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