davrot/latex-ub
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
latex-ub/services/history-v1/storage/scripts/global-blobs-db-cleanup
History
Exact
root cf640f60aa Init
2025-05-05 12:24:05 +00:00
..
01-create-blob-hashes-table.sql Init 2025-05-05 12:24:05 +00:00
02-set-global-flag.sql Init 2025-05-05 12:24:05 +00:00
03-create-global-blobs-table.sql Init 2025-05-05 12:24:05 +00:00
04-swap-global-blob-tables.sql Init 2025-05-05 12:24:05 +00:00
README.md Init 2025-05-05 12:24:05 +00:00
rollback.sql Init 2025-05-05 12:24:05 +00:00

README.md

Scripts in this directory were used when we cleaned up the global blobs table, ensuring that it only contained global blobs. The scripts are meant to be run in this order:

  • 01-create-blob-hashes-table.sql
  • 02-set-global-flag.sql
  • 03-create-global-blobs-table.sql
  • 04-swap-global-blob-tables.sql

The rollback.sql can be run to reverse the effect of 03-swap-global-blob-tables.sql.