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 /* The purpose of this function is to compute the permissions for a
50 subgraph of the database, starting from a given edge. The newly
51 computed permissions are used to add and remove rows from the main
54 perm_origin_uuid: The object that 'gets' the permission.
56 starting_uuid: The starting object the permission applies to.
58 starting_perm: The permission that perm_origin_uuid 'has' on
59 starting_uuid One of 1, 2, 3 for can_read,
60 can_write, can_manage respectively, or 0 to revoke
64 /* Starting from starting_uuid, determine the set of objects that
65 could be affected by this permission change.
67 Note: We don't traverse users unless it is an "identity"
68 permission (permission origin is self).
70 perm_from_start(perm_origin_uuid, target_uuid, val, traverse_owned) as (
73 traverse_graph(origin_uuid, target_uuid, val, traverse_owned, starting_set) as (
75 values (perm_origin_uuid, starting_uuid, starting_perm,
76 should_traverse_owned(starting_uuid, starting_perm),
77 (perm_origin_uuid = starting_uuid or starting_uuid not like '_____-tpzed-_______________'))
80 (select traverse_graph.origin_uuid,
85 case (edges.tail_uuid = perm_origin_uuid AND
86 edges.head_uuid = starting_uuid)
87 when true then starting_perm
91 should_traverse_owned(edges.head_uuid, edges.val),
93 from permission_graph_edges as edges, traverse_graph
94 where traverse_graph.target_uuid = edges.tail_uuid
95 and (edges.tail_uuid like '_____-j7d0g-_______________' or
96 traverse_graph.starting_set)))
97 select traverse_graph.origin_uuid, target_uuid, max(val) as val, bool_or(traverse_owned) as traverse_owned from traverse_graph
98 group by (traverse_graph.origin_uuid, target_uuid)
101 /* Find other inbound edges that grant permissions to 'targets' in
102 perm_from_start, and compute permissions that originate from
105 This is necessary for two reasons:
107 1) Other users may have access to a subset of the objects
108 through other permission links than the one we started from.
109 If we don't recompute them, their permission will get dropped.
111 2) There may be more than one path through which a user gets
112 permission to an object. For example, a user owns a project
113 and also shares it can_read with a group the user belongs
114 to. adding the can_read link must not overwrite the existing
115 can_manage permission granted by ownership.
117 additional_perms(perm_origin_uuid, target_uuid, val, traverse_owned) as (
120 traverse_graph(origin_uuid, target_uuid, val, traverse_owned, starting_set) as (
122 select edges.tail_uuid as origin_uuid, edges.head_uuid as target_uuid, edges.val,
123 should_traverse_owned(edges.head_uuid, edges.val),
124 edges.head_uuid like '_____-j7d0g-_______________'
125 from permission_graph_edges as edges
126 where (not (edges.tail_uuid = perm_origin_uuid and
127 edges.head_uuid = starting_uuid)) and
128 edges.tail_uuid not in (select target_uuid from perm_from_start where target_uuid like '_____-j7d0g-_______________') and
129 edges.head_uuid in (select target_uuid from perm_from_start)
132 (select traverse_graph.origin_uuid,
137 case (edges.tail_uuid = perm_origin_uuid AND
138 edges.head_uuid = starting_uuid)
139 when true then starting_perm
143 should_traverse_owned(edges.head_uuid, edges.val),
145 from permission_graph_edges as edges, traverse_graph
146 where traverse_graph.target_uuid = edges.tail_uuid
147 and (edges.tail_uuid like '_____-j7d0g-_______________' or
148 traverse_graph.starting_set)))
149 select traverse_graph.origin_uuid, target_uuid, max(val) as val, bool_or(traverse_owned) as traverse_owned from traverse_graph
150 group by (traverse_graph.origin_uuid, target_uuid)
153 /* Combine the permissions computed in the first two phases. */
154 all_perms(perm_origin_uuid, target_uuid, val, traverse_owned) as (
155 select * from perm_from_start
157 select * from additional_perms
160 /* The actual query that produces rows to be added or removed
161 from the materialized_permissions table. This is the clever
166 * For every group, the materialized_permissions lists all users
167 that can access to that group.
169 * The all_perms subquery has computed permissions on on a set of
170 objects for all inbound "origins", which are users or groups.
172 * Permissions through groups are transitive.
176 1) The materialized_permissions table declares that user X has permission N on group Y
177 2) The all_perms result has determined group Y has permission M on object Z
178 3) Therefore, user X has permission min(N, M) on object Z
180 This allows us to efficiently determine the set of users that
181 have permissions on the subset of objects, without having to
182 follow the chain of permission back up to find those users.
184 In addition, because users always have permission on themselves, this
185 query also makes sure those permission rows are always
188 select v.user_uuid, v.target_uuid, max(v.perm_level), bool_or(v.traverse_owned) from
191 least(u.val, m.perm_level) as perm_level,
193 from all_perms as u, materialized_permissions as m
194 where u.perm_origin_uuid = m.target_uuid AND m.traverse_owned
195 AND (m.user_uuid = m.target_uuid or m.target_uuid not like '_____-tpzed-_______________')
197 select target_uuid as user_uuid, target_uuid, 3, true
199 where all_perms.target_uuid like '_____-tpzed-_______________') as v
200 group by v.user_uuid, v.target_uuid
205 -- Name: project_subtree_with_trash_at(character varying, timestamp without time zone); Type: FUNCTION; Schema: public; Owner: -
208 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)
211 /* Starting from a project, recursively traverse all the projects
212 underneath it and return a set of project uuids and trash_at times
213 (may be null). The initial trash_at can be a timestamp or null.
214 The trash_at time propagates downward to groups it owns, i.e. when a
215 group is trashed, everything underneath it in the ownership
216 hierarchy is also considered trashed. However, this is fact is
217 recorded in the trashed_groups table, not by updating trash_at field
221 project_subtree(uuid, trash_at) as (
222 values (starting_uuid, starting_trash_at)
224 select groups.uuid, LEAST(project_subtree.trash_at, groups.trash_at)
225 from groups join project_subtree on (groups.owner_uuid = project_subtree.uuid)
227 select uuid, trash_at from project_subtree;
232 -- Name: should_traverse_owned(character varying, integer); Type: FUNCTION; Schema: public; Owner: -
235 CREATE FUNCTION public.should_traverse_owned(starting_uuid character varying, starting_perm integer) RETURNS boolean
236 LANGUAGE sql IMMUTABLE
238 /* Helper function. Determines if permission on an object implies
239 transitive permission to things the object owns. This is always
240 true for groups, but only true for users when the permission level
243 select starting_uuid like '_____-j7d0g-_______________' or
244 (starting_uuid like '_____-tpzed-_______________' and starting_perm >= 3);
248 SET default_tablespace = '';
250 SET default_with_oids = false;
253 -- Name: api_client_authorizations; Type: TABLE; Schema: public; Owner: -
256 CREATE TABLE public.api_client_authorizations (
258 api_token character varying(255) NOT NULL,
259 api_client_id integer NOT NULL,
260 user_id integer NOT NULL,
261 created_by_ip_address character varying(255),
262 last_used_by_ip_address character varying(255),
263 last_used_at timestamp without time zone,
264 expires_at timestamp without time zone,
265 created_at timestamp without time zone NOT NULL,
266 updated_at timestamp without time zone NOT NULL,
267 default_owner_uuid character varying(255),
268 scopes text DEFAULT '["all"]'::text,
269 uuid character varying(255) NOT NULL
274 -- Name: api_client_authorizations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
277 CREATE SEQUENCE public.api_client_authorizations_id_seq
286 -- Name: api_client_authorizations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
289 ALTER SEQUENCE public.api_client_authorizations_id_seq OWNED BY public.api_client_authorizations.id;
293 -- Name: api_clients; Type: TABLE; Schema: public; Owner: -
296 CREATE TABLE public.api_clients (
298 uuid character varying(255),
299 owner_uuid character varying(255),
300 modified_by_client_uuid character varying(255),
301 modified_by_user_uuid character varying(255),
302 modified_at timestamp without time zone,
303 name character varying(255),
304 url_prefix character varying(255),
305 created_at timestamp without time zone NOT NULL,
306 updated_at timestamp without time zone NOT NULL,
307 is_trusted boolean DEFAULT false
312 -- Name: api_clients_id_seq; Type: SEQUENCE; Schema: public; Owner: -
315 CREATE SEQUENCE public.api_clients_id_seq
324 -- Name: api_clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
327 ALTER SEQUENCE public.api_clients_id_seq OWNED BY public.api_clients.id;
331 -- Name: ar_internal_metadata; Type: TABLE; Schema: public; Owner: -
334 CREATE TABLE public.ar_internal_metadata (
335 key character varying NOT NULL,
336 value character varying,
337 created_at timestamp without time zone NOT NULL,
338 updated_at timestamp without time zone NOT NULL
343 -- Name: authorized_keys; Type: TABLE; Schema: public; Owner: -
346 CREATE TABLE public.authorized_keys (
348 uuid character varying(255) NOT NULL,
349 owner_uuid character varying(255) NOT NULL,
350 modified_by_client_uuid character varying(255),
351 modified_by_user_uuid character varying(255),
352 modified_at timestamp without time zone,
353 name character varying(255),
354 key_type character varying(255),
355 authorized_user_uuid character varying(255),
357 expires_at timestamp without time zone,
358 created_at timestamp without time zone NOT NULL,
359 updated_at timestamp without time zone NOT NULL
364 -- Name: authorized_keys_id_seq; Type: SEQUENCE; Schema: public; Owner: -
367 CREATE SEQUENCE public.authorized_keys_id_seq
376 -- Name: authorized_keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
379 ALTER SEQUENCE public.authorized_keys_id_seq OWNED BY public.authorized_keys.id;
383 -- Name: collections; Type: TABLE; Schema: public; Owner: -
386 CREATE TABLE public.collections (
388 owner_uuid character varying(255),
389 created_at timestamp without time zone NOT NULL,
390 modified_by_client_uuid character varying(255),
391 modified_by_user_uuid character varying(255),
392 modified_at timestamp without time zone,
393 portable_data_hash character varying(255),
394 replication_desired integer,
395 replication_confirmed_at timestamp without time zone,
396 replication_confirmed integer,
397 updated_at timestamp without time zone NOT NULL,
398 uuid character varying(255),
400 name character varying(255),
401 description character varying(524288),
403 delete_at timestamp without time zone,
405 trash_at timestamp without time zone,
406 is_trashed boolean DEFAULT false NOT NULL,
407 storage_classes_desired jsonb DEFAULT '["default"]'::jsonb,
408 storage_classes_confirmed jsonb DEFAULT '[]'::jsonb,
409 storage_classes_confirmed_at timestamp without time zone,
410 current_version_uuid character varying,
411 version integer DEFAULT 1 NOT NULL,
412 preserve_version boolean DEFAULT false,
413 file_count integer DEFAULT 0 NOT NULL,
414 file_size_total bigint DEFAULT 0 NOT NULL
419 -- Name: collections_id_seq; Type: SEQUENCE; Schema: public; Owner: -
422 CREATE SEQUENCE public.collections_id_seq
431 -- Name: collections_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
434 ALTER SEQUENCE public.collections_id_seq OWNED BY public.collections.id;
438 -- Name: container_requests; Type: TABLE; Schema: public; Owner: -
441 CREATE TABLE public.container_requests (
443 uuid character varying(255),
444 owner_uuid character varying(255),
445 created_at timestamp without time zone NOT NULL,
446 modified_at timestamp without time zone,
447 modified_by_client_uuid character varying(255),
448 modified_by_user_uuid character varying(255),
449 name character varying(255),
452 state character varying(255),
453 requesting_container_uuid character varying(255),
454 container_uuid character varying(255),
455 container_count_max integer,
457 runtime_constraints text,
458 container_image character varying(255),
460 cwd character varying(255),
462 output_path character varying(255),
464 expires_at timestamp without time zone,
466 updated_at timestamp without time zone NOT NULL,
467 container_count integer DEFAULT 0,
468 use_existing boolean DEFAULT true,
469 scheduling_parameters text,
470 output_uuid character varying(255),
471 log_uuid character varying(255),
472 output_name character varying(255) DEFAULT NULL::character varying,
473 output_ttl integer DEFAULT 0 NOT NULL,
474 secret_mounts jsonb DEFAULT '{}'::jsonb,
480 -- Name: container_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: -
483 CREATE SEQUENCE public.container_requests_id_seq
492 -- Name: container_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
495 ALTER SEQUENCE public.container_requests_id_seq OWNED BY public.container_requests.id;
499 -- Name: containers; Type: TABLE; Schema: public; Owner: -
502 CREATE TABLE public.containers (
504 uuid character varying(255),
505 owner_uuid character varying(255),
506 created_at timestamp without time zone NOT NULL,
507 modified_at timestamp without time zone,
508 modified_by_client_uuid character varying(255),
509 modified_by_user_uuid character varying(255),
510 state character varying(255),
511 started_at timestamp without time zone,
512 finished_at timestamp without time zone,
513 log character varying(255),
515 cwd character varying(255),
517 output_path character varying(255),
519 runtime_constraints text,
520 output character varying(255),
521 container_image character varying(255),
522 progress double precision,
524 updated_at timestamp without time zone NOT NULL,
526 auth_uuid character varying(255),
527 locked_by_uuid character varying(255),
528 scheduling_parameters text,
529 secret_mounts jsonb DEFAULT '{}'::jsonb,
530 secret_mounts_md5 character varying DEFAULT '99914b932bd37a50b983c5e7c90ae93b'::character varying,
531 runtime_status jsonb DEFAULT '{}'::jsonb,
532 runtime_user_uuid text,
533 runtime_auth_scopes jsonb,
535 lock_count integer DEFAULT 0 NOT NULL
540 -- Name: containers_id_seq; Type: SEQUENCE; Schema: public; Owner: -
543 CREATE SEQUENCE public.containers_id_seq
552 -- Name: containers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
555 ALTER SEQUENCE public.containers_id_seq OWNED BY public.containers.id;
559 -- Name: groups; Type: TABLE; Schema: public; Owner: -
562 CREATE TABLE public.groups (
564 uuid character varying(255),
565 owner_uuid character varying(255),
566 created_at timestamp without time zone NOT NULL,
567 modified_by_client_uuid character varying(255),
568 modified_by_user_uuid character varying(255),
569 modified_at timestamp without time zone,
570 name character varying(255) NOT NULL,
571 description character varying(524288),
572 updated_at timestamp without time zone NOT NULL,
573 group_class character varying(255),
574 trash_at timestamp without time zone,
575 is_trashed boolean DEFAULT false NOT NULL,
576 delete_at timestamp without time zone,
577 properties jsonb DEFAULT '{}'::jsonb
582 -- Name: groups_id_seq; Type: SEQUENCE; Schema: public; Owner: -
585 CREATE SEQUENCE public.groups_id_seq
594 -- Name: groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
597 ALTER SEQUENCE public.groups_id_seq OWNED BY public.groups.id;
601 -- Name: humans; Type: TABLE; Schema: public; Owner: -
604 CREATE TABLE public.humans (
606 uuid character varying(255) NOT NULL,
607 owner_uuid character varying(255) NOT NULL,
608 modified_by_client_uuid character varying(255),
609 modified_by_user_uuid character varying(255),
610 modified_at timestamp without time zone,
612 created_at timestamp without time zone NOT NULL,
613 updated_at timestamp without time zone NOT NULL
618 -- Name: humans_id_seq; Type: SEQUENCE; Schema: public; Owner: -
621 CREATE SEQUENCE public.humans_id_seq
630 -- Name: humans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
633 ALTER SEQUENCE public.humans_id_seq OWNED BY public.humans.id;
637 -- Name: job_tasks; Type: TABLE; Schema: public; Owner: -
640 CREATE TABLE public.job_tasks (
642 uuid character varying(255),
643 owner_uuid character varying(255),
644 modified_by_client_uuid character varying(255),
645 modified_by_user_uuid character varying(255),
646 modified_at timestamp without time zone,
647 job_uuid character varying(255),
651 progress double precision,
653 created_at timestamp without time zone NOT NULL,
654 updated_at timestamp without time zone NOT NULL,
655 created_by_job_task_uuid character varying(255),
657 started_at timestamp without time zone,
658 finished_at timestamp without time zone
663 -- Name: job_tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
666 CREATE SEQUENCE public.job_tasks_id_seq
675 -- Name: job_tasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
678 ALTER SEQUENCE public.job_tasks_id_seq OWNED BY public.job_tasks.id;
682 -- Name: job_tasks_qsequence_seq; Type: SEQUENCE; Schema: public; Owner: -
685 CREATE SEQUENCE public.job_tasks_qsequence_seq
694 -- Name: job_tasks_qsequence_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
697 ALTER SEQUENCE public.job_tasks_qsequence_seq OWNED BY public.job_tasks.qsequence;
701 -- Name: jobs; Type: TABLE; Schema: public; Owner: -
704 CREATE TABLE public.jobs (
706 uuid character varying(255),
707 owner_uuid character varying(255),
708 modified_by_client_uuid character varying(255),
709 modified_by_user_uuid character varying(255),
710 modified_at timestamp without time zone,
711 submit_id character varying(255),
712 script character varying(255),
713 script_version character varying(255),
714 script_parameters text,
715 cancelled_by_client_uuid character varying(255),
716 cancelled_by_user_uuid character varying(255),
717 cancelled_at timestamp without time zone,
718 started_at timestamp without time zone,
719 finished_at timestamp without time zone,
722 output character varying(255),
723 created_at timestamp without time zone NOT NULL,
724 updated_at timestamp without time zone NOT NULL,
725 is_locked_by_uuid character varying(255),
726 log character varying(255),
728 runtime_constraints text,
729 nondeterministic boolean,
730 repository character varying(255),
731 supplied_script_version character varying(255),
732 docker_image_locator character varying(255),
733 priority integer DEFAULT 0 NOT NULL,
734 description character varying(524288),
735 state character varying(255),
736 arvados_sdk_version character varying(255),
738 script_parameters_digest character varying(255)
743 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
746 CREATE SEQUENCE public.jobs_id_seq
755 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
758 ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;
762 -- Name: keep_disks; Type: TABLE; Schema: public; Owner: -
765 CREATE TABLE public.keep_disks (
767 uuid character varying(255) NOT NULL,
768 owner_uuid character varying(255) NOT NULL,
769 modified_by_client_uuid character varying(255),
770 modified_by_user_uuid character varying(255),
771 modified_at timestamp without time zone,
772 ping_secret character varying(255) NOT NULL,
773 node_uuid character varying(255),
774 filesystem_uuid character varying(255),
777 is_readable boolean DEFAULT true NOT NULL,
778 is_writable boolean DEFAULT true NOT NULL,
779 last_read_at timestamp without time zone,
780 last_write_at timestamp without time zone,
781 last_ping_at timestamp without time zone,
782 created_at timestamp without time zone NOT NULL,
783 updated_at timestamp without time zone NOT NULL,
784 keep_service_uuid character varying(255)
789 -- Name: keep_disks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
792 CREATE SEQUENCE public.keep_disks_id_seq
801 -- Name: keep_disks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
804 ALTER SEQUENCE public.keep_disks_id_seq OWNED BY public.keep_disks.id;
808 -- Name: keep_services; Type: TABLE; Schema: public; Owner: -
811 CREATE TABLE public.keep_services (
813 uuid character varying(255) NOT NULL,
814 owner_uuid character varying(255) NOT NULL,
815 modified_by_client_uuid character varying(255),
816 modified_by_user_uuid character varying(255),
817 modified_at timestamp without time zone,
818 service_host character varying(255),
819 service_port integer,
820 service_ssl_flag boolean,
821 service_type character varying(255),
822 created_at timestamp without time zone NOT NULL,
823 updated_at timestamp without time zone NOT NULL,
824 read_only boolean DEFAULT false NOT NULL
829 -- Name: keep_services_id_seq; Type: SEQUENCE; Schema: public; Owner: -
832 CREATE SEQUENCE public.keep_services_id_seq
841 -- Name: keep_services_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
844 ALTER SEQUENCE public.keep_services_id_seq OWNED BY public.keep_services.id;
848 -- Name: links; Type: TABLE; Schema: public; Owner: -
851 CREATE TABLE public.links (
853 uuid character varying(255),
854 owner_uuid character varying(255),
855 created_at timestamp without time zone NOT NULL,
856 modified_by_client_uuid character varying(255),
857 modified_by_user_uuid character varying(255),
858 modified_at timestamp without time zone,
859 tail_uuid character varying(255),
860 link_class character varying(255),
861 name character varying(255),
862 head_uuid character varying(255),
864 updated_at timestamp without time zone NOT NULL
869 -- Name: links_id_seq; Type: SEQUENCE; Schema: public; Owner: -
872 CREATE SEQUENCE public.links_id_seq
881 -- Name: links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
884 ALTER SEQUENCE public.links_id_seq OWNED BY public.links.id;
888 -- Name: logs; Type: TABLE; Schema: public; Owner: -
891 CREATE TABLE public.logs (
893 uuid character varying(255),
894 owner_uuid character varying(255),
895 modified_by_client_uuid character varying(255),
896 modified_by_user_uuid character varying(255),
897 object_uuid character varying(255),
898 event_at timestamp without time zone,
899 event_type character varying(255),
902 created_at timestamp without time zone NOT NULL,
903 updated_at timestamp without time zone NOT NULL,
904 modified_at timestamp without time zone,
905 object_owner_uuid character varying(255)
910 -- Name: logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
913 CREATE SEQUENCE public.logs_id_seq
922 -- Name: logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
925 ALTER SEQUENCE public.logs_id_seq OWNED BY public.logs.id;
929 -- Name: materialized_permissions; Type: TABLE; Schema: public; Owner: -
932 CREATE TABLE public.materialized_permissions (
933 user_uuid character varying,
934 target_uuid character varying,
936 traverse_owned boolean
941 -- Name: nodes; Type: TABLE; Schema: public; Owner: -
944 CREATE TABLE public.nodes (
946 uuid character varying(255),
947 owner_uuid character varying(255),
948 created_at timestamp without time zone NOT NULL,
949 modified_by_client_uuid character varying(255),
950 modified_by_user_uuid character varying(255),
951 modified_at timestamp without time zone,
953 hostname character varying(255),
954 domain character varying(255),
955 ip_address character varying(255),
956 first_ping_at timestamp without time zone,
957 last_ping_at timestamp without time zone,
959 updated_at timestamp without time zone NOT NULL,
961 job_uuid character varying(255)
966 -- Name: nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
969 CREATE SEQUENCE public.nodes_id_seq
978 -- Name: nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
981 ALTER SEQUENCE public.nodes_id_seq OWNED BY public.nodes.id;
985 -- Name: users; Type: TABLE; Schema: public; Owner: -
988 CREATE TABLE public.users (
990 uuid character varying(255),
991 owner_uuid character varying(255) NOT NULL,
992 created_at timestamp without time zone NOT NULL,
993 modified_by_client_uuid character varying(255),
994 modified_by_user_uuid character varying(255),
995 modified_at timestamp without time zone,
996 email character varying(255),
997 first_name character varying(255),
998 last_name character varying(255),
999 identity_url character varying(255),
1002 updated_at timestamp without time zone NOT NULL,
1003 default_owner_uuid character varying(255),
1004 is_active boolean DEFAULT false,
1005 username character varying(255),
1006 redirect_to_user_uuid character varying
1011 -- Name: permission_graph_edges; Type: VIEW; Schema: public; Owner: -
1014 CREATE VIEW public.permission_graph_edges AS
1015 SELECT groups.owner_uuid AS tail_uuid,
1016 groups.uuid AS head_uuid,
1020 SELECT users.owner_uuid AS tail_uuid,
1021 users.uuid AS head_uuid,
1025 SELECT users.uuid AS tail_uuid,
1026 users.uuid AS head_uuid,
1030 SELECT links.tail_uuid,
1033 WHEN ((links.name)::text = 'can_read'::text) THEN 1
1034 WHEN ((links.name)::text = 'can_login'::text) THEN 1
1035 WHEN ((links.name)::text = 'can_write'::text) THEN 2
1036 WHEN ((links.name)::text = 'can_manage'::text) THEN 3
1040 WHERE ((links.link_class)::text = 'permission'::text);
1044 -- Name: pipeline_instances; Type: TABLE; Schema: public; Owner: -
1047 CREATE TABLE public.pipeline_instances (
1048 id integer NOT NULL,
1049 uuid character varying(255),
1050 owner_uuid character varying(255),
1051 created_at timestamp without time zone NOT NULL,
1052 modified_by_client_uuid character varying(255),
1053 modified_by_user_uuid character varying(255),
1054 modified_at timestamp without time zone,
1055 pipeline_template_uuid character varying(255),
1056 name character varying(255),
1058 updated_at timestamp without time zone NOT NULL,
1060 state character varying(255),
1061 components_summary text,
1062 started_at timestamp without time zone,
1063 finished_at timestamp without time zone,
1064 description character varying(524288)
1069 -- Name: pipeline_instances_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1072 CREATE SEQUENCE public.pipeline_instances_id_seq
1081 -- Name: pipeline_instances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1084 ALTER SEQUENCE public.pipeline_instances_id_seq OWNED BY public.pipeline_instances.id;
1088 -- Name: pipeline_templates; Type: TABLE; Schema: public; Owner: -
1091 CREATE TABLE public.pipeline_templates (
1092 id integer NOT NULL,
1093 uuid character varying(255),
1094 owner_uuid character varying(255),
1095 created_at timestamp without time zone NOT NULL,
1096 modified_by_client_uuid character varying(255),
1097 modified_by_user_uuid character varying(255),
1098 modified_at timestamp without time zone,
1099 name character varying(255),
1101 updated_at timestamp without time zone NOT NULL,
1102 description character varying(524288)
1107 -- Name: pipeline_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1110 CREATE SEQUENCE public.pipeline_templates_id_seq
1119 -- Name: pipeline_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1122 ALTER SEQUENCE public.pipeline_templates_id_seq OWNED BY public.pipeline_templates.id;
1126 -- Name: repositories; Type: TABLE; Schema: public; Owner: -
1129 CREATE TABLE public.repositories (
1130 id integer NOT NULL,
1131 uuid character varying(255) NOT NULL,
1132 owner_uuid character varying(255) NOT NULL,
1133 modified_by_client_uuid character varying(255),
1134 modified_by_user_uuid character varying(255),
1135 modified_at timestamp without time zone,
1136 name character varying(255),
1137 created_at timestamp without time zone NOT NULL,
1138 updated_at timestamp without time zone NOT NULL
1143 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1146 CREATE SEQUENCE public.repositories_id_seq
1155 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1158 ALTER SEQUENCE public.repositories_id_seq OWNED BY public.repositories.id;
1162 -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -
1165 CREATE TABLE public.schema_migrations (
1166 version character varying(255) NOT NULL
1171 -- Name: specimens; Type: TABLE; Schema: public; Owner: -
1174 CREATE TABLE public.specimens (
1175 id integer NOT NULL,
1176 uuid character varying(255),
1177 owner_uuid character varying(255),
1178 created_at timestamp without time zone NOT NULL,
1179 modified_by_client_uuid character varying(255),
1180 modified_by_user_uuid character varying(255),
1181 modified_at timestamp without time zone,
1182 material character varying(255),
1183 updated_at timestamp without time zone NOT NULL,
1189 -- Name: specimens_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1192 CREATE SEQUENCE public.specimens_id_seq
1201 -- Name: specimens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1204 ALTER SEQUENCE public.specimens_id_seq OWNED BY public.specimens.id;
1208 -- Name: traits; Type: TABLE; Schema: public; Owner: -
1211 CREATE TABLE public.traits (
1212 id integer NOT NULL,
1213 uuid character varying(255) NOT NULL,
1214 owner_uuid character varying(255) NOT NULL,
1215 modified_by_client_uuid character varying(255),
1216 modified_by_user_uuid character varying(255),
1217 modified_at timestamp without time zone,
1218 name character varying(255),
1220 created_at timestamp without time zone NOT NULL,
1221 updated_at timestamp without time zone NOT NULL
1226 -- Name: traits_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1229 CREATE SEQUENCE public.traits_id_seq
1238 -- Name: traits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1241 ALTER SEQUENCE public.traits_id_seq OWNED BY public.traits.id;
1245 -- Name: trashed_groups; Type: TABLE; Schema: public; Owner: -
1248 CREATE TABLE public.trashed_groups (
1249 group_uuid character varying,
1250 trash_at timestamp without time zone
1255 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1258 CREATE SEQUENCE public.users_id_seq
1267 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1270 ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
1274 -- Name: virtual_machines; Type: TABLE; Schema: public; Owner: -
1277 CREATE TABLE public.virtual_machines (
1278 id integer NOT NULL,
1279 uuid character varying(255) NOT NULL,
1280 owner_uuid character varying(255) NOT NULL,
1281 modified_by_client_uuid character varying(255),
1282 modified_by_user_uuid character varying(255),
1283 modified_at timestamp without time zone,
1284 hostname character varying(255),
1285 created_at timestamp without time zone NOT NULL,
1286 updated_at timestamp without time zone NOT NULL
1291 -- Name: virtual_machines_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1294 CREATE SEQUENCE public.virtual_machines_id_seq
1303 -- Name: virtual_machines_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1306 ALTER SEQUENCE public.virtual_machines_id_seq OWNED BY public.virtual_machines.id;
1310 -- Name: workflows; Type: TABLE; Schema: public; Owner: -
1313 CREATE TABLE public.workflows (
1314 id integer NOT NULL,
1315 uuid character varying(255),
1316 owner_uuid character varying(255),
1317 created_at timestamp without time zone NOT NULL,
1318 modified_at timestamp without time zone,
1319 modified_by_client_uuid character varying(255),
1320 modified_by_user_uuid character varying(255),
1321 name character varying(255),
1324 updated_at timestamp without time zone NOT NULL
1329 -- Name: workflows_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1332 CREATE SEQUENCE public.workflows_id_seq
1341 -- Name: workflows_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1344 ALTER SEQUENCE public.workflows_id_seq OWNED BY public.workflows.id;
1348 -- Name: api_client_authorizations id; Type: DEFAULT; Schema: public; Owner: -
1351 ALTER TABLE ONLY public.api_client_authorizations ALTER COLUMN id SET DEFAULT nextval('public.api_client_authorizations_id_seq'::regclass);
1355 -- Name: api_clients id; Type: DEFAULT; Schema: public; Owner: -
1358 ALTER TABLE ONLY public.api_clients ALTER COLUMN id SET DEFAULT nextval('public.api_clients_id_seq'::regclass);
1362 -- Name: authorized_keys id; Type: DEFAULT; Schema: public; Owner: -
1365 ALTER TABLE ONLY public.authorized_keys ALTER COLUMN id SET DEFAULT nextval('public.authorized_keys_id_seq'::regclass);
1369 -- Name: collections id; Type: DEFAULT; Schema: public; Owner: -
1372 ALTER TABLE ONLY public.collections ALTER COLUMN id SET DEFAULT nextval('public.collections_id_seq'::regclass);
1376 -- Name: container_requests id; Type: DEFAULT; Schema: public; Owner: -
1379 ALTER TABLE ONLY public.container_requests ALTER COLUMN id SET DEFAULT nextval('public.container_requests_id_seq'::regclass);
1383 -- Name: containers id; Type: DEFAULT; Schema: public; Owner: -
1386 ALTER TABLE ONLY public.containers ALTER COLUMN id SET DEFAULT nextval('public.containers_id_seq'::regclass);
1390 -- Name: groups id; Type: DEFAULT; Schema: public; Owner: -
1393 ALTER TABLE ONLY public.groups ALTER COLUMN id SET DEFAULT nextval('public.groups_id_seq'::regclass);
1397 -- Name: humans id; Type: DEFAULT; Schema: public; Owner: -
1400 ALTER TABLE ONLY public.humans ALTER COLUMN id SET DEFAULT nextval('public.humans_id_seq'::regclass);
1404 -- Name: job_tasks id; Type: DEFAULT; Schema: public; Owner: -
1407 ALTER TABLE ONLY public.job_tasks ALTER COLUMN id SET DEFAULT nextval('public.job_tasks_id_seq'::regclass);
1411 -- Name: jobs id; Type: DEFAULT; Schema: public; Owner: -
1414 ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass);
1418 -- Name: keep_disks id; Type: DEFAULT; Schema: public; Owner: -
1421 ALTER TABLE ONLY public.keep_disks ALTER COLUMN id SET DEFAULT nextval('public.keep_disks_id_seq'::regclass);
1425 -- Name: keep_services id; Type: DEFAULT; Schema: public; Owner: -
1428 ALTER TABLE ONLY public.keep_services ALTER COLUMN id SET DEFAULT nextval('public.keep_services_id_seq'::regclass);
1432 -- Name: links id; Type: DEFAULT; Schema: public; Owner: -
1435 ALTER TABLE ONLY public.links ALTER COLUMN id SET DEFAULT nextval('public.links_id_seq'::regclass);
1439 -- Name: logs id; Type: DEFAULT; Schema: public; Owner: -
1442 ALTER TABLE ONLY public.logs ALTER COLUMN id SET DEFAULT nextval('public.logs_id_seq'::regclass);
1446 -- Name: nodes id; Type: DEFAULT; Schema: public; Owner: -
1449 ALTER TABLE ONLY public.nodes ALTER COLUMN id SET DEFAULT nextval('public.nodes_id_seq'::regclass);
1453 -- Name: pipeline_instances id; Type: DEFAULT; Schema: public; Owner: -
1456 ALTER TABLE ONLY public.pipeline_instances ALTER COLUMN id SET DEFAULT nextval('public.pipeline_instances_id_seq'::regclass);
1460 -- Name: pipeline_templates id; Type: DEFAULT; Schema: public; Owner: -
1463 ALTER TABLE ONLY public.pipeline_templates ALTER COLUMN id SET DEFAULT nextval('public.pipeline_templates_id_seq'::regclass);
1467 -- Name: repositories id; Type: DEFAULT; Schema: public; Owner: -
1470 ALTER TABLE ONLY public.repositories ALTER COLUMN id SET DEFAULT nextval('public.repositories_id_seq'::regclass);
1474 -- Name: specimens id; Type: DEFAULT; Schema: public; Owner: -
1477 ALTER TABLE ONLY public.specimens ALTER COLUMN id SET DEFAULT nextval('public.specimens_id_seq'::regclass);
1481 -- Name: traits id; Type: DEFAULT; Schema: public; Owner: -
1484 ALTER TABLE ONLY public.traits ALTER COLUMN id SET DEFAULT nextval('public.traits_id_seq'::regclass);
1488 -- Name: users id; Type: DEFAULT; Schema: public; Owner: -
1491 ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
1495 -- Name: virtual_machines id; Type: DEFAULT; Schema: public; Owner: -
1498 ALTER TABLE ONLY public.virtual_machines ALTER COLUMN id SET DEFAULT nextval('public.virtual_machines_id_seq'::regclass);
1502 -- Name: workflows id; Type: DEFAULT; Schema: public; Owner: -
1505 ALTER TABLE ONLY public.workflows ALTER COLUMN id SET DEFAULT nextval('public.workflows_id_seq'::regclass);
1509 -- Name: api_client_authorizations api_client_authorizations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1512 ALTER TABLE ONLY public.api_client_authorizations
1513 ADD CONSTRAINT api_client_authorizations_pkey PRIMARY KEY (id);
1517 -- Name: api_clients api_clients_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1520 ALTER TABLE ONLY public.api_clients
1521 ADD CONSTRAINT api_clients_pkey PRIMARY KEY (id);
1525 -- Name: ar_internal_metadata ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1528 ALTER TABLE ONLY public.ar_internal_metadata
1529 ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);
1533 -- Name: authorized_keys authorized_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1536 ALTER TABLE ONLY public.authorized_keys
1537 ADD CONSTRAINT authorized_keys_pkey PRIMARY KEY (id);
1541 -- Name: collections collections_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1544 ALTER TABLE ONLY public.collections
1545 ADD CONSTRAINT collections_pkey PRIMARY KEY (id);
1549 -- Name: container_requests container_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1552 ALTER TABLE ONLY public.container_requests
1553 ADD CONSTRAINT container_requests_pkey PRIMARY KEY (id);
1557 -- Name: containers containers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1560 ALTER TABLE ONLY public.containers
1561 ADD CONSTRAINT containers_pkey PRIMARY KEY (id);
1565 -- Name: groups groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1568 ALTER TABLE ONLY public.groups
1569 ADD CONSTRAINT groups_pkey PRIMARY KEY (id);
1573 -- Name: humans humans_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1576 ALTER TABLE ONLY public.humans
1577 ADD CONSTRAINT humans_pkey PRIMARY KEY (id);
1581 -- Name: job_tasks job_tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1584 ALTER TABLE ONLY public.job_tasks
1585 ADD CONSTRAINT job_tasks_pkey PRIMARY KEY (id);
1589 -- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1592 ALTER TABLE ONLY public.jobs
1593 ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);
1597 -- Name: keep_disks keep_disks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1600 ALTER TABLE ONLY public.keep_disks
1601 ADD CONSTRAINT keep_disks_pkey PRIMARY KEY (id);
1605 -- Name: keep_services keep_services_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1608 ALTER TABLE ONLY public.keep_services
1609 ADD CONSTRAINT keep_services_pkey PRIMARY KEY (id);
1613 -- Name: links links_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1616 ALTER TABLE ONLY public.links
1617 ADD CONSTRAINT links_pkey PRIMARY KEY (id);
1621 -- Name: logs logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1624 ALTER TABLE ONLY public.logs
1625 ADD CONSTRAINT logs_pkey PRIMARY KEY (id);
1629 -- Name: nodes nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1632 ALTER TABLE ONLY public.nodes
1633 ADD CONSTRAINT nodes_pkey PRIMARY KEY (id);
1637 -- Name: pipeline_instances pipeline_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1640 ALTER TABLE ONLY public.pipeline_instances
1641 ADD CONSTRAINT pipeline_instances_pkey PRIMARY KEY (id);
1645 -- Name: pipeline_templates pipeline_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1648 ALTER TABLE ONLY public.pipeline_templates
1649 ADD CONSTRAINT pipeline_templates_pkey PRIMARY KEY (id);
1653 -- Name: repositories repositories_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1656 ALTER TABLE ONLY public.repositories
1657 ADD CONSTRAINT repositories_pkey PRIMARY KEY (id);
1661 -- Name: specimens specimens_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1664 ALTER TABLE ONLY public.specimens
1665 ADD CONSTRAINT specimens_pkey PRIMARY KEY (id);
1669 -- Name: traits traits_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1672 ALTER TABLE ONLY public.traits
1673 ADD CONSTRAINT traits_pkey PRIMARY KEY (id);
1677 -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1680 ALTER TABLE ONLY public.users
1681 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
1685 -- Name: virtual_machines virtual_machines_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1688 ALTER TABLE ONLY public.virtual_machines
1689 ADD CONSTRAINT virtual_machines_pkey PRIMARY KEY (id);
1693 -- Name: workflows workflows_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1696 ALTER TABLE ONLY public.workflows
1697 ADD CONSTRAINT workflows_pkey PRIMARY KEY (id);
1701 -- Name: api_client_authorizations_search_index; Type: INDEX; Schema: public; Owner: -
1704 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);
1708 -- Name: api_clients_search_index; Type: INDEX; Schema: public; Owner: -
1711 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);
1715 -- Name: authorized_keys_search_index; Type: INDEX; Schema: public; Owner: -
1718 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);
1722 -- Name: collection_index_on_properties; Type: INDEX; Schema: public; Owner: -
1725 CREATE INDEX collection_index_on_properties ON public.collections USING gin (properties);
1729 -- Name: collections_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
1732 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)));
1736 -- Name: collections_search_index; Type: INDEX; Schema: public; Owner: -
1739 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);
1743 -- Name: collections_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
1746 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);
1750 -- Name: container_requests_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
1753 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)));
1757 -- Name: container_requests_index_on_properties; Type: INDEX; Schema: public; Owner: -
1760 CREATE INDEX container_requests_index_on_properties ON public.container_requests USING gin (properties);
1764 -- Name: container_requests_search_index; Type: INDEX; Schema: public; Owner: -
1767 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);
1771 -- Name: container_requests_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
1774 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);
1778 -- Name: containers_search_index; Type: INDEX; Schema: public; Owner: -
1781 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);
1785 -- Name: group_index_on_properties; Type: INDEX; Schema: public; Owner: -
1788 CREATE INDEX group_index_on_properties ON public.groups USING gin (properties);
1792 -- Name: groups_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
1795 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)));
1799 -- Name: groups_search_index; Type: INDEX; Schema: public; Owner: -
1802 CREATE INDEX groups_search_index ON public.groups USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, group_class);
1806 -- Name: groups_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
1809 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);
1813 -- Name: humans_search_index; Type: INDEX; Schema: public; Owner: -
1816 CREATE INDEX humans_search_index ON public.humans USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid);
1820 -- Name: index_api_client_authorizations_on_api_client_id; Type: INDEX; Schema: public; Owner: -
1823 CREATE INDEX index_api_client_authorizations_on_api_client_id ON public.api_client_authorizations USING btree (api_client_id);
1827 -- Name: index_api_client_authorizations_on_api_token; Type: INDEX; Schema: public; Owner: -
1830 CREATE UNIQUE INDEX index_api_client_authorizations_on_api_token ON public.api_client_authorizations USING btree (api_token);
1834 -- Name: index_api_client_authorizations_on_expires_at; Type: INDEX; Schema: public; Owner: -
1837 CREATE INDEX index_api_client_authorizations_on_expires_at ON public.api_client_authorizations USING btree (expires_at);
1841 -- Name: index_api_client_authorizations_on_user_id; Type: INDEX; Schema: public; Owner: -
1844 CREATE INDEX index_api_client_authorizations_on_user_id ON public.api_client_authorizations USING btree (user_id);
1848 -- Name: index_api_client_authorizations_on_uuid; Type: INDEX; Schema: public; Owner: -
1851 CREATE UNIQUE INDEX index_api_client_authorizations_on_uuid ON public.api_client_authorizations USING btree (uuid);
1855 -- Name: index_api_clients_on_created_at; Type: INDEX; Schema: public; Owner: -
1858 CREATE INDEX index_api_clients_on_created_at ON public.api_clients USING btree (created_at);
1862 -- Name: index_api_clients_on_modified_at; Type: INDEX; Schema: public; Owner: -
1865 CREATE INDEX index_api_clients_on_modified_at ON public.api_clients USING btree (modified_at);
1869 -- Name: index_api_clients_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1872 CREATE INDEX index_api_clients_on_owner_uuid ON public.api_clients USING btree (owner_uuid);
1876 -- Name: index_api_clients_on_uuid; Type: INDEX; Schema: public; Owner: -
1879 CREATE UNIQUE INDEX index_api_clients_on_uuid ON public.api_clients USING btree (uuid);
1883 -- Name: index_authkeys_on_user_and_expires_at; Type: INDEX; Schema: public; Owner: -
1886 CREATE INDEX index_authkeys_on_user_and_expires_at ON public.authorized_keys USING btree (authorized_user_uuid, expires_at);
1890 -- Name: index_authorized_keys_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1893 CREATE INDEX index_authorized_keys_on_owner_uuid ON public.authorized_keys USING btree (owner_uuid);
1897 -- Name: index_authorized_keys_on_uuid; Type: INDEX; Schema: public; Owner: -
1900 CREATE UNIQUE INDEX index_authorized_keys_on_uuid ON public.authorized_keys USING btree (uuid);
1904 -- Name: index_collections_on_created_at; Type: INDEX; Schema: public; Owner: -
1907 CREATE INDEX index_collections_on_created_at ON public.collections USING btree (created_at);
1911 -- Name: index_collections_on_current_version_uuid_and_version; Type: INDEX; Schema: public; Owner: -
1914 CREATE UNIQUE INDEX index_collections_on_current_version_uuid_and_version ON public.collections USING btree (current_version_uuid, version);
1918 -- Name: index_collections_on_delete_at; Type: INDEX; Schema: public; Owner: -
1921 CREATE INDEX index_collections_on_delete_at ON public.collections USING btree (delete_at);
1925 -- Name: index_collections_on_is_trashed; Type: INDEX; Schema: public; Owner: -
1928 CREATE INDEX index_collections_on_is_trashed ON public.collections USING btree (is_trashed);
1932 -- Name: index_collections_on_modified_at; Type: INDEX; Schema: public; Owner: -
1935 CREATE INDEX index_collections_on_modified_at ON public.collections USING btree (modified_at);
1939 -- Name: index_collections_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
1942 CREATE INDEX index_collections_on_modified_at_uuid ON public.collections USING btree (modified_at DESC, uuid);
1946 -- Name: index_collections_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1949 CREATE INDEX index_collections_on_owner_uuid ON public.collections USING btree (owner_uuid);
1953 -- Name: index_collections_on_owner_uuid_and_name; Type: INDEX; Schema: public; Owner: -
1956 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));
1960 -- Name: index_collections_on_portable_data_hash_and_trash_at; Type: INDEX; Schema: public; Owner: -
1963 CREATE INDEX index_collections_on_portable_data_hash_and_trash_at ON public.collections USING btree (portable_data_hash, trash_at);
1967 -- Name: index_collections_on_trash_at; Type: INDEX; Schema: public; Owner: -
1970 CREATE INDEX index_collections_on_trash_at ON public.collections USING btree (trash_at);
1974 -- Name: index_collections_on_uuid; Type: INDEX; Schema: public; Owner: -
1977 CREATE UNIQUE INDEX index_collections_on_uuid ON public.collections USING btree (uuid);
1981 -- Name: index_container_requests_on_container_uuid; Type: INDEX; Schema: public; Owner: -
1984 CREATE INDEX index_container_requests_on_container_uuid ON public.container_requests USING btree (container_uuid);
1988 -- Name: index_container_requests_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
1991 CREATE INDEX index_container_requests_on_modified_at_uuid ON public.container_requests USING btree (modified_at DESC, uuid);
1995 -- Name: index_container_requests_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1998 CREATE INDEX index_container_requests_on_owner_uuid ON public.container_requests USING btree (owner_uuid);
2002 -- Name: index_container_requests_on_requesting_container_uuid; Type: INDEX; Schema: public; Owner: -
2005 CREATE INDEX index_container_requests_on_requesting_container_uuid ON public.container_requests USING btree (requesting_container_uuid);
2009 -- Name: index_container_requests_on_uuid; Type: INDEX; Schema: public; Owner: -
2012 CREATE UNIQUE INDEX index_container_requests_on_uuid ON public.container_requests USING btree (uuid);
2016 -- Name: index_containers_on_auth_uuid; Type: INDEX; Schema: public; Owner: -
2019 CREATE INDEX index_containers_on_auth_uuid ON public.containers USING btree (auth_uuid);
2023 -- Name: index_containers_on_locked_by_uuid_and_priority; Type: INDEX; Schema: public; Owner: -
2026 CREATE INDEX index_containers_on_locked_by_uuid_and_priority ON public.containers USING btree (locked_by_uuid, priority);
2030 -- Name: index_containers_on_locked_by_uuid_and_uuid; Type: INDEX; Schema: public; Owner: -
2033 CREATE INDEX index_containers_on_locked_by_uuid_and_uuid ON public.containers USING btree (locked_by_uuid, uuid);
2037 -- Name: index_containers_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2040 CREATE INDEX index_containers_on_modified_at_uuid ON public.containers USING btree (modified_at DESC, uuid);
2044 -- Name: index_containers_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2047 CREATE INDEX index_containers_on_owner_uuid ON public.containers USING btree (owner_uuid);
2051 -- Name: index_containers_on_queued_state; Type: INDEX; Schema: public; Owner: -
2054 CREATE INDEX index_containers_on_queued_state ON public.containers USING btree (state, ((priority > 0)));
2058 -- Name: index_containers_on_reuse_columns; Type: INDEX; Schema: public; Owner: -
2061 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));
2065 -- Name: index_containers_on_runtime_status; Type: INDEX; Schema: public; Owner: -
2068 CREATE INDEX index_containers_on_runtime_status ON public.containers USING gin (runtime_status);
2072 -- Name: index_containers_on_secret_mounts_md5; Type: INDEX; Schema: public; Owner: -
2075 CREATE INDEX index_containers_on_secret_mounts_md5 ON public.containers USING btree (secret_mounts_md5);
2079 -- Name: index_containers_on_uuid; Type: INDEX; Schema: public; Owner: -
2082 CREATE UNIQUE INDEX index_containers_on_uuid ON public.containers USING btree (uuid);
2086 -- Name: index_groups_on_created_at; Type: INDEX; Schema: public; Owner: -
2089 CREATE INDEX index_groups_on_created_at ON public.groups USING btree (created_at);
2093 -- Name: index_groups_on_delete_at; Type: INDEX; Schema: public; Owner: -
2096 CREATE INDEX index_groups_on_delete_at ON public.groups USING btree (delete_at);
2100 -- Name: index_groups_on_group_class; Type: INDEX; Schema: public; Owner: -
2103 CREATE INDEX index_groups_on_group_class ON public.groups USING btree (group_class);
2107 -- Name: index_groups_on_is_trashed; Type: INDEX; Schema: public; Owner: -
2110 CREATE INDEX index_groups_on_is_trashed ON public.groups USING btree (is_trashed);
2114 -- Name: index_groups_on_modified_at; Type: INDEX; Schema: public; Owner: -
2117 CREATE INDEX index_groups_on_modified_at ON public.groups USING btree (modified_at);
2121 -- Name: index_groups_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2124 CREATE INDEX index_groups_on_modified_at_uuid ON public.groups USING btree (modified_at DESC, uuid);
2128 -- Name: index_groups_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2131 CREATE INDEX index_groups_on_owner_uuid ON public.groups USING btree (owner_uuid);
2135 -- Name: index_groups_on_owner_uuid_and_name; Type: INDEX; Schema: public; Owner: -
2138 CREATE UNIQUE INDEX index_groups_on_owner_uuid_and_name ON public.groups USING btree (owner_uuid, name) WHERE (is_trashed = false);
2142 -- Name: index_groups_on_trash_at; Type: INDEX; Schema: public; Owner: -
2145 CREATE INDEX index_groups_on_trash_at ON public.groups USING btree (trash_at);
2149 -- Name: index_groups_on_uuid; Type: INDEX; Schema: public; Owner: -
2152 CREATE UNIQUE INDEX index_groups_on_uuid ON public.groups USING btree (uuid);
2156 -- Name: index_humans_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2159 CREATE INDEX index_humans_on_owner_uuid ON public.humans USING btree (owner_uuid);
2163 -- Name: index_humans_on_uuid; Type: INDEX; Schema: public; Owner: -
2166 CREATE UNIQUE INDEX index_humans_on_uuid ON public.humans USING btree (uuid);
2170 -- Name: index_job_tasks_on_created_at; Type: INDEX; Schema: public; Owner: -
2173 CREATE INDEX index_job_tasks_on_created_at ON public.job_tasks USING btree (created_at);
2177 -- Name: index_job_tasks_on_created_by_job_task_uuid; Type: INDEX; Schema: public; Owner: -
2180 CREATE INDEX index_job_tasks_on_created_by_job_task_uuid ON public.job_tasks USING btree (created_by_job_task_uuid);
2184 -- Name: index_job_tasks_on_job_uuid; Type: INDEX; Schema: public; Owner: -
2187 CREATE INDEX index_job_tasks_on_job_uuid ON public.job_tasks USING btree (job_uuid);
2191 -- Name: index_job_tasks_on_modified_at; Type: INDEX; Schema: public; Owner: -
2194 CREATE INDEX index_job_tasks_on_modified_at ON public.job_tasks USING btree (modified_at);
2198 -- Name: index_job_tasks_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2201 CREATE INDEX index_job_tasks_on_owner_uuid ON public.job_tasks USING btree (owner_uuid);
2205 -- Name: index_job_tasks_on_sequence; Type: INDEX; Schema: public; Owner: -
2208 CREATE INDEX index_job_tasks_on_sequence ON public.job_tasks USING btree (sequence);
2212 -- Name: index_job_tasks_on_success; Type: INDEX; Schema: public; Owner: -
2215 CREATE INDEX index_job_tasks_on_success ON public.job_tasks USING btree (success);
2219 -- Name: index_job_tasks_on_uuid; Type: INDEX; Schema: public; Owner: -
2222 CREATE UNIQUE INDEX index_job_tasks_on_uuid ON public.job_tasks USING btree (uuid);
2226 -- Name: index_jobs_on_created_at; Type: INDEX; Schema: public; Owner: -
2229 CREATE INDEX index_jobs_on_created_at ON public.jobs USING btree (created_at);
2233 -- Name: index_jobs_on_finished_at; Type: INDEX; Schema: public; Owner: -
2236 CREATE INDEX index_jobs_on_finished_at ON public.jobs USING btree (finished_at);
2240 -- Name: index_jobs_on_modified_at; Type: INDEX; Schema: public; Owner: -
2243 CREATE INDEX index_jobs_on_modified_at ON public.jobs USING btree (modified_at);
2247 -- Name: index_jobs_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2250 CREATE INDEX index_jobs_on_modified_at_uuid ON public.jobs USING btree (modified_at DESC, uuid);
2254 -- Name: index_jobs_on_output; Type: INDEX; Schema: public; Owner: -
2257 CREATE INDEX index_jobs_on_output ON public.jobs USING btree (output);
2261 -- Name: index_jobs_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2264 CREATE INDEX index_jobs_on_owner_uuid ON public.jobs USING btree (owner_uuid);
2268 -- Name: index_jobs_on_script; Type: INDEX; Schema: public; Owner: -
2271 CREATE INDEX index_jobs_on_script ON public.jobs USING btree (script);
2275 -- Name: index_jobs_on_script_parameters_digest; Type: INDEX; Schema: public; Owner: -
2278 CREATE INDEX index_jobs_on_script_parameters_digest ON public.jobs USING btree (script_parameters_digest);
2282 -- Name: index_jobs_on_started_at; Type: INDEX; Schema: public; Owner: -
2285 CREATE INDEX index_jobs_on_started_at ON public.jobs USING btree (started_at);
2289 -- Name: index_jobs_on_submit_id; Type: INDEX; Schema: public; Owner: -
2292 CREATE UNIQUE INDEX index_jobs_on_submit_id ON public.jobs USING btree (submit_id);
2296 -- Name: index_jobs_on_uuid; Type: INDEX; Schema: public; Owner: -
2299 CREATE UNIQUE INDEX index_jobs_on_uuid ON public.jobs USING btree (uuid);
2303 -- Name: index_keep_disks_on_filesystem_uuid; Type: INDEX; Schema: public; Owner: -
2306 CREATE INDEX index_keep_disks_on_filesystem_uuid ON public.keep_disks USING btree (filesystem_uuid);
2310 -- Name: index_keep_disks_on_last_ping_at; Type: INDEX; Schema: public; Owner: -
2313 CREATE INDEX index_keep_disks_on_last_ping_at ON public.keep_disks USING btree (last_ping_at);
2317 -- Name: index_keep_disks_on_node_uuid; Type: INDEX; Schema: public; Owner: -
2320 CREATE INDEX index_keep_disks_on_node_uuid ON public.keep_disks USING btree (node_uuid);
2324 -- Name: index_keep_disks_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2327 CREATE INDEX index_keep_disks_on_owner_uuid ON public.keep_disks USING btree (owner_uuid);
2331 -- Name: index_keep_disks_on_uuid; Type: INDEX; Schema: public; Owner: -
2334 CREATE UNIQUE INDEX index_keep_disks_on_uuid ON public.keep_disks USING btree (uuid);
2338 -- Name: index_keep_services_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2341 CREATE INDEX index_keep_services_on_owner_uuid ON public.keep_services USING btree (owner_uuid);
2345 -- Name: index_keep_services_on_uuid; Type: INDEX; Schema: public; Owner: -
2348 CREATE UNIQUE INDEX index_keep_services_on_uuid ON public.keep_services USING btree (uuid);
2352 -- Name: index_links_on_created_at; Type: INDEX; Schema: public; Owner: -
2355 CREATE INDEX index_links_on_created_at ON public.links USING btree (created_at);
2359 -- Name: index_links_on_head_uuid; Type: INDEX; Schema: public; Owner: -
2362 CREATE INDEX index_links_on_head_uuid ON public.links USING btree (head_uuid);
2366 -- Name: index_links_on_modified_at; Type: INDEX; Schema: public; Owner: -
2369 CREATE INDEX index_links_on_modified_at ON public.links USING btree (modified_at);
2373 -- Name: index_links_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2376 CREATE INDEX index_links_on_modified_at_uuid ON public.links USING btree (modified_at DESC, uuid);
2380 -- Name: index_links_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2383 CREATE INDEX index_links_on_owner_uuid ON public.links USING btree (owner_uuid);
2387 -- Name: index_links_on_substring_head_uuid; Type: INDEX; Schema: public; Owner: -
2390 CREATE INDEX index_links_on_substring_head_uuid ON public.links USING btree ("substring"((head_uuid)::text, 7, 5));
2394 -- Name: index_links_on_substring_tail_uuid; Type: INDEX; Schema: public; Owner: -
2397 CREATE INDEX index_links_on_substring_tail_uuid ON public.links USING btree ("substring"((tail_uuid)::text, 7, 5));
2401 -- Name: index_links_on_tail_uuid; Type: INDEX; Schema: public; Owner: -
2404 CREATE INDEX index_links_on_tail_uuid ON public.links USING btree (tail_uuid);
2408 -- Name: index_links_on_uuid; Type: INDEX; Schema: public; Owner: -
2411 CREATE UNIQUE INDEX index_links_on_uuid ON public.links USING btree (uuid);
2415 -- Name: index_logs_on_created_at; Type: INDEX; Schema: public; Owner: -
2418 CREATE INDEX index_logs_on_created_at ON public.logs USING btree (created_at);
2422 -- Name: index_logs_on_event_at; Type: INDEX; Schema: public; Owner: -
2425 CREATE INDEX index_logs_on_event_at ON public.logs USING btree (event_at);
2429 -- Name: index_logs_on_event_type; Type: INDEX; Schema: public; Owner: -
2432 CREATE INDEX index_logs_on_event_type ON public.logs USING btree (event_type);
2436 -- Name: index_logs_on_modified_at; Type: INDEX; Schema: public; Owner: -
2439 CREATE INDEX index_logs_on_modified_at ON public.logs USING btree (modified_at);
2443 -- Name: index_logs_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2446 CREATE INDEX index_logs_on_modified_at_uuid ON public.logs USING btree (modified_at DESC, uuid);
2450 -- Name: index_logs_on_object_owner_uuid; Type: INDEX; Schema: public; Owner: -
2453 CREATE INDEX index_logs_on_object_owner_uuid ON public.logs USING btree (object_owner_uuid);
2457 -- Name: index_logs_on_object_uuid; Type: INDEX; Schema: public; Owner: -
2460 CREATE INDEX index_logs_on_object_uuid ON public.logs USING btree (object_uuid);
2464 -- Name: index_logs_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2467 CREATE INDEX index_logs_on_owner_uuid ON public.logs USING btree (owner_uuid);
2471 -- Name: index_logs_on_summary; Type: INDEX; Schema: public; Owner: -
2474 CREATE INDEX index_logs_on_summary ON public.logs USING btree (summary);
2478 -- Name: index_logs_on_uuid; Type: INDEX; Schema: public; Owner: -
2481 CREATE UNIQUE INDEX index_logs_on_uuid ON public.logs USING btree (uuid);
2485 -- Name: index_nodes_on_created_at; Type: INDEX; Schema: public; Owner: -
2488 CREATE INDEX index_nodes_on_created_at ON public.nodes USING btree (created_at);
2492 -- Name: index_nodes_on_hostname; Type: INDEX; Schema: public; Owner: -
2495 CREATE INDEX index_nodes_on_hostname ON public.nodes USING btree (hostname);
2499 -- Name: index_nodes_on_modified_at; Type: INDEX; Schema: public; Owner: -
2502 CREATE INDEX index_nodes_on_modified_at ON public.nodes USING btree (modified_at);
2506 -- Name: index_nodes_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2509 CREATE INDEX index_nodes_on_owner_uuid ON public.nodes USING btree (owner_uuid);
2513 -- Name: index_nodes_on_slot_number; Type: INDEX; Schema: public; Owner: -
2516 CREATE UNIQUE INDEX index_nodes_on_slot_number ON public.nodes USING btree (slot_number);
2520 -- Name: index_nodes_on_uuid; Type: INDEX; Schema: public; Owner: -
2523 CREATE UNIQUE INDEX index_nodes_on_uuid ON public.nodes USING btree (uuid);
2527 -- Name: index_pipeline_instances_on_created_at; Type: INDEX; Schema: public; Owner: -
2530 CREATE INDEX index_pipeline_instances_on_created_at ON public.pipeline_instances USING btree (created_at);
2534 -- Name: index_pipeline_instances_on_modified_at; Type: INDEX; Schema: public; Owner: -
2537 CREATE INDEX index_pipeline_instances_on_modified_at ON public.pipeline_instances USING btree (modified_at);
2541 -- Name: index_pipeline_instances_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2544 CREATE INDEX index_pipeline_instances_on_modified_at_uuid ON public.pipeline_instances USING btree (modified_at DESC, uuid);
2548 -- Name: index_pipeline_instances_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2551 CREATE INDEX index_pipeline_instances_on_owner_uuid ON public.pipeline_instances USING btree (owner_uuid);
2555 -- Name: index_pipeline_instances_on_uuid; Type: INDEX; Schema: public; Owner: -
2558 CREATE UNIQUE INDEX index_pipeline_instances_on_uuid ON public.pipeline_instances USING btree (uuid);
2562 -- Name: index_pipeline_templates_on_created_at; Type: INDEX; Schema: public; Owner: -
2565 CREATE INDEX index_pipeline_templates_on_created_at ON public.pipeline_templates USING btree (created_at);
2569 -- Name: index_pipeline_templates_on_modified_at; Type: INDEX; Schema: public; Owner: -
2572 CREATE INDEX index_pipeline_templates_on_modified_at ON public.pipeline_templates USING btree (modified_at);
2576 -- Name: index_pipeline_templates_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2579 CREATE INDEX index_pipeline_templates_on_modified_at_uuid ON public.pipeline_templates USING btree (modified_at DESC, uuid);
2583 -- Name: index_pipeline_templates_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2586 CREATE INDEX index_pipeline_templates_on_owner_uuid ON public.pipeline_templates USING btree (owner_uuid);
2590 -- Name: index_pipeline_templates_on_uuid; Type: INDEX; Schema: public; Owner: -
2593 CREATE UNIQUE INDEX index_pipeline_templates_on_uuid ON public.pipeline_templates USING btree (uuid);
2597 -- Name: index_repositories_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2600 CREATE INDEX index_repositories_on_modified_at_uuid ON public.repositories USING btree (modified_at DESC, uuid);
2604 -- Name: index_repositories_on_name; Type: INDEX; Schema: public; Owner: -
2607 CREATE UNIQUE INDEX index_repositories_on_name ON public.repositories USING btree (name);
2611 -- Name: index_repositories_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2614 CREATE INDEX index_repositories_on_owner_uuid ON public.repositories USING btree (owner_uuid);
2618 -- Name: index_repositories_on_uuid; Type: INDEX; Schema: public; Owner: -
2621 CREATE UNIQUE INDEX index_repositories_on_uuid ON public.repositories USING btree (uuid);
2625 -- Name: index_specimens_on_created_at; Type: INDEX; Schema: public; Owner: -
2628 CREATE INDEX index_specimens_on_created_at ON public.specimens USING btree (created_at);
2632 -- Name: index_specimens_on_modified_at; Type: INDEX; Schema: public; Owner: -
2635 CREATE INDEX index_specimens_on_modified_at ON public.specimens USING btree (modified_at);
2639 -- Name: index_specimens_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2642 CREATE INDEX index_specimens_on_owner_uuid ON public.specimens USING btree (owner_uuid);
2646 -- Name: index_specimens_on_uuid; Type: INDEX; Schema: public; Owner: -
2649 CREATE UNIQUE INDEX index_specimens_on_uuid ON public.specimens USING btree (uuid);
2653 -- Name: index_traits_on_name; Type: INDEX; Schema: public; Owner: -
2656 CREATE INDEX index_traits_on_name ON public.traits USING btree (name);
2660 -- Name: index_traits_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2663 CREATE INDEX index_traits_on_owner_uuid ON public.traits USING btree (owner_uuid);
2667 -- Name: index_traits_on_uuid; Type: INDEX; Schema: public; Owner: -
2670 CREATE UNIQUE INDEX index_traits_on_uuid ON public.traits USING btree (uuid);
2674 -- Name: index_trashed_groups_on_group_uuid; Type: INDEX; Schema: public; Owner: -
2677 CREATE UNIQUE INDEX index_trashed_groups_on_group_uuid ON public.trashed_groups USING btree (group_uuid);
2681 -- Name: index_users_on_created_at; Type: INDEX; Schema: public; Owner: -
2684 CREATE INDEX index_users_on_created_at ON public.users USING btree (created_at);
2688 -- Name: index_users_on_identity_url; Type: INDEX; Schema: public; Owner: -
2691 CREATE UNIQUE INDEX index_users_on_identity_url ON public.users USING btree (identity_url);
2695 -- Name: index_users_on_modified_at; Type: INDEX; Schema: public; Owner: -
2698 CREATE INDEX index_users_on_modified_at ON public.users USING btree (modified_at);
2702 -- Name: index_users_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2705 CREATE INDEX index_users_on_modified_at_uuid ON public.users USING btree (modified_at DESC, uuid);
2709 -- Name: index_users_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2712 CREATE INDEX index_users_on_owner_uuid ON public.users USING btree (owner_uuid);
2716 -- Name: index_users_on_username; Type: INDEX; Schema: public; Owner: -
2719 CREATE UNIQUE INDEX index_users_on_username ON public.users USING btree (username);
2723 -- Name: index_users_on_uuid; Type: INDEX; Schema: public; Owner: -
2726 CREATE UNIQUE INDEX index_users_on_uuid ON public.users USING btree (uuid);
2730 -- Name: index_virtual_machines_on_hostname; Type: INDEX; Schema: public; Owner: -
2733 CREATE INDEX index_virtual_machines_on_hostname ON public.virtual_machines USING btree (hostname);
2737 -- Name: index_virtual_machines_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2740 CREATE INDEX index_virtual_machines_on_modified_at_uuid ON public.virtual_machines USING btree (modified_at DESC, uuid);
2744 -- Name: index_virtual_machines_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2747 CREATE INDEX index_virtual_machines_on_owner_uuid ON public.virtual_machines USING btree (owner_uuid);
2751 -- Name: index_virtual_machines_on_uuid; Type: INDEX; Schema: public; Owner: -
2754 CREATE UNIQUE INDEX index_virtual_machines_on_uuid ON public.virtual_machines USING btree (uuid);
2758 -- Name: index_workflows_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2761 CREATE INDEX index_workflows_on_modified_at_uuid ON public.workflows USING btree (modified_at DESC, uuid);
2765 -- Name: index_workflows_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2768 CREATE INDEX index_workflows_on_owner_uuid ON public.workflows USING btree (owner_uuid);
2772 -- Name: index_workflows_on_uuid; Type: INDEX; Schema: public; Owner: -
2775 CREATE UNIQUE INDEX index_workflows_on_uuid ON public.workflows USING btree (uuid);
2779 -- Name: job_tasks_search_index; Type: INDEX; Schema: public; Owner: -
2782 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);
2786 -- Name: jobs_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2789 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)));
2793 -- Name: jobs_search_index; Type: INDEX; Schema: public; Owner: -
2796 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);
2800 -- Name: jobs_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2803 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);
2807 -- Name: keep_disks_search_index; Type: INDEX; Schema: public; Owner: -
2810 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);
2814 -- Name: keep_services_search_index; Type: INDEX; Schema: public; Owner: -
2817 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);
2821 -- Name: links_index_on_properties; Type: INDEX; Schema: public; Owner: -
2824 CREATE INDEX links_index_on_properties ON public.links USING gin (properties);
2828 -- Name: links_search_index; Type: INDEX; Schema: public; Owner: -
2831 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);
2835 -- Name: links_tail_name_unique_if_link_class_name; Type: INDEX; Schema: public; Owner: -
2838 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);
2842 -- Name: logs_search_index; Type: INDEX; Schema: public; Owner: -
2845 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);
2849 -- Name: nodes_index_on_info; Type: INDEX; Schema: public; Owner: -
2852 CREATE INDEX nodes_index_on_info ON public.nodes USING gin (info);
2856 -- Name: nodes_index_on_properties; Type: INDEX; Schema: public; Owner: -
2859 CREATE INDEX nodes_index_on_properties ON public.nodes USING gin (properties);
2863 -- Name: nodes_search_index; Type: INDEX; Schema: public; Owner: -
2866 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);
2870 -- Name: permission_target; Type: INDEX; Schema: public; Owner: -
2873 CREATE INDEX permission_target ON public.materialized_permissions USING btree (target_uuid);
2877 -- Name: permission_user_target; Type: INDEX; Schema: public; Owner: -
2880 CREATE UNIQUE INDEX permission_user_target ON public.materialized_permissions USING btree (user_uuid, target_uuid);
2884 -- Name: pipeline_instances_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2887 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)));
2891 -- Name: pipeline_instances_search_index; Type: INDEX; Schema: public; Owner: -
2894 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);
2898 -- Name: pipeline_instances_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2901 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);
2905 -- Name: pipeline_template_owner_uuid_name_unique; Type: INDEX; Schema: public; Owner: -
2908 CREATE UNIQUE INDEX pipeline_template_owner_uuid_name_unique ON public.pipeline_templates USING btree (owner_uuid, name);
2912 -- Name: pipeline_templates_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2915 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)));
2919 -- Name: pipeline_templates_search_index; Type: INDEX; Schema: public; Owner: -
2922 CREATE INDEX pipeline_templates_search_index ON public.pipeline_templates USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2926 -- Name: pipeline_templates_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2929 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);
2933 -- Name: repositories_search_index; Type: INDEX; Schema: public; Owner: -
2936 CREATE INDEX repositories_search_index ON public.repositories USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2940 -- Name: specimens_search_index; Type: INDEX; Schema: public; Owner: -
2943 CREATE INDEX specimens_search_index ON public.specimens USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, material);
2947 -- Name: traits_search_index; Type: INDEX; Schema: public; Owner: -
2950 CREATE INDEX traits_search_index ON public.traits USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2954 -- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -
2957 CREATE UNIQUE INDEX unique_schema_migrations ON public.schema_migrations USING btree (version);
2961 -- Name: users_search_index; Type: INDEX; Schema: public; Owner: -
2964 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);
2968 -- Name: virtual_machines_search_index; Type: INDEX; Schema: public; Owner: -
2971 CREATE INDEX virtual_machines_search_index ON public.virtual_machines USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, hostname);
2975 -- Name: workflows_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2978 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)));
2982 -- Name: workflows_search_idx; Type: INDEX; Schema: public; Owner: -
2985 CREATE INDEX workflows_search_idx ON public.workflows USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2989 -- Name: workflows_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2992 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);
2996 -- PostgreSQL database dump complete
2999 SET search_path TO "$user", public;
3001 INSERT INTO "schema_migrations" (version) VALUES