From c6505c52965e08db5aaf8b4d5db07e00f19262dc Mon Sep 17 00:00:00 2001
From: Brenda Wallace <shiny@cpan.org>
Date: Fri, 17 Jul 2009 23:13:30 +1200
Subject: postgres schema - removed not null constraint from nonce.tok, and
 copied the comment from the mysql schema

---
 db/laconica_pg.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'db/laconica_pg.sql')

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 */,
 
-- 
cgit v1.2.3-54-g00ecf

