2 -- PostgreSQL database dump
5 SET statement_timeout = 0;
6 SET client_encoding = 'UTF8';
7 SET standard_conforming_strings = on;
8 SET check_function_bodies = false;
9 SET client_min_messages = warning;
12 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
15 CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
19 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
22 COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
25 SET search_path = public, pg_catalog;
27 SET default_tablespace = '';
29 SET default_with_oids = false;
32 -- Name: api_client_authorizations; Type: TABLE; Schema: public; Owner: -; Tablespace:
35 CREATE TABLE api_client_authorizations (
37 api_token character varying(255) NOT NULL,
38 api_client_id integer NOT NULL,
39 user_id integer NOT NULL,
40 created_by_ip_address character varying(255),
41 last_used_by_ip_address character varying(255),
42 last_used_at timestamp without time zone,
43 expires_at timestamp without time zone,
44 created_at timestamp without time zone NOT NULL,
45 updated_at timestamp without time zone NOT NULL,
46 default_owner_uuid character varying(255),
47 scopes text DEFAULT '---
54 -- Name: api_client_authorizations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
57 CREATE SEQUENCE api_client_authorizations_id_seq
66 -- Name: api_client_authorizations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
69 ALTER SEQUENCE api_client_authorizations_id_seq OWNED BY api_client_authorizations.id;
73 -- Name: api_clients; Type: TABLE; Schema: public; Owner: -; Tablespace:
76 CREATE TABLE api_clients (
78 uuid character varying(255),
79 owner_uuid character varying(255),
80 modified_by_client_uuid character varying(255),
81 modified_by_user_uuid character varying(255),
82 modified_at timestamp without time zone,
83 name character varying(255),
84 url_prefix character varying(255),
85 created_at timestamp without time zone NOT NULL,
86 updated_at timestamp without time zone NOT NULL,
87 is_trusted boolean DEFAULT false
92 -- Name: api_clients_id_seq; Type: SEQUENCE; Schema: public; Owner: -
95 CREATE SEQUENCE api_clients_id_seq
104 -- Name: api_clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
107 ALTER SEQUENCE api_clients_id_seq OWNED BY api_clients.id;
111 -- Name: authorized_keys; Type: TABLE; Schema: public; Owner: -; Tablespace:
114 CREATE TABLE authorized_keys (
116 uuid character varying(255) NOT NULL,
117 owner_uuid character varying(255) NOT NULL,
118 modified_by_client_uuid character varying(255),
119 modified_by_user_uuid character varying(255),
120 modified_at timestamp without time zone,
121 name character varying(255),
122 key_type character varying(255),
123 authorized_user_uuid character varying(255),
125 expires_at timestamp without time zone,
126 created_at timestamp without time zone NOT NULL,
127 updated_at timestamp without time zone NOT NULL
132 -- Name: authorized_keys_id_seq; Type: SEQUENCE; Schema: public; Owner: -
135 CREATE SEQUENCE authorized_keys_id_seq
144 -- Name: authorized_keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
147 ALTER SEQUENCE authorized_keys_id_seq OWNED BY authorized_keys.id;
151 -- Name: collections; Type: TABLE; Schema: public; Owner: -; Tablespace:
154 CREATE TABLE collections (
156 owner_uuid character varying(255),
157 created_at timestamp without time zone NOT NULL,
158 modified_by_client_uuid character varying(255),
159 modified_by_user_uuid character varying(255),
160 modified_at timestamp without time zone,
161 portable_data_hash character varying(255),
162 replication_desired integer,
163 replication_confirmed_at timestamp without time zone,
164 replication_confirmed integer,
165 updated_at timestamp without time zone NOT NULL,
166 uuid character varying(255),
168 name character varying(255),
169 description character varying(524288),
171 expires_at timestamp without time zone,
172 file_names character varying(8192)
177 -- Name: collections_id_seq; Type: SEQUENCE; Schema: public; Owner: -
180 CREATE SEQUENCE collections_id_seq
189 -- Name: collections_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
192 ALTER SEQUENCE collections_id_seq OWNED BY collections.id;
196 -- Name: commit_ancestors; Type: TABLE; Schema: public; Owner: -; Tablespace:
199 CREATE TABLE commit_ancestors (
201 repository_name character varying(255),
202 descendant character varying(255) NOT NULL,
203 ancestor character varying(255) NOT NULL,
204 "is" boolean DEFAULT false NOT NULL,
205 created_at timestamp without time zone NOT NULL,
206 updated_at timestamp without time zone NOT NULL
211 -- Name: commit_ancestors_id_seq; Type: SEQUENCE; Schema: public; Owner: -
214 CREATE SEQUENCE commit_ancestors_id_seq
223 -- Name: commit_ancestors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
226 ALTER SEQUENCE commit_ancestors_id_seq OWNED BY commit_ancestors.id;
230 -- Name: commits; Type: TABLE; Schema: public; Owner: -; Tablespace:
233 CREATE TABLE commits (
235 repository_name character varying(255),
236 sha1 character varying(255),
237 message character varying(255),
238 created_at timestamp without time zone NOT NULL,
239 updated_at timestamp without time zone NOT NULL
244 -- Name: commits_id_seq; Type: SEQUENCE; Schema: public; Owner: -
247 CREATE SEQUENCE commits_id_seq
256 -- Name: commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
259 ALTER SEQUENCE commits_id_seq OWNED BY commits.id;
263 -- Name: groups; Type: TABLE; Schema: public; Owner: -; Tablespace:
266 CREATE TABLE groups (
268 uuid character varying(255),
269 owner_uuid character varying(255),
270 created_at timestamp without time zone NOT NULL,
271 modified_by_client_uuid character varying(255),
272 modified_by_user_uuid character varying(255),
273 modified_at timestamp without time zone,
274 name character varying(255) NOT NULL,
275 description character varying(524288),
276 updated_at timestamp without time zone NOT NULL,
277 group_class character varying(255)
282 -- Name: groups_id_seq; Type: SEQUENCE; Schema: public; Owner: -
285 CREATE SEQUENCE groups_id_seq
294 -- Name: groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
297 ALTER SEQUENCE groups_id_seq OWNED BY groups.id;
301 -- Name: humans; Type: TABLE; Schema: public; Owner: -; Tablespace:
304 CREATE TABLE humans (
306 uuid character varying(255) NOT NULL,
307 owner_uuid character varying(255) NOT NULL,
308 modified_by_client_uuid character varying(255),
309 modified_by_user_uuid character varying(255),
310 modified_at timestamp without time zone,
312 created_at timestamp without time zone NOT NULL,
313 updated_at timestamp without time zone NOT NULL
318 -- Name: humans_id_seq; Type: SEQUENCE; Schema: public; Owner: -
321 CREATE SEQUENCE humans_id_seq
330 -- Name: humans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
333 ALTER SEQUENCE humans_id_seq OWNED BY humans.id;
337 -- Name: job_tasks; Type: TABLE; Schema: public; Owner: -; Tablespace:
340 CREATE TABLE job_tasks (
342 uuid character varying(255),
343 owner_uuid character varying(255),
344 modified_by_client_uuid character varying(255),
345 modified_by_user_uuid character varying(255),
346 modified_at timestamp without time zone,
347 job_uuid character varying(255),
351 progress double precision,
353 created_at timestamp without time zone NOT NULL,
354 updated_at timestamp without time zone NOT NULL,
355 created_by_job_task_uuid character varying(255),
357 started_at timestamp without time zone,
358 finished_at timestamp without time zone
363 -- Name: job_tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
366 CREATE SEQUENCE job_tasks_id_seq
375 -- Name: job_tasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
378 ALTER SEQUENCE job_tasks_id_seq OWNED BY job_tasks.id;
382 -- Name: job_tasks_qsequence_seq; Type: SEQUENCE; Schema: public; Owner: -
385 CREATE SEQUENCE job_tasks_qsequence_seq
394 -- Name: job_tasks_qsequence_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
397 ALTER SEQUENCE job_tasks_qsequence_seq OWNED BY job_tasks.qsequence;
401 -- Name: jobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
406 uuid character varying(255),
407 owner_uuid character varying(255),
408 modified_by_client_uuid character varying(255),
409 modified_by_user_uuid character varying(255),
410 modified_at timestamp without time zone,
411 submit_id character varying(255),
412 script character varying(255),
413 script_version character varying(255),
414 script_parameters text,
415 cancelled_by_client_uuid character varying(255),
416 cancelled_by_user_uuid character varying(255),
417 cancelled_at timestamp without time zone,
418 started_at timestamp without time zone,
419 finished_at timestamp without time zone,
422 output character varying(255),
423 created_at timestamp without time zone NOT NULL,
424 updated_at timestamp without time zone NOT NULL,
425 is_locked_by_uuid character varying(255),
426 log character varying(255),
428 runtime_constraints text,
429 nondeterministic boolean,
430 repository character varying(255),
431 supplied_script_version character varying(255),
432 docker_image_locator character varying(255),
433 priority integer DEFAULT 0 NOT NULL,
434 description character varying(524288),
435 state character varying(255),
436 arvados_sdk_version character varying(255)
441 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
444 CREATE SEQUENCE jobs_id_seq
453 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
456 ALTER SEQUENCE jobs_id_seq OWNED BY jobs.id;
460 -- Name: keep_disks; Type: TABLE; Schema: public; Owner: -; Tablespace:
463 CREATE TABLE keep_disks (
465 uuid character varying(255) NOT NULL,
466 owner_uuid character varying(255) NOT NULL,
467 modified_by_client_uuid character varying(255),
468 modified_by_user_uuid character varying(255),
469 modified_at timestamp without time zone,
470 ping_secret character varying(255) NOT NULL,
471 node_uuid character varying(255),
472 filesystem_uuid character varying(255),
475 is_readable boolean DEFAULT true NOT NULL,
476 is_writable boolean DEFAULT true NOT NULL,
477 last_read_at timestamp without time zone,
478 last_write_at timestamp without time zone,
479 last_ping_at timestamp without time zone,
480 created_at timestamp without time zone NOT NULL,
481 updated_at timestamp without time zone NOT NULL,
482 keep_service_uuid character varying(255)
487 -- Name: keep_disks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
490 CREATE SEQUENCE keep_disks_id_seq
499 -- Name: keep_disks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
502 ALTER SEQUENCE keep_disks_id_seq OWNED BY keep_disks.id;
506 -- Name: keep_services; Type: TABLE; Schema: public; Owner: -; Tablespace:
509 CREATE TABLE keep_services (
511 uuid character varying(255) NOT NULL,
512 owner_uuid character varying(255) NOT NULL,
513 modified_by_client_uuid character varying(255),
514 modified_by_user_uuid character varying(255),
515 modified_at timestamp without time zone,
516 service_host character varying(255),
517 service_port integer,
518 service_ssl_flag boolean,
519 service_type character varying(255),
520 created_at timestamp without time zone NOT NULL,
521 updated_at timestamp without time zone NOT NULL
526 -- Name: keep_services_id_seq; Type: SEQUENCE; Schema: public; Owner: -
529 CREATE SEQUENCE keep_services_id_seq
538 -- Name: keep_services_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
541 ALTER SEQUENCE keep_services_id_seq OWNED BY keep_services.id;
545 -- Name: links; Type: TABLE; Schema: public; Owner: -; Tablespace:
550 uuid character varying(255),
551 owner_uuid character varying(255),
552 created_at timestamp without time zone NOT NULL,
553 modified_by_client_uuid character varying(255),
554 modified_by_user_uuid character varying(255),
555 modified_at timestamp without time zone,
556 tail_uuid character varying(255),
557 link_class character varying(255),
558 name character varying(255),
559 head_uuid character varying(255),
561 updated_at timestamp without time zone NOT NULL
566 -- Name: links_id_seq; Type: SEQUENCE; Schema: public; Owner: -
569 CREATE SEQUENCE links_id_seq
578 -- Name: links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
581 ALTER SEQUENCE links_id_seq OWNED BY links.id;
585 -- Name: logs; Type: TABLE; Schema: public; Owner: -; Tablespace:
590 uuid character varying(255),
591 owner_uuid character varying(255),
592 modified_by_client_uuid character varying(255),
593 modified_by_user_uuid character varying(255),
594 object_uuid character varying(255),
595 event_at timestamp without time zone,
596 event_type character varying(255),
599 created_at timestamp without time zone NOT NULL,
600 updated_at timestamp without time zone NOT NULL,
601 modified_at timestamp without time zone,
602 object_owner_uuid character varying(255)
607 -- Name: logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
610 CREATE SEQUENCE logs_id_seq
619 -- Name: logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
622 ALTER SEQUENCE logs_id_seq OWNED BY logs.id;
626 -- Name: nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
631 uuid character varying(255),
632 owner_uuid character varying(255),
633 created_at timestamp without time zone NOT NULL,
634 modified_by_client_uuid character varying(255),
635 modified_by_user_uuid character varying(255),
636 modified_at timestamp without time zone,
638 hostname character varying(255),
639 domain character varying(255),
640 ip_address character varying(255),
641 first_ping_at timestamp without time zone,
642 last_ping_at timestamp without time zone,
644 updated_at timestamp without time zone NOT NULL,
646 job_uuid character varying(255)
651 -- Name: nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
654 CREATE SEQUENCE nodes_id_seq
663 -- Name: nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
666 ALTER SEQUENCE nodes_id_seq OWNED BY nodes.id;
670 -- Name: pipeline_instances; Type: TABLE; Schema: public; Owner: -; Tablespace:
673 CREATE TABLE pipeline_instances (
675 uuid character varying(255),
676 owner_uuid character varying(255),
677 created_at timestamp without time zone NOT NULL,
678 modified_by_client_uuid character varying(255),
679 modified_by_user_uuid character varying(255),
680 modified_at timestamp without time zone,
681 pipeline_template_uuid character varying(255),
682 name character varying(255),
684 updated_at timestamp without time zone NOT NULL,
686 state character varying(255),
687 components_summary text,
688 started_at timestamp without time zone,
689 finished_at timestamp without time zone,
690 description character varying(524288)
695 -- Name: pipeline_instances_id_seq; Type: SEQUENCE; Schema: public; Owner: -
698 CREATE SEQUENCE pipeline_instances_id_seq
707 -- Name: pipeline_instances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
710 ALTER SEQUENCE pipeline_instances_id_seq OWNED BY pipeline_instances.id;
714 -- Name: pipeline_templates; Type: TABLE; Schema: public; Owner: -; Tablespace:
717 CREATE TABLE pipeline_templates (
719 uuid character varying(255),
720 owner_uuid character varying(255),
721 created_at timestamp without time zone NOT NULL,
722 modified_by_client_uuid character varying(255),
723 modified_by_user_uuid character varying(255),
724 modified_at timestamp without time zone,
725 name character varying(255),
727 updated_at timestamp without time zone NOT NULL,
728 description character varying(524288)
733 -- Name: pipeline_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
736 CREATE SEQUENCE pipeline_templates_id_seq
745 -- Name: pipeline_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
748 ALTER SEQUENCE pipeline_templates_id_seq OWNED BY pipeline_templates.id;
752 -- Name: repositories; Type: TABLE; Schema: public; Owner: -; Tablespace:
755 CREATE TABLE repositories (
757 uuid character varying(255) NOT NULL,
758 owner_uuid character varying(255) NOT NULL,
759 modified_by_client_uuid character varying(255),
760 modified_by_user_uuid character varying(255),
761 modified_at timestamp without time zone,
762 name character varying(255),
763 fetch_url character varying(255),
764 push_url character varying(255),
765 created_at timestamp without time zone NOT NULL,
766 updated_at timestamp without time zone NOT NULL
771 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
774 CREATE SEQUENCE repositories_id_seq
783 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
786 ALTER SEQUENCE repositories_id_seq OWNED BY repositories.id;
790 -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -; Tablespace:
793 CREATE TABLE schema_migrations (
794 version character varying(255) NOT NULL
799 -- Name: specimens; Type: TABLE; Schema: public; Owner: -; Tablespace:
802 CREATE TABLE specimens (
804 uuid character varying(255),
805 owner_uuid character varying(255),
806 created_at timestamp without time zone NOT NULL,
807 modified_by_client_uuid character varying(255),
808 modified_by_user_uuid character varying(255),
809 modified_at timestamp without time zone,
810 material character varying(255),
811 updated_at timestamp without time zone NOT NULL,
817 -- Name: specimens_id_seq; Type: SEQUENCE; Schema: public; Owner: -
820 CREATE SEQUENCE specimens_id_seq
829 -- Name: specimens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
832 ALTER SEQUENCE specimens_id_seq OWNED BY specimens.id;
836 -- Name: traits; Type: TABLE; Schema: public; Owner: -; Tablespace:
839 CREATE TABLE traits (
841 uuid character varying(255) NOT NULL,
842 owner_uuid character varying(255) NOT NULL,
843 modified_by_client_uuid character varying(255),
844 modified_by_user_uuid character varying(255),
845 modified_at timestamp without time zone,
846 name character varying(255),
848 created_at timestamp without time zone NOT NULL,
849 updated_at timestamp without time zone NOT NULL
854 -- Name: traits_id_seq; Type: SEQUENCE; Schema: public; Owner: -
857 CREATE SEQUENCE traits_id_seq
866 -- Name: traits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
869 ALTER SEQUENCE traits_id_seq OWNED BY traits.id;
873 -- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
878 uuid character varying(255),
879 owner_uuid character varying(255) NOT NULL,
880 created_at timestamp without time zone NOT NULL,
881 modified_by_client_uuid character varying(255),
882 modified_by_user_uuid character varying(255),
883 modified_at timestamp without time zone,
884 email character varying(255),
885 first_name character varying(255),
886 last_name character varying(255),
887 identity_url character varying(255),
890 updated_at timestamp without time zone NOT NULL,
891 default_owner_uuid character varying(255),
892 is_active boolean DEFAULT false,
893 username character varying(255)
898 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
901 CREATE SEQUENCE users_id_seq
910 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
913 ALTER SEQUENCE users_id_seq OWNED BY users.id;
917 -- Name: virtual_machines; Type: TABLE; Schema: public; Owner: -; Tablespace:
920 CREATE TABLE virtual_machines (
922 uuid character varying(255) NOT NULL,
923 owner_uuid character varying(255) NOT NULL,
924 modified_by_client_uuid character varying(255),
925 modified_by_user_uuid character varying(255),
926 modified_at timestamp without time zone,
927 hostname character varying(255),
928 created_at timestamp without time zone NOT NULL,
929 updated_at timestamp without time zone NOT NULL
934 -- Name: virtual_machines_id_seq; Type: SEQUENCE; Schema: public; Owner: -
937 CREATE SEQUENCE virtual_machines_id_seq
946 -- Name: virtual_machines_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
949 ALTER SEQUENCE virtual_machines_id_seq OWNED BY virtual_machines.id;
953 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
956 ALTER TABLE ONLY api_client_authorizations ALTER COLUMN id SET DEFAULT nextval('api_client_authorizations_id_seq'::regclass);
960 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
963 ALTER TABLE ONLY api_clients ALTER COLUMN id SET DEFAULT nextval('api_clients_id_seq'::regclass);
967 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
970 ALTER TABLE ONLY authorized_keys ALTER COLUMN id SET DEFAULT nextval('authorized_keys_id_seq'::regclass);
974 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
977 ALTER TABLE ONLY collections ALTER COLUMN id SET DEFAULT nextval('collections_id_seq'::regclass);
981 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
984 ALTER TABLE ONLY commit_ancestors ALTER COLUMN id SET DEFAULT nextval('commit_ancestors_id_seq'::regclass);
988 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
991 ALTER TABLE ONLY commits ALTER COLUMN id SET DEFAULT nextval('commits_id_seq'::regclass);
995 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
998 ALTER TABLE ONLY groups ALTER COLUMN id SET DEFAULT nextval('groups_id_seq'::regclass);
1002 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1005 ALTER TABLE ONLY humans ALTER COLUMN id SET DEFAULT nextval('humans_id_seq'::regclass);
1009 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1012 ALTER TABLE ONLY job_tasks ALTER COLUMN id SET DEFAULT nextval('job_tasks_id_seq'::regclass);
1016 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1019 ALTER TABLE ONLY jobs ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
1023 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1026 ALTER TABLE ONLY keep_disks ALTER COLUMN id SET DEFAULT nextval('keep_disks_id_seq'::regclass);
1030 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1033 ALTER TABLE ONLY keep_services ALTER COLUMN id SET DEFAULT nextval('keep_services_id_seq'::regclass);
1037 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1040 ALTER TABLE ONLY links ALTER COLUMN id SET DEFAULT nextval('links_id_seq'::regclass);
1044 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1047 ALTER TABLE ONLY logs ALTER COLUMN id SET DEFAULT nextval('logs_id_seq'::regclass);
1051 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1054 ALTER TABLE ONLY nodes ALTER COLUMN id SET DEFAULT nextval('nodes_id_seq'::regclass);
1058 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1061 ALTER TABLE ONLY pipeline_instances ALTER COLUMN id SET DEFAULT nextval('pipeline_instances_id_seq'::regclass);
1065 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1068 ALTER TABLE ONLY pipeline_templates ALTER COLUMN id SET DEFAULT nextval('pipeline_templates_id_seq'::regclass);
1072 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1075 ALTER TABLE ONLY repositories ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
1079 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1082 ALTER TABLE ONLY specimens ALTER COLUMN id SET DEFAULT nextval('specimens_id_seq'::regclass);
1086 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1089 ALTER TABLE ONLY traits ALTER COLUMN id SET DEFAULT nextval('traits_id_seq'::regclass);
1093 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1096 ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
1100 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1103 ALTER TABLE ONLY virtual_machines ALTER COLUMN id SET DEFAULT nextval('virtual_machines_id_seq'::regclass);
1107 -- Name: api_client_authorizations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1110 ALTER TABLE ONLY api_client_authorizations
1111 ADD CONSTRAINT api_client_authorizations_pkey PRIMARY KEY (id);
1115 -- Name: api_clients_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1118 ALTER TABLE ONLY api_clients
1119 ADD CONSTRAINT api_clients_pkey PRIMARY KEY (id);
1123 -- Name: authorized_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1126 ALTER TABLE ONLY authorized_keys
1127 ADD CONSTRAINT authorized_keys_pkey PRIMARY KEY (id);
1131 -- Name: collections_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1134 ALTER TABLE ONLY collections
1135 ADD CONSTRAINT collections_pkey PRIMARY KEY (id);
1139 -- Name: commit_ancestors_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1142 ALTER TABLE ONLY commit_ancestors
1143 ADD CONSTRAINT commit_ancestors_pkey PRIMARY KEY (id);
1147 -- Name: commits_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1150 ALTER TABLE ONLY commits
1151 ADD CONSTRAINT commits_pkey PRIMARY KEY (id);
1155 -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1158 ALTER TABLE ONLY groups
1159 ADD CONSTRAINT groups_pkey PRIMARY KEY (id);
1163 -- Name: humans_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1166 ALTER TABLE ONLY humans
1167 ADD CONSTRAINT humans_pkey PRIMARY KEY (id);
1171 -- Name: job_tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1174 ALTER TABLE ONLY job_tasks
1175 ADD CONSTRAINT job_tasks_pkey PRIMARY KEY (id);
1179 -- Name: jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1182 ALTER TABLE ONLY jobs
1183 ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);
1187 -- Name: keep_disks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1190 ALTER TABLE ONLY keep_disks
1191 ADD CONSTRAINT keep_disks_pkey PRIMARY KEY (id);
1195 -- Name: keep_services_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1198 ALTER TABLE ONLY keep_services
1199 ADD CONSTRAINT keep_services_pkey PRIMARY KEY (id);
1203 -- Name: links_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1206 ALTER TABLE ONLY links
1207 ADD CONSTRAINT links_pkey PRIMARY KEY (id);
1211 -- Name: logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1214 ALTER TABLE ONLY logs
1215 ADD CONSTRAINT logs_pkey PRIMARY KEY (id);
1219 -- Name: nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1222 ALTER TABLE ONLY nodes
1223 ADD CONSTRAINT nodes_pkey PRIMARY KEY (id);
1227 -- Name: pipeline_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1230 ALTER TABLE ONLY pipeline_instances
1231 ADD CONSTRAINT pipeline_instances_pkey PRIMARY KEY (id);
1235 -- Name: pipeline_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1238 ALTER TABLE ONLY pipeline_templates
1239 ADD CONSTRAINT pipeline_templates_pkey PRIMARY KEY (id);
1243 -- Name: repositories_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1246 ALTER TABLE ONLY repositories
1247 ADD CONSTRAINT repositories_pkey PRIMARY KEY (id);
1251 -- Name: specimens_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1254 ALTER TABLE ONLY specimens
1255 ADD CONSTRAINT specimens_pkey PRIMARY KEY (id);
1259 -- Name: traits_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1262 ALTER TABLE ONLY traits
1263 ADD CONSTRAINT traits_pkey PRIMARY KEY (id);
1267 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1270 ALTER TABLE ONLY users
1271 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
1275 -- Name: virtual_machines_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1278 ALTER TABLE ONLY virtual_machines
1279 ADD CONSTRAINT virtual_machines_pkey PRIMARY KEY (id);
1283 -- Name: api_client_authorizations_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
1286 CREATE INDEX api_client_authorizations_search_index ON api_client_authorizations USING btree (api_token, created_by_ip_address, last_used_by_ip_address, default_owner_uuid);
1290 -- Name: api_clients_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
1293 CREATE INDEX api_clients_search_index ON api_clients USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, url_prefix);
1297 -- Name: authorized_keys_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
1300 CREATE INDEX authorized_keys_search_index ON authorized_keys USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, key_type, authorized_user_uuid);
1304 -- Name: collection_owner_uuid_name_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
1307 CREATE UNIQUE INDEX collection_owner_uuid_name_unique ON collections USING btree (owner_uuid, name) WHERE (expires_at IS NULL);
1311 -- Name: collections_full_text_search_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1314 CREATE INDEX collections_full_text_search_idx ON collections USING gin (to_tsvector('english'::regconfig, (((((((((((((((((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) || (COALESCE(file_names, ''::character varying))::text)));
1318 -- Name: collections_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
1321 CREATE INDEX collections_search_index ON collections USING btree (owner_uuid, modified_by_client_uuid, modified_by_user_uuid, portable_data_hash, uuid, name, file_names);
1325 -- Name: groups_full_text_search_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1328 CREATE INDEX groups_full_text_search_idx ON groups USING gin (to_tsvector('english'::regconfig, (((((((((((((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)));
1332 -- Name: groups_owner_uuid_name_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
1335 CREATE UNIQUE INDEX groups_owner_uuid_name_unique ON groups USING btree (owner_uuid, name);
1339 -- Name: groups_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
1342 CREATE INDEX groups_search_index ON groups USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, group_class);
1346 -- Name: humans_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
1349 CREATE INDEX humans_search_index ON humans USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid);
1353 -- Name: index_api_client_authorizations_on_api_client_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1356 CREATE INDEX index_api_client_authorizations_on_api_client_id ON api_client_authorizations USING btree (api_client_id);
1360 -- Name: index_api_client_authorizations_on_api_token; Type: INDEX; Schema: public; Owner: -; Tablespace:
1363 CREATE UNIQUE INDEX index_api_client_authorizations_on_api_token ON api_client_authorizations USING btree (api_token);
1367 -- Name: index_api_client_authorizations_on_expires_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1370 CREATE INDEX index_api_client_authorizations_on_expires_at ON api_client_authorizations USING btree (expires_at);
1374 -- Name: index_api_client_authorizations_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1377 CREATE INDEX index_api_client_authorizations_on_user_id ON api_client_authorizations USING btree (user_id);
1381 -- Name: index_api_clients_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1384 CREATE INDEX index_api_clients_on_created_at ON api_clients USING btree (created_at);
1388 -- Name: index_api_clients_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1391 CREATE INDEX index_api_clients_on_modified_at ON api_clients USING btree (modified_at);
1395 -- Name: index_api_clients_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1398 CREATE INDEX index_api_clients_on_owner_uuid ON api_clients USING btree (owner_uuid);
1402 -- Name: index_api_clients_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1405 CREATE UNIQUE INDEX index_api_clients_on_uuid ON api_clients USING btree (uuid);
1409 -- Name: index_authkeys_on_user_and_expires_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1412 CREATE INDEX index_authkeys_on_user_and_expires_at ON authorized_keys USING btree (authorized_user_uuid, expires_at);
1416 -- Name: index_authorized_keys_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1419 CREATE INDEX index_authorized_keys_on_owner_uuid ON authorized_keys USING btree (owner_uuid);
1423 -- Name: index_authorized_keys_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1426 CREATE UNIQUE INDEX index_authorized_keys_on_uuid ON authorized_keys USING btree (uuid);
1430 -- Name: index_collections_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1433 CREATE INDEX index_collections_on_created_at ON collections USING btree (created_at);
1437 -- Name: index_collections_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1440 CREATE INDEX index_collections_on_modified_at ON collections USING btree (modified_at);
1444 -- Name: index_collections_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1447 CREATE INDEX index_collections_on_owner_uuid ON collections USING btree (owner_uuid);
1451 -- Name: index_collections_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1454 CREATE UNIQUE INDEX index_collections_on_uuid ON collections USING btree (uuid);
1458 -- Name: index_commit_ancestors_on_descendant_and_ancestor; Type: INDEX; Schema: public; Owner: -; Tablespace:
1461 CREATE UNIQUE INDEX index_commit_ancestors_on_descendant_and_ancestor ON commit_ancestors USING btree (descendant, ancestor);
1465 -- Name: index_commits_on_repository_name_and_sha1; Type: INDEX; Schema: public; Owner: -; Tablespace:
1468 CREATE UNIQUE INDEX index_commits_on_repository_name_and_sha1 ON commits USING btree (repository_name, sha1);
1472 -- Name: index_groups_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1475 CREATE INDEX index_groups_on_created_at ON groups USING btree (created_at);
1479 -- Name: index_groups_on_group_class; Type: INDEX; Schema: public; Owner: -; Tablespace:
1482 CREATE INDEX index_groups_on_group_class ON groups USING btree (group_class);
1486 -- Name: index_groups_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1489 CREATE INDEX index_groups_on_modified_at ON groups USING btree (modified_at);
1493 -- Name: index_groups_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1496 CREATE INDEX index_groups_on_owner_uuid ON groups USING btree (owner_uuid);
1500 -- Name: index_groups_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1503 CREATE UNIQUE INDEX index_groups_on_uuid ON groups USING btree (uuid);
1507 -- Name: index_humans_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1510 CREATE INDEX index_humans_on_owner_uuid ON humans USING btree (owner_uuid);
1514 -- Name: index_humans_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1517 CREATE UNIQUE INDEX index_humans_on_uuid ON humans USING btree (uuid);
1521 -- Name: index_job_tasks_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1524 CREATE INDEX index_job_tasks_on_created_at ON job_tasks USING btree (created_at);
1528 -- Name: index_job_tasks_on_job_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1531 CREATE INDEX index_job_tasks_on_job_uuid ON job_tasks USING btree (job_uuid);
1535 -- Name: index_job_tasks_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1538 CREATE INDEX index_job_tasks_on_modified_at ON job_tasks USING btree (modified_at);
1542 -- Name: index_job_tasks_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1545 CREATE INDEX index_job_tasks_on_owner_uuid ON job_tasks USING btree (owner_uuid);
1549 -- Name: index_job_tasks_on_sequence; Type: INDEX; Schema: public; Owner: -; Tablespace:
1552 CREATE INDEX index_job_tasks_on_sequence ON job_tasks USING btree (sequence);
1556 -- Name: index_job_tasks_on_success; Type: INDEX; Schema: public; Owner: -; Tablespace:
1559 CREATE INDEX index_job_tasks_on_success ON job_tasks USING btree (success);
1563 -- Name: index_job_tasks_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1566 CREATE UNIQUE INDEX index_job_tasks_on_uuid ON job_tasks USING btree (uuid);
1570 -- Name: index_jobs_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1573 CREATE INDEX index_jobs_on_created_at ON jobs USING btree (created_at);
1577 -- Name: index_jobs_on_finished_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1580 CREATE INDEX index_jobs_on_finished_at ON jobs USING btree (finished_at);
1584 -- Name: index_jobs_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1587 CREATE INDEX index_jobs_on_modified_at ON jobs USING btree (modified_at);
1591 -- Name: index_jobs_on_output; Type: INDEX; Schema: public; Owner: -; Tablespace:
1594 CREATE INDEX index_jobs_on_output ON jobs USING btree (output);
1598 -- Name: index_jobs_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1601 CREATE INDEX index_jobs_on_owner_uuid ON jobs USING btree (owner_uuid);
1605 -- Name: index_jobs_on_script; Type: INDEX; Schema: public; Owner: -; Tablespace:
1608 CREATE INDEX index_jobs_on_script ON jobs USING btree (script);
1612 -- Name: index_jobs_on_started_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1615 CREATE INDEX index_jobs_on_started_at ON jobs USING btree (started_at);
1619 -- Name: index_jobs_on_submit_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1622 CREATE UNIQUE INDEX index_jobs_on_submit_id ON jobs USING btree (submit_id);
1626 -- Name: index_jobs_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1629 CREATE UNIQUE INDEX index_jobs_on_uuid ON jobs USING btree (uuid);
1633 -- Name: index_keep_disks_on_filesystem_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1636 CREATE INDEX index_keep_disks_on_filesystem_uuid ON keep_disks USING btree (filesystem_uuid);
1640 -- Name: index_keep_disks_on_last_ping_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1643 CREATE INDEX index_keep_disks_on_last_ping_at ON keep_disks USING btree (last_ping_at);
1647 -- Name: index_keep_disks_on_node_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1650 CREATE INDEX index_keep_disks_on_node_uuid ON keep_disks USING btree (node_uuid);
1654 -- Name: index_keep_disks_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1657 CREATE INDEX index_keep_disks_on_owner_uuid ON keep_disks USING btree (owner_uuid);
1661 -- Name: index_keep_disks_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1664 CREATE UNIQUE INDEX index_keep_disks_on_uuid ON keep_disks USING btree (uuid);
1668 -- Name: index_keep_services_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1671 CREATE INDEX index_keep_services_on_owner_uuid ON keep_services USING btree (owner_uuid);
1675 -- Name: index_keep_services_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1678 CREATE UNIQUE INDEX index_keep_services_on_uuid ON keep_services USING btree (uuid);
1682 -- Name: index_links_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1685 CREATE INDEX index_links_on_created_at ON links USING btree (created_at);
1689 -- Name: index_links_on_head_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1692 CREATE INDEX index_links_on_head_uuid ON links USING btree (head_uuid);
1696 -- Name: index_links_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1699 CREATE INDEX index_links_on_modified_at ON links USING btree (modified_at);
1703 -- Name: index_links_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1706 CREATE INDEX index_links_on_owner_uuid ON links USING btree (owner_uuid);
1710 -- Name: index_links_on_tail_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1713 CREATE INDEX index_links_on_tail_uuid ON links USING btree (tail_uuid);
1717 -- Name: index_links_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1720 CREATE UNIQUE INDEX index_links_on_uuid ON links USING btree (uuid);
1724 -- Name: index_logs_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1727 CREATE INDEX index_logs_on_created_at ON logs USING btree (created_at);
1731 -- Name: index_logs_on_event_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1734 CREATE INDEX index_logs_on_event_at ON logs USING btree (event_at);
1738 -- Name: index_logs_on_event_type; Type: INDEX; Schema: public; Owner: -; Tablespace:
1741 CREATE INDEX index_logs_on_event_type ON logs USING btree (event_type);
1745 -- Name: index_logs_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1748 CREATE INDEX index_logs_on_modified_at ON logs USING btree (modified_at);
1752 -- Name: index_logs_on_object_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1755 CREATE INDEX index_logs_on_object_uuid ON logs USING btree (object_uuid);
1759 -- Name: index_logs_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1762 CREATE INDEX index_logs_on_owner_uuid ON logs USING btree (owner_uuid);
1766 -- Name: index_logs_on_summary; Type: INDEX; Schema: public; Owner: -; Tablespace:
1769 CREATE INDEX index_logs_on_summary ON logs USING btree (summary);
1773 -- Name: index_logs_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1776 CREATE UNIQUE INDEX index_logs_on_uuid ON logs USING btree (uuid);
1780 -- Name: index_nodes_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1783 CREATE INDEX index_nodes_on_created_at ON nodes USING btree (created_at);
1787 -- Name: index_nodes_on_hostname; Type: INDEX; Schema: public; Owner: -; Tablespace:
1790 CREATE INDEX index_nodes_on_hostname ON nodes USING btree (hostname);
1794 -- Name: index_nodes_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1797 CREATE INDEX index_nodes_on_modified_at ON nodes USING btree (modified_at);
1801 -- Name: index_nodes_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1804 CREATE INDEX index_nodes_on_owner_uuid ON nodes USING btree (owner_uuid);
1808 -- Name: index_nodes_on_slot_number; Type: INDEX; Schema: public; Owner: -; Tablespace:
1811 CREATE UNIQUE INDEX index_nodes_on_slot_number ON nodes USING btree (slot_number);
1815 -- Name: index_nodes_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1818 CREATE UNIQUE INDEX index_nodes_on_uuid ON nodes USING btree (uuid);
1822 -- Name: index_pipeline_instances_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1825 CREATE INDEX index_pipeline_instances_on_created_at ON pipeline_instances USING btree (created_at);
1829 -- Name: index_pipeline_instances_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1832 CREATE INDEX index_pipeline_instances_on_modified_at ON pipeline_instances USING btree (modified_at);
1836 -- Name: index_pipeline_instances_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1839 CREATE INDEX index_pipeline_instances_on_owner_uuid ON pipeline_instances USING btree (owner_uuid);
1843 -- Name: index_pipeline_instances_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1846 CREATE UNIQUE INDEX index_pipeline_instances_on_uuid ON pipeline_instances USING btree (uuid);
1850 -- Name: index_pipeline_templates_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1853 CREATE INDEX index_pipeline_templates_on_created_at ON pipeline_templates USING btree (created_at);
1857 -- Name: index_pipeline_templates_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1860 CREATE INDEX index_pipeline_templates_on_modified_at ON pipeline_templates USING btree (modified_at);
1864 -- Name: index_pipeline_templates_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1867 CREATE INDEX index_pipeline_templates_on_owner_uuid ON pipeline_templates USING btree (owner_uuid);
1871 -- Name: index_pipeline_templates_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1874 CREATE UNIQUE INDEX index_pipeline_templates_on_uuid ON pipeline_templates USING btree (uuid);
1878 -- Name: index_repositories_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
1881 CREATE UNIQUE INDEX index_repositories_on_name ON repositories USING btree (name);
1885 -- Name: index_repositories_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1888 CREATE INDEX index_repositories_on_owner_uuid ON repositories USING btree (owner_uuid);
1892 -- Name: index_repositories_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1895 CREATE UNIQUE INDEX index_repositories_on_uuid ON repositories USING btree (uuid);
1899 -- Name: index_specimens_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1902 CREATE INDEX index_specimens_on_created_at ON specimens USING btree (created_at);
1906 -- Name: index_specimens_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1909 CREATE INDEX index_specimens_on_modified_at ON specimens USING btree (modified_at);
1913 -- Name: index_specimens_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1916 CREATE INDEX index_specimens_on_owner_uuid ON specimens USING btree (owner_uuid);
1920 -- Name: index_specimens_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1923 CREATE UNIQUE INDEX index_specimens_on_uuid ON specimens USING btree (uuid);
1927 -- Name: index_traits_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
1930 CREATE INDEX index_traits_on_name ON traits USING btree (name);
1934 -- Name: index_traits_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1937 CREATE INDEX index_traits_on_owner_uuid ON traits USING btree (owner_uuid);
1941 -- Name: index_traits_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1944 CREATE UNIQUE INDEX index_traits_on_uuid ON traits USING btree (uuid);
1948 -- Name: index_users_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1951 CREATE INDEX index_users_on_created_at ON users USING btree (created_at);
1955 -- Name: index_users_on_modified_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1958 CREATE INDEX index_users_on_modified_at ON users USING btree (modified_at);
1962 -- Name: index_users_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1965 CREATE INDEX index_users_on_owner_uuid ON users USING btree (owner_uuid);
1969 -- Name: index_users_on_username; Type: INDEX; Schema: public; Owner: -; Tablespace:
1972 CREATE UNIQUE INDEX index_users_on_username ON users USING btree (username);
1976 -- Name: index_users_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1979 CREATE UNIQUE INDEX index_users_on_uuid ON users USING btree (uuid);
1983 -- Name: index_virtual_machines_on_hostname; Type: INDEX; Schema: public; Owner: -; Tablespace:
1986 CREATE INDEX index_virtual_machines_on_hostname ON virtual_machines USING btree (hostname);
1990 -- Name: index_virtual_machines_on_owner_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
1993 CREATE INDEX index_virtual_machines_on_owner_uuid ON virtual_machines USING btree (owner_uuid);
1997 -- Name: index_virtual_machines_on_uuid; Type: INDEX; Schema: public; Owner: -; Tablespace:
2000 CREATE UNIQUE INDEX index_virtual_machines_on_uuid ON virtual_machines USING btree (uuid);
2004 -- Name: job_tasks_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2007 CREATE INDEX job_tasks_search_index ON job_tasks USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, job_uuid, created_by_job_task_uuid);
2011 -- Name: jobs_full_text_search_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2014 CREATE INDEX jobs_full_text_search_idx ON jobs USING gin (to_tsvector('english'::regconfig, (((((((((((((((((((((((((((((((((((((((((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)));
2018 -- Name: jobs_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2021 CREATE INDEX jobs_search_index ON jobs USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, submit_id, script, script_version, cancelled_by_client_uuid, cancelled_by_user_uuid, output, is_locked_by_uuid, log, repository, supplied_script_version, docker_image_locator, state, arvados_sdk_version);
2025 -- Name: keep_disks_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2028 CREATE INDEX keep_disks_search_index ON keep_disks USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, ping_secret, node_uuid, filesystem_uuid, keep_service_uuid);
2032 -- Name: keep_services_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2035 CREATE INDEX keep_services_search_index ON keep_services USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, service_host, service_type);
2039 -- Name: links_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2042 CREATE INDEX links_search_index ON links USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, tail_uuid, link_class, name, head_uuid);
2046 -- Name: links_tail_name_unique_if_link_class_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
2049 CREATE UNIQUE INDEX links_tail_name_unique_if_link_class_name ON links USING btree (tail_uuid, name) WHERE ((link_class)::text = 'name'::text);
2053 -- Name: logs_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2056 CREATE INDEX logs_search_index ON logs USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, object_uuid, event_type, object_owner_uuid);
2060 -- Name: nodes_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2063 CREATE INDEX nodes_search_index ON nodes USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, hostname, domain, ip_address, job_uuid);
2067 -- Name: pipeline_instances_full_text_search_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2070 CREATE INDEX pipeline_instances_full_text_search_idx ON pipeline_instances USING gin (to_tsvector('english'::regconfig, (((((((((((((((((((((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)));
2074 -- Name: pipeline_instances_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2077 CREATE INDEX pipeline_instances_search_index ON pipeline_instances USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, pipeline_template_uuid, name, state);
2081 -- Name: pipeline_template_owner_uuid_name_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
2084 CREATE UNIQUE INDEX pipeline_template_owner_uuid_name_unique ON pipeline_templates USING btree (owner_uuid, name);
2088 -- Name: pipeline_templates_full_text_search_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2091 CREATE INDEX pipeline_templates_full_text_search_idx ON pipeline_templates USING gin (to_tsvector('english'::regconfig, (((((((((((((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)));
2095 -- Name: pipeline_templates_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2098 CREATE INDEX pipeline_templates_search_index ON pipeline_templates USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2102 -- Name: repositories_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2105 CREATE INDEX repositories_search_index ON repositories USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name, fetch_url, push_url);
2109 -- Name: specimens_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2112 CREATE INDEX specimens_search_index ON specimens USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, material);
2116 -- Name: traits_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2119 CREATE INDEX traits_search_index ON traits USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, name);
2123 -- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -; Tablespace:
2126 CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);
2130 -- Name: users_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2133 CREATE INDEX users_search_index ON users USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, email, first_name, last_name, identity_url, default_owner_uuid, username);
2137 -- Name: virtual_machines_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2140 CREATE INDEX virtual_machines_search_index ON virtual_machines USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, hostname);
2144 -- PostgreSQL database dump complete
2147 SET search_path TO "$user",public;
2149 INSERT INTO schema_migrations (version) VALUES ('20121016005009');
2151 INSERT INTO schema_migrations (version) VALUES ('20130105203021');
2153 INSERT INTO schema_migrations (version) VALUES ('20130105224358');
2155 INSERT INTO schema_migrations (version) VALUES ('20130105224618');
2157 INSERT INTO schema_migrations (version) VALUES ('20130107181109');
2159 INSERT INTO schema_migrations (version) VALUES ('20130107212832');
2161 INSERT INTO schema_migrations (version) VALUES ('20130109175700');
2163 INSERT INTO schema_migrations (version) VALUES ('20130109220548');
2165 INSERT INTO schema_migrations (version) VALUES ('20130113214204');
2167 INSERT INTO schema_migrations (version) VALUES ('20130116024233');
2169 INSERT INTO schema_migrations (version) VALUES ('20130116215213');
2171 INSERT INTO schema_migrations (version) VALUES ('20130118002239');
2173 INSERT INTO schema_migrations (version) VALUES ('20130122020042');
2175 INSERT INTO schema_migrations (version) VALUES ('20130122201442');
2177 INSERT INTO schema_migrations (version) VALUES ('20130122221616');
2179 INSERT INTO schema_migrations (version) VALUES ('20130123174514');
2181 INSERT INTO schema_migrations (version) VALUES ('20130123180224');
2183 INSERT INTO schema_migrations (version) VALUES ('20130123180228');
2185 INSERT INTO schema_migrations (version) VALUES ('20130125220425');
2187 INSERT INTO schema_migrations (version) VALUES ('20130128202518');
2189 INSERT INTO schema_migrations (version) VALUES ('20130128231343');
2191 INSERT INTO schema_migrations (version) VALUES ('20130130205749');
2193 INSERT INTO schema_migrations (version) VALUES ('20130203104818');
2195 INSERT INTO schema_migrations (version) VALUES ('20130203104824');
2197 INSERT INTO schema_migrations (version) VALUES ('20130203115329');
2199 INSERT INTO schema_migrations (version) VALUES ('20130207195855');
2201 INSERT INTO schema_migrations (version) VALUES ('20130218181504');
2203 INSERT INTO schema_migrations (version) VALUES ('20130226170000');
2205 INSERT INTO schema_migrations (version) VALUES ('20130313175417');
2207 INSERT INTO schema_migrations (version) VALUES ('20130315155820');
2209 INSERT INTO schema_migrations (version) VALUES ('20130315183626');
2211 INSERT INTO schema_migrations (version) VALUES ('20130315213205');
2213 INSERT INTO schema_migrations (version) VALUES ('20130318002138');
2215 INSERT INTO schema_migrations (version) VALUES ('20130319165853');
2217 INSERT INTO schema_migrations (version) VALUES ('20130319180730');
2219 INSERT INTO schema_migrations (version) VALUES ('20130319194637');
2221 INSERT INTO schema_migrations (version) VALUES ('20130319201431');
2223 INSERT INTO schema_migrations (version) VALUES ('20130319235957');
2225 INSERT INTO schema_migrations (version) VALUES ('20130320000107');
2227 INSERT INTO schema_migrations (version) VALUES ('20130326173804');
2229 INSERT INTO schema_migrations (version) VALUES ('20130326182917');
2231 INSERT INTO schema_migrations (version) VALUES ('20130415020241');
2233 INSERT INTO schema_migrations (version) VALUES ('20130425024459');
2235 INSERT INTO schema_migrations (version) VALUES ('20130425214427');
2237 INSERT INTO schema_migrations (version) VALUES ('20130523060112');
2239 INSERT INTO schema_migrations (version) VALUES ('20130523060213');
2241 INSERT INTO schema_migrations (version) VALUES ('20130524042319');
2243 INSERT INTO schema_migrations (version) VALUES ('20130528134100');
2245 INSERT INTO schema_migrations (version) VALUES ('20130606183519');
2247 INSERT INTO schema_migrations (version) VALUES ('20130608053730');
2249 INSERT INTO schema_migrations (version) VALUES ('20130610202538');
2251 INSERT INTO schema_migrations (version) VALUES ('20130611163736');
2253 INSERT INTO schema_migrations (version) VALUES ('20130612042554');
2255 INSERT INTO schema_migrations (version) VALUES ('20130617150007');
2257 INSERT INTO schema_migrations (version) VALUES ('20130626002829');
2259 INSERT INTO schema_migrations (version) VALUES ('20130626022810');
2261 INSERT INTO schema_migrations (version) VALUES ('20130627154537');
2263 INSERT INTO schema_migrations (version) VALUES ('20130627184333');
2265 INSERT INTO schema_migrations (version) VALUES ('20130708163414');
2267 INSERT INTO schema_migrations (version) VALUES ('20130708182912');
2269 INSERT INTO schema_migrations (version) VALUES ('20130708185153');
2271 INSERT INTO schema_migrations (version) VALUES ('20130724153034');
2273 INSERT INTO schema_migrations (version) VALUES ('20131007180607');
2275 INSERT INTO schema_migrations (version) VALUES ('20140117231056');
2277 INSERT INTO schema_migrations (version) VALUES ('20140124222114');
2279 INSERT INTO schema_migrations (version) VALUES ('20140129184311');
2281 INSERT INTO schema_migrations (version) VALUES ('20140317135600');
2283 INSERT INTO schema_migrations (version) VALUES ('20140319160547');
2285 INSERT INTO schema_migrations (version) VALUES ('20140321191343');
2287 INSERT INTO schema_migrations (version) VALUES ('20140324024606');
2289 INSERT INTO schema_migrations (version) VALUES ('20140325175653');
2291 INSERT INTO schema_migrations (version) VALUES ('20140402001908');
2293 INSERT INTO schema_migrations (version) VALUES ('20140407184311');
2295 INSERT INTO schema_migrations (version) VALUES ('20140421140924');
2297 INSERT INTO schema_migrations (version) VALUES ('20140421151939');
2299 INSERT INTO schema_migrations (version) VALUES ('20140421151940');
2301 INSERT INTO schema_migrations (version) VALUES ('20140422011506');
2303 INSERT INTO schema_migrations (version) VALUES ('20140423132913');
2305 INSERT INTO schema_migrations (version) VALUES ('20140423133559');
2307 INSERT INTO schema_migrations (version) VALUES ('20140501165548');
2309 INSERT INTO schema_migrations (version) VALUES ('20140519205916');
2311 INSERT INTO schema_migrations (version) VALUES ('20140527152921');
2313 INSERT INTO schema_migrations (version) VALUES ('20140530200539');
2315 INSERT INTO schema_migrations (version) VALUES ('20140601022548');
2317 INSERT INTO schema_migrations (version) VALUES ('20140602143352');
2319 INSERT INTO schema_migrations (version) VALUES ('20140607150616');
2321 INSERT INTO schema_migrations (version) VALUES ('20140611173003');
2323 INSERT INTO schema_migrations (version) VALUES ('20140627210837');
2325 INSERT INTO schema_migrations (version) VALUES ('20140709172343');
2327 INSERT INTO schema_migrations (version) VALUES ('20140714184006');
2329 INSERT INTO schema_migrations (version) VALUES ('20140811184643');
2331 INSERT INTO schema_migrations (version) VALUES ('20140817035914');
2333 INSERT INTO schema_migrations (version) VALUES ('20140818125735');
2335 INSERT INTO schema_migrations (version) VALUES ('20140826180337');
2337 INSERT INTO schema_migrations (version) VALUES ('20140828141043');
2339 INSERT INTO schema_migrations (version) VALUES ('20140909183946');
2341 INSERT INTO schema_migrations (version) VALUES ('20140911221252');
2343 INSERT INTO schema_migrations (version) VALUES ('20140918141529');
2345 INSERT INTO schema_migrations (version) VALUES ('20140918153541');
2347 INSERT INTO schema_migrations (version) VALUES ('20140918153705');
2349 INSERT INTO schema_migrations (version) VALUES ('20140924091559');
2351 INSERT INTO schema_migrations (version) VALUES ('20141111133038');
2353 INSERT INTO schema_migrations (version) VALUES ('20141208164553');
2355 INSERT INTO schema_migrations (version) VALUES ('20141208174553');
2357 INSERT INTO schema_migrations (version) VALUES ('20141208174653');
2359 INSERT INTO schema_migrations (version) VALUES ('20141208185217');
2361 INSERT INTO schema_migrations (version) VALUES ('20150122175935');
2363 INSERT INTO schema_migrations (version) VALUES ('20150123142953');
2365 INSERT INTO schema_migrations (version) VALUES ('20150203180223');
2367 INSERT INTO schema_migrations (version) VALUES ('20150206210804');
2369 INSERT INTO schema_migrations (version) VALUES ('20150206230342');
2371 INSERT INTO schema_migrations (version) VALUES ('20150216193428');
2373 INSERT INTO schema_migrations (version) VALUES ('20150303210106');
2375 INSERT INTO schema_migrations (version) VALUES ('20150312151136');
2377 INSERT INTO schema_migrations (version) VALUES ('20150317132720');