Table currencies
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores all the different installed currencies information.
Table Details
Primary Key
Indexed Fields
- None.
Columns
currencies_id 
- A unique, auto incremented value, to identify each currency record.
Type: int(11) Null: No Default: Extra: auto_increment
title
- The title of the currency record.
Type: varchar(32) Null: No Default:
code
- The three-character code of the currency record.
Type: char(3) Null: No Default:
symbol_left
- The text/symbols preceeding the currency record for display purposes.
Type: varchar(24) Null: Yes Default: NULL
symbol_right
- The text/symbols trailing the currency record for display purposes.
Type: varchar(24) Null: Yes Default: NULL
decimal_point
- The symbol used to represent the decimal point of the currency record for display purposes.
Type: char(1) Null: Yes Default: NULL
thousands_point
- The symbol used to represent the thousands separator of the currency record for display purposes.
Type: char(1) Null: Yes Default: NULL
decimal_places
- The number of decimal places of the currency record.
Type: char(1) Null: Yes Default: NULL
value
- The value of the currency record in relation to the default currency for currency conversion purposes.
Type: float(13,8) Null: Yes Default: NULL
last_updated
- The date and time that the record was last updated.
Type: datetime Null: Yes Default: NULL
Default Entries
currencies_id: 1 title: US Dollar code: USD symbol_left: $ symbol_right: decimal_point: . thousands_point: , decimal_places: 2 value: 1.00000000 last_updated: This value will always initially be the date and time that the database was setup.
currencies_id: 2 title: Euro code: EUR symbol_left: symbol_right: EUR decimal_point: . thousands_point: , decimal_places: 2 value: 1.20389998 last_updated: This value will always initially be the date and time that the database was setup.
