Table manufacturers info

From Zen Cart(tm) Wiki
Revision as of 13:01, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Stores information about each manufacturer that may be unique for each language.


Table Details

Primary Key

manufacturers_id
languages_id

Indexed Fields

None.


Columns

manufacturers_id Primary Key

Links the manufacturers info record to the manufacturers table.
Type: int(11)
Null: No
Default: 0


languages_id Primary Key

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