aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMarco Boss <bossm8@bfh.ch>2022-04-06 11:33:50 +0200
committerMarco Boss <bossm8@bfh.ch>2022-04-06 11:33:50 +0200
commitadb999ce2cec29f20f240707bc7278f798d5b94b (patch)
treecd08b70d0c31fa016b630fc14b78956cdfd4111f
parentf3a4b00907410444055f47d4ff2074b44f981ad3 (diff)
fix sharding
-rw-r--r--src/exchangedb/common-0001.sql37
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