[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue geas/tools/mac/gcdVerifier.pbproj/ntiffin....
|
From: |
Neil Tiffin |
|
Subject: |
gnue geas/tools/mac/gcdVerifier.pbproj/ntiffin.... |
|
Date: |
Thu, 05 Jul 2001 19:36:42 -0700 |
CVSROOT: /home/cvs
Module name: gnue
Changes by: Neil Tiffin <address@hidden> 01/07/05 19:36:42
Modified files:
geas/tools/mac/gcdVerifier.pbproj: ntiffin.pbxuser
gnue-config/base/location/classes: address.gcd
gnue-config/base/location/defaults: insert-en-country-codes.sql
insert-en-us-states.sql
gnue-config/base/location/doc: location.sgml
gnue-config/base/package-doc: chapters.ent
Log message:
Update SQL default data.
CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/geas/tools/mac/gcdVerifier.pbproj/ntiffin.pbxuser.diff?cvsroot=OldCVS&tr1=1.4&tr2=1.5&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/location/classes/address.gcd.diff?cvsroot=OldCVS&tr1=1.11&tr2=1.12&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/location/defaults/insert-en-country-codes.sql.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/location/defaults/insert-en-us-states.sql.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/location/doc/location.sgml.diff?cvsroot=OldCVS&tr1=1.5&tr2=1.6&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/package-doc/chapters.ent.diff?cvsroot=OldCVS&tr1=1.8&tr2=1.9&r1=text&r2=text
Patches:
Index: gnue/geas/tools/mac/gcdVerifier.pbproj/ntiffin.pbxuser
diff -u gnue/geas/tools/mac/gcdVerifier.pbproj/ntiffin.pbxuser:1.4
gnue/geas/tools/mac/gcdVerifier.pbproj/ntiffin.pbxuser:1.5
--- gnue/geas/tools/mac/gcdVerifier.pbproj/ntiffin.pbxuser:1.4 Thu Jul 5
12:06:11 2001
+++ gnue/geas/tools/mac/gcdVerifier.pbproj/ntiffin.pbxuser Thu Jul 5
19:36:41 2001
@@ -70,26 +70,26 @@
PBXWorkspaceConfiguration = {
ContentSize = "{974, 669}";
LeftSlideOut = {
- ActiveTab = 2;
+ ActiveTab = 0;
Frame = "{{0, 23}, {974, 646}}";
Split0 = {
ActiveTab = 2;
- Frame = "{{225, 0}, {749,
646}}";
+ Frame = "{{262, 0}, {712,
646}}";
Split0 = {
- Frame = "{{0, 287},
{749, 359}}";
+ Frame = "{{0, 287},
{712, 359}}";
};
SplitCount = 1;
Tab0 = {
Debugger = {
ActiveTab = 1;
- Frame = "{{0,
0}, {749, 464}}";
+ Frame = "{{0,
0}, {712, 464}}";
Split0 = {
- Frame =
"{{0, 437}, {749, 27}}";
+ Frame =
"{{0, 437}, {712, 27}}";
Split0
= {
-
Frame = "{{0, 0}, {220, 27}}";
+
Frame = "{{0, 0}, {209, 27}}";
};
Split1
= {
-
Frame = "{{229, 0}, {520, 27}}";
+
Frame = "{{218, 0}, {494, 27}}";
};
SplitCount = 2;
};
@@ -98,11 +98,11 @@
Frame =
"{{0, 0}, {100, 50}}";
};
Tab1 = {
- Frame =
"{{0, 0}, {749, 412}}";
+ Frame =
"{{0, 0}, {712, 412}}";
};
TabCount = 2;
};
- Frame = "{{0, 0}, {749,
464}}";
+ Frame = "{{0, 0}, {712,
464}}";
LauncherConfigVersion =
4;
};
Tab1 = {
@@ -113,9 +113,9 @@
};
};
Tab2 = {
- BuildMessageFrame =
"{{0, 0}, {751, 114}}";
- BuildTranscriptFrame =
"{{0, 123}, {751, 141}}";
- Frame = "{{0, 0}, {749,
262}}";
+ BuildMessageFrame =
"{{0, 0}, {714, 114}}";
+ BuildTranscriptFrame =
"{{0, 123}, {714, 141}}";
+ Frame = "{{0, 0}, {712,
262}}";
};
Tab3 = {
Frame = "{{0, 0}, {712,
507}}";
Index: gnue/gnue-config/base/location/classes/address.gcd
diff -u gnue/gnue-config/base/location/classes/address.gcd:1.11
gnue/gnue-config/base/location/classes/address.gcd:1.12
--- gnue/gnue-config/base/location/classes/address.gcd:1.11 Mon Jun 4
06:56:25 2001
+++ gnue/gnue-config/base/location/classes/address.gcd Thu Jul 5 19:36:42 2001
@@ -22,13 +22,14 @@
#
# This file originally written by Neil Tiffin (address@hidden).
#
-# $Revision: 1.11 $ $Date: 2001/06/04 13:56:25 $ $Author: ntiffin $
+# $Revision: 1.12 $ $Date: 2001/07/06 02:36:42 $ $Author: ntiffin $
#
module location
{
class region
{
+ char country<8>;
char code<8>; # state/region abbrev
char desc<35>; # long state/region name
};
Index: gnue/gnue-config/base/location/defaults/insert-en-country-codes.sql
diff -u gnue/gnue-config/base/location/defaults/insert-en-country-codes.sql:1.1
gnue/gnue-config/base/location/defaults/insert-en-country-codes.sql:1.2
--- gnue/gnue-config/base/location/defaults/insert-en-country-codes.sql:1.1
Sat Mar 3 16:42:13 2001
+++ gnue/gnue-config/base/location/defaults/insert-en-country-codes.sql Thu Jul
5 19:36:42 2001
@@ -1,255 +1,302 @@
-INSERT INTO ValidCountryCodes (country_description, country_phone_code,
country_code) VALUES
- ("Afghanistan", "", "AF"),
- ("Albania", "355", "AL"),
- ("Algeria", "213", "AG"),
- ("American Samoa", "684", ""),
- ("Andorra", "376", "AN"),
- ("Angola", "244", "AO"),
- ("Anguilla", "1", "AV"),
- ("Antarctica", "672", "AY"),
- ("Antigua and Barbuda", "1", "AC"),
- ("Argentina", "54", "AR"),
- ("Armenia", "374", "AM"),
- ("Aruba", "297", "AA"),
- ("Ashmore and Cartier Islands", "", "AT"),
- ("Ascension Island", "247", ""),
- ("Australia", "61", "AS"),
- ("Austria", "43", "AU"),
- ("Azerbaijan", "994", "AJ"),
- ("Bahamas", "1", "BF"),
- ("Bahrain", "973", "BA"),
- ("Bangladesh", "880", "BG"),
- ("Barbados", "1", "BB"),
- ("Belarus", "375", "BO"),
- ("Belgium", "32", "BE"),
- ("Belize", "501", "BH"),
- ("Benin", "229", "BN"),
- ("Bermuda", "441", "BD"),
- ("Bhutan", "975", "BT"),
- ("Bolivia", "591", "BL"),
- ("Bosnia and Herzegovina", "387", "BK"),
- ("Botswana", "267", "BC"),
- ("Brazil", "55", "BR"),
- ("British Indian Ocean Territory", "", "IO"),
- ("British Virgin Islands", "1", "VI"),
- ("Brunei", "673", "BX"),
- ("Bulgaria", "359", "BU"),
- ("Burkina Faso", "226", "UV"),
- ("Burundi", "257", "BY"),
- ("Cambodia", "855", "CB"),
- ("Cameroon", "237", "CM"),
- ("Canada", "1", "CA"),
- ("Cape Verde Islands", "238", "CV"),
- ("Cayman Islands", "1", "CJ"),
- ("Central African Republic", "236", "CT"),
- ("Chad Republic", "235", "CD"),
- ("Chatham Island", "64", ""),
- ("Chile", "56", "CI"),
- ("China", "86", "CH"),
- ("Christmas Island", "672", "KT"),
- ("Cocos (Keeling) Islands", "672", "CK"),
- ("Colombia", "57", "CO"),
- ("Comoros", "269", "CN"),
- ("Congo", "242", "CF"),
- ("Cook Islands", "682", "CW"),
- ("Coral Sea Islands", "", "CR"),
- ("Costa Rica", "506", "CS"),
- ("Cote D'Ivoire", "", "IV"),
- ("Croatia", "385", "HR"),
- ("Cuba", "53", "CU"),
- ("Cyprus", "357", "CY"),
- ("Czech Republic", "42", "EZ"),
- ("Denmark", "45", "DA"),
- ("Diego Garcia", "246", ""),
- ("Djibouti", "253", "DJ"),
- ("Dominica", "1", "DO"),
- ("Dominican Republic", "1", "DR"),
- ("Ecuador", "593", "EC"),
- ("Egypt", "20", "EG"),
- ("El Salvador", "503", "ES"),
- ("Equatorial Guinea", "240", "EK"),
- ("Eritrea", "291", "ER"),
- ("Estonia", "372", "EN"),
- ("Ethiopia", "251", "ET"),
- ("Europa Island", "", "EU"),
- ("Faeroe Islands", "298", "FO"),
- ("Falkland Islands", "500", "FK"),
- ("Fiji", "679", "FJ"),
- ("Finland", "358", "FI"),
- ("France", "33", "FR"),
- ("French Antilles", "596", ""),
- ("French Southern and Antarctic Lands", "", "FS"),
- ("French Guiana", "594", "FG"),
- ("French Polynesia", "689", "FP"),
- ("Gabon", "241", "GB"),
- ("Gaza Strip", "", "GZ"),
- ("Gambia", "220", "GA"),
- ("Georgia", "995", "GG"),
- ("Germany", "49", "GM"),
- ("Ghana", "233", "GH"),
- ("Gibraltar", "350", "GI"),
- ("Glorioso Islands", "", "GO"),
- ("Greece", "30", "GR"),
- ("Greenland", "299", "GL"),
- ("Grenada", "1", "GJ"),
- ("Guadeloupe", "590", "GP"),
- ("Guam", "671", ""),
- ("Guatemala", "502", "GT"),
- ("Guinea", "224", "GV"),
- ("Guinea-Bissau", "245", "PU"),
- ("Guyana", "592", "GY"),
- ("Haiti", "509", "HA"),
- ("Heard Island and Mcdonald Islands", "", "HM"),
- ("Honduras", "504", "HO"),
- ("Hong Kong", "852", "HK"),
- ("Hungary", "36", "HU"),
- ("Iceland", "354", "IC"),
- ("India", "91", "IN"),
- ("Indonesia", "62", "ID"),
- ("Iran", "98", "IR"),
- ("Iraq", "964", "IZ"),
- ("Ireland", "353", "EI"),
- ("Isle of Man", "", "IM"),
- ("Israel", "972", "IS"),
- ("Italy", "39", "IT"),
- ("Ivory Coast", "225", ""),
- ("Jamaica", "1", "JM"),
- ("Jan Mayen", "", "JN"),
- ("Japan", "81", "JA"),
- ("Jersey", "", "JE"),
- ("Jordan", "962", "JO"),
- ("Juan de Nova Island", "", "JU"),
- ("Kazakhstan", "7", "KZ"),
- ("Kenya", "254", "KE"),
- ("Kingman Reef", "", "KQ"),
- ("Kiribati", "686", ""),
- ("Korea, Democratic People's Republic of", "850", "KN"),
- ("Korea, Republic of", "82", "KS"),
- ("Kuwait", "965", "KU"),
- ("Kyrgyzstan", "7", "KG"),
- ("Laos", "856", "LA"),
- ("Latvia", "371", "LG"),
- ("Lebanon", "961", "LE"),
- ("Lesotho", "266", "LT"),
- ("Liberia", "231", "LI"),
- ("Libya", "218", "LY"),
- ("Liechtenstein", "4175", "LS"),
- ("Lithuania", "370", "LH"),
- ("Luxembourg", "352", "LU"),
- ("Macao", "853", "MC"),
- ("Macedonia", "389", "MK"),
- ("Madagascar", "261", "MA"),
- ("Malawi", "265", "MI"),
- ("Malaysia", "60", "MY"),
- ("Maldives", "960", "MV"),
- ("Mali", "223", "ML"),
- ("Malta", "356", "MT"),
- ("Marshall Islands", "692", ""),
- ("Martinique", "596", "MB"),
- ("Mauritania", "222", "MR"),
- ("Mauritius", "230", "MP"),
- ("Mayotte Islands", "2696", "MF"),
- ("Mexico", "52", "MX"),
- ("Micronesia", "691", ""),
- ("Moldova", "373", "MD"),
- ("Monaco", "377", "MN"),
- ("Mongolia", "976", "MG"),
- ("Montenegro", "", "MW"),
- ("Montserrat", "1", "MH"),
- ("Morocco", "212", "MO"),
- ("Mozambique", "258", "MZ"),
- ("Myanmar", "95", ""),
- ("Namibia", "264", "WA"),
- ("Nauru", "674", "NR"),
- ("Nepal", "977", "NP"),
- ("Netherlands", "31", "NL"),
- ("Netherlands Antilles", "599", "NT"),
- ("New Caledonia", "687", "NC"),
- ("New Zealand", "64", "NZ"),
- ("Nicaragua", "505", "NU"),
- ("Niger", "227", "NG"),
- ("Nigeria", "234", "NI"),
- ("Niue", "683", "NE"),
- ("Norfolk Island", "672", "NF"),
- ("Norway", "47", "NO"),
- ("Oman", "968", "MU"),
- ("Pakistan", "92", "PK"),
- ("Palau", "680", ""),
- ("Panama", "507", "PM"),
- ("Papua New Guinea", "675", "PP"),
- ("Paracel Islands", "", "PF"),
- ("Paraguay", "595", "PA"),
- ("Peru", "51", "PE"),
- ("Philippines", "63", "RP"),
- ("Pitcairn Islands", "", "PC"),
- ("Poland", "48", "PL"),
- ("Portugal", "351", "PO"),
- ("Qatar", "974", "QA"),
- ("Reunion", "262", "RE"),
- ("Romania", "40", "RO"),
- ("Russia", "7", "RS"),
- ("Rwanda", "250", "RW"),
- ("Saipan", "670", ""),
- ("San Marino", "378", "SM"),
- ("Sao Tome and Principe", "239", "TP"),
- ("Saudi Arabia", "966", "SA"),
- ("Senegal", "221", "SG"),
- ("Seychelles", "248", "SE"),
- ("Sierra Leone", "232", "SL"),
- ("Singapore", "65", "SN"),
- ("Slovak Republic", "42", "LO"),
- ("Slovenia", "386", "SI"),
- ("Solomon Islands", "677", "BP"),
- ("Somalia", "252", "SO"),
- ("South Africa", "27", "SF"),
- ("South Georgia and South Sandwich Islands", "", "SX"),
- ("Spain", "34", "SP"),
- ("Spratly Islands", "", "PG"),
- ("Sri Lanka", "94", "CE"),
- ("St. Helena", "290", "SH"),
- ("St. Kitts and Nevis", "1", "SC"),
- ("St. Lucia", "1", "ST"),
- ("St. Pierre and Miquelon", "508", "SB"),
- ("St. Vincent and the Grenadines", "1", "VC"),
- ("Sudan", "", "SU"),
- ("Svalbard", "", "SV"),
- ("Suriname", "597", "NS"),
- ("Swaziland", "268", "WZ"),
- ("Sweden", "46", "SW"),
- ("Switzerland", "41", "SZ"),
- ("Syria", "963", "SY"),
- ("Taiwan", "886", "TW"),
- ("Tajikistan", "7", "TI"),
- ("Tanzania", "255", "TZ"),
- ("Thailand", "66", "TH"),
- ("Togo", "228", "TO"),
- ("Tokelau", "", "TL"),
- ("Tonga Islands", "676", ""),
- ("Trinidad and Tobago", "1", "TD"),
- ("Tromelin Island", "", "TD"),
- ("Tunisia", "216", "TS"),
- ("Turkey", "90", "TU"),
- ("Turkmenistan", "7", "TX"),
- ("Turks and Caicos Islands", "1", "TK"),
- ("Tuvalu", "688", "TV"),
- ("Uganda", "256", "UG"),
- ("Ukraine", "380", "UP"),
- ("United Arab Emirates", "971", "TC"),
- ("United Kingdom", "44", "UK"),
- ("United States", "1", "US"),
- ("Uruguay", "598", "UY"),
- ("Uzbekistan", "7", "UZ"),
- ("Vanuatu", "678", "NH"),
- ("Vatican City", "", "VT"),
- ("Venezuela", "58", "VE"),
- ("Vietnam", "84", "VM"),
- ("Wallis and Futuna", "681", "WF"),
- ("West Bank", "", "WE"),
- ("Western Sahara", "", "WI"),
- ("Western Samoa", "685", "WS"),
- ("Yemen", "967", ""),
- ("Yugoslavia", "967", ""),
- ("Zaire", "243", "CG"),
- ("Zambia", "260", "ZA"),
- ("Zimbabwe", "263", "ZI")
-;
\ No newline at end of file
+
+#
+# ISO country and telephone codes
+#
+# $Id: insert-en-country-codes.sql,v 1.2 2001/07/06 02:36:42 ntiffin Exp $
+#
+
+INSERT INTO location__country (description, phone_code, code) VALUES
+ ("Afghanistan", "", "AF"),
+ ("Albania", "355", "AL"),
+ ("Algeria", "213", "AG"),
+ ("American Samoa", "684", ""),
+ ("Andorra", "376", "AN"),
+ ("Angola", "244", "AO"),
+ ("Anguilla", "1", "AV"),
+ ("Antarctica", "672", "AY"),
+ ("Antigua Barbuda", "1", "AC"),
+ ("Argentina", "54", "AR"),
+ ("Armenia", "374", "AM"),
+ ("Aruba", "297", "AA"),
+ ("Ashmore and Cartier Islands",
+ "", "AT"),
+ ("Ascension Island",
+ "247", ""),
+ ("Australia", "61", "AS"),
+ ("Austria", "43", "AU"),
+ ("Azerbaijan", "994", "AJ"),
+ ("Bahamas", "1", "BF"),
+ ("Bahrain", "973", "BA"),
+ ("Bangladesh", "880", "BG"),
+ ("Barbados", "1", "BB"),
+ ("Belarus", "375", "BO"),
+ ("Belgium", "32", "BE"),
+ ("Belize", "501", "BH"),
+ ("Benin", "229", "BN"),
+ ("Bermuda", "441", "BD"),
+ ("Bhutan", "975", "BT"),
+ ("Bolivia", "591", "BL"),
+ ("Bosnia Herzegovina",
+ "387", "BK"),
+ ("Botswana", "267", "BC"),
+ ("Brazil", "55", "BR"),
+ ("British Indian Ocean Territory",
+ "", "IO"),
+ ("British Virgin Islands",
+ "1", "VI"),
+ ("Brunei", "673", "BX"),
+ ("Bulgaria", "359", "BU"),
+ ("Burkina Faso", "226", "UV"),
+ ("Burundi", "257", "BY"),
+ ("Cambodia", "855", "CB"),
+ ("Cameroon", "237", "CM"),
+ ("Canada", "1", "CA"),
+ ("Cape Verde Islands",
+ "238", "CV"),
+ ("Cayman Islands", "1", "CJ"),
+ ("Central African Republic",
+ "236", "CT"),
+ ("Chad Republic", "235", "CD"),
+ ("Chatham Island", "64", ""),
+ ("Chile", "56", "CI"),
+ ("China", "86", "CH"),
+ ("Christmas Island",
+ "672", "KT"),
+ ("Cocos (Keeling) Islands",
+ "672", "CK"),
+ ("Colombia", "57", "CO"),
+ ("Comoros", "269", "CN"),
+ ("Congo", "242", "CF"),
+ ("Cook Islands", "682", "CW"),
+ ("Coral Sea Islands",
+ "", "CR"),
+ ("Costa Rica", "506", "CS"),
+ ("Cote D'Ivoire", "", "IV"),
+ ("Croatia", "385", "HR"),
+ ("Cuba", "53", "CU"),
+ ("Cyprus", "357", "CY"),
+ ("Czech Republic", "42", "EZ"),
+ ("Denmark", "45", "DA"),
+ ("Diego Garcia", "246", ""),
+ ("Djibouti", "253", "DJ"),
+ ("Dominica", "1", "DO"),
+ ("Dominican Republic",
+ "1", "DR"),
+ ("Ecuador", "593", "EC"),
+ ("Egypt", "20", "EG"),
+ ("El Salvador", "503", "ES"),
+ ("Equatorial Guinea",
+ "240", "EK"),
+ ("Eritrea", "291", "ER"),
+ ("Estonia", "372", "EN"),
+ ("Ethiopia", "251", "ET"),
+ ("Europa Island", "", "EU"),
+ ("Faeroe Islands", "298", "FO"),
+ ("Falkland Islands",
+ "500", "FK"),
+ ("Fiji", "679", "FJ"),
+ ("Finland", "358", "FI"),
+ ("France", "33", "FR"),
+ ("French Antilles",
+ "596", ""),
+ ("French Southern and Antarctic Lands",
+ "", "FS"),
+ ("French Guiana", "594", "FG"),
+ ("French Polynesia",
+ "689", "FP"),
+ ("Gabon", "241", "GB"),
+ ("Gaza Strip", "", "GZ"),
+ ("Gambia", "220", "GA"),
+ ("Georgia", "995", "GG"),
+ ("Germany", "49", "GM"),
+ ("Ghana", "233", "GH"),
+ ("Gibraltar", "350", "GI"),
+ ("Glorioso Islands",
+ "", "GO"),
+ ("Greece", "30", "GR"),
+ ("Greenland", "299", "GL"),
+ ("Grenada", "1", "GJ"),
+ ("Guadeloupe", "590", "GP"),
+ ("Guam", "671", ""),
+ ("Guatemala", "502", "GT"),
+ ("Guinea", "224", "GV"),
+ ("Guinea-Bissau", "245", "PU"),
+ ("Guyana", "592", "GY"),
+ ("Haiti", "509", "HA"),
+ ("Heard and McDonald Islands",
+ "", "HM"),
+ ("Honduras", "504", "HO"),
+ ("Hong Kong", "852", "HK"),
+ ("Hungary", "36", "HU"),
+ ("Iceland", "354", "IC"),
+ ("India", "91", "IN"),
+ ("Indonesia", "62", "ID"),
+ ("Iran", "98", "IR"),
+ ("Iraq", "964", "IZ"),
+ ("Ireland", "353", "EI"),
+ ("Isle of Man", "", "IM"),
+ ("Israel", "972", "IS"),
+ ("Italy", "39", "IT"),
+ ("Ivory Coast", "225", ""),
+ ("Jamaica", "1", "JM"),
+ ("Jan Mayen", "", "JN"),
+ ("Japan", "81", "JA"),
+ ("Jersey", "", "JE"),
+ ("Jordan", "962", "JO"),
+ ("Juan de Nova Island",
+ "", "JU"),
+ ("Kazakhstan", "7", "KZ"),
+ ("Kenya", "254", "KE"),
+ ("Kingman Reef", "", "KQ"),
+ ("Kiribati", "686", ""),
+ ("Korea, Democratic People's Republic of",
+ "850", "KN"),
+ ("Korea, Republic of",
+ "82", "KS"),
+ ("Kuwait", "965", "KU"),
+ ("Kyrgyzstan", "7", "KG"),
+ ("Laos", "856", "LA"),
+ ("Latvia", "371", "LG"),
+ ("Lebanon", "961", "LE"),
+ ("Lesotho", "266", "LT"),
+ ("Liberia", "231", "LI"),
+ ("Libya", "218", "LY"),
+ ("Liechtenstein", "4175", "LS"),
+ ("Lithuania", "370", "LH"),
+ ("Luxembourg", "352", "LU"),
+ ("Macao", "853", "MC"),
+ ("Macedonia", "389", "MK"),
+ ("Madagascar", "261", "MA"),
+ ("Malawi", "265", "MI"),
+ ("Malaysia", "60", "MY"),
+ ("Maldives", "960", "MV"),
+ ("Mali", "223", "ML"),
+ ("Malta", "356", "MT"),
+ ("Marshall Islands",
+ "692", ""),
+ ("Martinique", "596", "MB"),
+ ("Mauritania", "222", "MR"),
+ ("Mauritius", "230", "MP"),
+ ("Mayotte Islands",
+ "2696", "MF"),
+ ("Mexico", "52", "MX"),
+ ("Micronesia", "691", ""),
+ ("Moldova", "373", "MD"),
+ ("Monaco", "377", "MN"),
+ ("Mongolia", "976", "MG"),
+ ("Montenegro", "", "MW"),
+ ("Montserrat", "1", "MH"),
+ ("Morocco", "212", "MO"),
+ ("Mozambique", "258", "MZ"),
+ ("Myanmar", "95", ""),
+ ("Namibia", "264", "WA"),
+ ("Nauru", "674", "NR"),
+ ("Nepal", "977", "NP"),
+ ("Netherlands", "31", "NL"),
+ ("Netherlands Antilles",
+ "599", "NT"),
+ ("New Caledonia", "687", "NC"),
+ ("New Zealand", "64", "NZ"),
+ ("Nicaragua", "505", "NU"),
+ ("Niger", "227", "NG"),
+ ("Nigeria", "234", "NI"),
+ ("Niue", "683", "NE"),
+ ("Norfolk Island", "672", "NF"),
+ ("Norway", "47", "NO"),
+ ("Oman", "968", "MU"),
+ ("Pakistan", "92", "PK"),
+ ("Palau", "680", ""),
+ ("Panama", "507", "PM"),
+ ("Papua New Guinea",
+ "675", "PP"),
+ ("Paracel Islands",
+ "", "PF"),
+ ("Paraguay", "595", "PA"),
+ ("Peru", "51", "PE"),
+ ("Philippines", "63", "RP"),
+ ("Pitcairn Islands",
+ "", "PC"),
+ ("Poland", "48", "PL"),
+ ("Portugal", "351", "PO"),
+ ("Qatar", "974", "QA"),
+ ("Reunion", "262", "RE"),
+ ("Romania", "40", "RO"),
+ ("Russia", "7", "RS"),
+ ("Rwanda", "250", "RW"),
+ ("Saipan", "670", ""),
+ ("San Marino", "378", "SM"),
+ ("Sao Tome and Principe",
+ "239", "TP"),
+ ("Saudi Arabia", "966", "SA"),
+ ("Senegal", "221", "SG"),
+ ("Seychelles", "248", "SE"),
+ ("Sierra Leone", "232", "SL"),
+ ("Singapore", "65", "SN"),
+ ("Slovak Republic",
+ "42", "LO"),
+ ("Slovenia", "386", "SI"),
+ ("Solomon Islands",
+ "677", "BP"),
+ ("Somalia", "252", "SO"),
+ ("South Africa", "27", "SF"),
+ ("South Georgia and South Sandwich Islands",
+ "", "SX"),
+ ("Spain", "34", "SP"),
+ ("Spratly Islands",
+ "", "PG"),
+ ("Sri Lanka", "94", "CE"),
+ ("St. Helena", "290", "SH"),
+ ("St. Kitts and Nevis",
+ "1", "SC"),
+ ("St. Lucia", "1", "ST"),
+ ("St. Pierre and Miquelon",
+ "508", "SB"),
+ ("St. Vincent and the Grenadines",
+ "1", "VC"),
+ ("Sudan", "", "SU"),
+ ("Svalbard", "", "SV"),
+ ("Suriname", "597", "NS"),
+ ("Swaziland", "268", "WZ"),
+ ("Sweden", "46", "SW"),
+ ("Switzerland", "41", "SZ"),
+ ("Syria", "963", "SY"),
+ ("Taiwan", "886", "TW"),
+ ("Tajikistan", "7", "TI"),
+ ("Tanzania", "255", "TZ"),
+ ("Thailand", "66", "TH"),
+ ("Togo", "228", "TO"),
+ ("Tokelau", "", "TL"),
+ ("Tonga Islands", "676", ""),
+ ("Trinidad and Tobago",
+ "1", "TD"),
+ ("Tromelin Island",
+ "", "TD"),
+ ("Tunisia", "216", "TS"),
+ ("Turkey", "90", "TU"),
+ ("Turkmenistan", "7", "TX"),
+ ("Turks and Caicos Islands",
+ "1", "TK"),
+ ("Tuvalu", "688", "TV"),
+ ("Uganda", "256", "UG"),
+ ("Ukraine", "380", "UP"),
+ ("United Arab Emirates",
+ "971", "TC"),
+ ("United Kingdom", "44", "UK"),
+ ("United States", "1", "US"),
+ ("Uruguay", "598", "UY"),
+ ("Uzbekistan", "7", "UZ"),
+ ("Vanuatu", "678", "NH"),
+ ("Vatican City", "", "VT"),
+ ("Venezuela", "58", "VE"),
+ ("Vietnam", "84", "VM"),
+ ("Wallis and Futuna",
+ "681", "WF"),
+ ("West Bank", "", "WE"),
+ ("Western Sahara", "", "WI"),
+ ("Western Samoa", "685", "WS"),
+ ("Yemen", "967", ""),
+ ("Yugoslavia", "967", ""),
+ ("Zaire", "243", "CG"),
+ ("Zambia", "260", "ZA"),
+ ("Zimbabwe", "263", "ZI")
+;
Index: gnue/gnue-config/base/location/defaults/insert-en-us-states.sql
diff -u gnue/gnue-config/base/location/defaults/insert-en-us-states.sql:1.1
gnue/gnue-config/base/location/defaults/insert-en-us-states.sql:1.2
--- gnue/gnue-config/base/location/defaults/insert-en-us-states.sql:1.1 Sat Mar
3 16:42:13 2001
+++ gnue/gnue-config/base/location/defaults/insert-en-us-states.sql Thu Jul
5 19:36:42 2001
@@ -1,77 +1,84 @@
-INSERT into ValidStateCodes (state_description, state_code) VALUES
- ("Alabama", "AL"),
- ("Alaska", "AK"),
- ("American Samoa", "AS"),
- ("Arizona", "AZ"),
- ("Arkansas", "AR"),
- ("California", "CA"),
- ("Colorado", "CO"),
- ("Connecticut", "CT"),
- ("Delaware", "DE"),
- ("District of Columbia", "DC"),
- ("Federated States of Micronesia", "FM"),
- ("Florida", "FL"),
- ("Georgia", "GA"),
- ("Guam", "GU"),
- ("Hawaii", "HI"),
- ("Idaho", "ID"),
- ("Illinois", "IL"),
- ("Indiana", "IN"),
- ("Iowa", "IA"),
- ("Kansas", "KS"),
- ("Kentucky", "KY"),
- ("Louisiana", "LA"),
- ("Maine", "ME"),
- ("Marshall Islands", "MH"),
- ("Maryland", "MD"),
- ("Massachusetts", "MA"),
- ("Michigan", "MI"),
- ("Minnesota", "MN"),
- ("Mississippi", "MS"),
- ("Missouri", "MO"),
- ("Montana", "MT"),
- ("Nebraska", "NE"),
- ("Nevada", "NV"),
- ("New Hampshire", "NH"),
- ("New Jersey", "NJ"),
- ("New Mexico", "NM"),
- ("New York", "NY"),
- ("North Carolina", "NC"),
- ("North Dakota", "ND"),
- ("Northern Mariana Islands", "MP"),
- ("Ohio", "OH"),
- ("Oklahoma", "OK"),
- ("Oregon", "OR"),
- ("Palau", "PW"),
- ("Pennsylvania", "PA"),
- ("Puerto Rico", "PR"),
- ("Rhode Island", "RI"),
- ("South Carolina", "SC"),
- ("South Dakota", "SD"),
- ("Tennessee", "TN"),
- ("Texas", "TX"),
- ("US Minor Outlying Islands", "UM"),
- ("US Virgin Islands", "VI"),
- ("Utah", "UT"),
- ("Vermont", "VT"),
- ("Virginia", "VA"),
- ("Washington", "WA"),
- ("West Virginia", "WV"),
- ("Wisconsin", "WI"),
- ("Wyoming", "WY"),
- ("Alberta", "AB"),
- ("British Columbia", "BC"),
- ("Manitoba", "MB"),
- ("New Brunswick", "NB"),
- ("Newfoundland", "NF"),
- ("Northwest Territories", "NT"),
- ("Nova Scotia", "NS"),
- ("Ontario", "ON"),
- ("Prince Edward Island", "PE"),
- ("Quebec", "PQ"),
- ("Saskatchewan", "SK"),
- ("Yukon Territory", "YT"),
- ("Armed Forces Europe, the Middle East and Canada", "AE"),
- ("Armed Forces Pacific", "AP"),
- ("Armed Forces", "AA")
+
+#
+# United States and Canada region (state) codes
+#
+# $Id: insert-en-us-states.sql,v 1.2 2001/07/06 02:36:42 ntiffin Exp $
+#
+
+INSERT into region (desc, code, country) VALUES
+ ("Alabama", "AL", "US"),
+ ("Alaska", "AK", "US"),
+ ("American Samoa", "AS", "US"),
+ ("Arizona", "AZ", "US"),
+ ("Arkansas", "AR", "US"),
+ ("California", "CA", "US"),
+ ("Colorado", "CO", "US"),
+ ("Connecticut", "CT", "US"),
+ ("Delaware", "DE", "US"),
+ ("District of Columbia", "DC", "US"),
+ ("Federated States of Micronesia", "FM", "US"),
+ ("Florida", "FL", "US"),
+ ("Georgia", "GA", "US"),
+ ("Guam", "GU", "US"),
+ ("Hawaii", "HI", "US"),
+ ("Idaho", "ID", "US"),
+ ("Illinois", "IL", "US"),
+ ("Indiana", "IN", "US"),
+ ("Iowa", "IA", "US"),
+ ("Kansas", "KS", "US"),
+ ("Kentucky", "KY", "US"),
+ ("Louisiana", "LA", "US"),
+ ("Maine", "ME", "US"),
+ ("Marshall Islands", "MH", "US"),
+ ("Maryland", "MD", "US"),
+ ("Massachusetts", "MA", "US"),
+ ("Michigan", "MI", "US"),
+ ("Minnesota", "MN", "US"),
+ ("Mississippi", "MS", "US"),
+ ("Missouri", "MO", "US"),
+ ("Montana", "MT", "US"),
+ ("Nebraska", "NE", "US"),
+ ("Nevada", "NV", "US"),
+ ("New Hampshire", "NH", "US"),
+ ("New Jersey", "NJ", "US"),
+ ("New Mexico", "NM", "US"),
+ ("New York", "NY", "US"),
+ ("North Carolina", "NC", "US"),
+ ("North Dakota", "ND", "US"),
+ ("Northern Mariana Islands", "MP", "US"),
+ ("Ohio", "OH", "US"),
+ ("Oklahoma", "OK", "US"),
+ ("Oregon", "OR", "US"),
+ ("Palau", "PW", "US"),
+ ("Pennsylvania", "PA", "US"),
+ ("Puerto Rico", "PR", "US"),
+ ("Rhode Island", "RI", "US"),
+ ("South Carolina", "SC", "US"),
+ ("South Dakota", "SD", "US"),
+ ("Tennessee", "TN", "US"),
+ ("Texas", "TX", "US"),
+ ("US Minor Outlying Islands", "UM", "US"),
+ ("US Virgin Islands", "VI", "US"),
+ ("Utah", "UT", "US"),
+ ("Vermont", "VT", "US"),
+ ("Virginia", "VA", "US"),
+ ("Washington", "WA", "US"),
+ ("West Virginia", "WV", "US"),
+ ("Wisconsin", "WI", "US"),
+ ("Wyoming", "WY", "US"),
+ ("Alberta", "AB", "CA"),
+ ("British Columbia", "BC", "CA"),
+ ("Manitoba", "MB", "CA"),
+ ("New Brunswick", "NB", "CA"),
+ ("Newfoundland", "NF", "CA"),
+ ("Northwest Territories", "NT", "CA"),
+ ("Nova Scotia", "NS", "CA"),
+ ("Ontario", "ON", "CA"),
+ ("Prince Edward Island", "PE", "CA"),
+ ("Quebec", "PQ", "CA"),
+ ("Saskatchewan", "SK", "CA"),
+ ("Yukon Territory", "YT", "CA"),
+ ("Armed Forces Europe, the Middle East and Canada", "AE", "US"),
+ ("Armed Forces Pacific", "AP", "US"),
+ ("Armed Forces", "AA", "US")
;
Index: gnue/gnue-config/base/location/doc/location.sgml
diff -u gnue/gnue-config/base/location/doc/location.sgml:1.5
gnue/gnue-config/base/location/doc/location.sgml:1.6
--- gnue/gnue-config/base/location/doc/location.sgml:1.5 Wed Jul 4
11:04:13 2001
+++ gnue/gnue-config/base/location/doc/location.sgml Thu Jul 5 19:36:42 2001
@@ -3,7 +3,7 @@
<sect1>
<title>Requirements</title>
<para>
- This chapter is $Revision: 1.5 $ $Date: 2001/07/04
18:04:13 $.
+ This chapter is $Revision: 1.6 $ $Date: 2001/07/06
02:36:42 $.
</para>
<sect2>
<title> Business Requirements </title>
@@ -101,6 +101,19 @@
<para>
<programlisting>
&addresscode;
+ </programlisting>
+ </para>
+ </sect2>
+ <sect2>
+ <title>Default Data Definition</title>
+ <para>
+ <programlisting>
+ &countrydata;
+ </programlisting>
+ </para>
+ <para>
+ <programlisting>
+ &statedata;
</programlisting>
</para>
</sect2>
Index: gnue/gnue-config/base/package-doc/chapters.ent
diff -u gnue/gnue-config/base/package-doc/chapters.ent:1.8
gnue/gnue-config/base/package-doc/chapters.ent:1.9
--- gnue/gnue-config/base/package-doc/chapters.ent:1.8 Thu Jul 5 18:25:48 2001
+++ gnue/gnue-config/base/package-doc/chapters.ent Thu Jul 5 19:36:42 2001
@@ -1,6 +1,6 @@
<!-- -*- SGML -*-
- $Id: chapters.ent,v 1.8 2001/07/06 01:25:48 ntiffin Exp $
+ $Id: chapters.ent,v 1.9 2001/07/06 02:36:42 ntiffin Exp $
Contains chapter references
@@ -28,3 +28,5 @@
<!ENTITY orgcode SYSTEM "../org/classes/org.gcd">
<!ENTITY currencydata SYSTEM
"../currency/defaults/insert-en-ISO4217.sql.gcd">
+<!ENTITY countrydata SYSTEM
"../location/defaults/insert-en-country-codes.sql.gcd">
+<!ENTITY statedata SYSTEM
"../location/defaults/insert-en-us-states.sql.gcd">