31 lines
1.5 KiB
SQL
31 lines
1.5 KiB
SQL
DROP TABLE IF EXISTS `gitlink_email_jobs`;
|
|
CREATE TABLE `gitlink_email_jobs` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`sender` int(11) NOT NULL COMMENT '发送者id',
|
|
`emails` text NOT NULL COMMENT '收件人全部邮件地址',
|
|
`subject` varchar(500) DEFAULT NULL COMMENT '邮件主题',
|
|
`content` text NOT NULL COMMENT '邮件内容',
|
|
`created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
`dispatched_at` datetime DEFAULT NULL COMMENT '处理时间',
|
|
`dispatched_status` int(11) DEFAULT '-1' COMMENT '发送状态：-1 未处理,1 处理成功,2 处理失败',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
|
|
|
|
|
|
DROP TABLE IF EXISTS `gitlink_email_send_records`;
|
|
CREATE TABLE `gitlink_email_send_records` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`email` varchar(500) NOT NULL DEFAULT '' COMMENT '收件人邮件地址',
|
|
`job_id` int(11) NOT NULL COMMENT '邮件详情id',
|
|
`created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
`sent_at` datetime DEFAULT NULL COMMENT '发送时间',
|
|
`status` int(11) DEFAULT '-1' COMMENT '发送状态：-1 未发送,1 发送成功,2 发送失败',
|
|
PRIMARY KEY (`id`),
|
|
KEY `index_on_email_and_status` (`email`,`status`),
|
|
KEY `index_on_status` (`status`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
|
|
|
|
|
|
-- 2023-01-05 更新字符集编码
|
|
ALTER TABLE gitlink_email_jobs CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
ALTER TABLE gitlink_email_send_records CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; |