Drupal add timestamp to Taxonomy term data

I had another request to alter the default taxonomy_term_data table and adding the timestamps; created and changed just like in the node database table.

Here's a little snippet that will do the trick.

You need to create a custom module for this to work. Remember to replace YOUR_MODULE with your custom module name.

YOUR_MODULE.install

<?php/** * Implements hook_schema_alter(). */ function YOUR_MODULE_schema_alter(&$schema) {   $schema['taxonomy_term_data']['fields']['created'] = array(     'description' => 'Unix timestamp when the Taxonomy term was created.',     'type' => 'int',     'not null' => TRUE,     'default' => 0,   );   $schema['taxonomy_term_data']['fields']['changed'] = array(     'description' => 'Unix timestamp when the Taxonomy term was last modified.',     'type' => 'int',     'not null' => TRUE,     'default' => 0,   ); }/** * Implements hook_install(). */ function YOUR_MODULE_install() {   $schema = array();   YOUR_MODULE_schema_alter($schema);   // Altering the {taxonomy_term_data} table.   db_add_field('taxonomy_term_data', 'created', $schema['taxonomy_term_data']['fields']['created']);   db_add_field('taxonomy_term_data', 'changed', $schema['taxonomy_term_data']['fields']['changed']); }/** * Implements hook_uninstall(). */ function YOUR_MODULE_uninstall() {   // Delete the additional columns from the {taxonomy_term_data} table.   db_drop_field('taxonomy_term_data', 'created');   db_drop_field('taxonomy_term_data', 'changed'); }

YOUR_MODULE.module

<?php/** * @file * Alter the Taxonomy table to add timestamps. *//** * Implements hook_taxonomy_term_insert(). */ function YOUR_MODULE_taxonomy_term_insert($term) {   $term->created = REQUEST_TIME;   $term->changed = REQUEST_TIME;   drupal_write_record('taxonomy_term_data', $term, array('tid')); }/** * Implements hook_taxonomy_term_update(). */ function YOUR_MODULE_taxonomy_term_update($term) {   $term->changed = REQUEST_TIME;   drupal_write_record('taxonomy_term_data', $term, array('tid')); }

For your convenience, I've provided this little custom module for download, see attachment below. Enjoy coding with Drupal !

Attachment: taxonomy_timestamp-7.x-dev.zipTags: drupal drupal 7 taxonomy term timestamp schema

Original Article:

Drupal add timestamp to Taxonomy term data