Files
afup/sql/2018-04-01-techletter-unsubscribe.sql
2018-04-01 17:10:24 +02:00

9 lines
389 B
SQL

CREATE TABLE `afup_techletter_unsubscriptions` (
`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`email` varchar(255) NOT NULL,
`unsubscription_date` datetime NOT NULL,
`reason` varchar(255) DEFAULT NULL,
`mailchimp_id` varchar(255) DEFAULT NULL
) COMMENT='' ENGINE='InnoDB';
alter table `afup_techletter_unsubscriptions` convert to character set latin1 collate latin1_general_ci;