Table products options values

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

Database Version

1.3.5


Description

Holds the textual description of each product option for each language used in the store. Also holds the sort order for each option and as this is held per option/language combination, allows each language to have its own sort order.


Table Details

Primary Key

products_options_values_id
language_id

Indexed Fields

products_options_values_name
products_options_values_sort_order


Columns

products_options_values_id Primary Key

A unique value to identify each products option values record.
Type: int(11)
Null: No
Default: 0


language_id Primary Key

Cross-reference link to the languages table.
Type: int(11)
Null: No
Default: 1


products_options_values_name Index

The name of the given option value.
Type: varchar(64)
Null: No
Default:


products_options_values_sort_order Index

The sort order of the given option value.
Type: int(11)
Null: No
Default: 0


Default Entries (assuming demo data installed)

TODO!