Currency (tbl)
From UG
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