做薪酬调查有哪些网站,校园二手交易网站设计的原则,wordpress自定义站点,成都开发公司一.前言 该项目学习自黑马程序员#xff0c;由我整理如下#xff0c;版权归黑马程序员所有
二.环境搭建 1.数据库 第一天#xff0c;先创建如下库和表: sql文件如下: CREATE DATABASE IF NOT EXISTS leadnews_user DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_…一.前言 该项目学习自黑马程序员由我整理如下版权归黑马程序员所有
二.环境搭建 1.数据库 第一天先创建如下库和表: sql文件如下: CREATE DATABASE IF NOT EXISTS leadnews_user DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE leadnews_user;
SET NAMES utf8;
/*
Navicat MySQL Data TransferSource Server : localhost
Source Server Version : 50721
Source Host : localhost:3306
Source Database : leadnews_userTarget Server Type : MYSQL
Target Server Version : 50721
File Encoding : 65001Date: 2021-04-12 13:58:42
*/SET FOREIGN_KEY_CHECKS0;-- ----------------------------
-- Table structure for ap_user
-- ----------------------------
DROP TABLE IF EXISTS ap_user;
CREATE TABLE ap_user (id int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 主键,salt varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 密码、通信等加密盐,name varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 用户名,password varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 密码,md5加密,phone varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 手机号,image varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 头像,sex tinyint(1) unsigned DEFAULT NULL COMMENT 0 男\r\n 1 女\r\n 2 未知,is_certification tinyint(1) unsigned DEFAULT NULL COMMENT 0 未\r\n 1 是,is_identity_authentication tinyint(1) DEFAULT NULL COMMENT 是否身份认证,status tinyint(1) unsigned DEFAULT NULL COMMENT 0正常\r\n 1锁定,flag tinyint(1) unsigned DEFAULT NULL COMMENT 0 普通用户\r\n 1 自媒体人\r\n 2 大V,created_time datetime DEFAULT NULL COMMENT 注册时间,PRIMARY KEY (id) USING BTREE
) ENGINEInnoDB AUTO_INCREMENT7 DEFAULT CHARSETutf8mb4 COLLATEutf8mb4_unicode_ci ROW_FORMATDYNAMIC COMMENTAPP用户信息表;-- ----------------------------
-- Records of ap_user
-- ----------------------------
INSERT INTO ap_user VALUES (1, abc, zhangsan, abc, 13511223453, null, 1, null, null, 1, 1, 2020-03-19 23:22:07);
INSERT INTO ap_user VALUES (2, abc, lisi, abc, 13511223454, , 1, null, null, 1, 1, 2020-03-19 23:22:07);
INSERT INTO ap_user VALUES (3, sdsa, wangwu, wangwu, 13511223455, null, null, null, null, null, 1, null);
INSERT INTO ap_user VALUES (4, 123abc, admin, 81e158e10201b6d7aee6e35eaf744796, 13511223456, null, 1, null, null, 1, 1, 2020-03-30 16:36:32);
INSERT INTO ap_user VALUES (5, 123, suwukong, suwukong, 13511223458, null, 1, null, null, 1, 1, 2020-08-01 11:09:57);
INSERT INTO ap_user VALUES (6, null, null, null, null, null, null, null, null, null, null, null);-- ----------------------------
-- Table structure for ap_user_fan
-- ----------------------------
DROP TABLE IF EXISTS ap_user_fan;
CREATE TABLE ap_user_fan (id int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 主键,user_id int(11) unsigned DEFAULT NULL COMMENT 用户ID,fans_id int(11) unsigned DEFAULT NULL COMMENT 粉丝ID,fans_name varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 粉丝昵称,level tinyint(1) unsigned DEFAULT NULL COMMENT 粉丝忠实度\r\n 0 正常\r\n 1 潜力股\r\n 2 勇士\r\n 3 铁杆\r\n 4 老铁,created_time datetime DEFAULT NULL COMMENT 创建时间,is_display tinyint(1) unsigned DEFAULT NULL COMMENT 是否可见我动态,is_shield_letter tinyint(1) unsigned DEFAULT NULL COMMENT 是否屏蔽私信,is_shield_comment tinyint(1) unsigned DEFAULT NULL COMMENT 是否屏蔽评论,PRIMARY KEY (id) USING BTREE
) ENGINEInnoDB DEFAULT CHARSETutf8mb4 COLLATEutf8mb4_unicode_ci ROW_FORMATDYNAMIC COMMENTAPP用户粉丝信息表;-- ----------------------------
-- Records of ap_user_fan
-- ------------------------------ ----------------------------
-- Table structure for ap_user_follow
-- ----------------------------
DROP TABLE IF EXISTS ap_user_follow;
CREATE TABLE ap_user_follow (id int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 主键,user_id int(11) unsigned DEFAULT NULL COMMENT 用户ID,follow_id int(11) unsigned DEFAULT NULL COMMENT 关注作者ID,follow_name varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 粉丝昵称,level tinyint(1) unsigned DEFAULT NULL COMMENT 关注度\r\n 0 偶尔感兴趣\r\n 1 一般\r\n 2 经常\r\n 3 高度,is_notice tinyint(1) unsigned DEFAULT NULL COMMENT 是否动态通知,created_time datetime DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id) USING BTREE
) ENGINEInnoDB DEFAULT CHARSETutf8mb4 COLLATEutf8mb4_unicode_ci ROW_FORMATDYNAMIC COMMENTAPP用户关注信息表;-- ----------------------------
-- Records of ap_user_follow
-- ------------------------------ ----------------------------
-- Table structure for ap_user_realname
-- ----------------------------
DROP TABLE IF EXISTS ap_user_realname;
CREATE TABLE ap_user_realname (id int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 主键,user_id int(11) unsigned DEFAULT NULL COMMENT 账号ID,name varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 用户名称,idno varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 资源名称,font_image varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 正面照片,back_image varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 背面照片,hold_image varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 手持照片,live_image varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 活体照片,status tinyint(1) unsigned DEFAULT NULL COMMENT 状态\r\n 0 创建中\r\n 1 待审核\r\n 2 审核失败\r\n 9 审核通过,reason varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 拒绝原因,created_time datetime DEFAULT NULL COMMENT 创建时间,submited_time datetime DEFAULT NULL COMMENT 提交时间,updated_time datetime DEFAULT NULL COMMENT 更新时间,PRIMARY KEY (id) USING BTREE
) ENGINEInnoDB AUTO_INCREMENT6 DEFAULT CHARSETutf8mb4 COLLATEutf8mb4_unicode_ci ROW_FORMATDYNAMIC COMMENTAPP实名认证信息表;-- ----------------------------
-- Records of ap_user_realname
-- ----------------------------
INSERT INTO ap_user_realname VALUES (1, 1, zhangsan, 512335455602781278, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbHSAQlqFAAXIZNzAq9E126.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbF6AR16RAAZB2e1EsOg460.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbDeAH2qoAAbD_WiUJfk745.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9ba9qANVEdAAS25KJlEVE291.jpg, 9, , 2019-07-30 14:34:28, 2019-07-30 14:34:30, 2019-07-12 06:48:04);
INSERT INTO ap_user_realname VALUES (2, 2, lisi, 512335455602781279, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbHSAQlqFAAXIZNzAq9E126.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbF6AR16RAAZB2e1EsOg460.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbDeAH2qoAAbD_WiUJfk745.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9ba9qANVEdAAS25KJlEVE291.jpg, 1, , 2019-07-11 17:21:18, 2019-07-11 17:21:20, 2019-07-12 06:48:04);
INSERT INTO ap_user_realname VALUES (3, 3, wangwu6666, 512335455602781276, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbHSAQlqFAAXIZNzAq9E126.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbF6AR16RAAZB2e1EsOg460.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbDeAH2qoAAbD_WiUJfk745.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9ba9qANVEdAAS25KJlEVE291.jpg, 9, , 2019-07-11 17:21:18, 2019-07-11 17:21:20, 2019-07-12 06:48:04);
INSERT INTO ap_user_realname VALUES (5, 5, suwukong, 512335455602781279, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbHSAQlqFAAXIZNzAq9E126.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbF6AR16RAAZB2e1EsOg460.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9bbDeAH2qoAAbD_WiUJfk745.jpg, http://161.189.111.227/group1/M00/00/00/rBFwgF9ba9qANVEdAAS25KJlEVE291.jpg, 1, , 2020-08-01 11:10:31, 2020-08-01 11:10:34, 2020-08-01 11:10:36);2.虚拟机搭建 然后就是用finalshell连接虚拟机了
3.1docker更换源 一、国内常用镜像源
Docker中国官方镜像加速
--registry-mirrorhttps://registry.docker-cn.com网易163镜像加速
--registry-mirrorhttp://hub-mirror.c.163.com中科大镜像加速
--registry-mirrorhttps://docker.mirrors.ustc.edu.cn阿里云镜像加速需要注册账号后使用
--registry-mirrorhttps://{your_id}.mirror.aliyuncs.com
二、创建daemon.json文件
sudo mkdir -p /etc/docker
sudo tee /etc/docker/daemon.json -EOF
{registry-mirrors: [https://docker.mirrors.ustc.edu.cn]
}
EOF
三、重载Docker配置文件
sudo systemctl daemon-reload
四、重启Docker服务
sudo systemctl restart docker
五、查看配置结果
docker info|grep Mirrors -A 1 3.docker安装nacos 注意一定要访问ip:8848/nacos不要少了nacos否则会报404 4.初始化工程 三.全局异常处理 四.登录加密 通过加盐可以保证每个人最终生成的md5加密字符串不同使其难以破解
