diff options
| -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' */, |