-- 码鼎环保门禁系统(10.136.62.71)库结构补齐补丁 -- 现象1:接口 404 —— /environmentAccess/inspection/page、/environmentAccess/vehicle/page -- 原因:后端 jar 为旧版,缺 com.ruoyi.envaccess 整个包 → 换 ruoyi-mis.jar(4d26cab9…) 解决 -- 现象2:换包后报 -- java.sql.SQLSyntaxErrorException: Unknown column 'business_id' in 'field list' -- The error may exist in com/ruoyi/approve/mapper/ApproveProcessMapper.java -- 原因:库表结构落后于实体(MyBatis-Plus 生成 SELECT 带出实体全部列) -- 执行库:mis-ruoyi @10.136.62.71(列定义取自芯导环保 10.136.58.73 同名库) -- 执行时间:2026-10-23 -- 执行结果:11 张表全部补齐,与标准库 0 差异 -- 1. 审批流程(本次报错来源) ALTER TABLE approve_process ADD COLUMN business_id bigint NULL COMMENT '业务id', ADD COLUMN business_no varchar(255) NULL COMMENT '业务编号', ADD COLUMN business_title varchar(255) NULL COMMENT '业务标题', ADD COLUMN amount decimal(18,2) NULL COMMENT '金额', ADD COLUMN business_data text NULL COMMENT '业务数据', ADD COLUMN flow_definition_id bigint NULL COMMENT '流程定义id', ADD COLUMN update_time datetime NULL COMMENT '更新时间'; -- 2. 审批节点 ALTER TABLE approve_node ADD COLUMN approve_node_name varchar(255) NULL, ADD COLUMN condition_field varchar(255) NULL, ADD COLUMN condition_operator varchar(255) NULL, ADD COLUMN condition_value varchar(1000) NULL, ADD COLUMN is_current int NULL; -- 3. 审批日志 ALTER TABLE approve_log ADD COLUMN approve_node_id bigint NULL, ADD COLUMN approve_process_id bigint NULL, ADD COLUMN approve_user_name varchar(255) NULL, ADD COLUMN tenant_id bigint NULL; -- 4. 员工个人联系人 ALTER TABLE staff_contacts_personal ADD COLUMN user_id int NULL; -- 5. 售后服务 ALTER TABLE after_sales_service ADD COLUMN status_name varchar(255) NULL; -- 6. 设备维护 ALTER TABLE device_maintenance ADD COLUMN maintenance_cycle varchar(255) NULL, ADD COLUMN maintenance_content varchar(1000) NULL; -- 7. 采购出库 ALTER TABLE procurement_record_out ADD COLUMN supplier_name varchar(255) NULL, ADD COLUMN type int NULL, ADD COLUMN requisition_num decimal(18,2) NULL; -- 8. 采购入库 ALTER TABLE procurement_record_storage ADD COLUMN min_stock decimal(18,2) NULL, ADD COLUMN total_price decimal(18,2) NULL, ADD COLUMN unit_price decimal(18,2) NULL, ADD COLUMN registrant varchar(255) NULL; -- 9. 销售台账排产 ALTER TABLE sales_ledger_scheduling ADD COLUMN completion_deadline date NULL, ADD COLUMN production_requirement varchar(255) NULL; -- 10. 供应商管理 ALTER TABLE supplier_manage ADD COLUMN supplier_code varchar(255) NULL, ADD COLUMN supplier_short_name varchar(255) NULL, ADD COLUMN supplier_category varchar(255) NULL, ADD COLUMN supplier_level varchar(255) NULL, ADD COLUMN qualification_status int NULL, ADD COLUMN qualification_expiry_date date NULL, ADD COLUMN cooperation_status int NULL, ADD COLUMN cooperation_start_date date NULL, ADD COLUMN cooperation_history_summary varchar(1000) NULL, ADD COLUMN supplied_products_summary varchar(1000) NULL, ADD COLUMN remark varchar(1000) NULL, ADD COLUMN delete_flag int NULL; -- 11. 开票登记 ALTER TABLE ticket_registration ADD COLUMN invoice_code varchar(255) NULL, ADD COLUMN invoice_type varchar(255) NULL, ADD COLUMN invoice_status int NULL, ADD COLUMN tax_rate decimal(18,2) NULL, ADD COLUMN tax_amount decimal(18,2) NULL, ADD COLUMN currency varchar(255) NULL, ADD COLUMN supplier_id bigint NULL, ADD COLUMN sales_contract_no_id bigint NULL, ADD COLUMN verification_status int NULL, ADD COLUMN file_name varchar(1000) NULL, ADD COLUMN remark varchar(1000) NULL, ADD COLUMN delete_flag int NULL, ADD COLUMN create_user bigint NULL, ADD COLUMN update_user bigint NULL, ADD COLUMN update_time datetime NULL;