 CREATE TABLE country_petition_journals (
     id integer NOT NULL,
     petition_id integer NOT NULL,
+    country character varying,
     signature_count integer DEFAULT 0 NOT NULL,
     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL,

    state character varying(10) DEFAULT 'pending'::character varying NOT NULL,
    perishable_token character varying(255),
    postcode character varying(255),
    ip_address character varying(20),
    petition_id integer,
    created_at timestamp without time zone,



--
-- Name: index_country_petition_journals_on_petition_id_and_country; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX index_country_petition_journals_on_petition_id_and_country ON country_petition_journals USING btree (petition_id, country);


--
-- Name: index_debate_outcomes_on_petition_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

