aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
authorMatthew Somerville <matthew@cake.ukcod.org.uk>2010-05-12 14:33:40 +0100
committerMatthew Somerville <matthew@cake.ukcod.org.uk>2010-05-12 14:33:40 +0100
commitcc5f1f9fdcd215952c5defede623f5d2298143c3 (patch)
treefa2f9ceb6d6a2d804826b083d2db2a7adbab1456 /db/schema.sql
parent7c9d76755e99e62c3c43065cae785c02086a9e92 (diff)
Add confirmed column to update table.
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/db/schema.sql b/db/schema.sql
index f27d3dce7..53d188244 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -227,6 +227,7 @@ create table comment (
email text not null,
website text,
created timestamp not null default ms_current_timestamp(),
+ confirmed timestamp,
text text not null, -- as entered by comment author
photo bytea,
state text not null check (