discuz.sql

Discuz! 论坛软件系统 Discuz_TC_UTF8.rar

  total mediumint(8) unsigned NOT NULL default '0',
  lastupdate int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;

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

INSERT INTO cdb_onlinetime VALUES (1, 30, 30, 0);

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

-- 
-- 表的结构 `cdb_orders`
-- 

DROP TABLE IF EXISTS cdb_orders;
CREATE TABLE cdb_orders (
  orderid char(32) NOT NULL default '',
  `status` char(3) NOT NULL default '',
  buyer char(50) NOT NULL default '',
  admin char(15) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  amount smallint(6) unsigned NOT NULL default '0',
  price float(7,2) unsigned NOT NULL default '0.00',
  submitdate int(10) unsigned NOT NULL default '0',
  confirmdate int(10) unsigned NOT NULL default '0',
  UNIQUE KEY orderid (orderid),
  KEY submitdate (submitdate),
  KEY uid (uid,submitdate)
) TYPE=MyISAM;

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


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

-- 
-- 表的结构 `cdb_paymentlog`
-- 

DROP TABLE IF EXISTS cdb_paymentlog;
CREATE TABLE cdb_paymentlog (
  uid mediumint(8) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  authorid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  amount smallint(6) NOT NULL default '0',
  netamount smallint(6) NOT NULL default '0',
  PRIMARY KEY  (tid,uid),
  KEY uid (uid),
  KEY authorid (authorid)
) TYPE=MyISAM;

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


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

-- 
-- 表的结构 `cdb_plugins`
-- 

DROP TABLE IF EXISTS cdb_plugins;
CREATE TABLE cdb_plugins (
  pluginid smallint(6) unsigned NOT NULL auto_increment,
  available tinyint(1) NOT NULL default '0',
  adminid tinyint(1) unsigned NOT NULL default '0',
  name varchar(40) NOT NULL default '',
  identifier varchar(40) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  datatables varchar(255) NOT NULL default '',
  `directory` varchar(100) NOT NULL default '',
  copyright varchar(100) NOT NULL default '',
  modules text NOT NULL,
  PRIMARY KEY  (pluginid),
  UNIQUE KEY identifier (identifier)
) TYPE=MyISAM;

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


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

-- 
-- 表的结构 `cdb_pluginvars`
-- 

DROP TABLE IF EXISTS cdb_pluginvars;
CREATE TABLE cdb_pluginvars (
  pluginvarid mediumint(8) unsigned NOT NULL auto_increment,
  pluginid smallint(6) unsigned NOT NULL default '0',
  displayorder tinyint(3) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  variable varchar(40) NOT NULL default '',
  `type` varchar(20) NOT NULL default 'text',
  `value` text NOT NULL,
  extra text NOT NULL,
  PRIMARY KEY  (pluginvarid),
  KEY pluginid (pluginid)
) TYPE=MyISAM;

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


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

-- 
-- 表的结构 `cdb_pms`
-- 

DROP TABLE IF EXISTS cdb_pms;
CREATE TABLE cdb_pms (
  pmid int(10) unsigned NOT NULL auto_increment,
  msgfrom varchar(15) NOT NULL default '',
  msgfromid mediumint(8) unsigned NOT NULL default '0',
  msgtoid mediumint(8) unsigned NOT NULL default '0',
  folder enum('inbox','outbox') NOT NULL default 'inbox',
  `new` tinyint(1) NOT NULL default '0',
  `subject` varchar(75) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  message text NOT NULL,
  PRIMARY KEY  (pmid),
  KEY msgtoid (msgtoid,folder,dateline),
  KEY msgfromid (msgfromid,folder,dateline)
) TYPE=MyISAM;

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


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

-- 
-- 表的结构 `cdb_polls`
-- 

DROP TABLE IF EXISTS cdb_polls;
CREATE TABLE cdb_polls (
  tid mediumint(8) unsigned NOT NULL default '0',
  pollopts mediumtext NOT NULL,
  PRIMARY KEY  (tid)
) TYPE=MyISAM;

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


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

-- 
-- 表的结构 `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',
  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_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(20) 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_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 '',