Table configuration

From Zen Cart(tm) Wiki
Revision as of 21:14, 16 November 2012 by Wilt (talk | contribs) (use_function)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

configuration_id

Indexed Fields

configuration_key
configuration_value
configuration_group_id


Columns

configuration_id Primary Key

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 Index

A unique name for this configuration option (must be ALL_CAPS_WITH_NO_SPACES).
Type: varchar(255)
Null: No
Default:


configuration_value Index

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 Foreign Key Index

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 configuration value before displaying.
Type: text
Null: Yes
Default: NULL

set_function

Function to draw input fields for this option.
Type: text
Null: Yes
Default: NULL


Default Entries

Help.gif
The script in the discussion area of this page needs to be run to update the default entries to 1.3.5.