Merge "Revert "Add executable rights for executable (bash) files""

[lhc/web/wiklou.git] / maintenance / postgres / archives / patch-protected_titles.sql

diff --git a/maintenance/postgres/archives/patch-protected_titles.sql b/maintenance/postgres/archives/patch-protected_titles.sql
index 0dc4c1b..93f10e4 100644 (file)
--- a/maintenance/postgres/archives/patch-protected_titles.sql
+++ b/maintenance/postgres/archives/patch-protected_titles.sql
@@ -1,11 +1,10 @@
 CREATE TABLE protected_titles (
   pt_namespace   SMALLINT    NOT NULL,
   pt_title       TEXT        NOT NULL,
-  pt_by          INTEGER     NOT NULL,
-  pt_reason      TEXT,
+  pt_user        INTEGER         NULL  REFERENCES mwuser(user_id) ON DELETE SET NULL,
+  pt_reason      TEXT            NULL,
   pt_timestamp   TIMESTAMPTZ NOT NULL,
   pt_expiry      TIMESTAMPTZ     NULL,
   pt_create_perm TEXT        NOT NULL DEFAULT ''
 );
 CREATE UNIQUE INDEX protected_titles_unique ON protected_titles(pt_namespace, pt_title);
-CREATE INDEX protected_titles_index ON protected_titles(pt_by, pt_timestamp);