Table manufacturers info
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores information about each manufacturer that may be unique for each language.
Table Details
Primary Key
Indexed Fields
- None.
Columns
manufacturers_id 
- Links the manufacturers info record to the manufacturers table.
Type: int(11) Null: No Default: 0
languages_id
- Links the manufacturers info record to the languages table.
Type: int(11) Null: No Default: 0
manufacturers_url
- Language specific URL to the manufacturer's website.
Type: varchar(255) Null: No Default:
url_clicked
- The number of times this record's URL has been clicked on.
Type: int(5) Null: No Default: 0
date_last_click
- The date and time this record's URL was last clicked.
Type: datetime Null: Yes Default: NULL
Default Entries
manufacturers_id: 1 languages_id: 1 manufacturers_url: http://www.matrox.com url_clicked: 0 date_last_click: NULL
manufacturers_id: 2 languages_id: 1 manufacturers_url: http://www.microsoft.com url_clicked: 0 date_last_click: NULL
manufacturers_id: 3 languages_id: 1 manufacturers_url: http://www.warner.com url_clicked: 0 date_last_click: NULL
manufacturers_id: 4 languages_id: 1 manufacturers_url: http://www.fox.com url_clicked: 0 date_last_click: NULL
manufacturers_id: 5 languages_id: 1 manufacturers_url: http://www.logitech.com url_clicked: 0 date_last_click: NULL
manufacturers_id: 6 languages_id: 1 manufacturers_url: http://www.canon.com url_clicked: 0 date_last_click: NULL
manufacturers_id: 7 languages_id: 1 manufacturers_url: http://www.sierra.com url_clicked: 0 date_last_click: NULL
manufacturers_id: 8 languages_id: 1 manufacturers_url: http://www.infogrames.com url_clicked: 0 date_last_click: NULL
manufacturers_id: 9 languages_id: 1 manufacturers_url: http://www.hewlettpackard.com url_clicked: 0 date_last_click: NULL
