+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_box_service_solusvm:/tablelist/okayapi_box_service_solusvm.html


-- MySQL Table okayapi_box_service_solusvm
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_service_solusvm` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `cluster_id` bigint(20) NULL COMMENT '',
    `client_id` bigint(20) NULL COMMENT '',
    `vserverid` varchar(255) NULL COMMENT '',
    `virtid` varchar(255) NULL COMMENT '',
    `nodeid` varchar(255) NULL COMMENT '',
    `type` varchar(255) NULL COMMENT '',
    `node` varchar(255) NULL COMMENT '',
    `nodegroup` varchar(255) NULL COMMENT '',
    `hostname` varchar(255) NULL COMMENT '',
    `rootpassword` varchar(255) NULL COMMENT '',
    `username` varchar(255) NULL COMMENT '',
    `plan` varchar(255) NULL COMMENT '',
    `template` varchar(255) NULL COMMENT '',
    `ips` varchar(255) NULL COMMENT '',
    `hvmt` varchar(255) NULL COMMENT '',
    `custommemory` varchar(255) NULL COMMENT '',
    `customdiskspace` varchar(255) NULL COMMENT '',
    `custombandwidth` varchar(255) NULL COMMENT '',
    `customcpu` varchar(255) NULL COMMENT '',
    `customextraip` varchar(255) NULL COMMENT '',
    `issuelicense` varchar(255) NULL COMMENT '',
    `mainipaddress` varchar(255) NULL COMMENT '',
    `extraipaddress` varchar(255) NULL COMMENT '',
    `consoleuser` varchar(255) NULL COMMENT '',
    `consolepassword` varchar(255) NULL COMMENT '',
    `config` text NULL COMMENT '',
    KEY `cluster_id` (`cluster_id`),
    KEY `client_id` (`client_id`),
    KEY `vserverid` (`vserverid`),
    KEY `virtid` (`virtid`),
    KEY `nodeid` (`nodeid`),
    KEY `type` (`type`),
    KEY `node` (`node`),
    KEY `nodegroup` (`nodegroup`),
    KEY `hostname` (`hostname`),
    KEY `rootpassword` (`rootpassword`),
    KEY `username` (`username`),
    KEY `plan` (`plan`),
    KEY `template` (`template`),
    KEY `ips` (`ips`),
    KEY `hvmt` (`hvmt`),
    KEY `custommemory` (`custommemory`),
    KEY `customdiskspace` (`customdiskspace`),
    KEY `custombandwidth` (`custombandwidth`),
    KEY `customcpu` (`customcpu`),
    KEY `customextraip` (`customextraip`),
    KEY `issuelicense` (`issuelicense`),
    KEY `mainipaddress` (`mainipaddress`),
    KEY `extraipaddress` (`extraipaddress`),
    KEY `consoleuser` (`consoleuser`),
    KEY `consolepassword` (`consolepassword`),
    KEY `config` (`config`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '主机销售-solusvm服务';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-26 of 26 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
cluster_idbigint(20)
client_idbigint(20)Normal Index
vserveridvarchar(255)
virtidvarchar(255)
nodeidvarchar(255)
typevarchar(255)
nodevarchar(255)
nodegroupvarchar(255)
hostnamevarchar(255)
rootpasswordvarchar(255)
usernamevarchar(255)
planvarchar(255)
templatevarchar(255)
ipsvarchar(255)
hvmtvarchar(255)
custommemoryvarchar(255)
customdiskspacevarchar(255)
custombandwidthvarchar(255)
customcpuvarchar(255)
customextraipvarchar(255)
issuelicensevarchar(255)
mainipaddressvarchar(255)
extraipaddressvarchar(255)
consoleuservarchar(255)
consolepasswordvarchar(255)
configtext

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 ↑