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

ALTER TABLE pet_system.sys_service ADD COLUMN introduction text COMMENT '服务介绍';
ALTER TABLE pet_system.sys_service ADD COLUMN order_instruction text COMMENT '下单须知';

-- 菜单 SQL
insert into pet_system.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(2037451324848697345, '服务分类', '2020736413590941698', '1', 'classification', 'service/classification/index', 1, 0, 'C', '0', '0', 'service:classification:list', '#', 103, 1, sysdate(), null, null, '服务分类菜单', 0);

-- 按钮 SQL
insert into pet_system.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(2037451324848697346, '服务分类修改', 2037451324848697345, '1',  '#', '', 1, 0, 'F', '0', '0', 'service:classification:edit',        '#', 103, 1, sysdate(), null, null, '', 0);

insert into pet_system.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(2037451324848697347, '服务分类新增', 2037451324848697345, '2',  '#', '', 1, 0, 'F', '0', '0', 'service:classification:add',          '#', 103, 1, sysdate(), null, null, '', 0);

insert into pet_system.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(2037451324848697349, '服务分类删除', 2037451324848697345, '3',  '#', '', 1, 0, 'F', '0', '0', 'service:classification:remove',       '#', 103, 1, sysdate(), null, null, '', 0);

ALTER TABLE pet_system.sys_service ADD COLUMN classification_id bigint COMMENT '所属分类ID';

UPDATE pet_system.sys_menu SET parent_id = 2020736413590941698, menu_name = '服务列表', order_num = 2, path = 'list', component = 'service/list/index', is_frame = '1', is_cache = '0', menu_type = 'C', visible = '0', status = '0', perms = 'service:list:list', icon = 'service-list', remark = '服务列表菜单', platform_id = 0, create_dept = 103, create_time = '2026-02-25 13:44:44', update_by = 1, update_time = '2026-03-27 17:55:14' WHERE menu_id = 2026533580326912001

INSERT INTO pet_system.sys_agreement(id, title, content)
VALUES (4, '托运协议', '托运协议');

ALTER TABLE pet_system.sys_service ADD COLUMN price bigint COMMENT '订单服务费';

ALTER TABLE pet_system.sys_sub_order ADD COLUMN order_commission bigint COMMENT '订单佣金';
ALTER TABLE pet_system.sys_sub_order CHANGE price fulfillment_commission bigint COMMENT '履约佣金';

ALTER TABLE pet_system.sys_sub_order ADD COLUMN service_flag boolean DEFAULT true COMMENT '是否可以服务';

INSERT INTO pet_system.sys_agreement(id, title, content)
VALUES (5, '宠物洗护服务规范', '');

-- 首页轮播图配置（存储OSS文件ID，多个用逗号分隔） @Author: Antigravity
ALTER TABLE pet_system.sys_app_setting ADD COLUMN home_banner varchar(500) DEFAULT NULL COMMENT '首页轮播图OSS ID，多个用逗号分隔';

-- 插入好萌友(ID=2)的应用配置基础数据 @Author: Antigravity
INSERT INTO pet_system.sys_app_setting (id)
VALUES (2);

-- 插入好萌友(ID=2)的客服配置基础数据 @Author: Antigravity
INSERT INTO pet_system.sys_customer_service_setting (id, wechat_account, phone_number, start_service_time, end_service_time, qr_code, enterprise_wechat_link)
VALUES (2, NULL, NULL, '09:00:00', '18:00:00', NULL, NULL);

-- 投诉/评价表增加字段 @Author: Antigravity
ALTER TABLE pet_system.flf_complaint_log ADD COLUMN photos varchar(500) COMMENT '评价图片ID，多个用逗号分隔';
ALTER TABLE pet_system.flf_complaint_log ADD COLUMN praise_flag boolean DEFAULT false COMMENT '是否好评(true:好评, false:差评/投诉)';