Revision 57810
Added by Alessia Bardi over 4 years ago
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch_org_countries.sql | ||
---|---|---|
1 |
update dsm_organizations set country='TW' where country='Taiwan'; |
|
2 |
|
|
3 |
update dsm_organizations set country='NL' where country='Netherlands'; |
|
4 |
|
|
5 |
update dsm_organizations set country='NA' where country='NAM'; |
|
6 |
|
|
7 |
update dsm_organizations set country='KZ' where country='KAZ'; |
|
8 |
|
|
9 |
update dsm_organizations set country='IL' where country='Israel'; |
|
10 |
|
|
11 |
update dsm_organizations set country='US' where country='United States'; |
|
12 |
|
|
13 |
update dsm_organizations set country='DE' where country='Germany'; |
|
14 |
|
|
15 |
update dsm_organizations set country='CA' where country='Canada'; |
|
16 |
|
|
17 |
update dsm_organizations set country='LK' where country='LKA'; |
|
18 |
|
|
19 |
update dsm_organizations set country='CD' where country ='Congo, the Democratic Republic of the'; |
|
20 |
update dsm_organizations set country='CD' where country like 'Congo Democratic%'; |
|
21 |
update dsm_organizations set country='CD' where country = 'Zaire'; |
|
22 |
|
|
23 |
update dsm_organizations set country='FI' where country = 'Finland'; |
|
24 |
|
|
25 |
update dsm_organizations set country='MX' where country = 'Mexico'; |
|
26 |
update dsm_organizations set country='GB' where country = 'United Kingdom'; |
Also available in: Unified diff
Fixing countries for organizations coming from NSF annd not only