/*
MySQL Backup
Source Server Version: 5.6.16
Source Database: ptofabrica
Date: 11/02/2015 15:49:48
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
--  Table structure for `tblcarrito`
-- ----------------------------
DROP TABLE IF EXISTS `tblcarrito`;
CREATE TABLE `tblcarrito` (
  `intContador` int(11) NOT NULL AUTO_INCREMENT,
  `idUsuario` int(11) NOT NULL,
  `idProducto` int(11) NOT NULL,
  `intCantidad` int(11) NOT NULL DEFAULT '1',
  `intTransaccionEfectuada` int(11) NOT NULL DEFAULT '1',
  `fchCompra` datetime DEFAULT NULL,
  PRIMARY KEY (`intContador`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `tblcategoria`
-- ----------------------------
DROP TABLE IF EXISTS `tblcategoria`;
CREATE TABLE `tblcategoria` (
  `idCategoria` int(11) NOT NULL AUTO_INCREMENT,
  `strDescripcion` varchar(50) NOT NULL,
  PRIMARY KEY (`idCategoria`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `tblcompra`
-- ----------------------------
DROP TABLE IF EXISTS `tblcompra`;
CREATE TABLE `tblcompra` (
  `idCompra` int(11) NOT NULL AUTO_INCREMENT,
  `idUsuario` int(11) NOT NULL,
  `fchCompra` datetime NOT NULL,
  `dblTotal` double NOT NULL,
  PRIMARY KEY (`idCompra`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `tblproducto`
-- ----------------------------
DROP TABLE IF EXISTS `tblproducto`;
CREATE TABLE `tblproducto` (
  `idProducto` int(11) NOT NULL AUTO_INCREMENT,
  `strNombre` varchar(100) NOT NULL,
  `strSEO` varchar(200) NOT NULL,
  `dblPrecio` double NOT NULL,
  `intEstado` int(11) NOT NULL,
  `intCategoria` int(11) NOT NULL,
  `strImagen` varchar(70) NOT NULL DEFAULT '',
  `intCantidad` int(11) NOT NULL,
  PRIMARY KEY (`idProducto`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `tblusuario`
-- ----------------------------
DROP TABLE IF EXISTS `tblusuario`;
CREATE TABLE `tblusuario` (
  `idUsuario` int(11) NOT NULL AUTO_INCREMENT,
  `strNombre` varchar(50) NOT NULL,
  `strEmail` varchar(100) NOT NULL,
  `intActivo` int(11) NOT NULL,
  `strPassword` varchar(50) NOT NULL,
  `intPermiso` int(11) NOT NULL DEFAULT '1',
  `str1Nombre` varchar(50) NOT NULL DEFAULT '',
  `strApellido` varchar(50) NOT NULL DEFAULT '',
  `strDireccion` varchar(500) NOT NULL,
  `intCedula` varchar(8) NOT NULL,
  PRIMARY KEY (`idUsuario`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `tblvariables`
-- ----------------------------
DROP TABLE IF EXISTS `tblvariables`;
CREATE TABLE `tblvariables` (
  `idContador` int(11) NOT NULL AUTO_INCREMENT,
  `intIVA` int(11) DEFAULT NULL,
  PRIMARY KEY (`idContador`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records 
-- ----------------------------
INSERT INTO `tblcarrito` VALUES ('6','1','8','1','4','2015-02-03 13:03:59'), ('13','1','8','1','4','2015-02-03 13:03:59'), ('15','1','8','1','4','2015-02-03 13:03:59'), ('17','1','8','3','4','2015-02-03 13:03:59'), ('18','1','8','3','4','2015-02-03 13:03:59'), ('19','1','9','4','4','2015-02-03 13:03:59'), ('20','4','8','2','4','2015-02-03 13:03:59'), ('21','1','8','3','4','2015-02-03 13:03:59'), ('23','1','9','1','4','2015-02-03 13:03:59'), ('24','1','9','1','4','2015-02-03 18:26:02'), ('25','1','9','4','4','2015-02-03 18:35:15'), ('29','1','18','2','4','2015-02-03 18:35:15'), ('30','1','17','4','4','2015-02-03 18:35:15'), ('31','1','12','1','4','2015-02-03 18:13:21'), ('32','1','12','1','4','2015-02-03 18:15:40'), ('33','1','12','1','4','2015-02-03 18:35:15'), ('34','1','12','5','4','2015-02-03 18:17:57'), ('35','1','15','1','4','2015-02-03 18:21:37'), ('36','1','15','1','4','2015-02-03 18:35:15'), ('37','1','16','1','4','2015-02-03 18:23:14'), ('38','1','16','4','4','2015-02-03 18:34:07'), ('39','1','16','4','4','2015-02-03 18:35:15'), ('40','1','9','2','4','2015-02-04 23:06:17');
INSERT INTO `tblcategoria` VALUES ('1','Velas'), ('2','Muebles'), ('3','Edredones'), ('4','Alfombras'), ('5','mesas');
INSERT INTO `tblcompra` VALUES ('34','1','2015-01-20 19:03:27','150.08'), ('35','1','2015-01-20 19:03:34','150.08'), ('36','1','2015-01-20 19:07:59','150.08'), ('37','1','2015-01-20 19:14:55','150.08'), ('38','1','2015-01-20 19:27:42','450.24'), ('39','1','2015-01-20 19:29:01','450.24'), ('40','4','2015-01-23 09:18:00','300.16');
INSERT INTO `tblproducto` VALUES ('8','cuado','wer','5','1','4','100_2307.JPG','23'), ('9','algo','few','254','1','2','100_2307.JPG','20'), ('10','aldfdg','wferge','25234','1','2','100_2307.JPG','20'), ('11','wefkjw','fiwge','3242','1','4','100_2307.JPG','20'), ('12','vela grande blanca','fwkjef','2374','1','1','100_2307.JPG','36'), ('13','prueba1','wef','1342','1','1','100_2307.JPG','45'), ('14','prueba2','23fwe','2342','1','1','100_2307.JPG','20'), ('15','prueba 3','wfjwh','14243','1','1','100_2307.JPG','20'), ('16','asdads','fewfw','242','1','4','100_2307.JPG','24'), ('17','wfwf','qefqf','234','1','4','100_2304.JPG','20'), ('18','x','y','250','1','4','100_2303.JPG','20');
INSERT INTO `tblusuario` VALUES ('1','jefe','admin@gmail.com','1','fernando','2','fernando','martinez','las quintas de naguanagua 3ra calle casa 96-103\r\nlas quintas de naguanagua 3ra calle casa 96-103','18783530'), ('2','cliente','fernando@gmail.com','2','fernando','2','fernando','martinez','werfwf','12345678'), ('4','alguien','algo@gmail.com','1','1','1','algo','x','fregtrgd','12378945'), ('5','uno','uno@gmail.com','1','1','1','fernando','martinez','wfwfe','18783530'), ('6','q','a@gmail.com','1','1','1','a','b','wfwef','12345678'), ('7','x','1@gmail.com','1','1','1','1','2','wfwef','12345612'), ('8','1','2@gmail.com','1','1','1','2','3','wfwef','12345667'), ('9','a','c@gmail.com','1','1','1','b','c','rferfef','12345678'), ('10','e','r@gmail.com','1','12345','1','d','c','wfwefwe','12345678'), ('11','1','5@gmail.com','1','12345','1','2','3','fwfwe','45678912'), ('12','q','w@gmail.com','1','[a..z]','1','2','3','fwfwe','45678912'), ('13','e','e@gmail.com','1','s1','1','2','3','fwfwe','45678912'), ('14','a','b@gmail.com','1','f12345F','1','2','3','fwfwe','45678912'), ('15','o','j@gmail.com','1','123456fg','1','p','k','fwefw','14563278'), ('16','w','l@gmail.com','1','741963fg','1','w','e','fwefw','12345678'), ('17','cliente','cliente@gmail.com','1','741963fg','1','jose','persona','ytff','18412563');
INSERT INTO `tblvariables` VALUES ('1','12');