MySQL Create Table SQL
Table Structure: okayapi_box_service_license:/tablelist/okayapi_box_service_license.html
-- MySQL Table okayapi_box_service_license
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_service_license` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`client_id` bigint(20) NULL COMMENT '',
`license_key` varchar(255) NULL COMMENT '',
`validate_ip` tinyint(1) NULL DEFAULT '1' COMMENT '',
`validate_host` tinyint(1) NULL DEFAULT '1' COMMENT '',
`validate_path` tinyint(1) NULL DEFAULT '0' COMMENT '',
`validate_version` tinyint(1) NULL DEFAULT '0' COMMENT '',
`ips` text NULL COMMENT '',
`hosts` text NULL COMMENT '',
`paths` text NULL COMMENT '',
`versions` text NULL COMMENT '',
`config` text NULL COMMENT '',
`plugin` varchar(255) NULL COMMENT '',
`checked_at` datetime NULL COMMENT '',
`pinged_at` datetime NULL COMMENT '',
KEY `client_id` (`client_id`),
KEY `license_key` (`license_key`),
KEY `validate_ip` (`validate_ip`),
KEY `validate_host` (`validate_host`),
KEY `validate_path` (`validate_path`),
KEY `validate_version` (`validate_version`),
KEY `ips` (`ips`),
KEY `hosts` (`hosts`),
KEY `paths` (`paths`),
KEY `versions` (`versions`),
KEY `config` (`config`),
KEY `plugin` (`plugin`),
KEY `checked_at` (`checked_at`),
KEY `pinged_at` (`pinged_at`),
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 | |||
license_key | varchar(255) | 是 | Unique Index | |||
validate_ip | tinyint(1) | 1 | 是 | 1 | ||
validate_host | tinyint(1) | 1 | 是 | 1 | ||
validate_path | tinyint(1) | 0 | 是 | 0 | ||
validate_version | tinyint(1) | 0 | 是 | 0 | ||
ips | text | 是 | ||||
hosts | text | 是 | ||||
paths | text | 是 | ||||
versions | text | 是 | ||||
config | text | 是 | ||||
plugin | varchar(255) | 是 | ||||
checked_at | datetime | 是 | ||||
pinged_at | datetime | 是 |