-- Add CGST, SGST, and IGST fields to customer_quotation_item table
-- Run this SQL script in phpMyAdmin if the table already exists
-- Note: If you get an error that a column already exists, you can ignore it or comment out that line

ALTER TABLE `customer_quotation_item`
ADD COLUMN `cgst_rate` DECIMAL(5, 2) NOT NULL DEFAULT 0 AFTER `tax_amount`,
ADD COLUMN `cgst_amount` DECIMAL(18, 2) NOT NULL DEFAULT 0 AFTER `cgst_rate`,
ADD COLUMN `sgst_rate` DECIMAL(5, 2) NOT NULL DEFAULT 0 AFTER `cgst_amount`,
ADD COLUMN `sgst_amount` DECIMAL(18, 2) NOT NULL DEFAULT 0 AFTER `sgst_rate`,
ADD COLUMN `igst_rate` DECIMAL(5, 2) NOT NULL DEFAULT 0 AFTER `sgst_amount`,
ADD COLUMN `igst_amount` DECIMAL(18, 2) NOT NULL DEFAULT 0 AFTER `igst_rate`;

