diff options
Diffstat (limited to 'sql/views.sql')
| -rw-r--r-- | sql/views.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/views.sql b/sql/views.sql index 4c0a56b..94cbabd 100644 --- a/sql/views.sql +++ b/sql/views.sql @@ -1,5 +1,5 @@ BEGIN TRANSACTION; -CREATE VIEW IF NOT EXISTS stock AS SELECT id, name, amount FROM products WHERE deprecated = 0 OR amount != 0; +CREATE VIEW IF NOT EXISTS stock AS SELECT id, name, category, amount FROM products WHERE deprecated = 0 OR amount != 0; CREATE VIEW IF NOT EXISTS purchaseprices AS SELECT product, SUM(price * amount) / SUM(amount) AS price FROM restock GROUP BY product; CREATE VIEW IF NOT EXISTS invoice AS SELECT user, timestamp, id AS productid, name AS productname, |