r5214 - trunk/gnue-common/utils/xml2sql

[johannes]

Author: johannes
Date: 2004-03-03 10:49:59 -0600 (Wed, 03 Mar 2004)
New Revision: 5214

Modified:
   trunk/gnue-common/utils/xml2sql/example.gsd
Log:
Define restaurants before foods, so the constraints make sense :)


Modified: trunk/gnue-common/utils/xml2sql/example.gsd
===================================================================
--- trunk/gnue-common/utils/xml2sql/example.gsd 2004-03-03 16:47:53 UTC (rev 
5213)
+++ trunk/gnue-common/utils/xml2sql/example.gsd 2004-03-03 16:49:59 UTC (rev 
5214)
@@ -1,3 +1,4 @@
+<?xml version="1.0"?>
 <schema>
 <!-- A simple example how a gsd can look like. All types of constraints used.
      All different ways to create a primary key / uniq index -->
@@ -3,77 +4,83 @@
   <tables>
     <table name="zipcodes">
-         <fields>
-              <field name="city_id" type="number" length="5" nullable="N"/>
-             <field name="zip" type="number" length="5"/>
-         </fields>
-     </table>
-     <table name="cities">
-         <fields>
-             <field name="id" type="key" nullable="N"/>
-             <field name="name" type="string" length="50" nullable="N"/>
-         </fields>
-         <primarykey name="pk_cities">
-             <pkfield name="id"/>
-         </primarykey>
+      <fields>
+        <field name="city_id" type="number" length="5" nullable="N"/>
+        <field name="zip" type="number" length="5"/>
+      </fields>
     </table>
+    <table name="cities">
+      <fields>
+        <field name="id" type="key" nullable="N"/>
+        <field name="name" type="string" length="50" nullable="N"/>
+      </fields>
+      <primarykey name="pk_cities">
+        <pkfield name="id"/>
+      </primarykey>
+    </table>
     <table name="worlds_best_psychotherapists">
-         <fields>
-              <field name="id" type="key" nullable="N"/>       
-             <field name="name" type="string" length="50" nullable="N"/>
-             <field name="firstname" type="string" length="50" nullable="N"/>
-             <field name="country" type="string" length="50" nullable="N"/>
-         </fields>
+      <fields>
+        <field name="id" type="key" nullable="N"/>     
+        <field name="name" type="string" length="50" nullable="N"/>
+        <field name="firstname" type="string" length="50" nullable="N"/>
+        <field name="country" type="string" length="50" nullable="N"/>
+      </fields>
+      <indexes>
+        <index name="psyco_idx" unique="Y">
+          <indexfield name="name"/>
+          <indexfield name="firstname"/>
+        </index>
+      </indexes>
     </table>
+    <table name="restaurants">
+      <fields>
+        <field name="id" type="key" nullable="N"/>     
+        <field name="name" type="string" length="50" nullable="N"/>
+        <field name="place" type="string" length="50" nullable="N"/>
+      </fields>        
+      <primarykey name="pk_restaurants_id">
+        <pkfield name="id"/>
+      </primarykey>
+      <indexes>
+        <index name="rest_idx2">
+          <indexfield name="name"/>
+          <indexfield name="place"/>
+        </index>
+      </indexes>
+    </table>
     <table name="worlds_best_chinese_food">
-         <fields>
-              <field name="id" type="key" nullable="N"/>       
-             <field name="place" type="string" length="50" nullable="N"/>
-             <field name="name" type="string" length="50" nullable="N"/>
-             <field name="description" type="string"/>
-         </fields>     
-         <constraints>
-              <constraint name="fk_restaurant_id" type="foreignkey">
-                  <constraintfield name="place"/>
-                  <constraintref name="id" table="restaurants"/>
-              </constraint>
-              <constraint name="idx_address_personid" type="unique">
-                  <constraintfield name="id"/>
-              </constraint>
-         </constraints>
+      <fields>
+        <field name="id" type="key" nullable="N"/>     
+        <field name="place" type="key" nullable="N"/>
+        <field name="name" type="string" length="50" nullable="N"/>
+        <field name="description" type="string"/>
+      </fields>        
+      <constraints>
+        <constraint name="fk_restaurant_id" type="foreignkey">
+          <constraintfield name="place"/>
+          <constraintref name="id" table="restaurants"/>
+        </constraint>
+        <constraint name="idx_address_personid" type="unique">
+          <constraintfield name="id"/>
+        </constraint>
+      </constraints>
     </table>
-    <table name="restaurants">
-        <fields>
-              <field name="id" type="key" nullable="N"/>       
-             <field name="name" type="string" length="50" nullable="N"/>
-             <field name="place" type="string" length="50" nullable="N"/>
-        </fields>      
-         <indexes>
-              <index name="rest_idx1" unique="1">
-                   <indexfield name="id"/>
-              </index>
-              <index name="rest_idx2">
-                   <indexfield name="name"/>
-                   <indexfield name="place"/>
-              </index>
-         </indexes>
-     </table>
   </tables>
   <data>
-     <tabledata name="sample_persons" tablename="worlds_best_psychotherapists">
-       <rows>
-           <row>
-                 <value>1</value>
-                 <value>Freud</value>
-                 <value>Sigmund</value>
-                 <value>Austria</value>
-           </row>
-            <row>
-                  <value>2</value>
-                 <value>Sullivan</value>
-                 <value>Peter</value>
-                 <value>USA</value>
-          </row>
+    <tabledata name="sample_persons" tablename="worlds_best_psychotherapists">
+      <rows>
+        <row>
+          <value>1</value>
+          <value>Freud</value>
+          <value>Sigmund</value>
+          <value>Austria</value>
+        </row>
+        <row>
+          <value>2</value>
+          <value>Sullivan</value>
+          <value>Peter</value>
+          <value>USA</value>
+        </row>
                <!-- More rows -->
-       </rows>
+      </rows>
     </tabledata>
   </data>