1use utf8; 2package App::Netdisco::DB::Result::User; 3 4 5use strict; 6use warnings; 7 8use base 'App::Netdisco::DB::Result'; 9__PACKAGE__->table("users"); 10__PACKAGE__->add_columns( 11 "username", 12 { data_type => "varchar", is_nullable => 0, size => 50 }, 13 "password", 14 { data_type => "text", is_nullable => 1 }, 15 "token", 16 { data_type => "text", is_nullable => 1 }, 17 "token_from", 18 { data_type => "integer", is_nullable => 1 }, 19 "creation", 20 { 21 data_type => "timestamp", 22 default_value => \"current_timestamp", 23 is_nullable => 1, 24 original => { default_value => \"now()" }, 25 }, 26 "last_on", 27 { data_type => "timestamp", is_nullable => 1 }, 28 "port_control", 29 { data_type => "boolean", default_value => \"false", is_nullable => 1 }, 30 "ldap", 31 { data_type => "boolean", default_value => \"false", is_nullable => 1 }, 32 "radius", 33 { data_type => "boolean", default_value => \"false", is_nullable => 1 }, 34 "tacacs", 35 { data_type => "boolean", default_value => \"false", is_nullable => 1 }, 36 "admin", 37 { data_type => "boolean", default_value => \"false", is_nullable => 1 }, 38 "fullname", 39 { data_type => "text", is_nullable => 1 }, 40 "note", 41 { data_type => "text", is_nullable => 1 }, 42); 43__PACKAGE__->set_primary_key("username"); 44 45__PACKAGE__->has_many( roles => 'App::Netdisco::DB::Result::Virtual::UserRole', 46 'username', { cascade_copy => 0, cascade_update => 0, cascade_delete => 0 } ); 47 48sub created { return (shift)->get_column('created') } 49sub last_seen { return (shift)->get_column('last_seen') } 50 511; 52