diff options
author | Christian Grothoff <christian@grothoff.org> | 2022-06-01 23:03:40 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2022-06-01 23:03:49 +0200 |
commit | 00c68e0a04ae25f533e261547cf0847b4ae0de06 (patch) | |
tree | 34a968f43aebc27370b2744a474c6fe1abe6362e /src/exchangedb/common-0001.sql | |
parent | f86eead6d6abe56b772b60c2f4a83a2a40bf3bd8 (diff) | |
download | exchange-00c68e0a04ae25f533e261547cf0847b4ae0de06.tar.gz exchange-00c68e0a04ae25f533e261547cf0847b4ae0de06.tar.bz2 exchange-00c68e0a04ae25f533e261547cf0847b4ae0de06.zip |
-work on SQL for P2P table replication
Diffstat (limited to 'src/exchangedb/common-0001.sql')
-rw-r--r-- | src/exchangedb/common-0001.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/src/exchangedb/common-0001.sql b/src/exchangedb/common-0001.sql index 31c4b68e8..1e5619db7 100644 --- a/src/exchangedb/common-0001.sql +++ b/src/exchangedb/common-0001.sql @@ -1389,7 +1389,8 @@ BEGIN PERFORM create_partitioned_table( 'CREATE TABLE IF NOT EXISTS %I ' - '(reserve_pub BYTEA NOT NULL CHECK (LENGTH(reserve_pub)=32)' -- REFERENCES reserves(reserve_pub) ON DELETE CASCADE + '(history_request_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY' --UNIQUE' + ',reserve_pub BYTEA NOT NULL CHECK (LENGTH(reserve_pub)=32)' -- REFERENCES reserves(reserve_pub) ON DELETE CASCADE ',request_timestamp INT8 NOT NULL' ',reserve_sig BYTEA NOT NULL CHECK (LENGTH(reserve_sig)=64)' ',history_fee_val INT8 NOT NULL' @@ -1418,7 +1419,8 @@ BEGIN PERFORM create_partitioned_table( 'CREATE TABLE IF NOT EXISTS %I ' - '(reserve_pub BYTEA NOT NULL CHECK (LENGTH(reserve_pub)=32)' -- REFERENCES reserves(reserve_pub) ON DELETE CASCADE + '(close_request_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY' --UNIQUE' + ',reserve_pub BYTEA NOT NULL CHECK (LENGTH(reserve_pub)=32)' -- REFERENCES reserves(reserve_pub) ON DELETE CASCADE ',close_timestamp INT8 NOT NULL' ',reserve_sig BYTEA NOT NULL CHECK (LENGTH(reserve_sig)=64)' ',close_val INT8 NOT NULL' @@ -1489,7 +1491,6 @@ END $$; ---------------------------- wads_out ------------------------------- - CREATE OR REPLACE FUNCTION create_table_wads_out( IN shard_suffix VARCHAR DEFAULT NULL ) |