MySQL Create Table SQL
Table Structure: okayapi_box_mod_email_queue:/tablelist/okayapi_box_mod_email_queue.html
-- MySQL Table okayapi_box_mod_email_queue
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_mod_email_queue` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`to` varchar(255) NOT NULL COMMENT '',
`from` varchar(255) NOT NULL COMMENT '',
`subject` varchar(255) NOT NULL COMMENT '',
`content` text NOT NULL COMMENT '',
`to_name` varchar(255) NOT NULL COMMENT '',
`from_name` varchar(255) NOT NULL COMMENT '',
`client_id` int(11) NOT NULL COMMENT '',
`admin_id` int(11) NOT NULL COMMENT '',
`priority` int(11) NOT NULL COMMENT '',
`tries` int(11) NOT NULL COMMENT '',
`status` varchar(20) NOT NULL COMMENT '',
KEY `to` (`to`),
KEY `from` (`from`),
KEY `subject` (`subject`),
KEY `content` (`content`),
KEY `to_name` (`to_name`),
KEY `from_name` (`from_name`),
KEY `client_id` (`client_id`),
KEY `admin_id` (`admin_id`),
KEY `priority` (`priority`),
KEY `tries` (`tries`),
KEY `status` (`status`),
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-11 of 11 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
to | varchar(255) | 否 | ||||
from | varchar(255) | 否 | ||||
subject | varchar(255) | 否 | ||||
content | text | 否 | ||||
to_name | varchar(255) | 是 | ||||
from_name | varchar(255) | 是 | ||||
client_id | int(11) | 是 | ||||
admin_id | int(11) | 是 | ||||
priority | int(11) | 是 | ||||
tries | int(11) | 否 | ||||
status | varchar(20) | 否 |