diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-07-29 23:01:06 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-07-29 23:01:15 +0200 |
| commit | e47e5c0cfba7746263775e8bbd4064b640f69020 (patch) | |
| tree | 4d853f7e1d065a198b32dd14d38df179cf288e15 /src/exchangedb/0002-policy_details.sql | |
| parent | ecf6b2750bb6ed9157aece72602dd042a50e36f3 (diff) | |
| download | exchange-e47e5c0cfba7746263775e8bbd4064b640f69020.tar.xz | |
migration to new amount style for exchangedb
Diffstat (limited to 'src/exchangedb/0002-policy_details.sql')
| -rw-r--r-- | src/exchangedb/0002-policy_details.sql | 22 |
1 files changed, 9 insertions, 13 deletions
diff --git a/src/exchangedb/0002-policy_details.sql b/src/exchangedb/0002-policy_details.sql index c9bfd1575..8c53b0dc9 100644 --- a/src/exchangedb/0002-policy_details.sql +++ b/src/exchangedb/0002-policy_details.sql @@ -21,15 +21,11 @@ CREATE TABLE policy_details ,policy_hash_code BYTEA PRIMARY KEY CHECK(LENGTH(policy_hash_code)=16) ,policy_json VARCHAR ,deadline INT8 NOT NULL - ,commitment_val INT8 NOT NULL - ,commitment_frac INT4 NOT NULL - ,accumulated_total_val INT8 NOT NULL - ,accumulated_total_frac INT4 NOT NULL - ,fee_val INT8 NOT NULL - ,fee_frac INT4 NOT NULL - ,transferable_val INT8 NOT NULL - ,transferable_frac INT8 NOT NULL - ,fulfillment_state smallint NOT NULL CHECK(fulfillment_state between 0 and 5) + ,commitment taler_amount NOT NULL + ,accumulated_total taler_amount NOT NULL + ,fee taler_amount NOT NULL + ,transferable taler_amount NOT NULL + ,fulfillment_state SMALLINT NOT NULL CHECK(fulfillment_state between 0 and 5) ,fulfillment_id BIGINT NULL REFERENCES policy_fulfillments (fulfillment_id) ON DELETE CASCADE ); COMMENT ON TABLE policy_details @@ -40,13 +36,13 @@ COMMENT ON COLUMN policy_details.policy_json IS 'JSON object with options set that the exchange needs to consider when executing a deposit. Supported details depend on the policy extensions supported by the exchange.'; COMMENT ON COLUMN policy_details.deadline IS 'Deadline until the policy must be marked as fulfilled (maybe "forever")'; -COMMENT ON COLUMN policy_details.commitment_val +COMMENT ON COLUMN policy_details.commitment IS 'The amount that this policy commits to. Invariant: commitment >= fee'; -COMMENT ON COLUMN policy_details.accumulated_total_val +COMMENT ON COLUMN policy_details.accumulated_total IS 'The sum of all contributions of all deposit that reference this policy. Invariant: The fulfilment_state must be Insufficient as long as accumulated_total < commitment'; -COMMENT ON COLUMN policy_details.fee_val +COMMENT ON COLUMN policy_details.fee IS 'The fee for this policy, due when the policy is fulfilled or timed out'; -COMMENT ON COLUMN policy_details.transferable_val +COMMENT ON COLUMN policy_details.transferable IS 'The amount that on fulfillment or timeout will be transferred to the payto-URI''s of the corresponding deposit''s. The policy fees must have been already deducted from it. Invariant: fee+transferable <= accumulated_total. The remaining amount (accumulated_total - fee - transferable) can be refreshed by the owner of the coins when the state is Timeout or Success.'; COMMENT ON COLUMN policy_details.fulfillment_state IS 'State of the fulfillment: |