maintenance/postgres/archives/patch-revision_actor_temp-table.sql

   1 CREATE TABLE revision_actor_temp (
   2   revactor_rev INTEGER NOT NULL,
   3   revactor_actor INTEGER NOT NULL,
   4   revactor_timestamp TIMESTAMPTZ  NOT NULL,
   5   revactor_page INTEGER          NULL  REFERENCES page (page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
   6   PRIMARY KEY (revactor_rev, revactor_actor)
   7 );
   8 CREATE UNIQUE INDEX revactor_rev ON revision_actor_temp (revactor_rev);
   9 CREATE INDEX rev_actor_timestamp ON revision_actor_temp (revactor_actor,revactor_timestamp);
  10 CREATE INDEX rev_page_actor_timestamp ON revision_actor_temp (revactor_page,revactor_actor,revactor_timestamp);