--
--


-- Started on 2025-08-12 02:13:29

SET transaction_timeout = 0;



--
-- TOC entry 235 (class 1259 OID 17130)
-- Name: brands; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.brands (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    status smallint DEFAULT '0'::smallint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.brands OWNER TO admin;

--
-- TOC entry 234 (class 1259 OID 17129)
-- Name: brands_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.brands_id_seq OWNER TO admin;

--
-- TOC entry 5212 (class 0 OID 0)
-- Dependencies: 234
-- Name: brands_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.brands_id_seq OWNED BY public.brands.id;


--
-- TOC entry 247 (class 1259 OID 17241)
-- Name: carts; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.carts (
    id bigint NOT NULL,
    user_id bigint,
    product_id bigint NOT NULL,
    varient_id bigint NOT NULL,
    quantity integer NOT NULL,
    price numeric(10,2) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.carts OWNER TO admin;

--
-- TOC entry 246 (class 1259 OID 17240)
-- Name: carts_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.carts_id_seq OWNER TO admin;

--
-- TOC entry 5213 (class 0 OID 0)
-- Dependencies: 246
-- Name: carts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.carts_id_seq OWNED BY public.carts.id;


--
-- TOC entry 227 (class 1259 OID 17085)
-- Name: categories; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.categories (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    icon character varying(255),
    status boolean DEFAULT false,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.categories OWNER TO admin;

--
-- TOC entry 226 (class 1259 OID 17084)
-- Name: categories_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.categories_id_seq OWNER TO admin;

--
-- TOC entry 5214 (class 0 OID 0)
-- Dependencies: 226
-- Name: categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.categories_id_seq OWNED BY public.categories.id;


--
-- TOC entry 231 (class 1259 OID 17110)
-- Name: colors; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.colors (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    code character varying(255) NOT NULL,
    status smallint DEFAULT '0'::smallint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.colors OWNER TO admin;

--
-- TOC entry 230 (class 1259 OID 17109)
-- Name: colors_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.colors_id_seq OWNER TO admin;

--
-- TOC entry 5215 (class 0 OID 0)
-- Dependencies: 230
-- Name: colors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.colors_id_seq OWNED BY public.colors.id;


--
-- TOC entry 263 (class 1259 OID 17351)
-- Name: delivery_charges; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.delivery_charges (
    id bigint NOT NULL,
    location_type character varying(255) NOT NULL,
    charge numeric(10,2) NOT NULL,
    status boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.delivery_charges OWNER TO admin;

--
-- TOC entry 262 (class 1259 OID 17350)
-- Name: delivery_charges_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.delivery_charges_id_seq OWNER TO admin;

--
-- TOC entry 5216 (class 0 OID 0)
-- Dependencies: 262
-- Name: delivery_charges_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.delivery_charges_id_seq OWNED BY public.delivery_charges.id;


--
-- TOC entry 223 (class 1259 OID 17061)
-- Name: failed_jobs; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.failed_jobs (
    id bigint NOT NULL,
    uuid character varying(255) NOT NULL,
    connection text NOT NULL,
    queue text NOT NULL,
    payload text NOT NULL,
    exception text NOT NULL,
    failed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.failed_jobs OWNER TO admin;

--
-- TOC entry 222 (class 1259 OID 17060)
-- Name: failed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.failed_jobs_id_seq OWNER TO admin;

--
-- TOC entry 5217 (class 0 OID 0)
-- Dependencies: 222
-- Name: failed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

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


--
-- TOC entry 241 (class 1259 OID 17184)
-- Name: gallery_images; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.gallery_images (
    id bigint NOT NULL,
    product_id bigint NOT NULL,
    image character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.gallery_images OWNER TO admin;

--
-- TOC entry 240 (class 1259 OID 17183)
-- Name: gallery_images_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.gallery_images_id_seq OWNER TO admin;

--
-- TOC entry 5218 (class 0 OID 0)
-- Dependencies: 240
-- Name: gallery_images_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.gallery_images_id_seq OWNED BY public.gallery_images.id;


--
-- TOC entry 267 (class 1259 OID 17369)
-- Name: gtms; Type: TABLE; Schema: public; Owner: admin
--

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


ALTER TABLE public.gtms OWNER TO admin;

--
-- TOC entry 266 (class 1259 OID 17368)
-- Name: gtms_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.gtms_id_seq OWNER TO admin;

--
-- TOC entry 5219 (class 0 OID 0)
-- Dependencies: 266
-- Name: gtms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.gtms_id_seq OWNED BY public.gtms.id;


--
-- TOC entry 255 (class 1259 OID 17310)
-- Name: messages; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.messages (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    email character varying(255) NOT NULL,
    phone character varying(255) NOT NULL,
    subject character varying(255) NOT NULL,
    message text NOT NULL,
    is_read boolean DEFAULT false NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.messages OWNER TO admin;

--
-- TOC entry 254 (class 1259 OID 17309)
-- Name: messages_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.messages_id_seq OWNER TO admin;

--
-- TOC entry 5220 (class 0 OID 0)
-- Dependencies: 254
-- Name: messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.messages_id_seq OWNED BY public.messages.id;


--
-- TOC entry 218 (class 1259 OID 17035)
-- Name: migrations; Type: TABLE; Schema: public; Owner: admin
--

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


ALTER TABLE public.migrations OWNER TO admin;

--
-- TOC entry 217 (class 1259 OID 17034)
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.migrations_id_seq OWNER TO admin;

--
-- TOC entry 5221 (class 0 OID 0)
-- Dependencies: 217
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

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


--
-- TOC entry 251 (class 1259 OID 17276)
-- Name: order_items; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.order_items (
    id bigint NOT NULL,
    order_id bigint NOT NULL,
    product_id bigint NOT NULL,
    variant_id bigint NOT NULL,
    quantity integer NOT NULL,
    price numeric(10,2) NOT NULL,
    subtotal numeric(10,2) NOT NULL,
    variant_color character varying(255),
    variant_size character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.order_items OWNER TO admin;

--
-- TOC entry 250 (class 1259 OID 17275)
-- Name: order_items_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.order_items_id_seq OWNER TO admin;

--
-- TOC entry 5222 (class 0 OID 0)
-- Dependencies: 250
-- Name: order_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.order_items_id_seq OWNED BY public.order_items.id;

--
-- TOC entry 248 (class 1259 OID 17257)
-- Name: orders_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.orders_id_seq OWNER TO admin;

--
-- TOC entry 5223 (class 0 OID 0)
-- Dependencies: 248
-- Name: orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

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

--
-- TOC entry 224 (class 1259 OID 17072)
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.personal_access_tokens_id_seq OWNER TO admin;

--
-- TOC entry 5224 (class 0 OID 0)
-- Dependencies: 224
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.personal_access_tokens_id_seq OWNED BY public.personal_access_tokens.id;


--
-- TOC entry 269 (class 1259 OID 17376)
-- Name: popups; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.popups (
    id bigint NOT NULL,
    image character varying(255) NOT NULL,
    link character varying(255),
    status boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.popups OWNER TO admin;

--
-- TOC entry 268 (class 1259 OID 17375)
-- Name: popups_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.popups_id_seq OWNER TO admin;

--
-- TOC entry 5225 (class 0 OID 0)
-- Dependencies: 268
-- Name: popups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.popups_id_seq OWNED BY public.popups.id;


--
-- TOC entry 243 (class 1259 OID 17196)
-- Name: product_varients; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.product_varients (
    id bigint NOT NULL,
    product_id bigint NOT NULL,
    color_id bigint NOT NULL,
    size_id bigint NOT NULL,
    stock_quantity integer DEFAULT 0 NOT NULL,
    variant_price numeric(10,2),
    sku character varying(255),
    status boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_varients OWNER TO admin;

--
-- TOC entry 242 (class 1259 OID 17195)
-- Name: product_varients_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.product_varients_id_seq OWNER TO admin;

--
-- TOC entry 5226 (class 0 OID 0)
-- Dependencies: 242
-- Name: product_varients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.product_varients_id_seq OWNED BY public.product_varients.id;


--
-- TOC entry 239 (class 1259 OID 17150)
-- Name: products; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.products (
    id bigint NOT NULL,
    product_name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    product_image character varying(255) NOT NULL,
    product_code character varying(255) NOT NULL,
    category_id bigint NOT NULL,
    subcategory_id bigint,
    brand_id bigint,
    unit_id bigint,
    discount_type character varying(255),
    discount_amount numeric(10,2),
    tags character varying(255),
    sale_price numeric(10,2),
    description text,
    status boolean DEFAULT true NOT NULL,
    featured boolean DEFAULT false NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT products_discount_type_check CHECK (((discount_type)::text = ANY ((ARRAY['fixed'::character varying, 'percentage'::character varying])::text[])))
);


ALTER TABLE public.products OWNER TO admin;

--
-- TOC entry 238 (class 1259 OID 17149)
-- Name: products_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.products_id_seq OWNER TO admin;

--
-- TOC entry 5227 (class 0 OID 0)
-- Dependencies: 238
-- Name: products_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.products_id_seq OWNED BY public.products.id;


--
-- TOC entry 257 (class 1259 OID 17320)
-- Name: secondery_banners; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.secondery_banners (
    id bigint NOT NULL,
    title character varying(255),
    image character varying(255) NOT NULL,
    link character varying(255),
    "position" integer DEFAULT 0 NOT NULL,
    status boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.secondery_banners OWNER TO admin;

--
-- TOC entry 256 (class 1259 OID 17319)
-- Name: secondery_banners_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.secondery_banners_id_seq OWNER TO admin;

--
-- TOC entry 5228 (class 0 OID 0)
-- Dependencies: 256
-- Name: secondery_banners_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.secondery_banners_id_seq OWNED BY public.secondery_banners.id;


--
-- TOC entry 261 (class 1259 OID 17342)
-- Name: site_settings; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.site_settings (
    id bigint NOT NULL,
    site_name character varying(255),
    logo character varying(255),
    favicon character varying(255),
    phone character varying(255),
    email character varying(255),
    address text,
    footer_description text,
    facebook_url character varying(255),
    instagram_url character varying(255),
    youtube_url character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.site_settings OWNER TO admin;

--
-- TOC entry 260 (class 1259 OID 17341)
-- Name: site_settings_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.site_settings_id_seq OWNER TO admin;

--
-- TOC entry 5229 (class 0 OID 0)
-- Dependencies: 260
-- Name: site_settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.site_settings_id_seq OWNED BY public.site_settings.id;


--
-- TOC entry 233 (class 1259 OID 17120)
-- Name: sizes; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.sizes (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    status smallint DEFAULT '0'::smallint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sizes OWNER TO admin;

--
-- TOC entry 232 (class 1259 OID 17119)
-- Name: sizes_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.sizes_id_seq OWNER TO admin;

--
-- TOC entry 5230 (class 0 OID 0)
-- Dependencies: 232
-- Name: sizes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.sizes_id_seq OWNED BY public.sizes.id;


--
-- TOC entry 259 (class 1259 OID 17331)
-- Name: sliders; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.sliders (
    id bigint NOT NULL,
    title character varying(255),
    subtitle character varying(255),
    image character varying(255) NOT NULL,
    link character varying(255),
    "order" integer DEFAULT 0 NOT NULL,
    status boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sliders OWNER TO admin;

--
-- TOC entry 258 (class 1259 OID 17330)
-- Name: sliders_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.sliders_id_seq OWNER TO admin;

--
-- TOC entry 5231 (class 0 OID 0)
-- Dependencies: 258
-- Name: sliders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.sliders_id_seq OWNED BY public.sliders.id;


--
-- TOC entry 253 (class 1259 OID 17300)
-- Name: special_banners; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.special_banners (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    description text NOT NULL,
    image character varying(255),
    status boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.special_banners OWNER TO admin;

--
-- TOC entry 252 (class 1259 OID 17299)
-- Name: special_banners_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.special_banners_id_seq OWNER TO admin;

--
-- TOC entry 5232 (class 0 OID 0)
-- Dependencies: 252
-- Name: special_banners_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.special_banners_id_seq OWNED BY public.special_banners.id;


--
-- TOC entry 229 (class 1259 OID 17095)
-- Name: subcategories; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.subcategories (
    id bigint NOT NULL,
    category_id bigint NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    icon character varying(255),
    status boolean DEFAULT false,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.subcategories OWNER TO admin;

--
-- TOC entry 228 (class 1259 OID 17094)
-- Name: subcategories_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.subcategories_id_seq OWNER TO admin;

--
-- TOC entry 5233 (class 0 OID 0)
-- Dependencies: 228
-- Name: subcategories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.subcategories_id_seq OWNED BY public.subcategories.id;


--
-- TOC entry 237 (class 1259 OID 17140)
-- Name: units; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.units (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    status smallint DEFAULT '0'::smallint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.units OWNER TO admin;

--
-- TOC entry 236 (class 1259 OID 17139)
-- Name: units_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.units_id_seq OWNER TO admin;

--
-- TOC entry 5234 (class 0 OID 0)
-- Dependencies: 236
-- Name: units_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.units_id_seq OWNED BY public.units.id;

--
-- TOC entry 219 (class 1259 OID 17041)
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.users_id_seq OWNER TO admin;

--
-- TOC entry 5235 (class 0 OID 0)
-- Dependencies: 219
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

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


--
-- TOC entry 265 (class 1259 OID 17359)
-- Name: videos; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.videos (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    subtitle text,
    thumbnail character varying(255),
    video_url character varying(255) NOT NULL,
    status boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.videos OWNER TO admin;

--
-- TOC entry 264 (class 1259 OID 17358)
-- Name: videos_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.videos_id_seq OWNER TO admin;

--
-- TOC entry 5236 (class 0 OID 0)
-- Dependencies: 264
-- Name: videos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.videos_id_seq OWNED BY public.videos.id;


--
-- TOC entry 245 (class 1259 OID 17224)
-- Name: wish_lists; Type: TABLE; Schema: public; Owner: admin
--

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


ALTER TABLE public.wish_lists OWNER TO admin;

--
-- TOC entry 244 (class 1259 OID 17223)
-- Name: wish_lists_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER SEQUENCE public.wish_lists_id_seq OWNER TO admin;

--
-- TOC entry 5237 (class 0 OID 0)
-- Dependencies: 244
-- Name: wish_lists_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.wish_lists_id_seq OWNED BY public.wish_lists.id;


--
-- TOC entry 4886 (class 2604 OID 17133)
-- Name: brands id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4898 (class 2604 OID 17244)
-- Name: carts id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4878 (class 2604 OID 17088)
-- Name: categories id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4882 (class 2604 OID 17113)
-- Name: colors id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4914 (class 2604 OID 17354)
-- Name: delivery_charges id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4875 (class 2604 OID 17064)
-- Name: failed_jobs id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4893 (class 2604 OID 17187)
-- Name: gallery_images id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4918 (class 2604 OID 17372)
-- Name: gtms id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4905 (class 2604 OID 17313)
-- Name: messages id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4872 (class 2604 OID 17038)
-- Name: migrations id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4902 (class 2604 OID 17279)
-- Name: order_items id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4919 (class 2604 OID 17379)
-- Name: popups id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4894 (class 2604 OID 17199)
-- Name: product_varients id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4890 (class 2604 OID 17153)
-- Name: products id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4907 (class 2604 OID 17323)
-- Name: secondery_banners id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4913 (class 2604 OID 17345)
-- Name: site_settings id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4884 (class 2604 OID 17123)
-- Name: sizes id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4910 (class 2604 OID 17334)
-- Name: sliders id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4903 (class 2604 OID 17303)
-- Name: special_banners id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4880 (class 2604 OID 17098)
-- Name: subcategories id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4888 (class 2604 OID 17143)
-- Name: units id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4916 (class 2604 OID 17362)
-- Name: videos id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4897 (class 2604 OID 17227)
-- Name: wish_lists id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- TOC entry 5171 (class 0 OID 17130)
-- Dependencies: 235
-- Data for Name: brands; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.brands (id, name, slug, status, created_at, updated_at) FROM stdin;
1	bata	bata	1	2025-08-02 01:36:16	2025-08-02 01:37:13
2	rin	rin	1	2025-08-02 01:36:22	2025-08-02 01:37:13
3	surf exel	surf-exel	1	2025-08-02 01:36:29	2025-08-02 01:37:14
4	dove	dove	1	2025-08-02 01:36:59	2025-08-02 01:37:15
5	clear	clear	1	2025-08-02 01:37:08	2025-08-02 01:37:16
\.


--
-- TOC entry 5183 (class 0 OID 17241)
-- Dependencies: 247
-- Data for Name: carts; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.carts (id, user_id, product_id, varient_id, quantity, price, created_at, updated_at) FROM stdin;
8	1	5	5	1	400.00	2025-08-09 20:27:47	2025-08-09 20:27:47
\.


--
-- TOC entry 5163 (class 0 OID 17085)
-- Dependencies: 227
-- Data for Name: categories; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.categories (id, name, slug, icon, status, created_at, updated_at) FROM stdin;
3	Clothing	clothing	category-thumbnail/1754755396.jpg	t	2025-08-02 00:42:17	2025-08-09 16:03:16
2	Accessories	accessories	category-thumbnail/1754095324.webp	t	2025-08-02 00:42:04	2025-08-09 16:03:31
1	Bags Collection	bags-collection	category-thumbnail/1754749821.jpg	t	2025-08-02 00:41:51	2025-08-10 21:15:36
5	Kidd's Collection	kidds-collection	category-thumbnail/1754825048.png	f	2025-08-10 11:24:09	2025-08-10 21:15:38
6	Cross Body Bag Collection	cross-body-bag-collection	category-thumbnail/1754860608.jpg	f	2025-08-10 21:16:48	2025-08-10 21:16:48
7	Round Bag Collection	round-bag-collection	category-thumbnail/1754860630.jpg	f	2025-08-10 21:17:10	2025-08-10 21:17:10
8	Hobo Bag Collection	hobo-bag-collection	category-thumbnail/1754860655.jpg	f	2025-08-10 21:17:35	2025-08-10 21:17:35
\.


--
-- TOC entry 5167 (class 0 OID 17110)
-- Dependencies: 231
-- Data for Name: colors; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.colors (id, name, slug, code, status, created_at, updated_at) FROM stdin;
1	Default	default	#f5f5f5	0	2025-08-02 20:05:34	2025-08-02 20:05:34
\.


--
-- TOC entry 5199 (class 0 OID 17351)
-- Dependencies: 263
-- Data for Name: delivery_charges; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.delivery_charges (id, location_type, charge, status, created_at, updated_at) FROM stdin;
\.


--
-- TOC entry 5159 (class 0 OID 17061)
-- Dependencies: 223
-- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin;
\.


--
-- TOC entry 5177 (class 0 OID 17184)
-- Dependencies: 241
-- Data for Name: gallery_images; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.gallery_images (id, product_id, image, created_at, updated_at) FROM stdin;
26	5	1754750442_68975dea7617e.jpg	2025-08-09 14:40:42	2025-08-09 14:40:42
27	4	1754750472_68975e08030d2.jpg	2025-08-09 14:41:12	2025-08-09 14:41:12
28	3	1754754966_68976f96f1daf.jpg	2025-08-09 15:56:06	2025-08-09 15:56:06
29	2	1754755021_68976fcd6508c.jpg	2025-08-09 15:57:01	2025-08-09 15:57:01
30	1	1754755069_68976ffd645c3.jpg	2025-08-09 15:57:49	2025-08-09 15:57:49
31	6	1754757128_689778085e0dd.jpg	2025-08-09 16:32:08	2025-08-09 16:32:08
34	9	1754757154_689778225fa3d.jpg	2025-08-09 16:32:34	2025-08-09 16:32:34
35	10	1754757159_68977827a4ae3.jpg	2025-08-09 16:32:39	2025-08-09 16:32:39
36	11	1754757166_6897782e7d904.jpg	2025-08-09 16:32:46	2025-08-09 16:32:46
37	8	1754758430_68977d1eef2b5.jpg	2025-08-09 16:53:50	2025-08-09 16:53:50
38	8	1754758473_68977d4934bf2.jpg	2025-08-09 16:54:33	2025-08-09 16:54:33
39	8	1754758473_68977d4935bb9.jpg	2025-08-09 16:54:33	2025-08-09 16:54:33
40	7	1754758646_68977df6632b8.jpg	2025-08-09 16:57:26	2025-08-09 16:57:26
41	7	1754758646_68977df664244.jpg	2025-08-09 16:57:26	2025-08-09 16:57:26
\.


--
-- TOC entry 5203 (class 0 OID 17369)
-- Dependencies: 267
-- Data for Name: gtms; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.gtms (id, gtm_code, created_at, updated_at) FROM stdin;
\.


--
-- TOC entry 5191 (class 0 OID 17310)
-- Dependencies: 255
-- Data for Name: messages; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.messages (id, name, email, phone, subject, message, is_read, created_at, updated_at) FROM stdin;
\.


--
-- TOC entry 5154 (class 0 OID 17035)
-- Dependencies: 218
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.migrations (id, migration, batch) FROM stdin;
1	2014_10_12_000000_create_users_table	1
2	2014_10_12_100000_create_password_reset_tokens_table	1
3	2019_08_19_000000_create_failed_jobs_table	1
4	2019_12_14_000001_create_personal_access_tokens_table	1
5	2024_12_23_041914_create_categories_table	1
6	2024_12_24_044217_create_subcategories_table	1
7	2024_12_24_080149_create_colors_table	1
8	2024_12_24_080204_create_sizes_table	1
9	2024_12_24_084056_create_brands_table	1
10	2024_12_24_084111_create_units_table	1
11	2024_12_26_094422_create_products_table	1
12	2024_12_26_094606_create_gallery_images_table	1
13	2024_12_28_081227_create_product__varients_table	1
14	2024_12_31_071424_create_wish_lists_table	1
15	2024_12_31_154703_create_carts_table	1
16	2025_01_04_064427_create_orders_table	1
17	2025_01_04_064610_create_order_items_table	1
18	2025_01_13_083558_create_special_banners_table	1
19	2025_01_13_094618_create_messages_table	1
20	2025_01_13_105524_create_secondery_banners_table	1
21	2025_01_13_123931_create_sliders_table	1
22	2025_01_14_085331_create_site_settings_table	1
23	2025_01_23_074456_create_delivery_charges_table	1
24	2025_02_23_044931_create_videos_table	1
25	2025_02_26_083957_create_gtms_table	1
26	2025_06_15_145847_create_popups_table	1
\.


--
-- TOC entry 5187 (class 0 OID 17276)
-- Dependencies: 251
-- Data for Name: order_items; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.order_items (id, order_id, product_id, variant_id, quantity, price, subtotal, variant_color, variant_size, created_at, updated_at) FROM stdin;
1	1	1	1	1	500.00	500.00	Default	standard	2025-08-02 20:16:06	2025-08-02 20:16:06
2	2	4	4	1	500.00	500.00	Default	standard	2025-08-06 10:18:01	2025-08-06 10:18:01
\.


--
-- TOC entry 5205 (class 0 OID 17376)
-- Dependencies: 269
-- Data for Name: popups; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.popups (id, image, link, status, created_at, updated_at) FROM stdin;
\.


--
-- TOC entry 5179 (class 0 OID 17196)
-- Dependencies: 243
-- Data for Name: product_varients; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.product_varients (id, product_id, color_id, size_id, stock_quantity, variant_price, sku, status, created_at, updated_at) FROM stdin;
2	2	1	1	49	0.00	P175417521111911-1-1	t	2025-08-02 22:53:31	2025-08-09 15:57:01
11	11	1	1	49	0.00	P175475716691217-1-1	t	2025-08-09 16:32:46	2025-08-09 16:42:12
8	8	1	1	49	0.00	P175475714179680-1-1	t	2025-08-09 16:32:21	2025-08-09 16:54:33
6	6	1	1	49	0.00	P175475712820713-1-1	t	2025-08-09 16:32:08	2025-08-09 17:14:33
10	10	1	2	48	0.00	P175475715998142-1-2	t	2025-08-09 16:32:39	2025-08-09 17:14:47
9	9	1	1	48	0.00	P175475715420330-1-1	t	2025-08-09 16:32:34	2025-08-09 17:15:04
7	7	1	1	49	0.00	P175475713272637-1-1	t	2025-08-09 16:32:12	2025-08-09 17:15:20
5	5	1	1	49	0.00	P175417522286220-1-1	t	2025-08-02 22:53:42	2025-08-09 17:16:20
4	4	1	1	48	0.00	P175417521794983-1-1	t	2025-08-02 22:53:37	2025-08-09 17:17:02
3	3	1	1	49	0.00	P175417521490130-1-1	t	2025-08-02 22:53:34	2025-08-09 17:17:45
1	1	1	1	49	0.00	P175416520236166-1-1	t	2025-08-02 20:06:42	2025-08-09 17:18:27
\.


--
-- TOC entry 5175 (class 0 OID 17150)
-- Dependencies: 239
-- Data for Name: products; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.products (id, product_name, slug, product_image, product_code, category_id, subcategory_id, brand_id, unit_id, discount_type, discount_amount, tags, sale_price, description, status, featured, created_at, updated_at) FROM stdin;
5	Handmade Colorful Leaf Print Round Crossbody Bag	ponds-sun-miracle-detan-face-wash-100g-copy	product_1754750442_68975dea73930.jpg	P175417522286220	1	1	4	1	\N	\N	\N	400.00	<table style="text-align: center;">\r\n<thead>\r\n<tr>\r\n<th><span style="background-color: rgb(255, 255, 0);">Feature</span></th>\r\n<th><span style="background-color: rgb(255, 255, 0);">Details</span></th>\r\n<th><span style="background-color: rgb(255, 255, 0);">Benefits</span></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td><strong>Design</strong></td>\r\n<td>Vibrant multicolor leaf pattern on a crisp white background</td>\r\n<td>Adds a playful, cheerful touch to any outfit</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Material</strong></td>\r\n<td>Durable woven fabric with faux leather trim and secure zipper closure</td>\r\n<td>Ensures long-lasting use while keeping your belongings safe</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Usage</strong></td>\r\n<td>Compact round shape with adjustable crossbody strap</td>\r\n<td>Perfect for carrying essentials hands-free in style</td>\r\n</tr>\r\n</tbody></table>	t	t	2025-08-02 22:53:42	2025-08-09 17:16:20
8	Canvas Duffel Bag with Blue Tribal Straps	ponds-sun-miracle-detan-face-wash-100g-copy-copy-copy-copy	product_1754758430_68977d1ee8298.jpg	P175475714179680	1	2	4	1	\N	\N	\N	650.00	<table style="text-align: center;">\r\n<thead>\r\n<tr>\r\n<th><span style="background-color: rgb(255, 255, 0);">Feature</span></th>\r\n<th><span style="background-color: rgb(255, 255, 0);">Details</span></th>\r\n<th><span style="background-color: rgb(255, 255, 0);">Benefits</span></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td><strong>Design</strong></td>\r\n<td>Minimalist cream canvas body with bold blue geometric woven straps</td>\r\n<td>Combines modern simplicity with cultural craftsmanship</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Material</strong></td>\r\n<td>Sturdy canvas fabric with handwoven cotton strap details</td>\r\n<td>Ensures durability and long-lasting performance</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Usage</strong></td>\r\n<td>Spacious interior perfect for travel, gym, or weekend trips</td>\r\n<td>Offers ample storage while being easy to carry</td>\r\n</tr>\r\n</tbody></table>	t	t	2025-08-09 16:32:21	2025-08-09 16:53:50
4	Handmade Colorful Leaf Print Round Crossbody Bag	ponds-sun-miracle-detan-face-wash-100g-copy	product_1754750471_68975e07f33da.jpg	P175417521794983	1	1	4	1	\N	\N	\N	500.00	<table style="text-align: center;"><thead><tr><th><span style="background-color: rgb(255, 255, 0);">Feature</span></th><th><span style="background-color: rgb(255, 255, 0);">Details</span></th><th><span style="background-color: rgb(255, 255, 0);">Benefits</span></th></tr></thead><tbody><tr><td><span style="font-weight: bolder;">Design</span></td><td>Vibrant multicolor leaf pattern on a crisp white background</td><td>Adds a playful, cheerful touch to any outfit</td></tr><tr><td><span style="font-weight: bolder;">Material</span></td><td>Durable woven fabric with faux leather trim and secure zipper closure</td><td>Ensures long-lasting use while keeping your belongings safe</td></tr><tr><td><span style="font-weight: bolder;">Usage</span></td><td>Compact round shape with adjustable crossbody strap</td><td>Perfect for carrying essentials hands-free in style</td></tr></tbody></table>	t	t	2025-08-02 22:53:37	2025-08-09 17:17:02
9	Handcrafted Red Pattern Jute Crossbody Bag with Accent Patch	ponds-sun-miracle-detan-face-wash-100g-copy-copy	product_1754758239_68977c5f3eef3.jpg	P175475715420330	1	1	4	1	\N	\N	\N	850.00	<table style="text-align: center;">\r\n<thead>\r\n<tr>\r\n<th><span style="background-color: rgb(255, 255, 0);">Feature</span></th>\r\n<th><span style="background-color: rgb(255, 255, 0);">Details</span></th>\r\n<th><span style="background-color: rgb(255, 255, 0);">Benefits</span></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td><strong>Design</strong></td>\r\n<td>Bold red and beige pattern with a central square accent patch</td>\r\n<td>Creates a striking and artistic look for any outfit</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Material</strong></td>\r\n<td>Durable jute fabric with colorful cotton appliqué and braided strap</td>\r\n<td>Long-lasting, eco-friendly, and comfortable to carry</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Usage</strong></td>\r\n<td>Compact zip-closure design for secure storage and easy crossbody wear</td>\r\n<td>Keeps essentials safe while offering hands-free convenience</td>\r\n</tr>\r\n</tbody></table>	t	t	2025-08-09 16:32:34	2025-08-09 17:15:04
1	Handmade Colorful Leaf Print Round Crossbody Bag	ponds-sun-miracle-detan-face-wash-100g	product_1754755069_68976ffd60407.jpg	P175416520236166	1	1	4	1	\N	\N	\N	500.00	<table style="text-align: center;"><thead><tr><th><span style="background-color: rgb(255, 255, 0);">Feature</span></th><th><span style="background-color: rgb(255, 255, 0);">Details</span></th><th><span style="background-color: rgb(255, 255, 0);">Benefits</span></th></tr></thead><tbody><tr><td><span style="font-weight: bolder;">Design</span></td><td>Vibrant multicolor leaf pattern on a crisp white background</td><td>Adds a playful, cheerful touch to any outfit</td></tr><tr><td><span style="font-weight: bolder;">Material</span></td><td>Durable woven fabric with faux leather trim and secure zipper closure</td><td>Ensures long-lasting use while keeping your belongings safe</td></tr><tr><td><span style="font-weight: bolder;">Usage</span></td><td>Compact round shape with adjustable crossbody strap</td><td>Perfect for carrying essentials hands-free in style</td></tr></tbody></table>	t	f	2025-08-02 20:06:42	2025-08-09 17:18:27
2	Pond's Sun Miracle Detan Face Wash 100g (Copy)	ponds-sun-miracle-detan-face-wash-100g-copy	product_1754755021_68976fcd62b6e.jpg	P175417521111911	2	8	4	1	\N	\N	\N	500.00	<p>thgryhnfgh</p>	t	f	2025-08-02 22:53:31	2025-08-09 15:57:01
11	Handcrafted Traditional Woven Crossbody Bag with Fringe	ponds-sun-miracle-detan-face-wash-100g-copy	1754757166_6897782e78f62.jpg	P175475716691217	1	1	4	1	\N	\N	\N	850.00	<p><b style="background-color: rgb(255, 255, 0);"><br></b></p><table class="table table-bordered"><tbody><tr><td style="text-align: center; "><b style="background-color: rgb(255, 255, 0);">Feature</b></td><td style="text-align: center; "><b style="background-color: rgb(255, 255, 0);">Details</b></td><td style="text-align: center; "><b style="background-color: rgb(255, 255, 0);">Benefits</b></td></tr><tr><td>Design</td><td>Inspired by traditional weaving patterns with intricate rope detailing</td><td>Adds cultural charm and uniqueness to your style</td></tr><tr><td>Material</td><td>Made from durable woven fabric with soft cotton fringe trim</td><td>Ensures long-lasting use while maintaining comfort</td></tr><tr><td>Usage</td><td>Lightweight crossbody strap for easy daily carry</td><td>Keeps hands free and offers convenience for everyday activities</td></tr></tbody></table><p><br></p>	t	t	2025-08-09 16:32:46	2025-08-09 16:42:12
7	Handmade Two-Tone Hobo Bag with Tribal Print Accents	ponds-sun-miracle-detan-face-wash-100g-copy-copy-copy	product_1754758646_68977df66128d.jpg	P175475713272637	1	3	4	1	\N	\N	\N	650.00	<table style="text-align: center;">\r\n<thead>\r\n<tr>\r\n<th><span style="background-color: rgb(255, 255, 0);">Feature</span></th>\r\n<th><span style="background-color: rgb(255, 255, 0);">Details</span></th>\r\n<th><span style="background-color: rgb(255, 255, 0);">Benefits</span></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td><strong>Design</strong></td>\r\n<td>Elegant two-tone style with black tribal patterned fabric and button closure</td>\r\n<td>Adds a touch of cultural sophistication to your everyday look</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Material</strong></td>\r\n<td>Soft cotton blend body with durable printed fabric panels</td>\r\n<td>Lightweight yet sturdy for long-term use</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Usage</strong></td>\r\n<td>Spacious hobo style for daily essentials or casual outings</td>\r\n<td>Offers comfort, style, and practicality in one versatile bag</td>\r\n</tr>\r\n</tbody></table>	t	t	2025-08-09 16:32:12	2025-08-09 17:15:20
6	Handmade Colorful Leaf Print Round Crossbody Bag	ponds-sun-miracle-detan-face-wash-100g-copy-copy	product_1754759633_689781d177c1f.jpg	P175475712820713	1	15	4	1	\N	\N	\N	400.00	<table style="text-align: center;">\r\n<thead>\r\n<tr>\r\n<th><span style="background-color: rgb(255, 255, 0);">Feature</span></th>\r\n<th><span style="background-color: rgb(255, 255, 0);">Details</span></th>\r\n<th><span style="background-color: rgb(255, 255, 0);">Benefits</span></th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td><strong>Design</strong></td>\r\n<td>Vibrant multicolor leaf pattern on a crisp white background</td>\r\n<td>Adds a playful, cheerful touch to any outfit</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Material</strong></td>\r\n<td>Durable woven fabric with faux leather trim and secure zipper closure</td>\r\n<td>Ensures long-lasting use while keeping your belongings safe</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Usage</strong></td>\r\n<td>Compact round shape with adjustable crossbody strap</td>\r\n<td>Perfect for carrying essentials hands-free in style</td>\r\n</tr>\r\n</tbody></table>	t	t	2025-08-09 16:32:08	2025-08-09 17:14:33
10	Handmade Natural Jute Crossbody Bag with Tribal Accents	ponds-sun-miracle-detan-face-wash-100g-copy-copy	product_1754758107_68977bdb39755.jpg	P175475715998142	1	1	4	1	\N	\N	\N	850.00	<table>\r\n<thead>\r\n<tr>\r\n<th>Feature</th>\r\n<th style="text-align: center; "><p>Details<span style="color: rgb(33, 37, 41); font-family: "Source Sans Pro", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 700; letter-spacing: normal; orphans: 2; text-align: center; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">Details</span></p></th>\r\n<th style="text-align: center; ">Benefits</th>\r\n</tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td><strong>Design</strong></td>\r\n<td>Decorated with vibrant tribal-inspired geometric patterns</td>\r\n<td>Adds a bold, cultural, and eye-catching touch to your outfit</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Material</strong></td>\r\n<td>Crafted from eco-friendly natural jute with colorful fabric appliqué</td>\r\n<td>Durable, sustainable, and perfect for environmentally conscious users</td>\r\n</tr>\r\n<tr>\r\n<td><strong>Usage</strong></td>\r\n<td>Lightweight with braided strap for easy shoulder or crossbody wear</td>\r\n<td>Provides comfort and style for daily use or special occasions</td>\r\n</tr>\r\n</tbody></table>	t	t	2025-08-09 16:32:39	2025-08-09 17:14:47
3	Handmade Colorful Leaf Print Round Crossbody Bag	ponds-sun-miracle-detan-face-wash-100g-copy	product_1754754966_68976f96ef06e.jpg	P175417521490130	1	1	4	1	\N	\N	\N	500.00	<table style="text-align: center;"><thead><tr><th><span style="background-color: rgb(255, 255, 0);">Feature</span></th><th><span style="background-color: rgb(255, 255, 0);">Details</span></th><th><span style="background-color: rgb(255, 255, 0);">Benefits</span></th></tr></thead><tbody><tr><td><span style="font-weight: bolder;">Design</span></td><td>Vibrant multicolor leaf pattern on a crisp white background</td><td>Adds a playful, cheerful touch to any outfit</td></tr><tr><td><span style="font-weight: bolder;">Material</span></td><td>Durable woven fabric with faux leather trim and secure zipper closure</td><td>Ensures long-lasting use while keeping your belongings safe</td></tr><tr><td><span style="font-weight: bolder;">Usage</span></td><td>Compact round shape with adjustable crossbody strap</td><td>Perfect for carrying essentials hands-free in style</td></tr></tbody></table>	t	f	2025-08-02 22:53:34	2025-08-09 17:17:45
\.


--
-- TOC entry 5193 (class 0 OID 17320)
-- Dependencies: 257
-- Data for Name: secondery_banners; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.secondery_banners (id, title, image, link, "position", status, created_at, updated_at) FROM stdin;
\.


--
-- TOC entry 5197 (class 0 OID 17342)
-- Dependencies: 261
-- Data for Name: site_settings; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.site_settings (id, site_name, logo, favicon, phone, email, address, footer_description, facebook_url, instagram_url, youtube_url, created_at, updated_at) FROM stdin;
1	Chileghuri	settings/logo_1754726112.png	settings/favicon_1754099183.png	01768261277	chileghuri@gmail.com	gazipur road	\N	https://mzamin.com/	https://mzamin.com/	https://mzamin.com/	2025-08-02 01:46:24	2025-08-09 07:55:12
\.


--
-- TOC entry 5169 (class 0 OID 17120)
-- Dependencies: 233
-- Data for Name: sizes; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.sizes (id, name, slug, status, created_at, updated_at) FROM stdin;
1	standard	standard	1	2025-08-02 19:51:39	2025-08-02 19:51:53
2	large	large	1	2025-08-02 19:51:44	2025-08-02 19:51:55
3	small	small	1	2025-08-02 19:51:49	2025-08-02 19:51:56
\.


--
-- TOC entry 5195 (class 0 OID 17331)
-- Dependencies: 259
-- Data for Name: sliders; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.sliders (id, title, subtitle, image, link, "order", status, created_at, updated_at) FROM stdin;
1	khj	ityrter	1754095510_688d5f96dbb46.webp	http://127.0.0.1:8000/	0	t	2025-08-02 00:45:10	2025-08-02 00:45:10
2	\N	\N	1754095656_688d60289ddae.webp	\N	1	t	2025-08-02 00:47:36	2025-08-02 00:47:36
\.


--
-- TOC entry 5189 (class 0 OID 17300)
-- Dependencies: 253
-- Data for Name: special_banners; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.special_banners (id, title, description, image, status, created_at, updated_at) FROM stdin;
\.


--
-- TOC entry 5165 (class 0 OID 17095)
-- Dependencies: 229
-- Data for Name: subcategories; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.subcategories (id, category_id, name, slug, icon, status, created_at, updated_at) FROM stdin;
4	3	Kidd's	kidds	subcategory-thumbnail/1754161736.webp	t	2025-08-02 19:08:57	2025-08-02 19:10:28
5	3	Show pieces	show-pieces	subcategory-thumbnail/1754161752.webp	t	2025-08-02 19:09:12	2025-08-02 19:10:30
6	3	Stickers	stickers	subcategory-thumbnail/1754161777.webp	t	2025-08-02 19:09:37	2025-08-02 19:10:34
7	3	Tools	tools	subcategory-thumbnail/1754161815.webp	t	2025-08-02 19:10:15	2025-08-02 19:10:34
8	2	Hair Care	hair-care	subcategory-thumbnail/1754162012.webp	t	2025-08-02 19:13:32	2025-08-02 19:18:22
9	2	Skin Care	skin-care	subcategory-thumbnail/1754162024.webp	t	2025-08-02 19:13:44	2025-08-02 19:18:23
10	2	Dresses	dresses	subcategory-thumbnail/1754162040.webp	t	2025-08-02 19:14:00	2025-08-02 19:18:24
11	2	Vanity bag	vanity-bag	subcategory-thumbnail/1754162062.webp	t	2025-08-02 19:14:22	2025-08-02 19:33:22
12	2	Hand Bag	hand-bag	subcategory-thumbnail/1754162076.webp	t	2025-08-02 19:14:36	2025-08-02 19:33:24
13	2	Jwellery	jwellery	subcategory-thumbnail/1754162091.webp	t	2025-08-02 19:14:51	2025-08-02 19:33:26
14	1	Backpack	backpack	subcategory-thumbnail/1754162498.webp	t	2025-08-02 19:21:38	2025-08-02 19:33:27
1	1	Cross Body Bag	cross-body-bag	subcategory_images/1754749876.jpg	t	2025-08-02 01:40:07	2025-08-09 14:31:16
2	1	Duffel Bag	duffel-bag	subcategory_images/1754749991.jpg	t	2025-08-02 01:40:25	2025-08-09 14:33:11
3	1	Hobo Bag	hobo-bag	subcategory_images/1754750037.jpg	t	2025-08-02 01:40:47	2025-08-09 14:33:57
15	1	Round Bag	round-bag	subcategory-thumbnail/1754750145.jpg	t	2025-08-09 14:35:45	2025-08-09 14:37:57
16	1	Travel Bag	travel-bag	subcategory-thumbnail/1754750218.jpg	t	2025-08-09 14:36:58	2025-08-09 14:37:58
17	1	Wallet	wallet	subcategory-thumbnail/1754750246.jpg	t	2025-08-09 14:37:26	2025-08-09 14:38:00
18	1	Backpack	backpack	subcategory-thumbnail/1754750266.jpg	t	2025-08-09 14:37:46	2025-08-09 14:38:01
19	3	Women Silk Saree Collection	women-silk-saree-collection	subcategory-thumbnail/1754755509.jpg	t	2025-08-09 16:05:09	2025-08-09 16:14:27
20	3	Women Moslin Saree Collection	women-moslin-saree-collection	subcategory-thumbnail/1754755532.jpg	t	2025-08-09 16:05:32	2025-08-09 16:14:27
21	3	Hand Embroidary Saree(Half Silk)	hand-embroidary-sareehalf-silk	subcategory-thumbnail/1754755617.jpg	t	2025-08-09 16:06:57	2025-08-09 16:14:31
22	3	Hand Embroidary Saree(Cotton)	hand-embroidary-sareecotton	subcategory-thumbnail/1754755638.jpg	t	2025-08-09 16:07:18	2025-08-09 16:14:32
23	3	Womens Kurti	womens-kurti	subcategory-thumbnail/1754755720.jpg	t	2025-08-09 16:08:40	2025-08-09 16:14:32
24	3	Womens Frock	womens-frock	subcategory-thumbnail/1754755740.jpg	t	2025-08-09 16:09:00	2025-08-09 16:14:33
25	3	Tops	tops	subcategory-thumbnail/1754755789.jpg	t	2025-08-09 16:09:49	2025-08-09 16:14:34
26	3	Kaftan	kaftan	subcategory-thumbnail/1754755803.jpg	t	2025-08-09 16:10:03	2025-08-09 16:14:40
28	3	Poncho	poncho	subcategory-thumbnail/1754755842.jpg	t	2025-08-09 16:10:42	2025-08-09 16:14:41
29	3	Blouse	blouse	subcategory-thumbnail/1754755857.jpg	t	2025-08-09 16:10:57	2025-08-09 16:14:42
\.


--
-- TOC entry 5173 (class 0 OID 17140)
-- Dependencies: 237
-- Data for Name: units; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.units (id, name, slug, status, created_at, updated_at) FROM stdin;
1	piece	piece	1	2025-08-02 19:52:16	2025-08-02 19:52:35
2	ml	ml	1	2025-08-02 19:52:25	2025-08-02 19:52:35
3	kg	kg	1	2025-08-02 19:52:29	2025-08-02 19:52:36
\.


--
-- TOC entry 5201 (class 0 OID 17359)
-- Dependencies: 265
-- Data for Name: videos; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.videos (id, title, subtitle, thumbnail, video_url, status, created_at, updated_at) FROM stdin;
\.


--
-- TOC entry 5181 (class 0 OID 17224)
-- Dependencies: 245
-- Data for Name: wish_lists; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.wish_lists (id, user_id, product_id, created_at, updated_at) FROM stdin;
\.



--
-- TOC entry 4948 (class 2606 OID 17138)
-- Name: brands brands_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.brands
    ADD CONSTRAINT brands_pkey PRIMARY KEY (id);


--
-- TOC entry 4966 (class 2606 OID 17246)
-- Name: carts carts_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.carts
    ADD CONSTRAINT carts_pkey PRIMARY KEY (id);


--
-- TOC entry 4940 (class 2606 OID 17093)
-- Name: categories categories_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_pkey PRIMARY KEY (id);


--
-- TOC entry 4944 (class 2606 OID 17118)
-- Name: colors colors_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.colors
    ADD CONSTRAINT colors_pkey PRIMARY KEY (id);


--
-- TOC entry 4984 (class 2606 OID 17357)
-- Name: delivery_charges delivery_charges_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.delivery_charges
    ADD CONSTRAINT delivery_charges_pkey PRIMARY KEY (id);


--
-- TOC entry 4931 (class 2606 OID 17069)
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);


--
-- TOC entry 4933 (class 2606 OID 17071)
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4956 (class 2606 OID 17189)
-- Name: gallery_images gallery_images_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.gallery_images
    ADD CONSTRAINT gallery_images_pkey PRIMARY KEY (id);


--
-- TOC entry 4988 (class 2606 OID 17374)
-- Name: gtms gtms_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.gtms
    ADD CONSTRAINT gtms_pkey PRIMARY KEY (id);


--
-- TOC entry 4976 (class 2606 OID 17318)
-- Name: messages messages_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_pkey PRIMARY KEY (id);


--
-- TOC entry 4923 (class 2606 OID 17040)
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

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


--
-- TOC entry 4972 (class 2606 OID 17283)
-- Name: order_items order_items_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_pkey PRIMARY KEY (id);


--
-- TOC entry 4990 (class 2606 OID 17384)
-- Name: popups popups_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.popups
    ADD CONSTRAINT popups_pkey PRIMARY KEY (id);


--
-- TOC entry 4958 (class 2606 OID 17203)
-- Name: product_varients product_varients_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.product_varients
    ADD CONSTRAINT product_varients_pkey PRIMARY KEY (id);


--
-- TOC entry 4960 (class 2606 OID 17222)
-- Name: product_varients product_varients_sku_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.product_varients
    ADD CONSTRAINT product_varients_sku_unique UNIQUE (sku);


--
-- TOC entry 4952 (class 2606 OID 17160)
-- Name: products products_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_pkey PRIMARY KEY (id);


--
-- TOC entry 4954 (class 2606 OID 17182)
-- Name: products products_product_code_unique; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_product_code_unique UNIQUE (product_code);


--
-- TOC entry 4978 (class 2606 OID 17329)
-- Name: secondery_banners secondery_banners_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.secondery_banners
    ADD CONSTRAINT secondery_banners_pkey PRIMARY KEY (id);


--
-- TOC entry 4982 (class 2606 OID 17349)
-- Name: site_settings site_settings_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.site_settings
    ADD CONSTRAINT site_settings_pkey PRIMARY KEY (id);


--
-- TOC entry 4946 (class 2606 OID 17128)
-- Name: sizes sizes_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.sizes
    ADD CONSTRAINT sizes_pkey PRIMARY KEY (id);


--
-- TOC entry 4980 (class 2606 OID 17340)
-- Name: sliders sliders_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.sliders
    ADD CONSTRAINT sliders_pkey PRIMARY KEY (id);


--
-- TOC entry 4974 (class 2606 OID 17308)
-- Name: special_banners special_banners_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.special_banners
    ADD CONSTRAINT special_banners_pkey PRIMARY KEY (id);


--
-- TOC entry 4942 (class 2606 OID 17103)
-- Name: subcategories subcategories_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.subcategories
    ADD CONSTRAINT subcategories_pkey PRIMARY KEY (id);


--
-- TOC entry 4962 (class 2606 OID 17220)
-- Name: product_varients unique_variant_combination; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.product_varients
    ADD CONSTRAINT unique_variant_combination UNIQUE (product_id, color_id, size_id);


--
-- TOC entry 4950 (class 2606 OID 17148)
-- Name: units units_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.units
    ADD CONSTRAINT units_pkey PRIMARY KEY (id);


--
-- TOC entry 4986 (class 2606 OID 17367)
-- Name: videos videos_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.videos
    ADD CONSTRAINT videos_pkey PRIMARY KEY (id);


--
-- TOC entry 4964 (class 2606 OID 17229)
-- Name: wish_lists wish_lists_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.wish_lists
    ADD CONSTRAINT wish_lists_pkey PRIMARY KEY (id);


--
-- TOC entry 5002 (class 2606 OID 17247)
-- Name: carts carts_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.carts
    ADD CONSTRAINT carts_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- TOC entry 5003 (class 2606 OID 17252)
-- Name: carts carts_varient_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.carts
    ADD CONSTRAINT carts_varient_id_foreign FOREIGN KEY (varient_id) REFERENCES public.product_varients(id) ON DELETE CASCADE;


--
-- TOC entry 4996 (class 2606 OID 17190)
-- Name: gallery_images gallery_images_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.gallery_images
    ADD CONSTRAINT gallery_images_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- TOC entry 5005 (class 2606 OID 17284)
-- Name: order_items order_items_order_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.orders(id) ON DELETE CASCADE;


--
-- TOC entry 5006 (class 2606 OID 17289)
-- Name: order_items order_items_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- TOC entry 5007 (class 2606 OID 17294)
-- Name: order_items order_items_variant_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_variant_id_foreign FOREIGN KEY (variant_id) REFERENCES public.product_varients(id) ON DELETE CASCADE;


--
-- TOC entry 4997 (class 2606 OID 17209)
-- Name: product_varients product_varients_color_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.product_varients
    ADD CONSTRAINT product_varients_color_id_foreign FOREIGN KEY (color_id) REFERENCES public.colors(id) ON DELETE CASCADE;


--
-- TOC entry 4998 (class 2606 OID 17204)
-- Name: product_varients product_varients_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.product_varients
    ADD CONSTRAINT product_varients_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- TOC entry 4999 (class 2606 OID 17214)
-- Name: product_varients product_varients_size_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.product_varients
    ADD CONSTRAINT product_varients_size_id_foreign FOREIGN KEY (size_id) REFERENCES public.sizes(id) ON DELETE CASCADE;


--
-- TOC entry 4992 (class 2606 OID 17171)
-- Name: products products_brand_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_brand_id_foreign FOREIGN KEY (brand_id) REFERENCES public.brands(id) ON DELETE SET NULL;


--
-- TOC entry 4993 (class 2606 OID 17161)
-- Name: products products_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_category_id_foreign FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE CASCADE;


--
-- TOC entry 4994 (class 2606 OID 17166)
-- Name: products products_subcategory_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_subcategory_id_foreign FOREIGN KEY (subcategory_id) REFERENCES public.subcategories(id) ON DELETE CASCADE;


--
-- TOC entry 4995 (class 2606 OID 17176)
-- Name: products products_unit_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_unit_id_foreign FOREIGN KEY (unit_id) REFERENCES public.units(id) ON DELETE SET NULL;


--
-- TOC entry 4991 (class 2606 OID 17104)
-- Name: subcategories subcategories_category_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.subcategories
    ADD CONSTRAINT subcategories_category_id_foreign FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE CASCADE;


--
-- TOC entry 5000 (class 2606 OID 17235)
-- Name: wish_lists wish_lists_product_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.wish_lists
    ADD CONSTRAINT wish_lists_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;


--
-- TOC entry 5001 (class 2606 OID 17230)
-- Name: wish_lists wish_lists_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

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


--
-- TOC entry 5211 (class 0 OID 0)
-- Dependencies: 5
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: pg_database_owner
--

GRANT ALL ON SCHEMA public TO admin;


--
-- TOC entry 2173 (class 826 OID 17033)
-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: public; Owner: postgres
--

ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT ALL ON TABLES TO admin;


-- Completed on 2025-08-12 02:13:30

--
--

