MediaWiki 1.17.0

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

diff --git a/maintenance/postgres/archives/patch-msg_resource.sql b/maintenance/postgres/archives/patch-msg_resource.sql
new file mode 100644 (file)
index 0000000..00d8207
--- /dev/null
+++ b/maintenance/postgres/archives/patch-msg_resource.sql
@@ -0,0 +1,8 @@
+CREATE TABLE msg_resource (
+       mr_resource TEXT NOT NULL,
+       mr_lang         TEXT NOT NULL,
+       mr_blob         TEXT NOT NULL,
+       mr_timestamp    TIMESTAMPTZ NOT NULL
+);
+
+CREATE UNIQUE INDEX mr_resource_lang_idx ON msg_resource (mr_resource, mr_lang);