diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/laconica.sql | 1 | ||||
| -rw-r--r-- | db/laconica_pg.sql | 2 |
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' */,
|