You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by tf...@apache.org on 2005/10/17 21:39:11 UTC

svn commit: r325965 - /db/torque/runtime/trunk/xdocs/tutorial/step2.xml

Author: tfischer
Date: Mon Oct 17 12:39:07 2005
New Revision: 325965

URL: http://svn.apache.org/viewcvs?rev=325965&view=rev
Log:
Put book table at the end of the schema.xml in order to have all tables declared to which foreign keys exist
Thanks to Jean T. Anderson for pointing out the problem

Modified:
    db/torque/runtime/trunk/xdocs/tutorial/step2.xml

Modified: db/torque/runtime/trunk/xdocs/tutorial/step2.xml
URL: http://svn.apache.org/viewcvs/db/torque/runtime/trunk/xdocs/tutorial/step2.xml?rev=325965&r1=325964&r2=325965&view=diff
==============================================================================
--- db/torque/runtime/trunk/xdocs/tutorial/step2.xml (original)
+++ db/torque/runtime/trunk/xdocs/tutorial/step2.xml Mon Oct 17 12:39:07 2005
@@ -177,6 +177,40 @@
   name="bookstore"
   defaultIdMethod="idbroker">
 
+  <table name="publisher" description="Publisher Table">
+    <column
+      name="publisher_id"
+      required="true"
+      primaryKey="true"
+      type="INTEGER"
+      description="Publisher Id"/>
+    <column
+      name="name"
+      required="true"
+      type="VARCHAR"
+      size="128"
+      description="Publisher Name"/>
+  </table>
+  <table name="author" description="Author Table">
+    <column
+      name="author_id"
+      required="true"
+      primaryKey="true"
+      type="INTEGER"
+      description="Author Id"/>
+    <column
+      name="first_name"
+      required="true"
+      type="VARCHAR"
+      size="128"
+      description="First Name"/>
+    <column
+      name="last_name"
+      required="true"
+      type="VARCHAR"
+      size="128"
+      description="Last Name"/>
+  </table>
   <table name="book" description="Book Table">
     <column
       name="book_id"
@@ -217,40 +251,6 @@
         local="author_id"
         foreign="author_id"/>
     </foreign-key>
-  </table>
-  <table name="publisher" description="Publisher Table">
-    <column
-      name="publisher_id"
-      required="true"
-      primaryKey="true"
-      type="INTEGER"
-      description="Publisher Id"/>
-    <column
-      name="name"
-      required="true"
-      type="VARCHAR"
-      size="128"
-      description="Publisher Name"/>
-  </table>
-  <table name="author" description="Author Table">
-    <column
-      name="author_id"
-      required="true"
-      primaryKey="true"
-      type="INTEGER"
-      description="Author Id"/>
-    <column
-      name="first_name"
-      required="true"
-      type="VARCHAR"
-      size="128"
-      description="First Name"/>
-    <column
-      name="last_name"
-      required="true"
-      type="VARCHAR"
-      size="128"
-      description="Last Name"/>
   </table>
 </database>
 ]]></source>



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org