yani- / mysqldump-factory Goto Github PK

CREATE TABLE oxconfigdisplay (
OXID char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Config id (extends oxconfig record with this id)',
OXCFGMODULE varchar(100) NOT NULL DEFAULT '' COMMENT 'Module or theme specific config (theme:themename, module:modulename)',
OXCFGVARNAME varchar(100) NOT NULL DEFAULT '' COMMENT 'Variable name',
OXGROUPING varchar(255) NOT NULL DEFAULT '' COMMENT 'Grouping (groups config fields to array with specified value as key)',
OXVARCONSTRAINT varchar(255) NOT NULL DEFAULT '' COMMENT 'Serialized constraints',
OXPOS int(11) NOT NULL DEFAULT '0' COMMENT 'Sorting',
OXTIMESTAMP timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Timestamp',
PRIMARY KEY (OXID),
KEY list (OXCFGMODULE,OXCFGVARNAME)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Additional configuraion fields';