--MySql版本在4.1及以上
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;
例子:
--MySql版本在4.1及以上
DROP TABLE IF EXISTS `hp_guestbook_demo`;
CREATE TABLE `hp_guestbook_demo` (
`postid` int(4) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`url` varchar(50) NOT NULL default '',
`content` varchar(255) NOT NULL default '',
`posttime` datetime NOT NULL default '0000-00-00 00:00:00',
`replytime` datetime NOT NULL default '0000-00-00 00:00:00',
`replycontent` varchar(255) NOT NULL default '',
`ip` varchar(50) NOT NULL default '',
UNIQUE KEY `id` (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;
--MySql版本在4.0及以下
DROP TABLE IF EXISTS `hp_guestbook_demo`;
CREATE TABLE `hp_guestbook_demo` (
`postid` int(4) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`url` varchar(50) NOT NULL default '',
`content` varchar(255) NOT NULL default '',
`posttime` datetime NOT NULL default '0000-00-00 00:00:00',
`replytime` datetime NOT NULL default '0000-00-00 00:00:00',
`replycontent` varchar(255) NOT NULL default '',
`ip` varchar(50) NOT NULL default '',
UNIQUE KEY `id` (`postid`)
) ENGINE=MyISAM AUTO_INCREMENT=0;