Table product types

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

Database Version

1.3.5


Description

Help.gif


Table Details

Primary Key

type_id

Indexed Fields

type_master_type


Columns

type_id Primary Key

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


type_name

The name of the product type.
Type: varchar(255)
Null: No
Default:


type_handler

Help.gif
Type: varchar(255)
Null: No
Default:


type_master_type Index

Help.gif
Type: int(11)
Null: No
Default: 1


allow_add_to_cart

Can the product type be added to the cart? Can be set to N (no) or Y (yes).
Type: char(1)
Null: No
Default: Y


default_image

The default image of the product type.
Type: varchar(255)
Null: No
Default:


date_added

The date and time the product type was first added.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


last_modified

The date and time the product type was last modified.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


Default Entries

type_id: 1
type_name: Product - General
type_handler: product
type_master_type: 1
allow_add_to_cart: Y
default_image:
date_added: Will always be the date and time the database was installed (for default product types).
last_modified: Will initially be the date and time the database was installed (for default product types).


type_id: 2
type_name: Product - Music
type_handler: product_music
type_master_type: 1
allow_add_to_cart: Y
default_image:
date_added: Will always be the date and time the database was installed (for default product types).
last_modified: Will initially be the date and time the database was installed (for default product types).


type_id: 3
type_name: Document - General
type_handler: document_general
type_master_type: 3
allow_add_to_cart: N
default_image:
date_added: Will always be the date and time the database was installed (for default product types).
last_modified: Will initially be the date and time the database was installed (for default product types).


type_id: 4
type_name: Document - Product
type_handler: document_product
type_master_type: 3
allow_add_to_cart: Y
default_image:
date_added: Will always be the date and time the database was installed (for default product types).
last_modified: Will initially be the date and time the database was installed (for default product types).


type_id: 5
type_name: Product - Free Shipping
type_handler: product_free_shipping
type_master_type: 1
allow_add_to_cart: Y
default_image:
date_added: Will always be the date and time the database was installed (for default product types).
last_modified: Will initially be the date and time the database was installed (for default product types).