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


1
2
3
4
5
6
7
8
9

CREATE TABLE slots (
  slot_revision_id INTEGER   NOT NULL,
  slot_role_id     SMALLINT  NOT NULL,
  slot_content_id  INTEGER   NOT NULL,
  slot_origin INTEGER   NOT NULL,
  PRIMARY KEY (slot_revision_id, slot_role_id)
);

CREATE INDEX slot_revision_origin_role ON slots (slot_revision_id, slot_origin, slot_role_id);