|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
declare(strict_types=1); |
|
4
|
|
|
|
|
5
|
|
|
namespace Application\Migration; |
|
6
|
|
|
|
|
7
|
|
|
use Doctrine\DBAL\Schema\Schema; |
|
8
|
|
|
|
|
9
|
|
|
class Version20181207072206 extends AbstractMigration |
|
10
|
|
|
{ |
|
11
|
|
|
public function up(Schema $schema): void |
|
12
|
|
|
{ |
|
13
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
14
|
|
|
|
|
15
|
|
|
$this->addSql('CREATE TABLE user_tag (id INT AUTO_INCREMENT NOT NULL, creator_id INT DEFAULT NULL, owner_id INT DEFAULT NULL, updater_id INT DEFAULT NULL, creation_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, name VARCHAR(191) NOT NULL, color VARCHAR(7) DEFAULT \'\' NOT NULL, INDEX IDX_E89FD60861220EA6 (creator_id), INDEX IDX_E89FD6087E3C61F9 (owner_id), INDEX IDX_E89FD608E37ECFB0 (updater_id), UNIQUE INDEX unique_name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
16
|
|
|
$this->addSql('CREATE TABLE user_tag_user (user_tag_id INT NOT NULL, user_id INT NOT NULL, INDEX IDX_83118DFFDF80782C (user_tag_id), INDEX IDX_83118DFFA76ED395 (user_id), PRIMARY KEY(user_tag_id, user_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
17
|
|
|
$this->addSql('CREATE TABLE bookable (id INT AUTO_INCREMENT NOT NULL, creator_id INT DEFAULT NULL, owner_id INT DEFAULT NULL, updater_id INT DEFAULT NULL, type_id INT DEFAULT NULL, creation_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, initial_price NUMERIC(10, 0) DEFAULT \'0\' NOT NULL, periodic_price NUMERIC(10, 0) DEFAULT \'0\' NOT NULL, simultaneous_booking_maximum SMALLINT UNSIGNED DEFAULT 1 NOT NULL, booking_type ENUM(\'self_approved\', \'admin_approved\', \'admin_only\', \'mandatory\') DEFAULT \'self_approved\' NOT NULL COMMENT \'(DC2Type:BookingType)\', name VARCHAR(191) NOT NULL, description TEXT NOT NULL, code VARCHAR(10) DEFAULT \'\' NOT NULL, INDEX IDX_A10B812461220EA6 (creator_id), INDEX IDX_A10B81247E3C61F9 (owner_id), INDEX IDX_A10B8124E37ECFB0 (updater_id), INDEX IDX_A10B8124C54C8C93 (type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
18
|
|
|
$this->addSql('CREATE TABLE image (id INT AUTO_INCREMENT NOT NULL, creator_id INT DEFAULT NULL, owner_id INT DEFAULT NULL, updater_id INT DEFAULT NULL, bookable_id INT DEFAULT NULL, creation_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, filename VARCHAR(2000) NOT NULL, width INT NOT NULL, height INT NOT NULL, INDEX IDX_C53D045F61220EA6 (creator_id), INDEX IDX_C53D045F7E3C61F9 (owner_id), INDEX IDX_C53D045FE37ECFB0 (updater_id), INDEX IDX_C53D045FEC4F5B2F (bookable_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
19
|
|
|
$this->addSql('CREATE TABLE country (id INT AUTO_INCREMENT NOT NULL, creator_id INT DEFAULT NULL, owner_id INT DEFAULT NULL, updater_id INT DEFAULT NULL, creation_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, code VARCHAR(2) NOT NULL, name VARCHAR(191) NOT NULL, UNIQUE INDEX UNIQ_5373C96677153098 (code), INDEX IDX_5373C96661220EA6 (creator_id), INDEX IDX_5373C9667E3C61F9 (owner_id), INDEX IDX_5373C966E37ECFB0 (updater_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
20
|
|
|
$this->addSql('CREATE TABLE booking (id INT AUTO_INCREMENT NOT NULL, creator_id INT DEFAULT NULL, owner_id INT DEFAULT NULL, updater_id INT DEFAULT NULL, responsible_id INT DEFAULT NULL, creation_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, status ENUM(\'application\', \'booked\', \'processed\') DEFAULT \'application\' NOT NULL COMMENT \'(DC2Type:BookingStatus)\', participant_count INT UNSIGNED DEFAULT 1 NOT NULL, destination VARCHAR(50) DEFAULT \'\' NOT NULL, start_comment TEXT NOT NULL, end_comment TEXT NOT NULL, start_date DATETIME NOT NULL, end_date DATETIME DEFAULT NULL, estimated_end_date VARCHAR(50) DEFAULT \'\' NOT NULL, INDEX IDX_E00CEDDE61220EA6 (creator_id), INDEX IDX_E00CEDDE7E3C61F9 (owner_id), INDEX IDX_E00CEDDEE37ECFB0 (updater_id), INDEX IDX_E00CEDDE602AD315 (responsible_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
21
|
|
|
$this->addSql('CREATE TABLE booking_bookable (booking_id INT NOT NULL, bookable_id INT NOT NULL, INDEX IDX_9A3F1FA93301C60 (booking_id), INDEX IDX_9A3F1FA9EC4F5B2F (bookable_id), PRIMARY KEY(booking_id, bookable_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
22
|
|
|
$this->addSql('CREATE TABLE bookable_type (id INT AUTO_INCREMENT NOT NULL, creator_id INT DEFAULT NULL, owner_id INT DEFAULT NULL, updater_id INT DEFAULT NULL, creation_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, name VARCHAR(191) NOT NULL, INDEX IDX_B161DE161220EA6 (creator_id), INDEX IDX_B161DE17E3C61F9 (owner_id), INDEX IDX_B161DE1E37ECFB0 (updater_id), UNIQUE INDEX unique_name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
23
|
|
|
$this->addSql('CREATE TABLE license (id INT AUTO_INCREMENT NOT NULL, creator_id INT DEFAULT NULL, owner_id INT DEFAULT NULL, updater_id INT DEFAULT NULL, creation_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, name VARCHAR(191) NOT NULL, INDEX IDX_5768F41961220EA6 (creator_id), INDEX IDX_5768F4197E3C61F9 (owner_id), INDEX IDX_5768F419E37ECFB0 (updater_id), UNIQUE INDEX unique_name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
24
|
|
|
$this->addSql('CREATE TABLE license_bookable (license_id INT NOT NULL, bookable_id INT NOT NULL, INDEX IDX_5D5B1013460F904B (license_id), INDEX IDX_5D5B1013EC4F5B2F (bookable_id), PRIMARY KEY(license_id, bookable_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
25
|
|
|
$this->addSql('CREATE TABLE license_user (license_id INT NOT NULL, user_id INT NOT NULL, INDEX IDX_77C835A460F904B (license_id), INDEX IDX_77C835AA76ED395 (user_id), PRIMARY KEY(license_id, user_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
26
|
|
|
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, creator_id INT DEFAULT NULL, owner_id INT DEFAULT NULL, updater_id INT DEFAULT NULL, responsible_id INT DEFAULT NULL, creation_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, login VARCHAR(50) NOT NULL, password VARCHAR(255) NOT NULL, email VARCHAR(191) NOT NULL, role ENUM(\'inactive\', \'booking_only\', \'member\', \'responsible\', \'administrator\') DEFAULT \'member\' NOT NULL COMMENT \'(DC2Type:UserRole)\', active_until DATETIME DEFAULT NULL, phone VARCHAR(25) DEFAULT \'\' NOT NULL, birthday DATE DEFAULT NULL, name VARCHAR(191) NOT NULL, door1 TINYINT(1) DEFAULT \'1\' NOT NULL, door2 TINYINT(1) DEFAULT \'1\' NOT NULL, door3 TINYINT(1) DEFAULT \'1\' NOT NULL, door4 TINYINT(1) DEFAULT \'0\' NOT NULL, UNIQUE INDEX UNIQ_8D93D649AA08CB10 (login), INDEX IDX_8D93D64961220EA6 (creator_id), INDEX IDX_8D93D6497E3C61F9 (owner_id), INDEX IDX_8D93D649E37ECFB0 (updater_id), INDEX IDX_8D93D649602AD315 (responsible_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
27
|
|
|
$this->addSql('ALTER TABLE user_tag ADD CONSTRAINT FK_E89FD60861220EA6 FOREIGN KEY (creator_id) REFERENCES user (id)'); |
|
28
|
|
|
$this->addSql('ALTER TABLE user_tag ADD CONSTRAINT FK_E89FD6087E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id)'); |
|
29
|
|
|
$this->addSql('ALTER TABLE user_tag ADD CONSTRAINT FK_E89FD608E37ECFB0 FOREIGN KEY (updater_id) REFERENCES user (id)'); |
|
30
|
|
|
$this->addSql('ALTER TABLE user_tag_user ADD CONSTRAINT FK_83118DFFDF80782C FOREIGN KEY (user_tag_id) REFERENCES user_tag (id) ON DELETE CASCADE'); |
|
31
|
|
|
$this->addSql('ALTER TABLE user_tag_user ADD CONSTRAINT FK_83118DFFA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
|
32
|
|
|
$this->addSql('ALTER TABLE bookable ADD CONSTRAINT FK_A10B812461220EA6 FOREIGN KEY (creator_id) REFERENCES user (id)'); |
|
33
|
|
|
$this->addSql('ALTER TABLE bookable ADD CONSTRAINT FK_A10B81247E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id)'); |
|
34
|
|
|
$this->addSql('ALTER TABLE bookable ADD CONSTRAINT FK_A10B8124E37ECFB0 FOREIGN KEY (updater_id) REFERENCES user (id)'); |
|
35
|
|
|
$this->addSql('ALTER TABLE bookable ADD CONSTRAINT FK_A10B8124C54C8C93 FOREIGN KEY (type_id) REFERENCES bookable_type (id)'); |
|
36
|
|
|
$this->addSql('ALTER TABLE image ADD CONSTRAINT FK_C53D045F61220EA6 FOREIGN KEY (creator_id) REFERENCES user (id)'); |
|
37
|
|
|
$this->addSql('ALTER TABLE image ADD CONSTRAINT FK_C53D045F7E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id)'); |
|
38
|
|
|
$this->addSql('ALTER TABLE image ADD CONSTRAINT FK_C53D045FE37ECFB0 FOREIGN KEY (updater_id) REFERENCES user (id)'); |
|
39
|
|
|
$this->addSql('ALTER TABLE image ADD CONSTRAINT FK_C53D045FEC4F5B2F FOREIGN KEY (bookable_id) REFERENCES bookable (id) ON DELETE CASCADE'); |
|
40
|
|
|
$this->addSql('ALTER TABLE country ADD CONSTRAINT FK_5373C96661220EA6 FOREIGN KEY (creator_id) REFERENCES user (id)'); |
|
41
|
|
|
$this->addSql('ALTER TABLE country ADD CONSTRAINT FK_5373C9667E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id)'); |
|
42
|
|
|
$this->addSql('ALTER TABLE country ADD CONSTRAINT FK_5373C966E37ECFB0 FOREIGN KEY (updater_id) REFERENCES user (id)'); |
|
43
|
|
|
$this->addSql('ALTER TABLE booking ADD CONSTRAINT FK_E00CEDDE61220EA6 FOREIGN KEY (creator_id) REFERENCES user (id)'); |
|
44
|
|
|
$this->addSql('ALTER TABLE booking ADD CONSTRAINT FK_E00CEDDE7E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id)'); |
|
45
|
|
|
$this->addSql('ALTER TABLE booking ADD CONSTRAINT FK_E00CEDDEE37ECFB0 FOREIGN KEY (updater_id) REFERENCES user (id)'); |
|
46
|
|
|
$this->addSql('ALTER TABLE booking ADD CONSTRAINT FK_E00CEDDE602AD315 FOREIGN KEY (responsible_id) REFERENCES user (id) ON DELETE SET NULL'); |
|
47
|
|
|
$this->addSql('ALTER TABLE booking_bookable ADD CONSTRAINT FK_9A3F1FA93301C60 FOREIGN KEY (booking_id) REFERENCES booking (id) ON DELETE CASCADE'); |
|
48
|
|
|
$this->addSql('ALTER TABLE booking_bookable ADD CONSTRAINT FK_9A3F1FA9EC4F5B2F FOREIGN KEY (bookable_id) REFERENCES bookable (id) ON DELETE CASCADE'); |
|
49
|
|
|
$this->addSql('ALTER TABLE bookable_type ADD CONSTRAINT FK_B161DE161220EA6 FOREIGN KEY (creator_id) REFERENCES user (id)'); |
|
50
|
|
|
$this->addSql('ALTER TABLE bookable_type ADD CONSTRAINT FK_B161DE17E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id)'); |
|
51
|
|
|
$this->addSql('ALTER TABLE bookable_type ADD CONSTRAINT FK_B161DE1E37ECFB0 FOREIGN KEY (updater_id) REFERENCES user (id)'); |
|
52
|
|
|
$this->addSql('ALTER TABLE license ADD CONSTRAINT FK_5768F41961220EA6 FOREIGN KEY (creator_id) REFERENCES user (id)'); |
|
53
|
|
|
$this->addSql('ALTER TABLE license ADD CONSTRAINT FK_5768F4197E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id)'); |
|
54
|
|
|
$this->addSql('ALTER TABLE license ADD CONSTRAINT FK_5768F419E37ECFB0 FOREIGN KEY (updater_id) REFERENCES user (id)'); |
|
55
|
|
|
$this->addSql('ALTER TABLE license_bookable ADD CONSTRAINT FK_5D5B1013460F904B FOREIGN KEY (license_id) REFERENCES license (id) ON DELETE CASCADE'); |
|
56
|
|
|
$this->addSql('ALTER TABLE license_bookable ADD CONSTRAINT FK_5D5B1013EC4F5B2F FOREIGN KEY (bookable_id) REFERENCES bookable (id) ON DELETE CASCADE'); |
|
57
|
|
|
$this->addSql('ALTER TABLE license_user ADD CONSTRAINT FK_77C835A460F904B FOREIGN KEY (license_id) REFERENCES license (id) ON DELETE CASCADE'); |
|
58
|
|
|
$this->addSql('ALTER TABLE license_user ADD CONSTRAINT FK_77C835AA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE'); |
|
59
|
|
|
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D64961220EA6 FOREIGN KEY (creator_id) REFERENCES user (id)'); |
|
60
|
|
|
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D6497E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id)'); |
|
61
|
|
|
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D649E37ECFB0 FOREIGN KEY (updater_id) REFERENCES user (id)'); |
|
62
|
|
|
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D649602AD315 FOREIGN KEY (responsible_id) REFERENCES user (id) ON DELETE SET NULL'); |
|
63
|
|
|
$this->addSql('CREATE TABLE bookable_metadata (id INT AUTO_INCREMENT NOT NULL, creator_id INT DEFAULT NULL, owner_id INT DEFAULT NULL, updater_id INT DEFAULT NULL, bookable_id INT DEFAULT NULL, creation_date DATETIME DEFAULT NULL, update_date DATETIME DEFAULT NULL, value VARCHAR(191) DEFAULT \'\' NOT NULL, name VARCHAR(191) NOT NULL, INDEX IDX_F11FB12E61220EA6 (creator_id), INDEX IDX_F11FB12E7E3C61F9 (owner_id), INDEX IDX_F11FB12EE37ECFB0 (updater_id), INDEX IDX_F11FB12EEC4F5B2F (bookable_id), UNIQUE INDEX unique_name (name, bookable_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB'); |
|
64
|
|
|
$this->addSql('ALTER TABLE bookable_metadata ADD CONSTRAINT FK_F11FB12E61220EA6 FOREIGN KEY (creator_id) REFERENCES user (id)'); |
|
65
|
|
|
$this->addSql('ALTER TABLE bookable_metadata ADD CONSTRAINT FK_F11FB12E7E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id)'); |
|
66
|
|
|
$this->addSql('ALTER TABLE bookable_metadata ADD CONSTRAINT FK_F11FB12EE37ECFB0 FOREIGN KEY (updater_id) REFERENCES user (id)'); |
|
67
|
|
|
$this->addSql('ALTER TABLE bookable_metadata ADD CONSTRAINT FK_F11FB12EEC4F5B2F FOREIGN KEY (bookable_id) REFERENCES bookable (id) ON DELETE CASCADE'); |
|
68
|
|
|
|
|
69
|
|
|
$this->addSql('INSERT INTO country (id, code, name) VALUES |
|
70
|
|
|
(1, "CH", "Suisse"), |
|
71
|
|
|
(2, "FR", "France"), |
|
72
|
|
|
(3, "AU", "Australie"), |
|
73
|
|
|
(4, "AT", "Autriche"), |
|
74
|
|
|
(5, "BE", "Belgique"), |
|
75
|
|
|
(6, "CA", "Canada"), |
|
76
|
|
|
(7, "CZ", "République tchèque"), |
|
77
|
|
|
(8, "DK", "Danemark"), |
|
78
|
|
|
(9, "FI", "Finlande"), |
|
79
|
|
|
(10, "DE", "Allemagne"), |
|
80
|
|
|
(11, "GR", "Grèce"), |
|
81
|
|
|
(12, "HU", "Hongrie"), |
|
82
|
|
|
(13, "IS", "Islande"), |
|
83
|
|
|
(14, "IE", "Irlande"), |
|
84
|
|
|
(15, "IT", "Italie"), |
|
85
|
|
|
(16, "JP", "Japon"), |
|
86
|
|
|
(17, "LU", "Luxembourg"), |
|
87
|
|
|
(18, "MX", "Mexique"), |
|
88
|
|
|
(19, "NL", "Pays-Bas"), |
|
89
|
|
|
(20, "NZ", "Nouvelle-Zélande"), |
|
90
|
|
|
(21, "NO", "Norvège"), |
|
91
|
|
|
(22, "PL", "Pologne"), |
|
92
|
|
|
(23, "PT", "Portugal"), |
|
93
|
|
|
(24, "SK", "Slovaquie"), |
|
94
|
|
|
(25, "KR", "Corée du Sud"), |
|
95
|
|
|
(26, "ES", "Espagne"), |
|
96
|
|
|
(27, "SE", "Suède"), |
|
97
|
|
|
(28, "TR", "Turquie"), |
|
98
|
|
|
(29, "GB", "Angleterre"), |
|
99
|
|
|
(30, "US", "États-Unis"), |
|
100
|
|
|
(31, "AX", "Îles Åland"), |
|
101
|
|
|
(32, "AF", "Afghanistan"), |
|
102
|
|
|
(33, "AL", "Albanie"), |
|
103
|
|
|
(34, "DZ", "Algérie"), |
|
104
|
|
|
(35, "AS", "Samoa américaines"), |
|
105
|
|
|
(36, "AD", "Andorre"), |
|
106
|
|
|
(37, "AO", "Angola"), |
|
107
|
|
|
(38, "AI", "Anguilla"), |
|
108
|
|
|
(39, "AQ", "Antarctique"), |
|
109
|
|
|
(40, "AG", "Antigua et Barbuda"), |
|
110
|
|
|
(41, "AR", "Argentine"), |
|
111
|
|
|
(42, "AM", "Arménie"), |
|
112
|
|
|
(43, "AW", "Aruba"), |
|
113
|
|
|
(44, "AZ", "Azerbaïdjan"), |
|
114
|
|
|
(45, "BS", "Bahamas"), |
|
115
|
|
|
(46, "BH", "Bahreïn"), |
|
116
|
|
|
(47, "BD", "Bangladesh"), |
|
117
|
|
|
(48, "BB", "Barbade"), |
|
118
|
|
|
(49, "BY", "Biélorussie"), |
|
119
|
|
|
(50, "BZ", "Belize"), |
|
120
|
|
|
(51, "BJ", "Bénin"), |
|
121
|
|
|
(52, "BM", "Bermudes"), |
|
122
|
|
|
(53, "BT", "Bhutan"), |
|
123
|
|
|
(54, "BO", "Bolivie"), |
|
124
|
|
|
(55, "BQ", "Bonaire, Saint-Eustache et Saba"), |
|
125
|
|
|
(56, "BA", "Bosnie-Herzégovine"), |
|
126
|
|
|
(57, "BW", "Botswana"), |
|
127
|
|
|
(58, "BV", "Île Bouvet"), |
|
128
|
|
|
(59, "BR", "Brésil"), |
|
129
|
|
|
(60, "IO", "Territoire britannique de l\'océan Indien"), |
|
130
|
|
|
(61, "VG", "Îles Vierges"), |
|
131
|
|
|
(62, "BN", "Brunéi Darussalam"), |
|
132
|
|
|
(63, "BG", "Bulgarie"), |
|
133
|
|
|
(64, "BF", "Burkina Faso"), |
|
134
|
|
|
(65, "BI", "Burundi"), |
|
135
|
|
|
(66, "KH", "Cambodge"), |
|
136
|
|
|
(67, "CM", "Cameroun"), |
|
137
|
|
|
(68, "CV", "Cap-Vert"), |
|
138
|
|
|
(69, "KY", "Îles Caïmans"), |
|
139
|
|
|
(70, "CF", "Centrafrique"), |
|
140
|
|
|
(71, "TD", "Tchad"), |
|
141
|
|
|
(72, "CL", "Chili"), |
|
142
|
|
|
(73, "CN", "Chine"), |
|
143
|
|
|
(74, "CX", "Île Christmas"), |
|
144
|
|
|
(75, "CC", "Îles Cocos"), |
|
145
|
|
|
(76, "CO", "Colombie"), |
|
146
|
|
|
(77, "KM", "Comores"), |
|
147
|
|
|
(78, "CK", "Îles Cook"), |
|
148
|
|
|
(79, "CR", "Costa Rica"), |
|
149
|
|
|
(80, "HR", "Croatie"), |
|
150
|
|
|
(81, "CU", "Cuba"), |
|
151
|
|
|
(82, "CW", "Curaçao"), |
|
152
|
|
|
(83, "CY", "Chypre"), |
|
153
|
|
|
(84, "CD", "République démocratique du Congo"), |
|
154
|
|
|
(85, "DJ", "Djibouti"), |
|
155
|
|
|
(86, "DM", "Dominique"), |
|
156
|
|
|
(87, "DO", "République Dominicaine"), |
|
157
|
|
|
(88, "TL", "Timor Oriental"), |
|
158
|
|
|
(89, "EC", "Équateur"), |
|
159
|
|
|
(90, "EG", "Égypte"), |
|
160
|
|
|
(91, "SV", "Salvador"), |
|
161
|
|
|
(92, "GQ", "Guinée équatoriale"), |
|
162
|
|
|
(93, "ER", "Érythrée"), |
|
163
|
|
|
(94, "EE", "Estonie"), |
|
164
|
|
|
(95, "ET", "Éthiopie"), |
|
165
|
|
|
(96, "FK", "Îles Malouines"), |
|
166
|
|
|
(97, "FO", "Îles Féroé"), |
|
167
|
|
|
(98, "FJ", "Fidji"), |
|
168
|
|
|
(99, "GF", "Guyane"), |
|
169
|
|
|
(100, "PF", "Polynésie Française"), |
|
170
|
|
|
(101, "TF", "Terres australes françaises"), |
|
171
|
|
|
(102, "GA", "Gabon"), |
|
172
|
|
|
(103, "GM", "Gambie"), |
|
173
|
|
|
(104, "GE", "Géorgie"), |
|
174
|
|
|
(105, "GH", "Ghana"), |
|
175
|
|
|
(106, "GI", "Gibraltar"), |
|
176
|
|
|
(107, "GL", "Groenland"), |
|
177
|
|
|
(108, "GD", "Grenade"), |
|
178
|
|
|
(109, "GP", "Guadeloupe"), |
|
179
|
|
|
(110, "GU", "Guam"), |
|
180
|
|
|
(111, "GT", "Guatemala"), |
|
181
|
|
|
(112, "GG", "Guernesey"), |
|
182
|
|
|
(113, "GN", "Guinée"), |
|
183
|
|
|
(114, "GW", "Guinée-Bissau"), |
|
184
|
|
|
(115, "GY", "Guyana"), |
|
185
|
|
|
(116, "HT", "Haïti"), |
|
186
|
|
|
(117, "HM", "Île Heard et îles McDonald"), |
|
187
|
|
|
(118, "HN", "Honduras"), |
|
188
|
|
|
(119, "HK", "Hong Kong"), |
|
189
|
|
|
(120, "IN", "Inde"), |
|
190
|
|
|
(121, "ID", "Indonésie"), |
|
191
|
|
|
(122, "IR", "Iran"), |
|
192
|
|
|
(123, "IQ", "Irak"), |
|
193
|
|
|
(124, "IM", "Île de Man"), |
|
194
|
|
|
(125, "IL", "Israël"), |
|
195
|
|
|
(126, "CI", "Côte d\'Ivoire"), |
|
196
|
|
|
(127, "JM", "Jamaïque"), |
|
197
|
|
|
(128, "JE", "Jersey"), |
|
198
|
|
|
(129, "JO", "Jordanie"), |
|
199
|
|
|
(130, "KZ", "Kazakhstan"), |
|
200
|
|
|
(131, "KE", "Kenya"), |
|
201
|
|
|
(132, "KI", "Kiribati"), |
|
202
|
|
|
(133, "XK", "Kosovo"), |
|
203
|
|
|
(134, "KW", "Koweït"), |
|
204
|
|
|
(135, "KG", "Kirghizistan"), |
|
205
|
|
|
(136, "LA", "Laos"), |
|
206
|
|
|
(137, "LV", "Lettonie"), |
|
207
|
|
|
(138, "LB", "Liban"), |
|
208
|
|
|
(139, "LS", "Lesotho"), |
|
209
|
|
|
(140, "LR", "Liberia"), |
|
210
|
|
|
(141, "LY", "Libye"), |
|
211
|
|
|
(142, "LI", "Liechtenstein"), |
|
212
|
|
|
(143, "LT", "Lituanie"), |
|
213
|
|
|
(144, "MO", "Macao"), |
|
214
|
|
|
(145, "MK", "Macédoine"), |
|
215
|
|
|
(146, "MG", "Madagascar"), |
|
216
|
|
|
(147, "MW", "Malawi"), |
|
217
|
|
|
(148, "MY", "Malaisie"), |
|
218
|
|
|
(149, "MV", "Maldives"), |
|
219
|
|
|
(150, "ML", "Mali"), |
|
220
|
|
|
(151, "MT", "Malte"), |
|
221
|
|
|
(152, "MH", "Îles Marshall"), |
|
222
|
|
|
(153, "MQ", "Martinique"), |
|
223
|
|
|
(154, "MR", "Mauritanie"), |
|
224
|
|
|
(155, "MU", "Maurice"), |
|
225
|
|
|
(156, "YT", "Mayotte"), |
|
226
|
|
|
(157, "FM", "Micronésie"), |
|
227
|
|
|
(158, "MD", "Moldavie"), |
|
228
|
|
|
(159, "MC", "Monaco"), |
|
229
|
|
|
(160, "MN", "Mongolie"), |
|
230
|
|
|
(161, "ME", "Monténégro"), |
|
231
|
|
|
(162, "MS", "Montserrat"), |
|
232
|
|
|
(163, "MA", "Maroc"), |
|
233
|
|
|
(164, "MZ", "Mozambique"), |
|
234
|
|
|
(165, "MM", "Myanmar"), |
|
235
|
|
|
(166, "NA", "Namibie"), |
|
236
|
|
|
(167, "NR", "Nauru"), |
|
237
|
|
|
(168, "NP", "Népal"), |
|
238
|
|
|
(169, "AN", "Antilles néerlandaises"), |
|
239
|
|
|
(170, "NC", "Nouvelle-Calédonie"), |
|
240
|
|
|
(171, "NI", "Nicaragua"), |
|
241
|
|
|
(172, "NE", "Niger"), |
|
242
|
|
|
(173, "NG", "Nigeria"), |
|
243
|
|
|
(174, "NU", "Nioué"), |
|
244
|
|
|
(175, "NF", "Île Norfolk"), |
|
245
|
|
|
(176, "KP", "Corée du Nord"), |
|
246
|
|
|
(177, "MP", "Îles Mariannes du Nord"), |
|
247
|
|
|
(178, "OM", "Oman"), |
|
248
|
|
|
(179, "PK", "Pakistan"), |
|
249
|
|
|
(180, "PW", "Palaos"), |
|
250
|
|
|
(181, "PS", "Territoire palestinien"), |
|
251
|
|
|
(182, "PA", "Panama"), |
|
252
|
|
|
(183, "PG", "Papouasie-Nouvelle Guinée"), |
|
253
|
|
|
(184, "PY", "Paraguay"), |
|
254
|
|
|
(185, "PE", "Pérou"), |
|
255
|
|
|
(186, "PH", "Philippines"), |
|
256
|
|
|
(187, "PN", "Pitcairn"), |
|
257
|
|
|
(188, "PR", "Porto Rico"), |
|
258
|
|
|
(189, "QA", "Qatar"), |
|
259
|
|
|
(190, "RE", "Réunion"), |
|
260
|
|
|
(191, "CG", "Congo-Brazzaville"), |
|
261
|
|
|
(192, "RO", "Roumanie"), |
|
262
|
|
|
(193, "RU", "Russie"), |
|
263
|
|
|
(194, "RW", "Rwanda"), |
|
264
|
|
|
(195, "ST", "São Tomé-et-Príncipe"), |
|
265
|
|
|
(196, "BL", "Saint-Barthélémy"), |
|
266
|
|
|
(197, "SH", "Sainte-Hélène"), |
|
267
|
|
|
(198, "KN", "Saint-Christophe-et-Niévès"), |
|
268
|
|
|
(199, "LC", "Sainte-Lucie"), |
|
269
|
|
|
(200, "MF", "Saint-Martin"), |
|
270
|
|
|
(201, "PM", "Saint-Pierre et Miquelon"), |
|
271
|
|
|
(202, "VC", "Saint-Vincent-et-les Grenadines"), |
|
272
|
|
|
(203, "WS", "Samoa"), |
|
273
|
|
|
(204, "SM", "Saint-Marin"), |
|
274
|
|
|
(205, "SA", "Arabie saoudite"), |
|
275
|
|
|
(206, "SN", "Sénégal"), |
|
276
|
|
|
(207, "RS", "Serbie"), |
|
277
|
|
|
(208, "SC", "Seychelles"), |
|
278
|
|
|
(209, "SL", "Sierra Leone"), |
|
279
|
|
|
(210, "SG", "Singapour"), |
|
280
|
|
|
(211, "SX", "Saint-Martin"), |
|
281
|
|
|
(212, "SI", "Slovénie"), |
|
282
|
|
|
(213, "SB", "Îles Salomon"), |
|
283
|
|
|
(214, "SO", "Somalie"), |
|
284
|
|
|
(215, "ZA", "Afrique du Sud"), |
|
285
|
|
|
(216, "GS", "Géorgie du Sud et les îles Sandwich du Sud"), |
|
286
|
|
|
(217, "SS", "Sud-Soudan"), |
|
287
|
|
|
(218, "LK", "Sri Lanka"), |
|
288
|
|
|
(219, "SD", "Soudan"), |
|
289
|
|
|
(220, "SR", "Surinam"), |
|
290
|
|
|
(221, "SJ", "Svalbard et Île Jan Mayen"), |
|
291
|
|
|
(222, "SZ", "Swaziland"), |
|
292
|
|
|
(223, "SY", "Syrie"), |
|
293
|
|
|
(224, "TW", "Taïwan"), |
|
294
|
|
|
(225, "TJ", "Tadjikistan"), |
|
295
|
|
|
(226, "TZ", "Tanzanie"), |
|
296
|
|
|
(227, "TH", "Thaïlande"), |
|
297
|
|
|
(228, "TG", "République Togolaise"), |
|
298
|
|
|
(229, "TK", "Tokelau"), |
|
299
|
|
|
(230, "TO", "Tonga"), |
|
300
|
|
|
(231, "TT", "Trinidad et Tobago"), |
|
301
|
|
|
(232, "TN", "Tunisie"), |
|
302
|
|
|
(233, "TM", "Turkménistan"), |
|
303
|
|
|
(234, "TC", "Îles Turques-et-Caïques"), |
|
304
|
|
|
(235, "TV", "Tuvalu"), |
|
305
|
|
|
(236, "UM", "Îles mineures éloignées des États-Unis"), |
|
306
|
|
|
(237, "VI", "Îles Vierges des États-Unis"), |
|
307
|
|
|
(238, "UG", "Ouganda"), |
|
308
|
|
|
(239, "UA", "Ukraine"), |
|
309
|
|
|
(240, "AE", "Émirats Arabes Unis"), |
|
310
|
|
|
(241, "UY", "Uruguay"), |
|
311
|
|
|
(242, "UZ", "Ouzbékistan"), |
|
312
|
|
|
(243, "VU", "Vanuatu"), |
|
313
|
|
|
(244, "VA", "Vatican"), |
|
314
|
|
|
(245, "VE", "Vénézuéla"), |
|
315
|
|
|
(246, "VN", "Vietnam"), |
|
316
|
|
|
(247, "WF", "Wallis-et-Futuna"), |
|
317
|
|
|
(248, "EH", "Sahara Occidental"), |
|
318
|
|
|
(249, "YE", "Yémen"), |
|
319
|
|
|
(250, "ZM", "Zambie"), |
|
320
|
|
|
(251, "ZW", "Zimbabwe") |
|
321
|
|
|
'); |
|
322
|
|
|
} |
|
323
|
|
|
} |
|
324
|
|
|
|
Ecodev /
my-ichtus
