266 lines
11 KiB
SQL
266 lines
11 KiB
SQL
-- +goose Up
|
|
INSERT INTO lands (id, name, land_iso_code, sortkey, is_active, created_at, updated_at)
|
|
SELECT UUID_TO_BIN(UUID()), src.name, src.iso_code, src.sortkey, 1, NOW(3), NOW(3)
|
|
FROM (
|
|
SELECT 'AC' AS iso_code, 'Ascension' AS name, 1 AS sortkey
|
|
UNION ALL SELECT 'AD', 'Andorra', 2
|
|
UNION ALL SELECT 'AE', 'Vereinigte Arabische Emirate', 3
|
|
UNION ALL SELECT 'AF', 'Afghanistan', 4
|
|
UNION ALL SELECT 'AG', 'Antigua und Barbuda', 5
|
|
UNION ALL SELECT 'AI', 'Anguilla', 6
|
|
UNION ALL SELECT 'AL', 'Albanien', 7
|
|
UNION ALL SELECT 'AM', 'Armenien', 8
|
|
UNION ALL SELECT 'AN', 'Niederländische Antillen', 9
|
|
UNION ALL SELECT 'AO', 'Angola', 10
|
|
UNION ALL SELECT 'AQ', 'Antarktis', 11
|
|
UNION ALL SELECT 'AR', 'Argentinien', 12
|
|
UNION ALL SELECT 'AS', 'Amerikanisch Samoa', 13
|
|
UNION ALL SELECT 'AT', 'Österreich', 14
|
|
UNION ALL SELECT 'AU', 'Australien', 15
|
|
UNION ALL SELECT 'AW', 'Aruba', 16
|
|
UNION ALL SELECT 'AX', 'Aland', 17
|
|
UNION ALL SELECT 'AZ', 'Aserbaidschan', 18
|
|
UNION ALL SELECT 'BA', 'Bosnien-Herzegowina', 19
|
|
UNION ALL SELECT 'BB', 'Barbados', 20
|
|
UNION ALL SELECT 'BD', 'Bangladesch', 21
|
|
UNION ALL SELECT 'BE', 'Belgien', 22
|
|
UNION ALL SELECT 'BF', 'Burkina Faso', 23
|
|
UNION ALL SELECT 'BG', 'Bulgarien', 24
|
|
UNION ALL SELECT 'BH', 'Bahrain', 25
|
|
UNION ALL SELECT 'BJ', 'Benin', 26
|
|
UNION ALL SELECT 'BL', 'Burundi', 27
|
|
UNION ALL SELECT 'BM', 'Bermuda', 28
|
|
UNION ALL SELECT 'BN', 'Brunei Darussalam', 29
|
|
UNION ALL SELECT 'BO', 'Bolivien', 30
|
|
UNION ALL SELECT 'BR', 'Brasilien', 31
|
|
UNION ALL SELECT 'BS', 'Bahamas', 32
|
|
UNION ALL SELECT 'BT', 'Bhutan', 33
|
|
UNION ALL SELECT 'BV', 'Bouvetinseln', 34
|
|
UNION ALL SELECT 'BW', 'Botsuana', 35
|
|
UNION ALL SELECT 'BY', 'Belarus', 36
|
|
UNION ALL SELECT 'BZ', 'Belize ', 37
|
|
UNION ALL SELECT 'CA', 'Kanada', 38
|
|
UNION ALL SELECT 'CC', 'Kokosinseln', 39
|
|
UNION ALL SELECT 'CD', 'Demokratische Republik Kongo', 40
|
|
UNION ALL SELECT 'CF', 'Zentralafrikanische Republik', 41
|
|
UNION ALL SELECT 'CG', 'Kongo', 42
|
|
UNION ALL SELECT 'CH', 'Schweiz', 43
|
|
UNION ALL SELECT 'CI', 'Elfenbeinküste', 44
|
|
UNION ALL SELECT 'CK', 'Cookinseln', 45
|
|
UNION ALL SELECT 'CL', 'Chile', 46
|
|
UNION ALL SELECT 'CM', 'Kamerun', 47
|
|
UNION ALL SELECT 'CO', 'Kolumbien', 48
|
|
UNION ALL SELECT 'CR', 'Costa Rica', 49
|
|
UNION ALL SELECT 'CU', 'Kuba', 50
|
|
UNION ALL SELECT 'CV', 'Kap Verde', 51
|
|
UNION ALL SELECT 'CX', 'Weihnachtsinsel', 52
|
|
UNION ALL SELECT 'CY', 'Zypern', 53
|
|
UNION ALL SELECT 'CZ', 'Tschechische Republik', 54
|
|
UNION ALL SELECT 'DB', 'Dubai', 55
|
|
UNION ALL SELECT 'DE', 'Deutschland', 56
|
|
UNION ALL SELECT 'DJ', 'Dschibuti', 57
|
|
UNION ALL SELECT 'DK', 'Dänemark', 58
|
|
UNION ALL SELECT 'DM', 'Dominica', 59
|
|
UNION ALL SELECT 'DO', 'Dominikanische Republik', 60
|
|
UNION ALL SELECT 'DZ', 'Algerien', 61
|
|
UNION ALL SELECT 'EC', 'Ecuador', 62
|
|
UNION ALL SELECT 'EE', 'Estland', 63
|
|
UNION ALL SELECT 'EG', 'Ägypten', 64
|
|
UNION ALL SELECT 'EH', 'Western Sahara', 65
|
|
UNION ALL SELECT 'ER', 'Eritrea', 66
|
|
UNION ALL SELECT 'ES', 'Spanien', 67
|
|
UNION ALL SELECT 'ET', 'Äthiopien', 68
|
|
UNION ALL SELECT 'FI', 'Finnland', 69
|
|
UNION ALL SELECT 'FJ', 'Fidschi', 70
|
|
UNION ALL SELECT 'FK', 'Falklandinseln', 71
|
|
UNION ALL SELECT 'FM', 'Mikronesien', 72
|
|
UNION ALL SELECT 'FO', 'Färöer', 73
|
|
UNION ALL SELECT 'FR', 'Frankreich', 74
|
|
UNION ALL SELECT 'GA', 'Gabun', 75
|
|
UNION ALL SELECT 'GB', 'Vereinigtes Königreich', 76
|
|
UNION ALL SELECT 'GD', 'Grenada', 77
|
|
UNION ALL SELECT 'GE', 'Georgien', 78
|
|
UNION ALL SELECT 'GF', 'Französische Guyana', 79
|
|
UNION ALL SELECT 'GG', 'Guernsey', 80
|
|
UNION ALL SELECT 'GH', 'Ghana', 81
|
|
UNION ALL SELECT 'GI', 'Gibraltar', 82
|
|
UNION ALL SELECT 'GL', 'Grönland', 83
|
|
UNION ALL SELECT 'GM', 'Gambia', 84
|
|
UNION ALL SELECT 'GN', 'Guinea', 85
|
|
UNION ALL SELECT 'GP', 'Guadeloupe', 86
|
|
UNION ALL SELECT 'GQ', 'Äquatorialguinea', 87
|
|
UNION ALL SELECT 'GR', 'Griechenland', 88
|
|
UNION ALL SELECT 'GS', 'South Georgia and the South Sandwich Islands', 89
|
|
UNION ALL SELECT 'GT', 'Guatemala', 90
|
|
UNION ALL SELECT 'GU', 'Guam', 91
|
|
UNION ALL SELECT 'GW', 'Guinea-Bissau', 92
|
|
UNION ALL SELECT 'GY', 'Guyana', 93
|
|
UNION ALL SELECT 'HK', 'Hong Kong', 94
|
|
UNION ALL SELECT 'HM', 'Heard Island and McDonald Islands', 95
|
|
UNION ALL SELECT 'HN', 'Honduras', 96
|
|
UNION ALL SELECT 'HR', 'Kroatien', 97
|
|
UNION ALL SELECT 'HT', 'Haiti', 98
|
|
UNION ALL SELECT 'HU', 'Ungarn', 99
|
|
UNION ALL SELECT 'ID', 'Indonesien', 100
|
|
UNION ALL SELECT 'IE', 'Irland', 101
|
|
UNION ALL SELECT 'IL', 'Israel', 102
|
|
UNION ALL SELECT 'IM', 'Isle of Man', 103
|
|
UNION ALL SELECT 'IN', 'Indien', 104
|
|
UNION ALL SELECT 'IO', 'Br.Territ./Ind.Ozean', 105
|
|
UNION ALL SELECT 'IQ', 'Irak', 106
|
|
UNION ALL SELECT 'IR', 'Iran', 107
|
|
UNION ALL SELECT 'IS', 'Island', 108
|
|
UNION ALL SELECT 'IT', 'Italien', 109
|
|
UNION ALL SELECT 'JE', 'Jersey', 110
|
|
UNION ALL SELECT 'JM', 'Jamaika', 111
|
|
UNION ALL SELECT 'JO', 'Jordanien', 112
|
|
UNION ALL SELECT 'JP', 'Japan', 113
|
|
UNION ALL SELECT 'KE', 'Kenien', 114
|
|
UNION ALL SELECT 'KG', 'Kirgisistan', 115
|
|
UNION ALL SELECT 'KH', 'Kambodscha', 116
|
|
UNION ALL SELECT 'KI', 'Kiribati', 117
|
|
UNION ALL SELECT 'KM', 'Komoren', 118
|
|
UNION ALL SELECT 'KN', 'St. Kittis und Nevis', 119
|
|
UNION ALL SELECT 'KO', 'Kosovo', 120
|
|
UNION ALL SELECT 'KP', 'Korea, Demo. VR', 121
|
|
UNION ALL SELECT 'KR', 'Korea', 122
|
|
UNION ALL SELECT 'KW', 'Kuwait', 123
|
|
UNION ALL SELECT 'KY', 'Kaimaninseln', 124
|
|
UNION ALL SELECT 'KZ', 'Kasachstan', 125
|
|
UNION ALL SELECT 'LA', 'Laos', 126
|
|
UNION ALL SELECT 'LB', 'Libanon', 127
|
|
UNION ALL SELECT 'LC', 'Sankt Lucia', 128
|
|
UNION ALL SELECT 'LI', 'Liechtenstein', 129
|
|
UNION ALL SELECT 'LK', 'Sri Lanka', 130
|
|
UNION ALL SELECT 'LR', 'Liberia', 131
|
|
UNION ALL SELECT 'LS', 'Lesotho', 132
|
|
UNION ALL SELECT 'LT', 'Litauen', 133
|
|
UNION ALL SELECT 'LU', 'Luxemburg', 134
|
|
UNION ALL SELECT 'LV', 'Lettland', 135
|
|
UNION ALL SELECT 'LY', 'Lybien', 136
|
|
UNION ALL SELECT 'MA', 'Marokko', 137
|
|
UNION ALL SELECT 'MC', 'Monaco', 138
|
|
UNION ALL SELECT 'MD', 'Moldova', 139
|
|
UNION ALL SELECT 'ME', 'Montenegro', 140
|
|
UNION ALL SELECT 'MG', 'Madagaskar', 141
|
|
UNION ALL SELECT 'MH', 'Marshallinseln', 142
|
|
UNION ALL SELECT 'MK', 'Mazedonien', 143
|
|
UNION ALL SELECT 'ML', 'Mali', 144
|
|
UNION ALL SELECT 'MM', 'Myanmar', 145
|
|
UNION ALL SELECT 'MN', 'Mongolei', 146
|
|
UNION ALL SELECT 'MO', 'Macau', 147
|
|
UNION ALL SELECT 'MP', 'Marianen', 148
|
|
UNION ALL SELECT 'MQ', 'Martinique', 149
|
|
UNION ALL SELECT 'MR', 'Mauretanien', 150
|
|
UNION ALL SELECT 'MS', 'Montserrat', 151
|
|
UNION ALL SELECT 'MT', 'Malta', 152
|
|
UNION ALL SELECT 'MU', 'Mauritius', 153
|
|
UNION ALL SELECT 'MV', 'Malediven', 154
|
|
UNION ALL SELECT 'MW', 'Malawi', 155
|
|
UNION ALL SELECT 'MX', 'Mexiko', 156
|
|
UNION ALL SELECT 'MY', 'Malaysia', 157
|
|
UNION ALL SELECT 'MZ', 'Mosambik', 158
|
|
UNION ALL SELECT 'NA', 'Namibia', 159
|
|
UNION ALL SELECT 'NC', 'Neukaledonien', 160
|
|
UNION ALL SELECT 'NE', 'Niger', 161
|
|
UNION ALL SELECT 'NF', 'Norfolkins', 162
|
|
UNION ALL SELECT 'NG', 'Nigeria', 163
|
|
UNION ALL SELECT 'NI', 'Nicaragua', 164
|
|
UNION ALL SELECT 'NL', 'Niederlande', 165
|
|
UNION ALL SELECT 'NO', 'Norwegen', 166
|
|
UNION ALL SELECT 'NP', 'Nepal', 167
|
|
UNION ALL SELECT 'NR', 'Nauru', 168
|
|
UNION ALL SELECT 'NU', 'Niue', 169
|
|
UNION ALL SELECT 'NZ', 'Neuseeland', 170
|
|
UNION ALL SELECT 'O', 'unbekannt', 171
|
|
UNION ALL SELECT 'OM', 'Oman', 172
|
|
UNION ALL SELECT 'PA', 'Panama', 173
|
|
UNION ALL SELECT 'PE', 'Peru', 174
|
|
UNION ALL SELECT 'PF', 'Französchisch Polynesien', 175
|
|
UNION ALL SELECT 'PG', 'Papua Neuguinea', 176
|
|
UNION ALL SELECT 'PH', 'Philippinen', 177
|
|
UNION ALL SELECT 'PK', 'Pakistan', 178
|
|
UNION ALL SELECT 'PL', 'Polen', 179
|
|
UNION ALL SELECT 'PM', 'St Pierre und Miquelon', 180
|
|
UNION ALL SELECT 'PN', 'Pitkern', 181
|
|
UNION ALL SELECT 'PR', 'Puerto Rico', 182
|
|
UNION ALL SELECT 'PS', 'Palestina', 183
|
|
UNION ALL SELECT 'PT', 'Portugal', 184
|
|
UNION ALL SELECT 'PW', 'Palau', 185
|
|
UNION ALL SELECT 'PY', 'Paraguay', 186
|
|
UNION ALL SELECT 'Q', 'Katar', 187
|
|
UNION ALL SELECT 'RE', 'Reunion', 188
|
|
UNION ALL SELECT 'RM', 'San Marino', 189
|
|
UNION ALL SELECT 'RO', 'Rumänien', 190
|
|
UNION ALL SELECT 'RS', 'Serbien', 191
|
|
UNION ALL SELECT 'RU', 'Russische Föderation', 192
|
|
UNION ALL SELECT 'RW', 'Ruanda', 193
|
|
UNION ALL SELECT 'SA', 'Saudi Arabien', 194
|
|
UNION ALL SELECT 'SB', 'Salomonen', 195
|
|
UNION ALL SELECT 'SC', 'Seychellen', 196
|
|
UNION ALL SELECT 'SD', 'Sudan', 197
|
|
UNION ALL SELECT 'SE', 'Schweden', 198
|
|
UNION ALL SELECT 'SG', 'Singapur', 199
|
|
UNION ALL SELECT 'SH', 'Sankt Helena', 200
|
|
UNION ALL SELECT 'SI', 'Slowenien', 201
|
|
UNION ALL SELECT 'SJ', 'Svalbard', 202
|
|
UNION ALL SELECT 'SK', 'Slowakei', 203
|
|
UNION ALL SELECT 'SL', 'Sierra Leone', 204
|
|
UNION ALL SELECT 'SN', 'Senegal', 205
|
|
UNION ALL SELECT 'SO', 'Somalia', 206
|
|
UNION ALL SELECT 'SR', 'Suriname', 207
|
|
UNION ALL SELECT 'ST', 'Sao Tome und Pricipe', 208
|
|
UNION ALL SELECT 'SV', 'El Salvador', 209
|
|
UNION ALL SELECT 'SY', 'Syrien', 210
|
|
UNION ALL SELECT 'SZ', 'Swasiland', 211
|
|
UNION ALL SELECT 'TA', 'Tristan da Cunha', 212
|
|
UNION ALL SELECT 'TC', 'Turks und Caicosinseln', 213
|
|
UNION ALL SELECT 'TD', 'Tschad', 214
|
|
UNION ALL SELECT 'TF', 'French Southern and Antarctic Lands', 215
|
|
UNION ALL SELECT 'TG', 'Togo', 216
|
|
UNION ALL SELECT 'TH', 'Thailand', 217
|
|
UNION ALL SELECT 'TI', 'Timor Leste', 218
|
|
UNION ALL SELECT 'TJ', 'Tadschikistan', 219
|
|
UNION ALL SELECT 'TK', 'Tokelau', 220
|
|
UNION ALL SELECT 'TL', 'Ost-Timor', 221
|
|
UNION ALL SELECT 'TM', 'Turkmenistan', 222
|
|
UNION ALL SELECT 'TN', 'Tunesien', 223
|
|
UNION ALL SELECT 'TO', 'Tonga', 224
|
|
UNION ALL SELECT 'TP', 'Osttimor', 225
|
|
UNION ALL SELECT 'TR', 'Türkei', 226
|
|
UNION ALL SELECT 'TT', 'Trinidad und Tobago', 227
|
|
UNION ALL SELECT 'TV', 'Tuvalu', 228
|
|
UNION ALL SELECT 'TW', 'Taiwan', 229
|
|
UNION ALL SELECT 'TZ', 'Tansania', 230
|
|
UNION ALL SELECT 'UA', 'Ukraine', 231
|
|
UNION ALL SELECT 'UG', 'Uganda', 232
|
|
UNION ALL SELECT 'UK', 'Großbritannien', 233
|
|
UNION ALL SELECT 'UM', 'Baker Island', 234
|
|
UNION ALL SELECT 'US', 'Vereinigte Staaten (USA)', 235
|
|
UNION ALL SELECT 'UY', 'Uruguay', 236
|
|
UNION ALL SELECT 'UZ', 'Usbekistan', 237
|
|
UNION ALL SELECT 'V', 'Vatikanstadt', 238
|
|
UNION ALL SELECT 'VC', 'St. Vincent udn Grenadinen', 239
|
|
UNION ALL SELECT 'VE', 'Venezuela', 240
|
|
UNION ALL SELECT 'VG', 'Jungferninseln', 241
|
|
UNION ALL SELECT 'VI', 'US Jungferninseln', 242
|
|
UNION ALL SELECT 'VN', 'Vietnam', 243
|
|
UNION ALL SELECT 'VR', 'China', 244
|
|
UNION ALL SELECT 'VU', 'Vanuatu', 245
|
|
UNION ALL SELECT 'WF', 'Wallis und Futuna', 246
|
|
UNION ALL SELECT 'WS', 'Samoa', 247
|
|
UNION ALL SELECT 'X', 'Staatenlos', 248
|
|
UNION ALL SELECT 'YE', 'Jemen', 249
|
|
UNION ALL SELECT 'YT', 'Mayotte', 250
|
|
UNION ALL SELECT 'YU', 'ehem. Jugoslawien', 251
|
|
UNION ALL SELECT 'ZA', 'Südafrika', 252
|
|
UNION ALL SELECT 'ZM', 'Sambia', 253
|
|
UNION ALL SELECT 'ZW', 'Simbabwe', 254
|
|
) AS src
|
|
LEFT JOIN lands l ON l.land_iso_code = src.iso_code AND l.deleted_at IS NULL
|
|
WHERE l.id IS NULL;
|
|
|
|
-- +goose Down
|
|
-- Intentionally no-op to avoid deleting existing production reference data.
|
|
SELECT 1;
|