added verifier and verified_callback to postgres schema and update script

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

diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql
index aad0def360d2af2a80fa16480f62fddc9cbcc733..d8f5286bd586f83cff03dc7c0f8aa262a20ce8fd 100644 (file)
--- a/db/statusnet_pg.sql
+++ b/db/statusnet_pg.sql
@@ -201,6 +201,9 @@ create table token (
     type integer not null default 0 /* comment 'request or access' */,
     state integer default 0 /* comment 'for requests 0 = initial, 1 = authorized, 2 = used' */,
 
+    verifier varchar(255) comment 'verifier string for OAuth 1.0a',
+    verified_callback varchar(255) comment 'verified callback URL for OAuth 1.0a',
+
     created timestamp not null default CURRENT_TIMESTAMP /* comment 'date this record was created' */,
     modified timestamp /* comment 'date this record was modified' */,