MCR: replace slot_inherited with slot_origin

[lhc/web/wiklou.git] / maintenance / postgres / archives / patch-slots-table.sql

diff --git a/maintenance/postgres/archives/patch-slots-table.sql b/maintenance/postgres/archives/patch-slots-table.sql
index 9cad0d1..514921f 100644 (file)
--- a/maintenance/postgres/archives/patch-slots-table.sql
+++ b/maintenance/postgres/archives/patch-slots-table.sql
@@ -2,8 +2,8 @@ CREATE TABLE slots (
   slot_revision_id INTEGER   NOT NULL,
   slot_role_id     SMALLINT  NOT NULL,
   slot_content_id  INTEGER   NOT NULL,
-  slot_inherited   SMALLINT  NOT NULL  DEFAULT 0,
+  slot_origin INTEGER   NOT NULL,
   PRIMARY KEY (slot_revision_id, slot_role_id)
 );
 
-CREATE INDEX slot_role_inherited ON slots (slot_revision_id, slot_role_id, slot_inherited);
\ No newline at end of file
+CREATE INDEX slot_revision_origin_role ON slots (slot_revision_id, slot_origin, slot_role_id);