Currency (tbl)
From UG
-- ---------------------------- -- Table structure for tblCurrency -- ---------------------------- DROP TABLE IF EXISTS `tblCurrency`; CREATE TABLE `tblCurrency` ( `Id` int(10) NOT NULL auto_increment, `Name` varchar(50) NOT NULL, `Abbreviation` varchar(3) NOT NULL, `IsMain` tinyint(1) NOT NULL default '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1; mysql> describe tblCurrency; +--------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+----------------+ | Id | int(10) | NO | PRI | NULL | auto_increment | | Name | varchar(50) | NO | | NULL | | | Abbreviation | varchar(3) | NO | | NULL | | | IsMain | tinyint(1) | NO | | 0 | | +--------------+-------------+------+-----+---------+----------------+ 4 rows in set mysql> select * from tblCurrency; +----+-------------------+--------------+--------+ | Id | Name | Abbreviation | IsMain | +----+-------------------+--------------+--------+ | 1 | US Dollars | USD | 1 | | 3 | Euro | EUR | 0 | | 9 | Swiss Francs | CHF | 0 | | 11 | British Pound | GBP | 0 | | 15 | Russian Rubles | RUB | 0 | | 16 | Hong kong Dollars | HKD | 0 | | 18 | Ukrainian Hrivna | UAH | 0 | | 20 | Australian Dollar | AUD | 0 | | 22 | HHH | HHH | 0 | | 24 | New | NEW | 0 | | 25 | new | nnn | 0 | | 26 | sfagawgawg | nn2 | 0 | | 27 | Test | TTT | 0 | +----+-------------------+--------------+--------+ 13 rows in set