CREATE TABLE addresses (
id integer NOT NULL,
firstname character varying(255),
lastname character varying(255),
address1 character varying(255),
address2 character varying(255),
city character varying(255),
state_id integer,
zipcode character varying(255),
country_id integer,
phone character varying(255),
created_at timestamp without time zone,
updated_at timestamp without time zone,
state_name character varying(255),
alternative_phone character varying(255)
);

ALTER TABLE public.addresses OWNER TO XXXXXX;

CREATE SEQUENCE addresses_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;

ALTER TABLE public.addresses_id_seq OWNER TO XXXXXX;

ALTER SEQUENCE addresses_id_seq OWNED BY addresses.id;

SELECT pg_catalog.setval('addresses_id_seq', 348, TRUE);

COPY addresses (id, firstname, lastname, address1, address2, city, state_id, zipcode, country_id, phone, created_at, updated_at, state_name, alternative_phone) FROM stdin;
1 Mr CustomerA 1 New St Somewhere \N PS1 2BC 213 07XXX XXX XXX 2010-06-24 11:44:25.130213 2010-06-24 12:35:14.501107 SomeState \N
1 Mr CustomerB 2 New St Somewhere \N PS2 3AB 213 07XXX XXX XXX 2010-06-25 11:00:25.130213 2010-06-25 12:00:14.501107 SomeState \N