-- ----------------------------
-- Table structure for customerreigon
-- ----------------------------
DROP TABLE IF EXISTS `customerregion`;
CREATE TABLE `customerregion` (
  `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=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of customerreigon
-- ----------------------------
INSERT INTO `customerregion` VALUES ('1', 'Brooklyn', '1', '0001-01-01 00:00:00', '10', '2020-07-07 22:09:08', '10');
INSERT INTO `customerregion` VALUES ('2', 'Dandenong', '1', '0001-01-01 00:00:00', '10', '2020-07-07 22:09:26', '10');
INSERT INTO `customerregion` VALUES ('3', 'Interstate', '1', '0001-01-01 00:00:00', '10', '2020-07-07 22:09:32', '10');
INSERT INTO `customerregion` VALUES ('4', 'Overseas', '1', '0001-01-01 00:00:00', '10', '2020-07-07 22:09:54', '10');
