hdwiki.sql

hudong维客系统

-- Table: wiki_activate

CREATE TABLE wiki_activate (
  activate_id int(12) unsigned auto_increment NOT NULL,
  user_id int(12) unsigned NOT NULL,
  activate_str varchar(256) NOT NULL,
  state tinyint(1) NOT NULL default '1',
  primary key (activate_id)
)TYPE=MyISAM;


-- Table: wiki_attachment
CREATE TABLE wiki_attachment (
  attach_id int(12) unsigned auto_increment NOT NULL,
  doc_id int(12) unsigned NOT NULL,
  attach_title varchar(256) NOT NULL,
  attach_creator int(12) unsigned NOT NULL,
  attach_ip varchar(32) NOT NULL,
  attach_time datetime NOT NULL default '0000-00-00 00:00',
  attach_url varchar(512) NOT NULL,
  attach_type int(4) NOT NULL default '1',
  state tinyint(1) NOT NULL default '1',
  primary key (attach_id)
)TYPE=MyISAM;


-- Table: wiki_categorie

CREATE TABLE wiki_categorie (
  cat_id int(12) unsigned auto_increment NOT NULL,
  cat_name varchar(32) NOT NULL,
  cat_level int(6) unsigned NOT NULL default '1',
  cat_parent int(12) unsigned NOT NULL default '0',
  cat_intro varchar(512) NOT NULL default '',
  cat_navi varchar(512) NOT NULL default '',
  open_ico varchar(128) NOT NULL default '',
  close_ico varchar(128) NOT NULL default '',
  cat_order int(12) unsigned NOT NULL default '0',
  cat_doc_count int(12) unsigned NOT NULL default '0',
  state tinyint(1) NOT NULL default '1',
  primary key (cat_id)
)TYPE=MyISAM;



-- Table: wiki_doc

CREATE TABLE wiki_doc (
  doc_id int(12) unsigned auto_increment NOT NULL,
  cat_id int(12) unsigned NOT NULL,
  doc_title varchar(256) NOT NULL,
  doc_title_upper varchar(256) NOT NULL,
  doc_summary varchar(512) NOT NULL,
  doc_creator int(12) unsigned NOT NULL,
  doc_created_time datetime NOT NULL default '0000-00-00 00:00',
  doc_content mediumtext NOT NULL,
  doc_latest_edition_time datetime NOT NULL default '0000-00-00 00:00',
  doc_pic_count int(6) unsigned NOT NULL default '0',
  doc_tags varchar(256) NOT NULL,
  doc_seal_time datetime NOT NULL default '2005-07-18',
  doc_click_count int(12) unsigned NOT NULL default '0',
  doc_topic_count int(12) unsigned NOT NULL default '0',
  doc_reply_count int(12) unsigned NOT NULL default '0',
  doc_his_count int(12) unsigned NOT NULL default '1',
  doc_attendee_count int(12) unsigned NOT NULL default '1',
  doc_vote_count int(12) unsigned NOT NULL default '0',
  doc_first_img varchar(256) NOT NULL default '',
  doc_lock tinyint(1) NOT NULL default '0',
  state tinyint(1) NOT NULL default '1',
  primary key (doc_id)
)TYPE=MyISAM;

-- Table: wiki_his

CREATE TABLE wiki_his (
  his_id int(12) unsigned auto_increment NOT NULL,
  doc_id int(12) unsigned NOT NULL,
  doc_edition_no int(12) unsigned NOT NULL default '1',
  his_creator int(12) unsigned NOT NULL,
  his_created_time datetime NOT NULL default '0000-00-00 00:00',
  his_content mediumtext NOT NULL,
  his_ip varchar(32) NOT NULL,
  his_tags varchar(256) NOT NULL,
  his_kind tinyint(1) NOT NULL default '0',
  his_reason varchar(256) NOT NULL default '',
  his_coop tinyint(1) NOT NULL default '0',
  state tinyint(1) NOT NULL default '1',
  primary key (his_id)
)TYPE=MyISAM;


-- Table: wiki_lock

CREATE TABLE wiki_lock (
  doc_id int(12) unsigned NOT NULL,
  doc_locker int(12) unsigned NOT NULL,
  lock_time datetime NOT NULL default '0000-00-00 00:00',
  state tinyint(1) NOT NULL default '1',
  primary key (doc_id, doc_locker)
)TYPE=MyISAM;


-- Table: wiki_rank

CREATE TABLE wiki_rank (
  rank_id int(6) unsigned auto_increment NOT NULL,
  rank_title varchar(64) NOT NULL,
  rank_group varchar(32) NOT NULL,
  rank_min int(12) NOT NULL,
  rank_max int(12) NOT NULL,
  state tinyint(1) NOT NULL default '1',
  primary key (rank_id)
)TYPE=MyISAM;


-- Table: wiki_reply

CREATE TABLE wiki_reply (
  reply_id int(12) unsigned auto_increment NOT NULL,
  topic_id int(12) unsigned NOT NULL,
  reply_title varchar(256) NOT NULL,
  reply_content text NOT NULL,
  reply_creator int(12) unsigned NOT NULL,
  reply_ip varchar(32) NOT NULL,
  reply_anony tinyint(1) NOT NULL default '0',
  reply_time datetime NOT NULL default '0000-00-00 00:00',
  state tinyint(1) NOT NULL default '1',
  primary key (reply_id)
)TYPE=MyISAM;


-- Table: wiki_right

CREATE TABLE wiki_right (
  right_id int(12) unsigned NOT NULL,
  right_name varchar(32) NOT NULL,
  right_url varchar(512) NOT NULL,
  right_foward varchar(512) NOT NULL,
  state tinyint(1) NOT NULL default '1',
  primary key (right_id)
)TYPE=MyISAM;


-- Table: wiki_rightrel

CREATE TABLE wiki_rightrel (
  rightrel_id int(12) unsigned NOT NULL,
  role_id int(12) unsigned NOT NULL,
  right_id int(12) unsigned NOT NULL,
  state tinyint(1) NOT NULL default '1',
  primary key (rightrel_id)
)TYPE=MyISAM;


-- Table: wiki_role

CREATE TABLE wiki_role (
  role_id int(12) unsigned NOT NULL,
  role_name varchar(32) NOT NULL,
  state tinyint(1) NOT NULL default '1',
  primary key (role_id)
)TYPE=MyISAM;



-- Table: wiki_rolerel

CREATE TABLE wiki_rolerel (
  rolerel_id int(12) unsigned	auto_increment	NOT NULL,
  user_id int(12) unsigned NOT NULL,
  role_id int(12) unsigned NOT NULL,
  state tinyint(1) NOT NULL default '1',
  primary key (rolerel_id)
)TYPE=MyISAM;


-- Table: wiki_topic

CREATE TABLE wiki_topic (
  topic_id int(12) unsigned auto_increment NOT NULL,
  doc_id int(12) unsigned NOT NULL,
  topic_title varchar(256) NOT NULL,
  topic_content text NOT NULL,
  topic_creator int(12) unsigned NOT NULL,
  topic_ip varchar(32) NOT NULL,
  topic_anony tinyint(1) NOT NULL default '0',
  topic_created_time datetime NOT NULL default '0000-00-00 00:00',
  topic_view_count int(12) unsigned NOT NULL default '0',
  topic_reply_count int(12) unsigned NOT NULL default '0',
  last_reply_creator int(12) unsigned NOT NULL default '0',
  last_reply_ip varchar(32) NOT NULL,
  last_reply_anony tinyint(1) NOT NULL default '0',
  last_reply_time datetime NOT NULL default '0000-00-00 00:00',
  state tinyint(1) NOT NULL default '1',
  primary key (topic_id)
)TYPE=MyISAM;


-- Table: wiki_user

CREATE TABLE wiki_user (
  user_id int(12) unsigned auto_increment NOT NULL,
  user_email varchar(256) NOT NULL,
  user_nick varchar(32) NOT NULL,
  user_nick_upper varchar(32) NOT NULL,
  user_password varchar(256) NOT NULL,
  user_city int(6) unsigned NOT NULL default '1',
  user_sex tinyint(1) NOT NULL default '1',
  user_birthday varchar(10) NOT NULL default '',
  user_qq int(12) unsigned NOT NULL default '0',
  user_msn varchar(256) NOT NULL default '',
  user_homepage varchar(256) NOT NULL default '',
  user_intro varchar(512) NOT NULL default '',
  user_true_name varchar(64) NOT NULL default '',
  user_address varchar(256) NOT NULL default '',
  user_tel varchar(64) NOT NULL default '',
  user_reg_time datetime NOT NULL default '0000-00-00 00:00',
  user_click int(12) unsigned NOT NULL default '0',
  user_doc_count int(12) unsigned NOT NULL default '0',
  user_coop_count int(12) unsigned NOT NULL default '0',
  user_topic_count int(12) unsigned NOT NULL default '0',
  user_reply_count int(12) unsigned NOT NULL default '0',
  user_bonus int(12) NOT NULL default '0',
  user_small_ico varchar(256) NOT NULL default 'uploads/userface/face.gif',
  user_big_ico varchar(256) NOT NULL default 'uploads/userface/face.gif',
  last_login_ip varchar(32) NOT NULL,
  last_login_time datetime NOT NULL default '0000-00-00 00:00',
  state tinyint(1) NOT NULL default '1',
 primary key (user_id)
)TYPE=MyISAM;