Notes

ALTER TABLE `trucks` ADD `dPEFTagDate` DATE NOT NULL ;
ALTER TABLE `trucks` ADD `vRemarks` VARCHAR( 255 ) NULL ;

ALTER TABLE `vessels` ADD `fParallelBodyLength` FLOAT( 8, 2 ) NULL COMMENT 'Parallel Body Length';
ALTER TABLE `vessels` ADD `eTypeofHull` ENUM( 'single', 'doubleBottom', 'doubleHull' ) NULL DEFAULT 'single';
ALTER TABLE `vessels` ADD `iParallelBodyLengthUnitId` INT( 11 ) NULL ;
ALTER TABLE `vessels` ADD `vClassificationofSociety` VARCHAR( 255 ) NULL ;

ALTER TABLE `vessels` ADD `fBowtoCenterManifold` FLOAT( 8, 2 ) NULL ,
ADD `iBowtoCenterManifoldUnitId` INT( 8 ) NULL ,
ADD `fSterntoCenterManifold` FLOAT( 8, 2 ) NULL ,
ADD `iSterntoCenterManifoldUnitId` INT( 8 ) NULL ;

ALTER TABLE `lats` ADD `iTankId` INT(11) NULL AFTER `iProductId`;
ALTER TABLE `lats` CHANGE `iTankId` `iTankId` INT(11) NOT NULL;

ALTER TABLE `lats` ADD `fTotalLoadedQuantity` DOUBLE( 8, 2 ) NULL AFTER `fCompartment6LoadedQty` ;

ALTER TABLE `lats` ADD `vRemarks` VARCHAR( 255 ) NULL;

ALTER TABLE `lats` ADD `iReasonMasterId` INT( 11 ) NOT NULL AFTER `vRemarks` ;


ALTER TABLE `order_items` ADD `fLoadedQty` DOUBLE(16,2) NOT NULL AFTER `fQuantity`, ADD `fRemainingQty` DOUBLE(16,2) NOT NULL AFTER `fLoadedQty`;


ALTER TABLE `order_items` ADD `dExpiryDate` DATETIME NOT NULL AFTER `dDateAdded`;

ALTER TABLE `lats` CHANGE `fQuantity` `fQuantity` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment1Qty` `fCompartment1Qty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment2Qty` `fCompartment2Qty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment3Qty` `fCompartment3Qty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment4Qty` `fCompartment4Qty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment5Qty` `fCompartment5Qty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment6Qty` `fCompartment6Qty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment1LoadedQty` `fCompartment1LoadedQty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment2LoadedQty` `fCompartment2LoadedQty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment3LoadedQty` `fCompartment3LoadedQty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment4LoadedQty` `fCompartment4LoadedQty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment5LoadedQty` `fCompartment5LoadedQty` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fCompartment6LoadedQty` `fCompartment6LoadedQty` DOUBLE( 8, 2 ) NOT NULL ;


ALTER TABLE `order_lats` CHANGE `fQuantity` `fQuantity` DOUBLE( 8, 2 ) NOT NULL ;

ALTER TABLE `orders` CHANGE `fTotalAmount` `fTotalAmount` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fTotalQuantity` `fTotalQuantity` DOUBLE( 8, 2 ) NOT NULL ;

ALTER TABLE `order_items` CHANGE `fQuantity` `fQuantity` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fSellingPrice` `fSellingPrice` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fTotalAmount` `fTotalAmount` DOUBLE( 8, 2 ) NOT NULL ;

Need to sync (asset type- tank) and (site type - tank form) from MRS to TAS

ALTER TABLE `tank_farms` CHANGE `fTotalCapacity` `fTotalCapacity` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fDefaultThroughputRate` `fDefaultThroughputRate` DOUBLE( 8, 2 ) NOT NULL ,
CHANGE `fDefaultDemurrageRate` `fDefaultDemurrageRate` DOUBLE( 8, 2 ) NOT NULL ;

ALTER TABLE `tanks`
DROP `vName`;

CREATE TABLE IF NOT EXISTS `tank_quality_certificate` (
`iTankQualityCertificateId` int(11) NOT NULL AUTO_INCREMENT,
`iTankId` int(11) NOT NULL,
`iProductId` int(11) NOT NULL,
`vDescription` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`eStatus` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
`dDateUpload` datetime NOT NULL,
`dDateAdded` datetime NOT NULL,
`iAddedBy` int(11) NOT NULL,
`dDateUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`iLastUpdatedBy` int(11) NOT NULL,
`iSysRecDeleted` tinyint(4) DEFAULT '0',
`vTankCertificateCode` varchar(255) DEFAULT NULL,
PRIMARY KEY (`iTankQualityCertificateId`),
UNIQUE KEY `iTankQualityCertificateId` (`iTankQualityCertificateId`),
KEY `iTankQualityCertificateId_2` (`iTankQualityCertificateId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;


INSERT INTO `document_types` (`vDocumentType`, `vDescription`, `tConfiguration`, `dDateAdded`, `iAddedBy`, `dDateUpdated`, `iLastUpdatedBy`, `eStatus`, `iSysRecDeleted`, `vDocumentTypeCode`) VALUES
('Daily Quality Ceritificate', 'Daily tank Quality Ceritificate', '{n "requireApproval": true,n "accesserGroups":[n "terminal_admin",n "terminal_manager",n "product_owner_managment",n "mrs_admin",n "admin",n "loading_master" n]n}', '2017-12-12 15:09:25', 1, '2017-12-11 15:00:18', 0, 'Active', 0, 'daily_tank_quality_certificate');


ALTER TABLE `documents` CHANGE `eDocumentFor` `eDocumentFor` ENUM( 'Companyregister', 'Throughput contract', 'Deal Contract', 'Negotiation Meeting Plan', 'Discharge Activities', 'cargoRequest', 'Discharge Activities Master', 'CargoVesselNomination', 'Tickets', 'Ticket Attachments', 'Bulk Order', 'creditRequest', 'internalConsumption', 'Truck', 'retailStation', 'vessels', 'latFrontImage', 'latRareImage', 'TankDailyQualityCertificate' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;


ALTER TABLE `assets` DROP FOREIGN KEY `assets_ibfk_1` ;

ALTER TABLE `assets` DROP FOREIGN KEY `assets_ibfk_2` ;

ALTER TABLE `assets` DROP FOREIGN KEY `assets_ibfk_3` ;


need to sync "units_master" data

need to sync "worker_commands" data

ALTER TABLE `remarks` CHANGE `eRemarksType` `eRemarksType` ENUM( 'companyRegister', 'cargoRequest', 'changeRequest', 'bulkCustomerOrder', 'internalConsumption', 'internalConsumptionOrder', 'forecastingRequest', 'roroDelivered', 'orderLat' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;

INSERT INTO `terminal_settings` (`iTerminalSettingId`, `iTerminalId`, `vKey`, `vValue`, `iSysRecDeleted`, `vLabel`, `tUnit`, `tNote`, `eVisibility`, `eType`) VALUES
(38, 10, 'quantity_variance', '10', 0, 'Quantity Variance Value', '', '', 'Visible', 'Other');