better tests for "smalldatetime" support in MSSQL
[dbsrgits/DBIx-Class-Historic.git] / t / lib / DBICTest / Schema / Employee.pm
1 package # hide from PAUSE 
2     DBICTest::Schema::Employee;
3
4 use base qw/DBICTest::BaseResult/;
5
6 __PACKAGE__->load_components(qw( Ordered ));
7
8 __PACKAGE__->table('employee');
9
10 __PACKAGE__->add_columns(
11     employee_id => {
12         data_type => 'integer',
13         is_auto_increment => 1
14     },
15     position => {
16         data_type => 'integer',
17     },
18     group_id => {
19         data_type => 'integer',
20         is_nullable => 1,
21     },
22     group_id_2 => {
23         data_type => 'integer',
24         is_nullable => 1,
25     },
26     group_id_3 => {
27         data_type => 'integer',
28         is_nullable => 1,
29     },
30     name => {
31         data_type => 'varchar',
32         size      => 100,
33         is_nullable => 1,
34     },
35 );
36
37 __PACKAGE__->set_primary_key('employee_id');
38 __PACKAGE__->position_column('position');
39
40 #__PACKAGE__->add_unique_constraint(position_group => [ qw/position group_id/ ]);
41
42 __PACKAGE__->mk_classdata('field_name_for', {
43     employee_id => 'primary key',
44     position    => 'list position',
45     group_id    => 'collection column',
46     name        => 'employee name',
47 });
48
49 1;