Skip to content

Instantly share code, notes, and snippets.

@ZenGround0

ZenGround0/cleanup-pdp.sql

Created January 25, 2025 06:35
Show Gist options
  • Save ZenGround0/ea94a34d92da7deb12154a0dac5f1a7c to your computer and use it in GitHub Desktop.
Save ZenGround0/ea94a34d92da7deb12154a0dac5f1a7c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cleanup-pdp.sql
-- Clear tables in correct order (respecting foreign key constraints)
TRUNCATE TABLE curio.pdp_proof_sets CASCADE;
TRUNCATE TABLE curio.pdp_piecerefs CASCADE;
TRUNCATE TABLE curio.pdp_proofset_root_adds CASCADE;
TRUNCATE TABLE curio.pdp_proofset_roots CASCADE;
TRUNCATE TABLE curio.pdp_prove_tasks CASCADE;
TRUNCATE TABLE curio.pdp_proofset_creates CASCADE;
TRUNCATE TABLE curio.pdp_piece_uploads CASCADE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment