-- Update amount columns to 3 decimal places
ALTER TABLE customers MODIFY COLUMN balance DECIMAL(15,3) DEFAULT 0.000;
ALTER TABLE stock_items MODIFY COLUMN purchase_price DECIMAL(15,3) DEFAULT 0.000;
ALTER TABLE stock_items MODIFY COLUMN sale_price DECIMAL(15,3) DEFAULT 0.000;
ALTER TABLE invoices MODIFY COLUMN total_amount DECIMAL(15,3) DEFAULT 0.000;
ALTER TABLE invoices MODIFY COLUMN vat_amount DECIMAL(15,3) DEFAULT 0.000;
ALTER TABLE invoices MODIFY COLUMN total_with_vat DECIMAL(15,3) DEFAULT 0.000;
ALTER TABLE invoices MODIFY COLUMN paid_amount DECIMAL(15,3) DEFAULT 0.000;
ALTER TABLE invoice_items MODIFY COLUMN unit_price DECIMAL(15,3) DEFAULT 0.000;
ALTER TABLE invoice_items MODIFY COLUMN total_price DECIMAL(15,3) DEFAULT 0.000;
ALTER TABLE payments MODIFY COLUMN amount DECIMAL(15,3) DEFAULT 0.000;