From bb7c195ec514ff1e5017fb2853175822a833ea1a Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期二, 01 九月 2026 17:31:49 +0800
Subject: [PATCH] docs: 关机交接快照（09-01 晚）——运行状态、今日交付、待办
---
docs/init.sql | 32 +++++++++++++++++++++++++++++++-
1 files changed, 31 insertions(+), 1 deletions(-)
diff --git a/docs/init.sql b/docs/init.sql
index f7518c6..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鍚敤',
@@ -382,7 +383,7 @@
-- 棰勭疆绠＄悊鍛樿处鍙� 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);
@@ -587,3 +588,32 @@
('鑷勾鍒濈疮璁′笌鎶曡祫绯荤粺瀵规瘮', '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