PGDMP  .             
        ~            panaderiapasteleria_db    17.2    18.1               0    0    ENCODING    ENCODING        SET client_encoding = 'UTF8';
                           false                       0    0 
   STDSTRINGS 
   STDSTRINGS     (   SET standard_conforming_strings = 'on';
                           false                       0    0 
   SEARCHPATH 
   SEARCHPATH     8   SELECT pg_catalog.set_config('search_path', '', false);
                           false                       1262    32774    panaderiapasteleria_db    DATABASE        CREATE DATABASE panaderiapasteleria_db WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'Spanish_Peru.1252';
 &   DROP DATABASE panaderiapasteleria_db;
                     postgres    false                        1259    32775    cache    TABLE        CREATE TABLE public.cache (
    key character varying(255) NOT NULL,
    value text NOT NULL,
    expiration integer NOT NULL
);
    DROP TABLE public.cache;
       public         heap r       postgres    false                        1259    32780    cache_locks    TABLE        CREATE TABLE public.cache_locks (
    key character varying(255) NOT NULL,
    owner character varying(255) NOT NULL,
    expiration integer NOT NULL
);
    DROP TABLE public.cache_locks;
       public         heap r       postgres    false                        1259    32785    cash_movements    TABLE       CREATE TABLE public.cash_movements (
    id bigint NOT NULL,
    cash_register_id bigint NOT NULL,
    type character varying(255) NOT NULL,
    amount numeric(10,2) NOT NULL,
    description character varying(255) NOT NULL,
    reference_id character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT cash_movements_type_check CHECK (((type)::text = ANY (ARRAY[('in'::character varying)::text, ('out'::character varying)::text])))
);
 "   DROP TABLE public.cash_movements;
       public         heap r       postgres    false                        1259    32791    cash_movements_id_seq    SEQUENCE     ~   CREATE SEQUENCE public.cash_movements_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 ,   DROP SEQUENCE public.cash_movements_id_seq;
       public               postgres    false    219                       0    0    cash_movements_id_seq    SEQUENCE OWNED BY     O   ALTER SEQUENCE public.cash_movements_id_seq OWNED BY public.cash_movements.id;
          public               postgres    false    220                        1259    32792    cash_registers    TABLE       CREATE TABLE public.cash_registers (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    status character varying(255) DEFAULT 'open'::character varying NOT NULL,
    opening_amount numeric(10,2) NOT NULL,
    closing_amount numeric(10,2),
    opening_time timestamp(0) without time zone NOT NULL,
    closing_time timestamp(0) without time zone,
    notes text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 "   DROP TABLE public.cash_registers;
       public         heap r       postgres    false                        1259    32798    cash_registers_id_seq    SEQUENCE     ~   CREATE SEQUENCE public.cash_registers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 ,   DROP SEQUENCE public.cash_registers_id_seq;
       public               postgres    false    221                       0    0    cash_registers_id_seq    SEQUENCE OWNED BY     O   ALTER SEQUENCE public.cash_registers_id_seq OWNED BY public.cash_registers.id;
          public               postgres    false    222                        1259    32799 
   categories    TABLE     e  CREATE TABLE public.categories (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    parent_id bigint,
    image character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    description text,
    status boolean DEFAULT true NOT NULL
);
    DROP TABLE public.categories;
       public         heap r       postgres    false                        1259    32805    categories_id_seq    SEQUENCE     z   CREATE SEQUENCE public.categories_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 (   DROP SEQUENCE public.categories_id_seq;
       public               postgres    false    223                       0    0    categories_id_seq    SEQUENCE OWNED BY     G   ALTER SEQUENCE public.categories_id_seq OWNED BY public.categories.id;
          public               postgres    false    224                        1259    32806 	   customers    TABLE       CREATE TABLE public.customers (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    email character varying(255),
    phone character varying(255),
    address character varying(255),
    tax_id character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    status boolean DEFAULT true NOT NULL,
    birthday date,
    loyalty_points integer DEFAULT 0 NOT NULL,
    notes text
);
    DROP TABLE public.customers;
       public         heap r       postgres    false                        1259    32813    customers_id_seq    SEQUENCE     y   CREATE SEQUENCE public.customers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 '   DROP SEQUENCE public.customers_id_seq;
       public               postgres    false    225                       0    0    customers_id_seq    SEQUENCE OWNED BY     E   ALTER SEQUENCE public.customers_id_seq OWNED BY public.customers.id;
          public               postgres    false    226                        1259    32814    failed_jobs    TABLE     &  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
);
    DROP TABLE public.failed_jobs;
       public         heap r       postgres    false                        1259    32820    failed_jobs_id_seq    SEQUENCE     {   CREATE SEQUENCE public.failed_jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 )   DROP SEQUENCE public.failed_jobs_id_seq;
       public               postgres    false    227                       0    0    failed_jobs_id_seq    SEQUENCE OWNED BY     I   ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id;
          public               postgres    false    228                        1259    32821    inventory_movements    TABLE       CREATE TABLE public.inventory_movements (
    id bigint NOT NULL,
    supply_id bigint,
    warehouse_id bigint,
    type character varying(255) NOT NULL,
    quantity numeric(10,4) NOT NULL,
    reference_id bigint,
    notes character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    product_variant_id bigint,
    description character varying(255),
    user_id bigint
);
 '   DROP TABLE public.inventory_movements;
       public         heap r       postgres    false                        1259    32826    inventory_movements_id_seq    SEQUENCE        CREATE SEQUENCE public.inventory_movements_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 1   DROP SEQUENCE public.inventory_movements_id_seq;
       public               postgres    false    229                       0    0    inventory_movements_id_seq    SEQUENCE OWNED BY     Y   ALTER SEQUENCE public.inventory_movements_id_seq OWNED BY public.inventory_movements.id;
          public               postgres    false    230                        1259    32827    job_batches    TABLE     d  CREATE TABLE public.job_batches (
    id character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    total_jobs integer NOT NULL,
    pending_jobs integer NOT NULL,
    failed_jobs integer NOT NULL,
    failed_job_ids text NOT NULL,
    options text,
    cancelled_at integer,
    created_at integer NOT NULL,
    finished_at integer
);
    DROP TABLE public.job_batches;
       public         heap r       postgres    false                        1259    32832    jobs    TABLE        CREATE TABLE public.jobs (
    id bigint NOT NULL,
    queue character varying(255) NOT NULL,
    payload text NOT NULL,
    attempts smallint NOT NULL,
    reserved_at integer,
    available_at integer NOT NULL,
    created_at integer NOT NULL
);
    DROP TABLE public.jobs;
       public         heap r       postgres    false                        1259    32837    jobs_id_seq    SEQUENCE     t   CREATE SEQUENCE public.jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 "   DROP SEQUENCE public.jobs_id_seq;
       public               postgres    false    232                       0    0    jobs_id_seq    SEQUENCE OWNED BY     ;   ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;
          public               postgres    false    233                        1259    32838 
   migrations    TABLE        CREATE TABLE public.migrations (
    id integer NOT NULL,
    migration character varying(255) NOT NULL,
    batch integer NOT NULL
);
    DROP TABLE public.migrations;
       public         heap r       postgres    false                        1259    32841    migrations_id_seq    SEQUENCE        CREATE SEQUENCE public.migrations_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 (   DROP SEQUENCE public.migrations_id_seq;
       public               postgres    false    234                       0    0    migrations_id_seq    SEQUENCE OWNED BY     G   ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id;
          public               postgres    false    235                        1259    32842    model_has_permissions    TABLE        CREATE TABLE public.model_has_permissions (
    permission_id bigint NOT NULL,
    model_type character varying(255) NOT NULL,
    model_id bigint NOT NULL
);
 )   DROP TABLE public.model_has_permissions;
       public         heap r       postgres    false                        1259    32845    model_has_roles    TABLE        CREATE TABLE public.model_has_roles (
    role_id bigint NOT NULL,
    model_type character varying(255) NOT NULL,
    model_id bigint NOT NULL
);
 #   DROP TABLE public.model_has_roles;
       public         heap r       postgres    false                        1259    32848    order_items    TABLE     _  CREATE TABLE public.order_items (
    id bigint NOT NULL,
    order_id bigint NOT NULL,
    product_variant_id bigint,
    quantity integer NOT NULL,
    price numeric(10,2) NOT NULL,
    subtotal numeric(10,2) NOT NULL,
    notes character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.order_items;
       public         heap r       postgres    false                        1259    32851    order_items_id_seq    SEQUENCE     {   CREATE SEQUENCE public.order_items_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 )   DROP SEQUENCE public.order_items_id_seq;
       public               postgres    false    238                       0    0    order_items_id_seq    SEQUENCE OWNED BY     I   ALTER SEQUENCE public.order_items_id_seq OWNED BY public.order_items.id;
          public               postgres    false    239                        1259    32852    orders    TABLE       CREATE TABLE public.orders (
    id bigint NOT NULL,
    customer_id bigint,
    user_id bigint,
    status character varying(255) DEFAULT 'pending'::character varying NOT NULL,
    total numeric(10,2) DEFAULT '0'::numeric NOT NULL,
    type character varying(255) DEFAULT 'pos'::character varying NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.orders;
       public         heap r       postgres    false                        1259    32860    orders_id_seq    SEQUENCE     v   CREATE SEQUENCE public.orders_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 $   DROP SEQUENCE public.orders_id_seq;
       public               postgres    false    240                       0    0    orders_id_seq    SEQUENCE OWNED BY     ?   ALTER SEQUENCE public.orders_id_seq OWNED BY public.orders.id;
          public               postgres    false    241                        1259    32861    password_reset_tokens    TABLE        CREATE TABLE public.password_reset_tokens (
    email character varying(255) NOT NULL,
    token character varying(255) NOT NULL,
    created_at timestamp(0) without time zone
);
 )   DROP TABLE public.password_reset_tokens;
       public         heap r       postgres    false                        1259    32866    payments    TABLE     *  CREATE TABLE public.payments (
    id bigint NOT NULL,
    order_id bigint NOT NULL,
    method character varying(255) NOT NULL,
    amount numeric(10,2) NOT NULL,
    reference character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.payments;
       public         heap r       postgres    false                        1259    32871    payments_id_seq    SEQUENCE     x   CREATE SEQUENCE public.payments_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 &   DROP SEQUENCE public.payments_id_seq;
       public               postgres    false    243                       0    0    payments_id_seq    SEQUENCE OWNED BY     C   ALTER SEQUENCE public.payments_id_seq OWNED BY public.payments.id;
          public               postgres    false    244                        1259    32872    permissions    TABLE        CREATE TABLE public.permissions (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    guard_name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.permissions;
       public         heap r       postgres    false                        1259    32877    permissions_id_seq    SEQUENCE     {   CREATE SEQUENCE public.permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 )   DROP SEQUENCE public.permissions_id_seq;
       public               postgres    false    245                       0    0    permissions_id_seq    SEQUENCE OWNED BY     I   ALTER SEQUENCE public.permissions_id_seq OWNED BY public.permissions.id;
          public               postgres    false    246                        1259    32878    product_images    TABLE       CREATE TABLE public.product_images (
    id bigint NOT NULL,
    product_id bigint NOT NULL,
    image_path character varying(255) NOT NULL,
    is_primary boolean DEFAULT false NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 "   DROP TABLE public.product_images;
       public         heap r       postgres    false                        1259    32882    product_images_id_seq    SEQUENCE     ~   CREATE SEQUENCE public.product_images_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 ,   DROP SEQUENCE public.product_images_id_seq;
       public               postgres    false    247                       0    0    product_images_id_seq    SEQUENCE OWNED BY     O   ALTER SEQUENCE public.product_images_id_seq OWNED BY public.product_images.id;
          public               postgres    false    248                        1259    32883    product_transformations    TABLE     y  CREATE TABLE public.product_transformations (
    id bigint NOT NULL,
    source_variant_id bigint NOT NULL,
    target_variant_id bigint NOT NULL,
    source_quantity numeric(10,2) NOT NULL,
    target_quantity numeric(10,2) NOT NULL,
    user_id bigint NOT NULL,
    notes text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 +   DROP TABLE public.product_transformations;
       public         heap r       postgres    false                        1259    32888    product_transformations_id_seq    SEQUENCE        CREATE SEQUENCE public.product_transformations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 5   DROP SEQUENCE public.product_transformations_id_seq;
       public               postgres    false    249                       0    0    product_transformations_id_seq    SEQUENCE OWNED BY     a   ALTER SEQUENCE public.product_transformations_id_seq OWNED BY public.product_transformations.id;
          public               postgres    false    250                        1259    32889    product_variants    TABLE       CREATE TABLE public.product_variants (
    id bigint NOT NULL,
    product_id bigint NOT NULL,
    name character varying(255) NOT NULL,
    sku character varying(255),
    price numeric(10,2) NOT NULL,
    stock_track boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    current_stock integer DEFAULT 0 NOT NULL
);
 $   DROP TABLE public.product_variants;
       public         heap r       postgres    false                        1259    32896    product_variants_id_seq    SEQUENCE        CREATE SEQUENCE public.product_variants_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 .   DROP SEQUENCE public.product_variants_id_seq;
       public               postgres    false    251                       0    0    product_variants_id_seq    SEQUENCE OWNED BY     S   ALTER SEQUENCE public.product_variants_id_seq OWNED BY public.product_variants.id;
          public               postgres    false    252                        1259    32897    products    TABLE       CREATE TABLE public.products (
    id bigint NOT NULL,
    category_id bigint NOT NULL,
    name character varying(255) NOT NULL,
    slug character varying(255) NOT NULL,
    description text,
    type character varying(255) DEFAULT 'finished'::character varying NOT NULL,
    status character varying(255) DEFAULT 'active'::character varying NOT NULL,
    attributes json,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.products;
       public         heap r       postgres    false                        1259    32904    products_id_seq    SEQUENCE     x   CREATE SEQUENCE public.products_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 &   DROP SEQUENCE public.products_id_seq;
       public               postgres    false    253                       0    0    products_id_seq    SEQUENCE OWNED BY     C   ALTER SEQUENCE public.products_id_seq OWNED BY public.products.id;
          public               postgres    false    254                        1259    32905    purchase_items    TABLE     O  CREATE TABLE public.purchase_items (
    id bigint NOT NULL,
    purchase_id bigint NOT NULL,
    supply_id bigint NOT NULL,
    quantity numeric(10,2) NOT NULL,
    unit_cost numeric(10,2) NOT NULL,
    total_cost numeric(10,2) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 "   DROP TABLE public.purchase_items;
       public         heap r       postgres    false                        1259    32908    purchase_items_id_seq    SEQUENCE     ~   CREATE SEQUENCE public.purchase_items_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 ,   DROP SEQUENCE public.purchase_items_id_seq;
       public               postgres    false    255                       0    0    purchase_items_id_seq    SEQUENCE OWNED BY     O   ALTER SEQUENCE public.purchase_items_id_seq OWNED BY public.purchase_items.id;
          public               postgres    false    256                       1259    32909 	   purchases    TABLE       CREATE TABLE public.purchases (
    id bigint NOT NULL,
    supplier_id bigint NOT NULL,
    warehouse_id bigint NOT NULL,
    purchase_date date NOT NULL,
    total_amount numeric(10,2) DEFAULT '0'::numeric NOT NULL,
    status character varying(255) DEFAULT 'pending'::character varying NOT NULL,
    notes text,
    user_id bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.purchases;
       public         heap r       postgres    false                       1259    32916    purchases_id_seq    SEQUENCE     y   CREATE SEQUENCE public.purchases_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 '   DROP SEQUENCE public.purchases_id_seq;
       public               postgres    false    257                       0    0    purchases_id_seq    SEQUENCE OWNED BY     E   ALTER SEQUENCE public.purchases_id_seq OWNED BY public.purchases.id;
          public               postgres    false    258                       1259    32917    recipe_ingredients    TABLE     M  CREATE TABLE public.recipe_ingredients (
    id bigint NOT NULL,
    recipe_id bigint NOT NULL,
    supply_id bigint NOT NULL,
    quantity numeric(10,4) NOT NULL,
    unit character varying(255) DEFAULT 'g'::character varying NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 &   DROP TABLE public.recipe_ingredients;
       public         heap r       postgres    false                       1259    32921    recipe_ingredients_id_seq    SEQUENCE        CREATE SEQUENCE public.recipe_ingredients_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 0   DROP SEQUENCE public.recipe_ingredients_id_seq;
       public               postgres    false    259                       0    0    recipe_ingredients_id_seq    SEQUENCE OWNED BY     W   ALTER SEQUENCE public.recipe_ingredients_id_seq OWNED BY public.recipe_ingredients.id;
          public               postgres    false    260                       1259    32922    recipes    TABLE       CREATE TABLE public.recipes (
    id bigint NOT NULL,
    product_variant_id bigint,
    name character varying(255) NOT NULL,
    description text,
    prep_time integer,
    yield_quantity numeric(10,2) DEFAULT '1'::numeric NOT NULL,
    yield_unit character varying(255) DEFAULT 'unit'::character varying NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    image character varying(255),
    instructions text
);
    DROP TABLE public.recipes;
       public         heap r       postgres    false                       1259    32929    recipes_id_seq    SEQUENCE     w   CREATE SEQUENCE public.recipes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 %   DROP SEQUENCE public.recipes_id_seq;
       public               postgres    false    261                       0    0    recipes_id_seq    SEQUENCE OWNED BY     A   ALTER SEQUENCE public.recipes_id_seq OWNED BY public.recipes.id;
          public               postgres    false    262                       1259    32930    role_has_permissions    TABLE     m   CREATE TABLE public.role_has_permissions (
    permission_id bigint NOT NULL,
    role_id bigint NOT NULL
);
 (   DROP TABLE public.role_has_permissions;
       public         heap r       postgres    false                       1259    32933    roles    TABLE        CREATE TABLE public.roles (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    guard_name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.roles;
       public         heap r       postgres    false            	           1259    32938    roles_id_seq    SEQUENCE     u   CREATE SEQUENCE public.roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 #   DROP SEQUENCE public.roles_id_seq;
       public               postgres    false    264                       0    0    roles_id_seq    SEQUENCE OWNED BY     =   ALTER SEQUENCE public.roles_id_seq OWNED BY public.roles.id;
          public               postgres    false    265            
           1259    32939    sessions    TABLE        CREATE TABLE public.sessions (
    id character varying(255) NOT NULL,
    user_id bigint,
    ip_address character varying(45),
    user_agent text,
    payload text NOT NULL,
    last_activity integer NOT NULL
);
    DROP TABLE public.sessions;
       public         heap r       postgres    false                       1259    32944    settings    TABLE        CREATE TABLE public.settings (
    id bigint NOT NULL,
    key character varying(255) NOT NULL,
    value text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.settings;
       public         heap r       postgres    false                       1259    32949    settings_id_seq    SEQUENCE     x   CREATE SEQUENCE public.settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 &   DROP SEQUENCE public.settings_id_seq;
       public               postgres    false    267                       0    0    settings_id_seq    SEQUENCE OWNED BY     C   ALTER SEQUENCE public.settings_id_seq OWNED BY public.settings.id;
          public               postgres    false    268                       1259    32950    special_order_items    TABLE     U  CREATE TABLE public.special_order_items (
    id bigint NOT NULL,
    special_order_id bigint NOT NULL,
    product_variant_id bigint NOT NULL,
    quantity numeric(10,2) NOT NULL,
    unit_price numeric(10,2) NOT NULL,
    specifications text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 '   DROP TABLE public.special_order_items;
       public         heap r       postgres    false                       1259    32955    special_order_items_id_seq    SEQUENCE        CREATE SEQUENCE public.special_order_items_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 1   DROP SEQUENCE public.special_order_items_id_seq;
       public               postgres    false    269                       0    0    special_order_items_id_seq    SEQUENCE OWNED BY     Y   ALTER SEQUENCE public.special_order_items_id_seq OWNED BY public.special_order_items.id;
          public               postgres    false    270                       1259    32956    special_orders    TABLE       CREATE TABLE public.special_orders (
    id bigint NOT NULL,
    customer_id bigint NOT NULL,
    pickup_date timestamp(0) without time zone NOT NULL,
    status character varying(255) DEFAULT 'pending'::character varying NOT NULL,
    total_amount numeric(10,2) DEFAULT '0'::numeric NOT NULL,
    deposit_amount numeric(10,2) DEFAULT '0'::numeric NOT NULL,
    notes text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT special_orders_status_check CHECK (((status)::text = ANY (ARRAY[('pending'::character varying)::text, ('confirmed'::character varying)::text, ('in_production'::character varying)::text, ('ready'::character varying)::text, ('delivered'::character varying)::text, ('cancelled'::character varying)::text])))
);
 "   DROP TABLE public.special_orders;
       public         heap r       postgres    false                       1259    32965    special_orders_id_seq    SEQUENCE     ~   CREATE SEQUENCE public.special_orders_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 ,   DROP SEQUENCE public.special_orders_id_seq;
       public               postgres    false    271                       0    0    special_orders_id_seq    SEQUENCE OWNED BY     O   ALTER SEQUENCE public.special_orders_id_seq OWNED BY public.special_orders.id;
          public               postgres    false    272                       1259    32966 	   suppliers    TABLE       CREATE TABLE public.suppliers (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    contact_name character varying(255),
    phone character varying(255),
    email character varying(255),
    address text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    status boolean DEFAULT true NOT NULL,
    document_number character varying(255)
);
    DROP TABLE public.suppliers;
       public         heap r       postgres    false                       1259    32972    suppliers_id_seq    SEQUENCE     y   CREATE SEQUENCE public.suppliers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 '   DROP SEQUENCE public.suppliers_id_seq;
       public               postgres    false    273                       0    0    suppliers_id_seq    SEQUENCE OWNED BY     E   ALTER SEQUENCE public.suppliers_id_seq OWNED BY public.suppliers.id;
          public               postgres    false    274                       1259    32973    supplies    TABLE       CREATE TABLE public.supplies (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    sku character varying(255),
    base_unit character varying(255) DEFAULT 'kg'::character varying NOT NULL,
    cost numeric(10,4) DEFAULT '0'::numeric NOT NULL,
    min_stock numeric(10,2) DEFAULT '0'::numeric NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    status boolean DEFAULT true NOT NULL,
    supplier_id bigint
);
    DROP TABLE public.supplies;
       public         heap r       postgres    false                       1259    32982    supplies_id_seq    SEQUENCE     x   CREATE SEQUENCE public.supplies_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 &   DROP SEQUENCE public.supplies_id_seq;
       public               postgres    false    275                       0    0    supplies_id_seq    SEQUENCE OWNED BY     C   ALTER SEQUENCE public.supplies_id_seq OWNED BY public.supplies.id;
          public               postgres    false    276                       1259    32983    supply_stocks    TABLE     V  CREATE TABLE public.supply_stocks (
    id bigint NOT NULL,
    supply_id bigint NOT NULL,
    warehouse_id bigint NOT NULL,
    quantity numeric(10,4) DEFAULT '0'::numeric NOT NULL,
    batch_no character varying(255),
    expiration_date date,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 !   DROP TABLE public.supply_stocks;
       public         heap r       postgres    false                       1259    32987    supply_stocks_id_seq    SEQUENCE     }   CREATE SEQUENCE public.supply_stocks_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 +   DROP SEQUENCE public.supply_stocks_id_seq;
       public               postgres    false    277                       0    0    supply_stocks_id_seq    SEQUENCE OWNED BY     M   ALTER SEQUENCE public.supply_stocks_id_seq OWNED BY public.supply_stocks.id;
          public               postgres    false    278                       1259    32988    users    TABLE       CREATE TABLE public.users (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    email character varying(255) NOT NULL,
    role character varying(255) DEFAULT 'seller'::character varying NOT NULL,
    phone character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    email_verified_at timestamp(0) without time zone,
    password character varying(255) NOT NULL,
    remember_token character varying(100),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
    DROP TABLE public.users;
       public         heap r       postgres    false                       1259    32995    users_id_seq    SEQUENCE     u   CREATE SEQUENCE public.users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 #   DROP SEQUENCE public.users_id_seq;
       public               postgres    false    279                       0    0    users_id_seq    SEQUENCE OWNED BY     =   ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
          public               postgres    false    280                       1259    32996 
   warehouses    TABLE     (  CREATE TABLE public.warehouses (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    location character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    status boolean DEFAULT true NOT NULL,
    description text
);
    DROP TABLE public.warehouses;
       public         heap r       postgres    false                       1259    33002    warehouses_id_seq    SEQUENCE     z   CREATE SEQUENCE public.warehouses_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 (   DROP SEQUENCE public.warehouses_id_seq;
       public               postgres    false    281                       0    0    warehouses_id_seq    SEQUENCE OWNED BY     G   ALTER SEQUENCE public.warehouses_id_seq OWNED BY public.warehouses.id;
          public               postgres    false    282            2           2604    33003    cash_movements id    DEFAULT     v   ALTER TABLE ONLY public.cash_movements ALTER COLUMN id SET DEFAULT nextval('public.cash_movements_id_seq'::regclass);
 @   ALTER TABLE public.cash_movements ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    220    219            3           2604    33004    cash_registers id    DEFAULT     v   ALTER TABLE ONLY public.cash_registers ALTER COLUMN id SET DEFAULT nextval('public.cash_registers_id_seq'::regclass);
 @   ALTER TABLE public.cash_registers ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    222    221            5           2604    33005    categories id    DEFAULT     n   ALTER TABLE ONLY public.categories ALTER COLUMN id SET DEFAULT nextval('public.categories_id_seq'::regclass);
 <   ALTER TABLE public.categories ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    224    223            7           2604    33006    customers id    DEFAULT     l   ALTER TABLE ONLY public.customers ALTER COLUMN id SET DEFAULT nextval('public.customers_id_seq'::regclass);
 ;   ALTER TABLE public.customers ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    226    225            :           2604    33007    failed_jobs id    DEFAULT     p   ALTER TABLE ONLY public.failed_jobs ALTER COLUMN id SET DEFAULT nextval('public.failed_jobs_id_seq'::regclass);
 =   ALTER TABLE public.failed_jobs ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    228    227            <           2604    33008    inventory_movements id    DEFAULT        ALTER TABLE ONLY public.inventory_movements ALTER COLUMN id SET DEFAULT nextval('public.inventory_movements_id_seq'::regclass);
 E   ALTER TABLE public.inventory_movements ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    230    229            =           2604    33009    jobs id    DEFAULT     b   ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass);
 6   ALTER TABLE public.jobs ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    233    232            >           2604    33010    migrations id    DEFAULT     n   ALTER TABLE ONLY public.migrations ALTER COLUMN id SET DEFAULT nextval('public.migrations_id_seq'::regclass);
 <   ALTER TABLE public.migrations ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    235    234            ?           2604    33011    order_items id    DEFAULT     p   ALTER TABLE ONLY public.order_items ALTER COLUMN id SET DEFAULT nextval('public.order_items_id_seq'::regclass);
 =   ALTER TABLE public.order_items ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    239    238            @           2604    33012 	   orders id    DEFAULT     f   ALTER TABLE ONLY public.orders ALTER COLUMN id SET DEFAULT nextval('public.orders_id_seq'::regclass);
 8   ALTER TABLE public.orders ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    241    240            D           2604    33013    payments id    DEFAULT     j   ALTER TABLE ONLY public.payments ALTER COLUMN id SET DEFAULT nextval('public.payments_id_seq'::regclass);
 :   ALTER TABLE public.payments ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    244    243            E           2604    33014    permissions id    DEFAULT     p   ALTER TABLE ONLY public.permissions ALTER COLUMN id SET DEFAULT nextval('public.permissions_id_seq'::regclass);
 =   ALTER TABLE public.permissions ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    246    245            F           2604    33015    product_images id    DEFAULT     v   ALTER TABLE ONLY public.product_images ALTER COLUMN id SET DEFAULT nextval('public.product_images_id_seq'::regclass);
 @   ALTER TABLE public.product_images ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    248    247            H           2604    33016    product_transformations id    DEFAULT        ALTER TABLE ONLY public.product_transformations ALTER COLUMN id SET DEFAULT nextval('public.product_transformations_id_seq'::regclass);
 I   ALTER TABLE public.product_transformations ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    250    249            I           2604    33017    product_variants id    DEFAULT     z   ALTER TABLE ONLY public.product_variants ALTER COLUMN id SET DEFAULT nextval('public.product_variants_id_seq'::regclass);
 B   ALTER TABLE public.product_variants ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    252    251            L           2604    33018    products id    DEFAULT     j   ALTER TABLE ONLY public.products ALTER COLUMN id SET DEFAULT nextval('public.products_id_seq'::regclass);
 :   ALTER TABLE public.products ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    254    253            O           2604    33019    purchase_items id    DEFAULT     v   ALTER TABLE ONLY public.purchase_items ALTER COLUMN id SET DEFAULT nextval('public.purchase_items_id_seq'::regclass);
 @   ALTER TABLE public.purchase_items ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    256    255            P           2604    33020    purchases id    DEFAULT     l   ALTER TABLE ONLY public.purchases ALTER COLUMN id SET DEFAULT nextval('public.purchases_id_seq'::regclass);
 ;   ALTER TABLE public.purchases ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    258    257            S           2604    33021    recipe_ingredients id    DEFAULT     ~   ALTER TABLE ONLY public.recipe_ingredients ALTER COLUMN id SET DEFAULT nextval('public.recipe_ingredients_id_seq'::regclass);
 D   ALTER TABLE public.recipe_ingredients ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    260    259            U           2604    33022 
   recipes id    DEFAULT     h   ALTER TABLE ONLY public.recipes ALTER COLUMN id SET DEFAULT nextval('public.recipes_id_seq'::regclass);
 9   ALTER TABLE public.recipes ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    262    261            X           2604    33023    roles id    DEFAULT     d   ALTER TABLE ONLY public.roles ALTER COLUMN id SET DEFAULT nextval('public.roles_id_seq'::regclass);
 7   ALTER TABLE public.roles ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    265    264            Y           2604    33024    settings id    DEFAULT     j   ALTER TABLE ONLY public.settings ALTER COLUMN id SET DEFAULT nextval('public.settings_id_seq'::regclass);
 :   ALTER TABLE public.settings ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    268    267            Z           2604    33025    special_order_items id    DEFAULT        ALTER TABLE ONLY public.special_order_items ALTER COLUMN id SET DEFAULT nextval('public.special_order_items_id_seq'::regclass);
 E   ALTER TABLE public.special_order_items ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    270    269            [           2604    33026    special_orders id    DEFAULT     v   ALTER TABLE ONLY public.special_orders ALTER COLUMN id SET DEFAULT nextval('public.special_orders_id_seq'::regclass);
 @   ALTER TABLE public.special_orders ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    272    271            _           2604    33027    suppliers id    DEFAULT     l   ALTER TABLE ONLY public.suppliers ALTER COLUMN id SET DEFAULT nextval('public.suppliers_id_seq'::regclass);
 ;   ALTER TABLE public.suppliers ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    274    273            a           2604    33028    supplies id    DEFAULT     j   ALTER TABLE ONLY public.supplies ALTER COLUMN id SET DEFAULT nextval('public.supplies_id_seq'::regclass);
 :   ALTER TABLE public.supplies ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    276    275            f           2604    33029    supply_stocks id    DEFAULT     t   ALTER TABLE ONLY public.supply_stocks ALTER COLUMN id SET DEFAULT nextval('public.supply_stocks_id_seq'::regclass);
 ?   ALTER TABLE public.supply_stocks ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    278    277            h           2604    33030    users id    DEFAULT     d   ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
 7   ALTER TABLE public.users ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    280    279            k           2604    33031    warehouses id    DEFAULT     n   ALTER TABLE ONLY public.warehouses ALTER COLUMN id SET DEFAULT nextval('public.warehouses_id_seq'::regclass);
 <   ALTER TABLE public.warehouses ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    282    281                      0    32775    cache 
   TABLE DATA           7   COPY public.cache (key, value, expiration) FROM stdin;
    public               postgres    false    217   t                0    32780    cache_locks 
   TABLE DATA           =   COPY public.cache_locks (key, owner, expiration) FROM stdin;
    public               postgres    false    218   w                0    32785    cash_movements 
   TABLE DATA              COPY public.cash_movements (id, cash_register_id, type, amount, description, reference_id, created_at, updated_at) FROM stdin;
    public               postgres    false    219   2w                0    32792    cash_registers 
   TABLE DATA              COPY public.cash_registers (id, user_id, status, opening_amount, closing_amount, opening_time, closing_time, notes, created_at, updated_at) FROM stdin;
    public               postgres    false    221   Ow                0    32799 
   categories 
   TABLE DATA           s   COPY public.categories (id, name, slug, parent_id, image, created_at, updated_at, description, status) FROM stdin;
    public               postgres    false    223   w                0    32806 	   customers 
   TABLE DATA              COPY public.customers (id, name, email, phone, address, tax_id, created_at, updated_at, status, birthday, loyalty_points, notes) FROM stdin;
    public               postgres    false    225   /y                0    32814    failed_jobs 
   TABLE DATA           a   COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin;
    public               postgres    false    227   Vz                0    32821    inventory_movements 
   TABLE DATA              COPY public.inventory_movements (id, supply_id, warehouse_id, type, quantity, reference_id, notes, created_at, updated_at, product_variant_id, description, user_id) FROM stdin;
    public               postgres    false    229   sz                0    32827    job_batches 
   TABLE DATA              COPY public.job_batches (id, name, total_jobs, pending_jobs, failed_jobs, failed_job_ids, options, cancelled_at, created_at, finished_at) FROM stdin;
    public               postgres    false    231   6|                0    32832    jobs 
   TABLE DATA           c   COPY public.jobs (id, queue, payload, attempts, reserved_at, available_at, created_at) FROM stdin;
    public               postgres    false    232   S|                0    32838 
   migrations 
   TABLE DATA           :   COPY public.migrations (id, migration, batch) FROM stdin;
    public               postgres    false    234   p|                0    32842    model_has_permissions 
   TABLE DATA           T   COPY public.model_has_permissions (permission_id, model_type, model_id) FROM stdin;
    public               postgres    false    236                   0    32845    model_has_roles 
   TABLE DATA           H   COPY public.model_has_roles (role_id, model_type, model_id) FROM stdin;
    public               postgres    false    237   2                0    32848    order_items 
   TABLE DATA              COPY public.order_items (id, order_id, product_variant_id, quantity, price, subtotal, notes, created_at, updated_at) FROM stdin;
    public               postgres    false    238   j                0    32852    orders 
   TABLE DATA           g   COPY public.orders (id, customer_id, user_id, status, total, type, created_at, updated_at) FROM stdin;
    public               postgres    false    240   R                0    32861    password_reset_tokens 
   TABLE DATA           I   COPY public.password_reset_tokens (email, token, created_at) FROM stdin;
    public               postgres    false    242   N                0    32866    payments 
   TABLE DATA           c   COPY public.payments (id, order_id, method, amount, reference, created_at, updated_at) FROM stdin;
    public               postgres    false    243   k                0    32872    permissions 
   TABLE DATA           S   COPY public.permissions (id, name, guard_name, created_at, updated_at) FROM stdin;
    public               postgres    false    245                   0    32878    product_images 
   TABLE DATA           h   COPY public.product_images (id, product_id, image_path, is_primary, created_at, updated_at) FROM stdin;
    public               postgres    false    247                   0    32883    product_transformations 
   TABLE DATA              COPY public.product_transformations (id, source_variant_id, target_variant_id, source_quantity, target_quantity, user_id, notes, created_at, updated_at) FROM stdin;
    public               postgres    false    249                   0    32889    product_variants 
   TABLE DATA              COPY public.product_variants (id, product_id, name, sku, price, stock_track, created_at, updated_at, current_stock) FROM stdin;
    public               postgres    false    251   "                0    32897    products 
   TABLE DATA           ~   COPY public.products (id, category_id, name, slug, description, type, status, attributes, created_at, updated_at) FROM stdin;
    public               postgres    false    253   1                0    32905    purchase_items 
   TABLE DATA           }   COPY public.purchase_items (id, purchase_id, supply_id, quantity, unit_cost, total_cost, created_at, updated_at) FROM stdin;
    public               postgres    false    255                   0    32909 	   purchases 
   TABLE DATA              COPY public.purchases (id, supplier_id, warehouse_id, purchase_date, total_amount, status, notes, user_id, created_at, updated_at) FROM stdin;
    public               postgres    false    257                   0    32917    recipe_ingredients 
   TABLE DATA           n   COPY public.recipe_ingredients (id, recipe_id, supply_id, quantity, unit, created_at, updated_at) FROM stdin;
    public               postgres    false    259                   0    32922    recipes 
   TABLE DATA              COPY public.recipes (id, product_variant_id, name, description, prep_time, yield_quantity, yield_unit, created_at, updated_at, image, instructions) FROM stdin;
    public               postgres    false    261   ވ                0    32930    role_has_permissions 
   TABLE DATA           F   COPY public.role_has_permissions (permission_id, role_id) FROM stdin;
    public               postgres    false    263   1                0    32933    roles 
   TABLE DATA           M   COPY public.roles (id, name, guard_name, created_at, updated_at) FROM stdin;
    public               postgres    false    264   l                0    32939    sessions 
   TABLE DATA           _   COPY public.sessions (id, user_id, ip_address, user_agent, payload, last_activity) FROM stdin;
    public               postgres    false    266   Ǌ                0    32944    settings 
   TABLE DATA           J   COPY public.settings (id, key, value, created_at, updated_at) FROM stdin;
    public               postgres    false    267                   0    32950    special_order_items 
   TABLE DATA              COPY public.special_order_items (id, special_order_id, product_variant_id, quantity, unit_price, specifications, created_at, updated_at) FROM stdin;
    public               postgres    false    269   ׎                0    32956    special_orders 
   TABLE DATA              COPY public.special_orders (id, customer_id, pickup_date, status, total_amount, deposit_amount, notes, created_at, updated_at) FROM stdin;
    public               postgres    false    271                   0    32966 	   suppliers 
   TABLE DATA              COPY public.suppliers (id, name, contact_name, phone, email, address, created_at, updated_at, status, document_number) FROM stdin;
    public               postgres    false    273                   0    32973    supplies 
   TABLE DATA           z   COPY public.supplies (id, name, sku, base_unit, cost, min_stock, created_at, updated_at, status, supplier_id) FROM stdin;
    public               postgres    false    275                   0    32983    supply_stocks 
   TABLE DATA              COPY public.supply_stocks (id, supply_id, warehouse_id, quantity, batch_no, expiration_date, created_at, updated_at) FROM stdin;
    public               postgres    false    277   T                0    32988    users 
   TABLE DATA              COPY public.users (id, name, email, role, phone, is_active, email_verified_at, password, remember_token, created_at, updated_at) FROM stdin;
    public               postgres    false    279   Ւ                0    32996 
   warehouses 
   TABLE DATA           e   COPY public.warehouses (id, name, location, created_at, updated_at, status, description) FROM stdin;
    public               postgres    false    281                    0    0    cash_movements_id_seq    SEQUENCE SET     D   SELECT pg_catalog.setval('public.cash_movements_id_seq', 1, false);
          public               postgres    false    220                       0    0    cash_registers_id_seq    SEQUENCE SET     C   SELECT pg_catalog.setval('public.cash_registers_id_seq', 4, true);
          public               postgres    false    222                       0    0    categories_id_seq    SEQUENCE SET     @   SELECT pg_catalog.setval('public.categories_id_seq', 76, true);
          public               postgres    false    224                       0    0    customers_id_seq    SEQUENCE SET     ?   SELECT pg_catalog.setval('public.customers_id_seq', 71, true);
          public               postgres    false    226                       0    0    failed_jobs_id_seq    SEQUENCE SET     A   SELECT pg_catalog.setval('public.failed_jobs_id_seq', 1, false);
          public               postgres    false    228                       0    0    inventory_movements_id_seq    SEQUENCE SET     I   SELECT pg_catalog.setval('public.inventory_movements_id_seq', 18, true);
          public               postgres    false    230                       0    0    jobs_id_seq    SEQUENCE SET     :   SELECT pg_catalog.setval('public.jobs_id_seq', 1, false);
          public               postgres    false    233                       0    0    migrations_id_seq    SEQUENCE SET     @   SELECT pg_catalog.setval('public.migrations_id_seq', 41, true);
          public               postgres    false    235                       0    0    order_items_id_seq    SEQUENCE SET     A   SELECT pg_catalog.setval('public.order_items_id_seq', 45, true);
          public               postgres    false    239                       0    0    orders_id_seq    SEQUENCE SET     <   SELECT pg_catalog.setval('public.orders_id_seq', 44, true);
          public               postgres    false    241                       0    0    payments_id_seq    SEQUENCE SET     >   SELECT pg_catalog.setval('public.payments_id_seq', 1, false);
          public               postgres    false    244                       0    0    permissions_id_seq    SEQUENCE SET     @   SELECT pg_catalog.setval('public.permissions_id_seq', 5, true);
          public               postgres    false    246                       0    0    product_images_id_seq    SEQUENCE SET     C   SELECT pg_catalog.setval('public.product_images_id_seq', 4, true);
          public               postgres    false    248                       0    0    product_transformations_id_seq    SEQUENCE SET     M   SELECT pg_catalog.setval('public.product_transformations_id_seq', 1, false);
          public               postgres    false    250                       0    0    product_variants_id_seq    SEQUENCE SET     F   SELECT pg_catalog.setval('public.product_variants_id_seq', 74, true);
          public               postgres    false    252                       0    0    products_id_seq    SEQUENCE SET     >   SELECT pg_catalog.setval('public.products_id_seq', 74, true);
          public               postgres    false    254                       0    0    purchase_items_id_seq    SEQUENCE SET     D   SELECT pg_catalog.setval('public.purchase_items_id_seq', 55, true);
          public               postgres    false    256                       0    0    purchases_id_seq    SEQUENCE SET     ?   SELECT pg_catalog.setval('public.purchases_id_seq', 55, true);
          public               postgres    false    258                       0    0    recipe_ingredients_id_seq    SEQUENCE SET     I   SELECT pg_catalog.setval('public.recipe_ingredients_id_seq', 148, true);
          public               postgres    false    260                       0    0    recipes_id_seq    SEQUENCE SET     =   SELECT pg_catalog.setval('public.recipes_id_seq', 74, true);
          public               postgres    false    262                       0    0    roles_id_seq    SEQUENCE SET     :   SELECT pg_catalog.setval('public.roles_id_seq', 4, true);
          public               postgres    false    265                       0    0    settings_id_seq    SEQUENCE SET     =   SELECT pg_catalog.setval('public.settings_id_seq', 7, true);
          public               postgres    false    268                        0    0    special_order_items_id_seq    SEQUENCE SET     I   SELECT pg_catalog.setval('public.special_order_items_id_seq', 1, false);
          public               postgres    false    270                       0    0    special_orders_id_seq    SEQUENCE SET     D   SELECT pg_catalog.setval('public.special_orders_id_seq', 1, false);
          public               postgres    false    272                       0    0    suppliers_id_seq    SEQUENCE SET     ?   SELECT pg_catalog.setval('public.suppliers_id_seq', 75, true);
          public               postgres    false    274                       0    0    supplies_id_seq    SEQUENCE SET     >   SELECT pg_catalog.setval('public.supplies_id_seq', 75, true);
          public               postgres    false    276                       0    0    supply_stocks_id_seq    SEQUENCE SET     B   SELECT pg_catalog.setval('public.supply_stocks_id_seq', 5, true);
          public               postgres    false    278                       0    0    users_id_seq    SEQUENCE SET     :   SELECT pg_catalog.setval('public.users_id_seq', 2, true);
          public               postgres    false    280                       0    0    warehouses_id_seq    SEQUENCE SET     @   SELECT pg_catalog.setval('public.warehouses_id_seq', 74, true);
          public               postgres    false    282            t           2606    33033    cache_locks cache_locks_pkey 
   CONSTRAINT     [   ALTER TABLE ONLY public.cache_locks
    ADD CONSTRAINT cache_locks_pkey PRIMARY KEY (key);
 F   ALTER TABLE ONLY public.cache_locks DROP CONSTRAINT cache_locks_pkey;
       public                 postgres    false    218            q           2606    33035    cache cache_pkey 
   CONSTRAINT     O   ALTER TABLE ONLY public.cache
    ADD CONSTRAINT cache_pkey PRIMARY KEY (key);
 :   ALTER TABLE ONLY public.cache DROP CONSTRAINT cache_pkey;
       public                 postgres    false    217            v           2606    33037 "   cash_movements cash_movements_pkey 
   CONSTRAINT     `   ALTER TABLE ONLY public.cash_movements
    ADD CONSTRAINT cash_movements_pkey PRIMARY KEY (id);
 L   ALTER TABLE ONLY public.cash_movements DROP CONSTRAINT cash_movements_pkey;
       public                 postgres    false    219            x           2606    33039 "   cash_registers cash_registers_pkey 
   CONSTRAINT     `   ALTER TABLE ONLY public.cash_registers
    ADD CONSTRAINT cash_registers_pkey PRIMARY KEY (id);
 L   ALTER TABLE ONLY public.cash_registers DROP CONSTRAINT cash_registers_pkey;
       public                 postgres    false    221            z           2606    33041    categories categories_pkey 
   CONSTRAINT     X   ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_pkey PRIMARY KEY (id);
 D   ALTER TABLE ONLY public.categories DROP CONSTRAINT categories_pkey;
       public                 postgres    false    223            |           2606    33043 !   categories categories_slug_unique 
   CONSTRAINT     \   ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_slug_unique UNIQUE (slug);
 K   ALTER TABLE ONLY public.categories DROP CONSTRAINT categories_slug_unique;
       public                 postgres    false    223            ~           2606    33045    customers customers_pkey 
   CONSTRAINT     V   ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_pkey PRIMARY KEY (id);
 B   ALTER TABLE ONLY public.customers DROP CONSTRAINT customers_pkey;
       public                 postgres    false    225                       2606    33047    failed_jobs failed_jobs_pkey 
   CONSTRAINT     Z   ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);
 F   ALTER TABLE ONLY public.failed_jobs DROP CONSTRAINT failed_jobs_pkey;
       public                 postgres    false    227                       2606    33049 #   failed_jobs failed_jobs_uuid_unique 
   CONSTRAINT     ^   ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);
 M   ALTER TABLE ONLY public.failed_jobs DROP CONSTRAINT failed_jobs_uuid_unique;
       public                 postgres    false    227                       2606    33051 ,   inventory_movements inventory_movements_pkey 
   CONSTRAINT     j   ALTER TABLE ONLY public.inventory_movements
    ADD CONSTRAINT inventory_movements_pkey PRIMARY KEY (id);
 V   ALTER TABLE ONLY public.inventory_movements DROP CONSTRAINT inventory_movements_pkey;
       public                 postgres    false    229                       2606    33053    job_batches job_batches_pkey 
   CONSTRAINT     Z   ALTER TABLE ONLY public.job_batches
    ADD CONSTRAINT job_batches_pkey PRIMARY KEY (id);
 F   ALTER TABLE ONLY public.job_batches DROP CONSTRAINT job_batches_pkey;
       public                 postgres    false    231                       2606    33055    jobs jobs_pkey 
   CONSTRAINT     L   ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);
 8   ALTER TABLE ONLY public.jobs DROP CONSTRAINT jobs_pkey;
       public                 postgres    false    232                       2606    33057    migrations migrations_pkey 
   CONSTRAINT     X   ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);
 D   ALTER TABLE ONLY public.migrations DROP CONSTRAINT migrations_pkey;
       public                 postgres    false    234                       2606    33059 0   model_has_permissions model_has_permissions_pkey 
   CONSTRAINT        ALTER TABLE ONLY public.model_has_permissions
    ADD CONSTRAINT model_has_permissions_pkey PRIMARY KEY (permission_id, model_id, model_type);
 Z   ALTER TABLE ONLY public.model_has_permissions DROP CONSTRAINT model_has_permissions_pkey;
       public                 postgres    false    236    236    236                       2606    33061 $   model_has_roles model_has_roles_pkey 
   CONSTRAINT     }   ALTER TABLE ONLY public.model_has_roles
    ADD CONSTRAINT model_has_roles_pkey PRIMARY KEY (role_id, model_id, model_type);
 N   ALTER TABLE ONLY public.model_has_roles DROP CONSTRAINT model_has_roles_pkey;
       public                 postgres    false    237    237    237                       2606    33063    order_items order_items_pkey 
   CONSTRAINT     Z   ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_pkey PRIMARY KEY (id);
 F   ALTER TABLE ONLY public.order_items DROP CONSTRAINT order_items_pkey;
       public                 postgres    false    238                       2606    33065    orders orders_pkey 
   CONSTRAINT     P   ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_pkey PRIMARY KEY (id);
 <   ALTER TABLE ONLY public.orders DROP CONSTRAINT orders_pkey;
       public                 postgres    false    240                       2606    33067 0   password_reset_tokens password_reset_tokens_pkey 
   CONSTRAINT     q   ALTER TABLE ONLY public.password_reset_tokens
    ADD CONSTRAINT password_reset_tokens_pkey PRIMARY KEY (email);
 Z   ALTER TABLE ONLY public.password_reset_tokens DROP CONSTRAINT password_reset_tokens_pkey;
       public                 postgres    false    242                       2606    33069    payments payments_pkey 
   CONSTRAINT     T   ALTER TABLE ONLY public.payments
    ADD CONSTRAINT payments_pkey PRIMARY KEY (id);
 @   ALTER TABLE ONLY public.payments DROP CONSTRAINT payments_pkey;
       public                 postgres    false    243                       2606    33071 .   permissions permissions_name_guard_name_unique 
   CONSTRAINT     u   ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_name_guard_name_unique UNIQUE (name, guard_name);
 X   ALTER TABLE ONLY public.permissions DROP CONSTRAINT permissions_name_guard_name_unique;
       public                 postgres    false    245    245                       2606    33073    permissions permissions_pkey 
   CONSTRAINT     Z   ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);
 F   ALTER TABLE ONLY public.permissions DROP CONSTRAINT permissions_pkey;
       public                 postgres    false    245                       2606    33075 "   product_images product_images_pkey 
   CONSTRAINT     `   ALTER TABLE ONLY public.product_images
    ADD CONSTRAINT product_images_pkey PRIMARY KEY (id);
 L   ALTER TABLE ONLY public.product_images DROP CONSTRAINT product_images_pkey;
       public                 postgres    false    247                       2606    33077 4   product_transformations product_transformations_pkey 
   CONSTRAINT     r   ALTER TABLE ONLY public.product_transformations
    ADD CONSTRAINT product_transformations_pkey PRIMARY KEY (id);
 ^   ALTER TABLE ONLY public.product_transformations DROP CONSTRAINT product_transformations_pkey;
       public                 postgres    false    249                       2606    33079 &   product_variants product_variants_pkey 
   CONSTRAINT     d   ALTER TABLE ONLY public.product_variants
    ADD CONSTRAINT product_variants_pkey PRIMARY KEY (id);
 P   ALTER TABLE ONLY public.product_variants DROP CONSTRAINT product_variants_pkey;
       public                 postgres    false    251                       2606    33081 ,   product_variants product_variants_sku_unique 
   CONSTRAINT     f   ALTER TABLE ONLY public.product_variants
    ADD CONSTRAINT product_variants_sku_unique UNIQUE (sku);
 V   ALTER TABLE ONLY public.product_variants DROP CONSTRAINT product_variants_sku_unique;
       public                 postgres    false    251                       2606    33083    products products_pkey 
   CONSTRAINT     T   ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_pkey PRIMARY KEY (id);
 @   ALTER TABLE ONLY public.products DROP CONSTRAINT products_pkey;
       public                 postgres    false    253                       2606    33085    products products_slug_unique 
   CONSTRAINT     X   ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_slug_unique UNIQUE (slug);
 G   ALTER TABLE ONLY public.products DROP CONSTRAINT products_slug_unique;
       public                 postgres    false    253                       2606    33087 "   purchase_items purchase_items_pkey 
   CONSTRAINT     `   ALTER TABLE ONLY public.purchase_items
    ADD CONSTRAINT purchase_items_pkey PRIMARY KEY (id);
 L   ALTER TABLE ONLY public.purchase_items DROP CONSTRAINT purchase_items_pkey;
       public                 postgres    false    255                       2606    33089    purchases purchases_pkey 
   CONSTRAINT     V   ALTER TABLE ONLY public.purchases
    ADD CONSTRAINT purchases_pkey PRIMARY KEY (id);
 B   ALTER TABLE ONLY public.purchases DROP CONSTRAINT purchases_pkey;
       public                 postgres    false    257                       2606    33091 *   recipe_ingredients recipe_ingredients_pkey 
   CONSTRAINT     h   ALTER TABLE ONLY public.recipe_ingredients
    ADD CONSTRAINT recipe_ingredients_pkey PRIMARY KEY (id);
 T   ALTER TABLE ONLY public.recipe_ingredients DROP CONSTRAINT recipe_ingredients_pkey;
       public                 postgres    false    259                       2606    33093    recipes recipes_pkey 
   CONSTRAINT     R   ALTER TABLE ONLY public.recipes
    ADD CONSTRAINT recipes_pkey PRIMARY KEY (id);
 >   ALTER TABLE ONLY public.recipes DROP CONSTRAINT recipes_pkey;
       public                 postgres    false    261                       2606    33095 .   role_has_permissions role_has_permissions_pkey 
   CONSTRAINT        ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_pkey PRIMARY KEY (permission_id, role_id);
 X   ALTER TABLE ONLY public.role_has_permissions DROP CONSTRAINT role_has_permissions_pkey;
       public                 postgres    false    263    263                       2606    33097 "   roles roles_name_guard_name_unique 
   CONSTRAINT     i   ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_name_guard_name_unique UNIQUE (name, guard_name);
 L   ALTER TABLE ONLY public.roles DROP CONSTRAINT roles_name_guard_name_unique;
       public                 postgres    false    264    264                       2606    33099    roles roles_pkey 
   CONSTRAINT     N   ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);
 :   ALTER TABLE ONLY public.roles DROP CONSTRAINT roles_pkey;
       public                 postgres    false    264                       2606    33101    sessions sessions_pkey 
   CONSTRAINT     T   ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);
 @   ALTER TABLE ONLY public.sessions DROP CONSTRAINT sessions_pkey;
       public                 postgres    false    266                       2606    33103    settings settings_key_unique 
   CONSTRAINT     V   ALTER TABLE ONLY public.settings
    ADD CONSTRAINT settings_key_unique UNIQUE (key);
 F   ALTER TABLE ONLY public.settings DROP CONSTRAINT settings_key_unique;
       public                 postgres    false    267                       2606    33105    settings settings_pkey 
   CONSTRAINT     T   ALTER TABLE ONLY public.settings
    ADD CONSTRAINT settings_pkey PRIMARY KEY (id);
 @   ALTER TABLE ONLY public.settings DROP CONSTRAINT settings_pkey;
       public                 postgres    false    267                       2606    33107 ,   special_order_items special_order_items_pkey 
   CONSTRAINT     j   ALTER TABLE ONLY public.special_order_items
    ADD CONSTRAINT special_order_items_pkey PRIMARY KEY (id);
 V   ALTER TABLE ONLY public.special_order_items DROP CONSTRAINT special_order_items_pkey;
       public                 postgres    false    269                       2606    33109 "   special_orders special_orders_pkey 
   CONSTRAINT     `   ALTER TABLE ONLY public.special_orders
    ADD CONSTRAINT special_orders_pkey PRIMARY KEY (id);
 L   ALTER TABLE ONLY public.special_orders DROP CONSTRAINT special_orders_pkey;
       public                 postgres    false    271                       2606    33111    suppliers suppliers_pkey 
   CONSTRAINT     V   ALTER TABLE ONLY public.suppliers
    ADD CONSTRAINT suppliers_pkey PRIMARY KEY (id);
 B   ALTER TABLE ONLY public.suppliers DROP CONSTRAINT suppliers_pkey;
       public                 postgres    false    273                       2606    33113    supplies supplies_pkey 
   CONSTRAINT     T   ALTER TABLE ONLY public.supplies
    ADD CONSTRAINT supplies_pkey PRIMARY KEY (id);
 @   ALTER TABLE ONLY public.supplies DROP CONSTRAINT supplies_pkey;
       public                 postgres    false    275                       2606    33115    supplies supplies_sku_unique 
   CONSTRAINT     V   ALTER TABLE ONLY public.supplies
    ADD CONSTRAINT supplies_sku_unique UNIQUE (sku);
 F   ALTER TABLE ONLY public.supplies DROP CONSTRAINT supplies_sku_unique;
       public                 postgres    false    275                       2606    33117     supply_stocks supply_stocks_pkey 
   CONSTRAINT     ^   ALTER TABLE ONLY public.supply_stocks
    ADD CONSTRAINT supply_stocks_pkey PRIMARY KEY (id);
 J   ALTER TABLE ONLY public.supply_stocks DROP CONSTRAINT supply_stocks_pkey;
       public                 postgres    false    277                       2606    33119    users users_email_unique 
   CONSTRAINT     T   ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_unique UNIQUE (email);
 B   ALTER TABLE ONLY public.users DROP CONSTRAINT users_email_unique;
       public                 postgres    false    279                       2606    33121    users users_pkey 
   CONSTRAINT     N   ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);
 :   ALTER TABLE ONLY public.users DROP CONSTRAINT users_pkey;
       public                 postgres    false    279                       2606    33123    warehouses warehouses_pkey 
   CONSTRAINT     X   ALTER TABLE ONLY public.warehouses
    ADD CONSTRAINT warehouses_pkey PRIMARY KEY (id);
 D   ALTER TABLE ONLY public.warehouses DROP CONSTRAINT warehouses_pkey;
       public                 postgres    false    281            o           1259    33124    cache_expiration_index    INDEX     N   CREATE INDEX cache_expiration_index ON public.cache USING btree (expiration);
 *   DROP INDEX public.cache_expiration_index;
       public                 postgres    false    217            r           1259    33125    cache_locks_expiration_index    INDEX     Z   CREATE INDEX cache_locks_expiration_index ON public.cache_locks USING btree (expiration);
 0   DROP INDEX public.cache_locks_expiration_index;
       public                 postgres    false    218                       1259    33126    jobs_queue_index    INDEX     B   CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue);
 $   DROP INDEX public.jobs_queue_index;
       public                 postgres    false    232                       1259    33127 /   model_has_permissions_model_id_model_type_index    INDEX        CREATE INDEX model_has_permissions_model_id_model_type_index ON public.model_has_permissions USING btree (model_id, model_type);
 C   DROP INDEX public.model_has_permissions_model_id_model_type_index;
       public                 postgres    false    236    236                       1259    33128 )   model_has_roles_model_id_model_type_index    INDEX     u   CREATE INDEX model_has_roles_model_id_model_type_index ON public.model_has_roles USING btree (model_id, model_type);
 =   DROP INDEX public.model_has_roles_model_id_model_type_index;
       public                 postgres    false    237    237                       1259    33129    sessions_last_activity_index    INDEX     Z   CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity);
 0   DROP INDEX public.sessions_last_activity_index;
       public                 postgres    false    266                       1259    33130    sessions_user_id_index    INDEX     N   CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id);
 *   DROP INDEX public.sessions_user_id_index;
       public                 postgres    false    266                       2606    33131 6   cash_movements cash_movements_cash_register_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.cash_movements
    ADD CONSTRAINT cash_movements_cash_register_id_foreign FOREIGN KEY (cash_register_id) REFERENCES public.cash_registers(id) ON DELETE CASCADE;
 `   ALTER TABLE ONLY public.cash_movements DROP CONSTRAINT cash_movements_cash_register_id_foreign;
       public               postgres    false    221    219    4984                       2606    33136 -   cash_registers cash_registers_user_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.cash_registers
    ADD CONSTRAINT cash_registers_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
 W   ALTER TABLE ONLY public.cash_registers DROP CONSTRAINT cash_registers_user_id_foreign;
       public               postgres    false    279    5071    221                       2606    33141 '   categories categories_parent_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_parent_id_foreign FOREIGN KEY (parent_id) REFERENCES public.categories(id) ON DELETE CASCADE;
 Q   ALTER TABLE ONLY public.categories DROP CONSTRAINT categories_parent_id_foreign;
       public               postgres    false    223    223    4986                       2606    33146 9   inventory_movements inventory_movements_supply_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.inventory_movements
    ADD CONSTRAINT inventory_movements_supply_id_foreign FOREIGN KEY (supply_id) REFERENCES public.supplies(id) ON DELETE CASCADE;
 c   ALTER TABLE ONLY public.inventory_movements DROP CONSTRAINT inventory_movements_supply_id_foreign;
       public               postgres    false    229    5063    275                       2606    33151 <   inventory_movements inventory_movements_warehouse_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.inventory_movements
    ADD CONSTRAINT inventory_movements_warehouse_id_foreign FOREIGN KEY (warehouse_id) REFERENCES public.warehouses(id) ON DELETE CASCADE;
 f   ALTER TABLE ONLY public.inventory_movements DROP CONSTRAINT inventory_movements_warehouse_id_foreign;
       public               postgres    false    281    5073    229                       2606    33156 A   model_has_permissions model_has_permissions_permission_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.model_has_permissions
    ADD CONSTRAINT model_has_permissions_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;
 k   ALTER TABLE ONLY public.model_has_permissions DROP CONSTRAINT model_has_permissions_permission_id_foreign;
       public               postgres    false    5021    236    245                       2606    33161 /   model_has_roles model_has_roles_role_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.model_has_roles
    ADD CONSTRAINT model_has_roles_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;
 Y   ALTER TABLE ONLY public.model_has_roles DROP CONSTRAINT model_has_roles_role_id_foreign;
       public               postgres    false    237    5047    264                       2606    33166 (   order_items order_items_order_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.orders(id) ON DELETE CASCADE;
 R   ALTER TABLE ONLY public.order_items DROP CONSTRAINT order_items_order_id_foreign;
       public               postgres    false    240    238    5013                       2606    33171 2   order_items order_items_product_variant_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.order_items
    ADD CONSTRAINT order_items_product_variant_id_foreign FOREIGN KEY (product_variant_id) REFERENCES public.product_variants(id) ON DELETE SET NULL;
 \   ALTER TABLE ONLY public.order_items DROP CONSTRAINT order_items_product_variant_id_foreign;
       public               postgres    false    251    5027    238                       2606    33176 !   orders orders_customer_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE SET NULL;
 K   ALTER TABLE ONLY public.orders DROP CONSTRAINT orders_customer_id_foreign;
       public               postgres    false    240    4990    225                       2606    33181    orders orders_user_id_foreign    FK CONSTRAINT     |   ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id);
 G   ALTER TABLE ONLY public.orders DROP CONSTRAINT orders_user_id_foreign;
       public               postgres    false    279    240    5071                       2606    33186 "   payments payments_order_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.payments
    ADD CONSTRAINT payments_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.orders(id) ON DELETE CASCADE;
 L   ALTER TABLE ONLY public.payments DROP CONSTRAINT payments_order_id_foreign;
       public               postgres    false    5013    240    243                       2606    33191 0   product_images product_images_product_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.product_images
    ADD CONSTRAINT product_images_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;
 Z   ALTER TABLE ONLY public.product_images DROP CONSTRAINT product_images_product_id_foreign;
       public               postgres    false    253    247    5031                       2606    33196 I   product_transformations product_transformations_source_variant_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.product_transformations
    ADD CONSTRAINT product_transformations_source_variant_id_foreign FOREIGN KEY (source_variant_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;
 s   ALTER TABLE ONLY public.product_transformations DROP CONSTRAINT product_transformations_source_variant_id_foreign;
       public               postgres    false    5027    249    251                       2606    33201 I   product_transformations product_transformations_target_variant_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.product_transformations
    ADD CONSTRAINT product_transformations_target_variant_id_foreign FOREIGN KEY (target_variant_id) REFERENCES public.product_variants(id) ON DELETE CASCADE;
 s   ALTER TABLE ONLY public.product_transformations DROP CONSTRAINT product_transformations_target_variant_id_foreign;
       public               postgres    false    251    249    5027                       2606    33206 ?   product_transformations product_transformations_user_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.product_transformations
    ADD CONSTRAINT product_transformations_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;
 i   ALTER TABLE ONLY public.product_transformations DROP CONSTRAINT product_transformations_user_id_foreign;
       public               postgres    false    279    5071    249                       2606    33211 4   product_variants product_variants_product_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.product_variants
    ADD CONSTRAINT product_variants_product_id_foreign FOREIGN KEY (product_id) REFERENCES public.products(id) ON DELETE CASCADE;
 ^   ALTER TABLE ONLY public.product_variants DROP CONSTRAINT product_variants_product_id_foreign;
       public               postgres    false    5031    251    253                       2606    33216 %   products products_category_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_category_id_foreign FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE CASCADE;
 O   ALTER TABLE ONLY public.products DROP CONSTRAINT products_category_id_foreign;
       public               postgres    false    253    4986    223                       2606    33221 1   purchase_items purchase_items_purchase_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.purchase_items
    ADD CONSTRAINT purchase_items_purchase_id_foreign FOREIGN KEY (purchase_id) REFERENCES public.purchases(id) ON DELETE CASCADE;
 [   ALTER TABLE ONLY public.purchase_items DROP CONSTRAINT purchase_items_purchase_id_foreign;
       public               postgres    false    257    5037    255                       2606    33226 /   purchase_items purchase_items_supply_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.purchase_items
    ADD CONSTRAINT purchase_items_supply_id_foreign FOREIGN KEY (supply_id) REFERENCES public.supplies(id) ON DELETE RESTRICT;
 Y   ALTER TABLE ONLY public.purchase_items DROP CONSTRAINT purchase_items_supply_id_foreign;
       public               postgres    false    275    255    5063                       2606    33231 '   purchases purchases_supplier_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.purchases
    ADD CONSTRAINT purchases_supplier_id_foreign FOREIGN KEY (supplier_id) REFERENCES public.suppliers(id) ON DELETE RESTRICT;
 Q   ALTER TABLE ONLY public.purchases DROP CONSTRAINT purchases_supplier_id_foreign;
       public               postgres    false    257    5061    273                       2606    33236 #   purchases purchases_user_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.purchases
    ADD CONSTRAINT purchases_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE SET NULL;
 M   ALTER TABLE ONLY public.purchases DROP CONSTRAINT purchases_user_id_foreign;
       public               postgres    false    5071    279    257                       2606    33241 (   purchases purchases_warehouse_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.purchases
    ADD CONSTRAINT purchases_warehouse_id_foreign FOREIGN KEY (warehouse_id) REFERENCES public.warehouses(id) ON DELETE RESTRICT;
 R   ALTER TABLE ONLY public.purchases DROP CONSTRAINT purchases_warehouse_id_foreign;
       public               postgres    false    257    281    5073                       2606    33246 7   recipe_ingredients recipe_ingredients_recipe_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.recipe_ingredients
    ADD CONSTRAINT recipe_ingredients_recipe_id_foreign FOREIGN KEY (recipe_id) REFERENCES public.recipes(id) ON DELETE CASCADE;
 a   ALTER TABLE ONLY public.recipe_ingredients DROP CONSTRAINT recipe_ingredients_recipe_id_foreign;
       public               postgres    false    259    5041    261                       2606    33251 7   recipe_ingredients recipe_ingredients_supply_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.recipe_ingredients
    ADD CONSTRAINT recipe_ingredients_supply_id_foreign FOREIGN KEY (supply_id) REFERENCES public.supplies(id) ON DELETE RESTRICT;
 a   ALTER TABLE ONLY public.recipe_ingredients DROP CONSTRAINT recipe_ingredients_supply_id_foreign;
       public               postgres    false    275    259    5063                       2606    33256 *   recipes recipes_product_variant_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.recipes
    ADD CONSTRAINT recipes_product_variant_id_foreign FOREIGN KEY (product_variant_id) REFERENCES public.product_variants(id) ON DELETE SET NULL;
 T   ALTER TABLE ONLY public.recipes DROP CONSTRAINT recipes_product_variant_id_foreign;
       public               postgres    false    251    5027    261                       2606    33261 ?   role_has_permissions role_has_permissions_permission_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;
 i   ALTER TABLE ONLY public.role_has_permissions DROP CONSTRAINT role_has_permissions_permission_id_foreign;
       public               postgres    false    245    5021    263                       2606    33266 9   role_has_permissions role_has_permissions_role_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;
 c   ALTER TABLE ONLY public.role_has_permissions DROP CONSTRAINT role_has_permissions_role_id_foreign;
       public               postgres    false    264    263    5047                       2606    33271 B   special_order_items special_order_items_product_variant_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.special_order_items
    ADD CONSTRAINT special_order_items_product_variant_id_foreign FOREIGN KEY (product_variant_id) REFERENCES public.product_variants(id) ON DELETE RESTRICT;
 l   ALTER TABLE ONLY public.special_order_items DROP CONSTRAINT special_order_items_product_variant_id_foreign;
       public               postgres    false    251    5027    269                       2606    33276 @   special_order_items special_order_items_special_order_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.special_order_items
    ADD CONSTRAINT special_order_items_special_order_id_foreign FOREIGN KEY (special_order_id) REFERENCES public.special_orders(id) ON DELETE CASCADE;
 j   ALTER TABLE ONLY public.special_order_items DROP CONSTRAINT special_order_items_special_order_id_foreign;
       public               postgres    false    269    271    5059                       2606    33281 1   special_orders special_orders_customer_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.special_orders
    ADD CONSTRAINT special_orders_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE RESTRICT;
 [   ALTER TABLE ONLY public.special_orders DROP CONSTRAINT special_orders_customer_id_foreign;
       public               postgres    false    4990    271    225                       2606    33286 %   supplies supplies_supplier_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.supplies
    ADD CONSTRAINT supplies_supplier_id_foreign FOREIGN KEY (supplier_id) REFERENCES public.suppliers(id) ON DELETE SET NULL;
 O   ALTER TABLE ONLY public.supplies DROP CONSTRAINT supplies_supplier_id_foreign;
       public               postgres    false    5061    273    275                       2606    33291 -   supply_stocks supply_stocks_supply_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.supply_stocks
    ADD CONSTRAINT supply_stocks_supply_id_foreign FOREIGN KEY (supply_id) REFERENCES public.supplies(id) ON DELETE CASCADE;
 W   ALTER TABLE ONLY public.supply_stocks DROP CONSTRAINT supply_stocks_supply_id_foreign;
       public               postgres    false    5063    275    277                       2606    33296 0   supply_stocks supply_stocks_warehouse_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.supply_stocks
    ADD CONSTRAINT supply_stocks_warehouse_id_foreign FOREIGN KEY (warehouse_id) REFERENCES public.warehouses(id) ON DELETE CASCADE;
 Z   ALTER TABLE ONLY public.supply_stocks DROP CONSTRAINT supply_stocks_warehouse_id_foreign;
       public               postgres    false    5073    281    277                 x]0_$T׏bTAtd%>
(8Nsr(E[L?z,A9!2GZo ϙܖ5,Tτ}&IjZ%^9ܠqvV+Mc큉L}רLdIdǳB%ps,Cl,ѕ3r\|Hq3|%k<'IQ)Ni9s%iouEE	ט9m{qvsQ^f ުN?$-xވ%E뛱:\=F; ^|Kph5}\FL][|#1w.pu;jY+EPALzq-f]DCQ'oUL<l8Y,,d`3؟z!؀U,TK%~p/X8.D5c^>5Nr"xB֔PĭfƆɃ4C);"*TݾעiO+:Ñ>F5+=Tgd2=5Sri)X+QzpCW{9Uogggh0X㺥N&8Iն`ne|>!|rk8OUTWKQY~1ر{\ۑ9ݷNA.5 'CaBqˋ_<8圄8mf#R-77,."~>            x              x           5   x34/H4304202505T02!K0,b\1z\\\            x1n0ٜ2RV11Vc DUtr8M+02O|R=%}kpt32^0C)"F`f^Itw`t#l`:sjMSMO(LXNk.o?8?Q
;So
_$0C49=׳ti+~ۙⰕwj9ef`3t7mjy%5/yl,߇EӐf@d @qPPvRIB]{:?t7㵏#k?/<XE$>|I$Xz>]4O_z~H~i_E+מ_:_bm dpxH˾           xMj0|
]fF*!"4-]ec'l=G.V$`o6O#>%-;nk;8eNn}vY=$$/Ö+aT
<E
LS0CTw@+-w*QHv]|ن>5@7yv "cD 0gD1_aNa+)<Tx"|E8EWHP**^ѾCE+WSLx%)yъU+ῖ$I             x             x͔AK0ݧxE+M]o2Qsq [MFڊ_ǣgo^|V,%KfmjE)= o1mhX	jxtp^%,eSm*	sڇ˱ZYjB.3Q+QaB/a&ۗa"`fR⎝*Qו4"L0bщda&k[{Lv_I"#B2`W/{y	Nu.0R|D)<lC<gj+Fv[	ʽ}Ϩ3(qBCkmF94ݥYpkS
flJh?aKǾ5Ks?	ʕi,h6C*9u5<mc#{khxg->z            x              x             xَ T6w$"3>}=YfE.cPQ[ZAE@!4SH!9@v!]`howTFM~1ԊF*rew'޴wz̢\LXg/87gR;ɡ_4>T!A͎qj`z֜e	yۻ,N%6.zBZYFۤE;dzUt$)ero Y4lBpӸzp=Ml(Ō4{"Bu*ׯTM ̸F{ͅxbR;+!@8Efl()"0_׾wAԫqt,@RlYloLeåC$sS t+uE$W#ׅ7W^"ꚶ}[j[n'W&mTK#
U*rf'E`AF; Jj7x7:|QʲfiCWv,sVXvo:B[%1]0wGzDv!z-asه9M?#dL9b ; !>KY v*
~2ji5.Kx;BvP            x           (   x3t,(OI)	-N-42"j 1            x˩1EU2g"RA#
yp;R
!^O?HLd$͚*4VƩ95t$nxn ʲ+{*J?U$D,CFaϰlwugSg(	$`u}w>Y3Eu͚UEﷁyOwf}?󯫵GG            xn0{"q4G<G.aڦQޟ!M꥿OD%`8i0_a@)Aq$ߜ=Ώ#arhlns*NU:V!n@TWzqr2>;Ub'sY h!ޅp5{?o.F@\|=hTGdAڠ5aATD^C̟            x              x           o   x; z9PȚ^:I4a\I䀋&@]e2Vףm)ӥvXFm^Y"2߅4Gϡȷ@7)~\v|R/t|H            xmKr0  ur^@$dW""(~Xz.d6ATRyՌ~ʵ|v;}MY8ҿ!вV@@t$3A8+IGmkjbOE7hN I5Kj.ؾBTtm?^1N#,3$\$0d9Ɇ$<pTpzmk8nKPD!5'Dl2xZBl            x              xӱj0Slt'ffqИ@ct1nqRb$NswD-ǆazU2,fY%ˌpyԆBsJbKˈaa>#v=ey05qXĲ>{%EuܱL<[I3utwF.zX!=*%Ւ*%NV)(WKV)ExR5*Շa=X+%}[YR           xn )x@>Ll&iP[G:}+vm &%'EA1xU#u4cW-zzѰn]l6_mkl|Z0?o޻@,hvo&1)1%{wIn-&JmK:7ګOxtFϬivrb:x:xv<SQ*d6iL54eW+%?pгEKo0̵VIZk%%atVH
>y#081<G_~_!UC^|B,%2bI2'd<!'d!"!'dȈ!2'd*QOȨ"FĨ5:bI:D/v]QG6            xm0)/۳t9-ܗ/B$Lx>>&Iv7k`H`P(<@K]nX"AV:c$#ZjNt谁oQD&;a,3b@:b,~UlP?b\oY[r])r7kKt#INSn֖"&T~{Z،            x;n1D)kPH}ql!p 9&^-6E xq&?m&#	s~/߽BT(i.od 0yyf Z}D: 0	f)`ŵCJPE	P"r4CeDB6JkcKXot}'E47x¼9U~S©ixp 8o_            xһ1 Ork|%} "
/)g5$|M]rR*TM$~OiI-ROdU~oi1A0ݚt☨\PN?=jһBmY^YCbՑWfW9I9m|&ᤕK^&~@5i%wXpOꅻJv)g$ʬ78YϩbE         C  xԽn0~
@^SUcX-őS>B^C+lnCGGN?B:7zt<
JԷ#;F	UVU=?G;r45c#1|IoUzY&	/G=VriPc56A+緡[3Pك54~Hj6~^y🁰RF̡KNH\bi5O3xH3DL3d J3TN3tI3LFfUQe`6fpT>_         +   x 0wnJ@؆hl5Pr86|e         K   x3LJN-,OM42025050V002226&eęXI.cļtup&f摤'F m.[           x͔K8ɯ`-0ϠV/ <Ci0U`*) vYz3*@
QLUhU6Q`uS}f@Px즊Q~/Qn8qcEƍ[lWeQ}/VuE^w_u5#[{Jӷ,;%bQτ3*Kͧ
2	jMjD1>P^~M8+
$@+BNb5%ͥ,FHw=wV'%Vq`#]FvJObYc}Ԍe.|g^꣫&tR)D/:y{$X4Fv	'T"#.l:p7d4=
n%|}TU$-,\p(3aSGs~NjxQ'[%7hr
bA|vאcquA1:fb8݃XPplX#wZз=Y^]200MX@}]=NYelĠO@~	c<W⋥YlV@SÀuY/zBmfb%N«/Sė:4(v^@>.~%HT"{|*/?b'           x]o0_dHii6ER6RAn1yP'e8֪DfBN(d,B"lf	/i,`i1z7DZ":)ߕX\%Zk!ss6(pWe!̅jrФ>J4l0a*%>LRk^>a1_~-e̟o3;U?q>5k{            x              x             xn@܍NAnr,J>Qzzu)K(U1#$`1GT
mm5zV.iCr=}zXM6eЪ+ilE0"e4el~H
ϼ(VA(tojOsPN,slvekIYS3:_li$Pwc{7)g}xD)ų>I4>FOKԹԶ{rs`}}Zrc@
yV(;_~RBͩ<*d6TBRAD`gYXAXMUR8"+Sy٬oD01 cSy[)={/&<&`<Xh&01 Xxbd%K,X~Lƣa 2l         C  xMO 3|
.DJ
veM/O:}@C16x8 T0[0L,6inh-E{V{QiX3CPq9CkeSY]e2_̒ˡ`smu7H̊eT*'hSeUEUp{@7.}䱩#r`lLHԋ(kD^|zQDEU*wT.DEZ/6Q׋
Yn!71         q   xϻ@,KWLhk4HOQHp~;!a/uXj:(g*/iAxt|Ioc}hb8           xmOs0)8xI^
'u cjEvDAKEGo=̾.k!].eqRL.-0#>(VNʹy!/Gwj<#ݣsOylDw&DJ?:%,{E&X&!jq*e@׬Cpx:!Zl/7f72XAT1٤ɂ51hoWoB1o&iW/wG ĲntUU?}k           xӽj0Y~
1@EVv0Ce/Py!lwB\#?ylk~L$H[p0^*onk`W*'wHz^kZ4o)y~Byd[=M;	zѐO/[Hs1/̷ԇg~%ƃ&JJBYUjjm Ь)d-b-B!Ѭ+d64-b[mX`ު9     