More space for the counter

[quix0rs-gnu-social.git] / db / laconica.sql

diff --git a/db/laconica.sql b/db/laconica.sql
index 42e427d0bd7da44034398ef9fba5a183d608dc35..a366a6bcbb5225d92825d5317b9ade32dc7426f6 100644 (file)
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -88,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 tinyint default 1 comment 'deliver jabber messages',
+    sms tinyint default 1 comment 'deliver sms messages',
     token varchar(255) comment 'authorization token',
     secret varchar(255) comment 'token secret',
     created datetime not null comment 'date this record was created',