Files
ln-bi/migrations/20261030_asset_history_daily.sql
shishengliang 3ef30215e0
ci/woodpecker/push/woodpecker Pipeline was successful
feat(assets): 每天23:55采集资产状态快照
2026-10-30 16:57:33 +08:00

5 lines
336 B
SQL

-- Run once after 20261019_asset_history.sql; stop old capture workers before migration.
-- Existing YYYY-MM keys and archived vehicle rows remain unchanged.
ALTER TABLE bi_asset_history_batches CHANGE COLUMN period_month period_key CHAR(10) NOT NULL;
ALTER TABLE bi_asset_history_settings ADD COLUMN daily_enabled_at DATETIME(3) NULL;