后台 系统工具 数据库升级以下语句,升级该语句前最好先做好数据备份:
CREATE TABLE cdb_advertisements (
advid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
available tinyint(1) NOT NULL DEFAULT '0',
`type` varchar(50) NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
title varchar(50) NOT NULL DEFAULT '',
targets text NOT NULL,
parameters text NOT NULL,
`code` text NOT NULL,
starttime int(10) unsigned NOT NULL DEFAULT '0',
endtime int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (advid)
) TYPE=MyISAM; |