|
安装方法:后台 - 工具 - 数据库 - 升级 将下面的代码复制到那个框里,然后提交。注意,这里默认用cdb_ 请自行修改成自己的。- # Identify: MTIzNjgyNTU1Niw3LjAuMCxjdXN0b20sbXVsdGl2b2wsMQ==
- # <?exit();?>
- # Discuz! Multi-Volume Data Dump Vol.1
- # Version: Discuz! 7.0.0
- # Time: 2009-3-12 10:39
- # Type: custom
- # Table Prefix: cdb_
- #
- # Discuz! Home: [url]http://www.discuz.com[/url]
- # Please visit our website for newest infomation about Discuz!
- # --------------------------------------------------------
- DROP TABLE IF EXISTS cdb_giftlog;
- CREATE TABLE cdb_giftlog (
- id int(11) NOT NULL auto_increment,
- uid int(11) NOT NULL,
- username varchar(50) NOT NULL,
- gid int(11) NOT NULL,
- checked int(11) NOT NULL,
- trades int(11) NOT NULL,
- totalprice int(11) NOT NULL,
- realname varchar(50) NOT NULL,
- address varchar(250) NOT NULL,
- postalcode int(6) NOT NULL,
- remark text NOT NULL,
- phone varchar(15) NOT NULL,
- QQ int(11) unsigned NOT NULL,
- tradetime int(11) NOT NULL,
- checktime int(11) NOT NULL,
- PRIMARY KEY (id),
- KEY uid (uid,gid)
- ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=gbk AUTO_INCREMENT=18;
- DROP TABLE IF EXISTS cdb_gifts;
- CREATE TABLE cdb_gifts (
- gid int(11) NOT NULL auto_increment,
- `name` varchar(50) NOT NULL,
- price int(11) NOT NULL,
- unit tinytext NOT NULL,
- `type` tinyint(3) NOT NULL,
- onlinetime tinyint(3) NOT NULL,
- intro tinytext NOT NULL,
- num int(11) NOT NULL,
- maxnum tinyint(3) NOT NULL,
- trades int(11) NOT NULL,
- linestart int(11) NOT NULL,
- lineoff int(11) NOT NULL,
- sponsor varchar(100) NOT NULL,
- spoweb varchar(250) NOT NULL,
- istop tinyint(2) NOT NULL,
- PRIMARY KEY (gid)
- ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=gbk AUTO_INCREMENT=7;
- DROP TABLE IF EXISTS cdb_gifttype;
- CREATE TABLE cdb_gifttype (
- id int(6) unsigned NOT NULL auto_increment,
- gid int(6) unsigned NOT NULL,
- `name` varchar(20) character set gbk NOT NULL,
- PRIMARY KEY (id),
- KEY gid (gid)
- ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1;
- DROP TABLE IF EXISTS cdb_gifts;
- CREATE TABLE cdb_gifts (
- gid int(11) NOT NULL auto_increment,
- `name` varchar(50) NOT NULL,
- price int(11) NOT NULL,
- unit tinytext NOT NULL,
- `type` tinyint(3) NOT NULL,
- onlinetime tinyint(3) NOT NULL,
- intro tinytext NOT NULL,
- num int(11) NOT NULL,
- maxnum tinyint(3) NOT NULL,
- trades int(11) NOT NULL,
- linestart int(11) NOT NULL,
- lineoff int(11) NOT NULL,
- sponsor varchar(100) NOT NULL,
- spoweb varchar(250) NOT NULL,
- istop tinyint(2) NOT NULL,
- PRIMARY KEY (gid)
- ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=gbk AUTO_INCREMENT=7;
- DROP TABLE IF EXISTS cdb_giftlog;
- CREATE TABLE cdb_giftlog (
- id int(11) NOT NULL auto_increment,
- uid int(11) NOT NULL,
- username varchar(50) NOT NULL,
- gid int(11) NOT NULL,
- checked int(11) NOT NULL,
- trades int(11) NOT NULL,
- totalprice int(11) NOT NULL,
- realname varchar(50) NOT NULL,
- address varchar(250) NOT NULL,
- postalcode int(6) NOT NULL,
- remark text NOT NULL,
- phone varchar(15) NOT NULL,
- QQ int(11) unsigned NOT NULL,
- tradetime int(11) NOT NULL,
- checktime int(11) NOT NULL,
- PRIMARY KEY (id),
- KEY uid (uid,gid)
- ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=gbk AUTO_INCREMENT=18;
- DROP TABLE IF EXISTS cdb_gifttype;
- CREATE TABLE cdb_gifttype (
- id int(6) unsigned NOT NULL auto_increment,
- gid int(6) unsigned NOT NULL,
- `name` varchar(20) character set gbk NOT NULL,
- PRIMARY KEY (id),
- KEY gid (gid)
- ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1;
复制代码
礼品兑换7.2.rar
(28.26 KB, 下载次数: 40)
|
|