Table CURRENCIES incorporates decimal_point and thousand_point per currency
Code: Select all
DROP TABLE IF EXISTS currencies;
CREATE TABLE currencies (
currencies_id int(11) NOT NULL auto_increment,
title varchar(32) NOT NULL default '',
code char(3) NOT NULL default '',
symbol_left varchar(24) default NULL,
symbol_right varchar(24) default NULL,
decimal_point char(1) default NULL,
thousands_point char(1) default NULL,
decimal_places char(1) default NULL,
value float(13,8) default NULL,
last_updated datetime default NULL,
PRIMARY KEY (currencies_id)
) ENGINE=MyISAM;
Its's not language depending.
Alegro has (only):
Code: Select all
CREATE TABLE IF NOT EXISTS `currency` (
`currency_id` int(11) NOT NULL auto_increment,
`title` varchar(32) collate utf8_unicode_ci NOT NULL default '',
`code` varchar(3) collate utf8_unicode_ci NOT NULL default '',
`symbol_left` varchar(12) collate utf8_unicode_ci default NULL,
`symbol_right` varchar(12) collate utf8_unicode_ci default NULL,
`decimal_place` char(1) collate utf8_unicode_ci default NULL,
`value` double(13,8) default NULL,
`date_modified` datetime default NULL,
PRIMARY KEY (`currency_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;