MySQL Create Table SQL
Table Structure: okayapi_box_tld：/tablelist/okayapi_box_tld.html
-- MySQL Table okayapi_box_tld
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_tld` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tld_registrar_id` bigint(20) NULL COMMENT '',
`tld` varchar(15) NULL COMMENT '',
`price_registration` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
`price_renew` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
`price_transfer` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
`allow_register` tinyint(1) NULL COMMENT '',
`allow_transfer` tinyint(1) NULL COMMENT '',
`active` tinyint(1) NULL DEFAULT '1' COMMENT '',
`min_years` tinyint(4) NULL COMMENT '',
KEY `tld_registrar_id` (`tld_registrar_id`),
KEY `tld` (`tld`),
KEY `price_registration` (`price_registration`),
KEY `price_renew` (`price_renew`),
KEY `price_transfer` (`price_transfer`),
KEY `allow_register` (`allow_register`),
KEY `allow_transfer` (`allow_transfer`),
KEY `active` (`active`),
KEY `min_years` (`min_years`),
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-9 of 9 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| tld_registrar_id | bigint(20) | 是 | Normal Index | |||
| tld | varchar(15) | 是 | Unique Index | |||
| price_registration | decimal(18,2) | 0.00 | 是 | 0.00 | ||
| price_renew | decimal(18,2) | 0.00 | 是 | 0.00 | ||
| price_transfer | decimal(18,2) | 0.00 | 是 | 0.00 | ||
| allow_register | tinyint(1) | 是 | ||||
| allow_transfer | tinyint(1) | 是 | ||||
| active | tinyint(1) | 1 | 是 | 1 | ||
| min_years | tinyint(4) | 是 |
