MySQL Create Table SQL
Table Structure: okayapi_fie_nav：/tablelist/okayapi_fie_nav.html
-- MySQL Table okayapi_fie_nav
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_nav` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`is_main` tinyint(3) NOT NULL DEFAULT '1' COMMENT '是否为主导航;1:是;0:不是',
`okayapi_fie_nav_name` varchar(30) NOT NULL COMMENT '导航位置名称',
`remark` varchar(255) NOT NULL COMMENT '备注',
KEY `is_main` (`is_main`),
KEY `okayapi_fie_nav_name` (`okayapi_fie_nav_name`),
KEY `remark` (`remark`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-前台导航位置表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-3 of 3 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| is_main | tinyint(3) | 1 | 否 | 是否为主导航;1:是;0:不是 | 1 | |
| okayapi_fie_nav_name | varchar(30) | 否 | 导航位置名称 | |||
| remark | varchar(255) | 否 | 备注 |
