tmenu.psql

--
-- PostgreSQL database dump
--

-- Dumped from database version 13.4
-- Dumped by pg_dump version 13.4

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: alembic_version; Type: TABLE; Schema: public; Owner: rdoni
--

CREATE TABLE public.alembic_version (
    version_num character varying(32) NOT NULL
);


ALTER TABLE public.alembic_version OWNER TO rdoni;

--
-- Name: city; Type: TABLE; Schema: public; Owner: rdoni
--

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


ALTER TABLE public.city OWNER TO rdoni;

--
-- Name: city_id_seq; Type: SEQUENCE; Schema: public; Owner: rdoni
--

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


ALTER TABLE public.city_id_seq OWNER TO rdoni;

--
-- Name: city_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rdoni
--

ALTER SEQUENCE public.city_id_seq OWNED BY public.city.id;


--
-- Name: restaurant; Type: TABLE; Schema: public; Owner: rdoni
--

CREATE TABLE public.restaurant (
    id integer NOT NULL,
    name character varying NOT NULL,
    description character varying,
    menu character varying,
    city_id integer NOT NULL
);


ALTER TABLE public.restaurant OWNER TO rdoni;

--
-- Name: restaurant_id_seq; Type: SEQUENCE; Schema: public; Owner: rdoni
--

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


ALTER TABLE public.restaurant_id_seq OWNER TO rdoni;

--
-- Name: restaurant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rdoni
--

ALTER SEQUENCE public.restaurant_id_seq OWNED BY public.restaurant.id;


--
-- Name: city id; Type: DEFAULT; Schema: public; Owner: rdoni
--

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


--
-- Name: restaurant id; Type: DEFAULT; Schema: public; Owner: rdoni
--

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


--
-- Data for Name: alembic_version; Type: TABLE DATA; Schema: public; Owner: rdoni
--

COPY public.alembic_version (version_num) FROM stdin;
\.


--
-- Data for Name: city; Type: TABLE DATA; Schema: public; Owner: rdoni
--

COPY public.city (id, name) FROM stdin;
1	Tashkent
2	Kokand
3	Bukhara
\.


--
-- Data for Name: restaurant; Type: TABLE DATA; Schema: public; Owner: rdoni
--

COPY public.restaurant (id, name, description, menu, city_id) FROM stdin;
1	La Piola	qimmat ancha	not nesseccery for now	1
2	Piramida	nasib qimagan	not nesseccery for now	2
3	Ipak Yuli	borligini bilmiman :)	not nesseccery for now	3
4	Uch baqaloq	yopilib ketgan	not nesseccery for now	2
\.


--
-- Name: city_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rdoni
--

SELECT pg_catalog.setval('public.city_id_seq', 6, true);


--
-- Name: restaurant_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rdoni
--

SELECT pg_catalog.setval('public.restaurant_id_seq', 8, true);


--
-- Name: alembic_version alembic_version_pkc; Type: CONSTRAINT; Schema: public; Owner: rdoni
--

ALTER TABLE ONLY public.alembic_version
    ADD CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num);


--
-- Name: city city_pkey; Type: CONSTRAINT; Schema: public; Owner: rdoni
--

ALTER TABLE ONLY public.city
    ADD CONSTRAINT city_pkey PRIMARY KEY (id);


--
-- Name: restaurant restaurant_pkey; Type: CONSTRAINT; Schema: public; Owner: rdoni
--

ALTER TABLE ONLY public.restaurant
    ADD CONSTRAINT restaurant_pkey PRIMARY KEY (id);


--
-- Name: restaurant restaurant_city_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rdoni
--

ALTER TABLE ONLY public.restaurant
    ADD CONSTRAINT restaurant_city_id_fkey FOREIGN KEY (city_id) REFERENCES public.city(id);


--
-- PostgreSQL database dump complete
--