joniden/cities_mssql.sql

## cities_mssql.sql
CREATE TABLE Cities (
  id INT NOT NULL IDENTITY(1, 1),
  City varchar(255),
  Region varchar(50) default NULL,
  Country varchar(100) default NULL,
  PRIMARY KEY (id)
)

INSERT INTO Cities (City,Region,Country) VALUES ('Medellín','Antioquia','Nauru'),('Ovalle','IV','Botswana'),('Peñaflor','RM','Grenada'),('Kashmore','SI','Sierra Leone'),('El Bosque','Metropolitana de Santiago','Mauritania'),('Berlin','Berlin','Zimbabwe'),('Castres','Midi-Pyrénées','Belarus'),('Makassar','South Sulawesi','Pitcairn Islands'),('Heist-aan-Zee','WV','Monaco'),('Mexico City','CDM','Kenya');
INSERT INTO Cities (City,Region,Country) VALUES ('Pinarbasi','Kayseri','Luxembourg'),('Murcia','Murcia','Peru'),('Warren','Michigan','Bhutan'),('Remscheid','NW','Cuba'),('Logan City','Queensland','Sao Tome and Principe'),('Noisy-le-Grand','Île-de-France','Puerto Rico'),('Huancayo','Junín','South Sudan'),('Kapuskasing','ON','Tajikistan'),('Waiheke Island','NI','Colombia'),('Ribeirão Preto','SP','Zimbabwe');
INSERT INTO Cities (City,Region,Country) VALUES ('Masterton','North Island','Saint Vincent and The Grenadines'),('Neder-Over-Heembeek','BU','Cameroon'),('Norrköping','E','San Marino'),('Anseong','Gyeonggi','Tokelau'),('Feilding','North Island','Pakistan'),('Foz do Iguaçu','PR','Jersey'),('Vespolate','PIE','Chad'),('Vienna','Wie','Malta'),('Dehri','Bihar','Chad'),('Lo Espejo','Metropolitana de Santiago','Zambia');
INSERT INTO Cities (City,Region,Country) VALUES ('Alexandra','South Island','Lithuania'),('Guadalajara','CM','Kiribati'),('Oviedo','Principado de Asturias','Latvia'),('Gujranwala','SI','Austria'),('Burnie','Tasmania','Liberia'),('Mérida','Yucatán','Turkmenistan'),('Sandviken','X','Israel'),('Otukpo','BE','Libya'),('Fort Collins','Colorado','Portugal'),('Belfast','U','Uruguay');
INSERT INTO Cities (City,Region,Country) VALUES ('Guelph','Ontario','Anguilla'),('Beauvechain','WB','Sierra Leone'),('Pachuca','Hgo','Tajikistan'),('Täby','Stockholms län','Senegal'),('Helmond','Noord Brabant','Bosnia and Herzegovina'),('Olcenengo','PIE','French Southern Territories'),('Blue Mountains','NSW','Lesotho'),('Cambridge','Massachusetts','Belgium'),('Sullana','Piura','Macao'),('Barcelona','Catalunya','Guatemala');
INSERT INTO Cities (City,Region,Country) VALUES ('Kawerau','NI','Lithuania'),('Cambridge Bay','NU','United States'),('Zaanstad','N.','Dominican Republic'),('Siquirres','L','New Zealand'),('Poznan','WP','Togo'),('Geelong','Victoria','Zimbabwe'),('Sens','Bourgogne','Yemen'),('Boise','ID','Solomon Islands'),('Cranbrook','BC','Lesotho'),('San Vicente de Cañete','LIM','Cameroon');
INSERT INTO Cities (City,Region,Country) VALUES ('Wals-Siezenheim','Sbg','Tokelau'),('Tamworth','NSW','Saint Kitts and Nevis'),('Cabano','Quebec','Iceland'),('Argenteuil','IL','Swaziland'),('Plock','MA','Aruba'),('Poitiers','Poitou-Charentes','Palau'),('Ryazan','RYA','China'),('Tambov','TAM','Turkmenistan'),('Orai','UP','Zimbabwe'),('Täby','Stockholms län','Belarus');
INSERT INTO Cities (City,Region,Country) VALUES ('Fort Smith','Arkansas','United Arab Emirates'),('Berlin','BE','Guernsey'),('Taupo','NI','Norfolk Island'),('Smolensk','Smolensk Oblast','Argentina'),('Sijsele','West-Vlaanderen','United States'),('Londerzeel','VB','Malaysia'),('Mercedes','Heredia','Ethiopia'),('Iguala','Guerrero','China'),('Fort Resolution','NT','Angola'),('Provo','Utah','Guatemala');
INSERT INTO Cities (City,Region,Country) VALUES ('Portree','IN','Equatorial Guinea'),('Itagüí','Antioquia','Taiwan'),('Skegness','Lincolnshire','Saint Martin'),('Doñihue','O Higgins','United Arab Emirates'),('Galway','C','Hungary'),('San Rafael','SJ','Libya'),('Kraków','Malopolskie','Germany'),('Vaughan','ON','Guam'),('Dublin','L','Cook Islands'),('Bruderheim','AB','Korea, North');
INSERT INTO Cities (City,Region,Country) VALUES ('Hastings','North Island','El Salvador'),('Ostrowiec Swietokrzyski','SK','Costa Rica'),('Rhisnes','Namen','Kenya'),('Acapulco','Gro','Puerto Rico'),('Abaetetuba','Pará','Seychelles'),('Aisemont','NA','Bosnia and Herzegovina'),('Badajoz','Extremadura','Cape Verde'),('Quesada','Alajuela','Western Sahara'),('Jecheon','North Chungcheong','Heard Island and Mcdonald Islands'),('Vienna','Vienna','Nigeria');

## cities_mysql.sql
CREATE TABLE Cities (
  id int(8) NOT NULL auto_increment,
  City varchar(255),
  Region varchar(50) default NULL,
  Country varchar(100) default NULL,
  PRIMARY KEY (id)
) AUTO_INCREMENT=1;

INSERT INTO Cities (City,Region,Country) VALUES ('Medellín','Antioquia','Nauru'),('Ovalle','IV','Botswana'),('Peñaflor','RM','Grenada'),('Kashmore','SI','Sierra Leone'),('El Bosque','Metropolitana de Santiago','Mauritania'),('Berlin','Berlin','Zimbabwe'),('Castres','Midi-Pyrénées','Belarus'),('Makassar','South Sulawesi','Pitcairn Islands'),('Heist-aan-Zee','WV','Monaco'),('Mexico City','CDM','Kenya');
INSERT INTO Cities (City,Region,Country) VALUES ('Pinarbasi','Kayseri','Luxembourg'),('Murcia','Murcia','Peru'),('Warren','Michigan','Bhutan'),('Remscheid','NW','Cuba'),('Logan City','Queensland','Sao Tome and Principe'),('Noisy-le-Grand','Île-de-France','Puerto Rico'),('Huancayo','Junín','South Sudan'),('Kapuskasing','ON','Tajikistan'),('Waiheke Island','NI','Colombia'),('Ribeirão Preto','SP','Zimbabwe');
INSERT INTO Cities (City,Region,Country) VALUES ('Masterton','North Island','Saint Vincent and The Grenadines'),('Neder-Over-Heembeek','BU','Cameroon'),('Norrköping','E','San Marino'),('Anseong','Gyeonggi','Tokelau'),('Feilding','North Island','Pakistan'),('Foz do Iguaçu','PR','Jersey'),('Vespolate','PIE','Chad'),('Vienna','Wie','Malta'),('Dehri','Bihar','Chad'),('Lo Espejo','Metropolitana de Santiago','Zambia');
INSERT INTO Cities (City,Region,Country) VALUES ('Alexandra','South Island','Lithuania'),('Guadalajara','CM','Kiribati'),('Oviedo','Principado de Asturias','Latvia'),('Gujranwala','SI','Austria'),('Burnie','Tasmania','Liberia'),('Mérida','Yucatán','Turkmenistan'),('Sandviken','X','Israel'),('Otukpo','BE','Libya'),('Fort Collins','Colorado','Portugal'),('Belfast','U','Uruguay');
INSERT INTO Cities (City,Region,Country) VALUES ('Guelph','Ontario','Anguilla'),('Beauvechain','WB','Sierra Leone'),('Pachuca','Hgo','Tajikistan'),('Täby','Stockholms län','Senegal'),('Helmond','Noord Brabant','Bosnia and Herzegovina'),('Olcenengo','PIE','French Southern Territories'),('Blue Mountains','NSW','Lesotho'),('Cambridge','Massachusetts','Belgium'),('Sullana','Piura','Macao'),('Barcelona','Catalunya','Guatemala');
INSERT INTO Cities (City,Region,Country) VALUES ('Kawerau','NI','Lithuania'),('Cambridge Bay','NU','United States'),('Zaanstad','N.','Dominican Republic'),('Siquirres','L','New Zealand'),('Poznan','WP','Togo'),('Geelong','Victoria','Zimbabwe'),('Sens','Bourgogne','Yemen'),('Boise','ID','Solomon Islands'),('Cranbrook','BC','Lesotho'),('San Vicente de Cañete','LIM','Cameroon');
INSERT INTO Cities (City,Region,Country) VALUES ('Wals-Siezenheim','Sbg','Tokelau'),('Tamworth','NSW','Saint Kitts and Nevis'),('Cabano','Quebec','Iceland'),('Argenteuil','IL','Swaziland'),('Plock','MA','Aruba'),('Poitiers','Poitou-Charentes','Palau'),('Ryazan','RYA','China'),('Tambov','TAM','Turkmenistan'),('Orai','UP','Zimbabwe'),('Täby','Stockholms län','Belarus');
INSERT INTO Cities (City,Region,Country) VALUES ('Fort Smith','Arkansas','United Arab Emirates'),('Berlin','BE','Guernsey'),('Taupo','NI','Norfolk Island'),('Smolensk','Smolensk Oblast','Argentina'),('Sijsele','West-Vlaanderen','United States'),('Londerzeel','VB','Malaysia'),('Mercedes','Heredia','Ethiopia'),('Iguala','Guerrero','China'),('Fort Resolution','NT','Angola'),('Provo','Utah','Guatemala');
INSERT INTO Cities (City,Region,Country) VALUES ('Portree','IN','Equatorial Guinea'),('Itagüí','Antioquia','Taiwan'),('Skegness','Lincolnshire','Saint Martin'),('Doñihue','O Higgins','United Arab Emirates'),('Galway','C','Hungary'),('San Rafael','SJ','Libya'),('Kraków','Malopolskie','Germany'),('Vaughan','ON','Guam'),('Dublin','L','Cook Islands'),('Bruderheim','AB','Korea, North');
INSERT INTO Cities (City,Region,Country) VALUES ('Hastings','North Island','El Salvador'),('Ostrowiec Swietokrzyski','SK','Costa Rica'),('Rhisnes','Namen','Kenya'),('Acapulco','Gro','Puerto Rico'),('Abaetetuba','Pará','Seychelles'),('Aisemont','NA','Bosnia and Herzegovina'),('Badajoz','Extremadura','Cape Verde'),('Quesada','Alajuela','Western Sahara'),('Jecheon','North Chungcheong','Heard Island and Mcdonald Islands'),('Vienna','Vienna','Nigeria');

## cities_postgres.sql
CREATE TABLE Cities (
  id SERIAL PRIMARY KEY,
  City varchar(255),
  Region varchar(50) default NULL,
  Country varchar(100) default NULL
);

INSERT INTO Cities (City,Region,Country) VALUES ('Medellín','Antioquia','Nauru'),('Ovalle','IV','Botswana'),('Peñaflor','RM','Grenada'),('Kashmore','SI','Sierra Leone'),('El Bosque','Metropolitana de Santiago','Mauritania'),('Berlin','Berlin','Zimbabwe'),('Castres','Midi-Pyrénées','Belarus'),('Makassar','South Sulawesi','Pitcairn Islands'),('Heist-aan-Zee','WV','Monaco'),('Mexico City','CDM','Kenya');
INSERT INTO Cities (City,Region,Country) VALUES ('Pinarbasi','Kayseri','Luxembourg'),('Murcia','Murcia','Peru'),('Warren','Michigan','Bhutan'),('Remscheid','NW','Cuba'),('Logan City','Queensland','Sao Tome and Principe'),('Noisy-le-Grand','Île-de-France','Puerto Rico'),('Huancayo','Junín','South Sudan'),('Kapuskasing','ON','Tajikistan'),('Waiheke Island','NI','Colombia'),('Ribeirão Preto','SP','Zimbabwe');
INSERT INTO Cities (City,Region,Country) VALUES ('Masterton','North Island','Saint Vincent and The Grenadines'),('Neder-Over-Heembeek','BU','Cameroon'),('Norrköping','E','San Marino'),('Anseong','Gyeonggi','Tokelau'),('Feilding','North Island','Pakistan'),('Foz do Iguaçu','PR','Jersey'),('Vespolate','PIE','Chad'),('Vienna','Wie','Malta'),('Dehri','Bihar','Chad'),('Lo Espejo','Metropolitana de Santiago','Zambia');
INSERT INTO Cities (City,Region,Country) VALUES ('Alexandra','South Island','Lithuania'),('Guadalajara','CM','Kiribati'),('Oviedo','Principado de Asturias','Latvia'),('Gujranwala','SI','Austria'),('Burnie','Tasmania','Liberia'),('Mérida','Yucatán','Turkmenistan'),('Sandviken','X','Israel'),('Otukpo','BE','Libya'),('Fort Collins','Colorado','Portugal'),('Belfast','U','Uruguay');
INSERT INTO Cities (City,Region,Country) VALUES ('Guelph','Ontario','Anguilla'),('Beauvechain','WB','Sierra Leone'),('Pachuca','Hgo','Tajikistan'),('Täby','Stockholms län','Senegal'),('Helmond','Noord Brabant','Bosnia and Herzegovina'),('Olcenengo','PIE','French Southern Territories'),('Blue Mountains','NSW','Lesotho'),('Cambridge','Massachusetts','Belgium'),('Sullana','Piura','Macao'),('Barcelona','Catalunya','Guatemala');
INSERT INTO Cities (City,Region,Country) VALUES ('Kawerau','NI','Lithuania'),('Cambridge Bay','NU','United States'),('Zaanstad','N.','Dominican Republic'),('Siquirres','L','New Zealand'),('Poznan','WP','Togo'),('Geelong','Victoria','Zimbabwe'),('Sens','Bourgogne','Yemen'),('Boise','ID','Solomon Islands'),('Cranbrook','BC','Lesotho'),('San Vicente de Cañete','LIM','Cameroon');
INSERT INTO Cities (City,Region,Country) VALUES ('Wals-Siezenheim','Sbg','Tokelau'),('Tamworth','NSW','Saint Kitts and Nevis'),('Cabano','Quebec','Iceland'),('Argenteuil','IL','Swaziland'),('Plock','MA','Aruba'),('Poitiers','Poitou-Charentes','Palau'),('Ryazan','RYA','China'),('Tambov','TAM','Turkmenistan'),('Orai','UP','Zimbabwe'),('Täby','Stockholms län','Belarus');
INSERT INTO Cities (City,Region,Country) VALUES ('Fort Smith','Arkansas','United Arab Emirates'),('Berlin','BE','Guernsey'),('Taupo','NI','Norfolk Island'),('Smolensk','Smolensk Oblast','Argentina'),('Sijsele','West-Vlaanderen','United States'),('Londerzeel','VB','Malaysia'),('Mercedes','Heredia','Ethiopia'),('Iguala','Guerrero','China'),('Fort Resolution','NT','Angola'),('Provo','Utah','Guatemala');
INSERT INTO Cities (City,Region,Country) VALUES ('Portree','IN','Equatorial Guinea'),('Itagüí','Antioquia','Taiwan'),('Skegness','Lincolnshire','Saint Martin'),('Doñihue','O Higgins','United Arab Emirates'),('Galway','C','Hungary'),('San Rafael','SJ','Libya'),('Kraków','Malopolskie','Germany'),('Vaughan','ON','Guam'),('Dublin','L','Cook Islands'),('Bruderheim','AB','Korea, North');
INSERT INTO Cities (City,Region,Country) VALUES ('Hastings','North Island','El Salvador'),('Ostrowiec Swietokrzyski','SK','Costa Rica'),('Rhisnes','Namen','Kenya'),('Acapulco','Gro','Puerto Rico'),('Abaetetuba','Pará','Seychelles'),('Aisemont','NA','Bosnia and Herzegovina'),('Badajoz','Extremadura','Cape Verde'),('Quesada','Alajuela','Western Sahara'),('Jecheon','North Chungcheong','Heard Island and Mcdonald Islands'),('Vienna','Vienna','Nigeria');
	CREATE TABLE Cities (
	id INT NOT NULL IDENTITY(1, 1),
	City varchar(255),
	Region varchar(50) default NULL,
	Country varchar(100) default NULL,
	PRIMARY KEY (id)
	)

	INSERT INTO Cities (City,Region,Country) VALUES ('Medellín','Antioquia','Nauru'),('Ovalle','IV','Botswana'),('Peñaflor','RM','Grenada'),('Kashmore','SI','Sierra Leone'),('El Bosque','Metropolitana de Santiago','Mauritania'),('Berlin','Berlin','Zimbabwe'),('Castres','Midi-Pyrénées','Belarus'),('Makassar','South Sulawesi','Pitcairn Islands'),('Heist-aan-Zee','WV','Monaco'),('Mexico City','CDM','Kenya');
	INSERT INTO Cities (City,Region,Country) VALUES ('Pinarbasi','Kayseri','Luxembourg'),('Murcia','Murcia','Peru'),('Warren','Michigan','Bhutan'),('Remscheid','NW','Cuba'),('Logan City','Queensland','Sao Tome and Principe'),('Noisy-le-Grand','Île-de-France','Puerto Rico'),('Huancayo','Junín','South Sudan'),('Kapuskasing','ON','Tajikistan'),('Waiheke Island','NI','Colombia'),('Ribeirão Preto','SP','Zimbabwe');
	INSERT INTO Cities (City,Region,Country) VALUES ('Masterton','North Island','Saint Vincent and The Grenadines'),('Neder-Over-Heembeek','BU','Cameroon'),('Norrköping','E','San Marino'),('Anseong','Gyeonggi','Tokelau'),('Feilding','North Island','Pakistan'),('Foz do Iguaçu','PR','Jersey'),('Vespolate','PIE','Chad'),('Vienna','Wie','Malta'),('Dehri','Bihar','Chad'),('Lo Espejo','Metropolitana de Santiago','Zambia');
	INSERT INTO Cities (City,Region,Country) VALUES ('Alexandra','South Island','Lithuania'),('Guadalajara','CM','Kiribati'),('Oviedo','Principado de Asturias','Latvia'),('Gujranwala','SI','Austria'),('Burnie','Tasmania','Liberia'),('Mérida','Yucatán','Turkmenistan'),('Sandviken','X','Israel'),('Otukpo','BE','Libya'),('Fort Collins','Colorado','Portugal'),('Belfast','U','Uruguay');
	INSERT INTO Cities (City,Region,Country) VALUES ('Guelph','Ontario','Anguilla'),('Beauvechain','WB','Sierra Leone'),('Pachuca','Hgo','Tajikistan'),('Täby','Stockholms län','Senegal'),('Helmond','Noord Brabant','Bosnia and Herzegovina'),('Olcenengo','PIE','French Southern Territories'),('Blue Mountains','NSW','Lesotho'),('Cambridge','Massachusetts','Belgium'),('Sullana','Piura','Macao'),('Barcelona','Catalunya','Guatemala');
	INSERT INTO Cities (City,Region,Country) VALUES ('Kawerau','NI','Lithuania'),('Cambridge Bay','NU','United States'),('Zaanstad','N.','Dominican Republic'),('Siquirres','L','New Zealand'),('Poznan','WP','Togo'),('Geelong','Victoria','Zimbabwe'),('Sens','Bourgogne','Yemen'),('Boise','ID','Solomon Islands'),('Cranbrook','BC','Lesotho'),('San Vicente de Cañete','LIM','Cameroon');
	INSERT INTO Cities (City,Region,Country) VALUES ('Wals-Siezenheim','Sbg','Tokelau'),('Tamworth','NSW','Saint Kitts and Nevis'),('Cabano','Quebec','Iceland'),('Argenteuil','IL','Swaziland'),('Plock','MA','Aruba'),('Poitiers','Poitou-Charentes','Palau'),('Ryazan','RYA','China'),('Tambov','TAM','Turkmenistan'),('Orai','UP','Zimbabwe'),('Täby','Stockholms län','Belarus');
	INSERT INTO Cities (City,Region,Country) VALUES ('Fort Smith','Arkansas','United Arab Emirates'),('Berlin','BE','Guernsey'),('Taupo','NI','Norfolk Island'),('Smolensk','Smolensk Oblast','Argentina'),('Sijsele','West-Vlaanderen','United States'),('Londerzeel','VB','Malaysia'),('Mercedes','Heredia','Ethiopia'),('Iguala','Guerrero','China'),('Fort Resolution','NT','Angola'),('Provo','Utah','Guatemala');
	INSERT INTO Cities (City,Region,Country) VALUES ('Portree','IN','Equatorial Guinea'),('Itagüí','Antioquia','Taiwan'),('Skegness','Lincolnshire','Saint Martin'),('Doñihue','O Higgins','United Arab Emirates'),('Galway','C','Hungary'),('San Rafael','SJ','Libya'),('Kraków','Malopolskie','Germany'),('Vaughan','ON','Guam'),('Dublin','L','Cook Islands'),('Bruderheim','AB','Korea, North');
	INSERT INTO Cities (City,Region,Country) VALUES ('Hastings','North Island','El Salvador'),('Ostrowiec Swietokrzyski','SK','Costa Rica'),('Rhisnes','Namen','Kenya'),('Acapulco','Gro','Puerto Rico'),('Abaetetuba','Pará','Seychelles'),('Aisemont','NA','Bosnia and Herzegovina'),('Badajoz','Extremadura','Cape Verde'),('Quesada','Alajuela','Western Sahara'),('Jecheon','North Chungcheong','Heard Island and Mcdonald Islands'),('Vienna','Vienna','Nigeria');
	CREATE TABLE Cities (
	id int(8) NOT NULL auto_increment,
	City varchar(255),
	Region varchar(50) default NULL,
	Country varchar(100) default NULL,
	PRIMARY KEY (id)
	) AUTO_INCREMENT=1;

	INSERT INTO Cities (City,Region,Country) VALUES ('Medellín','Antioquia','Nauru'),('Ovalle','IV','Botswana'),('Peñaflor','RM','Grenada'),('Kashmore','SI','Sierra Leone'),('El Bosque','Metropolitana de Santiago','Mauritania'),('Berlin','Berlin','Zimbabwe'),('Castres','Midi-Pyrénées','Belarus'),('Makassar','South Sulawesi','Pitcairn Islands'),('Heist-aan-Zee','WV','Monaco'),('Mexico City','CDM','Kenya');
	INSERT INTO Cities (City,Region,Country) VALUES ('Pinarbasi','Kayseri','Luxembourg'),('Murcia','Murcia','Peru'),('Warren','Michigan','Bhutan'),('Remscheid','NW','Cuba'),('Logan City','Queensland','Sao Tome and Principe'),('Noisy-le-Grand','Île-de-France','Puerto Rico'),('Huancayo','Junín','South Sudan'),('Kapuskasing','ON','Tajikistan'),('Waiheke Island','NI','Colombia'),('Ribeirão Preto','SP','Zimbabwe');
	INSERT INTO Cities (City,Region,Country) VALUES ('Masterton','North Island','Saint Vincent and The Grenadines'),('Neder-Over-Heembeek','BU','Cameroon'),('Norrköping','E','San Marino'),('Anseong','Gyeonggi','Tokelau'),('Feilding','North Island','Pakistan'),('Foz do Iguaçu','PR','Jersey'),('Vespolate','PIE','Chad'),('Vienna','Wie','Malta'),('Dehri','Bihar','Chad'),('Lo Espejo','Metropolitana de Santiago','Zambia');
	INSERT INTO Cities (City,Region,Country) VALUES ('Alexandra','South Island','Lithuania'),('Guadalajara','CM','Kiribati'),('Oviedo','Principado de Asturias','Latvia'),('Gujranwala','SI','Austria'),('Burnie','Tasmania','Liberia'),('Mérida','Yucatán','Turkmenistan'),('Sandviken','X','Israel'),('Otukpo','BE','Libya'),('Fort Collins','Colorado','Portugal'),('Belfast','U','Uruguay');
	INSERT INTO Cities (City,Region,Country) VALUES ('Guelph','Ontario','Anguilla'),('Beauvechain','WB','Sierra Leone'),('Pachuca','Hgo','Tajikistan'),('Täby','Stockholms län','Senegal'),('Helmond','Noord Brabant','Bosnia and Herzegovina'),('Olcenengo','PIE','French Southern Territories'),('Blue Mountains','NSW','Lesotho'),('Cambridge','Massachusetts','Belgium'),('Sullana','Piura','Macao'),('Barcelona','Catalunya','Guatemala');
	INSERT INTO Cities (City,Region,Country) VALUES ('Kawerau','NI','Lithuania'),('Cambridge Bay','NU','United States'),('Zaanstad','N.','Dominican Republic'),('Siquirres','L','New Zealand'),('Poznan','WP','Togo'),('Geelong','Victoria','Zimbabwe'),('Sens','Bourgogne','Yemen'),('Boise','ID','Solomon Islands'),('Cranbrook','BC','Lesotho'),('San Vicente de Cañete','LIM','Cameroon');
	INSERT INTO Cities (City,Region,Country) VALUES ('Wals-Siezenheim','Sbg','Tokelau'),('Tamworth','NSW','Saint Kitts and Nevis'),('Cabano','Quebec','Iceland'),('Argenteuil','IL','Swaziland'),('Plock','MA','Aruba'),('Poitiers','Poitou-Charentes','Palau'),('Ryazan','RYA','China'),('Tambov','TAM','Turkmenistan'),('Orai','UP','Zimbabwe'),('Täby','Stockholms län','Belarus');
	INSERT INTO Cities (City,Region,Country) VALUES ('Fort Smith','Arkansas','United Arab Emirates'),('Berlin','BE','Guernsey'),('Taupo','NI','Norfolk Island'),('Smolensk','Smolensk Oblast','Argentina'),('Sijsele','West-Vlaanderen','United States'),('Londerzeel','VB','Malaysia'),('Mercedes','Heredia','Ethiopia'),('Iguala','Guerrero','China'),('Fort Resolution','NT','Angola'),('Provo','Utah','Guatemala');
	INSERT INTO Cities (City,Region,Country) VALUES ('Portree','IN','Equatorial Guinea'),('Itagüí','Antioquia','Taiwan'),('Skegness','Lincolnshire','Saint Martin'),('Doñihue','O Higgins','United Arab Emirates'),('Galway','C','Hungary'),('San Rafael','SJ','Libya'),('Kraków','Malopolskie','Germany'),('Vaughan','ON','Guam'),('Dublin','L','Cook Islands'),('Bruderheim','AB','Korea, North');
	INSERT INTO Cities (City,Region,Country) VALUES ('Hastings','North Island','El Salvador'),('Ostrowiec Swietokrzyski','SK','Costa Rica'),('Rhisnes','Namen','Kenya'),('Acapulco','Gro','Puerto Rico'),('Abaetetuba','Pará','Seychelles'),('Aisemont','NA','Bosnia and Herzegovina'),('Badajoz','Extremadura','Cape Verde'),('Quesada','Alajuela','Western Sahara'),('Jecheon','North Chungcheong','Heard Island and Mcdonald Islands'),('Vienna','Vienna','Nigeria');
	CREATE TABLE Cities (
	id SERIAL PRIMARY KEY,
	City varchar(255),
	Region varchar(50) default NULL,
	Country varchar(100) default NULL
	);

	INSERT INTO Cities (City,Region,Country) VALUES ('Medellín','Antioquia','Nauru'),('Ovalle','IV','Botswana'),('Peñaflor','RM','Grenada'),('Kashmore','SI','Sierra Leone'),('El Bosque','Metropolitana de Santiago','Mauritania'),('Berlin','Berlin','Zimbabwe'),('Castres','Midi-Pyrénées','Belarus'),('Makassar','South Sulawesi','Pitcairn Islands'),('Heist-aan-Zee','WV','Monaco'),('Mexico City','CDM','Kenya');
	INSERT INTO Cities (City,Region,Country) VALUES ('Pinarbasi','Kayseri','Luxembourg'),('Murcia','Murcia','Peru'),('Warren','Michigan','Bhutan'),('Remscheid','NW','Cuba'),('Logan City','Queensland','Sao Tome and Principe'),('Noisy-le-Grand','Île-de-France','Puerto Rico'),('Huancayo','Junín','South Sudan'),('Kapuskasing','ON','Tajikistan'),('Waiheke Island','NI','Colombia'),('Ribeirão Preto','SP','Zimbabwe');
	INSERT INTO Cities (City,Region,Country) VALUES ('Masterton','North Island','Saint Vincent and The Grenadines'),('Neder-Over-Heembeek','BU','Cameroon'),('Norrköping','E','San Marino'),('Anseong','Gyeonggi','Tokelau'),('Feilding','North Island','Pakistan'),('Foz do Iguaçu','PR','Jersey'),('Vespolate','PIE','Chad'),('Vienna','Wie','Malta'),('Dehri','Bihar','Chad'),('Lo Espejo','Metropolitana de Santiago','Zambia');
	INSERT INTO Cities (City,Region,Country) VALUES ('Alexandra','South Island','Lithuania'),('Guadalajara','CM','Kiribati'),('Oviedo','Principado de Asturias','Latvia'),('Gujranwala','SI','Austria'),('Burnie','Tasmania','Liberia'),('Mérida','Yucatán','Turkmenistan'),('Sandviken','X','Israel'),('Otukpo','BE','Libya'),('Fort Collins','Colorado','Portugal'),('Belfast','U','Uruguay');
	INSERT INTO Cities (City,Region,Country) VALUES ('Guelph','Ontario','Anguilla'),('Beauvechain','WB','Sierra Leone'),('Pachuca','Hgo','Tajikistan'),('Täby','Stockholms län','Senegal'),('Helmond','Noord Brabant','Bosnia and Herzegovina'),('Olcenengo','PIE','French Southern Territories'),('Blue Mountains','NSW','Lesotho'),('Cambridge','Massachusetts','Belgium'),('Sullana','Piura','Macao'),('Barcelona','Catalunya','Guatemala');
	INSERT INTO Cities (City,Region,Country) VALUES ('Kawerau','NI','Lithuania'),('Cambridge Bay','NU','United States'),('Zaanstad','N.','Dominican Republic'),('Siquirres','L','New Zealand'),('Poznan','WP','Togo'),('Geelong','Victoria','Zimbabwe'),('Sens','Bourgogne','Yemen'),('Boise','ID','Solomon Islands'),('Cranbrook','BC','Lesotho'),('San Vicente de Cañete','LIM','Cameroon');
	INSERT INTO Cities (City,Region,Country) VALUES ('Wals-Siezenheim','Sbg','Tokelau'),('Tamworth','NSW','Saint Kitts and Nevis'),('Cabano','Quebec','Iceland'),('Argenteuil','IL','Swaziland'),('Plock','MA','Aruba'),('Poitiers','Poitou-Charentes','Palau'),('Ryazan','RYA','China'),('Tambov','TAM','Turkmenistan'),('Orai','UP','Zimbabwe'),('Täby','Stockholms län','Belarus');
	INSERT INTO Cities (City,Region,Country) VALUES ('Fort Smith','Arkansas','United Arab Emirates'),('Berlin','BE','Guernsey'),('Taupo','NI','Norfolk Island'),('Smolensk','Smolensk Oblast','Argentina'),('Sijsele','West-Vlaanderen','United States'),('Londerzeel','VB','Malaysia'),('Mercedes','Heredia','Ethiopia'),('Iguala','Guerrero','China'),('Fort Resolution','NT','Angola'),('Provo','Utah','Guatemala');
	INSERT INTO Cities (City,Region,Country) VALUES ('Portree','IN','Equatorial Guinea'),('Itagüí','Antioquia','Taiwan'),('Skegness','Lincolnshire','Saint Martin'),('Doñihue','O Higgins','United Arab Emirates'),('Galway','C','Hungary'),('San Rafael','SJ','Libya'),('Kraków','Malopolskie','Germany'),('Vaughan','ON','Guam'),('Dublin','L','Cook Islands'),('Bruderheim','AB','Korea, North');
	INSERT INTO Cities (City,Region,Country) VALUES ('Hastings','North Island','El Salvador'),('Ostrowiec Swietokrzyski','SK','Costa Rica'),('Rhisnes','Namen','Kenya'),('Acapulco','Gro','Puerto Rico'),('Abaetetuba','Pará','Seychelles'),('Aisemont','NA','Bosnia and Herzegovina'),('Badajoz','Extremadura','Cape Verde'),('Quesada','Alajuela','Western Sahara'),('Jecheon','North Chungcheong','Heard Island and Mcdonald Islands'),('Vienna','Vienna','Nigeria');