__PACKAGE__->table('tblSubNet');
__PACKAGE__->add_columns(
    'id'          => { data_type=>'int',          is_auto_increment=>1 },
    'ip'          => { data_type=>'varchar', size=>15                  },
    'mask'        => { data_type=>'int'                                },
    'name'        => { data_type=>'varchar', size=>255, is_nullable=>1 },
    'start'       => { data_type=>'int'                                }, # the IP address as A 32 bit number
    'bitpattern'  => { data_type=>'varchar', size=>32                  },
);
__PACKAGE__->set_primary_key('id');
__PACKAGE__->add_unique_constraint(['bitpattern']);