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, character varying); Type: FUNCTION; Schema: public; Owner: -
45 CREATE FUNCTION public.compute_permission_subgraph(perm_origin_uuid character varying, starting_uuid character varying, starting_perm integer, perm_edge_id character varying) 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,
83 case (edges.edge_id = perm_edge_id)
84 when true then starting_perm
89 should_traverse_owned(edges.head_uuid, edges.val),
91 from permission_graph_edges as edges, traverse_graph
92 where traverse_graph.target_uuid = edges.tail_uuid
93 and (edges.tail_uuid like '_____-j7d0g-_______________' or
94 traverse_graph.starting_set)))
95 select traverse_graph.origin_uuid, target_uuid, max(val) as val, bool_or(traverse_owned) as traverse_owned from traverse_graph
96 group by (traverse_graph.origin_uuid, target_uuid)
99 /* Find other inbound edges that grant permissions to 'targets' in
100 perm_from_start, and compute permissions that originate from
103 This is necessary for two reasons:
105 1) Other users may have access to a subset of the objects
106 through other permission links than the one we started from.
107 If we don't recompute them, their permission will get dropped.
109 2) There may be more than one path through which a user gets
110 permission to an object. For example, a user owns a project
111 and also shares it can_read with a group the user belongs
112 to. adding the can_read link must not overwrite the existing
113 can_manage permission granted by ownership.
115 additional_perms(perm_origin_uuid, target_uuid, val, traverse_owned) as (
118 traverse_graph(origin_uuid, target_uuid, val, traverse_owned, starting_set) as (
120 select edges.tail_uuid as origin_uuid, edges.head_uuid as target_uuid, edges.val,
121 should_traverse_owned(edges.head_uuid, edges.val),
122 edges.head_uuid like '_____-j7d0g-_______________'
123 from permission_graph_edges as edges
124 where edges.edge_id != perm_edge_id and
125 edges.tail_uuid not in (select target_uuid from perm_from_start where target_uuid like '_____-j7d0g-_______________') and
126 edges.head_uuid in (select target_uuid from perm_from_start)
129 (select traverse_graph.origin_uuid,
132 case (edges.edge_id = perm_edge_id)
133 when true then starting_perm
138 should_traverse_owned(edges.head_uuid, edges.val),
140 from permission_graph_edges as edges, traverse_graph
141 where traverse_graph.target_uuid = edges.tail_uuid
142 and (edges.tail_uuid like '_____-j7d0g-_______________' or
143 traverse_graph.starting_set)))
144 select traverse_graph.origin_uuid, target_uuid, max(val) as val, bool_or(traverse_owned) as traverse_owned from traverse_graph
145 group by (traverse_graph.origin_uuid, target_uuid)
148 /* Combine the permissions computed in the first two phases. */
149 all_perms(perm_origin_uuid, target_uuid, val, traverse_owned) as (
150 select * from perm_from_start
152 select * from additional_perms
155 /* The actual query that produces rows to be added or removed
156 from the materialized_permissions table. This is the clever
161 * For every group, the materialized_permissions lists all users
162 that can access to that group.
164 * The all_perms subquery has computed permissions on on a set of
165 objects for all inbound "origins", which are users or groups.
167 * Permissions through groups are transitive.
171 1) The materialized_permissions table declares that user X has permission N on group Y
172 2) The all_perms result has determined group Y has permission M on object Z
173 3) Therefore, user X has permission min(N, M) on object Z
175 This allows us to efficiently determine the set of users that
176 have permissions on the subset of objects, without having to
177 follow the chain of permission back up to find those users.
179 In addition, because users always have permission on themselves, this
180 query also makes sure those permission rows are always
183 select v.user_uuid, v.target_uuid, max(v.perm_level), bool_or(v.traverse_owned) from
186 least(u.val, m.perm_level) as perm_level,
188 from all_perms as u, materialized_permissions as m
189 where u.perm_origin_uuid = m.target_uuid AND m.traverse_owned
190 AND (m.user_uuid = m.target_uuid or m.target_uuid not like '_____-tpzed-_______________')
192 select target_uuid as user_uuid, target_uuid, 3, true
194 where all_perms.target_uuid like '_____-tpzed-_______________') as v
195 group by v.user_uuid, v.target_uuid
200 -- Name: project_subtree_with_trash_at(character varying, timestamp without time zone); Type: FUNCTION; Schema: public; Owner: -
203 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)
206 /* Starting from a project, recursively traverse all the projects
207 underneath it and return a set of project uuids and trash_at times
208 (may be null). The initial trash_at can be a timestamp or null.
209 The trash_at time propagates downward to groups it owns, i.e. when a
210 group is trashed, everything underneath it in the ownership
211 hierarchy is also considered trashed. However, this is fact is
212 recorded in the trashed_groups table, not by updating trash_at field
216 project_subtree(uuid, trash_at) as (
217 values (starting_uuid, starting_trash_at)
219 select groups.uuid, LEAST(project_subtree.trash_at, groups.trash_at)
220 from groups join project_subtree on (groups.owner_uuid = project_subtree.uuid)
222 select uuid, trash_at from project_subtree;
227 -- Name: should_traverse_owned(character varying, integer); Type: FUNCTION; Schema: public; Owner: -
230 CREATE FUNCTION public.should_traverse_owned(starting_uuid character varying, starting_perm integer) RETURNS boolean
231 LANGUAGE sql IMMUTABLE
233 /* Helper function. Determines if permission on an object implies
234 transitive permission to things the object owns. This is always
235 true for groups, but only true for users when the permission level
238 select starting_uuid like '_____-j7d0g-_______________' or
239 (starting_uuid like '_____-tpzed-_______________' and starting_perm >= 3);
243 SET default_tablespace = '';
245 SET default_with_oids = false;
248 -- Name: api_client_authorizations; Type: TABLE; Schema: public; Owner: -
251 CREATE TABLE public.api_client_authorizations (
253 api_token character varying(255) NOT NULL,
254 api_client_id integer NOT NULL,
255 user_id integer NOT NULL,
256 created_by_ip_address character varying(255),
257 last_used_by_ip_address character varying(255),
258 last_used_at timestamp without time zone,
259 expires_at timestamp without time zone,
260 created_at timestamp without time zone NOT NULL,
261 updated_at timestamp without time zone NOT NULL,
262 default_owner_uuid character varying(255),
263 scopes text DEFAULT '["all"]'::text,
264 uuid character varying(255) NOT NULL
269 -- Name: api_client_authorizations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
272 CREATE SEQUENCE public.api_client_authorizations_id_seq
281 -- Name: api_client_authorizations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
284 ALTER SEQUENCE public.api_client_authorizations_id_seq OWNED BY public.api_client_authorizations.id;
288 -- Name: api_clients; Type: TABLE; Schema: public; Owner: -
291 CREATE TABLE public.api_clients (
293 uuid character varying(255),
294 owner_uuid character varying(255),
295 modified_by_client_uuid character varying(255),
296 modified_by_user_uuid character varying(255),
297 modified_at timestamp without time zone,
298 name character varying(255),
299 url_prefix character varying(255),
300 created_at timestamp without time zone NOT NULL,
301 updated_at timestamp without time zone NOT NULL,
302 is_trusted boolean DEFAULT false
307 -- Name: api_clients_id_seq; Type: SEQUENCE; Schema: public; Owner: -
310 CREATE SEQUENCE public.api_clients_id_seq
319 -- Name: api_clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
322 ALTER SEQUENCE public.api_clients_id_seq OWNED BY public.api_clients.id;
326 -- Name: ar_internal_metadata; Type: TABLE; Schema: public; Owner: -
329 CREATE TABLE public.ar_internal_metadata (
330 key character varying NOT NULL,
331 value character varying,
332 created_at timestamp without time zone NOT NULL,
333 updated_at timestamp without time zone NOT NULL
338 -- Name: authorized_keys; Type: TABLE; Schema: public; Owner: -
341 CREATE TABLE public.authorized_keys (
343 uuid character varying(255) NOT NULL,
344 owner_uuid character varying(255) NOT NULL,
345 modified_by_client_uuid character varying(255),
346 modified_by_user_uuid character varying(255),
347 modified_at timestamp without time zone,
348 name character varying(255),
349 key_type character varying(255),
350 authorized_user_uuid character varying(255),
352 expires_at timestamp without time zone,
353 created_at timestamp without time zone NOT NULL,
354 updated_at timestamp without time zone NOT NULL
359 -- Name: authorized_keys_id_seq; Type: SEQUENCE; Schema: public; Owner: -
362 CREATE SEQUENCE public.authorized_keys_id_seq
371 -- Name: authorized_keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
374 ALTER SEQUENCE public.authorized_keys_id_seq OWNED BY public.authorized_keys.id;
378 -- Name: collections; Type: TABLE; Schema: public; Owner: -
381 CREATE TABLE public.collections (
383 owner_uuid character varying(255),
384 created_at timestamp without time zone NOT NULL,
385 modified_by_client_uuid character varying(255),
386 modified_by_user_uuid character varying(255),
387 modified_at timestamp without time zone,
388 portable_data_hash character varying(255),
389 replication_desired integer,
390 replication_confirmed_at timestamp without time zone,
391 replication_confirmed integer,
392 updated_at timestamp without time zone NOT NULL,
393 uuid character varying(255),
395 name character varying(255),
396 description character varying(524288),
398 delete_at timestamp without time zone,
400 trash_at timestamp without time zone,
401 is_trashed boolean DEFAULT false NOT NULL,
402 storage_classes_desired jsonb DEFAULT '["default"]'::jsonb,
403 storage_classes_confirmed jsonb DEFAULT '[]'::jsonb,
404 storage_classes_confirmed_at timestamp without time zone,
405 current_version_uuid character varying,
406 version integer DEFAULT 1 NOT NULL,
407 preserve_version boolean DEFAULT false,
408 file_count integer DEFAULT 0 NOT NULL,
409 file_size_total bigint DEFAULT 0 NOT NULL
414 -- Name: collections_id_seq; Type: SEQUENCE; Schema: public; Owner: -
417 CREATE SEQUENCE public.collections_id_seq
426 -- Name: collections_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
429 ALTER SEQUENCE public.collections_id_seq OWNED BY public.collections.id;
433 -- Name: container_requests; Type: TABLE; Schema: public; Owner: -
436 CREATE TABLE public.container_requests (
438 uuid character varying(255),
439 owner_uuid character varying(255),
440 created_at timestamp without time zone NOT NULL,
441 modified_at timestamp without time zone,
442 modified_by_client_uuid character varying(255),
443 modified_by_user_uuid character varying(255),
444 name character varying(255),
447 state character varying(255),
448 requesting_container_uuid character varying(255),
449 container_uuid character varying(255),
450 container_count_max integer,
452 runtime_constraints text,
453 container_image character varying(255),
455 cwd character varying(255),
457 output_path character varying(255),
459 expires_at timestamp without time zone,
461 updated_at timestamp without time zone NOT NULL,
462 container_count integer DEFAULT 0,
463 use_existing boolean DEFAULT true,
464 scheduling_parameters text,
465 output_uuid character varying(255),
466 log_uuid character varying(255),
467 output_name character varying(255) DEFAULT NULL::character varying,
468 output_ttl integer DEFAULT 0 NOT NULL,
469 secret_mounts jsonb DEFAULT '{}'::jsonb,
475 -- Name: container_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: -
478 CREATE SEQUENCE public.container_requests_id_seq
487 -- Name: container_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
490 ALTER SEQUENCE public.container_requests_id_seq OWNED BY public.container_requests.id;
494 -- Name: containers; Type: TABLE; Schema: public; Owner: -
497 CREATE TABLE public.containers (
499 uuid character varying(255),
500 owner_uuid character varying(255),
501 created_at timestamp without time zone NOT NULL,
502 modified_at timestamp without time zone,
503 modified_by_client_uuid character varying(255),
504 modified_by_user_uuid character varying(255),
505 state character varying(255),
506 started_at timestamp without time zone,
507 finished_at timestamp without time zone,
508 log character varying(255),
510 cwd character varying(255),
512 output_path character varying(255),
514 runtime_constraints text,
515 output character varying(255),
516 container_image character varying(255),
517 progress double precision,
519 updated_at timestamp without time zone NOT NULL,
521 auth_uuid character varying(255),
522 locked_by_uuid character varying(255),
523 scheduling_parameters text,
524 secret_mounts jsonb DEFAULT '{}'::jsonb,
525 secret_mounts_md5 character varying DEFAULT '99914b932bd37a50b983c5e7c90ae93b'::character varying,
526 runtime_status jsonb DEFAULT '{}'::jsonb,
527 runtime_user_uuid text,
528 runtime_auth_scopes jsonb,
530 lock_count integer DEFAULT 0 NOT NULL
535 -- Name: containers_id_seq; Type: SEQUENCE; Schema: public; Owner: -
538 CREATE SEQUENCE public.containers_id_seq
547 -- Name: containers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
550 ALTER SEQUENCE public.containers_id_seq OWNED BY public.containers.id;
554 -- Name: groups; Type: TABLE; Schema: public; Owner: -
557 CREATE TABLE public.groups (
559 uuid character varying(255),
560 owner_uuid character varying(255),
561 created_at timestamp without time zone NOT NULL,
562 modified_by_client_uuid character varying(255),
563 modified_by_user_uuid character varying(255),
564 modified_at timestamp without time zone,
565 name character varying(255) NOT NULL,
566 description character varying(524288),
567 updated_at timestamp without time zone NOT NULL,
568 group_class character varying(255),
569 trash_at timestamp without time zone,
570 is_trashed boolean DEFAULT false NOT NULL,
571 delete_at timestamp without time zone,
572 properties jsonb DEFAULT '{}'::jsonb
577 -- Name: groups_id_seq; Type: SEQUENCE; Schema: public; Owner: -
580 CREATE SEQUENCE public.groups_id_seq
589 -- Name: groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
592 ALTER SEQUENCE public.groups_id_seq OWNED BY public.groups.id;
596 -- Name: humans; Type: TABLE; Schema: public; Owner: -
599 CREATE TABLE public.humans (
601 uuid character varying(255) NOT NULL,
602 owner_uuid character varying(255) NOT NULL,
603 modified_by_client_uuid character varying(255),
604 modified_by_user_uuid character varying(255),
605 modified_at timestamp without time zone,
607 created_at timestamp without time zone NOT NULL,
608 updated_at timestamp without time zone NOT NULL
613 -- Name: humans_id_seq; Type: SEQUENCE; Schema: public; Owner: -
616 CREATE SEQUENCE public.humans_id_seq
625 -- Name: humans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
628 ALTER SEQUENCE public.humans_id_seq OWNED BY public.humans.id;
632 -- Name: job_tasks; Type: TABLE; Schema: public; Owner: -
635 CREATE TABLE public.job_tasks (
637 uuid character varying(255),
638 owner_uuid character varying(255),
639 modified_by_client_uuid character varying(255),
640 modified_by_user_uuid character varying(255),
641 modified_at timestamp without time zone,
642 job_uuid character varying(255),
646 progress double precision,
648 created_at timestamp without time zone NOT NULL,
649 updated_at timestamp without time zone NOT NULL,
650 created_by_job_task_uuid character varying(255),
652 started_at timestamp without time zone,
653 finished_at timestamp without time zone
658 -- Name: job_tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
661 CREATE SEQUENCE public.job_tasks_id_seq
670 -- Name: job_tasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
673 ALTER SEQUENCE public.job_tasks_id_seq OWNED BY public.job_tasks.id;
677 -- Name: job_tasks_qsequence_seq; Type: SEQUENCE; Schema: public; Owner: -
680 CREATE SEQUENCE public.job_tasks_qsequence_seq
689 -- Name: job_tasks_qsequence_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
692 ALTER SEQUENCE public.job_tasks_qsequence_seq OWNED BY public.job_tasks.qsequence;
696 -- Name: jobs; Type: TABLE; Schema: public; Owner: -
699 CREATE TABLE public.jobs (
701 uuid character varying(255),
702 owner_uuid character varying(255),
703 modified_by_client_uuid character varying(255),
704 modified_by_user_uuid character varying(255),
705 modified_at timestamp without time zone,
706 submit_id character varying(255),
707 script character varying(255),
708 script_version character varying(255),
709 script_parameters text,
710 cancelled_by_client_uuid character varying(255),
711 cancelled_by_user_uuid character varying(255),
712 cancelled_at timestamp without time zone,
713 started_at timestamp without time zone,
714 finished_at timestamp without time zone,
717 output character varying(255),
718 created_at timestamp without time zone NOT NULL,
719 updated_at timestamp without time zone NOT NULL,
720 is_locked_by_uuid character varying(255),
721 log character varying(255),
723 runtime_constraints text,
724 nondeterministic boolean,
725 repository character varying(255),
726 supplied_script_version character varying(255),
727 docker_image_locator character varying(255),
728 priority integer DEFAULT 0 NOT NULL,
729 description character varying(524288),
730 state character varying(255),
731 arvados_sdk_version character varying(255),
733 script_parameters_digest character varying(255)
738 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
741 CREATE SEQUENCE public.jobs_id_seq
750 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
753 ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;
757 -- Name: keep_disks; Type: TABLE; Schema: public; Owner: -
760 CREATE TABLE public.keep_disks (
762 uuid character varying(255) NOT NULL,
763 owner_uuid character varying(255) NOT NULL,
764 modified_by_client_uuid character varying(255),
765 modified_by_user_uuid character varying(255),
766 modified_at timestamp without time zone,
767 ping_secret character varying(255) NOT NULL,
768 node_uuid character varying(255),
769 filesystem_uuid character varying(255),
772 is_readable boolean DEFAULT true NOT NULL,
773 is_writable boolean DEFAULT true NOT NULL,
774 last_read_at timestamp without time zone,
775 last_write_at timestamp without time zone,
776 last_ping_at timestamp without time zone,
777 created_at timestamp without time zone NOT NULL,
778 updated_at timestamp without time zone NOT NULL,
779 keep_service_uuid character varying(255)
784 -- Name: keep_disks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
787 CREATE SEQUENCE public.keep_disks_id_seq
796 -- Name: keep_disks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
799 ALTER SEQUENCE public.keep_disks_id_seq OWNED BY public.keep_disks.id;
803 -- Name: keep_services; Type: TABLE; Schema: public; Owner: -
806 CREATE TABLE public.keep_services (
808 uuid character varying(255) NOT NULL,
809 owner_uuid character varying(255) NOT NULL,
810 modified_by_client_uuid character varying(255),
811 modified_by_user_uuid character varying(255),
812 modified_at timestamp without time zone,
813 service_host character varying(255),
814 service_port integer,
815 service_ssl_flag boolean,
816 service_type character varying(255),
817 created_at timestamp without time zone NOT NULL,
818 updated_at timestamp without time zone NOT NULL,
819 read_only boolean DEFAULT false NOT NULL
824 -- Name: keep_services_id_seq; Type: SEQUENCE; Schema: public; Owner: -
827 CREATE SEQUENCE public.keep_services_id_seq
836 -- Name: keep_services_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
839 ALTER SEQUENCE public.keep_services_id_seq OWNED BY public.keep_services.id;
843 -- Name: links; Type: TABLE; Schema: public; Owner: -
846 CREATE TABLE public.links (
848 uuid character varying(255),
849 owner_uuid character varying(255),
850 created_at timestamp without time zone NOT NULL,
851 modified_by_client_uuid character varying(255),
852 modified_by_user_uuid character varying(255),
853 modified_at timestamp without time zone,
854 tail_uuid character varying(255),
855 link_class character varying(255),
856 name character varying(255),
857 head_uuid character varying(255),
859 updated_at timestamp without time zone NOT NULL
864 -- Name: links_id_seq; Type: SEQUENCE; Schema: public; Owner: -
867 CREATE SEQUENCE public.links_id_seq
876 -- Name: links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
879 ALTER SEQUENCE public.links_id_seq OWNED BY public.links.id;
883 -- Name: logs; Type: TABLE; Schema: public; Owner: -
886 CREATE TABLE public.logs (
888 uuid character varying(255),
889 owner_uuid character varying(255),
890 modified_by_client_uuid character varying(255),
891 modified_by_user_uuid character varying(255),
892 object_uuid character varying(255),
893 event_at timestamp without time zone,
894 event_type character varying(255),
897 created_at timestamp without time zone NOT NULL,
898 updated_at timestamp without time zone NOT NULL,
899 modified_at timestamp without time zone,
900 object_owner_uuid character varying(255)
905 -- Name: logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
908 CREATE SEQUENCE public.logs_id_seq
917 -- Name: logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
920 ALTER SEQUENCE public.logs_id_seq OWNED BY public.logs.id;
924 -- Name: materialized_permissions; Type: TABLE; Schema: public; Owner: -
927 CREATE TABLE public.materialized_permissions (
928 user_uuid character varying,
929 target_uuid character varying,
931 traverse_owned boolean
936 -- Name: nodes; Type: TABLE; Schema: public; Owner: -
939 CREATE TABLE public.nodes (
941 uuid character varying(255),
942 owner_uuid character varying(255),
943 created_at timestamp without time zone NOT NULL,
944 modified_by_client_uuid character varying(255),
945 modified_by_user_uuid character varying(255),
946 modified_at timestamp without time zone,
948 hostname character varying(255),
949 domain character varying(255),
950 ip_address character varying(255),
951 first_ping_at timestamp without time zone,
952 last_ping_at timestamp without time zone,
954 updated_at timestamp without time zone NOT NULL,
956 job_uuid character varying(255)
961 -- Name: nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
964 CREATE SEQUENCE public.nodes_id_seq
973 -- Name: nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
976 ALTER SEQUENCE public.nodes_id_seq OWNED BY public.nodes.id;
980 -- Name: users; Type: TABLE; Schema: public; Owner: -
983 CREATE TABLE public.users (
985 uuid character varying(255),
986 owner_uuid character varying(255) NOT NULL,
987 created_at timestamp without time zone NOT NULL,
988 modified_by_client_uuid character varying(255),
989 modified_by_user_uuid character varying(255),
990 modified_at timestamp without time zone,
991 email character varying(255),
992 first_name character varying(255),
993 last_name character varying(255),
994 identity_url character varying(255),
997 updated_at timestamp without time zone NOT NULL,
998 default_owner_uuid character varying(255),
999 is_active boolean DEFAULT false,
1000 username character varying(255),
1001 redirect_to_user_uuid character varying
1006 -- Name: permission_graph_edges; Type: VIEW; Schema: public; Owner: -
1009 CREATE VIEW public.permission_graph_edges AS
1010 SELECT groups.owner_uuid AS tail_uuid,
1011 groups.uuid AS head_uuid,
1013 groups.uuid AS edge_id
1016 SELECT users.owner_uuid AS tail_uuid,
1017 users.uuid AS head_uuid,
1019 users.uuid AS edge_id
1022 SELECT users.uuid AS tail_uuid,
1023 users.uuid AS head_uuid,
1025 ''::character varying AS edge_id
1028 SELECT links.tail_uuid,
1031 WHEN ((links.name)::text = 'can_read'::text) THEN 1
1032 WHEN ((links.name)::text = 'can_login'::text) THEN 1
1033 WHEN ((links.name)::text = 'can_write'::text) THEN 2
1034 WHEN ((links.name)::text = 'can_manage'::text) THEN 3
1037 links.uuid AS edge_id
1039 WHERE ((links.link_class)::text = 'permission'::text);
1043 -- Name: pipeline_instances; Type: TABLE; Schema: public; Owner: -
1046 CREATE TABLE public.pipeline_instances (
1047 id integer NOT NULL,
1048 uuid character varying(255),
1049 owner_uuid character varying(255),
1050 created_at timestamp without time zone NOT NULL,
1051 modified_by_client_uuid character varying(255),
1052 modified_by_user_uuid character varying(255),
1053 modified_at timestamp without time zone,
1054 pipeline_template_uuid character varying(255),
1055 name character varying(255),
1057 updated_at timestamp without time zone NOT NULL,
1059 state character varying(255),
1060 components_summary text,
1061 started_at timestamp without time zone,
1062 finished_at timestamp without time zone,
1063 description character varying(524288)
1068 -- Name: pipeline_instances_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1071 CREATE SEQUENCE public.pipeline_instances_id_seq
1080 -- Name: pipeline_instances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1083 ALTER SEQUENCE public.pipeline_instances_id_seq OWNED BY public.pipeline_instances.id;
1087 -- Name: pipeline_templates; Type: TABLE; Schema: public; Owner: -
1090 CREATE TABLE public.pipeline_templates (
1091 id integer NOT NULL,
1092 uuid character varying(255),
1093 owner_uuid character varying(255),
1094 created_at timestamp without time zone NOT NULL,
1095 modified_by_client_uuid character varying(255),
1096 modified_by_user_uuid character varying(255),
1097 modified_at timestamp without time zone,
1098 name character varying(255),
1100 updated_at timestamp without time zone NOT NULL,
1101 description character varying(524288)
1106 -- Name: pipeline_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1109 CREATE SEQUENCE public.pipeline_templates_id_seq
1118 -- Name: pipeline_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1121 ALTER SEQUENCE public.pipeline_templates_id_seq OWNED BY public.pipeline_templates.id;
1125 -- Name: repositories; Type: TABLE; Schema: public; Owner: -
1128 CREATE TABLE public.repositories (
1129 id integer NOT NULL,
1130 uuid character varying(255) NOT NULL,
1131 owner_uuid character varying(255) NOT NULL,
1132 modified_by_client_uuid character varying(255),
1133 modified_by_user_uuid character varying(255),
1134 modified_at timestamp without time zone,
1135 name character varying(255),
1136 created_at timestamp without time zone NOT NULL,
1137 updated_at timestamp without time zone NOT NULL
1142 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1145 CREATE SEQUENCE public.repositories_id_seq
1154 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1157 ALTER SEQUENCE public.repositories_id_seq OWNED BY public.repositories.id;
1161 -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -
1164 CREATE TABLE public.schema_migrations (
1165 version character varying(255) NOT NULL
1170 -- Name: specimens; Type: TABLE; Schema: public; Owner: -
1173 CREATE TABLE public.specimens (
1174 id integer NOT NULL,
1175 uuid character varying(255),
1176 owner_uuid character varying(255),
1177 created_at timestamp without time zone NOT NULL,
1178 modified_by_client_uuid character varying(255),
1179 modified_by_user_uuid character varying(255),
1180 modified_at timestamp without time zone,
1181 material character varying(255),
1182 updated_at timestamp without time zone NOT NULL,
1188 -- Name: specimens_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1191 CREATE SEQUENCE public.specimens_id_seq
1200 -- Name: specimens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1203 ALTER SEQUENCE public.specimens_id_seq OWNED BY public.specimens.id;
1207 -- Name: traits; Type: TABLE; Schema: public; Owner: -
1210 CREATE TABLE public.traits (
1211 id integer NOT NULL,
1212 uuid character varying(255) NOT NULL,
1213 owner_uuid character varying(255) NOT NULL,
1214 modified_by_client_uuid character varying(255),
1215 modified_by_user_uuid character varying(255),
1216 modified_at timestamp without time zone,
1217 name character varying(255),
1219 created_at timestamp without time zone NOT NULL,
1220 updated_at timestamp without time zone NOT NULL
1225 -- Name: traits_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1228 CREATE SEQUENCE public.traits_id_seq
1237 -- Name: traits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1240 ALTER SEQUENCE public.traits_id_seq OWNED BY public.traits.id;
1244 -- Name: trashed_groups; Type: TABLE; Schema: public; Owner: -
1247 CREATE TABLE public.trashed_groups (
1248 group_uuid character varying,
1249 trash_at timestamp without time zone
1254 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1257 CREATE SEQUENCE public.users_id_seq
1266 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1269 ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
1273 -- Name: virtual_machines; Type: TABLE; Schema: public; Owner: -
1276 CREATE TABLE public.virtual_machines (
1277 id integer NOT NULL,
1278 uuid character varying(255) NOT NULL,
1279 owner_uuid character varying(255) NOT NULL,
1280 modified_by_client_uuid character varying(255),
1281 modified_by_user_uuid character varying(255),
1282 modified_at timestamp without time zone,
1283 hostname character varying(255),
1284 created_at timestamp without time zone NOT NULL,
1285 updated_at timestamp without time zone NOT NULL
1290 -- Name: virtual_machines_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1293 CREATE SEQUENCE public.virtual_machines_id_seq
1302 -- Name: virtual_machines_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1305 ALTER SEQUENCE public.virtual_machines_id_seq OWNED BY public.virtual_machines.id;
1309 -- Name: workflows; Type: TABLE; Schema: public; Owner: -
1312 CREATE TABLE public.workflows (
1313 id integer NOT NULL,
1314 uuid character varying(255),
1315 owner_uuid character varying(255),
1316 created_at timestamp without time zone NOT NULL,
1317 modified_at timestamp without time zone,
1318 modified_by_client_uuid character varying(255),
1319 modified_by_user_uuid character varying(255),
1320 name character varying(255),
1323 updated_at timestamp without time zone NOT NULL
1328 -- Name: workflows_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1331 CREATE SEQUENCE public.workflows_id_seq
1340 -- Name: workflows_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1343 ALTER SEQUENCE public.workflows_id_seq OWNED BY public.workflows.id;
1347 -- Name: api_client_authorizations id; Type: DEFAULT; Schema: public; Owner: -
1350 ALTER TABLE ONLY public.api_client_authorizations ALTER COLUMN id SET DEFAULT nextval('public.api_client_authorizations_id_seq'::regclass);
1354 -- Name: api_clients id; Type: DEFAULT; Schema: public; Owner: -
1357 ALTER TABLE ONLY public.api_clients ALTER COLUMN id SET DEFAULT nextval('public.api_clients_id_seq'::regclass);
1361 -- Name: authorized_keys id; Type: DEFAULT; Schema: public; Owner: -
1364 ALTER TABLE ONLY public.authorized_keys ALTER COLUMN id SET DEFAULT nextval('public.authorized_keys_id_seq'::regclass);
1368 -- Name: collections id; Type: DEFAULT; Schema: public; Owner: -
1371 ALTER TABLE ONLY public.collections ALTER COLUMN id SET DEFAULT nextval('public.collections_id_seq'::regclass);
1375 -- Name: container_requests id; Type: DEFAULT; Schema: public; Owner: -
1378 ALTER TABLE ONLY public.container_requests ALTER COLUMN id SET DEFAULT nextval('public.container_requests_id_seq'::regclass);
1382 -- Name: containers id; Type: DEFAULT; Schema: public; Owner: -
1385 ALTER TABLE ONLY public.containers ALTER COLUMN id SET DEFAULT nextval('public.containers_id_seq'::regclass);
1389 -- Name: groups id; Type: DEFAULT; Schema: public; Owner: -
1392 ALTER TABLE ONLY public.groups ALTER COLUMN id SET DEFAULT nextval('public.groups_id_seq'::regclass);
1396 -- Name: humans id; Type: DEFAULT; Schema: public; Owner: -
1399 ALTER TABLE ONLY public.humans ALTER COLUMN id SET DEFAULT nextval('public.humans_id_seq'::regclass);
1403 -- Name: job_tasks id; Type: DEFAULT; Schema: public; Owner: -
1406 ALTER TABLE ONLY public.job_tasks ALTER COLUMN id SET DEFAULT nextval('public.job_tasks_id_seq'::regclass);
1410 -- Name: jobs id; Type: DEFAULT; Schema: public; Owner: -
1413 ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass);
1417 -- Name: keep_disks id; Type: DEFAULT; Schema: public; Owner: -
1420 ALTER TABLE ONLY public.keep_disks ALTER COLUMN id SET DEFAULT nextval('public.keep_disks_id_seq'::regclass);
1424 -- Name: keep_services id; Type: DEFAULT; Schema: public; Owner: -
1427 ALTER TABLE ONLY public.keep_services ALTER COLUMN id SET DEFAULT nextval('public.keep_services_id_seq'::regclass);
1431 -- Name: links id; Type: DEFAULT; Schema: public; Owner: -
1434 ALTER TABLE ONLY public.links ALTER COLUMN id SET DEFAULT nextval('public.links_id_seq'::regclass);
1438 -- Name: logs id; Type: DEFAULT; Schema: public; Owner: -
1441 ALTER TABLE ONLY public.logs ALTER COLUMN id SET DEFAULT nextval('public.logs_id_seq'::regclass);
1445 -- Name: nodes id; Type: DEFAULT; Schema: public; Owner: -
1448 ALTER TABLE ONLY public.nodes ALTER COLUMN id SET DEFAULT nextval('public.nodes_id_seq'::regclass);
1452 -- Name: pipeline_instances id; Type: DEFAULT; Schema: public; Owner: -
1455 ALTER TABLE ONLY public.pipeline_instances ALTER COLUMN id SET DEFAULT nextval('public.pipeline_instances_id_seq'::regclass);
1459 -- Name: pipeline_templates id; Type: DEFAULT; Schema: public; Owner: -
1462 ALTER TABLE ONLY public.pipeline_templates ALTER COLUMN id SET DEFAULT nextval('public.pipeline_templates_id_seq'::regclass);
1466 -- Name: repositories id; Type: DEFAULT; Schema: public; Owner: -
1469 ALTER TABLE ONLY public.repositories ALTER COLUMN id SET DEFAULT nextval('public.repositories_id_seq'::regclass);
1473 -- Name: specimens id; Type: DEFAULT; Schema: public; Owner: -
1476 ALTER TABLE ONLY public.specimens ALTER COLUMN id SET DEFAULT nextval('public.specimens_id_seq'::regclass);
1480 -- Name: traits id; Type: DEFAULT; Schema: public; Owner: -
1483 ALTER TABLE ONLY public.traits ALTER COLUMN id SET DEFAULT nextval('public.traits_id_seq'::regclass);
1487 -- Name: users id; Type: DEFAULT; Schema: public; Owner: -
1490 ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
1494 -- Name: virtual_machines id; Type: DEFAULT; Schema: public; Owner: -
1497 ALTER TABLE ONLY public.virtual_machines ALTER COLUMN id SET DEFAULT nextval('public.virtual_machines_id_seq'::regclass);
1501 -- Name: workflows id; Type: DEFAULT; Schema: public; Owner: -
1504 ALTER TABLE ONLY public.workflows ALTER COLUMN id SET DEFAULT nextval('public.workflows_id_seq'::regclass);
1508 -- Name: api_client_authorizations api_client_authorizations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1511 ALTER TABLE ONLY public.api_client_authorizations
1512 ADD CONSTRAINT api_client_authorizations_pkey PRIMARY KEY (id);
1516 -- Name: api_clients api_clients_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1519 ALTER TABLE ONLY public.api_clients
1520 ADD CONSTRAINT api_clients_pkey PRIMARY KEY (id);
1524 -- Name: ar_internal_metadata ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1527 ALTER TABLE ONLY public.ar_internal_metadata
1528 ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);
1532 -- Name: authorized_keys authorized_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1535 ALTER TABLE ONLY public.authorized_keys
1536 ADD CONSTRAINT authorized_keys_pkey PRIMARY KEY (id);
1540 -- Name: collections collections_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1543 ALTER TABLE ONLY public.collections
1544 ADD CONSTRAINT collections_pkey PRIMARY KEY (id);
1548 -- Name: container_requests container_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1551 ALTER TABLE ONLY public.container_requests
1552 ADD CONSTRAINT container_requests_pkey PRIMARY KEY (id);
1556 -- Name: containers containers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1559 ALTER TABLE ONLY public.containers
1560 ADD CONSTRAINT containers_pkey PRIMARY KEY (id);
1564 -- Name: groups groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1567 ALTER TABLE ONLY public.groups
1568 ADD CONSTRAINT groups_pkey PRIMARY KEY (id);
1572 -- Name: humans humans_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1575 ALTER TABLE ONLY public.humans
1576 ADD CONSTRAINT humans_pkey PRIMARY KEY (id);
1580 -- Name: job_tasks job_tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1583 ALTER TABLE ONLY public.job_tasks
1584 ADD CONSTRAINT job_tasks_pkey PRIMARY KEY (id);
1588 -- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1591 ALTER TABLE ONLY public.jobs
1592 ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);
1596 -- Name: keep_disks keep_disks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1599 ALTER TABLE ONLY public.keep_disks
1600 ADD CONSTRAINT keep_disks_pkey PRIMARY KEY (id);
1604 -- Name: keep_services keep_services_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1607 ALTER TABLE ONLY public.keep_services
1608 ADD CONSTRAINT keep_services_pkey PRIMARY KEY (id);
1612 -- Name: links links_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1615 ALTER TABLE ONLY public.links
1616 ADD CONSTRAINT links_pkey PRIMARY KEY (id);
1620 -- Name: logs logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1623 ALTER TABLE ONLY public.logs
1624 ADD CONSTRAINT logs_pkey PRIMARY KEY (id);
1628 -- Name: nodes nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1631 ALTER TABLE ONLY public.nodes
1632 ADD CONSTRAINT nodes_pkey PRIMARY KEY (id);
1636 -- Name: pipeline_instances pipeline_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1639 ALTER TABLE ONLY public.pipeline_instances
1640 ADD CONSTRAINT pipeline_instances_pkey PRIMARY KEY (id);
1644 -- Name: pipeline_templates pipeline_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1647 ALTER TABLE ONLY public.pipeline_templates
1648 ADD CONSTRAINT pipeline_templates_pkey PRIMARY KEY (id);
1652 -- Name: repositories repositories_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1655 ALTER TABLE ONLY public.repositories
1656 ADD CONSTRAINT repositories_pkey PRIMARY KEY (id);
1660 -- Name: specimens specimens_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1663 ALTER TABLE ONLY public.specimens
1664 ADD CONSTRAINT specimens_pkey PRIMARY KEY (id);
1668 -- Name: traits traits_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1671 ALTER TABLE ONLY public.traits
1672 ADD CONSTRAINT traits_pkey PRIMARY KEY (id);
1676 -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1679 ALTER TABLE ONLY public.users
1680 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
1684 -- Name: virtual_machines virtual_machines_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1687 ALTER TABLE ONLY public.virtual_machines
1688 ADD CONSTRAINT virtual_machines_pkey PRIMARY KEY (id);
1692 -- Name: workflows workflows_pkey; Type: CONSTRAINT; Schema: public; Owner: -
1695 ALTER TABLE ONLY public.workflows
1696 ADD CONSTRAINT workflows_pkey PRIMARY KEY (id);
1700 -- Name: api_client_authorizations_search_index; Type: INDEX; Schema: public; Owner: -
1703 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);
1707 -- Name: api_clients_search_index; Type: INDEX; Schema: public; Owner: -
1710 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);
1714 -- Name: authorized_keys_search_index; Type: INDEX; Schema: public; Owner: -
1717 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);
1721 -- Name: collection_index_on_properties; Type: INDEX; Schema: public; Owner: -
1724 CREATE INDEX collection_index_on_properties ON public.collections USING gin (properties);
1728 -- Name: collections_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
1731 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)));
1735 -- Name: collections_search_index; Type: INDEX; Schema: public; Owner: -
1738 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);
1742 -- Name: collections_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
1745 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);
1749 -- Name: container_requests_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
1752 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)));
1756 -- Name: container_requests_index_on_properties; Type: INDEX; Schema: public; Owner: -
1759 CREATE INDEX container_requests_index_on_properties ON public.container_requests USING gin (properties);
1763 -- Name: container_requests_search_index; Type: INDEX; Schema: public; Owner: -
1766 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);
1770 -- Name: container_requests_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
1773 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);
1777 -- Name: containers_search_index; Type: INDEX; Schema: public; Owner: -
1780 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);
1784 -- Name: group_index_on_properties; Type: INDEX; Schema: public; Owner: -
1787 CREATE INDEX group_index_on_properties ON public.groups USING gin (properties);
1791 -- Name: groups_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
1794 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)));
1798 -- Name: groups_search_index; Type: INDEX; Schema: public; Owner: -
1801 CREATE INDEX groups_search_index ON public.groups USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, group_class);
1805 -- Name: groups_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
1808 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);
1812 -- Name: humans_search_index; Type: INDEX; Schema: public; Owner: -
1815 CREATE INDEX humans_search_index ON public.humans USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid);
1819 -- Name: index_api_client_authorizations_on_api_client_id; Type: INDEX; Schema: public; Owner: -
1822 CREATE INDEX index_api_client_authorizations_on_api_client_id ON public.api_client_authorizations USING btree (api_client_id);
1826 -- Name: index_api_client_authorizations_on_api_token; Type: INDEX; Schema: public; Owner: -
1829 CREATE UNIQUE INDEX index_api_client_authorizations_on_api_token ON public.api_client_authorizations USING btree (api_token);
1833 -- Name: index_api_client_authorizations_on_expires_at; Type: INDEX; Schema: public; Owner: -
1836 CREATE INDEX index_api_client_authorizations_on_expires_at ON public.api_client_authorizations USING btree (expires_at);
1840 -- Name: index_api_client_authorizations_on_user_id; Type: INDEX; Schema: public; Owner: -
1843 CREATE INDEX index_api_client_authorizations_on_user_id ON public.api_client_authorizations USING btree (user_id);
1847 -- Name: index_api_client_authorizations_on_uuid; Type: INDEX; Schema: public; Owner: -
1850 CREATE UNIQUE INDEX index_api_client_authorizations_on_uuid ON public.api_client_authorizations USING btree (uuid);
1854 -- Name: index_api_clients_on_created_at; Type: INDEX; Schema: public; Owner: -
1857 CREATE INDEX index_api_clients_on_created_at ON public.api_clients USING btree (created_at);
1861 -- Name: index_api_clients_on_modified_at; Type: INDEX; Schema: public; Owner: -
1864 CREATE INDEX index_api_clients_on_modified_at ON public.api_clients USING btree (modified_at);
1868 -- Name: index_api_clients_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1871 CREATE INDEX index_api_clients_on_owner_uuid ON public.api_clients USING btree (owner_uuid);
1875 -- Name: index_api_clients_on_uuid; Type: INDEX; Schema: public; Owner: -
1878 CREATE UNIQUE INDEX index_api_clients_on_uuid ON public.api_clients USING btree (uuid);
1882 -- Name: index_authkeys_on_user_and_expires_at; Type: INDEX; Schema: public; Owner: -
1885 CREATE INDEX index_authkeys_on_user_and_expires_at ON public.authorized_keys USING btree (authorized_user_uuid, expires_at);
1889 -- Name: index_authorized_keys_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1892 CREATE INDEX index_authorized_keys_on_owner_uuid ON public.authorized_keys USING btree (owner_uuid);
1896 -- Name: index_authorized_keys_on_uuid; Type: INDEX; Schema: public; Owner: -
1899 CREATE UNIQUE INDEX index_authorized_keys_on_uuid ON public.authorized_keys USING btree (uuid);
1903 -- Name: index_collections_on_created_at; Type: INDEX; Schema: public; Owner: -
1906 CREATE INDEX index_collections_on_created_at ON public.collections USING btree (created_at);
1910 -- Name: index_collections_on_current_version_uuid_and_version; Type: INDEX; Schema: public; Owner: -
1913 CREATE UNIQUE INDEX index_collections_on_current_version_uuid_and_version ON public.collections USING btree (current_version_uuid, version);
1917 -- Name: index_collections_on_delete_at; Type: INDEX; Schema: public; Owner: -
1920 CREATE INDEX index_collections_on_delete_at ON public.collections USING btree (delete_at);
1924 -- Name: index_collections_on_is_trashed; Type: INDEX; Schema: public; Owner: -
1927 CREATE INDEX index_collections_on_is_trashed ON public.collections USING btree (is_trashed);
1931 -- Name: index_collections_on_modified_at; Type: INDEX; Schema: public; Owner: -
1934 CREATE INDEX index_collections_on_modified_at ON public.collections USING btree (modified_at);
1938 -- Name: index_collections_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
1941 CREATE INDEX index_collections_on_modified_at_uuid ON public.collections USING btree (modified_at DESC, uuid);
1945 -- Name: index_collections_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1948 CREATE INDEX index_collections_on_owner_uuid ON public.collections USING btree (owner_uuid);
1952 -- Name: index_collections_on_owner_uuid_and_name; Type: INDEX; Schema: public; Owner: -
1955 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));
1959 -- Name: index_collections_on_portable_data_hash_and_trash_at; Type: INDEX; Schema: public; Owner: -
1962 CREATE INDEX index_collections_on_portable_data_hash_and_trash_at ON public.collections USING btree (portable_data_hash, trash_at);
1966 -- Name: index_collections_on_trash_at; Type: INDEX; Schema: public; Owner: -
1969 CREATE INDEX index_collections_on_trash_at ON public.collections USING btree (trash_at);
1973 -- Name: index_collections_on_uuid; Type: INDEX; Schema: public; Owner: -
1976 CREATE UNIQUE INDEX index_collections_on_uuid ON public.collections USING btree (uuid);
1980 -- Name: index_container_requests_on_container_uuid; Type: INDEX; Schema: public; Owner: -
1983 CREATE INDEX index_container_requests_on_container_uuid ON public.container_requests USING btree (container_uuid);
1987 -- Name: index_container_requests_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
1990 CREATE INDEX index_container_requests_on_modified_at_uuid ON public.container_requests USING btree (modified_at DESC, uuid);
1994 -- Name: index_container_requests_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
1997 CREATE INDEX index_container_requests_on_owner_uuid ON public.container_requests USING btree (owner_uuid);
2001 -- Name: index_container_requests_on_requesting_container_uuid; Type: INDEX; Schema: public; Owner: -
2004 CREATE INDEX index_container_requests_on_requesting_container_uuid ON public.container_requests USING btree (requesting_container_uuid);
2008 -- Name: index_container_requests_on_uuid; Type: INDEX; Schema: public; Owner: -
2011 CREATE UNIQUE INDEX index_container_requests_on_uuid ON public.container_requests USING btree (uuid);
2015 -- Name: index_containers_on_auth_uuid; Type: INDEX; Schema: public; Owner: -
2018 CREATE INDEX index_containers_on_auth_uuid ON public.containers USING btree (auth_uuid);
2022 -- Name: index_containers_on_locked_by_uuid_and_priority; Type: INDEX; Schema: public; Owner: -
2025 CREATE INDEX index_containers_on_locked_by_uuid_and_priority ON public.containers USING btree (locked_by_uuid, priority);
2029 -- Name: index_containers_on_locked_by_uuid_and_uuid; Type: INDEX; Schema: public; Owner: -
2032 CREATE INDEX index_containers_on_locked_by_uuid_and_uuid ON public.containers USING btree (locked_by_uuid, uuid);
2036 -- Name: index_containers_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2039 CREATE INDEX index_containers_on_modified_at_uuid ON public.containers USING btree (modified_at DESC, uuid);
2043 -- Name: index_containers_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2046 CREATE INDEX index_containers_on_owner_uuid ON public.containers USING btree (owner_uuid);
2050 -- Name: index_containers_on_queued_state; Type: INDEX; Schema: public; Owner: -
2053 CREATE INDEX index_containers_on_queued_state ON public.containers USING btree (state, ((priority > 0)));
2057 -- Name: index_containers_on_reuse_columns; Type: INDEX; Schema: public; Owner: -
2060 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));
2064 -- Name: index_containers_on_runtime_status; Type: INDEX; Schema: public; Owner: -
2067 CREATE INDEX index_containers_on_runtime_status ON public.containers USING gin (runtime_status);
2071 -- Name: index_containers_on_secret_mounts_md5; Type: INDEX; Schema: public; Owner: -
2074 CREATE INDEX index_containers_on_secret_mounts_md5 ON public.containers USING btree (secret_mounts_md5);
2078 -- Name: index_containers_on_uuid; Type: INDEX; Schema: public; Owner: -
2081 CREATE UNIQUE INDEX index_containers_on_uuid ON public.containers USING btree (uuid);
2085 -- Name: index_groups_on_created_at; Type: INDEX; Schema: public; Owner: -
2088 CREATE INDEX index_groups_on_created_at ON public.groups USING btree (created_at);
2092 -- Name: index_groups_on_delete_at; Type: INDEX; Schema: public; Owner: -
2095 CREATE INDEX index_groups_on_delete_at ON public.groups USING btree (delete_at);
2099 -- Name: index_groups_on_group_class; Type: INDEX; Schema: public; Owner: -
2102 CREATE INDEX index_groups_on_group_class ON public.groups USING btree (group_class);
2106 -- Name: index_groups_on_is_trashed; Type: INDEX; Schema: public; Owner: -
2109 CREATE INDEX index_groups_on_is_trashed ON public.groups USING btree (is_trashed);
2113 -- Name: index_groups_on_modified_at; Type: INDEX; Schema: public; Owner: -
2116 CREATE INDEX index_groups_on_modified_at ON public.groups USING btree (modified_at);
2120 -- Name: index_groups_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2123 CREATE INDEX index_groups_on_modified_at_uuid ON public.groups USING btree (modified_at DESC, uuid);
2127 -- Name: index_groups_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2130 CREATE INDEX index_groups_on_owner_uuid ON public.groups USING btree (owner_uuid);
2134 -- Name: index_groups_on_owner_uuid_and_name; Type: INDEX; Schema: public; Owner: -
2137 CREATE UNIQUE INDEX index_groups_on_owner_uuid_and_name ON public.groups USING btree (owner_uuid, name) WHERE (is_trashed = false);
2141 -- Name: index_groups_on_trash_at; Type: INDEX; Schema: public; Owner: -
2144 CREATE INDEX index_groups_on_trash_at ON public.groups USING btree (trash_at);
2148 -- Name: index_groups_on_uuid; Type: INDEX; Schema: public; Owner: -
2151 CREATE UNIQUE INDEX index_groups_on_uuid ON public.groups USING btree (uuid);
2155 -- Name: index_humans_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2158 CREATE INDEX index_humans_on_owner_uuid ON public.humans USING btree (owner_uuid);
2162 -- Name: index_humans_on_uuid; Type: INDEX; Schema: public; Owner: -
2165 CREATE UNIQUE INDEX index_humans_on_uuid ON public.humans USING btree (uuid);
2169 -- Name: index_job_tasks_on_created_at; Type: INDEX; Schema: public; Owner: -
2172 CREATE INDEX index_job_tasks_on_created_at ON public.job_tasks USING btree (created_at);
2176 -- Name: index_job_tasks_on_created_by_job_task_uuid; Type: INDEX; Schema: public; Owner: -
2179 CREATE INDEX index_job_tasks_on_created_by_job_task_uuid ON public.job_tasks USING btree (created_by_job_task_uuid);
2183 -- Name: index_job_tasks_on_job_uuid; Type: INDEX; Schema: public; Owner: -
2186 CREATE INDEX index_job_tasks_on_job_uuid ON public.job_tasks USING btree (job_uuid);
2190 -- Name: index_job_tasks_on_modified_at; Type: INDEX; Schema: public; Owner: -
2193 CREATE INDEX index_job_tasks_on_modified_at ON public.job_tasks USING btree (modified_at);
2197 -- Name: index_job_tasks_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2200 CREATE INDEX index_job_tasks_on_owner_uuid ON public.job_tasks USING btree (owner_uuid);
2204 -- Name: index_job_tasks_on_sequence; Type: INDEX; Schema: public; Owner: -
2207 CREATE INDEX index_job_tasks_on_sequence ON public.job_tasks USING btree (sequence);
2211 -- Name: index_job_tasks_on_success; Type: INDEX; Schema: public; Owner: -
2214 CREATE INDEX index_job_tasks_on_success ON public.job_tasks USING btree (success);
2218 -- Name: index_job_tasks_on_uuid; Type: INDEX; Schema: public; Owner: -
2221 CREATE UNIQUE INDEX index_job_tasks_on_uuid ON public.job_tasks USING btree (uuid);
2225 -- Name: index_jobs_on_created_at; Type: INDEX; Schema: public; Owner: -
2228 CREATE INDEX index_jobs_on_created_at ON public.jobs USING btree (created_at);
2232 -- Name: index_jobs_on_finished_at; Type: INDEX; Schema: public; Owner: -
2235 CREATE INDEX index_jobs_on_finished_at ON public.jobs USING btree (finished_at);
2239 -- Name: index_jobs_on_modified_at; Type: INDEX; Schema: public; Owner: -
2242 CREATE INDEX index_jobs_on_modified_at ON public.jobs USING btree (modified_at);
2246 -- Name: index_jobs_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2249 CREATE INDEX index_jobs_on_modified_at_uuid ON public.jobs USING btree (modified_at DESC, uuid);
2253 -- Name: index_jobs_on_output; Type: INDEX; Schema: public; Owner: -
2256 CREATE INDEX index_jobs_on_output ON public.jobs USING btree (output);
2260 -- Name: index_jobs_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2263 CREATE INDEX index_jobs_on_owner_uuid ON public.jobs USING btree (owner_uuid);
2267 -- Name: index_jobs_on_script; Type: INDEX; Schema: public; Owner: -
2270 CREATE INDEX index_jobs_on_script ON public.jobs USING btree (script);
2274 -- Name: index_jobs_on_script_parameters_digest; Type: INDEX; Schema: public; Owner: -
2277 CREATE INDEX index_jobs_on_script_parameters_digest ON public.jobs USING btree (script_parameters_digest);
2281 -- Name: index_jobs_on_started_at; Type: INDEX; Schema: public; Owner: -
2284 CREATE INDEX index_jobs_on_started_at ON public.jobs USING btree (started_at);
2288 -- Name: index_jobs_on_submit_id; Type: INDEX; Schema: public; Owner: -
2291 CREATE UNIQUE INDEX index_jobs_on_submit_id ON public.jobs USING btree (submit_id);
2295 -- Name: index_jobs_on_uuid; Type: INDEX; Schema: public; Owner: -
2298 CREATE UNIQUE INDEX index_jobs_on_uuid ON public.jobs USING btree (uuid);
2302 -- Name: index_keep_disks_on_filesystem_uuid; Type: INDEX; Schema: public; Owner: -
2305 CREATE INDEX index_keep_disks_on_filesystem_uuid ON public.keep_disks USING btree (filesystem_uuid);
2309 -- Name: index_keep_disks_on_last_ping_at; Type: INDEX; Schema: public; Owner: -
2312 CREATE INDEX index_keep_disks_on_last_ping_at ON public.keep_disks USING btree (last_ping_at);
2316 -- Name: index_keep_disks_on_node_uuid; Type: INDEX; Schema: public; Owner: -
2319 CREATE INDEX index_keep_disks_on_node_uuid ON public.keep_disks USING btree (node_uuid);
2323 -- Name: index_keep_disks_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2326 CREATE INDEX index_keep_disks_on_owner_uuid ON public.keep_disks USING btree (owner_uuid);
2330 -- Name: index_keep_disks_on_uuid; Type: INDEX; Schema: public; Owner: -
2333 CREATE UNIQUE INDEX index_keep_disks_on_uuid ON public.keep_disks USING btree (uuid);
2337 -- Name: index_keep_services_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2340 CREATE INDEX index_keep_services_on_owner_uuid ON public.keep_services USING btree (owner_uuid);
2344 -- Name: index_keep_services_on_uuid; Type: INDEX; Schema: public; Owner: -
2347 CREATE UNIQUE INDEX index_keep_services_on_uuid ON public.keep_services USING btree (uuid);
2351 -- Name: index_links_on_created_at; Type: INDEX; Schema: public; Owner: -
2354 CREATE INDEX index_links_on_created_at ON public.links USING btree (created_at);
2358 -- Name: index_links_on_head_uuid; Type: INDEX; Schema: public; Owner: -
2361 CREATE INDEX index_links_on_head_uuid ON public.links USING btree (head_uuid);
2365 -- Name: index_links_on_modified_at; Type: INDEX; Schema: public; Owner: -
2368 CREATE INDEX index_links_on_modified_at ON public.links USING btree (modified_at);
2372 -- Name: index_links_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2375 CREATE INDEX index_links_on_modified_at_uuid ON public.links USING btree (modified_at DESC, uuid);
2379 -- Name: index_links_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2382 CREATE INDEX index_links_on_owner_uuid ON public.links USING btree (owner_uuid);
2386 -- Name: index_links_on_substring_head_uuid; Type: INDEX; Schema: public; Owner: -
2389 CREATE INDEX index_links_on_substring_head_uuid ON public.links USING btree ("substring"((head_uuid)::text, 7, 5));
2393 -- Name: index_links_on_substring_tail_uuid; Type: INDEX; Schema: public; Owner: -
2396 CREATE INDEX index_links_on_substring_tail_uuid ON public.links USING btree ("substring"((tail_uuid)::text, 7, 5));
2400 -- Name: index_links_on_tail_uuid; Type: INDEX; Schema: public; Owner: -
2403 CREATE INDEX index_links_on_tail_uuid ON public.links USING btree (tail_uuid);
2407 -- Name: index_links_on_uuid; Type: INDEX; Schema: public; Owner: -
2410 CREATE UNIQUE INDEX index_links_on_uuid ON public.links USING btree (uuid);
2414 -- Name: index_logs_on_created_at; Type: INDEX; Schema: public; Owner: -
2417 CREATE INDEX index_logs_on_created_at ON public.logs USING btree (created_at);
2421 -- Name: index_logs_on_event_at; Type: INDEX; Schema: public; Owner: -
2424 CREATE INDEX index_logs_on_event_at ON public.logs USING btree (event_at);
2428 -- Name: index_logs_on_event_type; Type: INDEX; Schema: public; Owner: -
2431 CREATE INDEX index_logs_on_event_type ON public.logs USING btree (event_type);
2435 -- Name: index_logs_on_modified_at; Type: INDEX; Schema: public; Owner: -
2438 CREATE INDEX index_logs_on_modified_at ON public.logs USING btree (modified_at);
2442 -- Name: index_logs_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2445 CREATE INDEX index_logs_on_modified_at_uuid ON public.logs USING btree (modified_at DESC, uuid);
2449 -- Name: index_logs_on_object_owner_uuid; Type: INDEX; Schema: public; Owner: -
2452 CREATE INDEX index_logs_on_object_owner_uuid ON public.logs USING btree (object_owner_uuid);
2456 -- Name: index_logs_on_object_uuid; Type: INDEX; Schema: public; Owner: -
2459 CREATE INDEX index_logs_on_object_uuid ON public.logs USING btree (object_uuid);
2463 -- Name: index_logs_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2466 CREATE INDEX index_logs_on_owner_uuid ON public.logs USING btree (owner_uuid);
2470 -- Name: index_logs_on_summary; Type: INDEX; Schema: public; Owner: -
2473 CREATE INDEX index_logs_on_summary ON public.logs USING btree (summary);
2477 -- Name: index_logs_on_uuid; Type: INDEX; Schema: public; Owner: -
2480 CREATE UNIQUE INDEX index_logs_on_uuid ON public.logs USING btree (uuid);
2484 -- Name: index_nodes_on_created_at; Type: INDEX; Schema: public; Owner: -
2487 CREATE INDEX index_nodes_on_created_at ON public.nodes USING btree (created_at);
2491 -- Name: index_nodes_on_hostname; Type: INDEX; Schema: public; Owner: -
2494 CREATE INDEX index_nodes_on_hostname ON public.nodes USING btree (hostname);
2498 -- Name: index_nodes_on_modified_at; Type: INDEX; Schema: public; Owner: -
2501 CREATE INDEX index_nodes_on_modified_at ON public.nodes USING btree (modified_at);
2505 -- Name: index_nodes_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2508 CREATE INDEX index_nodes_on_owner_uuid ON public.nodes USING btree (owner_uuid);
2512 -- Name: index_nodes_on_slot_number; Type: INDEX; Schema: public; Owner: -
2515 CREATE UNIQUE INDEX index_nodes_on_slot_number ON public.nodes USING btree (slot_number);
2519 -- Name: index_nodes_on_uuid; Type: INDEX; Schema: public; Owner: -
2522 CREATE UNIQUE INDEX index_nodes_on_uuid ON public.nodes USING btree (uuid);
2526 -- Name: index_pipeline_instances_on_created_at; Type: INDEX; Schema: public; Owner: -
2529 CREATE INDEX index_pipeline_instances_on_created_at ON public.pipeline_instances USING btree (created_at);
2533 -- Name: index_pipeline_instances_on_modified_at; Type: INDEX; Schema: public; Owner: -
2536 CREATE INDEX index_pipeline_instances_on_modified_at ON public.pipeline_instances USING btree (modified_at);
2540 -- Name: index_pipeline_instances_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2543 CREATE INDEX index_pipeline_instances_on_modified_at_uuid ON public.pipeline_instances USING btree (modified_at DESC, uuid);
2547 -- Name: index_pipeline_instances_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2550 CREATE INDEX index_pipeline_instances_on_owner_uuid ON public.pipeline_instances USING btree (owner_uuid);
2554 -- Name: index_pipeline_instances_on_uuid; Type: INDEX; Schema: public; Owner: -
2557 CREATE UNIQUE INDEX index_pipeline_instances_on_uuid ON public.pipeline_instances USING btree (uuid);
2561 -- Name: index_pipeline_templates_on_created_at; Type: INDEX; Schema: public; Owner: -
2564 CREATE INDEX index_pipeline_templates_on_created_at ON public.pipeline_templates USING btree (created_at);
2568 -- Name: index_pipeline_templates_on_modified_at; Type: INDEX; Schema: public; Owner: -
2571 CREATE INDEX index_pipeline_templates_on_modified_at ON public.pipeline_templates USING btree (modified_at);
2575 -- Name: index_pipeline_templates_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2578 CREATE INDEX index_pipeline_templates_on_modified_at_uuid ON public.pipeline_templates USING btree (modified_at DESC, uuid);
2582 -- Name: index_pipeline_templates_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2585 CREATE INDEX index_pipeline_templates_on_owner_uuid ON public.pipeline_templates USING btree (owner_uuid);
2589 -- Name: index_pipeline_templates_on_uuid; Type: INDEX; Schema: public; Owner: -
2592 CREATE UNIQUE INDEX index_pipeline_templates_on_uuid ON public.pipeline_templates USING btree (uuid);
2596 -- Name: index_repositories_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2599 CREATE INDEX index_repositories_on_modified_at_uuid ON public.repositories USING btree (modified_at DESC, uuid);
2603 -- Name: index_repositories_on_name; Type: INDEX; Schema: public; Owner: -
2606 CREATE UNIQUE INDEX index_repositories_on_name ON public.repositories USING btree (name);
2610 -- Name: index_repositories_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2613 CREATE INDEX index_repositories_on_owner_uuid ON public.repositories USING btree (owner_uuid);
2617 -- Name: index_repositories_on_uuid; Type: INDEX; Schema: public; Owner: -
2620 CREATE UNIQUE INDEX index_repositories_on_uuid ON public.repositories USING btree (uuid);
2624 -- Name: index_specimens_on_created_at; Type: INDEX; Schema: public; Owner: -
2627 CREATE INDEX index_specimens_on_created_at ON public.specimens USING btree (created_at);
2631 -- Name: index_specimens_on_modified_at; Type: INDEX; Schema: public; Owner: -
2634 CREATE INDEX index_specimens_on_modified_at ON public.specimens USING btree (modified_at);
2638 -- Name: index_specimens_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2641 CREATE INDEX index_specimens_on_owner_uuid ON public.specimens USING btree (owner_uuid);
2645 -- Name: index_specimens_on_uuid; Type: INDEX; Schema: public; Owner: -
2648 CREATE UNIQUE INDEX index_specimens_on_uuid ON public.specimens USING btree (uuid);
2652 -- Name: index_traits_on_name; Type: INDEX; Schema: public; Owner: -
2655 CREATE INDEX index_traits_on_name ON public.traits USING btree (name);
2659 -- Name: index_traits_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2662 CREATE INDEX index_traits_on_owner_uuid ON public.traits USING btree (owner_uuid);
2666 -- Name: index_traits_on_uuid; Type: INDEX; Schema: public; Owner: -
2669 CREATE UNIQUE INDEX index_traits_on_uuid ON public.traits USING btree (uuid);
2673 -- Name: index_trashed_groups_on_group_uuid; Type: INDEX; Schema: public; Owner: -
2676 CREATE UNIQUE INDEX index_trashed_groups_on_group_uuid ON public.trashed_groups USING btree (group_uuid);
2680 -- Name: index_users_on_created_at; Type: INDEX; Schema: public; Owner: -
2683 CREATE INDEX index_users_on_created_at ON public.users USING btree (created_at);
2687 -- Name: index_users_on_identity_url; Type: INDEX; Schema: public; Owner: -
2690 CREATE UNIQUE INDEX index_users_on_identity_url ON public.users USING btree (identity_url);
2694 -- Name: index_users_on_modified_at; Type: INDEX; Schema: public; Owner: -
2697 CREATE INDEX index_users_on_modified_at ON public.users USING btree (modified_at);
2701 -- Name: index_users_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2704 CREATE INDEX index_users_on_modified_at_uuid ON public.users USING btree (modified_at DESC, uuid);
2708 -- Name: index_users_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2711 CREATE INDEX index_users_on_owner_uuid ON public.users USING btree (owner_uuid);
2715 -- Name: index_users_on_username; Type: INDEX; Schema: public; Owner: -
2718 CREATE UNIQUE INDEX index_users_on_username ON public.users USING btree (username);
2722 -- Name: index_users_on_uuid; Type: INDEX; Schema: public; Owner: -
2725 CREATE UNIQUE INDEX index_users_on_uuid ON public.users USING btree (uuid);
2729 -- Name: index_virtual_machines_on_hostname; Type: INDEX; Schema: public; Owner: -
2732 CREATE INDEX index_virtual_machines_on_hostname ON public.virtual_machines USING btree (hostname);
2736 -- Name: index_virtual_machines_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2739 CREATE INDEX index_virtual_machines_on_modified_at_uuid ON public.virtual_machines USING btree (modified_at DESC, uuid);
2743 -- Name: index_virtual_machines_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2746 CREATE INDEX index_virtual_machines_on_owner_uuid ON public.virtual_machines USING btree (owner_uuid);
2750 -- Name: index_virtual_machines_on_uuid; Type: INDEX; Schema: public; Owner: -
2753 CREATE UNIQUE INDEX index_virtual_machines_on_uuid ON public.virtual_machines USING btree (uuid);
2757 -- Name: index_workflows_on_modified_at_uuid; Type: INDEX; Schema: public; Owner: -
2760 CREATE INDEX index_workflows_on_modified_at_uuid ON public.workflows USING btree (modified_at DESC, uuid);
2764 -- Name: index_workflows_on_owner_uuid; Type: INDEX; Schema: public; Owner: -
2767 CREATE INDEX index_workflows_on_owner_uuid ON public.workflows USING btree (owner_uuid);
2771 -- Name: index_workflows_on_uuid; Type: INDEX; Schema: public; Owner: -
2774 CREATE UNIQUE INDEX index_workflows_on_uuid ON public.workflows USING btree (uuid);
2778 -- Name: job_tasks_search_index; Type: INDEX; Schema: public; Owner: -
2781 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);
2785 -- Name: jobs_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2788 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)));
2792 -- Name: jobs_search_index; Type: INDEX; Schema: public; Owner: -
2795 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);
2799 -- Name: jobs_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2802 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);
2806 -- Name: keep_disks_search_index; Type: INDEX; Schema: public; Owner: -
2809 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);
2813 -- Name: keep_services_search_index; Type: INDEX; Schema: public; Owner: -
2816 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);
2820 -- Name: links_index_on_properties; Type: INDEX; Schema: public; Owner: -
2823 CREATE INDEX links_index_on_properties ON public.links USING gin (properties);
2827 -- Name: links_search_index; Type: INDEX; Schema: public; Owner: -
2830 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);
2834 -- Name: links_tail_name_unique_if_link_class_name; Type: INDEX; Schema: public; Owner: -
2837 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);
2841 -- Name: logs_search_index; Type: INDEX; Schema: public; Owner: -
2844 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);
2848 -- Name: nodes_index_on_info; Type: INDEX; Schema: public; Owner: -
2851 CREATE INDEX nodes_index_on_info ON public.nodes USING gin (info);
2855 -- Name: nodes_index_on_properties; Type: INDEX; Schema: public; Owner: -
2858 CREATE INDEX nodes_index_on_properties ON public.nodes USING gin (properties);
2862 -- Name: nodes_search_index; Type: INDEX; Schema: public; Owner: -
2865 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);
2869 -- Name: permission_target; Type: INDEX; Schema: public; Owner: -
2872 CREATE INDEX permission_target ON public.materialized_permissions USING btree (target_uuid);
2876 -- Name: permission_user_target; Type: INDEX; Schema: public; Owner: -
2879 CREATE UNIQUE INDEX permission_user_target ON public.materialized_permissions USING btree (user_uuid, target_uuid);
2883 -- Name: pipeline_instances_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2886 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)));
2890 -- Name: pipeline_instances_search_index; Type: INDEX; Schema: public; Owner: -
2893 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);
2897 -- Name: pipeline_instances_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2900 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);
2904 -- Name: pipeline_template_owner_uuid_name_unique; Type: INDEX; Schema: public; Owner: -
2907 CREATE UNIQUE INDEX pipeline_template_owner_uuid_name_unique ON public.pipeline_templates USING btree (owner_uuid, name);
2911 -- Name: pipeline_templates_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2914 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)));
2918 -- Name: pipeline_templates_search_index; Type: INDEX; Schema: public; Owner: -
2921 CREATE INDEX pipeline_templates_search_index ON public.pipeline_templates USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2925 -- Name: pipeline_templates_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2928 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);
2932 -- Name: repositories_search_index; Type: INDEX; Schema: public; Owner: -
2935 CREATE INDEX repositories_search_index ON public.repositories USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2939 -- Name: specimens_search_index; Type: INDEX; Schema: public; Owner: -
2942 CREATE INDEX specimens_search_index ON public.specimens USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, material);
2946 -- Name: traits_search_index; Type: INDEX; Schema: public; Owner: -
2949 CREATE INDEX traits_search_index ON public.traits USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2953 -- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -
2956 CREATE UNIQUE INDEX unique_schema_migrations ON public.schema_migrations USING btree (version);
2960 -- Name: users_search_index; Type: INDEX; Schema: public; Owner: -
2963 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);
2967 -- Name: virtual_machines_search_index; Type: INDEX; Schema: public; Owner: -
2970 CREATE INDEX virtual_machines_search_index ON public.virtual_machines USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, hostname);
2974 -- Name: workflows_full_text_search_idx; Type: INDEX; Schema: public; Owner: -
2977 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)));
2981 -- Name: workflows_search_idx; Type: INDEX; Schema: public; Owner: -
2984 CREATE INDEX workflows_search_idx ON public.workflows USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2988 -- Name: workflows_trgm_text_search_idx; Type: INDEX; Schema: public; Owner: -
2991 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);
2995 -- PostgreSQL database dump complete
2998 SET search_path TO "$user", public;
3000 INSERT INTO "schema_migrations" (version) VALUES