管理Discuz!代码分析的收集整理[2][表结构][2]

插入数据
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);
--cdb_smilies   表情信息表
DROP TABLE IF EXISTS cdb_smilies;
CREATE TABLE cdb_smilies (
id smallint(6) unsigned NOT NULL auto_increment,   --表情id
type enum('smiley','icon') NOT NULL default 'smiley',   --表情类型
code varchar(10) NOT NULL default '',     --smilies代码
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');
--cdb_stats 统计数据表
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);

--cdb_styles 风格
DROP TABLE IF EXISTS cdb_styles;
CREATE TABLE cdb_styles (
styleid smallint(6) unsigned NOT NULL auto_increment,   --风格id
name varchar(20) NOT NULL default '',     --风格的名称
available tinyint(1) NOT NULL default '1',    --是否可用
templateid smallint(6) unsigned NOT NULL default '0',   --对应的模板id
PRIMARY KEY (styleid),
KEY themename (name)
);

插入数据
INSERT INTO cdb_styles VALUES (1, 'Default Style', 1, 1);

--cdb_stylevars 风格的配置信息表
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',   --风格的id
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');
--cdb_subscrīptions 订阅信息表
DROP TABLE IF EXISTS cdb_subscrīptions;
CREATE TABLE cdb_subscrīptions (
uid mediumint(8) unsigned NOT NULL default '0',   --会员uid编号
tid mediumint(8) unsigned NOT NULL default '0',   --会员所订阅的主题id
email varchar(60) NOT NULL default '',    --email地址
lastnotify int(10) unsigned NOT NULL default '0',   --最后订阅主题记录
PRIMARY KEY (uid,tid)
);

--cdb_templates 模板
DROP TABLE IF EXISTS cdb_templates;
CREATE TABLE cdb_templates (
templateid smallint(6) unsigned NOT NULL auto_increment, --模板id
name varchar(30) NOT NULL default '',     --模板名称
charset varchar(30) NOT NULL default '',    --所用语言编码类型
directory varchar(100) NOT NULL default '',    --所在templates目录
copyright varchar(100) NOT NULL default '',    --模板版权信息
PRIMARY KEY (templateid)
);

插入数据
INSERT INTO cdb_templates VALUES (1, 'Default', '$lang[charset]',
'./templates/default', 'Designed by ARTERY');

--cdb_threads 主题资料表
DROP TABLE IF EXISTS cdb_threads;
CREATE TABLE cdb_threads (
tid mediumint(8) unsigned NOT NULL auto_increment,   --主题id
fid smallint(6) unsigned NOT NULL default '0',   --所在板块id
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',   --主题会员uid
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)
);

--cdb_usergroups 用户组数据表
DROP TABLE IF EXISTS cdb_usergroups;
CREATE TABLE cdb_usergroups (
groupid smallint(6) unsigned NOT NULL auto_increment,   --用户组id编号
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',   --使用hide代码
allowsigbbcode tinyint(1) NOT NULL default '0',   --使用Discuz!代码
allowsigimgcode tinyint(1) NOT NULL default '0',   --使用IMG代码
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');

--cdb_words 词语过滤表
DROP TABLE IF EXISTS cdb_words;
CREATE TABLE cdb_words (
id smallint(6) unsigned NOT NULL auto_increment, --自动id编号
admin varchar(15) NOT NULL default '',   --操作人记录
find varchar(60) NOT NULL default '',    --找到的不良词语
replacement varchar(60) NOT NULL default '',   --替换不良词语的内容
PRIMARY KEY (id)
);

--cdb_plugins 插件表
DROP TABLE IF EXISTS cdb_plugins;
CREATE TABLE cdb_plugins (
plug_id smallint(6) NOT NULL auto_increment,   --插件id
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)
);

--cdb_plugins_settings 插件配置表
DROP TABLE IF EXISTS cdb_plugins_settings;
CREATE TABLE cdb_plugins_settings (
conf_id int(10) unsigned NOT NULL auto_increment, --配置插件项目id
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)
);

转载于:https://www.cnblogs.com/changyou/archive/2010/01/08/1642636.html