说明文档
job新增字段
ALTER TABLE job ADD is_urgent int(2) DEFAULT 0 NOT NULL COMMENT '是否急招（0否，1是）';
ALTER TABLE job ADD job_keyword varchar(100) NULL COMMENT '职位关键字';
ALTER TABLE job ADD much_salary varchar(20) DEFAULT 12 NOT NULL COMMENT '多少薪';;
ALTER TABLE job ADD job_code varchar(100) NULL COMMENT 'job表中的Code，用于前端展示';
ALTER TABLE job_historical_record ADD job_keyword varchar(100) NULL COMMENT '职位关键字';
ALTER TABLE job_historical_record ADD much_salary varchar(20) DEFAULT 12 NOT NULL COMMENT '多少薪';;
ALTER TABLE job_historical_record ADD is_urgent int(2) DEFAULT 0 NOT NULL COMMENT '是否急招（0否，1是）';job_category表更新
alter table job_category add column `sort` tinyint(2) DEFAULT NULL COMMENT '排序';
alter table job_category add column `status` tinyint(2) DEFAULT '0' COMMENT '状态：0启用,1删除';
alter table job_category add column `update_by` int(11) DEFAULT NULL COMMENT '创建人(sys_user表user_id)';
alter table job_category add column `create_time` timestamp DEFAULT NULL COMMENT '创建时间';
alter table job_category add column `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间';
-- 原有职位类型数据标记为删除
update job_category set status = 1 where `type` = 0;job表历史数据删除
update job set job_category = '';新建表
CREATE TABLE `job_recommend_rank` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`job_id` varchar(100) NOT NULL COMMENT 'job表中job_id字段',
`deliver_num` int(11) DEFAULT NULL COMMENT '投递人数',
`deliver_rank` int(11) DEFAULT NULL COMMENT '投递人数排名',
`examine_num` int(11) DEFAULT NULL COMMENT '查看人数',
`examine_rank` int(11) DEFAULT NULL COMMENT '查看人数排名',
`issue_rank` int(11) DEFAULT NULL COMMENT '发布排名',
`score` decimal(10,2) DEFAULT NULL COMMENT '得分',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='职位排名';CREATE TABLE `custom_page` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自定义页面id',
`custom_page_name` varchar(50) NOT NULL COMMENT '页面标题',
`custom_page_template` varchar(200) NOT NULL COMMENT '页面模版（字典表CUSTOM_PAGE_TEMPLATE）',
`status` int(2) NOT NULL DEFAULT '1' COMMENT '状态：0停用，1启用',
`banner_url` varchar(2000) NOT NULL COMMENT 'banner路径',
`alipay_url` varchar(255) DEFAULT NULL COMMENT '支付宝小程序链接',
`wechat_url` varchar(255) DEFAULT NULL COMMENT '微信小程序链接',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义页面';
CREATE TABLE `custom_page_classify` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自定义页面分类导航id',
`custom_page_id` int(11) NOT NULL COMMENT '自定义页面表的id',
`custom_page_classify_name` varchar(255) NOT NULL COMMENT '自定义页面分类导航名称',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义页面分类导航';
CREATE TABLE `custom_page_job` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自定义页面类型职位id',
`custom_page_id` int(11) NOT NULL COMMENT '自定义页面表的id',
`custom_page_classify_id` int(11) NOT NULL COMMENT '自定义页面类型表id',
`job_id` int(11) NOT NULL COMMENT 'job表中的id',
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义页面职位列表';CREATE TABLE `job_intention` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT 'user表的id',
`job_status` tinyint(4) DEFAULT NULL COMMENT '求职状态（1：离职-随时到岗；2：在职-月内到岗；3：在职-考虑机会；4：在职-暂不考虑）',
`expected_job` int(11) DEFAULT NULL COMMENT '期望的职位job_category_id',
`work_city` varchar(100) DEFAULT NULL COMMENT '工作城市',
`expected_salary` varchar(50) DEFAULT NULL COMMENT '期望月薪',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='求职意向';职位排序算法
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,dict_category) VALUES
(0,'职位投递率权重','1','JOB_RANK_ALGORITHM_DELIVER_WEIGHT',NULL,NULL,'N','0','admin','2023-08-02 14:28:14','',NULL,'职位投递率权重',NULL),
(0,'职位发布时间权重','1','JOB_RANK_ALGORITHM_ISSUE_WEIGHT',NULL,NULL,'N','0','admin','2023-08-02 14:28:30','',NULL,'职位发布时间权重',NULL),
(0,'职位查看率权重','1','JOB_RANK_ALGORITHM_EXAMINE_WEIGHT',NULL,NULL,'N','0','admin','2023-08-02 14:30:02','',NULL,'职位查看率权重',NULL);自定义模板列表
INSERT INTO sys_dict_data (dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,dict_category) VALUES
(0,'模板1','1','CUSTOM_PAGE_TEMPLATE','https://lkl.lurb.online/recruiter/download/customPageTemplate/模板1.png','pagesTemp/templateA/templateA','N','0','admin','2023-08-02 14:28:14','',NULL,'页面模版',NULL);定时更新职位排名xxl-job
五分钟一次
任务描述：岗位排名定时更新
JobHandler：updateJobRecommendRankHandler
Cron：0 0/5 * * * ? 海报/短链
ALTER TABLE short_url_info ADD custom_page_id int(11) NULL COMMENT '自定义页面id';
ALTER TABLE short_url_info MODIFY COLUMN platform_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '平台类型：0微信，1支付宝，2微信自定义页面，3支付宝自定义页面';
-- 第一张图片
update poster_element set element_parameter = '{"rightWidth":980,"startY":635, "font":"SourceHanSerifSC-Regular.ttf", "fontSize":"45f", "fontColor":"255,255,255","wordsCount":15, "maxWordsCount":9}' where templete_id =7 and element_name = 'name';
-- 第二张图片
update poster_element set element_parameter = '{"startX":80, "startY":1670, "font":"MINIJIANDAHEI.ttf", "fontSize":"40f", "fontColor":"30,94,139"}' where templete_id =6 and element_name = 'salary';
-- 第四张图片
update poster_element set element_parameter = '{"centerX":549,"positionY":1754, "font":"MINIJIANDAHEI.ttf", "fontSize":"45f", "fontColor":"30,94,139"}' where templete_id =3 and element_name = 'salary';
-- 第六张图片
update poster_element set element_parameter = '{"startX":115,"startY":1155, "font":"MINIJIANDAHEI.ttf", "fontSize":"47f", "fontColor":"0,0,0"}' where templete_id =1 and element_name = 'salary';
-- 批量分享底图
update poster_element set element_parameter = '{"startX":490, "startY":1520, "font":"siyuanheiti.ttf", "fontSize":"38f", "fontColor":"171,46,7" }' where templete_id =5 and element_name = 'salary';
update poster_element set element_parameter = '{"startX":60, "startY":1520, "font":"siyuanheiti.ttf", "fontSize":"38f", "fontColor":"171,46,7","maxWordsCount":8,"rowSpacing":80 }' where templete_id =5 and element_name = 'name';
update poster_element set element_parameter = '{"cutRound":true,"times":1.4,"x":785,"y":1395}' where templete_id =5 and element_name = 'qrcode';省市数据SQL
DROP TABLE IF EXISTS `rc_district`; CREATE TABLE `rc_district` ( `district_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父及关系', `district` varchar(120) NOT NULL DEFAULT '' COMMENT '地区名称', `level` tinyint(1) NOT NULL COMMENT '子属关系', PRIMARY KEY (`district_id`), KEY `parent_id` (`pid`), KEY `region_type` (`level`) ) ENGINE=MyISAM AUTO_INCREMENT=3432 DEFAULT CHARSET=utf8 COMMENT='地区表'; delete from rc_district ; INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(110000, 0, '北京市', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(110100, 110000, '市辖区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(120000, 0, '天津市', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(120100, 120000, '市辖区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(130000, 0, '河北省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(130100, 130000, '石家庄市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(130200, 130000, '唐山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(130300, 130000, '秦皇岛市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(130400, 130000, '邯郸市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(130500, 130000, '邢台市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(130600, 130000, '保定市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(130700, 130000, '张家口市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(130800, 130000, '承德市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(130900, 130000, '沧州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(131000, 130000, '廊坊市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(131100, 130000, '衡水市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(140000, 0, '山西省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(140100, 140000, '太原市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(140200, 140000, '大同市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(140300, 140000, '阳泉市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(140400, 140000, '长治市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(140500, 140000, '晋城市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(140600, 140000, '朔州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(140700, 140000, '晋中市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(140800, 140000, '运城市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(140900, 140000, '忻州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(141000, 140000, '临汾市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(141100, 140000, '吕梁市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(150000, 0, '内蒙古自治区', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(150100, 150000, '呼和浩特市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(150200, 150000, '包头市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(150300, 150000, '乌海市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(150400, 150000, '赤峰市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(150500, 150000, '通辽市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(150600, 150000, '鄂尔多斯市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(150700, 150000, '呼伦贝尔市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(150800, 150000, '巴彦淖尔市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(150900, 150000, '乌兰察布市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(152200, 150000, '兴安盟', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(152500, 150000, '锡林郭勒盟', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(152900, 150000, '阿拉善盟', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(210000, 0, '辽宁省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(210100, 210000, '沈阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(210200, 210000, '大连市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(210300, 210000, '鞍山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(210400, 210000, '抚顺市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(210500, 210000, '本溪市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(210600, 210000, '丹东市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(210700, 210000, '锦州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(210800, 210000, '营口市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(210900, 210000, '阜新市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(211000, 210000, '辽阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(211100, 210000, '盘锦市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(211200, 210000, '铁岭市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(211300, 210000, '朝阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(211400, 210000, '葫芦岛市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(220000, 0, '吉林省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(220100, 220000, '长春市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(220200, 220000, '吉林市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(220300, 220000, '四平市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(220400, 220000, '辽源市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(220500, 220000, '通化市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(220600, 220000, '白山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(220700, 220000, '松原市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(220800, 220000, '白城市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(222400, 220000, '延边朝鲜族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(230000, 0, '黑龙江省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(230100, 230000, '哈尔滨市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(230200, 230000, '齐齐哈尔市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(230300, 230000, '鸡西市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(230400, 230000, '鹤岗市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(230500, 230000, '双鸭山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(230600, 230000, '大庆市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(230700, 230000, '伊春市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(230800, 230000, '佳木斯市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(230900, 230000, '七台河市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(231000, 230000, '牡丹江市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(231100, 230000, '黑河市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(231200, 230000, '绥化市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(232700, 230000, '大兴安岭地区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(310000, 0, '上海市', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(310100, 310000, '市辖区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(320000, 0, '江苏省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(320100, 320000, '南京市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(320200, 320000, '无锡市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(320300, 320000, '徐州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(320400, 320000, '常州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(320500, 320000, '苏州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(320600, 320000, '南通市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(320700, 320000, '连云港市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(320800, 320000, '淮安市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(320900, 320000, '盐城市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(321000, 320000, '扬州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(321100, 320000, '镇江市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(321200, 320000, '泰州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(321300, 320000, '宿迁市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(330000, 0, '浙江省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(330100, 330000, '杭州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(330200, 330000, '宁波市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(330300, 330000, '温州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(330400, 330000, '嘉兴市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(330500, 330000, '湖州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(330600, 330000, '绍兴市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(330700, 330000, '金华市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(330800, 330000, '衢州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(330900, 330000, '舟山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(331000, 330000, '台州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(331100, 330000, '丽水市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(340000, 0, '安徽省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(340100, 340000, '合肥市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(340200, 340000, '芜湖市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(340300, 340000, '蚌埠市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(340400, 340000, '淮南市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(340500, 340000, '马鞍山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(340600, 340000, '淮北市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(340700, 340000, '铜陵市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(340800, 340000, '安庆市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(341000, 340000, '黄山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(341100, 340000, '滁州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(341200, 340000, '阜阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(341300, 340000, '宿州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(341500, 340000, '六安市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(341600, 340000, '亳州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(341700, 340000, '池州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(341800, 340000, '宣城市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(350000, 0, '福建省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(350100, 350000, '福州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(350200, 350000, '厦门市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(350300, 350000, '莆田市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(350400, 350000, '三明市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(350500, 350000, '泉州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(350600, 350000, '漳州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(350700, 350000, '南平市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(350800, 350000, '龙岩市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(350900, 350000, '宁德市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(360000, 0, '江西省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(360100, 360000, '南昌市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(360200, 360000, '景德镇市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(360300, 360000, '萍乡市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(360400, 360000, '九江市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(360500, 360000, '新余市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(360600, 360000, '鹰潭市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(360700, 360000, '赣州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(360800, 360000, '吉安市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(360900, 360000, '宜春市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(361000, 360000, '抚州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(361100, 360000, '上饶市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(370000, 0, '山东省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(370100, 370000, '济南市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(370200, 370000, '青岛市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(370300, 370000, '淄博市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(370400, 370000, '枣庄市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(370500, 370000, '东营市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(370600, 370000, '烟台市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(370700, 370000, '潍坊市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(370800, 370000, '济宁市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(370900, 370000, '泰安市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(371000, 370000, '威海市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(371100, 370000, '日照市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(371300, 370000, '临沂市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(371400, 370000, '德州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(371500, 370000, '聊城市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(371600, 370000, '滨州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(371700, 370000, '菏泽市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(410000, 0, '河南省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(410100, 410000, '郑州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(410200, 410000, '开封市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(410300, 410000, '洛阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(410400, 410000, '平顶山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(410500, 410000, '安阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(410600, 410000, '鹤壁市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(410700, 410000, '新乡市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(410800, 410000, '焦作市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(410900, 410000, '濮阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(411000, 410000, '许昌市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(411100, 410000, '漯河市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(411200, 410000, '三门峡市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(411300, 410000, '南阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(411400, 410000, '商丘市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(411500, 410000, '信阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(411600, 410000, '周口市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(411700, 410000, '驻马店市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(419000, 410000, '济源市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(420000, 0, '湖北省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(420100, 420000, '武汉市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(420200, 420000, '黄石市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(420300, 420000, '十堰市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(420500, 420000, '宜昌市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(420600, 420000, '襄阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(420700, 420000, '鄂州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(420800, 420000, '荆门市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(420900, 420000, '孝感市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(421000, 420000, '荆州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(421100, 420000, '黄冈市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(421200, 420000, '咸宁市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(421300, 420000, '随州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(422800, 420000, '恩施土家族苗族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(429004, 420000, '仙桃市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(429005, 420000, '潜江市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(429006, 420000, '天门市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(429021, 420000, '神农架林区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(430000, 0, '湖南省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(430100, 430000, '长沙市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(430200, 430000, '株洲市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(430300, 430000, '湘潭市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(430400, 430000, '衡阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(430500, 430000, '邵阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(430600, 430000, '岳阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(430700, 430000, '常德市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(430800, 430000, '张家界市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(430900, 430000, '益阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(431000, 430000, '郴州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(431100, 430000, '永州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(431200, 430000, '怀化市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(431300, 430000, '娄底市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(433100, 430000, '湘西土家族苗族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(440000, 0, '广东省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(440100, 440000, '广州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(440200, 440000, '韶关市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(440300, 440000, '深圳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(440400, 440000, '珠海市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(440500, 440000, '汕头市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(440600, 440000, '佛山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(440700, 440000, '江门市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(440800, 440000, '湛江市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(440900, 440000, '茂名市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(441200, 440000, '肇庆市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(441300, 440000, '惠州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(441400, 440000, '梅州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(441500, 440000, '汕尾市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(441600, 440000, '河源市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(441700, 440000, '阳江市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(441800, 440000, '清远市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(441900, 440000, '东莞市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(442000, 440000, '中山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(445100, 440000, '潮州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(445200, 440000, '揭阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(445300, 440000, '云浮市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(450000, 0, '广西壮族自治区', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(450100, 450000, '南宁市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(450200, 450000, '柳州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(450300, 450000, '桂林市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(450400, 450000, '梧州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(450500, 450000, '北海市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(450600, 450000, '防城港市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(450700, 450000, '钦州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(450800, 450000, '贵港市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(450900, 450000, '玉林市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(451000, 450000, '百色市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(451100, 450000, '贺州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(451200, 450000, '河池市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(451300, 450000, '来宾市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(451400, 450000, '崇左市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(460000, 0, '海南省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(460100, 460000, '海口市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(460200, 460000, '三亚市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(460300, 460000, '三沙市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(460400, 460000, '儋州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469001, 460000, '五指山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469002, 460000, '琼海市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469005, 460000, '文昌市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469006, 460000, '万宁市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469007, 460000, '东方市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469021, 460000, '定安县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469022, 460000, '屯昌县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469023, 460000, '澄迈县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469024, 460000, '临高县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469025, 460000, '白沙黎族自治县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469026, 460000, '昌江黎族自治县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469027, 460000, '乐东黎族自治县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469028, 460000, '陵水黎族自治县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469029, 460000, '保亭黎族苗族自治县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(469030, 460000, '琼中黎族苗族自治县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(500000, 0, '重庆市', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(500100, 500000, '市辖区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(500200, 500000, '县', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(510000, 0, '四川省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(510100, 510000, '成都市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(510300, 510000, '自贡市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(510400, 510000, '攀枝花市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(510500, 510000, '泸州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(510600, 510000, '德阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(510700, 510000, '绵阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(510800, 510000, '广元市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(510900, 510000, '遂宁市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(511000, 510000, '内江市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(511100, 510000, '乐山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(511300, 510000, '南充市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(511400, 510000, '眉山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(511500, 510000, '宜宾市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(511600, 510000, '广安市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(511700, 510000, '达州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(511800, 510000, '雅安市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(511900, 510000, '巴中市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(512000, 510000, '资阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(513200, 510000, '阿坝藏族羌族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(513300, 510000, '甘孜藏族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(513400, 510000, '凉山彝族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(520000, 0, '贵州省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(520100, 520000, '贵阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(520200, 520000, '六盘水市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(520300, 520000, '遵义市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(520400, 520000, '安顺市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(520500, 520000, '毕节市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(520600, 520000, '铜仁市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(522300, 520000, '黔西南布依族苗族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(522600, 520000, '黔东南苗族侗族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(522700, 520000, '黔南布依族苗族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(530000, 0, '云南省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(530100, 530000, '昆明市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(530300, 530000, '曲靖市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(530400, 530000, '玉溪市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(530500, 530000, '保山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(530600, 530000, '昭通市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(530700, 530000, '丽江市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(530800, 530000, '普洱市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(530900, 530000, '临沧市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(532300, 530000, '楚雄彝族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(532500, 530000, '红河哈尼族彝族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(532600, 530000, '文山壮族苗族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(532800, 530000, '西双版纳傣族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(532900, 530000, '大理白族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(533100, 530000, '德宏傣族景颇族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(533300, 530000, '怒江傈僳族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(533400, 530000, '迪庆藏族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(540000, 0, '西藏自治区', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(540100, 540000, '拉萨市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(540200, 540000, '日喀则市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(540300, 540000, '昌都市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(540400, 540000, '林芝市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(540500, 540000, '山南市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(540600, 540000, '那曲市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(542500, 540000, '阿里地区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(610000, 0, '陕西省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(610100, 610000, '西安市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(610200, 610000, '铜川市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(610300, 610000, '宝鸡市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(610400, 610000, '咸阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(610500, 610000, '渭南市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(610600, 610000, '延安市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(610700, 610000, '汉中市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(610800, 610000, '榆林市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(610900, 610000, '安康市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(611000, 610000, '商洛市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(620000, 0, '甘肃省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(620100, 620000, '兰州市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(620200, 620000, '嘉峪关市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(620300, 620000, '金昌市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(620400, 620000, '白银市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(620500, 620000, '天水市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(620600, 620000, '武威市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(620700, 620000, '张掖市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(620800, 620000, '平凉市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(620900, 620000, '酒泉市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(621000, 620000, '庆阳市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(621100, 620000, '定西市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(621200, 620000, '陇南市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(622900, 620000, '临夏回族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(623000, 620000, '甘南藏族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(630000, 0, '青海省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(630100, 630000, '西宁市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(630200, 630000, '海东市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(632200, 630000, '海北藏族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(632300, 630000, '黄南藏族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(632500, 630000, '海南藏族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(632600, 630000, '果洛藏族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(632700, 630000, '玉树藏族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(632800, 630000, '海西蒙古族藏族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(640000, 0, '宁夏回族自治区', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(640100, 640000, '银川市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(640200, 640000, '石嘴山市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(640300, 640000, '吴忠市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(640400, 640000, '固原市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(640500, 640000, '中卫市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(650000, 0, '新疆维吾尔自治区', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(650100, 650000, '乌鲁木齐市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(650200, 650000, '克拉玛依市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(650400, 650000, '吐鲁番市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(650500, 650000, '哈密市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(652300, 650000, '昌吉回族自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(652700, 650000, '博尔塔拉蒙古自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(652800, 650000, '巴音郭楞蒙古自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(652900, 650000, '阿克苏地区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(653000, 650000, '克孜勒苏柯尔克孜自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(653100, 650000, '喀什地区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(653200, 650000, '和田地区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(654000, 650000, '伊犁哈萨克自治州', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(654200, 650000, '塔城地区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(654300, 650000, '阿勒泰地区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(659001, 650000, '石河子市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(659002, 650000, '阿拉尔市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(659003, 650000, '图木舒克市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(659004, 650000, '五家渠市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(659005, 650000, '北屯市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(659006, 650000, '铁门关市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(659007, 650000, '双河市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(659008, 650000, '可克达拉市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(659009, 650000, '昆玉市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(659010, 650000, '胡杨河市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(710000, 0, '台湾省', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(710100, 710000, '台北市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(710200, 710000, '高雄市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(710300, 710000, '基隆市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(710400, 710000, '台中市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(710500, 710000, '台南市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(710600, 710000, '新竹市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(710700, 710000, '嘉义市', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(810000, 0, '香港特别行政区', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(810001, 810000, '香港特别行政区', 2); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(820000, 0, '澳门特别行政区', 1); INSERT INTO rc_district (district_id, pid, district, `level`) VALUES(820001, 820000, '澳门特别行政区', 2); delete from rc_district where district='市辖区'; delete from rc_district where district='县';
简历投递记录表新增求职意向快照
ALTER TABLE recruit_person_info ADD job_intention_records varchar(500) NULL COMMENT '求职意向快照';
ALTER TABLE resume_records ADD job_intention_records varchar(500) NULL COMMENT '求职意向快照';job_historical_record 新增职位类型id字段
ALTER TABLE job_historical_record ADD job_category_id int(11) NULL COMMENT '职位类型id';删除job_category字段
ALTER TABLE job DROP COLUMN job_category;修改于 2023-08-24 08:08:05