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_inherited   SMALLINT  NOT NULL  DEFAULT 0,
   6   PRIMARY KEY (slot_revision_id, slot_role_id)
   7 );
   8
   9 CREATE INDEX slot_role_inherited ON slots (slot_revision_id, slot_role_id, slot_inherited);