diff options
| author | Edmund von der Burg <evdb@mysociety.org> | 2011-04-05 11:42:33 +0100 |
|---|---|---|
| committer | Edmund von der Burg <evdb@mysociety.org> | 2011-04-05 11:42:33 +0100 |
| commit | 4dd129c52e3afbe41c631f5b5ef31fa33e8b13f4 (patch) | |
| tree | 22026d0d4560065a6871cdda2170f8158a37ae7d /db/schema.sql | |
| parent | a21ae5261643ccfe7d13689dabaf7ebce8080c5c (diff) | |
Add back contacts changes
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/db/schema.sql b/db/schema.sql index 9d194004c..ae66fc28c 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -66,6 +66,7 @@ create function ms_current_timestamp() -- Who to send problems for a specific MaPit area ID to create table contacts ( + id serial primary key, area_id integer not null, category text not null default 'Other', email text not null, @@ -86,6 +87,7 @@ create unique index contacts_area_id_category_idx on contacts(area_id, category) create table contacts_history ( contacts_history_id serial not null primary key, + contact_id integer not null, area_id integer not null, category text not null default 'Other', email text not null, |