discuz.sql

论坛软件系统亦称电子公告板(BBS)系统

INSERT INTO cdb_settings VALUES ('creditspolicy', 'a:7:{s:4:"post";a:0:{}s:5:"reply";a:0:{}s:6:"digest";a:1:{i:1;i:10;}s:10:"postattach";a:0:{}s:9:"getattach";a:0:{}s:2:"pm";a:0:{}s:6:"search";a:0:{}}');
INSERT INTO cdb_settings VALUES ('creditstax', '0.2');
INSERT INTO cdb_settings VALUES ('creditstrans', '2');
INSERT INTO cdb_settings VALUES ('custombackup', '');
INSERT INTO cdb_settings VALUES ('dateformat', 'Y-n-j');
INSERT INTO cdb_settings VALUES ('debug', '1');
INSERT INTO cdb_settings VALUES ('delayviewcount', '0');
INSERT INTO cdb_settings VALUES ('deletereason', '');
INSERT INTO cdb_settings VALUES ('dotfolders', '');
INSERT INTO cdb_settings VALUES ('doublee', '1');
INSERT INTO cdb_settings VALUES ('dupkarmarate', '0');
INSERT INTO cdb_settings VALUES ('ec_account', '');
INSERT INTO cdb_settings VALUES ('ec_commision', '0');
INSERT INTO cdb_settings VALUES ('ec_id', '');
INSERT INTO cdb_settings VALUES ('ec_maxcredits', '1000');
INSERT INTO cdb_settings VALUES ('ec_maxcreditspermonth', '0');
INSERT INTO cdb_settings VALUES ('ec_mincredits', '0');
INSERT INTO cdb_settings VALUES ('ec_ratio', '0');
INSERT INTO cdb_settings VALUES ('ec_securitycode', '');
INSERT INTO cdb_settings VALUES ('editedby', '1');
INSERT INTO cdb_settings VALUES ('editoroptions', '1');
INSERT INTO cdb_settings VALUES ('edittimelimit', '');
INSERT INTO cdb_settings VALUES ('exchangemincredits', '100');
INSERT INTO cdb_settings VALUES ('extcredits', 'a:2:{i:1;a:3:{s:5:"title";s:4:"威望";s:12:"showinthread";s:0:"";s:9:"available";i:1;}i:2;a:3:{s:5:"title";s:4:"金钱";s:12:"showinthread";s:0:"";s:9:"available";i:1;}}');
INSERT INTO cdb_settings VALUES ('fastpost', '1');
INSERT INTO cdb_settings VALUES ('floodctrl', '15');
INSERT INTO cdb_settings VALUES ('forumjump', '1');
INSERT INTO cdb_settings VALUES ('globalstick', '1');
INSERT INTO cdb_settings VALUES ('gzipcompress', '0');
INSERT INTO cdb_settings VALUES ('hideprivate', '1');
INSERT INTO cdb_settings VALUES ('hottopic', '10');
INSERT INTO cdb_settings VALUES ('icp', '');
INSERT INTO cdb_settings VALUES ('initcredits', '0,0,0,0,0,0,0,0,0');
INSERT INTO cdb_settings VALUES ('ipaccess', '');
INSERT INTO cdb_settings VALUES ('ipregctrl', '');
INSERT INTO cdb_settings VALUES ('jscachelife', '1800');
INSERT INTO cdb_settings VALUES ('jsmenustatus', '15');
INSERT INTO cdb_settings VALUES ('jsrefdomains', '');
INSERT INTO cdb_settings VALUES ('jsstatus', '0');
INSERT INTO cdb_settings VALUES ('karmaratelimit', '0');
INSERT INTO cdb_settings VALUES ('loadctrl', '');
INSERT INTO cdb_settings VALUES ('losslessdel', '365');
INSERT INTO cdb_settings VALUES ('maxavatarpixel', '120');
INSERT INTO cdb_settings VALUES ('maxavatarsize', '20000');
INSERT INTO cdb_settings VALUES ('maxbdays', '0');
INSERT INTO cdb_settings VALUES ('maxchargespan', '0');
INSERT INTO cdb_settings VALUES ('maxfavorites', '100');
INSERT INTO cdb_settings VALUES ('maxincperthread', '0');
INSERT INTO cdb_settings VALUES ('maxmodworksmonths', '3');
INSERT INTO cdb_settings VALUES ('maxonlinelist', '0');
INSERT INTO cdb_settings VALUES ('maxonlines', '5000');
INSERT INTO cdb_settings VALUES ('maxpolloptions', '10');
INSERT INTO cdb_settings VALUES ('maxpostsize', '10000');
INSERT INTO cdb_settings VALUES ('maxsearchresults', '500');
INSERT INTO cdb_settings VALUES ('maxsigrows', '20');
INSERT INTO cdb_settings VALUES ('maxsmilies', '3');
INSERT INTO cdb_settings VALUES ('maxspm', '0');
INSERT INTO cdb_settings VALUES ('maxsubscriptions', '100');
INSERT INTO cdb_settings VALUES ('maxthreadads', '0');
INSERT INTO cdb_settings VALUES ('membermaxpages', '100');
INSERT INTO cdb_settings VALUES ('memberperpage', '25');
INSERT INTO cdb_settings VALUES ('memliststatus', '1');
INSERT INTO cdb_settings VALUES ('minpostsize', '10');
INSERT INTO cdb_settings VALUES ('moddisplay', 'flat');
INSERT INTO cdb_settings VALUES ('modratelimit', '0');
INSERT INTO cdb_settings VALUES ('modreasons', '广告/SPAM\r\n恶意灌水\r\n违规内容\r\n文不对题\r\n重复发帖\r\n\r\n我很赞同\r\n精品文章\r\n原创内容');
INSERT INTO cdb_settings VALUES ('modworkstatus', '0');
INSERT INTO cdb_settings VALUES ('myrecorddays', '30');
INSERT INTO cdb_settings VALUES ('newbiespan', '0');
INSERT INTO cdb_settings VALUES ('newsletter', '');
INSERT INTO cdb_settings VALUES ('nocacheheaders', '');
INSERT INTO cdb_settings VALUES ('oltimespan', '10');
INSERT INTO cdb_settings VALUES ('onlinerecord', '1	1040034649');
INSERT INTO cdb_settings VALUES ('passport_expire', '3600');
INSERT INTO cdb_settings VALUES ('passport_extcredits', '0');
INSERT INTO cdb_settings VALUES ('passport_key', '');
INSERT INTO cdb_settings VALUES ('passport_login_url', '');
INSERT INTO cdb_settings VALUES ('passport_logout_url', '');
INSERT INTO cdb_settings VALUES ('passport_register_url', '');
INSERT INTO cdb_settings VALUES ('passport_status', '');
INSERT INTO cdb_settings VALUES ('passport_url', '');
INSERT INTO cdb_settings VALUES ('postbanperiods', '');
INSERT INTO cdb_settings VALUES ('postmodperiods', '');
INSERT INTO cdb_settings VALUES ('postperpage', '10');
INSERT INTO cdb_settings VALUES ('pvfrequence', '60');
INSERT INTO cdb_settings VALUES ('qihoo_adminemail', '');
INSERT INTO cdb_settings VALUES ('qihoo_jammer', '1');
INSERT INTO cdb_settings VALUES ('qihoo_allsearch', '1');
INSERT INTO cdb_settings VALUES ('qihoo_keywords', '');
INSERT INTO cdb_settings VALUES ('qihoo_location', '1');
INSERT INTO cdb_settings VALUES ('qihoo_maxtopics', '10');
INSERT INTO cdb_settings VALUES ('qihoo_relatedthreads', '5');
INSERT INTO cdb_settings VALUES ('qihoo_relatedsort', '1');
INSERT INTO cdb_settings VALUES ('qihoo_searchbox', '6');
INSERT INTO cdb_settings VALUES ('qihoo_searchboxtxt', '输入关键词，快速搜索本论坛');
INSERT INTO cdb_settings VALUES ('qihoo_status', '1');
INSERT INTO cdb_settings VALUES ('qihoo_summary', '1');
INSERT INTO cdb_settings VALUES ('qihoo_topics', '');
INSERT INTO cdb_settings VALUES ('qihoo_validity', '1');
INSERT INTO cdb_settings VALUES ('qihoo_ustyle', '0');
INSERT INTO cdb_settings VALUES ('ratelogrecord', '5');
INSERT INTO cdb_settings VALUES ('regadvance', '0');
INSERT INTO cdb_settings VALUES ('regctrl', '0');
INSERT INTO cdb_settings VALUES ('regfloodctrl', '0');
INSERT INTO cdb_settings VALUES ('regstatus', '1');
INSERT INTO cdb_settings VALUES ('regverify', '0');
INSERT INTO cdb_settings VALUES ('reportpost', '1');
INSERT INTO cdb_settings VALUES ('rewritestatus', '0');
INSERT INTO cdb_settings VALUES ('rssstatus', '1');
INSERT INTO cdb_settings VALUES ('rssttl', '60');
INSERT INTO cdb_settings VALUES ('runwizard', '1');
INSERT INTO cdb_settings VALUES ('searchbanperiods', '');
INSERT INTO cdb_settings VALUES ('searchctrl', '30');
INSERT INTO cdb_settings VALUES ('seccodestatus', '0');
INSERT INTO cdb_settings VALUES ('seodescription', '');
INSERT INTO cdb_settings VALUES ('seohead', '');
INSERT INTO cdb_settings VALUES ('seokeywords', '');
INSERT INTO cdb_settings VALUES ('seotitle', '');
INSERT INTO cdb_settings VALUES ('showemail', '');
INSERT INTO cdb_settings VALUES ('showsettings', '7');
INSERT INTO cdb_settings VALUES ('sitename', 'Comsenz Inc.');
INSERT INTO cdb_settings VALUES ('siteurl', 'http://www.comsenz.com/');
INSERT INTO cdb_settings VALUES ('smcols', '4');
INSERT INTO cdb_settings VALUES ('smileyinsert', '1');
INSERT INTO cdb_settings VALUES ('starthreshold', '2');
INSERT INTO cdb_settings VALUES ('statscachelife', '180');
INSERT INTO cdb_settings VALUES ('statstatus', '');
INSERT INTO cdb_settings VALUES ('styleid', '1');
INSERT INTO cdb_settings VALUES ('stylejump', '0');
INSERT INTO cdb_settings VALUES ('subforumsindex', '');
INSERT INTO cdb_settings VALUES ('supe_maxupdateusers', '100');
INSERT INTO cdb_settings VALUES ('supe_siteurl', '');
INSERT INTO cdb_settings VALUES ('supe_sitename', '');
INSERT INTO cdb_settings VALUES ('supe_status', '0');
INSERT INTO cdb_settings VALUES ('supe_tablepre', '');
INSERT INTO cdb_settings VALUES ('threadmaxpages', '1000');
INSERT INTO cdb_settings VALUES ('threadsticky', '全局置顶,分类置顶,本版置顶');
INSERT INTO cdb_settings VALUES ('timeformat', 'H:i');
INSERT INTO cdb_settings VALUES ('timeoffset', '8');
INSERT INTO cdb_settings VALUES ('topicperpage', '20');
INSERT INTO cdb_settings VALUES ('transfermincredits', '1000');
INSERT INTO cdb_settings VALUES ('transsidstatus', '0');
INSERT INTO cdb_settings VALUES ('userstatusby', '1');
INSERT INTO cdb_settings VALUES ('visitbanperiods', '');
INSERT INTO cdb_settings VALUES ('visitedforums', '10');
INSERT INTO cdb_settings VALUES ('vtonlinestatus', '1');
INSERT INTO cdb_settings VALUES ('wapcharset', '2');
INSERT INTO cdb_settings VALUES ('wapdateformat', 'n/j');
INSERT INTO cdb_settings VALUES ('wapmps', '500');
INSERT INTO cdb_settings VALUES ('wapppp', '5');
INSERT INTO cdb_settings VALUES ('wapstatus', '1');
INSERT INTO cdb_settings VALUES ('waptpp', '10');
INSERT INTO cdb_settings VALUES ('watermarkquality', '80');
INSERT INTO cdb_settings VALUES ('watermarkstatus', '0');
INSERT INTO cdb_settings VALUES ('watermarktrans', '65');
INSERT INTO cdb_settings VALUES ('welcomemsg', '');
INSERT INTO cdb_settings VALUES ('welcomemsgtxt', '');
INSERT INTO cdb_settings VALUES ('whosonlinestatus', '1');
INSERT INTO cdb_settings VALUES ('indexname', 'index.php');
-- --------------------------------------------------------

--
-- 表的结构 `cdb_smilies`
--

DROP TABLE IF EXISTS cdb_smilies;
CREATE TABLE cdb_smilies (
  id smallint(6) unsigned NOT NULL auto_increment,
  displayorder tinyint(1) NOT NULL default '0',
  `type` enum('smiley','icon') NOT NULL default 'smiley',
  `code` varchar(30) NOT NULL default '',
  url varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

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

INSERT INTO cdb_smilies VALUES (1, 0, 'smiley', ':)', 'smile.gif');
INSERT INTO cdb_smilies VALUES (2, 0, 'smiley', ':(', 'sad.gif');
INSERT INTO cdb_smilies VALUES (3, 0, 'smiley', ':D', 'biggrin.gif');
INSERT INTO cdb_smilies VALUES (4, 0, 'smiley', ':''(', 'cry.gif');
INSERT INTO cdb_smilies VALUES (5, 0, 'smiley', ':@', 'huffy.gif');
INSERT INTO cdb_smilies VALUES (6, 0, 'smiley', ':o', 'shocked.gif');
INSERT INTO cdb_smilies VALUES (7, 0, 'smiley', ':P', 'tongue.gif');
INSERT INTO cdb_smilies VALUES (8, 0, 'smiley', ':$', 'shy.gif');
INSERT INTO cdb_smilies VALUES (9, 0, 'smiley', ';P', 'titter.gif');
INSERT INTO cdb_smilies VALUES (10, 0, 'smiley', ':L', 'sweat.gif');
INSERT INTO cdb_smilies VALUES (11, 0, 'smiley', ':Q', 'mad.gif');
INSERT INTO cdb_smilies VALUES (12, 0, 'smiley', ':lol', 'lol.gif');
INSERT INTO cdb_smilies VALUES (13, 0, 'smiley', ':hug:', 'hug.gif');
INSERT INTO cdb_smilies VALUES (14, 0, 'smiley', ':victory:', 'victory.gif');
INSERT INTO cdb_smilies VALUES (15, 0, 'smiley', ':time:', 'time.gif');
INSERT INTO cdb_smilies VALUES (16, 0, 'smiley', ':kiss:', 'kiss.gif');
INSERT INTO cdb_smilies VALUES (17, 0, 'smiley', ':handshake', 'handshake.gif');
INSERT INTO cdb_smilies VALUES (18, 0, 'smiley', ':call:', 'call.gif');
INSERT INTO cdb_smilies VALUES (19, 0, 'icon', '', 'icon1.gif');
INSERT INTO cdb_smilies VALUES (20, 0, 'icon', '', 'icon2.gif');
INSERT INTO cdb_smilies VALUES (21, 0, 'icon', '', 'icon3.gif');
INSERT INTO cdb_smilies VALUES (22, 0, 'icon', '', 'icon4.gif');
INSERT INTO cdb_smilies VALUES (23, 0, 'icon', '', 'icon5.gif');
INSERT INTO cdb_smilies VALUES (24, 0, 'icon', '', 'icon6.gif');
INSERT INTO cdb_smilies VALUES (25, 0, 'icon', '', 'icon7.gif');
INSERT INTO cdb_smilies VALUES (26, 0, 'icon', '', 'icon8.gif');
INSERT INTO cdb_smilies VALUES (27, 0, 'icon', '', 'icon9.gif');
INSERT INTO cdb_smilies VALUES (28, 0, 'smiley', ':loveliness:', 'loveliness.gif');
INSERT INTO cdb_smilies VALUES (29, 0, 'smiley', ':funk:', 'funk.gif');

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

--
-- 表的结构 `cdb_stats`
--

DROP TABLE IF EXISTS cdb_stats;
CREATE TABLE cdb_stats (
  `type` char(10) NOT NULL default '',
  variable char(10) NOT NULL default '',
  count int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`type`,variable)
) TYPE=MyISAM;

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

INSERT INTO cdb_stats VALUES ('total', 'hits', 1);
INSERT INTO cdb_stats VALUES ('total', 'members', 0);
INSERT INTO cdb_stats VALUES ('total', 'guests', 1);
INSERT INTO cdb_stats VALUES ('os', 'Windows', 1);
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', 'OS/2', 0);
INSERT INTO cdb_stats VALUES ('os', 'AIX', 0);
INSERT INTO cdb_stats VALUES ('os', 'Spiders', 0);
INSERT INTO cdb_stats VALUES ('os', 'Other', 0);
INSERT INTO cdb_stats VALUES ('browser', 'MSIE', 1);
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', 1);
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', 1);
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_statvars`
--

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','boardimg','logo.gif');
INSERT INTO cdb_stylevars VALUES ('2','1','nobold','0');
INSERT INTO cdb_stylevars VALUES ('3','1','msgfontsize','12px');
INSERT INTO cdb_stylevars VALUES ('4','1','fontsize','12px');
INSERT INTO cdb_stylevars VALUES ('5','1','font','Tahoma, Verdana');
INSERT INTO cdb_stylevars VALUES ('6','1','tablespace','4');
INSERT INTO cdb_stylevars VALUES ('7','1','tablewidth','98%');
INSERT INTO cdb_stylevars VALUES ('8','1','borderwidth','1');
INSERT INTO cdb_stylevars VALUES ('9','1','text','#333333');
INSERT INTO cdb_stylevars VALUES ('10','1','tabletext','#333333');
INSERT INTO cdb_stylevars VALUES ('11','1','catcolor','#FFFFD9');
INSERT INTO cdb_stylevars VALUES ('12','1','headertext','#154BA0');
INSERT INTO cdb_stylevars VALUES ('13','1','headercolor','header_bg.gif');
INSERT INTO cdb_stylevars VALUES ('14','1','