db.migration.V0.3__init.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of formkiq-server Show documentation

Server-side integration for the FormKiQ ios application

There is a newer version: 0.6.1


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;