DROP TABLE IF EXISTS `t_region`;
CREATE TABLE `t_region`  (
                             `id` int(0) NOT NULL AUTO_INCREMENT,
                             `region_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                             `region_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                             `channel_count` int(0) NULL DEFAULT 0,
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_region
-- ----------------------------
INSERT INTO `t_region` VALUES (1, '市南区', '370202', 4367);
INSERT INTO `t_region` VALUES (2, '市北区', '370203', 7193);
INSERT INTO `t_region` VALUES (3, '西海岸新区', '370211', 41402);
INSERT INTO `t_region` VALUES (4, '崂山区', '370212', 19573);
INSERT INTO `t_region` VALUES (5, '李沧区', '370213', 5702);
INSERT INTO `t_region` VALUES (6, '城阳区', '370214', 14565);
INSERT INTO `t_region` VALUES (7, '即墨区', '370215', 13794);
INSERT INTO `t_region` VALUES (8, '高新区', '370271', 0);
INSERT INTO `t_region` VALUES (9, '胶州市', '370281', 14874);
INSERT INTO `t_region` VALUES (10, '平度市', '370283', 16383);
INSERT INTO `t_region` VALUES (11, '莱西市', '370285', 10046);

SET FOREIGN_KEY_CHECKS = 1;