1	\N	schema_type	funcgen
2	\N	schema_version	113
3	\N	patch	patch_89_90_a.sql|schema_version
4	\N	patch	patch_89_90_b.sql|probe feature columns
5	\N	patch	patch_89_90_c.sql|Adds stable id index for probe_transcript table
6	\N	patch	patch_89_90_d.sql|Adds stable id index for probe_set_transcript table
7	1	species.production_name	carlito_syrichta
8	\N	patch	patch_90_91_a.sql|schema_version
9	\N	patch	patch_90_91_b.sql|Remove sequence regions from previous releases
10	\N	patch	patch_90_91_c.sql|Translate sequence region ids of regulatory features
11	\N	patch	patch_90_91_d.sql|Replace regulatory features with updated ones
12	\N	patch	patch_90_91_e.sql|Translate sequence region ids of segmentation features
13	\N	patch	patch_90_91_f.sql|Replace segmentation features with updated ones
14	\N	patch	patch_90_91_g.sql|Translate sequence region ids of probe features
15	\N	patch	patch_90_91_h.sql|Replace probe features with updated ones
16	\N	patch	patch_90_91_i.sql|Translate sequence region ids of annotated features
17	\N	patch	patch_90_91_j.sql|Replace annotated features with updated ones
18	\N	patch	patch_90_91_k.sql|Translate sequence region ids of external features
19	\N	patch	patch_90_91_l.sql|Replace external features with updated ones
20	\N	patch	patch_90_91_m.sql|Translate sequence region ids of mi rna target features
21	\N	patch	patch_90_91_n.sql|Replace mi rna target features with updated ones
22	\N	patch	patch_90_91_o.sql|Translate sequence region ids of motif features
23	\N	patch	patch_90_91_p.sql|Replace motif features with updated ones
24	\N	patch	patch_90_91_q.sql|Drop seq_region table
25	\N	patch	patch_90_91_r.sql|Translate coord_system_ids in meta_coord table
26	\N	patch	patch_90_91_s.sql|Replace meta coord table with the updated table
27	\N	patch	patch_90_91_t.sql|Drop coord_system table
28	\N	patch	patch_90_91_u.sql|Set default gender to unknown for epigenomes
29	\N	patch	patch_90_91_v.sql|Create read_file table and populate it
30	\N	patch	patch_90_91_w.sql|Create read_file_experimental_configuration table and populate it
31	\N	patch	patch_90_91_x.sql|Rename result_set to alignment in various tables and columns
32	\N	patch	patch_90_91_y.sql|Rename annotated_feature to peak
33	\N	patch	patch_90_91_z.sql|Drop input_subset table
34	\N	patch	patch_90_91_za.sql|Move peak_callings from feature_set to peak_calling
35	\N	patch	patch_90_91_zb.sql|Rename another table
36	\N	patch	patch_90_91_zc.sql|Remove peak_callings from the feature_set table
37	\N	patch	patch_90_91_zd.sql|Drop data_set table
38	\N	patch	patch_90_91_ze.sql|Drop supporting_set table
39	\N	patch	patch_90_91_zf.sql|Drop status tables
40	\N	patch	patch_90_91_zg.sql|rename table dbfile_registry to data_file and change the way alignments link to it
41	\N	patch	patch_90_91_zh.sql|Add new columns to read_file_experimental_configuration table
42	\N	patch	patch_90_91_zi.sql|Create probe_id index on probe_transcript table
43	\N	patch	patch_91_92_a.sql|schema_version
44	\N	patch	patch_91_92_b.sql|Drop column paired_with from table read_file
45	\N	patch	patch_91_92_c.sql|Create underlying_structure table
46	\N	patch	patch_92_93_a.sql|schema_version
47	\N	patch	patch_92_93_b.sql|Allow failed peak callings
48	\N	patch	patch_92_93_c.sql|Allow the number of reads to be stored
49	\N	patch	patch_92_93_d.sql|Create table for chance quality check
50	\N	patch	patch_92_93_e.sql|Peak_calling table changes
51	\N	patch	patch_92_93_f.sql|Updates to alignment table
52	\N	patch	patch_92_93_g.sql|New table idr
53	\N	patch	patch_92_93_h.sql|execution_plan table
54	\N	patch	patch_92_93_i.sql|Add table to store fastqc outcomes
55	\N	patch	patch_92_93_j.sql|phantom peak table
56	\N	patch	patch_92_93_k.sql|Add table to store frip scores
57	\N	patch	patch_92_93_l.sql|Remove unused epigenome columns
58	\N	patch	patch_92_93_m.sql|Remove constraints
59	\N	patch	patch_92_93_n.sql|Fix ids, add missing autoincrement
60	\N	patch	patch_92_93_o.sql|Create peak_calling_statistic table
61	\N	patch	patch_92_93_p.sql|Create segmentation_state_assignment table
62	\N	patch	patch_92_93_q.sql|Create segmentation_state_emission table
63	\N	patch	patch_92_93_r.sql|Create regulatory_build_statistics table
64	\N	patch	patch_92_93_s.sql|drop segmentation_feature table
65	\N	patch	patch_92_93_t.sql|drop alignment_qc_phantom_peak table
66	\N	patch	patch_92_93_u.sql|Create probemapping meta table
67	\N	patch	patch_92_93_v.sql|Create probemapping statistic table
68	\N	patch	patch_92_93_w.sql|Modify index name_exp_idx from table read_file_experimental_configuration
69	\N	patch	patch_93_94_a.sql|schema_version
70	\N	patch	patch_93_94_b.sql|Modify column display_label length from epigenome table
71	\N	patch	patch_93_94_c.sql|Adds table segmentation_cell_table_ctcf
72	\N	patch	patch_93_94_d.sql|Adds table segmentation_cell_table_without_ctcf
73	\N	patch	patch_93_94_e.sql|Create transcription_factor table
74	\N	patch	patch_93_94_f.sql|Create transcription_factor_complex table
75	\N	patch	patch_93_94_g.sql|Create transcription_factor_complex_composition table
76	\N	patch	patch_93_94_h.sql|Create binding_matrix_transcription_factor_complex table
77	\N	patch	patch_93_94_i.sql|Modify motif_feature table
78	\N	patch	patch_93_94_j.sql|Create motif_feature_peak table
79	\N	patch	patch_93_94_k.sql|Create motif_feature_regulatory_feature table
80	\N	patch	patch_93_94_l.sql|Modify binding_matrix_table
81	\N	patch	patch_93_94_m.sql|Create binding_matrix_frequencies table
82	\N	patch	patch_93_94_n.sql|Modify indices in motif_feature_peak table
83	\N	patch	patch_93_94_o.sql|Add indices to motif_feature_regulatory_feature table
84	\N	patch	patch_93_94_p.sql|Modify column display_label length from epigenome table
85	\N	patch	patch_94_95_a.sql|schema_version
86	\N	patch	patch_94_95_b.sql|update to segmentation state tables
87	\N	patch	patch_94_95_c.sql|Update to alignment table
88	\N	patch	patch_94_95_d.sql|Update to execution_plan table
89	\N	patch	patch_94_95_e.sql|Update to regulatory_build_statistic table
90	\N	patch	patch_94_95_f.sql|Update to experimental_group table
91	\N	patch	patch_94_95_g.sql|segmentation table
92	\N	patch	patch_94_95_h.sql|segmentation_cell_tables
93	\N	patch	patch_94_95_i.sql|segmentation_statistic table
94	\N	patch	patch_94_95_j.sql|segmentation_file table
95	\N	patch	patch_94_95_k.sql|peak calling statistic table
96	\N	patch	patch_94_95_l.sql|Modify length for column name from epigenome table
97	\N	patch	patch_94_95_m.sql|drop obsolete tables
98	\N	patch	patch_94_95_n.sql|add unique constrain on display_label column for epigenome table
99	\N	patch	patch_95_96_a.sql|schema_version
100	\N	patch	patch_95_96_b.sql|changed data type for regulatory build statistics
101	\N	patch	patch_95_96_c.sql|make unique probe_id column from probe table
102	\N	patch	patch_95_96_d.sql|add ReadFile to the enum of the ensembl_object_type
103	\N	patch	patch_95_96_e.sql|Add description and release_version columns to regulatory_build table
104	\N	patch	patch_95_96_f.sql|Modify binding_matrix_table
105	\N	patch	patch_96_97_a.sql|schema_version
106	\N	patch	patch_96_97_b.sql|Changed to text
107	\N	patch	patch_96_97_c.sql|Added flag
108	\N	patch	patch_96_97_d.sql|Fix foreign key data type inconsistencies
109	\N	patch	patch_96_97_e.sql|Update mirna_target_feature
110	\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
111	\N	patch	patch_96_97_g.sql|Modify column in regulatory_activity
112	\N	patch	patch_97_98_a.sql|schema_version
113	\N	patch	patch_97_98_b.sql|Update unique constraint in mirna_target_feature table
114	\N	patch	patch_98_99_a.sql|schema_version
115	\N	patch	patch_98_99_b.sql|update datetime default value
116	\N	patch	patch_99_100_a.sql|schema_version
117	\N	patch	patch_99_100_b.sql|rename so_name to so_term
118	\N	patch	patch_99_100_c.sql|remove default values from text data type
119	\N	patch	patch_99_100_d.sql|update type column on external_db table
120	\N	patch	patch_99_100_e.sql|Make some foreign keys not mandatory
121	\N	patch	patch_100_101_a.sql|schema_version
122	\N	patch	patch_101_102_a.sql|schema_version
123	\N	patch	patch_101_102_b.sql|Drop underlying_structure table
124	\N	patch	patch_102_103_a.sql|schema_version
125	\N	patch	patch_103_104_a.sql|schema_version
126	1	species.division	EnsemblVertebrates
127	\N	patch	patch_104_105_a.sql|schema_version
128	\N	patch	patch_104_105_b.sql|New indices
129	\N	patch	patch_105_106_a.sql|schema_version
130	\N	patch	patch_106_107_a.sql|schema_version
131	\N	patch	patch_107_108_a.sql|schema_version
132	\N	patch	patch_107_108_b.sql|New epigenome_track table
133	\N	patch	patch_108_109_a.sql|schema_version
134	\N	patch	patch_109_110_a.sql|schema_version
135	\N	patch	patch_110_111_a.sql|schema_version
136	\N	patch	patch_111_112_a.sql|schema_version
137	\N	patch	patch_111_112_b.sql|fix data_file_id length
138	\N	patch	patch_111_112_c.sql|set data_file_id to not null auto increment
139	\N	patch	patch_112_113_a.sql|schema_version
140	\N	patch	patch_112_113_b.sql|fix_compatibility_issues