maintenance/mssql/archives/patch-change_tag-tag_id.sql

   1 --
   2 -- Add ctd_tag_id to change_tag table to normalize it
   3 --
   4 ALTER TABLE /*_*/change_tag
   5   ADD COLUMN ct_tag_id int NULL CONSTRAINT ctd_tag_id__fk FOREIGN KEY REFERENCES /*_*/change_tag_def(ctd_id);
   6
   7 CREATE INDEX /*i*/change_tag_tag_id_id ON /*_*/change_tag (ct_tag_id,ct_rc_id,ct_rev_id,ct_log_id);