升级数据库:
- ALTER TABLE `cdb_dsoft` CHANGE `sort` `sort` CHAR( 10 ) NOT NULL;
复制代码
- ALTER TABLE `cdb_dsort` ADD `sup` INT( 10 ) DEFAULT '0' NOT NULL AFTER `id` ;
复制代码
- ALTER TABLE `cdb_dsoft`
- ADD `addoneshow` VARCHAR( 12 ) NOT NULL AFTER `audit` ,
- ADD `addtwoshow` VARCHAR( 12 ) NOT NULL AFTER `addone` ,
- ADD `addthrshow` VARCHAR( 12 ) NOT NULL AFTER `addtwo` ,
- ADD `addfoushow` VARCHAR( 12 ) NOT NULL AFTER `addthr` ,
- ADD `addfou` VARCHAR( 120 ) NOT NULL AFTER `addfoushow` ,
- ADD `addfivshow` VARCHAR( 12 ) DEFAULT '本站下载' AFTER `addfou` ,
- ADD `addfiv` VARCHAR( 120 ) NOT NULL AFTER `addfivshow` ,
- ADD `rate` int( 10 ) DEFAULT '0' NOT NULL ,
- ADD `groomdate` INT( 20 ) DEFAULT '0' NOT NULL AFTER `groom` ,
- ADD `softhold` VARCHAR( 30 ) DEFAULT '不详' NOT NULL ,
- ADD `softurl` VARCHAR( 120 ) DEFAULT '###' NOT NULL ;
复制代码
- CREATE TABLE `cdb_dlog` (
- `id` mediumint(20) unsigned NOT NULL auto_increment,
- `sort` varchar(1) NOT NULL default '',
- `name` varchar(15) NOT NULL default '0',
- `softid` varchar(15) NOT NULL default '0',
- `score` int(10) NOT NULL default '0',
- `aswhat` varchar(100) NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) TYPE=MyISAM
复制代码 |