-- Mufly 0.1 to 0.2 database upgrade script

use mufly;

alter table Tag add column tagDesc varchar(255) after id;
update Tag set tagDesc=tagName;

alter table Transaction add column hasChilds bit not null after id;
update Transaction set hasChilds=false;

commit;