1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
| -- 启用登录验证码
| UPDATE `sys_config`
| SET `config_value` = 'true',
| `update_by` = 'admin',
| `update_time` = NOW(),
| `remark` = '登录验证码开关'
| WHERE `config_key` = 'sys.account.captchaEnabled';
|
| INSERT INTO `sys_config` (
| `config_name`,
| `config_key`,
| `config_value`,
| `config_type`,
| `create_by`,
| `create_time`,
| `remark`
| )
| SELECT
| '账号验证码开关',
| 'sys.account.captchaEnabled',
| 'true',
| 'Y',
| 'admin',
| NOW(),
| '登录验证码开关'
| WHERE NOT EXISTS (
| SELECT 1 FROM `sys_config` WHERE `config_key` = 'sys.account.captchaEnabled'
| );
|
|