[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue/gnue-config accounting/gl/defaults/insert-...
From: |
Neil Tiffin |
Subject: |
gnue/gnue-config accounting/gl/defaults/insert-... |
Date: |
Fri, 06 Jul 2001 18:23:41 -0700 |
CVSROOT: /home/cvs
Module name: gnue
Changes by: Neil Tiffin <address@hidden> 01/07/06 18:23:41
Modified files:
gnue-config/accounting/gl/defaults: insert-en-status.sql
insert-en-type.sql
gnue-config/base/currency/defaults:
insert-en-ISO4217-currency.sql
gnue-config/base/language/defaults:
insert-ISO639LanguageCodes.sql
gnue-config/base/location/defaults: insert-en-country-codes.sql
insert-en-us-states.sql
gnue-config/base/person/defaults: insert-en-person-type.sql
insert-en-salutations.sql
Log message:
Reformat all files in non-sql format. All of these files will be
renamed.
CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/accounting/gl/defaults/insert-en-status.sql.diff?cvsroot=OldCVS&tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/accounting/gl/defaults/insert-en-type.sql.diff?cvsroot=OldCVS&tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.sql.diff?cvsroot=OldCVS&tr1=1.4&tr2=1.5&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.sql.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/defaults/insert-en-country-codes.sql.diff?cvsroot=OldCVS&tr1=1.2&tr2=1.3&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.2&tr2=1.3&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/person/defaults/insert-en-person-type.sql.diff?cvsroot=OldCVS&tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/person/defaults/insert-en-salutations.sql.diff?cvsroot=OldCVS&tr1=1.4&tr2=1.5&r1=text&r2=text
Patches:
Index: gnue/gnue-config/accounting/gl/defaults/insert-en-status.sql
diff -u gnue/gnue-config/accounting/gl/defaults/insert-en-status.sql:1.3
gnue/gnue-config/accounting/gl/defaults/insert-en-status.sql:1.4
--- gnue/gnue-config/accounting/gl/defaults/insert-en-status.sql:1.3 Thu Jul
5 18:25:47 2001
+++ gnue/gnue-config/accounting/gl/defaults/insert-en-status.sql Fri Jul
6 18:23:41 2001
@@ -1,7 +1,11 @@
-# $Id: insert-en-status.sql,v 1.3 2001/07/06 01:25:47 ntiffin Exp $
+#
+# This is a special file format that is converted by the
+# GEAS sql loader into valid sql
+#
+# $Id: insert-en-status.sql,v 1.4 2001/07/07 01:23:41 ntiffin Exp $
-INSERT INTO gl_acct__status (name, abbreviation, postable) VALUES
- ("Active", "A", true),
- ("InActive", "I", false),
- ("DeActivated", "D", false);
+INSERT INTO gl_acct__status (objectid, name, abbreviation, postable) VALUES
+ ("GEAS-OBJECT-ID", "Active", "A", true);
+ ("GEAS-OBJECT-ID", "InActive", "I", false);
+ ("GEAS-OBJECT-ID", "DeActivated", "D", false);
Index: gnue/gnue-config/accounting/gl/defaults/insert-en-type.sql
diff -u gnue/gnue-config/accounting/gl/defaults/insert-en-type.sql:1.3
gnue/gnue-config/accounting/gl/defaults/insert-en-type.sql:1.4
--- gnue/gnue-config/accounting/gl/defaults/insert-en-type.sql:1.3 Thu Jul
5 18:25:47 2001
+++ gnue/gnue-config/accounting/gl/defaults/insert-en-type.sql Fri Jul 6
18:23:41 2001
@@ -1,10 +1,14 @@
-# $Id: insert-en-type.sql,v 1.3 2001/07/06 01:25:47 ntiffin Exp $
+#
+# This is a special file format that is converted by the
+# GEAS sql loader into valid sql
+#
+# $Id: insert-en-type.sql,v 1.4 2001/07/07 01:23:41 ntiffin Exp $
-INSERT INTO gl_acct__type (name, description) VALUES
- ("Assets", "Assets"),
- ("Liabilities", "Liabilities"),
- ("Expenses", "Expenses"),
- ("Revenues", "Revenues"),
- ("Cost", "Cost of Goods"),
- ("Capital", "Capital");
\ No newline at end of file
+INSERT INTO gl_acct__type (objectid, name, description) VALUES
+ ("GEAS-OBJECT-ID", "Assets", "Assets");
+ ("GEAS-OBJECT-ID", "Liabilities", "Liabilities");
+ ("GEAS-OBJECT-ID", "Expenses", "Expenses");
+ ("GEAS-OBJECT-ID", "Revenues", "Revenues");
+ ("GEAS-OBJECT-ID", "Cost", "Cost of Goods");
+ ("GEAS-OBJECT-ID", "Capital", "Capital");
\ No newline at end of file
Index: gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.sql
diff -u
gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.sql:1.4
gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.sql:1.5
--- gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.sql:1.4
Fri Jul 6 10:45:31 2001
+++ gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.sql
Fri Jul 6 18:23:41 2001
@@ -13,164 +13,168 @@
# Maintenance Agency for ISO 4217. The code is for use in any application
of
# trade, commerce and banking.
#
-# $Id: insert-en-ISO4217-currency.sql,v 1.4 2001/07/06 17:45:31 dneighbors
Exp $
#
+# This is a special file format that is converted by the
+# GEAS sql loader into valid sql
+#
+# $Id: insert-en-ISO4217-currency.sql,v 1.5 2001/07/07 01:23:41 ntiffin Exp
$
+#
+INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89801 ','ADP', 'Andorran
Peseta',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89802 ','AED', 'United
Arab Emirates Dirham',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89803 ','AFA',
'Afghanistan Afghani',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89804 ','ALL', 'Albanian
Lek',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89805 ','ANG',
'Netherlands Antillian Guilder',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89806 ','AOK', 'Angolan
Kwanza',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89807 ','ARA',
'Argentinian Austral',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89808 ','ATS', 'Austrian
Schilling',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89809 ','AUD',
'Australian Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89810 ','AWG', 'Aruban
Florin',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89811 ','BBD', 'Barbados
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89812 ','BDT',
'Bangladeshi Taka',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89813 ','BEF', 'Belgian
Franc',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89814 ','BGL', 'Bulgarian
Lev',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89815 ','BHD', 'Bahraini
Dinar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89816 ','BIF', 'Burundi
Franc',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89817 ','BMD', 'Bermudian
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89818 ','BND', 'Brunei
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89819 ','BOB', 'Bolivian
Boliviano',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89820 ','BRC', 'Brazilian
Cruzeiro',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89821 ','BSD', 'Bahamian
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89822 ','BTN', 'Bhutan
Ngultrum',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89823 ','BUK', 'Burma
Kyat',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89824 ','BWP',
'Botswanian Pula',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89825 ','BZD', 'Belize
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89826 ','CAD', 'Canadian
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89827 ','CHF', 'Swiss
Franc',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89828 ','CLF', 'Chilean
Unidades de Fomento',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89829 ','CLP', 'Chilean
Peso',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89830 ','CNY', 'Yuan
(Chinese) Renminbi',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89831 ','COP', 'Colombian
Peso',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89832 ','CRC', 'Costa
Rican Colon',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89833 ','CSK', 'Czech
Koruna',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89834 ','CUP', 'Cuban
Peso',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89835 ','CVE', 'Cape
Verde Escudo',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89836 ','CYP', 'Cyprus
Pound',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89837 ','DDM', 'East
German Mark',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89838 ','DDR',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89839 ','DEM', 'Deutsche
Mark',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89840 ','DJF', 'Djibouti
Franc',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89841 ','DKK', 'Danish
Krone',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89842 ','DOP', 'Dominican
Peso',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89843 ','DZD', 'Algerian
Dinar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89844 ','ECS', 'Ecuador
Sucre',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89845 ','EGP', 'Egyptian
Pound',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89846 ','ESP', 'Spanish
Peseta',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89847 ','ETB', 'Ethiopian
Birr',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89848 ','EUR', 'Euro',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89849 ','FIM', 'Finnish
Markka',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89850 ','FJD', 'Fiji
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89851 ','FKP', 'Falkland
Islands Pound',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89852 ','FRF', 'French
Franc',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89853 ','GBP', 'British
Pound',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89854 ','GHC', 'Ghanaian
Cedi',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89855 ','GIP', 'Gibraltar
Pound',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89856 ','GMD', 'Gambian
Dalasi',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89857 ','GNF', 'Guinea
Franc',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89858 ','GRD', 'Greek
Drachma',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89859 ','GTQ',
'Guatemalan Quetzal',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89860 ','GWP',
'Guinea-Bissau Peso',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89861 ','GYD', 'Guyanan
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89862 ','HKD', 'Hong Kong
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89863 ','HNL', 'Honduran
Lempira',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89864 ','HTG', 'Haitian
Gourde',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89865 ','HUF', 'Hungarian
Forint',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89866 ','IDR',
'Indonesian Rupiah',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89867 ','IEP', 'Irish
Punt',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89868 ','ILS', 'Israeli
Shekel',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89869 ','INR', 'Indian
Rupee',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89870 ','IQD', 'Iraqi
Dinar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89871 ','IRR', 'Iranian
Rial',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89872 ','ISK', 'Iceland
Krona',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89873 ','ITL', 'Italian
Lira',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89874 ','JMD', 'Jamaican
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89875 ','JOD', 'Jordanian
Dinar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89876 ','JPY', 'Japanese
Yen',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89877 ','KES', 'Kenyan
Schilling',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89878 ','KHR',
'Kampuchean (Cambodian) Riel',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89879 ','KMF', 'Comoros
Franc',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89880 ','KPW', 'North
Korean Won',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89881 ','KRW', '(South)
Korean Won',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89882 ','KWD', 'Kuwaiti
Dinar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89883 ','KYD', 'Cayman
Islands Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89884 ','LAK', 'Lao
Kip',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89885 ','LBP', 'Lebanese
Pound',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89886 ','LKR', 'Sri Lanka
Rupee',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89887 ','LRD', 'Liberian
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89888 ','LSL', 'Lesotho
Loti',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89889 ','LUF',
'Luxembourg Franc',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89890 ','LYD', 'Libyan
Dinar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89891 ','MAD', 'Moroccan
Dirham',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89892 ','MGF', 'Malagasy
Franc',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89893 ','MNT', 'Mongolian
Tugrik',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89894 ','MOP', 'Macau
Pataca',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89895 ','MRO',
'Mauritanian Ouguiya',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89896 ','MTL', 'Maltese
Lira',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89897 ','MUR', 'Mauritius
Rupee',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89898 ','MVR', 'Maldive
Rufiyaa',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89899 ','MWK', 'Malawi
Kwacha',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89100 ','MXP', 'Mexican
Peso',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89101 ','MYR', 'Malaysian
Ringgit',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89102 ','MZM',
'Mozambique Metical',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89103 ','NGN', 'Nigerian
Naira',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89104 ','NIC',
'Nicaraguan Cordoba',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89105 ','NLG', 'Dutch
Guilder',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89106 ','NOK', 'Norwegian
Kroner',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89107 ','NPR', 'Nepalese
Rupee',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89108 ','NZD', 'New
Zealand Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89109 ','OMR', 'Omani
Rial',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89110 ','PAB',
'Panamanian Balboa',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89111 ','PEI', 'Peruvian
Inti',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89112 ','PGK', 'Papua New
Guinea Kina',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89113 ','PHP',
'Philippine Peso',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89114 ','PKR', 'Pakistan
Rupee',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89115 ','PLZ', 'Polish
Zloty',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89116 ','PTE',
'Portuguese Escudo',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89117 ','PYG', 'Paraguay
Guarani',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89118 ','QAR', 'Qatari
Rial',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89119 ','ROL', 'Romanian
Leu',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89120 ','RWF', 'Rwanda
Franc',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89121 ','SAR', 'Saudi
Arabian Riyal',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89122 ','SBD', 'Solomon
Islands Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89123 ','SCR',
'Seychelles Rupee',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89124 ','SDP', 'Sudanese
Pound',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89125 ','SEK', 'Swedish
Krona',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89126 ','SGD', 'Singapore
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89127 ','SHP', 'St.
Helena Pound',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89128 ','SLL', 'Sierra
Leone Leone',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89129 ','SOS', 'Somali
Schilling',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89130 ','SRG', 'Suriname
Guilder',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89131 ','STD', 'Sao Tome
and Principe Dobra',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89132 ','SUR', 'USSR
Rouble',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89133 ','SVC', 'El
Salvador Colon',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89134 ','SYP', 'Syrian
Potmd',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89135 ','SZL', 'Swaziland
Lilangeni',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89136 ','THB', 'Thai
Bhat',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89137 ','TND', 'Tunisian
Dinar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89138 ','TOP', 'Tongan
Paanga',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89139 ','TPE', 'East
Timor Escudo',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89140 ','TRL', 'Turkish
Lira',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89141 ','TTD', 'Trinidad
and Tobago Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89142 ','TWD', 'Taiwan
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89143 ','TZS', 'Tanzanian
Schilling',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89144 ','UGS', 'Uganda
Shilling',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89145 ','USD', 'US
Dollar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89146 ','UYP', 'Uruguayan
Peso',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89147 ','VEB',
'Venezualan Bolivar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89148 ','VND',
'Vietnamese Dong',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89149 ','VUV', 'Vanuatu
Vatu',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89150 ','WST', 'Samoan
Tala',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89151 ','YDD',
'Democratic Yemeni Dinar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89152 ','YER', 'Yemeni
Rial',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89153 ','YUD', 'New
Yugoslavia Dinar',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89154 ','ZAR', 'South
African Rand',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89155 ','ZMK', 'Zambian
Kwacha',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89156 ','ZRZ', 'Zaire
Zaire',2);
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES('a1cad99e60a44a789363fec1fff89157 ','ZWD', 'Zimbabwe
Dollar',2);
-;
+('GEAS-OBJECT-ID', 'ADP', 'Andorran Peseta',2);
+('GEAS-OBJECT-ID', 'AED', 'United Arab Emirates Dirham',2);
+('GEAS-OBJECT-ID', 'AFA', 'Afghanistan Afghani',2);
+('GEAS-OBJECT-ID', 'ALL', 'Albanian Lek',2);
+('GEAS-OBJECT-ID', 'ANG', 'Netherlands Antillian Guilder',2);
+('GEAS-OBJECT-ID', 'AOK', 'Angolan Kwanza',2);
+('GEAS-OBJECT-ID', 'ARA', 'Argentinian Austral',2);
+('GEAS-OBJECT-ID', 'ATS', 'Austrian Schilling',2);
+('GEAS-OBJECT-ID', 'AUD', 'Australian Dollar',2);
+('GEAS-OBJECT-ID', 'AWG', 'Aruban Florin',2);
+('GEAS-OBJECT-ID', 'BBD', 'Barbados Dollar',2);
+('GEAS-OBJECT-ID', 'BDT', 'Bangladeshi Taka',2);
+('GEAS-OBJECT-ID', 'BEF', 'Belgian Franc',2);
+('GEAS-OBJECT-ID', 'BGL', 'Bulgarian Lev',2);
+('GEAS-OBJECT-ID', 'BHD', 'Bahraini Dinar',2);
+('GEAS-OBJECT-ID', 'BIF', 'Burundi Franc',2);
+('GEAS-OBJECT-ID', 'BMD', 'Bermudian Dollar',2);
+('GEAS-OBJECT-ID', 'BND', 'Brunei Dollar',2);
+('GEAS-OBJECT-ID', 'BOB', 'Bolivian Boliviano',2);
+('GEAS-OBJECT-ID', 'BRC', 'Brazilian Cruzeiro',2);
+('GEAS-OBJECT-ID', 'BSD', 'Bahamian Dollar',2);
+('GEAS-OBJECT-ID', 'BTN', 'Bhutan Ngultrum',2);
+('GEAS-OBJECT-ID', 'BUK', 'Burma Kyat',2);
+('GEAS-OBJECT-ID', 'BWP', 'Botswanian Pula',2);
+('GEAS-OBJECT-ID', 'BZD', 'Belize Dollar',2);
+('GEAS-OBJECT-ID', 'CAD', 'Canadian Dollar',2);
+('GEAS-OBJECT-ID', 'CHF', 'Swiss Franc',2);
+('GEAS-OBJECT-ID', 'CLF', 'Chilean Unidades de Fomento',2);
+('GEAS-OBJECT-ID', 'CLP', 'Chilean Peso',2);
+('GEAS-OBJECT-ID', 'CNY', 'Yuan (Chinese) Renminbi',2);
+('GEAS-OBJECT-ID', 'COP', 'Colombian Peso',2);
+('GEAS-OBJECT-ID', 'CRC', 'Costa Rican Colon',2);
+('GEAS-OBJECT-ID', 'CSK', 'Czech Koruna',2);
+('GEAS-OBJECT-ID', 'CUP', 'Cuban Peso',2);
+('GEAS-OBJECT-ID', 'CVE', 'Cape Verde Escudo',2);
+('GEAS-OBJECT-ID', 'CYP', 'Cyprus Pound',2);
+('GEAS-OBJECT-ID', 'DDM', 'East German Mark',2),
+('GEAS-OBJECT-ID', 'DDR',2);
+('GEAS-OBJECT-ID', 'DEM', 'Deutsche Mark',2);
+('GEAS-OBJECT-ID', 'DJF', 'Djibouti Franc',2);
+('GEAS-OBJECT-ID', 'DKK', 'Danish Krone',2);
+('GEAS-OBJECT-ID', 'DOP', 'Dominican Peso',2);
+('GEAS-OBJECT-ID', 'DZD', 'Algerian Dinar',2);
+('GEAS-OBJECT-ID', 'ECS', 'Ecuador Sucre',2);
+('GEAS-OBJECT-ID', 'EGP', 'Egyptian Pound',2);
+('GEAS-OBJECT-ID', 'ESP', 'Spanish Peseta',2);
+('GEAS-OBJECT-ID', 'ETB', 'Ethiopian Birr',2);
+('GEAS-OBJECT-ID', 'EUR', 'Euro',2);
+('GEAS-OBJECT-ID', 'FIM', 'Finnish Markka',2);
+('GEAS-OBJECT-ID', 'FJD', 'Fiji Dollar',2);
+('GEAS-OBJECT-ID', 'FKP', 'Falkland Islands Pound',2);
+('GEAS-OBJECT-ID', 'FRF', 'French Franc',2);
+('GEAS-OBJECT-ID', 'GBP', 'British Pound',2);
+('GEAS-OBJECT-ID', 'GHC', 'Ghanaian Cedi',2);
+('GEAS-OBJECT-ID', 'GIP', 'Gibraltar Pound',2);
+('GEAS-OBJECT-ID', 'GMD', 'Gambian Dalasi',2);
+('GEAS-OBJECT-ID', 'GNF', 'Guinea Franc',2);
+('GEAS-OBJECT-ID', 'GRD', 'Greek Drachma',2);
+('GEAS-OBJECT-ID', 'GTQ', 'Guatemalan Quetzal',2);
+('GEAS-OBJECT-ID', 'GWP', 'Guinea-Bissau Peso',2);
+('GEAS-OBJECT-ID', 'GYD', 'Guyanan Dollar',2);
+('GEAS-OBJECT-ID', 'HKD', 'Hong Kong Dollar',2);
+('GEAS-OBJECT-ID', 'HNL', 'Honduran Lempira',2);
+('GEAS-OBJECT-ID', 'HTG', 'Haitian Gourde',2);
+('GEAS-OBJECT-ID', 'HUF', 'Hungarian Forint',2);
+('GEAS-OBJECT-ID', 'IDR', 'Indonesian Rupiah',2);
+('GEAS-OBJECT-ID', 'IEP', 'Irish Punt',2);
+('GEAS-OBJECT-ID', 'ILS', 'Israeli Shekel',2);
+('GEAS-OBJECT-ID', 'INR', 'Indian Rupee',2);
+('GEAS-OBJECT-ID', 'IQD', 'Iraqi Dinar',2);
+('GEAS-OBJECT-ID', 'IRR', 'Iranian Rial',2);
+('GEAS-OBJECT-ID', 'ISK', 'Iceland Krona',2);
+('GEAS-OBJECT-ID', 'ITL', 'Italian Lira',2);
+('GEAS-OBJECT-ID', 'JMD', 'Jamaican Dollar',2);
+('GEAS-OBJECT-ID', 'JOD', 'Jordanian Dinar',2);
+('GEAS-OBJECT-ID', 'JPY', 'Japanese Yen',2);
+('GEAS-OBJECT-ID', 'KES', 'Kenyan Schilling',2);
+('GEAS-OBJECT-ID', 'KHR', 'Kampuchean (Cambodian) Riel',2);
+('GEAS-OBJECT-ID', 'KMF', 'Comoros Franc',2);
+('GEAS-OBJECT-ID', 'KPW', 'North Korean Won',2);
+('GEAS-OBJECT-ID', 'KRW', '(South) Korean Won',2);
+('GEAS-OBJECT-ID', 'KWD', 'Kuwaiti Dinar',2);
+('GEAS-OBJECT-ID', 'KYD', 'Cayman Islands Dollar',2);
+('GEAS-OBJECT-ID', 'LAK', 'Lao Kip',2);
+('GEAS-OBJECT-ID', 'LBP', 'Lebanese Pound',2);
+('GEAS-OBJECT-ID', 'LKR', 'Sri Lanka Rupee',2);
+('GEAS-OBJECT-ID', 'LRD', 'Liberian Dollar',2);
+('GEAS-OBJECT-ID', 'LSL', 'Lesotho Loti',2);
+('GEAS-OBJECT-ID', 'LUF', 'Luxembourg Franc',2);
+('GEAS-OBJECT-ID', 'LYD', 'Libyan Dinar',2);
+('GEAS-OBJECT-ID', 'MAD', 'Moroccan Dirham',2);
+('GEAS-OBJECT-ID', 'MGF', 'Malagasy Franc',2);
+('GEAS-OBJECT-ID', 'MNT', 'Mongolian Tugrik',2);
+('GEAS-OBJECT-ID', 'MOP', 'Macau Pataca',2);
+('GEAS-OBJECT-ID', 'MRO', 'Mauritanian Ouguiya',2);
+('GEAS-OBJECT-ID', 'MTL', 'Maltese Lira',2);
+('GEAS-OBJECT-ID', 'MUR', 'Mauritius Rupee',2);
+('GEAS-OBJECT-ID', 'MVR', 'Maldive Rufiyaa',2);
+('GEAS-OBJECT-ID', 'MWK', 'Malawi Kwacha',2);
+('GEAS-OBJECT-ID', 'MXP', 'Mexican Peso',2);
+('GEAS-OBJECT-ID', 'MYR', 'Malaysian Ringgit',2);
+('GEAS-OBJECT-ID', 'MZM', 'Mozambique Metical',2);
+('GEAS-OBJECT-ID', 'NGN', 'Nigerian Naira',2);
+('GEAS-OBJECT-ID', 'NIC', 'Nicaraguan Cordoba',2);
+('GEAS-OBJECT-ID', 'NLG', 'Dutch Guilder',2);
+('GEAS-OBJECT-ID', 'NOK', 'Norwegian Kroner',2);
+('GEAS-OBJECT-ID', 'NPR', 'Nepalese Rupee',2);
+('GEAS-OBJECT-ID', 'NZD', 'New Zealand Dollar',2);
+('GEAS-OBJECT-ID', 'OMR', 'Omani Rial',2);
+('GEAS-OBJECT-ID', 'PAB', 'Panamanian Balboa',2);
+('GEAS-OBJECT-ID', 'PEI', 'Peruvian Inti',2);
+('GEAS-OBJECT-ID', 'PGK', 'Papua New Guinea Kina',2);
+('GEAS-OBJECT-ID', 'PHP', 'Philippine Peso',2);
+('GEAS-OBJECT-ID', 'PKR', 'Pakistan Rupee',2);
+('GEAS-OBJECT-ID', 'PLZ', 'Polish Zloty',2);
+('GEAS-OBJECT-ID', 'PTE', 'Portuguese Escudo',2);
+('GEAS-OBJECT-ID', 'PYG', 'Paraguay Guarani',2);
+('GEAS-OBJECT-ID', 'QAR', 'Qatari Rial',2);
+('GEAS-OBJECT-ID', 'ROL', 'Romanian Leu',2);
+('GEAS-OBJECT-ID', 'RWF', 'Rwanda Franc',2);
+('GEAS-OBJECT-ID', 'SAR', 'Saudi Arabian Riyal',2);
+('GEAS-OBJECT-ID', 'SBD', 'Solomon Islands Dollar',2);
+('GEAS-OBJECT-ID', 'SCR', 'Seychelles Rupee',2);
+('GEAS-OBJECT-ID', 'SDP', 'Sudanese Pound',2);
+('GEAS-OBJECT-ID', 'SEK', 'Swedish Krona',2);
+('GEAS-OBJECT-ID', 'SGD', 'Singapore Dollar',2);
+('GEAS-OBJECT-ID', 'SHP', 'St. Helena Pound',2);
+('GEAS-OBJECT-ID', 'SLL', 'Sierra Leone Leone',2);
+('GEAS-OBJECT-ID', 'SOS', 'Somali Schilling',2);
+('GEAS-OBJECT-ID', 'SRG', 'Suriname Guilder',2);
+('GEAS-OBJECT-ID', 'STD', 'Sao Tome and Principe Dobra',2);
+('GEAS-OBJECT-ID', 'SUR', 'USSR Rouble',2);
+('GEAS-OBJECT-ID', 'SVC', 'El Salvador Colon',2);
+('GEAS-OBJECT-ID', 'SYP', 'Syrian Potmd',2);
+('GEAS-OBJECT-ID', 'SZL', 'Swaziland Lilangeni',2);
+('GEAS-OBJECT-ID', 'THB', 'Thai Bhat',2);
+('GEAS-OBJECT-ID', 'TND', 'Tunisian Dinar',2);
+('GEAS-OBJECT-ID', 'TOP', 'Tongan Paanga',2);
+('GEAS-OBJECT-ID', 'TPE', 'East Timor Escudo',2);
+('GEAS-OBJECT-ID', 'TRL', 'Turkish Lira',2);
+('GEAS-OBJECT-ID', 'TTD', 'Trinidad and Tobago Dollar',2);
+('GEAS-OBJECT-ID', 'TWD', 'Taiwan Dollar',2);
+('GEAS-OBJECT-ID', 'TZS', 'Tanzanian Schilling',2);
+('GEAS-OBJECT-ID', 'UGS', 'Uganda Shilling',2);
+('GEAS-OBJECT-ID', 'USD', 'US Dollar',2);
+('GEAS-OBJECT-ID', 'UYP', 'Uruguayan Peso',2);
+('GEAS-OBJECT-ID', 'VEB', 'Venezualan Bolivar',2);
+('GEAS-OBJECT-ID', 'VND', 'Vietnamese Dong',2);
+('GEAS-OBJECT-ID', 'VUV', 'Vanuatu Vatu',2);
+('GEAS-OBJECT-ID', 'WST', 'Samoan Tala',2);
+('GEAS-OBJECT-ID', 'YDD', 'Democratic Yemeni Dinar',2);
+('GEAS-OBJECT-ID', 'YER', 'Yemeni Rial',2);
+('GEAS-OBJECT-ID', 'YUD', 'New Yugoslavia Dinar',2);
+('GEAS-OBJECT-ID', 'ZAR', 'South African Rand',2);
+('GEAS-OBJECT-ID', 'ZMK', 'Zambian Kwacha',2);
+('GEAS-OBJECT-ID', 'ZRZ', 'Zaire Zaire',2);
+('GEAS-OBJECT-ID', 'ZWD', 'Zimbabwe Dollar',2);
Index: gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.sql
diff -u
gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.sql:1.4
gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.sql:1.5
--- gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.sql:1.4
Thu Jul 5 18:25:48 2001
+++ gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.sql
Fri Jul 6 18:23:41 2001
@@ -4,145 +4,147 @@
#
# Not guaranteed to up to date.
#
-# $Id: insert-ISO639LanguageCodes.sql,v 1.4 2001/07/06 01:25:48 ntiffin Exp $
+# This is a special file format that is converted by the
+# GEAS sql loader into valid sql
#
+# $Id: insert-ISO639LanguageCodes.sql,v 1.5 2001/07/07 01:23:41 ntiffin Exp $
+#
-INSERT INTO language__language (code, desc_en, desc_fr) VALUES
- ("aa", "Afar", "afar"),
- ("ab", "Abkhazian", "abkhaze"),
- ("af", "Afrikaans", "afrikaans"),
- ("am", "Amharic", "amharique"),
- ("ar", "Arabic", "arabe"),
- ("as", "Assamese", "assamais"),
- ("ay", "Aymara", "aymara"),
- ("az", "Azerbaijani", "azri"),
- ("ba", "Bashkir", "bachkir"),
- ("be", "Byelorussian", "bilorusse"),
- ("bg", "Bulgarian", "bulgare"),
- ("bh", "Bihari", "bihari"),
- ("bi", "Bislama", "bichlamar"),
- ("bn", "Bengali Bangla", "bengali"),
- ("bo", "Tibetan", "tibtain"),
- ("br", "Breton", "breton"),
- ("ca", "Catalan", "catalan"),
- ("co", "Corsican", "corse"),
- ("cs", "Czech", "tchque"),
- ("cy", "Welsh", "gallois"),
- ("da", "Danish", "danois"),
- ("de", "German", "allemand"),
- ("el", "Greek", "grec"),
- ("en", "English", "anglais"),
- ("eo", "Esperanto", "espranto"),
- ("es", "Spanish", "espagnol"),
- ("et", "Estonian", "estonien"),
- ("eu", "Basque", "basque"),
- ("fa", "Persian", "persan"),
- ("fi", "Finnish", "finnois"),
- ("fj", "Fijian", "fidjien"),
- ("fo", "Faeroese", "froen"),
- ("fr", "French", "franais"),
- ("fy", "Frisian", "frison"),
- ("ga", "Irish", "irlandais"),
- ("gd", "Scots, Gaelic", "galique d'Ecosse"),
- ("gl", "Gallegan", "galicien"),
- ("gn", "Guarani", "guarani"),
- ("gu", "Gujarati", "goudjrati"),
- ("he", "Hebrew", "hbreu"),
- ("ha", "Hausa", "haoussa"),
- ("hi", "Hindi", "hindi"),
- ("hr", "Croatian", "croate"),
- ("hu", "Hungarian", "hongrois"),
- ("hy", "Armenian", "armnien"),
- ("ia", "Interlingua", "interlingua"),
- ("id", "Indonesian", "indonsien"),
- ("ie", "Interlingue", "interlingue"),
- ("ik", "Inupiaq", "inupiaq"),
- ("is", "Icelandic", "islandais"),
- ("it", "Italian", "italien"),
- ("iu", "Inuktitut", "inuktitut"),
- ("ja", "Japanese", "japonais"),
- ("jw", "Javanese", "javanais"),
- ("ka", "Georgian", "gorgien"),
- ("kk", "Kazakh", "kazakh"),
- ("kl", "Kalaallisut", "groenlandais"),
- ("km", "Khmer", "khmer"),
- ("kn", "Kannada", "kannada"),
- ("ko", "Korean", "coren"),
- ("ks", "Kashmiri", "kashmiri"),
- ("ku", "Kurdish", "kurde"),
- ("ky", "Kirghiz", "kirghize"),
- ("la", "Latin", "latin"),
- ("ln", "Lingala", "lingala"),
- ("lo", "Lao", "lao"),
- ("lt", "Lithuanian", "lituanien"),
- ("lv", "Latvian", "letton"),
- ("mg", "Malagasy", "malgache"),
- ("mi", "Maori", "maori"),
- ("mk", "Macedonian", "macdonien"),
- ("ml", "Malayalam", "malayalam"),
- ("mn", "Mongolian", "mongol"),
- ("mo", "Moldavian", "moldave"),
- ("mr", "Marathi", "marathe"),
- ("ms", "Malay", "malais"),
- ("mt", "Maltese", "maltais"),
- ("my", "Burmese", "birman"),
- ("na", "Nauru", "nauruan"),
- ("ne", "Nepali", "npalais"),
- ("nl", "Dutch", "nerlandais"),
- ("no", "Norwegian", "norvgien"),
- ("oc", "Occitan", "occitan"),
- ("om", "Oromo", "galla"),
- ("or", "Oriya", "oriya"),
- ("pa", "Panjabi", "pendjabi"),
- ("pl", "Polish", "polonais"),
- ("ps", "Pushto", "pachto"),
- ("pt", "Portuguese", "portugais"),
- ("qu", "Quechua", "quechua"),
- ("rm", "Raeto-Romance", "rhto-roman"),
- ("rn", "Rundi", "rundi"),
- ("ro", "Romanian", "roumain"),
- ("ru", "Russian", "russe"),
- ("rw", "Kinyarwanda", "rwanda"),
- ("sa", "Sanskrit", "sanskrit"),
- ("sd", "Sindhi", "sindhi"),
- ("sg", "Sango", "sango"),
- ("si", "Sinhalese", "singhalais"),
- ("sk", "Slovak", "slovaque"),
- ("sl", "Slovenian", "slovne"),
- ("sm", "Samoan", "samoan"),
- ("sn", "Shona", "shona"),
- ("so", "Somali", "somali"),
- ("sq", "Albanian", "albanais"),
- ("sr", "Serbian", "serbe"),
- ("ss", "Swati", "swati"),
- ("st", "Sotho", "sotho"),
- ("su", "Sundanese", "soundanais"),
- ("sv", "Swedish", "sudois"),
- ("sw", "Swahili", "swahili"),
- ("ta", "Tamil", "tamoul"),
- ("te", "Telugu", "tlougou"),
- ("tg", "Tajik", "tadjik"),
- ("th", "Thai", "tha"),
- ("ti", "Tigrinya", "tigrigna"),
- ("tk", "Turkmen", "turkmne"),
- ("tl", "Tagalog", "tagalog"),
- ("tn", "Tswana", "tswana"),
- ("to", "Tonga", "tongan"),
- ("tr", "Turkish", "turc"),
- ("ts", "Tsonga", "tsonga"),
- ("tt", "Tatar", "tatar"),
- ("tw", "Twi", "twi"),
- ("ug", "Uighur", "ougour"),
- ("uk", "Ukrainian", "ukrainien"),
- ("ur", "Urdu", "ourdou"),
- ("uz", "Uzbek", "ouszbek"),
- ("vi", "Vietnamese", "vietnamien"),
- ("vo", "Volapk", "volapk"),
- ("wo", "Wolof", "wolof"),
- ("xh", "Xhosa", "xhosa"),
- ("y", "Yiddish", "yiddish"),
- ("yo", "Yoruba", "yoruba"),
- ("za", "Zhuang", "zhuang"),
- ("zh", "Chinese", "chinois"),
- ("zu", "Zulu", "zoulou")
-;
+INSERT INTO language__language (objectid, code, desc_en, desc_fr) VALUES
+ ("GEAS-OBJECT-ID", "aa", "Afar", "afar");
+ ("GEAS-OBJECT-ID", "ab", "Abkhazian", "abkhaze");
+ ("GEAS-OBJECT-ID", "af", "Afrikaans", "afrikaans");
+ ("GEAS-OBJECT-ID", "am", "Amharic", "amharique");
+ ("GEAS-OBJECT-ID", "ar", "Arabic", "arabe");
+ ("GEAS-OBJECT-ID", "as", "Assamese", "assamais");
+ ("GEAS-OBJECT-ID", "ay", "Aymara", "aymara");
+ ("GEAS-OBJECT-ID", "az", "Azerbaijani", "azri");
+ ("GEAS-OBJECT-ID", "ba", "Bashkir", "bachkir");
+ ("GEAS-OBJECT-ID", "be", "Byelorussian", "bilorusse");
+ ("GEAS-OBJECT-ID", "bg", "Bulgarian", "bulgare");
+ ("GEAS-OBJECT-ID", "bh", "Bihari", "bihari");
+ ("GEAS-OBJECT-ID", "bi", "Bislama", "bichlamar");
+ ("GEAS-OBJECT-ID", "bn", "Bengali Bangla", "bengali");
+ ("GEAS-OBJECT-ID", "bo", "Tibetan", "tibtain");
+ ("GEAS-OBJECT-ID", "br", "Breton", "breton");
+ ("GEAS-OBJECT-ID", "ca", "Catalan", "catalan");
+ ("GEAS-OBJECT-ID", "co", "Corsican", "corse");
+ ("GEAS-OBJECT-ID", "cs", "Czech", "tchque");
+ ("GEAS-OBJECT-ID", "cy", "Welsh", "gallois");
+ ("GEAS-OBJECT-ID", "da", "Danish", "danois");
+ ("GEAS-OBJECT-ID", "de", "German", "allemand");
+ ("GEAS-OBJECT-ID", "el", "Greek", "grec");
+ ("GEAS-OBJECT-ID", "en", "English", "anglais");
+ ("GEAS-OBJECT-ID", "eo", "Esperanto", "espranto");
+ ("GEAS-OBJECT-ID", "es", "Spanish", "espagnol");
+ ("GEAS-OBJECT-ID", "et", "Estonian", "estonien");
+ ("GEAS-OBJECT-ID", "eu", "Basque", "basque");
+ ("GEAS-OBJECT-ID", "fa", "Persian", "persan");
+ ("GEAS-OBJECT-ID", "fi", "Finnish", "finnois");
+ ("GEAS-OBJECT-ID", "fj", "Fijian", "fidjien");
+ ("GEAS-OBJECT-ID", "fo", "Faeroese", "froen");
+ ("GEAS-OBJECT-ID", "fr", "French", "franais");
+ ("GEAS-OBJECT-ID", "fy", "Frisian", "frison");
+ ("GEAS-OBJECT-ID", "ga", "Irish", "irlandais");
+ ("GEAS-OBJECT-ID", "gd", "Scots, Gaelic", "galique d'Ecosse");
+ ("GEAS-OBJECT-ID", "gl", "Gallegan", "galicien");
+ ("GEAS-OBJECT-ID", "gn", "Guarani", "guarani");
+ ("GEAS-OBJECT-ID", "gu", "Gujarati", "goudjrati");
+ ("GEAS-OBJECT-ID", "he", "Hebrew", "hbreu");
+ ("GEAS-OBJECT-ID", "ha", "Hausa", "haoussa");
+ ("GEAS-OBJECT-ID", "hi", "Hindi", "hindi");
+ ("GEAS-OBJECT-ID", "hr", "Croatian", "croate");
+ ("GEAS-OBJECT-ID", "hu", "Hungarian", "hongrois");
+ ("GEAS-OBJECT-ID", "hy", "Armenian", "armnien");
+ ("GEAS-OBJECT-ID", "ia", "Interlingua", "interlingua");
+ ("GEAS-OBJECT-ID", "id", "Indonesian", "indonsien");
+ ("GEAS-OBJECT-ID", "ie", "Interlingue", "interlingue");
+ ("GEAS-OBJECT-ID", "ik", "Inupiaq", "inupiaq");
+ ("GEAS-OBJECT-ID", "is", "Icelandic", "islandais");
+ ("GEAS-OBJECT-ID", "it", "Italian", "italien");
+ ("GEAS-OBJECT-ID", "iu", "Inuktitut", "inuktitut");
+ ("GEAS-OBJECT-ID", "ja", "Japanese", "japonais");
+ ("GEAS-OBJECT-ID", "jw", "Javanese", "javanais");
+ ("GEAS-OBJECT-ID", "ka", "Georgian", "gorgien");
+ ("GEAS-OBJECT-ID", "kk", "Kazakh", "kazakh");
+ ("GEAS-OBJECT-ID", "kl", "Kalaallisut", "groenlandais");
+ ("GEAS-OBJECT-ID", "km", "Khmer", "khmer");
+ ("GEAS-OBJECT-ID", "kn", "Kannada", "kannada");
+ ("GEAS-OBJECT-ID", "ko", "Korean", "coren");
+ ("GEAS-OBJECT-ID", "ks", "Kashmiri", "kashmiri");
+ ("GEAS-OBJECT-ID", "ku", "Kurdish", "kurde");
+ ("GEAS-OBJECT-ID", "ky", "Kirghiz", "kirghize");
+ ("GEAS-OBJECT-ID", "la", "Latin", "latin");
+ ("GEAS-OBJECT-ID", "ln", "Lingala", "lingala");
+ ("GEAS-OBJECT-ID", "lo", "Lao", "lao");
+ ("GEAS-OBJECT-ID", "lt", "Lithuanian", "lituanien");
+ ("GEAS-OBJECT-ID", "lv", "Latvian", "letton");
+ ("GEAS-OBJECT-ID", "mg", "Malagasy", "malgache");
+ ("GEAS-OBJECT-ID", "mi", "Maori", "maori");
+ ("GEAS-OBJECT-ID", "mk", "Macedonian", "macdonien");
+ ("GEAS-OBJECT-ID", "ml", "Malayalam", "malayalam");
+ ("GEAS-OBJECT-ID", "mn", "Mongolian", "mongol");
+ ("GEAS-OBJECT-ID", "mo", "Moldavian", "moldave");
+ ("GEAS-OBJECT-ID", "mr", "Marathi", "marathe");
+ ("GEAS-OBJECT-ID", "ms", "Malay", "malais");
+ ("GEAS-OBJECT-ID", "mt", "Maltese", "maltais");
+ ("GEAS-OBJECT-ID", "my", "Burmese", "birman");
+ ("GEAS-OBJECT-ID", "na", "Nauru", "nauruan");
+ ("GEAS-OBJECT-ID", "ne", "Nepali", "npalais");
+ ("GEAS-OBJECT-ID", "nl", "Dutch", "nerlandais");
+ ("GEAS-OBJECT-ID", "no", "Norwegian", "norvgien");
+ ("GEAS-OBJECT-ID", "oc", "Occitan", "occitan");
+ ("GEAS-OBJECT-ID", "om", "Oromo", "galla");
+ ("GEAS-OBJECT-ID", "or", "Oriya", "oriya");
+ ("GEAS-OBJECT-ID", "pa", "Panjabi", "pendjabi");
+ ("GEAS-OBJECT-ID", "pl", "Polish", "polonais");
+ ("GEAS-OBJECT-ID", "ps", "Pushto", "pachto");
+ ("GEAS-OBJECT-ID", "pt", "Portuguese", "portugais");
+ ("GEAS-OBJECT-ID", "qu", "Quechua", "quechua");
+ ("GEAS-OBJECT-ID", "rm", "Raeto-Romance", "rhto-roman");
+ ("GEAS-OBJECT-ID", "rn", "Rundi", "rundi");
+ ("GEAS-OBJECT-ID", "ro", "Romanian", "roumain");
+ ("GEAS-OBJECT-ID", "ru", "Russian", "russe");
+ ("GEAS-OBJECT-ID", "rw", "Kinyarwanda", "rwanda");
+ ("GEAS-OBJECT-ID", "sa", "Sanskrit", "sanskrit");
+ ("GEAS-OBJECT-ID", "sd", "Sindhi", "sindhi");
+ ("GEAS-OBJECT-ID", "sg", "Sango", "sango");
+ ("GEAS-OBJECT-ID", "si", "Sinhalese", "singhalais");
+ ("GEAS-OBJECT-ID", "sk", "Slovak", "slovaque");
+ ("GEAS-OBJECT-ID", "sl", "Slovenian", "slovne");
+ ("GEAS-OBJECT-ID", "sm", "Samoan", "samoan");
+ ("GEAS-OBJECT-ID", "sn", "Shona", "shona");
+ ("GEAS-OBJECT-ID", "so", "Somali", "somali");
+ ("GEAS-OBJECT-ID", "sq", "Albanian", "albanais");
+ ("GEAS-OBJECT-ID", "sr", "Serbian", "serbe");
+ ("GEAS-OBJECT-ID", "ss", "Swati", "swati");
+ ("GEAS-OBJECT-ID", "st", "Sotho", "sotho");
+ ("GEAS-OBJECT-ID", "su", "Sundanese", "soundanais");
+ ("GEAS-OBJECT-ID", "sv", "Swedish", "sudois");
+ ("GEAS-OBJECT-ID", "sw", "Swahili", "swahili");
+ ("GEAS-OBJECT-ID", "ta", "Tamil", "tamoul");
+ ("GEAS-OBJECT-ID", "te", "Telugu", "tlougou");
+ ("GEAS-OBJECT-ID", "tg", "Tajik", "tadjik");
+ ("GEAS-OBJECT-ID", "th", "Thai", "tha");
+ ("GEAS-OBJECT-ID", "ti", "Tigrinya", "tigrigna");
+ ("GEAS-OBJECT-ID", "tk", "Turkmen", "turkmne");
+ ("GEAS-OBJECT-ID", "tl", "Tagalog", "tagalog");
+ ("GEAS-OBJECT-ID", "tn", "Tswana", "tswana");
+ ("GEAS-OBJECT-ID", "to", "Tonga", "tongan");
+ ("GEAS-OBJECT-ID", "tr", "Turkish", "turc");
+ ("GEAS-OBJECT-ID", "ts", "Tsonga", "tsonga");
+ ("GEAS-OBJECT-ID", "tt", "Tatar", "tatar");
+ ("GEAS-OBJECT-ID", "tw", "Twi", "twi");
+ ("GEAS-OBJECT-ID", "ug", "Uighur", "ougour");
+ ("GEAS-OBJECT-ID", "uk", "Ukrainian", "ukrainien");
+ ("GEAS-OBJECT-ID", "ur", "Urdu", "ourdou");
+ ("GEAS-OBJECT-ID", "uz", "Uzbek", "ouszbek");
+ ("GEAS-OBJECT-ID", "vi", "Vietnamese", "vietnamien");
+ ("GEAS-OBJECT-ID", "vo", "Volapk", "volapk");
+ ("GEAS-OBJECT-ID", "wo", "Wolof", "wolof");
+ ("GEAS-OBJECT-ID", "xh", "Xhosa", "xhosa");
+ ("GEAS-OBJECT-ID", "y", "Yiddish", "yiddish");
+ ("GEAS-OBJECT-ID", "yo", "Yoruba", "yoruba");
+ ("GEAS-OBJECT-ID", "za", "Zhuang", "zhuang");
+ ("GEAS-OBJECT-ID", "zh", "Chinese", "chinois");
+ ("GEAS-OBJECT-ID", "zu", "Zulu", "zoulou");
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.2
gnue/gnue-config/base/location/defaults/insert-en-country-codes.sql:1.3
--- gnue/gnue-config/base/location/defaults/insert-en-country-codes.sql:1.2
Thu Jul 5 19:36:42 2001
+++ gnue/gnue-config/base/location/defaults/insert-en-country-codes.sql Fri Jul
6 18:23:41 2001
@@ -2,301 +2,263 @@
#
# ISO country and telephone codes
#
-# $Id: insert-en-country-codes.sql,v 1.2 2001/07/06 02:36:42 ntiffin Exp $
+# This is a special file format that is converted by the
+# GEAS sql loader into valid sql
#
+# $Id: insert-en-country-codes.sql,v 1.3 2001/07/07 01:23:41 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")
-;
+INSERT INTO location__country (objectid, description, phone_code, code) VALUES
+ ("GEAS-OBJECT-ID", "Afghanistan", "", "AF");
+ ("GEAS-OBJECT-ID", "Albania", "355", "AL");
+ ("GEAS-OBJECT-ID", "Algeria", "213", "AG");
+ ("GEAS-OBJECT-ID", "American Samoa", "684", "");
+ ("GEAS-OBJECT-ID", "Andorra", "376", "AN");
+ ("GEAS-OBJECT-ID", "Angola", "244", "AO");
+ ("GEAS-OBJECT-ID", "Anguilla", "1", "AV");
+ ("GEAS-OBJECT-ID", "Antarctica", "672", "AY");
+ ("GEAS-OBJECT-ID", "Antigua Barbuda", "1", "AC");
+ ("GEAS-OBJECT-ID", "Argentina", "54", "AR");
+ ("GEAS-OBJECT-ID", "Armenia", "374", "AM");
+ ("GEAS-OBJECT-ID", "Aruba", "297", "AA");
+ ("GEAS-OBJECT-ID", "Ashmore and Cartier Islands", "", "AT");
+ ("GEAS-OBJECT-ID", "Ascension Island", "247", "");
+ ("GEAS-OBJECT-ID", "Australia", "61", "AS");
+ ("GEAS-OBJECT-ID", "Austria", "43", "AU");
+ ("GEAS-OBJECT-ID", "Azerbaijan", "994", "AJ");
+ ("GEAS-OBJECT-ID", "Bahamas", "1", "BF");
+ ("GEAS-OBJECT-ID", "Bahrain", "973", "BA");
+ ("GEAS-OBJECT-ID", "Bangladesh", "880", "BG");
+ ("GEAS-OBJECT-ID", "Barbados", "1", "BB");
+ ("GEAS-OBJECT-ID", "Belarus", "375", "BO");
+ ("GEAS-OBJECT-ID", "Belgium", "32", "BE");
+ ("GEAS-OBJECT-ID", "Belize", "501", "BH");
+ ("GEAS-OBJECT-ID", "Benin", "229", "BN");
+ ("GEAS-OBJECT-ID", "Bermuda", "441", "BD");
+ ("GEAS-OBJECT-ID", "Bhutan", "975", "BT");
+ ("GEAS-OBJECT-ID", "Bolivia", "591", "BL");
+ ("GEAS-OBJECT-ID", "Bosnia Herzegovina", "387", "BK");
+ ("GEAS-OBJECT-ID", "Botswana", "267", "BC");
+ ("GEAS-OBJECT-ID", "Brazil", "55", "BR");
+ ("GEAS-OBJECT-ID", "British Indian Ocean Territory", "", "IO");
+ ("GEAS-OBJECT-ID", "British Virgin Islands", "1", "VI");
+ ("GEAS-OBJECT-ID", "Brunei", "673", "BX");
+ ("GEAS-OBJECT-ID", "Bulgaria", "359", "BU");
+ ("GEAS-OBJECT-ID", "Burkina Faso", "226", "UV");
+ ("GEAS-OBJECT-ID", "Burundi", "257", "BY");
+ ("GEAS-OBJECT-ID", "Cambodia", "855", "CB");
+ ("GEAS-OBJECT-ID", "Cameroon", "237", "CM");
+ ("GEAS-OBJECT-ID", "Canada", "1", "CA");
+ ("GEAS-OBJECT-ID", "Cape Verde Islands", "238", "CV");
+ ("GEAS-OBJECT-ID", "Cayman Islands", "1", "CJ");
+ ("GEAS-OBJECT-ID", "Central African Republic", "236", "CT");
+ ("GEAS-OBJECT-ID", "Chad Republic", "235", "CD");
+ ("GEAS-OBJECT-ID", "Chatham Island", "64", "");
+ ("GEAS-OBJECT-ID", "Chile", "56", "CI");
+ ("GEAS-OBJECT-ID", "China", "86", "CH");
+ ("GEAS-OBJECT-ID", "Christmas Island", "672", "KT");
+ ("GEAS-OBJECT-ID", "Cocos (Keeling) Islands", "672", "CK");
+ ("GEAS-OBJECT-ID", "Colombia", "57", "CO");
+ ("GEAS-OBJECT-ID", "Comoros", "269", "CN");
+ ("GEAS-OBJECT-ID", "Congo", "242", "CF");
+ ("GEAS-OBJECT-ID", "Cook Islands", "682", "CW");
+ ("GEAS-OBJECT-ID", "Coral Sea Islands", "", "CR");
+ ("GEAS-OBJECT-ID", "Costa Rica", "506", "CS");
+ ("GEAS-OBJECT-ID", "Cote D'Ivoire", "", "IV");
+ ("GEAS-OBJECT-ID", "Croatia", "385", "HR");
+ ("GEAS-OBJECT-ID", "Cuba", "53", "CU");
+ ("GEAS-OBJECT-ID", "Cyprus", "357", "CY");
+ ("GEAS-OBJECT-ID", "Czech Republic", "42", "EZ");
+ ("GEAS-OBJECT-ID", "Denmark", "45", "DA");
+ ("GEAS-OBJECT-ID", "Diego Garcia", "246", "");
+ ("GEAS-OBJECT-ID", "Djibouti", "253", "DJ");
+ ("GEAS-OBJECT-ID", "Dominica", "1", "DO");
+ ("GEAS-OBJECT-ID", "Dominican Republic", "1", "DR");
+ ("GEAS-OBJECT-ID", "Ecuador", "593", "EC");
+ ("GEAS-OBJECT-ID", "Egypt", "20", "EG");
+ ("GEAS-OBJECT-ID", "El Salvador", "503", "ES");
+ ("GEAS-OBJECT-ID", "Equatorial Guinea", "240", "EK");
+ ("GEAS-OBJECT-ID", "Eritrea", "291", "ER");
+ ("GEAS-OBJECT-ID", "Estonia", "372", "EN");
+ ("GEAS-OBJECT-ID", "Ethiopia", "251", "ET");
+ ("GEAS-OBJECT-ID", "Europa Island", "", "EU");
+ ("GEAS-OBJECT-ID", "Faeroe Islands", "298", "FO");
+ ("GEAS-OBJECT-ID", "Falkland Islands", "500", "FK");
+ ("GEAS-OBJECT-ID", "Fiji", "679", "FJ");
+ ("GEAS-OBJECT-ID", "Finland", "358", "FI");
+ ("GEAS-OBJECT-ID", "France", "33", "FR");
+ ("GEAS-OBJECT-ID", "French Antilles", "596", "");
+ ("GEAS-OBJECT-ID", "French Southern and Antarctic Lands", "", "FS");
+ ("GEAS-OBJECT-ID", "French Guiana", "594", "FG");
+ ("GEAS-OBJECT-ID", "French Polynesia", "689", "FP");
+ ("GEAS-OBJECT-ID", "Gabon", "241", "GB");
+ ("GEAS-OBJECT-ID", "Gaza Strip", "", "GZ");
+ ("GEAS-OBJECT-ID", "Gambia", "220", "GA");
+ ("GEAS-OBJECT-ID", "Georgia", "995", "GG");
+ ("GEAS-OBJECT-ID", "Germany", "49", "GM");
+ ("GEAS-OBJECT-ID", "Ghana", "233", "GH");
+ ("GEAS-OBJECT-ID", "Gibraltar", "350", "GI");
+ ("GEAS-OBJECT-ID", "Glorioso Islands", "", "GO");
+ ("GEAS-OBJECT-ID", "Greece", "30", "GR");
+ ("GEAS-OBJECT-ID", "Greenland", "299", "GL");
+ ("GEAS-OBJECT-ID", "Grenada", "1", "GJ");
+ ("GEAS-OBJECT-ID", "Guadeloupe", "590", "GP");
+ ("GEAS-OBJECT-ID", "Guam", "671", "");
+ ("GEAS-OBJECT-ID", "Guatemala", "502", "GT");
+ ("GEAS-OBJECT-ID", "Guinea", "224", "GV");
+ ("GEAS-OBJECT-ID", "Guinea-Bissau", "245", "PU");
+ ("GEAS-OBJECT-ID", "Guyana", "592", "GY");
+ ("GEAS-OBJECT-ID", "Haiti", "509", "HA");
+ ("GEAS-OBJECT-ID", "Heard and McDonald Islands", "", "HM");
+ ("GEAS-OBJECT-ID", "Honduras", "504", "HO");
+ ("GEAS-OBJECT-ID", "Hong Kong", "852", "HK");
+ ("GEAS-OBJECT-ID", "Hungary", "36", "HU");
+ ("GEAS-OBJECT-ID", "Iceland", "354", "IC");
+ ("GEAS-OBJECT-ID", "India", "91", "IN");
+ ("GEAS-OBJECT-ID", "Indonesia", "62", "ID");
+ ("GEAS-OBJECT-ID", "Iran", "98", "IR");
+ ("GEAS-OBJECT-ID", "Iraq", "964", "IZ");
+ ("GEAS-OBJECT-ID", "Ireland", "353", "EI");
+ ("GEAS-OBJECT-ID", "Isle of Man", "", "IM");
+ ("GEAS-OBJECT-ID", "Israel", "972", "IS");
+ ("GEAS-OBJECT-ID", "Italy", "39", "IT");
+ ("GEAS-OBJECT-ID", "Ivory Coast", "225", "");
+ ("GEAS-OBJECT-ID", "Jamaica", "1", "JM");
+ ("GEAS-OBJECT-ID", "Jan Mayen", "", "JN");
+ ("GEAS-OBJECT-ID", "Japan", "81", "JA");
+ ("GEAS-OBJECT-ID", "Jersey", "", "JE");
+ ("GEAS-OBJECT-ID", "Jordan", "962", "JO");
+ ("GEAS-OBJECT-ID", "Juan de Nova Island", "", "JU");
+ ("GEAS-OBJECT-ID", "Kazakhstan", "7", "KZ");
+ ("GEAS-OBJECT-ID", "Kenya", "254", "KE");
+ ("GEAS-OBJECT-ID", "Kingman Reef", "", "KQ");
+ ("GEAS-OBJECT-ID", "Kiribati", "686", "");
+ ("GEAS-OBJECT-ID", "Korea, Democratic People's Republic of", "850", "KN");
+ ("GEAS-OBJECT-ID", "Korea, Republic of", "82", "KS");
+ ("GEAS-OBJECT-ID", "Kuwait", "965", "KU");
+ ("GEAS-OBJECT-ID", "Kyrgyzstan", "7", "KG");
+ ("GEAS-OBJECT-ID", "Laos", "856", "LA");
+ ("GEAS-OBJECT-ID", "Latvia", "371", "LG");
+ ("GEAS-OBJECT-ID", "Lebanon", "961", "LE");
+ ("GEAS-OBJECT-ID", "Lesotho", "266", "LT");
+ ("GEAS-OBJECT-ID", "Liberia", "231", "LI");
+ ("GEAS-OBJECT-ID", "Libya", "218", "LY");
+ ("GEAS-OBJECT-ID", "Liechtenstein", "4175", "LS");
+ ("GEAS-OBJECT-ID", "Lithuania", "370", "LH");
+ ("GEAS-OBJECT-ID", "Luxembourg", "352", "LU");
+ ("GEAS-OBJECT-ID", "Macao", "853", "MC");
+ ("GEAS-OBJECT-ID", "Macedonia", "389", "MK");
+ ("GEAS-OBJECT-ID", "Madagascar", "261", "MA");
+ ("GEAS-OBJECT-ID", "Malawi", "265", "MI");
+ ("GEAS-OBJECT-ID", "Malaysia", "60", "MY");
+ ("GEAS-OBJECT-ID", "Maldives", "960", "MV");
+ ("GEAS-OBJECT-ID", "Mali", "223", "ML");
+ ("GEAS-OBJECT-ID", "Malta", "356", "MT");
+ ("GEAS-OBJECT-ID", "Marshall Islands", "692", "");
+ ("GEAS-OBJECT-ID", "Martinique", "596", "MB");
+ ("GEAS-OBJECT-ID", "Mauritania", "222", "MR");
+ ("GEAS-OBJECT-ID", "Mauritius", "230", "MP");
+ ("GEAS-OBJECT-ID", "Mayotte Islands", "2696", "MF");
+ ("GEAS-OBJECT-ID", "Mexico", "52", "MX");
+ ("GEAS-OBJECT-ID", "Micronesia", "691", "");
+ ("GEAS-OBJECT-ID", "Moldova", "373", "MD");
+ ("GEAS-OBJECT-ID", "Monaco", "377", "MN");
+ ("GEAS-OBJECT-ID", "Mongolia", "976", "MG");
+ ("GEAS-OBJECT-ID", "Montenegro", "", "MW");
+ ("GEAS-OBJECT-ID", "Montserrat", "1", "MH");
+ ("GEAS-OBJECT-ID", "Morocco", "212", "MO");
+ ("GEAS-OBJECT-ID", "Mozambique", "258", "MZ");
+ ("GEAS-OBJECT-ID", "Myanmar", "95", "");
+ ("GEAS-OBJECT-ID", "Namibia", "264", "WA");
+ ("GEAS-OBJECT-ID", "Nauru", "674", "NR");
+ ("GEAS-OBJECT-ID", "Nepal", "977", "NP");
+ ("GEAS-OBJECT-ID", "Netherlands", "31", "NL");
+ ("GEAS-OBJECT-ID", "Netherlands Antilles", "599", "NT");
+ ("GEAS-OBJECT-ID", "New Caledonia", "687", "NC");
+ ("GEAS-OBJECT-ID", "New Zealand", "64", "NZ");
+ ("GEAS-OBJECT-ID", "Nicaragua", "505", "NU");
+ ("GEAS-OBJECT-ID", "Niger", "227", "NG");
+ ("GEAS-OBJECT-ID", "Nigeria", "234", "NI");
+ ("GEAS-OBJECT-ID", "Niue", "683", "NE");
+ ("GEAS-OBJECT-ID", "Norfolk Island", "672", "NF");
+ ("GEAS-OBJECT-ID", "Norway", "47", "NO");
+ ("GEAS-OBJECT-ID", "Oman", "968", "MU");
+ ("GEAS-OBJECT-ID", "Pakistan", "92", "PK");
+ ("GEAS-OBJECT-ID", "Palau", "680", "");
+ ("GEAS-OBJECT-ID", "Panama", "507", "PM");
+ ("GEAS-OBJECT-ID", "Papua New Guinea", "675", "PP");
+ ("GEAS-OBJECT-ID", "Paracel Islands", "", "PF");
+ ("GEAS-OBJECT-ID", "Paraguay", "595", "PA");
+ ("GEAS-OBJECT-ID", "Peru", "51", "PE");
+ ("GEAS-OBJECT-ID", "Philippines", "63", "RP");
+ ("GEAS-OBJECT-ID", "Pitcairn Islands", "", "PC");
+ ("GEAS-OBJECT-ID", "Poland", "48", "PL");
+ ("GEAS-OBJECT-ID", "Portugal", "351", "PO");
+ ("GEAS-OBJECT-ID", "Qatar", "974", "QA");
+ ("GEAS-OBJECT-ID", "Reunion", "262", "RE");
+ ("GEAS-OBJECT-ID", "Romania", "40", "RO");
+ ("GEAS-OBJECT-ID", "Russia", "7", "RS");
+ ("GEAS-OBJECT-ID", "Rwanda", "250", "RW");
+ ("GEAS-OBJECT-ID", "Saipan", "670", "");
+ ("GEAS-OBJECT-ID", "San Marino", "378", "SM");
+ ("GEAS-OBJECT-ID", "Sao Tome and Principe", "239", "TP");
+ ("GEAS-OBJECT-ID", "Saudi Arabia", "966", "SA");
+ ("GEAS-OBJECT-ID", "Senegal", "221", "SG");
+ ("GEAS-OBJECT-ID", "Seychelles", "248", "SE");
+ ("GEAS-OBJECT-ID", "Sierra Leone", "232", "SL");
+ ("GEAS-OBJECT-ID", "Singapore", "65", "SN");
+ ("GEAS-OBJECT-ID", "Slovak Republic", "42", "LO");
+ ("GEAS-OBJECT-ID", "Slovenia", "386", "SI");
+ ("GEAS-OBJECT-ID", "Solomon Islands", "677", "BP");
+ ("GEAS-OBJECT-ID", "Somalia", "252", "SO");
+ ("GEAS-OBJECT-ID", "South Africa", "27", "SF");
+ ("GEAS-OBJECT-ID", "South Georgia and South Sandwich Islands", "",
"SX");
+ ("GEAS-OBJECT-ID", "Spain", "34", "SP");
+ ("GEAS-OBJECT-ID", "Spratly Islands", "", "PG");
+ ("GEAS-OBJECT-ID", "Sri Lanka", "94", "CE");
+ ("GEAS-OBJECT-ID", "St. Helena", "290", "SH");
+ ("GEAS-OBJECT-ID", "St. Kitts and Nevis", "1", "SC");
+ ("GEAS-OBJECT-ID", "St. Lucia", "1", "ST");
+ ("GEAS-OBJECT-ID", "St. Pierre and Miquelon", "508", "SB");
+ ("GEAS-OBJECT-ID", "St. Vincent and the Grenadines", "1", "VC");
+ ("GEAS-OBJECT-ID", "Sudan", "", "SU");
+ ("GEAS-OBJECT-ID", "Svalbard", "", "SV");
+ ("GEAS-OBJECT-ID", "Suriname", "597", "NS");
+ ("GEAS-OBJECT-ID", "Swaziland", "268", "WZ");
+ ("GEAS-OBJECT-ID", "Sweden", "46", "SW");
+ ("GEAS-OBJECT-ID", "Switzerland", "41", "SZ");
+ ("GEAS-OBJECT-ID", "Syria", "963", "SY");
+ ("GEAS-OBJECT-ID", "Taiwan", "886", "TW");
+ ("GEAS-OBJECT-ID", "Tajikistan", "7", "TI");
+ ("GEAS-OBJECT-ID", "Tanzania", "255", "TZ");
+ ("GEAS-OBJECT-ID", "Thailand", "66", "TH");
+ ("GEAS-OBJECT-ID", "Togo", "228", "TO");
+ ("GEAS-OBJECT-ID", "Tokelau", "", "TL");
+ ("GEAS-OBJECT-ID", "Tonga Islands", "676", "");
+ ("GEAS-OBJECT-ID", "Trinidad and Tobago", "1", "TD");
+ ("GEAS-OBJECT-ID", "Tromelin Island", "", "TD");
+ ("GEAS-OBJECT-ID", "Tunisia", "216", "TS");
+ ("GEAS-OBJECT-ID", "Turkey", "90", "TU");
+ ("GEAS-OBJECT-ID", "Turkmenistan", "7", "TX");
+ ("GEAS-OBJECT-ID", "Turks and Caicos Islands", "1", "TK");
+ ("GEAS-OBJECT-ID", "Tuvalu", "688", "TV");
+ ("GEAS-OBJECT-ID", "Uganda", "256", "UG");
+ ("GEAS-OBJECT-ID", "Ukraine", "380", "UP");
+ ("GEAS-OBJECT-ID", "United Arab Emirates", "971", "TC");
+ ("GEAS-OBJECT-ID", "United Kingdom", "44", "UK");
+ ("GEAS-OBJECT-ID", "United States", "1", "US");
+ ("GEAS-OBJECT-ID", "Uruguay", "598", "UY");
+ ("GEAS-OBJECT-ID", "Uzbekistan", "7", "UZ");
+ ("GEAS-OBJECT-ID", "Vanuatu", "678", "NH");
+ ("GEAS-OBJECT-ID", "Vatican City", "", "VT");
+ ("GEAS-OBJECT-ID", "Venezuela", "58", "VE");
+ ("GEAS-OBJECT-ID", "Vietnam", "84", "VM");
+ ("GEAS-OBJECT-ID", "Wallis and Futuna", "681", "WF");
+ ("GEAS-OBJECT-ID", "West Bank", "", "WE");
+ ("GEAS-OBJECT-ID", "Western Sahara", "", "WI");
+ ("GEAS-OBJECT-ID", "Western Samoa", "685", "WS");
+ ("GEAS-OBJECT-ID", "Yemen", "967", "");
+ ("GEAS-OBJECT-ID", "Yugoslavia", "967", "");
+ ("GEAS-OBJECT-ID", "Zaire", "243", "CG");
+ ("GEAS-OBJECT-ID", "Zambia", "260", "ZA");
+ ("GEAS-OBJECT-ID", "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.2
gnue/gnue-config/base/location/defaults/insert-en-us-states.sql:1.3
--- gnue/gnue-config/base/location/defaults/insert-en-us-states.sql:1.2 Thu Jul
5 19:36:42 2001
+++ gnue/gnue-config/base/location/defaults/insert-en-us-states.sql Fri Jul
6 18:23:41 2001
@@ -2,83 +2,85 @@
#
# United States and Canada region (state) codes
#
-# $Id: insert-en-us-states.sql,v 1.2 2001/07/06 02:36:42 ntiffin Exp $
+# This is a special file format that is converted by the
+# GEAS sql loader into valid sql
#
+# $Id: insert-en-us-states.sql,v 1.3 2001/07/07 01:23:41 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")
-;
+INSERT into region (objectid, desc, code, country) VALUES
+ ("GEAS-OBJECT-ID", "Alabama", "AL", "US");
+ ("GEAS-OBJECT-ID", "Alaska", "AK", "US");
+ ("GEAS-OBJECT-ID", "American Samoa", "AS", "US");
+ ("GEAS-OBJECT-ID", "Arizona", "AZ", "US");
+ ("GEAS-OBJECT-ID", "Arkansas", "AR", "US");
+ ("GEAS-OBJECT-ID", "California", "CA", "US");
+ ("GEAS-OBJECT-ID", "Colorado", "CO", "US");
+ ("GEAS-OBJECT-ID", "Connecticut", "CT", "US");
+ ("GEAS-OBJECT-ID", "Delaware", "DE", "US");
+ ("GEAS-OBJECT-ID", "District of Columbia", "DC", "US");
+ ("GEAS-OBJECT-ID", "Federated States of Micronesia", "FM", "US");
+ ("GEAS-OBJECT-ID", "Florida", "FL", "US");
+ ("GEAS-OBJECT-ID", "Georgia", "GA", "US");
+ ("GEAS-OBJECT-ID", "Guam", "GU", "US");
+ ("GEAS-OBJECT-ID", "Hawaii", "HI", "US");
+ ("GEAS-OBJECT-ID", "Idaho", "ID", "US");
+ ("GEAS-OBJECT-ID", "Illinois", "IL", "US");
+ ("GEAS-OBJECT-ID", "Indiana", "IN", "US");
+ ("GEAS-OBJECT-ID", "Iowa", "IA", "US");
+ ("GEAS-OBJECT-ID", "Kansas", "KS", "US");
+ ("GEAS-OBJECT-ID", "Kentucky", "KY", "US");
+ ("GEAS-OBJECT-ID", "Louisiana", "LA", "US");
+ ("GEAS-OBJECT-ID", "Maine", "ME", "US");
+ ("GEAS-OBJECT-ID", "Marshall Islands", "MH", "US");
+ ("GEAS-OBJECT-ID", "Maryland", "MD", "US");
+ ("GEAS-OBJECT-ID", "Massachusetts", "MA", "US");
+ ("GEAS-OBJECT-ID", "Michigan", "MI", "US");
+ ("GEAS-OBJECT-ID", "Minnesota", "MN", "US");
+ ("GEAS-OBJECT-ID", "Mississippi", "MS", "US");
+ ("GEAS-OBJECT-ID", "Missouri", "MO", "US");
+ ("GEAS-OBJECT-ID", "Montana", "MT", "US");
+ ("GEAS-OBJECT-ID", "Nebraska", "NE", "US");
+ ("GEAS-OBJECT-ID", "Nevada", "NV", "US");
+ ("GEAS-OBJECT-ID", "New Hampshire", "NH", "US");
+ ("GEAS-OBJECT-ID", "New Jersey", "NJ", "US");
+ ("GEAS-OBJECT-ID", "New Mexico", "NM", "US");
+ ("GEAS-OBJECT-ID", "New York", "NY", "US");
+ ("GEAS-OBJECT-ID", "North Carolina", "NC", "US");
+ ("GEAS-OBJECT-ID", "North Dakota", "ND", "US");
+ ("GEAS-OBJECT-ID", "Northern Mariana Islands", "MP", "US");
+ ("GEAS-OBJECT-ID", "Ohio", "OH", "US");
+ ("GEAS-OBJECT-ID", "Oklahoma", "OK", "US");
+ ("GEAS-OBJECT-ID", "Oregon", "OR", "US");
+ ("GEAS-OBJECT-ID", "Palau", "PW", "US");
+ ("GEAS-OBJECT-ID", "Pennsylvania", "PA", "US");
+ ("GEAS-OBJECT-ID", "Puerto Rico", "PR", "US");
+ ("GEAS-OBJECT-ID", "Rhode Island", "RI", "US");
+ ("GEAS-OBJECT-ID", "South Carolina", "SC", "US");
+ ("GEAS-OBJECT-ID", "South Dakota", "SD", "US");
+ ("GEAS-OBJECT-ID", "Tennessee", "TN", "US");
+ ("GEAS-OBJECT-ID", "Texas", "TX", "US");
+ ("GEAS-OBJECT-ID", "US Minor Outlying Islands", "UM", "US");
+ ("GEAS-OBJECT-ID", "US Virgin Islands", "VI", "US");
+ ("GEAS-OBJECT-ID", "Utah", "UT", "US");
+ ("GEAS-OBJECT-ID", "Vermont", "VT", "US");
+ ("GEAS-OBJECT-ID", "Virginia", "VA", "US");
+ ("GEAS-OBJECT-ID", "Washington", "WA", "US");
+ ("GEAS-OBJECT-ID", "West Virginia", "WV", "US");
+ ("GEAS-OBJECT-ID", "Wisconsin", "WI", "US");
+ ("GEAS-OBJECT-ID", "Wyoming", "WY", "US");
+ ("GEAS-OBJECT-ID", "Alberta", "AB", "CA");
+ ("GEAS-OBJECT-ID", "British Columbia", "BC", "CA");
+ ("GEAS-OBJECT-ID", "Manitoba", "MB", "CA");
+ ("GEAS-OBJECT-ID", "New Brunswick", "NB", "CA");
+ ("GEAS-OBJECT-ID", "Newfoundland", "NF", "CA");
+ ("GEAS-OBJECT-ID", "Northwest Territories", "NT", "CA");
+ ("GEAS-OBJECT-ID", "Nova Scotia", "NS", "CA");
+ ("GEAS-OBJECT-ID", "Ontario", "ON", "CA");
+ ("GEAS-OBJECT-ID", "Prince Edward Island", "PE", "CA");
+ ("GEAS-OBJECT-ID", "Quebec", "PQ", "CA");
+ ("GEAS-OBJECT-ID", "Saskatchewan", "SK", "CA");
+ ("GEAS-OBJECT-ID", "Yukon Territory", "YT", "CA");
+ ("GEAS-OBJECT-ID", "Armed Forces Europe, the Middle East and Canada", "AE",
"US");
+ ("GEAS-OBJECT-ID", "Armed Forces Pacific", "AP", "US");
+ ("GEAS-OBJECT-ID", "Armed Forces", "AA", "US");
Index: gnue/gnue-config/base/person/defaults/insert-en-person-type.sql
diff -u gnue/gnue-config/base/person/defaults/insert-en-person-type.sql:1.3
gnue/gnue-config/base/person/defaults/insert-en-person-type.sql:1.4
--- gnue/gnue-config/base/person/defaults/insert-en-person-type.sql:1.3 Fri Jul
6 10:45:31 2001
+++ gnue/gnue-config/base/person/defaults/insert-en-person-type.sql Fri Jul
6 18:23:41 2001
@@ -1,5 +1,14 @@
-INSERT INTO "person__comm_type" (objectid, code, "desc") VALUES
('73a0a74c634a11d59bc30010a4d16fa6','EM', 'Employee');
-INSERT INTO "person__comm_type" (objectid, code, "desc") VALUES
('73a0a74c634a11d59bc30010a4d16fd6''CO', 'Contractor');
-INSERT INTO "person__comm_type" (objectid, code, "desc") VALUES
('73a0a74c634a11d59bc30010a4d16ff6','CU', 'Customer');
-INSERT INTO "person__comm_type" (objectid, code, "desc") VALUES
('73a0a74c634a11d59bc30010a4d16ft6','VE', 'Vendor');
-INSERT INTO "person__comm_type" (objectid, code, "desc") VALUES
('73a0a74c634a11d59bc30010a4d16fs4','SL', 'Sales Lead');
+
+#
+# This is a special file format that is converted by the
+# GEAS sql loader into valid sql
+#
+# $Id: insert-en-person-type.sql,v 1.4 2001/07/07 01:23:41 ntiffin Exp $
+#
+
+INSERT INTO "person__comm_type" (objectid, code, desc) VALUES
+ ('GEAS-OBJECT-ID', 'EM', 'Employee');
+ ('GEAS-OBJECT-ID', 'CO', 'Contractor');
+ ('GEAS-OBJECT-ID', 'CU', 'Customer');
+ ('GEAS-OBJECT-ID', 'VE', 'Vendor');
+ ('GEAS-OBJECT-ID', 'SL', 'Sales Lead');
Index: gnue/gnue-config/base/person/defaults/insert-en-salutations.sql
diff -u gnue/gnue-config/base/person/defaults/insert-en-salutations.sql:1.4
gnue/gnue-config/base/person/defaults/insert-en-salutations.sql:1.5
--- gnue/gnue-config/base/person/defaults/insert-en-salutations.sql:1.4 Fri Jul
6 10:45:31 2001
+++ gnue/gnue-config/base/person/defaults/insert-en-salutations.sql Fri Jul
6 18:23:41 2001
@@ -1,13 +1,22 @@
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('60161cac634a11d59bc30010a4d16fc6','Doctor');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('7388d086634a11d59bc30010a4d16fc6','Dr');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('738bf9be634a11d59bc30010a4d16fc6','Heer');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('738f3368634a11d59bc30010a4d16fc6','Herr');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('7392f8b8634a11d59bc30010a4d16fc6','Miss');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('7396b304634a11d59bc30010a4d16fc6','Mister');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('739a0766634a11d59bc30010a4d16fc6','Monsieur');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('739d493a634a11d59bc30010a4d16fc6','Mr');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('73a0a74c634a11d59bc30010a4d16fc6','Mrs');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('73a4784a634a11d59bc30010a4d16fc6','Ms');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('73a7b4ba634a11d59bc30010a4d16fc6','Professor');
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
('73aaf6e8634a11d59bc30010a4d16fc6','Sir');
+
+#
+# This is a special file format that is converted by the
+# GEAS sql loader into valid sql
+#
+# $Id: insert-en-salutations.sql,v 1.5 2001/07/07 01:23:41 ntiffin Exp $
+#
+
+INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
+ ('GEAS-OBJECT-ID','Doctor');
+ ('GEAS-OBJECT-ID','Dr');
+ ('GEAS-OBJECT-ID','Heer');
+ ('GEAS-OBJECT-ID','Herr');
+ ('GEAS-OBJECT-ID','Miss');
+ ('GEAS-OBJECT-ID','Mister');
+ ('GEAS-OBJECT-ID','Monsieur');
+ ('GEAS-OBJECT-ID','Mr');
+ ('GEAS-OBJECT-ID','Mrs');
+ ('GEAS-OBJECT-ID','Ms');
+ ('GEAS-OBJECT-ID','Professor');
+ ('GEAS-OBJECT-ID','Sir');