短信正式环境升级脚本

1.表的修改

ALTER TABLE yurun_common.sms_stat ADD sms_content VARCHAR(1024) NULL
COMMENT '短信内容'; 
ALTER TABLE yurun_common.sms_stat ADD sms_result CHAR(1) NULL
COMMENT '短信发送结果'; 
ALTER TABLE yurun_common.sms_stat MODIFY COLUMN sms_type CHAR(1)
COMMENT '短信类型 1-验证码2-访客邀请,短信通知';

2.表新增

CREATE TABLE sms_config(
    id INT NOT NULL AUTO_INCREMENT  COMMENT 'id' ,
    project VARCHAR(32)    COMMENT '项目标识' ,
    access_id VARCHAR(32)    COMMENT '短信AccessKeyId' ,
    access_secret VARCHAR(32)    COMMENT '短信AccessKeySecret' ,
    sign VARCHAR(32)    COMMENT '短信签名' ,
    captcha_template VARCHAR(32)    COMMENT '验证码短信模板' ,
    PRIMARY KEY (id)
) COMMENT = '短信配置信息表 ';
INSERT INTO `yurun_common`.`sms_config`(`id`, `project`, `access_id`, `access_secret`, `sign`, `captcha_template`) VALUES (1, 'visitor', 'LTAI4FtdNZN8vkxgxMZ8iYLw', 'Bncqhy1zPVcZUYPFVULAZZXpmCMACr', '雨润集团', 'SMS_175240434');
INSERT INTO `yurun_common`.`sms_config`(`id`, `project`, `access_id`, `access_secret`, `sign`, `captcha_template`) VALUES (2, 'si', 'LTAI4FtdNZN8vkxgxMZ8iYLw', 'Bncqhy1zPVcZUYPFVULAZZXpmCMACr', '雨润集团', 'SMS_175240434');
INSERT INTO `yurun_common`.`sms_config`(`id`, `project`, `access_id`, `access_secret`, `sign`, `captcha_template`) VALUES (3, 'im', 'LTAI4FtdNZN8vkxgxMZ8iYLw', 'Bncqhy1zPVcZUYPFVULAZZXpmCMACr', '雨润集团', 'SMS_175240434');
INSERT INTO `yurun_common`.`sms_config`(`id`, `project`, `access_id`, `access_secret`, `sign`, `captcha_template`) VALUES (4, 'x6', 'LTAI4FtdNZN8vkxgxMZ8iYLw', 'Bncqhy1zPVcZUYPFVULAZZXpmCMACr', '雨润集团', 'SMS_175240434');