Adding Postgres changes for the Workspace to work. Work remains to be done for ORacle.
Sanofi RC2 dumped from oracle, tables and sequences ported to postgres
Sanofi RC2 dumped from oracle, tables and sequences ported to postgres
views and functions for postgres from Oracle Sanofi RC2
functions, proceudres, rc1 data load working
user biomart_user for gene_ontology tables
Search Taxonomy schema addons.
Boston hackathon branch -> London hackathon branch
trigger function required
Merge branch 'london_hackathon' of github.com:transmart/transmart-data into london_hackathon

Merging v1.2 schema with postgres port of Oracle Sanofi RC2
thehyve: Merge master branch into london_hackathon

Conflicts:
	README.md
	data/common/.gitignore
	data/common/Makefile
	data/common/makefile.inc
	data/oracle/Makefile
	data/postgres/Makefile
	data/postgres/makefile.inc
	ddl/oracle/GLOBAL/amapp.sql
	ddl/oracle/GLOBAL/biomart.sql
	ddl/oracle/GLOBAL/biomart_user.sql
	ddl/oracle/GLOBAL/deapp.sql
	ddl/oracle/GLOBAL/fmapp.sql
	ddl/oracle/GLOBAL/i2b2demodata.sql
	ddl/oracle/GLOBAL/i2b2metadata.sql
	ddl/oracle/GLOBAL/searchapp.sql
	ddl/oracle/GLOBAL/tm_cz.sql
	ddl/oracle/GLOBAL/tm_lz.sql
	ddl/oracle/GLOBAL/tm_wz.sql
	ddl/oracle/Makefile
	ddl/oracle/amapp/_cross.sql
	ddl/oracle/amapp/_misc.sql
	ddl/oracle/amapp/am_data_uid.sql
	ddl/oracle/amapp/am_tag_association.sql
	ddl/oracle/amapp/am_tag_item.sql
	ddl/oracle/amapp/am_tag_template.sql
	ddl/oracle/amapp/am_tag_template_association.sql
	ddl/oracle/amapp/am_tag_value.sql
	ddl/oracle/amapp/functions/am_tag_value_uid.sql
	ddl/oracle/biomart/_cross.sql
	ddl/oracle/biomart/_misc.sql
	ddl/oracle/biomart/annotation.sql
	ddl/oracle/biomart/assay_analysis_data.sql
	ddl/oracle/biomart/bio_assay.sql
	ddl/oracle/biomart/bio_assay_analysis.sql
	ddl/oracle/biomart/bio_assay_analysis_data.sql
	ddl/oracle/biomart/bio_assay_analysis_data_tea.sql
	ddl/oracle/biomart/bio_assay_data.sql
	ddl/oracle/biomart/bio_assay_data_stats.sql
	ddl/oracle/biomart/bio_assay_dataset.sql
	ddl/oracle/biomart/bio_assay_sample.sql
	ddl/oracle/biomart/bio_asy_analysis_dataset.sql
	ddl/oracle/biomart/bio_asy_analysis_pltfm.sql
	ddl/oracle/biomart/bio_asy_data_stats_all.sql
	ddl/oracle/biomart/bio_cell_line.sql
	ddl/oracle/biomart/bio_cgdcp_data.sql
	ddl/oracle/biomart/bio_clinc_trial_attr.sql
	ddl/oracle/biomart/bio_clinc_trial_pt_group.sql
	ddl/oracle/biomart/bio_clinc_trial_time_pt.sql
	ddl/oracle/biomart/bio_clinical_trial.sql
	ddl/oracle/biomart/bio_clinical_trial_design.sql
	ddl/oracle/biomart/bio_compound.sql
	ddl/oracle/biomart/bio_content.sql
	ddl/oracle/biomart/bio_content_reference.sql
	ddl/oracle/biomart/bio_content_repository.sql
	ddl/oracle/biomart/bio_curated_data.sql
	ddl/oracle/biomart/bio_curation_dataset.sql
	ddl/oracle/biomart/bio_data_attribute.sql
	ddl/oracle/biomart/bio_data_compound.sql
	ddl/oracle/biomart/bio_data_disease.sql
	ddl/oracle/biomart/bio_data_ext_code.sql
	ddl/oracle/biomart/bio_data_literature.sql
	ddl/oracle/biomart/bio_data_omic_marker.sql
	ddl/oracle/biomart/bio_data_taxonomy.sql
	ddl/oracle/biomart/bio_disease.sql
	ddl/oracle/biomart/bio_experiment.sql
	ddl/oracle/biomart/bio_lit_alt_data.sql
	ddl/oracle/biomart/bio_lit_amd_data.sql
	ddl/oracle/biomart/bio_lit_inh_data.sql
	ddl/oracle/biomart/bio_lit_int_data.sql
	ddl/oracle/biomart/bio_lit_int_model_mv.sql
	ddl/oracle/biomart/bio_lit_model_data.sql
	ddl/oracle/biomart/bio_lit_pe_data.sql
	ddl/oracle/biomart/bio_lit_ref_data.sql
	ddl/oracle/biomart/bio_lit_sum_data.sql
	ddl/oracle/biomart/bio_observation.sql
	ddl/oracle/biomart/bio_patient.sql
	ddl/oracle/biomart/bio_patient_event.sql
	ddl/oracle/biomart/bio_patient_event_attr.sql
	ddl/oracle/biomart/bio_sample.sql
	ddl/oracle/biomart/bio_stats_exp_marker.sql
	ddl/oracle/biomart/bio_subject.sql
	ddl/oracle/biomart/bio_taxonomy.sql
	ddl/oracle/biomart/ctd2_clin_inhib_effect.sql
	ddl/oracle/biomart/ctd2_disease.sql
	ddl/oracle/biomart/ctd2_inhib_details.sql
	ddl/oracle/biomart/ctd2_study.sql
	ddl/oracle/biomart/ctd2_trial_details.sql
	ddl/oracle/biomart/ctd_allowed_meds_treatment.sql
	ddl/oracle/biomart/ctd_biomarker.sql
	ddl/oracle/biomart/ctd_disease.sql
	ddl/oracle/biomart/ctd_drug_inhib.sql
	ddl/oracle/biomart/ctd_full.sql
	ddl/oracle/biomart/ctd_inclusion_criteria.sql
	ddl/oracle/biomart/ctd_primary_endpts.sql
	ddl/oracle/biomart/ctd_sec_endpts.sql
	ddl/oracle/biomart/ctd_study.sql
	ddl/oracle/biomart/dd.sql
	ddl/oracle/biomart/functions/bio_assay_analysis_uid.sql
	ddl/oracle/biomart/functions/bio_assay_platform_uid.sql
	ddl/oracle/biomart/functions/bio_asy_analysis_pltfm_uid.sql
	ddl/oracle/biomart/functions/bio_compound_uid.sql
	ddl/oracle/biomart/functions/bio_concept_code_uid.sql
	ddl/oracle/biomart/functions/bio_curation_dataset_uid.sql
	ddl/oracle/biomart/functions/bio_disease_uid.sql
	ddl/oracle/biomart/functions/bio_experiment_uid.sql
	ddl/oracle/biomart/functions/bio_jub_oncol_data_uid.sql
	ddl/oracle/biomart/functions/bio_jub_oncol_sum_data_uid.sql
	ddl/oracle/biomart/functions/bio_observation_uid.sql
	ddl/oracle/biomart/functions/biomarker_gene_uid.sql
	ddl/oracle/biomart/functions/biomarker_pathway_uid.sql
	ddl/oracle/biomart/functions/cum_normal_dist.sql
	ddl/oracle/biomart/functions/fract_error_dist.sql
	ddl/oracle/biomart/functions/tea_npv_precompute.sql
	ddl/oracle/biomart/gene_info_test.sql
	ddl/oracle/biomart/gene_synonym_test.sql
	ddl/oracle/biomart/genego_gene_map.sql
	ddl/oracle/biomart/gse_analysis.sql
	ddl/oracle/biomart/gse_probeset.sql
	ddl/oracle/biomart/items.json
	ddl/oracle/biomart/mesh.sql
	ddl/oracle/biomart/mesh_descriptor.sql
	ddl/oracle/biomart/mesh_entry.sql
	ddl/oracle/biomart/mesh_temp.sql
	ddl/oracle/biomart/mirna_bio_assay_data_annot.sql
	ddl/oracle/biomart/project_info.sql
	ddl/oracle/biomart/tests.sql
	ddl/oracle/biomart/tmp_bio_marker.sql
	ddl/oracle/biomart/tmp_omicsoft_disease_m1.sql
	ddl/oracle/biomart/tmp_project_category.sql
	ddl/oracle/biomart/tmp_project_compound.sql
	ddl/oracle/biomart/tmp_project_disease.sql
	ddl/oracle/biomart/views/bio_marker_correl_mv.sql
	ddl/oracle/biomart/views/ctd_arm_view.sql
	ddl/oracle/biomart/views/ctd_biomarker_view.sql
	ddl/oracle/biomart/views/ctd_cell_info_view.sql
	ddl/oracle/biomart/views/ctd_clinical_chars_view.sql
	ddl/oracle/biomart/views/ctd_drug_effects_view.sql
	ddl/oracle/biomart/views/ctd_drug_inhibitor_view.sql
	ddl/oracle/biomart/views/ctd_events_view.sql
	ddl/oracle/biomart/views/ctd_experiments_view.sql
	ddl/oracle/biomart/views/ctd_expr_after_view.sql
	ddl/oracle/biomart/views/ctd_expr_baseline_view.sql
	ddl/oracle/biomart/views/ctd_expr_bio_view.sql
	ddl/oracle/biomart/views/ctd_expr_source_view.sql
	ddl/oracle/biomart/views/ctd_full_clinical_endpts_view.sql
	ddl/oracle/biomart/views/ctd_full_search_view.sql
	ddl/oracle/biomart/views/ctd_primary_endpts_view.sql
	ddl/oracle/biomart/views/ctd_prior_med_use_view.sql
	ddl/oracle/biomart/views/ctd_pulmonary_path_view.sql
	ddl/oracle/biomart/views/ctd_quant_params_view.sql
	ddl/oracle/biomart/views/ctd_reference_view.sql
	ddl/oracle/biomart/views/ctd_runin_therapies_view.sql
	ddl/oracle/biomart/views/ctd_secondary_endpts_view.sql
	ddl/oracle/biomart/views/ctd_stats_view.sql
	ddl/oracle/biomart/views/ctd_study_details_view.sql
	ddl/oracle/biomart/views/ctd_td_design_view.sql
	ddl/oracle/biomart/views/ctd_td_excl_view.sql
	ddl/oracle/biomart/views/ctd_td_inclusion_view.sql
	ddl/oracle/biomart/views/ctd_td_smoker_view.sql
	ddl/oracle/biomart/views/ctd_td_sponsor_view.sql
	ddl/oracle/biomart/views/ctd_td_status_view.sql
	ddl/oracle/biomart/views/ctd_treatment_phases_view.sql
	ddl/oracle/biomart_user/ioe_temp_obj_reg2.sql
	ddl/oracle/biomart_user/items.json
	ddl/oracle/biomart_user/kde_temp_obj_reg3.sql
	ddl/oracle/deapp/_misc.sql
	ddl/oracle/deapp/de_metabolite_sub_pathways.sql
	ddl/oracle/deapp/de_metabolite_sub_pway_metab.sql
	ddl/oracle/deapp/de_mrna_annotation.sql
	ddl/oracle/deapp/de_mrna_annotation_bkp.sql
	ddl/oracle/deapp/de_obs_enroll_days.sql
	ddl/oracle/deapp/de_pathway.sql
	ddl/oracle/deapp/de_pathway_gene.sql
	ddl/oracle/deapp/de_protein_annotation.sql
	ddl/oracle/deapp/de_rbm_annotation.sql
	ddl/oracle/deapp/de_rbm_data_annotation_join.sql
	ddl/oracle/deapp/de_saved_comparison.sql
	ddl/oracle/deapp/de_snp_calls_by_gsm.sql
	ddl/oracle/deapp/de_snp_copy_number.sql
	ddl/oracle/deapp/de_snp_data_by_patient.sql
	ddl/oracle/deapp/de_snp_data_by_probe.sql
	ddl/oracle/deapp/de_snp_data_dataset_loc.sql
	ddl/oracle/deapp/de_snp_data_dataset_loc_bk.sql
	ddl/oracle/deapp/de_snp_gene_map.sql
	ddl/oracle/deapp/de_snp_info.sql
	ddl/oracle/deapp/de_snp_probe.sql
	ddl/oracle/deapp/de_snp_probe_sorted_def.sql
	ddl/oracle/deapp/de_snp_probe_sorted_def_bk.sql
	ddl/oracle/deapp/de_snp_subject_sorted_def.sql
	ddl/oracle/deapp/de_snp_subject_sorted_def_bk.sql
	ddl/oracle/deapp/de_subject_metabolomics_data.sql
	ddl/oracle/deapp/de_subject_microarray_data.sql
	ddl/oracle/deapp/de_subject_microarray_data_new.sql
	ddl/oracle/deapp/de_subject_microarray_logs.sql
	ddl/oracle/deapp/de_subject_microarray_med.sql
	ddl/oracle/deapp/de_subject_protein_data.sql
	ddl/oracle/deapp/de_subject_rbm_data.sql
	ddl/oracle/deapp/de_subject_sample_mapping_bk.sql
	ddl/oracle/deapp/de_subject_snp_dataset.sql
	ddl/oracle/deapp/de_subject_snp_dataset_bk.sql
	ddl/oracle/deapp/de_subject_snp_dataset_gsk.sql
	ddl/oracle/deapp/de_xtrial_child_map.sql
	ddl/oracle/deapp/de_xtrial_parent_names.sql
	ddl/oracle/deapp/deapp_annotation.sql
	ddl/oracle/deapp/functions/number_parser.sql
	ddl/oracle/deapp/functions/text_parser.sql
	ddl/oracle/deapp/gpl2004_5.sql
	ddl/oracle/deapp/gpl2004_5_map.sql
	ddl/oracle/deapp/gpl3718_20.sql
	ddl/oracle/deapp/gpl3718_20_map.sql
	ddl/oracle/deapp/haploview_data.sql
	ddl/oracle/deapp/items.json
	ddl/oracle/deapp/kegg.sql
	ddl/oracle/deapp/kegg_def.sql
	ddl/oracle/deapp/procedures/dump_table_to_csv.sql
	ddl/oracle/deapp/procedures/protein_comparison_qry.sql
	ddl/oracle/deapp/procedures/protein_dbl_comp_qry.sql
	ddl/oracle/deapp/procedures/rbm_comparison_qry.sql
	ddl/oracle/deapp/procedures/rbm_dbl_comp_qry.sql
	ddl/oracle/deapp/procedures/util_grant_all.sql
	ddl/oracle/deapp/ricerca.sql
	ddl/oracle/fmapp/_misc.sql
	ddl/oracle/fmapp/fm_data_uid.sql
	ddl/oracle/fmapp/fm_file.sql
	ddl/oracle/fmapp/fm_folder.sql
	ddl/oracle/fmapp/fm_folder_association.sql
	ddl/oracle/fmapp/fm_folder_file_association.sql
	ddl/oracle/fmapp/functions/fm_file_uid.sql
	ddl/oracle/fmapp/functions/fm_folder_uid.sql
	ddl/oracle/fmapp/functions/fm_get_folder_full_name.sql
	ddl/oracle/fmapp/procedures/fm_update_folder_full_name.sql
	ddl/oracle/i2b2demodata/_misc.sql
	ddl/oracle/i2b2demodata/cd.sql
	ddl/oracle/i2b2demodata/code_lookup.sql
	ddl/oracle/i2b2demodata/concept_counts_bk.sql
	ddl/oracle/i2b2demodata/concept_dimension_bk.sql
	ddl/oracle/i2b2demodata/counter.sql
	ddl/oracle/i2b2demodata/crc_db_lookup.sql
	ddl/oracle/i2b2demodata/datamart_report.sql
	ddl/oracle/i2b2demodata/dimloader.sql
	ddl/oracle/i2b2demodata/dr$of_ctx_blob$i.sql
	ddl/oracle/i2b2demodata/dr$of_ctx_blob$k.sql
	ddl/oracle/i2b2demodata/dr$of_ctx_blob$n.sql
	ddl/oracle/i2b2demodata/dr$of_ctx_blob$r.sql
	ddl/oracle/i2b2demodata/encounter_mapping.sql
	ddl/oracle/i2b2demodata/functions/isnumeric.sql
	ddl/oracle/i2b2demodata/functions/sf_xtab.sql
	ddl/oracle/i2b2demodata/hilosequences.sql
	ddl/oracle/i2b2demodata/jms_messages.sql
	ddl/oracle/i2b2demodata/jms_roles.sql
	ddl/oracle/i2b2demodata/jms_subscriptions.sql
	ddl/oracle/i2b2demodata/jms_transactions.sql
	ddl/oracle/i2b2demodata/jms_users.sql
	ddl/oracle/i2b2demodata/map.sql
	ddl/oracle/i2b2demodata/news_updates.sql
	ddl/oracle/i2b2demodata/observation_fact.sql
	ddl/oracle/i2b2demodata/observation_fact_bk.sql
	ddl/oracle/i2b2demodata/patient_dimension.sql
	ddl/oracle/i2b2demodata/patient_mapping.sql
	ddl/oracle/i2b2demodata/procedures/create_temp_concept_table.sql
	ddl/oracle/i2b2demodata/procedures/create_temp_eid_table.sql
	ddl/oracle/i2b2demodata/procedures/create_temp_modifier_table.sql
	ddl/oracle/i2b2demodata/procedures/create_temp_patient_table.sql
	ddl/oracle/i2b2demodata/procedures/create_temp_pid_table.sql
	ddl/oracle/i2b2demodata/procedures/create_temp_provider_table.sql
	ddl/oracle/i2b2demodata/procedures/create_temp_table.sql
	ddl/oracle/i2b2demodata/procedures/create_temp_visit_table.sql
	ddl/oracle/i2b2demodata/procedures/insert_concept_fromtemp.sql
	ddl/oracle/i2b2demodata/procedures/insert_eid_map_fromtemp.sql
	ddl/oracle/i2b2demodata/procedures/insert_encountervisit_fromtemp.sql
	ddl/oracle/i2b2demodata/procedures/insert_modifier_fromtemp.sql
	ddl/oracle/i2b2demodata/procedures/insert_patient_map_fromtemp.sql
	ddl/oracle/i2b2demodata/procedures/insert_pid_map_fromtemp.sql
	ddl/oracle/i2b2demodata/procedures/insert_provider_fromtemp.sql
	ddl/oracle/i2b2demodata/procedures/remove_temp_table.sql
	ddl/oracle/i2b2demodata/procedures/sp_xtab.sql
	ddl/oracle/i2b2demodata/procedures/sync_clear_concept_table.sql
	ddl/oracle/i2b2demodata/procedures/sync_clear_modifier_table.sql
	ddl/oracle/i2b2demodata/procedures/sync_clear_provider_table.sql
	ddl/oracle/i2b2demodata/procedures/update_observation_fact.sql
	ddl/oracle/i2b2demodata/provider_dimension.sql
	ddl/oracle/i2b2demodata/qt_breakdown_path.sql
	ddl/oracle/i2b2demodata/qt_patient_enc_collection.sql
	ddl/oracle/i2b2demodata/qt_patient_set_collection.sql
	ddl/oracle/i2b2demodata/qt_pdo_query_master.sql
	ddl/oracle/i2b2demodata/qt_privilege.sql
	ddl/oracle/i2b2demodata/qt_query_instance.sql
	ddl/oracle/i2b2demodata/qt_query_result_instance.sql
	ddl/oracle/i2b2demodata/qt_query_result_type.sql
	ddl/oracle/i2b2demodata/qt_query_status_type.sql
	ddl/oracle/i2b2demodata/qt_xml_result.sql
	ddl/oracle/i2b2demodata/ricerca.sql
	ddl/oracle/i2b2demodata/sample_categories.sql
	ddl/oracle/i2b2demodata/sample_dimension.sql
	ddl/oracle/i2b2demodata/set_type.sql
	ddl/oracle/i2b2demodata/set_upload_status.sql
	ddl/oracle/i2b2demodata/source_master.sql
	ddl/oracle/i2b2demodata/timers.sql
	ddl/oracle/i2b2demodata/upload_status.sql
	ddl/oracle/i2b2demodata/visit_dimension.sql
	ddl/oracle/i2b2metadata/_misc.sql
	ddl/oracle/i2b2metadata/custom_meta.sql
	ddl/oracle/i2b2metadata/i2b2.sql
	ddl/oracle/i2b2metadata/i2b2_bk.sql
	ddl/oracle/i2b2metadata/i2b2_secure_bk.sql
	ddl/oracle/i2b2metadata/i2b2_secure_bk1.sql
	ddl/oracle/i2b2metadata/i2b2_tags.sql
	ddl/oracle/i2b2metadata/ont_db_lookup.sql
	ddl/oracle/i2b2metadata/ont_process_status.sql
	ddl/oracle/i2b2metadata/procedures/add_ontology_node.sql
	ddl/oracle/i2b2metadata/query1.sql
	ddl/oracle/i2b2metadata/schemes.sql
	ddl/oracle/i2b2metadata/table_access_20111030.sql
	ddl/oracle/i2b2metadata/tmp_secure_token.sql
	ddl/oracle/searchapp/_cross.sql
	ddl/oracle/searchapp/_misc.sql
	ddl/oracle/searchapp/functions/bio_clinical_trial_uid.sql
	ddl/oracle/searchapp/functions/bio_compound_uid.sql
	ddl/oracle/searchapp/mlog$_search_gene_signatur.sql
	ddl/oracle/searchapp/search_auth_user_sec_access.sql
	ddl/oracle/searchapp/search_bio_mkr_correl_fast_mv.sql
	ddl/oracle/searchapp/search_custom_filter.sql
	ddl/oracle/searchapp/search_custom_filter_item.sql
	ddl/oracle/searchapp/search_gene_sig_file_schema.sql
	ddl/oracle/searchapp/search_gene_signature.sql
	ddl/oracle/searchapp/search_gene_signature_item.sql
	ddl/oracle/searchapp/search_secure_object_path.sql
	ddl/oracle/searchapp/search_user_feedback.sql
	ddl/oracle/searchapp/views/search_auth_user_sec_access_v.sql
	ddl/oracle/tm_cz/_cross.sql
	ddl/oracle/tm_cz/_misc.sql
	ddl/oracle/tm_cz/antigen_deapp.sql
	ddl/oracle/tm_cz/az_test_comparison_info.sql
	ddl/oracle/tm_cz/az_test_run.sql
	ddl/oracle/tm_cz/az_test_step_act_result.sql
	ddl/oracle/tm_cz/az_test_step_run.sql
	ddl/oracle/tm_cz/bio_clinical_trial_release.sql
	ddl/oracle/tm_cz/bio_data_compound_release.sql
	ddl/oracle/tm_cz/bio_data_uid_release.sql
	ddl/oracle/tm_cz/bio_experiment_release.sql
	ddl/oracle/tm_cz/category_path_excluded_words.sql
	ddl/oracle/tm_cz/concept_dimension_release.sql
	ddl/oracle/tm_cz/cz_data.sql
	ddl/oracle/tm_cz/cz_data_file.sql
	ddl/oracle/tm_cz/cz_dw_version.sql
	ddl/oracle/tm_cz/cz_form_layout.sql
	ddl/oracle/tm_cz/cz_job_audit.sql
	ddl/oracle/tm_cz/cz_job_master.sql
	ddl/oracle/tm_cz/cz_job_message.sql
	ddl/oracle/tm_cz/cz_person.sql
	ddl/oracle/tm_cz/cz_test.sql
	ddl/oracle/tm_cz/cz_test_category.sql
	ddl/oracle/tm_cz/cz_test_result.sql
	ddl/oracle/tm_cz/cz_test_severity.sql
	ddl/oracle/tm_cz/de_gpl_info_release.sql
	ddl/oracle/tm_cz/de_mrna_annotation_release.sql
	ddl/oracle/tm_cz/de_snp_data_by_patient_release.sql
	ddl/oracle/tm_cz/de_snp_data_by_probe_release.sql
	ddl/oracle/tm_cz/de_snp_data_ds_loc_release.sql
	ddl/oracle/tm_cz/de_snp_gene_map_release.sql
	ddl/oracle/tm_cz/de_snp_info_release.sql
	ddl/oracle/tm_cz/de_snp_probe_release.sql
	ddl/oracle/tm_cz/de_snp_probe_sort_def_release.sql
	ddl/oracle/tm_cz/de_subj_protein_data_release.sql
	ddl/oracle/tm_cz/de_subj_sample_map_release.sql
	ddl/oracle/tm_cz/de_subject_mrna_data_release.sql
	ddl/oracle/tm_cz/de_subject_rbm_data_release.sql
	ddl/oracle/tm_cz/functions/bio_assay_analysis_uid.sql
	ddl/oracle/tm_cz/functions/bio_assay_platform_uid.sql
	ddl/oracle/tm_cz/functions/bio_asy_analysis_pltfm_uid.sql
	ddl/oracle/tm_cz/functions/bio_compound_uid.sql
	ddl/oracle/tm_cz/functions/bio_curation_dataset_uid.sql
	ddl/oracle/tm_cz/functions/bio_disease_uid.sql
	ddl/oracle/tm_cz/functions/bio_experiment_uid.sql
	ddl/oracle/tm_cz/functions/bio_jub_oncol_data_uid.sql
	ddl/oracle/tm_cz/functions/bio_jub_oncol_sum_data_uid.sql
	ddl/oracle/tm_cz/functions/biomarker_gene_uid.sql
	ddl/oracle/tm_cz/functions/biomarker_pathway_uid.sql
	ddl/oracle/tm_cz/functions/czf_init_cap.sql
	ddl/oracle/tm_cz/functions/czf_num_occurances.sql
	ddl/oracle/tm_cz/functions/czf_parse_nth_value.sql
	ddl/oracle/tm_cz/functions/is_date.sql
	ddl/oracle/tm_cz/functions/is_number.sql
	ddl/oracle/tm_cz/functions/is_number_v2.sql
	ddl/oracle/tm_cz/functions/jnj_init_cap.sql
	ddl/oracle/tm_cz/functions/num_occurances.sql
	ddl/oracle/tm_cz/functions/parse_nth_value.sql
	ddl/oracle/tm_cz/functions/rdc_init_cap.sql
	ddl/oracle/tm_cz/functions/string_agg.sql
	ddl/oracle/tm_cz/functions/text_parser.sql
	ddl/oracle/tm_cz/haploview_data_release.sql
	ddl/oracle/tm_cz/i2b2_release.sql
	ddl/oracle/tm_cz/i2b2_tags_release.sql
	ddl/oracle/tm_cz/items.json
	ddl/oracle/tm_cz/mirna_probeset_deapp.sql
	ddl/oracle/tm_cz/node_curation.sql
	ddl/oracle/tm_cz/observation_fact_release.sql
	ddl/oracle/tm_cz/patient_dimension_release.sql
	ddl/oracle/tm_cz/probeset_deapp_bkp.sql
	ddl/oracle/tm_cz/procedures/create_synonyms.sql
	ddl/oracle/tm_cz/procedures/cz_audit_example.sql
	ddl/oracle/tm_cz/procedures/cz_end_audit.sql
	ddl/oracle/tm_cz/procedures/cz_error_handler.sql
	ddl/oracle/tm_cz/procedures/cz_info_handler.sql
	ddl/oracle/tm_cz/procedures/cz_start_audit.sql
	ddl/oracle/tm_cz/procedures/cz_write_audit.sql
	ddl/oracle/tm_cz/procedures/cz_write_error.sql
	ddl/oracle/tm_cz/procedures/cz_write_info.sql
	ddl/oracle/tm_cz/procedures/czx_end_audit.sql
	ddl/oracle/tm_cz/procedures/czx_error_handler.sql
	ddl/oracle/tm_cz/procedures/czx_start_audit.sql
	ddl/oracle/tm_cz/procedures/czx_write_audit.sql
	ddl/oracle/tm_cz/procedures/czx_write_error.sql
	ddl/oracle/tm_cz/procedures/data_export.sql
	ddl/oracle/tm_cz/procedures/drop_table.sql
	ddl/oracle/tm_cz/procedures/dropsyn.sql
	ddl/oracle/tm_cz/procedures/i2b2_add_node.sql
	ddl/oracle/tm_cz/procedures/i2b2_add_root_node.sql
	ddl/oracle/tm_cz/procedures/i2b2_add_snp_biomarker_nodes.sql
	ddl/oracle/tm_cz/procedures/i2b2_backout_trial.sql
	ddl/oracle/tm_cz/procedures/i2b2_bulk_add_search_term.sql
	ddl/oracle/tm_cz/procedures/i2b2_create_concept_counts.sql
	ddl/oracle/tm_cz/procedures/i2b2_create_external_tables.sql
	ddl/oracle/tm_cz/procedures/i2b2_create_security_for_trial.sql
	ddl/oracle/tm_cz/procedures/i2b2_delete_1_node.sql
	ddl/oracle/tm_cz/procedures/i2b2_delete_all_nodes.sql
	ddl/oracle/tm_cz/procedures/i2b2_fill_in_tree.sql
	ddl/oracle/tm_cz/procedures/i2b2_hide_node.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_annotation_deapp.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_clinical_data.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_metabolomics_annot.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_mirna_annot_deapp.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_omicsoft_annot.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_omicsoft_data.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_proteomics_annot.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_rbm_annotation.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_rbm_data.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_sample_categories.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_security_data.sql
	ddl/oracle/tm_cz/procedures/i2b2_load_study_metadata.sql
	ddl/oracle/tm_cz/procedures/i2b2_metabolomics_zscore_calc.sql
	ddl/oracle/tm_cz/procedures/i2b2_mirna_zscore_calc.sql
	ddl/oracle/tm_cz/procedures/i2b2_mrna_index_maint.sql
	ddl/oracle/tm_cz/procedures/i2b2_mrna_zscore_calc.sql
	ddl/oracle/tm_cz/procedures/i2b2_process_metabolomic_data.sql
	ddl/oracle/tm_cz/procedures/i2b2_process_mrna_data.sql
	ddl/oracle/tm_cz/procedures/i2b2_process_proteomics_data.sql
	ddl/oracle/tm_cz/procedures/i2b2_process_qpcr_mirna_data.sql
	ddl/oracle/tm_cz/procedures/i2b2_process_rna_seq_data.sql
	ddl/oracle/tm_cz/procedures/i2b2_proteomics_zscore_calc.sql
	ddl/oracle/tm_cz/procedures/i2b2_rbm_zscore_calc_new.sql
	ddl/oracle/tm_cz/procedures/i2b2_rename_node.sql
	ddl/oracle/tm_cz/procedures/i2b2_rna_seq_annotation.sql
	ddl/oracle/tm_cz/procedures/i2b2_rna_seq_zscore_calc.sql
	ddl/oracle/tm_cz/procedures/i2b2_secure_study.sql
	ddl/oracle/tm_cz/procedures/i2b2_show_node.sql
	ddl/oracle/tm_cz/procedures/i2b2_table_bkp.sql
	ddl/oracle/tm_cz/procedures/i2b2_table_defrag.sql
	ddl/oracle/tm_cz/procedures/i2b2_truncate_release_tables.sql
	ddl/oracle/tm_cz/procedures/load_kegg_content_data.sql
	ddl/oracle/tm_cz/procedures/rdc_reload_mrna_data.sql
	ddl/oracle/tm_cz/procedures/rename_program.sql
	ddl/oracle/tm_cz/procedures/rename_study.sql
	ddl/oracle/tm_cz/procedures/set_bio_data_uid_dis.sql
	ddl/oracle/tm_cz/procedures/set_bio_data_uid_path.sql
	ddl/oracle/tm_cz/procedures/upgrade_mrna_data.sql
	ddl/oracle/tm_cz/procedures/util_create_synonym_all.sql
	ddl/oracle/tm_cz/procedures/util_drop_all.sql
	ddl/oracle/tm_cz/procedures/util_drop_anything.sql
	ddl/oracle/tm_cz/procedures/util_drop_synonym.sql
	ddl/oracle/tm_cz/procedures/util_drop_synonym_by_owner.sql
	ddl/oracle/tm_cz/procedures/util_drop_table.sql
	ddl/oracle/tm_cz/procedures/util_grant_all.sql
	ddl/oracle/tm_cz/procedures/util_grant_execute.sql
	ddl/oracle/tm_cz/procedures/util_grant_select.sql
	ddl/oracle/tm_cz/procedures/util_is_populated.sql
	ddl/oracle/tm_cz/procedures/util_make_object_list.sql
	ddl/oracle/tm_cz/procedures/util_recompile_all.sql
	ddl/oracle/tm_cz/procedures/util_truncate_table.sql
	ddl/oracle/tm_cz/sample_categories_release.sql
	ddl/oracle/tm_cz/search_secure_object_release.sql
	ddl/oracle/tm_cz/tjea_junk.sql
	ddl/oracle/tm_cz/tmp_num_data_types.sql
	ddl/oracle/tm_cz/tmp_trial_data.sql
	ddl/oracle/tm_cz/tmp_trial_nodes.sql
	ddl/oracle/tm_cz/views/all_test_detail_view.sql
	ddl/oracle/tm_cz/views/all_test_summary_view.sql
	ddl/oracle/tm_cz/views/last_test_detail_view.sql
	ddl/oracle/tm_cz/views/last_test_summary_view.sql
	ddl/oracle/tm_lz/items.json
	ddl/oracle/tm_lz/lt_protein_annotation.sql
	ddl/oracle/tm_lz/lt_src_cel_files.sql
	ddl/oracle/tm_lz/lt_src_data_metadata.sql
	ddl/oracle/tm_lz/lt_src_nextbio.sql
	ddl/oracle/tm_lz/lt_src_omicsoft_annot.sql
	ddl/oracle/tm_lz/lt_src_omicsoft_data.sql
	ddl/oracle/tm_lz/lt_src_pathway.sql
	ddl/oracle/tm_lz/lt_src_pathway_org.sql
	ddl/oracle/tm_lz/lt_src_proteomics_data.sql
	ddl/oracle/tm_lz/lt_src_proteomics_sub_sam_map.sql
	ddl/oracle/tm_lz/lt_src_sample_categories.sql
	ddl/oracle/tm_lz/lt_src_study_metadata_orig.sql
	ddl/oracle/tm_lz/lt_src_subj_enroll_date.sql
	ddl/oracle/tm_lz/lz_src_mrna_data.sql
	ddl/oracle/tm_lz/lz_src_mrna_subj_samp_map.sql
	ddl/oracle/tm_lz/lz_src_sample_categories.sql
	ddl/oracle/tm_lz/lz_src_sample_categories_bkup.sql
	ddl/oracle/tm_lz/lz_src_study_metadata.sql
	ddl/oracle/tm_lz/procedures/util_grant_all.sql
	ddl/oracle/tm_wz/procedures/util_grant_all.sql
	ddl/oracle/tm_wz/wt_clinical_data_dups.sql
	ddl/oracle/tm_wz/wt_proteomics_node_values.sql
	ddl/oracle/tm_wz/wt_proteomics_nodes.sql
	ddl/oracle/tm_wz/wt_subject_mirna_calcs.sql
	ddl/oracle/tm_wz/wt_subject_mirna_logs.sql
	ddl/oracle/tm_wz/wt_subject_proteomics_calcs.sql
	ddl/oracle/tm_wz/wt_subject_proteomics_logs.sql
	ddl/oracle/tm_wz/wt_subject_proteomics_med.sql
	ddl/oracle/tm_wz/wt_subject_proteomics_probeset.sql
	ddl/postgres/biomart/_load_all.sql
	ddl/postgres/biomart/mirna_bio_assay_data_annot.sql
	ddl/postgres/biomart/mirna_bio_assay_feature_group.sql
	ddl/postgres/biomart/views/bio_marker_correl_mview.sql
	ddl/postgres/deapp/_load_all.sql
	ddl/postgres/deapp/_misc.sql
	ddl/postgres/deapp/de_gpl_info.sql
	ddl/postgres/deapp/de_protein_annotation.sql
	ddl/postgres/deapp/de_qpcr_mirna_annotation.sql
	ddl/postgres/deapp/de_subject_mirna_data.sql
	ddl/postgres/deapp/de_subject_protein_data.sql
	ddl/postgres/deapp/de_subject_rbm_data.sql
	ddl/postgres/deapp/dependencies.php
	ddl/postgres/i2b2demodata/observation_fact.sql
	ddl/postgres/searchapp/search_auth_user_sec_access.sql
	ddl/postgres/tm_cz/_cross.sql
	ddl/postgres/tm_cz/_load_all.sql
	ddl/postgres/tm_cz/functions/i2b2_load_chrom_region.sql
	ddl/postgres/tm_cz/functions/i2b2_load_mirna_annot_deapp.sql
	ddl/postgres/tm_cz/functions/i2b2_load_proteomics_annot.sql
	ddl/postgres/tm_cz/functions/i2b2_mirna_zscore_calc.sql
	ddl/postgres/tm_cz/functions/i2b2_process_proteomics_data.sql
	ddl/postgres/tm_cz/functions/i2b2_process_qpcr_mirna_data.sql
	ddl/postgres/tm_cz/functions/i2b2_proteomics_zscore_calc.sql
	ddl/postgres/tm_cz/mirna_annotation_deapp.sql
	ddl/postgres/tm_cz/mirna_probeset_deapp.sql
	ddl/postgres/tm_lz/_load_all.sql
	ddl/postgres/tm_lz/lt_protein_annotation.sql
	ddl/postgres/tm_lz/lt_qpcr_mirna_annotation.sql
	ddl/postgres/tm_lz/lt_src_clinical_data.sql
	ddl/postgres/tm_lz/lz_src_clinical_data.sql
	ddl/postgres/tm_wz/_load_all.sql
	ddl/postgres/tm_wz/wrk_clinical_data.sql
	ddl/postgres/tm_wz/wt_clinical_data_dups.sql
	ddl/postgres/tm_wz/wt_subject_microarray_calcs.sql
	ddl/postgres/tm_wz/wt_subject_microarray_med.sql
	ddl/postgres/tm_wz/wt_subject_mirna_calcs.sql
	ddl/postgres/tm_wz/wt_subject_mirna_logs.sql
	ddl/postgres/tm_wz/wt_subject_mirna_med.sql
	ddl/postgres/tm_wz/wt_subject_mirna_probeset.sql
	ddl/postgres/tm_wz/wt_subject_proteomics_calcs.sql
	ddl/postgres/tm_wz/wt_subject_proteomics_logs.sql
	ddl/postgres/tm_wz/wt_subject_proteomics_med.sql
	ddl/postgres/tm_wz/wt_subject_proteomics_probeset.sql
Merge pull request #1 from thehyve/london_hackathon

thehyve London hackathon merge with galaxy and other updates
oracle minor updates for postgres differences
Merge branch 'london_hackathon' of github.com:transmart/transmart-data into london_hackathon
catch multi-line create or replace function in postgres
documentation for ora-pg-compare.pl
Add table to _load_all.sql
Add prerequisite to more targets

Fetch ojdbc driver
Use user/password from global settings
Fix ora database creation