da36506b89
P0 fixes: - ModelError.Is(): use exact matching instead of substring contains() - shouldClearStickySession: add context param for cancellation/tracing P1 fixes: - TODO stubs: return 501 Not Implemented errors - validateInstanceSignature: deduplicate to shared validateCodeSignature() - Error messages: standardize to English only - http.go: remove pseudo if-else with duplicate branches
11 lines
317 B
SQL
11 lines
317 B
SQL
-- Fix legacy subscription records with invalid expires_at (year > 2099).
|
|
DO $$
|
|
BEGIN
|
|
IF to_regclass('public.user_subscriptions') IS NOT NULL THEN
|
|
UPDATE user_subscriptions
|
|
SET expires_at = TIMESTAMPTZ '2099-12-31 23:59:59+00'
|
|
WHERE expires_at > TIMESTAMPTZ '2099-12-31 23:59:59+00';
|
|
END IF;
|
|
END $$;
|
|
|