MySQL Create Table SQL
Table Structure: okayapi_fie_route：/tablelist/okayapi_fie_route.html
-- MySQL Table okayapi_fie_route
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_route` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
`okayapi_fie_route_status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态;1:启用,0:不启用',
`okayapi_fie_route_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'URL规则类型;1:用户自定义;2:别名添加',
`full_url` varchar(255) NOT NULL COMMENT '完整url',
`url` varchar(255) NOT NULL COMMENT '实际显示的url',
KEY `list_order` (`list_order`),
KEY `okayapi_fie_route_status` (`okayapi_fie_route_status`),
KEY `okayapi_fie_route_type` (`okayapi_fie_route_type`),
KEY `full_url` (`full_url`),
KEY `url` (`url`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-url路由表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| list_order | float | 10000 | 否 | 排序 | 10000 | |
| okayapi_fie_route_status | tinyint(2) | 1 | 否 | 状态;1:启用,0:不启用 | 1 | |
| okayapi_fie_route_type | tinyint(4) | 1 | 否 | URL规则类型;1:用户自定义;2:别名添加 | 1 | |
| full_url | varchar(255) | 否 | 完整url | |||
| url | varchar(255) | 否 | 实际显示的url |
