DROP TABLE IF EXISTS `visititemcommercial`;
CREATE TABLE `visititemcommercial` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `visitId` int(10) NOT NULL DEFAULT '0',
  `partNo` varchar(50) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `qty` double(6,2) NOT NULL DEFAULT '0.00',
  `unit` varchar(20) NOT NULL DEFAULT '',
  `unitPrice` double(10,4) NOT NULL DEFAULT '0.0000',
  `totalPrice` double(14,4) 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 `description` (`description`) USING BTREE,
  KEY `visitId` (`visitId`) USING BTREE,
  KEY `totalPrice` (`totalPrice`) USING BTREE,
  KEY `partNo` (`partNo`) USING BTREE,
  KEY `qty` (`qty`) USING BTREE,
  KEY `unitPrice` (`unitPrice`) USING BTREE,
  KEY `unit` (`unit`) USING BTREE
)   ENGINE=InnoDB
  DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
  ROW_FORMAT=Dynamic;
