Currency (tbl)

From UG

Jump to: navigation, search




-- ----------------------------

-- 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
Personal tools