diff options
Diffstat (limited to 'www/wiki/maintenance/archives/patch-change_tag.sql')
-rw-r--r-- | www/wiki/maintenance/archives/patch-change_tag.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/www/wiki/maintenance/archives/patch-change_tag.sql b/www/wiki/maintenance/archives/patch-change_tag.sql new file mode 100644 index 00000000..3079a5bb --- /dev/null +++ b/www/wiki/maintenance/archives/patch-change_tag.sql @@ -0,0 +1,15 @@ +-- A table to track tags for revisions, logs and recent changes. +-- Andrew Garrett, 2009-01 +CREATE TABLE /*_*/change_tag ( + ct_rc_id int NULL, + ct_log_id int NULL, + ct_rev_id int NULL, + ct_tag varchar(255) NOT NULL, + ct_params BLOB NULL +) /*$wgDBTableOptions*/; + +CREATE UNIQUE INDEX /*i*/change_tag_rc_tag ON /*_*/change_tag (ct_rc_id,ct_tag); +CREATE UNIQUE INDEX /*i*/change_tag_log_tag ON /*_*/change_tag (ct_log_id,ct_tag); +CREATE UNIQUE INDEX /*i*/change_tag_rev_tag ON /*_*/change_tag (ct_rev_id,ct_tag); +-- Covering index, so we can pull all the info only out of the index. +CREATE INDEX /*i*/change_tag_tag_id ON /*_*/change_tag (ct_tag,ct_rc_id,ct_rev_id,ct_log_id); |