-- Drop Custom Pricing Tables
-- This script removes custom pricing functionality from the system
-- Execute this script to permanently delete the custom_pricing and store_custom_pricing tables

-- Drop store_custom_pricing table (store owner custom pricing)
DROP TABLE IF EXISTS `store_custom_pricing`;

-- Drop custom_pricing table (admin custom pricing)
DROP TABLE IF EXISTS `custom_pricing`;

-- Note: After running this script, the system will only use tiered pricing (range-based pricing)
-- from agent_pricing_rules and store_pricing tables

