From 140bee20a29fe967cbfcbda3e79af97b7f8f08e5 Mon Sep 17 00:00:00 2001 From: CiaranG Date: Wed, 7 Jan 2009 21:11:51 +0000 Subject: Some more PostgreSQL script updates - some recently added fields were missing --- db/laconica_pg.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'db/laconica_pg.sql') diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql index 4f88a6ada..3538e97ad 100644 --- a/db/laconica_pg.sql +++ b/db/laconica_pg.sql @@ -49,7 +49,8 @@ create table "user" ( 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' */, + emailnotifymsg integer default 1 / * comment 'Notify by email of direct messages' */, +emailmicroid integer default 1 /* comment 'whether to publish email microid' */, language varchar(50) /* comment 'preferred language' */, timezone varchar(50) /* comment 'timezone' */, emailpost integer default 1 /* comment 'Post by email' */, @@ -87,6 +88,8 @@ create table remote_profile ( create table subscription ( subscriber integer not null /* comment 'profile listening' */, subscribed integer not null /* comment 'profile being listened to' */, + jabber integer default 1 /* comment 'deliver jabber messages', + sms integer default 1 comment 'deliver sms messages', token varchar(255) /* comment 'authorization token' */, secret varchar(255) /* comment 'token secret' */, created timestamp not null /* comment 'date this record was created' */, -- cgit v1.2.3-54-g00ecf