后台-->升级数据库---->导入:
- DROP TABLE IF EXISTS `cdb_dsoft`;
- CREATE TABLE `cdb_dsoft` (
- `id` mediumint(15) unsigned NOT NULL auto_increment,
- `name` varchar(50) NOT NULL default '',
- `sort` char(10) NOT NULL default '',
- `lang` varchar(16) NOT NULL default '',
- `edition` varchar(16) NOT NULL default '',
- `size` varchar(10) NOT NULL default '',
- `picture` varchar(120) NOT NULL default '',
- `star` int(1) NOT NULL default '0',
- `putdate` varchar(24) NOT NULL default '',
- `auddate` varchar(24) NOT NULL default '',
- `roof` varchar(50) NOT NULL default '',
- `groom` char(1) NOT NULL default '',
- `degree` int(8) NOT NULL default '0',
- `downcount` int(8) NOT NULL default '0',
- `needcredit` int(6) NOT NULL default '0',
- `payment` int(5) NOT NULL default '0',
- `putname` varchar(15) NOT NULL default '',
- `brief` mediumtext NOT NULL,
- `assessor` varchar(15) NOT NULL default '',
- `audit` char(1) NOT NULL default '',
- `addoneshow` VARCHAR( 12 ) NOT NULL default '',
- `addone` varchar(120) NOT NULL default '',
- `addtwoshow` VARCHAR( 12 ) NOT NULL default '',
- `addtwo` varchar(120) NOT NULL default '',
- `addthrshow` VARCHAR( 12 ) NOT NULL default '',
- `addthr` varchar(120) NOT NULL default '',
- `addfoushow` VARCHAR( 12 ) NOT NULL default '',
- `addfou` varchar(120) NOT NULL default '',
- `addfivshow` VARCHAR( 12 ) NOT NULL default '',
- `addfiv` varchar(120) NOT NULL default '',
- `rate` int( 10 ) DEFAULT '0' NOT NULL ,
- `groomdate` INT( 20 ) DEFAULT '0' NOT NULL,
- `softhold` VARCHAR( 30 ) DEFAULT '不详' NOT NULL ,
- `softurl` VARCHAR( 120 ) DEFAULT '###' NOT NULL ,
- `getuser` mediumtext NOT NULL,
- `getguest` int(5) NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) TYPE=MyISAM
复制代码 |