Home Explore Help
Sign In
WangKang
/
emoon-backend
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master-arch-20260326
Branches Tags
emoon-backend
/
script
/
sql
/
mysql-bak-2025-09-26
/
sys_config.sql

sys_config.sql 8.7 KB
Permalink History Raw

1234567891011121314151617181920212223242526272829303132333435363738 
  1. create table sys_config
    2. 

  2. (
    3. 

  3.     config_id    bigint                        not null comment '参数主键'
    4. 

  4.         primary key,
    5. 

  5.     tenant_id    varchar(20)  default '000000' null comment '租户编号',
    6. 

  6.     config_name  varchar(100) default ''       null comment '参数名称',
    7. 

  7.     config_key   varchar(100) default ''       null comment '参数键名',
    8. 

  8.     config_value varchar(500) default ''       null comment '参数键值',
    9. 

  9.     config_type  char         default 'N'      null comment '系统内置（Y是 N否）',
    10. 

  10.     create_dept  bigint                        null comment '创建部门',
    11. 

  11.     create_by    bigint                        null comment '创建者',
    12. 

  12.     create_time  datetime                      null comment '创建时间',
    13. 

  13.     update_by    bigint                        null comment '更新者',
    14. 

  14.     update_time  datetime                      null comment '更新时间',
    15. 

  15.     remark       varchar(500)                  null comment '备注'
    16. 

  16. )
    17. 

  17.     comment '参数配置表';
    18. 

  18. 

  19. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1, '000000', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 103, 1, '2025-08-23 21:51:26', null, null, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
    20. 

  20. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (2, '000000', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 103, 1, '2025-08-23 21:51:26', null, null, '初始化密码 123456');
    21. 

  21. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (3, '000000', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, '2025-08-23 21:51:26', null, null, '深色主题theme-dark，浅色主题theme-light');
    22. 

  22. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (5, '000000', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 103, 1, '2025-08-23 21:51:26', null, null, '是否开启注册用户功能（true开启，false关闭）');
    23. 

  23. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (11, '000000', 'OSS预览列表资源开关', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, '2025-08-23 21:51:26', null, null, 'true:开启, false:关闭');
    24. 

  24. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959256836772753409, '889144', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 103, 1, '2025-08-23 22:10:06', 1, '2025-08-23 22:10:06', '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
    25. 

  25. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959256836776947713, '889144', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 103, 1, '2025-08-23 22:10:06', 1, '2025-08-23 22:10:06', '初始化密码 123456');
    26. 

  26. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959256836781142017, '889144', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, '2025-08-23 22:10:06', 1, '2025-08-23 22:10:06', '深色主题theme-dark，浅色主题theme-light');
    27. 

  27. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959256836781142018, '889144', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 103, 1, '2025-08-23 22:10:06', 1, '2025-08-23 22:10:06', '是否开启注册用户功能（true开启，false关闭）');
    28. 

  28. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959256836781142019, '889144', 'OSS预览列表资源开关', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, '2025-08-23 22:10:06', 1, '2025-08-23 22:10:06', 'true:开启, false:关闭');
    29. 

  29. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959976408306454529, '841063', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 103, 1, '2025-08-25 21:49:25', 1, '2025-08-25 21:49:25', '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
    30. 

  30. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959976408310648833, '841063', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 103, 1, '2025-08-25 21:49:25', 1, '2025-08-25 21:49:25', '初始化密码 123456');
    31. 

  31. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959976408310648834, '841063', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, '2025-08-25 21:49:25', 1, '2025-08-25 21:49:25', '深色主题theme-dark，浅色主题theme-light');
    32. 

  32. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959976408310648835, '841063', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 103, 1, '2025-08-25 21:49:25', 1, '2025-08-25 21:49:25', '是否开启注册用户功能（true开启，false关闭）');
    33. 

  33. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959976408310648836, '841063', 'OSS预览列表资源开关', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, '2025-08-25 21:49:25', 1, '2025-08-25 21:49:25', 'true:开启, false:关闭');
    34. 

  34. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1960316478414721026, '938163', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 103, 1, '2025-08-26 20:20:44', 1, '2025-08-26 20:20:44', '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
    35. 

  35. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1960316478418915330, '938163', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 103, 1, '2025-08-26 20:20:44', 1, '2025-08-26 20:20:44', '初始化密码 123456');
    36. 

  36. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1960316478418915331, '938163', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, '2025-08-26 20:20:44', 1, '2025-08-26 20:20:44', '深色主题theme-dark，浅色主题theme-light');
    37. 

  37. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1960316478418915332, '938163', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 103, 1, '2025-08-26 20:20:44', 1, '2025-08-26 20:20:44', '是否开启注册用户功能（true开启，false关闭）');
    38. 

  38. INSERT INTO ruoyi.sys_config (config_id, tenant_id, config_name, config_key, config_value, config_type, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1960316478418915333, '938163', 'OSS预览列表资源开关', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, '2025-08-26 20:20:44', 1, '2025-08-26 20:20:44', 'true:开启, false:关闭');
    39.