X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/cf09cb606af8c08d07e99149734e903c11f497f6..5810ac278a9abac129369dafcdb42436452c74c8:/services/api/db/structure.sql diff --git a/services/api/db/structure.sql b/services/api/db/structure.sql index 16ac2c1427..df3e58fe9a 100644 --- a/services/api/db/structure.sql +++ b/services/api/db/structure.sql @@ -167,9 +167,10 @@ CREATE TABLE collections ( uuid character varying(255), manifest_text text, name character varying(255), - description character varying(255), + description character varying(524288), properties text, - expires_at date + expires_at date, + file_names character varying(8192) ); @@ -272,7 +273,7 @@ CREATE TABLE groups ( modified_by_user_uuid character varying(255), modified_at timestamp without time zone, name character varying(255) NOT NULL, - description text, + description character varying(524288), updated_at timestamp without time zone NOT NULL, group_class character varying(255) ); @@ -431,7 +432,7 @@ CREATE TABLE jobs ( supplied_script_version character varying(255), docker_image_locator character varying(255), priority integer DEFAULT 0 NOT NULL, - description text, + description character varying(524288), state character varying(255), arvados_sdk_version character varying(255) ); @@ -685,7 +686,7 @@ CREATE TABLE pipeline_instances ( properties text, state character varying(255), components_summary text, - description text, + description character varying(524288), started_at timestamp without time zone, finished_at timestamp without time zone ); @@ -725,7 +726,7 @@ CREATE TABLE pipeline_templates ( name character varying(255), components text, updated_at timestamp without time zone NOT NULL, - description text + description character varying(524288) ); @@ -1282,7 +1283,7 @@ ALTER TABLE ONLY virtual_machines -- Name: api_client_authorizations_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX api_client_authorizations_search_index ON api_client_authorizations USING btree (api_token, created_by_ip_address, last_used_by_ip_address, default_owner_uuid, scopes); +CREATE INDEX api_client_authorizations_search_index ON api_client_authorizations USING btree (api_token, created_by_ip_address, last_used_by_ip_address, default_owner_uuid); -- @@ -1296,7 +1297,7 @@ CREATE INDEX api_clients_search_index ON api_clients USING btree (uuid, owner_uu -- Name: authorized_keys_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX authorized_keys_search_index ON authorized_keys USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, key_type, authorized_user_uuid, public_key); +CREATE INDEX authorized_keys_search_index ON authorized_keys USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, key_type, authorized_user_uuid); -- @@ -1310,7 +1311,7 @@ CREATE UNIQUE INDEX collection_owner_uuid_name_unique ON collections USING btree -- Name: collections_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX collections_search_index ON collections USING btree (owner_uuid, modified_by_client_uuid, modified_by_user_uuid, portable_data_hash, redundancy_confirmed_by_client_uuid, uuid, manifest_text, name, description, properties); +CREATE INDEX collections_search_index ON collections USING btree (owner_uuid, modified_by_client_uuid, modified_by_user_uuid, portable_data_hash, redundancy_confirmed_by_client_uuid, uuid, name, description, file_names); -- @@ -1331,7 +1332,7 @@ CREATE INDEX groups_search_index ON groups USING btree (uuid, owner_uuid, modifi -- Name: humans_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX humans_search_index ON humans USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, properties); +CREATE INDEX humans_search_index ON humans USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid); -- @@ -1982,14 +1983,14 @@ CREATE UNIQUE INDEX index_virtual_machines_on_uuid ON virtual_machines USING btr -- Name: job_tasks_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX job_tasks_search_index ON job_tasks USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, job_uuid, parameters, output, created_by_job_task_uuid); +CREATE INDEX job_tasks_search_index ON job_tasks USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, job_uuid, created_by_job_task_uuid); -- -- Name: jobs_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX jobs_search_index ON jobs USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, submit_id, script, script_version, script_parameters, cancelled_by_client_uuid, cancelled_by_user_uuid, output, is_locked_by_uuid, log, tasks_summary, runtime_constraints, repository, supplied_script_version, docker_image_locator, description, state, arvados_sdk_version); +CREATE INDEX jobs_search_index ON jobs USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, submit_id, script, script_version, cancelled_by_client_uuid, cancelled_by_user_uuid, output, is_locked_by_uuid, log, repository, supplied_script_version, docker_image_locator, description, state, arvados_sdk_version); -- @@ -2010,7 +2011,7 @@ CREATE INDEX keep_services_search_index ON keep_services USING btree (uuid, owne -- Name: links_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX links_search_index ON links USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, tail_uuid, link_class, name, head_uuid, properties); +CREATE INDEX links_search_index ON links USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, tail_uuid, link_class, name, head_uuid); -- @@ -2024,21 +2025,21 @@ CREATE UNIQUE INDEX links_tail_name_unique_if_link_class_name ON links USING btr -- Name: logs_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX logs_search_index ON logs USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, object_uuid, event_type, summary, properties, object_owner_uuid); +CREATE INDEX logs_search_index ON logs USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, object_uuid, event_type, object_owner_uuid); -- -- Name: nodes_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX nodes_search_index ON nodes USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, hostname, domain, ip_address, info, properties, job_uuid); +CREATE INDEX nodes_search_index ON nodes USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, hostname, domain, ip_address, job_uuid); -- -- Name: pipeline_instances_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX pipeline_instances_search_index ON pipeline_instances USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, pipeline_template_uuid, name, components, properties, state, components_summary, description); +CREATE INDEX pipeline_instances_search_index ON pipeline_instances USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, pipeline_template_uuid, name, state, description); -- @@ -2052,7 +2053,7 @@ CREATE UNIQUE INDEX pipeline_template_owner_uuid_name_unique ON pipeline_templat -- Name: pipeline_templates_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX pipeline_templates_search_index ON pipeline_templates USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, components, description); +CREATE INDEX pipeline_templates_search_index ON pipeline_templates USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, description); -- @@ -2066,14 +2067,14 @@ CREATE INDEX repositories_search_index ON repositories USING btree (uuid, owner_ -- Name: specimens_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX specimens_search_index ON specimens USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, material, properties); +CREATE INDEX specimens_search_index ON specimens USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, material); -- -- Name: traits_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX traits_search_index ON traits USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, properties); +CREATE INDEX traits_search_index ON traits USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name); -- @@ -2087,7 +2088,7 @@ CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (v -- Name: users_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX users_search_index ON users USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, email, first_name, last_name, identity_url, prefs, default_owner_uuid); +CREATE INDEX users_search_index ON users USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, email, first_name, last_name, identity_url, default_owner_uuid); -- @@ -2309,4 +2310,8 @@ INSERT INTO schema_migrations (version) VALUES ('20141111133038'); INSERT INTO schema_migrations (version) VALUES ('20141208164553'); +INSERT INTO schema_migrations (version) VALUES ('20141208174553'); + +INSERT INTO schema_migrations (version) VALUES ('20141208174653'); + INSERT INTO schema_migrations (version) VALUES ('20141208185217'); \ No newline at end of file