安装花店出现的问题:
ALTER TABLE `cdb_members` ADD `flowers` int(10) UNSIGNED NOT NULL default '0';
升级错误,MySQL 提示: Duplicate column name 'flowers' ,请返回。
CREATE TABLE `cdb_flowers` (
`flowerid` int(10) unsigned NOT NULL auto_increment,
`claid` int(10) unsigned NOT NULL default '0',
`flowername` varchar(15) NOT NULL default '',
`flowerurl` varchar(100) NOT NULL default '',
`flowermean` mediumtext NOT NULL,
`flowerprice` smallint(6) unsigned NOT NULL default '0',
`flowernum` smallint(6) unsigned NOT NULL default '0',
`description` mediumtext NOT NULL,
`datelinein` int(10) unsigned NOT NULL default '0',
`flowerdays` smallint(6) unsigned NOT NULL default '1',
`flowershow` tinyint(1) NOT NULL default '0',
`flowerthumb` tinyint(1) NOT NULL default '0',
`displayorder` tinyint(1) NOT NULL default '0',
`totalsell` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`flowerid`),
KEY `datelinein` (`datelinein`),
KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
升级错误,MySQL 提示: Table 'cdb_flowers' already exists ,请返回。
CREATE TABLE `cdb_flowerlog` (
`logid` int(10) unsigned NOT NULL auto_increment,
`uid` int(10) unsigned NOT NULL,
`username` char(15) NOT NULL,
`flowerid` int(10) unsigned NOT NULL,
`flowerurl` char(100) NOT NULL default '',
`fromuid` int(10) unsigned NOT NULL,
`fromusername` char(15) NOT NULL,
`flowername` char(15) NOT NULL default '',
`datelinefrom` int(10) unsigned NOT NULL,
`datelineto` int(10) unsigned NOT NULL,
`message` text NOT NULL,
PRIMARY KEY (`logid`),
KEY `uid` (`uid`),
KEY `datelinefrom` (`datelinefrom`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
升级错误,MySQL 提示: Table 'cdb_flowerlog' already exists ,请返回。
CREATE TABLE `cdb_flowercla` (
`claid` int(10) unsigned NOT NULL auto_increment,
`parentid` int(10) unsigned NOT NULL default '0',
`claname` char(30) NOT NULL default '',
`displayorder` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`claid`),
KEY `parentid` (`parentid`),
KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
升级错误,MySQL 提示: Table 'cdb_flowercla' already exists ,请返回。
新增字段的数据表:
flowers int(10) unsigned NOT NULL
论坛程序版本 Discuz! 6.0.0 Release 20070904
操作系统及 PHP WINNT / PHP v5.2.1
MySQL 版本 5.2.0-falcon-alpha-community-nt
注:贴间不显示鲜花(我用了贴间美化),请高手前来回答,苹果再此谢谢了!!
[ 本帖最后由 应山红苹果 于 2007-12-19 12:47 编辑 ]