#

Junjie

12 小时以前 656429e94f5989911bdf07848ef44b1cc71dfaf1

 src/main/resources/sql/20260313_create_station_path_policy_tables.sql

@@ -4,6 +4,7 @@
  `profile_name` VARCHAR(128) NOT NULL COMMENT '模板名称',
  `priority` INT NOT NULL DEFAULT 100 COMMENT '优先级，越小越优先',
  `status` TINYINT NOT NULL DEFAULT 1 COMMENT '状态 1启用 0禁用',
  `is_default` TINYINT NOT NULL DEFAULT 0 COMMENT '默认模板 1是 0否',
  `config_json` LONGTEXT NULL COMMENT '模板参数JSON',
  `memo` VARCHAR(255) NULL COMMENT '备注',
  `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
@@ -37,22 +38,16 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='输送站点路径人工规则';

INSERT INTO `asr_bas_station_path_profile`
(`profile_code`, `profile_name`, `priority`, `status`, `config_json`, `memo`)
(`profile_code`, `profile_name`, `priority`, `status`, `is_default`, `config_json`, `memo`)
SELECT
  'default',
  '默认模板',
  100,
  1,
  1,
  '{"calcMaxDepth":120,"calcMaxPaths":500,"calcMaxCost":300,"s1TopK":5,"s1LenWeight":1.0,"s1TurnWeight":3.0,"s1LiftWeight":8.0,"s1SoftDeviationWeight":4.0,"s1MaxLenRatio":1.15,"s1MaxTurnDiff":1,"s2BusyWeight":2.0,"s2RunBlockWeight":10.0,"s2LoopLoadWeight":12.0,"stationPathLenWeightPercent":50.0,"stationPathCongWeightPercent":50.0,"stationPathPassOtherOutStationWeightPercent":100.0,"stationPathPassOtherOutStationForceSkip":false}',
  '默认模板'
FROM dual
WHERE NOT EXISTS (
  SELECT 1 FROM `asr_bas_station_path_profile` WHERE `profile_code` = 'default'
);

INSERT INTO `sys_config`(`name`, `code`, `value`, `type`, `status`, `select_type`)
SELECT '站点路径默认模板编码', 'stationPathDefaultProfileCode', 'default', 1, 1, 'system'
FROM dual
WHERE NOT EXISTS (
  SELECT 1 FROM `sys_config` WHERE `code` = 'stationPathDefaultProfileCode'
);