From fa4a2d34855da5eca29d81409cb5fbd64f13faba Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Sat, 22 May 2010 20:04:46 +1200 Subject: added verifier and verified_callback to postgres schema and update script --- db/08to09_pg.sql | 3 +++ db/statusnet_pg.sql | 3 +++ 2 files changed, 6 insertions(+) diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql index a1cbad814..ecf100884 100644 --- a/db/08to09_pg.sql +++ b/db/08to09_pg.sql @@ -83,3 +83,6 @@ ALTER TABLE profile ADD COLUMN location_ns integer /* comment 'namespace for loc ALTER TABLE consumer add COLUMN consumer_secret varchar(255) not null ; /*comment 'secret value'*/ +ALTER TABLE token ADD COLUMN verifier varchar(255); /* comment 'verifier string for OAuth 1.0a',*/ +ALTER TABLE token ADD COLUMN verified_callback varchar(255); /* comment 'verified callback URL for OAuth 1.0a',*/ + diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql index aad0def36..d8f5286bd 100644 --- 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' */, -- cgit v1.2.3