Currency (tbl)

From UG

Revision as of 20:16, 16 December 2009 (edit) Alex (Talk | contribs) (Created page with 'Category:DB <pre> mysql> describe tblCurrency; +--------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | …') ← Older edit		Current revision as of 08:44, 31 January 2010 (edit) (undo) Alex (Talk | contribs) m (moved Tbl Currency to Currency (tbl))
(3 intermediate revisions not shown)
Line 1:		Line 1:
-	[[Category:DB]]	+	[[Category:Acc Data Objects]]
	<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;
Line 14:		Line 34:
	4 rows in set		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
	</pre>		</pre>

---

Current revision as of 08:44, 31 January 2010

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

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