<?php
// $Id: guestbook.install,v 1.1.4.5 2008/08/13 22:22:05 sun Exp $

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

    case 'pgsql':
      $query = db_query("CREATE TABLE {guestbook} (
          id serial,
          recipient integer NOT NULL default '0',
          author integer NOT NULL default '0',
          anonname varchar(64) default NULL,
          anonemail varchar(128) default NULL,
          anonwebsite varchar(128) default NULL,
          message text,
          commentauthor integer default NULL,
          comment text,
          created integer NOT NULL default '0',
          PRIMARY KEY (id)
        ); 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_%%'");
}

function guestbook_update_1() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql('ALTER TABLE {guestbook} ADD COLUMN anonemail varchar(128)');
      $ret[] = update_sql('ALTER TABLE {guestbook} ADD COLUMN anonwebsite varchar(128)');
      $ret[] = update_sql('ALTER TABLE {guestbook} ADD COLUMN commentauthor int(10) unsigned');
      $ret[] = update_sql('ALTER TABLE {guestbook} MODIFY COLUMN anonname varchar(64)');

      $query = db_query("SELECT max(id) as id FROM {guestbook}");
      $row = db_fetch_object($query);

      $ret[] = update_sql("INSERT INTO {sequences} SET name = 'guestbook_id', id = '$row->id'");
      break;
    case 'pgsql':
      break;
  }
  return $ret;
}

function guestbook_update_2() {
  return _system_update_utf8(array('guestbook'));
}

function guestbook_update_3() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
    case 'pgsql':
      $ret[] = update_sql('CREATE INDEX guestbook_author ON {guestbook}(author)');
      $ret[] = update_sql('CREATE INDEX guestbook_commentauthor ON {guestbook}(commentauthor)');
      $ret[] = update_sql('CREATE INDEX guestbook_created ON {guestbook}(created)');
      break;
  }
  return $ret;
}