· 9 years ago · May 02, 2017, 02:36 PM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.4.4
6-- Dumped by pg_dump version 9.4.4
7-- Started on 2017-05-02 11:30:00
8
9SET statement_timeout = 0;
10SET lock_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SET check_function_bodies = false;
14SET client_min_messages = warning;
15
16--
17-- TOC entry 181 (class 3079 OID 11855)
18-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
19--
20
21CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
22
23
24--
25-- TOC entry 2070 (class 0 OID 0)
26-- Dependencies: 181
27-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
28--
29
30COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
31
32
33SET search_path = public, pg_catalog;
34
35SET default_tablespace = '';
36
37SET default_with_oids = false;
38
39--
40-- TOC entry 172 (class 1259 OID 73130)
41-- Name: aplicacion; Type: TABLE; Schema: public; Owner: fermin; Tablespace:
42--
43
44CREATE TABLE aplicacion (
45 id_aplicacion integer NOT NULL,
46 cd_usuario_actual character varying(255),
47 cd_usuario_alta character varying(255),
48 dt_actual timestamp without time zone,
49 dt_alta timestamp without time zone,
50 ds_nombre character varying(255)
51);
52
53
54ALTER TABLE aplicacion OWNER TO fermin;
55
56--
57-- TOC entry 173 (class 1259 OID 73138)
58-- Name: authorities; Type: TABLE; Schema: public; Owner: fermin; Tablespace:
59--
60
61CREATE TABLE authorities (
62 id bigint NOT NULL,
63 authority character varying(255),
64 username character varying(255)
65);
66
67
68ALTER TABLE authorities OWNER TO fermin;
69
70--
71-- TOC entry 174 (class 1259 OID 73146)
72-- Name: edicionpassword; Type: TABLE; Schema: public; Owner: fermin; Tablespace:
73--
74
75CREATE TABLE edicionpassword (
76 id bigint NOT NULL,
77 cd_usuario_actual character varying(255),
78 cd_usuario_alta character varying(255),
79 dt_actual timestamp without time zone,
80 dt_alta timestamp without time zone,
81 ds_username character varying(255)
82);
83
84
85ALTER TABLE edicionpassword OWNER TO fermin;
86
87--
88-- TOC entry 175 (class 1259 OID 73154)
89-- Name: evento; Type: TABLE; Schema: public; Owner: fermin; Tablespace:
90--
91
92CREATE TABLE evento (
93 dtype character varying(31) NOT NULL,
94 id_evento integer NOT NULL,
95 cd_usuario_actual character varying(255),
96 cd_usuario_alta character varying(255),
97 dt_actual timestamp without time zone,
98 dt_alta timestamp without time zone,
99 ds_descripcion character varying(255),
100 dt_fecha timestamp without time zone,
101 nm_autor character varying(255),
102 ds_aplicacion character varying(255),
103 id_rol bigint
104);
105
106
107ALTER TABLE evento OWNER TO fermin;
108
109--
110-- TOC entry 180 (class 1259 OID 73210)
111-- Name: hibernate_sequence; Type: SEQUENCE; Schema: public; Owner: fermin
112--
113
114CREATE SEQUENCE hibernate_sequence
115 START WITH 1
116 INCREMENT BY 1
117 NO MINVALUE
118 NO MAXVALUE
119 CACHE 1;
120
121
122ALTER TABLE hibernate_sequence OWNER TO fermin;
123
124--
125-- TOC entry 176 (class 1259 OID 73162)
126-- Name: permiso; Type: TABLE; Schema: public; Owner: fermin; Tablespace:
127--
128
129CREATE TABLE permiso (
130 id bigint NOT NULL,
131 cd_usuario_actual character varying(255),
132 cd_usuario_alta character varying(255),
133 dt_actual timestamp without time zone,
134 dt_alta timestamp without time zone,
135 ds_accion character varying(255),
136 ds_pantalla character varying(255),
137 ds_roles character varying(255),
138 id_aplicacion integer
139);
140
141
142ALTER TABLE permiso OWNER TO fermin;
143
144--
145-- TOC entry 177 (class 1259 OID 73170)
146-- Name: personaips; Type: TABLE; Schema: public; Owner: fermin; Tablespace:
147--
148
149CREATE TABLE personaips (
150 id_persona_ips integer NOT NULL,
151 cd_usuario_actual character varying(255),
152 cd_usuario_alta character varying(255),
153 dt_actual timestamp without time zone,
154 dt_alta timestamp without time zone,
155 ds_mail character varying(255),
156 nm_usuario character varying(255)
157);
158
159
160ALTER TABLE personaips OWNER TO fermin;
161
162--
163-- TOC entry 178 (class 1259 OID 73178)
164-- Name: rol; Type: TABLE; Schema: public; Owner: fermin; Tablespace:
165--
166
167CREATE TABLE rol (
168 id bigint NOT NULL,
169 cd_usuario_actual character varying(255),
170 cd_usuario_alta character varying(255),
171 dt_actual timestamp without time zone,
172 dt_alta timestamp without time zone,
173 ds_nombre character varying(255),
174 dt_fecha_baja timestamp without time zone,
175 dt_fecha_creacion timestamp without time zone
176);
177
178
179ALTER TABLE rol OWNER TO fermin;
180
181--
182-- TOC entry 179 (class 1259 OID 73186)
183-- Name: users; Type: TABLE; Schema: public; Owner: fermin; Tablespace:
184--
185
186CREATE TABLE users (
187 id bigint NOT NULL,
188 enabled integer NOT NULL,
189 password character varying(255),
190 username character varying(255)
191);
192
193
194ALTER TABLE users OWNER TO fermin;
195
196--
197-- TOC entry 2054 (class 0 OID 73130)
198-- Dependencies: 172
199-- Data for Name: aplicacion; Type: TABLE DATA; Schema: public; Owner: fermin
200--
201
202COPY aplicacion (id_aplicacion, cd_usuario_actual, cd_usuario_alta, dt_actual, dt_alta, ds_nombre) FROM stdin;
2037 \N \N \N \N Rupa
2048 \N \N \N \N Todas
20516 \N \N \N \N WebDeudas
20691 \N \N \N \N CapacitaIPS
207\.
208
209
210--
211-- TOC entry 2055 (class 0 OID 73138)
212-- Dependencies: 173
213-- Data for Name: authorities; Type: TABLE DATA; Schema: public; Owner: fermin
214--
215
216COPY authorities (id, authority, username) FROM stdin;
2172 ROLE_USER ips
2184 ROLE_SUPER_ADMIN super
21976 ROLE_TIERI tieri
22078 ROLE_REGISTRO registro
22180 ROLE_USER beatriz
22282 ROLE_USER betiana
22384 ROLE_USER pablo
22494 ROLE_ADOLFO_GONZALES_CHAVES adolfo_gonzales_chaves
22598 ROLE_ALMIRANTE_BROWN almirante_brown
226102 ROLE_AZUL azul
227106 ROLE_BAHIA_BLANCA bahia_blanca
228110 ROLE_BALCARCE balcarce
229114 ROLE_BARADERO baradero
230118 ROLE_BENITO_JUAREZ benito_juarez
231122 ROLE_BOLIVAR bolivar
232126 ROLE_BRANDSEN brandsen
233130 ROLE_CABA caba
234134 ROLE_CABA_(CASA_DE_LA_PROVINCIA) caba_(casa_de_la_provincia)
235138 ROLE_CAPITAN_SARMIENTO capitan_sarmiento
236142 ROLE_CARLOS_CASARES carlos_casares
237146 ROLE_CASTELLI castelli
238150 ROLE_CARMEN_DE_PATAGONES carmen_de_patagones
239154 ROLE_CHACABUCO chacabuco
240158 ROLE_CHASCOMUS chascomus
241162 ROLE_CHIVILCOY chivilcoy
242166 ROLE_CORONEL_DORREGO coronel_dorrego
243170 ROLE_CORONEL_PRINGLES coronel_pringles
244174 ROLE_CORONEL_ROSALES coronel_rosales
245178 ROLE_DAIREAUX daireaux
246182 ROLE_DOLORES dolores
247186 ROLE_FLORENCIO_VARELA florencio_varela
248190 ROLE_GENERAL_ALVARADO general_alvarado
249194 ROLE_GENERAL_ALVEAR general_alvear
250198 ROLE_GENERAL_ARENALES general_arenales
251202 ROLE_GENERAL_BELGRANO general_belgrano
252206 ROLE_GENERAL_CONESA general_conesa
253210 ROLE_GENERAL_LA_MADRID general_la_madrid
254214 ROLE_GENERAL_LAVALLE general_lavalle
255218 ROLE_GENERAL_MADARIAGA general_madariaga
256222 ROLE_GENERAL_PAZ general_paz
257226 ROLE_GENERAL_PUEYRREDON_-1- general_pueyrredon_-1-
258230 ROLE_GENERAL_PUEYRREDON_-2- general_pueyrredon_-2-
259234 ROLE_GENERAL_RODRIGUEZ general_rodriguez
260238 ROLE_GUAMINI guamini
261242 ROLE_HIPOLITO_YRIGOYEN hipolito_yrigoyen
262246 ROLE_LA_MATANZA la_matanza
263250 ROLE_LAPRIDA laprida
264254 ROLE_LEZAMA lezama
265258 ROLE_LINCOLN lincoln
266262 ROLE_LOBOS lobos
267266 ROLE_LOMAS_DE_ZAMORA lomas_de_zamora
268270 ROLE_MAGDALENA magdalena
269274 ROLE_MAIPU maipu
270278 ROLE_MARCOS_PAZ marcos_paz
271282 ROLE_MERCEDES mercedes
272286 ROLE_MONTE_HERMOSO monte_hermoso
273290 ROLE_MORENO moreno
274294 ROLE_NECOCHEA necochea
275298 ROLE_9_DE_JULIO 9_de_julio
276302 ROLE_OLAVARRIA olavarria
277306 ROLE_PARTIDO_DE_LA_COSTA_(MAR_DEL_TUYU) partido_de_la_costa_(mar_del_tuyu)
278310 ROLE_PEHUAJO pehuajo
279314 ROLE_PELLEGRINI pellegrini
280318 ROLE_PINAMAR pinamar
281322 ROLE_PUNTA_INDIO punta_indio
282326 ROLE_SAAVEDRA saavedra
283330 ROLE_ROJAS rojas
284334 ROLE_ROQUE_PEREZ roque_perez
285338 ROLE_SALADILLO saladillo
286342 ROLE_SALIQUELLO saliquello
287346 ROLE_SALTO salto
288350 ROLE_SAN_ANTONIO_DE_ARECO san_antonio_de_areco
289354 ROLE_SAN_CAYETANO san_cayetano
290358 ROLE_SAN_MIGUEL san_miguel
291362 ROLE_SAN_MIGUEL_DEL_MONTE san_miguel_del_monte
292366 ROLE_SAN_NICOLAS san_nicolas
293370 ROLE_TANDIL tandil
294374 ROLE_TAPALQUE tapalque
295378 ROLE_TIGRE tigre
296382 ROLE_TRENQUE_LAUQUEN trenque_lauquen
297386 ROLE_TRES_ARROYOS tres_arroyos
298390 ROLE_TRES_DE_FEBRERO tres_de_febrero
299394 ROLE_TRES_LOMAS tres_lomas
300398 ROLE_VILLA_GESELL villa_gesell
301402 ROLE_VILLARINO villarino
302491 ROLE_CAP cap
303493 ROLE_SUPER_ADMIN_CAPACITA amarquez
304\.
305
306
307--
308-- TOC entry 2056 (class 0 OID 73146)
309-- Dependencies: 174
310-- Data for Name: edicionpassword; Type: TABLE DATA; Schema: public; Owner: fermin
311--
312
313COPY edicionpassword (id, cd_usuario_actual, cd_usuario_alta, dt_actual, dt_alta, ds_username) FROM stdin;
31411 \N \N \N \N beatriz
31512 \N \N \N \N betiana
316\.
317
318
319--
320-- TOC entry 2057 (class 0 OID 73154)
321-- Dependencies: 175
322-- Data for Name: evento; Type: TABLE DATA; Schema: public; Owner: fermin
323--
324
325COPY evento (dtype, id_evento, cd_usuario_actual, cd_usuario_alta, dt_actual, dt_alta, ds_descripcion, dt_fecha, nm_autor, ds_aplicacion, id_rol) FROM stdin;
326EventoRol 48 \N \N \N \N El Rol TIERI ahora posee permisos para Flujo Manual, accion='Todo' 2016-04-14 12:08:39.663 Generacion Automatica WebDeudas 14
327EventoRol 49 \N \N \N \N El Rol TIERI ahora posee permisos para Flujo Masiva, accion='Todo' 2016-04-14 12:08:39.666 Generacion Automatica WebDeudas 14
328EventoRol 50 \N \N \N \N El Rol TIERI ahora posee permisos para Estadisticas, accion='Todo' 2016-04-14 12:08:39.676 Generacion Automatica WebDeudas 14
329EventoRol 51 \N \N \N \N El Rol TIERI ahora posee permisos para Eventos, accion='Todo' 2016-04-14 12:08:39.681 Generacion Automatica WebDeudas 14
330EventoRol 52 \N \N \N \N El Rol TIERI ahora posee permisos para Listado Deudores, accion='Todo' 2016-04-14 12:08:39.688 Generacion Automatica WebDeudas 14
331EventoRol 53 \N \N \N \N El Rol TIERI ahora posee permisos para Listado Planes, accion='Todo' 2016-04-14 12:08:39.693 Generacion Automatica WebDeudas 14
332EventoRol 54 \N \N \N \N El Rol TIERI ahora posee permisos para Validar Deudas, accion='Todo' 2016-04-14 12:08:39.699 Generacion Automatica WebDeudas 14
333EventoRol 55 \N \N \N \N El Rol TIERI ahora posee permisos para Desestimar Deudas, accion='Todo' 2016-04-14 12:08:39.703 Generacion Automatica WebDeudas 14
334EventoRol 56 \N \N \N \N El Rol TIERI ahora posee permisos para Recuperar Deudas de Titulos Ejecutivos, accion='Todo' 2016-04-14 12:08:39.708 Generacion Automatica WebDeudas 14
335EventoRol 57 \N \N \N \N El Rol TIERI ahora posee permisos para ver Instancias de Titulos en Recuperacion, accion='Todo' 2016-04-14 12:08:39.713 Generacion Automatica WebDeudas 14
336EventoRol 58 \N \N \N \N El Rol TIERI ahora posee permisos para Deudas Desestimadas, accion='Todo' 2016-04-14 12:08:39.716 Generacion Automatica WebDeudas 14
337EventoRol 59 \N \N \N \N El Rol TIERI ahora posee permisos para Deudas Erroneas, accion='Todo' 2016-04-14 12:08:39.72 Generacion Automatica WebDeudas 14
338EventoRol 60 \N \N \N \N El Rol TIERI ahora posee permisos para Listado Presuntas, accion='Todo' 2016-04-14 12:08:39.724 Generacion Automatica WebDeudas 14
339EventoRol 61 \N \N \N \N El Rol TIERI ahora posee permisos para Listado Presuntas Invalidadas, accion='Todo' 2016-04-14 12:08:39.756 Generacion Automatica WebDeudas 14
340EventoRol 62 \N \N \N \N El Rol REGISTRO ahora posee permisos para Flujo Registro, accion='Todo' 2016-04-14 12:08:39.671 Generacion Automatica WebDeudas 15
341EventoRol 63 \N \N \N \N El Rol REGISTRO ahora posee permisos para Estadisticas, accion='Todo' 2016-04-14 12:08:39.676 Generacion Automatica WebDeudas 15
342EventoRol 64 \N \N \N \N El Rol REGISTRO ahora posee permisos para Eventos, accion='Todo' 2016-04-14 12:08:39.681 Generacion Automatica WebDeudas 15
343EventoRol 65 \N \N \N \N El Rol REGISTRO ahora posee permisos para Listado Deudores, accion='Todo' 2016-04-14 12:08:39.688 Generacion Automatica WebDeudas 15
344EventoRol 66 \N \N \N \N El Rol REGISTRO ahora posee permisos para Listado Planes, accion='Todo' 2016-04-14 12:08:39.693 Generacion Automatica WebDeudas 15
345EventoRol 67 \N \N \N \N El Rol REGISTRO ahora posee permisos para Validar Deudas, accion='Todo' 2016-04-14 12:08:39.699 Generacion Automatica WebDeudas 15
346EventoRol 68 \N \N \N \N El Rol REGISTRO ahora posee permisos para Desestimar Deudas, accion='Todo' 2016-04-14 12:08:39.703 Generacion Automatica WebDeudas 15
347EventoRol 69 \N \N \N \N El Rol REGISTRO ahora posee permisos para Recuperar Deudas de Titulos Ejecutivos, accion='Todo' 2016-04-14 12:08:39.708 Generacion Automatica WebDeudas 15
348EventoRol 70 \N \N \N \N El Rol REGISTRO ahora posee permisos para ver Instancias de Titulos en Recuperacion, accion='Todo' 2016-04-14 12:08:39.713 Generacion Automatica WebDeudas 15
349EventoRol 71 \N \N \N \N El Rol REGISTRO ahora posee permisos para Deudas Desestimadas, accion='Todo' 2016-04-14 12:08:39.716 Generacion Automatica WebDeudas 15
350EventoRol 72 \N \N \N \N El Rol REGISTRO ahora posee permisos para Deudas Erroneas, accion='Todo' 2016-04-14 12:08:39.72 Generacion Automatica WebDeudas 15
351EventoRol 73 \N \N \N \N El Rol REGISTRO ahora posee permisos para Listado Presuntas, accion='Todo' 2016-04-14 12:08:39.724 Generacion Automatica WebDeudas 15
352EventoRol 74 \N \N \N \N El Rol REGISTRO ahora posee permisos para Listado Presuntas Invalidadas, accion='Todo' 2016-04-14 12:08:39.756 Generacion Automatica WebDeudas 15
353EventoRol 407 \N \N \N \N Creacion del Rol ROLE_SUPER_ADMIN_CAPACITA 2016-04-14 12:08:40.056 Generacion Automatica CapacitaIPS 92
354EventoRol 408 \N \N \N \N El Rol SUPER_ADMIN_CAPACITA ahora posee permisos para Datos Cap, accion='Todo' 2016-04-14 12:08:42.546 Generacion Automatica CapacitaIPS 92
355EventoRol 409 \N \N \N \N El Rol SUPER_ADMIN_CAPACITA ahora posee permisos para Administracion, accion='Todo' 2016-04-14 12:08:42.548 Generacion Automatica CapacitaIPS 92
356EventoRol 410 \N \N \N \N El Rol CAP ahora posee permisos para Datos Cap, accion='Todo' 2016-04-14 12:08:42.545 Generacion Automatica CapacitaIPS 90
357EventoRol 494 \N \N \N \N Creacion del Rol ROLE_SUPER_ADMIN 2016-04-14 12:08:39.429 Generacion Automatica Todas 10
358EventoRol 495 \N \N \N \N El usuario super ahora posee el Rol ROLE_SUPER_ADMIN 2016-04-14 12:08:39.429 Generacion Automatica Todas 10
359EventoRol 496 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Descargar Documentacion Tecnologia, accion='Todo' 2016-04-14 12:08:39.65 Generacion Automatica WebDeudas 10
360EventoRol 497 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Configuracion Permisos, accion='Todo' 2016-04-14 12:08:39.657 Generacion Automatica WebDeudas 10
361EventoRol 498 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Flujo Manual, accion='Todo' 2016-04-14 12:08:39.663 Generacion Automatica WebDeudas 10
362EventoRol 499 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Flujo Masiva, accion='Todo' 2016-04-14 12:08:39.666 Generacion Automatica WebDeudas 10
363EventoRol 500 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Flujo Registro, accion='Todo' 2016-04-14 12:08:39.671 Generacion Automatica WebDeudas 10
364EventoRol 501 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Estadisticas, accion='Todo' 2016-04-14 12:08:39.676 Generacion Automatica WebDeudas 10
365EventoRol 502 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Eventos, accion='Todo' 2016-04-14 12:08:39.681 Generacion Automatica WebDeudas 10
366EventoRol 503 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Listado Deudores, accion='Todo' 2016-04-14 12:08:39.688 Generacion Automatica WebDeudas 10
367EventoRol 504 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Listado Planes, accion='Todo' 2016-04-14 12:08:39.693 Generacion Automatica WebDeudas 10
368EventoRol 505 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Validar Deudas, accion='Todo' 2016-04-14 12:08:39.699 Generacion Automatica WebDeudas 10
369EventoRol 506 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Desestimar Deudas, accion='Todo' 2016-04-14 12:08:39.703 Generacion Automatica WebDeudas 10
370EventoRol 507 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Recuperar Deudas de Titulos Ejecutivos, accion='Todo' 2016-04-14 12:08:39.708 Generacion Automatica WebDeudas 10
371EventoRol 508 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para ver Instancias de Titulos en Recuperacion, accion='Todo' 2016-04-14 12:08:39.713 Generacion Automatica WebDeudas 10
372EventoRol 509 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Deudas Desestimadas, accion='Todo' 2016-04-14 12:08:39.716 Generacion Automatica WebDeudas 10
373EventoRol 510 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Deudas Erroneas, accion='Todo' 2016-04-14 12:08:39.72 Generacion Automatica WebDeudas 10
374EventoRol 511 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Listado Presuntas, accion='Todo' 2016-04-14 12:08:39.724 Generacion Automatica WebDeudas 10
375EventoRol 512 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Listado Presuntas Invalidadas, accion='Todo' 2016-04-14 12:08:39.756 Generacion Automatica WebDeudas 10
376EventoRol 513 \N \N \N \N El usuario amarquez ahora posee el Rol ROLE_SUPER_ADMIN_CAPACITA 2016-04-14 12:08:40.056 Generacion Automatica CapacitaIPS 92
377EventoRol 514 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Datos Cap, accion='Todo' 2016-04-14 12:08:42.546 Generacion Automatica CapacitaIPS 10
378EventoRol 515 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Administracion, accion='Todo' 2016-04-14 12:08:42.548 Generacion Automatica CapacitaIPS 10
379EventoRol 516 \N \N \N \N Creacion del Rol ROLE_USER 2016-04-14 12:08:39.415 Generacion Automatica Todas 9
380EventoRol 517 \N \N \N \N El usuario ips ahora posee el Rol ROLE_USER 2016-04-14 12:08:39.415 Generacion Automatica Todas 9
381EventoRol 518 \N \N \N \N El Rol USER ahora posee permisos para Descargar Documentacion Tecnologia, accion='Todo' 2016-04-14 12:08:39.65 Generacion Automatica WebDeudas 9
382EventoRol 519 \N \N \N \N El Rol USER ahora posee permisos para Flujo Manual, accion='Todo' 2016-04-14 12:08:39.663 Generacion Automatica WebDeudas 9
383EventoRol 520 \N \N \N \N El Rol USER ahora posee permisos para Flujo Masiva, accion='Todo' 2016-04-14 12:08:39.666 Generacion Automatica WebDeudas 9
384EventoRol 521 \N \N \N \N El Rol USER ahora posee permisos para Flujo Registro, accion='Todo' 2016-04-14 12:08:39.671 Generacion Automatica WebDeudas 9
385EventoRol 522 \N \N \N \N El Rol USER ahora posee permisos para Estadisticas, accion='Todo' 2016-04-14 12:08:39.676 Generacion Automatica WebDeudas 9
386EventoRol 523 \N \N \N \N El Rol USER ahora posee permisos para Eventos, accion='Todo' 2016-04-14 12:08:39.681 Generacion Automatica WebDeudas 9
387EventoRol 524 \N \N \N \N El Rol USER ahora posee permisos para Listado Deudores, accion='Todo' 2016-04-14 12:08:39.688 Generacion Automatica WebDeudas 9
388EventoRol 525 \N \N \N \N El Rol USER ahora posee permisos para Listado Planes, accion='Todo' 2016-04-14 12:08:39.693 Generacion Automatica WebDeudas 9
389EventoRol 526 \N \N \N \N El Rol USER ahora posee permisos para Validar Deudas, accion='Todo' 2016-04-14 12:08:39.699 Generacion Automatica WebDeudas 9
390EventoRol 527 \N \N \N \N El Rol USER ahora posee permisos para Desestimar Deudas, accion='Todo' 2016-04-14 12:08:39.703 Generacion Automatica WebDeudas 9
391EventoRol 528 \N \N \N \N El Rol USER ahora posee permisos para Recuperar Deudas de Titulos Ejecutivos, accion='Todo' 2016-04-14 12:08:39.708 Generacion Automatica WebDeudas 9
392EventoRol 529 \N \N \N \N El Rol USER ahora posee permisos para ver Instancias de Titulos en Recuperacion, accion='Todo' 2016-04-14 12:08:39.713 Generacion Automatica WebDeudas 9
393EventoRol 530 \N \N \N \N El Rol USER ahora posee permisos para Deudas Desestimadas, accion='Todo' 2016-04-14 12:08:39.716 Generacion Automatica WebDeudas 9
394EventoRol 531 \N \N \N \N El Rol USER ahora posee permisos para Deudas Erroneas, accion='Todo' 2016-04-14 12:08:39.72 Generacion Automatica WebDeudas 9
395EventoRol 532 \N \N \N \N El Rol USER ahora posee permisos para Listado Presuntas, accion='Todo' 2016-04-14 12:08:39.724 Generacion Automatica WebDeudas 9
396EventoRol 533 \N \N \N \N El Rol USER ahora posee permisos para Listado Presuntas Invalidadas, accion='Todo' 2016-04-14 12:08:39.756 Generacion Automatica WebDeudas 9
397EventoRol 535 \N \N \N \N El Rol USER ahora posee permisos para Listado Descuentos, accion='Todo' 2016-07-26 08:28:07.501 Generacion Automatica WebDeudas 9
398EventoRol 536 \N \N \N \N El Rol SUPER_ADMIN ahora posee permisos para Listado Descuentos, accion='Todo' 2016-07-26 08:28:07.598 Generacion Automatica WebDeudas 10
399EventoRol 537 \N \N \N \N El Rol TIERI ahora posee permisos para Listado Descuentos, accion='Todo' 2016-07-26 08:28:07.643 Generacion Automatica WebDeudas 14
400EventoRol 538 \N \N \N \N El Rol REGISTRO ahora posee permisos para Listado Descuentos, accion='Todo' 2016-07-26 08:28:07.662 Generacion Automatica WebDeudas 15
401\.
402
403
404--
405-- TOC entry 2071 (class 0 OID 0)
406-- Dependencies: 180
407-- Name: hibernate_sequence; Type: SEQUENCE SET; Schema: public; Owner: fermin
408--
409
410SELECT pg_catalog.setval('hibernate_sequence', 538, true);
411
412
413--
414-- TOC entry 2058 (class 0 OID 73162)
415-- Dependencies: 176
416-- Data for Name: permiso; Type: TABLE DATA; Schema: public; Owner: fermin
417--
418
419COPY permiso (id, cd_usuario_actual, cd_usuario_alta, dt_actual, dt_alta, ds_accion, ds_pantalla, ds_roles, id_aplicacion) FROM stdin;
42017 \N \N \N \N Configuracion Permisos Menu Principal SUPER_ADMIN 16
42118 \N \N \N \N Descargar Documentacion Tecnologia Menu Principal USER,SUPER_ADMIN 16
42219 \N \N \N \N Estadisticas Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
42320 \N \N \N \N Eventos Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
42421 \N \N \N \N Listado Deudores Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
42522 \N \N \N \N Listado Planes Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
42623 \N \N \N \N Validar Deudas Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
42724 \N \N \N \N Desestimar Deudas Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
42825 \N \N \N \N Recuperar Deudas De Titulos Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
42926 \N \N \N \N Instancias De Titulos En Recuperacion Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
43027 \N \N \N \N Deudas Desestimadas Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
43128 \N \N \N \N Deudas Erroneas Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
43229 \N \N \N \N Listado Presuntas Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
43330 \N \N \N \N Listado Presuntas Invalidadas Menu Principal TIERI,REGISTRO,USER,SUPER_ADMIN 16
43431 \N \N \N \N Todo Descargar Documentacion Tecnologia USER,SUPER_ADMIN 16
43532 \N \N \N \N Todo Configuracion Permisos SUPER_ADMIN 16
43633 \N \N \N \N Todo Flujo Manual TIERI,USER,SUPER_ADMIN 16
43734 \N \N \N \N Todo Flujo Masiva TIERI,USER,SUPER_ADMIN 16
43835 \N \N \N \N Todo Flujo Registro REGISTRO,USER,SUPER_ADMIN 16
43936 \N \N \N \N Todo Estadisticas TIERI,REGISTRO,USER,SUPER_ADMIN 16
44037 \N \N \N \N Todo Eventos TIERI,REGISTRO,USER,SUPER_ADMIN 16
44138 \N \N \N \N Todo Listado Deudores TIERI,REGISTRO,USER,SUPER_ADMIN 16
44239 \N \N \N \N Todo Listado Planes TIERI,REGISTRO,USER,SUPER_ADMIN 16
44340 \N \N \N \N Todo Validar Deudas TIERI,REGISTRO,USER,SUPER_ADMIN 16
44441 \N \N \N \N Todo Desestimar Deudas TIERI,REGISTRO,USER,SUPER_ADMIN 16
44542 \N \N \N \N Todo Recuperar Deudas De Titulos TIERI,REGISTRO,USER,SUPER_ADMIN 16
44643 \N \N \N \N Todo Instancias De Titulos En Recuperacion TIERI,REGISTRO,USER,SUPER_ADMIN 16
44744 \N \N \N \N Todo Deudas Desestimadas TIERI,REGISTRO,USER,SUPER_ADMIN 16
44845 \N \N \N \N Todo Deudas Erroneas TIERI,REGISTRO,USER,SUPER_ADMIN 16
44946 \N \N \N \N Todo Listado Presuntas TIERI,REGISTRO,USER,SUPER_ADMIN 16
45047 \N \N \N \N Todo Listado Presuntas Invalidadas TIERI,REGISTRO,USER,SUPER_ADMIN 16
45196 \N \N \N \N Todo ADOLFO_GONZALES_CHAVES ADOLFO_GONZALES_CHAVES 91
452100 \N \N \N \N Todo ALMIRANTE_BROWN ALMIRANTE_BROWN 91
453104 \N \N \N \N Todo AZUL AZUL 91
454108 \N \N \N \N Todo BAHIA_BLANCA BAHIA_BLANCA 91
455112 \N \N \N \N Todo BALCARCE BALCARCE 91
456116 \N \N \N \N Todo BARADERO BARADERO 91
457120 \N \N \N \N Todo BENITO_JUAREZ BENITO_JUAREZ 91
458124 \N \N \N \N Todo BOLIVAR BOLIVAR 91
459128 \N \N \N \N Todo BRANDSEN BRANDSEN 91
460132 \N \N \N \N Todo CABA CABA 91
461136 \N \N \N \N Todo CABA_(CASA_DE_LA_PROVINCIA) CABA_(CASA_DE_LA_PROVINCIA) 91
462140 \N \N \N \N Todo CAPITAN_SARMIENTO CAPITAN_SARMIENTO 91
463144 \N \N \N \N Todo CARLOS_CASARES CARLOS_CASARES 91
464148 \N \N \N \N Todo CASTELLI CASTELLI 91
465152 \N \N \N \N Todo CARMEN_DE_PATAGONES CARMEN_DE_PATAGONES 91
466156 \N \N \N \N Todo CHACABUCO CHACABUCO 91
467160 \N \N \N \N Todo CHASCOMUS CHASCOMUS 91
468164 \N \N \N \N Todo CHIVILCOY CHIVILCOY 91
469168 \N \N \N \N Todo CORONEL_DORREGO CORONEL_DORREGO 91
470172 \N \N \N \N Todo CORONEL_PRINGLES CORONEL_PRINGLES 91
471176 \N \N \N \N Todo CORONEL_ROSALES CORONEL_ROSALES 91
472180 \N \N \N \N Todo DAIREAUX DAIREAUX 91
473184 \N \N \N \N Todo DOLORES DOLORES 91
474188 \N \N \N \N Todo FLORENCIO_VARELA FLORENCIO_VARELA 91
475192 \N \N \N \N Todo GENERAL_ALVARADO GENERAL_ALVARADO 91
476196 \N \N \N \N Todo GENERAL_ALVEAR GENERAL_ALVEAR 91
477200 \N \N \N \N Todo GENERAL_ARENALES GENERAL_ARENALES 91
478204 \N \N \N \N Todo GENERAL_BELGRANO GENERAL_BELGRANO 91
479208 \N \N \N \N Todo GENERAL_CONESA GENERAL_CONESA 91
480212 \N \N \N \N Todo GENERAL_LA_MADRID GENERAL_LA_MADRID 91
481216 \N \N \N \N Todo GENERAL_LAVALLE GENERAL_LAVALLE 91
482220 \N \N \N \N Todo GENERAL_MADARIAGA GENERAL_MADARIAGA 91
483224 \N \N \N \N Todo GENERAL_PAZ GENERAL_PAZ 91
484228 \N \N \N \N Todo GENERAL_PUEYRREDON_-1- GENERAL_PUEYRREDON_-1- 91
485232 \N \N \N \N Todo GENERAL_PUEYRREDON_-2- GENERAL_PUEYRREDON_-2- 91
486236 \N \N \N \N Todo GENERAL_RODRIGUEZ GENERAL_RODRIGUEZ 91
487240 \N \N \N \N Todo GUAMINI GUAMINI 91
488244 \N \N \N \N Todo HIPOLITO_YRIGOYEN HIPOLITO_YRIGOYEN 91
489248 \N \N \N \N Todo LA_MATANZA LA_MATANZA 91
490252 \N \N \N \N Todo LAPRIDA LAPRIDA 91
491256 \N \N \N \N Todo LEZAMA LEZAMA 91
492260 \N \N \N \N Todo LINCOLN LINCOLN 91
493264 \N \N \N \N Todo LOBOS LOBOS 91
494268 \N \N \N \N Todo LOMAS_DE_ZAMORA LOMAS_DE_ZAMORA 91
495272 \N \N \N \N Todo MAGDALENA MAGDALENA 91
496276 \N \N \N \N Todo MAIPU MAIPU 91
497280 \N \N \N \N Todo MARCOS_PAZ MARCOS_PAZ 91
498284 \N \N \N \N Todo MERCEDES MERCEDES 91
499288 \N \N \N \N Todo MONTE_HERMOSO MONTE_HERMOSO 91
500292 \N \N \N \N Todo MORENO MORENO 91
501296 \N \N \N \N Todo NECOCHEA NECOCHEA 91
502300 \N \N \N \N Todo 9_DE_JULIO 9_DE_JULIO 91
503304 \N \N \N \N Todo OLAVARRIA OLAVARRIA 91
504308 \N \N \N \N Todo PARTIDO_DE_LA_COSTA_(MAR_DEL_TUYU) PARTIDO_DE_LA_COSTA_(MAR_DEL_TUYU) 91
505312 \N \N \N \N Todo PEHUAJO PEHUAJO 91
506316 \N \N \N \N Todo PELLEGRINI PELLEGRINI 91
507320 \N \N \N \N Todo PINAMAR PINAMAR 91
508324 \N \N \N \N Todo PUNTA_INDIO PUNTA_INDIO 91
509328 \N \N \N \N Todo SAAVEDRA SAAVEDRA 91
510332 \N \N \N \N Todo ROJAS ROJAS 91
511336 \N \N \N \N Todo ROQUE_PEREZ ROQUE_PEREZ 91
512340 \N \N \N \N Todo SALADILLO SALADILLO 91
513344 \N \N \N \N Todo SALIQUELLO SALIQUELLO 91
514348 \N \N \N \N Todo SALTO SALTO 91
515360 \N \N \N \N Todo SAN_MIGUEL SAN_MIGUEL 91
516364 \N \N \N \N Todo SAN_MIGUEL_DEL_MONTE SAN_MIGUEL_DEL_MONTE 91
517384 \N \N \N \N Todo TRENQUE_LAUQUEN TRENQUE_LAUQUEN 91
518388 \N \N \N \N Todo TRES_ARROYOS TRES_ARROYOS 91
519392 \N \N \N \N Todo TRES_DE_FEBRERO TRES_DE_FEBRERO 91
520396 \N \N \N \N Todo TRES_LOMAS TRES_LOMAS 91
521400 \N \N \N \N Todo VILLA_GESELL VILLA_GESELL 91
522404 \N \N \N \N Todo VILLARINO VILLARINO 91
523405 \N \N \N \N Todo Datos Cap CAP,SUPER_ADMIN,SUPER_ADMIN_CAPACITA 91
524406 \N \N \N \N Todo Administracion SUPER_ADMIN,SUPER_ADMIN_CAPACITA 91
525352 \N \N \N \N Todo SAN_ANTONIO_DE_ARECO SAN_ANTONIO_DE_ARECO 91
526356 \N \N \N \N Todo SAN_CAYETANO SAN_CAYETANO 91
527368 \N \N \N \N Todo SAN_NICOLAS SAN_NICOLAS 91
528372 \N \N \N \N Todo TANDIL TANDIL 91
529376 \N \N \N \N Todo TAPALQUE TAPALQUE 91
530380 \N \N \N \N Todo TIGRE TIGRE 91
531534 \N \N \N \N Todo Listado Descuentos USER,SUPER_ADMIN,TIERI,REGISTRO 16
532\.
533
534
535--
536-- TOC entry 2059 (class 0 OID 73170)
537-- Dependencies: 177
538-- Data for Name: personaips; Type: TABLE DATA; Schema: public; Owner: fermin
539--
540
541COPY personaips (id_persona_ips, cd_usuario_actual, cd_usuario_alta, dt_actual, dt_alta, ds_mail, nm_usuario) FROM stdin;
5425 \N \N \N \N frecalt@ips.gba.gov.ar ips
5436 \N \N \N \N amaciel@ips.gba.gov.ar super
54485 \N \N \N \N ptieri@ips.gba.gov.ar tieri
54586 \N \N \N \N ilrosenfeld@ips.gba.gov.ar registro
54687 \N \N \N \N bdiaz@ips.gba.gov.ar beatriz
54788 \N \N \N \N bpaz@ips.gba.gov.ar betiana
54889 \N \N \N \N pregini@ips.gba.gov.ar pablo
549411 \N \N \N \N ilrosenfeld@ips.gba.gov.ar cap
550412 \N \N \N \N amarquez@ips.gba.gov.ar amarquez
551413 \N \N \N \N capgchaves@ips.gba.gov.ar adolfo_gonzales_chaves
552414 \N \N \N \N capaltebrown@ips.gba.gov.ar almirante_brown
553415 \N \N \N \N capazul@ips.gba.gov.ar azul
554416 \N \N \N \N capbahia@ips.gba.gov.ar bahia_blanca
555417 \N \N \N \N capbalcarce@ips.gba.gov.ar balcarce
556418 \N \N \N \N capbaradero@ips.gba.gov.ar baradero
557419 \N \N \N \N capbjuarez@ips.gba.gov.ar benito_juarez
558420 \N \N \N \N capbolivar@ips.gba.gov.ar bolivar
559421 \N \N \N \N capbrandsen@ips.gba.gov.ar brandsen
560422 \N \N \N \N capcaba@ips.gba.gov.ar caba
561423 \N \N \N \N capcasaprov@ips.gba.gov.ar caba_(casa_de_la_provincia)
562424 \N \N \N \N capsarmiento@ips.gba.gov.ar capitan_sarmiento
563425 \N \N \N \N capcasares@ips.gba.gov.ar carlos_casares
564426 \N \N \N \N capcastelli@ips.gba.gov.ar castelli
565427 \N \N \N \N cappatagones@ips.gba.gov.ar carmen_de_patagones
566428 \N \N \N \N capchacabuco@ips.gba.gov.ar chacabuco
567429 \N \N \N \N capchascomus@ips.gba.gov.ar chascomus
568430 \N \N \N \N capchivilcoy@ips.gba.gov.ar chivilcoy
569431 \N \N \N \N capdorrego@ips.gba.gov.ar coronel_dorrego
570432 \N \N \N \N capcpringles@ips.gba.gov.ar coronel_pringles
571433 \N \N \N \N capdaireaux@ips.gba.gov.ar daireaux
572434 \N \N \N \N capdolores@ips.gba.gov.ar dolores
573435 \N \N \N \N capflorenciovarela@ips.gba.gov.ar florencio_varela
574436 \N \N \N \N capmiramar@ips.gba.gov.ar general_alvarado
575437 \N \N \N \N capalvear@ips.gba.gov.ar general_alvear
576438 \N \N \N \N capgarenales@ips.gba.gov.ar general_arenales
577439 \N \N \N \N capbelgrano@ips.gba.gov.ar general_belgrano
578440 \N \N \N \N captordillo@ips.gba.gov.ar general_conesa
579441 \N \N \N \N caplamadrid@ips.gba.gov.ar general_la_madrid
580442 \N \N \N \N caplavalle@ips.gba.gov.ar general_lavalle
581443 \N \N \N \N capmadariaga@ips.gba.gov.ar general_madariaga
582444 \N \N \N \N capchascomus@ips.gba.gov.ar general_paz
583445 \N \N \N \N capmardel@ips.gba.gov.ar general_pueyrredon_-1-
584446 \N \N \N \N capmardeldos@ips.gba.gov.ar general_pueyrredon2_-2-
585447 \N \N \N \N caprodriguez@ips.gba.gov.ar general_rodriguez
586448 \N \N \N \N capguamini@ips.gba.gov.ar guamini
587449 \N \N \N \N caphenderson@ips.gba.gov.ar hipolito_yrigoyen
588450 \N \N \N \N caplamatanza@ips.gba.gov.ar la_matanza
589451 \N \N \N \N caplaprida@ips.gba.gov.ar laprida
590452 \N \N \N \N caplezama@ips.gba.gov.ar lezama
591453 \N \N \N \N caplincoln@ips.gba.gov.ar lincoln
592454 \N \N \N \N caplobos@ips.gba.gov.ar lobos
593455 \N \N \N \N caplomas@ips.gba.gov.ar lomas_de_zamora
594456 \N \N \N \N capmagdalena@ips.gba.gov.ar magdalena
595457 \N \N \N \N capmaipu@ips.gba.gov.ar maipu
596458 \N \N \N \N capmarcospaz@ips.gba.gov.ar marcos_paz
597459 \N \N \N \N capmercedes@ips.gba.gov.ar mercedes
598460 \N \N \N \N capmontehermoso@ips.gba.gov.ar monte_hermoso
599461 \N \N \N \N capmoreno@ips.gba.gov.ar moreno
600462 \N \N \N \N capnecochea@ips.gba.gov.ar necochea
601463 \N \N \N \N capnuevedejulio@ips.gba.gov.ar 9_de_julio
602464 \N \N \N \N capolavaria@ips.gba.gov.ar olavarria
603465 \N \N \N \N cappdelacosta@ips.gba.gov.ar partido_de_la_costa(mar_del_tuyu)
604466 \N \N \N \N cappehuajo@ips.gba.gov.ar pehuajo
605467 \N \N \N \N cappellegrini@ips.gba.gov.ar pellegrini
606468 \N \N \N \N cappinamar@ips.gba.gov.ar pinamar
607469 \N \N \N \N cappuntaindio@ips.gba.gov.ar punta_indio
608470 \N \N \N \N cappigue@ips.gba.gov.ar saavedra
609471 \N \N \N \N caprojas@ips.gba.gov.ar rojas
610472 \N \N \N \N caproqueperez@ips.gba.gov.ar roque_perez
611473 \N \N \N \N capsaladillo@ips.gba.gov.ar saladillo
612474 \N \N \N \N saliquello
613475 \N \N \N \N salto
614476 \N \N \N \N capsareco@ips.gba.gov.ar san_antonio_de_areco
615477 \N \N \N \N capscayetano@ips.gba.gov.ar san_cayetano
616478 \N \N \N \N capsanmiguel@ips.gba.gov.ar san_miguel
617479 \N \N \N \N capmonte@ips.gba.gov.ar san_miguel_del_monte
618480 \N \N \N \N capsannicolas@ips.gba.gov.ar san_nicolas
619481 \N \N \N \N captandil@ips.gba.gov.ar tandil
620482 \N \N \N \N captapalque@ips.gba.gov.ar tapalque
621483 \N \N \N \N captigre@ips.gba.gov.ar tigre
622484 \N \N \N \N caplauquen@ips.gba.gov.ar trenque_lauquen
623485 \N \N \N \N captresarroyos@ips.gba.gov.ar tres_arroyos
624486 \N \N \N \N captresdefebrero@ips.gba.gov.ar tres_de_febrero
625487 \N \N \N \N captreslomas@ips.gba.gov.ar tres_lomas
626488 \N \N \N \N capvillagesell@ips.gba.gov.ar villa_gesell
627489 \N \N \N \N capvillarino@ips.gba.gov.ar villarino
628\.
629
630
631--
632-- TOC entry 2060 (class 0 OID 73178)
633-- Dependencies: 178
634-- Data for Name: rol; Type: TABLE DATA; Schema: public; Owner: fermin
635--
636
637COPY rol (id, cd_usuario_actual, cd_usuario_alta, dt_actual, dt_alta, ds_nombre, dt_fecha_baja, dt_fecha_creacion) FROM stdin;
6389 \N \N \N \N USER \N 2016-04-14 12:00:00
63910 \N \N \N \N SUPER_ADMIN \N 2016-04-14 12:00:00
64014 \N \N \N \N TIERI \N 2016-04-14 12:00:00
64115 \N \N \N \N REGISTRO \N 2016-04-14 12:00:00
64290 \N \N \N \N CAP \N 2016-04-14 12:00:00
64392 \N \N \N \N SUPER_ADMIN_CAPACITA \N 2016-04-14 12:00:00
64495 \N \N \N \N ADOLFO_GONZALES_CHAVES \N 2016-04-14 12:00:00
64599 \N \N \N \N ALMIRANTE_BROWN \N 2016-04-14 12:00:00
646103 \N \N \N \N AZUL \N 2016-04-14 12:00:00
647107 \N \N \N \N BAHIA_BLANCA \N 2016-04-14 12:00:00
648111 \N \N \N \N BALCARCE \N 2016-04-14 12:00:00
649115 \N \N \N \N BARADERO \N 2016-04-14 12:00:00
650119 \N \N \N \N BENITO_JUAREZ \N 2016-04-14 12:00:00
651123 \N \N \N \N BOLIVAR \N 2016-04-14 12:00:00
652127 \N \N \N \N BRANDSEN \N 2016-04-14 12:00:00
653131 \N \N \N \N CABA \N 2016-04-14 12:00:00
654135 \N \N \N \N CABA_(CASA_DE_LA_PROVINCIA) \N 2016-04-14 12:00:00
655139 \N \N \N \N CAPITAN_SARMIENTO \N 2016-04-14 12:00:00
656143 \N \N \N \N CARLOS_CASARES \N 2016-04-14 12:00:00
657147 \N \N \N \N CASTELLI \N 2016-04-14 12:00:00
658151 \N \N \N \N CARMEN_DE_PATAGONES \N 2016-04-14 12:00:00
659155 \N \N \N \N CHACABUCO \N 2016-04-14 12:00:00
660159 \N \N \N \N CHASCOMUS \N 2016-04-14 12:00:00
661163 \N \N \N \N CHIVILCOY \N 2016-04-14 12:00:00
662167 \N \N \N \N CORONEL_DORREGO \N 2016-04-14 12:00:00
663171 \N \N \N \N CORONEL_PRINGLES \N 2016-04-14 12:00:00
664175 \N \N \N \N CORONEL_ROSALES \N 2016-04-14 12:00:00
665179 \N \N \N \N DAIREAUX \N 2016-04-14 12:00:00
666183 \N \N \N \N DOLORES \N 2016-04-14 12:00:00
667187 \N \N \N \N FLORENCIO_VARELA \N 2016-04-14 12:00:00
668191 \N \N \N \N GENERAL_ALVARADO \N 2016-04-14 12:00:00
669195 \N \N \N \N GENERAL_ALVEAR \N 2016-04-14 12:00:00
670199 \N \N \N \N GENERAL_ARENALES \N 2016-04-14 12:00:00
671203 \N \N \N \N GENERAL_BELGRANO \N 2016-04-14 12:00:00
672207 \N \N \N \N GENERAL_CONESA \N 2016-04-14 12:00:00
673211 \N \N \N \N GENERAL_LA_MADRID \N 2016-04-14 12:00:00
674215 \N \N \N \N GENERAL_LAVALLE \N 2016-04-14 12:00:00
675219 \N \N \N \N GENERAL_MADARIAGA \N 2016-04-14 12:00:00
676223 \N \N \N \N GENERAL_PAZ \N 2016-04-14 12:00:00
677227 \N \N \N \N GENERAL_PUEYRREDON_-1- \N 2016-04-14 12:00:00
678231 \N \N \N \N GENERAL_PUEYRREDON_-2- \N 2016-04-14 12:00:00
679235 \N \N \N \N GENERAL_RODRIGUEZ \N 2016-04-14 12:00:00
680239 \N \N \N \N GUAMINI \N 2016-04-14 12:00:00
681243 \N \N \N \N HIPOLITO_YRIGOYEN \N 2016-04-14 12:00:00
682247 \N \N \N \N LA_MATANZA \N 2016-04-14 12:00:00
683251 \N \N \N \N LAPRIDA \N 2016-04-14 12:00:00
684255 \N \N \N \N LEZAMA \N 2016-04-14 12:00:00
685259 \N \N \N \N LINCOLN \N 2016-04-14 12:00:00
686263 \N \N \N \N LOBOS \N 2016-04-14 12:00:00
687267 \N \N \N \N LOMAS_DE_ZAMORA \N 2016-04-14 12:00:00
688271 \N \N \N \N MAGDALENA \N 2016-04-14 12:00:00
689275 \N \N \N \N MAIPU \N 2016-04-14 12:00:00
690279 \N \N \N \N MARCOS_PAZ \N 2016-04-14 12:00:00
691283 \N \N \N \N MERCEDES \N 2016-04-14 12:00:00
692287 \N \N \N \N MONTE_HERMOSO \N 2016-04-14 12:00:00
693291 \N \N \N \N MORENO \N 2016-04-14 12:00:00
694295 \N \N \N \N NECOCHEA \N 2016-04-14 12:00:00
695299 \N \N \N \N 9_DE_JULIO \N 2016-04-14 12:00:00
696303 \N \N \N \N OLAVARRIA \N 2016-04-14 12:00:00
697307 \N \N \N \N PARTIDO_DE_LA_COSTA_(MAR_DEL_TUYU) \N 2016-04-14 12:00:00
698311 \N \N \N \N PEHUAJO \N 2016-04-14 12:00:00
699315 \N \N \N \N PELLEGRINI \N 2016-04-14 12:00:00
700319 \N \N \N \N PINAMAR \N 2016-04-14 12:00:00
701323 \N \N \N \N PUNTA_INDIO \N 2016-04-14 12:00:00
702327 \N \N \N \N SAAVEDRA \N 2016-04-14 12:00:00
703331 \N \N \N \N ROJAS \N 2016-04-14 12:00:00
704335 \N \N \N \N ROQUE_PEREZ \N 2016-04-14 12:00:00
705339 \N \N \N \N SALADILLO \N 2016-04-14 12:00:00
706343 \N \N \N \N SALIQUELLO \N 2016-04-14 12:00:00
707347 \N \N \N \N SALTO \N 2016-04-14 12:00:00
708351 \N \N \N \N SAN_ANTONIO_DE_ARECO \N 2016-04-14 12:00:00
709355 \N \N \N \N SAN_CAYETANO \N 2016-04-14 12:00:00
710359 \N \N \N \N SAN_MIGUEL \N 2016-04-14 12:00:00
711363 \N \N \N \N SAN_MIGUEL_DEL_MONTE \N 2016-04-14 12:00:00
712367 \N \N \N \N SAN_NICOLAS \N 2016-04-14 12:00:00
713371 \N \N \N \N TANDIL \N 2016-04-14 12:00:00
714375 \N \N \N \N TAPALQUE \N 2016-04-14 12:00:00
715379 \N \N \N \N TIGRE \N 2016-04-14 12:00:00
716383 \N \N \N \N TRENQUE_LAUQUEN \N 2016-04-14 12:00:00
717387 \N \N \N \N TRES_ARROYOS \N 2016-04-14 12:00:00
718391 \N \N \N \N TRES_DE_FEBRERO \N 2016-04-14 12:00:00
719395 \N \N \N \N TRES_LOMAS \N 2016-04-14 12:00:00
720399 \N \N \N \N VILLA_GESELL \N 2016-04-14 12:00:00
721403 \N \N \N \N VILLARINO \N 2016-04-14 12:00:00
722\.
723
724
725--
726-- TOC entry 2061 (class 0 OID 73186)
727-- Dependencies: 179
728-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: fermin
729--
730
731COPY users (id, enabled, password, username) FROM stdin;
7321 1 dbee5f3e9a44198fcbf480542c212e4cb276fa33 ips
7333 1 8451ba8a14d79753d34cb33b51ba46b4b025eb81 super
73475 1 c5d97a056bd0c875f9d31fb74984fa638deb605b tieri
73577 1 0ac94d31653bde841bd0dcb5745a2cdf7eb5b56d registro
73679 1 293a09bc5efd175ff2edbdb9273a748bac4a0740 beatriz
73781 1 77154f64b0aad5d4ef57ef7925e781913414c403 betiana
73883 1 707d14912bb250caf67dfe0ea4035681fbfc4f56 pablo
73993 1 edfc26dafa66dc7d15a8ad511083243b64ab5d66 adolfo_gonzales_chaves
74097 1 36eb2f131a64602d741b8eb0a0ce8fdb24169898 almirante_brown
741101 1 1768d39c5bb4a98329b02421d5cdd1466cfe6998 azul
742105 1 e377fd88afa85e65e5814a0360b7d4720b7a896b bahia_blanca
743109 1 44a9276ec01d9597ce17b67ec828ca1c91c1529e balcarce
744113 1 0bec099fbaff70379ae6fb77904e866d456b2f51 baradero
745117 1 33715a4596f30855c470442c4c17989650a66309 benito_juarez
746121 1 14a5090a64dc9c0d9f32d5d5711abf183eb60f15 bolivar
747125 1 3c5e912ba353d78481d9144713fa4ed6b1b2b873 brandsen
748129 1 6656f9e0a7fea39d57e76c317527f14a16474f5d caba
749133 1 69f61b8cc0e387844a538f02fb89e2f1c2fff6ed caba_(casa_de_la_provincia)
750137 1 64057fa9bc924724b76bd0b42c1b0b1b401d3b13 capitan_sarmiento
751141 1 0bc72440b6209faa20c9a63fc81811ea64a02bdf carlos_casares
752145 1 08e6e11639363ec5744feded5626d82bbc9305db castelli
753149 1 a60f4e1a15965ca064de2790e994f6fad9e4606f carmen_de_patagones
754153 1 4acab2c95c82a95df1e9e23af811d662a8e69898 chacabuco
755157 1 463d1f1b463ef7502ec4380d33ddd7f2bda8f248 chascomus
756161 1 0c754b2f085288a07772a4790e5f5192cd277aa6 chivilcoy
757165 1 19de19a80bcf840d4b5d5afb2f0148d68784ec87 coronel_dorrego
758169 1 bebab8680a554adca4b5a0d5c6b3ddea51d0a11b coronel_pringles
759173 1 70ea0eea078509daff024234fde8ded044a4bd9f coronel_rosales
760177 1 7f73e8bd85e58f0e6900a09d513c1bf08df0d2bc daireaux
761181 1 7fea8eda846cfd24ba628d256da799db09e05718 dolores
762185 1 eeaca68594e0683e9beee355b0dc291d1127d7fc florencio_varela
763189 1 4b50c8ca0840656fb308f40dcaca6d24143edfe9 general_alvarado
764193 1 36e6cdb40c32b74fbb965edbebf879b2a93f1674 general_alvear
765197 1 185668321f3c4b00222c4db0db17dc8917558637 general_arenales
766201 1 5462570c5b0dcd82f5bc7d7c27324ec7d472acf7 general_belgrano
767205 1 f8c08c4d5fb38900024d26a9c3046ba234126d16 general_conesa
768209 1 7fb4224613d24116eeee2b23bd8fa6ab7d954d56 general_la_madrid
769213 1 b1d33698a14598d53568aac78f937b95ef26ac44 general_lavalle
770217 1 e9888244d83b2352170502e9f45bdbe53bc539d5 general_madariaga
771221 1 8d9732fa6e72d8ba174da56d4355592d3037f7c2 general_paz
772225 1 63d2a70e0fb076abd73c6f1b865b84582e416934 general_pueyrredon_-1-
773229 1 9a185819b44d38977e8e9344513ff11d2d0a7275 general_pueyrredon_-2-
774233 1 32e1a795771dbf48f1379f3d19826959f082a15e general_rodriguez
775237 1 4ae6de788f0bcca2aded8bc1e2acb1875f0e8087 guamini
776241 1 79d23970bb6184af246773676c96cfd50c351b1c hipolito_yrigoyen
777245 1 2ada644794cfce3bf714b1d13ae8114ad528c7c3 la_matanza
778249 1 a27e050b40a4fba1ff8b381577714c2f9dbcdbc8 laprida
779253 1 22893482d571203e3a7403871781437c1cf018b1 lezama
780257 1 e2a8bbda57fb87262b0f7e59c3bccbbe9f361e23 lincoln
781261 1 3ac8851c38aee6b779ac4764b14c9612231f18c1 lobos
782265 1 bbe0d994ce641e0561923bf0aeda5bc484cd2554 lomas_de_zamora
783269 1 ada3e9666e7e4886585784d50396549ef45f6852 magdalena
784273 1 b152f2df8277836f65eec3397c6590c909af0a4e maipu
785277 1 344eef9d10f2808d65bca4e8e0980403888caf2e marcos_paz
786281 1 f11ea658082349955674a565fe658ad5bedfb328 mercedes
787285 1 2c3df826696e35d0b367d82e43bea013765b5ec3 monte_hermoso
788289 1 1c018a305664da4040a64de20321707c068d2f4a moreno
789293 1 62bca2f5be1bf9306f56a8ab6ad6acc0db6fe24e necochea
790297 1 356b0cd1f3b9debc8c76ec8b0a66142fc0c8ff4d 9_de_julio
791301 1 7bb6d43fc68277429fe4afcfbd131fa1a3641825 olavarria
792305 1 88520e9f2183f98c15109c9d5b3ded1c33abb561 partido_de_la_costa_(mar_del_tuyu)
793309 1 e15d6c29969fe8a17a25dee379bcf9a2405b691f pehuajo
794313 1 dd3121172598149bbe01e9ad275241184d4b3ff6 pellegrini
795317 1 112c003b6e44853928a4f5615d222f91b5c49382 pinamar
796321 1 40fb75b7d30d01d885f607d727bf5db45738a2dd punta_indio
797325 1 61ac7046ea074d496d241095d950ee0e6fa18f75 saavedra
798329 1 fc6fea5b0c058716683a5ec0cf63833ba7a72bca rojas
799333 1 bce2cd22f7d0a2abc9055b0ac228016ed22b2364 roque_perez
800337 1 97e0e600238f5ba13ad46358102f9bf85b525199 saladillo
801341 1 45c846ef3db601a49bf4745019dd7fd5bf772d57 saliquello
802345 1 95171455bc296e201cea1603d0ef4e46ff51373b salto
803349 1 ada9faa1f3e2c958c08d77ec905c86dad37ee3d4 san_antonio_de_areco
804353 1 01cd5fe3208faf5e6ef59783cc5746b0c337b9ee san_cayetano
805357 1 475bb9f39f7fe3d071c3d66ea92f5b30a6e1c298 san_miguel
806361 1 20f248533b16f2ab2ff1d2d43845355bf4ccece2 san_miguel_del_monte
807365 1 0fa82a67ab3046dd344c364be47554f942c903af san_nicolas
808369 1 bdb61496152a27d22455ad9ab96fccda464368b9 tandil
809373 1 e6ebbef990a7086737282af0578973425eeb0cd2 tapalque
810377 1 c557c8fce1c642b7aab2671ede854f731a8b5d91 tigre
811381 1 238ec99ec1f8ff1b3c342ca8b4b26f7ed1bcd458 trenque_lauquen
812385 1 77c01b041c3c9bd2131526ab7d8fec24b15fab5d tres_arroyos
813389 1 de04a80806086e3d5e1cfa7f16af50d0da14b0e6 tres_de_febrero
814393 1 bc1dfa0ecc66f5301e24ee529cd259d64cbdf333 tres_lomas
815397 1 a60e402001b8b3c3f2f6609a12c019f5764380cc villa_gesell
816401 1 986d8ec5e37ca0338530365f390fb87b7eb139a3 villarino
817490 1 ac4be5ac63e1ea62640409f639b010b9fb479c5b cap
818492 1 a8bcbfc6f0ac07e35b2783379670b5eac0584ead amarquez
819\.
820
821
822--
823-- TOC entry 1918 (class 2606 OID 73137)
824-- Name: aplicacion_pkey; Type: CONSTRAINT; Schema: public; Owner: fermin; Tablespace:
825--
826
827ALTER TABLE ONLY aplicacion
828 ADD CONSTRAINT aplicacion_pkey PRIMARY KEY (id_aplicacion);
829
830
831--
832-- TOC entry 1921 (class 2606 OID 73145)
833-- Name: authorities_pkey; Type: CONSTRAINT; Schema: public; Owner: fermin; Tablespace:
834--
835
836ALTER TABLE ONLY authorities
837 ADD CONSTRAINT authorities_pkey PRIMARY KEY (id);
838
839
840--
841-- TOC entry 1923 (class 2606 OID 73153)
842-- Name: edicionpassword_pkey; Type: CONSTRAINT; Schema: public; Owner: fermin; Tablespace:
843--
844
845ALTER TABLE ONLY edicionpassword
846 ADD CONSTRAINT edicionpassword_pkey PRIMARY KEY (id);
847
848
849--
850-- TOC entry 1926 (class 2606 OID 73161)
851-- Name: evento_pkey; Type: CONSTRAINT; Schema: public; Owner: fermin; Tablespace:
852--
853
854ALTER TABLE ONLY evento
855 ADD CONSTRAINT evento_pkey PRIMARY KEY (id_evento);
856
857
858--
859-- TOC entry 1934 (class 2606 OID 73169)
860-- Name: permiso_pkey; Type: CONSTRAINT; Schema: public; Owner: fermin; Tablespace:
861--
862
863ALTER TABLE ONLY permiso
864 ADD CONSTRAINT permiso_pkey PRIMARY KEY (id);
865
866
867--
868-- TOC entry 1936 (class 2606 OID 73177)
869-- Name: personaips_pkey; Type: CONSTRAINT; Schema: public; Owner: fermin; Tablespace:
870--
871
872ALTER TABLE ONLY personaips
873 ADD CONSTRAINT personaips_pkey PRIMARY KEY (id_persona_ips);
874
875
876--
877-- TOC entry 1938 (class 2606 OID 73185)
878-- Name: rol_pkey; Type: CONSTRAINT; Schema: public; Owner: fermin; Tablespace:
879--
880
881ALTER TABLE ONLY rol
882 ADD CONSTRAINT rol_pkey PRIMARY KEY (id);
883
884
885--
886-- TOC entry 1940 (class 2606 OID 73193)
887-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: fermin; Tablespace:
888--
889
890ALTER TABLE ONLY users
891 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
892
893
894--
895-- TOC entry 1930 (class 1259 OID 73207)
896-- Name: ds_accion_index; Type: INDEX; Schema: public; Owner: fermin; Tablespace:
897--
898
899CREATE INDEX ds_accion_index ON permiso USING btree (ds_accion);
900
901
902--
903-- TOC entry 1924 (class 1259 OID 73213)
904-- Name: ds_aplicacion_eventorol_index; Type: INDEX; Schema: public; Owner: fermin; Tablespace:
905--
906
907CREATE INDEX ds_aplicacion_eventorol_index ON evento USING btree (ds_aplicacion);
908
909
910--
911-- TOC entry 1919 (class 1259 OID 73194)
912-- Name: ds_nombre_index; Type: INDEX; Schema: public; Owner: fermin; Tablespace:
913--
914
915CREATE INDEX ds_nombre_index ON aplicacion USING btree (ds_nombre);
916
917
918--
919-- TOC entry 1931 (class 1259 OID 73208)
920-- Name: ds_pantalla_index; Type: INDEX; Schema: public; Owner: fermin; Tablespace:
921--
922
923CREATE INDEX ds_pantalla_index ON permiso USING btree (ds_pantalla);
924
925
926--
927-- TOC entry 1932 (class 1259 OID 73209)
928-- Name: ds_roles_index; Type: INDEX; Schema: public; Owner: fermin; Tablespace:
929--
930
931CREATE INDEX ds_roles_index ON permiso USING btree (ds_roles);
932
933
934--
935-- TOC entry 1927 (class 1259 OID 73212)
936-- Name: nm_autor_evento_index; Type: INDEX; Schema: public; Owner: fermin; Tablespace:
937--
938
939CREATE INDEX nm_autor_evento_index ON evento USING btree (nm_autor);
940
941
942--
943-- TOC entry 1928 (class 1259 OID 73200)
944-- Name: nm_autor_index; Type: INDEX; Schema: public; Owner: fermin; Tablespace:
945--
946
947CREATE INDEX nm_autor_index ON evento USING btree (nm_autor);
948
949
950--
951-- TOC entry 1929 (class 1259 OID 73201)
952-- Name: rol_eventorol_index; Type: INDEX; Schema: public; Owner: fermin; Tablespace:
953--
954
955CREATE INDEX rol_eventorol_index ON evento USING btree (id_rol);
956
957
958--
959-- TOC entry 1943 (class 2606 OID 73202)
960-- Name: fk3ac59775fdb696a7; Type: FK CONSTRAINT; Schema: public; Owner: fermin
961--
962
963ALTER TABLE ONLY permiso
964 ADD CONSTRAINT fk3ac59775fdb696a7 FOREIGN KEY (id_aplicacion) REFERENCES aplicacion(id_aplicacion);
965
966
967--
968-- TOC entry 1941 (class 2606 OID 73195)
969-- Name: fk7c6ccd3590a35335; Type: FK CONSTRAINT; Schema: public; Owner: fermin
970--
971
972ALTER TABLE ONLY evento
973 ADD CONSTRAINT fk7c6ccd3590a35335 FOREIGN KEY (id_rol) REFERENCES rol(id);
974
975
976--
977-- TOC entry 1944 (class 2606 OID 77314)
978-- Name: fkm8mm4rsfjw0jlha58xu9w4ne1; Type: FK CONSTRAINT; Schema: public; Owner: fermin
979--
980
981ALTER TABLE ONLY permiso
982 ADD CONSTRAINT fkm8mm4rsfjw0jlha58xu9w4ne1 FOREIGN KEY (id_aplicacion) REFERENCES aplicacion(id_aplicacion);
983
984
985--
986-- TOC entry 1942 (class 2606 OID 77309)
987-- Name: fkng96gagywc9ixg8p1p0vxb84a; Type: FK CONSTRAINT; Schema: public; Owner: fermin
988--
989
990ALTER TABLE ONLY evento
991 ADD CONSTRAINT fkng96gagywc9ixg8p1p0vxb84a FOREIGN KEY (id_rol) REFERENCES rol(id);
992
993
994--
995-- TOC entry 2069 (class 0 OID 0)
996-- Dependencies: 5
997-- Name: public; Type: ACL; Schema: -; Owner: postgres
998--
999
1000REVOKE ALL ON SCHEMA public FROM PUBLIC;
1001REVOKE ALL ON SCHEMA public FROM postgres;
1002GRANT ALL ON SCHEMA public TO postgres;
1003GRANT ALL ON SCHEMA public TO PUBLIC;
1004
1005
1006-- Completed on 2017-05-02 11:30:01
1007
1008--
1009-- PostgreSQL database dump complete
1010--