--
-- PostgreSQL database cluster dump
--

\restrict ZN2MWhcNcTjvXFY9gSwor7LGcQ0hNtYthj0apH0YhhlRVzaFmIYQKg82p4g83F5

SET default_transaction_read_only = off;


--
-- Roles
--

CREATE ROLE authenticator;
ALTER ROLE authenticator WITH NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'SCRAM-SHA-256$4096:eqEiH814IMujbF6UBPb8rw==$IvmLqliUceS7OlyT5y7lMqJd0B1L/wJ2KI9/HvWYrjg=:Cjgp+MxroClFe5Op7bsH1xE8270mBjMyts+E6IpTXh0=';
CREATE ROLE oc_admin;
ALTER ROLE oc_admin WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'SCRAM-SHA-256$4096:xrV70Q3lWEdkHaQor4CAkA==$q1QyWaUQc7LUPxhbQJiwyc7gbBx8V01lwM389Tb2tSA=:XQpQIudBj2LbNaTsfsMV8vorkV/jkuhCwobaUDERmvM=';
CREATE ROLE postgres;
ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS PASSWORD 'SCRAM-SHA-256$4096:8yIoO9SVZaCzbAXAD2pDMA==$jC/qBFqIKZ+itHQtzgf/WeJoUwVRV7kZhL5RRS/pKfI=:tLRyeKhTqLGc8yXUqajnsEJZLErfDLik+rjZKvuOTrQ=';
CREATE ROLE tzzr;
ALTER ROLE tzzr WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'SCRAM-SHA-256$4096:tW6oQod7QBwdr5YlShroSw==$5pvUIR6Hw4GtE5Ng4raxn5cNCkNtL2S/LjOsJMDAMuM=:wM/dvMgYF1VuTGBKvPKPPY7OQjQwCqVnYn9D+3T46T8=';
CREATE ROLE web_anon;
ALTER ROLE web_anon WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN NOREPLICATION NOBYPASSRLS;

--
-- User Configurations
--

--
-- User Config "tzzr"
--

ALTER ROLE tzzr SET search_path TO 'tzzr_core_hst', 'tzzr_core_itm_base', 'tzzr_core_secretaria', 'tzzr_core_oracle', 'tzzr_core_contabilidad', 'tzzr_core_administracion', 'tzzr_core_produccion', 'public';


--
-- Role memberships
--

GRANT web_anon TO authenticator GRANTED BY postgres;






\unrestrict ZN2MWhcNcTjvXFY9gSwor7LGcQ0hNtYthj0apH0YhhlRVzaFmIYQKg82p4g83F5

--
-- Databases
--

--
-- Database "template1" dump
--

\connect template1

--
--

\restrict iPX0DZxREpI6f9k3PsEZbOH7ZLxbRWCUd1mzX8d8GpjFZkxrtZuaxCImsESuAve


SELECT pg_catalog.set_config('search_path', '', false);

--
--

\unrestrict iPX0DZxREpI6f9k3PsEZbOH7ZLxbRWCUd1mzX8d8GpjFZkxrtZuaxCImsESuAve

--
-- Database "deck" dump
--

--
--

\restrict liiVB9h9uyn31lwdd7RW8IsPLxm769jcMxwEt0zV7T0ysEDpCr9qOlNKgMo1uLh


SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: deck; Type: DATABASE; Schema: -; Owner: tzzr
--

CREATE DATABASE deck WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LC_COLLATE = 'C' LC_CTYPE = 'C.UTF-8';


ALTER DATABASE deck OWNER TO tzzr;

\unrestrict liiVB9h9uyn31lwdd7RW8IsPLxm769jcMxwEt0zV7T0ysEDpCr9qOlNKgMo1uLh
\connect deck
\restrict liiVB9h9uyn31lwdd7RW8IsPLxm769jcMxwEt0zV7T0ysEDpCr9qOlNKgMo1uLh

SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: administracion_mason; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA administracion_mason;


ALTER SCHEMA administracion_mason OWNER TO postgres;

--
-- Name: contabilidad_feldman; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA contabilidad_feldman;


ALTER SCHEMA contabilidad_feldman OWNER TO postgres;

--
-- Name: mail_manager; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA mail_manager;


ALTER SCHEMA mail_manager OWNER TO postgres;

--
-- Name: production_alfred; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA production_alfred;


ALTER SCHEMA production_alfred OWNER TO postgres;

--
-- Name: secretaria_clara; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA secretaria_clara;


ALTER SCHEMA secretaria_clara OWNER TO postgres;



--
-- Name: graph_bck; Type: TABLE; Schema: administracion_mason; Owner: postgres
--

CREATE TABLE administracion_mason.graph_bck (
    num integer NOT NULL,
    mrf_a character varying(64) NOT NULL,
    mrf_b character varying(64) NOT NULL,
    weight double precision DEFAULT 0.5,
    edge_type character varying(32),
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE administracion_mason.graph_bck OWNER TO postgres;

--
-- Name: graph_bck_num_seq; Type: SEQUENCE; Schema: administracion_mason; Owner: postgres
--

CREATE SEQUENCE administracion_mason.graph_bck_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE administracion_mason.graph_bck_num_seq OWNER TO postgres;

--
-- Name: graph_bck_num_seq; Type: SEQUENCE OWNED BY; Schema: administracion_mason; Owner: postgres
--

ALTER SEQUENCE administracion_mason.graph_bck_num_seq OWNED BY administracion_mason.graph_bck.num;


--
-- Name: graph_mst; Type: TABLE; Schema: administracion_mason; Owner: postgres
--

CREATE TABLE administracion_mason.graph_mst (
    num integer NOT NULL,
    mrf_a character varying(64) NOT NULL,
    mrf_b character varying(64) NOT NULL,
    weight double precision DEFAULT 0.5,
    edge_type character varying(32),
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE administracion_mason.graph_mst OWNER TO postgres;

--
-- Name: graph_mst_num_seq; Type: SEQUENCE; Schema: administracion_mason; Owner: postgres
--

CREATE SEQUENCE administracion_mason.graph_mst_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE administracion_mason.graph_mst_num_seq OWNER TO postgres;

--
-- Name: graph_mst_num_seq; Type: SEQUENCE OWNED BY; Schema: administracion_mason; Owner: postgres
--

ALTER SEQUENCE administracion_mason.graph_mst_num_seq OWNED BY administracion_mason.graph_mst.num;


--
-- Name: library_bck; Type: TABLE; Schema: administracion_mason; Owner: postgres
--

CREATE TABLE administracion_mason.library_bck (
    num integer NOT NULL,
    mrf_library character varying(64) NOT NULL,
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE administracion_mason.library_bck OWNER TO postgres;

--
-- Name: library_bck_num_seq; Type: SEQUENCE; Schema: administracion_mason; Owner: postgres
--

CREATE SEQUENCE administracion_mason.library_bck_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE administracion_mason.library_bck_num_seq OWNER TO postgres;

--
-- Name: library_bck_num_seq; Type: SEQUENCE OWNED BY; Schema: administracion_mason; Owner: postgres
--

ALTER SEQUENCE administracion_mason.library_bck_num_seq OWNED BY administracion_mason.library_bck.num;


--
-- Name: library_mst; Type: TABLE; Schema: administracion_mason; Owner: postgres
--

CREATE TABLE administracion_mason.library_mst (
    num integer NOT NULL,
    mrf_library character varying(64) NOT NULL,
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE administracion_mason.library_mst OWNER TO postgres;

--
-- Name: library_mst_num_seq; Type: SEQUENCE; Schema: administracion_mason; Owner: postgres
--

CREATE SEQUENCE administracion_mason.library_mst_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE administracion_mason.library_mst_num_seq OWNER TO postgres;

--
-- Name: library_mst_num_seq; Type: SEQUENCE OWNED BY; Schema: administracion_mason; Owner: postgres
--

ALTER SEQUENCE administracion_mason.library_mst_num_seq OWNED BY administracion_mason.library_mst.num;


--
-- Name: tree_bck; Type: TABLE; Schema: administracion_mason; Owner: postgres
--

CREATE TABLE administracion_mason.tree_bck (
    num integer NOT NULL,
    mrf_parent character varying(64),
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE administracion_mason.tree_bck OWNER TO postgres;

--
-- Name: tree_bck_num_seq; Type: SEQUENCE; Schema: administracion_mason; Owner: postgres
--

CREATE SEQUENCE administracion_mason.tree_bck_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE administracion_mason.tree_bck_num_seq OWNER TO postgres;

--
-- Name: tree_bck_num_seq; Type: SEQUENCE OWNED BY; Schema: administracion_mason; Owner: postgres
--

ALTER SEQUENCE administracion_mason.tree_bck_num_seq OWNED BY administracion_mason.tree_bck.num;


--
-- Name: tree_mst; Type: TABLE; Schema: administracion_mason; Owner: postgres
--

CREATE TABLE administracion_mason.tree_mst (
    num integer NOT NULL,
    mrf_parent character varying(64),
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE administracion_mason.tree_mst OWNER TO postgres;

--
-- Name: tree_mst_num_seq; Type: SEQUENCE; Schema: administracion_mason; Owner: postgres
--

CREATE SEQUENCE administracion_mason.tree_mst_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE administracion_mason.tree_mst_num_seq OWNER TO postgres;

--
-- Name: tree_mst_num_seq; Type: SEQUENCE OWNED BY; Schema: administracion_mason; Owner: postgres
--

ALTER SEQUENCE administracion_mason.tree_mst_num_seq OWNED BY administracion_mason.tree_mst.num;


--
-- Name: graph_bck; Type: TABLE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE TABLE contabilidad_feldman.graph_bck (
    num integer NOT NULL,
    mrf_a character varying(64) NOT NULL,
    mrf_b character varying(64) NOT NULL,
    weight double precision DEFAULT 0.5,
    edge_type character varying(32),
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE contabilidad_feldman.graph_bck OWNER TO postgres;

--
-- Name: graph_bck_num_seq; Type: SEQUENCE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE SEQUENCE contabilidad_feldman.graph_bck_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE contabilidad_feldman.graph_bck_num_seq OWNER TO postgres;

--
-- Name: graph_bck_num_seq; Type: SEQUENCE OWNED BY; Schema: contabilidad_feldman; Owner: postgres
--

ALTER SEQUENCE contabilidad_feldman.graph_bck_num_seq OWNED BY contabilidad_feldman.graph_bck.num;


--
-- Name: graph_mst; Type: TABLE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE TABLE contabilidad_feldman.graph_mst (
    num integer NOT NULL,
    mrf_a character varying(64) NOT NULL,
    mrf_b character varying(64) NOT NULL,
    weight double precision DEFAULT 0.5,
    edge_type character varying(32),
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE contabilidad_feldman.graph_mst OWNER TO postgres;

--
-- Name: graph_mst_num_seq; Type: SEQUENCE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE SEQUENCE contabilidad_feldman.graph_mst_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE contabilidad_feldman.graph_mst_num_seq OWNER TO postgres;

--
-- Name: graph_mst_num_seq; Type: SEQUENCE OWNED BY; Schema: contabilidad_feldman; Owner: postgres
--

ALTER SEQUENCE contabilidad_feldman.graph_mst_num_seq OWNED BY contabilidad_feldman.graph_mst.num;


--
-- Name: library_bck; Type: TABLE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE TABLE contabilidad_feldman.library_bck (
    num integer NOT NULL,
    mrf_library character varying(64) NOT NULL,
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE contabilidad_feldman.library_bck OWNER TO postgres;

--
-- Name: library_bck_num_seq; Type: SEQUENCE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE SEQUENCE contabilidad_feldman.library_bck_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE contabilidad_feldman.library_bck_num_seq OWNER TO postgres;

--
-- Name: library_bck_num_seq; Type: SEQUENCE OWNED BY; Schema: contabilidad_feldman; Owner: postgres
--

ALTER SEQUENCE contabilidad_feldman.library_bck_num_seq OWNED BY contabilidad_feldman.library_bck.num;


--
-- Name: library_mst; Type: TABLE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE TABLE contabilidad_feldman.library_mst (
    num integer NOT NULL,
    mrf_library character varying(64) NOT NULL,
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE contabilidad_feldman.library_mst OWNER TO postgres;

--
-- Name: library_mst_num_seq; Type: SEQUENCE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE SEQUENCE contabilidad_feldman.library_mst_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE contabilidad_feldman.library_mst_num_seq OWNER TO postgres;

--
-- Name: library_mst_num_seq; Type: SEQUENCE OWNED BY; Schema: contabilidad_feldman; Owner: postgres
--

ALTER SEQUENCE contabilidad_feldman.library_mst_num_seq OWNED BY contabilidad_feldman.library_mst.num;


--
-- Name: tree_bck; Type: TABLE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE TABLE contabilidad_feldman.tree_bck (
    num integer NOT NULL,
    mrf_parent character varying(64),
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE contabilidad_feldman.tree_bck OWNER TO postgres;

--
-- Name: tree_bck_num_seq; Type: SEQUENCE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE SEQUENCE contabilidad_feldman.tree_bck_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE contabilidad_feldman.tree_bck_num_seq OWNER TO postgres;

--
-- Name: tree_bck_num_seq; Type: SEQUENCE OWNED BY; Schema: contabilidad_feldman; Owner: postgres
--

ALTER SEQUENCE contabilidad_feldman.tree_bck_num_seq OWNED BY contabilidad_feldman.tree_bck.num;


--
-- Name: tree_mst; Type: TABLE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE TABLE contabilidad_feldman.tree_mst (
    num integer NOT NULL,
    mrf_parent character varying(64),
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE contabilidad_feldman.tree_mst OWNER TO postgres;

--
-- Name: tree_mst_num_seq; Type: SEQUENCE; Schema: contabilidad_feldman; Owner: postgres
--

CREATE SEQUENCE contabilidad_feldman.tree_mst_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE contabilidad_feldman.tree_mst_num_seq OWNER TO postgres;

--
-- Name: tree_mst_num_seq; Type: SEQUENCE OWNED BY; Schema: contabilidad_feldman; Owner: postgres
--

ALTER SEQUENCE contabilidad_feldman.tree_mst_num_seq OWNED BY contabilidad_feldman.tree_mst.num;


--
-- Name: file_exposure; Type: TABLE; Schema: mail_manager; Owner: postgres
--

CREATE TABLE mail_manager.file_exposure (
    id integer NOT NULL,
    hash_contenido character varying(64) NOT NULL,
    status character varying(20) DEFAULT 'active'::character varying NOT NULL,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    notes text,
    synced_at timestamp with time zone,
    CONSTRAINT file_exposure_status_check CHECK (((status)::text = ANY (ARRAY[('active'::character varying)::text, ('inactive'::character varying)::text, ('deleted'::character varying)::text])))
);


ALTER TABLE mail_manager.file_exposure OWNER TO postgres;

--
-- Name: TABLE file_exposure; Type: COMMENT; Schema: mail_manager; Owner: postgres
--

COMMENT ON TABLE mail_manager.file_exposure IS 'Control de exposicion de archivos por hash - firewall basado en hash';


--
-- Name: COLUMN file_exposure.hash_contenido; Type: COMMENT; Schema: mail_manager; Owner: postgres
--

COMMENT ON COLUMN mail_manager.file_exposure.hash_contenido IS 'SHA256 hash del contenido del archivo (MRF)';


--
-- Name: COLUMN file_exposure.status; Type: COMMENT; Schema: mail_manager; Owner: postgres
--

COMMENT ON COLUMN mail_manager.file_exposure.status IS 'active=permitido, inactive=bloqueado (excepto admin), deleted=bloqueado total';


--
-- Name: file_exposure_id_seq; Type: SEQUENCE; Schema: mail_manager; Owner: postgres
--

CREATE SEQUENCE mail_manager.file_exposure_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE mail_manager.file_exposure_id_seq OWNER TO postgres;

--
-- Name: file_exposure_id_seq; Type: SEQUENCE OWNED BY; Schema: mail_manager; Owner: postgres
--

ALTER SEQUENCE mail_manager.file_exposure_id_seq OWNED BY mail_manager.file_exposure.id;


--
-- Name: graph_mth; Type: TABLE; Schema: production_alfred; Owner: postgres
--

CREATE TABLE production_alfred.graph_mth (
    num integer NOT NULL,
    mrf_a character varying(64) NOT NULL,
    mrf_b character varying(64) NOT NULL,
    weight double precision DEFAULT 0.5,
    edge_type character varying(32),
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE production_alfred.graph_mth OWNER TO postgres;

--
-- Name: graph_mth_num_seq; Type: SEQUENCE; Schema: production_alfred; Owner: postgres
--

CREATE SEQUENCE production_alfred.graph_mth_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE production_alfred.graph_mth_num_seq OWNER TO postgres;

--
-- Name: graph_mth_num_seq; Type: SEQUENCE OWNED BY; Schema: production_alfred; Owner: postgres
--

ALTER SEQUENCE production_alfred.graph_mth_num_seq OWNED BY production_alfred.graph_mth.num;


--
-- Name: library_mth; Type: TABLE; Schema: production_alfred; Owner: postgres
--

CREATE TABLE production_alfred.library_mth (
    num integer NOT NULL,
    mrf_library character varying(64) NOT NULL,
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE production_alfred.library_mth OWNER TO postgres;

--
-- Name: library_mth_num_seq; Type: SEQUENCE; Schema: production_alfred; Owner: postgres
--

CREATE SEQUENCE production_alfred.library_mth_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE production_alfred.library_mth_num_seq OWNER TO postgres;

--
-- Name: library_mth_num_seq; Type: SEQUENCE OWNED BY; Schema: production_alfred; Owner: postgres
--

ALTER SEQUENCE production_alfred.library_mth_num_seq OWNED BY production_alfred.library_mth.num;


--
-- Name: tree_mth; Type: TABLE; Schema: production_alfred; Owner: postgres
--

CREATE TABLE production_alfred.tree_mth (
    num integer NOT NULL,
    mrf_parent character varying(64),
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE production_alfred.tree_mth OWNER TO postgres;

--
-- Name: tree_mth_num_seq; Type: SEQUENCE; Schema: production_alfred; Owner: postgres
--

CREATE SEQUENCE production_alfred.tree_mth_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE production_alfred.tree_mth_num_seq OWNER TO postgres;

--
-- Name: tree_mth_num_seq; Type: SEQUENCE OWNED BY; Schema: production_alfred; Owner: postgres
--

ALTER SEQUENCE production_alfred.tree_mth_num_seq OWNED BY production_alfred.tree_mth.num;


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

CREATE TABLE public.mail_log (
    id integer NOT NULL,
    hash character varying(64) NOT NULL,
    message_id text,
    from_addr text,
    to_addrs jsonb,
    subject text,
    received_at timestamp with time zone DEFAULT now(),
    size integer,
    email_raw bytea,
    metadata jsonb,
    sent_to_secretaria boolean DEFAULT false,
    sent_at timestamp with time zone
);


ALTER TABLE public.mail_log OWNER TO postgres;

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

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


ALTER TABLE public.mail_log_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.mail_log_id_seq OWNED BY public.mail_log.id;


--
-- Name: graph_atc; Type: TABLE; Schema: secretaria_clara; Owner: postgres
--

CREATE TABLE secretaria_clara.graph_atc (
    num integer NOT NULL,
    mrf_a character varying(64) NOT NULL,
    mrf_b character varying(64) NOT NULL,
    weight double precision DEFAULT 0.5,
    edge_type character varying(32),
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE secretaria_clara.graph_atc OWNER TO postgres;

--
-- Name: graph_atc_num_seq; Type: SEQUENCE; Schema: secretaria_clara; Owner: postgres
--

CREATE SEQUENCE secretaria_clara.graph_atc_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE secretaria_clara.graph_atc_num_seq OWNER TO postgres;

--
-- Name: graph_atc_num_seq; Type: SEQUENCE OWNED BY; Schema: secretaria_clara; Owner: postgres
--

ALTER SEQUENCE secretaria_clara.graph_atc_num_seq OWNED BY secretaria_clara.graph_atc.num;


--
-- Name: graph_bck; Type: TABLE; Schema: secretaria_clara; Owner: postgres
--

CREATE TABLE secretaria_clara.graph_bck (
    num integer NOT NULL,
    mrf_a character varying(64) NOT NULL,
    mrf_b character varying(64) NOT NULL,
    weight double precision DEFAULT 0.5,
    edge_type character varying(32),
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE secretaria_clara.graph_bck OWNER TO postgres;

--
-- Name: graph_bck_num_seq; Type: SEQUENCE; Schema: secretaria_clara; Owner: postgres
--

CREATE SEQUENCE secretaria_clara.graph_bck_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE secretaria_clara.graph_bck_num_seq OWNER TO postgres;

--
-- Name: graph_bck_num_seq; Type: SEQUENCE OWNED BY; Schema: secretaria_clara; Owner: postgres
--

ALTER SEQUENCE secretaria_clara.graph_bck_num_seq OWNED BY secretaria_clara.graph_bck.num;


--
-- Name: graph_mst; Type: TABLE; Schema: secretaria_clara; Owner: postgres
--

CREATE TABLE secretaria_clara.graph_mst (
    num integer NOT NULL,
    mrf_a character varying(64) NOT NULL,
    mrf_b character varying(64) NOT NULL,
    weight double precision DEFAULT 0.5,
    edge_type character varying(32),
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE secretaria_clara.graph_mst OWNER TO postgres;

--
-- Name: graph_mst_num_seq; Type: SEQUENCE; Schema: secretaria_clara; Owner: postgres
--

CREATE SEQUENCE secretaria_clara.graph_mst_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE secretaria_clara.graph_mst_num_seq OWNER TO postgres;

--
-- Name: graph_mst_num_seq; Type: SEQUENCE OWNED BY; Schema: secretaria_clara; Owner: postgres
--

ALTER SEQUENCE secretaria_clara.graph_mst_num_seq OWNED BY secretaria_clara.graph_mst.num;


--
-- Name: library_atc; Type: TABLE; Schema: secretaria_clara; Owner: postgres
--

CREATE TABLE secretaria_clara.library_atc (
    num integer NOT NULL,
    mrf_library character varying(64) NOT NULL,
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE secretaria_clara.library_atc OWNER TO postgres;

--
-- Name: library_atc_num_seq; Type: SEQUENCE; Schema: secretaria_clara; Owner: postgres
--

CREATE SEQUENCE secretaria_clara.library_atc_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE secretaria_clara.library_atc_num_seq OWNER TO postgres;

--
-- Name: library_atc_num_seq; Type: SEQUENCE OWNED BY; Schema: secretaria_clara; Owner: postgres
--

ALTER SEQUENCE secretaria_clara.library_atc_num_seq OWNED BY secretaria_clara.library_atc.num;


--
-- Name: library_bck; Type: TABLE; Schema: secretaria_clara; Owner: postgres
--

CREATE TABLE secretaria_clara.library_bck (
    num integer NOT NULL,
    mrf_library character varying(64) NOT NULL,
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE secretaria_clara.library_bck OWNER TO postgres;

--
-- Name: library_bck_num_seq; Type: SEQUENCE; Schema: secretaria_clara; Owner: postgres
--

CREATE SEQUENCE secretaria_clara.library_bck_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE secretaria_clara.library_bck_num_seq OWNER TO postgres;

--
-- Name: library_bck_num_seq; Type: SEQUENCE OWNED BY; Schema: secretaria_clara; Owner: postgres
--

ALTER SEQUENCE secretaria_clara.library_bck_num_seq OWNED BY secretaria_clara.library_bck.num;


--
-- Name: library_mst; Type: TABLE; Schema: secretaria_clara; Owner: postgres
--

CREATE TABLE secretaria_clara.library_mst (
    num integer NOT NULL,
    mrf_library character varying(64) NOT NULL,
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE secretaria_clara.library_mst OWNER TO postgres;

--
-- Name: library_mst_num_seq; Type: SEQUENCE; Schema: secretaria_clara; Owner: postgres
--

CREATE SEQUENCE secretaria_clara.library_mst_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE secretaria_clara.library_mst_num_seq OWNER TO postgres;

--
-- Name: library_mst_num_seq; Type: SEQUENCE OWNED BY; Schema: secretaria_clara; Owner: postgres
--

ALTER SEQUENCE secretaria_clara.library_mst_num_seq OWNED BY secretaria_clara.library_mst.num;


--
-- Name: tree_atc; Type: TABLE; Schema: secretaria_clara; Owner: postgres
--

CREATE TABLE secretaria_clara.tree_atc (
    num integer NOT NULL,
    mrf_parent character varying(64),
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE secretaria_clara.tree_atc OWNER TO postgres;

--
-- Name: tree_atc_num_seq; Type: SEQUENCE; Schema: secretaria_clara; Owner: postgres
--

CREATE SEQUENCE secretaria_clara.tree_atc_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE secretaria_clara.tree_atc_num_seq OWNER TO postgres;

--
-- Name: tree_atc_num_seq; Type: SEQUENCE OWNED BY; Schema: secretaria_clara; Owner: postgres
--

ALTER SEQUENCE secretaria_clara.tree_atc_num_seq OWNED BY secretaria_clara.tree_atc.num;


--
-- Name: tree_bck; Type: TABLE; Schema: secretaria_clara; Owner: postgres
--

CREATE TABLE secretaria_clara.tree_bck (
    num integer NOT NULL,
    mrf_parent character varying(64),
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE secretaria_clara.tree_bck OWNER TO postgres;

--
-- Name: tree_bck_num_seq; Type: SEQUENCE; Schema: secretaria_clara; Owner: postgres
--

CREATE SEQUENCE secretaria_clara.tree_bck_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE secretaria_clara.tree_bck_num_seq OWNER TO postgres;

--
-- Name: tree_bck_num_seq; Type: SEQUENCE OWNED BY; Schema: secretaria_clara; Owner: postgres
--

ALTER SEQUENCE secretaria_clara.tree_bck_num_seq OWNED BY secretaria_clara.tree_bck.num;


--
-- Name: tree_mst; Type: TABLE; Schema: secretaria_clara; Owner: postgres
--

CREATE TABLE secretaria_clara.tree_mst (
    num integer NOT NULL,
    mrf_parent character varying(64),
    mrf_child character varying(64) NOT NULL,
    created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE secretaria_clara.tree_mst OWNER TO postgres;

--
-- Name: tree_mst_num_seq; Type: SEQUENCE; Schema: secretaria_clara; Owner: postgres
--

CREATE SEQUENCE secretaria_clara.tree_mst_num_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE secretaria_clara.tree_mst_num_seq OWNER TO postgres;

--
-- Name: tree_mst_num_seq; Type: SEQUENCE OWNED BY; Schema: secretaria_clara; Owner: postgres
--

ALTER SEQUENCE secretaria_clara.tree_mst_num_seq OWNED BY secretaria_clara.tree_mst.num;


--
-- Name: graph_bck num; Type: DEFAULT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.graph_bck ALTER COLUMN num SET DEFAULT nextval('administracion_mason.graph_bck_num_seq'::regclass);


--
-- Name: graph_mst num; Type: DEFAULT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.graph_mst ALTER COLUMN num SET DEFAULT nextval('administracion_mason.graph_mst_num_seq'::regclass);


--
-- Name: library_bck num; Type: DEFAULT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.library_bck ALTER COLUMN num SET DEFAULT nextval('administracion_mason.library_bck_num_seq'::regclass);


--
-- Name: library_mst num; Type: DEFAULT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.library_mst ALTER COLUMN num SET DEFAULT nextval('administracion_mason.library_mst_num_seq'::regclass);


--
-- Name: tree_bck num; Type: DEFAULT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.tree_bck ALTER COLUMN num SET DEFAULT nextval('administracion_mason.tree_bck_num_seq'::regclass);


--
-- Name: tree_mst num; Type: DEFAULT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.tree_mst ALTER COLUMN num SET DEFAULT nextval('administracion_mason.tree_mst_num_seq'::regclass);


--
-- Name: graph_bck num; Type: DEFAULT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.graph_bck ALTER COLUMN num SET DEFAULT nextval('contabilidad_feldman.graph_bck_num_seq'::regclass);


--
-- Name: graph_mst num; Type: DEFAULT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.graph_mst ALTER COLUMN num SET DEFAULT nextval('contabilidad_feldman.graph_mst_num_seq'::regclass);


--
-- Name: library_bck num; Type: DEFAULT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.library_bck ALTER COLUMN num SET DEFAULT nextval('contabilidad_feldman.library_bck_num_seq'::regclass);


--
-- Name: library_mst num; Type: DEFAULT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.library_mst ALTER COLUMN num SET DEFAULT nextval('contabilidad_feldman.library_mst_num_seq'::regclass);


--
-- Name: tree_bck num; Type: DEFAULT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.tree_bck ALTER COLUMN num SET DEFAULT nextval('contabilidad_feldman.tree_bck_num_seq'::regclass);


--
-- Name: tree_mst num; Type: DEFAULT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.tree_mst ALTER COLUMN num SET DEFAULT nextval('contabilidad_feldman.tree_mst_num_seq'::regclass);


--
-- Name: file_exposure id; Type: DEFAULT; Schema: mail_manager; Owner: postgres
--

ALTER TABLE ONLY mail_manager.file_exposure ALTER COLUMN id SET DEFAULT nextval('mail_manager.file_exposure_id_seq'::regclass);


--
-- Name: graph_mth num; Type: DEFAULT; Schema: production_alfred; Owner: postgres
--

ALTER TABLE ONLY production_alfred.graph_mth ALTER COLUMN num SET DEFAULT nextval('production_alfred.graph_mth_num_seq'::regclass);


--
-- Name: library_mth num; Type: DEFAULT; Schema: production_alfred; Owner: postgres
--

ALTER TABLE ONLY production_alfred.library_mth ALTER COLUMN num SET DEFAULT nextval('production_alfred.library_mth_num_seq'::regclass);


--
-- Name: tree_mth num; Type: DEFAULT; Schema: production_alfred; Owner: postgres
--

ALTER TABLE ONLY production_alfred.tree_mth ALTER COLUMN num SET DEFAULT nextval('production_alfred.tree_mth_num_seq'::regclass);


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

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


--
-- Name: graph_atc num; Type: DEFAULT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.graph_atc ALTER COLUMN num SET DEFAULT nextval('secretaria_clara.graph_atc_num_seq'::regclass);


--
-- Name: graph_bck num; Type: DEFAULT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.graph_bck ALTER COLUMN num SET DEFAULT nextval('secretaria_clara.graph_bck_num_seq'::regclass);


--
-- Name: graph_mst num; Type: DEFAULT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.graph_mst ALTER COLUMN num SET DEFAULT nextval('secretaria_clara.graph_mst_num_seq'::regclass);


--
-- Name: library_atc num; Type: DEFAULT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.library_atc ALTER COLUMN num SET DEFAULT nextval('secretaria_clara.library_atc_num_seq'::regclass);


--
-- Name: library_bck num; Type: DEFAULT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.library_bck ALTER COLUMN num SET DEFAULT nextval('secretaria_clara.library_bck_num_seq'::regclass);


--
-- Name: library_mst num; Type: DEFAULT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.library_mst ALTER COLUMN num SET DEFAULT nextval('secretaria_clara.library_mst_num_seq'::regclass);


--
-- Name: tree_atc num; Type: DEFAULT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.tree_atc ALTER COLUMN num SET DEFAULT nextval('secretaria_clara.tree_atc_num_seq'::regclass);


--
-- Name: tree_bck num; Type: DEFAULT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.tree_bck ALTER COLUMN num SET DEFAULT nextval('secretaria_clara.tree_bck_num_seq'::regclass);


--
-- Name: tree_mst num; Type: DEFAULT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.tree_mst ALTER COLUMN num SET DEFAULT nextval('secretaria_clara.tree_mst_num_seq'::regclass);


--
-- Data for Name: graph_bck; Type: TABLE DATA; Schema: administracion_mason; Owner: postgres
--

COPY administracion_mason.graph_bck (num, mrf_a, mrf_b, weight, edge_type, created_at) FROM stdin;
\.


--
-- Data for Name: graph_mst; Type: TABLE DATA; Schema: administracion_mason; Owner: postgres
--

COPY administracion_mason.graph_mst (num, mrf_a, mrf_b, weight, edge_type, created_at) FROM stdin;
\.


--
-- Data for Name: library_bck; Type: TABLE DATA; Schema: administracion_mason; Owner: postgres
--

COPY administracion_mason.library_bck (num, mrf_library, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: library_mst; Type: TABLE DATA; Schema: administracion_mason; Owner: postgres
--

COPY administracion_mason.library_mst (num, mrf_library, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: tree_bck; Type: TABLE DATA; Schema: administracion_mason; Owner: postgres
--

COPY administracion_mason.tree_bck (num, mrf_parent, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: tree_mst; Type: TABLE DATA; Schema: administracion_mason; Owner: postgres
--

COPY administracion_mason.tree_mst (num, mrf_parent, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: graph_bck; Type: TABLE DATA; Schema: contabilidad_feldman; Owner: postgres
--

COPY contabilidad_feldman.graph_bck (num, mrf_a, mrf_b, weight, edge_type, created_at) FROM stdin;
\.


--
-- Data for Name: graph_mst; Type: TABLE DATA; Schema: contabilidad_feldman; Owner: postgres
--

COPY contabilidad_feldman.graph_mst (num, mrf_a, mrf_b, weight, edge_type, created_at) FROM stdin;
\.


--
-- Data for Name: library_bck; Type: TABLE DATA; Schema: contabilidad_feldman; Owner: postgres
--

COPY contabilidad_feldman.library_bck (num, mrf_library, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: library_mst; Type: TABLE DATA; Schema: contabilidad_feldman; Owner: postgres
--

COPY contabilidad_feldman.library_mst (num, mrf_library, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: tree_bck; Type: TABLE DATA; Schema: contabilidad_feldman; Owner: postgres
--

COPY contabilidad_feldman.tree_bck (num, mrf_parent, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: tree_mst; Type: TABLE DATA; Schema: contabilidad_feldman; Owner: postgres
--

COPY contabilidad_feldman.tree_mst (num, mrf_parent, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: file_exposure; Type: TABLE DATA; Schema: mail_manager; Owner: postgres
--

COPY mail_manager.file_exposure (id, hash_contenido, status, created_at, updated_at, notes, synced_at) FROM stdin;
1	test123abc	deleted	2026-01-11 08:09:45.039106+00	2026-01-11 08:09:45.039106+00	\N	\N
\.


--
-- Data for Name: graph_mth; Type: TABLE DATA; Schema: production_alfred; Owner: postgres
--

COPY production_alfred.graph_mth (num, mrf_a, mrf_b, weight, edge_type, created_at) FROM stdin;
\.


--
-- Data for Name: library_mth; Type: TABLE DATA; Schema: production_alfred; Owner: postgres
--

COPY production_alfred.library_mth (num, mrf_library, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: tree_mth; Type: TABLE DATA; Schema: production_alfred; Owner: postgres
--

COPY production_alfred.tree_mth (num, mrf_parent, mrf_child, created_at) FROM stdin;
\.


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

COPY public.mail_log (id, hash, message_id, from_addr, to_addrs, subject, received_at, size, email_raw, metadata, sent_to_secretaria, sent_at) FROM stdin;
1	4869278f87f8cc33	test123	test@example.com	["dest@tzzr.dev"]	Test email	2026-01-11 06:49:02.059065+00	18	\\x5465737420656d61696c20636f6e74656e74	{"email_base64": "VGVzdCBlbWFpbCBjb250ZW50"}	t	2026-01-11 06:49:13.738314+00
39	be1cd64d224a8c7e	20260111082231.3795307@tzzrdeck.me	test@tzzrdeck.me	["alex@tzzr.xyz"]	Prueba Mail Manager	2026-01-11 07:22:32.662608+00	294	\\x446174653a2053756e2c203131204a616e20323032362030383a32323a3331202b303130300d0a546f3a20616c657840747a7a722e78797a0d0a46726f6d3a207465737440747a7a726465636b2e6d650d0a5375626a6563743a20507275656261204d61696c204d616e616765720d0a4d6573736167652d49643a203c32303236303131313038323233312e3337393533303740747a7a726465636b2e6d653e0d0a582d4d61696c65723a207377616b73207632303230313031342e30206a65746d6f72652e6f72672f6a6f686e2f636f64652f7377616b732f0d0a0d0a4573746520657320756e20656d61696c2064652070727565626120706172612076657269666963617220656c20686f6f6b206465204d61696c204d616e616765722e0d0a0d0a0d0a	{"email_base64": "RGF0ZTogU3VuLCAxMSBKYW4gMjAyNiAwODoyMjozMSArMDEwMA0KVG86IGFsZXhAdHp6ci54eXoNCkZyb206IHRlc3RAdHp6cmRlY2subWUNClN1YmplY3Q6IFBydWViYSBNYWlsIE1hbmFnZXINCk1lc3NhZ2UtSWQ6IDwyMDI2MDExMTA4MjIzMS4zNzk1MzA3QHR6enJkZWNrLm1lPg0KWC1NYWlsZXI6IHN3YWtzIHYyMDIwMTAxNC4wIGpldG1vcmUub3JnL2pvaG4vY29kZS9zd2Frcy8NCg0KRXN0ZSBlcyB1biBlbWFpbCBkZSBwcnVlYmEgcGFyYSB2ZXJpZmljYXIgZWwgaG9vayBkZSBNYWlsIE1hbmFnZXIuDQoNCg0K"}	f	\N
42	5fc96858f9c8d61a	20260111073559.A321F17BCB5@mail.tzzrdeck.me	root@mail.tzzrdeck.me	["admin@tzzrdeck.me"]		2026-01-11 07:36:00.491912+00	183	\\x4d6573736167652d49643a203c32303236303131313037333535392e4133323146313742434235406d61696c2e747a7a726465636b2e6d653e0d0a446174653a2053756e2c203131204a616e20323032362030383a33353a3539202b303130302028434554290d0a46726f6d3a20726f6f74203c726f6f74406d61696c2e747a7a726465636b2e6d653e0d0a0d0a5465737420656d61696c2053756e204a616e2031312030383a33353a35392043455420323032360d0a	{"email_base64": "TWVzc2FnZS1JZDogPDIwMjYwMTExMDczNTU5LkEzMjFGMTdCQ0I1QG1haWwudHp6cmRlY2subWU+DQpEYXRlOiBTdW4sIDExIEphbiAyMDI2IDA4OjM1OjU5ICswMTAwIChDRVQpDQpGcm9tOiByb290IDxyb290QG1haWwudHp6cmRlY2subWU+DQoNClRlc3QgZW1haWwgU3VuIEphbiAxMSAwODozNTo1OSBDRVQgMjAyNg0K"}	f	\N
43	2799a614d56fb9a6	20260111073628.E291717BCEE@mail.tzzrdeck.me	test@example.com	["admin@tzzrdeck.me"]		2026-01-11 07:36:29.564098+00	186	\\x4d6573736167652d49643a203c32303236303131313037333632382e4532393137313742434545406d61696c2e747a7a726465636b2e6d653e0d0a446174653a2053756e2c203131204a616e20323032362030383a33363a3238202b303130302028434554290d0a46726f6d3a20726f6f74203c74657374406578616d706c652e636f6d3e0d0a0d0a5465737420656d61696c2065787465726e6f2053756e204a616e2031312030383a33363a32382043455420323032360d0a	{"email_base64": "TWVzc2FnZS1JZDogPDIwMjYwMTExMDczNjI4LkUyOTE3MTdCQ0VFQG1haWwudHp6cmRlY2subWU+DQpEYXRlOiBTdW4sIDExIEphbiAyMDI2IDA4OjM2OjI4ICswMTAwIChDRVQpDQpGcm9tOiByb290IDx0ZXN0QGV4YW1wbGUuY29tPg0KDQpUZXN0IGVtYWlsIGV4dGVybm8gU3VuIEphbiAxMSAwODozNjoyOCBDRVQgMjAyNg0K"}	f	\N
44	72d4abddbfa7e154	20260111083807.3844466@tzzrdeck.me	test@tzzrdeck.me	["admin@tzzrdeck.me"]	Test correo arreglado	2026-01-11 07:38:08.249534+00	255	\\x446174653a2053756e2c203131204a616e20323032362030383a33383a3037202b303130300d0a546f3a2061646d696e40747a7a726465636b2e6d650d0a46726f6d3a207465737440747a7a726465636b2e6d650d0a5375626a6563743a205465737420636f7272656f2061727265676c61646f0d0a4d6573736167652d49643a203c32303236303131313038333830372e3338343434363640747a7a726465636b2e6d653e0d0a582d4d61696c65723a207377616b73207632303230313031342e30206a65746d6f72652e6f72672f6a6f686e2f636f64652f7377616b732f0d0a0d0a5072756562612064657370756573206465206669780d0a0d0a0d0a	{"email_base64": "RGF0ZTogU3VuLCAxMSBKYW4gMjAyNiAwODozODowNyArMDEwMA0KVG86IGFkbWluQHR6enJkZWNrLm1lDQpGcm9tOiB0ZXN0QHR6enJkZWNrLm1lDQpTdWJqZWN0OiBUZXN0IGNvcnJlbyBhcnJlZ2xhZG8NCk1lc3NhZ2UtSWQ6IDwyMDI2MDExMTA4MzgwNy4zODQ0NDY2QHR6enJkZWNrLm1lPg0KWC1NYWlsZXI6IHN3YWtzIHYyMDIwMTAxNC4wIGpldG1vcmUub3JnL2pvaG4vY29kZS9zd2Frcy8NCg0KUHJ1ZWJhIGRlc3B1ZXMgZGUgZml4DQoNCg0K"}	f	\N
45	c78d76b997fbf3f1	undef	pablo@tzzrdeck.me	["pablo@tzzrdeck.me"]	Creación de "Calendario personal"	2026-01-11 09:26:57.941491+00	816	\\x46726f6d3a20225061626c6f22203c7061626c6f40747a7a726465636b2e6d653e0d0a546f3a20225061626c6f22203c7061626c6f40747a7a726465636b2e6d653e0d0a436f6e74656e742d547970653a206d756c7469706172742f616c7465726e61746976653b20626f756e646172793d222d2d2d2d3d5f3d2d5f4f70656e47726f7570776172655f6f72675f4e474d696d652d35392d313736383132333631362e3738343131382d302d2d2d2d2d2d220d0a446174653a2053756e2c203131204a616e20323032362031303a32363a3536202b303130300d0a5375626a6563743a203d3f7574662d383f713f4372656163693d43333d42336e3f3d206465203d3f7574662d383f713f3d323243616c656e646172696f3f3d0a203d3f7574662d383f713f5f706572736f6e616c3d32323f3d0d0a0d0a2d2d2d2d2d2d3d5f3d2d5f4f70656e47726f7570776172655f6f72675f4e474d696d652d35392d313736383132333631362e3738343131382d302d2d2d2d2d2d0d0a436f6e74656e742d547970653a20746578742f706c61696e3b20636861727365743d7574662d380d0a436f6e74656e742d4c656e6774683a2034380d0a0d0a4c612063617270657461202243616c656e646172696f20706572736f6e616c22206861207369646f206372656164612e0d0a0d0a2d2d2d2d2d2d3d5f3d2d5f4f70656e47726f7570776172655f6f72675f4e474d696d652d35392d313736383132333631362e3738343131382d302d2d2d2d2d2d0d0a436f6e74656e742d547970653a206170706c69636174696f6e2f782d736f676f2d6e6f74696669636174696f6e3b206d6574686f643d6164643b20747970653d4170706f696e746d656e743b20636861727365743d7574662d380d0a436f6e74656e742d4c656e6774683a2036390d0a0d0a68747470733a2f2f6d61696c2e747a7a726465636b2e6d652f534f476f2f736f2f7061626c6f40747a7a726465636b2e6d652f43616c656e6461722f706572736f6e616c2f0d0a0d0a2d2d2d2d2d2d3d5f3d2d5f4f70656e47726f7570776172655f6f72675f4e474d696d652d35392d313736383132333631362e3738343131382d302d2d2d2d2d2d2d2d0d0a0d0a	{"email_base64": "RnJvbTogIlBhYmxvIiA8cGFibG9AdHp6cmRlY2subWU+DQpUbzogIlBhYmxvIiA8cGFibG9AdHp6cmRlY2subWU+DQpDb250ZW50LVR5cGU6IG11bHRpcGFydC9hbHRlcm5hdGl2ZTsgYm91bmRhcnk9Ii0tLS09Xz0tX09wZW5Hcm91cHdhcmVfb3JnX05HTWltZS01OS0xNzY4MTIzNjE2Ljc4NDExOC0wLS0tLS0tIg0KRGF0ZTogU3VuLCAxMSBKYW4gMjAyNiAxMDoyNjo1NiArMDEwMA0KU3ViamVjdDogPT91dGYtOD9xP0NyZWFjaT1DMz1CM24/PSBkZSA9P3V0Zi04P3E/PTIyQ2FsZW5kYXJpbz89CiA9P3V0Zi04P3E/X3BlcnNvbmFsPTIyPz0NCg0KLS0tLS0tPV89LV9PcGVuR3JvdXB3YXJlX29yZ19OR01pbWUtNTktMTc2ODEyMzYxNi43ODQxMTgtMC0tLS0tLQ0KQ29udGVudC1UeXBlOiB0ZXh0L3BsYWluOyBjaGFyc2V0PXV0Zi04DQpDb250ZW50LUxlbmd0aDogNDgNCg0KTGEgY2FycGV0YSAiQ2FsZW5kYXJpbyBwZXJzb25hbCIgaGEgc2lkbyBjcmVhZGEuDQoNCi0tLS0tLT1fPS1fT3Blbkdyb3Vwd2FyZV9vcmdfTkdNaW1lLTU5LTE3NjgxMjM2MTYuNzg0MTE4LTAtLS0tLS0NCkNvbnRlbnQtVHlwZTogYXBwbGljYXRpb24veC1zb2dvLW5vdGlmaWNhdGlvbjsgbWV0aG9kPWFkZDsgdHlwZT1BcHBvaW50bWVudDsgY2hhcnNldD11dGYtOA0KQ29udGVudC1MZW5ndGg6IDY5DQoNCmh0dHBzOi8vbWFpbC50enpyZGVjay5tZS9TT0dvL3NvL3BhYmxvQHR6enJkZWNrLm1lL0NhbGVuZGFyL3BlcnNvbmFsLw0KDQotLS0tLS09Xz0tX09wZW5Hcm91cHdhcmVfb3JnX05HTWltZS01OS0xNzY4MTIzNjE2Ljc4NDExOC0wLS0tLS0tLS0NCg0K"}	f	\N
46	b04e04b42d96b246	20260111102908.4098899@tzzrdeck.me	sistema@tzzrdeck.me	["pablo@tzzrdeck.me"]	Bienvenido a Mail Manager	2026-01-11 09:29:09.604632+00	301	\\x446174653a2053756e2c203131204a616e20323032362031303a32393a3038202b303130300d0a546f3a207061626c6f40747a7a726465636b2e6d650d0a46726f6d3a2073697374656d6140747a7a726465636b2e6d650d0a5375626a6563743a204269656e76656e69646f2061204d61696c204d616e616765720d0a4d6573736167652d49643a203c32303236303131313130323930382e3430393838393940747a7a726465636b2e6d653e0d0a582d4d61696c65723a207377616b73207632303230313031342e30206a65746d6f72652e6f72672f6a6f686e2f636f64652f7377616b732f0d0a0d0a547520636f7272656f207061626c6f40747a7a726465636b2e6d6520657374c3a12066756e63696f6e616e646f20636f7272656374616d656e74652e0d0a0d0a0d0a	{"email_base64": "RGF0ZTogU3VuLCAxMSBKYW4gMjAyNiAxMDoyOTowOCArMDEwMA0KVG86IHBhYmxvQHR6enJkZWNrLm1lDQpGcm9tOiBzaXN0ZW1hQHR6enJkZWNrLm1lDQpTdWJqZWN0OiBCaWVudmVuaWRvIGEgTWFpbCBNYW5hZ2VyDQpNZXNzYWdlLUlkOiA8MjAyNjAxMTExMDI5MDguNDA5ODg5OUB0enpyZGVjay5tZT4NClgtTWFpbGVyOiBzd2FrcyB2MjAyMDEwMTQuMCBqZXRtb3JlLm9yZy9qb2huL2NvZGUvc3dha3MvDQoNClR1IGNvcnJlbyBwYWJsb0B0enpyZGVjay5tZSBlc3TDoSBmdW5jaW9uYW5kbyBjb3JyZWN0YW1lbnRlLg0KDQoNCg=="}	f	\N
\.


--
-- Data for Name: graph_atc; Type: TABLE DATA; Schema: secretaria_clara; Owner: postgres
--

COPY secretaria_clara.graph_atc (num, mrf_a, mrf_b, weight, edge_type, created_at) FROM stdin;
\.


--
-- Data for Name: graph_bck; Type: TABLE DATA; Schema: secretaria_clara; Owner: postgres
--

COPY secretaria_clara.graph_bck (num, mrf_a, mrf_b, weight, edge_type, created_at) FROM stdin;
\.


--
-- Data for Name: graph_mst; Type: TABLE DATA; Schema: secretaria_clara; Owner: postgres
--

COPY secretaria_clara.graph_mst (num, mrf_a, mrf_b, weight, edge_type, created_at) FROM stdin;
\.


--
-- Data for Name: library_atc; Type: TABLE DATA; Schema: secretaria_clara; Owner: postgres
--

COPY secretaria_clara.library_atc (num, mrf_library, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: library_bck; Type: TABLE DATA; Schema: secretaria_clara; Owner: postgres
--

COPY secretaria_clara.library_bck (num, mrf_library, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: library_mst; Type: TABLE DATA; Schema: secretaria_clara; Owner: postgres
--

COPY secretaria_clara.library_mst (num, mrf_library, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: tree_atc; Type: TABLE DATA; Schema: secretaria_clara; Owner: postgres
--

COPY secretaria_clara.tree_atc (num, mrf_parent, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: tree_bck; Type: TABLE DATA; Schema: secretaria_clara; Owner: postgres
--

COPY secretaria_clara.tree_bck (num, mrf_parent, mrf_child, created_at) FROM stdin;
\.


--
-- Data for Name: tree_mst; Type: TABLE DATA; Schema: secretaria_clara; Owner: postgres
--

COPY secretaria_clara.tree_mst (num, mrf_parent, mrf_child, created_at) FROM stdin;
\.


--
-- Name: graph_bck_num_seq; Type: SEQUENCE SET; Schema: administracion_mason; Owner: postgres
--

SELECT pg_catalog.setval('administracion_mason.graph_bck_num_seq', 1, false);


--
-- Name: graph_mst_num_seq; Type: SEQUENCE SET; Schema: administracion_mason; Owner: postgres
--

SELECT pg_catalog.setval('administracion_mason.graph_mst_num_seq', 1, false);


--
-- Name: library_bck_num_seq; Type: SEQUENCE SET; Schema: administracion_mason; Owner: postgres
--

SELECT pg_catalog.setval('administracion_mason.library_bck_num_seq', 1, false);


--
-- Name: library_mst_num_seq; Type: SEQUENCE SET; Schema: administracion_mason; Owner: postgres
--

SELECT pg_catalog.setval('administracion_mason.library_mst_num_seq', 1, false);


--
-- Name: tree_bck_num_seq; Type: SEQUENCE SET; Schema: administracion_mason; Owner: postgres
--

SELECT pg_catalog.setval('administracion_mason.tree_bck_num_seq', 1, false);


--
-- Name: tree_mst_num_seq; Type: SEQUENCE SET; Schema: administracion_mason; Owner: postgres
--

SELECT pg_catalog.setval('administracion_mason.tree_mst_num_seq', 1, false);


--
-- Name: graph_bck_num_seq; Type: SEQUENCE SET; Schema: contabilidad_feldman; Owner: postgres
--

SELECT pg_catalog.setval('contabilidad_feldman.graph_bck_num_seq', 1, false);


--
-- Name: graph_mst_num_seq; Type: SEQUENCE SET; Schema: contabilidad_feldman; Owner: postgres
--

SELECT pg_catalog.setval('contabilidad_feldman.graph_mst_num_seq', 1, false);


--
-- Name: library_bck_num_seq; Type: SEQUENCE SET; Schema: contabilidad_feldman; Owner: postgres
--

SELECT pg_catalog.setval('contabilidad_feldman.library_bck_num_seq', 1, false);


--
-- Name: library_mst_num_seq; Type: SEQUENCE SET; Schema: contabilidad_feldman; Owner: postgres
--

SELECT pg_catalog.setval('contabilidad_feldman.library_mst_num_seq', 1, false);


--
-- Name: tree_bck_num_seq; Type: SEQUENCE SET; Schema: contabilidad_feldman; Owner: postgres
--

SELECT pg_catalog.setval('contabilidad_feldman.tree_bck_num_seq', 1, false);


--
-- Name: tree_mst_num_seq; Type: SEQUENCE SET; Schema: contabilidad_feldman; Owner: postgres
--

SELECT pg_catalog.setval('contabilidad_feldman.tree_mst_num_seq', 1, false);


--
-- Name: file_exposure_id_seq; Type: SEQUENCE SET; Schema: mail_manager; Owner: postgres
--

SELECT pg_catalog.setval('mail_manager.file_exposure_id_seq', 5, true);


--
-- Name: graph_mth_num_seq; Type: SEQUENCE SET; Schema: production_alfred; Owner: postgres
--

SELECT pg_catalog.setval('production_alfred.graph_mth_num_seq', 1, false);


--
-- Name: library_mth_num_seq; Type: SEQUENCE SET; Schema: production_alfred; Owner: postgres
--

SELECT pg_catalog.setval('production_alfred.library_mth_num_seq', 1, false);


--
-- Name: tree_mth_num_seq; Type: SEQUENCE SET; Schema: production_alfred; Owner: postgres
--

SELECT pg_catalog.setval('production_alfred.tree_mth_num_seq', 1, false);


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

SELECT pg_catalog.setval('public.mail_log_id_seq', 46, true);


--
-- Name: graph_atc_num_seq; Type: SEQUENCE SET; Schema: secretaria_clara; Owner: postgres
--

SELECT pg_catalog.setval('secretaria_clara.graph_atc_num_seq', 1, false);


--
-- Name: graph_bck_num_seq; Type: SEQUENCE SET; Schema: secretaria_clara; Owner: postgres
--

SELECT pg_catalog.setval('secretaria_clara.graph_bck_num_seq', 1, false);


--
-- Name: graph_mst_num_seq; Type: SEQUENCE SET; Schema: secretaria_clara; Owner: postgres
--

SELECT pg_catalog.setval('secretaria_clara.graph_mst_num_seq', 1, false);


--
-- Name: library_atc_num_seq; Type: SEQUENCE SET; Schema: secretaria_clara; Owner: postgres
--

SELECT pg_catalog.setval('secretaria_clara.library_atc_num_seq', 1, false);


--
-- Name: library_bck_num_seq; Type: SEQUENCE SET; Schema: secretaria_clara; Owner: postgres
--

SELECT pg_catalog.setval('secretaria_clara.library_bck_num_seq', 1, false);


--
-- Name: library_mst_num_seq; Type: SEQUENCE SET; Schema: secretaria_clara; Owner: postgres
--

SELECT pg_catalog.setval('secretaria_clara.library_mst_num_seq', 1, false);


--
-- Name: tree_atc_num_seq; Type: SEQUENCE SET; Schema: secretaria_clara; Owner: postgres
--

SELECT pg_catalog.setval('secretaria_clara.tree_atc_num_seq', 1, false);


--
-- Name: tree_bck_num_seq; Type: SEQUENCE SET; Schema: secretaria_clara; Owner: postgres
--

SELECT pg_catalog.setval('secretaria_clara.tree_bck_num_seq', 1, false);


--
-- Name: tree_mst_num_seq; Type: SEQUENCE SET; Schema: secretaria_clara; Owner: postgres
--

SELECT pg_catalog.setval('secretaria_clara.tree_mst_num_seq', 1, false);


--
-- Name: graph_bck graph_bck_mrf_a_mrf_b_key; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.graph_bck
    ADD CONSTRAINT graph_bck_mrf_a_mrf_b_key UNIQUE (mrf_a, mrf_b);


--
-- Name: graph_bck graph_bck_pkey; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.graph_bck
    ADD CONSTRAINT graph_bck_pkey PRIMARY KEY (num);


--
-- Name: graph_mst graph_mst_mrf_a_mrf_b_key; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.graph_mst
    ADD CONSTRAINT graph_mst_mrf_a_mrf_b_key UNIQUE (mrf_a, mrf_b);


--
-- Name: graph_mst graph_mst_pkey; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.graph_mst
    ADD CONSTRAINT graph_mst_pkey PRIMARY KEY (num);


--
-- Name: library_bck library_bck_mrf_library_mrf_child_key; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.library_bck
    ADD CONSTRAINT library_bck_mrf_library_mrf_child_key UNIQUE (mrf_library, mrf_child);


--
-- Name: library_bck library_bck_pkey; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.library_bck
    ADD CONSTRAINT library_bck_pkey PRIMARY KEY (num);


--
-- Name: library_mst library_mst_mrf_library_mrf_child_key; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.library_mst
    ADD CONSTRAINT library_mst_mrf_library_mrf_child_key UNIQUE (mrf_library, mrf_child);


--
-- Name: library_mst library_mst_pkey; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.library_mst
    ADD CONSTRAINT library_mst_pkey PRIMARY KEY (num);


--
-- Name: tree_bck tree_bck_mrf_child_key; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.tree_bck
    ADD CONSTRAINT tree_bck_mrf_child_key UNIQUE (mrf_child);


--
-- Name: tree_bck tree_bck_pkey; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.tree_bck
    ADD CONSTRAINT tree_bck_pkey PRIMARY KEY (num);


--
-- Name: tree_mst tree_mst_mrf_child_key; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.tree_mst
    ADD CONSTRAINT tree_mst_mrf_child_key UNIQUE (mrf_child);


--
-- Name: tree_mst tree_mst_pkey; Type: CONSTRAINT; Schema: administracion_mason; Owner: postgres
--

ALTER TABLE ONLY administracion_mason.tree_mst
    ADD CONSTRAINT tree_mst_pkey PRIMARY KEY (num);


--
-- Name: graph_bck graph_bck_mrf_a_mrf_b_key; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.graph_bck
    ADD CONSTRAINT graph_bck_mrf_a_mrf_b_key UNIQUE (mrf_a, mrf_b);


--
-- Name: graph_bck graph_bck_pkey; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.graph_bck
    ADD CONSTRAINT graph_bck_pkey PRIMARY KEY (num);


--
-- Name: graph_mst graph_mst_mrf_a_mrf_b_key; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.graph_mst
    ADD CONSTRAINT graph_mst_mrf_a_mrf_b_key UNIQUE (mrf_a, mrf_b);


--
-- Name: graph_mst graph_mst_pkey; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.graph_mst
    ADD CONSTRAINT graph_mst_pkey PRIMARY KEY (num);


--
-- Name: library_bck library_bck_mrf_library_mrf_child_key; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.library_bck
    ADD CONSTRAINT library_bck_mrf_library_mrf_child_key UNIQUE (mrf_library, mrf_child);


--
-- Name: library_bck library_bck_pkey; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.library_bck
    ADD CONSTRAINT library_bck_pkey PRIMARY KEY (num);


--
-- Name: library_mst library_mst_mrf_library_mrf_child_key; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.library_mst
    ADD CONSTRAINT library_mst_mrf_library_mrf_child_key UNIQUE (mrf_library, mrf_child);


--
-- Name: library_mst library_mst_pkey; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.library_mst
    ADD CONSTRAINT library_mst_pkey PRIMARY KEY (num);


--
-- Name: tree_bck tree_bck_mrf_child_key; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.tree_bck
    ADD CONSTRAINT tree_bck_mrf_child_key UNIQUE (mrf_child);


--
-- Name: tree_bck tree_bck_pkey; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.tree_bck
    ADD CONSTRAINT tree_bck_pkey PRIMARY KEY (num);


--
-- Name: tree_mst tree_mst_mrf_child_key; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.tree_mst
    ADD CONSTRAINT tree_mst_mrf_child_key UNIQUE (mrf_child);


--
-- Name: tree_mst tree_mst_pkey; Type: CONSTRAINT; Schema: contabilidad_feldman; Owner: postgres
--

ALTER TABLE ONLY contabilidad_feldman.tree_mst
    ADD CONSTRAINT tree_mst_pkey PRIMARY KEY (num);


--
-- Name: file_exposure file_exposure_hash_contenido_key; Type: CONSTRAINT; Schema: mail_manager; Owner: postgres
--

ALTER TABLE ONLY mail_manager.file_exposure
    ADD CONSTRAINT file_exposure_hash_contenido_key UNIQUE (hash_contenido);


--
-- Name: file_exposure file_exposure_pkey; Type: CONSTRAINT; Schema: mail_manager; Owner: postgres
--

ALTER TABLE ONLY mail_manager.file_exposure
    ADD CONSTRAINT file_exposure_pkey PRIMARY KEY (id);


--
-- Name: graph_mth graph_mth_mrf_a_mrf_b_key; Type: CONSTRAINT; Schema: production_alfred; Owner: postgres
--

ALTER TABLE ONLY production_alfred.graph_mth
    ADD CONSTRAINT graph_mth_mrf_a_mrf_b_key UNIQUE (mrf_a, mrf_b);


--
-- Name: graph_mth graph_mth_pkey; Type: CONSTRAINT; Schema: production_alfred; Owner: postgres
--

ALTER TABLE ONLY production_alfred.graph_mth
    ADD CONSTRAINT graph_mth_pkey PRIMARY KEY (num);


--
-- Name: library_mth library_mth_mrf_library_mrf_child_key; Type: CONSTRAINT; Schema: production_alfred; Owner: postgres
--

ALTER TABLE ONLY production_alfred.library_mth
    ADD CONSTRAINT library_mth_mrf_library_mrf_child_key UNIQUE (mrf_library, mrf_child);


--
-- Name: library_mth library_mth_pkey; Type: CONSTRAINT; Schema: production_alfred; Owner: postgres
--

ALTER TABLE ONLY production_alfred.library_mth
    ADD CONSTRAINT library_mth_pkey PRIMARY KEY (num);


--
-- Name: tree_mth tree_mth_mrf_child_key; Type: CONSTRAINT; Schema: production_alfred; Owner: postgres
--

ALTER TABLE ONLY production_alfred.tree_mth
    ADD CONSTRAINT tree_mth_mrf_child_key UNIQUE (mrf_child);


--
-- Name: tree_mth tree_mth_pkey; Type: CONSTRAINT; Schema: production_alfred; Owner: postgres
--

ALTER TABLE ONLY production_alfred.tree_mth
    ADD CONSTRAINT tree_mth_pkey PRIMARY KEY (num);


--
-- Name: mail_log mail_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mail_log
    ADD CONSTRAINT mail_log_pkey PRIMARY KEY (id);


--
-- Name: graph_atc graph_atc_mrf_a_mrf_b_key; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.graph_atc
    ADD CONSTRAINT graph_atc_mrf_a_mrf_b_key UNIQUE (mrf_a, mrf_b);


--
-- Name: graph_atc graph_atc_pkey; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.graph_atc
    ADD CONSTRAINT graph_atc_pkey PRIMARY KEY (num);


--
-- Name: graph_bck graph_bck_mrf_a_mrf_b_key; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.graph_bck
    ADD CONSTRAINT graph_bck_mrf_a_mrf_b_key UNIQUE (mrf_a, mrf_b);


--
-- Name: graph_bck graph_bck_pkey; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.graph_bck
    ADD CONSTRAINT graph_bck_pkey PRIMARY KEY (num);


--
-- Name: graph_mst graph_mst_mrf_a_mrf_b_key; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.graph_mst
    ADD CONSTRAINT graph_mst_mrf_a_mrf_b_key UNIQUE (mrf_a, mrf_b);


--
-- Name: graph_mst graph_mst_pkey; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.graph_mst
    ADD CONSTRAINT graph_mst_pkey PRIMARY KEY (num);


--
-- Name: library_atc library_atc_mrf_library_mrf_child_key; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.library_atc
    ADD CONSTRAINT library_atc_mrf_library_mrf_child_key UNIQUE (mrf_library, mrf_child);


--
-- Name: library_atc library_atc_pkey; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.library_atc
    ADD CONSTRAINT library_atc_pkey PRIMARY KEY (num);


--
-- Name: library_bck library_bck_mrf_library_mrf_child_key; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.library_bck
    ADD CONSTRAINT library_bck_mrf_library_mrf_child_key UNIQUE (mrf_library, mrf_child);


--
-- Name: library_bck library_bck_pkey; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.library_bck
    ADD CONSTRAINT library_bck_pkey PRIMARY KEY (num);


--
-- Name: library_mst library_mst_mrf_library_mrf_child_key; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.library_mst
    ADD CONSTRAINT library_mst_mrf_library_mrf_child_key UNIQUE (mrf_library, mrf_child);


--
-- Name: library_mst library_mst_pkey; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.library_mst
    ADD CONSTRAINT library_mst_pkey PRIMARY KEY (num);


--
-- Name: tree_atc tree_atc_mrf_child_key; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.tree_atc
    ADD CONSTRAINT tree_atc_mrf_child_key UNIQUE (mrf_child);


--
-- Name: tree_atc tree_atc_pkey; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.tree_atc
    ADD CONSTRAINT tree_atc_pkey PRIMARY KEY (num);


--
-- Name: tree_bck tree_bck_mrf_child_key; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.tree_bck
    ADD CONSTRAINT tree_bck_mrf_child_key UNIQUE (mrf_child);


--
-- Name: tree_bck tree_bck_pkey; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.tree_bck
    ADD CONSTRAINT tree_bck_pkey PRIMARY KEY (num);


--
-- Name: tree_mst tree_mst_mrf_child_key; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.tree_mst
    ADD CONSTRAINT tree_mst_mrf_child_key UNIQUE (mrf_child);


--
-- Name: tree_mst tree_mst_pkey; Type: CONSTRAINT; Schema: secretaria_clara; Owner: postgres
--

ALTER TABLE ONLY secretaria_clara.tree_mst
    ADD CONSTRAINT tree_mst_pkey PRIMARY KEY (num);


--
-- Name: idx_file_exposure_hash; Type: INDEX; Schema: mail_manager; Owner: postgres
--

CREATE INDEX idx_file_exposure_hash ON mail_manager.file_exposure USING btree (hash_contenido);


--
-- Name: idx_file_exposure_status; Type: INDEX; Schema: mail_manager; Owner: postgres
--

CREATE INDEX idx_file_exposure_status ON mail_manager.file_exposure USING btree (status);


--
-- Name: idx_mail_log_hash; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_mail_log_hash ON public.mail_log USING btree (hash);


--
-- Name: idx_mail_log_pending; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_mail_log_pending ON public.mail_log USING btree (sent_to_secretaria) WHERE (NOT sent_to_secretaria);


--
-- Name: idx_mail_log_received; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_mail_log_received ON public.mail_log USING btree (received_at DESC);


--
-- Name: idx_mail_log_sent; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_mail_log_sent ON public.mail_log USING btree (sent_to_secretaria);


--
-- Name: SCHEMA mail_manager; Type: ACL; Schema: -; Owner: postgres
--

GRANT USAGE ON SCHEMA mail_manager TO tzzr;


--
-- Name: TABLE file_exposure; Type: ACL; Schema: mail_manager; Owner: postgres
--

GRANT ALL ON TABLE mail_manager.file_exposure TO tzzr;


--
-- Name: SEQUENCE file_exposure_id_seq; Type: ACL; Schema: mail_manager; Owner: postgres
--

GRANT SELECT,USAGE ON SEQUENCE mail_manager.file_exposure_id_seq TO tzzr;


--
-- Name: TABLE mail_log; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.mail_log TO tzzr;


--
-- Name: SEQUENCE mail_log_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,USAGE ON SEQUENCE public.mail_log_id_seq TO tzzr;


--
-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: mail_manager; Owner: postgres
--

ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA mail_manager GRANT ALL ON TABLES  TO tzzr;


--
--

\unrestrict liiVB9h9uyn31lwdd7RW8IsPLxm769jcMxwEt0zV7T0ysEDpCr9qOlNKgMo1uLh

--
-- Database "nextcloud" dump
--

--
--

\restrict a7tmqH0Y47vKkFmoDBik6JjSCMar3gJKmdRvqy3W6v6jaD0QbhGUTb3aG1tJUhb


SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: nextcloud; Type: DATABASE; Schema: -; Owner: oc_admin
--

CREATE DATABASE nextcloud WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LC_COLLATE = 'C' LC_CTYPE = 'C.UTF-8';


ALTER DATABASE nextcloud OWNER TO oc_admin;

\unrestrict a7tmqH0Y47vKkFmoDBik6JjSCMar3gJKmdRvqy3W6v6jaD0QbhGUTb3aG1tJUhb
\connect nextcloud
\restrict a7tmqH0Y47vKkFmoDBik6JjSCMar3gJKmdRvqy3W6v6jaD0QbhGUTb3aG1tJUhb

SELECT pg_catalog.set_config('search_path', '', false);



--
-- Name: oc_accounts; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_accounts (
    uid character varying(64) DEFAULT ''::character varying NOT NULL,
    data text DEFAULT ''::text NOT NULL
);


ALTER TABLE public.oc_accounts OWNER TO oc_admin;

--
-- Name: oc_accounts_data; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_accounts_data (
    id bigint NOT NULL,
    uid character varying(64) NOT NULL,
    name character varying(64) NOT NULL,
    value character varying(255) DEFAULT ''::character varying
);


ALTER TABLE public.oc_accounts_data OWNER TO oc_admin;

--
-- Name: oc_accounts_data_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_accounts_data_id_seq OWNER TO oc_admin;

--
-- Name: oc_accounts_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_accounts_data_id_seq OWNED BY public.oc_accounts_data.id;


--
-- Name: oc_activity; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_activity (
    activity_id bigint NOT NULL,
    "timestamp" integer DEFAULT 0 NOT NULL,
    priority integer DEFAULT 0 NOT NULL,
    type character varying(255) DEFAULT NULL::character varying,
    "user" character varying(64) DEFAULT NULL::character varying,
    affecteduser character varying(64) NOT NULL,
    app character varying(32) NOT NULL,
    subject character varying(255) NOT NULL,
    subjectparams text NOT NULL,
    message character varying(255) DEFAULT NULL::character varying,
    messageparams text,
    file character varying(4000) DEFAULT NULL::character varying,
    link character varying(4000) DEFAULT NULL::character varying,
    object_type character varying(255) DEFAULT NULL::character varying,
    object_id bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_activity OWNER TO oc_admin;

--
-- Name: oc_activity_activity_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_activity_activity_id_seq OWNER TO oc_admin;

--
-- Name: oc_activity_activity_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_activity_activity_id_seq OWNED BY public.oc_activity.activity_id;


--
-- Name: oc_activity_mq; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_activity_mq (
    mail_id bigint NOT NULL,
    amq_timestamp integer DEFAULT 0 NOT NULL,
    amq_latest_send integer DEFAULT 0 NOT NULL,
    amq_type character varying(255) NOT NULL,
    amq_affecteduser character varying(64) NOT NULL,
    amq_appid character varying(32) NOT NULL,
    amq_subject character varying(255) NOT NULL,
    amq_subjectparams text,
    object_type character varying(255) DEFAULT NULL::character varying,
    object_id bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_activity_mq OWNER TO oc_admin;

--
-- Name: oc_activity_mq_mail_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_activity_mq_mail_id_seq OWNER TO oc_admin;

--
-- Name: oc_activity_mq_mail_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_activity_mq_mail_id_seq OWNED BY public.oc_activity_mq.mail_id;


--
-- Name: oc_addressbookchanges; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_addressbookchanges (
    id bigint NOT NULL,
    uri character varying(255) DEFAULT NULL::character varying,
    synctoken integer DEFAULT 1 NOT NULL,
    addressbookid bigint NOT NULL,
    operation smallint NOT NULL,
    created_at integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_addressbookchanges OWNER TO oc_admin;

--
-- Name: oc_addressbookchanges_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_addressbookchanges_id_seq OWNER TO oc_admin;

--
-- Name: oc_addressbookchanges_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_addressbookchanges_id_seq OWNED BY public.oc_addressbookchanges.id;


--
-- Name: oc_addressbooks; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_addressbooks (
    id bigint NOT NULL,
    principaluri character varying(255) DEFAULT NULL::character varying,
    displayname character varying(255) DEFAULT NULL::character varying,
    uri character varying(255) DEFAULT NULL::character varying,
    description character varying(255) DEFAULT NULL::character varying,
    synctoken integer DEFAULT 1 NOT NULL
);


ALTER TABLE public.oc_addressbooks OWNER TO oc_admin;

--
-- Name: oc_addressbooks_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_addressbooks_id_seq OWNER TO oc_admin;

--
-- Name: oc_addressbooks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_addressbooks_id_seq OWNED BY public.oc_addressbooks.id;


--
-- Name: oc_appconfig; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_appconfig (
    appid character varying(32) DEFAULT ''::character varying NOT NULL,
    configkey character varying(64) DEFAULT ''::character varying NOT NULL,
    configvalue text,
    type integer DEFAULT 2 NOT NULL,
    lazy smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_appconfig OWNER TO oc_admin;

--
-- Name: oc_appconfig_ex; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_appconfig_ex (
    id bigint NOT NULL,
    appid character varying(32) NOT NULL,
    configkey character varying(64) NOT NULL,
    configvalue text,
    sensitive smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_appconfig_ex OWNER TO oc_admin;

--
-- Name: oc_appconfig_ex_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_appconfig_ex_id_seq OWNER TO oc_admin;

--
-- Name: oc_appconfig_ex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_appconfig_ex_id_seq OWNED BY public.oc_appconfig_ex.id;


--
-- Name: oc_authorized_groups; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_authorized_groups (
    id integer NOT NULL,
    group_id character varying(200) NOT NULL,
    class character varying(200) NOT NULL
);


ALTER TABLE public.oc_authorized_groups OWNER TO oc_admin;

--
-- Name: oc_authorized_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_authorized_groups_id_seq OWNER TO oc_admin;

--
-- Name: oc_authorized_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_authorized_groups_id_seq OWNED BY public.oc_authorized_groups.id;


--
-- Name: oc_authtoken; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_authtoken (
    id bigint NOT NULL,
    uid character varying(64) DEFAULT ''::character varying NOT NULL,
    login_name character varying(255) DEFAULT ''::character varying NOT NULL,
    password text,
    name text DEFAULT ''::text NOT NULL,
    token character varying(200) DEFAULT ''::character varying NOT NULL,
    type smallint DEFAULT 0,
    remember smallint DEFAULT 0,
    last_activity integer DEFAULT 0,
    last_check integer DEFAULT 0,
    scope text,
    expires integer,
    private_key text,
    public_key text,
    version smallint DEFAULT 1 NOT NULL,
    password_invalid boolean DEFAULT false,
    password_hash character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_authtoken OWNER TO oc_admin;

--
-- Name: oc_authtoken_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_authtoken_id_seq OWNER TO oc_admin;

--
-- Name: oc_authtoken_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_authtoken_id_seq OWNED BY public.oc_authtoken.id;


--
-- Name: oc_bruteforce_attempts; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_bruteforce_attempts (
    id bigint NOT NULL,
    action character varying(64) DEFAULT ''::character varying NOT NULL,
    occurred integer DEFAULT 0 NOT NULL,
    ip character varying(255) DEFAULT ''::character varying NOT NULL,
    subnet character varying(255) DEFAULT ''::character varying NOT NULL,
    metadata character varying(255) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.oc_bruteforce_attempts OWNER TO oc_admin;

--
-- Name: oc_bruteforce_attempts_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_bruteforce_attempts_id_seq OWNER TO oc_admin;

--
-- Name: oc_bruteforce_attempts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_bruteforce_attempts_id_seq OWNED BY public.oc_bruteforce_attempts.id;


--
-- Name: oc_calendar_invitations; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendar_invitations (
    id bigint NOT NULL,
    uid character varying(255) NOT NULL,
    recurrenceid character varying(255) DEFAULT NULL::character varying,
    attendee character varying(255) NOT NULL,
    organizer character varying(255) NOT NULL,
    sequence bigint,
    token character varying(60) NOT NULL,
    expiration bigint NOT NULL
);


ALTER TABLE public.oc_calendar_invitations OWNER TO oc_admin;

--
-- Name: oc_calendar_invitations_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendar_invitations_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendar_invitations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendar_invitations_id_seq OWNED BY public.oc_calendar_invitations.id;


--
-- Name: oc_calendar_reminders; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendar_reminders (
    id bigint NOT NULL,
    calendar_id bigint NOT NULL,
    object_id bigint NOT NULL,
    is_recurring smallint,
    uid character varying(255) NOT NULL,
    recurrence_id bigint,
    is_recurrence_exception smallint NOT NULL,
    event_hash character varying(255) NOT NULL,
    alarm_hash character varying(255) NOT NULL,
    type character varying(255) NOT NULL,
    is_relative smallint NOT NULL,
    notification_date bigint NOT NULL,
    is_repeat_based smallint NOT NULL
);


ALTER TABLE public.oc_calendar_reminders OWNER TO oc_admin;

--
-- Name: oc_calendar_reminders_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendar_reminders_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendar_reminders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendar_reminders_id_seq OWNED BY public.oc_calendar_reminders.id;


--
-- Name: oc_calendar_resources; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendar_resources (
    id bigint NOT NULL,
    backend_id character varying(64) DEFAULT NULL::character varying,
    resource_id character varying(64) DEFAULT NULL::character varying,
    email character varying(255) DEFAULT NULL::character varying,
    displayname character varying(255) DEFAULT NULL::character varying,
    group_restrictions character varying(4000) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_calendar_resources OWNER TO oc_admin;

--
-- Name: oc_calendar_resources_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendar_resources_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendar_resources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendar_resources_id_seq OWNED BY public.oc_calendar_resources.id;


--
-- Name: oc_calendar_resources_md; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendar_resources_md (
    id bigint NOT NULL,
    resource_id bigint NOT NULL,
    key character varying(255) NOT NULL,
    value character varying(4000) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_calendar_resources_md OWNER TO oc_admin;

--
-- Name: oc_calendar_resources_md_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendar_resources_md_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendar_resources_md_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendar_resources_md_id_seq OWNED BY public.oc_calendar_resources_md.id;


--
-- Name: oc_calendar_rooms; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendar_rooms (
    id bigint NOT NULL,
    backend_id character varying(64) DEFAULT NULL::character varying,
    resource_id character varying(64) DEFAULT NULL::character varying,
    email character varying(255) DEFAULT NULL::character varying,
    displayname character varying(255) DEFAULT NULL::character varying,
    group_restrictions character varying(4000) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_calendar_rooms OWNER TO oc_admin;

--
-- Name: oc_calendar_rooms_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendar_rooms_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendar_rooms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendar_rooms_id_seq OWNED BY public.oc_calendar_rooms.id;


--
-- Name: oc_calendar_rooms_md; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendar_rooms_md (
    id bigint NOT NULL,
    room_id bigint NOT NULL,
    key character varying(255) NOT NULL,
    value character varying(4000) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_calendar_rooms_md OWNER TO oc_admin;

--
-- Name: oc_calendar_rooms_md_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendar_rooms_md_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendar_rooms_md_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendar_rooms_md_id_seq OWNED BY public.oc_calendar_rooms_md.id;


--
-- Name: oc_calendarchanges; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendarchanges (
    id bigint NOT NULL,
    uri character varying(255) DEFAULT NULL::character varying,
    synctoken integer DEFAULT 1 NOT NULL,
    calendarid bigint NOT NULL,
    operation smallint NOT NULL,
    calendartype integer DEFAULT 0 NOT NULL,
    created_at integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_calendarchanges OWNER TO oc_admin;

--
-- Name: oc_calendarchanges_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendarchanges_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendarchanges_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendarchanges_id_seq OWNED BY public.oc_calendarchanges.id;


--
-- Name: oc_calendarobjects; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendarobjects (
    id bigint NOT NULL,
    calendardata bytea,
    uri character varying(255) DEFAULT NULL::character varying,
    calendarid bigint NOT NULL,
    lastmodified integer,
    etag character varying(32) DEFAULT NULL::character varying,
    size bigint NOT NULL,
    componenttype character varying(8) DEFAULT NULL::character varying,
    firstoccurence bigint,
    lastoccurence bigint,
    uid character varying(255) DEFAULT NULL::character varying,
    classification integer DEFAULT 0,
    calendartype integer DEFAULT 0 NOT NULL,
    deleted_at integer
);


ALTER TABLE public.oc_calendarobjects OWNER TO oc_admin;

--
-- Name: oc_calendarobjects_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendarobjects_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendarobjects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendarobjects_id_seq OWNED BY public.oc_calendarobjects.id;


--
-- Name: oc_calendarobjects_props; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendarobjects_props (
    id bigint NOT NULL,
    calendarid bigint DEFAULT 0 NOT NULL,
    objectid bigint DEFAULT 0 NOT NULL,
    name character varying(64) DEFAULT NULL::character varying,
    parameter character varying(64) DEFAULT NULL::character varying,
    value character varying(255) DEFAULT NULL::character varying,
    calendartype integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_calendarobjects_props OWNER TO oc_admin;

--
-- Name: oc_calendarobjects_props_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendarobjects_props_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendarobjects_props_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendarobjects_props_id_seq OWNED BY public.oc_calendarobjects_props.id;


--
-- Name: oc_calendars; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendars (
    id bigint NOT NULL,
    principaluri character varying(255) DEFAULT NULL::character varying,
    displayname character varying(255) DEFAULT NULL::character varying,
    uri character varying(255) DEFAULT NULL::character varying,
    synctoken integer DEFAULT 1 NOT NULL,
    description character varying(255) DEFAULT NULL::character varying,
    calendarorder integer DEFAULT 0 NOT NULL,
    calendarcolor character varying(255) DEFAULT NULL::character varying,
    timezone text,
    components character varying(64) DEFAULT NULL::character varying,
    transparent smallint DEFAULT 0 NOT NULL,
    deleted_at integer
);


ALTER TABLE public.oc_calendars OWNER TO oc_admin;

--
-- Name: oc_calendars_federated; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendars_federated (
    id bigint NOT NULL,
    display_name character varying(255) NOT NULL,
    color character varying(7) DEFAULT NULL::character varying,
    uri character varying(255) NOT NULL,
    principaluri character varying(255) NOT NULL,
    remote_url character varying(255) NOT NULL,
    token character varying(255) NOT NULL,
    sync_token integer DEFAULT 0 NOT NULL,
    last_sync bigint,
    shared_by character varying(255) NOT NULL,
    shared_by_display_name character varying(255) NOT NULL,
    components character varying(255) NOT NULL,
    permissions integer NOT NULL
);


ALTER TABLE public.oc_calendars_federated OWNER TO oc_admin;

--
-- Name: oc_calendars_federated_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendars_federated_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendars_federated_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendars_federated_id_seq OWNED BY public.oc_calendars_federated.id;


--
-- Name: oc_calendars_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendars_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendars_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendars_id_seq OWNED BY public.oc_calendars.id;


--
-- Name: oc_calendarsubscriptions; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_calendarsubscriptions (
    id bigint NOT NULL,
    uri character varying(255) DEFAULT NULL::character varying,
    principaluri character varying(255) DEFAULT NULL::character varying,
    displayname character varying(100) DEFAULT NULL::character varying,
    refreshrate character varying(10) DEFAULT NULL::character varying,
    calendarorder integer DEFAULT 0 NOT NULL,
    calendarcolor character varying(255) DEFAULT NULL::character varying,
    striptodos smallint,
    stripalarms smallint,
    stripattachments smallint,
    lastmodified integer,
    synctoken integer DEFAULT 1 NOT NULL,
    source text
);


ALTER TABLE public.oc_calendarsubscriptions OWNER TO oc_admin;

--
-- Name: oc_calendarsubscriptions_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_calendarsubscriptions_id_seq OWNER TO oc_admin;

--
-- Name: oc_calendarsubscriptions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_calendarsubscriptions_id_seq OWNED BY public.oc_calendarsubscriptions.id;


--
-- Name: oc_cards; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_cards (
    id bigint NOT NULL,
    addressbookid bigint DEFAULT 0 NOT NULL,
    carddata bytea,
    uri character varying(255) DEFAULT NULL::character varying,
    lastmodified bigint,
    etag character varying(32) DEFAULT NULL::character varying,
    size bigint NOT NULL,
    uid character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_cards OWNER TO oc_admin;

--
-- Name: oc_cards_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_cards_id_seq OWNER TO oc_admin;

--
-- Name: oc_cards_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_cards_id_seq OWNED BY public.oc_cards.id;


--
-- Name: oc_cards_properties; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_cards_properties (
    id bigint NOT NULL,
    addressbookid bigint DEFAULT 0 NOT NULL,
    cardid bigint DEFAULT 0 NOT NULL,
    name character varying(64) DEFAULT NULL::character varying,
    value character varying(255) DEFAULT NULL::character varying,
    preferred integer DEFAULT 1 NOT NULL
);


ALTER TABLE public.oc_cards_properties OWNER TO oc_admin;

--
-- Name: oc_cards_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_cards_properties_id_seq OWNER TO oc_admin;

--
-- Name: oc_cards_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_cards_properties_id_seq OWNED BY public.oc_cards_properties.id;


--
-- Name: oc_circles_circle; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_circles_circle (
    id integer NOT NULL,
    unique_id character varying(31) NOT NULL,
    name character varying(127) NOT NULL,
    display_name character varying(255) DEFAULT ''::character varying,
    sanitized_name character varying(127) DEFAULT ''::character varying,
    instance character varying(255) DEFAULT ''::character varying,
    config integer,
    source integer,
    settings text,
    description text,
    creation timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
    contact_addressbook integer,
    contact_groupname character varying(127) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_circles_circle OWNER TO oc_admin;

--
-- Name: oc_circles_circle_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_circles_circle_id_seq OWNER TO oc_admin;

--
-- Name: oc_circles_circle_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_circles_circle_id_seq OWNED BY public.oc_circles_circle.id;


--
-- Name: oc_circles_event; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_circles_event (
    token character varying(63) NOT NULL,
    instance character varying(255) NOT NULL,
    event text,
    result text,
    interface integer DEFAULT 0 NOT NULL,
    severity integer,
    retry integer,
    status integer,
    updated timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
    creation bigint
);


ALTER TABLE public.oc_circles_event OWNER TO oc_admin;

--
-- Name: oc_circles_member; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_circles_member (
    id integer NOT NULL,
    single_id character varying(31) DEFAULT NULL::character varying,
    circle_id character varying(31) NOT NULL,
    member_id character varying(31) DEFAULT NULL::character varying,
    user_id character varying(127) NOT NULL,
    user_type smallint DEFAULT 1 NOT NULL,
    instance character varying(255) DEFAULT ''::character varying,
    invited_by character varying(31) DEFAULT NULL::character varying,
    level smallint NOT NULL,
    status character varying(15) DEFAULT NULL::character varying,
    note text,
    cached_name character varying(255) DEFAULT ''::character varying,
    cached_update timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
    contact_id character varying(127) DEFAULT NULL::character varying,
    contact_meta text,
    joined timestamp(0) without time zone DEFAULT NULL::timestamp without time zone
);


ALTER TABLE public.oc_circles_member OWNER TO oc_admin;

--
-- Name: oc_circles_member_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_circles_member_id_seq OWNER TO oc_admin;

--
-- Name: oc_circles_member_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_circles_member_id_seq OWNED BY public.oc_circles_member.id;


--
-- Name: oc_circles_membership; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_circles_membership (
    circle_id character varying(31) NOT NULL,
    single_id character varying(31) NOT NULL,
    level integer NOT NULL,
    inheritance_first character varying(31) NOT NULL,
    inheritance_last character varying(31) NOT NULL,
    inheritance_depth integer NOT NULL,
    inheritance_path text NOT NULL
);


ALTER TABLE public.oc_circles_membership OWNER TO oc_admin;

--
-- Name: oc_circles_mount; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_circles_mount (
    id integer NOT NULL,
    mount_id character varying(31) NOT NULL,
    circle_id character varying(31) NOT NULL,
    single_id character varying(31) NOT NULL,
    token character varying(63) DEFAULT NULL::character varying,
    parent integer,
    mountpoint text,
    mountpoint_hash character varying(64) DEFAULT NULL::character varying,
    remote character varying(255) DEFAULT ''::character varying,
    remote_id integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_circles_mount OWNER TO oc_admin;

--
-- Name: oc_circles_mount_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_circles_mount_id_seq OWNER TO oc_admin;

--
-- Name: oc_circles_mount_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_circles_mount_id_seq OWNED BY public.oc_circles_mount.id;


--
-- Name: oc_circles_mountpoint; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_circles_mountpoint (
    id integer NOT NULL,
    mount_id character varying(31) NOT NULL,
    single_id character varying(31) NOT NULL,
    mountpoint text,
    mountpoint_hash character varying(64) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_circles_mountpoint OWNER TO oc_admin;

--
-- Name: oc_circles_mountpoint_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_circles_mountpoint_id_seq OWNER TO oc_admin;

--
-- Name: oc_circles_mountpoint_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_circles_mountpoint_id_seq OWNED BY public.oc_circles_mountpoint.id;


--
-- Name: oc_circles_remote; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_circles_remote (
    id integer NOT NULL,
    type character varying(15) DEFAULT 'Unknown'::character varying NOT NULL,
    interface integer DEFAULT 0 NOT NULL,
    uid character varying(20) DEFAULT NULL::character varying,
    instance character varying(127) DEFAULT NULL::character varying,
    href character varying(254) DEFAULT NULL::character varying,
    item text,
    creation timestamp(0) without time zone DEFAULT NULL::timestamp without time zone
);


ALTER TABLE public.oc_circles_remote OWNER TO oc_admin;

--
-- Name: oc_circles_remote_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_circles_remote_id_seq OWNER TO oc_admin;

--
-- Name: oc_circles_remote_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_circles_remote_id_seq OWNED BY public.oc_circles_remote.id;


--
-- Name: oc_circles_share_lock; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_circles_share_lock (
    id integer NOT NULL,
    item_id character varying(31) NOT NULL,
    circle_id character varying(31) NOT NULL,
    instance character varying(127) NOT NULL
);


ALTER TABLE public.oc_circles_share_lock OWNER TO oc_admin;

--
-- Name: oc_circles_share_lock_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_circles_share_lock_id_seq OWNER TO oc_admin;

--
-- Name: oc_circles_share_lock_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_circles_share_lock_id_seq OWNED BY public.oc_circles_share_lock.id;


--
-- Name: oc_circles_token; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_circles_token (
    id integer NOT NULL,
    share_id integer,
    circle_id character varying(31) DEFAULT NULL::character varying,
    single_id character varying(31) DEFAULT NULL::character varying,
    member_id character varying(31) DEFAULT NULL::character varying,
    token character varying(31) DEFAULT NULL::character varying,
    password character varying(127) DEFAULT NULL::character varying,
    accepted integer
);


ALTER TABLE public.oc_circles_token OWNER TO oc_admin;

--
-- Name: oc_circles_token_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_circles_token_id_seq OWNER TO oc_admin;

--
-- Name: oc_circles_token_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_circles_token_id_seq OWNED BY public.oc_circles_token.id;


--
-- Name: oc_collres_accesscache; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_collres_accesscache (
    user_id character varying(64) NOT NULL,
    collection_id bigint DEFAULT 0 NOT NULL,
    resource_type character varying(64) DEFAULT ''::character varying NOT NULL,
    resource_id character varying(64) DEFAULT ''::character varying NOT NULL,
    access boolean DEFAULT false
);


ALTER TABLE public.oc_collres_accesscache OWNER TO oc_admin;

--
-- Name: oc_collres_collections; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_collres_collections (
    id bigint NOT NULL,
    name character varying(64) NOT NULL
);


ALTER TABLE public.oc_collres_collections OWNER TO oc_admin;

--
-- Name: oc_collres_collections_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_collres_collections_id_seq OWNER TO oc_admin;

--
-- Name: oc_collres_collections_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_collres_collections_id_seq OWNED BY public.oc_collres_collections.id;


--
-- Name: oc_collres_resources; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_collres_resources (
    collection_id bigint NOT NULL,
    resource_type character varying(64) NOT NULL,
    resource_id character varying(64) NOT NULL
);


ALTER TABLE public.oc_collres_resources OWNER TO oc_admin;

--
-- Name: oc_comments; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_comments (
    id bigint NOT NULL,
    parent_id bigint DEFAULT 0 NOT NULL,
    topmost_parent_id bigint DEFAULT 0 NOT NULL,
    children_count integer DEFAULT 0 NOT NULL,
    actor_type character varying(64) DEFAULT ''::character varying NOT NULL,
    actor_id character varying(64) DEFAULT ''::character varying NOT NULL,
    message text,
    verb character varying(64) DEFAULT NULL::character varying,
    creation_timestamp timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
    latest_child_timestamp timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
    object_type character varying(64) DEFAULT ''::character varying NOT NULL,
    object_id character varying(64) DEFAULT ''::character varying NOT NULL,
    reference_id character varying(64) DEFAULT NULL::character varying,
    reactions character varying(4000) DEFAULT NULL::character varying,
    expire_date timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
    meta_data text DEFAULT ''::text
);


ALTER TABLE public.oc_comments OWNER TO oc_admin;

--
-- Name: oc_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_comments_id_seq OWNER TO oc_admin;

--
-- Name: oc_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_comments_id_seq OWNED BY public.oc_comments.id;


--
-- Name: oc_comments_read_markers; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_comments_read_markers (
    user_id character varying(64) DEFAULT ''::character varying NOT NULL,
    object_type character varying(64) DEFAULT ''::character varying NOT NULL,
    object_id character varying(64) DEFAULT ''::character varying NOT NULL,
    marker_datetime timestamp(0) without time zone DEFAULT NULL::timestamp without time zone
);


ALTER TABLE public.oc_comments_read_markers OWNER TO oc_admin;

--
-- Name: oc_dav_absence; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_dav_absence (
    id integer NOT NULL,
    user_id character varying(64) NOT NULL,
    first_day character varying(10) NOT NULL,
    last_day character varying(10) NOT NULL,
    status character varying(100) NOT NULL,
    message text NOT NULL,
    replacement_user_id character varying(64) DEFAULT ''::character varying,
    replacement_user_display_name character varying(64) DEFAULT ''::character varying
);


ALTER TABLE public.oc_dav_absence OWNER TO oc_admin;

--
-- Name: oc_dav_absence_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_dav_absence_id_seq OWNER TO oc_admin;

--
-- Name: oc_dav_absence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_dav_absence_id_seq OWNED BY public.oc_dav_absence.id;


--
-- Name: oc_dav_cal_proxy; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_dav_cal_proxy (
    id bigint NOT NULL,
    owner_id character varying(64) NOT NULL,
    proxy_id character varying(64) NOT NULL,
    permissions integer
);


ALTER TABLE public.oc_dav_cal_proxy OWNER TO oc_admin;

--
-- Name: oc_dav_cal_proxy_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_dav_cal_proxy_id_seq OWNER TO oc_admin;

--
-- Name: oc_dav_cal_proxy_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_dav_cal_proxy_id_seq OWNED BY public.oc_dav_cal_proxy.id;


--
-- Name: oc_dav_shares; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_dav_shares (
    id bigint NOT NULL,
    principaluri character varying(255) DEFAULT NULL::character varying,
    type character varying(255) DEFAULT NULL::character varying,
    access smallint,
    resourceid bigint NOT NULL,
    publicuri character varying(255) DEFAULT NULL::character varying,
    token character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_dav_shares OWNER TO oc_admin;

--
-- Name: oc_dav_shares_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_dav_shares_id_seq OWNER TO oc_admin;

--
-- Name: oc_dav_shares_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_dav_shares_id_seq OWNED BY public.oc_dav_shares.id;


--
-- Name: oc_direct_edit; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_direct_edit (
    id bigint NOT NULL,
    editor_id character varying(64) NOT NULL,
    token character varying(64) NOT NULL,
    file_id bigint NOT NULL,
    user_id character varying(64) DEFAULT NULL::character varying,
    share_id bigint,
    "timestamp" bigint NOT NULL,
    accessed boolean DEFAULT false,
    file_path character varying(4000) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_direct_edit OWNER TO oc_admin;

--
-- Name: oc_direct_edit_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_direct_edit_id_seq OWNER TO oc_admin;

--
-- Name: oc_direct_edit_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_direct_edit_id_seq OWNED BY public.oc_direct_edit.id;


--
-- Name: oc_directlink; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_directlink (
    id bigint NOT NULL,
    user_id character varying(64) DEFAULT NULL::character varying,
    file_id bigint NOT NULL,
    token character varying(60) DEFAULT NULL::character varying,
    expiration bigint NOT NULL
);


ALTER TABLE public.oc_directlink OWNER TO oc_admin;

--
-- Name: oc_directlink_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_directlink_id_seq OWNER TO oc_admin;

--
-- Name: oc_directlink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_directlink_id_seq OWNED BY public.oc_directlink.id;


--
-- Name: oc_ex_apps; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_apps (
    id bigint NOT NULL,
    appid character varying(32) NOT NULL,
    version character varying(32) NOT NULL,
    name character varying(64) NOT NULL,
    daemon_config_name character varying(64) DEFAULT '0'::character varying NOT NULL,
    port smallint NOT NULL,
    secret character varying(256) NOT NULL,
    status json NOT NULL,
    enabled smallint DEFAULT 0 NOT NULL,
    created_time bigint NOT NULL
);


ALTER TABLE public.oc_ex_apps OWNER TO oc_admin;

--
-- Name: oc_ex_apps_daemons; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_apps_daemons (
    id bigint NOT NULL,
    name character varying(64) NOT NULL,
    display_name character varying(255) NOT NULL,
    accepts_deploy_id character varying(64) NOT NULL,
    protocol character varying(32) NOT NULL,
    host character varying(255) NOT NULL,
    deploy_config json NOT NULL
);


ALTER TABLE public.oc_ex_apps_daemons OWNER TO oc_admin;

--
-- Name: oc_ex_apps_daemons_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_apps_daemons_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_apps_daemons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_apps_daemons_id_seq OWNED BY public.oc_ex_apps_daemons.id;


--
-- Name: oc_ex_apps_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_apps_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_apps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_apps_id_seq OWNED BY public.oc_ex_apps.id;


--
-- Name: oc_ex_apps_routes; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_apps_routes (
    id integer NOT NULL,
    appid character varying(32) NOT NULL,
    url character varying(512) NOT NULL,
    verb character varying(64) NOT NULL,
    access_level integer DEFAULT 0 NOT NULL,
    headers_to_exclude character varying(512) DEFAULT NULL::character varying,
    bruteforce_protection character varying(512) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_ex_apps_routes OWNER TO oc_admin;

--
-- Name: oc_ex_apps_routes_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_apps_routes_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_apps_routes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_apps_routes_id_seq OWNED BY public.oc_ex_apps_routes.id;


--
-- Name: oc_ex_deploy_options; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_deploy_options (
    id bigint NOT NULL,
    appid character varying(32) NOT NULL,
    type character varying(32) NOT NULL,
    value json NOT NULL
);


ALTER TABLE public.oc_ex_deploy_options OWNER TO oc_admin;

--
-- Name: oc_ex_deploy_options_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_deploy_options_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_deploy_options_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_deploy_options_id_seq OWNED BY public.oc_ex_deploy_options.id;


--
-- Name: oc_ex_occ_commands; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_occ_commands (
    id bigint NOT NULL,
    appid character varying(32) NOT NULL,
    name character varying(64) NOT NULL,
    description character varying(255) DEFAULT NULL::character varying,
    hidden smallint DEFAULT 0 NOT NULL,
    arguments json NOT NULL,
    options json NOT NULL,
    usages json NOT NULL,
    execute_handler character varying(410) NOT NULL
);


ALTER TABLE public.oc_ex_occ_commands OWNER TO oc_admin;

--
-- Name: oc_ex_occ_commands_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_occ_commands_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_occ_commands_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_occ_commands_id_seq OWNED BY public.oc_ex_occ_commands.id;


--
-- Name: oc_ex_settings_forms; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_settings_forms (
    id bigint NOT NULL,
    appid character varying(32) NOT NULL,
    formid character varying(64) NOT NULL,
    scheme json NOT NULL
);


ALTER TABLE public.oc_ex_settings_forms OWNER TO oc_admin;

--
-- Name: oc_ex_settings_forms_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_settings_forms_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_settings_forms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_settings_forms_id_seq OWNED BY public.oc_ex_settings_forms.id;


--
-- Name: oc_ex_task_processing; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_task_processing (
    id bigint NOT NULL,
    app_id character varying(32) NOT NULL,
    name character varying(255) NOT NULL,
    display_name character varying(255) NOT NULL,
    task_type character varying(255) NOT NULL,
    custom_task_type text,
    provider text NOT NULL
);


ALTER TABLE public.oc_ex_task_processing OWNER TO oc_admin;

--
-- Name: oc_ex_task_processing_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_task_processing_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_task_processing_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_task_processing_id_seq OWNED BY public.oc_ex_task_processing.id;


--
-- Name: oc_ex_ui_files_actions; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_ui_files_actions (
    id bigint NOT NULL,
    appid character varying(32) NOT NULL,
    name character varying(64) NOT NULL,
    display_name character varying(64) NOT NULL,
    mime text DEFAULT 'file'::text NOT NULL,
    permissions character varying(255) NOT NULL,
    "order" bigint DEFAULT 0 NOT NULL,
    icon character varying(255) DEFAULT ''::character varying,
    action_handler character varying(64) NOT NULL,
    version character varying(64) DEFAULT '1.0'::character varying NOT NULL
);


ALTER TABLE public.oc_ex_ui_files_actions OWNER TO oc_admin;

--
-- Name: oc_ex_ui_files_actions_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_ui_files_actions_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_ui_files_actions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_ui_files_actions_id_seq OWNED BY public.oc_ex_ui_files_actions.id;


--
-- Name: oc_ex_ui_scripts; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_ui_scripts (
    id bigint NOT NULL,
    appid character varying(32) NOT NULL,
    type character varying(16) NOT NULL,
    name character varying(32) NOT NULL,
    path character varying(410) NOT NULL,
    after_app_id character varying(32) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_ex_ui_scripts OWNER TO oc_admin;

--
-- Name: oc_ex_ui_scripts_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_ui_scripts_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_ui_scripts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_ui_scripts_id_seq OWNED BY public.oc_ex_ui_scripts.id;


--
-- Name: oc_ex_ui_states; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_ui_states (
    id bigint NOT NULL,
    appid character varying(32) NOT NULL,
    type character varying(16) NOT NULL,
    name character varying(32) NOT NULL,
    key character varying(64) NOT NULL,
    value json NOT NULL
);


ALTER TABLE public.oc_ex_ui_states OWNER TO oc_admin;

--
-- Name: oc_ex_ui_states_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_ui_states_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_ui_states_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_ui_states_id_seq OWNED BY public.oc_ex_ui_states.id;


--
-- Name: oc_ex_ui_styles; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_ui_styles (
    id bigint NOT NULL,
    appid character varying(32) NOT NULL,
    type character varying(16) NOT NULL,
    name character varying(32) NOT NULL,
    path character varying(410) NOT NULL
);


ALTER TABLE public.oc_ex_ui_styles OWNER TO oc_admin;

--
-- Name: oc_ex_ui_styles_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_ui_styles_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_ui_styles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_ui_styles_id_seq OWNED BY public.oc_ex_ui_styles.id;


--
-- Name: oc_ex_ui_top_menu; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ex_ui_top_menu (
    id bigint NOT NULL,
    appid character varying(32) NOT NULL,
    name character varying(32) NOT NULL,
    display_name character varying(32) NOT NULL,
    icon character varying(255) DEFAULT ''::character varying,
    admin_required smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_ex_ui_top_menu OWNER TO oc_admin;

--
-- Name: oc_ex_ui_top_menu_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ex_ui_top_menu_id_seq OWNER TO oc_admin;

--
-- Name: oc_ex_ui_top_menu_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ex_ui_top_menu_id_seq OWNED BY public.oc_ex_ui_top_menu.id;


--
-- Name: oc_federated_invites; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_federated_invites (
    id bigint NOT NULL,
    user_id character varying(64) NOT NULL,
    recipient_provider character varying(2083) DEFAULT NULL::character varying,
    recipient_user_id character varying(1024) DEFAULT NULL::character varying,
    recipient_name character varying(1024) DEFAULT NULL::character varying,
    recipient_email character varying(320) DEFAULT NULL::character varying,
    token character varying(60) NOT NULL,
    accepted boolean DEFAULT false,
    created_at bigint NOT NULL,
    expired_at bigint,
    accepted_at bigint
);


ALTER TABLE public.oc_federated_invites OWNER TO oc_admin;

--
-- Name: oc_federated_invites_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_federated_invites_id_seq OWNER TO oc_admin;

--
-- Name: oc_federated_invites_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_federated_invites_id_seq OWNED BY public.oc_federated_invites.id;


--
-- Name: oc_federated_reshares; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_federated_reshares (
    share_id bigint NOT NULL,
    remote_id character varying(255) DEFAULT ''::character varying
);


ALTER TABLE public.oc_federated_reshares OWNER TO oc_admin;

--
-- Name: oc_file_locks; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_file_locks (
    id bigint NOT NULL,
    lock integer DEFAULT 0 NOT NULL,
    key character varying(64) NOT NULL,
    ttl integer DEFAULT '-1'::integer NOT NULL
);


ALTER TABLE public.oc_file_locks OWNER TO oc_admin;

--
-- Name: oc_file_locks_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_file_locks_id_seq OWNER TO oc_admin;

--
-- Name: oc_file_locks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_file_locks_id_seq OWNED BY public.oc_file_locks.id;


--
-- Name: oc_filecache; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_filecache (
    fileid bigint NOT NULL,
    storage bigint DEFAULT 0 NOT NULL,
    path character varying(4000) DEFAULT NULL::character varying,
    path_hash character varying(32) DEFAULT ''::character varying NOT NULL,
    parent bigint DEFAULT 0 NOT NULL,
    name character varying(250) DEFAULT NULL::character varying,
    mimetype bigint DEFAULT 0 NOT NULL,
    mimepart bigint DEFAULT 0 NOT NULL,
    size bigint DEFAULT 0 NOT NULL,
    mtime bigint DEFAULT 0 NOT NULL,
    storage_mtime bigint DEFAULT 0 NOT NULL,
    encrypted integer DEFAULT 0 NOT NULL,
    unencrypted_size bigint DEFAULT 0 NOT NULL,
    etag character varying(40) DEFAULT NULL::character varying,
    permissions integer DEFAULT 0,
    checksum character varying(255) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_filecache OWNER TO oc_admin;

--
-- Name: oc_filecache_extended; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_filecache_extended (
    fileid bigint NOT NULL,
    metadata_etag character varying(40) DEFAULT NULL::character varying,
    creation_time bigint DEFAULT 0 NOT NULL,
    upload_time bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_filecache_extended OWNER TO oc_admin;

--
-- Name: oc_filecache_fileid_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_filecache_fileid_seq OWNER TO oc_admin;

--
-- Name: oc_filecache_fileid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_filecache_fileid_seq OWNED BY public.oc_filecache.fileid;


--
-- Name: oc_files_metadata; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_files_metadata (
    id bigint NOT NULL,
    file_id bigint NOT NULL,
    json text NOT NULL,
    sync_token character varying(15) NOT NULL,
    last_update timestamp(0) without time zone NOT NULL
);


ALTER TABLE public.oc_files_metadata OWNER TO oc_admin;

--
-- Name: oc_files_metadata_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_files_metadata_id_seq OWNER TO oc_admin;

--
-- Name: oc_files_metadata_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_files_metadata_id_seq OWNED BY public.oc_files_metadata.id;


--
-- Name: oc_files_metadata_index; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_files_metadata_index (
    id bigint NOT NULL,
    file_id bigint NOT NULL,
    meta_key character varying(31) DEFAULT NULL::character varying,
    meta_value_string character varying(63) DEFAULT NULL::character varying,
    meta_value_int bigint
);


ALTER TABLE public.oc_files_metadata_index OWNER TO oc_admin;

--
-- Name: oc_files_metadata_index_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_files_metadata_index_id_seq OWNER TO oc_admin;

--
-- Name: oc_files_metadata_index_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_files_metadata_index_id_seq OWNED BY public.oc_files_metadata_index.id;


--
-- Name: oc_files_reminders; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_files_reminders (
    id bigint NOT NULL,
    user_id character varying(64) NOT NULL,
    file_id bigint NOT NULL,
    due_date timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    notified boolean DEFAULT false
);


ALTER TABLE public.oc_files_reminders OWNER TO oc_admin;

--
-- Name: oc_files_reminders_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_files_reminders_id_seq OWNER TO oc_admin;

--
-- Name: oc_files_reminders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_files_reminders_id_seq OWNED BY public.oc_files_reminders.id;


--
-- Name: oc_files_trash; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_files_trash (
    auto_id bigint NOT NULL,
    id character varying(250) DEFAULT ''::character varying NOT NULL,
    "user" character varying(64) DEFAULT ''::character varying NOT NULL,
    "timestamp" character varying(12) DEFAULT ''::character varying NOT NULL,
    location character varying(512) DEFAULT ''::character varying NOT NULL,
    type character varying(4) DEFAULT NULL::character varying,
    mime character varying(255) DEFAULT NULL::character varying,
    deleted_by character varying(64) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_files_trash OWNER TO oc_admin;

--
-- Name: oc_files_trash_auto_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_files_trash_auto_id_seq OWNER TO oc_admin;

--
-- Name: oc_files_trash_auto_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_files_trash_auto_id_seq OWNED BY public.oc_files_trash.auto_id;


--
-- Name: oc_files_versions; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_files_versions (
    id bigint NOT NULL,
    file_id bigint NOT NULL,
    "timestamp" bigint NOT NULL,
    size bigint NOT NULL,
    mimetype bigint NOT NULL,
    metadata json NOT NULL
);


ALTER TABLE public.oc_files_versions OWNER TO oc_admin;

--
-- Name: oc_files_versions_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_files_versions_id_seq OWNER TO oc_admin;

--
-- Name: oc_files_versions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_files_versions_id_seq OWNED BY public.oc_files_versions.id;


--
-- Name: oc_flow_checks; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_flow_checks (
    id integer NOT NULL,
    class character varying(256) DEFAULT ''::character varying NOT NULL,
    operator character varying(16) DEFAULT ''::character varying NOT NULL,
    value text,
    hash character varying(32) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.oc_flow_checks OWNER TO oc_admin;

--
-- Name: oc_flow_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_flow_checks_id_seq OWNER TO oc_admin;

--
-- Name: oc_flow_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_flow_checks_id_seq OWNED BY public.oc_flow_checks.id;


--
-- Name: oc_flow_operations; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_flow_operations (
    id integer NOT NULL,
    class character varying(256) DEFAULT ''::character varying NOT NULL,
    name character varying(256) DEFAULT ''::character varying,
    checks text,
    operation text,
    entity character varying(256) DEFAULT 'OCA\WorkflowEngine\Entity\File'::character varying NOT NULL,
    events text DEFAULT '[]'::text NOT NULL
);


ALTER TABLE public.oc_flow_operations OWNER TO oc_admin;

--
-- Name: oc_flow_operations_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_flow_operations_id_seq OWNER TO oc_admin;

--
-- Name: oc_flow_operations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_flow_operations_id_seq OWNED BY public.oc_flow_operations.id;


--
-- Name: oc_flow_operations_scope; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_flow_operations_scope (
    id bigint NOT NULL,
    operation_id integer DEFAULT 0 NOT NULL,
    type integer DEFAULT 0 NOT NULL,
    value character varying(64) DEFAULT ''::character varying
);


ALTER TABLE public.oc_flow_operations_scope OWNER TO oc_admin;

--
-- Name: oc_flow_operations_scope_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_flow_operations_scope_id_seq OWNER TO oc_admin;

--
-- Name: oc_flow_operations_scope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_flow_operations_scope_id_seq OWNED BY public.oc_flow_operations_scope.id;


--
-- Name: oc_group_admin; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_group_admin (
    gid character varying(64) DEFAULT ''::character varying NOT NULL,
    uid character varying(64) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.oc_group_admin OWNER TO oc_admin;

--
-- Name: oc_group_user; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_group_user (
    gid character varying(64) DEFAULT ''::character varying NOT NULL,
    uid character varying(64) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.oc_group_user OWNER TO oc_admin;

--
-- Name: oc_groups; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_groups (
    gid character varying(64) DEFAULT ''::character varying NOT NULL,
    displayname character varying(255) DEFAULT 'name'::character varying NOT NULL
);


ALTER TABLE public.oc_groups OWNER TO oc_admin;

--
-- Name: oc_jobs; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_jobs (
    id bigint NOT NULL,
    class character varying(255) DEFAULT ''::character varying NOT NULL,
    argument character varying(4000) DEFAULT ''::character varying NOT NULL,
    last_run integer DEFAULT 0,
    last_checked integer DEFAULT 0,
    reserved_at integer DEFAULT 0,
    execution_duration integer DEFAULT 0,
    argument_hash character varying(64) DEFAULT NULL::character varying,
    time_sensitive smallint DEFAULT 1 NOT NULL
);


ALTER TABLE public.oc_jobs OWNER TO oc_admin;

--
-- Name: oc_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_jobs_id_seq OWNER TO oc_admin;

--
-- Name: oc_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_jobs_id_seq OWNED BY public.oc_jobs.id;


--
-- Name: oc_known_users; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_known_users (
    id bigint NOT NULL,
    known_to character varying(255) NOT NULL,
    known_user character varying(255) NOT NULL
);


ALTER TABLE public.oc_known_users OWNER TO oc_admin;

--
-- Name: oc_known_users_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_known_users_id_seq OWNER TO oc_admin;

--
-- Name: oc_known_users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_known_users_id_seq OWNED BY public.oc_known_users.id;


--
-- Name: oc_login_flow_v2; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_login_flow_v2 (
    id bigint NOT NULL,
    "timestamp" bigint NOT NULL,
    started smallint DEFAULT 0 NOT NULL,
    poll_token character varying(255) NOT NULL,
    login_token character varying(255) NOT NULL,
    public_key text NOT NULL,
    private_key text NOT NULL,
    client_name character varying(255) NOT NULL,
    login_name character varying(255) DEFAULT NULL::character varying,
    server character varying(255) DEFAULT NULL::character varying,
    app_password character varying(1024) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_login_flow_v2 OWNER TO oc_admin;

--
-- Name: oc_login_flow_v2_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_login_flow_v2_id_seq OWNER TO oc_admin;

--
-- Name: oc_login_flow_v2_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_login_flow_v2_id_seq OWNED BY public.oc_login_flow_v2.id;


--
-- Name: oc_migrations; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_migrations (
    app character varying(255) NOT NULL,
    version character varying(255) NOT NULL
);


ALTER TABLE public.oc_migrations OWNER TO oc_admin;

--
-- Name: oc_mimetypes; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_mimetypes (
    id bigint NOT NULL,
    mimetype character varying(255) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.oc_mimetypes OWNER TO oc_admin;

--
-- Name: oc_mimetypes_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_mimetypes_id_seq OWNER TO oc_admin;

--
-- Name: oc_mimetypes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_mimetypes_id_seq OWNED BY public.oc_mimetypes.id;


--
-- Name: oc_mounts; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_mounts (
    id bigint NOT NULL,
    storage_id bigint NOT NULL,
    root_id bigint NOT NULL,
    user_id character varying(64) NOT NULL,
    mount_point character varying(4000) NOT NULL,
    mount_id bigint,
    mount_provider_class character varying(128) DEFAULT NULL::character varying,
    mount_point_hash character varying(32) NOT NULL
);


ALTER TABLE public.oc_mounts OWNER TO oc_admin;

--
-- Name: oc_mounts_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_mounts_id_seq OWNER TO oc_admin;

--
-- Name: oc_mounts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_mounts_id_seq OWNED BY public.oc_mounts.id;


--
-- Name: oc_notifications; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_notifications (
    notification_id integer NOT NULL,
    app character varying(32) NOT NULL,
    "user" character varying(64) NOT NULL,
    "timestamp" integer DEFAULT 0 NOT NULL,
    object_type character varying(64) NOT NULL,
    object_id character varying(64) NOT NULL,
    subject character varying(64) NOT NULL,
    subject_parameters text,
    message character varying(64) DEFAULT NULL::character varying,
    message_parameters text,
    link character varying(4000) DEFAULT NULL::character varying,
    icon character varying(4000) DEFAULT NULL::character varying,
    actions text
);


ALTER TABLE public.oc_notifications OWNER TO oc_admin;

--
-- Name: oc_notifications_notification_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_notifications_notification_id_seq OWNER TO oc_admin;

--
-- Name: oc_notifications_notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_notifications_notification_id_seq OWNED BY public.oc_notifications.notification_id;


--
-- Name: oc_notifications_pushhash; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_notifications_pushhash (
    id integer NOT NULL,
    uid character varying(64) NOT NULL,
    token integer DEFAULT 0 NOT NULL,
    deviceidentifier character varying(128) NOT NULL,
    devicepublickey character varying(512) NOT NULL,
    devicepublickeyhash character varying(128) NOT NULL,
    pushtokenhash character varying(128) NOT NULL,
    proxyserver character varying(256) NOT NULL,
    apptype character varying(32) DEFAULT 'unknown'::character varying NOT NULL
);


ALTER TABLE public.oc_notifications_pushhash OWNER TO oc_admin;

--
-- Name: oc_notifications_pushhash_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_notifications_pushhash_id_seq OWNER TO oc_admin;

--
-- Name: oc_notifications_pushhash_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_notifications_pushhash_id_seq OWNED BY public.oc_notifications_pushhash.id;


--
-- Name: oc_notifications_settings; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_notifications_settings (
    id bigint NOT NULL,
    user_id character varying(64) NOT NULL,
    batch_time integer DEFAULT 0 NOT NULL,
    last_send_id bigint DEFAULT 0 NOT NULL,
    next_send_time integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_notifications_settings OWNER TO oc_admin;

--
-- Name: oc_notifications_settings_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_notifications_settings_id_seq OWNER TO oc_admin;

--
-- Name: oc_notifications_settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_notifications_settings_id_seq OWNED BY public.oc_notifications_settings.id;


--
-- Name: oc_oauth2_access_tokens; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_oauth2_access_tokens (
    id integer NOT NULL,
    token_id integer NOT NULL,
    client_id integer NOT NULL,
    hashed_code character varying(128) NOT NULL,
    encrypted_token character varying(786) NOT NULL,
    code_created_at bigint DEFAULT 0 NOT NULL,
    token_count bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_oauth2_access_tokens OWNER TO oc_admin;

--
-- Name: oc_oauth2_access_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_oauth2_access_tokens_id_seq OWNER TO oc_admin;

--
-- Name: oc_oauth2_access_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_oauth2_access_tokens_id_seq OWNED BY public.oc_oauth2_access_tokens.id;


--
-- Name: oc_oauth2_clients; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_oauth2_clients (
    id integer NOT NULL,
    name character varying(64) NOT NULL,
    redirect_uri character varying(2000) NOT NULL,
    client_identifier character varying(64) NOT NULL,
    secret character varying(512) NOT NULL
);


ALTER TABLE public.oc_oauth2_clients OWNER TO oc_admin;

--
-- Name: oc_oauth2_clients_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_oauth2_clients_id_seq OWNER TO oc_admin;

--
-- Name: oc_oauth2_clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_oauth2_clients_id_seq OWNED BY public.oc_oauth2_clients.id;


--
-- Name: oc_open_local_editor; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_open_local_editor (
    id bigint NOT NULL,
    user_id character varying(64) NOT NULL,
    path_hash character varying(64) NOT NULL,
    expiration_time bigint NOT NULL,
    token character varying(128) NOT NULL
);


ALTER TABLE public.oc_open_local_editor OWNER TO oc_admin;

--
-- Name: oc_open_local_editor_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_open_local_editor_id_seq OWNER TO oc_admin;

--
-- Name: oc_open_local_editor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_open_local_editor_id_seq OWNED BY public.oc_open_local_editor.id;


--
-- Name: oc_photos_albums; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_photos_albums (
    album_id bigint NOT NULL,
    name character varying(255) NOT NULL,
    "user" character varying(255) NOT NULL,
    created bigint NOT NULL,
    location character varying(255) NOT NULL,
    last_added_photo bigint NOT NULL,
    filters text
);


ALTER TABLE public.oc_photos_albums OWNER TO oc_admin;

--
-- Name: oc_photos_albums_album_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_photos_albums_album_id_seq OWNER TO oc_admin;

--
-- Name: oc_photos_albums_album_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_photos_albums_album_id_seq OWNED BY public.oc_photos_albums.album_id;


--
-- Name: oc_photos_albums_collabs; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_photos_albums_collabs (
    id bigint NOT NULL,
    album_id bigint NOT NULL,
    collaborator_id character varying(64) NOT NULL,
    collaborator_type integer NOT NULL
);


ALTER TABLE public.oc_photos_albums_collabs OWNER TO oc_admin;

--
-- Name: oc_photos_albums_collabs_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_photos_albums_collabs_id_seq OWNER TO oc_admin;

--
-- Name: oc_photos_albums_collabs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_photos_albums_collabs_id_seq OWNED BY public.oc_photos_albums_collabs.id;


--
-- Name: oc_photos_albums_files; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_photos_albums_files (
    album_file_id bigint NOT NULL,
    album_id bigint NOT NULL,
    file_id bigint NOT NULL,
    added bigint NOT NULL,
    owner character varying(64) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_photos_albums_files OWNER TO oc_admin;

--
-- Name: oc_photos_albums_files_album_file_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_photos_albums_files_album_file_id_seq OWNER TO oc_admin;

--
-- Name: oc_photos_albums_files_album_file_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_photos_albums_files_album_file_id_seq OWNED BY public.oc_photos_albums_files.album_file_id;


--
-- Name: oc_preferences; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_preferences (
    userid character varying(64) DEFAULT ''::character varying NOT NULL,
    appid character varying(32) DEFAULT ''::character varying NOT NULL,
    configkey character varying(64) DEFAULT ''::character varying NOT NULL,
    configvalue text,
    lazy smallint DEFAULT 0 NOT NULL,
    type smallint DEFAULT 0 NOT NULL,
    flags integer DEFAULT 0 NOT NULL,
    indexed character varying(64) DEFAULT ''::character varying
);


ALTER TABLE public.oc_preferences OWNER TO oc_admin;

--
-- Name: oc_preferences_ex; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_preferences_ex (
    id bigint NOT NULL,
    userid character varying(64) NOT NULL,
    appid character varying(32) NOT NULL,
    configkey character varying(64) NOT NULL,
    configvalue text,
    sensitive smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_preferences_ex OWNER TO oc_admin;

--
-- Name: oc_preferences_ex_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_preferences_ex_id_seq OWNER TO oc_admin;

--
-- Name: oc_preferences_ex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_preferences_ex_id_seq OWNED BY public.oc_preferences_ex.id;


--
-- Name: oc_privacy_admins; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_privacy_admins (
    id integer NOT NULL,
    displayname character varying(64) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.oc_privacy_admins OWNER TO oc_admin;

--
-- Name: oc_privacy_admins_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_privacy_admins_id_seq OWNER TO oc_admin;

--
-- Name: oc_privacy_admins_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_privacy_admins_id_seq OWNED BY public.oc_privacy_admins.id;


--
-- Name: oc_profile_config; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_profile_config (
    id bigint NOT NULL,
    user_id character varying(64) NOT NULL,
    config text NOT NULL
);


ALTER TABLE public.oc_profile_config OWNER TO oc_admin;

--
-- Name: oc_profile_config_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_profile_config_id_seq OWNER TO oc_admin;

--
-- Name: oc_profile_config_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_profile_config_id_seq OWNED BY public.oc_profile_config.id;


--
-- Name: oc_properties; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_properties (
    id bigint NOT NULL,
    userid character varying(64) DEFAULT ''::character varying NOT NULL,
    propertypath character varying(255) DEFAULT ''::character varying NOT NULL,
    propertyname character varying(255) DEFAULT ''::character varying NOT NULL,
    propertyvalue text NOT NULL,
    valuetype smallint DEFAULT 1
);


ALTER TABLE public.oc_properties OWNER TO oc_admin;

--
-- Name: oc_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_properties_id_seq OWNER TO oc_admin;

--
-- Name: oc_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_properties_id_seq OWNED BY public.oc_properties.id;


--
-- Name: oc_ratelimit_entries; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_ratelimit_entries (
    id bigint NOT NULL,
    hash character varying(128) NOT NULL,
    delete_after timestamp(0) without time zone NOT NULL
);


ALTER TABLE public.oc_ratelimit_entries OWNER TO oc_admin;

--
-- Name: oc_ratelimit_entries_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_ratelimit_entries_id_seq OWNER TO oc_admin;

--
-- Name: oc_ratelimit_entries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_ratelimit_entries_id_seq OWNED BY public.oc_ratelimit_entries.id;


--
-- Name: oc_reactions; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_reactions (
    id bigint NOT NULL,
    parent_id bigint NOT NULL,
    message_id bigint NOT NULL,
    actor_type character varying(64) DEFAULT ''::character varying NOT NULL,
    actor_id character varying(64) DEFAULT ''::character varying NOT NULL,
    reaction character varying(32) NOT NULL
);


ALTER TABLE public.oc_reactions OWNER TO oc_admin;

--
-- Name: oc_reactions_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_reactions_id_seq OWNER TO oc_admin;

--
-- Name: oc_reactions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_reactions_id_seq OWNED BY public.oc_reactions.id;


--
-- Name: oc_recent_contact; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_recent_contact (
    id integer NOT NULL,
    actor_uid character varying(64) NOT NULL,
    uid character varying(64) DEFAULT NULL::character varying,
    email character varying(255) DEFAULT NULL::character varying,
    federated_cloud_id character varying(255) DEFAULT NULL::character varying,
    card bytea NOT NULL,
    last_contact integer NOT NULL
);


ALTER TABLE public.oc_recent_contact OWNER TO oc_admin;

--
-- Name: oc_recent_contact_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_recent_contact_id_seq OWNER TO oc_admin;

--
-- Name: oc_recent_contact_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_recent_contact_id_seq OWNED BY public.oc_recent_contact.id;


--
-- Name: oc_schedulingobjects; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_schedulingobjects (
    id bigint NOT NULL,
    principaluri character varying(255) DEFAULT NULL::character varying,
    calendardata bytea,
    uri character varying(255) DEFAULT NULL::character varying,
    lastmodified integer,
    etag character varying(32) DEFAULT NULL::character varying,
    size bigint NOT NULL
);


ALTER TABLE public.oc_schedulingobjects OWNER TO oc_admin;

--
-- Name: oc_schedulingobjects_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_schedulingobjects_id_seq OWNER TO oc_admin;

--
-- Name: oc_schedulingobjects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_schedulingobjects_id_seq OWNED BY public.oc_schedulingobjects.id;


--
-- Name: oc_sec_signatory; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_sec_signatory (
    id bigint NOT NULL,
    key_id_sum character varying(127) NOT NULL,
    key_id character varying(512) NOT NULL,
    host character varying(512) NOT NULL,
    provider_id character varying(31) NOT NULL,
    account character varying(127) DEFAULT ''::character varying,
    public_key text DEFAULT ''::text NOT NULL,
    metadata text DEFAULT '[]'::text NOT NULL,
    type smallint DEFAULT 9 NOT NULL,
    status smallint DEFAULT 0 NOT NULL,
    creation integer DEFAULT 0,
    last_updated integer DEFAULT 0
);


ALTER TABLE public.oc_sec_signatory OWNER TO oc_admin;

--
-- Name: oc_sec_signatory_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_sec_signatory_id_seq OWNER TO oc_admin;

--
-- Name: oc_sec_signatory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_sec_signatory_id_seq OWNED BY public.oc_sec_signatory.id;


--
-- Name: oc_share; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_share (
    id bigint NOT NULL,
    share_type smallint DEFAULT 0 NOT NULL,
    share_with character varying(255) DEFAULT NULL::character varying,
    password character varying(255) DEFAULT NULL::character varying,
    uid_owner character varying(64) DEFAULT ''::character varying NOT NULL,
    uid_initiator character varying(64) DEFAULT NULL::character varying,
    parent bigint,
    item_type character varying(64) DEFAULT ''::character varying NOT NULL,
    item_source character varying(255) DEFAULT NULL::character varying,
    item_target character varying(255) DEFAULT NULL::character varying,
    file_source bigint,
    file_target character varying(512) DEFAULT NULL::character varying,
    permissions smallint DEFAULT 0 NOT NULL,
    stime bigint DEFAULT 0 NOT NULL,
    accepted smallint DEFAULT 0 NOT NULL,
    expiration timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
    token character varying(32) DEFAULT NULL::character varying,
    mail_send smallint DEFAULT 0 NOT NULL,
    share_name character varying(64) DEFAULT NULL::character varying,
    password_by_talk boolean DEFAULT false,
    note text,
    hide_download smallint DEFAULT 0,
    label character varying(255) DEFAULT NULL::character varying,
    attributes json,
    password_expiration_time timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
    reminder_sent boolean DEFAULT false
);


ALTER TABLE public.oc_share OWNER TO oc_admin;

--
-- Name: oc_share_external; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_share_external (
    id bigint NOT NULL,
    parent bigint DEFAULT '-1'::integer,
    share_type integer,
    remote character varying(512) NOT NULL,
    remote_id character varying(255) DEFAULT ''::character varying,
    share_token character varying(64) NOT NULL,
    password character varying(64) DEFAULT NULL::character varying,
    name character varying(4000) NOT NULL,
    owner character varying(255) NOT NULL,
    "user" character varying(64) NOT NULL,
    mountpoint character varying(4000) NOT NULL,
    mountpoint_hash character varying(32) NOT NULL,
    accepted integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_share_external OWNER TO oc_admin;

--
-- Name: oc_share_external_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_share_external_id_seq OWNER TO oc_admin;

--
-- Name: oc_share_external_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_share_external_id_seq OWNED BY public.oc_share_external.id;


--
-- Name: oc_share_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_share_id_seq OWNER TO oc_admin;

--
-- Name: oc_share_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_share_id_seq OWNED BY public.oc_share.id;


--
-- Name: oc_shares_limits; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_shares_limits (
    id character varying(32) NOT NULL,
    "limit" bigint NOT NULL,
    downloads bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_shares_limits OWNER TO oc_admin;

--
-- Name: oc_storages; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_storages (
    numeric_id bigint NOT NULL,
    id character varying(64) DEFAULT NULL::character varying,
    available integer DEFAULT 1 NOT NULL,
    last_checked integer
);


ALTER TABLE public.oc_storages OWNER TO oc_admin;

--
-- Name: oc_storages_credentials; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_storages_credentials (
    id bigint NOT NULL,
    "user" character varying(64) DEFAULT NULL::character varying,
    identifier character varying(64) NOT NULL,
    credentials text
);


ALTER TABLE public.oc_storages_credentials OWNER TO oc_admin;

--
-- Name: oc_storages_credentials_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_storages_credentials_id_seq OWNER TO oc_admin;

--
-- Name: oc_storages_credentials_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_storages_credentials_id_seq OWNED BY public.oc_storages_credentials.id;


--
-- Name: oc_storages_numeric_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_storages_numeric_id_seq OWNER TO oc_admin;

--
-- Name: oc_storages_numeric_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_storages_numeric_id_seq OWNED BY public.oc_storages.numeric_id;


--
-- Name: oc_systemtag; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_systemtag (
    id bigint NOT NULL,
    name character varying(64) DEFAULT ''::character varying NOT NULL,
    visibility smallint DEFAULT 1 NOT NULL,
    editable smallint DEFAULT 1 NOT NULL,
    etag character varying(32) DEFAULT NULL::character varying,
    color character varying(6) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_systemtag OWNER TO oc_admin;

--
-- Name: oc_systemtag_group; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_systemtag_group (
    systemtagid bigint DEFAULT 0 NOT NULL,
    gid character varying(255) NOT NULL
);


ALTER TABLE public.oc_systemtag_group OWNER TO oc_admin;

--
-- Name: oc_systemtag_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_systemtag_id_seq OWNER TO oc_admin;

--
-- Name: oc_systemtag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_systemtag_id_seq OWNED BY public.oc_systemtag.id;


--
-- Name: oc_systemtag_object_mapping; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_systemtag_object_mapping (
    objectid character varying(64) DEFAULT ''::character varying NOT NULL,
    objecttype character varying(64) DEFAULT ''::character varying NOT NULL,
    systemtagid bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_systemtag_object_mapping OWNER TO oc_admin;

--
-- Name: oc_taskprocessing_tasks; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_taskprocessing_tasks (
    id bigint NOT NULL,
    type character varying(255) NOT NULL,
    input text NOT NULL,
    output text,
    status integer DEFAULT 0,
    user_id character varying(64) DEFAULT NULL::character varying,
    app_id character varying(32) DEFAULT ''::character varying NOT NULL,
    custom_id character varying(255) DEFAULT ''::character varying,
    last_updated integer DEFAULT 0,
    completion_expected_at timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
    progress double precision DEFAULT '0'::double precision,
    error_message character varying(4000) DEFAULT NULL::character varying,
    scheduled_at integer,
    started_at integer,
    ended_at integer,
    webhook_uri character varying(4000) DEFAULT NULL::character varying,
    webhook_method character varying(64) DEFAULT NULL::character varying,
    allow_cleanup smallint DEFAULT 1 NOT NULL
);


ALTER TABLE public.oc_taskprocessing_tasks OWNER TO oc_admin;

--
-- Name: oc_taskprocessing_tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_taskprocessing_tasks_id_seq OWNER TO oc_admin;

--
-- Name: oc_taskprocessing_tasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_taskprocessing_tasks_id_seq OWNED BY public.oc_taskprocessing_tasks.id;


--
-- Name: oc_text2image_tasks; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_text2image_tasks (
    id bigint NOT NULL,
    input text NOT NULL,
    status integer DEFAULT 0,
    number_of_images integer DEFAULT 1 NOT NULL,
    user_id character varying(64) DEFAULT NULL::character varying,
    app_id character varying(32) DEFAULT ''::character varying NOT NULL,
    identifier character varying(255) DEFAULT ''::character varying,
    last_updated timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
    completion_expected_at timestamp(0) without time zone DEFAULT NULL::timestamp without time zone
);


ALTER TABLE public.oc_text2image_tasks OWNER TO oc_admin;

--
-- Name: oc_text2image_tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_text2image_tasks_id_seq OWNER TO oc_admin;

--
-- Name: oc_text2image_tasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_text2image_tasks_id_seq OWNED BY public.oc_text2image_tasks.id;


--
-- Name: oc_text_documents; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_text_documents (
    id bigint NOT NULL,
    current_version bigint DEFAULT 0,
    last_saved_version bigint DEFAULT 0,
    last_saved_version_time bigint NOT NULL,
    last_saved_version_etag character varying(64) DEFAULT ''::character varying,
    base_version_etag character varying(64) DEFAULT ''::character varying,
    checksum character varying(8) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_text_documents OWNER TO oc_admin;

--
-- Name: oc_text_sessions; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_text_sessions (
    id bigint NOT NULL,
    user_id character varying(64) DEFAULT NULL::character varying,
    guest_name character varying(64) DEFAULT NULL::character varying,
    color character varying(7) DEFAULT NULL::character varying,
    token character varying(64) NOT NULL,
    document_id bigint NOT NULL,
    last_contact bigint NOT NULL,
    last_awareness_message text DEFAULT ''::text
);


ALTER TABLE public.oc_text_sessions OWNER TO oc_admin;

--
-- Name: oc_text_sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_text_sessions_id_seq OWNER TO oc_admin;

--
-- Name: oc_text_sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_text_sessions_id_seq OWNED BY public.oc_text_sessions.id;


--
-- Name: oc_text_steps; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_text_steps (
    id bigint NOT NULL,
    document_id bigint NOT NULL,
    session_id bigint NOT NULL,
    data text NOT NULL,
    version bigint DEFAULT 0,
    "timestamp" bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_text_steps OWNER TO oc_admin;

--
-- Name: oc_text_steps_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_text_steps_id_seq OWNER TO oc_admin;

--
-- Name: oc_text_steps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_text_steps_id_seq OWNED BY public.oc_text_steps.id;


--
-- Name: oc_textprocessing_tasks; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_textprocessing_tasks (
    id bigint NOT NULL,
    type character varying(255) NOT NULL,
    input text NOT NULL,
    output text,
    status integer DEFAULT 0,
    user_id character varying(64) DEFAULT NULL::character varying,
    app_id character varying(32) DEFAULT ''::character varying NOT NULL,
    identifier character varying(255) DEFAULT ''::character varying NOT NULL,
    last_updated integer DEFAULT 0,
    completion_expected_at timestamp(0) without time zone DEFAULT NULL::timestamp without time zone
);


ALTER TABLE public.oc_textprocessing_tasks OWNER TO oc_admin;

--
-- Name: oc_textprocessing_tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_textprocessing_tasks_id_seq OWNER TO oc_admin;

--
-- Name: oc_textprocessing_tasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_textprocessing_tasks_id_seq OWNED BY public.oc_textprocessing_tasks.id;


--
-- Name: oc_trusted_servers; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_trusted_servers (
    id integer NOT NULL,
    url character varying(512) NOT NULL,
    url_hash character varying(255) DEFAULT ''::character varying NOT NULL,
    token character varying(128) DEFAULT NULL::character varying,
    shared_secret character varying(256) DEFAULT NULL::character varying,
    status integer DEFAULT 2 NOT NULL,
    sync_token character varying(512) DEFAULT NULL::character varying
);


ALTER TABLE public.oc_trusted_servers OWNER TO oc_admin;

--
-- Name: oc_trusted_servers_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_trusted_servers_id_seq OWNER TO oc_admin;

--
-- Name: oc_trusted_servers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_trusted_servers_id_seq OWNED BY public.oc_trusted_servers.id;


--
-- Name: oc_twofactor_backupcodes; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_twofactor_backupcodes (
    id bigint NOT NULL,
    user_id character varying(64) DEFAULT ''::character varying NOT NULL,
    code character varying(128) NOT NULL,
    used smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_twofactor_backupcodes OWNER TO oc_admin;

--
-- Name: oc_twofactor_backupcodes_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_twofactor_backupcodes_id_seq OWNER TO oc_admin;

--
-- Name: oc_twofactor_backupcodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_twofactor_backupcodes_id_seq OWNED BY public.oc_twofactor_backupcodes.id;


--
-- Name: oc_twofactor_providers; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_twofactor_providers (
    provider_id character varying(32) NOT NULL,
    uid character varying(64) NOT NULL,
    enabled smallint NOT NULL
);


ALTER TABLE public.oc_twofactor_providers OWNER TO oc_admin;

--
-- Name: oc_user_status; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_user_status (
    id bigint NOT NULL,
    user_id character varying(255) NOT NULL,
    status character varying(255) NOT NULL,
    status_timestamp integer NOT NULL,
    is_user_defined boolean,
    message_id character varying(255) DEFAULT NULL::character varying,
    custom_icon character varying(255) DEFAULT NULL::character varying,
    custom_message text,
    clear_at integer,
    is_backup boolean DEFAULT false,
    status_message_timestamp integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.oc_user_status OWNER TO oc_admin;

--
-- Name: oc_user_status_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_user_status_id_seq OWNER TO oc_admin;

--
-- Name: oc_user_status_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_user_status_id_seq OWNED BY public.oc_user_status.id;


--
-- Name: oc_user_transfer_owner; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_user_transfer_owner (
    id bigint NOT NULL,
    source_user character varying(64) NOT NULL,
    target_user character varying(64) NOT NULL,
    file_id bigint NOT NULL,
    node_name character varying(255) NOT NULL
);


ALTER TABLE public.oc_user_transfer_owner OWNER TO oc_admin;

--
-- Name: oc_user_transfer_owner_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_user_transfer_owner_id_seq OWNER TO oc_admin;

--
-- Name: oc_user_transfer_owner_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_user_transfer_owner_id_seq OWNED BY public.oc_user_transfer_owner.id;


--
-- Name: oc_users; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_users (
    uid character varying(64) DEFAULT ''::character varying NOT NULL,
    displayname character varying(64) DEFAULT NULL::character varying,
    password character varying(255) DEFAULT ''::character varying NOT NULL,
    uid_lower character varying(64) DEFAULT ''::character varying
);


ALTER TABLE public.oc_users OWNER TO oc_admin;

--
-- Name: oc_vcategory; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_vcategory (
    id bigint NOT NULL,
    uid character varying(64) DEFAULT ''::character varying NOT NULL,
    type character varying(64) DEFAULT ''::character varying NOT NULL,
    category character varying(255) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.oc_vcategory OWNER TO oc_admin;

--
-- Name: oc_vcategory_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_vcategory_id_seq OWNER TO oc_admin;

--
-- Name: oc_vcategory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_vcategory_id_seq OWNED BY public.oc_vcategory.id;


--
-- Name: oc_vcategory_to_object; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_vcategory_to_object (
    objid bigint DEFAULT 0 NOT NULL,
    categoryid bigint DEFAULT 0 NOT NULL,
    type character varying(64) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.oc_vcategory_to_object OWNER TO oc_admin;

--
-- Name: oc_webauthn; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_webauthn (
    id integer NOT NULL,
    uid character varying(64) NOT NULL,
    name character varying(64) NOT NULL,
    public_key_credential_id character varying(512) NOT NULL,
    data text NOT NULL,
    user_verification boolean DEFAULT false
);


ALTER TABLE public.oc_webauthn OWNER TO oc_admin;

--
-- Name: oc_webauthn_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_webauthn_id_seq OWNER TO oc_admin;

--
-- Name: oc_webauthn_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_webauthn_id_seq OWNED BY public.oc_webauthn.id;


--
-- Name: oc_webhook_listeners; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_webhook_listeners (
    id bigint NOT NULL,
    app_id character varying(64) DEFAULT NULL::character varying,
    user_id character varying(64) DEFAULT NULL::character varying,
    http_method character varying(32) NOT NULL,
    uri character varying(4000) NOT NULL,
    event character varying(4000) NOT NULL,
    event_filter text,
    user_id_filter character varying(64) DEFAULT NULL::character varying,
    headers text,
    auth_method character varying(16) DEFAULT ''::character varying NOT NULL,
    auth_data text
);


ALTER TABLE public.oc_webhook_listeners OWNER TO oc_admin;

--
-- Name: oc_webhook_listeners_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_webhook_listeners_id_seq OWNER TO oc_admin;

--
-- Name: oc_webhook_listeners_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_webhook_listeners_id_seq OWNED BY public.oc_webhook_listeners.id;


--
-- Name: oc_whats_new; Type: TABLE; Schema: public; Owner: oc_admin
--

CREATE TABLE public.oc_whats_new (
    id integer NOT NULL,
    version character varying(64) DEFAULT '11'::character varying NOT NULL,
    etag character varying(64) DEFAULT ''::character varying NOT NULL,
    last_check integer DEFAULT 0 NOT NULL,
    data text DEFAULT ''::text NOT NULL
);


ALTER TABLE public.oc_whats_new OWNER TO oc_admin;

--
-- Name: oc_whats_new_id_seq; Type: SEQUENCE; Schema: public; Owner: oc_admin
--

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


ALTER TABLE public.oc_whats_new_id_seq OWNER TO oc_admin;

--
-- Name: oc_whats_new_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: oc_admin
--

ALTER SEQUENCE public.oc_whats_new_id_seq OWNED BY public.oc_whats_new.id;


--
-- Name: oc_accounts_data id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_activity activity_id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

ALTER TABLE ONLY public.oc_activity ALTER COLUMN activity_id SET DEFAULT nextval('public.oc_activity_activity_id_seq'::regclass);


--
-- Name: oc_activity_mq mail_id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

ALTER TABLE ONLY public.oc_activity_mq ALTER COLUMN mail_id SET DEFAULT nextval('public.oc_activity_mq_mail_id_seq'::regclass);


--
-- Name: oc_addressbookchanges id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_addressbooks id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_appconfig_ex id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_authorized_groups id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_authtoken id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_bruteforce_attempts id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendar_invitations id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendar_reminders id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendar_resources id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendar_resources_md id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendar_rooms id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendar_rooms_md id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendarchanges id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendarobjects id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendarobjects_props id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendars id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendars_federated id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_calendarsubscriptions id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_cards id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_cards_properties id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_circles_circle id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_circles_member id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_circles_mount id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_circles_mountpoint id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_circles_remote id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_circles_share_lock id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_circles_token id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_collres_collections id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_comments id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_dav_absence id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_dav_cal_proxy id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_dav_shares id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_direct_edit id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_directlink id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_apps id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_apps_daemons id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_apps_routes id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_deploy_options id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_occ_commands id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_settings_forms id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_task_processing id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_ui_files_actions id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_ui_scripts id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_ui_states id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_ui_styles id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ex_ui_top_menu id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_federated_invites id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_file_locks id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_filecache fileid; Type: DEFAULT; Schema: public; Owner: oc_admin
--

ALTER TABLE ONLY public.oc_filecache ALTER COLUMN fileid SET DEFAULT nextval('public.oc_filecache_fileid_seq'::regclass);


--
-- Name: oc_files_metadata id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_files_metadata_index id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_files_reminders id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_files_trash auto_id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

ALTER TABLE ONLY public.oc_files_trash ALTER COLUMN auto_id SET DEFAULT nextval('public.oc_files_trash_auto_id_seq'::regclass);


--
-- Name: oc_files_versions id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_flow_checks id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_flow_operations id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_flow_operations_scope id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_jobs id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_known_users id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_login_flow_v2 id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_mimetypes id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_mounts id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_notifications notification_id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

ALTER TABLE ONLY public.oc_notifications ALTER COLUMN notification_id SET DEFAULT nextval('public.oc_notifications_notification_id_seq'::regclass);


--
-- Name: oc_notifications_pushhash id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_notifications_settings id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_oauth2_access_tokens id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_oauth2_clients id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_open_local_editor id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_photos_albums album_id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

ALTER TABLE ONLY public.oc_photos_albums ALTER COLUMN album_id SET DEFAULT nextval('public.oc_photos_albums_album_id_seq'::regclass);


--
-- Name: oc_photos_albums_collabs id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_photos_albums_files album_file_id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

ALTER TABLE ONLY public.oc_photos_albums_files ALTER COLUMN album_file_id SET DEFAULT nextval('public.oc_photos_albums_files_album_file_id_seq'::regclass);


--
-- Name: oc_preferences_ex id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_privacy_admins id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_profile_config id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_properties id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_ratelimit_entries id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_reactions id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_recent_contact id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_schedulingobjects id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_sec_signatory id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_share id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_share_external id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_storages numeric_id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

ALTER TABLE ONLY public.oc_storages ALTER COLUMN numeric_id SET DEFAULT nextval('public.oc_storages_numeric_id_seq'::regclass);


--
-- Name: oc_storages_credentials id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_systemtag id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_taskprocessing_tasks id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_text2image_tasks id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_text_sessions id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_text_steps id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_textprocessing_tasks id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_trusted_servers id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_twofactor_backupcodes id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_user_status id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_user_transfer_owner id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_vcategory id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_webauthn id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_webhook_listeners id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Name: oc_whats_new id; Type: DEFAULT; Schema: public; Owner: oc_admin
--

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


--
-- Data for Name: oc_accounts; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_accounts (uid, data) FROM stdin;
deck	{"displayname":{"value":"deck","scope":"v2-federated","verified":"0"},"address":{"value":"","scope":"v2-local","verified":"0"},"website":{"value":"","scope":"v2-local","verified":"0"},"email":{"value":"nextcloud@tzzr.pro","scope":"v2-federated","verified":"0"},"avatar":{"value":"","scope":"v2-federated","verified":"0"},"phone":{"value":"","scope":"v2-local","verified":"0"},"twitter":{"value":"","scope":"v2-local","verified":"0"},"bluesky":{"value":"","scope":"v2-local","verified":"0"},"fediverse":{"value":"","scope":"v2-local","verified":"0"},"organisation":{"value":"","scope":"v2-local","verified":"0"},"role":{"value":"","scope":"v2-local","verified":"0"},"headline":{"value":"","scope":"v2-local","verified":"0"},"biography":{"value":"","scope":"v2-local","verified":"0"},"birthdate":{"value":"","scope":"v2-local","verified":"0"},"profile_enabled":{"value":"1","scope":"v2-local","verified":"0"},"pronouns":{"value":"","scope":"v2-federated","verified":"0"}}
\.


--
-- Data for Name: oc_accounts_data; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_accounts_data (id, uid, name, value) FROM stdin;
182	deck	displayname	deck
183	deck	address	
184	deck	website	
185	deck	email	nextcloud@tzzr.pro
186	deck	phone	
187	deck	twitter	
188	deck	bluesky	
189	deck	fediverse	
190	deck	organisation	
191	deck	role	
192	deck	headline	
193	deck	biography	
194	deck	birthdate	
195	deck	profile_enabled	1
196	deck	pronouns	
\.


--
-- Data for Name: oc_activity; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_activity (activity_id, "timestamp", priority, type, "user", affecteduser, app, subject, subjectparams, message, messageparams, file, link, object_type, object_id) FROM stdin;
223	1768671040	30	file_created	deck	deck	files	created_self	[{"1464":"\\/Photos"}]		[]	/Photos	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1464
224	1768671040	30	file_created	deck	deck	files	created_self	[{"1465":"\\/Photos\\/Toucan.jpg"}]		[]	/Photos/Toucan.jpg	https://cloud.tzzrdeck.me/apps/files/?dir=/Photos	files	1465
225	1768671040	30	file_created	deck	deck	files	created_self	[{"1466":"\\/Photos\\/Steps.jpg"}]		[]	/Photos/Steps.jpg	https://cloud.tzzrdeck.me/apps/files/?dir=/Photos	files	1466
226	1768671040	30	file_created	deck	deck	files	created_self	[{"1467":"\\/Photos\\/Gorilla.jpg"}]		[]	/Photos/Gorilla.jpg	https://cloud.tzzrdeck.me/apps/files/?dir=/Photos	files	1467
227	1768671040	30	file_created	deck	deck	files	created_self	[{"1468":"\\/Photos\\/Nextcloud community.jpg"}]		[]	/Photos/Nextcloud community.jpg	https://cloud.tzzrdeck.me/apps/files/?dir=/Photos	files	1468
228	1768671041	30	file_created	deck	deck	files	created_self	[{"1469":"\\/Photos\\/Readme.md"}]		[]	/Photos/Readme.md	https://cloud.tzzrdeck.me/apps/files/?dir=/Photos	files	1469
229	1768671041	30	file_created	deck	deck	files	created_self	[{"1470":"\\/Photos\\/Vineyard.jpg"}]		[]	/Photos/Vineyard.jpg	https://cloud.tzzrdeck.me/apps/files/?dir=/Photos	files	1470
230	1768671041	30	file_created	deck	deck	files	created_self	[{"1471":"\\/Photos\\/Birdie.jpg"}]		[]	/Photos/Birdie.jpg	https://cloud.tzzrdeck.me/apps/files/?dir=/Photos	files	1471
231	1768671041	30	file_created	deck	deck	files	created_self	[{"1472":"\\/Photos\\/Library.jpg"}]		[]	/Photos/Library.jpg	https://cloud.tzzrdeck.me/apps/files/?dir=/Photos	files	1472
232	1768671041	30	file_created	deck	deck	files	created_self	[{"1473":"\\/Photos\\/Frog.jpg"}]		[]	/Photos/Frog.jpg	https://cloud.tzzrdeck.me/apps/files/?dir=/Photos	files	1473
233	1768671041	30	file_created	deck	deck	files	created_self	[{"1474":"\\/Readme.md"}]		[]	/Readme.md	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1474
234	1768671041	30	file_created	deck	deck	files	created_self	[{"1475":"\\/Nextcloud.png"}]		[]	/Nextcloud.png	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1475
235	1768671041	30	file_created	deck	deck	files	created_self	[{"1476":"\\/Nextcloud intro.mp4"}]		[]	/Nextcloud intro.mp4	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1476
236	1768671041	30	file_created	deck	deck	files	created_self	[{"1477":"\\/Templates"}]		[]	/Templates	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1477
237	1768671041	30	file_created	deck	deck	files	created_self	[{"1478":"\\/Templates\\/Gotong royong.odp"}]		[]	/Templates/Gotong royong.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1478
238	1768671041	30	file_created	deck	deck	files	created_self	[{"1479":"\\/Templates\\/Business model canvas.odg"}]		[]	/Templates/Business model canvas.odg	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1479
239	1768671041	30	file_created	deck	deck	files	created_self	[{"1480":"\\/Templates\\/Ecosystem.odp"}]		[]	/Templates/Ecosystem.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1480
240	1768671041	30	file_created	deck	deck	files	created_self	[{"1481":"\\/Templates\\/Flowchart.whiteboard"}]		[]	/Templates/Flowchart.whiteboard	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1481
241	1768671041	30	file_created	deck	deck	files	created_self	[{"1482":"\\/Templates\\/Report.odt"}]		[]	/Templates/Report.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1482
242	1768671041	30	file_created	deck	deck	files	created_self	[{"1483":"\\/Templates\\/Pitch deck.odp"}]		[]	/Templates/Pitch deck.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1483
243	1768671041	30	file_created	deck	deck	files	created_self	[{"1484":"\\/Templates\\/Calendar.odt"}]		[]	/Templates/Calendar.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1484
244	1768671041	30	file_created	deck	deck	files	created_self	[{"1485":"\\/Templates\\/Certificate.odt"}]		[]	/Templates/Certificate.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1485
245	1768671041	30	file_created	deck	deck	files	created_self	[{"1486":"\\/Templates\\/Letter.odt"}]		[]	/Templates/Letter.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1486
246	1768671041	30	file_created	deck	deck	files	created_self	[{"1487":"\\/Templates\\/Yellow idea.odp"}]		[]	/Templates/Yellow idea.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1487
247	1768671042	30	file_created	deck	deck	files	created_self	[{"1488":"\\/Templates\\/Elegant.odp"}]		[]	/Templates/Elegant.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1488
248	1768671042	30	file_created	deck	deck	files	created_self	[{"1489":"\\/Templates\\/Flowchart.odg"}]		[]	/Templates/Flowchart.odg	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1489
249	1768671042	30	file_created	deck	deck	files	created_self	[{"1490":"\\/Templates\\/Brainstorming.whiteboard"}]		[]	/Templates/Brainstorming.whiteboard	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1490
250	1768671042	30	file_created	deck	deck	files	created_self	[{"1491":"\\/Templates\\/Modern company.odp"}]		[]	/Templates/Modern company.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1491
251	1768671042	30	file_created	deck	deck	files	created_self	[{"1492":"\\/Templates\\/Mindmap.odg"}]		[]	/Templates/Mindmap.odg	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1492
252	1768671042	30	file_created	deck	deck	files	created_self	[{"1493":"\\/Templates\\/Triangle.odp"}]		[]	/Templates/Triangle.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1493
253	1768671042	30	file_created	deck	deck	files	created_self	[{"1494":"\\/Templates\\/Nostalgia.odp"}]		[]	/Templates/Nostalgia.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1494
254	1768671042	30	file_created	deck	deck	files	created_self	[{"1495":"\\/Templates\\/Meeting notes.md"}]		[]	/Templates/Meeting notes.md	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1495
255	1768671042	30	file_created	deck	deck	files	created_self	[{"1496":"\\/Templates\\/Resume.odt"}]		[]	/Templates/Resume.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1496
256	1768671042	30	file_created	deck	deck	files	created_self	[{"1497":"\\/Templates\\/Photo book.odt"}]		[]	/Templates/Photo book.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1497
257	1768671042	30	file_created	deck	deck	files	created_self	[{"1498":"\\/Templates\\/Timeline.whiteboard"}]		[]	/Templates/Timeline.whiteboard	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1498
258	1768671042	30	file_created	deck	deck	files	created_self	[{"1499":"\\/Templates\\/Syllabus.odt"}]		[]	/Templates/Syllabus.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1499
259	1768671042	30	file_created	deck	deck	files	created_self	[{"1500":"\\/Templates\\/Diagram & table.ods"}]		[]	/Templates/Diagram & table.ods	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1500
219	1768670966	30	circles_as_member		deck	circles	member_added	{"ver":2,"circle":{"singleId":"6HkvLNzWn5oBKDjjFz2wyegEGOblkGh","name":"group:admin","config":1540,"url":""},"initiator":{"userId":"circles","displayName":"Circles","type":10000,"level":9,"status":"Member"},"member":{"userId":"deck","displayName":"deck","type":1,"level":1,"status":"Member"}}		[]				0
220	1768670966	30	group_settings		deck	settings	group_added	{"user":"deck","group":"admin"}		[]				0
260	1768671042	30	file_created	deck	deck	files	created_self	[{"1501":"\\/Templates\\/Mother's day.odt"}]		[]	/Templates/Mother's day.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1501
261	1768671042	30	file_created	deck	deck	files	created_self	[{"1502":"\\/Templates\\/Readme.md"}]		[]	/Templates/Readme.md	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1502
262	1768671042	30	file_created	deck	deck	files	created_self	[{"1503":"\\/Templates\\/Simple.odp"}]		[]	/Templates/Simple.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1503
263	1768671042	30	file_created	deck	deck	files	created_self	[{"1504":"\\/Templates\\/Meeting agenda.whiteboard"}]		[]	/Templates/Meeting agenda.whiteboard	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1504
264	1768671042	30	file_created	deck	deck	files	created_self	[{"1505":"\\/Templates\\/Timesheet.ods"}]		[]	/Templates/Timesheet.ods	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1505
265	1768671042	30	file_created	deck	deck	files	created_self	[{"1506":"\\/Templates\\/Invoice.ods"}]		[]	/Templates/Invoice.ods	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1506
266	1768671042	30	file_created	deck	deck	files	created_self	[{"1507":"\\/Templates\\/Business model canvas.ods"}]		[]	/Templates/Business model canvas.ods	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1507
267	1768671042	30	file_created	deck	deck	files	created_self	[{"1508":"\\/Templates\\/Mind map.whiteboard"}]		[]	/Templates/Mind map.whiteboard	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1508
268	1768671042	30	file_created	deck	deck	files	created_self	[{"1509":"\\/Templates\\/Onboarding.odp"}]		[]	/Templates/Onboarding.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1509
269	1768671043	30	file_created	deck	deck	files	created_self	[{"1510":"\\/Templates\\/Party invitation.odt"}]		[]	/Templates/Party invitation.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1510
270	1768671043	30	file_created	deck	deck	files	created_self	[{"1511":"\\/Templates\\/Impact effort.whiteboard"}]		[]	/Templates/Impact effort.whiteboard	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1511
271	1768671043	30	file_created	deck	deck	files	created_self	[{"1512":"\\/Templates\\/Business model canvas.whiteboard"}]		[]	/Templates/Business model canvas.whiteboard	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1512
272	1768671043	30	file_created	deck	deck	files	created_self	[{"1513":"\\/Templates\\/Checklist.ods"}]		[]	/Templates/Checklist.ods	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1513
273	1768671043	30	file_created	deck	deck	files	created_self	[{"1514":"\\/Templates\\/Kanban board.whiteboard"}]		[]	/Templates/Kanban board.whiteboard	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1514
274	1768671043	30	file_created	deck	deck	files	created_self	[{"1515":"\\/Templates\\/Sticky notes.whiteboard"}]		[]	/Templates/Sticky notes.whiteboard	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1515
275	1768671043	30	file_created	deck	deck	files	created_self	[{"1516":"\\/Templates\\/Product plan.md"}]		[]	/Templates/Product plan.md	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1516
276	1768671043	30	file_created	deck	deck	files	created_self	[{"1517":"\\/Templates\\/Org chart.odg"}]		[]	/Templates/Org chart.odg	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1517
277	1768671043	30	file_created	deck	deck	files	created_self	[{"1518":"\\/Templates\\/Security.odp"}]		[]	/Templates/Security.odp	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1518
278	1768671043	30	file_created	deck	deck	files	created_self	[{"1519":"\\/Templates\\/Venn diagram.whiteboard"}]		[]	/Templates/Venn diagram.whiteboard	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1519
279	1768671043	30	file_created	deck	deck	files	created_self	[{"1520":"\\/Templates\\/Expense report.ods"}]		[]	/Templates/Expense report.ods	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1520
280	1768671043	30	file_created	deck	deck	files	created_self	[{"1521":"\\/Templates\\/Invoice.odt"}]		[]	/Templates/Invoice.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1521
281	1768671043	30	file_created	deck	deck	files	created_self	[{"1522":"\\/Templates\\/Menu.odt"}]		[]	/Templates/Menu.odt	https://cloud.tzzrdeck.me/apps/files/?dir=/Templates	files	1522
282	1768671043	30	file_created	deck	deck	files	created_self	[{"1523":"\\/Documents"}]		[]	/Documents	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1523
283	1768671043	30	file_created	deck	deck	files	created_self	[{"1524":"\\/Documents\\/Nextcloud flyer.pdf"}]		[]	/Documents/Nextcloud flyer.pdf	https://cloud.tzzrdeck.me/apps/files/?dir=/Documents	files	1524
284	1768671043	30	file_created	deck	deck	files	created_self	[{"1525":"\\/Documents\\/Welcome to Nextcloud Hub.docx"}]		[]	/Documents/Welcome to Nextcloud Hub.docx	https://cloud.tzzrdeck.me/apps/files/?dir=/Documents	files	1525
285	1768671043	30	file_created	deck	deck	files	created_self	[{"1526":"\\/Documents\\/Example.md"}]		[]	/Documents/Example.md	https://cloud.tzzrdeck.me/apps/files/?dir=/Documents	files	1526
286	1768671043	30	file_created	deck	deck	files	created_self	[{"1527":"\\/Documents\\/Readme.md"}]		[]	/Documents/Readme.md	https://cloud.tzzrdeck.me/apps/files/?dir=/Documents	files	1527
287	1768671043	30	file_created	deck	deck	files	created_self	[{"1528":"\\/Reasons to use Nextcloud.pdf"}]		[]	/Reasons to use Nextcloud.pdf	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1528
288	1768671043	30	file_created	deck	deck	files	created_self	[{"1529":"\\/Templates credits.md"}]		[]	/Templates credits.md	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1529
289	1768671043	30	file_created	deck	deck	files	created_self	[{"1530":"\\/Nextcloud Manual.pdf"}]		[]	/Nextcloud Manual.pdf	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1530
290	1768671043	30	file_changed	deck	deck	files	renamed_self	[{"1477":"\\/\\/Plantillas"},{"1477":"\\/\\/Templates"}]		[]	//Plantillas	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1477
291	1768671043	30	calendar	deck	deck	dav	calendar_add_self	{"actor":"deck","calendar":{"id":9,"uri":"personal","name":"Personal"}}		[]			calendar	9
292	1768671044	30	calendar_event	deck	deck	dav	object_add_event_self	{"actor":"deck","calendar":{"id":9,"uri":"personal","name":"Personal"},"object":{"id":"YYrSQg18asUjY2EExYRi5fcF7uTjPfZA","name":"Evento de ejemplo - \\u00a1\\u00e1bralo!","classified":false}}		[]			calendar	9
293	1768671044	30	contacts	deck	deck	dav	addressbook_add_self	{"actor":"deck","addressbook":{"id":6,"uri":"contacts","name":"Contacts"}}		[]			addressbook	6
294	1768671044	30	contacts	deck	deck	dav	card_add_self	{"actor":"deck","addressbook":{"id":6,"uri":"contacts","name":"Contacts"},"card":{"id":"359b2771-76d3-496d-bc73-260294906aec","name":"Leon Green"}}		[]			addressbook	6
74	1768111814	30	calendar	system	system	dav	calendar_add_self	{"actor":"system","calendar":{"id":3,"uri":"contact_birthdays","name":"Contact birthdays"}}		[]			calendar	3
295	1768671044	30	calendar	deck	deck	dav	calendar_add_self	{"actor":"deck","calendar":{"id":10,"uri":"contact_birthdays","name":"Cumplea\\u00f1os del contacto"}}		[]			calendar	10
296	1768671044	30	calendar_event	deck	deck	dav	object_add_event_self	{"actor":"deck","calendar":{"id":10,"uri":"contact_birthdays","name":"Cumplea\\u00f1os del contacto"},"object":{"id":"359b2771-76d3-496d-bc73-260294906aec","name":"\\ud83c\\udf82 Leon Green (2000)","classified":false}}		[]			calendar	10
297	1768671219	30	file_deleted	deck	deck	files	deleted_self	[{"1476":"\\/Nextcloud intro.mp4"}]		[]	/Nextcloud intro.mp4	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1476
298	1768671219	30	file_deleted	deck	deck	files	deleted_self	[{"1474":"\\/Readme.md"}]		[]	/Readme.md	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1474
299	1768671219	30	file_deleted	deck	deck	files	deleted_self	[{"1528":"\\/Reasons to use Nextcloud.pdf"}]		[]	/Reasons to use Nextcloud.pdf	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1528
300	1768671219	30	file_deleted	deck	deck	files	deleted_self	[{"1530":"\\/Nextcloud Manual.pdf"}]		[]	/Nextcloud Manual.pdf	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1530
301	1768671219	30	file_deleted	deck	deck	files	deleted_self	[{"1475":"\\/Nextcloud.png"}]		[]	/Nextcloud.png	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1475
302	1768671219	30	file_deleted	deck	deck	files	deleted_self	[{"1529":"\\/Templates credits.md"}]		[]	/Templates credits.md	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1529
303	1768671219	30	file_deleted	deck	deck	files	deleted_self	[{"1464":"\\/Photos"}]		[]	/Photos	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1464
304	1768671219	30	file_deleted	deck	deck	files	deleted_self	[{"1523":"\\/Documents"}]		[]	/Documents	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1523
305	1768671219	30	file_deleted	deck	deck	files	deleted_self	[{"1477":"\\/Plantillas"}]		[]	/Plantillas	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1477
306	1768681509	30	file_changed	deck	deck	files	moved_self	[{"1585":"\\/documentos adjuntos\\/"},{"1591":"\\/documentos adjuntos\\/architect\\/sesiones"}]		[]	/documentos adjuntos/sesiones	https://cloud.tzzrdeck.me/apps/files/?dir=/documentos%20adjuntos	files	1591
307	1768681510	30	file_changed	deck	deck	files	moved_self	[{"1585":"\\/documentos adjuntos\\/"},{"1593":"\\/documentos adjuntos\\/architect\\/TZZR_DATABASE_STRUCTURE_2026-01-17.md"}]		[]	/documentos adjuntos/TZZR_DATABASE_STRUCTURE_2026-01-17.md	https://cloud.tzzrdeck.me/apps/files/?dir=/documentos%20adjuntos	files	1593
308	1768681510	30	file_changed	deck	deck	files	moved_self	[{"1585":"\\/documentos adjuntos\\/"},{"1594":"\\/documentos adjuntos\\/architect\\/TZZR_SCHEMA_WONDERSHARE.md"}]		[]	/documentos adjuntos/TZZR_SCHEMA_WONDERSHARE.md	https://cloud.tzzrdeck.me/apps/files/?dir=/documentos%20adjuntos	files	1594
309	1768681513	30	file_deleted	deck	deck	files	deleted_self	[{"1590":"\\/documentos adjuntos\\/architect"}]		[]	/documentos adjuntos/architect	https://cloud.tzzrdeck.me/apps/files/?dir=/documentos%20adjuntos	files	1590
310	1768681525	30	file_created	deck	deck	files	created_self	[{"1595":"\\/documentos adjuntos\\/architect"}]		[]	/documentos adjuntos/architect	https://cloud.tzzrdeck.me/apps/files/?dir=/documentos%20adjuntos	files	1595
311	1768681525	30	file_changed	deck	deck	files	moved_self	[{"1595":"\\/documentos adjuntos\\/architect\\/"},{"1591":"\\/documentos adjuntos\\/sesiones"}]		[]	/documentos adjuntos/architect/sesiones	https://cloud.tzzrdeck.me/apps/files/?dir=/documentos%20adjuntos/architect	files	1591
312	1768681525	30	file_changed	deck	deck	files	moved_self	[{"1595":"\\/documentos adjuntos\\/architect\\/"},{"1593":"\\/documentos adjuntos\\/TZZR_DATABASE_STRUCTURE_2026-01-17.md"}]		[]	/documentos adjuntos/architect/TZZR_DATABASE_STRUCTURE_2026-01-17.md	https://cloud.tzzrdeck.me/apps/files/?dir=/documentos%20adjuntos/architect	files	1593
313	1768681525	30	file_changed	deck	deck	files	moved_self	[{"1595":"\\/documentos adjuntos\\/architect\\/"},{"1594":"\\/documentos adjuntos\\/TZZR_SCHEMA_WONDERSHARE.md"}]		[]	/documentos adjuntos/architect/TZZR_SCHEMA_WONDERSHARE.md	https://cloud.tzzrdeck.me/apps/files/?dir=/documentos%20adjuntos/architect	files	1594
314	1768684226	30	file_deleted	deck	deck	files	deleted_self	[{"1592":"\\/documentos adjuntos\\/architect\\/sesiones\\/legacy_database_deck.json"}]		[]	/documentos adjuntos/architect/sesiones/legacy_database_deck.json	https://cloud.tzzrdeck.me/apps/files/?dir=/documentos%20adjuntos/architect/sesiones	files	1592
315	1768684234	30	file_deleted	deck	deck	files	deleted_self	[{"1586":"\\/documentos adjuntos\\/esquemas_postgresql_tzzr.pdf"}]		[]	/documentos adjuntos/esquemas_postgresql_tzzr.pdf	https://cloud.tzzrdeck.me/apps/files/?dir=/documentos%20adjuntos	files	1586
316	1768684244	30	file_deleted	deck	deck	files	deleted_self	[{"1585":"\\/documentos adjuntos"}]		[]	/documentos adjuntos	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1585
317	1768689536	30	file_created	deck	deck	files	created_self	[{"1596":"\\/bandeja de salida\\/opinion gemini.txt"}]		[]	/bandeja de salida/opinion gemini.txt	https://cloud.tzzrdeck.me/apps/files/?dir=/bandeja%20de%20salida	files	1596
318	1768699858	30	file_deleted	deck	deck	files	deleted_self	[{"1600":"\\/architect\\/260118_frontend_reestructuracion.md"}]		[]	/architect/260118_frontend_reestructuracion.md	https://cloud.tzzrdeck.me/apps/files/?dir=/architect	files	1600
319	1768699869	30	file_deleted	deck	deck	files	deleted_self	[{"1598":"\\/architect"}]		[]	/architect	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1598
320	1768699873	30	file_deleted	deck	deck	files	deleted_self	[{"1597":"\\/bandeja de salida\\/260115_opinion gemini.txt"}]		[]	/bandeja de salida/260115_opinion gemini.txt	https://cloud.tzzrdeck.me/apps/files/?dir=/bandeja%20de%20salida	files	1597
321	1770567474	30	file_changed	deck	deck	files	renamed_self	[{"1653":"\\/\\/00_IA"},{"1653":"\\/\\/IA"}]		[]	//00_IA	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1653
322	1770570428	30	file_created	deck	deck	files	created_self	[{"1681":"\\/prompt modelo-cero.md"}]		[]	/prompt modelo-cero.md	https://cloud.tzzrdeck.me/apps/files/?dir=/	files	1681
323	1770570442	30	file_changed	deck	deck	files	moved_self	[{"1653":"\\/00_IA\\/"},{"1681":"\\/\\/prompt modelo-cero.md"}]		[]	/00_IA/prompt modelo-cero.md	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA	files	1681
324	1772131802	30	calendar_event	deck	deck	dav	object_delete_event_self	{"actor":"deck","calendar":{"id":10,"uri":"contact_birthdays","name":"Cumplea\\u00f1os del contacto"},"object":{"id":"359b2771-76d3-496d-bc73-260294906aec","name":"\\ud83c\\udf82 Leon Green (2000)","classified":false}}		[]			calendar	10
325	1772131802	30	calendar_event	deck	deck	dav	object_add_event_self	{"actor":"deck","calendar":{"id":10,"uri":"contact_birthdays","name":"Cumplea\\u00f1os del contacto"},"object":{"id":"359b2771-76d3-496d-bc73-260294906aec","name":"\\ud83c\\udf82 Leon Green (2000)","classified":false}}		[]			calendar	10
326	1772451327	30	file_created	deck	deck	files	created_self	[{"1769":"\\/00_IA\\/infraestructura\\/front"}]		[]	/00_IA/infraestructura/front	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA/infraestructura	files	1769
327	1772451327	30	file_created	deck	deck	files	created_self	[{"1770":"\\/00_IA\\/infraestructura\\/front\\/front_modelocero.html"}]		[]	/00_IA/infraestructura/front/front_modelocero.html	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA/infraestructura/front	files	1770
328	1772619377	30	file_changed	deck	deck	files	changed_self	[{"1770":"\\/00_IA\\/infraestructura\\/front\\/front_modelocero.html"}]		[]	/00_IA/infraestructura/front/front_modelocero.html	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA/infraestructura/front	files	1770
329	1772621021	30	file_changed	deck	deck	files	changed_self	[{"1770":"\\/00_IA\\/infraestructura\\/front\\/front_modelocero.html"}]		[]	/00_IA/infraestructura/front/front_modelocero.html	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA/infraestructura/front	files	1770
330	1772622935	30	file_created	deck	deck	files	created_self	[{"1777":"\\/00_IA\\/sesiones\\/260304_normalizacion_de_frontends.md"}]		[]	/00_IA/sesiones/260304_normalizacion_de_frontends.md	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA/sesiones	files	1777
331	1772631148	30	file_created	deck	deck	files	created_self	[{"1778":"\\/00_IA\\/agentes\\/migrador_deck.md"}]		[]	/00_IA/agentes/migrador_deck.md	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA/agentes	files	1778
333	1772631148	30	file_created	deck	deck	files	created_self	[{"1781":"\\/00_IA\\/agentes\\/prototipo_tailwind.md"}]		[]	/00_IA/agentes/prototipo_tailwind.md	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA/agentes	files	1781
334	1772631148	30	file_created	deck	deck	files	created_self	[{"1779":"\\/00_IA\\/agentes\\/mcp_frontend.md"}]		[]	/00_IA/agentes/mcp_frontend.md	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA/agentes	files	1779
332	1772631148	30	file_created	deck	deck	files	created_self	[{"1780":"\\/00_IA\\/agentes\\/servicios_ui.md"}]		[]	/00_IA/agentes/servicios_ui.md	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA/agentes	files	1780
335	1772631148	30	file_changed	deck	deck	files	changed_self	[{"1770":"\\/00_IA\\/infraestructura\\/front\\/front_modelocero.html"}]		[]	/00_IA/infraestructura/front/front_modelocero.html	https://cloud.tzzrdeck.me/apps/files/?dir=/00_IA/infraestructura/front	files	1770
\.


--
-- Data for Name: oc_activity_mq; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_activity_mq (mail_id, amq_timestamp, amq_latest_send, amq_type, amq_affecteduser, amq_appid, amq_subject, amq_subjectparams, object_type, object_id) FROM stdin;
\.


--
-- Data for Name: oc_addressbookchanges; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_addressbookchanges (id, uri, synctoken, addressbookid, operation, created_at) FROM stdin;
2	Database:nextcloud@tzzr.pro.vcf	1	1	1	1768111814
3	Database:nextcloud@tzzr.pro.vcf	2	1	2	1768111815
4	Database:nextcloud@tzzr.pro.vcf	3	1	2	1768111815
5	Database:nextcloud@tzzr.pro.vcf	4	1	3	1768111893
6	Database:tzzrdeck.vcf	5	1	1	1768111895
7	Database:tzzrdeck.vcf	6	1	2	1768111895
8	Database:tzzrdeck.vcf	7	1	2	1768111895
10	Database:tzzrdeck.vcf	8	1	3	1768656723
11	Database:tzzrdeck.vcf	9	1	1	1768656747
12	Database:tzzrdeck.vcf	10	1	2	1768656747
13	Database:tzzrdeck.vcf	11	1	2	1768656747
15	Database:tzzrdeck.vcf	12	1	2	1768657822
17	Database:admin.vcf	13	1	3	1768669290
18	Database:deck.vcf	14	1	1	1768670965
19	Database:deck.vcf	15	1	2	1768670965
20	Database:tzzrdeck.vcf	16	1	3	1768670967
21	default	1	6	1	1768671044
22	Database:deck.vcf	17	1	2	1772131503
23	Database:deck.vcf	18	1	2	1773585017
\.


--
-- Data for Name: oc_addressbooks; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_addressbooks (id, principaluri, displayname, uri, description, synctoken) FROM stdin;
6	principals/users/deck	Contacts	contacts	\N	2
1	principals/system/system	system	system	System addressbook which holds all users of this instance	19
\.


--
-- Data for Name: oc_appconfig; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_appconfig (appid, configkey, configvalue, type, lazy) FROM stdin;
core	installedat	1766445201.322	2	0
core	vendor	nextcloud	2	0
provisioning_api	installed_version	1.22.0	2	0
provisioning_api	enabled	yes	2	0
provisioning_api	types	prevent_group_restriction	2	0
twofactor_backupcodes	installed_version	1.21.0	2	0
twofactor_backupcodes	enabled	yes	2	0
twofactor_backupcodes	types		2	0
support	installed_version	4.0.0-dev.0	2	0
support	enabled	yes	2	0
support	types	session	2	0
lookup_server_connector	installed_version	1.20.0	2	0
lookup_server_connector	enabled	yes	2	0
lookup_server_connector	types	authentication	2	0
weather_status	installed_version	1.12.0	2	0
weather_status	enabled	yes	2	0
weather_status	types		2	0
notifications	installed_version	5.0.0-dev.0	2	0
notifications	enabled	yes	2	0
notifications	types	logging	2	0
comments	installed_version	1.22.0	2	0
comments	enabled	yes	2	0
comments	types	logging	2	0
dav	installed_version	1.34.2	2	0
dav	enabled	yes	2	0
dav	types	filesystem	2	0
dashboard	installed_version	7.12.0	2	0
dashboard	enabled	yes	2	0
dashboard	types		2	0
files_downloadlimit	installed_version	5.0.0-dev.0	2	0
files_downloadlimit	enabled	yes	2	0
files_downloadlimit	types		2	0
recommendations	installed_version	5.0.0-dev.0	2	0
recommendations	enabled	yes	2	0
recommendations	types		2	0
app_api	installed_version	32.0.0	2	0
app_api	enabled	yes	2	0
app_api	types		2	0
files_versions	installed_version	1.25.0	2	0
files_versions	enabled	yes	2	0
files_versions	types	filesystem,dav	2	0
federation	installed_version	1.22.0	2	0
federation	enabled	yes	2	0
federation	types	authentication	2	0
related_resources	installed_version	3.0.0-dev.0	2	0
related_resources	enabled	yes	2	0
related_resources	types		2	0
user_status	installed_version	1.12.0	2	0
user_status	enabled	yes	2	0
user_status	types		2	0
contactsinteraction	installed_version	1.13.1	2	0
contactsinteraction	enabled	yes	2	0
contactsinteraction	types	dav	2	0
cloud_federation_api	installed_version	1.16.0	2	0
cloud_federation_api	enabled	yes	2	0
cloud_federation_api	types	filesystem	2	0
serverinfo	installed_version	4.0.0-dev.0	2	0
serverinfo	enabled	yes	2	0
serverinfo	types		2	0
files_sharing	installed_version	1.24.1	2	0
files_sharing	enabled	yes	2	0
core	public_files	files_sharing/public.php	2	0
files_sharing	types	filesystem	2	0
profile	installed_version	1.1.0	2	0
profile	enabled	yes	2	0
profile	types		2	0
logreader	installed_version	5.0.0-dev.0	2	0
logreader	enabled	yes	2	0
logreader	types	logging	2	0
sharebymail	installed_version	1.22.0	2	0
sharebymail	enabled	yes	2	0
sharebymail	types	filesystem	2	0
federatedfilesharing	installed_version	1.22.0	2	0
federatedfilesharing	enabled	yes	2	0
federatedfilesharing	types		2	0
firstrunwizard	installed_version	5.0.0-dev.0	2	0
firstrunwizard	enabled	yes	2	0
firstrunwizard	types		2	0
viewer	installed_version	5.0.0-dev.0	2	0
viewer	enabled	yes	2	0
viewer	types		2	0
webhook_listeners	installed_version	1.3.0	2	0
webhook_listeners	enabled	yes	2	0
webhook_listeners	types	filesystem	2	0
privacy	installed_version	4.0.0-dev.0	2	0
privacy	enabled	yes	2	0
privacy	types		2	0
systemtags	installed_version	1.22.0	2	0
systemtags	enabled	yes	2	0
systemtags	types	logging	2	0
updatenotification	installed_version	1.22.0	2	0
updatenotification	enabled	yes	2	0
updatenotification	types		2	0
files	installed_version	2.4.0	2	0
files	enabled	yes	2	0
files	types	filesystem	2	0
circles	installed_version	32.0.0	2	0
circles	enabled	yes	2	0
circles	types	filesystem,dav	2	0
activity	installed_version	5.0.0-dev.0	2	0
activity	enabled	yes	2	0
activity	types	filesystem	2	0
password_policy	installed_version	4.0.0-dev.0	2	0
password_policy	enabled	yes	2	0
password_policy	types	authentication	2	0
files_trashbin	installed_version	1.22.0	2	0
files_trashbin	enabled	yes	2	0
files_trashbin	types	filesystem,dav	2	0
survey_client	installed_version	4.0.0-dev.0	2	0
survey_client	enabled	yes	2	0
survey_client	types		2	0
settings	installed_version	1.15.1	2	0
settings	enabled	yes	2	0
settings	types		2	0
files_pdfviewer	installed_version	5.0.0-dev.0	2	0
files_pdfviewer	enabled	yes	2	0
files_pdfviewer	types		2	0
theming	installed_version	2.7.0	2	0
theming	enabled	yes	2	0
theming	types	logging	2	0
bruteforcesettings	installed_version	5.0.0-dev.0	2	0
bruteforcesettings	enabled	yes	2	0
bruteforcesettings	types		2	0
oauth2	installed_version	1.20.0	2	0
oauth2	enabled	yes	2	0
oauth2	types	authentication	2	0
photos	installed_version	5.0.0-dev.1	2	0
photos	enabled	yes	2	0
photos	types	dav,authentication	2	0
text	installed_version	6.0.1	2	0
text	enabled	yes	2	0
text	types	dav	2	0
workflowengine	installed_version	2.14.0	2	0
workflowengine	enabled	yes	2	0
workflowengine	types	filesystem	2	0
nextcloud_announcements	installed_version	4.0.0-dev.0	2	0
nextcloud_announcements	enabled	yes	2	0
nextcloud_announcements	types	logging	2	0
files_reminders	installed_version	1.5.0	2	0
files_reminders	enabled	yes	2	0
files_reminders	types		2	0
core	files_metadata	{"photos-original_date_time":{"value":null,"type":"int","etag":"","indexed":true,"editPermission":0},"photos-exif":{"value":null,"type":"array","etag":"","indexed":false,"editPermission":0},"photos-ifd0":{"value":null,"type":"array","etag":"","indexed":false,"editPermission":0},"photos-size":{"value":null,"type":"array","etag":"","indexed":false,"editPermission":0}}	64	1
dav	hasCustomDefaultContact	0	32	0
circles	loopback_tmp_scheme	https	2	0
core	moveavatarsdone	yes	2	0
core	previewsCleanedUp	1	2	0
circles	migration_22	1	2	0
updatenotification	core	32.0.6.1	4	0
dav	regeneratedBirthdayCalendarsForYearFix	yes	2	0
dav	buildCalendarSearchIndex	yes	2	0
dav	builtSocialSearchIndex	yes	2	0
dav	buildCalendarReminderIndex	yes	2	0
support	SwitchUpdaterServerHasRun	yes	2	0
updatenotification	update_check_errors	0	8	0
core	backgroundjobs_mode	cron	4	0
serverinfo	size_appdata_storage	0	16	0
serverinfo	cached_count_storages	3	8	0
core	oc.integritycheck.checker	[]	64	1
core	metadataGenerationDone	1	32	0
files	mimetype_version	32.0.5.0	4	0
photos	lastPlaceMappedUser	deck	2	0
photos	lastPlaceMappingDone	true	2	0
core	lastupdatedat	1773889965	8	0
circles	migration_run	0	2	0
circles	maintenance_run	0	2	0
nextcloud_announcements	pub_date	Thu, 24 Oct 2019 00:00:00 +0200	2	0
circles	maintenance_update	{"3":1773925502,"2":1773927618,"1":1773927618}	2	0
serverinfo	cached_count_filecache	683	8	0
serverinfo	cached_count_appdata_files	554	8	0
backgroundjob	lastjob	27	2	0
core	lastcron	1773927618	8	0
core	lastupdateResult	{"version":"32.0.6.1","versionstring":"Nextcloud 32.0.6","url":"https:\\/\\/download.nextcloud.com\\/server\\/releases\\/nextcloud-32.0.6.zip","web":"https:\\/\\/docs.nextcloud.com\\/server\\/32\\/admin_manual\\/maintenance\\/upgrade.html","changes":"https:\\/\\/updates.nextcloud.com\\/changelog_server\\/?version=32.0.6","autoupdater":"1","eol":"0"}	2	0
\.


--
-- Data for Name: oc_appconfig_ex; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_appconfig_ex (id, appid, configkey, configvalue, sensitive) FROM stdin;
\.


--
-- Data for Name: oc_authorized_groups; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_authorized_groups (id, group_id, class) FROM stdin;
\.


--
-- Data for Name: oc_authtoken; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_authtoken (id, uid, login_name, password, name, token, type, remember, last_activity, last_check, scope, expires, private_key, public_key, version, password_invalid, password_hash) FROM stdin;
115	deck	deck	U36s914GMSh5CEB5Mg+0PgIq7KlGNDomJ7RaHjqSz2fEHgUQyM90MVKVFFE1OmlkCL8MuffZSBV1GQlyZPLsXnhhkpRNxNqNhLsi/hlJAkyrEd9GjzsiVu6tQpfg2guucLp0/JUw78RRgYA3JQcJEm8HozeHoge1aT1q6CTOvfjo2hdoZvKkxQFC3vZXKsE5lSqDP57IoyXtEkpgPMCavHZ+LJRVDSmJSK1gCd1k/8aYUBzHYD09u26BsoMuYqMUsjrdCXevmmNY72YEdVHAwTHhPAidgSUDHI2+1fCDPv86OJYe/gpwml3d5n3CDAEK+sT8Tt+H0RFzoCCgIuaaVw==	Mac (Desktop Client - Macintosh)	6fc8b49986f1fdd2e3cbbfd668a03ec84cf5076135a1174d09ebcd1ddad9b7325317c87eb4bd5ba5c7d0bbc20f6bffaaef5cca14a967786e0478174a7f0b39e2	1	0	1773456576	1773456424	\N	\N	b6961b664de3feeeb11cd195c2ed2700b29f75b99779f90eb5c7993103102a8d9084ae6138abf712138144326dab3023721fdb9f13a2607fe2e4ca0173a57dfa400eed892ab4a46695cfd6b46aeb3d94b1dcb4e3476d062abf20501d9b2607563ee4da4f5a042276055fbcac38574b6605c2e7c60a69d5a8e3b0eea31596fa8c89867d06c7c71e9d2beffd0f240bda98078f29d668930c25fb1e66eb9d3e853ef6eca4aedae8de5bcf422b33b507b3a8da3f418b07bbbd02939ba1c4718345b21702d08ed69ebbfc1d9d17ad2ceadbf0997eb74df66e6034d3eff42e0de2834abae43d953033f15d09a2a38d085b17624490bafc9eaebc8328cba2a348af9182f3e5ad23c58d6ca0829616af0cc87b3d1c3a4ee006d16593f19771639938493bb3397eec6cd1586e9b393a7cb4294ca267ba0d67a2c041cc77f4ad116622e98b557b820d1f9ac3be485c273e63c79fe61564083d92adfa1dba68cce130aaae3cdd87fd17fdfd987c92f62bd572aa288da118ad849956a4cf62e7abbc2e28a237d8afc40aeeec12e6d40b9d4462fb2e137d3e2f4ee1347b3a6c544308ad3d1bb05cf2d599344f5ee3f44e7819528a2ad5d8058fbcddfad3baf93ef718f48f549c3991d608dff06cf63de8ad39368e7a24787bb5be631c5aaf51952f41c19de4a190a9c32353f27e29f744084141166cdf60d3492b9162ca68a7005754ebee642443e140915f5e6e2831c6870128713aeab65c6917886a3d7aff9cdb56abbb747e111d31306e1e0d31dbc75b58aff436c173e812dcc50fd5d0bfbef287f36a964cc134f7a1c3df3ec4f298328b361bafdb1ecf68ab0a569f8de343bfeed0a7229d6a0f2a7bc8111a3365d6e9d52ea985dc86eba2e94b4f4839bb2ce4f690f2497cf7193fd227f101f050095b22cd718ccbc950ee7dce9f69f2c32a73ea5b93a13f1d0106d6c8d098e42e58a272fa82d9a656bbe5cdb20021dcf7f69adc37f8dcfaeeb208d55bbd7ff29314215fc75f9e993fb794db27ac82a2e96bc821b2b76d0916191f5afcb8e0b37679b0800fe7c6fec6f4751e72cee22911947b27d6f0ce9dc796de1cd97d5a5e26060ff950be6ac06638dd0195e01c2cf84bf34439039f04988d7722703fe9642b3ceaed3b40cfbde8432f3ba045a35c72bbf37918cededf59d1b2d2976e881fd28d49ddc9fe70da8e03fbaf9ef921214a1c2de522fe64b33f87c25a35d8ef40272f3c850152ee3c7dab515626880b640bab8e52c6a9853e1ed9dc3af0bcbd73dadea0ac2f0ceeb8842ddf4242ac1708ab6ef850242f5d83176a9034e4ae8088b27de678e355cca66d473e20eaee6c916500c87ae04348e53be7ac394ee3ad7aca27947ee56594b00c0c348fc8091a4d0596e022d3bd2a1ce70d7a1f1c23ce1f42d3604b297418085c45c572b805cfaeebf8f7ec6b92998ffdb0bac6cfaf889b0c21afee4c129ba1a3d3fc8da4943cef09181ad0a613dca6c70cbd79f774d5464f434367cc2dcd808927854831e2526585fbded193285adb5443a90b410e8c20ae023b88323def724ff97da1c966306f7ba64f54f68f7c9b7817ecc2476500b8fb69b7297f4d5294cf321e2f94c577777fe6b9e9a82c7c328af0193a1b34cdd3d310192025797300d2ee44706ef3d2657720017e55dc9b33c631520cb79345c156cb9a5133b54d1e034503815a26d89f31db53a0cf0f169691021ea1ddd6eb7afdcb6b11403ebe10d7df49a4afb8070c4a71a138f4fa13def3eaf4b9b253c7ca73792629ba71669ca57556c82be5845facd3fba9216fcc38ee4a79e2a9379ac00466fb6a1463cec697cf04997a6fd3281caabc8ac5d00ec57006416a32316fbff9ecd64eb9643b9395fe858b66edd34ac4e371cf428868278cbb3063a74b0ec19b5bf0a7a0cb26fc94538db55c576435436eaa75ee3508448296deecceb31fa4d09f29178f4ca769abbf6ed3b9a6f4b6955089ecc388d9053af17da253ffc85ab9f8a910cf187d779d2aa0a099d7a83e939ea755126166b7dc40d06964ead920564a408b48120fa40c1a66dab9d4b48301da9adaf6bff7f65b323fceb07460ab023e4634ec2edbf62a425b68664b6ab915bf6600144adfa3f1d4734941eb01d85ecd1a53bb1afeec6a2b2554db1d9364c68b5c584238cacb6bec1f3c151f35903ca1a956dc102caf1304be7efc8eef356da07a97a0d1e4bca32ef7d835896317c1d058ff3c8f59e9a6129cf24d55baf8b1ef7dde657723287e877908c4fb805675164093b9be4734de4fb2245d4ea7f5a66ac4860a056ff275b947e7828193d2cc3495bb574fa7a587adbc69676aabbb21251f8f999526015a8a65acc389f830bc2d9a23110540950265db8e3d77258ac41d26b8524bbe547180968a102959c5c3e4e8db49e03b20|fa1e48eb88540bed32d4558062ceabe2|3722eff8fa8ac42522412250245b0572574b5f76e23b22ff0079f2f344677e276c69b0f527803517e542b66ce40aaa729a3e384799044e3170f843bc8c88e9f3|3	-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtFXa6X379K3E8pjxvo4C\nyZ7AiswC/y3SRJ+0z6IMnU+oUFo9b3oPjagScnqHc93EmxITqSwjldemIcdZMU3e\n+AstPrrZQXrQ5nTWf3q3JMB6ri598iVYdzVRiTV29mQa1H81gJSf8n8OKwWWmhvk\noKMp4N96HTGMAVw9L2OpTcYtfC/yIgseR/J3bwaqrN2VcRSMUZAmV1wj2ORpIEBK\n3+0Ta2woHaQX8258/COVGaLYKncaIehBtE0E6seUm1Mku75e9cIbWqXdHY8IH024\nPrDJViRuMoswQ7UEz16iQFe+94RIk9ppTmwxgWGAhrVoaiU42A67Khl56n5xUsWo\n9wIDAQAB\n-----END PUBLIC KEY-----\n	2	f	3|$argon2id$v=19$m=65536,t=4,p=1$U1c2RkNyR2FmQ042aUFZWA$wVPAF8e92cTlp+VqBnTF1ZYzz354TWJ4r6N9+Z9xh0c
117	deck	deck	BXz7/wkLkqkZa+NQe76yqNTFgOfYpsdHuOiSAYYP2vhX/Lbchy7WqIpLtj141tE2hSfspu6dAuK6EacGJRStxnwTAr0tJWY7QCNqzUW2HNyv2BQ+ANO44qWqaYq+Z9eVd7i6Tw1kXeT4AbysYbKinWdwIp9j2GHcGPWzoKiyRoQCfQI/rUnFePVWaAkj5A8eQce/f7cT5E6b/Ip/7ptM4nAz+3Y0KKvHE0ZjtEKsE6UHHsA2EsfBV4sIf5/qQjy04KQtSvRqd9/cVFpE0AWpXOoeVUFJbprphRW5oWzJWMeYllG5PYE+zhCrp3ULDrVN2AhDyc0BCIGHa91DlQoDqw==	Mozilla/5.0 (Android) Nextcloud-android/3.34.1	0739d1e6c3bc4b8fcc0950956d3cf7bde7764f78c425741913e7b9fd9f9ec36da8d7cea3aa14c599ad4d0548c73e9ddd635480a93d4705fb0af9566555074d33	1	0	1771998265	1771998265	\N	\N	96c34005800c78b2a89b6075704f53ce584edb262a648848517862d17cddf0a9ce713ea1a13b9d25937dcac07ebac8757f87ad79de1a0a06ad7d7c7888bb5bf35b364a79b7bee7bd6a905dec8d31de7910d37d06086780ddc1829e4d51ed34c0bc18e457af8fdd38c927121482e187ee5e5bb99fa5773358041c378d3abd8bc09841762a7b0fca2a8dd788a0cea7d267883a17b0d2126400d9ec787424abea1daaa1312e00764865fdfd7dfe59d194cb1885a2c227b8f40a962b4e854b0b305157a9c03e2bb264fdf79c86b8a9057cc71fb2c1cbfe92bccd5dc68ef991caacf9ea246329dbc0fae3c52ae6d8e489a5b146508ae1ee66268080aca6362d8a32bba59e6040881edae8b7c03f1efc52835ec4fa5ca69f5c77360e17665e07cc7fd14952ff794ab53ff26f0df2b8f4cdbe7267a8ad3a26994af9c2a0dc7c5290a1c203a01b687946f00d5f9a2be823ed37d60d98fe8b3a10add012a5ca8ba56d1afd1a0df70ed42316ef479cada84703381fc77a6ef891c31838890c02b2700e120407aef9c59323966356ea43ca04be0f97b27887cead6db124f5e2c15bde6d6562342dbc4abb1bf206b0fd571a75721bc3bdbce537b493d40b270b09a7d3668bb1b5571b1e196c88ed6e55c828aefeb1449bc3cd791f38b3e1e760eaded661bebf8c9df65b8ccfff5b41ff4636e3f46fa3bfefa27c7fd73821246e99d4c599f385327d5a8ecdf4b44dc09f219309435d2ac29cc8a70d2f5f562dd6fff98280a3535b22437e21bf1c438002618aea9623ed84af6d5171cc26c1f40ed65e1f84a4c3cb8cb4b82e3f14d2ce162d66ebdceee89dbc8281f18e9cc7a0831d70bb7c5e930e33ee1d5be1af1bb5b1362dc4692755e622ba3663303f8865cc2dd1c6cd3f6829c55487edbb5b0a8387da1aeb08ccc3f81e2288b48d722d8134f4f005ce453805eab5391b53357ec70ed3c5c4e95a4130d319e65f704c9dca13258174ee888b86342e1c5c47b48139a8f6fb04c98573082bff9944668e2669a51df5a418e98ba33e3fa8dc5d3e08b8156370d6390e5227dfebcc5aca983b108fda5539a21ba34ad6fd08a02c10f82381db02b73dc86b6249e9694b13320bf9c6b7fec267c9334bcafcd1dc6e3cdce15bd23482922ce61f6ac133ca7c1403b2dd3a89f0916531a864d85519c694680da65b3a3fdbd0c757f18bb3c2a6c5f933457b7240bf86582f890ac43f67f99d2a193c8c3770acb29f3b513f045b04c868fd0892dd4943f9496f910e27fbacd3cee65440e42568d342737f2752298d61e8f19d979dc869a65b4560503a0eb99db4dcb0ca090c69fbb0225e0e6186680b5a2c47f2b26430f730b93c376807662eb498db043d5bf46f805f781a6763e37dacd9b6050a1a55deba4282d60fbd816b151c3f54b7194ff01f14d4c5b4757987e0f20bc929351ab1030e739e183ccc868b5f83079bd8dd0dd5e559412dc0169622fcb9667a3ab262bbea9406ffd974d36502d9dd3b4c9d77f28d15e730040a29730ae2ccbc1da9325a4a7490b6290cedff7d4cb85ab7d85cbf069f8b147748cbab8bdac3ff9f7f6cac7277b7e639d16f3ae4cdefdb6b4bd74ca4d93af72abb2bf74e7c0979005ec779445b548149daa268e67865dc33494cf8f77602749ccf77dc7adc6021c8cc9aa203557099102e9c2e5c251a99721142abcc7e3bc4f953f21c82725358888a9dc5965c455157bf507be21124a42e3ea6badf4dc4ac078ad1bfcffd161cefea56eee270d6fb5d1d691b68dca9145b0bae1a160d1672881809344449945bb1f45388170a3f1d13a2ad9008f34dd19e6980b5eb4475009f94bd9c9121bbeb94ecfc6e95b3d2840dbe2fb8df143c39569ab273eaee52bae09af5184d4635aa47bec663ef68626b9b536f7723d09984c9ebdfe9b3bed181ce992462f4d186cf630a41f65dc4d56574f49f98e126751c435f4941e71f1a189e08860cd72820739dc6b596252342df2e477db655bbcf76a04231a3b2a75a3b5d03e03a2d442d9c0589aa2aa90a8c982a6f0da5dfcef469f201ffaecd44cfe545780629f86bbd0925520e4c0a3c1f9e8d189e413aeeb74aaf0cc7f0d0c725758055200c1dad959b2e7d195983450abfbba7338e1be6b8b1ae898f5a14a6123222b0d9ad0ca075ea49867546ba0787c4c7fd8b9669a92308f732faa1073521b527485150fb8cf9cbd4b09077c55f2a9388da67084d0297c28f564e5b7541b5e9ee21afb2b17a0d2a691518b70953f4b6cbaddf9bfd9a79b23c98eccf59779cf2cb1885d2b735ed9e53b1c0aa6ac7542a6067325ef47ba5e04bc3a7e1722e16517dabbcf4117f48957424288ff4194677a83d4a66e710006760efc92907b3cccf6eb16a75b79ad1d3f89df56c81ceec91092b3b4a8e3b379c4bd510|01f11494f967b186f7f6b9b82e71afba|2e7956ac2dbbe66c40c0c9c2bd20e386a8cb2acd4431c8e86261191d22278a720ae01a598c7c19d26d3ebc0f6b0ddf22e38575e5b87c4927f53c3202f7c8b6bf|3	-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAwYSjS7fbPv/4Wy/xsBjE\nmP8Z01xJGxCnqOr7BGrwKj2yZcXYWbAchYdR5+Qdqo23Hg/IXeVg7ieuceugdEwo\nG1cgx8Wgh43SrXGr0jOyAL2iU3IfwpQ7oBRmwF6IXytxgwuxWQdlwu5GJJ9E8GIO\nwitgL4NlhVS/M0jyE8bp29lg/s0TeiB3J/rj4yeL+bvQbJK/PZ6nIYyW62O6543A\n9UCgwcpXiHL7wgY76KXgJOj5BTN4ZQiTSTLLRhUvOcBbUkd+QpOBcmxONcouihrg\nArV9fMAXc9U67u72gaJ/HdDZOQU+H9I3lZsrG3HnxSYcIVXCjCrhAaAvla1ZUe7W\nVQIDAQAB\n-----END PUBLIC KEY-----\n	2	f	3|$argon2id$v=19$m=65536,t=4,p=1$U1c2RkNyR2FmQ042aUFZWA$wVPAF8e92cTlp+VqBnTF1ZYzz354TWJ4r6N9+Z9xh0c
\.


--
-- Data for Name: oc_bruteforce_attempts; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_bruteforce_attempts (id, action, occurred, ip, subnet, metadata) FROM stdin;
\.


--
-- Data for Name: oc_calendar_invitations; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendar_invitations (id, uid, recurrenceid, attendee, organizer, sequence, token, expiration) FROM stdin;
\.


--
-- Data for Name: oc_calendar_reminders; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendar_reminders (id, calendar_id, object_id, is_recurring, uid, recurrence_id, is_recurrence_exception, event_hash, alarm_hash, type, is_relative, notification_date, is_repeat_based) FROM stdin;
7	10	10	1	359b2771-76d3-496d-bc73-260294906aec	1798761600	0	88c8121877ecb09038e898ad6bded686	76093d23ab21b01668f0685b69a71007	DISPLAY	1	1798794000	0
\.


--
-- Data for Name: oc_calendar_resources; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendar_resources (id, backend_id, resource_id, email, displayname, group_restrictions) FROM stdin;
\.


--
-- Data for Name: oc_calendar_resources_md; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendar_resources_md (id, resource_id, key, value) FROM stdin;
\.


--
-- Data for Name: oc_calendar_rooms; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendar_rooms (id, backend_id, resource_id, email, displayname, group_restrictions) FROM stdin;
\.


--
-- Data for Name: oc_calendar_rooms_md; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendar_rooms_md (id, room_id, key, value) FROM stdin;
\.


--
-- Data for Name: oc_calendarchanges; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendarchanges (id, uri, synctoken, calendarid, operation, calendartype, created_at) FROM stdin;
8	YYrSQg18asUjY2EExYRi5fcF7uTjPfZA.ics	1	9	1	0	1768671044
9	contacts-default.ics	1	10	1	0	1768671044
10	contacts-default.ics	2	10	3	0	1772131802
11	contacts-default.ics	3	10	1	0	1772131802
\.


--
-- Data for Name: oc_calendarobjects; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendarobjects (id, calendardata, uri, calendarid, lastmodified, etag, size, componenttype, firstoccurence, lastoccurence, uid, classification, calendartype, deleted_at) FROM stdin;
8	\\x424547494e3a5643414c454e4441520d0a56455253494f4e3a322e300d0a50524f4449443a2d2f2f53616272652f2f536162726520564f626a65637420342e352e362f2f454e0d0a43414c5343414c453a475245474f5249414e0d0a424547494e3a564556454e540d0a5549443a59597253516731386173556a5932454578595269356663463775546a50665a410d0a44545354414d503a3230323630313137543137333034345a0d0a53554d4d4152593a4576656e746f20646520656a656d706c6f202d20c2a1c3a16272616c6f210d0a445453544152543a3230323630313234543130303030305a0d0a4454454e443a3230323630313234543131303030305a0d0a4445534352495054494f4e3ac2a14269656e76656e69646f2061204e657874636c6f75642043616c656e646172215c6e5c6e4573746520657320756e206576656e746f20646520656a656d0d0a20706c6f202d20c2a16578706c6f7265206c6120666c65786962696c6964616420646520706c616e65617220636f6e204e657874636c6f75642043616c656e6461722065646974616e646f0d0a20206375616e74617320766563657320717569657261215c6e5c6e436f6e204e657874636c6f75642043616c656e6461725c2c20706f6472c3a13a5c6e2d2043726561725c2c20656469740d0a2061725c2c20792061646d696e697374726172206576656e746f732066c3a163696c6d656e74652e5c6e2d204372656172206dc3ba6c7469706c65732063616c656e646172696f732079200d0a20636f6d7061727469726c6f7320636f6e2073752065717569706f2064652074726162616a6f5c2c20616d69676f735c2c206f2073752066616d696c69612e5c6e2d2056657269666963610d0a2072206c6120646973706f6e6962696c696461642079206d6f737472617220737573207469656d706f73206465206f63757061646f2061206f74726f732e5c6e2d20536520696e746567720d0a2061206465206d616e657261207472616e73706172656e746520636f6e206f747261732061707073207920646973706f73697469766f73207669612043616c4441562e5c6e2d20506572730d0a206f6e616c69636520737520657870657269656e6369613a2050726f6772616d65206576656e746f7320726563757272656e7465735c2c20616a75737465206c6173206e6f7469666963610d0a2063696f6e65735c2c206173c3ad20636f6d6f206f74726f7320616a75737465732e0d0a454e443a564556454e540d0a454e443a5643414c454e4441520d0a	YYrSQg18asUjY2EExYRi5fcF7uTjPfZA.ics	9	1768671044	d6c9deffcbe5c3a0e79b3983239af86d	939	VEVENT	1769248800	1769252400	YYrSQg18asUjY2EExYRi5fcF7uTjPfZA	0	0	\N
10	\\x424547494e3a5643414c454e4441520d0a56455253494f4e3a322e300d0a43414c5343414c453a475245474f5249414e0d0a50524f4449443a2d2f2f49444e206e657874636c6f75642e636f6d2f2f42697274686461792063616c656e6461722f2f454e0d0a424547494e3a564556454e540d0a44545354414d503a3230323630323236543138353030325a0d0a445453544152543b56414c55453d444154453a32303030303130310d0a4454454e443b56414c55453d444154453a32303030303130320d0a5549443a33353962323737312d373664332d343936642d626337332d3236303239343930366165630d0a5252554c453a465245513d594541524c590d0a53554d4d4152593af09f8e82204c656f6e20477265656e202832303030290d0a5452414e53503a5452414e53504152454e540d0a582d4e455854434c4f55442d42432d4649454c442d545950453a424441590d0a582d4e455854434c4f55442d42432d554e4b4e4f574e2d594541523a300d0a582d4e455854434c4f55442d42432d594541523a323030300d0a424547494e3a56414c41524d0d0a545249474745523b56414c55453d4455524154494f4e3a505439480d0a414354494f4e3a444953504c41590d0a4445534352495054494f4e3af09f8e82204c656f6e20477265656e202832303030290d0a454e443a56414c41524d0d0a454e443a564556454e540d0a454e443a5643414c454e4441520d0a	contacts-default.ics	10	1772131802	2a28abc798ae92aeb4b16e1133599c0e	534	VEVENT	946684800	2145916800	359b2771-76d3-496d-bc73-260294906aec	0	0	\N
\.


--
-- Data for Name: oc_calendarobjects_props; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendarobjects_props (id, calendarid, objectid, name, parameter, value, calendartype) FROM stdin;
11	9	8	SUMMARY	\N	Evento de ejemplo - ¡ábralo!	0
12	9	8	DESCRIPTION	\N	¡Bienvenido a Nextcloud Calendar!\n\nEste es un evento de ejemplo - ¡explore la flexibilidad de planear con Nextcloud Calendar editando cuantas veces quiera!\n\nCon Nextcloud Calendar, podrá:\n- Crear, editar, y administrar eventos fácilmente.\n- Crear mú	0
14	10	10	SUMMARY	\N	🎂 Leon Green (2000)	0
\.


--
-- Data for Name: oc_calendars; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendars (id, principaluri, displayname, uri, synctoken, description, calendarorder, calendarcolor, timezone, components, transparent, deleted_at) FROM stdin;
9	principals/users/deck	Personal	personal	2	\N	0	#00679e	\N	VEVENT	0	\N
3	principals/system/system	Contact birthdays	contact_birthdays	1	\N	0	#E9D859	\N	VEVENT	0	\N
10	principals/users/deck	Cumpleaños del contacto	contact_birthdays	4	\N	0	#E9D859	\N	VEVENT	0	\N
\.


--
-- Data for Name: oc_calendars_federated; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendars_federated (id, display_name, color, uri, principaluri, remote_url, token, sync_token, last_sync, shared_by, shared_by_display_name, components, permissions) FROM stdin;
\.


--
-- Data for Name: oc_calendarsubscriptions; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_calendarsubscriptions (id, uri, principaluri, displayname, refreshrate, calendarorder, calendarcolor, striptodos, stripalarms, stripattachments, lastmodified, synctoken, source) FROM stdin;
\.


--
-- Data for Name: oc_cards; Type: TABLE DATA; Schema: public; Owner: oc_admin
--

COPY public.oc_cards (id, addressbookid, carddata, uri, lastmodified, etag, size, uid) FROM stdin;
9	6	\\x[encoded data, 272194 characters]