Index: trunk/phase3/maintenance/postgres/tables.sql |
— | — | @@ -121,7 +121,7 @@ |
122 | 122 | pr_user INTEGER NULL, |
123 | 123 | pr_expiry TIMESTAMPTZ NULL |
124 | 124 | ); |
125 | | -CREATE UNIQUE INDEX pr_pagetype ON page_restrictions (pr_page,pr_type); |
| 125 | +ALTER TABLE page_restrictions ADD CONSTRAINT page_restrictions_pk PRIMARY KEY (pr_page,pr_type); |
126 | 126 | |
127 | 127 | |
128 | 128 | CREATE TABLE archive2 ( |