· 8 years ago · Dec 24, 2017, 03:44 PM
1CREATE TABLE IF NOT EXISTS `mails` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
4 `ip_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
5 `created_at` datetime DEFAULT NULL,
6 PRIMARY KEY (`id`),
7 UNIQUE KEY `email` (`email`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;