uuid.install in Universally Unique IDentifier 5

File

uuid.install

<?php

/**
 * Implementation of hook_install().
 */
function uuid_install() {
  $tables = array(
    'node' => 'nid',
    'users' => 'uid',
    'node_revisions' => 'vid',
  );
  foreach ($tables as $table => $key) {

    // Create tables.
    db_query(uuid_table_schema($table, $key));

    // Build UUIDs.
    db_query('INSERT INTO {uuid_' . $table . '} SELECT ' . $key . ', UUID() FROM {' . $table . '}');
  }
}

/**
 * Remove duplicated user UUIDs and change uuid field to index instead of a primary key.
 */
function uuid_update_1() {
  $ret = array();

  // Move the non duplicates into a temporary table.
  $ret[] = update_sql('CREATE TABLE {uuid_users_temp} AS SELECT * FROM {uuid_users} GROUP BY uid');

  // Delete the old table.
  $ret[] = update_sql('DROP TABLE {uuid_users}');

  // Rename the new_table to the name of the old_table.
  $ret[] = update_sql('RENAME TABLE {uuid_users_temp} TO {uuid_users}');

  // Add key and index to new table.
  $ret[] = update_sql('ALTER TABLE {uuid_users} ADD PRIMARY KEY(uid), ADD INDEX {uuid_users}_uuid_idx(uuid)');

  // Recreate primary key and add index to uuid_node table.
  $ret[] = update_sql('ALTER TABLE {uuid_node} DROP PRIMARY KEY, ADD PRIMARY KEY(nid), ADD INDEX {uuid_node}_uuid_idx(uuid)');
  return $ret;
}
function uuid_update_2() {

  // Create uuid_node_revisions table.
  db_query(uuid_table_schema('node_revisions', 'vid'));

  // Populate uuid_node_revisions table.
  db_query('INSERT INTO {uuid_node_revisions} SELECT vid, UUID() FROM {node_revisions}');
  return array();
}

/**
 * Return schema for a uuid table.
 * 
 * @param $table
 *   Table name.
 * @param $key
 *   Name of key field, e.g. nid for nodes.
 * @return
 *   Array with table structure definition (schema).
 */
function uuid_table_schema($table, $key = 'key') {
  return "CREATE TABLE {uuid_" . $table . "} (\n    " . $key . " int(10) unsigned NOT NULL default '0',\n    uuid char(36) NOT NULL default '',\n    PRIMARY KEY  (" . $key . "),\n    KEY {uuid_" . $table . "}_uuid_idx(uuid)\n  ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;";
}

/**
 * Implementation of hook_uninstall().
 */
function uuid_uninstall() {
  foreach (array(
    'node',
    'users',
    'node_revisions',
  ) as $table) {
    db_query('DROP TABLE {uuid_' . $table . '}');
  }
}

Functions

Name	Description
uuid_install	Implementation of hook_install().
uuid_table_schema	Return schema for a uuid table.
uuid_uninstall	Implementation of hook_uninstall().
uuid_update_1	Remove duplicated user UUIDs and change uuid field to index instead of a primary key.
uuid_update_2