summaryrefslogtreecommitdiff
path: root/maintenance/postgres/archives/patch-mediawiki_version.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/postgres/archives/patch-mediawiki_version.sql')
-rw-r--r--maintenance/postgres/archives/patch-mediawiki_version.sql18
1 files changed, 18 insertions, 0 deletions
diff --git a/maintenance/postgres/archives/patch-mediawiki_version.sql b/maintenance/postgres/archives/patch-mediawiki_version.sql
new file mode 100644
index 00000000..811b38a1
--- /dev/null
+++ b/maintenance/postgres/archives/patch-mediawiki_version.sql
@@ -0,0 +1,18 @@
+CREATE TABLE mediawiki_version (
+ type TEXT NOT NULL,
+ mw_version TEXT NOT NULL,
+ notes TEXT NULL,
+
+ pg_version TEXT NULL,
+ pg_dbname TEXT NULL,
+ pg_user TEXT NULL,
+ pg_port TEXT NULL,
+ mw_schema TEXT NULL,
+ ts2_schema TEXT NULL,
+ ctype TEXT NULL,
+
+ sql_version TEXT NULL,
+ sql_date TEXT NULL,
+ cdate TIMESTAMPTZ NOT NULL DEFAULT now()
+);
+