diff options
Diffstat (limited to 'www/wiki/maintenance/archives/patch-slot-origin.sql')
-rw-r--r-- | www/wiki/maintenance/archives/patch-slot-origin.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/www/wiki/maintenance/archives/patch-slot-origin.sql b/www/wiki/maintenance/archives/patch-slot-origin.sql new file mode 100644 index 00000000..ee069231 --- /dev/null +++ b/www/wiki/maintenance/archives/patch-slot-origin.sql @@ -0,0 +1,15 @@ +-- +-- Replace slot_inherited with slot_origin. +-- +-- NOTE: There is no release that has slot_inherited. This is only needed to transition between +-- snapshot versions of 1.30. +-- +-- NOTE: No code that writes to the slots table was merged yet, the table is assumed to be empty. +-- +DROP INDEX /*i*/slot_role_inherited ON /*_*/slots; + +ALTER TABLE /*_*/slots + DROP COLUMN slot_inherited, + ADD COLUMN slot_origin bigint unsigned NOT NULL; + +CREATE INDEX /*i*/slot_revision_origin_role ON /*_*/slots (slot_revision_id, slot_origin, slot_role_id); |