+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_kite_addons:/tablelist/okayapi_kite_addons.html


-- MySQL Table okayapi_kite_addons
-- From: OkayAPI.com
CREATE TABLE `okayapi_kite_addons` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(40) NULL COMMENT '插件名或标识',
    `title` varchar(20) NULL COMMENT '中文名',
    `description` text NULL COMMENT '插件描述',
    `status` tinyint(1) NULL DEFAULT '0' COMMENT '状态 0 未安装 1 启用 2禁用 3损坏',
    `config` text NULL COMMENT '配置',
    `author` varchar(40) NULL COMMENT '作者',
    `version` varchar(20) NULL COMMENT '版本号',
    `has_adminlist` tinyint(1) NULL DEFAULT '0' COMMENT '是否有后台列表',
    `create_at` int(11) NULL COMMENT '创建时间',
    `update_at` int(11) NULL COMMENT '更新时间',
    KEY `name` (`name`),
    KEY `title` (`title`),
    KEY `description` (`description`),
    KEY `status` (`status`),
    KEY `config` (`config`),
    KEY `author` (`author`),
    KEY `version` (`version`),
    KEY `has_adminlist` (`has_adminlist`),
    KEY `create_at` (`create_at`),
    KEY `update_at` (`update_at`),
    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-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
namevarchar(40)插件名或标识
titlevarchar(20)中文名
descriptiontext插件描述
statustinyint(1)0状态 0 未安装 1 启用 2禁用 3损坏0
configtext配置
authorvarchar(40)作者
versionvarchar(20)版本号
has_adminlisttinyint(1)0是否有后台列表0
create_atint(11)创建时间
update_atint(11)更新时间

Guess You Like

MySQL Table Design okayapi_kite_auth_role

MySQL Table Design okayapi_kite_auth_rule

MySQL Table Design okayapi_kite_auth_user

MySQL Table Design okayapi_kite_block

MySQL Table Design okayapi_kite_document_category

MySQL Table Design okayapi_kite_document_comments

MySQL Table Design okayapi_kite_document_comments_like

MySQL Table Design okayapi_kite_document_content

MySQL Table Design okayapi_kite_document_content_extra

MySQL Table Design okayapi_kite_document_content_like

MySQL Table Design okayapi_kite_document_field

MySQL Table Design okayapi_kite_document_model

MySQL Table Design okayapi_kite_document_model_field

MySQL Table Design okayapi_kite_feedback

MySQL Table Design okayapi_kite_hooks

MySQL Table Design okayapi_kite_language

MySQL Table Design okayapi_kite_link

MySQL Table Design okayapi_kite_log

MySQL Table Design okayapi_kite_message

MySQL Table Design okayapi_kite_navigation

TOP ↑