1	\N	schema_version	113
2	\N	patch	patch_54_55_a.sql|schema version
3	\N	patch	patch_54_55_b.sql|add NO_CONSEQUENCE for cnv
4	\N	patch	patch_54_55_c.sql|changed description for failed_description table
5	\N	patch	patch_55_56_a.sql|schema version
6	\N	patch	patch_55_56_b.sql|add subsnp_id
7	\N	patch	patch_55_56_c.sql|add subsnp_handle
8	\N	patch	patch_56_57_a.sql|schema version
9	\N	patch	patch_56_57_b.sql|add LD option to display column in sample
10	\N	patch	patch_56_57_c.sql|add structural variation
11	\N	patch	patch_56_57_d.sql|new consequence type PARTIAL_CODON
12	\N	patch	patch_56_57_e.sql|variation set tables
13	\N	patch	patch_57_58_a.sql|schema version
14	\N	patch	patch_57_58_b.sql|add cds_start, cds_end, change transcript_id to stable_id in transcript_variation
15	\N	patch	patch_57_58_c.sql|new consequence type NMD_TRANSCRIPT
16	\N	patch	patch_57_58_d.sql|new column url in source table
17	\N	patch	patch_58_59_a.sql|schema version
18	\N	patch	patch_58_59_b.sql|new validation status: precious
19	\N	schema_type	variation
20	\N	patch	patch_58_59_c.sql|schema_type entry in meta table
21	\N	patch	patch_58_59_d.sql|add somatic column to source table
22	\N	patch	patch_58_59_e.sql|add 1000Genome validation_status
23	\N	patch	patch_59_60_a.sql|schema version
24	\N	patch	patch_59_60_b.sql|add count column to allele and population_genotype
25	\N	patch	patch_59_60_c.sql|add flipped column to variation
26	\N	patch	patch_59_60_d.sql|modify index on variation_feature and structural_variation
27	\N	patch	patch_60_61_a.sql|schema version
28	\N	patch	patch_60_61_b.sql|change structure of failed_variation table
29	\N	patch	patch_60_61_c.sql|change allele columns in tmp_individual_genotype_single_bp to char(1)
30	\N	patch	patch_60_61_d.sql|change type of column in variation_annotation to double
31	\N	patch	patch_60_61_e.sql|add new failed_description entry
32	\N	patch	patch_60_61_f.sql|add allele_string column to structural variation
33	\N	patch	patch_60_61_g.sql|add variation_set_id column to variation_feature table
34	\N	patch	patch_60_61_h.sql|add support for storing the class of a variation in the database using the SO id
35	\N	patch	patch_60_61_i.sql|add a failed description for variations with no associated sequence
36	\N	patch	patch_60_61_j.sql|change the display tern for insertions and deletions
37	\N	patch	patch_60_61_k.sql|change the p_value datatype from varchar to double in the variation_annotation table
38	\N	patch	patch_61_62_a.sql|schema version
39	\N	patch	patch_61_62_b.sql|change structure of failed_variation table
40	\N	patch	patch_61_62_c.sql|add failed_allele table
41	\N	patch	patch_61_62_d.sql|add a type column in the source table
42	\N	patch	patch_61_62_e.sql|add the tables study and supporting_structural_variation
43	\N	patch	patch_61_62_f.sql|add a study_id column in the tables structural_variation and variation_annotation
44	\N	patch	patch_61_62_g.sql|move somatic flag from source to variation and variation_feature tables
45	\N	patch	patch_61_62_h.sql|use the attrib_id for the var_class
46	\N	patch	patch_61_62_i.sql|change the consequence_type column in variation_feature to use SO terms
47	\N	patch	patch_61_62_j.sql|change fields that hold alleles to large varchars
48	\N	patch	patch_61_62_k.sql|add MARTDISPLAYABLE option to sample display column
49	\N	patch	patch_61_62_l.sql|update to new transcript_variation schema
50	\N	patch	patch_61_62_m.sql|add new schema for nsSNP predictions
51	\N	patch	patch_61_62_n.sql|add the table associate_study
52	\N	patch	patch_61_62_o.sql|add a somatic_status columns to source
53	\N	patch	patch_61_62_p.sql|add some failed descriptions
54	\N	patch	patch_61_62_q.sql|revert ancestral_allele to varchar 255
55	\N	patch	patch_62_63_a.sql|schema version
56	\N	patch	patch_62_63_b.sql|add a column for specifying a variation set short name as an attribute
57	\N	patch	patch_62_63_c.sql|add a unique constraint on the index for attrib_type_id and value columns in attrib table
58	\N	patch	patch_62_63_d.sql|alter some structural_variation columns and a supporting_structural_variation index
59	\N	patch	patch_62_63_e.sql|change the default value of the study name column
60	\N	patch	patch_63_64_a.sql|schema version
61	\N	patch	patch_63_64_b.sql|structural variation changes
62	\N	patch	patch_63_64_c.sql|update to new protein function prediction schema
63	\N	patch	patch_63_64_d.sql|add lsdb entry to enum in type column
64	\N	patch	patch_63_64_e.sql|remove the column somatic from the structural variation table
65	\N	patch	patch_64_65_a.sql|schema version
66	\N	patch	patch_64_65_b.sql|structural variation schema changes
67	\N	patch	patch_64_65_c.sql|adds a failed table for structural variation
68	\N	patch	patch_64_65_d.sql|adds a variation set table for structural variation
69	1	ploidy	1
70	\N	patch	patch_64_65_e.sql|add meta entry for ploidy
71	\N	patch	patch_64_65_f.sql|creates and populates allele_code and genotype_code
72	\N	patch	patch_64_65_g.sql|creates and populates new allele and population_genotype tables
73	\N	patch	patch_64_65_h.sql|creates new genotype tables
74	\N	patch	patch_64_65_i.sql|add support for new data types from dbSNP
75	\N	patch	patch_65_66_a.sql|fix species_id in ploidy entry
76	\N	patch	patch_65_66_b.sql|remove unused tables
77	\N	patch	patch_65_66_c.sql|populate the columns is_evidence and variation_set_id into the structural variation feature table
78	\N	patch	patch_65_66_d.sql|Added coord_system table and update seq_region table in include coord_system_id in order to support multiple-species variation databases
79	\N	patch	patch_65_66_e.sql|schema version
80	\N	patch	patch_65_66_f.sql|change tagged_variation_feature to store relationship between tag and tagged
81	\N	patch	patch_66_67_a.sql|schema version
82	\N	patch	patch_66_67_b.sql|update protein function predictions table schema
83	\N	patch	patch_66_67_c.sql|update the structural_variation schema
84	\N	patch	patch_67_68_a.sql|schema version
85	\N	patch	patch_67_68_b.sql|update the transcript_variation table
86	\N	patch	patch_67_68_c.sql|change consequence_type sets in transcript_variation and variation_feature
87	\N	patch	patch_67_68_d.sql|add distance_to_transcript field to transcript_variation
88	\N	patch	patch_67_68_e.sql|add MAF columns to variation_feature
89	\N	patch	patch_67_68_f.sql|update to store frequency submitter handle in allele table
90	\N	patch	patch_67_68_g.sql|update to description text in the failed_description table
91	\N	patch	patch_67_68_h.sql|rename consequence_type to consequence_types in variation_feature and add index
92	\N	patch	patch_67_68_i.sql|change the type of the column study_type in the study table
93	\N	patch	patch_68_69_a.sql|schema version
94	\N	patch	patch_68_69_b.sql|update the variation_feature table
95	\N	patch	patch_68_69_c.sql|update for dbSNP handle information
96	\N	patch	patch_68_69_d.sql|additional variant fail class
97	\N	patch	patch_68_69_e.sql|length change for source.name 
98	\N	patch	patch_69_70_a.sql|schema version
99	\N	patch	patch_69_70_b.sql|drop table flanking_sequence
100	\N	patch	patch_69_70_c.sql|add freqs_from_gts column to sample table
101	\N	patch	patch_69_70_d.sql|add regulatory region variation tables
102	\N	patch	patch_69_70_e.sql|add consequence terms to consequence_types set in variation_feature
103	\N	patch	patch_70_71_a.sql|schema version
104	\N	patch	patch_70_71_b.sql|add evidence column
105	\N	patch	patch_70_71_c.sql|increase size of minor_allele
106	\N	patch	patch_70_71_d.sql|drop feature_idx from consequence tables
107	\N	patch	patch_70_71_e.sql|create study_variation table
108	\N	patch	patch_70_71_f.sql|add phenotype_feature and phenotype_feature_attrib
109	\N	patch	patch_70_71_g.sql|add stable_id column to phenotype
110	\N	patch	patch_70_71_h.sql|copy data to phenotype_feature and phenotype_feature_attrib
111	\N	patch	patch_70_71_i.sql|drop old annotation tables
112	\N	patch	patch_70_71_j.sql|add pos_idx key to phenotype_feature
113	\N	patch	patch_70_71_k.sql|add type_value_idx key to phenotype_feature_attrib
115	\N	patch	patch_71_72_a.sql|schema version
116	\N	patch	patch_71_72_b.sql|Changes for sample table redesign: Rename columns and indexes
117	\N	patch	patch_71_72_c.sql|Move data from sample table to new individual and population tables.
118	\N	patch	patch_71_72_d.sql|Replace sample_synonym by individual_synonym and population_synonym
119	\N	patch	patch_71_72_e.sql|change variation clinical_significance column
120	\N	patch	patch_71_72_f.sql|new tables for citations
121	\N	patch	patch_71_72_g.sql|Add new columns to the tables structural_variation and structural_variation_feature.
122	\N	patch	patch_71_72_h.sql|Create a table structural_variation_sample. Move the structural variation data from phenotype_feature_attrib to structural_variation_sample and structural_variation.
123	\N	patch	patch_71_72_i.sql|Change the type of the column description in the table study.
124	\N	patch	patch_72_73_a.sql|schema version
125	\N	patch	patch_72_73_b.sql|Add year to publication table
126	\N	patch	patch_72_73_c.sql|Add phased column to genotype_code table
127	\N	patch	patch_72_73_d.sql| revert population_synonym.name and individual_synonym.name to varchars
128	\N	patch	patch_72_73_e.sql|Add ESP to varition set in variation and variation_feature tables
129	\N	patch	patch_73_74_a.sql|schema version
130	\N	patch	patch_73_74_b.sql|Add doi and UCSC id to publication table
131	\N	patch	patch_73_74_c.sql|Add clinical_significance to variation_feature table
132	\N	patch	patch_73_74_d.sql|Add data_types to source table
133	\N	patch	patch_73_74_e.sql|Update indexes for the phenotype table
134	1	species.production_name	saccharomyces_cerevisiae
135	\N	patch	patch_74_75_a.sql|schema version
136	\N	patch	patch_74_75_b.sql|Drop read_coverage table
137	\N	patch	patch_75_76_a.sql|schema version
138	\N	patch	patch_75_76_b.sql|Change evidence storage in Variation & Variation_feature table to attribs
139	\N	patch	patch_75_76_c.sql|Add new table and extra column to population table to specify if population is to be displayed seperately on the PopulationGenetics page and if so with what priority
140	\N	patch	patch_75_76_d.sql|Restore read_coverage table
141	\N	patch	patch_75_76_e.sql|Add has_coverage flag to individual table
142	\N	patch	patch_75_76_f.sql|Add index on the source_id column in variation_feature and phenotype_feature
143	\N	patch	patch_75_76_g.sql|update variation and variation_feature to use the same clinical significance terms as ClinVar
144	\N	patch	patch_75_76_h.sql|Replace the column clinical_significance_attrib_id by clinical_significance in structural_variation
145	\N	patch	patch_75_76_i.sql|Add tables required for HGVS index creation
146	\N	patch	patch_76_77_a.sql|schema version
147	\N	patch	patch_76_77_b.sql|Add new column to Variation table to flag whether variants should be displayed or not
148	\N	patch	patch_76_77_c.sql|update SO consequence terms
149	\N	patch	patch_76_77_d.sql|update SO terms in attrib table
150	\N	patch	patch_76_77_e.sql|add variation_attrib table
151	\N	patch	patch_76_77_f.sql|Add new variation_set_id column to individual table
152	\N	patch	patch_76_77_g.sql|Add new column to Variation_feature table to flag whether variants should be displayed or not
153	\N	patch	patch_77_78_a.sql|schema version
154	\N	patch	patch_77_78_b.sql|Add a column copy_number for CNV supporting structural variants
155	\N	patch	patch_77_78_c.sql|Drop the table study_variation
156	\N	patch	patch_77_78_d.sql|Extend the index type_val_idx in the table attrib
157	\N	patch	patch_77_78_e.sql|add indexes on father_ and mother_individual_id and population name
158	\N	patch	patch_77_78_f.sql|Add new column to the transcript_variation table to flag whether variants should be displayed or not
159	\N	patch	patch_78_79_a.sql|schema version
160	\N	patch	patch_78_79_b.sql|change the column attrib_type_id by attrib_id in the variation_attrib table
161	\N	patch	patch_78_79_c.sql|Store more detailed Sift information
162	\N	patch	patch_79_80_a.sql|schema version
163	\N	patch	patch_79_80_b.sql|create a unique key for the variation_name column in the table structural_variation
164	\N	patch	patch_79_80_c.sql|change the column consequence_types in transcript_variation and variation_feature to add protein_altering_variant and change initiator_codon_variant to start_lost
165	\N	patch	patch_79_80_d.sql|Reduce consequence_terms to the set of relevant SO_terms in motif_feature_variation and regulatory_feature_variation tables
166	\N	patch	patch_79_80_e.sql|update the attrib tables by changing the default values
167	\N	patch	patch_79_80_f.sql|add Phenotype or Disease evidence_attribs
168	\N	patch	patch_80_81_a.sql|schema version
169	\N	patch	patch_80_81_b.sql|Create new sample table and update individual table. Copy individual data into new sample table.
170	\N	patch	patch_80_81_c.sql|Update table, column and index names from individual to sample.
171	\N	patch	patch_80_81_d.sql|Update type of motif_name to varchar.
172	\N	patch	patch_80_81_e.sql|Drop the column strain_id from structural_variation_sample
173	\N	patch	patch_80_81_f.sql|Update meta. Rename sample to individual.
174	\N	patch	patch_81_82_a.sql|schema version
175	\N	patch	patch_81_82_b.sql|update the description in the failed_description table
176	\N	patch	patch_81_82_c.sql|new entry in the failed_description table
177	\N	patch	patch_82_83_a.sql|schema version
178	\N	patch	patch_82_83_b.sql|Add the evidence ExAC in variation and variation_feature
179	\N	patch	patch_82_83_c.sql|Drop the column validation_status in variation and variation_feature
180	\N	patch	patch_57_58_e.sql|new consequence type HGMD_MUTATION
181	\N	patch	patch_83_84_a.sql|schema version
182	\N	patch	patch_84_85_a.sql|schema version
183	\N	patch	patch_84_85_b.sql|create sample_synonym
184	\N	patch	patch_84_85_c.sql|drop column moltype from variation_synonym
187	\N	patch	patch_84_85_f.sql|add phenotype_ontology_accession
242	\N	patch	patch_91_92_a.sql|schema version
189	\N	patch	patch_84_85_d.sql|Making attrib_id auto_increment
190	\N	patch	patch_84_85_e.sql|drop the table tagged_variation_feature
191	\N	patch	patch_84_85_g.sql|allow the column description to store more text in the source table
192	\N	patch	patch_85_86_a.sql|schema version
193	\N	patch	patch_85_86_b.sql|add qualifier & index to phenotype_onology_accession
194	\N	patch	patch_85_86_c.sql|add index on study.external_reference
195	\N	patch	patch_86_87_a.sql|schema version
196	\N	patch	patch_87_88_a.sql|schema version
197	\N	patch	patch_87_88_b.sql|seq_region_name_255
198	\N	patch	patch_88_89_a.sql|schema version
199	\N	patch	patch_88_89_b.sql|Drop strain_gtype_poly table
200	\N	patch	patch_89_90_a.sql|schema version
201	\N	patch	patch_89_90_b.sql|add start_retained_variant to consequence_types in variation_feature and transcript_variation
202	\N	patch	patch_89_90_c.sql|remove regulatory and TFBS consequences from consequence_types in  transcript_variation
203	\N	patch	patch_90_91_a.sql|schema version
204	\N	patch	patch_90_91_b.sql|extend the characters supported in the publication.authors column
205	\N	patch	patch_90_91_c.sql|Add new column zygosity in the table structural_variation_sample
206	\N	patch	patch_91_92_b.sql|Add index on feature_stable_id in regulatory_feature_variation and motif_feature_variation
207	\N	patch	patch_91_92_c.sql|Change the column zygosity in the table structural_variation_sample
208	\N	patch	patch_91_92_d.sql|create table to store names of submitters to ClinVar etc
209	\N	patch	patch_92_93_a.sql|schema version
210	\N	patch	patch_92_93_b.sql|Extend phenotype_ontology_accession mapped_by_attrib predefined set
211	\N	patch	patch_92_93_c.sql|Add new evidence attribs to the variation and variation_feature tables
212	\N	patch	patch_93_94_a.sql|schema version
213	\N	patch	patch_94_95_a.sql|schema version
214	1	sift_version	sift5.2.2
215	1	sift_protein_db_version	uniref90 Release:2015_04
217	1	TranscriptEffect_run_date	2018-10-31
218	1	VariationClass_run_date	2018-10-31
220	\N	patch	patch_94_95_b.sql|create table to store allele synonyms
221	\N	patch	patch_95_96_a.sql|schema version
222	\N	patch	patch_95_96_b.sql|modify index on variation_synonym
223	\N	patch	patch_95_96_c.sql|add new entries to the failed_description table
224	\N	patch	patch_95_96_d.sql|create table to store failed variation features
225	\N	patch	patch_95_96_e.sql|Rename motif_name to binding_matrix_stable_id.
226	\N	patch	patch_96_97_a.sql|schema version
227	\N	patch	patch_96_97_b.sql|move ancestral allele column to variation_feature
228	\N	patch	patch_96_97_c.sql|add an unique index on the name column
229	\N	patch	patch_97_98_a.sql|schema version
230	\N	patch	patch_98_99_a.sql|schema version
231	\N	patch	patch_98_99_b.sql|Add the column data_source_attrib in the table variation_citation
232	\N	patch	patch_98_99_c.sql|Increase the size of the title and doi columns in the publication table
233	\N	patch	patch_98_99_d.sql|add key data_source_attrib
234	\N	patch	patch_98_99_e.sql|Fix attrib ids in table variation_citation
235	\N	patch	patch_99_100_a.sql|schema version
236	\N	patch	patch_99_100_b.sql|add frequency to structural variation
237	\N	patch	patch_99_100_c.sql|add class_attrib_id column to phenotype
238	\N	patch	patch_100_101_a.sql|schema version
239	\N	patch	patch_100_101_b.sql|Add new data_source_attrib to variation_citation
240	1	variation_source.database	1
241	1	variation_source.vcf	0
243	\N	patch	patch_101_102_a.sql|schema version
244	\N	patch	patch_101_102_b.sql|Add new clinical_significance to variation, variation_feature and structural_variation
245	\N	patch	patch_102_103_a.sql|schema version
246	\N	patch	patch_103_104_a.sql|schema version
247	1	species.division	EnsemblVertebrates
248	\N	patch	patch_104_105_a.sql|schema version
249	\N	patch	patch_104_105_b.sql|Increase publication title size
250	\N	patch	patch_105_106_a.sql|schema version
251	\N	patch	patch_106_107_a.sql|schema version
252	\N	patch	patch_106_107_b.sql|consequences update
253	\N	patch	patch_106_107_c.sql|remove regulatory and TFBS consequences from consequence_types in transcript_variation
254	\N	patch	patch_107_108_a.sql|schema version
255	\N	patch	patch_107_108_b.sql|fix SAS population description
256	\N	patch	patch_108_109_a.sql|schema version
257	\N	patch	patch_109_110_a.sql|schema version
258	\N	patch	patch_109_110_b.sql|Add DDG2P data_source_attrib to variation_citation
259	\N	patch	patch_109_110_c.sql|Add new clinical_significance values to variation, variation_feature and structural_variation
260	\N	patch	patch_110_111_a.sql|schema version
261	\N	patch	patch_110_111_b.sql|Update transcript_variation primary key
262	\N	patch	patch_111_112_a.sql|schema version
263	\N	patch	patch_112_113_a.sql|schema version
264	\N	patch	patch_112_113_b.sql|Update meta_key length