<?php
// $Id$

/**
 * Implementation of hook_install()
 */
function signature_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {users_signature} (
        uid int unsigned NOT NULL default '0',
        signature MEDIUMTEXT default NULL,
        PRIMARY KEY (uid)
        ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      db_query("INSERT INTO {users_signature} (uid, signature)
        SELECT uid, signature
        FROM {users}
        WHERE signature<>''");
      db_query("UPDATE {users} SET signature=NULL");
      break;
  }
}

/**
 * Implementation of hook_uninstall()
 */
function signature_uninstall() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("UPDATE {users}, {users_signature}
        SET {users}.signature={users_signature}.signature
        WHERE {users}.uid={users_signature}.uid");
      db_query("DROP TABLE {users_signature}");
      db_query("DELETE FROM {variable} WHERE name LIKE 'signature\_%'");
      break;
  }
}

/**
 * Implementation of hook_update()
 */
function signature_update_1() {
  $items = array();
  $items[] = update_sql("CREATE TABLE {users_signature} (
    uid int unsigned NOT NULL default '0',
    signature MEDIUMTEXT default '',
    PRIMARY KEY (uid)
    ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
  $items[] = update_sql("INSERT INTO {users_signature} (uid, signature)
    SELECT uid, signature
    FROM {users}
    WHERE signature<>''");
    // For some reason IS NOT NULL didn't work in this case
  $items[] = update_sql("UPDATE {users} SET signature=NULL");
  return $items;
}