Table specials
From Zen Cart(tm) Wiki
Contents |
Database version
v1.3.0
Description
Table Details
Primary Key
specials_id
Indexed Fields
status
products_id
specials_date_available
expires_date
Columns
specials_id
Type: int(11)
Null: No
Default:
Extra: auto_increment
products_id 
Type: int(11)
Null: No
Default: 0
specials_new_products_price
Type: decimal(15,4)
Null: No
Default: 0.0000
specials_date_added
Type: datetime
Null: Yes
Default: NULL
specials_last_modified
Type: datetime
Null: Yes
Default: NULL
expires_date
Type: date
Null: No
Default: '0001-01-01'
date_status_change
Type: datetime
Null: Yes
Default: NULL
status
Type: int(1)
Null: No
Default: 1
specials_date_available
Type: date
Null: No
Default: '0001-01-01'