# Host: localhost  (Version 5.7.24)
# Date: 2019-03-11 19:18:45
# Generator: MySQL-Front 6.1  (Build 1.26)


#
# Structure for table "tblconsultas"
#

DROP TABLE IF EXISTS `tblconsultas`;
CREATE TABLE `tblconsultas` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `fchFecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `refUsuario` int(11) DEFAULT NULL,
  `strConsulta` text NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

#
# Data for table "tblconsultas"
#

/*!40000 ALTER TABLE `tblconsultas` DISABLE KEYS */;
INSERT INTO `tblconsultas` VALUES (1,'2019-03-11 19:10:19',0,'SELECT Id, strEmail, strPassword, intTipo FROM tblusuario WHERE strEmail=\'jorvidu@gmail.com\' AND strPassword=\'38ce1e52c4f77c2548216911bba796740fc2a72a992f25197ce15b6d97862e39\' AND intEstado=1'),(2,'2019-03-11 19:12:29',0,'INSERT INTO tblusuario(strEmail, strPassword, strNombre, intTipo, intEstado) VALUES (\'jorvidu@gmail.com\', \'8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92\', \'Jorge\', 0, 1)'),(3,'2019-03-11 19:14:59',0,'INSERT INTO tblusuario(strEmail, strPassword, strNombre, intTipo, intEstado) VALUES (\'jorvidu@gmail.com\', \'d2198f8668a091685ecd15f9c71b59d67bd2242a7de57cb8b5a5460d7018a323\', \'werfwer\', 0, 1)');
/*!40000 ALTER TABLE `tblconsultas` ENABLE KEYS */;

#
# Structure for table "tblusuario"
#

DROP TABLE IF EXISTS `tblusuario`;
CREATE TABLE `tblusuario` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `strEmail` varchar(60) NOT NULL DEFAULT '',
  `strPassword` varchar(100) NOT NULL DEFAULT '',
  `strNombre` varchar(100) NOT NULL DEFAULT '',
  `fchAlta` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `intTipo` int(11) NOT NULL DEFAULT '0' COMMENT '0: Usuario 1: Ofrece Servicios',
  `fchModificacion` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `intEstado` int(11) DEFAULT '1',
  PRIMARY KEY (`Id`),
  UNIQUE KEY `strEmail` (`strEmail`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

#
# Data for table "tblusuario"
#

/*!40000 ALTER TABLE `tblusuario` DISABLE KEYS */;
INSERT INTO `tblusuario` VALUES (7,'sdfgsdf@sfdfsdf.com','8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92','Jorge','2019-03-07 17:16:04',0,NULL,1),(9,'jorvidu@gmail.com','8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92','Jorge','2019-03-11 19:12:29',0,NULL,1);
/*!40000 ALTER TABLE `tblusuario` ENABLE KEYS */;
