Commit | Line | Data |
8273e845 |
1 | package # hide from PAUSE |
c6d74d3e |
2 | MyStarLinkMCPK; |
ea2e61bf |
3 | |
4a233f30 |
4 | use warnings; |
5 | use strict; |
6 | |
ea2e61bf |
7 | use base 'MyBase'; |
8 | |
9 | use MyStar; |
10 | use MyFilm; |
11 | |
ea2e61bf |
12 | # This is a many-to-many mapping table that uses the two foreign keys |
13 | # as its own primary key - there's no extra 'auto-inc' column here |
14 | |
15 | __PACKAGE__->set_table(); |
16 | __PACKAGE__->columns(Primary => qw/film star/); |
17 | __PACKAGE__->columns(All => qw/film star/); |
18 | __PACKAGE__->has_a(film => 'MyFilm'); |
19 | __PACKAGE__->has_a(star => 'MyStar'); |
20 | |
21 | sub create_sql { |
6a3bf251 |
22 | return qq{ |
ea2e61bf |
23 | film INTEGER NOT NULL, |
24 | star INTEGER NOT NULL, |
25 | PRIMARY KEY (film, star) |
26 | }; |
27 | } |
28 | |
29 | 1; |
30 | |