1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
use utf8;
package ASM::DB::Result::Actionlog;
use strict;
use warnings;
use parent 'DBIx::Class::Core';
__PACKAGE__->load_components('InflateColumn::DateTime');
__PACKAGE__->table('actionlog');
__PACKAGE__->add_columns(
index => { data_type => 'bigint', is_auto_increment => 1, is_nullable => 0 },
time => {
data_type => 'timestamp',
datetime_undef_if_invalid => 1,
default_value => \'current_timestamp',
is_nullable => 0,
},
action => { data_type => 'varchar', is_nullable => 0, size => 20 },
reason => { data_type => 'varchar', is_nullable => 1, size => 512 },
channel => { data_type => 'varchar', is_nullable => 1, size => 51 },
nick => { data_type => 'varchar', is_nullable => 0, size => 17 },
user => { data_type => 'varchar', is_nullable => 1, size => 11 },
host => { data_type => 'varchar', is_nullable => 1, size => 64 },
ip => { data_type => 'integer', is_nullable => 1, extra => { unsigned => 1 } },
gecos => { data_type => 'varchar', is_nullable => 1, size => 512 },
account => { data_type => 'varchar', is_nullable => 1, size => 17 },
bynick => { data_type => 'varchar', is_nullable => 1, size => 17 },
byuser => { data_type => 'varchar', is_nullable => 1, size => 11 },
byhost => { data_type => 'varchar', is_nullable => 1, size => 64 },
bygecos => { data_type => 'varchar', is_nullable => 1, size => 512 },
byaccount => { data_type => 'varchar', is_nullable => 1, size => 17 },
);
__PACKAGE__->set_primary_key('index');
1;
|
