From 0acd500f0a2e2e34ff199472dd5575723afb6358 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 27 九月 2026 17:48:04 +0800
Subject: [PATCH] fix(汇总表母版): 157 格文本型数字改为数值(公交 AF/M 各68 + G 17、轨道轮渡 4)；重新生成验证仅 68 格类型变化、值不变。并记录排名页块顺序/辅助列定位

---
 deploy-templates/db/sql_wyc.sql |   45 +++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 45 insertions(+), 0 deletions(-)

diff --git a/deploy-templates/db/sql_wyc.sql b/deploy-templates/db/sql_wyc.sql
new file mode 100644
index 0000000..2a1ee6b
--- /dev/null
+++ b/deploy-templates/db/sql_wyc.sql
@@ -0,0 +1,45 @@
+-- 鍩庡競瀹㈣繍缃戠害杞︽湀搴﹁緭鍏ュ缓琛紙2026-09-04锛�
+-- 鏁版嵁婧�1锛氭ā鏉縚缃戠害杞︽�绘暟.xlsx锛堟湀搴﹀叏鐪� pin锛氬杩愰噺/鍏朵腑鍩庡競鍐�/鍛ㄨ浆閲�/鍏朵腑鍩庡競鍐呭懆杞噺锛�
+-- 鏁版嵁婧�2锛氭ā鏉縚缃戠害杞﹁鍗曞強鍏ㄧ渷鎬婚噺.xlsx锛堟湀搴﹁緭鍏ラ〉锛欱-E 鍏ㄧ渷 pin + F 璁㈠崟鍚堣 + G-W 17甯傚窞璁㈠崟锛�
+
+CREATE TABLE IF NOT EXISTS wyc_total_monthly (
+  id BIGINT NOT NULL AUTO_INCREMENT,
+  report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� yyyy-MM',
+  pin_k DOUBLE DEFAULT NULL COMMENT '鍏ㄧ渷缃戠害杞﹀杩愰噺(涓囦汉娆�)',
+  pin_ck DOUBLE DEFAULT NULL COMMENT '鍏朵腑鍩庡競鍐呭杩愰噺',
+  pin_z DOUBLE DEFAULT NULL COMMENT '鍏ㄧ渷瀹㈣繍鍛ㄨ浆閲�(涓囦汉鍏噷)',
+  pin_cz DOUBLE DEFAULT NULL COMMENT '鍏朵腑鍩庡競鍐呭懆杞噺',
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  PRIMARY KEY (id),
+  UNIQUE KEY uk_wyc_total_period (report_period)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='缃戠害杞︽湀搴﹀叏鐪� pin 杈撳叆';
+
+CREATE TABLE IF NOT EXISTS wyc_order_monthly (
+  id BIGINT NOT NULL AUTO_INCREMENT,
+  report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� yyyy-MM',
+  pin_k DOUBLE DEFAULT NULL,
+  pin_ck DOUBLE DEFAULT NULL,
+  pin_z DOUBLE DEFAULT NULL,
+  pin_cz DOUBLE DEFAULT NULL,
+  order_sum DOUBLE DEFAULT NULL COMMENT '璁㈠崟鍚堣锛堝崟锛�',
+  order_wuhan DOUBLE DEFAULT NULL,
+  order_huangshi DOUBLE DEFAULT NULL,
+  order_shiyan DOUBLE DEFAULT NULL,
+  order_yichang DOUBLE DEFAULT NULL,
+  order_xiangyang DOUBLE DEFAULT NULL,
+  order_ezhou DOUBLE DEFAULT NULL,
+  order_jingmen DOUBLE DEFAULT NULL,
+  order_xiaogan DOUBLE DEFAULT NULL,
+  order_jingzhou DOUBLE DEFAULT NULL,
+  order_huanggang DOUBLE DEFAULT NULL,
+  order_xianning DOUBLE DEFAULT NULL,
+  order_suizhou DOUBLE DEFAULT NULL,
+  order_enshi DOUBLE DEFAULT NULL,
+  order_xiantao DOUBLE DEFAULT NULL,
+  order_qianjiang DOUBLE DEFAULT NULL,
+  order_tianmen DOUBLE DEFAULT NULL,
+  order_shennong DOUBLE DEFAULT NULL,
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  PRIMARY KEY (id),
+  UNIQUE KEY uk_wyc_order_period (report_period)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='缃戠害杞﹁鍗曞強鍏ㄧ渷鎬婚噺鏈堝害杈撳叆';

--
Gitblit v1.9.1