okayapi_jieqi_system_mainmenu - MySQ Table 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 Name	Field Type	Default	IS NULL	Index	Demo Data
modname	varchar(50)		否	Normal Index
layer	tinyint(3)	0	否		0
caption	varchar(50)		否
description	varchar(255)		否
command	varchar(100)		否
power	tinyint(1)	0	否		0
target	tinyint(1)	0	否		0
weight	int(10)	0	否	Normal Index	0
publish	tinyint(1)	0	否	Normal Index	0