db.migration.V0.6.0__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

update system_properties set value='0.6.0' where key='version';

create table oauth_code (
  code VARCHAR(256), authentication bytea
);

ALTER TABLE folder_forms ADD COLUMN status varchar(25) NULL;

update folder_forms set status='ACTIVE';

alter table folder_forms alter column status set not null;

drop table folder_logs;

ALTER TABLE folders_access ADD COLUMN updated_date timestamp NULL;

update folders_access set updated_date=inserted_date;

alter table folders_access alter column updated_date set not null;

ALTER TABLE folders_access ADD COLUMN status varchar(25) NULL;

update folders_access set status='ACTIVE';

alter table folders_access alter column status set not null;

---
--- users settings
---
CREATE TABLE public.user_settings  ( 
	user_setting_id		uuid PRIMARY KEY,
    user_id 			uuid NOT NULL,
    setting       		varchar(255) NOT NULL,
    value    		    varchar(255) NOT NULL
)
WITHOUT OIDS 
TABLESPACE pg_default;

CREATE INDEX user_settings_user_id_idx ON public.user_settings (user_id);