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

   1 CREATE TABLE slots (
   2   slot_revision_id INTEGER   NOT NULL,
   3   slot_role_id     SMALLINT  NOT NULL,
   4   slot_content_id  INTEGER   NOT NULL,
   5   slot_origin INTEGER   NOT NULL,
   6   PRIMARY KEY (slot_revision_id, slot_role_id)
   7 );
   8
   9 CREATE INDEX slot_revision_origin_role ON slots (slot_revision_id, slot_origin, slot_role_id);