path: root/upgrades/dbpatches/1.6/mysql/patch/triggers.sql

update triggers set comments='' where comments is null;
alter table triggers modify comments blob DEFAULT '' NOT NULL;

alter table triggers add type integer DEFAULT '0' NOT NULL;