diff options
author | Brenda Wallace <shiny@cpan.org> | 2010-05-22 20:04:46 +1200 |
---|---|---|
committer | Brenda Wallace <shiny@cpan.org> | 2010-05-22 20:04:46 +1200 |
commit | fa4a2d34855da5eca29d81409cb5fbd64f13faba (patch) | |
tree | 5f91d24a84ab9f9f4ae9b43c63fab06663bdad4b /db | |
parent | 839592524783a686b4c5410ba5e273617132df06 (diff) |
added verifier and verified_callback to postgres schema and update script
Diffstat (limited to 'db')
-rw-r--r-- | db/08to09_pg.sql | 3 | ||||
-rw-r--r-- | db/statusnet_pg.sql | 3 |
2 files changed, 6 insertions, 0 deletions
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' */, |