|
Home > Archive > Apache JDO Project > July 2005 > Table "project_member"
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Table "project_member"
|
|
| Michael Watzek 2005-07-27, 7:45 am |
| 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/
-------------------------------------------------------------------
| |
| Michelle Caisse 2005-07-27, 5:45 pm |
| 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
|
|
|
|
|