Split down patch-actor-table.sql

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

diff --git a/maintenance/postgres/archives/patch-actor-table.sql b/maintenance/postgres/archives/patch-actor-table.sql
index 68e5d26..78f990f 100644 (file)
--- a/maintenance/postgres/archives/patch-actor-table.sql
+++ b/maintenance/postgres/archives/patch-actor-table.sql
@@ -1,7 +1,7 @@
 --
 -- patch-actor-table.sql
 --
--- T167246. Add an `actor` table and various columns (and temporary tables) to reference it.
+-- T167246. Add an `actor` table.
 
 CREATE SEQUENCE actor_actor_id_seq;
 CREATE TABLE actor (
@@ -11,14 +11,3 @@ CREATE TABLE actor (
 );
 CREATE UNIQUE INDEX actor_user ON actor (actor_user);
 CREATE UNIQUE INDEX actor_name ON actor (actor_name);
-
-CREATE TABLE revision_actor_temp (
-  revactor_rev INTEGER NOT NULL,
-  revactor_actor INTEGER NOT NULL,
-  revactor_timestamp TIMESTAMPTZ  NOT NULL,
-  revactor_page INTEGER          NULL  REFERENCES page (page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
-  PRIMARY KEY (revactor_rev, revactor_actor)
-);
-CREATE UNIQUE INDEX revactor_rev ON revision_actor_temp (revactor_rev);
-CREATE INDEX rev_actor_timestamp ON revision_actor_temp (revactor_actor,revactor_timestamp);
-CREATE INDEX rev_page_actor_timestamp ON revision_actor_temp (revactor_page,revactor_actor,revactor_timestamp);