Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
7721 lines (6811 sloc) 209 KB
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
DROP TABLE frames CASCADE;
DROP TABLE images CASCADE;
DROP TABLE pages CASCADE;
DROP TABLE piggybak_addresses CASCADE;
DROP TABLE piggybak_bundle_discounts_bundle_discount_sellables CASCADE;
DROP TABLE piggybak_bundle_discounts_bundle_discounts CASCADE;
DROP TABLE piggybak_countries CASCADE;
DROP TABLE piggybak_coupons_coupon_applications CASCADE;
DROP TABLE piggybak_coupons_coupons CASCADE;
DROP TABLE piggybak_giftcerts_buyable_giftcerts CASCADE;
DROP TABLE piggybak_giftcerts_giftcert_applications CASCADE;
DROP TABLE piggybak_giftcerts_giftcerts CASCADE;
DROP TABLE piggybak_line_items CASCADE;
DROP TABLE piggybak_order_notes CASCADE;
DROP TABLE piggybak_orders CASCADE;
DROP TABLE piggybak_payment_method_values CASCADE;
DROP TABLE piggybak_payment_methods CASCADE;
DROP TABLE piggybak_payments CASCADE;
DROP TABLE piggybak_sellables CASCADE;
DROP TABLE piggybak_shipments CASCADE;
DROP TABLE piggybak_shipping_method_values CASCADE;
DROP TABLE piggybak_shipping_methods CASCADE;
DROP TABLE piggybak_states CASCADE;
DROP TABLE piggybak_tax_method_values CASCADE;
DROP TABLE piggybak_tax_methods CASCADE;
DROP TABLE piggybak_taxonomy_navigation_nodes CASCADE;
DROP TABLE piggybak_taxonomy_sellable_taxonomies CASCADE;
DROP TABLE piggybak_variants_option_configurations CASCADE;
DROP TABLE piggybak_variants_option_values CASCADE;
DROP TABLE piggybak_variants_option_values_variants CASCADE;
DROP TABLE piggybak_variants_options CASCADE;
DROP TABLE piggybak_variants_variants CASCADE;
DROP TABLE posts CASCADE;
DROP TABLE rails_admin_histories CASCADE;
DROP TABLE roles CASCADE;
DROP TABLE roles_users CASCADE;
DROP TABLE schema_migrations CASCADE;
DROP TABLE taggings CASCADE;
DROP TABLE tags CASCADE;
DROP TABLE users CASCADE;
--
-- Name: frames; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE frames (
id integer NOT NULL,
title character varying(255) NOT NULL,
slug character varying(255) NOT NULL,
description text,
main_file_name character varying(255),
main_content_type character varying(255),
main_file_size character varying(255),
main_updated_at timestamp without time zone,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE public.frames OWNER TO piggybak;
--
-- Name: frames_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE frames_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.frames_id_seq OWNER TO piggybak;
--
-- Name: frames_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE frames_id_seq OWNED BY frames.id;
--
-- Name: images; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE images (
id integer NOT NULL,
title character varying(255) NOT NULL,
slug character varying(255) NOT NULL,
description text,
user_id integer NOT NULL,
gallery_file_name character varying(255),
gallery_content_type character varying(255),
gallery_file_size character varying(255),
gallery_updated_at timestamp without time zone,
main_file_name character varying(255),
main_content_type character varying(255),
main_file_size character varying(255),
main_updated_at timestamp without time zone,
created_at timestamp without time zone,
updated_at timestamp without time zone,
is_featured boolean DEFAULT false NOT NULL
);
ALTER TABLE public.images OWNER TO piggybak;
--
-- Name: images_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE images_id_seq
START WITH 100
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.images_id_seq OWNER TO piggybak;
--
-- Name: images_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE images_id_seq OWNED BY images.id;
--
-- Name: pages; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE pages (
id integer NOT NULL,
title character varying(255),
slug character varying(255),
content text,
created_at timestamp without time zone,
updated_at timestamp without time zone
);
ALTER TABLE public.pages OWNER TO piggybak;
--
-- Name: pages_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE pages_id_seq
START WITH 5
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.pages_id_seq OWNER TO piggybak;
--
-- Name: pages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE pages_id_seq OWNED BY pages.id;
--
-- Name: piggybak_addresses; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_addresses (
id integer NOT NULL,
firstname character varying(255) NOT NULL,
lastname character varying(255) NOT NULL,
address1 character varying(255) NOT NULL,
address2 character varying(255),
city character varying(255) NOT NULL,
state_id character varying(255) NOT NULL,
zip character varying(255) NOT NULL,
created_at timestamp without time zone,
updated_at timestamp without time zone,
country_id integer
);
ALTER TABLE public.piggybak_addresses OWNER TO piggybak;
--
-- Name: piggybak_addresses_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_addresses_id_seq
START WITH 50
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_addresses_id_seq OWNER TO piggybak;
--
-- Name: piggybak_addresses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_addresses_id_seq OWNED BY piggybak_addresses.id;
--
-- Name: piggybak_bundle_discounts_bundle_discount_sellables; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_bundle_discounts_bundle_discount_sellables (
id integer NOT NULL,
bundle_discount_id integer NOT NULL,
sellable_id integer NOT NULL
);
ALTER TABLE public.piggybak_bundle_discounts_bundle_discount_sellables OWNER TO piggybak;
--
-- Name: piggybak_bundle_discounts_bundle_discount_sellables_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_bundle_discounts_bundle_discount_sellables_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_bundle_discounts_bundle_discount_sellables_id_seq OWNER TO piggybak;
--
-- Name: piggybak_bundle_discounts_bundle_discount_sellables_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_bundle_discounts_bundle_discount_sellables_id_seq OWNED BY piggybak_bundle_discounts_bundle_discount_sellables.id;
--
-- Name: piggybak_bundle_discounts_bundle_discounts; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_bundle_discounts_bundle_discounts (
id integer NOT NULL,
name character varying(255) NOT NULL,
discount double precision NOT NULL,
multiply boolean DEFAULT false NOT NULL,
active_until timestamp without time zone,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE public.piggybak_bundle_discounts_bundle_discounts OWNER TO piggybak;
--
-- Name: piggybak_bundle_discounts_bundle_discounts_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_bundle_discounts_bundle_discounts_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_bundle_discounts_bundle_discounts_id_seq OWNER TO piggybak;
--
-- Name: piggybak_bundle_discounts_bundle_discounts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_bundle_discounts_bundle_discounts_id_seq OWNED BY piggybak_bundle_discounts_bundle_discounts.id;
--
-- Name: piggybak_countries; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_countries (
id integer NOT NULL,
name character varying(255),
abbr character varying(255),
active_shipping boolean DEFAULT false,
active_billing boolean DEFAULT false
);
ALTER TABLE public.piggybak_countries OWNER TO piggybak;
--
-- Name: piggybak_countries_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_countries_id_seq
START WITH 1000
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_countries_id_seq OWNER TO piggybak;
--
-- Name: piggybak_countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_countries_id_seq OWNED BY piggybak_countries.id;
--
-- Name: piggybak_coupons_coupon_applications; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_coupons_coupon_applications (
id integer NOT NULL,
line_item_id integer,
coupon_id integer
);
ALTER TABLE public.piggybak_coupons_coupon_applications OWNER TO piggybak;
--
-- Name: piggybak_coupons_coupon_applications_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_coupons_coupon_applications_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_coupons_coupon_applications_id_seq OWNER TO piggybak;
--
-- Name: piggybak_coupons_coupon_applications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_coupons_coupon_applications_id_seq OWNED BY piggybak_coupons_coupon_applications.id;
--
-- Name: piggybak_coupons_coupons; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_coupons_coupons (
id integer NOT NULL,
code character varying(255) NOT NULL,
amount numeric(10,2) NOT NULL,
discount_type character varying(255) NOT NULL,
min_cart_total numeric(10,2) NOT NULL,
expiration_date date,
allowed_applications integer
);
ALTER TABLE public.piggybak_coupons_coupons OWNER TO piggybak;
--
-- Name: piggybak_coupons_coupons_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_coupons_coupons_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_coupons_coupons_id_seq OWNER TO piggybak;
--
-- Name: piggybak_coupons_coupons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_coupons_coupons_id_seq OWNED BY piggybak_coupons_coupons.id;
--
-- Name: piggybak_giftcerts_buyable_giftcerts; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_giftcerts_buyable_giftcerts (
id integer NOT NULL
);
ALTER TABLE public.piggybak_giftcerts_buyable_giftcerts OWNER TO piggybak;
--
-- Name: piggybak_giftcerts_buyable_giftcerts_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_giftcerts_buyable_giftcerts_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_giftcerts_buyable_giftcerts_id_seq OWNER TO piggybak;
--
-- Name: piggybak_giftcerts_buyable_giftcerts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_giftcerts_buyable_giftcerts_id_seq OWNED BY piggybak_giftcerts_buyable_giftcerts.id;
--
-- Name: piggybak_giftcerts_giftcert_applications; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_giftcerts_giftcert_applications (
id integer NOT NULL,
line_item_id integer,
giftcert_id integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE public.piggybak_giftcerts_giftcert_applications OWNER TO piggybak;
--
-- Name: piggybak_giftcerts_giftcert_applications_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_giftcerts_giftcert_applications_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_giftcerts_giftcert_applications_id_seq OWNER TO piggybak;
--
-- Name: piggybak_giftcerts_giftcert_applications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_giftcerts_giftcert_applications_id_seq OWNED BY piggybak_giftcerts_giftcert_applications.id;
--
-- Name: piggybak_giftcerts_giftcerts; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_giftcerts_giftcerts (
id integer NOT NULL,
code character varying(255) NOT NULL,
amount numeric NOT NULL,
expiration_date date,
order_id integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE public.piggybak_giftcerts_giftcerts OWNER TO piggybak;
--
-- Name: piggybak_giftcerts_giftcerts_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_giftcerts_giftcerts_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_giftcerts_giftcerts_id_seq OWNER TO piggybak;
--
-- Name: piggybak_giftcerts_giftcerts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_giftcerts_giftcerts_id_seq OWNED BY piggybak_giftcerts_giftcerts.id;
--
-- Name: piggybak_line_items; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_line_items (
id integer NOT NULL,
order_id integer NOT NULL,
quantity integer NOT NULL,
sellable_id integer,
price numeric(10,2),
unit_price numeric(10,2) DEFAULT 0.0 NOT NULL,
description character varying(255) DEFAULT ''::character varying NOT NULL,
line_item_type character varying(255) DEFAULT 'sellable'::character varying NOT NULL,
created_at timestamp without time zone,
updated_at timestamp without time zone
);
ALTER TABLE public.piggybak_line_items OWNER TO piggybak;
--
-- Name: piggybak_line_items_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_line_items_id_seq
START WITH 30
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_line_items_id_seq OWNER TO piggybak;
--
-- Name: piggybak_line_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_line_items_id_seq OWNED BY piggybak_line_items.id;
--
-- Name: piggybak_order_notes; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_order_notes (
id integer NOT NULL,
order_id integer NOT NULL,
user_id integer NOT NULL,
note text,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE public.piggybak_order_notes OWNER TO piggybak;
--
-- Name: piggybak_order_notes_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_order_notes_id_seq
START WITH 30
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_order_notes_id_seq OWNER TO piggybak;
--
-- Name: piggybak_order_notes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_order_notes_id_seq OWNED BY piggybak_order_notes.id;
--
-- Name: piggybak_orders; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_orders (
id integer NOT NULL,
billing_address_id integer NOT NULL,
shipping_address_id integer NOT NULL,
user_id integer,
email character varying(255) NOT NULL,
phone character varying(255) NOT NULL,
total numeric(10,2) NOT NULL,
total_due numeric(10,2) NOT NULL,
status character varying(255) NOT NULL,
created_at timestamp without time zone,
updated_at timestamp without time zone,
ip_address character varying(255),
user_agent text,
to_be_cancelled boolean DEFAULT false,
confirmation_sent boolean DEFAULT false
);
ALTER TABLE public.piggybak_orders OWNER TO piggybak;
--
-- Name: piggybak_orders_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_orders_id_seq
START WITH 30
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_orders_id_seq OWNER TO piggybak;
--
-- Name: piggybak_orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_orders_id_seq OWNED BY piggybak_orders.id;
--
-- Name: piggybak_payment_method_values; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_payment_method_values (
id integer NOT NULL,
payment_method_id integer,
key character varying(255),
value character varying(255)
);
ALTER TABLE public.piggybak_payment_method_values OWNER TO piggybak;
--
-- Name: piggybak_payment_method_values_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_payment_method_values_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_payment_method_values_id_seq OWNER TO piggybak;
--
-- Name: piggybak_payment_method_values_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_payment_method_values_id_seq OWNED BY piggybak_payment_method_values.id;
--
-- Name: piggybak_payment_methods; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_payment_methods (
id integer NOT NULL,
description character varying(255) NOT NULL,
klass character varying(255) NOT NULL,
active boolean DEFAULT false NOT NULL,
created_at timestamp without time zone,
updated_at timestamp without time zone
);
ALTER TABLE public.piggybak_payment_methods OWNER TO piggybak;
--
-- Name: piggybak_payment_methods_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_payment_methods_id_seq
START WITH 5
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_payment_methods_id_seq OWNER TO piggybak;
--
-- Name: piggybak_payment_methods_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_payment_methods_id_seq OWNED BY piggybak_payment_methods.id;
--
-- Name: piggybak_payments; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_payments (
id integer NOT NULL,
payment_method_id integer,
status character varying(255) DEFAULT 'paid'::character varying NOT NULL,
month integer,
year integer,
transaction_id character varying(255),
created_at timestamp without time zone,
updated_at timestamp without time zone,
masked_number character varying(255),
line_item_id integer
);
ALTER TABLE public.piggybak_payments OWNER TO piggybak;
--
-- Name: piggybak_payments_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_payments_id_seq
START WITH 50
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_payments_id_seq OWNER TO piggybak;
--
-- Name: piggybak_payments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_payments_id_seq OWNED BY piggybak_payments.id;
--
-- Name: piggybak_sellables; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_sellables (
id integer NOT NULL,
sku character varying(255) NOT NULL,
description character varying(255) NOT NULL,
price numeric(10,2) NOT NULL,
quantity integer DEFAULT 0 NOT NULL,
item_id integer NOT NULL,
item_type character varying(255) NOT NULL,
active boolean DEFAULT false NOT NULL,
unlimited_inventory boolean DEFAULT false NOT NULL
);
ALTER TABLE public.piggybak_sellables OWNER TO piggybak;
--
-- Name: piggybak_sellables_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_sellables_id_seq
START WITH 100
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_sellables_id_seq OWNER TO piggybak;
--
-- Name: piggybak_sellables_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_sellables_id_seq OWNED BY piggybak_sellables.id;
--
-- Name: piggybak_shipments; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_shipments (
id integer NOT NULL,
shipping_method_id integer NOT NULL,
status character varying(255) DEFAULT 'new'::character varying NOT NULL,
created_at timestamp without time zone,
updated_at timestamp without time zone,
line_item_id integer
);
ALTER TABLE public.piggybak_shipments OWNER TO piggybak;
--
-- Name: piggybak_shipments_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_shipments_id_seq
START WITH 20
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_shipments_id_seq OWNER TO piggybak;
--
-- Name: piggybak_shipments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_shipments_id_seq OWNED BY piggybak_shipments.id;
--
-- Name: piggybak_shipping_method_values; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_shipping_method_values (
id integer NOT NULL,
shipping_method_id integer,
key character varying(255),
value character varying(255)
);
ALTER TABLE public.piggybak_shipping_method_values OWNER TO piggybak;
--
-- Name: piggybak_shipping_method_values_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_shipping_method_values_id_seq
START WITH 20
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_shipping_method_values_id_seq OWNER TO piggybak;
--
-- Name: piggybak_shipping_method_values_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_shipping_method_values_id_seq OWNED BY piggybak_shipping_method_values.id;
--
-- Name: piggybak_shipping_methods; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_shipping_methods (
id integer NOT NULL,
description character varying(255) NOT NULL,
klass character varying(255) NOT NULL,
active boolean DEFAULT false NOT NULL
);
ALTER TABLE public.piggybak_shipping_methods OWNER TO piggybak;
--
-- Name: piggybak_shipping_methods_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_shipping_methods_id_seq
START WITH 10
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_shipping_methods_id_seq OWNER TO piggybak;
--
-- Name: piggybak_shipping_methods_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_shipping_methods_id_seq OWNED BY piggybak_shipping_methods.id;
--
-- Name: piggybak_states; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_states (
id integer NOT NULL,
abbr character varying(255),
name character varying(255),
country_id integer
);
ALTER TABLE public.piggybak_states OWNER TO piggybak;
--
-- Name: piggybak_states_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_states_id_seq
START WITH 1000
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_states_id_seq OWNER TO piggybak;
--
-- Name: piggybak_states_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_states_id_seq OWNED BY piggybak_states.id;
--
-- Name: piggybak_tax_method_values; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_tax_method_values (
id integer NOT NULL,
tax_method_id integer,
key character varying(255),
value character varying(255)
);
ALTER TABLE public.piggybak_tax_method_values OWNER TO piggybak;
--
-- Name: piggybak_tax_method_values_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_tax_method_values_id_seq
START WITH 10
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_tax_method_values_id_seq OWNER TO piggybak;
--
-- Name: piggybak_tax_method_values_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_tax_method_values_id_seq OWNED BY piggybak_tax_method_values.id;
--
-- Name: piggybak_tax_methods; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_tax_methods (
id integer NOT NULL,
description character varying(255) NOT NULL,
klass character varying(255) NOT NULL,
active boolean DEFAULT false NOT NULL
);
ALTER TABLE public.piggybak_tax_methods OWNER TO piggybak;
--
-- Name: piggybak_tax_methods_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_tax_methods_id_seq
START WITH 10
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_tax_methods_id_seq OWNER TO piggybak;
--
-- Name: piggybak_tax_methods_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_tax_methods_id_seq OWNED BY piggybak_tax_methods.id;
--
-- Name: piggybak_taxonomy_navigation_nodes; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_taxonomy_navigation_nodes (
id integer NOT NULL,
title character varying(255),
slug character varying(255),
"position" character varying(255),
ancestry character varying(255),
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE public.piggybak_taxonomy_navigation_nodes OWNER TO piggybak;
--
-- Name: piggybak_taxonomy_navigation_nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_taxonomy_navigation_nodes_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_taxonomy_navigation_nodes_id_seq OWNER TO piggybak;
--
-- Name: piggybak_taxonomy_navigation_nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_taxonomy_navigation_nodes_id_seq OWNED BY piggybak_taxonomy_navigation_nodes.id;
--
-- Name: piggybak_taxonomy_sellable_taxonomies; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_taxonomy_sellable_taxonomies (
id integer NOT NULL,
navigation_node_id integer NOT NULL,
sellable_id integer NOT NULL,
sort integer DEFAULT 0 NOT NULL
);
ALTER TABLE public.piggybak_taxonomy_sellable_taxonomies OWNER TO piggybak;
--
-- Name: piggybak_taxonomy_sellable_taxonomies_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_taxonomy_sellable_taxonomies_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_taxonomy_sellable_taxonomies_id_seq OWNER TO piggybak;
--
-- Name: piggybak_taxonomy_sellable_taxonomies_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_taxonomy_sellable_taxonomies_id_seq OWNED BY piggybak_taxonomy_sellable_taxonomies.id;
--
-- Name: piggybak_variants_option_configurations; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_variants_option_configurations (
id integer NOT NULL,
klass character varying(255) NOT NULL,
option_id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE public.piggybak_variants_option_configurations OWNER TO piggybak;
--
-- Name: piggybak_variants_option_configurations_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_variants_option_configurations_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_variants_option_configurations_id_seq OWNER TO piggybak;
--
-- Name: piggybak_variants_option_configurations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_variants_option_configurations_id_seq OWNED BY piggybak_variants_option_configurations.id;
--
-- Name: piggybak_variants_option_values; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_variants_option_values (
id integer NOT NULL,
option_id integer,
name character varying(255),
"position" integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE public.piggybak_variants_option_values OWNER TO piggybak;
--
-- Name: piggybak_variants_option_values_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_variants_option_values_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_variants_option_values_id_seq OWNER TO piggybak;
--
-- Name: piggybak_variants_option_values_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_variants_option_values_id_seq OWNED BY piggybak_variants_option_values.id;
--
-- Name: piggybak_variants_option_values_variants; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_variants_option_values_variants (
option_value_id integer,
variant_id integer
);
ALTER TABLE public.piggybak_variants_option_values_variants OWNER TO piggybak;
--
-- Name: piggybak_variants_options; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_variants_options (
id integer NOT NULL,
name character varying(255),
"position" integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE public.piggybak_variants_options OWNER TO piggybak;
--
-- Name: piggybak_variants_options_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_variants_options_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_variants_options_id_seq OWNER TO piggybak;
--
-- Name: piggybak_variants_options_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_variants_options_id_seq OWNED BY piggybak_variants_options.id;
--
-- Name: piggybak_variants_variants; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE piggybak_variants_variants (
id integer NOT NULL,
item_id integer NOT NULL,
item_type character varying(255) NOT NULL,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
ALTER TABLE public.piggybak_variants_variants OWNER TO piggybak;
--
-- Name: piggybak_variants_variants_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE piggybak_variants_variants_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.piggybak_variants_variants_id_seq OWNER TO piggybak;
--
-- Name: piggybak_variants_variants_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE piggybak_variants_variants_id_seq OWNED BY piggybak_variants_variants.id;
--
-- Name: posts; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE posts (
id integer NOT NULL,
title character varying(255) NOT NULL,
slug character varying(255) NOT NULL,
user_id integer,
content text,
created_at timestamp without time zone,
updated_at timestamp without time zone
);
ALTER TABLE public.posts OWNER TO piggybak;
--
-- Name: posts_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE posts_id_seq
START WITH 10
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.posts_id_seq OWNER TO piggybak;
--
-- Name: posts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE posts_id_seq OWNED BY posts.id;
--
-- Name: rails_admin_histories; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE rails_admin_histories (
id integer NOT NULL,
message text,
username character varying(255),
item integer,
"table" character varying(255),
month smallint,
year bigint,
created_at timestamp without time zone,
updated_at timestamp without time zone
);
ALTER TABLE public.rails_admin_histories OWNER TO piggybak;
--
-- Name: rails_admin_histories_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE rails_admin_histories_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.rails_admin_histories_id_seq OWNER TO piggybak;
--
-- Name: rails_admin_histories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE rails_admin_histories_id_seq OWNED BY rails_admin_histories.id;
--
-- Name: roles; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE roles (
id integer NOT NULL,
name character varying(255)
);
ALTER TABLE public.roles OWNER TO piggybak;
--
-- Name: roles_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE roles_id_seq
START WITH 20
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.roles_id_seq OWNER TO piggybak;
--
-- Name: roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE roles_id_seq OWNED BY roles.id;
--
-- Name: roles_users; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE roles_users (
role_id integer,
user_id integer
);
ALTER TABLE public.roles_users OWNER TO piggybak;
--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE schema_migrations (
version character varying(255) NOT NULL
);
ALTER TABLE public.schema_migrations OWNER TO piggybak;
--
-- Name: taggings; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE taggings (
id integer NOT NULL,
tag_id integer,
taggable_id integer,
taggable_type character varying(255),
tagger_id integer,
tagger_type character varying(255),
context character varying(128),
created_at timestamp without time zone
);
ALTER TABLE public.taggings OWNER TO piggybak;
--
-- Name: taggings_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE taggings_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.taggings_id_seq OWNER TO piggybak;
--
-- Name: taggings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE taggings_id_seq OWNED BY taggings.id;
--
-- Name: tags; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE tags (
id integer NOT NULL,
name character varying(255)
);
ALTER TABLE public.tags OWNER TO piggybak;
--
-- Name: tags_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE tags_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.tags_id_seq OWNER TO piggybak;
--
-- Name: tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE tags_id_seq OWNED BY tags.id;
--
-- Name: users; Type: TABLE; Schema: public; Owner: piggybak; Tablespace:
--
CREATE TABLE users (
id integer NOT NULL,
email character varying(255) DEFAULT ''::character varying NOT NULL,
encrypted_password character varying(128) DEFAULT ''::character varying NOT NULL,
reset_password_token character varying(255),
reset_password_sent_at timestamp without time zone,
remember_created_at timestamp without time zone,
sign_in_count integer DEFAULT 0,
current_sign_in_at timestamp without time zone,
last_sign_in_at timestamp without time zone,
current_sign_in_ip character varying(255),
last_sign_in_ip character varying(255),
display_name character varying(255) NOT NULL,
created_at timestamp without time zone,
updated_at timestamp without time zone
);
ALTER TABLE public.users OWNER TO piggybak;
--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: piggybak
--
CREATE SEQUENCE users_id_seq
START WITH 20
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.users_id_seq OWNER TO piggybak;
--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: piggybak
--
ALTER SEQUENCE users_id_seq OWNED BY users.id;
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY frames ALTER COLUMN id SET DEFAULT nextval('frames_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY images ALTER COLUMN id SET DEFAULT nextval('images_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY pages ALTER COLUMN id SET DEFAULT nextval('pages_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_addresses ALTER COLUMN id SET DEFAULT nextval('piggybak_addresses_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_bundle_discounts_bundle_discount_sellables ALTER COLUMN id SET DEFAULT nextval('piggybak_bundle_discounts_bundle_discount_sellables_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_bundle_discounts_bundle_discounts ALTER COLUMN id SET DEFAULT nextval('piggybak_bundle_discounts_bundle_discounts_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_countries ALTER COLUMN id SET DEFAULT nextval('piggybak_countries_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_coupons_coupon_applications ALTER COLUMN id SET DEFAULT nextval('piggybak_coupons_coupon_applications_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_coupons_coupons ALTER COLUMN id SET DEFAULT nextval('piggybak_coupons_coupons_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_giftcerts_buyable_giftcerts ALTER COLUMN id SET DEFAULT nextval('piggybak_giftcerts_buyable_giftcerts_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_giftcerts_giftcert_applications ALTER COLUMN id SET DEFAULT nextval('piggybak_giftcerts_giftcert_applications_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_giftcerts_giftcerts ALTER COLUMN id SET DEFAULT nextval('piggybak_giftcerts_giftcerts_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_line_items ALTER COLUMN id SET DEFAULT nextval('piggybak_line_items_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_order_notes ALTER COLUMN id SET DEFAULT nextval('piggybak_order_notes_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_orders ALTER COLUMN id SET DEFAULT nextval('piggybak_orders_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_payment_method_values ALTER COLUMN id SET DEFAULT nextval('piggybak_payment_method_values_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_payment_methods ALTER COLUMN id SET DEFAULT nextval('piggybak_payment_methods_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_payments ALTER COLUMN id SET DEFAULT nextval('piggybak_payments_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_sellables ALTER COLUMN id SET DEFAULT nextval('piggybak_sellables_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_shipments ALTER COLUMN id SET DEFAULT nextval('piggybak_shipments_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_shipping_method_values ALTER COLUMN id SET DEFAULT nextval('piggybak_shipping_method_values_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_shipping_methods ALTER COLUMN id SET DEFAULT nextval('piggybak_shipping_methods_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_states ALTER COLUMN id SET DEFAULT nextval('piggybak_states_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_tax_method_values ALTER COLUMN id SET DEFAULT nextval('piggybak_tax_method_values_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_tax_methods ALTER COLUMN id SET DEFAULT nextval('piggybak_tax_methods_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_taxonomy_navigation_nodes ALTER COLUMN id SET DEFAULT nextval('piggybak_taxonomy_navigation_nodes_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_taxonomy_sellable_taxonomies ALTER COLUMN id SET DEFAULT nextval('piggybak_taxonomy_sellable_taxonomies_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_variants_option_configurations ALTER COLUMN id SET DEFAULT nextval('piggybak_variants_option_configurations_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_variants_option_values ALTER COLUMN id SET DEFAULT nextval('piggybak_variants_option_values_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_variants_options ALTER COLUMN id SET DEFAULT nextval('piggybak_variants_options_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY piggybak_variants_variants ALTER COLUMN id SET DEFAULT nextval('piggybak_variants_variants_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY posts ALTER COLUMN id SET DEFAULT nextval('posts_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY rails_admin_histories ALTER COLUMN id SET DEFAULT nextval('rails_admin_histories_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY roles ALTER COLUMN id SET DEFAULT nextval('roles_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY taggings ALTER COLUMN id SET DEFAULT nextval('taggings_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY tags ALTER COLUMN id SET DEFAULT nextval('tags_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: piggybak
--
ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
--
-- Data for Name: frames; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY frames (id, title, slug, description, main_file_name, main_content_type, main_file_size, main_updated_at, created_at, updated_at) FROM stdin;
1 Professional Frame frame Purchase a frame to go with your print! Frames are available in two sizes (10" x 20" and 20" x 40") and four finishes. All frames include white matboard. frames.jpg image/jpeg 48501 2012-11-05 15:41:30.337191 2012-11-05 15:41:30.950787 2012-11-05 15:52:43.768192
\.
--
-- Name: frames_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('frames_id_seq', 1, true);
--
-- Data for Name: images; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY images (id, title, slug, description, user_id, gallery_file_name, gallery_content_type, gallery_file_size, gallery_updated_at, main_file_name, main_content_type, main_file_size, main_updated_at, created_at, updated_at, is_featured) FROM stdin;
19 Backlit Fall Leaves backlit-fall-leaves Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_0988.jpg image/jpeg 41431 2012-01-05 04:02:17.527388 IMG_0988 (2).jpg image/jpeg 96516 2012-01-06 03:06:14.112479 2012-01-04 01:48:59.726619 2012-01-06 03:06:14.268086 f
17 Murky Reflection murky-reflection Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_0609.jpg image/jpeg 45565 2012-01-05 04:02:09.769174 IMG_0609 (2).jpg image/jpeg 140129 2012-01-06 03:03:39.315426 2012-01-04 01:46:37.840913 2012-01-06 03:03:39.474964 f
23 Spider spider Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_1536.jpg image/jpeg 27710 2012-01-05 04:01:16.011062 IMG_1536 (2).jpg image/jpeg 57358 2012-01-06 03:02:47.276154 2012-01-04 01:52:25.037344 2012-01-06 03:02:47.511552 f
21 Car Window car-window Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_1268.jpg image/jpeg 44889 2012-01-05 04:00:07.543055 IMG_1268 (2).jpg image/jpeg 106393 2012-01-06 03:03:12.78358 2012-01-04 01:50:49.530661 2012-01-06 03:03:12.936139 f
20 Green Bokeh green-bokeh Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_1028.jpg image/jpeg 37003 2012-01-05 04:02:26.702469 IMG_1028 (2).jpg image/jpeg 87977 2012-01-06 03:03:21.248613 2012-01-04 01:49:59.772243 2012-01-06 03:03:21.499063 f
12 Dog in Sunglasses dog-sunglasses Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_8294.jpg image/jpeg 40478 2012-01-05 03:57:50.636307 IMG_8294 (2).jpg image/jpeg 92476 2012-01-06 03:09:19.681559 2012-01-04 01:27:22.702599 2012-01-06 03:09:19.820237 f
22 Dog Lookout dog-lookout Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_1458.jpg image/jpeg 33929 2012-01-05 03:59:52.267494 IMG_1458 (2).jpg image/jpeg 75948 2012-01-06 03:03:00.661259 2012-01-04 01:51:44.08727 2012-01-06 03:03:00.812015 f
16 Nature nature Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_0980.jpg image/jpeg 34911 2012-01-05 03:58:56.92517 IMG_0980.jpg image/jpeg 77774 2012-01-06 03:03:47.696025 2012-01-04 01:41:41.914299 2012-01-06 03:03:47.846072 f
15 Beach Dog beach-dog Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_0262.jpg image/jpeg 32280 2012-01-05 04:00:20.512985 IMG_0262 (2).jpg image/jpeg 79680 2012-01-06 03:08:03.74322 2012-01-04 01:38:51.87074 2012-01-06 03:08:03.892608 f
18 Butterfly butterfly Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_0928.jpg image/jpeg 34827 2012-01-05 03:58:44.497056 IMG_0928 (2).jpg image/jpeg 72064 2012-01-06 03:03:29.916677 2012-01-04 01:47:45.592717 2012-01-06 03:03:30.066065 f
14 Tired Puppy tired-puppy Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_7785.jpg image/jpeg 30221 2012-01-05 03:58:21.898289 IMG_7785.jpg image/jpeg 61377 2012-01-06 03:04:18.222199 2012-01-04 01:37:55.347265 2012-01-06 03:04:18.37046 f
35 Nature #2 nature-2 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_5662.jpg image/jpeg 43548 2012-01-05 03:54:17.926043 IMG_5662 (2).jpg image/jpeg 114621 2012-01-06 02:51:40.791842 2012-01-04 02:07:08.109208 2012-01-06 02:51:41.049886 f
40 Best Friends best-friends Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_8262.jpg image/jpeg 40076 2012-01-05 03:51:32.488375 IMG_8262 (2).jpg image/jpeg 104557 2012-01-06 02:50:37.365756 2012-01-04 02:11:23.269686 2012-01-06 02:50:37.50471 f
28 Puppy Pile puppy-pile Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_4575.jpg image/jpeg 34836 2012-01-05 03:56:43.630299 IMG_4575 (2).jpg image/jpeg 73476 2012-01-06 03:01:36.981517 2012-01-04 01:57:01.570171 2012-01-06 03:01:37.144175 f
34 Tug Of War tug-of-war Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_5488.jpg image/jpeg 33189 2012-01-05 03:54:37.244278 IMG_5488 (2).jpg image/jpeg 70391 2012-01-06 02:51:52.395457 2012-01-04 02:05:33.246414 2012-01-06 02:51:52.544557 f
30 Pollination pollination This is a description for pollination. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_4991.jpg image/jpeg 36220 2012-01-05 03:56:14.639197 IMG_4991 (2).jpg image/jpeg 87487 2012-01-06 02:53:15.873413 2012-01-04 01:59:10.399855 2012-01-06 02:53:16.022288 t
29 Purple Flowers purple-flowers Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_4968.jpg image/jpeg 40189 2012-01-05 03:56:29.725263 IMG_4968 (2).jpg image/jpeg 85800 2012-01-06 02:53:27.422139 2012-01-04 01:58:19.376719 2012-01-06 02:53:27.57473 f
27 Happy Beagle happy-beagle Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_3880.jpg image/jpeg 54633 2012-01-05 03:57:03.822005 IMG_3880 (2).jpg image/jpeg 162972 2012-01-06 03:02:10.336384 2012-01-04 01:56:09.84998 2012-01-06 03:02:10.501727 f
25 Puppy Pals puppy-pals Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_3536.jpg image/jpeg 38042 2012-01-05 03:57:16.770321 IMG_3536 (2).jpg image/jpeg 84435 2012-01-06 03:02:22.057652 2012-01-04 01:54:44.063851 2012-01-06 03:02:22.223951 f
24 Spider Duo spider-duo Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_2739.jpg image/jpeg 38569 2012-01-05 04:01:05.115159 IMG_2739 (2).jpg image/jpeg 82394 2012-01-06 03:02:35.608226 2012-01-04 01:53:55.327604 2012-01-06 03:02:35.758069 f
33 Spiderweb spiderweb Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_5363.jpg image/jpeg 33836 2012-01-05 03:55:02.365646 IMG_5363 (2).jpg image/jpeg 78344 2012-01-06 03:05:51.562723 2012-01-04 02:04:19.266243 2012-01-06 03:05:51.806537 f
41 Street Cat street-cat Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_8604.jpg image/jpeg 34090 2012-01-05 03:51:18.704083 IMG_8604 (2).jpg image/jpeg 79893 2012-01-06 02:50:24.491587 2012-01-04 02:12:11.715957 2012-01-06 02:50:24.710716 t
39 Make a Wish make-a-wish Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_8003.jpg image/jpeg 38606 2012-01-05 03:51:46.898428 IMG_8003 (2).jpg image/jpeg 96062 2012-01-06 02:50:52.858552 2012-01-04 02:10:36.607113 2012-01-06 02:50:52.997194 f
44 Japanese Maple japanese-maple Here is a description for Japanese Maple. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_9608.jpg image/jpeg 35674 2012-01-05 03:49:58.302731 IMG_9608 (2).jpg image/jpeg 77961 2012-01-06 02:49:34.261722 2012-01-04 02:15:29.245068 2012-01-06 02:49:34.510136 t
43 Spider #2 spider-2 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_9205.jpg image/jpeg 33984 2012-01-05 03:50:35.561096 IMG_9205 (2).jpg image/jpeg 75189 2012-01-06 02:49:53.765752 2012-01-04 02:14:15.202401 2012-01-06 02:49:53.91309 f
42 Fall Colors fall-colors Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_8784.jpg image/jpeg 53858 2012-01-05 03:50:51.722957 IMG_8784 (2).jpg image/jpeg 162781 2012-01-06 02:50:12.277823 2012-01-04 02:13:29.236201 2012-01-06 02:50:12.443617 f
38 Nature #4 nature-4 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_6262.jpg image/jpeg 39719 2012-01-05 03:52:00.3107 IMG_6262 (2).jpg image/jpeg 106741 2012-01-06 02:51:04.614477 2012-01-04 02:09:51.890184 2012-01-06 02:51:04.763192 f
37 Floor Dog floor-dog Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_5987.jpg image/jpeg 33664 2012-01-05 03:52:14.736048 IMG_5987 (2).jpg image/jpeg 71490 2012-01-06 02:51:17.040249 2012-01-04 02:08:46.4199 2012-01-06 02:51:17.176603 f
36 Nature #3 nature-3 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_5668.jpg image/jpeg 34040 2012-01-05 03:52:28.372689 IMG_5668 (2).jpg image/jpeg 75551 2012-01-06 02:51:27.464653 2012-01-04 02:07:55.197138 2012-01-06 02:51:27.61041 f
32 Beach Dog #2 beach-dog-2 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_5220.jpg image/jpeg 51321 2012-01-05 03:55:31.299079 IMG_5220 (2).jpg image/jpeg 132938 2012-01-06 02:52:51.561219 2012-01-04 02:03:05.963117 2012-01-06 02:52:51.712604 f
31 Pollination #2 pollination-2 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_5078.jpg image/jpeg 35775 2012-01-05 03:55:59.614872 IMG_5078 (2).jpg image/jpeg 72021 2012-01-06 02:53:03.887999 2012-01-04 01:59:58.192968 2012-01-06 02:53:04.050902 f
13 Havanese Smile havanese-smile Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_0276.jpg image/jpeg 47522 2012-01-05 03:58:03.825062 IMG_0276 (2).jpg image/jpeg 87106 2012-01-06 03:04:08.348957 2012-01-04 01:28:34.72775 2012-01-06 03:04:08.598823 f
11 Fall Leaves fall-leaves Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_2836.jpg image/jpeg 61986 2012-01-05 03:57:29.962346 IMG_2836.jpg image/jpeg 206737 2012-01-06 03:04:35.133013 2012-01-04 01:26:18.728123 2012-01-06 03:04:35.30472 f
45 Relaxing Puppy relaxing-puppy Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 10 IMG_9892.jpg image/jpeg 35612 2012-01-05 03:49:17.471811 IMG_9892 (2).jpg image/jpeg 84226 2012-01-06 02:49:16.499131 2012-01-04 02:16:30.973072 2012-01-06 02:49:16.648919 f
\.
--
-- Name: images_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('images_id_seq', 45, true);
--
-- Data for Name: pages; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY pages (id, title, slug, content, created_at, updated_at) FROM stdin;
2 Terms terms <p>\r\n\tThis is a generic Terms and Conditions page in the Piggbak demo. It&#39;s content is driven by a WYSIWYG editor in the Admin.</p>\r\n<h3>\r\n\tAll Rights Reserved</h3>\r\n<p>\r\n\tThe photos shown in this demo are &copy; Steph Skardal. All Rights Reserved.</p>\r\n<h3>\r\n\tTemplate</h3>\r\n<p>\r\n\tThe template shown in this demo was purchased from <a href="http://themeforest.net/item/sevenwonders-clean-responsive-html-template/1157155">ThemeForest</a>, under the <a href="http://themeforest.net/wiki/support/legal-terms/licensing-terms/">Regular License</a>. It can not be ported to additional sites without purchase of the theme.</p>\r\n 2012-01-04 00:01:29.190115 2012-01-10 21:24:22.633361
1 About about <p>\r\n\tThis is a generic about page in the Piggybak demo. It is driven by a WYSIWYG editor in the Admin.</p>\r\n\r\n<h3>About Piggybak</h3>\r\n\r\n<p>Piggybak is a Ruby on Rails 3 gem that offers mountable ecommerce functionality. Visit the main site <a href="/">here</a>.</p> 2012-01-03 23:59:47.608532 2012-01-10 21:25:37.762214
\.
--
-- Name: pages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('pages_id_seq', 2, true);
--
-- Data for Name: piggybak_addresses; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_addresses (id, firstname, lastname, address1, address2, city, state_id, zip, created_at, updated_at, country_id) FROM stdin;
41 Testy Tester 12360 West Carolina Dr. Lakewood 6883 80228 2012-01-10 16:16:12.893695 2012-01-10 16:16:12.893695 405
42 Testy Tester 12360 West Carolina Dr. Lakewood 6883 80228 2012-01-10 16:16:13.066987 2012-01-10 16:16:13.066987 405
43 Steph Skardal 54 Elizabeth St. Salt Lake City 6926 84105 2012-01-10 16:19:25.728466 2012-01-10 16:19:25.728466 405
44 Steph Skardal 54 Elizabeth St. Salt Lake City 6926 84105 2012-01-10 16:19:25.731399 2012-01-10 16:19:25.731399 405
45 S S 123 WS 6907 27103 2014-03-31 22:01:33.295337 2014-03-31 22:01:33.295337 405
46 S S 123 WS 6907 27103 2014-03-31 22:01:33.302465 2014-03-31 22:01:33.302465 405
\.
--
-- Name: piggybak_addresses_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_addresses_id_seq', 46, true);
--
-- Data for Name: piggybak_bundle_discounts_bundle_discount_sellables; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_bundle_discounts_bundle_discount_sellables (id, bundle_discount_id, sellable_id) FROM stdin;
3 2 29
4 2 30
5 3 15
6 3 34
7 3 35
8 3 37
\.
--
-- Name: piggybak_bundle_discounts_bundle_discount_sellables_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_bundle_discounts_bundle_discount_sellables_id_seq', 8, true);
--
-- Data for Name: piggybak_bundle_discounts_bundle_discounts; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_bundle_discounts_bundle_discounts (id, name, discount, multiply, active_until, created_at, updated_at) FROM stdin;
2 Pollination Bundle Discount 10 f \N 2012-11-15 23:55:45.447528 2012-11-15 23:55:45.447528
3 Nature Discount 20 f \N 2012-11-15 23:56:13.221795 2012-11-15 23:56:13.221795
\.
--
-- Name: piggybak_bundle_discounts_bundle_discounts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_bundle_discounts_bundle_discounts_id_seq', 3, true);
--
-- Data for Name: piggybak_countries; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_countries (id, name, abbr, active_shipping, active_billing) FROM stdin;
176 Andorra AD f f
177 United Arab Emirates AE f f
178 Afghanistan AF f f
179 Antigua and Barbuda AG f f
180 Anguilla AI f f
181 Albania AL f f
182 Armenia AM f f
183 Netherlands Antilles AN f f
184 Angola AO f f
185 Antarctica AQ f f
186 Argentina AR f f
187 American Samoa AS f f
188 Austria AT f f
189 Australia AU f f
190 Aruba AW f f
191 Åland Islands AX f f
192 Azerbaijan AZ f f
193 Bosnia and Herzegovina BA f f
194 Barbados BB f f
195 Bangladesh BD f f
196 Belgium BE f f
197 Burkina Faso BF f f
198 Bulgaria BG f f
199 Bahrain BH f f
200 Burundi BI f f
201 Benin BJ f f
202 Saint Barthélemy BL f f
203 Bermuda BM f f
204 Brunei Darussalam BN f f
205 Bolivia BO f f
206 Brazil BR f f
207 Bahamas BS f f
208 Bhutan BT f f
209 Bouvet Island BV f f
210 Botswana BW f f
211 Belarus BY f f
212 Belize BZ f f
214 Cocos (Keeling) Islands CC f f
215 Congo, The Democratic Republic Of The CD f f
216 Central African Republic CF f f
217 Congo CG f f
218 Switzerland CH f f
219 Côte D'Ivoire CI f f
220 Cook Islands CK f f
221 Chile CL f f
222 Cameroon CM f f
223 China CN f f
224 Colombia CO f f
225 Costa Rica CR f f
226 Cuba CU f f
227 Cape Verde CV f f
228 Christmas Island CX f f
229 Cyprus CY f f
230 Czech Republic CZ f f
231 Germany DE f f
232 Djibouti DJ f f
233 Denmark DK f f
234 Dominica DM f f
235 Dominican Republic DO f f
236 Algeria DZ f f
237 Ecuador EC f f
238 Estonia EE f f
239 Egypt EG f f
240 Western Sahara EH f f
241 Eritrea ER f f
242 Spain ES f f
243 Ethiopia ET f f
244 Finland FI f f
245 Fiji FJ f f
246 Falkland Islands (Malvinas) FK f f
247 Micronesia, Federated States Of FM f f
248 Faroe Islands FO f f
249 France FR f f
250 Gabon GA f f
251 United Kingdom GB f f
252 Grenada GD f f
253 Georgia GE f f
254 French Guiana GF f f
255 Guernsey GG f f
256 Ghana GH f f
257 Gibraltar GI f f
258 Greenland GL f f
259 Gambia GM f f
260 Guinea GN f f
261 Guadeloupe GP f f
262 Equatorial Guinea GQ f f
263 Greece GR f f
264 South Georgia and the South Sandwich Islands GS f f
265 Guatemala GT f f
266 Guam GU f f
267 Guinea-Bissau GW f f
268 Guyana GY f f
269 Hong Kong HK f f
270 Heard and McDonald Islands HM f f
271 Honduras HN f f
272 Croatia HR f f
273 Haiti HT f f
274 Hungary HU f f
275 Indonesia ID f f
276 Ireland IE f f
277 Israel IL f f
278 Isle of Man IM f f
279 India IN f f
281 Iraq IQ f f
282 Iran, Islamic Republic Of IR f f
283 Iceland IS f f
284 Italy IT f f
285 Jersey JE f f
286 Jamaica JM f f
287 Jordan JO f f
288 Japan JP f f
289 Kenya KE f f
290 Kyrgyzstan KG f f
291 Cambodia KH f f
292 Kiribati KI f f
293 Comoros KM f f
294 Saint Kitts And Nevis KN f f
295 Korea, Democratic People's Republic Of KP f f
296 Korea, Republic of KR f f
297 Kuwait KW f f
298 Cayman Islands KY f f
299 Kazakhstan KZ f f
300 Lao People's Democratic Republic LA f f
301 Lebanon LB f f
302 Saint Lucia LC f f
303 Liechtenstein LI f f
304 Sri Lanka LK f f
305 Liberia LR f f
306 Lesotho LS f f
307 Lithuania LT f f
308 Luxembourg LU f f
309 Latvia LV f f
310 Libyan Arab Jamahiriya LY f f
311 Morocco MA f f
312 Monaco MC f f
313 Moldova, Republic of MD f f
314 Montenegro ME f f
315 Saint Martin MF f f
316 Madagascar MG f f
317 Marshall Islands MH f f
318 Macedonia, the Former Yugoslav Republic Of MK f f
319 Mali ML f f
320 Myanmar MM f f
321 Mongolia MN f f
322 Macao MO f f
323 Northern Mariana Islands MP f f
324 Martinique MQ f f
325 Mauritania MR f f
326 Montserrat MS f f
327 Malta MT f f
328 Mauritius MU f f
329 Maldives MV f f
330 Malawi MW f f
280 British Indian Ocean Territory IO f t
331 Mexico MX f f
332 Malaysia MY f f
333 Mozambique MZ f f
334 Namibia NA f f
335 New Caledonia NC f f
336 Niger NE f f
337 Norfolk Island NF f f
338 Nigeria NG f f
339 Nicaragua NI f f
340 Netherlands NL f f
341 Norway NO f f
342 Nepal NP f f
343 Nauru NR f f
344 Niue NU f f
345 New Zealand NZ f f
346 Oman OM f f
347 Panama PA f f
348 Peru PE f f
349 French Polynesia PF f f
350 Papua New Guinea PG f f
351 Philippines PH f f
352 Pakistan PK f f
353 Poland PL f f
354 Saint Pierre And Miquelon PM f f
355 Pitcairn PN f f
356 Puerto Rico PR f f
357 Palestinian Territory, Occupied PS f f
358 Portugal PT f f
359 Palau PW f f
360 Paraguay PY f f
361 Qatar QA f f
362 Réunion RE f f
363 Romania RO f f
364 Serbia RS f f
365 Russian Federation RU f f
366 Rwanda RW f f
367 Saudi Arabia SA f f
368 Solomon Islands SB f f
369 Seychelles SC f f
370 Sudan SD f f
371 Sweden SE f f
372 Singapore SG f f
373 Saint Helena SH f f
374 Slovenia SI f f
375 Svalbard And Jan Mayen SJ f f
376 Slovakia SK f f
377 Sierra Leone SL f f
378 San Marino SM f f
379 Senegal SN f f
380 Somalia SO f f
381 Suriname SR f f
382 Sao Tome and Principe ST f f
383 El Salvador SV f f
384 Syrian Arab Republic SY f f
385 Swaziland SZ f f
386 Turks and Caicos Islands TC f f
387 Chad TD f f
388 French Southern Territories TF f f
389 Togo TG f f
390 Thailand TH f f
391 Tajikistan TJ f f
392 Tokelau TK f f
393 Timor-Leste TL f f
394 Turkmenistan TM f f
395 Tunisia TN f f
396 Tonga TO f f
397 Turkey TR f f
398 Trinidad and Tobago TT f f
399 Tuvalu TV f f
400 Taiwan, Province Of China TW f f
401 Tanzania, United Republic of TZ f f
402 Ukraine UA f f
403 Uganda UG f f
404 United States Minor Outlying Islands UM f f
406 Uruguay UY f f
407 Uzbekistan UZ f f
408 Holy See (Vatican City State) VA f f
409 Saint Vincent And The Grenedines VC f f
410 Venezuela, Bolivarian Republic of VE f f
411 Virgin Islands, British VG f f
412 Virgin Islands, U.S. VI f f
413 Viet Nam VN f f
414 Vanuatu VU f f
415 Wallis and Futuna WF f f
416 Samoa WS f f
417 Yemen YE f f
418 Mayotte YT f f
419 South Africa ZA f f
420 Zambia ZM f f
421 Zimbabwe ZW f f
405 United States US t t
213 Canada CA t t
\.
--
-- Name: piggybak_countries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_countries_id_seq', 421, true);
--
-- Data for Name: piggybak_coupons_coupon_applications; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_coupons_coupon_applications (id, line_item_id, coupon_id) FROM stdin;
\.
--
-- Name: piggybak_coupons_coupon_applications_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_coupons_coupon_applications_id_seq', 1, false);
--
-- Data for Name: piggybak_coupons_coupons; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_coupons_coupons (id, code, amount, discount_type, min_cart_total, expiration_date, allowed_applications) FROM stdin;
1 APOXPQAWHDRC 10.00 % 20.00 2020-12-31 10
2 DAZWDHBPYTMP 0.00 ship 0.00 2020-12-31 10
3 DWMIFNRBKTOZ 10.00 $ 10.00 2020-12-31 10
4 RRRXPQAWHDRC 5.00 % 20.00 2001-12-31 1
5 TTTXPQAWHDRC 10.00 % 20.00 2020-12-31 1
\.
--
-- Name: piggybak_coupons_coupons_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_coupons_coupons_id_seq', 3, true);
--
-- Data for Name: piggybak_giftcerts_buyable_giftcerts; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_giftcerts_buyable_giftcerts (id) FROM stdin;
1
\.
--
-- Name: piggybak_giftcerts_buyable_giftcerts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_giftcerts_buyable_giftcerts_id_seq', 1, true);
--
-- Data for Name: piggybak_giftcerts_giftcert_applications; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_giftcerts_giftcert_applications (id, line_item_id, giftcert_id, created_at, updated_at) FROM stdin;
\.
--
-- Name: piggybak_giftcerts_giftcert_applications_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_giftcerts_giftcert_applications_id_seq', 1, false);
--
-- Data for Name: piggybak_giftcerts_giftcerts; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_giftcerts_giftcerts (id, code, amount, expiration_date, order_id, created_at, updated_at) FROM stdin;
1 XDELRGQFPNMN 100.0 2013-12-31 \N 2012-11-05 16:05:14.825879 2012-11-05 16:05:14.825879
2 IEQGABUEKJGQ 10.0 2013-12-31 \N 2012-11-05 16:05:27.603879 2012-11-05 16:05:27.603879
\.
--
-- Name: piggybak_giftcerts_giftcerts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_giftcerts_giftcerts_id_seq', 2, true);
--
-- Data for Name: piggybak_line_items; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_line_items (id, order_id, quantity, sellable_id, price, unit_price, description, line_item_type, created_at, updated_at) FROM stdin;
19 16 1 15 19.00 0.00 sellable \N \N
20 17 1 15 19.00 0.00 sellable \N \N
21 16 1 \N 10.00 0.00 Shipping shipment 2012-10-17 15:39:00.951104 2012-10-17 15:39:01.082012
22 17 1 \N 20.00 0.00 Shipping shipment 2012-10-17 15:39:01.084616 2012-10-17 15:39:01.089901
23 16 1 \N -29.00 0.00 Payment payment 2012-10-17 15:39:01.106489 2012-10-17 15:39:01.114213
24 17 1 \N -39.00 0.00 Payment payment 2012-10-17 15:39:01.11578 2012-10-17 15:39:01.121287
25 18 1 \N 0.00 0.00 Pickup (NC Only) shipment 2014-03-31 22:01:33.236848 2014-03-31 22:01:33.330298
26 18 1 \N -21.33 0.00 Payment payment 2014-03-31 22:01:33.238374 2014-03-31 22:01:33.334117
27 18 1 29 19.99 19.99 4"x6" Print of Pollination sellable 2014-03-31 22:01:33.263438 2014-03-31 22:01:33.337153
28 18 1 \N 1.34 0.00 Tax Charge tax 2014-03-31 22:01:33.320896 2014-03-31 22:01:33.338367
\.
--
-- Name: piggybak_line_items_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_line_items_id_seq', 28, true);
--
-- Data for Name: piggybak_order_notes; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_order_notes (id, order_id, user_id, note, created_at, updated_at) FROM stdin;
1 18 0 LineItem #25 added:<br />quantity: 1<br />price: $0.00<br />description: Pickup (NC Only)<br /><br />LineItem #26 added:<br />quantity: 1<br />price: $-21.33<br />description: Payment<br /><br />LineItem #27 added:<br />quantity: 1<br />price: $19.99<br />description: 4"x6" Print of Pollination<br /><br />LineItem #28 added:<br />quantity: 1<br />price: $1.34<br />description: Tax Charge<br /> 2014-03-31 22:01:33.351786 2014-03-31 22:01:33.351786
\.
--
-- Name: piggybak_order_notes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_order_notes_id_seq', 1, true);
--
-- Data for Name: piggybak_orders; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_orders (id, billing_address_id, shipping_address_id, user_id, email, phone, total, total_due, status, created_at, updated_at, ip_address, user_agent, to_be_cancelled, confirmation_sent) FROM stdin;
16 41 42 10 test@endpoint.com 6304844834 29.00 0.00 new 2012-01-10 16:16:12.691295 2012-01-10 16:16:13.081443 174.111.11.143 \N f f
17 43 44 \N steph@endpoint.com 6304844834 39.00 0.00 new 2012-01-10 16:19:25.541916 2012-01-10 16:19:25.745341 174.111.11.143 \N f f
18 45 46 10 test@endpoint.com 6304844834 21.33 0.00 new 2014-03-31 22:01:33.238556 2014-03-31 22:01:33.32807 75.183.100.168 Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:28.0) Gecko/20100101 Firefox/28.0 f t
\.
--
-- Name: piggybak_orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_orders_id_seq', 18, true);
--
-- Data for Name: piggybak_payment_method_values; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_payment_method_values (id, payment_method_id, key, value) FROM stdin;
\.
--
-- Name: piggybak_payment_method_values_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_payment_method_values_id_seq', 2, true);
--
-- Data for Name: piggybak_payment_methods; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_payment_methods (id, description, klass, active, created_at, updated_at) FROM stdin;
1 Fake Credit Card ::Piggybak::PaymentCalculator::Fake t 2012-01-03 21:47:03.052088 2012-01-05 21:04:27.193433
\.
--
-- Name: piggybak_payment_methods_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_payment_methods_id_seq', 2, true);
--
-- Data for Name: piggybak_payments; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_payments (id, payment_method_id, status, month, year, transaction_id, created_at, updated_at, masked_number, line_item_id) FROM stdin;
15 1 paid 1 2012 N/A 2012-01-10 16:16:13.121248 2012-10-17 15:39:01.112282 \N 23
16 1 paid 1 2012 N/A 2012-01-10 16:19:25.751568 2012-10-17 15:39:01.12037 \N 24
17 1 paid 1 2015 N/A 2014-03-31 22:01:33.335405 2014-03-31 22:01:33.335405 41**********1111 26
\.
--
-- Name: piggybak_payments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_payments_id_seq', 17, true);
--
-- Data for Name: piggybak_sellables; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_sellables (id, sku, description, price, quantity, item_id, item_type, active, unlimited_inventory) FROM stdin;
9 test-3 Print of Test #3 19.99 8 10 Image t f
7 1 Sample Product 19.99 8 8 Image t f
8 test-2 Print of Test #2 19.99 6 9 Image t f
12 havanese-smile 4"x6" Print of Havanese Smile 19.99 0 13 Image t t
13 puppy 4"x6" Print of Tired Puppy 19.99 20 14 Image t f
14 beach-dog 4"x6" Print of Beach Dog 19.99 20 15 Image t f
10 fall-leaves 4"x6" Print of Fall Leaves 19.99 100 11 Image t t
19 Green Bokeh 4"x6" Print of Green Bokeh 9.99 100 20 Image t f
20 car-window 4"x6" Print of Car Window 24.99 10 21 Image t f
21 dog-lookout 4"x6" Print of Dog Lookout 19.99 7 22 Image t t
22 spider 4"x6" Print of Spider 19.99 100 23 Image t f
24 puppy-pals 4"x6" Print of Puppy Pals 19.99 100 25 Image t f
25 slug 4"x6" Print of Slug 19.99 100 26 Image t t
26 happy-beagle 4"x6" Print of Happy Beagle 19.99 100 27 Image t t
27 puppy-pile 4"x6" Print of Puppy Pile 39.99 20 28 Image t t
28 purple-flowers 4"x6" Print of Purple Flowers 19.99 100 29 Image t t
30 polination-2 4"x6" Print of Pollination #2 19.99 100 31 Image t t
31 beach-dog-2 4"x6" Print of Beach Dog #2 19.99 100 32 Image t t
32 spiderweb 4"x6" Print of Spiderweb 24.99 100 33 Image t t
33 tug-of-war 4"x6" Print of Tug Of War 24.99 100 34 Image t f
34 nature-2 4"x6" Print of Nature #2 24.99 100 35 Image t t
35 nature-3 4"x6" Print of Nature #3 24.99 100 36 Image t t
36 floor-dog 4"x6" Print of Floor Dog 24.99 100 37 Image t t
37 nature-4 4"x6" Print of Nature #4 24.99 100 38 Image t t
38 make-a-wish 4"x6" Print of Make a Wish 24.99 100 39 Image t t
39 best-friends 4"x6" Print of Best Friends 24.99 100 40 Image t t
41 fall-colors 4"x6" Print of Fall Colors 24.99 100 42 Image t t
42 spider-2 4"x6" Print of Spider #2 24.99 100 43 Image f f
43 japanese-maple 4"x6" Print of Japanese Maple 24.99 100 44 Image f f
16 murky-reflection 4"x6" Print of Murky Reflection 19.99 98 17 Image t t
23 spider-duo 4"x6" Print of Spider Duo 19.99 99 24 Image t t
40 street-cat 4"x6" Print of Street Cat 24.99 7 41 Image t t
17 butterfly 4"x6" Print of Butterfly 30.00 94 18 Image t t
18 backlit-fall-leaves 4"x6" Print of Backlit Fall Leaves 19.99 999 19 Image t f
29 pollination 4"x6" Print of Pollination 19.99 99 30 Image t t
44 relaxing-puppy 4"x6" Print of Relaxing Puppy 24.99 3 45 Image t f
11 dog-sunglasses 4"x6" Print of Dog in Sunglasses 19.99 3 12 Image t t
15 nature 4"x6" Print of Nature 19.00 98 16 Image t t
45 giftcert-10 $10 Gift Certificate 10.00 0 1 PiggybakVariants::Variant t t
46 giftcert-20 $20 Gift Certificate 20.00 0 2 PiggybakVariants::Variant t t
47 giftcert-40 $40 Gift Certificate 40.00 0 3 PiggybakVariants::Variant t t
48 10-cherry 10" x 20" Cherry Frame 24.99 0 4 PiggybakVariants::Variant t t
49 10-iron 10" x 20" Iron Frame 24.99 0 5 PiggybakVariants::Variant t t
50 10-black 10" x 20" Black Frame 19.99 0 6 PiggybakVariants::Variant t t
51 10-bronze 10" x 20" Bronze Frame 29.99 0 7 PiggybakVariants::Variant t t
52 20-cherry 20" x 40" Cherry Frame 39.99 0 8 PiggybakVariants::Variant t t
53 20-iron 20" x 40" Iron Frame 39.99 0 9 PiggybakVariants::Variant t t
54 20-black 20" x 40" Black Frame 34.99 0 10 PiggybakVariants::Variant t t
55 20-bronze 20" x 40" Bronze Frame 44.99 0 11 PiggybakVariants::Variant t f
\.
--
-- Name: piggybak_sellables_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_sellables_id_seq', 55, true);
--
-- Data for Name: piggybak_shipments; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_shipments (id, shipping_method_id, status, created_at, updated_at, line_item_id) FROM stdin;
15 4 new 2012-01-10 16:16:13.12503 2012-10-17 15:39:01.079716 21
16 5 new 2012-01-10 16:19:25.753415 2012-10-17 15:39:01.089099 22
17 6 new 2014-03-31 22:01:33.332445 2014-03-31 22:01:33.332445 25
\.
--
-- Name: piggybak_shipments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_shipments_id_seq', 17, true);
--
-- Data for Name: piggybak_shipping_method_values; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_shipping_method_values (id, shipping_method_id, key, value) FROM stdin;
4 4 rate 10.00
5 5 rate 20.00
7 6 rate 0.00
6 6 state_id 6907
\.
--
-- Name: piggybak_shipping_method_values_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_shipping_method_values_id_seq', 7, true);
--
-- Data for Name: piggybak_shipping_methods; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_shipping_methods (id, description, klass, active) FROM stdin;
6 Pickup (NC Only) Pickup t
4 Standard Shipping ::Piggybak::ShippingCalculator::FlatRate t
5 Express Shipping ::Piggybak::ShippingCalculator::FlatRate t
\.
--
-- Name: piggybak_shipping_methods_id_seq; Type: SEQUENCE SET; Schema: public; Owner: piggybak
--
SELECT pg_catalog.setval('piggybak_shipping_methods_id_seq', 6, true);
--
-- Data for Name: piggybak_states; Type: TABLE DATA; Schema: public; Owner: piggybak
--
COPY piggybak_states (id, abbr, name, country_id) FROM stdin;
2871 02 Canillo 176
2872 03 Encamp 176
2873 04 La Massana 176
2874 05 Ordino 176
2875 06 Sant Julià de Lòria 176
2876 07 Andorra la Vella 176
2877 08 Escaldes-Engordany 176
2878 AJ 'Ajman 177
2879 AZ Abu Z¸aby [Abu Dhabi] 177
2880 DU Dubayy [Dubai] 177
2881 FU Al Fujayrah 177
2882 RK Ra’s al Khaymah 177
2883 SH Ash Shariqah [Sharjah] 177
2884 UQ Umm al Qaywayn 177
2885 BAL Balkh 178
2886 BAM Bamian 178
2887 BDG Badghis 178
2888 BDS Badakhshan 178
2889 BGL Baghlan 178
2890 DAY Daykondi 178
2891 FRA Farah 178
2892 FYB Faryab 178
2893 GHA Ghazni 178
2894 GHO Ghowr 178
2895 HEL Helmand 178
2896 HER Herat 178
2897 JOW Jowzjan 178
2898 KAB Kabul [Kabol] 178
2899 KAN Kandahar 178
2900 KAP Kapisa 178
2901 KDZ Kondoz [Kunduz] 178
2902 KHO Khowst 178
2903 KNR Konar [Kunar] 178
2904 LAG Laghman 178
2905 LOW Lowgar 178
2906 NAN Nangrahar [Nangarhar] 178
2907 NIM Nimruz 178
2908 NUR Nurestan 178
2909 ORU Oruzgan [Uruzgan] 178
2910 PAN Panjshir 178
2911 PAR Parwan 178
2912 PIA Paktia 178
2913 PKA Paktika 178
2914 SAM Samangan 178
2915 SAR Sar-e Pol 178
2916 TAK Takhar 178
2917 WAR Wardak [Wardag] 178
2918 ZAB Zabol [Zabul] 178
2919 03 Saint George 179
2920 04 Saint John’s 179
2921 05 Saint Mary 179
2922 06 Saint Paul 179
2923 07 Saint Peter 179
2924 08 Saint Philip 179
2925 10 Barbuda 179
2926 X2~ Redonda 179
2927 BR Berat 181
2928 BU Bulqizë 181
2929 DI Dibër 181
2930 DL Delvinë 181
2931 DR Durrës 181
2932 DV Devoll 181
2933 EL Elbasan 181
2934 ER Kolonjë 181
2935 FR Fier 181
2936 GJ Gjirokastër 181
2937 GR Gramsh 181
2938 HA Has 181
2939 KA Kavajë 181
2940 KB Kurbin 181
2941 KC Kuçovë 181
2942 KO Korçë 181
2943 KR Krujë 181
2944 KU Kukës 181
2945 LB Librazhd 181
2946 LE Lezhë 181
2947 LU Lushnjë 181
2948 MK Mallakastër 181
2949 MM Malësi e Madhe 181
2950 MR Mirditë 181
2951 MT Mat 181
2952 PG Pogradec 181
2953 PQ Peqin 181
2954 PR Përmet 181
2955 PU Pukë 181
2956 SH Shkodër 181
2957 SK Skrapar 181
2958 SR Sarandë 181
2959 TE Tepelenë 181
2960 TP Tropojë 181
2961 TR Tiranë 181
2962 VL Vlorë 181
2963 AG Aragac?otn 182
2964 AR Ararat 182
2965 AV Armavir 182
2966 ER Erevan 182
2967 GR Gegark'unik' 182
2968 KT Kotayk' 182
2969 LO Lo?y 182
2970 SH Širak 182
2971 SU Syunik' 182
2972 TV Tavuš 182
2973 VD Vayoc Jor 182
2974 BGO Bengo 184
2975 BGU Benguela 184
2976 BIE Bié 184
2977 CAB Cabinda 184
2978 CCU Cuando-Cubango 184
2979 CNN Cunene 184
2980 CNO Cuanza Norte 184
2981 CUS Cuanza Sul 184
2982 HUA Huambo 184
2983 HUI Huíla 184
2984 LNO Lunda Norte 184
2985 LSU Lunda Sul 184
2986 LUA Luanda 184
2987 MAL Malange 184
2988 MOX Moxico 184
2989 NAM Namibe 184
2990 UIG Uíge 184
2991 ZAI Zaire 184
2992 A Salta 186
2993 B Buenos Aires 186
2994 C Capital federal 186
2995 D San Luis 186
2996 E Entre Ríos 186
2997 F La Rioja 186
2998 G Santiago del Estero 186
2999 H Chaco 186
3000 J San Juan 186
3001 K Catamarca 186
3002 L La Pampa 186
3003 M Mendoza 186
3004 N Misiones 186
3005 P Formosa 186
3006 Q Neuquén 186
3007 R Río Negro 186
3008 S Santa Fe 186
3009 T Tucumán 186
3010 U Chubut 186
3011 V Tierra del Fuego 186
3012 W Corrientes 186
3013 X Córdoba 186
3014 Y Jujuy 186
3015 Z Santa Cruz 186
3016 1 Burgenland 188
3017 2 Kärnten 188
3018 3 Niederösterreich 188
3019 4 Oberösterreich 188
3020 5 Salzburg 188
3021 6 Steiermark 188
3022 7 Tirol 188
3023 8 Vorarlberg 188
3024 9 Wien 188
3025 ACT Australian Capital Territory 189
3026 NSW New South Wales 189
3027 NT Northern Territory 189
3028 QLD Queensland 189
3029 SA South Australia 189
3030 TAS Tasmania 189
3031 VIC Victoria 189
3032 WA Western Australia 189
3033 AB Äli Bayramli 192
3034 ABS Abseron 192
3035 AGA Agstafa 192
3036 AGC Agcabädi 192
3037 AGM Agdam 192
3038 AGS Agdas 192
3039 AGU Agsu 192
3040 AST Astara 192
3041 BA Baki 192
3042 BAB Babäk 192
3043 BAL Balakän 192
3044 BAR Bärdä 192
3045 BEY Beyläqan 192
3046 BIL Biläsuvar 192
3047 CAB Cäbrayil 192
3048 CAL Cälilabab 192
3049 CUL Culfa 192
3050 DAS Daskäsän 192
3051 DAV Däväçi 192
3052 FUZ Füzuli 192
3053 GA Gäncä 192
3054 GAD Gädäbäy 192
3055 GOR Goranboy 192
3056 GOY Göyçay 192
3057 HAC Haciqabul 192
3058 IMI Imisli 192
3059 ISM Ismayilli 192
3060 KAL Kälbäcär 192
3061 KUR Kürdämir 192
3062 LA Länkäran City 192
3063 LAC Laçin 192
3064 LAN Länkäran 192
3065 LER Lerik 192
3066 MAS Masalli 192
3067 MI Mingäçevir 192
3068 NA Naftalan 192
3069 NEF Neftçala 192
3070 NX Naxçivan 192
3071 OGU Oguz 192
3072 ORD Ordubad 192
3073 QAB Qäbälä 192
3074 QAX Qax 192
3075 QAZ Qazax 192
3076 QBA Quba 192
3077 QBI Qubadli 192
3078 QOB Qobustan 192
3079 QUS Qusar 192
3080 SA Säki City 192
3081 SAB Sabirabad 192
3082 SAD Sädäräk 192
3083 SAH Sahbuz 192
3084 SAK Säki 192
3085 SAL Salyan 192
3086 SAR Särur 192
3087 SAT Saatli 192
3088 SIY Siyäzän 192
3089 SKR Sämkir 192
3090 SM Sumqayit 192
3091 SMI Samaxi 192
3092 SMX Samux 192
3093 SS Susa City 192
3094 SUS Susa 192
3095 TAR Tärtär 192
3096 TOV Tovuz 192
3097 UCA Ucar 192
3098 XA Xankändi 192
3099 XAC Xaçmaz 192
3100 XAN Xanlar 192
3101 XCI Xocali 192
3102 XIZ Xizi 192
3103 XVD Xocavänd 192
3104 YAR Yardimli 192
3105 YE Yevlax City 192
3106 YEV Yevlax 192
3107 ZAN Zängilan 192
3108 ZAQ Zaqatala 192
3109 ZAR Zärdab 192
3110 BIH Federacija Bosna i Hercegovina 193
3111 SRP Republika Srpska 193
3112 01 Christ Church 194
3113 02 Saint Andrew 194
3114 03 Saint George 194
3115 04 Saint James 194
3116 05 Saint John 194
3117 06 Saint Joseph 194
3118 07 Saint Lucy 194
3119 08 Saint Michael 194
3120 09 Saint Peter 194
3121 10 Saint Philip 194
3122 11 Saint Thomas 194
3123 01 Bandarban zila 195
3124 02 Barguna zila 195
3125 03 Bogra zila 195
3126 04 Brahmanbaria zila 195
3127 05 Bagerhat zila 195
3128 06 Barisal zila 195
3129 07 Bhola zila 195
3130 08 Comilla zila 195
3131 09 Chandpur zila 195
3132 10 Chittagong zila 195
3133 11 Cox's Bazar zila 195
3134 12 Chuadanga zila 195
3135 13 Dhaka zila 195
3136 14 Dinajpur zila 195
3137 15 Faridpur zila 195
3138 16 Feni zila 195
3139 17 Gopalganj zila 195
3140 18 Gazipur zila 195
3141 19 Gaibandha zila 195
3142 20 Habiganj zila 195
3143 21 Jamalpur zila 195
3144 22 Jessore zila 195
3145 23 Jhenaidah zila 195
3146 24 Jaipurhat zila 195
3147 25 Jhalakati zila 195
3148 26 Kishoreganj zila 195
3149 27 Khulna zila 195
3150 28 Kurigram zila 195
3151 29 Khagrachari zila 195
3152 30 Kushtia zila 195
3153 31 Lakshmipur zila 195
3154 32 Lalmonirhat zila 195
3155 33 Manikganj zila 195
3156 34 Mymensingh zila 195
3157 35 Munshiganj zila 195
3158 36 Madaripur zila 195
3159 37 Magura zila 195
3160 38 Moulvibazar zila 195
3161 39 Meherpur zila 195
3162 40 Narayanganj zila 195
3163 41 Netrakona zila 195
3164 42 Narsingdi zila 195
3165 43 Narail zila 195
3166 44 Natore zila 195
3167 45 Nawabganj zila 195
3168 46 Nilphamari zila 195
3169 47 Noakhali zila 195
3170 48 Naogaon zila 195
3171 49 Pabna zila 195
3172 50 Pirojpur zila 195
3173 51 Patuakhali zila 195
3174 52 Panchagarh zila 195
3175 53 Rajbari zila 195
3176 54 Rajshahi zila 195
3177 55 Rangpur zila 195
3178 56 Rangamati zila 195
3179 57 Sherpur zila 195
3180 58 Satkhira zila 195
3181 59 Sirajganj zila 195
3182 60 Sylhet zila 195
3183 61 Sunamganj zila 195
3184 62 Shariatpur zila 195
3185 63 Tangail zila 195
3186 64 Thakurgaon zila 195
3187 BRU Brussels 196
3188 VAN Antwerpen (nl) 196
3189 VBR Vlaams Brabant (nl) 196
3190 VLI Limburg (nl) 196
3191 VOV Oost-Vlaanderen (nl) 196
3192 VWV West-Vlaanderen (nl) 196
3193 WBR Brabant Wallon (fr) 196
3194 WHT Hainaut (fr) 196
3195 WLG Liège (fr) 196
3196 WLX Luxembourg (fr) 196
3197 WNA Namur (fr) 196
3198 BAL Balé 197
3199 BAM Bam 197
3200 BAN Banwa 197
3201 BAZ Bazèga 197
3202 BGR Bougouriba 197
3203 BLG Boulgou 197
3204 BLK Boulkiemdé 197
3205 COM Comoé 197
3206 GAN Ganzourgou 197
3207 GNA Gnagna 197
3208 GOU Gourma 197
3209 HOU Houet 197
3210 IOB Ioba 197
3211 KAD Kadiogo 197
3212 KEN Kénédougou 197
3213 KMD Komondjari 197
3214 KMP Kompienga 197
3215 KOP Koulpélogo 197
3216 KOS Kossi 197
3217 KOT Kouritenga 197
3218 KOW Kourwéogo 197
3219 LER Léraba 197
3220 LOR Loroum 197
3221 MOU Mouhoun 197
3222 NAM Namentenga 197
3223 NAO Nahouri 197
3224 NAY Nayala 197
3225 NOU Noumbiel 197
3226 OUB Oubritenga 197
3227 OUD Oudalan 197
3228 PAS Passoré 197
3229 PON Poni 197
3230 SEN Séno 197
3231 SIS Sissili 197
3232 SMT Sanmatenga 197
3233 SNG Sanguié 197
3234 SOM Soum 197
3235 SOR Sourou 197
3236 TAP Tapoa 197
3237 TUI Tui 197
3238 YAG Yagha 197
3239 YAT Yatenga 197
3240 ZIR Ziro 197
3241 ZON Zondoma 197
3242 ZOU Zoundwéogo 197
3243 01 Blagoevgrad 198
3244 02 Burgas 198
3245 03 Varna 198
3246 04 Veliko Tarnovo 198
3247 05 Vidin 198
3248 06 Vratsa 198
3249 07 Gabrovo 198
3250 08 Dobrich 198
3251 09 Kardzhali 198
3252 10 Kjustendil 198
3253 11 Lovech 198
3254 12 Montana 198
3255 13 Pazardzhik 198
3256 14 Pernik 198
3257 15 Pleven 198
3258 16 Plovdiv 198
3259 17 Razgrad 198
3260 18 Ruse 198
3261 19 Silistra 198
3262 20 Sliven 198
3263 21 Smolyan 198
3264 22 Sofia-Grad 198
3265 23 Sofia 198
3266 24 Stara Zagora 198
3267 25 Targovishte 198
3268 26 Haskovo 198
3269 27 Šumen 198
3270 28 Yambol 198
3271 13 Al Manamah (Al ‘Asimah) 199
3272 14 Al Janubiyah 199
3273 15 Al Muharraq 199
3274 16 Al Wustá 199
3275 17 Ash Shamaliyah 199
3276 BB Bubanza 200
3277 BJ Bujumbura 200
3278 BR Bururi 200
3279 CA Cankuzo 200
3280 CI Cibitoke 200
3281 GI Gitega 200
3282 KI Kirundo 200
3283 KR Karuzi 200
3284 KY Kayanza 200
3285 MA Makamba 200
3286 MU Muramvya 200
3287 MW Mwaro 200
3288 MY Muyinga 200
3289 NG Ngozi 200
3290 RT Rutana 200
3291 RY Ruyigi 200
3292 AK Atakora 201
3293 AL Alibori 201
3294 AQ Atlantique 201
3295 BO Borgou 201
3296 CO Collines 201
3297 DO Donga 201
3298 KO Kouffo 201
3299 LI Littoral 201
3300 MO Mono 201
3301 OU Ouémé 201
3302 PL Plateau 201
3303 ZO Zou 201
3304 BE Belait 204
3305 BM Brunei-Muara 204
3306 TE Temburong 204
3307 TU Tutong 204
3308 B El Beni 205
3309 C Cochabamba 205
3310 H Chuquisaca 205
3311 L La Paz 205
3312 N Pando 205
3313 O Oruro 205
3314 P Potosí 205
3315 S Santa Cruz 205
3316 T Tarija 205
3317 AC Acre 206
3318 AL Alagoas 206
3319 AM Amazonas 206
3320 AP Amapá 206
3321 BA Bahia 206
3322 CE Ceará 206
3323 DF Distrito Federal 206
3324 ES Espírito Santo 206
3325 GO Goiás 206
3326 MA Maranhão 206
3327 MG Minas Gerais 206
3328 MS Mato Grosso do Sul 206
3329 MT Mato Grosso 206
3330 PA Pará 206
3331 PB Paraíba 206
3332 PE Pernambuco 206
3333 PI Piauí 206
3334 PR Paraná 206
3335 RJ Rio de Janeiro 206
3336 RN Rio Grande do Norte 206
3337 RO Rondônia 206
3338 RR Roraima 206
3339 RS Rio Grande do Sul 206
3340 SC Santa Catarina 206
3341 SE Sergipe 206
3342 SP São Paulo 206
3343 TO Tocantins 206
3344 AC Acklins and Crooked Islands 207
3345 BI Bimini 207
3346 CI Cat Island 207
3347 EX Exuma 207
3348 FC Fresh Creek 207
3349 FP Freeport 207
3350 GH Governor's Harbour 207
3351 GT Green Turtle Cay 207
3352 HI Harbour Island 207
3353 HR High Rock 207
3354 IN Inagua 207
3355 KB Kemps Bay 207
3356 LI Long Island 207
3357 MG Mayaguana 207
3358 MH Marsh Harbour 207
3359 NB Nicholls Town and Berry Islands 207
3360 NP New Providence 207
3361 RI Ragged Island 207
3362 RS Rock Sound 207
3363 SP Sandy Point 207
3364 SR San Salvador and Rum Cay 207
3365 11 Paro 208
3366 12 Chhukha 208
3367 13 Ha 208
3368 14 Samtse 208
3369 15 Thimphu 208
3370 21 Tsirang 208
3371 22 Dagana 208
3372 23 Punakha 208
3373 24 Wangdue Phodrang 208
3374 31 Sarpang 208
3375 32 Trongsa 208
3376 33 Bumthang 208
3377 34 Zhemgang 208
3378 41 Trashigang 208
3379 42 Monggar 208
3380 43 Pemagatshel 208
3381 44 Lhuentse 208
3382 45 Samdrup Jongkha 208
3383 GA Gasa 208
3384 TY Trashi Yangtse 208
3385 CE Central 210
3386 GH Ghanzi 210
3387 KG Kgalagadi 210
3388 KL Kgatleng 210
3389 KW Kweneng 210
3390 NE North-East 210
3391 NW North-West 210
3392 SE South-East 210
3393 SO Southern 210
3394 BR Brestskaya voblasts' (be) Brestskaya oblast' (ru) 211
3395 HO Homyel'skaya voblasts' (be) Gomel'skaya oblast' (ru) 211
3396 HR Hrodzenskaya voblasts' (be) Grodnenskaya oblast' (ru) 211
3397 MA Mahilyowskaya voblasts' (be) Mogilevskaya oblast' (ru) 211
3398 MI Minskaya voblasts' (be) Minskaya oblast' (ru) 211
3399 VI Vitsyebskaya voblasts' (be) Vitebskaya oblast' (ru) 211
3400 X1~ Horad Minsk 211
3401 BZ Belize 212
3402 CY Cayo 212
3403 CZL Corozal 212
3404 OW Orange Walk 212
3405 SC Stann Creek 212
3406 TOL Toledo 212
3407 AB Alberta 213
3408 BC British Columbia 213
3409 MB Manitoba 213
3410 NB New Brunswick 213
3411 NL Newfoundland and Labrador 213
3412 NS Nova Scotia 213
3413 NT Northwest Territories 213
3414 NU Nunavut 213
3415 ON Ontario 213
3416 PE Prince Edward Island 213
3417 QC Quebec 213
3418 SK Saskatchewan 213
3419 YT Yukon Territory 213
3420 BC Bas-Congo 215
3421 BN Bandundu 215
3422 EQ Équateur 215
3423 KA Katanga 215
3424 KE Kasai-Oriental 215
3425 KN Kinshasa 215
3426 KW Kasai-Occidental 215
3427 MA Maniema 215
3428 NK Nord-Kivu 215
3429 OR Orientale 215
3430 SK Sud-Kivu 215
3431 AC Ouham 216
3432 BB Bamingui-Bangoran 216
3433 BGF Bangui 216
3434 BK Basse-Kotto 216
3435 HK Haute-Kotto 216
3436 HM Haut-Mbomou 216
3437 HS Mambéré-Kadéï 216
3438 KB Nana-Grébizi 216
3439 KG Kémo 216
3440 LB Lobaye 216
3441 MB Mbomou 216
3442 MP Ombella-Mpoko 216
3443 NM Nana-Mambéré 216
3444 OP Ouham-Pendé 216
3445 SE Sangha-Mbaéré 216
3446 UK Ouaka 216
3447 VK Vakaga 216
3448 11 Bouenza 217
3449 12 Pool 217
3450 13 Sangha 217
3451 14 Plateaux 217
3452 15 Cuvette-Ouest 217
3453 2 Lékoumou 217
3454 5 Kouilou 217
3455 7 Likouala 217
3456 8 Cuvette 217
3457 9 Niari 217
3458 BZV Brazzaville 217
3459 AG Aargau (de) 218
3460 AI Appenzell Innerrhoden (de) 218
3461 AR Appenzell Ausserrhoden (de) 218
3462 BE Bern (de) 218
3463 BL Basel-Landschaft (de) 218
3464 BS Basel-Stadt (de) 218
3465 FR Fribourg (fr) 218
3466 GE Genève (fr) 218
3467 GL Glarus (de) 218
3468 GR Graubünden (de) 218
3469 JU Jura (fr) 218
3470 LU Luzern (de) 218
3471 NE Neuchâtel (fr) 218
3472 NW Nidwalden (de) 218
3473 OW Obwalden (de) 218
3474 SG Sankt Gallen (de) 218
3475 SH Schaffhausen (de) 218
3476 SO Solothurn (de) 218
3477 SZ Schwyz (de) 218
3478 TG Thurgau (de) 218
3479 TI Ticino (it) 218
3480 UR Uri (de) 218
3481 VD Vaud (fr) 218
3482 VS Valais (fr) 218
3483 ZG Zug (de) 218
3484 ZH Zürich (de) 218
3485 01 Lagunes (Région des) 219
3486 02 Haut-Sassandra (Région du) 219
3487 03 Savanes (Région des) 219
3488 04 Vallée du Bandama (Région de la) 219
3489 05 Moyen-Comoé (Région du) 219
3490 06 18 Montagnes (Région des) 219
3491 07 Lacs (Région des) 219
3492 08 Zanzan (Région du) 219
3493 09 Bas-Sassandra (Région du) 219
3494 10 Denguélé (Région du) 219
3495 11 Nzi-Comoé (Région) 219
3496 12 Marahoué (Région de la) 219
3497 13 Sud-Comoé (Région du) 219
3498 14 Worodougou (Région du) 219
3499 15 Sud-Bandama (Région du) 219
3500 16 Agnébi (Région de l') 219
3501 17 Bafing (Région du) 219
3502 18 Fromager (Région du) 219
3503 19 Moyen-Cavally (Région du) 219
3504 AI Aisén del General Carlos Ibáñez del Campo 221
3505 AN Antofagasta 221
3506 AR Araucanía 221
3507 AT Atacama 221
3508 BI Bío-Bío 221
3509 CO Coquimbo 221
3510 LI Libertador General Bernardo O'Higgins 221
3511 LL Los Lagos 221
3512 MA Magallanes 221
3513 ML Maule 221
3514 RM Región Metropolitana de Santiago 221
3515 TA Tarapacá 221
3516 VS Valparaíso 221
3517 AD Adamaoua 222
3518 CE Centre 222
3519 EN Far North 222
3520 ES East 222
3521 LT Littoral 222
3522 NO North 222
3523 NW North-West 222
3524 OU West 222
3525 SU South 222
3526 SW South-West 222
3527 11 Beijing 223
3528 12 Tianjin 223
3529 13 Hebei 223
3530 14 Shanxi 223
3531 15 Nei Mongol (mn) 223
3532 21 Liaoning 223
3533 22 Jilin 223
3534 23 Heilongjiang 223
3535 31 Shanghai 223
3536 32 Jiangsu 223
3537 33 Zhejiang 223
3538 34 Anhui 223
3539 35 Fujian 223
3540 36 Jiangxi 223
3541 37 Shandong 223
3542 41 Henan 223
3543 42 Hubei 223
3544 43 Hunan 223
3545 44 Guangdong 223
3546 45 Guangxi 223
3547 46 Hainan 223
3548 50 Chongqing 223
3549 51 Sichuan 223
3550 52 Guizhou 223
3551 53 Yunnan 223
3552 54 Xizang 223
3553 61 Shaanxi 223
3554 62 Gansu 223
3555 63 Qinghai 223
3556 64 Ningxia 223
3557 65 Xinjiang 223
3558 71 Taiwan * 223
3559 91 Xianggang (zh) ** 223
3560 92 Aomen (zh) *** 223
3561 AMA Amazonas 224
3562 ANT Antioquia 224
3563 ARA Arauca 224
3564 ATL Atlántico 224
3565 BOL Bolívar 224
3566 BOY Boyacá 224
3567 CAL Caldas 224
3568 CAQ Caquetá 224
3569 CAS Casanare 224
3570 CAU Cauca 224
3571 CES Cesar 224
3572 CHO Chocó 224
3573 COR Córdoba 224
3574 CUN Cundinamarca 224
3575 DC Distrito Capital de Bogotá 224
3576 GUA Guainía 224
3577 GUV Guaviare 224
3578 HUI Huila 224
3579 LAG La Guajira 224
3580 MAG Magdalena 224
3581 MET Meta 224
3582 NAR Nariño 224
3583 NSA Norte de Santander 224
3584 PUT Putumayo 224
3585 QUI Quindío 224
3586 RIS Risaralda 224
3587 SAN Santander 224
3588 SAP San Andrés, Providencia y Santa Catalina 224
3589 SUC Sucre 224
3590 TOL Tolima 224
3591 VAC Valle del Cauca 224
3592 VAU Vaupés 224
3593 VID Vichada 224
3594 A Alajuela 225
3595 C Cartago 225
3596 G Guanacaste 225
3597 H Heredia 225
3598 L Limón 225
3599 P Puntarenas 225
3600 SJ San José 225
3601 01 Pinar del Río 226
3602 02 La Habana 226
3603 03 Ciudad de La Habana 226
3604 04 Matanzas 226
3605 05 Villa Clara 226
3606 06 Cienfuegos 226
3607 07 Sancti Spíritus 226
3608 08 Ciego de Ávila 226
3609 09 Camagüey 226
3610 10 Las Tunas 226
3611 11 Holguín 226
3612 12 Granma 226
3613 13 Santiago de Cuba 226
3614 14 Guantánamo 226
3615 99 Isla de la Juventud 226
3616 BR Brava 227
3617 BV Boa Vista 227
3618 CA Santa Catarina 227
3619 CR Santa Cruz 227
3620 CS Calheta de São Miguel 227
3621 MA Maio 227
3622 MO Mosteiros 227
3623 PA Paúl 227
3624 PN Porto Novo 227
3625 PR Praia 227
3626 RG Ribeira Grande 227
3627 SD São Domingos 227
3628 SF São Filipe 227
3629 SL Sal 227
3630 SN São Nicolau 227
3631 SV São Vicente 227
3632 TA Tarrafal 227
3633 01 Lefkosia 229
3634 02 Lemesos 229
3635 03 Larnaka 229
3636 04 Ammochostos 229
3637 05 Pafos 229
3638 06 Keryneia 229
3639 JC Jihoceský kraj 230
3640 JM Jihomoravský kraj 230
3641 KA Karlovarský kraj 230
3642 KR Královéhradecký kraj 230
3643 LI Liberecký kraj 230
3644 MO Moravskoslezský kraj 230
3645 OL Olomoucký kraj 230
3646 PA Pardubický kraj 230
3647 PL Plzenský kraj 230
3648 PR Praha, hlavní mesto 230
3649 ST Stredoceský kraj 230
3650 US Ústecký kraj 230
3651 VY Vysocina 230
3652 ZL Zlínský kraj 230
3653 BB Brandenburg 231
3654 BE Berlin 231
3655 BW Baden-Württemberg 231
3656 BY Bayern 231
3657 HB Bremen 231
3658 HE Hessen 231
3659 HH Hamburg 231
3660 MV Mecklenburg-Vorpommern 231
3661 NI Niedersachsen 231
3662 NW Nordrhein-Westfalen 231
3663 RP Rheinland-Pfalz 231
3664 SH Schleswig-Holstein 231
3665 SL Saarland 231
3666 SN Sachsen 231
3667 ST Sachsen-Anhalt 231
3668 TH Thüringen 231
3669 AR Arta 232
3670 AS Ali Sabieh 232
3671 DI Dikhil 232
3672 DJ Djibouti 232
3673 OB Obock 232
3674 TA Tadjourah 232
3675 015 København 233
3676 020 Frederiksborg 233
3677 025 Roskilde 233
3678 030 Vestsjælland 233
3679 035 Storstrøm 233
3680 040 Bornholm 233
3681 042 Fyn 233
3682 050 Sønderjylland 233
3683 055 Ribe 233
3684 060 Vejle 233
3685 065 Ringkøbing 233
3686 070 Århus 233
3687 076 Viborg 233
3688 080 Nordjylland 233
3689 101 København City 233
3690 147 Frederiksberg City 233
3691 81 North Jutland 233
3692 82 Central Jutland 233
3693 83 South Denmark 233
3694 84 Capital 233
3695 85 Zeeland 233
3696 02 Saint Andrew 234
3697 03 Saint David 234
3698 04 Saint George 234
3699 05 Saint John 234
3700 06 Saint Joseph 234
3701 07 Saint Luke 234
3702 08 Saint Mark 234
3703 09 Saint Patrick 234
3704 10 Saint Paul 234
3705 11 Saint Peter 234
3706 01 Distrito Nacional (Santo Domingo) 235
3707 02 Azua 235
3708 03 Bahoruco 235
3709 04 Barahona 235
3710 05 Dajabón 235
3711 06 Duarte 235
3712 07 La Estrelleta [Elías Piña] 235
3713 08 El Seybo [El Seibo] 235
3714 09 Espaillat 235
3715 10 Independencia 235
3716 11 La Altagracia 235
3717 12 La Romana 235
3718 13 La Vega 235
3719 14 María Trinidad Sánchez 235
3720 15 Monte Cristi 235
3721 16 Pedernales 235
3722 17 Peravia 235
3723 18 Puerto Plata 235
3724 19 Salcedo 235
3725 20 Samaná 235
3726 21 San Cristóbal 235
3727 22 San Juan 235
3728 23 San Pedro de Macorís 235
3729 24 Sánchez Ramírez 235
3730 25 Santiago 235
3731 26 Santiago Rodríguez 235
3732 27 Valverde 235
3733 28 Monseñor Nouel 235
3734 29 Monte Plata 235
3735 30 Hato Mayor 235
3736 31 San Jose de Ocoa 235
3737 01 Adrar 236
3738 02 Chlef 236
3739 03 Laghouat 236
3740 04 Oum el Bouaghi 236
3741 05 Batna 236
3742 06 Béjaïa 236
3743 07 Biskra 236
3744 08 Béchar 236
3745 09 Blida 236
3746 10 Bouira 236
3747 11 Tamanghasset 236
3748 12 Tébessa 236
3749 13 Tlemcen 236
3750 14 Tiaret 236
3751 15 Tizi Ouzou 236
3752 16 Alger 236
3753 17 Djelfa 236
3754 18 Jijel 236
3755 19 Sétif 236
3756 20 Saïda 236
3757 21 Skikda 236
3758 22 Sidi Bel Abbès 236
3759 23 Annaba 236
3760 24 Guelma 236
3761 25 Constantine 236
3762 26 Médéa 236
3763 27 Mostaganem 236
3764 28 Msila 236
3765 29 Mascara 236
3766 30 Ouargla 236
3767 31 Oran 236
3768 32 El Bayadh 236
3769 33 Illizi 236
3770 34 Bordj Bou Arréridj 236
3771 35 Boumerdès 236
3772 36 El Tarf 236
3773 37 Tindouf 236
3774 38 Tissemsilt 236
3775 39 El Oued 236
3776 40 Khenchela 236
3777 41 Souk Ahras 236
3778 42 Tipaza 236
3779 43 Mila 236
3780 44 Aïn Defla 236
3781 45 Naama 236
3782 46 Aïn Témouchent 236
3783 47 Ghardaïa 236
3784 48 Relizane 236
3785 A Azuay 237
3786 B Bolívar 237
3787 C Carchi 237
3788 D Orellana 237
3789 E Esmeraldas 237
3790 F Cañar 237
3791 G Guayas 237
3792 H Chimborazo 237
3793 I Imbabura 237
3794 L Loja 237
3795 M Manabí 237
3796 N Napo 237
3797 O El Oro 237
3798 P Pichincha 237
3799 R Los Ríos 237
3800 S Morona-Santiago 237
3801 T Tungurahua 237
3802 U Sucumbíos 237
3803 W Galápagos 237
3804 X Cotopaxi 237
3805 X1~ Santa Elena 237
3806 X2~ Santo Domingo de los Tsachilas 237
3807 Y Pastaza 237
3808 Z Zamora-Chinchipe 237
3809 37 Harjumaa 238
3810 39 Hiiumaa 238
3811 44 Ida-Virumaa 238
3812 49 Jõgevamaa 238
3813 51 Järvamaa 238
3814 57 Läänemaa 238
3815 59 Lääne-Virumaa 238
3816 65 Põlvamaa 238
3817 67 Pärnumaa 238
3818 70 Raplamaa 238
3819 74 Saaremaa 238
3820 78 Tartumaa 238
3821 82 Valgamaa 238
3822 84 Viljandimaa 238
3823 86 Võrumaa 238
3824 ALX Al Iskandariyah 239
3825 ASN Aswan 239
3826 AST Asyut 239
3827 BA Al Bahr al Ahmar 239
3828 BH Al Buhayrah 239
3829 BNS Bani Suwayf 239
3830 C Al Qahirah 239
3831 DK Ad Daqahliyah 239
3832 DT Dumyat 239
3833 FYM Al Fayyum 239
3834 GH Al Gharbiyah 239
3835 GZ Al Jizah 239
3836 IS Al Ismā`īlīyah 239
3837 JS Janub Sina' 239
3838 KB Al Qalyubiyah 239
3839 KFS Kafr ash Shaykh 239
3840 KN Qina 239
3841 LX al-Uqsur 239
3842 MN Al Minya 239
3843 MNF Al Minufiyah 239
3844 MT Matrūh 239
3845 PTS Būr Sa`īd 239
3846 SHG Suhaj 239
3847 SHR Ash Sharqiyah 239
3848 SIN Shamal Sina' 239
3849 SUZ As Suways 239
3850 WAD Al Wadi al Jadid 239
3851 BOD Boujdour 240
3852 ESM Es Semara 240
3853 LAA Laayoune 240
3854 OUD Oued el Dahab 240
3855 AN Anseba 241
3856 DK Debubawi Keyih Bahri [Debub-Keih-Bahri] 241
3857 DU Debub 241
3858 GB Gash-Barka 241
3859 MA Maakel [Maekel] 241
3860 SK Semenawi Keyih Bahri [Semien-Keih-Bahri] 241
3861 A Alicante 242
3862 AB Albacete 242
3863 AL Almería 242
3864 AV Ávila 242
3865 B Barcelona 242
3866 BA Badajoz 242
3867 BI Vizcaya 242
3868 BU Burgos 242
3869 C A Coruña 242
3870 CA Cádiz 242
3871 CC Cáceres 242
3872 CE Ceuta 242
3873 CO Córdoba 242
3874 CR Ciudad Real 242
3875 CS Castellón 242
3876 CU Cuenca 242
3877 GC Las Palmas 242
3878 GI Girona 242
3879 GR Granada 242
3880 GU Guadalajara 242
3881 H Huelva 242
3882 HU Huesca 242
3883 J Jaén 242
3884 L Lleida 242
3885 LE León 242
3886 LO La Rioja 242
3887 LU Lugo 242
3888 M Madrid 242
3889 MA Málaga 242
3890 ML Melilla 242
3891 MU Murcia 242
3892 NA Navarra 242
3893 O Asturias 242
3894 OR Ourense 242
3895 P Palencia 242
3896 PM Baleares 242
3897 PO Pontevedra 242
3898 S Cantabria 242
3899 SA Salamanca 242
3900 SE Sevilla 242
3901 SG Segovia 242
3902 SO Soria 242
3903 SS Guipúzcoa 242
3904 T Tarragona 242
3905 TE Teruel 242
3906 TF Santa Cruz de Tenerife 242
3907 TO Toledo 242
3908 V Valencia 242
3909 VA Valladolid 242
3910 VI Álava 242
3911 Z Zaragoza 242
3912 ZA Zamora 242
3913 AA Adis Abeba 243
3914 AF Afar 243
3915 AM Amara 243
3916 BE Binshangul Gumuz 243
3917 DD Dire Dawa 243
3918 GA Gambela Hizboch 243
3919 HA Hareri Hizb 243
3920 OR Oromiya 243
3921 SN YeDebub Biheroch Bihereseboch na Hizboch 243
3922 SO Sumale 243
3923 TI Tigray 243
3924 AL Ahvenanmaan lääni 244
3925 ES Etelä-Suomen lääni 244
3926 IS Itä-Suomen lääni 244
3927 LL Lapin lääni 244
3928 LS Länsi-Suomen lääni 244
3929 OL Oulun lääni 244
3930 C Central 245
3931 E Eastern 245
3932 N Northern 245
3933 R Rotuma 245
3934 W Western 245
3935 KSA Kosrae 247
3936 PNI Pohnpei 247
3937 TRK Chuuk 247
3938 YAP Yap 247
3939 01 Ain 249
3940 02 Aisne 249
3941 03 Allier 249
3942 04 Alpes-de-Haute-Provence 249
3943 05 Hautes-Alpes 249
3944 06 Alpes-Maritimes 249
3945 07 Ardèche 249
3946 08 Ardennes 249
3947 09 Ariège 249
3948 10 Aube 249
3949 11 Aude 249
3950 12 Aveyron 249
3951 13 Bouches-du-Rhône 249
3952 14 Calvados 249
3953 15 Cantal 249
3954 16 Charente 249
3955 17 Charente-Maritime 249
3956 18 Cher 249
3957 19 Corrèze 249
3958 21 Côte-d'Or 249
3959 22 Côtes-d'Armor 249
3960 23 Creuse 249
3961 24 Dordogne 249
3962 25 Doubs 249
3963 26 Drôme 249
3964 27 Eure 249
3965 28 Eure-et-Loir 249
3966 29 Finistère 249
3967 2A Corse-du-Sud 249
3968 2B Haute-Corse 249
3969 30 Gard 249
3970 31 Haute-Garonne 249
3971 32 Gers 249
3972 33 Gironde 249
3973 34 Hérault 249
3974 35 Ille-et-Vilaine 249
3975 36 Indre 249
3976 37 Indre-et-Loire 249
3977 38 Isère 249
3978 39 Jura 249
3979 40 Landes 249
3980 41 Loir-et-Cher 249
3981 42 Loire 249
3982 43 Haute-Loire 249
3983 44 Loire-Atlantique 249
3984 45 Loiret 249
3985 46 Lot 249
3986 47 Lot-et-Garonne 249
3987 48 Lozère 249
3988 49 Maine-et-Loire 249
3989 50 Manche 249
3990 51 Marne 249
3991 52 Haute-Marne 249
3992 53 Mayenne 249
3993 54 Meurthe-et-Moselle 249
3994 55 Meuse 249
3995 56 Morbihan 249
3996 57 Moselle 249
3997 58 Nièvre 249
3998 59 Nord 249
3999 60 Oise 249
4000 61 Orne 249
4001 62 Pas-de-Calais 249
4002 63 Puy-de-Dôme 249
4003 64 Pyrénées-Atlantiques 249
4004 65 Hautes-Pyrénées 249
4005 66 Pyrénées-Orientales 249
4006 67 Bas-Rhin 249
4007 68 Haut-Rhin 249
4008 69 Rhône 249
4009 70 Haute-Saône 249
4010 71 Saône-et-Loire 249
4011 72 Sarthe 249
4012 73 Savoie 249
4013 74 Haute-Savoie 249
4014 75 Paris 249
4015 76 Seine-Maritime 249
4016 77 Seine-et-Marne 249
4017 78 Yvelines 249
4018 79 Deux-Sèvres 249
4019 80 Somme 249
4020 81 Tarn 249
4021 82 Tarn-et-Garonne 249
4022 83 Var 249
4023 84 Vaucluse 249
4024 85 Vendée 249
4025 86 Vienne 249
4026 87 Haute-Vienne 249
4027 88 Vosges 249
4028 89 Yonne 249
4029 90 Territoire de Belfort 249
4030 91 Essonne 249
4031 92 Hauts-de-Seine 249
4032 93 Seine-Saint-Denis 249
4033 94 Val-de-Marne 249
4034 95 Val-d'Oise 249
4035 NC Nouvelle-Calédonie (see also separate entry under NC) 249
4036 PF Polynésie française (see also separate entry under PF) 249
4037 PM Saint-Pierre-et-Miquelon (see also separate entry under PM) 249
4038 TF Terres Australes Françaises (see also separate entry under TF) 249
4039 WF Wallis et Futuna (see also separate entry under WF) 249
4040 YT Mayotte (see also separate entry under YT) 249
4041 1 Estuaire 250
4042 2 Haut-Ogooué 250
4043 3 Moyen-Ogooué 250
4044 4 Ngounié 250
4045 5 Nyanga 250
4046 6 Ogooué-Ivindo 250
4047 7 Ogooué-Lolo 250
4048 8 Ogooué-Maritime 250
4049 9 Woleu-Ntem 250
4050 ABD Aberdeenshire 251
4051 ABE Aberdeen City 251
4052 AGB Argyll and Bute 251
4053 AGY Isle of Anglesey [Sir Ynys Môn GB-YNM] 251
4054 ANS Angus 251
4055 ANT Antrim 251
4056 ARD Ards 251
4057 ARM Armagh 251
4058 BAS Bath and North East Somerset 251
4059 BBD Blackburn with Darwen 251
4060 BDF Bedfordshire 251
4061 BDG Barking and Dagenham 251
4062 BEN Brent 251
4063 BEX Bexley 251
4064 BFS Belfast 251
4208 PLY Plymouth 251
4065 BGE Bridgend [Pen-y-bont ar Ogwr GB-POG] 251
4066 BGW Blaenau Gwent 251
4067 BIR Birmingham 251
4068 BKM Buckinghamshire 251
4069 BLA Ballymena 251
4070 BLY Ballymoney 251
4071 BMH Bournemouth 251
4072 BNB Banbridge 251
4073 BNE Barnet 251
4074 BNH Brighton and Hove 251
4075 BNS Barnsley 251
4076 BOL Bolton 251
4077 BPL Blackpool 251
4078 BRC Bracknell Forest 251
4079 BRD Bradford 251
4080 BRY Bromley 251
4081 BST Bristol, City of 251
4082 BUR Bury 251
4083 CAM Cambridgeshire 251
4084 CAY Caerphilly [Caerffili GB-CAF] 251
4085 CGN Ceredigion [Sir Ceredigion] 251
4086 CGV Craigavon 251
4087 CHS Cheshire 251
4088 CKF Carrickfergus 251
4089 CKT Cookstown 251
4090 CLD Calderdale 251
4091 CLK Clackmannanshire 251
4092 CLR Coleraine 251
4093 CMA Cumbria 251
4094 CMD Camden 251
4095 CMN Carmarthenshire [Sir Gaerfyrddin GB-GFY] 251
4096 CON Cornwall 251
4097 COV Coventry 251
4098 CRF Cardiff [Caerdydd GB-CRD] 251
4099 CRY Croydon 251
4100 CSR Castlereagh 251
4101 CWY Conwy 251
4102 DAL Darlington 251
4103 DBY Derbyshire 251
4104 DEN Denbighshire [Sir Ddinbych GB-DDB] 251
4105 DER Derby 251
4106 DEV Devon 251
4107 DGN Dungannon 251
4108 DGY Dumfries and Galloway 251
4109 DNC Doncaster 251
4110 DND Dundee City 251
4111 DOR Dorset 251
4112 DOW Down 251
4113 DRY Derry 251
4114 DUD Dudley 251
4115 DUR Durham 251
4116 EAL Ealing 251
4117 EAY East Ayrshire 251
4118 EDH Edinburgh, City of 251
4119 EDU East Dunbartonshire 251
4120 ELN East Lothian 251
4121 ELS Eilean Siar 251
4122 ENF Enfield 251
4123 ERW East Renfrewshire 251
4124 ERY East Riding of Yorkshire 251
4125 ESS Essex 251
4126 ESX East Sussex 251
4127 FAL Falkirk 251
4128 FER Fermanagh 251
4129 FIF Fife 251
4130 FLN Flintshire [Sir y Fflint GB-FFL] 251
4131 GAT Gateshead 251
4132 GLG Glasgow City 251
4133 GLS Gloucestershire 251
4134 GRE Greenwich 251
4135 GWN Gwynedd 251
4136 HAL Halton 251
4137 HAM Hampshire 251
4138 HAV Havering 251
4139 HCK Hackney 251
4140 HEF Herefordshire, County of 251
4141 HIL Hillingdon 251
4142 HLD Highland 251
4143 HMF Hammersmith and Fulham 251
4144 HNS Hounslow 251
4145 HPL Hartlepool 251
4146 HRT Hertfordshire 251
4147 HRW Harrow 251
4148 HRY Haringey 251
4149 IOS Isles of Scilly 251
4150 IOW Isle of Wight 251
4151 ISL Islington 251
4152 IVC Inverclyde 251
4153 KEC Kensington and Chelsea 251
4154 KEN Kent 251
4155 KHL Kingston upon Hull, City of 251
4156 KIR Kirklees 251
4157 KTT Kingston upon Thames 251
4158 KWL Knowsley 251
4159 LAN Lancashire 251
4160 LBH Lambeth 251
4161 LCE Leicester 251
4162 LDS Leeds 251
4163 LEC Leicestershire 251
4164 LEW Lewisham 251
4165 LIN Lincolnshire 251
4166 LIV Liverpool 251
4167 LMV Limavady 251
4168 LND London, City of 251
4169 LRN Larne 251
4170 LSB Lisburn 251
4171 LUT Luton 251
4172 MAN Manchester 251
4173 MDB Middlesbrough 251
4174 MDW Medway 251
4175 MFT Magherafelt 251
4176 MIK Milton Keynes 251
4177 MLN Midlothian 251
4178 MON Monmouthshire [Sir Fynwy GB-FYN] 251
4179 MRT Merton 251
4180 MRY Moray 251
4181 MTY Merthyr Tydfil [Merthyr Tudful GB-MTU] 251
4182 MYL Moyle 251
4183 NAY North Ayrshire 251
4184 NBL Northumberland 251
4185 NDN North Down 251
4186 NEL North East Lincolnshire 251
4187 NET Newcastle upon Tyne 251
4188 NFK Norfolk 251
4189 NGM Nottingham 251
4190 NLK North Lanarkshire 251
4191 NLN North Lincolnshire 251
4192 NSM North Somerset 251
4193 NTA Newtownabbey 251
4194 NTH Northamptonshire 251
4195 NTL Neath Port Talbot [Castell-nedd Port Talbot GB-CTL] 251
4196 NTT Nottinghamshire 251
4197 NTY North Tyneside 251
4198 NWM Newham 251
4199 NWP Newport [Casnewydd GB-CNW] 251
4200 NYK North Yorkshire 251
4201 NYM Newry and Mourne 251
4202 OLD Oldham 251
4203 OMH Omagh 251
4204 ORK Orkney Islands 251
4205 OXF Oxfordshire 251
4206 PEM Pembrokeshire [Sir Benfro GB-BNF] 251
4207 PKN Perth and Kinross 251
4209 POL Poole 251
4210 POR Portsmouth 251
4211 POW Powys 251
4212 PTE Peterborough 251
4213 RCC Redcar and Cleveland 251
4214 RCH Rochdale 251
4215 RCT Rhondda, Cynon, Taff [Rhondda, Cynon,Taf] 251
4216 RDB Redbridge 251
4217 RDG Reading 251
4218 RFW Renfrewshire 251
4219 RIC Richmond upon Thames 251
4220 ROT Rotherham 251
4221 RUT Rutland 251
4222 SAW Sandwell 251
4223 SAY South Ayrshire 251
4224 SCB Scottish Borders, The 251
4225 SFK Suffolk 251
4226 SFT Sefton 251
4227 SGC South Gloucestershire 251
4228 SHF Sheffield 251
4229 SHN St. Helens 251
4230 SHR Shropshire 251
4231 SKP Stockport 251
4232 SLF Salford 251
4233 SLG Slough 251
4234 SLK South Lanarkshire 251
4235 SND Sunderland 251
4236 SOL Solihull 251
4237 SOM Somerset 251
4238 SOS Southend-on-Sea 251
4239 SRY Surrey 251
4240 STB Strabane 251
4241 STE Stoke-on-Trent 251
4242 STG Stirling 251
4243 STH Southampton 251
4244 STN Sutton 251
4245 STS Staffordshire 251
4246 STT Stockton-on-Tees 251
4247 STY South Tyneside 251
4248 SWA Swansea [Abertawe GB-ATA] 251
4249 SWD Swindon 251
4250 SWK Southwark 251
4251 TAM Tameside 251
4252 TFW Telford and Wrekin 251
4253 THR Thurrock 251
4254 TOB Torbay 251
4255 TOF Torfaen [Tor-faen] 251
4256 TRF Trafford 251
4257 TWH Tower Hamlets 251
4258 VGL Vale of Glamorgan, The [Bro Morgannwg GB-BMG] 251
4259 WAR Warwickshire 251
4260 WBK West Berkshire 251
4261 WDU West Dunbartonshire 251
4262 WFT Waltham Forest 251
4263 WGN Wigan 251
4264 WIL Wiltshire 251
4265 WKF Wakefield 251
4266 WLL Walsall 251
4267 WLN West Lothian 251
4268 WLV Wolverhampton 251
4269 WND Wandsworth 251
4270 WNM Windsor and Maidenhead 251
4271 WOK Wokingham 251
4272 WOR Worcestershire 251
4273 WRL Wirral 251
4274 WRT Warrington 251
4275 WRX Wrexham [Wrecsam GB-WRC] 251
4276 WSM Westminster 251
4277 WSX West Sussex 251
4278 YOR York 251
4279 ZET Shetland Islands 251
4280 01 Saint Andrew 252
4281 02 Saint David 252
4282 03 Saint George 252
4283 04 Saint John 252
4284 05 Saint Mark 252
4285 06 Saint Patrick 252
4286 10 Southern Grenadine Islands 252
4287 AB Abkhazia 253
4288 AJ Ajaria 253
4289 GU Guria 253
4290 IM Imereti 253
4291 KA Kakheti 253
4292 KK Kvemo Kartli 253
4293 MM Mtskheta-Mtianeti 253
4294 RL Racha-Lechkhumi [and] Kvemo Svaneti 253
4295 SJ Samtskhe-Javakheti 253
4296 SK Shida Kartli 253
4297 SZ Samegrelo-Zemo Svaneti 253
4298 TB Tbilisi 253
4299 AA Greater Accra 256
4300 AH Ashanti 256
4301 BA Brong-Ahafo 256
4302 CP Central 256
4303 EP Eastern 256
4304 NP Northern 256
4305 TV Volta 256
4306 UE Upper East 256
4307 UW Upper West 256
4308 WP Western 256
4309 B Banjul 259
4310 L Lower River 259
4311 M MacCarthy Island 259
4312 N North Bank 259
4313 U Upper River 259
4314 W Western 259
4315 BE Beyla 260
4316 BF Boffa 260
4317 BK Boké 260
4318 C Conakry 260
4319 CO Coyah 260
4320 DB Dabola 260
4321 DI Dinguiraye 260
4322 DL Dalaba 260
4323 DU Dubréka 260
4324 FA Faranah 260
4325 FO Forécariah 260
4326 FR Fria 260
4327 GA Gaoual 260
4328 GU Guékédou 260
4329 KA Kankan 260
4330 KB Koubia 260
4331 KD Kindia 260
4332 KE Kérouané 260
4333 KN Koundara 260
4334 KO Kouroussa 260
4335 KS Kissidougou 260
4336 LA Labé 260
4337 LE Lélouma 260
4338 LO Lola 260
4339 MC Macenta 260
4340 MD Mandiana 260
4341 ML Mali 260
4342 MM Mamou 260
4343 NZ Nzérékoré 260
4344 PI Pita 260
4345 SI Siguiri 260
4346 TE Télimélé 260
4347 TO Tougué 260
4348 YO Yomou 260
4349 AN Annobón 262
4350 BN Bioko Norte 262
4351 BS Bioko Sur 262
4352 C Región Continental 262
4353 CS Centro Sur 262
4354 I Región Insular 262
4355 KN Kie-Ntem 262
4356 LI Litoral 262
4357 WN Wele-Nzás 262
4358 01 Aitolia-Akarnania 263
4359 03 Voiotia 263
4360 04 Evvoia 263
4361 05 Evrytania 263
4362 06 Fthiotis 263
4363 07 Fokis 263
4364 11 Argolis 263
4365 12 Arkadia 263
4366 13 Achaïa 263
4367 14 Ileia 263
4368 15 Korinthia 263
4369 16 Lakonia 263
4370 17 Messinia 263
4371 21 Zakynthos 263
4372 22 Kerkyra 263
4373 23 Kefallinia 263
4374 24 Lefkas 263
4375 31 Arta 263
4376 32 Thesprotia 263
4377 33 Ioannina 263
4378 34 Preveza 263
4379 41 Karditsa 263
4380 42 Larisa 263
4381 43 Magnisia 263
4382 44 Trikala 263
4383 51 Grevena 263
4384 52 Drama 263
4385 53 Imathia 263
4386 54 Thessaloniki 263
4387 55 Kavalla 263
4388 56 Kastoria 263
4389 57 Kilkis 263
4390 58 Kozani 263
4391 59 Pella 263
4392 61 Pieria 263
4393 62 Serrai 263
4394 63 Florina 263
4395 64 Chalkidiki 263
4396 69 Agio Oros 263
4397 71 Evros 263
4398 72 Xanthi 263
4399 73 Rodopi 263
4400 81 Dodekanisos 263
4401 82 Kyklades 263
4402 83 Lesvos 263
4403 84 Samos 263
4404 85 Chios 263
4405 91 Irakleion 263
4406 92 Lasithion 263
4407 93 Rethymnon 263
4408 94 Chania 263
4409 A1 Attiki 263
4410 AV Alta Verapaz 265
4411 BV Baja Verapaz 265
4412 CM Chimaltenango 265
4413 CQ Chiquimula 265
4414 ES Escuintla 265
4415 GU Guatemala 265
4416 HU Huehuetenango 265
4417 IZ Izabal 265
4418 JA Jalapa 265
4419 JU Jutiapa 265
4420 PE Petén 265
4421 PR El Progreso 265
4422 QC Quiché 265
4423 QZ Quetzaltenango 265
4424 RE Retalhuleu 265
4425 SA Sacatepéquez 265
4426 SM San Marcos 265
4427 SO Sololá 265
4428 SR Santa Rosa 265
4429 SU Suchitepéquez 265
4430 TO Totonicapán 265
4431 ZA Zacapa 265
4432 BA Bafatá 267
4433 BL Bolama 267
4434 BM Biombo 267
4435 BS Bissau 267
4436 CA Cacheu 267
4437 GA Gabú 267
4438 OI Oio 267
4439 QU Quinara 267
4440 TO Tombali 267
4441 BA Barima-Waini 268
4442 CU Cuyuni-Mazaruni 268
4443 DE Demerara-Mahaica 268
4444 EB East Berbice-Corentyne 268
4445 ES Essequibo Islands-West Demerara 268
4446 MA Mahaica-Berbice 268
4447 PM Pomeroon-Supenaam 268
4448 PT Potaro-Siparuni 268
4449 UD Upper Demerara-Berbice 268
4450 UT Upper Takutu-Upper Essequibo 268
4451 AT Atlántida 271
4452 CH Choluteca 271
4453 CL Colón 271
4454 CM Comayagua 271
4455 CP Copán 271
4456 CR Cortés 271
4457 EP El Paraíso 271
4458 FM Francisco Morazán 271
4459 GD Gracias a Dios 271
4460 IB Islas de la Bahía 271
4461 IN Intibucá 271
4462 LE Lempira 271
4463 LP La Paz 271
4464 OC Ocotepeque 271
4465 OL Olancho 271
4466 SB Santa Bárbara 271
4467 VA Valle 271
4468 YO Yoro 271
4469 01 Zagrebacka županija 272
4470 02 Krapinsko-zagorska županija 272
4471 03 Sisacko-moslavacka županija 272
4472 04 Karlovacka županija 272
4473 05 Varaždinska županija 272
4474 06 Koprivnicko-križevacka županija 272
4475 07 Bjelovarsko-bilogorska županija 272
4476 08 Primorsko-goranska županija 272
4477 09 Licko-senjska županija 272
4478 10 Viroviticko-podravska županija 272
4479 11 Požeško-slavonska županija 272
4480 12 Brodsko-posavska županija 272
4481 13 Zadarska županija 272
4482 14 Osjecko-baranjska županija 272
4483 15 Šibensko-kninska županija 272
4484 16 Vukovarsko-srijemska županija 272
4485 17 Splitsko-dalmatinska županija 272
4486 18 Istarska županija 272
4487 19 Dubrovacko-neretvanska županija 272
4488 20 Medimurska županija 272
4489 21 Grad Zagreb 272
4490 AR Artibonite 273
4491 CE Centre 273
4492 GA Grande-Anse 273
4493 ND Nord 273
4494 NE Nord-Est 273
4495 NO Nord-Ouest 273
4496 OU Ouest 273
4497 SD Sud 273
4498 SE Sud-Est 273
4499 BA Baranya 274
4500 BC Békéscsaba 274
4501 BE Békés 274
4502 BK Bács-Kiskun 274
4503 BU Budapest 274
4504 BZ Borsod-Abaúj-Zemplén 274
4505 CS Csongrád 274
4506 DE Debrecen 274
4507 DU Dunaújváros 274
4508 EG Eger 274
4509 FE Fejér 274
4510 GS Gyor-Moson-Sopron 274
4511 GY Gyor 274
4512 HB Hajdú-Bihar 274
4513 HE Heves 274
4514 HV Hódmezovásárhely 274
4515 JN Jász-Nagykun-Szolnok 274
4516 KE Komárom-Esztergom 274
4517 KM Kecskemét 274
4518 KV Kaposvár 274
4519 MI Miskolc 274
4520 NK Nagykanizsa 274
4521 NO Nógrád 274
4522 NY Nyíregyháza 274
4523 PE Pest 274
4524 PS Pécs 274
4525 SD Szeged 274
4526 SF Székesfehérvár 274
4527 SH Szombathely 274
4528 SK Szolnok 274
4529 SN Sopron 274
4530 SO Somogy 274
4531 SS Szekszárd 274
4532 ST Salgótarján 274
4533 SZ Szabolcs-Szatmár-Bereg 274
4534 TB Tatabánya 274
4535 TO Tolna 274
4536 VA Vas 274
4537 VE Veszprém 274
4538 VM Veszprém City 274
4539 X1~ Erd 274
4540 ZA Zala 274
4541 ZE Zalaegerszeg 274
4542 AC Aceh 275
4543 BA Bali 275
4544 BB Bangka Belitung 275
4545 BE Bengkulu 275
4546 BT Banten 275
4547 GO Gorontalo 275
4548 JA Jambi 275
4549 JB Jawa Barat 275
4550 JI Jawa Timur 275
4551 JK Jakarta Raya 275
4552 JT Jawa Tengah 275
4553 KB Kalimantan Barat 275
4554 KI Kalimantan Timur 275
4555 KR Kepulauan Riau 275
4556 KS Kalimantan Selatan 275
4557 KT Kalimantan Tengah 275
4558 LA Lampung 275
4559 MA Maluku 275
4560 MU Maluku Utara 275
4561 NB Nusa Tenggara Barat 275
4562 NT Nusa Tenggara Timur 275
4563 PA Papua 275
4564 RI Riau 275
4565 SA Sulawesi Utara 275
4566 SB Sumatera Barat 275
4567 SG Sulawesi Tenggara 275
4568 SN Sulawesi Selatan 275
4569 SR Sulawesi Barat 275
4570 SS Sumatera Selatan 275
4571 ST Sulawesi Tengah 275
4572 SU Sumatera Utara 275
4573 X1~ Papua Barat 275
4574 YO Yogyakarta 275
4575 C Cork 276
4576 CE Clare 276
4577 CN Cavan 276
4578 CW Carlow 276
4579 D Dublin 276
4580 DL Donegal 276
4581 G Galway 276
4582 KE Kildare 276
4583 KK Kilkenny 276
4584 KY Kerry 276
4585 LD Longford 276
4586 LH Louth 276
4587 LK Limerick 276
4588 LM Leitrim 276
4589 LS Laois 276
4590 MH Meath 276
4591 MN Monaghan 276
4592 MO Mayo 276
4593 OY Offaly 276
4594 RN Roscommon 276
4595 SO Sligo 276
4596 TA Tipperary 276
4597 WD Waterford 276
4598 WH Westmeath 276
4599 WW Wicklow 276
4600 WX Wexford 276
4601 D HaDarom 277
4602 HA Haifa 277
4603 JM Yerushalayim 277
4604 M HaMerkaz 277
4605 TA Tel-Aviv 277
4606 Z HaZafon 277
4607 AN Andaman and Nicobar Islands 279
4608 AP Andhra Pradesh 279
4609 AR Arunachal Pradesh 279
4610 AS Assam 279
4611 BR Bihar 279
4612 CH Chandigarh 279
4613 CT Chhattisgarh 279
4614 DD Daman and Diu 279
4615 DL Delhi 279
4616 DN Dadra and Nagar Haveli 279
4617 GA Goa 279
4618 GJ Gujarat 279
4619 HP Himachal Pradesh 279
4620 HR Haryana 279
4621 JH Jharkhand 279
4622 JK Jammu and Kashmir 279
4623 KA Karnataka 279
4624 KL Kerala 279
4625 LD Lakshadweep 279
4626 MH Maharashtra 279
4627 ML Meghalaya 279
4628 MN Manipur 279
4629 MP Madhya Pradesh 279
4630 MZ Mizoram 279
4631 NL Nagaland 279
4632 OR Orissa 279
4633 PB Punjab 279
4634 PY Pondicherry 279
4635 RJ Rajasthan 279
4636 SK Sikkim 279
4637 TN Tamil Nadu 279
4638 TR Tripura 279
4639 UL Uttaranchal 279
4640 UP Uttar Pradesh 279
4641 WB West Bengal 279
4642 AN Al Anbar 281
4643 AR Arbil 281
4644 BA Al Basrah 281
4645 BB Babil 281
4646 BG Baghdad 281
4647 DA Dahuk 281
4648 DI Diyalá 281
4649 DQ Dhi Qar 281
4650 KA Karbala' 281
4651 MA Maysan 281
4652 MU Al Muthanná 281
4653 NA An Najaf 281
4654 NI Ninawá 281
4655 QA Al Qadisiyah 281
4656 SD Salah ad Din 281
4657 SU As Sulaymaniyah 281
4658 TS At Ta'mim 281
4659 WA Wasit 281
4660 01 Az¯arbayjan-e Sharqi 282
4661 02 Az¯arbayjan-e Gharbi 282
4662 03 Ardabil 282
4663 04 Esfahan 282
4664 05 Ilam 282
4665 06 Bushehr 282
4666 07 Tehran 282
4667 08 Chahar Mah¸all va Bakhtiari 282
4668 09 Khorasan 282
4669 10 Khuzestan 282
4670 11 Zanjan 282
4671 12 Semnan 282
4672 13 Sistan va Baluchestan 282
4673 14 Fars 282
4674 15 Kerman 282
4675 16 Kordestan 282
4676 17 Kermanshah 282
4677 18 Kohkiluyeh va Buyer Ahmad 282
4678 19 Gilan 282
4679 20 Lorestan 282
4680 21 Mazandaran 282
4681 22 Markazi 282
4682 23 Hormozgan 282
4683 24 Hamadan 282
4684 25 Yazd 282
4685 26 Qom 282
4686 27 Golestan 282
4687 28 Qazvin 282
4688 29 Khorasan-e Janubi 282
4689 30 Khorasan-e Razavi 282
4690 31 Khorasan-e Shemali 282
4691 0 Reykjavík 283
4692 1 Höfuðborgarsvæði utan Reykjavíkur 283
4693 2 Suðurnes 283
4694 3 Vesturland 283
4695 4 Vestfirðir 283
4696 5 Norðurland vestra 283
4697 6 Norðurland eystra 283
4698 7 Austurland 283
4699 8 Suðurland 283
4700 AG Agrigento 284
4701 AL Alessandria 284
4702 AN Ancona 284
4703 AO Aosta 284
4704 AP Ascoli Piceno 284
4705 AQ L'Aquila 284
4706 AR Arezzo 284
4707 AT Asti 284
4708 AV Avellino 284
4709 BA Bari 284
4710 BG Bergamo 284
4711 BI Biella 284
4712 BL Belluno 284
4713 BN Benevento 284
4714 BO Bologna 284
4715 BR Brindisi 284
4716 BS Brescia 284
4717 BZ Bolzano 284
4718 CA Cagliari 284
4719 CB Campobasso 284
4720 CE Caserta 284
4721 CH Chieti 284
4722 CI Carbonia-Iglesias 284
4723 CL Caltanissetta 284
4724 CN Cuneo 284
4725 CO Como 284
4726 CR Cremona 284
4727 CS Cosenza 284
4728 CT Catania 284
4729 CZ Catanzaro 284
4730 EN Enna 284
4731 FE Ferrara 284
4732 FG Foggia 284
4733 FI Firenze 284
4734 FO Forlì 284
4735 FR Frosinone 284
4736 GE Genova 284
4737 GO Gorizia 284
4738 GR Grosseto 284
4739 IM Imperia 284
4740 IS Isernia 284
4741 KR Crotone 284
4742 LC Lecco 284
4743 LE Lecce 284
4744 LI Livorno 284
4745 LO Lodi 284
4746 LT Latina 284
4747 LU Lucca 284
4748 MA Medio Campidano 284
4749 MC Macerata 284
4750 ME Messina 284
4751 MI Milano 284
4752 MN Mantova 284
4753 MO Modena 284
4754 MS Massa-Carrara 284
4755 MT Matera 284
4756 NA Napoli 284
4757 NO Novara 284
4758 NU Nuoro 284
4759 OG Ogliastra 284
4760 OL Olbia-Tempio 284
4761 OR Oristano 284
4762 PA Palermo 284
4763 PC Piacenza 284
4764 PD Padova 284
4765 PE Pescara 284
4766 PG Perugia 284
4767 PI Pisa 284
4768 PN Pordenone 284
4769 PO Prato 284
4770 PR Parma 284
4771 PS Pesaro e Urbino 284
4772 PT Pistoia 284
4773 PV Pavia 284
4774 PZ Potenza 284
4775 RA Ravenna 284
4776 RC Reggio Calabria 284
4777 RE Reggio Emilia 284
4778 RG Ragusa 284
4779 RI Rieti 284
4780 RM Roma 284
4781 RN Rimini 284
4782 RO Rovigo 284
4783 SA Salerno 284
4784 SI Siena 284
4785 SO Sondrio 284
4786 SP La Spezia 284
4787 SR Siracusa 284
4788 SS Sassari 284
4789 SV Savona 284
4790 TA Taranto 284
4791 TE Teramo 284
4792 TN Trento 284
4793 TO Torino 284
4794 TP Trapani 284
4795 TR Terni 284
4796 TS Trieste 284
4797 TV Treviso 284
4798 UD Udine 284
4799 VA Varese 284
4800 VB Verbano-Cusio-Ossola 284
4801 VC Vercelli 284
4802 VE Venezia 284
4803 VI Vicenza 284
4804 VR Verona 284
4805 VT Viterbo 284
4806 VV Vibo Valentia 284
4807 01 Kingston 286
4808 02 Saint Andrew 286
4809 03 Saint Thomas 286
4810 04 Portland 286
4811 05 Saint Mary 286
4812 06 Saint Ann 286
4813 07 Trelawny 286
4814 08 Saint James 286
4815 09 Hanover 286
4816 10 Westmoreland 286
4817 11 Saint Elizabeth 286
4818 12 Manchester 286
4819 13 Clarendon 286
4820 14 Saint Catherine 286
4821 AJ ?Ajlun 287
4822 AM ?Amman 287
4823 AQ Aqaba 287
4824 AT At Tafilah 287
4825 AZ Az Zarqa' 287
4826 BA Al Balqa' 287
4827 IR Irbid 287
4828 JA Jarash 287
4829 KA Al Karak 287
4830 MA Al Mafraq 287
4831 MD Madaba 287
4832 MN Ma`an 287
4833 01 Hokkaidô [Hokkaido] 288
4834 02 Aomori 288
4835 03 Iwate 288
4836 04 Miyagi 288
4837 05 Akita 288
4838 06 Yamagata 288
4839 07 Hukusima [Fukushima] 288
4840 08 Ibaraki 288
4841 09 Totigi [Tochigi] 288
4842 10 Gunma 288
4843 11 Saitama 288
4844 12 Tiba [Chiba] 288
4845 13 Tôkyô [Tokyo] 288
4846 14 Kanagawa 288
4847 15 Niigata 288
4848 16 Toyama 288
4849 17 Isikawa [Ishikawa] 288
4850 18 Hukui [Fukui] 288
4851 19 Yamanasi [Yamanashi] 288
4852 20 Nagano 288
4853 21 Gihu [Gifu] 288
4854 22 Sizuoka [Shizuoka] 288
4855 23 Aiti [Aichi] 288
4856 24 Mie 288
4857 25 Siga [Shiga] 288
4858 26 Kyôto [Kyoto] 288
4859 27 Ôsaka [Osaka] 288
4860 28 Hyôgo [Hyogo] 288
4861 29 Nara 288
4862 30 Wakayama 288
4863 31 Tottori 288
4864 32 Simane [Shimane] 288
4865 33 Okayama 288
4866 34 Hirosima [Hiroshima] 288
4867 35 Yamaguti [Yamaguchi] 288
4868 36 Tokusima [Tokushima] 288
4869 37 Kagawa 288
4870 38 Ehime 288
4871 39 Kôti [Kochi] 288
4872 40 Hukuoka [Fukuoka] 288
4873 41 Saga 288
4874 42 Nagasaki 288
4875 43 Kumamoto 288
4876 44 Ôita [Oita] 288
4877 45 Miyazaki 288
4878 46 Kagosima [Kagoshima] 288
4879 47 Okinawa 288
4880 110 Nairobi Municipality 289
4881 200 Central 289
4882 300 Coast 289
4883 400 Eastern 289
4884 500 North-Eastern 289
4885 600 Nyanza 289
4886 700 Rift Valley 289
4887 900 Western 289
4888 B Batken 290
4889 C Chü 290
4890 GB Bishkek 290
4891 J Jalal-Abad 290
4892 N Naryn 290
4893 O Osh 290
4894 T Talas 290
4895 Y Ysyk-Köl 290
4896 1 Banteay Mean Chey [Bântéay Méanchey] 291
4897 10 Kracheh [Krâchéh] 291
4898 11 Mondol Kiri [Môndól Kiri] 291
4899 12 Phnom Penh [Phnum Pénh] 291
4900 13 Preah Vihear [Preah Vihéar] 291
4901 14 Prey Veaeng [Prey Vêng] 291
4902 15 Pousaat [Pouthisat] 291
4903 16 Rotanak Kiri [Rôtânôkiri] 291
4904 17 Siem Reab [Siemréab] 291
4905 18 Krong Preah Sihanouk [Krong Preah Sihanouk] 291
4906 19 Stueng Traeng [Stœ?ng Trêng] 291
4907 2 Baat Dambang [Batdâmbâng] 291
4908 20 Svaay Rieng [Svay Rieng] 291
4909 21 Taakaev [Takêv] 291
4910 22 Otdar Mean Chey [Otdâr Méanchey] 291
4911 23 Krong Kep [Krong Kêb] 291
4912 24 Krong Pailin [Krong Pailin] 291
4913 3 Kampong Chaam [Kâmpóng Cham] 291
4914 4 Kampong Chhnang [Kâmpóng Chhnang] 291
4915 5 Kampong Spueu [Kâmpóng Spœ] 291
4916 6 Kampong Thum [Kâmpóng Thum] 291
4917 7 Kampot [Kâmpôt] 291
4918 8 Kandaal [Kândal] 291
4919 9 Kaoh Kong [Kaôh Kong] 291
4920 G Gilbert Islands 292
4921 L Line Islands 292
4922 P Phoenix Islands 292
4923 A Anjouan 293
4924 G Grande Comore 293
4925 M Mohéli 293
4926 01 Christ Church Nichola Town 294
4927 02 Saint Anne Sandy Point 294
4928 03 Saint George Basseterre 294
4929 04 Saint George Gingerland 294
4930 05 Saint James Windward 294
4931 06 Saint John Capisterre 294
4932 07 Saint John Figtree 294
4933 08 Saint Mary Cayon 294
4934 09 Saint Paul Capisterre 294
4935 10 Saint Paul Charlestown 294
4936 11 Saint Peter Basseterre 294
4937 12 Saint Thomas Lowland 294
4938 13 Saint Thomas Middle Island 294
4939 15 Trinity Palmetto Point 294
4940 CHA Chagang-do 295
4941 HAB Hamgyongbuk-do 295
4942 HAN Hamgyongnam-do 295
4943 HWB Hwanghaebuk-do 295
4944 HWN Hwanghaenam-do 295
4945 KAE Kaesong-si 295
4946 KAN Kangwon-do 295
4947 NAJ Najin Sonbong-si 295
4948 NAM Nampo-si 295
4949 PYB Pyonganbuk-do 295
4950 PYN Pyongannam-do 295
4951 PYO Pyongyang-si 295
4952 X1~ Rason 295
4953 YAN Yanggang-do 295
4954 11 Seoul Teugbyeolsi [Seoul-T'ukpyolshi] 296
4955 26 Busan Gwang'yeogsi [Pusan-Kwangyokshi] 296
4956 27 Daegu Gwang'yeogsi [Taegu-Kwangyokshi] 296
4957 28 Incheon Gwang'yeogsi [Inch'n-Kwangyokshi] 296
4958 29 Gwangju Gwang'yeogsi [Kwangju-Kwangyokshi] 296
4959 30 Daejeon Gwang'yeogsi [Taejon-Kwangyokshi] 296
4960 31 Ulsan Gwang'yeogsi [Ulsan-Kwangyokshi] 296
4961 41 Gyeonggido [Kyonggi-do] 296
4962 42 Gang'weondo [Kang-won-do] 296
4963 43 Chungcheongbugdo [Ch'ungch'ongbuk-do] 296
4964 44 Chungcheongnamdo [Ch'ungch'ongnam-do] 296
4965 45 Jeonrabugdo[Chollabuk-do] 296
4966 46 Jeonranamdo [Chollanam-do] 296
4967 47 Gyeongsangbugdo [Kyongsangbuk-do] 296
4968 48 Gyeongsangnamdo [Kyongsangnam-do] 296
4969 49 Jejudo [Cheju-do] 296
4970 AH Al Ahmadi 297
4971 FA Al Farwaniyah 297
4972 HA Hawalli 297
4973 JA Al Jahrah 297
4974 KU Al Kuwayt 297
4975 MU Mubarak al-Kabir 297
4976 AKM Aqmola oblysy 299
4977 AKT Aqtöbe oblysy 299
4978 ALA Almaty 299
4979 ALM Almaty oblysy 299
4980 AST Astana 299
4981 ATY Atyrau oblysy 299
4982 BAY Bayqongyr 299
4983 KAR Qaraghandy oblysy 299
4984 KUS Qostanay oblysy 299
4985 KZY Qyzylorda oblysy 299
4986 MAN Mangghystau oblysy 299
4987 PAV Pavlodar oblysy 299
4988 SEV Soltüstik Qazaqstan oblysy 299
4989 VOS Shyghys Qazaqstan oblysy 299
4990 YUZ Ongtüstik Qazaqstan oblysy 299
4991 ZAP Batys Qazaqstan oblysy 299
4992 ZHA Zhambyl oblysy 299
4993 AT Attapu [Attopeu] 300
4994 BK Bokèo 300
4995 BL Bolikhamxai [Borikhane] 300
4996 CH Champasak [Champassak] 300
4997 HO Houaphan 300
4998 KH Khammouan 300
4999 LM Louang Namtha 300
5000 LP Louangphabang [Louang Prabang] 300
5001 OU Oudômxai [Oudomsai] 300
5002 PH Phôngsali [Phong Saly] 300
5003 SL Salavan [Saravane] 300
5004 SV Savannakhét 300
5005 VI Vientiane 300
5006 VT Vientiane Prefecture 300
5007 XA Xaignabouli [Sayaboury] 300
5008 XE Xékong [Sékong] 300
5009 XI Xiangkhoang [Xieng Khouang] 300
5010 XN Xaisômboun 300
5011 AS Loubnâne ech Chemâli 301
5012 BA Beirut 301
5013 BI El Béqaa 301
5014 JA Loubnâne ej Jnoûbi 301
5015 JL Jabal Loubnâne 301
5016 NA Nabatîyé 301
5017 01 Balzers 303
5018 02 Eschen 303
5019 03 Gamprin 303
5020 04 Mauren 303
5021 05 Planken 303
5022 06 Ruggell 303
5023 07 Schaan 303
5024 08 Schellenberg 303
5025 09 Triesen 303
5026 10 Triesenberg 303
5027 11 Vaduz 303
5028 11 Colombo 304
5029 12 Gampaha 304
5030 13 Kalutara 304
5031 21 Kandy 304
5032 22 Matale 304
5033 23 Nuwara Eliya 304
5034 31 Galle 304
5035 32 Matara 304
5036 33 Hambantota 304
5037 41 Jaffna 304
5038 42 Kilinochchi 304
5039 43 Mannar 304
5040 44 Vavuniya 304
5041 45 Mullaittivu 304
5042 51 Batticaloa 304
5043 52 Ampara 304
5044 53 Trincomalee 304
5045 61 Kurunegala 304
5046 62 Puttalam 304
5047 71 Anuradhapura 304
5048 72 Polonnaruwa 304
5049 81 Badulla 304
5050 82 Monaragala 304
5051 91 Ratnapura 304
5052 92 Kegalla 304
5053 BG Bong 305
5054 BM Bomi 305
5055 CM Grand Cape Mount 305
5056 GB Grand Bassa 305
5057 GG Grand Gedeh 305
5058 GK Grand Kru 305
5059 LO Lofa 305
5060 MG Margibi 305
5061 MO Montserrado 305
5062 MY Maryland 305
5063 NI Nimba 305
5064 RI Rivercess 305
5065 SI Sinoe 305
5066 X1~ Gbarpolu 305
5067 X2~ River Gee 305
5068 A Maseru 306
5069 B Butha-Buthe 306
5070 C Leribe 306
5071 D Berea 306
5072 E Mafeteng 306
5073 F Mohale's Hoek 306
5074 G Quthing 306
5075 H Qacha's Nek 306
5076 J Mokhotlong 306
5077 K Thaba-Tseka 306
5078 AL Alytaus Apskritis 307
5079 KL Klaipedos Apskritis 307
5080 KU Kauno Apskritis 307
5081 MR Marijampoles Apskritis 307
5082 PN Panevežio Apskritis 307
5083 SA Šiauliu Apskritis 307
5084 TA Taurages Apskritis 307
5085 TE Telšiu Apskritis 307
5086 UT Utenos Apskritis 307
5087 VL Vilniaus Apskritis 307
5088 D Diekirch 308
5089 G Grevenmacher 308
5090 L Luxembourg (fr) 308
5091 AI Aizkraukles Aprinkis 309
5092 AL Aluksnes Aprinkis 309
5093 BL Balvu Aprinkis 309
5094 BU Bauskas Aprinkis 309
5095 CE Cesu Aprinkis 309
5096 DA Daugavpils Aprinkis 309
5097 DGV Daugavpils 309
5098 DO Dobeles Aprinkis 309
5099 GU Gulbenes Aprinkis 309
5100 JEL Jelgava 309
5101 JK Jekabpils Aprinkis 309
5102 JL Jelgavas Aprinkis 309
5103 JUR Jurmala 309
5104 KR Kraslavas Aprinkis 309
5105 KU Kuldigas Aprinkis 309
5106 LE Liepajas Aprinkis 309
5107 LM Limbažu Aprinkis 309
5108 LPX Liepaja 309
5109 LU Ludzas Aprinkis 309
5110 MA Madonas Aprinkis 309
5111 OG Ogres Aprinkis 309
5112 PR Preilu Aprinkis 309
5113 RE Rezeknes Aprinkis 309
5114 REZ Rezekne 309
5115 RI Rigas Aprinkis 309
5116 RIX Riga 309
5117 SA Saldus Aprinkis 309
5118 TA Talsu Aprinkis 309
5119 TU Tukuma Aprinkis 309
5120 VE Ventspils Aprinkis 309
5121 VEN Ventspils 309
5122 VK Valkas Aprinkis 309
5123 VM Valmieras Aprinkis 309
5124 AJ Ajdabiya 310
5125 BA Banghazi 310
5126 BU Al Butnan 310
5127 BW Bani Walid 310
5128 DR Darnah 310
5129 GD Ghadamis 310
5130 GR Gharyan 310
5131 GT Ghat 310
5132 HZ Al ?izam al Akh?ar 310
5133 JA Al Jabal al Akh?ar 310
5134 JB Jaghbub 310
5135 JI Al Jifarah 310
5136 JU Al Jufrah 310
5137 KF Al Kufrah 310
5138 MB Al Marqab 310
5139 MI Misratah 310
5140 MJ Al Marj 310
5141 MQ Murzuq 310
5142 MZ Mizdah 310
5143 NL Nalut 310
5144 NQ An Nuqat al Khams 310