movilba
MOVILBA-672
· child of MOVILBA-667 Simplificar MovilBA: censo de tablas, columnas, vistas, rutas y pantallas que nada usa, para quitarlas Done
Removal candidate: public.verification_tokens
Done normal
dmdb04-mba-l-ca
Candidate census (read-only): public.verification_tokens exact count 0/0 PROD/DEV; no current src/ token-table reader or view/routine dependency. The app's current email-verification flow stores its token on users.email_verification_token and auth uses a custom Credentials/Keycloak config without DrizzleAdapter; only generated schema and a stale DB comment identify this table as NextAuth tokens. Counters are 0/0/0; reset/last-write time unavailable. Follow-up: verify framework/runtime implications and grants/dependencies before proposing removal. Do not drop here.
Activity
-
parent=#4252
-
db04-mba-l-ca / db
-
2026-10-02 SELECT-only census + guarded DDL draft. PROD/DEV exact count 0/0; owner postgres/movilba_user; PROD broad relacl, DEV NULL; no FK, user trigger, dependent view, or routine-body reference. App code uses users.email_verification_token, not this table. Two dated offline exporter scripts DO read it: tools/2025-09-24-export_db.py:57 and tools/2025-09-03-export_db.py:65, so running those after DROP would fail; coder03 asked whether they must remain runnable. Joint 668/672 draft /data-lezama/movilba/migration-evidence/2026-10-02-movilba-668-672-drop-empty-tables-DEV-Y-PROD.sql. PROD+DEV ROLLBACK rehearsals PASS; DEV mutant with one inserted token raises expected 'lineas_transporte 0, verification_tokens 1'; test row rolled back (live count 0). Audit pending; no apply until reader disposition.
-
audit pass: DDL structural review only, same script as MOVILBA-668
payload
{"scope":"DDL structural review only, same script as MOVILBA-668","outcome":"pass","evidence":"see MOVILBA-668 audit event, same preflight/postflight/lock-and-count pattern applied to verification_tokens. Apply held on coder03's exporter-script disposition, not on this review","reportRef":null} -
2026-10-02 coder03 ruling: the dated offline export scripts need not remain runnable after verification_tokens DROP; their removal candidate is MOVILBA-673, owned separately by coder03assistant. Migration header updated to cite 673 only; SQL body unchanged from successful ROLLBACK and negative-control rehearsals. Audit must verdict the revised checksum before apply.
-
audit pass: re-bound to SHA256 6fcd0e9f, header-only change (MOVILBA-673 disposition ref), body identical to prior PASS
payload
{"scope":"re-bound to SHA256 6fcd0e9f, header-only change (MOVILBA-673 disposition ref), body identical to prior PASS","outcome":"pass","evidence":"sha256sum matches db04's claim; diffed header lines 1-6, rest of file unchanged from prior audited version","reportRef":null} -
2026-10-02: Same applied migration as MOVILBA-668, sha256 6fcd0e9f9a058ae39132a23eb160d528e8bcb7f8a16466b29925da902f907002. PROD then DEV, each count 0/0 under lock, COMMIT; postchecks verify targets absent and shared deps intact. Generated Drizzle diff awaits audit before SHIP. MOVILBA-673 owns stale dated exporters.
-
2026-10-02 14:36 ART | Expanded static scan found no references in scripts/, api-external/, docs/reference/parque-movil-api/, or systemd units. This table was already dropped by db04 under the audited guarded 668/672 migration (SHA-256 6fcd0e9f9a058ae39132a23eb160d528e8bcb7f8a16466b29925da902f907002), PROD then DEV; current table absence is not a new action by this lane.
-
coder03-mba-l-cc 2026-10-02 14:48 ART: table dropped in PROD then DEV by db04 with audit PASS (SQL sha 6fcd0e9f); SQL, README row and regenerated drizzle mirror shipped as v5.6.149 (main 1752e730). PROD, dev01 and pod all report 149 (pod serviceId 21324 confirmed by proxy-mba-w-cc).
cleanup
2w ago by coder03assistant-mba-l-ca
2w ago
2026-10-02 17:47