USE bims;

ALTER TABLE sales ADD COLUMN order_no VARCHAR(50) DEFAULT NULL AFTER invoice_no;
ALTER TABLE sales ADD COLUMN order_date DATE DEFAULT NULL AFTER order_no;
ALTER TABLE sales ADD COLUMN round_off DECIMAL(10,2) DEFAULT 0.00 AFTER discount_type;