add admin_email_templates

[wfpl-cms.git] / admin_email_templates.sql

diff --git a/admin_email_templates.sql b/admin_email_templates.sql
new file mode 100644 (file)
index 0000000..dc11783
--- /dev/null
+++ b/admin_email_templates.sql
@@ -0,0 +1,12 @@
+drop table if exists email_templates;
+create table email_templates (
+    id int unique auto_increment,
+    slug varchar(200) binary not null default "",
+    notes text binary not null default "",
+    from_addr varchar(100) binary not null default "",
+    to_addr varchar(100) binary not null default "",
+    cc_addr varchar(100) binary not null default "",
+    bcc_addr varchar(100) binary not null default "",
+    subject varchar(200) binary not null default "",
+    content text binary not null default ""
+) CHARSET=utf8;