MediaWiki 1.17.0

[autoinstallsdev/mediawiki.git] / maintenance / postgres / archives / patch-change_tag.sql

diff --git a/maintenance/postgres/archives/patch-change_tag.sql b/maintenance/postgres/archives/patch-change_tag.sql
index 1f52c47490a05933950c04a653c061d5a1b709bd..89d74b63ece6b6cfcb07822ac84600ef4600496c 100644 (file)
--- a/maintenance/postgres/archives/patch-change_tag.sql
+++ b/maintenance/postgres/archives/patch-change_tag.sql
@@ -1,28 +1,11 @@
-
 CREATE TABLE change_tag (
-       ct_rc_id INTEGER NULL,
-       ct_log_id INTEGER NULL,
-       ct_rev_id INTEGER NULL,
-       ct_tag TEXT NOT NULL,
-       ct_params TEXT NULL
+  ct_rc_id   INTEGER      NULL,
+  ct_log_id  INTEGER      NULL,
+  ct_rev_id  INTEGER      NULL,
+  ct_tag     TEXT     NOT NULL,
+  ct_params  TEXT         NULL
 );
 CREATE UNIQUE INDEX change_tag_rc_tag ON change_tag(ct_rc_id,ct_tag);
 CREATE UNIQUE INDEX change_tag_log_tag ON change_tag(ct_log_id,ct_tag);
 CREATE UNIQUE INDEX change_tag_rev_tag ON change_tag(ct_rev_id,ct_tag);
 CREATE INDEX change_tag_tag_id ON change_tag(ct_tag,ct_rc_id,ct_rev_id,ct_log_id);
-
-
-CREATE TABLE tag_summary (
-       ts_rc_id INTEGER NULL,
-       ts_log_id INTEGER NULL,
-       ts_rev_id INTEGER NULL,
-       ts_tags TEXT NOT NULL
-);
-CREATE UNIQUE INDEX tag_summary_rc_id ON tag_summary(ts_rc_id);
-CREATE UNIQUE INDEX tag_summary_log_id ON tag_summary(ts_log_id);
-CREATE UNIQUE INDEX tag_summary_rev_id ON tag_summary(ts_rev_id);
-
-
-CREATE TABLE valid_tag (
-       vt_tag TEXT NOT NULL PRIMARY KEY
-);