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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
cluster_id | bigint(20) | 是 | ||||
client_id | bigint(20) | 是 | Normal Index | |||
vserverid | varchar(255) | 是 | ||||
virtid | varchar(255) | 是 | ||||
nodeid | varchar(255) | 是 | ||||
type | varchar(255) | 是 | ||||
node | varchar(255) | 是 | ||||
nodegroup | varchar(255) | 是 | ||||
hostname | varchar(255) | 是 | ||||
rootpassword | varchar(255) | 是 | ||||
username | varchar(255) | 是 | ||||
plan | varchar(255) | 是 | ||||
template | varchar(255) | 是 | ||||
ips | varchar(255) | 是 | ||||
hvmt | varchar(255) | 是 | ||||
custommemory | varchar(255) | 是 | ||||
customdiskspace | varchar(255) | 是 | ||||
custombandwidth | varchar(255) | 是 | ||||
customcpu | varchar(255) | 是 | ||||
customextraip | varchar(255) | 是 | ||||
issuelicense | varchar(255) | 是 | ||||
mainipaddress | varchar(255) | 是 | ||||
extraipaddress | varchar(255) | 是 | ||||
consoleuser | varchar(255) | 是 | ||||
consolepassword | varchar(255) | 是 | ||||
config | text | 是 |