Software Público Brasileiro

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: alembic_version; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE alembic_version (
    version_num character varying(32) NOT NULL
);


ALTER TABLE alembic_version OWNER TO postgres;

--
-- Name: lb_base; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_base (
    id_base integer NOT NULL,
    name character varying NOT NULL,
    struct character varying NOT NULL,
    dt_base timestamp without time zone NOT NULL,
    idx_exp boolean NOT NULL,
    idx_exp_url character varying,
    idx_exp_time integer,
    file_ext boolean NOT NULL,
    file_ext_time integer,
    txt_mapping character varying
);


ALTER TABLE lb_base OWNER TO postgres;

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

CREATE SEQUENCE lb_base_id_base_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_base_id_base_seq OWNER TO postgres;

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

ALTER SEQUENCE lb_base_id_base_seq OWNED BY lb_base.id_base;


--
-- Name: lb_doc__form; Type: TABLE; Schema: public; Owner: lbu; Tablespace: 
--

CREATE TABLE lb_doc__form (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone
);


ALTER TABLE lb_doc__form OWNER TO lbu;

--
-- Name: lb_doc__form_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: lbu
--

CREATE SEQUENCE lb_doc__form_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__form_id_doc_seq OWNER TO lbu;

--
-- Name: lb_doc__history; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc__history (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone
);


ALTER TABLE lb_doc__history OWNER TO postgres;

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

CREATE SEQUENCE lb_doc__history_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__history_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc__report; Type: TABLE; Schema: public; Owner: lbu; Tablespace: 
--

CREATE TABLE lb_doc__report (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone
);


ALTER TABLE lb_doc__report OWNER TO lbu;

--
-- Name: lb_doc__report_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: lbu
--

CREATE SEQUENCE lb_doc__report_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__report_id_doc_seq OWNER TO lbu;

--
-- Name: lb_doc__search; Type: TABLE; Schema: public; Owner: lbu; Tablespace: 
--

CREATE TABLE lb_doc__search (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone
);


ALTER TABLE lb_doc__search OWNER TO lbu;

--
-- Name: lb_doc__search_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: lbu
--

CREATE SEQUENCE lb_doc__search_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__search_id_doc_seq OWNER TO lbu;

--
-- Name: lb_doc__user; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc__user (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone,
    name_base character varying[],
    id_user integer,
    status_user boolean,
    access_type character varying[],
    name_user character varying,
    creation_date_user date,
    email_user character varying,
    passwd_user character varying
);


ALTER TABLE lb_doc__user OWNER TO postgres;

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

CREATE SEQUENCE lb_doc__user_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__user_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc_app_user; Type: TABLE; Schema: public; Owner: lbu; Tablespace: 
--

CREATE TABLE lb_doc_app_user (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone,
    id_user character varying,
    status_user boolean,
    name_user character varying,
    creation_date_user date,
    email_user character varying,
    passwd_user character varying
);


ALTER TABLE lb_doc_app_user OWNER TO lbu;

--
-- Name: lb_doc_app_user_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: lbu
--

CREATE SEQUENCE lb_doc_app_user_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc_app_user_id_doc_seq OWNER TO lbu;

--
-- Name: lb_doc_log_lbconverter; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc_log_lbconverter (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone,
    file_name character varying,
    id_doc_orig integer,
    nm_base character varying,
    dt_error timestamp without time zone
);


ALTER TABLE lb_doc_log_lbconverter OWNER TO postgres;

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

CREATE SEQUENCE lb_doc_log_lbconverter_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc_log_lbconverter_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc_log_lbindex; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc_log_lbindex (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone,
    id_doc_orig integer,
    dt_last_up_orig timestamp without time zone,
    nm_base character varying,
    dt_error timestamp without time zone
);


ALTER TABLE lb_doc_log_lbindex OWNER TO postgres;

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

CREATE SEQUENCE lb_doc_log_lbindex_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc_log_lbindex_id_doc_seq OWNER TO postgres;

--
-- Name: lb_file__form; Type: TABLE; Schema: public; Owner: lbu; Tablespace: 
--

CREATE TABLE lb_file__form (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__form OWNER TO lbu;

--
-- Name: lb_file__history; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file__history (
    id_file integer NOT NULL,
    id_doc integer NOT NULL,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__history OWNER TO postgres;

--
-- Name: lb_file__report; Type: TABLE; Schema: public; Owner: lbu; Tablespace: 
--

CREATE TABLE lb_file__report (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__report OWNER TO lbu;

--
-- Name: lb_file__search; Type: TABLE; Schema: public; Owner: lbu; Tablespace: 
--

CREATE TABLE lb_file__search (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__search OWNER TO lbu;

--
-- Name: lb_file__user; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file__user (
    id_file integer NOT NULL,
    id_doc integer NOT NULL,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__user OWNER TO postgres;

--
-- Name: lb_file_app_user; Type: TABLE; Schema: public; Owner: lbu; Tablespace: 
--

CREATE TABLE lb_file_app_user (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file_app_user OWNER TO lbu;

--
-- Name: lb_file_log_lbconverter; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file_log_lbconverter (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file_log_lbconverter OWNER TO postgres;

--
-- Name: lb_file_log_lbindex; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file_log_lbindex (
    id_file integer NOT NULL,
    id_doc integer NOT NULL,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file_log_lbindex OWNER TO postgres;

--
-- Name: lb_index_error; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_index_error (
    id_error integer NOT NULL,
    base character varying NOT NULL,
    id_doc integer NOT NULL,
    dt_error timestamp without time zone NOT NULL,
    msg_error character varying
);


ALTER TABLE lb_index_error OWNER TO postgres;

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

CREATE SEQUENCE lb_index_error_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_index_error_seq OWNER TO postgres;

--
-- Name: lb_txt_idx; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_txt_idx (
    id_idx integer NOT NULL,
    nm_idx character varying NOT NULL,
    cfg_idx character varying NOT NULL,
    dt_crt_idx timestamp without time zone NOT NULL,
    dt_upt_idx timestamp without time zone NOT NULL,
    url_idx character varying NOT NULL,
    actv_idx boolean NOT NULL,
    struct character varying NOT NULL
);


ALTER TABLE lb_txt_idx OWNER TO postgres;

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

CREATE SEQUENCE lb_txt_idx_id_idx_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_txt_idx_id_idx_seq OWNER TO postgres;

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

ALTER SEQUENCE lb_txt_idx_id_idx_seq OWNED BY lb_txt_idx.id_idx;


--
-- Name: id_base; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY lb_base ALTER COLUMN id_base SET DEFAULT nextval('lb_base_id_base_seq'::regclass);


--
-- Name: id_idx; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY lb_txt_idx ALTER COLUMN id_idx SET DEFAULT nextval('lb_txt_idx_id_idx_seq'::regclass);


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

COPY alembic_version (version_num) FROM stdin;
\.


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

COPY lb_base (id_base, name, struct, dt_base, idx_exp, idx_exp_url, idx_exp_time, file_ext, file_ext_time, txt_mapping) FROM stdin;
4	_user	{"content":[{"field":{"alias":"id","description":"LightBase's uses ID","name":"id_user","datatype":"Integer","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"name","description":"User's name","name":"name_user","datatype":"Text","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"email","description":"User's mail","name":"email_user","datatype":"Text","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"passwd","description":"User's password","name":"passwd_user","datatype":"Text","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"group":{"content":[{"field":{"alias":"name_base","description":"Name of the base the user can access","name":"name_base","datatype":"Text","indices":["Textual","Ordenado","Fuzzy"],"required":false,"multivalued":false}},{"field":{"alias":"access_type","description":"Type of access the user has","name":"access_type","datatype":"Text","indices":["Textual","Ordenado"],"required":false,"multivalued":false}}],"metadata":{"alias":"bases","description":"List of bases that the user can access and what kind of access it is","multivalued":true,"name":"bases_user"}}},{"field":{"alias":"creation_date","description":"Date the user account was created","name":"creation_date_user","datatype":"Date","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"status","description":"Check if the user is activer or not","name":"status_user","datatype":"Boolean","indices":["Textual","Ordenado"],"required":true,"multivalued":false}}],"metadata":{"color":"#000000","description":"LightBase's Users Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":4,"name":"_user","password":"","model":{"creation_date_user":"Date","email_user":"Text","id_user":"Integer","name_user":"Text","passwd_user":"Text","status_user":"Boolean","bases_user":[{"access_type":"Text","name_base":"Text"}]}}}	2017-01-01 00:00:00	f		0	f	0	
5	app_user	{"content":[{"field":{"name":"id_user","datatype":"Text","required":true,"alias":"id_user","multivalued":false,"indices":["Textual","Ordenado"],"description":"LightBase's uses ID"}},{"field":{"name":"name_user","datatype":"Text","required":true,"alias":"name","multivalued":false,"indices":["Textual","Ordenado"],"description":"User's name"}},{"field":{"name":"email_user","datatype":"Text","required":true,"alias":"email","multivalued":false,"indices":["Textual","Ordenado"],"description":"User's mail"}},{"field":{"name":"passwd_user","datatype":"Text","required":true,"alias":"passwd","multivalued":false,"indices":["Textual","Ordenado"],"description":"User's password"}},{"field":{"name":"bases","datatype":"Integer","required":false,"alias":"bases","multivalued":true,"indices":["Textual"],"description":"Id doc list the base the user is owner"}},{"field":{"name":"forms","datatype":"Integer","required":false,"alias":"forms","multivalued":true,"indices":["Textual"],"description":"Id doc list of the form where user can access"}},{"field":{"name":"reports","datatype":"Text","required":false,"alias":"reports","multivalued":true,"indices":["Textual"],"description":"Id doc list of the report where user can access"}},{"group":{"content":[{"field":{"name":"id","datatype":"Integer","required":true,"alias":"id","multivalued":false,"indices":["Textual"],"description":"Id doc of element"}},{"field":{"name":"type","datatype":"Text","required":true,"alias":"type","multivalued":false,"indices":["Textual"],"description":"Types allowed form, base and report"}}],"metadata":{"multivalued":true,"alias":"shortcuts","name":"shortcuts","description":"List of shortcuts of user"}}},{"field":{"name":"creation_date_user","datatype":"Date","required":true,"alias":"creation_date","multivalued":false,"indices":["Textual","Ordenado"],"description":"Date the user account was created"}},{"field":{"name":"status_user","datatype":"Boolean","required":true,"alias":"status","multivalued":false,"indices":["Textual","Ordenado"],"description":"Check if the user is activer or not"}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase's Users Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":5,"name":"app_user","owner":"","password":"","txt_mapping":"","model":{"bases":["Integer"],"creation_date_user":"Date","email_user":"Text","forms":["Integer"],"id_user":"Text","name_user":"Text","passwd_user":"Text","reports":["Text"],"status_user":"Boolean","shortcuts":[{"id":"Integer","type":"Text"}]}}}	2017-01-01 00:00:00	f		0	f	0	
2	_history	{"content":[{"field":{"alias":"id_base","description":"Base old ID.","name":"id_base","datatype":"Integer","indices":["Textual"],"required":true,"multivalued":false}},{"field":{"alias":"author","description":"Event Author.","name":"author","datatype":"Text","indices":["Textual"],"required":true,"multivalued":false}},{"field":{"alias":"date","description":"Event Date.","name":"date","datatype":"DateTime","indices":["Textual"],"required":true,"multivalued":false}},{"field":{"alias":"name","description":"Base old name.","name":"name","datatype":"Text","indices":["Textual"],"required":true,"multivalued":false}},{"field":{"alias":"structure","description":"Base old structure","name":"structure","datatype":"Json","indices":["Textual"],"required":true,"multivalued":false}},{"field":{"alias":"status","description":"Base status","name":"status","datatype":"Text","indices":["Textual"],"required":true,"multivalued":false}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase - History Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":2,"name":"_history","owner":"","password":"","txt_mapping":"","model":{"author":"Text","date":"DateTime","id_base":"Integer","name":"Text","status":"Text","structure":"Json"}}}	2017-01-01 00:00:00	f		0	f	0	
1	_form	{"content":[{"field":{"name":"id_base","datatype":"Integer","required":true,"alias":"id_base","multivalued":false,"indices":["Textual"],"description":"Base ID."}},{"field":{"name":"author","datatype":"Text","required":true,"alias":"author","multivalued":false,"indices":["Textual"],"description":"Event Author."}},{"field":{"name":"name","datatype":"Text","required":true,"alias":"name","multivalued":false,"indices":["Textual"],"description":"Form name."}},{"field":{"name":"description","datatype":"Text","required":true,"alias":"description","multivalued":false,"indices":["Textual"],"description":"Form description."}},{"field":{"name":"structure","datatype":"Json","required":true,"alias":"structure","multivalued":false,"indices":["Textual"],"description":"Form structure"}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase's Form Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":1,"name":"_form","owner":"","password":"","txt_mapping":"","model":{"author":"Text","description":"Text","id_base":"Integer","name":"Text","structure":"Json"}}}	2017-01-01 00:00:00	f		0	f	0	
3	_report	{"content":[{"field":{"name":"id_base","datatype":"Integer","required":true,"alias":"id_base","multivalued":false,"indices":["Textual"],"description":"Base ID."}},{"field":{"name":"author","datatype":"Text","required":true,"alias":"author","multivalued":false,"indices":["Textual"],"description":"Event Author."}},{"field":{"name":"name","datatype":"Text","required":true,"alias":"name","multivalued":false,"indices":["Textual"],"description":"Report name."}},{"field":{"name":"description","datatype":"Text","required":true,"alias":"description","multivalued":false,"indices":["Textual"],"description":"Report description."}},{"field":{"name":"structure","datatype":"Json","required":true,"alias":"structure","multivalued":false,"indices":["Textual"],"description":"Report structure"}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase's Report Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":3,"name":"_report","owner":"","password":"","txt_mapping":"","model":{"author":"Text","description":"Text","id_base":"Integer","name":"Text","structure":"Json"}}}	2017-01-01 00:00:00	f		0	f	0	
7	log_lbindex	{"content":[{"field":{"alias":"Nome da base","description":"Nome da base","name":"nm_base","datatype":"Text","indices":["Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"identificador do documento","description":"id do documento que originou o erro.","name":"id_doc_orig","datatype":"Integer","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"Mensagem de erro","description":"Mensagem de erro","name":"error_msg","datatype":"Text","indices":["Nenhum"],"required":true,"multivalued":false}},{"field":{"alias":"Data do erro","description":"Data e Hora no formato DD/MM/AAAA - HH:MM:SS do erro","name":"dt_error","datatype":"DateTime","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"dt_last_up_orig","description":"Data e Hora no formato DD/MM/AAAA - HH:MM:SS da última atualização do registro que originou o erro.","name":"dt_last_up_orig","datatype":"DateTime","indices":["Textual","Ordenado"],"required":true,"multivalued":false}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase - Log de erros do LBIndex","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":7,"name":"log_lbindex","owner":"","password":"","model":{"dt_error":"DateTime","dt_last_up_orig":"DateTime","error_msg":"Text","id_doc_orig":"Integer","nm_base":"Text"}}}	2017-01-01 00:00:00	f		0	f	0	
6	log_lbconverter	{"content":[{"field":{"name":"nm_base","datatype":"Text","required":true,"alias":"Nome da base","multivalued":false,"indices":["Ordenado"],"description":"Nome da base"}},{"field":{"name":"id_doc_orig","datatype":"Integer","required":true,"alias":"id_doc_orig","multivalued":false,"indices":["Textual","Ordenado"],"description":"id do documento que originou o erro."}},{"field":{"name":"id_file_orig","datatype":"Text","required":true,"alias":"id_file_orig","multivalued":false,"indices":["Textual"],"description":"ID do arquivo que originou o erro."}},{"field":{"name":"file_name","datatype":"Text","required":true,"alias":"file_name","multivalued":false,"indices":["Ordenado"],"description":"File name"}},{"field":{"name":"error_msg","datatype":"Text","required":true,"alias":"Mensagem de erro","multivalued":false,"indices":["Nenhum"],"description":"Mensagem de erro"}},{"field":{"name":"dt_error","datatype":"DateTime","required":true,"alias":"Data do erro","multivalued":false,"indices":["Textual","Ordenado"],"description":"Data do erro"}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase - Log de erros do LBConverter","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":6,"name":"log_lbconverter","owner":"","password":"","txt_mapping":"","model":{"dt_error":"DateTime","error_msg":"Text","file_name":"Text","id_doc_orig":"Integer","id_file_orig":"Text","nm_base":"Text"}}}	2017-01-01 00:00:00	f		0	f	0	
\.


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

SELECT pg_catalog.setval('lb_base_id_base_seq', 7, true);


--
-- Data for Name: lb_doc__form; Type: TABLE DATA; Schema: public; Owner: lbu
--

COPY lb_doc__form (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx) FROM stdin;
\.


--
-- Name: lb_doc__form_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: lbu
--

SELECT pg_catalog.setval('lb_doc__form_id_doc_seq', 1, false);


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

COPY lb_doc__history (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx) FROM stdin;
\.


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

SELECT pg_catalog.setval('lb_doc__history_id_doc_seq', 1134, true);


--
-- Data for Name: lb_doc__report; Type: TABLE DATA; Schema: public; Owner: lbu
--

COPY lb_doc__report (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx) FROM stdin;
\.


--
-- Name: lb_doc__report_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: lbu
--

SELECT pg_catalog.setval('lb_doc__report_id_doc_seq', 1, false);


--
-- Data for Name: lb_doc__search; Type: TABLE DATA; Schema: public; Owner: lbu
--

COPY lb_doc__search (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx) FROM stdin;
\.


--
-- Name: lb_doc__search_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: lbu
--

SELECT pg_catalog.setval('lb_doc__search_id_doc_seq', 1, false);


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

COPY lb_doc__user (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx, name_base, id_user, status_user, access_type, name_user, creation_date_user, email_user, passwd_user) FROM stdin;
\.


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

SELECT pg_catalog.setval('lb_doc__user_id_doc_seq', 1, true);


--
-- Data for Name: lb_doc_app_user; Type: TABLE DATA; Schema: public; Owner: lbu
--

COPY lb_doc_app_user (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx, id_user, status_user, name_user, creation_date_user, email_user, passwd_user) FROM stdin;
\.


--
-- Name: lb_doc_app_user_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: lbu
--

SELECT pg_catalog.setval('lb_doc_app_user_id_doc_seq', 1, false);


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

COPY lb_doc_log_lbconverter (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx, file_name, id_doc_orig, nm_base, dt_error) FROM stdin;
\.


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

SELECT pg_catalog.setval('lb_doc_log_lbconverter_id_doc_seq', 481444, true);


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

COPY lb_doc_log_lbindex (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx, id_doc_orig, dt_last_up_orig, nm_base, dt_error) FROM stdin;
\.


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

SELECT pg_catalog.setval('lb_doc_log_lbindex_id_doc_seq', 620125, true);


--
-- Data for Name: lb_file__form; Type: TABLE DATA; Schema: public; Owner: lbu
--

COPY lb_file__form (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


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

COPY lb_file__history (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file__report; Type: TABLE DATA; Schema: public; Owner: lbu
--

COPY lb_file__report (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file__search; Type: TABLE DATA; Schema: public; Owner: lbu
--

COPY lb_file__search (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


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

COPY lb_file__user (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file_app_user; Type: TABLE DATA; Schema: public; Owner: lbu
--

COPY lb_file_app_user (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


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

COPY lb_file_log_lbconverter (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


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

COPY lb_file_log_lbindex (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


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

COPY lb_index_error (id_error, base, id_doc, dt_error, msg_error) FROM stdin;
\.


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

SELECT pg_catalog.setval('lb_index_error_seq', 3699, true);


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

COPY lb_txt_idx (id_idx, nm_idx, cfg_idx, dt_crt_idx, dt_upt_idx, url_idx, actv_idx, struct) FROM stdin;
\.


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

SELECT pg_catalog.setval('lb_txt_idx_id_idx_seq', 1, false);


--
-- Name: lb_base_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_base
    ADD CONSTRAINT lb_base_name_key UNIQUE (name);


--
-- Name: lb_base_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_base
    ADD CONSTRAINT lb_base_pkey PRIMARY KEY (id_base);


--
-- Name: lb_doc__form_pkey; Type: CONSTRAINT; Schema: public; Owner: lbu; Tablespace: 
--

ALTER TABLE ONLY lb_doc__form
    ADD CONSTRAINT lb_doc__form_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc__history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc__history
    ADD CONSTRAINT lb_doc__history_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc__report_pkey; Type: CONSTRAINT; Schema: public; Owner: lbu; Tablespace: 
--

ALTER TABLE ONLY lb_doc__report
    ADD CONSTRAINT lb_doc__report_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc__search_pkey; Type: CONSTRAINT; Schema: public; Owner: lbu; Tablespace: 
--

ALTER TABLE ONLY lb_doc__search
    ADD CONSTRAINT lb_doc__search_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc__user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc__user
    ADD CONSTRAINT lb_doc__user_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc_app_user_pkey; Type: CONSTRAINT; Schema: public; Owner: lbu; Tablespace: 
--

ALTER TABLE ONLY lb_doc_app_user
    ADD CONSTRAINT lb_doc_app_user_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc_log_lbconverter_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc_log_lbconverter
    ADD CONSTRAINT lb_doc_log_lbconverter_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc_log_lbindex_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc_log_lbindex
    ADD CONSTRAINT lb_doc_log_lbindex_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_file__form_pkey; Type: CONSTRAINT; Schema: public; Owner: lbu; Tablespace: 
--

ALTER TABLE ONLY lb_file__form
    ADD CONSTRAINT lb_file__form_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file__history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file__history
    ADD CONSTRAINT lb_file__history_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file__report_pkey; Type: CONSTRAINT; Schema: public; Owner: lbu; Tablespace: 
--

ALTER TABLE ONLY lb_file__report
    ADD CONSTRAINT lb_file__report_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file__search_pkey; Type: CONSTRAINT; Schema: public; Owner: lbu; Tablespace: 
--

ALTER TABLE ONLY lb_file__search
    ADD CONSTRAINT lb_file__search_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file__user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file__user
    ADD CONSTRAINT lb_file__user_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file_app_user_pkey; Type: CONSTRAINT; Schema: public; Owner: lbu; Tablespace: 
--

ALTER TABLE ONLY lb_file_app_user
    ADD CONSTRAINT lb_file_app_user_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file_log_lbconverter_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file_log_lbconverter
    ADD CONSTRAINT lb_file_log_lbconverter_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file_log_lbindex_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file_log_lbindex
    ADD CONSTRAINT lb_file_log_lbindex_pkey PRIMARY KEY (id_file);


--
-- Name: lb_index_error_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_index_error
    ADD CONSTRAINT lb_index_error_pkey PRIMARY KEY (id_error);


--
-- Name: lb_txt_idx_nm_idx_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_txt_idx
    ADD CONSTRAINT lb_txt_idx_nm_idx_key UNIQUE (nm_idx);


--
-- Name: lb_txt_idx_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_txt_idx
    ADD CONSTRAINT lb_txt_idx_pkey PRIMARY KEY (id_idx);


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

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--