[Dbix-class] relationships between schemas

[John Napiorkowski]

Hi,

I have two mysql databases on different boxes with
different connect strings.  However there is a
relationship between some tables between these two
databases.  Of course this relationship is not
enforces inside the database, but that's the way my
the previous consultant set it up and it's not
changing anytime soon.

Basically there is one database with a membership
system and another with a shared album system.  The
membership table in the first has a member_id primary
key, while the album table in the second has a column
called 'member_id' which is a member_id from the
member database.

I created schemas like this for the members table:

package membership::Schema::db::members;

__PACKAGE__->table("members");

__PACKAGE__->add_columns(

  "member_id",

);


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com