MySQL Create Table SQL
Table Structure: okayapi_box_support_helpdesk：/tablelist/okayapi_box_support_helpdesk.html
-- MySQL Table okayapi_box_support_helpdesk
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_support_helpdesk` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NULL COMMENT '',
`email` varchar(255) NULL COMMENT '',
`close_after` smallint(6) NULL DEFAULT '24' COMMENT '',
`can_reopen` tinyint(1) NULL DEFAULT '0' COMMENT '',
`signature` text NULL COMMENT '',
KEY `name` (`name`),
KEY `email` (`email`),
KEY `close_after` (`close_after`),
KEY `can_reopen` (`can_reopen`),
KEY `signature` (`signature`),
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-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| name | varchar(255) | 是 | ||||
| varchar(255) | 是 | |||||
| close_after | smallint(6) | 24 | 是 | 24 | ||
| can_reopen | tinyint(1) | 0 | 是 | 0 | ||
| signature | text | 是 |
