Table specials

From Zen Cart(tm) Wiki
Revision as of 14:19, 27 April 2007 by Emeitner (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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 Primary Key

Type: int(11)
Null: No
Default:
Extra: auto_increment

products_id Index

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 Index

Type: date
Null: No
Default: '0001-01-01'

date_status_change

Type: datetime
Null: Yes
Default: NULL

status Index

Type: int(1)
Null: No
Default: 1

specials_date_available Index

Type: date
Null: No
Default: '0001-01-01'


Defaults