movilba MOVILBA-702 · child of MOVILBA-667 Simplificar MovilBA: censo de tablas, columnas, vistas, rutas y pantallas que nada usa, para quitarlas Done

Removal candidate: empty public.accounts and dependent views

Done normal dmdb04-mba-l-ca

Whole-table candidate public.accounts, 0 rows in PROD/DEV. Five installed views are dependency descendants; retire them in dependency order under guarded no-CASCADE DDL before dropping accounts. Authorized direction coder03-mba-l-cc 2026-10-02. Dated export_db.py readers belong to MOVILBA-673.

Sub-tickets — 5/5 done

Column candidate: public.accounts.access_token

MOVILBA-691 Canceled

cmcoder03assistant-mba-l-ca

Column candidate: public.accounts.provider_account_id

MOVILBA-692 Canceled

cmcoder03assistant-mba-l-ca

Column candidate: public.accounts.refresh_token

MOVILBA-693 Canceled

cmcoder03assistant-mba-l-ca

Column candidate: public.accounts.session_state

MOVILBA-694 Canceled

cmcoder03assistant-mba-l-ca

Column candidate: public.accounts.token_type

MOVILBA-695 Canceled

cmcoder03assistant-mba-l-ca

+ Add sub-ticket

Activity

db04-mba-l-ca created · 2w ago

parent=#4252
db04-mba-l-ca progress · 2w ago

2026-10-02 guarded DDL draft /data-lezama/movilba/migration-evidence/2026-10-02-movilba-702-drop-accounts-views-DEV-Y-PROD.sql sha256 a7dfce7f. Dependency graph measured in both bases: accounts -> auth_methods_stats/footprint_detalle/sin_login; footprint_detalle -> footprint; footprint -> sin_login/dominio_falso. No src/scripts/tools/api-external direct view readers; systemd movilba-sync services invoke scripts/sync-to-api.ts, also no reader. Dated export_db.py accounts SELECT belongs to 673. PROD and DEV rollback rehearsals both DROP 5 views + empty table and ROLLBACK; postchecks show all six still installed, accounts 0 rows. Audit requested; NO APPLY.

audit-mba-l-cc audited · 2w ago

audit pass: DDL structural review only, same script covers 701/703/676/678/679

payload

{"scope":"DDL structural review only, same script covers 701/703/676/678/679","outcome":"pass","evidence":"topo drop order valid (leaves first, accounts last), dependency-edge EXCEPT ALL check both directions, 0 rows locked, outgoing FK to users unchanged, no CASCADE. Grep confirms 0 runtime readers in src/scripts/tools/api-external, only docs/migration-archive hits","reportRef":null}

db04-mba-l-ca progress · 2w ago

2026-10-02 APPLIED audited SHA256 a7dfce7fb673721cddc0ad4d5aab2cf6f69dad86af6789e498eff5d11382f1f4 PROD then DEV. Both legs counted accounts=0 under ACCESS EXCLUSIVE lock, dropped five views in dependency order and accounts, COMMIT. Read-only postchecks in both: all six regclasses NULL; users remains. DEV introspection regenerated schema.ts and relations.ts; diff removes only accounts and five pgView exports/relations. Applied SQL copied byte-identical to docs/migrations/; generated mirror awaits audit before SHIP. MOVILBA-673 owns dated exporter readers.

audit-mba-l-cc audited · 2w ago

audit pass: post-apply schema.ts/relations.ts regen diff

payload

{"scope":"post-apply schema.ts/relations.ts regen diff","outcome":"pass","evidence":"pure deletion diff: accounts + 5 views + accounts import/relation removed, nothing else touched. No reorder, no unrelated drift","reportRef":null}

coder03-mba-l-cc completed · 2w ago

coder03-mba-l-cc 2026-10-02 14:52 ART: applied PROD then DEV by db04 with audit PASS; SQL, README row and regenerated drizzle mirror (combined audit PASS) shipped as v5.6.150 on PROD and DEV; pod push requested from proxy-mba-w-cc.
coder03-mba-l-cc note · 2w ago

coder03-mba-l-cc 2026-10-02 15:03 ART: pod confirmed on 150 by proxy-mba-w-cc (serviceId 21461); PROD, dev01 and pod on the same build.