From ef4849a201277cc1fa39bca4834308e56ec3aa73 Mon Sep 17 00:00:00 2001
From: Brion Vibber <brion@users.mediawiki.org>
Date: Tue, 28 Apr 2009 18:42:26 +0000
Subject: Follow-up to r49803: use proper type and add an explicit foreign key
 reference for up_user->user_id as we have for other tables in the postgresql
 schema

---
 maintenance/postgres/archives/patch-user_properties.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(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
index 4c930c80c87c..b40fa85fce73 100644
--- a/maintenance/postgres/archives/patch-user_properties.sql
+++ b/maintenance/postgres/archives/patch-user_properties.sql
@@ -1,5 +1,5 @@
 CREATE TABLE user_properties(
-  up_user BIGINT NOT NULL,
+  up_user   INTEGER      NULL  REFERENCES mwuser(user_id) ON DELETE CASCADE,
   up_property TEXT NOT NULL,
   up_value TEXT
 );
-- 
cgit v1.2.3

