+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_fie_plugin:/tablelist/okayapi_fie_plugin.html


-- MySQL Table okayapi_fie_plugin
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_plugin` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_fie_plugin_type` tinyint(3) NULL DEFAULT '1' COMMENT '插件类型;1:网站;8:微信',
    `has_admin` tinyint(3) NULL DEFAULT '0' COMMENT '是否有后台管理,0:没有;1:有',
    `okayapi_fie_plugin_status` tinyint(3) NULL DEFAULT '1' COMMENT '状态;1:开启;0:禁用',
    `create_time` int(10) NULL DEFAULT '0' COMMENT '插件安装时间',
    `okayapi_fie_plugin_name` varchar(50) NULL COMMENT '插件标识名,英文字母(惟一)',
    `title` varchar(50) NULL COMMENT '插件名称',
    `demo_url` varchar(50) NULL COMMENT '演示地址,带协议',
    `hooks` varchar(255) NULL COMMENT '实现的钩子;以“,”分隔',
    `author` varchar(20) NULL COMMENT '插件作者',
    `author_url` varchar(50) NULL COMMENT '作者网站链接',
    `version` varchar(20) NULL COMMENT '插件版本号',
    `description` varchar(255) NULL COMMENT '插件描述',
    `config` text NULL COMMENT '插件配置',
    KEY `okayapi_fie_plugin_type` (`okayapi_fie_plugin_type`),
    KEY `has_admin` (`has_admin`),
    KEY `okayapi_fie_plugin_status` (`okayapi_fie_plugin_status`),
    KEY `create_time` (`create_time`),
    KEY `okayapi_fie_plugin_name` (`okayapi_fie_plugin_name`),
    KEY `title` (`title`),
    KEY `demo_url` (`demo_url`),
    KEY `hooks` (`hooks`),
    KEY `author` (`author`),
    KEY `author_url` (`author_url`),
    KEY `version` (`version`),
    KEY `description` (`description`),
    KEY `config` (`config`),
    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-13 of 13 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_fie_plugin_typetinyint(3)1插件类型;1:网站;8:微信1
has_admintinyint(3)0是否有后台管理,0:没有;1:有0
okayapi_fie_plugin_statustinyint(3)1状态;1:开启;0:禁用1
create_timeint(10)0插件安装时间0
okayapi_fie_plugin_namevarchar(50)插件标识名,英文字母(惟一)
titlevarchar(50)插件名称
demo_urlvarchar(50)演示地址,带协议
hooksvarchar(255)实现的钩子;以“,”分隔
authorvarchar(20)插件作者
author_urlvarchar(50)作者网站链接
versionvarchar(20)插件版本号
descriptionvarchar(255)插件描述
configtext插件配置

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_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

MySQL Table Design okayapi_fie_role

TOP ↑