MySQL Create Table SQL
Table Structure: okayapi_box_service_hosting_server:/tablelist/okayapi_box_service_hosting_server.html
-- MySQL Table okayapi_box_service_hosting_server
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_service_hosting_server` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NULL COMMENT '',
`ip` varchar(45) NULL COMMENT '',
`hostname` varchar(100) NULL COMMENT '',
`assigned_ips` text NULL COMMENT '',
`status_url` varchar(255) NULL COMMENT '',
`active` tinyint(1) NULL COMMENT '',
`max_accounts` bigint(20) NULL COMMENT '',
`ns1` varchar(100) NULL COMMENT '',
`ns2` varchar(100) NULL COMMENT '',
`ns3` varchar(100) NULL COMMENT '',
`ns4` varchar(100) NULL COMMENT '',
`manager` varchar(100) NULL COMMENT '',
`username` text NULL COMMENT '',
`password` text NULL COMMENT '',
`accesshash` text NULL COMMENT '',
`port` varchar(20) NULL COMMENT '',
`config` text NULL COMMENT '',
`secure` tinyint(1) NULL COMMENT '',
KEY `name` (`name`),
KEY `ip` (`ip`),
KEY `hostname` (`hostname`),
KEY `assigned_ips` (`assigned_ips`),
KEY `status_url` (`status_url`),
KEY `active` (`active`),
KEY `max_accounts` (`max_accounts`),
KEY `ns1` (`ns1`),
KEY `ns2` (`ns2`),
KEY `ns3` (`ns3`),
KEY `ns4` (`ns4`),
KEY `manager` (`manager`),
KEY `username` (`username`),
KEY `password` (`password`),
KEY `accesshash` (`accesshash`),
KEY `port` (`port`),
KEY `config` (`config`),
KEY `secure` (`secure`),
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-18 of 18 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
name | varchar(100) | 是 | ||||
ip | varchar(45) | 是 | ||||
hostname | varchar(100) | 是 | ||||
assigned_ips | text | 是 | ||||
status_url | varchar(255) | 是 | ||||
active | tinyint(1) | 是 | ||||
max_accounts | bigint(20) | 是 | ||||
ns1 | varchar(100) | 是 | ||||
ns2 | varchar(100) | 是 | ||||
ns3 | varchar(100) | 是 | ||||
ns4 | varchar(100) | 是 | ||||
manager | varchar(100) | 是 | ||||
username | text | 是 | ||||
password | text | 是 | ||||
accesshash | text | 是 | ||||
port | varchar(20) | 是 | ||||
config | text | 是 | ||||
secure | tinyint(1) | 是 |