/** 表名前缀请根据实际安装环境调整。以下语句可重复执行。 **/
INSERT INTO `sc_config` (`value`, `name`, `describe`, `error_tips`, `type`, `only_tag`, `upd_time`)
SELECT '', '互亿无线APIID', '互亿无线短信接口账号', '请输入互亿无线APIID', 'home', 'common_sms_username', UNIX_TIMESTAMP()
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM `sc_config` WHERE `only_tag` = 'common_sms_username');

INSERT INTO `sc_config` (`value`, `name`, `describe`, `error_tips`, `type`, `only_tag`, `upd_time`)
SELECT '', '互亿无线APIKEY', '互亿无线短信接口密钥', '请输入互亿无线APIKEY', 'home', 'common_sms_apikey', UNIX_TIMESTAMP()
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM `sc_config` WHERE `only_tag` = 'common_sms_apikey');

UPDATE `sc_config`
SET `name` = '互亿无线APIID', `describe` = '互亿无线短信接口账号', `error_tips` = '请输入互亿无线APIID', `upd_time` = UNIX_TIMESTAMP()
WHERE `only_tag` = 'common_sms_username';

UPDATE `sc_config`
SET `name` = '互亿无线APIKEY', `describe` = '互亿无线短信接口密钥', `error_tips` = '请输入互亿无线APIKEY', `upd_time` = UNIX_TIMESTAMP()
WHERE `only_tag` = 'common_sms_apikey';

DELETE FROM `sc_config` WHERE `only_tag` = 'common_sms_sign';
