liangfangxing/SmartVoyage
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
SmartVoyage/database.sql
liangfangxing 0b087df55e feat: mcp
2026-03-20 11:26:44 +08:00

436 lines
84 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
DROP DATABASE IF EXISTS travel_rag;
CREATE DATABASE travel_rag CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE travel_rag;
CREATE TABLE train_tickets (
id INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键，自增，唯一标识每条记录',
departure_city VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '出发城市（如“北京”）',
arrival_city VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '到达城市（如“上海”）',
departure_time DATETIME NOT NULL COMMENT '出发时间（如“2025-08-12 07:00:00”）',
arrival_time DATETIME NOT NULL COMMENT '到达时间（如“2025-08-12 11:30:00”）',
train_number VARCHAR(20) NOT NULL COMMENT '火车车次（如“G1001”）',
seat_type VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '座位类型（如“二等座”）',
total_seats INT NOT NULL COMMENT '总座位数（如 1000）',
remaining_seats INT NOT NULL COMMENT '剩余座位数（如 50）',
price DECIMAL(10, 2) NOT NULL COMMENT '票价（如 553.50）',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间，自动记录插入时间',
UNIQUE KEY unique_train (departure_time, train_number) -- 唯一约束，确保同一时间和车次不重复
) COMMENT='火车票信息表';
CREATE TABLE flight_tickets (
id INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键，自增，唯一标识每条记录',
departure_city VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '出发城市（如“北京”）',
arrival_city VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '到达城市（如“上海”）',
departure_time DATETIME NOT NULL COMMENT '出发时间（如“2025-08-12 08:00:00”）',
arrival_time DATETIME NOT NULL COMMENT '到达时间（如“2025-08-12 10:30:00”）',
flight_number VARCHAR(20) NOT NULL COMMENT '航班号（如“CA1234”）',
cabin_type VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '舱位类型（如“经济舱”）',
total_seats INT NOT NULL COMMENT '总座位数（如 200）',
remaining_seats INT NOT NULL COMMENT '剩余座位数（如 10）',
price DECIMAL(10, 2) NOT NULL COMMENT '票价（如 1200.00）',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间，自动记录插入时间',
UNIQUE KEY unique_flight (departure_time, flight_number) -- 唯一约束，确保同一时间和航班号不重复
) COMMENT='航班机票信息表';
CREATE TABLE concert_tickets (
id INT AUTO_INCREMENT PRIMARY KEY, -- 主键，自增，唯一标识每条记录
artist VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, -- 艺人名称（如“周杰伦”）
city VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, -- 举办城市（如“上海”）
venue VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, -- 场馆（如“上海体育场”）
start_time DATETIME NOT NULL, -- 开始时间（如“2025-08-12 19:00:00”）
end_time DATETIME NOT NULL, -- 结束时间（如“2025-08-12 22:00:00”）
ticket_type VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, -- 票类型（如“VIP”）
total_seats INT NOT NULL, -- 总座位数（如 5000）
remaining_seats INT NOT NULL, -- 剩余座位数（如 100）
price DECIMAL(10, 2) NOT NULL, -- 票价（如 880.00）
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- 创建时间，自动记录插入时间
UNIQUE KEY unique_concert (start_time, artist, ticket_type) -- 唯一约束，确保同一时间、艺人和票类型不重复
);
CREATE TABLE IF NOT EXISTS weather_data (
id INT AUTO_INCREMENT PRIMARY KEY,
city VARCHAR(50) NOT NULL COMMENT '城市名称',
fx_date DATE NOT NULL COMMENT '预报日期',
sunrise TIME COMMENT '日出时间',
sunset TIME COMMENT '日落时间',
moonrise TIME COMMENT '月升时间',
moonset TIME COMMENT '月落时间',
moon_phase VARCHAR(20) COMMENT '月相名称',
moon_phase_icon VARCHAR(10) COMMENT '月相图标代码',
temp_max INT COMMENT '最高温度',
temp_min INT COMMENT '最低温度',
icon_day VARCHAR(10) COMMENT '白天天气图标代码',
text_day VARCHAR(20) COMMENT '白天天气描述',
icon_night VARCHAR(10) COMMENT '夜间天气图标代码',
text_night VARCHAR(20) COMMENT '夜间天气描述',
wind360_day INT COMMENT '白天风向360角度',
wind_dir_day VARCHAR(20) COMMENT '白天风向',
wind_scale_day VARCHAR(10) COMMENT '白天风力等级',
wind_speed_day INT COMMENT '白天风速 (km/h)',
wind360_night INT COMMENT '夜间风向360角度',
wind_dir_night VARCHAR(20) COMMENT '夜间风向',
wind_scale_night VARCHAR(10) COMMENT '夜间风力等级',
wind_speed_night INT COMMENT '夜间风速 (km/h)',
precip DECIMAL(5,1) COMMENT '降水量 (mm)',
uv_index INT COMMENT '紫外线指数',
humidity INT COMMENT '相对湿度 (%)',
pressure INT COMMENT '大气压强 (hPa)',
vis INT COMMENT '能见度 (km)',
cloud INT COMMENT '云量 (%)',
update_time DATETIME COMMENT '数据更新时间',
UNIQUE KEY unique_city_date (city, fx_date)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='天气数据表';
INSERT INTO train_tickets (
departure_city, arrival_city, departure_time, arrival_time,
train_number, seat_type, total_seats, remaining_seats, price
) VALUES
-- 第1-10条
('广州', '上海', '2026-03-18 07:00:00', '2026-03-18 14:30:00', 'G1301', '二等座', 800, 120, 858.00),
('广州', '北京', '2026-03-18 08:15:00', '2026-03-18 18:45:00', 'G80', '一等座', 750, 85, 1380.50),
('上海', '北京', '2026-03-18 09:00:00', '2026-03-18 15:30:00', 'G1', '二等座', 1000, 200, 553.00),
('北京', '上海', '2026-03-18 10:00:00', '2026-03-18 16:40:00', 'G2', '商务座', 50, 8, 1873.50),
('上海', '广州', '2026-03-18 11:30:00', '2026-03-18 20:15:00', 'G1302', '二等座', 900, 350, 876.00),
('北京', '广州', '2026-03-18 13:00:00', '2026-03-19 00:20:00', 'G65', '二等座', 850, 180, 1031.00),
('广州', '上海', '2026-03-19 06:45:00', '2026-03-19 14:10:00', 'G1303', '一等座', 200, 45, 1373.00),
('上海', '北京', '2026-03-19 08:30:00', '2026-03-19 15:00:00', 'G3', '二等座', 1000, 420, 553.00),
('北京', '广州', '2026-03-19 09:40:00', '2026-03-20 00:10:00', 'G67', '商务座', 40, 5, 3280.00),
('广州', '北京', '2026-03-19 10:20:00', '2026-03-19 20:50:00', 'G82', '二等座', 800, 95, 1380.50),
-- 第11-20条
('上海', '广州', '2026-03-19 12:00:00', '2026-03-19 20:45:00', 'G1304', '二等座', 950, 280, 865.50),
('北京', '上海', '2026-03-19 14:10:00', '2026-03-19 20:50:00', 'G4', '一等座', 250, 60, 885.00),
('广州', '上海', '2026-03-20 07:15:00', '2026-03-20 14:45:00', 'G1305', '二等座', 850, 150, 858.00),
('上海', '北京', '2026-03-20 08:45:00', '2026-03-20 15:15:00', 'G5', '二等座', 1000, 380, 553.00),
('北京', '广州', '2026-03-20 10:00:00', '2026-03-21 00:30:00', 'G69', '二等座', 800, 120, 1031.00),
('广州', '北京', '2026-03-20 11:30:00', '2026-03-20 22:00:00', 'G84', '一等座', 180, 30, 2208.80),
('上海', '广州', '2026-03-20 13:15:00', '2026-03-21 00:50:00', 'G1306', '商务座', 30, 2, 2780.00),
('北京', '上海', '2026-03-20 15:00:00', '2026-03-20 21:40:00', 'G6', '二等座', 1000, 450, 553.00),
('广州', '上海', '2026-03-21 06:30:00', '2026-03-21 14:00:00', 'G1307', '二等座', 900, 210, 858.00),
('上海', '北京', '2026-03-21 08:00:00', '2026-03-21 14:30:00', 'G7', '一等座', 220, 75, 885.00),
-- 第21-30条
('北京', '广州', '2026-03-21 09:20:00', '2026-03-22 00:00:00', 'G71', '二等座', 850, 160, 1031.00),
('广州', '北京', '2026-03-21 10:45:00', '2026-03-21 21:15:00', 'G86', '商务座', 45, 7, 4350.00),
('上海', '广州', '2026-03-21 12:30:00', '2026-03-21 21:10:00', 'G1308', '二等座', 920, 320, 876.00),
('北京', '上海', '2026-03-21 14:00:00', '2026-03-21 20:40:00', 'G8', '二等座', 1000, 390, 553.00),
('广州', '上海', '2026-03-22 07:45:00', '2026-03-22 15:15:00', 'G1309', '一等座', 200, 40, 1373.00),
('上海', '北京', '2026-03-22 08:30:00', '2026-03-22 15:00:00', 'G9', '二等座', 1000, 280, 553.00),
('北京', '广州', '2026-03-22 10:10:00', '2026-03-23 00:40:00', 'G73', '二等座', 800, 110, 1031.00),
('广州', '北京', '2026-03-22 11:50:00', '2026-03-22 22:20:00', 'G88', '二等座', 850, 140, 1380.50),
('上海', '广州', '2026-03-22 13:20:00', '2026-03-22 22:00:00', 'G1310', '一等座', 190, 55, 1392.00),
('北京', '上海', '2026-03-22 15:30:00', '2026-03-22 22:10:00', 'G10', '商务座', 50, 9, 1873.50),
-- 第31-40条
('广州', '上海', '2026-03-23 06:50:00', '2026-03-23 14:20:00', 'G1311', '二等座', 880, 190, 858.00),
('上海', '北京', '2026-03-23 08:15:00', '2026-03-23 14:45:00', 'G11', '二等座', 1000, 350, 553.00),
('北京', '广州', '2026-03-23 09:30:00', '2026-03-24 00:10:00', 'G75', '一等座', 180, 40, 1649.60),
('广州', '北京', '2026-03-23 10:50:00', '2026-03-23 21:20:00', 'G90', '二等座', 820, 85, 1380.50),
('上海', '广州', '2026-03-23 12:15:00', '2026-03-23 20:55:00', 'G1312', '二等座', 940, 270, 865.50),
('北京', '上海', '2026-03-23 14:20:00', '2026-03-23 21:00:00', 'G12', '二等座', 1000, 410, 553.00),
('广州', '上海', '2026-03-24 07:20:00', '2026-03-24 14:50:00', 'G1313', '商务座', 35, 4, 2725.00),
('上海', '北京', '2026-03-24 08:40:00', '2026-03-24 15:10:00', 'G13', '一等座', 230, 80, 885.00),
('北京', '广州', '2026-03-24 10:00:00', '2026-03-25 00:30:00', 'G77', '二等座', 860, 170, 1031.00),
('广州', '北京', '2026-03-24 11:30:00', '2026-03-24 22:00:00', 'G92', '一等座', 200, 50, 2208.80),
-- 第41-50条
('上海', '广州', '2026-03-24 13:00:00', '2026-03-24 21:40:00', 'G1314', '二等座', 910, 300, 876.00),
('北京', '上海', '2026-03-24 15:10:00', '2026-03-24 21:50:00', 'G14', '二等座', 1000, 370, 553.00),
('广州', '上海', '2026-03-25 06:40:00', '2026-03-25 14:10:00', 'G1315', '二等座', 890, 220, 858.00),
('上海', '北京', '2026-03-25 08:20:00', '2026-03-25 14:50:00', 'G15', '商务座', 45, 6, 1873.50),
('北京', '广州', '2026-03-25 09:45:00', '2026-03-26 00:15:00', 'G79', '二等座', 830, 130, 1031.00),
('广州', '北京', '2026-03-25 10:55:00', '2026-03-25 21:25:00', 'G94', '二等座', 840, 90, 1380.50),
('上海', '广州', '2026-03-25 12:20:00', '2026-03-25 21:00:00', 'G1316', '一等座', 210, 65, 1392.00),
('北京', '上海', '2026-03-25 14:30:00', '2026-03-25 21:10:00', 'G16', '二等座', 1000, 430, 553.00),
('广州', '上海', '2026-03-25 16:00:00', '2026-03-25 23:30:00', 'G1317', '二等座', 870, 180, 858.00),
('上海', '北京', '2026-03-25 17:30:00', '2026-03-26 00:00:00', 'G17', '二等座', 1000, 310, 553.00);
INSERT INTO flight_tickets (departure_city, arrival_city, departure_time, arrival_time, flight_number, cabin_type, total_seats, remaining_seats, price) VALUES
-- 2026-03-18
('北京', '上海', '2026-03-18 08:00:00', '2026-03-18 10:10:00', 'CA1501', '经济舱', 180, 45, 680.00),
('上海', '广州', '2026-03-18 08:30:00', '2026-03-18 11:00:00', 'MU5301', '经济舱', 200, 12, 750.00),
('广州', '北京', '2026-03-18 09:15:00', '2026-03-18 12:20:00', 'CZ3101', '公务舱', 30, 8, 2200.00),
('北京', '广州', '2026-03-18 10:20:00', '2026-03-18 13:40:00', 'CA1301', '经济舱', 200, 33, 850.00),
('上海', '北京', '2026-03-18 11:00:00', '2026-03-18 13:10:00', 'MU5101', '经济舱', 180, 67, 720.00),
('广州', '上海', '2026-03-18 12:10:00', '2026-03-18 14:20:00', 'CZ3501', '经济舱', 200, 89, 580.00),
('北京', '上海', '2026-03-18 13:45:00', '2026-03-18 15:55:00', 'CA1517', '公务舱', 28, 3, 1800.00),
('上海', '广州', '2026-03-18 14:30:00', '2026-03-18 16:50:00', 'HO1111', '经济舱', 180, 105, 690.00),
('广州', '北京', '2026-03-18 16:00:00', '2026-03-18 19:10:00', 'CZ3099', '经济舱', 200, 56, 920.00),
('北京', '广州', '2026-03-18 18:20:00', '2026-03-18 21:40:00', 'HU7801', '经济舱', 200, 47, 810.00),
-- 2026-03-19
('上海', '北京', '2026-03-19 07:50:00', '2026-03-19 10:00:00', 'MU5127', '经济舱', 180, 23, 700.00),
('广州', '上海', '2026-03-19 08:40:00', '2026-03-19 10:50:00', '9C8830', '经济舱', 180, 78, 520.00),
('北京', '上海', '2026-03-19 10:10:00', '2026-03-19 12:20:00', 'CA1549', '经济舱', 200, 112, 650.00),
('上海', '广州', '2026-03-19 11:30:00', '2026-03-19 13:50:00', 'MU5305', '公务舱', 32, 5, 1950.00),
('广州', '北京', '2026-03-19 13:15:00', '2026-03-19 16:20:00', 'CZ3103', '经济舱', 200, 41, 880.00),
('北京', '广州', '2026-03-19 15:00:00', '2026-03-19 18:20:00', 'CA1321', '经济舱', 200, 90, 830.00),
('上海', '北京', '2026-03-19 16:45:00', '2026-03-19 18:55:00', 'CA1850', '经济舱', 180, 34, 760.00),
('广州', '上海', '2026-03-19 18:20:00', '2026-03-19 20:30:00', 'MU5308', '经济舱', 200, 123, 600.00),
('北京', '上海', '2026-03-19 20:00:00', '2026-03-19 22:10:00', 'MU5150', '公务舱', 30, 7, 1750.00),
('上海', '广州', '2026-03-19 21:30:00', '2026-03-19 23:50:00', 'CZ3522', '经济舱', 180, 56, 720.00),
-- 2026-03-20
('广州', '北京', '2026-03-20 08:20:00', '2026-03-20 11:30:00', 'CZ3105', '经济舱', 200, 67, 900.00),
('北京', '广州', '2026-03-20 10:00:00', '2026-03-20 13:20:00', 'CA1305', '经济舱', 200, 45, 870.00),
('上海', '北京', '2026-03-20 12:00:00', '2026-03-20 14:10:00', 'MU5115', '经济舱', 180, 88, 710.00),
('北京', '上海', '2026-03-20 13:30:00', '2026-03-20 15:40:00', 'CA1553', '公务舱', 28, 4, 1900.00),
('广州', '上海', '2026-03-20 15:10:00', '2026-03-20 17:20:00', 'HO1115', '经济舱', 180, 102, 540.00),
('上海', '广州', '2026-03-20 16:50:00', '2026-03-20 19:10:00', 'CZ3505', '经济舱', 200, 78, 680.00),
('北京', '广州', '2026-03-20 18:30:00', '2026-03-20 21:50:00', 'HU7805', '经济舱', 200, 33, 890.00),
('广州', '北京', '2026-03-20 20:00:00', '2026-03-20 23:10:00', 'CA1331', '经济舱', 200, 91, 940.00),
('上海', '北京', '2026-03-20 21:40:00', '2026-03-20 23:50:00', 'MU5131', '公务舱', 30, 6, 2000.00),
('北京', '上海', '2026-03-20 22:20:00', '2026-03-21 00:30:00', '9C8890', '经济舱', 180, 120, 620.00),
-- 2026-03-21
('广州', '上海', '2026-03-21 08:00:00', '2026-03-21 10:10:00', 'CZ3507', '经济舱', 200, 55, 560.00),
('北京', '广州', '2026-03-21 09:30:00', '2026-03-21 12:50:00', 'CA1309', '经济舱', 200, 47, 860.00),
('上海', '北京', '2026-03-21 11:00:00', '2026-03-21 13:10:00', 'MU5109', '经济舱', 180, 77, 730.00),
('广州', '北京', '2026-03-21 12:40:00', '2026-03-21 15:50:00', 'CZ3107', '公务舱', 32, 9, 2100.00),
('北京', '上海', '2026-03-21 14:20:00', '2026-03-21 16:30:00', 'HO1119', '经济舱', 180, 134, 600.00),
('上海', '广州', '2026-03-21 16:00:00', '2026-03-21 18:20:00', 'MU5311', '经济舱', 200, 82, 710.00),
('广州', '上海', '2026-03-21 17:30:00', '2026-03-21 19:40:00', 'CA1561', '经济舱', 200, 96, 590.00),
('北京', '广州', '2026-03-21 19:00:00', '2026-03-21 22:20:00', 'HU7809', '公务舱', 28, 5, 1850.00),
('上海', '北京', '2026-03-21 20:30:00', '2026-03-21 22:40:00', 'CZ3526', '经济舱', 180, 43, 780.00),
('广州', '北京', '2026-03-21 22:00:00', '2026-03-22 01:10:00', 'CA1335', '经济舱', 200, 109, 910.00),
-- 2026-03-22
('北京', '上海', '2026-03-22 08:10:00', '2026-03-22 10:20:00', 'MU5103', '经济舱', 180, 65, 670.00),
('上海', '广州', '2026-03-22 09:20:00', '2026-03-22 11:40:00', 'CZ3509', '经济舱', 200, 114, 650.00),
('广州', '北京', '2026-03-22 10:50:00', '2026-03-22 14:00:00', 'CA1303', '公务舱', 30, 7, 2250.00),
('北京', '广州', '2026-03-22 12:30:00', '2026-03-22 15:50:00', 'HO1123', '经济舱', 200, 52, 840.00),
('上海', '北京', '2026-03-22 14:00:00', '2026-03-22 16:10:00', 'MU5111', '经济舱', 180, 89, 740.00),
('广州', '上海', '2026-03-22 15:30:00', '2026-03-22 17:40:00', 'CZ3511', '经济舱', 200, 101, 570.00),
('北京', '上海', '2026-03-22 17:00:00', '2026-03-22 19:10:00', 'CA1565', '经济舱', 200, 76, 630.00),
('上海', '广州', '2026-03-22 18:30:00', '2026-03-22 20:50:00', 'HU7813', '公务舱', 28, 4, 1950.00),
('广州', '北京', '2026-03-22 20:00:00', '2026-03-22 23:10:00', 'CA1337', '经济舱', 200, 118, 870.00),
('北京', '广州', '2026-03-22 21:30:00', '2026-03-23 00:50:00', 'MU5315', '经济舱', 180, 29, 820.00),
-- 2026-03-23
('上海', '北京', '2026-03-23 08:30:00', '2026-03-23 10:40:00', 'CZ3528', '经济舱', 180, 95, 690.00),
('广州', '上海', '2026-03-23 10:00:00', '2026-03-23 12:10:00', 'CA1567', '经济舱', 200, 142, 550.00),
('北京', '广州', '2026-03-23 11:30:00', '2026-03-23 14:50:00', 'HO1127', '公务舱', 32, 6, 2050.00),
('上海', '广州', '2026-03-23 13:00:00', '2026-03-23 15:20:00', 'MU5317', '经济舱', 200, 61, 700.00),
('广州', '北京', '2026-03-23 14:30:00', '2026-03-23 17:40:00', 'CZ3111', '经济舱', 200, 84, 930.00),
('北京', '上海', '2026-03-23 16:00:00', '2026-03-23 18:10:00', 'CA1569', '经济舱', 180, 37, 610.00),
('上海', '北京', '2026-03-23 17:30:00', '2026-03-23 19:40:00', 'MU5117', '经济舱', 180, 126, 770.00),
('广州', '上海', '2026-03-23 19:00:00', '2026-03-23 21:10:00', 'CZ3513', '公务舱', 30, 8, 1800.00),
('北京', '广州', '2026-03-23 20:30:00', '2026-03-23 23:50:00', 'HU7817', '经济舱', 200, 53, 800.00),
('上海', '广州', '2026-03-23 22:00:00', '2026-03-24 00:20:00', 'CA1339', '经济舱', 200, 97, 670.00),
-- 2026-03-24
('广州', '北京', '2026-03-24 08:40:00', '2026-03-24 11:50:00', 'CA1307', '经济舱', 200, 44, 950.00),
('北京', '上海', '2026-03-24 10:10:00', '2026-03-24 12:20:00', 'MU5105', '经济舱', 180, 102, 640.00),
('上海', '广州', '2026-03-24 11:40:00', '2026-03-24 14:00:00', 'CZ3515', '经济舱', 200, 79, 720.00),
('广州', '北京', '2026-03-24 13:10:00', '2026-03-24 16:20:00', 'HO1131', '公务舱', 28, 5, 2150.00),
('北京', '广州', '2026-03-24 14:40:00', '2026-03-24 18:00:00', 'CA1311', '经济舱', 200, 68, 880.00),
('上海', '北京', '2026-03-24 16:10:00', '2026-03-24 18:20:00', 'MU5119', '经济舱', 180, 113, 760.00),
('广州', '上海', '2026-03-24 17:40:00', '2026-03-24 19:50:00', 'CZ3517', '经济舱', 200, 87, 600.00),
('北京', '上海', '2026-03-24 19:10:00', '2026-03-24 21:20:00', 'CA1571', '经济舱', 180, 51, 590.00),
('上海', '广州', '2026-03-24 20:40:00', '2026-03-24 23:00:00', 'HU7821', '公务舱', 32, 4, 1900.00),
('广州', '北京', '2026-03-24 22:10:00', '2026-03-25 01:20:00', 'CA1341', '经济舱', 200, 136, 920.00),
-- 2026-03-25
('北京', '上海', '2026-03-25 08:50:00', '2026-03-25 11:00:00', 'MU5107', '经济舱', 180, 59, 660.00),
('上海', '广州', '2026-03-25 10:20:00', '2026-03-25 12:40:00', 'CZ3519', '经济舱', 200, 108, 690.00),
('广州', '北京', '2026-03-25 11:50:00', '2026-03-25 15:00:00', 'CA1313', '经济舱', 200, 72, 890.00),
('北京', '广州', '2026-03-25 13:20:00', '2026-03-25 16:40:00', 'HO1135', '公务舱', 30, 7, 2000.00),
('上海', '北京', '2026-03-25 14:50:00', '2026-03-25 17:00:00', 'MU5121', '经济舱', 180, 94, 710.00),
('广州', '上海', '2026-03-25 16:20:00', '2026-03-25 18:30:00', 'CZ3521', '经济舱', 200, 121, 570.00),
('北京', '上海', '2026-03-25 17:50:00', '2026-03-25 20:00:00', 'CA1573', '经济舱', 180, 48, 640.00),
('上海', '广州', '2026-03-25 19:20:00', '2026-03-25 21:40:00', 'HU7825', '经济舱', 200, 83, 730.00),
('广州', '北京', '2026-03-25 20:50:00', '2026-03-25 23:50:00', 'CA1345', '公务舱', 28, 3, 1850.00),
('北京', '广州', '2026-03-25 22:20:00', '2026-03-26 01:40:00', 'MU5319', '经济舱', 200, 99, 810.00);
INSERT INTO concert_tickets (artist, city, venue, start_time, end_time, ticket_type, total_seats, remaining_seats, price) VALUES
-- 注意：根据唯一约束 unique_concert (start_time, artist, ticket_type)，
-- 同一时间、同一艺人、同一票类型只能有一条记录
-- 2026-03-18
('周杰伦', '北京', '国家体育场（鸟巢）', '2026-03-18 19:00:00', '2026-03-18 22:00:00', 'VIP', 500, 50, 1880.00),
('周杰伦', '北京', '国家体育场（鸟巢）', '2026-03-18 20:30:00', '2026-03-18 23:30:00', '看台', 15000, 2340, 580.00),
('吴岳峰', '上海', '梅赛德斯-奔驰文化中心', '2026-03-18 20:00:00', '2026-03-18 23:00:00', '内场', 2000, 156, 980.00),
('邓秋月', '广州', '广州体育馆', '2026-03-18 19:30:00', '2026-03-18 22:30:00', 'VIP', 300, 45, 1280.00),
('毛建龙', '北京', '五棵松体育馆', '2026-03-18 20:30:00', '2026-03-18 23:00:00', '看台', 10000, 3200, 380.00),
('周杰伦', '上海', '上海体育场', '2026-03-18 20:00:00', '2026-03-18 23:00:00', '内场', 3000, 120, 1580.00),
('周杰伦', '上海', '上海体育场', '2026-03-18 21:00:00', '2026-03-19 00:00:00', '看台', 20000, 4500, 680.00),
('吴岳峰', '广州', '广州宝能观致文化中心', '2026-03-18 20:00:00', '2026-03-18 23:00:00', 'VIP', 400, 89, 1080.00),
('邓秋月', '北京', '凯迪拉克中心', '2026-03-18 20:00:00', '2026-03-18 22:30:00', '内场', 1500, 230, 880.00),
('毛建龙', '上海', '静安体育中心', '2026-03-18 20:00:00', '2026-03-18 22:30:00', '看台', 8000, 1200, 280.00),
-- 2026-03-19
('周杰伦', '广州', '广州大学城体育中心体育场', '2026-03-19 19:00:00', '2026-03-19 22:00:00', 'VIP', 600, 78, 1780.00),
('周杰伦', '广州', '广州大学城体育中心体育场', '2026-03-19 20:00:00', '2026-03-19 23:00:00', '看台', 18000, 3100, 550.00),
('吴岳峰', '北京', '国家体育馆', '2026-03-19 20:00:00', '2026-03-19 23:00:00', '内场', 2500, 198, 1020.00),
('邓秋月', '上海', '上海大舞台', '2026-03-19 19:30:00', '2026-03-19 22:30:00', 'VIP', 350, 56, 1180.00),
('毛建龙', '广州', '广州中山纪念堂', '2026-03-19 20:30:00', '2026-03-19 23:00:00', '看台', 5000, 850, 350.00),
('周杰伦', '北京', '工人体育场', '2026-03-19 20:00:00', '2026-03-19 23:00:00', '内场', 3500, 145, 1680.00),
('周杰伦', '北京', '工人体育场', '2026-03-19 21:00:00', '2026-03-20 00:00:00', '看台', 22000, 5200, 620.00),
('吴岳峰', '上海', '虹口足球场', '2026-03-19 20:00:00', '2026-03-19 23:00:00', 'VIP', 450, 92, 1120.00),
('邓秋月', '广州', '广州国际体育演艺中心', '2026-03-19 20:00:00', '2026-03-19 22:30:00', '内场', 1800, 310, 920.00),
('毛建龙', '北京', '北展剧场', '2026-03-19 20:00:00', '2026-03-19 22:30:00', '看台', 6000, 1450, 320.00),
-- 2026-03-20
('周杰伦', '上海', '东方体育中心', '2026-03-20 19:00:00', '2026-03-20 22:00:00', 'VIP', 550, 65, 1920.00),
('周杰伦', '上海', '东方体育中心', '2026-03-20 20:00:00', '2026-03-20 23:00:00', '看台', 16000, 2800, 590.00),
('吴岳峰', '广州', '天河体育场', '2026-03-20 20:00:00', '2026-03-20 23:00:00', '内场', 2200, 167, 1050.00),
('邓秋月', '北京', '首都体育馆', '2026-03-20 19:30:00', '2026-03-20 22:30:00', 'VIP', 320, 48, 1250.00),
('毛建龙', '上海', '上海音乐厅', '2026-03-20 20:30:00', '2026-03-20 23:00:00', '看台', 3000, 520, 420.00),
('周杰伦', '广州', '广东省人民体育场', '2026-03-20 20:00:00', '2026-03-20 23:00:00', '内场', 3200, 132, 1620.00),
('周杰伦', '广州', '广东省人民体育场', '2026-03-20 21:00:00', '2026-03-21 00:00:00', '看台', 19000, 4100, 650.00),
('吴岳峰', '北京', '朝阳体育馆', '2026-03-20 20:00:00', '2026-03-20 23:00:00', 'VIP', 380, 75, 1150.00),
('邓秋月', '上海', '上海交响乐团音乐厅', '2026-03-20 20:00:00', '2026-03-20 22:30:00', '内场', 1200, 190, 950.00),
('毛建龙', '广州', '星海音乐厅', '2026-03-20 20:00:00', '2026-03-20 22:30:00', '看台', 4500, 920, 380.00),
-- 2026-03-21
('周杰伦', '北京', '国家游泳中心（水立方）', '2026-03-21 19:00:00', '2026-03-21 22:00:00', 'VIP', 480, 55, 1950.00),
('周杰伦', '北京', '国家游泳中心（水立方）', '2026-03-21 20:00:00', '2026-03-21 23:00:00', '看台', 14000, 2600, 610.00),
('吴岳峰', '上海', '上海文化广场', '2026-03-21 20:00:00', '2026-03-21 23:00:00', '内场', 1800, 145, 990.00),
('邓秋月', '广州', '广州友谊剧院', '2026-03-21 19:30:00', '2026-03-21 22:30:00', 'VIP', 280, 40, 1320.00),
('毛建龙', '北京', '天桥艺术中心', '2026-03-21 20:30:00', '2026-03-21 23:00:00', '看台', 3500, 680, 410.00),
('周杰伦', '上海', '上海世博文化中心', '2026-03-21 20:00:00', '2026-03-21 23:00:00', '内场', 2800, 118, 1720.00),
('周杰伦', '上海', '上海世博文化中心', '2026-03-21 21:00:00', '2026-03-22 00:00:00', '看台', 17000, 3800, 720.00),
('吴岳峰', '广州', '广州白云国际会议中心', '2026-03-21 20:00:00', '2026-03-21 23:00:00', 'VIP', 330, 60, 1220.00),
('邓秋月', '北京', '国家大剧院', '2026-03-21 20:00:00', '2026-03-21 22:30:00', '内场', 1000, 175, 1020.00),
('毛建龙', '上海', '上海国际舞蹈中心', '2026-03-21 20:00:00', '2026-03-21 22:30:00', '看台', 2500, 450, 360.00),
-- 2026-03-22
('周杰伦', '广州', '广州海心沙亚运公园', '2026-03-22 19:00:00', '2026-03-22 22:00:00', 'VIP', 520, 70, 1850.00),
('周杰伦', '广州', '广州海心沙亚运公园', '2026-03-22 20:00:00', '2026-03-22 23:00:00', '看台', 15000, 2900, 540.00),
('吴岳峰', '北京', '北京展览馆剧场', '2026-03-22 20:00:00', '2026-03-22 23:00:00', '内场', 2100, 180, 1010.00),
('邓秋月', '上海', '上海音乐谷', '2026-03-22 19:30:00', '2026-03-22 22:30:00', 'VIP', 300, 52, 1350.00),
('毛建龙', '广州', '广州大剧院', '2026-03-22 20:30:00', '2026-03-22 23:00:00', '看台', 4000, 780, 390.00),
('周杰伦', '北京', '北京大学生体育馆', '2026-03-22 20:00:00', '2026-03-22 23:00:00', '内场', 3000, 125, 1780.00),
('周杰伦', '北京', '北京大学生体育馆', '2026-03-22 21:00:00', '2026-03-23 00:00:00', '看台', 18000, 4300, 670.00),
('吴岳峰', '上海', '上海儿童艺术剧场', '2026-03-22 20:00:00', '2026-03-22 23:00:00', 'VIP', 370, 68, 1180.00),
('邓秋月', '广州', '广州艺术博物院', '2026-03-22 20:00:00', '2026-03-22 22:30:00', '内场', 1300, 220, 980.00),
('毛建龙', '北京', '北京喜剧院', '2026-03-22 20:00:00', '2026-03-22 22:30:00', '看台', 2800, 510, 340.00),
-- 2026-03-23
('周杰伦', '上海', '上海国际体操中心', '2026-03-23 19:00:00', '2026-03-23 22:00:00', 'VIP', 470, 62, 1980.00),
('周杰伦', '上海', '上海国际体操中心', '2026-03-23 20:00:00', '2026-03-23 23:00:00', '看台', 13000, 2400, 630.00),
('吴岳峰', '广州', '广州体育馆二号馆', '2026-03-23 20:00:00', '2026-03-23 23:00:00', '内场', 1900, 155, 960.00),
('邓秋月', '北京', '北京剧院', '2026-03-23 19:30:00', '2026-03-23 22:30:00', 'VIP', 260, 38, 1420.00),
('毛建龙', '上海', '上海话剧艺术中心', '2026-03-23 20:30:00', '2026-03-23 23:00:00', '看台', 2200, 390, 400.00),
('周杰伦', '广州', '广州体育学院体育馆', '2026-03-23 20:00:00', '2026-03-23 23:00:00', '内场', 2900, 110, 1680.00),
('周杰伦', '广州', '广州体育学院体育馆', '2026-03-23 21:00:00', '2026-03-24 00:00:00', '看台', 16000, 3600, 590.00),
('吴岳峰', '北京', '北京音乐厅', '2026-03-23 20:00:00', '2026-03-23 23:00:00', 'VIP', 350, 72, 1250.00),
('邓秋月', '上海', '上海木偶剧团仙乐斯演艺厅', '2026-03-23 20:00:00', '2026-03-23 22:30:00', '内场', 1100, 185, 1050.00),
('毛建龙', '广州', '广州蓓蕾剧院', '2026-03-23 20:00:00', '2026-03-23 22:30:00', '看台', 3200, 610, 370.00),
-- 2026-03-24
('周杰伦', '北京', '北京工人体育馆', '2026-03-24 19:00:00', '2026-03-24 22:00:00', 'VIP', 450, 58, 2050.00),
('周杰伦', '北京', '北京工人体育馆', '2026-03-24 20:00:00', '2026-03-24 23:00:00', '看台', 12000, 2200, 660.00),
('吴岳峰', '上海', '上海国际时尚中心', '2026-03-24 20:00:00', '2026-03-24 23:00:00', '内场', 1700, 142, 920.00),
('邓秋月', '广州', '广州少年宫蓓蕾剧院', '2026-03-24 19:30:00', '2026-03-24 22:30:00', 'VIP', 240, 35, 1550.00),
('毛建龙', '北京', '北京民族文化宫大剧院', '2026-03-24 20:30:00', '2026-03-24 23:00:00', '看台', 2000, 380, 430.00),
('周杰伦', '上海', '上海长宁体操中心', '2026-03-24 20:00:00', '2026-03-24 23:00:00', '内场', 2600, 105, 1820.00),
('周杰伦', '上海', '上海长宁体操中心', '2026-03-24 21:00:00', '2026-03-25 00:00:00', '看台', 14000, 3200, 740.00),
('吴岳峰', '广州', '广州黄花岗剧院', '2026-03-24 20:00:00', '2026-03-24 23:00:00', 'VIP', 310, 65, 1350.00),
('邓秋月', '北京', '北京国图艺术中心', '2026-03-24 20:00:00', '2026-03-24 22:30:00', '内场', 900, 160, 1120.00),
('毛建龙', '上海', '上海人民大舞台', '2026-03-24 20:00:00', '2026-03-24 22:30:00', '看台', 1800, 340, 450.00),
-- 2026-03-25
('周杰伦', '广州', '广州天河体育馆', '2026-03-25 19:00:00', '2026-03-25 22:00:00', 'VIP', 490, 68, 1880.00),
('周杰伦', '广州', '广州天河体育馆', '2026-03-25 20:00:00', '2026-03-25 23:00:00', '看台', 17000, 3900, 570.00),
('吴岳峰', '北京', '北京世纪剧院', '2026-03-25 20:00:00', '2026-03-25 23:00:00', '内场', 1600, 130, 940.00),
('邓秋月', '上海', '上海东方艺术中心', '2026-03-25 19:30:00', '2026-03-25 22:30:00', 'VIP', 220, 30, 1620.00),
('毛建龙', '广州', '广州星海音乐厅（交响乐厅）', '2026-03-25 20:30:00', '2026-03-25 23:00:00', '看台', 1500, 290, 480.00),
('周杰伦', '北京', '北京天桥剧场', '2026-03-25 20:00:00', '2026-03-25 23:00:00', '内场', 2400, 98, 1920.00),
('周杰伦', '北京', '北京天桥剧场', '2026-03-25 21:00:00', '2026-03-26 00:00:00', '看台', 15000, 3400, 690.00),
('吴岳峰', '上海', '上海商城剧院', '2026-03-25 20:00:00', '2026-03-25 23:00:00', 'VIP', 290, 55, 1280.00),
('邓秋月', '广州', '广州大剧院实验剧场', '2026-03-25 20:00:00', '2026-03-25 22:30:00', '内场', 800, 140, 1180.00),
('毛建龙', '北京', '北京保利剧院', '2026-03-25 20:00:00', '2026-03-25 22:30:00', '看台', 1200, 230, 520.00);
truncate weather_data;
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (1, '北京', '2026-03-18', '06:23:00', '18:24:00', '05:46:00', '17:38:00', '残月', '807', 12, 0, '100', '晴', '150', '晴', 225, '西南风', '1-3', 3, 225, '西南风', '1-3', 3, 0.0, 5, 20, 1013, 25, 0, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (2, '北京', '2026-03-19', '06:21:00', '18:25:00', '06:09:00', '18:48:00', '新月', '800', 16, 2, '100', '晴', '150', '晴', 225, '西南风', '1-3', 3, 45, '东北风', '1-3', 3, 0.0, 4, 19, 1015, 25, 0, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (3, '北京', '2026-03-20', '06:20:00', '18:26:00', '06:34:00', '20:00:00', '蛾眉月', '801', 15, 2, '100', '晴', '150', '晴', 135, '东南风', '1-3', 3, 90, '东风', '1-3', 3, 0.0, 5, 39, 1015, 25, 0, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (4, '北京', '2026-03-21', '06:18:00', '18:27:00', '06:59:00', '21:14:00', '蛾眉月', '801', 18, 3, '101', '多云', '151', '多云', 225, '西南风', '1-3', 3, 315, '西北风', '1-3', 3, 0.0, 5, 25, 1010, 25, 3, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (5, '北京', '2026-03-22', '06:16:00', '18:28:00', '07:30:00', '22:31:00', '蛾眉月', '801', 18, 4, '100', '晴', '151', '多云', 0, '北风', '1-3', 16, 45, '东北风', '1-3', 3, 0.0, 5, 29, 1017, 25, 0, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (6, '北京', '2026-03-23', '06:15:00', '18:29:00', '08:06:00', '23:49:00', '蛾眉月', '801', 16, 4, '101', '多云', '150', '晴', 180, '南风', '1-3', 3, 180, '南风', '1-3', 3, 0.0, 2, 33, 1013, 25, 1, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (7, '北京', '2026-03-24', '06:13:00', '18:30:00', '08:53:00', '00:00:00', '蛾眉月', '801', 18, 5, '100', '晴', '150', '晴', 180, '南风', '1-3', 3, 180, '南风', '1-3', 3, 0.0, 5, 53, 1007, 25, 1, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (8, '北京', '2026-03-25', '06:11:00', '18:31:00', '09:50:00', '01:03:00', '蛾眉月', '801', 22, 10, '101', '多云', '151', '多云', 0, '北风', '1-3', 3, 315, '西北风', '1-3', 3, 0.0, 5, 36, 1005, 25, 1, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (9, '北京', '2026-03-26', '06:10:00', '18:32:00', '10:57:00', '02:08:00', '上弦月', '802', 21, 7, '100', '晴', '104', '阴', 180, '南风', '1-3', 3, 180, '南风', '1-3', 3, 0.0, 5, 12, 1012, 25, 0, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (10, '北京', '2026-03-27', '06:08:00', '18:33:00', '12:12:00', '03:02:00', '盈凸月', '803', 18, 7, '101', '多云', '150', '晴', 315, '西北风', '1-3', 3, 225, '西南风', '1-3', 3, 0.0, 6, 11, 1016, 25, 0, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (11, '北京', '2026-03-28', '06:07:00', '18:34:00', '13:28:00', '03:44:00', '盈凸月', '803', 21, 9, '104', '阴', '104', '阴', 180, '南风', '1-3', 3, 0, '北风', '1-3', 16, 0.0, 6, 13, 1015, 25, 0, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (12, '北京', '2026-03-29', '06:05:00', '18:35:00', '14:42:00', '04:17:00', '盈凸月', '803', 17, 7, '101', '多云', '151', '多云', 0, '北风', '1-3', 16, 315, '西北风', '1-3', 16, 0.1, 6, 13, 1016, 25, 40, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (13, '北京', '2026-03-30', '06:03:00', '18:36:00', '15:53:00', '04:45:00', '盈凸月', '803', 16, 8, '104', '阴', '104', '阴', 315, '西北风', '1-3', 3, 0, '北风', '1-3', 16, 0.0, 2, 22, 1008, 25, 4, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (14, '北京', '2026-03-31', '06:02:00', '18:37:00', '17:00:00', '05:09:00', '盈凸月', '803', 16, 6, '101', '多云', '151', '多云', 0, '北风', '1-3', 3, 0, '北风', '1-3', 16, 0.0, 6, 53, 999, 21, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (15, '北京', '2026-04-01', '06:00:00', '18:38:00', '18:05:00', '05:30:00', '盈凸月', '803', 15, 6, '101', '多云', '150', '晴', 0, '北风', '1-3', 16, 0, '北风', '1-3', 3, 0.0, 2, 25, 1006, 25, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (16, '北京', '2026-04-02', '05:58:00', '18:39:00', '19:09:00', '05:52:00', '满月', '804', 13, 3, '100', '晴', '150', '晴', 276, '西风', '5-6', 39, 304, '西北风', '5-6', 39, 0.0, 6, 28, 995, 25, 20, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (17, '北京', '2026-04-03', '05:57:00', '18:40:00', '20:12:00', '06:13:00', '亏凸月', '805', 17, 4, '101', '多云', '151', '多云', 309, '西北风', '1-3', 19, 276, '西风', '1-3', 17, 0.0, 4, 24, 1010, 24, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (18, '北京', '2026-04-04', '05:55:00', '18:41:00', '21:15:00', '06:38:00', '亏凸月', '805', 19, 4, '100', '晴', '150', '晴', 329, '西北风', '1-3', 19, 336, '西北风', '1-3', 17, 0.0, 6, 25, 1009, 25, 20, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (19, '北京', '2026-04-05', '05:54:00', '18:42:00', '22:18:00', '07:05:00', '亏凸月', '805', 20, 6, '100', '晴', '153', '晴间多云', 51, '东北风', '1-3', 7, 56, '东北风', '1-3', 7, 0.0, 6, 25, 1009, 24, 20, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (20, '北京', '2026-04-06', '05:52:00', '18:43:00', '23:18:00', '07:37:00', '亏凸月', '805', 20, 7, '100', '晴', '153', '晴间多云', 63, '东北风', '1-3', 15, 156, '东南风', '1-3', 15, 0.0, 7, 24, 1012, 23, 10, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (21, '北京', '2026-04-07', '05:50:00', '18:44:00', '00:00:00', '08:16:00', '亏凸月', '805', 21, 9, '101', '多云', '350', '阵雨', 330, '西北风', '1-3', 17, 277, '西风', '1-3', 17, 0.0, 2, 25, 1011, 24, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (22, '北京', '2026-04-08', '05:49:00', '18:45:00', '00:15:00', '09:04:00', '亏凸月', '805', 20, 8, '302', '雷阵雨', '153', '晴间多云', 6, '北风', '4-5', 37, 320, '西北风', '1-3', 19, 1.7, 2, 27, 1012, 25, 62, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (23, '北京', '2026-04-09', '05:47:00', '18:46:00', '01:05:00', '09:59:00', '亏凸月', '805', 15, 6, '100', '晴', '150', '晴', 311, '西北风', '4-5', 33, 347, '西北风', '3-4', 28, 0.0, 7, 24, 1012, 25, 20, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (24, '北京', '2026-04-10', '05:46:00', '18:47:00', '01:49:00', '10:59:00', '下弦月', '806', 18, 4, '100', '晴', '150', '晴', 298, '西北风', '1-3', 19, 219, '西南风', '1-3', 19, 0.0, 7, 26, 1011, 25, 20, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (25, '北京', '2026-04-11', '05:44:00', '18:48:00', '02:26:00', '12:03:00', '残月', '807', 20, 6, '100', '晴', '151', '多云', 34, '东北风', '1-3', 17, 71, '东北风', '1-3', 17, 0.0, 7, 27, 1010, 24, 20, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (26, '北京', '2026-04-12', '05:43:00', '18:49:00', '02:56:00', '13:09:00', '残月', '807', 22, 10, '101', '多云', '153', '晴间多云', 11, '北风', '1-3', 7, 128, '东南风', '1-3', 6, 0.0, 2, 24, 1011, 25, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (27, '北京', '2026-04-13', '05:41:00', '18:50:00', '03:24:00', '14:16:00', '残月', '807', 21, 8, '102', '少云', '150', '晴', 100, '东风', '3-4', 20, 131, '东南风', '3-4', 20, 0.0, 4, 24, 1009, 25, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (28, '北京', '2026-04-14', '05:40:00', '18:51:00', '03:48:00', '15:23:00', '残月', '807', 22, 10, '101', '多云', '151', '多云', 89, '东风', '1-3', 19, 87, '东风', '1-3', 19, 0.0, 2, 24, 1011, 25, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (29, '北京', '2026-04-15', '05:38:00', '18:52:00', '04:11:00', '16:32:00', '残月', '807', 22, 9, '300', '阵雨', '350', '阵雨', 38, '东北风', '1-3', 19, 46, '东北风', '1-3', 19, 1.8, 2, 25, 1012, 24, 56, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (30, '北京', '2026-04-16', '05:37:00', '18:53:00', '04:35:00', '17:42:00', '残月', '807', 17, 8, '101', '多云', '151', '多云', 4, '北风', '1-3', 19, 13, '东北风', '1-3', 17, 0.0, 2, 25, 1010, 23, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (31, '上海', '2026-03-18', '06:02:00', '18:04:00', '05:19:00', '17:20:00', '残月', '807', 13, 6, '305', '小雨', '305', '小雨', 315, '西北风', '1-3', 16, 45, '东北风', '1-3', 3, 4.9, 2, 87, 1022, 24, 91, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (32, '上海', '2026-03-19', '06:01:00', '18:05:00', '05:49:00', '18:23:00', '新月', '800', 13, 6, '101', '多云', '151', '多云', 45, '东北风', '1-3', 3, 90, '东风', '1-3', 3, 0.0, 5, 74, 1021, 24, 3, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (33, '上海', '2026-03-20', '06:00:00', '18:06:00', '06:19:00', '19:28:00', '蛾眉月', '801', 15, 7, '305', '小雨', '104', '阴', 45, '东北风', '1-3', 3, 90, '东风', '1-3', 3, 0.0, 7, 74, 1024, 25, 1, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (34, '上海', '2026-03-21', '05:58:00', '18:06:00', '06:52:00', '20:36:00', '蛾眉月', '801', 16, 10, '101', '多云', '151', '多云', 90, '东风', '1-3', 3, 135, '东南风', '1-3', 3, 0.0, 7, 88, 1020, 25, 1, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (35, '上海', '2026-03-22', '05:57:00', '18:07:00', '07:29:00', '21:47:00', '蛾眉月', '801', 18, 12, '104', '阴', '305', '小雨', 180, '南风', '1-3', 3, 45, '东北风', '1-3', 3, 0.0, 3, 95, 1018, 21, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (36, '上海', '2026-03-23', '05:56:00', '18:08:00', '08:11:00', '22:59:00', '蛾眉月', '801', 16, 10, '305', '小雨', '306', '中雨', 90, '东风', '1-3', 3, 45, '东北风', '1-3', 3, 7.7, 2, 94, 1017, 21, 80, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (37, '上海', '2026-03-24', '05:54:00', '18:08:00', '09:01:00', '00:00:00', '蛾眉月', '801', 13, 10, '305', '小雨', '305', '小雨', 45, '东北风', '1-3', 3, 0, '北风', '1-3', 3, 1.3, 2, 92, 1017, 24, 59, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (38, '上海', '2026-03-25', '05:53:00', '18:09:00', '10:01:00', '00:09:00', '蛾眉月', '801', 16, 11, '305', '小雨', '104', '阴', 45, '东北风', '1-3', 3, 90, '东风', '1-3', 3, 2.4, 2, 95, 1016, 25, 56, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (39, '上海', '2026-03-26', '05:52:00', '18:09:00', '11:07:00', '01:14:00', '上弦月', '802', 16, 10, '305', '小雨', '104', '阴', 180, '南风', '1-3', 3, 45, '东北风', '1-3', 3, 0.0, 8, 97, 1016, 24, 0, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (40, '上海', '2026-03-27', '05:51:00', '18:10:00', '12:18:00', '02:11:00', '盈凸月', '803', 21, 10, '104', '阴', '104', '阴', 90, '东风', '1-3', 3, 135, '东南风', '1-3', 3, 0.0, 3, 63, 1021, 25, 1, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (41, '上海', '2026-03-28', '05:49:00', '18:11:00', '13:29:00', '03:00:00', '盈凸月', '803', 18, 13, '104', '阴', '305', '小雨', 135, '东南风', '1-3', 16, 135, '东南风', '1-3', 16, 0.0, 4, 56, 1020, 25, 1, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (42, '上海', '2026-03-29', '05:48:00', '18:11:00', '14:37:00', '03:39:00', '盈凸月', '803', 17, 12, '305', '小雨', '305', '小雨', 315, '西北风', '1-3', 3, 315, '西北风', '1-3', 16, 1.3, 2, 87, 1023, 23, 55, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (43, '上海', '2026-03-30', '05:47:00', '18:12:00', '15:41:00', '04:13:00', '盈凸月', '803', 16, 9, '104', '阴', '151', '多云', 0, '北风', '1-3', 16, 180, '南风', '1-3', 3, 2.3, 4, 68, 1023, 25, 68, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (44, '上海', '2026-03-31', '05:46:00', '18:13:00', '16:42:00', '04:43:00', '盈凸月', '803', 20, 12, '104', '阴', '104', '阴', 180, '南风', '1-3', 3, 180, '南风', '1-3', 3, 0.0, 4, 80, 1015, 25, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (45, '上海', '2026-04-01', '05:44:00', '18:13:00', '17:41:00', '05:10:00', '盈凸月', '803', 20, 11, '104', '阴', '104', '阴', 225, '西南风', '1-3', 3, 0, '北风', '1-3', 16, 0.6, 2, 63, 1017, 25, 55, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (46, '上海', '2026-04-02', '05:43:00', '18:14:00', '18:39:00', '05:37:00', '满月', '804', 18, 10, '101', '多云', '305', '小雨', 4, '北风', '4-5', 32, 12, '东北风', '3-4', 20, 0.5, 2, 65, 1012, 25, 55, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (47, '上海', '2026-04-03', '05:42:00', '18:15:00', '19:36:00', '06:05:00', '亏凸月', '805', 16, 8, '300', '阵雨', '151', '多云', 259, '西风', '1-3', 6, 167, '东南风', '1-3', 11, 0.8, 2, 81, 1019, 25, 56, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (48, '上海', '2026-04-04', '05:41:00', '18:15:00', '20:34:00', '06:34:00', '亏凸月', '805', 17, 10, '101', '多云', '151', '多云', 160, '东南风', '1-3', 7, 148, '东南风', '1-3', 13, 0.0, 5, 80, 1019, 22, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (49, '上海', '2026-04-05', '05:39:00', '18:16:00', '21:31:00', '07:07:00', '亏凸月', '805', 18, 12, '101', '多云', '305', '小雨', 142, '东南风', '3-4', 20, 116, '东南风', '1-3', 19, 0.0, 2, 79, 1018, 23, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (50, '上海', '2026-04-06', '05:38:00', '18:16:00', '22:28:00', '07:44:00', '亏凸月', '805', 17, 11, '305', '小雨', '153', '晴间多云', 76, '东北风', '5-6', 43, 53, '东北风', '4-5', 32, 8.8, 2, 81, 1018, 25, 62, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (51, '上海', '2026-04-07', '05:37:00', '18:17:00', '23:22:00', '08:26:00', '亏凸月', '805', 15, 10, '100', '晴', '153', '晴间多云', 84, '东风', '4-5', 37, 137, '东南风', '5-6', 39, 0.0, 9, 82, 1018, 22, 20, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (52, '上海', '2026-04-08', '05:36:00', '18:18:00', '00:00:00', '09:14:00', '亏凸月', '805', 18, 13, '305', '小雨', '153', '晴间多云', 185, '南风', '5-6', 39, 267, '西风', '4-5', 32, 9.4, 2, 82, 1018, 25, 63, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (53, '上海', '2026-04-09', '05:34:00', '18:18:00', '00:13:00', '10:08:00', '亏凸月', '805', 19, 12, '103', '晴间多云', '151', '多云', 308, '西北风', '4-5', 37, 294, '西北风', '3-4', 28, 0.0, 6, 80, 1020, 24, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (54, '上海', '2026-04-10', '05:33:00', '18:19:00', '00:58:00', '11:05:00', '下弦月', '806', 19, 12, '101', '多云', '151', '多云', 274, '西风', '1-3', 7, 202, '西南风', '1-3', 6, 0.0, 2, 79, 1019, 22, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (55, '上海', '2026-04-11', '05:32:00', '18:20:00', '01:40:00', '12:05:00', '残月', '807', 19, 10, '101', '多云', '153', '晴间多云', 199, '西南风', '1-3', 13, 197, '西南风', '1-3', 15, 0.0, 2, 79, 1017, 24, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (56, '上海', '2026-04-12', '05:31:00', '18:20:00', '02:16:00', '13:06:00', '残月', '807', 17, 9, '100', '晴', '305', '小雨', 166, '东南风', '4-5', 30, 158, '东南风', '4-5', 32, 0.0, 9, 79, 1018, 23, 5, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (57, '上海', '2026-04-13', '05:30:00', '18:21:00', '02:49:00', '14:07:00', '残月', '807', 20, 13, '100', '晴', '150', '晴', 268, '西风', '3-4', 28, 62, '东北风', '1-3', 19, 0.0, 9, 79, 1019, 23, 5, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (58, '上海', '2026-04-14', '05:29:00', '18:22:00', '03:19:00', '15:08:00', '残月', '807', 20, 13, '100', '晴', '151', '多云', 117, '东南风', '4-5', 30, 134, '东南风', '4-5', 30, 0.0, 10, 81, 1019, 25, 10, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (59, '上海', '2026-04-15', '05:27:00', '18:22:00', '03:49:00', '16:10:00', '残月', '807', 20, 14, '305', '小雨', '305', '小雨', 141, '东南风', '4-5', 37, 152, '东南风', '4-5', 35, 5.5, 2, 82, 1017, 23, 60, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (60, '上海', '2026-04-16', '05:26:00', '18:23:00', '04:18:00', '17:13:00', '残月', '807', 20, 15, '305', '小雨', '350', '阵雨', 162, '东南风', '1-3', 19, 196, '西南风', '4-5', 37, 9.1, 2, 80, 1019, 25, 63, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (61, '广州', '2026-03-18', '06:34:00', '18:38:00', '05:49:00', '17:57:00', '残月', '807', 28, 17, '101', '多云', '151', '多云', 0, '北风', '1-3', 3, 0, '北风', '1-3', 3, 0.0, 8, 64, 1012, 25, 16, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (62, '广州', '2026-03-19', '06:33:00', '18:38:00', '06:23:00', '18:55:00', '新月', '800', 27, 19, '101', '多云', '151', '多云', 0, '北风', '1-3', 3, 0, '北风', '1-3', 3, 0.0, 2, 69, 1012, 25, 12, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (63, '广州', '2026-03-20', '06:32:00', '18:38:00', '06:57:00', '19:55:00', '蛾眉月', '801', 27, 19, '101', '多云', '151', '多云', 0, '北风', '1-3', 3, 0, '北风', '1-3', 3, 1.0, 3, 73, 1015, 25, 80, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (64, '广州', '2026-03-21', '06:31:00', '18:39:00', '07:36:00', '20:58:00', '蛾眉月', '801', 27, 18, '101', '多云', '151', '多云', 0, '北风', '1-3', 3, 0, '北风', '1-3', 3, 0.0, 6, 73, 1014, 25, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (65, '广州', '2026-03-22', '06:30:00', '18:39:00', '08:17:00', '22:03:00', '蛾眉月', '801', 28, 19, '101', '多云', '151', '多云', 180, '南风', '1-3', 16, 0, '北风', '1-3', 3, 0.0, 3, 68, 1013, 25, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (66, '广州', '2026-03-23', '06:29:00', '18:39:00', '09:04:00', '23:11:00', '蛾眉月', '801', 28, 20, '101', '多云', '151', '多云', 180, '南风', '1-3', 16, 0, '北风', '1-3', 3, 0.0, 3, 68, 1010, 25, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (67, '广州', '2026-03-24', '06:28:00', '18:40:00', '09:58:00', '00:00:00', '蛾眉月', '801', 29, 21, '100', '晴', '151', '多云', 0, '北风', '1-3', 3, 0, '北风', '1-3', 3, 0.0, 3, 67, 1010, 25, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (68, '广州', '2026-03-25', '06:27:00', '18:40:00', '10:59:00', '00:20:00', '蛾眉月', '801', 28, 18, '100', '晴', '150', '晴', 180, '南风', '1-3', 3, 180, '南风', '1-3', 3, 0.0, 10, 66, 1011, 25, 3, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (69, '广州', '2026-03-26', '06:26:00', '18:41:00', '12:05:00', '01:25:00', '上弦月', '802', 29, 19, '100', '晴', '150', '晴', 180, '南风', '1-3', 3, 135, '东南风', '1-3', 3, 0.0, 9, 61, 1011, 25, 7, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (70, '广州', '2026-03-27', '06:25:00', '18:41:00', '13:13:00', '02:23:00', '盈凸月', '803', 30, 21, '101', '多云', '151', '多云', 180, '南风', '1-3', 3, 180, '南风', '1-3', 3, 0.0, 10, 65, 1011, 25, 7, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (71, '广州', '2026-03-28', '06:24:00', '18:41:00', '14:20:00', '03:14:00', '盈凸月', '803', 30, 20, '101', '多云', '104', '阴', 180, '南风', '1-3', 16, 180, '南风', '1-3', 16, 0.0, 10, 67, 1012, 25, 4, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (72, '广州', '2026-03-29', '06:23:00', '18:42:00', '15:22:00', '03:59:00', '盈凸月', '803', 31, 21, '104', '阴', '104', '阴', 135, '东南风', '1-3', 16, 180, '南风', '1-3', 3, 0.0, 10, 64, 1012, 25, 4, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (73, '广州', '2026-03-30', '06:22:00', '18:42:00', '16:22:00', '04:38:00', '盈凸月', '803', 32, 18, '305', '小雨', '305', '小雨', 0, '北风', '1-3', 3, 0, '北风', '1-3', 16, 0.3, 4, 66, 1014, 23, 55, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (74, '广州', '2026-03-31', '06:21:00', '18:42:00', '17:18:00', '05:12:00', '盈凸月', '803', 23, 19, '104', '阴', '104', '阴', 90, '东风', '1-3', 3, 135, '东南风', '1-3', 3, 1.3, 4, 64, 1014, 25, 61, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (75, '广州', '2026-04-01', '06:20:00', '18:43:00', '18:12:00', '05:44:00', '盈凸月', '803', 28, 20, '305', '小雨', '305', '小雨', 135, '东南风', '1-3', 3, 0, '北风', '1-3', 3, 0.0, 4, 59, 1012, 24, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (76, '广州', '2026-04-02', '06:19:00', '18:43:00', '19:05:00', '06:16:00', '满月', '804', 26, 20, '101', '多云', '153', '晴间多云', 140, '东南风', '1-3', 17, 163, '东南风', '1-3', 19, 1.0, 4, 60, 1010, 24, 55, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (77, '广州', '2026-04-03', '06:19:00', '18:43:00', '19:58:00', '06:48:00', '亏凸月', '805', 27, 20, '101', '多云', '151', '多云', 160, '东南风', '1-3', 15, 171, '南风', '1-3', 17, 1.0, 4, 68, 1010, 25, 55, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (78, '广州', '2026-04-04', '06:18:00', '18:44:00', '20:52:00', '07:21:00', '亏凸月', '805', 27, 19, '101', '多云', '151', '多云', 164, '东南风', '1-3', 19, 174, '南风', '1-3', 19, 0.0, 3, 67, 1013, 23, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (79, '广州', '2026-04-05', '06:17:00', '18:44:00', '21:46:00', '07:58:00', '亏凸月', '805', 27, 20, '300', '阵雨', '350', '阵雨', 168, '东南风', '3-4', 24, 166, '东南风', '3-4', 24, 0.8, 3, 67, 1011, 23, 57, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (80, '广州', '2026-04-06', '06:16:00', '18:44:00', '22:40:00', '08:38:00', '亏凸月', '805', 27, 20, '302', '雷阵雨', '350', '阵雨', 178, '南风', '1-3', 19, 150, '东南风', '1-3', 17, 1.8, 3, 68, 1011, 25, 64, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (81, '广州', '2026-04-07', '06:15:00', '18:45:00', '23:33:00', '09:22:00', '亏凸月', '805', 27, 20, '302', '雷阵雨', '151', '多云', 143, '东南风', '3-4', 24, 170, '南风', '3-4', 24, 1.7, 3, 65, 1011, 25, 64, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (82, '广州', '2026-04-08', '06:14:00', '18:45:00', '00:00:00', '10:11:00', '亏凸月', '805', 27, 21, '302', '雷阵雨', '153', '晴间多云', 201, '西南风', '4-5', 30, 172, '南风', '4-5', 30, 2.1, 4, 68, 1013, 25, 64, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (83, '广州', '2026-04-09', '06:13:00', '18:46:00', '00:24:00', '11:05:00', '亏凸月', '805', 27, 21, '302', '雷阵雨', '302', '雷阵雨', 108, '东南风', '1-3', 7, 124, '东南风', '1-3', 11, 15.9, 3, 66, 1012, 25, 70, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (84, '广州', '2026-04-10', '06:12:00', '18:46:00', '01:11:00', '12:01:00', '下弦月', '806', 26, 20, '302', '雷阵雨', '302', '雷阵雨', 167, '东南风', '1-3', 19, 303, '西北风', '1-3', 15, 16.2, 3, 68, 1013, 23, 70, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (85, '广州', '2026-04-11', '06:11:00', '18:46:00', '01:55:00', '12:57:00', '残月', '807', 27, 18, '103', '晴间多云', '150', '晴', 354, '北风', '3-4', 20, 16, '东北风', '1-3', 15, 0.0, 5, 65, 1010, 23, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (86, '广州', '2026-04-12', '06:10:00', '18:47:00', '02:35:00', '13:54:00', '残月', '807', 27, 19, '101', '多云', '153', '晴间多云', 327, '西北风', '1-3', 6, 177, '南风', '1-3', 11, 0.0, 7, 65, 1013, 24, 25, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (87, '广州', '2026-04-13', '06:09:00', '18:47:00', '03:11:00', '14:50:00', '残月', '807', 26, 21, '302', '雷阵雨', '302', '雷阵雨', 63, '东北风', '1-3', 6, 85, '东风', '1-3', 6, 15.1, 4, 66, 1011, 25, 69, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (88, '广州', '2026-04-14', '06:08:00', '18:47:00', '03:47:00', '15:46:00', '残月', '807', 27, 21, '300', '阵雨', '350', '阵雨', 131, '东南风', '4-5', 30, 167, '东南风', '4-5', 30, 2.6, 3, 67, 1014, 25, 65, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (89, '广州', '2026-04-15', '06:07:00', '18:48:00', '04:21:00', '16:43:00', '残月', '807', 28, 21, '300', '阵雨', '151', '多云', 173, '南风', '5-6', 39, 170, '南风', '5-6', 39, 1.1, 5, 66, 1011, 25, 60, '2026-03-18 17:02:00');
INSERT INTO travel_rag.weather_data (id, city, fx_date, sunrise, sunset, moonrise, moonset, moon_phase, moon_phase_icon, temp_max, temp_min, icon_day, text_day, icon_night, text_night, wind360_day, wind_dir_day, wind_scale_day, wind_speed_day, wind360_night, wind_dir_night, wind_scale_night, wind_speed_night, precip, uv_index, humidity, pressure, vis, cloud, update_time) VALUES (90, '广州', '2026-04-16', '06:06:00', '18:48:00', '04:55:00', '17:42:00', '残月', '807', 28, 22, '300', '阵雨', '153', '晴间多云', 174, '南风', '5-6', 39, 162, '东南风', '4-5', 37, 0.6, 6, 65, 1013, 25, 56, '2026-03-18 17:02:00');
commit;
Reference in New Issue View Git Blame Copy Permalink