aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorlouise <louise>2009-08-27 13:13:26 +0000
committerlouise <louise>2009-08-27 13:13:26 +0000
commit1fc7278ff0158e7f0e90f9e5631609ea2d6abc62 (patch)
treefc806053385366a63fb888e11f243b924c8a69f2 /db
parente720d39ca516481382b57ed1b0fb50698c5ad42f (diff)
Add cobrand field to store which version of the site problems and updates came from
Diffstat (limited to 'db')
-rw-r--r--db/schema.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql
index f4849448a..9bf695bd5 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.45 2009-07-10 15:17:28 matthew Exp $
+-- $Id: schema.sql,v 1.46 2009-08-27 13:13:26 louise Exp $
--
-- secret
@@ -149,6 +149,7 @@ create table problem (
),
lang text not null default 'en-gb',
service text not null default '',
+ cobrand text not null default '',
lastupdate timestamp not null default ms_current_timestamp(),
whensent timestamp,
send_questionnaire boolean not null default 't'
@@ -232,6 +233,7 @@ create table comment (
or state = 'confirmed'
or state = 'hidden'
),
+ cobrand text not null default '',
lang text not null default 'en-gb',
mark_fixed boolean not null,
mark_open boolean not null default 'f'