1	\N	schema_type	funcgen
2	\N	schema_version	113
4	1	species.production_name	caenorhabditis_elegans
5	\N	patch	patch_83_84_a.sql|schema_version
6	\N	patch	patch_83_84_b.sql|Drop unique key for cell_type.efo_id
7	\N	patch	patch_83_84_c.sql|Add not null constraint to cell_type.display_label
8	\N	patch	patch_83_84_d.sql|Add segmentation enum to result_set.feature_class
9	\N	patch	patch_83_84_e.sql|Increase length of regbuild_string.name
10	\N	patch	patch_83_84_f.sql|Change regulatory_feature has_evidence to activity
11	\N	patch	patch_84_85_a.sql|schema_version
12	\N	patch	patch_84_85_b.sql|rename cell_type table
13	\N	patch	patch_84_85_c.sql|new epigenome table columns
14	\N	patch	patch_84_85_d.sql|add columns to experiment table
15	\N	patch	patch_84_85_e.sql|add/modify columns in input_subset table
16	\N	patch	patch_84_85_f.sql|drop replicate column from result_set table
17	\N	patch	patch_84_85_g.sql|update dbentry related tables
18	\N	patch	patch_84_85_h.sql|Store file types along with the files.
19	\N	patch	patch_84_85_i.sql|Normalise regulatory feature table: Create a non redundant version of the regulatory features.
20	\N	patch	patch_84_85_j.sql|Normalise regulatory feature table: Create a linking table between regulatory features and feature sets.
21	\N	patch	patch_84_85_k.sql|Normalise regulatory feature table: Link up the new non redundant regulatory features.
22	\N	patch	patch_84_85_l.sql|Normalise regulatory feature table: Link up the regulatory attributes with the linking table.
23	\N	patch	patch_84_85_m.sql|Normalise regulatory feature table: Clean up temporary columns and tables.
24	\N	patch	patch_84_85_n.sql|Make activity an enum.
25	\N	patch	patch_84_85_o.sql|Delete all MultiCell regulatory features feature set entries.
26	\N	patch	patch_84_85_p.sql|Delete MultiCell feature_set and epigenome.
27	\N	patch	patch_84_85_q.sql|Rename table regulatory_attribute to regulatory_evidence.
28	\N	patch	patch_84_85_r.sql|Drop unused empty tables
29	\N	patch	patch_84_85_s.sql|modify table_name column in result_set_input table
30	\N	patch	patch_84_85_t.sql|Drop table regbuild_string
31	\N	patch	patch_84_85_u.sql|Remove regulatory build entries from feature_set table, relink everything else.
32	\N	patch	patch_84_85_v.sql|Move meta entries regarding regulatory build to the regulatory_build table
33	\N	patch	patch_84_85_w.sql|Extend the name length in the input_subset table
34	\N	patch	patch_84_85_x.sql|Remove unused columns in the experiment table
35	\N	patch	patch_84_85_y.sql|Table for storing epigenomes used in the regulatory build
36	\N	patch	patch_84_85_z.sql|Move segmentation entries from result_set table into the new segmentation_file table.
37	\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.
38	\N	patch	patch_84_85_zb.sql|Bugfix, the primary key was wrongly named.
39	\N	patch	patch_85_86_a.sql|schema_version
40	\N	patch	patch_85_86_b.sql|Drop tables epigenome_lineage and lineage
41	\N	patch	patch_85_86_c.sql|Add production name column to feature_type table
42	\N	patch	patch_85_86_d.sql|Add new columns to input_subset table to accommodate paired-end data
43	\N	patch	patch_85_86_e.sql|Add QC tables
44	\N	patch	patch_86_87_a.sql|schema_version
45	\N	patch	patch_86_87_b.sql|Change data type of certain columns to facilitate foreing key constraints
46	\N	patch	patch_86_87_c.sql|Remove obsolete coloumns from external_feature_file
47	\N	patch	patch_86_87_d.sql|Add 'unknown' as a valid gender in the epigenome table
48	\N	patch	patch_86_87_e.sql|Increase data_set.name length
49	\N	patch	patch_87_88_a.sql|schema_version
50	\N	patch	patch_87_88_b.sql|seq_region_name_255
51	\N	patch	patch_87_88_c.sql|sample_regulatory_feature_id field for regulatory build
52	\N	patch	patch_88_89_a.sql|schema_version
53	\N	patch	patch_88_89_b.sql|Created probe_seq table
54	\N	patch	patch_88_89_c.sql|created probe_feature_transcript table
55	\N	patch	patch_88_89_d.sql|created probe_transcript table
56	\N	patch	patch_88_89_e.sql|created probeset_transcript table
57	\N	patch	patch_88_89_f.sql|Removed probe features from object_xref and xref table
58	\N	patch	patch_88_89_g.sql|Removed probe mappings from the xref tables
59	\N	patch	patch_88_89_h.sql|Removed probe set mappings from the xref tables
60	\N	patch	patch_88_89_i.sql|New columns for array table
61	\N	patch	patch_88_89_j.sql|Added array_chip_id column to probe_set table
62	\N	patch	patch_88_89_k.sql|Added probe_seq_id column to probe table
63	\N	patch	patch_89_90_a.sql|schema_version
64	\N	patch	patch_89_90_b.sql|probe feature columns
65	\N	patch	patch_89_90_c.sql|Adds stable id index for probe_transcript table
66	\N	patch	patch_89_90_d.sql|Adds stable id index for probe_set_transcript table
67	\N	patch	patch_90_91_a.sql|schema_version
68	\N	patch	patch_90_91_b.sql|Remove sequence regions from previous releases
69	\N	patch	patch_90_91_c.sql|Translate sequence region ids of regulatory features
70	\N	patch	patch_90_91_d.sql|Replace regulatory features with updated ones
71	\N	patch	patch_90_91_e.sql|Translate sequence region ids of segmentation features
72	\N	patch	patch_90_91_f.sql|Replace segmentation features with updated ones
73	\N	patch	patch_90_91_g.sql|Translate sequence region ids of probe features
74	\N	patch	patch_90_91_h.sql|Replace probe features with updated ones
75	\N	patch	patch_90_91_i.sql|Translate sequence region ids of annotated features
76	\N	patch	patch_90_91_j.sql|Replace annotated features with updated ones
77	\N	patch	patch_90_91_k.sql|Translate sequence region ids of external features
78	\N	patch	patch_90_91_l.sql|Replace external features with updated ones
79	\N	patch	patch_90_91_m.sql|Translate sequence region ids of mi rna target features
80	\N	patch	patch_90_91_n.sql|Replace mi rna target features with updated ones
81	\N	patch	patch_90_91_o.sql|Translate sequence region ids of motif features
82	\N	patch	patch_90_91_p.sql|Replace motif features with updated ones
83	\N	patch	patch_90_91_q.sql|Drop seq_region table
84	\N	patch	patch_90_91_r.sql|Translate coord_system_ids in meta_coord table
85	\N	patch	patch_90_91_s.sql|Replace meta coord table with the updated table
86	\N	patch	patch_90_91_t.sql|Drop coord_system table
87	\N	patch	patch_90_91_u.sql|Set default gender to unknown for epigenomes
88	\N	patch	patch_90_91_v.sql|Create read_file table and populate it
89	\N	patch	patch_90_91_w.sql|Create read_file_experimental_configuration table and populate it
90	\N	patch	patch_90_91_x.sql|Rename result_set to alignment in various tables and columns
91	\N	patch	patch_90_91_y.sql|Rename annotated_feature to peak
92	\N	patch	patch_90_91_z.sql|Drop input_subset table
93	\N	patch	patch_90_91_za.sql|Move peak_callings from feature_set to peak_calling
94	\N	patch	patch_90_91_zb.sql|Rename another table
95	\N	patch	patch_90_91_zc.sql|Remove peak_callings from the feature_set table
96	\N	patch	patch_90_91_zd.sql|Drop data_set table
97	\N	patch	patch_90_91_ze.sql|Drop supporting_set table
98	\N	patch	patch_90_91_zf.sql|Drop status tables
99	\N	patch	patch_90_91_zg.sql|rename table dbfile_registry to data_file and change the way alignments link to it
100	\N	patch	patch_90_91_zh.sql|Add new columns to read_file_experimental_configuration table
101	\N	patch	patch_90_91_zi.sql|Create probe_id index on probe_transcript table
102	\N	patch	patch_91_92_a.sql|schema_version
103	\N	patch	patch_91_92_b.sql|Drop column paired_with from table read_file
104	\N	patch	patch_91_92_c.sql|Create underlying_structure table
105	\N	patch	patch_92_93_a.sql|schema_version
106	\N	patch	patch_92_93_b.sql|Allow failed peak callings
107	\N	patch	patch_92_93_c.sql|Allow the number of reads to be stored
108	\N	patch	patch_92_93_d.sql|Create table for chance quality check
109	\N	patch	patch_92_93_e.sql|Peak_calling table changes
110	\N	patch	patch_92_93_f.sql|Updates to alignment table
111	\N	patch	patch_92_93_g.sql|New table idr
112	\N	patch	patch_92_93_h.sql|execution_plan table
113	\N	patch	patch_92_93_i.sql|Add table to store fastqc outcomes
114	\N	patch	patch_92_93_j.sql|phantom peak table
115	\N	patch	patch_92_93_k.sql|Add table to store frip scores
116	\N	patch	patch_92_93_l.sql|Remove unused epigenome columns
117	\N	patch	patch_92_93_m.sql|Remove constraints
118	\N	patch	patch_92_93_n.sql|Fix ids, add missing autoincrement
119	\N	patch	patch_92_93_o.sql|Create peak_calling_statistic table
120	\N	patch	patch_92_93_p.sql|Create segmentation_state_assignment table
121	\N	patch	patch_92_93_q.sql|Create segmentation_state_emission table
122	\N	patch	patch_92_93_r.sql|Create regulatory_build_statistics table
123	\N	patch	patch_92_93_s.sql|drop segmentation_feature table
124	\N	patch	patch_92_93_t.sql|drop alignment_qc_phantom_peak table
125	\N	patch	patch_92_93_u.sql|Create probemapping meta table
126	\N	patch	patch_92_93_v.sql|Create probemapping statistic table
127	\N	patch	patch_92_93_w.sql|Modify index name_exp_idx from table read_file_experimental_configuration
128	\N	patch	patch_93_94_a.sql|schema_version
129	\N	patch	patch_93_94_b.sql|Modify column display_label length from epigenome table
130	\N	patch	patch_93_94_c.sql|Adds table segmentation_cell_table_ctcf
131	\N	patch	patch_93_94_d.sql|Adds table segmentation_cell_table_without_ctcf
132	\N	patch	patch_93_94_e.sql|Create transcription_factor table
133	\N	patch	patch_93_94_f.sql|Create transcription_factor_complex table
134	\N	patch	patch_93_94_g.sql|Create transcription_factor_complex_composition table
135	\N	patch	patch_93_94_h.sql|Create binding_matrix_transcription_factor_complex table
136	\N	patch	patch_93_94_i.sql|Modify motif_feature table
137	\N	patch	patch_93_94_j.sql|Create motif_feature_peak table
138	\N	patch	patch_93_94_k.sql|Create motif_feature_regulatory_feature table
139	\N	patch	patch_93_94_l.sql|Modify binding_matrix_table
140	\N	patch	patch_93_94_m.sql|Create binding_matrix_frequencies table
141	\N	patch	patch_93_94_n.sql|Modify indices in motif_feature_peak table
142	\N	patch	patch_93_94_o.sql|Add indices to motif_feature_regulatory_feature table
143	\N	patch	patch_93_94_p.sql|Modify column display_label length from epigenome table
144	\N	patch	patch_94_95_a.sql|schema_version
145	\N	patch	patch_94_95_b.sql|update to segmentation state tables
146	\N	patch	patch_94_95_c.sql|Update to alignment table
147	\N	patch	patch_94_95_d.sql|Update to execution_plan table
148	\N	patch	patch_94_95_e.sql|Update to regulatory_build_statistic table
149	\N	patch	patch_94_95_f.sql|Update to experimental_group table
150	\N	patch	patch_94_95_g.sql|segmentation table
151	\N	patch	patch_94_95_h.sql|segmentation_cell_tables
152	\N	patch	patch_94_95_i.sql|segmentation_statistic table
153	\N	patch	patch_94_95_j.sql|segmentation_file table
154	\N	patch	patch_94_95_k.sql|peak calling statistic table
155	\N	patch	patch_94_95_l.sql|Modify length for column name from epigenome table
156	\N	patch	patch_94_95_m.sql|drop obsolete tables
157	\N	patch	patch_94_95_n.sql|add unique constrain on display_label column for epigenome table
158	\N	patch	patch_95_96_a.sql|schema_version
159	\N	patch	patch_95_96_b.sql|changed data type for regulatory build statistics
160	\N	patch	patch_95_96_c.sql|make unique probe_id column from probe table
161	\N	patch	patch_95_96_d.sql|add ReadFile to the enum of the ensembl_object_type
162	\N	patch	patch_95_96_e.sql|Add description and release_version columns to regulatory_build table
163	\N	patch	patch_95_96_f.sql|Modify binding_matrix_table
164	\N	patch	patch_96_97_a.sql|schema_version
165	\N	patch	patch_96_97_b.sql|Changed to text
166	\N	patch	patch_96_97_c.sql|Added flag
167	\N	patch	patch_96_97_d.sql|Fix foreign key data type inconsistencies
168	\N	patch	patch_96_97_e.sql|Update mirna_target_feature
169	\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
170	\N	patch	patch_96_97_g.sql|Modify column in regulatory_activity
171	\N	patch	patch_97_98_a.sql|schema_version
172	\N	patch	patch_97_98_b.sql|Update unique constraint in mirna_target_feature table
173	\N	patch	patch_98_99_a.sql|schema_version
174	\N	patch	patch_98_99_b.sql|update datetime default value
175	\N	patch	patch_99_100_a.sql|schema_version
176	\N	patch	patch_99_100_b.sql|rename so_name to so_term
177	\N	patch	patch_99_100_c.sql|remove default values from text data type
178	\N	patch	patch_99_100_d.sql|update type column on external_db table
179	\N	patch	patch_99_100_e.sql|Make some foreign keys not mandatory
180	\N	patch	patch_100_101_a.sql|schema_version
181	\N	patch	patch_101_102_a.sql|schema_version
182	\N	patch	patch_101_102_b.sql|Drop underlying_structure table
183	\N	patch	patch_102_103_a.sql|schema_version
184	\N	patch	patch_103_104_a.sql|schema_version
185	1	species.division	EnsemblVertebrates
186	\N	patch	patch_104_105_a.sql|schema_version
187	\N	patch	patch_104_105_b.sql|New indices
188	\N	patch	patch_105_106_a.sql|schema_version
189	\N	patch	patch_106_107_a.sql|schema_version
190	\N	patch	patch_107_108_a.sql|schema_version
191	\N	patch	patch_107_108_b.sql|New epigenome_track table
192	\N	patch	patch_108_109_a.sql|schema_version
193	\N	patch	patch_109_110_a.sql|schema_version
194	\N	patch	patch_110_111_a.sql|schema_version
195	\N	patch	patch_111_112_a.sql|schema_version
196	\N	patch	patch_111_112_b.sql|fix data_file_id length
197	\N	patch	patch_111_112_c.sql|set data_file_id to not null auto increment
198	\N	patch	patch_112_113_b.sql|fix_compatibility_issues