-- Migration script to add finance fields to sales table
-- Run this if your database already exists

ALTER TABLE sales 
ADD COLUMN finance_company VARCHAR(200) AFTER staff_id,
ADD COLUMN finance_loan_ac_no VARCHAR(100) AFTER finance_company,
ADD COLUMN emi_start_date DATE AFTER finance_loan_ac_no,
ADD COLUMN emi_amount DECIMAL(10, 2) AFTER emi_start_date;



