X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/ffc0c0768c4d2dc9aae3d4e3be3cb5584e42a4ba..61925eaac13ef601879178d6343de9f9714f3da1:/services/api/db/structure.sql diff --git a/services/api/db/structure.sql b/services/api/db/structure.sql index bda4e5de87..fa4760d8a0 100644 --- a/services/api/db/structure.sql +++ b/services/api/db/structure.sql @@ -289,7 +289,8 @@ CREATE TABLE container_requests ( priority integer, expires_at timestamp without time zone, filters text, - updated_at timestamp without time zone NOT NULL + updated_at timestamp without time zone NOT NULL, + container_count integer DEFAULT 0 ); @@ -1069,7 +1070,7 @@ CREATE TABLE workflows ( modified_by_user_uuid character varying(255), name character varying(255), description text, - workflow text, + definition text, updated_at timestamp without time zone NOT NULL ); @@ -2410,7 +2411,7 @@ CREATE INDEX virtual_machines_search_index ON virtual_machines USING btree (uuid -- Name: workflows_full_text_search_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX workflows_full_text_search_idx ON workflows USING gin (to_tsvector('english'::regconfig, (((((((((((((' '::text || (COALESCE(uuid, ''::character varying))::text) || ' '::text) || (COALESCE(owner_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(modified_by_client_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(modified_by_user_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(name, ''::character varying))::text) || ' '::text) || COALESCE(description, ''::text)) || ' '::text) || COALESCE(workflow, ''::text)))); +CREATE INDEX workflows_full_text_search_idx ON workflows USING gin (to_tsvector('english'::regconfig, (((((((((((((' '::text || (COALESCE(uuid, ''::character varying))::text) || ' '::text) || (COALESCE(owner_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(modified_by_client_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(modified_by_user_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(name, ''::character varying))::text) || ' '::text) || COALESCE(description, ''::text)) || ' '::text) || COALESCE(definition, ''::text)))); -- @@ -2680,10 +2681,14 @@ INSERT INTO schema_migrations (version) VALUES ('20160506175108'); INSERT INTO schema_migrations (version) VALUES ('20160509143250'); -INSERT INTO schema_migrations (version) VALUES ('20160808151459'); - INSERT INTO schema_migrations (version) VALUES ('20160808151559'); INSERT INTO schema_migrations (version) VALUES ('20160819195557'); -INSERT INTO schema_migrations (version) VALUES ('20160819195725'); \ No newline at end of file +INSERT INTO schema_migrations (version) VALUES ('20160819195725'); + +INSERT INTO schema_migrations (version) VALUES ('20160901210110'); + +INSERT INTO schema_migrations (version) VALUES ('20160909181442'); + +INSERT INTO schema_migrations (version) VALUES ('20160926194129'); \ No newline at end of file