Skip to content

Latest commit

 

History

History
53 lines (46 loc) · 2 KB

编辑历史.md

File metadata and controls

53 lines (46 loc) · 2 KB
Raw

人物与角色的编辑历史

CREATE TABLE IF NOT EXISTS `chii_rev_history` (
  `rev_id` mediumint(8) unsigned NOT NULL,
  `rev_type` tinyint(3) unsigned NOT NULL COMMENT '条目，角色，人物',
  `rev_mid` mediumint(8) unsigned NOT NULL COMMENT '对应条目，人物的ID',
  `rev_text_id` mediumint(9) unsigned NOT NULL,
  `rev_dateline` int(10) unsigned NOT NULL,
  `rev_creator` mediumint(8) unsigned NOT NULL,
  `rev_edit_summary` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

rev_text_id：编辑信息的id rev_edit_summary：编辑注释 rev_creator：编辑用户的id rev_dateline：编辑时间

编辑信息

CREATE TABLE IF NOT EXISTS `chii_rev_text` (
  `rev_text_id` mediumint(9) unsigned NOT NULL,
  `rev_text` mediumblob NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

rev_text：经DEFLATE算法压缩的PHP序列化的字符串，解序列化后为以rev_id为key，人物与角色各字段的更新数据为value的Map

条目编辑历史

CREATE TABLE IF NOT EXISTS `chii_subject_revisions` (
  `rev_id` mediumint(8) unsigned NOT NULL,
  `rev_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '修订类型',
  `rev_subject_id` mediumint(8) unsigned NOT NULL,
  `rev_type_id` smallint(6) unsigned NOT NULL DEFAULT '0',
  `rev_creator` mediumint(8) unsigned NOT NULL,
  `rev_dateline` int(10) unsigned NOT NULL DEFAULT '0',
  `rev_name` varchar(80) NOT NULL,
  `rev_name_cn` varchar(80) NOT NULL,
  `rev_field_infobox` mediumtext NOT NULL,
  `rev_field_summary` mediumtext NOT NULL,
  `rev_vote_field` mediumtext NOT NULL,
  `rev_field_eps` mediumint(8) unsigned NOT NULL,
  `rev_edit_summary` varchar(200) NOT NULL,
  `rev_platform` smallint(6) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

rev_type_id：条目类型 rev_field_summary：条目概述 rev_field_infobox：Infobox格式的条目信息