+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
namevarchar(100)
ipvarchar(45)
hostnamevarchar(100)
assigned_ipstext
status_urlvarchar(255)
activetinyint(1)
max_accountsbigint(20)
ns1varchar(100)
ns2varchar(100)
ns3varchar(100)
ns4varchar(100)
managervarchar(100)
usernametext
passwordtext
accesshashtext
portvarchar(20)
configtext
securetinyint(1)

Guess You Like

MySQL Table Design okayapi_activity_admin_history

MySQL Table Design okayapi_activity_client_email

MySQL Table Design okayapi_activity_client_history

MySQL Table Design okayapi_activity_system

MySQL Table Design okayapi_box_admin

MySQL Table Design okayapi_box_admin_group

MySQL Table Design okayapi_box_cart

MySQL Table Design okayapi_box_cart_product

MySQL Table Design okayapi_box_client

MySQL Table Design okayapi_box_client_balance

MySQL Table Design okayapi_box_client_group

MySQL Table Design okayapi_box_client_order

MySQL Table Design okayapi_box_client_order_meta

MySQL Table Design okayapi_box_client_order_status

MySQL Table Design okayapi_box_client_password_reset

MySQL Table Design okayapi_box_currency

MySQL Table Design okayapi_box_email_template

MySQL Table Design okayapi_box_extension

MySQL Table Design okayapi_box_extension_meta

MySQL Table Design okayapi_box_form

TOP ↑