aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
authorEdmund von der Burg <evdb@mysociety.org>2011-04-08 14:35:10 +0100
committerEdmund von der Burg <evdb@mysociety.org>2011-04-08 14:35:10 +0100
commitcf984198252ed545d924985ddeadaae506087ea6 (patch)
tree6a3146e51c342066e49289f82f7e77c27c52fb0f /db/schema.sql
parent546d9b679f4c56163bbc5df2e98310bc516d3313 (diff)
parent3134f2bed0d1005b130651a2f4c711ad108798a5 (diff)
Merge branch 'master' of ssh://evdb@git.mysociety.org/data/git/public/fixmystreet
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/db/schema.sql b/db/schema.sql
index fbff047fb..c58abaf48 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -137,6 +137,11 @@ create table problem (
phone text not null,
anonymous boolean not null,
+ -- External information
+ external_id text,
+ external_body text,
+ external_team text,
+
-- Metadata
created timestamp not null default ms_current_timestamp(),
confirmed timestamp,