java-bbc/db/2025-06-24 门店端添加消息管理.sql

USE `yami_bbc`;
alter table tz_notify_log add column station_id bigint(20) DEFAULT 0 NULL COMMENT '选择发送的门店id（0为店铺）' AFTER shop_id;
alter table tz_notify_template_remind add column station_id BIGINT(20) default 0 null comment '门店id（0为店铺）' after shop_id;
insert into tz_shop_menu (menu_id,parent_id,url,perms,type,icon,order_num,hidden,sys_type) VALUES (1476,1016,'sys/message-manager/notify-manager/index','',1,'',3,0,3),
                                                                                                  (1477,1476,'','shop:notifyTemplateRemind:page',2,'',0,0,3),
                                                                                                  (1478,1476,'','shop:notifyTemplateRemind:update',2,'',0,0,3),
                                                                                                  (1479,1476,'','shop:notifyLog:page',2,'',0,0,3),
                                                                                                  (1480,1476,'','shop:notifyLog:count',2,'',0,0,3);
insert into tz_shop_menu_lang (menu_id,lang,name) values (1476,0,'消息管理'),(1476,1,'Message Management'),
                                                        (1477,0,'查询'),(1477,1,'query'),
                                                      (1478,0,'更新'),(1478,1,'update'),
                                                      (1479,0,'查询'),(1479,1,'query'),
                                                      (1780,0,'统计'),(1780,1,'count');