ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
CREATE DATABASE IF NOT EXISTS deploy DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_general_ci;
use deploy;
DROP TABLE IF EXISTS `d_user`;
CREATE TABLE `d_user`  (
  `id` int unsigned NOT NULL,
  `username` varchar(10)  NOT NULL DEFAULT '',
  `password` varchar(32)  NOT NULL DEFAULT '',
  `git_token` varchar(100)  NOT NULL DEFAULT '' COMMENT 'git仓库的',
  `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `git_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 gitlab  2github 3gitee',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `d_user` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '6aaef86af61ffc5ccb05372516b0e2da', '2022-08-12 15:20:44', '2022-08-12 18:23:11', 3);
DROP TABLE IF EXISTS `d_user_project`;
CREATE TABLE `d_user_project`  (
  `id` int unsigned NOT NULL,
  `name` varchar(20)  NOT NULL DEFAULT '' COMMENT '项目名称',
  `repo_name` varchar(20)  NOT NULL DEFAULT '' COMMENT '仓库名称',
  `branch_name` varchar(20)  NOT NULL DEFAULT '' COMMENT '分支名称',
  `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;