m
484498d989
- golang-migrate embarqué via embed (db/migrations/*.sql), MigrateDatabase(url) au boot
- ids TEXT 32-hex avec CHECK ~ '^[0-9a-f]{32}$' ; operations idempotentes UNIQUE(device_id, operation_id)
- harness db/migrations_test.go (up → assertions schéma → down, skip si PG indisponible)
- DB dev fraîche vaultdrop_dev (la DB vaultdrop héberge un prototype V2 abandonné)
3 lines
112 B
SQL
3 lines
112 B
SQL
DROP INDEX IF EXISTS idx_ocr_jobs_file;
|
|
DROP INDEX IF EXISTS idx_ocr_jobs_status;
|
|
DROP TABLE IF EXISTS ocr_jobs; |