4aca0c7f6f
Some checks failed
Build and Deploy (service.xpcool.com) / build-and-deploy (push) Failing after 5m7s
- 新增 9 张房屋相关数据表（社区/楼宇/房源/价格快照/交易/设施/社区设施/学区/偏好） - 添加菜单权限种子数据并绑定超级管理员角色 - 生成 DAO 层代码和实体对象 - 实现房屋模块 API 接口（社区/房源/看板）和控制器服务层 - 支持多平台软关联匹配、笋盘标记和低可信度标记功能 - 更新超级管理员账号为 xxcool/xxCool@2026 - 调整 RBAC 菜单结构，移除管理员管理功能，新增日志管理菜单 - 修复 RBAC 安全漏洞，确保禁用角色权限失效 - 重构认证模块，将登录相关接口迁移到统一包结构下 - 移除废弃的管理模块和工具类接口定义 - 为通用工具包添加中文注释和文档说明
37 lines
1.7 KiB
Go
37 lines
1.7 KiB
Go
-- 008_admin_account_v2.sql
|
||
-- 生产环境超级管理员账号替换（一次性/可重跑幂等）：
|
||
-- 1) 彻底删除 admin/admin123 相关数据（用户、角色绑定、refresh 会话、审计记录）
|
||
-- 2) 新增超级管理员 xxcool（密码 xxCool@2026，bcrypt 哈希），绑定 super_admin 角色
|
||
-- 说明：xxcool 哈希为 bcrypt cost=10（$2b$10$...，Go bcrypt.CompareHashAndPassword 兼容 2a/2b/2y）。
|
||
|
||
-- ============ 1) 删除 admin 账号及其全部数据痕迹 ============
|
||
-- refresh 会话（scope=admin 且 subject 指向 admin）
|
||
DELETE FROM auth_refresh_session
|
||
WHERE scope = 'admin' AND subject_id = (SELECT id FROM admin_user WHERE username = 'admin');
|
||
|
||
-- 审计操作日志
|
||
DELETE FROM admin_operation_log
|
||
WHERE admin_user_id = (SELECT id FROM admin_user WHERE username = 'admin');
|
||
|
||
-- 用户-角色绑定
|
||
DELETE FROM admin_user_role
|
||
WHERE admin_user_id = (SELECT id FROM admin_user WHERE username = 'admin');
|
||
|
||
-- 用户本身
|
||
DELETE FROM admin_user WHERE username = 'admin';
|
||
|
||
-- ============ 2) 新增 xxcool 超级管理员 ============
|
||
-- 防重跑：先清掉可能存在的 xxcool
|
||
DELETE FROM admin_user_role
|
||
WHERE admin_user_id = (SELECT id FROM admin_user WHERE username = 'xxcool');
|
||
DELETE FROM auth_refresh_session
|
||
WHERE scope = 'admin' AND subject_id = (SELECT id FROM admin_user WHERE username = 'xxcool');
|
||
DELETE FROM admin_user WHERE username = 'xxcool';
|
||
|
||
INSERT INTO admin_user (username, password_hash, nickname, status, created_at, updated_at)
|
||
VALUES ('xxcool', '$2b$10$9saH0goudfeZ4pdIUELOFe5zJCgTMGB/cvPE/uPA343gHC2.xdfly', '超级管理员', 1, NOW(), NOW());
|
||
|
||
-- 绑定 super_admin 角色（role_id=1）
|
||
INSERT INTO admin_user_role (admin_user_id, role_id, created_at, updated_at)
|
||
VALUES (LAST_INSERT_ID(), 1, NOW(), NOW());
|