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