INSERT INTO `mn_zz_DocItemType` (`name`, `title`) VALUES ('Member/MyAccount', 'Member My Account'); UPDATE `mn_zz_DocItem` SET `type` = 'Member/MyAccount' WHERE `id_doc` = 28 AND `type` = 'Member/Overview'; DELETE FROM `mn_zz_DocItemType` WHERE `name` = 'Member/Overview'; DELETE `d`, `di`, `hb`, `hbc` FROM `mn_zz_Doc` AS `d` LEFT JOIN `mn_zz_DocItem` AS `di` ON `di`.`id_doc` = `d`.`id` LEFT JOIN `mn_zz_DocTitle` AS `dt` ON `dt`.`id_parent` = `d`.`id` LEFT JOIN `mn_zz_HTMLBlock` AS `hb` ON `hb`.`name` = `di`.`name` AND `di`.`type` = 'HTMLBlock/Show' LEFT JOIN `mn_zz_HTMLBlockContent` AS `hbc` ON `hbc`.`id_parent` = `hb`.`id` WHERE `d`.`id` IN(32, 52); DELETE FROM `mn_zz_DocItemType` WHERE `name` = 'Member/Profile'; ALTER TABLE `mn_Member` DROP `show_rss`; DELETE `dit`, `di` FROM `mn_zz_DocItemType` AS `dit` LEFT JOIN `mn_zz_DocItem` AS `di` ON `di`.`type` = `dit`.`name` WHERE `dit`.`name` IN ('Member/CustomizeRss', 'RssFeed/Block');