MySQL Create Table SQL
Table Structure: okayapi_box_service_domain:/tablelist/okayapi_box_service_domain.html
-- MySQL Table okayapi_box_service_domain
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_service_domain` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`client_id` bigint(20) NULL COMMENT '',
`tld_registrar_id` bigint(20) NULL COMMENT '',
`sld` varchar(255) NULL COMMENT '',
`tld` varchar(100) NULL COMMENT '',
`ns1` varchar(255) NULL COMMENT '',
`ns2` varchar(255) NULL COMMENT '',
`ns3` varchar(255) NULL COMMENT '',
`ns4` varchar(255) NULL COMMENT '',
`period` int(11) NULL COMMENT '',
`privacy` int(11) NULL COMMENT '',
`locked` tinyint(1) NULL DEFAULT '1' COMMENT '',
`transfer_code` varchar(255) NULL COMMENT '',
`action` varchar(30) NULL COMMENT '',
`contact_email` varchar(255) NULL COMMENT '',
`contact_company` varchar(255) NULL COMMENT '',
`contact_first_name` varchar(255) NULL COMMENT '',
`contact_last_name` varchar(255) NULL COMMENT '',
`contact_address1` varchar(255) NULL COMMENT '',
`contact_address2` varchar(255) NULL COMMENT '',
`contact_city` varchar(255) NULL COMMENT '',
`contact_state` varchar(255) NULL COMMENT '',
`contact_postcode` varchar(255) NULL COMMENT '',
`contact_country` varchar(255) NULL COMMENT '',
`contact_phone_cc` varchar(255) NULL COMMENT '',
`contact_phone` varchar(255) NULL COMMENT '',
`details` text NULL COMMENT '',
`synced_at` datetime NULL COMMENT '',
`registered_at` datetime NULL COMMENT '',
`expires_at` datetime NULL COMMENT '',
KEY `client_id` (`client_id`),
KEY `tld_registrar_id` (`tld_registrar_id`),
KEY `sld` (`sld`),
KEY `tld` (`tld`),
KEY `ns1` (`ns1`),
KEY `ns2` (`ns2`),
KEY `ns3` (`ns3`),
KEY `ns4` (`ns4`),
KEY `period` (`period`),
KEY `privacy` (`privacy`),
KEY `locked` (`locked`),
KEY `transfer_code` (`transfer_code`),
KEY `action` (`action`),
KEY `contact_email` (`contact_email`),
KEY `contact_company` (`contact_company`),
KEY `contact_first_name` (`contact_first_name`),
KEY `contact_last_name` (`contact_last_name`),
KEY `contact_address1` (`contact_address1`),
KEY `contact_address2` (`contact_address2`),
KEY `contact_city` (`contact_city`),
KEY `contact_state` (`contact_state`),
KEY `contact_postcode` (`contact_postcode`),
KEY `contact_country` (`contact_country`),
KEY `contact_phone_cc` (`contact_phone_cc`),
KEY `contact_phone` (`contact_phone`),
KEY `details` (`details`),
KEY `synced_at` (`synced_at`),
KEY `registered_at` (`registered_at`),
KEY `expires_at` (`expires_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-29 of 29 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
client_id | bigint(20) | 是 | Normal Index | |||
tld_registrar_id | bigint(20) | 是 | Normal Index | |||
sld | varchar(255) | 是 | ||||
tld | varchar(100) | 是 | ||||
ns1 | varchar(255) | 是 | ||||
ns2 | varchar(255) | 是 | ||||
ns3 | varchar(255) | 是 | ||||
ns4 | varchar(255) | 是 | ||||
period | int(11) | 是 | ||||
privacy | int(11) | 是 | ||||
locked | tinyint(1) | 1 | 是 | 1 | ||
transfer_code | varchar(255) | 是 | ||||
action | varchar(30) | 是 | ||||
contact_email | varchar(255) | 是 | ||||
contact_company | varchar(255) | 是 | ||||
contact_first_name | varchar(255) | 是 | ||||
contact_last_name | varchar(255) | 是 | ||||
contact_address1 | varchar(255) | 是 | ||||
contact_address2 | varchar(255) | 是 | ||||
contact_city | varchar(255) | 是 | ||||
contact_state | varchar(255) | 是 | ||||
contact_postcode | varchar(255) | 是 | ||||
contact_country | varchar(255) | 是 | ||||
contact_phone_cc | varchar(255) | 是 | ||||
contact_phone | varchar(255) | 是 | ||||
details | text | 是 | ||||
synced_at | datetime | 是 | ||||
registered_at | datetime | 是 | ||||
expires_at | datetime | 是 |