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';