534	\N	schema_version	97
156	1	species.production_name	homo_sapiens
223	\N	schema_type	funcgen
589	\N	patch	patch_78_79_a.sql|schema_version
592	\N	patch	patch_78_79_b.sql|binding_matrix unique key
596	\N	patch	patch_79_80_a.sql|schema_version
597	\N	patch	patch_79_80_b.sql|dbfile_registry_unique_key
598	\N	patch	patch_79_80_c.sql|stable_id_changed_to_varchar
599	\N	patch	patch_80_81_a.sql|schema_version
600	\N	patch	patch_80_81_b.sql|add gender: mixed to table cell_type 
601	\N	patch	patch_80_81_c.sql|drop experiment.date
602	\N	patch	patch_81_82_a.sql|schema_version
603	\N	patch	patch_82_83_a.sql|schema_version
604	\N	patch	patch_83_84_a.sql|schema_version
605	\N	patch	patch_83_84_b.sql|Drop unique key for cell_type.efo_id
606	\N	patch	patch_83_84_c.sql|Add not null constraint to cell_type.display_label
607	\N	patch	patch_83_84_d.sql|Add segmentation enum to result_set.feature_class
608	\N	patch	patch_83_84_e.sql|Increase length of regbuild_string.name
609	\N	patch	patch_83_84_f.sql|Change regulatory_feature has_evidence to activity
610	\N	patch	patch_84_85_a.sql|schema_version
611	\N	patch	patch_84_85_b.sql|rename cell_type table
612	\N	patch	patch_84_85_c.sql|new epigenome table columns
613	\N	patch	patch_84_85_d.sql|add columns to experiment table
614	\N	patch	patch_84_85_e.sql|add/modify columns in input_subset table
615	\N	patch	patch_84_85_f.sql|drop replicate column from result_set table
616	\N	patch	patch_84_85_g.sql|update dbentry related tables
617	\N	patch	patch_84_85_h.sql|Store file types along with the files.
618	\N	patch	patch_84_85_i.sql|Normalise regulatory feature table: Create a non redundant version of the regulatory features.
619	\N	patch	patch_84_85_j.sql|Normalise regulatory feature table: Create a linking table between regulatory features and feature sets.
620	\N	patch	patch_84_85_k.sql|Normalise regulatory feature table: Link up the new non redundant regulatory features.
621	\N	patch	patch_84_85_l.sql|Normalise regulatory feature table: Link up the regulatory attributes with the linking table.
622	\N	patch	patch_84_85_m.sql|Normalise regulatory feature table: Clean up temporary columns and tables.
623	\N	patch	patch_84_85_n.sql|Make activity an enum.
624	\N	patch	patch_84_85_o.sql|Delete all MultiCell regulatory features feature set entries.
625	\N	patch	patch_84_85_p.sql|Delete MultiCell feature_set and epigenome.
626	\N	patch	patch_84_85_q.sql|Rename table regulatory_attribute to regulatory_evidence.
627	\N	patch	patch_84_85_r.sql|Drop unused empty tables
628	\N	patch	patch_84_85_s.sql|modify table_name column in result_set_input table
629	\N	patch	patch_84_85_t.sql|Drop table regbuild_string
630	\N	patch	patch_84_85_u.sql|Remove regulatory build entries from feature_set table, relink everything else.
631	\N	patch	patch_84_85_v.sql|Move meta entries regarding regulatory build to the regulatory_build table
632	\N	patch	patch_84_85_w.sql|Extend the name length in the input_subset table
633	\N	patch	patch_84_85_x.sql|Remove unused columns in the experiment table
634	\N	patch	patch_84_85_y.sql|Table for storing epigenomes used in the regulatory build
635	\N	patch	patch_84_85_z.sql|Move segmentation entries from result_set table into the new segmentation_file table.
636	\N	patch	patch_84_85_za.sql|Move entries provided by external sources from the result_set table into the new external_feature_file table.
637	\N	patch	patch_84_85_zb.sql|Bugfix, the primary key was wrongly named.
638	\N	patch	patch_85_86_a.sql|schema_version
639	\N	patch	patch_85_86_b.sql|Drop tables epigenome_lineage and lineage
640	\N	patch	patch_85_86_c.sql|Add production name column to feature_type table
641	\N	patch	patch_85_86_d.sql|Add new columns to input_subset table to accommodate paired-end data
642	\N	patch	patch_85_86_e.sql|Add QC tables
643	\N	patch	patch_86_87_a.sql|schema_version
644	\N	patch	patch_86_87_b.sql|Change data type of certain columns to facilitate foreing key constraints
645	\N	patch	patch_86_87_c.sql|Remove obsolete coloumns from external_feature_file
646	\N	patch	patch_86_87_d.sql|Add 'unknown' as a valid gender in the epigenome table
647	\N	patch	patch_86_87_e.sql|Increase data_set.name length
648	\N	patch	patch_87_88_a.sql|schema_version
649	\N	patch	patch_87_88_b.sql|seq_region_name_255
650	\N	patch	patch_87_88_c.sql|sample_regulatory_feature_id field for regulatory build
651	\N	patch	patch_88_89_a.sql|schema_version
652	\N	patch	patch_88_89_b.sql|Created probe_seq table
653	\N	patch	patch_88_89_c.sql|created probe_feature_transcript table
654	\N	patch	patch_88_89_d.sql|created probe_transcript table
655	\N	patch	patch_88_89_e.sql|created probeset_transcript table
656	\N	patch	patch_88_89_f.sql|Removed probe features from object_xref and xref table
657	\N	patch	patch_88_89_g.sql|Removed probe mappings from the xref tables
658	\N	patch	patch_88_89_h.sql|Removed probe set mappings from the xref tables
659	\N	patch	patch_88_89_i.sql|New columns for array table
660	\N	patch	patch_88_89_j.sql|Added array_chip_id column to probe_set table
661	\N	patch	patch_88_89_k.sql|Added probe_seq_id column to probe table
662	\N	patch	patch_89_90_a.sql|schema_version
663	\N	patch	patch_89_90_b.sql|probe feature columns
664	\N	patch	patch_89_90_c.sql|Adds stable id index for probe_transcript table
665	\N	patch	patch_89_90_d.sql|Adds stable id index for probe_set_transcript table
666	\N	patch	patch_90_91_a.sql|schema_version
667	\N	patch	patch_90_91_b.sql|Remove sequence regions from previous releases
668	\N	patch	patch_90_91_c.sql|Translate sequence region ids of regulatory features
669	\N	patch	patch_90_91_d.sql|Replace regulatory features with updated ones
670	\N	patch	patch_90_91_e.sql|Translate sequence region ids of segmentation features
671	\N	patch	patch_90_91_f.sql|Replace segmentation features with updated ones
672	\N	patch	patch_90_91_g.sql|Translate sequence region ids of probe features
673	\N	patch	patch_90_91_h.sql|Replace probe features with updated ones
674	\N	patch	patch_90_91_i.sql|Translate sequence region ids of annotated features
675	\N	patch	patch_90_91_j.sql|Replace annotated features with updated ones
676	\N	patch	patch_90_91_k.sql|Translate sequence region ids of external features
677	\N	patch	patch_90_91_l.sql|Replace external features with updated ones
678	\N	patch	patch_90_91_m.sql|Translate sequence region ids of mi rna target features
679	\N	patch	patch_90_91_n.sql|Replace mi rna target features with updated ones
680	\N	patch	patch_90_91_o.sql|Translate sequence region ids of motif features
681	\N	patch	patch_90_91_p.sql|Replace motif features with updated ones
682	\N	patch	patch_90_91_q.sql|Drop seq_region table
683	\N	patch	patch_90_91_r.sql|Translate coord_system_ids in meta_coord table
684	\N	patch	patch_90_91_s.sql|Replace meta coord table with the updated table
685	\N	patch	patch_90_91_t.sql|Drop coord_system table
686	\N	patch	patch_90_91_u.sql|Set default gender to unknown for epigenomes
687	\N	patch	patch_90_91_v.sql|Create read_file table and populate it
688	\N	patch	patch_90_91_w.sql|Create read_file_experimental_configuration table and populate it
689	\N	patch	patch_90_91_x.sql|Rename result_set to alignment in various tables and columns
690	\N	patch	patch_90_91_y.sql|Rename annotated_feature to peak
691	\N	patch	patch_90_91_z.sql|Drop input_subset table
692	\N	patch	patch_90_91_za.sql|Move peak_callings from feature_set to peak_calling
693	\N	patch	patch_90_91_zb.sql|Rename another table
694	\N	patch	patch_90_91_zc.sql|Remove peak_callings from the feature_set table
695	\N	patch	patch_90_91_zd.sql|Drop data_set table
696	\N	patch	patch_90_91_ze.sql|Drop supporting_set table
697	\N	patch	patch_90_91_zf.sql|Drop status tables
698	\N	patch	patch_90_91_zg.sql|rename table dbfile_registry to data_file and change the way alignments link to it
699	\N	patch	patch_90_91_zh.sql|Add new columns to read_file_experimental_configuration table
700	\N	patch	patch_90_91_zi.sql|Create probe_id index on probe_transcript table
701	\N	patch	patch_91_92_a.sql|schema_version
702	\N	patch	patch_91_92_b.sql|Drop column paired_with from table read_file
703	\N	patch	patch_91_92_c.sql|Create underlying_structure table
704	\N	patch	patch_92_93_a.sql|schema_version
705	\N	patch	patch_92_93_b.sql|Allow failed peak callings
706	\N	patch	patch_92_93_c.sql|Allow the number of reads to be stored
707	\N	patch	patch_92_93_d.sql|Create table for chance quality check
708	\N	patch	patch_92_93_e.sql|Peak_calling table changes
709	\N	patch	patch_92_93_f.sql|Updates to alignment table
710	\N	patch	patch_92_93_g.sql|New table idr
711	\N	patch	patch_92_93_h.sql|execution_plan table
712	\N	patch	patch_92_93_i.sql|Add table to store fastqc outcomes
713	\N	patch	patch_92_93_j.sql|phantom peak table
714	\N	patch	patch_92_93_k.sql|Add table to store frip scores
715	\N	patch	patch_92_93_l.sql|Remove unused epigenome columns
716	\N	patch	patch_92_93_m.sql|Remove constraints
717	\N	patch	patch_92_93_n.sql|Fix ids, add missing autoincrement
718	\N	patch	patch_92_93_o.sql|Create peak_calling_statistic table
719	\N	patch	patch_92_93_p.sql|Create segmentation_state_assignment table
720	\N	patch	patch_92_93_q.sql|Create segmentation_state_emission table
721	\N	patch	patch_92_93_r.sql|Create regulatory_build_statistics table
722	\N	patch	patch_92_93_s.sql|drop segmentation_feature table
723	\N	patch	patch_92_93_t.sql|drop alignment_qc_phantom_peak table
724	\N	patch	patch_92_93_u.sql|Create probemapping meta table
725	\N	patch	patch_92_93_v.sql|Create probemapping statistic table
726	\N	patch	patch_92_93_w.sql|Modify index name_exp_idx from table read_file_experimental_configuration
727	\N	patch	patch_93_94_a.sql|schema_version
728	\N	patch	patch_93_94_b.sql|Modify column display_label length from epigenome table
729	\N	patch	patch_93_94_c.sql|Adds table segmentation_cell_table_ctcf
730	\N	patch	patch_93_94_d.sql|Adds table segmentation_cell_table_without_ctcf
731	\N	patch	patch_93_94_e.sql|Create transcription_factor table
732	\N	patch	patch_93_94_f.sql|Create transcription_factor_complex table
733	\N	patch	patch_93_94_g.sql|Create transcription_factor_complex_composition table
734	\N	patch	patch_93_94_h.sql|Create binding_matrix_transcription_factor_complex table
735	\N	patch	patch_93_94_i.sql|Modify motif_feature table
736	\N	patch	patch_93_94_j.sql|Create motif_feature_peak table
737	\N	patch	patch_93_94_k.sql|Create motif_feature_regulatory_feature table
738	\N	patch	patch_93_94_l.sql|Modify binding_matrix_table
739	\N	patch	patch_93_94_m.sql|Create binding_matrix_frequencies table
740	\N	patch	patch_93_94_n.sql|Modify indices in motif_feature_peak table
741	\N	patch	patch_93_94_o.sql|Add indices to motif_feature_regulatory_feature table
742	\N	patch	patch_93_94_p.sql|Modify column display_label length from epigenome table
743	\N	patch	patch_94_95_a.sql|schema_version
744	\N	patch	patch_94_95_b.sql|update to segmentation state tables
745	\N	patch	patch_94_95_c.sql|Update to alignment table
746	\N	patch	patch_94_95_d.sql|Update to execution_plan table
747	\N	patch	patch_94_95_e.sql|Update to regulatory_build_statistic table
748	\N	patch	patch_94_95_f.sql|Update to experimental_group table
749	\N	patch	patch_94_95_g.sql|segmentation table
750	\N	patch	patch_94_95_h.sql|segmentation_cell_tables
751	\N	patch	patch_94_95_i.sql|segmentation_statistic table
752	\N	patch	patch_94_95_j.sql|segmentation_file table
753	\N	patch	patch_94_95_k.sql|peak calling statistic table
754	\N	patch	patch_94_95_l.sql|Modify length for column name from epigenome table
755	\N	patch	patch_94_95_m.sql|drop obsolete tables
756	\N	patch	patch_94_95_n.sql|add unique constrain on display_label column for epigenome table
757	\N	patch	patch_95_96_a.sql|schema_version
758	\N	patch	patch_95_96_b.sql|changed data type for regulatory build statistics
759	\N	patch	patch_95_96_c.sql|make unique probe_id column from probe table
760	\N	patch	patch_95_96_d.sql|add ReadFile to the enum of the ensembl_object_type
761	\N	patch	patch_95_96_e.sql|Add description and release_version columns to regulatory_build table
762	\N	patch	patch_95_96_f.sql|Modify binding_matrix_table
763	\N	patch	patch_96_97_a.sql|schema_version
764	\N	patch	patch_96_97_b.sql|Changed to text
765	\N	patch	patch_96_97_c.sql|Added flag
766	\N	patch	patch_96_97_d.sql|Fix foreign key data type inconsistencies
767	\N	patch	patch_96_97_e.sql|Update mirna_target_feature
768	\N	patch	patch_96_97_f.sql|Add search_terms and full_name columns to epigenome table, rename display_label column to short_name and change description to TEXT