text: /* Populate Countries List */
  INSERT INTO `unepassignment`.`Countries` VALUES
  (NULL, 'AF', 'Afghanistan'),
  (NULL, 'AL', 'Albania'),
  (NULL, 'DZ', 'Algeria'),
  (NULL, 'DS', 'American Samoa'),
  (NULL, 'AD', 'Andorra'),
  (NULL, 'AO', 'Angola'),
  (NULL, 'AI', 'Anguilla'),
  (NULL, 'AQ', 'Antarctica'),
  (NULL, 'AG', 'Antigua and Barbuda'),
  (NULL, 'AR', 'Argentina'),
  (NULL, 'AM', 'Armenia'),
  (NULL, 'AW', 'Aruba'),
  (NULL, 'AU', 'Australia'),
  (NULL, 'AT', 'Austria'),
  (NULL, 'AZ', 'Azerbaijan'),
  (NULL, 'BS', 'Bahamas'),
  (NULL, 'BH', 'Bahrain'),
  (NULL, 'BD', 'Bangladesh'),
  (NULL, 'BB', 'Barbados'),
  (NULL, 'BY', 'Belarus'),
  (NULL, 'BE', 'Belgium'),
  (NULL, 'BZ', 'Belize'),
  (NULL, 'BJ', 'Benin'),
  (NULL, 'BM', 'Bermuda'),
  (NULL, 'BT', 'Bhutan'),
  (NULL, 'BO', 'Bolivia'),
  (NULL, 'BA', 'Bosnia and Herzegovina'),
  (NULL, 'BW', 'Botswana'),
  (NULL, 'BV', 'Bouvet Island'),
  (NULL, 'BR', 'Brazil'),
  (NULL, 'IO', 'British Indian Ocean Territory'),
  (NULL, 'BN', 'Brunei Darussalam'),
  (NULL, 'BG', 'Bulgaria'),
  (NULL, 'BF', 'Burkina Faso'),
  (NULL, 'BI', 'Burundi'),
  (NULL, 'KH', 'Cambodia'),
  (NULL, 'CM', 'Cameroon'),
  (NULL, 'CA', 'Canada'),
  (NULL, 'CV', 'Cape Verde'),
  (NULL, 'KY', 'Cayman Islands'),
  (NULL, 'CF', 'Central African Republic'),
  (NULL, 'TD', 'Chad'),
  (NULL, 'CL', 'Chile'),
  (NULL, 'CN', 'China'),
  (NULL, 'CX', 'Christmas Island'),
  (NULL, 'CC', 'Cocos (Keeling) Islands'),
  (NULL, 'CO', 'Colombia'),
  (NULL, 'KM', 'Comoros'),
  (NULL, 'CG', 'Congo'),
  (NULL, 'CK', 'Cook Islands'),
  (NULL, 'CR', 'Costa Rica'),
  (NULL, 'HR', 'Croatia (Hrvatska)'),
  (NULL, 'CU', 'Cuba'),
  (NULL, 'CY', 'Cyprus'),
  (NULL, 'CZ', 'Czech Republic'),
  (NULL, 'DK', 'Denmark'),
  (NULL, 'DJ', 'Djibouti'),
  (NULL, 'DM', 'Dominica'),
  (NULL, 'DO', 'Dominican Republic'),
  (NULL, 'TP', 'East Timor'),
  (NULL, 'EC', 'Ecuador'),
  (NULL, 'EG', 'Egypt'),
  (NULL, 'SV', 'El Salvador'),
  (NULL, 'GQ', 'Equatorial Guinea'),
  (NULL, 'ER', 'Eritrea'),
  (NULL, 'EE', 'Estonia'),
  (NULL, 'ET', 'Ethiopia'),
  (NULL, 'FK', 'Falkland Islands (Malvinas)'),
  (NULL, 'FO', 'Faroe Islands'),
  (NULL, 'FJ', 'Fiji'),
  (NULL, 'FI', 'Finland'),
  (NULL, 'FR', 'France'),
  (NULL, 'FX', 'France, Metropolitan'),
  (NULL, 'GF', 'French Guiana'),
  (NULL, 'PF', 'French Polynesia'),
  (NULL, 'TF', 'French Southern Territories'),
  (NULL, 'GA', 'Gabon'),
  (NULL, 'GM', 'Gambia'),
  (NULL, 'GE', 'Georgia'),
  (NULL, 'DE', 'Germany'),
  (NULL, 'GH', 'Ghana'),
  (NULL, 'GI', 'Gibraltar'),
  (NULL, 'GK', 'Guernsey'),
  (NULL, 'GR', 'Greece'),
  (NULL, 'GL', 'Greenland'),
  (NULL, 'GD', 'Grenada'),
  (NULL, 'GP', 'Guadeloupe'),
  (NULL, 'GU', 'Guam'),
  (NULL, 'GT', 'Guatemala'),
  (NULL, 'GN', 'Guinea'),
  (NULL, 'GW', 'Guinea-Bissau'),
  (NULL, 'GY', 'Guyana'),
  (NULL, 'HT', 'Haiti'),
  (NULL, 'HM', 'Heard and Mc Donald Islands'),
  (NULL, 'HN', 'Honduras'),
  (NULL, 'HK', 'Hong Kong'),
  (NULL, 'HU', 'Hungary'),
  (NULL, 'IS', 'Iceland'),
  (NULL, 'IN', 'India'),
  (NULL, 'IM', 'Isle of Man'),
  (NULL, 'ID', 'Indonesia'),
  (NULL, 'IR', 'Iran (Islamic Republic of)'),
  (NULL, 'IQ', 'Iraq'),
  (NULL, 'IE', 'Ireland'),
  (NULL, 'IL', 'Israel'),
  (NULL, 'IT', 'Italy'),
  (NULL, 'CI', 'Ivory Coast'),
  (NULL, 'JE', 'Jersey'),
  (NULL, 'JM', 'Jamaica'),
  (NULL, 'JP', 'Japan'),
  (NULL, 'JO', 'Jordan'),
  (NULL, 'KZ', 'Kazakhstan'),
  (NULL, 'KE', 'Kenya'),
  (NULL, 'KI', 'Kiribati'),
  (NULL, 'KP', 'Korea, Democratic People''s Republic of'),
  (NULL, 'KR', 'Korea, Republic of'),
  (NULL, 'XK', 'Kosovo'),
  (NULL, 'KW', 'Kuwait'),
  (NULL, 'KG', 'Kyrgyzstan'),
  (NULL, 'LA', 'Lao People''s Democratic Republic'),
  (NULL, 'LV', 'Latvia'),
  (NULL, 'LB', 'Lebanon'),
  (NULL, 'LS', 'Lesotho'),
  (NULL, 'LR', 'Liberia'),
  (NULL, 'LY', 'Libyan Arab Jamahiriya'),
  (NULL, 'LI', 'Liechtenstein'),
  (NULL, 'LT', 'Lithuania'),
  (NULL, 'LU', 'Luxembourg'),
  (NULL, 'MO', 'Macau'),
  (NULL, 'MK', 'Macedonia'),
  (NULL, 'MG', 'Madagascar'),
  (NULL, 'MW', 'Malawi'),
  (NULL, 'MY', 'Malaysia'),
  (NULL, 'MV', 'Maldives'),
  (NULL, 'ML', 'Mali'),
  (NULL, 'MT', 'Malta'),
  (NULL, 'MH', 'Marshall Islands'),
  (NULL, 'MQ', 'Martinique'),
  (NULL, 'MR', 'Mauritania'),
  (NULL, 'MU', 'Mauritius'),
  (NULL, 'TY', 'Mayotte'),
  (NULL, 'MX', 'Mexico'),
  (NULL, 'FM', 'Micronesia, Federated States of'),
  (NULL, 'MD', 'Moldova, Republic of'),
  (NULL, 'MC', 'Monaco'),
  (NULL, 'MN', 'Mongolia'),
  (NULL, 'ME', 'Montenegro'),
  (NULL, 'MS', 'Montserrat'),
  (NULL, 'MA', 'Morocco'),
  (NULL, 'MZ', 'Mozambique'),
  (NULL, 'MM', 'Myanmar'),
  (NULL, 'NA', 'Namibia'),
  (NULL, 'NR', 'Nauru'),
  (NULL, 'NP', 'Nepal'),
  (NULL, 'NL', 'Netherlands'),
  (NULL, 'AN', 'Netherlands Antilles'),
  (NULL, 'NC', 'New Caledonia'),
  (NULL, 'NZ', 'New Zealand'),
  (NULL, 'NI', 'Nicaragua'),
  (NULL, 'NE', 'Niger'),
  (NULL, 'NG', 'Nigeria'),
  (NULL, 'NU', 'Niue'),
  (NULL, 'NF', 'Norfolk Island'),
  (NULL, 'MP', 'Northern Mariana Islands'),
  (NULL, 'NO', 'Norway'),
  (NULL, 'OM', 'Oman'),
  (NULL, 'PK', 'Pakistan'),
  (NULL, 'PW', 'Palau'),
  (NULL, 'PS', 'Palestine'),
  (NULL, 'PA', 'Panama'),
  (NULL, 'PG', 'Papua New Guinea'),
  (NULL, 'PY', 'Paraguay'),
  (NULL, 'PE', 'Peru'),
  (NULL, 'PH', 'Philippines'),
  (NULL, 'PN', 'Pitcairn'),
  (NULL, 'PL', 'Poland'),
  (NULL, 'PT', 'Portugal'),
  (NULL, 'PR', 'Puerto Rico'),
  (NULL, 'QA', 'Qatar'),
  (NULL, 'RE', 'Reunion'),
  (NULL, 'RO', 'Romania'),
  (NULL, 'RU', 'Russian Federation'),
  (NULL, 'RW', 'Rwanda'),
  (NULL, 'KN', 'Saint Kitts and Nevis'),
  (NULL, 'LC', 'Saint Lucia'),
  (NULL, 'VC', 'Saint Vincent and the Grenadines'),
  (NULL, 'WS', 'Samoa'),
  (NULL, 'SM', 'San Marino'),
  (NULL, 'ST', 'Sao Tome and Principe'),
  (NULL, 'SA', 'Saudi Arabia'),
  (NULL, 'SN', 'Senegal'),
  (NULL, 'RS', 'Serbia'),
  (NULL, 'SC', 'Seychelles'),
  (NULL, 'SL', 'Sierra Leone'),
  (NULL, 'SG', 'Singapore'),
  (NULL, 'SK', 'Slovakia'),
  (NULL, 'SI', 'Slovenia'),
  (NULL, 'SB', 'Solomon Islands'),
  (NULL, 'SO', 'Somalia'),
  (NULL, 'ZA', 'South Africa'),
  (NULL, 'GS', 'South Georgia South Sandwich Islands'),
  (NULL, 'SS', 'South Sudan'),
  (NULL, 'ES', 'Spain'),
  (NULL, 'LK', 'Sri Lanka'),
  (NULL, 'SH', 'St. Helena'),
  (NULL, 'PM', 'St. Pierre and Miquelon'),
  (NULL, 'SD', 'Sudan'),
  (NULL, 'SR', 'Suriname'),
  (NULL, 'SJ', 'Svalbard and Jan Mayen Islands'),
  (NULL, 'SZ', 'Swaziland'),
  (NULL, 'SE', 'Sweden'),
  (NULL, 'CH', 'Switzerland'),
  (NULL, 'SY', 'Syrian Arab Republic'),
  (NULL, 'TW', 'Taiwan'),
  (NULL, 'TJ', 'Tajikistan'),
  (NULL, 'TZ', 'Tanzania, United Republic of'),
  (NULL, 'TH', 'Thailand'),
  (NULL, 'TG', 'Togo'),
  (NULL, 'TK', 'Tokelau'),
  (NULL, 'TO', 'Tonga'),
  (NULL, 'TT', 'Trinidad and Tobago'),
  (NULL, 'TN', 'Tunisia'),
  (NULL, 'TR', 'Turkey'),
  (NULL, 'TM', 'Turkmenistan'),
  (NULL, 'TC', 'Turks and Caicos Islands'),
  (NULL, 'TV', 'Tuvalu'),
  (NULL, 'UG', 'Uganda'),
  (NULL, 'UA', 'Ukraine'),
  (NULL, 'AE', 'United Arab Emirates'),
  (NULL, 'GB', 'United Kingdom'),
  (NULL, 'US', 'United States'),
  (NULL, 'UM', 'United States minor outlying islands'),
  (NULL, 'UY', 'Uruguay'),
  (NULL, 'UZ', 'Uzbekistan'),
  (NULL, 'VU', 'Vanuatu'),
  (NULL, 'VA', 'Vatican City State'),
  (NULL, 'VE', 'Venezuela'),
  (NULL, 'VN', 'Vietnam'),
  (NULL, 'VG', 'Virgin Islands (British)'),
  (NULL, 'VI', 'Virgin Islands (U.S.)'),
  (NULL, 'WF', 'Wallis and Futuna Islands'),
  (NULL, 'EH', 'Western Sahara'),
  (NULL, 'YE', 'Yemen'),
  (NULL, 'ZR', 'Zaire'),
  (NULL, 'ZM', 'Zambia'),
  (NULL, 'ZW', 'Zimbabwe');
  
  
  /* Populate Implementing Office List */
  INSERT INTO `unepassignment`.`Office` VALUES
  (NULL, 'Africa Office', ''),
  (NULL, 'Asia Pacific Office', ''),
  (NULL, 'CTCN', ''),
  (NULL, 'Economy Division', ''),
  (NULL, 'Ecosystems', ''),
  (NULL, 'Europe Office', ''),
  (NULL, 'Latin America Office', ''),
  (NULL, 'Policy & Programme Division', ''),
  (NULL, 'West Asia Office', '');
  
  
  /* Populate Readiness or NAP Status */
  INSERT INTO `unepassignment`.`NAPStatus` VALUES
  (NULL, 'Readiness', ''),
  (NULL, 'National Adaptation Plans', '');
  
  
  /* Populate Type of readiness */
  INSERT INTO `unepassignment`.`NAPType` VALUES
  (NULL, 'Capacity Building', ''),
  (NULL, 'FI/TNA/other', ''),
  (NULL, 'NAP', ''),
  (NULL, 'REDD+', ''),
  (NULL, 'Not Defined', '');
  
  
  /* Populate Project Status */
  INSERT INTO `unepassignment`.`ProjectStatus` VALUES
  (NULL, 'Completed', ''),
  (NULL, 'Completion Report Submitted', ''),
  (NULL, 'Requesting Funds', ''),
  (NULL, 'Under Implementation', '');
  
  
  /* Populate Projects Table */
  INSERT INTO `Projects` (`id`, `reference`, `implementingoffice`, `title`, `grantamount`, `firstdisbursement`, `gcfdate`, `startdate`, `enddate`, `napstatus`, `naptype`, `status`, `createuser`, `createdate`, `createipaddr`, `lastmodifyuser`, `lastmodifydate`, `lastmodifyipaddr`, `deleted`) VALUES
  (1, 'ALB-RS-001', 6, 'Readiness support to Albania', '300000.00', '147500.00', '2016-11-15', '2016-08-30', '2017-08-30', 1, 1, 1, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (2, 'BRA-RS-001', 4, 'Technology Needs Assessment for the Implementation of Climate Action Plans', '700000.00', '197450.00', '2018-06-20', '2018-06-20', '2019-12-19', 1, 2, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (3, 'COM-RS-001', 5, '1. Establishing and strengthening National Designated Authorities or Focal Points; 2. Developing strategic frameworks for engagement with the GCF, including the preparation of country programmes.', '426080.00', '115117.00', '2018-11-01', '2018-11-01', '2020-10-21', 1, 1, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (4, 'CRI-RS-002', 7, 'Building sub-national capacities for the implementation of the National Adaptation Plan in Costa Rica', '2861917.00', '350575.33', '2018-10-23', '2018-10-23', '2021-10-23', 2, 3, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (5, 'DOM-RS-002', 7, 'Building capacity to advance National Adaptation Plan Process in the Dominican Republic', '2998325.00', '1161912.00', '2018-07-11', '2018-07-11', '2021-06-10', 2, 3, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (6, 'EGY-RS-001', 5, 'Supporting Egypt’s engagement with the Green Climate Fund: Logical framework support', '300000.00', '122456.00', '2017-05-02', '2017-04-24', '2018-10-23', 1, 1, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (7, 'GHA-RS-001', 3, 'Drought Early Warning and Forecasting System: Improving resiliency of crops to drought through strengthened early warning within Ghana, Uganda and Sudan', '300150.00', '300150.00', '2017-05-15', '2017-05-15', '2019-05-10', 1, 2, 2, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (8, 'HND-RS-002', 7, 'Supporting strategic planning to engage with the GCF and comply with the national commitments under the Paris Agreement regarding the LULUCF sector', '764960.00', '243515.00', '2018-01-18', '2018-01-18', '2019-07-19', 1, 4, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (9, 'JOR-RS-001', 9, 'Strengthening NDA of Jordan to deliver on GCF Investment Framework', '300000.00', '150000.00', '2017-06-15', '2017-06-15', '2018-12-14', 1, 1, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (10, 'MDG-RS-001', 5, 'Building Capacity in Madagascar to engage with the GCF', '300000.00', '177588.00', '2018-07-20', '2018-07-20', '2019-07-19', 1, 1, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (11, 'MLY-RS-002', 2, 'Accessing REDD+ result-based payments in Malaysia', '819230.00', '465695.33', '2018-11-12', '2018-11-12', '2020-11-13', 1, 4, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (12, 'MDV-RS-001', 2, 'Establishing and strengthening National Designated Authority (NDA), and developing strategic framework for engagement with the GCF in Maldives', '300000.00', '198545.00', '2017-06-16', '2017-06-16', '2018-06-13', 1, 1, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0),
  (13, 'MRT-RS-002', 1, 'Building capacity to advance National Adaptation Plan Process in Mauritania', '2670374.00', '742163.00', '2018-07-17', '2018-07-17', '2021-07-08', 2, 3, 4, 0, 0, '127.0.0.1', 0, 0, '127.0.0.1', 0);
  
  
  /* Populate Project Location Table */
  INSERT INTO `ProjectLocation` (`projectid`, `countryid`) VALUES
  (1, 2),
  (2, 30),
  (3, 48),
  (4, 51),
  (5, 59),
  (6, 62),
  (7, 81),
  (8, 95),
  (9, 111),
  (10, 131),
  (11, 133),
  (12, 134),
  (13, 139),
  (6, 149),
  (2, 170),
  (1, 181),
  (7, 207),
  (7, 227);