View file sql.txt

CREATE TABLE `guest` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`quot` varchar(200) NOT NULL default '',
`mess` varchar(200) NOT NULL default '',
`url` varchar(50) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`agent` varchar(100) NOT NULL default '',
`ip` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `bans` (
`id` int(10) unsigned NOT NULL auto_increment,
`ip` varchar(50) NOT NULL default '',
`ua` varchar(100) NOT NULL default '',
  PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `mails` (
`id` int(10) unsigned NOT NULL auto_increment,
`to` varchar(50) NOT NULL default '',
`theme` varchar(50) NOT NULL default '',
`msg` varchar(1000) NOT NULL default '',
`from` varchar(50) NOT NULL default '',
 PRIMARY KEY (`id`)
) TYPE=MyISAM;