aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2011-06-30 17:59:13 +0100
committerStruan Donald <struan@exo.org.uk>2011-06-30 17:59:13 +0100
commit8166f167f4446c1f419f17ae192405c80af8e2da (patch)
tree3ab8a64d19af62889ecab9b19aed7d038e33e34a /db
parent719d078717a204b33f8253c9da6c567a8d8d22b6 (diff)
syntax error
Diffstat (limited to 'db')
-rw-r--r--db/schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql
index bf019c7ec..cad42fdcb 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -286,7 +286,7 @@ create table comment (
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
mark_fixed boolean not null,
- mark_open boolean not null default 'f'
+ mark_open boolean not null default 'f',
problem_state text check (
problem_state = 'confirmed'
or problem_state = 'investigating'