diff options
| -rw-r--r-- | db/schema.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index f6ec62508..80e2d4d61 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.47 2009-09-02 09:21:32 louise Exp $ +-- $Id: schema.sql,v 1.48 2009-09-17 10:14:37 louise Exp $ -- -- secret @@ -150,6 +150,7 @@ create table problem ( lang text not null default 'en-gb', service text not null default '', cobrand text not null default '', + cobrand_data text not null default '', -- Extra data used in cobranded versions of the site lastupdate timestamp not null default ms_current_timestamp(), whensent timestamp, send_questionnaire boolean not null default 't' @@ -235,6 +236,7 @@ create table comment ( ), cobrand text not null default '', lang text not null default 'en-gb', + cobrand_data text not null default '', -- Extra data used in cobranded versions of the site mark_fixed boolean not null, mark_open boolean not null default 'f' -- other fields? one to indicate whether this was written by the council @@ -280,6 +282,7 @@ create table alert ( confirmed integer not null default 0, lang text not null default 'en-gb', cobrand text not null default '', + cobrand_data text not null default '', -- Extra data used in cobranded versions of the site whensubscribed timestamp not null default ms_current_timestamp(), whendisabled timestamp default null ); |