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 ;