[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[gnue] r8220 - in trunk/gnue-samples: . testcases/forms/gauntlet two-tie
From: |
jamest |
Subject: |
[gnue] r8220 - in trunk/gnue-samples: . testcases/forms/gauntlet two-tier two-tier/schema |
Date: |
Sat, 11 Mar 2006 18:01:06 -0600 (CST) |
Author: jamest
Date: 2006-03-11 18:01:05 -0600 (Sat, 11 Mar 2006)
New Revision: 8220
Added:
trunk/gnue-samples/appserver/
trunk/gnue-samples/two-tier/
trunk/gnue-samples/two-tier/schema/
trunk/gnue-samples/two-tier/schema/address.gsd
trunk/gnue-samples/two-tier/schema/invoice.gsd
trunk/gnue-samples/two-tier/schema/invoice_address.gsd
trunk/gnue-samples/two-tier/schema/invoice_item.gsd
trunk/gnue-samples/two-tier/schema/items.gsd
trunk/gnue-samples/two-tier/schema/lk_address_type.gsd
trunk/gnue-samples/two-tier/schema/state.gsd
trunk/gnue-samples/two-tier/schema/zipcode.gsd
Modified:
trunk/gnue-samples/README
trunk/gnue-samples/testcases/forms/gauntlet/gauntlet.gfd
Log:
start of a very basic testkit for use by other gnue packages
Modified: trunk/gnue-samples/README
===================================================================
--- trunk/gnue-samples/README 2006-03-11 19:30:12 UTC (rev 8219)
+++ trunk/gnue-samples/README 2006-03-12 00:01:05 UTC (rev 8220)
@@ -8,6 +8,8 @@
------------
Please see INSTALL for installation instructions.
+gsscvs -c gnue -d -u dbadmin *.gsd
+
License
-------
GNU Enterprise is free software. See the file `COPYING' for the terms and
Modified: trunk/gnue-samples/testcases/forms/gauntlet/gauntlet.gfd
===================================================================
--- trunk/gnue-samples/testcases/forms/gauntlet/gauntlet.gfd 2006-03-11
19:30:12 UTC (rev 8219)
+++ trunk/gnue-samples/testcases/forms/gauntlet/gauntlet.gfd 2006-03-12
00:01:05 UTC (rev 8220)
@@ -19,12 +19,23 @@
</staticset>
</datasource>
- <trigger name="dialogButtonTrigger" type="NAMED"><![CDATA[##
+<!-- <trigger name="dialogButtonTrigger" type="NAMED"><![CDATA[##
modal = 1
parameters = {'placeholder':''}
activateDialog('dialogSelector', parameters, modal)
]]></trigger>
+-->
+ <trigger type="ON-STARTUP" name="trgStartup"><![CDATA[
+ value = form.getParameter('param1')
+ if value:
+ styleFields.defaultField=value
+
+ value = form.getParameter('param2')
+ if value:
+ styleFields.labelField=value
+ ]]></trigger>
+
<logic>
<block name="styleFields">
<field name="defaultField"/>
@@ -175,11 +186,10 @@
<button name="messageButton" c:height="1" c:width="22" c:x="3"
c:y="7" label="Display a message box">
<trigger name="Trigger5" type="ON-ACTION"><![CDATA[
- params = {'placeholder': ''}
- activateDialog ('getMessageDialog', params, True)
- if params.has_key ('message'):
- messageBox (params ['message'], params ['kind'])]]>
- </trigger>
+ activateDialog ('getMessageDialog', modal=True)
+ if getParameter('message'):
+ messageBox (getParameter('message'), getParameter('kind'))
+ ]]></trigger>
</button>
<box c:x="1" c:y="0" c:height="10" c:width="60"
@@ -286,5 +296,7 @@
</page>
</layout>
</dialog>
+ <parameter name="param1" default=""/>
+ <parameter name="param2" default=""/>
</form>
Added: trunk/gnue-samples/two-tier/schema/address.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/address.gsd 2006-03-11 19:30:12 UTC
(rev 8219)
+++ trunk/gnue-samples/two-tier/schema/address.gsd 2006-03-12 00:01:05 UTC
(rev 8220)
@@ -0,0 +1,52 @@
+<?xml version="1.0"?>
+<schema>
+ <tables>
+ <table name="address">
+ <fields>
+ <field name="address_id" type="number" nullable="N"
defaultwith="serial"/>
+ <field name="created" type="datetime" nullable="N"
defaultwith="timestamp"/>
+ <field name="address1" type="string" length="50" nullable="N"/>
+ <field name="address2" type="string" length="50"/>
+ <field name="city" type="string" length="30" nullable="N"/>
+ <field name="state" type="string" length="2" nullable="N"/>
+ <field name="zip" type="string" length="5" nullable="N"/>
+ </fields>
+
+ <primarykey name="pk_address_address_id">
+ <pkfield name="address_id"/>
+ </primarykey>
+
+ <constraints>
+ <foreignkey name="fk_address_csz" references="zipcode">
+ <fkfield name="city" references="city"/>
+ <fkfield name="state" references="state"/>
+ <fkfield name="zip" references="zip"/>
+ </foreignkey>
+ </constraints>
+ </table>
+ </tables>
+
+ <data>
+ <tabledata name="address_data" tablename="address">
+ <rows>
+ <row>
+ <value field="address_id">0</value>
+ <value field="address1">1234 1ST STREET</value>
+ <value field="address2">SUITE A</value>
+ <value field="city">MANHATTAN</value>
+ <value field="state">KS</value>
+ <value field="zip">66502</value>
+ </row>
+
+ <row>
+ <value field="address_id">1</value>
+ <value field="address1">6789 N. MAIN</value>
+ <value field="city" >ELLSWORTH</value>
+ <value field="state">KS</value>
+ <value field="zip">67439</value>
+ </row>
+ </rows>
+ </tabledata>
+ </data>
+
+</schema>
\ No newline at end of file
Added: trunk/gnue-samples/two-tier/schema/invoice.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/invoice.gsd 2006-03-11 19:30:12 UTC
(rev 8219)
+++ trunk/gnue-samples/two-tier/schema/invoice.gsd 2006-03-12 00:01:05 UTC
(rev 8220)
@@ -0,0 +1,84 @@
+<?xml version="1.0"?>
+<schema>
+ <tables>
+ <table name="invoice">
+ <fields>
+ <field name="invoice_id" type="number" nullable="N"
defaultwith="serial"/>
+ <field name="created" type="datetime" nullable="N"
defaultwith="timestamp"/>
+ <field name="mdse_total" type="number" length="9" precision="2"
nullable="N"/>
+ <field name="freight_total" type="number" length="9" precision="2"
nullable="N"/>
+ <field name="labor_total" type="number" length="9" precision="2"
nullable="N"/>
+ <field name="subtotal" type="number" length="9" precision="2"
nullable="N"/>
+ <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="shipto_attention1" type="string" length="50"
nullable="N"/>
+ <field name="shipto_attention2" type="string" length="50"/>
+ <field name="shipto_address1" type="string" length="50"
nullable="N"/>
+ <field name="shipto_address2" type="string" length="50"/>
+ <field name="shipto_city" type="string" length="30"
nullable="N"/>
+ <field name="shipto_state" type="string" length="2"
nullable="N"/>
+ <field name="shipto_zip" type="string" length="5"
nullable="N"/>
+
+ <field name="billto_attention1" type="string" length="50"
nullable="N"/>
+ <field name="billto_attention2" type="string" length="50"/>
+ <field name="billto_address1" type="string" length="50"
nullable="N"/>
+ <field name="billto_address2" type="string" length="50"/>
+ <field name="billto_city" type="string" length="30"
nullable="N"/>
+ <field name="billto_state" type="string" length="2"
nullable="N"/>
+ <field name="billto_zip" type="string" length="5"
nullable="N"/>
+ </fields>
+
+ <primarykey name="pk_invoice_invoice_id">
+ <pkfield name="invoice_id"/>
+ </primarykey>
+
+ <constraints>
+ <foreignkey name="fk_invoice_shipto_csz" references="zipcode">
+ <fkfield name="shipto_city" references="city"/>
+ <fkfield name="shipto_state" references="state"/>
+ <fkfield name="shipto_zip" references="zip"/>
+ </foreignkey>
+
+ <foreignkey name="fk_invoice_billto_csz" references="zipcode">
+ <fkfield name="billto_city" references="city"/>
+ <fkfield name="billto_state" references="state"/>
+ <fkfield name="billto_zip" references="zip"/>
+ </foreignkey>
+ </constraints>
+ </table>
+ </tables>
+
+ <data>
+ <tabledata name="invoice_data" tablename="invoice">
+ <rows>
+ <row>
+ <value field="invoice_id">1</value>
+ <value field="mdse_total">130</value>
+ <value field="freight_total">10</value>
+ <value field="labor_total">0</value>
+ <value field="subtotal">140</value>
+ <value field="tax_total">14</value>
+ <value field="tax_rate">10</value>
+ <value field="grand_total">154</value>
+
+ <value field="shipto_attention1">JOHN DOE</value>
+ <value field="shipto_attention2">GNUECORP</value>
+ <value field="shipto_address1">1234 1ST STREET</value>
+ <value field="shipto_address2">SUITE A</value>
+ <value field="shipto_city">MANHATTAN</value>
+ <value field="shipto_state">KS</value>
+ <value field="shipto_zip">66502</value>
+
+ <value field="billto_attention1">JANE SMITH</value>
+ <value field="billto_address1">6789 N. MAIN</value>
+ <value field="billto_city" >ELLSWORTH</value>
+ <value field="billto_state">KS</value>
+ <value field="billto_zip">67439</value>
+ </row>
+ </rows>
+ </tabledata>
+ </data>
+
+</schema>
\ No newline at end of file
Added: trunk/gnue-samples/two-tier/schema/invoice_address.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/invoice_address.gsd 2006-03-11
19:30:12 UTC (rev 8219)
+++ trunk/gnue-samples/two-tier/schema/invoice_address.gsd 2006-03-12
00:01:05 UTC (rev 8220)
@@ -0,0 +1,58 @@
+<?xml version="1.0"?>
+<schema>
+ <tables>
+ <table name="invoice_address">
+ <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="invoice_id" type="number" nullable="N"/>
+ <field name="address_id" type="number" nullable="N"/>
+ <field name="attention1" type="string" length="50"
nullable="N"/>
+ <field name="attention2" type="string" length="50"/>
+ <field name="address_type" type="string" length="5"
nullable="N"/>
+ </fields>
+
+ <primarykey name="pk_invoice_address_invoice_address_id">
+ <pkfield name="invoice_address_id"/>
+ </primarykey>
+
+ <constraints>
+ <foreignkey name="fk_invoice_address_invoice_id" references="invoice">
+ <fkfield name="invoice_id" references="invoice_id"/>
+ </foreignkey>
+
+ <foreignkey name="fk_invoice_address_address_id" references="address">
+ <fkfield name="address_id" references="address_id"/>
+ </foreignkey>
+
+ <foreignkey name="fk_invoice_address_type"
references="lk_address_type">
+ <fkfield name="address_type" references="type"/>
+ </foreignkey>
+ </constraints>
+ </table>
+ </tables>
+
+ <data>
+ <tabledata name="invoice_address_data" tablename="invoice_address">
+ <rows>
+ <row>
+ <value field="invoice_address_id">0</value>
+ <value field="invoice_id">1</value>
+ <value field="address_id">0</value>
+ <value field="attention1">JOHN DOE</value>
+ <value field="attention2">GNUECORP</value>
+ <value field="address_type">SHIP</value>
+ </row>
+<!-- <row>
+ <value field="invoice_address_id">1</value>
+ <value field="invoice_id">1</value>
+ <value field="address_id">1</value>
+ <value field="attention1">JANE SMITH</value>
+ <value field="address_type">BILL</value>
+ </row>
+ -->
+ </rows>
+ </tabledata>
+ </data>
+</schema>
\ No newline at end of file
Added: trunk/gnue-samples/two-tier/schema/invoice_item.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/invoice_item.gsd 2006-03-11 19:30:12 UTC
(rev 8219)
+++ trunk/gnue-samples/two-tier/schema/invoice_item.gsd 2006-03-12 00:01:05 UTC
(rev 8220)
@@ -0,0 +1,49 @@
+<?xml version="1.0"?>
+<schema>
+ <tables>
+ <table name="invoice_item">
+ <fields>
+ <field name="invoice_item_id" type="number" nullable="N"
defaultwith="serial"/>
+ <field name="invoice_id" type="number" nullable="N"/>
+ <field name="sku" type="string" length="50" nullable="N"/>
+ <field name="description" type="string" length="50" nullable="N"/>
+ <field name="quantity" type="number" nullable="N"/>
+ <field name="unit_price" type="number" length="9" precision="2"
nullable="N"/>
+ </fields>
+
+ <primarykey name="pk_invoice_item_id">
+ <pkfield name="invoice_item_id"/>
+ </primarykey>
+
+ <constraints>
+ <foreignkey name="fk_invoice_item_sku" references="items">
+ <fkfield name="sku" references="sku"/>
+ </foreignkey>
+ </constraints>
+ </table>
+ </tables>
+
+ <data>
+ <tabledata name="invoice_item_data" tablename="invoice_item">
+ <rows>
+ <row>
+ <value field="invoice_item_id">0</value>
+ <value field="invoice_id">0</value>
+ <value field="sku">GTS2000</value>
+ <value field="description">GOAT TRACKER 2000</value>
+ <value field="quantity">1</value>
+ <value field="unit_price">125.00</value>
+ </row>
+ <row>
+ <value field="invoice_item_id">1</value>
+ <value field="invoice_id">0</value>
+ <value field="sku">GRPEL</value>
+ <value field="description">GOAT REPELLENT</value>
+ <value field="quantity">5</value>
+ <value field="unit_price">5.00</value>
+ </row>
+ </rows>
+ </tabledata>
+ </data>
+
+</schema>
\ No newline at end of file
Added: trunk/gnue-samples/two-tier/schema/items.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/items.gsd 2006-03-11 19:30:12 UTC
(rev 8219)
+++ trunk/gnue-samples/two-tier/schema/items.gsd 2006-03-12 00:01:05 UTC
(rev 8220)
@@ -0,0 +1,50 @@
+<?xml version="1.0"?>
+<schema>
+ <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"/>
+ </fields>
+
+ <primarykey name="pk_items_item_id">
+ <pkfield name="item_id"/>
+ </primarykey>
+
+ <constraints>
+ <unique name="unique_sku">
+ <uqfield name="sku"/>
+ </unique>
+ </constraints>
+ </table>
+ </tables>
+
+ <data>
+ <tabledata name="items" tablename="items">
+ <rows>
+ <row>
+ <value field="item_id">0</value>
+ <value field="sku">GTS2000</value>
+ <value field="make">GNUE</value>
+ <value field="model">TRK2000</value>
+ <value field="description">GOAT TRACKER 2000</value>
+ <value field="unit_price">125.00</value>
+ </row>
+ <row>
+ <value field="item_id">1</value>
+ <value field="sku">GRPEL</value>
+ <value field="make">GNUE</value>
+ <value field="model">REPEL</value>
+ <value field="description">GOAT REPELLENT</value>
+ <value field="unit_price">5.00</value>
+ </row>
+ </rows>
+ </tabledata>
+ </data>
+
+</schema>
\ No newline at end of file
Added: trunk/gnue-samples/two-tier/schema/lk_address_type.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/lk_address_type.gsd 2006-03-11
19:30:12 UTC (rev 8219)
+++ trunk/gnue-samples/two-tier/schema/lk_address_type.gsd 2006-03-12
00:01:05 UTC (rev 8220)
@@ -0,0 +1,30 @@
+<?xml version="1.0"?>
+<schema>
+ <tables>
+ <table name="lk_address_type">
+ <fields>
+ <field name="type" type="string" length="5" nullable="N"/>
+ <field name="description" type="string" length="50" nullable="N"/>
+ </fields>
+
+ <primarykey name="pk_lk_address_type_type">
+ <pkfield name="type"/>
+ </primarykey>
+ </table>
+ </tables>
+
+ <data>
+ <tabledata name="lk_address_type_data" tablename="lk_address_type">
+ <rows>
+ <row>
+ <value field="type">SHIP</value>
+ <value field="description">A shipping address</value>
+ </row>
+ <row>
+ <value field="type">BILL</value>
+ <value field="description">A billing address</value>
+ </row>
+ </rows>
+ </tabledata>
+ </data>
+</schema>
\ No newline at end of file
Added: trunk/gnue-samples/two-tier/schema/state.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/state.gsd 2006-03-11 19:30:12 UTC
(rev 8219)
+++ trunk/gnue-samples/two-tier/schema/state.gsd 2006-03-12 00:01:05 UTC
(rev 8220)
@@ -0,0 +1,240 @@
+<?xml version="1.0"?>
+<schema>
+ <tables>
+ <table name="state">
+ <fields>
+ <field name="state" type="string" length="2" nullable="False"/>
+ <field name="description" type="string" length="30" nullable="False"/>
+ </fields>
+ <primarykey name="pk_state">
+ <pkfield name="state"/>
+ </primarykey>
+ <constraints/>
+ </table>
+</tables>
+
+<data>
+ <tabledata name="states_data" tablename="state">
+ <rows>
+ <row>
+ <value field="state">AL</value>
+ <value field="description">Alabama</value>
+ </row>
+ <row>
+ <value field="state">AK</value>
+ <value field="description">Alaska</value>
+ </row>
+ <row>
+ <value field="state">AZ</value>
+ <value field="description">Arizona</value>
+ </row>
+ <row>
+ <value field="state">AR</value>
+ <value field="description">Arkansas</value>
+ </row>
+ <row>
+ <value field="state">CA</value>
+ <value field="description">California</value>
+ </row>
+ <row>
+ <value field="state">CO</value>
+ <value field="description">Colorado</value>
+ </row>
+ <row>
+ <value field="state">CT</value>
+ <value field="description">Connecticut</value>
+ </row>
+ <row>
+ <value field="state">DE</value>
+ <value field="description">Delaware</value>
+ </row>
+ <row>
+ <value field="state">DC</value>
+ <value field="description">District of Columbia</value>
+ </row>
+ <row>
+ <value field="state">FL</value>
+ <value field="description">Florida</value>
+ </row>
+ <row>
+ <value field="state">GA</value>
+ <value field="description">Georgia</value>
+ </row>
+ <row>
+ <value field="state">GU</value>
+ <value field="description">Guam</value>
+ </row>
+ <row>
+ <value field="state">HI</value>
+ <value field="description">Hawaii</value>
+ </row>
+ <row>
+ <value field="state">ID</value>
+ <value field="description">Idaho</value>
+ </row>
+ <row>
+ <value field="state">IL</value>
+ <value field="description">Illinois</value>
+ </row>
+ <row>
+ <value field="state">IN</value>
+ <value field="description">Indiana</value>
+ </row>
+ <row>
+ <value field="state">IA</value>
+ <value field="description">Iowa</value>
+ </row>
+ <row>
+ <value field="state">KS</value>
+ <value field="description">Kansas</value>
+ </row>
+ <row>
+ <value field="state">KY</value>
+ <value field="description">Kentucky</value>
+ </row>
+ <row>
+ <value field="state">LA</value>
+ <value field="description">Louisiana</value>
+ </row>
+ <row>
+ <value field="state">ME</value>
+ <value field="description">Maine</value>
+ </row>
+ <row>
+ <value field="state">MD</value>
+ <value field="description">Maryland</value>
+ </row>
+ <row>
+ <value field="state">MA</value>
+ <value field="description">Massachusetts</value>
+ </row>
+ <row>
+ <value field="state">MI</value>
+ <value field="description">Michigan</value>
+ </row>
+ <row>
+ <value field="state">MN</value>
+ <value field="description">Minnesota</value>
+ </row>
+ <row>
+ <value field="state">MS</value>
+ <value field="description">Mississippi</value>
+ </row>
+ <row>
+ <value field="state">MO</value>
+ <value field="description">Missouri</value>
+ </row>
+ <row>
+ <value field="state">MT</value>
+ <value field="description">Montana</value>
+ </row>
+ <row>
+ <value field="state">NE</value>
+ <value field="description">Nebraska</value>
+ </row>
+ <row>
+ <value field="state">NV</value>
+ <value field="description">Nevada</value>
+ </row>
+ <row>
+ <value field="state">NH</value>
+ <value field="description">New Hampshire</value>
+ </row>
+ <row>
+ <value field="state">NJ</value>
+ <value field="description">New Jersey</value>
+ </row>
+ <row>
+ <value field="state">NM</value>
+ <value field="description">New Mexico</value>
+ </row>
+ <row>
+ <value field="state">NY</value>
+ <value field="description">New York</value>
+ </row>
+ <row>
+ <value field="state">NC</value>
+ <value field="description">North Carolina</value>
+ </row>
+ <row>
+ <value field="state">ND</value>
+ <value field="description">North Dakota</value>
+ </row>
+ <row>
+ <value field="state">OH</value>
+ <value field="description">Ohio</value>
+ </row>
+ <row>
+ <value field="state">OK</value>
+ <value field="description">Oklahoma</value>
+ </row>
+ <row>
+ <value field="state">OR</value>
+ <value field="description">Oregon</value>
+ </row>
+ <row>
+ <value field="state">PA</value>
+ <value field="description">Pennsylvania</value>
+ </row>
+ <row>
+ <value field="state">PR</value>
+ <value field="description">Puerto Rico</value>
+ </row>
+ <row>
+ <value field="state">RI</value>
+ <value field="description">Rhode Island</value>
+ </row>
+ <row>
+ <value field="state">SC</value>
+ <value field="description">South Carolina</value>
+ </row>
+ <row>
+ <value field="state">SD</value>
+ <value field="description">South Dakota</value>
+ </row>
+ <row>
+ <value field="state">TN</value>
+ <value field="description">Tennessee</value>
+ </row>
+ <row>
+ <value field="state">TX</value>
+ <value field="description">Texas</value>
+ </row>
+ <row>
+ <value field="state">UT</value>
+ <value field="description">Utah</value>
+ </row>
+ <row>
+ <value field="state">VT</value>
+ <value field="description">Vermont</value>
+ </row>
+ <row>
+ <value field="state">VA</value>
+ <value field="description">Virginia</value>
+ </row>
+ <row>
+ <value field="state">VI</value>
+ <value field="description">Virgin Islands</value>
+ </row>
+ <row>
+ <value field="state">WA</value>
+ <value field="description">Washington</value>
+ </row>
+ <row>
+ <value field="state">WV</value>
+ <value field="description">West Virginia</value>
+ </row>
+ <row>
+ <value field="state">WI</value>
+ <value field="description">Wisconsin</value>
+ </row>
+ <row>
+ <value field="state">WY</value>
+ <value field="description">Wyoming</value>
+ </row>
+ </rows>
+ </tabledata>
+
+</data>
+
+</schema>
Added: trunk/gnue-samples/two-tier/schema/zipcode.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/zipcode.gsd 2006-03-11 19:30:12 UTC
(rev 8219)
+++ trunk/gnue-samples/two-tier/schema/zipcode.gsd 2006-03-12 00:01:05 UTC
(rev 8220)
@@ -0,0 +1,39 @@
+<?xml version="1.0"?>
+<schema>
+ <tables>
+ <table name="zipcode">
+ <fields>
+ <field name="zip" type="string" length="5" nullable="False"/>
+ <field name="city" type="string" length="30" nullable="False"/>
+ <field name="state" type="string" length="2" nullable="False"/>
+ </fields>
+ <primarykey name="pk_zipcode">
+ <pkfield name="zip"/>
+ <pkfield name="city"/>
+ <pkfield name="state"/>
+ </primarykey>
+ <constraints>
+ <foreignkey name="fk_zipcode_state" references="state">
+ <fkfield name="state" references="state"/>
+ </foreignkey>
+ </constraints>
+ </table>
+ </tables>
+
+ <data>
+ <tabledata name="zipcode_data" tablename="zipcode">
+ <rows>
+ <row>
+ <value field="zip">66502</value>
+ <value field="city">MANHATTAN</value>
+ <value field="state">KS</value>
+ </row>
+ <row>
+ <value field="zip">67439</value>
+ <value field="city">ELLSWORTH</value>
+ <value field="state">KS</value>
+ </row>
+ </rows>
+ </tabledata>
+ </data>
+</schema>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [gnue] r8220 - in trunk/gnue-samples: . testcases/forms/gauntlet two-tier two-tier/schema,
jamest <=