X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/b50a3bcb38cf9e79416d8cc9b0d8b66249b3d473..3ef580c47029ff0fbf959b044f29c183f41cb609:/services/api/db/structure.sql diff --git a/services/api/db/structure.sql b/services/api/db/structure.sql index e25a2a9605..3e1fa3fae4 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 ); @@ -1730,6 +1728,13 @@ CREATE UNIQUE INDEX index_commits_on_repository_name_and_sha1 ON commits USING b CREATE INDEX index_container_requests_on_owner_uuid ON container_requests USING btree (owner_uuid); +-- +-- Name: index_container_requests_on_requesting_container_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- + +CREATE INDEX index_container_requests_on_requesting_container_uuid ON container_requests USING btree (requesting_container_uuid); + + -- -- Name: index_container_requests_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace: -- @@ -1807,6 +1812,13 @@ CREATE UNIQUE INDEX index_humans_on_uuid ON humans USING btree (uuid); CREATE INDEX index_job_tasks_on_created_at ON job_tasks USING btree (created_at); +-- +-- Name: index_job_tasks_on_created_by_job_task_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- + +CREATE INDEX index_job_tasks_on_created_by_job_task_uuid ON job_tasks USING btree (created_by_job_task_uuid); + + -- -- Name: index_job_tasks_on_job_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace: -- @@ -2038,6 +2050,13 @@ CREATE INDEX index_logs_on_event_type ON logs USING btree (event_type); CREATE INDEX index_logs_on_modified_at ON logs USING btree (modified_at); +-- +-- Name: index_logs_on_object_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- + +CREATE INDEX index_logs_on_object_owner_uuid ON logs USING btree (object_owner_uuid); + + -- -- Name: index_logs_on_object_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace: -- @@ -2754,6 +2773,15 @@ 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'); \ No newline at end of file +INSERT INTO schema_migrations (version) VALUES ('20170330012505'); + +INSERT INTO schema_migrations (version) VALUES ('20170419173031'); + +INSERT INTO schema_migrations (version) VALUES ('20170419173712'); + +INSERT INTO schema_migrations (version) VALUES ('20170419175801'); +