summaryrefslogtreecommitdiff
path: root/db/laconica.sql
diff options
context:
space:
mode:
authorZach Copley <zach@controlyourself.ca>2009-07-30 00:20:13 +0000
committerEvan Prodromou <evan@controlyourself.ca>2009-08-24 11:52:06 -0400
commit5d5b9f7022ad144cc747a33bcabea773d2f92b28 (patch)
tree90eadc3913ee4a39cdf2d20004a1aed86fe7e749 /db/laconica.sql
parent77f303c2be138aee34955e2a737bd9cb31caa2d4 (diff)
Add new Foreign_link col to store OAuth access token
Diffstat (limited to 'db/laconica.sql')
-rw-r--r--db/laconica.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 2c04f680a..8b1152cbd 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -291,7 +291,8 @@ create table foreign_link (
user_id int comment 'link to user on this system, if exists' references user (id),
foreign_id bigint unsigned comment 'link to user on foreign service, if exists' references foreign_user(id),
service int not null comment 'foreign key to service' references foreign_service(id),
- credentials varchar(255) comment 'authc credentials, typically a password',
+ credentials varchar(255) comment 'auth credentials, typically a password or token secret',
+ token varchar(255) comment 'access token',
noticesync tinyint not null default 1 comment 'notice synchronization, bit 1 = sync outgoing, bit 2 = sync incoming, bit 3 = filter local replies',
friendsync tinyint not null default 2 comment 'friend synchronization, bit 1 = sync outgoing, bit 2 = sync incoming',
profilesync tinyint not null default 1 comment 'profile synchronization, bit 1 = sync outgoing, bit 2 = sync incoming',