area_insert_quanguo.sql

DROP TABLE IF EXISTS `area`; CREATE TABLE `area` ( `id` bigint(20) NOT NULL COMMENT 'ID', `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域名称', `pid` bigint(20) NOT NULL COMMENT '父ID', `level` int(11) NOT NULL COMMENT '级别:1-省,2-市,3-区,4-乡镇', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '行政区域表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of area -- ---------------------------- INSERT INTO `area` VALUES (110000000000, '北京市', 0, 1); INSERT INTO `area` VALUES (110100000000, '市辖区', 110000000000, 2); INSERT INTO `area` VALUES (110101000000, '东城区', 110100000000, 3); INSERT INTO `area` VALUES (110101001000, '东华门街道办事处', 110101000000, 4); INSERT INTO `area` VALUES (110101002000, '景山街道办事处', 110101000000, 4); INSERT INTO `area` VALUES (110101003000, '交道口街道办事处', 110101000000, 4); INSERT INTO `area` VALUES (110101004000, '安定门街道办事处', 110101000000, 4); INSERT INTO `area` VALUES (110101005000, '北新桥街道办事处', 110101000000, 4); INSERT INTO `area` VALUES (110101006000, '东四街道办事处', 110101000000, 4);