--
-- Remove the module from setup_module table
--
DELETE FROM `setup_module` WHERE `setup_module`.`module` = "Cart2Quote_Quotation";
--
-- Remove Cart2Quote configuration from core_config_data
--
DELETE FROM `core_config_data` WHERE `path` LIKE "cart2quote_%";
--
-- Remove Sequence information used for the increment id's
--
DELETE FROM `sales_sequence_profile` WHERE `meta_id` IN (SELECT `meta_id` FROM `sales_sequence_meta` WHERE `entity_type` LIKE "quote");
DELETE FROM `sales_sequence_meta` WHERE `entity_type` LIKE "quote";
--
-- Remove the increment id tables per store
-- NOTE: add the statement "DROP TABLE IF EXISTS `sequence_quote_{store_id}`;" per store id
--

--
-- Remove all the Cart2Quote tables
--

--
-- Remove the column "linked_quotation_id" from the "quote" table
--
ALTER TABLE `quote` DROP COLUMN `linked_quotation_id`;


