--
-- Host: 35.225.233.105    Database: 2017_2018
-- ------------------------------------------------------


--
-- Table structure for table `usuarioslpv`
--

CREATE TABLE `usuarioslpv` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `empresa` varchar(255) NOT NULL DEFAULT '',
  `nombre` varchar(255) NOT NULL DEFAULT '',
  `usuario` varchar(100) NOT NULL DEFAULT '',
  `pass` varchar(50) NOT NULL DEFAULT '',
  `departamento` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(200) NOT NULL DEFAULT '',
  `tipo` varchar(50) NOT NULL DEFAULT '' COMMENT 'A = Administrador E = Ejecutivo AA = Agente Aduanal C = Cliente',
  `referencia` varchar(150) NOT NULL DEFAULT '',
  `rol` varchar(5) DEFAULT NULL COMMENT 'E = Ejecutivo All = todos A = Administrador',
  `activo` int(11) DEFAULT NULL,
  `perfil` varchar(20) DEFAULT NULL,
  `creadopor` varchar(11) DEFAULT NULL,
  `fechaRegistro` datetime DEFAULT NULL,
  `editadorpor` int(11) DEFAULT NULL,
  `fechaUpdate` datetime DEFAULT NULL,
  `tipoe` varchar(50) DEFAULT NULL,
  `gafete` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usuarioslpv`
--

INSERT INTO `usuarioslpv` VALUES ('1','LPV','LORENA ZAPATA','LFZX','1111','sistemas','lorena.zapata@interteam.com.mx','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('2','LPV','JOSE HERNANDEZ','JHERNANDEZeqweewqeeqwe','lp123','GERENTE DE OPERACIONES','JOSE.HERNANDEZ@LPVER.COM','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('13','LPV','SHEILA ALANIS','SHEILA.ALANIS','lpv33','CONFIRMACIONES','SHEILA.ALANIS@LPVER.COM','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('14','LPV','ERENDIRA CERVANTES','ERENDIRA.CERVANTES','lp2008','HBL PANALPINA','ERENDIRA.CERVANTES@LPVER.COM','OPERACIONES','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('12','LPV','ANTONIO YEPEZ','ANTONIO.YEPEZ','ay3ay','CONFIRMACIONES','ANTONIO.YEPEZ@LPVER.COM','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1','LPV','Mayret Flores ','mayret.flores','teryam','GERENTE','mayret.flores@lpver.com','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('2','LPV','JOSE HERNANDEZ','JHERNANDEZ','okok12333232123334','GERENTE DE OPERACIONES','JOSE.HERNANDEZ@LPVER.COM','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1','LPV','MARISA PINO VILLA','MPINO','1111','','marisa.pino@lpver.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('11','LPV','JOSE TOUNSON','JOSE.TOUNSON','jt43','CONTADOR','JOSE.TOUNSON@LPVER.COM','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('501','LPV','Ana Rodriguez','AnaRodriguez','1arnemo','Operaciones','ANA.RODRIGUEZ@LPV.COM','OPERACIONES','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('15','LPV','MARISA PINO','MARISA.PINO','mp12lpv','HBL PANALPINA','MARISA.PINO@LPVER.COM','OPERACIONES','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1','LPM','JAVIER GONZALEZ','JGONZALEZ','7594','','javier.gonzalez@lpmzlo.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('18','LPV','VANESA PAREDES','VANESA.PAREDES','vp81','HBL','VANESA.PAREDES@LPVER.COM','OPERACIONES','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10','LPV','TAMINA DíAZ','td97','TDIAZ123','HBL','ALMA.TAMINA@LPVER.COM','OPERACIONES','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('','LPV','Tania Sanchez','Tania.Sanchez','santan32','%','Tania.Sanchez@lpver.com','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('','LPV','Sergio Reyes','Sergio.Reyes','serrey45','%','Sergio.Reyes@lpver.com','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('','contabilidad','contabilidad','contabilidad','conta2010','contabilidad','','','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('','LPV','Ana Karen Rodriguez ','anakaren.rodriguez','ankaro','GERENTE','anakaren.rodriguez@lpver.com','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('','LPV','Juanita Bautista','juanita.bautista','juabau','GERENTE','juanita.bautista@lpver.com','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('','INTERTEAM','ELENA MACHADO','EMS','1429','CONTABILIDAD','elena.machado@interteam.com.mx','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('','LPV','PATRICIA CUELLAR','PCC','PCUELLAR','HBL','patricia.cuellar@lpver.com','OPERACIONES','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('','LPV','RUBEN VALERIO BENITEZ','RUBVAL','1111','EXPORTACION','ruben.valerio@lpver.com','E','','A',1,'General','LFZX','2013-05-08 00:00:00',NULL,NULL,NULL,51932),('','EMPRESA DEL CLIENTE','CLIENTE','CLIENTE','1111','EXPORTACION','','C','','A',1,'General','0','2013-05-08 10:46:27',NULL,NULL,NULL,NULL),('','LPVER','INGRID CONTRERAS','INGCON','INCONTRERAS','hbl','ingrid.contreras@lpver.com','OPERACIONES','%','A',1,'General',NULL,NULL,NULL,NULL,NULL,NULL),('14770','LPV','RUBEN VALERIO BENITEZ','RUBEVAL','7t1i3j4a','EXPORTACION','ruben.valerio@lpver.com','E','','A',1,'General',NULL,NULL,NULL,NULL,'E',51932),('14771','LPV','CECILIA SANCHEZ','CECISAN','1002regi','EXPORTACION','cecilia.sanchez@lpver.com','E','','A',1,'General',NULL,NULL,NULL,NULL,'E',36071),('14772','LPV','FERNANDO QUIROZ SANDRIA','FERNQUI','arilei1702','EXPORTACION LPVER','fernando.quiroz@lpver.com','E','','A',1,'General',NULL,NULL,NULL,NULL,'E',36068),('14773','LPV','LUIS MARTINEZ REYES','MARTLU','mojarra13','EXPORTACION LPVER','luis.martinez@lpver.com','E','','A',1,'General',NULL,NULL,NULL,NULL,'E',51936),('1','LPA','NORMA ESPINOSA','NESPINOSA','2222','','norma.espinosa@lpalt.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('13','LPV','MIGUEL GONZALEZ','miggon','Mickey','CONFIRMACIONES','miguel.gonzalez@lpver.com','ADMINISTRADOR','%',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('14771','LPV','Jorge Alberto Reyes Sandoval','JREYES','1980','EXPORTACION','jorge.reyes@lpver.com','E','','A',1,'General',NULL,NULL,NULL,NULL,'E',0),('1','LPV','ELENA MACHADO','EMACHADO','1111','CONTABILIDAD','elena.machado@interteam.com.mx','E','%','E',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPA','LAURA ARTEAGA VEGA','LARTEAGA','1111','','laura.arteaga@lpalt.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPA','VANESSA DEL ANGEL PEREZ','VDELANGEL','1111','','vanesa.delangel@lpalt.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPA','VIOLETA MORALES JUAREZ','VMORALES','1111','','violeta.juarez@lpalt.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPM','MONICA FIGUEROA','MFIGUEROA','5410','','monica.figueroa@lpmzlo.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPV','ANA CECILIA SANCHEZ AGUILAR','asanchez','1111','','cecilia.sanchez@lpver.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPV','FERNANDO QUIROZ SANDRIA','FQUIROGA','1111','','fernando.quiroga@lpver.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPV','LUIS MARTINEZ REYES','LMARTINEZ','1111','','luis.martinez@lpver.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPV','ORLANDO GARCIA BLANCO','OGARCIA','1111','','orlando.garcia@lpver.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',36067),('1','LPV','RUBEN VALERIO BENITEZ','RVALERIO','1111','','ruben.valerio@lpver.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPM','ADRIAN MARTINEZ','AMARTINEZ','1111','','adrian.martinez@lpmzlo.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPV','JULIA CASTILLO DOMINGUEZ','JCASTILLO','1111','','julia.castillo@lpver.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPV','ERENDIRA CERVANTES MORALES','ECERVANTES','1111','','erendira.cervantes@lpver.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPM','PAOLA DENISE FERNANDEZ BENITEZ','PFERNANDEZ','7791','','paola.fernandez@lpmzlo.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPM','RUTH FLORIAN ALVAREZ','RFLORIAN','4693','','ruth.florian@lpmzlo.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPL','ALMA MORENO','AMORENO','1111','','alma.moreno@lplc.com.mx','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('14771','LPV','MAYRA LLANOS','MLLANOS','4001','EXPORTACION','mayra.llanos@lpver.com','E','','A',1,'General',NULL,NULL,NULL,NULL,'E',36061),('1','LPM','IVAN SOTELO','ISOTELO','1111','','ivan.sotelo@lpmzlo.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPM','PATRICIA BENITEZ','PBENITEZ','5411','','patricia.benitez@lpmzlo.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL),('1','LPM','FABIOLA ZEPEDA LEON','FZEPEDA','4512','','fabiola.zepeda@lpmzlo.com','E','%','A',1,NULL,NULL,NULL,NULL,NULL,'E',NULL);


