MySQL Create Table SQL
Table Structure: okayapi_box_service_custom:/tablelist/okayapi_box_service_custom.html
-- MySQL Table okayapi_box_service_custom
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_service_custom` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`client_id` bigint(20) NULL COMMENT '',
`plugin` varchar(255) NULL COMMENT '',
`plugin_config` text NULL COMMENT '',
`f1` text NULL COMMENT '',
`f2` text NULL COMMENT '',
`f3` text NULL COMMENT '',
`f4` text NULL COMMENT '',
`f5` text NULL COMMENT '',
`f6` text NULL COMMENT '',
`f7` text NULL COMMENT '',
`f8` text NULL COMMENT '',
`f9` text NULL COMMENT '',
`f10` text NULL COMMENT '',
`config` text NULL COMMENT '',
KEY `client_id` (`client_id`),
KEY `plugin` (`plugin`),
KEY `plugin_config` (`plugin_config`),
KEY `f1` (`f1`),
KEY `f2` (`f2`),
KEY `f3` (`f3`),
KEY `f4` (`f4`),
KEY `f5` (`f5`),
KEY `f6` (`f6`),
KEY `f7` (`f7`),
KEY `f8` (`f8`),
KEY `f9` (`f9`),
KEY `f10` (`f10`),
KEY `config` (`config`),
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-14 of 14 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
client_id | bigint(20) | 是 | Normal Index | |||
plugin | varchar(255) | 是 | ||||
plugin_config | text | 是 | ||||
f1 | text | 是 | ||||
f2 | text | 是 | ||||
f3 | text | 是 | ||||
f4 | text | 是 | ||||
f5 | text | 是 | ||||
f6 | text | 是 | ||||
f7 | text | 是 | ||||
f8 | text | 是 | ||||
f9 | text | 是 | ||||
f10 | text | 是 | ||||
config | text | 是 |