diff options
| author | Sebastian Reichel <sre@ring0.de> | 2013-05-24 00:12:42 +0200 |
|---|---|---|
| committer | Sebastian Reichel <sre@ring0.de> | 2013-05-24 00:12:42 +0200 |
| commit | 591b7537a26b79389eb2295b2c0afc8b4c35df67 (patch) | |
| tree | 641af6c7d554b4f431dc6c003344c13a0e3b021c /sql/views.sql | |
| parent | 1105c32181ebaed1aebad6b44624227e9c83e9ee (diff) | |
| download | serial-barcode-scanner-591b7537a26b79389eb2295b2c0afc8b4c35df67.tar.bz2 | |
add minimal support for deprecation flag
Diffstat (limited to 'sql/views.sql')
| -rw-r--r-- | sql/views.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/views.sql b/sql/views.sql index 8edfa9f..4b138fe 100644 --- a/sql/views.sql +++ b/sql/views.sql @@ -1,4 +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 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, |