You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-commits@db.apache.org by cl...@apache.org on 2005/07/22 22:55:54 UTC

svn commit: r224396 - /incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm

Author: clr
Date: Fri Jul 22 13:55:51 2005
New Revision: 224396

URL: http://svn.apache.org/viewcvs?rev=224396&view=rev
Log:
Add index to discriminator; add foreign-key elements

Modified:
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm

Modified: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm?rev=224396&r1=224395&r2=224396&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm (original)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/package-derby.orm Fri Jul 22 13:55:51 2005
@@ -66,9 +66,6 @@
                         <foreign-key/>
             </field>
             <field name="reviewedProjects" mapped-by="reviewers">
-                <element>
-                    <foreign-key name="PR_PROJ_FK"/>
-                </element>
             </field>
             <field name="projects" mapped-by="members"/>
             <field name="team" mapped-by="manager"/>
@@ -77,7 +74,8 @@
 
         <class name="Person" table="persons">
             <inheritance strategy="new-table">
-                <discriminator strategy="class-name" column="DISCRIMINATOR"/>
+                <discriminator strategy="class-name" column="DISCRIMINATOR"
+                    indexed="true"/>
             </inheritance>
             <field name="personid" column="PERSONID" primary-key="true"/>
             <field name="firstname" column="FIRSTNAME"/>
@@ -102,7 +100,9 @@
 
         <class name="Insurance" table="insuranceplans">
             <inheritance strategy="new-table">
-                <discriminator strategy="class-name" column="DISCRIMINATOR"/>
+                <discriminator strategy="class-name" column="DISCRIMINATOR">
+                    <index name="INS_DISCRIMINATOR_INDEX" unique="false"/>
+                </discriminator>
             </inheritance>
             <field name="insid" column="INSID" primary-key="true"/>
             <field name="carrier" column="CARRIER"/>
@@ -128,9 +128,11 @@
                <column name="BUDGET" jdbc-type="DECIMAL" length="11" scale="2"/>
             </field>
             <field name="reviewers" table="project_reviewer">
-                <join column="PROJID"/>
-                <element column="REVIEWER">
+                <join column="PROJID">
                     <foreign-key name="PR_PROJ_FK"/>
+                </join>
+                <element column="REVIEWER">
+                    <foreign-key name="PR_REV_FK"/>
                 </element>
             </field>
             <field name="members" table="project_member">