· 6 years ago · Nov 11, 2019, 03:08 PM
1DROP TABLE IF EXISTS 'sendinblue_country_codes'
2 CREATE TABLE 'sendinblue_country_codes' (
3 `sendinblue_country_code_id` int(11) unsigned NOT NULL auto_increment,
4 `iso_code` varchar(255) NOT NULL default '',
5 `country_prefix` text NOT NULL default '',
6 `status` smallint(6) NOT NULL default '1',
7 `created_time` datetime NULL,
8 `update_time` datetime NULL,
9 PRIMARY KEY (`sendinblue_country_code_id`)
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11
12 INSERT INTO sendinblue_country_codes
13 (`iso_code`, `country_prefix`, `status`, `created_time`, `update_time`)
14 VALUES
15 ('AD', '376', 1, now(), now()),
16 ('AE', '971', 1, now(), now()),
17 ('AF', '93', 1, now(), now()),
18 ('AG', '1268', 1, now(), now()),
19 ('AI', '1264', 1, now(), now()),
20 ('AL', '355', 1, now(), now()),
21 ('AM', '374', 1, now(), now()),
22 ('AN', '599', 1, now(), now()),
23 ('AO', '244', 1, now(), now()),
24 ('AQ', '672', 1, now(), now()),
25 ('AR', '54', 1, now(), now()),
26 ('AS', '1684', 1, now(), now()),
27 ('AT', '43', 1, now(), now()),
28 ('AU', '61', 1, now(), now()),
29 ('AW', '297', 1, now(), now()),
30 ('AZ', '994', 1, now(), now()),
31 ('BA', '387', 1, now(), now()),
32 ('BB', '1246', 1, now(), now()),
33 ('BD', '880', 1, now(), now()),
34 ('BE', '32', 1, now(), now()),
35 ('BF', '226', 1, now(), now()),
36 ('BG', '359', 1, now(), now()),
37 ('BH', '973', 1, now(), now()),
38 ('BI', '257', 1, now(), now()),
39 ('BJ', '229', 1, now(), now()),
40 ('BL', '590', 1, now(), now()),
41 ('BM', '1441', 1, now(), now()),
42 ('BN', '673', 1, now(), now()),
43 ('BO', '591', 1, now(), now()),
44 ('BR', '55', 1, now(), now()),
45 ('BS', '1242', 1, now(), now()),
46 ('BT', '975', 1, now(), now()),
47 ('BW', '267', 1, now(), now()),
48 ('BY', '375', 1, now(), now()),
49 ('BZ', '501', 1, now(), now()),
50 ('CA', '1', 1, now(), now()),
51 ('CC', '61', 1, now(), now()),
52 ('CD', '242', 1, now(), now()),
53 ('CF', '236', 1, now(), now()),
54 ('CG', '242', 1, now(), now()),
55 ('CH', '41', 1, now(), now()),
56 ('CI', '225', 1, now(), now()),
57 ('CK', '682', 1, now(), now()),
58 ('CL', '56', 1, now(), now()),
59 ('CM', '237', 1, now(), now()),
60 ('CN', '86', 1, now(), now()),
61 ('CO', '57', 1, now(), now()),
62 ('CR', '506', 1, now(), now()),
63 ('CU', '53', 1, now(), now()),
64 ('CV', '238', 1, now(), now()),
65 ('CX', '61', 1, now(), now()),
66 ('CY', '357', 1, now(), now()),
67 ('CZ', '420', 1, now(), now()),
68 ('DE', '49', 1, now(), now()),
69 ('DJ', '253', 1, now(), now()),
70 ('DK', '45', 1, now(), now()),
71 ('DM', '1767', 1, now(), now()),
72 ('DO', '1809', 1, now(), now()),
73 ('DZ', '213', 1, now(), now()),
74 ('EC', '593', 1, now(), now()),
75 ('EE', '372', 1, now(), now()),
76 ('EG', '20', 1, now(), now()),
77 ('EH', '212', 1, now(), now()),
78 ('ER', '291', 1, now(), now()),
79 ('ES', '34', 1, now(), now()),
80 ('ET', '251', 1, now(), now()),
81 ('FI', '358', 1, now(), now()),
82 ('FJ', '679', 1, now(), now()),
83 ('FK', '500', 1, now(), now()),
84 ('FM', '691', 1, now(), now()),
85 ('FO', '298', 1, now(), now()),
86 ('FR', '33', 1, now(), now()),
87 ('GA', '241', 1, now(), now()),
88 ('GB', '44', 1, now(), now()),
89 ('GD', '1473', 1, now(), now()),
90 ('GE', '995', 1, now(), now()),
91 ('GF', '594', 1, now(), now()),
92 ('GH', '233', 1, now(), now()),
93 ('GI', '350', 1, now(), now()),
94 ('GL', '299', 1, now(), now()),
95 ('GM', '220', 1, now(), now()),
96 ('GN', '224', 1, now(), now()),
97 ('GP', '590', 1, now(), now()),
98 ('GQ', '240', 1, now(), now()),
99 ('GR', '30', 1, now(), now()),
100 ('GT', '502', 1, now(), now()),
101 ('GU', '1671', 1, now(), now()),
102 ('GW', '245', 1, now(), now()),
103 ('GY', '592', 1, now(), now()),
104 ('HK', '852', 1, now(), now()),
105 ('HN', '504', 1, now(), now()),
106 ('HR', '385', 1, now(), now()),
107 ('HT', '509', 1, now(), now()),
108 ('HU', '36', 1, now(), now()),
109 ('ID', '62', 1, now(), now()),
110 ('IE', '353', 1, now(), now()),
111 ('IL', '972', 1, now(), now()),
112 ('IM', '44', 1, now(), now()),
113 ('IN', '91', 1, now(), now()),
114 ('IO', '246', 1, now(), now()),
115 ('IQ', '964', 1, now(), now()),
116 ('IR', '98', 1, now(), now()),
117 ('IS', '354', 1, now(), now()),
118 ('IT', '39', 1, now(), now()),
119 ('JE', '44', 1, now(), now()),
120 ('JM', '1876', 1, now(), now()),
121 ('JO', '962', 1, now(), now()),
122 ('JP', '81', 1, now(), now()),
123 ('KE', '254', 1, now(), now()),
124 ('KG', '996', 1, now(), now()),
125 ('KH', '855', 1, now(), now()),
126 ('KI', '686', 1, now(), now()),
127 ('KM', '269', 1, now(), now()),
128 ('KN', '1869', 1, now(), now()),
129 ('KP', '850', 1, now(), now()),
130 ('KR', '82', 1, now(), now()),
131 ('KW', '965', 1, now(), now()),
132 ('KY', '1345', 1, now(), now()),
133 ('KZ', '7', 1, now(), now()),
134 ('LA', '856', 1, now(), now()),
135 ('LB', '961', 1, now(), now()),
136 ('LC', '1758', 1, now(), now()),
137 ('LI', '423', 1, now(), now()),
138 ('LK', '94', 1, now(), now()),
139 ('LR', '231', 1, now(), now()),
140 ('LS', '266', 1, now(), now()),
141 ('LT', '370', 1, now(), now()),
142 ('LU', '352', 1, now(), now()),
143 ('LV', '371', 1, now(), now()),
144 ('LY', '218', 1, now(), now()),
145 ('MA', '212', 1, now(), now()),
146 ('MC', '377', 1, now(), now()),
147 ('MD', '373', 1, now(), now()),
148 ('ME', '382', 1, now(), now()),
149 ('MF', '1599', 1, now(), now()),
150 ('MG', '261', 1, now(), now()),
151 ('MH', '692', 1, now(), now()),
152 ('MK', '389', 1, now(), now()),
153 ('ML', '223', 1, now(), now()),
154 ('MN', '976', 1, now(), now()),
155 ('MO', '853', 1, now(), now()),
156 ('MP', '1670', 1, now(), now()),
157 ('MQ', '596', 1, now(), now()),
158 ('MR', '222', 1, now(), now()),
159 ('MS', '1664', 1, now(), now()),
160 ('MT', '356', 1, now(), now()),
161 ('MU', '230', 1, now(), now()),
162 ('MV', '960', 1, now(), now()),
163 ('MW', '265', 1, now(), now()),
164 ('MX', '52', 1, now(), now()),
165 ('MY', '60', 1, now(), now()),
166 ('MZ', '258', 1, now(), now()),
167 ('NA', '264', 1, now(), now()),
168 ('NC', '687', 1, now(), now()),
169 ('NE', '227', 1, now(), now()),
170 ('NF', '672', 1, now(), now()),
171 ('NG', '234', 1, now(), now()),
172 ('NI', '505', 1, now(), now()),
173 ('NL', '31', 1, now(), now()),
174 ('NO', '47', 1, now(), now()),
175 ('NP', '977', 1, now(), now()),
176 ('NR', '674', 1, now(), now()),
177 ('NU', '683', 1, now(), now()),
178 ('NZ', '64', 1, now(), now()),
179 ('OM', '968', 1, now(), now()),
180 ('PA', '507', 1, now(), now()),
181 ('PE', '51', 1, now(), now()),
182 ('PF', '689', 1, now(), now()),
183 ('PG', '675', 1, now(), now()),
184 ('PH', '63', 1, now(), now()),
185 ('PK', '92', 1, now(), now()),
186 ('PL', '48', 1, now(), now()),
187 ('PM', '508', 1, now(), now()),
188 ('PN', '870', 1, now(), now()),
189 ('PR', '1', 1, now(), now()),
190 ('PS', '970', 1, now(), now()),
191 ('PT', '351', 1, now(), now()),
192 ('PW', '680', 1, now(), now()),
193 ('PY', '595', 1, now(), now()),
194 ('QA', '974', 1, now(), now()),
195 ('RE', '262', 1, now(), now()),
196 ('RO', '40', 1, now(), now()),
197 ('RS', '381', 1, now(), now()),
198 ('RU', '7', 1, now(), now()),
199 ('RW', '250', 1, now(), now()),
200 ('SA', '966', 1, now(), now()),
201 ('SB', '677', 1, now(), now()),
202 ('SC', '248', 1, now(), now()),
203 ('SD', '249', 1, now(), now()),
204 ('SE', '46', 1, now(), now()),
205 ('SG', '65', 1, now(), now()),
206 ('SH', '290', 1, now(), now()),
207 ('SI', '386', 1, now(), now()),
208 ('SJ', '47', 1, now(), now()),
209 ('SK', '421', 1, now(), now()),
210 ('SL', '232', 1, now(), now()),
211 ('SM', '378', 1, now(), now()),
212 ('SN', '221', 1, now(), now()),
213 ('SO', '252', 1, now(), now()),
214 ('SR', '597', 1, now(), now()),
215 ('ST', '239', 1, now(), now()),
216 ('SV', '503', 1, now(), now()),
217 ('SY', '963', 1, now(), now()),
218 ('SZ', '268', 1, now(), now()),
219 ('TC', '1649', 1, now(), now()),
220 ('TD', '235', 1, now(), now()),
221 ('TF', '262', 1, now(), now()),
222 ('TG', '228', 1, now(), now()),
223 ('TH', '66', 1, now(), now()),
224 ('TJ', '992', 1, now(), now()),
225 ('TK', '690', 1, now(), now()),
226 ('TL', '670', 1, now(), now()),
227 ('TM', '993', 1, now(), now()),
228 ('TN', '216', 1, now(), now()),
229 ('TO', '676', 1, now(), now()),
230 ('TR', '90', 1, now(), now()),
231 ('TT', '1868', 1, now(), now()),
232 ('TV', '688', 1, now(), now()),
233 ('TW', '886', 1, now(), now()),
234 ('TZ', '255', 1, now(), now()),
235 ('UA', '380', 1, now(), now()),
236 ('UG', '256', 1, now(), now()),
237 ('UM', '1', 1, now(), now()),
238 ('US', '1', 1, now(), now()),
239 ('UY', '598', 1, now(), now()),
240 ('UZ', '998', 1, now(), now()),
241 ('VA', '39', 1, now(), now()),
242 ('VC', '1784', 1, now(), now()),
243 ('VE', '58', 1, now(), now()),
244 ('VG', '1284', 1, now(), now()),
245 ('VI', '1340', 1, now(), now()),
246 ('VN', '84', 1, now(), now()),
247 ('VU', '678', 1, now(), now()),
248 ('WF', '681', 1, now(), now()),
249 ('WS', '685', 1, now(), now()),
250 ('YE', '967', 1, now(), now()),
251 ('YT', '262', 1, now(), now()),
252 ('ZA', '27', 1, now(), now()),
253 ('ZM', '260', 1, now(), now()),
254 ('ZW', '263', 1, now(), now());