maintenance/mssql/archives/patch-rev_text_id-default.sql

   1 --
   2 -- Adds a default value to the rev_text_id field in the revision table.
   3 -- This is to allow the Multi Content Revisions migration to happen where
   4 -- rows will have to be added to the revision table with no rev_text_id.
   5 --
   6 -- 2018-03-12
   7 --
   8
   9 ALTER TABLE /*_*/revision
  10   ADD CONSTRAINT DF_rev_text_id DEFAULT 0 FOR rev_text_id;