[VAXman(Admin)]

Yesterday in the speakeasy, someone referred to the project to add country of origin information to the Aural Moon music library as the "FLAG PROJECT" so, for lack of a better title, it is the "FLAG PROJECT".

If you want to help, here is what is needed. Doing this all manually in SAM will take much time. It would be far easier to simply issue a script of SQL commands to update this. So, if you want to help, here is what is needed:

1. Use this table (sorted by country name):
   

   SELECT DISTINCT code, country FROM ip2country ORDER BY country ASC
   
   code	country
   AF	Afghanistan
   AX	Aland Islands
   AL	Albania
   DZ	Algeria
   AS	American Samoa
   AD	Andorra
   AO	Angola
   AI	Anguilla
   AQ	Antarctica
   AG	Antigua and Barbuda
   AR	Argentina
   AM	Armenia
   AW	Aruba
   AP	Asia/Pacific Region
   AU	Australia
   AT	Austria
   AZ	Azerbaijan
   BS	Bahamas
   BH	Bahrain
   BD	Bangladesh
   BB	Barbados
   BY	Belarus
   BE	Belgium
   BZ	Belize
   BJ	Benin
   BM	Bermuda
   BT	Bhutan
   BO	Bolivia
   BA	Bosnia and Herzegovina
   BW	Botswana
   BV	Bouvet Island
   BR	Brazil
   IO	British Indian Ocean Territory
   BN	Brunei Darussalam
   BG	Bulgaria
   BF	Burkina Faso
   BI	Burundi
   KH	Cambodia
   CM	Cameroon
   CA	Canada
   CV	Cape Verde
   KY	Cayman Islands
   CF	Central African Republic
   TD	Chad
   CL	Chile
   CN	China
   CO	Colombia
   KM	Comoros
   CG	Congo
   CD	Congo
   CK	Cook Islands
   CR	Costa Rica
   HR	Croatia
   CU	Cuba
   CY	Cyprus
   CZ	Czech Republic
   DK	Denmark
   DJ	Djibouti
   DM	Dominica
   DO	Dominican Republic
   EC	Ecuador
   EG	Egypt
   SV	El Salvador
   GQ	Equatorial Guinea
   ER	Eritrea
   EE	Estonia
   ET	Ethiopia
   EU	Europe
   FK	Falkland Islands (Malvinas)
   FO	Faroe Islands
   FJ	Fiji
   FI	Finland
   FR	France
   GF	French Guiana
   PF	French Polynesia
   GA	Gabon
   GM	Gambia
   GE	Georgia
   DE	Germany
   GH	Ghana
   GI	Gibraltar
   GR	Greece
   GL	Greenland
   GD	Grenada
   GP	Guadeloupe
   GU	Guam
   GT	Guatemala
   GG	Guernsey
   GN	Guinea
   GW	Guinea-Bissau
   GY	Guyana
   HT	Haiti
   VA	Holy See (Vatican City State)
   HN	Honduras
   HK	Hong Kong
   HU	Hungary
   IS	Iceland
   IN	India
   ID	Indonesia
   IR	Iran
   IQ	Iraq
   IE	Ireland
   IM	Isle of Man
   IL	Israel
   IT	Italy
   JM	Jamaica
   JP	Japan
   JE	Jersey
   JO	Jordan
   KZ	Kazakhstan
   KE	Kenya
   KI	Kiribati
   KP	Korea
   KR	Korea
   KW	Kuwait
   KG	Kyrgyzstan
   LV	Latvia
   LB	Lebanon
   LS	Lesotho
   LR	Liberia
   LY	Libyan Arab Jamahiriya
   LI	Liechtenstein
   LT	Lithuania
   LU	Luxembourg
   MO	Macau
   MK	Macedonia
   MG	Madagascar
   MW	Malawi
   MY	Malaysia
   MV	Maldives
   ML	Mali
   MT	Malta
   MH	Marshall Islands
   MQ	Martinique
   MR	Mauritania
   MU	Mauritius
   YT	Mayotte
   MX	Mexico
   FM	Micronesia
   MD	Moldova
   MC	Monaco
   MN	Mongolia
   ME	Montenegro
   MS	Montserrat
   MA	Morocco
   MZ	Mozambique
   MM	Myanmar
   NA	Namibia
   NR	Nauru
   NP	Nepal
   NL	Netherlands
   AN	Netherlands Antilles
   NC	New Caledonia
   NZ	New Zealand
   NI	Nicaragua
   NE	Niger
   NG	Nigeria
   NU	Niue
   NF	Norfolk Island
   MP	Northern Mariana Islands
   NO	Norway
   OM	Oman
   PK	Pakistan
   PW	Palau
   PS	Palestinian Territory
   PA	Panama
   PG	Papua New Guinea
   PY	Paraguay
   PE	Peru
   PH	Philippines
   PN	Pitcairn Islands
   PL	Poland
   PT	Portugal
   PR	Puerto Rico
   QA	Qatar
   RE	Reunion
   RO	Romania
   RU	Russian Federation
   RW	Rwanda
   KN	Saint Kitts and Nevis
   LC	Saint Lucia
   MF	Saint Martin
   PM	Saint Pierre and Miquelon
   VC	Saint Vincent and the Grenadines
   WS	Samoa
   SM	San Marino
   ST	Sao Tome and Principe
   SA	Saudi Arabia
   SN	Senegal
   RS	Serbia
   SC	Seychelles
   SL	Sierra Leone
   SG	Singapore
   SK	Slovakia
   SI	Slovenia
   SB	Solomon Islands
   SO	Somalia
   ZA	South Africa
   ES	Spain
   LK	Sri Lanka
   SD	Sudan
   SR	Suriname
   SZ	Swaziland
   SE	Sweden
   CH	Switzerland
   SY	Syrian Arab Republic
   TW	Taiwan
   TJ	Tajikistan
   TZ	Tanzania
   TH	Thailand
   TL	Timor-Leste
   TG	Togo
   TK	Tokelau
   TO	Tonga
   TT	Trinidad and Tobago
   TN	Tunisia
   TR	Turkey
   TM	Turkmenistan
   TC	Turks and Caicos Islands
   TV	Tuvalu
   UG	Uganda
   UA	Ukraine
   AE	United Arab Emirates
   GB	United Kingdom
   US	United States
   UM	United States Minor Outlying Islands
   UY	Uruguay
   UZ	Uzbekistan
   VU	Vanuatu
   VE	Venezuela
   VN	Vietnam
   VG	Virgin Islands
   VI	Virgin Islands
   WF	Wallis and Futuna
   YE	Yemen
   ZM	Zambia
   ZW	Zimbabwe

   or this one (sorted by code):
   
   

   SELECT DISTINCT code,country FROM joomla.ip2country ORDER BY code ASC
   
   code	country
   AD	Andorra
   AE	United Arab Emirates
   AF	Afghanistan
   AG	Antigua and Barbuda
   AI	Anguilla
   AL	Albania
   AM	Armenia
   AN	Netherlands Antilles
   AO	Angola
   AP	Asia/Pacific Region
   AQ	Antarctica
   AR	Argentina
   AS	American Samoa
   AT	Austria
   AU	Australia
   AW	Aruba
   AX	Aland Islands
   AZ	Azerbaijan
   BA	Bosnia and Herzegovina
   BB	Barbados
   BD	Bangladesh
   BE	Belgium
   BF	Burkina Faso
   BG	Bulgaria
   BH	Bahrain
   BI	Burundi
   BJ	Benin
   BM	Bermuda
   BN	Brunei Darussalam
   BO	Bolivia
   BR	Brazil
   BS	Bahamas
   BT	Bhutan
   BV	Bouvet Island
   BW	Botswana
   BY	Belarus
   BZ	Belize
   CA	Canada
   CD	Congo
   CF	Central African Republic
   CG	Congo
   CH	Switzerland
   CK	Cook Islands
   CL	Chile
   CM	Cameroon
   CN	China
   CO	Colombia
   CR	Costa Rica
   CU	Cuba
   CV	Cape Verde
   CY	Cyprus
   CZ	Czech Republic
   DE	Germany
   DJ	Djibouti
   DK	Denmark
   DM	Dominica
   DO	Dominican Republic
   DZ	Algeria
   EC	Ecuador
   EE	Estonia
   EG	Egypt
   ER	Eritrea
   ES	Spain
   ET	Ethiopia
   EU	Europe
   FI	Finland
   FJ	Fiji
   FK	Falkland Islands (Malvinas)
   FM	Micronesia
   FO	Faroe Islands
   FR	France
   GA	Gabon
   GB	United Kingdom
   GD	Grenada
   GE	Georgia
   GF	French Guiana
   GG	Guernsey
   GH	Ghana
   GI	Gibraltar
   GL	Greenland
   GM	Gambia
   GN	Guinea
   GP	Guadeloupe
   GQ	Equatorial Guinea
   GR	Greece
   GT	Guatemala
   GU	Guam
   GW	Guinea-Bissau
   GY	Guyana
   HK	Hong Kong
   HN	Honduras
   HR	Croatia
   HT	Haiti
   HU	Hungary
   ID	Indonesia
   IE	Ireland
   IL	Israel
   IM	Isle of Man
   IN	India
   IO	British Indian Ocean Territory
   IQ	Iraq
   IR	Iran
   IS	Iceland
   IT	Italy
   JE	Jersey
   JM	Jamaica
   JO	Jordan
   JP	Japan
   KE	Kenya
   KG	Kyrgyzstan
   KH	Cambodia
   KI	Kiribati
   KM	Comoros
   KN	Saint Kitts and Nevis
   KP	Korea
   KR	Korea
   KW	Kuwait
   KY	Cayman Islands
   KZ	Kazakhstan
   LB	Lebanon
   LC	Saint Lucia
   LI	Liechtenstein
   LK	Sri Lanka
   LR	Liberia
   LS	Lesotho
   LT	Lithuania
   LU	Luxembourg
   LV	Latvia
   LY	Libyan Arab Jamahiriya
   MA	Morocco
   MC	Monaco
   MD	Moldova
   ME	Montenegro
   MF	Saint Martin
   MG	Madagascar
   MH	Marshall Islands
   MK	Macedonia
   ML	Mali
   MM	Myanmar
   MN	Mongolia
   MO	Macau
   MP	Northern Mariana Islands
   MQ	Martinique
   MR	Mauritania
   MS	Montserrat
   MT	Malta
   MU	Mauritius
   MV	Maldives
   MW	Malawi
   MX	Mexico
   MY	Malaysia
   MZ	Mozambique
   NA	Namibia
   NC	New Caledonia
   NE	Niger
   NF	Norfolk Island
   NG	Nigeria
   NI	Nicaragua
   NL	Netherlands
   NO	Norway
   NP	Nepal
   NR	Nauru
   NU	Niue
   NZ	New Zealand
   OM	Oman
   PA	Panama
   PE	Peru
   PF	French Polynesia
   PG	Papua New Guinea
   PH	Philippines
   PK	Pakistan
   PL	Poland
   PM	Saint Pierre and Miquelon
   PN	Pitcairn Islands
   PR	Puerto Rico
   PS	Palestinian Territory
   PT	Portugal
   PW	Palau
   PY	Paraguay
   QA	Qatar
   RE	Reunion
   RO	Romania
   RS	Serbia
   RU	Russian Federation
   RW	Rwanda
   SA	Saudi Arabia
   SB	Solomon Islands
   SC	Seychelles
   SD	Sudan
   SE	Sweden
   SG	Singapore
   SI	Slovenia
   SK	Slovakia
   SL	Sierra Leone
   SM	San Marino
   SN	Senegal
   SO	Somalia
   SR	Suriname
   ST	Sao Tome and Principe
   SV	El Salvador
   SY	Syrian Arab Republic
   SZ	Swaziland
   TC	Turks and Caicos Islands
   TD	Chad
   TG	Togo
   TH	Thailand
   TJ	Tajikistan
   TK	Tokelau
   TL	Timor-Leste
   TM	Turkmenistan
   TN	Tunisia
   TO	Tonga
   TR	Turkey
   TT	Trinidad and Tobago
   TV	Tuvalu
   TW	Taiwan
   TZ	Tanzania
   UA	Ukraine
   UG	Uganda
   UM	United States Minor Outlying Islands
   US	United States
   UY	Uruguay
   UZ	Uzbekistan
   VA	Holy See (Vatican City State)
   VC	Saint Vincent and the Grenadines
   VE	Venezuela
   VG	Virgin Islands
   VI	Virgin Islands
   VN	Vietnam
   VU	Vanuatu
   WF	Wallis and Futuna
   WS	Samoa
   YE	Yemen
   YT	Mayotte
   ZA	South Africa
   ZM	Zambia
   ZW	Zimbabwe

2. Use the following template SQL query command:
   

   UPDATE samdb.songlist set lyrics="xx" where artist="artist";

   Fill in the CC (country code) and the artist name.
   
   For example:
   

   UPDATE samdb.songlist set lyrics="GB" where artist="YES";

3. Keep in mind that Jim does things like "The Moody Blues" "Moody Blues, The" and "Roger Waters" "Waters, Roger"
   
   
4. Post your efforts in this thread by keeping the SQL command inside the CODE tags (the hash # mark in the options above) and copy each preceding contribution and then add yours.
   
   
5. Don't top post!!! I will delete them!!!
   
   
6. JUST post the updated SQL.

Thanks. I will delete posts as they are accrued leaving only the most recent so as not to clutter this effort too much. Do not worry about duplicates. I will sort through. If you see an error, feel free to correct it when you post.

Also, the artist name must be exact. For example: "Premiata Forneria Marconi" is acceptable whereas "PFM" is not... unless you happen to find that Jim listed this band as "PFM" in the library. (hint: he didn't).


Thanks so far to:

• Yesspaz
• tobytanzer
• dnsrees
• jtmckinley
• Wojtek

for their contributions to the effort.