MySQL Create Table SQL
Table Structure: okayapi_box_queue_message:/tablelist/okayapi_box_queue_message.html
-- MySQL Table okayapi_box_queue_message
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_queue_message` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`queue_id` bigint(20) NULL COMMENT '',
`handle` char(32) NULL COMMENT '',
`handler` varchar(255) NULL COMMENT '',
`body` longblob NULL COMMENT '',
`hash` char(32) NULL COMMENT '',
`timeout` double(18,2) NULL COMMENT '',
`log` text NULL COMMENT '',
`execute_at` datetime NULL COMMENT '',
KEY `queue_id` (`queue_id`),
KEY `handle` (`handle`),
KEY `handler` (`handler`),
KEY `body` (`body`),
KEY `hash` (`hash`),
KEY `timeout` (`timeout`),
KEY `log` (`log`),
KEY `execute_at` (`execute_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-8 of 8 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
queue_id | bigint(20) | 是 | Normal Index | |||
handle | char(32) | 是 | ||||
handler | varchar(255) | 是 | ||||
body | longblob | 是 | ||||
hash | char(32) | 是 | ||||
timeout | double(18,2) | 是 | ||||
log | text | 是 | ||||
execute_at | datetime | 是 |