Drop ct_tag column from change_tag table
[lhc/web/wiklou.git] / maintenance / postgres / archives / patch-drop-ct_tag.sql
1 -- T185355
2 ALTER TABLE /*_*/change_tag ALTER COLUMN ct_tag_id SET NOT NULL;
3
4 DROP INDEX /*i*/change_tag_rc_tag_nonuniq;
5 DROP INDEX /*i*/change_tag_log_tag_nonuniq;
6 DROP INDEX /*i*/change_tag_rev_tag_nonuniq;
7 DROP INDEX /*i*/change_tag_tag_id;
8
9 ALTER TABLE /*_*/change_tag DROP COLUMN ct_tag;
10