MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_base_config：/tablelist/okayapi_lvyou_jee_base_config.html
-- MySQL Table okayapi_lvyou_jee_base_config
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_base_config` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sort` int(11) NULL COMMENT '',
`config_key` varchar(200) NULL COMMENT '',
`config_value` varchar(200) NULL COMMENT '',
`memo` varchar(200) NULL COMMENT '',
`isdel` int(11) NULL DEFAULT '0' COMMENT '0:允许删除,1：不允许删除',
KEY `sort` (`sort`),
KEY `config_key` (`config_key`),
KEY `config_value` (`config_value`),
KEY `memo` (`memo`),
KEY `isdel` (`isdel`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-基本配置';
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 |
|---|---|---|---|---|---|---|
| sort | int(11) | 是 | ||||
| config_key | varchar(200) | 是 | ||||
| config_value | varchar(200) | 是 | ||||
| memo | varchar(200) | 是 | ||||
| isdel | int(11) | 0 | 是 | 0:允许删除,1：不允许删除 | 0 |
