discuz.sql

Discuz! 论坛软件系统 Discuz_TC_UTF8.rar

DROP TABLE IF EXISTS cdb_statvars;
CREATE TABLE cdb_statvars (
  `type` varchar(20) NOT NULL default '',
  variable varchar(20) NOT NULL default '',
  `value` mediumtext NOT NULL,
  PRIMARY KEY  (`type`,variable)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_statvars`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `cdb_styles`
-- 

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)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_styles`
-- 

INSERT INTO cdb_styles VALUES (1, '默认风格', 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',
  variable text NOT NULL,
  substitute text NOT NULL,
  PRIMARY KEY  (stylevarid),
  KEY styleid (styleid)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_stylevars`
-- 

INSERT INTO cdb_stylevars VALUES (1, 1, 'bgcolor', '#9EB6D8');
INSERT INTO cdb_stylevars VALUES (2, 1, 'altbg1', '#F8F8F8');
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', '#698CC3');
INSERT INTO cdb_stylevars VALUES (6, 1, 'headercolor', '#698CC3');
INSERT INTO cdb_stylevars VALUES (7, 1, 'headertext', '#FFFFFF');
INSERT INTO cdb_stylevars VALUES (8, 1, 'catcolor', '#EFEFEF');
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, 'msgfontsize', '12px');
INSERT INTO cdb_stylevars VALUES (17, 1, 'nobold', '');
INSERT INTO cdb_stylevars VALUES (18, 1, 'boardimg', 'logo.gif');
INSERT INTO cdb_stylevars VALUES (19, 1, 'imgdir', 'images/default');
INSERT INTO cdb_stylevars VALUES (20, 1, 'smdir', 'images/smilies');
INSERT INTO cdb_stylevars VALUES (21, 1, 'cattext', '#000000');
INSERT INTO cdb_stylevars VALUES (22, 1, 'smfontsize', '11px');
INSERT INTO cdb_stylevars VALUES (23, 1, 'smfont', 'Arial, Tahoma');
INSERT INTO cdb_stylevars VALUES (24, 1, 'maintablespace', '8');
INSERT INTO cdb_stylevars VALUES (25, 1, 'maintablewidth', '98%');
INSERT INTO cdb_stylevars VALUES (26, 1, 'maintablecolor', '#FFFFFF');
INSERT INTO cdb_stylevars VALUES (27, 1, 'innerborderwidth', '1');
INSERT INTO cdb_stylevars VALUES (28, 1, 'innerbordercolor', '#D6E0EF');

-- --------------------------------------------------------

-- 
-- 表的结构 `cdb_subscriptions`
-- 

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)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_subscriptions`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `cdb_templates`
-- 

DROP TABLE IF EXISTS cdb_templates;
CREATE TABLE cdb_templates (
  templateid smallint(6) unsigned NOT NULL auto_increment,
  name varchar(30) NOT NULL default '',
  `directory` varchar(100) NOT NULL default '',
  copyright varchar(100) NOT NULL default '',
  PRIMARY KEY  (templateid)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_templates`
-- 

INSERT INTO cdb_templates VALUES (1, '默认模板套系', './templates/default', '北京康盛世纪科技有限公司');

-- --------------------------------------------------------

-- 
-- 表的结构 `cdb_threads`
-- 

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',
  iconid smallint(6) unsigned NOT NULL default '0',
  typeid smallint(6) unsigned NOT NULL default '0',
  readperm tinyint(3) unsigned NOT NULL default '0',
  price smallint(6) 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 int(10) unsigned NOT NULL default '0',
  replies mediumint(8) 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',
  rate tinyint(1) NOT NULL default '0',
  blog tinyint(1) NOT NULL default '0',
  poll tinyint(1) NOT NULL default '0',
  attachment tinyint(1) NOT NULL default '0',
  moderated tinyint(1) NOT NULL default '0',
  closed mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY digest (digest),
  KEY displayorder (fid,displayorder,lastpost),
  KEY blog (blog,authorid,dateline),
  KEY typeid (fid,typeid,displayorder,lastpost)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_threads`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `cdb_threadsmod`
-- 

DROP TABLE IF EXISTS cdb_threadsmod;
CREATE TABLE cdb_threadsmod (
  tid mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  username char(15) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  `action` char(3) NOT NULL default '',
  PRIMARY KEY  (tid)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_threadsmod`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `cdb_threadtypes`
-- 

DROP TABLE IF EXISTS cdb_threadtypes;
CREATE TABLE cdb_threadtypes (
  typeid smallint(6) unsigned NOT NULL auto_increment,
  displayorder tinyint(3) NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  PRIMARY KEY  (typeid)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_threadtypes`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `cdb_usergroups`
-- 

DROP TABLE IF EXISTS cdb_usergroups;
CREATE TABLE cdb_usergroups (
  groupid smallint(6) unsigned NOT NULL auto_increment,
  radminid tinyint(3) NOT NULL default '0',
  `type` enum('system','special','member') NOT NULL default 'member',
  system char(8) NOT NULL default 'private',
  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 '',
  readaccess tinyint(3) unsigned NOT NULL default '0',
  allowvisit tinyint(1) NOT NULL default '0',
  allowpost tinyint(1) NOT NULL default '0',
  allowreply tinyint(1) NOT NULL default '0',
  allowpostpoll tinyint(1) NOT NULL default '0',
  allowdirectpost 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',
  allowmultigroups tinyint(1) NOT NULL default '0',
  allowsearch tinyint(1) NOT NULL default '0',
  allowavatar tinyint(1) NOT NULL default '0',
  allowcstatus tinyint(1) NOT NULL default '0',
  allowuseblog tinyint(1) NOT NULL default '0',
  allowinvisible tinyint(1) NOT NULL default '0',
  allowtransfer tinyint(1) NOT NULL default '0',
  allowsetreadperm tinyint(1) NOT NULL default '0',
  allowsetattachperm tinyint(1) NOT NULL default '0',
  allowhidecode tinyint(1) NOT NULL default '0',
  allowhtml tinyint(1) NOT NULL default '0',
  allowcusbbcode tinyint(1) NOT NULL default '0',
  allownickname tinyint(1) NOT NULL default '0',
  allowsigbbcode tinyint(1) NOT NULL default '0',
  allowsigimgcode tinyint(1) NOT NULL default '0',
  allowviewpro tinyint(1) NOT NULL default '0',
  allowviewstats tinyint(1) NOT NULL default '0',
  disableperiodctrl tinyint(1) NOT NULL default '0',
  reasonpm tinyint(1) NOT NULL default '0',
  maxprice smallint(6) unsigned NOT NULL default '0',
  maxpmnum smallint(6) unsigned NOT NULL default '0',
  maxsigsize smallint(6) unsigned NOT NULL default '0',
  maxattachsize mediumint(8) unsigned NOT NULL default '0',
  maxsizeperday int(10) unsigned NOT NULL default '0',
  attachextensions char(100) NOT NULL default '',
  raterange char(150) NOT NULL default '',
  PRIMARY KEY  (groupid),
  KEY creditsrange (creditshigher,creditslower)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_usergroups`
-- 

INSERT INTO cdb_usergroups VALUES (1, 1, 'system', 'private', '管理员', 0, 0, 9, '', '', 200, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 0, 30, 200, 500, 2048000, 0, '', '1	-30	30	500');
INSERT INTO cdb_usergroups VALUES (2, 2, 'system', 'private', '超级版主', 0, 0, 8, '', '', 150, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 0, 20, 120, 300, 2048000, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '1	-15	15	50');
INSERT INTO cdb_usergroups VALUES (3, 3, 'system', 'private', '版主', 0, 0, 7, '', '', 100, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 1, 1, 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 0, 10, 80, 200, 2048000, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '1	-10	10	30');
INSERT INTO cdb_usergroups VALUES (4, 0, 'system', 'private', '禁止发言', 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '');
INSERT INTO cdb_usergroups VALUES (5, 0, 'system', 'private', '禁止访问', 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '');
INSERT INTO cdb_usergroups VALUES (6, 0, 'system', 'private', '禁止 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '');
INSERT INTO cdb_usergroups VALUES (7, 0, 'system', 'private', '游客', 0, 0, 0, '', '', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '');
INSERT INTO cdb_usergroups VALUES (8, 0, 'system', 'private', '等待验证会员', 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, 1, 0, 0, 0, 0, 0, 0, 0, 50, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '');
INSERT INTO cdb_usergroups VALUES (9, 0, 'member', 'private', '乞丐', -9999999, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '');
INSERT INTO cdb_usergroups VALUES (10, 0, 'member', 'private', '新手上路', 0, 50, 1, '', '', 10, 1, 1, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 20, 80, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '');
INSERT INTO cdb_usergroups VALUES (11, 0, 'member', 'private', '注册会员', 50, 200, 2, '', '', 20, 1, 1, 1, 1, 0, 1, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 30, 100, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '0	-4	4	10');
INSERT INTO cdb_usergroups VALUES (12, 0, 'member', 'private', '中级会员', 200, 500, 3, '', '', 30, 1, 1, 1, 1, 0, 1, 0, 1, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 1, 0, 0, 0, 50, 150, 256000, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '0	-6	6	15');
INSERT INTO cdb_usergroups VALUES (13, 0, 'member', 'private', '高级会员', 500, 1000, 4, '', '', 50, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 3, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 1, 0, 0, 0, 60, 200, 512000, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '1	-10	10	30');
INSERT INTO cdb_usergroups VALUES (14, 0, 'member', 'private', '金牌会员', 1000, 3000, 6, '', '', 70, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 3, 1, 0, 0, 0, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 0, 0, 0, 80, 300, 1024000, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '1	-15	15	40');
INSERT INTO cdb_usergroups VALUES (15, 0, 'member', 'private', '论坛元老', 3000, 9999999, 8, '', '', 90, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 3, 1, 0, 1, 0, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 0, 0, 0, 100, 500, 2048000, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '1	-20	20	50');


-- --------------------------------------------------------

-- 
-- 表的结构 `cdb_validating`
-- 

DROP TABLE IF EXISTS cdb_validating;
CREATE TABLE cdb_validating (
  uid mediumint(8) unsigned NOT NULL default '0',
  submitdate int(10) unsigned NOT NULL default '0',
  moddate int(10) unsigned NOT NULL default '0',
  admin varchar(15) NOT NULL default '',
  submittimes tinyint(3) unsigned NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  message text NOT NULL,
  remark text NOT NULL,
  PRIMARY KEY  (uid),
  KEY `status` (`status`)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_validating`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `cdb_words`
-- 

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(255) NOT NULL default '',
  replacement varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `cdb_words`
--