aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authormatthew <matthew>2008-03-28 15:11:47 +0000
committermatthew <matthew>2008-03-28 15:11:47 +0000
commit695d2d8b9e52189fdf7000afb49cb3ce19d65e52 (patch)
treeb60b8980d241cfe75d6584d5c2eb6d5554f1f419 /db
parentb59b2afcc984edd776c6dab71cffaf85dedb338d (diff)
Allow photo upload on updates.
Diffstat (limited to 'db')
-rw-r--r--db/schema.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql
index 4078421e8..a6609229b 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.37 2007-08-24 00:24:14 matthew Exp $
+-- $Id: schema.sql,v 1.38 2008-03-28 15:11:47 matthew Exp $
--
-- secret
@@ -222,6 +222,7 @@ create table comment (
website text,
created timestamp not null default ms_current_timestamp(),
text text not null, -- as entered by comment author
+ photo bytea,
state text not null check (
state = 'unconfirmed'
or state = 'confirmed'