-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcdegpanel (4).sql
More file actions
572 lines (550 loc) · 102 KB
/
cdegpanel (4).sql
File metadata and controls
572 lines (550 loc) · 102 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
CREATE DATABASE IF NOT EXISTS `cdegpanel` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `cdegpanel`;
DROP TABLE IF EXISTS `composteras`;
CREATE TABLE `composteras` (
`id` int(11) NOT NULL,
`codBenefic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`coordenas` varchar(800) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0,0',
`lat` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`log` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '0',
`fecha_inicial` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`nombre_institucion` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`nombre_responsable` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`celular_responsable` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Nota` varchar(800) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`estado` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`foto1_compostera` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firma` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Direccion_compostera` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`barrio_compostera` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`localidad_compostera` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`id_usuario` int(11) DEFAULT NULL,
`nombre_quientrega` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`serial_compostera` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Capacidad_compostera` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `composteras` (`id`, `codBenefic`, `coordenas`, `lat`, `log`, `fecha_inicial`, `nombre_institucion`, `nombre_responsable`, `celular_responsable`, `Nota`, `estado`, `foto1_compostera`, `firma`, `Direccion_compostera`, `barrio_compostera`, `localidad_compostera`, `id_usuario`, `nombre_quientrega`, `serial_compostera`, `Capacidad_compostera`) VALUES
(26, '1', '4.628294573057498, -74.09048749596795', '4.628294573057498', '-74.09048749596795', '2023-09-07', 'Centro Nariño', 'Olga Moreno / Andrés Barrero', '3132071482', 'Se entrego en buenas condiciones. la entrada es al lado de Olímpica, frente al hotel Hilton', 'INCOMPLETO', 'a3346712-22be-4968-bc11-c7f959fbe355.jpg', 'firma', 'Cra 37 # 24 - 30', NULL, NULL, 74, 'Rodrigo Andrés rios', '0000000000', 20),
(27, '7', '4.74859820939379, -74.02550345036849', '4.74859820939379', '-74.02550345036849', '2023-10-12', 'Hacienda La Estancia', 'Neydi Alexandra Dueñas Leguizamon ', '3046694938', '', 'INCOMPLETO', 'c56b4892-4cd0-4238-be60-461e19e69b30.jpg', 'firma', 'Cra 8 # 170 - 52', NULL, NULL, 75, 'Rodrigo Andrés rios', '0000000000', 20),
(28, '7', '4.649914642424484, -74.13446463588954', '4.649914642424484', '-74.13446463588954', '2023-08-26', 'Visión Colombia', 'Cesar Daniel Contreras Perez', '3043493477', '', 'INCOMPLETO', '2dafd1c7-aa03-4ea0-ac08-d75e7c60748f.jpg', 'firma', 'Cra 78 G # 13 - 43', NULL, NULL, 76, 'Rodrigo Andrés rios', '0000000000', 20),
(29, '8', '4.647043425508743, -74.08878201626034', '4.647043425508743', '-74.08878201626034', '2023-08-25', 'La Esmeralda', 'Shirly Rocio Rey Pardo', '3103303587', '', 'INCOMPLETO', 'ec1a30d3-7151-4758-a5db-5f04b390acf0.jpg', 'firma', 'Calle 45 A # 53 - 05', NULL, NULL, 77, 'Rodrigo Andrés rios', '0000000000', 20),
(30, '10', '4.768522481162369, -74.04677064232055', '4.768522481162369', '-74.04677064232055', '2023-09-12', 'Mirandela', 'Marisabel Tellez Rojas', '6694467/3002614341', '', 'INCOMPLETO', '', 'firma', 'Carrera 54 D # 189 - 59 ', NULL, NULL, 78, 'Rodrigo Andrés rios', '0000000000', 20),
(31, '11', '4.649653849667556, -74.1344183846546', '4.649653849667556', '-74.1344183846546', '2023-08-26', 'Visión Colombia', 'Pedro orlando Acosta Bejarano', '3103207353', '', 'INCOMPLETO', 'a5f95287-a56b-4041-bc9c-88a2ef9dbf44.jpg', 'firma', 'Carrera 78F # 13-43', NULL, NULL, 79, 'Rodrigo Andrés rios', '0000000000', 20),
(32, '15', '4.783271756338553, -74.0416506543631', '4.783271756338553', '-74.0416506543631', '2023-09-12', 'Universidad Escuela de Ingenieros', 'Laura Cristina Lesmes Posada', '6683600 Ext 136 3223085424', '', 'INCOMPLETO', '14f45e0e-226e-4e8c-82c7-afe07f322676.jpg', 'firma', 'Avenida Carrera 45 # 205-59, Autopista Norte (UNIVERSIDAD ESCUELA DE INGENIEROS)', NULL, NULL, 80, 'Rodrigo Andrés rios', '0000000000', 20),
(33, '18', '4.6365476, -74.0652501', '4.6365476', '-74.0652501', '2023-10-11', 'Finca Santa Isabel ', 'Martha Alejandra Villalba Contreras', '3144184258', '', 'INCOMPLETO', '9c2e1a9e-c5b6-4008-b966-b2eaa0ecdc2c.jpg', 'firma', 'Finca Santa Isabel ', NULL, NULL, 81, 'Rodrigo Andrés rios', '0000000000', 20),
(34, '203', '4.62346,-74.070404', '4.62346', '-74.070404', '2023-10-30', 'Universidad Nacional de Colombia', 'Esteban Alejandro Alarcón Hurtado ', '3242336232', '', 'INCOMPLETO', NULL, 'firma', 'teusaquillo Carrera 30 # 45 ', NULL, 'Teusaquillo', 82, 'Alejandro Duque Castrillon', '203', 20),
(35, '204', '4.5419135,-74.152284', '4.5419135', '-74.152284', '2023-10-30', 'Colegio Santa Librada IED', 'Bibiana Villa', '3166291113', '', 'INCOMPLETO', NULL, 'firma', 'Calle 75 B Sur No 9A_ 45', NULL, 'Usme', 83, 'Alejandro Duque Castrillon', '204', 20),
(36, '205', '5.328055,-72.399062', '5.328055', '-72.399062', '2023-09-27', 'Colegio Jose Marti Sede A', 'Irne Montaño Burbano', '3108614171', '', 'INCOMPLETO', NULL, 'firma', 'Carrera 13A # 32 - 36 Sur', NULL, 'Rafael Uribe Uribe', 84, 'Alejandro Duque Castrillon', '205', 20),
(37, '209', '4.593216,-74.069792', '4.593216', '-74.069792', '2023-09-27', 'Huerta Centro comunitario', 'Margarita Sanabria Ortiz ', '3215031051', '', 'INCOMPLETO', NULL, 'firma', 'Carrera 3 Este #18a Sur57', NULL, 'San Cristóbal', 85, 'Alejandro Duque Castrillon', '209', 20),
(38, '211', '6.2816389,-75.4390589', '6.2816389', '-75.4390589', '2023-09-21', 'Propiedad Horizontal', 'Andrea Carolina Hernández Macías ', '3058155640', '', 'INCOMPLETO', NULL, 'firma', 'Carrera 3 # 6-25 sur ', NULL, 'San Cristóbal', 86, 'Alejandro Duque Castrillon', '211', 20),
(39, '212', '4.1166475,-73.5885957', '4.1166475', '-73.5885957', '2023-10-02', ' Colegio Jorge Isaacs', 'Fernando Duitama Parra', '3145332172', '', 'INCOMPLETO', NULL, 'firma', 'Carrera 14 Este # 66-70 sur', NULL, 'San Cristóbal', 87, 'Alejandro Duque Castrillon', '212', 20),
(40, '216', '7.0978435,-73.0973476', '7.0978435', '-73.0973476', '2023-10-30', 'salon comunal', 'Jhon Fredy Moreno Suárez /Carlos Peña Pineda', '7610403- 3122443612 /3145332172', '', 'INCOMPLETO', NULL, 'firma', 'Calle 91 A sur # 14- 60 usme', NULL, 'Usme', 88, 'Alejandro Duque Castrillon', '216', 20),
(41, '220', '4.5673281,-74.1210708', '4.5673281', '-74.1210708', '2023-09-05', 'Alameda de San Jose Etapa 2 ', 'Franklin García celeita ', '3057069150', '', 'INCOMPLETO', NULL, 'firma', 'Diagonal 49 sur # 86 - 40 Alameda de San Jose Etapa ', NULL, 'Kennedy', 89, 'Alejandro Duque Castrillon', '220', 20),
(42, '221', '4.693727,-74.030102', '4.693727', '-74.030102', '2023-10-12', 'Aguas de Bogotá SA ESP', 'Mayra Velez/ Aguas de Bogotá SA ESP', '3166174279', '', 'INCOMPLETO', NULL, 'firma', 'Carrera 11 No. 93-92 Aguas de Bogotá SA ESP', NULL, 'Usaquén', 90, 'Alejandro Duque Castrillon', '221', 20),
(43, '224', '4.541377,-74.08628', '4.541377', '-74.08628', '2023-09-26', 'IED JUANA ESCOBAR', 'Luz Dary Martínez Rodríguez ', '3212530450', '', 'INCOMPLETO', NULL, 'firma', 'Carrera 12 E # 57 - 50 sur Sede B', NULL, 'San Cristóbal', 91, 'Alejandro Duque Castrillon', '224', 20),
(44, '225', '4.139936,-73.58864', '4.139936', '-73.58864', '2023-09-26', 'IED JUANA ESCOBAR SEDE A', 'Sonia Temilda Diaz Quintero', '3104894862', '', 'INCOMPLETO', NULL, 'firma', 'carrera 15A ESTE # 57 A SUR - 16', NULL, 'San Cristóbal', 92, 'Alejandro Duque Castrillon', '225', 20),
(45, '227', '4.565838,-74.068446', '4.565838', '-74.068446', '2023-09-21', 'Huerta', 'Katherine Sánchez ', '3187922372', '', 'INCOMPLETO', NULL, 'firma', 'Carrera 23b este N 9-48 sur', NULL, 'San Cristóbal', 93, 'Alejandro Duque Castrillon', '227', 20),
(46, '229', '5.713798,-72.9358851', '5.713798', '-72.9358851', '2023-09-21', 'Huerta', 'Oscar Giovany Mejia Galeano', '3057184896', '', 'INCOMPLETO', NULL, 'firma', 'Calle 6C Sur N° 8A-19 Este', NULL, 'San Cristóbal', 94, 'Alejandro Duque Castrillon', '229', 20),
(47, '235', '4.62346,-74.070404', '4.62346', '-74.070404', '2023-09-25', 'Junta de accion comunal', 'Pedro Abril Rodriguez', '3115913183', '', 'INCOMPLETO', NULL, 'firma', 'Teusaquillo', NULL, 'Tunjuelito', 95, 'Alejandro Duque Castrillon', '235', 20),
(48, '238', '4.7011172,-74.0983518', '4.7011172', '-74.0983518', '2023-09-07', 'Huerta', 'Yuri Martinez/Francy Quiroga', '3208360925', '', 'INCOMPLETO', NULL, 'firma', 'Cra. 82a #64-61', NULL, 'Bosa', 96, 'Alejandro Duque Castrillon', '238', 20),
(49, '243', '4.0762446,-73.6716447', '4.0762446', '-73.6716447', '2023-09-27', 'Institucional', 'Liliana Umbarila Numpaque/Diana Rubiano', '3114551412,3134257227', '', 'INCOMPLETO', NULL, 'firma', 'Calle 69 sur # 11D 71 este', NULL, 'San Cristóbal', 97, 'Alejandro Duque Castrillon', '243', 20),
(50, '244A', '4.760223,-74.0212098', '4.760223', '-74.0212098', '2023-09-12', 'Institucional', 'Laura Vanessa Lotero Zapata', '3102017734', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Calle 183 #51-65 Transmilenio', NULL, 'Suba', 98, 'Alejandro Duque Castrillon', '244A', 20),
(51, '244B', '4.760223,-74.0212098', '4.760223', '-74.0212098', '2023-09-14', 'Institucional', 'Laura Vanessa Lotero Zapata', '1031169864', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Calle 183 #51-65 Transmilenio', NULL, 'Suba', 99, 'Alejandro Duque Castrillon', '244B', 20),
(52, '246', '4.687618,-74.076234', '4.687618', '-74.076234', '2023-10-04', 'Propiedad Horizontal', 'Ariadna Díaz Monroy', '3108655010', 'Propiedad Horizontal', 'INCOMPLETO', NULL, 'firma', 'Carrera 68B # 95 - 45', NULL, 'Suba', 100, 'Alejandro Duque Castrillon', '246', 20),
(53, '249', '4.6534649,-74.0836453', '4.6534649', '-74.0836453', '2023-10-11', 'Institucional', 'German Leonel Sarmiento Cruz ', '3203270944', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Calle 16 31 10 ', NULL, 'Rafael Uribe Uribe', 101, 'Alejandro Duque Castrillon', '249', 20),
(54, '250', '4.6149556,-74.1582948', '4.6149556', '-74.1582948', '2023-10-11', 'Bodega reciclaje', 'Carmen Lucy Ramirez ', '3503694175', 'Bodega reciclaje', 'INCOMPLETO', NULL, 'firma', 'Calle 41g Sur #80, Bogotá', NULL, 'Kennedy', 102, 'Alejandro Duque Castrillon', '250', 20),
(55, '252', '4.0979667,-73.6433396', '4.0979667', '-73.6433396', '2023-09-28', 'Institucional', 'Edgar Fernando Barbosa Pineda', '3045821463', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Calle 30 Sur #34-37', NULL, 'Antonio Nariño', 103, 'Alejandro Duque Castrillon', '252', 20),
(56, '253', '4.7228415,-74.0550046', '4.7228415', '-74.0550046', '2023-09-18', 'Propiedad Horizontal', 'Diana Lizeth León Sierra', '3185103934', 'Propiedad Horizontal', 'INCOMPLETO', NULL, 'firma', 'calle 136 # 74-80', NULL, 'Suba', 104, 'Alejandro Duque Castrillon', '253', 20),
(57, '254', '4.8992597,-74.0340256', '4.8992597', '-74.0340256', '2023-09-27', 'Huerta', 'Maria Mercedes Saenz Estupiñan', '3222478114,3124276985', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Calle 10 sur # 5 - 32 este, bogota', NULL, 'San Cristóbal', 105, 'Alejandro Duque Castrillon', '254', 20),
(58, '263', '4.722769,-74.133159', '4.722769', '-74.133159', '2023-09-19', 'Propiedad Horizontal', 'Ingrid caterine romero bejarano ', '3058174145', 'Propiedad Horizontal', 'INCOMPLETO', NULL, 'firma', 'Calle 77b #116c -73', NULL, 'Engativá', 106, 'Alejandro Duque Castrillon', '263', 20),
(59, '266', '5.850034,-76.020867', '5.850034', '-76.020867', '2023-09-28', 'Huerta', 'Jorge Junior López Munca/Jorge Alberto Lopez Lopez', '3024211884', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Transversal 18 J Bis #71 B sur 36, Ciudad Bolivar', NULL, 'Ciudad Bolívar', 107, 'Alejandro Duque Castrillon', '266', 20),
(60, '270', '4.686042,-74.051471', '4.686042', '-74.051471', '2023-10-17', 'Huerta', 'Yerli Marcela Barrera Huertas', '3134820255', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Sumapaz, Bogotá', NULL, 'Sumapaz', 108, 'Alejandro Duque Castrillon', '270', 20),
(61, '271', '4.068251,-73.6709583', '4.068251', '-73.6709583', '2023-10-03', 'Colegio Gabriel Garcia Marquez', 'Luz Herminda Parrado Mora', '3222357349', '', 'INCOMPLETO', NULL, 'firma', 'Calle 83 sur # 13_ 33 este', NULL, 'Usme', 109, 'Alejandro Duque Castrillon', '271', 20),
(62, '275', '4.534254,-74.084978', '4.534254', '-74.084978', '2023-10-03', 'Colegio Nueva Esperanza IED cerca de Juan Rey', 'María Teresa Pava ', '3144248780', '', 'INCOMPLETO', NULL, 'firma', 'Carrera 15 este # 76 - 59 sur Colegio Nueva Esperanza IED cerca de Juan Rey', NULL, 'Usme', 110, 'Alejandro Duque Castrillon', '275', 20),
(63, '276', '4.758527,-74.049379', '4.758527', '-74.049379', '2023-10-30', 'Colegio Delia Zapata', 'Flor Azucena López Bohórquez/Yolanda Bolivar Zambrano', '3125660481', '', 'INCOMPLETO', NULL, 'firma', 'Calle 144C #141A-51 b', NULL, 'Suba', 111, 'Alejandro Duque Castrillon', '276', 20),
(64, '277', '4.514797,-74.097355', '4.514797', '-74.097355', '2023-10-10', 'granja tibares asocunt, Huerta', 'Luis Hernando Tangarife suaza / Vladimir Bernal/Rosa Piedrahita ', '3058604025,3122382972', '', 'INCOMPLETO', NULL, 'firma', 'Usme', NULL, 'Usme', 112, 'Alejandro Duque Castrillon', '277', 20),
(65, '280', '4.514797,-74.097355', '4.514797', '-74.097355', '2023-10-18', 'I.E.D. Virrey José Solís ', 'Yisela Gómez Gutiérrez ', '3214170545', '', 'INCOMPLETO', NULL, 'firma', 'Usme', NULL, 'Usme', 113, 'Alejandro Duque Castrillon', '280', 20),
(66, '282', '4.0808661,-73.6678509', '4.0808661', '-73.6678509', '2023-09-21', 'Empresa JCC', 'Viviana Fonseca ', '3107628614,3214200874', '', 'INCOMPLETO', NULL, 'firma', 'Calle 57 Sur #17-18 Empresa JCC', NULL, 'Tunjuelito', 114, 'Alejandro Duque Castrillon', '282', 20),
(67, '283', '4.744787,-74.045309', '4.744787', '-74.045309', '2023-09-06', 'Colegio Bosanova sede A', 'Wilson Alejandro Rodríguez Plazas/Claudia Patricia Serna/ Emanuel Cataño', ' 3124808078,3152430603', '', 'INCOMPLETO', NULL, 'firma', 'Calle 59 B # 87 B - 02 sur Colegio Bosanova sede A', NULL, 'Bosa', 115, 'Alejandro Duque Castrillon', '283', 20),
(68, '285', '4.5320007,-74.1146322', '4.5320007', '-74.1146322', '2023-09-07', 'Institucional', 'Yuri Tatiana Salazar', '3228965933', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Calle 66A Sur #81b-35', NULL, 'Bosa', 116, 'Alejandro Duque Castrillon', '285', 20),
(69, '289', '4.514797,-74.097355', '4.514797', '-74.097355', '2023-10-10', 'Vivero de la alcaldía local de usme ', 'Diego arias ', '3183426294', 'Vivero de la alcaldía local de usme ', 'INCOMPLETO', NULL, 'firma', 'Usme', NULL, 'Usme', 117, 'Alejandro Duque Castrillon', '289', 20),
(70, '290', '4.62346,-74.070404', '4.62346', '-74.070404', '2023-09-22', 'Propiedad Horizontal', 'Vilma Velasquez', '3502646779', 'Propiedad Horizontal', 'INCOMPLETO', NULL, 'firma', 'Teusaquillo', NULL, 'Teusaquillo', 118, 'Alejandro Duque Castrillon', '290', 20),
(71, '291', '6.2816389,-75.4390589', '6.2816389', '-75.4390589', '2023-09-28', 'Salon Comunal', 'Lindon arevalo vargas', '3214939078', 'Salon Comunal', 'INCOMPLETO', NULL, 'firma', 'Calle 77 A sur #16 H 25 Salon Comunal', NULL, 'Ciudad Bolívar', 119, 'Alejandro Duque Castrillon', '291', 20),
(72, '292', '4.514797,-74.097355', '4.514797', '-74.097355', '2023-10-10', 'Huerta', 'Cesar ignacio chaves gutierrez ', '3233631449', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Usme Vereda chiguasa Finca Villa Camila Sector Los Chavez', NULL, 'Usme', 120, 'Alejandro Duque Castrillon', '292', 20),
(73, '294A', '11.5091137,-72.9140946', '11.5091137', '-72.9140946', '2023-09-01', 'Colegio Santo Domingo Bilingüe sede bachillerato', 'Christian Ramos ', '3214979083', '', 'INCOMPLETO', NULL, 'firma', 'Carrera 72 p No 38a 44', NULL, 'Kennedy', 121, 'Alejandro Duque Castrillon', '294A', 20),
(74, '294B', '6.167272,-75.56336', '6.167272', '-75.56336', '2023-09-01', 'Colegio Santo Domingo Bilingüe sede primaria', 'Cristian Ramos/Amanda Solano', '3214979083', '', 'INCOMPLETO', NULL, 'firma', 'Carrera 73 No. 36A - 36 Sur ', NULL, 'Kennedy', 122, 'Alejandro Duque Castrillon', '294B', 20),
(75, '300', '4.647272289243121,-74.14672851562501', '4.647272289243121', '-74.14672851562501', '2023-08-29', 'Centro Administrativo ', 'Claudia Viviana Villalobos Fagua ', '3168725902', '', 'INCOMPLETO', NULL, 'firma', 'Calle 11 #8-17 bo', NULL, 'Santa Fe', 123, 'Alejandro Duque Castrillon', '300', 20),
(76, '301', '4.69718,-74.127511', '4.69718', '-74.127511', '2023-09-20', ' Jardín Botánico de Bogotá ', 'Luis Alfonso Sandoval Rico ', '3133871935', '', 'INCOMPLETO', NULL, 'firma', 'Av calle 63 # 68- 95 Jardín Botánico de Bogotá ', NULL, 'Engativá', 124, 'Alejandro Duque Castrillon', '301', 20),
(77, '303', '4.7262916,-74.111888', '4.7262916', '-74.111888', '2023-09-19', 'Conjunto Tamarindos', 'Diana Bermudez', '3144121746', 'Conjunto Tamarindos', 'INCOMPLETO', NULL, 'firma', 'Cra 112F 80-59 Conjunto Tamarindos', NULL, 'Engativá', 125, 'Alejandro Duque Castrillon', '303', 20),
(78, '304', '11.003935,-74.807955', '11.003935', '-74.807955', '2023-10-04', 'Colegio Julio Florez', 'EIMMY RODRÌGUEZ A.', '3016367529,3046130484', 'Colegio Julio Florez', 'INCOMPLETO', NULL, 'firma', 'Carrera 68B #94-12 Colegio Julio Florez', NULL, 'Suba', 126, 'Alejandro Duque Castrillon', '304', 20),
(79, '306', '4.5080182,-74.0846664', '4.5080182', '-74.0846664', '2023-10-02', 'Colegio', 'Yanet González Cárdenas ', '7920458 ,3002068669', 'el Tesoro de la cumbre', 'INCOMPLETO', NULL, 'firma', ' Calle 81 sur No. 18M-02 ', NULL, 'Ciudad Bolívar', 127, 'Alejandro Duque Castrillon', '306', 20),
(80, '309', '4.667404,-74.069079', '4.667404', '-74.069079', '2023-09-19', 'Colegio', 'Nathalí Rozo Gaitan ', '3186128824', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 74A # 73A 85', NULL, 'Engativá', 128, 'Alejandro Duque Castrillon', '309', 20),
(81, '311', '4.627193183125919,-74.14775848388673', '4.627193183125919', '-74.14775848388673', '2023-09-05', 'Conjunto Rincon de Castilla', 'Armando valderrama Angarita ', '3183684837', 'Propiedad Horizontal', 'INCOMPLETO', NULL, 'firma', 'Diagonal 9#78c-42 Conjunto Rincon de Castilla', NULL, 'Kennedy', 129, 'Alejandro Duque Castrillon', '311', 20),
(82, '313', '4.625325,-74.1677964', '4.625325', '-74.1677964', '2023-09-01', 'Institucional', 'Yamile Arévalo /Cristian Oviedo', '3143960319', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Cl. 42G Sur #89-17', NULL, 'Kennedy', 130, 'Alejandro Duque Castrillon', '313', 20),
(83, '314', '4.625325,-74.1677964', '4.625325', '-74.1677964', '2023-09-01', 'Institucional', 'Yamile Arévalo /Cristian Oviedo', '3143960319', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Cl. 42G Sur #89-17', NULL, 'Kennedy', 131, 'Alejandro Duque Castrillon', '314', 20),
(84, '319', '6.2816389,-75.4390589', '6.2816389', '-75.4390589', '2023-09-08', 'Propiedad Horizontal', 'Xiomara Hernández Castillo ', '3134831181', 'Propiedad Horizontal', 'INCOMPLETO', NULL, 'firma', 'Carrera 20 N 187 40 ', NULL, 'Usaquén', 132, 'Alejandro Duque Castrillon', '319', 20),
(85, '325', '4.693727,-74.030102', '4.693727', '-74.030102', '2023-09-19', 'Institucional', 'Sara Ximena González Quimbayo', '3012889309', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'localidad usaquen Kra 8D # 158-09', NULL, 'Usaquén', 133, 'Alejandro Duque Castrillon', '325', 20),
(86, '326', '4.6506001,-74.0722484394054', '4.6506001', '-74.0722484394054', '2023-10-30', 'Huerta', 'Harry Norberto Palacios Amado ', '3186263470', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Carrera 24 b n 37-62 sur bogota', NULL, 'Rafael Uribe Uribe', 134, 'Alejandro Duque Castrillon', '326', 20),
(87, '331', '4.7095264,-74.0280281', '4.7095264', '-74.0280281', '2023-09-21', 'Colegio Altamira/Miller Morales Duarte', 'MILENA RUIZ MORA ', '3134001978', '', 'INCOMPLETO', NULL, 'firma', 'Calle 131# 77-04 Colegio Altamira/Miller Morales Duarte', NULL, 'San Cristóbal', 135, 'Alejandro Duque Castrillon', '331', 20),
(88, '332', '5.0322583000000005,-73.9920644', '5.0322583000000005', '-73.9920644', '2023-09-08', 'Jardin Chico Navarra', 'Maria Carolina Mercado Rey ', '3154404948', '', 'INCOMPLETO', NULL, 'firma', 'Calle 101 # 19 A - 28 Jardin Chico Navarra', NULL, 'Usaquén', 136, 'Alejandro Duque Castrillon', '332', 20),
(89, '335', '7.0745207,-73.11212685000001', '7.0745207', '-73.11212685000001', '2023-10-30', 'origami Mazurén ', 'Nataly Agathon Mancera/Monica Merchan', '3016477270', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 153 # 50 - 95 origami Mazurén ', NULL, 'Suba', 137, 'Alejandro Duque Castrillon', '335', 20),
(90, '339', '4.742183009642097,-74.08493041992189', '4.742183009642097', '-74.08493041992189', '2023-10-04', ' Colegio Altamira/Miller Morales Duarte', 'Viviana Molina ', '3106977033', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'localidad suba bogota', NULL, 'Suba', 138, 'Alejandro Duque Castrillon', '339', 20),
(91, '342', '6.2816389,-75.4390589', '6.2816389', '-75.4390589', '2023-10-11', 'Huerta', 'Edgar fidel Carrero alvarez/Laura Carrero Vanegas', '3125939824', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Kilometro 13 vía San Juan de Sumapaz vereda San Rosa del Hato', NULL, 'Usme', 139, 'Alejandro Duque Castrillon', '342', 20),
(92, '348', '4.686042,-74.051471', '4.686042', '-74.051471', '2023-10-17', 'Colegio Campestre Jaime Garzon', 'Javier Valero ', '3138635513', '', 'INCOMPLETO', NULL, 'firma', 'Sumapaz, Bogotá', NULL, 'Sumapaz', 140, 'Alejandro Duque Castrillon', '348', 20),
(93, '350', '4.66605,-74.055766', '4.66605', '-74.055766', '2023-09-12', ' CC Atlantis Plaza', 'Esteban Arias', '3504946341', 'Centro Comercial', 'INCOMPLETO', NULL, 'firma', 'Calle 81 # 13-06 CC Atlantis Plaza', NULL, 'Chapinero', 141, 'Alejandro Duque Castrillon', '350', 20),
(94, '351', '4.686042,-74.051471', '4.686042', '-74.051471', '2023-10-17', 'Huerta', 'Yeison Fernando Páez Mendoza ', '3138055347', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Sumapaz, Bogotá', NULL, 'Sumapaz', 142, 'Alejandro Duque Castrillon', '351', 20),
(95, '353', '4.9127426,-74.0184271', '4.9127426', '-74.0184271', '2023-09-20', 'Universidad', 'Alexander Umaña ', '3187157699', 'Universidad', 'INCOMPLETO', NULL, 'firma', 'Cra 7a #179-03 bogota', NULL, 'Usaquén', 143, 'Alejandro Duque Castrillon', '353', 20),
(96, '354', '4.7956896,-74.0581365', '4.7956896', '-74.0581365', '2023-09-29', 'Colegio', 'Rubi Penagos Castellanos ', '3144843300', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Cra 77 B #74-02', NULL, 'Engativá', 144, 'Alejandro Duque Castrillon', '354', 20),
(97, '355', '4.67529755,-74.1484971278545', '4.67529755', '-74.1484971278545', '2023-09-29', 'Colegio', 'Silvia Johanna Gutierrez Robles', '3017274248', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 16J 97-20 bogota', NULL, 'Fontibón', 145, 'Alejandro Duque Castrillon', '355', 20),
(98, '356', '7.8378496,-72.4732815', '7.8378496', '-72.4732815', '2023-10-04', 'Institucional', 'Felipe Andrés Cañón León ', '3132816116', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'AVENIDA CALLE 1 N 24C-10', NULL, 'Los Mártires', 146, 'Alejandro Duque Castrillon', '356', 20),
(99, '357', '4.9203146,-74.0186701', '4.9203146', '-74.0186701', '2023-10-13', 'Huerta', 'Ruth Arévalo Salazar ', '3166347288', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Kra 5 B Este No 100 B 35 sur bogota', NULL, 'Usme', 147, 'Alejandro Duque Castrillon', '357', 20),
(100, '358', '4.92290715,-74.0225926', '4.92290715', '-74.0225926', '2023-10-13', 'Huerta', 'Lina tatiana garzon garzon ', '3204461158', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Carrera 3 bis # 55 b 66 sur bogota', NULL, 'Usme', 148, 'Alejandro Duque Castrillon', '358', 20),
(101, '359', '1.049829,-77.452964', '1.049829', '-77.452964', '2023-10-13', 'Huerta', 'Jenny Andrea Liberato Murcia ', '3212184445', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Vereda el Uval Finca el pedregal Usme ', NULL, 'Usme', 149, 'Alejandro Duque Castrillon', '359', 20),
(102, '361', '4.9215492,-74.0228684', '4.9215492', '-74.0228684', '2023-10-12', 'Propiedad Horizontal', 'Oscar Edilmer Castro Moreno ', '3184505948', 'Propiedad Horizontal', 'INCOMPLETO', NULL, 'firma', 'Calle 7 # 90-64 bogota', NULL, 'Kennedy', 150, 'Alejandro Duque Castrillon', '361', 20),
(103, '26', '4.753919364384137,-74.07632741717418', '4.753919364384137', '-74.07632741717418', '2023-09-18', '', 'Libardo Castiblanco Lesmes', '3046241557', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'carrera 90 # 159 A 48 Interior 3', 'carrera 90 # 159 A 48 Interior 3', '', 151, 'Rodrigo Andrés rios', '26', 20),
(104, '33', '4.66660703463219,-74.01879829178954', '4.66660703463219', '-74.01879829178954', '2023-09-11', '', 'Martha Belén Hernandez Alba', '3012150278', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'calle 96 C # 12 - 06 Este Interior 1', 'calle 96 C # 12 - 06 Este Interior 1', '', 152, 'Rodrigo Andrés rios', '33', 20),
(105, '38', '4.62672575,-74.08477845', '4.62672575', '-74.08477845', '2023-08-25', 'Fundación Inti Huasi Casa del Sol', 'Diana Aguiree', '3173792960', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'CAlle 25 bis # 31 A 93 Bogotá', 'CAlle 25 bis # 31 A 93 Bogotá', 'Gran America', 153, 'Rodrigo Andrés rios', '38', 20),
(106, '43', '9.102372,-74.98065', '9.102372', '-74.98065', '2023-10-10', 'Finaca El pantano', 'Maria Felida Torre Valcarcel', '3219127589', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Finca el pantano Bogotá', 'Finca el pantano Bogotá', 'La requilina', 154, 'Rodrigo Andrés rios', '43', 20),
(107, '48', '4.559102116807596,-74.00455225171353', '4.559102116807596', '-74.00455225171353', '2023-10-10', 'Finca San José', 'Jaider Mauricio Paez Rubio', '3114543079', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Km 1 via Hato Finca San José Bogotá', 'Km 1 via Hato Finca San José Bogotá', 'Vereda Chiguaza', 155, 'Rodrigo Andrés rios', '48', 20),
(108, '55', '4.61882,-74.155804', '4.61882', '-74.155804', '2023-10-09', 'Finca El Portal de la montaña', 'Neftali Carreño Gomez', '3125129206', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Finca el portal de la montaña Bogotá', 'Finca el portal de la montaña Bogotá', 'Vereda Olarte', 156, 'Rodrigo Andrés rios', '55', 20),
(109, '57', '4.62572837523573,-74.06731727083151', '4.62572837523573', '-74.06731727083151', '2023-08-29', 'Ministerio de Ambiente', 'Julio Rodriguez Bernal', '3155671460', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Ministerio de ambiente Carrera 13 # 37 - 38 Bogotá', 'Ministerio de ambiente Carrera 13 # 37 - 38 Bogotá', 'Santa Fé', 157, 'Rodrigo Andrés rios', '57', 20),
(110, '60', '4.685649,-74.060422', '4.685649', '-74.060422', '2023-09-18', 'Omaira Cifuentes Useche', 'Omaira Cifuentes Useche', '3144798416', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Calle 97 # 8 - 35 Este Bogotá', 'Calle 97 # 8 - 35 Este Bogotá', 'San Luis', 158, 'Rodrigo Andrés rios', '60', 20),
(111, '62', '6.2521859,-75.425758', '6.2521859', '-75.425758', '2023-10-09', 'Finca Quebradas', 'Hector Chipotecua Fosca', '3016060248', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Finca Quebradas Bogotá', 'Finca Quebradas Bogotá', 'Vereda El Uval', 159, 'Rodrigo Andrés rios', '62', 20),
(112, '64', '4.4856245,-74.0978432', '4.4856245', '-74.0978432', '2023-10-11', 'JAC Villa Alemana II', 'Libardo Lozano Yate', '3124683531', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Junta de Acción Comunal Calle 113 sur # 3-13 Bogotá', 'Junta de Acción Comunal Calle 113 sur # 3-13 Bogotá', 'Villa Alemana II', 160, 'Rodrigo Andrés rios', '64', 20),
(113, '67', '4.7178238,-74.0355867', '4.7178238', '-74.0355867', '2023-10-09', '', 'Plinio Muñoz Lagos', '3123261901', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Calle 138 A sur # 12-07 ', 'Calle 138 A sur # 12-07 ', 'Centro ', 161, 'Rodrigo Andrés rios', '67', 20),
(114, '68', '6.252177,-75.4257418', '6.252177', '-75.4257418', '2023-10-09', 'Finca San Luis', 'Nidia Mora Chaparro', '3213732616', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Finca San Luis Bogotá', 'Finca San Luis Bogotá', 'Vereda El destino', 162, 'Rodrigo Andrés rios', '68', 20),
(115, '69', '4.667,-74.116389', '4.667', '-74.116389', '2023-08-28', '', 'Yuly Katerine Rincón Mendez', '3223722045', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Carrera 74 # 42 g 52 Sur CDC Lago Timiza Bogota', 'Carrera 74 # 42 g 52 Sur CDC Lago Timiza Bogota', 'Timiza', 163, 'Rodrigo Andrés rios', '69', 20),
(116, '72', '4.4988622,-74.086035', '4.4988622', '-74.086035', '2023-10-03', 'Fundación Don Bosco', 'Fabio Hernando Ortíz', '3115531813', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Fundación Don Bosco Calle 91 Sur # 4- 22 Este Bogotá', 'Fundación Don Bosco Calle 91 Sur # 4- 22 Este Bogotá', 'Chuniza', 164, 'Rodrigo Andrés rios', '72', 20),
(117, '74', '4.602144583660102,-74.0622864333833', '4.602144583660102', '-74.0622864333833', '2023-09-08', 'CAI Monserrate', 'Sandra Patricia Machuca Rodriguez', '3192145108', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'CAI Monserrate Carrera 2 Este Bogotá', 'CAI Monserrate Carrera 2 Este Bogotá', 'Monserrate', 165, 'Rodrigo Andrés rios', '74', 20),
(118, '76', '4.7415962,-74.1095437', '4.7415962', '-74.1095437', '2023-09-20', '', 'Dolly Calderon ', '3138148854', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Transversal 126 # 133 - 35 Bogotá', 'Transversal 126 # 133 - 35 Bogotá', 'La Gaitana', 166, 'Rodrigo Andrés rios', '76', 20),
(119, '78', '4.4856245,-74.0978432', '4.4856245', '-74.0978432', '2023-10-11', '', 'Ignacio Viajan Humo', '3202798747', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Calle 113 sur # 4-13 Bogotá', 'Calle 113 sur # 4-13 Bogotá', 'Villa Alemania', 167, 'Rodrigo Andrés rios', '78', 20),
(120, '79', '4.6889311,-74.0309723', '4.6889311', '-74.0309723', '2023-10-05', 'Colegio Eduardo Umaña Mendoza', 'Diana Catalina Tellez Ortíz', '3057128262', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 111 A sur # 4B - 07 Este Bogotá', 'Calle 111 A sur # 4B - 07 Este Bogotá', 'Villa Alemania', 168, 'Rodrigo Andrés rios', '79', 20),
(121, '81', '4.548598,-74.095721', '4.548598', '-74.095721', '2023-09-26', 'Centro Proteger La María', 'Felipe Andrés Cañón León', '3132816116', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Carrera 3 A # 10 - 26 Sur Bogotá', 'Carrera 3 A # 10 - 26 Sur Bogotá', 'La Maria', 169, 'Rodrigo Andrés rios', '81', 20),
(122, '83', '4.600896,-74.073745', '4.600896', '-74.073745', '2023-09-07', '', 'Gloria Esthér Jimenez Cabrejo ', '3105619617', 'Propiedad Horizontal', 'INCOMPLETO', NULL, 'firma', 'Carrera 32 A # 25 B 75 Conjunto mirador de tacai torre 2 apto 1104 Bogotá', 'Carrera 32 A # 25 B 75 Conjunto mirador de tacai torre 2 apto 1104 Bogotá', 'Gran America', 170, 'Rodrigo Andrés rios', '83', 20),
(123, '88', '4.678081,-74.042904', '4.678081', '-74.042904', '2023-09-14', 'Fundación Niños', 'Lucinda Lancheros Martinez', '3012671241', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Carrera 4 B Este # 162 c 96 Bogotá', 'Carrera 4 B Este # 162 c 96 Bogotá', 'Santa Cecilia', 171, 'Rodrigo Andrés rios', '88', 20),
(124, '91', '4.6385765,-74.0671923', '4.6385765', '-74.0671923', '2023-09-05', '', 'Maria Consuelo Arevalo Valderrama', '3173311007', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Calle 51 A # 27 -51 Bogotá', 'Calle 51 A # 27 -51 Bogotá', 'Galerias', 172, 'Rodrigo Andrés rios', '91', 20),
(125, '92', '4.658554956408209,-74.08078321603328', '4.658554956408209', '-74.08078321603328', '2023-08-28', 'Salón Comunal', 'Yeison David Barragán Becerra', '3168502276', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Calle 11 B # 80 b 54 Salón Comunal Bogotá', 'Calle 11 B # 80 b 54 Salón Comunal Bogotá', 'Santa Catalina Sector I y II', 173, 'Rodrigo Andrés rios', '92', 20),
(126, '100', '4.596097,-74.091545', '4.596097', '-74.091545', '2023-09-05', '', 'Franklin Garcia Celeita', '3057069150', 'Propiedad Horizontal', 'INCOMPLETO', NULL, 'firma', 'Calle 2 # 89 - 35 Portales de primavera MZ 13 Bogotá', 'Calle 2 # 89 - 35 Portales de primavera MZ 13 Bogotá', 'Patio bonito', 174, 'Rodrigo Andrés rios', '100', 20),
(127, '101', '4.640533,-74.066006', '4.640533', '-74.066006', '2023-09-18', 'UAESP', 'Olga Bonilla Gonzalez ', '3166229757', 'Institucional', 'INCOMPLETO', NULL, 'firma', 'Avenida Caracas # 53 - 80 Bogotá', 'Avenida Caracas # 53 - 80 Bogotá', 'Chapinero', 175, 'Rodrigo Andrés rios', '101', 20),
(128, '105', '4.562273354038218,-74.11373474654236', '4.562273354038218', '-74.11373474654236', '2023-10-02', 'Colegio Unión Europea IED', 'Eliana Constanza Gordillo Gomez', '3208664744', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 18 M # 63 B 09 Sur Bogotá', 'Carrera 18 M # 63 B 09 Sur Bogotá', 'Lucero Medio', 176, 'Rodrigo Andrés rios', '105', 20),
(129, '106', '6.2700323,-75.4387402', '6.2700323', '-75.4387402', '2023-08-29', 'Colegio El Jazmin IED', 'Aldemar Garcia Rincón', '3243645827', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 1 H # 40 D 13 Bogotá ', 'Calle 1 H # 40 D 13 Bogotá ', 'El Jazmin', 177, 'Rodrigo Andrés rios', '106', 20),
(130, '107', '4.77018,-74.0673478', '4.77018', '-74.0673478', '2023-09-26', 'Colegio Los Naranjos', 'Claudia Milena Galindo ', '3054253206', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 80 M # 71 C sur 31 Bogotá', 'Carrera 80 M # 71 C sur 31 Bogotá', 'Los naranjos', 178, 'Rodrigo Andrés rios', '107', 20),
(131, '110', '4.602454,-74.087822', '4.602454', '-74.087822', '2023-09-01', 'Colegio Castilla IED', 'William Rendón', '3188223051', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 78 C # 8 A 43 Bogotá', 'Carrera 78 C # 8 A 43 Bogotá', 'Castilla', 179, 'Rodrigo Andrés rios', '110', 20),
(132, '115', '4.6561096,-74.0464676', '4.6561096', '-74.0464676', '2023-10-03', 'Colegio Almirante Padilla Sede A', 'Angela Viviana Gamez Bernal ', '3002321675', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 76 A sur # 1 D 59 este Bogotá', 'Calle 76 A sur # 1 D 59 este Bogotá', 'Almirante Padilla', 180, 'Rodrigo Andrés rios', '115', 20),
(133, '117', '4.561324,-74.125177', '4.561324', '-74.125177', '2023-09-07', 'Colegio Ciudadela Educativa de Bosa', 'Olga Lucia Parra Dimaté ', '3102718583', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 52 sur # 97 C 35 Bogotá', 'Calle 52 sur # 97 C 35 Bogotá', 'Porvenir', 181, 'Rodrigo Andrés rios', '117', 20),
(134, '118', '4.6262071,-74.0700833', '4.6262071', '-74.0700833', '2023-08-28', 'INEM Kennedy ', 'Edith Constanza Negrete Soler', '3157830260', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 38 C sur # 79 - 08 Bogotá', 'Calle 38 C sur # 79 - 08 Bogotá', 'Central', 182, 'Rodrigo Andrés rios', '118', 20),
(135, '120', '4.482828,-74.0972644', '4.482828', '-74.0972644', '2023-10-05', 'Colegio ', 'Yaneth Gonzalez ', '3107572607', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Autopista al LLano Km 8 Vereda el Uval Bogotá', 'Autopista al LLano Km 8 Vereda el Uval Bogotá', 'Vereda El Uval', 183, 'Rodrigo Andrés rios', '120', 20),
(136, '122', '4.5440566,-74.1376345', '4.5440566', '-74.1376345', '2023-10-02', 'Colegio Sotavento ', 'Iris Johanna Chaparro ', '3226643455', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 73 A sur # 16 T 27 Bogotá', 'Calle 73 A sur # 16 T 27 Bogotá', 'Sotavento', 184, 'Rodrigo Andrés rios', '122', 20),
(137, '126A', '4.7259462,-74.0847747', '4.7259462', '-74.0847747', '2023-08-28', 'Colegio Gabriel Betancour Mejía Sede A', 'Liliana Sepulveda Olmos', '3108623393', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 87 A # 6 A 23 Bogotá', 'Carrera 87 A # 6 A 23 Bogotá', 'Tintal', 185, 'Rodrigo Andrés rios', '126A', 20),
(138, '126B', '4.6404153,-74.141867', '4.6404153', '-74.141867', '2023-08-28', 'Colegio Gabriel Betancour Mejía Sede B', 'Liliana Sepulveda Olmos', '3108623393', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 8a Bis #94-72, Bogotá', 'Calle 8a Bis #94-72, Bogotá', 'Tintal', 186, 'Rodrigo Andrés rios', '126B', 20),
(139, '126C', '4.597517,-74.074139', '4.597517', '-74.074139', '2023-08-28', 'Colegio Gabriel Betancour Mejía Sede C', 'Liliana Sepulveda Olmos', '3108623393', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 11A #88a-27, Bogotá', 'Calle 11A #88a-27, Bogotá', 'Tintal', 187, 'Rodrigo Andrés rios', '126C', 20),
(140, '133', '4.6120798370145355,-74.08490557370214', '4.6120798370145355', '-74.08490557370214', '2023-09-18', 'Colegio Técnico Jaime Pardo Leal', 'Ingrid Ximena Arias Hodge', '3134759501', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 10 a # 3 -63 sur, Bogotá', 'Carrera 10 a # 3 -63 sur, Bogotá', 'Policarpa salabarrieta', 188, 'Rodrigo Andrés rios', '133', 20),
(141, '134', '4.5359285,-74.1104213', '4.5359285', '-74.1104213', '2023-09-07', '', 'Luz Alexandra Benitez Prieto ', '3116164137', 'Huerta', 'INCOMPLETO', NULL, 'firma', 'Calle 62 A sur # 86 B 29, Bogotá', 'Calle 62 A sur # 86 B 29, Bogotá', 'Villas del Velero', 189, 'Rodrigo Andrés rios', '134', 20),
(142, '135', '4.7603995,-74.0616236', '4.7603995', '-74.0616236', '2023-10-04', 'Colegio Bolivia ', 'Amelia Salazar Salazar ', '3167430288', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 68 g # 78 - 90, Bogotá', 'Carrera 68 g # 78 - 90, Bogotá', 'Las Ferias', 190, 'Rodrigo Andrés rios', '135', 20),
(143, '141', '4.6523165,-74.0560266', '4.6523165', '-74.0560266', '2023-09-06', 'Colegio IED Porfirio Barba jacob', 'Carlos Augusto Perez Medellín', '3016344352', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 70 A sur # 81 G 13, Bogotá', 'Calle 70 A sur # 81 G 13, Bogotá', 'Palestina', 191, 'Rodrigo Andrés rios', '141', 20),
(144, '142', '6.2700323,-75.4387402', '6.2700323', '-75.4387402', '2023-09-26', 'Colegio La Victoria', 'Claudia Marcela Rincón Rincón', '3015582681', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 3 B Este # 38 -25 Sur, Bogotá', 'Carrera 3 B Este # 38 -25 Sur, Bogotá', 'La Victoria', 192, 'Rodrigo Andrés rios', '142', 20),
(145, '144', '4.652849,-74.056601', '4.652849', '-74.056601', '2023-10-02', 'Colegio La Joya IED', 'Luis Gamboa Pinilla ', '3016384005', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 80 A sur # 18 C 70, Bogotá', 'Calle 80 A sur # 18 C 70, Bogotá', 'El Tesoro', 193, 'Rodrigo Andrés rios', '144', 20),
(146, '147', '4.607539,-74.135995', '4.607539', '-74.135995', '2023-09-29', 'Colegio IED Bravo Paez', 'Jorge Enrique Saenz ', '3162938510', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 37 Sur # 23 - 51, Bogotá', 'Calle 37 Sur # 23 - 51, Bogotá', 'Quiroga', 194, 'Rodrigo Andrés rios', '147', 20),
(147, '148', '4.597517,-74.074139', '4.597517', '-74.074139', '2023-08-29', 'Colegio Antonio José de Sucre', 'Diana Marcela Espinoza Velasquez ', '3229360138', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 11 # 65 b 10, Bogotá', 'Calle 11 # 65 b 10, Bogotá', 'Salazar Gomez', 195, 'Rodrigo Andrés rios', '148', 20),
(148, '151', '4.7489421,-74.0450052', '4.7489421', '-74.0450052', '2023-09-11', 'Colegio ', 'Jesus Castro ', '3012893890', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 22 B # 16 - 03, Bogotá', 'Carrera 22 B # 16 - 03, Bogotá', 'Restrepo ', 196, 'Rodrigo Andrés rios', '151', 20),
(149, '152', '4.7821343,-74.0469116', '4.7821343', '-74.0469116', '2023-09-26', 'Colegio Venecia ', 'Orlando Hurtado', '3102231920', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 55 # 49-25 Sur, Bogotá', 'Carrera 55 # 49-25 Sur, Bogotá', 'Venecia', 197, 'Rodrigo Andrés rios', '152', 20),
(150, '153', '7.0774038,-73.1112929', '7.0774038', '-73.1112929', '2023-09-12', 'Colegio república de Panamá IED ', 'Luis forero ', '3112898797', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 149 # 117-35 ', 'Calle 149 # 117-35 ', 'San Fernando ', 198, 'Alejandro Duque Castrillon', '153', 20),
(151, '154B', '7.0774038,-73.1112929', '7.0774038', '-73.1112929', '2023-09-20', 'Colegio Compartir de Suba SEDE B', 'German Giovanni Arias Bernal ', '3192477642', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 149 # 117-35', 'Calle 149 # 117-35', 'Compartir', 199, 'Alejandro Duque Castrillon', '154B', 20),
(152, '156', '4.5600965,-74.1260465', '4.5600965', '-74.1260465', '2023-09-06', 'Colegio Brasilia Bosa', 'Mileny Sanabria Hernández', '6015241458,3114787881', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 53 Bis sur #87-08 Colegio Brasilia Bosa', 'Calle 53 Bis sur #87-08 Colegio Brasilia Bosa', 'Brasilia', 200, 'Alejandro Duque Castrillon', '156', 20),
(153, '159', '4.682959,-74.088005', '4.682959', '-74.088005', '2023-09-20', 'Colegio Magdalena Ortega', 'Zamira Gutiérrez', '3168292377', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 69B 78a 36', 'Carrera 69B 78a 36', 'Ferias', 201, 'Alejandro Duque Castrillon', '159', 20),
(154, '161A', '4.64966645,-74.05692355', '4.64966645', '-74.05692355', '2023-09-12', ' Colegio Jorge Eliecer Gaitan Sede A', 'Ingrid Bibiana Rodríguez Pinzón ', '3103129075', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 66A N° 56 – 25/ 56-35, bogota', 'Calle 66A N° 56 – 25/ 56-35, bogota', ' Popular modelo norte ', 202, 'Alejandro Duque Castrillon', '161A', 20),
(155, '162', '10.96006095,-74.80381295000001', '10.96006095', '-74.80381295000001', '2023-09-11', 'Colegio Toberin sede B', 'Carmen Lucía Arrieta Garzón', '3168328636', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 14C Nº 164-75 ', 'Carrera 14C Nº 164-75 ', 'Babilonia', 203, 'Alejandro Duque Castrillon', '162', 20),
(156, '165', '4.586031,-74.089684', '4.586031', '-74.089684', '2023-09-01', 'Colegio Kennedy', 'Carlos Alfonso Rodriguez Herrera/Luz Dary Cardenas', '3168328636', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 5 Sur 72A - 69 ', 'Calle 5 Sur 72A - 69 ', 'Cervantes', 204, 'Alejandro Duque Castrillon', '165', 20),
(157, '167', '4.4343964,-75.2026034', '4.4343964', '-75.2026034', '2023-09-28', 'Colegio Arborizadora baja', 'Lina Mireya Beltran D Aleman', '3154663848', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 59 I sur No 44a-02 Colegio Arborizadora baja', 'Calle 59 I sur No 44a-02 Colegio Arborizadora baja', 'Arborizadora Baja ', 205, 'Alejandro Duque Castrillon', '167', 20),
(158, '168', '4.7219096,-74.0657505', '4.7219096', '-74.0657505', '2023-09-14', 'Colegio Virginia Gutierrez de Pineda', 'Martha Cecilia Figueroa Sánchez ', '3192383824', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 131B No 94 F-31 Colegio Virginia Gutierrez de Pineda', 'Calle 131B No 94 F-31 Colegio Virginia Gutierrez de Pineda', 'Gloria Lara ', 206, 'Alejandro Duque Castrillon', '168', 20),
(159, '171', '7.1050736,-73.1294627', '7.1050736', '-73.1294627', '2023-10-05', 'Colegio Fancisco Antonio Zea Sede B', 'Sebastián Moreno Maldonado/Maryory Salas', '3014250688', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Transversal 2a 135-78 sur Colegio Fancisco Antonio Zea Sede B', 'Transversal 2a 135-78 sur Colegio Fancisco Antonio Zea Sede B', 'Centro', 207, 'Alejandro Duque Castrillon', '171', 20),
(160, '172', '6.441319,-71.793805', '6.441319', '-71.793805', '2023-08-28', 'colegio San José de Castilla sede A', 'Stella Vasquez Avila', '3103282683', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 78 f #7d-03 ', 'Carrera 78 f #7d-03 ', 'Castilla', 208, 'Alejandro Duque Castrillon', '172', 20),
(161, '173', '4.86571945,-72.9028025', '4.86571945', '-72.9028025', '2023-09-05', ' Colegio Dario Echandia', 'Blanca Cecilia Herrera Chacon', '3058136808', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 5A sur 88 B 08 Colegio Dario Echandia', 'Calle 5A sur 88 B 08 Colegio Dario Echandia', 'Patio bonito', 209, 'Alejandro Duque Castrillon', '173', 20),
(162, '174', '5.627044,-73.808596', '5.627044', '-73.808596', '2023-09-19', 'Colegio Distrital Simon Bolivar ', 'Mirtha Oxley Bello sanchez/Bibiana Tellez', '3134873786', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Colegio Distrital Simon Bolivar Carrera 92 No. 87A-60 Sede B', 'Colegio Distrital Simon Bolivar Carrera 92 No. 87A-60 Sede B', 'Quirigua', 210, 'Alejandro Duque Castrillon', '174', 20),
(163, '177', '4.5601496,-74.0969983', '4.5601496', '-74.0969983', '2023-09-27', 'IED Santa Lucia Cafam', 'Freddy Alexander Amaya Valero', '3106791063', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Diagonal 36 Sur #16b-26 IED Santa Lucia Cafam', 'Diagonal 36 Sur #16b-26 IED Santa Lucia Cafam', 'Granjas de San Pablo', 211, 'Alejandro Duque Castrillon', '177', 20),
(164, '180', '4.696879026871425,-74.13574218750001', '4.696879026871425', '-74.13574218750001', '2023-10-05', ' Colegio Fancisco D', 'Maria Rosalida Montiel', '3208859848', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 127b sur 13 05 Colegio ', 'Calle 127b sur 13 05 Colegio ', 'Centro', 212, 'Alejandro Duque Castrillon', '180', 20),
(165, '182', '4.5249317,-74.1172548', '4.5249317', '-74.1172548', '2023-10-03', 'colegio Santa Martha IED', 'Mayly Viviana Suta Uscátegui ', '3194750060', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 69D Sur #8B-63 (colegio Santa Martha IED)', 'Calle 69D Sur #8B-63 (colegio Santa Martha IED)', 'Venecia', 213, 'Alejandro Duque Castrillon', '182', 20),
(166, '189', '3.477429,-76.495799', '3.477429', '-76.495799', '2023-11-18', 'Colegio Luis Carlos Galan Sarmiento', 'María Rueda ', '3002899293', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 1B # 52A-02 Colegio Luis Carlos Galan Sarmiento', 'Calle 1B # 52A-02 Colegio Luis Carlos Galan Sarmiento', 'La Ponderosa ', 214, 'Alejandro Duque Castrillon', '189', 20),
(167, '196', '4.535593,-74.09309', '4.535593', '-74.09309', '2023-09-11', 'Colegio Campestre Monteverde', 'Heidy Paola Jimenez Medina', '3115883401', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Carrera 5C ESTE # 98 A 55 Colegio Campestre Monteverde', 'Carrera 5C ESTE # 98 A 55 Colegio Campestre Monteverde', '', 215, 'Alejandro Duque Castrillon', '196', 20),
(168, '198', '4.0762446,-73.6716447', '4.0762446', '-73.6716447', '2023-09-28', 'Colegio Angela Restrepo Moreno', 'Sor Irma Alejandra Rosas Zambrano', '3208589677', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'Calle 69 sur #71g-12 ', 'Calle 69 sur #71g-12 ', 'sierra morena ', 216, 'Alejandro Duque Castrillon', '198', 20),
(169, '2525', '4.6996245000000005,-74.14420799999999', '4.6996245000000005', '-74.14420799999999', '2023-11-01', 'Institucional', 'YEISON HERNAN', '3104624554', 'Colegio', 'INCOMPLETO', NULL, 'firma', 'autopista med bog km26 mall com loc25', 'autopista med bog km26 mall com loc25', 'Centro', 78, 'Alejandro Duque Castrillon', '2525', 20);
DROP TABLE IF EXISTS `registrodiarioestadooperacion`;
CREATE TABLE `registrodiarioestadooperacion` (
`id` int(11) NOT NULL,
`id_compostera` int(11) NOT NULL,
`fecha_registro` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`hora_registro` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`clima` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`temperatura` int(11) DEFAULT NULL,
`humedad` int(11) DEFAULT NULL,
`Pinsectos` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Proedores` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`descrPreolores` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Polor` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`MaterialEstructurante` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`CantidadME` int(11) DEFAULT NULL,
`Materialorganico` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`CantidadMO` int(11) DEFAULT NULL,
`cantidadCompost` int(11) DEFAULT NULL,
`FotoEstadoActual` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`TipoRegistro` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`id_quienRegistra` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `registrodiarioestadooperacion` (`id`, `id_compostera`, `fecha_registro`, `hora_registro`, `clima`, `temperatura`, `humedad`, `Pinsectos`, `Proedores`, `descrPreolores`, `Polor`, `MaterialEstructurante`, `CantidadME`, `Materialorganico`, `CantidadMO`, `cantidadCompost`, `FotoEstadoActual`, `TipoRegistro`, `id_quienRegistra`) VALUES
(24, 26, '2023-09-07', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, 'a3346712-22be-4968-bc11-c7f959fbe355.jpg', 'INICIAL', '73'),
(25, 27, '2023-10-12', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, 'c56b4892-4cd0-4238-be60-461e19e69b30.jpg', 'INICIAL', '73'),
(26, 28, '2023-08-26', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, '2dafd1c7-aa03-4ea0-ac08-d75e7c60748f.jpg', 'INICIAL', '73'),
(27, 29, '2023-08-25', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, 'ec1a30d3-7151-4758-a5db-5f04b390acf0.jpg', 'INICIAL', '73'),
(28, 30, '2023-09-12', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, 'c24deb58-7777-4d12-9de9-5136531d0e70.jpg', 'INICIAL', '73'),
(29, 31, '2023-08-26', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, 'a5f95287-a56b-4041-bc9c-88a2ef9dbf44.jpg', 'INICIAL', '73'),
(30, 32, '2023-09-12', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, '14f45e0e-226e-4e8c-82c7-afe07f322676.jpg', 'INICIAL', '73'),
(31, 33, '2023-10-11', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, '9c2e1a9e-c5b6-4008-b966-b2eaa0ecdc2c.jpg', 'INICIAL', '73'),
(32, 34, '2023-10-30', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(33, 35, '2023-10-30', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(34, 36, '2023-09-27', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(35, 37, '2023-09-27', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(36, 38, '2023-09-21', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(37, 39, '2023-10-02', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(38, 40, '2023-10-30', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(39, 41, '2023-09-05', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(40, 42, '2023-10-12', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(41, 43, '2023-09-26', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(42, 44, '2023-09-26', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(43, 45, '2023-09-21', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(44, 46, '2023-09-21', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(45, 47, '2023-09-25', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(46, 48, '2023-09-07', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(47, 49, '2023-09-27', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(48, 50, '2023-09-12', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(49, 51, '2023-09-14', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(50, 52, '2023-10-04', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(51, 53, '2023-10-11', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(52, 54, '2023-10-11', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(53, 55, '2023-09-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(54, 56, '2023-09-18', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(55, 57, '2023-09-27', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(56, 58, '2023-09-19', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(57, 59, '2023-09-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(58, 60, '2023-10-17', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(59, 61, '2023-10-03', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(60, 62, '2023-10-03', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(61, 63, '2023-10-30', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(62, 64, '2023-10-10', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(63, 65, '2023-10-18', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(64, 66, '2023-09-21', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(65, 67, '2023-09-06', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(66, 68, '2023-09-07', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(67, 69, '2023-10-10', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(68, 70, '2023-09-22', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(69, 71, '2023-09-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(70, 72, '2023-10-10', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(71, 73, '2023-09-01', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(72, 74, '2023-09-01', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(73, 75, '2023-08-29', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(74, 76, '2023-09-20', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(75, 77, '2023-09-19', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(76, 78, '2023-10-04', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(77, 79, '2023-10-02', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(78, 80, '2023-09-19', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(79, 81, '2023-09-05', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(80, 82, '2023-09-01', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(81, 83, '2023-09-01', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(82, 84, '2023-09-08', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(83, 85, '2023-09-19', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(84, 86, '2023-10-30', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(85, 87, '2023-09-21', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(86, 88, '2023-09-08', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(87, 89, '2023-10-30', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(88, 90, '2023-10-04', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(89, 91, '2023-10-11', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(90, 92, '2023-10-17', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(91, 93, '2023-09-12', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(92, 94, '2023-10-17', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(93, 95, '2023-09-20', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(94, 96, '2023-09-29', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(95, 97, '2023-09-29', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(96, 98, '2023-10-04', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(97, 99, '2023-10-13', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(98, 100, '2023-10-13', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(99, 101, '2023-10-13', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(100, 102, '2023-10-12', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(101, 103, '2023-09-18', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(102, 104, '2023-09-11', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(103, 105, '2023-08-25', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(104, 106, '2023-10-10', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(105, 107, '2023-10-10', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(106, 108, '2023-10-09', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(107, 109, '2023-08-29', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(108, 110, '2023-09-18', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(109, 111, '2023-10-09', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(110, 112, '2023-10-11', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(111, 113, '2023-10-09', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(112, 114, '2023-10-09', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(113, 115, '2023-08-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(114, 116, '2023-10-03', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(115, 117, '2023-09-08', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(116, 118, '2023-09-20', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(117, 119, '2023-10-11', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(118, 120, '2023-10-05', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(119, 121, '2023-09-26', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(120, 122, '2023-09-07', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(121, 123, '2023-09-14', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(122, 124, '2023-09-05', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(123, 125, '2023-08-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(124, 126, '2023-09-05', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(125, 127, '2023-09-18', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(126, 128, '2023-10-02', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(127, 129, '2023-08-29', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(128, 130, '2023-09-26', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(129, 131, '2023-09-01', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(130, 132, '2023-10-03', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(131, 133, '2023-09-07', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(132, 134, '2023-08-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(133, 135, '2023-10-05', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(134, 136, '2023-10-02', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(135, 137, '2023-08-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(136, 138, '2023-08-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(137, 139, '2023-08-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(138, 140, '2023-09-18', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(139, 141, '2023-09-07', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(140, 142, '2023-10-04', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(141, 143, '2023-09-06', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(142, 144, '2023-09-26', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(143, 145, '2023-10-02', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(144, 146, '2023-09-29', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(145, 147, '2023-08-29', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(146, 148, '2023-09-11', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(147, 149, '2023-09-26', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '73'),
(148, 150, '2023-09-12', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(149, 151, '2023-09-20', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(150, 152, '2023-09-06', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(151, 153, '2023-09-20', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(152, 154, '2023-09-12', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(153, 155, '2023-09-11', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(154, 156, '2023-09-01', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(155, 157, '2023-09-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(156, 158, '2023-09-14', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(157, 159, '2023-10-05', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(158, 160, '2023-08-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(159, 161, '2023-09-05', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(160, 162, '2023-09-19', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(161, 163, '2023-09-27', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(162, 164, '2023-10-05', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(163, 165, '2023-10-03', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(164, 166, '2023-11-18', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(165, 167, '2023-09-11', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(166, 168, '2023-09-28', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(167, 169, '2023-11-01', NULL, 'NA', NULL, NULL, 'NA', 'NA', NULL, 'NA', 'NA', 0, 'NA', 0, NULL, NULL, 'INICIAL', '1'),
(168, 30, '2023-11-01', '20:00', 'lluvioso', 15, 97, NULL, NULL, 'sin olor', 'no', 'NA', 1, 'NA', 2, NULL, '2b30cbd2-8c53-421f-84ea-8303ebdaa3d3.png', 'CARGABIOMASA', '78'),
(169, 30, '2023-11-01', '20:03', 'Soleado', 15, 97, NULL, NULL, 'mal olor acido', 'no', 'NA', 22, 'NA', 55, NULL, '269bc3dc-ed6b-4816-bb10-d7c392026c29.png', 'CARGABIOMASA', '78');
DROP TABLE IF EXISTS `softlogs`;
CREATE TABLE `softlogs` (
`id` int(11) NOT NULL,
`fecha` varchar(255) NOT NULL,
`hora` varchar(255) NOT NULL,
`descripcion` varchar(255) NOT NULL,
`responsable` varchar(255) NOT NULL,
`id_usuario` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
DROP TABLE IF EXISTS `usuarios`;
CREATE TABLE `usuarios` (
`id` int(11) NOT NULL,
`nombre` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
`user` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`password` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
`celular` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`identificacion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tipoIdentifi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`eps` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`arl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`caja_compensacion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fondo_pensiones` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Nivel_educativo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contacto_alternativo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cat_licencia_cond` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`registro_ingreso` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
`cargo` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
`dependencia` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`salarioMes` int(11) DEFAULT NULL,
`foto_perfil` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `usuarios` (`id`, `nombre`, `user`, `password`, `email`, `celular`, `identificacion`, `tipoIdentifi`, `eps`, `arl`, `caja_compensacion`, `fondo_pensiones`, `Nivel_educativo`, `contacto_alternativo`, `cat_licencia_cond`, `registro_ingreso`, `cargo`, `dependencia`, `salarioMes`, `foto_perfil`) VALUES
(1, 'Alejandro Duque Castrillon', 'dev', '$2a$08$DcBFeycAlRnmNsB65zjMWOlgkj4szgbCDU54O2UjMSlZAJ45ZRCja', 'alejodc412@gmail.com', '3022835914', '1216727457', '+A', 'Sura', 'Sura', 'comfama', 'porvenir', NULL, NULL, NULL, 'no', 'admin', NULL, 2000000, '84e243cd-0264-495c-861c-7768ce87c64c.png'),
(70, 'Evelyn Cárdenas Gutierrez ', 'evelyn.cardenas@aguasdebogota.com.co', '$2a$08$cdHi5SAKJebcXnqHXFTGQuLrZvsL6HKhozng7NJwbPvAs61xTiPCq', 'evelyn.cardenas@aguasdebogota.com.co', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'admin', 'DIRECCION', NULL, NULL),
(71, 'Alejandro duque Castrillon ', 'alejodc412@gmail.com', '$2a$08$cnshBmHWNe7TndJ1wCL0OeuGrWFs6H2MhWPaPTWutQ9rnv1GBVUEO', 'alejodc412@gmail.com', '3022835914', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(72, 'Alejandro duque Castrillon', 'alejodc412@gmail.com', '$2a$08$WTxOD3tKwmfW3.2jL.QA3uFcbZarEZX9n1vrE5TgYDDovnKauaJma', 'alejodc412@gmail.com', '3022835914', '1216727457', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(73, 'Rodrigo Andrés rios', 'a.rios@c-deg.com.co', '$2a$08$mQn/NLjrjDrAY07URpxyJeMlo3pbNJ8CpMWDN173laiViX2MwnfaS', 'a.rios@c-deg.com.co', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'admin', 'DIRECCION', NULL, NULL),
(74, 'Olga Moreno / Andrés Barrero', 'olga.moreno@aguasdebogota.com.co', '$2a$08$R4XmV1XNe/vNrqYwvjC2lujWbhTGKqURf/9QcXOchWWpZpdMzf/7O', 'olga.moreno@aguasdebogota.com.co', '3132071482', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(75, 'Neydi Alexandra Dueñas Leguizamon ', 'alexandradueas@gmail.com', '$2a$08$506cC1Kj0Tagx2q4EHYXtedOUZulC4DZ/IzDetGd3ZalX8M11JxH6', 'alexandradueas@gmail.com', '3046694938', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(76, 'Cesar Daniel Contreras Perez', 'danielcperez529@gmail.com', '$2a$08$py3sfCdyx1lESkuOfIzUcudbcv8OQ3.EjUHiKfyx6M.WDRUS9cE46', 'danielcperez529@gmail.com', '3043493477', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(77, 'Shirly Rocio Rey Pardo', 'shirly.reyp@gmail.com', '$2a$08$yqc5k/pQ0W7Q6JJ9LySEqenHNuuihdca3HYnUVTbofkrJatTbNmzq', 'shirly.reyp@gmail.com', '3103303587', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(78, 'Marisabel Tellez Rojas', 'marisabeltellez@gmail.com', '$2a$08$8dfHOhw6udBXFm.sVQpny.K0XaLhxv9Q4Lz5LgygPz6YUGh7ZuAvi', 'marisabeltellez@gmail.com', '6694467/3002614341', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(79, 'Pedro orlando Acosta Bejarano', '', '$2a$08$m04DW4zc9.ZKE1qt4VLVhe6uupayw3tkTamjcxfq6CDp6lNh71.Li', '', '3103207353', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(80, 'Laura Cristina Lesmes Posada', '', '$2a$08$TTBNiV1M2yM776/pI.jEge0XR9f3TaYiK8nGw8LP.uDxqfuwu.XxG', '', '6683600 Ext 136 3223085424', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(81, 'Martha Alejandra Villalba Contreras', '', '$2a$08$eO4pxlyeQfSiggDKcVhkzeMORSkywft7qDs213UCIr0OwcYACGHJu', '', '3144184258', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(82, 'Esteban Alejandro Alarcón Hurtado ', '', '$2a$08$Sc6dDWwyTtRPccHpn1gL7ucbQN0tiYp0B.5x/zOefG0sG0qrykCSi', '', '3242336232', '1031179596', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(83, 'Bibiana Villa', '', '$2a$08$4mI15cnGohYNbmwF4APzde3ouvg.lRpejsJ71nwUdU7LJstWcKTsm', '', '3166291113', '52104957', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(84, 'Irne Montaño Burbano', '', '$2a$08$IA9MxMow9RSVNaHyDIf7u.QOzSnekJcNOO6yLb8T5NChuhgbu3gty', '', '3108614171', '80124141', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(85, 'Margarita Sanabria Ortiz ', '', '$2a$08$c.qQ6bizulC4JL4zcjNmv.lsDUGLD2rDsryqKHbOB1Q1VPIt57kAO', '', '3215031051', '51951077', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(86, 'Andrea Carolina Hernández Macías ', '', '$2a$08$FW23nT7lDxaSPcf3tdNSq.DpcMyRir7N7LTYshTsrje1EAedEYnLW', '', '3058155640', '52897061', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(87, 'Fernando Duitama Parra', '', '$2a$08$9Uf6BYZ/.5Mm6hsSIC2l0OK119K8o8Uug8lLoJl9iGRv7zurI/MA2', '', '3145332172', '1023032868', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(88, 'Jhon Fredy Moreno Suárez /Carlos Peña Pineda', '', '$2a$08$pqyoHfaKdFuI0XfvkAAMHuIiHHFh3O0Rk3plkM0XhpD7W1d4bzMoa', '', '7610403- 3122443612 /3145332172', '1023001390', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(89, 'Franklin García celeita ', '', '$2a$08$RkWi25B1qA9BR.kEFK/CC.KBFeALaGnDCEmx3b6oPSrEyW9qFovoi', '', '3057069150', '79618023', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(90, 'Mayra Velez/ Aguas de Bogotá SA ESP', '', '$2a$08$7C3oO9M33anbFY7y2Us3OuFtHwN97bd0TTujQDzj.bTAhxd5i8.5S', '', '3166174279', '8301282861', 'NIT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(91, 'Luz Dary Martínez Rodríguez ', '', '$2a$08$MnfEBx5.L/4zJ3xxtrovFeJxmTuAz14YfurIu8l3GQ9B5ZyDBOyGK', '', '3212530450', '52170036', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(92, 'Sonia Temilda Diaz Quintero', '', '$2a$08$fAdEPn0M/wq.RkWjiDSnKemttamuQArzLEfNcq0SbvVYEVdABJTc.', '', '3104894862', '52732363', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(93, 'Katherine Sánchez ', '', '$2a$08$aclyqm9tZZjDtsZDPqglr.cvC1EK7a4C3hHzKgY8URmxjB97V/gJG', '', '3187922372', '1023907805', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(94, 'Oscar Giovany Mejia Galeano', '', '$2a$08$Ci.6eGV5sSN3CIceSakDN.9ga8RCgzGWDr9PVd4I8W7RXeye0QiYq', '', '3057184896', '14229111', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(95, 'Pedro Abril Rodriguez', '', '$2a$08$Vgk3EBMVvMB1aZ8H8cTz4uq0JMG8o3TMExFxAoDO6.rqV4BMFVb7a', '', '3115913183', '1192770743', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(96, 'Yuri Martinez/Francy Quiroga', '', '$2a$08$GlauE.eHYPabaRrTLpi0D.FetGcDYWa9xo7KMrQTmhvi4zABhfbFO', '', '3208360925', '1016049333', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(97, 'Liliana Umbarila Numpaque/Diana Rubiano', '', '$2a$08$AXm6qzuJ0QOxdtdgGWADO.8k0tCJb9j7lYs.eVGKKZ8Ai09rwsoIe', '', '3114551412,3134257227', '52951869', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(98, 'Laura Vanessa Lotero Zapata', '', '$2a$08$ckw/vC/YFT3YMVEVWl5bQOt0TslAf8ui8oh8E2wKsIl/SipS5lJnS', '', '3102017734', '1031169864', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(99, 'Laura Vanessa Lotero Zapata', '', '$2a$08$d06c4SDvs2yfCZZpRCs3tu4ZNRif0O1A.ex2uv1T2DOThmP59EhDe', '', '1031169864', '1031169864', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(100, 'Ariadna Díaz Monroy', '', '$2a$08$yji/AuaGNF1AVI64FcWGZ.q8c4Ii.FUtheZ4McvP4QlKSv6hVm83G', '', '3108655010', '51751685', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(101, 'German Leonel Sarmiento Cruz ', '', '$2a$08$tnrKOpuqwCvd8E2FfQLIquMlqOhDy7/Gqo3WlvQIueXB0beqKHUGi', '', '3203270944', '79971280', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(102, 'Carmen Lucy Ramirez ', '', '$2a$08$2ktPfTKqiUVQQEq83UYoAOCk8ruX4yrYGJLz5AlifFGL0V5EvTt0q', '', '3503694175', '25138330', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(103, 'Edgar Fernando Barbosa Pineda', '', '$2a$08$UKvNri7fLfa9wiJsRDjimOMfoYeQU04TT/nx2ycGeZx5Uc2wDW94W', '', '3045821463', '19465235', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(104, 'Diana Lizeth León Sierra', '', '$2a$08$QDC6Qs5kopeYsjYhP3iwq.nuZ.ZY28ospTEaZDqmyo4C7n8UoOUTW', '', '3185103934', '1022425430', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(105, 'Maria Mercedes Saenz Estupiñan', '', '$2a$08$odv7hf36ufqdedYMS/Na3O21229D4.ltPvge.DSMoMwzfyChq9TRC', '', '3222478114,3124276985', '1023869943', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(106, 'Ingrid caterine romero bejarano ', '', '$2a$08$AowMexnE77B/OzoRTvIcOe9quxL/Ao2/gqtHltzE1IXNSvW95EJR.', '', '3058174145', '53040553', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(107, 'Jorge Junior López Munca/Jorge Alberto Lopez Lopez', '', '$2a$08$YIAbjnRTR9x7B7HhSvsQ1.Wf3tDY0iJ8Q7SF5ESxTvyXqmdEqy1Gq', '', '3024211884', '1033816829', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(108, 'Yerli Marcela Barrera Huertas', '', '$2a$08$M2dOTkZRfhFwoakFeTiMvOo3AcKMv/54ls.QqwQIkpu6nwsoUvwua', '', '3134820255', '1022996155', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(109, 'Luz Herminda Parrado Mora', '', '$2a$08$trC..SvdbqU.KOPZW5iD8unVjo3qqVmjuJdB1PT8.XgdWN.tKjUeG', '', '3222357349', '20851818', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(110, 'María Teresa Pava ', '', '$2a$08$nwhglDPGyi.ko3okHazxC.hOnzcDj3dIYZgGp8LFbPd8ghwsRXPhK', '', '3144248780', '51843816', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(111, 'Flor Azucena López Bohórquez/Yolanda Bolivar Zambrano', '', '$2a$08$zOXPJP7WlpY0CHyXAX9VQ.3r6Kxk1bHnkrnI5.gRHGIoSXMfbQAhG', '', '3125660481', '23607377', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(112, 'Luis Hernando Tangarife suaza / Vladimir Bernal/Rosa Piedrahita ', '', '$2a$08$/JStYGMllcXKUcHp36c3muTtKnJMh8nBsTtXtuldRafmlegXpiGwa', '', '3058604025,3122382972', '15927836', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(113, 'Yisela Gómez Gutiérrez ', '', '$2a$08$retTZ0pl9zSiltZwRkUqX.h8sw.6rzS3pMO.CWPbL5Moq8M3d1Fo.', '', '3214170545', '39732186', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(114, 'Viviana Fonseca ', '', '$2a$08$R7uE8wBmXEhvP7tmx0mH0evQkF0nkz2Q9VRUJ9aMnQl8aJx20Uo7W', '', '3107628614,3214200874', '39810661', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(115, 'Wilson Alejandro Rodríguez Plazas/Claudia Patricia Serna/ Emanuel Cataño', '', '$2a$08$qzx5Ll4J4uEWUlXtx38lnObXUTg8nHLNQc0lU1vEqhEz4MwSCpD1i', '', ' 3124808078,3152430603', '79969324', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(116, 'Yuri Tatiana Salazar', '', '$2a$08$OYyNUEiOHUl1C80NFPvr1.6GkoYJfz8AGRnHYJv0Fz9g6TJrbMDHu', '', '3228965933', '1012410717', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(117, 'Diego arias ', '', '$2a$08$c.jotd5QU/Er2iKSbZPUgu3C206V8EDzL.z5B2Y9BT0so0jIcId1G', '', '3183426294', '1030553056', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(118, 'Vilma Velasquez', '', '$2a$08$ZaO5WHZPOhgK7ahKzqv2EOzzsCNoQHrkRP/PifShe.Am3mxfqxuWa', '', '3502646779', '21021083', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(119, 'Lindon arevalo vargas', '', '$2a$08$kB7hRkivo.FgVX9WLMfGA.E7rEJiah3rg0HYWYwGyH7iRWQL5NNHi', '', '3214939078', '79330642', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(120, 'Cesar ignacio chaves gutierrez ', '', '$2a$08$Aoq77cPTzlZhKsVUK4ix2.JBGaaagstH8AVZaJ7bt5P//OygyxhLW', '', '3233631449', '79817412', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(121, 'Christian Ramos ', '', '$2a$08$uQW3W0RljBcYTqeR4mDhg.Ln.3Is4H5Ib5gJgSyBLg822SyRc.sxa', '', '3214979083', '1026261460', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(122, 'Cristian Ramos/Amanda Solano', '', '$2a$08$A9Ylf2tad6RjLFxorx.bnOL4TP6Mpko5r8Mvn161NhDa7SWMS3Thu', '', '3214979083', '1026261460', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(123, 'Claudia Viviana Villalobos Fagua ', '', '$2a$08$ToXTbi9avNy2nAJ1r5snKu70o6BmCUD2/YURat9Aket5I.r2yq.cq', '', '3168725902', '1010173514', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(124, 'Luis Alfonso Sandoval Rico ', '', '$2a$08$pFKO6GEk.U2jgGe.B6ZST.IMtZDjrZtE.YwHlSsRuBF0Pgxb.9bCm', '', '3133871935', '79581145', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(125, 'Diana Bermudez', '', '$2a$08$.IYr.BNUqlsy1M4pI6kwuu.BMbuo0IYdKLEq.qW8RIiiSGThiBRby', '', '3144121746', '52466160', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(126, 'EIMMY RODRÌGUEZ A.', '', '$2a$08$CaayfS8WWRhxq1Oj8DaPhOXgBrmDtY5tzfTmTMb8k0tmyp.zGX2Q.', '', '3016367529,3046130484', '52834128', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(127, 'Yanet González Cárdenas ', '', '$2a$08$8NXGpftO0VRKHOKJnlf5CumzS0gwj5P4uy5TXKZchZUzam2dDS95a', '', '7920458 ,3002068669', '30054969', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(128, 'Nathalí Rozo Gaitan ', '', '$2a$08$PwYy5iFHfa./f.nzT.cl4u..iScwzQ1MBAGsD72Zp6jQp3QF9Q7Pq', '', '3186128824', '1016063077', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(129, 'Armando valderrama Angarita ', '', '$2a$08$9ukQUPz1RRQ8KkGTs5etFOncEvgV8Yv/lX5xgJfPvo3sgISoxeFES', '', '3183684837', '4253183', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(130, 'Yamile Arévalo /Cristian Oviedo', '', '$2a$08$6O2O8KvQ9fv1Rkblz.juh.AaKuvb1ea0SqPDGJnBcWHb2RqPIne6q', '', '3143960319', '51891614', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(131, 'Yamile Arévalo /Cristian Oviedo', '', '$2a$08$S38djGOwP1OIWWN4edCkb.yyIAkNwjk81rdx9I.vfMzhQBAQWJL16', '', '3143960319', '51891614', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(132, 'Xiomara Hernández Castillo ', '', '$2a$08$Vm9poNVe8J5foGYalmVop.9k8BtLBzfRk2bcSjMGlQ82/Mq09DMty', '', '3134831181', '35261597', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(133, 'Sara Ximena González Quimbayo', '', '$2a$08$J1nrbSbVICZVfccBALOyZOUO4gk9pSoXn6soJnO27tQv2MP3q0EKK', '', '3012889309', '1019116956', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(134, 'Harry Norberto Palacios Amado ', '', '$2a$08$iNWXY1/B1/ehi/ddZGwV7uCwSpjJgddyJYUPfKwgGL7mmAqHzaqxG', '', '3186263470', '79388639', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(135, 'MILENA RUIZ MORA ', '', '$2a$08$6VcMobdlFO1LoTiTuj9AT.WpBbd1EajbwwRSFLzx.8JMpU.g6Rimi', '', '3134001978', '52281393', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(136, 'Maria Carolina Mercado Rey ', '', '$2a$08$U89MbMbGv/qBSBEZm6eKUuk8uhZOp.w6iDQASC3snc91DCP4ftOs.', '', '3154404948', '53104089', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(137, 'Nataly Agathon Mancera/Monica Merchan', '', '$2a$08$7Jk7544XJzeZjaWsVMveVeJCiOW3X0MTyr6g.Td2p0.synpZrO.v6', '', '3016477270', '1084416191', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(138, 'Viviana Molina ', '', '$2a$08$QsoLqn.a39Qw7gw199Dv4.oXE69Week5NaeCJWUsFBOHEW41h7aRS', '', '3106977033', '1014231776', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(139, 'Edgar fidel Carrero alvarez/Laura Carrero Vanegas', '', '$2a$08$Cw08bbOWOp2f5hKA7CqqAOP/HIOd/yAToPZkJiegRV0QNH0btWHUe', '', '3125939824', '79257523', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(140, 'Javier Valero ', '', '$2a$08$pz1yoIBwqNZe1aFlV/9L2OBtSZU.p.KC.hLQ4vqT7YyBd83MeVPmu', '', '3138635513', '82390434', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(141, 'Esteban Arias', '', '$2a$08$k6PsH3.11R7RBTchtgT9ped3QNJw.wY/zgCXjzdyewCrb1ZIpcgpi', '', '3504946341', '1026562300', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(142, 'Yeison Fernando Páez Mendoza ', '', '$2a$08$K2mRPPVJ0a.GO8UVFubXQOs260w2dJnysfVdVyl.zVL2eQ9KxFrM2', '', '3138055347', '1022977504', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(143, 'Alexander Umaña ', '', '$2a$08$xp9XKrFznSkr.eMmS0bWSOorF8Ya8hKNBDT.x1QyqsiU.8gp405GG', '', '3187157699', '80064337', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(144, 'Rubi Penagos Castellanos ', '', '$2a$08$J0zShkCxNA41osIabAiyzOHSsaqa33rlIJkKt04da184MTns2uyVK', '', '3144843300', '21147540', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(145, 'Silvia Johanna Gutierrez Robles', '', '$2a$08$tv5zd8alSWvJA4nluKJN/eBOGNPBCpRposKds.7/EIOhVfDfuJ3fq', '', '3017274248', '52763786', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(146, 'Felipe Andrés Cañón León ', '', '$2a$08$KPIZQ0GyiCJCSfWIGLE.AOsCg6kTmrGZfTiLBcWQpxgLgYcKUp19q', '', '3132816116', '1018402454', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(147, 'Ruth Arévalo Salazar ', '', '$2a$08$hNBmtf0jBcsMNqJX.atlKefjeaps6hn7T/LVjqtecXcHbMJ0lapaW', '', '3166347288', '52096033', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(148, 'Lina tatiana garzon garzon ', '', '$2a$08$R8BO.eKmIzMVjiWraBYHmOQXP.9OSQWZBx9nz4/G44wXiAO8AcVim', '', '3204461158', '1033707611', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(149, 'Jenny Andrea Liberato Murcia ', '', '$2a$08$AoFsfgRwiB9cZ4hb3rZ7Zu.9kLSWTh6Wnf7Lej18BNnC/6VJCeBNS', '', '3212184445', '1022972414', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(150, 'Oscar Edilmer Castro Moreno ', '', '$2a$08$RVmL8/RHRG7UscsCzss0e.iI5YePtR.bPOZ85YVU6HtEJixUZ84Ve', '', '3184505948', '79614713', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(151, 'Libardo Castiblanco Lesmes', '', '$2a$08$pCSsKp1LRnYgioSAVVVdJOnaahrWOyNxzdDlEdUX8ZogU9SyaYMoS', '', '3046241557', '79869913', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(152, 'Martha Belén Hernandez Alba', '', '$2a$08$ZDbmkpH0NW7wKpSrqCDP..4YgKvXBqmk0UMwA7NYjbEiPxAWjwRWa', '', '3012150278', '28684958', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(153, 'Diana Aguiree', '', '$2a$08$Fx3xHkVmAplKOQa2gh.JS.MxvGakBgi7lf3IJwyODkajrf1f9oa1G', '', '3173792960', '9003510096', 'NIT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(154, 'Maria Felida Torre Valcarcel', '', '$2a$08$MPG94Nebmf0sv0R//e7hH.8i22F8LYZ0rC6FdDHG6ITLStvfgzXRW', '', '3219127589', '24089695', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(155, 'Jaider Mauricio Paez Rubio', '', '$2a$08$Z2UnoyPmNZUq5QU7lYDNSOl9utMVqBAGbwhwdI/fnd6iCE.RaUfEO', '', '3114543079', '1000693515', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(156, 'Neftali Carreño Gomez', '', '$2a$08$4tLb7lL2oq3UTCs58H9UnOcf/o//q5RdyMXTlOthJy/ZwY/o7Urz2', '', '3125129206', '19058975', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(157, 'Julio Rodriguez Bernal', '', '$2a$08$hj9vSLjCGSMZkZU6FGSYGOvu/wmDH1BBloDyxeotd7C56fgDRmeQG', '', '3155671460', '94460030', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(158, 'Omaira Cifuentes Useche', '', '$2a$08$2dfqFnxk7CobKDghneCN3.VDhKkxc8pfVythY9fEcTyHQWuSIO7PO', '', '3144798416', '52454468', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(159, 'Hector Chipotecua Fosca', '', '$2a$08$VBgGWGKa844GHuP5C1zceO0Y00/D/2CkOfg4X/SvvhewrUJaQ4N6.', '', '3016060248', '3231439', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(160, 'Libardo Lozano Yate', '', '$2a$08$.yMJCcvcoXJocbLb5Vcq1O.hEX/PKNjcdFYTscrKZwVz81xO/dDlm', '', '3124683531', '1022996767', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(161, 'Plinio Muñoz Lagos', '', '$2a$08$NZtqSiRP2qMsJEwNfqH79eyVcT3YVRDWhXtj42igZfFDaxtrB7ikm', '', '3123261901', '3231621', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(162, 'Nidia Mora Chaparro', '', '$2a$08$Sf018eLhOKwumnAh/oFxZ.cpjvnNpzCWsbtve4EjhWY21/QhFMHI.', '', '3213732616', '52745239', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(163, 'Yuly Katerine Rincón Mendez', '', '$2a$08$Gu6bbsvbWSMf0PLKyYmAU./zL3JuE1ls0am6bBrT/KqnreQJm8Jg2', '', '3223722045', '1030549155', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(164, 'Fabio Hernando Ortíz', '', '$2a$08$mhQ2Z7560hhGjYPFgGUAieLRZOqxvjV0RFta7xNjskf1gbrjU.JwO', '', '3115531813', '16801959', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(165, 'Sandra Patricia Machuca Rodriguez', '', '$2a$08$bEJRLetmSK56JX9jjIQxBOy0uMQmY/uzqJ3/XhPDX.csqOO6XHxMy', '', '3192145108', '51940004', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(166, 'Dolly Calderon ', '', '$2a$08$vfV0KYM7M5ncr1o70Lqw7ujaJ/loz9EW5.lLH/ExqJTnTVBnR.Poa', '', '3138148854', '65499174', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(167, 'Ignacio Viajan Humo', '', '$2a$08$MSaFDiqzqsd6VIgkecDR2eG4jX3RFBFvxVXDvj.gXCA1.C79wdeoG', '', '3202798747', '1022986982', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(168, 'Diana Catalina Tellez Ortíz', '', '$2a$08$9btlwqzGTu15QaJVjZjFvutIDAur3PB1Vh9Hf55CK/a7MGxc5UC8m', '', '3057128262', '52823543', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(169, 'Felipe Andrés Cañón León', '', '$2a$08$5gUb4/DDNb3lr7ZZv4kM/ebSW9a1rWM7xf3eeje25D1sJVivnKsfC', '', '3132816116', '1018402454', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(170, 'Gloria Esthér Jimenez Cabrejo ', '', '$2a$08$IwxjeeZUFYg8Qhr8HCno/.Lw5B5W8IjHminPy/ff8M9cB58BrCZX6', '', '3105619617', '51646396', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(171, 'Lucinda Lancheros Martinez', '', '$2a$08$Q0/otBWkdHPpRAdlZCqcJ.ZqqlYFhEL4L7C90iBKL4sA.QAEw5GvO', '', '3012671241', '39775561', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(172, 'Maria Consuelo Arevalo Valderrama', '', '$2a$08$P9j/eM1ouaUS6yVjJXo/gu167Vh8OxLNJh/6bqY.qLjbElQ/xtpeW', '', '3173311007', '51775546', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(173, 'Yeison David Barragán Becerra', '', '$2a$08$386.Y2ft/G2g.NC5EJql8uEKzXxhvVNXgowotOeNzONOusLzIQC8W', '', '3168502276', '1016063819', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(174, 'Franklin Garcia Celeita', '', '$2a$08$6PtbwyKF1RmAKyR3cOCTyONIFdMR8SVYZTSDOWE8LFZVC3aPHnNL2', '', '3057069150', '79618023', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(175, 'Olga Bonilla Gonzalez ', '', '$2a$08$mT/5FsVZMfuEU.Q6WheIWuJy7mcAoN9QsycGOUheqEQi16a6WFYy.', '', '3166229757', '1010160872', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(176, 'Eliana Constanza Gordillo Gomez', '', '$2a$08$3fr5MIxgxhPbrKCms7NGYuPwdzP1kHxSYcgQGbyIAMsmjbvoLsUZa', '', '3208664744', '51955368', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(177, 'Aldemar Garcia Rincón', '', '$2a$08$tZgarj5Z7kQh57XdFAjaWuGYMHW3Fw5ah8AXpjRANbwOjGNzMskf2', '', '3243645827', '79744696', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(178, 'Claudia Milena Galindo ', '', '$2a$08$NgseFy4qIE7OCbOFSJ9zJe20PWfWyEVPPF5UuJap8G2JYJ8qjFLGK', '', '3054253206', '28553092', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(179, 'William Rendón', '', '$2a$08$jDeaQDeJGOTOAZZzK8IXhuBMy8f3f9uzyD3df71SVxUGZXPTFmo/2', '', '3188223051', '1073672325', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(180, 'Angela Viviana Gamez Bernal ', '', '$2a$08$g3Y5wP5/fqIrMRvIq/PRM.W9cVF42pcE7OxuH4xa8/VVNcFYfz8xC', '', '3002321675', '53135828', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(181, 'Olga Lucia Parra Dimaté ', '', '$2a$08$7jTzpYMFcVRSDf9sf755Oul4RJleU3MjXJt5GquTEIIQNFkUjk686', '', '3102718583', '52841925', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(182, 'Edith Constanza Negrete Soler', '', '$2a$08$qteKQ/sAhiZjvpMVGzg1Dufa4osLgIGAdNHxUkdXUSgn6iJ9ZZMti', '', '3157830260', '51958962', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(183, 'Yaneth Gonzalez ', '', '$2a$08$MqHB/lVWKdzoYpTOOJYg9eWZ5DHfuluYxU6qABNIEhSwEkTHgPXmK', '', '3107572607', '52309406', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(184, 'Iris Johanna Chaparro ', '', '$2a$08$rGh/fPVLV93nlf41e4wgvOiHOrWSVeOsxuTJSgUAQqR6sI5NQfZyG', '', '3226643455', '52749778', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(185, 'Liliana Sepulveda Olmos', '', '$2a$08$nFni6x0qs2YniGeLAXQRK.VupF7ztYBEBmNUYW2JUN3xvKYPFYQ52', '', '3108623393', '39650822', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(186, 'Liliana Sepulveda Olmos', '', '$2a$08$/a0AHMV3PZI2B9.qjpMIweqYXBz5WHnt6xLdKa3GI0POvYOHXad/.', '', '3108623393', '39650822', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(187, 'Liliana Sepulveda Olmos', '', '$2a$08$n3R9sxAfD11Eo/hB8dnm7.cSSabovoHXQZuzrxePw8K20mTyL3CKO', '', '3108623393', '39650822', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(188, 'Ingrid Ximena Arias Hodge', '', '$2a$08$LTSjeHWWitqLNCe4aH6HiODddYGPSG9NtBWzx5bCcCKdp59SPNXbC', '', '3134759501', '1010208872', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(189, 'Luz Alexandra Benitez Prieto ', '', '$2a$08$ZMUZeHJEyyxDHsnsQSqWruxzntumMv2oSG9T.we8gwc2nh/PgRkTa', '', '3116164137', '52758939', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(190, 'Amelia Salazar Salazar ', '', '$2a$08$XZ9S5p/9rzT9YNa8uTyy6.wwZy5mcJpdFUEBBJ788ous0AsNnfnte', '', '3167430288', '51915891', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(191, 'Carlos Augusto Perez Medellín', '', '$2a$08$v36bNmk1WyOoX.RqDHZpouRecAcbBy8/JMMxretgL1Km1TL8Sv30G', '', '3016344352', '80228593', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(192, 'Claudia Marcela Rincón Rincón', '', '$2a$08$ICVrV9STOOdXXJeclHxtVu5HkN/OBvLsC0D6JHnkRBKpQtNrDatdW', '', '3015582681', '52853940', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(193, 'Luis Gamboa Pinilla ', '', '$2a$08$etHrTzfy5dPGgQZjLsqfH.UwTt1y/W0FrC/nJSpRo7VqRXn4cGfji', '', '3016384005', '80871640', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(194, 'Jorge Enrique Saenz ', '', '$2a$08$Jyl5RopKiVF4qoVjELcXg.LinMk3epxVW4cveqgi1oTRxHUlfM.Sa', '', '3162938510', '79701663', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(195, 'Diana Marcela Espinoza Velasquez ', '', '$2a$08$vyse11fGAUL5Zl.K/SlS9OA9Poa4.y.IDBc8XhfnonVr4BEW7N972', '', '3229360138', '1010173951', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(196, 'Jesus Castro ', '', '$2a$08$Zi6Z8H76rDMheLqMWPn9Xe4eocIjdAVMZd28HHirvLVHKQi8wo7Va', '', '3012893890', '79359032', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(197, 'Orlando Hurtado', '', '$2a$08$UvGLbg6a0qHiiL/tpk4aM.2lQMxhwZlnqYxgRAsSrWT9bQaEl1gFm', '', '3102231920', '19236382', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(198, 'Luis forero ', 'luis.forero@hotmail.es', '$2a$08$rfq04NfvQ2CLZIrPB3LleuHuiLNL9IuiZ5o4vUHpuGW6oCBN6WdiK', 'luis.forero@hotmail.es', '3112898797', '79804880', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(199, 'German Giovanni Arias Bernal ', 'ggarias@educacionbogota.edu.co', '$2a$08$BEVnqSAi8DVe.HYv.T8RL.zOffUVfGzMjreOU8L2Edz/3R1PYvBey', 'ggarias@educacionbogota.edu.co', '3192477642', '3199917', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(200, 'Mileny Sanabria Hernández', 'msanabriah@educacionbogota.edu.co', '$2a$08$lWxD9XWGpDbmVpV2EE41gu30w1MVxRohh4ohWpKZPt8EG7O6nbxhe', 'msanabriah@educacionbogota.edu.co', '6015241458,3114787881', '52009307', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(201, 'Zamira Gutiérrez', 'Zammive@hotmail.com', '$2a$08$kPsHqRrYGbxSM/H/.3oAoOI/LPN57BtXEACw0Nedqc/mHhbk1Mmy6', 'Zammive@hotmail.com', '3168292377', '52019535', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(202, 'Ingrid Bibiana Rodríguez Pinzón ', 'Ibrodriguezp@educacionbogota.edu.co', '$2a$08$8UQilHFYdLfYqUi0xoDfyeS8RW5xokuFamaFDDa4EnOhnfz1s14ye', 'Ibrodriguezp@educacionbogota.edu.co', '3103129075', '52354210', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(203, 'Carmen Lucía Arrieta Garzón', 'carrieta@educacionbogota.edu.co', '$2a$08$/wb57/XvjDNCNdLRMc6Zh.pHEKQCliaagcdNQw0HC5f1racWM3Az6', 'carrieta@educacionbogota.edu.co', '3168328636', '41700628', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(204, 'Carlos Alfonso Rodriguez Herrera/Luz Dary Cardenas', 'coldikennedy8@educacionbogota.edu.co', '$2a$08$nLNxocR0rJ/V3nG9LKzvFulTJQtBUQc4ledPmdffQ15CER8uEoTra', 'coldikennedy8@educacionbogota.edu.co', '3168328636', '19269817', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(205, 'Lina Mireya Beltran D Aleman', 'linabeltran@colarborizadorabaja.edu.co', '$2a$08$qZKSGk/.Sd1ceD722rXQu.0EOBzuzjJqgaiSI3zxxbBR2vRc9Wu2W', 'linabeltran@colarborizadorabaja.edu.co', '3154663848', '19269817', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(206, 'Martha Cecilia Figueroa Sánchez ', 'marthac2720@hotmail.com', '$2a$08$WxeVAL9RlqAOCgRqliLLvOlMYO53VCc2ZlNQyfh0IJ.pngG.t2oHm', 'marthac2720@hotmail.com', '3192383824', '51748911', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(207, 'Sebastián Moreno Maldonado/Maryory Salas', 'sebastianmoreno387e@educacionbogota.edu.co', '$2a$08$xAn5yHgtEPg6O2Ge39Gl9eUISb7WAALwpQ8jNxQLMMEFQIpvqv84y', 'sebastianmoreno387e@educacionbogota.edu.co', '3014250688', '1032412857', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(208, 'Stella Vasquez Avila', 'svasquez1@educacionboogota.edu.co', '$2a$08$Z28/bhXGrum1N2Lc0jzhBOg30teGjNmzPfQHn.MNX44SdAz226cYy', 'svasquez1@educacionboogota.edu.co', '3103282683', '51840004', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(209, 'Blanca Cecilia Herrera Chacon', 'coldidario8@educacionbogota.edu.co', '$2a$08$D/ezhhkddeDHQEM8/UgE5eandLQkha0a/dprdvreQY/6wSEiXyzq6', 'coldidario8@educacionbogota.edu.co', '3058136808', '52054762', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(210, 'Mirtha Oxley Bello sanchez/Bibiana Tellez', 'simoncienciasbolivar@gmail.com', '$2a$08$5a1Bym6zXcGn00OVa1yFvuf0t9m/CajffEEBz.vGrv6Q1GFbGBlM6', 'simoncienciasbolivar@gmail.com', '3134873786', '51734294', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(211, 'Freddy Alexander Amaya Valero', 'freddyaav@gmail.com', '$2a$08$/6zAx2GOA175KWYnT6tQPOVXSm/d//pAzXRHJgI9Xi6gtsJWsKYf.', 'freddyaav@gmail.com', '3106791063', '80726197', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(212, 'Maria Rosalida Montiel', 'maria.montiel430@educacionbogota.edu.co', '$2a$08$cn1DAxxEz.wN5d7Ek6waiO6qt7MBPJiMeYsvbcB5IqwGe78zphXcW', 'maria.montiel430@educacionbogota.edu.co', '3208859848', '1022923430', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(213, 'Mayly Viviana Suta Uscátegui ', 'mvsuta@educacionbogota.edu.co', '$2a$08$8UobNaAHz6WqevkMyzewhO6lj23fvpN.hlIVNQCLHiz4rcnX0iLZi', 'mvsuta@educacionbogota.edu.co', '3194750060', '52812561', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(214, 'María Rueda ', 'mruedaga@educacionbogota.edu.co', '$2a$08$ofcPbP375IdxzT7bRd/l6.XACh.QJ3iLFtqDdMEiFtGIWTfdnBhA.', 'mruedaga@educacionbogota.edu.co', '3002899293', '35506918', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(215, 'Heidy Paola Jimenez Medina', 'HPJIMENEZ@EDUCACIONBOGOTA.EDU.CO', '$2a$08$WehldPhRk9dVtTRvvYkWI.Ul3AmU685l/mzH3qH7iO.Fa.894a7fa', 'HPJIMENEZ@EDUCACIONBOGOTA.EDU.CO', '3115883401', '52086488', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL),
(216, 'Sor Irma Alejandra Rosas Zambrano', 'rectoriacedro@chinca.org.co', '$2a$08$pU3a/FTlWYMzRMEIKfEfKuMvMFyQRSiBrvhGI.R.Lf1t0Ow79oTSm', 'rectoriacedro@chinca.org.co', '3208589677', '1052380739', 'CC', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no', 'user1', 'CLIENTES', NULL, NULL);
ALTER TABLE `composteras`
ADD PRIMARY KEY (`id`);
ALTER TABLE `registrodiarioestadooperacion`
ADD PRIMARY KEY (`id`),
ADD KEY `fk_composteras` (`id_compostera`);
ALTER TABLE `softlogs`
ADD PRIMARY KEY (`id`);
ALTER TABLE `usuarios`
ADD PRIMARY KEY (`id`);
ALTER TABLE `composteras`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=170;
ALTER TABLE `registrodiarioestadooperacion`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=170;
ALTER TABLE `softlogs`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `usuarios`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=217;
ALTER TABLE `registrodiarioestadooperacion`
ADD CONSTRAINT `idcompost_fk` FOREIGN KEY (`id_compostera`) REFERENCES `composteras` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;