setting table:
- setting_id
- field_name
- field_label
- filed_value
- field_type (text,number,upload,list,selecet,....)
- filed_id (used for programming calling (set_setting(filed_id,filed_value), get_setting(filed_id)))
- filed_priority
- field_tooltip
- field_group
- field_tab (used where we have many fields and want to organize it in multi tab
- field_default_value
CREATE TABLE setting (
setting_id int(11) NOT NULL AUTO_INCREMENT ,
setting_tab_id int(255) NULL DEFAULT NULL ,
name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
label varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
value varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
type enum('select','list','upload','number','text') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
id varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
priority varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
tooltip varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
group varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
default varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (setting_id)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
CHECKSUM=0
ROW_FORMAT=DYNAMIC
DELAY_KEY_WRITE=0
;
CREATE TABLE setting_group (
setting_group_id int(11) NULL DEFAULT NULL ,
name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
CHECKSUM=0
ROW_FORMAT=DYNAMIC
DELAY_KEY_WRITE=0
;
CREATE TABLE setting_tab (
setting_tab_id int(11) NOT NULL AUTO_INCREMENT ,
setting_group_id int(11) NULL DEFAULT NULL ,
name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
priority varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
description longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (setting_tab_id)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
CHECKSUM=0
ROW_FORMAT=DYNAMIC
DELAY_KEY_WRITE=0
;