1 package # hide from PAUSE
2 DBICTest::Schema::Year2000CDs;
4 use base 'DBIx::Class::Core::View';
6 __PACKAGE__->view('cd');
7 __PACKAGE__->view_definition("SELECT cdid, artist, title FROM cd WHERE year ='2000'");
8 __PACKAGE__->add_columns(
10 data_type => 'integer',
11 is_auto_increment => 1,
14 data_type => 'integer',
17 data_type => 'varchar',
22 __PACKAGE__->set_primary_key('cdid');
23 __PACKAGE__->add_unique_constraint([ qw/artist title/ ]);