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