LBF Db structure

[Aaron Turner <aturner@linuxkb.org>]

I'm trying to replace the UserCharityXref with a CompanyCharityXref table.
The UserCharityXref schema is:

CREATE TABLE UserCharityXref (
   UniqueID int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   CharityID int(10) DEFAULT '0' NOT NULL,
   UserID int(10) DEFAULT '0' NOT NULL,
   PRIMARY KEY (UniqueID),
   KEY CompanyID_Index (CharityID),
   KEY UserID_Index (UserID),
   KEY UserID_CompanyID_Index (CharityID, UserID)
);

I'm confused though why CompanyID keeps showing up in the KEY's and how I
should deal with them in converting the table schema into a
CompanyCharityXref.

Any help would be great- I can't believe how much I've already done.  Oh,
the perl-DBI list had my answer about the UID question and even better it
doesn't require any SELECT!

$uid = $sth->{mysql_insertid}; 

--
Aaron Turner, Core Developer       http://vodka.linuxkb.org/~aturner/
Linux Knowledge Base Organization  http://linuxkb.org/
Because world domination requires quality open documentation.