69 lines
7.6 KiB
SQL
69 lines
7.6 KiB
SQL
|
||
truncate table T_SMS_TEMPLATE;
|
||
|
||
-- 短信模板初始化
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (1, '每日业绩', '尊敬的董事长您好！今日A=%s，B=%s，C=%s，D=%s，合计=%s', 'SMS-1', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 5);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (2, '结算安置问题', '%s结算错误，安置有问题', 'SMS-2', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 1);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (10, '验证码', '您的验证码为%s，请在10分钟内使用。', 'SMS-10', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 1);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (11, '会员注册成功', '尊敬的%s您好！恭喜您注册成功，您的会员编号是%s，请及时登陆并修改初始密码。详情咨询400-111-2818', 'SMS-11', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 2);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (12, '忘记密码', '验证码%s，您正在尝试修改登录密码，请妥善保管账户信息。', 'SMS-12', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 1);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (13, '订单发货', '尊敬的%s您好，你的快递单号为%s，的%s已发货，请注意查收。', 'SMS-13', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 3);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (15, '库存预警', '%s的产品库存不足，%s请注及时补仓。', 'SMS-15', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 2);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (17, '余额核对', '用户编号为%s余额计算有误,请及时核对。', 'SMS-17', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 1);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (18, '沙棘提货提醒', '尊敬的会员，您购买的沙棘果汁礼包提货卡已经发放到账户中，请在本月5日前登录会员平台提货，超时将无法提货！', 'SMS-18', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 0);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (21, '售后收货', '尊敬的会员，现已收到您寄来的售后产品，检测时间大约在3到5个工作日，请您耐心等待！', 'SMS-21', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 0);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (22, '售后换新', '尊敬的会员，您的售后产品已检测完毕，给您换新处理，寄出快递单号:%s，请查收!', 'SMS-22', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 1);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (23, '售后原件', '尊敬的会员，您的售后产品已检测完毕，给您原件寄回，寄出快递单号:%s，请查收!', 'SMS-23', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 1);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (24, '售后换件', '尊敬的会员，您的售后产品已检测完毕，给您更换配件并原件寄回，寄出快递单号:%s，请查收!', 'SMS-24', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 1);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (25, '产品补发', '尊敬的会员，您的售后问题已核实，给您补发产品，寄出快递单号:%s，请查收!', 'SMS-25', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 1);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (26, '售后受理', '尊敬的会员，您的售后问题已受理，需要与您核实相关信息，请注意接听电话或致电4001112818!', 'SMS-26', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 0);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (27, '疫情延迟补发', '由于疫情原因，您订购的产品，快递不能正常发出，我们的物流每天都会尝试补发，疫情解除限制后，会第一时间安排订单发货，请您耐心等待。如有任何问题，请您致电4001112818进行咨询。', 'SMS-27', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 0);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (28, '疫情延迟发货', '您好，受疫情影响您的售后产品将延迟发出，此间会一直为您尝试发货，发出后运单号会以短信的形式发送给您，请注意查收信息，感谢谅解。', 'SMS-28', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 0);
|
||
|
||
insert into T_SMS_TEMPLATE (PK_ID, TEMPLATE_NAME, TEMPLATE_CONTENT, TEMPLATE_CODE, DEL_FLAG, CREATION_TIME, MODIFIED_TIME, PK_COUNTRY, PK_CREATOR, PK_MODIFIED, ENABLE, PARAM_NUM)
|
||
values (29, '售后快速处理', '尊敬的会员！您的售后产品已快速处理，请您及时寄回售后产品，此为发出新机的快递单号%s，请查收！', 'SMS-29', 0, to_date('01-03-2023 01:00:00', 'dd-mm-yyyy hh24:mi:ss'), null, 1, 1, null, 0, 1);
|
||
|
||
-- 删除序列
|
||
drop SEQUENCE T_SMS_TEMPLATE_SEQ;
|
||
|
||
-- 创建序列
|
||
create sequence T_SMS_TEMPLATE_SEQ
|
||
minvalue 1
|
||
maxvalue 999999999
|
||
start with 30
|
||
increment by 1
|
||
cache 10;
|