r5750 - trunk/gnue-appserver/samples

[johannes]

Author: johannes
Date: 2004-04-20 09:43:54 -0500 (Tue, 20 Apr 2004)
New Revision: 5750

Modified:
   trunk/gnue-appserver/samples/sample.gsd
Log:
Added the constraint-def in address_person, and moved the tabledata-part :)


Modified: trunk/gnue-appserver/samples/sample.gsd
===================================================================
--- trunk/gnue-appserver/samples/sample.gsd     2004-04-20 14:29:07 UTC (rev 
5749)
+++ trunk/gnue-appserver/samples/sample.gsd     2004-04-20 14:43:54 UTC (rev 
5750)
@@ -52,7 +52,12 @@
                type="string"/>
       </fields>
       <indexes/>
-      <constraints/>
+      <constraints>
+        <constraint name="address_person_address_country_fk" type="foreignkey">
+          <constraintfield name="address_country"/>
+          <constraintref name="gnue_id" table="address_country"/>
+        </constraint>
+      </constraints>
       <primarykey name="gnue_id_pk_address_person">
         <pkfield name="gnue_id"/>
       </primarykey>
@@ -323,52 +328,6 @@
         </row>
       </rows>
     </tabledata>
-    <tabledata name="sample_persons" tablename="address_person">
-      <definition>
-        <column field="gnue_id" type="string(32)"/>
-        <column field="address_name" type="string(35)"/>
-        <column field="address_street" type="string(35)"/>
-        <column field="address_zip" type="string(35)"/>
-        <column field="address_city" type="string(35)"/>
-        <column field="address_country" type="string(32)"/>
-        <column field="address_children" type="number(2)"/>
-        <column field="address_weight" type="number(4.1)"/>
-        <column field="address_born" type="date"/>
-        <column field="address_meettime" type="time"/>
-        <column field="address_lastmeeting" type="datetime"/>
-        <column field="address_human" type="boolean"/>
-      </definition>
-      <rows>
-        <row>
-          <value field="gnue_id">00000000000000000000000000001100</value>
-          <value field="address_name">James T. Kirk</value>
-          <value field="address_street">Enterprise Road 17</value>
-          <value field="address_zip">2002</value>
-          <value field="address_city">Gnutown</value>
-          <value 
field="address_country">00000000000000000000002000000002</value>
-          <value field="address_children">1</value>
-          <value field="address_weight">85.4</value>
-          <value field="address_born">2233-03-21</value>
-          <value field="address_meettime">19:00</value>
-          <value field="address_lastmeeting">2270-05-31 18:30</value>
-          <value field="address_human">TRUE</value>
-        </row>
-        <row>
-          <value field="gnue_id">00000000000000000000000000001101</value>
-          <value field="address_name">Mr. Spock</value>
-          <value field="address_street">Vulc Lane 1</value>
-          <value field="address_zip">4711</value>
-          <value field="address_city">Vulcane</value>
-          <value 
field="address_country">00000000000000000000002000000001</value>
-          <value field="address_children">0</value>
-          <value field="address_weight">78.8</value>
-          <value field="address_born">2230-01-01</value>
-          <value field="address_meettime">6:30</value>
-          <value field="address_lastmeeting">2270-05-17 08:00</value>
-          <value field="address_human">FALSE</value>
-        </row>
-      </rows>
-    </tabledata>
     <tabledata name="sample_countries" tablename="address_country">
       <definition>
         <column field="gnue_id" type="string(32)"/>
@@ -1578,5 +1537,51 @@
         </row>
       </rows>
     </tabledata>
+    <tabledata name="sample_persons" tablename="address_person">
+      <definition>
+        <column field="gnue_id" type="string(32)"/>
+        <column field="address_name" type="string(35)"/>
+        <column field="address_street" type="string(35)"/>
+        <column field="address_zip" type="string(35)"/>
+        <column field="address_city" type="string(35)"/>
+        <column field="address_country" type="string(32)"/>
+        <column field="address_children" type="number(2)"/>
+        <column field="address_weight" type="number(4.1)"/>
+        <column field="address_born" type="date"/>
+        <column field="address_meettime" type="time"/>
+        <column field="address_lastmeeting" type="datetime"/>
+        <column field="address_human" type="boolean"/>
+      </definition>
+      <rows>
+        <row>
+          <value field="gnue_id">00000000000000000000000000001100</value>
+          <value field="address_name">James T. Kirk</value>
+          <value field="address_street">Enterprise Road 17</value>
+          <value field="address_zip">2002</value>
+          <value field="address_city">Gnutown</value>
+          <value 
field="address_country">00000000000000000000002000000002</value>
+          <value field="address_children">1</value>
+          <value field="address_weight">85.4</value>
+          <value field="address_born">2233-03-21</value>
+          <value field="address_meettime">19:00</value>
+          <value field="address_lastmeeting">2270-05-31 18:30</value>
+          <value field="address_human">TRUE</value>
+        </row>
+        <row>
+          <value field="gnue_id">00000000000000000000000000001101</value>
+          <value field="address_name">Mr. Spock</value>
+          <value field="address_street">Vulc Lane 1</value>
+          <value field="address_zip">4711</value>
+          <value field="address_city">Vulcane</value>
+          <value 
field="address_country">00000000000000000000002000000001</value>
+          <value field="address_children">0</value>
+          <value field="address_weight">78.8</value>
+          <value field="address_born">2230-01-01</value>
+          <value field="address_meettime">6:30</value>
+          <value field="address_lastmeeting">2270-05-17 08:00</value>
+          <value field="address_human">FALSE</value>
+        </row>
+      </rows>
+    </tabledata>
   </data>
 </schema>