基本升级代码,适用2.0,2.2F
- ALTER TABLE `cdb_members` ADD `money` INT(10) DEFAULT '0' NOT NULL, ADD `bank` INT(10) DEFAULT '0' NOT NULL, ADD `savemt` INT(10) DEFAULT '0' NOT NULL;
- ALTER TABLE `cdb_sessions` ADD `invisible` TINYINT( 1 ) DEFAULT '0' NOT NULL;
- ALTER TABLE `cdb_members` ADD `secques` VARCHAR(8) NOT NULL ;
- ALTER TABLE `cdb_members` ADD `verify` TINYINT( 1 ) DEFAULT '1' NOT NULL ;
- ALTER TABLE `cdb_forums` ADD `replyperm` TINYTEXT NOT NULL AFTER `postperm` ;
- ALTER TABLE `cdb_threads` ADD `highlight` tinyint(1) default '0' NOT NULL ;
- ALTER TABLE `cdb_forums` ADD `postofcredit` VARCHAR( 25 ) DEFAULT '1,1,1' NOT NULL ;
- ALTER TABLE `cdb_forums` ADD `postosetthread` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
- ALTER TABLE `cdb_forums` ADD `postosetreply` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
- ALTER TABLE `cdb_forums` ADD `postosetdel` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
- ALTER TABLE `cdb_attachments` ADD `dl_users` TEXT NOT NULL ;
- ALTER TABLE `cdb_threads` ADD `flower` INT(10) DEFAULT '0' NOT NULL;
- ALTER TABLE `cdb_threads` ADD `egg` INT(10) DEFAULT '0' NOT NULL;
- ALTER TABLE `cdb_members` ADD `lastposttime` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ;
- ALTER TABLE `cdb_forums` ADD `rule` text NOT NULL;
- ALTER TABLE `cdb_members` ADD `signature2` TEXT NOT NULL AFTER `signature` ,
- ADD `signature3` TEXT NOT NULL AFTER `signature2` ;
- ALTER TABLE `cdb_karmalog` CHANGE `score` `score` TINYINT( 3 ) DEFAULT '0' NOT NULL ;
- ALTER TABLE `cdb_members` ADD `logintime` INT( 10 ) DEFAULT '0' NOT NULL ;
- ALTER TABLE `cdb_members` ADD `periodoftime` INT( 10 ) DEFAULT '0' NOT NULL ;
- ALTER TABLE `cdb_threads` ADD `topendtime` int(10) DEFAULT '0' NOT NULL;
- ALTER TABLE `cdb_members` ADD `getmoneytime` INT(11) DEFAULT '0' NOT NULL;
- ALTER TABLE `cdb_members` ADD `khtime` INT(11) DEFAULT '0' NOT NULL;
- ALTER TABLE `cdb_members` ADD `glory` INT(10) DEFAULT '0' NOT NULL;
- ALTER TABLE `cdb_forums` ADD `gloryneeded` INT(10) DEFAULT '0' NOT NULL;
- ALTER TABLE `cdb_threads` ADD `glorysrequire` smallint(6) unsigned NOT NULL default '0' AFTER creditsrequire;
- ALTER TABLE `cdb_usergroups` ADD `allowsetviewgloryperm` tinyint(1) NOT NULL default '0' AFTER allowsetviewperm;
- ALTER TABLE `cdb_memo` CHANGE `type` `type` ENUM( 'address', 'notebook', 'collections','wish' ) DEFAULT 'address' NOT NULL;
- ALTER TABLE `cdb_settings` ADD `maxusertoday` SMALLINT( 6 ) UNSIGNED DEFAULT '50' NOT NULL AFTER `regstatus` ;
- ALTER TABLE `cdb_members` ADD `medals` VARCHAR( 50 ) NOT NULL ;
- ALTER TABLE `cdb_members` ADD `useimages` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
- ALTER TABLE `cdb_members` add `hw` varchar(15) NULL;
- ALTER TABLE `cdb_threads` ADD `cate` VARCHAR( 2 ) DEFAULT '0' NOT NULL AFTER `fid` ;
- ALTER TABLE `cdb_forums` ADD `cates` VARCHAR( 150 ) DEFAULT '_所有分类' NOT NULL AFTER `name` ;
复制代码 |