Table configuration
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores values that become constants on-the-fly. This enables developers to write modules/contributions which use values that are set in the admin area without inserting hard-coded values in the php scripts. Overall, constants stored in the database are more manageable and make patching easier.
Table Details
Primary Key
Indexed Fields
Columns
configuration_id 
- A unique, auto incremented value, to identify each configuration record.
Type: int(11) Null: No Default: Extra: auto_increment
configuration_title
- A short, unique name for this configuration option.
Type: text Null: No Default:
configuration_key 
- A unique name for this configuration option (must be ALL_CAPS_WITH_NO_SPACES).
Type: varchar(255) Null: No Default:
configuration_value 
- A value for this configuration option.
Type: text Null: No Default:
configuration_description
- A description for this configuration option.
Type: text Null: No Default:
configuration_group_id

- Links this configuration option to a configuration group. Foreign key to configuration_group.configuration_group_id.
Type: int(11) Null: No Default: 0
sort_order
- The sort order for this configuration option.
Type: int(5) Null: Yes Default: NULL
last_modified
- The date and time this configuration option was last modified.
Type: datetime Null: Yes Default: NULL
date_added
- The date and time this configuration option was first added.
Type: datetime Null: No Default: 0001-01-01 00:00:00
use_function
- Function run on input by the user before making the change to the value.
Type: text Null: Yes Default: NULL
set_function
- Function to draw input fields for this option.
Type: text Null: Yes Default: NULL
