summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2009-07-17 23:13:30 +1200
committerBrenda Wallace <shiny@cpan.org>2009-07-17 23:17:58 +1200
commitc6505c52965e08db5aaf8b4d5db07e00f19262dc (patch)
tree72d5b3e88a6c33721b82a4a0612f30beb2b87941
parentb05b998d68ab2d4802ed4ec96abec59332ffe354 (diff)
postgres schema - removed not null constraint from nonce.tok, and copied the comment from the mysql schema
-rw-r--r--db/laconica_pg.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index dae8b8faf..2d8286c60 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -1,3 +1,4 @@
+
/* local and remote users have profiles */
create sequence profile_seq;
@@ -184,7 +185,7 @@ create table token (
create table nonce (
consumer_key varchar(255) not null /* comment 'unique identifier, root URL' */,
- tok char(32) not null /* comment 'identifying value' */,
+ tok char(32) /* comment 'buggy old value, ignored' */,
nonce char(32) null /* comment 'buggy old value, ignored */,
ts integer not null /* comment 'timestamp sent' values are epoch, and only used internally */,