www/wiki/maintenance/oracle/archives/patch-slots.sql


1
2
3
4
5
6
7
8
9
10

CREATE TABLE &mw_prefix.slots (
  slot_revision_id NUMBER NOT NULL,
  slot_role_id NUMBER NOT NULL,
  slot_content_id NUMBER NOT NULL,
  slot_origin NUMBER NOT NULL
);

ALTER TABLE &mw_prefix.slots ADD CONSTRAINT &mw_prefix.slots_pk PRIMARY KEY (slot_revision_id, slot_role_id);

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