diff options
| -rw-r--r-- | src/exchangedb/common-0001.sql | 37 |
1 files changed, 33 insertions, 4 deletions
diff --git a/src/exchangedb/common-0001.sql b/src/exchangedb/common-0001.sql index 11386b22e..1bf3e6308 100644 --- a/src/exchangedb/common-0001.sql +++ b/src/exchangedb/common-0001.sql @@ -2292,19 +2292,48 @@ BEGIN ; ALTER TABLE IF EXISTS purse_requests - DROP CONSTRAINT IF EXISTS purse_requests_reserve_pub_request_timestamp_pkey + DROP CONSTRAINT IF EXISTS purse_requests_pkey CASCADE + ; + + ALTER TABLE IF EXISTS purse_merges + DROP CONSTRAINT IF EXISTS purse_merges_pkey CASCADE + ; + + ALTER TABLE IF EXISTS account_merges + DROP CONSTRAINT IF EXISTS account_merges_pkey CASCADE + ; + + ALTER TABLE IF EXISTS contracts + DROP CONSTRAINT IF EXISTS contracts_pkey CASCADE + ; + + ALTER TABLE IF EXISTS history_requests + DROP CONSTRAINT IF EXISTS history_requests_pkey CASCADE ; ALTER TABLE IF EXISTS close_requests - DROP CONSTRAINT IF EXISTS close_requests_reserve_pub_close_timestamp_pkey + DROP CONSTRAINT IF EXISTS close_requests_pkey CASCADE ; ALTER TABLE IF EXISTS purse_deposits - DROP CONSTRAINT IF EXISTS purse_deposits_purse_pub_coin_pub_pkey + DROP CONSTRAINT IF EXISTS purse_deposits_pkey CASCADE + ; + + ALTER TABLE IF EXISTS wads_out + DROP CONSTRAINT IF EXISTS wads_out_pkey CASCADE + ; + + ALTER TABLE IF EXISTS wad_out_entries + DROP CONSTRAINT IF EXISTS wad_out_entries_pkey CASCADE ; ALTER TABLE IF EXISTS wads_in - DROP CONSTRAINT IF EXISTS wads_in_wad_id_origin_exchange_url_key CASCADE + DROP CONSTRAINT IF EXISTS wads_in_pkey CASCADE + ,DROP CONSTRAINT IF EXISTS wads_in_wad_id_origin_exchange_url_key + ; + + ALTER TABLE IF EXISTS wad_in_entries + DROP CONSTRAINT IF EXISTS wad_in_entries_pkey CASCADE ; END |