From adb999ce2cec29f20f240707bc7278f798d5b94b Mon Sep 17 00:00:00 2001 From: Marco Boss Date: Wed, 6 Apr 2022 11:33:50 +0200 Subject: fix sharding --- src/exchangedb/common-0001.sql | 37 +++++++++++++++++++++++++++++++++---- 1 file 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 -- cgit v1.2.3