 create table constituency_cache (
     id integer not null primary key,
     name text not null,
-    rep_name text not null default ''
-);
+    rep_name text not null default '',
+    rep_id integer not null default 0 
+);

-- Copyright (c) 2005 UK Citizens Online Democracy. All rights reserved.
-- Email: francis@mysociety.org; WWW: http://www.mysociety.org/
--
-- $Id: schema.sql,v 1.21 2006-01-09 11:12:52 chris Exp $
--

-- Returns the timestamp of current time, but with possibly overriden "today".

);

create index constituent_person_id_idx on constituent(person_id);
create index constituent_constituency_idx on constituent(constituency);
create unique index constituent_person_id_constituency_idx on constituent(person_id, constituency);

-- secret
