ALTER TABLE department ADD COLUMN parenttype varchar(10);
UPDATE department SET parenttype='company' WHERE parenttype IS NULL;
ALTER TABLE department ALTER parenttype SET NOT NULL;
ALTER TABLE department ALTER parenttype SET default 'company';

ALTER TABLE department ADD COLUMN parent integer;
UPDATE department SET parent=company WHERE parent IS NULL;
ALTER TABLE department ALTER parent SET NOT NULL;
ALTER TABLE department ALTER parent SET default '1';

