BEGIN;
alter table phonetype add column prov_firmware varchar(255) not null default '';
alter table phonetype add column prov_bootloader varchar(255) not null default '';
update phonetype set firmware_version = '' where firmware_version IS NULL;
update phonetype set bootloader_version = '' where bootloader_version IS NULL;
update phonetype set prov_firmware = firmware_version;
update phonetype set prov_bootloader = bootloader_version;
alter table phonetype drop column firmware_version;
alter table phonetype drop column bootloader_version;

alter table phone add column prov_firmware varchar(255) not null default '';
alter table phone add column prov_bootloader varchar(255) not null default '';
COMMIT;
