summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorCiaranG <ciaran@ciarang.com>2009-03-05 16:15:29 +0000
committerCiaranG <ciaran@ciarang.com>2009-03-05 16:15:29 +0000
commit97bc187e3132663ceadd2a779ce43ca67a7f3a02 (patch)
tree07cfae470a01b3d473736dd1c59547327627a784 /db
parenta7efd4ff556bbf6bafcfc81db758ab192b8802ad (diff)
PostgreSQL - the ts field in the OAuth nonce table needed to be an integer. (fix submitted by oxygene)
Diffstat (limited to 'db')
-rw-r--r--db/laconica_pg.sql2
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' */,