X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/1aa3f43606ba5e31633c063851d25b8fab4b93e2..f79536fda9dc40f480383caa69a35663702b2ba4:/services/api/db/structure.sql diff --git a/services/api/db/structure.sql b/services/api/db/structure.sql index 4e3cd36344..e25a2a9605 100644 --- a/services/api/db/structure.sql +++ b/services/api/db/structure.sql @@ -297,7 +297,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 +1688,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 +2750,10 @@ 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 ('20170328215436'); + +INSERT INTO schema_migrations (version) VALUES ('20170330012505'); \ No newline at end of file