--
-- PostgreSQL database dump
--

\restrict 3eocS4QpDoQP3igusSgLPPc25sgwWvH2JcjmvzZ6uMe5OFOERktgicK048vr4Kd

-- Dumped from database version 16.10
-- Dumped by pg_dump version 16.10

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: combos; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.combos (
    id integer NOT NULL,
    name text NOT NULL,
    marathi_name text,
    description text NOT NULL,
    marathi_description text,
    salad_ids text[] NOT NULL,
    base_price integer NOT NULL,
    combo_price integer NOT NULL,
    discount integer NOT NULL,
    image_url text NOT NULL,
    servings integer NOT NULL
);


ALTER TABLE public.combos OWNER TO postgres;

--
-- Name: combos_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.combos_id_seq OWNER TO postgres;

--
-- Name: combos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.combos_id_seq OWNED BY public.combos.id;


--
-- Name: contact_requests; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.contact_requests (
    id integer NOT NULL,
    name text NOT NULL,
    phone text NOT NULL,
    message text NOT NULL
);


ALTER TABLE public.contact_requests OWNER TO postgres;

--
-- Name: contact_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.contact_requests_id_seq OWNER TO postgres;

--
-- Name: contact_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.contact_requests_id_seq OWNED BY public.contact_requests.id;


--
-- Name: outlets; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.outlets (
    id integer NOT NULL,
    name text NOT NULL,
    marathi_name text,
    address text NOT NULL,
    marathi_address text,
    lat text NOT NULL,
    lng text NOT NULL,
    phone text NOT NULL
);


ALTER TABLE public.outlets OWNER TO postgres;

--
-- Name: outlets_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.outlets_id_seq OWNER TO postgres;

--
-- Name: outlets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.outlets_id_seq OWNED BY public.outlets.id;


--
-- Name: salads; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.salads (
    id integer NOT NULL,
    name text NOT NULL,
    marathi_name text,
    description text NOT NULL,
    marathi_description text,
    price integer NOT NULL,
    ingredients text[] NOT NULL,
    calories integer NOT NULL,
    protein text NOT NULL,
    carbs text NOT NULL,
    fat text NOT NULL,
    is_veg boolean DEFAULT true,
    image_url text NOT NULL,
    category text NOT NULL
);


ALTER TABLE public.salads OWNER TO postgres;

--
-- Name: salads_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.salads_id_seq OWNER TO postgres;

--
-- Name: salads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.salads_id_seq OWNED BY public.salads.id;


--
-- Name: subscriptions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.subscriptions (
    id integer NOT NULL,
    name text NOT NULL,
    marathi_name text,
    description text NOT NULL,
    marathi_description text,
    type text NOT NULL,
    duration integer NOT NULL,
    base_price integer NOT NULL,
    discounted_price integer NOT NULL,
    savings_percentage integer NOT NULL,
    salads_per_week integer NOT NULL,
    image_url text NOT NULL
);


ALTER TABLE public.subscriptions OWNER TO postgres;

--
-- Name: subscriptions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.subscriptions_id_seq OWNER TO postgres;

--
-- Name: subscriptions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.subscriptions_id_seq OWNED BY public.subscriptions.id;


--
-- Name: combos id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: contact_requests id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: outlets id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: salads id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: subscriptions id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Data for Name: combos; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.combos (id, name, marathi_name, description, marathi_description, salad_ids, base_price, combo_price, discount, image_url, servings) FROM stdin;
1	Power & Detox Duo	पॉवर आणि डिटॉक्स ड्यू	Protein Power Bowl + Green Detox Salad	प्रोटीन पॉवर बाउल + ग्रीन डिटॉक्स सॅलड	{1,2}	448	379	15	https://images.unsplash.com/photo-1546069901-ba9599a7e63c?w=800&q=80	2
2	Triple Health Pack	ट्रिपल हेल्थ पॅक	Protein Power + Green Detox + Paneer Tikka	प्रोटीन पॉवर + ग्रीन डिटॉक्स + पनीर टिक्का	{1,2,4}	677	542	20	https://images.unsplash.com/photo-1512621776951-a57141f2eefd?w=800&q=80	3
3	Weight Loss Combo	वजन कमी करण्याचा कॉम्बो	Exotic Fruit + Sprouts & Moong + Corn & Peanut	एक्झॉटिक फ्रूट + स्प्राउट्स & मूग + कॉर्न & शेंगदाणा	{3,5,7}	488	390	20	https://images.unsplash.com/photo-1519996529931-28324d5a630e?w=800&q=80	3
4	Mediterranean Bliss	मेडिटेरेनियन ब्लिस	Mediterranean Quinoa + Greek Salad + Beetroot Walnut	मेडिटेरेनियन क्विनोआ + ग्रीक सॅलड + बीटरूट अक्रोड	{6,8,9}	788	630	20	https://images.unsplash.com/photo-1511690656952-34342d5c2899?w=800&q=80	3
\.


--
-- Data for Name: contact_requests; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.contact_requests (id, name, phone, message) FROM stdin;
\.


--
-- Data for Name: outlets; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.outlets (id, name, marathi_name, address, marathi_address, lat, lng, phone) FROM stdin;
1	Daily Bowl - Thane West	डेली बाउल - ठाणे पश्चिम	Gawand baug, kokanipada, Thane west 400 610	गावंड बाग, कोकणीपाडा, ठाणे पश्चिम ४०० ६१०	19.2452	72.9723	+91 9594620104
2	Daily Bowl - Mulund	डेली बाउल - मुलुंड	Shop 5, R-Mall, Mulund West, Mumbai 400080	दुकान ५, आर-मॉल, मुलुंड पश्चिम, मुंबई ४०००८०	19.1764	72.9525	+91 9594620105
\.


--
-- Data for Name: salads; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.salads (id, name, marathi_name, description, marathi_description, price, ingredients, calories, protein, carbs, fat, is_veg, image_url, category) FROM stdin;
1	Protein Power Bowl	प्रोटीन पॉवर बाउल	A high-protein mix of chickpeas, kidney beans, and paneer with a tangy lemon dressing.	काबुली चणा, राजमा आणि पनीर यांचे लिंबाच्या रसासोबत हाय प्रोटीन मिश्रण.	199	{Chickpeas,"Kidney Beans",Paneer,"Lemon Dressing",Cucumber,Tomato}	350	22g	45g	12g	t	https://images.unsplash.com/photo-1546069901-ba9599a7e63c?w=800&q=80	Muscle Gain
2	Green Detox Salad	ग्रीन डिटॉक्स सॅलड	Fresh spinach, kale, avocado, and green apple for a refreshing detox.	ताजे पालक, केल, ॲव्होकॅडो आणि हिरवे सफरचंद यांचे डिटॉक्स मिश्रण.	249	{Spinach,Kale,Avocado,"Green Apple","Chia Seeds","Honey Mustard Dressing"}	220	5g	18g	15g	t	https://images.unsplash.com/photo-1512621776951-a57141f2eefd?w=800&q=80	Detox
3	Exotic Fruit Bowl	एक्झॉटिक फ्रूट बाउल	A colorful mix of seasonal fruits topped with seeds and honey.	हंगामी फळांचे बिया आणि मधासह रंगीबेरंगी मिश्रण.	179	{Watermelon,Papaya,Pomegranate,Kiwi,"Sunflower Seeds",Honey}	180	3g	40g	2g	t	https://images.unsplash.com/photo-1519996529931-28324d5a630e?w=800&q=80	Weight Loss
4	Paneer Tikka Salad	पनीर टिक्का सॅलड	Grilled paneer cubes with roasted vegetables and mint chutney.	भाजलेल्या भाज्या आणि पुदिन्याच्या चटणीसह ग्रिल्ड पनीर.	229	{"Grilled Paneer","Bell Peppers",Onion,"Mint Chutney",Lettuce}	310	18g	12g	20g	t	https://images.unsplash.com/photo-1567620905732-2d1ec7ab7445?w=800&q=80	Muscle Gain
5	Sprouts & Moong Salad	स्प्राउट्स आणि मूग सॅलड	Healthy sprouted moong with chopped veggies and chaat masala.	भाज्या आणि चाट मसाल्यासह मोड आलेले मूग.	149	{"Sprouted Moong",Onion,Tomato,Coriander,"Chaat Masala","Lemon Juice"}	160	10g	28g	1g	t	https://images.unsplash.com/photo-1547496502-ffa22d388bce?w=800&q=80	Weight Loss
6	Mediterranean Quinoa Bowl	मेडिटेरेनियन क्विनोआ बाउल	Quinoa, olives, feta cheese, and cherry tomatoes with olive oil dressing.	क्विनोआ, ऑलिव्ह, फेटा चीज आणि चेरी टोमॅटो ऑलिव्ह ऑइल ड्रेसिंगसह.	299	{Quinoa,Olives,"Feta Cheese","Cherry Tomatoes",Cucumber,"Olive Oil"}	340	12g	42g	14g	t	https://images.unsplash.com/photo-1511690656952-34342d5c2899?w=800&q=80	Detox
7	Corn & Peanut Salsa	कॉर्न आणि शेंगदाणा सालसा	Sweet corn and crunchy peanuts tossed with spicy salsa.	तिखट सालसासह स्वीट कॉर्न आणि शेंगदाणे.	159	{"Sweet Corn","Roasted Peanuts",Onion,Tomato,"Green Chilli",Lemon}	250	9g	30g	11g	t	https://images.unsplash.com/photo-1529312266912-b33cf6227e24?w=800&q=80	Weight Loss
8	Classic Greek Salad	क्लासिक ग्रीक सॅलड	Crispy lettuce, cucumber, olives, and feta cheese.	कुरकुरीत लेट्यूस, काकडी, ऑलिव्ह आणि फेटा चीज.	269	{Lettuce,Cucumber,"Black Olives","Feta Cheese","Red Onion",Oregano}	210	6g	10g	16g	t	https://images.unsplash.com/photo-1540420773420-3366772f4999?w=800&q=80	Detox
9	Beetroot & Walnut Salad	बीटरूट आणि अक्रोड सॅलड	Roasted beetroot slices with crunchy walnuts and feta.	भाजलेले बीटरूटचे तुकडे, अक्रोड आणि फेटा.	219	{"Roasted Beetroot",Walnuts,"Feta Cheese",Arugula,"Balsamic Glaze"}	230	7g	15g	16g	t	https://images.unsplash.com/photo-1505576399279-565b52d4ac71?w=800&q=80	Detox
10	Tofu & Broccoli Stir Fry	टोफू आणि ब्रोकोली स्टिर फ्राय	Grilled tofu and broccoli tossed in soy-garlic sauce.	सोया-लसूण सॉसमध्ये टोफू आणि ब्रोकोली.	279	{Tofu,Broccoli,"Bell Peppers","Soy Sauce",Garlic,"Sesame Seeds"}	290	20g	15g	18g	t	https://images.unsplash.com/photo-1623428187969-5da2dcea5ebf?w=800&q=80	Muscle Gain
\.


--
-- Data for Name: subscriptions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.subscriptions (id, name, marathi_name, description, marathi_description, type, duration, base_price, discounted_price, savings_percentage, salads_per_week, image_url) FROM stdin;
1	Weekly Starter	साप्ताहिक स्टार्टर	Get 3 fresh salads every week with 15% savings	दर आठवड्यातून 3 ताजे सॅलड 15% सवयीत	weekly	1	597	507	15	3	https://images.unsplash.com/photo-1546069901-ba9599a7e63c?w=800&q=80
2	Weekly Premium	साप्ताहिक प्रीमियम	Get 5 fresh salads every week with 20% savings	दर आठवड्यातून 5 ताजे सॅलड 20% सवयीत	weekly	1	995	796	20	5	https://images.unsplash.com/photo-1512621776951-a57141f2eefd?w=800&q=80
3	Monthly Starter	मासिक स्टार्टर	Get 12 fresh salads every month with 25% savings	दर महिन्यातून 12 ताजे सॅलड 25% सवयीत	monthly	1	2388	1791	25	3	https://images.unsplash.com/photo-1519996529931-28324d5a630e?w=800&q=80
4	Monthly Premium	मासिक प्रीमियम	Get 20 fresh salads every month with 30% savings	दर महिन्यातून 20 ताजे सॅलड 30% सवयीत	monthly	1	3980	2786	30	5	https://images.unsplash.com/photo-1540420773420-3366772f4999?w=800&q=80
\.


--
-- Name: combos_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: contact_requests_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: outlets_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.outlets_id_seq', 2, true);


--
-- Name: salads_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: subscriptions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: combos combos_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.combos
    ADD CONSTRAINT combos_pkey PRIMARY KEY (id);


--
-- Name: contact_requests contact_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.contact_requests
    ADD CONSTRAINT contact_requests_pkey PRIMARY KEY (id);


--
-- Name: outlets outlets_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.outlets
    ADD CONSTRAINT outlets_pkey PRIMARY KEY (id);


--
-- Name: salads salads_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.salads
    ADD CONSTRAINT salads_pkey PRIMARY KEY (id);


--
-- Name: subscriptions subscriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscriptions
    ADD CONSTRAINT subscriptions_pkey PRIMARY KEY (id);


--
-- PostgreSQL database dump complete
--

\unrestrict 3eocS4QpDoQP3igusSgLPPc25sgwWvH2JcjmvzZ6uMe5OFOERktgicK048vr4Kd

