--
-- PostgreSQL database dump
--

\restrict rhlmVg0VsZcRnN1UQfbGsebFUHaaJ5PgcaH5ShQmqjuglM1a1NdXaKMZ2uzEoac

-- Dumped from database version 17.9
-- Dumped by pg_dump version 17.8

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_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;

--
-- Name: citext; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;


--
-- Name: EXTENSION citext; Type: COMMENT; Schema: -; Owner: -
--

COMMENT ON EXTENSION citext IS 'data type for case-insensitive character strings';


SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: accounts; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.accounts (
    id bigint NOT NULL,
    game character varying(255) NOT NULL,
    account_name character varying(255) NOT NULL,
    account_password text NOT NULL,
    additional_information jsonb NOT NULL,
    rank_updated_at timestamp(0) without time zone DEFAULT '2024-08-20 19:25:47.191917'::timestamp without time zone NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    checker_last_check timestamp(0) without time zone,
    checker_status integer DEFAULT 0 NOT NULL,
    account_email character varying(255),
    account_email_password text,
    account_email_provider_link character varying(255)
);


--
-- Name: accounts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: accounts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.accounts_id_seq OWNED BY public.accounts.id;


--
-- Name: audits; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.audits (
    id bigint NOT NULL,
    user_type character varying(255),
    user_id bigint,
    event character varying(255) NOT NULL,
    auditable_type character varying(255) NOT NULL,
    auditable_id bigint NOT NULL,
    old_values jsonb,
    new_values jsonb,
    url text,
    ip_address inet,
    user_agent character varying(1023),
    tags character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: audits_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: audits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.audits_id_seq OWNED BY public.audits.id;


--
-- Name: authentication_logs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.authentication_logs (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    ip_address character varying(255) NOT NULL,
    user_agent text,
    login_at timestamp(0) without time zone NOT NULL,
    visitor_id character varying(255),
    country_code character varying(2) DEFAULT 'XX'::character varying NOT NULL,
    is_impersonation boolean DEFAULT false NOT NULL
);


--
-- Name: authentication_log_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: authentication_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.authentication_log_id_seq OWNED BY public.authentication_logs.id;


--
-- Name: bans; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.bans (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    banned_by_id bigint,
    reason text NOT NULL,
    note text,
    expires_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: bans_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: bans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.bans_id_seq OWNED BY public.bans.id;


--
-- Name: blacklisted_values; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.blacklisted_values (
    id bigint NOT NULL,
    key character varying(255) NOT NULL,
    value text NOT NULL,
    source character varying(255) NOT NULL,
    reason character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: blacklisted_values_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: blacklisted_values_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.blacklisted_values_id_seq OWNED BY public.blacklisted_values.id;


--
-- Name: boosts; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.boosts (
    id integer NOT NULL,
    user_id bigint,
    price numeric(10,2) NOT NULL,
    status smallint DEFAULT 8 NOT NULL,
    booster_id integer,
    paid boolean DEFAULT false NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    currency character varying(255) DEFAULT 'EUR'::character varying NOT NULL,
    hidden boolean DEFAULT false NOT NULL,
    description text,
    percentage numeric(3,2) DEFAULT 0.5 NOT NULL,
    user_schedule text,
    booster_schedule text,
    last_poke_at timestamp(0) without time zone,
    username text,
    password text,
    summonername character varying(255),
    enquiry jsonb NOT NULL,
    reservation_expires_at timestamp(0) without time zone,
    reservation_extended boolean DEFAULT false NOT NULL,
    user_ready_to_play_expires_at timestamp(0) with time zone,
    booster_ready_to_play_expires_at timestamp(0) with time zone,
    "teammateName" character varying(255)
);


--
-- Name: boosts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: boosts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.boosts_id_seq OWNED BY public.boosts.id;


--
-- Name: bulk_accounts; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.bulk_accounts (
    id bigint NOT NULL,
    offer_id integer NOT NULL,
    username character varying(255) NOT NULL,
    password character varying(255) NOT NULL,
    deleted_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: bulk_accounts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: bulk_accounts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.bulk_accounts_id_seq OWNED BY public.bulk_accounts.id;


--
-- Name: cache; Type: TABLE; Schema: public; Owner: -
--

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


--
-- Name: chat_conversation_user_states; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.chat_conversation_user_states (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    service_type character varying(255) NOT NULL,
    service_id bigint NOT NULL,
    last_read_at timestamp(0) without time zone,
    has_unread boolean DEFAULT false NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: chat_conversation_user_states_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: chat_conversation_user_states_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.chat_conversation_user_states_id_seq OWNED BY public.chat_conversation_user_states.id;


--
-- Name: chat_messages; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.chat_messages (
    id integer NOT NULL,
    message text,
    user_id integer NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    service_type character varying(255) NOT NULL,
    service_id bigint NOT NULL,
    system_message boolean DEFAULT false NOT NULL,
    seen_at timestamp(0) without time zone,
    title text
);


--
-- Name: chat_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: chat_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.chat_messages_id_seq OWNED BY public.chat_messages.id;


--
-- Name: coachings; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.coachings (
    id integer NOT NULL,
    user_id integer,
    booster_id integer,
    price numeric(10,2) NOT NULL,
    currency character varying(255) NOT NULL,
    status integer DEFAULT 0 NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    user_schedule text,
    booster_schedule text,
    paid boolean DEFAULT false NOT NULL,
    percentage numeric(10,2) DEFAULT 0.5 NOT NULL,
    description text,
    last_poke_at timestamp(0) without time zone,
    enquiry jsonb NOT NULL,
    reservation_expires_at timestamp(0) without time zone,
    reservation_extended boolean DEFAULT false NOT NULL
);


--
-- Name: coachings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: coachings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.coachings_id_seq OWNED BY public.coachings.id;


--
-- Name: coupons; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.coupons (
    id integer NOT NULL,
    body character varying(255) NOT NULL,
    discount numeric(4,2) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    type integer DEFAULT 0 NOT NULL,
    uses_left integer,
    useable_till timestamp(0) without time zone,
    description text
);


--
-- Name: coupons_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: coupons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.coupons_id_seq OWNED BY public.coupons.id;


--
-- Name: disputes; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.disputes (
    id bigint NOT NULL,
    status smallint DEFAULT '0'::smallint NOT NULL,
    reason smallint NOT NULL,
    description text,
    freeze_days_left integer,
    disputable_old_status integer NOT NULL,
    seller_wallet_was_moved_to_security_deposit boolean DEFAULT false NOT NULL,
    admin_id bigint,
    last_status_change_at timestamp(0) with time zone DEFAULT now() NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    disputable_type character varying(255) NOT NULL,
    disputable_id bigint NOT NULL
);


--
-- Name: disputes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: disputes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.disputes_id_seq OWNED BY public.disputes.id;


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

CREATE TABLE public.failed_jobs (
    id integer 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,
    uuid character varying(255)
);


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

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


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

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


--
-- Name: favourite_contractors; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.favourite_contractors (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    contractor_id bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: favourite_contractors_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: favourite_contractors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.favourite_contractors_id_seq OWNED BY public.favourite_contractors.id;


--
-- Name: freeze_logs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.freeze_logs (
    id integer NOT NULL,
    user_id integer NOT NULL,
    amount numeric(10,2) NOT NULL,
    currency character varying(255) NOT NULL,
    expire_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    freezable_type character varying(255) NOT NULL,
    freezable_id bigint NOT NULL
);


--
-- Name: freeze_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: freeze_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.freeze_logs_id_seq OWNED BY public.freeze_logs.id;


--
-- Name: jobs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.jobs (
    id bigint NOT NULL,
    queue character varying(255) NOT NULL,
    payload text NOT NULL,
    attempts smallint NOT NULL,
    reserved_at integer,
    available_at integer NOT NULL,
    created_at integer NOT NULL
);


--
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;


--
-- Name: labels; Type: TABLE; Schema: public; Owner: -
--

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


--
-- Name: labels_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: labels_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.labels_id_seq OWNED BY public.labels.id;


--
-- Name: marketplace_fees; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.marketplace_fees (
    id bigint NOT NULL,
    type character varying(255) NOT NULL,
    game character varying(255) NOT NULL,
    seller_type character varying(255),
    data jsonb NOT NULL,
    user_id bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    subject character varying(255) NOT NULL
);


--
-- Name: marketplace_fees_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: marketplace_fees_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.marketplace_fees_id_seq OWNED BY public.marketplace_fees.id;


--
-- Name: marketplace_galleries; Type: TABLE; Schema: public; Owner: -
--

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


--
-- Name: marketplace_galleries_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: marketplace_galleries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.marketplace_galleries_id_seq OWNED BY public.marketplace_galleries.id;


--
-- Name: marketplace_items; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.marketplace_items (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    buyer_id bigint,
    game character varying(255) NOT NULL,
    currency character varying(255) NOT NULL,
    delivery_instruction text NOT NULL,
    delivery_time character varying(255) NOT NULL,
    details jsonb NOT NULL,
    title character varying(255) NOT NULL,
    description text NOT NULL,
    status character varying(255) NOT NULL,
    price_seller integer NOT NULL,
    price_public integer NOT NULL,
    bought_at timestamp(0) without time zone,
    warranty_days integer,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    quantity integer DEFAULT 1 NOT NULL
);


--
-- Name: marketplace_items_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: marketplace_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.marketplace_items_id_seq OWNED BY public.marketplace_items.id;


--
-- Name: media; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.media (
    id bigint NOT NULL,
    model_type character varying(255) NOT NULL,
    model_id bigint NOT NULL,
    uuid uuid,
    collection_name character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    file_name character varying(255) NOT NULL,
    mime_type character varying(255),
    disk character varying(255) NOT NULL,
    conversions_disk character varying(255),
    size bigint NOT NULL,
    manipulations json NOT NULL,
    custom_properties json NOT NULL,
    generated_conversions json NOT NULL,
    responsive_images json NOT NULL,
    order_column integer,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: media_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: media_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.media_id_seq OWNED BY public.media.id;


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

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


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

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


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

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


--
-- Name: offer_orders; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.offer_orders (
    id bigint NOT NULL,
    offer_id bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    warranty_days integer NOT NULL
);


--
-- Name: offer_orders_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: offer_orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.offer_orders_id_seq OWNED BY public.offer_orders.id;


--
-- Name: offers; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.offers (
    id integer NOT NULL,
    user_id integer NOT NULL,
    buyer_id integer,
    description text NOT NULL,
    price_seller numeric(10,2) NOT NULL,
    currency character varying(255) NOT NULL,
    status integer DEFAULT 0 NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    price_public numeric(10,2),
    official boolean DEFAULT false NOT NULL,
    method character varying(255),
    accepted_at timestamp(0) without time zone,
    bought_at timestamp(0) without time zone,
    comfort boolean DEFAULT false NOT NULL,
    customized boolean DEFAULT false NOT NULL,
    levelup integer DEFAULT 0,
    verified boolean,
    expert_pick boolean DEFAULT false NOT NULL,
    rare boolean DEFAULT false NOT NULL,
    last_poke_at timestamp(0) without time zone,
    uuid uuid,
    in_game_name_changeable boolean,
    account_id bigint,
    dispute_marked_as_solved_at timestamp(0) with time zone,
    warranty_days integer,
    title character varying(255),
    searchable_vector tsvector GENERATED ALWAYS AS (to_tsvector('english'::regconfig, (((COALESCE(title, ''::character varying))::text || ' '::text) || COALESCE(description, ''::text)))) STORED
);


--
-- Name: offers_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: offers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.offers_id_seq OWNED BY public.offers.id;


--
-- Name: orders; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.orders (
    id integer NOT NULL,
    user_id integer,
    price numeric(10,2) NOT NULL,
    service_type character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    currency character varying(255) DEFAULT 'EUR'::character varying NOT NULL,
    email character varying(255),
    deleted_at timestamp(0) without time zone,
    hash character varying(255) NOT NULL,
    coupon character varying(255),
    buyer_country character varying(255),
    balance_partial_amount numeric(10,2),
    service_id bigint,
    method character varying(255),
    coupon_percentage_value numeric(4,2),
    recovery_email_sent_at timestamp(0) without time zone,
    quantity integer
);


--
-- Name: orders_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.orders_id_seq OWNED BY public.orders.id;


--
-- Name: password_resets; Type: TABLE; Schema: public; Owner: -
--

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


--
-- Name: payment_methods; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.payment_methods (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    method character varying(64) NOT NULL,
    details jsonb,
    status integer DEFAULT 0 NOT NULL,
    rejection_reason character varying(255),
    reviewed_by bigint,
    reviewed_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,
    sort_order integer DEFAULT 0 NOT NULL
);


--
-- Name: payment_methods_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: payment_methods_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.payment_methods_id_seq OWNED BY public.payment_methods.id;


--
-- Name: payments; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.payments (
    id bigint NOT NULL,
    price numeric(8,2) NOT NULL,
    currency character varying(255) NOT NULL,
    method character varying(255) NOT NULL,
    response jsonb NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: payments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: payments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.payments_id_seq OWNED BY public.payments.id;


--
-- Name: popup_reports; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.popup_reports (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    reporter_id bigint,
    boost_id bigint NOT NULL,
    reason character varying(255) NOT NULL,
    reason_label character varying(255),
    description text,
    resolved_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: popup_reports_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: popup_reports_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.popup_reports_id_seq OWNED BY public.popup_reports.id;


--
-- Name: post_categories; Type: TABLE; Schema: public; Owner: -
--

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


--
-- Name: post_categories_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: post_categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.post_categories_id_seq OWNED BY public.post_categories.id;


--
-- Name: post_label; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.post_label (
    id bigint NOT NULL,
    post_id bigint NOT NULL,
    label_id bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: post_label_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: post_label_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.post_label_id_seq OWNED BY public.post_label.id;


--
-- Name: posts; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.posts (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    content text NOT NULL,
    user_id integer NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    tags json NOT NULL,
    language character varying(255) DEFAULT 'en'::character varying NOT NULL,
    topics json,
    slug character varying(255),
    public boolean DEFAULT false NOT NULL,
    is_main boolean DEFAULT false NOT NULL,
    meta_title text,
    meta_description text
);


--
-- Name: posts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: posts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.posts_id_seq OWNED BY public.posts.id;


--
-- Name: profiles; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.profiles (
    id integer NOT NULL,
    user_id integer NOT NULL,
    description text,
    languages jsonb DEFAULT '[]'::jsonb NOT NULL,
    champions text DEFAULT '[]'::text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    servers text DEFAULT '[]'::text NOT NULL,
    valorant_agents text DEFAULT '[]'::text NOT NULL,
    booster_feature1 character varying(255),
    booster_feature2 character varying(255),
    booster_feature3 character varying(255),
    tft_servers text DEFAULT '[]'::text NOT NULL,
    valorant_servers text DEFAULT '[]'::text NOT NULL,
    booster_main_game character varying(255) DEFAULT 'lol'::character varying NOT NULL,
    overwatch_champions text DEFAULT '[]'::text NOT NULL,
    overwatch_servers text DEFAULT '[]'::text NOT NULL,
    overwatch_roles text DEFAULT '[]'::text NOT NULL,
    overwatch_platforms text DEFAULT '[]'::text NOT NULL,
    apex_characters text DEFAULT '[]'::text NOT NULL,
    apex_platforms text DEFAULT '[]'::text NOT NULL,
    rocket_platforms text DEFAULT '[]'::text NOT NULL,
    wildrift_champions text DEFAULT '[]'::text NOT NULL,
    wildrift_servers text DEFAULT '[]'::text NOT NULL,
    wildrift_roles text DEFAULT '[]'::text NOT NULL,
    role_primary character varying(255),
    role_secondary character varying(255),
    arc_raiders_platforms json
);


--
-- Name: profiles_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: profiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.profiles_id_seq OWNED BY public.profiles.id;


--
-- Name: rank_reservations; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.rank_reservations (
    id bigint NOT NULL,
    permission_name character varying(255) NOT NULL,
    service_type character varying(255) NOT NULL,
    game character varying(255) NOT NULL,
    factor_field character varying(255) NOT NULL,
    starting_factor character varying(255),
    ending_factor character varying(255),
    reservation_seconds integer,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    is_active boolean DEFAULT true NOT NULL
);


--
-- Name: rank_reservations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: rank_reservations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.rank_reservations_id_seq OWNED BY public.rank_reservations.id;


--
-- Name: reasons; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.reasons (
    id integer NOT NULL,
    boost_id integer,
    reason text NOT NULL,
    user_id integer NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    coaching_id integer,
    type character varying(255) DEFAULT 'boost'::character varying NOT NULL,
    by_customer boolean DEFAULT false NOT NULL,
    no_progress_description text
);


--
-- Name: reasons_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: reasons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.reasons_id_seq OWNED BY public.reasons.id;


--
-- Name: rental_account_rentals; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.rental_account_rentals (
    id bigint NOT NULL,
    rental_account_id bigint NOT NULL,
    user_id bigint NOT NULL,
    reason character varying(255),
    rented_at timestamp(0) without time zone DEFAULT '2024-08-20 19:25:47.191917'::timestamp without time zone NOT NULL,
    returns_at timestamp(0) without time zone,
    boost_id bigint,
    extended boolean DEFAULT false NOT NULL,
    zippy_purchase_id bigint
);


--
-- Name: rental_account_rentals_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: rental_account_rentals_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.rental_account_rentals_id_seq OWNED BY public.rental_account_rentals.id;


--
-- Name: rental_accounts; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.rental_accounts (
    id bigint NOT NULL,
    account_id bigint,
    banned_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: rental_accounts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: rental_accounts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.rental_accounts_id_seq OWNED BY public.rental_accounts.id;


--
-- Name: reviews; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.reviews (
    id integer NOT NULL,
    boost_id integer,
    user_id integer NOT NULL,
    status integer DEFAULT 0 NOT NULL,
    contents text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    hash character varying(255) DEFAULT 'not_set'::character varying NOT NULL,
    coaching_id integer,
    offer_id integer,
    rating integer,
    rated_at timestamp(0) without time zone,
    approved_at timestamp(0) without time zone,
    zippy_purchase_id bigint,
    marketplace_item_id bigint,
    CONSTRAINT only_one_filled CHECK ((((((((boost_id IS NOT NULL))::integer + ((coaching_id IS NOT NULL))::integer) + ((offer_id IS NOT NULL))::integer) + ((zippy_purchase_id IS NOT NULL))::integer) + ((marketplace_item_id IS NOT NULL))::integer) = 1))
);


--
-- Name: reviews_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: reviews_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.reviews_id_seq OWNED BY public.reviews.id;


--
-- Name: service_rates; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.service_rates (
    id bigint NOT NULL,
    service_type smallint NOT NULL,
    game text NOT NULL,
    rate_type smallint NOT NULL,
    rate_target text,
    rate numeric(3,2) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: service_rates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: service_rates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.service_rates_id_seq OWNED BY public.service_rates.id;


--
-- Name: sessions; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.sessions (
    id character varying(255) NOT NULL,
    user_id bigint,
    ip_address character varying(45),
    user_agent text,
    payload text NOT NULL,
    last_activity integer NOT NULL
);


--
-- Name: settings; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.settings (
    id bigint NOT NULL,
    "group" character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    locked boolean DEFAULT false NOT NULL,
    payload json NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: settings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.settings_id_seq OWNED BY public.settings.id;


--
-- Name: subcharges; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.subcharges (
    id integer NOT NULL,
    token character varying(255) NOT NULL,
    used boolean DEFAULT false NOT NULL,
    description character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: subcharges_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: subcharges_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.subcharges_id_seq OWNED BY public.subcharges.id;


--
-- Name: swift_pass_profitability; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.swift_pass_profitability (
    id bigint NOT NULL,
    boost_id bigint NOT NULL,
    hour_type character varying(255) NOT NULL,
    division character varying(255) NOT NULL,
    rate numeric(5,2) NOT NULL,
    boost_price numeric(10,2) NOT NULL,
    total_paid numeric(10,2) NOT NULL,
    descriptions text,
    boost_created_at timestamp(0) without time zone NOT NULL,
    generated_at timestamp(0) without time zone NOT NULL
);


--
-- Name: swift_pass_profitability_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: swift_pass_profitability_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.swift_pass_profitability_id_seq OWNED BY public.swift_pass_profitability.id;


--
-- Name: tips; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.tips (
    id integer NOT NULL,
    token character varying(255) NOT NULL,
    used boolean DEFAULT false NOT NULL,
    booster_id integer NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: tips_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: tips_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.tips_id_seq OWNED BY public.tips.id;


--
-- Name: transactions; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.transactions (
    id bigint NOT NULL,
    payable_type character varying(255) NOT NULL,
    payable_id bigint NOT NULL,
    wallet_id bigint NOT NULL,
    type character varying(255) NOT NULL,
    amount numeric(64,0) NOT NULL,
    confirmed boolean NOT NULL,
    meta json,
    uuid uuid NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) with time zone,
    CONSTRAINT transactions_type_check CHECK (((type)::text = ANY (ARRAY[('deposit'::character varying)::text, ('withdraw'::character varying)::text])))
);


--
-- Name: transactions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: transactions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.transactions_id_seq OWNED BY public.transactions.id;


--
-- Name: transfers; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.transfers (
    id bigint NOT NULL,
    from_id bigint NOT NULL,
    to_id bigint NOT NULL,
    status character varying(255) DEFAULT 'transfer'::character varying NOT NULL,
    status_last character varying(255),
    deposit_id bigint NOT NULL,
    withdraw_id bigint NOT NULL,
    discount numeric(64,0) DEFAULT '0'::numeric NOT NULL,
    fee numeric(64,0) DEFAULT '0'::numeric NOT NULL,
    uuid uuid NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) with time zone,
    extra json,
    CONSTRAINT transfers_status_check CHECK (((status)::text = ANY (ARRAY[('exchange'::character varying)::text, ('transfer'::character varying)::text, ('paid'::character varying)::text, ('refund'::character varying)::text, ('gift'::character varying)::text]))),
    CONSTRAINT transfers_status_last_check CHECK (((status_last)::text = ANY (ARRAY[('exchange'::character varying)::text, ('transfer'::character varying)::text, ('paid'::character varying)::text, ('refund'::character varying)::text, ('gift'::character varying)::text])))
);


--
-- Name: transfers_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: transfers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.transfers_id_seq OWNED BY public.transfers.id;


--
-- Name: user_marketplace_profiles; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.user_marketplace_profiles (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    verified_seller boolean DEFAULT false NOT NULL,
    is_eb24_seller boolean DEFAULT false NOT NULL,
    marketplace_verification boolean,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: user_marketplace_profiles_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: user_marketplace_profiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.user_marketplace_profiles_id_seq OWNED BY public.user_marketplace_profiles.id;


--
-- Name: user_social_providers; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.user_social_providers (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    provider character varying NOT NULL,
    provider_id text NOT NULL,
    provider_name text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: verification_sessions; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.verification_sessions (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    token character varying(255),
    status smallint DEFAULT '0'::smallint NOT NULL,
    full_name character varying(255),
    failed_reason character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: user_verifications_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: user_verifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.user_verifications_id_seq OWNED BY public.verification_sessions.id;


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

CREATE TABLE public.users (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    email public.citext NOT NULL,
    password character varying(255) NOT NULL,
    role integer DEFAULT 0 NOT NULL,
    remember_token character varying(100),
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone,
    fullname character varying(255),
    skype character varying(255),
    discord character varying(255),
    country character varying(255),
    subscribed boolean DEFAULT false NOT NULL,
    discord_channel character varying(255),
    ranks json,
    last_active_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    permissions jsonb DEFAULT '{"lol":{"booster":true,"coach":true,"vip":false,"loyalty":false,"elite":false},"tft":{"booster":false,"coach":false,"vip":false,"loyalty":false,"elite":false},"valorant":{"booster":false,"coach":false,"vip":false,"loyalty":false,"elite":false}}'::json NOT NULL,
    divisions jsonb DEFAULT '{"lol":{"rank":25,"limitation":27},"tft":{"rank":25,"limitation":21},"valorant":{"rank":22,"limitation":21}}'::json NOT NULL,
    two_factor_secret character varying(255),
    role_changed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    payments_withhold_reason character varying(255),
    limitations jsonb DEFAULT '{}'::jsonb NOT NULL,
    uuid uuid,
    recovery_code character varying(255),
    game_accounts jsonb,
    can_change_name integer DEFAULT 0 NOT NULL,
    name_changed_at timestamp(0) without time zone
);


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

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


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

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


--
-- Name: users_social_providers_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: users_social_providers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.users_social_providers_id_seq OWNED BY public.user_social_providers.id;


--
-- Name: verification_requirements; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.verification_requirements (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    grace_period_ends_at timestamp(0) without time zone NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    reasons jsonb
);


--
-- Name: verification_requirements_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: verification_requirements_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.verification_requirements_id_seq OWNED BY public.verification_requirements.id;


--
-- Name: wallets; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.wallets (
    id bigint NOT NULL,
    holder_type character varying(255) NOT NULL,
    holder_id bigint NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    uuid uuid NOT NULL,
    description character varying(255),
    meta json,
    balance numeric(64,0) DEFAULT '0'::numeric NOT NULL,
    decimal_places smallint DEFAULT '2'::smallint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) with time zone
);


--
-- Name: wallets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: wallets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.wallets_id_seq OWNED BY public.wallets.id;


--
-- Name: withdraw_change_logs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.withdraw_change_logs (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    withdraw_action_update json NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


--
-- Name: withdraw_change_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: withdraw_change_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.withdraw_change_logs_id_seq OWNED BY public.withdraw_change_logs.id;


--
-- Name: zippy_product_offers; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.zippy_product_offers (
    id bigint NOT NULL,
    zippy_product_family_uuid uuid NOT NULL,
    revision integer NOT NULL,
    acceptance_status smallint DEFAULT '0'::smallint NOT NULL,
    family_uuid uuid NOT NULL,
    amount integer NOT NULL,
    price_usd integer NOT NULL,
    price_eur integer NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    family_created_at date NOT NULL,
    deleted_at timestamp(0) without time zone,
    additional text
);


--
-- Name: zippy_product_offers_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: zippy_product_offers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.zippy_product_offers_id_seq OWNED BY public.zippy_product_offers.id;


--
-- Name: zippy_products; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.zippy_products (
    id bigint NOT NULL,
    zippy_profile_family_uuid uuid NOT NULL,
    revision integer NOT NULL,
    family_uuid uuid NOT NULL,
    acceptance_status smallint DEFAULT '0'::smallint NOT NULL,
    type smallint NOT NULL,
    name text,
    description text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    family_created_at date NOT NULL,
    deleted_at timestamp(0) without time zone,
    CONSTRAINT zippy_products_type_check CHECK ((((type = 0) AND (name IS NOT NULL) AND (description IS NOT NULL)) OR ((type <> 0) AND (name IS NULL) AND (description IS NULL))))
);


--
-- Name: zippy_products_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: zippy_products_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.zippy_products_id_seq OWNED BY public.zippy_products.id;


--
-- Name: zippy_profiles; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.zippy_profiles (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    service_type text NOT NULL,
    revision integer NOT NULL,
    family_uuid uuid NOT NULL,
    acceptance_status smallint DEFAULT '0'::smallint NOT NULL,
    slug text NOT NULL,
    summary text NOT NULL,
    rank text,
    features jsonb DEFAULT '[]'::jsonb NOT NULL,
    active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    family_created_at date NOT NULL,
    deleted_at timestamp(0) without time zone,
    subtitle character varying(255),
    deactivation_job_uuid uuid,
    age smallint,
    call_of_duty_version character varying(255)
);


--
-- Name: zippy_profiles_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: zippy_profiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.zippy_profiles_id_seq OWNED BY public.zippy_profiles.id;


--
-- Name: zippy_purchases; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.zippy_purchases (
    id bigint NOT NULL,
    status integer NOT NULL,
    user_id bigint,
    zippy_product_offer_id bigint NOT NULL,
    quantity integer NOT NULL,
    paid boolean DEFAULT false NOT NULL,
    percentage numeric(3,2) DEFAULT 0.5 NOT NULL,
    currency character varying(255) NOT NULL,
    last_poke_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    user_schedule text,
    booster_schedule text,
    price integer NOT NULL,
    game_account text
);


--
-- Name: zippy_purchases_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: zippy_purchases_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.zippy_purchases_id_seq OWNED BY public.zippy_purchases.id;


--
-- Name: accounts id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: audits id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: authentication_logs id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: bans id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: blacklisted_values id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: boosts id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: bulk_accounts id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: chat_conversation_user_states id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: chat_messages id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: coachings id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: coupons id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: disputes id; Type: DEFAULT; Schema: public; Owner: -
--

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


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

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


--
-- Name: favourite_contractors id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: freeze_logs id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: jobs id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: labels id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: marketplace_fees id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: marketplace_galleries id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: marketplace_items id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: media id; Type: DEFAULT; Schema: public; Owner: -
--

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


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

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


--
-- Name: offer_orders id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: offers id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: orders id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: payment_methods id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: payments id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: popup_reports id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: post_categories id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: post_label id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: posts id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: profiles id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: rank_reservations id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: reasons id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: rental_account_rentals id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: rental_accounts id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: reviews id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: service_rates id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: settings id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: subcharges id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: swift_pass_profitability id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: tips id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: transactions id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: transfers id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: user_marketplace_profiles id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: user_social_providers id; Type: DEFAULT; Schema: public; Owner: -
--

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


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

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


--
-- Name: verification_requirements id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: verification_sessions id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: wallets id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: withdraw_change_logs id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: zippy_product_offers id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: zippy_products id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: zippy_profiles id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: zippy_purchases id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: accounts accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.accounts
    ADD CONSTRAINT accounts_pkey PRIMARY KEY (id);


--
-- Name: audits audits_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.audits
    ADD CONSTRAINT audits_pkey PRIMARY KEY (id);


--
-- Name: authentication_logs authentication_log_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.authentication_logs
    ADD CONSTRAINT authentication_log_pkey PRIMARY KEY (id);


--
-- Name: bans bans_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.bans
    ADD CONSTRAINT bans_pkey PRIMARY KEY (id);


--
-- Name: blacklisted_values blacklisted_values_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blacklisted_values
    ADD CONSTRAINT blacklisted_values_pkey PRIMARY KEY (id);


--
-- Name: boosts boosts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.boosts
    ADD CONSTRAINT boosts_pkey PRIMARY KEY (id);


--
-- Name: bulk_accounts bulk_accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.bulk_accounts
    ADD CONSTRAINT bulk_accounts_pkey PRIMARY KEY (id);


--
-- Name: cache cache_key_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.cache
    ADD CONSTRAINT cache_key_unique UNIQUE (key);


--
-- Name: chat_conversation_user_states chat_conv_user_state_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.chat_conversation_user_states
    ADD CONSTRAINT chat_conv_user_state_unique UNIQUE (user_id, service_type, service_id);


--
-- Name: chat_conversation_user_states chat_conversation_user_states_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.chat_conversation_user_states
    ADD CONSTRAINT chat_conversation_user_states_pkey PRIMARY KEY (id);


--
-- Name: chat_messages chat_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.chat_messages
    ADD CONSTRAINT chat_messages_pkey PRIMARY KEY (id);


--
-- Name: coachings coachings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.coachings
    ADD CONSTRAINT coachings_pkey PRIMARY KEY (id);


--
-- Name: coupons coupons_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.coupons
    ADD CONSTRAINT coupons_pkey PRIMARY KEY (id);


--
-- Name: disputes disputes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.disputes
    ADD CONSTRAINT disputes_pkey PRIMARY KEY (id);


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

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: -
--

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


--
-- Name: favourite_contractors favourite_contractors_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.favourite_contractors
    ADD CONSTRAINT favourite_contractors_pkey PRIMARY KEY (id);


--
-- Name: freeze_logs freeze_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.freeze_logs
    ADD CONSTRAINT freeze_logs_pkey PRIMARY KEY (id);


--
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);


--
-- Name: labels labels_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.labels
    ADD CONSTRAINT labels_pkey PRIMARY KEY (id);


--
-- Name: labels labels_slug_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.labels
    ADD CONSTRAINT labels_slug_unique UNIQUE (slug);


--
-- Name: marketplace_fees marketplace_fees_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.marketplace_fees
    ADD CONSTRAINT marketplace_fees_pkey PRIMARY KEY (id);


--
-- Name: marketplace_galleries marketplace_galleries_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.marketplace_galleries
    ADD CONSTRAINT marketplace_galleries_pkey PRIMARY KEY (id);


--
-- Name: marketplace_galleries marketplace_galleries_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.marketplace_galleries
    ADD CONSTRAINT marketplace_galleries_uuid_unique UNIQUE (uuid);


--
-- Name: marketplace_items marketplace_items_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.marketplace_items
    ADD CONSTRAINT marketplace_items_pkey PRIMARY KEY (id);


--
-- Name: media media_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.media
    ADD CONSTRAINT media_pkey PRIMARY KEY (id);


--
-- Name: media media_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.media
    ADD CONSTRAINT media_uuid_unique UNIQUE (uuid);


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

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


--
-- Name: offer_orders offer_orders_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.offer_orders
    ADD CONSTRAINT offer_orders_pkey PRIMARY KEY (id);


--
-- Name: offers offers_account_id_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.offers
    ADD CONSTRAINT offers_account_id_unique UNIQUE (account_id);


--
-- Name: offers offers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.offers
    ADD CONSTRAINT offers_pkey PRIMARY KEY (id);


--
-- Name: offers offers_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.offers
    ADD CONSTRAINT offers_uuid_unique UNIQUE (uuid);


--
-- Name: orders orders_hash_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_hash_unique UNIQUE (hash);


--
-- Name: orders orders_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_pkey PRIMARY KEY (id);


--
-- Name: payment_methods payment_methods_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.payment_methods
    ADD CONSTRAINT payment_methods_pkey PRIMARY KEY (id);


--
-- Name: payments payments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.payments
    ADD CONSTRAINT payments_pkey PRIMARY KEY (id);


--
-- Name: popup_reports popup_reports_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.popup_reports
    ADD CONSTRAINT popup_reports_pkey PRIMARY KEY (id);


--
-- Name: post_categories post_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.post_categories
    ADD CONSTRAINT post_categories_pkey PRIMARY KEY (id);


--
-- Name: post_categories post_categories_slug_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.post_categories
    ADD CONSTRAINT post_categories_slug_unique UNIQUE (slug);


--
-- Name: post_label post_label_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.post_label
    ADD CONSTRAINT post_label_pkey PRIMARY KEY (id);


--
-- Name: posts posts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.posts
    ADD CONSTRAINT posts_pkey PRIMARY KEY (id);


--
-- Name: posts posts_slug_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.posts
    ADD CONSTRAINT posts_slug_unique UNIQUE (slug);


--
-- Name: profiles profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.profiles
    ADD CONSTRAINT profiles_pkey PRIMARY KEY (id);


--
-- Name: profiles profiles_user_id_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.profiles
    ADD CONSTRAINT profiles_user_id_unique UNIQUE (user_id);


--
-- Name: rank_reservations rank_reservations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.rank_reservations
    ADD CONSTRAINT rank_reservations_pkey PRIMARY KEY (id);


--
-- Name: reasons reasons_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reasons
    ADD CONSTRAINT reasons_pkey PRIMARY KEY (id);


--
-- Name: rental_account_rentals rental_account_rentals_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.rental_account_rentals
    ADD CONSTRAINT rental_account_rentals_pkey PRIMARY KEY (id);


--
-- Name: rental_accounts rental_accounts_account_id_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.rental_accounts
    ADD CONSTRAINT rental_accounts_account_id_unique UNIQUE (account_id);


--
-- Name: rental_accounts rental_accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.rental_accounts
    ADD CONSTRAINT rental_accounts_pkey PRIMARY KEY (id);


--
-- Name: reviews reviews_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_pkey PRIMARY KEY (id);


--
-- Name: service_rates service_rates_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.service_rates
    ADD CONSTRAINT service_rates_pkey PRIMARY KEY (id);


--
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);


--
-- Name: settings settings_group_name_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.settings
    ADD CONSTRAINT settings_group_name_unique UNIQUE ("group", name);


--
-- Name: settings settings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.settings
    ADD CONSTRAINT settings_pkey PRIMARY KEY (id);


--
-- Name: subcharges subcharges_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.subcharges
    ADD CONSTRAINT subcharges_pkey PRIMARY KEY (id);


--
-- Name: swift_pass_profitability swift_pass_profitability_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.swift_pass_profitability
    ADD CONSTRAINT swift_pass_profitability_pkey PRIMARY KEY (id);


--
-- Name: tips tips_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.tips
    ADD CONSTRAINT tips_pkey PRIMARY KEY (id);


--
-- Name: transactions transactions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_pkey PRIMARY KEY (id);


--
-- Name: transactions transactions_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_uuid_unique UNIQUE (uuid);


--
-- Name: transfers transfers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.transfers
    ADD CONSTRAINT transfers_pkey PRIMARY KEY (id);


--
-- Name: transfers transfers_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.transfers
    ADD CONSTRAINT transfers_uuid_unique UNIQUE (uuid);


--
-- Name: user_marketplace_profiles user_marketplace_profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_marketplace_profiles
    ADD CONSTRAINT user_marketplace_profiles_pkey PRIMARY KEY (id);


--
-- Name: verification_sessions user_verifications_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.verification_sessions
    ADD CONSTRAINT user_verifications_pkey PRIMARY KEY (id);


--
-- Name: verification_sessions user_verifications_token_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.verification_sessions
    ADD CONSTRAINT user_verifications_token_unique UNIQUE (token);


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

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


--
-- Name: users users_name_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_name_unique UNIQUE (name);


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

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


--
-- Name: user_social_providers users_social_providers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_social_providers
    ADD CONSTRAINT users_social_providers_pkey PRIMARY KEY (id);


--
-- Name: verification_requirements verification_requirements_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.verification_requirements
    ADD CONSTRAINT verification_requirements_pkey PRIMARY KEY (id);


--
-- Name: verification_requirements verification_requirements_user_id_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.verification_requirements
    ADD CONSTRAINT verification_requirements_user_id_unique UNIQUE (user_id);


--
-- Name: wallets wallets_holder_type_holder_id_slug_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.wallets
    ADD CONSTRAINT wallets_holder_type_holder_id_slug_unique UNIQUE (holder_type, holder_id, slug);


--
-- Name: wallets wallets_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.wallets
    ADD CONSTRAINT wallets_pkey PRIMARY KEY (id);


--
-- Name: wallets wallets_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.wallets
    ADD CONSTRAINT wallets_uuid_unique UNIQUE (uuid);


--
-- Name: withdraw_change_logs withdraw_change_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.withdraw_change_logs
    ADD CONSTRAINT withdraw_change_logs_pkey PRIMARY KEY (id);


--
-- Name: zippy_product_offers zippy_product_offers_family_uuid_revision_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zippy_product_offers
    ADD CONSTRAINT zippy_product_offers_family_uuid_revision_unique UNIQUE (family_uuid, revision);


--
-- Name: zippy_product_offers zippy_product_offers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zippy_product_offers
    ADD CONSTRAINT zippy_product_offers_pkey PRIMARY KEY (id);


--
-- Name: zippy_products zippy_products_family_uuid_revision_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zippy_products
    ADD CONSTRAINT zippy_products_family_uuid_revision_unique UNIQUE (family_uuid, revision);


--
-- Name: zippy_products zippy_products_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zippy_products
    ADD CONSTRAINT zippy_products_pkey PRIMARY KEY (id);


--
-- Name: zippy_profiles zippy_profiles_family_uuid_revision_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zippy_profiles
    ADD CONSTRAINT zippy_profiles_family_uuid_revision_unique UNIQUE (family_uuid, revision);


--
-- Name: zippy_profiles zippy_profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zippy_profiles
    ADD CONSTRAINT zippy_profiles_pkey PRIMARY KEY (id);


--
-- Name: zippy_purchases zippy_purchases_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zippy_purchases
    ADD CONSTRAINT zippy_purchases_pkey PRIMARY KEY (id);


--
-- Name: accounts_game_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX accounts_game_index ON public.accounts USING btree (game);


--
-- Name: accounts_id_game_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX accounts_id_game_index ON public.accounts USING btree (id, game);


--
-- Name: audits_auditable_type_auditable_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX audits_auditable_type_auditable_id_index ON public.audits USING btree (auditable_type, auditable_id);


--
-- Name: audits_user_id_user_type_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX audits_user_id_user_type_index ON public.audits USING btree (user_id, user_type);


--
-- Name: authentication_logs_ip_address_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX authentication_logs_ip_address_index ON public.authentication_logs USING btree (ip_address);


--
-- Name: authentication_logs_user_agent_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX authentication_logs_user_agent_index ON public.authentication_logs USING btree (user_agent);


--
-- Name: authentication_logs_user_id_login_at_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX authentication_logs_user_id_login_at_index ON public.authentication_logs USING btree (user_id, login_at DESC);


--
-- Name: bans_user_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX bans_user_id_index ON public.bans USING btree (user_id);


--
-- Name: boosts_booster_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX boosts_booster_id_index ON public.boosts USING btree (booster_id);


--
-- Name: boosts_booster_id_status_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX boosts_booster_id_status_index ON public.boosts USING btree (booster_id, status);


--
-- Name: boosts_status_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX boosts_status_index ON public.boosts USING btree (status);


--
-- Name: boosts_user_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX boosts_user_id_index ON public.boosts USING btree (user_id);


--
-- Name: chat_conv_user_state_service_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX chat_conv_user_state_service_index ON public.chat_conversation_user_states USING btree (service_type, service_id);


--
-- Name: chat_conv_user_state_user_unread_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX chat_conv_user_state_user_unread_index ON public.chat_conversation_user_states USING btree (user_id, has_unread);


--
-- Name: chat_messages_service_type_service_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX chat_messages_service_type_service_id_index ON public.chat_messages USING btree (service_type, service_id);


--
-- Name: chat_messages_user_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX chat_messages_user_id_index ON public.chat_messages USING btree (user_id);


--
-- Name: coachings_booster_id_status_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX coachings_booster_id_status_index ON public.coachings USING btree (booster_id, status);


--
-- Name: coachings_status_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX coachings_status_index ON public.coachings USING btree (status);


--
-- Name: disputes_disputable_type_disputable_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX disputes_disputable_type_disputable_id_index ON public.disputes USING btree (disputable_type, disputable_id);


--
-- Name: freeze_logs_freezable_type_freezable_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX freeze_logs_freezable_type_freezable_id_index ON public.freeze_logs USING btree (freezable_type, freezable_id);


--
-- Name: freeze_logs_user_id_expire_at_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX freeze_logs_user_id_expire_at_index ON public.freeze_logs USING btree (user_id, expire_at);


--
-- Name: jobs_queue_reserved_at_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX jobs_queue_reserved_at_index ON public.jobs USING btree (queue, reserved_at);


--
-- Name: marketplace_fees_game_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX marketplace_fees_game_index ON public.marketplace_fees USING btree (game);


--
-- Name: marketplace_fees_type_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX marketplace_fees_type_index ON public.marketplace_fees USING btree (type);


--
-- Name: media_model_type_model_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX media_model_type_model_id_index ON public.media USING btree (model_type, model_id);


--
-- Name: media_order_column_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX media_order_column_index ON public.media USING btree (order_column);


--
-- Name: offer_orders_offer_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX offer_orders_offer_id_index ON public.offer_orders USING btree (offer_id);


--
-- Name: offers_searchable_vector_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX offers_searchable_vector_idx ON public.offers USING gin (searchable_vector);


--
-- Name: offers_status_created_at_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX offers_status_created_at_index ON public.offers USING btree (status, created_at DESC);


--
-- Name: offers_status_id_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX offers_status_id_idx ON public.offers USING btree (status, id);


--
-- Name: offers_status_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX offers_status_index ON public.offers USING btree (status);


--
-- Name: offers_user_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX offers_user_id_index ON public.offers USING btree (user_id);


--
-- Name: offers_user_id_status_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX offers_user_id_status_index ON public.offers USING btree (user_id, status);


--
-- Name: orders_service_type_service_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX orders_service_type_service_id_index ON public.orders USING btree (service_type, service_id);


--
-- Name: orders_user_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX orders_user_id_index ON public.orders USING btree (user_id);


--
-- Name: password_resets_email_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX password_resets_email_index ON public.password_resets USING btree (email);


--
-- Name: password_resets_token_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX password_resets_token_index ON public.password_resets USING btree (token);


--
-- Name: payable_confirmed_ind; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX payable_confirmed_ind ON public.transactions USING btree (payable_type, payable_id, confirmed);


--
-- Name: payable_type_confirmed_ind; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX payable_type_confirmed_ind ON public.transactions USING btree (payable_type, payable_id, type, confirmed);


--
-- Name: payable_type_ind; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX payable_type_ind ON public.transactions USING btree (payable_type, payable_id, type);


--
-- Name: payable_type_payable_id_ind; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX payable_type_payable_id_ind ON public.transactions USING btree (payable_type, payable_id);


--
-- Name: payment_methods_user_id_sort_order_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX payment_methods_user_id_sort_order_index ON public.payment_methods USING btree (user_id, sort_order);


--
-- Name: payment_methods_user_id_status_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX payment_methods_user_id_status_index ON public.payment_methods USING btree (user_id, status);


--
-- Name: reasons_boost_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX reasons_boost_id_index ON public.reasons USING btree (boost_id);


--
-- Name: reviews_boost_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX reviews_boost_id_index ON public.reviews USING btree (boost_id);


--
-- Name: reviews_coaching_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX reviews_coaching_id_index ON public.reviews USING btree (coaching_id);


--
-- Name: reviews_marketplace_item_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX reviews_marketplace_item_id_index ON public.reviews USING btree (marketplace_item_id);


--
-- Name: reviews_offer_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX reviews_offer_id_index ON public.reviews USING btree (offer_id);


--
-- Name: reviews_rating_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX reviews_rating_index ON public.reviews USING btree (rating);


--
-- Name: reviews_status_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX reviews_status_index ON public.reviews USING btree (status);


--
-- Name: service_rates_service_type_game_rate_type_rate_target_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX service_rates_service_type_game_rate_type_rate_target_idx ON public.service_rates USING btree (service_type, game, rate_type, rate_target) NULLS NOT DISTINCT;


--
-- Name: sessions_last_activity_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity);


--
-- Name: sessions_user_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id);


--
-- Name: transactions_meta_serviceid_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX transactions_meta_serviceid_index ON public.transactions USING btree (((meta ->> 'serviceId'::text)));


--
-- Name: transactions_payable_type_payable_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX transactions_payable_type_payable_id_index ON public.transactions USING btree (payable_type, payable_id);


--
-- Name: transactions_type_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX transactions_type_index ON public.transactions USING btree (type);


--
-- Name: transfers_from_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX transfers_from_id_index ON public.transfers USING btree (from_id);


--
-- Name: transfers_to_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX transfers_to_id_index ON public.transfers USING btree (to_id);


--
-- Name: user_marketplace_profiles_user_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX user_marketplace_profiles_user_id_index ON public.user_marketplace_profiles USING btree (user_id);


--
-- Name: user_marketplace_profiles_verified_seller_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX user_marketplace_profiles_verified_seller_index ON public.user_marketplace_profiles USING btree (verified_seller);


--
-- Name: user_social_providers_user_id_provider_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX user_social_providers_user_id_provider_index ON public.user_social_providers USING btree (user_id, provider);


--
-- Name: users_name_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX users_name_index ON public.users USING btree (name);


--
-- Name: users_role_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX users_role_index ON public.users USING btree (role);


--
-- Name: wallets_holder_type_holder_id_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX wallets_holder_type_holder_id_index ON public.wallets USING btree (holder_type, holder_id);


--
-- Name: wallets_slug_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX wallets_slug_index ON public.wallets USING btree (slug);


--
-- Name: zippy_product_offers_family_uuid_acceptance_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX zippy_product_offers_family_uuid_acceptance_idx ON public.zippy_product_offers USING btree (family_uuid, acceptance_status, id);


--
-- Name: zippy_product_offers_family_uuid_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX zippy_product_offers_family_uuid_index ON public.zippy_product_offers USING btree (family_uuid);


--
-- Name: zippy_products_family_uuid_acceptance_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX zippy_products_family_uuid_acceptance_idx ON public.zippy_products USING btree (family_uuid, acceptance_status, id);


--
-- Name: zippy_products_family_uuid_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX zippy_products_family_uuid_index ON public.zippy_products USING btree (family_uuid);


--
-- Name: zippy_profiles_family_uuid_acceptance_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX zippy_profiles_family_uuid_acceptance_idx ON public.zippy_profiles USING btree (family_uuid, acceptance_status, id);


--
-- Name: zippy_profiles_family_uuid_index; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX zippy_profiles_family_uuid_index ON public.zippy_profiles USING btree (family_uuid);


--
-- Name: authentication_logs authentication_log_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.authentication_logs
    ADD CONSTRAINT authentication_log_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: bans bans_banned_by_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.bans
    ADD CONSTRAINT bans_banned_by_id_foreign FOREIGN KEY (banned_by_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: bans bans_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.bans
    ADD CONSTRAINT bans_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: chat_conversation_user_states chat_conversation_user_states_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.chat_conversation_user_states
    ADD CONSTRAINT chat_conversation_user_states_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: favourite_contractors favourite_contractors_contractor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.favourite_contractors
    ADD CONSTRAINT favourite_contractors_contractor_id_foreign FOREIGN KEY (contractor_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: favourite_contractors favourite_contractors_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.favourite_contractors
    ADD CONSTRAINT favourite_contractors_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: labels labels_post_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.labels
    ADD CONSTRAINT labels_post_category_id_foreign FOREIGN KEY (post_category_id) REFERENCES public.post_categories(id) ON DELETE CASCADE;


--
-- Name: marketplace_galleries marketplace_galleries_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.marketplace_galleries
    ADD CONSTRAINT marketplace_galleries_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: marketplace_items marketplace_items_buyer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.marketplace_items
    ADD CONSTRAINT marketplace_items_buyer_id_foreign FOREIGN KEY (buyer_id) REFERENCES public.users(id);


--
-- Name: marketplace_items marketplace_items_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.marketplace_items
    ADD CONSTRAINT marketplace_items_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: offer_orders offer_orders_offer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.offer_orders
    ADD CONSTRAINT offer_orders_offer_id_foreign FOREIGN KEY (offer_id) REFERENCES public.offers(id) ON DELETE CASCADE;


--
-- Name: offers offers_account_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.offers
    ADD CONSTRAINT offers_account_id_foreign FOREIGN KEY (account_id) REFERENCES public.accounts(id) ON DELETE CASCADE;


--
-- Name: offers offers_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.offers
    ADD CONSTRAINT offers_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: payment_methods payment_methods_reviewed_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.payment_methods
    ADD CONSTRAINT payment_methods_reviewed_by_foreign FOREIGN KEY (reviewed_by) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: payment_methods payment_methods_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.payment_methods
    ADD CONSTRAINT payment_methods_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: popup_reports popup_reports_boost_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.popup_reports
    ADD CONSTRAINT popup_reports_boost_id_foreign FOREIGN KEY (boost_id) REFERENCES public.boosts(id) ON DELETE CASCADE;


--
-- Name: popup_reports popup_reports_reporter_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.popup_reports
    ADD CONSTRAINT popup_reports_reporter_id_foreign FOREIGN KEY (reporter_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: popup_reports popup_reports_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.popup_reports
    ADD CONSTRAINT popup_reports_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: post_label post_label_label_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.post_label
    ADD CONSTRAINT post_label_label_id_foreign FOREIGN KEY (label_id) REFERENCES public.labels(id) ON DELETE CASCADE;


--
-- Name: post_label post_label_post_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.post_label
    ADD CONSTRAINT post_label_post_id_foreign FOREIGN KEY (post_id) REFERENCES public.posts(id) ON DELETE CASCADE;


--
-- Name: rental_account_rentals rental_account_rentals_rental_account_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.rental_account_rentals
    ADD CONSTRAINT rental_account_rentals_rental_account_id_foreign FOREIGN KEY (rental_account_id) REFERENCES public.rental_accounts(id) ON DELETE CASCADE;


--
-- Name: rental_account_rentals rental_account_rentals_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.rental_account_rentals
    ADD CONSTRAINT rental_account_rentals_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: rental_account_rentals rental_account_rentals_zippy_purchase_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.rental_account_rentals
    ADD CONSTRAINT rental_account_rentals_zippy_purchase_id_foreign FOREIGN KEY (zippy_purchase_id) REFERENCES public.zippy_purchases(id) ON DELETE SET NULL;


--
-- Name: rental_accounts rental_accounts_account_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.rental_accounts
    ADD CONSTRAINT rental_accounts_account_id_foreign FOREIGN KEY (account_id) REFERENCES public.accounts(id) ON DELETE CASCADE;


--
-- Name: reviews reviews_boost_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_boost_id_foreign FOREIGN KEY (boost_id) REFERENCES public.boosts(id) ON DELETE CASCADE;


--
-- Name: reviews reviews_coaching_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_coaching_id_foreign FOREIGN KEY (coaching_id) REFERENCES public.coachings(id) ON DELETE CASCADE;


--
-- Name: reviews reviews_marketplace_item_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_marketplace_item_id_foreign FOREIGN KEY (marketplace_item_id) REFERENCES public.marketplace_items(id) ON DELETE SET NULL;


--
-- Name: reviews reviews_offer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_offer_id_foreign FOREIGN KEY (offer_id) REFERENCES public.offers(id) ON DELETE CASCADE;


--
-- Name: reviews reviews_zippy_purchase_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_zippy_purchase_id_foreign FOREIGN KEY (zippy_purchase_id) REFERENCES public.zippy_purchases(id) ON DELETE CASCADE;


--
-- Name: swift_pass_profitability swift_pass_profitability_boost_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.swift_pass_profitability
    ADD CONSTRAINT swift_pass_profitability_boost_id_foreign FOREIGN KEY (boost_id) REFERENCES public.boosts(id) ON DELETE CASCADE;


--
-- Name: transactions transactions_wallet_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_wallet_id_foreign FOREIGN KEY (wallet_id) REFERENCES public.wallets(id) ON DELETE CASCADE;


--
-- Name: transfers transfers_deposit_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.transfers
    ADD CONSTRAINT transfers_deposit_id_foreign FOREIGN KEY (deposit_id) REFERENCES public.transactions(id) ON DELETE CASCADE;


--
-- Name: transfers transfers_withdraw_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.transfers
    ADD CONSTRAINT transfers_withdraw_id_foreign FOREIGN KEY (withdraw_id) REFERENCES public.transactions(id) ON DELETE CASCADE;


--
-- Name: user_marketplace_profiles user_marketplace_profiles_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_marketplace_profiles
    ADD CONSTRAINT user_marketplace_profiles_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: verification_sessions user_verifications_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.verification_sessions
    ADD CONSTRAINT user_verifications_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: user_social_providers users_social_providers_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_social_providers
    ADD CONSTRAINT users_social_providers_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: verification_requirements verification_requirements_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.verification_requirements
    ADD CONSTRAINT verification_requirements_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: zippy_profiles zippy_profiles_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zippy_profiles
    ADD CONSTRAINT zippy_profiles_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: zippy_purchases zippy_purchases_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zippy_purchases
    ADD CONSTRAINT zippy_purchases_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: zippy_purchases zippy_purchases_zippy_product_offer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zippy_purchases
    ADD CONSTRAINT zippy_purchases_zippy_product_offer_id_foreign FOREIGN KEY (zippy_product_offer_id) REFERENCES public.zippy_product_offers(id) ON DELETE CASCADE;


--
-- PostgreSQL database dump complete
--

\unrestrict rhlmVg0VsZcRnN1UQfbGsebFUHaaJ5PgcaH5ShQmqjuglM1a1NdXaKMZ2uzEoac

--
-- PostgreSQL database dump
--

\restrict gA8LmNrxqVQtznfFVniuDo2ira6humRFAfDsYQidbAdv8aI4tR6Ed12BxfygDR2

-- Dumped from database version 17.9
-- Dumped by pg_dump version 17.8

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_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;

--
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: -
--

COPY public.migrations (id, migration, batch) FROM stdin;
1	2014_10_12_000000_create_users_table	1
2	2014_10_12_100000_create_password_resets_table	1
3	2016_09_07_173105_create_orders_table	1
4	2016_09_08_185914_create_boosts_table	1
5	2016_09_08_190130_create_accounts_table	1
6	2016_09_12_164156_create_chat_messages_table	1
7	2016_09_17_175517_create_screenshots_table	1
8	2016_09_20_181717_create_jobs_table	1
9	2016_09_21_170109_create_profiles_table	1
10	2016_09_23_214519_create_failed_jobs_table	1
11	2016_09_24_154852_create_reasons_table	1
12	2016_10_01_204858_create_reviews_table	1
13	2016_10_10_190244_add_currency_columns	1
14	2016_11_05_202828_create_balance_logs_table	1
15	2016_11_05_214002_add_percentage_to_user	1
16	2016_11_06_133740_add_status_to_accounts	1
17	2016_11_06_165139_add_hidden_to_boosts	1
18	2016_11_22_155621_create_flex_rows	1
19	2016_11_23_162106_add_method_row_to_boosts	1
20	2016_12_07_205511_create_invoices_table	1
21	2016_12_07_215557_add_fullname_to_user	1
22	2017_01_07_142443_create_posts_table	1
23	2017_01_20_160000_add_two_factor_authentication_required_fields	1
24	2017_02_10_185942_create_coupons_table	1
25	2017_04_18_130004_add_description_row_to_boosts	1
26	2017_04_18_130744_remove_percentage_from_users	1
27	2017_04_18_130754_add_percentage_to_boosts	1
28	2017_04_18_133310_add_user_credentials_to_user	1
29	2017_09_01_000000_create_authentication_log_table	1
30	2017_12_02_151521_change_user_id_to_optional_in_orders	1
31	2017_12_02_224324_add_email_to_order	1
32	2017_12_04_181044_change_message_to_text	1
33	2017_12_05_225710_create_subcharges_table	1
34	2017_12_09_224129_make_orders_flexible	1
35	2017_12_09_225724_moved_stuff_from_subcharge_to_order	1
36	2017_12_10_005345_create_tips_table	1
37	2017_12_10_145250_make_admin_nullable_in_balance_logs	1
38	2017_12_11_204929_create_offers_table	1
39	2017_12_14_115152_make_chatmessages_flexible	1
40	2017_12_14_123453_add_screenshots_to_offer	1
41	2017_12_15_230505_move_offer_id_from_offer_to_order	1
42	2017_12_18_192810_create_gift_boxes_table	1
43	2017_12_18_221119_add_balance_rows_to_user	1
44	2017_12_21_223628_create_coachings_table	1
45	2017_12_30_185314_create_invoice_logs_table	1
46	2018_01_02_215626_add_special_options	1
47	2018_02_25_152102_add_secret_2fa_to_users	1
48	2018_05_03_092157_add_queue_to_order	1
49	2018_05_03_093051_add_queue_to_boost	1
50	2018_05_03_111435_add_duo_type	1
51	2018_05_15_174019_create_champion_rows	1
52	2018_05_15_174958_make_queue_nullable	1
53	2018_05_16_195913_add_lines_to_coaching	1
54	2018_05_16_200111_remove_role_from_coaching	1
55	2018_05_16_200556_change_rank_to_string_in_coaching	1
56	2018_05_24_202128_create_addontial_user_info	1
57	2018_05_26_102711_add_lp_to_users	1
58	2018_05_26_123556_add_avatar_to_user	1
59	2018_05_26_204802_create_server_row_in_coachings	1
60	2018_08_11_003343_create_log_table	1
61	2018_08_13_120910_add_tags_field_to_posts	1
62	2018_09_08_162312_add_schedule_to_boost_and_coaching	1
63	2018_09_14_160828_make_orders_soft_deletable	1
64	2018_09_14_162128_add_hash_to_orders	1
65	2018_09_16_152329_add_more_withdraw_fields_to_user	1
66	2018_09_18_125504_add_special_to_profiles	1
67	2018_09_22_091743_giftbox_can_be_bought_as_guest	1
68	2018_09_22_095744_add_fields_to_offer	1
69	2018_09_22_114756_add_subscribed_to_user	1
70	2018_09_29_073050_add_champions_to_coaching	1
71	2018_10_01_231305_add_decimal_places_to_coupon	1
72	2018_10_02_001657_delete_verified_column	1
73	2018_10_03_210456_create_cache_table	1
74	2018_10_03_215859_add_server_to_boosts_and_orders	1
75	2018_10_06_135851_add_coach_id_to_chat_messages	1
76	2018_10_06_143514_add_coaching_to_reason	1
77	2018_10_06_190424_add_paid_to_coachings	1
78	2018_10_08_193520_add_price_public_to_offer	1
79	2018_10_10_153503_make_amount_decimal	1
80	2018_10_10_163500_add_percentage_to_coachings	1
81	2018_10_17_175642_add_official_to_offers	1
82	2018_10_21_164702_add_discount_to_offer	1
83	2018_10_23_092346_create_company_accounts_table	1
84	2018_10_24_134045_add_roles_to_profile	1
85	2018_10_24_170734_change_type_of_champions_to_text_at_orders_and_boosts	1
86	2018_10_24_193841_add_api_data_to_accounts	1
87	2018_10_27_153105_add_server_to_profiles	1
88	2018_10_27_160638_adjust_reviews_to_guest_functionality	1
89	2018_11_05_194059_add_limitation_to_users	1
90	2018_11_05_205741_change_default_value_of_limitation	1
91	2018_11_06_211044_configure_coupons_to_be_limited	1
92	2018_11_06_220749_add_coupon_to_orders	1
93	2018_11_06_222923_create_transactions_table	1
94	2018_11_07_192923_create_transfers_table	1
95	2018_11_15_124230_create_wallets_table	1
96	2018_12_01_145906_add_pending_to_users	1
97	2019_01_08_150145_add_description_to_coachings	1
98	2019_01_08_150330_add_description_to_orders	1
99	2019_01_24_230626_change_default_avatar	1
100	2019_02_01_212241_make_schedule_text	1
101	2019_02_06_231024_add_email_and_email_password_to_offers	1
102	2019_03_01_142552_set_champions_to_text	1
103	2019_03_01_142625_set_champion_to_varchar	1
104	2019_03_04_210551_remove_pending_from_user	1
105	2019_03_04_211042_create_freeze_logs	1
106	2019_03_05_103235_change_amount_to_decimal	1
107	2019_03_20_203341_add_method_field_to_purchases	1
108	2019_03_25_080906_add_dates_to_offer	1
109	2019_04_08_085308_create_partners_table	1
110	2019_04_09_082557_create_referrals_table	1
111	2019_04_09_090910_add_referral_to_orders	1
112	2019_04_09_150552_create_promotions_table	1
113	2019_04_11_120158_add_paid_to_referrals	1
114	2019_04_20_003607_add_language_to_coachings	1
115	2019_04_20_094702_add_lp_to_orders_and_boosts	1
116	2019_04_23_175528_add_discord_columns_to_user	1
117	2019_05_01_002925_remove_2fa_from_user	1
118	2019_05_11_223132_change_orders_id_to_order_id	1
119	2019_07_20_122445_tft_rows	1
120	2019_08_07_194142_add_language_field_to_posts	1
121	2019_08_15_221216_remove_length_from_partners	1
122	2019_08_15_221255_add_social_urls_fields	1
123	2019_08_15_233114_add_verified_seller_to_users	1
124	2019_08_21_112818_add_discount_to_partner	1
125	2019_08_28_171816_comfort_sale_to_offers	1
126	2019_08_28_181042_add_warranty	1
127	2019_08_30_140541_added_roles_to_boosts	1
128	2019_09_01_083042_make_info_optional_at_partners	1
129	2019_09_04_191936_create_queue_option_in_offer	1
130	2019_09_23_203237_add_customized_account_field_to_offer	1
131	2019_12_23_000918_add_facebook_fields_to_user	1
132	2019_12_27_122809_add_by_customer_field_to_reason	1
133	2019_12_31_003753_move_special_from_profile_to_user	1
134	2020_01_01_231137_add_topics_to_posts	1
135	2020_01_14_162620_new_coachings_types	1
136	2020_01_19_004616_adjust_new_offer_fields	1
137	2020_01_19_153049_add_new_account_properties	1
138	2020_01_19_163121_create_bulk_accounts_table	1
139	2020_01_19_235709_add_last_season_rank_to_offers	1
140	2020_01_20_092559_make_levelup_default_to_zero	1
141	2020_01_27_231544_add_offer_id_to_reviews	1
142	2020_01_28_192515_add_last_rank_update_to_offers	1
143	2020_02_01_144736_add_buyer_country	1
144	2020_02_04_220208_add_tokens_to_mastery	1
145	2020_02_24_001044_add_sumonnername_to_offer	1
146	2020_06_08_124333_add_valorant_rows	1
147	2020_07_18_205631_add_added_percentage_to_boosts	1
148	2020_07_18_205943_add_added_percentage_to_coachings	1
149	2020_07_27_120922_create_payments_table	1
150	2020_10_30_093150_new_withdraw_informations	1
151	2020_11_03_173519_added_bank_name_to_users	1
152	2020_12_07_193534_make_emails_case_insensitive	1
153	2020_12_14_105201_add_column_valorant_agents	1
154	2020_12_14_121304_add_columns_booster_features	1
155	2020_12_14_123500_add_column_tft_server	1
156	2020_12_14_123559_add_column_valorant_server	1
157	2020_12_14_130409_add_column_booster_main_game	1
158	2020_12_15_045004_add_tft_valorant_division_and_rank_to-profile	1
159	2020_12_20_132008_edit_required_profile_fields	1
160	2020_12_29_144742_add_last_active_at_to_user	1
161	2021_01_07_152713_add_google_authentication_to_users	1
162	2021_01_31_172252_morph_format_for_chat_messages	1
163	2021_02_02_170721_add_offline_mode_to_boosts_table	1
164	2021_02_04_132548_new_limitation_and_rank_system	1
165	2021_02_09_192329_add_uuid_to_failed_jobs_table	1
166	2021_02_11_154208_add_warranty_to_offers	1
167	2021_02_11_191314_last_poke_at_columns	1
168	2021_02_12_200224_change_structure_of_coaching	1
169	2021_02_15_182738_set_all_services_to_new_archive_status	1
170	2021_05_15_100325_move_to_new2_f_a_solution	1
171	2021_11_02_202021_update_wallets_uuid_table	1
172	2022_06_23_211630_add_new_valorant_rank_ascendant	1
173	2022_09_11_152201_add_slug_field_to_posts	1
174	2022_10_27_205531_create_sessions_table	1
175	2022_12_05_205347_remove_partnership_leftovers	1
176	2022_12_14_083707_create_settings_table	1
177	2023_01_26_164157_remove_rank_info_from_account	1
178	2023_02_13_161828_add_screenshots_to_reasons	1
179	2023_02_15_082138_create_withdraw_change_logs_table	1
180	2023_04_05_163326_create_user_verifications_table	1
181	2023_04_06_145835_add_role_changed_at_to_users	1
182	2023_04_06_175752_remove_all_telescope_tables	1
183	2023_04_23_101308_add_balance_partial_amount_to_orders_table	1
184	2023_04_26_074910_change_social_id_fields_to_string	1
185	2023_04_26_155120_change_permissions_to_jsonb	1
186	2023_05_07_202825_make_token_in_user_verifications_nullable	1
187	2023_05_20_150812_remove_status_field_from_users_table	1
188	2023_05_28_174915_migrate_lp_to_balance_and_delete_column_in_users_table	1
189	2023_05_30_221925_add_rating_column_to_reviews_table	1
190	2023_06_13_063920_remove_log_table	1
191	2023_06_13_112726_migrate_authentication_log_table_to_clearer_format	1
192	2023_06_18_172458_migrate_statuses_to_ratings_in_revies_table	1
193	2023_06_26_183234_add_approved_at_column_to_reviews_table	1
194	2023_06_28_184449_migrate_statuses_to_new_convention_in_revies_table	1
195	2023_07_03_111239_encrypt_all_passwords_in_the_offers_table	1
196	2023_07_03_122104_encrypt_credentials_in_the_accounts_table	1
197	2023_07_05_095025_decrypt_offer_marketplace_account_name	1
198	2023_07_05_112620_reencode_withdraw_action_update_in_withdraw_change_log	1
199	2023_07_05_152139_encrypt_without_serialization	1
200	2023_07_07_093427_decrypt_accounts_summoner_name	1
201	2023_07_08_000502_move_blog_images_from_uploadcare_to_own_storage	1
202	2023_07_09_214723_add_visitor_id_to_authentication_logs	1
203	2023_07_11_113021_ensure_that_there_is_created_at_in_users_table	1
204	2023_07_14_141232_migrate_from_dynamic_country_getter_to_field_in_database	1
205	2023_07_14_190100_migrate_old_divisions_into_new_structure	1
209	2023_07_28_125126_remove_additional_division_fields_from_offer	1
210	2023_07_30_110644_offers_additional_information	1
211	2023_07_30_142049_migrate_offer_additional_information	1
212	2023_08_04_122837_consistent_l_p_for_immortal	1
213	2023_08_05_182637_infinite_option_in_freezelog	1
214	2023_08_06_201431_make_balances_unsigned	1
215	2023_08_07_124131_strongly_typed_summoner_spells	1
216	2023_08_08_111901_remove_language_from_coachings_and_standardize_lang	1
217	2023_08_11_155417_create_index_on_user_name	1
218	2023_08_13_183028_create_index_on_authenticationlogs	1
219	2023_08_16_171202_consistent_lp_for_invoices	1
220	2023_08_16_221001_transfer_account_model_to_boost_model	1
221	2023_08_27_222152_migrate_users_to_new_balance_approach	1
222	2023_09_02_190616_create_media_table	1
223	2023_09_06_204357_migrate_boosters_to_new_balance_approach	1
224	2023_09_09_111107_copy_blogpost_image_to_media_collection	1
225	2023_09_09_123526_remove_leftovers	1
226	2023_09_23_010357_make_placement_boosts_and_orders_clearer	1
227	2023_09_23_053027_change_screenshots_url_column	1
228	2023_09_24_052042_add_columns_to_chat_message	1
229	2023_09_26_180905_remove_uploadcare_trash	1
230	2023_09_28_081418_remove_screenshots_table	1
231	2023_09_29_225353_add_index_on_status_column	1
232	2023_10_03_084218_add_is_read_notification_to_chat_message	1
233	2023_10_04_084218_add_title_to_chat_message	1
234	2023_10_05_193329_delete_admin_description_from_offers	1
235	2023_10_16_174524_migrate_boosts_coachings_offers_to_new_balance_approach	1
236	2023_11_07_181313_rename_valorant_to_vrt_in_booster_main_game	1
237	2023_11_13_134701_bans	1
238	2023_11_15_202031_update_schedule_format	1
239	2023_11_16_170352_migrate_orders_table_to_new_approach	1
240	2023_11_19_181716_create_offer_orders_table	1
241	2023_11_20_133056_remove_flex_and_loyalty_points_from_boosts	1
242	2023_11_20_201112_delete_invoices_table	1
243	2023_11_23_112011_change_default_status_of_boost_to8	1
244	2023_11_23_134756_transition_old_service_type_to_new_convention	1
245	2023_11_26_230643_migrate_tft_to_emerald	1
246	2023_11_27_005612_delete_old_balance_columns	1
247	2023_11_28_154433_add_payments_suspended_cause_to_users_table	1
248	2023_12_01_073446_add_is_main_blog_post	1
249	2023_12_02_075323_create_post_category	1
250	2023_12_09_202921_create_indexes_on_orders_morph	1
251	2023_12_10_190848_create_label_table	1
252	2023_12_10_194238_create_post_label	1
253	2023_12_10_204244_create_base_categories	1
254	2023_12_30_093640_migrate_properties_to_json	1
255	2024_01_05_184858_migrate_social_providers_to_separate_table	1
256	2024_01_18_175759_migrate_coaching_to_new_structure	1
257	2024_01_25_181720_add_uuid_to_offers	1
258	2024_01_26_132830_remove_giftbox	1
259	2024_01_28_173025_convert_limitations_to_new_structure	1
260	2024_01_29_173827_offer_new_fields	1
261	2024_02_14_145411_convert_to_offer_to_gameenum	1
269	2024_03_02_163947_add_additional_fields_to_profile	2
270	2024_03_07_182626_migrate_lol_primary_role_solo_and_secondary_to_roles	2
271	2024_03_08_182626_migrate_lol_primary_role_solo_and_secondary_to_roles_update	2
273	2024_03_17_184547_add_apex_fields_to_profiles	2
275	2024_03_20_093048_create_audits_table	2
276	2024_03_22_122628_add_rocket_platform_field_to_profiles	2
277	2024_03_24_134801_add_coupon_value_to_order	2
279	2024_03_26_182829_add_index_on_user_id_in_chat_messages	2
280	2024_03_27_074008_create_rank_reservations_table	2
281	2024_03_30_012401_allow_rank_reservations_to_be_disactivated	2
282	2024_04_03_152142_create_favourite_contractors	2
283	2024_04_06_081951_add_uuid_to_users_table	2
284	2024_04_06_111714_add_index_on_boost_id_in_reasons	2
285	2024_04_06_111836_add_index_on_user_id_in_bans	2
286	2024_04_08_142238_rename_tiers_to_string_based_enums	2
287	2024_04_14_063015_add_changed_to_waiting_for_booster_at_column	2
288	2024_04_14_063015_drop_changed_to_waiting_for_booster_at_column	2
289	2024_04_15_082410_rename_user_verification_table_to_verification_session	2
290	2024_04_15_191251_change_auditable_column_types	2
291	2024_04_18_102413_use_jsonb_for_transactions_meta	2
292	2024_04_18_144538_create_index_on_service_id_for_transactions	2
293	2024_04_18_194835_migrate_to_common_high_tier	2
294	2024_04_20_070716_add_in_game_name_changeable_column_to_offers	2
295	2024_04_23_172001_add_marketplace_verification_column_to_user	2
296	2024_04_25_231449_create_verification_requirements_table	2
297	2024_04_26_091441_common_pay_per_games	2
298	2024_04_27_135247_unique_username	2
299	2024_05_02_141038_add_wildrift_champions_roles_and_servers_to_profile	2
300	2024_05_02_141355_create_wr_cashback_settings	2
301	2024_05_13_101845_create_blacklisted_users_table	2
302	2024_05_14_092437_remove_boostify_username_from_users	2
303	2024_05_17_111234_create_job_batches_table	3
304	2024_05_17_111247_create_notifications_table	3
305	2024_05_17_111300_create_imports_table	3
306	2024_05_17_111301_create_exports_table	3
307	2024_05_17_111302_create_failed_import_rows_table	3
308	2024_05_20_050440_drop_blacklisted_users_and_create_blacklisted_values	3
309	2024_05_23_145233_make_is_read_notification_non_nullable	3
310	2024_05_24_163058_remove_unnessesary_tables	3
317	2024_05_30_050151_remove_user_agent_values_from_blacklist	4
318	2024_05_30_110727_create_user_marketplace_profile_table	4
319	2024_06_24_225309_create_index_on_user_id_in_user_marketplace_profiles	4
320	2024_06_25_223100_create_is_impersonation_on_authentication_logs	4
328	2024_06_28_083149_add_reservation_expires_at_to_boosts_and_coaching	5
329	2024_06_30_055312_migrate_lol_ppg_divisions	5
330	2024_07_01_101925_remove_logout_at	5
331	2024_07_01_105312_migrate_arena_to_win_arena	5
332	2024_07_01_212248_make_hash_unique_in_orders	5
333	2024_07_05_120933_create_accounts_table	5
334	2024_07_19_065312_migrate_arena_service_type_to_proper_one	5
335	2024_07_19_095032_remove_admin_offer_column	5
336	2024_07_19_165032_add_recover_code_to_users_table	5
337	2024_07_29_100944_fix_double_encryption_for_accounts	5
338	2024_08_03_144154_rename_user_social_provider_table	5
339	2024_08_08_095831_add_user_constrain_to_offers	5
340	2024_08_12_140509_add_recovery_email_sent_at_to_orders	5
341	2024_08_14_142652_add_extended_and_boost_id_to_reservationaccountreservation	5
342	2024_08_20_174034_fix_offers	5
350	2024_08_20_213958_drop_forgein_key_constraint_from_rental_account_renals	6
351	2024_08_22_190609_create_index_on_accounts.game	6
352	2024_08_29_155233_optimize_reviews_table	6
353	2024_09_09_093145_create_index_on_users.role	6
354	2024_09_10_153624_remove_discount_from_offers_table	6
355	2024_09_12_132810_process_all_verification_sessions	6
356	2024_09_15_102943_change_price_to_seller_price_in_offers	6
364	2024_09_23_135812_create_marketplace_fees_table	7
365	2024_10_03_171740_change_last_active_at_to_not_null_in_users	7
366	2024_10_10_090042_add_default_to_last_active_at	7
367	2024_10_21_135208_migrate_marketplace_accounts_to_enums	7
368	2024_10_22_135208_remove_invoice_logs	7
369	2024_10_26_120015_add_no_progress_to_reason_table	7
370	2024_11_10_115543_add_checker_info_to_accounts	7
371	2024_11_14_105208_accounts_issues	7
372	2024_11_16_053305_accounts_rental_issues	7
373	2024_11_16_063305_accounts_rental_issues2	7
374	2024_11_28_154042_create_security_deposit_wallet	7
375	2024_12_08_153846_add_ready_to_play_columns	7
376	2024_12_13_124539_strongly_type_profiles	7
377	2024_12_18_081601_rename_ready_to_play_column	7
378	2024_12_18_121438_default_values_for_profiles	7
379	2024_12_19_155714_change_default_percentage_for_boosts	7
380	2024_12_20_010932_dispute_solve_in_offers	7
381	2024_12_30_000426_create_service_rates_table	7
382	2025_01_06_145933_revert_default_rate_for_boosts_to50	7
383	2025_01_09_003220_offer_order_orders_issue	7
384	2025_01_09_003220_reference_services_in_reviews	7
385	2025_01_10_003220_add_index_to_orders_user_id_column	7
386	2025_01_11_133329_reviews_indexes	7
387	2025_01_11_133510_bans_on_delete_cascade	7
388	2025_01_12_132707_banned_by_id_constrain	7
390	2025_01_22_180016_create_popup_reports_table	7
394	2023_12_30_113122_extra_columns_removed	8
395	2023_12_30_204610_soft_delete	8
396	2024_01_24_185401_add_extra_column_in_transfer	8
402	2025_01_31_134700_add_meta_title_and_meta_description_to_posts	8
411	2025_02_04_163048_remove_is_read_notification_from_chatmessages	9
412	2025_02_16_120111_make_warranty_parameter_int	9
413	2025_02_25_131735_add_check_constraint_to_reviews_table	9
414	2025_02_25_235505_add_index_to_user_social_providers	9
415	2025_03_03_115727_divide_role_fields	9
416	2025_03_16_131729_create_disputes_table	9
417	2025_03_22_142852_create_marketplace_galleries_table	9
420	2025_04_30_015234_new_coaching	9
421	2025_05_16_085622_add_account_email_and_account_email_password_to_accounts	9
422	2025_05_25_165940_verification_requirement_reason	9
423	2025_05_26_000000_remove_email_fields_from_offers_and_add_provider_link_to_accounts	9
424	2025_06_02_000000_issues_accounts	9
425	2025_06_03_000000_issues_accounts	9
427	2025_06_08_055415_add_title_to_offers_table	10
441	2025_06_28_191208_add_index_to_user_id_in_offers	11
442	2025_07_05_092516_indexes_for_offer_resource	11
445	2025_07_25_095733_create_zippy_purchases_table	11
446	2025_08_07_181351_zippy_services_family_created_at	11
447	2025_08_07_184413_add_zippy_to_reviews	11
449	2025_08_12_122650_cleanup_languages	11
450	2025_08_13_141928_add_index_to_verified_seller_in_user_marketplace_profiles	11
451	2025_08_14_212526_add_schedule_to_zippy_purchase	11
452	2025_08_14_214344_update_reviews_constrain	11
453	2025_08_17_155409_add_price_to_zippypurchase	11
454	2025_08_18_205256_add_soft_deletes_to_zippy	11
455	2025_08_22_131219_index_boosts	11
456	2025_09_02_122608_offer_description_not_null	11
457	2025_09_15_124004_recover_lost_passwords	11
458	2025_09_15_190627_add_subtitle_to_zippy_profiles	11
459	2025_09_15_200122_add_additional_to_zippy_offers	11
460	2025_09_23_124004_teammate_boost	11
461	2025_10_02_130000_arena_issue	11
462	2025_10_03_100000_add_deactivation_job_uuid_to_zippy_profiles_table	11
463	2025_10_04_120000_add_game_accounts_to_users_and_summoner_name_to_zippy_purchases	11
464	2025_10_06_074225_username_change_date	11
465	2025_10_28_202927_convert_game_account_to_string	11
466	2023_07_26_211003_create_lol_cashback_settings	12
467	2023_07_26_215226_create_tft_cashback_settings	12
468	2023_07_26_215231_create_vrt_cashback_settings	12
469	2024_02_24_215231_create_ow_cashback_settings	12
470	2024_03_14_215231_create_ap_cashback_settings	12
471	2024_03_19_164025_create_rl_cashback_settings	12
472	2024_03_25_155639_create_cs_cashback_settings	12
473	2025_01_15_155639_create_mr_cashback_settings	12
474	2025_04_26_155639_create_fn_cashback_settings	12
475	2025_04_28_155639_create_coc_cashback_settings	12
476	2025_06_13_123622_zippy_product_info_settings	12
477	2025_06_18_155639_create_new_gamescashback_settings	12
478	2025_07_15_181216_ai_fraud_detection_settings	12
479	2025_07_21_155639_create_new_gamescashback_settings	12
480	2025_08_08_135747_zippy_cashback	12
481	2025_08_20_000000_make_disputes_polymorphic	12
482	2025_08_24_000000_create_username_settings	12
483	2025_09_15_120000_add_ggirls_games_product_info	12
484	2025_11_05_113904_allow_mesage_to_be_null_in_chat_messages	12
485	2025_11_07_131134_searchable_vector_to_offers	12
486	2025_11_07_150000_add_zippy_purchase_id_to_rental_account_rentals	12
487	2025_11_07_163404_create_marketplace_items_table	12
488	2025_11_15_092550_modify_marketplace_fees	12
489	2025_11_24_120000_add_ultimate_monthly_coaching_product_setting	12
490	2025_11_25_120000_add_age_and_cod_version_to_zippy_profiles	12
491	2025_11_25_120000_archive_old_services	12
492	2025_12_24_000000_make_freezelogs_polymorphic	12
493	2025_12_29_000000_fix_arc_raiders_game_value_in_marketplace_items	12
494	2025_12_29_120000_create_ar_cashback_settings	12
495	2025_12_30_164700_change_description_to_text_in_marketplace_items_table	12
496	2025_12_31_000000_make_profile_languages_not_nullable	12
497	2025_12_31_120000_fix_ar_cashback_settings	12
498	2026_01_04_000000_rename_offer_old_status_to_disputable_old_status_in_disputes	12
499	2026_01_10_000000_update_service_rates_game_rbw_to_r6s	12
500	2026_01_15_000001_add_arc_raiders_platforms_to_profiles	12
501	2026_01_15_120000_create_payment_methods_table	12
502	2026_01_16_090000_remove_withdraw_fields_from_users_table	12
503	2026_01_24_000000_fix_arc_riders_game_value_in_marketplace_fees	12
504	2026_01_29_000000_add_marketplace_item_to_reviews	12
505	2026_01_29_000001_add_soft_deletes_to_payment_methods_table	12
506	2026_01_29_000002_add_sort_order_to_payment_methods_table	12
507	2026_02_04_000000_add_marketplace_item_id_index_to_reviews	12
508	2026_02_09_094519_add_quantity_to_marketplace_items_table	12
509	2026_02_09_112834_add_quantity_to_orders_table	12
510	2026_02_13_104428_create_swift_pass_profitability_table	12
511	2026_02_17_155951_change_payments_response_column_to_jsonb	12
512	2026_02_20_151934_create_chat_conversation_user_states_table	12
513	2026_03_05_232335_new_indexes	13
514	2026_03_06_122411_new_indexes2	13
515	2026_03_07_140520_indexes3	14
\.


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

SELECT pg_catalog.setval('public.migrations_id_seq', 515, true);


--
-- PostgreSQL database dump complete
--

\unrestrict gA8LmNrxqVQtznfFVniuDo2ira6humRFAfDsYQidbAdv8aI4tR6Ed12BxfygDR2

