1 -- Copyright (C) The Arvados Authors. All rights reserved.
3 -- SPDX-License-Identifier: AGPL-3.0
5 SET statement_timeout = 0;
6 SET client_encoding = 'UTF8';
7 SET standard_conforming_strings = on;
8 SELECT pg_catalog.set_config('search_path', '', false);
9 SET check_function_bodies = false;
10 SET xmloption = content;
11 SET client_min_messages = warning;
14 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
17 CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
21 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
24 -- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
28 -- Name: pg_trgm; Type: EXTENSION; Schema: -; Owner: -
31 CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public;
35 -- Name: EXTENSION pg_trgm; Type: COMMENT; Schema: -; Owner: -
38 -- COMMENT ON EXTENSION pg_trgm IS 'text similarity measurement and index searching based on trigrams';
42 -- Name: compute_permission_subgraph(character varying, character varying, integer); Type: FUNCTION; Schema: public; Owner: -
45 CREATE FUNCTION public.compute_permission_subgraph(perm_origin_uuid character varying, starting_uuid character varying, starting_perm integer) RETURNS TABLE(user_uuid character varying, target_uuid character varying, val integer, traverse_owned boolean)
49 perm_from_start(perm_origin_uuid, target_uuid, val, traverse_owned) as (
50 select perm_origin_uuid, target_uuid, val, traverse_owned
51 from search_permission_graph(starting_uuid, starting_perm)),
53 edges(tail_uuid, head_uuid, val) as (
54 select * from permission_graph_edges()),
56 additional_perms(perm_origin_uuid, target_uuid, val, traverse_owned) as (
57 select edges.tail_uuid as perm_origin_uuid, ps.target_uuid, ps.val,
58 should_traverse_owned(ps.target_uuid, ps.val)
59 from edges, lateral search_permission_graph(edges.head_uuid, edges.val) as ps
60 where (not (edges.tail_uuid = perm_origin_uuid and
61 edges.head_uuid = starting_uuid)) and
62 edges.tail_uuid not in (select target_uuid from perm_from_start) and
63 edges.head_uuid in (select target_uuid from perm_from_start)),
65 partial_perms(perm_origin_uuid, target_uuid, val, traverse_owned) as (
66 select * from perm_from_start
68 select * from additional_perms
71 user_identity_perms(perm_origin_uuid, target_uuid, val, traverse_owned) as (
72 select users.uuid as perm_origin_uuid, ps.target_uuid, ps.val, ps.traverse_owned
73 from users, lateral search_permission_graph(users.uuid, 3) as ps
74 where (users.owner_uuid not in (select target_uuid from partial_perms) or
75 users.owner_uuid = users.uuid) and
76 users.uuid in (select target_uuid from partial_perms)
79 all_perms(perm_origin_uuid, target_uuid, val, traverse_owned) as (
80 select * from partial_perms
82 select * from user_identity_perms
85 select v.user_uuid, v.target_uuid, max(v.perm_level), bool_or(v.traverse_owned) from
86 (select materialized_permissions.user_uuid,
88 least(u.val, materialized_permissions.perm_level) as perm_level,
91 join materialized_permissions on (u.perm_origin_uuid = materialized_permissions.target_uuid)
92 where materialized_permissions.traverse_owned
94 select perm_origin_uuid as user_uuid, target_uuid, val as perm_level, traverse_owned
96 where perm_origin_uuid like '_____-tpzed-_______________') as v
97 group by v.user_uuid, v.target_uuid
102 -- Name: compute_trashed(); Type: FUNCTION; Schema: public; Owner: -
105 CREATE FUNCTION public.compute_trashed() RETURNS TABLE(uuid character varying, trash_at timestamp without time zone)
108 select ps.target_uuid as group_uuid, ps.trash_at from groups,
109 lateral project_subtree_with_trash_at(groups.uuid, groups.trash_at) ps
110 where groups.owner_uuid like '_____-tpzed-_______________'
115 -- Name: permission_graph_edges(); Type: FUNCTION; Schema: public; Owner: -
118 CREATE FUNCTION public.permission_graph_edges() RETURNS TABLE(tail_uuid character varying, head_uuid character varying, val integer)
121 select groups.owner_uuid, groups.uuid, (3) from groups
123 select users.owner_uuid, users.uuid, (3) from users
125 select links.tail_uuid,
128 WHEN links.name = 'can_read' THEN 1
129 WHEN links.name = 'can_login' THEN 1
130 WHEN links.name = 'can_write' THEN 2
131 WHEN links.name = 'can_manage' THEN 3
134 where links.link_class='permission'
139 -- Name: project_subtree_with_trash_at(character varying, timestamp without time zone); Type: FUNCTION; Schema: public; Owner: -
142 CREATE FUNCTION public.project_subtree_with_trash_at(starting_uuid character varying, starting_trash_at timestamp without time zone) RETURNS TABLE(target_uuid character varying, trash_at timestamp without time zone)
146 project_subtree(uuid, trash_at) as (
147 values (starting_uuid, starting_trash_at)
149 select groups.uuid, LEAST(project_subtree.trash_at, groups.trash_at)
150 from groups join project_subtree on (groups.owner_uuid = project_subtree.uuid)
152 select uuid, trash_at from project_subtree;
157 -- Name: search_permission_graph(character varying, integer); Type: FUNCTION; Schema: public; Owner: -
160 CREATE FUNCTION public.search_permission_graph(starting_uuid character varying, starting_perm integer) RETURNS TABLE(target_uuid character varying, val integer, traverse_owned boolean)
163 WITH RECURSIVE edges(tail_uuid, head_uuid, val) as (
164 select * from permission_graph_edges()
166 traverse_graph(target_uuid, val, traverse_owned) as (
167 values (starting_uuid, starting_perm,
168 should_traverse_owned(starting_uuid, starting_perm))
170 (select edges.head_uuid,
171 least(edges.val, traverse_graph.val,
172 case traverse_graph.traverse_owned
176 should_traverse_owned(edges.head_uuid, edges.val)
178 join traverse_graph on (traverse_graph.target_uuid = edges.tail_uuid)))
179 select target_uuid, max(val), bool_or(traverse_owned) from traverse_graph
180 group by (target_uuid) ;
185 -- Name: should_traverse_owned(character varying, integer); Type: FUNCTION; Schema: public; Owner: -
188 CREATE FUNCTION public.should_traverse_owned(starting_uuid character varying, starting_perm integer) RETURNS boolean
191 select starting_uuid like '_____-j7d0g-_______________' or
192 (starting_uuid like '_____-tpzed-_______________' and starting_perm >= 3);
196 SET default_tablespace = '';
198 SET default_with_oids = false;
201 -- Name: api_client_authorizations; Type: TABLE; Schema: public; Owner: -
204 CREATE TABLE public.api_client_authorizations (
206 api_token character varying(255) NOT NULL,
207 api_client_id integer NOT NULL,
208 user_id integer NOT NULL,
209 created_by_ip_address character varying(255),
210 last_used_by_ip_address character varying(255),
211 last_used_at timestamp without time zone,
212 expires_at timestamp without time zone,
213 created_at timestamp without time zone NOT NULL,
214 updated_at timestamp without time zone NOT NULL,
215 default_owner_uuid character varying(255),
216 scopes text DEFAULT '["all"]'::text,
217 uuid character varying(255) NOT NULL
222 -- Name: api_client_authorizations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
225 CREATE SEQUENCE public.api_client_authorizations_id_seq
234 -- Name: api_client_authorizations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
237 ALTER SEQUENCE public.api_client_authorizations_id_seq OWNED BY public.api_client_authorizations.id;
241 -- Name: api_clients; Type: TABLE; Schema: public; Owner: -
244 CREATE TABLE public.api_clients (
246 uuid character varying(255),
247 owner_uuid character varying(255),
248 modified_by_client_uuid character varying(255),
249 modified_by_user_uuid character varying(255),
250 modified_at timestamp without time zone,
251 name character varying(255),
252 url_prefix character varying(255),
253 created_at timestamp without time zone NOT NULL,
254 updated_at timestamp without time zone NOT NULL,
255 is_trusted boolean DEFAULT false
260 -- Name: api_clients_id_seq; Type: SEQUENCE; Schema: public; Owner: -
263 CREATE SEQUENCE public.api_clients_id_seq
272 -- Name: api_clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
275 ALTER SEQUENCE public.api_clients_id_seq OWNED BY public.api_clients.id;
279 -- Name: ar_internal_metadata; Type: TABLE; Schema: public; Owner: -
282 CREATE TABLE public.ar_internal_metadata (
283 key character varying NOT NULL,
284 value character varying,
285 created_at timestamp without time zone NOT NULL,
286 updated_at timestamp without time zone NOT NULL
291 -- Name: authorized_keys; Type: TABLE; Schema: public; Owner: -
294 CREATE TABLE public.authorized_keys (
296 uuid character varying(255) NOT NULL,
297 owner_uuid character varying(255) NOT NULL,
298 modified_by_client_uuid character varying(255),
299 modified_by_user_uuid character varying(255),
300 modified_at timestamp without time zone,
301 name character varying(255),
302 key_type character varying(255),
303 authorized_user_uuid character varying(255),
305 expires_at timestamp without time zone,
306 created_at timestamp without time zone NOT NULL,
307 updated_at timestamp without time zone NOT NULL
312 -- Name: authorized_keys_id_seq; Type: SEQUENCE; Schema: public; Owner: -
315 CREATE SEQUENCE public.authorized_keys_id_seq
324 -- Name: authorized_keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
327 ALTER SEQUENCE public.authorized_keys_id_seq OWNED BY public.authorized_keys.id;
331 -- Name: collections; Type: TABLE; Schema: public; Owner: -
334 CREATE TABLE public.collections (
336 owner_uuid character varying(255),
337 created_at timestamp without time zone NOT NULL,
338 modified_by_client_uuid character varying(255),
339 modified_by_user_uuid character varying(255),
340 modified_at timestamp without time zone,
341 portable_data_hash character varying(255),
342 replication_desired integer,
343 replication_confirmed_at timestamp without time zone,
344 replication_confirmed integer,
345 updated_at timestamp without time zone NOT NULL,
346 uuid character varying(255),
348 name character varying(255),
349 description character varying(524288),
351 delete_at timestamp without time zone,
353 trash_at timestamp without time zone,
354 is_trashed boolean DEFAULT false NOT NULL,
355 storage_classes_desired jsonb DEFAULT '["default"]'::jsonb,
356 storage_classes_confirmed jsonb DEFAULT '[]'::jsonb,
357 storage_classes_confirmed_at timestamp without time zone,
358 current_version_uuid character varying,
359 version integer DEFAULT 1 NOT NULL,
360 preserve_version boolean DEFAULT false,
361 file_count integer DEFAULT 0 NOT NULL,
362 file_size_total bigint DEFAULT 0 NOT NULL
367 -- Name: collections_id_seq; Type: SEQUENCE; Schema: public; Owner: -
370 CREATE SEQUENCE public.collections_id_seq
379 -- Name: collections_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
382 ALTER SEQUENCE public.collections_id_seq OWNED BY public.collections.id;
386 -- Name: container_requests; Type: TABLE; Schema: public; Owner: -
389 CREATE TABLE public.container_requests (
391 uuid character varying(255),
392 owner_uuid character varying(255),
393 created_at timestamp without time zone NOT NULL,
394 modified_at timestamp without time zone,
395 modified_by_client_uuid character varying(255),
396 modified_by_user_uuid character varying(255),
397 name character varying(255),
400 state character varying(255),
401 requesting_container_uuid character varying(255),
402 container_uuid character varying(255),
403 container_count_max integer,
405 runtime_constraints text,
406 container_image character varying(255),
408 cwd character varying(255),
410 output_path character varying(255),
412 expires_at timestamp without time zone,
414 updated_at timestamp without time zone NOT NULL,
415 container_count integer DEFAULT 0,
416 use_existing boolean DEFAULT true,
417 scheduling_parameters text,
418 output_uuid character varying(255),
419 log_uuid character varying(255),
420 output_name character varying(255) DEFAULT NULL::character varying,
421 output_ttl integer DEFAULT 0 NOT NULL,
422 secret_mounts jsonb DEFAULT '{}'::jsonb,
428 -- Name: container_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: -
431 CREATE SEQUENCE public.container_requests_id_seq
440 -- Name: container_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
443 ALTER SEQUENCE public.container_requests_id_seq OWNED BY public.container_requests.id;
447 -- Name: containers; Type: TABLE; Schema: public; Owner: -
450 CREATE TABLE public.containers (
452 uuid character varying(255),
453 owner_uuid character varying(255),
454 created_at timestamp without time zone NOT NULL,
455 modified_at timestamp without time zone,
456 modified_by_client_uuid character varying(255),
457 modified_by_user_uuid character varying(255),
458 state character varying(255),
459 started_at timestamp without time zone,
460 finished_at timestamp without time zone,
461 log character varying(255),
463 cwd character varying(255),
465 output_path character varying(255),
467 runtime_constraints text,
468 output character varying(255),
469 container_image character varying(255),
470 progress double precision,
472 updated_at timestamp without time zone NOT NULL,
474 auth_uuid character varying(255),
475 locked_by_uuid character varying(255),
476 scheduling_parameters text,
477 secret_mounts jsonb DEFAULT '{}'::jsonb,
478 secret_mounts_md5 character varying DEFAULT '99914b932bd37a50b983c5e7c90ae93b'::character varying,
479 runtime_status jsonb DEFAULT '{}'::jsonb,
480 runtime_user_uuid text,
481 runtime_auth_scopes jsonb,
483 lock_count integer DEFAULT 0 NOT NULL
488 -- Name: containers_id_seq; Type: SEQUENCE; Schema: public; Owner: -
491 CREATE SEQUENCE public.containers_id_seq
500 -- Name: containers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
503 ALTER SEQUENCE public.containers_id_seq OWNED BY public.containers.id;
507 -- Name: groups; Type: TABLE; Schema: public; Owner: -
510 CREATE TABLE public.groups (
512 uuid character varying(255),
513 owner_uuid character varying(255),
514 created_at timestamp without time zone NOT NULL,
515 modified_by_client_uuid character varying(255),
516 modified_by_user_uuid character varying(255),
517 modified_at timestamp without time zone,
518 name character varying(255) NOT NULL,
519 description character varying(524288),
520 updated_at timestamp without time zone NOT NULL,
521 group_class character varying(255),
522 trash_at timestamp without time zone,
523 is_trashed boolean DEFAULT false NOT NULL,
524 delete_at timestamp without time zone,
525 properties jsonb DEFAULT '{}'::jsonb
530 -- Name: groups_id_seq; Type: SEQUENCE; Schema: public; Owner: -
533 CREATE SEQUENCE public.groups_id_seq
542 -- Name: groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
545 ALTER SEQUENCE public.groups_id_seq OWNED BY public.groups.id;
549 -- Name: humans; Type: TABLE; Schema: public; Owner: -
552 CREATE TABLE public.humans (
554 uuid character varying(255) NOT NULL,
555 owner_uuid character varying(255) NOT NULL,
556 modified_by_client_uuid character varying(255),
557 modified_by_user_uuid character varying(255),
558 modified_at timestamp without time zone,
560 created_at timestamp without time zone NOT NULL,
561 updated_at timestamp without time zone NOT NULL
566 -- Name: humans_id_seq; Type: SEQUENCE; Schema: public; Owner: -
569 CREATE SEQUENCE public.humans_id_seq
578 -- Name: humans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
581 ALTER SEQUENCE public.humans_id_seq OWNED BY public.humans.id;
585 -- Name: job_tasks; Type: TABLE; Schema: public; Owner: -
588 CREATE TABLE public.job_tasks (
590 uuid character varying(255),
591 owner_uuid character varying(255),
592 modified_by_client_uuid character varying(255),
593 modified_by_user_uuid character varying(255),
594 modified_at timestamp without time zone,
595 job_uuid character varying(255),
599 progress double precision,
601 created_at timestamp without time zone NOT NULL,
602 updated_at timestamp without time zone NOT NULL,
603 created_by_job_task_uuid character varying(255),
605 started_at timestamp without time zone,
606 finished_at timestamp without time zone
611 -- Name: job_tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
614 CREATE SEQUENCE public.job_tasks_id_seq
623 -- Name: job_tasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
626 ALTER SEQUENCE public.job_tasks_id_seq OWNED BY public.job_tasks.id;
630 -- Name: job_tasks_qsequence_seq; Type: SEQUENCE; Schema: public; Owner: -
633 CREATE SEQUENCE public.job_tasks_qsequence_seq
642 -- Name: job_tasks_qsequence_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
645 ALTER SEQUENCE public.job_tasks_qsequence_seq OWNED BY public.job_tasks.qsequence;
649 -- Name: jobs; Type: TABLE; Schema: public; Owner: -
652 CREATE TABLE public.jobs (
654 uuid character varying(255),
655 owner_uuid character varying(255),
656 modified_by_client_uuid character varying(255),
657 modified_by_user_uuid character varying(255),
658 modified_at timestamp without time zone,
659 submit_id character varying(255),
660 script character varying(255),
661 script_version character varying(255),
662 script_parameters text,
663 cancelled_by_client_uuid character varying(255),
664 cancelled_by_user_uuid character varying(255),
665 cancelled_at timestamp without time zone,
666 started_at timestamp without time zone,
667 finished_at timestamp without time zone,
670 output character varying(255),
671 created_at timestamp without time zone NOT NULL,
672 updated_at timestamp without time zone NOT NULL,
673 is_locked_by_uuid character varying(255),
674 log character varying(255),
676 runtime_constraints text,
677 nondeterministic boolean,
678 repository character varying(255),
679 supplied_script_version character varying(255),
680 docker_image_locator character varying(255),
681 priority integer DEFAULT 0 NOT NULL,
682 description character varying(524288),
683 state character varying(255),
684 arvados_sdk_version character varying(255),
686 script_parameters_digest character varying(255)
691 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
694 CREATE SEQUENCE public.jobs_id_seq
703 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
706 ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;
710 -- Name: keep_disks; Type: TABLE; Schema: public; Owner: -
713 CREATE TABLE public.keep_disks (
715 uuid character varying(255) NOT NULL,
716 owner_uuid character varying(255) NOT NULL,
717 modified_by_client_uuid character varying(255),
718 modified_by_user_uuid character varying(255),
719 modified_at timestamp without time zone,
720 ping_secret character varying(255) NOT NULL,
721 node_uuid character varying(255),
722 filesystem_uuid character varying(255),
725 is_readable boolean DEFAULT true NOT NULL,
726 is_writable boolean DEFAULT true NOT NULL,
727 last_read_at timestamp without time zone,
728 last_write_at timestamp without time zone,
729 last_ping_at timestamp without time zone,
730 created_at timestamp without time zone NOT NULL,
731 updated_at timestamp without time zone NOT NULL,
732 keep_service_uuid character varying(255)
737 -- Name: keep_disks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
740 CREATE SEQUENCE public.keep_disks_id_seq
749 -- Name: keep_disks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
752 ALTER SEQUENCE public.keep_disks_id_seq OWNED BY public.keep_disks.id;
756 -- Name: keep_services; Type: TABLE; Schema: public; Owner: -
759 CREATE TABLE public.keep_services (
761 uuid character varying(255) NOT NULL,
762 owner_uuid character varying(255) NOT NULL,
763 modified_by_client_uuid character varying(255),
764 modified_by_user_uuid character varying(255),
765 modified_at timestamp without time zone,
766 service_host character varying(255),
767 service_port integer,
768 service_ssl_flag boolean,
769 service_type character varying(255),
770 created_at timestamp without time zone NOT NULL,
771 updated_at timestamp without time zone NOT NULL,
772 read_only boolean DEFAULT false NOT NULL
777 -- Name: keep_services_id_seq; Type: SEQUENCE; Schema: public; Owner: -
780 CREATE SEQUENCE public.keep_services_id_seq
789 -- Name: keep_services_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
792 ALTER SEQUENCE public.keep_services_id_seq OWNED BY public.keep_services.id;
796 -- Name: links; Type: TABLE; Schema: public; Owner: -
799 CREATE TABLE public.links (
801 uuid character varying(255),
802 owner_uuid character varying(255),
803 created_at timestamp without time zone NOT NULL,
804 modified_by_client_uuid character varying(255),
805 modified_by_user_uuid character varying(255),
806 modified_at timestamp without time zone,
807 tail_uuid character varying(255),
808 link_class character varying(255),
809 name character varying(255),
810 head_uuid character varying(255),
812 updated_at timestamp without time zone NOT NULL
817 -- Name: links_id_seq; Type: SEQUENCE; Schema: public; Owner: -
820 CREATE SEQUENCE public.links_id_seq
829 -- Name: links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
832 ALTER SEQUENCE public.links_id_seq OWNED BY public.links.id;
836 -- Name: logs; Type: TABLE; Schema: public; Owner: -
839 CREATE TABLE public.logs (
841 uuid character varying(255),
842 owner_uuid character varying(255),
843 modified_by_client_uuid character varying(255),
844 modified_by_user_uuid character varying(255),
845 object_uuid character varying(255),
846 event_at timestamp without time zone,
847 event_type character varying(255),
850 created_at timestamp without time zone NOT NULL,
851 updated_at timestamp without time zone NOT NULL,
852 modified_at timestamp without time zone,
853 object_owner_uuid character varying(255)
858 -- Name: logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
861 CREATE SEQUENCE public.logs_id_seq
870 -- Name: logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
873 ALTER SEQUENCE public.logs_id_seq OWNED BY public.logs.id;
877 -- Name: materialized_permissions; Type: TABLE; Schema: public; Owner: -
880 CREATE TABLE public.materialized_permissions (
881 user_uuid character varying,
882 target_uuid character varying,
884 traverse_owned boolean
889 -- Name: nodes; Type: TABLE; Schema: public; Owner: -
892 CREATE TABLE public.nodes (
894 uuid character varying(255),
895 owner_uuid character varying(255),
896 created_at timestamp without time zone NOT NULL,
897 modified_by_client_uuid character varying(255),
898 modified_by_user_uuid character varying(255),
899 modified_at timestamp without time zone,
901 hostname character varying(255),
902 domain character varying(255),
903 ip_address character varying(255),
904 first_ping_at timestamp without time zone,
905 last_ping_at timestamp without time zone,
907 updated_at timestamp without time zone NOT NULL,
909 job_uuid character varying(255)
914 -- Name: nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
917 CREATE SEQUENCE public.nodes_id_seq
926 -- Name: nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
929 ALTER SEQUENCE public.nodes_id_seq OWNED BY public.nodes.id;
933 -- Name: pipeline_instances; Type: TABLE; Schema: public; Owner: -
936 CREATE TABLE public.pipeline_instances (
938 uuid character varying(255),
939 owner_uuid character varying(255),
940 created_at timestamp without time zone NOT NULL,
941 modified_by_client_uuid character varying(255),
942 modified_by_user_uuid character varying(255),
943 modified_at timestamp without time zone,
944 pipeline_template_uuid character varying(255),
945 name character varying(255),
947 updated_at timestamp without time zone NOT NULL,
949 state character varying(255),
950 components_summary text,
951 started_at timestamp without time zone,
952 finished_at timestamp without time zone,
953 description character varying(524288)
958 -- Name: pipeline_instances_id_seq; Type: SEQUENCE; Schema: public; Owner: -
961 CREATE SEQUENCE public.pipeline_instances_id_seq
970 -- Name: pipeline_instances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
973 ALTER SEQUENCE public.pipeline_instances_id_seq OWNED BY public.pipeline_instances.id;
977 -- Name: pipeline_templates; Type: TABLE; Schema: public; Owner: -
980 CREATE TABLE public.pipeline_templates (
982 uuid character varying(255),
983 owner_uuid character varying(255),
984 created_at timestamp without time zone NOT NULL,
985 modified_by_client_uuid character varying(255),
986 modified_by_user_uuid character varying(255),
987 modified_at timestamp without time zone,
988 name character varying(255),
990 updated_at timestamp without time zone NOT NULL,
991 description character varying(524288)
996 -- Name: pipeline_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
999 CREATE SEQUENCE public.pipeline_templates_id_seq
1008 -- Name: pipeline_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1011 ALTER SEQUENCE public.pipeline_templates_id_seq OWNED BY public.pipeline_templates.id;
1015 -- Name: repositories; Type: TABLE; Schema: public; Owner: -
1018 CREATE TABLE public.repositories (
1019 id integer NOT NULL,
1020 uuid character varying(255) NOT NULL,
1021 owner_uuid character varying(255) NOT NULL,
1022 modified_by_client_uuid character varying(255),
1023 modified_by_user_uuid character varying(255),
1024 modified_at timestamp without time zone,
1025 name character varying(255),
1026 created_at timestamp without time zone NOT NULL,
1027 updated_at timestamp without time zone NOT NULL
1032 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1035 CREATE SEQUENCE public.repositories_id_seq
1044 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1047 ALTER SEQUENCE public.repositories_id_seq OWNED BY public.repositories.id;
1051 -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -
1054 CREATE TABLE public.schema_migrations (
1055 version character varying(255) NOT NULL
1060 -- Name: specimens; Type: TABLE; Schema: public; Owner: -
1063 CREATE TABLE public.specimens (
1064 id integer NOT NULL,
1065 uuid character varying(255),
1066 owner_uuid character varying(255),
1067 created_at timestamp without time zone NOT NULL,
1068 modified_by_client_uuid character varying(255),
1069 modified_by_user_uuid character varying(255),
1070 modified_at timestamp without time zone,
1071 material character varying(255),
1072 updated_at timestamp without time zone NOT NULL,
1078 -- Name: specimens_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1081 CREATE SEQUENCE public.specimens_id_seq
1090 -- Name: specimens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1093 ALTER SEQUENCE public.specimens_id_seq OWNED BY public.specimens.id;
1097 -- Name: traits; Type: TABLE; Schema: public; Owner: -
1100 CREATE TABLE public.traits (
1101 id integer NOT NULL,
1102 uuid character varying(255) NOT NULL,
1103 owner_uuid character varying(255) NOT NULL,
1104 modified_by_client_uuid character varying(255),
1105 modified_by_user_uuid character varying(255),
1106 modified_at timestamp without time zone,
1107 name character varying(255),
1109 created_at timestamp without time zone NOT NULL,
1110 updated_at timestamp without time zone NOT NULL
1115 -- Name: traits_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1118 CREATE SEQUENCE public.traits_id_seq
1127 -- Name: traits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1130 ALTER SEQUENCE public.traits_id_seq OWNED BY public.traits.id;
1134 -- Name: trashed_groups; Type: TABLE; Schema: public; Owner: -
1137 CREATE TABLE public.trashed_groups (
1138 group_uuid character varying,
1139 trash_at timestamp without time zone
1144 -- Name: users; Type: TABLE; Schema: public; Owner: -
1147 CREATE TABLE public.users (
1148 id integer NOT NULL,
1149 uuid character varying(255),
1150 owner_uuid character varying(255) NOT NULL,
1151 created_at timestamp without time zone NOT NULL,
1152 modified_by_client_uuid character varying(255),
1153 modified_by_user_uuid character varying(255),
1154 modified_at timestamp without time zone,
1155 email character varying(255),
1156 first_name character varying(255),
1157 last_name character varying(255),
1158 identity_url character varying(255),
1161 updated_at timestamp without time zone NOT NULL,
1162 default_owner_uuid character varying(255),
1163 is_active boolean DEFAULT false,
1164 username character varying(255),
1165 redirect_to_user_uuid character varying
1170 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1173 CREATE SEQUENCE public.users_id_seq
1182 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1185 ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
1189 -- Name: virtual_machines; Type: TABLE; Schema: public; Owner: -
1192 CREATE TABLE public.virtual_machines (
1193 id integer NOT NULL,
1194 uuid character varying(255) NOT NULL,
1195 owner_uuid character varying(255) NOT NULL,
1196 modified_by_client_uuid character varying(255),
1197 modified_by_user_uuid character varying(255),
1198 modified_at timestamp without time zone,
1199 hostname character varying(255),
1200 created_at timestamp without time zone NOT NULL,
1201 updated_at timestamp without time zone NOT NULL
1206 -- Name: virtual_machines_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1209 CREATE SEQUENCE public.virtual_machines_id_seq
1218 -- Name: virtual_machines_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1221 ALTER SEQUENCE public.virtual_machines_id_seq OWNED BY public.virtual_machines.id;
1225 -- Name: workflows; Type: TABLE; Schema: public; Owner: -
1228 CREATE TABLE public.workflows (
1229 id integer NOT NULL,
1230 uuid character varying(255),
1231 owner_uuid character varying(255),
1232 created_at timestamp without time zone NOT NULL,
1233 modified_at timestamp without time zone,
1234 modified_by_client_uuid character varying(255),
1235 modified_by_user_uuid character varying(255),
1236 name character varying(255),
1239 updated_at timestamp without time zone NOT NULL
1244 -- Name: workflows_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1247 CREATE SEQUENCE public.workflows_id_seq
1256 -- Name: workflows_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1259 ALTER SEQUENCE public.workflows_id_seq OWNED BY public.workflows.id;
1263 -- Name: api_client_authorizations id; Type: DEFAULT; Schema: public; Owner: -
1266 ALTER TABLE ONLY public.api_client_authorizations ALTER COLUMN id SET DEFAULT nextval('public.api_client_authorizations_id_seq'::regclass);
1270 -- Name: api_clients id; Type: DEFAULT; Schema: public; Owner: -
1273 ALTER TABLE ONLY public.api_clients ALTER COLUMN id SET DEFAULT nextval('public.api_clients_id_seq'::regclass);
1277 -- Name: authorized_keys id; Type: DEFAULT; Schema: public; Owner: -
1280 ALTER TABLE ONLY public.authorized_keys ALTER COLUMN id SET DEFAULT nextval('public.authorized_keys_id_seq'::regclass);
1284 -- Name: collections id; Type: DEFAULT; Schema: public; Owner: -
1287 ALTER TABLE ONLY public.collections ALTER COLUMN id SET DEFAULT nextval('public.collections_id_seq'::regclass);
1291 -- Name: container_requests id; Type: DEFAULT; Schema: public; Owner: -
1294 ALTER TABLE ONLY public.container_requests ALTER COLUMN id SET DEFAULT nextval('public.container_requests_id_seq'::regclass);
1298 -- Name: containers id; Type: DEFAULT; Schema: public; Owner: -
1301 ALTER TABLE ONLY public.containers ALTER COLUMN id SET DEFAULT nextval('public.containers_id_seq'::regclass);
1305 -- Name: groups id; Type: DEFAULT; Schema: public; Owner: -
1308 ALTER TABLE ONLY public.groups ALTER COLUMN id SET DEFAULT nextval('public.groups_id_seq'::regclass);
1312 -- Name: humans id; Type: DEFAULT; Schema: public; Owner: -
1315 ALTER TABLE ONLY public.humans ALTER COLUMN id SET DEFAULT nextval('public.humans_id_seq'::regclass);
1319 -- Name: job_tasks id; Type: DEFAULT; Schema: public; Owner: -
1322 ALTER TABLE ONLY public.job_tasks ALTER COLUMN id SET DEFAULT nextval('public.job_tasks_id_seq'::regclass);
1326 -- Name: jobs id; Type: DEFAULT; Schema: public; Owner: -
1329 ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass);
1333 -- Name: keep_disks id; Type: DEFAULT; Schema: public; Owner: -
1336 ALTER TABLE ONLY public.keep_disks ALTER COLUMN id SET DEFAULT nextval('public.keep_disks_id_seq'::regclass);
1340 -- Name: keep_services id; Type: DEFAULT; Schema: public; Owner: -
1343 ALTER TABLE ONLY public.keep_services ALTER COLUMN id SET DEFAULT nextval('public.keep_services_id_seq'::regclass);
1347 -- Name: links id; Type: DEFAULT; Schema: public; Owner: -
1350 ALTER TABLE ONLY public.links ALTER COLUMN id SET DEFAULT nextval('public.links_id_seq'::regclass);
1354 -- Name: logs id; Type: DEFAULT; Schema: public; Owner: -
1357 ALTER TABLE ONLY public.logs ALTER COLUMN id SET DEFAULT nextval('public.logs_id_seq'::regclass);
1361 -- Name: nodes id; Type: DEFAULT; Schema: public; Owner: -
1364 ALTER TABLE ONLY public.nodes ALTER COLUMN id SET DEFAULT nextval('public.nodes_id_seq'::regclass);
1368 -- Name: pipeline_instances id; Type: DEFAULT; Schema: public; Owner: -
1371 ALTER TABLE ONLY public.pipeline_instances ALTER COLUMN id SET DEFAULT nextval('public.pipeline_instances_id_seq'::regclass);
1375 -- Name: pipeline_templates id; Type: DEFAULT; Schema: public; Owner: -
1378 ALTER TABLE ONLY public.pipeline_templates ALTER COLUMN id SET DEFAULT nextval('public.pipeline_templates_id_seq'::regclass);
1382 -- Name: repositories id; Type: DEFAULT; Schema: public; Owner: -
1385 ALTER TABLE ONLY public.repositories ALTER COLUMN id SET DEFAULT nextval('public.repositories_id_seq'::regclass);
1389 -- Name: specimens id; Type: DEFAULT; Schema: public; Owner: -
1392 ALTER TABLE ONLY public.specimens ALTER COLUMN id SET DEFAULT nextval('public.specimens_id_seq'::regclass);
1396 -- Name: traits id; Type: DEFAULT; Schema: public; Owner: -
1399 ALTER TABLE ONLY public.traits ALTER COLUMN id SET DEFAULT nextval('public.traits_id_seq'::regclass);
1403 -- Name: users id; Type: DEFAULT; Schema: public; Owner: -
1406 ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
1410 -- Name: virtual_machines id; Type: DEFAULT; Schema: public; Owner: -
1413 ALTER TABLE ONLY public.virtual_machines ALTER COLUMN id SET DEFAULT nextval('public.virtual_machines_id_seq'::regclass);
1417 -- Name: workflows id; Type: DEFAULT; Schema: public; Owner: -
1420 ALTER TABLE ONLY public.workflows ALTER COLUMN id SET DEFAULT nextval('public.workflows_id_seq'::regclass);
1424 -- Name: api_client_authorizations api_client_authorizations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1427 ALTER TABLE ONLY public.api_client_authorizations
1428 ADD CONSTRAINT api_client_authorizations_pkey PRIMARY KEY (id);
1432 -- Name: api_clients api_clients_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1435 ALTER TABLE ONLY public.api_clients
1436 ADD CONSTRAINT api_clients_pkey PRIMARY KEY (id);
1440 -- Name: ar_internal_metadata ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1443 ALTER TABLE ONLY public.ar_internal_metadata
1444 ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);
1448 -- Name: authorized_keys authorized_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1451 ALTER TABLE ONLY public.authorized_keys
1452 ADD CONSTRAINT authorized_keys_pkey PRIMARY KEY (id);
1456 -- Name: collections collections_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1459 ALTER TABLE ONLY public.collections
1460 ADD CONSTRAINT collections_pkey PRIMARY KEY (id);
1464 -- Name: container_requests container_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1467 ALTER TABLE ONLY public.container_requests
1468 ADD CONSTRAINT container_requests_pkey PRIMARY KEY (id);
1472 -- Name: containers containers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1475 ALTER TABLE ONLY public.containers
1476 ADD CONSTRAINT containers_pkey PRIMARY KEY (id);
1480 -- Name: groups groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1483 ALTER TABLE ONLY public.groups
1484 ADD CONSTRAINT groups_pkey PRIMARY KEY (id);
1488 -- Name: humans humans_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1491 ALTER TABLE ONLY public.humans
1492 ADD CONSTRAINT humans_pkey PRIMARY KEY (id);
1496 -- Name: job_tasks job_tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1499 ALTER TABLE ONLY public.job_tasks
1500 ADD CONSTRAINT job_tasks_pkey PRIMARY KEY (id);
1504 -- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1507 ALTER TABLE ONLY public.jobs
1508 ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);
1512 -- Name: keep_disks keep_disks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1515 ALTER TABLE ONLY public.keep_disks
1516 ADD CONSTRAINT keep_disks_pkey PRIMARY KEY (id);
1520 -- Name: keep_services keep_services_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1523 ALTER TABLE ONLY public.keep_services
1524 ADD CONSTRAINT keep_services_pkey PRIMARY KEY (id);
1528 -- Name: links links_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1531 ALTER TABLE ONLY public.links
1532 ADD CONSTRAINT links_pkey PRIMARY KEY (id);
1536 -- Name: logs logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1539 ALTER TABLE ONLY public.logs
1540 ADD CONSTRAINT logs_pkey PRIMARY KEY (id);
1544 -- Name: nodes nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1547 ALTER TABLE ONLY public.nodes
1548 ADD CONSTRAINT nodes_pkey PRIMARY KEY (id);
1552 -- Name: pipeline_instances pipeline_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1555 ALTER TABLE ONLY public.pipeline_instances
1556 ADD CONSTRAINT pipeline_instances_pkey PRIMARY KEY (id);
1560 -- Name: pipeline_templates pipeline_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1563 ALTER TABLE ONLY public.pipeline_templates
1564 ADD CONSTRAINT pipeline_templates_pkey PRIMARY KEY (id);
1568 -- Name: repositories repositories_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1571 ALTER TABLE ONLY public.repositories
1572 ADD CONSTRAINT repositories_pkey PRIMARY KEY (id);
1576 -- Name: specimens specimens_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1579 ALTER TABLE ONLY public.specimens
1580 ADD CONSTRAINT specimens_pkey PRIMARY KEY (id);
1584 -- Name: traits traits_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1587 ALTER TABLE ONLY public.traits
1588 ADD CONSTRAINT traits_pkey PRIMARY KEY (id);
1592 -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1595 ALTER TABLE ONLY public.users
1596 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
1600 -- Name: virtual_machines virtual_machines_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1603 ALTER TABLE ONLY public.virtual_machines
1604 ADD CONSTRAINT virtual_machines_pkey PRIMARY KEY (id);
1608 -- Name: workflows workflows_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1611 ALTER TABLE ONLY public.workflows
1612 ADD CONSTRAINT workflows_pkey PRIMARY KEY (id);
1616 -- Name: api_client_authorizations_search_index; Type: INDEX; Schema: public; Owner: -
1619 CREATE INDEX api_client_authorizations_search_index ON public.api_client_authorizations USING btree (api_token, created_by_ip_address, last_used_by_ip_address, default_owner_uuid, uuid);
1623 -- Name: api_clients_search_index; Type: INDEX; Schema: public; Owner: -
1626 CREATE INDEX api_clients_search_index ON public.api_clients USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, url_prefix);
1630 -- Name: authorized_keys_search_index; Type: INDEX; Schema: public; Owner: -
1633 CREATE INDEX authorized_keys_search_index ON public.authorized_keys USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, key_type, authorized_user_uuid);
1637 -- Name: collection_index_on_properties; Type: INDEX; Schema: public; Owner: -
1640 CREATE INDEX collection_index_on_properties ON public.collections USING gin (properties);
1644 -- Name: collections_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
1647 CREATE INDEX collections_full_text_search_idx ON public.collections USING gin (to_tsvector('english'::regconfig, substr((((((((((((((((((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(portable_data_hash, ''::character varying))::text) || ' '::text) || (COALESCE(uuid, ''::character varying))::text) || ' '::text) || (COALESCE(name, ''::character varying))::text) || ' '::text) || (COALESCE(description, ''::character varying))::text) || ' '::text) || COALESCE((properties)::text, ''::text)) || ' '::text) || COALESCE(file_names, ''::text)), 0, 1000000)));
1651 -- Name: collections_search_index; Type: INDEX; Schema: public; Owner: -
1654 CREATE INDEX collections_search_index ON public.collections USING btree (owner_uuid, modified_by_client_uuid, modified_by_user_uuid, portable_data_hash, uuid, name, current_version_uuid);
1658 -- Name: collections_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
1661 CREATE INDEX collections_trgm_text_search_idx ON public.collections USING gin (((((((((((((((((((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(portable_data_hash, ''::character varying))::text) || ' '::text) || (COALESCE(uuid, ''::character varying))::text) || ' '::text) || (COALESCE(name, ''::character varying))::text) || ' '::text) || (COALESCE(description, ''::character varying))::text) || ' '::text) || COALESCE((properties)::text, ''::text)) || ' '::text) || COALESCE(file_names, ''::text))) public.gin_trgm_ops);
1665 -- Name: container_requests_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
1668 CREATE INDEX container_requests_full_text_search_idx ON public.container_requests USING gin (to_tsvector('english'::regconfig, substr((((((((((((((((((((((((((((((((((((((((((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((properties)::text, ''::text)) || ' '::text) || (COALESCE(state, ''::character varying))::text) || ' '::text) || (COALESCE(requesting_container_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(container_uuid, ''::character varying))::text) || ' '::text) || COALESCE(runtime_constraints, ''::text)) || ' '::text) || (COALESCE(container_image, ''::character varying))::text) || ' '::text) || COALESCE(environment, ''::text)) || ' '::text) || (COALESCE(cwd, ''::character varying))::text) || ' '::text) || COALESCE(command, ''::text)) || ' '::text) || (COALESCE(output_path, ''::character varying))::text) || ' '::text) || COALESCE(filters, ''::text)) || ' '::text) || COALESCE(scheduling_parameters, ''::text)) || ' '::text) || (COALESCE(output_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(log_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(output_name, ''::character varying))::text), 0, 1000000)));
1672 -- Name: container_requests_index_on_properties; Type: INDEX; Schema: public; Owner: -
1675 CREATE INDEX container_requests_index_on_properties ON public.container_requests USING gin (properties);
1679 -- Name: container_requests_search_index; Type: INDEX; Schema: public; Owner: -
1682 CREATE INDEX container_requests_search_index ON public.container_requests USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, state, requesting_container_uuid, container_uuid, container_image, cwd, output_path, output_uuid, log_uuid, output_name);
1686 -- Name: container_requests_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
1689 CREATE INDEX container_requests_trgm_text_search_idx ON public.container_requests USING gin (((((((((((((((((((((((((((((((((((((((((((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((properties)::text, ''::text)) || ' '::text) || (COALESCE(state, ''::character varying))::text) || ' '::text) || (COALESCE(requesting_container_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(container_uuid, ''::character varying))::text) || ' '::text) || COALESCE(runtime_constraints, ''::text)) || ' '::text) || (COALESCE(container_image, ''::character varying))::text) || ' '::text) || COALESCE(environment, ''::text)) || ' '::text) || (COALESCE(cwd, ''::character varying))::text) || ' '::text) || COALESCE(command, ''::text)) || ' '::text) || (COALESCE(output_path, ''::character varying))::text) || ' '::text) || COALESCE(filters, ''::text)) || ' '::text) || COALESCE(scheduling_parameters, ''::text)) || ' '::text) || (COALESCE(output_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(log_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(output_name, ''::character varying))::text)) public.gin_trgm_ops);
1693 -- Name: containers_search_index; Type: INDEX; Schema: public; Owner: -
1696 CREATE INDEX containers_search_index ON public.containers USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, state, log, cwd, output_path, output, container_image, auth_uuid, locked_by_uuid);
1700 -- Name: group_index_on_properties; Type: INDEX; Schema: public; Owner: -
1703 CREATE INDEX group_index_on_properties ON public.groups USING gin (properties);
1707 -- Name: groups_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
1710 CREATE INDEX groups_full_text_search_idx ON public.groups USING gin (to_tsvector('english'::regconfig, substr((((((((((((((((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, ''::character varying))::text) || ' '::text) || (COALESCE(group_class, ''::character varying))::text) || ' '::text) || COALESCE((properties)::text, ''::text)), 0, 1000000)));
1714 -- Name: groups_search_index; Type: INDEX; Schema: public; Owner: -
1717 CREATE INDEX groups_search_index ON public.groups USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, group_class);
1721 -- Name: groups_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
1724 CREATE INDEX groups_trgm_text_search_idx ON public.groups USING gin (((((((((((((((((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, ''::character varying))::text) || ' '::text) || (COALESCE(group_class, ''::character varying))::text) || ' '::text) || COALESCE((properties)::text, ''::text))) public.gin_trgm_ops);
1728 -- Name: humans_search_index; Type: INDEX; Schema: public; Owner: -
1731 CREATE INDEX humans_search_index ON public.humans USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid);
1735 -- Name: index_api_client_authorizations_on_api_client_id; Type: INDEX; Schema: public; Owner: -
1738 CREATE INDEX index_api_client_authorizations_on_api_client_id ON public.api_client_authorizations USING btree (api_client_id);
1742 -- Name: index_api_client_authorizations_on_api_token; Type: INDEX; Schema: public; Owner: -
1745 CREATE UNIQUE INDEX index_api_client_authorizations_on_api_token ON public.api_client_authorizations USING btree (api_token);
1749 -- Name: index_api_client_authorizations_on_expires_at; Type: INDEX; Schema: public; Owner: -
1752 CREATE INDEX index_api_client_authorizations_on_expires_at ON public.api_client_authorizations USING btree (expires_at);
1756 -- Name: index_api_client_authorizations_on_user_id; Type: INDEX; Schema: public; Owner: -
1759 CREATE INDEX index_api_client_authorizations_on_user_id ON public.api_client_authorizations USING btree (user_id);
1763 -- Name: index_api_client_authorizations_on_uuid; Type: INDEX; Schema: public; Owner: -
1766 CREATE UNIQUE INDEX index_api_client_authorizations_on_uuid ON public.api_client_authorizations USING btree (uuid);
1770 -- Name: index_api_clients_on_created_at; Type: INDEX; Schema: public; Owner: -
1773 CREATE INDEX index_api_clients_on_created_at ON public.api_clients USING btree (created_at);
1777 -- Name: index_api_clients_on_modified_at; Type: INDEX; Schema: public; Owner: -
1780 CREATE INDEX index_api_clients_on_modified_at ON public.api_clients USING btree (modified_at);
1784 -- Name: index_api_clients_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1787 CREATE INDEX index_api_clients_on_owner_uuid ON public.api_clients USING btree (owner_uuid);
1791 -- Name: index_api_clients_on_uuid; Type: INDEX; Schema: public; Owner: -
1794 CREATE UNIQUE INDEX index_api_clients_on_uuid ON public.api_clients USING btree (uuid);
1798 -- Name: index_authkeys_on_user_and_expires_at; Type: INDEX; Schema: public; Owner: -
1801 CREATE INDEX index_authkeys_on_user_and_expires_at ON public.authorized_keys USING btree (authorized_user_uuid, expires_at);
1805 -- Name: index_authorized_keys_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1808 CREATE INDEX index_authorized_keys_on_owner_uuid ON public.authorized_keys USING btree (owner_uuid);
1812 -- Name: index_authorized_keys_on_uuid; Type: INDEX; Schema: public; Owner: -
1815 CREATE UNIQUE INDEX index_authorized_keys_on_uuid ON public.authorized_keys USING btree (uuid);
1819 -- Name: index_collections_on_created_at; Type: INDEX; Schema: public; Owner: -
1822 CREATE INDEX index_collections_on_created_at ON public.collections USING btree (created_at);
1826 -- Name: index_collections_on_current_version_uuid_and_version; Type: INDEX; Schema: public; Owner: -
1829 CREATE UNIQUE INDEX index_collections_on_current_version_uuid_and_version ON public.collections USING btree (current_version_uuid, version);
1833 -- Name: index_collections_on_delete_at; Type: INDEX; Schema: public; Owner: -
1836 CREATE INDEX index_collections_on_delete_at ON public.collections USING btree (delete_at);
1840 -- Name: index_collections_on_is_trashed; Type: INDEX; Schema: public; Owner: -
1843 CREATE INDEX index_collections_on_is_trashed ON public.collections USING btree (is_trashed);
1847 -- Name: index_collections_on_modified_at; Type: INDEX; Schema: public; Owner: -
1850 CREATE INDEX index_collections_on_modified_at ON public.collections USING btree (modified_at);
1854 -- Name: index_collections_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
1857 CREATE INDEX index_collections_on_modified_at_uuid ON public.collections USING btree (modified_at DESC, uuid);
1861 -- Name: index_collections_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1864 CREATE INDEX index_collections_on_owner_uuid ON public.collections USING btree (owner_uuid);
1868 -- Name: index_collections_on_owner_uuid_and_name; Type: INDEX; Schema: public; Owner: -
1871 CREATE UNIQUE INDEX index_collections_on_owner_uuid_and_name ON public.collections USING btree (owner_uuid, name) WHERE ((is_trashed = false) AND ((current_version_uuid)::text = (uuid)::text));
1875 -- Name: index_collections_on_portable_data_hash_and_trash_at; Type: INDEX; Schema: public; Owner: -
1878 CREATE INDEX index_collections_on_portable_data_hash_and_trash_at ON public.collections USING btree (portable_data_hash, trash_at);
1882 -- Name: index_collections_on_trash_at; Type: INDEX; Schema: public; Owner: -
1885 CREATE INDEX index_collections_on_trash_at ON public.collections USING btree (trash_at);
1889 -- Name: index_collections_on_uuid; Type: INDEX; Schema: public; Owner: -
1892 CREATE UNIQUE INDEX index_collections_on_uuid ON public.collections USING btree (uuid);
1896 -- Name: index_container_requests_on_container_uuid; Type: INDEX; Schema: public; Owner: -
1899 CREATE INDEX index_container_requests_on_container_uuid ON public.container_requests USING btree (container_uuid);
1903 -- Name: index_container_requests_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
1906 CREATE INDEX index_container_requests_on_modified_at_uuid ON public.container_requests USING btree (modified_at DESC, uuid);
1910 -- Name: index_container_requests_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1913 CREATE INDEX index_container_requests_on_owner_uuid ON public.container_requests USING btree (owner_uuid);
1917 -- Name: index_container_requests_on_requesting_container_uuid; Type: INDEX; Schema: public; Owner: -
1920 CREATE INDEX index_container_requests_on_requesting_container_uuid ON public.container_requests USING btree (requesting_container_uuid);
1924 -- Name: index_container_requests_on_uuid; Type: INDEX; Schema: public; Owner: -
1927 CREATE UNIQUE INDEX index_container_requests_on_uuid ON public.container_requests USING btree (uuid);
1931 -- Name: index_containers_on_auth_uuid; Type: INDEX; Schema: public; Owner: -
1934 CREATE INDEX index_containers_on_auth_uuid ON public.containers USING btree (auth_uuid);
1938 -- Name: index_containers_on_locked_by_uuid_and_priority; Type: INDEX; Schema: public; Owner: -
1941 CREATE INDEX index_containers_on_locked_by_uuid_and_priority ON public.containers USING btree (locked_by_uuid, priority);
1945 -- Name: index_containers_on_locked_by_uuid_and_uuid; Type: INDEX; Schema: public; Owner: -
1948 CREATE INDEX index_containers_on_locked_by_uuid_and_uuid ON public.containers USING btree (locked_by_uuid, uuid);
1952 -- Name: index_containers_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
1955 CREATE INDEX index_containers_on_modified_at_uuid ON public.containers USING btree (modified_at DESC, uuid);
1959 -- Name: index_containers_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1962 CREATE INDEX index_containers_on_owner_uuid ON public.containers USING btree (owner_uuid);
1966 -- Name: index_containers_on_queued_state; Type: INDEX; Schema: public; Owner: -
1969 CREATE INDEX index_containers_on_queued_state ON public.containers USING btree (state, ((priority > 0)));
1973 -- Name: index_containers_on_reuse_columns; Type: INDEX; Schema: public; Owner: -
1976 CREATE INDEX index_containers_on_reuse_columns ON public.containers USING btree (md5(command), cwd, md5(environment), output_path, container_image, md5(mounts), secret_mounts_md5, md5(runtime_constraints));
1980 -- Name: index_containers_on_runtime_status; Type: INDEX; Schema: public; Owner: -
1983 CREATE INDEX index_containers_on_runtime_status ON public.containers USING gin (runtime_status);
1987 -- Name: index_containers_on_secret_mounts_md5; Type: INDEX; Schema: public; Owner: -
1990 CREATE INDEX index_containers_on_secret_mounts_md5 ON public.containers USING btree (secret_mounts_md5);
1994 -- Name: index_containers_on_uuid; Type: INDEX; Schema: public; Owner: -
1997 CREATE UNIQUE INDEX index_containers_on_uuid ON public.containers USING btree (uuid);
2001 -- Name: index_groups_on_created_at; Type: INDEX; Schema: public; Owner: -
2004 CREATE INDEX index_groups_on_created_at ON public.groups USING btree (created_at);
2008 -- Name: index_groups_on_delete_at; Type: INDEX; Schema: public; Owner: -
2011 CREATE INDEX index_groups_on_delete_at ON public.groups USING btree (delete_at);
2015 -- Name: index_groups_on_group_class; Type: INDEX; Schema: public; Owner: -
2018 CREATE INDEX index_groups_on_group_class ON public.groups USING btree (group_class);
2022 -- Name: index_groups_on_is_trashed; Type: INDEX; Schema: public; Owner: -
2025 CREATE INDEX index_groups_on_is_trashed ON public.groups USING btree (is_trashed);
2029 -- Name: index_groups_on_modified_at; Type: INDEX; Schema: public; Owner: -
2032 CREATE INDEX index_groups_on_modified_at ON public.groups USING btree (modified_at);
2036 -- Name: index_groups_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2039 CREATE INDEX index_groups_on_modified_at_uuid ON public.groups USING btree (modified_at DESC, uuid);
2043 -- Name: index_groups_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2046 CREATE INDEX index_groups_on_owner_uuid ON public.groups USING btree (owner_uuid);
2050 -- Name: index_groups_on_owner_uuid_and_name; Type: INDEX; Schema: public; Owner: -
2053 CREATE UNIQUE INDEX index_groups_on_owner_uuid_and_name ON public.groups USING btree (owner_uuid, name) WHERE (is_trashed = false);
2057 -- Name: index_groups_on_trash_at; Type: INDEX; Schema: public; Owner: -
2060 CREATE INDEX index_groups_on_trash_at ON public.groups USING btree (trash_at);
2064 -- Name: index_groups_on_uuid; Type: INDEX; Schema: public; Owner: -
2067 CREATE UNIQUE INDEX index_groups_on_uuid ON public.groups USING btree (uuid);
2071 -- Name: index_humans_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2074 CREATE INDEX index_humans_on_owner_uuid ON public.humans USING btree (owner_uuid);
2078 -- Name: index_humans_on_uuid; Type: INDEX; Schema: public; Owner: -
2081 CREATE UNIQUE INDEX index_humans_on_uuid ON public.humans USING btree (uuid);
2085 -- Name: index_job_tasks_on_created_at; Type: INDEX; Schema: public; Owner: -
2088 CREATE INDEX index_job_tasks_on_created_at ON public.job_tasks USING btree (created_at);
2092 -- Name: index_job_tasks_on_created_by_job_task_uuid; Type: INDEX; Schema: public; Owner: -
2095 CREATE INDEX index_job_tasks_on_created_by_job_task_uuid ON public.job_tasks USING btree (created_by_job_task_uuid);
2099 -- Name: index_job_tasks_on_job_uuid; Type: INDEX; Schema: public; Owner: -
2102 CREATE INDEX index_job_tasks_on_job_uuid ON public.job_tasks USING btree (job_uuid);
2106 -- Name: index_job_tasks_on_modified_at; Type: INDEX; Schema: public; Owner: -
2109 CREATE INDEX index_job_tasks_on_modified_at ON public.job_tasks USING btree (modified_at);
2113 -- Name: index_job_tasks_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2116 CREATE INDEX index_job_tasks_on_owner_uuid ON public.job_tasks USING btree (owner_uuid);
2120 -- Name: index_job_tasks_on_sequence; Type: INDEX; Schema: public; Owner: -
2123 CREATE INDEX index_job_tasks_on_sequence ON public.job_tasks USING btree (sequence);
2127 -- Name: index_job_tasks_on_success; Type: INDEX; Schema: public; Owner: -
2130 CREATE INDEX index_job_tasks_on_success ON public.job_tasks USING btree (success);
2134 -- Name: index_job_tasks_on_uuid; Type: INDEX; Schema: public; Owner: -
2137 CREATE UNIQUE INDEX index_job_tasks_on_uuid ON public.job_tasks USING btree (uuid);
2141 -- Name: index_jobs_on_created_at; Type: INDEX; Schema: public; Owner: -
2144 CREATE INDEX index_jobs_on_created_at ON public.jobs USING btree (created_at);
2148 -- Name: index_jobs_on_finished_at; Type: INDEX; Schema: public; Owner: -
2151 CREATE INDEX index_jobs_on_finished_at ON public.jobs USING btree (finished_at);
2155 -- Name: index_jobs_on_modified_at; Type: INDEX; Schema: public; Owner: -
2158 CREATE INDEX index_jobs_on_modified_at ON public.jobs USING btree (modified_at);
2162 -- Name: index_jobs_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2165 CREATE INDEX index_jobs_on_modified_at_uuid ON public.jobs USING btree (modified_at DESC, uuid);
2169 -- Name: index_jobs_on_output; Type: INDEX; Schema: public; Owner: -
2172 CREATE INDEX index_jobs_on_output ON public.jobs USING btree (output);
2176 -- Name: index_jobs_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2179 CREATE INDEX index_jobs_on_owner_uuid ON public.jobs USING btree (owner_uuid);
2183 -- Name: index_jobs_on_script; Type: INDEX; Schema: public; Owner: -
2186 CREATE INDEX index_jobs_on_script ON public.jobs USING btree (script);
2190 -- Name: index_jobs_on_script_parameters_digest; Type: INDEX; Schema: public; Owner: -
2193 CREATE INDEX index_jobs_on_script_parameters_digest ON public.jobs USING btree (script_parameters_digest);
2197 -- Name: index_jobs_on_started_at; Type: INDEX; Schema: public; Owner: -
2200 CREATE INDEX index_jobs_on_started_at ON public.jobs USING btree (started_at);
2204 -- Name: index_jobs_on_submit_id; Type: INDEX; Schema: public; Owner: -
2207 CREATE UNIQUE INDEX index_jobs_on_submit_id ON public.jobs USING btree (submit_id);
2211 -- Name: index_jobs_on_uuid; Type: INDEX; Schema: public; Owner: -
2214 CREATE UNIQUE INDEX index_jobs_on_uuid ON public.jobs USING btree (uuid);
2218 -- Name: index_keep_disks_on_filesystem_uuid; Type: INDEX; Schema: public; Owner: -
2221 CREATE INDEX index_keep_disks_on_filesystem_uuid ON public.keep_disks USING btree (filesystem_uuid);
2225 -- Name: index_keep_disks_on_last_ping_at; Type: INDEX; Schema: public; Owner: -
2228 CREATE INDEX index_keep_disks_on_last_ping_at ON public.keep_disks USING btree (last_ping_at);
2232 -- Name: index_keep_disks_on_node_uuid; Type: INDEX; Schema: public; Owner: -
2235 CREATE INDEX index_keep_disks_on_node_uuid ON public.keep_disks USING btree (node_uuid);
2239 -- Name: index_keep_disks_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2242 CREATE INDEX index_keep_disks_on_owner_uuid ON public.keep_disks USING btree (owner_uuid);
2246 -- Name: index_keep_disks_on_uuid; Type: INDEX; Schema: public; Owner: -
2249 CREATE UNIQUE INDEX index_keep_disks_on_uuid ON public.keep_disks USING btree (uuid);
2253 -- Name: index_keep_services_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2256 CREATE INDEX index_keep_services_on_owner_uuid ON public.keep_services USING btree (owner_uuid);
2260 -- Name: index_keep_services_on_uuid; Type: INDEX; Schema: public; Owner: -
2263 CREATE UNIQUE INDEX index_keep_services_on_uuid ON public.keep_services USING btree (uuid);
2267 -- Name: index_links_on_created_at; Type: INDEX; Schema: public; Owner: -
2270 CREATE INDEX index_links_on_created_at ON public.links USING btree (created_at);
2274 -- Name: index_links_on_head_uuid; Type: INDEX; Schema: public; Owner: -
2277 CREATE INDEX index_links_on_head_uuid ON public.links USING btree (head_uuid);
2281 -- Name: index_links_on_modified_at; Type: INDEX; Schema: public; Owner: -
2284 CREATE INDEX index_links_on_modified_at ON public.links USING btree (modified_at);
2288 -- Name: index_links_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2291 CREATE INDEX index_links_on_modified_at_uuid ON public.links USING btree (modified_at DESC, uuid);
2295 -- Name: index_links_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2298 CREATE INDEX index_links_on_owner_uuid ON public.links USING btree (owner_uuid);
2302 -- Name: index_links_on_substring_head_uuid; Type: INDEX; Schema: public; Owner: -
2305 CREATE INDEX index_links_on_substring_head_uuid ON public.links USING btree ("substring"((head_uuid)::text, 7, 5));
2309 -- Name: index_links_on_substring_tail_uuid; Type: INDEX; Schema: public; Owner: -
2312 CREATE INDEX index_links_on_substring_tail_uuid ON public.links USING btree ("substring"((tail_uuid)::text, 7, 5));
2316 -- Name: index_links_on_tail_uuid; Type: INDEX; Schema: public; Owner: -
2319 CREATE INDEX index_links_on_tail_uuid ON public.links USING btree (tail_uuid);
2323 -- Name: index_links_on_uuid; Type: INDEX; Schema: public; Owner: -
2326 CREATE UNIQUE INDEX index_links_on_uuid ON public.links USING btree (uuid);
2330 -- Name: index_logs_on_created_at; Type: INDEX; Schema: public; Owner: -
2333 CREATE INDEX index_logs_on_created_at ON public.logs USING btree (created_at);
2337 -- Name: index_logs_on_event_at; Type: INDEX; Schema: public; Owner: -
2340 CREATE INDEX index_logs_on_event_at ON public.logs USING btree (event_at);
2344 -- Name: index_logs_on_event_type; Type: INDEX; Schema: public; Owner: -
2347 CREATE INDEX index_logs_on_event_type ON public.logs USING btree (event_type);
2351 -- Name: index_logs_on_modified_at; Type: INDEX; Schema: public; Owner: -
2354 CREATE INDEX index_logs_on_modified_at ON public.logs USING btree (modified_at);
2358 -- Name: index_logs_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2361 CREATE INDEX index_logs_on_modified_at_uuid ON public.logs USING btree (modified_at DESC, uuid);
2365 -- Name: index_logs_on_object_owner_uuid; Type: INDEX; Schema: public; Owner: -
2368 CREATE INDEX index_logs_on_object_owner_uuid ON public.logs USING btree (object_owner_uuid);
2372 -- Name: index_logs_on_object_uuid; Type: INDEX; Schema: public; Owner: -
2375 CREATE INDEX index_logs_on_object_uuid ON public.logs USING btree (object_uuid);
2379 -- Name: index_logs_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2382 CREATE INDEX index_logs_on_owner_uuid ON public.logs USING btree (owner_uuid);
2386 -- Name: index_logs_on_summary; Type: INDEX; Schema: public; Owner: -
2389 CREATE INDEX index_logs_on_summary ON public.logs USING btree (summary);
2393 -- Name: index_logs_on_uuid; Type: INDEX; Schema: public; Owner: -
2396 CREATE UNIQUE INDEX index_logs_on_uuid ON public.logs USING btree (uuid);
2400 -- Name: index_nodes_on_created_at; Type: INDEX; Schema: public; Owner: -
2403 CREATE INDEX index_nodes_on_created_at ON public.nodes USING btree (created_at);
2407 -- Name: index_nodes_on_hostname; Type: INDEX; Schema: public; Owner: -
2410 CREATE INDEX index_nodes_on_hostname ON public.nodes USING btree (hostname);
2414 -- Name: index_nodes_on_modified_at; Type: INDEX; Schema: public; Owner: -
2417 CREATE INDEX index_nodes_on_modified_at ON public.nodes USING btree (modified_at);
2421 -- Name: index_nodes_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2424 CREATE INDEX index_nodes_on_owner_uuid ON public.nodes USING btree (owner_uuid);
2428 -- Name: index_nodes_on_slot_number; Type: INDEX; Schema: public; Owner: -
2431 CREATE UNIQUE INDEX index_nodes_on_slot_number ON public.nodes USING btree (slot_number);
2435 -- Name: index_nodes_on_uuid; Type: INDEX; Schema: public; Owner: -
2438 CREATE UNIQUE INDEX index_nodes_on_uuid ON public.nodes USING btree (uuid);
2442 -- Name: index_pipeline_instances_on_created_at; Type: INDEX; Schema: public; Owner: -
2445 CREATE INDEX index_pipeline_instances_on_created_at ON public.pipeline_instances USING btree (created_at);
2449 -- Name: index_pipeline_instances_on_modified_at; Type: INDEX; Schema: public; Owner: -
2452 CREATE INDEX index_pipeline_instances_on_modified_at ON public.pipeline_instances USING btree (modified_at);
2456 -- Name: index_pipeline_instances_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2459 CREATE INDEX index_pipeline_instances_on_modified_at_uuid ON public.pipeline_instances USING btree (modified_at DESC, uuid);
2463 -- Name: index_pipeline_instances_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2466 CREATE INDEX index_pipeline_instances_on_owner_uuid ON public.pipeline_instances USING btree (owner_uuid);
2470 -- Name: index_pipeline_instances_on_uuid; Type: INDEX; Schema: public; Owner: -
2473 CREATE UNIQUE INDEX index_pipeline_instances_on_uuid ON public.pipeline_instances USING btree (uuid);
2477 -- Name: index_pipeline_templates_on_created_at; Type: INDEX; Schema: public; Owner: -
2480 CREATE INDEX index_pipeline_templates_on_created_at ON public.pipeline_templates USING btree (created_at);
2484 -- Name: index_pipeline_templates_on_modified_at; Type: INDEX; Schema: public; Owner: -
2487 CREATE INDEX index_pipeline_templates_on_modified_at ON public.pipeline_templates USING btree (modified_at);
2491 -- Name: index_pipeline_templates_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2494 CREATE INDEX index_pipeline_templates_on_modified_at_uuid ON public.pipeline_templates USING btree (modified_at DESC, uuid);
2498 -- Name: index_pipeline_templates_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2501 CREATE INDEX index_pipeline_templates_on_owner_uuid ON public.pipeline_templates USING btree (owner_uuid);
2505 -- Name: index_pipeline_templates_on_uuid; Type: INDEX; Schema: public; Owner: -
2508 CREATE UNIQUE INDEX index_pipeline_templates_on_uuid ON public.pipeline_templates USING btree (uuid);
2512 -- Name: index_repositories_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2515 CREATE INDEX index_repositories_on_modified_at_uuid ON public.repositories USING btree (modified_at DESC, uuid);
2519 -- Name: index_repositories_on_name; Type: INDEX; Schema: public; Owner: -
2522 CREATE UNIQUE INDEX index_repositories_on_name ON public.repositories USING btree (name);
2526 -- Name: index_repositories_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2529 CREATE INDEX index_repositories_on_owner_uuid ON public.repositories USING btree (owner_uuid);
2533 -- Name: index_repositories_on_uuid; Type: INDEX; Schema: public; Owner: -
2536 CREATE UNIQUE INDEX index_repositories_on_uuid ON public.repositories USING btree (uuid);
2540 -- Name: index_specimens_on_created_at; Type: INDEX; Schema: public; Owner: -
2543 CREATE INDEX index_specimens_on_created_at ON public.specimens USING btree (created_at);
2547 -- Name: index_specimens_on_modified_at; Type: INDEX; Schema: public; Owner: -
2550 CREATE INDEX index_specimens_on_modified_at ON public.specimens USING btree (modified_at);
2554 -- Name: index_specimens_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2557 CREATE INDEX index_specimens_on_owner_uuid ON public.specimens USING btree (owner_uuid);
2561 -- Name: index_specimens_on_uuid; Type: INDEX; Schema: public; Owner: -
2564 CREATE UNIQUE INDEX index_specimens_on_uuid ON public.specimens USING btree (uuid);
2568 -- Name: index_traits_on_name; Type: INDEX; Schema: public; Owner: -
2571 CREATE INDEX index_traits_on_name ON public.traits USING btree (name);
2575 -- Name: index_traits_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2578 CREATE INDEX index_traits_on_owner_uuid ON public.traits USING btree (owner_uuid);
2582 -- Name: index_traits_on_uuid; Type: INDEX; Schema: public; Owner: -
2585 CREATE UNIQUE INDEX index_traits_on_uuid ON public.traits USING btree (uuid);
2589 -- Name: index_trashed_groups_on_group_uuid; Type: INDEX; Schema: public; Owner: -
2592 CREATE UNIQUE INDEX index_trashed_groups_on_group_uuid ON public.trashed_groups USING btree (group_uuid);
2596 -- Name: index_users_on_created_at; Type: INDEX; Schema: public; Owner: -
2599 CREATE INDEX index_users_on_created_at ON public.users USING btree (created_at);
2603 -- Name: index_users_on_identity_url; Type: INDEX; Schema: public; Owner: -
2606 CREATE UNIQUE INDEX index_users_on_identity_url ON public.users USING btree (identity_url);
2610 -- Name: index_users_on_modified_at; Type: INDEX; Schema: public; Owner: -
2613 CREATE INDEX index_users_on_modified_at ON public.users USING btree (modified_at);
2617 -- Name: index_users_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2620 CREATE INDEX index_users_on_modified_at_uuid ON public.users USING btree (modified_at DESC, uuid);
2624 -- Name: index_users_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2627 CREATE INDEX index_users_on_owner_uuid ON public.users USING btree (owner_uuid);
2631 -- Name: index_users_on_username; Type: INDEX; Schema: public; Owner: -
2634 CREATE UNIQUE INDEX index_users_on_username ON public.users USING btree (username);
2638 -- Name: index_users_on_uuid; Type: INDEX; Schema: public; Owner: -
2641 CREATE UNIQUE INDEX index_users_on_uuid ON public.users USING btree (uuid);
2645 -- Name: index_virtual_machines_on_hostname; Type: INDEX; Schema: public; Owner: -
2648 CREATE INDEX index_virtual_machines_on_hostname ON public.virtual_machines USING btree (hostname);
2652 -- Name: index_virtual_machines_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2655 CREATE INDEX index_virtual_machines_on_modified_at_uuid ON public.virtual_machines USING btree (modified_at DESC, uuid);
2659 -- Name: index_virtual_machines_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2662 CREATE INDEX index_virtual_machines_on_owner_uuid ON public.virtual_machines USING btree (owner_uuid);
2666 -- Name: index_virtual_machines_on_uuid; Type: INDEX; Schema: public; Owner: -
2669 CREATE UNIQUE INDEX index_virtual_machines_on_uuid ON public.virtual_machines USING btree (uuid);
2673 -- Name: index_workflows_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2676 CREATE INDEX index_workflows_on_modified_at_uuid ON public.workflows USING btree (modified_at DESC, uuid);
2680 -- Name: index_workflows_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2683 CREATE INDEX index_workflows_on_owner_uuid ON public.workflows USING btree (owner_uuid);
2687 -- Name: index_workflows_on_uuid; Type: INDEX; Schema: public; Owner: -
2690 CREATE UNIQUE INDEX index_workflows_on_uuid ON public.workflows USING btree (uuid);
2694 -- Name: job_tasks_search_index; Type: INDEX; Schema: public; Owner: -
2697 CREATE INDEX job_tasks_search_index ON public.job_tasks USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, job_uuid, created_by_job_task_uuid);
2701 -- Name: jobs_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2704 CREATE INDEX jobs_full_text_search_idx ON public.jobs USING gin (to_tsvector('english'::regconfig, substr((((((((((((((((((((((((((((((((((((((((((((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(submit_id, ''::character varying))::text) || ' '::text) || (COALESCE(script, ''::character varying))::text) || ' '::text) || (COALESCE(script_version, ''::character varying))::text) || ' '::text) || COALESCE(script_parameters, ''::text)) || ' '::text) || (COALESCE(cancelled_by_client_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(cancelled_by_user_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(output, ''::character varying))::text) || ' '::text) || (COALESCE(is_locked_by_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(log, ''::character varying))::text) || ' '::text) || COALESCE(tasks_summary, ''::text)) || ' '::text) || COALESCE(runtime_constraints, ''::text)) || ' '::text) || (COALESCE(repository, ''::character varying))::text) || ' '::text) || (COALESCE(supplied_script_version, ''::character varying))::text) || ' '::text) || (COALESCE(docker_image_locator, ''::character varying))::text) || ' '::text) || (COALESCE(description, ''::character varying))::text) || ' '::text) || (COALESCE(state, ''::character varying))::text) || ' '::text) || (COALESCE(arvados_sdk_version, ''::character varying))::text) || ' '::text) || COALESCE(components, ''::text)), 0, 1000000)));
2708 -- Name: jobs_search_index; Type: INDEX; Schema: public; Owner: -
2711 CREATE INDEX jobs_search_index ON public.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, state, arvados_sdk_version);
2715 -- Name: jobs_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2718 CREATE INDEX jobs_trgm_text_search_idx ON public.jobs USING gin (((((((((((((((((((((((((((((((((((((((((((((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(submit_id, ''::character varying))::text) || ' '::text) || (COALESCE(script, ''::character varying))::text) || ' '::text) || (COALESCE(script_version, ''::character varying))::text) || ' '::text) || COALESCE(script_parameters, ''::text)) || ' '::text) || (COALESCE(cancelled_by_client_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(cancelled_by_user_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(output, ''::character varying))::text) || ' '::text) || (COALESCE(is_locked_by_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(log, ''::character varying))::text) || ' '::text) || COALESCE(tasks_summary, ''::text)) || ' '::text) || COALESCE(runtime_constraints, ''::text)) || ' '::text) || (COALESCE(repository, ''::character varying))::text) || ' '::text) || (COALESCE(supplied_script_version, ''::character varying))::text) || ' '::text) || (COALESCE(docker_image_locator, ''::character varying))::text) || ' '::text) || (COALESCE(description, ''::character varying))::text) || ' '::text) || (COALESCE(state, ''::character varying))::text) || ' '::text) || (COALESCE(arvados_sdk_version, ''::character varying))::text) || ' '::text) || COALESCE(components, ''::text))) public.gin_trgm_ops);
2722 -- Name: keep_disks_search_index; Type: INDEX; Schema: public; Owner: -
2725 CREATE INDEX keep_disks_search_index ON public.keep_disks USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, ping_secret, node_uuid, filesystem_uuid, keep_service_uuid);
2729 -- Name: keep_services_search_index; Type: INDEX; Schema: public; Owner: -
2732 CREATE INDEX keep_services_search_index ON public.keep_services USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, service_host, service_type);
2736 -- Name: links_index_on_properties; Type: INDEX; Schema: public; Owner: -
2739 CREATE INDEX links_index_on_properties ON public.links USING gin (properties);
2743 -- Name: links_search_index; Type: INDEX; Schema: public; Owner: -
2746 CREATE INDEX links_search_index ON public.links USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, tail_uuid, link_class, name, head_uuid);
2750 -- Name: links_tail_name_unique_if_link_class_name; Type: INDEX; Schema: public; Owner: -
2753 CREATE UNIQUE INDEX links_tail_name_unique_if_link_class_name ON public.links USING btree (tail_uuid, name) WHERE ((link_class)::text = 'name'::text);
2757 -- Name: logs_search_index; Type: INDEX; Schema: public; Owner: -
2760 CREATE INDEX logs_search_index ON public.logs USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, object_uuid, event_type, object_owner_uuid);
2764 -- Name: nodes_index_on_info; Type: INDEX; Schema: public; Owner: -
2767 CREATE INDEX nodes_index_on_info ON public.nodes USING gin (info);
2771 -- Name: nodes_index_on_properties; Type: INDEX; Schema: public; Owner: -
2774 CREATE INDEX nodes_index_on_properties ON public.nodes USING gin (properties);
2778 -- Name: nodes_search_index; Type: INDEX; Schema: public; Owner: -
2781 CREATE INDEX nodes_search_index ON public.nodes USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, hostname, domain, ip_address, job_uuid);
2785 -- Name: permission_user_target; Type: INDEX; Schema: public; Owner: -
2788 CREATE UNIQUE INDEX permission_user_target ON public.materialized_permissions USING btree (user_uuid, target_uuid);
2792 -- Name: pipeline_instances_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2795 CREATE INDEX pipeline_instances_full_text_search_idx ON public.pipeline_instances USING gin (to_tsvector('english'::regconfig, substr((((((((((((((((((((((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(pipeline_template_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(name, ''::character varying))::text) || ' '::text) || COALESCE(components, ''::text)) || ' '::text) || COALESCE(properties, ''::text)) || ' '::text) || (COALESCE(state, ''::character varying))::text) || ' '::text) || COALESCE(components_summary, ''::text)) || ' '::text) || (COALESCE(description, ''::character varying))::text), 0, 1000000)));
2799 -- Name: pipeline_instances_search_index; Type: INDEX; Schema: public; Owner: -
2802 CREATE INDEX pipeline_instances_search_index ON public.pipeline_instances USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, pipeline_template_uuid, name, state);
2806 -- Name: pipeline_instances_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2809 CREATE INDEX pipeline_instances_trgm_text_search_idx ON public.pipeline_instances USING gin (((((((((((((((((((((((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(pipeline_template_uuid, ''::character varying))::text) || ' '::text) || (COALESCE(name, ''::character varying))::text) || ' '::text) || COALESCE(components, ''::text)) || ' '::text) || COALESCE(properties, ''::text)) || ' '::text) || (COALESCE(state, ''::character varying))::text) || ' '::text) || COALESCE(components_summary, ''::text)) || ' '::text) || (COALESCE(description, ''::character varying))::text)) public.gin_trgm_ops);
2813 -- Name: pipeline_template_owner_uuid_name_unique; Type: INDEX; Schema: public; Owner: -
2816 CREATE UNIQUE INDEX pipeline_template_owner_uuid_name_unique ON public.pipeline_templates USING btree (owner_uuid, name);
2820 -- Name: pipeline_templates_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2823 CREATE INDEX pipeline_templates_full_text_search_idx ON public.pipeline_templates USING gin (to_tsvector('english'::regconfig, substr((((((((((((((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(components, ''::text)) || ' '::text) || (COALESCE(description, ''::character varying))::text), 0, 1000000)));
2827 -- Name: pipeline_templates_search_index; Type: INDEX; Schema: public; Owner: -
2830 CREATE INDEX pipeline_templates_search_index ON public.pipeline_templates USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2834 -- Name: pipeline_templates_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2837 CREATE INDEX pipeline_templates_trgm_text_search_idx ON public.pipeline_templates USING gin (((((((((((((((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(components, ''::text)) || ' '::text) || (COALESCE(description, ''::character varying))::text)) public.gin_trgm_ops);
2841 -- Name: repositories_search_index; Type: INDEX; Schema: public; Owner: -
2844 CREATE INDEX repositories_search_index ON public.repositories USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2848 -- Name: specimens_search_index; Type: INDEX; Schema: public; Owner: -
2851 CREATE INDEX specimens_search_index ON public.specimens USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, material);
2855 -- Name: traits_search_index; Type: INDEX; Schema: public; Owner: -
2858 CREATE INDEX traits_search_index ON public.traits USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2862 -- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -
2865 CREATE UNIQUE INDEX unique_schema_migrations ON public.schema_migrations USING btree (version);
2869 -- Name: users_search_index; Type: INDEX; Schema: public; Owner: -
2872 CREATE INDEX users_search_index ON public.users USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, email, first_name, last_name, identity_url, default_owner_uuid, username, redirect_to_user_uuid);
2876 -- Name: virtual_machines_search_index; Type: INDEX; Schema: public; Owner: -
2879 CREATE INDEX virtual_machines_search_index ON public.virtual_machines USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, hostname);
2883 -- Name: workflows_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2886 CREATE INDEX workflows_full_text_search_idx ON public.workflows USING gin (to_tsvector('english'::regconfig, substr((((((((((((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)), 0, 1000000)));
2890 -- Name: workflows_search_idx; Type: INDEX; Schema: public; Owner: -
2893 CREATE INDEX workflows_search_idx ON public.workflows USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2897 -- Name: workflows_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2900 CREATE INDEX workflows_trgm_text_search_idx ON public.workflows USING gin (((((((((((((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))) public.gin_trgm_ops);
2904 -- PostgreSQL database dump complete
2907 SET search_path TO "$user", public;
2909 INSERT INTO "schema_migrations" (version) VALUES