1 package DBICTest::Schema::Event;
6 use base qw/DBICTest::BaseResult/;
8 __PACKAGE__->load_components(qw/InflateColumn::DateTime/);
10 __PACKAGE__->table('event');
12 __PACKAGE__->add_columns(
13 id => { data_type => 'integer', is_auto_increment => 1 },
15 # this MUST be 'date' for the Firebird and SQLAnywhere tests
16 starts_at => { data_type => 'date', datetime_undef_if_invalid => 1 },
18 created_on => { data_type => 'timestamp' },
19 varchar_date => { data_type => 'varchar', size => 20, is_nullable => 1 },
20 varchar_datetime => { data_type => 'varchar', size => 20, is_nullable => 1 },
21 skip_inflation => { data_type => 'datetime', inflate_datetime => 0, is_nullable => 1 },
22 ts_without_tz => { data_type => 'datetime', is_nullable => 1 }, # used in EventTZPg
25 __PACKAGE__->set_primary_key('id');
27 # Test add_columns '+colname' to augment a column definition.
28 __PACKAGE__->add_columns(
32 '+varchar_datetime' => {
33 inflate_datetime => 1,