-- =========================================================
-- cleanup.sql — Remove unrelated/leftover tables from this database
-- Run this ONLY if these tables exist in your CRM database
-- (they belong to a different application, e.g. an online store)
-- =========================================================

DROP TABLE IF EXISTS st_categories;
DROP TABLE IF EXISTS st_customers;
DROP TABLE IF EXISTS st_order_tracking;
DROP TABLE IF EXISTS st_orders;
DROP TABLE IF EXISTS st_products;
DROP TABLE IF EXISTS st_wishlist;
DROP TABLE IF EXISTS vn_contacts;
DROP TABLE IF EXISTS vn_page_views;
DROP TABLE IF EXISTS vn_settings;
DROP TABLE IF EXISTS vn_stats_daily;
DROP TABLE IF EXISTS vn_visitors;

-- After running this, only the 24 CRM/HR tables should remain:
-- organizations, departments, designations, employees, teams, team_members,
-- salary_structures, payroll_runs, payslips, leave_types, leave_balances,
-- leave_requests, attendance, holidays, incentive_rules, employee_incentives,
-- employee_documents, leads, lead_status_history, call_logs,
-- service_zone_mapping, installations, daily_stats, login_logs