Extend User Howto Question

[Blake Day]

While attempting to follow the Extend User Howto, I encountered a problem.

In my application's schema, I have the following:

 <table name="CTLG_USER" javaName="CatalogUser" alias="TurbineUser"
     baseClass="<package>.catalog.om.TurbineUserAdapter"
  basePeer="<package>.catalog.om.TurbineUserPeerAdapter">

  <!-- Unique identifier -->
     <column name="USER_ID" primaryKey="true" required="true"
type="integer"/>
 </table>

 <table name="CTLG_SAVED_ITEM" javaName="SavedItem">
  <column name="USER_ID" required="true" primaryKey="true" type="INTEGER"/>
  <column name="PRODUCT_ID" required="true" primaryKey="true" size="16"
type="VARCHAR"/>

  <foreign-key foreignTable="CTLG_USER">
      <reference local="USER_ID" foreign="USER_ID"/>
  </foreign-key>
  <foreign-key foreignTable="CTLG_PRODUCT">
      <reference local="PRODUCT_ID" foreign="PRODUCT_ID"/>
  </foreign-key>
 </table>

Unfortunately, the following SQL is generated:

ALTER TABLE CTLG_SAVED_ITEM
    ADD CONSTRAINT USER_ID FOREIGN KEY (USER_ID)
    REFERENCES CTLG_USER (USER_ID);

I need the SQL to reflect TURBINE_USER as the foreign table, not CTLG_USER.
Does anyone have any suggestions as to why this is happening, and how I
might be able to solve the problem?

Thanks in advance,
Michael Blake Day
Artistry Studios - e-commerce design, implementation and hosting
email: [EMAIL PROTECTED]


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>