db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Bouschen <mbo.t...@spree.de>
Subject Re: TCK Schema : M-N relations
Date Sun, 04 Sep 2005 21:55:29 GMT
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			


Mime
View raw message