From f12dd21e080d0a17c7d3ccac313412ebafb93a72 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Sat, 10 Mar 2007 18:19:07 +0000 Subject: [PATCH] *Revert r20302, no use for this index --- maintenance/postgres/tables.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index fb53d872d7..9cafcb3324 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -121,7 +121,7 @@ CREATE TABLE page_restrictions ( pr_user INTEGER NULL, pr_expiry TIMESTAMPTZ NULL ); -CREATE UNIQUE INDEX pr_pagetype ON page_restrictions (pr_page,pr_type); +ALTER TABLE page_restrictions ADD CONSTRAINT page_restrictions_pk PRIMARY KEY (pr_page,pr_type); CREATE TABLE archive2 ( -- 2.20.1