--
-- Host: localhost    Database: GastosComunesDB
-- ------------------------------------------------------


--
-- Table structure for table `cargos`
--

CREATE TABLE `cargos` (
  `idcargos` int(11) NOT NULL AUTO_INCREMENT,
  `motivo` varchar(200) DEFAULT NULL,
  `monto` int(11) DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `mes` int(11) DEFAULT NULL,
  `fecha` datetime DEFAULT NULL,
  `observaciones` varchar(255) DEFAULT NULL,
  `departamentos_iddepartamento` int(11) NOT NULL,
  `departamentos_propiedades_rut` int(11) NOT NULL,
  PRIMARY KEY (`idcargos`,`departamentos_iddepartamento`,`departamentos_propiedades_rut`),
  KEY `fk_gastos_departamentos1_idx` (`departamentos_iddepartamento`,`departamentos_propiedades_rut`),
  CONSTRAINT `fk_gastos_departamentos1` FOREIGN KEY (`departamentos_iddepartamento`, `departamentos_propiedades_rut`) REFERENCES `departamentos` (`iddepartamento`, `propiedades_rut`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cargos`
--

INSERT INTO `cargos` VALUES (29,'ruidos molestos',50000,2017,1,'2017-02-08 20:32:25','',1218,-8),(30,'mal uso de  e',60500,2016,11,'2017-02-10 23:47:57','el 22 de enero',1225,-8);

--
-- Table structure for table `datos_maestros`
--

CREATE TABLE `datos_maestros` (
  `iddatos_maestros` int(11) NOT NULL,
  `uf` int(11) DEFAULT NULL,
  `fecha_uf` datetime DEFAULT NULL,
  PRIMARY KEY (`iddatos_maestros`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `datos_maestros`
--


--
-- Table structure for table `departamentos`
--

CREATE TABLE `departamentos` (
  `iddepartamento` int(11) NOT NULL AUTO_INCREMENT,
  `torre` varchar(45) DEFAULT NULL,
  `depto` varchar(45) DEFAULT NULL,
  `porcentaje_gc` varchar(45) DEFAULT NULL,
  `porcentaje_fr` varchar(45) DEFAULT NULL,
  `nombre_copropietario` varchar(200) DEFAULT NULL,
  `email_copropietario` varchar(200) DEFAULT NULL,
  `propiedades_rut` int(11) NOT NULL,
  `mesesVencidos` int(11) DEFAULT NULL,
  `montoMesesVencido` int(11) DEFAULT NULL,
  `montoFijo` int(11) DEFAULT NULL,
  PRIMARY KEY (`iddepartamento`,`propiedades_rut`),
  KEY `fk_departamentos_propiedades_idx` (`propiedades_rut`),
  CONSTRAINT `fk_departamentos_propiedades` FOREIGN KEY (`propiedades_rut`) REFERENCES `propiedades` (`rut`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1627 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `departamentos`
--

INSERT INTO `departamentos` VALUES (1094,NULL,'201','0.01239','0.05','Marisa Kausel Contador',NULL,53311123,0,0,0),(1095,NULL,'202','0.01684','0.05','Luis Soto Valpuesta',NULL,53311123,0,0,0),(1096,NULL,'203','0.01683','0.05','Ivonne Arellano Hamelin',NULL,53311123,0,0,0),(1097,NULL,'204','0.01639','0.05','Juan Galdames Schiattino',NULL,53311123,0,0,0),(1098,NULL,'301','0.01251','0.05','Carolina Pita',NULL,53311123,0,0,0),(1099,NULL,'302','0.02119','0.05','Maria De Los Angeles Perez Mardones',NULL,53311123,0,0,0),(1100,NULL,'303','0.0179','0.05','Lautaro Echeverria Recabarren',NULL,53311123,0,0,0),(1101,NULL,'304','0.01651','0.05','Juan E Mendez Martinez',NULL,53311123,0,0,0),(1102,NULL,'401','0.01244','0.05','Carla Lara Berrios',NULL,53311123,0,0,0),(1103,NULL,'402','0.01973','0.05','Erwin Kullmer Navarrete',NULL,53311123,0,0,0),(1104,NULL,'403','0.01928','0.05','Jose Miguel Alvarez Donoso',NULL,53311123,0,0,0),(1105,NULL,'404','0.01501','0.05','Inversiones B Y B Beckdorf Carlos',NULL,53311123,0,378926,0),(1106,NULL,'501','0.01243','0.05','Richard Rubilar Carrasco',NULL,53311123,0,0,0),(1107,NULL,'502','0.01827','0.05','Juan Froemel Andrade',NULL,53311123,0,0,0),(1108,NULL,'503','0.01926','0.05','Juan Leiva Buchi',NULL,53311123,0,-11628,0),(1109,NULL,'504','0.01816','0.05','Francisco Sarras Alam',NULL,53311123,0,0,0),(1110,NULL,'601','0.011','0.05','Patricio Reyes',NULL,53311123,0,136273,0),(1111,NULL,'602','0.01873','0.05','Osman Olivares Milla',NULL,53311123,0,0,0),(1112,NULL,'603','0.01946','0.05','Jorge Mayerson Kardonski',NULL,53311123,0,0,0),(1113,NULL,'604','0.01786','0.05','Rosa Simunovic Ibañez',NULL,53311123,0,0,0),(1114,NULL,'701','0.01255','0.05','Miren Igone Uriarte Plazaola',NULL,53311123,0,0,0),(1115,NULL,'702','0.01891','0.05','Nathyuszka Canelon Patiño',NULL,53311123,0,0,0),(1116,NULL,'703','0.0193','0.05','Pablo Enrique Aguilera Marin',NULL,53311123,0,0,0),(1117,NULL,'704','0.01645','0.05','Laurence Golborne Riveros',NULL,53311123,0,0,0),(1118,NULL,'801','0.01246','0.05','Dina Ortiz Fuentes',NULL,53311123,0,0,0),(1119,NULL,'802','0.01829','0.05','Danielle Reyes Cabala',NULL,53311123,0,0,0),(1120,NULL,'803','0.01933','0.05','Paula Reyes Paula Reyes',NULL,53311123,0,0,0),(1121,NULL,'804','0.01634','0.05','Rafael Garcia Lopez',NULL,53311123,0,0,0),(1122,NULL,'901','0.01255','0.05','Christian Hafelin Barrios',NULL,53311123,0,0,0),(1123,NULL,'902','0.0193','0.05','Gonzalo Rossel De La Maza',NULL,53311123,0,0,0),(1124,NULL,'903','0.01922','0.05','Carlos Stutz Neveu',NULL,53311123,0,0,0),(1125,NULL,'904','0.0165','0.05','Roberto Salazar Esperante',NULL,53311123,0,0,0),(1126,NULL,'1001','0.01244','0.05','Oscar Marcelo Butron Vaca',NULL,53311123,0,264762,0),(1127,NULL,'1002','0.01828','0.05','Ciro Ernesto Ibanez Acosta',NULL,53311123,0,-261,0),(1128,NULL,'1003','0.01948','0.05','Denise Shomaly Khashram',NULL,53311123,0,0,0),(1129,NULL,'1004','0.01647','0.05','Elfride Lam Pasten',NULL,53311123,0,0,0),(1130,NULL,'1101','0.01258','0.05','Carlos Casas Cordero',NULL,53311123,0,427402,0),(1131,NULL,'1102','0.01826','0.05','Danae Gallegos Duk',NULL,53311123,0,0,0),(1132,NULL,'1103','0.01939','0.05','Claudio Acosta Speranza',NULL,53311123,0,0,0),(1133,NULL,'1104','0.01644','0.05','Mariano Gonzalez Barahona',NULL,53311123,0,0,0),(1134,NULL,'1201','0.01424','0.05','Gustavo Metz Arndt',NULL,53311123,0,0,0),(1135,NULL,'1202','0.01822','0.05','Diego Prieto Damn',NULL,53311123,0,0,0),(1136,NULL,'1203','0.01944','0.05','Lee Min Keum Ja',NULL,53311123,0,0,0),(1137,NULL,'1204','0.01669','0.05','Pedro Leguina Eguia',NULL,53311123,0,0,0),(1138,NULL,'1301','0.01108','0.05','Elly M Gonzlez Yanez',NULL,53311123,0,0,0),(1139,NULL,'1302','0.01971','0.05','Maria Eugenia Gallardo Chavez',NULL,53311123,0,-515083,0),(1140,NULL,'1303','0.02079','0.05','Antonio Donizeti Castillo',NULL,53311123,0,0,0),(1141,NULL,'1304','0.01517','0.05','Rodrigo Chacon Coorsi',NULL,53311123,0,0,0),(1142,NULL,'1401','0.01248','0.05','Marcia Banda Garay',NULL,53311123,0,310070,0),(1143,NULL,'1402','0.01829','0.05','Alberto Calvo Montes',NULL,53311123,0,0,0),(1144,NULL,'1403','0.01999','0.05','Lim Byoung Kwon',NULL,53311123,0,0,0),(1145,NULL,'1404','0.01659','0.05','Sonia Andersen Munoz',NULL,53311123,0,0,0),(1146,NULL,'1501','0.01394','0.05','Rodolfo Vergara Silva',NULL,53311123,0,0,0),(1147,NULL,'1502','0.01534','0.05','Marta Fresia Mendoza Brule',NULL,53311123,0,0,0),(1148,NULL,'1503','0.01931','0.05','Sandra Edmund Paoa',NULL,53311123,0,0,0),(1149,NULL,'1504','0.01655','0.05','Rossana Lagos Carter',NULL,53311123,0,0,0),(1150,NULL,'1601','0.01253','0.05','Lautaro Olivares Aravena',NULL,53311123,0,145139,0),(1151,NULL,'1602','0.01684','0.05','Rossana Romanini Echeverria',NULL,53311123,0,0,0),(1152,NULL,'1603','0.01949','0.05','M Victoria Ureta Zañartu',NULL,53311123,0,0,0),(1153,NULL,'1604','0.01658','0.05','M Esperanza Garcia Vinuela',NULL,53311123,0,0,0),(1154,'453','11','0','0','Sin Nombre',NULL,-6,0,0,59660),(1155,'453','12','0','0','Sin Nombre',NULL,-6,0,0,64930),(1156,'453','21','0','0','Sin Nombre',NULL,-6,0,0,59660),(1157,'453','22','0','0','Sin Nombre',NULL,-6,0,0,64930),(1158,'453','31','0','0','Sin Nombre',NULL,-6,0,0,59660),(1159,'453','32','0','0','Sin Nombre',NULL,-6,0,0,64930),(1160,'453','41','0','0','Sin Nombre',NULL,-6,0,0,59660),(1161,'453','42','0','0','Sin Nombre',NULL,-6,0,0,64930),(1162,'455','11','0','0','Sin Nombre',NULL,-6,0,0,64930),(1163,'455','12','0','0','Sin Nombre',NULL,-6,0,0,59660),(1164,'455','21','0','0','Sin Nombre',NULL,-6,0,0,64930),(1165,'455','22','0','0','Sin Nombre',NULL,-6,0,0,59660),(1166,'455','31','0','0','Sin Nombre',NULL,-6,0,0,64930),(1167,'455','32','0','0','Sin Nombre',NULL,-6,0,0,59660),(1168,'455','41','0','0','Sin Nombre',NULL,-6,0,0,64930),(1169,'455','42','0','0','Sin Nombre',NULL,-6,0,0,59660),(1170,'457','11','0','0','Sin Nombre',NULL,-6,0,0,59660),(1171,'457','12','0','0','Sin Nombre',NULL,-6,0,0,64930),(1172,'457','21','0','0','Sin Nombre',NULL,-6,0,0,59660),(1173,'457','22','0','0','Sin Nombre',NULL,-6,0,0,64930),(1174,'457','31','0','0','Sin Nombre',NULL,-6,0,0,59660),(1175,'457','32','0','0','Sin Nombre',NULL,-6,0,0,64930),(1176,'457','41','0','0','Sin Nombre',NULL,-6,0,0,59660),(1177,'457','42','0','0','Sin Nombre',NULL,-6,0,0,64930),(1178,'459','11','0','0','Sin Nombre',NULL,-6,0,0,64930),(1179,'459','12','0','0','Sin Nombre',NULL,-6,0,0,59660),(1180,'459','21','0','0','Sin Nombre',NULL,-6,0,0,64930),(1181,'459','22','0','0','Sin Nombre',NULL,-6,0,0,59660),(1182,'459','31','0','0','Sin Nombre',NULL,-6,0,0,64930),(1183,'459','32','0','0','Sin Nombre',NULL,-6,0,0,59660),(1184,'459','41','0','0','Sin Nombre',NULL,-6,0,0,64930),(1185,'459','42','0','0','Sin Nombre',NULL,-6,0,0,59660),(1186,'573','11','0','0','Sin Nombre',NULL,-6,0,0,59660),(1187,'573','12','0','0','Sin Nombre',NULL,-6,0,0,60060),(1188,'573','21','0','0','Sin Nombre',NULL,-6,0,0,59660),(1189,'573','22','0','0','Sin Nombre',NULL,-6,0,0,60060),(1190,'573','31','0','0','Sin Nombre',NULL,-6,0,0,59660),(1191,'573','32','0','0','Sin Nombre',NULL,-6,0,0,60060),(1192,'573','41','0','0','Sin Nombre',NULL,-6,0,0,59660),(1193,'573','42','0','0','Sin Nombre',NULL,-6,0,0,60060),(1194,'575','11','0','0','Sin Nombre',NULL,-6,0,0,63440),(1195,'575','12','0','0','Sin Nombre',NULL,-6,0,0,59660),(1196,'575','21','0','0','Sin Nombre',NULL,-6,0,0,63440),(1197,'575','22','0','0','Sin Nombre',NULL,-6,0,0,59660),(1198,'575','31','0','0','Sin Nombre',NULL,-6,0,0,63440),(1199,'575','32','0','0','Sin Nombre',NULL,-6,0,0,59660),(1200,'575','41','0','0','Sin Nombre',NULL,-6,0,0,63440),(1201,'575','42','0','0','Sin Nombre',NULL,-6,0,0,59660),(1202,'577','11','0','0','Sin Nombre',NULL,-6,0,0,59660),(1203,'577','12','0','0','Sin Nombre',NULL,-6,0,0,63440),(1204,'577','21','0','0','Sin Nombre',NULL,-6,0,0,59660),(1205,'577','22','0','0','Sin Nombre',NULL,-6,0,0,63440),(1206,'577','31','0','0','Sin Nombre',NULL,-6,0,0,59660),(1207,'577','32','0','0','Sin Nombre',NULL,-6,0,0,63440),(1208,'577','41','0','0','Sin Nombre',NULL,-6,0,0,59660),(1209,'577','42','0','0','Sin Nombre',NULL,-6,0,0,63440),(1210,'579','11','0','0','Sin Nombre',NULL,-6,0,0,60060),(1211,'579','12','0','0','Sin Nombre',NULL,-6,0,0,59660),(1212,'579','21','0','0','Sin Nombre',NULL,-6,0,0,60060),(1213,'579','22','0','0','Sin Nombre',NULL,-6,0,0,59660),(1214,'579','31','0','0','Sin Nombre',NULL,-6,0,0,60060),(1215,'579','32','0','0','Sin Nombre',NULL,-6,0,0,59660),(1216,'579','41','0','0','Sin Nombre',NULL,-6,0,0,60060),(1217,'579','42','0','0','Sin Nombre',NULL,-6,0,0,59660),(1218,NULL,'201','1.239','0.05','Marisa Kausel Contador',NULL,-8,0,0,0),(1219,NULL,'202','1.6840000000000002','0.05','Luis Soto Valpuesta',NULL,-8,0,0,0),(1220,NULL,'203','1.683','0.05','Ivonne Arellano Hamelin',NULL,-8,0,0,0),(1221,NULL,'204','1.6389999999999998','0.05','Juan Galdames Schiattino',NULL,-8,0,0,0),(1222,NULL,'301','1.2510000000000001','0.05','Carolina Pita',NULL,-8,0,0,0),(1223,NULL,'302','2.119','0.05','Maria De Los Angeles Perez Mardones',NULL,-8,0,0,0),(1224,NULL,'303','1.79','0.05','Lautaro Echeverria Recabarren',NULL,-8,0,0,0),(1225,NULL,'304','1.651','0.05','Juan E Mendez Martinez',NULL,-8,0,0,0),(1226,NULL,'401','1.244','0.05','Carla Lara Berrios',NULL,-8,0,0,0),(1227,NULL,'402','1.973','0.05','Erwin Kullmer Navarrete',NULL,-8,0,0,0),(1228,NULL,'403','1.928','0.05','Jose Miguel Alvarez Donoso',NULL,-8,0,0,0),(1229,NULL,'404','1.5010000000000003','0.05','Inversiones B Y B Beckdorf Carlos',NULL,-8,0,378926,0),(1230,NULL,'501','1.243','0.05','Richard Rubilar Carrasco',NULL,-8,0,0,0),(1231,NULL,'502','1.8270000000000002','0.05','Juan Froemel Andrade',NULL,-8,0,0,0),(1232,NULL,'503','1.926','0.05','Juan Leiva Buchi',NULL,-8,0,-11628,0),(1233,NULL,'504','1.8159999999999998','0.05','Francisco Sarras Alam',NULL,-8,0,0,0),(1234,NULL,'601','1.0999999999999999','0.05','Patricio Reyes',NULL,-8,0,136273,0),(1235,NULL,'602','1.8730000000000002','0.05','Osman Olivares Milla',NULL,-8,0,0,0),(1236,NULL,'603','1.9460000000000002','0.05','Jorge Mayerson Kardonski',NULL,-8,0,0,0),(1237,NULL,'604','1.786','0.05','Rosa Simunovic Ibañez',NULL,-8,0,0,0),(1238,NULL,'701','1.2550000000000001','0.05','Miren Igone Uriarte Plazaola',NULL,-8,0,0,0),(1239,NULL,'702','1.891','0.05','Nathyuszka Canelon Patiño',NULL,-8,0,0,0),(1240,NULL,'703','1.9300000000000004','0.05','Pablo Enrique Aguilera Marin',NULL,-8,0,0,0),(1241,NULL,'704','1.645','0.05','Laurence Golborne Riveros',NULL,-8,0,0,0),(1242,NULL,'801','1.246','0.05','Dina Ortiz Fuentes',NULL,-8,0,0,0),(1243,NULL,'802','1.829','0.05','Danielle Reyes Cabala',NULL,-8,0,0,0),(1244,NULL,'803','1.933','0.05','Paula Reyes Paula Reyes',NULL,-8,0,0,0),(1245,NULL,'804','1.6340000000000001','0.05','Rafael Garcia Lopez',NULL,-8,0,0,0),(1246,NULL,'901','1.2550000000000001','0.05','Christian Hafelin Barrios',NULL,-8,0,0,0),(1247,NULL,'902','1.9300000000000004','0.05','Gonzalo Rossel De La Maza',NULL,-8,0,0,0),(1248,NULL,'903','1.9220000000000002','0.05','Carlos Stutz Neveu',NULL,-8,0,0,0),(1249,NULL,'904','1.65','0.05','Roberto Salazar Esperante',NULL,-8,0,0,0),(1250,NULL,'1001','1.244','0.05','Oscar Marcelo Butron Vaca',NULL,-8,0,264762,0),(1251,NULL,'1002','1.828','0.05','Ciro Ernesto Ibanez Acosta',NULL,-8,0,-261,0),(1252,NULL,'1003','1.9480000000000002','0.05','Denise Shomaly Khashram',NULL,-8,0,0,0),(1253,NULL,'1004','1.6469999999999998','0.05','Elfride Lam Pasten',NULL,-8,0,0,0),(1254,NULL,'1101','1.258','0.05','Carlos Casas Cordero',NULL,-8,0,427402,0),(1255,NULL,'1102','1.8259999999999998','0.05','Danae Gallegos Duk',NULL,-8,0,0,0),(1256,NULL,'1103','1.939','0.05','Claudio Acosta Speranza',NULL,-8,0,0,0),(1257,NULL,'1104','1.6439999999999997','0.05','Mariano Gonzalez Barahona',NULL,-8,0,0,0),(1258,NULL,'1201','1.4240000000000002','0.05','Gustavo Metz Arndt',NULL,-8,0,0,0),(1259,NULL,'1202','1.822','0.05','Diego Prieto Damn',NULL,-8,0,0,0),(1260,NULL,'1203','1.944','0.05','Lee Min Keum Ja',NULL,-8,0,0,0),(1261,NULL,'1204','1.669','0.05','Pedro Leguina Eguia',NULL,-8,0,0,0),(1262,NULL,'1301','1.1079999999999999','0.05','Elly M Gonzlez Yanez',NULL,-8,0,0,0),(1263,NULL,'1302','1.9709999999999999','0.05','Maria Eugenia Gallardo Chavez',NULL,-8,0,-515083,0),(1264,NULL,'1303','2.0789999999999997','0.05','Antonio Donizeti Castillo',NULL,-8,0,0,0),(1265,NULL,'1304','1.517','0.05','Rodrigo Chacon Coorsi',NULL,-8,0,0,0),(1266,NULL,'1401','1.248','0.05','Marcia Banda Garay',NULL,-8,0,310070,0),(1267,NULL,'1402','1.829','0.05','Alberto Calvo Montes',NULL,-8,0,0,0),(1268,NULL,'1403','1.999','0.05','Lim Byoung Kwon',NULL,-8,0,0,0),(1269,NULL,'1404','1.659','0.05','Sonia Andersen Munoz',NULL,-8,0,0,0),(1270,NULL,'1501','1.3939999999999997','0.05','Rodolfo Vergara Silva',NULL,-8,0,0,0),(1271,NULL,'1502','1.534','0.05','Marta Fresia Mendoza Brule',NULL,-8,0,0,0),(1272,NULL,'1503','1.931','0.05','Sandra Edmund Paoa',NULL,-8,0,0,0),(1273,NULL,'1504','1.6549999999999998','0.05','Rossana Lagos Carter',NULL,-8,0,0,0),(1274,NULL,'1601','1.253','0.05','Lautaro Olivares Aravena',NULL,-8,0,145139,0),(1275,NULL,'1602','1.6840000000000002','0.05','Rossana Romanini Echeverria',NULL,-8,0,0,0),(1276,NULL,'1603','1.949','0.05','M Victoria Ureta Zañartu',NULL,-8,0,0,0),(1277,NULL,'1604','1.6580000000000001','0.05','M Esperanza Garcia Vinuela',NULL,-8,0,0,0),(1278,NULL,'D-0301','0.475000',NULL,'MARIA INÉS MONTES',NULL,53304492,0,78117,0),(1279,NULL,'D-0302','0.512100',NULL,'ANDY SALINAS ',NULL,53304492,0,81784,0),(1280,NULL,'D-0303','0.494100',NULL,'EVELYN BEQUER MUÑOZ',NULL,53304492,0,236472,0),(1281,NULL,'D-0304','0.516700',NULL,'MARCELA SILVA',NULL,53304492,0,72492,0),(1282,NULL,'D-0305','0.728500',NULL,'ARTURO CARRASCO',NULL,53304492,0,359306,0),(1283,NULL,'D-0306','0.460000',NULL,'EVA PINCETIC',NULL,53304492,0,76154,0),(1284,NULL,'D-0307','0.803700',NULL,'MARIA SOLEDAD JIL EGAÑA',NULL,53304492,0,110037,0),(1285,NULL,'D-0308','0.516800',NULL,'CARMEN GLORIA PEREIRA',NULL,53304492,0,67608,0),(1286,NULL,'D-0309','0.491800',NULL,'NADIA PATRICIA LARA MORENO',NULL,53304492,0,71683,0),(1287,NULL,'D-0310','0.510900',NULL,'SARA GUAJARDO ACOSTA',NULL,53304492,0,91829,0),(1288,NULL,'D-0311','0.474500',NULL,'ROLANDO ROJAS ROJAS ',NULL,53304492,0,78051,0),(1289,NULL,'D-0401','0.475000',NULL,'JAIME CAICEO ESCUDERO',NULL,53304492,0,244873,0),(1290,NULL,'D-0402','0.513400',NULL,'CARLOS ALVAREZ',NULL,53304492,0,154575,0),(1291,NULL,'D-0403','0.474500',NULL,'FRANCISCO CASTILLO',NULL,53304492,0,140767,0),(1292,NULL,'D-0404','0.511900',NULL,'MARIA FERNANDA GOMEZ',NULL,53304492,0,82165,0),(1293,NULL,'D-0405','0.738400',NULL,'OSCAR OYARZO',NULL,53304492,0,101495,0),(1294,NULL,'D-0406','0.457100',NULL,'PABLO GRAN LOPEZ',NULL,53304492,0,78224,0),(1295,NULL,'D-0407','0.758700',NULL,'JAIME MERINO ',NULL,53304492,0,234849,0),(1296,NULL,'D-0408','0.515400',NULL,'PATRICIO MERICQ GUILA',NULL,53304492,0,79668,0),(1297,NULL,'D-0409','0.490900',NULL,'PAULA OLIVARES',NULL,53304492,0,226280,0),(1298,NULL,'D-0410','0.509600',NULL,'ANDREA SOLE ARAYA',NULL,53304492,0,281322,0),(1299,NULL,'D-0411','0.473900',NULL,'TERESA MONTES ',NULL,53304492,0,98262,0),(1300,NULL,'D-0501','0.466000',NULL,'SOFIA BUSTOS LARENAS',NULL,53304492,0,81837,0),(1301,NULL,'D-0502','0.510200',NULL,'FRANCISCA QUIROZ',NULL,53304492,0,78988,0),(1302,NULL,'D-0503','0.465500',NULL,'PATRICIO CARRASCO MOLINA',NULL,53304492,0,68243,0),(1303,NULL,'D-0504','0.494000',NULL,'JACQUELINE GAC MUÑOZ',NULL,53304492,0,69522,0),(1304,NULL,'D-0505','0.726900',NULL,'RAUL JORQUERA ',NULL,53304492,0,218548,0),(1305,NULL,'D-0506','0.455400',NULL,'LORENZO SAN MARTIN CARRASCO ',NULL,53304492,0,75553,0),(1306,NULL,'D-0507','0.759700',NULL,'MARCELA INES BOBADILLA DIAZ',NULL,53304492,0,99384,0),(1307,NULL,'D-0508','0.494000',NULL,'PATRICIA PLAZA MUNITA',NULL,53304492,0,69522,0),(1308,NULL,'D-0509','0.462200',NULL,'JUDITH CAÑAS MEDEL ',NULL,53304492,0,65362,0),(1309,NULL,'D-0510','0.511600',NULL,'JOSEE OCARANZA',NULL,53304492,0,164469,0),(1310,NULL,'D-0511','0.486400',NULL,'MARCELO AVENDAÑO ',NULL,53304492,0,297894,0),(1311,NULL,'D-0601','0.486500',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,74724,0),(1312,NULL,'D-0602','0.510200',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,84392,0),(1313,NULL,'D-0603','0.464100',NULL,'ERNESTO YAÑEZ EGEBRT ',NULL,53304492,0,78361,0),(1314,NULL,'D-0604','0.493800',NULL,'CARMEN GLORIA HERMOSILLA',NULL,53304492,0,174743,0),(1315,NULL,'D-0605','0.728300',NULL,'JOSE REAL',NULL,53304492,0,109968,0),(1316,NULL,'D-0606','0.456800',NULL,'INES VILLALOBOS',NULL,53304492,0,80633,0),(1317,NULL,'D-0607','0.758500',NULL,'KARIN PIWONKA',NULL,53304492,0,116368,0),(1318,NULL,'D-0608','0.484100',NULL,'CRISTOBAL DEL SOLAR',NULL,53304492,0,68227,0),(1319,NULL,'D-0609','0.465900',NULL,'JUAN Fco. CARVAJAL DAMANN ',NULL,53304492,0,89170,0),(1320,NULL,'D-0610','0.510900',NULL,'ANDRES FERNANDEZ',NULL,53304492,0,168035,0),(1321,NULL,'D-0611','0.466700',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,81928,0),(1322,NULL,'D-0701','0.476600',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,80775,0),(1323,NULL,'D-0702','0.521600',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,80985,0),(1324,NULL,'D-0703','0.463900',NULL,'ROLANDO ROJAS ROJAS ',NULL,53304492,0,84011,0),(1325,NULL,'D-0704','0.494400',NULL,'ALBERT CLARO',NULL,53304492,0,83103,0),(1326,NULL,'D-0705','0.742400',NULL,'MARICEL HENRIQUEZ',NULL,53304492,0,109364,0),(1327,NULL,'D-0706','0.455800',NULL,'CARMEN LUZ LARRAIN',NULL,53304492,0,204463,0),(1328,NULL,'D-0707','0.750600',NULL,'BERNARDITA PAGUEGUY (191.296)',NULL,53304492,0,128084,0),(1329,NULL,'D-0708','0.492500',NULL,'JULIETA PHILLIPS',NULL,53304492,0,302579,0),(1330,NULL,'D-0709','0.465100',NULL,'JUDITH CAÑAS MEDEL ',NULL,53304492,0,123944,0),(1331,NULL,'D-0710','0.512100',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,180060,0),(1332,NULL,'D-0711','0.478500',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,78575,0),(1333,NULL,'D-0801','0.475000',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,78117,0),(1334,NULL,'D-0802','0.510200',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,84392,0),(1335,NULL,'D-0803','0.464000',NULL,'ALBERTO CLARO VIAL',NULL,53304492,0,74229,0),(1336,NULL,'D-0804','0.492200',NULL,'ITALIA ROSAS',NULL,53304492,0,75319,0),(1337,NULL,'D-0805','0.725800',NULL,'SANDRA GARCIA',NULL,53304492,0,148863,0),(1338,NULL,'D-0806','0.466900',NULL,'JAVIER  VALLE PONCE',NULL,53304492,0,75772,0),(1339,NULL,'D-0807','0.808100',NULL,'ENRIQUE HAQUIN',NULL,53304492,0,242948,0),(1340,NULL,'D-0808','0.504800',NULL,'EMA ROJAS',NULL,53304492,0,169802,0),(1341,NULL,'D-0809','0.454300',NULL,'JUAN EDUARDO UNDURRAGA',NULL,53304492,0,336964,0),(1342,NULL,'D-0810','0.510200',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,89289,0),(1343,NULL,'D-0811','0.486400',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,79608,0),(1344,NULL,'D-0901','0.476500',NULL,'YOLANDA VIAL',NULL,53304492,0,80762,0),(1345,NULL,'D-0902','0.521800',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,93255,0),(1346,NULL,'D-0903','0.464700',NULL,'PUBLICIDAD Y PROM. ESPERANZA S.A',NULL,53304492,0,76769,0),(1347,NULL,'D-0904','0.494900',NULL,'AUGUSTO ZAVALA',NULL,53304492,0,69640,0),(1348,NULL,'D-0905','0.684100',NULL,'MARIA CECILIA GOYCOLEA MOZO',NULL,53304492,0,114487,0),(1349,NULL,'D-0906','0.457300',NULL,'JULIETA PHILIPS',NULL,53304492,0,275671,0),(1350,NULL,'D-0907','0.758500',NULL,'MARIA PIA LAGOS JOFRÉ ',NULL,53304492,0,111319,0),(1351,NULL,'D-0908','0.494900',NULL,'PATRICIA CASTILLO FELIU',NULL,53304492,0,83169,0),(1352,NULL,'D-0909','0.454300',NULL,'AURORA ARELLANO',NULL,53304492,0,473712,0),(1353,NULL,'D-0910','0.513700',NULL,'PABLO GARCES ACUÑA',NULL,53304492,0,79446,0),(1354,NULL,'D-0911','0.476400',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,75851,0),(1355,NULL,'D-1001','0.475000',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,83014,0),(1356,NULL,'D-1002','0.510800',NULL,'JOSE LUIS GRAU',NULL,53304492,0,69271,0),(1357,NULL,'D-1003','0.462200',NULL,'TOMAS VILLAGRA VEGA',NULL,53304492,0,62092,0),(1358,NULL,'D-1004','0.503900',NULL,'M.a TERESA VENTURINO SEPULVEDA',NULL,53304492,0,143531,0),(1359,NULL,'D-1005','0.728400',NULL,'EDUARDO PADILLA ROBLES',NULL,53304492,0,87943,0),(1360,NULL,'D-1006','0.456700',NULL,'CAROLINA GUTIERREZ',NULL,53304492,0,66793,0),(1361,NULL,'D-1007','0.761700',NULL,'PAULA FUENTEALBA QUEZADA',NULL,53304492,0,106991,0),(1362,NULL,'D-1008','0.493100',NULL,'JUAN ESPINOZA MEDEL',NULL,53304492,0,320996,0),(1363,NULL,'D-1009','0.465400',NULL,'JULIA CASTILLO FELIU',NULL,53304492,0,76861,0),(1364,NULL,'D-1010','0.510200',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,84392,0),(1365,NULL,'D-1011','0.475000',NULL,'INMOBILIARIA E INVERS. RODE LTDA.',NULL,53304492,0,150975,0),(1366,NULL,'D-1101','0.475000',NULL,'RICARDO JULIAN SAID',NULL,53304492,0,73219,0),(1367,NULL,'D-1102','0.521700',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,85896,0),(1368,NULL,'D-1103','0.427000',NULL,'CAROLINA TALLAR PABST',NULL,53304492,0,70816,0),(1369,NULL,'D-1104','0.492900',NULL,'LUIS EDUARDO GALLARDO ',NULL,53304492,0,64481,0),(1370,NULL,'D-1105','0.774300',NULL,'MARIA HURTADO LATORRE',NULL,53304492,0,220431,0),(1371,NULL,'D-1106','0.455400',NULL,'JULIETA PHILLIPS',NULL,53304492,0,66921,0),(1372,NULL,'D-1107','0.770500',NULL,'LILIAN VEGA',NULL,53304492,0,130688,0),(1373,NULL,'D-1108','0.493900',NULL,'JUAN MORAGA PEÑA ',NULL,53304492,0,75692,0),(1374,NULL,'D-1109','0.464500',NULL,'RAFAEL GATICA VARAS',NULL,53304492,0,125675,0),(1375,NULL,'D-1110','0.512200',NULL,'MARIA TERESA GUTIERREZ',NULL,53304492,0,79249,0),(1376,NULL,'D-1111','0.486500',NULL,'SOFIA HOTT',NULL,53304492,0,66140,0),(1377,NULL,'D-1201','0.486500',NULL,'NEIA RODRIGUEZ',NULL,53304492,0,63644,0),(1378,NULL,'D-1202','0.510200',NULL,'JOSE RIVERA',NULL,53304492,0,163878,0),(1379,NULL,'D-1203','0.474600',NULL,'EVELYN   RAPAPORT',NULL,53304492,0,75616,0),(1380,NULL,'D-1204','0.492000',NULL,'MARIA COYA FERNANDEZ',NULL,53304492,0,66812,0),(1381,NULL,'D-1205','0.672900',NULL,'GUSTAVO KREFFT PUELMA',NULL,53304492,0,92926,0),(1382,NULL,'D-1206','0.455400',NULL,'INVERSIONES JP LTDA.',NULL,53304492,0,62024,0),(1383,NULL,'D-1207','0.760200',NULL,'PABLO GARCIA ',NULL,53304492,0,393878,0),(1384,NULL,'D-1208','0.494200',NULL,'MONICA SLEBE TAJMUCH',NULL,53304492,0,452751,0),(1385,NULL,'D-1209','0.474200',NULL,'MARISOL SANTA MARIA ',NULL,53304492,0,78012,0),(1386,NULL,'D-1210','0.512000',NULL,'JAVIER MORAGA',NULL,53304492,0,151912,0),(1387,NULL,'D-1211','0.476900',NULL,'MARIA EUGENIA CLARO',NULL,53304492,0,62388,0),(1388,NULL,'D-1301','0.473900',NULL,'RODRIGO CARRASCO',NULL,53304492,0,71790,0),(1389,NULL,'D-1302','0.514800',NULL,'SERGIO JELINCIC DEL CAMPO',NULL,53304492,0,69795,0),(1390,NULL,'D-1303','0.464200',NULL,'JAIME DIAZ DE VALDES',NULL,53304492,0,60303,0),(1391,NULL,'D-1304','0.504000',NULL,'M. EUGENIA IRARRAZABAL',NULL,53304492,0,267361,0),(1392,NULL,'D-1305','0.771900',NULL,'JULIAN ARANGUIZ',NULL,53304492,0,378136,0),(1393,NULL,'D-1306','0.467600',NULL,'CHRISTIAN RECART PIZARRO ',NULL,53304492,0,68517,0),(1394,NULL,'D-1307','0.760900',NULL,'OSVALDO ACEVEDO PEREZ',NULL,53304492,0,248044,0),(1395,NULL,'D-1308','0.492400',NULL,'PABLO GRAN LOPEZ',NULL,53304492,0,82499,0),(1396,NULL,'D-1309','0.462700',NULL,'PILAR ADRIAZOLA',NULL,53304492,0,177663,0),(1397,NULL,'D-1310','0.463500',NULL,'FELIPE ORTIZ',NULL,53304492,0,60635,0),(1398,NULL,'D-1311','0.427000',NULL,'PAULA PULGAR CABRERA',NULL,53304492,0,65655,0),(1399,NULL,'D-1401','0.474700',NULL,'XIMENA REYES',NULL,53304492,0,273767,0),(1400,NULL,'D-1402','0.512200',NULL,'MARIA CAROLINA TRONCOS MOUAT',NULL,53304492,0,150740,0),(1401,NULL,'D-1403','0.464300',NULL,'PABLO VADES ALDUNATE',NULL,53304492,0,153036,0),(1402,NULL,'D-1404','0.493200',NULL,'XIMENA REYES',NULL,53304492,0,170998,0),(1403,NULL,'D-1405','0.738300',NULL,'DANIELA BERTOGLIA NAVARRO',NULL,53304492,0,119129,0),(1404,NULL,'D-1406','0.458900',NULL,'EDITH SALAZAR',NULL,53304492,0,260858,0),(1405,NULL,'D-1407','0.759900',NULL,'ENRIQUE RODRIGUEZ CALLEJAS',NULL,53304492,0,155174,0),(1406,NULL,'D-1408','0.493900',NULL,'FRANCISCO CABEZAS BONILLA',NULL,53304492,0,153747,0),(1407,NULL,'D-1409','0.462100',NULL,'MARIA FERNANDA GOMEZ',NULL,53304492,0,78878,0),(1408,NULL,'D-1410','0.513700',NULL,'ALEJANDO CARPENTER TORRES',NULL,53304492,0,87288,0),(1409,NULL,'D-1411','0.477000',NULL,'MACARENA HERRERA',NULL,53304492,0,62401,0),(1410,NULL,'D-1501','0.486400',NULL,'ALBERTO CLARO',NULL,53304492,0,71860,0),(1411,NULL,'D-1502','0.521700',NULL,'ALBERTO CLARO',NULL,53304492,0,175477,0),(1412,NULL,'D-1503','0.464100',NULL,'SANDRA NOVOA',NULL,53304492,0,65611,0),(1413,NULL,'D-1504','0.492000',NULL,'ELIZABETH RUDNICK',NULL,53304492,0,64363,0),(1414,NULL,'D-1505','0.728200',NULL,'NICOLÁS ISA',NULL,53304492,0,112404,0),(1415,NULL,'D-1506','0.457300',NULL,'MACARENA SMITS',NULL,53304492,0,67170,0),(1416,NULL,'D-1507','0.762500',NULL,'M. FERNANDA MUÑOZ HOCES',NULL,53304492,0,223511,0),(1417,NULL,'D-1508','0.494400',NULL,'NANCY ARAVENA NEIRA',NULL,53304492,0,75757,0),(1418,NULL,'D-1509','0.474100',NULL,'INMOBILIARIA E INVERS. COPIHUAL',NULL,53304492,0,73102,0),(1419,NULL,'D-1510','0.511900',NULL,'ANDREA HALABI MOREL',NULL,53304492,0,74313,0),(1420,NULL,'D-1511','0.476700',NULL,'ROBERTO SEGOVIA',NULL,53304492,0,62326,0),(1421,NULL,'D-1601','0.487600',NULL,'ANTONIO BARBIERI',NULL,53304492,0,74868,0),(1422,NULL,'D-1602','0.513800',NULL,'ALVARO ARANDA',NULL,53304492,0,268778,0),(1423,NULL,'D-1603','0.461600',NULL,'MARIA COYA FERNANDEZ',NULL,53304492,0,60386,0),(1424,NULL,'D-1604','0.681100',NULL,'CLAUDIA CASTILLO ARAYA',NULL,53304492,0,235471,0),(1425,NULL,'D-1605','0.427000',NULL,'ROBERTO SEGOVIA MELERO',NULL,53304492,0,58309,0),(1426,NULL,'D-1606','0.437100',NULL,'GUSTAVO KREFFT PUELMA',NULL,53304492,0,62079,0),(1427,NULL,'D-1607','0.679300',NULL,'IGNACIO VICUÑA BAEZA',NULL,53304492,0,111411,0),(1428,NULL,'D-1608','0.462600',NULL,'PAMELA JARA VENEGAS',NULL,53304492,0,92138,0),(1429,NULL,'D-1609','0.524300',NULL,'INMOBILIARIA E INVERS. CRISPA',NULL,53304492,0,266952,0),(1430,NULL,'D-1610','0.480900',NULL,'PABLO VALDES ALDUNATE',NULL,53304492,0,176755,0),(1431,NULL,'D-1701','0.473900',NULL,'ALBERTO CLARO',NULL,53304492,0,76376,0),(1432,NULL,'D-1702','0.503900',NULL,'SOC. DE INV. STA. M. DE LOS ANGELES',NULL,53304492,0,250826,0),(1433,NULL,'D-1703','0.464400',NULL,'JOSE CARMONA',NULL,53304492,0,60753,0),(1434,NULL,'D-1704','0.678500',NULL,'FLORA BARRERA MIRANDA ',NULL,53304492,0,186023,0),(1435,NULL,'D-1705','0.427300',NULL,'JUAN  LLONA',NULL,53304492,0,58348,0),(1436,NULL,'D-1706','0.427300',NULL,'INMOBILIARIA E INVERS. COPIHUAL',NULL,53304492,0,58348,0),(1437,NULL,'D-1707','0.678100',NULL,'MARIA ISABEL VILLEGAS',NULL,53304492,0,107135,0),(1438,NULL,'D-1708','0.464500',NULL,'JUAN ESPINOZA MEDEL',NULL,53304492,0,142650,0),(1439,NULL,'D-1709','0.511700',NULL,'RODRIGO PEREZ DE CASTRO',NULL,53304492,0,146203,0),(1440,NULL,'D-1710','0.475900',NULL,'TOMAS VILLAGRA',NULL,53304492,0,146450,0),(1441,NULL,'L-1','1.094900',NULL,'INMOB. E INVERS. CATALUNYA',NULL,53304492,0,494631,0),(1442,NULL,'L-2','1.390400',NULL,'BANCO BCI',NULL,53304492,0,196591,0),(1443,NULL,'L-3','0.917200',NULL,'BANCO BCI',NULL,53304492,0,134688,0),(1444,NULL,'OF-201','0.343200',NULL,'ARTURO BENAVIDES DITTBORN',NULL,53304492,0,181239,0),(1445,NULL,'OF-202','0.347200',NULL,'ALEXANDRA CAVERO VIDAL',NULL,53304492,0,55811,0),(1446,NULL,'OF-203','0.335100',NULL,'PATRICIO CAÑETE',NULL,53304492,0,107367,0),(1447,NULL,'OF-204','3.044900',NULL,'INVERSIONES J.R.C LTDA.',NULL,53304492,0,507842,0),(1448,NULL,'OF-210','0.563500',NULL,'GABRIELA FICHELSON',NULL,53304492,0,85327,0),(1449,NULL,'OF-211','0.893900',NULL,'B@CKOFFICE CONSULTING',NULL,53304492,0,445107,0),(1450,NULL,'OF-212','0.657800',NULL,'SILVIA BARRIENTOS',NULL,53304492,0,86053,0),(1451,NULL,'OF-214','3.458900',NULL,'GEOSINERGIA',NULL,53304492,0,472002,0),(1452,NULL,'D-0301','0.4750',NULL,'MARIA INÉS MONTES',NULL,53304492,0,78117,0),(1453,NULL,'D-0302','0.5121',NULL,'ANDY SALINAS ',NULL,53304492,0,81784,0),(1454,NULL,'D-0303','0.4941',NULL,'EVELYN BEQUER MUÑOZ',NULL,53304492,0,236472,0),(1455,NULL,'D-0304','0.5167',NULL,'MARCELA SILVA',NULL,53304492,0,72492,0),(1456,NULL,'D-0305','0.7285',NULL,'ARTURO CARRASCO',NULL,53304492,0,359306,0),(1457,NULL,'D-0306','0.4600',NULL,'EVA PINCETIC',NULL,53304492,0,76154,0),(1458,NULL,'D-0307','0.8037',NULL,'MARIA SOLEDAD JIL EGAÑA',NULL,53304492,0,110037,0),(1459,NULL,'D-0308','0.5168',NULL,'CARMEN GLORIA PEREIRA',NULL,53304492,0,67608,0),(1460,NULL,'D-0309','0.4918',NULL,'NADIA PATRICIA LARA MORENO',NULL,53304492,0,71683,0),(1461,NULL,'D-0310','0.5109',NULL,'SARA GUAJARDO ACOSTA',NULL,53304492,0,91829,0),(1462,NULL,'D-0311','0.4745',NULL,'ROLANDO ROJAS ROJAS ',NULL,53304492,0,78051,0),(1463,NULL,'D-0401','0.4750',NULL,'JAIME CAICEO ESCUDERO',NULL,53304492,0,244873,0),(1464,NULL,'D-0402','0.5134',NULL,'CARLOS ALVAREZ',NULL,53304492,0,154575,0),(1465,NULL,'D-0403','0.4745',NULL,'FRANCISCO CASTILLO',NULL,53304492,0,140767,0),(1466,NULL,'D-0404','0.5119',NULL,'MARIA FERNANDA GOMEZ',NULL,53304492,0,82165,0),(1467,NULL,'D-0405','0.7384',NULL,'OSCAR OYARZO',NULL,53304492,0,101495,0),(1468,NULL,'D-0406','0.4571',NULL,'PABLO GRAN LOPEZ',NULL,53304492,0,78224,0),(1469,NULL,'D-0407','0.7587',NULL,'JAIME MERINO ',NULL,53304492,0,234849,0),(1470,NULL,'D-0408','0.5154',NULL,'PATRICIO MERICQ GUILA',NULL,53304492,0,79668,0),(1471,NULL,'D-0409','0.4909',NULL,'PAULA OLIVARES',NULL,53304492,0,226280,0),(1472,NULL,'D-0410','0.5096',NULL,'ANDREA SOLE ARAYA',NULL,53304492,0,281322,0),(1473,NULL,'D-0411','0.4739',NULL,'TERESA MONTES ',NULL,53304492,0,98262,0),(1474,NULL,'D-0501','0.4660',NULL,'SOFIA BUSTOS LARENAS',NULL,53304492,0,81837,0),(1475,NULL,'D-0502','0.5102',NULL,'FRANCISCA QUIROZ',NULL,53304492,0,78988,0),(1476,NULL,'D-0503','0.4655',NULL,'PATRICIO CARRASCO MOLINA',NULL,53304492,0,68243,0),(1477,NULL,'D-0504','0.4940',NULL,'JACQUELINE GAC MUÑOZ',NULL,53304492,0,69522,0),(1478,NULL,'D-0505','0.7269',NULL,'RAUL JORQUERA ',NULL,53304492,0,218548,0),(1479,NULL,'D-0506','0.4554',NULL,'LORENZO SAN MARTIN CARRASCO ',NULL,53304492,0,75553,0),(1480,NULL,'D-0507','0.7597',NULL,'MARCELA INES BOBADILLA DIAZ',NULL,53304492,0,99384,0),(1481,NULL,'D-0508','0.4940',NULL,'PATRICIA PLAZA MUNITA',NULL,53304492,0,69522,0),(1482,NULL,'D-0509','0.4622',NULL,'JUDITH CAÑAS MEDEL ',NULL,53304492,0,65362,0),(1483,NULL,'D-0510','0.5116',NULL,'JOSEE OCARANZA',NULL,53304492,0,164469,0),(1484,NULL,'D-0511','0.4864',NULL,'MARCELO AVENDAÑO ',NULL,53304492,0,297894,0),(1485,NULL,'D-0601','0.4865',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,74724,0),(1486,NULL,'D-0602','0.5102',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,84392,0),(1487,NULL,'D-0603','0.4641',NULL,'ERNESTO YAÑEZ EGEBRT ',NULL,53304492,0,78361,0),(1488,NULL,'D-0604','0.4938',NULL,'CARMEN GLORIA HERMOSILLA',NULL,53304492,0,174743,0),(1489,NULL,'D-0605','0.7283',NULL,'JOSE REAL',NULL,53304492,0,109968,0),(1490,NULL,'D-0606','0.4568',NULL,'INES VILLALOBOS',NULL,53304492,0,80633,0),(1491,NULL,'D-0607','0.7585',NULL,'KARIN PIWONKA',NULL,53304492,0,116368,0),(1492,NULL,'D-0608','0.4841',NULL,'CRISTOBAL DEL SOLAR',NULL,53304492,0,68227,0),(1493,NULL,'D-0609','0.4659',NULL,'JUAN Fco. CARVAJAL DAMANN ',NULL,53304492,0,89170,0),(1494,NULL,'D-0610','0.5109',NULL,'ANDRES FERNANDEZ',NULL,53304492,0,168035,0),(1495,NULL,'D-0611','0.4667',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,81928,0),(1496,NULL,'D-0701','0.4766',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,80775,0),(1497,NULL,'D-0702','0.5216',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,80985,0),(1498,NULL,'D-0703','0.4639',NULL,'ROLANDO ROJAS ROJAS ',NULL,53304492,0,84011,0),(1499,NULL,'D-0704','0.4944',NULL,'ALBERT CLARO',NULL,53304492,0,83103,0),(1500,NULL,'D-0705','0.7424',NULL,'MARICEL HENRIQUEZ',NULL,53304492,0,109364,0),(1501,NULL,'D-0706','0.4558',NULL,'CARMEN LUZ LARRAIN',NULL,53304492,0,204463,0),(1502,NULL,'D-0707','0.7506',NULL,'BERNARDITA PAGUEGUY (191.296)',NULL,53304492,0,128084,0),(1503,NULL,'D-0708','0.4925',NULL,'JULIETA PHILLIPS',NULL,53304492,0,302579,0),(1504,NULL,'D-0709','0.4651',NULL,'JUDITH CAÑAS MEDEL ',NULL,53304492,0,123944,0),(1505,NULL,'D-0710','0.5121',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,180060,0),(1506,NULL,'D-0711','0.4785',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,78575,0),(1507,NULL,'D-0801','0.4750',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,78117,0),(1508,NULL,'D-0802','0.5102',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,84392,0),(1509,NULL,'D-0803','0.4640',NULL,'ALBERTO CLARO VIAL',NULL,53304492,0,74229,0),(1510,NULL,'D-0804','0.4922',NULL,'ITALIA ROSAS',NULL,53304492,0,75319,0),(1511,NULL,'D-0805','0.7258',NULL,'SANDRA GARCIA',NULL,53304492,0,148863,0),(1512,NULL,'D-0806','0.4669',NULL,'JAVIER  VALLE PONCE',NULL,53304492,0,75772,0),(1513,NULL,'D-0807','0.8081',NULL,'ENRIQUE HAQUIN',NULL,53304492,0,242948,0),(1514,NULL,'D-0808','0.5048',NULL,'EMA ROJAS',NULL,53304492,0,169802,0),(1515,NULL,'D-0809','0.4543',NULL,'JUAN EDUARDO UNDURRAGA',NULL,53304492,0,336964,0),(1516,NULL,'D-0810','0.5102',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,89289,0),(1517,NULL,'D-0811','0.4864',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,79608,0),(1518,NULL,'D-0901','0.4765',NULL,'YOLANDA VIAL',NULL,53304492,0,80762,0),(1519,NULL,'D-0902','0.5218',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,93255,0),(1520,NULL,'D-0903','0.4647',NULL,'PUBLICIDAD Y PROM. ESPERANZA S.A',NULL,53304492,0,76769,0),(1521,NULL,'D-0904','0.4949',NULL,'AUGUSTO ZAVALA',NULL,53304492,0,69640,0),(1522,NULL,'D-0905','0.6841',NULL,'MARIA CECILIA GOYCOLEA MOZO',NULL,53304492,0,114487,0),(1523,NULL,'D-0906','0.4573',NULL,'JULIETA PHILIPS',NULL,53304492,0,275671,0),(1524,NULL,'D-0907','0.7585',NULL,'MARIA PIA LAGOS JOFRÉ ',NULL,53304492,0,111319,0),(1525,NULL,'D-0908','0.4949',NULL,'PATRICIA CASTILLO FELIU',NULL,53304492,0,83169,0),(1526,NULL,'D-0909','0.4543',NULL,'AURORA ARELLANO',NULL,53304492,0,473712,0),(1527,NULL,'D-0910','0.5137',NULL,'PABLO GARCES ACUÑA',NULL,53304492,0,79446,0),(1528,NULL,'D-0911','0.4764',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,75851,0),(1529,NULL,'D-1001','0.4750',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,83014,0),(1530,NULL,'D-1002','0.5108',NULL,'JOSE LUIS GRAU',NULL,53304492,0,69271,0),(1531,NULL,'D-1003','0.4622',NULL,'TOMAS VILLAGRA VEGA',NULL,53304492,0,62092,0),(1532,NULL,'D-1004','0.5039',NULL,'M.a TERESA VENTURINO SEPULVEDA',NULL,53304492,0,143531,0),(1533,NULL,'D-1005','0.7284',NULL,'EDUARDO PADILLA ROBLES',NULL,53304492,0,87943,0),(1534,NULL,'D-1006','0.4567',NULL,'CAROLINA GUTIERREZ',NULL,53304492,0,66793,0),(1535,NULL,'D-1007','0.7617',NULL,'PAULA FUENTEALBA QUEZADA',NULL,53304492,0,106991,0),(1536,NULL,'D-1008','0.4931',NULL,'JUAN ESPINOZA MEDEL',NULL,53304492,0,320996,0),(1537,NULL,'D-1009','0.4654',NULL,'JULIA CASTILLO FELIU',NULL,53304492,0,76861,0),(1538,NULL,'D-1010','0.5102',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,84392,0),(1539,NULL,'D-1011','0.4750',NULL,'INMOBILIARIA E INVERS. RODE LTDA.',NULL,53304492,0,150975,0),(1540,NULL,'D-1101','0.4750',NULL,'RICARDO JULIAN SAID',NULL,53304492,0,73219,0),(1541,NULL,'D-1102','0.5217',NULL,'YOLANDA VIAL DONOSO',NULL,53304492,0,85896,0),(1542,NULL,'D-1103','0.4270',NULL,'CAROLINA TALLAR PABST',NULL,53304492,0,70816,0),(1543,NULL,'D-1104','0.4929',NULL,'LUIS EDUARDO GALLARDO ',NULL,53304492,0,64481,0),(1544,NULL,'D-1105','0.7743',NULL,'MARIA HURTADO LATORRE',NULL,53304492,0,220431,0),(1545,NULL,'D-1106','0.4554',NULL,'JULIETA PHILLIPS',NULL,53304492,0,66921,0),(1546,NULL,'D-1107','0.7705',NULL,'LILIAN VEGA',NULL,53304492,0,130688,0),(1547,NULL,'D-1108','0.4939',NULL,'JUAN MORAGA PEÑA ',NULL,53304492,0,75692,0),(1548,NULL,'D-1109','0.4645',NULL,'RAFAEL GATICA VARAS',NULL,53304492,0,125675,0),(1549,NULL,'D-1110','0.5122',NULL,'MARIA TERESA GUTIERREZ',NULL,53304492,0,79249,0),(1550,NULL,'D-1111','0.4865',NULL,'SOFIA HOTT',NULL,53304492,0,66140,0),(1551,NULL,'D-1201','0.4865',NULL,'NEIA RODRIGUEZ',NULL,53304492,0,63644,0),(1552,NULL,'D-1202','0.5102',NULL,'JOSE RIVERA',NULL,53304492,0,163878,0),(1553,NULL,'D-1203','0.4746',NULL,'EVELYN   RAPAPORT',NULL,53304492,0,75616,0),(1554,NULL,'D-1204','0.4920',NULL,'MARIA COYA FERNANDEZ',NULL,53304492,0,66812,0),(1555,NULL,'D-1205','0.6729',NULL,'GUSTAVO KREFFT PUELMA',NULL,53304492,0,92926,0),(1556,NULL,'D-1206','0.4554',NULL,'INVERSIONES JP LTDA.',NULL,53304492,0,62024,0),(1557,NULL,'D-1207','0.7602',NULL,'PABLO GARCIA ',NULL,53304492,0,393878,0),(1558,NULL,'D-1208','0.4942',NULL,'MONICA SLEBE TAJMUCH',NULL,53304492,0,452751,0),(1559,NULL,'D-1209','0.4742',NULL,'MARISOL SANTA MARIA ',NULL,53304492,0,78012,0),(1560,NULL,'D-1210','0.5120',NULL,'JAVIER MORAGA',NULL,53304492,0,151912,0),(1561,NULL,'D-1211','0.4769',NULL,'MARIA EUGENIA CLARO',NULL,53304492,0,62388,0),(1562,NULL,'D-1301','0.4739',NULL,'RODRIGO CARRASCO',NULL,53304492,0,71790,0),(1563,NULL,'D-1302','0.5148',NULL,'SERGIO JELINCIC DEL CAMPO',NULL,53304492,0,69795,0),(1564,NULL,'D-1303','0.4642',NULL,'JAIME DIAZ DE VALDES',NULL,53304492,0,60303,0),(1565,NULL,'D-1304','0.5040',NULL,'M. EUGENIA IRARRAZABAL',NULL,53304492,0,267361,0),(1566,NULL,'D-1305','0.7719',NULL,'JULIAN ARANGUIZ',NULL,53304492,0,378136,0),(1567,NULL,'D-1306','0.4676',NULL,'CHRISTIAN RECART PIZARRO ',NULL,53304492,0,68517,0),(1568,NULL,'D-1307','0.7609',NULL,'OSVALDO ACEVEDO PEREZ',NULL,53304492,0,248044,0),(1569,NULL,'D-1308','0.4924',NULL,'PABLO GRAN LOPEZ',NULL,53304492,0,82499,0),(1570,NULL,'D-1309','0.4627',NULL,'PILAR ADRIAZOLA',NULL,53304492,0,177663,0),(1571,NULL,'D-1310','0.4635',NULL,'FELIPE ORTIZ',NULL,53304492,0,60635,0),(1572,NULL,'D-1311','0.4270',NULL,'PAULA PULGAR CABRERA',NULL,53304492,0,65655,0),(1573,NULL,'D-1401','0.4747',NULL,'XIMENA REYES',NULL,53304492,0,273767,0),(1574,NULL,'D-1402','0.5122',NULL,'MARIA CAROLINA TRONCOS MOUAT',NULL,53304492,0,150740,0),(1575,NULL,'D-1403','0.4643',NULL,'PABLO VADES ALDUNATE',NULL,53304492,0,153036,0),(1576,NULL,'D-1404','0.4932',NULL,'XIMENA REYES',NULL,53304492,0,170998,0),(1577,NULL,'D-1405','0.7383',NULL,'DANIELA BERTOGLIA NAVARRO',NULL,53304492,0,119129,0),(1578,NULL,'D-1406','0.4589',NULL,'EDITH SALAZAR',NULL,53304492,0,260858,0),(1579,NULL,'D-1407','0.7599',NULL,'ENRIQUE RODRIGUEZ CALLEJAS',NULL,53304492,0,155174,0),(1580,NULL,'D-1408','0.4939',NULL,'FRANCISCO CABEZAS BONILLA',NULL,53304492,0,153747,0),(1581,NULL,'D-1409','0.4621',NULL,'MARIA FERNANDA GOMEZ',NULL,53304492,0,78878,0),(1582,NULL,'D-1410','0.5137',NULL,'ALEJANDO CARPENTER TORRES',NULL,53304492,0,87288,0),(1583,NULL,'D-1411','0.4770',NULL,'MACARENA HERRERA',NULL,53304492,0,62401,0),(1584,NULL,'D-1501','0.4864',NULL,'ALBERTO CLARO',NULL,53304492,0,71860,0),(1585,NULL,'D-1502','0.5217',NULL,'ALBERTO CLARO',NULL,53304492,0,175477,0),(1586,NULL,'D-1503','0.4641',NULL,'SANDRA NOVOA',NULL,53304492,0,65611,0),(1587,NULL,'D-1504','0.4920',NULL,'ELIZABETH RUDNICK',NULL,53304492,0,64363,0),(1588,NULL,'D-1505','0.7282',NULL,'NICOLÁS ISA',NULL,53304492,0,112404,0),(1589,NULL,'D-1506','0.4573',NULL,'MACARENA SMITS',NULL,53304492,0,67170,0),(1590,NULL,'D-1507','0.7625',NULL,'M. FERNANDA MUÑOZ HOCES',NULL,53304492,0,223511,0),(1591,NULL,'D-1508','0.4944',NULL,'NANCY ARAVENA NEIRA',NULL,53304492,0,75757,0),(1592,NULL,'D-1509','0.4741',NULL,'INMOBILIARIA E INVERS. COPIHUAL',NULL,53304492,0,73102,0),(1593,NULL,'D-1510','0.5119',NULL,'ANDREA HALABI MOREL',NULL,53304492,0,74313,0),(1594,NULL,'D-1511','0.4767',NULL,'ROBERTO SEGOVIA',NULL,53304492,0,62326,0),(1595,NULL,'D-1601','0.4876',NULL,'ANTONIO BARBIERI',NULL,53304492,0,74868,0),(1596,NULL,'D-1602','0.5138',NULL,'ALVARO ARANDA',NULL,53304492,0,268778,0),(1597,NULL,'D-1603','0.4616',NULL,'MARIA COYA FERNANDEZ',NULL,53304492,0,60386,0),(1598,NULL,'D-1604','0.6811',NULL,'CLAUDIA CASTILLO ARAYA',NULL,53304492,0,235471,0),(1599,NULL,'D-1605','0.4270',NULL,'ROBERTO SEGOVIA MELERO',NULL,53304492,0,58309,0),(1600,NULL,'D-1606','0.4371',NULL,'GUSTAVO KREFFT PUELMA',NULL,53304492,0,62079,0),(1601,NULL,'D-1607','0.6793',NULL,'IGNACIO VICUÑA BAEZA',NULL,53304492,0,111411,0),(1602,NULL,'D-1608','0.4626',NULL,'PAMELA JARA VENEGAS',NULL,53304492,0,92138,0),(1603,NULL,'D-1609','0.5243',NULL,'INMOBILIARIA E INVERS. CRISPA',NULL,53304492,0,266952,0),(1604,NULL,'D-1610','0.4809',NULL,'PABLO VALDES ALDUNATE',NULL,53304492,0,176755,0),(1605,NULL,'D-1701','0.4739',NULL,'ALBERTO CLARO',NULL,53304492,0,76376,0),(1606,NULL,'D-1702','0.5039',NULL,'SOC. DE INV. STA. M. DE LOS ANGELES',NULL,53304492,0,250826,0),(1607,NULL,'D-1703','0.4644',NULL,'JOSE CARMONA',NULL,53304492,0,60753,0),(1608,NULL,'D-1704','0.6785',NULL,'FLORA BARRERA MIRANDA ',NULL,53304492,0,186023,0),(1609,NULL,'D-1705','0.4273',NULL,'JUAN  LLONA',NULL,53304492,0,58348,0),(1610,NULL,'D-1706','0.4273',NULL,'INMOBILIARIA E INVERS. COPIHUAL',NULL,53304492,0,58348,0),(1611,NULL,'D-1707','0.6781',NULL,'MARIA ISABEL VILLEGAS',NULL,53304492,0,107135,0),(1612,NULL,'D-1708','0.4645',NULL,'JUAN ESPINOZA MEDEL',NULL,53304492,0,142650,0),(1613,NULL,'D-1709','0.5117',NULL,'RODRIGO PEREZ DE CASTRO',NULL,53304492,0,146203,0),(1614,NULL,'D-1710','0.4759',NULL,'TOMAS VILLAGRA',NULL,53304492,0,146450,0),(1615,NULL,'L-1','1.0949',NULL,'INMOB. E INVERS. CATALUNYA',NULL,53304492,0,494631,0),(1616,NULL,'L-2','1.3904',NULL,'BANCO BCI',NULL,53304492,0,196591,0),(1617,NULL,'L-3','0.9172',NULL,'BANCO BCI',NULL,53304492,0,134688,0),(1618,NULL,'OF-201','0.3432',NULL,'ARTURO BENAVIDES DITTBORN',NULL,53304492,0,181239,0),(1619,NULL,'OF-202','0.3472',NULL,'ALEXANDRA CAVERO VIDAL',NULL,53304492,0,55811,0),(1620,NULL,'OF-203','0.3351',NULL,'PATRICIO CAÑETE',NULL,53304492,0,107367,0),(1621,NULL,'OF-204','3.0449',NULL,'INVERSIONES J.R.C LTDA.',NULL,53304492,0,507842,0),(1622,NULL,'OF-210','0.5635',NULL,'GABRIELA FICHELSON',NULL,53304492,0,85327,0),(1623,NULL,'OF-211','0.8939',NULL,'B@CKOFFICE CONSULTING',NULL,53304492,0,445107,0),(1624,NULL,'OF-212','0.6578',NULL,'SILVIA BARRIENTOS',NULL,53304492,0,86053,0),(1625,NULL,'OF-214','3.4589',NULL,'GEOSINERGIA',NULL,53304492,0,472002,0),(1626,NULL,'AJUSTE','0,5373',NULL,'GEOSINERGIA',NULL,53304492,0,0,0);

--
-- Table structure for table `departamentos_has_medidores`
--

CREATE TABLE `departamentos_has_medidores` (
  `departamentos_iddepartamento` int(11) NOT NULL,
  `departamentos_propiedades_rut` int(11) NOT NULL,
  `medidores_idmedidores` int(11) NOT NULL,
  `anio` int(11) DEFAULT NULL,
  `mes` int(11) DEFAULT NULL,
  `lecturaAnterior` decimal(10,0) DEFAULT NULL,
  `lecturaActual` decimal(10,0) DEFAULT '0',
  `consumo` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`departamentos_iddepartamento`,`departamentos_propiedades_rut`,`medidores_idmedidores`),
  KEY `fk_departamentos_has_medidores_medidores1_idx` (`medidores_idmedidores`),
  KEY `fk_departamentos_has_medidores_departamentos1_idx` (`departamentos_iddepartamento`,`departamentos_propiedades_rut`),
  CONSTRAINT `fk_departamentos_has_medidores_departamentos1` FOREIGN KEY (`departamentos_iddepartamento`, `departamentos_propiedades_rut`) REFERENCES `departamentos` (`iddepartamento`, `propiedades_rut`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_departamentos_has_medidores_medidores1` FOREIGN KEY (`medidores_idmedidores`) REFERENCES `medidores` (`idmedidores`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `departamentos_has_medidores`
--


--
-- Table structure for table `encGastos`
--

CREATE TABLE `encGastos` (
  `idencGastos` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` datetime DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `mes` int(11) DEFAULT NULL,
  `cobroGenerado` tinyint(1) DEFAULT NULL,
  `propiedades_rut` int(11) NOT NULL,
  `estadoCerrarMes` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`idencGastos`,`propiedades_rut`),
  KEY `fk_encGastos_propiedades1_idx` (`propiedades_rut`),
  CONSTRAINT `fk_encGastos_propiedades1` FOREIGN KEY (`propiedades_rut`) REFERENCES `propiedades` (`rut`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `encGastos`
--

INSERT INTO `encGastos` VALUES (79,'2017-02-08 20:22:33',2017,2,1,-8,0),(80,'2017-02-08 20:29:49',2017,1,1,-8,0),(81,'2017-02-08 20:55:16',2017,3,0,-8,0),(82,'2017-02-10 23:40:08',2016,12,1,-8,0),(83,'2017-02-10 23:49:12',2016,11,1,-8,0);

--
-- Table structure for table `gastos`
--

CREATE TABLE `gastos` (
  `idgastos` int(11) NOT NULL AUTO_INCREMENT,
  `monto` int(11) DEFAULT NULL,
  `numero_boleta` varchar(45) DEFAULT NULL,
  `fecha` datetime DEFAULT NULL,
  `observaciones` varchar(255) DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `mes` int(11) DEFAULT NULL,
  `rut_proveedor` varchar(45) DEFAULT NULL,
  `nombre_proveedor` varchar(200) DEFAULT NULL,
  `tipo_gasto` varchar(45) DEFAULT NULL,
  `boleta` blob,
  `comprobante` blob,
  `encGastos_idencGastos` int(11) NOT NULL,
  `encGastos_propiedades_rut` int(11) NOT NULL,
  PRIMARY KEY (`idgastos`,`encGastos_idencGastos`,`encGastos_propiedades_rut`),
  KEY `fk_gastos_encGastos1_idx` (`encGastos_idencGastos`,`encGastos_propiedades_rut`),
  CONSTRAINT `fk_gastos_encGastos1` FOREIGN KEY (`encGastos_idencGastos`, `encGastos_propiedades_rut`) REFERENCES `encGastos` (`idencGastos`, `propiedades_rut`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gastos`
--

INSERT INTO `gastos` VALUES (180,500000,'102','2017-02-08 20:22:33','boleta chilectra',2017,2,'16680254-7','Chilectra','Gastos de uso o consumo','boleta','comprobante',79,-8),(181,400000,'5465','2017-02-08 20:23:41','',2017,2,'11111111-1','Agua','Gastos de uso o consumo','boleta','comprobante',79,-8),(182,150000,'12','2017-02-08 20:24:42','',2017,2,'6365510-4','sada','Gastos de mantención','boleta','comprobante',79,-8),(183,90000,'56','2017-02-08 20:25:20','jejeje',2017,2,'55555555-5','internet','Gastos de uso o consumo','boleta','comprobante',79,-8),(184,900000,'78','2017-02-08 20:29:49','',2017,1,'16680254-7','gas','Gastos de uso o consumo','boleta','comprobante',80,-8),(185,450000,'12','2017-02-08 20:30:24','',2017,1,'6365510-4','piscina','Gastos de mantención','boleta','comprobante',80,-8),(186,185652,'45','2017-02-08 20:31:41','',2017,1,'16680254-7','sodimac','Gastos de reparación y otros','boleta','comprobante',80,-8),(188,450000,'56','2017-02-10 23:40:08','',2016,12,'16680254-7','gas','Gastos de uso o consumo','boleta','comprobante',82,-8),(189,650000,'454','2017-02-10 23:40:50','',2016,12,'55555555-5','luz','Gastos de uso o consumo','boleta','comprobante',82,-8),(190,1000000,'DSFS','2017-02-10 23:49:12','',2016,11,'16680254-7','DUSTY','Remuneraciones','boleta','comprobante',83,-8);

--
-- Table structure for table `gastoscomunes`
--

CREATE TABLE `gastoscomunes` (
  `idgastocomunes` int(11) NOT NULL AUTO_INCREMENT,
  `fecha_pago` datetime DEFAULT NULL,
  `monto` int(11) DEFAULT NULL,
  `estado` varchar(50) DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `mes` int(11) DEFAULT NULL,
  `khipu_paymentid` varchar(45) DEFAULT NULL,
  `khipu_conciliation` datetime DEFAULT NULL,
  `departamentos_propiedades_rut` int(11) NOT NULL,
  `departamentos_iddepartamento` int(11) NOT NULL,
  `notificacion` tinyint(1) DEFAULT NULL,
  `fechaNotificacion` datetime DEFAULT NULL,
  `pagoVencido` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`idgastocomunes`,`departamentos_propiedades_rut`,`departamentos_iddepartamento`),
  KEY `fk_gastoscomunes_departamentos1_idx` (`departamentos_iddepartamento`,`departamentos_propiedades_rut`),
  CONSTRAINT `fk_gastoscomunes_departamentos1` FOREIGN KEY (`departamentos_iddepartamento`, `departamentos_propiedades_rut`) REFERENCES `departamentos` (`iddepartamento`, `propiedades_rut`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2023 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gastoscomunes`
--

INSERT INTO `gastoscomunes` VALUES (1783,'2017-02-08 20:26:40',14125,'Pagado',2017,2,NULL,NULL,-8,1218,NULL,NULL,NULL),(1784,'0000-00-00 00:00:00',19198,'Pendiente',2017,2,NULL,NULL,-8,1219,NULL,NULL,NULL),(1785,'0000-00-00 00:00:00',19186,'Pendiente',2017,2,NULL,NULL,-8,1220,NULL,NULL,NULL),(1786,'0000-00-00 00:00:00',18685,'Pendiente',2017,2,NULL,NULL,-8,1221,NULL,NULL,NULL),(1787,'0000-00-00 00:00:00',14261,'Pendiente',2017,2,NULL,NULL,-8,1222,NULL,NULL,NULL),(1788,'2017-02-08 20:27:00',24157,'Pagado',2017,2,NULL,NULL,-8,1223,NULL,NULL,NULL),(1789,'2017-02-08 20:27:18',20406,'Pagado',2017,2,NULL,NULL,-8,1224,NULL,NULL,NULL),(1790,'0000-00-00 00:00:00',18821,'Pendiente',2017,2,NULL,NULL,-8,1225,NULL,NULL,NULL),(1791,'0000-00-00 00:00:00',14182,'Pendiente',2017,2,NULL,NULL,-8,1226,NULL,NULL,NULL),(1792,'0000-00-00 00:00:00',22492,'Pendiente',2017,2,NULL,NULL,-8,1227,NULL,NULL,NULL),(1793,'0000-00-00 00:00:00',21979,'Pendiente',2017,2,NULL,NULL,-8,1228,NULL,NULL,NULL),(1794,'0000-00-00 00:00:00',17111,'Pendiente',2017,2,NULL,NULL,-8,1229,NULL,NULL,NULL),(1795,'0000-00-00 00:00:00',14170,'Pendiente',2017,2,NULL,NULL,-8,1230,NULL,NULL,NULL),(1796,'0000-00-00 00:00:00',20828,'Pendiente',2017,2,NULL,NULL,-8,1231,NULL,NULL,NULL),(1797,'0000-00-00 00:00:00',21956,'Pendiente',2017,2,NULL,NULL,-8,1232,NULL,NULL,NULL),(1798,'0000-00-00 00:00:00',20702,'Pendiente',2017,2,NULL,NULL,-8,1233,NULL,NULL,NULL),(1799,'2017-02-08 20:27:32',12540,'Pagado',2017,2,NULL,NULL,-8,1234,NULL,NULL,NULL),(1800,'0000-00-00 00:00:00',21352,'Pendiente',2017,2,NULL,NULL,-8,1235,NULL,NULL,NULL),(1801,'0000-00-00 00:00:00',22184,'Pendiente',2017,2,NULL,NULL,-8,1236,NULL,NULL,NULL),(1802,'0000-00-00 00:00:00',20360,'Pendiente',2017,2,NULL,NULL,-8,1237,NULL,NULL,NULL),(1803,'0000-00-00 00:00:00',14307,'Pendiente',2017,2,NULL,NULL,-8,1238,NULL,NULL,NULL),(1804,'0000-00-00 00:00:00',21557,'Pendiente',2017,2,NULL,NULL,-8,1239,NULL,NULL,NULL),(1805,'0000-00-00 00:00:00',22002,'Pendiente',2017,2,NULL,NULL,-8,1240,NULL,NULL,NULL),(1806,'0000-00-00 00:00:00',18753,'Pendiente',2017,2,NULL,NULL,-8,1241,NULL,NULL,NULL),(1807,'0000-00-00 00:00:00',14204,'Pendiente',2017,2,NULL,NULL,-8,1242,NULL,NULL,NULL),(1808,'0000-00-00 00:00:00',20851,'Pendiente',2017,2,NULL,NULL,-8,1243,NULL,NULL,NULL),(1809,'0000-00-00 00:00:00',22036,'Pendiente',2017,2,NULL,NULL,-8,1244,NULL,NULL,NULL),(1810,'0000-00-00 00:00:00',18628,'Pendiente',2017,2,NULL,NULL,-8,1245,NULL,NULL,NULL),(1811,'0000-00-00 00:00:00',14307,'Pendiente',2017,2,NULL,NULL,-8,1246,NULL,NULL,NULL),(1812,'0000-00-00 00:00:00',22002,'Pendiente',2017,2,NULL,NULL,-8,1247,NULL,NULL,NULL),(1813,'0000-00-00 00:00:00',21911,'Pendiente',2017,2,NULL,NULL,-8,1248,NULL,NULL,NULL),(1814,'0000-00-00 00:00:00',18810,'Pendiente',2017,2,NULL,NULL,-8,1249,NULL,NULL,NULL),(1815,'0000-00-00 00:00:00',14182,'Pendiente',2017,2,NULL,NULL,-8,1250,NULL,NULL,NULL),(1816,'0000-00-00 00:00:00',20839,'Pendiente',2017,2,NULL,NULL,-8,1251,NULL,NULL,NULL),(1817,'0000-00-00 00:00:00',22207,'Pendiente',2017,2,NULL,NULL,-8,1252,NULL,NULL,NULL),(1818,'0000-00-00 00:00:00',18776,'Pendiente',2017,2,NULL,NULL,-8,1253,NULL,NULL,NULL),(1819,'0000-00-00 00:00:00',14341,'Pendiente',2017,2,NULL,NULL,-8,1254,NULL,NULL,NULL),(1820,'0000-00-00 00:00:00',20816,'Pendiente',2017,2,NULL,NULL,-8,1255,NULL,NULL,NULL),(1821,'0000-00-00 00:00:00',22105,'Pendiente',2017,2,NULL,NULL,-8,1256,NULL,NULL,NULL),(1822,'0000-00-00 00:00:00',18742,'Pendiente',2017,2,NULL,NULL,-8,1257,NULL,NULL,NULL),(1823,'0000-00-00 00:00:00',16234,'Pendiente',2017,2,NULL,NULL,-8,1258,NULL,NULL,NULL),(1824,'0000-00-00 00:00:00',20771,'Pendiente',2017,2,NULL,NULL,-8,1259,NULL,NULL,NULL),(1825,'0000-00-00 00:00:00',22162,'Pendiente',2017,2,NULL,NULL,-8,1260,NULL,NULL,NULL),(1826,'0000-00-00 00:00:00',19027,'Pendiente',2017,2,NULL,NULL,-8,1261,NULL,NULL,NULL),(1827,'0000-00-00 00:00:00',12631,'Pendiente',2017,2,NULL,NULL,-8,1262,NULL,NULL,NULL),(1828,'0000-00-00 00:00:00',22469,'Pendiente',2017,2,NULL,NULL,-8,1263,NULL,NULL,NULL),(1829,'0000-00-00 00:00:00',23701,'Pendiente',2017,2,NULL,NULL,-8,1264,NULL,NULL,NULL),(1830,'0000-00-00 00:00:00',17294,'Pendiente',2017,2,NULL,NULL,-8,1265,NULL,NULL,NULL),(1831,'0000-00-00 00:00:00',14227,'Pendiente',2017,2,NULL,NULL,-8,1266,NULL,NULL,NULL),(1832,'0000-00-00 00:00:00',20851,'Pendiente',2017,2,NULL,NULL,-8,1267,NULL,NULL,NULL),(1833,'0000-00-00 00:00:00',22789,'Pendiente',2017,2,NULL,NULL,-8,1268,NULL,NULL,NULL),(1834,'0000-00-00 00:00:00',18913,'Pendiente',2017,2,NULL,NULL,-8,1269,NULL,NULL,NULL),(1835,'0000-00-00 00:00:00',15892,'Pendiente',2017,2,NULL,NULL,-8,1270,NULL,NULL,NULL),(1836,'0000-00-00 00:00:00',17488,'Pendiente',2017,2,NULL,NULL,-8,1271,NULL,NULL,NULL),(1837,'0000-00-00 00:00:00',22013,'Pendiente',2017,2,NULL,NULL,-8,1272,NULL,NULL,NULL),(1838,'0000-00-00 00:00:00',18867,'Pendiente',2017,2,NULL,NULL,-8,1273,NULL,NULL,NULL),(1839,'0000-00-00 00:00:00',14284,'Pendiente',2017,2,NULL,NULL,-8,1274,NULL,NULL,NULL),(1840,'0000-00-00 00:00:00',19198,'Pendiente',2017,2,NULL,NULL,-8,1275,NULL,NULL,NULL),(1841,'0000-00-00 00:00:00',22219,'Pendiente',2017,2,NULL,NULL,-8,1276,NULL,NULL,NULL),(1842,'0000-00-00 00:00:00',18901,'Pendiente',2017,2,NULL,NULL,-8,1277,NULL,NULL,NULL),(1843,'2017-02-08 20:34:55',69027,'Pagado',2017,1,NULL,NULL,-8,1218,NULL,NULL,NULL),(1844,'0000-00-00 00:00:00',25860,'Pendiente',2017,1,NULL,NULL,-8,1219,NULL,NULL,NULL),(1845,'0000-00-00 00:00:00',25845,'Pendiente',2017,1,NULL,NULL,-8,1220,NULL,NULL,NULL),(1846,'0000-00-00 00:00:00',25169,'Pendiente',2017,1,NULL,NULL,-8,1221,NULL,NULL,NULL),(1847,'0000-00-00 00:00:00',19211,'Pendiente',2017,1,NULL,NULL,-8,1222,NULL,NULL,NULL),(1848,'0000-00-00 00:00:00',32540,'Pendiente',2017,1,NULL,NULL,-8,1223,NULL,NULL,NULL),(1849,'0000-00-00 00:00:00',27488,'Pendiente',2017,1,NULL,NULL,-8,1224,NULL,NULL,NULL),(1850,'0000-00-00 00:00:00',25354,'Pendiente',2017,1,NULL,NULL,-8,1225,NULL,NULL,NULL),(1851,'0000-00-00 00:00:00',19104,'Pendiente',2017,1,NULL,NULL,-8,1226,NULL,NULL,NULL),(1852,'0000-00-00 00:00:00',30298,'Pendiente',2017,1,NULL,NULL,-8,1227,NULL,NULL,NULL),(1853,'0000-00-00 00:00:00',29607,'Pendiente',2017,1,NULL,NULL,-8,1228,NULL,NULL,NULL),(1854,'0000-00-00 00:00:00',23050,'Pendiente',2017,1,NULL,NULL,-8,1229,NULL,NULL,NULL),(1855,'0000-00-00 00:00:00',19088,'Pendiente',2017,1,NULL,NULL,-8,1230,NULL,NULL,NULL),(1856,'0000-00-00 00:00:00',28056,'Pendiente',2017,1,NULL,NULL,-8,1231,NULL,NULL,NULL),(1857,'0000-00-00 00:00:00',29577,'Pendiente',2017,1,NULL,NULL,-8,1232,NULL,NULL,NULL),(1858,'0000-00-00 00:00:00',27887,'Pendiente',2017,1,NULL,NULL,-8,1233,NULL,NULL,NULL),(1859,'0000-00-00 00:00:00',16892,'Pendiente',2017,1,NULL,NULL,-8,1234,NULL,NULL,NULL),(1860,'0000-00-00 00:00:00',28763,'Pendiente',2017,1,NULL,NULL,-8,1235,NULL,NULL,NULL),(1861,'0000-00-00 00:00:00',29884,'Pendiente',2017,1,NULL,NULL,-8,1236,NULL,NULL,NULL),(1862,'0000-00-00 00:00:00',27427,'Pendiente',2017,1,NULL,NULL,-8,1237,NULL,NULL,NULL),(1863,'0000-00-00 00:00:00',19272,'Pendiente',2017,1,NULL,NULL,-8,1238,NULL,NULL,NULL),(1864,'0000-00-00 00:00:00',29039,'Pendiente',2017,1,NULL,NULL,-8,1239,NULL,NULL,NULL),(1865,'0000-00-00 00:00:00',29638,'Pendiente',2017,1,NULL,NULL,-8,1240,NULL,NULL,NULL),(1866,'0000-00-00 00:00:00',25261,'Pendiente',2017,1,NULL,NULL,-8,1241,NULL,NULL,NULL),(1867,'0000-00-00 00:00:00',19134,'Pendiente',2017,1,NULL,NULL,-8,1242,NULL,NULL,NULL),(1868,'0000-00-00 00:00:00',28087,'Pendiente',2017,1,NULL,NULL,-8,1243,NULL,NULL,NULL),(1869,'0000-00-00 00:00:00',29684,'Pendiente',2017,1,NULL,NULL,-8,1244,NULL,NULL,NULL),(1870,'0000-00-00 00:00:00',25093,'Pendiente',2017,1,NULL,NULL,-8,1245,NULL,NULL,NULL),(1871,'0000-00-00 00:00:00',19272,'Pendiente',2017,1,NULL,NULL,-8,1246,NULL,NULL,NULL),(1872,'0000-00-00 00:00:00',29638,'Pendiente',2017,1,NULL,NULL,-8,1247,NULL,NULL,NULL),(1873,'0000-00-00 00:00:00',29515,'Pendiente',2017,1,NULL,NULL,-8,1248,NULL,NULL,NULL),(1874,'0000-00-00 00:00:00',25338,'Pendiente',2017,1,NULL,NULL,-8,1249,NULL,NULL,NULL),(1875,'0000-00-00 00:00:00',19104,'Pendiente',2017,1,NULL,NULL,-8,1250,NULL,NULL,NULL),(1876,'0000-00-00 00:00:00',28072,'Pendiente',2017,1,NULL,NULL,-8,1251,NULL,NULL,NULL),(1877,'0000-00-00 00:00:00',29915,'Pendiente',2017,1,NULL,NULL,-8,1252,NULL,NULL,NULL),(1878,'0000-00-00 00:00:00',25292,'Pendiente',2017,1,NULL,NULL,-8,1253,NULL,NULL,NULL),(1879,'0000-00-00 00:00:00',19319,'Pendiente',2017,1,NULL,NULL,-8,1254,NULL,NULL,NULL),(1880,'0000-00-00 00:00:00',28041,'Pendiente',2017,1,NULL,NULL,-8,1255,NULL,NULL,NULL),(1881,'0000-00-00 00:00:00',29776,'Pendiente',2017,1,NULL,NULL,-8,1256,NULL,NULL,NULL),(1882,'0000-00-00 00:00:00',25246,'Pendiente',2017,1,NULL,NULL,-8,1257,NULL,NULL,NULL),(1883,'0000-00-00 00:00:00',21868,'Pendiente',2017,1,NULL,NULL,-8,1258,NULL,NULL,NULL),(1884,'0000-00-00 00:00:00',27980,'Pendiente',2017,1,NULL,NULL,-8,1259,NULL,NULL,NULL),(1885,'0000-00-00 00:00:00',29853,'Pendiente',2017,1,NULL,NULL,-8,1260,NULL,NULL,NULL),(1886,'0000-00-00 00:00:00',25630,'Pendiente',2017,1,NULL,NULL,-8,1261,NULL,NULL,NULL),(1887,'0000-00-00 00:00:00',17015,'Pendiente',2017,1,NULL,NULL,-8,1262,NULL,NULL,NULL),(1888,'0000-00-00 00:00:00',30268,'Pendiente',2017,1,NULL,NULL,-8,1263,NULL,NULL,NULL),(1889,'0000-00-00 00:00:00',31926,'Pendiente',2017,1,NULL,NULL,-8,1264,NULL,NULL,NULL),(1890,'0000-00-00 00:00:00',23296,'Pendiente',2017,1,NULL,NULL,-8,1265,NULL,NULL,NULL),(1891,'0000-00-00 00:00:00',19165,'Pendiente',2017,1,NULL,NULL,-8,1266,NULL,NULL,NULL),(1892,'0000-00-00 00:00:00',28087,'Pendiente',2017,1,NULL,NULL,-8,1267,NULL,NULL,NULL),(1893,'0000-00-00 00:00:00',30698,'Pendiente',2017,1,NULL,NULL,-8,1268,NULL,NULL,NULL),(1894,'0000-00-00 00:00:00',25476,'Pendiente',2017,1,NULL,NULL,-8,1269,NULL,NULL,NULL),(1895,'0000-00-00 00:00:00',21407,'Pendiente',2017,1,NULL,NULL,-8,1270,NULL,NULL,NULL),(1896,'0000-00-00 00:00:00',23557,'Pendiente',2017,1,NULL,NULL,-8,1271,NULL,NULL,NULL),(1897,'0000-00-00 00:00:00',29653,'Pendiente',2017,1,NULL,NULL,-8,1272,NULL,NULL,NULL),(1898,'0000-00-00 00:00:00',25415,'Pendiente',2017,1,NULL,NULL,-8,1273,NULL,NULL,NULL),(1899,'0000-00-00 00:00:00',19242,'Pendiente',2017,1,NULL,NULL,-8,1274,NULL,NULL,NULL),(1900,'0000-00-00 00:00:00',25860,'Pendiente',2017,1,NULL,NULL,-8,1275,NULL,NULL,NULL),(1901,'0000-00-00 00:00:00',29930,'Pendiente',2017,1,NULL,NULL,-8,1276,NULL,NULL,NULL),(1902,'0000-00-00 00:00:00',25461,'Pendiente',2017,1,NULL,NULL,-8,1277,NULL,NULL,NULL),(1903,'2017-02-10 23:42:26',13629,'Pagado',2016,12,NULL,NULL,-8,1218,NULL,NULL,NULL),(1904,'0000-00-00 00:00:00',18524,'Pendiente',2016,12,NULL,NULL,-8,1219,NULL,NULL,NULL),(1905,'0000-00-00 00:00:00',18513,'Pendiente',2016,12,NULL,NULL,-8,1220,NULL,NULL,NULL),(1906,'0000-00-00 00:00:00',18029,'Pendiente',2016,12,NULL,NULL,-8,1221,NULL,NULL,NULL),(1907,'0000-00-00 00:00:00',13761,'Pendiente',2016,12,NULL,NULL,-8,1222,NULL,NULL,NULL),(1908,'0000-00-00 00:00:00',23309,'Pendiente',2016,12,NULL,NULL,-8,1223,NULL,NULL,NULL),(1909,'0000-00-00 00:00:00',19690,'Pendiente',2016,12,NULL,NULL,-8,1224,NULL,NULL,NULL),(1910,'0000-00-00 00:00:00',18161,'Pendiente',2016,12,NULL,NULL,-8,1225,NULL,NULL,NULL),(1911,'0000-00-00 00:00:00',13684,'Pendiente',2016,12,NULL,NULL,-8,1226,NULL,NULL,NULL),(1912,'0000-00-00 00:00:00',21703,'Pendiente',2016,12,NULL,NULL,-8,1227,NULL,NULL,NULL),(1913,'0000-00-00 00:00:00',21208,'Pendiente',2016,12,NULL,NULL,-8,1228,NULL,NULL,NULL),(1914,'0000-00-00 00:00:00',16511,'Pendiente',2016,12,NULL,NULL,-8,1229,NULL,NULL,NULL),(1915,'0000-00-00 00:00:00',13673,'Pendiente',2016,12,NULL,NULL,-8,1230,NULL,NULL,NULL),(1916,'0000-00-00 00:00:00',20097,'Pendiente',2016,12,NULL,NULL,-8,1231,NULL,NULL,NULL),(1917,'2017-02-10 23:42:46',21186,'Pagado',2016,12,NULL,NULL,-8,1232,NULL,NULL,NULL),(1918,'0000-00-00 00:00:00',19976,'Pendiente',2016,12,NULL,NULL,-8,1233,NULL,NULL,NULL),(1919,'0000-00-00 00:00:00',12100,'Pendiente',2016,12,NULL,NULL,-8,1234,NULL,NULL,NULL),(1920,'0000-00-00 00:00:00',20603,'Pendiente',2016,12,NULL,NULL,-8,1235,NULL,NULL,NULL),(1921,'0000-00-00 00:00:00',21406,'Pendiente',2016,12,NULL,NULL,-8,1236,NULL,NULL,NULL),(1922,'0000-00-00 00:00:00',19646,'Pendiente',2016,12,NULL,NULL,-8,1237,NULL,NULL,NULL),(1923,'0000-00-00 00:00:00',13805,'Pendiente',2016,12,NULL,NULL,-8,1238,NULL,NULL,NULL),(1924,'0000-00-00 00:00:00',20801,'Pendiente',2016,12,NULL,NULL,-8,1239,NULL,NULL,NULL),(1925,'0000-00-00 00:00:00',21230,'Pendiente',2016,12,NULL,NULL,-8,1240,NULL,NULL,NULL),(1926,'0000-00-00 00:00:00',18095,'Pendiente',2016,12,NULL,NULL,-8,1241,NULL,NULL,NULL),(1927,'0000-00-00 00:00:00',13706,'Pendiente',2016,12,NULL,NULL,-8,1242,NULL,NULL,NULL),(1928,'0000-00-00 00:00:00',20119,'Pendiente',2016,12,NULL,NULL,-8,1243,NULL,NULL,NULL),(1929,'0000-00-00 00:00:00',21263,'Pendiente',2016,12,NULL,NULL,-8,1244,NULL,NULL,NULL),(1930,'0000-00-00 00:00:00',17974,'Pendiente',2016,12,NULL,NULL,-8,1245,NULL,NULL,NULL),(1931,'0000-00-00 00:00:00',13805,'Pendiente',2016,12,NULL,NULL,-8,1246,NULL,NULL,NULL),(1932,'0000-00-00 00:00:00',21230,'Pendiente',2016,12,NULL,NULL,-8,1247,NULL,NULL,NULL),(1933,'0000-00-00 00:00:00',21142,'Pendiente',2016,12,NULL,NULL,-8,1248,NULL,NULL,NULL),(1934,'0000-00-00 00:00:00',18150,'Pendiente',2016,12,NULL,NULL,-8,1249,NULL,NULL,NULL),(1935,'0000-00-00 00:00:00',13684,'Pendiente',2016,12,NULL,NULL,-8,1250,NULL,NULL,NULL),(1936,'0000-00-00 00:00:00',20108,'Pendiente',2016,12,NULL,NULL,-8,1251,NULL,NULL,NULL),(1937,'0000-00-00 00:00:00',21428,'Pendiente',2016,12,NULL,NULL,-8,1252,NULL,NULL,NULL),(1938,'0000-00-00 00:00:00',18117,'Pendiente',2016,12,NULL,NULL,-8,1253,NULL,NULL,NULL),(1939,'0000-00-00 00:00:00',13838,'Pendiente',2016,12,NULL,NULL,-8,1254,NULL,NULL,NULL),(1940,'0000-00-00 00:00:00',20086,'Pendiente',2016,12,NULL,NULL,-8,1255,NULL,NULL,NULL),(1941,'0000-00-00 00:00:00',21329,'Pendiente',2016,12,NULL,NULL,-8,1256,NULL,NULL,NULL),(1942,'0000-00-00 00:00:00',18084,'Pendiente',2016,12,NULL,NULL,-8,1257,NULL,NULL,NULL),(1943,'0000-00-00 00:00:00',15664,'Pendiente',2016,12,NULL,NULL,-8,1258,NULL,NULL,NULL),(1944,'0000-00-00 00:00:00',20042,'Pendiente',2016,12,NULL,NULL,-8,1259,NULL,NULL,NULL),(1945,'0000-00-00 00:00:00',21384,'Pendiente',2016,12,NULL,NULL,-8,1260,NULL,NULL,NULL),(1946,'0000-00-00 00:00:00',18359,'Pendiente',2016,12,NULL,NULL,-8,1261,NULL,NULL,NULL),(1947,'0000-00-00 00:00:00',12188,'Pendiente',2016,12,NULL,NULL,-8,1262,NULL,NULL,NULL),(1948,'0000-00-00 00:00:00',21681,'Pendiente',2016,12,NULL,NULL,-8,1263,NULL,NULL,NULL),(1949,'0000-00-00 00:00:00',22869,'Pendiente',2016,12,NULL,NULL,-8,1264,NULL,NULL,NULL),(1950,'0000-00-00 00:00:00',16687,'Pendiente',2016,12,NULL,NULL,-8,1265,NULL,NULL,NULL),(1951,'0000-00-00 00:00:00',13728,'Pendiente',2016,12,NULL,NULL,-8,1266,NULL,NULL,NULL),(1952,'0000-00-00 00:00:00',20119,'Pendiente',2016,12,NULL,NULL,-8,1267,NULL,NULL,NULL),(1953,'0000-00-00 00:00:00',21989,'Pendiente',2016,12,NULL,NULL,-8,1268,NULL,NULL,NULL),(1954,'0000-00-00 00:00:00',18249,'Pendiente',2016,12,NULL,NULL,-8,1269,NULL,NULL,NULL),(1955,'0000-00-00 00:00:00',15334,'Pendiente',2016,12,NULL,NULL,-8,1270,NULL,NULL,NULL),(1956,'0000-00-00 00:00:00',16874,'Pendiente',2016,12,NULL,NULL,-8,1271,NULL,NULL,NULL),(1957,'0000-00-00 00:00:00',21241,'Pendiente',2016,12,NULL,NULL,-8,1272,NULL,NULL,NULL),(1958,'0000-00-00 00:00:00',18205,'Pendiente',2016,12,NULL,NULL,-8,1273,NULL,NULL,NULL),(1959,'0000-00-00 00:00:00',13783,'Pendiente',2016,12,NULL,NULL,-8,1274,NULL,NULL,NULL),(1960,'0000-00-00 00:00:00',18524,'Pendiente',2016,12,NULL,NULL,-8,1275,NULL,NULL,NULL),(1961,'0000-00-00 00:00:00',21439,'Pendiente',2016,12,NULL,NULL,-8,1276,NULL,NULL,NULL),(1962,'0000-00-00 00:00:00',18238,'Pendiente',2016,12,NULL,NULL,-8,1277,NULL,NULL,NULL),(1963,'2017-02-10 23:51:16',12390,'Pagado',2016,11,NULL,NULL,-8,1218,NULL,NULL,NULL),(1964,'0000-00-00 00:00:00',16840,'Pendiente',2016,11,NULL,NULL,-8,1219,NULL,NULL,NULL),(1965,'2017-02-11 00:08:20',16830,'Pagado',2016,11,NULL,NULL,-8,1220,NULL,NULL,NULL),(1966,'0000-00-00 00:00:00',16390,'Pendiente',2016,11,NULL,NULL,-8,1221,NULL,NULL,NULL),(1967,'2017-02-10 23:51:10',12510,'Pagado',2016,11,NULL,NULL,-8,1222,NULL,NULL,NULL),(1968,'0000-00-00 00:00:00',21190,'Pendiente',2016,11,NULL,NULL,-8,1223,NULL,NULL,NULL),(1969,'0000-00-00 00:00:00',17900,'Pendiente',2016,11,NULL,NULL,-8,1224,NULL,NULL,NULL),(1970,'2017-02-10 23:50:56',77010,'Pagado',2016,11,NULL,NULL,-8,1225,NULL,NULL,NULL),(1971,'0000-00-00 00:00:00',12440,'Pendiente',2016,11,NULL,NULL,-8,1226,NULL,NULL,NULL),(1972,'0000-00-00 00:00:00',19730,'Pendiente',2016,11,NULL,NULL,-8,1227,NULL,NULL,NULL),(1973,'0000-00-00 00:00:00',19280,'Pendiente',2016,11,NULL,NULL,-8,1228,NULL,NULL,NULL),(1974,'0000-00-00 00:00:00',15010,'Pendiente',2016,11,NULL,NULL,-8,1229,NULL,NULL,NULL),(1975,'0000-00-00 00:00:00',12430,'Pendiente',2016,11,NULL,NULL,-8,1230,NULL,NULL,NULL),(1976,'0000-00-00 00:00:00',18270,'Pendiente',2016,11,NULL,NULL,-8,1231,NULL,NULL,NULL),(1977,'0000-00-00 00:00:00',19260,'Pendiente',2016,11,NULL,NULL,-8,1232,NULL,NULL,NULL),(1978,'0000-00-00 00:00:00',18160,'Pendiente',2016,11,NULL,NULL,-8,1233,NULL,NULL,NULL),(1979,'0000-00-00 00:00:00',11000,'Pendiente',2016,11,NULL,NULL,-8,1234,NULL,NULL,NULL),(1980,'0000-00-00 00:00:00',18730,'Pendiente',2016,11,NULL,NULL,-8,1235,NULL,NULL,NULL),(1981,'0000-00-00 00:00:00',19460,'Pendiente',2016,11,NULL,NULL,-8,1236,NULL,NULL,NULL),(1982,'0000-00-00 00:00:00',17860,'Pendiente',2016,11,NULL,NULL,-8,1237,NULL,NULL,NULL),(1983,'0000-00-00 00:00:00',12550,'Pendiente',2016,11,NULL,NULL,-8,1238,NULL,NULL,NULL),(1984,'0000-00-00 00:00:00',18910,'Pendiente',2016,11,NULL,NULL,-8,1239,NULL,NULL,NULL),(1985,'0000-00-00 00:00:00',19300,'Pendiente',2016,11,NULL,NULL,-8,1240,NULL,NULL,NULL),(1986,'0000-00-00 00:00:00',16450,'Pendiente',2016,11,NULL,NULL,-8,1241,NULL,NULL,NULL),(1987,'0000-00-00 00:00:00',12460,'Pendiente',2016,11,NULL,NULL,-8,1242,NULL,NULL,NULL),(1988,'0000-00-00 00:00:00',18290,'Pendiente',2016,11,NULL,NULL,-8,1243,NULL,NULL,NULL),(1989,'0000-00-00 00:00:00',19330,'Pendiente',2016,11,NULL,NULL,-8,1244,NULL,NULL,NULL),(1990,'0000-00-00 00:00:00',16340,'Pendiente',2016,11,NULL,NULL,-8,1245,NULL,NULL,NULL),(1991,'0000-00-00 00:00:00',12550,'Pendiente',2016,11,NULL,NULL,-8,1246,NULL,NULL,NULL),(1992,'0000-00-00 00:00:00',19300,'Pendiente',2016,11,NULL,NULL,-8,1247,NULL,NULL,NULL),(1993,'0000-00-00 00:00:00',19220,'Pendiente',2016,11,NULL,NULL,-8,1248,NULL,NULL,NULL),(1994,'0000-00-00 00:00:00',16500,'Pendiente',2016,11,NULL,NULL,-8,1249,NULL,NULL,NULL),(1995,'0000-00-00 00:00:00',12440,'Pendiente',2016,11,NULL,NULL,-8,1250,NULL,NULL,NULL),(1996,'0000-00-00 00:00:00',18280,'Pendiente',2016,11,NULL,NULL,-8,1251,NULL,NULL,NULL),(1997,'0000-00-00 00:00:00',19480,'Pendiente',2016,11,NULL,NULL,-8,1252,NULL,NULL,NULL),(1998,'0000-00-00 00:00:00',16470,'Pendiente',2016,11,NULL,NULL,-8,1253,NULL,NULL,NULL),(1999,'0000-00-00 00:00:00',12580,'Pendiente',2016,11,NULL,NULL,-8,1254,NULL,NULL,NULL),(2000,'0000-00-00 00:00:00',18260,'Pendiente',2016,11,NULL,NULL,-8,1255,NULL,NULL,NULL),(2001,'0000-00-00 00:00:00',19390,'Pendiente',2016,11,NULL,NULL,-8,1256,NULL,NULL,NULL),(2002,'0000-00-00 00:00:00',16440,'Pendiente',2016,11,NULL,NULL,-8,1257,NULL,NULL,NULL),(2003,'0000-00-00 00:00:00',14240,'Pendiente',2016,11,NULL,NULL,-8,1258,NULL,NULL,NULL),(2004,'0000-00-00 00:00:00',18220,'Pendiente',2016,11,NULL,NULL,-8,1259,NULL,NULL,NULL),(2005,'0000-00-00 00:00:00',19440,'Pendiente',2016,11,NULL,NULL,-8,1260,NULL,NULL,NULL),(2006,'0000-00-00 00:00:00',16690,'Pendiente',2016,11,NULL,NULL,-8,1261,NULL,NULL,NULL),(2007,'0000-00-00 00:00:00',11080,'Pendiente',2016,11,NULL,NULL,-8,1262,NULL,NULL,NULL),(2008,'0000-00-00 00:00:00',19710,'Pendiente',2016,11,NULL,NULL,-8,1263,NULL,NULL,NULL),(2009,'0000-00-00 00:00:00',20790,'Pendiente',2016,11,NULL,NULL,-8,1264,NULL,NULL,NULL),(2010,'0000-00-00 00:00:00',15170,'Pendiente',2016,11,NULL,NULL,-8,1265,NULL,NULL,NULL),(2011,'0000-00-00 00:00:00',12480,'Pendiente',2016,11,NULL,NULL,-8,1266,NULL,NULL,NULL),(2012,'0000-00-00 00:00:00',18290,'Pendiente',2016,11,NULL,NULL,-8,1267,NULL,NULL,NULL),(2013,'0000-00-00 00:00:00',19990,'Pendiente',2016,11,NULL,NULL,-8,1268,NULL,NULL,NULL),(2014,'0000-00-00 00:00:00',16590,'Pendiente',2016,11,NULL,NULL,-8,1269,NULL,NULL,NULL),(2015,'0000-00-00 00:00:00',13940,'Pendiente',2016,11,NULL,NULL,-8,1270,NULL,NULL,NULL),(2016,'0000-00-00 00:00:00',15340,'Pendiente',2016,11,NULL,NULL,-8,1271,NULL,NULL,NULL),(2017,'0000-00-00 00:00:00',19310,'Pendiente',2016,11,NULL,NULL,-8,1272,NULL,NULL,NULL),(2018,'0000-00-00 00:00:00',16550,'Pendiente',2016,11,NULL,NULL,-8,1273,NULL,NULL,NULL),(2019,'0000-00-00 00:00:00',12530,'Pendiente',2016,11,NULL,NULL,-8,1274,NULL,NULL,NULL),(2020,'0000-00-00 00:00:00',16840,'Pendiente',2016,11,NULL,NULL,-8,1275,NULL,NULL,NULL),(2021,'0000-00-00 00:00:00',19490,'Pendiente',2016,11,NULL,NULL,-8,1276,NULL,NULL,NULL),(2022,'0000-00-00 00:00:00',16580,'Pendiente',2016,11,NULL,NULL,-8,1277,NULL,NULL,NULL);

--
-- Table structure for table `indicadores`
--

CREATE TABLE `indicadores` (
  `idindicadores` int(11) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(45) DEFAULT NULL,
  `nombre` varchar(45) DEFAULT NULL,
  `valor` decimal(4,2) DEFAULT NULL,
  PRIMARY KEY (`idindicadores`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `indicadores`
--

INSERT INTO `indicadores` VALUES (1,'afp','provida',11.54),(2,'afp','capital',11.44);

--
-- Table structure for table `medidores`
--

CREATE TABLE `medidores` (
  `idmedidores` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(45) DEFAULT NULL,
  `um` varchar(45) DEFAULT NULL,
  `descripcion` varchar(200) DEFAULT NULL,
  `propiedades_rut` int(11) NOT NULL,
  PRIMARY KEY (`idmedidores`,`propiedades_rut`),
  KEY `fk_medidores_propiedades1_idx` (`propiedades_rut`),
  CONSTRAINT `fk_medidores_propiedades1` FOREIGN KEY (`propiedades_rut`) REFERENCES `propiedades` (`rut`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `medidores`
--

INSERT INTO `medidores` VALUES (1,'Agua','m3','Agua de medidor',-8),(2,'Luz','Kw','Medidor 123123',-8);

--
-- Table structure for table `modulos`
--

CREATE TABLE `modulos` (
  `idmodulos` varchar(100) NOT NULL,
  `nombre` varchar(200) DEFAULT NULL,
  `href` varchar(100) DEFAULT NULL,
  `faicon` varchar(100) DEFAULT NULL,
  `url` varchar(100) DEFAULT NULL,
  `orden` int(11) DEFAULT NULL,
  PRIMARY KEY (`idmodulos`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modulos`
--

INSERT INTO `modulos` VALUES ('CARGOS','Cargos','#cargos',NULL,'cargos',5),('COPROPIETARIOS','Departamentos','#copropietarios',NULL,'copropietarios',1),('GASTOS','Gastos Comunes','#gastos',NULL,'gastos',4),('GASTOSCOMUNES','Pagos','#gastoscomunes',NULL,'gastoscomunes',6),('REMUNERACIONES','Remuneraciones','#remuneraciones',NULL,'remuneraciones',3),('TRABAJADORES','Trabajadores','#trabajadores',NULL,'trabajadores',2);

--
-- Table structure for table `propiedades`
--

CREATE TABLE `propiedades` (
  `rut` int(11) NOT NULL,
  `nombre` varchar(200) DEFAULT NULL,
  `direccion` varchar(200) DEFAULT NULL,
  `region` varchar(45) DEFAULT NULL,
  `comuna` varchar(45) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `esGastoFijo` tinyint(1) DEFAULT NULL,
  `tieneMedidores` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`rut`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propiedades`
--

INSERT INTO `propiedades` VALUES (-8,'Comunidad del anillo','La Comarca 123','Mordor','13',NULL,0,1),(-6,'comunidad Puerto lindo','av los leones 123','Independencia','13',NULL,1,0),(1,'Alto Lo Castillo III','Av. San Juan #323','6','Machalí','altolocastillo@gmail.com',NULL,0),(53304492,'Comunidad Edificio Atlanta','Apoquindo 6445','Apoquindo 6445','13','Las Condes',0,0),(53311123,'Edificio Estrella del Norte','Estrella del Norte 957','13','Vitacura','estrellanorte957@gmail.com',0,0),(56027010,'comunidad Edificio Los Militares 6782','Malmo 505','13','Las Condes','avallegabrielli@vtr.net',1,0),(56027234,'Comunidad Edificio Los Sargentos','Malmo 502','13','Las Condes','Sandia@propiedades.cl',NULL,0);

--
-- Table structure for table `remuneraciones`
--

CREATE TABLE `remuneraciones` (
  `idremuneraciones` int(11) NOT NULL AUTO_INCREMENT,
  `mes` int(11) DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `dias_trabajados` int(11) DEFAULT NULL,
  `sueldo_base` int(11) DEFAULT NULL,
  `valor_dias_trabajados` int(11) DEFAULT NULL,
  `gratificacion` int(11) DEFAULT NULL,
  `comisiones` int(11) DEFAULT NULL,
  `asignacion_familiar` int(11) DEFAULT NULL,
  `bonos` int(11) DEFAULT NULL,
  `horas_extras` int(11) DEFAULT NULL,
  `colacion` int(11) DEFAULT NULL,
  `movilizacion` int(11) DEFAULT NULL,
  `total_haberes` int(11) DEFAULT NULL,
  `total_descuentos` int(11) DEFAULT NULL,
  `base_imponible` int(11) DEFAULT NULL,
  `afp` varchar(45) DEFAULT NULL,
  `valor_afp` decimal(4,2) DEFAULT NULL,
  `total_afp` int(11) DEFAULT NULL,
  `isapre` varchar(45) DEFAULT NULL,
  `valor_isapre` decimal(4,2) DEFAULT NULL,
  `total_isapre` int(11) DEFAULT NULL,
  `prev_seguro_cesantia_emp` decimal(4,2) DEFAULT NULL,
  `prev_seguro_cesantia_trab` decimal(4,2) DEFAULT NULL,
  `total_seguro_cesantia_emp` int(11) DEFAULT NULL,
  `total_seguro_cesantia_trab` int(11) DEFAULT NULL,
  `descuentos` int(11) DEFAULT NULL,
  `sueldo_liquido` int(11) DEFAULT NULL,
  `fecha_borrador` datetime DEFAULT NULL,
  `fecha_pdf` datetime DEFAULT NULL,
  `pdf` blob,
  `estado` int(11) DEFAULT NULL,
  `trabajadores_rut` int(11) NOT NULL,
  `trabajadores_propiedades_rut` int(11) NOT NULL,
  PRIMARY KEY (`idremuneraciones`,`trabajadores_rut`,`trabajadores_propiedades_rut`),
  KEY `fk_remuneraciones_trabajadores1_idx` (`trabajadores_rut`,`trabajadores_propiedades_rut`),
  CONSTRAINT `fk_remuneraciones_trabajadores1` FOREIGN KEY (`trabajadores_rut`, `trabajadores_propiedades_rut`) REFERENCES `trabajadores` (`rut`, `propiedades_rut`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `remuneraciones`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `idroles` varchar(100) NOT NULL,
  `nombre` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`idroles`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES ('ADMINISTRADOR','administrador'),('ROOT','root');

--
-- Table structure for table `roles_modulos_acciones`
--

CREATE TABLE `roles_modulos_acciones` (
  `roles_idroles` varchar(100) NOT NULL,
  `modulos_idmodulos` varchar(100) NOT NULL,
  `ver` int(11) DEFAULT NULL,
  `agregar` int(11) DEFAULT NULL,
  `modificar` int(11) DEFAULT NULL,
  `eliminar` int(11) DEFAULT NULL,
  `notificar` int(11) DEFAULT NULL,
  PRIMARY KEY (`roles_idroles`,`modulos_idmodulos`),
  KEY `fk_roles_modulos_acciones_roles1_idx` (`roles_idroles`),
  KEY `fk_roles_modulos_acciones_modulos1` (`modulos_idmodulos`),
  CONSTRAINT `fk_roles_modulos_acciones_modulos1` FOREIGN KEY (`modulos_idmodulos`) REFERENCES `modulos` (`idmodulos`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_roles_modulos_acciones_roles1` FOREIGN KEY (`roles_idroles`) REFERENCES `roles` (`idroles`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles_modulos_acciones`
--

INSERT INTO `roles_modulos_acciones` VALUES ('ADMINISTRADOR','CARGOS',1,NULL,NULL,NULL,NULL),('ADMINISTRADOR','COPROPIETARIOS',1,NULL,NULL,NULL,NULL),('ADMINISTRADOR','GASTOS',1,NULL,NULL,NULL,NULL),('ADMINISTRADOR','GASTOSCOMUNES',1,NULL,NULL,NULL,NULL),('ROOT','CARGOS',1,NULL,NULL,NULL,NULL),('ROOT','COPROPIETARIOS',1,NULL,NULL,NULL,NULL),('ROOT','GASTOS',1,NULL,NULL,NULL,NULL),('ROOT','GASTOSCOMUNES',1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `trabajadores`
--

CREATE TABLE `trabajadores` (
  `rut` int(11) NOT NULL,
  `nombre` varchar(255) DEFAULT NULL,
  `fecha_ingreso` datetime DEFAULT NULL,
  `cargo` varchar(255) DEFAULT NULL,
  `banco` varchar(100) DEFAULT NULL,
  `numero_cuenta` varchar(100) DEFAULT NULL,
  `sueldo_base` int(11) DEFAULT NULL,
  `gratificacion` int(11) DEFAULT NULL,
  `afp` varchar(100) DEFAULT NULL,
  `isapre` varchar(100) DEFAULT NULL,
  `valor_plan_isapre` int(11) DEFAULT NULL,
  `version` int(11) NOT NULL,
  `propiedades_rut` int(11) NOT NULL,
  `inicio_contrato` datetime DEFAULT NULL,
  `termino_contrato` datetime DEFAULT NULL,
  PRIMARY KEY (`rut`,`propiedades_rut`,`version`),
  KEY `fk_trabajadores_propiedades1_idx` (`propiedades_rut`),
  CONSTRAINT `fk_trabajadores_propiedades1` FOREIGN KEY (`propiedades_rut`) REFERENCES `propiedades` (`rut`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `trabajadores`
--

INSERT INTO `trabajadores` VALUES (2,'Dusty Panes','0000-00-00 00:00:00','Guardia','Santander','4444444',500000,24000,'Cuprum','Fonasa',10000,1,-8,NULL,NULL),(2,'Dusty Panes','2016-11-01 00:00:00','Conserje','Santander','4343553332',500000,200000,'Provida','Vida tres',5,1,-6,NULL,NULL),(15533936,'Felipe Venegas','0000-00-00 00:00:00','Ingeniero','Chile','5555555',200000,20000,'Provida','Banmedica',24000,1,-8,NULL,NULL),(15533936,'Felipe Venegas','0000-00-00 00:00:00','Conserje','Chile','12312312312',500000,100000,'Provida','Banmedica',2,1,-6,NULL,NULL);

--
-- Table structure for table `usuarios_propiedades`
--

CREATE TABLE `usuarios_propiedades` (
  `usuarios_idusuarios` int(11) NOT NULL,
  `propiedades_rut` int(11) NOT NULL,
  PRIMARY KEY (`usuarios_idusuarios`,`propiedades_rut`),
  KEY `fk_usuarios_propiedades_propiedades1_idx` (`propiedades_rut`),
  CONSTRAINT `fk_usuarios_propiedades_propiedades1` FOREIGN KEY (`propiedades_rut`) REFERENCES `propiedades` (`rut`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_usuarios_propiedades_usuarios1` FOREIGN KEY (`usuarios_idusuarios`) REFERENCES `usuarios` (`idusuarios`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usuarios_propiedades`
--

INSERT INTO `usuarios_propiedades` VALUES (1,-8),(2,-8),(1,-6),(2,-6),(1,1),(1,53311123),(2,53311123),(3,53311123),(1,56027010),(2,56027010),(3,56027010),(4,56027010),(1,56027234),(2,56027234);


