[gnue] r8231 - trunk/gnue-samples/two-tier/schema

[jamest]

Author: jamest
Date: 2006-03-15 19:16:05 -0600 (Wed, 15 Mar 2006)
New Revision: 8231

Modified:
   trunk/gnue-samples/two-tier/schema/invoice.gsd
   trunk/gnue-samples/two-tier/schema/invoice_address.gsd
   trunk/gnue-samples/two-tier/schema/items.gsd
Log:
added boolean and date
added fishhook to items table


Modified: trunk/gnue-samples/two-tier/schema/invoice.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/invoice.gsd      2006-03-15 20:20:29 UTC 
(rev 8230)
+++ trunk/gnue-samples/two-tier/schema/invoice.gsd      2006-03-16 01:16:05 UTC 
(rev 8231)
@@ -12,6 +12,7 @@
         <field name="tax_total"     type="number"   length="9" precision="2" 
nullable="N"/>
         <field name="tax_rate"      type="number"   length="9" precision="4" 
nullable="N"/>
         <field name="grand_total"   type="number"   length="9" precision="2" 
nullable="N"/>
+        <field name="locked"        type="boolean"  length="9" precision="2" 
nullable="N" default="false"/>
       </fields>
       
       <primarykey name="pk_invoice_invoice_id">
@@ -39,4 +40,4 @@
     </tabledata>
   </data>
 
-</schema>
\ No newline at end of file
+</schema>

Modified: trunk/gnue-samples/two-tier/schema/invoice_address.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/invoice_address.gsd      2006-03-15 
20:20:29 UTC (rev 8230)
+++ trunk/gnue-samples/two-tier/schema/invoice_address.gsd      2006-03-16 
01:16:05 UTC (rev 8231)
@@ -5,7 +5,7 @@
       <fields>
         <field name="invoice_address_id" type="number"   nullable="N" 
defaultwith="serial"/>
         <field name="created"            type="datetime" nullable="N" 
defaultwith="timestamp"/>
-        <field name="valid_from"         type="datetime" nullable="N" 
defaultwith="timestamp"/>
+        <field name="valid_from"         type="date"     nullable="N" 
defaultwith="timestamp"/>
         <field name="invoice_id"         type="number"   nullable="N"/>
         <field name="address_id"         type="number"   nullable="N"/>
         <field name="attention1"         type="string"   length="50" 
nullable="N"/>
@@ -54,4 +54,4 @@
       </rows>
     </tabledata>
   </data>
-</schema>
\ No newline at end of file
+</schema>

Modified: trunk/gnue-samples/two-tier/schema/items.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/items.gsd        2006-03-15 20:20:29 UTC 
(rev 8230)
+++ trunk/gnue-samples/two-tier/schema/items.gsd        2006-03-16 01:16:05 UTC 
(rev 8231)
@@ -3,13 +3,14 @@
   <tables>
     <table name="items">
       <fields>
-        <field name="item_id"       type="number"   nullable="N"  
defaultwith="serial"/>
-        <field name="created"       type="datetime" nullable="N"  
defaultwith="timestamp"/>
-        <field name="sku"           type="string"   length="50" nullable="N"/>
-        <field name="make"          type="string"   length="50" nullable="N"/>
-        <field name="model"         type="string"   length="50" nullable="N"/>
-        <field name="description"   type="string"   length="50" nullable="N"/>
-        <field name="unit_price"    type="number"   length="9" precision="2" 
nullable="N"/>
+        <field name="item_id"              type="number"   nullable="N"  
defaultwith="serial"/>
+        <field name="created"              type="datetime" nullable="N"  
defaultwith="timestamp"/>
+        <field name="replacement_item_id"  type="string"   length="50" />
+        <field name="sku"                  type="string"   length="50" 
nullable="N"/>
+        <field name="make"                 type="string"   length="50" 
nullable="N"/>
+        <field name="model"                type="string"   length="50" 
nullable="N"/>
+        <field name="description"          type="string"   length="50" 
nullable="N"/>
+        <field name="unit_price"           type="number"   length="9" 
precision="2" nullable="N"/>
       </fields>
       
       <primarykey name="pk_items_item_id">
@@ -22,7 +23,11 @@
         </index>
       </indexes>
 
-      <constraints />
+      <constraints>
+        <foreignkey name="fk_item_replace_item_id"  references="items">
+          <fkfield name="replacement_item_id"  references="item_id"/>
+        </foreignkey>
+      </constraints>
     </table>
   </tables>