discuz.sql

PHP论坛源码（请配合MYSQL和apache安装）

--
-- 表的结构 `cdb_regips`
--

DROP TABLE IF EXISTS cdb_regips;
CREATE TABLE cdb_regips (
  ip char(15) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  count smallint(6) NOT NULL default '0',
  KEY ip (ip)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_relatedthreads`
--

DROP TABLE IF EXISTS cdb_relatedthreads;
CREATE TABLE cdb_relatedthreads (
  tid mediumint(8) NOT NULL default '0',
  expiration int(10) NOT NULL default '0',
  keywords varchar(255) NOT NULL default '',
  relatedthreads text NOT NULL,
  PRIMARY KEY  (tid)
) TYPE=MyISAM;

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

--
-- 表的结构 `cdb_rsscaches`
--

DROP TABLE IF EXISTS cdb_rsscaches;
CREATE TABLE cdb_rsscaches (
  lastupdate int(10) unsigned NOT NULL default '0',
  fid smallint(6) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  forum char(50) NOT NULL default '',
  author char(15) NOT NULL default '',
  `subject` char(80) NOT NULL default '',
  description char(255) NOT NULL default '',
  KEY fid (fid,dateline)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_searchindex`
--

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)
) 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', '1');
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 ('bdaystatus', '1');
INSERT INTO cdb_settings VALUES ('boardlicensed', '0');
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 ('creditsnotify', '');
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 ('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_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 ('maxmodworksmonths', '3');
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 ('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 ('modworkstatus', '0');
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_keywords', '');
INSERT INTO cdb_settings VALUES ('qihoo_maxtopics', '10');
INSERT INTO cdb_settings VALUES ('qihoo_relatedthreads', '5');
INSERT INTO cdb_settings VALUES ('qihoo_summary', '1');
INSERT INTO cdb_settings VALUES ('qihoo_searchbox', '0');
INSERT INTO cdb_settings VALUES ('qihoo_status', '0');
INSERT INTO cdb_settings VALUES ('qihoo_topics', '');
INSERT INTO cdb_settings VALUES ('qihoo_validity', '1');
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 ('rssstatus', '1');
INSERT INTO cdb_settings VALUES ('rssttl', '60');
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 ('sitename', 'Comsenz Inc.');
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');
INSERT INTO cdb_settings VALUES ('rewritestatus', '0');
INSERT INTO cdb_settings VALUES ('watermarkquality', '80');

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

--
-- 表的结构 `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`
--