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
|
package DBICTest::Schema::Event;
use strict;
use warnings;
use base qw/DBICTest::BaseResult/;
__PACKAGE__->load_components(qw/InflateColumn::DateTime/);
__PACKAGE__->table('event');
__PACKAGE__->add_columns(
id => { data_type => 'integer', is_auto_increment => 1 },
# this MUST be 'date' for the Firebird and SQLAnywhere tests
starts_at => { data_type => 'date', datetime_undef_if_invalid => 1 },
created_on => { data_type => 'timestamp' },
varchar_date => { data_type => 'varchar', size => 20, is_nullable => 1 },
varchar_datetime => { data_type => 'varchar', size => 20, is_nullable => 1 },
skip_inflation => { data_type => 'datetime', inflate_datetime => 0, is_nullable => 1 },
ts_without_tz => { data_type => 'datetime', is_nullable => 1 }, # used in EventTZPg
);
__PACKAGE__->set_primary_key('id');
# Test add_columns '+colname' to augment a column definition.
__PACKAGE__->add_columns(
'+varchar_date' => {
inflate_date => 1,
},
'+varchar_datetime' => {
inflate_datetime => 1,
},
);
1;
|
