diff options
| author | Matthew Somerville <matthew@mysociety.org> | 2015-05-20 10:25:16 +0100 |
|---|---|---|
| committer | Matthew Somerville <matthew@mysociety.org> | 2015-09-29 16:46:53 +0100 |
| commit | 361990d4409ccda79e9f0cf166a505eefeac4495 (patch) | |
| tree | 6fea825e1ce4e43b314d5b8b83c73d4c052116bd /db/schema.sql | |
| parent | 1dd68c2f6fed08b90fdaea8efd8c6bcf0399b8d8 (diff) | |
Allow underscore in cobrand name/data in database.
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/db/schema.sql b/db/schema.sql index ea2698b0e..2db89bddb 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -173,8 +173,8 @@ create table problem ( ), lang text not null default 'en-gb', service text not null default '', - cobrand text not null default '' check (cobrand ~* '^[a-z0-9]*$'), - cobrand_data text not null default '' check (cobrand_data ~* '^[a-z0-9]*$'), -- Extra data used in cobranded versions of the site + cobrand text not null default '' check (cobrand ~* '^[a-z0-9_]*$'), + cobrand_data text not null default '' check (cobrand_data ~* '^[a-z0-9_]*$'), -- Extra data used in cobranded versions of the site lastupdate timestamp not null default current_timestamp, whensent timestamp, send_questionnaire boolean not null default 't', @@ -297,9 +297,9 @@ create table comment ( or state = 'confirmed' or state = 'hidden' ), - cobrand text not null default '' check (cobrand ~* '^[a-z0-9]*$'), + cobrand text not null default '' check (cobrand ~* '^[a-z0-9_]*$'), lang text not null default 'en-gb', - cobrand_data text not null default '' check (cobrand_data ~* '^[a-z0-9]*$'), -- Extra data used in cobranded versions of the site + cobrand_data text not null default '' check (cobrand_data ~* '^[a-z0-9_]*$'), -- Extra data used in cobranded versions of the site mark_fixed boolean not null, mark_open boolean not null default 'f', problem_state text check ( @@ -366,8 +366,8 @@ create table alert ( user_id int references users(id) not null, confirmed integer not null default 0, lang text not null default 'en-gb', - cobrand text not null default '' check (cobrand ~* '^[a-z0-9]*$'), - cobrand_data text not null default '' check (cobrand_data ~* '^[a-z0-9]*$'), -- Extra data used in cobranded versions of the site + cobrand text not null default '' check (cobrand ~* '^[a-z0-9_]*$'), + cobrand_data text not null default '' check (cobrand_data ~* '^[a-z0-9_]*$'), -- Extra data used in cobranded versions of the site whensubscribed timestamp not null default current_timestamp, whendisabled timestamp default null ); |