INSERT INTO `systemsettings` (`type`, `value`, `description`, `active`, `created`, `createdById`, `updated`, `updatedById`) VALUES
    ('order_unit_price_gst_inc', false, 'the unit price in qoute/order detail page is inc gst or ex gst. 1 is inc, 0 is ex', 1, NOW(), 10, NOW(), 10);

INSERT INTO `systemsettings` (`type`, `value`, `description`, `active`, `created`, `createdById`, `updated`, `updatedById`) VALUES
    ('order_unit_price_gst_exchange', false, 'if it is 1, a tickbox will appear in quote/order detail page to allow user exchange inc/ex gst for unit price', 1, NOW(), 10, NOW(), 10);

INSERT INTO `systemsettings` (`type`, `value`, `description`, `active`, `created`, `createdById`, `updated`, `updatedById`) VALUES
    ('order_display_tier_price', false, 'if display product tier price in quote/order, 1 is display, 0 is not display', 1, NOW(), 10, NOW(), 10);

ALTER TABLE `orderitem`
ADD COLUMN `unitPriceExGST` double(10,4) NOT NULL DEFAULT '0.0000' AFTER `unitPrice`;
