db.migration.V0.3__init.sql Maven / Gradle / Ivy
alter table client_forms rename column form_id to uuid;
alter table client_forms add column type varchar(25) NULL;
update client_forms set type='FORM';
alter table client_forms alter column type set not null;
alter table form_logs rename column form_id to uuid;
insert into client_forms(type, client_form_id, client_id, parent_uuid, uuid, sha1_hash, asset_id, data, inserted_date, updated_date)
select 'WORKFLOW', client_workflow_id, client_id, parent_uuid, uuid, sha1_hash, asset_id, data, inserted_date, updated_date from client_workflows;
drop table client_workflows;