is_trashed boolean DEFAULT false NOT NULL,
storage_classes_desired jsonb DEFAULT '["default"]'::jsonb,
storage_classes_confirmed jsonb DEFAULT '[]'::jsonb,
- storage_classes_confirmed_at timestamp without time zone
+ storage_classes_confirmed_at timestamp without time zone,
+ current_version_uuid character varying,
+ version integer DEFAULT 1 NOT NULL,
+ preserve_version boolean DEFAULT false
);
log_uuid character varying(255),
output_name character varying(255) DEFAULT NULL::character varying,
output_ttl integer DEFAULT 0 NOT NULL,
- secret_mounts jsonb DEFAULT '{}'::jsonb
+ secret_mounts jsonb DEFAULT '{}'::jsonb,
+ runtime_token text
);
scheduling_parameters text,
secret_mounts jsonb DEFAULT '{}'::jsonb,
secret_mounts_md5 character varying DEFAULT '99914b932bd37a50b983c5e7c90ae93b'::character varying,
- runtime_status jsonb DEFAULT '{}'::jsonb
+ runtime_status jsonb DEFAULT '{}'::jsonb,
+ runtime_user_uuid text,
+ runtime_auth_scopes jsonb,
+ runtime_token text
);
-- Name: collections_search_index; Type: INDEX; Schema: public; Owner: -
--
- CREATE INDEX collections_search_index ON public.collections USING btree (owner_uuid, modified_by_client_uuid, modified_by_user_uuid, portable_data_hash, uuid, name);
+ CREATE INDEX collections_search_index ON public.collections USING btree (owner_uuid, modified_by_client_uuid, modified_by_user_uuid, portable_data_hash, uuid, name, current_version_uuid);
--
CREATE INDEX index_collections_on_created_at ON public.collections USING btree (created_at);
+ --
+ -- Name: index_collections_on_current_version_uuid_and_version; Type: INDEX; Schema: public; Owner: -
+ --
+
+ CREATE UNIQUE INDEX index_collections_on_current_version_uuid_and_version ON public.collections USING btree (current_version_uuid, version);
+
+
--
-- Name: index_collections_on_delete_at; Type: INDEX; Schema: public; Owner: -
--
-- Name: index_collections_on_owner_uuid_and_name; Type: INDEX; Schema: public; Owner: -
--
- CREATE UNIQUE INDEX index_collections_on_owner_uuid_and_name ON public.collections USING btree (owner_uuid, name) WHERE (is_trashed = false);
+ CREATE UNIQUE INDEX index_collections_on_owner_uuid_and_name ON public.collections USING btree (owner_uuid, name) WHERE ((is_trashed = false) AND ((current_version_uuid)::text = (uuid)::text));
--
INSERT INTO schema_migrations (version) VALUES ('20180904110712');
+ INSERT INTO schema_migrations (version) VALUES ('20180913175443');
+
+ INSERT INTO schema_migrations (version) VALUES ('20180915155335');
+
INSERT INTO schema_migrations (version) VALUES ('20180917205609');
+INSERT INTO schema_migrations (version) VALUES ('20181005192222');
+
+INSERT INTO schema_migrations (version) VALUES ('20181011184200');
+
+ INSERT INTO schema_migrations (version) VALUES ('20180919001158');
+
+ INSERT INTO schema_migrations (version) VALUES ('20181001175023');
+
+ INSERT INTO schema_migrations (version) VALUES ('20181004131141');