mysql的安装
因为数据表中的字段使用了JSON格 式，所以大家的MySQL版本至少要是5.7以上的，低版本的MySQL不支持JSON，建 议使用低版本MySQL的同学，先要升级一下自己的MySQL数据库。
mysql大部分都可以使用默认的配置，但是中间有些东西我们可以进行选择
选择只安装数据库，不安装其他捆绑的东西：
然后在选择用户权限加密方法，我们选择后者，兼容mysql5.x,否则旧的项目就连接不到行新的数据库了：
在输入root用户密码，尽量复杂一些，但是要自己能记住：
Navicat的安装
Navicat是商业软件，可以试用，所以这里就不再说明破解版软件的安装方法，大家自行查阅。
下面说明一下导入EMOS系统数据库
- 使用下面的emos.sql
- 在Navicat上面连接本地mysql，新建emos数据库（字符集或者排序规则都可以不选）
- 然后在emos数据库上右键执行SQL文件
- 刷新emos数据库 ```sql SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0;
— Table structure for qrtz_blob_triggers
DROP TABLE IF EXISTS qrtz_blob_triggers;
CREATE TABLE qrtz_blob_triggers (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_GROUP varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
BLOB_DATA blob NULL,
PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) USING BTREE,
INDEX SCHED_NAME(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) USING BTREE,
CONSTRAINT qrtz_blob_triggers_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES qrtz_triggers (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_blob_triggers
— Table structure for qrtz_calendars
DROP TABLE IF EXISTS qrtz_calendars;
CREATE TABLE qrtz_calendars (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CALENDAR_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CALENDAR blob NOT NULL,
PRIMARY KEY (SCHED_NAME, CALENDAR_NAME) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_calendars
— Table structure for qrtz_cron_triggers
DROP TABLE IF EXISTS qrtz_cron_triggers;
CREATE TABLE qrtz_cron_triggers (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_GROUP varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CRON_EXPRESSION varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TIME_ZONE_ID varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) USING BTREE,
CONSTRAINT qrtz_cron_triggers_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES qrtz_triggers (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_cron_triggers
— Table structure for qrtz_fired_triggers
DROP TABLE IF EXISTS qrtz_fired_triggers;
CREATE TABLE qrtz_fired_triggers (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
ENTRY_ID varchar(95) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_GROUP varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
INSTANCE_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
FIRED_TIME bigint(13) NOT NULL,
SCHED_TIME bigint(13) NOT NULL,
PRIORITY int(11) NOT NULL,
STATE varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
JOB_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
JOB_GROUP varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
IS_NONCONCURRENT varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
REQUESTS_RECOVERY varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (SCHED_NAME, ENTRY_ID) USING BTREE,
INDEX IDX_QRTZ_FT_TRIG_INST_NAME(SCHED_NAME, INSTANCE_NAME) USING BTREE,
INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY(SCHED_NAME, INSTANCE_NAME, REQUESTS_RECOVERY) USING BTREE,
INDEX IDX_QRTZ_FT_J_G(SCHED_NAME, JOB_NAME, JOB_GROUP) USING BTREE,
INDEX IDX_QRTZ_FT_JG(SCHED_NAME, JOB_GROUP) USING BTREE,
INDEX IDX_QRTZ_FT_T_G(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) USING BTREE,
INDEX IDX_QRTZ_FT_TG(SCHED_NAME, TRIGGER_GROUP) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_fired_triggers
— Table structure for qrtz_job_details
DROP TABLE IF EXISTS qrtz_job_details;
CREATE TABLE qrtz_job_details (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
JOB_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
JOB_GROUP varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
DESCRIPTION varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
JOB_CLASS_NAME varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
IS_DURABLE varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
IS_NONCONCURRENT varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
IS_UPDATE_DATA varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
REQUESTS_RECOVERY varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
JOB_DATA blob NULL,
PRIMARY KEY (SCHED_NAME, JOB_NAME, JOB_GROUP) USING BTREE,
INDEX IDX_QRTZ_J_REQ_RECOVERY(SCHED_NAME, REQUESTS_RECOVERY) USING BTREE,
INDEX IDX_QRTZ_J_GRP(SCHED_NAME, JOB_GROUP) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_job_details
— Table structure for qrtz_locks
DROP TABLE IF EXISTS qrtz_locks;
CREATE TABLE qrtz_locks (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
LOCK_NAME varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (SCHED_NAME, LOCK_NAME) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_locks
INSERT INTO qrtz_locks VALUES (‘quartzScheduler’, ‘TRIGGER_ACCESS’);
— Table structure for qrtz_paused_trigger_grps
DROP TABLE IF EXISTS qrtz_paused_trigger_grps;
CREATE TABLE qrtz_paused_trigger_grps (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_GROUP varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (SCHED_NAME, TRIGGER_GROUP) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_paused_trigger_grps
— Table structure for qrtz_scheduler_state
DROP TABLE IF EXISTS qrtz_scheduler_state;
CREATE TABLE qrtz_scheduler_state (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
INSTANCE_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
LAST_CHECKIN_TIME bigint(13) NOT NULL,
CHECKIN_INTERVAL bigint(13) NOT NULL,
PRIMARY KEY (SCHED_NAME, INSTANCE_NAME) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_scheduler_state
— Table structure for qrtz_simple_triggers
DROP TABLE IF EXISTS qrtz_simple_triggers;
CREATE TABLE qrtz_simple_triggers (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_GROUP varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
REPEAT_COUNT bigint(7) NOT NULL,
REPEAT_INTERVAL bigint(12) NOT NULL,
TIMES_TRIGGERED bigint(10) NOT NULL,
PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) USING BTREE,
CONSTRAINT qrtz_simple_triggers_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES qrtz_triggers (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_simple_triggers
— Table structure for qrtz_simprop_triggers
DROP TABLE IF EXISTS qrtz_simprop_triggers;
CREATE TABLE qrtz_simprop_triggers (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_GROUP varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
STR_PROP_1 varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
STR_PROP_2 varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
STR_PROP_3 varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
INT_PROP_1 int(11) NULL DEFAULT NULL,
INT_PROP_2 int(11) NULL DEFAULT NULL,
LONG_PROP_1 bigint(20) NULL DEFAULT NULL,
LONG_PROP_2 bigint(20) NULL DEFAULT NULL,
DEC_PROP_1 decimal(13, 4) NULL DEFAULT NULL,
DEC_PROP_2 decimal(13, 4) NULL DEFAULT NULL,
BOOL_PROP_1 varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
BOOL_PROP_2 varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) USING BTREE,
CONSTRAINT qrtz_simprop_triggers_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES qrtz_triggers (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_simprop_triggers
— Table structure for qrtz_triggers
DROP TABLE IF EXISTS qrtz_triggers;
CREATE TABLE qrtz_triggers (
SCHED_NAME varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_GROUP varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
JOB_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
JOB_GROUP varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
DESCRIPTION varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
NEXT_FIRE_TIME bigint(13) NULL DEFAULT NULL,
PREV_FIRE_TIME bigint(13) NULL DEFAULT NULL,
PRIORITY int(11) NULL DEFAULT NULL,
TRIGGER_STATE varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
TRIGGER_TYPE varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
START_TIME bigint(13) NOT NULL,
END_TIME bigint(13) NULL DEFAULT NULL,
CALENDAR_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
MISFIRE_INSTR smallint(2) NULL DEFAULT NULL,
JOB_DATA blob NULL,
PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) USING BTREE,
INDEX IDX_QRTZ_T_J(SCHED_NAME, JOB_NAME, JOB_GROUP) USING BTREE,
INDEX IDX_QRTZ_T_JG(SCHED_NAME, JOB_GROUP) USING BTREE,
INDEX IDX_QRTZ_T_C(SCHED_NAME, CALENDAR_NAME) USING BTREE,
INDEX IDX_QRTZ_T_G(SCHED_NAME, TRIGGER_GROUP) USING BTREE,
INDEX IDX_QRTZ_T_STATE(SCHED_NAME, TRIGGER_STATE) USING BTREE,
INDEX IDX_QRTZ_T_N_STATE(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_STATE) USING BTREE,
INDEX IDX_QRTZ_T_N_G_STATE(SCHED_NAME, TRIGGER_GROUP, TRIGGER_STATE) USING BTREE,
INDEX IDX_QRTZ_T_NEXT_FIRE_TIME(SCHED_NAME, NEXT_FIRE_TIME) USING BTREE,
INDEX IDX_QRTZ_T_NFT_ST(SCHED_NAME, TRIGGER_STATE, NEXT_FIRE_TIME) USING BTREE,
INDEX IDX_QRTZ_T_NFT_MISFIRE(SCHED_NAME, MISFIRE_INSTR, NEXT_FIRE_TIME) USING BTREE,
INDEX IDX_QRTZ_T_NFT_ST_MISFIRE(SCHED_NAME, MISFIRE_INSTR, NEXT_FIRE_TIME, TRIGGER_STATE) USING BTREE,
INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP(SCHED_NAME, MISFIRE_INSTR, NEXT_FIRE_TIME, TRIGGER_GROUP, TRIGGER_STATE) USING BTREE,
CONSTRAINT qrtz_triggers_ibfk_1 FOREIGN KEY (SCHED_NAME, JOB_NAME, JOB_GROUP) REFERENCES qrtz_job_details (SCHED_NAME, JOB_NAME, JOB_GROUP) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of qrtz_triggers
— Table structure for sys_config
DROP TABLE IF EXISTS sys_config;
CREATE TABLE sys_config (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
param_key varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘参数名’,
param_value varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘参数值’,
status tinyint(1) UNSIGNED NOT NULL COMMENT ‘状态’,
remark varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘备注’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_param_key(param_key) USING BTREE,
INDEX idx_status(status) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of sys_config
INSERT INTO sys_config VALUES (1, ‘attendance_start_time’, ‘06:00’, 1, ‘上班考勤开始时间’);
INSERT INTO sys_config VALUES (2, ‘attendance_time’, ‘08:30’, 1, ‘上班时间’);
INSERT INTO sys_config VALUES (3, ‘attendance_end_time’, ‘09:30’, 1, ‘上班考勤截止时间’);
INSERT INTO sys_config VALUES (4, ‘closing_start_time’, ‘16:30’, 1, ‘下班考勤开始时间’);
INSERT INTO sys_config VALUES (5, ‘closing_time’, ‘17:30’, 1, ‘下班时间’);
INSERT INTO sys_config VALUES (6, ‘closing_end_time’, ‘23:59’, 1, ‘下班考勤截止时间’);
— Table structure for tb_action
DROP TABLE IF EXISTS tb_action;
CREATE TABLE tb_action (
id int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
action_code varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘行为编号’,
action_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘行为名称’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_action_name(action_name) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘行为表’ ROW_FORMAT = DYNAMIC;
— Records of tb_action
INSERT INTO tb_action VALUES (1, ‘INSERT’, ‘添加’);
INSERT INTO tb_action VALUES (2, ‘DELETE’, ‘删除’);
INSERT INTO tb_action VALUES (3, ‘UPDATE’, ‘修改’);
INSERT INTO tb_action VALUES (4, ‘SELECT’, ‘查询’);
INSERT INTO tb_action VALUES (5, ‘APPROVAL’, ‘审批’);
INSERT INTO tb_action VALUES (6, ‘EXPORT’, ‘导出’);
INSERT INTO tb_action VALUES (7, ‘BACKUP’, ‘备份’);
— Table structure for tb_checkin
DROP TABLE IF EXISTS tb_checkin;
CREATE TABLE tb_checkin (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
user_id int(10) UNSIGNED NOT NULL COMMENT ‘用户ID’,
address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘签到地址’,
country varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘国家’,
province varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘省份’,
city varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘城市’,
district varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘区划’,
status tinyint(3) UNSIGNED NOT NULL COMMENT ‘考勤结果’,
risk int(255) UNSIGNED NULL DEFAULT 0 COMMENT ‘风险等级’,
date date NOT NULL COMMENT ‘签到日期’,
create_time datetime(0) NOT NULL COMMENT ‘签到时间’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_user_id(user_id, date) USING BTREE,
INDEX idx_date(date) USING BTREE,
INDEX idx_status(status) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘签到表’ ROW_FORMAT = DYNAMIC;
— Records of tb_checkin
— Table structure for tb_city
DROP TABLE IF EXISTS tb_city;
CREATE TABLE tb_city (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
city varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘城市名称’,
code varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘拼音简称’,
PRIMARY KEY (id) USING BTREE,
INDEX idx_city(city) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 330 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘疫情城市列表’ ROW_FORMAT = DYNAMIC;
— Records of tb_city
INSERT INTO tb_city VALUES (1, ‘阿坝市’, ‘ab’);
INSERT INTO tb_city VALUES (2, ‘安康市’, ‘ak’);
INSERT INTO tb_city VALUES (3, ‘阿克苏市’, ‘aks’);
INSERT INTO tb_city VALUES (4, ‘阿拉善市’, ‘alsm’);
INSERT INTO tb_city VALUES (5, ‘安顺市’, ‘anshun’);
INSERT INTO tb_city VALUES (6, ‘安庆市’, ‘aq’);
INSERT INTO tb_city VALUES (7, ‘鞍山市’, ‘as’);
INSERT INTO tb_city VALUES (8, ‘安阳市’, ‘ay’);
INSERT INTO tb_city VALUES (9, ‘百色市’, ‘baise’);
INSERT INTO tb_city VALUES (10, ‘白山市’, ‘baishan’);
INSERT INTO tb_city VALUES (11, ‘宝鸡市’, ‘baoji’);
INSERT INTO tb_city VALUES (12, ‘巴中市’, ‘bazhong’);
INSERT INTO tb_city VALUES (13, ‘蚌埠市’, ‘bb’);
INSERT INTO tb_city VALUES (14, ‘白城市’, ‘bc’);
INSERT INTO tb_city VALUES (15, ‘保定市’, ‘bd’);
INSERT INTO tb_city VALUES (16, ‘博尔塔拉市’, ‘betl’);
INSERT INTO tb_city VALUES (17, ‘北海市’, ‘bh’);
INSERT INTO tb_city VALUES (18, ‘毕节市’, ‘bijie’);
INSERT INTO tb_city VALUES (19, ‘北京市’, ‘bj’);
INSERT INTO tb_city VALUES (20, ‘西双版纳市’, ‘bn’);
INSERT INTO tb_city VALUES (21, ‘亳州市’, ‘bozhou’);
INSERT INTO tb_city VALUES (22, ‘保山市’, ‘bs’);
INSERT INTO tb_city VALUES (23, ‘包头市’, ‘bt’);
INSERT INTO tb_city VALUES (24, ‘本溪市’, ‘bx’);
INSERT INTO tb_city VALUES (25, ‘白银市’, ‘by’);
INSERT INTO tb_city VALUES (26, ‘巴彦淖尔市’, ‘bycem’);
INSERT INTO tb_city VALUES (27, ‘巴音郭楞市’, ‘bygl’);
INSERT INTO tb_city VALUES (28, ‘滨州市’, ‘bz’);
INSERT INTO tb_city VALUES (29, ‘沧州市’, ‘cangzhou’);
INSERT INTO tb_city VALUES (30, ‘长春市’, ‘cc’);
INSERT INTO tb_city VALUES (31, ‘成都市’, ‘cd’);
INSERT INTO tb_city VALUES (32, ‘赤峰市’, ‘cf’);
INSERT INTO tb_city VALUES (33, ‘常德市’, ‘changde’);
INSERT INTO tb_city VALUES (34, ‘长治市’, ‘changzhi’);
INSERT INTO tb_city VALUES (35, ‘潮州市’, ‘chaozhou’);
INSERT INTO tb_city VALUES (36, ‘承德市’, ‘chengde’);
INSERT INTO tb_city VALUES (37, ‘郴州市’, ‘chenzhou’);
INSERT INTO tb_city VALUES (38, ‘池州市’, ‘chizhou’);
INSERT INTO tb_city VALUES (39, ‘崇左市’, ‘chongzuo’);
INSERT INTO tb_city VALUES (40, ‘滁州市’, ‘chuzhou’);
INSERT INTO tb_city VALUES (41, ‘昌吉市’, ‘cj’);
INSERT INTO tb_city VALUES (42, ‘重庆市’, ‘cq’);
INSERT INTO tb_city VALUES (43, ‘长沙市’, ‘cs’);
INSERT INTO tb_city VALUES (44, ‘楚雄市’, ‘cx’);
INSERT INTO tb_city VALUES (45, ‘朝阳市’, ‘cy’);
INSERT INTO tb_city VALUES (46, ‘常州市’, ‘cz’);
INSERT INTO tb_city VALUES (47, ‘大理市’, ‘dali’);
INSERT INTO tb_city VALUES (48, ‘达州市’, ‘dazhou’);
INSERT INTO tb_city VALUES (49, ‘丹东市’, ‘dd’);
INSERT INTO tb_city VALUES (50, ‘德阳市’, ‘deyang’);
INSERT INTO tb_city VALUES (51, ‘东莞市’, ‘dg’);
INSERT INTO tb_city VALUES (52, ‘德宏市’, ‘dh’);
INSERT INTO tb_city VALUES (53, ‘迪庆市’, ‘diqing’);
INSERT INTO tb_city VALUES (54, ‘大连市’, ‘dl’);
INSERT INTO tb_city VALUES (55, ‘大庆市’, ‘dq’);
INSERT INTO tb_city VALUES (56, ‘大同市’, ‘dt’);
INSERT INTO tb_city VALUES (57, ‘定西市’, ‘dx’);
INSERT INTO tb_city VALUES (58, ‘大兴安岭市’, ‘dxal’);
INSERT INTO tb_city VALUES (59, ‘东营市’, ‘dy’);
INSERT INTO tb_city VALUES (60, ‘德州市’, ‘dz’);
INSERT INTO tb_city VALUES (61, ‘鄂尔多斯市’, ‘erds’);
INSERT INTO tb_city VALUES (62, ‘恩施市’, ‘es’);
INSERT INTO tb_city VALUES (63, ‘鄂州市’, ‘ez’);
INSERT INTO tb_city VALUES (64, ‘防城港市’, ‘fcg’);
INSERT INTO tb_city VALUES (65, ‘佛山市’, ‘fs’);
INSERT INTO tb_city VALUES (66, ‘抚顺市’, ‘fushun’);
INSERT INTO tb_city VALUES (67, ‘抚州市’, ‘fuzhou’);
INSERT INTO tb_city VALUES (68, ‘阜新市’, ‘fx’);
INSERT INTO tb_city VALUES (69, ‘阜阳市’, ‘fy’);
INSERT INTO tb_city VALUES (70, ‘福州市’, ‘fz’);
INSERT INTO tb_city VALUES (71, ‘广安市’, ‘ga’);
INSERT INTO tb_city VALUES (72, ‘赣州市’, ‘ganzhou’);
INSERT INTO tb_city VALUES (73, ‘甘孜市’, ‘ganzi’);
INSERT INTO tb_city VALUES (74, ‘贵港市’, ‘gg’);
INSERT INTO tb_city VALUES (75, ‘桂林市’, ‘gl’);
INSERT INTO tb_city VALUES (76, ‘广元市’, ‘guangyuan’);
INSERT INTO tb_city VALUES (77, ‘果洛市’, ‘guoluo’);
INSERT INTO tb_city VALUES (78, ‘固原市’, ‘guyuan’);
INSERT INTO tb_city VALUES (79, ‘贵阳市’, ‘gy’);
INSERT INTO tb_city VALUES (80, ‘广州市’, ‘gz’);
INSERT INTO tb_city VALUES (81, ‘淮安市’, ‘ha’);
INSERT INTO tb_city VALUES (82, ‘海北市’, ‘haibei’);
INSERT INTO tb_city VALUES (83, ‘海东市’, ‘haidong’);
INSERT INTO tb_city VALUES (84, ‘海南市’, ‘hainan’);
INSERT INTO tb_city VALUES (85, ‘汉中市’, ‘hanzhong’);
INSERT INTO tb_city VALUES (86, ‘鹤壁市’, ‘hb’);
INSERT INTO tb_city VALUES (87, ‘河池市’, ‘hc’);
INSERT INTO tb_city VALUES (88, ‘邯郸市’, ‘hd’);
INSERT INTO tb_city VALUES (89, ‘哈尔滨市’, ‘heb’);
INSERT INTO tb_city VALUES (90, ‘鹤岗市’, ‘hegang’);
INSERT INTO tb_city VALUES (91, ‘黑河市’, ‘heihe’);
INSERT INTO tb_city VALUES (92, ‘河源市’, ‘heyuan’);
INSERT INTO tb_city VALUES (93, ‘菏泽市’, ‘heze’);
INSERT INTO tb_city VALUES (94, ‘贺州市’, ‘hezhou’);
INSERT INTO tb_city VALUES (95, ‘合肥市’, ‘hf’);
INSERT INTO tb_city VALUES (96, ‘黄冈市’, ‘hg’);
INSERT INTO tb_city VALUES (97, ‘怀化市’, ‘hh’);
INSERT INTO tb_city VALUES (98, ‘呼伦贝尔市’, ‘hlbe’);
INSERT INTO tb_city VALUES (99, ‘葫芦岛市’, ‘hld’);
INSERT INTO tb_city VALUES (100, ‘哈密市’, ‘hm’);
INSERT INTO tb_city VALUES (101, ‘淮南市’, ‘hn’);
INSERT INTO tb_city VALUES (102, ‘红河市’, ‘honghe’);
INSERT INTO tb_city VALUES (103, ‘衡水市’, ‘hs’);
INSERT INTO tb_city VALUES (104, ‘黄石市’, ‘hshi’);
INSERT INTO tb_city VALUES (105, ‘和田市’, ‘ht’);
INSERT INTO tb_city VALUES (106, ‘呼和浩特市’, ‘hu’);
INSERT INTO tb_city VALUES (107, ‘淮北市’, ‘huaibei’);
INSERT INTO tb_city VALUES (108, ‘黄南市’, ‘huangnan’);
INSERT INTO tb_city VALUES (109, ‘黄山市’, ‘huangshan’);
INSERT INTO tb_city VALUES (110, ‘惠州市’, ‘huizhou’);
INSERT INTO tb_city VALUES (111, ‘湖州市’, ‘huzhou’);
INSERT INTO tb_city VALUES (112, ‘海西市’, ‘hx’);
INSERT INTO tb_city VALUES (113, ‘衡阳市’, ‘hy’);
INSERT INTO tb_city VALUES (114, ‘杭州市’, ‘hz’);
INSERT INTO tb_city VALUES (115, ‘吉安市’, ‘ja’);
INSERT INTO tb_city VALUES (116, ‘晋城市’, ‘jc’);
INSERT INTO tb_city VALUES (117, ‘景德镇市’, ‘jdz’);
INSERT INTO tb_city VALUES (118, ‘金华市’, ‘jh’);
INSERT INTO tb_city VALUES (119, ‘焦作市’, ‘jiaozuo’);
INSERT INTO tb_city VALUES (120, ‘金昌市’, ‘jinchang’);
INSERT INTO tb_city VALUES (121, ‘荆门市’, ‘jingmen’);
INSERT INTO tb_city VALUES (122, ‘荆州市’, ‘jingzhou’);
INSERT INTO tb_city VALUES (123, ‘济宁市’, ‘jining’);
INSERT INTO tb_city VALUES (124, ‘锦州市’, ‘jinzhou’);
INSERT INTO tb_city VALUES (125, ‘鸡西市’, ‘jixi’);
INSERT INTO tb_city VALUES (126, ‘济源市’, ‘jiyuan’);
INSERT INTO tb_city VALUES (127, ‘九江市’, ‘jj’);
INSERT INTO tb_city VALUES (128, ‘吉林市’, ‘jl’);
INSERT INTO tb_city VALUES (129, ‘江门市’, ‘jm’);
INSERT INTO tb_city VALUES (130, ‘佳木斯市’, ‘jms’);
INSERT INTO tb_city VALUES (131, ‘济南市’, ‘jn’);
INSERT INTO tb_city VALUES (132, ‘酒泉市’, ‘jq’);
INSERT INTO tb_city VALUES (133, ‘嘉兴市’, ‘jx’);
INSERT INTO tb_city VALUES (134, ‘揭阳市’, ‘jy’);
INSERT INTO tb_city VALUES (135, ‘嘉峪关市’, ‘jyg’);
INSERT INTO tb_city VALUES (136, ‘晋中市’, ‘jz’);
INSERT INTO tb_city VALUES (137, ‘喀什市’, ‘kashi’);
INSERT INTO tb_city VALUES (138, ‘开封市’, ‘kf’);
INSERT INTO tb_city VALUES (139, ‘克拉玛依市’, ‘klmy’);
INSERT INTO tb_city VALUES (140, ‘昆明市’, ‘km’);
INSERT INTO tb_city VALUES (141, ‘克孜勒苏市’, ‘kzls’);
INSERT INTO tb_city VALUES (142, ‘六安市’, ‘la’);
INSERT INTO tb_city VALUES (143, ‘来宾市’, ‘lb’);
INSERT INTO tb_city VALUES (144, ‘聊城市’, ‘lc’);
INSERT INTO tb_city VALUES (145, ‘娄底市’, ‘ld’);
INSERT INTO tb_city VALUES (146, ‘乐山市’, ‘leshan’);
INSERT INTO tb_city VALUES (147, ‘廊坊市’, ‘lf’);
INSERT INTO tb_city VALUES (148, ‘漯河市’, ‘lh’);
INSERT INTO tb_city VALUES (149, ‘凉山市’, ‘liangshan’);
INSERT INTO tb_city VALUES (150, ‘辽阳市’, ‘liaoyang’);
INSERT INTO tb_city VALUES (151, ‘辽源市’, ‘liaoyuan’);
INSERT INTO tb_city VALUES (152, ‘临沧市’, ‘lincang’);
INSERT INTO tb_city VALUES (153, ‘临汾市’, ‘linfen’);
INSERT INTO tb_city VALUES (154, ‘临沂市’, ‘linyi’);
INSERT INTO tb_city VALUES (155, ‘丽水市’, ‘lishui’);
INSERT INTO tb_city VALUES (156, ‘柳州市’, ‘liuzhou’);
INSERT INTO tb_city VALUES (157, ‘丽江市’, ‘lj’);
INSERT INTO tb_city VALUES (158, ‘吕梁市’, ‘ll’);
INSERT INTO tb_city VALUES (159, ‘陇南市’, ‘ln’);
INSERT INTO tb_city VALUES (160, ‘龙岩市’, ‘longyan’);
INSERT INTO tb_city VALUES (161, ‘六盘水市’, ‘lps’);
INSERT INTO tb_city VALUES (162, ‘泸州市’, ‘luzhou’);
INSERT INTO tb_city VALUES (163, ‘洛阳市’, ‘ly’);
INSERT INTO tb_city VALUES (164, ‘连云港市’, ‘lyg’);
INSERT INTO tb_city VALUES (165, ‘兰州市’, ‘lz’);
INSERT INTO tb_city VALUES (166, ‘马鞍山市’, ‘mas’);
INSERT INTO tb_city VALUES (167, ‘牡丹江市’, ‘mdj’);
INSERT INTO tb_city VALUES (168, ‘茂名市’, ‘mm’);
INSERT INTO tb_city VALUES (169, ‘眉山市’, ‘ms’);
INSERT INTO tb_city VALUES (170, ‘绵阳市’, ‘my’);
INSERT INTO tb_city VALUES (171, ‘梅州市’, ‘mz’);
INSERT INTO tb_city VALUES (172, ‘南充市’, ‘nanchong’);
INSERT INTO tb_city VALUES (173, ‘宁波市’, ‘nb’);
INSERT INTO tb_city VALUES (174, ‘南昌市’, ‘nc’);
INSERT INTO tb_city VALUES (175, ‘宁德市’, ‘nd’);
INSERT INTO tb_city VALUES (176, ‘内江市’, ‘neijiang’);
INSERT INTO tb_city VALUES (177, ‘南京市’, ‘nj’);
INSERT INTO tb_city VALUES (178, ‘南宁市’, ‘nn’);
INSERT INTO tb_city VALUES (179, ‘南平市’, ‘np’);
INSERT INTO tb_city VALUES (180, ‘南通市’, ‘nt’);
INSERT INTO tb_city VALUES (181, ‘怒江市’, ‘nujiang’);
INSERT INTO tb_city VALUES (182, ‘南阳市’, ‘ny’);
INSERT INTO tb_city VALUES (183, ‘平顶山市’, ‘pds’);
INSERT INTO tb_city VALUES (184, ‘普洱市’, ‘pe’);
INSERT INTO tb_city VALUES (185, ‘盘锦市’, ‘pj’);
INSERT INTO tb_city VALUES (186, ‘平凉市’, ‘pl’);
INSERT INTO tb_city VALUES (187, ‘莆田市’, ‘pt’);
INSERT INTO tb_city VALUES (188, ‘萍乡市’, ‘px’);
INSERT INTO tb_city VALUES (189, ‘濮阳市’, ‘py’);
INSERT INTO tb_city VALUES (190, ‘攀枝花市’, ‘pzh’);
INSERT INTO tb_city VALUES (191, ‘青岛市’, ‘qd’);
INSERT INTO tb_city VALUES (192, ‘黔东南市’, ‘qdn’);
INSERT INTO tb_city VALUES (193, ‘秦皇岛市’, ‘qhd’);
INSERT INTO tb_city VALUES (194, ‘潜江市’, ‘qianjiang’);
INSERT INTO tb_city VALUES (195, ‘庆阳市’, ‘qingyang’);
INSERT INTO tb_city VALUES (196, ‘钦州市’, ‘qinzhou’);
INSERT INTO tb_city VALUES (197, ‘曲靖市’, ‘qj’);
INSERT INTO tb_city VALUES (198, ‘黔南市’, ‘qn’);
INSERT INTO tb_city VALUES (199, ‘齐齐哈尔市’, ‘qqhr’);
INSERT INTO tb_city VALUES (200, ‘七台河市’, ‘qth’);
INSERT INTO tb_city VALUES (201, ‘衢州市’, ‘quzhou’);
INSERT INTO tb_city VALUES (202, ‘黔西南市’, ‘qxn’);
INSERT INTO tb_city VALUES (203, ‘清远市’, ‘qy’);
INSERT INTO tb_city VALUES (204, ‘泉州市’, ‘qz’);
INSERT INTO tb_city VALUES (205, ‘日照市’, ‘rz’);
INSERT INTO tb_city VALUES (206, ‘三亚市’, ‘sanya’);
INSERT INTO tb_city VALUES (207, ‘韶关市’, ‘sg’);
INSERT INTO tb_city VALUES (208, ‘上海市’, ‘sh’);
INSERT INTO tb_city VALUES (209, ‘邵阳市’, ‘shaoyang’);
INSERT INTO tb_city VALUES (210, ‘十堰市’, ‘shiyan’);
INSERT INTO tb_city VALUES (211, ‘朔州市’, ‘shuozhou’);
INSERT INTO tb_city VALUES (212, ‘石家庄市’, ‘sjz’);
INSERT INTO tb_city VALUES (213, ‘商洛市’, ‘sl’);
INSERT INTO tb_city VALUES (214, ‘三明市’, ‘sm’);
INSERT INTO tb_city VALUES (215, ‘三门峡市’, ‘smx’);
INSERT INTO tb_city VALUES (216, ‘神农架市’, ‘snj’);
INSERT INTO tb_city VALUES (217, ‘松原市’, ‘songyuan’);
INSERT INTO tb_city VALUES (218, ‘四平市’, ‘sp’);
INSERT INTO tb_city VALUES (219, ‘商丘市’, ‘sq’);
INSERT INTO tb_city VALUES (220, ‘上饶市’, ‘sr’);
INSERT INTO tb_city VALUES (221, ‘汕头市’, ‘st’);
INSERT INTO tb_city VALUES (222, ‘宿州市’, ‘su’);
INSERT INTO tb_city VALUES (223, ‘绥化市’, ‘suihua’);
INSERT INTO tb_city VALUES (224, ‘遂宁市’, ‘suining’);
INSERT INTO tb_city VALUES (225, ‘随州市’, ‘suizhou’);
INSERT INTO tb_city VALUES (226, ‘宿迁市’, ‘suqian’);
INSERT INTO tb_city VALUES (227, ‘苏州市’, ‘suzhou’);
INSERT INTO tb_city VALUES (228, ‘汕尾市’, ‘sw’);
INSERT INTO tb_city VALUES (229, ‘绍兴市’, ‘sx’);
INSERT INTO tb_city VALUES (230, ‘沈阳市’, ‘sy’);
INSERT INTO tb_city VALUES (231, ‘双鸭山市’, ‘sys’);
INSERT INTO tb_city VALUES (232, ‘深圳市’, ‘bendibao.com/news/yqdengji/‘);
INSERT INTO tb_city VALUES (233, ‘石嘴山市’, ‘szs’);
INSERT INTO tb_city VALUES (234, ‘泰安市’, ‘ta’);
INSERT INTO tb_city VALUES (235, ‘塔城市’, ‘tacheng’);
INSERT INTO tb_city VALUES (236, ‘泰州市’, ‘taizhou’);
INSERT INTO tb_city VALUES (237, ‘铜川市’, ‘tc’);
INSERT INTO tb_city VALUES (238, ‘通化市’, ‘th’);
INSERT INTO tb_city VALUES (239, ‘天水市’, ‘tianshui’);
INSERT INTO tb_city VALUES (240, ‘天津市’, ‘tj’);
INSERT INTO tb_city VALUES (241, ‘吐鲁番市’, ‘tlf’);
INSERT INTO tb_city VALUES (242, ‘天门市’, ‘tm’);
INSERT INTO tb_city VALUES (243, ‘通辽市’, ‘tongliao’);
INSERT INTO tb_city VALUES (244, ‘铜陵市’, ‘tongling’);
INSERT INTO tb_city VALUES (245, ‘铜仁市’, ‘tr’);
INSERT INTO tb_city VALUES (246, ‘唐山市’, ‘ts’);
INSERT INTO tb_city VALUES (247, ‘太原市’, ‘ty’);
INSERT INTO tb_city VALUES (248, ‘台州市’, ‘tz’);
INSERT INTO tb_city VALUES (249, ‘威海市’, ‘weihai’);
INSERT INTO tb_city VALUES (250, ‘潍坊市’, ‘wf’);
INSERT INTO tb_city VALUES (251, ‘武汉市’, ‘wh’);
INSERT INTO tb_city VALUES (252, ‘乌兰察布市’, ‘wlcb’);
INSERT INTO tb_city VALUES (253, ‘乌鲁木齐市’, ‘wlmq’);
INSERT INTO tb_city VALUES (254, ‘渭南市’, ‘wn’);
INSERT INTO tb_city VALUES (255, ‘文山市’, ‘ws’);
INSERT INTO tb_city VALUES (256, ‘乌海市’, ‘wuhai’);
INSERT INTO tb_city VALUES (257, ‘芜湖市’, ‘wuhu’);
INSERT INTO tb_city VALUES (258, ‘武威市’, ‘wuwei’);
INSERT INTO tb_city VALUES (259, ‘吴忠市’, ‘wuzhong’);
INSERT INTO tb_city VALUES (260, ‘梧州市’, ‘wuzhou’);
INSERT INTO tb_city VALUES (261, ‘无锡市’, ‘wx’);
INSERT INTO tb_city VALUES (262, ‘温州市’, ‘wz’);
INSERT INTO tb_city VALUES (263, ‘五指山市’, ‘wzs’);
INSERT INTO tb_city VALUES (264, ‘西安市’, ‘xa’);
INSERT INTO tb_city VALUES (265, ‘兴安市’, ‘xam’);
INSERT INTO tb_city VALUES (266, ‘许昌市’, ‘xc’);
INSERT INTO tb_city VALUES (267, ‘襄阳市’, ‘xf’);
INSERT INTO tb_city VALUES (268, ‘孝感市’, ‘xg’);
INSERT INTO tb_city VALUES (269, ‘湘潭市’, ‘xiangtan’);
INSERT INTO tb_city VALUES (270, ‘湘西市’, ‘xiangxi’);
INSERT INTO tb_city VALUES (271, ‘咸宁市’, ‘xianning’);
INSERT INTO tb_city VALUES (272, ‘仙桃市’, ‘xiantao’);
INSERT INTO tb_city VALUES (273, ‘咸阳市’, ‘xianyang’);
INSERT INTO tb_city VALUES (274, ‘新余市’, ‘xinyu’);
INSERT INTO tb_city VALUES (275, ‘忻州市’, ‘xinzhou’);
INSERT INTO tb_city VALUES (276, ‘锡林郭勒市’, ‘xl’);
INSERT INTO tb_city VALUES (277, ‘厦门市’, ‘xm’);
INSERT INTO tb_city VALUES (278, ‘西宁市’, ‘xn’);
INSERT INTO tb_city VALUES (279, ‘邢台市’, ‘xt’);
INSERT INTO tb_city VALUES (280, ‘宣城市’, ‘xuancheng’);
INSERT INTO tb_city VALUES (281, ‘新乡市’, ‘xx’);
INSERT INTO tb_city VALUES (282, ‘信阳市’, ‘xy’);
INSERT INTO tb_city VALUES (283, ‘徐州市’, ‘xz’);
INSERT INTO tb_city VALUES (284, ‘雅安市’, ‘ya’);
INSERT INTO tb_city VALUES (285, ‘延边市’, ‘yanbian’);
INSERT INTO tb_city VALUES (286, ‘盐城市’, ‘yancheng’);
INSERT INTO tb_city VALUES (287, ‘阳泉市’, ‘yangquan’);
INSERT INTO tb_city VALUES (288, ‘宜宾市’, ‘yb’);
INSERT INTO tb_city VALUES (289, ‘银川市’, ‘yc’);
INSERT INTO tb_city VALUES (290, ‘云浮市’, ‘yf’);
INSERT INTO tb_city VALUES (291, ‘伊春市’, ‘yich’);
INSERT INTO tb_city VALUES (292, ‘宜昌市’, ‘yichang’);
INSERT INTO tb_city VALUES (293, ‘宜春市’, ‘yichun’);
INSERT INTO tb_city VALUES (294, ‘伊犁市’, ‘yili’);
INSERT INTO tb_city VALUES (295, ‘鹰潭市’, ‘yingtan’);
INSERT INTO tb_city VALUES (296, ‘益阳市’, ‘yiyang’);
INSERT INTO tb_city VALUES (297, ‘阳江市’, ‘yj’);
INSERT INTO tb_city VALUES (298, ‘营口市’, ‘yk’);
INSERT INTO tb_city VALUES (299, ‘榆林市’, ‘yl’);
INSERT INTO tb_city VALUES (300, ‘延安市’, ‘yn’);
INSERT INTO tb_city VALUES (301, ‘永州市’, ‘yongzhou’);
INSERT INTO tb_city VALUES (302, ‘玉树市’, ‘ys’);
INSERT INTO tb_city VALUES (303, ‘烟台市’, ‘yt’);
INSERT INTO tb_city VALUES (304, ‘玉林市’, ‘yulin’);
INSERT INTO tb_city VALUES (305, ‘运城市’, ‘yuncheng’);
INSERT INTO tb_city VALUES (306, ‘玉溪市’, ‘yx’);
INSERT INTO tb_city VALUES (307, ‘岳阳市’, ‘yy’);
INSERT INTO tb_city VALUES (308, ‘扬州市’, ‘yz’);
INSERT INTO tb_city VALUES (309, ‘枣庄市’, ‘zaozhuang’);
INSERT INTO tb_city VALUES (310, ‘淄博市’, ‘zb’);
INSERT INTO tb_city VALUES (311, ‘自贡市’, ‘zg’);
INSERT INTO tb_city VALUES (312, ‘珠海市’, ‘zh’);
INSERT INTO tb_city VALUES (313, ‘张掖市’, ‘zhangye’);
INSERT INTO tb_city VALUES (314, ‘漳州市’, ‘zhangzhou’);
INSERT INTO tb_city VALUES (315, ‘湛江市’, ‘zhanjiang’);
INSERT INTO tb_city VALUES (316, ‘舟山市’, ‘zhoushan’);
INSERT INTO tb_city VALUES (317, ‘株洲市’, ‘zhuzhou’);
INSERT INTO tb_city VALUES (318, ‘镇江市’, ‘zj’);
INSERT INTO tb_city VALUES (319, ‘张家界市’, ‘zjj’);
INSERT INTO tb_city VALUES (320, ‘张家口市’, ‘zjk’);
INSERT INTO tb_city VALUES (321, ‘周口市’, ‘zk’);
INSERT INTO tb_city VALUES (322, ‘驻马店市’, ‘zmd’);
INSERT INTO tb_city VALUES (323, ‘肇庆市’, ‘zq’);
INSERT INTO tb_city VALUES (324, ‘中山市’, ‘zs’);
INSERT INTO tb_city VALUES (325, ‘昭通市’, ‘zt’);
INSERT INTO tb_city VALUES (326, ‘遵义市’, ‘zunyi’);
INSERT INTO tb_city VALUES (327, ‘中卫市’, ‘zw’);
INSERT INTO tb_city VALUES (328, ‘资阳市’, ‘zy’);
INSERT INTO tb_city VALUES (329, ‘郑州市’, ‘zz’);
— Table structure for tb_dept
DROP TABLE IF EXISTS tb_dept;
CREATE TABLE tb_dept (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
dept_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘部门名称’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_dept_name(dept_name) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of tb_dept
INSERT INTO tb_dept VALUES (11, ‘保安部’);
INSERT INTO tb_dept VALUES (5, ‘后勤部’);
INSERT INTO tb_dept VALUES (4, ‘市场部’);
INSERT INTO tb_dept VALUES (3, ‘技术部’);
INSERT INTO tb_dept VALUES (1, ‘管理部’);
INSERT INTO tb_dept VALUES (2, ‘行政部’);
— Table structure for tb_face_model
DROP TABLE IF EXISTS tb_face_model;
CREATE TABLE tb_face_model (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键值’,
user_id int(10) UNSIGNED NOT NULL COMMENT ‘用户ID’,
face_model text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用户人脸模型’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_user_id(user_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of tb_face_model
— Table structure for tb_holidays
DROP TABLE IF EXISTS tb_holidays;
CREATE TABLE tb_holidays (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
date date NOT NULL COMMENT ‘日期’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_date(date) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘节假日表’ ROW_FORMAT = DYNAMIC;
— Records of tb_holidays
— Table structure for tb_meeting
DROP TABLE IF EXISTS tb_meeting;
CREATE TABLE tb_meeting (
id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
uuid varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘UUID’,
title varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘会议题目’,
creator_id bigint(200) NOT NULL COMMENT ‘创建人ID’,
date date NOT NULL COMMENT ‘日期’,
place varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘开会地点’,
start time(0) NOT NULL COMMENT ‘开始时间’,
end time(0) NOT NULL COMMENT ‘结束时间’,
type smallint(6) NOT NULL COMMENT ‘会议类型（1在线会议，2线下会议）’,
members json NOT NULL COMMENT ‘参与者’,
desc varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘会议内容’,
instance_id varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘工作流实例ID’,
status smallint(6) NOT NULL COMMENT ‘状态（1未开始，2进行中，3已结束）’,
create_time datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT ‘创建时间’,
PRIMARY KEY (id) USING BTREE,
INDEX idx_creator_id(creator_id) USING BTREE,
INDEX idx_date(date) USING BTREE,
INDEX idx_type(type) USING BTREE,
INDEX idx_status(status) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘会议表’ ROW_FORMAT = DYNAMIC;
— Records of tb_meeting
— Table structure for tb_module
DROP TABLE IF EXISTS tb_module;
CREATE TABLE tb_module (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
module_code varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘模块编号’,
module_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘模块名称’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_module_id(module_code) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘模块资源表’ ROW_FORMAT = DYNAMIC;
— Records of tb_module
INSERT INTO tb_module VALUES (1, ‘USER’, ‘用户管理’);
INSERT INTO tb_module VALUES (2, ‘EMPLOYEE’, ‘员工管理’);
INSERT INTO tb_module VALUES (3, ‘DEPT’, ‘部门管理’);
INSERT INTO tb_module VALUES (4, ‘MEETING’, ‘会议管理’);
INSERT INTO tb_module VALUES (5, ‘WORKFLOW’, ‘工作流管理’);
— Table structure for tb_permission
DROP TABLE IF EXISTS tb_permission;
CREATE TABLE tb_permission (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
permission_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘权限’,
module_id int(10) UNSIGNED NOT NULL COMMENT ‘模块ID’,
action_id int(10) UNSIGNED NOT NULL COMMENT ‘行为ID’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_permission(permission_name) USING BTREE,
UNIQUE INDEX unq_complex(module_id, action_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of tb_permission
INSERT INTO tb_permission VALUES (1, ‘USER:INSERT’, 1, 1);
INSERT INTO tb_permission VALUES (2, ‘USER:DELETE’, 1, 2);
INSERT INTO tb_permission VALUES (3, ‘USER:UPDATE’, 1, 3);
INSERT INTO tb_permission VALUES (4, ‘USER:SELECT’, 1, 4);
INSERT INTO tb_permission VALUES (5, ‘EMPLOYEE:INSERT’, 2, 1);
INSERT INTO tb_permission VALUES (6, ‘EMPLOYEE:DELETE’, 2, 2);
INSERT INTO tb_permission VALUES (7, ‘EMPLOYEE:UPDATE’, 2, 3);
INSERT INTO tb_permission VALUES (8, ‘EMPLOYEE:SELECT’, 2, 4);
INSERT INTO tb_permission VALUES (9, ‘DEPT:INSERT’, 3, 1);
INSERT INTO tb_permission VALUES (10, ‘DEPT:DELETE’, 3, 2);
INSERT INTO tb_permission VALUES (11, ‘DEPT:UPDATE’, 3, 3);
INSERT INTO tb_permission VALUES (12, ‘DEPT:SELECT’, 3, 4);
INSERT INTO tb_permission VALUES (13, ‘MEETING:INSERT’, 4, 1);
INSERT INTO tb_permission VALUES (14, ‘MEETING:DELETE’, 4, 2);
INSERT INTO tb_permission VALUES (15, ‘MEETING:UPDATE’, 4, 3);
INSERT INTO tb_permission VALUES (16, ‘MEETING:SELECT’, 4, 4);
INSERT INTO tb_permission VALUES (17, ‘WORKFLOW:APPROVAL’, 5, 5);
INSERT INTO tb_permission VALUES (18, ‘ROOT’, 0, 0);
UPDATE tb_permission SET id=0 WHERE permission_name=’ROOT’;
— Table structure for tb_role
DROP TABLE IF EXISTS tb_role;
CREATE TABLE tb_role (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
role_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘角色名称’,
permissions json NOT NULL COMMENT ‘权限集合’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_role_name(role_name) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘角色表’ ROW_FORMAT = DYNAMIC;
— Records of tb_role
INSERT INTO tb_role VALUES (1, ‘总经理’, ‘[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17]’);
INSERT INTO tb_role VALUES (2, ‘部门经理’, ‘[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11]’);
INSERT INTO tb_role VALUES (3, ‘普通员工’, ‘[1, 2, 3, 4, 5, 6, 7, 8]’);
INSERT INTO tb_role VALUES (4, ‘超级管理员’, ‘[0]’);
UPDATE tb_role SET id=0 WHERE role_name=’超级管理员’;
— Table structure for tb_user
DROP TABLE IF EXISTS tb_user;
CREATE TABLE tb_user (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
open_id varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘长期授权字符串’,
nickname varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘昵称’,
photo varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘头像网址’,
name varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘姓名’,
sex enum(‘男’,’女’) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘性别’,
tel char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘手机号码’,
email varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘邮箱’,
hiredate date NULL DEFAULT NULL COMMENT ‘入职日期’,
role json NOT NULL COMMENT ‘角色’,
root tinyint(1) NOT NULL COMMENT ‘是否是超级管理员’,
dept_id int(10) UNSIGNED NULL DEFAULT NULL COMMENT ‘部门编号’,
status tinyint(4) NOT NULL COMMENT ‘状态’,
create_time datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT ‘创建时间’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_open_id(open_id) USING BTREE,
INDEX unq_email(email) USING BTREE,
INDEX idx_dept_id(dept_id) USING BTREE,
INDEX idx_status(status) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用户表’ ROW_FORMAT = DYNAMIC;
— Records of tb_user
— Table structure for tb_workday
DROP TABLE IF EXISTS tb_workday;
CREATE TABLE tb_workday (
id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
date date NULL DEFAULT NULL COMMENT ‘日期’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX unq_date(date) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
— Records of tb_workday
SET FOREIGN_KEY_CHECKS = 1;
<a name="WpH2r"></a>## MongoDB的安装开发系统少不了系统消息这个模块，比如要给一千人发消息就有1000条消息记录，放入mysql非常占用空间，而且mysql数据表单表超过2000万，性能就会大幅下降，所以我们使用mongoDB来存放消息。在[MongoDB官网](https://fastdl.mongodb.org/win32/mongodb-win32-x86_64-2008plus-ssl-4.0.28-signed.msi)上下载msi文件，然后选择好自己的安装地址，然后全部都是next一路选择默认。<br />下载好了之后可以使用Navicat或者MongoDB Compass去连接，后者如果你不会的话可以看下面这个[博客](https://blog.csdn.net/weixin_45492007/article/details/104075811)<br />这里注意两点：- **win7最高只能下载4.0.28**- **win7在下载导向当中最好取消单击 Install MongoDB Compass，然后单独下载MongoDB Compass，下载地址在**[**这里**](https://www.mongodb.com/try/download/compass?tck=docs_server)默认mongoDB安装的时候没有用户名和密码，所以在使用MongoDB Compass连接的时候在Authentication当中默认选择的是None：<br />我们需要在admin验证库当中设置和保存，在MongoDB界面最底部的_MONGOSH当中先进入到admin当中，然后创建一个用户，名字为root，密码自己取，这个root用户的为最高权限，保存在admin数据库当中：<br /><br />配置好之后再重新连接一下本地，那么Authentication当中就需要使用Username/Password的方式了：<br /><a name="HXcns"></a>## Redis的安装Redis的安装可以直接参考[菜鸟教程](https://www.runoob.com/redis/redis-install.html)，每次启动都需要到安装的地方打开命令行执行下面的命令进行启动：```shellredis-server.exe redis.windows.conf
当然如果你认为这样太麻烦了，可以将redis设置为windows服务，这样不用每次都使用命令来启动了
关于设置Redis的连接密码，在redis.conf（windows当中是redis.windows.conf文件）当中有一个地方进行注释修改即可，比如下面这种就是将密码修改为了admin123
# requirepass foobaredrequirepass admin123
关于Redis可视化的工具这里推荐两种，一个是RedisInsight-v2,一个是RedisDesktopManager, 使用起来也很方便，后者更加方便，如果在上步你设置了连接密码，在下图当中验证地方需要填写密码进行验证：
- RedisDesktopManager新版在github需要自行编译，当然网上也有编译好的
而RedisInsight界面更加好看一些：
Maven安装
到Maven官网去下载zip包，然后解压缩（不要解压到C盘）:
- 到解压的目录下创建一个要放以后项目里用到的所有maven包的文件夹，可以叫做maven-repo
在conf/settings.xml当中去配置，需要配置两个地方
一个是刚才我们创建的maven-repo地址要配置进来(因为我maven解压缩到了D盘的apache-maven-3.8.1目录下)：
<localRepository>D:\apache-maven-3.8.1\maven-repo</localRepository>
另一个是配置阿里云仓库，因为maven原本的仓库地址是在外国：
<mirrors><!-- mirror| Specifies a repository mirror site to use instead of a given repository. The repository that| this mirror serves has an ID that matches the mirrorOf element of this mirror. IDs are used| for inheritance and direct lookup purposes, and must be unique across the set of mirrors.|<mirror><id>mirrorId</id><mirrorOf>repositoryId</mirrorOf><name>Human Readable Name for this Mirror.</name><url>http://my.repository.com/repo/path</url></mirror>--><!-- <mirror><id>maven-default-http-blocker</id><mirrorOf>external:http:*</mirrorOf><name>Pseudo repository to mirror external repositories initially using HTTP.</name><url>http://0.0.0.0/</url><blocked>true</blocked></mirror> --><mirror><id>nexus-aliyun</id><mirrorOf>central</mirrorOf><name>Nexus aliyun</name><url>http://maven.aliyun.com/nexus/content/groups/public</url></mirror><mirror><id>alimaven</id><mirrorOf>central</mirrorOf><name>aliyun maven</name><url>http://maven.aliyun.com/nexus/content/repositories/central/</url></mirror><mirror><id>repo2</id><mirrorOf>central</mirrorOf><name>Human Readable Name for this Mirror.</name><url>http://repo2.maven.org/maven2/</url></mirror></mirrors>
最后我们在IDEA上面去配置我们刚才设置好的maven即可，在File->Setting当中找到Mave配置界面，改三个东西：Mave的目录地址，Maven配置文件地址，Maven依赖包下载本地地址：
IDEA插件安装
- Lombok插件： 编译字节码的时候自动生成set/get方法
- Free MyBatis Plus插件：创建数据库连接，根据选中的数据表生成各种MyBatis文件
小程序开发工具的安装
到微信开发工具平台去下载稳定版的小程序开发工具，然后要开放小程序服务端口，因为后面使用uni-app去开发小程序后，编译后需要运行在小程序开发工具上。
HBuilderX的安装
在HBuilder官网上去下载HBuilderX，这个是专门使用vue去编写小程序的软件，下载下来的是zip，解压之后我们需要去配置小程序开发工具安装路径：
- 工具 -> 设置
- 在运行配置当中找到微信开发者工具路径，并如实填写
VirtualBox虚拟机的安装
- Bios开启cpu虚拟化
- 选择正确的网卡（就是物理网卡，有的笔记本有两个网卡：有线网卡和无限网卡，需要正确选择）
- 设置桥接网络（不要使用NAT的方式）
- 桥接网络能让虚拟化的实例拥有独立的IP地址
- NAT网络共享宿主机IP地址
- 宿主机是Windows系统
- Windows不支持多IP和虚拟IP
- Windows防火墙会影响虚拟机实例
首先去开启BIOS虚拟化，在主板BIOS上面开启CPU虚拟化，为的是能在电脑上安装Docker程序。如果不开启虚拟 化，是无法安装Docker的。AMD和Intel的CPU在BIOS界面开启虚拟化的方式不同，请看下 面的具体区别。
- AMD：在BIOS界面找到SVM,开启这个选项：
- Intel：在BIOS界面找到下面的选项，开启即可：
接着去virtualbox官网去下载exe文件，也可以到VirtualBox 镜像去下载最新版，然后执行默认的安装即可（我是下载了6.1.12版本，改了一下安装路径，不想放在C盘）。
下面我们来一步步讲解创建虚拟机：
- 首先在VirtualBox界面上点击新建按钮，开始创建虚拟机：
- 定义虚拟机的名字，只要你填写CentOS，下面会自动设置好类型为Linux，版本为 RedHat。（因为CentOS系统是根据RedHat代码编译而来的，跟RedHat是同源的操作系统， 稳定性和安全性都是相同的，只不过无法使用RedHat那些收费的商业服务。在 诸多免费Linux发行版里面，CentOS系统是最适合安装在服务器上面）
- 虚拟机的内存建议同学们设置成2GB（2048MB）（因为我们要在Linux上面运行Docker，Docker里面还要跑人脸识别程序，还包括 了机器学习的功能，所以虚拟机的内存不能太小。另外，2GB的内存不是启动 虚拟机就直接占用掉2GB内存空间，这里只是规定的最大内存空间。低负载的 情况下，虚拟机实际占用的内存仅仅几百兆而已）。
- 默认选择创建虚拟磁盘。
- 设置上限为20G。
- 修改网络模式为桥接（虚拟机默认网络模式为NAT，也就是虚拟机和Windows公用同一个IP地址。由 于Windows系统不可以在网卡中设置多个IP地址，所以有时候我们想把部署的 程序配不同的IP和端口就没办法实现，包括搭建Swarm分布式环境的时候， 每个虚拟机主机IP必须不同。这么看来，NAT模式不太能满足我们的需求。 我建议大家把网络模式改成桥接，这样虚拟机会使用虚拟的网卡上网，虚拟机 会享用一个独立的IP。甚至我们可以在虚拟网卡里面设置多个IP地址，这都是 可以的。）
- 在创建的虚拟机上面点击右键，选择设置
- 在网络界面，选择桥接网卡，然后选中你上网的网卡。（网卡怎么选呢？打开自己电脑的网络和共享中心，然后选择更改适配器设置，根据你现在正在使用的上网的网卡进行选择，如下图）
CentOS系统的安装
我们使用的CentOS7这个版本，主要的步骤就是下面三个：
- 开启网络服务
- 设置管理员密码
- 查看主机IP地址
关于centos.iso文件可以去阿里云开源镜像站去下载，或者可以去centos官网下载，下面我们就开始给我们上面的虚拟机安装CentOS系统：
- 首先向光驱插入ISO文件：
- 右键设置，然后进入存储设置面板。
- 点击没有盘片，表示这里没有光驱。
- 在分配光驱的右侧，点击小图标，选择“选择或创建一个虚拟光驱”。
- 点击注册。
- 选择你之前下载好的centos7的iso镜像文件。
- 点击选择按钮。
- 经过上面步骤iso文件已经成功插入光驱，点击OK保存配置即可
- 启动虚拟机，安装centos系统
- 启动虚拟机：
- 选择第一个选项，开始执行安装：
- 安装界面语言选择中文：
- 选择安装位置
- 默认会自动创建分区，不需要我们干预，点击完成即可
- 默认情况下CentOS并没有开启联网功能，需要我们手动开启联网
- 选择打开网络，然后记住你虚拟网卡的名字
- 然后选择开始安装CentOS
- 安装过程中，可以设置root账户密码
- 安装完成之后点击重启，选择第一个，root账户登录CentOS系统，查看系统IP地址（ip addr）
下面我们就需要根据这个IP地址去创建SSH连接。
建立SSH连接
- 使用MobaXterm软件
- 最好的SSH客户端软件
- 只支持Window系统
- 可以支持多种远程连接方式
- 内置SFTP功能（上传文件）
- 修改CentOS静态IP地址（Linux应该有固定的静态的IP地址，如果你的电脑重启之后，虚拟机的IP就会辩变化，所以虚拟机当中的CentOS系统应该有固定的静态的IP地址）
- 创建虚拟机快照（可以还原，快照就是个还原点而已）
然后创建连接之后，就需要输入用户名和密码，然后还让你输入加密的密码，因为用户名和密码以明文的方式保存在本地不安全，可以检查一下ip地址：
下面我们需要给centos设置静态IP地址：
- 进入到/etc/sysconfig/network-scripts/目录，查找你网卡对应的文件，文件名字就是ifcfg-xxxx,xxx就是之前你要记住的ip的名字
- 使用编辑器打开这个文件，添加并设置红色的部分，保存文件
- 左侧就是一个SFTP的功能区域，找到对应文件，然后右键->open with
- 使用本地某个编辑器打开，修改完保存
- 重启网络服务 ```shell // 方法一 service network restart
// 方法二：或者使用下面两个命令 systemctl restart NetworkManager systemctl restart network ```
- 创建新的IP的SSH连接，然后ping某个网址，看看结果
参考文档：Centos ping不通百度彻底解决
若有收获，就点个赞吧
0 人点赞
