请问Discuz2.5SP1与Discuz2.5的数据结构有哪些变化？

wenshuang · 发表于 2005-10-1 12:47:59

RT，希望版主/高手能够解答
目前发现好像members表有些变化。。。

jimmyjimmyqqq · 发表于 2005-10-1 12:49:03

我不知道..幫你頂！

wenshuang · 发表于 2005-10-1 20:03:49

有没有人知道这？

5025488.net · 发表于 2005-10-1 20:53:32

2.5

DROP TABLE IF EXISTS cdb_access;
CREATE TABLE cdb_access (
uid mediumint(8) unsigned NOT NULL default '0',
fid smallint(6) unsigned NOT NULL default '0',
allowview tinyint(1) NOT NULL default '0',
allowpost tinyint(1) NOT NULL default '0',
allowreply tinyint(1) NOT NULL default '0',
allowgetattach tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid,fid)
);
DROP TABLE IF EXISTS cdb_admingroups;
CREATE TABLE cdb_admingroups (
admingid smallint(3) unsigned NOT NULL auto_increment,
admintitle char(30) NOT NULL default '',
adminglobal tinyint(1) NOT NULL default '0',
alloweditpost tinyint(1) NOT NULL default '0',
alloweditpoll tinyint(1) NOT NULL default '0',
allowdelpost tinyint(1) NOT NULL default '0',
allowmassprune tinyint(1) NOT NULL default '0',
allowcensorword tinyint(1) NOT NULL default '0',
allowviewip tinyint(1) NOT NULL default '0',
allowbanip tinyint(1) NOT NULL default '0',
allowedituser tinyint(1) NOT NULL default '0',
allowbanuser tinyint(1) NOT NULL default '0',
allowpostannounce tinyint(1) NOT NULL default '0',
allowviewlog tinyint(1) NOT NULL default '0',
allowhighlight tinyint(1) NOT NULL default '0',
allowdigest tinyint(1) NOT NULL default '0',
allowclose tinyint(1) NOT NULL default '0',
allowmove tinyint(1) NOT NULL default '0',
allowtop tinyint(1) NOT NULL default '0',
allowmerge tinyint(1) NOT NULL default '0',
allowsplit tinyint(1) NOT NULL default '0',
disablepostctrl tinyint(1) NOT NULL default '0',
PRIMARY KEY (admingid)
) ;
INSERT INTO cdb_admingroups VALUES (1, 'Administrator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO cdb_admingroups VALUES (2, 'SuperModerator', 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO cdb_admingroups VALUES (3, 'Moderator', 0, 1, 0, 1, 0, 0, 1, 0, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1);
DROP TABLE IF EXISTS cdb_adminsessions;
CREATE TABLE cdb_adminsessions (
uid mediumint(8) NOT NULL default '0',
ip char(20) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
errorlog tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid,ip,dateline)
);
DROP TABLE IF EXISTS cdb_announcements;
CREATE TABLE cdb_announcements (
id smallint(6) unsigned NOT NULL auto_increment,
author varchar(15) NOT NULL default '',
subject varchar(250) NOT NULL default '',
posturl varchar(250) NOT NULL default '',
displayorder tinyint(3) NOT NULL default '0',
starttime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',
message text NOT NULL,
PRIMARY KEY (id)
);
DROP TABLE IF EXISTS cdb_attachments;
CREATE TABLE cdb_attachments (
aid mediumint(8) unsigned NOT NULL auto_increment,
tid mediumint(8) unsigned NOT NULL default '0',
pid int(10) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
creditsrequire smallint(6) unsigned NOT NULL default '0',
filename char(100) NOT NULL default '',
filetype char(50) NOT NULL default '',
filesize int(10) unsigned NOT NULL default '0',
attachment char(100) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
downloads smallint(6) unsigned NOT NULL default '0',
PRIMARY KEY (aid),
KEY tid (tid),
KEY pid (pid),
KEY uid (uid)
);
DROP TABLE IF EXISTS cdb_attachtypes;
CREATE TABLE cdb_attachtypes (
id smallint(6) unsigned NOT NULL auto_increment,
extension char(6) NOT NULL default '',
maxsize int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id)
);
DROP TABLE IF EXISTS cdb_banned;
CREATE TABLE cdb_banned (
id smallint(6) unsigned NOT NULL auto_increment,
ip1 smallint(3) NOT NULL default '0',
ip2 smallint(3) NOT NULL default '0',
ip3 smallint(3) NOT NULL default '0',
ip4 smallint(3) NOT NULL default '0',
admin varchar(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
expiration int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id)
);
DROP TABLE IF EXISTS cdb_bbcodes;
CREATE TABLE cdb_bbcodes (
id mediumint(8) unsigned NOT NULL auto_increment,
available tinyint(1) NOT NULL default '0',
tag varchar(100) NOT NULL default '',
replacement text NOT NULL,
example varchar(255) NOT NULL default '',
explanation text NOT NULL,
params tinyint(1) unsigned NOT NULL default '1',
nest tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (id)
);
DROP TABLE IF EXISTS cdb_buddys;
CREATE TABLE cdb_buddys (
uid mediumint(8) unsigned NOT NULL default '0',
buddyid mediumint(8) unsigned NOT NULL default '0',
KEY uid (uid)
);
DROP TABLE IF EXISTS cdb_caches;
CREATE TABLE cdb_caches (
cid int(10) unsigned NOT NULL auto_increment,
ckey varchar(80) NOT NULL default '',
cval text NOT NULL,
dateline int(10) NOT NULL default '0',
extr varchar(80) NOT NULL default '',
PRIMARY KEY (cid),
KEY ckey (ckey)
);
DROP TABLE IF EXISTS cdb_failedlogins;
CREATE TABLE cdb_failedlogins (
ip char(15) NOT NULL default '',
count tinyint(1) unsigned NOT NULL default '0',
lastupdate int(10) unsigned NOT NULL default '0'
);
DROP TABLE IF EXISTS cdb_favorites;
CREATE TABLE cdb_favorites (
uid mediumint(8) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
KEY tid (tid)
);
DROP TABLE IF EXISTS cdb_forumlinks;
CREATE TABLE cdb_forumlinks (
id smallint(6) unsigned NOT NULL auto_increment,
displayorder tinyint(3) NOT NULL default '0',
name varchar(100) NOT NULL default '',
url varchar(200) NOT NULL default '',
note varchar(200) NOT NULL default '',
logo varchar(100) NOT NULL default '',
PRIMARY KEY (id)
);
INSERT INTO cdb_forumlinks VALUES (1, 0, 'Discuz! Board', 'http://www.discuz.com', 'Discuz! 官方网站，提供最新 Discuz! 软件下载、使用讨论与技术交流', 'images/logo.gif');
INSERT INTO cdb_forumlinks VALUES (2, 0, 'Free Discuz!', 'http://www.freediscuz.net', 'Free Discuz!，免费 Discuz! 插件与风格', 'http://www.freediscuz.net/bbs/images/logo4.gif');
DROP TABLE IF EXISTS cdb_forums;
CREATE TABLE cdb_forums (
fid smallint(6) unsigned NOT NULL auto_increment,
fup smallint(6) unsigned NOT NULL default '0',
type enum('group','forum','sub') NOT NULL default 'forum',
icon char(50) NOT NULL default '',
name char(50) NOT NULL default '',
description char(255) NOT NULL default '',
status tinyint(1) NOT NULL default '0',
displayorder tinyint(3) NOT NULL default '0',
moderator char(255) NOT NULL default '',
styleid smallint(6) unsigned NOT NULL default '0',
threads mediumint(8) unsigned NOT NULL default '0',
posts mediumint(8) unsigned NOT NULL default '0',
lastpost char(110) NOT NULL default '',
allowsmilies tinyint(1) NOT NULL default '0',
allowhtml tinyint(1) NOT NULL default '0',
allowbbcode tinyint(1) NOT NULL default '0',
allowimgcode tinyint(1) NOT NULL default '0',
postcredits tinyint(3) NOT NULL default '-1',
replycredits tinyint(3) NOT NULL default '-1',
password char(12) NOT NULL default '',
viewperm char(100) NOT NULL default '',
postperm char(100) NOT NULL default '',
replyperm char(100) NOT NULL default '',
getattachperm char(100) NOT NULL default '',
PRIMARY KEY (fid),
KEY forum (status,type,displayorder)
);
INSERT INTO cdb_forums VALUES (1, 0, 'forum', '', '默认论坛', '', 1, 0, '', 0, 0, 0, '', 1, 0, 1, 1, -1, -1, '', '', '', '', '');
DROP TABLE IF EXISTS cdb_karmalog;
CREATE TABLE cdb_karmalog (
kid int(10) NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
pid int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
score tinyint(3) NOT NULL default '0',
PRIMARY KEY (kid),
KEY pid (pid),
KEY dateline (dateline)
);
DROP TABLE IF EXISTS cdb_members;
CREATE TABLE cdb_members (
uid mediumint(8) unsigned NOT NULL auto_increment,
username varchar(15) NOT NULL default '',
password varchar(32) NOT NULL default '',
secques varchar(8) NOT NULL default '',
gender tinyint(1) NOT NULL default '0',
adminid smallint(3) NOT NULL default '0',
groupid smallint(6) unsigned NOT NULL default '0',
regip varchar(15) NOT NULL default '',
regdate int(10) unsigned NOT NULL default '0',
lastip varchar(15) NOT NULL default '',
lastvisit int(10) unsigned NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
postnum smallint(6) unsigned NOT NULL default '0',
credit int(10) NOT NULL default '0',
extracredit int(10) NOT NULL default '0',
email varchar(60) NOT NULL default '',
site varchar(75) NOT NULL default '',
icq varchar(12) NOT NULL default '',
oicq varchar(12) NOT NULL default '',
yahoo varchar(40) NOT NULL default '',
msn varchar(40) NOT NULL default '',
location varchar(30) NOT NULL default '',
bday date NOT NULL default '0000-00-00',
bio text NOT NULL,
avatar varchar(100) NOT NULL default '',
avatarwidth tinyint(3) unsigned NOT NULL default '0',
avatarheight tinyint(3) unsigned NOT NULL default '0',
signature text NOT NULL,
customstatus varchar(30) NOT NULL default '',
tpp tinyint(3) unsigned NOT NULL default '0',
ppp tinyint(3) unsigned NOT NULL default '0',
styleid smallint(6) unsigned NOT NULL default '0',
dateformat varchar(10) NOT NULL default '',
timeformat varchar(5) NOT NULL default '',
showemail tinyint(1) NOT NULL default '0',
newsletter tinyint(1) NOT NULL default '0',
invisible tinyint(1) NOT NULL default '0',
timeoffset char(3) NOT NULL default '',
ignorepm text NOT NULL,
newpm tinyint(1) NOT NULL default '0',
accessmasks tinyint(1) NOT NULL default '0',
identifying varchar(20) NOT NULL default '',
PRIMARY KEY (uid),
KEY username (username)
);
DROP TABLE IF EXISTS cdb_onlinelist;
CREATE TABLE cdb_onlinelist (
groupid smallint(6) unsigned NOT NULL default '0',
displayorder tinyint(3) NOT NULL default '0',
title varchar(30) NOT NULL default '',
url varchar(30) NOT NULL default ''
);
INSERT INTO cdb_onlinelist VALUES (1, 1, '管理员', 'online_admin.gif');
INSERT INTO cdb_onlinelist VALUES (2, 2, '超级版主', 'online_supermod.gif');
INSERT INTO cdb_onlinelist VALUES (3, 3, '版主', 'online_moderator.gif');
INSERT INTO cdb_onlinelist VALUES (0, 4, '注册用户', 'online_member.gif');
DROP TABLE IF EXISTS cdb_pms;
CREATE TABLE cdb_pms (
pmid int(10) unsigned NOT NULL auto_increment,
msgfrom varchar(15) NOT NULL default '',
msgfromid mediumint(8) unsigned NOT NULL default '0',
msgtoid mediumint(8) unsigned NOT NULL default '0',
folder enum('inbox','outbox') NOT NULL default 'inbox',
new tinyint(1) NOT NULL default '0',
subject varchar(75) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
message text NOT NULL,
PRIMARY KEY (pmid),
KEY msgtoid (msgtoid),
KEY msgfromid (msgfromid)
);
DROP TABLE IF EXISTS cdb_polls;
CREATE TABLE cdb_polls (
tid mediumint(8) unsigned NOT NULL default '0',
pollopts mediumtext NOT NULL,
PRIMARY KEY (tid)
);
DROP TABLE IF EXISTS cdb_posts;
CREATE TABLE cdb_posts (
pid int(10) unsigned NOT NULL auto_increment,
fid smallint(6) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
aid tinyint(1) NOT NULL default '0',
author varchar(15) NOT NULL default '',
authorid mediumint(8) unsigned NOT NULL default '0',
subject varchar(80) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
message mediumtext NOT NULL,
useip varchar(15) NOT NULL default '',
usesig tinyint(1) NOT NULL default '0',
bbcodeoff tinyint(1) NOT NULL default '0',
smileyoff tinyint(1) NOT NULL default '0',
parseurloff tinyint(1) NOT NULL default '0',
rate smallint(6) NOT NULL default '0',
ratetimes tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (pid),
KEY fid (fid),
KEY dateline (dateline),
KEY authorid (authorid),
KEY tid (tid,dateline)
);
DROP TABLE IF EXISTS cdb_ranks;
CREATE TABLE cdb_ranks (
rankid smallint(6) unsigned NOT NULL auto_increment,
ranktitle varchar(30) NOT NULL default '',
postshigher smallint(6) unsigned NOT NULL default '0',
stars tinyint(3) NOT NULL default '0',
color varchar(7) NOT NULL default '',
PRIMARY KEY (rankid)
);
INSERT INTO cdb_ranks VALUES (1, 'Beginner', 0, 1, '');
INSERT INTO cdb_ranks VALUES (2, 'Poster', 50, 2, '');
INSERT INTO cdb_ranks VALUES (3, 'Cool Poster', 300, 5, '');
INSERT INTO cdb_ranks VALUES (4, 'Writer', 1000, 4, '');
INSERT INTO cdb_ranks VALUES (5, 'Excellent Writer', 3000, 5, '');
DROP TABLE IF EXISTS cdb_searchindex;
CREATE TABLE cdb_searchindex (
searchid int(10) unsigned NOT NULL auto_increment,
keywords varchar(255) NOT NULL default '',
searchstring varchar(255) NOT NULL default '',
useip varchar(15) NOT NULL default '',
uid mediumint(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
expiration int(10) unsigned NOT NULL default '0',
threads smallint(6) unsigned NOT NULL default '0',
tids text NOT NULL,
PRIMARY KEY (searchid)
);
DROP TABLE IF EXISTS cdb_sessions;
CREATE TABLE cdb_sessions (
sid char(6) binary NOT NULL default '',
ip1 tinyint(3) unsigned NOT NULL default '0',
ip2 tinyint(3) unsigned NOT NULL default '0',
ip3 tinyint(3) unsigned NOT NULL default '0',
ip4 tinyint(3) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
groupid smallint(6) unsigned NOT NULL default '0',
styleid smallint(6) unsigned NOT NULL default '0',
invisible tinyint(1) NOT NULL default '0',
action tinyint(1) unsigned NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
fid smallint(6) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
UNIQUE KEY sid (sid)
) TYPE=HEAP MAX_ROWS=2000;
DROP TABLE IF EXISTS cdb_settings;
CREATE TABLE cdb_settings (
variable varchar(32) NOT NULL default '',
value text NOT NULL,
PRIMARY KEY (variable)
);
INSERT INTO cdb_settings VALUES ('attachimgpost', 0x31);
INSERT INTO cdb_settings VALUES ('attachrefcheck', 0x30);
INSERT INTO cdb_settings VALUES ('attachsave', 0x31);
INSERT INTO cdb_settings VALUES ('attachimgcheck', 0x30);
INSERT INTO cdb_settings VALUES ('attachsoftdownload', 0x30);
INSERT INTO cdb_settings VALUES ('attach_max', 0x30);
INSERT INTO cdb_settings VALUES ('attach_newpost', 0x32);
INSERT INTO cdb_settings VALUES ('attach_editpost', 0x31);
INSERT INTO cdb_settings VALUES ('attach_replypost', 0x31);
INSERT INTO cdb_settings VALUES ('bbclosed', 0x30);
INSERT INTO cdb_settings VALUES ('bbinsert', 0x31);
INSERT INTO cdb_settings VALUES ('bbname', 0x44697363757a2120426f617264);
INSERT INTO cdb_settings VALUES ('bbrules', 0x30);
INSERT INTO cdb_settings VALUES ('bbrulestxt', '');
INSERT INTO cdb_settings VALUES ('censoruser', '');
INSERT INTO cdb_settings VALUES ('closedreason', '');
INSERT INTO cdb_settings VALUES ('statcacherefresh', 0x33363030);
INSERT INTO cdb_settings VALUES ('dateformat', 0x592d6e2d6a);
INSERT INTO cdb_settings VALUES ('debug', 0x31);
INSERT INTO cdb_settings VALUES ('delayviewcount', 0x30);
INSERT INTO cdb_settings VALUES ('delayeditpost', 0x30);
INSERT INTO cdb_settings VALUES ('delaykarma', 0x30);
INSERT INTO cdb_settings VALUES ('deletedcredits', 0x31);
INSERT INTO cdb_settings VALUES ('digestcredits', 0x3130);
INSERT INTO cdb_settings VALUES ('dosevasive', 0x30);
INSERT INTO cdb_settings VALUES ('doublee', 0x31);
INSERT INTO cdb_settings VALUES ('editedby', 0x31);
INSERT INTO cdb_settings VALUES ('fastpost', 0x31);
INSERT INTO cdb_settings VALUES ('floodctrl', 0x3135);
INSERT INTO cdb_settings VALUES ('forumjump', 0x31);
INSERT INTO cdb_settings VALUES ('gzipcompress', 0x30);
INSERT INTO cdb_settings VALUES ('hideprivate', 0x31);
INSERT INTO cdb_settings VALUES ('hottopic', 0x3130);
INSERT INTO cdb_settings VALUES ('loadctrl', 0x30);
INSERT INTO cdb_settings VALUES ('logincredits', 0x30);
INSERT INTO cdb_settings VALUES ('maxavatarpixel', 0x313230);
INSERT INTO cdb_settings VALUES ('maxavatarsize', 0x30);
INSERT INTO cdb_settings VALUES ('maxonlines', 0x31303030);
INSERT INTO cdb_settings VALUES ('maxpolloptions', 0x3130);
INSERT INTO cdb_settings VALUES ('maxpostsize', 0x3130303030);
INSERT INTO cdb_settings VALUES ('maxsearchresults', 0x353132);
INSERT INTO cdb_settings VALUES ('memberperpage', 0x3235);
INSERT INTO cdb_settings VALUES ('memliststatus', 0x31);
INSERT INTO cdb_settings VALUES ('minpostsize', 0x30);
INSERT INTO cdb_settings VALUES ('moddisplay', 0x666c6174);
INSERT INTO cdb_settings VALUES ('modshortcut', 0x30);
INSERT INTO cdb_settings VALUES ('newbiespan', 0x30);
INSERT INTO cdb_settings VALUES ('nocacheheaders', 0x30);
INSERT INTO cdb_settings VALUES ('onlinerecord', 0x310931303430303334363439);
INSERT INTO cdb_settings VALUES ('postcredits', 0x31);
INSERT INTO cdb_settings VALUES ('postperpage', 0x3130);
INSERT INTO cdb_settings VALUES ('regctrl', 0x30);
INSERT INTO cdb_settings VALUES ('regstatus', 0x31);
INSERT INTO cdb_settings VALUES ('regverify', 0x30);
INSERT INTO cdb_settings VALUES ('replycredits', 0x31);
INSERT INTO cdb_settings VALUES ('reportpost', 0x31);
INSERT INTO cdb_settings VALUES ('searchctrl', 0x3330);
INSERT INTO cdb_settings VALUES ('sitename', '北京康盛世纪科技有限公司');
INSERT INTO cdb_settings VALUES ('siteurl', 0x687474703a2f2f7777772e63726f73736461792e636f6d2f);
INSERT INTO cdb_settings VALUES ('smcols', 0x33);
INSERT INTO cdb_settings VALUES ('smileyinsert', 0x31);
INSERT INTO cdb_settings VALUES ('statstatus', 0x30);
INSERT INTO cdb_settings VALUES ('styleid', 0x31);
INSERT INTO cdb_settings VALUES ('timeformat', 0x683a692041);
INSERT INTO cdb_settings VALUES ('timeoffset', 0x38);
INSERT INTO cdb_settings VALUES ('topicperpage', 0x3230);
INSERT INTO cdb_settings VALUES ('userstatusby', 0x31);
INSERT INTO cdb_settings VALUES ('version', 0x322e35);
INSERT INTO cdb_settings VALUES ('vtonlinestatus', 0x31);
INSERT INTO cdb_settings VALUES ('welcomemsg', 0x30);
INSERT INTO cdb_settings VALUES ('welcomemsgtxt', '');
INSERT INTO cdb_settings VALUES ('whosonlinestatus', 0x31);
INSERT INTO cdb_settings VALUES ('useimagemessage', 0x31);
DROP TABLE IF EXISTS cdb_smilies;
CREATE TABLE cdb_smilies (
id smallint(6) unsigned NOT NULL auto_increment,
type enum('smiley','icon') NOT NULL default 'smiley',
code varchar(10) NOT NULL default '',
url varchar(30) NOT NULL default '',
PRIMARY KEY (id)
);
INSERT INTO cdb_smilies VALUES (1, 'smiley', ':)', 'smile.gif');
INSERT INTO cdb_smilies VALUES (2, 'smiley', ':(', 'sad.gif');
INSERT INTO cdb_smilies VALUES (3, 'smiley', ':D', 'biggrin.gif');
INSERT INTO cdb_smilies VALUES (4, 'smiley', ';)', 'wink.gif');
INSERT INTO cdb_smilies VALUES (5, 'smiley', ':cool:', 'cool.gif');
INSERT INTO cdb_smilies VALUES (6, 'smiley', ':mad:', 'mad.gif');
INSERT INTO cdb_smilies VALUES (7, 'smiley', ':o', 'shocked.gif');
INSERT INTO cdb_smilies VALUES (8, 'smiley', ':P', 'tongue.gif');
INSERT INTO cdb_smilies VALUES (9, 'smiley', ':lol:', 'lol.gif');
INSERT INTO cdb_smilies VALUES (10, 'icon', '', 'icon1.gif');
INSERT INTO cdb_smilies VALUES (11, 'icon', '', 'icon2.gif');
INSERT INTO cdb_smilies VALUES (12, 'icon', '', 'icon3.gif');
INSERT INTO cdb_smilies VALUES (13, 'icon', '', 'icon4.gif');
INSERT INTO cdb_smilies VALUES (14, 'icon', '', 'icon5.gif');
INSERT INTO cdb_smilies VALUES (15, 'icon', '', 'icon6.gif');
INSERT INTO cdb_smilies VALUES (16, 'icon', '', 'icon7.gif');
INSERT INTO cdb_smilies VALUES (17, 'icon', '', 'icon8.gif');
INSERT INTO cdb_smilies VALUES (18, 'icon', '', 'icon9.gif');
DROP TABLE IF EXISTS cdb_stats;
CREATE TABLE cdb_stats (
type varchar(20) NOT NULL default '',
var varchar(20) NOT NULL default '',
count int(10) unsigned NOT NULL default '0',
PRIMARY KEY (type,var)
);
INSERT INTO cdb_stats VALUES ('total', 'hits', 0);
INSERT INTO cdb_stats VALUES ('total', 'members', 0);
INSERT INTO cdb_stats VALUES ('total', 'guests', 0);
INSERT INTO cdb_stats VALUES ('os', 'Windows', 0);
INSERT INTO cdb_stats VALUES ('os', 'Mac', 0);
INSERT INTO cdb_stats VALUES ('os', 'Linux', 0);
INSERT INTO cdb_stats VALUES ('os', 'FreeBSD', 0);
INSERT INTO cdb_stats VALUES ('os', 'SunOS', 0);
INSERT INTO cdb_stats VALUES ('os', 'BeOS', 0);
INSERT INTO cdb_stats VALUES ('os', 'OS/2', 0);
INSERT INTO cdb_stats VALUES ('os', 'AIX', 0);
INSERT INTO cdb_stats VALUES ('os', 'Other', 0);
INSERT INTO cdb_stats VALUES ('browser', 'MSIE', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Netscape', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Mozilla', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Lynx', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Opera', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Konqueror', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Other', 0);
INSERT INTO cdb_stats VALUES ('week', '0', 0);
INSERT INTO cdb_stats VALUES ('week', '1', 0);
INSERT INTO cdb_stats VALUES ('week', '2', 0);
INSERT INTO cdb_stats VALUES ('week', '3', 0);
INSERT INTO cdb_stats VALUES ('week', '4', 0);
INSERT INTO cdb_stats VALUES ('week', '5', 0);
INSERT INTO cdb_stats VALUES ('week', '6', 0);
INSERT INTO cdb_stats VALUES ('hour', '00', 0);
INSERT INTO cdb_stats VALUES ('hour', '01', 0);
INSERT INTO cdb_stats VALUES ('hour', '02', 0);
INSERT INTO cdb_stats VALUES ('hour', '03', 0);
INSERT INTO cdb_stats VALUES ('hour', '04', 0);
INSERT INTO cdb_stats VALUES ('hour', '05', 0);
INSERT INTO cdb_stats VALUES ('hour', '06', 0);
INSERT INTO cdb_stats VALUES ('hour', '07', 0);
INSERT INTO cdb_stats VALUES ('hour', '08', 0);
INSERT INTO cdb_stats VALUES ('hour', '09', 0);
INSERT INTO cdb_stats VALUES ('hour', '10', 0);
INSERT INTO cdb_stats VALUES ('hour', '11', 0);
INSERT INTO cdb_stats VALUES ('hour', '12', 0);
INSERT INTO cdb_stats VALUES ('hour', '13', 0);
INSERT INTO cdb_stats VALUES ('hour', '14', 0);
INSERT INTO cdb_stats VALUES ('hour', '15', 0);
INSERT INTO cdb_stats VALUES ('hour', '16', 0);
INSERT INTO cdb_stats VALUES ('hour', '17', 0);
INSERT INTO cdb_stats VALUES ('hour', '18', 0);
INSERT INTO cdb_stats VALUES ('hour', '19', 0);
INSERT INTO cdb_stats VALUES ('hour', '20', 0);
INSERT INTO cdb_stats VALUES ('hour', '21', 0);
INSERT INTO cdb_stats VALUES ('hour', '22', 0);
INSERT INTO cdb_stats VALUES ('hour', '23', 0);
DROP TABLE IF EXISTS cdb_styles;
CREATE TABLE cdb_styles (
styleid smallint(6) unsigned NOT NULL auto_increment,
name varchar(20) NOT NULL default '',
available tinyint(1) NOT NULL default '1',
templateid smallint(6) unsigned NOT NULL default '0',
PRIMARY KEY (styleid),
KEY themename (name)
);
INSERT INTO cdb_styles VALUES (1, 'Default Style', 1, 1);
DROP TABLE IF EXISTS cdb_stylevars;
CREATE TABLE cdb_stylevars (
stylevarid smallint(6) unsigned NOT NULL auto_increment,
styleid smallint(6) unsigned NOT NULL default '0',
variable text NOT NULL,
substitute text NOT NULL,
PRIMARY KEY (stylevarid),
KEY styleid (styleid)
);
INSERT INTO cdb_stylevars VALUES (1, 1, 'bgcolor', '#E9EDF7');
INSERT INTO cdb_stylevars VALUES (2, 1, 'altbg1', '#F8F9FC');
INSERT INTO cdb_stylevars VALUES (3, 1, 'altbg2', '#FFFFFF');
INSERT INTO cdb_stylevars VALUES (4, 1, 'link', '#003366');
INSERT INTO cdb_stylevars VALUES (5, 1, 'bordercolor', '#DDE3EC');
INSERT INTO cdb_stylevars VALUES (6, 1, 'headercolor', 'headerbg.gif');
INSERT INTO cdb_stylevars VALUES (7, 1, 'headertext', '#FFFFFF');
INSERT INTO cdb_stylevars VALUES (8, 1, 'catcolor', 'catbg.gif');
INSERT INTO cdb_stylevars VALUES (9, 1, 'tabletext', '#000000');
INSERT INTO cdb_stylevars VALUES (10, 1, 'text', '#000000');
INSERT INTO cdb_stylevars VALUES (11, 1, 'borderwidth', '1');
INSERT INTO cdb_stylevars VALUES (12, 1, 'tablewidth', '99%');
INSERT INTO cdb_stylevars VALUES (13, 1, 'tablespace', '4');
INSERT INTO cdb_stylevars VALUES (14, 1, 'font', 'Tahoma, Verdana');
INSERT INTO cdb_stylevars VALUES (15, 1, 'fontsize', '12px');
INSERT INTO cdb_stylevars VALUES (16, 1, 'nobold', '0');
INSERT INTO cdb_stylevars VALUES (17, 1, 'boardimg', 'logo.gif');
INSERT INTO cdb_stylevars VALUES (18, 1, 'imgdir', 'images/default');
INSERT INTO cdb_stylevars VALUES (19, 1, 'smdir', 'images/smilies');
INSERT INTO cdb_stylevars VALUES (20, 1, 'cattext', '#000000');
INSERT INTO cdb_stylevars VALUES (21, 1, 'smfontsize', '11px');
INSERT INTO cdb_stylevars VALUES (22, 1, 'smfont', 'Tahoma');
INSERT INTO cdb_stylevars VALUES (23, 1, 'maintablespace', '8');
INSERT INTO cdb_stylevars VALUES (24, 1, 'maintablewidth', '98%');
INSERT INTO cdb_stylevars VALUES (25, 1, 'maintablecolor', '#FFFFFF');
DROP TABLE IF EXISTS cdb_subscriptions;
CREATE TABLE cdb_subscriptions (
uid mediumint(8) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
email varchar(60) NOT NULL default '',
lastnotify int(10) unsigned NOT NULL default '0',
PRIMARY KEY (uid,tid)
);
DROP TABLE IF EXISTS cdb_templates;
CREATE TABLE cdb_templates (
templateid smallint(6) unsigned NOT NULL auto_increment,
name varchar(30) NOT NULL default '',
charset varchar(30) NOT NULL default '',
directory varchar(100) NOT NULL default '',
copyright varchar(100) NOT NULL default '',
PRIMARY KEY (templateid)
);
INSERT INTO cdb_templates VALUES (1, 'Default', '$lang[charset]', './templates/default', 'Designed by ARTERY');
DROP TABLE IF EXISTS cdb_threads;
CREATE TABLE cdb_threads (
tid mediumint(8) unsigned NOT NULL auto_increment,
fid smallint(6) unsigned NOT NULL default '0',
creditsrequire smallint(6) unsigned NOT NULL default '0',
iconid smallint(6) unsigned NOT NULL default '0',
author char(15) NOT NULL default '',
authorid mediumint(8) unsigned NOT NULL default '0',
subject char(80) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
lastposter char(15) NOT NULL default '',
views mediumint(8) unsigned NOT NULL default '0',
replies smallint(6) unsigned NOT NULL default '0',
displayorder tinyint(1) NOT NULL default '0',
highlight tinyint(1) NOT NULL default '0',
digest tinyint(1) NOT NULL default '0',
poll tinyint(1) NOT NULL default '0',
attachment tinyint(1) NOT NULL default '0',
closed mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (tid),
KEY displayorder (fid,displayorder,lastpost),
KEY digest (digest)
);
DROP TABLE IF EXISTS cdb_usergroups;
CREATE TABLE cdb_usergroups (
groupid smallint(6) unsigned NOT NULL auto_increment,
type enum('system','special','member') NOT NULL default 'member',
grouptitle char(30) NOT NULL default '',
creditshigher int(10) NOT NULL default '0',
creditslower int(10) NOT NULL default '0',
stars tinyint(3) NOT NULL default '0',
color char(7) NOT NULL default '',
groupavatar char(60) NOT NULL default '',
allowcstatus tinyint(1) NOT NULL default '0',
allowavatar tinyint(1) NOT NULL default '0',
allowvisit tinyint(1) NOT NULL default '0',
allowview tinyint(1) NOT NULL default '0',
allowpost tinyint(1) NOT NULL default '0',
allowpostpoll tinyint(1) NOT NULL default '0',
allowgetattach tinyint(1) NOT NULL default '0',
allowpostattach tinyint(1) NOT NULL default '0',
allowvote tinyint(1) NOT NULL default '0',
allowsearch tinyint(1) NOT NULL default '0',
allowkarma tinyint(1) NOT NULL default '0',
allowinvisible tinyint(1) NOT NULL default '0',
allowsetviewperm tinyint(1) NOT NULL default '0',
allowsetattachperm tinyint(1) NOT NULL default '0',
allowhidecode tinyint(1) NOT NULL default '0',
allowsigbbcode tinyint(1) NOT NULL default '0',
allowsigimgcode tinyint(1) NOT NULL default '0',
allowviewstats tinyint(1) NOT NULL default '0',
maxpmnum smallint(6) unsigned NOT NULL default '0',
maxsigsize smallint(6) unsigned NOT NULL default '0',
maxkarmarate tinyint(3) unsigned NOT NULL default '0',
maxrateperday smallint(6) unsigned NOT NULL default '0',
maxattachsize int(10) unsigned NOT NULL default '0',
attachextensions char(60) NOT NULL default '',
PRIMARY KEY (groupid),
KEY creditsrange (creditshigher,creditslower)
);
INSERT INTO cdb_usergroups VALUES (1, 'system', '管理员', 0, 0, 9, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 200, 500, 30, 500, 2048000, '');
INSERT INTO cdb_usergroups VALUES (2, 'system', '超级版主', 0, 0, 8, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 120, 300, 15, 50, 2048000, '');
INSERT INTO cdb_usergroups VALUES (3, 'system', '版主', 0, 0, 7, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 0, 1, 1, 1, 1, 1, 1, 80, 200, 10, 30, 2048000, 'chm,pdf,zip,rar,tar,tgz,gif,jpg,jpeg,png');
INSERT INTO cdb_usergroups VALUES (4, 'system', '禁止发言', 0, 0, 0, '', '', 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (5, 'system', '禁止访问', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (6, 'system', 'IP 禁止', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (7, 'system', '游客', 0, 0, 0, '', '', 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (8, 'system', '等待验证用户', 0, 0, 0, '', '', 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 50, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (9, 'member', '社区乞丐', -9999999, 0, 0, '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (10, 'member', '新手上路', 0, 50, 1, '', '', 0, 0, 1, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 20, 80, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (11, 'member', '注册用户', 50, 200, 2, '', '', 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 1, 30, 100, 4, 10, 0, '');
INSERT INTO cdb_usergroups VALUES (12, 'member', '中级用户', 200, 500, 3, '', '', 0, 2, 1, 1, 1, 1, 1, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 1, 50, 150, 6, 15, 256000, 'gif,jpg,jpeg,png');
INSERT INTO cdb_usergroups VALUES (13, 'member', '高级用户', 500, 1000, 4, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 0, 0, 0, 0, 1, 0, 1, 60, 200, 10, 30, 512000, 'zip,rar,tar,tgz,gif,jpg,jpeg,png');
INSERT INTO cdb_usergroups VALUES (14, 'member', '银牌会员', 1000, 3000, 6, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 0, 1, 1, 0, 1, 1, 1, 80, 300, 15, 40, 1024000, 'chm,pdf,zip,rar,tar,tgz,gif,jpg,jpeg,png');
INSERT INTO cdb_usergroups VALUES (15, 'member', '金牌会员', 3000, 9999999, 8, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 0, 1, 1, 1, 100, 500, 20, 50, 2048000, 'chm,pdf,zip,rar,tar,tgz,gif,jpg,jpeg,png');
DROP TABLE IF EXISTS cdb_words;
CREATE TABLE cdb_words (
id smallint(6) unsigned NOT NULL auto_increment,
admin varchar(15) NOT NULL default '',
find varchar(60) NOT NULL default '',
replacement varchar(60) NOT NULL default '',
PRIMARY KEY (id)
);
DROP TABLE IF EXISTS cdb_plugins;
CREATE TABLE cdb_plugins (
plug_id smallint(6) NOT NULL auto_increment,
plug_title varchar(255) NOT NULL default '',
plug_version varchar(255) NOT NULL default '',
plug_author varchar(255) NOT NULL default '0',
plug_key varchar(255) NOT NULL default '',
plug_stats tinyint(1) NOT NULL default '0',
plug_cp varchar(255) NOT NULL default '',
plug_tables varchar(255) NOT NULL default '',
plug_license text NOT NULL,
plug_desc text NOT NULL,
PRIMARY KEY (plug_id),
KEY plug_keyword (plug_key)
);
DROP TABLE IF EXISTS cdb_plugins_settings;
CREATE TABLE cdb_plugins_settings (
conf_id int(10) unsigned NOT NULL auto_increment,
conf_title varchar(255) NOT NULL default '',
conf_desc text NOT NULL,
conf_group varchar(255) NOT NULL default '',
conf_type varchar(255) NOT NULL default '',
conf_key varchar(255) NOT NULL default '',
conf_value text NOT NULL,
conf_extra text NOT NULL,
conf_position smallint(3) unsigned NOT NULL default '0',
conf_cached tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (conf_id),
KEY conf_group (conf_group)
);

复制代码

5025488.net · 发表于 2005-10-1 20:54:45

2.5 sp1

DROP TABLE IF EXISTS cdb_access;
CREATE TABLE cdb_access (
uid mediumint(8) unsigned NOT NULL default '0',
fid smallint(6) unsigned NOT NULL default '0',
allowview tinyint(1) NOT NULL default '0',
allowpost tinyint(1) NOT NULL default '0',
allowreply tinyint(1) NOT NULL default '0',
allowgetattach tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid,fid)
);
DROP TABLE IF EXISTS cdb_admingroups;
CREATE TABLE cdb_admingroups (
admingid smallint(3) unsigned NOT NULL auto_increment,
admintitle char(30) NOT NULL default '',
adminglobal tinyint(1) NOT NULL default '0',
alloweditpost tinyint(1) NOT NULL default '0',
alloweditpoll tinyint(1) NOT NULL default '0',
allowdelpost tinyint(1) NOT NULL default '0',
allowmassprune tinyint(1) NOT NULL default '0',
allowcensorword tinyint(1) NOT NULL default '0',
allowviewip tinyint(1) NOT NULL default '0',
allowbanip tinyint(1) NOT NULL default '0',
allowedituser tinyint(1) NOT NULL default '0',
allowbanuser tinyint(1) NOT NULL default '0',
allowpostannounce tinyint(1) NOT NULL default '0',
allowviewlog tinyint(1) NOT NULL default '0',
allowhighlight tinyint(1) NOT NULL default '0',
allowdigest tinyint(1) NOT NULL default '0',
allowclose tinyint(1) NOT NULL default '0',
allowmove tinyint(1) NOT NULL default '0',
allowtop tinyint(1) NOT NULL default '0',
allowmerge tinyint(1) NOT NULL default '0',
allowsplit tinyint(1) NOT NULL default '0',
disablepostctrl tinyint(1) NOT NULL default '0',
PRIMARY KEY (admingid)
) ;
INSERT INTO cdb_admingroups VALUES (1, 'Administrator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO cdb_admingroups VALUES (2, 'SuperModerator', 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO cdb_admingroups VALUES (3, 'Moderator', 0, 1, 0, 1, 0, 0, 1, 0, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1);
DROP TABLE IF EXISTS cdb_adminsessions;
CREATE TABLE cdb_adminsessions (
uid mediumint(8) NOT NULL default '0',
ip char(20) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
errorlog tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid,ip,dateline)
);
DROP TABLE IF EXISTS cdb_announcements;
CREATE TABLE cdb_announcements (
id smallint(6) unsigned NOT NULL auto_increment,
author varchar(15) NOT NULL default '',
subject varchar(250) NOT NULL default '',
posturl varchar(250) NOT NULL default '',
displayorder tinyint(3) NOT NULL default '0',
starttime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',
message text NOT NULL,
PRIMARY KEY (id)
);
DROP TABLE IF EXISTS cdb_attachments;
CREATE TABLE cdb_attachments (
aid mediumint(8) unsigned NOT NULL auto_increment,
tid mediumint(8) unsigned NOT NULL default '0',
pid int(10) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
creditsrequire smallint(6) unsigned NOT NULL default '0',
filename char(100) NOT NULL default '',
filetype char(50) NOT NULL default '',
filesize int(10) unsigned NOT NULL default '0',
attachment char(100) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
downloads smallint(6) unsigned NOT NULL default '0',
PRIMARY KEY (aid),
KEY tid (tid),
KEY pid (pid),
KEY uid (uid)
);
DROP TABLE IF EXISTS cdb_attachtypes;
CREATE TABLE cdb_attachtypes (
id smallint(6) unsigned NOT NULL auto_increment,
extension char(10) NOT NULL default '',
maxsize int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id)
);
DROP TABLE IF EXISTS cdb_banned;
CREATE TABLE cdb_banned (
id smallint(6) unsigned NOT NULL auto_increment,
ip1 smallint(3) NOT NULL default '0',
ip2 smallint(3) NOT NULL default '0',
ip3 smallint(3) NOT NULL default '0',
ip4 smallint(3) NOT NULL default '0',
admin varchar(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
expiration int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id)
);
DROP TABLE IF EXISTS cdb_bbcodes;
CREATE TABLE cdb_bbcodes (
id mediumint(8) unsigned NOT NULL auto_increment,
available tinyint(1) NOT NULL default '0',
tag varchar(100) NOT NULL default '',
replacement text NOT NULL,
example varchar(255) NOT NULL default '',
explanation text NOT NULL,
params tinyint(1) unsigned NOT NULL default '1',
nest tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (id)
);
DROP TABLE IF EXISTS cdb_buddys;
CREATE TABLE cdb_buddys (
uid mediumint(8) unsigned NOT NULL default '0',
buddyid mediumint(8) unsigned NOT NULL default '0',
KEY uid (uid)
);
DROP TABLE IF EXISTS cdb_caches;
CREATE TABLE cdb_caches (
cid int(10) unsigned NOT NULL auto_increment,
ckey varchar(80) NOT NULL default '',
cval text NOT NULL,
dateline int(10) NOT NULL default '0',
extr varchar(80) NOT NULL default '',
PRIMARY KEY (cid),
KEY ckey (ckey)
);
DROP TABLE IF EXISTS cdb_failedlogins;
CREATE TABLE cdb_failedlogins (
ip char(15) NOT NULL default '',
count tinyint(1) unsigned NOT NULL default '0',
lastupdate int(10) unsigned NOT NULL default '0'
);
DROP TABLE IF EXISTS cdb_favorites;
CREATE TABLE cdb_favorites (
uid mediumint(8) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
KEY tid (tid)
);
DROP TABLE IF EXISTS cdb_forumlinks;
CREATE TABLE cdb_forumlinks (
id smallint(6) unsigned NOT NULL auto_increment,
displayorder tinyint(3) NOT NULL default '0',
name varchar(100) NOT NULL default '',
url varchar(200) NOT NULL default '',
note varchar(200) NOT NULL default '',
logo varchar(100) NOT NULL default '',
PRIMARY KEY (id)
);
INSERT INTO cdb_forumlinks VALUES (1, 0, 'Discuz! Board', 'http://www.discuz.com', 'Discuz! 官方网站，提供最新 Discuz! 软件下载、使用讨论与技术交流', 'images/logo.gif');
INSERT INTO cdb_forumlinks VALUES (2, 0, 'Free Discuz!', 'http://www.freediscuz.net', 'Free Discuz!，免费 Discuz! 插件与风格', 'http://www.freediscuz.net/bbs/images/logo4.gif');
DROP TABLE IF EXISTS cdb_forums;
CREATE TABLE cdb_forums (
fid smallint(6) unsigned NOT NULL auto_increment,
fup smallint(6) unsigned NOT NULL default '0',
type enum('group','forum','sub') NOT NULL default 'forum',
icon char(50) NOT NULL default '',
name char(255) NOT NULL default '',
description char(255) NOT NULL default '',
status tinyint(1) NOT NULL default '0',
displayorder tinyint(3) NOT NULL default '0',
moderator char(255) NOT NULL default '',
styleid smallint(6) unsigned NOT NULL default '0',
threads mediumint(8) unsigned NOT NULL default '0',
posts mediumint(8) unsigned NOT NULL default '0',
lastpost char(110) NOT NULL default '',
allowsmilies tinyint(1) NOT NULL default '0',
allowhtml tinyint(1) NOT NULL default '0',
allowbbcode tinyint(1) NOT NULL default '0',
allowimgcode tinyint(1) NOT NULL default '0',
postcredits tinyint(3) NOT NULL default '-1',
replycredits tinyint(3) NOT NULL default '-1',
password char(12) NOT NULL default '',
viewperm char(100) NOT NULL default '',
postperm char(100) NOT NULL default '',
replyperm char(100) NOT NULL default '',
getattachperm char(100) NOT NULL default '',
PRIMARY KEY (fid),
KEY forum (status,type,displayorder)
);
INSERT INTO cdb_forums VALUES (1, 0, 'forum', '', '默认论坛', '', 1, 0, '', 0, 0, 0, '', 1, 0, 1, 1, -1, -1, '', '', '', '', '');
DROP TABLE IF EXISTS cdb_karmalog;
CREATE TABLE cdb_karmalog (
kid int(10) NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
pid int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
score tinyint(3) NOT NULL default '0',
PRIMARY KEY (kid),
KEY pid (pid),
KEY dateline (dateline)
);
DROP TABLE IF EXISTS cdb_members;
CREATE TABLE cdb_members (
uid mediumint(8) unsigned NOT NULL auto_increment,
username varchar(15) NOT NULL default '',
password varchar(32) NOT NULL default '',
secques varchar(8) NOT NULL default '',
gender tinyint(1) NOT NULL default '0',
adminid smallint(3) NOT NULL default '0',
groupid smallint(6) unsigned NOT NULL default '0',
regip varchar(15) NOT NULL default '',
regdate int(10) unsigned NOT NULL default '0',
lastip varchar(15) NOT NULL default '',
lastvisit int(10) unsigned NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
postnum smallint(6) unsigned NOT NULL default '0',
credit int(10) NOT NULL default '0',
extracredit int(10) NOT NULL default '0',
email varchar(60) NOT NULL default '',
site varchar(75) NOT NULL default '',
icq varchar(12) NOT NULL default '',
oicq varchar(12) NOT NULL default '',
yahoo varchar(40) NOT NULL default '',
msn varchar(40) NOT NULL default '',
location varchar(30) NOT NULL default '',
bday date NOT NULL default '0000-00-00',
bio text NOT NULL,
avatar varchar(100) NOT NULL default '',
avatarwidth tinyint(3) unsigned NOT NULL default '0',
avatarheight tinyint(3) unsigned NOT NULL default '0',
signature text NOT NULL,
customstatus varchar(30) NOT NULL default '',
tpp tinyint(3) unsigned NOT NULL default '0',
ppp tinyint(3) unsigned NOT NULL default '0',
styleid smallint(6) unsigned NOT NULL default '0',
dateformat varchar(10) NOT NULL default '',
timeformat varchar(5) NOT NULL default '',
showemail tinyint(1) NOT NULL default '0',
newsletter tinyint(1) NOT NULL default '0',
invisible tinyint(1) NOT NULL default '0',
timeoffset char(4) NOT NULL default '',
ignorepm text NOT NULL,
newpm tinyint(1) NOT NULL default '0',
accessmasks tinyint(1) NOT NULL default '0',
identifying varchar(20) NOT NULL default '',
PRIMARY KEY (uid),
KEY username (username)
);
DROP TABLE IF EXISTS cdb_onlinelist;
CREATE TABLE cdb_onlinelist (
groupid smallint(6) unsigned NOT NULL default '0',
displayorder tinyint(3) NOT NULL default '0',
title varchar(30) NOT NULL default '',
url varchar(30) NOT NULL default ''
);
INSERT INTO cdb_onlinelist VALUES (1, 1, '管理员', 'online_admin.gif');
INSERT INTO cdb_onlinelist VALUES (2, 2, '超级版主', 'online_supermod.gif');
INSERT INTO cdb_onlinelist VALUES (3, 3, '版主', 'online_moderator.gif');
INSERT INTO cdb_onlinelist VALUES (0, 4, '注册用户', 'online_member.gif');
DROP TABLE IF EXISTS cdb_pms;
CREATE TABLE cdb_pms (
pmid int(10) unsigned NOT NULL auto_increment,
msgfrom varchar(15) NOT NULL default '',
msgfromid mediumint(8) unsigned NOT NULL default '0',
msgtoid mediumint(8) unsigned NOT NULL default '0',
folder enum('inbox','outbox') NOT NULL default 'inbox',
new tinyint(1) NOT NULL default '0',
subject varchar(75) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
message text NOT NULL,
PRIMARY KEY (pmid),
KEY msgtoid (msgtoid),
KEY msgfromid (msgfromid)
);
DROP TABLE IF EXISTS cdb_polls;
CREATE TABLE cdb_polls (
tid mediumint(8) unsigned NOT NULL default '0',
pollopts mediumtext NOT NULL,
PRIMARY KEY (tid)
);
DROP TABLE IF EXISTS cdb_posts;
CREATE TABLE cdb_posts (
pid int(10) unsigned NOT NULL auto_increment,
fid smallint(6) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
aid tinyint(1) NOT NULL default '0',
author varchar(15) NOT NULL default '',
authorid mediumint(8) unsigned NOT NULL default '0',
subject varchar(80) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
message mediumtext NOT NULL,
useip varchar(15) NOT NULL default '',
usesig tinyint(1) NOT NULL default '0',
bbcodeoff tinyint(1) NOT NULL default '0',
smileyoff tinyint(1) NOT NULL default '0',
parseurloff tinyint(1) NOT NULL default '0',
rate smallint(6) NOT NULL default '0',
ratetimes tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (pid),
KEY fid (fid),
KEY dateline (dateline),
KEY authorid (authorid),
KEY tid (tid,dateline)
);
DROP TABLE IF EXISTS cdb_ranks;
CREATE TABLE cdb_ranks (
rankid smallint(6) unsigned NOT NULL auto_increment,
ranktitle varchar(30) NOT NULL default '',
postshigher smallint(6) unsigned NOT NULL default '0',
stars tinyint(3) NOT NULL default '0',
color varchar(7) NOT NULL default '',
PRIMARY KEY (rankid)
);
INSERT INTO cdb_ranks VALUES (1, 'Beginner', 0, 1, '');
INSERT INTO cdb_ranks VALUES (2, 'Poster', 50, 2, '');
INSERT INTO cdb_ranks VALUES (3, 'Cool Poster', 300, 5, '');
INSERT INTO cdb_ranks VALUES (4, 'Writer', 1000, 4, '');
INSERT INTO cdb_ranks VALUES (5, 'Excellent Writer', 3000, 5, '');
DROP TABLE IF EXISTS cdb_searchindex;
CREATE TABLE cdb_searchindex (
searchid int(10) unsigned NOT NULL auto_increment,
keywords varchar(255) NOT NULL default '',
searchstring varchar(255) NOT NULL default '',
useip varchar(15) NOT NULL default '',
uid mediumint(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
expiration int(10) unsigned NOT NULL default '0',
threads smallint(6) unsigned NOT NULL default '0',
tids text NOT NULL,
PRIMARY KEY (searchid)
);
DROP TABLE IF EXISTS cdb_sessions;
CREATE TABLE cdb_sessions (
sid char(6) binary NOT NULL default '',
ip1 tinyint(3) unsigned NOT NULL default '0',
ip2 tinyint(3) unsigned NOT NULL default '0',
ip3 tinyint(3) unsigned NOT NULL default '0',
ip4 tinyint(3) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
groupid smallint(6) unsigned NOT NULL default '0',
styleid smallint(6) unsigned NOT NULL default '0',
invisible tinyint(1) NOT NULL default '0',
action tinyint(1) unsigned NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
fid smallint(6) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
UNIQUE KEY sid (sid)
) TYPE=HEAP MAX_ROWS=2000;
DROP TABLE IF EXISTS cdb_settings;
CREATE TABLE cdb_settings (
variable varchar(32) NOT NULL default '',
value text NOT NULL,
PRIMARY KEY (variable)
);
INSERT INTO cdb_settings VALUES ('announcements_num', 0x31);
INSERT INTO cdb_settings VALUES ('attachimgpost', 0x31);
INSERT INTO cdb_settings VALUES ('attachrefcheck', 0x30);
INSERT INTO cdb_settings VALUES ('attachsave', 0x31);
INSERT INTO cdb_settings VALUES ('attachimgcheck', 0x30);
INSERT INTO cdb_settings VALUES ('attachsoftdownload', 0x30);
INSERT INTO cdb_settings VALUES ('attach_max', 0x30);
INSERT INTO cdb_settings VALUES ('attach_newpost', 0x32);
INSERT INTO cdb_settings VALUES ('attach_editpost', 0x31);
INSERT INTO cdb_settings VALUES ('attach_replypost', 0x31);
INSERT INTO cdb_settings VALUES ('bbclosed', 0x30);
INSERT INTO cdb_settings VALUES ('bbinsert', 0x31);
INSERT INTO cdb_settings VALUES ('bbname', 0x44697363757a2120426f617264);
INSERT INTO cdb_settings VALUES ('bbrules', 0x30);
INSERT INTO cdb_settings VALUES ('bbrulestxt', '');
INSERT INTO cdb_settings VALUES ('censoruser', '');
INSERT INTO cdb_settings VALUES ('closedreason', '');
INSERT INTO cdb_settings VALUES ('statcacherefresh', 0x33363030);
INSERT INTO cdb_settings VALUES ('dateformat', 0x592d6e2d6a);
INSERT INTO cdb_settings VALUES ('debug', 0x31);
INSERT INTO cdb_settings VALUES ('delayviewcount', 0x30);
INSERT INTO cdb_settings VALUES ('delayeditpost', 0x30);
INSERT INTO cdb_settings VALUES ('delayreply', 0x30);
INSERT INTO cdb_settings VALUES ('delaykarma', 0x30);
INSERT INTO cdb_settings VALUES ('deletedcredits', 0x31);
INSERT INTO cdb_settings VALUES ('digestcredits', 0x3130);
INSERT INTO cdb_settings VALUES ('dosevasive', 0x30);
INSERT INTO cdb_settings VALUES ('doublee', 0x31);
INSERT INTO cdb_settings VALUES ('editedby', 0x31);
INSERT INTO cdb_settings VALUES ('fastpost', 0x31);
INSERT INTO cdb_settings VALUES ('floodctrl', 0x3135);
INSERT INTO cdb_settings VALUES ('forumjump', 0x31);
INSERT INTO cdb_settings VALUES ('gzipcompress', 0x30);
INSERT INTO cdb_settings VALUES ('hideprivate', 0x31);
INSERT INTO cdb_settings VALUES ('hottopic', 0x3130);
INSERT INTO cdb_settings VALUES ('loadctrl', 0x30);
INSERT INTO cdb_settings VALUES ('logincredits', 0x30);
INSERT INTO cdb_settings VALUES ('maxavatarpixel', 0x313230);
INSERT INTO cdb_settings VALUES ('maxavatarsize', 0x30);
INSERT INTO cdb_settings VALUES ('maxonlines', 0x31303030);
INSERT INTO cdb_settings VALUES ('maxpolloptions', 0x3130);
INSERT INTO cdb_settings VALUES ('maxpostsize', 0x3130303030);
INSERT INTO cdb_settings VALUES ('maxsearchresults', 0x353132);
INSERT INTO cdb_settings VALUES ('memberperpage', 0x3235);
INSERT INTO cdb_settings VALUES ('memliststatus', 0x31);
INSERT INTO cdb_settings VALUES ('minpostsize', 0x30);
INSERT INTO cdb_settings VALUES ('moddisplay', 0x666c6174);
INSERT INTO cdb_settings VALUES ('modshortcut', 0x30);
INSERT INTO cdb_settings VALUES ('newbiespan', 0x30);
INSERT INTO cdb_settings VALUES ('nocacheheaders', 0x30);
INSERT INTO cdb_settings VALUES ('onlinerecord', 0x310931303430303334363439);
INSERT INTO cdb_settings VALUES ('postcredits', 0x31);
INSERT INTO cdb_settings VALUES ('postperpage', 0x3130);
INSERT INTO cdb_settings VALUES ('regctrl', 0x30);
INSERT INTO cdb_settings VALUES ('regstatus', 0x31);
INSERT INTO cdb_settings VALUES ('regverify', 0x30);
INSERT INTO cdb_settings VALUES ('replycredits', 0x31);
INSERT INTO cdb_settings VALUES ('reportpost', 0x31);
INSERT INTO cdb_settings VALUES ('searchctrl', 0x3330);
INSERT INTO cdb_settings VALUES ('sitename', '北京康盛世纪科技有限公司');
INSERT INTO cdb_settings VALUES ('siteurl', 0x687474703a2f2f7777772e63726f73736461792e636f6d2f);
INSERT INTO cdb_settings VALUES ('smcols', 0x33);
INSERT INTO cdb_settings VALUES ('smileyinsert', 0x31);
INSERT INTO cdb_settings VALUES ('statstatus', 0x30);
INSERT INTO cdb_settings VALUES ('styleid', 0x31);
INSERT INTO cdb_settings VALUES ('timeformat', 0x683a692041);
INSERT INTO cdb_settings VALUES ('timeoffset', 0x38);
INSERT INTO cdb_settings VALUES ('topicperpage', 0x3230);
INSERT INTO cdb_settings VALUES ('userstatusby', 0x31);
INSERT INTO cdb_settings VALUES ('version', 0x322e35);
INSERT INTO cdb_settings VALUES ('vtonlinestatus', 0x30);
INSERT INTO cdb_settings VALUES ('welcomemsg', 0x30);
INSERT INTO cdb_settings VALUES ('welcomemsgtxt', '');
INSERT INTO cdb_settings VALUES ('whosonlinestatus', 0x31);
INSERT INTO cdb_settings VALUES ('useimagemessage', 0x31);
DROP TABLE IF EXISTS cdb_smilies;
CREATE TABLE cdb_smilies (
id smallint(6) unsigned NOT NULL auto_increment,
type enum('smiley','icon') NOT NULL default 'smiley',
code varchar(10) NOT NULL default '',
url varchar(30) NOT NULL default '',
PRIMARY KEY (id)
);
INSERT INTO cdb_smilies VALUES (1, 'smiley', ':)', 'smile.gif');
INSERT INTO cdb_smilies VALUES (2, 'smiley', ':(', 'sad.gif');
INSERT INTO cdb_smilies VALUES (3, 'smiley', ':D', 'biggrin.gif');
INSERT INTO cdb_smilies VALUES (4, 'smiley', ';)', 'wink.gif');
INSERT INTO cdb_smilies VALUES (5, 'smiley', ':cool:', 'cool.gif');
INSERT INTO cdb_smilies VALUES (6, 'smiley', ':mad:', 'mad.gif');
INSERT INTO cdb_smilies VALUES (7, 'smiley', ':o', 'shocked.gif');
INSERT INTO cdb_smilies VALUES (8, 'smiley', ':P', 'tongue.gif');
INSERT INTO cdb_smilies VALUES (9, 'smiley', ':lol:', 'lol.gif');
INSERT INTO cdb_smilies VALUES (10, 'icon', '', 'icon1.gif');
INSERT INTO cdb_smilies VALUES (11, 'icon', '', 'icon2.gif');
INSERT INTO cdb_smilies VALUES (12, 'icon', '', 'icon3.gif');
INSERT INTO cdb_smilies VALUES (13, 'icon', '', 'icon4.gif');
INSERT INTO cdb_smilies VALUES (14, 'icon', '', 'icon5.gif');
INSERT INTO cdb_smilies VALUES (15, 'icon', '', 'icon6.gif');
INSERT INTO cdb_smilies VALUES (16, 'icon', '', 'icon7.gif');
INSERT INTO cdb_smilies VALUES (17, 'icon', '', 'icon8.gif');
INSERT INTO cdb_smilies VALUES (18, 'icon', '', 'icon9.gif');
DROP TABLE IF EXISTS cdb_stats;
CREATE TABLE cdb_stats (
type varchar(20) NOT NULL default '',
var varchar(20) NOT NULL default '',
count int(10) unsigned NOT NULL default '0',
PRIMARY KEY (type,var)
);
INSERT INTO cdb_stats VALUES ('total', 'hits', 0);
INSERT INTO cdb_stats VALUES ('total', 'members', 0);
INSERT INTO cdb_stats VALUES ('total', 'guests', 0);
INSERT INTO cdb_stats VALUES ('os', 'Windows', 0);
INSERT INTO cdb_stats VALUES ('os', 'Mac', 0);
INSERT INTO cdb_stats VALUES ('os', 'Linux', 0);
INSERT INTO cdb_stats VALUES ('os', 'FreeBSD', 0);
INSERT INTO cdb_stats VALUES ('os', 'SunOS', 0);
INSERT INTO cdb_stats VALUES ('os', 'BeOS', 0);
INSERT INTO cdb_stats VALUES ('os', 'OS/2', 0);
INSERT INTO cdb_stats VALUES ('os', 'AIX', 0);
INSERT INTO cdb_stats VALUES ('os', 'Other', 0);
INSERT INTO cdb_stats VALUES ('browser', 'MSIE', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Netscape', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Mozilla', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Lynx', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Opera', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Konqueror', 0);
INSERT INTO cdb_stats VALUES ('browser', 'Other', 0);
INSERT INTO cdb_stats VALUES ('week', '0', 0);
INSERT INTO cdb_stats VALUES ('week', '1', 0);
INSERT INTO cdb_stats VALUES ('week', '2', 0);
INSERT INTO cdb_stats VALUES ('week', '3', 0);
INSERT INTO cdb_stats VALUES ('week', '4', 0);
INSERT INTO cdb_stats VALUES ('week', '5', 0);
INSERT INTO cdb_stats VALUES ('week', '6', 0);
INSERT INTO cdb_stats VALUES ('hour', '00', 0);
INSERT INTO cdb_stats VALUES ('hour', '01', 0);
INSERT INTO cdb_stats VALUES ('hour', '02', 0);
INSERT INTO cdb_stats VALUES ('hour', '03', 0);
INSERT INTO cdb_stats VALUES ('hour', '04', 0);
INSERT INTO cdb_stats VALUES ('hour', '05', 0);
INSERT INTO cdb_stats VALUES ('hour', '06', 0);
INSERT INTO cdb_stats VALUES ('hour', '07', 0);
INSERT INTO cdb_stats VALUES ('hour', '08', 0);
INSERT INTO cdb_stats VALUES ('hour', '09', 0);
INSERT INTO cdb_stats VALUES ('hour', '10', 0);
INSERT INTO cdb_stats VALUES ('hour', '11', 0);
INSERT INTO cdb_stats VALUES ('hour', '12', 0);
INSERT INTO cdb_stats VALUES ('hour', '13', 0);
INSERT INTO cdb_stats VALUES ('hour', '14', 0);
INSERT INTO cdb_stats VALUES ('hour', '15', 0);
INSERT INTO cdb_stats VALUES ('hour', '16', 0);
INSERT INTO cdb_stats VALUES ('hour', '17', 0);
INSERT INTO cdb_stats VALUES ('hour', '18', 0);
INSERT INTO cdb_stats VALUES ('hour', '19', 0);
INSERT INTO cdb_stats VALUES ('hour', '20', 0);
INSERT INTO cdb_stats VALUES ('hour', '21', 0);
INSERT INTO cdb_stats VALUES ('hour', '22', 0);
INSERT INTO cdb_stats VALUES ('hour', '23', 0);
DROP TABLE IF EXISTS cdb_styles;
CREATE TABLE cdb_styles (
styleid smallint(6) unsigned NOT NULL auto_increment,
name varchar(20) NOT NULL default '',
available tinyint(1) NOT NULL default '1',
templateid smallint(6) unsigned NOT NULL default '0',
PRIMARY KEY (styleid),
KEY themename (name)
);
INSERT INTO cdb_styles VALUES (1, 'Default Style', 1, 1);
DROP TABLE IF EXISTS cdb_stylevars;
CREATE TABLE cdb_stylevars (
stylevarid smallint(6) unsigned NOT NULL auto_increment,
styleid smallint(6) unsigned NOT NULL default '0',
variable text NOT NULL,
substitute text NOT NULL,
PRIMARY KEY (stylevarid),
KEY styleid (styleid)
);
INSERT INTO cdb_stylevars VALUES (1, 1, 'bgcolor', '#E9EDF7');
INSERT INTO cdb_stylevars VALUES (2, 1, 'altbg1', '#F8F9FC');
INSERT INTO cdb_stylevars VALUES (3, 1, 'altbg2', '#FFFFFF');
INSERT INTO cdb_stylevars VALUES (4, 1, 'link', '#003366');
INSERT INTO cdb_stylevars VALUES (5, 1, 'bordercolor', '#DDE3EC');
INSERT INTO cdb_stylevars VALUES (6, 1, 'headercolor', 'headerbg.gif');
INSERT INTO cdb_stylevars VALUES (7, 1, 'headertext', '#FFFFFF');
INSERT INTO cdb_stylevars VALUES (8, 1, 'catcolor', 'catbg.gif');
INSERT INTO cdb_stylevars VALUES (9, 1, 'tabletext', '#000000');
INSERT INTO cdb_stylevars VALUES (10, 1, 'text', '#000000');
INSERT INTO cdb_stylevars VALUES (11, 1, 'borderwidth', '1');
INSERT INTO cdb_stylevars VALUES (12, 1, 'tablewidth', '99%');
INSERT INTO cdb_stylevars VALUES (13, 1, 'tablespace', '4');
INSERT INTO cdb_stylevars VALUES (14, 1, 'font', 'Tahoma, Verdana');
INSERT INTO cdb_stylevars VALUES (15, 1, 'fontsize', '12px');
INSERT INTO cdb_stylevars VALUES (16, 1, 'nobold', '0');
INSERT INTO cdb_stylevars VALUES (17, 1, 'boardimg', 'logo.gif');
INSERT INTO cdb_stylevars VALUES (18, 1, 'imgdir', 'images/default');
INSERT INTO cdb_stylevars VALUES (19, 1, 'smdir', 'images/smilies');
INSERT INTO cdb_stylevars VALUES (20, 1, 'cattext', '#000000');
INSERT INTO cdb_stylevars VALUES (21, 1, 'smfontsize', '11px');
INSERT INTO cdb_stylevars VALUES (22, 1, 'smfont', 'Tahoma');
INSERT INTO cdb_stylevars VALUES (23, 1, 'maintablespace', '8');
INSERT INTO cdb_stylevars VALUES (24, 1, 'maintablewidth', '98%');
INSERT INTO cdb_stylevars VALUES (25, 1, 'maintablecolor', '#FFFFFF');
DROP TABLE IF EXISTS cdb_subscriptions;
CREATE TABLE cdb_subscriptions (
uid mediumint(8) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
email varchar(60) NOT NULL default '',
lastnotify int(10) unsigned NOT NULL default '0',
PRIMARY KEY (uid,tid)
);
DROP TABLE IF EXISTS cdb_templates;
CREATE TABLE cdb_templates (
templateid smallint(6) unsigned NOT NULL auto_increment,
name varchar(30) NOT NULL default '',
charset varchar(30) NOT NULL default '',
directory varchar(100) NOT NULL default '',
copyright varchar(100) NOT NULL default '',
PRIMARY KEY (templateid)
);
INSERT INTO cdb_templates VALUES (1, 'Default', '$lang[charset]', './templates/default', 'Designed by ARTERY');
DROP TABLE IF EXISTS cdb_threads;
CREATE TABLE cdb_threads (
tid mediumint(8) unsigned NOT NULL auto_increment,
fid smallint(6) unsigned NOT NULL default '0',
creditsrequire smallint(6) unsigned NOT NULL default '0',
iconid smallint(6) unsigned NOT NULL default '0',
author char(15) NOT NULL default '',
authorid mediumint(8) unsigned NOT NULL default '0',
subject char(80) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
lastposter char(15) NOT NULL default '',
views mediumint(8) unsigned NOT NULL default '0',
replies smallint(6) unsigned NOT NULL default '0',
displayorder tinyint(1) NOT NULL default '0',
highlight tinyint(1) NOT NULL default '0',
digest tinyint(1) NOT NULL default '0',
poll tinyint(1) NOT NULL default '0',
attachment tinyint(1) NOT NULL default '0',
closed mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (tid),
KEY displayorder (fid,displayorder,lastpost),
KEY digest (digest)
);
DROP TABLE IF EXISTS cdb_usergroups;
CREATE TABLE cdb_usergroups (
groupid smallint(6) unsigned NOT NULL auto_increment,
type enum('system','special','member') NOT NULL default 'member',
grouptitle char(30) NOT NULL default '',
creditshigher int(10) NOT NULL default '0',
creditslower int(10) NOT NULL default '0',
stars tinyint(3) NOT NULL default '0',
color char(7) NOT NULL default '',
groupavatar char(60) NOT NULL default '',
allowcstatus tinyint(1) NOT NULL default '0',
allowavatar tinyint(1) NOT NULL default '0',
allowvisit tinyint(1) NOT NULL default '0',
allowview tinyint(1) NOT NULL default '0',
allowpost tinyint(1) NOT NULL default '0',
allowpostpoll tinyint(1) NOT NULL default '0',
allowgetattach tinyint(1) NOT NULL default '0',
allowpostattach tinyint(1) NOT NULL default '0',
allowvote tinyint(1) NOT NULL default '0',
allowsearch tinyint(1) NOT NULL default '0',
allowkarma tinyint(1) NOT NULL default '0',
allowinvisible tinyint(1) NOT NULL default '0',
allowsetviewperm tinyint(1) NOT NULL default '0',
allowsetattachperm tinyint(1) NOT NULL default '0',
allowhidecode tinyint(1) NOT NULL default '0',
allowsigbbcode tinyint(1) NOT NULL default '0',
allowsigimgcode tinyint(1) NOT NULL default '0',
allowviewstats tinyint(1) NOT NULL default '0',
maxpmnum smallint(6) unsigned NOT NULL default '0',
maxsigsize smallint(6) unsigned NOT NULL default '0',
maxkarmarate tinyint(3) unsigned NOT NULL default '0',
maxrateperday smallint(6) unsigned NOT NULL default '0',
maxattachsize int(10) unsigned NOT NULL default '0',
attachextensions char(255) NOT NULL default '',
PRIMARY KEY (groupid),
KEY creditsrange (creditshigher,creditslower)
);
INSERT INTO cdb_usergroups VALUES (1, 'system', '管理员', 0, 0, 9, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 200, 500, 30, 500, 2048000, '');
INSERT INTO cdb_usergroups VALUES (2, 'system', '超级版主', 0, 0, 8, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 120, 300, 15, 50, 2048000, '');
INSERT INTO cdb_usergroups VALUES (3, 'system', '版主', 0, 0, 7, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 0, 1, 1, 1, 1, 1, 1, 80, 200, 10, 30, 2048000, 'chm,pdf,zip,rar,tar,tgz,gif,jpg,jpeg,png');
INSERT INTO cdb_usergroups VALUES (4, 'system', '禁止发言', 0, 0, 0, '', '', 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (5, 'system', '禁止访问', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (6, 'system', 'IP 禁止', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (7, 'system', '游客', 0, 0, 0, '', '', 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (8, 'system', '等待验证用户', 0, 0, 0, '', '', 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 50, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (9, 'member', '社区乞丐', -9999999, 0, 0, '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (10, 'member', '新手上路', 0, 50, 1, '', '', 0, 0, 1, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 20, 80, 0, 0, 0, '');
INSERT INTO cdb_usergroups VALUES (11, 'member', '注册用户', 50, 200, 2, '', '', 0, 1, 1, 1, 1, 1, 1, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 1, 30, 100, 4, 10, 0, '');
INSERT INTO cdb_usergroups VALUES (12, 'member', '中级用户', 200, 500, 3, '', '', 0, 2, 1, 1, 1, 1, 1, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 1, 50, 150, 6, 15, 256000, 'gif,jpg,jpeg,png');
INSERT INTO cdb_usergroups VALUES (13, 'member', '高级用户', 500, 1000, 4, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 0, 0, 0, 0, 1, 0, 1, 60, 200, 10, 30, 512000, 'zip,rar,tar,tgz,gif,jpg,jpeg,png');
INSERT INTO cdb_usergroups VALUES (14, 'member', '银牌会员', 1000, 3000, 6, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 0, 1, 1, 0, 1, 1, 1, 80, 300, 15, 40, 1024000, 'chm,pdf,zip,rar,tar,tgz,gif,jpg,jpeg,png');
INSERT INTO cdb_usergroups VALUES (15, 'member', '金牌会员', 3000, 9999999, 8, '', '', 1, 3, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 0, 1, 1, 1, 100, 500, 20, 50, 2048000, 'chm,pdf,zip,rar,tar,tgz,gif,jpg,jpeg,png');
DROP TABLE IF EXISTS cdb_words;
CREATE TABLE cdb_words (
id smallint(6) unsigned NOT NULL auto_increment,
admin varchar(15) NOT NULL default '',
find varchar(60) NOT NULL default '',
replacement varchar(60) NOT NULL default '',
PRIMARY KEY (id)
);
DROP TABLE IF EXISTS cdb_plugins;
CREATE TABLE cdb_plugins (
plug_id smallint(6) NOT NULL auto_increment,
plug_title varchar(255) NOT NULL default '',
plug_version varchar(255) NOT NULL default '',
plug_author varchar(255) NOT NULL default '0',
plug_key varchar(255) NOT NULL default '',
plug_stats tinyint(1) NOT NULL default '0',
plug_cp varchar(255) NOT NULL default '',
plug_tables varchar(255) NOT NULL default '',
plug_license text NOT NULL,
plug_desc text NOT NULL,
PRIMARY KEY (plug_id),
KEY plug_keyword (plug_key)
);
DROP TABLE IF EXISTS cdb_plugins_settings;
CREATE TABLE cdb_plugins_settings (
conf_id int(10) unsigned NOT NULL auto_increment,
conf_title varchar(255) NOT NULL default '',
conf_desc text NOT NULL,
conf_group varchar(255) NOT NULL default '',
conf_type varchar(255) NOT NULL default '',
conf_key varchar(255) NOT NULL default '',
conf_value text NOT NULL,
conf_extra text NOT NULL,
conf_position smallint(3) unsigned NOT NULL default '0',
conf_cached tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (conf_id),
KEY conf_group (conf_group)
);

复制代码

		自动登录	找回密码
密码			立即注册