01
CREATE TABLE IF NOT EXISTS `guestbook` (
02
`id` int(11) NOT NULL auto_increment,
03
`user_ip` int(10) unsigned NOT NULL,
04
`user_email` varchar(50) NOT NULL,
05
`addtime` int(11) NOT NULL,
06
`name` varchar(15) NOT NULL,
07
`text` text NOT NULL,
08
`admin_text` text NOT NULL,
09
`image` varchar(40) NOT NULL,
10
`sex` tinyint(1) NOT NULL default '1',
11
PRIMARY KEY (`id`)
12
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;