r5197 - trunk/gnue-common/utils/xml2sql

[jan]

Author: jan
Date: 2004-02-29 15:36:13 -0600 (Sun, 29 Feb 2004)
New Revision: 5197

Modified:
   trunk/gnue-common/utils/xml2sql/example.gsd
Log:
update example to match gsd schema of scripter


Modified: trunk/gnue-common/utils/xml2sql/example.gsd
===================================================================
--- trunk/gnue-common/utils/xml2sql/example.gsd 2004-02-29 17:24:11 UTC (rev 
5196)
+++ trunk/gnue-common/utils/xml2sql/example.gsd 2004-02-29 21:36:13 UTC (rev 
5197)
@@ -4,14 +4,14 @@
   <tables>
     <table name="zipcodes">
          <fields>
-              <field name="city_id" type="int" size="5" nullable="N"/>
-             <field name="zip" type="int" size="5"/>
+              <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="auto" nullable="N"/>
-             <field name="name" type="varchar" size="50" nullable="N"/>
+             <field name="id" type="key" nullable="N"/>
+             <field name="name" type="string" length="50" nullable="N"/>
          </fields>
          <primarykey name="pk_cities">
              <pkfield name="id"/>
@@ -19,18 +19,18 @@
     </table>
     <table name="worlds_best_psychotherapists">
          <fields>
-              <field name="id" type="auto" nullable="N"/>      
-             <field name="name" type="varchar" size="50" nullable="N"/>
-             <field name="firstname" type="varchar" size="50" nullable="N"/>
-             <field name="country" type="varchar" size="50" nullable="N"/>
+              <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>
     </table>
     <table name="worlds_best_chinese_food">
          <fields>
-              <field name="id" type="auto" nullable="N"/>      
-             <field name="place" type="varchar" size="50" nullable="N"/>
-             <field name="name" type="varchar" size="50" nullable="N"/>
-             <field name="description" type="text"/>
+              <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">
@@ -44,17 +44,17 @@
     </table>
     <table name="restaurants">
         <fields>
-              <field name="id" type="auto" nullable="N"/>      
-             <field name="name" type="varchar" size="50" nullable="N"/>
-             <field name="place" type="varchar" size="50" nullable="N"/>
+              <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" type="unique">
-                   <idxfield name="id"/>
+              <index name="rest_idx1" unique="1">
+                   <indexfield name="id"/>
               </index>
               <index name="rest_idx2">
-                   <idxfield name="name"/>
-                   <idxfield name="place"/>
+                   <indexfield name="name"/>
+                   <indexfield name="place"/>
               </index>
          </indexes>
      </table>