-- Add new billing fields and remove dependency on predefined GST logic
ALTER TABLE billing_records
ADD COLUMN IF NOT EXISTS order_type VARCHAR(50) DEFAULT NULL,
ADD COLUMN IF NOT EXISTS area_type VARCHAR(50) DEFAULT NULL,
ADD COLUMN IF NOT EXISTS my_amount DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS discount DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS delivery_charge DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS parcel_charge DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS service_charge DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS additional_charge DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS other_deduction_charge DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS cgst DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS sgst DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS waived_off DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS assign_to VARCHAR(100) DEFAULT NULL,
ADD COLUMN IF NOT EXISTS biller_name VARCHAR(100) DEFAULT NULL,
ADD COLUMN IF NOT EXISTS reason TEXT DEFAULT NULL,
ADD COLUMN IF NOT EXISTS tip DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN IF NOT EXISTS total_with_tip DECIMAL(10, 2) DEFAULT 0.00;
