Currency (tbl)

From UG

Revision as of 21:51, 16 December 2009 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 21:33, 18 December 2009 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 2:		Line 2:
	<pre>		<pre>
		+
		+
		+	-- ----------------------------
		+
		+	-- 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;		mysql> describe tblCurrency;

---

Revision as of 21:33, 18 December 2009

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

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