INSERT INTO product (sku, name, hireable, productMeasurementTypeId, mageId, mageType, assetAccNo, revenueAccNo, costAccNo, isFromB2B, sellOnWeb, isPoa, localOnly, manufacturerId, asNewFromDate, asNewToDate, shortDescription, fullDescAssetId, customTabAssetId, isKit, isBom, attributeSetId, manualDatafeed, length, width, height, weight, taxFree, initialCost, minMargin, warranty, videoUrl, layerNavis, squareId, ifSyncToSquare, ifManageStock, ifTrackable, ifThirdParty, active, created, createdById, updated, updatedById)
VALUES ('Extra-Expense-For-Bill', 'Extra Expense For Bill', 0, 1, '', 'simple', '642', '212', '321', 0, 0, 0, 1, 1, '0001-01-01 00:00:00', '0001-01-01 00:00:00', '', '', '', 0, 0, 1, 0, 0.0, 0.0, 0.0, 0.0000, 0, 0.00, 0.00, '', '', '', '', 0, 0, 0, 0, '0', UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10');

ALTER TABLE `orderitem` MODIFY COLUMN `discount`  double(7,4) UNSIGNED NOT NULL DEFAULT 0.0000 AFTER `unitPriceExGST`;
