setup_data1.sql

关于进售存的 好东西

INSERT INTO `#@__area` VALUES (1006, '丹东市', 10, 0);
INSERT INTO `#@__area` VALUES (1007, '锦州市', 10, 0);
INSERT INTO `#@__area` VALUES (1008, '葫芦岛市', 10, 0);
INSERT INTO `#@__area` VALUES (1009, '营口市', 10, 0);
INSERT INTO `#@__area` VALUES (1010, '盘锦市', 10, 0);
INSERT INTO `#@__area` VALUES (1011, '阜新市', 10, 0);
INSERT INTO `#@__area` VALUES (1012, '辽阳市', 10, 0);
INSERT INTO `#@__area` VALUES (1013, '铁岭市', 10, 0);
INSERT INTO `#@__area` VALUES (1014, '朝阳市', 10, 0);
INSERT INTO `#@__area` VALUES (11, '江西省', 0, 0);
INSERT INTO `#@__area` VALUES (1101, '南昌市', 11, 0);
INSERT INTO `#@__area` VALUES (1102, '景德镇市', 11, 0);
INSERT INTO `#@__area` VALUES (1103, '萍乡市', 11, 0);
INSERT INTO `#@__area` VALUES (1104, '新余市', 11, 0);
INSERT INTO `#@__area` VALUES (1105, '九江市', 11, 0);
INSERT INTO `#@__area` VALUES (1106, '鹰潭市', 11, 0);
INSERT INTO `#@__area` VALUES (1107, '赣州市', 11, 0);
INSERT INTO `#@__area` VALUES (1108, '吉安市', 11, 0);
INSERT INTO `#@__area` VALUES (1109, '宜春市', 11, 0);
INSERT INTO `#@__area` VALUES (1110, '抚州市', 11, 0);
INSERT INTO `#@__area` VALUES (1111, '上饶市', 11, 0);
INSERT INTO `#@__area` VALUES (12, '四川省', 0, 0);
INSERT INTO `#@__area` VALUES (1201, '成都市', 12, 0);
INSERT INTO `#@__area` VALUES (1202, '自贡市', 12, 0);
INSERT INTO `#@__area` VALUES (1203, '攀枝花市', 12, 0);
INSERT INTO `#@__area` VALUES (1204, '泸州市', 12, 0);
INSERT INTO `#@__area` VALUES (1205, '德阳市', 12, 0);
INSERT INTO `#@__area` VALUES (1206, '绵阳市', 12, 0);
INSERT INTO `#@__area` VALUES (1207, '广元市', 12, 0);
INSERT INTO `#@__area` VALUES (1208, '遂宁市', 12, 0);
INSERT INTO `#@__area` VALUES (1209, '内江市', 12, 0);
INSERT INTO `#@__area` VALUES (1210, '乐山市', 12, 0);
INSERT INTO `#@__area` VALUES (1211, '南充市', 12, 0);
INSERT INTO `#@__area` VALUES (1212, '宜宾市', 12, 0);
INSERT INTO `#@__area` VALUES (1213, '广安市', 12, 0);
INSERT INTO `#@__area` VALUES (1214, '达州市', 12, 0);
INSERT INTO `#@__area` VALUES (1215, '巴中市', 12, 0);
INSERT INTO `#@__area` VALUES (1216, '雅安市', 12, 0);
INSERT INTO `#@__area` VALUES (1217, '眉山市', 12, 0);
INSERT INTO `#@__area` VALUES (1218, '资阳市', 12, 0);
INSERT INTO `#@__area` VALUES (1219, '阿坝州', 12, 0);
INSERT INTO `#@__area` VALUES (1220, '甘孜州', 12, 0);
INSERT INTO `#@__area` VALUES (1221, '凉山州', 12, 0);
INSERT INTO `#@__area` VALUES (13, '陕西省', 0, 0);
INSERT INTO `#@__area` VALUES (3114, '西安市', 13, 0);
INSERT INTO `#@__area` VALUES (1302, '铜川市', 13, 0);
INSERT INTO `#@__area` VALUES (1303, '宝鸡市', 13, 0);
INSERT INTO `#@__area` VALUES (1304, '咸阳市', 13, 0);
INSERT INTO `#@__area` VALUES (1305, '渭南市', 13, 0);
INSERT INTO `#@__area` VALUES (1306, '延安市', 13, 0);
INSERT INTO `#@__area` VALUES (1307, '汉中市', 13, 0);
INSERT INTO `#@__area` VALUES (1308, '榆林市', 13, 0);
INSERT INTO `#@__area` VALUES (1309, '安康市', 13, 0);
INSERT INTO `#@__area` VALUES (1310, '商洛地区', 13, 0);
INSERT INTO `#@__area` VALUES (14, '湖北省', 0, 0);
INSERT INTO `#@__area` VALUES (1401, '武汉市', 14, 0);
INSERT INTO `#@__area` VALUES (1402, '黄石市', 14, 0);
INSERT INTO `#@__area` VALUES (1403, '襄樊市', 14, 0);
INSERT INTO `#@__area` VALUES (1404, '十堰市', 14, 0);
INSERT INTO `#@__area` VALUES (1405, '荆州市', 14, 0);
INSERT INTO `#@__area` VALUES (1406, '宜昌市', 14, 0);
INSERT INTO `#@__area` VALUES (1407, '荆门市', 14, 0);
INSERT INTO `#@__area` VALUES (1408, '鄂州市', 14, 0);
INSERT INTO `#@__area` VALUES (1409, '孝感市', 14, 0);
INSERT INTO `#@__area` VALUES (1410, '黄冈市', 14, 0);
INSERT INTO `#@__area` VALUES (1411, '咸宁市', 14, 0);
INSERT INTO `#@__area` VALUES (1412, '随州市', 14, 0);
INSERT INTO `#@__area` VALUES (1413, '仙桃市', 14, 0);
INSERT INTO `#@__area` VALUES (1414, '天门市', 14, 0);
INSERT INTO `#@__area` VALUES (1415, '潜江市', 14, 0);
INSERT INTO `#@__area` VALUES (1416, '神农架', 14, 0);
INSERT INTO `#@__area` VALUES (1417, '恩施州', 14, 0);
INSERT INTO `#@__area` VALUES (15, '河南省', 0, 0);
INSERT INTO `#@__area` VALUES (1501, '郑州市', 15, 0);
INSERT INTO `#@__area` VALUES (1502, '开封市', 15, 0);
INSERT INTO `#@__area` VALUES (1503, '洛阳市', 15, 0);
INSERT INTO `#@__area` VALUES (1504, '平顶山市', 15, 0);
INSERT INTO `#@__area` VALUES (1505, '焦作市', 15, 0);
INSERT INTO `#@__area` VALUES (1506, '鹤壁市', 15, 0);
INSERT INTO `#@__area` VALUES (1507, '新乡市', 15, 0);
INSERT INTO `#@__area` VALUES (1508, '安阳市', 15, 0);
INSERT INTO `#@__area` VALUES (1509, '濮阳市', 15, 0);
INSERT INTO `#@__area` VALUES (1510, '许昌市', 15, 0);
INSERT INTO `#@__area` VALUES (1511, '漯河市', 15, 0);
INSERT INTO `#@__area` VALUES (1512, '三门峡市', 15, 0);
INSERT INTO `#@__area` VALUES (1513, '南阳市', 15, 0);
INSERT INTO `#@__area` VALUES (1514, '商丘市', 15, 0);
INSERT INTO `#@__area` VALUES (1515, '信阳市', 15, 0);
INSERT INTO `#@__area` VALUES (1516, '周口市', 15, 0);
INSERT INTO `#@__area` VALUES (1517, '驻马店市', 15, 0);
INSERT INTO `#@__area` VALUES (1518, '济源市', 15, 0);
INSERT INTO `#@__area` VALUES (16, '河北省', 0, 0);
INSERT INTO `#@__area` VALUES (1601, '石家庄市', 16, 0);
INSERT INTO `#@__area` VALUES (1602, '唐山市', 16, 0);
INSERT INTO `#@__area` VALUES (1603, '秦皇岛市', 16, 0);
INSERT INTO `#@__area` VALUES (1604, '邯郸市', 16, 0);
INSERT INTO `#@__area` VALUES (1605, '邢台市', 16, 0);
INSERT INTO `#@__area` VALUES (1606, '保定市', 16, 0);
INSERT INTO `#@__area` VALUES (1607, '张家口市', 16, 0);
INSERT INTO `#@__area` VALUES (1608, '承德市', 16, 0);
INSERT INTO `#@__area` VALUES (1609, '沧州市', 16, 0);
INSERT INTO `#@__area` VALUES (1610, '廊坊市', 16, 0);
INSERT INTO `#@__area` VALUES (1611, '衡水市', 16, 0);
INSERT INTO `#@__area` VALUES (17, '山西省', 0, 0);
INSERT INTO `#@__area` VALUES (1701, '太原市', 17, 0);
INSERT INTO `#@__area` VALUES (1702, '大同市', 17, 0);
INSERT INTO `#@__area` VALUES (1703, '阳泉市', 17, 0);
INSERT INTO `#@__area` VALUES (1704, '长治市', 17, 0);
INSERT INTO `#@__area` VALUES (1705, '晋城市', 17, 0);
INSERT INTO `#@__area` VALUES (1706, '朔州市', 17, 0);
INSERT INTO `#@__area` VALUES (1707, '晋中市', 17, 0);
INSERT INTO `#@__area` VALUES (1708, '忻州市', 17, 0);
INSERT INTO `#@__area` VALUES (1709, '临汾市', 17, 0);
INSERT INTO `#@__area` VALUES (1710, '运城市', 17, 0);
INSERT INTO `#@__area` VALUES (1711, '吕梁地区', 17, 0);
INSERT INTO `#@__area` VALUES (18, '内蒙古', 0, 0);
INSERT INTO `#@__area` VALUES (1801, '呼和浩特', 18, 0);
INSERT INTO `#@__area` VALUES (1802, '包头市', 18, 0);
INSERT INTO `#@__area` VALUES (1803, '乌海市', 18, 0);
INSERT INTO `#@__area` VALUES (1804, '赤峰市', 18, 0);
INSERT INTO `#@__area` VALUES (1805, '通辽市', 18, 0);
INSERT INTO `#@__area` VALUES (1806, '鄂尔多斯', 18, 0);
INSERT INTO `#@__area` VALUES (1807, '乌兰察布', 18, 0);
INSERT INTO `#@__area` VALUES (1808, '锡林郭勒', 18, 0);
INSERT INTO `#@__area` VALUES (1809, '呼伦贝尔', 18, 0);
INSERT INTO `#@__area` VALUES (1810, '巴彦淖尔', 18, 0);
INSERT INTO `#@__area` VALUES (1811, '阿拉善盟', 18, 0);
INSERT INTO `#@__area` VALUES (1812, '兴安盟', 18, 0);
INSERT INTO `#@__area` VALUES (19, '吉林省', 0, 0);
INSERT INTO `#@__area` VALUES (1901, '长春市', 19, 0);
INSERT INTO `#@__area` VALUES (1902, '吉林市', 19, 0);
INSERT INTO `#@__area` VALUES (1903, '四平市', 19, 0);
INSERT INTO `#@__area` VALUES (1904, '辽源市', 19, 0);
INSERT INTO `#@__area` VALUES (1905, '通化市', 19, 0);
INSERT INTO `#@__area` VALUES (1906, '白山市', 19, 0);
INSERT INTO `#@__area` VALUES (1907, '松原市', 19, 0);
INSERT INTO `#@__area` VALUES (1908, '白城市', 19, 0);
INSERT INTO `#@__area` VALUES (1909, '延边州', 19, 0);
INSERT INTO `#@__area` VALUES (20, '黑龙江', 0, 0);
INSERT INTO `#@__area` VALUES (2001, '哈尔滨市', 20, 0);
INSERT INTO `#@__area` VALUES (2002, '齐齐哈尔', 20, 0);
INSERT INTO `#@__area` VALUES (2003, '鹤岗市', 20, 0);
INSERT INTO `#@__area` VALUES (2004, '双鸭山市', 20, 0);
INSERT INTO `#@__area` VALUES (2005, '鸡西市', 20, 0);
INSERT INTO `#@__area` VALUES (2006, '大庆市', 20, 0);
INSERT INTO `#@__area` VALUES (2007, '伊春市', 20, 0);
INSERT INTO `#@__area` VALUES (2008, '牡丹江市', 20, 0);
INSERT INTO `#@__area` VALUES (2009, '佳木斯市', 20, 0);
INSERT INTO `#@__area` VALUES (2010, '七台河市', 20, 0);
INSERT INTO `#@__area` VALUES (2011, '黑河市', 20, 0);
INSERT INTO `#@__area` VALUES (2012, '绥化市', 20, 0);
INSERT INTO `#@__area` VALUES (2013, '大兴安岭', 20, 0);
INSERT INTO `#@__area` VALUES (21, '安徽省', 0, 0);
INSERT INTO `#@__area` VALUES (2101, '合肥市', 21, 0);
INSERT INTO `#@__area` VALUES (2102, '芜湖市', 21, 0);
INSERT INTO `#@__area` VALUES (2103, '蚌埠市', 21, 0);
INSERT INTO `#@__area` VALUES (2104, '淮南市', 21, 0);
INSERT INTO `#@__area` VALUES (2105, '马鞍山市', 21, 0);
INSERT INTO `#@__area` VALUES (2106, '淮北市', 21, 0);
INSERT INTO `#@__area` VALUES (2107, '铜陵市', 21, 0);
INSERT INTO `#@__area` VALUES (2108, '安庆市', 21, 0);
INSERT INTO `#@__area` VALUES (2109, '黄山市', 21, 0);
INSERT INTO `#@__area` VALUES (2110, '滁州市', 21, 0);
INSERT INTO `#@__area` VALUES (2111, '阜阳市', 21, 0);
INSERT INTO `#@__area` VALUES (2112, '宿州市', 21, 0);
INSERT INTO `#@__area` VALUES (2113, '巢湖市', 21, 0);
INSERT INTO `#@__area` VALUES (2114, '六安市', 21, 0);
INSERT INTO `#@__area` VALUES (2115, '亳州市', 21, 0);
INSERT INTO `#@__area` VALUES (2116, '宣城市', 21, 0);
INSERT INTO `#@__area` VALUES (2117, '池州市', 21, 0);
INSERT INTO `#@__area` VALUES (22, '湖南省', 0, 0);
INSERT INTO `#@__area` VALUES (2201, '长沙市', 22, 0);
INSERT INTO `#@__area` VALUES (2202, '株州市', 22, 0);
INSERT INTO `#@__area` VALUES (2203, '湘潭市', 22, 0);
INSERT INTO `#@__area` VALUES (2204, '衡阳市', 22, 0);
INSERT INTO `#@__area` VALUES (2205, '邵阳市', 22, 0);
INSERT INTO `#@__area` VALUES (2206, '岳阳市', 22, 0);
INSERT INTO `#@__area` VALUES (2207, '常德市', 22, 0);
INSERT INTO `#@__area` VALUES (2208, '张家界市', 22, 0);
INSERT INTO `#@__area` VALUES (2209, '益阳市', 22, 0);
INSERT INTO `#@__area` VALUES (2210, '郴州市', 22, 0);