diff options
| author | Zach Copley <zach@controlyourself.ca> | 2009-07-30 00:20:13 +0000 |
|---|---|---|
| committer | Evan Prodromou <evan@controlyourself.ca> | 2009-08-24 11:52:06 -0400 |
| commit | 5d5b9f7022ad144cc747a33bcabea773d2f92b28 (patch) | |
| tree | 90eadc3913ee4a39cdf2d20004a1aed86fe7e749 /db/laconica.sql | |
| parent | 77f303c2be138aee34955e2a737bd9cb31caa2d4 (diff) | |
Add new Foreign_link col to store OAuth access token
Diffstat (limited to 'db/laconica.sql')
| -rw-r--r-- | db/laconica.sql | 3 |
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', |