-- ----------------------------
-- Table structure for customertype
-- ----------------------------
DROP TABLE IF EXISTS `customertype`;
CREATE TABLE `customertype` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `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 `createdById` (`createdById`) USING BTREE,
  KEY `updatedById` (`updatedById`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of customertype
-- ----------------------------
INSERT INTO `customertype` VALUES ('1', 'All Customers', '1', '0001-01-01 00:00:00', '10', '2020-07-07 22:06:57', '10');
INSERT INTO `customertype` VALUES ('2', 'Manufacturer', '1', '2016-07-18 08:11:02', '10', '2016-07-18 08:11:02', '10');
INSERT INTO `customertype` VALUES ('3', 'Reseller', '1', '2016-07-18 08:11:02', '10', '2016-07-18 08:11:02', '10');
INSERT INTO `customertype` VALUES ('4', 'Trades', '1', '2016-07-18 08:11:02', '10', '2016-07-18 08:11:02', '10');
INSERT INTO `customertype` VALUES ('5', 'Retail', '1', '2016-07-18 08:11:02', '10', '2020-01-21 04:50:19', '10');
INSERT INTO `customertype` VALUES ('6', 'Wholesaler', '1', '2016-07-18 08:11:02', '10', '2020-01-21 04:50:19', '10');
INSERT INTO `customertype` VALUES ('7', 'Vendor', '1', '2016-07-18 08:11:02', '10', '2020-01-21 04:50:19', '10');
INSERT INTO `customertype` VALUES ('8', 'Construction', '1', '2016-07-18 08:11:02', '10', '2020-01-21 04:50:19', '10');
INSERT INTO `customertype` VALUES ('9', 'Mechanical', '1', '2016-07-18 08:11:02', '10', '2020-01-21 04:50:19', '10');
INSERT INTO `customertype` VALUES ('10', 'Government', '1', '2016-07-18 08:11:02', '10', '2020-01-21 04:50:19', '10');
INSERT INTO `customertype` VALUES ('11', 'Industrial Laundry', '1', '2016-07-18 08:11:02', '10', '2020-01-21 04:50:19', '10');
INSERT INTO `customertype` VALUES ('12', 'Equipment Hire', '1', '2016-07-18 08:11:02', '10', '2016-07-18 08:11:02', '10');
INSERT INTO `customertype` VALUES ('13', 'Financial', '1', '2016-07-18 08:11:02', '10', '2016-07-18 08:11:02', '10');
INSERT INTO `customertype` VALUES ('14', 'Demolitions', '1', '2016-07-18 08:11:02', '10', '2016-07-18 08:11:02', '10');
INSERT INTO `customertype` VALUES ('15', 'Exporter', '1', '2016-07-18 08:11:02', '10', '2016-07-18 08:11:02', '10');
