[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[gnue] r9204 - in trunk/gnue-samples/two-tier: forms schema
|
From: |
johannes |
|
Subject: |
[gnue] r9204 - in trunk/gnue-samples/two-tier: forms schema |
|
Date: |
Fri, 5 Jan 2007 02:02:15 -0600 (CST) |
Author: johannes
Date: 2007-01-05 02:02:14 -0600 (Fri, 05 Jan 2007)
New Revision: 9204
Added:
trunk/gnue-samples/two-tier/forms/country.gfd
trunk/gnue-samples/two-tier/schema/country.gsd
Removed:
trunk/gnue-samples/two-tier/forms/states.gfd
trunk/gnue-samples/two-tier/schema/state.gsd
Modified:
trunk/gnue-samples/two-tier/forms/customer.gfd
trunk/gnue-samples/two-tier/schema/customer.gsd
Log:
Renamed state into country
Copied: trunk/gnue-samples/two-tier/forms/country.gfd (from rev 9203,
trunk/gnue-samples/two-tier/forms/states.gfd)
===================================================================
--- trunk/gnue-samples/two-tier/forms/states.gfd 2007-01-04 22:45:24 UTC
(rev 9203)
+++ trunk/gnue-samples/two-tier/forms/country.gfd 2007-01-05 08:02:14 UTC
(rev 9204)
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<form title="Country names">
+ <options>
+ <author>GNU Enterprise Samples</author>
+ <version>$Rev$</version>
+ <description>
+ This lists the country names in alphabetical order
+ </description>
+ </options>
+
+ <datasource name="dts_country" connection="sample" table="country"
+ prequery="Y">
+ <sortorder>
+ <sortfield name="code" descending="False" ignorecase="False" />
+ </sortorder>
+ </datasource>
+
+ <logic>
+ <block name="blk_country" datasource="dts_country">
+ <field name="code" field="code" datatype="text" maxLength="2" />
+ <field name="name" field="name" datatype="text" maxLength="50" />
+ </block>
+ </logic>
+
+ <layout>
+ <page name="Countries" caption="Countries">
+ <vbox name="box" block="blk_country">
+ <grid name="grid" rows="15">
+ <gridline>
+ <entry name="code" field="code" label="Code"/>
+ <entry name="name" field="name" label="Name"/>
+ </gridline>
+ </grid>
+ </vbox>
+ </page>
+ </layout>
+
+</form>
Modified: trunk/gnue-samples/two-tier/forms/customer.gfd
===================================================================
--- trunk/gnue-samples/two-tier/forms/customer.gfd 2007-01-04 22:45:24 UTC
(rev 9203)
+++ trunk/gnue-samples/two-tier/forms/customer.gfd 2007-01-05 08:02:14 UTC
(rev 9204)
@@ -22,7 +22,8 @@
</sortorder>
</datasource>
- <datasource name="dts_state" connection="sample" table="state" prequery="Y">
+ <datasource name="dts_country" connection="sample" table="country"
+ prequery="Y">
<sortorder>
<sortfield name="code" descending="False" />
</sortorder>
@@ -37,10 +38,10 @@
<field name="address2" field="address2" datatype="text" maxLength="50" />
<field name="city" field="city" datatype="text" maxLength="30" />
<field name="zip" field="zip" datatype="text" maxLength="10" />
- <field name="state_code" field="state" fk_key="id" fk_description="code"
- fk_source="dts_state" case="upper"/>
- <field name="state_name" field="state" fk_key="id" fk_description="name"
- fk_source="dts_state" />
+ <field name="country_code" field="country" fk_key="id"
+ fk_description="code" fk_source="dts_country" case="upper"/>
+ <field name="country_name" field="country" fk_key="id"
+ fk_description="name" fk_source="dts_country" />
<field name="billing" field="billing_address" fk_key="id"
fk_description="name,city" fk_source="dts_billing" />
<field name="created" field="created" datatype="datetime" />
@@ -66,9 +67,9 @@
<entry name="zip" field="zip" label="Zip:"/>
<hbox name="country">
- <entry name="state_code" field="state_code" label="State code:"
+ <entry name="country_code" field="country_code" label="Country code:"
s:stretch="0" style="dropdown" />
- <entry name="state_name" field="state_name" label="State name:"
+ <entry name="country_name" field="country_name" label="Country name:"
style="dropdown" />
</hbox>
Deleted: trunk/gnue-samples/two-tier/forms/states.gfd
===================================================================
--- trunk/gnue-samples/two-tier/forms/states.gfd 2007-01-04 22:45:24 UTC
(rev 9203)
+++ trunk/gnue-samples/two-tier/forms/states.gfd 2007-01-05 08:02:14 UTC
(rev 9204)
@@ -1,38 +0,0 @@
-<?xml version="1.0" encoding="utf-8"?>
-
-<form title="Country names">
- <options>
- <author>GNU Enterprise Samples</author>
- <version>$Rev$</version>
- <description>
- This lists the country names in alphabetical order
- </description>
- </options>
-
- <datasource name="dts_state" connection="sample" table="state" prequery="Y">
- <sortorder>
- <sortfield name="code" descending="False" ignorecase="False" />
- </sortorder>
- </datasource>
-
- <logic>
- <block name="blk_state" datasource="dts_state">
- <field name="code" field="code" datatype="text" maxLength="2" />
- <field name="name" field="name" datatype="text" maxLength="50" />
- </block>
- </logic>
-
- <layout>
- <page name="States" caption="States">
- <vbox name="box" block="blk_state">
- <grid name="grid" rows="15">
- <gridline>
- <entry name="code" field="code" label="Code"/>
- <entry name="name" field="name" label="Country name"/>
- </gridline>
- </grid>
- </vbox>
- </page>
- </layout>
-
-</form>
Copied: trunk/gnue-samples/two-tier/schema/country.gsd (from rev 9203,
trunk/gnue-samples/two-tier/schema/state.gsd)
===================================================================
--- trunk/gnue-samples/two-tier/schema/state.gsd 2007-01-04 22:45:24 UTC
(rev 9203)
+++ trunk/gnue-samples/two-tier/schema/country.gsd 2007-01-05 08:02:14 UTC
(rev 9204)
@@ -0,0 +1,1239 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<schema>
+
+ <tables>
+ <table name="country">
+ <fields>
+ <field name="id" type="number" length="8" nullable="False"
+ defaultwith="serial"/>
+ <field name="code" type="string" length="2" nullable="False"/>
+ <field name="name" type="string" length="50" nullable="False"/>
+ </fields>
+
+ <primarykey name="pk_country">
+ <pkfield name="id"/>
+ </primarykey>
+
+ <constraints/>
+ </table>
+ </tables>
+
+ <data>
+ <tabledata name="iso_3166_country" tablename="country">
+ <rows>
+ <row>
+ <value field="id">1</value>
+ <value field="code">AF</value>
+ <value field="name">Afghanistan</value>
+ </row>
+ <row>
+ <value field="id">2</value>
+ <value field="code">AX</value>
+ <value field="name">Åland Islands</value>
+ </row>
+ <row>
+ <value field="id">3</value>
+ <value field="code">AL</value>
+ <value field="name">Albania</value>
+ </row>
+ <row>
+ <value field="id">4</value>
+ <value field="code">DZ</value>
+ <value field="name">Algeria</value>
+ </row>
+ <row>
+ <value field="id">5</value>
+ <value field="code">AS</value>
+ <value field="name">American Samoa</value>
+ </row>
+ <row>
+ <value field="id">6</value>
+ <value field="code">AD</value>
+ <value field="name">Andorra</value>
+ </row>
+ <row>
+ <value field="id">7</value>
+ <value field="code">AO</value>
+ <value field="name">Angola</value>
+ </row>
+ <row>
+ <value field="id">8</value>
+ <value field="code">AI</value>
+ <value field="name">Anguilla</value>
+ </row>
+ <row>
+ <value field="id">9</value>
+ <value field="code">AQ</value>
+ <value field="name">Antarctica</value>
+ </row>
+ <row>
+ <value field="id">10</value>
+ <value field="code">AG</value>
+ <value field="name">Antigua and Barbuda</value>
+ </row>
+ <row>
+ <value field="id">11</value>
+ <value field="code">AR</value>
+ <value field="name">Argentina</value>
+ </row>
+ <row>
+ <value field="id">12</value>
+ <value field="code">AM</value>
+ <value field="name">Armenia</value>
+ </row>
+ <row>
+ <value field="id">13</value>
+ <value field="code">AW</value>
+ <value field="name">Aruba</value>
+ </row>
+ <row>
+ <value field="id">14</value>
+ <value field="code">AU</value>
+ <value field="name">Australia</value>
+ </row>
+ <row>
+ <value field="id">15</value>
+ <value field="code">AT</value>
+ <value field="name">Austria</value>
+ </row>
+ <row>
+ <value field="id">16</value>
+ <value field="code">AZ</value>
+ <value field="name">Azerbaijan</value>
+ </row>
+ <row>
+ <value field="id">17</value>
+ <value field="code">BS</value>
+ <value field="name">Bahamas</value>
+ </row>
+ <row>
+ <value field="id">18</value>
+ <value field="code">BH</value>
+ <value field="name">Bahrain</value>
+ </row>
+ <row>
+ <value field="id">19</value>
+ <value field="code">BD</value>
+ <value field="name">Bangladesh</value>
+ </row>
+ <row>
+ <value field="id">20</value>
+ <value field="code">BB</value>
+ <value field="name">Barbados</value>
+ </row>
+ <row>
+ <value field="id">21</value>
+ <value field="code">BY</value>
+ <value field="name">Belarus</value>
+ </row>
+ <row>
+ <value field="id">22</value>
+ <value field="code">BE</value>
+ <value field="name">Belgium</value>
+ </row>
+ <row>
+ <value field="id">23</value>
+ <value field="code">BZ</value>
+ <value field="name">Belize</value>
+ </row>
+ <row>
+ <value field="id">24</value>
+ <value field="code">BJ</value>
+ <value field="name">Benin</value>
+ </row>
+ <row>
+ <value field="id">25</value>
+ <value field="code">BM</value>
+ <value field="name">Bermuda</value>
+ </row>
+ <row>
+ <value field="id">26</value>
+ <value field="code">BT</value>
+ <value field="name">Bhutan</value>
+ </row>
+ <row>
+ <value field="id">27</value>
+ <value field="code">BO</value>
+ <value field="name">Bolivia</value>
+ </row>
+ <row>
+ <value field="id">28</value>
+ <value field="code">BA</value>
+ <value field="name">Bosnia and Herzegovina</value>
+ </row>
+ <row>
+ <value field="id">29</value>
+ <value field="code">BW</value>
+ <value field="name">Botswana</value>
+ </row>
+ <row>
+ <value field="id">30</value>
+ <value field="code">BV</value>
+ <value field="name">Bouvet Island</value>
+ </row>
+ <row>
+ <value field="id">31</value>
+ <value field="code">BR</value>
+ <value field="name">Brazil</value>
+ </row>
+ <row>
+ <value field="id">32</value>
+ <value field="code">IO</value>
+ <value field="name">British Indian Ocean Territory</value>
+ </row>
+ <row>
+ <value field="id">33</value>
+ <value field="code">BN</value>
+ <value field="name">Brunei Darussalam</value>
+ </row>
+ <row>
+ <value field="id">34</value>
+ <value field="code">BG</value>
+ <value field="name">Bulgaria</value>
+ </row>
+ <row>
+ <value field="id">35</value>
+ <value field="code">BF</value>
+ <value field="name">Burkina Faso</value>
+ </row>
+ <row>
+ <value field="id">36</value>
+ <value field="code">BI</value>
+ <value field="name">Burundi</value>
+ </row>
+ <row>
+ <value field="id">37</value>
+ <value field="code">KH</value>
+ <value field="name">Cambodia</value>
+ </row>
+ <row>
+ <value field="id">38</value>
+ <value field="code">CM</value>
+ <value field="name">Cameroon</value>
+ </row>
+ <row>
+ <value field="id">39</value>
+ <value field="code">CA</value>
+ <value field="name">Canada</value>
+ </row>
+ <row>
+ <value field="id">40</value>
+ <value field="code">CV</value>
+ <value field="name">Cape Verde</value>
+ </row>
+ <row>
+ <value field="id">41</value>
+ <value field="code">KY</value>
+ <value field="name">Cayman Islands</value>
+ </row>
+ <row>
+ <value field="id">42</value>
+ <value field="code">CF</value>
+ <value field="name">Central African Republic</value>
+ </row>
+ <row>
+ <value field="id">43</value>
+ <value field="code">TD</value>
+ <value field="name">Chad</value>
+ </row>
+ <row>
+ <value field="id">44</value>
+ <value field="code">CL</value>
+ <value field="name">Chile</value>
+ </row>
+ <row>
+ <value field="id">45</value>
+ <value field="code">CN</value>
+ <value field="name">China</value>
+ </row>
+ <row>
+ <value field="id">46</value>
+ <value field="code">CX</value>
+ <value field="name">Christmas Island</value>
+ </row>
+ <row>
+ <value field="id">47</value>
+ <value field="code">CC</value>
+ <value field="name">Cocos (Keeling) Islands</value>
+ </row>
+ <row>
+ <value field="id">48</value>
+ <value field="code">CO</value>
+ <value field="name">Colombia</value>
+ </row>
+ <row>
+ <value field="id">49</value>
+ <value field="code">KM</value>
+ <value field="name">Comoros</value>
+ </row>
+ <row>
+ <value field="id">50</value>
+ <value field="code">CG</value>
+ <value field="name">Congo</value>
+ </row>
+ <row>
+ <value field="id">51</value>
+ <value field="code">CD</value>
+ <value field="name">Congo, The Democratic Republic of the</value>
+ </row>
+ <row>
+ <value field="id">52</value>
+ <value field="code">CK</value>
+ <value field="name">Cook Islands</value>
+ </row>
+ <row>
+ <value field="id">53</value>
+ <value field="code">CR</value>
+ <value field="name">Costa Rica</value>
+ </row>
+ <row>
+ <value field="id">54</value>
+ <value field="code">CI</value>
+ <value field="name">Côte D'Ivoire</value>
+ </row>
+ <row>
+ <value field="id">55</value>
+ <value field="code">HR</value>
+ <value field="name">Croatia</value>
+ </row>
+ <row>
+ <value field="id">56</value>
+ <value field="code">CU</value>
+ <value field="name">Cuba</value>
+ </row>
+ <row>
+ <value field="id">57</value>
+ <value field="code">CY</value>
+ <value field="name">Cyprus</value>
+ </row>
+ <row>
+ <value field="id">58</value>
+ <value field="code">CZ</value>
+ <value field="name">Czech Republic</value>
+ </row>
+ <row>
+ <value field="id">59</value>
+ <value field="code">DK</value>
+ <value field="name">Denmark</value>
+ </row>
+ <row>
+ <value field="id">60</value>
+ <value field="code">DJ</value>
+ <value field="name">Djibouti</value>
+ </row>
+ <row>
+ <value field="id">61</value>
+ <value field="code">DM</value>
+ <value field="name">Dominica</value>
+ </row>
+ <row>
+ <value field="id">62</value>
+ <value field="code">DO</value>
+ <value field="name">Dominican Republic</value>
+ </row>
+ <row>
+ <value field="id">63</value>
+ <value field="code">EC</value>
+ <value field="name">Ecuador</value>
+ </row>
+ <row>
+ <value field="id">64</value>
+ <value field="code">EG</value>
+ <value field="name">Egypt</value>
+ </row>
+ <row>
+ <value field="id">65</value>
+ <value field="code">SV</value>
+ <value field="name">El Salvador</value>
+ </row>
+ <row>
+ <value field="id">66</value>
+ <value field="code">GQ</value>
+ <value field="name">Equatorial Guinea</value>
+ </row>
+ <row>
+ <value field="id">67</value>
+ <value field="code">ER</value>
+ <value field="name">Eritrea</value>
+ </row>
+ <row>
+ <value field="id">68</value>
+ <value field="code">EE</value>
+ <value field="name">Estonia</value>
+ </row>
+ <row>
+ <value field="id">69</value>
+ <value field="code">ET</value>
+ <value field="name">Ethiopia</value>
+ </row>
+ <row>
+ <value field="id">70</value>
+ <value field="code">FK</value>
+ <value field="name">Falkland Islands (Malvinas)</value>
+ </row>
+ <row>
+ <value field="id">71</value>
+ <value field="code">FO</value>
+ <value field="name">Faroe Islands</value>
+ </row>
+ <row>
+ <value field="id">72</value>
+ <value field="code">FJ</value>
+ <value field="name">Fiji</value>
+ </row>
+ <row>
+ <value field="id">73</value>
+ <value field="code">FI</value>
+ <value field="name">Finland</value>
+ </row>
+ <row>
+ <value field="id">74</value>
+ <value field="code">FR</value>
+ <value field="name">France</value>
+ </row>
+ <row>
+ <value field="id">75</value>
+ <value field="code">GF</value>
+ <value field="name">French Guiana</value>
+ </row>
+ <row>
+ <value field="id">76</value>
+ <value field="code">PF</value>
+ <value field="name">French Polynesia</value>
+ </row>
+ <row>
+ <value field="id">77</value>
+ <value field="code">TF</value>
+ <value field="name">French Southern Territories</value>
+ </row>
+ <row>
+ <value field="id">78</value>
+ <value field="code">GA</value>
+ <value field="name">Gabon</value>
+ </row>
+ <row>
+ <value field="id">79</value>
+ <value field="code">GM</value>
+ <value field="name">Gambia</value>
+ </row>
+ <row>
+ <value field="id">80</value>
+ <value field="code">GE</value>
+ <value field="name">Georgia</value>
+ </row>
+ <row>
+ <value field="id">81</value>
+ <value field="code">DE</value>
+ <value field="name">Germany</value>
+ </row>
+ <row>
+ <value field="id">82</value>
+ <value field="code">GH</value>
+ <value field="name">Ghana</value>
+ </row>
+ <row>
+ <value field="id">83</value>
+ <value field="code">GI</value>
+ <value field="name">Gibraltar</value>
+ </row>
+ <row>
+ <value field="id">84</value>
+ <value field="code">GR</value>
+ <value field="name">Greece</value>
+ </row>
+ <row>
+ <value field="id">85</value>
+ <value field="code">GL</value>
+ <value field="name">Greenland</value>
+ </row>
+ <row>
+ <value field="id">86</value>
+ <value field="code">GD</value>
+ <value field="name">Grenada</value>
+ </row>
+ <row>
+ <value field="id">87</value>
+ <value field="code">GP</value>
+ <value field="name">Guadeloupe</value>
+ </row>
+ <row>
+ <value field="id">88</value>
+ <value field="code">GU</value>
+ <value field="name">Guam</value>
+ </row>
+ <row>
+ <value field="id">89</value>
+ <value field="code">GT</value>
+ <value field="name">Guatemala</value>
+ </row>
+ <row>
+ <value field="id">90</value>
+ <value field="code">GG</value>
+ <value field="name">Guernsey</value>
+ </row>
+ <row>
+ <value field="id">91</value>
+ <value field="code">GN</value>
+ <value field="name">Guinea</value>
+ </row>
+ <row>
+ <value field="id">92</value>
+ <value field="code">GW</value>
+ <value field="name">Guinea-Bissau</value>
+ </row>
+ <row>
+ <value field="id">93</value>
+ <value field="code">GY</value>
+ <value field="name">Guyana</value>
+ </row>
+ <row>
+ <value field="id">94</value>
+ <value field="code">HT</value>
+ <value field="name">Haiti</value>
+ </row>
+ <row>
+ <value field="id">95</value>
+ <value field="code">HM</value>
+ <value field="name">Heard Island and Mcdonald Islands</value>
+ </row>
+ <row>
+ <value field="id">96</value>
+ <value field="code">VA</value>
+ <value field="name">Holy See (Vatican City State)</value>
+ </row>
+ <row>
+ <value field="id">97</value>
+ <value field="code">HN</value>
+ <value field="name">Honduras</value>
+ </row>
+ <row>
+ <value field="id">98</value>
+ <value field="code">HK</value>
+ <value field="name">Hong Kong</value>
+ </row>
+ <row>
+ <value field="id">99</value>
+ <value field="code">HU</value>
+ <value field="name">Hungary</value>
+ </row>
+ <row>
+ <value field="id">100</value>
+ <value field="code">IS</value>
+ <value field="name">Iceland</value>
+ </row>
+ <row>
+ <value field="id">101</value>
+ <value field="code">IN</value>
+ <value field="name">India</value>
+ </row>
+ <row>
+ <value field="id">102</value>
+ <value field="code">ID</value>
+ <value field="name">Indonesia</value>
+ </row>
+ <row>
+ <value field="id">103</value>
+ <value field="code">IR</value>
+ <value field="name">Iran, Islamic Republic of</value>
+ </row>
+ <row>
+ <value field="id">104</value>
+ <value field="code">IQ</value>
+ <value field="name">Iraq</value>
+ </row>
+ <row>
+ <value field="id">105</value>
+ <value field="code">IE</value>
+ <value field="name">Ireland</value>
+ </row>
+ <row>
+ <value field="id">106</value>
+ <value field="code">IL</value>
+ <value field="name">Israel</value>
+ </row>
+ <row>
+ <value field="id">107</value>
+ <value field="code">IT</value>
+ <value field="name">Italy</value>
+ </row>
+ <row>
+ <value field="id">108</value>
+ <value field="code">JM</value>
+ <value field="name">Jamaica</value>
+ </row>
+ <row>
+ <value field="id">109</value>
+ <value field="code">JP</value>
+ <value field="name">Japan</value>
+ </row>
+ <row>
+ <value field="id">110</value>
+ <value field="code">JO</value>
+ <value field="name">Jordan</value>
+ </row>
+ <row>
+ <value field="id">111</value>
+ <value field="code">KZ</value>
+ <value field="name">Kazakhstan</value>
+ </row>
+ <row>
+ <value field="id">112</value>
+ <value field="code">KE</value>
+ <value field="name">Kenya</value>
+ </row>
+ <row>
+ <value field="id">113</value>
+ <value field="code">KI</value>
+ <value field="name">Kiribati</value>
+ </row>
+ <row>
+ <value field="id">114</value>
+ <value field="code">KP</value>
+ <value field="name">Korea, Democratic People's Republic of</value>
+ </row>
+ <row>
+ <value field="id">115</value>
+ <value field="code">KR</value>
+ <value field="name">Korea, Republic of</value>
+ </row>
+ <row>
+ <value field="id">116</value>
+ <value field="code">KW</value>
+ <value field="name">Kuwait</value>
+ </row>
+ <row>
+ <value field="id">117</value>
+ <value field="code">KG</value>
+ <value field="name">Kyrgyzstan</value>
+ </row>
+ <row>
+ <value field="id">118</value>
+ <value field="code">LA</value>
+ <value field="name">Lao People's Democratic Republic</value>
+ </row>
+ <row>
+ <value field="id">119</value>
+ <value field="code">LV</value>
+ <value field="name">Latvia</value>
+ </row>
+ <row>
+ <value field="id">120</value>
+ <value field="code">LB</value>
+ <value field="name">Lebanon</value>
+ </row>
+ <row>
+ <value field="id">121</value>
+ <value field="code">LS</value>
+ <value field="name">Lesotho</value>
+ </row>
+ <row>
+ <value field="id">122</value>
+ <value field="code">LR</value>
+ <value field="name">Liberia</value>
+ </row>
+ <row>
+ <value field="id">123</value>
+ <value field="code">LY</value>
+ <value field="name">Libyan Arab Jamahiriya</value>
+ </row>
+ <row>
+ <value field="id">124</value>
+ <value field="code">LI</value>
+ <value field="name">Liechtenstein</value>
+ </row>
+ <row>
+ <value field="id">125</value>
+ <value field="code">LT</value>
+ <value field="name">Lithuania</value>
+ </row>
+ <row>
+ <value field="id">126</value>
+ <value field="code">LU</value>
+ <value field="name">Luxembourg</value>
+ </row>
+ <row>
+ <value field="id">127</value>
+ <value field="code">MO</value>
+ <value field="name">Macao</value>
+ </row>
+ <row>
+ <value field="id">128</value>
+ <value field="code">MK</value>
+ <value field="name">Macedonia, The Former Yugoslav Republic
of</value>
+ </row>
+ <row>
+ <value field="id">129</value>
+ <value field="code">MG</value>
+ <value field="name">Madagascar</value>
+ </row>
+ <row>
+ <value field="id">130</value>
+ <value field="code">MW</value>
+ <value field="name">Malawi</value>
+ </row>
+ <row>
+ <value field="id">131</value>
+ <value field="code">MY</value>
+ <value field="name">Malaysia</value>
+ </row>
+ <row>
+ <value field="id">132</value>
+ <value field="code">MV</value>
+ <value field="name">Maldives</value>
+ </row>
+ <row>
+ <value field="id">133</value>
+ <value field="code">ML</value>
+ <value field="name">Mali</value>
+ </row>
+ <row>
+ <value field="id">134</value>
+ <value field="code">MT</value>
+ <value field="name">Malta</value>
+ </row>
+ <row>
+ <value field="id">135</value>
+ <value field="code">MH</value>
+ <value field="name">Marshall Islands</value>
+ </row>
+ <row>
+ <value field="id">136</value>
+ <value field="code">MQ</value>
+ <value field="name">Martinique</value>
+ </row>
+ <row>
+ <value field="id">137</value>
+ <value field="code">MR</value>
+ <value field="name">Mauritania</value>
+ </row>
+ <row>
+ <value field="id">138</value>
+ <value field="code">MU</value>
+ <value field="name">Mauritius</value>
+ </row>
+ <row>
+ <value field="id">139</value>
+ <value field="code">YT</value>
+ <value field="name">Mayotte</value>
+ </row>
+ <row>
+ <value field="id">140</value>
+ <value field="code">MX</value>
+ <value field="name">Mexico</value>
+ </row>
+ <row>
+ <value field="id">141</value>
+ <value field="code">FM</value>
+ <value field="name">Micronesia, Federated States of</value>
+ </row>
+ <row>
+ <value field="id">142</value>
+ <value field="code">MD</value>
+ <value field="name">Moldova, Republic of</value>
+ </row>
+ <row>
+ <value field="id">143</value>
+ <value field="code">MC</value>
+ <value field="name">Monaco</value>
+ </row>
+ <row>
+ <value field="id">144</value>
+ <value field="code">MN</value>
+ <value field="name">Mongolia</value>
+ </row>
+ <row>
+ <value field="id">145</value>
+ <value field="code">ME</value>
+ <value field="name">Montenegro</value>
+ </row>
+ <row>
+ <value field="id">146</value>
+ <value field="code">MS</value>
+ <value field="name">Montserrat</value>
+ </row>
+ <row>
+ <value field="id">147</value>
+ <value field="code">MA</value>
+ <value field="name">Morocco</value>
+ </row>
+ <row>
+ <value field="id">148</value>
+ <value field="code">MZ</value>
+ <value field="name">Mozambique</value>
+ </row>
+ <row>
+ <value field="id">149</value>
+ <value field="code">MM</value>
+ <value field="name">Myanmar</value>
+ </row>
+ <row>
+ <value field="id">150</value>
+ <value field="code">NA</value>
+ <value field="name">Namibia</value>
+ </row>
+ <row>
+ <value field="id">151</value>
+ <value field="code">NR</value>
+ <value field="name">Nauru</value>
+ </row>
+ <row>
+ <value field="id">152</value>
+ <value field="code">NP</value>
+ <value field="name">Nepal</value>
+ </row>
+ <row>
+ <value field="id">153</value>
+ <value field="code">NL</value>
+ <value field="name">Netherlands</value>
+ </row>
+ <row>
+ <value field="id">154</value>
+ <value field="code">AN</value>
+ <value field="name">Netherlands Antilles</value>
+ </row>
+ <row>
+ <value field="id">155</value>
+ <value field="code">NC</value>
+ <value field="name">New Caledonia</value>
+ </row>
+ <row>
+ <value field="id">156</value>
+ <value field="code">NZ</value>
+ <value field="name">New Zealand</value>
+ </row>
+ <row>
+ <value field="id">157</value>
+ <value field="code">NI</value>
+ <value field="name">Nicaragua</value>
+ </row>
+ <row>
+ <value field="id">158</value>
+ <value field="code">NE</value>
+ <value field="name">Niger</value>
+ </row>
+ <row>
+ <value field="id">159</value>
+ <value field="code">NG</value>
+ <value field="name">Nigeria</value>
+ </row>
+ <row>
+ <value field="id">160</value>
+ <value field="code">NU</value>
+ <value field="name">Niue</value>
+ </row>
+ <row>
+ <value field="id">161</value>
+ <value field="code">NF</value>
+ <value field="name">Norfolk Island</value>
+ </row>
+ <row>
+ <value field="id">162</value>
+ <value field="code">MP</value>
+ <value field="name">Northern Mariana Islands</value>
+ </row>
+ <row>
+ <value field="id">163</value>
+ <value field="code">NO</value>
+ <value field="name">Norway</value>
+ </row>
+ <row>
+ <value field="id">164</value>
+ <value field="code">OM</value>
+ <value field="name">Oman</value>
+ </row>
+ <row>
+ <value field="id">165</value>
+ <value field="code">PK</value>
+ <value field="name">Pakistan</value>
+ </row>
+ <row>
+ <value field="id">166</value>
+ <value field="code">PW</value>
+ <value field="name">Palau</value>
+ </row>
+ <row>
+ <value field="id">167</value>
+ <value field="code">PS</value>
+ <value field="name">Palestinian Territory, Occupied</value>
+ </row>
+ <row>
+ <value field="id">168</value>
+ <value field="code">PA</value>
+ <value field="name">Panama</value>
+ </row>
+ <row>
+ <value field="id">169</value>
+ <value field="code">PG</value>
+ <value field="name">Papua New Guinea</value>
+ </row>
+ <row>
+ <value field="id">170</value>
+ <value field="code">PY</value>
+ <value field="name">Paraguay</value>
+ </row>
+ <row>
+ <value field="id">171</value>
+ <value field="code">PE</value>
+ <value field="name">Peru</value>
+ </row>
+ <row>
+ <value field="id">172</value>
+ <value field="code">PH</value>
+ <value field="name">Philippines</value>
+ </row>
+ <row>
+ <value field="id">173</value>
+ <value field="code">PN</value>
+ <value field="name">Pitcairn</value>
+ </row>
+ <row>
+ <value field="id">174</value>
+ <value field="code">PL</value>
+ <value field="name">Poland</value>
+ </row>
+ <row>
+ <value field="id">175</value>
+ <value field="code">PT</value>
+ <value field="name">Portugal</value>
+ </row>
+ <row>
+ <value field="id">176</value>
+ <value field="code">PR</value>
+ <value field="name">Puerto Rico</value>
+ </row>
+ <row>
+ <value field="id">177</value>
+ <value field="code">QA</value>
+ <value field="name">Qatar</value>
+ </row>
+ <row>
+ <value field="id">178</value>
+ <value field="code">RE</value>
+ <value field="name">Réunion</value>
+ </row>
+ <row>
+ <value field="id">179</value>
+ <value field="code">RO</value>
+ <value field="name">Romania</value>
+ </row>
+ <row>
+ <value field="id">180</value>
+ <value field="code">RU</value>
+ <value field="name">Russian Federation</value>
+ </row>
+ <row>
+ <value field="id">181</value>
+ <value field="code">RW</value>
+ <value field="name">Rwanda</value>
+ </row>
+ <row>
+ <value field="id">182</value>
+ <value field="code">SH</value>
+ <value field="name">Saint Helena</value>
+ </row>
+ <row>
+ <value field="id">183</value>
+ <value field="code">KN</value>
+ <value field="name">Saint Kitts and Nevis</value>
+ </row>
+ <row>
+ <value field="id">184</value>
+ <value field="code">LC</value>
+ <value field="name">Saint Lucia</value>
+ </row>
+ <row>
+ <value field="id">185</value>
+ <value field="code">PM</value>
+ <value field="name">Saint Pierre and Miquelon</value>
+ </row>
+ <row>
+ <value field="id">186</value>
+ <value field="code">VC</value>
+ <value field="name">Saint Vincent and The Grenadines</value>
+ </row>
+ <row>
+ <value field="id">187</value>
+ <value field="code">WS</value>
+ <value field="name">Samoa</value>
+ </row>
+ <row>
+ <value field="id">188</value>
+ <value field="code">SM</value>
+ <value field="name">San Marino</value>
+ </row>
+ <row>
+ <value field="id">189</value>
+ <value field="code">ST</value>
+ <value field="name">Sao Tome and Principe</value>
+ </row>
+ <row>
+ <value field="id">190</value>
+ <value field="code">SA</value>
+ <value field="name">Saudi Arabia</value>
+ </row>
+ <row>
+ <value field="id">191</value>
+ <value field="code">SN</value>
+ <value field="name">Senegal</value>
+ </row>
+ <row>
+ <value field="id">192</value>
+ <value field="code">RS</value>
+ <value field="name">Serbia</value>
+ </row>
+ <row>
+ <value field="id">193</value>
+ <value field="code">SC</value>
+ <value field="name">Seychelles</value>
+ </row>
+ <row>
+ <value field="id">194</value>
+ <value field="code">SL</value>
+ <value field="name">Sierra Leone</value>
+ </row>
+ <row>
+ <value field="id">195</value>
+ <value field="code">SG</value>
+ <value field="name">Singapore</value>
+ </row>
+ <row>
+ <value field="id">196</value>
+ <value field="code">SK</value>
+ <value field="name">Slovakia</value>
+ </row>
+ <row>
+ <value field="id">197</value>
+ <value field="code">SI</value>
+ <value field="name">Slovenia</value>
+ </row>
+ <row>
+ <value field="id">198</value>
+ <value field="code">SB</value>
+ <value field="name">Solomon Islands</value>
+ </row>
+ <row>
+ <value field="id">199</value>
+ <value field="code">SO</value>
+ <value field="name">Somalia</value>
+ </row>
+ <row>
+ <value field="id">200</value>
+ <value field="code">ZA</value>
+ <value field="name">South Africa</value>
+ </row>
+ <row>
+ <value field="id">201</value>
+ <value field="code">GS</value>
+ <value field="name">South Georgia and The South Sandwich
Islands</value>
+ </row>
+ <row>
+ <value field="id">202</value>
+ <value field="code">ES</value>
+ <value field="name">Spain</value>
+ </row>
+ <row>
+ <value field="id">203</value>
+ <value field="code">LK</value>
+ <value field="name">Sri Lanka</value>
+ </row>
+ <row>
+ <value field="id">204</value>
+ <value field="code">SD</value>
+ <value field="name">Sudan</value>
+ </row>
+ <row>
+ <value field="id">205</value>
+ <value field="code">SR</value>
+ <value field="name">Suriname</value>
+ </row>
+ <row>
+ <value field="id">206</value>
+ <value field="code">SJ</value>
+ <value field="name">Svalbard and Jan Mayen</value>
+ </row>
+ <row>
+ <value field="id">207</value>
+ <value field="code">SZ</value>
+ <value field="name">Swaziland</value>
+ </row>
+ <row>
+ <value field="id">208</value>
+ <value field="code">SE</value>
+ <value field="name">Sweden</value>
+ </row>
+ <row>
+ <value field="id">209</value>
+ <value field="code">CH</value>
+ <value field="name">Switzerland</value>
+ </row>
+ <row>
+ <value field="id">210</value>
+ <value field="code">SY</value>
+ <value field="name">Syrian Arab Republic</value>
+ </row>
+ <row>
+ <value field="id">211</value>
+ <value field="code">TW</value>
+ <value field="name">Taiwan, Province of China</value>
+ </row>
+ <row>
+ <value field="id">212</value>
+ <value field="code">TJ</value>
+ <value field="name">Tajikistan</value>
+ </row>
+ <row>
+ <value field="id">213</value>
+ <value field="code">TZ</value>
+ <value field="name">Tanzania, United Republic of</value>
+ </row>
+ <row>
+ <value field="id">214</value>
+ <value field="code">TH</value>
+ <value field="name">Thailand</value>
+ </row>
+ <row>
+ <value field="id">215</value>
+ <value field="code">TL</value>
+ <value field="name">Timor-Leste</value>
+ </row>
+ <row>
+ <value field="id">216</value>
+ <value field="code">TG</value>
+ <value field="name">Togo</value>
+ </row>
+ <row>
+ <value field="id">217</value>
+ <value field="code">TK</value>
+ <value field="name">Tokelau</value>
+ </row>
+ <row>
+ <value field="id">218</value>
+ <value field="code">TO</value>
+ <value field="name">Tonga</value>
+ </row>
+ <row>
+ <value field="id">219</value>
+ <value field="code">TT</value>
+ <value field="name">Trinidad and Tobago</value>
+ </row>
+ <row>
+ <value field="id">220</value>
+ <value field="code">TN</value>
+ <value field="name">Tunisia</value>
+ </row>
+ <row>
+ <value field="id">221</value>
+ <value field="code">TR</value>
+ <value field="name">Turkey</value>
+ </row>
+ <row>
+ <value field="id">222</value>
+ <value field="code">TM</value>
+ <value field="name">Turkmenistan</value>
+ </row>
+ <row>
+ <value field="id">223</value>
+ <value field="code">TC</value>
+ <value field="name">Turks and Caicos Islands</value>
+ </row>
+ <row>
+ <value field="id">224</value>
+ <value field="code">TV</value>
+ <value field="name">Tuvalu</value>
+ </row>
+ <row>
+ <value field="id">225</value>
+ <value field="code">UG</value>
+ <value field="name">Uganda</value>
+ </row>
+ <row>
+ <value field="id">226</value>
+ <value field="code">UA</value>
+ <value field="name">Ukraine</value>
+ </row>
+ <row>
+ <value field="id">227</value>
+ <value field="code">AE</value>
+ <value field="name">United Arab Emirates</value>
+ </row>
+ <row>
+ <value field="id">228</value>
+ <value field="code">GB</value>
+ <value field="name">United Kingdom</value>
+ </row>
+ <row>
+ <value field="id">229</value>
+ <value field="code">US</value>
+ <value field="name">United States</value>
+ </row>
+ <row>
+ <value field="id">230</value>
+ <value field="code">UM</value>
+ <value field="name">United States Minor Outlying Islands</value>
+ </row>
+ <row>
+ <value field="id">231</value>
+ <value field="code">UY</value>
+ <value field="name">Uruguay</value>
+ </row>
+ <row>
+ <value field="id">232</value>
+ <value field="code">UZ</value>
+ <value field="name">Uzbekistan</value>
+ </row>
+ <row>
+ <value field="id">233</value>
+ <value field="code">VU</value>
+ <value field="name">Vanuatu</value>
+ </row>
+ <row>
+ <value field="id">234</value>
+ <value field="code">VE</value>
+ <value field="name">Venezuela</value>
+ </row>
+ <row>
+ <value field="id">235</value>
+ <value field="code">VN</value>
+ <value field="name">Viet Nam</value>
+ </row>
+ <row>
+ <value field="id">236</value>
+ <value field="code">VG</value>
+ <value field="name">Virgin Islands, British</value>
+ </row>
+ <row>
+ <value field="id">237</value>
+ <value field="code">VI</value>
+ <value field="name">Virgin Islands, U.S.</value>
+ </row>
+ <row>
+ <value field="id">238</value>
+ <value field="code">WF</value>
+ <value field="name">Wallis and Futuna</value>
+ </row>
+ <row>
+ <value field="id">239</value>
+ <value field="code">EH</value>
+ <value field="name">Western Sahara</value>
+ </row>
+ <row>
+ <value field="id">240</value>
+ <value field="code">YE</value>
+ <value field="name">Yemen</value>
+ </row>
+ <row>
+ <value field="id">241</value>
+ <value field="code">ZM</value>
+ <value field="name">Zambia</value>
+ </row>
+ <row>
+ <value field="id">242</value>
+ <value field="code">ZW</value>
+ <value field="name">Zimbabwe</value>
+ </row>
+ </rows>
+ </tabledata>
+ </data>
+
+</schema>
Modified: trunk/gnue-samples/two-tier/schema/customer.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/customer.gsd 2007-01-04 22:45:24 UTC
(rev 9203)
+++ trunk/gnue-samples/two-tier/schema/customer.gsd 2007-01-05 08:02:14 UTC
(rev 9204)
@@ -14,7 +14,7 @@
<field name="address2" type="string" length="50" />
<field name="city" type="string" length="30" />
<field name="zip" type="string" length="10" />
- <field name="state" type="number" length="8" />
+ <field name="country" type="number" length="8" />
<field name="billing_address" type="number" length="8" />
<field name="created" type="datetime" nullable="N" />
<field name="last_invoice" type="date" />
@@ -26,8 +26,8 @@
</primarykey>
<constraints>
- <foreignkey name="fk_customer_state" references="state">
- <fkfield name="state" references="id" />
+ <foreignkey name="fk_customer_country" references="country">
+ <fkfield name="country" references="id" />
</foreignkey>
<foreignkey name="fk_customer_billing" references="customer">
@@ -48,7 +48,7 @@
<value field="address2">Suite A</value>
<value field="city">Manhattan</value>
<value field="zip">66502</value>
- <value field="state">229</value>
+ <value field="country">229</value>
<value field="created">2004-07-21 14:21:59</value>
</row>
<row>
@@ -58,7 +58,7 @@
<value field="address1">6789 N. Main</value>
<value field="city">Ellsworth</value>
<value field="zip">67439</value>
- <value field="state">229</value>
+ <value field="country">229</value>
<value field="billing_address">0</value>
<value field="created">2005-12-03 07:48:02</value>
</row>
@@ -69,7 +69,7 @@
<value field="address1">Kaiserstrasse 23</value>
<value field="city">Bregenz</value>
<value field="zip">6900</value>
- <value field="state">15</value>
+ <value field="country">15</value>
<value field="created">2006-06-20 17:05:17</value>
</row>
<row>
@@ -79,7 +79,7 @@
<value field="address1">Im Städtschen Zoo 1</value>
<value field="city">Neustadt</value>
<value field="zip">4711</value>
- <value field="state">2</value>
+ <value field="country">2</value>
<value field="created">2001-01-20 15:01:41</value>
</row>
</rows>
Deleted: trunk/gnue-samples/two-tier/schema/state.gsd
===================================================================
--- trunk/gnue-samples/two-tier/schema/state.gsd 2007-01-04 22:45:24 UTC
(rev 9203)
+++ trunk/gnue-samples/two-tier/schema/state.gsd 2007-01-05 08:02:14 UTC
(rev 9204)
@@ -1,1239 +0,0 @@
-<?xml version="1.0" encoding="utf-8"?>
-
-<schema>
-
- <tables>
- <table name="state">
- <fields>
- <field name="id" type="number" length="8" nullable="False"
- defaultwith="serial"/>
- <field name="code" type="string" length="2" nullable="False"/>
- <field name="name" type="string" length="50" nullable="False"/>
- </fields>
-
- <primarykey name="pk_state">
- <pkfield name="id"/>
- </primarykey>
-
- <constraints/>
- </table>
- </tables>
-
- <data>
- <tabledata name="iso_3166_states" tablename="state">
- <rows>
- <row>
- <value field="id">1</value>
- <value field="code">AF</value>
- <value field="name">Afghanistan</value>
- </row>
- <row>
- <value field="id">2</value>
- <value field="code">AX</value>
- <value field="name">Åland Islands</value>
- </row>
- <row>
- <value field="id">3</value>
- <value field="code">AL</value>
- <value field="name">Albania</value>
- </row>
- <row>
- <value field="id">4</value>
- <value field="code">DZ</value>
- <value field="name">Algeria</value>
- </row>
- <row>
- <value field="id">5</value>
- <value field="code">AS</value>
- <value field="name">American Samoa</value>
- </row>
- <row>
- <value field="id">6</value>
- <value field="code">AD</value>
- <value field="name">Andorra</value>
- </row>
- <row>
- <value field="id">7</value>
- <value field="code">AO</value>
- <value field="name">Angola</value>
- </row>
- <row>
- <value field="id">8</value>
- <value field="code">AI</value>
- <value field="name">Anguilla</value>
- </row>
- <row>
- <value field="id">9</value>
- <value field="code">AQ</value>
- <value field="name">Antarctica</value>
- </row>
- <row>
- <value field="id">10</value>
- <value field="code">AG</value>
- <value field="name">Antigua and Barbuda</value>
- </row>
- <row>
- <value field="id">11</value>
- <value field="code">AR</value>
- <value field="name">Argentina</value>
- </row>
- <row>
- <value field="id">12</value>
- <value field="code">AM</value>
- <value field="name">Armenia</value>
- </row>
- <row>
- <value field="id">13</value>
- <value field="code">AW</value>
- <value field="name">Aruba</value>
- </row>
- <row>
- <value field="id">14</value>
- <value field="code">AU</value>
- <value field="name">Australia</value>
- </row>
- <row>
- <value field="id">15</value>
- <value field="code">AT</value>
- <value field="name">Austria</value>
- </row>
- <row>
- <value field="id">16</value>
- <value field="code">AZ</value>
- <value field="name">Azerbaijan</value>
- </row>
- <row>
- <value field="id">17</value>
- <value field="code">BS</value>
- <value field="name">Bahamas</value>
- </row>
- <row>
- <value field="id">18</value>
- <value field="code">BH</value>
- <value field="name">Bahrain</value>
- </row>
- <row>
- <value field="id">19</value>
- <value field="code">BD</value>
- <value field="name">Bangladesh</value>
- </row>
- <row>
- <value field="id">20</value>
- <value field="code">BB</value>
- <value field="name">Barbados</value>
- </row>
- <row>
- <value field="id">21</value>
- <value field="code">BY</value>
- <value field="name">Belarus</value>
- </row>
- <row>
- <value field="id">22</value>
- <value field="code">BE</value>
- <value field="name">Belgium</value>
- </row>
- <row>
- <value field="id">23</value>
- <value field="code">BZ</value>
- <value field="name">Belize</value>
- </row>
- <row>
- <value field="id">24</value>
- <value field="code">BJ</value>
- <value field="name">Benin</value>
- </row>
- <row>
- <value field="id">25</value>
- <value field="code">BM</value>
- <value field="name">Bermuda</value>
- </row>
- <row>
- <value field="id">26</value>
- <value field="code">BT</value>
- <value field="name">Bhutan</value>
- </row>
- <row>
- <value field="id">27</value>
- <value field="code">BO</value>
- <value field="name">Bolivia</value>
- </row>
- <row>
- <value field="id">28</value>
- <value field="code">BA</value>
- <value field="name">Bosnia and Herzegovina</value>
- </row>
- <row>
- <value field="id">29</value>
- <value field="code">BW</value>
- <value field="name">Botswana</value>
- </row>
- <row>
- <value field="id">30</value>
- <value field="code">BV</value>
- <value field="name">Bouvet Island</value>
- </row>
- <row>
- <value field="id">31</value>
- <value field="code">BR</value>
- <value field="name">Brazil</value>
- </row>
- <row>
- <value field="id">32</value>
- <value field="code">IO</value>
- <value field="name">British Indian Ocean Territory</value>
- </row>
- <row>
- <value field="id">33</value>
- <value field="code">BN</value>
- <value field="name">Brunei Darussalam</value>
- </row>
- <row>
- <value field="id">34</value>
- <value field="code">BG</value>
- <value field="name">Bulgaria</value>
- </row>
- <row>
- <value field="id">35</value>
- <value field="code">BF</value>
- <value field="name">Burkina Faso</value>
- </row>
- <row>
- <value field="id">36</value>
- <value field="code">BI</value>
- <value field="name">Burundi</value>
- </row>
- <row>
- <value field="id">37</value>
- <value field="code">KH</value>
- <value field="name">Cambodia</value>
- </row>
- <row>
- <value field="id">38</value>
- <value field="code">CM</value>
- <value field="name">Cameroon</value>
- </row>
- <row>
- <value field="id">39</value>
- <value field="code">CA</value>
- <value field="name">Canada</value>
- </row>
- <row>
- <value field="id">40</value>
- <value field="code">CV</value>
- <value field="name">Cape Verde</value>
- </row>
- <row>
- <value field="id">41</value>
- <value field="code">KY</value>
- <value field="name">Cayman Islands</value>
- </row>
- <row>
- <value field="id">42</value>
- <value field="code">CF</value>
- <value field="name">Central African Republic</value>
- </row>
- <row>
- <value field="id">43</value>
- <value field="code">TD</value>
- <value field="name">Chad</value>
- </row>
- <row>
- <value field="id">44</value>
- <value field="code">CL</value>
- <value field="name">Chile</value>
- </row>
- <row>
- <value field="id">45</value>
- <value field="code">CN</value>
- <value field="name">China</value>
- </row>
- <row>
- <value field="id">46</value>
- <value field="code">CX</value>
- <value field="name">Christmas Island</value>
- </row>
- <row>
- <value field="id">47</value>
- <value field="code">CC</value>
- <value field="name">Cocos (Keeling) Islands</value>
- </row>
- <row>
- <value field="id">48</value>
- <value field="code">CO</value>
- <value field="name">Colombia</value>
- </row>
- <row>
- <value field="id">49</value>
- <value field="code">KM</value>
- <value field="name">Comoros</value>
- </row>
- <row>
- <value field="id">50</value>
- <value field="code">CG</value>
- <value field="name">Congo</value>
- </row>
- <row>
- <value field="id">51</value>
- <value field="code">CD</value>
- <value field="name">Congo, The Democratic Republic of the</value>
- </row>
- <row>
- <value field="id">52</value>
- <value field="code">CK</value>
- <value field="name">Cook Islands</value>
- </row>
- <row>
- <value field="id">53</value>
- <value field="code">CR</value>
- <value field="name">Costa Rica</value>
- </row>
- <row>
- <value field="id">54</value>
- <value field="code">CI</value>
- <value field="name">Côte D'Ivoire</value>
- </row>
- <row>
- <value field="id">55</value>
- <value field="code">HR</value>
- <value field="name">Croatia</value>
- </row>
- <row>
- <value field="id">56</value>
- <value field="code">CU</value>
- <value field="name">Cuba</value>
- </row>
- <row>
- <value field="id">57</value>
- <value field="code">CY</value>
- <value field="name">Cyprus</value>
- </row>
- <row>
- <value field="id">58</value>
- <value field="code">CZ</value>
- <value field="name">Czech Republic</value>
- </row>
- <row>
- <value field="id">59</value>
- <value field="code">DK</value>
- <value field="name">Denmark</value>
- </row>
- <row>
- <value field="id">60</value>
- <value field="code">DJ</value>
- <value field="name">Djibouti</value>
- </row>
- <row>
- <value field="id">61</value>
- <value field="code">DM</value>
- <value field="name">Dominica</value>
- </row>
- <row>
- <value field="id">62</value>
- <value field="code">DO</value>
- <value field="name">Dominican Republic</value>
- </row>
- <row>
- <value field="id">63</value>
- <value field="code">EC</value>
- <value field="name">Ecuador</value>
- </row>
- <row>
- <value field="id">64</value>
- <value field="code">EG</value>
- <value field="name">Egypt</value>
- </row>
- <row>
- <value field="id">65</value>
- <value field="code">SV</value>
- <value field="name">El Salvador</value>
- </row>
- <row>
- <value field="id">66</value>
- <value field="code">GQ</value>
- <value field="name">Equatorial Guinea</value>
- </row>
- <row>
- <value field="id">67</value>
- <value field="code">ER</value>
- <value field="name">Eritrea</value>
- </row>
- <row>
- <value field="id">68</value>
- <value field="code">EE</value>
- <value field="name">Estonia</value>
- </row>
- <row>
- <value field="id">69</value>
- <value field="code">ET</value>
- <value field="name">Ethiopia</value>
- </row>
- <row>
- <value field="id">70</value>
- <value field="code">FK</value>
- <value field="name">Falkland Islands (Malvinas)</value>
- </row>
- <row>
- <value field="id">71</value>
- <value field="code">FO</value>
- <value field="name">Faroe Islands</value>
- </row>
- <row>
- <value field="id">72</value>
- <value field="code">FJ</value>
- <value field="name">Fiji</value>
- </row>
- <row>
- <value field="id">73</value>
- <value field="code">FI</value>
- <value field="name">Finland</value>
- </row>
- <row>
- <value field="id">74</value>
- <value field="code">FR</value>
- <value field="name">France</value>
- </row>
- <row>
- <value field="id">75</value>
- <value field="code">GF</value>
- <value field="name">French Guiana</value>
- </row>
- <row>
- <value field="id">76</value>
- <value field="code">PF</value>
- <value field="name">French Polynesia</value>
- </row>
- <row>
- <value field="id">77</value>
- <value field="code">TF</value>
- <value field="name">French Southern Territories</value>
- </row>
- <row>
- <value field="id">78</value>
- <value field="code">GA</value>
- <value field="name">Gabon</value>
- </row>
- <row>
- <value field="id">79</value>
- <value field="code">GM</value>
- <value field="name">Gambia</value>
- </row>
- <row>
- <value field="id">80</value>
- <value field="code">GE</value>
- <value field="name">Georgia</value>
- </row>
- <row>
- <value field="id">81</value>
- <value field="code">DE</value>
- <value field="name">Germany</value>
- </row>
- <row>
- <value field="id">82</value>
- <value field="code">GH</value>
- <value field="name">Ghana</value>
- </row>
- <row>
- <value field="id">83</value>
- <value field="code">GI</value>
- <value field="name">Gibraltar</value>
- </row>
- <row>
- <value field="id">84</value>
- <value field="code">GR</value>
- <value field="name">Greece</value>
- </row>
- <row>
- <value field="id">85</value>
- <value field="code">GL</value>
- <value field="name">Greenland</value>
- </row>
- <row>
- <value field="id">86</value>
- <value field="code">GD</value>
- <value field="name">Grenada</value>
- </row>
- <row>
- <value field="id">87</value>
- <value field="code">GP</value>
- <value field="name">Guadeloupe</value>
- </row>
- <row>
- <value field="id">88</value>
- <value field="code">GU</value>
- <value field="name">Guam</value>
- </row>
- <row>
- <value field="id">89</value>
- <value field="code">GT</value>
- <value field="name">Guatemala</value>
- </row>
- <row>
- <value field="id">90</value>
- <value field="code">GG</value>
- <value field="name">Guernsey</value>
- </row>
- <row>
- <value field="id">91</value>
- <value field="code">GN</value>
- <value field="name">Guinea</value>
- </row>
- <row>
- <value field="id">92</value>
- <value field="code">GW</value>
- <value field="name">Guinea-Bissau</value>
- </row>
- <row>
- <value field="id">93</value>
- <value field="code">GY</value>
- <value field="name">Guyana</value>
- </row>
- <row>
- <value field="id">94</value>
- <value field="code">HT</value>
- <value field="name">Haiti</value>
- </row>
- <row>
- <value field="id">95</value>
- <value field="code">HM</value>
- <value field="name">Heard Island and Mcdonald Islands</value>
- </row>
- <row>
- <value field="id">96</value>
- <value field="code">VA</value>
- <value field="name">Holy See (Vatican City State)</value>
- </row>
- <row>
- <value field="id">97</value>
- <value field="code">HN</value>
- <value field="name">Honduras</value>
- </row>
- <row>
- <value field="id">98</value>
- <value field="code">HK</value>
- <value field="name">Hong Kong</value>
- </row>
- <row>
- <value field="id">99</value>
- <value field="code">HU</value>
- <value field="name">Hungary</value>
- </row>
- <row>
- <value field="id">100</value>
- <value field="code">IS</value>
- <value field="name">Iceland</value>
- </row>
- <row>
- <value field="id">101</value>
- <value field="code">IN</value>
- <value field="name">India</value>
- </row>
- <row>
- <value field="id">102</value>
- <value field="code">ID</value>
- <value field="name">Indonesia</value>
- </row>
- <row>
- <value field="id">103</value>
- <value field="code">IR</value>
- <value field="name">Iran, Islamic Republic of</value>
- </row>
- <row>
- <value field="id">104</value>
- <value field="code">IQ</value>
- <value field="name">Iraq</value>
- </row>
- <row>
- <value field="id">105</value>
- <value field="code">IE</value>
- <value field="name">Ireland</value>
- </row>
- <row>
- <value field="id">106</value>
- <value field="code">IL</value>
- <value field="name">Israel</value>
- </row>
- <row>
- <value field="id">107</value>
- <value field="code">IT</value>
- <value field="name">Italy</value>
- </row>
- <row>
- <value field="id">108</value>
- <value field="code">JM</value>
- <value field="name">Jamaica</value>
- </row>
- <row>
- <value field="id">109</value>
- <value field="code">JP</value>
- <value field="name">Japan</value>
- </row>
- <row>
- <value field="id">110</value>
- <value field="code">JO</value>
- <value field="name">Jordan</value>
- </row>
- <row>
- <value field="id">111</value>
- <value field="code">KZ</value>
- <value field="name">Kazakhstan</value>
- </row>
- <row>
- <value field="id">112</value>
- <value field="code">KE</value>
- <value field="name">Kenya</value>
- </row>
- <row>
- <value field="id">113</value>
- <value field="code">KI</value>
- <value field="name">Kiribati</value>
- </row>
- <row>
- <value field="id">114</value>
- <value field="code">KP</value>
- <value field="name">Korea, Democratic People's Republic of</value>
- </row>
- <row>
- <value field="id">115</value>
- <value field="code">KR</value>
- <value field="name">Korea, Republic of</value>
- </row>
- <row>
- <value field="id">116</value>
- <value field="code">KW</value>
- <value field="name">Kuwait</value>
- </row>
- <row>
- <value field="id">117</value>
- <value field="code">KG</value>
- <value field="name">Kyrgyzstan</value>
- </row>
- <row>
- <value field="id">118</value>
- <value field="code">LA</value>
- <value field="name">Lao People's Democratic Republic</value>
- </row>
- <row>
- <value field="id">119</value>
- <value field="code">LV</value>
- <value field="name">Latvia</value>
- </row>
- <row>
- <value field="id">120</value>
- <value field="code">LB</value>
- <value field="name">Lebanon</value>
- </row>
- <row>
- <value field="id">121</value>
- <value field="code">LS</value>
- <value field="name">Lesotho</value>
- </row>
- <row>
- <value field="id">122</value>
- <value field="code">LR</value>
- <value field="name">Liberia</value>
- </row>
- <row>
- <value field="id">123</value>
- <value field="code">LY</value>
- <value field="name">Libyan Arab Jamahiriya</value>
- </row>
- <row>
- <value field="id">124</value>
- <value field="code">LI</value>
- <value field="name">Liechtenstein</value>
- </row>
- <row>
- <value field="id">125</value>
- <value field="code">LT</value>
- <value field="name">Lithuania</value>
- </row>
- <row>
- <value field="id">126</value>
- <value field="code">LU</value>
- <value field="name">Luxembourg</value>
- </row>
- <row>
- <value field="id">127</value>
- <value field="code">MO</value>
- <value field="name">Macao</value>
- </row>
- <row>
- <value field="id">128</value>
- <value field="code">MK</value>
- <value field="name">Macedonia, The Former Yugoslav Republic
of</value>
- </row>
- <row>
- <value field="id">129</value>
- <value field="code">MG</value>
- <value field="name">Madagascar</value>
- </row>
- <row>
- <value field="id">130</value>
- <value field="code">MW</value>
- <value field="name">Malawi</value>
- </row>
- <row>
- <value field="id">131</value>
- <value field="code">MY</value>
- <value field="name">Malaysia</value>
- </row>
- <row>
- <value field="id">132</value>
- <value field="code">MV</value>
- <value field="name">Maldives</value>
- </row>
- <row>
- <value field="id">133</value>
- <value field="code">ML</value>
- <value field="name">Mali</value>
- </row>
- <row>
- <value field="id">134</value>
- <value field="code">MT</value>
- <value field="name">Malta</value>
- </row>
- <row>
- <value field="id">135</value>
- <value field="code">MH</value>
- <value field="name">Marshall Islands</value>
- </row>
- <row>
- <value field="id">136</value>
- <value field="code">MQ</value>
- <value field="name">Martinique</value>
- </row>
- <row>
- <value field="id">137</value>
- <value field="code">MR</value>
- <value field="name">Mauritania</value>
- </row>
- <row>
- <value field="id">138</value>
- <value field="code">MU</value>
- <value field="name">Mauritius</value>
- </row>
- <row>
- <value field="id">139</value>
- <value field="code">YT</value>
- <value field="name">Mayotte</value>
- </row>
- <row>
- <value field="id">140</value>
- <value field="code">MX</value>
- <value field="name">Mexico</value>
- </row>
- <row>
- <value field="id">141</value>
- <value field="code">FM</value>
- <value field="name">Micronesia, Federated States of</value>
- </row>
- <row>
- <value field="id">142</value>
- <value field="code">MD</value>
- <value field="name">Moldova, Republic of</value>
- </row>
- <row>
- <value field="id">143</value>
- <value field="code">MC</value>
- <value field="name">Monaco</value>
- </row>
- <row>
- <value field="id">144</value>
- <value field="code">MN</value>
- <value field="name">Mongolia</value>
- </row>
- <row>
- <value field="id">145</value>
- <value field="code">ME</value>
- <value field="name">Montenegro</value>
- </row>
- <row>
- <value field="id">146</value>
- <value field="code">MS</value>
- <value field="name">Montserrat</value>
- </row>
- <row>
- <value field="id">147</value>
- <value field="code">MA</value>
- <value field="name">Morocco</value>
- </row>
- <row>
- <value field="id">148</value>
- <value field="code">MZ</value>
- <value field="name">Mozambique</value>
- </row>
- <row>
- <value field="id">149</value>
- <value field="code">MM</value>
- <value field="name">Myanmar</value>
- </row>
- <row>
- <value field="id">150</value>
- <value field="code">NA</value>
- <value field="name">Namibia</value>
- </row>
- <row>
- <value field="id">151</value>
- <value field="code">NR</value>
- <value field="name">Nauru</value>
- </row>
- <row>
- <value field="id">152</value>
- <value field="code">NP</value>
- <value field="name">Nepal</value>
- </row>
- <row>
- <value field="id">153</value>
- <value field="code">NL</value>
- <value field="name">Netherlands</value>
- </row>
- <row>
- <value field="id">154</value>
- <value field="code">AN</value>
- <value field="name">Netherlands Antilles</value>
- </row>
- <row>
- <value field="id">155</value>
- <value field="code">NC</value>
- <value field="name">New Caledonia</value>
- </row>
- <row>
- <value field="id">156</value>
- <value field="code">NZ</value>
- <value field="name">New Zealand</value>
- </row>
- <row>
- <value field="id">157</value>
- <value field="code">NI</value>
- <value field="name">Nicaragua</value>
- </row>
- <row>
- <value field="id">158</value>
- <value field="code">NE</value>
- <value field="name">Niger</value>
- </row>
- <row>
- <value field="id">159</value>
- <value field="code">NG</value>
- <value field="name">Nigeria</value>
- </row>
- <row>
- <value field="id">160</value>
- <value field="code">NU</value>
- <value field="name">Niue</value>
- </row>
- <row>
- <value field="id">161</value>
- <value field="code">NF</value>
- <value field="name">Norfolk Island</value>
- </row>
- <row>
- <value field="id">162</value>
- <value field="code">MP</value>
- <value field="name">Northern Mariana Islands</value>
- </row>
- <row>
- <value field="id">163</value>
- <value field="code">NO</value>
- <value field="name">Norway</value>
- </row>
- <row>
- <value field="id">164</value>
- <value field="code">OM</value>
- <value field="name">Oman</value>
- </row>
- <row>
- <value field="id">165</value>
- <value field="code">PK</value>
- <value field="name">Pakistan</value>
- </row>
- <row>
- <value field="id">166</value>
- <value field="code">PW</value>
- <value field="name">Palau</value>
- </row>
- <row>
- <value field="id">167</value>
- <value field="code">PS</value>
- <value field="name">Palestinian Territory, Occupied</value>
- </row>
- <row>
- <value field="id">168</value>
- <value field="code">PA</value>
- <value field="name">Panama</value>
- </row>
- <row>
- <value field="id">169</value>
- <value field="code">PG</value>
- <value field="name">Papua New Guinea</value>
- </row>
- <row>
- <value field="id">170</value>
- <value field="code">PY</value>
- <value field="name">Paraguay</value>
- </row>
- <row>
- <value field="id">171</value>
- <value field="code">PE</value>
- <value field="name">Peru</value>
- </row>
- <row>
- <value field="id">172</value>
- <value field="code">PH</value>
- <value field="name">Philippines</value>
- </row>
- <row>
- <value field="id">173</value>
- <value field="code">PN</value>
- <value field="name">Pitcairn</value>
- </row>
- <row>
- <value field="id">174</value>
- <value field="code">PL</value>
- <value field="name">Poland</value>
- </row>
- <row>
- <value field="id">175</value>
- <value field="code">PT</value>
- <value field="name">Portugal</value>
- </row>
- <row>
- <value field="id">176</value>
- <value field="code">PR</value>
- <value field="name">Puerto Rico</value>
- </row>
- <row>
- <value field="id">177</value>
- <value field="code">QA</value>
- <value field="name">Qatar</value>
- </row>
- <row>
- <value field="id">178</value>
- <value field="code">RE</value>
- <value field="name">Réunion</value>
- </row>
- <row>
- <value field="id">179</value>
- <value field="code">RO</value>
- <value field="name">Romania</value>
- </row>
- <row>
- <value field="id">180</value>
- <value field="code">RU</value>
- <value field="name">Russian Federation</value>
- </row>
- <row>
- <value field="id">181</value>
- <value field="code">RW</value>
- <value field="name">Rwanda</value>
- </row>
- <row>
- <value field="id">182</value>
- <value field="code">SH</value>
- <value field="name">Saint Helena</value>
- </row>
- <row>
- <value field="id">183</value>
- <value field="code">KN</value>
- <value field="name">Saint Kitts and Nevis</value>
- </row>
- <row>
- <value field="id">184</value>
- <value field="code">LC</value>
- <value field="name">Saint Lucia</value>
- </row>
- <row>
- <value field="id">185</value>
- <value field="code">PM</value>
- <value field="name">Saint Pierre and Miquelon</value>
- </row>
- <row>
- <value field="id">186</value>
- <value field="code">VC</value>
- <value field="name">Saint Vincent and The Grenadines</value>
- </row>
- <row>
- <value field="id">187</value>
- <value field="code">WS</value>
- <value field="name">Samoa</value>
- </row>
- <row>
- <value field="id">188</value>
- <value field="code">SM</value>
- <value field="name">San Marino</value>
- </row>
- <row>
- <value field="id">189</value>
- <value field="code">ST</value>
- <value field="name">Sao Tome and Principe</value>
- </row>
- <row>
- <value field="id">190</value>
- <value field="code">SA</value>
- <value field="name">Saudi Arabia</value>
- </row>
- <row>
- <value field="id">191</value>
- <value field="code">SN</value>
- <value field="name">Senegal</value>
- </row>
- <row>
- <value field="id">192</value>
- <value field="code">RS</value>
- <value field="name">Serbia</value>
- </row>
- <row>
- <value field="id">193</value>
- <value field="code">SC</value>
- <value field="name">Seychelles</value>
- </row>
- <row>
- <value field="id">194</value>
- <value field="code">SL</value>
- <value field="name">Sierra Leone</value>
- </row>
- <row>
- <value field="id">195</value>
- <value field="code">SG</value>
- <value field="name">Singapore</value>
- </row>
- <row>
- <value field="id">196</value>
- <value field="code">SK</value>
- <value field="name">Slovakia</value>
- </row>
- <row>
- <value field="id">197</value>
- <value field="code">SI</value>
- <value field="name">Slovenia</value>
- </row>
- <row>
- <value field="id">198</value>
- <value field="code">SB</value>
- <value field="name">Solomon Islands</value>
- </row>
- <row>
- <value field="id">199</value>
- <value field="code">SO</value>
- <value field="name">Somalia</value>
- </row>
- <row>
- <value field="id">200</value>
- <value field="code">ZA</value>
- <value field="name">South Africa</value>
- </row>
- <row>
- <value field="id">201</value>
- <value field="code">GS</value>
- <value field="name">South Georgia and The South Sandwich
Islands</value>
- </row>
- <row>
- <value field="id">202</value>
- <value field="code">ES</value>
- <value field="name">Spain</value>
- </row>
- <row>
- <value field="id">203</value>
- <value field="code">LK</value>
- <value field="name">Sri Lanka</value>
- </row>
- <row>
- <value field="id">204</value>
- <value field="code">SD</value>
- <value field="name">Sudan</value>
- </row>
- <row>
- <value field="id">205</value>
- <value field="code">SR</value>
- <value field="name">Suriname</value>
- </row>
- <row>
- <value field="id">206</value>
- <value field="code">SJ</value>
- <value field="name">Svalbard and Jan Mayen</value>
- </row>
- <row>
- <value field="id">207</value>
- <value field="code">SZ</value>
- <value field="name">Swaziland</value>
- </row>
- <row>
- <value field="id">208</value>
- <value field="code">SE</value>
- <value field="name">Sweden</value>
- </row>
- <row>
- <value field="id">209</value>
- <value field="code">CH</value>
- <value field="name">Switzerland</value>
- </row>
- <row>
- <value field="id">210</value>
- <value field="code">SY</value>
- <value field="name">Syrian Arab Republic</value>
- </row>
- <row>
- <value field="id">211</value>
- <value field="code">TW</value>
- <value field="name">Taiwan, Province of China</value>
- </row>
- <row>
- <value field="id">212</value>
- <value field="code">TJ</value>
- <value field="name">Tajikistan</value>
- </row>
- <row>
- <value field="id">213</value>
- <value field="code">TZ</value>
- <value field="name">Tanzania, United Republic of</value>
- </row>
- <row>
- <value field="id">214</value>
- <value field="code">TH</value>
- <value field="name">Thailand</value>
- </row>
- <row>
- <value field="id">215</value>
- <value field="code">TL</value>
- <value field="name">Timor-Leste</value>
- </row>
- <row>
- <value field="id">216</value>
- <value field="code">TG</value>
- <value field="name">Togo</value>
- </row>
- <row>
- <value field="id">217</value>
- <value field="code">TK</value>
- <value field="name">Tokelau</value>
- </row>
- <row>
- <value field="id">218</value>
- <value field="code">TO</value>
- <value field="name">Tonga</value>
- </row>
- <row>
- <value field="id">219</value>
- <value field="code">TT</value>
- <value field="name">Trinidad and Tobago</value>
- </row>
- <row>
- <value field="id">220</value>
- <value field="code">TN</value>
- <value field="name">Tunisia</value>
- </row>
- <row>
- <value field="id">221</value>
- <value field="code">TR</value>
- <value field="name">Turkey</value>
- </row>
- <row>
- <value field="id">222</value>
- <value field="code">TM</value>
- <value field="name">Turkmenistan</value>
- </row>
- <row>
- <value field="id">223</value>
- <value field="code">TC</value>
- <value field="name">Turks and Caicos Islands</value>
- </row>
- <row>
- <value field="id">224</value>
- <value field="code">TV</value>
- <value field="name">Tuvalu</value>
- </row>
- <row>
- <value field="id">225</value>
- <value field="code">UG</value>
- <value field="name">Uganda</value>
- </row>
- <row>
- <value field="id">226</value>
- <value field="code">UA</value>
- <value field="name">Ukraine</value>
- </row>
- <row>
- <value field="id">227</value>
- <value field="code">AE</value>
- <value field="name">United Arab Emirates</value>
- </row>
- <row>
- <value field="id">228</value>
- <value field="code">GB</value>
- <value field="name">United Kingdom</value>
- </row>
- <row>
- <value field="id">229</value>
- <value field="code">US</value>
- <value field="name">United States</value>
- </row>
- <row>
- <value field="id">230</value>
- <value field="code">UM</value>
- <value field="name">United States Minor Outlying Islands</value>
- </row>
- <row>
- <value field="id">231</value>
- <value field="code">UY</value>
- <value field="name">Uruguay</value>
- </row>
- <row>
- <value field="id">232</value>
- <value field="code">UZ</value>
- <value field="name">Uzbekistan</value>
- </row>
- <row>
- <value field="id">233</value>
- <value field="code">VU</value>
- <value field="name">Vanuatu</value>
- </row>
- <row>
- <value field="id">234</value>
- <value field="code">VE</value>
- <value field="name">Venezuela</value>
- </row>
- <row>
- <value field="id">235</value>
- <value field="code">VN</value>
- <value field="name">Viet Nam</value>
- </row>
- <row>
- <value field="id">236</value>
- <value field="code">VG</value>
- <value field="name">Virgin Islands, British</value>
- </row>
- <row>
- <value field="id">237</value>
- <value field="code">VI</value>
- <value field="name">Virgin Islands, U.S.</value>
- </row>
- <row>
- <value field="id">238</value>
- <value field="code">WF</value>
- <value field="name">Wallis and Futuna</value>
- </row>
- <row>
- <value field="id">239</value>
- <value field="code">EH</value>
- <value field="name">Western Sahara</value>
- </row>
- <row>
- <value field="id">240</value>
- <value field="code">YE</value>
- <value field="name">Yemen</value>
- </row>
- <row>
- <value field="id">241</value>
- <value field="code">ZM</value>
- <value field="name">Zambia</value>
- </row>
- <row>
- <value field="id">242</value>
- <value field="code">ZW</value>
- <value field="name">Zimbabwe</value>
- </row>
- </rows>
- </tabledata>
- </data>
-
-</schema>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [gnue] r9204 - in trunk/gnue-samples/two-tier: forms schema,
johannes <=