Nudge feature

darcs-hash:20081116022735-eefa4-366f6deb85942f859ebd532e477b57737bcafbf8.gz

2 files changed, 3 insertions, 0 deletions

diff --git a/db/laconica.sql b/db/laconica.sql
index 87ac6e26d..4f4c37bd6 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -48,6 +48,7 @@ create table user (
     incomingemail varchar(255) unique key comment 'email address for post-by-email',
     emailnotifysub tinyint default 1 comment 'Notify by email of subscriptions',
     emailnotifyfav tinyint default 1 comment 'Notify by email of favorites',
+    emailnotifynudge tinyint default 1 comment 'Notify by email of nudges',
     emailnotifymsg tinyint default 1 comment 'Notify by email of direct messages',
     emailmicroid tinyint default 1 comment 'whether to publish email microid',
     language varchar(50) comment 'preferred language',
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index d027dc0af..e784bb169 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -47,6 +47,8 @@ create table "user" (
     email varchar(255) unique /* comment 'email address for password recovery etc.' */,

     incomingemail varchar(255) unique /* comment 'email address for post-by-email' */,

     emailnotifysub integer default 1 /* comment 'Notify by email of subscriptions' */,

+    emailnotifyfav integer default 1 /* comment 'Notify by email of favorites' */,

+    emailnotifynudge integer default 1 /* comment 'Notify by email of nudges' */,

     emailmicroid integer default 1 /* comment 'whether to publish email microid' */,

     language varchar(50) /* comment 'preferred language' */,

     timezone varchar(50) /* comment 'timezone' */,