[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
r6444 - in trunk: gnue-forms/samples/zipcode gnue-samples/tutorials/form
|
From: |
kilo |
|
Subject: |
r6444 - in trunk: gnue-forms/samples/zipcode gnue-samples/tutorials/forms |
|
Date: |
Fri, 1 Oct 2004 06:24:47 -0500 (CDT) |
Author: kilo
Date: 2004-10-01 06:24:46 -0500 (Fri, 01 Oct 2004)
New Revision: 6444
Added:
trunk/gnue-forms/samples/zipcode/zipcode.gsd
Removed:
trunk/gnue-forms/samples/zipcode/pg_zip_code.sql
trunk/gnue-samples/tutorials/forms/zipcode/
Log:
Removed obsolete forms sample
Deleted: trunk/gnue-forms/samples/zipcode/pg_zip_code.sql
===================================================================
--- trunk/gnue-forms/samples/zipcode/pg_zip_code.sql 2004-09-30 23:31:48 UTC
(rev 6443)
+++ trunk/gnue-forms/samples/zipcode/pg_zip_code.sql 2004-10-01 11:24:46 UTC
(rev 6444)
@@ -1,77 +0,0 @@
-create table state
-(
- state char(2) PRIMARY KEY,
- description varchar(30) NOT NULL
-);
-
-
-create table zipcode
-(
- zip char(5) PRIMARY KEY,
- city varchar(30) NOT NULL,
- state char(2) NOT NULL REFERENCES state
-);
-
-INSERT INTO state (state, description) VALUES('AL','Alabama');
-INSERT INTO state (state, description) VALUES('AK','Alaska');
-INSERT INTO state (state, description) VALUES('AZ','Arizona');
-INSERT INTO state (state, description) VALUES('AR','Arkansas');
-INSERT INTO state (state, description) VALUES('CA','California');
-INSERT INTO state (state, description) VALUES('CO','Colorado');
-INSERT INTO state (state, description) VALUES('CT','Connecticut');
-INSERT INTO state (state, description) VALUES('DE','Delaware');
-INSERT INTO state (state, description) VALUES('DC','District of Columbia');
-INSERT INTO state (state, description) VALUES('FL','Florida');
-INSERT INTO state (state, description) VALUES('GA','Georgia');
-INSERT INTO state (state, description) VALUES('GU','Guam');
-INSERT INTO state (state, description) VALUES('HI','Hawaii');
-INSERT INTO state (state, description) VALUES('ID','Idaho');
-INSERT INTO state (state, description) VALUES('IL','Illinois');
-INSERT INTO state (state, description) VALUES('IN','Indiana');
-INSERT INTO state (state, description) VALUES('IA','Iowa');
-INSERT INTO state (state, description) VALUES('KS','Kansas');
-INSERT INTO state (state, description) VALUES('KY','Kentucky');
-INSERT INTO state (state, description) VALUES('LA','Louisiana');
-INSERT INTO state (state, description) VALUES('ME','Maine');
-INSERT INTO state (state, description) VALUES('MD','Maryland');
-INSERT INTO state (state, description) VALUES('MA','Massachusetts');
-INSERT INTO state (state, description) VALUES('MI','Michigan');
-INSERT INTO state (state, description) VALUES('MN','Minnesota');
-INSERT INTO state (state, description) VALUES('MS','Mississippi');
-INSERT INTO state (state, description) VALUES('MO','Missouri');
-INSERT INTO state (state, description) VALUES('MT','Montana');
-INSERT INTO state (state, description) VALUES('NE','Nebraska');
-INSERT INTO state (state, description) VALUES('NV','Nevada');
-INSERT INTO state (state, description) VALUES('NH','New Hampshire');
-INSERT INTO state (state, description) VALUES('NJ','New Jersey');
-INSERT INTO state (state, description) VALUES('NM','New Mexico');
-INSERT INTO state (state, description) VALUES('NY','New York');
-INSERT INTO state (state, description) VALUES('NC','North Carolina');
-INSERT INTO state (state, description) VALUES('ND','North Dakota');
-INSERT INTO state (state, description) VALUES('OH','Ohio');
-INSERT INTO state (state, description) VALUES('OK','Oklahoma');
-INSERT INTO state (state, description) VALUES('OR','Oregon');
-INSERT INTO state (state, description) VALUES('PA','Pennsylvania');
-INSERT INTO state (state, description) VALUES('PR','Puerto Rico');
-INSERT INTO state (state, description) VALUES('RI','Rhode Island');
-INSERT INTO state (state, description) VALUES('SC','South Carolina');
-INSERT INTO state (state, description) VALUES('SD','South Dakota');
-INSERT INTO state (state, description) VALUES('TN','Tennessee');
-INSERT INTO state (state, description) VALUES('TX','Texas');
-INSERT INTO state (state, description) VALUES('UT','Utah');
-INSERT INTO state (state, description) VALUES('VT','Vermont');
-INSERT INTO state (state, description) VALUES('VA','Virginia');
-INSERT INTO state (state, description) VALUES('VI','Virgin Islands');
-INSERT INTO state (state, description) VALUES('WA','Washington');
-INSERT INTO state (state, description) VALUES('WV','West Virginia');
-INSERT INTO state (state, description) VALUES('WI','Wisconsin');
-INSERT INTO state (state, description) VALUES('WY','Wyoming');
-
-
-
-
-
-
-
-
-
Added: trunk/gnue-forms/samples/zipcode/zipcode.gsd
===================================================================
--- trunk/gnue-forms/samples/zipcode/zipcode.gsd 2004-09-30 23:31:48 UTC
(rev 6443)
+++ trunk/gnue-forms/samples/zipcode/zipcode.gsd 2004-10-01 11:24:46 UTC
(rev 6444)
@@ -0,0 +1,257 @@
+<?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"/>
+ </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"/>
+ </fields>
+ <primarykey name="pk_zipcode">
+ <pkfield name="zipcode"/>
+ </primarykey>
+ <constraints>
+ <constraint name="fk_zipcode_state" type="foreignkey">
+ <constraintfield name="state"/>
+ <constraintref name="state" table="state"/>
+ </constraint>
+ </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>
+ </tabledata>
+</data>
+</schema>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- r6444 - in trunk: gnue-forms/samples/zipcode gnue-samples/tutorials/forms,
kilo <=