SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE `sys_users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, `uuid` varchar(191) DEFAULT NULL COMMENT '用户UUID', `username` varchar(191) DEFAULT NULL COMMENT '用户登录名', `password` varchar(191) DEFAULT NULL COMMENT '用户登录密码', `nick_name` varchar(191) DEFAULT '系统用户' COMMENT '用户昵称', `header_img` varchar(191) DEFAULT 'http://qmplusimg.henrongyi.top/head.png' COMMENT '用户头像', `authority_id` varchar(191) DEFAULT '888' COMMENT '用户角色ID', PRIMARY KEY (`id`), KEY `idx_sys_users_deleted_at` (`deleted_at`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; CREATE TABLE `sys_authorities` ( `created_at` datetime NULL, `updated_at` datetime NULL, `deleted_at` datetime NULL, `authority_id` varchar(90) NOT NULL UNIQUE COMMENT '角色ID', `authority_name` varchar(191) COMMENT '角色名', PRIMARY KEY (`authority_id`), INDEX idx_sys_authorities_deleted_at (`deleted_at`), CONSTRAINT `fk_sys_usersority` FOREIGN KEY (`authority_id`) REFERENCES `sys_users`(`authority_id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci