出现升级错误,MySQL 提示: Table 'cdb_lovewall' already exists ,请返回。是数据表已经存在,必须先删除cdb_lovewall表。再升级下面就可以了!
CREATE TABLE cdb_lovewall (
id bigint(20) NOT NULL auto_increment,
lovesay tinytext NOT NULL,
uid int(11) NOT NULL default '0',
uname varchar(16) NOT NULL default '',
backcolor varchar(6) NOT NULL default '',
postop smallint(3) NOT NULL default '0',
posleft smallint(3) NOT NULL default '0',
lovetime bigint(20) NOT NULL default '0',
nickname varchar(10) NOT NULL default '',
mysign varchar(8) NOT NULL default '',
moodid tinyint(3) unsigned NOT NULL default '0',
colorid tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (id),
KEY id (id),
KEY uid (uid),
KEY lovetime (lovetime)
) TYPE=MyISAM DEFAULT CHARSET=gbk; |