function guestbook_install in Guestbook 5

Same name and namespace in other branches

1. 5.2 guestbook.install \guestbook_install()
2. 6.2 guestbook.install \guestbook_install()
3. 6 guestbook.install \guestbook_install()

Implementation of hook_install().

File

./guestbook.install, line 6

Code

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;
  }
}