

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', '收银台进行会员验证时发送');
