guestbook.install in Guestbook 5.2

File

guestbook.install

<?php

/**
 * Implementation of hook_install().
 */
function guestbook_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $query = db_query("CREATE TABLE IF NOT EXISTS {guestbook} (\n          id int(10) unsigned NOT NULL default '0',\n          recipient int(10) unsigned NOT NULL default '0',\n          author int(10) unsigned NOT NULL default '0',\n          anonname varchar(64) default NULL,\n          anonemail varchar(128) default NULL,\n          anonwebsite varchar(128) default NULL,\n          message text,\n          commentauthor int(10) unsigned default NULL,\n          comment text,\n          created int(11) unsigned NOT NULL default '0',\n          PRIMARY KEY (id),\n          KEY recipient (recipient)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'pgsql':
      $query = db_query("CREATE TABLE {guestbook} (\n          id serial,\n          recipient integer NOT NULL default '0',\n          author integer NOT NULL default '0',\n          anonname varchar(64) default NULL,\n          anonemail varchar(128) default NULL,\n          anonwebsite varchar(128) default NULL,\n          message text,\n          commentauthor integer default NULL,\n          comment text,\n          created integer NOT NULL default '0',\n          PRIMARY KEY (id)\n        ); CREATE INDEX {guestbook}_recipient_idx ON {guestbook}(recipient);");
      break;
  }
}

/**
 * Implementation of hook_uninstall().
 */
function guestbook_uninstall() {
  db_query('DROP TABLE {guestbook}');
  db_query("DELETE FROM {variable} WHERE name LIKE 'guestbook_%%'");
}

/**
 * Rename permission "administer all guestbooks" to "moderate all guestbooks".
 */
function guestbook_update_5200() {
  $ret = array();
  $result = db_query("SELECT rid, perm FROM {permission} ORDER BY rid");
  while ($role = db_fetch_object($result)) {
    $renamed_permission = strtr($role->perm, array(
      'administer all guestbooks' => 'moderate all guestbooks',
    ));
    if ($renamed_permission != $role->perm) {
      $ret[] = update_sql("UPDATE {permission} SET perm = '{$renamed_permission}' WHERE rid = " . $role->rid);
    }
  }
  return $ret;
}

Functions

Name	Description
guestbook_install	Implementation of hook_install().
guestbook_uninstall	Implementation of hook_uninstall().
guestbook_update_5200	Rename permission "administer all guestbooks" to "moderate all guestbooks".