1 files changed, 10 insertions, 0 deletions
diff --git a/www/wiki/maintenance/oracle/archives/patch-slots.sql b/www/wiki/maintenance/oracle/archives/patch-slots.sql
new file mode 100644
index 00000000..fde35d5a
--- /dev/null
+++ b/www/wiki/maintenance/oracle/archives/patch-slots.sql
@@ -0,0 +1,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);