From 94380fab60289fd2be38812fb88a7117a12cb803 Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期一, 31 八月 2026 14:31:48 +0800
Subject: [PATCH] docs: 关机交接快照（08-31）——今日修复/改密已交付、运行状态、待办（重新打包发布、验证码开关、崩溃取证）

---
 docs/init.sql |  236 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 234 insertions(+), 2 deletions(-)

diff --git a/docs/init.sql b/docs/init.sql
index e824b6f..f5b8a64 100644
--- a/docs/init.sql
+++ b/docs/init.sql
@@ -37,6 +37,7 @@
     username VARCHAR(50) NOT NULL UNIQUE,
     password VARCHAR(200) NOT NULL COMMENT 'BCrypt',
     real_name VARCHAR(50),
+    modules VARCHAR(255) DEFAULT NULL COMMENT '璐熻矗鎶ヨ〃妯″潡锛堥�楀彿鍒嗛殧锛�',
     phone VARCHAR(20),
     dept_id BIGINT,
     status TINYINT DEFAULT 1 COMMENT '0绂佺敤 1鍚敤',
@@ -289,7 +290,7 @@
 ('杞﹁締鏁拌繍鏀垮姣�', 'RULE_001', '浼佷笟涓婃姤杞﹁締鏁颁笌杩愭斂鏁版嵁瀵规瘮锛屽樊璺�>5鍙伴渶鏍稿疄', 'vehicleTotal', 'DIFF', '5', 'RED', 'H2032', 1, 1),
 ('鍚ㄤ綅杩愭斂瀵规瘮', 'RULE_002', '浼佷笟涓婃姤鍚ㄤ綅涓庤繍鏀挎暟鎹姣旓紝宸窛>50闇�鏍稿疄', 'tonsTotal', 'DIFF', '50', 'RED', 'H2032', 1, 2),
 ('鍛ㄨ浆閲忚建杩瑰姣�', 'RULE_003', '涓婃姤鍛ㄨ浆閲忎笌杞ㄨ抗娴嬬畻鍛ㄨ浆閲忓姣旓紝楂樺嚭30%闇�鏍稿疄', 'turnoverTotal,trackMileage', 'RATIO', '1.3', 'RED', 'H2032', 1, 3),
-('璐ц繍绫诲瀷鐜瘮', 'RULE_004', '鏈湀鏂板璐ц繍绫诲瀷闇�鏍稿疄', 'freightContainer,freightCoal', 'MOM', '0', 'YELLOW', 'H2032', 1, 4),
+('璐ц繍绫诲瀷鐜瘮', 'RULE_004', '鏈湀鏂板璐ц繍绫诲瀷闇�鏍稿疄锛堜笂鏈堜负0銆佹湰鏈堟湁閲忥級', 'freightContainer,freightCoal,freightOilGas,freightCrudeOil,freightMetalOre,freightIronOre,freightBuilding,freightGrain', 'MOM', '0', 'YELLOW', 'H2032', 1, 4),
 ('闆嗚绠卞紓甯�', 'RULE_005', '鏃犻泦瑁呯杞︿絾鏈夐泦瑁呯璐ц繍閲忛渶鏍稿疄', 'freightContainer,vehicleContainer', 'NULL_CHECK', '0', 'RED', 'H2032', 1, 5),
 ('鏁磋溅鍚ㄤ綅鑼冨洿', 'RULE_006', '鏁磋溅鍚ㄤ綅涓嶅湪4-40鍚ㄤ箣闂�', 'tonsWhole', 'OUT_RANGE', '4,40', 'YELLOW', 'H2032', 1, 6);
 
@@ -382,6 +383,237 @@
 
 -- 棰勭疆绠＄悊鍛樿处鍙� admin / admin123
 INSERT INTO sys_user (username, password, real_name, dept_id) VALUES
-('admin', '.zmdr9k7uOCQb376NoUnuTJ8iAt6Z5EHsM8lE9lBOsl7iAt6Z5Eh', '绯荤粺绠＄悊鍛�', 1);
+('admin', '$2b$10$aqN02Pwvzzuta/66V9MpGerfUH6favtq8av3cc/gueg6lQ9E4CH8u', '绯荤粺绠＄悊鍛�', 1);
 
 INSERT INTO sys_user_role (user_id, role_id) VALUES (1, 1);
+
+
+-- ============================================
+-- 鍏�佸叕璺梾瀹㈣繍杈擄紙浜や紒缁烪203-1锛夋墿灞曟ā鍧�
+-- ============================================
+
+DROP TABLE IF EXISTS h2031_enterprise_monthly;
+CREATE TABLE h2031_enterprise_monthly (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-06',
+    region_code VARCHAR(20) COMMENT '鎵�灞炲湴鍖�',
+    enterprise_code VARCHAR(50) COMMENT '浼佷笟浠ｇ爜',
+    enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+    vehicle_total INT COMMENT '瀹㈣繍杞﹁締_鎬昏',
+    seat_total INT COMMENT '鏍稿畾杞藉浣峗鎬昏',
+    vehicle_schedule INT COMMENT '杞﹁締鏁癬瀹㈣繍鐝溅锛堝惈瀹氱嚎鏃呮父瀹㈣繍瀹㈣溅锛�',
+    seat_schedule INT COMMENT '鏍稿畾杞藉浣峗瀹㈣繍鐝溅锛堝惈瀹氱嚎鏃呮父瀹㈣繍瀹㈣溅锛�',
+    vehicle_charter INT COMMENT '杞﹁締鏁癬瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓稿杩愬杞︼級',
+    seat_charter INT COMMENT '鏍稿畾杞藉浣峗瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓稿杩愬杞︼級',
+    passenger_total DOUBLE COMMENT '瀹㈣繍閲廮鎬昏锛堜汉锛�',
+    turnover_total DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮鎬昏锛堜汉鍏噷锛�',
+    passenger_class1 DOUBLE COMMENT '瀹㈣繍閲廮涓�绫诲杩愮彮绾匡紙鍚畾绾挎梾娓革級',
+    turnover_class1 DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮涓�绫诲杩愮彮绾匡紙鍚畾绾挎梾娓革級',
+    passenger_class2 DOUBLE COMMENT '瀹㈣繍閲廮浜岀被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    turnover_class2 DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮浜岀被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    passenger_class3 DOUBLE COMMENT '瀹㈣繍閲廮涓夌被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    turnover_class3 DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮涓夌被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    passenger_class4 DOUBLE COMMENT '瀹㈣繍閲廮鍥涚被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    turnover_class4 DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮鍥涚被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    passenger_charter DOUBLE COMMENT '瀹㈣繍閲廮瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓革級',
+    turnover_charter DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓革級',
+    avg_distance_total DOUBLE COMMENT '瀹㈣繍骞冲潎杩愯窛锛堝叕閲岋級',
+    avg_distance_class1 DOUBLE COMMENT '涓�绫诲杩愮彮绾垮钩鍧囪繍璺濓紙鍏噷锛�',
+    avg_distance_class2 DOUBLE COMMENT '浜岀被瀹㈣繍鐝嚎骞冲潎杩愯窛锛堝叕閲岋級',
+    avg_distance_class3 DOUBLE COMMENT '涓夌被瀹㈣繍鐝嚎骞冲潎杩愯窛锛堝叕閲岋級',
+    avg_distance_class4 DOUBLE COMMENT '鍥涚被瀹㈣繍鐝嚎骞冲潎杩愯窛锛堝叕閲岋級',
+    avg_distance_charter DOUBLE COMMENT '鏃呮父銆佸寘杞﹀钩鍧囪繍璺濓紙鍏噷锛�',
+    verify_explanation TEXT COMMENT '鏍稿疄鎬у師鍥犺В閲�',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='浜や紒缁烪203-1琛╛鍏矾鏃呭杩愯緭鏈堝害鐢熶骇鎯呭喌';
+
+DROP TABLE IF EXISTS passenger_auth_vehicle;
+CREATE TABLE passenger_auth_vehicle (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) COMMENT '鎶ヨ〃鏈�',
+    enterprise_code VARCHAR(50) COMMENT '浼佷笟浠ｇ爜',
+    enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+    vehicle_count INT DEFAULT 0 COMMENT '杞﹁締鏁�',
+    seat_count INT DEFAULT 0 COMMENT '杞藉浣嶆暟',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鍏矾鏃呭杩愭斂杞﹁締鏁版嵁';
+
+-- H203-1 棰勭疆瀹℃牳瑙勫垯锛�4缁�8鏉★紝report_type=H2031锛�
+INSERT INTO audit_rule (rule_name, rule_code, description, check_field, compare_type, threshold, alert_level, report_type, is_enabled, sort_order) VALUES
+('杞﹁締鏁拌繍鏀垮姣�(鏃呭)', 'RULE_P001', '瀹㈣繍杞﹁締鏁颁笌杩愭斂杞﹁締鏁板姣旓紝宸窛>3鍙伴渶鏍稿疄', 'vehicleTotal', 'DIFF', '3', 'RED', 'H2031', 1, 21),
+('杞藉浣嶆暟杩愭斂瀵规瘮(鏃呭)', 'RULE_P002', '鏍稿畾杞藉浣嶆暟涓庤繍鏀胯浇瀹綅鏁板姣旓紝宸窛>50闇�鏍稿疄', 'seatTotal', 'DIFF', '50', 'RED', 'H2031', 1, 22),
+('瀹㈣繍閲忕幆姣�=0鏍稿疄', 'RULE_P003', '涓�绫�/浜岀被/涓夌被/鍥涚被/鍖呰溅瀹㈣繍閲忕幆姣斾笂涓湀绛変簬0闇�鏍稿疄', 'passengerClass1,passengerClass2,passengerClass3,passengerClass4,passengerCharter', 'MOM_EQ_ZERO', '0', 'YELLOW', 'H2031', 1, 23),
+('鏃呭鍛ㄨ浆閲忕幆姣�=0鏍稿疄', 'RULE_P004', '涓�绫�/浜岀被/涓夌被/鍥涚被/鍖呰溅鏃呭鍛ㄨ浆閲忕幆姣斾笂涓湀绛変簬0闇�鏍稿疄', 'turnoverClass1,turnoverClass2,turnoverClass3,turnoverClass4,turnoverCharter', 'MOM_EQ_ZERO', '0', 'YELLOW', 'H2031', 1, 24),
+('骞冲潎杩愯窛鐜瘮瓒吢�10%鏍稿疄', 'RULE_P005', '涓�绫�/浜岀被/涓夌被/鍥涚被骞冲潎杩愯窛鐜瘮涓婁釜鏈堣秴杩嚶�10%闇�鏍稿疄', 'avgDistanceClass1,avgDistanceClass2,avgDistanceClass3,avgDistanceClass4', 'MOM_PCT', '10', 'YELLOW', 'H2031', 1, 25),
+('鍖呰溅骞冲潎杩愯窛绛変簬涓婃湀鏍稿疄', 'RULE_P006', '鏃呮父鍖呰溅骞冲潎杩愯窛绛変簬涓婁釜鏈堥渶鏍稿疄', 'avgDistanceCharter', 'MOM_EQ', '0', 'YELLOW', 'H2031', 1, 26),
+('鏃犵彮绾挎湁鐝嚎瀹㈣繍閲忔牳瀹�', 'RULE_P007', '鏃犲杩愮彮杞︼紙鐝嚎杞﹁締鏁颁负0锛変絾鏈夌彮绾垮杩愰噺闇�鏍稿疄', 'vehicleSchedule,passengerClass1,passengerClass2,passengerClass3,passengerClass4', 'EXISTENCE', '0', 'RED', 'H2031', 1, 27),
+('鏃犲寘杞︽湁鍖呰溅瀹㈣繍閲忔牳瀹�', 'RULE_P008', '鏃犲杩愬寘杞︼紙鍖呰溅杞﹁締鏁颁负0锛変絾鏈夊寘杞﹀杩愰噺闇�鏍稿疄', 'vehicleCharter,passengerCharter', 'EXISTENCE', '0', 'RED', 'H2031', 1, 28);
+
+
+-- ============================================
+-- 涔濄�侀亾璺揣杩愯兘婧愭秷鑰楋紙浜や紒缁烪204锛夋墿灞曟ā鍧�
+-- ============================================
+
+-- 閬撹矾璐ц繍杞﹁締鑳芥簮娑堣�楁儏鍐碉紙杞﹁締绮掑害瀛ｆ姤锛�
+DROP TABLE IF EXISTS h204_vehicle_quarterly;
+CREATE TABLE h204_vehicle_quarterly (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-06锛堝搴︽湯鏈堬級',
+    region_code VARCHAR(20) COMMENT '鎵�灞炲湴鍖�',
+    enterprise_code VARCHAR(50) COMMENT '浼佷笟浠ｇ爜',
+    enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+    plate_no VARCHAR(30) COMMENT '杞︾墝鍙�',
+    vehicle_type_code VARCHAR(10) COMMENT '杞﹁締绫诲瀷浠ｇ爜',
+    vehicle_type VARCHAR(50) COMMENT '杞﹁締绫诲瀷锛堜腑鏂囷級',
+    fuel_type_code VARCHAR(10) COMMENT '鐕冩枡绫诲瀷浠ｇ爜',
+    fuel_type VARCHAR(50) COMMENT '鐕冩枡绫诲瀷锛堜腑鏂囷級',
+    manufacture_year INT COMMENT '鍑哄巶骞翠唤',
+    marked_tonnage DOUBLE COMMENT '鏍囪鍚ㄤ綅锛堝惃锛�',
+    total_mileage DOUBLE COMMENT '鎬昏绋嬶紙鍏噷锛�',
+    loaded_mileage DOUBLE COMMENT '杞借揣閲岀▼锛堝叕閲岋級',
+    empty_mileage DOUBLE COMMENT '绌洪┒閲岀▼锛堝叕閲岋級',
+    freight DOUBLE COMMENT '璐ц繍閲忥紙鍚級',
+    turnover DOUBLE COMMENT '璐х墿鍛ㄨ浆閲忥紙鍚ㄥ叕閲岋級',
+    trip_count INT COMMENT '瓒熸鏁帮紙涓級',
+    fuel_unit VARCHAR(20) COMMENT '鐕冩枡1璁￠噺鍗曚綅',
+    fuel_consumption DOUBLE COMMENT '鐕冩枡1娑堣�楅噺',
+    avg_distance DOUBLE COMMENT '骞冲潎杩愯窛锛堝叕閲岋級',
+    avg_loaded_tonnage DOUBLE COMMENT '骞冲潎杞借揣鍚ㄤ綅锛堝惃锛�',
+    avg_trip_mileage DOUBLE COMMENT '鍗曡稛骞冲潎閲岀▼锛堝叕閲岋級',
+    fuel_per_100km DOUBLE COMMENT '鐧惧叕閲屽崟鑰�',
+    turnover_fuel DOUBLE COMMENT '鍛ㄨ浆閲忓崟鑰�',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    KEY idx_period_plate (report_period, plate_no),
+    KEY idx_period_ent (report_period, enterprise_code)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='浜や紒缁烪204琛╛閬撹矾璐ц繍杞﹁締鑳芥簮娑堣�楁儏鍐碉紙杞﹁締绮掑害锛�';
+
+-- 閬撹矾璐ц繍鑳借�梍杩愭斂杞﹁締淇℃伅锛堣溅鐗岀矑搴︼級
+DROP TABLE IF EXISTS h204_auth_vehicle;
+CREATE TABLE h204_auth_vehicle (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈�',
+    plate_no VARCHAR(30) NOT NULL COMMENT '杞︾墝鍙�',
+    vehicle_type VARCHAR(50) COMMENT '杞﹁締绫诲瀷',
+    fuel_type VARCHAR(50) COMMENT '鐕冩枡绫诲瀷',
+    marked_tonnage DOUBLE COMMENT '鏍囪鍚ㄤ綅锛堝惃锛�',
+    traction_quality DOUBLE COMMENT '鍑嗙壍寮曡川閲忥紙鐗靛紩杞︽爣璁板惃浣嶏級',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    KEY idx_period_plate (report_period, plate_no)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='閬撹矾璐ц繍鑳借�梍杩愭斂杞﹁締淇℃伅锛堣溅鐗岀矑搴︼級';
+
+-- H204 棰勭疆瀹℃牳瑙勫垯锛�4鏉★紝report_type=H204锛�
+INSERT INTO audit_rule (rule_name, rule_code, description, check_field, compare_type, threshold, alert_level, report_type, is_enabled, sort_order) VALUES
+('杞﹁締绫诲瀷涓庤繍鏀垮姣�', 'RULE_E001', '鑳借�楁槑缁嗚溅杈嗙被鍨嬩笌杩愭斂杞﹁締淇℃伅涓嶄竴鑷撮渶鏍稿疄', 'vehicleType', 'CROSS_DIFF', '0', 'RED', 'H204', 1, 31),
+('鐕冩枡绫诲瀷涓庤繍鏀垮姣�', 'RULE_E002', '鑳借�楁槑缁嗙噧鏂欑被鍨嬩笌杩愭斂杞﹁締淇℃伅涓嶄竴鑷撮渶鏍稿疄', 'fuelType', 'CROSS_DIFF', '0', 'RED', 'H204', 1, 32),
+('鏍囪鍚ㄤ綅涓庤繍鏀垮姣�', 'RULE_E003', '鑳借�楁槑缁嗘爣璁板惃浣嶄笌杩愭斂瀵规瘮锛屽樊璺�>0.05鍚ㄩ渶鏍稿疄锛堢壍寮曡溅瀵规瘮鍑嗙壍寮曡川閲忥級', 'markedTonnage', 'CROSS_DIFF', '0.05', 'YELLOW', 'H204', 1, 33),
+('杩愭斂杞﹁締淇℃伅缂哄け', 'RULE_E004', '鑳借�楁槑缁嗚溅鐗屽彿鍦ㄨ繍鏀胯溅杈嗕俊鎭腑涓嶅瓨鍦ㄩ渶鏍稿疄', 'plateNo', 'EXISTENCE_AUTH', '0', 'RED', 'H204', 1, 34),
+('杞借揣閲岀▼鍗犳瘮涓庡崟瓒熼噷绋嬫瘮鏍稿疄', 'RULE_E005', '杞借揣閲岀▼/鎬昏绋� 涓� 骞冲潎杩愯窛/鍗曡稛骞冲潎閲岀▼ 鐩稿樊卤10%闇�鏍稿疄', 'loadedMileage,totalMileage,avgDistance,avgTripMileage', 'LOADED_RATIO_DIFF', '0.1', 'YELLOW', 'H204', 1, 35),
+('鐧惧叕閲屽崟鑰楄秴鑼冨洿鏍稿疄', 'RULE_E006', '鐧惧叕閲屽崟鑰楀亸绂诲悓鐕冩枡绫诲瀷涓綅鏁拌秴杩�50%闇�鏍稿疄', 'fuelPer100km,fuelTypeCode', 'FUEL_RANGE', '0.5', 'YELLOW', 'H204', 1, 36),
+('鐧惧叕閲屽崟鑰楃幆姣斿彉鍖栨牳瀹�', 'RULE_E007', '鍚屼竴杈嗚溅鐧惧叕閲屽崟鑰楃幆姣斿彉鍖栬秴杩嚶�50%闇�鏍稿疄', 'fuelPer100km,plateNo', 'FUEL_MOM', '0.5', 'YELLOW', 'H204', 1, 37),
+('鑳借�楅噺涓庤揣杩愭湀鎶ュ姣旀牳瀹�', 'RULE_E008', '浼佷笟鑳借�楄揣杩愰噺/鍛ㄨ浆閲忎箣鍜屽ぇ浜庤揣杩愭湀鎶�50%闇�鏍稿疄', 'freight,turnover,enterpriseName', 'FREIGHT_VS_H2032', '0.5', 'RED', 'H204', 1, 38),
+('骞冲潎杩愯窛涓庤揣杩愭湀鎶ュ姣旀牳瀹�', 'RULE_E009', '杞﹁締骞冲潎杩愯窛涓庤揣杩愭湀鎶ュ钩鍧囪繍璺濈浉宸�60%闇�鏍稿疄', 'avgDistance,enterpriseName', 'AVG_DIST_VS_H2032', '0.6', 'YELLOW', 'H204', 1, 39),
+('骞冲潎杞借揣鍚ㄤ綅涓庢爣璁板惃浣嶆瘮鍊兼牳瀹�', 'RULE_E010', '骞冲潎杞借揣鍚ㄤ綅/鏍囪鍚ㄤ綅 灏忎簬0.5鎴栧ぇ浜�1闇�鏍稿疄', 'avgLoadedTonnage,markedTonnage', 'LOADED_TON_RATIO', '0.5,1', 'YELLOW', 'H204', 1, 40);
+
+-- ============================================
+-- 鍗併�佹姇璧勬ā鍧楋紙瀹㈣繍绔欏満/鐗╂祦鍥尯锛夋墿灞�
+-- ============================================
+
+-- 鎶曡祫椤圭洰涓绘。锛堟寜 椤圭洰鍚�+绫诲埆 鍞竴锛�
+DROP TABLE IF EXISTS investment_project;
+CREATE TABLE investment_project (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    project_name VARCHAR(200) NOT NULL COMMENT '椤圭洰鍚嶇О',
+    category VARCHAR(20) NOT NULL COMMENT '绫诲埆锛氬杩愮珯鍦�/鐗╂祦鍥尯',
+    city VARCHAR(50) COMMENT '甯傚窞',
+    county VARCHAR(100) COMMENT '鍘匡紙甯傘�佸尯锛�',
+    builder_name VARCHAR(200) COMMENT '鎶曡祫寤鸿鍗曚綅',
+    construct_nature VARCHAR(50) COMMENT '寤鸿鎬ц川',
+    start_time VARCHAR(20) COMMENT '寮�宸ユ椂闂�',
+    end_time VARCHAR(20) COMMENT '寤烘垚/绔ｅ伐鏃堕棿',
+    total_investment DOUBLE COMMENT '璁″垝鎬绘姇璧勶紙涓囧厓锛�',
+    approval_gk VARCHAR(500) COMMENT '宸ュ彲鎵瑰',
+    approval_cs VARCHAR(500) COMMENT '鍒濊鎵瑰',
+    building_area DOUBLE COMMENT '寤虹瓚闈㈢Н锛堝钩鏂圭背锛�',
+    is_billion TINYINT DEFAULT 0 COMMENT '浜垮厓鎶曡祫椤圭洰鏍囪',
+    is_county TINYINT DEFAULT 0 COMMENT '缁忔祹寮哄幙椤圭洰鏍囪',
+    is_five_year TINYINT DEFAULT 0 COMMENT '鍗佷簲浜旈噸鐐圭墿娴侀」鐩爣璁�',
+    source VARCHAR(50) COMMENT '鏁版嵁鏉ユ簮',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+    UNIQUE KEY uk_name_category (project_name, category)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鎶曡祫椤圭洰涓绘。';
+
+-- 鎶曡祫椤圭洰鏈堝害瀹屾垚鎯呭喌
+DROP TABLE IF EXISTS investment_monthly;
+CREATE TABLE investment_monthly (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-07',
+    project_id BIGINT NOT NULL COMMENT '椤圭洰涓绘。ID',
+    year_plan DOUBLE COMMENT '鏈勾璁″垝鎶曡祫锛堜竾鍏冿級',
+    year_cum DOUBLE COMMENT '鑷勾鍒濈疮璁″畬鎴愭姇璧勶紙涓囧厓锛�',
+    month_done DOUBLE COMMENT '鍏朵腑锛氭湰鏈堝畬鎴愭姇璧勶紙涓囧厓锛�',
+    start_cum DOUBLE COMMENT '鑷紑濮嬪缓璁剧疮璁″畬鎴愭姇璧勶紙涓囧厓锛�',
+    progress_stage VARCHAR(100) COMMENT '寤鸿闃舵',
+    progress_desc VARCHAR(2000) COMMENT '褰㈣薄杩涘害',
+    building_area DOUBLE COMMENT '寤虹瓚闈㈢Н锛堝钩鏂圭背锛�',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    KEY idx_period (report_period),
+    KEY idx_project (project_id)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鎶曡祫椤圭洰鏈堝害瀹屾垚鎯呭喌';
+
+-- 鎶曡祫绯荤粺鏌ヨ瀵煎嚭锛堝鏍告瘮瀵瑰熀鍑嗭級
+DROP TABLE IF EXISTS investment_system;
+CREATE TABLE investment_system (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-07',
+    project_name VARCHAR(200) NOT NULL COMMENT '椤圭洰鍚嶇О锛堝崟浣嶏級',
+    total_investment DOUBLE COMMENT '璁″垝鎬绘姇璧勶紙涓囧厓锛�',
+    start_cum DOUBLE COMMENT '鑷紑濮嬪缓璁捐嚦鏈湀绱瀹屾垚鎶曡祫锛堜竾鍏冿級',
+    year_plan DOUBLE COMMENT '鏈勾璁″垝鎶曡祫锛堜竾鍏冿級',
+    year_cum DOUBLE COMMENT '鑷勾鍒濈疮璁″畬鎴愭姇璧勶紙涓囧厓锛�',
+    month_done DOUBLE COMMENT '褰撴湀瀹屾垚鎶曡祫锛堜竾鍏冿級',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    KEY idx_period (report_period)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鎶曡祫绯荤粺鏌ヨ瀵煎嚭锛堝鏍告瘮瀵瑰熀鍑嗭級';
+
+-- INVEST 棰勭疆瀹℃牳瑙勫垯锛�4鏉★紝report_type=INVEST锛�
+INSERT INTO audit_rule (rule_name, rule_code, description, check_field, compare_type, threshold, alert_level, report_type, is_enabled, sort_order) VALUES
+('鑷紑濮嬬疮璁′笌鎶曡祫绯荤粺瀵规瘮', 'RULE_I001', '鑷紑濮嬪缓璁剧疮璁″畬鎴愭姇璧勪笌鎶曡祫绯荤粺瀵煎嚭宸紓瓒呴槇鍊奸渶鏍稿疄', 'startCum', 'CROSS_DIFF', '100|5', 'YELLOW', 'INVEST', 1, 41),
+('鑷勾鍒濈疮璁′笌鎶曡祫绯荤粺瀵规瘮', 'RULE_I002', '鑷勾鍒濈疮璁″畬鎴愭姇璧勪笌鎶曡祫绯荤粺瀵煎嚭宸紓瓒呴槇鍊奸渶鏍稿疄', 'yearCum', 'CROSS_DIFF', '50|5', 'YELLOW', 'INVEST', 1, 42),
+('鏈湀瀹屾垚涓庢姇璧勭郴缁熷姣�', 'RULE_I003', '鏈湀瀹屾垚鎶曡祫涓庢姇璧勭郴缁熷鍑哄樊寮傝秴闃堝�奸渶鏍稿疄', 'monthDone', 'CROSS_DIFF', '30|30', 'YELLOW', 'INVEST', 1, 43),
+('鎶曡祫绯荤粺椤圭洰缂哄け鏍稿疄', 'RULE_I004', '姹囨�诲ぇ琛ㄩ」鐩湪鎶曡祫绯荤粺瀵煎嚭涓笉瀛樺湪闇�鏍稿疄', 'projectName', 'EXISTENCE_SYS', '0', 'YELLOW', 'INVEST', 1, 44);
+
+
+-- ============================================
+-- 涔濄�佸叕璺梾瀹釜浣撳杩愰噺/鍛ㄨ浆閲忥紙浼佷笟绾夸笅姹囨姤锛�
+-- ============================================
+DROP TABLE IF EXISTS passenger_individual_monthly;
+CREATE TABLE passenger_individual_monthly (
+  id BIGINT AUTO_INCREMENT PRIMARY KEY,
+  report_period VARCHAR(20) COMMENT '鎶ヨ〃鏈� 2026-07',
+  region_code VARCHAR(20) COMMENT '鎵�灞炲湴鍖猴紙琛屾斂鍖哄垝浠ｇ爜锛�',
+  enterprise_code VARCHAR(50) COMMENT '浼佷笟浠ｇ爜',
+  enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+  passenger_count DOUBLE COMMENT '鍏朵腑涓綋瀹㈣繍閲忥紙浜猴級',
+  turnover DOUBLE COMMENT '鍏朵腑涓綋鏃呭鍛ㄨ浆閲忥紙浜哄叕閲岋級',
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  KEY idx_period (report_period)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鍏矾鏃呭涓綋瀹㈣繍閲�/鍛ㄨ浆閲�';
+
+-- ============================================
+-- 鍗併�佹姤琛ㄦ湡瀹℃牳閫氳繃鏍囪锛坅udit_run锛�
+-- ============================================
+DROP TABLE IF EXISTS audit_run;
+CREATE TABLE audit_run (
+  id BIGINT AUTO_INCREMENT PRIMARY KEY,
+  report_type VARCHAR(50) COMMENT '鎶ヨ〃绫诲瀷',
+  report_period VARCHAR(20) COMMENT '鎶ヨ〃鏈�',
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  KEY idx_type_period (report_type, report_period)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鎶ヨ〃鏈熷鏍搁�氳繃鏍囪';

--
Gitblit v1.9.1