email_queue.sql 442 B

12345678910111213
  1. CREATE TABLE `email_queue` (
  2. `id` bigint(20) NOT NULL,
  3. `to_email` varchar(32) NOT NULL,
  4. `subject` longtext NOT NULL,
  5. `template` longtext NOT NULL,
  6. `array` longtext NOT NULL,
  7. `time` int(64) NOT NULL
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Email Queue 發件列表';
  9. ALTER TABLE `email_queue`
  10. ADD PRIMARY KEY (`id`);
  11. ALTER TABLE `email_queue`
  12. MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;