diff options
author | Arun Persaud <arun@nubati.net> | 2009-06-21 23:23:15 -0700 |
---|---|---|
committer | Arun Persaud <arun@nubati.net> | 2009-06-23 00:17:00 -0700 |
commit | c757506a0a598593115c377a6e4acf399f4d2b83 (patch) | |
tree | ae26d5aca8ae536e5754781a3341422bfa07b632 /create_database.sql | |
parent | 1a44bc0d058016a093a112f064bac63a570c400d (diff) | |
download | e-DoKo-c757506a0a598593115c377a6e4acf399f4d2b83.tar.gz e-DoKo-c757506a0a598593115c377a6e4acf399f4d2b83.tar.bz2 e-DoKo-c757506a0a598593115c377a6e4acf399f4d2b83.zip |
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.
Diffstat (limited to 'create_database.sql')
-rw-r--r-- | create_database.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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) +); + + |