Created
October 15, 2015 12:53
-
-
Save deweller/172471b6fc11384be8c9 to your computer and use it in GitHub Desktop.
Upgrade counterparty sqlite db from undolog branch
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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