discuz.sql

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

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

INSERT INTO cdb_members VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', 0, 1, 1, 0, '', 'hidden', 1150355501, '127.0.0.1', 0, 1150355547, 1150355501, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '[e-mail]', '0000-00-00', 0, 0, 0, 0, '', 0, 0, 1, 1, 0, '9999', 0, 0, 2, 0, 26);

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

--
-- 表的结构 `cdb_moderators`
--

DROP TABLE IF EXISTS cdb_moderators;
CREATE TABLE cdb_moderators (
  uid mediumint(8) unsigned NOT NULL default '0',
  fid smallint(6) unsigned NOT NULL default '0',
  displayorder tinyint(3) NOT NULL default '0',
  inherited tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (uid,fid)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_modworks`
--

DROP TABLE IF EXISTS cdb_modworks;
CREATE TABLE cdb_modworks (
  uid mediumint(8) unsigned NOT NULL default '0',
  modaction char(3) NOT NULL default '',
  dateline date NOT NULL default '2006-01-01',
  count smallint(6) unsigned NOT NULL default '0',
  posts smallint(6) unsigned NOT NULL default '0',
  KEY uid (uid,dateline)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_myposts`
--

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

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


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

--
-- 表的结构 `cdb_mythreads`
--

DROP TABLE IF EXISTS cdb_mythreads;
CREATE TABLE cdb_mythreads (
  uid mediumint(8) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) NOT NULL default '0',
  PRIMARY KEY  (uid,tid),
  KEY tid (tid,dateline)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_onlinelist`
--

DROP TABLE IF EXISTS cdb_onlinelist;
CREATE TABLE cdb_onlinelist (
  groupid smallint(6) unsigned NOT NULL default '0',
  displayorder tinyint(3) NOT NULL default '0',
  title varchar(30) NOT NULL default '',
  url varchar(30) NOT NULL default ''
) TYPE=MyISAM;

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

INSERT INTO cdb_onlinelist VALUES (1, 1, '管理员', 'online_admin.gif');
INSERT INTO cdb_onlinelist VALUES (2, 2, '超级版主', 'online_supermod.gif');
INSERT INTO cdb_onlinelist VALUES (3, 3, '版主', 'online_moderator.gif');
INSERT INTO cdb_onlinelist VALUES (0, 4, '会员', 'online_member.gif');

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

--
-- 表的结构 `cdb_onlinetime`
--

DROP TABLE IF EXISTS cdb_onlinetime;
CREATE TABLE cdb_onlinetime (
  uid mediumint(8) unsigned NOT NULL default '0',
  thismonth smallint(6) unsigned NOT NULL default '0',
  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 int(10) 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 int(10) unsigned NOT NULL default '0',
  netamount int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (tid,uid),
  KEY uid (uid),
  KEY authorid (authorid)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_pluginhooks`
--

DROP TABLE IF EXISTS cdb_pluginhooks;
CREATE TABLE cdb_pluginhooks (
  pluginhookid mediumint(8) unsigned NOT NULL auto_increment,
  pluginid smallint(6) unsigned NOT NULL default '0',
  available tinyint(1) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  description mediumtext NOT NULL,
  `code` mediumtext NOT NULL,
  PRIMARY KEY  (pluginhookid),
  KEY pluginid (pluginid),
  KEY available (available)
) TYPE=MyISAM;

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


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

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

DROP TABLE IF EXISTS cdb_pmsearchindex;
CREATE TABLE cdb_pmsearchindex (
  searchid int(10) unsigned NOT NULL auto_increment,
  keywords varchar(255) NOT NULL default '',
  searchstring varchar(255) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  expiration int(10) unsigned NOT NULL default '0',
  pms smallint(6) unsigned NOT NULL default '0',
  pmids text NOT NULL,
  PRIMARY KEY  (searchid)
) TYPE=MyISAM;

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


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

--
-- 表的结构 `cdb_polloptions`
--

DROP TABLE IF EXISTS cdb_polloptions;
CREATE TABLE cdb_polloptions (
  polloptionid int(10) unsigned NOT NULL auto_increment,
  tid mediumint(8) unsigned NOT NULL default '0',
  votes mediumint(8) unsigned NOT NULL default '0',
  displayorder tinyint(3) NOT NULL default '0',
  polloption varchar(80) NOT NULL default '',
  voterids mediumtext NOT NULL,
  PRIMARY KEY  (polloptionid),
  KEY tid (tid,displayorder)
) TYPE=MyISAM AUTO_INCREMENT=1;

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


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

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

DROP TABLE IF EXISTS cdb_polls;
CREATE TABLE cdb_polls (
  tid mediumint(8) unsigned NOT NULL default '0',
  multiple tinyint(1) NOT NULL default '0',
  visible tinyint(1) NOT NULL default '0',
  maxchoices tinyint(3) unsigned NOT NULL default '0',
  expiration int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (tid)
) TYPE=MyISAM;

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