534 \N schema_version 109 80 \N patch patch_50_51_b.sql|multispecies 83 \N patch patch_50_51_c.sql|associated_feature_type 82 \N patch patch_50_51_a.sql|cell_type_description 86 \N patch patch_50_51_d.sql|regulatory_feature.display_label 102 \N patch patch_51_52_a.sql|widen_columns 103 \N patch patch_51_52_b.sql|external_db_description 106 \N patch patch_52_53_a.sql|unmapped_tables 105 \N patch patch_52_53_b.sql|redefine analysis_description 107 \N patch patch_52_53_c.sql|ensembl_object_type ProbeSet Probe 108 \N patch patch_52_53_d.sql|identity_xref ensembl xref id start end 109 \N patch patch_52_53_f.sql|array.class 110 \N patch patch_52_53_g.sql|regulatory_feature.bound_seq_region_start/end 112 \N patch patch_52_53_h.sql|feature_set.display_label 113 \N patch patch_52_53_i.sql|probe PRIMARY KEY 114 \N patch patch_52_53_j.sql|ensembl_object_type ProbeFeature 115 \N patch patch_53_54_a.sql|edb.db_name length 116 \N patch patch_53_54_b.sql|identity_object_analysis_move 118 \N patch patch_53_54_c.sql|multispecies 121 \N patch patch_54_55_d.sql|edb.db_name variation fix 124 \N patch patch_54_55_c.sql|coord_system.is_current_version_null 126 \N patch patch_54_55_b.sql|FK_consistency_tweaks 127 \N patch patch_54_55_a.sql|partition_result_feature 146 \N patch patch_54_55_f.sql|probe_set.name_index 147 \N patch patch_55_56_a.sql|probe_set.name_length 148 \N patch patch_55_56_a.sql|probe_set.name_length 151 \N patch patch_55_56_b.sql|probe_feature.cigar_line_format 152 \N patch patch_55_56_c.sql|analysis_description.display_label_not_null 154 \N patch patch_56_57_b.sql|uo.object_type_id_key 155 \N patch patch_56_57_c.sql|uo.object_type_enum 156 1 species.production_name homo_sapiens 157 \N patch patch_56_57_d.sql|CompareSchema_tidyup 159 \N patch patch_56_57_e.sql|s.table_name_length 160 \N patch patch_56_57_f.sql|result_feature.scores 161 \N patch patch_56_57_g.sql|rename_experimentalset_tables 162 \N patch patch_56_57_h.sql|chip_seq_result_set 163 \N patch patch_56_57_i.sql|cell_type.gender 164 \N patch patch_56_57_k.sql|meta_species.system_name 184 \N patch patch_57_58_a.sql|schema_version 185 \N patch patch_57_58_b.sql|result_feature_paritions 186 \N patch patch_57_58_c.sql|meta.meta_value_length 187 \N patch patch_57_58_d.sql|meta_key.production_name 188 \N patch patch_57_58_e.sql|probe.name_key 197 \N patch patch_58_59_c.sql|annotated_feature.summit 198 \N patch patch_58_59_a.sql|schema_version 199 \N patch patch_58_59_b.sql|probe.description 222 \N patch patch_58_59_d.sql|regulatory_feature.binary_string_projected 223 \N schema_type funcgen 224 \N patch patch_58_59_e.sql|meta.schema_type 225 \N patch patch_58_59_f.sql|result_feature.partitions 242 \N patch patch_59_60_a.sql|schema_version 243 \N patch patch_59_60_b.sql|associated_feature_type.table_name_id 244 \N patch patch_59_60_c.sql|motif_feature_binding_matrix 245 \N patch patch_59_60_d.sql|probe_feature.cigar_line_varchar 246 \N patch patch_59_60_e.sql|regulatory_attribute.allow_motif_table 277 \N patch patch_59_60_f.sql|bm.frequencies_pf.index_mods 278 \N patch patch_59_60_g.sql|rename_go_xref_table 279 \N patch patch_59_60_h.sql|af_amf.index_tweaks 283 \N patch patch_60_61_a.sql|schema_version 284 \N patch patch_60_61_b.sql|binding_matrix.analysis_id 285 \N patch patch_60_61_c.sql|probe.name_alter 286 \N patch patch_60_61_d.sql|rejig_object_xref_indexes 287 \N patch patch_61_62_b.sql|interdb_stable_id 289 \N patch patch_61_62_a.sql|schema_version 290 \N patch patch_61_62_c.sql|feature_type.sequence_ontology 291 \N patch patch_61_62_e.sql|dbfile_registry 292 \N patch patch_61_62_d.sql|experimental_group.description 358 \N patch patch_61_62_g.sql|synonym_field_extension 359 \N patch patch_61_62_i.sql|drop_external_db.display_label_linkable 360 \N patch patch_61_62_h.sql|external_db.db_name_release_idx 361 \N patch patch_61_62_f.sql|regulatory_feature.fset_seq_region_idx 363 \N patch patch_61_62_j.sql|meta_key.extend 368 \N patch patch_62_63_c.sql|binding_matrix.threshold 369 \N patch patch_62_63_a.sql|schema_version 370 \N patch patch_62_63_b.sql|binding_matrix.analysis_id_small_int 372 \N patch patch_63_64_b.sql|cell_type.efo_id 373 \N patch patch_63_64_a.sql|schema_version 375 \N patch patch_63_64_c.sql|experiment.archive_id_data_url 376 \N patch patch_63_64_d.sql|experimental_group.url 418 \N patch patch_63_64_g.sql|index_tidy_up 419 \N patch patch_63_64_e.sql|object_xref.ensembl_object_type 420 \N patch patch_63_64_f.sql|feature_set.experiment_id 421 \N patch patch_64_65_a.sql|schema_version 422 \N patch patch_64_65_b.sql|feature_type.analysis_id 423 \N patch patch_64_65_c.sql|cell_type.gender_hermaphrodite 424 \N patch patch_64_65_d.sql|segmentation_feature 425 \N patch patch_64_65_e.sql|regulatory_attribute.table_enum 426 \N patch patch_64_65_f.sql|input_set.segmentation_type 470 \N patch patch_64_65_g.sql|MAX_ROWS_AVG_ROW_LENGTH_clean_up 514 \N patch patch_65_66_c.sql|array_chip.name_design 515 \N patch patch_65_66_b.sql|cell_type.tissue_and_lineage 516 \N patch patch_65_66_a.sql|schema_version 517 \N patch patch_65_66_d.sql|unmapped_object.reorder_unmapped_obj_index 523 \N patch patch_65_66_e.sql|add_regbuild_string_table 527 \N patch patch_66_67_a.sql|schema_version 528 \N patch patch_66_67_b.sql|regulatory_attribute.attribute_feature_idx 529 \N patch patch_66_67_d.sql|regulatory_feature.binary_string_500 530 \N patch patch_66_67_c.sql|result_feature.remove_partitions 535 \N patch patch_67_68_a.sql|schema_version 536 \N patch patch_67_68_b.sql|input_subset.archive_id_display_url 537 \N patch patch_67_68_c.sql|input_set_subset.replicate_is_control 538 \N patch patch_67_68_d.sql|feature_set.input_set_id 539 \N patch patch_68_69_a.sql|schema_version 540 \N patch patch_68_69_b.sql|DNAMethylationFeature support 541 \N patch patch_68_69_c.sql|regbuild_string.species_id_not_null 542 \N patch patch_68_69_d.sql|xref.id_index_fix 543 \N patch patch_69_70_a.sql|schema_version 545 \N patch patch_70_71_a.sql|schema_version 546 \N patch patch_70_71_b.sql|analysis_key_clean 547 \N patch patch_70_71_c.sql|design_table_removal 550 \N patch patch_71_72_c.sql|added_type_to_supporting_set_PK 551 \N patch patch_71_72_b.sql|associated_xref 552 \N patch patch_71_72_a.sql|schema_version 553 \N patch patch_52_53_e.sql|external_db.type ENSEMBL 554 \N patch patch_54_55_e.sql|feature_type.class_update 555 \N patch patch_56_57_a.sql|schema_version 556 \N patch patch_56_57_j.sql|probe_feature.cigar_line_format 557 \N patch patch_69_70_b.sql|regulatory_feature.bound_start/end_length 558 \N patch patch_72_73_a.sql|schema_version 559 \N patch patch_73_74_b.sql|input_set_subset_split 560 \N patch patch_73_74_c.sql|result_set.replicate 561 \N patch patch_73_74_d.sql|status_name_length 562 \N patch patch_73_74_a.sql|schema_version 563 \N patch patch_73_74_e.sql|drop_probe_design 564 \N patch patch_74_75_a.sql|schema_version 565 \N patch patch_74_75_b.sql|result_set.name_unique 566 \N patch patch_74_75_c.sql|input_subset.analysis_id_experiment_idx 567 \N patch patch_74_75_d.sql|result_set_input.table_name_input_subset 568 \N patch patch_74_75_f.sql|experiment.feature_cell_type_id 569 \N patch patch_74_75_g.sql|analysis.TarBase 590 \N patch patch_79_80_c.sql|stable_id_changed_to_varchar 591 \N patch patch_80_81_b.sql|add gender: mixed to table cell_type 573 \N patch patch_75_76_b.sql|result/feature_set.experiment_id & experiment/input_subset.display_url/archive_id 574 \N patch patch_75_76_c.sql|cell_type.display_label 575 \N patch patch_75_76_d.sql|feature_set.type mirna; object_xref.ensembl_object_type add MirnaTargetFeature 576 \N patch patch_75_76_f.sql|add feature_type.class Transcription Start Site 577 \N patch patch_75_76_a.sql|schema_version 578 \N patch patch_75_76_e.sql|add has_evidence, cell_type_count to regulatory_feature, adjust UNIQUE constraint 579 1 patch patch_75_76_g.sql|mirna_target_feature 580 \N patch patch_76_77_a.sql|schema_version 581 \N patch patch_76_77_b.sql|CTCF feature_type update 582 \N patch patch_76_77_c.sql|Correct mirna so_name and accession in feature_type 583 \N patch patch_76_77_d.sql|Fix errornous feature_type_id in mirna_target_feature 584 \N patch patch_77_78_a.sql|schema_version 585 \N patch patch_77_78_b.sql|Change unmapped_reason_id from smallint to int 586 \N patch patch_78_79_a.sql|schema_version 587 \N patch patch_78_79_b.sql|binding_matrix unique key 588 \N patch patch_79_80_a.sql|schema_version 589 \N patch patch_79_80_b.sql|dbfile_registry_unique_key 592 \N patch patch_80_81_b.sql|add gender: mixed to table cell_type 593 \N patch patch_80_81_a.sql|schema_version 595 \N patch patch_80_81_c.sql|drop experiment.date 596 \N patch patch_81_82_a.sql|schema_version 597 \N patch patch_82_83_a.sql|schema_version 598 \N patch patch_83_84_a.sql|schema_version 599 \N patch patch_83_84_b.sql|Drop unique key for cell_type.efo_id 628 \N patch patch_84_85_v.sql|Move meta entries regarding regulatory build to the regulatory_build table 603 \N patch patch_83_84_c.sql|Add not null constraint to cell_type.display_label 604 \N patch patch_83_84_e.sql|Increase length of regbuild_string.name 605 \N patch patch_83_84_d.sql|Add segmentation enum to result_set.feature_class 606 \N patch patch_83_84_f.sql|Change regulatory_feature has_evidence to activity 607 \N patch patch_84_85_a.sql|schema_version 608 \N patch patch_84_85_b.sql|rename cell_type table 609 \N patch patch_84_85_c.sql|new epigenome table columns 610 \N patch patch_84_85_d.sql|add columns to experiment table 611 \N patch patch_84_85_e.sql|add/modify columns in input_subset table 612 \N patch patch_84_85_f.sql|drop replicate column from result_set table 613 \N patch patch_84_85_g.sql|update dbentry related tables 614 \N patch patch_84_85_h.sql|Store file types along with the files. 615 \N patch patch_84_85_i.sql|Normalise regulatory feature table: Create a non redundant version of the regulatory features. 616 \N patch patch_84_85_j.sql|Normalise regulatory feature table: Create a linking table between regulatory features and feature sets. 617 \N patch patch_84_85_k.sql|Normalise regulatory feature table: Link up the new non redundant regulatory features. 618 \N patch patch_84_85_l.sql|Normalise regulatory feature table: Link up the regulatory attributes with the linking table. 619 \N patch patch_84_85_m.sql|Normalise regulatory feature table: Clean up temporary columns and tables. 620 \N patch patch_84_85_n.sql|Make activity an enum. 621 \N patch patch_84_85_o.sql|Delete all MultiCell regulatory features feature set entries. 622 \N patch patch_84_85_p.sql|Delete MultiCell feature_set and epigenome. 623 \N patch patch_84_85_q.sql|Rename table regulatory_attribute to regulatory_evidence. 624 \N patch patch_84_85_r.sql|Drop unused empty tables 625 \N patch patch_84_85_s.sql|modify table_name column in result_set_input table 626 \N patch patch_84_85_t.sql|Drop table regbuild_string 627 \N patch patch_84_85_u.sql|Remove regulatory build entries from feature_set table, relink everything else. 629 \N patch patch_84_85_w.sql|Extend the name length in the input_subset table 630 \N patch patch_84_85_x.sql|Remove unused columns in the experiment table 631 \N patch patch_84_85_y.sql|Table for storing epigenomes used in the regulatory build 632 \N patch patch_84_85_z.sql|Move segmentation entries from result_set table into the new segmentation_file table. 633 \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. 634 \N patch patch_84_85_zb.sql|Bugfix, the primary key was wrongly named. 635 \N patch patch_85_86_a.sql|schema_version 636 \N patch patch_85_86_b.sql|Drop tables epigenome_lineage and lineage 637 \N patch patch_85_86_c.sql|Add production name column to feature_type table 638 \N patch patch_85_86_d.sql|Add new columns to input_subset table to accommodate paired-end data 639 \N patch patch_85_86_e.sql|Add QC tables 640 \N patch patch_86_87_a.sql|schema_version 641 \N patch patch_86_87_b.sql|Change data type of certain columns to facilitate foreing key constraints 642 \N patch patch_86_87_c.sql|Remove obsolete coloumns from external_feature_file 643 \N patch patch_86_87_d.sql|Add 'unknown' as a valid gender in the epigenome table 644 \N patch patch_86_87_e.sql|Increase data_set.name length 645 \N patch patch_87_88_a.sql|schema_version 646 \N patch patch_87_88_b.sql|seq_region_name_255 647 \N patch patch_87_88_c.sql|sample_regulatory_feature_id field for regulatory build 648 \N patch patch_88_89_a.sql|schema_version 649 \N patch patch_88_89_b.sql|Created probe_seq table 650 \N patch patch_88_89_c.sql|created probe_feature_transcript table 651 \N patch patch_88_89_d.sql|created probe_transcript table 652 \N patch patch_88_89_e.sql|created probeset_transcript table 653 \N patch patch_88_89_f.sql|Removed probe features from object_xref and xref table 654 \N patch patch_88_89_g.sql|Removed probe mappings from the xref tables 655 \N patch patch_88_89_h.sql|Removed probe set mappings from the xref tables 656 \N patch patch_88_89_i.sql|New columns for array table 657 \N patch patch_88_89_j.sql|Added array_chip_id column to probe_set table 658 \N patch patch_88_89_k.sql|Added probe_seq_id column to probe table 659 \N patch patch_89_90_a.sql|schema_version 660 \N patch patch_89_90_b.sql|probe feature columns 661 \N patch patch_89_90_c.sql|Adds stable id index for probe_transcript table 662 \N patch patch_89_90_d.sql|Adds stable id index for probe_set_transcript table 663 \N patch patch_90_91_a.sql|schema_version 664 \N patch patch_90_91_b.sql|Remove sequence regions from previous releases 665 \N patch patch_90_91_c.sql|Translate sequence region ids of regulatory features 666 \N patch patch_90_91_d.sql|Replace regulatory features with updated ones 667 \N patch patch_90_91_e.sql|Translate sequence region ids of segmentation features 668 \N patch patch_90_91_f.sql|Replace segmentation features with updated ones 669 \N patch patch_90_91_g.sql|Translate sequence region ids of probe features 670 \N patch patch_90_91_h.sql|Replace probe features with updated ones 671 \N patch patch_90_91_i.sql|Translate sequence region ids of annotated features 672 \N patch patch_90_91_j.sql|Replace annotated features with updated ones 673 \N patch patch_90_91_k.sql|Translate sequence region ids of external features 674 \N patch patch_90_91_l.sql|Replace external features with updated ones 675 \N patch patch_90_91_m.sql|Translate sequence region ids of mi rna target features 676 \N patch patch_90_91_n.sql|Replace mi rna target features with updated ones 677 \N patch patch_90_91_o.sql|Translate sequence region ids of motif features 678 \N patch patch_90_91_p.sql|Replace motif features with updated ones 679 \N patch patch_90_91_q.sql|Drop seq_region table 680 \N patch patch_90_91_r.sql|Translate coord_system_ids in meta_coord table 681 \N patch patch_90_91_s.sql|Replace meta coord table with the updated table 682 \N patch patch_90_91_t.sql|Drop coord_system table 683 \N patch patch_90_91_u.sql|Set default gender to unknown for epigenomes 684 \N patch patch_90_91_v.sql|Create read_file table and populate it 685 \N patch patch_90_91_w.sql|Create read_file_experimental_configuration table and populate it 686 \N patch patch_90_91_x.sql|Rename result_set to alignment in various tables and columns 687 \N patch patch_90_91_y.sql|Rename annotated_feature to peak 688 \N patch patch_90_91_z.sql|Drop input_subset table 689 \N patch patch_90_91_za.sql|Move peak_callings from feature_set to peak_calling 690 \N patch patch_90_91_zb.sql|Rename another table 691 \N patch patch_90_91_zc.sql|Remove peak_callings from the feature_set table 692 \N patch patch_90_91_zd.sql|Drop data_set table 693 \N patch patch_90_91_ze.sql|Drop supporting_set table 694 \N patch patch_90_91_zf.sql|Drop status tables 695 \N patch patch_90_91_zg.sql|rename table dbfile_registry to data_file and change the way alignments link to it 696 \N patch patch_90_91_zh.sql|Add new columns to read_file_experimental_configuration table 697 \N patch patch_90_91_zi.sql|Create probe_id index on probe_transcript table 698 \N patch patch_91_92_a.sql|schema_version 699 \N patch patch_91_92_b.sql|Drop column paired_with from table read_file 700 \N patch patch_91_92_c.sql|Create underlying_structure table 701 \N patch patch_92_93_a.sql|schema_version 702 \N patch patch_92_93_b.sql|Allow failed peak callings 703 \N patch patch_92_93_c.sql|Allow the number of reads to be stored 704 \N patch patch_92_93_d.sql|Create table for chance quality check 705 \N patch patch_92_93_e.sql|Peak_calling table changes 706 \N patch patch_92_93_f.sql|Updates to alignment table 707 \N patch patch_92_93_g.sql|New table idr 708 \N patch patch_92_93_h.sql|execution_plan table 709 \N patch patch_92_93_i.sql|Add table to store fastqc outcomes 710 \N patch patch_92_93_j.sql|phantom peak table 711 \N patch patch_92_93_k.sql|Add table to store frip scores 712 \N patch patch_92_93_l.sql|Remove unused epigenome columns 713 \N patch patch_92_93_m.sql|Remove constraints 714 \N patch patch_92_93_n.sql|Fix ids, add missing autoincrement 715 \N patch patch_92_93_o.sql|Create peak_calling_statistic table 716 \N patch patch_92_93_p.sql|Create segmentation_state_assignment table 717 \N patch patch_92_93_q.sql|Create segmentation_state_emission table 718 \N patch patch_92_93_r.sql|Create regulatory_build_statistics table 719 \N patch patch_92_93_s.sql|drop segmentation_feature table 720 \N patch patch_92_93_t.sql|drop alignment_qc_phantom_peak table 721 \N patch patch_92_93_u.sql|Create probemapping meta table 722 \N patch patch_92_93_v.sql|Create probemapping statistic table 723 \N patch patch_92_93_w.sql|Modify index name_exp_idx from table read_file_experimental_configuration 724 \N patch patch_93_94_a.sql|schema_version 725 \N patch patch_93_94_b.sql|Modify column display_label length from epigenome table 726 \N patch patch_93_94_c.sql|Adds table segmentation_cell_table_ctcf 727 \N patch patch_93_94_d.sql|Adds table segmentation_cell_table_without_ctcf 728 \N patch patch_93_94_e.sql|Create transcription_factor table 729 \N patch patch_93_94_f.sql|Create transcription_factor_complex table 730 \N patch patch_93_94_g.sql|Create transcription_factor_complex_composition table 731 \N patch patch_93_94_h.sql|Create binding_matrix_transcription_factor_complex table 732 \N patch patch_93_94_i.sql|Modify motif_feature table 733 \N patch patch_93_94_j.sql|Create motif_feature_peak table 734 \N patch patch_93_94_k.sql|Create motif_feature_regulatory_feature table 735 \N patch patch_93_94_l.sql|Modify binding_matrix_table 736 \N patch patch_93_94_m.sql|Create binding_matrix_frequencies table 737 \N patch patch_94_95_a.sql|schema_version 738 \N patch patch_94_95_b.sql|update to segmentation state tables 739 \N patch patch_94_95_c.sql|Update to alignment table 740 \N patch patch_94_95_d.sql|Update to execution_plan table 741 \N patch patch_94_95_e.sql|Update to regulatory_build_statistic table 742 \N patch patch_94_95_f.sql|Update to experimental_group table 743 \N patch patch_94_95_g.sql|segmentation table 744 \N patch patch_94_95_h.sql|segmentation_cell_tables 745 \N patch patch_94_95_i.sql|segmentation_statistic table 746 \N patch patch_94_95_j.sql|segmentation_file table 747 \N patch patch_94_95_k.sql|peak calling statistic table 748 \N patch patch_94_95_l.sql|Modify length for column name from epigenome table 749 \N patch patch_94_95_m.sql|drop obsolete tables 750 \N patch patch_94_95_n.sql|add unique constrain on display_label column for epigenome table 751 \N patch patch_95_96_a.sql|schema_version 752 \N patch patch_95_96_b.sql|changed data type for regulatory build statistics 753 \N patch patch_95_96_c.sql|make unique probe_id column from probe table 754 \N patch patch_95_96_d.sql|add ReadFile to the enum of the ensembl_object_type 755 \N patch patch_95_96_e.sql|Add description and release_version columns to regulatory_build table 756 \N patch patch_96_97_a.sql|schema_version 757 \N patch patch_96_97_b.sql|Changed to text 758 \N patch patch_96_97_c.sql|Added flag 759 \N patch patch_96_97_d.sql|Fix foreign key data type inconsistencies 760 \N patch patch_96_97_e.sql|Update mirna_target_feature 761 \N patch patch_96_97_g.sql|Modify column in regulatory_activity 762 \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 763 \N patch patch_97_98_a.sql|schema_version 764 \N patch patch_97_98_b.sql|Update unique constraint in mirna_target_feature table 765 \N patch patch_98_99_a.sql|schema_version 766 \N patch patch_98_99_b.sql|update datetime default value 767 \N patch patch_99_100_a.sql|schema_version 768 \N patch patch_99_100_b.sql|rename so_name to so_term 769 \N patch patch_99_100_c.sql|remove default values from text data type 770 \N patch patch_99_100_d.sql|update type column on external_db table 771 \N patch patch_99_100_e.sql|Make some foreign keys not mandatory 772 \N patch patch_100_101_a.sql|schema_version 773 \N patch patch_101_102_a.sql|schema_version 774 \N patch patch_101_102_b.sql|Drop underlying_structure table 775 \N patch patch_102_103_a.sql|schema_version 776 \N patch patch_103_104_a.sql|schema_version 777 \N patch patch_104_105_a.sql|schema_version 778 \N patch patch_104_105_b.sql|New indices 779 \N patch patch_105_106_a.sql|schema_version 780 \N patch patch_106_107_a.sql|schema_version 781 \N patch patch_107_108_a.sql|schema_version 782 \N patch patch_107_108_b.sql|New epigenome_track table 783 \N patch patch_108_109_a.sql|schema_version