+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_fie_theme_file:/tablelist/okayapi_fie_theme_file.html


-- MySQL Table okayapi_fie_theme_file
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_theme_file` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `is_public` tinyint(4) NULL DEFAULT '0' COMMENT '是否公共的模板文件',
    `list_order` float NULL DEFAULT '10000' COMMENT '排序',
    `theme` varchar(20) NULL COMMENT '模板名称',
    `okayapi_fie_theme_file_name` varchar(20) NULL COMMENT '模板文件名',
    `okayapi_fie_theme_file_action` varchar(50) NULL COMMENT '操作',
    `okayapi_fie_theme_file_file` varchar(50) NULL COMMENT '模板文件,相对于模板根目录,如Portal/index.html',
    `description` varchar(100) NULL COMMENT '模板文件描述',
    `more` text NULL COMMENT '模板更多配置,用户自己后台设置的',
    `config_more` text NULL COMMENT '模板更多配置,来源模板的配置文件',
    `draft_more` text NULL COMMENT '模板更多配置,用户临时保存的配置',
    KEY `is_public` (`is_public`),
    KEY `list_order` (`list_order`),
    KEY `theme` (`theme`),
    KEY `okayapi_fie_theme_file_name` (`okayapi_fie_theme_file_name`),
    KEY `okayapi_fie_theme_file_action` (`okayapi_fie_theme_file_action`),
    KEY `okayapi_fie_theme_file_file` (`okayapi_fie_theme_file_file`),
    KEY `description` (`description`),
    KEY `more` (`more`),
    KEY `config_more` (`config_more`),
    KEY `draft_more` (`draft_more`),
    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-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
is_publictinyint(4)0是否公共的模板文件0
list_orderfloat10000排序10000
themevarchar(20)模板名称
okayapi_fie_theme_file_namevarchar(20)模板文件名
okayapi_fie_theme_file_actionvarchar(50)操作
okayapi_fie_theme_file_filevarchar(50)模板文件,相对于模板根目录,如Portal/index.html
descriptionvarchar(100)模板文件描述
moretext模板更多配置,用户自己后台设置的
config_moretext模板更多配置,来源模板的配置文件
draft_moretext模板更多配置,用户临时保存的配置

Guess You Like

MySQL Table Design okayapi_message

MySQL Table Design okayapi_article

MySQL Table Design okayapi_fie_admin_menu

MySQL Table Design okayapi_fie_asset

MySQL Table Design okayapi_fie_auth_access

MySQL Table Design okayapi_fie_auth_rule

MySQL Table Design okayapi_fie_comment

MySQL Table Design okayapi_fie_hook

MySQL Table Design okayapi_fie_hook_plugin

MySQL Table Design okayapi_fie_link

MySQL Table Design okayapi_fie_nav

MySQL Table Design okayapi_fie_nav_menu

MySQL Table Design okayapi_fie_option

MySQL Table Design okayapi_fie_plugin

MySQL Table Design okayapi_fie_portal_category

MySQL Table Design okayapi_fie_portal_category_post

MySQL Table Design okayapi_fie_portal_post

MySQL Table Design okayapi_fie_portal_tag

MySQL Table Design okayapi_fie_portal_tag_post

MySQL Table Design okayapi_fie_recycle_bin

TOP ↑