[Gforge-commits] gforge/db 20040325.sql, 1.1, 1.2 ccodes.txt, 1.1, NONE

[cbayle]

Update of /cvsroot/gforge/gforge/db
In directory db.perdue.net:/tmp/cvs-serv11348

Modified Files:
        20040325.sql 
Removed Files:
        ccodes.txt 
Log Message:
Introduce ccodes.txt in 20040325.sql as COPY to stdin


Index: 20040325.sql
===================================================================
RCS file: /cvsroot/gforge/gforge/db/20040325.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- 20040325.sql        25 Mar 2004 17:19:58 -0000      1.1
+++ 20040325.sql        25 Mar 2004 22:11:20 -0000      1.2
@@ -10,5 +10,245 @@
 ccode char(2) primary key
 );
 
-COPY country_code FROM '/tmp/ccodes.txt';
+COPY "country_code"  FROM stdin;
+AFGHANISTAN    AF
+ALBANIA        AL
+ALGERIA        DZ
+AMERICAN SAMOA AS
+ANDORRA        AD
+ANGOLA AO
+ANGUILLA       AI
+ANTARCTICA     AQ
+ANTIGUA AND BARBUDA    AG
+ARGENTINA      AR
+ARMENIA        AM
+ARUBA  AW
+AUSTRALIA      AU
+AUSTRIA        AT
+AZERBAIJAN     AZ
+BAHAMAS        BS
+BAHRAIN        BH
+BANGLADESH     BD
+BARBADOS       BB
+BELARUS        BY
+BELGIUM        BE
+BELIZE BZ
+BENIN  BJ
+BERMUDA        BM
+BHUTAN BT
+BOLIVIA        BO
+BOSNIA AND HERZEGOVINA BA
+BOTSWANA       BW
+BOUVET ISLAND  BV
+BRAZIL BR
+BRITISH INDIAN OCEAN TERRITORY IO
+BRUNEI DARUSSALAM      BN
+BULGARIA       BG
+BURKINA FASO   BF
+BURUNDI        BI
+CAMBODIA       KH
+CAMEROON       CM
+CANADA CA
+CAPE VERDE     CV
+CAYMAN ISLANDS KY
+CENTRAL AFRICAN REPUBLIC       CF
+CHAD   TD
+CHILE  CL
+CHINA  CN
+CHRISTMAS ISLAND       CX
+COCOS (KEELING) ISLANDS        CC
+COLOMBIA       CO
+COMOROS        KM
+CONGO  CG
+CONGO, THE DEMOCRATIC REPUBLIC OF THE  CD
+COOK ISLANDS   CK
+COSTA RICA     CR
+COTE D'IVOIRE  CI
+CROATIA        HR
+CUBA   CU
+CYPRUS CY
+CZECH REPUBLIC CZ
+DENMARK        DK
+DJIBOUTI       DJ
+DOMINICA       DM
+DOMINICAN REPUBLIC     DO
+EAST TIMOR     TP
+ECUADOR        EC
+EGYPT  EG
+EL SALVADOR    SV
+EQUATORIAL GUINEA      GQ
+ERITREA        ER
+ESTONIA        EE
+ETHIOPIA       ET
+FALKLAND ISLANDS (MALVINAS)    FK
+FAROE ISLANDS  FO
+FIJI   FJ
+FINLAND        FI
+FRANCE FR
+FRENCH GUIANA  GF
+FRENCH POLYNESIA       PF
+FRENCH SOUTHERN TERRITORIES    TF
+GABON  GA
+GAMBIA GM
+GEORGIA        GE
+GERMANY        DE
+GHANA  GH
+GIBRALTAR      GI
+GREECE GR
+GREENLAND      GL
+GRENADA        GD
+GUADELOUPE     GP
+GUAM   GU
+GUATEMALA      GT
+GUINEA GN
+GUINEA-BISSAU  GW
+GUYANA GY
+HAITI  HT
+HEARD ISLAND AND MCDONALD ISLANDS      HM
+HOLY SEE (VATICAN CITY STATE)  VA
+HONDURAS       HN
+HONG KONG      HK
+HUNGARY        HU
+ICELAND        IS
+INDIA  IN
+INDONESIA      ID
+IRAN, ISLAMIC REPUBLIC OF      IR
+IRAQ   IQ
+IRELAND        IE
+ISRAEL IL
+ITALY  IT
+JAMAICA        JM
+JAPAN  JP
+JORDAN JO
+KAZAKSTAN      KZ
+KENYA  KE
+KIRIBATI       KI
+KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF KP
+KOREA, REPUBLIC OF     KR
+KUWAIT KW
+KYRGYZSTAN     KG
+LAO PEOPLE'S DEMOCRATIC REPUBLIC       LA
+LATVIA LV
+LEBANON        LB
+LESOTHO        LS
+LIBERIA        LR
+LIBYAN ARAB JAMAHIRIYA LY
+LIECHTENSTEIN  LI
+LITHUANIA      LT
+LUXEMBOURG     LU
+MACAU  MO
+MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF     MK
+MADAGASCAR     MG
+MALAWI MW
+MALAYSIA       MY
+MALDIVES       MV
+MALI   ML
+MALTA  MT
+MARSHALL ISLANDS       MH
+MARTINIQUE     MQ
+MAURITANIA     MR
+MAURITIUS      MU
+MAYOTTE        YT
+MEXICO MX
+MICRONESIA, FEDERATED STATES OF        FM
+MOLDOVA, REPUBLIC OF   MD
+MONACO MC
+MONGOLIA       MN
+MONTSERRAT     MS
+MOROCCO        MA
+MOZAMBIQUE     MZ
+MYANMAR        MM
+NAMIBIA        NA
+NAURU  NR
+NEPAL  NP
+NETHERLANDS    NL
+NETHERLANDS ANTILLES   AN
+NEW CALEDONIA  NC
+NEW ZEALAND    NZ
+NICARAGUA      NI
+NIGER  NE
+NIGERIA        NG
+NIUE   NU
+NORFOLK ISLAND NF
+NORTHERN MARIANA ISLANDS       MP
+NORWAY NO
+OMAN   OM
+PAKISTAN       PK
+PALAU  PW
+PALESTINIAN TERRITORY, OCCUPIED        PS
+PANAMA PA
+PAPUA NEW GUINEA       PG
+PARAGUAY       PY
+PERU   PE
+PHILIPPINES    PH
+PITCAIRN       PN
+POLAND PL
+PORTUGAL       PT
+PUERTO RICO    PR
+QATAR  QA
+REUNION        RE
+ROMANIA        RO
+RUSSIAN FEDERATION     RU
+RWANDA RW
+SAINT HELENA   SH
+SAINT KITTS AND NEVIS  KN
+SAINT LUCIA    LC
+SAINT PIERRE AND MIQUELON      PM
+SAINT VINCENT AND THE GRENADINES       VC
+SAMOA  WS
+SAN MARINO     SM
+SAO TOME AND PRINCIPE  ST
+SAUDI ARABIA   SA
+SENEGAL        SN
+SEYCHELLES     SC
+SIERRA LEONE   SL
+SINGAPORE      SG
+SLOVAKIA       SK
+SLOVENIA       SI
+SOLOMON ISLANDS        SB
+SOMALIA        SO
+SOUTH AFRICA   ZA
+SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS   GS
+SPAIN  ES
+SRI LANKA      LK
+SUDAN  SD
+SURINAME       SR
+SVALBARD AND JAN MAYEN SJ
+SWAZILAND      SZ
+SWEDEN SE
+SWITZERLAND    CH
+SYRIAN ARAB REPUBLIC   SY
+TAIWAN, PROVINCE OF CHINA      TW
+TAJIKISTAN     TJ
+TANZANIA, UNITED REPUBLIC OF   TZ
+THAILAND       TH
+TOGO   TG
+TOKELAU        TK
+TONGA  TO
+TRINIDAD AND TOBAGO    TT
+TUNISIA        TN
+TURKEY TR
+TURKMENISTAN   TM
+TURKS AND CAICOS ISLANDS       TC
+TUVALU TV
+UGANDA UG
+UKRAINE        UA
+UNITED ARAB EMIRATES   AE
+UNITED STATES  US
+UNITED STATES MINOR OUTLYING ISLANDS   UM
+URUGUAY        UY
+UZBEKISTAN     UZ
+VANUATU        VU
+VENEZUELA      VE
+VIET NAM       VN
+VIRGIN ISLANDS, BRITISH        VG
+VIRGIN ISLANDS, U.S.   VI
+WALLIS AND FUTUNA      WF
+WESTERN SAHARA EH
+YEMEN  YE
+YUGOSLAVIA     YU
+ZAMBIA ZM
+ZIMBABWE       ZW
+UNITED KINGDOM UK
+\.
 

--- ccodes.txt DELETED ---