Table manufacturers
From Zen Cart(tm) Wiki
Revision as of 13:00, 8 September 2006 by Allcanadiansearch.ca (Talk | contribs)
Contents |
Database Version
- 1.3.5
Description
- Stores information about each manufacturer that is common for all languages.
Table Details
Primary Key
Indexed Fields
Columns
manufacturers_id 
- A unique, auto incremented value, to identify each manufacturers record.
Type: int(11) Null: No Default: Extra: auto_increment
manufacturers_name 
- The name of the manufacturer.
Type: varchar(32) Null: No Default:
manufacturers_image
- The path and filename of the manufacturers image.
Type: varchar(64) Null: Yes Default: NULL
date_added
- The date and time that the manufacturers record was first added.
Type: datetime Null: Yes Default: NULL
last_modified
- The date and time that the manufacturers record was last modified.
Type: datetime Null: Yes Default: NULL
Default Entries
manufacturers_id: 1 manufacturers_name: Matrox manufacturers_image: manufacturers/manufacturer_matrox.gif date_added: 2003-12-23 03:18:19 last_modified: NULL
manufacturers_id: 2 manufacturers_name: Microsoft manufacturers_image: manufacturers/manufacturer_microsoft.gif date_added: 2003-12-23 03:18:19 last_modified: NULL
manufacturers_id: 3 manufacturers_name: Warner manufacturers_image: manufacturers/manufacturer_warner.gif date_added: 2003-12-23 03:18:19 last_modified: NULL
manufacturers_id: 4 manufacturers_name: Fox manufacturers_image: manufacturers/manufacturer_fox.gif date_added: 2003-12-23 03:18:19 last_modified: NULL
manufacturers_id: 5 manufacturers_name: Logitech manufacturers_image: manufacturers/manufacturer_logitech.gif date_added: 2003-12-23 03:18:19 last_modified: NULL
manufacturers_id: 6 manufacturers_name: Canon manufacturers_image: manufacturers/manufacturer_canon.gif date_added: 2003-12-23 03:18:19 last_modified: NULL
manufacturers_id: 7 manufacturers_name: Sierra manufacturers_image: manufacturers/manufacturer_sierra.gif date_added: 2003-12-23 03:18:19 last_modified: NULL
manufacturers_id: 8 manufacturers_name: GT Interactive manufacturers_image: manufacturers/manufacturer_gt_interactive.gif date_added: 2003-12-23 03:18:19 last_modified: NULL
manufacturers_id: 9 manufacturers_name: Hewlett Packard manufacturers_image: manufacturers/manufacturer_hewlett_packard.gif date_added: 2003-12-23 03:18:19 last_modified: NULL
