-- =========================
-- DROP ORDER DISCOUNTS
-- =========================
DROP INDEX IF EXISTS idx_order_discounts_discount;
DROP INDEX IF EXISTS idx_order_discounts_outlet;
DROP INDEX IF EXISTS idx_order_discounts_order;
DROP TABLE IF EXISTS order_discounts;

-- =========================
-- DROP DISCOUNT CATEGORIES
-- =========================
DROP INDEX IF EXISTS idx_discount_categories_category;
DROP INDEX IF EXISTS idx_discount_categories_discount;
DROP TABLE IF EXISTS discount_categories;

-- =========================
-- DROP DISCOUNT PRODUCTS
-- =========================
DROP INDEX IF EXISTS idx_discount_products_product;
DROP INDEX IF EXISTS idx_discount_products_discount;
DROP TABLE IF EXISTS discount_products;

-- =========================
-- DROP DISCOUNT OUTLETS
-- =========================
DROP INDEX IF EXISTS idx_discount_outlets_outlet;
DROP INDEX IF EXISTS idx_discount_outlets_discount;
DROP TABLE IF EXISTS discount_outlets;

-- =========================
-- DROP DISCOUNTS
-- =========================
DROP INDEX IF EXISTS idx_discounts_customer_type;
DROP INDEX IF EXISTS idx_discounts_dates;
DROP INDEX IF EXISTS idx_discounts_active;
DROP INDEX IF EXISTS idx_discounts_code;
DROP INDEX IF EXISTS idx_discounts_organization;
DROP INDEX IF EXISTS idx_discounts_campaign;
DROP TABLE IF EXISTS discounts;