database_dump.sql - main - argunv/demo

database_dump.sql
1 569 строк51 KB
anonimys2020
docs: описать запуск и дамп базы
02 июн 2026, 16:03
02 июн 2026, 16:035ffdf4b
--
-- PostgreSQL database dump
--

\restrict ZgQ4byzu53BZ6zOhOtsL5esq9IdcvuQf5BRdKO0MNzDobnU6nJnfDuxjnUhqFRz

-- Dumped from database version 17.10 (Homebrew)
-- Dumped by pg_dump version 17.10 (Homebrew)

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

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.auth_group (
    id integer NOT NULL,
    name character varying(150) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO vladislavargun;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

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

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 vladislavargun;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

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

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 vladislavargun;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

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: core_category; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_category (
    id bigint NOT NULL,
    name character varying(255) NOT NULL
);


ALTER TABLE public.core_category OWNER TO vladislavargun;

--
-- Name: core_category_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_category ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_category_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: core_manufacturer; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_manufacturer (
    id bigint NOT NULL,
    name character varying(255) NOT NULL
);


ALTER TABLE public.core_manufacturer OWNER TO vladislavargun;

--
-- Name: core_manufacturer_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_manufacturer ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_manufacturer_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: core_order; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_order (
    id bigint NOT NULL,
    status character varying(40) NOT NULL,
    order_date character varying(20),
    delivery_date character varying(20),
    client_full_name character varying(255) NOT NULL,
    receive_code character varying(50) NOT NULL,
    pickup_point_id bigint NOT NULL
);


ALTER TABLE public.core_order OWNER TO vladislavargun;

--
-- Name: core_order_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_order ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_order_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: core_orderitem; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_orderitem (
    id bigint NOT NULL,
    quantity integer NOT NULL,
    order_id bigint NOT NULL,
    product_id bigint NOT NULL
);


ALTER TABLE public.core_orderitem OWNER TO vladislavargun;

--
-- Name: core_orderitem_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_orderitem ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_orderitem_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: core_pickuppoint; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_pickuppoint (
    id bigint NOT NULL,
    address character varying(300) NOT NULL
);


ALTER TABLE public.core_pickuppoint OWNER TO vladislavargun;

--
-- Name: core_pickuppoint_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_pickuppoint ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_pickuppoint_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: core_product; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_product (
    id bigint NOT NULL,
    article character varying(50) NOT NULL,
    name character varying(255) NOT NULL,
    description text NOT NULL,
    price numeric(10,2) NOT NULL,
    unit character varying(30) NOT NULL,
    stock_quantity integer NOT NULL,
    discount integer NOT NULL,
    photo character varying(100),
    category_id bigint NOT NULL,
    manufacturer_id bigint NOT NULL,
    supplier_id bigint NOT NULL
);


ALTER TABLE public.core_product OWNER TO vladislavargun;

--
-- Name: core_product_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_product ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_product_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: core_role; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_role (
    id bigint NOT NULL,
    code character varying(30) NOT NULL,
    name character varying(120) NOT NULL
);


ALTER TABLE public.core_role OWNER TO vladislavargun;

--
-- Name: core_role_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_role ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_role_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: core_supplier; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_supplier (
    id bigint NOT NULL,
    name character varying(255) NOT NULL
);


ALTER TABLE public.core_supplier OWNER TO vladislavargun;

--
-- Name: core_supplier_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_supplier ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_supplier_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: core_userprofile; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_userprofile (
    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,
    full_name character varying(255) NOT NULL,
    role_id bigint
);


ALTER TABLE public.core_userprofile OWNER TO vladislavargun;

--
-- Name: core_userprofile_groups; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_userprofile_groups (
    id bigint NOT NULL,
    userprofile_id bigint NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.core_userprofile_groups OWNER TO vladislavargun;

--
-- Name: core_userprofile_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_userprofile_groups ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_userprofile_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: core_userprofile_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_userprofile ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_userprofile_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: core_userprofile_user_permissions; Type: TABLE; Schema: public; Owner: vladislavargun
--

CREATE TABLE public.core_userprofile_user_permissions (
    id bigint NOT NULL,
    userprofile_id bigint NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.core_userprofile_user_permissions OWNER TO vladislavargun;

--
-- Name: core_userprofile_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

ALTER TABLE public.core_userprofile_user_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.core_userprofile_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: vladislavargun
--

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 vladislavargun;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

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

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 vladislavargun;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

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_migrations; Type: TABLE; Schema: public; Owner: vladislavargun
--

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 vladislavargun;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: vladislavargun
--

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

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 vladislavargun;

--
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.auth_group (id, name) FROM stdin;
\.


--
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


--
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

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	3	add_permission
6	Can change permission	3	change_permission
7	Can delete permission	3	delete_permission
8	Can view permission	3	view_permission
9	Can add group	2	add_group
10	Can change group	2	change_group
11	Can delete group	2	delete_group
12	Can view group	2	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 category	6	add_category
22	Can change category	6	change_category
23	Can delete category	6	delete_category
24	Can view category	6	view_category
25	Can add manufacturer	7	add_manufacturer
26	Can change manufacturer	7	change_manufacturer
27	Can delete manufacturer	7	delete_manufacturer
28	Can view manufacturer	7	view_manufacturer
29	Can add pickup point	10	add_pickuppoint
30	Can change pickup point	10	change_pickuppoint
31	Can delete pickup point	10	delete_pickuppoint
32	Can view pickup point	10	view_pickuppoint
33	Can add role	12	add_role
34	Can change role	12	change_role
35	Can delete role	12	delete_role
36	Can view role	12	view_role
37	Can add supplier	13	add_supplier
38	Can change supplier	13	change_supplier
39	Can delete supplier	13	delete_supplier
40	Can view supplier	13	view_supplier
41	Can add order	8	add_order
42	Can change order	8	change_order
43	Can delete order	8	delete_order
44	Can view order	8	view_order
45	Can add product	11	add_product
46	Can change product	11	change_product
47	Can delete product	11	delete_product
48	Can view product	11	view_product
49	Can add user	14	add_userprofile
50	Can change user	14	change_userprofile
51	Can delete user	14	delete_userprofile
52	Can view user	14	view_userprofile
53	Can add order item	9	add_orderitem
54	Can change order item	9	change_orderitem
55	Can delete order item	9	delete_orderitem
56	Can view order item	9	view_orderitem
\.


--
-- Data for Name: core_category; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_category (id, name) FROM stdin;
1	Велосипед взрослый горный
2	Велосипед городской подростковый
3	Велосипед городской взрослый
4	Велосипед детский горный
5	Велосипед детский городской
\.


--
-- Data for Name: core_manufacturer; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_manufacturer (id, name) FROM stdin;
1	Slash
2	Shimano
3	Skill bike
4	NEXT
5	Aero
6	Fizard
7	kari
\.


--
-- Data for Name: core_order; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_order (id, status, order_date, delivery_date, client_full_name, receive_code, pickup_point_id) FROM stdin;
1	Новый	02/27/23	04/20/23	Степанов Михаил Артёмович	901	1
2	Новый	09/28/22	04/21/23	Никифорова Весения Николаевна	902	11
3	Новый	03/21/23	04/22/23	Сазонов Руслан Германович	903	2
4	Завершен	02/20/23	04/23/23	Одинцов Серафим Артёмович	904	11
5	Завершен	03/17/23	04/24/23	Степанов Михаил Артёмович	905	2
6	Завершен	03/01/23	04/25/23	Никифорова Весения Николаевна	906	15
7	Завершен	30.02.2023	04/26/23	Сазонов Руслан Германович	907	3
8	Новый	03/31/23	04/27/23	Одинцов Серафим Артёмович	908	19
9	Новый	04/02/23	04/28/23	Степанов Михаил Артёмович	909	5
10	Новый	04/03/23	04/29/23	Степанов Михаил Артёмович	910	19
\.


--
-- Data for Name: core_orderitem; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_orderitem (id, quantity, order_id, product_id) FROM stdin;
1	2	1	1
2	2	1	2
3	1	2	2
4	1	2	1
5	10	3	3
6	10	3	4
7	5	4	5
8	4	4	3
9	20	5	6
10	20	5	7
11	2	6	1
12	2	6	2
13	3	7	8
14	3	7	9
15	1	8	5
16	1	8	6
17	5	9	10
18	1	9	9
19	5	10	9
20	5	10	10
\.


--
-- Data for Name: core_pickuppoint; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_pickuppoint (id, address) FROM stdin;
1	420151, г. Лесной, ул. Вишневая, 32
2	125061, г. Лесной, ул. Подгорная, 8
3	630370, г. Лесной, ул. Шоссейная, 24
4	400562, г. Лесной, ул. Зеленая, 32
5	614510, г. Лесной, ул. Маяковского, 47
6	410542, г. Лесной, ул. Светлая, 46
7	620839, г. Лесной, ул. Цветочная, 8
8	443890, г. Лесной, ул. Коммунистическая, 1
9	603379, г. Лесной, ул. Спортивная, 46
10	603721, г. Лесной, ул. Гоголя, 41
11	410172, г. Лесной, ул. Северная, 13
12	614611, г. Лесной, ул. Молодежная, 50
13	454311, г.Лесной, ул. Новая, 19
14	660007, г.Лесной, ул. Октябрьская, 19
15	603036, г. Лесной, ул. Садовая, 4
16	394060, г.Лесной, ул. Фрунзе, 43
17	410661, г. Лесной, ул. Школьная, 50
18	625590, г. Лесной, ул. Коммунистическая, 20
19	625683, г. Лесной, ул. 8 Марта
20	450983, г.Лесной, ул. Комсомольская, 26
21	394782, г. Лесной, ул. Чехова, 3
22	603002, г. Лесной, ул. Дзержинского, 28
23	450558, г. Лесной, ул. Набережная, 30
24	344288, г. Лесной, ул. Чехова, 1
25	614164, г.Лесной,  ул. Степная, 30
26	394242, г. Лесной, ул. Коммунистическая, 43
27	660540, г. Лесной, ул. Солнечная, 25
28	125837, г. Лесной, ул. Шоссейная, 40
29	125703, г. Лесной, ул. Партизанская, 49
30	625283, г. Лесной, ул. Победы, 46
31	614753, г. Лесной, ул. Полевая, 35
32	426030, г. Лесной, ул. Маяковского, 44
33	450375, г. Лесной ул. Клубная, 44
34	625560, г. Лесной, ул. Некрасова, 12
35	630201, г. Лесной, ул. Комсомольская, 17
36	190949, г. Лесной, ул. Мичурина, 26
\.


--
-- Data for Name: core_product; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_product (id, article, name, description, price, unit, stock_quantity, discount, photo, category_id, manufacturer_id, supplier_id) FROM stdin;
1	А112Т4	Велосипед взрослый горный Slash Stream 27.5 колеса (2025) 17" Черный (162-172 см)	Горный велосипед Slash Stream 27.5 (2025) – легкий и надежный компаньон для поездок по пересеченной местности. Мощные шатуны интенсивно передают усилия мышц на вал каретки.	19775.00	шт.	15	30	products/1.JPG	1	1	1
2	G843H5	Велосипед взрослый горный Slash Stream 27.5 колеса (2025) 19" Синий (172-182 см)	В комплектацию включены дисковые механические тормоза RPT DSC-310. Особый упор разработчики рамы данной модели сделали на увеличение прочности мест наибольшей нагрузки.	19791.00	шт.	9	30	products/2.JPG	1	1	1
3	D325D4	Велосипед городской подростковый серый	Городской подростковый велосипед - идеальный выбор для активного образа жизни!\nОткройте для себя комфорт и свободу передвижения с нашим стильным городским велосипедом.	9919.00	шт.	12	5	products/3.JPG	2	2	2
4	S432T5	Велосипед Skill Bike 3051, городской, 21 скорость, сталь, 29" колеса, черно-красный	SKILL BIKE модель 3051 - горный велосипед на спицах, обеспечивающий уверенную и комфортную езду как по городским улицам, так и по горной местности.	16442.00	шт.	15	15	products/4.JPG	3	3	3
5	F325D4	Велосипед Skillbike 3052, горный, складной, рама 17 дюймов, колеса 26 дюймов, 21 скорость	SKILL BIKE модель 3052 - велосипед складной, предназначен для тех, кто ценит комфорт, стиль и максимальную мобильность. Горный велосипед легко помещается в багажник и идеально подходит для активных поездок в городской суете.	17985.00	шт.	50	18	products/5.JPG	1	3	3
6	G432G6	Велосипед Skill Bike 3053, горный, двухподвесный, рама 17 дюймов, колеса 26 дюймов, 21 скорость	SKILL BIKE модель 3053 - горный велосипед на литых дисках, имеет амортизаторы как на переднем, так и на заднем колесе.	17621.00	шт.	0	20	products/6.JPG	1	3	3
7	H542F5	Велосипед MILANO M300, горный, для взрослых, 26", 7 скоростей	Горный велосипед MILANO M300 с диаметром колес 26 дюйма подойдет для подростков и взрослых, без усилий позволит преодолевать любые непроходимые каменистые поверхности и зоны бездорожья.	13509.00	шт.	5	4	products/7.JPG	1	4	4
8	C346F5	Горный велосипед скоростной, колёса 24", рама - 14", черно-красный	Горный велосипед – это надежный и стильный выбор для любителей активного отдыха. Удобное седло из искусственной кожи и наличие подножки добавляют удобства во время поездок.	15212.00	шт.	4	5	products/8.JPG	4	5	4
9	F256G6	26" Велосипед Fizard, 15" алюминий, дисковые тормоза, 21 скорость, серый	Горный велосипед Fizard — надёжный универсальный маунтинбайк для города и бездорожья.	15126.00	шт.	3	25	products/9.JPG	4	6	4
10	J532V5	Велосипед двухколесный детский 14 дюймов, со светящимися колесами, черный	Велосипед двухколесный детский 14 дюймов от Kari - это надежный и безопасный транспорт для вашего ребенка.	6417.00	шт.	6	8		5	7	5
\.


--
-- Data for Name: core_role; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_role (id, code, name) FROM stdin;
1	guest	Гость
2	client	Клиент
3	admin	Администратор
4	manager	Менеджер
\.


--
-- Data for Name: core_supplier; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_supplier (id, name) FROM stdin;
1	ВелоСтрана
2	ЯндексМаркет
3	Скилс
4	ПерспективаГрупп
5	kari
\.


--
-- Data for Name: core_userprofile; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_userprofile (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined, full_name, role_id) FROM stdin;
1	pbkdf2_sha256$1200000$Yd1D6GXmcHUKinIxWwK1zl$59zz1qsYyMXcimQQIksleAGNx6+qH2klDmju66qntsg=	\N	t	94d5ous@gmail.com				t	t	2026-06-02 16:00:46.363243+03	Никифорова Весения Николаевна	3
2	pbkdf2_sha256$1200000$fbrELdlbJeExXU4q2jentO$WbKvCtHHNeo1fXEf9HDcfEWazyHKwjN1naTZQkWN/zU=	\N	t	uth4iz@mail.com				t	t	2026-06-02 16:00:46.664582+03	Сазонов Руслан Германович	3
3	pbkdf2_sha256$1200000$VewIY9Jb4Qf11LMSXvJ5Mf$OkWP8gz4qbpadIS7shwQ0/10kO2XPDIVT74GSbr/8hY=	\N	t	5d4zbu@tutanota.com				t	t	2026-06-02 16:00:46.967372+03	Одинцов Серафим Артёмович	3
4	pbkdf2_sha256$1200000$CzQONFWPzmntV4nty5Vmc5$jaA50ynhe97S9u9vL9qbmnuVSCtb5oBNyuPHyNs02po=	\N	f	ptec8ym@yahoo.com				f	t	2026-06-02 16:00:47.273133+03	Ситдикова Елена Анатольевна	4
5	pbkdf2_sha256$1200000$6kildGm1Ehmk7kaMH07deW$BwUkaIwnNRonhN28gWb9qhcoeD+NQ+W7NlKh/Da+M/w=	\N	f	1qz4kw@mail.com				f	t	2026-06-02 16:00:47.575568+03	Ворсин Петр Евгеньевич	4
6	pbkdf2_sha256$1200000$fs9C4rB9SAYt5uLB1OcoLw$yZnhzCfEkkntvMIpo/5/17SoSFrT1pj0uFzUhE8Ah9I=	\N	f	4np6se@mail.com				f	t	2026-06-02 16:00:47.895008+03	Старикова Елена Павловна	4
7	pbkdf2_sha256$1200000$ZcUrJesUFmMAt12gJQ9E6h$lFQi6VgznTAbiKxkhkzVlUZ/YeiGxUq53DfVgAlbdYk=	\N	f	yzls62@outlook.com				f	t	2026-06-02 16:00:48.212542+03	Никифорова Анна Семеновна	2
8	pbkdf2_sha256$1200000$hhHhZojc7KRj81DLUjiHGk$pnxzAm3T8CgWWnY933MO64/IUtpzqxhTaO2R4sJIw08=	\N	f	1diph5e@tutanota.com				f	t	2026-06-02 16:00:48.513198+03	Стелина Евгения Петровна	2
9	pbkdf2_sha256$1200000$NOrIHo4vJLE0QaWY7w1Ze8$mkkG7lfVLZM3QWbjFfZKyzFHbwFmmU/qFIN/e1hqKXI=	\N	f	tjde7c@yahoo.com				f	t	2026-06-02 16:00:48.81475+03	Михайлюк Анна Вячеславовна	2
10	pbkdf2_sha256$1200000$KgdpC2ubou6PQZGfcQWh26$xV/aEL7zI53FoR1L4cByHCmcktDj02w83yY6LT8DMT8=	\N	f	wpmrc3do@tutanota.com				f	t	2026-06-02 16:00:49.117868+03	Степанов Михаил Артёмович	2
\.


--
-- Data for Name: core_userprofile_groups; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_userprofile_groups (id, userprofile_id, group_id) FROM stdin;
\.


--
-- Data for Name: core_userprofile_user_permissions; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.core_userprofile_user_permissions (id, userprofile_id, permission_id) FROM stdin;
\.


--
-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
\.


--
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	group
3	auth	permission
4	contenttypes	contenttype
5	sessions	session
6	core	category
7	core	manufacturer
8	core	order
9	core	orderitem
10	core	pickuppoint
11	core	product
12	core	role
13	core	supplier
14	core	userprofile
\.


--
-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2026-06-02 16:00:44.677388+03
2	contenttypes	0002_remove_content_type_name	2026-06-02 16:00:44.683394+03
3	auth	0001_initial	2026-06-02 16:00:44.710835+03
4	auth	0002_alter_permission_name_max_length	2026-06-02 16:00:44.716233+03
5	auth	0003_alter_user_email_max_length	2026-06-02 16:00:44.723045+03
6	auth	0004_alter_user_username_opts	2026-06-02 16:00:44.729976+03
7	auth	0005_alter_user_last_login_null	2026-06-02 16:00:44.735871+03
8	auth	0006_require_contenttypes_0002	2026-06-02 16:00:44.737329+03
9	auth	0007_alter_validators_add_error_messages	2026-06-02 16:00:44.742712+03
10	auth	0008_alter_user_username_max_length	2026-06-02 16:00:44.747963+03
11	auth	0009_alter_user_last_name_max_length	2026-06-02 16:00:44.753883+03
12	auth	0010_alter_group_name_max_length	2026-06-02 16:00:44.760325+03
13	auth	0011_update_proxy_permissions	2026-06-02 16:00:44.76442+03
14	auth	0012_alter_user_first_name_max_length	2026-06-02 16:00:44.769438+03
15	core	0001_initial	2026-06-02 16:00:44.87186+03
16	admin	0001_initial	2026-06-02 16:00:44.891262+03
17	admin	0002_logentry_remove_auto_add	2026-06-02 16:00:44.901078+03
18	admin	0003_logentry_add_action_flag_choices	2026-06-02 16:00:44.908794+03
19	sessions	0001_initial	2026-06-02 16:00:44.919634+03
\.


--
-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: vladislavargun
--

COPY public.django_session (session_key, session_data, expire_date) FROM stdin;
\.


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.auth_group_id_seq', 1, false);


--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.auth_group_permissions_id_seq', 1, false);


--
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.auth_permission_id_seq', 56, true);


--
-- Name: core_category_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_category_id_seq', 5, true);


--
-- Name: core_manufacturer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_manufacturer_id_seq', 7, true);


--
-- Name: core_order_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_order_id_seq', 1, false);


--
-- Name: core_orderitem_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_orderitem_id_seq', 20, true);


--
-- Name: core_pickuppoint_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_pickuppoint_id_seq', 36, true);


--
-- Name: core_product_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_product_id_seq', 10, true);


--
-- Name: core_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_role_id_seq', 4, true);


--
-- Name: core_supplier_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_supplier_id_seq', 5, true);


--
-- Name: core_userprofile_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_userprofile_groups_id_seq', 1, false);


--
-- Name: core_userprofile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_userprofile_id_seq', 10, true);


--
-- Name: core_userprofile_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.core_userprofile_user_permissions_id_seq', 1, false);


--
-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.django_admin_log_id_seq', 1, false);


--
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.django_content_type_id_seq', 14, true);


--
-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vladislavargun
--

SELECT pg_catalog.setval('public.django_migrations_id_seq', 19, true);


--
-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

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

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

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

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

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

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: core_category core_category_name_key; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_category
    ADD CONSTRAINT core_category_name_key UNIQUE (name);


--
-- Name: core_category core_category_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_category
    ADD CONSTRAINT core_category_pkey PRIMARY KEY (id);


--
-- Name: core_manufacturer core_manufacturer_name_key; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_manufacturer
    ADD CONSTRAINT core_manufacturer_name_key UNIQUE (name);


--
-- Name: core_manufacturer core_manufacturer_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_manufacturer
    ADD CONSTRAINT core_manufacturer_pkey PRIMARY KEY (id);


--
-- Name: core_order core_order_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_order
    ADD CONSTRAINT core_order_pkey PRIMARY KEY (id);


--
-- Name: core_orderitem core_orderitem_order_id_product_id_c19895da_uniq; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_orderitem
    ADD CONSTRAINT core_orderitem_order_id_product_id_c19895da_uniq UNIQUE (order_id, product_id);


--
-- Name: core_orderitem core_orderitem_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_orderitem
    ADD CONSTRAINT core_orderitem_pkey PRIMARY KEY (id);


--
-- Name: core_pickuppoint core_pickuppoint_address_key; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_pickuppoint
    ADD CONSTRAINT core_pickuppoint_address_key UNIQUE (address);


--
-- Name: core_pickuppoint core_pickuppoint_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_pickuppoint
    ADD CONSTRAINT core_pickuppoint_pkey PRIMARY KEY (id);


--
-- Name: core_product core_product_article_key; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_product
    ADD CONSTRAINT core_product_article_key UNIQUE (article);


--
-- Name: core_product core_product_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_product
    ADD CONSTRAINT core_product_pkey PRIMARY KEY (id);


--
-- Name: core_role core_role_code_key; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_role
    ADD CONSTRAINT core_role_code_key UNIQUE (code);


--
-- Name: core_role core_role_name_key; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_role
    ADD CONSTRAINT core_role_name_key UNIQUE (name);


--
-- Name: core_role core_role_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_role
    ADD CONSTRAINT core_role_pkey PRIMARY KEY (id);


--
-- Name: core_supplier core_supplier_name_key; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_supplier
    ADD CONSTRAINT core_supplier_name_key UNIQUE (name);


--
-- Name: core_supplier core_supplier_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_supplier
    ADD CONSTRAINT core_supplier_pkey PRIMARY KEY (id);


--
-- Name: core_userprofile_groups core_userprofile_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile_groups
    ADD CONSTRAINT core_userprofile_groups_pkey PRIMARY KEY (id);


--
-- Name: core_userprofile_groups core_userprofile_groups_userprofile_id_group_id_850ef664_uniq; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile_groups
    ADD CONSTRAINT core_userprofile_groups_userprofile_id_group_id_850ef664_uniq UNIQUE (userprofile_id, group_id);


--
-- Name: core_userprofile core_userprofile_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile
    ADD CONSTRAINT core_userprofile_pkey PRIMARY KEY (id);


--
-- Name: core_userprofile_user_permissions core_userprofile_user_pe_userprofile_id_permissio_99e366ea_uniq; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile_user_permissions
    ADD CONSTRAINT core_userprofile_user_pe_userprofile_id_permissio_99e366ea_uniq UNIQUE (userprofile_id, permission_id);


--
-- Name: core_userprofile_user_permissions core_userprofile_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile_user_permissions
    ADD CONSTRAINT core_userprofile_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: core_userprofile core_userprofile_username_key; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile
    ADD CONSTRAINT core_userprofile_username_key UNIQUE (username);


--
-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

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

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

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: vladislavargun
--

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

ALTER TABLE ONLY public.django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: vladislavargun
--

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

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

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

CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);


--
-- Name: core_category_name_55b68161_like; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_category_name_55b68161_like ON public.core_category USING btree (name varchar_pattern_ops);


--
-- Name: core_manufacturer_name_24f3fcf9_like; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_manufacturer_name_24f3fcf9_like ON public.core_manufacturer USING btree (name varchar_pattern_ops);


--
-- Name: core_order_pickup_point_id_a5e2e98b; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_order_pickup_point_id_a5e2e98b ON public.core_order USING btree (pickup_point_id);


--
-- Name: core_orderitem_order_id_30929c10; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_orderitem_order_id_30929c10 ON public.core_orderitem USING btree (order_id);


--
-- Name: core_orderitem_product_id_0c2047cd; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_orderitem_product_id_0c2047cd ON public.core_orderitem USING btree (product_id);


--
-- Name: core_pickuppoint_address_84b02d12_like; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_pickuppoint_address_84b02d12_like ON public.core_pickuppoint USING btree (address varchar_pattern_ops);


--
-- Name: core_product_article_5977a5fc_like; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_product_article_5977a5fc_like ON public.core_product USING btree (article varchar_pattern_ops);


--
-- Name: core_product_category_id_b9d8ff9f; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_product_category_id_b9d8ff9f ON public.core_product USING btree (category_id);


--
-- Name: core_product_manufacturer_id_d625b069; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_product_manufacturer_id_d625b069 ON public.core_product USING btree (manufacturer_id);


--
-- Name: core_product_supplier_id_493af3ba; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_product_supplier_id_493af3ba ON public.core_product USING btree (supplier_id);


--
-- Name: core_role_code_8abfc066_like; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_role_code_8abfc066_like ON public.core_role USING btree (code varchar_pattern_ops);


--
-- Name: core_role_name_ca4cd9c7_like; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_role_name_ca4cd9c7_like ON public.core_role USING btree (name varchar_pattern_ops);


--
-- Name: core_supplier_name_42c1de63_like; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_supplier_name_42c1de63_like ON public.core_supplier USING btree (name varchar_pattern_ops);


--
-- Name: core_userprofile_groups_group_id_384230fa; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_userprofile_groups_group_id_384230fa ON public.core_userprofile_groups USING btree (group_id);


--
-- Name: core_userprofile_groups_userprofile_id_b21bcdce; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_userprofile_groups_userprofile_id_b21bcdce ON public.core_userprofile_groups USING btree (userprofile_id);


--
-- Name: core_userprofile_role_id_391ca017; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_userprofile_role_id_391ca017 ON public.core_userprofile USING btree (role_id);


--
-- Name: core_userprofile_user_permissions_permission_id_c90fc1a9; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_userprofile_user_permissions_permission_id_c90fc1a9 ON public.core_userprofile_user_permissions USING btree (permission_id);


--
-- Name: core_userprofile_user_permissions_userprofile_id_e6c8d79a; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_userprofile_user_permissions_userprofile_id_e6c8d79a ON public.core_userprofile_user_permissions USING btree (userprofile_id);


--
-- Name: core_userprofile_username_4b8ba0a6_like; Type: INDEX; Schema: public; Owner: vladislavargun
--

CREATE INDEX core_userprofile_username_4b8ba0a6_like ON public.core_userprofile USING btree (username varchar_pattern_ops);


--
-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: vladislavargun
--

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

CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);


--
-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: vladislavargun
--

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

CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);


--
-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

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

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

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: core_order core_order_pickup_point_id_a5e2e98b_fk_core_pickuppoint_id; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_order
    ADD CONSTRAINT core_order_pickup_point_id_a5e2e98b_fk_core_pickuppoint_id FOREIGN KEY (pickup_point_id) REFERENCES public.core_pickuppoint(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_orderitem core_orderitem_order_id_30929c10_fk_core_order_id; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_orderitem
    ADD CONSTRAINT core_orderitem_order_id_30929c10_fk_core_order_id FOREIGN KEY (order_id) REFERENCES public.core_order(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_orderitem core_orderitem_product_id_0c2047cd_fk_core_product_id; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_orderitem
    ADD CONSTRAINT core_orderitem_product_id_0c2047cd_fk_core_product_id FOREIGN KEY (product_id) REFERENCES public.core_product(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_product core_product_category_id_b9d8ff9f_fk_core_category_id; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_product
    ADD CONSTRAINT core_product_category_id_b9d8ff9f_fk_core_category_id FOREIGN KEY (category_id) REFERENCES public.core_category(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_product core_product_manufacturer_id_d625b069_fk_core_manufacturer_id; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_product
    ADD CONSTRAINT core_product_manufacturer_id_d625b069_fk_core_manufacturer_id FOREIGN KEY (manufacturer_id) REFERENCES public.core_manufacturer(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_product core_product_supplier_id_493af3ba_fk_core_supplier_id; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_product
    ADD CONSTRAINT core_product_supplier_id_493af3ba_fk_core_supplier_id FOREIGN KEY (supplier_id) REFERENCES public.core_supplier(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_userprofile_groups core_userprofile_gro_userprofile_id_b21bcdce_fk_core_user; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile_groups
    ADD CONSTRAINT core_userprofile_gro_userprofile_id_b21bcdce_fk_core_user FOREIGN KEY (userprofile_id) REFERENCES public.core_userprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_userprofile_groups core_userprofile_groups_group_id_384230fa_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile_groups
    ADD CONSTRAINT core_userprofile_groups_group_id_384230fa_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_userprofile core_userprofile_role_id_391ca017_fk_core_role_id; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile
    ADD CONSTRAINT core_userprofile_role_id_391ca017_fk_core_role_id FOREIGN KEY (role_id) REFERENCES public.core_role(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_userprofile_user_permissions core_userprofile_use_permission_id_c90fc1a9_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile_user_permissions
    ADD CONSTRAINT core_userprofile_use_permission_id_c90fc1a9_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_userprofile_user_permissions core_userprofile_use_userprofile_id_e6c8d79a_fk_core_user; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.core_userprofile_user_permissions
    ADD CONSTRAINT core_userprofile_use_userprofile_id_e6c8d79a_fk_core_user FOREIGN KEY (userprofile_id) REFERENCES public.core_userprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

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_core_userprofile_id; Type: FK CONSTRAINT; Schema: public; Owner: vladislavargun
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_core_userprofile_id FOREIGN KEY (user_id) REFERENCES public.core_userprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- PostgreSQL database dump complete
--

\unrestrict ZgQ4byzu53BZ6zOhOtsL5esq9IdcvuQf5BRdKO0MNzDobnU6nJnfDuxjnUhqFRz