From dba3ca83e44b812ab4adcea8561ee5edf5eb1b89 Mon Sep 17 00:00:00 2001
From: Alexandre Emsenhuber <ialex@users.mediawiki.org>
Date: Fri, 24 Apr 2009 08:49:29 +0000
Subject: Follow-up r49790: update the PostgreSQL schema

---
 maintenance/postgres/archives/patch-user_properties.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 maintenance/postgres/archives/patch-user_properties.sql

(limited to 'maintenance/postgres/archives/patch-user_properties.sql')

diff --git a/maintenance/postgres/archives/patch-user_properties.sql b/maintenance/postgres/archives/patch-user_properties.sql
new file mode 100644
index 000000000000..4c930c80c87c
--- /dev/null
+++ b/maintenance/postgres/archives/patch-user_properties.sql
@@ -0,0 +1,8 @@
+CREATE TABLE user_properties(
+  up_user BIGINT NOT NULL,
+  up_property TEXT NOT NULL,
+  up_value TEXT
+);
+
+CREATE UNIQUE INDEX user_properties_user_property on user_properties (up_user,up_property);
+CREATE INDEX user_properties_property on user_properties (up_property);
-- 
cgit v1.2.3

