From e6ec1e8a20f4ec9da75501b409629f30be67f2b6 Mon Sep 17 00:00:00 2001
From: Aaron Schulz <aaron@users.mediawiki.org>
Date: Sun, 25 Feb 2007 19:49:51 +0000
Subject: [PATCH] *Add pr_id column to fix horrible breakage (Bug 9103)

---
 maintenance/postgres/tables.sql | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql
index 62e021e87a..a934d93262 100644
--- a/maintenance/postgres/tables.sql
+++ b/maintenance/postgres/tables.sql
@@ -109,7 +109,9 @@ CREATE TABLE pagecontent ( -- replaces reserved word 'text'
 );
 
 
+CREATE SEQUENCE pr_id_val;
 CREATE TABLE page_restrictions (
+  pr_id      INTEGER      NOT NULL  UNIQUE DEFAULT nextval('pr_id_val'),
   pr_page    INTEGER          NULL  REFERENCES page (page_id) ON DELETE CASCADE,
   pr_type    TEXT         NOT NULL,
   pr_level   TEXT         NOT NULL,
-- 
2.20.1