李建琦
6d655c9903
Release / update-version (push) Has been cancelled
Release / build-frontend (push) Has been cancelled
Release / release (push) Has been cancelled
Release / sync-version-file (push) Has been cancelled
CI / shell (push) Canceled after 0s
CI / test (push) Canceled after 0s
CI / frontend (push) Canceled after 0s
CI / golangci-lint (push) Canceled after 0s
Security Scan / backend-security (push) Canceled after 0s
Security Scan / frontend-security (push) Canceled after 0s
15 lines
698 B
SQL
15 lines
698 B
SQL
-- Drop legacy cache token columns that lack the underscore separator.
|
|
-- These were created by GORM's automatic snake_case conversion:
|
|
-- CacheCreation5mTokens → cache_creation5m_tokens (incorrect)
|
|
-- CacheCreation1hTokens → cache_creation1h_tokens (incorrect)
|
|
--
|
|
-- The canonical columns are:
|
|
-- cache_creation_5m_tokens (defined in 001_init.sql)
|
|
-- cache_creation_1h_tokens (defined in 001_init.sql)
|
|
--
|
|
-- Migration 009 already copied data from legacy → canonical columns.
|
|
-- This migration drops the legacy columns to avoid confusion.
|
|
|
|
ALTER TABLE usage_logs DROP COLUMN IF EXISTS cache_creation5m_tokens;
|
|
ALTER TABLE usage_logs DROP COLUMN IF EXISTS cache_creation1h_tokens;
|