Table product types
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
Table Details
Primary Key
Indexed Fields
Columns
type_id 
- 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
Type: varchar(255) Null: No Default:
type_master_type 
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).
