DZ论坛礼品兑换插件for 7.2免费下载
安装方法：后台 - 工具 - 数据库 - 升级 将下面的代码复制到那个框里，然后提交。注意，这里默认用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: http://www.discuz.com
# 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;
页:
[1]