diff options
Diffstat (limited to 'src/backenddb')
-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 |