package Foorum::Schema::User;
use strict;
use warnings;
our $VERSION = '1.001000';
use base 'DBIx::Class';
__PACKAGE__->load_components(qw/Core/);
__PACKAGE__->table('user');
__PACKAGE__->add_columns(
'user_id',
{ data_type => 'INT',
default_value => undef,
is_nullable => 0,
size => 11
},
'username',
{ data_type => 'VARCHAR',
default_value => undef,
is_nullable => 0,
size => 32,
},
'password',
{ data_type => 'VARCHAR',
default_value => '000000',
is_nullable => 0,
size => 32,
},
'nickname',
{ data_type => 'VARCHAR',
default_value => undef,
is_nullable => 0,
size => 100,
},
'gender',
{ data_type => 'ENUM',
default_value => 'NA',
is_nullable => 0,
size => 2
},
'email',
{ data_type => 'VARCHAR',
default_value => undef,
is_nullable => 0,
size => 255,
},
'point',
{ data_type => 'INT', default_value => 0, is_nullable => 0, size => 8 },
'register_time',
{ data_type => 'INT', default_value => 0, is_nullable => 0, size => 11 },
'register_ip',
{ data_type => 'VARCHAR',
default_value => undef,
is_nullable => 0,
size => 32,
},
'last_login_on',
{ data_type => 'INT',
default_value => 0,
is_nullable => 1,
size => 11,
},
'last_login_ip',
{ data_type => 'VARCHAR',
default_value => undef,
is_nullable => 1,
size => 32,
},
'login_times',
{ data_type => 'MEDIUMINT',
default_value => 1,
is_nullable => 0,
size => 8
},
'status',
{ data_type => 'ENUM',
default_value => 'unverified',
is_nullable => 0,
size => 10,
},
'threads',
{ data_type => 'INT', default_value => 0, is_nullable => 0, size => 11 },
'replies',
{ data_type => 'INT', default_value => 0, is_nullable => 0, size => 11 },
'lang',
{ data_type => 'CHAR',
default_value => 'cn',
is_nullable => 1,
size => 2
},
'country',
{ data_type => 'CHAR',
default_value => 'cn',
is_nullable => 1,
size => 2
},
'state_id',
{ data_type => 'INT', default_value => 0, is_nullable => 0, size => 11 },
'city_id',
{ data_type => 'INT', default_value => 0, is_nullable => 0, size => 11 },
);
__PACKAGE__->set_primary_key('user_id');
__PACKAGE__->add_unique_constraint( 'email', ['email'] );
__PACKAGE__->add_unique_constraint( 'username', ['username'] );
__PACKAGE__->might_have(
'details' => 'Foorum::Schema::UserDetails',
{ 'foreign.user_id' => 'self.user_id' }
);
__PACKAGE__->resultset_class('Foorum::ResultSet::User');
1;
__END__
=pod
=head1 NAME
Foorum::Schema::User - Table 'user'
=head1 COLUMNS
=over 4
=item user_id
INT(11)
NOT NULL, PRIMARY KEY
=item username
VARCHAR(32)
NOT NULL
=item password
VARCHAR(32)
NOT NULL, DEFAULT VALUE '000000'
=item nickname
VARCHAR(100)
NOT NULL
=item gender
ENUM(2)
NOT NULL, DEFAULT VALUE 'NA'
=item email
VARCHAR(255)
NOT NULL
=item point
INT(8)
NOT NULL
=item register_time
INT(11)
NOT NULL
=item register_ip
VARCHAR(32)
NOT NULL
=item last_login_on
INT(11)
=item last_login_ip
VARCHAR(32)
=item login_times
MEDIUMINT(8)
NOT NULL, DEFAULT VALUE '1'
=item status
ENUM(10)
NOT NULL, DEFAULT VALUE 'unverified'
=item threads
INT(11)
NOT NULL
=item replies
INT(11)
NOT NULL
=item lang
CHAR(2)
DEFAULT VALUE 'cn'
=item country
CHAR(2)
DEFAULT VALUE 'cn'
=item state_id
INT(11)
NOT NULL
=item city_id
INT(11)
NOT NULL
=back
=head1 AUTHOR
Fayland Lam <fayland at gmail.com>
=cut