From f0f00e9ba8a755e4317e029d73b69a92ad9f9df1 Mon Sep 17 00:00:00 2001 From: kongzy <kongzy> Date: 星期六, 14 九月 2024 17:02:41 +0800 Subject: [PATCH] update --- exam-admin/src/main/resources/db/migration/V20231016001_add_user.sql | 5 ++--- 1 files changed, 2 insertions(+), 3 deletions(-) diff --git a/exam-admin/src/main/resources/db/migration/V20231016001_add_user.sql b/exam-admin/src/main/resources/db/migration/V20231016001_add_user.sql index b160bee..207f24f 100644 --- a/exam-admin/src/main/resources/db/migration/V20231016001_add_user.sql +++ b/exam-admin/src/main/resources/db/migration/V20231016001_add_user.sql @@ -1,7 +1,6 @@ -- ---------------------------- -- 系统管理用户表 -- ---------------------------- -drop table if exists `train_exam`.`sys_user`; CREATE TABLE `train_exam`.`sys_user` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录账号', @@ -10,7 +9,7 @@ `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码', `sex` tinyint NULL DEFAULT 2 COMMENT '用户性别(0男，1女，2未知，默认2)', `company_id` bigint(20) NULL DEFAULT NULL COMMENT '公司id', -`parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父级账号id', +`parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父级账号id', `password` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码', `status` tinyint NULL DEFAULT 0 COMMENT '账号状态(0正常，1停用，默认0)', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志(0代表存在，2代表删除，默认0)', @@ -27,4 +26,4 @@ UNIQUE INDEX `index_username`(`username`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统管理用户表' ROW_FORMAT = Dynamic; -insert into sys_user values(1, 'admin', '国科鸿宇', 0, '15888888888', 0, null, '$2a$10$CrsAZufp851DxTmUBep7TOuUAESWdqlkrReAIR.4SHBIahl9exO6y', 0, 0, '127.0.0.1', sysdate(), sysdate(), 'admin', sysdate(), '', sysdate(), '管理员',0); +insert into sys_user values(1, 'admin', '国科鸿宇', 0, '15888888888', 0, null,0, '$2a$10$CrsAZufp851DxTmUBep7TOuUAESWdqlkrReAIR.4SHBIahl9exO6y', 0, 0, '127.0.0.1', sysdate(), sysdate(), 'admin', sysdate(), '', sysdate(), '管理员',0); -- Gitblit v1.9.2