DROP TABLE IF EXISTS `hireassetconvert`;
CREATE TABLE `hireassetconvert` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `hireAssetConvertNo` varchar(50) NOT NULL DEFAULT '',
    `convertFromId` int(10) unsigned NOT NULL DEFAULT '0',
    `convertToId` int(10) unsigned NOT NULL DEFAULT '0',
    `convertQty` int(10) unsigned NOT NULL DEFAULT '0',
    `convertPartInstanceIdsAndValues` varchar(2000) NOT NULL DEFAULT '',
    `totalAmt` double(10,4) unsigned NOT NULL DEFAULT '0.0000',
    `active` tinyint(1) NOT NULL DEFAULT '1',
    `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
    `createdById` int(10) unsigned NOT NULL DEFAULT '0',
    `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updatedById` int(10) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `convertFromId` (`convertFromId`),
    KEY `convertToId` (`convertToId`)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
