1 files changed, 19 insertions, 0 deletions
diff --git a/www/wiki/extensions/Translate/sql/revtag.sql b/www/wiki/extensions/Translate/sql/revtag.sql
new file mode 100644
index 00000000..0a05bf61
--- /dev/null
+++ b/www/wiki/extensions/Translate/sql/revtag.sql
@@ -0,0 +1,19 @@
+-- These tables could go into core someday, but not likely
+
+-- Revision tags
+CREATE TABLE /*$wgDBprefix*/revtag (
+  rt_type varbinary(60) NOT NULL,
+
+  -- Link to page.page_id
+  rt_page int NOT NULL,
+
+  -- Link to revision.rev_id
+  rt_revision int NOT NULL,
+
+  rt_value blob NULL
+) /*$wgDBTableOptions*/;
+-- Index for finding all revisions in a page with a given tag
+CREATE UNIQUE INDEX /*i*/rt_type_page_revision ON /*$wgDBprefix*/revtag
+(rt_type, rt_page, rt_revision);
+-- Index for finding the tags on a given revision
+CREATE INDEX /*i*/rt_revision_type ON /*$wgDBprefix*/revtag (rt_revision, rt_type);