From 79b7424746c7636cd23a7869169431afa6941b06 Mon Sep 17 00:00:00 2001 From: Sebastian Reichel Date: Sat, 8 Dec 2012 23:35:33 +0100 Subject: rename table sells -> sales --- sql/views.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql/views.sql') diff --git a/sql/views.sql b/sql/views.sql index 6ab5ef2..8edfa9f 100644 --- a/sql/views.sql +++ b/sql/views.sql @@ -17,6 +17,6 @@ CREATE VIEW IF NOT EXISTS invoice AS WHERE product = id AND valid_from <= timestamp ORDER BY valid_from DESC LIMIT 1) END AS price - FROM sells INNER JOIN products ON sells.product = products.id + FROM sales INNER JOIN products ON sales.product = products.id ORDER BY timestamp; COMMIT; -- cgit v1.2.3