diff options
| author | matthew <matthew> | 2006-10-09 17:30:38 +0000 |
|---|---|---|
| committer | matthew <matthew> | 2006-10-09 17:30:38 +0000 |
| commit | b2366ec59b4d98d0202ed9693a97672e22deb9ee (patch) | |
| tree | b5c431cb94ab9e0b8e73e8a7ebae3e295eccd986 /db/schema.sql | |
| parent | ba8c61f5ee2c9fe624a2e5d53f74835647c42c94 (diff) | |
Add optional phone box.
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index cfe503dbc..cc3f8ef23 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.9 2006-09-26 16:11:50 matthew Exp $ +-- $Id: schema.sql,v 1.10 2006-10-09 17:30:38 matthew Exp $ -- -- secret @@ -81,6 +81,7 @@ create table problem ( -- category integer not null references category(id), name text not null, email text not null, + phone text not null, created timestamp not null default ms_current_timestamp(), state text not null check ( state = 'unconfirmed' |