# Doctrine Migration File Generated on 2019-01-18 20:53:50

# Version 20180329185634
ALTER TABLE mt_lead_event_log DROP FOREIGN KEY FK_AF1A0B7955458D;
ALTER TABLE mt_lead_event_log ADD CONSTRAINT FK_AF1A0B7955458D FOREIGN KEY (lead_id) REFERENCES mt_leads (id) ON DELETE CASCADE;
INSERT INTO mt_migrations (version) VALUES ('20180329185634');

# Version 20180329200949
INSERT INTO mt_migrations (version) VALUES ('20180329200949');

# Version 20180404185715
INSERT INTO mt_migrations (version) VALUES ('20180404185715');

# Version 20180406233027
INSERT INTO mt_migrations (version) VALUES ('20180406233027');

# Version 20180410101632
ALTER TABLE `mt_lead_devices` ADD UNIQUE `mt_tracking_id` (`tracking_id`);;
INSERT INTO mt_migrations (version) VALUES ('20180410101632');

# Version 20180419145934
UPDATE `mt_lead_fields` SET is_listable = 1 WHERE is_listable = 0;;
INSERT INTO mt_migrations (version) VALUES ('20180419145934');

# Version 20180507150753
INSERT INTO mt_migrations (version) VALUES ('20180507150753');

# Version 20180515082957
INSERT INTO mt_migrations (version) VALUES ('20180515082957');

# Version 20180516201301
INSERT INTO mt_migrations (version) VALUES ('20180516201301');

# Version 20180516211256
INSERT INTO mt_migrations (version) VALUES ('20180516211256');

# Version 20180604000000
INSERT INTO mt_migrations (version) VALUES ('20180604000000');

# Version 20180622152140
INSERT INTO mt_migrations (version) VALUES ('20180622152140');

# Version 20180625222654
INSERT INTO mt_migrations (version) VALUES ('20180625222654');

# Version 20180722100755
INSERT INTO mt_migrations (version) VALUES ('20180722100755');

# Version 20180730070549
INSERT INTO mt_migrations (version) VALUES ('20180730070549');

# Version 20180801081855
INSERT INTO mt_migrations (version) VALUES ('20180801081855');

# Version 20180829202029
INSERT INTO mt_migrations (version) VALUES ('20180829202029');

# Version 20180830004341
INSERT INTO mt_migrations (version) VALUES ('20180830004341');

# Version 20180906165938
INSERT INTO mt_migrations (version) VALUES ('20180906165938');

# Version 20181004211855
INSERT INTO mt_migrations (version) VALUES ('20181004211855');

# Version 20181008234543
INSERT INTO mt_migrations (version) VALUES ('20181008234543');

# Version 20181011150000
UPDATE `mt_page_hits` SET url = replace(url, '&#38;', '&') WHERE url LIKE "%&#38;%";;
INSERT INTO mt_migrations (version) VALUES ('20181011150000');
