diff options
author | Christian Grothoff <christian@grothoff.org> | 2020-06-04 21:00:32 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2020-06-04 21:00:32 +0200 |
commit | 78119045b5eaf622ac3752f6cc7f07d9cc5c2feb (patch) | |
tree | 3f9125a04a1bcc1fd9933bf7c6158a1e1add4f65 /src/backenddb/merchant-0001.sql | |
parent | 59413577cf283700e603192d35f6b060e0135495 (diff) | |
download | merchant-78119045b5eaf622ac3752f6cc7f07d9cc5c2feb.tar.gz merchant-78119045b5eaf622ac3752f6cc7f07d9cc5c2feb.tar.bz2 merchant-78119045b5eaf622ac3752f6cc7f07d9cc5c2feb.zip |
work on GET /private/orders/ID"
Diffstat (limited to 'src/backenddb/merchant-0001.sql')
-rw-r--r-- | src/backenddb/merchant-0001.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql index d74b8527..34e2cb4b 100644 --- a/src/backenddb/merchant-0001.sql +++ b/src/backenddb/merchant-0001.sql @@ -470,8 +470,8 @@ CREATE TABLE IF NOT EXISTS merchant_tips ,expiration INT8 NOT NULL ,amount_val INT8 NOT NULL ,amount_frac INT4 NOT NULL - ,picked_up_val INT8 NOT NULL - ,picked_up_frac INT4 NOT NULL + ,picked_up_val INT8 NOT NULL DEFAULT 0 + ,picked_up_frac INT4 NOT NULL DEFAULT 0 ,was_picked_up BOOLEAN NOT NULL DEFAULT FALSE ); CREATE INDEX IF NOT EXISTS merchant_tips_by_pickup_and_expiration |