diff options
Diffstat (limited to 'local/db.pm')
-rw-r--r-- | local/db.pm | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/local/db.pm b/local/db.pm index dbb5d7d..517eadb 100644 --- a/local/db.pm +++ b/local/db.pm @@ -31,6 +31,8 @@ local::db::seen->table('seen'); local::db::seen->columns(All => qw/seen_id download user/); local::db::seen->has_a(download => 'local::db::download'); local::db::seen->has_a(user => 'local::db::owner'); +local::db::seen->set_sql(count_download => qq{ SELECT COUNT(user) as dlcount ,download FROM seen GROUP BY download }); + package local::db::ip; use base 'local::db::dbi'; |