| 12345678910111213141516171819202122232425262728 |
- DROP TABLE IF EXISTS `goods_export`;
- CREATE TABLE `goods_export` (
- export_id int NOT NULL AUTO_INCREMENT,
- `condition` varchar(2000) NOT NULL DEFAULT '' COMMENT '条件 json',
- status int NOT NULL DEFAULT 0 COMMENT '导出状态 0 正在导出 1 已导出 2 已删除',
- create_time int NOT NULL DEFAULT 0 COMMENT '导出时间',
- path varchar(255) NOT NULL DEFAULT '' COMMENT '导出文件的物理路径',
- site_id int NOT NULL DEFAULT 0 COMMENT '站点id',
- PRIMARY KEY (export_id)
- )
- ENGINE = INNODB,
- CHARACTER SET utf8,
- COLLATE utf8_general_ci,
- COMMENT = '商品导出记录表';
- INSERT INTO `adv_position` (site_id,ap_name,ap_intro,ap_height,ap_width,default_content,ap_background_color,type,keyword,is_system,state)
- values(1, '品牌专区', '品牌', 0, 0, '', '#ffffff', 2, 'NS_BRAND', 0, 1);
- ALTER TABLE `message` ADD COLUMN aliapp_template_id varchar(1000) NOT NULL DEFAULT '' COMMENT '支付宝小程序配置参数';
- UPDATE `message_template` nmt SET nmt.support_type = 'sms,wechat,weapp,aliapp', nmt.aliapp_json = '{"lib_code": "TM541decbd2ebe4538abeb2db523201e19", "keyword_list": [{"name": "状态"},{"name": "下单时间"},{"name": "订单详情"},{"name": "订单金额"}], "content": "状态: 已支付\\n下单时间: 2023-04-12 14:30:15\\n订单详情: 京彩莲门帘透明空调....\\n订单金额: ￥50.00","scene_rule": "one_time_subscribe"}' WHERE nmt.keywords = 'ORDER_PAY';
- DELETE FROM `message_template` WHERE keywords='CASHIER_MEMBER_VERIFY_CODE';
- INSERT INTO `message_template` (addon,keywords,title,message_type,message_json,support_type,remark) VALUES
- ('cashier', 'CASHIER_MEMBER_VERIFY_CODE', '收银台会员验证', 1, '{"code":"验证码"}', 'sms', '收银台进行会员验证时发送');
|
