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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_fie_plugin_type | tinyint(3) | 1 | 否 | 插件类型;1:网站;8:微信 | 1 | |
has_admin | tinyint(3) | 0 | 否 | 是否有后台管理,0:没有;1:有 | 0 | |
okayapi_fie_plugin_status | tinyint(3) | 1 | 否 | 状态;1:开启;0:禁用 | 1 | |
create_time | int(10) | 0 | 否 | 插件安装时间 | 0 | |
okayapi_fie_plugin_name | varchar(50) | 否 | 插件标识名,英文字母(惟一) | |||
title | varchar(50) | 否 | 插件名称 | |||
demo_url | varchar(50) | 否 | 演示地址,带协议 | |||
hooks | varchar(255) | 否 | 实现的钩子;以“,”分隔 | |||
author | varchar(20) | 否 | 插件作者 | |||
author_url | varchar(50) | 否 | 作者网站链接 | |||
version | varchar(20) | 否 | 插件版本号 | |||
description | varchar(255) | 否 | 插件描述 | |||
config | text | 是 | 插件配置 |