2020-028-zzy-001.sql 3.2 KB

1234567
  1. use dcp;
  2. UPDATE `dcp`.`sys_push_template_info` SET `template_name` = '[能联全球]能联全球操作验证码', `template_key` = '000037', `template_title` = '[能联全球]能联全球操作验证码', `template_title_EN` = '[WEI] - Email verification code', `template_content` = '尊敬的用户,您好! \n 欢迎您使用能联全球!您本次操作的邮箱验证码为:{验证码} 验证码有效期为10分钟!\n==========================\n提醒:本邮件为系统自动发出,请勿回复!\n==========================', `template_content_EN` = 'Here is the verification code :{验证码}\nIt expires in 10 minutes. \n\nThis is an automated email; if you did not authorize this action, then please change your password. For more information, please visit WEI Support.', `template_param` = '', `push_task_type` = '', `push_task_type_dict` = '', `language` = '', `language_dict` = '', `information_level` = '', `information_level_dict` = '1', `template_type` = '通用', `template_type_dict` = 'TEMPLATE_TYPE_CURRENCY', `template_function_type_dict` = 'OTHER_CURRENCY_VERIFICATION_CODE', `create_by` = '1', `business_type` = '其他', `business_type_dict` = 'OTHER_CURRENCY', `template_function_type` = '验证码', `create_date` = '2020-10-10 11:22:46', `update_by` = '1', `update_date` = '2020-12-28 10:51:20' WHERE `id` = 'de32baec0aa711eb89a48cec4b8bb500';
  3. INSERT INTO `dcp`.`sys_push_template_info`(`id`, `template_name`, `template_key`, `template_title`, `template_title_EN`, `template_content`, `template_content_EN`, `template_param`, `push_task_type`, `push_task_type_dict`, `language`, `language_dict`, `information_level`, `information_level_dict`, `template_type`, `template_type_dict`, `template_function_type_dict`, `create_by`, `business_type`, `business_type_dict`, `template_function_type`, `create_date`, `update_by`, `update_date`) VALUES ('679dafc3465e11eb83f98cec4b79dd1c', '[能联全球]能联全球操作验证码', '000035', '[能联全球]能联全球操作验证码', '[WEI] - Email verification code', '尊敬的用户,您好! \n 欢迎您使用能联全球!您本次操作的邮箱验证码为:{验证码} 验证码有效期为10分钟!\n==========================\n注册地址:https://www.geidcp.com/#/Register\n提醒:本邮件为系统自动发出,请勿回复!\n==========================', 'Here is the verification code :{验证码}\nIt expires in 10 minutes. \n\n Registered Address :https://www.geidcp.com/#/Register\nThis is an automated email; if you did not authorize this action, then please change your password. For more information, please visit WEI Support.', '', '', '', '', '', '', '1', '通用', 'TEMPLATE_TYPE_CURRENCY', 'OTHER_CURRENCY_VERIFICATION_CODE', '1', '其他', 'OTHER_CURRENCY', '验证码', '2020-12-25 11:08:04', '1', '2020-12-28 10:26:40');
  4. UPDATE `dcp`.`sys_parameter` SET `PARAMETER_VALUE` = '能联全球' WHERE `PARAMETER_ID` = 162;
  5. INSERT INTO `dcp`.`sys_parameter`(`PARAMETER_ID`, `PARAMETER_NAME`, `PARAMETER_TYPE`, `PARAMETER_VALUE`, `PARAMETER_ORDER`, `PARAMETER_DESCRIPTION`, `PARAMETER_REMARK`, `CREATE_USER_ID`, `CREATE_TIME`, `UPDATE_USER_ID`, `UPDATE_TIME`) VALUES (200, 'SMS_APP_SIGN_EN', NULL, 'WEI', NULL, NULL, NULL, 1, '2020-12-24 14:41:52', 1, '2020-12-24 14:41:56');
  6. /*已操作161,159*/