+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jieqi_system_mainmenu:/tablelist/okayapi_jieqi_system_mainmenu.html


-- MySQL Table okayapi_jieqi_system_mainmenu
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_mainmenu` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `modname` varchar(50) NOT NULL COMMENT '',
    `layer` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
    `caption` varchar(50) NOT NULL COMMENT '',
    `description` varchar(255) NOT NULL COMMENT '',
    `command` varchar(100) NOT NULL COMMENT '',
    `power` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `target` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `weight` int(10) NOT NULL DEFAULT '0' COMMENT '',
    `publish` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    KEY `modname` (`modname`),
    KEY `layer` (`layer`),
    KEY `caption` (`caption`),
    KEY `description` (`description`),
    KEY `command` (`command`),
    KEY `power` (`power`),
    KEY `target` (`target`),
    KEY `weight` (`weight`),
    KEY `publish` (`publish`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-主菜单';

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


MySQL database table structure design

Displaying 1-9 of 9 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
modnamevarchar(50)Normal Index
layertinyint(3)00
captionvarchar(50)
descriptionvarchar(255)
commandvarchar(100)
powertinyint(1)00
targettinyint(1)00
weightint(10)0Normal Index0
publishtinyint(1)0Normal Index0

Guess You Like

MySQL Table Design okayapi_xwx_author

MySQL Table Design okayapi_xwx_banner

MySQL Table Design okayapi_xwx_book

MySQL Table Design okayapi_xwx_category

MySQL Table Design okayapi_xwx_chapter

MySQL Table Design okayapi_xwx_tag

MySQL Table Design okayapi_xwx_admin

MySQL Table Design okayapi_xwx_friendship_link

MySQL Table Design okayapi_jieqi_system_adminmenu

MySQL Table Design okayapi_jieqi_system_blockconfigs

MySQL Table Design okayapi_jieqi_system_blocks

MySQL Table Design okayapi_jieqi_system_configs

MySQL Table Design okayapi_jieqi_system_defaultmenu

MySQL Table Design okayapi_jieqi_system_friends

MySQL Table Design okayapi_jieqi_system_groups

MySQL Table Design okayapi_jieqi_system_honors

MySQL Table Design okayapi_jieqi_system_logs

MySQL Table Design okayapi_jieqi_system_mblock

MySQL Table Design okayapi_jieqi_system_message

MySQL Table Design okayapi_jieqi_system_modules

TOP ↑