-- SQL Script to add door_size, door_no, and door_color fields to customer_po_item table
-- Run this in phpMyAdmin SQL tab or MySQL command line

ALTER TABLE `customer_po_item`
ADD COLUMN `door_size` VARCHAR(100) NULL DEFAULT NULL COMMENT 'Door size specification' AFTER `delivery_date`,
ADD COLUMN `door_no` VARCHAR(100) NULL DEFAULT NULL COMMENT 'Door number' AFTER `door_size`,
ADD COLUMN `door_color` VARCHAR(100) NULL DEFAULT NULL COMMENT 'Door color specification' AFTER `door_no`;
