diff options
Diffstat (limited to 'src/backenddb/merchant-0005.sql')
| -rw-r--r-- | src/backenddb/merchant-0005.sql | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/src/backenddb/merchant-0005.sql b/src/backenddb/merchant-0005.sql index 5c01e55b..a0e283fa 100644 --- a/src/backenddb/merchant-0005.sql +++ b/src/backenddb/merchant-0005.sql @@ -35,6 +35,7 @@ ALTER TABLE merchant_tip_reserve_keys ADD COLUMN master_pub BYTEA NOT NULL CHECK (LENGTH(master_pub)=32); ALTER TABLE merchant_transfers + ADD COLUMN ready_time INT8 NOT NULL DEFAULT (0), ADD COLUMN failed BOOLEAN NOT NULL DEFAULT FALSE, ADD COLUMN validation_status INT4 DEFAULT NULL; COMMENT ON COLUMN merchant_transfers.failed @@ -42,12 +43,12 @@ COMMENT ON COLUMN merchant_transfers.failed COMMENT ON COLUMN merchant_transfers.validation_status IS 'Taler error code describing the state of the validation'; ---CREATE INDEX merchant_transfers_by_open --- ON merchant_transfers --- (ready_time ASC) --- WHERE confirmed AND NOT (failed OR verified); ---COMMENT ON INDEX merchant_transfers_by_open --- IS 'For select_open_transfers'; +CREATE INDEX merchant_transfers_by_open + ON merchant_transfers + (ready_time ASC) + WHERE confirmed AND NOT (failed OR verified); +COMMENT ON INDEX merchant_transfers_by_open + IS 'For select_open_transfers'; ALTER TABLE merchant_accounts |