-- Name: pipe_pipelinedetails_path1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_path1_hash ON public.pipe_pipelinedetails USING hash (path);


--
-- Name: pipe_pipelinedetails_pipe_pipelinerepository_pipe_pipelin1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_pipe_pipelinerepository_pipe_pipelin1 ON public.pipe_pipelinedetails USING btree (pipe_pipelinerepository_pipe_pipelinerepository_id);


--
-- Name: pipe_pipelinedetails_pipe_pipelinerepository_pipe_pipelin1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_pipe_pipelinerepository_pipe_pipelin1_hash ON public.pipe_pipelinedetails USING hash (pipe_pipelinerepository_pipe_pipelinerepository_id);


--
-- Name: pipe_pipelinedetails_pipelinedetails_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_pipelinedetails_info1 ON public.pipe_pipelinedetails USING btree (pipelinedetails_info);


--
-- Name: pipe_pipelinedetails_pipelinedetails_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinedetails_pipelinedetails_info1_hash ON public.pipe_pipelinedetails USING hash (pipelinedetails_info);


--
-- Name: pipe_pipelinerepository_meta_data_activation_user_xdat_us1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinerepository_meta_data_activation_user_xdat_us1 ON public.pipe_pipelinerepository_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: pipe_pipelinerepository_meta_data_activation_user_xdat_us1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinerepository_meta_data_activation_user_xdat_us1_hash ON public.pipe_pipelinerepository_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: pipe_pipelinerepository_meta_data_insert_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinerepository_meta_data_insert_user_xdat_user_i1 ON public.pipe_pipelinerepository_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: pipe_pipelinerepository_meta_data_insert_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinerepository_meta_data_insert_user_xdat_user_i1_hash ON public.pipe_pipelinerepository_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: pipe_pipelinerepository_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinerepository_meta_data_meta_data_id1_hash ON public.pipe_pipelinerepository_meta_data USING hash (meta_data_id);


--
-- Name: pipe_pipelinerepository_pipe_pipelinerepository_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinerepository_pipe_pipelinerepository_id1_hash ON public.pipe_pipelinerepository USING hash (pipe_pipelinerepository_id);


--
-- Name: pipe_pipelinerepository_pipelinerepository_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinerepository_pipelinerepository_info1 ON public.pipe_pipelinerepository USING btree (pipelinerepository_info);


--
-- Name: pipe_pipelinerepository_pipelinerepository_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX pipe_pipelinerepository_pipelinerepository_info1_hash ON public.pipe_pipelinerepository USING hash (pipelinerepository_info);


--
-- Name: prov_process_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_process_meta_data_activation_user_xdat_user_id1 ON public.prov_process_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: prov_process_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_process_meta_data_activation_user_xdat_user_id1_hash ON public.prov_process_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: prov_process_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_process_meta_data_insert_user_xdat_user_id1 ON public.prov_process_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: prov_process_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_process_meta_data_insert_user_xdat_user_id1_hash ON public.prov_process_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: prov_process_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_process_meta_data_meta_data_id1_hash ON public.prov_process_meta_data USING hash (meta_data_id);


--
-- Name: prov_process_process_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_process_process_info1 ON public.prov_process USING btree (process_info);


--
-- Name: prov_process_process_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_process_process_info1_hash ON public.prov_process USING hash (process_info);


--
-- Name: prov_process_prov_process_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_process_prov_process_id1_hash ON public.prov_process USING hash (prov_process_id);


--
-- Name: prov_processstep_library_meta_data_activation_user_xdat_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_library_meta_data_activation_user_xdat_u1 ON public.prov_processstep_library_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: prov_processstep_library_meta_data_activation_user_xdat_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_library_meta_data_activation_user_xdat_u1_hash ON public.prov_processstep_library_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: prov_processstep_library_meta_data_insert_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_library_meta_data_insert_user_xdat_user_1 ON public.prov_processstep_library_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: prov_processstep_library_meta_data_insert_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_library_meta_data_insert_user_xdat_user_1_hash ON public.prov_processstep_library_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: prov_processstep_library_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_library_meta_data_meta_data_id1_hash ON public.prov_processstep_library_meta_data USING hash (meta_data_id);


--
-- Name: prov_processstep_library_processstep_library_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_library_processstep_library_info1 ON public.prov_processstep_library USING btree (processstep_library_info);


--
-- Name: prov_processstep_library_processstep_library_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_library_processstep_library_info1_hash ON public.prov_processstep_library USING hash (processstep_library_info);


--
-- Name: prov_processstep_library_prov_processstep_library_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_library_prov_processstep_library_id1_hash ON public.prov_processstep_library USING hash (prov_processstep_library_id);


--
-- Name: prov_processstep_library_prov_processstep_prov_processste1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_library_prov_processstep_prov_processste1 ON public.prov_processstep_library USING btree (prov_processstep_prov_processstep_id);


--
-- Name: prov_processstep_library_prov_processstep_prov_processste1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_library_prov_processstep_prov_processste1_hash ON public.prov_processstep_library USING hash (prov_processstep_prov_processstep_id);


--
-- Name: prov_processstep_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_meta_data_activation_user_xdat_user_id1 ON public.prov_processstep_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: prov_processstep_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_meta_data_activation_user_xdat_user_id1_hash ON public.prov_processstep_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: prov_processstep_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_meta_data_insert_user_xdat_user_id1 ON public.prov_processstep_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: prov_processstep_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_meta_data_insert_user_xdat_user_id1_hash ON public.prov_processstep_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: prov_processstep_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_meta_data_meta_data_id1_hash ON public.prov_processstep_meta_data USING hash (meta_data_id);


--
-- Name: prov_processstep_processstep_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_processstep_info1 ON public.prov_processstep USING btree (processstep_info);


--
-- Name: prov_processstep_processstep_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_processstep_info1_hash ON public.prov_processstep USING hash (processstep_info);


--
-- Name: prov_processstep_prov_process_prov_process_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_prov_process_prov_process_id1 ON public.prov_processstep USING btree (prov_process_prov_process_id);


--
-- Name: prov_processstep_prov_process_prov_process_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_prov_process_prov_process_id1_hash ON public.prov_processstep USING hash (prov_process_prov_process_id);


--
-- Name: prov_processstep_prov_processstep_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX prov_processstep_prov_processstep_id1_hash ON public.prov_processstep USING hash (prov_processstep_id);


--
-- Name: scr_screeningassessment_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningassessment_id1 ON public.scr_screeningassessment USING btree (id);


--
-- Name: scr_screeningassessment_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningassessment_id1_hash ON public.scr_screeningassessment USING hash (id);


--
-- Name: scr_screeningassessment_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningassessment_id2_hash ON public.scr_screeningassessment USING hash (id);


--
-- Name: scr_screeningassessment_meta_data_activation_user_xdat_us1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningassessment_meta_data_activation_user_xdat_us1 ON public.scr_screeningassessment_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: scr_screeningassessment_meta_data_activation_user_xdat_us1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningassessment_meta_data_activation_user_xdat_us1_hash ON public.scr_screeningassessment_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: scr_screeningassessment_meta_data_insert_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningassessment_meta_data_insert_user_xdat_user_i1 ON public.scr_screeningassessment_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: scr_screeningassessment_meta_data_insert_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningassessment_meta_data_insert_user_xdat_user_i1_hash ON public.scr_screeningassessment_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: scr_screeningassessment_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningassessment_meta_data_meta_data_id1_hash ON public.scr_screeningassessment_meta_data USING hash (meta_data_id);


--
-- Name: scr_screeningassessment_screeningassessment_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningassessment_screeningassessment_info1 ON public.scr_screeningassessment USING btree (screeningassessment_info);


--
-- Name: scr_screeningassessment_screeningassessment_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningassessment_screeningassessment_info1_hash ON public.scr_screeningassessment USING hash (screeningassessment_info);


--
-- Name: scr_screeningscandata_meta_data_activation_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningscandata_meta_data_activation_user_xdat_user1 ON public.scr_screeningscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: scr_screeningscandata_meta_data_activation_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningscandata_meta_data_activation_user_xdat_user1_hash ON public.scr_screeningscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: scr_screeningscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningscandata_meta_data_insert_user_xdat_user_id1 ON public.scr_screeningscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: scr_screeningscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningscandata_meta_data_insert_user_xdat_user_id1_hash ON public.scr_screeningscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: scr_screeningscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningscandata_meta_data_meta_data_id1_hash ON public.scr_screeningscandata_meta_data USING hash (meta_data_id);


--
-- Name: scr_screeningscandata_scans_scan_scr_screeningassessm_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningscandata_scans_scan_scr_screeningassessm_id1 ON public.scr_screeningscandata USING btree (scans_scan_scr_screeningassessm_id);


--
-- Name: scr_screeningscandata_scans_scan_scr_screeningassessm_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningscandata_scans_scan_scr_screeningassessm_id1_hash ON public.scr_screeningscandata USING hash (scans_scan_scr_screeningassessm_id);


--
-- Name: scr_screeningscandata_scr_screeningscandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningscandata_scr_screeningscandata_id1_hash ON public.scr_screeningscandata USING hash (scr_screeningscandata_id);


--
-- Name: scr_screeningscandata_screeningscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningscandata_screeningscandata_info1 ON public.scr_screeningscandata USING btree (screeningscandata_info);


--
-- Name: scr_screeningscandata_screeningscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX scr_screeningscandata_screeningscandata_info1_hash ON public.scr_screeningscandata USING hash (screeningscandata_info);


--
-- Name: val_additionalval_additionalval_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_additionalval_additionalval_info1 ON public.val_additionalval USING btree (additionalval_info);


--
-- Name: val_additionalval_additionalval_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_additionalval_additionalval_info1_hash ON public.val_additionalval USING hash (additionalval_info);


--
-- Name: val_additionalval_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_additionalval_meta_data_activation_user_xdat_user_id1 ON public.val_additionalval_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: val_additionalval_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_additionalval_meta_data_activation_user_xdat_user_id1_hash ON public.val_additionalval_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: val_additionalval_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_additionalval_meta_data_insert_user_xdat_user_id1 ON public.val_additionalval_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: val_additionalval_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_additionalval_meta_data_insert_user_xdat_user_id1_hash ON public.val_additionalval_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: val_additionalval_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_additionalval_meta_data_meta_data_id1_hash ON public.val_additionalval_meta_data USING hash (meta_data_id);


--
-- Name: val_additionalval_val_additionalval_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_additionalval_val_additionalval_id1_hash ON public.val_additionalval USING hash (val_additionalval_id);


--
-- Name: val_protocoldata_check_additionalval_val_additionalval_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_check_additionalval_val_additionalval_id1 ON public.val_protocoldata USING btree (check_additionalval_val_additionalval_id);


--
-- Name: val_protocoldata_check_additionalval_val_additionalval_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_check_additionalval_val_additionalval_id1_hash ON public.val_protocoldata USING hash (check_additionalval_val_additionalval_id);


--
-- Name: val_protocoldata_comment_check_comments_comment_val_prot_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_comment_check_comments_comment_val_prot_1 ON public.val_protocoldata_comment USING btree (check_comments_comment_val_prot_id);


--
-- Name: val_protocoldata_comment_check_comments_comment_val_prot_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_comment_check_comments_comment_val_prot_1_hash ON public.val_protocoldata_comment USING hash (check_comments_comment_val_prot_id);


--
-- Name: val_protocoldata_comment_meta_data_activation_user_xdat_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_comment_meta_data_activation_user_xdat_u1 ON public.val_protocoldata_comment_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_comment_meta_data_activation_user_xdat_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_comment_meta_data_activation_user_xdat_u1_hash ON public.val_protocoldata_comment_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_comment_meta_data_insert_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_comment_meta_data_insert_user_xdat_user_1 ON public.val_protocoldata_comment_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_comment_meta_data_insert_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_comment_meta_data_insert_user_xdat_user_1_hash ON public.val_protocoldata_comment_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_comment_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_comment_meta_data_meta_data_id1_hash ON public.val_protocoldata_comment_meta_data USING hash (meta_data_id);


--
-- Name: val_protocoldata_comment_protocoldata_comment_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_comment_protocoldata_comment_info1 ON public.val_protocoldata_comment USING btree (protocoldata_comment_info);


--
-- Name: val_protocoldata_comment_protocoldata_comment_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_comment_protocoldata_comment_info1_hash ON public.val_protocoldata_comment USING hash (protocoldata_comment_info);


--
-- Name: val_protocoldata_comment_val_protocoldata_comment_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_comment_val_protocoldata_comment_id1_hash ON public.val_protocoldata_comment USING hash (val_protocoldata_comment_id);


--
-- Name: val_protocoldata_condition_check_conditions_condition_val1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_condition_check_conditions_condition_val1 ON public.val_protocoldata_condition USING btree (check_conditions_condition_val__id);


--
-- Name: val_protocoldata_condition_check_conditions_condition_val1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_condition_check_conditions_condition_val1_hash ON public.val_protocoldata_condition USING hash (check_conditions_condition_val__id);


--
-- Name: val_protocoldata_condition_meta_data_activation_user_xdat1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_condition_meta_data_activation_user_xdat1 ON public.val_protocoldata_condition_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_condition_meta_data_activation_user_xdat1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_condition_meta_data_activation_user_xdat1_hash ON public.val_protocoldata_condition_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_condition_meta_data_insert_user_xdat_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_condition_meta_data_insert_user_xdat_use1 ON public.val_protocoldata_condition_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_condition_meta_data_insert_user_xdat_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_condition_meta_data_insert_user_xdat_use1_hash ON public.val_protocoldata_condition_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_condition_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_condition_meta_data_meta_data_id1_hash ON public.val_protocoldata_condition_meta_data USING hash (meta_data_id);


--
-- Name: val_protocoldata_condition_protocoldata_condition_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_condition_protocoldata_condition_info1 ON public.val_protocoldata_condition USING btree (protocoldata_condition_info);


--
-- Name: val_protocoldata_condition_protocoldata_condition_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_condition_protocoldata_condition_info1_hash ON public.val_protocoldata_condition USING hash (protocoldata_condition_info);


--
-- Name: val_protocoldata_condition_val_protocoldata_condition_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_condition_val_protocoldata_condition_id1_hash ON public.val_protocoldata_condition USING hash (val_protocoldata_condition_id);


--
-- Name: val_protocoldata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_id1 ON public.val_protocoldata USING btree (id);


--
-- Name: val_protocoldata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_id1_hash ON public.val_protocoldata USING hash (id);


--
-- Name: val_protocoldata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_id2_hash ON public.val_protocoldata USING hash (id);


--
-- Name: val_protocoldata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_meta_data_activation_user_xdat_user_id1 ON public.val_protocoldata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_meta_data_activation_user_xdat_user_id1_hash ON public.val_protocoldata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_meta_data_insert_user_xdat_user_id1 ON public.val_protocoldata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_meta_data_insert_user_xdat_user_id1_hash ON public.val_protocoldata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_meta_data_meta_data_id1_hash ON public.val_protocoldata_meta_data USING hash (meta_data_id);


--
-- Name: val_protocoldata_protocoldata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_protocoldata_info1 ON public.val_protocoldata USING btree (protocoldata_info);


--
-- Name: val_protocoldata_protocoldata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_protocoldata_info1_hash ON public.val_protocoldata USING hash (protocoldata_info);


--
-- Name: val_protocoldata_scan_check_additionalval_val_additionalv1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_additionalval_val_additionalv1 ON public.val_protocoldata_scan_check USING btree (additionalval_val_additionalval_id);


--
-- Name: val_protocoldata_scan_check_additionalval_val_additionalv1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_additionalval_val_additionalv1_hash ON public.val_protocoldata_scan_check USING hash (additionalval_val_additionalval_id);


--
-- Name: val_protocoldata_scan_check_comment_comments_comment_val_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_comment_comments_comment_val_1 ON public.val_protocoldata_scan_check_comment USING btree (comments_comment_val_protocolda_val_protocoldata_scan_check_id);


--
-- Name: val_protocoldata_scan_check_comment_comments_comment_val_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_comment_comments_comment_val_1_hash ON public.val_protocoldata_scan_check_comment USING hash (comments_comment_val_protocolda_val_protocoldata_scan_check_id);


--
-- Name: val_protocoldata_scan_check_comment_meta_data_activation_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_comment_meta_data_activation_1 ON public.val_protocoldata_scan_check_comment_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_comment_meta_data_activation_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_comment_meta_data_activation_1_hash ON public.val_protocoldata_scan_check_comment_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_comment_meta_data_insert_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_comment_meta_data_insert_user1 ON public.val_protocoldata_scan_check_comment_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_comment_meta_data_insert_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_comment_meta_data_insert_user1_hash ON public.val_protocoldata_scan_check_comment_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_comment_meta_data_meta_data_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_comment_meta_data_meta_data_i1_hash ON public.val_protocoldata_scan_check_comment_meta_data USING hash (meta_data_id);


--
-- Name: val_protocoldata_scan_check_comment_protocoldata_scan_che1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_comment_protocoldata_scan_che1 ON public.val_protocoldata_scan_check_comment USING btree (protocoldata_scan_check_comment_info);


--
-- Name: val_protocoldata_scan_check_comment_protocoldata_scan_che1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_comment_protocoldata_scan_che1_hash ON public.val_protocoldata_scan_check_comment USING hash (protocoldata_scan_check_comment_info);


--
-- Name: val_protocoldata_scan_check_comment_val_protocoldata_scan1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_comment_val_protocoldata_scan1_hash ON public.val_protocoldata_scan_check_comment USING hash (val_protocoldata_scan_check_comment_id);


--
-- Name: val_protocoldata_scan_check_condition_conditions_conditio1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_condition_conditions_conditio1 ON public.val_protocoldata_scan_check_condition USING btree (conditions_condition_val_protoc_val_protocoldata_scan_check_id);


--
-- Name: val_protocoldata_scan_check_condition_conditions_conditio1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_condition_conditions_conditio1_hash ON public.val_protocoldata_scan_check_condition USING hash (conditions_condition_val_protoc_val_protocoldata_scan_check_id);


--
-- Name: val_protocoldata_scan_check_condition_meta_data_activatio1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_condition_meta_data_activatio1 ON public.val_protocoldata_scan_check_condition_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_condition_meta_data_activatio1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_condition_meta_data_activatio1_hash ON public.val_protocoldata_scan_check_condition_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_condition_meta_data_insert_us1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_condition_meta_data_insert_us1 ON public.val_protocoldata_scan_check_condition_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_condition_meta_data_insert_us1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_condition_meta_data_insert_us1_hash ON public.val_protocoldata_scan_check_condition_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_condition_meta_data_meta_data1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_condition_meta_data_meta_data1_hash ON public.val_protocoldata_scan_check_condition_meta_data USING hash (meta_data_id);


--
-- Name: val_protocoldata_scan_check_condition_protocoldata_scan_c1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_condition_protocoldata_scan_c1 ON public.val_protocoldata_scan_check_condition USING btree (protocoldata_scan_check_condition_info);


--
-- Name: val_protocoldata_scan_check_condition_protocoldata_scan_c1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_condition_protocoldata_scan_c1_hash ON public.val_protocoldata_scan_check_condition USING hash (protocoldata_scan_check_condition_info);


--
-- Name: val_protocoldata_scan_check_condition_val_protocoldata_sc1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_condition_val_protocoldata_sc1_hash ON public.val_protocoldata_scan_check_condition USING hash (val_protocoldata_scan_check_condition_id);


--
-- Name: val_protocoldata_scan_check_meta_data_activation_user_xda1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_meta_data_activation_user_xda1 ON public.val_protocoldata_scan_check_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_meta_data_activation_user_xda1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_meta_data_activation_user_xda1_hash ON public.val_protocoldata_scan_check_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_meta_data_insert_user_xdat_us1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_meta_data_insert_user_xdat_us1 ON public.val_protocoldata_scan_check_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_meta_data_insert_user_xdat_us1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_meta_data_insert_user_xdat_us1_hash ON public.val_protocoldata_scan_check_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: val_protocoldata_scan_check_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_meta_data_meta_data_id1_hash ON public.val_protocoldata_scan_check_meta_data USING hash (meta_data_id);


--
-- Name: val_protocoldata_scan_check_protocoldata_scan_check_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_protocoldata_scan_check_info1 ON public.val_protocoldata_scan_check USING btree (protocoldata_scan_check_info);


--
-- Name: val_protocoldata_scan_check_protocoldata_scan_check_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_protocoldata_scan_check_info1_hash ON public.val_protocoldata_scan_check USING hash (protocoldata_scan_check_info);


--
-- Name: val_protocoldata_scan_check_scans_scan_check_val_protocol1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_scans_scan_check_val_protocol1 ON public.val_protocoldata_scan_check USING btree (scans_scan_check_val_protocolda_id);


--
-- Name: val_protocoldata_scan_check_scans_scan_check_val_protocol1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_scans_scan_check_val_protocol1_hash ON public.val_protocoldata_scan_check USING hash (scans_scan_check_val_protocolda_id);


--
-- Name: val_protocoldata_scan_check_val_protocoldata_scan_check_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX val_protocoldata_scan_check_val_protocoldata_scan_check_i1_hash ON public.val_protocoldata_scan_check USING hash (val_protocoldata_scan_check_id);


--
-- Name: wrk_abstractexecutionenvironment_abstractexecutionenviron1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_abstractexecutionenvironment_abstractexecutionenviron1 ON public.wrk_abstractexecutionenvironment USING btree (abstractexecutionenvironment_info);


--
-- Name: wrk_abstractexecutionenvironment_abstractexecutionenviron1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_abstractexecutionenvironment_abstractexecutionenviron1_hash ON public.wrk_abstractexecutionenvironment USING hash (abstractexecutionenvironment_info);


--
-- Name: wrk_abstractexecutionenvironment_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_abstractexecutionenvironment_extension1 ON public.wrk_abstractexecutionenvironment USING btree (extension);


--
-- Name: wrk_abstractexecutionenvironment_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_abstractexecutionenvironment_extension1_hash ON public.wrk_abstractexecutionenvironment USING hash (extension);


--
-- Name: wrk_abstractexecutionenvironment_meta_data_activation_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_abstractexecutionenvironment_meta_data_activation_use1 ON public.wrk_abstractexecutionenvironment_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: wrk_abstractexecutionenvironment_meta_data_activation_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_abstractexecutionenvironment_meta_data_activation_use1_hash ON public.wrk_abstractexecutionenvironment_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: wrk_abstractexecutionenvironment_meta_data_insert_user_xd1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_abstractexecutionenvironment_meta_data_insert_user_xd1 ON public.wrk_abstractexecutionenvironment_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: wrk_abstractexecutionenvironment_meta_data_insert_user_xd1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_abstractexecutionenvironment_meta_data_insert_user_xd1_hash ON public.wrk_abstractexecutionenvironment_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: wrk_abstractexecutionenvironment_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_abstractexecutionenvironment_meta_data_meta_data_id1_hash ON public.wrk_abstractexecutionenvironment_meta_data USING hash (meta_data_id);


--
-- Name: wrk_abstractexecutionenvironment_wrk_abstractexecutionenv1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_abstractexecutionenvironment_wrk_abstractexecutionenv1_hash ON public.wrk_abstractexecutionenvironment USING hash (wrk_abstractexecutionenvironment_id);


--
-- Name: wrk_workflowdata_executionenvironment_wrk_abstractexecuti1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_workflowdata_executionenvironment_wrk_abstractexecuti1 ON public.wrk_workflowdata USING btree (executionenvironment_wrk_abstractexecutionenvironment_id);


--
-- Name: wrk_workflowdata_executionenvironment_wrk_abstractexecuti1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_workflowdata_executionenvironment_wrk_abstractexecuti1_hash ON public.wrk_workflowdata USING hash (executionenvironment_wrk_abstractexecutionenvironment_id);


--
-- Name: wrk_workflowdata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_workflowdata_meta_data_activation_user_xdat_user_id1 ON public.wrk_workflowdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: wrk_workflowdata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_workflowdata_meta_data_activation_user_xdat_user_id1_hash ON public.wrk_workflowdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: wrk_workflowdata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_workflowdata_meta_data_insert_user_xdat_user_id1 ON public.wrk_workflowdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: wrk_workflowdata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_workflowdata_meta_data_insert_user_xdat_user_id1_hash ON public.wrk_workflowdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: wrk_workflowdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_workflowdata_meta_data_meta_data_id1_hash ON public.wrk_workflowdata_meta_data USING hash (meta_data_id);


--
-- Name: wrk_workflowdata_workflowdata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_workflowdata_workflowdata_info1 ON public.wrk_workflowdata USING btree (workflowdata_info);


--
-- Name: wrk_workflowdata_workflowdata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_workflowdata_workflowdata_info1_hash ON public.wrk_workflowdata USING hash (workflowdata_info);


--
-- Name: wrk_workflowdata_wrk_workflowdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_workflowdata_wrk_workflowdata_id1_hash ON public.wrk_workflowdata USING hash (wrk_workflowdata_id);


--
-- Name: wrk_xnatexecutionenvironment_meta_data_activation_user_xd1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_meta_data_activation_user_xd1 ON public.wrk_xnatexecutionenvironment_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_meta_data_activation_user_xd1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_meta_data_activation_user_xd1_hash ON public.wrk_xnatexecutionenvironment_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_meta_data_insert_user_xdat_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_meta_data_insert_user_xdat_u1 ON public.wrk_xnatexecutionenvironment_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_meta_data_insert_user_xdat_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_meta_data_insert_user_xdat_u1_hash ON public.wrk_xnatexecutionenvironment_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_meta_data_meta_data_id1_hash ON public.wrk_xnatexecutionenvironment_meta_data USING hash (meta_data_id);


--
-- Name: wrk_xnatexecutionenvironment_notify_meta_data_activation_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_notify_meta_data_activation_1 ON public.wrk_xnatexecutionenvironment_notify_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_notify_meta_data_activation_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_notify_meta_data_activation_1_hash ON public.wrk_xnatexecutionenvironment_notify_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_notify_meta_data_insert_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_notify_meta_data_insert_user1 ON public.wrk_xnatexecutionenvironment_notify_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_notify_meta_data_insert_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_notify_meta_data_insert_user1_hash ON public.wrk_xnatexecutionenvironment_notify_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_notify_meta_data_meta_data_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_notify_meta_data_meta_data_i1_hash ON public.wrk_xnatexecutionenvironment_notify_meta_data USING hash (meta_data_id);


--
-- Name: wrk_xnatexecutionenvironment_notify_wrk_xnatexecutionenvi1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_notify_wrk_xnatexecutionenvi1 ON public.wrk_xnatexecutionenvironment_notify USING btree (wrk_xnatexecutionenvironment_wrk_abstractexecutionenvironmen);


--
-- Name: wrk_xnatexecutionenvironment_notify_wrk_xnatexecutionenvi1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_notify_wrk_xnatexecutionenvi1_hash ON public.wrk_xnatexecutionenvironment_notify USING hash (wrk_xnatexecutionenvironment_wrk_abstractexecutionenvironmen);


--
-- Name: wrk_xnatexecutionenvironment_notify_wrk_xnatexecutionenvi2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_notify_wrk_xnatexecutionenvi2_hash ON public.wrk_xnatexecutionenvironment_notify USING hash (wrk_xnatexecutionenvironment_notify_id);


--
-- Name: wrk_xnatexecutionenvironment_notify_xnatexecutionenvironm1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_notify_xnatexecutionenvironm1 ON public.wrk_xnatexecutionenvironment_notify USING btree (xnatexecutionenvironment_notify_info);


--
-- Name: wrk_xnatexecutionenvironment_notify_xnatexecutionenvironm1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_notify_xnatexecutionenvironm1_hash ON public.wrk_xnatexecutionenvironment_notify USING hash (xnatexecutionenvironment_notify_info);


--
-- Name: wrk_xnatexecutionenvironment_parameter_meta_data_activati1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_parameter_meta_data_activati1 ON public.wrk_xnatexecutionenvironment_parameter_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_parameter_meta_data_activati1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_parameter_meta_data_activati1_hash ON public.wrk_xnatexecutionenvironment_parameter_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_parameter_meta_data_insert_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_parameter_meta_data_insert_u1 ON public.wrk_xnatexecutionenvironment_parameter_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_parameter_meta_data_insert_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_parameter_meta_data_insert_u1_hash ON public.wrk_xnatexecutionenvironment_parameter_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: wrk_xnatexecutionenvironment_parameter_meta_data_meta_dat1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_parameter_meta_data_meta_dat1_hash ON public.wrk_xnatexecutionenvironment_parameter_meta_data USING hash (meta_data_id);


--
-- Name: wrk_xnatexecutionenvironment_parameter_parameters_paramet1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_parameter_parameters_paramet1 ON public.wrk_xnatexecutionenvironment_parameter USING btree (parameters_parameter_wrk_xnatex_wrk_abstractexecutionenvironmen);


--
-- Name: wrk_xnatexecutionenvironment_parameter_parameters_paramet1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_parameter_parameters_paramet1_hash ON public.wrk_xnatexecutionenvironment_parameter USING hash (parameters_parameter_wrk_xnatex_wrk_abstractexecutionenvironmen);


--
-- Name: wrk_xnatexecutionenvironment_parameter_wrk_xnatexecutione1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_parameter_wrk_xnatexecutione1_hash ON public.wrk_xnatexecutionenvironment_parameter USING hash (wrk_xnatexecutionenvironment_parameter_id);


--
-- Name: wrk_xnatexecutionenvironment_parameter_xnatexecutionenvir1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_parameter_xnatexecutionenvir1 ON public.wrk_xnatexecutionenvironment_parameter USING btree (xnatexecutionenvironment_parameter_info);


--
-- Name: wrk_xnatexecutionenvironment_parameter_xnatexecutionenvir1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_parameter_xnatexecutionenvir1_hash ON public.wrk_xnatexecutionenvironment_parameter USING hash (xnatexecutionenvironment_parameter_info);


--
-- Name: wrk_xnatexecutionenvironment_wrk_abstractexecutionenviron1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_wrk_abstractexecutionenviron1 ON public.wrk_xnatexecutionenvironment USING btree (wrk_abstractexecutionenvironment_id);


--
-- Name: wrk_xnatexecutionenvironment_wrk_abstractexecutionenviron1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_wrk_abstractexecutionenviron1_hash ON public.wrk_xnatexecutionenvironment USING hash (wrk_abstractexecutionenvironment_id);


--
-- Name: wrk_xnatexecutionenvironment_wrk_abstractexecutionenviron2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_wrk_abstractexecutionenviron2_hash ON public.wrk_xnatexecutionenvironment USING hash (wrk_abstractexecutionenvironment_id);


--
-- Name: wrk_xnatexecutionenvironment_xnatexecutionenvironment_inf1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_xnatexecutionenvironment_inf1 ON public.wrk_xnatexecutionenvironment USING btree (xnatexecutionenvironment_info);


--
-- Name: wrk_xnatexecutionenvironment_xnatexecutionenvironment_inf1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX wrk_xnatexecutionenvironment_xnatexecutionenvironment_inf1_hash ON public.wrk_xnatexecutionenvironment USING hash (xnatexecutionenvironment_info);


--
-- Name: xdat_access_log_access_log_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_access_log_access_log_info1 ON public.xdat_access_log USING btree (access_log_info);


--
-- Name: xdat_access_log_access_log_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_access_log_access_log_info1_hash ON public.xdat_access_log USING hash (access_log_info);


--
-- Name: xdat_access_log_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_access_log_meta_data_activation_user_xdat_user_id1 ON public.xdat_access_log_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_access_log_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_access_log_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_access_log_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_access_log_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_access_log_meta_data_insert_user_xdat_user_id1 ON public.xdat_access_log_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_access_log_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_access_log_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_access_log_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_access_log_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_access_log_meta_data_meta_data_id1_hash ON public.xdat_access_log_meta_data USING hash (meta_data_id);


--
-- Name: xdat_access_log_xdat_access_log_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_access_log_xdat_access_log_id1_hash ON public.xdat_access_log USING hash (xdat_access_log_id);


--
-- Name: xdat_action_type_action_name1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_action_type_action_name1_hash ON public.xdat_action_type USING hash (action_name);


--
-- Name: xdat_action_type_action_type_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_action_type_action_type_info1 ON public.xdat_action_type USING btree (action_type_info);


--
-- Name: xdat_action_type_action_type_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_action_type_action_type_info1_hash ON public.xdat_action_type USING hash (action_type_info);


--
-- Name: xdat_action_type_actions_action_xdat_security_xdat_securi1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_action_type_actions_action_xdat_security_xdat_securi1 ON public.xdat_action_type USING btree (actions_action_xdat_security_xdat_security_id);


--
-- Name: xdat_action_type_actions_action_xdat_security_xdat_securi1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_action_type_actions_action_xdat_security_xdat_securi1_hash ON public.xdat_action_type USING hash (actions_action_xdat_security_xdat_security_id);


--
-- Name: xdat_action_type_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_action_type_meta_data_activation_user_xdat_user_id1 ON public.xdat_action_type_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_action_type_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_action_type_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_action_type_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_action_type_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_action_type_meta_data_insert_user_xdat_user_id1 ON public.xdat_action_type_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_action_type_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_action_type_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_action_type_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_action_type_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_action_type_meta_data_meta_data_id1_hash ON public.xdat_action_type_meta_data USING hash (meta_data_id);


--
-- Name: xdat_change_info_change_info_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_change_info_change_info_info1 ON public.xdat_change_info USING btree (change_info_info);


--
-- Name: xdat_change_info_change_info_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_change_info_change_info_info1_hash ON public.xdat_change_info USING hash (change_info_info);


--
-- Name: xdat_change_info_change_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_change_info_change_user1 ON public.xdat_change_info USING btree (change_user);


--
-- Name: xdat_change_info_change_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_change_info_change_user1_hash ON public.xdat_change_info USING hash (change_user);


--
-- Name: xdat_change_info_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_change_info_meta_data_activation_user_xdat_user_id1 ON public.xdat_change_info_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_change_info_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_change_info_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_change_info_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_change_info_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_change_info_meta_data_insert_user_xdat_user_id1 ON public.xdat_change_info_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_change_info_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_change_info_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_change_info_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_change_info_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_change_info_meta_data_meta_data_id1_hash ON public.xdat_change_info_meta_data USING hash (meta_data_id);


--
-- Name: xdat_change_info_xdat_change_info_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_change_info_xdat_change_info_id1_hash ON public.xdat_change_info USING hash (xdat_change_info_id);


--
-- Name: xdat_criteria_criteria_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_criteria_info1 ON public.xdat_criteria USING btree (criteria_info);


--
-- Name: xdat_criteria_criteria_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_criteria_info1_hash ON public.xdat_criteria USING hash (criteria_info);


--
-- Name: xdat_criteria_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_meta_data_activation_user_xdat_user_id1 ON public.xdat_criteria_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_criteria_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_criteria_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_criteria_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_meta_data_insert_user_xdat_user_id1 ON public.xdat_criteria_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_criteria_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_criteria_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_criteria_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_meta_data_meta_data_id1_hash ON public.xdat_criteria_meta_data USING hash (meta_data_id);


--
-- Name: xdat_criteria_set_child_set_xdat_criteria_set_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_child_set_xdat_criteria_set_id1 ON public.xdat_criteria_set USING btree (child_set_xdat_criteria_set_id);


--
-- Name: xdat_criteria_set_child_set_xdat_criteria_set_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_child_set_xdat_criteria_set_id1_hash ON public.xdat_criteria_set USING hash (child_set_xdat_criteria_set_id);


--
-- Name: xdat_criteria_set_criteria_set_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_criteria_set_info1 ON public.xdat_criteria_set USING btree (criteria_set_info);


--
-- Name: xdat_criteria_set_criteria_set_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_criteria_set_info1_hash ON public.xdat_criteria_set USING hash (criteria_set_info);


--
-- Name: xdat_criteria_set_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_meta_data_activation_user_xdat_user_id1 ON public.xdat_criteria_set_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_criteria_set_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_criteria_set_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_criteria_set_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_meta_data_insert_user_xdat_user_id1 ON public.xdat_criteria_set_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_criteria_set_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_criteria_set_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_criteria_set_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_meta_data_meta_data_id1_hash ON public.xdat_criteria_set_meta_data USING hash (meta_data_id);


--
-- Name: xdat_criteria_set_xdat_criteria_set_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_xdat_criteria_set_id1_hash ON public.xdat_criteria_set USING hash (xdat_criteria_set_id);


--
-- Name: xdat_criteria_set_xdat_stored_search_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_xdat_stored_search_id1 ON public.xdat_criteria_set USING btree (xdat_stored_search_id);


--
-- Name: xdat_criteria_set_xdat_stored_search_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_set_xdat_stored_search_id1_hash ON public.xdat_criteria_set USING hash (xdat_stored_search_id);


--
-- Name: xdat_criteria_xdat_criteria_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_xdat_criteria_id1_hash ON public.xdat_criteria USING hash (xdat_criteria_id);


--
-- Name: xdat_criteria_xdat_criteria_set_xdat_criteria_set_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_xdat_criteria_set_xdat_criteria_set_id1 ON public.xdat_criteria USING btree (xdat_criteria_set_xdat_criteria_set_id);


--
-- Name: xdat_criteria_xdat_criteria_set_xdat_criteria_set_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_criteria_xdat_criteria_set_xdat_criteria_set_id1_hash ON public.xdat_criteria USING hash (xdat_criteria_set_xdat_criteria_set_id);


--
-- Name: xdat_element_access_element_access_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_element_access_info1 ON public.xdat_element_access USING btree (element_access_info);


--
-- Name: xdat_element_access_element_access_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_element_access_info1_hash ON public.xdat_element_access USING hash (element_access_info);


--
-- Name: xdat_element_access_meta_data_activation_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_meta_data_activation_user_xdat_user_i1 ON public.xdat_element_access_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_element_access_meta_data_activation_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_meta_data_activation_user_xdat_user_i1_hash ON public.xdat_element_access_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_element_access_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_meta_data_insert_user_xdat_user_id1 ON public.xdat_element_access_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_element_access_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_element_access_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_element_access_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_meta_data_meta_data_id1_hash ON public.xdat_element_access_meta_data USING hash (meta_data_id);


--
-- Name: xdat_element_access_secure_ip_element_access_secure_ip_in1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_secure_ip_element_access_secure_ip_in1 ON public.xdat_element_access_secure_ip USING btree (element_access_secure_ip_info);


--
-- Name: xdat_element_access_secure_ip_element_access_secure_ip_in1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_secure_ip_element_access_secure_ip_in1_hash ON public.xdat_element_access_secure_ip USING hash (element_access_secure_ip_info);


--
-- Name: xdat_element_access_secure_ip_meta_data_activation_user_x1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_secure_ip_meta_data_activation_user_x1 ON public.xdat_element_access_secure_ip_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_element_access_secure_ip_meta_data_activation_user_x1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_secure_ip_meta_data_activation_user_x1_hash ON public.xdat_element_access_secure_ip_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_element_access_secure_ip_meta_data_insert_user_xdat_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_secure_ip_meta_data_insert_user_xdat_1 ON public.xdat_element_access_secure_ip_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_element_access_secure_ip_meta_data_insert_user_xdat_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_secure_ip_meta_data_insert_user_xdat_1_hash ON public.xdat_element_access_secure_ip_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_element_access_secure_ip_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_secure_ip_meta_data_meta_data_id1_hash ON public.xdat_element_access_secure_ip_meta_data USING hash (meta_data_id);


--
-- Name: xdat_element_access_secure_ip_xdat_element_access_secure_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_secure_ip_xdat_element_access_secure_1_hash ON public.xdat_element_access_secure_ip USING hash (xdat_element_access_secure_ip_id);


--
-- Name: xdat_element_access_secure_ip_xdat_element_access_xdat_el1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_secure_ip_xdat_element_access_xdat_el1 ON public.xdat_element_access_secure_ip USING btree (xdat_element_access_xdat_element_access_id);


--
-- Name: xdat_element_access_secure_ip_xdat_element_access_xdat_el1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_secure_ip_xdat_element_access_xdat_el1_hash ON public.xdat_element_access_secure_ip USING hash (xdat_element_access_xdat_element_access_id);


--
-- Name: xdat_element_access_xdat_element_access_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_xdat_element_access_id1_hash ON public.xdat_element_access USING hash (xdat_element_access_id);


--
-- Name: xdat_element_access_xdat_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_xdat_user_xdat_user_id1 ON public.xdat_element_access USING btree (xdat_user_xdat_user_id);


--
-- Name: xdat_element_access_xdat_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_xdat_user_xdat_user_id1_hash ON public.xdat_element_access USING hash (xdat_user_xdat_user_id);


--
-- Name: xdat_element_access_xdat_usergroup_xdat_usergroup_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_xdat_usergroup_xdat_usergroup_id1 ON public.xdat_element_access USING btree (xdat_usergroup_xdat_usergroup_id);


--
-- Name: xdat_element_access_xdat_usergroup_xdat_usergroup_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_access_xdat_usergroup_xdat_usergroup_id1_hash ON public.xdat_element_access USING hash (xdat_usergroup_xdat_usergroup_id);


--
-- Name: xdat_element_action_type_element_action_type_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_action_type_element_action_type_info1 ON public.xdat_element_action_type USING btree (element_action_type_info);


--
-- Name: xdat_element_action_type_element_action_type_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_action_type_element_action_type_info1_hash ON public.xdat_element_action_type USING hash (element_action_type_info);


--
-- Name: xdat_element_action_type_element_actions_element_action__1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_action_type_element_actions_element_action__1 ON public.xdat_element_action_type USING btree (element_actions_element_action__element_name);


--
-- Name: xdat_element_action_type_element_actions_element_action__1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_action_type_element_actions_element_action__1_hash ON public.xdat_element_action_type USING hash (element_actions_element_action__element_name);


--
-- Name: xdat_element_action_type_meta_data_activation_user_xdat_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_action_type_meta_data_activation_user_xdat_u1 ON public.xdat_element_action_type_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_element_action_type_meta_data_activation_user_xdat_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_action_type_meta_data_activation_user_xdat_u1_hash ON public.xdat_element_action_type_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_element_action_type_meta_data_insert_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_action_type_meta_data_insert_user_xdat_user_1 ON public.xdat_element_action_type_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_element_action_type_meta_data_insert_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_action_type_meta_data_insert_user_xdat_user_1_hash ON public.xdat_element_action_type_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_element_action_type_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_action_type_meta_data_meta_data_id1_hash ON public.xdat_element_action_type_meta_data USING hash (meta_data_id);


--
-- Name: xdat_element_action_type_xdat_element_action_type_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_action_type_xdat_element_action_type_id1_hash ON public.xdat_element_action_type USING hash (xdat_element_action_type_id);


--
-- Name: xdat_element_security_element_name1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_element_name1_hash ON public.xdat_element_security USING hash (element_name);


--
-- Name: xdat_element_security_element_security_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_element_security_info1 ON public.xdat_element_security USING btree (element_security_info);


--
-- Name: xdat_element_security_element_security_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_element_security_info1_hash ON public.xdat_element_security USING hash (element_security_info);


--
-- Name: xdat_element_security_element_security_set_element_se_xda1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_element_security_set_element_se_xda1 ON public.xdat_element_security USING btree (element_security_set_element_se_xdat_security_id);


--
-- Name: xdat_element_security_element_security_set_element_se_xda1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_element_security_set_element_se_xda1_hash ON public.xdat_element_security USING hash (element_security_set_element_se_xdat_security_id);


--
-- Name: xdat_element_security_listing_action_element_security_lis1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_listing_action_element_security_lis1 ON public.xdat_element_security_listing_action USING btree (element_security_listing_action_info);


--
-- Name: xdat_element_security_listing_action_element_security_lis1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_listing_action_element_security_lis1_hash ON public.xdat_element_security_listing_action USING hash (element_security_listing_action_info);


--
-- Name: xdat_element_security_listing_action_listing_actions_list1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_listing_action_listing_actions_list1 ON public.xdat_element_security_listing_action USING btree (listing_actions_listing_action__element_name);


--
-- Name: xdat_element_security_listing_action_listing_actions_list1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_listing_action_listing_actions_list1_hash ON public.xdat_element_security_listing_action USING hash (listing_actions_listing_action__element_name);


--
-- Name: xdat_element_security_listing_action_meta_data_activation1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_listing_action_meta_data_activation1 ON public.xdat_element_security_listing_action_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_element_security_listing_action_meta_data_activation1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_listing_action_meta_data_activation1_hash ON public.xdat_element_security_listing_action_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_element_security_listing_action_meta_data_insert_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_listing_action_meta_data_insert_use1 ON public.xdat_element_security_listing_action_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_element_security_listing_action_meta_data_insert_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_listing_action_meta_data_insert_use1_hash ON public.xdat_element_security_listing_action_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_element_security_listing_action_meta_data_meta_data_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_listing_action_meta_data_meta_data_1_hash ON public.xdat_element_security_listing_action_meta_data USING hash (meta_data_id);


--
-- Name: xdat_element_security_listing_action_xdat_element_securit1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_listing_action_xdat_element_securit1_hash ON public.xdat_element_security_listing_action USING hash (xdat_element_security_listing_action_id);


--
-- Name: xdat_element_security_meta_data_activation_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_meta_data_activation_user_xdat_user1 ON public.xdat_element_security_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_element_security_meta_data_activation_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_meta_data_activation_user_xdat_user1_hash ON public.xdat_element_security_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_element_security_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_meta_data_insert_user_xdat_user_id1 ON public.xdat_element_security_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_element_security_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_element_security_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_element_security_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_element_security_meta_data_meta_data_id1_hash ON public.xdat_element_security_meta_data USING hash (meta_data_id);


--
-- Name: xdat_field_mapping_field_mapping_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_field_mapping_info1 ON public.xdat_field_mapping USING btree (field_mapping_info);


--
-- Name: xdat_field_mapping_field_mapping_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_field_mapping_info1_hash ON public.xdat_field_mapping USING hash (field_mapping_info);


--
-- Name: xdat_field_mapping_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_meta_data_activation_user_xdat_user_id1 ON public.xdat_field_mapping_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_field_mapping_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_field_mapping_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_field_mapping_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_meta_data_insert_user_xdat_user_id1 ON public.xdat_field_mapping_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_field_mapping_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_field_mapping_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_field_mapping_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_meta_data_meta_data_id1_hash ON public.xdat_field_mapping_meta_data USING hash (meta_data_id);


--
-- Name: xdat_field_mapping_set_field_mapping_set_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_field_mapping_set_info1 ON public.xdat_field_mapping_set USING btree (field_mapping_set_info);


--
-- Name: xdat_field_mapping_set_field_mapping_set_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_field_mapping_set_info1_hash ON public.xdat_field_mapping_set USING hash (field_mapping_set_info);


--
-- Name: xdat_field_mapping_set_meta_data_activation_user_xdat_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_meta_data_activation_user_xdat_use1 ON public.xdat_field_mapping_set_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_field_mapping_set_meta_data_activation_user_xdat_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_meta_data_activation_user_xdat_use1_hash ON public.xdat_field_mapping_set_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_field_mapping_set_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_meta_data_insert_user_xdat_user_id1 ON public.xdat_field_mapping_set_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_field_mapping_set_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_field_mapping_set_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_field_mapping_set_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_meta_data_meta_data_id1_hash ON public.xdat_field_mapping_set_meta_data USING hash (meta_data_id);


--
-- Name: xdat_field_mapping_set_permissions_allow_set_xdat_elem_xd1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_permissions_allow_set_xdat_elem_xd1 ON public.xdat_field_mapping_set USING btree (permissions_allow_set_xdat_elem_xdat_element_access_id);


--
-- Name: xdat_field_mapping_set_permissions_allow_set_xdat_elem_xd1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_permissions_allow_set_xdat_elem_xd1_hash ON public.xdat_field_mapping_set USING hash (permissions_allow_set_xdat_elem_xdat_element_access_id);


--
-- Name: xdat_field_mapping_set_sub_set_xdat_field_mapping_set_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_sub_set_xdat_field_mapping_set_id1 ON public.xdat_field_mapping_set USING btree (sub_set_xdat_field_mapping_set_id);


--
-- Name: xdat_field_mapping_set_sub_set_xdat_field_mapping_set_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_sub_set_xdat_field_mapping_set_id1_hash ON public.xdat_field_mapping_set USING hash (sub_set_xdat_field_mapping_set_id);


--
-- Name: xdat_field_mapping_set_xdat_field_mapping_set_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_set_xdat_field_mapping_set_id1_hash ON public.xdat_field_mapping_set USING hash (xdat_field_mapping_set_id);


--
-- Name: xdat_field_mapping_xdat_field_mapping_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_xdat_field_mapping_id1_hash ON public.xdat_field_mapping USING hash (xdat_field_mapping_id);


--
-- Name: xdat_field_mapping_xdat_field_mapping_set_xdat_field_mapp1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_xdat_field_mapping_set_xdat_field_mapp1 ON public.xdat_field_mapping USING btree (xdat_field_mapping_set_xdat_field_mapping_set_id);


--
-- Name: xdat_field_mapping_xdat_field_mapping_set_xdat_field_mapp1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_field_mapping_xdat_field_mapping_set_xdat_field_mapp1_hash ON public.xdat_field_mapping USING hash (xdat_field_mapping_set_xdat_field_mapping_set_id);


--
-- Name: xdat_infoentry_infoentry_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_infoentry_infoentry_info1 ON public.xdat_infoentry USING btree (infoentry_info);


--
-- Name: xdat_infoentry_infoentry_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_infoentry_infoentry_info1_hash ON public.xdat_infoentry USING hash (infoentry_info);


--
-- Name: xdat_infoentry_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_infoentry_meta_data_activation_user_xdat_user_id1 ON public.xdat_infoentry_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_infoentry_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_infoentry_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_infoentry_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_infoentry_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_infoentry_meta_data_insert_user_xdat_user_id1 ON public.xdat_infoentry_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_infoentry_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_infoentry_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_infoentry_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_infoentry_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_infoentry_meta_data_meta_data_id1_hash ON public.xdat_infoentry_meta_data USING hash (meta_data_id);


--
-- Name: xdat_infoentry_xdat_infoentry_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_infoentry_xdat_infoentry_id1_hash ON public.xdat_infoentry USING hash (xdat_infoentry_id);


--
-- Name: xdat_meta_element_xdat_meta_element_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_meta_element_xdat_meta_element_id1_hash ON public.xdat_meta_element USING hash (xdat_meta_element_id);


--
-- Name: xdat_newsentry_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_newsentry_meta_data_activation_user_xdat_user_id1 ON public.xdat_newsentry_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_newsentry_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_newsentry_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_newsentry_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_newsentry_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_newsentry_meta_data_insert_user_xdat_user_id1 ON public.xdat_newsentry_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_newsentry_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_newsentry_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_newsentry_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_newsentry_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_newsentry_meta_data_meta_data_id1_hash ON public.xdat_newsentry_meta_data USING hash (meta_data_id);


--
-- Name: xdat_newsentry_newsentry_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_newsentry_newsentry_info1 ON public.xdat_newsentry USING btree (newsentry_info);


--
-- Name: xdat_newsentry_newsentry_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_newsentry_newsentry_info1_hash ON public.xdat_newsentry USING hash (newsentry_info);


--
-- Name: xdat_newsentry_xdat_newsentry_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_newsentry_xdat_newsentry_id1_hash ON public.xdat_newsentry USING hash (xdat_newsentry_id);


--
-- Name: xdat_primary_security_field_meta_data_activation_user_xda1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_primary_security_field_meta_data_activation_user_xda1 ON public.xdat_primary_security_field_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_primary_security_field_meta_data_activation_user_xda1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_primary_security_field_meta_data_activation_user_xda1_hash ON public.xdat_primary_security_field_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_primary_security_field_meta_data_insert_user_xdat_us1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_primary_security_field_meta_data_insert_user_xdat_us1 ON public.xdat_primary_security_field_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_primary_security_field_meta_data_insert_user_xdat_us1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_primary_security_field_meta_data_insert_user_xdat_us1_hash ON public.xdat_primary_security_field_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_primary_security_field_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_primary_security_field_meta_data_meta_data_id1_hash ON public.xdat_primary_security_field_meta_data USING hash (meta_data_id);


--
-- Name: xdat_primary_security_field_primary_security_field_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_primary_security_field_primary_security_field_info1 ON public.xdat_primary_security_field USING btree (primary_security_field_info);


--
-- Name: xdat_primary_security_field_primary_security_field_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_primary_security_field_primary_security_field_info1_hash ON public.xdat_primary_security_field USING hash (primary_security_field_info);


--
-- Name: xdat_primary_security_field_primary_security_fields_prima1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_primary_security_field_primary_security_fields_prima1 ON public.xdat_primary_security_field USING btree (primary_security_fields_primary_element_name);


--
-- Name: xdat_primary_security_field_primary_security_fields_prima1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_primary_security_field_primary_security_fields_prima1_hash ON public.xdat_primary_security_field USING hash (primary_security_fields_primary_element_name);


--
-- Name: xdat_primary_security_field_xdat_primary_security_field_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_primary_security_field_xdat_primary_security_field_i1_hash ON public.xdat_primary_security_field USING hash (xdat_primary_security_field_id);


--
-- Name: xdat_role_type_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_role_type_meta_data_activation_user_xdat_user_id1 ON public.xdat_role_type_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_role_type_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_role_type_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_role_type_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_role_type_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_role_type_meta_data_insert_user_xdat_user_id1 ON public.xdat_role_type_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_role_type_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_role_type_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_role_type_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_role_type_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_role_type_meta_data_meta_data_id1_hash ON public.xdat_role_type_meta_data USING hash (meta_data_id);


--
-- Name: xdat_role_type_role_name1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_role_type_role_name1_hash ON public.xdat_role_type USING hash (role_name);


--
-- Name: xdat_role_type_role_type_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_role_type_role_type_info1 ON public.xdat_role_type USING btree (role_type_info);


--
-- Name: xdat_role_type_role_type_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_role_type_role_type_info1_hash ON public.xdat_role_type USING hash (role_type_info);


--
-- Name: xdat_role_type_roles_role_xdat_security_xdat_security_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_role_type_roles_role_xdat_security_xdat_security_id1 ON public.xdat_role_type USING btree (roles_role_xdat_security_xdat_security_id);


--
-- Name: xdat_role_type_roles_role_xdat_security_xdat_security_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_role_type_roles_role_xdat_security_xdat_security_id1_hash ON public.xdat_role_type USING hash (roles_role_xdat_security_xdat_security_id);


--
-- Name: xdat_search_field_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_field_meta_data_activation_user_xdat_user_id1 ON public.xdat_search_field_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_search_field_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_field_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_search_field_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_search_field_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_field_meta_data_insert_user_xdat_user_id1 ON public.xdat_search_field_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_search_field_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_field_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_search_field_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_search_field_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_field_meta_data_meta_data_id1_hash ON public.xdat_search_field_meta_data USING hash (meta_data_id);


--
-- Name: xdat_search_field_search_field_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_field_search_field_info1 ON public.xdat_search_field USING btree (search_field_info);


--
-- Name: xdat_search_field_search_field_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_field_search_field_info1_hash ON public.xdat_search_field USING hash (search_field_info);


--
-- Name: xdat_search_field_xdat_search_field_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_field_xdat_search_field_id1_hash ON public.xdat_search_field USING hash (xdat_search_field_id);


--
-- Name: xdat_search_field_xdat_stored_search_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_field_xdat_stored_search_id1 ON public.xdat_search_field USING btree (xdat_stored_search_id);


--
-- Name: xdat_search_field_xdat_stored_search_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_field_xdat_stored_search_id1_hash ON public.xdat_search_field USING hash (xdat_stored_search_id);


--
-- Name: xdat_search_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_id1 ON public.xdat_search USING btree (id);


--
-- Name: xdat_search_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_id1_hash ON public.xdat_search USING hash (id);


--
-- Name: xdat_search_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_id2_hash ON public.xdat_search USING hash (id);


--
-- Name: xdat_search_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_meta_data_activation_user_xdat_user_id1 ON public.xdat_search_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_search_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_search_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_search_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_meta_data_insert_user_xdat_user_id1 ON public.xdat_search_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_search_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_search_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_search_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_meta_data_meta_data_id1_hash ON public.xdat_search_meta_data USING hash (meta_data_id);


--
-- Name: xdat_search_search_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_search_info1 ON public.xdat_search USING btree (search_info);


--
-- Name: xdat_search_search_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_search_search_info1_hash ON public.xdat_search USING hash (search_info);


--
-- Name: xdat_security_infolist_info_xdat_infoentry_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_infolist_info_xdat_infoentry_id1 ON public.xdat_security USING btree (infolist_info_xdat_infoentry_id);


--
-- Name: xdat_security_infolist_info_xdat_infoentry_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_infolist_info_xdat_infoentry_id1_hash ON public.xdat_security USING hash (infolist_info_xdat_infoentry_id);


--
-- Name: xdat_security_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_meta_data_activation_user_xdat_user_id1 ON public.xdat_security_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_security_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_security_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_security_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_meta_data_insert_user_xdat_user_id1 ON public.xdat_security_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_security_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_security_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_security_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_meta_data_meta_data_id1_hash ON public.xdat_security_meta_data USING hash (meta_data_id);


--
-- Name: xdat_security_newslist_news_xdat_newsentry_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_newslist_news_xdat_newsentry_id1 ON public.xdat_security USING btree (newslist_news_xdat_newsentry_id);


--
-- Name: xdat_security_newslist_news_xdat_newsentry_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_newslist_news_xdat_newsentry_id1_hash ON public.xdat_security USING hash (newslist_news_xdat_newsentry_id);


--
-- Name: xdat_security_security_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_security_info1 ON public.xdat_security USING btree (security_info);


--
-- Name: xdat_security_security_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_security_info1_hash ON public.xdat_security USING hash (security_info);


--
-- Name: xdat_security_xdat_security_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_security_xdat_security_id1_hash ON public.xdat_security USING hash (xdat_security_id);


--
-- Name: xdat_stored_search_allowed_user_meta_data_activation_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_allowed_user_meta_data_activation_user1 ON public.xdat_stored_search_allowed_user_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_stored_search_allowed_user_meta_data_activation_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_allowed_user_meta_data_activation_user1_hash ON public.xdat_stored_search_allowed_user_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_stored_search_allowed_user_meta_data_insert_user_xda1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_allowed_user_meta_data_insert_user_xda1 ON public.xdat_stored_search_allowed_user_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_stored_search_allowed_user_meta_data_insert_user_xda1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_allowed_user_meta_data_insert_user_xda1_hash ON public.xdat_stored_search_allowed_user_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_stored_search_allowed_user_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_allowed_user_meta_data_meta_data_id1_hash ON public.xdat_stored_search_allowed_user_meta_data USING hash (meta_data_id);


--
-- Name: xdat_stored_search_allowed_user_stored_search_allowed_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_allowed_user_stored_search_allowed_use1 ON public.xdat_stored_search_allowed_user USING btree (stored_search_allowed_user_info);


--
-- Name: xdat_stored_search_allowed_user_stored_search_allowed_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_allowed_user_stored_search_allowed_use1_hash ON public.xdat_stored_search_allowed_user USING hash (stored_search_allowed_user_info);


--
-- Name: xdat_stored_search_allowed_user_xdat_stored_search_allowe1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_allowed_user_xdat_stored_search_allowe1_hash ON public.xdat_stored_search_allowed_user USING hash (xdat_stored_search_allowed_user_id);


--
-- Name: xdat_stored_search_allowed_user_xdat_stored_search_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_allowed_user_xdat_stored_search_id1 ON public.xdat_stored_search_allowed_user USING btree (xdat_stored_search_id);


--
-- Name: xdat_stored_search_allowed_user_xdat_stored_search_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_allowed_user_xdat_stored_search_id1_hash ON public.xdat_stored_search_allowed_user USING hash (xdat_stored_search_id);


--
-- Name: xdat_stored_search_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_extension1 ON public.xdat_stored_search USING btree (extension);


--
-- Name: xdat_stored_search_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_extension1_hash ON public.xdat_stored_search USING hash (extension);


--
-- Name: xdat_stored_search_groupid_allowed_groups_groupid_xdat_st1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_groupid_allowed_groups_groupid_xdat_st1 ON public.xdat_stored_search_groupid USING btree (allowed_groups_groupid_xdat_sto_id);


--
-- Name: xdat_stored_search_groupid_allowed_groups_groupid_xdat_st1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_groupid_allowed_groups_groupid_xdat_st1_hash ON public.xdat_stored_search_groupid USING hash (allowed_groups_groupid_xdat_sto_id);


--
-- Name: xdat_stored_search_groupid_meta_data_activation_user_xdat1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_groupid_meta_data_activation_user_xdat1 ON public.xdat_stored_search_groupid_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_stored_search_groupid_meta_data_activation_user_xdat1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_groupid_meta_data_activation_user_xdat1_hash ON public.xdat_stored_search_groupid_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_stored_search_groupid_meta_data_insert_user_xdat_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_groupid_meta_data_insert_user_xdat_use1 ON public.xdat_stored_search_groupid_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_stored_search_groupid_meta_data_insert_user_xdat_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_groupid_meta_data_insert_user_xdat_use1_hash ON public.xdat_stored_search_groupid_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_stored_search_groupid_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_groupid_meta_data_meta_data_id1_hash ON public.xdat_stored_search_groupid_meta_data USING hash (meta_data_id);


--
-- Name: xdat_stored_search_groupid_stored_search_groupid_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_groupid_stored_search_groupid_info1 ON public.xdat_stored_search_groupid USING btree (stored_search_groupid_info);


--
-- Name: xdat_stored_search_groupid_stored_search_groupid_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_groupid_stored_search_groupid_info1_hash ON public.xdat_stored_search_groupid USING hash (stored_search_groupid_info);


--
-- Name: xdat_stored_search_groupid_xdat_stored_search_groupid_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_groupid_xdat_stored_search_groupid_id1_hash ON public.xdat_stored_search_groupid USING hash (xdat_stored_search_groupid_id);


--
-- Name: xdat_stored_search_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_id1_hash ON public.xdat_stored_search USING hash (id);


--
-- Name: xdat_stored_search_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_meta_data_activation_user_xdat_user_id1 ON public.xdat_stored_search_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_stored_search_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_stored_search_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_stored_search_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_meta_data_insert_user_xdat_user_id1 ON public.xdat_stored_search_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_stored_search_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_stored_search_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_stored_search_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_meta_data_meta_data_id1_hash ON public.xdat_stored_search_meta_data USING hash (meta_data_id);


--
-- Name: xdat_stored_search_stored_search_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_stored_search_info1 ON public.xdat_stored_search USING btree (stored_search_info);


--
-- Name: xdat_stored_search_stored_search_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_stored_search_stored_search_info1_hash ON public.xdat_stored_search USING hash (stored_search_info);


--
-- Name: xdat_user_groupid_groups_groupid_xdat_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_groupid_groups_groupid_xdat_user_xdat_user_id1 ON public.xdat_user_groupid USING btree (groups_groupid_xdat_user_xdat_user_id);


--
-- Name: xdat_user_groupid_groups_groupid_xdat_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_groupid_groups_groupid_xdat_user_xdat_user_id1_hash ON public.xdat_user_groupid USING hash (groups_groupid_xdat_user_xdat_user_id);


--
-- Name: xdat_user_groupid_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_groupid_meta_data_activation_user_xdat_user_id1 ON public.xdat_user_groupid_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_user_groupid_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_groupid_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_user_groupid_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_user_groupid_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_groupid_meta_data_insert_user_xdat_user_id1 ON public.xdat_user_groupid_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_user_groupid_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_groupid_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_user_groupid_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_user_groupid_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_groupid_meta_data_meta_data_id1_hash ON public.xdat_user_groupid_meta_data USING hash (meta_data_id);


--
-- Name: xdat_user_groupid_user_groupid_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_groupid_user_groupid_info1 ON public.xdat_user_groupid USING btree (user_groupid_info);


--
-- Name: xdat_user_groupid_user_groupid_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_groupid_user_groupid_info1_hash ON public.xdat_user_groupid USING hash (user_groupid_info);


--
-- Name: xdat_user_groupid_xdat_user_groupid_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_groupid_xdat_user_groupid_id1_hash ON public.xdat_user_groupid USING hash (xdat_user_groupid_id);


--
-- Name: xdat_user_login_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_login_meta_data_activation_user_xdat_user_id1 ON public.xdat_user_login_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_user_login_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_login_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_user_login_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_user_login_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_login_meta_data_insert_user_xdat_user_id1 ON public.xdat_user_login_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_user_login_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_login_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_user_login_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_user_login_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_login_meta_data_meta_data_id1_hash ON public.xdat_user_login_meta_data USING hash (meta_data_id);


--
-- Name: xdat_user_login_user_login_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_login_user_login_info1 ON public.xdat_user_login USING btree (user_login_info);


--
-- Name: xdat_user_login_user_login_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_login_user_login_info1_hash ON public.xdat_user_login USING hash (user_login_info);


--
-- Name: xdat_user_login_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_login_user_xdat_user_id1 ON public.xdat_user_login USING btree (user_xdat_user_id);


--
-- Name: xdat_user_login_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_login_user_xdat_user_id1_hash ON public.xdat_user_login USING hash (user_xdat_user_id);


--
-- Name: xdat_user_login_xdat_user_login_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_login_xdat_user_login_id1_hash ON public.xdat_user_login USING hash (xdat_user_login_id);


--
-- Name: xdat_user_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_meta_data_activation_user_xdat_user_id1 ON public.xdat_user_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_user_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_user_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_user_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_meta_data_insert_user_xdat_user_id1 ON public.xdat_user_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_user_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_user_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_user_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_meta_data_meta_data_id1_hash ON public.xdat_user_meta_data USING hash (meta_data_id);


--
-- Name: xdat_user_user_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_user_info1 ON public.xdat_user USING btree (user_info);


--
-- Name: xdat_user_user_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_user_info1_hash ON public.xdat_user USING hash (user_info);


--
-- Name: xdat_user_users_user_xdat_security_xdat_security_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_users_user_xdat_security_xdat_security_id1 ON public.xdat_user USING btree (users_user_xdat_security_xdat_security_id);


--
-- Name: xdat_user_users_user_xdat_security_xdat_security_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_users_user_xdat_security_xdat_security_id1_hash ON public.xdat_user USING hash (users_user_xdat_security_xdat_security_id);


--
-- Name: xdat_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_user_xdat_user_id1_hash ON public.xdat_user USING hash (xdat_user_id);


--
-- Name: xdat_usergroup_groups_group_xdat_security_xdat_security_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_usergroup_groups_group_xdat_security_xdat_security_i1 ON public.xdat_usergroup USING btree (groups_group_xdat_security_xdat_security_id);


--
-- Name: xdat_usergroup_groups_group_xdat_security_xdat_security_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_usergroup_groups_group_xdat_security_xdat_security_i1_hash ON public.xdat_usergroup USING hash (groups_group_xdat_security_xdat_security_id);


--
-- Name: xdat_usergroup_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_usergroup_meta_data_activation_user_xdat_user_id1 ON public.xdat_usergroup_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xdat_usergroup_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_usergroup_meta_data_activation_user_xdat_user_id1_hash ON public.xdat_usergroup_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xdat_usergroup_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_usergroup_meta_data_insert_user_xdat_user_id1 ON public.xdat_usergroup_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xdat_usergroup_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_usergroup_meta_data_insert_user_xdat_user_id1_hash ON public.xdat_usergroup_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xdat_usergroup_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_usergroup_meta_data_meta_data_id1_hash ON public.xdat_usergroup_meta_data USING hash (meta_data_id);


--
-- Name: xdat_usergroup_usergroup_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_usergroup_usergroup_info1 ON public.xdat_usergroup USING btree (usergroup_info);


--
-- Name: xdat_usergroup_usergroup_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_usergroup_usergroup_info1_hash ON public.xdat_usergroup USING hash (usergroup_info);


--
-- Name: xdat_usergroup_xdat_usergroup_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xdat_usergroup_xdat_usergroup_id1_hash ON public.xdat_usergroup USING hash (xdat_usergroup_id);


--
-- Name: xnat_a_scidresearchdata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_scidresearchdata_id1 ON public.xnat_a_scidresearchdata USING btree (id);


--
-- Name: xnat_a_scidresearchdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_scidresearchdata_id1_hash ON public.xnat_a_scidresearchdata USING hash (id);


--
-- Name: xnat_a_scidresearchdata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_scidresearchdata_id2_hash ON public.xnat_a_scidresearchdata USING hash (id);


--
-- Name: xnat_a_scidresearchdata_meta_data_activation_user_xdat_us1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_scidresearchdata_meta_data_activation_user_xdat_us1 ON public.xnat_a_scidresearchdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_a_scidresearchdata_meta_data_activation_user_xdat_us1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_scidresearchdata_meta_data_activation_user_xdat_us1_hash ON public.xnat_a_scidresearchdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_a_scidresearchdata_meta_data_insert_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_scidresearchdata_meta_data_insert_user_xdat_user_i1 ON public.xnat_a_scidresearchdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_a_scidresearchdata_meta_data_insert_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_scidresearchdata_meta_data_insert_user_xdat_user_i1_hash ON public.xnat_a_scidresearchdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_a_scidresearchdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_scidresearchdata_meta_data_meta_data_id1_hash ON public.xnat_a_scidresearchdata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_a_scidresearchdata_scidresearchdata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_scidresearchdata_scidresearchdata_info1 ON public.xnat_a_scidresearchdata USING btree (scidresearchdata_info);


--
-- Name: xnat_a_scidresearchdata_scidresearchdata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_scidresearchdata_scidresearchdata_info1_hash ON public.xnat_a_scidresearchdata USING hash (scidresearchdata_info);


--
-- Name: xnat_a_sideeffectspittsburghdata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_sideeffectspittsburghdata_id1 ON public.xnat_a_sideeffectspittsburghdata USING btree (id);


--
-- Name: xnat_a_sideeffectspittsburghdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_sideeffectspittsburghdata_id1_hash ON public.xnat_a_sideeffectspittsburghdata USING hash (id);


--
-- Name: xnat_a_sideeffectspittsburghdata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_sideeffectspittsburghdata_id2_hash ON public.xnat_a_sideeffectspittsburghdata USING hash (id);


--
-- Name: xnat_a_sideeffectspittsburghdata_meta_data_activation_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_sideeffectspittsburghdata_meta_data_activation_use1 ON public.xnat_a_sideeffectspittsburghdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_a_sideeffectspittsburghdata_meta_data_activation_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_sideeffectspittsburghdata_meta_data_activation_use1_hash ON public.xnat_a_sideeffectspittsburghdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_a_sideeffectspittsburghdata_meta_data_insert_user_xd1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_sideeffectspittsburghdata_meta_data_insert_user_xd1 ON public.xnat_a_sideeffectspittsburghdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_a_sideeffectspittsburghdata_meta_data_insert_user_xd1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_sideeffectspittsburghdata_meta_data_insert_user_xd1_hash ON public.xnat_a_sideeffectspittsburghdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_a_sideeffectspittsburghdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_sideeffectspittsburghdata_meta_data_meta_data_id1_hash ON public.xnat_a_sideeffectspittsburghdata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_a_sideeffectspittsburghdata_sideeffectspittsburghdat1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_sideeffectspittsburghdata_sideeffectspittsburghdat1 ON public.xnat_a_sideeffectspittsburghdata USING btree (sideeffectspittsburghdata_info);


--
-- Name: xnat_a_sideeffectspittsburghdata_sideeffectspittsburghdat1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_sideeffectspittsburghdata_sideeffectspittsburghdat1_hash ON public.xnat_a_sideeffectspittsburghdata USING hash (sideeffectspittsburghdata_info);


--
-- Name: xnat_a_updrs3data_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_updrs3data_id1 ON public.xnat_a_updrs3data USING btree (id);


--
-- Name: xnat_a_updrs3data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_updrs3data_id1_hash ON public.xnat_a_updrs3data USING hash (id);


--
-- Name: xnat_a_updrs3data_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_updrs3data_id2_hash ON public.xnat_a_updrs3data USING hash (id);


--
-- Name: xnat_a_updrs3data_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_updrs3data_meta_data_activation_user_xdat_user_id1 ON public.xnat_a_updrs3data_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_a_updrs3data_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_updrs3data_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_a_updrs3data_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_a_updrs3data_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_updrs3data_meta_data_insert_user_xdat_user_id1 ON public.xnat_a_updrs3data_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_a_updrs3data_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_updrs3data_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_a_updrs3data_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_a_updrs3data_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_updrs3data_meta_data_meta_data_id1_hash ON public.xnat_a_updrs3data_meta_data USING hash (meta_data_id);


--
-- Name: xnat_a_updrs3data_updrs3data_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_updrs3data_updrs3data_info1 ON public.xnat_a_updrs3data USING btree (updrs3data_info);


--
-- Name: xnat_a_updrs3data_updrs3data_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_updrs3data_updrs3data_info1_hash ON public.xnat_a_updrs3data USING hash (updrs3data_info);


--
-- Name: xnat_a_ybocsdata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ybocsdata_id1 ON public.xnat_a_ybocsdata USING btree (id);


--
-- Name: xnat_a_ybocsdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ybocsdata_id1_hash ON public.xnat_a_ybocsdata USING hash (id);


--
-- Name: xnat_a_ybocsdata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ybocsdata_id2_hash ON public.xnat_a_ybocsdata USING hash (id);


--
-- Name: xnat_a_ybocsdata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ybocsdata_meta_data_activation_user_xdat_user_id1 ON public.xnat_a_ybocsdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_a_ybocsdata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ybocsdata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_a_ybocsdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_a_ybocsdata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ybocsdata_meta_data_insert_user_xdat_user_id1 ON public.xnat_a_ybocsdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_a_ybocsdata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ybocsdata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_a_ybocsdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_a_ybocsdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ybocsdata_meta_data_meta_data_id1_hash ON public.xnat_a_ybocsdata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_a_ybocsdata_ybocsdata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ybocsdata_ybocsdata_info1 ON public.xnat_a_ybocsdata USING btree (ybocsdata_info);


--
-- Name: xnat_a_ybocsdata_ybocsdata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ybocsdata_ybocsdata_info1_hash ON public.xnat_a_ybocsdata USING hash (ybocsdata_info);


--
-- Name: xnat_a_ygtssdata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ygtssdata_id1 ON public.xnat_a_ygtssdata USING btree (id);


--
-- Name: xnat_a_ygtssdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ygtssdata_id1_hash ON public.xnat_a_ygtssdata USING hash (id);


--
-- Name: xnat_a_ygtssdata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ygtssdata_id2_hash ON public.xnat_a_ygtssdata USING hash (id);


--
-- Name: xnat_a_ygtssdata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ygtssdata_meta_data_activation_user_xdat_user_id1 ON public.xnat_a_ygtssdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_a_ygtssdata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ygtssdata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_a_ygtssdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_a_ygtssdata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ygtssdata_meta_data_insert_user_xdat_user_id1 ON public.xnat_a_ygtssdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_a_ygtssdata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ygtssdata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_a_ygtssdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_a_ygtssdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ygtssdata_meta_data_meta_data_id1_hash ON public.xnat_a_ygtssdata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_a_ygtssdata_ygtssdata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ygtssdata_ygtssdata_info1 ON public.xnat_a_ygtssdata USING btree (ygtssdata_info);


--
-- Name: xnat_a_ygtssdata_ygtssdata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_a_ygtssdata_ygtssdata_info1_hash ON public.xnat_a_ygtssdata USING hash (ygtssdata_info);


--
-- Name: xnat_abstractdemographicdata_abstractdemographicdata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractdemographicdata_abstractdemographicdata_info1 ON public.xnat_abstractdemographicdata USING btree (abstractdemographicdata_info);


--
-- Name: xnat_abstractdemographicdata_abstractdemographicdata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractdemographicdata_abstractdemographicdata_info1_hash ON public.xnat_abstractdemographicdata USING hash (abstractdemographicdata_info);


--
-- Name: xnat_abstractdemographicdata_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractdemographicdata_extension1 ON public.xnat_abstractdemographicdata USING btree (extension);


--
-- Name: xnat_abstractdemographicdata_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractdemographicdata_extension1_hash ON public.xnat_abstractdemographicdata USING hash (extension);


--
-- Name: xnat_abstractdemographicdata_meta_data_activation_user_xd1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractdemographicdata_meta_data_activation_user_xd1 ON public.xnat_abstractdemographicdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_abstractdemographicdata_meta_data_activation_user_xd1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractdemographicdata_meta_data_activation_user_xd1_hash ON public.xnat_abstractdemographicdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_abstractdemographicdata_meta_data_insert_user_xdat_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractdemographicdata_meta_data_insert_user_xdat_u1 ON public.xnat_abstractdemographicdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_abstractdemographicdata_meta_data_insert_user_xdat_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractdemographicdata_meta_data_insert_user_xdat_u1_hash ON public.xnat_abstractdemographicdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_abstractdemographicdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractdemographicdata_meta_data_meta_data_id1_hash ON public.xnat_abstractdemographicdata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_abstractdemographicdata_xnat_abstractdemographicdata1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractdemographicdata_xnat_abstractdemographicdata1_hash ON public.xnat_abstractdemographicdata USING hash (xnat_abstractdemographicdata_id);


--
-- Name: xnat_abstractprotocol_abstractprotocol_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_abstractprotocol_info1 ON public.xnat_abstractprotocol USING btree (abstractprotocol_info);


--
-- Name: xnat_abstractprotocol_abstractprotocol_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_abstractprotocol_info1_hash ON public.xnat_abstractprotocol USING hash (abstractprotocol_info);


--
-- Name: xnat_abstractprotocol_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_extension1 ON public.xnat_abstractprotocol USING btree (extension);


--
-- Name: xnat_abstractprotocol_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_extension1_hash ON public.xnat_abstractprotocol USING hash (extension);


--
-- Name: xnat_abstractprotocol_meta_data_activation_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_meta_data_activation_user_xdat_user1 ON public.xnat_abstractprotocol_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_abstractprotocol_meta_data_activation_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_meta_data_activation_user_xdat_user1_hash ON public.xnat_abstractprotocol_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_abstractprotocol_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_meta_data_insert_user_xdat_user_id1 ON public.xnat_abstractprotocol_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_abstractprotocol_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_abstractprotocol_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_abstractprotocol_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_meta_data_meta_data_id1_hash ON public.xnat_abstractprotocol_meta_data USING hash (meta_data_id);


--
-- Name: xnat_abstractprotocol_xnat_abstractprotocol_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_xnat_abstractprotocol_id1_hash ON public.xnat_abstractprotocol USING hash (xnat_abstractprotocol_id);


--
-- Name: xnat_abstractprotocol_xnat_projectdata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_xnat_projectdata_id1 ON public.xnat_abstractprotocol USING btree (xnat_projectdata_id);


--
-- Name: xnat_abstractprotocol_xnat_projectdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractprotocol_xnat_projectdata_id1_hash ON public.xnat_abstractprotocol USING hash (xnat_projectdata_id);


--
-- Name: xnat_abstractresource_abstractresource_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_abstractresource_info1 ON public.xnat_abstractresource USING btree (abstractresource_info);


--
-- Name: xnat_abstractresource_abstractresource_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_abstractresource_info1_hash ON public.xnat_abstractresource USING hash (abstractresource_info);


--
-- Name: xnat_abstractresource_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_extension1 ON public.xnat_abstractresource USING btree (extension);


--
-- Name: xnat_abstractresource_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_extension1_hash ON public.xnat_abstractresource USING hash (extension);


--
-- Name: xnat_abstractresource_meta_data_activation_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_meta_data_activation_user_xdat_user1 ON public.xnat_abstractresource_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_abstractresource_meta_data_activation_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_meta_data_activation_user_xdat_user1_hash ON public.xnat_abstractresource_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_abstractresource_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_meta_data_insert_user_xdat_user_id1 ON public.xnat_abstractresource_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_abstractresource_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_abstractresource_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_abstractresource_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_meta_data_meta_data_id1_hash ON public.xnat_abstractresource_meta_data USING hash (meta_data_id);


--
-- Name: xnat_abstractresource_tag_abstractresource_tag_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_tag_abstractresource_tag_info1 ON public.xnat_abstractresource_tag USING btree (abstractresource_tag_info);


--
-- Name: xnat_abstractresource_tag_abstractresource_tag_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_tag_abstractresource_tag_info1_hash ON public.xnat_abstractresource_tag USING hash (abstractresource_tag_info);


--
-- Name: xnat_abstractresource_tag_meta_data_activation_user_xdat_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_tag_meta_data_activation_user_xdat_1 ON public.xnat_abstractresource_tag_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_abstractresource_tag_meta_data_activation_user_xdat_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_tag_meta_data_activation_user_xdat_1_hash ON public.xnat_abstractresource_tag_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_abstractresource_tag_meta_data_insert_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_tag_meta_data_insert_user_xdat_user1 ON public.xnat_abstractresource_tag_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_abstractresource_tag_meta_data_insert_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_tag_meta_data_insert_user_xdat_user1_hash ON public.xnat_abstractresource_tag_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_abstractresource_tag_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_tag_meta_data_meta_data_id1_hash ON public.xnat_abstractresource_tag_meta_data USING hash (meta_data_id);


--
-- Name: xnat_abstractresource_tag_tags_tag_xnat_abstractresource_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_tag_tags_tag_xnat_abstractresource_1 ON public.xnat_abstractresource_tag USING btree (tags_tag_xnat_abstractresource_xnat_abstractresource_id);


--
-- Name: xnat_abstractresource_tag_tags_tag_xnat_abstractresource_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_tag_tags_tag_xnat_abstractresource_1_hash ON public.xnat_abstractresource_tag USING hash (tags_tag_xnat_abstractresource_xnat_abstractresource_id);


--
-- Name: xnat_abstractresource_tag_xnat_abstractresource_tag_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_tag_xnat_abstractresource_tag_id1_hash ON public.xnat_abstractresource_tag USING hash (xnat_abstractresource_tag_id);


--
-- Name: xnat_abstractresource_xnat_abstractresource_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_xnat_abstractresource_id1_hash ON public.xnat_abstractresource USING hash (xnat_abstractresource_id);


--
-- Name: xnat_abstractresource_xnat_imagescandata_xnat_imagescanda1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_xnat_imagescandata_xnat_imagescanda1 ON public.xnat_abstractresource USING btree (xnat_imagescandata_xnat_imagescandata_id);


--
-- Name: xnat_abstractresource_xnat_imagescandata_xnat_imagescanda1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractresource_xnat_imagescandata_xnat_imagescanda1_hash ON public.xnat_abstractresource USING hash (xnat_imagescandata_xnat_imagescandata_id);


--
-- Name: xnat_abstractstatistics_abstractstatistics_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractstatistics_abstractstatistics_info1 ON public.xnat_abstractstatistics USING btree (abstractstatistics_info);


--
-- Name: xnat_abstractstatistics_abstractstatistics_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractstatistics_abstractstatistics_info1_hash ON public.xnat_abstractstatistics USING hash (abstractstatistics_info);


--
-- Name: xnat_abstractstatistics_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractstatistics_extension1 ON public.xnat_abstractstatistics USING btree (extension);


--
-- Name: xnat_abstractstatistics_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractstatistics_extension1_hash ON public.xnat_abstractstatistics USING hash (extension);


--
-- Name: xnat_abstractstatistics_meta_data_activation_user_xdat_us1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractstatistics_meta_data_activation_user_xdat_us1 ON public.xnat_abstractstatistics_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_abstractstatistics_meta_data_activation_user_xdat_us1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractstatistics_meta_data_activation_user_xdat_us1_hash ON public.xnat_abstractstatistics_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_abstractstatistics_meta_data_insert_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractstatistics_meta_data_insert_user_xdat_user_i1 ON public.xnat_abstractstatistics_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_abstractstatistics_meta_data_insert_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractstatistics_meta_data_insert_user_xdat_user_i1_hash ON public.xnat_abstractstatistics_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_abstractstatistics_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractstatistics_meta_data_meta_data_id1_hash ON public.xnat_abstractstatistics_meta_data USING hash (meta_data_id);


--
-- Name: xnat_abstractstatistics_xnat_abstractstatistics_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractstatistics_xnat_abstractstatistics_id1_hash ON public.xnat_abstractstatistics USING hash (xnat_abstractstatistics_id);


--
-- Name: xnat_abstractsubjectmetadata_abstractsubjectmetadata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractsubjectmetadata_abstractsubjectmetadata_info1 ON public.xnat_abstractsubjectmetadata USING btree (abstractsubjectmetadata_info);


--
-- Name: xnat_abstractsubjectmetadata_abstractsubjectmetadata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractsubjectmetadata_abstractsubjectmetadata_info1_hash ON public.xnat_abstractsubjectmetadata USING hash (abstractsubjectmetadata_info);


--
-- Name: xnat_abstractsubjectmetadata_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractsubjectmetadata_extension1 ON public.xnat_abstractsubjectmetadata USING btree (extension);


--
-- Name: xnat_abstractsubjectmetadata_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractsubjectmetadata_extension1_hash ON public.xnat_abstractsubjectmetadata USING hash (extension);


--
-- Name: xnat_abstractsubjectmetadata_meta_data_activation_user_xd1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractsubjectmetadata_meta_data_activation_user_xd1 ON public.xnat_abstractsubjectmetadata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_abstractsubjectmetadata_meta_data_activation_user_xd1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractsubjectmetadata_meta_data_activation_user_xd1_hash ON public.xnat_abstractsubjectmetadata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_abstractsubjectmetadata_meta_data_insert_user_xdat_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractsubjectmetadata_meta_data_insert_user_xdat_u1 ON public.xnat_abstractsubjectmetadata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_abstractsubjectmetadata_meta_data_insert_user_xdat_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractsubjectmetadata_meta_data_insert_user_xdat_u1_hash ON public.xnat_abstractsubjectmetadata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_abstractsubjectmetadata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractsubjectmetadata_meta_data_meta_data_id1_hash ON public.xnat_abstractsubjectmetadata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_abstractsubjectmetadata_xnat_abstractsubjectmetadata1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_abstractsubjectmetadata_xnat_abstractsubjectmetadata1_hash ON public.xnat_abstractsubjectmetadata USING hash (xnat_abstractsubjectmetadata_id);


--
-- Name: xnat_addfield_addfield_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_addfield_info1 ON public.xnat_addfield USING btree (addfield_info);


--
-- Name: xnat_addfield_addfield_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_addfield_info1_hash ON public.xnat_addfield USING hash (addfield_info);


--
-- Name: xnat_addfield_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_meta_data_activation_user_xdat_user_id1 ON public.xnat_addfield_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_addfield_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_addfield_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_addfield_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_meta_data_insert_user_xdat_user_id1 ON public.xnat_addfield_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_addfield_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_addfield_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_addfield_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_meta_data_meta_data_id1_hash ON public.xnat_addfield_meta_data USING hash (meta_data_id);


--
-- Name: xnat_addfield_parameters_addparam_xnat_imagea_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_parameters_addparam_xnat_imagea_id1 ON public.xnat_addfield USING btree (parameters_addparam_xnat_imagea_id);


--
-- Name: xnat_addfield_parameters_addparam_xnat_imagea_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_parameters_addparam_xnat_imagea_id1_hash ON public.xnat_addfield USING hash (parameters_addparam_xnat_imagea_id);


--
-- Name: xnat_addfield_parameters_addparam_xnat_mrscan_xnat_images1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_parameters_addparam_xnat_mrscan_xnat_images1 ON public.xnat_addfield USING btree (parameters_addparam_xnat_mrscan_xnat_imagescandata_id);


--
-- Name: xnat_addfield_parameters_addparam_xnat_mrscan_xnat_images1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_parameters_addparam_xnat_mrscan_xnat_images1_hash ON public.xnat_addfield USING hash (parameters_addparam_xnat_mrscan_xnat_imagescandata_id);


--
-- Name: xnat_addfield_parameters_addparam_xnat_petsca_xnat_images1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_parameters_addparam_xnat_petsca_xnat_images1 ON public.xnat_addfield USING btree (parameters_addparam_xnat_petsca_xnat_imagescandata_id);


--
-- Name: xnat_addfield_parameters_addparam_xnat_petsca_xnat_images1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_parameters_addparam_xnat_petsca_xnat_images1_hash ON public.xnat_addfield USING hash (parameters_addparam_xnat_petsca_xnat_imagescandata_id);


--
-- Name: xnat_addfield_parameters_addparam_xnat_recons_xnat_recons1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_parameters_addparam_xnat_recons_xnat_recons1 ON public.xnat_addfield USING btree (parameters_addparam_xnat_recons_xnat_reconstructedimagedata_id);


--
-- Name: xnat_addfield_parameters_addparam_xnat_recons_xnat_recons1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_parameters_addparam_xnat_recons_xnat_recons1_hash ON public.xnat_addfield USING hash (parameters_addparam_xnat_recons_xnat_reconstructedimagedata_id);


--
-- Name: xnat_addfield_xnat_addfield_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_addfield_xnat_addfield_id1_hash ON public.xnat_addfield USING hash (xnat_addfield_id);


--
-- Name: xnat_algorithm_algorithm_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_algorithm_info1 ON public.xnat_algorithm USING btree (algorithm_info);


--
-- Name: xnat_algorithm_algorithm_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_algorithm_info1_hash ON public.xnat_algorithm USING hash (algorithm_info);


--
-- Name: xnat_algorithm_family_xnat_dicomcodedvalue_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_family_xnat_dicomcodedvalue_id1 ON public.xnat_algorithm USING btree (family_xnat_dicomcodedvalue_id);


--
-- Name: xnat_algorithm_family_xnat_dicomcodedvalue_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_family_xnat_dicomcodedvalue_id1_hash ON public.xnat_algorithm USING hash (family_xnat_dicomcodedvalue_id);


--
-- Name: xnat_algorithm_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_meta_data_activation_user_xdat_user_id1 ON public.xnat_algorithm_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_algorithm_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_algorithm_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_algorithm_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_meta_data_insert_user_xdat_user_id1 ON public.xnat_algorithm_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_algorithm_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_algorithm_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_algorithm_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_meta_data_meta_data_id1_hash ON public.xnat_algorithm_meta_data USING hash (meta_data_id);


--
-- Name: xnat_algorithm_namecode_xnat_dicomcodedvalue_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_namecode_xnat_dicomcodedvalue_id1 ON public.xnat_algorithm USING btree (namecode_xnat_dicomcodedvalue_id);


--
-- Name: xnat_algorithm_namecode_xnat_dicomcodedvalue_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_namecode_xnat_dicomcodedvalue_id1_hash ON public.xnat_algorithm USING hash (namecode_xnat_dicomcodedvalue_id);


--
-- Name: xnat_algorithm_xnat_algorithm_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_algorithm_xnat_algorithm_id1_hash ON public.xnat_algorithm USING hash (xnat_algorithm_id);


--
-- Name: xnat_computationdata_computationdata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_computationdata_computationdata_info1 ON public.xnat_computationdata USING btree (computationdata_info);


--
-- Name: xnat_computationdata_computationdata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_computationdata_computationdata_info1_hash ON public.xnat_computationdata USING hash (computationdata_info);


--
-- Name: xnat_computationdata_computations_datum_xnat_reconst_xnat1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_computationdata_computations_datum_xnat_reconst_xnat1 ON public.xnat_computationdata USING btree (computations_datum_xnat_reconst_xnat_reconstructedimagedata_id);


--
-- Name: xnat_computationdata_computations_datum_xnat_reconst_xnat1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_computationdata_computations_datum_xnat_reconst_xnat1_hash ON public.xnat_computationdata USING hash (computations_datum_xnat_reconst_xnat_reconstructedimagedata_id);


--
-- Name: xnat_computationdata_meta_data_activation_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_computationdata_meta_data_activation_user_xdat_user_1 ON public.xnat_computationdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_computationdata_meta_data_activation_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_computationdata_meta_data_activation_user_xdat_user_1_hash ON public.xnat_computationdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_computationdata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_computationdata_meta_data_insert_user_xdat_user_id1 ON public.xnat_computationdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_computationdata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_computationdata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_computationdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_computationdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_computationdata_meta_data_meta_data_id1_hash ON public.xnat_computationdata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_computationdata_xnat_computationdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_computationdata_xnat_computationdata_id1_hash ON public.xnat_computationdata USING hash (xnat_computationdata_id);


--
-- Name: xnat_contrastbolus_contrastbolus_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_contrastbolus_contrastbolus_info1 ON public.xnat_contrastbolus USING btree (contrastbolus_info);


--
-- Name: xnat_contrastbolus_contrastbolus_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_contrastbolus_contrastbolus_info1_hash ON public.xnat_contrastbolus USING hash (contrastbolus_info);


--
-- Name: xnat_contrastbolus_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_contrastbolus_meta_data_activation_user_xdat_user_id1 ON public.xnat_contrastbolus_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_contrastbolus_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_contrastbolus_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_contrastbolus_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_contrastbolus_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_contrastbolus_meta_data_insert_user_xdat_user_id1 ON public.xnat_contrastbolus_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_contrastbolus_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_contrastbolus_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_contrastbolus_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_contrastbolus_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_contrastbolus_meta_data_meta_data_id1_hash ON public.xnat_contrastbolus_meta_data USING hash (meta_data_id);


--
-- Name: xnat_contrastbolus_xnat_contrastbolus_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_contrastbolus_xnat_contrastbolus_id1_hash ON public.xnat_contrastbolus USING hash (xnat_contrastbolus_id);


--
-- Name: xnat_crscandata_crscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crscandata_crscandata_info1 ON public.xnat_crscandata USING btree (crscandata_info);


--
-- Name: xnat_crscandata_crscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crscandata_crscandata_info1_hash ON public.xnat_crscandata USING hash (crscandata_info);


--
-- Name: xnat_crscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_crscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_crscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_crscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_crscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_crscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_crscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_crscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_crscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crscandata_meta_data_meta_data_id1_hash ON public.xnat_crscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_crscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crscandata_xnat_imagescandata_id1 ON public.xnat_crscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_crscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crscandata_xnat_imagescandata_id1_hash ON public.xnat_crscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_crscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crscandata_xnat_imagescandata_id2_hash ON public.xnat_crscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_crsessiondata_crsessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crsessiondata_crsessiondata_info1 ON public.xnat_crsessiondata USING btree (crsessiondata_info);


--
-- Name: xnat_crsessiondata_crsessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crsessiondata_crsessiondata_info1_hash ON public.xnat_crsessiondata USING hash (crsessiondata_info);


--
-- Name: xnat_crsessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crsessiondata_id1 ON public.xnat_crsessiondata USING btree (id);


--
-- Name: xnat_crsessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crsessiondata_id1_hash ON public.xnat_crsessiondata USING hash (id);


--
-- Name: xnat_crsessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crsessiondata_id2_hash ON public.xnat_crsessiondata USING hash (id);


--
-- Name: xnat_crsessiondata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crsessiondata_meta_data_activation_user_xdat_user_id1 ON public.xnat_crsessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_crsessiondata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crsessiondata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_crsessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_crsessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crsessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_crsessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_crsessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crsessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_crsessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_crsessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_crsessiondata_meta_data_meta_data_id1_hash ON public.xnat_crsessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_ctscandata_ctscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_ctscandata_info1 ON public.xnat_ctscandata USING btree (ctscandata_info);


--
-- Name: xnat_ctscandata_ctscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_ctscandata_info1_hash ON public.xnat_ctscandata USING hash (ctscandata_info);


--
-- Name: xnat_ctscandata_focalspot_ctscandata_focalspot_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_focalspot_ctscandata_focalspot_info1 ON public.xnat_ctscandata_focalspot USING btree (ctscandata_focalspot_info);


--
-- Name: xnat_ctscandata_focalspot_ctscandata_focalspot_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_focalspot_ctscandata_focalspot_info1_hash ON public.xnat_ctscandata_focalspot USING hash (ctscandata_focalspot_info);


--
-- Name: xnat_ctscandata_focalspot_meta_data_activation_user_xdat_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_focalspot_meta_data_activation_user_xdat_1 ON public.xnat_ctscandata_focalspot_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_ctscandata_focalspot_meta_data_activation_user_xdat_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_focalspot_meta_data_activation_user_xdat_1_hash ON public.xnat_ctscandata_focalspot_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_ctscandata_focalspot_meta_data_insert_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_focalspot_meta_data_insert_user_xdat_user1 ON public.xnat_ctscandata_focalspot_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_ctscandata_focalspot_meta_data_insert_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_focalspot_meta_data_insert_user_xdat_user1_hash ON public.xnat_ctscandata_focalspot_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_ctscandata_focalspot_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_focalspot_meta_data_meta_data_id1_hash ON public.xnat_ctscandata_focalspot_meta_data USING hash (meta_data_id);


--
-- Name: xnat_ctscandata_focalspot_parameters_focalspots_focalspot1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_focalspot_parameters_focalspots_focalspot1 ON public.xnat_ctscandata_focalspot USING btree (parameters_focalspots_focalspot_xnat_imagescandata_id);


--
-- Name: xnat_ctscandata_focalspot_parameters_focalspots_focalspot1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_focalspot_parameters_focalspots_focalspot1_hash ON public.xnat_ctscandata_focalspot USING hash (parameters_focalspots_focalspot_xnat_imagescandata_id);


--
-- Name: xnat_ctscandata_focalspot_xnat_ctscandata_focalspot_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_focalspot_xnat_ctscandata_focalspot_id1_hash ON public.xnat_ctscandata_focalspot USING hash (xnat_ctscandata_focalspot_id);


--
-- Name: xnat_ctscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_ctscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_ctscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_ctscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_ctscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_ctscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_ctscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_ctscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_ctscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_meta_data_meta_data_id1_hash ON public.xnat_ctscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_ctscandata_parameters_contrastbolus_xnat_contrastbol1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_parameters_contrastbolus_xnat_contrastbol1 ON public.xnat_ctscandata USING btree (parameters_contrastbolus_xnat_contrastbolus_id);


--
-- Name: xnat_ctscandata_parameters_contrastbolus_xnat_contrastbol1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_parameters_contrastbolus_xnat_contrastbol1_hash ON public.xnat_ctscandata USING hash (parameters_contrastbolus_xnat_contrastbolus_id);


--
-- Name: xnat_ctscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_xnat_imagescandata_id1 ON public.xnat_ctscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_ctscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_xnat_imagescandata_id1_hash ON public.xnat_ctscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_ctscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctscandata_xnat_imagescandata_id2_hash ON public.xnat_ctscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_ctsessiondata_ctsessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctsessiondata_ctsessiondata_info1 ON public.xnat_ctsessiondata USING btree (ctsessiondata_info);


--
-- Name: xnat_ctsessiondata_ctsessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctsessiondata_ctsessiondata_info1_hash ON public.xnat_ctsessiondata USING hash (ctsessiondata_info);


--
-- Name: xnat_ctsessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctsessiondata_id1 ON public.xnat_ctsessiondata USING btree (id);


--
-- Name: xnat_ctsessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctsessiondata_id1_hash ON public.xnat_ctsessiondata USING hash (id);


--
-- Name: xnat_ctsessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctsessiondata_id2_hash ON public.xnat_ctsessiondata USING hash (id);


--
-- Name: xnat_ctsessiondata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctsessiondata_meta_data_activation_user_xdat_user_id1 ON public.xnat_ctsessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_ctsessiondata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctsessiondata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_ctsessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_ctsessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctsessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_ctsessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_ctsessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctsessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_ctsessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_ctsessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ctsessiondata_meta_data_meta_data_id1_hash ON public.xnat_ctsessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_datatypeprotocol_datatypeprotocol_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_datatypeprotocol_datatypeprotocol_info1 ON public.xnat_datatypeprotocol USING btree (datatypeprotocol_info);


--
-- Name: xnat_datatypeprotocol_datatypeprotocol_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_datatypeprotocol_datatypeprotocol_info1_hash ON public.xnat_datatypeprotocol USING hash (datatypeprotocol_info);


--
-- Name: xnat_datatypeprotocol_meta_data_activation_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_datatypeprotocol_meta_data_activation_user_xdat_user1 ON public.xnat_datatypeprotocol_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_datatypeprotocol_meta_data_activation_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_datatypeprotocol_meta_data_activation_user_xdat_user1_hash ON public.xnat_datatypeprotocol_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_datatypeprotocol_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_datatypeprotocol_meta_data_insert_user_xdat_user_id1 ON public.xnat_datatypeprotocol_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_datatypeprotocol_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_datatypeprotocol_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_datatypeprotocol_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_datatypeprotocol_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_datatypeprotocol_meta_data_meta_data_id1_hash ON public.xnat_datatypeprotocol_meta_data USING hash (meta_data_id);


--
-- Name: xnat_datatypeprotocol_xnat_abstractprotocol_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_datatypeprotocol_xnat_abstractprotocol_id1 ON public.xnat_datatypeprotocol USING btree (xnat_abstractprotocol_id);


--
-- Name: xnat_datatypeprotocol_xnat_abstractprotocol_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_datatypeprotocol_xnat_abstractprotocol_id1_hash ON public.xnat_datatypeprotocol USING hash (xnat_abstractprotocol_id);


--
-- Name: xnat_datatypeprotocol_xnat_abstractprotocol_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_datatypeprotocol_xnat_abstractprotocol_id2_hash ON public.xnat_datatypeprotocol USING hash (xnat_abstractprotocol_id);


--
-- Name: xnat_demographicdata_demographicdata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_demographicdata_demographicdata_info1 ON public.xnat_demographicdata USING btree (demographicdata_info);


--
-- Name: xnat_demographicdata_demographicdata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_demographicdata_demographicdata_info1_hash ON public.xnat_demographicdata USING hash (demographicdata_info);


--
-- Name: xnat_demographicdata_meta_data_activation_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_demographicdata_meta_data_activation_user_xdat_user_1 ON public.xnat_demographicdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_demographicdata_meta_data_activation_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_demographicdata_meta_data_activation_user_xdat_user_1_hash ON public.xnat_demographicdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_demographicdata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_demographicdata_meta_data_insert_user_xdat_user_id1 ON public.xnat_demographicdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_demographicdata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_demographicdata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_demographicdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_demographicdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_demographicdata_meta_data_meta_data_id1_hash ON public.xnat_demographicdata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_demographicdata_xnat_abstractdemographicdata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_demographicdata_xnat_abstractdemographicdata_id1 ON public.xnat_demographicdata USING btree (xnat_abstractdemographicdata_id);


--
-- Name: xnat_demographicdata_xnat_abstractdemographicdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_demographicdata_xnat_abstractdemographicdata_id1_hash ON public.xnat_demographicdata USING hash (xnat_abstractdemographicdata_id);


--
-- Name: xnat_demographicdata_xnat_abstractdemographicdata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_demographicdata_xnat_abstractdemographicdata_id2_hash ON public.xnat_demographicdata USING hash (xnat_abstractdemographicdata_id);


--
-- Name: xnat_deriveddata_deriveddata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_deriveddata_info1 ON public.xnat_deriveddata USING btree (deriveddata_info);


--
-- Name: xnat_deriveddata_deriveddata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_deriveddata_info1_hash ON public.xnat_deriveddata USING hash (deriveddata_info);


--
-- Name: xnat_deriveddata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_id1 ON public.xnat_deriveddata USING btree (id);


--
-- Name: xnat_deriveddata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_id1_hash ON public.xnat_deriveddata USING hash (id);


--
-- Name: xnat_deriveddata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_id2_hash ON public.xnat_deriveddata USING hash (id);


--
-- Name: xnat_deriveddata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_meta_data_activation_user_xdat_user_id1 ON public.xnat_deriveddata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_deriveddata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_deriveddata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_deriveddata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_meta_data_insert_user_xdat_user_id1 ON public.xnat_deriveddata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_deriveddata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_deriveddata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_deriveddata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_meta_data_meta_data_id1_hash ON public.xnat_deriveddata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_deriveddata_provenance_prov_process_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_provenance_prov_process_id1 ON public.xnat_deriveddata USING btree (provenance_prov_process_id);


--
-- Name: xnat_deriveddata_provenance_prov_process_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_deriveddata_provenance_prov_process_id1_hash ON public.xnat_deriveddata USING hash (provenance_prov_process_id);


--
-- Name: xnat_dicomcodedvalue_dicomcodedvalue_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomcodedvalue_dicomcodedvalue_info1 ON public.xnat_dicomcodedvalue USING btree (dicomcodedvalue_info);


--
-- Name: xnat_dicomcodedvalue_dicomcodedvalue_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomcodedvalue_dicomcodedvalue_info1_hash ON public.xnat_dicomcodedvalue USING hash (dicomcodedvalue_info);


--
-- Name: xnat_dicomcodedvalue_meta_data_activation_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomcodedvalue_meta_data_activation_user_xdat_user_1 ON public.xnat_dicomcodedvalue_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_dicomcodedvalue_meta_data_activation_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomcodedvalue_meta_data_activation_user_xdat_user_1_hash ON public.xnat_dicomcodedvalue_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_dicomcodedvalue_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomcodedvalue_meta_data_insert_user_xdat_user_id1 ON public.xnat_dicomcodedvalue_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_dicomcodedvalue_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomcodedvalue_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_dicomcodedvalue_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_dicomcodedvalue_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomcodedvalue_meta_data_meta_data_id1_hash ON public.xnat_dicomcodedvalue_meta_data USING hash (meta_data_id);


--
-- Name: xnat_dicomcodedvalue_xnat_dicomcodedvalue_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomcodedvalue_xnat_dicomcodedvalue_id1_hash ON public.xnat_dicomcodedvalue USING hash (xnat_dicomcodedvalue_id);


--
-- Name: xnat_dicomseries_dicomseries_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_dicomseries_info1 ON public.xnat_dicomseries USING btree (dicomseries_info);


--
-- Name: xnat_dicomseries_dicomseries_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_dicomseries_info1_hash ON public.xnat_dicomseries USING hash (dicomseries_info);


--
-- Name: xnat_dicomseries_image_dicomseries_image_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_image_dicomseries_image_info1 ON public.xnat_dicomseries_image USING btree (dicomseries_image_info);


--
-- Name: xnat_dicomseries_image_dicomseries_image_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_image_dicomseries_image_info1_hash ON public.xnat_dicomseries_image USING hash (dicomseries_image_info);


--
-- Name: xnat_dicomseries_image_imageset_image_xnat_dicomseries_xn1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_image_imageset_image_xnat_dicomseries_xn1 ON public.xnat_dicomseries_image USING btree (imageset_image_xnat_dicomseries_xnat_abstractresource_id);


--
-- Name: xnat_dicomseries_image_imageset_image_xnat_dicomseries_xn1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_image_imageset_image_xnat_dicomseries_xn1_hash ON public.xnat_dicomseries_image USING hash (imageset_image_xnat_dicomseries_xnat_abstractresource_id);


--
-- Name: xnat_dicomseries_image_meta_data_activation_user_xdat_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_image_meta_data_activation_user_xdat_use1 ON public.xnat_dicomseries_image_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_dicomseries_image_meta_data_activation_user_xdat_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_image_meta_data_activation_user_xdat_use1_hash ON public.xnat_dicomseries_image_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_dicomseries_image_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_image_meta_data_insert_user_xdat_user_id1 ON public.xnat_dicomseries_image_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_dicomseries_image_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_image_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_dicomseries_image_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_dicomseries_image_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_image_meta_data_meta_data_id1_hash ON public.xnat_dicomseries_image_meta_data USING hash (meta_data_id);


--
-- Name: xnat_dicomseries_image_xnat_dicomseries_image_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_image_xnat_dicomseries_image_id1_hash ON public.xnat_dicomseries_image USING hash (xnat_dicomseries_image_id);


--
-- Name: xnat_dicomseries_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_meta_data_activation_user_xdat_user_id1 ON public.xnat_dicomseries_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_dicomseries_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_dicomseries_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_dicomseries_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_meta_data_insert_user_xdat_user_id1 ON public.xnat_dicomseries_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_dicomseries_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_dicomseries_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_dicomseries_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_meta_data_meta_data_id1_hash ON public.xnat_dicomseries_meta_data USING hash (meta_data_id);


--
-- Name: xnat_dicomseries_xnat_abstractresource_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_xnat_abstractresource_id1 ON public.xnat_dicomseries USING btree (xnat_abstractresource_id);


--
-- Name: xnat_dicomseries_xnat_abstractresource_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_xnat_abstractresource_id1_hash ON public.xnat_dicomseries USING hash (xnat_abstractresource_id);


--
-- Name: xnat_dicomseries_xnat_abstractresource_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dicomseries_xnat_abstractresource_id2_hash ON public.xnat_dicomseries USING hash (xnat_abstractresource_id);


--
-- Name: xnat_dx3dcraniofacialscandata_dx3dcraniofacialscandata_in1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialscandata_dx3dcraniofacialscandata_in1 ON public.xnat_dx3dcraniofacialscandata USING btree (dx3dcraniofacialscandata_info);


--
-- Name: xnat_dx3dcraniofacialscandata_dx3dcraniofacialscandata_in1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialscandata_dx3dcraniofacialscandata_in1_hash ON public.xnat_dx3dcraniofacialscandata USING hash (dx3dcraniofacialscandata_info);


--
-- Name: xnat_dx3dcraniofacialscandata_meta_data_activation_user_x1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialscandata_meta_data_activation_user_x1 ON public.xnat_dx3dcraniofacialscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_dx3dcraniofacialscandata_meta_data_activation_user_x1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialscandata_meta_data_activation_user_x1_hash ON public.xnat_dx3dcraniofacialscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_dx3dcraniofacialscandata_meta_data_insert_user_xdat_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialscandata_meta_data_insert_user_xdat_1 ON public.xnat_dx3dcraniofacialscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_dx3dcraniofacialscandata_meta_data_insert_user_xdat_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialscandata_meta_data_insert_user_xdat_1_hash ON public.xnat_dx3dcraniofacialscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_dx3dcraniofacialscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialscandata_meta_data_meta_data_id1_hash ON public.xnat_dx3dcraniofacialscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_dx3dcraniofacialscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialscandata_xnat_imagescandata_id1 ON public.xnat_dx3dcraniofacialscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_dx3dcraniofacialscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialscandata_xnat_imagescandata_id1_hash ON public.xnat_dx3dcraniofacialscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_dx3dcraniofacialscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialscandata_xnat_imagescandata_id2_hash ON public.xnat_dx3dcraniofacialscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_dx3dcraniofacialsessiondata_dx3dcraniofacialsessiond1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialsessiondata_dx3dcraniofacialsessiond1 ON public.xnat_dx3dcraniofacialsessiondata USING btree (dx3dcraniofacialsessiondata_info);


--
-- Name: xnat_dx3dcraniofacialsessiondata_dx3dcraniofacialsessiond1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialsessiondata_dx3dcraniofacialsessiond1_hash ON public.xnat_dx3dcraniofacialsessiondata USING hash (dx3dcraniofacialsessiondata_info);


--
-- Name: xnat_dx3dcraniofacialsessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialsessiondata_id1 ON public.xnat_dx3dcraniofacialsessiondata USING btree (id);


--
-- Name: xnat_dx3dcraniofacialsessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialsessiondata_id1_hash ON public.xnat_dx3dcraniofacialsessiondata USING hash (id);


--
-- Name: xnat_dx3dcraniofacialsessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialsessiondata_id2_hash ON public.xnat_dx3dcraniofacialsessiondata USING hash (id);


--
-- Name: xnat_dx3dcraniofacialsessiondata_meta_data_activation_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialsessiondata_meta_data_activation_use1 ON public.xnat_dx3dcraniofacialsessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_dx3dcraniofacialsessiondata_meta_data_activation_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialsessiondata_meta_data_activation_use1_hash ON public.xnat_dx3dcraniofacialsessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_dx3dcraniofacialsessiondata_meta_data_insert_user_xd1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialsessiondata_meta_data_insert_user_xd1 ON public.xnat_dx3dcraniofacialsessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_dx3dcraniofacialsessiondata_meta_data_insert_user_xd1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialsessiondata_meta_data_insert_user_xd1_hash ON public.xnat_dx3dcraniofacialsessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_dx3dcraniofacialsessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dx3dcraniofacialsessiondata_meta_data_meta_data_id1_hash ON public.xnat_dx3dcraniofacialsessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_dxscandata_dxscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxscandata_dxscandata_info1 ON public.xnat_dxscandata USING btree (dxscandata_info);


--
-- Name: xnat_dxscandata_dxscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxscandata_dxscandata_info1_hash ON public.xnat_dxscandata USING hash (dxscandata_info);


--
-- Name: xnat_dxscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_dxscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_dxscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_dxscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_dxscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_dxscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_dxscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_dxscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_dxscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxscandata_meta_data_meta_data_id1_hash ON public.xnat_dxscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_dxscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxscandata_xnat_imagescandata_id1 ON public.xnat_dxscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_dxscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxscandata_xnat_imagescandata_id1_hash ON public.xnat_dxscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_dxscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxscandata_xnat_imagescandata_id2_hash ON public.xnat_dxscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_dxsessiondata_dxsessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxsessiondata_dxsessiondata_info1 ON public.xnat_dxsessiondata USING btree (dxsessiondata_info);


--
-- Name: xnat_dxsessiondata_dxsessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxsessiondata_dxsessiondata_info1_hash ON public.xnat_dxsessiondata USING hash (dxsessiondata_info);


--
-- Name: xnat_dxsessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxsessiondata_id1 ON public.xnat_dxsessiondata USING btree (id);


--
-- Name: xnat_dxsessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxsessiondata_id1_hash ON public.xnat_dxsessiondata USING hash (id);


--
-- Name: xnat_dxsessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxsessiondata_id2_hash ON public.xnat_dxsessiondata USING hash (id);


--
-- Name: xnat_dxsessiondata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxsessiondata_meta_data_activation_user_xdat_user_id1 ON public.xnat_dxsessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_dxsessiondata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxsessiondata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_dxsessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_dxsessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxsessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_dxsessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_dxsessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxsessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_dxsessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_dxsessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_dxsessiondata_meta_data_meta_data_id1_hash ON public.xnat_dxsessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_ecgscandata_ecgscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgscandata_ecgscandata_info1 ON public.xnat_ecgscandata USING btree (ecgscandata_info);


--
-- Name: xnat_ecgscandata_ecgscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgscandata_ecgscandata_info1_hash ON public.xnat_ecgscandata USING hash (ecgscandata_info);


--
-- Name: xnat_ecgscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_ecgscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_ecgscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_ecgscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_ecgscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_ecgscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_ecgscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_ecgscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_ecgscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgscandata_meta_data_meta_data_id1_hash ON public.xnat_ecgscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_ecgscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgscandata_xnat_imagescandata_id1 ON public.xnat_ecgscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_ecgscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgscandata_xnat_imagescandata_id1_hash ON public.xnat_ecgscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_ecgscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgscandata_xnat_imagescandata_id2_hash ON public.xnat_ecgscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_ecgsessiondata_ecgsessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgsessiondata_ecgsessiondata_info1 ON public.xnat_ecgsessiondata USING btree (ecgsessiondata_info);


--
-- Name: xnat_ecgsessiondata_ecgsessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgsessiondata_ecgsessiondata_info1_hash ON public.xnat_ecgsessiondata USING hash (ecgsessiondata_info);


--
-- Name: xnat_ecgsessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgsessiondata_id1 ON public.xnat_ecgsessiondata USING btree (id);


--
-- Name: xnat_ecgsessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgsessiondata_id1_hash ON public.xnat_ecgsessiondata USING hash (id);


--
-- Name: xnat_ecgsessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgsessiondata_id2_hash ON public.xnat_ecgsessiondata USING hash (id);


--
-- Name: xnat_ecgsessiondata_meta_data_activation_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgsessiondata_meta_data_activation_user_xdat_user_i1 ON public.xnat_ecgsessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_ecgsessiondata_meta_data_activation_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgsessiondata_meta_data_activation_user_xdat_user_i1_hash ON public.xnat_ecgsessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_ecgsessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgsessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_ecgsessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_ecgsessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgsessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_ecgsessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_ecgsessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_ecgsessiondata_meta_data_meta_data_id1_hash ON public.xnat_ecgsessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_eegscandata_channel_channels_channel_xnat_eegscanda_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_channel_channels_channel_xnat_eegscanda_1 ON public.xnat_eegscandata_channel USING btree (channels_channel_xnat_eegscanda_xnat_imagescandata_id);


--
-- Name: xnat_eegscandata_channel_channels_channel_xnat_eegscanda_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_channel_channels_channel_xnat_eegscanda_1_hash ON public.xnat_eegscandata_channel USING hash (channels_channel_xnat_eegscanda_xnat_imagescandata_id);


--
-- Name: xnat_eegscandata_channel_eegscandata_channel_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_channel_eegscandata_channel_info1 ON public.xnat_eegscandata_channel USING btree (eegscandata_channel_info);


--
-- Name: xnat_eegscandata_channel_eegscandata_channel_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_channel_eegscandata_channel_info1_hash ON public.xnat_eegscandata_channel USING hash (eegscandata_channel_info);


--
-- Name: xnat_eegscandata_channel_meta_data_activation_user_xdat_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_channel_meta_data_activation_user_xdat_u1 ON public.xnat_eegscandata_channel_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_eegscandata_channel_meta_data_activation_user_xdat_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_channel_meta_data_activation_user_xdat_u1_hash ON public.xnat_eegscandata_channel_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_eegscandata_channel_meta_data_insert_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_channel_meta_data_insert_user_xdat_user_1 ON public.xnat_eegscandata_channel_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_eegscandata_channel_meta_data_insert_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_channel_meta_data_insert_user_xdat_user_1_hash ON public.xnat_eegscandata_channel_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_eegscandata_channel_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_channel_meta_data_meta_data_id1_hash ON public.xnat_eegscandata_channel_meta_data USING hash (meta_data_id);


--
-- Name: xnat_eegscandata_channel_xnat_eegscandata_channel_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_channel_xnat_eegscandata_channel_id1_hash ON public.xnat_eegscandata_channel USING hash (xnat_eegscandata_channel_id);


--
-- Name: xnat_eegscandata_eegscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_eegscandata_info1 ON public.xnat_eegscandata USING btree (eegscandata_info);


--
-- Name: xnat_eegscandata_eegscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_eegscandata_info1_hash ON public.xnat_eegscandata USING hash (eegscandata_info);


--
-- Name: xnat_eegscandata_impedance_eegscandata_impedance_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_impedance_eegscandata_impedance_info1 ON public.xnat_eegscandata_impedance USING btree (eegscandata_impedance_info);


--
-- Name: xnat_eegscandata_impedance_eegscandata_impedance_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_impedance_eegscandata_impedance_info1_hash ON public.xnat_eegscandata_impedance USING hash (eegscandata_impedance_info);


--
-- Name: xnat_eegscandata_impedance_meta_data_activation_user_xdat1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_impedance_meta_data_activation_user_xdat1 ON public.xnat_eegscandata_impedance_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_eegscandata_impedance_meta_data_activation_user_xdat1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_impedance_meta_data_activation_user_xdat1_hash ON public.xnat_eegscandata_impedance_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_eegscandata_impedance_meta_data_insert_user_xdat_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_impedance_meta_data_insert_user_xdat_use1 ON public.xnat_eegscandata_impedance_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_eegscandata_impedance_meta_data_insert_user_xdat_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_impedance_meta_data_insert_user_xdat_use1_hash ON public.xnat_eegscandata_impedance_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_eegscandata_impedance_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_impedance_meta_data_meta_data_id1_hash ON public.xnat_eegscandata_impedance_meta_data USING hash (meta_data_id);


--
-- Name: xnat_eegscandata_impedance_softwarefiltersimpedances_impe1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_impedance_softwarefiltersimpedances_impe1 ON public.xnat_eegscandata_impedance USING btree (softwarefiltersimpedances_imped_xnat_imagescandata_id);


--
-- Name: xnat_eegscandata_impedance_softwarefiltersimpedances_impe1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_impedance_softwarefiltersimpedances_impe1_hash ON public.xnat_eegscandata_impedance USING hash (softwarefiltersimpedances_imped_xnat_imagescandata_id);


--
-- Name: xnat_eegscandata_impedance_xnat_eegscandata_impedance_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_impedance_xnat_eegscandata_impedance_id1_hash ON public.xnat_eegscandata_impedance USING hash (xnat_eegscandata_impedance_id);


--
-- Name: xnat_eegscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_eegscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_eegscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_eegscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_eegscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_eegscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_eegscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_eegscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_eegscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_meta_data_meta_data_id1_hash ON public.xnat_eegscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_eegscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_xnat_imagescandata_id1 ON public.xnat_eegscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_eegscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_xnat_imagescandata_id1_hash ON public.xnat_eegscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_eegscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegscandata_xnat_imagescandata_id2_hash ON public.xnat_eegscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_eegsessiondata_eegsessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegsessiondata_eegsessiondata_info1 ON public.xnat_eegsessiondata USING btree (eegsessiondata_info);


--
-- Name: xnat_eegsessiondata_eegsessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegsessiondata_eegsessiondata_info1_hash ON public.xnat_eegsessiondata USING hash (eegsessiondata_info);


--
-- Name: xnat_eegsessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegsessiondata_id1 ON public.xnat_eegsessiondata USING btree (id);


--
-- Name: xnat_eegsessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegsessiondata_id1_hash ON public.xnat_eegsessiondata USING hash (id);


--
-- Name: xnat_eegsessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegsessiondata_id2_hash ON public.xnat_eegsessiondata USING hash (id);


--
-- Name: xnat_eegsessiondata_meta_data_activation_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegsessiondata_meta_data_activation_user_xdat_user_i1 ON public.xnat_eegsessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_eegsessiondata_meta_data_activation_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegsessiondata_meta_data_activation_user_xdat_user_i1_hash ON public.xnat_eegsessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_eegsessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegsessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_eegsessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_eegsessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegsessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_eegsessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_eegsessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_eegsessiondata_meta_data_meta_data_id1_hash ON public.xnat_eegsessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_epsscandata_epsscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epsscandata_epsscandata_info1 ON public.xnat_epsscandata USING btree (epsscandata_info);


--
-- Name: xnat_epsscandata_epsscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epsscandata_epsscandata_info1_hash ON public.xnat_epsscandata USING hash (epsscandata_info);


--
-- Name: xnat_epsscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epsscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_epsscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_epsscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epsscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_epsscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_epsscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epsscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_epsscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_epsscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epsscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_epsscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_epsscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epsscandata_meta_data_meta_data_id1_hash ON public.xnat_epsscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_epsscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epsscandata_xnat_imagescandata_id1 ON public.xnat_epsscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_epsscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epsscandata_xnat_imagescandata_id1_hash ON public.xnat_epsscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_epsscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epsscandata_xnat_imagescandata_id2_hash ON public.xnat_epsscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_epssessiondata_epssessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epssessiondata_epssessiondata_info1 ON public.xnat_epssessiondata USING btree (epssessiondata_info);


--
-- Name: xnat_epssessiondata_epssessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epssessiondata_epssessiondata_info1_hash ON public.xnat_epssessiondata USING hash (epssessiondata_info);


--
-- Name: xnat_epssessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epssessiondata_id1 ON public.xnat_epssessiondata USING btree (id);


--
-- Name: xnat_epssessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epssessiondata_id1_hash ON public.xnat_epssessiondata USING hash (id);


--
-- Name: xnat_epssessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epssessiondata_id2_hash ON public.xnat_epssessiondata USING hash (id);


--
-- Name: xnat_epssessiondata_meta_data_activation_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epssessiondata_meta_data_activation_user_xdat_user_i1 ON public.xnat_epssessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_epssessiondata_meta_data_activation_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epssessiondata_meta_data_activation_user_xdat_user_i1_hash ON public.xnat_epssessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_epssessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epssessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_epssessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_epssessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epssessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_epssessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_epssessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_epssessiondata_meta_data_meta_data_id1_hash ON public.xnat_epssessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_esscandata_esscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esscandata_esscandata_info1 ON public.xnat_esscandata USING btree (esscandata_info);


--
-- Name: xnat_esscandata_esscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esscandata_esscandata_info1_hash ON public.xnat_esscandata USING hash (esscandata_info);


--
-- Name: xnat_esscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_esscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_esscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_esscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_esscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_esscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_esscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_esscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_esscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esscandata_meta_data_meta_data_id1_hash ON public.xnat_esscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_esscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esscandata_xnat_imagescandata_id1 ON public.xnat_esscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_esscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esscandata_xnat_imagescandata_id1_hash ON public.xnat_esscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_esscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esscandata_xnat_imagescandata_id2_hash ON public.xnat_esscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_essessiondata_essessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_essessiondata_essessiondata_info1 ON public.xnat_essessiondata USING btree (essessiondata_info);


--
-- Name: xnat_essessiondata_essessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_essessiondata_essessiondata_info1_hash ON public.xnat_essessiondata USING hash (essessiondata_info);


--
-- Name: xnat_essessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_essessiondata_id1 ON public.xnat_essessiondata USING btree (id);


--
-- Name: xnat_essessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_essessiondata_id1_hash ON public.xnat_essessiondata USING hash (id);


--
-- Name: xnat_essessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_essessiondata_id2_hash ON public.xnat_essessiondata USING hash (id);


--
-- Name: xnat_essessiondata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_essessiondata_meta_data_activation_user_xdat_user_id1 ON public.xnat_essessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_essessiondata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_essessiondata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_essessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_essessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_essessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_essessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_essessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_essessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_essessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_essessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_essessiondata_meta_data_meta_data_id1_hash ON public.xnat_essessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_esvscandata_esvscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvscandata_esvscandata_info1 ON public.xnat_esvscandata USING btree (esvscandata_info);


--
-- Name: xnat_esvscandata_esvscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvscandata_esvscandata_info1_hash ON public.xnat_esvscandata USING hash (esvscandata_info);


--
-- Name: xnat_esvscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_esvscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_esvscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_esvscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_esvscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_esvscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_esvscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_esvscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_esvscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvscandata_meta_data_meta_data_id1_hash ON public.xnat_esvscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_esvscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvscandata_xnat_imagescandata_id1 ON public.xnat_esvscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_esvscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvscandata_xnat_imagescandata_id1_hash ON public.xnat_esvscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_esvscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvscandata_xnat_imagescandata_id2_hash ON public.xnat_esvscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_esvsessiondata_esvsessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvsessiondata_esvsessiondata_info1 ON public.xnat_esvsessiondata USING btree (esvsessiondata_info);


--
-- Name: xnat_esvsessiondata_esvsessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvsessiondata_esvsessiondata_info1_hash ON public.xnat_esvsessiondata USING hash (esvsessiondata_info);


--
-- Name: xnat_esvsessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvsessiondata_id1 ON public.xnat_esvsessiondata USING btree (id);


--
-- Name: xnat_esvsessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvsessiondata_id1_hash ON public.xnat_esvsessiondata USING hash (id);


--
-- Name: xnat_esvsessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvsessiondata_id2_hash ON public.xnat_esvsessiondata USING hash (id);


--
-- Name: xnat_esvsessiondata_meta_data_activation_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvsessiondata_meta_data_activation_user_xdat_user_i1 ON public.xnat_esvsessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_esvsessiondata_meta_data_activation_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvsessiondata_meta_data_activation_user_xdat_user_i1_hash ON public.xnat_esvsessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_esvsessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvsessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_esvsessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_esvsessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvsessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_esvsessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_esvsessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_esvsessiondata_meta_data_meta_data_id1_hash ON public.xnat_esvsessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_experimentdata_experimentdata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_experimentdata_info1 ON public.xnat_experimentdata USING btree (experimentdata_info);


--
-- Name: xnat_experimentdata_experimentdata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_experimentdata_info1_hash ON public.xnat_experimentdata USING hash (experimentdata_info);


--
-- Name: xnat_experimentdata_extension1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_extension1 ON public.xnat_experimentdata USING btree (extension);


--
-- Name: xnat_experimentdata_extension1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_extension1_hash ON public.xnat_experimentdata USING hash (extension);


--
-- Name: xnat_experimentdata_field_experimentdata_field_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_field_experimentdata_field_info1 ON public.xnat_experimentdata_field USING btree (experimentdata_field_info);


--
-- Name: xnat_experimentdata_field_experimentdata_field_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_field_experimentdata_field_info1_hash ON public.xnat_experimentdata_field USING hash (experimentdata_field_info);


--
-- Name: xnat_experimentdata_field_fields_field_xnat_experimentdat1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_field_fields_field_xnat_experimentdat1 ON public.xnat_experimentdata_field USING btree (fields_field_xnat_experimentdat_id);


--
-- Name: xnat_experimentdata_field_fields_field_xnat_experimentdat1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_field_fields_field_xnat_experimentdat1_hash ON public.xnat_experimentdata_field USING hash (fields_field_xnat_experimentdat_id);


--
-- Name: xnat_experimentdata_field_meta_data_activation_user_xdat_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_field_meta_data_activation_user_xdat_1 ON public.xnat_experimentdata_field_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_experimentdata_field_meta_data_activation_user_xdat_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_field_meta_data_activation_user_xdat_1_hash ON public.xnat_experimentdata_field_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_experimentdata_field_meta_data_insert_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_field_meta_data_insert_user_xdat_user1 ON public.xnat_experimentdata_field_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_experimentdata_field_meta_data_insert_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_field_meta_data_insert_user_xdat_user1_hash ON public.xnat_experimentdata_field_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_experimentdata_field_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_field_meta_data_meta_data_id1_hash ON public.xnat_experimentdata_field_meta_data USING hash (meta_data_id);


--
-- Name: xnat_experimentdata_field_xnat_experimentdata_field_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_field_xnat_experimentdata_field_id1_hash ON public.xnat_experimentdata_field USING hash (xnat_experimentdata_field_id);


--
-- Name: xnat_experimentdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_id1_hash ON public.xnat_experimentdata USING hash (id);


--
-- Name: xnat_experimentdata_investigator_xnat_investigatordata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_investigator_xnat_investigatordata_id1 ON public.xnat_experimentdata USING btree (investigator_xnat_investigatordata_id);


--
-- Name: xnat_experimentdata_investigator_xnat_investigatordata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_investigator_xnat_investigatordata_id1_hash ON public.xnat_experimentdata USING hash (investigator_xnat_investigatordata_id);


--
-- Name: xnat_experimentdata_meta_data_activation_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_meta_data_activation_user_xdat_user_i1 ON public.xnat_experimentdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_experimentdata_meta_data_activation_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_meta_data_activation_user_xdat_user_i1_hash ON public.xnat_experimentdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_experimentdata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_meta_data_insert_user_xdat_user_id1 ON public.xnat_experimentdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_experimentdata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_experimentdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_experimentdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_meta_data_meta_data_id1_hash ON public.xnat_experimentdata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_experimentdata_share_experimentdata_share_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_share_experimentdata_share_info1 ON public.xnat_experimentdata_share USING btree (experimentdata_share_info);


--
-- Name: xnat_experimentdata_share_experimentdata_share_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_share_experimentdata_share_info1_hash ON public.xnat_experimentdata_share USING hash (experimentdata_share_info);


--
-- Name: xnat_experimentdata_share_meta_data_activation_user_xdat_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_share_meta_data_activation_user_xdat_1 ON public.xnat_experimentdata_share_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_experimentdata_share_meta_data_activation_user_xdat_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_share_meta_data_activation_user_xdat_1_hash ON public.xnat_experimentdata_share_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_experimentdata_share_meta_data_insert_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_share_meta_data_insert_user_xdat_user1 ON public.xnat_experimentdata_share_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_experimentdata_share_meta_data_insert_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_share_meta_data_insert_user_xdat_user1_hash ON public.xnat_experimentdata_share_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_experimentdata_share_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_share_meta_data_meta_data_id1_hash ON public.xnat_experimentdata_share_meta_data USING hash (meta_data_id);


--
-- Name: xnat_experimentdata_share_sharing_share_xnat_experimentda1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_share_sharing_share_xnat_experimentda1 ON public.xnat_experimentdata_share USING btree (sharing_share_xnat_experimentda_id);


--
-- Name: xnat_experimentdata_share_sharing_share_xnat_experimentda1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_share_sharing_share_xnat_experimentda1_hash ON public.xnat_experimentdata_share USING hash (sharing_share_xnat_experimentda_id);


--
-- Name: xnat_experimentdata_share_xnat_experimentdata_share_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_share_xnat_experimentdata_share_id1_hash ON public.xnat_experimentdata_share USING hash (xnat_experimentdata_share_id);


--
-- Name: xnat_experimentdata_validation_xnat_validationdata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_validation_xnat_validationdata_id1 ON public.xnat_experimentdata USING btree (validation_xnat_validationdata_id);


--
-- Name: xnat_experimentdata_validation_xnat_validationdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_experimentdata_validation_xnat_validationdata_id1_hash ON public.xnat_experimentdata USING hash (validation_xnat_validationdata_id);


--
-- Name: xnat_fielddefinitiongroup_field_fielddefinitiongroup_fiel1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_fielddefinitiongroup_fiel1 ON public.xnat_fielddefinitiongroup_field USING btree (fielddefinitiongroup_field_info);


--
-- Name: xnat_fielddefinitiongroup_field_fielddefinitiongroup_fiel1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_fielddefinitiongroup_fiel1_hash ON public.xnat_fielddefinitiongroup_field USING hash (fielddefinitiongroup_field_info);


--
-- Name: xnat_fielddefinitiongroup_field_fields_field_xnat_fieldde1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_fields_field_xnat_fieldde1 ON public.xnat_fielddefinitiongroup_field USING btree (fields_field_xnat_fielddefiniti_xnat_fielddefinitiongroup_id);


--
-- Name: xnat_fielddefinitiongroup_field_fields_field_xnat_fieldde1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_fields_field_xnat_fieldde1_hash ON public.xnat_fielddefinitiongroup_field USING hash (fields_field_xnat_fielddefiniti_xnat_fielddefinitiongroup_id);


--
-- Name: xnat_fielddefinitiongroup_field_meta_data_activation_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_meta_data_activation_user1 ON public.xnat_fielddefinitiongroup_field_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_field_meta_data_activation_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_meta_data_activation_user1_hash ON public.xnat_fielddefinitiongroup_field_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_field_meta_data_insert_user_xda1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_meta_data_insert_user_xda1 ON public.xnat_fielddefinitiongroup_field_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_field_meta_data_insert_user_xda1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_meta_data_insert_user_xda1_hash ON public.xnat_fielddefinitiongroup_field_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_field_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_meta_data_meta_data_id1_hash ON public.xnat_fielddefinitiongroup_field_meta_data USING hash (meta_data_id);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_fielddefini1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_possiblevalue_fielddefini1 ON public.xnat_fielddefinitiongroup_field_possiblevalue USING btree (fielddefinitiongroup_field_possiblevalue_info);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_fielddefini1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_possiblevalue_fielddefini1_hash ON public.xnat_fielddefinitiongroup_field_possiblevalue USING hash (fielddefinitiongroup_field_possiblevalue_info);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_meta_data_a1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_possiblevalue_meta_data_a1 ON public.xnat_fielddefinitiongroup_field_possiblevalue_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_meta_data_a1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_possiblevalue_meta_data_a1_hash ON public.xnat_fielddefinitiongroup_field_possiblevalue_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_meta_data_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_possiblevalue_meta_data_i1 ON public.xnat_fielddefinitiongroup_field_possiblevalue_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_meta_data_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_possiblevalue_meta_data_i1_hash ON public.xnat_fielddefinitiongroup_field_possiblevalue_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_meta_data_m1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_possiblevalue_meta_data_m1_hash ON public.xnat_fielddefinitiongroup_field_possiblevalue_meta_data USING hash (meta_data_id);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_possibleval1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_possiblevalue_possibleval1 ON public.xnat_fielddefinitiongroup_field_possiblevalue USING btree (possiblevalues_possiblevalue_xn_xnat_fielddefinitiongroup_field);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_possibleval1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_possiblevalue_possibleval1_hash ON public.xnat_fielddefinitiongroup_field_possiblevalue USING hash (possiblevalues_possiblevalue_xn_xnat_fielddefinitiongroup_field);


--
-- Name: xnat_fielddefinitiongroup_field_possiblevalue_xnat_fieldd1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_possiblevalue_xnat_fieldd1_hash ON public.xnat_fielddefinitiongroup_field_possiblevalue USING hash (xnat_fielddefinitiongroup_field_possiblevalue_id);


--
-- Name: xnat_fielddefinitiongroup_field_xnat_fielddefinitiongroup1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_field_xnat_fielddefinitiongroup1_hash ON public.xnat_fielddefinitiongroup_field USING hash (xnat_fielddefinitiongroup_field_id);


--
-- Name: xnat_fielddefinitiongroup_fielddefinitiongroup_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_fielddefinitiongroup_info1 ON public.xnat_fielddefinitiongroup USING btree (fielddefinitiongroup_info);


--
-- Name: xnat_fielddefinitiongroup_fielddefinitiongroup_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_fielddefinitiongroup_info1_hash ON public.xnat_fielddefinitiongroup USING hash (fielddefinitiongroup_info);


--
-- Name: xnat_fielddefinitiongroup_meta_data_activation_user_xdat_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_meta_data_activation_user_xdat_1 ON public.xnat_fielddefinitiongroup_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_meta_data_activation_user_xdat_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_meta_data_activation_user_xdat_1_hash ON public.xnat_fielddefinitiongroup_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_meta_data_insert_user_xdat_user1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_meta_data_insert_user_xdat_user1 ON public.xnat_fielddefinitiongroup_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_meta_data_insert_user_xdat_user1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_meta_data_insert_user_xdat_user1_hash ON public.xnat_fielddefinitiongroup_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_fielddefinitiongroup_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_meta_data_meta_data_id1_hash ON public.xnat_fielddefinitiongroup_meta_data USING hash (meta_data_id);


--
-- Name: xnat_fielddefinitiongroup_xnat_fielddefinitiongroup_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_fielddefinitiongroup_xnat_fielddefinitiongroup_id1_hash ON public.xnat_fielddefinitiongroup USING hash (xnat_fielddefinitiongroup_id);


--
-- Name: xnat_genericdata_genericdata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_genericdata_genericdata_info1 ON public.xnat_genericdata USING btree (genericdata_info);


--
-- Name: xnat_genericdata_genericdata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_genericdata_genericdata_info1_hash ON public.xnat_genericdata USING hash (genericdata_info);


--
-- Name: xnat_genericdata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_genericdata_id1 ON public.xnat_genericdata USING btree (id);


--
-- Name: xnat_genericdata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_genericdata_id1_hash ON public.xnat_genericdata USING hash (id);


--
-- Name: xnat_genericdata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_genericdata_id2_hash ON public.xnat_genericdata USING hash (id);


--
-- Name: xnat_genericdata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_genericdata_meta_data_activation_user_xdat_user_id1 ON public.xnat_genericdata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_genericdata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_genericdata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_genericdata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_genericdata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_genericdata_meta_data_insert_user_xdat_user_id1 ON public.xnat_genericdata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_genericdata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_genericdata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_genericdata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_genericdata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_genericdata_meta_data_meta_data_id1_hash ON public.xnat_genericdata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_gmscandata_gmscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmscandata_gmscandata_info1 ON public.xnat_gmscandata USING btree (gmscandata_info);


--
-- Name: xnat_gmscandata_gmscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmscandata_gmscandata_info1_hash ON public.xnat_gmscandata USING hash (gmscandata_info);


--
-- Name: xnat_gmscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_gmscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_gmscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_gmscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_gmscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_gmscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_gmscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_gmscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_gmscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmscandata_meta_data_meta_data_id1_hash ON public.xnat_gmscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_gmscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmscandata_xnat_imagescandata_id1 ON public.xnat_gmscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_gmscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmscandata_xnat_imagescandata_id1_hash ON public.xnat_gmscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_gmscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmscandata_xnat_imagescandata_id2_hash ON public.xnat_gmscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_gmsessiondata_gmsessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmsessiondata_gmsessiondata_info1 ON public.xnat_gmsessiondata USING btree (gmsessiondata_info);


--
-- Name: xnat_gmsessiondata_gmsessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmsessiondata_gmsessiondata_info1_hash ON public.xnat_gmsessiondata USING hash (gmsessiondata_info);


--
-- Name: xnat_gmsessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmsessiondata_id1 ON public.xnat_gmsessiondata USING btree (id);


--
-- Name: xnat_gmsessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmsessiondata_id1_hash ON public.xnat_gmsessiondata USING hash (id);


--
-- Name: xnat_gmsessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmsessiondata_id2_hash ON public.xnat_gmsessiondata USING hash (id);


--
-- Name: xnat_gmsessiondata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmsessiondata_meta_data_activation_user_xdat_user_id1 ON public.xnat_gmsessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_gmsessiondata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmsessiondata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_gmsessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_gmsessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmsessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_gmsessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_gmsessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmsessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_gmsessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_gmsessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmsessiondata_meta_data_meta_data_id1_hash ON public.xnat_gmsessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_gmvscandata_gmvscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvscandata_gmvscandata_info1 ON public.xnat_gmvscandata USING btree (gmvscandata_info);


--
-- Name: xnat_gmvscandata_gmvscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvscandata_gmvscandata_info1_hash ON public.xnat_gmvscandata USING hash (gmvscandata_info);


--
-- Name: xnat_gmvscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_gmvscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_gmvscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_gmvscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_gmvscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_gmvscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_gmvscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_gmvscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_gmvscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvscandata_meta_data_meta_data_id1_hash ON public.xnat_gmvscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_gmvscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvscandata_xnat_imagescandata_id1 ON public.xnat_gmvscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_gmvscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvscandata_xnat_imagescandata_id1_hash ON public.xnat_gmvscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_gmvscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvscandata_xnat_imagescandata_id2_hash ON public.xnat_gmvscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_gmvsessiondata_gmvsessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvsessiondata_gmvsessiondata_info1 ON public.xnat_gmvsessiondata USING btree (gmvsessiondata_info);


--
-- Name: xnat_gmvsessiondata_gmvsessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvsessiondata_gmvsessiondata_info1_hash ON public.xnat_gmvsessiondata USING hash (gmvsessiondata_info);


--
-- Name: xnat_gmvsessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvsessiondata_id1 ON public.xnat_gmvsessiondata USING btree (id);


--
-- Name: xnat_gmvsessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvsessiondata_id1_hash ON public.xnat_gmvsessiondata USING hash (id);


--
-- Name: xnat_gmvsessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvsessiondata_id2_hash ON public.xnat_gmvsessiondata USING hash (id);


--
-- Name: xnat_gmvsessiondata_meta_data_activation_user_xdat_user_i1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvsessiondata_meta_data_activation_user_xdat_user_i1 ON public.xnat_gmvsessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_gmvsessiondata_meta_data_activation_user_xdat_user_i1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvsessiondata_meta_data_activation_user_xdat_user_i1_hash ON public.xnat_gmvsessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_gmvsessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvsessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_gmvsessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_gmvsessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvsessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_gmvsessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_gmvsessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_gmvsessiondata_meta_data_meta_data_id1_hash ON public.xnat_gmvsessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_hdscandata_hdscandata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdscandata_hdscandata_info1 ON public.xnat_hdscandata USING btree (hdscandata_info);


--
-- Name: xnat_hdscandata_hdscandata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdscandata_hdscandata_info1_hash ON public.xnat_hdscandata USING hash (hdscandata_info);


--
-- Name: xnat_hdscandata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdscandata_meta_data_activation_user_xdat_user_id1 ON public.xnat_hdscandata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_hdscandata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdscandata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_hdscandata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_hdscandata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdscandata_meta_data_insert_user_xdat_user_id1 ON public.xnat_hdscandata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_hdscandata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdscandata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_hdscandata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_hdscandata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdscandata_meta_data_meta_data_id1_hash ON public.xnat_hdscandata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_hdscandata_xnat_imagescandata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdscandata_xnat_imagescandata_id1 ON public.xnat_hdscandata USING btree (xnat_imagescandata_id);


--
-- Name: xnat_hdscandata_xnat_imagescandata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdscandata_xnat_imagescandata_id1_hash ON public.xnat_hdscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_hdscandata_xnat_imagescandata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdscandata_xnat_imagescandata_id2_hash ON public.xnat_hdscandata USING hash (xnat_imagescandata_id);


--
-- Name: xnat_hdsessiondata_hdsessiondata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdsessiondata_hdsessiondata_info1 ON public.xnat_hdsessiondata USING btree (hdsessiondata_info);


--
-- Name: xnat_hdsessiondata_hdsessiondata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdsessiondata_hdsessiondata_info1_hash ON public.xnat_hdsessiondata USING hash (hdsessiondata_info);


--
-- Name: xnat_hdsessiondata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdsessiondata_id1 ON public.xnat_hdsessiondata USING btree (id);


--
-- Name: xnat_hdsessiondata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdsessiondata_id1_hash ON public.xnat_hdsessiondata USING hash (id);


--
-- Name: xnat_hdsessiondata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdsessiondata_id2_hash ON public.xnat_hdsessiondata USING hash (id);


--
-- Name: xnat_hdsessiondata_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdsessiondata_meta_data_activation_user_xdat_user_id1 ON public.xnat_hdsessiondata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_hdsessiondata_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdsessiondata_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_hdsessiondata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_hdsessiondata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdsessiondata_meta_data_insert_user_xdat_user_id1 ON public.xnat_hdsessiondata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_hdsessiondata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdsessiondata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_hdsessiondata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_hdsessiondata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_hdsessiondata_meta_data_meta_data_id1_hash ON public.xnat_hdsessiondata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_imageassessordata_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageassessordata_id1 ON public.xnat_imageassessordata USING btree (id);


--
-- Name: xnat_imageassessordata_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageassessordata_id1_hash ON public.xnat_imageassessordata USING hash (id);


--
-- Name: xnat_imageassessordata_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageassessordata_id2_hash ON public.xnat_imageassessordata USING hash (id);


--
-- Name: xnat_imageassessordata_imageassessordata_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageassessordata_imageassessordata_info1 ON public.xnat_imageassessordata USING btree (imageassessordata_info);


--
-- Name: xnat_imageassessordata_imageassessordata_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageassessordata_imageassessordata_info1_hash ON public.xnat_imageassessordata USING hash (imageassessordata_info);


--
-- Name: xnat_imageassessordata_meta_data_activation_user_xdat_use1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageassessordata_meta_data_activation_user_xdat_use1 ON public.xnat_imageassessordata_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_imageassessordata_meta_data_activation_user_xdat_use1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageassessordata_meta_data_activation_user_xdat_use1_hash ON public.xnat_imageassessordata_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_imageassessordata_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageassessordata_meta_data_insert_user_xdat_user_id1 ON public.xnat_imageassessordata_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_imageassessordata_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageassessordata_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_imageassessordata_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_imageassessordata_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageassessordata_meta_data_meta_data_id1_hash ON public.xnat_imageassessordata_meta_data USING hash (meta_data_id);


--
-- Name: xnat_imageresource_imageresource_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresource_imageresource_info1 ON public.xnat_imageresource USING btree (imageresource_info);


--
-- Name: xnat_imageresource_imageresource_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresource_imageresource_info1_hash ON public.xnat_imageresource USING hash (imageresource_info);


--
-- Name: xnat_imageresource_meta_data_activation_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresource_meta_data_activation_user_xdat_user_id1 ON public.xnat_imageresource_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_imageresource_meta_data_activation_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresource_meta_data_activation_user_xdat_user_id1_hash ON public.xnat_imageresource_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_imageresource_meta_data_insert_user_xdat_user_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresource_meta_data_insert_user_xdat_user_id1 ON public.xnat_imageresource_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_imageresource_meta_data_insert_user_xdat_user_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresource_meta_data_insert_user_xdat_user_id1_hash ON public.xnat_imageresource_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_imageresource_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresource_meta_data_meta_data_id1_hash ON public.xnat_imageresource_meta_data USING hash (meta_data_id);


--
-- Name: xnat_imageresource_xnat_abstractresource_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresource_xnat_abstractresource_id1 ON public.xnat_imageresource USING btree (xnat_abstractresource_id);


--
-- Name: xnat_imageresource_xnat_abstractresource_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresource_xnat_abstractresource_id1_hash ON public.xnat_imageresource USING hash (xnat_abstractresource_id);


--
-- Name: xnat_imageresource_xnat_abstractresource_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresource_xnat_abstractresource_id2_hash ON public.xnat_imageresource USING hash (xnat_abstractresource_id);


--
-- Name: xnat_imageresourceseries_imageresourceseries_info1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresourceseries_imageresourceseries_info1 ON public.xnat_imageresourceseries USING btree (imageresourceseries_info);


--
-- Name: xnat_imageresourceseries_imageresourceseries_info1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresourceseries_imageresourceseries_info1_hash ON public.xnat_imageresourceseries USING hash (imageresourceseries_info);


--
-- Name: xnat_imageresourceseries_meta_data_activation_user_xdat_u1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresourceseries_meta_data_activation_user_xdat_u1 ON public.xnat_imageresourceseries_meta_data USING btree (activation_user_xdat_user_id);


--
-- Name: xnat_imageresourceseries_meta_data_activation_user_xdat_u1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresourceseries_meta_data_activation_user_xdat_u1_hash ON public.xnat_imageresourceseries_meta_data USING hash (activation_user_xdat_user_id);


--
-- Name: xnat_imageresourceseries_meta_data_insert_user_xdat_user_1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresourceseries_meta_data_insert_user_xdat_user_1 ON public.xnat_imageresourceseries_meta_data USING btree (insert_user_xdat_user_id);


--
-- Name: xnat_imageresourceseries_meta_data_insert_user_xdat_user_1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresourceseries_meta_data_insert_user_xdat_user_1_hash ON public.xnat_imageresourceseries_meta_data USING hash (insert_user_xdat_user_id);


--
-- Name: xnat_imageresourceseries_meta_data_meta_data_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresourceseries_meta_data_meta_data_id1_hash ON public.xnat_imageresourceseries_meta_data USING hash (meta_data_id);


--
-- Name: xnat_imageresourceseries_xnat_abstractresource_id1; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresourceseries_xnat_abstractresource_id1 ON public.xnat_imageresourceseries USING btree (xnat_abstractresource_id);


--
-- Name: xnat_imageresourceseries_xnat_abstractresource_id1_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresourceseries_xnat_abstractresource_id1_hash ON public.xnat_imageresourceseries USING hash (xnat_abstractresource_id);


--
-- Name: xnat_imageresourceseries_xnat_abstractresource_id2_hash; Type: INDEX; Schema: public; Owner: xnat
--

CREATE INDEX xnat_imageresourceseries_xnat_abstractresource_id2_hash ON public.xnat_imageresourceseries USING hash (xnat_abstractresource_id);


--
