我在安装“礼品店”插件,不知道在哪里运行啊? SQL语句如下:- 2.运行下列SQL语句:(请选择适合自己MySQL版本的sql语句,并自行修改表前缀)
- MySQL版本>=4.1,请执行下列SQL语句升级数据库:
- ALTER TABLE `cdb_members` ADD `flowers` int(10) UNSIGNED NOT NULL default '0';
- 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;
- 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;
- 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版本<=4.0,请执行下列SQL语句升级数据库:
- ALTER TABLE `cdb_members` ADD `flowers` int(10) UNSIGNED NOT NULL default '0';
- 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`)
- ) TYPE=MyISAM;
- 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`)
- ) TYPE=MyISAM;
- 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`)
- ) TYPE=MyISAM;
复制代码 |