Commit | Line | Data |
80021def |
1 | package # hide from PAUSE |
4e298a80 |
2 | DBICTest::Schema::Employee; |
80021def |
3 | |
660cf1be |
4 | use base qw/DBICTest::BaseResult/; |
80021def |
5 | |
ff657a43 |
6 | __PACKAGE__->load_components(qw( Ordered )); |
80021def |
7 | |
38e48163 |
8 | __PACKAGE__->table('employee'); |
80021def |
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 | }, |
169bb185 |
18 | group_id => { |
19 | data_type => 'integer', |
20 | is_nullable => 1, |
21 | }, |
1d941d67 |
22 | group_id_2 => { |
23 | data_type => 'integer', |
24 | is_nullable => 1, |
25 | }, |
9beded8a |
26 | group_id_3 => { |
27 | data_type => 'integer', |
28 | is_nullable => 1, |
29 | }, |
80021def |
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 | |
dc66dea1 |
40 | #__PACKAGE__->add_unique_constraint(position_group => [ qw/position group_id/ ]); |
92b0ca0f |
41 | |
80021def |
42 | __PACKAGE__->mk_classdata('field_name_for', { |
43 | employee_id => 'primary key', |
44 | position => 'list position', |
169bb185 |
45 | group_id => 'collection column', |
80021def |
46 | name => 'employee name', |
47 | }); |
48 | |
49 | 1; |