Abdullah Imran FlavaSava7

My gists: https://gist.github.com/FlavaSava7

FlavaSava7 / cities_countriesId_english.sql

Created October 8, 2017 13:11

This list is connected to https://gist.github.com/FlavaSava7/3c0f7f630d0cce5abaf0ad2e0c8e88df countries list.

	CREATE TABLE `cities` (
	`id` int NOT NULL ,
	`city_name` varchar(100) NOT NULL default '',
	`country_id` varchar(3) NOT NULL,

	PRIMARY KEY (`id`),
	FOREIGN KEY (`country_id`) REFERENCES countries(`country_code`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	--
	-- Dumping data for table `countries`

FlavaSava7 / countries_nationalities_arabic_english.sql

Last active October 13, 2024 09:52

SQL Countries & Nationalities List : English and Arabic

	CREATE TABLE `countries` (
	`country_code` varchar(2) NOT NULL default '',
	`country_enName` varchar(100) NOT NULL default '',
	`country_arName` varchar(100) NOT NULL default '',
	`country_enNationality` varchar(100) NOT NULL default '',
	`country_arNationality` varchar(100) NOT NULL default '',
	PRIMARY KEY (`country_code`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	--
	-- Dumping data for table `countries`