View file guestbook/guestbook.sql

CREATE TABLE `guestbook` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(128) NOT NULL default '',
  `email` varchar(128) NOT NULL default '',
  `rate` enum('0','1','2','3','4','5') NOT NULL default '3',
  `comments` text NOT NULL,
  `show_email` enum('1','0') NOT NULL default '1',
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `url` text NOT NULL,
  `show_url` enum('0','1','2') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;