Table manufacturers

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.5


Description

Stores information about each manufacturer that is common for all languages.


Table Details

Primary Key

manufacturers_id

Indexed Fields

manufacturers_name


Columns

manufacturers_id Primary Key

A unique, auto incremented value, to identify each manufacturers record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


manufacturers_name Index

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