From 79b7424746c7636cd23a7869169431afa6941b06 Mon Sep 17 00:00:00 2001
From: Sebastian Reichel <sre@ring0.de>
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

