From 6855d611161c2236cba7eefb2c51b801c32b8a4b Mon Sep 17 00:00:00 2001
From: Stefano Zacchiroli <zack@upsilon.cc>
Date: Fri, 13 May 2005 11:22:06 +0000
Subject: [PATCH] sql for filling hits table

---
 helm/metadata/sql/rating.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 helm/metadata/sql/rating.sql

diff --git a/helm/metadata/sql/rating.sql b/helm/metadata/sql/rating.sql
new file mode 100644
index 000000000..b34a9fd08
--- /dev/null
+++ b/helm/metadata/sql/rating.sql
@@ -0,0 +1,6 @@
+
+INSERT INTO hits
+SELECT h_occurrence, COUNT(source)
+FROM refObj
+GROUP BY h_occurrence;
+
-- 
2.39.2