okayapi_fie_option - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_fie_option：/tablelist/okayapi_fie_option.html


-- MySQL Table okayapi_fie_option
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_option` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `autoload` tinyint(3) NULL DEFAULT '1' COMMENT '是否自动加载;1:自动加载;0:不自动加载',
    `option_name` varchar(64) NULL COMMENT '配置名',
    `option_value` longtext NULL COMMENT '配置值',
    KEY `autoload` (`autoload`),
    KEY `option_name` (`option_name`),
    KEY `option_value` (`option_value`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-全站配置表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-3 of 3 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
autoload	tinyint(3)	1	否	是否自动加载;1:自动加载;0:不自动加载		1
option_name	varchar(64)		否	配置名	Unique Index
option_value	longtext		是	配置值