aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
authormatthew <matthew>2007-01-20 00:51:49 +0000
committermatthew <matthew>2007-01-20 00:51:49 +0000
commit7f9e3397773f70ae34fcab85b24901ca8640f6a9 (patch)
tree9d33b0cabbe52e1365a67f4267233218a6c9c77b /db/schema.sql
parentecec90ddc0192c4e4e93188e49a2d5f80365f1b2 (diff)
First draft of council submission script.
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql5
1 files changed, 3 insertions, 2 deletions
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