qwert2001qwert

qwert2001qwert / currency.sql

Last active September 1, 2021 16:16 — forked from allanlaal/currency.sql

SQL table of World currencies and symbols (коды валют мира и их символы)


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


	INSERT INTO `currency` (`iso`, `name`, `symbol`) VALUES
	('ADP', 'Andorran Peseta', 'ADP'),