WebOrbiton
v3.0.0.2

FlatlyPage

← Changes All versions
16 lines · 614 B
  1. -- newsletter.sql - Database structure
  2. -- Run this in phpMyAdmin SQL tab
  4. CREATE TABLE IF NOT EXISTS `newsletter_subscribers` (
  5. `id` int(11) NOT NULL AUTO_INCREMENT,
  6. `email` varchar(255) NOT NULL,
  7. `token` varchar(64) NOT NULL,
  8. `confirmed` tinyint(1) DEFAULT 0,
  9. `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  10. `confirmed_at` timestamp NULL DEFAULT NULL,
  11. `ip_address` varchar(45) DEFAULT NULL,
  12. PRIMARY KEY (`id`),
  13. UNIQUE KEY `email` (`email`),
  14. KEY `idx_token` (`token`),
  15. KEY `idx_confirmed` (`confirmed`)
  16. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;