view release on metacpan or  search on metacpan

lib/AproJo/DB/Schema/Result/User.pm  view on Meta::CPAN

package AproJo::DB::Schema::Result::User;

use strict;
use warnings;

use base 'DBIx::Class::Core';

__PACKAGE__->table('users');

__PACKAGE__->add_columns(
  'user_id',
  {data_type => 'integer', is_auto_increment => 1, is_nullable => 0},
  'name',
  {data_type => 'varchar', is_nullable => 0, size => 160},
  'alias',
  {data_type => 'varchar', default_value => '', is_nullable => 1, size => 160},
  'trash',
  {data_type => 'tinyint', default_value => 0, is_nullable => 1},
  'active',
  {data_type => 'tinyint', default_value => 1, is_nullable => 1},
  'mail',
  {data_type => 'varchar', default_value => '', is_nullable => 1, size => 100},
  'password',
  {data_type => 'varchar', is_nullable => 1, size => 254},
);

__PACKAGE__->set_primary_key('user_id');

__PACKAGE__->add_unique_constraint('name', ['name']);

__PACKAGE__->has_many(
  'user_roles',
  'AproJo::DB::Schema::Result::UserRole',
  {'foreign.user_id' => 'self.user_id'},
  {cascade_copy      => 0, cascade_delete => 0},
);

__PACKAGE__->many_to_many('roles', 'user_roles', 'role_id');

__PACKAGE__->has_many(
  'user_groups',
  'AproJo::DB::Schema::Result::UserGroup',
  {'foreign.user_id' => 'self.user_id'},
  {cascade_copy      => 0, cascade_delete => 0},
);

__PACKAGE__->many_to_many('groups', 'user_groups', 'group');

1;