maintenance/oracle/archives/patch-slots.sql

   1 CREATE TABLE &mw_prefix.slots (
   2   slot_revision_id NUMBER NOT NULL,
   3   slot_role_id NUMBER NOT NULL,
   4   slot_content_id NUMBER NOT NULL,
   5   slot_inherited CHAR(1) DEFAULT '0' NOT NULL
   6 );
   7
   8 ALTER TABLE &mw_prefix.slots ADD CONSTRAINT &mw_prefix.slots_pk PRIMARY KEY (slot_revision_id, slot_role_id);
   9
  10 CREATE INDEX &mw_prefix.slot_role_inherited ON &mw_prefix.slots (slot_revision_id, slot_role_id, slot_inherited);