--
-- Host: 35.225.233.105    Database: 2018_2019
-- ------------------------------------------------------


--
-- Table structure for table `usuarios`
--

CREATE TABLE `usuarios` (
  `id` varchar(10) DEFAULT '',
  `nombre` varchar(50) DEFAULT '',
  `apellidopaterno` varchar(50) DEFAULT '',
  `apellidomaterno` varchar(50) DEFAULT '',
  `departamento` varchar(50) DEFAULT '',
  `email` varchar(250) DEFAULT '',
  `login` varchar(50) DEFAULT '',
  `name` varchar(255) DEFAULT '',
  `funtion` varchar(150) DEFAULT '',
  `position` varchar(10) DEFAULT '',
  `web_contact` varchar(20) DEFAULT '',
  `export_access` varchar(20) DEFAULT '',
  `import_access` varchar(20) DEFAULT '',
  `contrasena` varchar(50) DEFAULT '',
  `usuario_usuarios` varchar(200) DEFAULT NULL,
  `contrasena_usuarios` varchar(200) DEFAULT NULL,
  `email_usuarios` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usuarios`
--

INSERT INTO `usuarios` VALUES ('26','SRA. KARLA CARMONA','','','EJECUTIVO DE VENTAS','KARLA.CARMONA@INTERTEAM.COM.MX','','MS. KARLA CARMONA','SALES EXECUTIVE','16','','','','','lpv','lpv2010','facturas@lpver.com'),('32','SRA. BEATRIZ ORTIZ','','','IMPORTACION SUDAMERICA','BEATRIZ.ORTIZ@INTERTEAM.COM.MX','','MS. BEATRIZ ORTIZ','IMPORT SOUTH AMERICA','44','','','','','','',''),('39','SRA. JESSICA MEDRANO','','','EXPORTACION EUROPA','JESSICA.MEDRANO@INTERTEAM.COM.MX','','MS. JESSICA MEDRANO','EXPORT EUROPE','34','','','','','','',''),('36','SRA. YAZMIN BRIZUELA','','','SUB GERENTE  EXPORTACIONES & ASIA','YAZMIN.BRIZUELA@INTERTEAM.COM.MX','','MS. YAZMIN BRIZUELA','SUB MANAGER EXPORTS & ASIA','30','','','','','','',''),('110','SR. ANDRES TOVAR','','','EXPORTACION COSTA RICA & PANAMA','ANDRES.TOVAR@INTERTEAM.COM.MX','','ANDRES TOVAR','EXPORT COSTA RICA & PANAMA','38','','','','','','',''),('38','SRA. MICHELLE ESCALANTE','','','EXPORTACION BRASIL,CHILE,ECUADOR & PERU','MICHELLE.ESCALANTE@INTERTEAM.COM.MX','','MS. MICHELLE ESCALANTE','EXPORT BRAZIL,CHILE,ECUADOR & PERU','32','','','','','','',''),('51','SR. KURT W. GIESS','','','DIRECTOR GENERAL','KURT.GIESS@INTERTEAM.COM.MX','','MR. KURT W. GIESS','MANAGING DIRECTOR','01','','','','','','',''),('107','SRA. ELVIA MORENO','','','EJECUTIVO DE VENTAS','ELVIA.MORENO@INTERTEAM.COM.MX','','MS. ELVIA MORENO','SALES EXECUTIVE','15','','','','','','',''),('93','SR. PATRIK RYDBERG','','','GERENTE PRICING','PATRIK.RYDBERG@INTERTEAM.COM.MX','','MR. PATRIK RYDBERG','PRICING MANAGER','05','','','','','','',''),('41','SR. NELSON BARRERA','','','GERENTE REGIONAL GUADALAJARA','NELSON.BARRERA@INTERTEAM.COM.MX','','MR. NELSON BARRERA','REGIONAL MANAGER GUADALAJARA','09','','','','','','',''),('105','SRA. GABRIELA SANCHEZ','','','IMPORTACION EUROPA','GABRIELA.SANCHEZ@INTERTEAM.COM.MX','','MS. GABRIELA SANCHEZ','IMPORT EUROPE','48','','','','','','',''),('52','SR. CHRISTIAN SAMAYOA','','','GERENTE TI & ADMINISTRACION','CHRISTIAN.SAMAYOA@INTERTEAM.COM.MX','','MR. CHRISTIAN SAMAYOA','IT & ADMINISTRATION  MANAGER','07','','','','','','',''),('60','SRA. IRMA AVILES','','','CONTABILIDAD','IRMA.AVILES@INTERTEAM.COM.MX','','MS. IRMA AVILES','ACCOUNTING','22','','','','','','',''),('99','SR. ROMAN LIMA','','','IMPORTACION ASIA','ROMAN.LIMA@INTERTEAM.COM.MX','','MR. ROMAN LIMA','IMPORT ASIA','58','','','','','','',''),('103','SR. HECTOR RODRIGUEZ','','','GERENTE COMERCIAL','HECTOR.RODRIGUEZ@INTERTEAM.COM.MX','','MR. HECTOR RODRIGUEZ','COMMERCIAL MANAGER','04','','','','','','',''),('64','SRA. MARINA PRADO','','','IMPORTACION EUROPA','MARINA.PRADO@INTERTEAM.COM.MX','','MS. MARINA PRADO','IMPORT EUROPE','52','','','','','','',''),('65','SR. ROGELIO LOPEZ','','','EJECUTIVO DE VENTAS GUADALAJARA','ROGELIO.LOPEZ@INTERTEAM.COM.MX','','MR. ROGELIO LOPEZ','SALES EXECUTIVE GUADALAJARA','20','','','','','','',''),('69','SRA. ARELI MEDRANO','','','IMPORTACION EUROPA','ARELI.MEDRANO@INTERTEAM.COM.MX','','MS.  ARELI MEDRANO','IMPORT EUROPE','50','','','','','','',''),('82','SRA. MARGARITA RAMIREZ','','','SUB GERENTE WWA GLOBAL ACCOUNTS','MARGARITA.RAMIREZ@INTERTEAM.COM.MX','','MS. MARGARITA RAMIREZ','WWA GLOBAL ACCOUNTS SUB MANAGER','11','','','','','','',''),('104','SR. HECTOR ORTEGA','','','GERENTE WWA GLOBAL ACCOUNTS','HECTOR.ORTEGA@INTERTEAM.COM.MX','','MR. HECTOR ORTEGA','WWA GLOBAL ACCOUNTS MANAGER','10','','','','','','',''),('79','SRA. MARISOL VILLAR','','','CONTABILIDAD & PAGOS','MARISOL.VILLAR@INTERTEAM.COM.MX','','MS. MARISOL VILLAR','ACCOUNTING & PAYMENTS','24','','','','','','',''),('111','SR. RAUL GARIBAY','','','GERENTE REGIONAL ZONA NORTE','RAUL.GARIBAY@INTERTEAM.COM.MX','','MR. RAUL GARIBAY','REGIONAL MANAGER NORTHERN AREA','08','','','','','','',''),('85','SRA. CLAUDIA FLORES','','','IMPORTACION ASIA','CLAUDIA.FLORES@INTERTEAM.COM.MX','','MS. CLAUDIA FLORES','IMPORT ASIA','54','','','','','','',''),('94','SR. JUAN NUÑEZ','','','IMPORTACION ASIA','JUAN.NUNEZ@INTERTEAM.COM.MX','','MR. JUAN NUÑEZ','IMPORT ASIA','60','','','','','','',''),('98','SRA. LAURA IBARRA','','','CREDITO & COBRANZA','LAURA.IBARRA@INTERTEAM.COM.MX','','MS. LAURA IBARRA','CREDIT & MONEY COLLECTION','26','','','','','','',''),('106','SRA. NORMA ARIZMENDI','','','SUPERVISORA SERVICIO A CLIENTES','NORMA.ARIZMENDI@INTERTEAM.COM.MX','','NS. NORMA ARIZMENDI','SUPERVISOR CUSTOMER SERVICE','12','','','','','','',''),('101','SRA. CECILIA HERRERA','','','EXPORTACION ARGENTINA & COLOMBIA','CECILIA.HERRERA@INTERTEAM.COM.MX','','MS. CECILIA HERRERA','EXPORT ARGENTINA & COLOMBIA','36','','','','','','',''),('102','SRA. FABIOLA MENDOZA','','','SERVICIO A CLIENTES','FABIOLA.MENDOZA@INTERTEAM.COM.MX','','MS. FABIOLA MENDOZA','CUSTOMER SERVICE','13','','','','','','',''),('112','SRA. JANET LAVARIEGA','','','EJECUTIVO DE VENTAS','JANET.LAVARIEGA@INTERTEAM.COM.MX','','MS. JANET LAVARIEGA','SALES EXECUTIVE','18','','','','','','',''),('108','SRA. KARLA CARRILLO','','','IMPORTACION ASIA','KARLA.CARRILLO@INTERTEAM.COM.MX','','MS. KARLA CARRILLO','IMPORT ASIA','56','','','','','','',''),('113','SRA. JUANITA PUGA','','','CREDITO & COBRANZA','JUANITA.PUGA@INTERTEAM.COM.MX','','MS. JUANITA PUGA','CREDIT & MONEY COLLECTION','28','','','','','','',''),('120','SAMUEL BLOOM','','','GENERAL','SAMUEL@HOTMAIL.COM','','','','','','','','CCLPM','cristina.cardenas','CCLPM','cristina.cardenas@lpmzlo.com'),('116','SRA. NATALIA ALVAREZ','','','EXPORTACION TERRESTRE & BOOKINGS','NATALIA.ALVAREZ@INTERTEAM.COM.MX','','MS. NATALIA ALVAREZ','EXPORT OVERLAND & BOOKINGS','40','','','','','','',''),('117','SR. JOSE TOUNSON','','','CONTRALOR','JOSE.TOUNSON@INTERTEAM.COM.MX','','MR. JOSE TOUNSON','CONTROLLER','02','','','','','','',''),('118','SRA. JUDITH GAMA','','','SERVICIO A CLIENTES','JUDITH.GAMA@INTERTEAM.COM.MX','','MS. JUDITH GAMA','CUSTOMER SERVICE','14','','','','','','',''),('119','SR. JAVIER VARGAS','','','GERENTE CONTABILIDAD','JAVIER.VARGAS@INTERTEAM.COM.MX','','MR. JAVIER VARGAS','ACCOUNTING MANAGER','06','','','','','','',''),('','MARCELA GODINEZ','','','EXPORTACION','MARCELA.GODINEZ@INTERTEAM.COM.MX','MARCELAGODINEZ','MARCELA GODINEZ','EXPORTACION','90','YES','','','3','3','2','MARCELA.GODINEZ@INTERTEAM.COM.MX'),('100','SRA LORENA FABIANA ZAPATA PROVASSI','','','','LORENA.ZAPATA@INTERTEAM.COM.MX','','','','','','','','',NULL,NULL,NULL),('100','FABIOLA MENDOZA','','','','BOOKINGS@INTERTEAM.COM.MX','','','','','','','','',NULL,NULL,NULL);


