ALTER TABLE `shipments`
ADD COLUMN `sender_company` VARCHAR(255) NULL AFTER `sender_phone`,
ADD COLUMN `sender_address_2` VARCHAR(255) NULL AFTER `sender_address`,
ADD COLUMN `sender_city` VARCHAR(100) NULL AFTER `sender_pincode`,
ADD COLUMN `sender_state` VARCHAR(100) NULL AFTER `sender_city`,
ADD COLUMN `sender_mobile` VARCHAR(20) NULL AFTER `sender_state`,
ADD COLUMN `sender_email` VARCHAR(100) NULL AFTER `sender_mobile`,
ADD COLUMN `sender_country` VARCHAR(100) NULL DEFAULT 'INDIA' AFTER `sender_email`,
ADD COLUMN `sender_iec_no` VARCHAR(50) NULL AFTER `sender_country`,
ADD COLUMN `sender_document_type` VARCHAR(50) NULL AFTER `sender_iec_no`,
ADD COLUMN `sender_document_no` VARCHAR(100) NULL AFTER `sender_document_type`,

ADD COLUMN `receiver_company` VARCHAR(255) NULL AFTER `receiver_phone`,
ADD COLUMN `receiver_address_2` VARCHAR(255) NULL AFTER `receiver_address`,
ADD COLUMN `receiver_city` VARCHAR(100) NULL AFTER `receiver_pincode`,
ADD COLUMN `receiver_state` VARCHAR(100) NULL AFTER `receiver_city`,
ADD COLUMN `receiver_mobile` VARCHAR(20) NULL AFTER `receiver_state`,
ADD COLUMN `receiver_email` VARCHAR(100) NULL AFTER `receiver_mobile`,
ADD COLUMN `receiver_country` VARCHAR(100) NULL DEFAULT 'INDIA' AFTER `receiver_email`,
ADD COLUMN `receiver_iec_no` VARCHAR(50) NULL AFTER `receiver_country`,
ADD COLUMN `receiver_document_type` VARCHAR(50) NULL AFTER `receiver_iec_no`,
ADD COLUMN `receiver_document_no` VARCHAR(100) NULL AFTER `receiver_document_type`,

ADD COLUMN `book_date` DATE NULL AFTER `tracking_number`,
ADD COLUMN `book_time` TIME NULL AFTER `book_date`,
ADD COLUMN `client_code` VARCHAR(50) NULL AFTER `customer_id`,
ADD COLUMN `product` VARCHAR(100) NULL AFTER `service_type_id`,
ADD COLUMN `vendor` VARCHAR(100) NULL AFTER `product`,
ADD COLUMN `declared_value` DECIMAL(10,2) NULL DEFAULT 0.00 AFTER `total_amount`,
ADD COLUMN `pieces` INT(11) NULL DEFAULT 1 AFTER `declared_value`,
ADD COLUMN `actual_weight` DECIMAL(10,3) NULL DEFAULT 0.000 AFTER `pieces`,
ADD COLUMN `volumetric_weight` DECIMAL(10,3) NULL DEFAULT 0.000 AFTER `actual_weight`,
ADD COLUMN `charge_weight` DECIMAL(10,3) NULL DEFAULT 0.000 AFTER `volumetric_weight`,
ADD COLUMN `is_commercial` TINYINT(1) NULL DEFAULT 0 AFTER `charge_weight`,
ADD COLUMN `medical_charges` TINYINT(1) NULL DEFAULT 0 AFTER `is_commercial`,
ADD COLUMN `is_oda` TINYINT(1) NULL DEFAULT 0 AFTER `medical_charges`;
