Mwumva fordarnold

🎯

Focused

Looking for new ideas. Software product design.

allanlaal / currency.sql

Last active December 5, 2021 06:51

SQL table of World currencies (even some expired ones) Source: http://bcmoney-mobiletv.com/blog/2008/12/30/currency-codes-dropdown-and-sql-table/ Cleaned up a bit, uses InnoDB and iso currency code as the PRIMARY key

	--
	-- Table structure for table `currency`
	--

	CREATE TABLE IF NOT EXISTS `currency` (
	`iso` char(3) CHARACTER SET utf8 NOT NULL DEFAULT '',
	`name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
	PRIMARY KEY (`iso`),
	UNIQUE KEY `name` (`name`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

adhipg / countries.sql

Created January 12, 2012 11:41

Sql dump of all the Countries, Country Codes, Phone codes.

	CREATE TABLE IF NOT EXISTS `country` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`iso` char(2) NOT NULL,
	`name` varchar(80) NOT NULL,
	`nicename` varchar(80) NOT NULL,
	`iso3` char(3) DEFAULT NULL,
	`numcode` smallint(6) DEFAULT NULL,
	`phonecode` int(5) NOT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;