maintenance/mssql/archives/patch-slot-origin.sql

   1 --
   2 -- Replace slot_inherited with slot_origin.
   3 --
   4 -- NOTE: There is no release that has slot_inherited. This is only needed to transition between
   5 -- snapshot versions of 1.30.
   6 --
   7 -- NOTE: No code that writes to the slots table was merge yet, the table is assumed to be empty.
   8 --
   9 DROP INDEX /*i*/slot_role_inherited ON /*_*/slots;
  10
  11 ALTER TABLE /*_*/slots DROP CONSTRAINT DF_slot_inherited, COLUMN slot_inherited;
  12 ALTER TABLE /*_*/slots ADD COLUMN slot_origin bigint NOT NULL;
  13
  14 CREATE INDEX /*i*/slot_revision_origin_role ON /*_*/slots (slot_revision_id, slot_origin, slot_role_id);