-- Copyright [1999-2015] Wellcome Trust Sanger Institute and the EMBL-European Bioinformatics Institute
-- Copyright [2016-2019] EMBL-European Bioinformatics Institute
-- 
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
-- 
--      http://www.apache.org/licenses/LICENSE-2.0
-- 
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.

--insert into feature_type values(NULL, 'TSS 2.5KB', 'Pseudo', 'Feature is within +/-2.5KB of the Transcript Start Site');
i--nsert into feature_type values(NULL, 'TTS 2.5KB', 'Pseudo', 'Feature is within +/-2.5KB of the Transcript Termination Site');


--Human only data patch
--This may change if we do another build for v50
--update meta set meta_value='9,8,23,24,25,26,11,27,12,6,5,4,28,29,13,30,31,14,32,33,34,10,35,36,8,9,11,12,4,13,14,10,178400,178401' where meta_key='regulatory_string_feature_type_id';


--remove MT reg features
-- delete from regulatory_feature where seq_region_id =137;
--End human only data patch

--mouse Vienna set renaming and feature_type fix
--update result_set set name=replace(name, 'H4K4', 'H3K4') where name like "Vienna MEFf H4K4%";
--update data_set set name=replace(name, 'H4K4', 'H3K4') where name like "Vienna MEFf H4K4%";
--update feature_set set name=replace(name, 'H4K4', 'H3K4') where name like "Vienna MEFf H4K4%";

--update result_set set feature_type_id=(select feature_type_id from feature_type where name='H3K4me3') where name like 'Vienna MEFf H3K4me3';
--update result_set set feature_type_id=(select feature_type_id from feature_type where name='H3K4me2') where name like 'Vienna MEFf H3K4me2';
--update feature_set set feature_type_id=(select feature_type_id from feature_type where name='H3K4me3') where name like 'Vienna MEFf H3K4me3';
--update feature_set set feature_type_id=(select feature_type_id from feature_type where name='H3K4me2') where name like 'Vienna MEFf H3K4me2';
