+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_sys_config_manage:/tablelist/okayapi_sys_config_manage.html


-- MySQL Table okayapi_sys_config_manage
-- From: OkayAPI.com
CREATE TABLE `okayapi_sys_config_manage` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(50) NOT NULL COMMENT '配置标题',
    `name` varchar(30) NOT NULL COMMENT '配置标识',
    `type` varchar(30) NOT NULL COMMENT '配置类型',
    `cate_id` int(10) NOT NULL COMMENT '配置分类',
    `extra` varchar(1000) NOT NULL COMMENT '配置值',
    `remark` varchar(1000) NOT NULL COMMENT '配置说明',
    `value` text NOT NULL COMMENT '配置值',
    `is_hide_remark` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否隐藏说明',
    `sort` int(10) NOT NULL COMMENT '排序',
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
    KEY `title` (`title`),
    KEY `name` (`name`),
    KEY `type` (`type`),
    KEY `cate_id` (`cate_id`),
    KEY `extra` (`extra`),
    KEY `remark` (`remark`),
    KEY `value` (`value`),
    KEY `is_hide_remark` (`is_hide_remark`),
    KEY `sort` (`sort`),
    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-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlevarchar(50)配置标题
namevarchar(30)配置标识
typevarchar(30)配置类型
cate_idint(10)配置分类
extravarchar(1000)配置值
remarkvarchar(1000)配置说明
valuetext配置值
is_hide_remarktinyint(4)1是否隐藏说明1
sortint(10)排序
statustinyint(4)1状态[-1:删除;0:禁用;1启用]1

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_addon_manage

MySQL Table Design okayapi_server_manage

TOP ↑