省市区街道4级mysql数据库表sql文件

-- 表：loRa_street CREATE TABLE loRa_street ( code VARCHAR (255) PRIMARY KEY, name VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_general_ci, areaCode VARCHAR (255) REFERENCES area (code) ON DELETE SET NULL ON UPDATE CASCADE, provinceCode VARCHAR (255) REFERENCES province (code) ON DELETE SET NULL ON UPDATE CASCADE, cityCode VARCHAR (255) REFERENCES city (code) ON DELETE SET NULL ON UPDATE CASCADE ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101001', '东华门街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101002', '景山街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101003', '交道口街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101004', '安定门街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101005', '北新桥街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101006', '东四街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101007', '朝阳门街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101008', '建国门街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101009', '东直门街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101010', '和平里街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101011', '前门街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101012', '崇文门外街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101013', '东花市街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101014', '龙潭街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101015', '体育馆路街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, provinceCode, cityCode ) VALUES ( '110101016', '天坛街道办事处', '110101', '11', '1101' ); INSERT INTO loRa_street ( code, name, areaCode, prov