DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`logid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`field` varchar(15) NOT NULL,
`value` int(10) unsigned NOT NULL DEFAULT '0',
`module` varchar(15) NOT NULL,
`file` varchar(20) NOT NULL,
`action` varchar(20) NOT NULL,
`querystring` varchar(255) NOT NULL,
`data` mediumtext NOT NULL,
`userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`username` varchar(20) NOT NULL,
`ip` varchar(15) NOT NULL,
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',//把0000-00-00 00:00:00改为1999-10-10 00:00:00后错误消失`
endtime` date NOT NULL DEFAULT 'picScrolltop',//把picScrolltop改为1999-10-10 00:00:00后错误消失
PRIMARY KEY (`logid`),
KEY `module` (`module`,`file`,`action`),
KEY `username` (`username`,`action`)
) ENGINE=MyISAM AUTO_INCREMENT=67851 DEFAULT CHARSET=utf8;
`isurl` enum('1','0') NOT NULL DEFAULT '0',
建表语句枚举类型默认值为0 转储的SQL语句其值为‘ ’把空值替换为0值后错误排除