pet-system/script/sql/business/update.sql

# 2026/02/10
ALTER TABLE `pet_system`.`sys_menu` ADD COLUMN `platform_id` tinyint NOT NULL COMMENT '平台ID';
ALTER TABLE `pet_system`.`sys_user` ADD COLUMN `platform_id` tinyint NOT NULL COMMENT '平台ID';

# 2026/02/11
-- 菜单 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2021464069248733185, '商户分类', '6', '1', 'tenantCategories', 'system/tenantCategories/index', 1, 0, 'C', '0', '0', 'system:tenantCategories:list', '#', 103, 1, sysdate(), null, null, '商户分类菜单', 0);

-- 按钮 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2021464069248733186, '商户分类查询', 2021464069248733185, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:tenantCategories:query',        '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2021464069248733187, '商户分类新增', 2021464069248733185, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:tenantCategories:add',          '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2021464069248733188, '商户分类修改', 2021464069248733185, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:tenantCategories:edit',         '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2021464069248733189, '商户分类删除', 2021464069248733185, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:tenantCategories:remove',       '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2021464069248733190, '商户分类导出', 2021464069248733185, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:tenantCategories:export',       '#', 103, 1, sysdate(), null, null, '', 0);

ALTER TABLE `pet_system`.`sys_tenant` ADD COLUMN `logo` bigint COMMENT '品牌LOGO';

ALTER TABLE `pet_system`.`sys_tenant` ADD COLUMN `admin` bigint NOT NULL COMMENT '管理员';
ALTER TABLE `pet_system`.`sys_role` ADD COLUMN `platform_id` tinyint NOT NULL COMMENT '平台ID';

# 2026/02/24
-- 菜单 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026190519642099713, '门店管理', '6', '1', 'store', 'system/store/index', 1, 0, 'C', '0', '0', 'system:store:list', '#', 103, 1, sysdate(), null, null, '门店管理菜单', 0);

-- 按钮 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026190519642099714, '门店管理查询', 2026190519642099713, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:store:query',        '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026190519642099715, '门店管理新增', 2026190519642099713, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:store:add',          '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026190519642099716, '门店管理修改', 2026190519642099713, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:store:edit',         '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026190519642099717, '门店管理删除', 2026190519642099713, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:store:remove',       '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026190519642099718, '门店管理导出', 2026190519642099713, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:store:export',       '#', 103, 1, sysdate(), null, null, '', 0);

ALTER TABLE `pet_system`.`sys_dept` ADD COLUMN `platform_id` tinyint NOT NULL COMMENT '平台ID';
ALTER TABLE `pet_system`.`sys_post` ADD COLUMN `platform_id` tinyint NOT NULL COMMENT '平台ID';

# 2026/02/25
-- 菜单 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026533580326912001, '服务列表', '2020736413590941698', '1', 'list', 'service/list/index', 1, 0, 'C', '0', '0', 'service:list:list', '#', 103, 1, sysdate(), null, null, '服务列表菜单', 0);

-- 按钮 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026533580326912002, '服务列表查询', 2026533580326912001, '1',  '#', '', 1, 0, 'F', '0', '0', 'service:list:query',        '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026533580326912003, '服务列表新增', 2026533580326912001, '2',  '#', '', 1, 0, 'F', '0', '0', 'service:list:add',          '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026533580326912004, '服务列表修改', 2026533580326912001, '3',  '#', '', 1, 0, 'F', '0', '0', 'service:list:edit',         '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026533580326912005, '服务列表删除', 2026533580326912001, '4',  '#', '', 1, 0, 'F', '0', '0', 'service:list:remove',       '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026533580326912006, '服务列表导出', 2026533580326912001, '5',  '#', '', 1, 0, 'F', '0', '0', 'service:list:export',       '#', 103, 1, sysdate(), null, null, '', 0);

-- 菜单 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2021464069248733192, '商户分类', '6', '12', 'tenantCategories', 'system/tenantCategories/index', 1, 0, 'C', '0', '0', 'system:tenantCategories:list', '#', 103, 1, sysdate(), null, null, '商户分类菜单', 0);

-- 按钮 SQL
-- 菜单 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026556930960998402, '区域站点', '1', '1', 'areaStation', 'system/areaStation/index', 1, 0, 'C', '0', '0', 'system:areaStation:list', '#', 103, 1, sysdate(), null, null, '区域站点菜单', 0);

-- 按钮 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026556930960998403, '区域站点查询', 2026556930960998402, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:areaStation:query',        '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026556930960998404, '区域站点新增', 2026556930960998402, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:areaStation:add',          '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026556930960998405, '区域站点修改', 2026556930960998402, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:areaStation:edit',         '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026556930960998406, '区域站点删除', 2026556930960998402, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:areaStation:remove',       '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026556930960998407, '区域站点导出', 2026556930960998402, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:areaStation:export',       '#', 103, 1, sysdate(), null, null, '', 0);

# 2026/02/26
-- 菜单 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026924472514756609, '短信配置', '1', '12', 'smsConfig', 'resource/smsConfig/index', 1, 0, 'C', '0', '0', 'resource:smsConfig:list', '#', 103, 1, sysdate(), null, null, '短信配置菜单', 0);

-- 按钮 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026924472514756610, '短信配置查询', 2026924472514756609, '1',  '#', '', 1, 0, 'F', '0', '0', 'resource:smsConfig:query',        '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026924472514756611, '短信配置新增', 2026924472514756609, '2',  '#', '', 1, 0, 'F', '0', '0', 'resource:smsConfig:add',          '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026924472514756612, '短信配置修改', 2026924472514756609, '3',  '#', '', 1, 0, 'F', '0', '0', 'resource:smsConfig:edit',         '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026924472514756613, '短信配置删除', 2026924472514756609, '4',  '#', '', 1, 0, 'F', '0', '0', 'resource:smsConfig:remove',       '#', 103, 1, sysdate(), null, null, '', 0);

insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_dept, create_by, create_time, update_by, update_time, remark, platform_id)
values(2026924472514756614, '短信配置导出', 2026924472514756609, '5',  '#', '', 1, 0, 'F', '0', '0', 'resource:smsConfig:export',       '#', 103, 1, sysdate(), null, null, '', 0);