You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-dev@db.apache.org by Michael Watzek <mw...@spree.de> on 2005/07/27 15:17:57 UTC
Table "project_member"
Hi Michelle,
another question concerning the schema: Table
"applicationidentity0.project_member" does not specify "REFERENCE"
clauses of its columns but table "datastoreidentity0.project_member" does:
applicationidentity0:
CREATE TABLE project_member (
PROJID INTEGER NOT NULL,
MEMBER INTEGER NOT NULL
);
datastoreidentity0:
CREATE TABLE project_member (
PROJID INTEGER REFERENCES projects NOT NULL,
MEMBER INTEGER REFERENCES persons NOT NULL
);
I suggest to add "REFERENCE" clauses to table
applicationidentity0.project_member.
Regards,
Michael
--
-------------------------------------------------------------------
Michael Watzek Tech@Spree Engineering GmbH
mailto:mwa.tech@spree.de Buelowstr. 66
Tel.: ++49/30/235 520 36 10783 Berlin - Germany
Fax.: ++49/30/217 520 12 http://www.spree.de/
-------------------------------------------------------------------
Re: Table "project_member"
Posted by Michelle Caisse <Mi...@Sun.COM>.
Hi Michael,
I fixed these problems.
Thanks,
Michelle
Michael Watzek wrote:
> Hi Michelle,
>
> another question concerning the schema: Table
> "applicationidentity0.project_member" does not specify "REFERENCE"
> clauses of its columns but table "datastoreidentity0.project_member"
> does:
>
> applicationidentity0:
>
> CREATE TABLE project_member (
> PROJID INTEGER NOT NULL,
> MEMBER INTEGER NOT NULL
> );
>
>
> datastoreidentity0:
>
> CREATE TABLE project_member (
> PROJID INTEGER REFERENCES projects NOT NULL,
> MEMBER INTEGER REFERENCES persons NOT NULL
> );
>
> I suggest to add "REFERENCE" clauses to table
> applicationidentity0.project_member.
>
> Regards,
> Michael