okayapi_box_email_template - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_box_email_template：/tablelist/okayapi_box_email_template.html


-- MySQL Table okayapi_box_email_template
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_email_template` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `action_code` varchar(255) NULL COMMENT '',
    `category` varchar(30) NULL COMMENT 'general, domain, invoice, hosting, support, download, custom, license',
    `enabled` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `subject` varchar(255) NULL COMMENT '',
    `content` text NULL COMMENT '',
    `description` text NULL COMMENT '',
    `vars` text NULL COMMENT '',
    KEY `action_code` (`action_code`),
    KEY `category` (`category`),
    KEY `enabled` (`enabled`),
    KEY `subject` (`subject`),
    KEY `content` (`content`),
    KEY `description` (`description`),
    KEY `vars` (`vars`),
    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-7 of 7 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
action_code	varchar(255)		是		Unique Index
category	varchar(30)		是	general, domain, invoice, hosting, support, download, custom, license
enabled	tinyint(1)	1	是			1
subject	varchar(255)		是
content	text		是
description	text		是
vars	text		是