summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOthmar Gsenger <otti@wirdorange.org>2011-01-15 20:28:31 +0000
committerOthmar Gsenger <otti@wirdorange.org>2011-01-15 20:28:31 +0000
commitf93d1f3233a116d93882b05c1bfa40914680e897 (patch)
treed76d0859a0e33cb87825c955704b30af1761bf46
parentdocumented db create (diff)
added ip table
-rw-r--r--local/db.pm8
1 files changed, 8 insertions, 0 deletions
diff --git a/local/db.pm b/local/db.pm
index 9ae4793..0ce5f2e 100644
--- a/local/db.pm
+++ b/local/db.pm
@@ -23,6 +23,7 @@ local::db::owner->table('owner');
local::db::owner->columns(All => qw/owner_id name quoata quota_used/);
local::db::owner->has_many(download => 'local::db::download');
local::db::owner->has_many(seen => 'local::db::seen');
+local::db::owner->has_many(ip => 'local::db::ip');
package local::db::seen;
use base 'local::db::dbi';
@@ -30,3 +31,10 @@ 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');
+
+package local::db::ip;
+use base 'local::db::dbi';
+local::db::ip->table('owner');
+local::db::ip->columns(All => qw/ip_id owner subnet mask/);
+local::db::ip->has_one(owner => 'local::db::owner');
+