MySQL Create Table SQL
Table Structure: okayapi_fie_hook:/tablelist/okayapi_fie_hook.html
-- MySQL Table okayapi_fie_hook
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_hook` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_fie_hook_type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '钩子类型(1:系统钩子;2:应用钩子;3:模板钩子;4:后台模板钩子)',
`once` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否只允许一个插件运行(0:多个;1:一个)',
`okayapi_fie_hook_name` varchar(50) NOT NULL COMMENT '钩子名称',
`hook` varchar(50) NOT NULL COMMENT '钩子',
`app` varchar(15) NOT NULL COMMENT '应用名(只有应用钩子才用)',
`description` varchar(255) NOT NULL COMMENT '描述',
KEY `okayapi_fie_hook_type` (`okayapi_fie_hook_type`),
KEY `once` (`once`),
KEY `okayapi_fie_hook_name` (`okayapi_fie_hook_name`),
KEY `hook` (`hook`),
KEY `app` (`app`),
KEY `description` (`description`),
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-6 of 6 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_fie_hook_type | tinyint(3) | 0 | 否 | 钩子类型(1:系统钩子;2:应用钩子;3:模板钩子;4:后台模板钩子) | 0 | |
once | tinyint(3) | 0 | 否 | 是否只允许一个插件运行(0:多个;1:一个) | 0 | |
okayapi_fie_hook_name | varchar(50) | 否 | 钩子名称 | |||
hook | varchar(50) | 否 | 钩子 | |||
app | varchar(15) | 否 | 应用名(只有应用钩子才用) | |||
description | varchar(255) | 否 | 描述 |