More test schema relations for future tests
[dbsrgits/DBIx-Class.git] / t / lib / DBICTest / Schema / Genre.pm
index e72cd93..db2ca9c 100644 (file)
@@ -5,18 +5,19 @@ use strict;
 use base 'DBIx::Class::Core';
 
 __PACKAGE__->table('genre');
-__PACKAGE__->add_columns(qw/genreid name/);
+__PACKAGE__->add_columns(
+    genreid => {
+      data_type => 'integer',
+      is_auto_increment => 1,
+    },
+    name => {
+      data_type => 'varchar',
+      size => 100,
+    },
+);
 __PACKAGE__->set_primary_key('genreid');
+__PACKAGE__->add_unique_constraint ( genre_name => [qw/name/] );
 
-1;
-package DBICTest::Schema::Genre;
-
-use strict;
-
-use base 'DBIx::Class::Core';
-
-__PACKAGE__->table('genre');
-__PACKAGE__->add_columns(qw/genreid name/);
-__PACKAGE__->set_primary_key('genreid');
+__PACKAGE__->has_many (cds => 'DBICTest::Schema::CD', 'genreid');
 
 1;