X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/f6bdb550ec87fd38f528f5eb67925d6bcf5af22f..77d9c05d89dabc9e9e9a15f46cd12c8ad61ed64e:/services/api/db/structure.sql diff --git a/services/api/db/structure.sql b/services/api/db/structure.sql index 4e3cd36344..5c592a264b 100644 --- a/services/api/db/structure.sql +++ b/services/api/db/structure.sql @@ -44,9 +44,7 @@ CREATE TABLE api_client_authorizations ( created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL, default_owner_uuid character varying(255), - scopes text DEFAULT '--- -- all -'::text NOT NULL, + scopes text DEFAULT '["all"]'::text, uuid character varying(255) NOT NULL ); @@ -297,7 +295,8 @@ CREATE TABLE container_requests ( scheduling_parameters text, output_uuid character varying(255), log_uuid character varying(255), - output_name character varying(255) DEFAULT NULL::character varying + output_name character varying(255) DEFAULT NULL::character varying, + output_ttl integer DEFAULT 0 NOT NULL ); @@ -1687,6 +1686,13 @@ CREATE INDEX index_collections_on_owner_uuid ON collections USING btree (owner_u CREATE UNIQUE INDEX index_collections_on_owner_uuid_and_name ON collections USING btree (owner_uuid, name) WHERE (is_trashed = false); +-- +-- Name: index_collections_on_portable_data_hash; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- + +CREATE INDEX index_collections_on_portable_data_hash ON collections USING btree (portable_data_hash); + + -- -- Name: index_collections_on_trash_at; Type: INDEX; Schema: public; Owner: -; Tablespace: -- @@ -2742,4 +2748,12 @@ INSERT INTO schema_migrations (version) VALUES ('20170105160301'); INSERT INTO schema_migrations (version) VALUES ('20170105160302'); -INSERT INTO schema_migrations (version) VALUES ('20170216170823'); \ No newline at end of file +INSERT INTO schema_migrations (version) VALUES ('20170216170823'); + +INSERT INTO schema_migrations (version) VALUES ('20170301225558'); + +INSERT INTO schema_migrations (version) VALUES ('20170319063406'); + +INSERT INTO schema_migrations (version) VALUES ('20170328215436'); + +INSERT INTO schema_migrations (version) VALUES ('20170330012505');