Add email opt-out system

[patchwork] / lib / sql / migration / 010-optout-tables.sql

diff --git a/lib/sql/migration/010-optout-tables.sql b/lib/sql/migration/010-optout-tables.sql
new file mode 100644 (file)
index 0000000..0a5d835
--- /dev/null
+++ b/lib/sql/migration/010-optout-tables.sql
@@ -0,0 +1,5 @@
+BEGIN;
+CREATE TABLE "patchwork_emailoptout" (
+    "email" varchar(200) NOT NULL PRIMARY KEY
+);
+COMMIT;