diff options
| author | Sebastian Reichel <sre@ring0.de> | 2015-10-28 05:16:52 +0100 |
|---|---|---|
| committer | Sebastian Reichel <sre@ring0.de> | 2015-10-28 05:44:43 +0100 |
| commit | dbcace5e7de23a48e8686171c7a412a950acc764 (patch) | |
| tree | 4fe561f643f5b405c0621123b053590305363106 /sql/views.sql | |
| parent | a98e611b8a2e86255a5e4cf971260a1d93326b7d (diff) | |
| download | serial-barcode-scanner-dbcace5e7de23a48e8686171c7a412a950acc764.tar.bz2 | |
add product category
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, |