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);

area_insert_taiwan.sql

INSERT INTO `area` (`id`, `pid`, `name`, `level`) VALUES (830000000000, 0, '台灣省', 1); INSERT INTO `area` (`id`, `pid`, `name`, `level`) VALUES (830100000000, 830000000000, '臺北市', 2), (830200000000, 830000000000, '基隆市', 2), (830300000000, 830000000000, '新北市', 2), (830400000000, 830000000000, '桃園市', 2), (830500000000, 830000000000, '新竹市', 2), (830600000000, 830000000000, '新竹縣', 2), (830700000000, 830000000000, '苗栗縣', 2), (830800000000, 830000000000, '臺中市', 2), (830900000000, 830000000000, '彰化縣', 2), (831000000000, 830000000000, '南投縣', 2), (831100000000, 830000000000, '雲林縣', 2), (831200000000, 830000000000, '嘉義市', 2), (831300000000, 830000000000, '嘉義縣', 2), (831400000000, 830000000000, '臺南市', 2), (831500000000, 830000000000, '高雄市', 2), (831600000000, 830000000000, '屏東縣', 2), (831700000000, 830000000000, '宜蘭縣', 2), (831800000000, 830000000000, '花蓮縣', 2), (831900000000, 830000000000, '臺東縣', 2), (832000000000, 830000000000, '澎湖縣', 2), (832100000000, 830000000000, '金門縣', 2), (832200000000, 830000000000, '連江縣', 2), (830101000000, 830100000000, '中正區', 3), (830102000000, 830100000000, '大同區', 3), (830103000000, 830100000000, '中山區', 3), (830104000000, 830100000000, '松山區', 3), (830105000000, 830100000000, '大安區', 3), (830106000000, 830100000000, '萬華區', 3), (830107000000, 830100000000, '信義區', 3), (830108000000, 830100000000, '士林區', 3), (830109000000, 830100000000, '北投區', 3), (830110000000, 830100000000, '內湖區', 3), (830111000000, 830100000000, '南港區', 3), (830112000000, 830100000000, '文山區', 3), (830201000000, 830200000000, '仁愛區', 3), (830202000000, 830200000000, '信義區', 3), (830203000000, 830200000000, '中正區', 3),

zencart 手机版

zencart 手机版 手机端版 zencart手机端模板 莆田zencart模板 莆田zencart外贸模板

手机版 ZENCART手机模板

手机版 ZENCART 外贸建站