diff options
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, |