discuz.sql

Discuz! 论坛软件系统 Discuz_TC_UTF8.rar

  receivecredits tinyint(1) NOT NULL default '0',
  send int(10) unsigned NOT NULL default '0',
  receive int(10) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  operation char(3) NOT NULL default '',
  KEY uid (uid,dateline)
) TYPE=MyISAM;

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


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

-- 
-- 表的结构 `cdb_failedlogins`
-- 

DROP TABLE IF EXISTS cdb_failedlogins;
CREATE TABLE cdb_failedlogins (
  ip char(15) NOT NULL default '',
  count tinyint(1) unsigned NOT NULL default '0',
  lastupdate int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (ip)
) TYPE=MyISAM;

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


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

-- 
-- 表的结构 `cdb_favorites`
-- 

DROP TABLE IF EXISTS cdb_favorites;
CREATE TABLE cdb_favorites (
  uid mediumint(8) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  KEY uid (uid)
) TYPE=MyISAM;

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


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

-- 
-- 表的结构 `cdb_forumfields`
-- 

DROP TABLE IF EXISTS cdb_forumfields;
CREATE TABLE cdb_forumfields (
  fid smallint(6) unsigned NOT NULL default '0',
  description text NOT NULL,
  `password` varchar(12) NOT NULL default '',
  icon varchar(255) NOT NULL default '',
  postcredits varchar(255) NOT NULL default '',
  replycredits varchar(255) NOT NULL default '',
  redirect varchar(255) NOT NULL default '',
  attachextensions varchar(255) NOT NULL default '',
  moderators text NOT NULL,
  rules text NOT NULL,
  threadtypes text NOT NULL,
  viewperm text NOT NULL,
  postperm text NOT NULL,
  replyperm text NOT NULL,
  getattachperm text NOT NULL,
  postattachperm text NOT NULL,
  PRIMARY KEY  (fid)
) TYPE=MyISAM;

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

INSERT INTO cdb_forumfields VALUES (1, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

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

-- 
-- 表的结构 `cdb_forumlinks`
-- 

DROP TABLE IF EXISTS cdb_forumlinks;
CREATE TABLE cdb_forumlinks (
  id smallint(6) unsigned NOT NULL auto_increment,
  displayorder tinyint(3) NOT NULL default '0',
  name varchar(100) NOT NULL default '',
  url varchar(100) NOT NULL default '',
  note varchar(200) NOT NULL default '',
  logo varchar(100) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

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

INSERT INTO cdb_forumlinks VALUES (1, 0, 'Discuz! 官方论坛', 'http://www.discuz.com', '提供最新 Discuz! 产品新闻、软件下载与技术交流', 'images/logo.gif');

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

-- 
-- 表的结构 `cdb_forums`
-- 

DROP TABLE IF EXISTS cdb_forums;
CREATE TABLE cdb_forums (
  fid smallint(6) unsigned NOT NULL auto_increment,
  fup smallint(6) unsigned NOT NULL default '0',
  `type` enum('group','forum','sub') NOT NULL default 'forum',
  name char(50) NOT NULL default '',
  `status` tinyint(1) NOT NULL default '0',
  displayorder tinyint(3) NOT NULL default '0',
  styleid smallint(6) unsigned NOT NULL default '0',
  threads mediumint(8) unsigned NOT NULL default '0',
  posts mediumint(8) unsigned NOT NULL default '0',
  todayposts mediumint(8) unsigned NOT NULL default '0',
  lastpost char(110) NOT NULL default '',
  allowsmilies tinyint(1) NOT NULL default '0',
  allowhtml tinyint(1) NOT NULL default '0',
  allowbbcode tinyint(1) NOT NULL default '0',
  allowimgcode tinyint(1) NOT NULL default '0',
  allowblog tinyint(1) NOT NULL default '0',
  allowtrade tinyint(1) NOT NULL default '0',
  alloweditrules tinyint(1) NOT NULL default '0',
  recyclebin tinyint(1) NOT NULL default '0',
  modnewposts tinyint(1) NOT NULL default '0',
  jammer tinyint(1) NOT NULL default '0',
  disablewatermark tinyint(1) NOT NULL default '0',
  inheritedmod tinyint(1) NOT NULL default '0',
  autoclose smallint(6) NOT NULL default '0',
  PRIMARY KEY  (fid),
  KEY forum (`status`,`type`,displayorder),
  KEY fup (fup)
) TYPE=MyISAM;

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

INSERT INTO cdb_forums VALUES (1, 0, 'forum', '默认论坛', 1, 0, 0, 0, 0, 0, '			', 1, 0, 1, 1, 1, 3, 0, 0, 0, 0, 0, 0, 0);

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

-- 
-- 表的结构 `cdb_medals`
-- 

DROP TABLE IF EXISTS cdb_medals;
CREATE TABLE cdb_medals (
  medalid smallint(6) unsigned NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  available tinyint(1) NOT NULL default '0',
  image varchar(30) NOT NULL default '',
  PRIMARY KEY  (medalid)
) TYPE=MyISAM;

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

INSERT INTO cdb_medals VALUES (1, 'Medal No.1', 0, 'medal1.gif');
INSERT INTO cdb_medals VALUES (2, 'Medal No.2', 0, 'medal2.gif');
INSERT INTO cdb_medals VALUES (3, 'Medal No.3', 0, 'medal3.gif');
INSERT INTO cdb_medals VALUES (4, 'Medal No.4', 0, 'medal4.gif');
INSERT INTO cdb_medals VALUES (5, 'Medal No.5', 0, 'medal5.gif');
INSERT INTO cdb_medals VALUES (6, 'Medal No.6', 0, 'medal6.gif');
INSERT INTO cdb_medals VALUES (7, 'Medal No.7', 0, 'medal7.gif');
INSERT INTO cdb_medals VALUES (8, 'Medal No.8', 0, 'medal8.gif');
INSERT INTO cdb_medals VALUES (9, 'Medal No.9', 0, 'medal9.gif');
INSERT INTO cdb_medals VALUES (10, 'Medal No.10', 0, 'medal10.gif');

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

-- 
-- 表的结构 `cdb_memberfields`
-- 

DROP TABLE IF EXISTS cdb_memberfields;
CREATE TABLE cdb_memberfields (
  uid mediumint(8) unsigned NOT NULL default '0',
  nickname varchar(30) NOT NULL default '',
  site varchar(75) NOT NULL default '',
  alipay varchar(50) NOT NULL default '',
  icq varchar(12) NOT NULL default '',
  qq varchar(12) NOT NULL default '',
  yahoo varchar(40) NOT NULL default '',
  msn varchar(40) NOT NULL default '',
  taobao varchar(40) NOT NULL default '',
  location varchar(30) NOT NULL default '',
  customstatus varchar(30) NOT NULL default '',
  medals varchar(255) NOT NULL default '',
  avatar varchar(255) NOT NULL default '',
  avatarwidth tinyint(3) unsigned NOT NULL default '0',
  avatarheight tinyint(3) unsigned NOT NULL default '0',
  bio text NOT NULL,
  signature text NOT NULL,
  sightml text NOT NULL,
  ignorepm text NOT NULL,
  groupterms text NOT NULL,
  authstr varchar(20) NOT NULL default '',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;

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

INSERT INTO cdb_memberfields VALUES (1, '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', '', '', '', '');

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

-- 
-- 表的结构 `cdb_members`
-- 

DROP TABLE IF EXISTS cdb_members;
CREATE TABLE cdb_members (
  uid mediumint(8) unsigned NOT NULL auto_increment,
  username char(15) NOT NULL default '',
  `password` char(32) NOT NULL default '',
  secques char(8) NOT NULL default '',
  gender tinyint(1) NOT NULL default '0',
  adminid tinyint(1) NOT NULL default '0',
  groupid smallint(6) unsigned NOT NULL default '0',
  groupexpiry int(10) unsigned NOT NULL default '0',
  extgroupids char(60) NOT NULL default '',
  regip char(15) NOT NULL default '',
  regdate int(10) unsigned NOT NULL default '0',
  lastip char(15) NOT NULL default '',
  lastvisit int(10) unsigned NOT NULL default '0',
  lastactivity int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  posts mediumint(8) unsigned NOT NULL default '0',
  digestposts smallint(6) unsigned NOT NULL default '0',
  oltime smallint(6) unsigned NOT NULL default '0',
  pageviews mediumint(8) unsigned NOT NULL default '0',
  credits int(10) NOT NULL default '0',
  extcredits1 int(10) NOT NULL default '0',
  extcredits2 int(10) NOT NULL default '0',
  extcredits3 int(10) NOT NULL default '0',
  extcredits4 int(10) NOT NULL default '0',
  extcredits5 int(10) NOT NULL default '0',
  extcredits6 int(10) NOT NULL default '0',
  extcredits7 int(10) NOT NULL default '0',
  extcredits8 int(10) NOT NULL default '0',
  avatarshowid int(10) unsigned NOT NULL default '0',
  email char(50) NOT NULL default '',
  bday date NOT NULL default '0000-00-00',
  sigstatus tinyint(1) NOT NULL default '0',
  tpp tinyint(3) unsigned NOT NULL default '0',
  ppp tinyint(3) unsigned NOT NULL default '0',
  styleid smallint(6) unsigned NOT NULL default '0',
  dateformat char(10) NOT NULL default '',
  timeformat tinyint(1) NOT NULL default '0',
  pmsound tinyint(1) NOT NULL default '0',
  showemail tinyint(1) NOT NULL default '0',
  newsletter tinyint(1) NOT NULL default '0',
  invisible tinyint(1) NOT NULL default '0',
  timeoffset char(4) NOT NULL default '',
  newpm tinyint(1) NOT NULL default '0',
  accessmasks tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (uid),
  UNIQUE KEY username (username),
  KEY email (email)
) TYPE=MyISAM;

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

INSERT INTO cdb_members VALUES (1, 'admin', '0cc175b9c0f1b6a831c399e269772661', '', 0, 1, 1, 0, '', 'hidden', 1127871817, '', 1127871817, 0, 1127871817, 0, 0, 0, 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);

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

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