summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2010-05-22 20:04:46 +1200
committerBrenda Wallace <shiny@cpan.org>2010-05-22 20:04:46 +1200
commitfa4a2d34855da5eca29d81409cb5fbd64f13faba (patch)
tree5f91d24a84ab9f9f4ae9b43c63fab06663bdad4b /db
parent839592524783a686b4c5410ba5e273617132df06 (diff)
added verifier and verified_callback to postgres schema and update script
Diffstat (limited to 'db')
-rw-r--r--db/08to09_pg.sql3
-rw-r--r--db/statusnet_pg.sql3
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' */,