okayapi_box_mod_massmailer - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_box_mod_massmailer：/tablelist/okayapi_box_mod_massmailer.html


-- MySQL Table okayapi_box_mod_massmailer
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_mod_massmailer` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `from_email` varchar(255) NULL COMMENT '',
    `from_name` varchar(255) NULL COMMENT '',
    `subject` varchar(255) NULL COMMENT '',
    `content` text NULL COMMENT '',
    `filter` text NULL COMMENT '',
    `status` varchar(255) NULL COMMENT '',
    `sent_at` datetime NULL COMMENT '',
    KEY `from_email` (`from_email`),
    KEY `from_name` (`from_name`),
    KEY `subject` (`subject`),
    KEY `content` (`content`),
    KEY `filter` (`filter`),
    KEY `status` (`status`),
    KEY `sent_at` (`sent_at`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '主机销售-邮件massmailer';

After replication, you can go to the database to create the database table.