The popular open-source contract for web professionals by Stuff & Nonsense
- Originally published: 23rd December 2008
- Revised date: March 15th 2016
- Original post
AllanJeremy
/ currency.sql
Last active
February 21, 2018 10:23
— forked from allanlaal/currency.sql
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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- 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; |
AllanJeremy
/ Contract Killer 3.md
Created
August 24, 2017 12:13
The latest version of my ‘killer contract’ for web designers and developers
AllanJeremy
/ countries.sql
Created
July 25, 2017 16:31
— forked from adhipg/countries.sql
Sql dump of all the Countries, Country Codes, Phone codes.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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; |