PGDMP  :                    ~            licencia_panaderia    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    66536    licencia_panaderia    DATABASE        CREATE DATABASE licencia_panaderia WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'Spanish_Peru.1252';
 "   DROP DATABASE licencia_panaderia;
                     postgres    false                        1259    66831    activaciones    TABLE       CREATE TABLE public.activaciones (
    id bigint NOT NULL,
    licencia_id bigint NOT NULL,
    ip_address character varying(255),
    mac_address character varying(255),
    estado character varying(255) NOT NULL,
    detalles text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT activaciones_estado_check CHECK (((estado)::text = ANY ((ARRAY['EXITO'::character varying, 'ERROR'::character varying, 'BLOQUEADO'::character varying])::text[])))
);
     DROP TABLE public.activaciones;
       public         heap r       postgres    false                        1259    66830    activaciones_id_seq    SEQUENCE     |   CREATE SEQUENCE public.activaciones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 *   DROP SEQUENCE public.activaciones_id_seq;
       public               postgres    false    235                       0    0    activaciones_id_seq    SEQUENCE OWNED BY     K   ALTER SEQUENCE public.activaciones_id_seq OWNED BY public.activaciones.id;
          public               postgres    false    234                        1259    66753    cache    TABLE        CREATE TABLE public.cache (
    key character varying(255) NOT NULL,
    value text NOT NULL,
    expiration bigint NOT NULL
);
    DROP TABLE public.cache;
       public         heap r       postgres    false                        1259    66761    cache_locks    TABLE        CREATE TABLE public.cache_locks (
    key character varying(255) NOT NULL,
    owner character varying(255) NOT NULL,
    expiration bigint NOT NULL
);
    DROP TABLE public.cache_locks;
       public         heap r       postgres    false                        1259    66861    configuraciones    TABLE     ]  CREATE TABLE public.configuraciones (
    id bigint NOT NULL,
    nombre_proveedor character varying(255) NOT NULL,
    email_contacto character varying(255),
    telefono_contacto character varying(255),
    secret_key character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);
 #   DROP TABLE public.configuraciones;
       public         heap r       postgres    false                       0    0 !   COLUMN configuraciones.secret_key    COMMENT     X   COMMENT ON COLUMN public.configuraciones.secret_key IS 'HMAC Key global o por defecto';
          public               postgres    false    239                        1259    66860    configuraciones_id_seq    SEQUENCE        CREATE SEQUENCE public.configuraciones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 -   DROP SEQUENCE public.configuraciones_id_seq;
       public               postgres    false    239                       0    0    configuraciones_id_seq    SEQUENCE OWNED BY     Q   ALTER SEQUENCE public.configuraciones_id_seq OWNED BY public.configuraciones.id;
          public               postgres    false    238                        1259    66799    empresas    TABLE     i  CREATE TABLE public.empresas (
    id bigint NOT NULL,
    razon_social character varying(255) NOT NULL,
    ruc character varying(20) NOT NULL,
    responsable character varying(255),
    email character varying(255),
    telefono character varying(255),
    direccion character varying(255),
    estado character varying(255) DEFAULT 'ACTIVO'::character varying NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT empresas_estado_check CHECK (((estado)::text = ANY ((ARRAY['ACTIVO'::character varying, 'INACTIVO'::character varying])::text[])))
);
    DROP TABLE public.empresas;
       public         heap r       postgres    false                        1259    66798    empresas_id_seq    SEQUENCE     x   CREATE SEQUENCE public.empresas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 &   DROP SEQUENCE public.empresas_id_seq;
       public               postgres    false    231                       0    0    empresas_id_seq    SEQUENCE OWNED BY     C   ALTER SEQUENCE public.empresas_id_seq OWNED BY public.empresas.id;
          public               postgres    false    230                        1259    66787    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    66786    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    229                       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    66779    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    66770    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    66769    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    226                       0    0    jobs_id_seq    SEQUENCE OWNED BY     ;   ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;
          public               postgres    false    225                        1259    66812 	   licencias    TABLE       CREATE TABLE public.licencias (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    clave_licencia character varying(255) NOT NULL,
    tipo character varying(255) NOT NULL,
    fecha_inicio date NOT NULL,
    fecha_vencimiento date NOT NULL,
    estado character varying(255) DEFAULT 'ACTIVA'::character varying NOT NULL,
    mac_address character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT licencias_estado_check CHECK (((estado)::text = ANY ((ARRAY['ACTIVA'::character varying, 'VENCIDA'::character varying, 'SUSPENDIDA'::character varying])::text[])))
);
    DROP TABLE public.licencias;
       public         heap r       postgres    false                       0    0    COLUMN licencias.mac_address    COMMENT     T   COMMENT ON COLUMN public.licencias.mac_address IS 'Enlazada al equipo del cliente';
          public               postgres    false    233                        1259    66811    licencias_id_seq    SEQUENCE     y   CREATE SEQUENCE public.licencias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 '   DROP SEQUENCE public.licencias_id_seq;
       public               postgres    false    233                       0    0    licencias_id_seq    SEQUENCE OWNED BY     E   ALTER SEQUENCE public.licencias_id_seq OWNED BY public.licencias.id;
          public               postgres    false    232                        1259    66720 
   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    66719    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    218                       0    0    migrations_id_seq    SEQUENCE OWNED BY     G   ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id;
          public               postgres    false    217                        1259    66846    pagos    TABLE     {  CREATE TABLE public.pagos (
    id bigint NOT NULL,
    licencia_id bigint NOT NULL,
    monto numeric(10,2) NOT NULL,
    metodo_pago character varying(255) NOT NULL,
    comprobante character varying(255),
    num_operacion character varying(255),
    fecha_pago date NOT NULL,
    notas text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT pagos_metodo_pago_check CHECK (((metodo_pago)::text = ANY ((ARRAY['TRANSFERENCIA'::character varying, 'EFECTIVO'::character varying, 'YAPE'::character varying, 'PLIN'::character varying, 'OTROS'::character varying])::text[])))
);
    DROP TABLE public.pagos;
       public         heap r       postgres    false                        1259    66845    pagos_id_seq    SEQUENCE     u   CREATE SEQUENCE public.pagos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 #   DROP SEQUENCE public.pagos_id_seq;
       public               postgres    false    237                       0    0    pagos_id_seq    SEQUENCE OWNED BY     =   ALTER SEQUENCE public.pagos_id_seq OWNED BY public.pagos.id;
          public               postgres    false    236                        1259    66737    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    66744    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    66727    users    TABLE     x  CREATE TABLE public.users (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    email character varying(255) 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    66726    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    220                       0    0    users_id_seq    SEQUENCE OWNED BY     =   ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
          public               postgres    false    219                       2604    66834    activaciones id    DEFAULT     r   ALTER TABLE ONLY public.activaciones ALTER COLUMN id SET DEFAULT nextval('public.activaciones_id_seq'::regclass);
 >   ALTER TABLE public.activaciones ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    234    235    235                       2604    66864    configuraciones id    DEFAULT     x   ALTER TABLE ONLY public.configuraciones ALTER COLUMN id SET DEFAULT nextval('public.configuraciones_id_seq'::regclass);
 A   ALTER TABLE public.configuraciones ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    238    239    239                       2604    66802    empresas id    DEFAULT     j   ALTER TABLE ONLY public.empresas ALTER COLUMN id SET DEFAULT nextval('public.empresas_id_seq'::regclass);
 :   ALTER TABLE public.empresas ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    230    231    231                       2604    66790    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    229    229                       2604    66773    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    226    225    226                       2604    66815    licencias id    DEFAULT     l   ALTER TABLE ONLY public.licencias ALTER COLUMN id SET DEFAULT nextval('public.licencias_id_seq'::regclass);
 ;   ALTER TABLE public.licencias ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    232    233    233                       2604    66723    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    218    217    218                       2604    66849    pagos id    DEFAULT     d   ALTER TABLE ONLY public.pagos ALTER COLUMN id SET DEFAULT nextval('public.pagos_id_seq'::regclass);
 7   ALTER TABLE public.pagos ALTER COLUMN id DROP DEFAULT;
       public               postgres    false    237    236    237                       2604    66730    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    220    219    220                      0    66831    activaciones 
   TABLE DATA           z   COPY public.activaciones (id, licencia_id, ip_address, mac_address, estado, detalles, created_at, updated_at) FROM stdin;
    public               postgres    false    235   v                 0    66753    cache 
   TABLE DATA           7   COPY public.cache (key, value, expiration) FROM stdin;
    public               postgres    false    223   w                 0    66761    cache_locks 
   TABLE DATA           =   COPY public.cache_locks (key, owner, expiration) FROM stdin;
    public               postgres    false    224   )w                 0    66861    configuraciones 
   TABLE DATA              COPY public.configuraciones (id, nombre_proveedor, email_contacto, telefono_contacto, secret_key, created_at, updated_at) FROM stdin;
    public               postgres    false    239   Fw                 0    66799    empresas 
   TABLE DATA              COPY public.empresas (id, razon_social, ruc, responsable, email, telefono, direccion, estado, created_at, updated_at) FROM stdin;
    public               postgres    false    231   w                 0    66787    failed_jobs 
   TABLE DATA           a   COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin;
    public               postgres    false    229   Hx                 0    66779    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    227   ex                 0    66770    jobs 
   TABLE DATA           c   COPY public.jobs (id, queue, payload, attempts, reserved_at, available_at, created_at) FROM stdin;
    public               postgres    false    226   x                 0    66812 	   licencias 
   TABLE DATA              COPY public.licencias (id, empresa_id, clave_licencia, tipo, fecha_inicio, fecha_vencimiento, estado, mac_address, created_at, updated_at) FROM stdin;
    public               postgres    false    233   x                 0    66720 
   migrations 
   TABLE DATA           :   COPY public.migrations (id, migration, batch) FROM stdin;
    public               postgres    false    218   y                 0    66846    pagos 
   TABLE DATA              COPY public.pagos (id, licencia_id, monto, metodo_pago, comprobante, num_operacion, fecha_pago, notas, created_at, updated_at) FROM stdin;
    public               postgres    false    237   nz                 0    66737    password_reset_tokens 
   TABLE DATA           I   COPY public.password_reset_tokens (email, token, created_at) FROM stdin;
    public               postgres    false    221   z                 0    66744    sessions 
   TABLE DATA           _   COPY public.sessions (id, user_id, ip_address, user_agent, payload, last_activity) FROM stdin;
    public               postgres    false    222   z                 0    66727    users 
   TABLE DATA           u   COPY public.users (id, name, email, email_verified_at, password, remember_token, created_at, updated_at) FROM stdin;
    public               postgres    false    220   z                  0    0    activaciones_id_seq    SEQUENCE SET     B   SELECT pg_catalog.setval('public.activaciones_id_seq', 1, false);
          public               postgres    false    234                       0    0    configuraciones_id_seq    SEQUENCE SET     D   SELECT pg_catalog.setval('public.configuraciones_id_seq', 1, true);
          public               postgres    false    238                       0    0    empresas_id_seq    SEQUENCE SET     =   SELECT pg_catalog.setval('public.empresas_id_seq', 1, true);
          public               postgres    false    230                       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    jobs_id_seq    SEQUENCE SET     :   SELECT pg_catalog.setval('public.jobs_id_seq', 1, false);
          public               postgres    false    225                       0    0    licencias_id_seq    SEQUENCE SET     >   SELECT pg_catalog.setval('public.licencias_id_seq', 3, true);
          public               postgres    false    232                       0    0    migrations_id_seq    SEQUENCE SET     ?   SELECT pg_catalog.setval('public.migrations_id_seq', 8, true);
          public               postgres    false    217                       0    0    pagos_id_seq    SEQUENCE SET     ;   SELECT pg_catalog.setval('public.pagos_id_seq', 1, false);
          public               postgres    false    236                       0    0    users_id_seq    SEQUENCE SET     :   SELECT pg_catalog.setval('public.users_id_seq', 1, true);
          public               postgres    false    219                       2606    66839    activaciones activaciones_pkey 
   CONSTRAINT     \   ALTER TABLE ONLY public.activaciones
    ADD CONSTRAINT activaciones_pkey PRIMARY KEY (id);
 H   ALTER TABLE ONLY public.activaciones DROP CONSTRAINT activaciones_pkey;
       public                 postgres    false    235                       2606    66767    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    224                       2606    66759    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    223                       2606    66868 $   configuraciones configuraciones_pkey 
   CONSTRAINT     b   ALTER TABLE ONLY public.configuraciones
    ADD CONSTRAINT configuraciones_pkey PRIMARY KEY (id);
 N   ALTER TABLE ONLY public.configuraciones DROP CONSTRAINT configuraciones_pkey;
       public                 postgres    false    239                       2606    66808    empresas empresas_pkey 
   CONSTRAINT     T   ALTER TABLE ONLY public.empresas
    ADD CONSTRAINT empresas_pkey PRIMARY KEY (id);
 @   ALTER TABLE ONLY public.empresas DROP CONSTRAINT empresas_pkey;
       public                 postgres    false    231                       2606    66810    empresas empresas_ruc_unique 
   CONSTRAINT     V   ALTER TABLE ONLY public.empresas
    ADD CONSTRAINT empresas_ruc_unique UNIQUE (ruc);
 F   ALTER TABLE ONLY public.empresas DROP CONSTRAINT empresas_ruc_unique;
       public                 postgres    false    231                       2606    66795    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    229                       2606    66797 #   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    229                       2606    66785    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    227                       2606    66777    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    226                       2606    66829 )   licencias licencias_clave_licencia_unique 
   CONSTRAINT     n   ALTER TABLE ONLY public.licencias
    ADD CONSTRAINT licencias_clave_licencia_unique UNIQUE (clave_licencia);
 S   ALTER TABLE ONLY public.licencias DROP CONSTRAINT licencias_clave_licencia_unique;
       public                 postgres    false    233                       2606    66822    licencias licencias_pkey 
   CONSTRAINT     V   ALTER TABLE ONLY public.licencias
    ADD CONSTRAINT licencias_pkey PRIMARY KEY (id);
 B   ALTER TABLE ONLY public.licencias DROP CONSTRAINT licencias_pkey;
       public                 postgres    false    233                       2606    66725    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    218                       2606    66854    pagos pagos_pkey 
   CONSTRAINT     N   ALTER TABLE ONLY public.pagos
    ADD CONSTRAINT pagos_pkey PRIMARY KEY (id);
 :   ALTER TABLE ONLY public.pagos DROP CONSTRAINT pagos_pkey;
       public                 postgres    false    237                       2606    66743 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    221                       2606    66750    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    222                       2606    66736    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    220                       2606    66734    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    220                       1259    66760    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    223                       1259    66768    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    224                       1259    66778    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    226                       1259    66752    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    222                       1259    66751    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    222                       2606    66840 -   activaciones activaciones_licencia_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.activaciones
    ADD CONSTRAINT activaciones_licencia_id_foreign FOREIGN KEY (licencia_id) REFERENCES public.licencias(id) ON DELETE CASCADE;
 W   ALTER TABLE ONLY public.activaciones DROP CONSTRAINT activaciones_licencia_id_foreign;
       public               postgres    false    233    235    4852                       2606    66823 &   licencias licencias_empresa_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.licencias
    ADD CONSTRAINT licencias_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.empresas(id) ON DELETE CASCADE;
 P   ALTER TABLE ONLY public.licencias DROP CONSTRAINT licencias_empresa_id_foreign;
       public               postgres    false    231    233    4846                       2606    66855    pagos pagos_licencia_id_foreign    FK CONSTRAINT        ALTER TABLE ONLY public.pagos
    ADD CONSTRAINT pagos_licencia_id_foreign FOREIGN KEY (licencia_id) REFERENCES public.licencias(id) ON DELETE CASCADE;
 I   ALTER TABLE ONLY public.pagos DROP CONSTRAINT pagos_licencia_id_foreign;
       public               postgres    false    4852    237    233                  x              x              x           }   x3tI-N,*IL/RHIUO+)O,JLLsLNKL,K65T40P0` ? CxCgc?g #98$82ȄH 61=... 	%         e   x3trvT042ACβ"܂DC|\NKuTp:<93d61=...             x              x              x           $  xn@Ek
y9^w*vXؤHACrAjhtp)1`"z4uŧu>zʘmeڋoнNF	J4-
6($z(10/]lɕ#IahWN"%,EΜIC_p/(ڻZ0ggS$gPr]+SJL:ÞtdiԭfY3qm1AOd58uLŝ_EDju            xeQ g8Ø3ac>~Tv>a"(L)BBKàhQfti&ٶ|Hn C+̱+ };I)ߣj            x              x              x              x3tL,.)JL/Lr2S3s9c8U*UT+}ݫ}ҍ
JK+\B̼"B=|ݜ]͂Br|K3JAtLH W ̈́*'     