From 5d5b9f7022ad144cc747a33bcabea773d2f92b28 Mon Sep 17 00:00:00 2001
From: Zach Copley <zach@controlyourself.ca>
Date: Thu, 30 Jul 2009 00:20:13 +0000
Subject: Add new Foreign_link col to store OAuth access token

---
 db/laconica.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'db/laconica.sql')

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',
-- 
cgit v1.2.3-54-g00ecf

