From 7f9e3397773f70ae34fcab85b24901ca8640f6a9 Mon Sep 17 00:00:00 2001
From: matthew <matthew>
Date: Sat, 20 Jan 2007 00:51:49 +0000
Subject: First draft of council submission script.

---
 db/schema.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'db/schema.sql')

diff --git a/db/schema.sql b/db/schema.sql
index dae44c420..fd6947afc 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -4,7 +4,7 @@
 -- Copyright (c) 2006 UK Citizens Online Democracy. All rights reserved.
 -- Email: matthew@mysociety.org; WWW: http://www.mysociety.org/
 --
--- $Id: schema.sql,v 1.13 2007-01-19 16:57:28 matthew Exp $
+-- $Id: schema.sql,v 1.14 2007-01-20 00:51:49 matthew Exp $
 --
 
 -- secret
@@ -96,7 +96,8 @@ create table problem (
         or state = 'confirmed'
         or state = 'fixed'
         or state = 'hidden'
-    )
+    ),
+    whensent timestamp
 );
 
 -- Who to send problems for a specific MaPit area ID to
-- 
cgit v1.2.3

