ALTER TABLE `cdb_posts` ADD `flower` INT(10) DEFAULT '0' NOT NULL;
ALTER TABLE `cdb_posts` ADD `egg` INT(10) DEFAULT '0' 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;
升级数据库2:
CREATE TABLE `cdb_felog` (
`id` mediumint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
`fromuser` varchar( 15 ) NOT NULL default '',
`touser` varchar( 15 ) NOT NULL default '',
`asfe` varchar( 8 ) NOT NULL default '',
`score` int( 10 ) NOT NULL default '0',
`tid` varchar( 15 ) NOT NULL default '',
`aswhat` varchar( 100 ) NOT NULL default '',
PRIMARY KEY ( `id` )
) TYPE = MYISAM;