Skip to content

Instantly share code, notes, and snippets.

@deweller
Created October 15, 2015 12:53
Show Gist options
  • Save deweller/172471b6fc11384be8c9 to your computer and use it in GitHub Desktop.
Save deweller/172471b6fc11384be8c9 to your computer and use it in GitHub Desktop.
Upgrade counterparty sqlite db from undolog branch
DROP TABLE undolog_block;
DROP TABLE undolog;
DROP TRIGGER IF EXISTS _credits_it;
DROP TRIGGER IF EXISTS _credits_ut;
DROP TRIGGER IF EXISTS _credits_dt;
DROP TRIGGER IF EXISTS _debits_it;
DROP TRIGGER IF EXISTS _debits_ut;
DROP TRIGGER IF EXISTS _debits_dt;
DROP TRIGGER IF EXISTS _messages_it;
DROP TRIGGER IF EXISTS _messages_ut;
DROP TRIGGER IF EXISTS _messages_dt;
DROP TRIGGER IF EXISTS _bet_match_resolutions_it;
DROP TRIGGER IF EXISTS _bet_match_resolutions_ut;
DROP TRIGGER IF EXISTS _bet_match_resolutions_dt;
DROP TRIGGER IF EXISTS _order_match_expirations_it;
DROP TRIGGER IF EXISTS _order_match_expirations_ut;
DROP TRIGGER IF EXISTS _order_match_expirations_dt;
DROP TRIGGER IF EXISTS _order_matches_it;
DROP TRIGGER IF EXISTS _order_matches_ut;
DROP TRIGGER IF EXISTS _order_matches_dt;
DROP TRIGGER IF EXISTS _order_expirations_it;
DROP TRIGGER IF EXISTS _order_expirations_ut;
DROP TRIGGER IF EXISTS _order_expirations_dt;
DROP TRIGGER IF EXISTS _orders_it;
DROP TRIGGER IF EXISTS _orders_ut;
DROP TRIGGER IF EXISTS _orders_dt;
DROP TRIGGER IF EXISTS _bet_match_expirations_it;
DROP TRIGGER IF EXISTS _bet_match_expirations_ut;
DROP TRIGGER IF EXISTS _bet_match_expirations_dt;
DROP TRIGGER IF EXISTS _bet_matches_it;
DROP TRIGGER IF EXISTS _bet_matches_ut;
DROP TRIGGER IF EXISTS _bet_matches_dt;
DROP TRIGGER IF EXISTS _bet_expirations_it;
DROP TRIGGER IF EXISTS _bet_expirations_ut;
DROP TRIGGER IF EXISTS _bet_expirations_dt;
DROP TRIGGER IF EXISTS _bets_it;
DROP TRIGGER IF EXISTS _bets_ut;
DROP TRIGGER IF EXISTS _bets_dt;
DROP TRIGGER IF EXISTS _broadcasts_it;
DROP TRIGGER IF EXISTS _broadcasts_ut;
DROP TRIGGER IF EXISTS _broadcasts_dt;
DROP TRIGGER IF EXISTS _btcpays_it;
DROP TRIGGER IF EXISTS _btcpays_ut;
DROP TRIGGER IF EXISTS _btcpays_dt;
DROP TRIGGER IF EXISTS _burns_it;
DROP TRIGGER IF EXISTS _burns_ut;
DROP TRIGGER IF EXISTS _burns_dt;
DROP TRIGGER IF EXISTS _cancels_it;
DROP TRIGGER IF EXISTS _cancels_ut;
DROP TRIGGER IF EXISTS _cancels_dt;
DROP TRIGGER IF EXISTS _dividends_it;
DROP TRIGGER IF EXISTS _dividends_ut;
DROP TRIGGER IF EXISTS _dividends_dt;
DROP TRIGGER IF EXISTS _issuances_it;
DROP TRIGGER IF EXISTS _issuances_ut;
DROP TRIGGER IF EXISTS _issuances_dt;
DROP TRIGGER IF EXISTS _sends_it;
DROP TRIGGER IF EXISTS _sends_ut;
DROP TRIGGER IF EXISTS _sends_dt;
DROP TRIGGER IF EXISTS _rps_match_expirations_it;
DROP TRIGGER IF EXISTS _rps_match_expirations_ut;
DROP TRIGGER IF EXISTS _rps_match_expirations_dt;
DROP TRIGGER IF EXISTS _rps_expirations_it;
DROP TRIGGER IF EXISTS _rps_expirations_ut;
DROP TRIGGER IF EXISTS _rps_expirations_dt;
DROP TRIGGER IF EXISTS _rpsresolves_it;
DROP TRIGGER IF EXISTS _rpsresolves_ut;
DROP TRIGGER IF EXISTS _rpsresolves_dt;
DROP TRIGGER IF EXISTS _rps_matches_it;
DROP TRIGGER IF EXISTS _rps_matches_ut;
DROP TRIGGER IF EXISTS _rps_matches_dt;
DROP TRIGGER IF EXISTS _rps_it;
DROP TRIGGER IF EXISTS _rps_ut;
DROP TRIGGER IF EXISTS _rps_dt;
DROP TRIGGER IF EXISTS _executions_it;
DROP TRIGGER IF EXISTS _executions_ut;
DROP TRIGGER IF EXISTS _executions_dt;
DROP TRIGGER IF EXISTS _storage_it;
DROP TRIGGER IF EXISTS _storage_ut;
DROP TRIGGER IF EXISTS _storage_dt;
DROP TRIGGER IF EXISTS _suicides_it;
DROP TRIGGER IF EXISTS _suicides_ut;
DROP TRIGGER IF EXISTS _suicides_dt;
DROP TRIGGER IF EXISTS _nonces_it;
DROP TRIGGER IF EXISTS _nonces_ut;
DROP TRIGGER IF EXISTS _nonces_dt;
DROP TRIGGER IF EXISTS _postqueue_it;
DROP TRIGGER IF EXISTS _postqueue_ut;
DROP TRIGGER IF EXISTS _postqueue_dt;
DROP TRIGGER IF EXISTS _contracts_it;
DROP TRIGGER IF EXISTS _contracts_ut;
DROP TRIGGER IF EXISTS _contracts_dt;
DROP TRIGGER IF EXISTS _destructions_it;
DROP TRIGGER IF EXISTS _destructions_ut;
DROP TRIGGER IF EXISTS _destructions_dt;
DROP TRIGGER IF EXISTS _assets_it;
DROP TRIGGER IF EXISTS _assets_ut;
DROP TRIGGER IF EXISTS _assets_dt;
DROP TRIGGER IF EXISTS _balances_it;
DROP TRIGGER IF EXISTS _balances_ut;
DROP TRIGGER IF EXISTS _balances_dt;
DROP TRIGGER IF EXISTS _credits_insert;
DROP TRIGGER IF EXISTS _credits_update;
DROP TRIGGER IF EXISTS _credits_delete;
DROP TRIGGER IF EXISTS _debits_insert;
DROP TRIGGER IF EXISTS _debits_update;
DROP TRIGGER IF EXISTS _debits_delete;
DROP TRIGGER IF EXISTS _messages_insert;
DROP TRIGGER IF EXISTS _messages_update;
DROP TRIGGER IF EXISTS _messages_delete;
DROP TRIGGER IF EXISTS _bet_match_resolutions_insert;
DROP TRIGGER IF EXISTS _bet_match_resolutions_update;
DROP TRIGGER IF EXISTS _bet_match_resolutions_delete;
DROP TRIGGER IF EXISTS _order_match_expirations_insert;
DROP TRIGGER IF EXISTS _order_match_expirations_update;
DROP TRIGGER IF EXISTS _order_match_expirations_delete;
DROP TRIGGER IF EXISTS _order_matches_insert;
DROP TRIGGER IF EXISTS _order_matches_update;
DROP TRIGGER IF EXISTS _order_matches_delete;
DROP TRIGGER IF EXISTS _order_expirations_insert;
DROP TRIGGER IF EXISTS _order_expirations_update;
DROP TRIGGER IF EXISTS _order_expirations_delete;
DROP TRIGGER IF EXISTS _orders_insert;
DROP TRIGGER IF EXISTS _orders_update;
DROP TRIGGER IF EXISTS _orders_delete;
DROP TRIGGER IF EXISTS _bet_match_expirations_insert;
DROP TRIGGER IF EXISTS _bet_match_expirations_update;
DROP TRIGGER IF EXISTS _bet_match_expirations_delete;
DROP TRIGGER IF EXISTS _bet_matches_insert;
DROP TRIGGER IF EXISTS _bet_matches_update;
DROP TRIGGER IF EXISTS _bet_matches_delete;
DROP TRIGGER IF EXISTS _bet_expirations_insert;
DROP TRIGGER IF EXISTS _bet_expirations_update;
DROP TRIGGER IF EXISTS _bet_expirations_delete;
DROP TRIGGER IF EXISTS _bets_insert;
DROP TRIGGER IF EXISTS _bets_update;
DROP TRIGGER IF EXISTS _bets_delete;
DROP TRIGGER IF EXISTS _broadcasts_insert;
DROP TRIGGER IF EXISTS _broadcasts_update;
DROP TRIGGER IF EXISTS _broadcasts_delete;
DROP TRIGGER IF EXISTS _btcpays_insert;
DROP TRIGGER IF EXISTS _btcpays_update;
DROP TRIGGER IF EXISTS _btcpays_delete;
DROP TRIGGER IF EXISTS _burns_insert;
DROP TRIGGER IF EXISTS _burns_update;
DROP TRIGGER IF EXISTS _burns_delete;
DROP TRIGGER IF EXISTS _cancels_insert;
DROP TRIGGER IF EXISTS _cancels_update;
DROP TRIGGER IF EXISTS _cancels_delete;
DROP TRIGGER IF EXISTS _dividends_insert;
DROP TRIGGER IF EXISTS _dividends_update;
DROP TRIGGER IF EXISTS _dividends_delete;
DROP TRIGGER IF EXISTS _issuances_insert;
DROP TRIGGER IF EXISTS _issuances_update;
DROP TRIGGER IF EXISTS _issuances_delete;
DROP TRIGGER IF EXISTS _sends_insert;
DROP TRIGGER IF EXISTS _sends_update;
DROP TRIGGER IF EXISTS _sends_delete;
DROP TRIGGER IF EXISTS _rps_match_expirations_insert;
DROP TRIGGER IF EXISTS _rps_match_expirations_update;
DROP TRIGGER IF EXISTS _rps_match_expirations_delete;
DROP TRIGGER IF EXISTS _rps_expirations_insert;
DROP TRIGGER IF EXISTS _rps_expirations_update;
DROP TRIGGER IF EXISTS _rps_expirations_delete;
DROP TRIGGER IF EXISTS _rpsresolves_insert;
DROP TRIGGER IF EXISTS _rpsresolves_update;
DROP TRIGGER IF EXISTS _rpsresolves_delete;
DROP TRIGGER IF EXISTS _rps_matches_insert;
DROP TRIGGER IF EXISTS _rps_matches_update;
DROP TRIGGER IF EXISTS _rps_matches_delete;
DROP TRIGGER IF EXISTS _rps_insert;
DROP TRIGGER IF EXISTS _rps_update;
DROP TRIGGER IF EXISTS _rps_delete;
DROP TRIGGER IF EXISTS _executions_insert;
DROP TRIGGER IF EXISTS _executions_update;
DROP TRIGGER IF EXISTS _executions_delete;
DROP TRIGGER IF EXISTS _storage_insert;
DROP TRIGGER IF EXISTS _storage_update;
DROP TRIGGER IF EXISTS _storage_delete;
DROP TRIGGER IF EXISTS _suicides_insert;
DROP TRIGGER IF EXISTS _suicides_update;
DROP TRIGGER IF EXISTS _suicides_delete;
DROP TRIGGER IF EXISTS _nonces_insert;
DROP TRIGGER IF EXISTS _nonces_update;
DROP TRIGGER IF EXISTS _nonces_delete;
DROP TRIGGER IF EXISTS _postqueue_insert;
DROP TRIGGER IF EXISTS _postqueue_update;
DROP TRIGGER IF EXISTS _postqueue_delete;
DROP TRIGGER IF EXISTS _contracts_insert;
DROP TRIGGER IF EXISTS _contracts_update;
DROP TRIGGER IF EXISTS _contracts_delete;
DROP TRIGGER IF EXISTS _destructions_insert;
DROP TRIGGER IF EXISTS _destructions_update;
DROP TRIGGER IF EXISTS _destructions_delete;
DROP TRIGGER IF EXISTS _assets_insert;
DROP TRIGGER IF EXISTS _assets_update;
DROP TRIGGER IF EXISTS _assets_delete;
DROP TRIGGER IF EXISTS _balances_insert;
DROP TRIGGER IF EXISTS _balances_update;
DROP TRIGGER IF EXISTS _balances_delete;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment