From c757506a0a598593115c377a6e4acf399f4d2b83 Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Sun, 21 Jun 2009 23:23:15 -0700
Subject: added option for email digest

you can now select to get emails only every N hours. They are saved in the database and a cron script will send them out.
---
 create_database.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'create_database.sql')

diff --git a/create_database.sql b/create_database.sql
index 339c337..40a008a 100644
--- a/create_database.sql
+++ b/create_database.sql
@@ -465,3 +465,15 @@ create table user_openids (
   user_id int not null,
   index (user_id)
 );
+
+DROP TABLE IF EXISTS `digest_email`;
+create table digest_email (
+  `id` int(11) NOT NULL auto_increment,
+  `email` varchar(255) default null,
+  `create_date` timestamp NOT NULL default '0000-00-00 00:00:00',
+  `content` text,
+  UNIQUE KEY `id` (`id`),
+  index (email)
+);
+
+
-- 
cgit v1.2.3-18-g5258