📄 discuz.sql
字号:
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)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_searchindex`
--
-- --------------------------------------------------------
--
-- 表的结构 `cdb_sessions`
--
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',
lastolupdate int(10) unsigned NOT NULL default '0',
pageviews smallint(6) unsigned NOT NULL default '0',
seccode smallint(6) unsigned NOT NULL default '0',
fid smallint(6) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
bloguid mediumint(8) unsigned NOT NULL default '0',
UNIQUE KEY sid (sid),
KEY uid (uid),
KEY bloguid (bloguid)
) TYPE=Heap;
--
-- 导出表中的数据 `cdb_sessions`
--
INSERT INTO cdb_sessions VALUES (0x6d364758636b, 127, 0, 0, 1, 0, '', 7, 1, 0, 1, 1125560676, 0, 0, 8712, 0, 0, 0);
-- --------------------------------------------------------
--
-- 表的结构 `cdb_settings`
--
DROP TABLE IF EXISTS cdb_settings;
CREATE TABLE cdb_settings (
variable varchar(32) NOT NULL default '',
`value` text NOT NULL,
PRIMARY KEY (variable)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_settings`
--
INSERT INTO cdb_settings VALUES ('adminipaccess', '');
INSERT INTO cdb_settings VALUES ('archiverstatus', '1');
INSERT INTO cdb_settings VALUES ('attachimgpost', '1');
INSERT INTO cdb_settings VALUES ('attachrefcheck', '');
INSERT INTO cdb_settings VALUES ('attachsave', '0');
INSERT INTO cdb_settings VALUES ('authkey', 'BBsrBEukdwdbmCV');
INSERT INTO cdb_settings VALUES ('avatarshowdefault', '0');
INSERT INTO cdb_settings VALUES ('avatarshowheight', '200');
INSERT INTO cdb_settings VALUES ('avatarshowlink', '1');
INSERT INTO cdb_settings VALUES ('avatarshowpos', '3');
INSERT INTO cdb_settings VALUES ('avatarshowstatus', '0');
INSERT INTO cdb_settings VALUES ('avatarshowwidth', '135');
INSERT INTO cdb_settings VALUES ('bannedmessages', '1');
INSERT INTO cdb_settings VALUES ('bbclosed', '');
INSERT INTO cdb_settings VALUES ('bbinsert', '1');
INSERT INTO cdb_settings VALUES ('bbname', 'Discuz! Board');
INSERT INTO cdb_settings VALUES ('bbrules', '');
INSERT INTO cdb_settings VALUES ('bbrulestxt', '');
INSERT INTO cdb_settings VALUES ('censoremail', '');
INSERT INTO cdb_settings VALUES ('censoruser', '');
INSERT INTO cdb_settings VALUES ('closedreason', '');
INSERT INTO cdb_settings VALUES ('creditsformula', 'extcredits1');
INSERT INTO cdb_settings VALUES ('creditsformulaexp', '');
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', '0');
INSERT INTO cdb_settings VALUES ('dateformat', 'Y-n-j');
INSERT INTO cdb_settings VALUES ('debug', '1');
INSERT INTO cdb_settings VALUES ('delayviewcount', '');
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_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 ('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 ('fullmytopics', '1');
INSERT INTO cdb_settings VALUES ('globalstick', '0');
INSERT INTO cdb_settings VALUES ('gzipcompress', '');
INSERT INTO cdb_settings VALUES ('hideprivate', '1');
INSERT INTO cdb_settings VALUES ('hottopic', '10');
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 ('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 ('maxchargespan', '0');
INSERT INTO cdb_settings VALUES ('maxincperthread', '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 ('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', '0');
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 ('newbiespan', '0');
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 ('qihoostatus', '0');
INSERT INTO cdb_settings VALUES ('regctrl', '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 ('rssstatus', '1');
INSERT INTO cdb_settings VALUES ('rssttl', '60');
INSERT INTO cdb_settings VALUES ('searchbanperiods', '');
INSERT INTO cdb_settings VALUES ('searchbox', '0');
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 ('sitename', 'Comsenz Technology Ltd');
INSERT INTO cdb_settings VALUES ('siteurl', 'http://www.comsenz.com/');
INSERT INTO cdb_settings VALUES ('smcols', '3');
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 ('threadmaxpages', '1000');
INSERT INTO cdb_settings VALUES ('timeformat', 'h:i A');
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 ('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');
-- --------------------------------------------------------
--
-- 表的结构 `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');
-- --------------------------------------------------------
--
-- 表的结构 `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`
--
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -