clear_db.sql

TRUNCATE TABLE account CASCADE;
TRUNCATE TABLE average_block_time_from_genesis CASCADE;
TRUNCATE TABLE average_block_time_per_day CASCADE;
TRUNCATE TABLE average_block_time_per_hour CASCADE;
TRUNCATE TABLE average_block_time_per_minute CASCADE;
TRUNCATE TABLE block CASCADE;
TRUNCATE TABLE community_pool CASCADE;
TRUNCATE TABLE distribution_params CASCADE;
TRUNCATE TABLE double_sign_evidence CASCADE;
TRUNCATE TABLE double_sign_vote CASCADE;
TRUNCATE TABLE fee_grant_allowance CASCADE;
TRUNCATE TABLE genesis CASCADE;
TRUNCATE TABLE gov_params CASCADE;
TRUNCATE TABLE inflation CASCADE;
TRUNCATE TABLE message CASCADE;
TRUNCATE TABLE mint_params CASCADE;
TRUNCATE TABLE modules CASCADE;
TRUNCATE TABLE pre_commit CASCADE;
TRUNCATE TABLE proposal CASCADE;
TRUNCATE TABLE proposal_deposit CASCADE;
TRUNCATE TABLE proposal_staking_pool_snapshot CASCADE;
TRUNCATE TABLE proposal_tally_result CASCADE;
TRUNCATE TABLE proposal_validator_status_snapshot CASCADE;
TRUNCATE TABLE proposal_vote CASCADE;
TRUNCATE TABLE pruning CASCADE;
TRUNCATE TABLE slashing_params CASCADE;
TRUNCATE TABLE staking_params CASCADE;
TRUNCATE TABLE staking_pool CASCADE;
TRUNCATE TABLE supply CASCADE;
TRUNCATE TABLE token CASCADE;
TRUNCATE TABLE token_price CASCADE;
TRUNCATE TABLE token_price_history CASCADE;
TRUNCATE TABLE token_unit CASCADE;
TRUNCATE TABLE transaction CASCADE;
TRUNCATE TABLE transaction_0 CASCADE;
TRUNCATE TABLE validator CASCADE;
TRUNCATE TABLE validator_commission CASCADE;
TRUNCATE TABLE validator_description CASCADE;
TRUNCATE TABLE validator_info CASCADE;
TRUNCATE TABLE validator_signing_info CASCADE;
TRUNCATE TABLE validator_status CASCADE;
TRUNCATE TABLE validator_voting_power CASCADE;
TRUNCATE TABLE vesting_account CASCADE;
TRUNCATE TABLE vesting_period CASCADE;