[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
r6652 - trunk/gnue-forms/samples/zipcode
From: |
johannes |
Subject: |
r6652 - trunk/gnue-forms/samples/zipcode |
Date: |
Mon, 8 Nov 2004 09:03:53 -0600 (CST) |
Author: johannes
Date: 2004-11-08 09:03:52 -0600 (Mon, 08 Nov 2004)
New Revision: 6652
Modified:
trunk/gnue-forms/samples/zipcode/zipcode.gsd
Log:
Fixed gsd file
Modified: trunk/gnue-forms/samples/zipcode/zipcode.gsd
===================================================================
--- trunk/gnue-forms/samples/zipcode/zipcode.gsd 2004-11-08 14:52:44 UTC
(rev 6651)
+++ trunk/gnue-forms/samples/zipcode/zipcode.gsd 2004-11-08 15:03:52 UTC
(rev 6652)
@@ -1,28 +1,27 @@
<?xml version="1.0"?>
-<!-- Schema definition created by GNUe Designer's
- "Create Schema from Form" plugin -->
<schema>
<tables>
<table name="state">
<fields>
- <field name="state" size="2" type="char"/>
- <field name="description" size="30" type="varchar" nullable="N"/>
+ <field name="state" type="string" length="2"/>
+ <field name="description" type="string" length="30" nullable="N"/>
</fields>
<primarykey name="pk_state">
<pkfield name="state"/>
</primarykey>
<constraints/>
</table>
+
<table name="zipcode">
<fields>
- <field name="zipcode" size="5" type="varchar"/>
- <field name="city" size="30" type="varchar" nullable="N"/>
- <field name="state" size="2" type="char" nullable="N"/>
- <field name="longitude" type="float"/>
- <field name="latitude" type="float"/>
+ <field name="zip" type="string" length="5"/>
+ <field name="city" type="string" length="30" nullable="N"/>
+ <field name="state" type="string" length="2" nullable="N"/>
+ <field name="longitude" type="number" length="5" precision="2"/>
+ <field name="latitude" type="number" length="5" precision="2"/>
</fields>
<primarykey name="pk_zipcode">
- <pkfield name="zipcode"/>
+ <pkfield name="zip"/>
</primarykey>
<constraints>
<constraint name="fk_zipcode_state" type="foreignkey">
@@ -32,226 +31,234 @@
</constraints>
</table>
</tables>
+
<data>
<tabledata name="states_data" tablename="state">
- <rows>
- <row>
- <value>'AL'</value>
- <value>'Alabama'</value>
- </row>
- <row>
- <value>'AK'</value>
- <value>'Alaska'</value>
- </row>
- <row>
- <value>'AZ'</value>
- <value>'Arizona'</value>
- </row>
- <row>
- <value>'AR'</value>
- <value>'Arkansas'</value>
- </row>
- <row>
- <value>'CA'</value>
- <value>'California'</value>
- </row>
- <row>
- <value>'CO'</value>
- <value>'Colorado'</value>
- </row>
- <row>
- <value>'CT'</value>
- <value>'Connecticut'</value>
- </row>
- <row>
- <value>'DE'</value>
- <value>'Delaware'</value>
- </row>
- <row>
- <value>'DC'</value>
- <value>'District of Columbia'</value>
- </row>
- <row>
- <value>'FL'</value>
- <value>'Florida'</value>
- </row>
- <row>
- <value>'GA'</value>
- <value>'Georgia'</value>
- </row>
- <row>
- <value>'GU'</value>
- <value>'Guam'</value>
- </row>
- <row>
- <value>'HI'</value>
- <value>'Hawaii'</value>
- </row>
- <row>
- <value>'ID'</value>
- <value>'Idaho'</value>
- </row>
- <row>
- <value>'IL'</value>
- <value>'Illinois'</value>
- </row>
- <row>
- <value>'IN'</value>
- <value>'Indiana'</value>
- </row>
- <row>
- <value>'IA'</value>
- <value>'Iowa'</value>
- </row>
- <row>
- <value>'KS'</value>
- <value>'Kansas'</value>
- </row>
- <row>
- <value>'KY'</value>
- <value>'Kentucky'</value>
- </row>
- <row>
- <value>'LA'</value>
- <value>'Louisiana'</value>
- </row>
- <row>
- <value>'ME'</value>
- <value>'Maine'</value>
- </row>
- <row>
- <value>'MD'</value>
- <value>'Maryland'</value>
- </row>
- <row>
- <value>'MA'</value>
- <value>'Massachusetts'</value>
- </row>
- <row>
- <value>'MI'</value>
- <value>'Michigan'</value>
- </row>
- <row>
- <value>'MN'</value>
- <value>'Minnesota'</value>
- </row>
- <row>
- <value>'MS'</value>
- <value>'Mississippi'</value>
- </row>
- <row>
- <value>'MO'</value>
- <value>'Missouri'</value>
- </row>
- <row>
- <value>'MT'</value>
- <value>'Montana'</value>
- </row>
- <row>
- <value>'NE'</value>
- <value>'Nebraska'</value>
- </row>
- <row>
- <value>'NV'</value>
- <value>'Nevada'</value>
- </row>
- <row>
- <value>'NH'</value>
- <value>'New Hampshire'</value>
- </row>
- <row>
- <value>'NJ'</value>
- <value>'New Jersey'</value>
- </row>
- <row>
- <value>'NM'</value>
- <value>'New Mexico'</value>
- </row>
- <row>
- <value>'NY'</value>
- <value>'New York'</value>
- </row>
- <row>
- <value>'NC'</value>
- <value>'North Carolina'</value>
- </row>
- <row>
- <value>'ND'</value>
- <value>'North Dakota'</value>
- </row>
- <row>
- <value>'OH'</value>
- <value>'Ohio'</value>
- </row>
- <row>
- <value>'OK'</value>
- <value>'Oklahoma'</value>
- </row>
- <row>
- <value>'OR'</value>
- <value>'Oregon'</value>
- </row>
- <row>
- <value>'PA'</value>
- <value>'Pennsylvania'</value>
- </row>
- <row>
- <value>'PR'</value>
- <value>'Puerto Rico'</value>
- </row>
- <row>
- <value>'RI'</value>
- <value>'Rhode Island'</value>
- </row>
- <row>
- <value>'SC'</value>
- <value>'South Carolina'</value>
- </row>
- <row>
- <value>'SD'</value>
- <value>'South Dakota'</value>
- </row>
- <row>
- <value>'TN'</value>
- <value>'Tennessee'</value>
- </row>
- <row>
- <value>'TX'</value>
- <value>'Texas'</value>
- </row>
- <row>
- <value>'UT'</value>
- <value>'Utah'</value>
- </row>
- <row>
- <value>'VT'</value>
- <value>'Vermont'</value>
- </row>
- <row>
- <value>'VA'</value>
- <value>'Virginia'</value>
- </row>
- <row>
- <value>'VI'</value>
- <value>'Virgin Islands'</value>
- </row>
- <row>
- <value>'WA'</value>
- <value>'Washington'</value>
- </row>
- <row>
- <value>'WV'</value>
- <value>'West Virginia'</value>
- </row>
- <row>
- <value>'WI'</value>
- <value>'Wisconsin'</value>
- </row>
- <row>
- <value>'WY'</value>
- <value>'Wyoming'</value>
- </row>
- </rows>
+ <definition>
+ <column field="state" key="Y" type="string(2)"/>
+ <column field="description" type="string(30)"/>
+ </definition>
+
+ <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>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- r6652 - trunk/gnue-forms/samples/zipcode,
johannes <=