这个是什么原因: Invalid default value for 'mtime' create table `cpg0729_pictures`( `pid` int(11) NOT NULL auto_increment, `aid` int(11) NOT NULL, `filepath` varchar(255) NOT NULL, `filename` varchar(255) NOT NULL, `filesize` int(11) NOT NULL, `total_filesize` int(11) NOT NULL, `pwidth` smallint(6) NOT NULL, `pheight` smallint(6) NOT NULL, `hits` int(10) NOT NULL, `mtime` timestamp DEFAULT 'CURRENT_TIMESTAMP', `ctime` int(11) NOT NULL, `owner_id` int(11) NOT NULL, `owner_name` varchar(40) NOT NULL, `pic_rating` int(11) NOT NULL, `votes` int(11) NOT NULL, `title` varchar(255) NOT NULL, `caption` text NOT NULL, `keywords` varchar(255) NOT NULL, `approved` enum('YES','NO') DEFAULT 'NO' NOT NULL, `user1` varchar(255) NOT NULL, `user2` varchar(255) NOT NULL, `user3` varchar(255) NOT NULL, `user4` varchar(255) NOT NULL, `url_prefix` tinyint(4) NOT NULL, `randpos` int(11) NOT NULL, `pic_raw_ip` tinytext, `pic_hdr_ip` tinytext, PRIMARY KEY (pid), KEY pic_hits (hits), KEY pic_rate (pic_rating), KEY aid_approved (aid,approved), KEY randpos (randpos), KEY pic_aid (aid), FULLTEXT KEY search (title,caption,keywords,filename)) Type=MyISAM COMMENT='';
|