+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_sys_addon_manage:/tablelist/okayapi_sys_addon_manage.html


-- MySQL Table okayapi_sys_addon_manage
-- From: OkayAPI.com
CREATE TABLE `okayapi_sys_addon_manage` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(20) NOT NULL COMMENT '中文名',
    `name` varchar(40) NOT NULL COMMENT '插件名或标识',
    `title_initial` varchar(1) NOT NULL COMMENT '首字母拼音',
    `cover` varchar(200) NOT NULL COMMENT '封面',
    `group` varchar(20) NOT NULL COMMENT '组别',
    `brief_introduction` varchar(140) NOT NULL COMMENT '简单介绍',
    `description` varchar(1000) NOT NULL COMMENT '插件描述',
    `config` text NOT NULL COMMENT '配置',
    `author` varchar(40) NOT NULL COMMENT '作者',
    `version` varchar(20) NOT NULL COMMENT '版本号',
    `wechat_message` varchar(1000) NOT NULL COMMENT '接收微信回复类别',
    `is_setting` tinyint(1) NOT NULL DEFAULT '-1' COMMENT '设置',
    `is_hook` tinyint(1) NOT NULL DEFAULT '0' COMMENT '钩子[0:不支持;1:支持]',
    `is_rule` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否要嵌入规则',
    `is_mini_program` tinyint(4) NOT NULL DEFAULT '0' COMMENT '小程序[0:不支持;1:支持]',
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
    KEY `title` (`title`),
    KEY `name` (`name`),
    KEY `title_initial` (`title_initial`),
    KEY `cover` (`cover`),
    KEY `group` (`group`),
    KEY `brief_introduction` (`brief_introduction`),
    KEY `description` (`description`),
    KEY `config` (`config`),
    KEY `author` (`author`),
    KEY `version` (`version`),
    KEY `wechat_message` (`wechat_message`),
    KEY `is_setting` (`is_setting`),
    KEY `is_hook` (`is_hook`),
    KEY `is_rule` (`is_rule`),
    KEY `is_mini_program` (`is_mini_program`),
    KEY `status` (`status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '系统插件表';

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


MySQL database table structure design

Displaying 1-16 of 16 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlevarchar(20)中文名
namevarchar(40)插件名或标识Normal Index
title_initialvarchar(1)首字母拼音
covervarchar(200)封面
groupvarchar(20)组别
brief_introductionvarchar(140)简单介绍
descriptionvarchar(1000)插件描述
configtext配置
authorvarchar(40)作者
versionvarchar(20)版本号
wechat_messagevarchar(1000)接收微信回复类别
is_settingtinyint(1)-1设置-1
is_hooktinyint(1)0钩子[0:不支持;1:支持]0
is_ruletinyint(4)0是否要嵌入规则0
is_mini_programtinyint(4)0小程序[0:不支持;1:支持]0
statustinyint(4)1状态[-1:删除;0:禁用;1启用]Normal Index1

Guess You Like

MySQL Table Design okayapi_file_uploads

MySQL Table Design okayapi_framework_log

MySQL Table Design okayapi_provinces_log

MySQL Table Design okayapi_sms_log

MySQL Table Design okayapi_member_datas_log

MySQL Table Design okayapi_member_vip

MySQL Table Design okayapi_sys_message

MySQL Table Design okayapi_sys_notice_manage

MySQL Table Design okayapi_sys_menu_manage

MySQL Table Design okayapi_sys_config_manage

MySQL Table Design okayapi_server_manage

TOP ↑