-- Mufly 0.2.X to 0.2.4 database upgrade script

use mufly;

ALTER TABLE Transaction ADD COLUMN transactionComment VARCHAR(255) AFTER parent_id;
UPDATE Transaction SET transactionComment='' WHERE transactionComment is null;

ALTER TABLE Account ADD COLUMN isHidden BIT  NOT NULL AFTER accountNumber;
UPDATE Account SET isHidden=false;

commit;