diff options
| author | CiaranG <ciaran@ciarang.com> | 2009-03-05 16:15:29 +0000 |
|---|---|---|
| committer | CiaranG <ciaran@ciarang.com> | 2009-03-05 16:15:29 +0000 |
| commit | 97bc187e3132663ceadd2a779ce43ca67a7f3a02 (patch) | |
| tree | 07cfae470a01b3d473736dd1c59547327627a784 | |
| parent | a7efd4ff556bbf6bafcfc81db758ab192b8802ad (diff) | |
PostgreSQL - the ts field in the OAuth nonce table needed to be an integer. (fix submitted by oxygene)
| -rw-r--r-- | db/laconica_pg.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql index 4ef2330f4..2d83f784a 100644 --- a/db/laconica_pg.sql +++ b/db/laconica_pg.sql @@ -181,7 +181,7 @@ create table nonce ( consumer_key varchar(255) not null /* comment 'unique identifier, root URL' */,
tok char(32) not null /* comment 'identifying value' */,
nonce char(32) not null /* comment 'nonce' */,
- ts timestamp not null /* comment 'timestamp sent' */,
+ ts integer not null /* comment 'timestamp sent' values are epoch, and only used internally */,
created timestamp not null default CURRENT_TIMESTAMP /* comment 'date this record was created' */,
modified timestamp /* comment 'date this record was modified' */,
|