1	\N	schema_type	variation
2	\N	schema_version	113
3	\N	patch	patch_90_91_a.sql|schema version
4	\N	patch	patch_90_91_b.sql|extend the characters supported in the publication.authors column
7	1	web_config	menu#Arrays and other##var_other#
6	1	web_config	set#Illumina BovineHD BeadChip#Illumina BovineHD#variation_set_BovineHD#var_other
8	1	web_config	set#All variants on genotyping chips#All genotyping chips#variation_set_all_chips#var_other
9	1	web_config	menu#Failed variants##failed#
10	1	web_config	menu#Sequence variants##variants#
11	1	web_config	source#Sequence variants (EVA and all other sources)#All sequence variants#variation_feature_variation#variants
12	1	web_config	set#Illumina BovineSNP50 BeadChip#Illumina BovineSNP50#variation_set_BovineSNP50#var_other
13	1	web_config	set#All failed variants#All failed variants#variation_set_fail_all#failed
5	1	web_config	set#Illumina BovineLD BeadChip#Illumina BovineLD#variation_set_BovineLD#var_other
15	1	species.production_name	bos_taurus
16	1	ploidy	2
30	\N	patch	patch_91_92_c.sql|Change the column zygosity in the table structural_variation_sample
29	\N	patch	patch_91_92_b.sql|Add index on feature_stable_id in regulatory_feature_variation and motif_feature_variation
27	1	sift_version	sift6.2.1
28	\N	patch	patch_91_92_a.sql|schema version
25	1	HGVS_version	2.121101
23	\N	patch	patch_90_91_c.sql|Add new column zygosity in the table structural_variation_sample
24	1	EquivalentAlleles_run_date	2017-10-11
31	\N	patch	patch_91_92_d.sql|create table to store names of submitters to ClinVar etc
32	1	EPMC_citation_update	2018-2-5
33	1	UCSC_citation_update	2018-2-5
34	\N	patch	patch_92_93_a.sql|schema version
35	\N	patch	patch_92_93_b.sql|Extend phenotype_ontology_accession mapped_by_attrib predefined set
36	\N	patch	patch_92_93_c.sql|Add new evidence attribs to the variation and variation_feature tables
37	\N	patch	patch_93_94_a.sql|schema version
38	\N	patch	patch_94_95_a.sql|schema version
39	\N	patch	patch_94_95_b.sql|create table to store allele synonyms
40	1	sift_version	sift
41	1	sift_protein_db_version	uniref90.fasta
44	1	TranscriptEffect_run_date	2018-10-19
45	1	VariationClass_run_date	2018-10-20
46	1	EquivalentAlleles_run_date	2018-10-26
47	\N	patch	patch_95_96_a.sql|schema version
48	\N	patch	patch_95_96_b.sql|modify index on variation_synonym
49	\N	patch	patch_95_96_c.sql|add new entries to the failed_description table
50	\N	patch	patch_95_96_d.sql|create table to store failed variation features
51	\N	patch	patch_95_96_e.sql|Rename motif_name to binding_matrix_stable_id.
52	\N	patch	patch_96_97_a.sql|schema version
53	\N	patch	patch_96_97_b.sql|move ancestral allele column to variation_feature
54	\N	patch	patch_96_97_c.sql|add an unique index on the name column
55	1	variation_source.database	1
56	1	variation_source.vcf	0
57	\N	patch	patch_97_98_a.sql|schema version
58	1	EPMC_citation_update	2019-07-16
59	1	UCSC_citation_update	2019-07-16
60	\N	patch	patch_98_99_a.sql|schema version
61	\N	patch	patch_98_99_b.sql|Add the column data_source_attrib in the table variation_citation
62	\N	patch	patch_98_99_c.sql|Increase the size of the title and doi columns in the publication table
63	\N	patch	patch_98_99_d.sql|add key data_source_attrib
64	\N	patch	patch_98_99_e.sql|Fix attrib ids in table variation_citation
65	1	PhenotypeAnnotation_run_date_OMIA	2019-10-25
66	\N	patch	patch_99_100_a.sql|schema version
67	\N	patch	patch_99_100_b.sql|add frequency to structural variation
68	\N	patch	patch_99_100_c.sql|add class_attrib_id column to phenotype
69	1	PhenotypeAnnotation_run_date_OMIA	2020-01-22
70	1	PhenotypeAnnotation_run_date_AnimalQTLdb	2020-01-22
71	\N	patch	patch_100_101_a.sql|schema version
72	\N	patch	patch_100_101_b.sql|Add new data_source_attrib to variation_citation
73	1	PhenotypeAnnotation_run_date_OMIA	2020-04-23
74	1	PhenotypeAnnotation_run_date_OMIA	2020-04-24
75	\N	patch	patch_101_102_a.sql|schema version
76	\N	patch	patch_101_102_b.sql|Add new clinical_significance to variation, variation_feature and structural_variation
77	1	PhenotypeAnnotation_run_date_OMIA	2020-07-21
78	1	PhenotypeAnnotation_run_date_AnimalQTLdb	2020-07-23
79	1	PhenotypeAnnotation_run_date_OMIA	2020-07-23
80	\N	patch	patch_102_103_a.sql|schema version
81	\N	patch	patch_103_104_a.sql|schema version
82	1	PhenotypeAnnotation_run_date_OMIA	2021-01-25
83	1	PhenotypeAnnotation_run_date_AnimalQTLdb	2021-01-27
84	1	species.division	EnsemblVertebrates
85	\N	patch	patch_104_105_a.sql|schema version
86	\N	patch	patch_104_105_b.sql|Increase publication title size
87	1	PhenotypeAnnotation_run_date_OMIA	2021-08-03
88	1	PhenotypeAnnotation_run_date_AnimalQTLdb	2021-08-04
89	\N	patch	patch_105_106_a.sql|schema version
90	1	PhenotypeAnnotation_run_date_OMIA	2021-10-21
91	1	PhenotypeAnnotation_run_date_AnimalQTLdb	2021-10-21
92	\N	patch	patch_106_107_a.sql|schema version
93	\N	patch	patch_106_107_b.sql|consequences update
94	\N	patch	patch_106_107_c.sql|remove regulatory and TFBS consequences from consequence_types in transcript_variation
95	1	PhenotypeAnnotation_run_date_OMIA	2022-03-24
96	1	PhenotypeAnnotation_run_date_AnimalQTLdb	2022-03-24
97	\N	patch	patch_107_108_a.sql|schema version
98	\N	patch	patch_107_108_b.sql|fix SAS population description
99	1	EPMC_citation_update	2022-07-13
100	1	EquivalentAlleles_run_date	2022-07-15
101	1	PhenotypeAnnotation_run_date_OMIA	2022-07-15
102	1	PhenotypeAnnotation_run_date_AnimalQTLdb	2022-07-15
103	1	TranscriptEffect_run_date	2022-07-19
104	1	VariationClass_run_date	2022-07-20
105	1	web_config	source#EVA variants#EVA#variation_feature_variation_EVA#variants
106	\N	patch	patch_108_109_a.sql|schema version
107	1	TranscriptEffect_run_date	2022-09-22
108	1	VariationClass_run_date	2022-09-22
109	1	PhenotypeAnnotation_run_date_OMIA	2022-10-18
110	1	PhenotypeAnnotation_run_date_AnimalQTLdb	2022-10-18
111	\N	patch	patch_109_110_a.sql|schema version
112	\N	patch	patch_109_110_b.sql|Add DDG2P data_source_attrib to variation_citation
113	\N	patch	patch_109_110_c.sql|Add new clinical_significance values to variation, variation_feature and structural_variation
114	1	EquivalentAlleles_run_date	2023-02-08
115	1	TranscriptEffect_run_date	2023-02-09
116	1	VariationClass_run_date	2023-02-09
117	1	PhenotypeAnnotation_run_date_OMIA	2023-03-05
118	1	PhenotypeAnnotation_run_date_AnimalQTLdb	2023-03-05
119	\N	patch	patch_110_111_a.sql|schema version
120	\N	patch	patch_110_111_b.sql|Update transcript_variation primary key
121	1	EquivalentAlleles_run_date	2023-07-10
122	1	TranscriptEffect_run_date	2023-07-11
123	1	VariationClass_run_date	2023-07-11
124	1	TranscriptEffect_run_date	2023-07-12
125	1	VariationClass_run_date	2023-07-12
126	1	PhenotypeAnnotation_run_date_OMIA	2023-07-25
127	\N	patch	patch_111_112_a.sql|schema version
128	1	PhenotypeAnnotation_run_date_OMIA	2023-11-24
129	\N	patch	patch_112_113_a.sql|schema version
130	\N	patch	patch_112_113_b.sql|Update meta_key length
131	1	PhenotypeAnnotation_run_date_OMIA	2024-06-18
132	1	PhenotypeAnnotation_run_date_OMIA	2024-06-19
133	1	PhenotypeAnnotation_run_date_AnimalQTLdb	2024-06-19