MySQL Create Table SQL
Table Structure: okayapi_server_manage：/tablelist/okayapi_server_manage.html
-- MySQL Table okayapi_server_manage
-- From: OkayAPI.com
CREATE TABLE `okayapi_server_manage` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) NULL COMMENT '服务器备注',
`IntranetIP` varchar(20) NULL COMMENT '内网ip',
`PublicIP` varchar(20) NULL COMMENT '公网ip',
`PublicDomain` varchar(30) NULL COMMENT '域名',
`owner` varchar(25) NULL COMMENT '用户主',
`explanation` varchar(50) NULL COMMENT '用途备注',
KEY `name` (`name`),
KEY `IntranetIP` (`IntranetIP`),
KEY `PublicIP` (`PublicIP`),
KEY `PublicDomain` (`PublicDomain`),
KEY `owner` (`owner`),
KEY `explanation` (`explanation`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '服务器管理表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| name | varchar(30) | 是 | 服务器备注 | |||
| IntranetIP | varchar(20) | 是 | 内网ip | |||
| PublicIP | varchar(20) | 是 | 公网ip | |||
| PublicDomain | varchar(30) | 是 | 域名 | |||
| owner | varchar(25) | 是 | 用户主 | |||
| explanation | varchar(50) | 是 | 用途备注 |
