www/wiki/maintenance/archives/patch-slot-origin.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
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);