discuz.sql

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

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

--
-- 表的结构 `cdb_posts`
--

DROP TABLE IF EXISTS cdb_posts;
CREATE TABLE cdb_posts (
  pid int(10) unsigned NOT NULL auto_increment,
  fid smallint(6) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  `first` tinyint(1) NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  authorid mediumint(8) unsigned NOT NULL default '0',
  `subject` varchar(80) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  message mediumtext NOT NULL,
  useip varchar(15) NOT NULL default '',
  invisible tinyint(1) NOT NULL default '0',
  anonymous tinyint(1) NOT NULL default '0',
  usesig tinyint(1) NOT NULL default '0',
  htmlon tinyint(1) NOT NULL default '0',
  bbcodeoff tinyint(1) NOT NULL default '0',
  smileyoff tinyint(1) NOT NULL default '0',
  parseurloff tinyint(1) NOT NULL default '0',
  attachment tinyint(1) NOT NULL default '0',
  rate smallint(6) NOT NULL default '0',
  ratetimes tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (pid),
  KEY fid (fid),
  KEY authorid (authorid),
  KEY dateline (dateline),
  KEY invisible (invisible),
  KEY displayorder (tid,invisible,dateline),
  KEY `first` (tid,`first`)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_profilefields`
--

DROP TABLE IF EXISTS cdb_profilefields;
CREATE TABLE cdb_profilefields (
  fieldid smallint(6) unsigned NOT NULL auto_increment,
  available tinyint(1) NOT NULL default '0',
  invisible tinyint(1) NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  size tinyint(3) unsigned NOT NULL default '0',
  displayorder smallint(6) NOT NULL default '0',
  required tinyint(1) NOT NULL default '0',
  unchangeable tinyint(1) NOT NULL default '0',
  showinthread tinyint(1) NOT NULL default '0',
  selective tinyint(1) NOT NULL default '0',
  choices text NOT NULL,
  PRIMARY KEY  (fieldid)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_promotions`
--

DROP TABLE IF EXISTS cdb_promotions;
CREATE TABLE cdb_promotions (
  ip char(15) NOT NULL default '',
  uid mediumint(8) NOT NULL default '0',
  username char(15) NOT NULL default '',
  PRIMARY KEY  (ip)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_pushedthreads`
--

DROP TABLE IF EXISTS cdb_pushedthreads;
CREATE TABLE cdb_pushedthreads (
  id mediumint(8) unsigned NOT NULL,
  tid mediumint(8) unsigned NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  `subject` char(80) NOT NULL,
  message text NOT NULL,
  PRIMARY KEY  (id),
  KEY displayorder (`status`,dateline)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_ranks`
--

DROP TABLE IF EXISTS cdb_ranks;
CREATE TABLE cdb_ranks (
  rankid smallint(6) unsigned NOT NULL auto_increment,
  ranktitle varchar(30) NOT NULL default '',
  postshigher mediumint(8) unsigned NOT NULL default '0',
  stars tinyint(3) NOT NULL default '0',
  color varchar(7) NOT NULL default '',
  PRIMARY KEY  (rankid)
) TYPE=MyISAM;

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

INSERT INTO cdb_ranks VALUES (1, '新生入学', 0, 1, '');
INSERT INTO cdb_ranks VALUES (2, '小试牛刀', 50, 2, '');
INSERT INTO cdb_ranks VALUES (3, '实习记者', 300, 5, '');
INSERT INTO cdb_ranks VALUES (4, '自由撰稿人', 1000, 4, '');
INSERT INTO cdb_ranks VALUES (5, '特聘作家', 3000, 5, '');

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

--
-- 表的结构 `cdb_ratelog`
--

DROP TABLE IF EXISTS cdb_ratelog;
CREATE TABLE cdb_ratelog (
  pid int(10) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  username char(15) NOT NULL default '',
  extcredits tinyint(1) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  score smallint(6) NOT NULL default '0',
  reason char(40) NOT NULL default '',
  KEY pid (pid,dateline),
  KEY dateline (dateline)
) TYPE=MyISAM;

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


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

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


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

--
-- 表的结构 `cdb_rewardlog`
--

DROP TABLE IF EXISTS cdb_rewardlog;
CREATE TABLE cdb_rewardlog (
  tid mediumint(8) unsigned NOT NULL default '0',
  authorid mediumint(8) unsigned NOT NULL default '0',
  answererid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned default '0',
  netamount int(10) unsigned NOT NULL default '0',
  KEY userid (authorid,answererid)
) TYPE=MyISAM;

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


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

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


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

--
-- 表的结构 `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 ('accessemail', '');
INSERT INTO cdb_settings VALUES ('adminipaccess', '');
INSERT INTO cdb_settings VALUES ('allowcsscache', '1');
INSERT INTO cdb_settings VALUES ('archiverstatus', '1');
INSERT INTO cdb_settings VALUES ('attachbanperiods', '');
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', '0');
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', '');