Table address format
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores all the available formats for the ouput of an address stored in the address_book table.
- These formats are used to display addresses in the correct format, as selected by the related address_format field in the countries table.
- These formats are ISO standards.
Table Details
Primary Key
Indexed Fields
- None.
Columns
address_format_id 
- A unique, auto incremented value, to identify each address format record.
Type: int(11) Null: No Default: Extra: auto_increment
address_format
- The format used for displaying the shipping/billing address.
Type: varchar(128) Null: No Default:
Variables!
Possible variables are:
- $firstname - first name
- $lastname - last name
- $cr - forces line break
- $streets - street address
- $city - city
- $state - state
- $statecomma - state followed by a comma and a space
- $postcode - postcode
- $country - country
- Punctuation, spaces and other characters can be added as well before or after the variables
address_summary
- Summary of the address format used for display purposes.
Type: varchar(48) Null: No Default:
Default Entries
address_format_id: 1 address_format: $firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country address_summary: $city / $country
address_format_id: 2 address_format: $firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country address_summary: $city, $state / $country
address_format_id: 3 address_format: $firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country address_summary: $state / $country
address_format_id: 4 address_format: $firstname $lastname$cr$streets$cr$city ($postcode)$cr$country address_summary: $postcode / $country
address_format_id: 5 address_format: $firstname $lastname$cr$streets$cr$postcode $city$cr$country address_summary: $city / $country
