Hi Andy,
thanks for the patch!
I think the changes also apply to the other datastoreidentity schema
files: schema[1-4].sql, since they have exactly the same problem. Am I
right? I have patched all 5 schema files in my workspace. I just want to
double check before I check in the changes.
Regards Michael
>Hi Craig,
>
>
>
>>I'd be happy if you could propose a patch fixing the FK's.
>>
>>
>
>patch is attached. Not raised a JIRA because in the time taken to raise the
>JIRA somebody could just have applied the patch
>
>
>
>
>------------------------------------------------------------------------
>
>Index: test/sql/derby/datastoreidentity/schema.sql
>===================================================================
>--- test/sql/derby/datastoreidentity/schema.sql (revision 267234)
>+++ test/sql/derby/datastoreidentity/schema.sql (working copy)
>@@ -167,12 +167,20 @@
>
> ALTER TABLE project_reviewer
> ADD CONSTRAINT PR_PROJ_FK FOREIGN KEY
>- (PROJID) REFERENCES projects(PROJID);
>+ (PROJID) REFERENCES projects(DATASTORE_IDENTITY);
>
> ALTER TABLE project_reviewer
> ADD CONSTRAINT PR_REV_FK FOREIGN KEY
>- (REVIEWER) REFERENCES persons(PERSONID);
>+ (REVIEWER) REFERENCES persons(DATASTORE_IDENTITY);
>
>+ALTER TABLE project_member
>+ ADD CONSTRAINT PM_PROJ_FK FOREIGN KEY
>+ (PROJID) REFERENCES projects(DATASTORE_IDENTITY);
>+
>+ALTER TABLE project_member
>+ ADD CONSTRAINT PM_MEMB_FK FOREIGN KEY
>+ (MEMBER) REFERENCES persons(DATASTORE_IDENTITY);
>+
> ALTER TABLE departments
> ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
> (EMP_OF_THE_MONTH) REFERENCES persons(DATASTORE_IDENTITY);
>
>
--
Michael Bouschen Tech@Spree Engineering GmbH
mailto:mbo.tech@spree.de http://www.tech.spree.de/
Tel.:++49/30/235 520-33 Buelowstr. 66
Fax.:++49/30/2175 2012 D-10783 Berlin
|