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;