admin
d272e52ba0
CI (SIAX Cloud) / integration (push) Has been skipped
masterplan-lock / check (pull_request) Successful in 4s
masterplan-lock / check (push) Successful in 13s
Security Scan (SIAX Cloud) / security (push) Successful in 16s
CI (SIAX Cloud) / security (push) Successful in 21s
CI (SIAX Cloud) / security (pull_request) Successful in 18s
Security Scan (SIAX Cloud) / security (pull_request) Successful in 19s
CI (SIAX Cloud) / integration (pull_request) Successful in 27s
CI (SIAX Cloud) / quality (push) Successful in 37s
CI (SIAX Cloud) / quality (pull_request) Successful in 37s
lib/subscriptions-store.ts listSubscriptions() SELECT:ar created_at men sql/001_init.sql definierade aldrig kolumnen — GET /api/subscriptions har alltså ALWAYS brutit mot Postgres i prod (42703 errorMissingColumn, mätt live mot 0pt.app 2026-09-22: 500). Kolumnen är nu ADD:ad live på 0pt-edge-postgres (idempotent IF NOT EXISTS); denna migration gör ändringen reproducerbar. GET svarar nu 200 [].
7 lines
462 B
SQL
7 lines
462 B
SQL
-- 014: subscriptions.created_at — additiv.
|
|
-- lib/subscriptions-store.ts SELECT:ar `created_at` men sql/001_init.sql definierade
|
|
-- aldrig kolumnen, så GET /api/subscriptions (200-kontraktet) bröt mot Postgres
|
|
-- (42703 errorMissingColumn, mätt live 2026-09-22 på 0pt.app). Idempotent; applicerad
|
|
-- live på 0pt-edge-postgres (xh70k0qa0cyju840zsvsgoze) samma pass.
|
|
ALTER TABLE subscriptions ADD COLUMN IF NOT EXISTS created_at timestamptz DEFAULT now();
|