diff options
| author | Christian Grothoff <christian@grothoff.org> | 2020-04-25 22:32:36 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2020-04-25 22:32:36 +0200 |
| commit | 46aa711262566b7a8f358cbe684c64ed526a5edb (patch) | |
| tree | f4defe802906f061e66ba1ce82247f3c4c8d1f1b /src/backenddb/merchant-0001.sql | |
| parent | 23750b7d0622c7080ff8acde2b623568b98a88f4 (diff) | |
misc bugfixes
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 f49c2cc6..a4f720ee 100644 --- a/src/backenddb/merchant-0001.sql +++ b/src/backenddb/merchant-0001.sql @@ -129,8 +129,8 @@ CREATE TABLE IF NOT EXISTS merchant_inventory ,price_val INT8 NOT NULL ,price_frac INT4 NOT NULL ,total_stock BIGINT NOT NULL - ,total_sold BIGINT NOT NULL - ,total_lost BIGINT NOT NULL + ,total_sold BIGINT NOT NULL DEFAULT 0 + ,total_lost BIGINT NOT NULL DEFAULT 0 ,address BYTEA NOT NULL ,next_restock INT8 NOT NULL ,UNIQUE (merchant_serial, product_id) |