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
)
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
);