· 9 years ago · Oct 17, 2016, 10:44 AM
1-- ----------------------------
2-- Table structure for country_codes
3-- ----------------------------
4DROP TABLE IF EXISTS "public"."country_codes";
5CREATE TABLE "public"."country_codes" (
6 "id" int4 NOT NULL DEFAULT nextval('country_codes_id_seq'::regclass),
7 "country" varchar(255) NOT NULL COLLATE "default",
8 "dialing_code" int4 NOT NULL,
9 "country_code" varchar(255) NOT NULL COLLATE "default"
10)
11WITH (OIDS=FALSE);
12ALTER TABLE "public"."country_codes" OWNER TO "eatmedev";
13
14-- ----------------------------
15-- Records of country_codes
16-- ----------------------------
17BEGIN;
18INSERT INTO "public"."country_codes" VALUES ('1', 'Afghanistan', '93', 'AF');
19INSERT INTO "public"."country_codes" VALUES ('2', 'Albania', '355', 'AL');
20INSERT INTO "public"."country_codes" VALUES ('3', 'Algeria', '213', 'DZ');
21INSERT INTO "public"."country_codes" VALUES ('4', 'American Samoa', '1', 'AS');
22INSERT INTO "public"."country_codes" VALUES ('5', 'Andorra', '376', 'AD');
23INSERT INTO "public"."country_codes" VALUES ('6', 'Angola', '244', 'AO');
24INSERT INTO "public"."country_codes" VALUES ('7', 'Anguilla', '1', 'AI');
25INSERT INTO "public"."country_codes" VALUES ('8', 'Antigua', '1', 'AG');
26INSERT INTO "public"."country_codes" VALUES ('9', 'Argentina', '54', 'AR');
27INSERT INTO "public"."country_codes" VALUES ('10', 'Armenia', '374', 'AM');
28INSERT INTO "public"."country_codes" VALUES ('11', 'Aruba', '297', 'AW');
29INSERT INTO "public"."country_codes" VALUES ('12', 'Australia', '61', 'AU');
30INSERT INTO "public"."country_codes" VALUES ('13', 'Austria', '43', 'AT');
31INSERT INTO "public"."country_codes" VALUES ('14', 'Azerbaijan', '994', 'AZ');
32INSERT INTO "public"."country_codes" VALUES ('15', 'Bahrain', '973', 'BH');
33INSERT INTO "public"."country_codes" VALUES ('16', 'Bangladesh', '880', 'BD');
34INSERT INTO "public"."country_codes" VALUES ('17', 'Barbados', '1', 'BB');
35INSERT INTO "public"."country_codes" VALUES ('18', 'Belarus', '375', 'BY');
36INSERT INTO "public"."country_codes" VALUES ('19', 'Belgium', '32', 'BE');
37INSERT INTO "public"."country_codes" VALUES ('20', 'Belize', '501', 'BZ');
38INSERT INTO "public"."country_codes" VALUES ('21', 'Benin', '229', 'BJ');
39INSERT INTO "public"."country_codes" VALUES ('22', 'Bermuda', '1', 'BM');
40INSERT INTO "public"."country_codes" VALUES ('23', 'Bhutan', '975', 'BT');
41INSERT INTO "public"."country_codes" VALUES ('24', 'Bolivia', '591', 'BO');
42INSERT INTO "public"."country_codes" VALUES ('25', 'Bonaire, Sint Eustatius and Saba', '599', 'BQ');
43INSERT INTO "public"."country_codes" VALUES ('26', 'Bosnia and Herzegovina', '387', 'BA');
44INSERT INTO "public"."country_codes" VALUES ('27', 'Botswana', '267', 'BW');
45INSERT INTO "public"."country_codes" VALUES ('28', 'Brazil', '55', 'BR');
46INSERT INTO "public"."country_codes" VALUES ('29', 'British Indian Ocean Territory', '246', 'IO');
47INSERT INTO "public"."country_codes" VALUES ('30', 'British Virgin Islands', '1', 'VG');
48INSERT INTO "public"."country_codes" VALUES ('31', 'Brunei', '673', 'BN');
49INSERT INTO "public"."country_codes" VALUES ('32', 'Bulgaria', '359', 'BG');
50INSERT INTO "public"."country_codes" VALUES ('33', 'Burkina Faso', '226', 'BF');
51INSERT INTO "public"."country_codes" VALUES ('34', 'Burundi', '257', 'BI');
52INSERT INTO "public"."country_codes" VALUES ('35', 'Cambodia', '855', 'KH');
53INSERT INTO "public"."country_codes" VALUES ('36', 'Cameroon', '237', 'CM');
54INSERT INTO "public"."country_codes" VALUES ('37', 'Canada', '1', 'CA');
55INSERT INTO "public"."country_codes" VALUES ('38', 'Cape Verde', '238', 'CV');
56INSERT INTO "public"."country_codes" VALUES ('39', 'Cayman Islands', '1', 'KY');
57INSERT INTO "public"."country_codes" VALUES ('40', 'Central African Republic', '236', 'CF');
58INSERT INTO "public"."country_codes" VALUES ('41', 'Chad', '235', 'TD');
59INSERT INTO "public"."country_codes" VALUES ('42', 'Chile', '56', 'CL');
60INSERT INTO "public"."country_codes" VALUES ('43', 'China', '86', 'CN');
61INSERT INTO "public"."country_codes" VALUES ('44', 'Colombia', '57', 'CO');
62INSERT INTO "public"."country_codes" VALUES ('45', 'Comoros', '269', 'KM');
63INSERT INTO "public"."country_codes" VALUES ('46', 'Cook Islands', '682', 'CK');
64INSERT INTO "public"."country_codes" VALUES ('47', 'Costa Rica', '506', 'CR');
65INSERT INTO "public"."country_codes" VALUES ('48', 'Côte d''Ivoire', '225', 'CI');
66INSERT INTO "public"."country_codes" VALUES ('49', 'Croatia', '385', 'HR');
67INSERT INTO "public"."country_codes" VALUES ('50', 'Cuba', '53', 'CU');
68INSERT INTO "public"."country_codes" VALUES ('51', 'Curaçao', '599', 'CW');
69INSERT INTO "public"."country_codes" VALUES ('52', 'Cyprus', '357', 'CY');
70INSERT INTO "public"."country_codes" VALUES ('53', 'Czech Republic', '420', 'CZ');
71INSERT INTO "public"."country_codes" VALUES ('54', 'Democratic Republic of the Congo', '243', 'CD');
72INSERT INTO "public"."country_codes" VALUES ('55', 'Denmark', '45', 'DK');
73INSERT INTO "public"."country_codes" VALUES ('56', 'Djibouti', '253', 'DJ');
74INSERT INTO "public"."country_codes" VALUES ('57', 'Dominica', '1', 'DM');
75INSERT INTO "public"."country_codes" VALUES ('58', 'Dominican Republic', '1', 'DO');
76INSERT INTO "public"."country_codes" VALUES ('59', 'Ecuador', '593', 'EC');
77INSERT INTO "public"."country_codes" VALUES ('60', 'Egypt', '20', 'EG');
78INSERT INTO "public"."country_codes" VALUES ('61', 'El Salvador', '503', 'SV');
79INSERT INTO "public"."country_codes" VALUES ('62', 'Equatorial Guinea', '240', 'GQ');
80INSERT INTO "public"."country_codes" VALUES ('63', 'Eritrea', '291', 'ER');
81INSERT INTO "public"."country_codes" VALUES ('64', 'Estonia', '372', 'EE');
82INSERT INTO "public"."country_codes" VALUES ('65', 'Ethiopia', '251', 'ET');
83INSERT INTO "public"."country_codes" VALUES ('66', 'Falkland Islands', '500', 'FK');
84INSERT INTO "public"."country_codes" VALUES ('67', 'Faroe Islands', '298', 'FO');
85INSERT INTO "public"."country_codes" VALUES ('68', 'Federated States of Micronesia', '691', 'FM');
86INSERT INTO "public"."country_codes" VALUES ('69', 'Fiji', '679', 'FJ');
87INSERT INTO "public"."country_codes" VALUES ('70', 'Finland', '358', 'FI');
88INSERT INTO "public"."country_codes" VALUES ('71', 'France', '33', 'FR');
89INSERT INTO "public"."country_codes" VALUES ('72', 'French Guiana', '594', 'GF');
90INSERT INTO "public"."country_codes" VALUES ('73', 'French Polynesia', '689', 'PF');
91INSERT INTO "public"."country_codes" VALUES ('74', 'Gabon', '241', 'GA');
92INSERT INTO "public"."country_codes" VALUES ('75', 'Georgia', '995', 'GE');
93INSERT INTO "public"."country_codes" VALUES ('76', 'Germany', '49', 'DE');
94INSERT INTO "public"."country_codes" VALUES ('77', 'Ghana', '233', 'GH');
95INSERT INTO "public"."country_codes" VALUES ('78', 'Gibraltar', '350', 'GI');
96INSERT INTO "public"."country_codes" VALUES ('79', 'Greece', '30', 'GR');
97INSERT INTO "public"."country_codes" VALUES ('80', 'Greenland', '299', 'GL');
98INSERT INTO "public"."country_codes" VALUES ('81', 'Grenada', '1', 'GD');
99INSERT INTO "public"."country_codes" VALUES ('82', 'Guadeloupe', '590', 'GP');
100INSERT INTO "public"."country_codes" VALUES ('83', 'Guam', '1', 'GU');
101INSERT INTO "public"."country_codes" VALUES ('84', 'Guatemala', '502', 'GT');
102INSERT INTO "public"."country_codes" VALUES ('85', 'Guernsey', '44', 'GG');
103INSERT INTO "public"."country_codes" VALUES ('86', 'Guinea', '224', 'GN');
104INSERT INTO "public"."country_codes" VALUES ('87', 'Guinea-Bissau', '245', 'GW');
105INSERT INTO "public"."country_codes" VALUES ('88', 'Guyana', '592', 'GY');
106INSERT INTO "public"."country_codes" VALUES ('89', 'Haiti', '509', 'HT');
107INSERT INTO "public"."country_codes" VALUES ('90', 'Honduras', '504', 'HN');
108INSERT INTO "public"."country_codes" VALUES ('91', 'Hong Kong', '852', 'HK');
109INSERT INTO "public"."country_codes" VALUES ('92', 'Hungary', '36', 'HU');
110INSERT INTO "public"."country_codes" VALUES ('93', 'Iceland', '354', 'IS');
111INSERT INTO "public"."country_codes" VALUES ('94', 'India', '91', 'IN');
112INSERT INTO "public"."country_codes" VALUES ('95', 'Indonesia', '62', 'ID');
113INSERT INTO "public"."country_codes" VALUES ('96', 'Iran', '98', 'IR');
114INSERT INTO "public"."country_codes" VALUES ('97', 'Iraq', '964', 'IQ');
115INSERT INTO "public"."country_codes" VALUES ('98', 'Ireland', '353', 'IE');
116INSERT INTO "public"."country_codes" VALUES ('99', 'Isle Of Man', '44', 'IM');
117INSERT INTO "public"."country_codes" VALUES ('100', 'Israel', '972', 'IL');
118INSERT INTO "public"."country_codes" VALUES ('101', 'Italy', '39', 'IT');
119INSERT INTO "public"."country_codes" VALUES ('102', 'Jamaica', '1', 'JM');
120INSERT INTO "public"."country_codes" VALUES ('103', 'Japan', '81', 'JP');
121INSERT INTO "public"."country_codes" VALUES ('104', 'Jersey', '44', 'JE');
122INSERT INTO "public"."country_codes" VALUES ('105', 'Jordan', '962', 'JO');
123INSERT INTO "public"."country_codes" VALUES ('106', 'Kazakhstan', '7', 'KZ');
124INSERT INTO "public"."country_codes" VALUES ('107', 'Kenya', '254', 'KE');
125INSERT INTO "public"."country_codes" VALUES ('108', 'Kiribati', '686', 'KI');
126INSERT INTO "public"."country_codes" VALUES ('109', 'Kuwait', '965', 'KW');
127INSERT INTO "public"."country_codes" VALUES ('110', 'Kyrgyzstan', '996', 'KG');
128INSERT INTO "public"."country_codes" VALUES ('111', 'Laos', '856', 'LA');
129INSERT INTO "public"."country_codes" VALUES ('112', 'Latvia', '371', 'LV');
130INSERT INTO "public"."country_codes" VALUES ('113', 'Lebanon', '961', 'LB');
131INSERT INTO "public"."country_codes" VALUES ('114', 'Lesotho', '266', 'LS');
132INSERT INTO "public"."country_codes" VALUES ('115', 'Liberia', '231', 'LR');
133INSERT INTO "public"."country_codes" VALUES ('116', 'Libya', '218', 'LY');
134INSERT INTO "public"."country_codes" VALUES ('117', 'Liechtenstein', '423', 'LI');
135INSERT INTO "public"."country_codes" VALUES ('118', 'Lithuania', '370', 'LT');
136INSERT INTO "public"."country_codes" VALUES ('119', 'Luxembourg', '352', 'LU');
137INSERT INTO "public"."country_codes" VALUES ('120', 'Macau', '853', 'MO');
138INSERT INTO "public"."country_codes" VALUES ('121', 'Macedonia', '389', 'MK');
139INSERT INTO "public"."country_codes" VALUES ('122', 'Madagascar', '261', 'MG');
140INSERT INTO "public"."country_codes" VALUES ('123', 'Malawi', '265', 'MW');
141INSERT INTO "public"."country_codes" VALUES ('124', 'Malaysia', '60', 'MY');
142INSERT INTO "public"."country_codes" VALUES ('125', 'Maldives', '960', 'MV');
143INSERT INTO "public"."country_codes" VALUES ('126', 'Mali', '223', 'ML');
144INSERT INTO "public"."country_codes" VALUES ('127', 'Malta', '356', 'MT');
145INSERT INTO "public"."country_codes" VALUES ('128', 'Marshall Islands', '692', 'MH');
146INSERT INTO "public"."country_codes" VALUES ('129', 'Martinique', '596', 'MQ');
147INSERT INTO "public"."country_codes" VALUES ('130', 'Mauritania', '222', 'MR');
148INSERT INTO "public"."country_codes" VALUES ('131', 'Mauritius', '230', 'MU');
149INSERT INTO "public"."country_codes" VALUES ('132', 'Mayotte', '262', 'YT');
150INSERT INTO "public"."country_codes" VALUES ('133', 'Mexico', '52', 'MX');
151INSERT INTO "public"."country_codes" VALUES ('134', 'Moldova', '373', 'MD');
152INSERT INTO "public"."country_codes" VALUES ('135', 'Monaco', '377', 'MC');
153INSERT INTO "public"."country_codes" VALUES ('136', 'Mongolia', '976', 'MN');
154INSERT INTO "public"."country_codes" VALUES ('137', 'Montenegro', '382', 'ME');
155INSERT INTO "public"."country_codes" VALUES ('138', 'Montserrat', '1', 'MS');
156INSERT INTO "public"."country_codes" VALUES ('139', 'Morocco', '212', 'MA');
157INSERT INTO "public"."country_codes" VALUES ('140', 'Mozambique', '258', 'MZ');
158INSERT INTO "public"."country_codes" VALUES ('141', 'Myanmar', '95', 'MM');
159INSERT INTO "public"."country_codes" VALUES ('142', 'Namibia', '264', 'NA');
160INSERT INTO "public"."country_codes" VALUES ('143', 'Nauru', '674', 'NR');
161INSERT INTO "public"."country_codes" VALUES ('144', 'Nepal', '977', 'NP');
162INSERT INTO "public"."country_codes" VALUES ('145', 'Netherlands', '31', 'NL');
163INSERT INTO "public"."country_codes" VALUES ('146', 'New Caledonia', '687', 'NC');
164INSERT INTO "public"."country_codes" VALUES ('147', 'New Zealand', '64', 'NZ');
165INSERT INTO "public"."country_codes" VALUES ('148', 'Nicaragua', '505', 'NI');
166INSERT INTO "public"."country_codes" VALUES ('149', 'Niger', '227', 'NE');
167INSERT INTO "public"."country_codes" VALUES ('150', 'Nigeria', '234', 'NG');
168INSERT INTO "public"."country_codes" VALUES ('151', 'Niue', '683', 'NU');
169INSERT INTO "public"."country_codes" VALUES ('152', 'Norfolk Island', '672', 'NF');
170INSERT INTO "public"."country_codes" VALUES ('153', 'North Korea', '850', 'KP');
171INSERT INTO "public"."country_codes" VALUES ('154', 'Northern Mariana Islands', '1', 'MP');
172INSERT INTO "public"."country_codes" VALUES ('155', 'Norway', '47', 'NO');
173INSERT INTO "public"."country_codes" VALUES ('156', 'Oman', '968', 'OM');
174INSERT INTO "public"."country_codes" VALUES ('157', 'Pakistan', '92', 'PK');
175INSERT INTO "public"."country_codes" VALUES ('158', 'Palau', '680', 'PW');
176INSERT INTO "public"."country_codes" VALUES ('159', 'Palestine', '970', 'PS');
177INSERT INTO "public"."country_codes" VALUES ('160', 'Panama', '507', 'PA');
178INSERT INTO "public"."country_codes" VALUES ('161', 'Papua New Guinea', '675', 'PG');
179INSERT INTO "public"."country_codes" VALUES ('162', 'Paraguay', '595', 'PY');
180INSERT INTO "public"."country_codes" VALUES ('163', 'Peru', '51', 'PE');
181INSERT INTO "public"."country_codes" VALUES ('164', 'Philippines', '63', 'PH');
182INSERT INTO "public"."country_codes" VALUES ('165', 'Poland', '48', 'PL');
183INSERT INTO "public"."country_codes" VALUES ('166', 'Portugal', '351', 'PT');
184INSERT INTO "public"."country_codes" VALUES ('167', 'Puerto Rico', '1', 'PR');
185INSERT INTO "public"."country_codes" VALUES ('168', 'Qatar', '974', 'QA');
186INSERT INTO "public"."country_codes" VALUES ('169', 'Republic of the Congo', '242', 'CG');
187INSERT INTO "public"."country_codes" VALUES ('170', 'Réunion', '262', 'RE');
188INSERT INTO "public"."country_codes" VALUES ('171', 'Romania', '40', 'RO');
189INSERT INTO "public"."country_codes" VALUES ('172', 'Russia', '7', 'RU');
190INSERT INTO "public"."country_codes" VALUES ('173', 'Rwanda', '250', 'RW');
191INSERT INTO "public"."country_codes" VALUES ('174', 'Saint Helena', '290', 'SH');
192INSERT INTO "public"."country_codes" VALUES ('175', 'Saint Kitts and Nevis', '1', 'KN');
193INSERT INTO "public"."country_codes" VALUES ('176', 'Saint Pierre and Miquelon', '508', 'PM');
194INSERT INTO "public"."country_codes" VALUES ('177', 'Saint Vincent and the Grenadines', '1', 'VC');
195INSERT INTO "public"."country_codes" VALUES ('178', 'Samoa', '685', 'WS');
196INSERT INTO "public"."country_codes" VALUES ('179', 'San Marino', '378', 'SM');
197INSERT INTO "public"."country_codes" VALUES ('180', 'Sao Tome and Principe', '239', 'ST');
198INSERT INTO "public"."country_codes" VALUES ('181', 'Saudi Arabia', '966', 'SA');
199INSERT INTO "public"."country_codes" VALUES ('182', 'Senegal', '221', 'SN');
200INSERT INTO "public"."country_codes" VALUES ('183', 'Serbia', '381', 'RS');
201INSERT INTO "public"."country_codes" VALUES ('184', 'Seychelles', '248', 'SC');
202INSERT INTO "public"."country_codes" VALUES ('185', 'Sierra Leone', '232', 'SL');
203INSERT INTO "public"."country_codes" VALUES ('186', 'Singapore', '65', 'SG');
204INSERT INTO "public"."country_codes" VALUES ('187', 'Sint Maarten', '1', 'SX');
205INSERT INTO "public"."country_codes" VALUES ('188', 'Slovakia', '421', 'SK');
206INSERT INTO "public"."country_codes" VALUES ('189', 'Slovenia', '386', 'SI');
207INSERT INTO "public"."country_codes" VALUES ('190', 'Solomon Islands', '677', 'SB');
208INSERT INTO "public"."country_codes" VALUES ('191', 'Somalia', '252', 'SO');
209INSERT INTO "public"."country_codes" VALUES ('192', 'South Africa', '27', 'ZA');
210INSERT INTO "public"."country_codes" VALUES ('193', 'South Korea', '82', 'KR');
211INSERT INTO "public"."country_codes" VALUES ('194', 'South Sudan', '211', 'SS');
212INSERT INTO "public"."country_codes" VALUES ('195', 'Spain', '34', 'ES');
213INSERT INTO "public"."country_codes" VALUES ('196', 'Sri Lanka', '94', 'LK');
214INSERT INTO "public"."country_codes" VALUES ('197', 'St. Lucia', '1', 'LC');
215INSERT INTO "public"."country_codes" VALUES ('198', 'Sudan', '249', 'SD');
216INSERT INTO "public"."country_codes" VALUES ('199', 'Suriname', '597', 'SR');
217INSERT INTO "public"."country_codes" VALUES ('200', 'Swaziland', '268', 'SZ');
218INSERT INTO "public"."country_codes" VALUES ('201', 'Sweden', '46', 'SE');
219INSERT INTO "public"."country_codes" VALUES ('202', 'Switzerland', '41', 'CH');
220INSERT INTO "public"."country_codes" VALUES ('203', 'Syria', '963', 'SY');
221INSERT INTO "public"."country_codes" VALUES ('204', 'Taiwan', '886', 'TW');
222INSERT INTO "public"."country_codes" VALUES ('205', 'Tajikistan', '992', 'TJ');
223INSERT INTO "public"."country_codes" VALUES ('206', 'Tanzania', '255', 'TZ');
224INSERT INTO "public"."country_codes" VALUES ('207', 'Thailand', '66', 'TH');
225INSERT INTO "public"."country_codes" VALUES ('208', 'The Bahamas', '1', 'BS');
226INSERT INTO "public"."country_codes" VALUES ('209', 'The Gambia', '220', 'GM');
227INSERT INTO "public"."country_codes" VALUES ('210', 'Timor-Leste', '670', 'TL');
228INSERT INTO "public"."country_codes" VALUES ('211', 'Togo', '228', 'TG');
229INSERT INTO "public"."country_codes" VALUES ('212', 'Tokelau', '690', 'TK');
230INSERT INTO "public"."country_codes" VALUES ('213', 'Tonga', '676', 'TO');
231INSERT INTO "public"."country_codes" VALUES ('214', 'Trinidad and Tobago', '1', 'TT');
232INSERT INTO "public"."country_codes" VALUES ('215', 'Tunisia', '216', 'TN');
233INSERT INTO "public"."country_codes" VALUES ('216', 'Turkey', '90', 'TR');
234INSERT INTO "public"."country_codes" VALUES ('217', 'Turkmenistan', '993', 'TM');
235INSERT INTO "public"."country_codes" VALUES ('218', 'Turks and Caicos Islands', '1', 'TC');
236INSERT INTO "public"."country_codes" VALUES ('219', 'Tuvalu', '688', 'TV');
237INSERT INTO "public"."country_codes" VALUES ('220', 'Uganda', '256', 'UG');
238INSERT INTO "public"."country_codes" VALUES ('221', 'Ukraine', '380', 'UA');
239INSERT INTO "public"."country_codes" VALUES ('222', 'United Arab Emirates', '971', 'AE');
240INSERT INTO "public"."country_codes" VALUES ('223', 'United Kingdom', '44', 'GB');
241INSERT INTO "public"."country_codes" VALUES ('224', 'United States', '1', 'US');
242INSERT INTO "public"."country_codes" VALUES ('225', 'Uruguay', '598', 'UY');
243INSERT INTO "public"."country_codes" VALUES ('226', 'US Virgin Islands', '1', 'VI');
244INSERT INTO "public"."country_codes" VALUES ('227', 'Uzbekistan', '998', 'UZ');
245INSERT INTO "public"."country_codes" VALUES ('228', 'Vanuatu', '678', 'VU');
246INSERT INTO "public"."country_codes" VALUES ('229', 'Venezuela', '58', 'VE');
247INSERT INTO "public"."country_codes" VALUES ('230', 'Vietnam', '84', 'VN');
248INSERT INTO "public"."country_codes" VALUES ('231', 'Wallis and Futuna', '681', 'WF');
249INSERT INTO "public"."country_codes" VALUES ('232', 'Western Sahara', '212', 'EH');
250INSERT INTO "public"."country_codes" VALUES ('233', 'Yemen', '967', 'YE');
251INSERT INTO "public"."country_codes" VALUES ('234', 'Zambia', '260', 'ZM');
252COMMIT;
253
254-- ----------------------------
255-- Primary key structure for table country_codes
256-- ----------------------------
257ALTER TABLE "public"."country_codes" ADD PRIMARY KEY ("id") NOT DEFERRABLE INITIALLY IMMEDIATE;