diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-02-21 14:48:07 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-02-21 14:48:07 +0100 |
| commit | fbdb2b127c828ce2feffc0ee72417f51e9b78987 (patch) | |
| tree | 91beaf5d2ad6b654e6ce55dac83ec27bfa7905e1 /src/backenddb/merchant-0004.sql | |
| parent | 1c3fbbf86b82e4ce12855431400ef0f95f0c4273 (diff) | |
-fix SQL
Diffstat (limited to 'src/backenddb/merchant-0004.sql')
| -rw-r--r-- | src/backenddb/merchant-0004.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/backenddb/merchant-0004.sql b/src/backenddb/merchant-0004.sql index 41d1008b..7c86a636 100644 --- a/src/backenddb/merchant-0004.sql +++ b/src/backenddb/merchant-0004.sql @@ -111,8 +111,8 @@ COMMENT ON COLUMN merchant_kyc.aml_decision ALTER TABLE merchant_orders - ADD COLUMN pos_key VARCHAR DEFAULT NULL; - ADD COLUMN pos_algorithm INT4 NOT NULL DEFAULT (0); + ADD COLUMN pos_key VARCHAR DEFAULT NULL, + ADD COLUMN pos_algorithm INT NOT NULL DEFAULT (0); COMMENT ON COLUMN merchant_orders.pos_key IS 'encoded based key which is used for the verification of payment'; @@ -122,8 +122,8 @@ COMMENT ON COLUMN merchant_orders.pos_algorithm ALTER TABLE merchant_contract_terms - ADD COLUMN pos_key VARCHAR DEFAULT NULL; - ADD COLUMN pos_algorithm INT4 NOT NULL DEFAULT (0); + ADD COLUMN pos_key VARCHAR DEFAULT NULL, + ADD COLUMN pos_algorithm INT NOT NULL DEFAULT (0); COMMENT ON COLUMN merchant_contract_terms.pos_key IS 'enconded based key which is used for the verification of payment'; |