
--
-- Table structure for table `t_medidores`
--

CREATE TABLE `t_medidores` (
  `t_medidor` int(1) NOT NULL,
  `nombre_medidor` varchar(15) COLLATE utf8_spanish2_ci NOT NULL,
  PRIMARY KEY (`t_medidor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `t_medidores`
--

INSERT INTO `t_medidores` VALUES (1,'MSQ-900'),(2,'JDSU-1300'),(3,'DSAM6300'),(4,'SDA5000'),(5,'No tiene');

--
-- Table structure for table `t_red`
--

CREATE TABLE `t_red` (
  `Id_red` int(1) NOT NULL,
  `Nombre_red` varchar(10) COLLATE utf8_spanish2_ci NOT NULL,
  PRIMARY KEY (`Id_red`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `t_red`
--

INSERT INTO `t_red` VALUES (1,'Interna'),(2,'Externa'),(3,'Fibra');

--
-- Table structure for table `t_resultallamada`
--

CREATE TABLE `t_resultallamada` (
  `Id_resullamada` int(2) NOT NULL AUTO_INCREMENT,
  `Resullamada` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`Id_resullamada`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `t_resultallamada`
--

INSERT INTO `t_resultallamada` VALUES (1,'OK'),(2,'No contacto'),(3,'Mala atencion del tecnico'),(4,'Señal deficiente'),(5,'instalacion antiestetica'),(6,'Incumplimiento horario'),(7,'Daño en la vivienda'),(8,'Robo'),(9,'Inconformidad Comercial'),(10,'Mala atencion telefonica'),(11,'Lugar de trabajo desordenado'),(12,'Daños Otro Operador'),(13,'Instalacion Incompleta'),(14,'Imagen Corporativa'),(15,'Falla Continua'),(16,'Intermitencia internet'),(17,'Lentitud en Internet'),(18,'Fallas en la TV'),(19,'Fallas en telefonia'),(20,'No entregan todos los servicios');

--
-- Table structure for table `t_solucion`
--

CREATE TABLE `t_solucion` (
  `Id_Solucion` int(30) NOT NULL DEFAULT '0',
  `Solucion` varchar(30) DEFAULT NULL,
  `Id_subrazon` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`Id_Solucion`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `t_solucion`
--

INSERT INTO `t_solucion` VALUES (1,'OK','OK'),(2,'No contacto','OK');

--
-- Table structure for table `t_tipotrabajo`
--

CREATE TABLE `t_tipotrabajo` (
  `Id` int(2) NOT NULL,
  `nomtipotrabajo` varchar(50) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `t_tipotrabajo`
--

INSERT INTO `t_tipotrabajo` VALUES (1,'Arreglos'),(2,'Instalaciones');

--
-- Table structure for table `t_trabajo`
--

CREATE TABLE `t_trabajo` (
  `Id_trabajo` int(2) NOT NULL,
  `Nombre_trabajo` varchar(33) DEFAULT NULL,
  `Id_red` int(1) DEFAULT NULL,
  PRIMARY KEY (`Id_trabajo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `t_trabajo`
--

INSERT INTO `t_trabajo` VALUES (1,'Arreglos Bidi',1),(2,'Arreglos Uni',1),(3,'Instalaciones Bidi',1),(4,'Movil de Apoyo Bidi/Uni',1),(5,'Posventa Bidi',1),(6,'Proyectos (Cambio tec - Blindaje)',1),(7,'Rx - Dx',1),(8,'DTH',1),(9,'Correctivo Bidi',2),(10,'Correctivo Uni',2),(11,'Pmp',2),(12,'Pma',2),(13,'Ruido',2),(14,'Potencia',2),(15,'Supervisor Bidi/Uni',2),(16,'Supervisor PMP',2);

--
-- Table structure for table `t_usuario`
--

CREATE TABLE `t_usuario` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `Cedula` bigint(12) DEFAULT NULL,
  `Clave` varchar(8) DEFAULT NULL,
  `Id_acces` varchar(3) DEFAULT NULL,
  `Nombre_usu` varchar(32) DEFAULT NULL,
  `Correo` varchar(33) DEFAULT NULL,
  `Zona` varchar(36) DEFAULT NULL,
  `Funcion` varchar(15) DEFAULT NULL,
  `Poblacion` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `t_usuario`
--

INSERT INTO `t_usuario` VALUES (0,94317615,'Claro123','33','NASPIRAN ROSERO SEGUNDO JUVENAL','na','Zona Integral O&M Cali','Supervisor Oper','Cali'),(1,7562833,'Claro123','33','ALVAREZ ALZATE YURY WALDIR','yury.alvarez@claro.com.co','Zona Integral O&M Armenia','Interventor','Armenia'),(2,9728065,'Claro123','33','ALZATE TANGARIFE CESAR AUGUSTO','cesar.alzate@claro.com.co','Zona Integral O&M Armenia','Interventor','Armenia'),(3,18515967,'Claro123','33','ARANGO VALENCIA JORGE HERNAN','jorge.arango@claro.com.co','Zona Integral O&M Pereira','Interventor','Pereira'),(4,88281305,'Claro123','33','AREVALO MARQUEZ WINER','winer.arevalo@claro.com.co','Zona Pasto - Putumayo - Caqueta','Tecnico','Pitalito'),(6,72264427,'Claro123','33','BEDOYA ORTIZ FERNEY','ferney.bedoya@claro.com.co','Zona Integral O&M Manizales','Interventor','Manizales'),(7,17349239,'Claro123','31','BERMUDEZ USMA ERIDSON','eridson.bermudez@claro.com.co','Zona Integral O&M Ibague bidi','Lider','Ibague'),(8,7689622,'Claro123','33','BERNAL SOTO ARLED','arled.bernal@claro.com.co','Zona Integral O&M Neiva','Interventor','Neiva'),(9,10034674,'Claro123','33','BUITRAGO LOPEZ HAROLD MILLER','harold.buitrago@claro.com.co','Zona Integral O&M Pereira','Interventor','Pereira'),(10,7724044,'Claro123','33','CABRERA JOHNATAN EFRAIN','johnatan.cabrera@claro.com.co','Zona Integral O&M Neiva','Interventor','Neiva'),(11,83235544,'Claro123','33','CAMACHO CEDENO CARLOS EDUARDO','carlos.camacho@claro.com.co','Zona Integral O&M Neiva','Interventor','Neiva'),(12,6112493,'Claro123','33','CARDENAS RIVERA FABIAN DE JESUS','fabian.cardenas@claro.com.co','Zona Integral O&M Armenia','Interventor','Armenia'),(13,4287872,'Claro123','33','CASTRO CORONADO FERNANDO','fernando.castro@claro.com.co','Zona Integral O&M Poblaciones Tolima','Tecnico','Pto boyaca'),(14,18103959,'Claro123','33','CHAMORRO ROBINSON','robinson.chamorro@claro.com.co','Zona Pasto - Putumayo - Caqueta','Tecnico','Villa Garzon'),(15,16073663,'Claro123','31','CUESTA MOLINA ANDRES HERNANDO','andres.cuesta@claro.com.co','Zona Integral O&M Manizales','Lider','Manizales'),(16,74360573,'Claro123','33','DELGADO CASTRO ANDRES MAURICIO','andres.delgado@claro.com.co','Zona Integral O&M Poblaciones Tolima','Tecnico','Fresno'),(17,17647383,'Claro123','31','DOMINGUEZ DIAZ OSCAR','oscar.dominguez@claro.com.co','Zona Pasto - Putumayo - Caqueta','Lider','Florencia'),(18,93290902,'Claro123','33','ENCISO PARRA OSCAR DELLY','oscar.encizo@claro.com.co','Zona Integral O&M Ibague bidi','Interventor','Ibague'),(19,79488218,'Claro123','33','ESCOBAR BASTIDAS JULIO CESAR','julio.escobar@claro.com.co','Zona Pasto - Putumayo - Caqueta','Tecnico','Mocoa'),(20,12199083,'Claro123','33','FERNANDEZ CALIXTO ANDRES','calixto.fernandez@claro.com.co','Zona Integral O&M Poblaciones Huila','Tecnico','Garzon'),(21,80020727,'Claro123','33','FERNANDEZ FERNANDEZ MAURICIO','mauricio.fernandez.f@claro.com.co','Zona Integral O&M Poblaciones Tolima','Interventor','Honda'),(22,93410745,'Claro123','33','FIERRO LOPEZ FERNANDO ENRIQUE','fernando.fierro@claro.com.co','Zona Integral O&M Ibague bidi','Interventor','Ibague'),(23,93394177,'Claro123','33','FRANCO AMAYA CARLOS AUGUSTO','carlos.franco@claro.com.co','Zona Integral O&M Ibague bidi','Interventor','Ibague'),(24,18618633,'Claro123','31','GARCIA ALVAREZ JULIAN ANDRES','julian.garcia@claro.com.co','Zona Integral O&M Pereira','Lider','Manizales'),(25,10016346,'Claro123','33','GARCIA CAICEDO CARLOS FERNANDO','carlos.garcia.c@claro.com.co','Zona Integral O&M Pereira','Interventor','Pereira'),(26,80271327,'Claro123','33','GARZON ALARCON JULIO CESAR','julio.garzon@claro.com.co','Zona Integral O&M Neiva','Interventor','Neiva'),(27,7702148,'Claro123','33','GASPAR TRUJILLO DAVID','david.gaspar@claro.com.co','Zona Integral O&M Neiva','Interventor','Neiva'),(28,75081687,'Claro123','33','GIL HENAO JOSE YAMID','jose.gil@claro.com.co','Zona Integral O&M Manizales','Interventor','Manizales'),(29,6445417,'Claro123','33','GOMEZ MENA JUAN CARLOS','juan.gomez.m@claro.com.co','Zona Integral O&M Norte del Valle','Interventor','Armenia'),(30,93336267,'Claro123','33','GONZALEZ DIAZ RAUL','raul.gonzalez.d@claro.com.co','Zona Integral O&M Poblaciones Tolima','Tecnico','Mariquita'),(31,9736926,'Claro123','33','GRAJALES RONAL','ronal.grajales@claro.com.co','Zona Integral O&M Armenia','Interventor','Armenia'),(32,7716517,'Claro123','31','GUACHETA RAMIREZ OSCAR MAURICIO','oscar.guacheta@claro.com.co','Zona Integral O&M Neiva','Lider','Neiva'),(33,93471948,'Claro123','31','GUTIERREZ CERVERA ADDRITH','addrdith.gutierrez@claro.com.co','Zona Integral O&M Ibague uni','Lider','Ibague'),(34,14271412,'Claro123','33','GUZMAN MORENO ELBER','elber.guzman@claro.com.co','Zona Integral O&M Poblaciones Tolima','Tecnico','Libano'),(35,14319784,'Claro123','33','HERRERA CRUZ CARLOS ALBERTO','carlos.herrera@claro.com.co','Zona Integral O&M Poblaciones Tolima','Tecnico','Honda'),(36,11441279,'Claro123','33','HERRERA RODRIGUEZ JAVIER ALFREDO','javier.herrera@claro.com.co','Zona Integral O&M Neiva','Interventor','Neiva'),(37,18125988,'Claro123','33','LASSO GARCIA LIBARDO','Se solicitara creacion','Zona Pasto - Putumayo - Caqueta','Tecnico','Mocoa'),(38,9737920,'Claro123','33','LOPEZ GIRALDO JOHAN MAURICIO','johan.lopez@claro.com.co','Zona Integral O&M Armenia','Interventor','Cali Norte'),(39,16226787,'Claro123','33','LOPEZ GOMEZ PEDRO JOSE','pedro.lopez.g@claro.com.co','Zona Integral O&M Pereira','Interventor','Pereira'),(40,18124999,'Claro123','33','LOPEZ ORTEGA WILSON','wilson.lopez@claro.com.co','Zona Pasto - Putumayo - Caqueta','Tecnico','Mocoa'),(41,93383526,'Claro123','33','MALO ROJAS MARIO ENRIQUE','mario.malo@claro.com.co','Zona Integral O&M Ibague uni','Interventor','Ibague'),(42,93061849,'Claro123','31','MARIN OCAMPO OLMEDO','olmedo.marin@claro.com.co','Zona Integral O&M Armenia','Lider','Armenia'),(43,16551297,'Claro123','33','MARTINEZ MONTOYA LUBIAN ENRIQUE','lubian.martinez@claro.com.co','Zona Integral O&M Pereira','Interventor','Pereira'),(44,93420437,'Claro123','33','MIRANDA WILSON ALBERTO','alberto.miranda.w@claro.com.co','Zona Integral O&M Manizales','Interventor','Manizales'),(45,12196893,'Claro123','33','MOLINA LOMBANA JARONL WILBER','jaronl.molina@claro.com.co','Zona Integral O&M Poblaciones Huila','Tecnico','Garzon'),(46,17684065,'Claro123','33','MORENO DANILO ANDRES','danilo.moreno@claro.com.co','Zona Pasto - Putumayo - Caqueta','Interventor','Florencia'),(47,94232134,'Claro123','33','MOYANO RODRIGUEZ HECTOR FABIAN','hector.moyano@claro.com.co','Zona Integral O&M Pereira','Interventor','Pereira'),(48,5348764,'Claro123','33','MUNOZ MASMUTA JOSE NECTARIO','jose.munoz.m@claro.com.co','Zona Pasto - Putumayo - Caqueta','Tecnico','Mocoa'),(49,83088606,'Claro123','33','MURCIA BARREIRA JOSE ELVER','jose.murcia@claro.com.co','Zona Integral O&M Poblaciones Huila','Tecnico','Neiva'),(50,93337588,'Claro123','33','OROZCO RAMIREZ EDGAR ORMINSO','edgar.orozco@claro.com.co','Zona Integral O&M Poblaciones Tolima','Tecnico','Mariquita'),(51,4414565,'Claro123','33','OSPINA GUZMAN GUSTAVO ADOLFO','gustavo.ospina@claro.com.co','Zona Integral O&M Manizales','Interventor','Manizales'),(52,74392221,'Claro123','33','PARRA GONZALEZ MISAEL','misael.parra@claro.com.co','Zona Integral O&M Ibague bidi','Interventor','Ibague'),(53,7684017,'Claro123','33','PERDOMO ROJAS RAFAEL','rafael.perdomo@claro.com.co','Zona Integral O&M Neiva','Interventor','Neiva'),(54,14322941,'Claro123','33','PEREZ MORENO ARTURO','arturo.perez@claro.com.co','Zona Integral O&M Poblaciones Tolima','Tecnico','Pto boyaca'),(55,94406564,'Claro123','33','PUERTA SALAZAR JUAN CARLOS','juan.puerta@claro.com.co','Zona Integral O&M Norte del Valle','Interventor','Armenia'),(56,5827570,'Claro123','33','RAMIREZ DONOSO JOHN ALEXANDER','john.ramirez@claro.com.co','Zona Integral O&M Ibague uni','Interventor','Ibague'),(57,9865932,'Claro123','33','RAMIREZ MUNOZ DIEGO ALEXANDER','diego.ramirez.m@claro.com.co','Zona Integral O&M Pereira','Interventor','Pereira'),(58,83230798,'Claro123','33','RAMIREZ OVIEDO EDGAR','Edgar.ramirez@claro.com.co','Zona Pasto - Putumayo - Caqueta','Tecnico','Pitalito'),(59,18435796,'Claro123','33','RAMIREZ VASQUEZ MAURICIO AUGUSTO','mauricio.ramirez@claro.com.co','Zona Pasto - Putumayo - Caqueta','Interventor','Mocoa'),(60,38360166,'Claro123','33','RIOS CHACIN JOSEFINA','josefina.rios@claro.com.co','Coordinacion','Ingeniero','Ibague'),(61,13723678,'Claro123','33','ROJAS EDWARD ALBERTO','edward.rojas@claro.com.co','Zona Pasto - Putumayo - Caqueta','Interventor','Florencia'),(62,14325378,'Claro123','33','RUBIO DIEGO ANDRES','andres.rubio@claro.com.co','Zona Integral O&M Poblaciones Tolima','Tecnico','Honda'),(63,93203726,'Claro123','33','SIERRA RIVERA JOSE FERNANDO','jose.sierra@claro.com.co','Zona Integral O&M Ibague bidi','Interventor','Ibague'),(64,9773732,'Claro123','33','SILVA IDROBO FABIAN ANDRES','fabian.silva@claro.com.co','Zona Integral O&M Armenia','Interventor','Armenia'),(65,93406003,'Claro123','33','SUACHE MENDEZ CARLOS ANDRES','carlos.suache@claro.com.co','Zona Integral O&M Pereira','Interventor','Pereira'),(66,4414523,'Claro123','33','TABARES GRISALES FABIO NELSON','fabio.tabares@claro.com.co','Zona Integral O&M Manizales','Interventor','Manizales'),(67,5823034,'Claro123','33','TRUJILLO RAMIREZ WILSON','wilson.trujillo@claro.com.co','Zona Integral O&M Manizales','Interventor','Manizales'),(68,93407880,'Claro123','33','VARGAS OLARTE JOSE JULIAN','jose.vargas.o@claro.com.co','Zona Integral O&M Ibague bidi','Interventor','Ibague'),(69,98653286,'Claro123','33','WILCHES CONTRERAS JUAN ANTONIO','juan.wilches@claro.com.co','Zona Integral O&M Manizales','Interventor','Manizales'),(70,14321799,'Claro123','33','ZAMBRANO GARCIA LUIS HERNANDO','luis.zambrano.g@claro.com.co','Zona Integral O&M Poblaciones Tolima','Tecnico','Honda'),(71,1112904128,'Claro123','33','SIERRA PARRA  EDIER ALBERTO','esierra@decibelessa.com','Zona Integral O&M Pereira','Supervisor A','Pereira'),(72,4512235,'Claro123','33','ZAPATA LONDONO JULIAN ANDRES','jzapata@decibelessa.com','Zona Integral O&M Pereira','Supervisor A','Pereira'),(73,16078076,'Claro123','3','ORTIZ VALENCIA ANDRES FELIPE','andres.ortiz@claro.com.co','Zona Integral O&M Pereira','Analista','Pereira'),(74,1088259065,'Claro123','3','ESPINOSA CLAVIJO JUAN PABLO','juan.espisosa@claro.com.co','Zona Integral O&M Pereira','Analista','Pereira'),(75,75092477,'Claro123','31','GARCIA JIMENEZ JORGE WILLIAM','jorge.garcia.j@claro.com.co','Coordinacion','Coordinador','Manizales'),(76,772644271,'Claro123','33','FERNEY BEDOYA ORTIZ','fherney@gmail.com','Zona Integral O&M Manizales','Interventor','Manizales'),(77,10015071,'Claro123','31','GUSTAVO SUAREZ OSPINA','gustavo.suarez@claro.com.co','Ele cafetero','Jefe tecnico','Pereira'),(79,94324311,'Claro123','33','MOYANO RODRIGUEZ HECTOR FABIAN','na','Zona Integral O&M Cali','Interventor Cal','Tulua'),(80,91279409,'Claro123','33','MUNOZ MASMUTA JOSE NECTARIO','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(81,16792139,'Claro123','33','MURCIA BARREIRA JOSE ELVER','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(83,94302399,'Claro123','33','MONTOYA TORIJANO CARLOS','na','Zona Integral O&M Cali','Interventor Cal','Tulua'),(84,94404049,'Claro123','33','ACOSTA PORTILLO JOSUE','na','Zona Integral O&M Cali','Interventor Cal','Tulua'),(85,14466709,'Claro123','33','OSPINA GUZMAN GUSTAVO ADOLFO','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(86,10286556,'Claro123','33','PABON BURBANO FERNANDO ANDRES','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(87,94323742,'Claro123','33','PALOMINO VELASCO VICTOR ALFREDO','na','Zona Integral O&M Cali','Interventor Cal','Tulua'),(88,94316460,'Claro123','33','PARADA GAMBA MICHEL','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(89,19443751,'Claro123','33','PARRA CUELLAR WUILSON FERNANDO','na','Zona Integral O&M Cali','Interventor Cal','Tulua'),(90,94326101,'Claro123','33','PARRA GONZALEZ MISAEL','na','Zona Integral O&M Cali','Interventor Cal','Tulua'),(91,94315318,'Claro123','33','PERDOMO ROJAS RAFAEL','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(92,94284790,'Claro123','33','PEREZ MORENO ARTURO','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(93,15813459,'Claro123','33','PUERTA SALAZAR JUAN CARLOS','na','Zona Integral O&M Cali','Interventor Cal','Pasto'),(94,13070205,'Claro123','33','QUIJANO CIFUENTES DIEGO LEON','na','Zona Integral O&M Cali','Supervisor Oper','Pasto'),(95,5205089,'Claro123','33','RAMIREZ CARVAJAL CARLOS ANDREY','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(96,5348904,'Claro123','33','RAMIREZ DONOSO JOHN ALEXANDER','na','Zona Integral O&M Cali','Supervisor Oper','Pasto'),(97,6506018,'Claro123','33','MAZUERA LINO','na','Zona Integral O&M Cali','Supervisor Oper','Cali'),(98,94296060,'Claro123','33','FREYRE BEJARANO FABIAN','na','Zona Integral O&M Cali','Interventor Cal','Cali Sur'),(99,94418486,'Claro123','33','DIEGO FERNANDO MARIN','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(100,11636012,'Claro123','33','RIOS CASTRILLON CARLOS ALBERTO','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(101,94499398,'Claro123','33','RIOS CHACIN JOSEFINA','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(102,16778356,'Claro123','33','ROJAS EDWARD ALBERTO','na','Zona Integral O&M Cali','Interventor Red','Cali'),(103,16777502,'Claro123','33','RUBIO DIEGO ANDRES','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(104,79851379,'Claro123','33','PARADA GAMBA MICHEL','na','Zona Integral O&M Cali','Interventor Mtt','Popayan'),(105,94415002,'Claro123','33','SEPULVEDA PEREZ JULIAN ALBERTO','na','Zona Integral O&M Cali','Interventor Red','Cali'),(106,16936923,'Claro123','33','CAICEDO VALENCIA ALVARO','na','Zona Integral O&M Cali','Interventor','Cali Norte'),(107,16491497,'Claro123','33','VASQUEZ ZUÑIGA NERY','na','Zona Integral O&M Cali','Supervisor Oper','Cali'),(108,16765166,'Claro123','33','SILVA IDROBO FABIAN ANDRES','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(109,3396616,'Claro123','33','SUACHE MENDEZ CARLOS ANDRES','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(110,16791983,'Claro123','33','TABARES GRISALES FABIO NELSON','na','Zona Integral O&M Cali','Interventor','Cali'),(111,15813115,'Claro123','33','TRUJILLO RAMIREZ WILSON','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(112,94279768,'Claro123','33','TRULLO USGAME EDILBERTO','na','Zona Integral O&M Cali','Supervisor Oper','Cali'),(113,93410813,'Claro123','33','URRIAGO JUAN EUGENIO','na','Zona Integral O&M Cali','Supervisor Oper','Cali'),(114,94405991,'Claro123','33','VARGAS OLARTE JOSE JULIAN','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(115,16753440,'Claro123','33','VASQUEZ MORA JAIRO ALFONSO','na','Zona Integral O&M Cali','Interventor Cal','Cali'),(116,86050372,'Claro123','33','SEPULVEDA JULIAN ALBERTO','na','Zona Integral O&M Cali','Supervisor Oper','Cali Norte'),(117,16550838,'Claro123','33','MONSALVE MISAEL','na','Zona Integral O&M Cali','Supervisor Oper','Cali Norte'),(118,14576350,'Claro123','33','VASQUEZ JAIRO ALFONSO','na','Zona Integral O&M Cali','Interventor Cal','Popayan'),(119,94279115,'Claro123','33','ZAMBRANO GARCIA LUIS HERNANDO','na','Zona Integral O&M Cali','Supervisor Oper','Cali Norte'),(120,93206131,'Claro123','33','RAMIREZ CARLOS ANDREY','na','Zona Integral O&M Cali','Interventor Cal','Cali Norte'),(121,80542143,'Claro123','32','EDGAR GUILLERMO RUIZ SALGADO','edgar.ruiz.s@claro.com.co','Cali','Coordinador Con','Cali'),(122,94428322,'Claro123','33','FERNANDO ANGULO PENALOSA','fernando.angulo@claro.com.co','Cali','Líder Mantenimi','Cali'),(123,75063526,'Claro123','33','JOHN JAIRO CHICA','jairo.chica@claro.com.co','Cali Sur','Lider de O&M zo','Cali Sur'),(124,76332147,'Claro123','33','RODRIGUEZ HERRERA CAMILO','camilo.rodriguez.h@claro.com.co','Cali','Lider O&M zona ','Cali Norte'),(125,16783034,'Claro123','32','POLO POLINDARA HARVEY','harvey.polo@claro.com.co','Cali','Coodinador Cont','Cali'),(126,80002202,'Claro123','33','CORREA GABRIEL',NULL,'Cali','Coordinador Ali','Cali Norte'),(127,66959976,'Claro123','3','ARISTIZABAL GONZALEZ DIANA',NULL,'Cali','Analista Cacida','Cali');

--
-- Table structure for table `t_vehiculo`
--

CREATE TABLE `t_vehiculo` (
  `Id_vehiculo` int(1) NOT NULL,
  `Nombre_vehiculo` varchar(10) COLLATE utf8_spanish2_ci NOT NULL,
  PRIMARY KEY (`Id_vehiculo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `t_vehiculo`
--

INSERT INTO `t_vehiculo` VALUES (1,'Carry'),(2,'Moto'),(3,'Furgon');

--
-- Table structure for table `t_zona`
--

CREATE TABLE `t_zona` (
  `Id_zona` int(1) NOT NULL AUTO_INCREMENT,
  `Nombre_zona` varchar(10) COLLATE utf8_spanish2_ci NOT NULL,
  `Id_aliado` int(2) NOT NULL,
  PRIMARY KEY (`Id_zona`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `t_zona`
--

INSERT INTO `t_zona` VALUES (1,'Armenia',2),(2,'Florencia ',3),(3,'Ibague ',3),(4,'Manizales',3),(5,'Neiva',1),(6,'Pereira',1),(7,'Cali Norte',1),(8,'Cali Sur',1),(9,'Tulua',1),(10,'Popayan',1),(11,'Pasto',1);

--
-- Dumping events for database 'proyecto'
--

--
-- Dumping routines for database 'proyecto'
--


