-- -- PostgreSQL database dump -- -- Dumped from database version 14.7 -- Dumped by pg_dump version 14.7 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: achievement; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.achievement ( id bigint NOT NULL, time_received timestamp with time zone NOT NULL, achievement_id bigint NOT NULL, sportsman_id bigint NOT NULL ); ALTER TABLE public.achievement OWNER TO sports; -- -- Name: achievement_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.achievement ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.achievement_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: achievements; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.achievements ( id bigint NOT NULL, title character varying(128) NOT NULL, description character varying(255) NOT NULL, image character varying(100) NOT NULL, image_animated character varying(100), value double precision NOT NULL ); ALTER TABLE public.achievements OWNER TO sports; -- -- Name: achievements_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.achievements ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.achievements_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: auth_group; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.auth_group ( id integer NOT NULL, name character varying(150) NOT NULL ); ALTER TABLE public.auth_group OWNER TO sports; -- -- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.auth_group ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.auth_group_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.auth_group_permissions ( id bigint NOT NULL, group_id integer NOT NULL, permission_id integer NOT NULL ); ALTER TABLE public.auth_group_permissions OWNER TO sports; -- -- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.auth_group_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.auth_group_permissions_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: auth_permission; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.auth_permission ( id integer NOT NULL, name character varying(255) NOT NULL, content_type_id integer NOT NULL, codename character varying(100) NOT NULL ); ALTER TABLE public.auth_permission OWNER TO sports; -- -- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.auth_permission ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.auth_permission_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: auth_user; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.auth_user ( id bigint NOT NULL, password character varying(128) NOT NULL, last_login timestamp with time zone, is_superuser boolean NOT NULL, username character varying(150) NOT NULL, first_name character varying(150) NOT NULL, last_name character varying(150) NOT NULL, email character varying(254) NOT NULL, is_staff boolean NOT NULL, is_active boolean NOT NULL, date_joined timestamp with time zone NOT NULL, phone_number character varying(60) NOT NULL ); ALTER TABLE public.auth_user OWNER TO sports; -- -- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.auth_user_groups ( id bigint NOT NULL, sharixuser_id bigint NOT NULL, group_id integer NOT NULL ); ALTER TABLE public.auth_user_groups OWNER TO sports; -- -- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.auth_user_groups ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.auth_user_groups_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.auth_user ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.auth_user_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.auth_user_user_permissions ( id bigint NOT NULL, sharixuser_id bigint NOT NULL, permission_id integer NOT NULL ); ALTER TABLE public.auth_user_user_permissions OWNER TO sports; -- -- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.auth_user_user_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.auth_user_user_permissions_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: authtoken_token; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.authtoken_token ( key character varying(40) NOT NULL, created timestamp with time zone NOT NULL, user_id bigint NOT NULL ); ALTER TABLE public.authtoken_token OWNER TO sports; -- -- Name: blocked_sportsman; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.blocked_sportsman ( id bigint NOT NULL, sportsman_id bigint NOT NULL, sportsman_blocked_id bigint NOT NULL ); ALTER TABLE public.blocked_sportsman OWNER TO sports; -- -- Name: blocked_sportsman_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.blocked_sportsman ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.blocked_sportsman_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: browse_event; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.browse_event ( id bigint NOT NULL, time_browsed timestamp with time zone NOT NULL, event_browseevent_id bigint NOT NULL, sportsman_id bigint NOT NULL ); ALTER TABLE public.browse_event OWNER TO sports; -- -- Name: browse_event_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.browse_event ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.browse_event_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: browse_sportsman; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.browse_sportsman ( id bigint NOT NULL, time_browsed timestamp with time zone NOT NULL, sportsman_id bigint NOT NULL, sportsman_browsed_id bigint NOT NULL ); ALTER TABLE public.browse_sportsman OWNER TO sports; -- -- Name: browse_sportsman_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.browse_sportsman ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.browse_sportsman_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: client; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.client ( id bigint NOT NULL, requirements character varying(150) NOT NULL, status character varying(150) NOT NULL, id_metaservice bigint, is_global boolean NOT NULL, is_visible boolean NOT NULL, ticket_status_id bigint NOT NULL, user_id bigint NOT NULL ); ALTER TABLE public.client OWNER TO sports; -- -- Name: client_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.client ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.client_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: company; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.company ( id bigint NOT NULL, legal_name character varying(150) NOT NULL, inn character varying(12) NOT NULL, kpp character varying(9) NOT NULL, ogrn character varying(13) NOT NULL, bank_name character varying(150) NOT NULL, bik character varying(9) NOT NULL, ks character varying(50) NOT NULL, rs character varying(50) NOT NULL, address character varying(150) NOT NULL, requirements character varying(150) NOT NULL, status character varying(150) NOT NULL, id_metaservice bigint, is_global boolean NOT NULL, is_visible boolean NOT NULL, repr_id_id bigint NOT NULL, ticket_status_id bigint NOT NULL ); ALTER TABLE public.company OWNER TO sports; -- -- Name: company_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.company ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.company_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: django_admin_log; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.django_admin_log ( id integer NOT NULL, action_time timestamp with time zone NOT NULL, object_id text, object_repr character varying(200) NOT NULL, action_flag smallint NOT NULL, change_message text NOT NULL, content_type_id integer, user_id bigint NOT NULL, CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0)) ); ALTER TABLE public.django_admin_log OWNER TO sports; -- -- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.django_admin_log ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.django_admin_log_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: django_content_type; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.django_content_type ( id integer NOT NULL, app_label character varying(100) NOT NULL, model character varying(100) NOT NULL ); ALTER TABLE public.django_content_type OWNER TO sports; -- -- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.django_content_type ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.django_content_type_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: django_flatpage; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.django_flatpage ( id integer NOT NULL, url character varying(100) NOT NULL, title character varying(200) NOT NULL, content text NOT NULL, enable_comments boolean NOT NULL, template_name character varying(70) NOT NULL, registration_required boolean NOT NULL ); ALTER TABLE public.django_flatpage OWNER TO sports; -- -- Name: django_flatpage_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.django_flatpage ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.django_flatpage_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: django_flatpage_sites; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.django_flatpage_sites ( id bigint NOT NULL, flatpage_id integer NOT NULL, site_id integer NOT NULL ); ALTER TABLE public.django_flatpage_sites OWNER TO sports; -- -- Name: django_flatpage_sites_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.django_flatpage_sites ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.django_flatpage_sites_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: django_migrations; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.django_migrations ( id bigint NOT NULL, app character varying(255) NOT NULL, name character varying(255) NOT NULL, applied timestamp with time zone NOT NULL ); ALTER TABLE public.django_migrations OWNER TO sports; -- -- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.django_migrations ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.django_migrations_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: django_session; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.django_session ( session_key character varying(40) NOT NULL, session_data text NOT NULL, expire_date timestamp with time zone NOT NULL ); ALTER TABLE public.django_session OWNER TO sports; -- -- Name: django_site; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.django_site ( id integer NOT NULL, domain character varying(100) NOT NULL, name character varying(50) NOT NULL ); ALTER TABLE public.django_site OWNER TO sports; -- -- Name: django_site_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.django_site ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.django_site_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: documents; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.documents ( id bigint NOT NULL, check_date timestamp with time zone NOT NULL, check_level integer NOT NULL, expire_date timestamp with time zone, id_metaservice bigint, requirements character varying(150) NOT NULL, status character varying(150) NOT NULL, datalink text NOT NULL, doc_type character varying(150) NOT NULL, is_global boolean NOT NULL, is_visible boolean NOT NULL, checked_by_id bigint, company_id_id bigint, ticket_status_id bigint NOT NULL, user_id_id bigint NOT NULL ); ALTER TABLE public.documents OWNER TO sports; -- -- Name: documents_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.documents ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.documents_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: event; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.event ( id bigint NOT NULL, rating_id integer, attempts integer, order_place_type character varying(150), order_place_start character varying(150), order_place_start_gps character varying(150), order_place_start_sector integer, order_place_start_real character varying(150), order_place_start_real_gps character varying(150), order_place_finish_predicted character varying(150), order_place_finish_predicted_gps character varying(150), order_place_finish_sector integer, order_place_finish_real character varying(150), order_place_finish_real_gps character varying(150), required_gender character varying(1), description character varying(512) NOT NULL, time_updated timestamp with time zone, time_close timestamp with time zone, max_participants integer NOT NULL, min_participants integer NOT NULL, max_age integer NOT NULL, min_age integer NOT NULL, is_public boolean NOT NULL, host_id bigint NOT NULL, order_synced_id bigint NOT NULL, resource_id_id bigint, sport_id bigint NOT NULL, min_level integer, max_level integer ); ALTER TABLE public.event OWNER TO sports; -- -- Name: event_gallery; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.event_gallery ( id bigint NOT NULL, image character varying(100) NOT NULL, event_id bigint NOT NULL ); ALTER TABLE public.event_gallery OWNER TO sports; -- -- Name: event_gallery_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.event_gallery ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.event_gallery_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: event_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.event ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.event_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: orders; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.orders ( id bigint NOT NULL, state character varying(150) NOT NULL, id_metaservice bigint, time_created timestamp with time zone NOT NULL, time_placed timestamp with time zone NOT NULL, time_start timestamp with time zone, time_start_real timestamp with time zone, time_start_predicted timestamp with time zone, time_finish_predicted timestamp with time zone NOT NULL, time_finish_real timestamp with time zone, predicted_price double precision NOT NULL, real_price double precision NOT NULL, is_global boolean NOT NULL, is_visible boolean NOT NULL, client_id_id bigint, provider_id bigint, receiver_id bigint, service_id bigint, service_type_id bigint, ticket_id bigint ); ALTER TABLE public.orders OWNER TO sports; -- -- Name: orders_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.orders ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.orders_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: participant; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.participant ( id bigint NOT NULL, is_finished boolean NOT NULL, event_participant_id bigint NOT NULL, sportsman_id bigint NOT NULL ); ALTER TABLE public.participant OWNER TO sports; -- -- Name: participant_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.participant ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.participant_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: permissions; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.permissions ( id bigint NOT NULL, check_date timestamp with time zone, id_permissions bigint NOT NULL, check_level character varying(10) NOT NULL, status character varying(150) NOT NULL, id_metaservice bigint NOT NULL, is_global boolean NOT NULL, is_visible boolean NOT NULL, checked_by_id bigint, ticket_status_id bigint, user_id_id bigint ); ALTER TABLE public.permissions OWNER TO sports; -- -- Name: permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.permissions_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: provider; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.provider ( id bigint NOT NULL, type character varying(150) NOT NULL, id_metaservice bigint, requirements character varying(300) NOT NULL, status character varying(150) NOT NULL, location_type character varying(300) NOT NULL, default_location character varying(300) NOT NULL, is_global boolean NOT NULL, is_visible boolean NOT NULL, company_id_id bigint, ticket_status_id bigint, user_id_id bigint ); ALTER TABLE public.provider OWNER TO sports; -- -- Name: provider_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.provider ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.provider_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: relationship; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.relationship ( id bigint NOT NULL, neg_type integer NOT NULL, id_metaservice bigint, requirements character varying(150) NOT NULL, status character varying(150) NOT NULL, is_global boolean NOT NULL, is_visible boolean NOT NULL, ticket_status_id bigint NOT NULL, user_id_who_id bigint NOT NULL, user_id_whom_id bigint NOT NULL ); ALTER TABLE public.relationship OWNER TO sports; -- -- Name: relationship_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.relationship ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.relationship_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: resource; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.resource ( id bigint NOT NULL, type_id character varying(10) NOT NULL, requirements character varying(150) NOT NULL, status character varying(150) NOT NULL, id_metaservice bigint, is_global boolean NOT NULL, is_visible boolean NOT NULL, ticket_status_id bigint NOT NULL, user_id_id bigint NOT NULL ); ALTER TABLE public.resource OWNER TO sports; -- -- Name: resource_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.resource ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.resource_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: saved_event; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.saved_event ( id bigint NOT NULL, event_savedevent_id bigint NOT NULL, sportsman_id bigint NOT NULL ); ALTER TABLE public.saved_event OWNER TO sports; -- -- Name: saved_event_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.saved_event ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.saved_event_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: saved_sportsman; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.saved_sportsman ( id bigint NOT NULL, sportsman_id bigint NOT NULL, sportsman_saved_id bigint NOT NULL ); ALTER TABLE public.saved_sportsman OWNER TO sports; -- -- Name: saved_sportsman_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.saved_sportsman ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.saved_sportsman_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: service; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.service ( id bigint NOT NULL, requirements character varying(150) NOT NULL, id_metaservice bigint, price_alg character varying(100) NOT NULL, price_km numeric(9,2) NOT NULL, price_min numeric(9,2) NOT NULL, price_amount numeric(9,2) NOT NULL, service_status character varying(150) NOT NULL, status character varying(150) NOT NULL, is_global boolean NOT NULL, is_visible boolean NOT NULL, id_provider_id bigint NOT NULL, resource_id_id bigint, servicetype_id_id bigint NOT NULL, ticket_status_id bigint NOT NULL ); ALTER TABLE public.service OWNER TO sports; -- -- Name: service_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.service ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.service_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: servicetype; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.servicetype ( id bigint NOT NULL, codename character varying(255) NOT NULL, caption character varying(255) NOT NULL, description text NOT NULL, requirements character varying(300) NOT NULL, price_type character varying(150) NOT NULL, status character varying(150) NOT NULL, id_metaservice bigint NOT NULL, link_agreement character varying(400) NOT NULL, is_global boolean NOT NULL, is_visible boolean NOT NULL, ticket_status_id bigint ); ALTER TABLE public.servicetype OWNER TO sports; -- -- Name: servicetype_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.servicetype ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.servicetype_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: sport; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.sport ( id bigint NOT NULL, title character varying(128) NOT NULL, image character varying(100) NOT NULL ); ALTER TABLE public.sport OWNER TO sports; -- -- Name: sport_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.sport ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.sport_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: sport_preferrence; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.sport_preferrence ( id bigint NOT NULL, sport_id bigint NOT NULL, sportsman_id bigint NOT NULL ); ALTER TABLE public.sport_preferrence OWNER TO sports; -- -- Name: sport_preferrence_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.sport_preferrence ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.sport_preferrence_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: sportsman; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.sportsman ( id bigint NOT NULL, bio character varying(512) NOT NULL, level double precision NOT NULL, birthdate date, active_status character varying(64) NOT NULL, time_updated timestamp with time zone, preferred_time character varying(128) NOT NULL, reliance_rating double precision NOT NULL, gender character varying(1), client_id bigint NOT NULL ); ALTER TABLE public.sportsman OWNER TO sports; -- -- Name: sportsman_gallery; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.sportsman_gallery ( id bigint NOT NULL, image character varying(100) NOT NULL, sportsman_id bigint NOT NULL ); ALTER TABLE public.sportsman_gallery OWNER TO sports; -- -- Name: sportsman_gallery_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.sportsman_gallery ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.sportsman_gallery_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: sportsman_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.sportsman ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.sportsman_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: tickets_attachment; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.tickets_attachment ( id bigint NOT NULL, "timestamp" timestamp with time zone NOT NULL, file character varying(255) NOT NULL, added_by_id bigint NOT NULL, task_id bigint NOT NULL ); ALTER TABLE public.tickets_attachment OWNER TO sports; -- -- Name: tickets_attachment_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.tickets_attachment ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.tickets_attachment_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: tickets_comment; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.tickets_comment ( id bigint NOT NULL, date timestamp with time zone NOT NULL, email_from character varying(320), email_message_id character varying(255), body text NOT NULL, author_id bigint, task_id bigint NOT NULL ); ALTER TABLE public.tickets_comment OWNER TO sports; -- -- Name: tickets_comment_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.tickets_comment ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.tickets_comment_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: tickets_task; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.tickets_task ( id bigint NOT NULL, status smallint, created_date date NOT NULL, status_changed_date timestamp with time zone NOT NULL, priority smallint NOT NULL, title character varying(64) NOT NULL, note text, due_date date, assigned_to_id bigint, created_by_id bigint, task_list_id bigint NOT NULL, type_id bigint, CONSTRAINT tickets_task_priority_check CHECK ((priority >= 0)), CONSTRAINT tickets_task_status_check CHECK ((status >= 0)) ); ALTER TABLE public.tickets_task OWNER TO sports; -- -- Name: tickets_task_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.tickets_task ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.tickets_task_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: tickets_tasklist; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.tickets_tasklist ( id bigint NOT NULL, name character varying(48) NOT NULL, slug character varying(50) NOT NULL, group_id integer NOT NULL ); ALTER TABLE public.tickets_tasklist OWNER TO sports; -- -- Name: tickets_tasklist_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.tickets_tasklist ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.tickets_tasklist_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Name: tickets_tickettype; Type: TABLE; Schema: public; Owner: sports -- CREATE TABLE public.tickets_tickettype ( id bigint NOT NULL, name character varying(32) NOT NULL, life_cycle character varying(350) NOT NULL ); ALTER TABLE public.tickets_tickettype OWNER TO sports; -- -- Name: tickets_tickettype_id_seq; Type: SEQUENCE; Schema: public; Owner: sports -- ALTER TABLE public.tickets_tickettype ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY ( SEQUENCE NAME public.tickets_tickettype_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ); -- -- Data for Name: achievement; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.achievement (id, time_received, achievement_id, sportsman_id) FROM stdin; \. -- -- Data for Name: achievements; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.achievements (id, title, description, image, image_animated, value) FROM stdin; \. -- -- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.auth_group (id, name) FROM stdin; 1 METASERVICE-ADMIN 2 METASERVICE-SUPERVISOR 3 METASERVICE-SUPPORT 4 METASERVICE-TECHSUPPORT 5 PARTNER-ADMIN 6 PARTNER-SUPERVISOR 7 PARTNER-TECHSUPPORT 8 PARTNER-SUPPORT 9 GUEST 10 CLIENT 11 PROVIDER \. -- -- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.auth_group_permissions (id, group_id, permission_id) FROM stdin; \. -- -- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin; 1 Can add log entry 1 add_logentry 2 Can change log entry 1 change_logentry 3 Can delete log entry 1 delete_logentry 4 Can view log entry 1 view_logentry 5 Can add permission 2 add_permission 6 Can change permission 2 change_permission 7 Can delete permission 2 delete_permission 8 Can view permission 2 view_permission 9 Can add group 3 add_group 10 Can change group 3 change_group 11 Can delete group 3 delete_group 12 Can view group 3 view_group 13 Can add content type 4 add_contenttype 14 Can change content type 4 change_contenttype 15 Can delete content type 4 delete_contenttype 16 Can view content type 4 view_contenttype 17 Can add session 5 add_session 18 Can change session 5 change_session 19 Can delete session 5 delete_session 20 Can view session 5 view_session 21 Can add sharix user 6 add_sharixuser 22 Can change sharix user 6 change_sharixuser 23 Can delete sharix user 6 delete_sharixuser 24 Can view sharix user 6 view_sharixuser 25 Can add ticket type 7 add_tickettype 26 Can change ticket type 7 change_tickettype 27 Can delete ticket type 7 delete_tickettype 28 Can view ticket type 7 view_tickettype 29 Can add Ticket List 8 add_tasklist 30 Can change Ticket List 8 change_tasklist 31 Can delete Ticket List 8 delete_tasklist 32 Can view Ticket List 8 view_tasklist 33 Can add Ticket 9 add_task 34 Can change Ticket 9 change_task 35 Can delete Ticket 9 delete_task 36 Can view Ticket 9 view_task 37 Can add attachment 10 add_attachment 38 Can change attachment 10 change_attachment 39 Can delete attachment 10 delete_attachment 40 Can view attachment 10 view_attachment 41 Can add Comment 11 add_comment 42 Can change Comment 11 change_comment 43 Can delete Comment 11 delete_comment 44 Can view Comment 11 view_comment 45 Can add Клиента 12 add_client 46 Can change Клиента 12 change_client 47 Can delete Клиента 12 delete_client 48 Can view Клиента 12 view_client 49 Can add Компания 13 add_company 50 Can change Компания 13 change_company 51 Can delete Компания 13 delete_company 52 Can view Компания 13 view_company 53 Can add Документ 14 add_documents 54 Can change Документ 14 change_documents 55 Can delete Документ 14 delete_documents 56 Can view Документ 14 view_documents 57 Can add Заказ 15 add_orders 58 Can change Заказ 15 change_orders 59 Can delete Заказ 15 delete_orders 60 Can view Заказ 15 view_orders 61 Can add Разрешение 16 add_permissions 62 Can change Разрешение 16 change_permissions 63 Can delete Разрешение 16 delete_permissions 64 Can view Разрешение 16 view_permissions 65 Can add Поставщик 17 add_provider 66 Can change Поставщик 17 change_provider 67 Can delete Поставщик 17 delete_provider 68 Can view Поставщик 17 view_provider 69 Can add Связь (Договорное отношение) 18 add_relationship 70 Can change Связь (Договорное отношение) 18 change_relationship 71 Can delete Связь (Договорное отношение) 18 delete_relationship 72 Can view Связь (Договорное отношение) 18 view_relationship 73 Can add Ресурс 19 add_resource 74 Can change Ресурс 19 change_resource 75 Can delete Ресурс 19 delete_resource 76 Can view Ресурс 19 view_resource 77 Can add Услуга 20 add_service 78 Can change Услуга 20 change_service 79 Can delete Услуга 20 delete_service 80 Can view Услуга 20 view_service 81 Can add Тип услуги 21 add_servicetype 82 Can change Тип услуги 21 change_servicetype 83 Can delete Тип услуги 21 delete_servicetype 84 Can view Тип услуги 21 view_servicetype 85 Can add достижение пользователя 22 add_achievement 86 Can change достижение пользователя 22 change_achievement 87 Can delete достижение пользователя 22 delete_achievement 88 Can view достижение пользователя 22 view_achievement 89 Can add достижения 23 add_achievements 90 Can change достижения 23 change_achievements 91 Can delete достижения 23 delete_achievements 92 Can view достижения 23 view_achievements 93 Can add заблокированный ползователь 24 add_blockedsportsman 94 Can change заблокированный ползователь 24 change_blockedsportsman 95 Can delete заблокированный ползователь 24 delete_blockedsportsman 96 Can view заблокированный ползователь 24 view_blockedsportsman 97 Can add просмотренное мероприятие 25 add_browseevent 98 Can change просмотренное мероприятие 25 change_browseevent 99 Can delete просмотренное мероприятие 25 delete_browseevent 100 Can view просмотренное мероприятие 25 view_browseevent 101 Can add просмотренный пользователь 26 add_browsesportsman 102 Can change просмотренный пользователь 26 change_browsesportsman 103 Can delete просмотренный пользователь 26 delete_browsesportsman 104 Can view просмотренный пользователь 26 view_browsesportsman 105 Can add мероприятие 27 add_event 106 Can change мероприятие 27 change_event 107 Can delete мероприятие 27 delete_event 108 Can view мероприятие 27 view_event 109 Can add участник 28 add_participant 110 Can change участник 28 change_participant 111 Can delete участник 28 delete_participant 112 Can view участник 28 view_participant 113 Can add сохранённое мероприятие 29 add_savedevent 114 Can change сохранённое мероприятие 29 change_savedevent 115 Can delete сохранённое мероприятие 29 delete_savedevent 116 Can view сохранённое мероприятие 29 view_savedevent 117 Can add сохранённый ползователь 30 add_savedsportsman 118 Can change сохранённый ползователь 30 change_savedsportsman 119 Can delete сохранённый ползователь 30 delete_savedsportsman 120 Can view сохранённый ползователь 30 view_savedsportsman 121 Can add вид спорта 31 add_sport 122 Can change вид спорта 31 change_sport 123 Can delete вид спорта 31 delete_sport 124 Can view вид спорта 31 view_sport 125 Can add предпочитаемый вид спорта 32 add_sportpreferrence 126 Can change предпочитаемый вид спорта 32 change_sportpreferrence 127 Can delete предпочитаемый вид спорта 32 delete_sportpreferrence 128 Can view предпочитаемый вид спорта 32 view_sportpreferrence 129 Can add Спортсмена 33 add_sportsman 130 Can change Спортсмена 33 change_sportsman 131 Can delete Спортсмена 33 delete_sportsman 132 Can view Спортсмена 33 view_sportsman 133 Can add фото пользователя 34 add_sportsmangallery 134 Can change фото пользователя 34 change_sportsmangallery 135 Can delete фото пользователя 34 delete_sportsmangallery 136 Can view фото пользователя 34 view_sportsmangallery 137 Can add фото мероприятия 35 add_eventgallery 138 Can change фото мероприятия 35 change_eventgallery 139 Can delete фото мероприятия 35 delete_eventgallery 140 Can view фото мероприятия 35 view_eventgallery 141 Can add Заказ (local) 36 add_orderslocal 142 Can change Заказ (local) 36 change_orderslocal 143 Can delete Заказ (local) 36 delete_orderslocal 144 Can view Заказ (local) 36 view_orderslocal 145 Can add site 37 add_site 146 Can change site 37 change_site 147 Can delete site 37 delete_site 148 Can view site 37 view_site 149 Can add flat page 38 add_flatpage 150 Can change flat page 38 change_flatpage 151 Can delete flat page 38 delete_flatpage 152 Can view flat page 38 view_flatpage 153 Can add Token 39 add_token 154 Can change Token 39 change_token 155 Can delete Token 39 delete_token 156 Can view Token 39 view_token 157 Can add token 40 add_tokenproxy 158 Can change token 40 change_tokenproxy 159 Can delete token 40 delete_tokenproxy 160 Can view token 40 view_tokenproxy 161 Can add Заказ (local) 41 add_orderslocal 162 Can change Заказ (local) 41 change_orderslocal 163 Can delete Заказ (local) 41 delete_orderslocal 164 Can view Заказ (local) 41 view_orderslocal \. -- -- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined, phone_number) FROM stdin; 5 pbkdf2_sha256$390000$97cCPzGHs8gcPLz2VAydDd$SwUt8EAPmAi5S17ATm6l1unXaDbY7Kh7CyQsenr5u4s= \N t test1 t t 2023-06-24 10:12:03+00 79999999999 4 pbkdf2_sha256$390000$dybPsuafHEh06gUzSQ7Fw9$+UpzOKi3Ot3oNoy3ee/sF8YqrWdB/IGDSC4JyoJBZ4k= \N f Test f t 2023-06-24 10:09:04+00 88888888888 1 pbkdf2_sha256$390000$PLZqNtiv7ychKYSMaVkI3X$G+tycHSegPGGMmLXFcxfro+xFqCjap7Jgsu/SKa4Gg4= 2023-06-24 13:51:07.010662+00 t 99999999999 Сервис Спортович t t 2023-06-17 13:59:37+00 99999999999 15 pbkdf2_sha256$390000$bQdDDgvw2F4D1lnQab2qgW$ExZcPmX3ImSkSGaI5GkVafNnZzme6V1R3uDaAfQE6pg= \N f sports_template_bot f t 2023-06-24 12:36:27.284185+00 sports_template_bot 16 pbkdf2_sha256$390000$kekVEGXAXKUluHCpYRDJvf$wivbeOZZqwzT3Y8NX41HCQqqYfzlejVHoKsXGA6sG+w= \N f sports_strequest_assigned f t 2023-06-24 12:36:27.630439+00 sports_strequest_assigned 17 pbkdf2_sha256$390000$GleT0WW9fwSAzb4fZU6GZR$3txGLVscE8XUw8Ce5tirerq/byM7bm2eIGn3tq7LuCc= \N f sports_strequest_inprocess f t 2023-06-24 12:36:27.877138+00 sports_strequest_inprocess 18 pbkdf2_sha256$390000$zRPekFypKQ9DTueSyykVOD$ukFbRQhbShLG3+kZa5XQ3V8Pf36Zg04a4OXsmB1zJFg= \N f sports_strequest_new f t 2023-06-24 12:36:28.135171+00 sports_strequest_new 19 pbkdf2_sha256$390000$oun5Qutuqn4yvN0Dsp5bl8$bTtGmLZHPQK8bd/3AjRDU/LJ7FZrmxPuWR8t5fex3LI= \N f sports_strequest_resportsed f t 2023-06-24 12:36:28.392955+00 sports_strequest_resportsed 33 pbkdf2_sha256$390000$0n6Rz6nYJsqeMCiZPpWDOm$CX6YvBSTDusYM2G+clqzsIUN2Y59I7Xk3aAh1tjuBaM= \N f sports_servicerequest_accepted f t 2023-06-24 12:36:31.968282+00 sports_servicerequest_accepted 34 pbkdf2_sha256$390000$mJwjx1NrM8kNJcRy40HTMt$zhx1bgJ+gd+WZDQAI4rFGUUheIh9T//J6oNwHJ/Kg9E= \N f sports_servicerequest_pending f t 2023-06-24 12:36:32.214478+00 sports_servicerequest_pending 2 pbkdf2_sha256$390000$T4acx0TrRjZNAMTAmLLN1m$IZnqLkTwNGGYDjPfMQrbgpAwOy3r8gLZyMFHw7nRBC0= \N t root t t 2023-06-21 14:52:07.01291+00 12345678910 35 pbkdf2_sha256$390000$t81KbTxa5Y49FZpmscZO6u$KiltayWTwnksNbr5qtzo/A9eGq2th5Z9TkfrGzikljM= \N f sports_servicerequest_declined f t 2023-06-24 12:36:32.4434+00 sports_servicerequest_declined 20 pbkdf2_sha256$390000$wdoorvumPI762QXTBi3KgI$UuHvXj1FdYA4tKr3ReWP6qMICXdZU4pUZCX3ARWKTuk= \N f sports_strequest_wontfix f t 2023-06-24 12:36:28.643123+00 sports_strequest_wontfix 36 pbkdf2_sha256$390000$rCOAqKLOq9l292mGg1ud8y$Zgteq8365mMM4ZzZJ1AgFvpNbM/odAX74NjdkQ5dDwM= \N f sports_servicerequest_prestart f t 2023-06-24 12:36:32.693525+00 sports_servicerequest_prestart 3 pbkdf2_sha256$390000$wiip0NdVLDVnulCvlcFQ85$HmPv4OM5unj3wb9FYCLXdQ+fBnajMLwApDnWI6YaTiI= \N t felocS Владислав Шипилов vlad.shipilov.felocs@gmail.com t t 2023-06-21 21:31:15+00 79204641558 21 pbkdf2_sha256$390000$cBLRSbMq5yWjr0umIXZuO0$H84um6D391JAxmPPSCFz92e8cDrfs+om9B8Utny8A6c= \N f sports_strequest_done f t 2023-06-24 12:36:28.884348+00 sports_strequest_done 22 pbkdf2_sha256$390000$ejjyB0sCQDfAvW3pBkwAeq$ECOW/7TiUONWDqJYqneowcPI+dvFej3A+8AZr/4XPD4= \N f sports_strequest_duplicate f t 2023-06-24 12:36:29.128037+00 sports_strequest_duplicate 23 pbkdf2_sha256$390000$uK1sMEIRnucBHNwF9aBwVF$yuIkYCOoX0DPlgvGkBSNc+tnQOWiKSljdxTrmh43gik= \N f sports_strequest_closed f t 2023-06-24 12:36:29.377061+00 sports_strequest_closed 24 pbkdf2_sha256$390000$c5JrqWZoKCk7D7gUuoK0Uq$siWs4V9GpCA5LzCzbasjsC8ni+Pa/YzA3lQxNAQllTM= \N f sports_accessrequest_pending f t 2023-06-24 12:36:29.618383+00 sports_accessrequest_pending 25 pbkdf2_sha256$390000$ySAURg3FEGd5eUJX4zLEUk$L+/TC8ovufb0BylTzV2QGkFMOe8klSMRAQQ11Q8BssQ= \N f sports_accessrequest_accepted f t 2023-06-24 12:36:29.885654+00 sports_accessrequest_accepted 26 pbkdf2_sha256$390000$qEA7iPRnVFQpYxBjC3bYCZ$BNiNQV/sLAPMSzwBupElmrXlim2Ji+5qQ/7V0NaYLZ0= \N f sports_accessrequest_declined f t 2023-06-24 12:36:30.185107+00 sports_accessrequest_declined 27 pbkdf2_sha256$390000$WHdjZxBS35WysCVxucuJM5$fEpwUbYgUHcboKDzAUgO4pk7ILjIbAOOjCq5OzNo2SQ= \N f sports_negrequest_pending f t 2023-06-24 12:36:30.459575+00 sports_negrequest_pending 28 pbkdf2_sha256$390000$zOcSy0ZA1dSUH5THrFuUQM$DrwfMzJoe3yJyM+1zUKSRsTkF5rbuglIReBd0vUKOvo= \N f sports_negrequest_accepted f t 2023-06-24 12:36:30.733452+00 sports_negrequest_accepted 29 pbkdf2_sha256$390000$8cPKZEnwrrhpM5oVsYXFBa$OjoP7W90iEN/qY2/aw7hnu734+FqZrg6PlIAPSl/ZmU= \N f sports_negrequest_declined f t 2023-06-24 12:36:30.97673+00 sports_negrequest_declined 30 pbkdf2_sha256$390000$R9zjN05XKCAg7D8z2q2V4t$72HiPPxBwa0gunZkvnGA6jYspSDYOW6HKXS2F9xSd+w= \N f sports_servicerequest_template f t 2023-06-24 12:36:31.234535+00 sports_servicerequest_template 31 pbkdf2_sha256$390000$ro2dNC0ivlin9ywwBTb8fC$kSjbEuCroUwgggobD/N/lsnVkUDI4TrnkTQM31//uMk= \N f sports_servicerequest_booked f t 2023-06-24 12:36:31.484782+00 sports_servicerequest_booked 32 pbkdf2_sha256$390000$GTFwRLUDdgkoOctnk1fEqb$ckFoUX1fWPDs1i6o2ZJjzZHxosvtq0W+oSFmMZ+V+Wk= \N f sports_servicerequest_assigned f t 2023-06-24 12:36:31.727424+00 sports_servicerequest_assigned 37 pbkdf2_sha256$390000$JxK2CF6Pgwy9wKo1Fc0lJH$rkUVHWXLQzb27O8lZhhPewlDJg42+TQLdACRbcFSqkc= \N f sports_servicerequest_process f t 2023-06-24 12:36:32.943394+00 sports_servicerequest_process 38 pbkdf2_sha256$390000$tXuLSNhSHwFB75mP0ifgqW$1mJPR1q9QdDe3SxSOwoVsfnmCD4M3cX+UXGyu5lPHEk= \N f sports_servicerequest_forcemajeure f t 2023-06-24 12:36:33.209939+00 sports_servicerequest_forcemajeure 39 pbkdf2_sha256$390000$jltzeSu3IINcIYlxOQ5snS$6mg59lbIUvOzkmtmCo0iyU7dIN8kpjoi40BgLqApqPs= \N f sports_servicerequest_forcemajeurecancelled f t 2023-06-24 12:36:33.459965+00 sports_servicerequest_forcemajeurecancelled 13 pbkdf2_sha256$390000$JfyYU1EE2xRC3gZXRCgbnM$nz5xlvOb7oDdMRTKxlHimsWwY6ECzaTMpPOVAvojI7Q= \N f 99999999992 Саппорт Спортович f t 2023-06-24 10:18:48+00 99999999992 12 pbkdf2_sha256$390000$jMsHV7OAEvQK0Bm76sZCDx$TZJGLiLX+2/s5uyfFOnbhWkc8FkTZj1Xul4wNeSik0I= \N f 99999999993 Техсаппорт Спортович f t 2023-06-24 10:18:18+00 99999999993 11 pbkdf2_sha256$390000$svk62Ltyqmx29DTm2yNVay$Pao6M5agIouVikpWa39kO1b9YwVJ64uv4rA9KD4aQnQ= \N f 99999999994 Админ Пспортович f t 2023-06-24 10:17:44+00 99999999994 10 pbkdf2_sha256$390000$xP8Pj1KBtDro9O5b0r6eLw$uZx3HF/R8ygoi4q/JFkOFmAW9xdz83XpHy7JxPAfidw= \N f 99999999995 Супервайзор Пспортович f t 2023-06-24 10:16:32+00 99999999995 9 pbkdf2_sha256$390000$mAxWgi7SlGlPMwILDNcF0M$qr28v3OUFBQICGF1L+nGGDscimO5E7bzCnrKBstwBcc= \N f 99999999996 Саппорт Пспортович f t 2023-06-24 10:15:52+00 99999999996 8 pbkdf2_sha256$390000$RUF3R7d0lblFqMYQXkQr3E$fIY7uy4V+k1hOMGItXOKQYFsMzmd+YOP7TeDo8f9rxU= \N f 99999999997 Техсаппорт Пспортович f t 2023-06-24 10:15:01+00 99999999997 7 pbkdf2_sha256$390000$j7GMhD8MmyzJZj01Wxy7RG$4fVK1NMh0Tu433IspV7ysALq3r8Oi5Tkalpz6tAABHc= \N f 99999999998 Поставщик Спортович f t 2023-06-24 10:14:05+00 99999999998 40 pbkdf2_sha256$390000$baQYopj6jMmwfXyHIYOiUH$fxCGdolR+Vhki5yQ6JDUktBf7L4V3EqJ5zl0Yb2DVDo= \N f sports_servicerequest_done f t 2023-06-24 12:36:33.709883+00 sports_servicerequest_done 41 pbkdf2_sha256$390000$1VVhFknkCsnrd2b6xPThvp$v2v/qAAqkCFiGyB28xgSkQ8Pli2L6NI5g7i3PJdHyRI= \N f sports_servicerequest_cancelled f t 2023-06-24 12:36:33.952072+00 sports_servicerequest_cancelled 42 pbkdf2_sha256$390000$ft7cVyxmPqEvUTO0ghCUMW$BaNDNsa9yEkxXnz/dXuW9/8Mw027ewuG9pFMBQfk0Qw= \N f sports_servicerequest_closed f t 2023-06-24 12:36:34.201401+00 sports_servicerequest_closed 14 pbkdf2_sha256$390000$IKPtuLyrTBoZ0UTHJ8erYn$2D9uoOpQiHdp5Zyss9o7uAPCad0FyQ2ED4jf/6tGlHY= \N f 99999999991 Супервайзор Спортович f t 2023-06-24 10:19:25+00 99999999991 43 pbkdf2_sha256$390000$cYF3tnhc9GdLBFBUpCZnKL$YjYxtTCU48JXujUQU1pPVWYkM8LYaGslZ1LGnc/yPi8= 2023-06-24 13:26:53.362771+00 t admin t t 2023-06-24 13:25:29.783884+00 12345678911 \. -- -- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.auth_user_groups (id, sharixuser_id, group_id) FROM stdin; 1 4 9 3 7 11 4 8 7 5 9 8 6 10 6 7 11 5 8 12 4 9 13 3 10 14 5 11 1 1 \. -- -- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.auth_user_user_permissions (id, sharixuser_id, permission_id) FROM stdin; \. -- -- Data for Name: authtoken_token; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.authtoken_token (key, created, user_id) FROM stdin; f644f9cc48a8f95d98b51f8f41dbf2e6c54d75df 2023-06-17 16:42:47.853245+00 1 \. -- -- Data for Name: blocked_sportsman; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.blocked_sportsman (id, sportsman_id, sportsman_blocked_id) FROM stdin; \. -- -- Data for Name: browse_event; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.browse_event (id, time_browsed, event_browseevent_id, sportsman_id) FROM stdin; \. -- -- Data for Name: browse_sportsman; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.browse_sportsman (id, time_browsed, sportsman_id, sportsman_browsed_id) FROM stdin; \. -- -- Data for Name: client; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.client (id, requirements, status, id_metaservice, is_global, is_visible, ticket_status_id, user_id) FROM stdin; 1 никаких 1 4 f f 1 2 2 фыв фыв 4 t t 1 1 \. -- -- Data for Name: company; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.company (id, legal_name, inn, kpp, ogrn, bank_name, bik, ks, rs, address, requirements, status, id_metaservice, is_global, is_visible, repr_id_id, ticket_status_id) FROM stdin; 1 фывф фыв фыв фыв фыв фыв фыв фыв фыв фыв фыв 4 f f 1 1 \. -- -- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin; 1 2023-06-17 16:42:47.854123+00 1 f644f9cc48a8f95d98b51f8f41dbf2e6c54d75df 1 [{"added": {}}] 40 1 2 2023-06-17 18:28:19.228093+00 23 Влад 1 [{"added": {}}] 8 1 3 2023-06-17 18:28:40.453925+00 1 sdfsdf 1 [{"added": {}}] 9 1 4 2023-06-17 18:28:56.103207+00 1 ServiceType object (1) 1 [{"added": {}}] 21 1 5 2023-06-17 18:32:19.343202+00 1 Sport object (1) 1 [{"added": {}}] 31 1 6 2023-06-17 18:32:52.81919+00 1 Client object (1) 1 [{"added": {}}] 12 1 7 2023-06-17 18:33:57.015711+00 1 Sportsman object (1) 1 [{"added": {}}] 33 1 8 2023-06-17 18:35:28.207544+00 1 Resource object (1) 1 [{"added": {}}] 19 1 9 2023-06-17 18:37:56.187854+00 1 Company object (1) 1 [{"added": {}}] 13 1 10 2023-06-17 18:38:10.291374+00 1 Provider object (1) 1 [{"added": {}}] 17 1 11 2023-06-17 18:38:27.586864+00 1 Service object (1) 1 [{"added": {}}] 20 1 12 2023-06-17 18:38:54.941619+00 2 Provider object (2) 1 [{"added": {}}] 17 1 13 2023-06-17 18:39:20.938309+00 1 Orders object (1) 1 [{"added": {}}] 15 1 14 2023-06-17 18:39:25.236357+00 1 Event object (1) 1 [{"added": {}}] 27 1 15 2023-06-21 15:43:10.077191+00 1 Client object (1) 2 [{"changed": {"fields": ["User"]}}] 12 1 16 2023-06-21 15:43:16.616566+00 2 Sportsman object (2) 2 [] 33 1 17 2023-06-21 15:43:59.735601+00 2 Client object (2) 1 [{"added": {}}] 12 1 18 2023-06-21 15:44:01.937987+00 2 Sportsman object (2) 2 [{"changed": {"fields": ["Client"]}}] 33 1 19 2023-06-21 21:33:11.615372+00 3 79204641558 1 [{"added": {}}] 6 1 20 2023-06-24 10:11:52.019596+00 4 88888888888 1 [{"added": {}}] 6 1 21 2023-06-24 10:12:41.15236+00 4 88888888888 2 [{"changed": {"fields": ["password"]}}] 6 1 22 2023-06-24 10:13:08.289544+00 5 79999999999 1 [{"added": {}}] 6 1 23 2023-06-24 10:13:57.330854+00 6 799999999999 1 [{"added": {}}] 6 1 24 2023-06-24 10:14:43.594172+00 7 799999999998 1 [{"added": {}}] 6 1 25 2023-06-24 10:15:40.20164+00 8 799999999997 1 [{"added": {}}] 6 1 26 2023-06-24 10:16:26.943709+00 9 799999999996 1 [{"added": {}}] 6 1 27 2023-06-24 10:17:16.039777+00 10 799999999995 1 [{"added": {}}] 6 1 28 2023-06-24 10:18:11.637058+00 11 799999999994 1 [{"added": {}}] 6 1 29 2023-06-24 10:18:42.95427+00 12 799999999993 1 [{"added": {}}] 6 1 30 2023-06-24 10:19:19.684636+00 13 799999999992 1 [{"added": {}}] 6 1 31 2023-06-24 10:19:51.572667+00 14 799999999991 1 [{"added": {}}] 6 1 32 2023-06-24 10:37:21.142492+00 5 79999999999 2 [{"changed": {"fields": ["password"]}}] 6 1 33 2023-06-24 10:37:27.575612+00 4 88888888888 2 [{"changed": {"fields": ["password"]}}] 6 1 34 2023-06-24 10:37:36.775705+00 6 799999999999 2 [{"changed": {"fields": ["password"]}}] 6 1 35 2023-06-24 10:37:41.875039+00 7 799999999998 2 [{"changed": {"fields": ["password"]}}] 6 1 36 2023-06-24 10:37:48.825863+00 8 799999999997 2 [{"changed": {"fields": ["password"]}}] 6 1 37 2023-06-24 10:37:55.59249+00 9 799999999996 2 [{"changed": {"fields": ["password"]}}] 6 1 38 2023-06-24 10:38:01.184168+00 10 799999999995 2 [{"changed": {"fields": ["password"]}}] 6 1 39 2023-06-24 10:38:09.40087+00 11 799999999994 2 [{"changed": {"fields": ["password"]}}] 6 1 40 2023-06-24 10:38:19.417646+00 9 799999999996 2 [{"changed": {"fields": ["password"]}}] 6 1 41 2023-06-24 10:38:24.026682+00 10 799999999995 2 [{"changed": {"fields": ["password"]}}] 6 1 42 2023-06-24 10:38:27.767644+00 12 799999999993 2 [{"changed": {"fields": ["password"]}}] 6 1 43 2023-06-24 10:38:31.384753+00 13 799999999992 2 [{"changed": {"fields": ["password"]}}] 6 1 44 2023-06-24 10:38:35.702301+00 14 799999999991 2 [{"changed": {"fields": ["password"]}}] 6 1 45 2023-06-24 12:18:36.370274+00 6 799999999999 3 6 1 46 2023-06-24 12:19:21.045151+00 1 99999999999 2 [{"changed": {"fields": ["Username", "First name", "Last name", "Groups"]}}] 6 1 47 2023-06-24 12:19:41.005796+00 1 99999999999 2 [] 6 1 48 2023-06-24 12:22:58.778241+00 7 99999999998 2 [{"changed": {"fields": ["\\u041d\\u043e\\u043c\\u0435\\u0440 \\u0442\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d\\u0430", "Username"]}}] 6 1 49 2023-06-24 12:24:07.061953+00 8 99999999997 2 [{"changed": {"fields": ["\\u041d\\u043e\\u043c\\u0435\\u0440 \\u0442\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d\\u0430", "Username"]}}] 6 1 50 2023-06-24 12:24:15.375428+00 9 99999999996 2 [{"changed": {"fields": ["\\u041d\\u043e\\u043c\\u0435\\u0440 \\u0442\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d\\u0430", "Username"]}}] 6 1 51 2023-06-24 12:24:35.068383+00 10 99999999995 2 [{"changed": {"fields": ["\\u041d\\u043e\\u043c\\u0435\\u0440 \\u0442\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d\\u0430", "Username"]}}] 6 1 52 2023-06-24 12:24:44.465063+00 11 99999999994 2 [{"changed": {"fields": ["\\u041d\\u043e\\u043c\\u0435\\u0440 \\u0442\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d\\u0430", "Username"]}}] 6 1 53 2023-06-24 12:24:50.899957+00 12 99999999993 2 [{"changed": {"fields": ["\\u041d\\u043e\\u043c\\u0435\\u0440 \\u0442\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d\\u0430", "Username"]}}] 6 1 54 2023-06-24 12:24:56.962259+00 13 99999999992 2 [{"changed": {"fields": ["\\u041d\\u043e\\u043c\\u0435\\u0440 \\u0442\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d\\u0430", "Username"]}}] 6 1 55 2023-06-24 12:25:02.572637+00 14 99999999991 2 [{"changed": {"fields": ["\\u041d\\u043e\\u043c\\u0435\\u0440 \\u0442\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d\\u0430", "Username"]}}] 6 1 56 2023-06-24 12:48:27.865937+00 14 99999999991 2 [{"changed": {"fields": ["password"]}}] 6 1 57 2023-06-24 12:48:32.239092+00 13 99999999992 2 [{"changed": {"fields": ["password"]}}] 6 1 58 2023-06-24 12:48:36.349979+00 12 99999999993 2 [{"changed": {"fields": ["password"]}}] 6 1 59 2023-06-24 12:48:39.9092+00 11 99999999994 2 [{"changed": {"fields": ["password"]}}] 6 1 60 2023-06-24 12:48:43.923055+00 10 99999999995 2 [{"changed": {"fields": ["password"]}}] 6 1 61 2023-06-24 12:48:47.796947+00 9 99999999996 2 [{"changed": {"fields": ["password"]}}] 6 1 62 2023-06-24 12:48:51.380877+00 8 99999999997 2 [{"changed": {"fields": ["password"]}}] 6 1 63 2023-06-24 12:48:54.732284+00 7 99999999998 2 [{"changed": {"fields": ["password"]}}] 6 1 64 2023-06-24 12:48:58.773162+00 1 99999999999 2 [{"changed": {"fields": ["password"]}}] 6 1 \. -- -- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.django_content_type (id, app_label, model) FROM stdin; 1 admin logentry 2 auth permission 3 auth group 4 contenttypes contenttype 5 sessions session 6 SharixAdmin sharixuser 7 tickets tickettype 8 tickets tasklist 9 tickets task 10 tickets attachment 11 tickets comment 12 metaservicesynced client 13 metaservicesynced company 14 metaservicesynced documents 15 metaservicesynced orders 16 metaservicesynced permissions 17 metaservicesynced provider 18 metaservicesynced relationship 19 metaservicesynced resource 20 metaservicesynced service 21 metaservicesynced servicetype 22 webservice_running achievement 23 webservice_running achievements 24 webservice_running blockedsportsman 25 webservice_running browseevent 26 webservice_running browsesportsman 27 webservice_running event 28 webservice_running participant 29 webservice_running savedevent 30 webservice_running savedsportsman 31 webservice_running sport 32 webservice_running sportpreferrence 33 webservice_running sportsman 34 webservice_running sportsmangallery 35 webservice_running eventgallery 36 openlocal orderslocal 37 sites site 38 flatpages flatpage 39 authtoken token 40 authtoken tokenproxy 41 webservice_running orderslocal \. -- -- Data for Name: django_flatpage; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.django_flatpage (id, url, title, content, enable_comments, template_name, registration_required) FROM stdin; \. -- -- Data for Name: django_flatpage_sites; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.django_flatpage_sites (id, flatpage_id, site_id) FROM stdin; \. -- -- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.django_migrations (id, app, name, applied) FROM stdin; 1 contenttypes 0001_initial 2023-06-17 13:58:39.012875+00 2 contenttypes 0002_remove_content_type_name 2023-06-17 13:58:39.029653+00 3 auth 0001_initial 2023-06-17 13:58:39.697852+00 4 auth 0002_alter_permission_name_max_length 2023-06-17 13:58:39.751393+00 5 auth 0003_alter_user_email_max_length 2023-06-17 13:58:39.795312+00 6 auth 0004_alter_user_username_opts 2023-06-17 13:58:39.864743+00 7 auth 0005_alter_user_last_login_null 2023-06-17 13:58:39.954701+00 8 auth 0006_require_contenttypes_0002 2023-06-17 13:58:40.011972+00 9 auth 0007_alter_validators_add_error_messages 2023-06-17 13:58:40.05181+00 10 auth 0008_alter_user_username_max_length 2023-06-17 13:58:40.075176+00 11 auth 0009_alter_user_last_name_max_length 2023-06-17 13:58:40.084367+00 12 auth 0010_alter_group_name_max_length 2023-06-17 13:58:40.092779+00 13 auth 0011_update_proxy_permissions 2023-06-17 13:58:40.146724+00 14 auth 0012_alter_user_first_name_max_length 2023-06-17 13:58:40.211411+00 15 SharixAdmin 0001_initial 2023-06-17 13:58:40.93159+00 16 admin 0001_initial 2023-06-17 13:58:41.205402+00 17 admin 0002_logentry_remove_auto_add 2023-06-17 13:58:41.271959+00 18 admin 0003_logentry_add_action_flag_choices 2023-06-17 13:58:41.348261+00 19 authtoken 0001_initial 2023-06-17 13:58:41.537062+00 20 authtoken 0002_auto_20160226_1747 2023-06-17 13:58:41.632055+00 21 authtoken 0003_tokenproxy 2023-06-17 13:58:41.686289+00 22 sites 0001_initial 2023-06-17 13:58:41.766993+00 23 flatpages 0001_initial 2023-06-17 13:58:42.24671+00 24 tickets 0001_initial 2023-06-17 13:58:43.957152+00 25 metaservicesynced 0001_initial 2023-06-17 13:58:44.892728+00 26 metaservicesynced 0002_initial 2023-06-17 13:58:46.892465+00 27 sessions 0001_initial 2023-06-17 13:58:47.358235+00 28 sites 0002_alter_domain_unique 2023-06-17 13:58:47.895353+00 29 webservice_running 0001_initial 2023-06-17 13:58:51.75274+00 30 metaservicesynced 0002_alter_company_inn 2023-06-21 15:20:24.538775+00 31 tickets 0002_alter_task_created_date 2023-06-21 15:20:24.669077+00 \. -- -- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.django_session (session_key, session_data, expire_date) FROM stdin; f94w32eqb9ynr5t3gsnkinstxj4oonha .eJxVjDsOwjAQBe_iGlkm699S0ucM1q7XxgGUSPlUiLtDpBTQvpl5L5VoW1valjKnQdRFWVCn35EpP8q4E7nTeJt0nsZ1Hljvij7oovtJyvN6uH8HjZb2rWMuDjuMFNADZwlnZz2CREOeHSATG3KusvVsRKgAVMTQGSi5djGo9wcEDzgb:1qD3HV:ZzLYE2Z-_cJq432sIN-uWjQQ1XWvO_SJnS3UEJn6NX0 2023-07-08 13:26:25.126435+00 17iori62ctnasosrruh57nlf4kj42f1w .eJxVjDsOwjAQBe_iGlkm699S0ucM1q7XxgGUSPlUiLtDpBTQvpl5L5VoW1valjKnQdRFWVCn35EpP8q4E7nTeJt0nsZ1Hljvij7oovtJyvN6uH8HjZb2rWMuDjuMFNADZwlnZz2CREOeHSATG3KusvVsRKgAVMTQGSi5djGo9wcEDzgb:1qD3Hx:hJyZ-eZwroLSwDoJqNNYjNw9MzTRVtiJ-Pb2eq6i3VI 2023-07-08 13:26:53.372889+00 uce2yqygm53c57yxg2suelyw1rvbzyoo .eJxVjDsOwjAQBe_iGlmKE6_XlPScIXr2bkgA2VI-FeLuECkFtG9m3sv02Nax3xad-0nM2TTm9Lsl5IeWHcgd5VZtrmWdp2R3xR50sdcq-rwc7t_BiGX81hxIB8oByXlmbtuGI2n2QgFRQpd9BDDESAxy4jtHLGiSupw6Acz7A9_SOFI:1qD3fP:BPxttoTkbsadPOC9qayqXkeK2-8Mzb5T39oPbeLsOHg 2023-07-08 13:51:07.035981+00 q14ha6slmpwj1ag5hivuyg8w39ip1yyk .eJxVjLsOAiEUBf-F2pDLwhKwtPcbyH1FVg0k-6iM_66bbKHtmZnzMgW3tZZt0blMYs7GmdPvRsgPbTuQO7Zbt9zbOk9kd8UedLHXLvq8HO7fQcWlfmtgjhpSVmXREGh0eYScBEnFRQeYkL2IJxdSEjcQA3qgTJ5SlAHM-wMC9Dh4:1qBbgS:LYA4glGIfAcW19HL1Zx5_VC0FyVnNufvGY_1iejWTpU 2023-07-04 13:46:12.450855+00 j2jaw8z3udky38qr0earw0490dauqe8a .eJxVjLsOAiEUBf-F2pDLwhKwtPcbyH1FVg0k-6iM_66bbKHtmZnzMgW3tZZt0blMYs7GmdPvRsgPbTuQO7Zbt9zbOk9kd8UedLHXLvq8HO7fQcWlfmtgjhpSVmXREGh0eYScBEnFRQeYkL2IJxdSEjcQA3qgTJ5SlAHM-wMC9Dh4:1qD2Bt:6DKtskx_ZS_jGqFHlesiy-v14iwNEFjp4JbkwP3s7H0 2023-07-08 12:16:33.513068+00 dekb9oith0dmoftv86gv98v75c1m1z4k .eJxVjDsOwjAQBe_iGlmKE6_XlPScIXr2bkgA2VI-FeLuECkFtG9m3sv02Nax3xad-0nM2TTm9Lsl5IeWHcgd5VZtrmWdp2R3xR50sdcq-rwc7t_BiGX81hxIB8oByXlmbtuGI2n2QgFRQpd9BDDESAxy4jtHLGiSupw6Acz7A9_SOFI:1qD2hG:R5xcfiz1J9afqS3_l2DNfegYOWsUn3soUM3mBbEa-3U 2023-07-08 12:48:58.807965+00 \. -- -- Data for Name: django_site; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.django_site (id, domain, name) FROM stdin; 1 example.com example.com \. -- -- Data for Name: documents; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.documents (id, check_date, check_level, expire_date, id_metaservice, requirements, status, datalink, doc_type, is_global, is_visible, checked_by_id, company_id_id, ticket_status_id, user_id_id) FROM stdin; \. -- -- Data for Name: event; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.event (id, rating_id, attempts, order_place_type, order_place_start, order_place_start_gps, order_place_start_sector, order_place_start_real, order_place_start_real_gps, order_place_finish_predicted, order_place_finish_predicted_gps, order_place_finish_sector, order_place_finish_real, order_place_finish_real_gps, required_gender, description, time_updated, time_close, max_participants, min_participants, max_age, min_age, is_public, host_id, order_synced_id, resource_id_id, sport_id, min_level, max_level) FROM stdin; 1 123 123 кцукцук цукцук цук 123123 1231231 3123123 12 31 23123 12312 1231 M Крутая гитара 2023-06-17 18:39:25.234345+00 2023-06-17 18:34:12+00 124 12 111 11 t 1 1 1 1 \N \N \. -- -- Data for Name: event_gallery; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.event_gallery (id, image, event_id) FROM stdin; \. -- -- Data for Name: orders; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.orders (id, state, id_metaservice, time_created, time_placed, time_start, time_start_real, time_start_predicted, time_finish_predicted, time_finish_real, predicted_price, real_price, is_global, is_visible, client_id_id, provider_id, receiver_id, service_id, service_type_id, ticket_id) FROM stdin; 1 фафы 1412 2023-06-17 18:39:20.935503+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 2 фафы 1412 2023-06-22 19:27:12.718264+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 3 фафы 1412 2023-06-22 19:52:29.898908+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 4 фафы 1412 2023-06-22 20:09:53.247779+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 5 фафы 1412 2023-06-23 02:08:18.999768+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 6 фафы 1412 2023-06-23 02:09:25.340735+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 7 фафы 1412 2023-06-23 02:14:51.494085+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 8 фафы 1412 2023-06-23 02:15:53.999044+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 9 фафы 1412 2023-06-23 02:26:12.330622+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 10 фафы 1412 2023-06-23 02:32:56.804625+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 11 фафы 1412 2023-06-23 02:56:37.642191+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 12 фафы 1412 2023-06-23 02:58:13.887705+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 13 фафы 1412 2023-06-23 03:03:17.320921+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 14 фафы 1412 2023-06-23 03:03:17.319335+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 15 new 1 2023-06-24 14:18:25.899294+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 0 0 t t 1 2 1 1 1 1 16 new 1 2023-06-24 14:18:27.620358+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 0 0 t t 1 2 1 1 1 1 17 new 1 2023-06-24 14:18:28.1502+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 0 0 t t 1 2 1 1 1 1 18 new 1 2023-06-24 14:18:28.607785+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 0 0 t t 1 2 1 1 1 1 19 фафы 1412 2023-06-24 14:25:14.87789+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 1 20 фафы 1412 2023-06-24 14:27:11.155101+00 2023-06-17 18:38:59+00 2023-06-17 18:39:02+00 2023-06-17 18:39:06+00 2023-06-17 18:39:08+00 2023-06-17 18:39:10+00 2023-06-17 18:39:12+00 21341 124124 f f 1 2 1 1 1 2 21 new 1 2023-06-24 14:27:52.342145+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 0 0 t t 1 2 1 1 1 3 22 new 1 2023-06-24 14:27:55.620152+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 0 0 t t 1 2 1 1 1 4 23 new 1 2023-06-24 14:27:56.229278+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 0 0 t t 1 2 1 1 1 5 24 new 1 2023-06-24 14:31:27.845477+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 2023-06-17 18:38:59+00 0 0 t t 1 2 1 1 1 1 \. -- -- Data for Name: participant; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.participant (id, is_finished, event_participant_id, sportsman_id) FROM stdin; \. -- -- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.permissions (id, check_date, id_permissions, check_level, status, id_metaservice, is_global, is_visible, checked_by_id, ticket_status_id, user_id_id) FROM stdin; \. -- -- Data for Name: provider; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.provider (id, type, id_metaservice, requirements, status, location_type, default_location, is_global, is_visible, company_id_id, ticket_status_id, user_id_id) FROM stdin; 1 фв 4 фыв фыв фывфв фыв f f 1 1 1 2 укецу 234 234 234 234 234 f f 1 1 1 \. -- -- Data for Name: relationship; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.relationship (id, neg_type, id_metaservice, requirements, status, is_global, is_visible, ticket_status_id, user_id_who_id, user_id_whom_id) FROM stdin; \. -- -- Data for Name: resource; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.resource (id, type_id, requirements, status, id_metaservice, is_global, is_visible, ticket_status_id, user_id_id) FROM stdin; 1 1234 1 23 23423 f f 1 1 \. -- -- Data for Name: saved_event; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.saved_event (id, event_savedevent_id, sportsman_id) FROM stdin; \. -- -- Data for Name: saved_sportsman; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.saved_sportsman (id, sportsman_id, sportsman_saved_id) FROM stdin; \. -- -- Data for Name: service; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.service (id, requirements, id_metaservice, price_alg, price_km, price_min, price_amount, service_status, status, is_global, is_visible, id_provider_id, resource_id_id, servicetype_id_id, ticket_status_id) FROM stdin; 1 фыв 4 фыв 124.00 124.00 124.00 12 1234 f f 1 1 1 1 \. -- -- Data for Name: servicetype; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.servicetype (id, codename, caption, description, requirements, price_type, status, id_metaservice, link_agreement, is_global, is_visible, ticket_status_id) FROM stdin; 1 Встреча Встреча Встреча 1 1 1 4 asd f f 1 \. -- -- Data for Name: sport; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.sport (id, title, image) FROM stdin; 1 Футбол sports/sport/RJEYeJCd5fE.jpg \. -- -- Data for Name: sport_preferrence; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.sport_preferrence (id, sport_id, sportsman_id) FROM stdin; \. -- -- Data for Name: sportsman; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.sportsman (id, bio, level, birthdate, active_status, time_updated, preferred_time, reliance_rating, gender, client_id) FROM stdin; 1 укеуке 1 2023-06-17 Active 2023-06-17 18:33:39+00 142124 124 F 1 2 gdfg 3.4 2023-06-17 Active 2023-06-17 18:33:39+00 142124 124 F 2 \. -- -- Data for Name: sportsman_gallery; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.sportsman_gallery (id, image, sportsman_id) FROM stdin; \. -- -- Data for Name: tickets_attachment; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.tickets_attachment (id, "timestamp", file, added_by_id, task_id) FROM stdin; \. -- -- Data for Name: tickets_comment; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.tickets_comment (id, date, email_from, email_message_id, body, author_id, task_id) FROM stdin; \. -- -- Data for Name: tickets_task; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.tickets_task (id, status, created_date, status_changed_date, priority, title, note, due_date, assigned_to_id, created_by_id, task_list_id, type_id) FROM stdin; 1 4 2023-06-17 2023-06-17 18:28:40.45161+00 0 sdfsdf sdfsdf 2023-06-17 1 1 23 1 2 \N 2023-06-24 2023-06-24 14:27:11.033196+00 0 New ticket title \N \N \N \N 9 \N 3 \N 2023-06-24 2023-06-24 14:27:52.325854+00 0 New ticket title \N \N \N \N 9 \N 4 \N 2023-06-24 2023-06-24 14:27:55.578442+00 0 New ticket title \N \N \N \N 9 \N 5 \N 2023-06-24 2023-06-24 14:27:56.210404+00 0 New ticket title \N \N \N \N 9 \N \. -- -- Data for Name: tickets_tasklist; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.tickets_tasklist (id, name, slug, group_id) FROM stdin; 1 MS-ADMIN Активация партнеров NEG_REQUEST partner_activation 1 2 MS-ADMIN права в сервисе ACCESS_REQUEST metaservice_roles 1 3 MS-ADMIN проверка документов ST_REQUEST metaservice_partner_docs 1 4 MS-SUPER активность пользователей ST_REQUEST activity_control 2 5 MS-SUPER оперативный доступ ST_REQUEST operational_control 2 6 MS-SUPER опер доступ экстра ACCESS_REQUEST operational_control_extra 2 7 MS-SUPER права сервиса ST_REQUEST access_control 2 8 MS-SUPER проверка документов ST_REQUEST metaservice_partner_docs 2 9 MS-SUP входящие обычные заявки ST_REQUEST service-inbox 3 10 MS-SUP Заявки на УСЛУГИ сервиса SERVICE_REQUEST service_request 3 11 MS-TSUP входящие тех заявки ST_REQUEST service-inbox-tech 4 12 P-ADMIN документы исполнителей ST_REQUEST provider_docs 5 13 P-ADMIN документы ресурсов ST_REQUEST resource_docs 5 14 P-ADMIN права в партнерке ACCESS_REQUEST partner_roles 5 15 P-SUPER активность внутри партнера ST_REQUEST activity_control 6 16 P-SUPER документы исполнителей ST_REQUEST provider_docs 6 17 P-SUPER документы ресурсов ST_REQUEST resource_docs 6 18 P-SUPER доступ внутри партнера ST_REQUEST access_control 6 19 P-SUPER оперативный доступ ST_REQUEST operational_control 6 20 P-SUPER оперативный доступ экстра ST_REQUEST operational_control_extra 6 21 P-SUPER ручной аппрув заявок ACCESS-REQUEST service_request_edit 6 22 P-TSUP входящие тех заявки ST_REQUEST partner-inbox-tech 7 23 Влад ASS 10 \. -- -- Data for Name: tickets_tickettype; Type: TABLE DATA; Schema: public; Owner: sports -- COPY public.tickets_tickettype (id, name, life_cycle) FROM stdin; 1 ST_REQUEST 111-121-149-159,110-121-149-159,121-131-149-159,131-141-149,141-151-110,149-151-110,159,151 2 SERVICE_REQUEST 210-211-251,211-212-220-238-249,212-221-229-238-249,221-222-238-249,220-211-238-249,229-211-251,222-231-238-249,231-241-238-249,238-231-239-211-212-221-220-222-249,239-231-239-211-212-221-220-222-249,241-251,249-251,251 3 ACCESS_REQUEST 320-321-359,321,359 4 NEG_REQUEST 420-421-459,421,459 \. -- -- Name: achievement_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.achievement_id_seq', 1, false); -- -- Name: achievements_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.achievements_id_seq', 1, false); -- -- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.auth_group_id_seq', 11, true); -- -- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.auth_group_permissions_id_seq', 1, false); -- -- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.auth_permission_id_seq', 164, true); -- -- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.auth_user_groups_id_seq', 11, true); -- -- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.auth_user_id_seq', 43, true); -- -- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.auth_user_user_permissions_id_seq', 1, false); -- -- Name: blocked_sportsman_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.blocked_sportsman_id_seq', 1, false); -- -- Name: browse_event_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.browse_event_id_seq', 1, false); -- -- Name: browse_sportsman_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.browse_sportsman_id_seq', 1, false); -- -- Name: client_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.client_id_seq', 2, true); -- -- Name: company_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.company_id_seq', 1, true); -- -- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.django_admin_log_id_seq', 64, true); -- -- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.django_content_type_id_seq', 41, true); -- -- Name: django_flatpage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.django_flatpage_id_seq', 1, false); -- -- Name: django_flatpage_sites_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.django_flatpage_sites_id_seq', 1, false); -- -- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.django_migrations_id_seq', 31, true); -- -- Name: django_site_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.django_site_id_seq', 1, true); -- -- Name: documents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.documents_id_seq', 1, false); -- -- Name: event_gallery_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.event_gallery_id_seq', 1, false); -- -- Name: event_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.event_id_seq', 1, true); -- -- Name: orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.orders_id_seq', 24, true); -- -- Name: participant_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.participant_id_seq', 1, false); -- -- Name: permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.permissions_id_seq', 1, false); -- -- Name: provider_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.provider_id_seq', 2, true); -- -- Name: relationship_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.relationship_id_seq', 1, false); -- -- Name: resource_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.resource_id_seq', 1, true); -- -- Name: saved_event_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.saved_event_id_seq', 1, false); -- -- Name: saved_sportsman_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.saved_sportsman_id_seq', 1, false); -- -- Name: service_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.service_id_seq', 1, true); -- -- Name: servicetype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.servicetype_id_seq', 1, true); -- -- Name: sport_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.sport_id_seq', 1, true); -- -- Name: sport_preferrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.sport_preferrence_id_seq', 1, false); -- -- Name: sportsman_gallery_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.sportsman_gallery_id_seq', 1, false); -- -- Name: sportsman_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.sportsman_id_seq', 2, true); -- -- Name: tickets_attachment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.tickets_attachment_id_seq', 1, false); -- -- Name: tickets_comment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.tickets_comment_id_seq', 1, false); -- -- Name: tickets_task_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.tickets_task_id_seq', 5, true); -- -- Name: tickets_tasklist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.tickets_tasklist_id_seq', 23, true); -- -- Name: tickets_tickettype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sports -- SELECT pg_catalog.setval('public.tickets_tickettype_id_seq', 4, true); -- -- Name: achievement achievement_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.achievement ADD CONSTRAINT achievement_pkey PRIMARY KEY (id); -- -- Name: achievements achievements_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.achievements ADD CONSTRAINT achievements_pkey PRIMARY KEY (id); -- -- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_group ADD CONSTRAINT auth_group_name_key UNIQUE (name); -- -- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_group_permissions ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id); -- -- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_group_permissions ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id); -- -- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_group ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id); -- -- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_permission ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename); -- -- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_permission ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id); -- -- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user_groups ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id); -- -- Name: auth_user_groups auth_user_groups_sharixuser_id_group_id_1c389e1b_uniq; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user_groups ADD CONSTRAINT auth_user_groups_sharixuser_id_group_id_1c389e1b_uniq UNIQUE (sharixuser_id, group_id); -- -- Name: auth_user auth_user_phone_number_key; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user ADD CONSTRAINT auth_user_phone_number_key UNIQUE (phone_number); -- -- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id); -- -- Name: auth_user_user_permissions auth_user_user_permissio_sharixuser_id_permission_d945e8cc_uniq; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user_user_permissions ADD CONSTRAINT auth_user_user_permissio_sharixuser_id_permission_d945e8cc_uniq UNIQUE (sharixuser_id, permission_id); -- -- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user_user_permissions ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id); -- -- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user ADD CONSTRAINT auth_user_username_key UNIQUE (username); -- -- Name: authtoken_token authtoken_token_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.authtoken_token ADD CONSTRAINT authtoken_token_pkey PRIMARY KEY (key); -- -- Name: authtoken_token authtoken_token_user_id_key; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.authtoken_token ADD CONSTRAINT authtoken_token_user_id_key UNIQUE (user_id); -- -- Name: blocked_sportsman blocked_sportsman_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.blocked_sportsman ADD CONSTRAINT blocked_sportsman_pkey PRIMARY KEY (id); -- -- Name: browse_event browse_event_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.browse_event ADD CONSTRAINT browse_event_pkey PRIMARY KEY (id); -- -- Name: browse_sportsman browse_sportsman_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.browse_sportsman ADD CONSTRAINT browse_sportsman_pkey PRIMARY KEY (id); -- -- Name: client client_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.client ADD CONSTRAINT client_pkey PRIMARY KEY (id); -- -- Name: company company_inn_key; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.company ADD CONSTRAINT company_inn_key UNIQUE (inn); -- -- Name: company company_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.company ADD CONSTRAINT company_pkey PRIMARY KEY (id); -- -- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_admin_log ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id); -- -- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_content_type ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model); -- -- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_content_type ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id); -- -- Name: django_flatpage django_flatpage_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_flatpage ADD CONSTRAINT django_flatpage_pkey PRIMARY KEY (id); -- -- Name: django_flatpage_sites django_flatpage_sites_flatpage_id_site_id_0d29d9d1_uniq; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_flatpage_sites ADD CONSTRAINT django_flatpage_sites_flatpage_id_site_id_0d29d9d1_uniq UNIQUE (flatpage_id, site_id); -- -- Name: django_flatpage_sites django_flatpage_sites_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_flatpage_sites ADD CONSTRAINT django_flatpage_sites_pkey PRIMARY KEY (id); -- -- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_migrations ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id); -- -- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_session ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key); -- -- Name: django_site django_site_domain_a2e37b91_uniq; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_site ADD CONSTRAINT django_site_domain_a2e37b91_uniq UNIQUE (domain); -- -- Name: django_site django_site_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_site ADD CONSTRAINT django_site_pkey PRIMARY KEY (id); -- -- Name: documents documents_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.documents ADD CONSTRAINT documents_pkey PRIMARY KEY (id); -- -- Name: event_gallery event_gallery_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.event_gallery ADD CONSTRAINT event_gallery_pkey PRIMARY KEY (id); -- -- Name: event event_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.event ADD CONSTRAINT event_pkey PRIMARY KEY (id); -- -- Name: orders orders_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.orders ADD CONSTRAINT orders_pkey PRIMARY KEY (id); -- -- Name: participant participant_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.participant ADD CONSTRAINT participant_pkey PRIMARY KEY (id); -- -- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.permissions ADD CONSTRAINT permissions_pkey PRIMARY KEY (id); -- -- Name: provider provider_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.provider ADD CONSTRAINT provider_pkey PRIMARY KEY (id); -- -- Name: relationship relationship_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.relationship ADD CONSTRAINT relationship_pkey PRIMARY KEY (id); -- -- Name: resource resource_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.resource ADD CONSTRAINT resource_pkey PRIMARY KEY (id); -- -- Name: saved_event saved_event_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.saved_event ADD CONSTRAINT saved_event_pkey PRIMARY KEY (id); -- -- Name: saved_sportsman saved_sportsman_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.saved_sportsman ADD CONSTRAINT saved_sportsman_pkey PRIMARY KEY (id); -- -- Name: service service_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.service ADD CONSTRAINT service_pkey PRIMARY KEY (id); -- -- Name: servicetype servicetype_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.servicetype ADD CONSTRAINT servicetype_pkey PRIMARY KEY (id); -- -- Name: sport sport_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.sport ADD CONSTRAINT sport_pkey PRIMARY KEY (id); -- -- Name: sport_preferrence sport_preferrence_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.sport_preferrence ADD CONSTRAINT sport_preferrence_pkey PRIMARY KEY (id); -- -- Name: sportsman_gallery sportsman_gallery_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.sportsman_gallery ADD CONSTRAINT sportsman_gallery_pkey PRIMARY KEY (id); -- -- Name: sportsman sportsman_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.sportsman ADD CONSTRAINT sportsman_pkey PRIMARY KEY (id); -- -- Name: tickets_attachment tickets_attachment_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_attachment ADD CONSTRAINT tickets_attachment_pkey PRIMARY KEY (id); -- -- Name: tickets_comment tickets_comment_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_comment ADD CONSTRAINT tickets_comment_pkey PRIMARY KEY (id); -- -- Name: tickets_comment tickets_comment_task_id_email_message_id_c2280cd2_uniq; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_comment ADD CONSTRAINT tickets_comment_task_id_email_message_id_c2280cd2_uniq UNIQUE (task_id, email_message_id); -- -- Name: tickets_task tickets_task_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_task ADD CONSTRAINT tickets_task_pkey PRIMARY KEY (id); -- -- Name: tickets_tasklist tickets_tasklist_group_id_slug_7aeeac6b_uniq; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_tasklist ADD CONSTRAINT tickets_tasklist_group_id_slug_7aeeac6b_uniq UNIQUE (group_id, slug); -- -- Name: tickets_tasklist tickets_tasklist_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_tasklist ADD CONSTRAINT tickets_tasklist_pkey PRIMARY KEY (id); -- -- Name: tickets_tickettype tickets_tickettype_life_cycle_key; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_tickettype ADD CONSTRAINT tickets_tickettype_life_cycle_key UNIQUE (life_cycle); -- -- Name: tickets_tickettype tickets_tickettype_name_key; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_tickettype ADD CONSTRAINT tickets_tickettype_name_key UNIQUE (name); -- -- Name: tickets_tickettype tickets_tickettype_pkey; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_tickettype ADD CONSTRAINT tickets_tickettype_pkey PRIMARY KEY (id); -- -- Name: achievement unique_achievement; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.achievement ADD CONSTRAINT unique_achievement UNIQUE (sportsman_id, achievement_id); -- -- Name: blocked_sportsman unique_blocked_sportsman; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.blocked_sportsman ADD CONSTRAINT unique_blocked_sportsman UNIQUE (sportsman_id, sportsman_blocked_id); -- -- Name: browse_event unique_browse_event; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.browse_event ADD CONSTRAINT unique_browse_event UNIQUE (sportsman_id, event_browseevent_id); -- -- Name: browse_sportsman unique_browse_sportsman; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.browse_sportsman ADD CONSTRAINT unique_browse_sportsman UNIQUE (sportsman_id, sportsman_browsed_id); -- -- Name: participant unique_participant; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.participant ADD CONSTRAINT unique_participant UNIQUE (sportsman_id, event_participant_id); -- -- Name: saved_event unique_saved_event; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.saved_event ADD CONSTRAINT unique_saved_event UNIQUE (sportsman_id, event_savedevent_id); -- -- Name: saved_sportsman unique_saved_sportsman; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.saved_sportsman ADD CONSTRAINT unique_saved_sportsman UNIQUE (sportsman_id, sportsman_saved_id); -- -- Name: sport_preferrence unique_sportpreferrence; Type: CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.sport_preferrence ADD CONSTRAINT unique_sportpreferrence UNIQUE (sportsman_id, sport_id); -- -- Name: achievement_achievement_id_f44d8554; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX achievement_achievement_id_f44d8554 ON public.achievement USING btree (achievement_id); -- -- Name: achievement_sportsman_id_550fd02d; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX achievement_sportsman_id_550fd02d ON public.achievement USING btree (sportsman_id); -- -- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops); -- -- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id); -- -- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id); -- -- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id); -- -- Name: auth_user_groups_group_id_97559544; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX auth_user_groups_group_id_97559544 ON public.auth_user_groups USING btree (group_id); -- -- Name: auth_user_groups_sharixuser_id_772bb15e; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX auth_user_groups_sharixuser_id_772bb15e ON public.auth_user_groups USING btree (sharixuser_id); -- -- Name: auth_user_phone_number_21846c29_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX auth_user_phone_number_21846c29_like ON public.auth_user USING btree (phone_number varchar_pattern_ops); -- -- Name: auth_user_user_permissions_permission_id_1fbb5f2c; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON public.auth_user_user_permissions USING btree (permission_id); -- -- Name: auth_user_user_permissions_sharixuser_id_31146c79; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX auth_user_user_permissions_sharixuser_id_31146c79 ON public.auth_user_user_permissions USING btree (sharixuser_id); -- -- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX auth_user_username_6821ab7c_like ON public.auth_user USING btree (username varchar_pattern_ops); -- -- Name: authtoken_token_key_10f0b77e_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX authtoken_token_key_10f0b77e_like ON public.authtoken_token USING btree (key varchar_pattern_ops); -- -- Name: blocked_sportsman_sportsman_blocked_id_09a28c8f; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX blocked_sportsman_sportsman_blocked_id_09a28c8f ON public.blocked_sportsman USING btree (sportsman_blocked_id); -- -- Name: blocked_sportsman_sportsman_id_41cf40b7; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX blocked_sportsman_sportsman_id_41cf40b7 ON public.blocked_sportsman USING btree (sportsman_id); -- -- Name: browse_event_event_browseevent_id_19a81220; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX browse_event_event_browseevent_id_19a81220 ON public.browse_event USING btree (event_browseevent_id); -- -- Name: browse_event_sportsman_id_ba071710; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX browse_event_sportsman_id_ba071710 ON public.browse_event USING btree (sportsman_id); -- -- Name: browse_sportsman_sportsman_browsed_id_393ca39b; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX browse_sportsman_sportsman_browsed_id_393ca39b ON public.browse_sportsman USING btree (sportsman_browsed_id); -- -- Name: browse_sportsman_sportsman_id_007390f0; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX browse_sportsman_sportsman_id_007390f0 ON public.browse_sportsman USING btree (sportsman_id); -- -- Name: client_ticket_status_id_85e20251; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX client_ticket_status_id_85e20251 ON public.client USING btree (ticket_status_id); -- -- Name: client_user_id_af1c5063; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX client_user_id_af1c5063 ON public.client USING btree (user_id); -- -- Name: company_inn_b373e4fd_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX company_inn_b373e4fd_like ON public.company USING btree (inn varchar_pattern_ops); -- -- Name: company_repr_id_id_830e507c; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX company_repr_id_id_830e507c ON public.company USING btree (repr_id_id); -- -- Name: company_ticket_status_id_3300d57e; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX company_ticket_status_id_3300d57e ON public.company USING btree (ticket_status_id); -- -- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id); -- -- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id); -- -- Name: django_flatpage_sites_flatpage_id_078bbc8b; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX django_flatpage_sites_flatpage_id_078bbc8b ON public.django_flatpage_sites USING btree (flatpage_id); -- -- Name: django_flatpage_sites_site_id_bfd8ea84; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX django_flatpage_sites_site_id_bfd8ea84 ON public.django_flatpage_sites USING btree (site_id); -- -- Name: django_flatpage_url_41612362; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX django_flatpage_url_41612362 ON public.django_flatpage USING btree (url); -- -- Name: django_flatpage_url_41612362_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX django_flatpage_url_41612362_like ON public.django_flatpage USING btree (url varchar_pattern_ops); -- -- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date); -- -- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops); -- -- Name: django_site_domain_a2e37b91_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX django_site_domain_a2e37b91_like ON public.django_site USING btree (domain varchar_pattern_ops); -- -- Name: documents_checked_by_id_d2cb7bbf; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX documents_checked_by_id_d2cb7bbf ON public.documents USING btree (checked_by_id); -- -- Name: documents_company_id_id_ae4b0bd6; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX documents_company_id_id_ae4b0bd6 ON public.documents USING btree (company_id_id); -- -- Name: documents_ticket_status_id_579c3a79; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX documents_ticket_status_id_579c3a79 ON public.documents USING btree (ticket_status_id); -- -- Name: documents_user_id_id_3df1ae44; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX documents_user_id_id_3df1ae44 ON public.documents USING btree (user_id_id); -- -- Name: event_gallery_event_id_fefda20c; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX event_gallery_event_id_fefda20c ON public.event_gallery USING btree (event_id); -- -- Name: event_host_id_47126ec0; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX event_host_id_47126ec0 ON public.event USING btree (host_id); -- -- Name: event_order_synced_id_d72e85c1; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX event_order_synced_id_d72e85c1 ON public.event USING btree (order_synced_id); -- -- Name: event_resource_id_id_e99cc9bf; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX event_resource_id_id_e99cc9bf ON public.event USING btree (resource_id_id); -- -- Name: event_sport_id_4b9df778; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX event_sport_id_4b9df778 ON public.event USING btree (sport_id); -- -- Name: orders_client_id_id_bb96bfa3; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX orders_client_id_id_bb96bfa3 ON public.orders USING btree (client_id_id); -- -- Name: orders_provider_id_374ce07c; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX orders_provider_id_374ce07c ON public.orders USING btree (provider_id); -- -- Name: orders_receiver_id_c9f26e76; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX orders_receiver_id_c9f26e76 ON public.orders USING btree (receiver_id); -- -- Name: orders_service_id_a14ad139; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX orders_service_id_a14ad139 ON public.orders USING btree (service_id); -- -- Name: orders_service_type_id_6389f57c; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX orders_service_type_id_6389f57c ON public.orders USING btree (service_type_id); -- -- Name: orders_ticket_id_5e864231; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX orders_ticket_id_5e864231 ON public.orders USING btree (ticket_id); -- -- Name: participant_event_participant_id_8627532c; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX participant_event_participant_id_8627532c ON public.participant USING btree (event_participant_id); -- -- Name: participant_sportsman_id_5f0e72cd; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX participant_sportsman_id_5f0e72cd ON public.participant USING btree (sportsman_id); -- -- Name: permissions_checked_by_id_c4ae2d37; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX permissions_checked_by_id_c4ae2d37 ON public.permissions USING btree (checked_by_id); -- -- Name: permissions_ticket_status_id_ffaa2331; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX permissions_ticket_status_id_ffaa2331 ON public.permissions USING btree (ticket_status_id); -- -- Name: permissions_user_id_id_5e803886; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX permissions_user_id_id_5e803886 ON public.permissions USING btree (user_id_id); -- -- Name: provider_company_id_id_cbface41; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX provider_company_id_id_cbface41 ON public.provider USING btree (company_id_id); -- -- Name: provider_ticket_status_id_1393a2d9; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX provider_ticket_status_id_1393a2d9 ON public.provider USING btree (ticket_status_id); -- -- Name: provider_user_id_id_f80c97d0; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX provider_user_id_id_f80c97d0 ON public.provider USING btree (user_id_id); -- -- Name: relationship_ticket_status_id_95154047; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX relationship_ticket_status_id_95154047 ON public.relationship USING btree (ticket_status_id); -- -- Name: relationship_user_id_who_id_56f216cd; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX relationship_user_id_who_id_56f216cd ON public.relationship USING btree (user_id_who_id); -- -- Name: relationship_user_id_whom_id_ed5d0b59; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX relationship_user_id_whom_id_ed5d0b59 ON public.relationship USING btree (user_id_whom_id); -- -- Name: resource_ticket_status_id_fd78cde6; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX resource_ticket_status_id_fd78cde6 ON public.resource USING btree (ticket_status_id); -- -- Name: resource_user_id_id_f8636fa7; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX resource_user_id_id_f8636fa7 ON public.resource USING btree (user_id_id); -- -- Name: saved_event_event_savedevent_id_9208645c; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX saved_event_event_savedevent_id_9208645c ON public.saved_event USING btree (event_savedevent_id); -- -- Name: saved_event_sportsman_id_02a40b11; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX saved_event_sportsman_id_02a40b11 ON public.saved_event USING btree (sportsman_id); -- -- Name: saved_sportsman_sportsman_id_3a5033e3; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX saved_sportsman_sportsman_id_3a5033e3 ON public.saved_sportsman USING btree (sportsman_id); -- -- Name: saved_sportsman_sportsman_saved_id_4ab950e0; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX saved_sportsman_sportsman_saved_id_4ab950e0 ON public.saved_sportsman USING btree (sportsman_saved_id); -- -- Name: service_id_provider_id_1b630b89; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX service_id_provider_id_1b630b89 ON public.service USING btree (id_provider_id); -- -- Name: service_resource_id_id_0f1f1ca2; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX service_resource_id_id_0f1f1ca2 ON public.service USING btree (resource_id_id); -- -- Name: service_servicetype_id_id_3a28b055; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX service_servicetype_id_id_3a28b055 ON public.service USING btree (servicetype_id_id); -- -- Name: service_ticket_status_id_5b6b572d; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX service_ticket_status_id_5b6b572d ON public.service USING btree (ticket_status_id); -- -- Name: servicetype_ticket_status_id_77b8bfcd; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX servicetype_ticket_status_id_77b8bfcd ON public.servicetype USING btree (ticket_status_id); -- -- Name: sport_preferrence_sport_id_331b3060; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX sport_preferrence_sport_id_331b3060 ON public.sport_preferrence USING btree (sport_id); -- -- Name: sport_preferrence_sportsman_id_c85f5d64; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX sport_preferrence_sportsman_id_c85f5d64 ON public.sport_preferrence USING btree (sportsman_id); -- -- Name: sportsman_client_id_d332b8c0; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX sportsman_client_id_d332b8c0 ON public.sportsman USING btree (client_id); -- -- Name: sportsman_gallery_sportsman_id_620db12f; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX sportsman_gallery_sportsman_id_620db12f ON public.sportsman_gallery USING btree (sportsman_id); -- -- Name: tickets_attachment_added_by_id_3c8ddb6f; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_attachment_added_by_id_3c8ddb6f ON public.tickets_attachment USING btree (added_by_id); -- -- Name: tickets_attachment_task_id_075d0abc; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_attachment_task_id_075d0abc ON public.tickets_attachment USING btree (task_id); -- -- Name: tickets_comment_author_id_92e77b6b; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_comment_author_id_92e77b6b ON public.tickets_comment USING btree (author_id); -- -- Name: tickets_comment_task_id_13ac4c64; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_comment_task_id_13ac4c64 ON public.tickets_comment USING btree (task_id); -- -- Name: tickets_task_assigned_to_id_5a33e646; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_task_assigned_to_id_5a33e646 ON public.tickets_task USING btree (assigned_to_id); -- -- Name: tickets_task_created_by_id_b9c0cd01; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_task_created_by_id_b9c0cd01 ON public.tickets_task USING btree (created_by_id); -- -- Name: tickets_task_task_list_id_c1b9fc64; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_task_task_list_id_c1b9fc64 ON public.tickets_task USING btree (task_list_id); -- -- Name: tickets_task_type_id_162ca4d2; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_task_type_id_162ca4d2 ON public.tickets_task USING btree (type_id); -- -- Name: tickets_tasklist_group_id_1c12657b; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_tasklist_group_id_1c12657b ON public.tickets_tasklist USING btree (group_id); -- -- Name: tickets_tasklist_slug_e1f9ff9a; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_tasklist_slug_e1f9ff9a ON public.tickets_tasklist USING btree (slug); -- -- Name: tickets_tasklist_slug_e1f9ff9a_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_tasklist_slug_e1f9ff9a_like ON public.tickets_tasklist USING btree (slug varchar_pattern_ops); -- -- Name: tickets_tickettype_life_cycle_d3f50cd2_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_tickettype_life_cycle_d3f50cd2_like ON public.tickets_tickettype USING btree (life_cycle varchar_pattern_ops); -- -- Name: tickets_tickettype_name_558f2f80_like; Type: INDEX; Schema: public; Owner: sports -- CREATE INDEX tickets_tickettype_name_558f2f80_like ON public.tickets_tickettype USING btree (name varchar_pattern_ops); -- -- Name: achievement achievement_achievement_id_f44d8554_fk_achievements_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.achievement ADD CONSTRAINT achievement_achievement_id_f44d8554_fk_achievements_id FOREIGN KEY (achievement_id) REFERENCES public.achievements(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: achievement achievement_sportsman_id_550fd02d_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.achievement ADD CONSTRAINT achievement_sportsman_id_550fd02d_fk_sportsman_id FOREIGN KEY (sportsman_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_group_permissions ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_group_permissions ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_permission ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user_groups ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: auth_user_groups auth_user_groups_sharixuser_id_772bb15e_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user_groups ADD CONSTRAINT auth_user_groups_sharixuser_id_772bb15e_fk_auth_user_id FOREIGN KEY (sharixuser_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user_user_permissions ADD CONSTRAINT auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: auth_user_user_permissions auth_user_user_permi_sharixuser_id_31146c79_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.auth_user_user_permissions ADD CONSTRAINT auth_user_user_permi_sharixuser_id_31146c79_fk_auth_user FOREIGN KEY (sharixuser_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: authtoken_token authtoken_token_user_id_35299eff_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.authtoken_token ADD CONSTRAINT authtoken_token_user_id_35299eff_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: blocked_sportsman blocked_sportsman_sportsman_blocked_id_09a28c8f_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.blocked_sportsman ADD CONSTRAINT blocked_sportsman_sportsman_blocked_id_09a28c8f_fk_sportsman_id FOREIGN KEY (sportsman_blocked_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: blocked_sportsman blocked_sportsman_sportsman_id_41cf40b7_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.blocked_sportsman ADD CONSTRAINT blocked_sportsman_sportsman_id_41cf40b7_fk_sportsman_id FOREIGN KEY (sportsman_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: browse_event browse_event_event_browseevent_id_19a81220_fk_event_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.browse_event ADD CONSTRAINT browse_event_event_browseevent_id_19a81220_fk_event_id FOREIGN KEY (event_browseevent_id) REFERENCES public.event(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: browse_event browse_event_sportsman_id_ba071710_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.browse_event ADD CONSTRAINT browse_event_sportsman_id_ba071710_fk_sportsman_id FOREIGN KEY (sportsman_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: browse_sportsman browse_sportsman_sportsman_browsed_id_393ca39b_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.browse_sportsman ADD CONSTRAINT browse_sportsman_sportsman_browsed_id_393ca39b_fk_sportsman_id FOREIGN KEY (sportsman_browsed_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: browse_sportsman browse_sportsman_sportsman_id_007390f0_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.browse_sportsman ADD CONSTRAINT browse_sportsman_sportsman_id_007390f0_fk_sportsman_id FOREIGN KEY (sportsman_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: client client_ticket_status_id_85e20251_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.client ADD CONSTRAINT client_ticket_status_id_85e20251_fk_tickets_task_id FOREIGN KEY (ticket_status_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: client client_user_id_af1c5063_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.client ADD CONSTRAINT client_user_id_af1c5063_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: company company_repr_id_id_830e507c_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.company ADD CONSTRAINT company_repr_id_id_830e507c_fk_auth_user_id FOREIGN KEY (repr_id_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: company company_ticket_status_id_3300d57e_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.company ADD CONSTRAINT company_ticket_status_id_3300d57e_fk_tickets_task_id FOREIGN KEY (ticket_status_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_admin_log ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: django_admin_log django_admin_log_user_id_c564eba6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_admin_log ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: django_flatpage_sites django_flatpage_site_flatpage_id_078bbc8b_fk_django_fl; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_flatpage_sites ADD CONSTRAINT django_flatpage_site_flatpage_id_078bbc8b_fk_django_fl FOREIGN KEY (flatpage_id) REFERENCES public.django_flatpage(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: django_flatpage_sites django_flatpage_sites_site_id_bfd8ea84_fk_django_site_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.django_flatpage_sites ADD CONSTRAINT django_flatpage_sites_site_id_bfd8ea84_fk_django_site_id FOREIGN KEY (site_id) REFERENCES public.django_site(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: documents documents_checked_by_id_d2cb7bbf_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.documents ADD CONSTRAINT documents_checked_by_id_d2cb7bbf_fk_auth_user_id FOREIGN KEY (checked_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: documents documents_company_id_id_ae4b0bd6_fk_company_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.documents ADD CONSTRAINT documents_company_id_id_ae4b0bd6_fk_company_id FOREIGN KEY (company_id_id) REFERENCES public.company(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: documents documents_ticket_status_id_579c3a79_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.documents ADD CONSTRAINT documents_ticket_status_id_579c3a79_fk_tickets_task_id FOREIGN KEY (ticket_status_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: documents documents_user_id_id_3df1ae44_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.documents ADD CONSTRAINT documents_user_id_id_3df1ae44_fk_auth_user_id FOREIGN KEY (user_id_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: event_gallery event_gallery_event_id_fefda20c_fk_event_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.event_gallery ADD CONSTRAINT event_gallery_event_id_fefda20c_fk_event_id FOREIGN KEY (event_id) REFERENCES public.event(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: event event_host_id_47126ec0_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.event ADD CONSTRAINT event_host_id_47126ec0_fk_sportsman_id FOREIGN KEY (host_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: event event_order_synced_id_d72e85c1_fk_orders_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.event ADD CONSTRAINT event_order_synced_id_d72e85c1_fk_orders_id FOREIGN KEY (order_synced_id) REFERENCES public.orders(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: event event_resource_id_id_e99cc9bf_fk_resource_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.event ADD CONSTRAINT event_resource_id_id_e99cc9bf_fk_resource_id FOREIGN KEY (resource_id_id) REFERENCES public.resource(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: event event_sport_id_4b9df778_fk_sport_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.event ADD CONSTRAINT event_sport_id_4b9df778_fk_sport_id FOREIGN KEY (sport_id) REFERENCES public.sport(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: orders orders_client_id_id_bb96bfa3_fk_client_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.orders ADD CONSTRAINT orders_client_id_id_bb96bfa3_fk_client_id FOREIGN KEY (client_id_id) REFERENCES public.client(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: orders orders_provider_id_374ce07c_fk_provider_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.orders ADD CONSTRAINT orders_provider_id_374ce07c_fk_provider_id FOREIGN KEY (provider_id) REFERENCES public.provider(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: orders orders_receiver_id_c9f26e76_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.orders ADD CONSTRAINT orders_receiver_id_c9f26e76_fk_auth_user_id FOREIGN KEY (receiver_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: orders orders_service_id_a14ad139_fk_service_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.orders ADD CONSTRAINT orders_service_id_a14ad139_fk_service_id FOREIGN KEY (service_id) REFERENCES public.service(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: orders orders_service_type_id_6389f57c_fk_servicetype_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.orders ADD CONSTRAINT orders_service_type_id_6389f57c_fk_servicetype_id FOREIGN KEY (service_type_id) REFERENCES public.servicetype(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: orders orders_ticket_id_5e864231_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.orders ADD CONSTRAINT orders_ticket_id_5e864231_fk_tickets_task_id FOREIGN KEY (ticket_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: participant participant_event_participant_id_8627532c_fk_event_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.participant ADD CONSTRAINT participant_event_participant_id_8627532c_fk_event_id FOREIGN KEY (event_participant_id) REFERENCES public.event(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: participant participant_sportsman_id_5f0e72cd_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.participant ADD CONSTRAINT participant_sportsman_id_5f0e72cd_fk_sportsman_id FOREIGN KEY (sportsman_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: permissions permissions_checked_by_id_c4ae2d37_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.permissions ADD CONSTRAINT permissions_checked_by_id_c4ae2d37_fk_auth_user_id FOREIGN KEY (checked_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: permissions permissions_ticket_status_id_ffaa2331_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.permissions ADD CONSTRAINT permissions_ticket_status_id_ffaa2331_fk_tickets_task_id FOREIGN KEY (ticket_status_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: permissions permissions_user_id_id_5e803886_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.permissions ADD CONSTRAINT permissions_user_id_id_5e803886_fk_auth_user_id FOREIGN KEY (user_id_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: provider provider_company_id_id_cbface41_fk_company_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.provider ADD CONSTRAINT provider_company_id_id_cbface41_fk_company_id FOREIGN KEY (company_id_id) REFERENCES public.company(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: provider provider_ticket_status_id_1393a2d9_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.provider ADD CONSTRAINT provider_ticket_status_id_1393a2d9_fk_tickets_task_id FOREIGN KEY (ticket_status_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: provider provider_user_id_id_f80c97d0_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.provider ADD CONSTRAINT provider_user_id_id_f80c97d0_fk_auth_user_id FOREIGN KEY (user_id_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: relationship relationship_ticket_status_id_95154047_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.relationship ADD CONSTRAINT relationship_ticket_status_id_95154047_fk_tickets_task_id FOREIGN KEY (ticket_status_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: relationship relationship_user_id_who_id_56f216cd_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.relationship ADD CONSTRAINT relationship_user_id_who_id_56f216cd_fk_auth_user_id FOREIGN KEY (user_id_who_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: relationship relationship_user_id_whom_id_ed5d0b59_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.relationship ADD CONSTRAINT relationship_user_id_whom_id_ed5d0b59_fk_auth_user_id FOREIGN KEY (user_id_whom_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: resource resource_ticket_status_id_fd78cde6_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.resource ADD CONSTRAINT resource_ticket_status_id_fd78cde6_fk_tickets_task_id FOREIGN KEY (ticket_status_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: resource resource_user_id_id_f8636fa7_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.resource ADD CONSTRAINT resource_user_id_id_f8636fa7_fk_auth_user_id FOREIGN KEY (user_id_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: saved_event saved_event_event_savedevent_id_9208645c_fk_event_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.saved_event ADD CONSTRAINT saved_event_event_savedevent_id_9208645c_fk_event_id FOREIGN KEY (event_savedevent_id) REFERENCES public.event(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: saved_event saved_event_sportsman_id_02a40b11_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.saved_event ADD CONSTRAINT saved_event_sportsman_id_02a40b11_fk_sportsman_id FOREIGN KEY (sportsman_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: saved_sportsman saved_sportsman_sportsman_id_3a5033e3_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.saved_sportsman ADD CONSTRAINT saved_sportsman_sportsman_id_3a5033e3_fk_sportsman_id FOREIGN KEY (sportsman_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: saved_sportsman saved_sportsman_sportsman_saved_id_4ab950e0_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.saved_sportsman ADD CONSTRAINT saved_sportsman_sportsman_saved_id_4ab950e0_fk_sportsman_id FOREIGN KEY (sportsman_saved_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: service service_id_provider_id_1b630b89_fk_provider_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.service ADD CONSTRAINT service_id_provider_id_1b630b89_fk_provider_id FOREIGN KEY (id_provider_id) REFERENCES public.provider(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: service service_resource_id_id_0f1f1ca2_fk_resource_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.service ADD CONSTRAINT service_resource_id_id_0f1f1ca2_fk_resource_id FOREIGN KEY (resource_id_id) REFERENCES public.resource(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: service service_servicetype_id_id_3a28b055_fk_servicetype_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.service ADD CONSTRAINT service_servicetype_id_id_3a28b055_fk_servicetype_id FOREIGN KEY (servicetype_id_id) REFERENCES public.servicetype(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: service service_ticket_status_id_5b6b572d_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.service ADD CONSTRAINT service_ticket_status_id_5b6b572d_fk_tickets_task_id FOREIGN KEY (ticket_status_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: servicetype servicetype_ticket_status_id_77b8bfcd_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.servicetype ADD CONSTRAINT servicetype_ticket_status_id_77b8bfcd_fk_tickets_task_id FOREIGN KEY (ticket_status_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: sport_preferrence sport_preferrence_sport_id_331b3060_fk_sport_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.sport_preferrence ADD CONSTRAINT sport_preferrence_sport_id_331b3060_fk_sport_id FOREIGN KEY (sport_id) REFERENCES public.sport(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: sport_preferrence sport_preferrence_sportsman_id_c85f5d64_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.sport_preferrence ADD CONSTRAINT sport_preferrence_sportsman_id_c85f5d64_fk_sportsman_id FOREIGN KEY (sportsman_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: sportsman sportsman_client_id_d332b8c0_fk_client_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.sportsman ADD CONSTRAINT sportsman_client_id_d332b8c0_fk_client_id FOREIGN KEY (client_id) REFERENCES public.client(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: sportsman_gallery sportsman_gallery_sportsman_id_620db12f_fk_sportsman_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.sportsman_gallery ADD CONSTRAINT sportsman_gallery_sportsman_id_620db12f_fk_sportsman_id FOREIGN KEY (sportsman_id) REFERENCES public.sportsman(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: tickets_attachment tickets_attachment_added_by_id_3c8ddb6f_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_attachment ADD CONSTRAINT tickets_attachment_added_by_id_3c8ddb6f_fk_auth_user_id FOREIGN KEY (added_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: tickets_attachment tickets_attachment_task_id_075d0abc_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_attachment ADD CONSTRAINT tickets_attachment_task_id_075d0abc_fk_tickets_task_id FOREIGN KEY (task_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: tickets_comment tickets_comment_author_id_92e77b6b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_comment ADD CONSTRAINT tickets_comment_author_id_92e77b6b_fk_auth_user_id FOREIGN KEY (author_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: tickets_comment tickets_comment_task_id_13ac4c64_fk_tickets_task_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_comment ADD CONSTRAINT tickets_comment_task_id_13ac4c64_fk_tickets_task_id FOREIGN KEY (task_id) REFERENCES public.tickets_task(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: tickets_task tickets_task_assigned_to_id_5a33e646_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_task ADD CONSTRAINT tickets_task_assigned_to_id_5a33e646_fk_auth_user_id FOREIGN KEY (assigned_to_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: tickets_task tickets_task_created_by_id_b9c0cd01_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_task ADD CONSTRAINT tickets_task_created_by_id_b9c0cd01_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: tickets_task tickets_task_task_list_id_c1b9fc64_fk_tickets_tasklist_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_task ADD CONSTRAINT tickets_task_task_list_id_c1b9fc64_fk_tickets_tasklist_id FOREIGN KEY (task_list_id) REFERENCES public.tickets_tasklist(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: tickets_task tickets_task_type_id_162ca4d2_fk_tickets_tickettype_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_task ADD CONSTRAINT tickets_task_type_id_162ca4d2_fk_tickets_tickettype_id FOREIGN KEY (type_id) REFERENCES public.tickets_tickettype(id) DEFERRABLE INITIALLY DEFERRED; -- -- Name: tickets_tasklist tickets_tasklist_group_id_1c12657b_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: sports -- ALTER TABLE ONLY public.tickets_tasklist ADD CONSTRAINT tickets_tasklist_group_id_1c12657b_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED; -- -- PostgreSQL database dump complete --