--
-- PostgreSQL database dump
--

-- Dumped from database version 15.5 (Ubuntu 15.5-1.pgdg22.04+1)
-- Dumped by pg_dump version 15.5 (Ubuntu 15.5-1.pgdg22.04+1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: action_events; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.action_events (
    id bigint NOT NULL,
    batch_id character(36) NOT NULL,
    user_id bigint NOT NULL,
    name character varying(255) NOT NULL,
    actionable_type character varying(255) NOT NULL,
    actionable_id bigint NOT NULL,
    target_type character varying(255) NOT NULL,
    target_id bigint NOT NULL,
    model_type character varying(255) NOT NULL,
    model_id bigint,
    fields text NOT NULL,
    status character varying(25) DEFAULT 'running'::character varying NOT NULL,
    exception text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    original text,
    changes text
);


ALTER TABLE public.action_events OWNER TO forge;

--
-- Name: action_events_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.action_events_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.action_events_id_seq OWNER TO forge;

--
-- Name: action_events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.action_events_id_seq OWNED BY public.action_events.id;


--
-- Name: call_requests; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.call_requests (
    id bigint NOT NULL,
    car_id bigint,
    name character varying(100) NOT NULL,
    phone character varying(100) NOT NULL,
    ip_address inet,
    user_agent character varying(300),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.call_requests OWNER TO forge;

--
-- Name: call_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.call_requests_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.call_requests_id_seq OWNER TO forge;

--
-- Name: call_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.call_requests_id_seq OWNED BY public.call_requests.id;


--
-- Name: car_category; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.car_category (
    car_id bigint NOT NULL,
    category_id bigint NOT NULL
);


ALTER TABLE public.car_category OWNER TO forge;

--
-- Name: cars; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.cars (
    id bigint NOT NULL,
    manufacturer_id bigint,
    model_id bigint,
    generation_id bigint,
    title character varying(400) NOT NULL,
    vin character varying(45) NOT NULL,
    body_type integer,
    color integer,
    engine_id bigint,
    transmission integer,
    drive_wheel integer,
    vehicle_type integer,
    fuel integer,
    cylinders integer,
    year integer,
    views integer DEFAULT 0 NOT NULL,
    sitemap_id bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    download_specs_at timestamp(0) without time zone,
    processed_specs_at timestamp(0) without time zone,
    has_images boolean DEFAULT false NOT NULL,
    has_bid boolean DEFAULT false NOT NULL,
    has_buy_now boolean DEFAULT false NOT NULL,
    is_hidden boolean DEFAULT false
);


ALTER TABLE public.cars OWNER TO forge;

--
-- Name: cars_id_seq1; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.cars_id_seq1
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.cars_id_seq1 OWNER TO forge;

--
-- Name: cars_id_seq1; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.cars_id_seq1 OWNED BY public.cars.id;


--
-- Name: categories; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.categories (
    id bigint NOT NULL,
    name character varying(200),
    meta_title character varying(400),
    meta_description character varying(1000),
    h1 character varying(400),
    url character varying(900) NOT NULL,
    filters jsonb NOT NULL,
    views integer DEFAULT 0 NOT NULL,
    cars_qty integer,
    cars_selected_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    content text
);


ALTER TABLE public.categories OWNER TO forge;

--
-- Name: categories_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.categories_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.categories_id_seq OWNER TO forge;

--
-- Name: categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.categories_id_seq OWNED BY public.categories.id;


--
-- Name: cities; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.cities (
    id bigint NOT NULL,
    country_id bigint,
    state_id bigint,
    name character varying(100) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.cities OWNER TO forge;

--
-- Name: cities_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.cities_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.cities_id_seq OWNER TO forge;

--
-- Name: cities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.cities_id_seq OWNED BY public.cities.id;


--
-- Name: countries; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.countries (
    id bigint NOT NULL,
    iso character varying(2),
    name character varying(70) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.countries OWNER TO forge;

--
-- Name: countries_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.countries_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.countries_id_seq OWNER TO forge;

--
-- Name: countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.countries_id_seq OWNED BY public.countries.id;


--
-- Name: currencies; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.currencies (
    id bigint NOT NULL,
    code character varying(3) NOT NULL,
    symbol character varying(25),
    symbol_native character varying(25),
    decimal_digits integer,
    name character varying(80)
);


ALTER TABLE public.currencies OWNER TO forge;

--
-- Name: currencies_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.currencies_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.currencies_id_seq OWNER TO forge;

--
-- Name: currencies_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.currencies_id_seq OWNED BY public.currencies.id;


--
-- Name: damages; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.damages (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    name_i18n character varying(150),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.damages OWNER TO forge;

--
-- Name: damages_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.damages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.damages_id_seq OWNER TO forge;

--
-- Name: damages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.damages_id_seq OWNED BY public.damages.id;


--
-- Name: engines; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.engines (
    id bigint NOT NULL,
    name character varying(250) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.engines OWNER TO forge;

--
-- Name: engines_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.engines_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.engines_id_seq OWNER TO forge;

--
-- Name: engines_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.engines_id_seq OWNED BY public.engines.id;


--
-- Name: failed_jobs; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.failed_jobs (
    id bigint NOT NULL,
    uuid character varying(255) NOT NULL,
    connection text NOT NULL,
    queue text NOT NULL,
    payload text NOT NULL,
    exception text NOT NULL,
    failed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.failed_jobs OWNER TO forge;

--
-- Name: failed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.failed_jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.failed_jobs_id_seq OWNER TO forge;

--
-- Name: failed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id;


--
-- Name: generations; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.generations (
    id bigint NOT NULL,
    manufacturer_id bigint NOT NULL,
    model_id bigint NOT NULL,
    name character varying(200) NOT NULL,
    from_year integer,
    to_year integer,
    cars_qty integer,
    ids json,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.generations OWNER TO forge;

--
-- Name: generations_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.generations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.generations_id_seq OWNER TO forge;

--
-- Name: generations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.generations_id_seq OWNED BY public.generations.id;


--
-- Name: images; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.images (
    id bigint NOT NULL,
    car_id bigint NOT NULL,
    lot_id bigint,
    images json,
    images_original_small json,
    images_original_normal json,
    images_original_big json,
    exterior json,
    exterior_original json,
    interior character varying(100),
    interior_original character varying(170),
    video_url character varying(170),
    external_panorama_url character varying(170),
    start_download_at timestamp(0) without time zone,
    end_download_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    youtube_id character varying(255),
    youtube_start_at timestamp(0) without time zone,
    youtube_end_at timestamp(0) without time zone
);


ALTER TABLE public.images OWNER TO forge;

--
-- Name: images_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.images_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.images_id_seq OWNER TO forge;

--
-- Name: images_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.images_id_seq OWNED BY public.images.id;


--
-- Name: locations; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.locations (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.locations OWNER TO forge;

--
-- Name: locations_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.locations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.locations_id_seq OWNER TO forge;

--
-- Name: locations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.locations_id_seq OWNED BY public.locations.id;


--
-- Name: lot_prices_old; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.lot_prices_old (
    id bigint NOT NULL,
    car_id bigint NOT NULL,
    lot_id bigint NOT NULL,
    sale_date timestamp(0) without time zone,
    bid double precision,
    buy_now_price double precision,
    final_price double precision,
    currency_id bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    status integer,
    parser_created_at timestamp(0) without time zone,
    parser_updated_at timestamp(0) without time zone
);


ALTER TABLE public.lot_prices_old OWNER TO forge;

--
-- Name: lot_prices_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.lot_prices_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.lot_prices_id_seq OWNER TO forge;

--
-- Name: lot_prices_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.lot_prices_id_seq OWNED BY public.lot_prices_old.id;


--
-- Name: lots; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.lots (
    id bigint NOT NULL,
    car_id bigint NOT NULL,
    lot character varying(40) NOT NULL,
    domain_id integer NOT NULL,
    odometer_km integer,
    odometer_mi integer,
    odometer_status integer,
    seller_id bigint,
    title_id bigint,
    main_damage_id bigint,
    second_damage_id bigint,
    keys_available boolean,
    airbags integer,
    condition integer,
    country_id bigint,
    state_id bigint,
    city_id bigint,
    location_id bigint,
    postal_code character varying(255),
    latitude double precision,
    longitude double precision,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    pre_accident_price double precision,
    clean_wholesale_price double precision,
    estimate_repair_price double precision,
    actual_cash_value double precision,
    sale_date timestamp(0) without time zone,
    bid double precision,
    buy_now_price double precision,
    currency_id bigint,
    status integer
);


ALTER TABLE public.lots OWNER TO forge;

--
-- Name: lots_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.lots_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.lots_id_seq OWNER TO forge;

--
-- Name: lots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.lots_id_seq OWNED BY public.lots.id;


--
-- Name: manufacturers; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.manufacturers (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    image character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    cars_qty integer,
    synonyms jsonb,
    display_on_site boolean DEFAULT true
);


ALTER TABLE public.manufacturers OWNER TO forge;

--
-- Name: manufacturers_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.manufacturers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturers_id_seq OWNER TO forge;

--
-- Name: manufacturers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.manufacturers_id_seq OWNED BY public.manufacturers.id;


--
-- Name: migrations; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.migrations (
    id integer NOT NULL,
    migration character varying(255) NOT NULL,
    batch integer NOT NULL
);


ALTER TABLE public.migrations OWNER TO forge;

--
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.migrations_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.migrations_id_seq OWNER TO forge;

--
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id;


--
-- Name: models; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.models (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    manufacturer_id bigint NOT NULL,
    cars_qty integer,
    synonyms jsonb
);


ALTER TABLE public.models OWNER TO forge;

--
-- Name: models_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.models_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.models_id_seq OWNER TO forge;

--
-- Name: models_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.models_id_seq OWNED BY public.models.id;


--
-- Name: nova_field_attachments; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.nova_field_attachments (
    id integer NOT NULL,
    attachable_type character varying(255) NOT NULL,
    attachable_id bigint NOT NULL,
    attachment character varying(255) NOT NULL,
    disk character varying(255) NOT NULL,
    url character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.nova_field_attachments OWNER TO forge;

--
-- Name: nova_field_attachments_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.nova_field_attachments_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.nova_field_attachments_id_seq OWNER TO forge;

--
-- Name: nova_field_attachments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.nova_field_attachments_id_seq OWNED BY public.nova_field_attachments.id;


--
-- Name: nova_notifications; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.nova_notifications (
    id uuid NOT NULL,
    type character varying(255) NOT NULL,
    notifiable_type character varying(255) NOT NULL,
    notifiable_id bigint NOT NULL,
    data text NOT NULL,
    read_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.nova_notifications OWNER TO forge;

--
-- Name: nova_pending_field_attachments; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.nova_pending_field_attachments (
    id integer NOT NULL,
    draft_id character varying(255) NOT NULL,
    attachment character varying(255) NOT NULL,
    disk character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.nova_pending_field_attachments OWNER TO forge;

--
-- Name: nova_pending_field_attachments_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.nova_pending_field_attachments_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.nova_pending_field_attachments_id_seq OWNER TO forge;

--
-- Name: nova_pending_field_attachments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.nova_pending_field_attachments_id_seq OWNED BY public.nova_pending_field_attachments.id;


--
-- Name: nova_settings; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.nova_settings (
    key character varying(255) NOT NULL,
    value text
);


ALTER TABLE public.nova_settings OWNER TO forge;

--
-- Name: password_reset_tokens; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.password_reset_tokens (
    email character varying(255) NOT NULL,
    token character varying(255) NOT NULL,
    created_at timestamp(0) without time zone
);


ALTER TABLE public.password_reset_tokens OWNER TO forge;

--
-- Name: personal_access_tokens; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.personal_access_tokens (
    id bigint NOT NULL,
    tokenable_type character varying(255) NOT NULL,
    tokenable_id bigint NOT NULL,
    name character varying(255) NOT NULL,
    token character varying(64) NOT NULL,
    abilities text,
    last_used_at timestamp(0) without time zone,
    expires_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.personal_access_tokens OWNER TO forge;

--
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.personal_access_tokens_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.personal_access_tokens_id_seq OWNER TO forge;

--
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.personal_access_tokens_id_seq OWNED BY public.personal_access_tokens.id;


--
-- Name: sellers; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.sellers (
    id bigint NOT NULL,
    name character varying(200),
    insurance boolean,
    logo character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    cars_qty integer,
    synonyms jsonb,
    facebook character varying(255),
    instagram character varying(255),
    twitter character varying(255),
    website character varying(255),
    is_credit_company boolean,
    is_rental boolean
);


ALTER TABLE public.sellers OWNER TO forge;

--
-- Name: sellers_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.sellers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sellers_id_seq OWNER TO forge;

--
-- Name: sellers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.sellers_id_seq OWNED BY public.sellers.id;


--
-- Name: sitemaps; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.sitemaps (
    id bigint NOT NULL,
    file_name character varying(70) NOT NULL,
    links_qty integer DEFAULT 0 NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sitemaps OWNER TO forge;

--
-- Name: sitemaps_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.sitemaps_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sitemaps_id_seq OWNER TO forge;

--
-- Name: sitemaps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.sitemaps_id_seq OWNED BY public.sitemaps.id;


--
-- Name: states; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.states (
    id bigint NOT NULL,
    country_id bigint,
    code character varying(10),
    name character varying(70),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.states OWNER TO forge;

--
-- Name: states_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.states_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.states_id_seq OWNER TO forge;

--
-- Name: states_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.states_id_seq OWNED BY public.states.id;


--
-- Name: titles; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.titles (
    id bigint NOT NULL,
    code character varying(10),
    name character varying(150) NOT NULL,
    name_i18n character varying(150),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.titles OWNER TO forge;

--
-- Name: titles_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.titles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.titles_id_seq OWNER TO forge;

--
-- Name: titles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.titles_id_seq OWNED BY public.titles.id;


--
-- Name: users; Type: TABLE; Schema: public; Owner: forge
--

CREATE TABLE public.users (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    email character varying(255) NOT NULL,
    email_verified_at timestamp(0) without time zone,
    password character varying(255) NOT NULL,
    remember_token character varying(100),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.users OWNER TO forge;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: forge
--

CREATE SEQUENCE public.users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.users_id_seq OWNER TO forge;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: forge
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- Name: action_events id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.action_events ALTER COLUMN id SET DEFAULT nextval('public.action_events_id_seq'::regclass);


--
-- Name: call_requests id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.call_requests ALTER COLUMN id SET DEFAULT nextval('public.call_requests_id_seq'::regclass);


--
-- Name: cars id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cars ALTER COLUMN id SET DEFAULT nextval('public.cars_id_seq1'::regclass);


--
-- Name: categories id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.categories ALTER COLUMN id SET DEFAULT nextval('public.categories_id_seq'::regclass);


--
-- Name: cities id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cities ALTER COLUMN id SET DEFAULT nextval('public.cities_id_seq'::regclass);


--
-- Name: countries id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.countries ALTER COLUMN id SET DEFAULT nextval('public.countries_id_seq'::regclass);


--
-- Name: currencies id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.currencies ALTER COLUMN id SET DEFAULT nextval('public.currencies_id_seq'::regclass);


--
-- Name: damages id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.damages ALTER COLUMN id SET DEFAULT nextval('public.damages_id_seq'::regclass);


--
-- Name: engines id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.engines ALTER COLUMN id SET DEFAULT nextval('public.engines_id_seq'::regclass);


--
-- Name: failed_jobs id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.failed_jobs ALTER COLUMN id SET DEFAULT nextval('public.failed_jobs_id_seq'::regclass);


--
-- Name: generations id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.generations ALTER COLUMN id SET DEFAULT nextval('public.generations_id_seq'::regclass);


--
-- Name: images id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.images ALTER COLUMN id SET DEFAULT nextval('public.images_id_seq'::regclass);


--
-- Name: locations id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.locations ALTER COLUMN id SET DEFAULT nextval('public.locations_id_seq'::regclass);


--
-- Name: lot_prices_old id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lot_prices_old ALTER COLUMN id SET DEFAULT nextval('public.lot_prices_id_seq'::regclass);


--
-- Name: lots id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots ALTER COLUMN id SET DEFAULT nextval('public.lots_id_seq'::regclass);


--
-- Name: manufacturers id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.manufacturers ALTER COLUMN id SET DEFAULT nextval('public.manufacturers_id_seq'::regclass);


--
-- Name: migrations id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.migrations ALTER COLUMN id SET DEFAULT nextval('public.migrations_id_seq'::regclass);


--
-- Name: models id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.models ALTER COLUMN id SET DEFAULT nextval('public.models_id_seq'::regclass);


--
-- Name: nova_field_attachments id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.nova_field_attachments ALTER COLUMN id SET DEFAULT nextval('public.nova_field_attachments_id_seq'::regclass);


--
-- Name: nova_pending_field_attachments id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.nova_pending_field_attachments ALTER COLUMN id SET DEFAULT nextval('public.nova_pending_field_attachments_id_seq'::regclass);


--
-- Name: personal_access_tokens id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.personal_access_tokens ALTER COLUMN id SET DEFAULT nextval('public.personal_access_tokens_id_seq'::regclass);


--
-- Name: sellers id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.sellers ALTER COLUMN id SET DEFAULT nextval('public.sellers_id_seq'::regclass);


--
-- Name: sitemaps id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.sitemaps ALTER COLUMN id SET DEFAULT nextval('public.sitemaps_id_seq'::regclass);


--
-- Name: states id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.states ALTER COLUMN id SET DEFAULT nextval('public.states_id_seq'::regclass);


--
-- Name: titles id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.titles ALTER COLUMN id SET DEFAULT nextval('public.titles_id_seq'::regclass);


--
-- Name: users id; Type: DEFAULT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);


--
-- Name: action_events action_events_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.action_events
    ADD CONSTRAINT action_events_pkey PRIMARY KEY (id);


--
-- Name: call_requests call_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.call_requests
    ADD CONSTRAINT call_requests_pkey PRIMARY KEY (id);


--
-- Name: car_category car_category_car_id_category_id_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.car_category
    ADD CONSTRAINT car_category_car_id_category_id_unique UNIQUE (car_id, category_id);


--
-- Name: cars cars_pkey1; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cars
    ADD CONSTRAINT cars_pkey1 PRIMARY KEY (id);


--
-- Name: cars cars_vin_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cars
    ADD CONSTRAINT cars_vin_unique UNIQUE (vin);


--
-- Name: categories categories_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_pkey PRIMARY KEY (id);


--
-- Name: cities cities_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_pkey PRIMARY KEY (id);


--
-- Name: countries countries_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.countries
    ADD CONSTRAINT countries_pkey PRIMARY KEY (id);


--
-- Name: currencies currencies_code_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.currencies
    ADD CONSTRAINT currencies_code_unique UNIQUE (code);


--
-- Name: currencies currencies_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.currencies
    ADD CONSTRAINT currencies_pkey PRIMARY KEY (id);


--
-- Name: damages damages_name_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.damages
    ADD CONSTRAINT damages_name_unique UNIQUE (name);


--
-- Name: damages damages_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.damages
    ADD CONSTRAINT damages_pkey PRIMARY KEY (id);


--
-- Name: engines engines_name_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.engines
    ADD CONSTRAINT engines_name_unique UNIQUE (name);


--
-- Name: engines engines_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.engines
    ADD CONSTRAINT engines_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);


--
-- Name: generations generation_unique_id; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.generations
    ADD CONSTRAINT generation_unique_id UNIQUE (id);


--
-- Name: generations generations_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.generations
    ADD CONSTRAINT generations_pkey PRIMARY KEY (id);


--
-- Name: images images_car_id_lot_id_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.images
    ADD CONSTRAINT images_car_id_lot_id_unique UNIQUE (car_id, lot_id);


--
-- Name: images images_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.images
    ADD CONSTRAINT images_pkey PRIMARY KEY (id);


--
-- Name: locations locations_name_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.locations
    ADD CONSTRAINT locations_name_unique UNIQUE (name);


--
-- Name: locations locations_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.locations
    ADD CONSTRAINT locations_pkey PRIMARY KEY (id);


--
-- Name: lot_prices_old lot_prices_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lot_prices_old
    ADD CONSTRAINT lot_prices_pkey PRIMARY KEY (id);


--
-- Name: lots lots_lot_domain_id_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_lot_domain_id_unique UNIQUE (lot, domain_id);


--
-- Name: lots lots_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_pkey PRIMARY KEY (id);


--
-- Name: manufacturers manufacturer_unique_id; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.manufacturers
    ADD CONSTRAINT manufacturer_unique_id UNIQUE (id);


--
-- Name: manufacturers manufacturers_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.manufacturers
    ADD CONSTRAINT manufacturers_pkey PRIMARY KEY (id);


--
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);


--
-- Name: models model_unique_id; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.models
    ADD CONSTRAINT model_unique_id UNIQUE (id);


--
-- Name: models models_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.models
    ADD CONSTRAINT models_pkey PRIMARY KEY (id);


--
-- Name: nova_field_attachments nova_field_attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.nova_field_attachments
    ADD CONSTRAINT nova_field_attachments_pkey PRIMARY KEY (id);


--
-- Name: nova_notifications nova_notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.nova_notifications
    ADD CONSTRAINT nova_notifications_pkey PRIMARY KEY (id);


--
-- Name: nova_pending_field_attachments nova_pending_field_attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.nova_pending_field_attachments
    ADD CONSTRAINT nova_pending_field_attachments_pkey PRIMARY KEY (id);


--
-- Name: nova_settings nova_settings_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.nova_settings
    ADD CONSTRAINT nova_settings_pkey PRIMARY KEY (key);


--
-- Name: password_reset_tokens password_reset_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.password_reset_tokens
    ADD CONSTRAINT password_reset_tokens_pkey PRIMARY KEY (email);


--
-- Name: personal_access_tokens personal_access_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.personal_access_tokens
    ADD CONSTRAINT personal_access_tokens_pkey PRIMARY KEY (id);


--
-- Name: personal_access_tokens personal_access_tokens_token_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.personal_access_tokens
    ADD CONSTRAINT personal_access_tokens_token_unique UNIQUE (token);


--
-- Name: sellers sellers_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.sellers
    ADD CONSTRAINT sellers_pkey PRIMARY KEY (id);


--
-- Name: sitemaps sitemaps_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.sitemaps
    ADD CONSTRAINT sitemaps_pkey PRIMARY KEY (id);


--
-- Name: states states_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.states
    ADD CONSTRAINT states_pkey PRIMARY KEY (id);


--
-- Name: titles titles_name_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.titles
    ADD CONSTRAINT titles_name_unique UNIQUE (name);


--
-- Name: titles titles_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.titles
    ADD CONSTRAINT titles_pkey PRIMARY KEY (id);


--
-- Name: users users_email_unique; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_unique UNIQUE (email);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: action_events_actionable_type_actionable_id_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX action_events_actionable_type_actionable_id_index ON public.action_events USING btree (actionable_type, actionable_id);


--
-- Name: action_events_batch_id_model_type_model_id_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX action_events_batch_id_model_type_model_id_index ON public.action_events USING btree (batch_id, model_type, model_id);


--
-- Name: action_events_target_type_target_id_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX action_events_target_type_target_id_index ON public.action_events USING btree (target_type, target_id);


--
-- Name: action_events_user_id_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX action_events_user_id_index ON public.action_events USING btree (user_id);


--
-- Name: car_category_car_id_category_id_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX car_category_car_id_category_id_index ON public.car_category USING btree (car_id, category_id);


--
-- Name: cars_brands_id; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX cars_brands_id ON public.cars USING btree (manufacturer_id, model_id, generation_id);


--
-- Name: lot_prices_car_id_lot_id_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX lot_prices_car_id_lot_id_index ON public.lot_prices_old USING btree (car_id, lot_id);


--
-- Name: lots_odometer_km_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX lots_odometer_km_index ON public.lots USING btree (odometer_km);


--
-- Name: nova_field_attachments_attachable_type_attachable_id_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX nova_field_attachments_attachable_type_attachable_id_index ON public.nova_field_attachments USING btree (attachable_type, attachable_id);


--
-- Name: nova_field_attachments_url_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX nova_field_attachments_url_index ON public.nova_field_attachments USING btree (url);


--
-- Name: nova_notifications_notifiable_type_notifiable_id_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX nova_notifications_notifiable_type_notifiable_id_index ON public.nova_notifications USING btree (notifiable_type, notifiable_id);


--
-- Name: nova_pending_field_attachments_draft_id_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX nova_pending_field_attachments_draft_id_index ON public.nova_pending_field_attachments USING btree (draft_id);


--
-- Name: personal_access_tokens_tokenable_type_tokenable_id_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX personal_access_tokens_tokenable_type_tokenable_id_index ON public.personal_access_tokens USING btree (tokenable_type, tokenable_id);


--
-- Name: price_lots_index; Type: INDEX; Schema: public; Owner: forge
--

CREATE INDEX price_lots_index ON public.lots USING btree (bid, buy_now_price, status);


--
-- Name: call_requests call_requests_car_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.call_requests
    ADD CONSTRAINT call_requests_car_id_foreign FOREIGN KEY (car_id) REFERENCES public.cars(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: car_category car_category_car_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.car_category
    ADD CONSTRAINT car_category_car_id_foreign FOREIGN KEY (car_id) REFERENCES public.cars(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: car_category car_category_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.car_category
    ADD CONSTRAINT car_category_category_id_foreign FOREIGN KEY (category_id) REFERENCES public.categories(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: cars cars_engine_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cars
    ADD CONSTRAINT cars_engine_id_foreign FOREIGN KEY (engine_id) REFERENCES public.engines(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: cars cars_generation_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cars
    ADD CONSTRAINT cars_generation_id_foreign FOREIGN KEY (generation_id) REFERENCES public.generations(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: cars cars_manufacturer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cars
    ADD CONSTRAINT cars_manufacturer_id_foreign FOREIGN KEY (manufacturer_id) REFERENCES public.manufacturers(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: cars cars_model_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cars
    ADD CONSTRAINT cars_model_id_foreign FOREIGN KEY (model_id) REFERENCES public.models(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: cars cars_sitemap_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cars
    ADD CONSTRAINT cars_sitemap_id_foreign FOREIGN KEY (sitemap_id) REFERENCES public.sitemaps(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: cities cities_country_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_country_id_foreign FOREIGN KEY (country_id) REFERENCES public.countries(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: cities cities_state_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_state_id_foreign FOREIGN KEY (state_id) REFERENCES public.states(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: generations generations_manufacturer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.generations
    ADD CONSTRAINT generations_manufacturer_id_foreign FOREIGN KEY (manufacturer_id) REFERENCES public.manufacturers(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: generations generations_model_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.generations
    ADD CONSTRAINT generations_model_id_foreign FOREIGN KEY (model_id) REFERENCES public.models(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: images images_car_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.images
    ADD CONSTRAINT images_car_id_foreign FOREIGN KEY (car_id) REFERENCES public.cars(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: images images_lot_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.images
    ADD CONSTRAINT images_lot_id_foreign FOREIGN KEY (lot_id) REFERENCES public.lots(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: lot_prices_old lot_prices_car_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lot_prices_old
    ADD CONSTRAINT lot_prices_car_id_foreign FOREIGN KEY (car_id) REFERENCES public.cars(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: lot_prices_old lot_prices_currency_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lot_prices_old
    ADD CONSTRAINT lot_prices_currency_id_foreign FOREIGN KEY (currency_id) REFERENCES public.currencies(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: lot_prices_old lot_prices_lot_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lot_prices_old
    ADD CONSTRAINT lot_prices_lot_id_foreign FOREIGN KEY (lot_id) REFERENCES public.lots(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: lots lots_car_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_car_id_foreign FOREIGN KEY (car_id) REFERENCES public.cars(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: lots lots_city_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_city_id_foreign FOREIGN KEY (city_id) REFERENCES public.cities(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: lots lots_country_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_country_id_foreign FOREIGN KEY (country_id) REFERENCES public.countries(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: lots lots_currency_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_currency_id_foreign FOREIGN KEY (currency_id) REFERENCES public.currencies(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: lots lots_location_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_location_id_foreign FOREIGN KEY (location_id) REFERENCES public.locations(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: lots lots_main_damage_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_main_damage_id_foreign FOREIGN KEY (main_damage_id) REFERENCES public.damages(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: lots lots_second_damage_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_second_damage_id_foreign FOREIGN KEY (second_damage_id) REFERENCES public.damages(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: lots lots_seller_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_seller_id_foreign FOREIGN KEY (seller_id) REFERENCES public.sellers(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: lots lots_state_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_state_id_foreign FOREIGN KEY (state_id) REFERENCES public.states(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: lots lots_title_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.lots
    ADD CONSTRAINT lots_title_id_foreign FOREIGN KEY (title_id) REFERENCES public.titles(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: models models_manufacturer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.models
    ADD CONSTRAINT models_manufacturer_id_foreign FOREIGN KEY (manufacturer_id) REFERENCES public.manufacturers(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: states states_country_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: forge
--

ALTER TABLE ONLY public.states
    ADD CONSTRAINT states_country_id_foreign FOREIGN KEY (country_id) REFERENCES public.countries(id) ON DELETE CASCADE;


--
-- PostgreSQL database dump complete
--

INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (1, 'USD', '$', '$', 2, 'US Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (2, 'CAD', 'CA$', '$', 2, 'Canadian Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (3, 'EUR', '€', '€', 2, 'Euro');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (4, 'AED', 'AED', 'د.إ.‏', 2, 'United Arab Emirates Dirham');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (5, 'AFN', 'Af', '؋', 0, 'Afghan Afghani');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (6, 'ALL', 'ALL', 'Lek', 0, 'Albanian Lek');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (7, 'AMD', 'AMD', 'դր.', 0, 'Armenian Dram');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (8, 'ARS', 'AR$', '$', 2, 'Argentine Peso');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (9, 'AUD', 'AU$', '$', 2, 'Australian Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (10, 'AZN', 'man.', 'ман.', 2, 'Azerbaijani Manat');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (11, 'BAM', 'KM', 'KM', 2, 'Bosnia-Herzegovina Convertible Mark');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (12, 'BDT', 'Tk', '৳', 2, 'Bangladeshi Taka');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (13, 'BGN', 'BGN', 'лв.', 2, 'Bulgarian Lev');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (14, 'BHD', 'BD', 'د.ب.‏', 3, 'Bahraini Dinar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (15, 'BIF', 'FBu', 'FBu', 0, 'Burundian Franc');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (16, 'BND', 'BN$', '$', 2, 'Brunei Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (17, 'BOB', 'Bs', 'Bs', 2, 'Bolivian Boliviano');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (18, 'BRL', 'R$', 'R$', 2, 'Brazilian Real');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (19, 'BWP', 'BWP', 'P', 2, 'Botswanan Pula');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (20, 'BYN', 'Br', 'руб.', 2, 'Belarusian Ruble');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (21, 'BZD', 'BZ$', '$', 2, 'Belize Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (22, 'CDF', 'CDF', 'FrCD', 2, 'Congolese Franc');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (23, 'CHF', 'CHF', 'CHF', 2, 'Swiss Franc');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (24, 'CLP', 'CL$', '$', 0, 'Chilean Peso');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (25, 'CNY', 'CN¥', 'CN¥', 2, 'Chinese Yuan');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (26, 'COP', 'CO$', '$', 0, 'Colombian Peso');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (27, 'CRC', '₡', '₡', 0, 'Costa Rican Colón');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (28, 'CVE', 'CV$', 'CV$', 2, 'Cape Verdean Escudo');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (29, 'CZK', 'Kč', 'Kč', 2, 'Czech Republic Koruna');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (30, 'DJF', 'Fdj', 'Fdj', 0, 'Djiboutian Franc');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (31, 'DKK', 'Dkr', 'kr', 2, 'Danish Krone');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (32, 'DOP', 'RD$', 'RD$', 2, 'Dominican Peso');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (33, 'DZD', 'DA', 'د.ج.‏', 2, 'Algerian Dinar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (34, 'EEK', 'Ekr', 'kr', 2, 'Estonian Kroon');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (35, 'EGP', 'EGP', 'ج.م.‏', 2, 'Egyptian Pound');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (36, 'ERN', 'Nfk', 'Nfk', 2, 'Eritrean Nakfa');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (37, 'ETB', 'Br', 'Br', 2, 'Ethiopian Birr');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (38, 'GBP', '£', '£', 2, 'British Pound Sterling');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (39, 'GEL', 'GEL', 'GEL', 2, 'Georgian Lari');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (40, 'GHS', 'GH₵', 'GH₵', 2, 'Ghanaian Cedi');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (41, 'GNF', 'FG', 'FG', 0, 'Guinean Franc');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (42, 'GTQ', 'GTQ', 'Q', 2, 'Guatemalan Quetzal');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (43, 'HKD', 'HK$', '$', 2, 'Hong Kong Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (44, 'HNL', 'HNL', 'L', 2, 'Honduran Lempira');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (45, 'HRK', 'kn', 'kn', 2, 'Croatian Kuna');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (46, 'HUF', 'Ft', 'Ft', 0, 'Hungarian Forint');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (47, 'IDR', 'Rp', 'Rp', 0, 'Indonesian Rupiah');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (48, 'ILS', '₪', '₪', 2, 'Israeli New Sheqel');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (49, 'INR', '₹', 'रुपया', 2, 'Indian Rupee');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (50, 'IQD', 'IQD', 'د.ع.‏', 0, 'Iraqi Dinar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (51, 'IRR', 'IRR', '﷼', 0, 'Iranian Rial');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (52, 'ISK', 'Ikr', 'kr', 0, 'Icelandic Króna');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (53, 'JMD', 'J$', '$', 2, 'Jamaican Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (54, 'JOD', 'JD', 'د.أ.‏', 3, 'Jordanian Dinar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (55, 'JPY', '¥', '￥', 0, 'Japanese Yen');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (56, 'KES', 'Ksh', 'Ksh', 2, 'Kenyan Shilling');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (57, 'KHR', 'KHR', '៛', 2, 'Cambodian Riel');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (58, 'KMF', 'CF', 'FC', 0, 'Comorian Franc');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (59, 'KRW', '₩', '₩', 0, 'South Korean Won');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (60, 'KWD', 'KD', 'د.ك.‏', 3, 'Kuwaiti Dinar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (61, 'KZT', 'KZT', '₸', 2, 'Kazakhstani Tenge');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (62, 'LBP', 'L.L.', 'ل.ل.‏', 0, 'Lebanese Pound');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (63, 'LKR', 'SLRs', 'SL Re', 2, 'Sri Lankan Rupee');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (64, 'LTL', 'Lt', 'Lt', 2, 'Lithuanian Litas');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (65, 'LVL', 'Ls', 'Ls', 2, 'Latvian Lats');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (66, 'LYD', 'LD', 'د.ل.‏', 3, 'Libyan Dinar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (67, 'MAD', 'MAD', 'د.م.‏', 2, 'Moroccan Dirham');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (68, 'MDL', 'MDL', 'MDL', 2, 'Moldovan Leu');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (69, 'MGA', 'MGA', 'MGA', 0, 'Malagasy Ariary');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (70, 'MKD', 'MKD', 'MKD', 2, 'Macedonian Denar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (71, 'MMK', 'MMK', 'K', 0, 'Myanma Kyat');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (72, 'MOP', 'MOP$', 'MOP$', 2, 'Macanese Pataca');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (73, 'MUR', 'MURs', 'MURs', 0, 'Mauritian Rupee');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (74, 'MXN', 'MX$', '$', 2, 'Mexican Peso');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (75, 'MYR', 'RM', 'RM', 2, 'Malaysian Ringgit');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (76, 'MZN', 'MTn', 'MTn', 2, 'Mozambican Metical');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (77, 'NAD', 'N$', 'N$', 2, 'Namibian Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (78, 'NGN', '₦', '₦', 2, 'Nigerian Naira');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (79, 'NIO', 'C$', 'C$', 2, 'Nicaraguan Córdoba');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (80, 'NOK', 'Nkr', 'kr', 2, 'Norwegian Krone');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (81, 'NPR', 'NPRs', 'नेरू', 2, 'Nepalese Rupee');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (82, 'NZD', 'NZ$', '$', 2, 'New Zealand Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (83, 'OMR', 'OMR', 'ر.ع.‏', 3, 'Omani Rial');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (84, 'PAB', 'B/.', 'B/.', 2, 'Panamanian Balboa');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (85, 'PEN', 'S/.', 'S/.', 2, 'Peruvian Nuevo Sol');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (86, 'PHP', '₱', '₱', 2, 'Philippine Peso');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (87, 'PKR', 'PKRs', '₨', 0, 'Pakistani Rupee');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (88, 'PLN', 'zł', 'zł', 2, 'Polish Zloty');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (89, 'PYG', '₲', '₲', 0, 'Paraguayan Guarani');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (90, 'QAR', 'QR', 'ر.ق.‏', 2, 'Qatari Rial');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (91, 'RON', 'RON', 'RON', 2, 'Romanian Leu');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (92, 'RSD', 'din.', 'дин.', 0, 'Serbian Dinar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (93, 'RUB', 'RUB', '₽.', 2, 'Russian Ruble');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (94, 'RWF', 'RWF', 'FR', 0, 'Rwandan Franc');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (95, 'SAR', 'SR', 'ر.س.‏', 2, 'Saudi Riyal');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (96, 'SDG', 'SDG', 'SDG', 2, 'Sudanese Pound');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (97, 'SEK', 'Skr', 'kr', 2, 'Swedish Krona');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (98, 'SGD', 'S$', '$', 2, 'Singapore Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (99, 'SOS', 'Ssh', 'Ssh', 0, 'Somali Shilling');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (100, 'SYP', 'SY£', 'ل.س.‏', 0, 'Syrian Pound');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (101, 'THB', '฿', '฿', 2, 'Thai Baht');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (102, 'TND', 'DT', 'د.ت.‏', 3, 'Tunisian Dinar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (103, 'TOP', 'T$', 'T$', 2, 'Tongan Paʻanga');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (104, 'TRY', 'TL', 'TL', 2, 'Turkish Lira');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (105, 'TTD', 'TT$', '$', 2, 'Trinidad and Tobago Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (106, 'TWD', 'NT$', 'NT$', 2, 'New Taiwan Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (107, 'TZS', 'TSh', 'TSh', 0, 'Tanzanian Shilling');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (108, 'UAH', '₴', '₴', 2, 'Ukrainian Hryvnia');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (109, 'UGX', 'USh', 'USh', 0, 'Ugandan Shilling');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (110, 'UYU', '$U', '$', 2, 'Uruguayan Peso');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (111, 'UZS', 'UZS', 'UZS', 0, 'Uzbekistan Som');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (112, 'VEF', 'Bs.F.', 'Bs.F.', 2, 'Venezuelan Bolívar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (113, 'VND', '₫', '₫', 0, 'Vietnamese Dong');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (114, 'XAF', 'FCFA', 'FCFA', 0, 'CFA Franc BEAC');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (115, 'XOF', 'CFA', 'CFA', 0, 'CFA Franc BCEAO');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (116, 'YER', 'YR', 'ر.ي.‏', 0, 'Yemeni Rial');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (117, 'ZAR', 'R', 'R', 2, 'South African Rand');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (118, 'ZMK', 'ZK', 'ZK', 0, 'Zambian Kwacha');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (119, 'ZWL', 'ZWL$', 'ZWL$', 0, 'Zimbabwean Dollar');
INSERT INTO public.currencies (id, code, symbol, symbol_native, decimal_digits, name) VALUES (120, 'CUP', '$', '$', 2, 'Cuban Peso');
