db.migration.v0.19.0.6__add_cleanup_param.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of agr_curation_api Show documentation

This software is for using the curation api as a library

There is a newer version: v0.35.0

ALTER TABLE public.bulkloadfile_aud
   ADD bulkloadcleanup character varying(255);
ALTER TABLE public.bulkloadfile
   ADD bulkloadcleanup character varying(255);

UPDATE public.bulkloadfile_aud SET bulkloadcleanup = 'YES';
UPDATE public.bulkloadfile SET bulkloadcleanup = 'YES';