INSERT INTO informe VALUES("11819","123456789","2015-10-30","09:15:22","82/1monterreynuevo/Modulos/venta/facturar.php","::1");
INSERT INTO informe VALUES("11820","123456789","2015-10-30","09:15:30","82/1monterreynuevo/Modulos/venta/facturar.php","::1");
INSERT INTO informe VALUES("11821","123456789","2015-10-30","09:15:51","82/1monterreynuevo/Modulos/venta/facturar.php","::1");
INSERT INTO informe VALUES("11822","123456789","2015-10-30","09:18:06","82/1monterreynuevo/Modulos/principal/","::1");
INSERT INTO informe VALUES("11823","123456789","2015-10-30","09:18:10","82/1monterreynuevo/Modulos/usuario/consultar.php","::1");
INSERT INTO informe VALUES("11824","123456789","2015-10-30","09:18:11","82/1monterreynuevo/Modulos/usuario/permiso.php?u=caa297fe47671dbb6c4ba4547ebef3a4a022cc91","::1");
INSERT INTO informe VALUES("11825","123456789","2015-10-30","09:18:19","82/1monterreynuevo/Modulos/usuario/permiso.php?i=a45999286e69faa1ed4dddb8f3c37d7c0258f238&u=caa297fe47671dbb6c4ba4547ebef3a4a022cc91","::1");
INSERT INTO informe VALUES("11826","123456789","2015-10-30","09:18:19","82/1monterreynuevo/Modulos/usuario/permiso.php?u=caa297fe47671dbb6c4ba4547ebef3a4a022cc91","::1");
INSERT INTO informe VALUES("11827","123456789","2015-10-30","09:18:24","82/1monterreynuevo/Modulos/venta/facturar.php","::1");
INSERT INTO informe VALUES("11828","123456789","2015-10-30","09:21:34","82/1monterreynuevo/Modulos/principal/","::1");
INSERT INTO informe VALUES("11829","123456789","2015-10-30","09:34:50","82/1monterreynuevo/Modulos/usuario/consultar.php","::1");
INSERT INTO informe VALUES("11830","123456789","2015-10-30","09:34:52","82/1monterreynuevo/Modulos/usuario/permiso.php?u=caa297fe47671dbb6c4ba4547ebef3a4a022cc91","::1");
INSERT INTO informe VALUES("11831","123456789","2015-10-30","09:34:57","82/1monterreynuevo/Modulos/usuario/permiso.php?i=e9e4ef61b18759cee69b3212aa385c37848a6ddf&u=caa297fe47671dbb6c4ba4547ebef3a4a022cc91","::1");
INSERT INTO informe VALUES("11832","123456789","2015-10-30","09:34:57","82/1monterreynuevo/Modulos/usuario/permiso.php?u=caa297fe47671dbb6c4ba4547ebef3a4a022cc91","::1");
INSERT INTO informe VALUES("11833","123456789","2015-10-30","09:35:05","82/1monterreynuevo/Modulos/datos/apartado.php","::1");
INSERT INTO informe VALUES("11834","123456789","2015-10-30","10:44:02","82/1monterreynuevo/Modulos/datos/apartado.php","::1");
INSERT INTO informe VALUES("11835","123456789","2015-10-30","10:44:54","82/1monterreynuevo/Modulos/datos/apartado.php","::1");
INSERT INTO informe VALUES("11836","123456789","2015-10-30","10:45:01","82/1monterreynuevo/Modulos/datos/apartado.php","::1");
INSERT INTO informe VALUES("11837","123456789","2015-10-30","10:45:06","82/1monterreynuevo/Modulos/datos/apartado.php","::1");
INSERT INTO informe VALUES("11838","123456789","2015-10-30","10:46:13","82/1monterreynuevo/Modulos/venta/facturar.php","::1");
INSERT INTO informe VALUES("11839","123456789","2015-10-30","10:46:33","82/1monterreynuevo/Modulos/venta/facturar.php","::1");
INSERT INTO informe VALUES("11840","123456789","2015-10-30","10:56:20","82/1monterreynuevo/Modulos/datos/apartado.php","::1");
INSERT INTO informe VALUES("11841","123456789","2015-10-30","10:56:40","82/1monterreynuevo/Modulos/datos/apartado.php","::1");
INSERT INTO informe VALUES("11842","123456789","2015-10-30","10:56:45","82/1monterreynuevo/Modulos/datos/apartado.php","::1");
INSERT INTO informe VALUES("11843","123456789","2015-10-30","10:58:22","82/1monterreynuevo/Modulos/datos/apartado.php","::1");
INSERT INTO informe VALUES("11844","123456789","2015-10-30","11:03:38","82/1monterreynuevo/Modulos/datos/apartado.php","::1");
INSERT INTO informe VALUES("11845","123456789","2015-10-30","11:30:49","82/1monterreynuevo/Modulos/usuario/consultar.php","::1");
INSERT INTO informe VALUES("11846","123456789","2015-10-30","11:30:51","82/1monterreynuevo/Modulos/usuario/permiso.php?u=caa297fe47671dbb6c4ba4547ebef3a4a022cc91","::1");
INSERT INTO informe VALUES("11847","123456789","2015-10-30","11:30:56","82/1monterreynuevo/Modulos/usuario/permiso.php?i=3b7c8c048afcb0d94bc8b6cde28462bf1cb7b1a8&u=caa297fe47671dbb6c4ba4547ebef3a4a022cc91","::1");
INSERT INTO informe VALUES("11848","123456789","2015-10-30","11:30:56","82/1monterreynuevo/Modulos/usuario/permiso.php?u=caa297fe47671dbb6c4ba4547ebef3a4a022cc91","::1");
INSERT INTO informe VALUES("11849","123456789","2015-10-30","11:31:00","82/1monterreynuevo/Modulos/venta/consultar_apartado.php","::1");
INSERT INTO informe VALUES("11850","123456789","2015-10-30","11:31:09","82/1monterreynuevo/Modulos/venta/consultar_apartado.php?fechai=2015-10-30&fechaf=2015-10-30","::1");
INSERT INTO informe VALUES("11851","123456789","2015-10-30","11:31:13","82/1monterreynuevo/Modulos/venta/consultar_apartado.php","::1");
INSERT INTO informe VALUES("11852","123456789","2015-10-30","11:33:59","82/1monterreynuevo/Modulos/venta/consultar_apartado.php","::1");
INSERT INTO informe VALUES("11853","123456789","2015-10-30","11:34:14","82/1monterreynuevo/Modulos/venta/consultar_apartado.php","::1");
INSERT INTO informe VALUES("11854","123456789","2015-10-30","11:34:20","82/1monterreynuevo/Modulos/venta/proceso.php","::1");
INSERT INTO informe VALUES("11855","123456789","2015-10-30","11:34:23","82/1monterreynuevo/Modulos/venta/proceso.php?i=7c0002683b941441e0683dcc54069ee2ffd46351","::1");
INSERT INTO informe VALUES("11856","123456789","2015-10-30","11:34:24","82/1monterreynuevo/Modulos/venta/ticket.php?i=7c0002683b941441e0683dcc54069ee2ffd46351","::1");
INSERT INTO informe VALUES("11857","123456789","2015-10-30","11:37:36","82/1monterreynuevo/Modulos/venta/consultar.php","::1");
INSERT INTO informe VALUES("11858","123456789","2015-10-30","11:37:39","82/1monterreynuevo/Modulos/venta/consultar.php?fechai=2015-10-30&fechaf=2015-10-30","::1");
INSERT INTO informe VALUES("11859","123456789","2015-10-30","11:39:03","82/1monterreynuevo/Modulos/venta/consultar.php?fechai=2015-10-30&fechaf=2015-10-30","::1");
INSERT INTO informe VALUES("11860","123456789","2015-10-30","11:39:10","82/1monterreynuevo/Modulos/venta/cotiza_consultar.php","::1");
INSERT INTO informe VALUES("11861","123456789","2015-10-30","11:39:14","82/1monterreynuevo/Modulos/venta/consultar_apartado.php","::1");
INSERT INTO informe VALUES("11862","123456789","2015-10-30","11:43:12","82/1monterreynuevo/Modulos/venta/consultar_apartado.php","::1");
INSERT INTO informe VALUES("11863","123456789","2015-10-30","11:43:15","82/1monterreynuevo/Modulos/venta/ticket.php?i=7c0002683b941441e0683dcc54069ee2ffd46351","::1");
INSERT INTO informe VALUES("11864","123456789","2015-10-30","11:44:24","82/1monterreynuevo/Modulos/venta/consultar_apartado.php?cliente=15","::1");
INSERT INTO informe VALUES("11865","123456789","2015-10-30","11:58:11","82/1monterreynuevo/Modulos/venta/consultar_apartado.php?cliente=15","::1");
INSERT INTO informe VALUES("11866","123456789","2015-10-30","11:58:25","82/1monterreynuevo/Modulos/venta/consultar_apartado.php?cliente=15","::1");
INSERT INTO informe VALUES("11867","123456789","2015-10-30","11:58:30","82/1monterreynuevo/Modulos/venta/consultar_apartado.php?tipo=112","::1");
INSERT INTO informe VALUES("11868","123456789","2015-10-30","11:58:43","82/1monterreynuevo/Modulos/venta/consultar_apartado.php?tipo=112","::1");
INSERT INTO informe VALUES("11869","123456789","2015-10-30","11:59:22","82/1monterreynuevo/Modulos/venta/consultar_apartado.php?tipo=112","::1");
INSERT INTO informe VALUES("11870","123456789","2015-10-30","11:59:25","82/1monterreynuevo/Modulos/venta/consultar_apartado.php?tipo=31842bbfef6724a706c75d639edb683f87eeb2d8","::1");
INSERT INTO informe VALUES("11871","123456789","2015-10-30","11:59:29","82/1monterreynuevo/Modulos/venta/consultar_apartado.php?tipo=6c77968369a52386afe85704b669809d45bba589","::1");
INSERT INTO informe VALUES("11872","123456789","2015-10-30","13:13:22","82/1monterreynuevo/Modulos/venta/index.php","::1");
INSERT INTO informe VALUES("11873","123456789","2015-10-30","13:16:30","82/1monterreynuevo/Modulos/principal/","::1");
INSERT INTO informe VALUES("11874","123456789","2015-10-30","13:16:32","82/1monterreynuevo/Modulos/principal/conteo.php","::1");
INSERT INTO informe VALUES("11875","123456789","2015-10-30","13:16:34","82/1monterreynuevo/Modulos/principal/","::1");
INSERT INTO informe VALUES("11876","123456789","2015-10-30","13:16:38","82/1monterreynuevo/Modulos/principal/admin_BD.php","::1");
INSERT INTO informe VALUES("11877","123456789","2015-10-30","13:16:39","82/1monterreynuevo/Modulos/principal/actualizar.php","::1");
INSERT INTO informe VALUES("11878","123456789","2015-10-30","13:16:40","82/1monterreynuevo/Modulos/principal/actualizar.php","::1");
INSERT INTO informe VALUES("11879","123456789","2015-10-30","14:29:07","82/1monterreynuevo/Modulos/servicios/consultar.php","::1");
INSERT INTO informe VALUES("11880","123456789","2015-10-30","14:53:19","82/1monterreynuevo/Modulos/financiero/estado.php","::1");
INSERT INTO informe VALUES("11881","123456789","2015-10-30","17:24:42","82/1monterreynuevo/Modulos/bodega/trans.php","::1");
INSERT INTO informe VALUES("11882","123456789","2015-10-30","17:24:47","82/1monterreynuevo/Modulos/bodega/contenido.php","::1");
INSERT INTO informe VALUES("11883","123456789","2015-10-30","17:24:52","82/1monterreynuevo/Modulos/bodega/contenido.php?sucursal=1&refe=grupo&subrefe=16","::1");
INSERT INTO informe VALUES("11884","123456789","2015-10-31","10:17:23","82/1monterreynuevo/","::1");
INSERT INTO informe VALUES("11885","123456789","2015-10-31","10:28:41","82/1monterreynuevo/","::1");
INSERT INTO informe VALUES("11886","123456789","2015-10-31","10:28:44","82/1monterreynuevo/Modulos/principal/","::1");
INSERT INTO informe VALUES("11887","123456789","2015-10-31","10:47:44","82/1monterreynuevo/Modulos/principal/","::1");
INSERT INTO informe VALUES("11888","123456789","2015-10-31","10:47:45","82/1monterreynuevo/Modulos/principal/ceder.php","::1");
INSERT INTO informe VALUES("11889","123456789","2015-10-31","10:54:19","82/1monterreynuevo/Modulos/principal/ceder.php","::1");
INSERT INTO informe VALUES("11890","123456789","2015-10-31","10:55:53","82/1monterreynuevo/Modulos/principal/ceder.php","::1");
INSERT INTO informe VALUES("11891","123456789","2015-10-31","10:56:24","82/1monterreynuevo/Modulos/principal/ceder.php","::1");
INSERT INTO informe VALUES("11892","123456789","2015-10-31","11:03:43","82/1monterreynuevo/Modulos/principal/ceder.php","::1");
INSERT INTO informe VALUES("11893","123456789","2015-10-31","11:04:27","82/1monterreynuevo/Modulos/principal/ceder.php","::1");
INSERT INTO informe VALUES("11894","123456789","2015-10-31","11:12:56","82/1monterreynuevo/Modulos/principal/ceder.php?i=730cdf062eed2454e64723c83d45b243c277bcb0","::1");
INSERT INTO informe VALUES("11895","123456789","2015-10-31","11:12:56","82/1monterreynuevo/Modulos/principal/ceder.php","::1");
INSERT INTO informe VALUES("11896","123456789","2015-10-31","12:25:11","82/1monterreynuevo/Modulos/venta/admin_cxc.php","::1");
INSERT INTO informe VALUES("11897","123456789","2015-10-31","12:25:12","82/1monterreynuevo/Modulos/venta/admin_detalle.php?i=c0b56e05b4f234bd2ee0f4ac624c98d9a4615d69","::1");
INSERT INTO informe VALUES("11898","123456789","2015-10-31","12:28:17","82/1monterreynuevo/","::1");
INSERT INTO informe VALUES("11899","123456789","2015-10-31","12:28:22","82/1monterreynuevo/","::1");


CREATE TABLE `iva` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `valor` varchar(100) NOT NULL,
  `estado` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO iva VALUES("2","IVA PRUEBA","16","s");


CREATE TABLE `lista` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `impuesto` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO lista VALUES("1","Lista A","s");
INSERT INTO lista VALUES("2","Lista B","n");
INSERT INTO lista VALUES("3","Lista C","n");
INSERT INTO lista VALUES("4","Lista D","n");
INSERT INTO lista VALUES("5","Lista E","n");
INSERT INTO lista VALUES("6","Lista F","n");


CREATE TABLE `metodopago` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO metodopago VALUES("1","Contados","Contado");
INSERT INTO metodopago VALUES("2","Credito","Credito");
INSERT INTO metodopago VALUES("3","Tarjeta","Credito");
INSERT INTO metodopago VALUES("4","Depositos","Credito");
INSERT INTO metodopago VALUES("5","Bonos","Credito");
INSERT INTO metodopago VALUES("6","Promociones","Contado");


CREATE TABLE `no_concepto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO no_concepto VALUES("1","Comisiones","positivo");
INSERT INTO no_concepto VALUES("2","Descuentos","negativo");
INSERT INTO no_concepto VALUES("3","Salud y Pension","negativo");


CREATE TABLE `no_empleado` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doc` varchar(255) NOT NULL,
  `salario` varchar(255) NOT NULL,
  `pagos` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO no_empleado VALUES("1","123456789","6000","2");
INSERT INTO no_empleado VALUES("2","5566","5000","2");
INSERT INTO no_empleado VALUES("3","5555","950000","2");


CREATE TABLE `no_metodopago` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `relacion` varchar(255) NOT NULL,
  `concepto` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `dolar` varchar(255) NOT NULL,
  `tasa` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `cat` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

INSERT INTO no_metodopago VALUES("1","6","4","1950","0","0","SALIDA","NOMINA");
INSERT INTO no_metodopago VALUES("2","3","1","5000","0","0","SALIDA","PRESTAMO");
INSERT INTO no_metodopago VALUES("3","7","4","3400","0","0","SALIDA","NOMINA");
INSERT INTO no_metodopago VALUES("4","1","4","10000","0","0","SALIDA","PRESTAMO");
INSERT INTO no_metodopago VALUES("5","8","1","1850","0","0","SALIDA","NOMINA");
INSERT INTO no_metodopago VALUES("6","1","1","3000000","0","0","SALIDA","PRESTAMO");
INSERT INTO no_metodopago VALUES("7","1","4","227500","0","0","SALIDA","NOMINA");


CREATE TABLE `no_pago` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `empleado` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `mes` varchar(255) NOT NULL,
  `anno` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO no_pago VALUES("1","5555","227500","8","2015","2015-08-13","13:49:43","123456789","1");


CREATE TABLE `no_pago_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pago` varchar(255) NOT NULL,
  `concepto` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO no_pago_detalle VALUES("1","1","Salario","positivo","475000");
INSERT INTO no_pago_detalle VALUES("2","1","PRESTAMO, Prestamos Personales","negativo","262500");
INSERT INTO no_pago_detalle VALUES("3","1","Comisiones","positivo","15000");
INSERT INTO no_pago_detalle VALUES("4","1","Descuentos","negativo","0");
INSERT INTO no_pago_detalle VALUES("5","1","Salud y Pension","negativo","0");


CREATE TABLE `no_prestamo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doc` varchar(255) NOT NULL,
  `valor_prestado` varchar(255) NOT NULL,
  `valor_pagar` varchar(255) NOT NULL,
  `npagos` varchar(255) NOT NULL,
  `vpagos` varchar(255) NOT NULL,
  `interes` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  `nota` text NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO no_prestamo VALUES("1","5555","3000000","3150000","12","262500","5","2015-08-13","13:47:27","123456789","Ninguna","1","n","1");


CREATE TABLE `no_prestamo_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prestamo` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO no_prestamo_detalle VALUES("1","1","262500","2015-08-13","13:49:43","123456789");


CREATE TABLE `no_tipo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO no_tipo VALUES("1","Prestamos Personales");
INSERT INTO no_tipo VALUES("2","Prestamos por Comisiones");


CREATE TABLE `online_banco` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `cuenta` varchar(255) NOT NULL,
  `clabe` varchar(255) NOT NULL,
  `nota` text NOT NULL,
  `estado` varchar(20) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO online_banco VALUES("1","Bancoazateca","No. de Cuenta 8488484","767654","Ninguna observacion para esta cuenta bancaria","s","2015-07-16","12:21:50","123456789");
INSERT INTO online_banco VALUES("2","Coppel","No. de cuenta 39494994","45466","ninguna observacion","s","2015-07-16","12:21:36","123456789");


CREATE TABLE `online_correo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `n1` text NOT NULL,
  `n2` text NOT NULL,
  `n3` text NOT NULL,
  `n4` text NOT NULL,
  `n5` text NOT NULL,
  `n6` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO online_correo VALUES("1","parrafo 1sasas","parrafo 2asas","parrafo 3ccc","parrafo 4cdddd","parrafo 5dd","parrafo 6gggg");


CREATE TABLE `online_descuento1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `categoria` varchar(255) NOT NULL,
  `subcategoria` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `fechai` date NOT NULL,
  `fechaf` date NOT NULL,
  `estado` varchar(20) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO online_descuento1 VALUES("1","Descuento de Pruebas","grupo","1","porcentaje","5","2015-08-21","2015-09-21","s","123456789","2015-07-21","00:22:50");


CREATE TABLE `online_descuento2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `producto` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `fechai` date NOT NULL,
  `fechaf` date NOT NULL,
  `estado` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO online_descuento2 VALUES("1","Descripcion de pruebassss","12","porcentaje","7","2015-07-21","2015-07-31","s","2015-07-24","11:22:27","123456789");


CREATE TABLE `online_empresaenvio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `pagina1` varchar(255) NOT NULL,
  `pagina2` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `contacto` varchar(255) NOT NULL,
  `telefono` varchar(255) NOT NULL,
  `celular` varchar(255) NOT NULL,
  `direccion` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO online_empresaenvio VALUES("1","ESTAFETA","http://www.estafeta.com","http://www.estafeta.com/herramientas/rastreo.aspx","s","CONTACTO","TELEFONO","CELULAR","DIRECCION");
INSERT INTO online_empresaenvio VALUES("2","CORREOS DE MEXICOs","http://www.correosdemexico.gob.mx/","http://www.correosdemexico.gob.mx/ServiciosLinea/Paginas/cemsmexpost.aspx","s","Contacto de correos","telefonode correo","celular de correos de mexico","direccion complea de correos de mexico");
INSERT INTO online_empresaenvio VALUES("3","pruena nombr","pagina 1","pagina 2","s","contact","telefono","celular","direccion");


CREATE TABLE `online_envio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(25) NOT NULL,
  `factura` varchar(255) NOT NULL,
  `lista` varchar(255) NOT NULL,
  `gasto` varchar(255) NOT NULL,
  `subtotal` varchar(255) NOT NULL,
  `cliente` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `correo` varchar(255) NOT NULL,
  `dir` varchar(255) NOT NULL,
  `tel` varchar(255) NOT NULL,
  `cel` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `colonia` varchar(255) NOT NULL,
  `municipio` varchar(255) NOT NULL,
  `cp` varchar(255) NOT NULL,
  `vestado` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `fechae` date NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `inventario` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

INSERT INTO online_envio VALUES("6","ticket","5","3","95","102","58578","CLIENTE MAYOREO","dulceriajaja@hotmail.com;","SAN PEDRO","844","7584","estado de mexico","san pedro","tecamac","55477","Pedido Enviado","","2015-08-10","11:09:08","0000-00-00","1","n");
INSERT INTO online_envio VALUES("7","ticket","","3","95","8","58578","CLIENTE MAYOREO","dulceriajaja@hotmail.com;","SAN PEDRO","844","7584","estado de mexico","san pedro","tecamac","55477","Comprobante Enviado","","2015-08-12","11:38:37","0000-00-00","1","");
INSERT INTO online_envio VALUES("8","ticket","7","1","101","32","16","Infosis Piso 11","bryo@no.com","Maq Piso 11","33","554","nl","centro","mty","64000","Comprobante Enviado","","2015-08-13","13:54:34","0000-00-00","1","n");


CREATE TABLE `online_envio_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `envio` varchar(255) NOT NULL,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `um` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `costo` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `familia` varchar(255) NOT NULL,
  `grupo` varchar(255) NOT NULL,
  `subgrupo` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

INSERT INTO online_envio_detalle VALUES("13","6","7501006551068","ACT II MANTEQUILLA EXTRA","PIEZA","7","10","0","2015-08-10","14","12","13","0","1","","");
INSERT INTO online_envio_detalle VALUES("14","6","7503004600120","AVE FRESA","PIEZA","3","8","0","2015-08-10","18","16","17","0","1","","");
INSERT INTO online_envio_detalle VALUES("15","6","7501000133055","BARRITAS DE FRESA","PIEZA","1","8","0","2015-08-10","26","24","25","0","1","","");
INSERT INTO online_envio_detalle VALUES("16","7","7503004600120","AVE FRESA","PIEZA","1","8","0","2015-08-12","18","16","17","0","1","","");
INSERT INTO online_envio_detalle VALUES("17","8","7501006551068","ACT II MANTEQUILLA EXTRA","PIEZA","1","10","0","2015-08-13","14","12","13","0","1","","");
INSERT INTO online_envio_detalle VALUES("18","8","7503004600120","AVE FRESA","PIEZA","2","11","0","2015-08-13","18","16","17","0","1","","");


CREATE TABLE `online_estado` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pedido` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

INSERT INTO online_estado VALUES("10","6","2015-08-10","11:09:08","Pedido Realizado");
INSERT INTO online_estado VALUES("11","6","2015-08-10","11:09:16","Envio de Comprobante de Pago");
INSERT INTO online_estado VALUES("12","6","2015-08-11","10:23:04","Pedido Facturado y Confirmado");
INSERT INTO online_estado VALUES("13","7","2015-08-12","11:38:37","Pedido Realizado");
INSERT INTO online_estado VALUES("14","7","2015-08-12","11:39:28","Envio de Comprobante");
INSERT INTO online_estado VALUES("15","8","2015-08-13","13:54:34","Pedido Realizado");
INSERT INTO online_estado VALUES("16","8","2015-08-13","13:54:40","Envio de Comprobante");
INSERT INTO online_estado VALUES("17","8","2015-08-13","13:55:16","Pedido Facturado y Confirmado");


CREATE TABLE `online_fin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `empresa` varchar(255) NOT NULL,
  `guia` varchar(255) NOT NULL,
  `cliente` varchar(255) NOT NULL,
  `pedido` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `pagina` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO online_fin VALUES("1","2","ABC12345CD","58578","6","2015-08-11","13:58:11","http://www.correosdemexico.gob.mx/ServiciosLinea/Paginas/cemsmexpost.aspx","123456789","1");


CREATE TABLE `online_gasto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lista` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO online_gasto VALUES("1","1","101","2015-07-14","12:55:14","123456789");
INSERT INTO online_gasto VALUES("2","2","90","2015-07-14","12:44:58","123456789");
INSERT INTO online_gasto VALUES("3","3","95","2015-07-14","12:45:04","123456789");
INSERT INTO online_gasto VALUES("4","4","100","2015-07-14","12:45:07","123456789");
INSERT INTO online_gasto VALUES("5","5","106","2015-07-14","12:45:12","123456789");
INSERT INTO online_gasto VALUES("6","6","12","2015-07-14","12:45:15","123456789");


CREATE TABLE `online_imagen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pedido` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `nota_cliente` text NOT NULL,
  `nota_admin` text NOT NULL,
  `estado` varchar(255) NOT NULL,
  `banco` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO online_imagen VALUES("4","6","2015-08-10","11:09:16","","","Factura Confirmada","1");
INSERT INTO online_imagen VALUES("5","7","2015-08-12","11:39:28","","","En Revicion","1");
INSERT INTO online_imagen VALUES("6","8","2015-08-13","13:54:40","","","Factura Confirmada","1");


CREATE TABLE `online_prioridad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `producto` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `fechai` date NOT NULL,
  `fechaf` date NOT NULL,
  `estado` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `persona` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cod` varchar(255) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `dir` varchar(255) NOT NULL,
  `tel` varchar(255) NOT NULL,
  `cel` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO persona VALUES("1","123456789","JORGE VASQUEZ","TECAMACss","00","11");
INSERT INTO persona VALUES("2","5566","USUARIO DE PRUEBA","CARACOLES","6679159","3156780");
INSERT INTO persona VALUES("3","5555","Alberto C","la misma","455","6677");


CREATE TABLE `pie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sucursal` varchar(255) NOT NULL,
  `texto1` text NOT NULL,
  `texto2` text NOT NULL,
  `texto3` text NOT NULL,
  `texto4` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO pie VALUES("1","1","pie","de","pagina","jorge");


CREATE TABLE `plan_renta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `dia` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO plan_renta VALUES("2","Semana","7","s");
INSERT INTO plan_renta VALUES("3","Mes","30","s");


CREATE TABLE `pro_confi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `tabla` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=latin1;

INSERT INTO pro_confi VALUES("1","Grupo","grupo");
INSERT INTO pro_confi VALUES("2","SubGrupo","subgrupo");
INSERT INTO pro_confi VALUES("3","Familia","familia");
INSERT INTO pro_confi VALUES("4","AUDIO","grupo");
INSERT INTO pro_confi VALUES("5","AUDIFONO","subgrupo");
INSERT INTO pro_confi VALUES("6","NOKIA","familia");
INSERT INTO pro_confi VALUES("7","PARLANTES","grupo");
INSERT INTO pro_confi VALUES("8","DOBLE","subgrupo");
INSERT INTO pro_confi VALUES("9","SAMSUMG","familia");
INSERT INTO pro_confi VALUES("10","Cocina","dpto");
INSERT INTO pro_confi VALUES("11","Juegos","dpto");
INSERT INTO pro_confi VALUES("12","SAMS","grupo");
INSERT INTO pro_confi VALUES("13","PALOMITAS","subgrupo");
INSERT INTO pro_confi VALUES("14","CONAGRA","familia");
INSERT INTO pro_confi VALUES("15","Cargadas","dpto");
INSERT INTO pro_confi VALUES("16","ALTAFIBRA","grupo");
INSERT INTO pro_confi VALUES("17","PAN","subgrupo");
INSERT INTO pro_confi VALUES("18","ALTAFIBRA","familia");
INSERT INTO pro_confi VALUES("19","GAMESA","grupo");
INSERT INTO pro_confi VALUES("20","GALLETA FRESA","subgrupo");
INSERT INTO pro_confi VALUES("21","PEPSICO","familia");
INSERT INTO pro_confi VALUES("22","GALLETA PINA","subgrupo");
INSERT INTO pro_confi VALUES("23","GALLETAS VAINILLA","subgrupo");
INSERT INTO pro_confi VALUES("24","MARINELA","grupo");
INSERT INTO pro_confi VALUES("25","BARRAS DE FRESA","subgrupo");
INSERT INTO pro_confi VALUES("26","BIMBO","familia");
INSERT INTO pro_confi VALUES("27","BARRAS DE PINA","subgrupo");
INSERT INTO pro_confi VALUES("28","BIG COLA","grupo");
INSERT INTO pro_confi VALUES("29","PET 620 ML","subgrupo");
INSERT INTO pro_confi VALUES("30","BIG COLA","familia");
INSERT INTO pro_confi VALUES("31","LATA 355 ML","subgrupo");
INSERT INTO pro_confi VALUES("32","BOKADOS","grupo");
INSERT INTO pro_confi VALUES("33","PAPAS","subgrupo");
INSERT INTO pro_confi VALUES("34","ARCA CONTINENTAL","familia");
INSERT INTO pro_confi VALUES("35","BARRITA DE FRESA","subgrupo");
INSERT INTO pro_confi VALUES("36","BIMBO","grupo");
INSERT INTO pro_confi VALUES("37","BARRITA DE PINA","subgrupo");
INSERT INTO pro_confi VALUES("38","RICOLINO","grupo");
INSERT INTO pro_confi VALUES("39","DULCE","subgrupo");
INSERT INTO pro_confi VALUES("40","BARCEL","familia");
INSERT INTO pro_confi VALUES("41","CACAHUATES","grupo");
INSERT INTO pro_confi VALUES("42","CACAHUATE JAPONES","subgrupo");
INSERT INTO pro_confi VALUES("43","NIPON","familia");
INSERT INTO pro_confi VALUES("44","CACAHUATE ENCHILADO","subgrupo");
INSERT INTO pro_confi VALUES("45","MARINELA","familia");
INSERT INTO pro_confi VALUES("46","SABRITAS","grupo");
INSERT INTO pro_confi VALUES("47","CHICHARRON DE CERDO","subgrupo");
INSERT INTO pro_confi VALUES("48","LEO","grupo");
INSERT INTO pro_confi VALUES("49","ENCANTO","familia");
INSERT INTO pro_confi VALUES("50","BARCEL","grupo");
INSERT INTO pro_confi VALUES("51","CON JALAPENO","subgrupo");
INSERT INTO pro_confi VALUES("52","LALA","grupo");
INSERT INTO pro_confi VALUES("53","CHOCOLATE","subgrupo");
INSERT INTO pro_confi VALUES("54","LALA","familia");
INSERT INTO pro_confi VALUES("55","GALLETAS CHOCOLATE","subgrupo");
INSERT INTO pro_confi VALUES("56","PET 500 ML","subgrupo");
INSERT INTO pro_confi VALUES("57","ENCANTO","grupo");
INSERT INTO pro_confi VALUES("58","PET 400 ML","subgrupo");
INSERT INTO pro_confi VALUES("59","GALLETAS FRESA","subgrupo");
INSERT INTO pro_confi VALUES("60","DORITOS NACHO","subgrupo");
INSERT INTO pro_confi VALUES("61","AVENA CON GRANOLA","subgrupo");
INSERT INTO pro_confi VALUES("62","AVENA CON MANZANA Y CANELA","subgrupo");
INSERT INTO pro_confi VALUES("63","AVENA CON PASAS","subgrupo");
INSERT INTO pro_confi VALUES("64","GALLETA DE NUEZ","subgrupo");
INSERT INTO pro_confi VALUES("65","PAN","grupo");
INSERT INTO pro_confi VALUES("66","SEMILLAS","subgrupo");
INSERT INTO pro_confi VALUES("67","PASTILLAS","subgrupo");
INSERT INTO pro_confi VALUES("68","HALLS","familia");
INSERT INTO pro_confi VALUES("69","JUMEX","familia");
INSERT INTO pro_confi VALUES("70","CACAHUATE SALADO","subgrupo");
INSERT INTO pro_confi VALUES("71","EZEQUIEL GARZA VALADEZ","grupo");
INSERT INTO pro_confi VALUES("72","MARS","familia");
INSERT INTO pro_confi VALUES("73","PAY DE NUEZ","subgrupo");
INSERT INTO pro_confi VALUES("74","PAY DE PINA","subgrupo");
INSERT INTO pro_confi VALUES("75","PELONETES","familia");
INSERT INTO pro_confi VALUES("76","PET 600 ML","subgrupo");
INSERT INTO pro_confi VALUES("77","SENOR TRIGAL","grupo");
INSERT INTO pro_confi VALUES("78","SENOR TRIGAL","familia");
INSERT INTO pro_confi VALUES("79","SONRICS","familia");
INSERT INTO pro_confi VALUES("80","ROLES","grupo");
INSERT INTO pro_confi VALUES("81","CON PASAS","subgrupo");
INSERT INTO pro_confi VALUES("82","GLASEADOS","subgrupo");
INSERT INTO pro_confi VALUES("83","RUFFLES CON QUESO","subgrupo");
INSERT INTO pro_confi VALUES("84","SEMITA","subgrupo");
INSERT INTO pro_confi VALUES("85","ALMADEN","familia");
INSERT INTO pro_confi VALUES("86","FRESA","subgrupo");
INSERT INTO pro_confi VALUES("87","VAINILLA","subgrupo");
INSERT INTO pro_confi VALUES("88","CON FUEGO","subgrupo");
INSERT INTO pro_confi VALUES("89","ORIGINAL","subgrupo");
INSERT INTO pro_confi VALUES("90","TARTAS DE FRESA","subgrupo");
INSERT INTO pro_confi VALUES("91","CHICLES","subgrupo");
INSERT INTO pro_confi VALUES("92","ADAMS","familia");
INSERT INTO pro_confi VALUES("93","YOGHURT","subgrupo");
INSERT INTO pro_confi VALUES("94","X","talla");
INSERT INTO pro_confi VALUES("95","XL","talla");
INSERT INTO pro_confi VALUES("96","Blanco","color");
INSERT INTO pro_confi VALUES("97","Azul","color");
INSERT INTO pro_confi VALUES("98","Rojo","color");
INSERT INTO pro_confi VALUES("99","Negro","color");
INSERT INTO pro_confi VALUES("100","Grupo Insumo Pruebas","insumo grupo");
INSERT INTO pro_confi VALUES("101","Insumo SUb Grupo Pruebas","insumo subgrupo");
INSERT INTO pro_confi VALUES("102","Insumo Familia Pruebas","insumo familia");
INSERT INTO pro_confi VALUES("103","Kg","insumo medida");
INSERT INTO pro_confi VALUES("104","g","insumo medida");
INSERT INTO pro_confi VALUES("105","ml","insumo medida");
INSERT INTO pro_confi VALUES("106","Servicio 1 familia","servicio familia");
INSERT INTO pro_confi VALUES("107","servicio 2 familia","servicio familia");
INSERT INTO pro_confi VALUES("108","servicio 1 grupo","servicio grupo");
INSERT INTO pro_confi VALUES("109","servicio 2 grupo","servicio grupo");
INSERT INTO pro_confi VALUES("110","servicio 1 subgrupo","servicio subgrupo");
INSERT INTO pro_confi VALUES("111","servicio 2 subgrupo","servicio subgrupo");
INSERT INTO pro_confi VALUES("112","APARTADO 1","apartado");
INSERT INTO pro_confi VALUES("113","SEPARADO 2","apartado");
INSERT INTO pro_confi VALUES("114","SEPARADO 3","apartado");


CREATE TABLE `pro_kits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO pro_kits VALUES("1","Kits Unos","AZUL","2015-05-22","123456789");
INSERT INTO pro_kits VALUES("2","nuevo","AZUL","2015-05-22","123456789");
INSERT INTO pro_kits VALUES("3","prueba hoy","AMARILLO","2015-08-13","123456789");


CREATE TABLE `pro_kits_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kits` varchar(255) NOT NULL,
  `prod` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO pro_kits_detalle VALUES("1","1","12","10");
INSERT INTO pro_kits_detalle VALUES("2","1","13","5");
INSERT INTO pro_kits_detalle VALUES("3","2","13","1");
INSERT INTO pro_kits_detalle VALUES("4","3","12","1");
INSERT INTO pro_kits_detalle VALUES("5","3","13","2");


CREATE TABLE `pro_kits_precio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kits` varchar(255) NOT NULL,
  `prod` varchar(255) NOT NULL,
  `lista` varchar(255) NOT NULL,
  `val` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

INSERT INTO pro_kits_precio VALUES("1","1","12","3","500");
INSERT INTO pro_kits_precio VALUES("2","1","12","2","0");
INSERT INTO pro_kits_precio VALUES("3","1","12","1","0");
INSERT INTO pro_kits_precio VALUES("4","1","13","3","320");
INSERT INTO pro_kits_precio VALUES("5","1","13","2","300");
INSERT INTO pro_kits_precio VALUES("6","1","13","1","325");
INSERT INTO pro_kits_precio VALUES("7","2","13","3","320");
INSERT INTO pro_kits_precio VALUES("8","2","13","2","300");
INSERT INTO pro_kits_precio VALUES("9","2","13","1","325");
INSERT INTO pro_kits_precio VALUES("10","3","12","1","1");
INSERT INTO pro_kits_precio VALUES("11","3","12","2","1");
INSERT INTO pro_kits_precio VALUES("12","3","12","3","500");
INSERT INTO pro_kits_precio VALUES("13","3","12","5","1");
INSERT INTO pro_kits_precio VALUES("14","3","12","6","1");
INSERT INTO pro_kits_precio VALUES("15","3","13","6","1");
INSERT INTO pro_kits_precio VALUES("16","3","13","5","1");
INSERT INTO pro_kits_precio VALUES("17","3","13","4","1");
INSERT INTO pro_kits_precio VALUES("18","3","13","3","320");


CREATE TABLE `pro_precio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `producto` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `lista` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=733 DEFAULT CHARSET=latin1;

INSERT INTO pro_precio VALUES("1","12","120","1");
INSERT INTO pro_precio VALUES("2","13","100","1");
INSERT INTO pro_precio VALUES("3","12","120","2");
INSERT INTO pro_precio VALUES("4","13","0","2");
INSERT INTO pro_precio VALUES("5","12","120","3");
INSERT INTO pro_precio VALUES("6","13","0","3");
INSERT INTO pro_precio VALUES("7","12","120","4");
INSERT INTO pro_precio VALUES("8","13","0","4");
INSERT INTO pro_precio VALUES("9","12","120","5");
INSERT INTO pro_precio VALUES("10","13","0","5");
INSERT INTO pro_precio VALUES("11","12","120","6");
INSERT INTO pro_precio VALUES("12","13","0","6");
INSERT INTO pro_precio VALUES("109","676767","140","1");
INSERT INTO pro_precio VALUES("110","676767","150","2");
INSERT INTO pro_precio VALUES("111","676767","180","3");
INSERT INTO pro_precio VALUES("112","676767","154","4");
INSERT INTO pro_precio VALUES("113","676767","110","5");
INSERT INTO pro_precio VALUES("114","676767","140","6");
INSERT INTO pro_precio VALUES("115","5894048","250","1");
INSERT INTO pro_precio VALUES("116","5894048","250","2");
INSERT INTO pro_precio VALUES("117","5894048","280","3");
INSERT INTO pro_precio VALUES("118","5894048","180","4");
INSERT INTO pro_precio VALUES("119","5894048","230","5");
INSERT INTO pro_precio VALUES("120","5894048","250","6");
INSERT INTO pro_precio VALUES("121","23","10","1");
INSERT INTO pro_precio VALUES("122","23","10","2");
INSERT INTO pro_precio VALUES("123","23","11","3");
INSERT INTO pro_precio VALUES("124","23","12","4");
INSERT INTO pro_precio VALUES("125","23","15","5");
INSERT INTO pro_precio VALUES("126","23","9","6");
INSERT INTO pro_precio VALUES("127","9393","100","1");
INSERT INTO pro_precio VALUES("128","9393","100","2");
INSERT INTO pro_precio VALUES("129","9393","100","3");
INSERT INTO pro_precio VALUES("130","9393","100","4");
INSERT INTO pro_precio VALUES("131","9393","200","5");
INSERT INTO pro_precio VALUES("132","9393","200","6");
INSERT INTO pro_precio VALUES("133","345","100","1");
INSERT INTO pro_precio VALUES("134","345","200","2");
INSERT INTO pro_precio VALUES("135","345","300","3");
INSERT INTO pro_precio VALUES("136","345","140","4");
INSERT INTO pro_precio VALUES("137","345","110","5");
INSERT INTO pro_precio VALUES("138","345","140","6");
INSERT INTO pro_precio VALUES("139","7501006551068","10","1");
INSERT INTO pro_precio VALUES("140","7501006551068","10","2");
INSERT INTO pro_precio VALUES("141","7501006551068","10","3");
INSERT INTO pro_precio VALUES("142","7501006551068","0","4");
INSERT INTO pro_precio VALUES("143","7501006551068","0","5");
INSERT INTO pro_precio VALUES("144","7501006551068","0","6");
INSERT INTO pro_precio VALUES("145","7503004600120","11","1");
INSERT INTO pro_precio VALUES("146","7503004600120","11","2");
INSERT INTO pro_precio VALUES("147","7503004600120","8","3");
INSERT INTO pro_precio VALUES("148","7503004600120","0","4");
INSERT INTO pro_precio VALUES("149","7503004600120","0","5");
INSERT INTO pro_precio VALUES("150","7503004600120","0","6");
INSERT INTO pro_precio VALUES("151","7501761810189","9","1");
INSERT INTO pro_precio VALUES("152","7501761810189","10","2");
INSERT INTO pro_precio VALUES("153","7501761810189","9","3");
INSERT INTO pro_precio VALUES("154","7501761810189","0","4");
INSERT INTO pro_precio VALUES("155","7501761810189","0","5");
INSERT INTO pro_precio VALUES("156","7501761810189","0","6");
INSERT INTO pro_precio VALUES("157","7501761810271","9","1");
INSERT INTO pro_precio VALUES("158","7501761810271","10","2");
INSERT INTO pro_precio VALUES("159","7501761810271","9","3");
INSERT INTO pro_precio VALUES("160","7501761810271","0","4");
INSERT INTO pro_precio VALUES("161","7501761810271","0","5");
INSERT INTO pro_precio VALUES("162","7501761810271","0","6");
INSERT INTO pro_precio VALUES("163","7501000669509","10","1");
INSERT INTO pro_precio VALUES("164","7501000669509","12","2");
INSERT INTO pro_precio VALUES("165","7501000669509","10","3");
INSERT INTO pro_precio VALUES("166","7501000669509","0","4");
INSERT INTO pro_precio VALUES("167","7501000669509","0","5");
INSERT INTO pro_precio VALUES("168","7501000669509","0","6");
INSERT INTO pro_precio VALUES("169","7501000133055","9","1");
INSERT INTO pro_precio VALUES("170","7501000133055","10","2");
INSERT INTO pro_precio VALUES("171","7501000133055","8","3");
INSERT INTO pro_precio VALUES("172","7501000133055","0","4");
INSERT INTO pro_precio VALUES("173","7501000133055","0","5");
INSERT INTO pro_precio VALUES("174","7501000133055","0","6");
INSERT INTO pro_precio VALUES("175","7501000133031","9","1");
INSERT INTO pro_precio VALUES("176","7501000133031","10","2");
INSERT INTO pro_precio VALUES("177","7501000133031","8","3");
INSERT INTO pro_precio VALUES("178","7501000133031","0","4");
INSERT INTO pro_precio VALUES("179","7501000133031","0","5");
INSERT INTO pro_precio VALUES("180","7501000133031","0","6");
INSERT INTO pro_precio VALUES("181","7506241201228","7","1");
INSERT INTO pro_precio VALUES("182","7506241201228","10","2");
INSERT INTO pro_precio VALUES("183","7506241201228","7","3");
INSERT INTO pro_precio VALUES("184","7506241201228","0","4");
INSERT INTO pro_precio VALUES("185","7506241201228","0","5");
INSERT INTO pro_precio VALUES("186","7506241201228","0","6");
INSERT INTO pro_precio VALUES("187","7750670002196","6","1");
INSERT INTO pro_precio VALUES("188","7750670002196","6","2");
INSERT INTO pro_precio VALUES("189","7750670002196","6","3");
INSERT INTO pro_precio VALUES("190","7750670002196","0","4");
INSERT INTO pro_precio VALUES("191","7750670002196","0","5");
INSERT INTO pro_precio VALUES("192","7750670002196","0","6");
INSERT INTO pro_precio VALUES("193","730399003848","8.5","1");
INSERT INTO pro_precio VALUES("194","730399003848","9","2");
INSERT INTO pro_precio VALUES("195","730399003848","8","3");
INSERT INTO pro_precio VALUES("196","730399003848","0","4");
INSERT INTO pro_precio VALUES("197","730399003848","0","5");
INSERT INTO pro_precio VALUES("198","730399003848","0","6");
INSERT INTO pro_precio VALUES("199","730399004029","8.5","1");
INSERT INTO pro_precio VALUES("200","730399004029","8.5","2");
INSERT INTO pro_precio VALUES("201","730399004029","8","3");
INSERT INTO pro_precio VALUES("202","730399004029","0","4");
INSERT INTO pro_precio VALUES("203","730399004029","0","5");
INSERT INTO pro_precio VALUES("204","730399004029","0","6");
INSERT INTO pro_precio VALUES("205","730399013106","9.5","1");
INSERT INTO pro_precio VALUES("206","730399013106","10","2");
INSERT INTO pro_precio VALUES("207","730399013106","9","3");
INSERT INTO pro_precio VALUES("208","730399013106","0","4");
INSERT INTO pro_precio VALUES("209","730399013106","0","5");
INSERT INTO pro_precio VALUES("210","730399013106","0","6");
INSERT INTO pro_precio VALUES("211","7501000116447","8","1");
INSERT INTO pro_precio VALUES("212","7501000116447","10","2");
INSERT INTO pro_precio VALUES("213","7501000116447","8","3");
INSERT INTO pro_precio VALUES("214","7501000116447","0","4");
INSERT INTO pro_precio VALUES("215","7501000116447","0","5");
INSERT INTO pro_precio VALUES("216","7501000116447","0","6");
INSERT INTO pro_precio VALUES("217","7501000116430","8","1");
INSERT INTO pro_precio VALUES("218","7501000116430","10","2");
INSERT INTO pro_precio VALUES("219","7501000116430","8","3");
INSERT INTO pro_precio VALUES("220","7501000116430","0","4");
INSERT INTO pro_precio VALUES("221","7501000116430","0","5");
INSERT INTO pro_precio VALUES("222","7501000116430","0","6");
INSERT INTO pro_precio VALUES("223","7432354","7.5","1");
INSERT INTO pro_precio VALUES("224","7432354","7.5","2");
INSERT INTO pro_precio VALUES("225","7432354","7.5","3");
INSERT INTO pro_precio VALUES("226","7432354","0","4");
INSERT INTO pro_precio VALUES("227","7432354","0","5");
INSERT INTO pro_precio VALUES("228","7432354","0","6");
INSERT INTO pro_precio VALUES("229","7501016411505","8","1");
INSERT INTO pro_precio VALUES("230","7501016411505","9","2");
INSERT INTO pro_precio VALUES("231","7501016411505","8","3");
INSERT INTO pro_precio VALUES("232","7501016411505","0","4");
INSERT INTO pro_precio VALUES("233","7501016411505","0","5");
INSERT INTO pro_precio VALUES("234","7501016411505","0","6");
INSERT INTO pro_precio VALUES("235","730399001844","8.5","1");
INSERT INTO pro_precio VALUES("236","730399001844","9","2");
INSERT INTO pro_precio VALUES("237","730399001844","8","3");
INSERT INTO pro_precio VALUES("238","730399001844","0","4");
INSERT INTO pro_precio VALUES("239","730399001844","0","5");
INSERT INTO pro_precio VALUES("240","730399001844","0","6");
INSERT INTO pro_precio VALUES("241","75002220","8","1");
INSERT INTO pro_precio VALUES("242","75002220","8","2");
INSERT INTO pro_precio VALUES("243","75002220","8","3");
INSERT INTO pro_precio VALUES("244","75002220","0","4");
INSERT INTO pro_precio VALUES("245","75002220","0","5");
INSERT INTO pro_precio VALUES("246","75002220","0","6");
INSERT INTO pro_precio VALUES("247","7501011143586","8","1");
INSERT INTO pro_precio VALUES("248","7501011143586","8","2");
INSERT INTO pro_precio VALUES("249","7501011143586","8","3");
INSERT INTO pro_precio VALUES("250","7501011143586","0","4");
INSERT INTO pro_precio VALUES("251","7501011143586","0","5");
INSERT INTO pro_precio VALUES("252","7501011143586","0","6");
INSERT INTO pro_precio VALUES("253","730399018415","10","1");
INSERT INTO pro_precio VALUES("254","730399018415","9","2");
INSERT INTO pro_precio VALUES("255","730399018415","9","3");
INSERT INTO pro_precio VALUES("256","730399018415","0","4");
INSERT INTO pro_precio VALUES("257","730399018415","0","5");
INSERT INTO pro_precio VALUES("258","730399018415","0","6");
INSERT INTO pro_precio VALUES("259","39465021008","9","1");
INSERT INTO pro_precio VALUES("260","39465021008","10","2");
INSERT INTO pro_precio VALUES("261","39465021008","8","3");
INSERT INTO pro_precio VALUES("262","39465021008","0","4");
INSERT INTO pro_precio VALUES("263","39465021008","0","5");
INSERT INTO pro_precio VALUES("264","39465021008","0","6");
INSERT INTO pro_precio VALUES("265","7501000266333","11","1");
INSERT INTO pro_precio VALUES("266","7501000266333","11","2");
INSERT INTO pro_precio VALUES("267","7501000266333","10","3");
INSERT INTO pro_precio VALUES("268","7501000266333","0","4");
INSERT INTO pro_precio VALUES("269","7501000266333","0","5");
INSERT INTO pro_precio VALUES("270","7501000266333","0","6");
INSERT INTO pro_precio VALUES("271","7501020535891","9","1");
INSERT INTO pro_precio VALUES("272","7501020535891","10","2");
INSERT INTO pro_precio VALUES("273","7501020535891","8","3");
INSERT INTO pro_precio VALUES("274","7501020535891","0","4");
INSERT INTO pro_precio VALUES("275","7501020535891","0","5");
INSERT INTO pro_precio VALUES("276","7501020535891","0","6");
INSERT INTO pro_precio VALUES("277","7501000658220","8","1");
INSERT INTO pro_precio VALUES("278","7501000658220","8","2");
INSERT INTO pro_precio VALUES("279","7501000658220","8","3");
INSERT INTO pro_precio VALUES("280","7501000658220","0","4");
INSERT INTO pro_precio VALUES("281","7501000658220","0","5");
INSERT INTO pro_precio VALUES("282","7501000658220","0","6");
INSERT INTO pro_precio VALUES("283","74323078688","9","1");
INSERT INTO pro_precio VALUES("284","74323078688","10","2");
INSERT INTO pro_precio VALUES("285","74323078688","9","3");
INSERT INTO pro_precio VALUES("286","74323078688","0","4");
INSERT INTO pro_precio VALUES("287","74323078688","0","5");
INSERT INTO pro_precio VALUES("288","74323078688","0","6");
INSERT INTO pro_precio VALUES("289","75002275","11","1");
INSERT INTO pro_precio VALUES("290","75002275","12","2");
INSERT INTO pro_precio VALUES("291","75002275","11","3");
INSERT INTO pro_precio VALUES("292","75002275","0","4");
INSERT INTO pro_precio VALUES("293","75002275","0","5");
INSERT INTO pro_precio VALUES("294","75002275","0","6");
INSERT INTO pro_precio VALUES("295","7501000635306","9","1");
INSERT INTO pro_precio VALUES("296","7501000635306","10","2");
INSERT INTO pro_precio VALUES("297","7501000635306","8","3");
INSERT INTO pro_precio VALUES("298","7501000635306","0","4");
INSERT INTO pro_precio VALUES("299","7501000635306","0","5");
INSERT INTO pro_precio VALUES("300","7501000635306","0","6");
INSERT INTO pro_precio VALUES("301","7501011132283","9","1");
INSERT INTO pro_precio VALUES("302","7501011132283","9","2");
INSERT INTO pro_precio VALUES("303","7501011132283","8","3");
INSERT INTO pro_precio VALUES("304","7501011132283","0","4");
INSERT INTO pro_precio VALUES("305","7501011132283","0","5");
INSERT INTO pro_precio VALUES("306","7501011132283","0","6");
INSERT INTO pro_precio VALUES("307","75009809","9.5","1");
INSERT INTO pro_precio VALUES("308","75009809","12","2");
INSERT INTO pro_precio VALUES("309","75009809","9","3");
INSERT INTO pro_precio VALUES("310","75009809","0","4");
INSERT INTO pro_precio VALUES("311","75009809","0","5");
INSERT INTO pro_precio VALUES("312","75009809","0","6");
INSERT INTO pro_precio VALUES("313","7501055300075","9","1");
INSERT INTO pro_precio VALUES("314","7501055300075","12","2");
INSERT INTO pro_precio VALUES("315","7501055300075","9","3");
INSERT INTO pro_precio VALUES("316","7501055300075","0","4");
INSERT INTO pro_precio VALUES("317","7501055300075","0","5");
INSERT INTO pro_precio VALUES("318","7501055300075","0","6");
INSERT INTO pro_precio VALUES("319","7501055305391","9","1");
INSERT INTO pro_precio VALUES("320","7501055305391","12","2");
INSERT INTO pro_precio VALUES("321","7501055305391","9","3");
INSERT INTO pro_precio VALUES("322","7501055305391","0","4");
INSERT INTO pro_precio VALUES("323","7501055305391","0","5");
INSERT INTO pro_precio VALUES("324","7501055305391","0","6");
INSERT INTO pro_precio VALUES("325","39465011009","9","1");
INSERT INTO pro_precio VALUES("326","39465011009","10","2");
INSERT INTO pro_precio VALUES("327","39465011009","8","3");
INSERT INTO pro_precio VALUES("328","39465011009","0","4");
INSERT INTO pro_precio VALUES("329","39465011009","0","5");
INSERT INTO pro_precio VALUES("330","39465011009","0","6");
INSERT INTO pro_precio VALUES("331","7506241202102","9","1");
INSERT INTO pro_precio VALUES("332","7506241202102","9","2");
INSERT INTO pro_precio VALUES("333","7506241202102","9","3");
INSERT INTO pro_precio VALUES("334","7506241202102","0","4");
INSERT INTO pro_precio VALUES("335","7506241202102","0","5");
INSERT INTO pro_precio VALUES("336","7506241202102","0","6");
INSERT INTO pro_precio VALUES("337","7501000606566","10","1");
INSERT INTO pro_precio VALUES("338","7501000606566","10","2");
INSERT INTO pro_precio VALUES("339","7501000606566","10","3");
INSERT INTO pro_precio VALUES("340","7501000606566","0","4");
INSERT INTO pro_precio VALUES("341","7501000606566","0","5");
INSERT INTO pro_precio VALUES("342","7501000606566","0","6");
INSERT INTO pro_precio VALUES("343","7501000606580","10","1");
INSERT INTO pro_precio VALUES("344","7501000606580","10","2");
INSERT INTO pro_precio VALUES("345","7501000606580","10","3");
INSERT INTO pro_precio VALUES("346","7501000606580","0","4");
INSERT INTO pro_precio VALUES("347","7501000606580","0","5");
INSERT INTO pro_precio VALUES("348","7501000606580","0","6");
INSERT INTO pro_precio VALUES("349","7501000606573","10","1");
INSERT INTO pro_precio VALUES("350","7501000606573","10","2");
INSERT INTO pro_precio VALUES("351","7501000606573","10","3");
INSERT INTO pro_precio VALUES("352","7501000606573","0","4");
INSERT INTO pro_precio VALUES("353","7501000606573","0","5");
INSERT INTO pro_precio VALUES("354","7501000606573","0","6");
INSERT INTO pro_precio VALUES("355","7501000635245","10","1");
INSERT INTO pro_precio VALUES("356","7501000635245","10","2");
INSERT INTO pro_precio VALUES("357","7501000635245","10","3");
INSERT INTO pro_precio VALUES("358","7501000635245","0","4");
INSERT INTO pro_precio VALUES("359","7501000635245","0","5");
INSERT INTO pro_precio VALUES("360","7501000635245","0","6");
INSERT INTO pro_precio VALUES("361","730399007556","7.5","1");
INSERT INTO pro_precio VALUES("362","730399007556","8","2");
INSERT INTO pro_precio VALUES("363","730399007556","7.5","3");
INSERT INTO pro_precio VALUES("364","730399007556","0","4");
INSERT INTO pro_precio VALUES("365","730399007556","0","5");
INSERT INTO pro_precio VALUES("366","730399007556","0","6");
INSERT INTO pro_precio VALUES("367","7501000628384","8","1");
INSERT INTO pro_precio VALUES("368","7501000628384","9","2");
INSERT INTO pro_precio VALUES("369","7501000628384","8","3");
INSERT INTO pro_precio VALUES("370","7501000628384","0","4");
INSERT INTO pro_precio VALUES("371","7501000628384","0","5");
INSERT INTO pro_precio VALUES("372","7501000628384","0","6");
INSERT INTO pro_precio VALUES("373","7501011123588","9","1");
INSERT INTO pro_precio VALUES("374","7501011123588","9","2");
INSERT INTO pro_precio VALUES("375","7501011123588","9","3");
INSERT INTO pro_precio VALUES("376","7501011123588","0","4");
INSERT INTO pro_precio VALUES("377","7501011123588","0","5");
INSERT INTO pro_precio VALUES("378","7501011123588","0","6");
INSERT INTO pro_precio VALUES("379","730399012062","8.5","1");
INSERT INTO pro_precio VALUES("380","730399012062","9","2");
INSERT INTO pro_precio VALUES("381","730399012062","8","3");
INSERT INTO pro_precio VALUES("382","730399012062","0","4");
INSERT INTO pro_precio VALUES("383","730399012062","0","5");
INSERT INTO pro_precio VALUES("384","730399012062","0","6");
INSERT INTO pro_precio VALUES("385","7503004600014","11","1");
INSERT INTO pro_precio VALUES("386","7503004600014","11","2");
INSERT INTO pro_precio VALUES("387","7503004600014","10","3");
INSERT INTO pro_precio VALUES("388","7503004600014","0","4");
INSERT INTO pro_precio VALUES("389","7503004600014","0","5");
INSERT INTO pro_precio VALUES("390","7503004600014","0","6");
INSERT INTO pro_precio VALUES("391","730399003329","8.5","1");
INSERT INTO pro_precio VALUES("392","730399003329","10","2");
INSERT INTO pro_precio VALUES("393","730399003329","8","3");
INSERT INTO pro_precio VALUES("394","730399003329","0","4");
INSERT INTO pro_precio VALUES("395","730399003329","0","5");
INSERT INTO pro_precio VALUES("396","730399003329","0","6");
INSERT INTO pro_precio VALUES("397","7501011116252","9.5","1");
INSERT INTO pro_precio VALUES("398","7501011116252","10","2");
INSERT INTO pro_precio VALUES("399","7501011116252","9","3");
INSERT INTO pro_precio VALUES("400","7501011116252","0","4");
INSERT INTO pro_precio VALUES("401","7501011116252","0","5");
INSERT INTO pro_precio VALUES("402","7501011116252","0","6");
INSERT INTO pro_precio VALUES("403","7501761802344","9","1");
INSERT INTO pro_precio VALUES("404","7501761802344","10","2");
INSERT INTO pro_precio VALUES("405","7501761802344","9","3");
INSERT INTO pro_precio VALUES("406","7501761802344","0","4");
INSERT INTO pro_precio VALUES("407","7501761802344","0","5");
INSERT INTO pro_precio VALUES("408","7501761802344","0","6");
INSERT INTO pro_precio VALUES("409","7501761802351","9","1");
INSERT INTO pro_precio VALUES("410","7501761802351","10","2");
INSERT INTO pro_precio VALUES("411","7501761802351","9","3");
INSERT INTO pro_precio VALUES("412","7501761802351","0","4");
INSERT INTO pro_precio VALUES("413","7501761802351","0","5");
INSERT INTO pro_precio VALUES("414","7501761802351","0","6");
INSERT INTO pro_precio VALUES("415","7501761802337","9","1");
INSERT INTO pro_precio VALUES("416","7501761802337","10","2");
INSERT INTO pro_precio VALUES("417","7501761802337","9","3");
INSERT INTO pro_precio VALUES("418","7501761802337","0","4");
INSERT INTO pro_precio VALUES("419","7501761802337","0","5");
INSERT INTO pro_precio VALUES("420","7501761802337","0","6");
INSERT INTO pro_precio VALUES("421","7503004600144","13","1");
INSERT INTO pro_precio VALUES("422","7503004600144","13","2");
INSERT INTO pro_precio VALUES("423","7503004600144","10","3");
INSERT INTO pro_precio VALUES("424","7503004600144","0","4");
INSERT INTO pro_precio VALUES("425","7503004600144","0","5");
INSERT INTO pro_precio VALUES("426","7503004600144","0","6");
INSERT INTO pro_precio VALUES("427","7501000153107","9","1");
INSERT INTO pro_precio VALUES("428","7501000153107","10","2");
INSERT INTO pro_precio VALUES("429","7501000153107","9","3");
INSERT INTO pro_precio VALUES("430","7501000153107","0","4");
INSERT INTO pro_precio VALUES("431","7501000153107","0","5");
INSERT INTO pro_precio VALUES("432","7501000153107","0","6");
INSERT INTO pro_precio VALUES("433","730399002209","8.5","1");
INSERT INTO pro_precio VALUES("434","730399002209","9","2");
INSERT INTO pro_precio VALUES("435","730399002209","8","3");
INSERT INTO pro_precio VALUES("436","730399002209","0","4");
INSERT INTO pro_precio VALUES("437","730399002209","0","5");
INSERT INTO pro_precio VALUES("438","730399002209","0","6");
INSERT INTO pro_precio VALUES("439","730399006122","9","1");
INSERT INTO pro_precio VALUES("440","730399006122","9","2");
INSERT INTO pro_precio VALUES("441","730399006122","9","3");
INSERT INTO pro_precio VALUES("442","730399006122","0","4");
INSERT INTO pro_precio VALUES("443","730399006122","0","5");
INSERT INTO pro_precio VALUES("444","730399006122","0","6");
INSERT INTO pro_precio VALUES("445","7622210267818","8","1");
INSERT INTO pro_precio VALUES("446","7622210267818","8","2");
INSERT INTO pro_precio VALUES("447","7622210267818","7.5","3");
INSERT INTO pro_precio VALUES("448","7622210267818","0","4");
INSERT INTO pro_precio VALUES("449","7622210267818","0","5");
INSERT INTO pro_precio VALUES("450","7622210267818","0","6");
INSERT INTO pro_precio VALUES("451","730399003497","8.5","1");
INSERT INTO pro_precio VALUES("452","730399003497","10","2");
INSERT INTO pro_precio VALUES("453","730399003497","8","3");
INSERT INTO pro_precio VALUES("454","730399003497","0","4");
INSERT INTO pro_precio VALUES("455","730399003497","0","5");
INSERT INTO pro_precio VALUES("456","730399003497","0","6");
INSERT INTO pro_precio VALUES("457","7501013118056","9","1");
INSERT INTO pro_precio VALUES("458","7501013118056","10","2");
INSERT INTO pro_precio VALUES("459","7501013118056","9","3");
INSERT INTO pro_precio VALUES("460","7501013118056","0","4");
INSERT INTO pro_precio VALUES("461","7501013118056","0","5");
INSERT INTO pro_precio VALUES("462","7501013118056","0","6");
INSERT INTO pro_precio VALUES("463","7501013118032","9","1");
INSERT INTO pro_precio VALUES("464","7501013118032","10","2");
INSERT INTO pro_precio VALUES("465","7501013118032","9","3");
INSERT INTO pro_precio VALUES("466","7501013118032","0","4");
INSERT INTO pro_precio VALUES("467","7501013118032","0","5");
INSERT INTO pro_precio VALUES("468","7501013118032","0","6");
INSERT INTO pro_precio VALUES("469","7501013118193","9","1");
INSERT INTO pro_precio VALUES("470","7501013118193","10","2");
INSERT INTO pro_precio VALUES("471","7501013118193","9","3");
INSERT INTO pro_precio VALUES("472","7501013118193","0","4");
INSERT INTO pro_precio VALUES("473","7501013118193","0","5");
INSERT INTO pro_precio VALUES("474","7501013118193","0","6");
INSERT INTO pro_precio VALUES("475","7501013118117","9","1");
INSERT INTO pro_precio VALUES("476","7501013118117","10","2");
INSERT INTO pro_precio VALUES("477","7501013118117","9","3");
INSERT INTO pro_precio VALUES("478","7501013118117","0","4");
INSERT INTO pro_precio VALUES("479","7501013118117","0","5");
INSERT INTO pro_precio VALUES("480","7501013118117","0","6");
INSERT INTO pro_precio VALUES("481","7501011197794","10","1");
INSERT INTO pro_precio VALUES("482","7501011197794","10","2");
INSERT INTO pro_precio VALUES("483","7501011197794","9","3");
INSERT INTO pro_precio VALUES("484","7501011197794","0","4");
INSERT INTO pro_precio VALUES("485","7501011197794","0","5");
INSERT INTO pro_precio VALUES("486","7501011197794","0","6");
INSERT INTO pro_precio VALUES("487","74323096989","9","1");
INSERT INTO pro_precio VALUES("488","74323096989","10","2");
INSERT INTO pro_precio VALUES("489","74323096989","7.5","3");
INSERT INTO pro_precio VALUES("490","74323096989","0","4");
INSERT INTO pro_precio VALUES("491","74323096989","0","5");
INSERT INTO pro_precio VALUES("492","74323096989","0","6");
INSERT INTO pro_precio VALUES("493","7506174500450","14","1");
INSERT INTO pro_precio VALUES("494","7506174500450","15","2");
INSERT INTO pro_precio VALUES("495","7506174500450","12.5","3");
INSERT INTO pro_precio VALUES("496","7506174500450","0","4");
INSERT INTO pro_precio VALUES("497","7506174500450","0","5");
INSERT INTO pro_precio VALUES("498","7506174500450","0","6");
INSERT INTO pro_precio VALUES("499","7501000651375","8","1");
INSERT INTO pro_precio VALUES("500","7501000651375","10","2");
INSERT INTO pro_precio VALUES("501","7501000651375","8","3");
INSERT INTO pro_precio VALUES("502","7501000651375","0","4");
INSERT INTO pro_precio VALUES("503","7501000651375","0","5");
INSERT INTO pro_precio VALUES("504","7501000651375","0","6");
INSERT INTO pro_precio VALUES("505","7501031360130","7.5","1");
INSERT INTO pro_precio VALUES("506","7501031360130","10","2");
INSERT INTO pro_precio VALUES("507","7501031360130","7.5","3");
INSERT INTO pro_precio VALUES("508","7501031360130","0","4");
INSERT INTO pro_precio VALUES("509","7501031360130","0","5");
INSERT INTO pro_precio VALUES("510","7501031360130","0","6");
INSERT INTO pro_precio VALUES("511","7501031346301","7.5","1");
INSERT INTO pro_precio VALUES("512","7501031346301","10","2");
INSERT INTO pro_precio VALUES("513","7501031346301","7.5","3");
INSERT INTO pro_precio VALUES("514","7501031346301","0","4");
INSERT INTO pro_precio VALUES("515","7501031346301","0","5");
INSERT INTO pro_precio VALUES("516","7501031346301","0","6");
INSERT INTO pro_precio VALUES("517","75002244","9","1");
INSERT INTO pro_precio VALUES("518","75002244","10","2");
INSERT INTO pro_precio VALUES("519","75002244","9","3");
INSERT INTO pro_precio VALUES("520","75002244","0","4");
INSERT INTO pro_precio VALUES("521","75002244","0","5");
INSERT INTO pro_precio VALUES("522","75002244","0","6");
INSERT INTO pro_precio VALUES("523","74323077827","9","1");
INSERT INTO pro_precio VALUES("524","74323077827","10","2");
INSERT INTO pro_precio VALUES("525","74323077827","7","3");
INSERT INTO pro_precio VALUES("526","74323077827","0","4");
INSERT INTO pro_precio VALUES("527","74323077827","0","5");
INSERT INTO pro_precio VALUES("528","74323077827","0","6");
INSERT INTO pro_precio VALUES("529","7501000153541","14.5","1");
INSERT INTO pro_precio VALUES("530","7501000153541","16","2");
INSERT INTO pro_precio VALUES("531","7501000153541","13.5","3");
INSERT INTO pro_precio VALUES("532","7501000153541","0","4");
INSERT INTO pro_precio VALUES("533","7501000153541","0","5");
INSERT INTO pro_precio VALUES("534","7501000153541","0","6");
INSERT INTO pro_precio VALUES("535","7501000153503","14.5","1");
INSERT INTO pro_precio VALUES("536","7501000153503","16","2");
INSERT INTO pro_precio VALUES("537","7501000153503","13.5","3");
INSERT INTO pro_precio VALUES("538","7501000153503","0","4");
INSERT INTO pro_precio VALUES("539","7501000153503","0","5");
INSERT INTO pro_precio VALUES("540","7501000153503","0","6");
INSERT INTO pro_precio VALUES("541","719886511066","7","1");
INSERT INTO pro_precio VALUES("542","719886511066","7","2");
INSERT INTO pro_precio VALUES("543","719886511066","8","3");
INSERT INTO pro_precio VALUES("544","719886511066","0","4");
INSERT INTO pro_precio VALUES("545","719886511066","0","5");
INSERT INTO pro_precio VALUES("546","719886511066","0","6");
INSERT INTO pro_precio VALUES("547","7501031310012","9","1");
INSERT INTO pro_precio VALUES("548","7501031310012","12","2");
INSERT INTO pro_precio VALUES("549","7501031310012","9","3");
INSERT INTO pro_precio VALUES("550","7501031310012","0","4");
INSERT INTO pro_precio VALUES("551","7501031310012","0","5");
INSERT INTO pro_precio VALUES("552","7501031310012","0","6");
INSERT INTO pro_precio VALUES("553","7501037377309","7.5","1");
INSERT INTO pro_precio VALUES("554","7501037377309","7.5","2");
INSERT INTO pro_precio VALUES("555","7501037377309","7.5","3");
INSERT INTO pro_precio VALUES("556","7501037377309","0","4");
INSERT INTO pro_precio VALUES("557","7501037377309","0","5");
INSERT INTO pro_precio VALUES("558","7501037377309","0","6");
INSERT INTO pro_precio VALUES("559","7501031312306","7.5","1");
INSERT INTO pro_precio VALUES("560","7501031312306","9","2");
INSERT INTO pro_precio VALUES("561","7501031312306","7.5","3");
INSERT INTO pro_precio VALUES("562","7501031312306","0","4");
INSERT INTO pro_precio VALUES("563","7501031312306","0","5");
INSERT INTO pro_precio VALUES("564","7501031312306","0","6");
INSERT INTO pro_precio VALUES("565","7501000153800","12","1");
INSERT INTO pro_precio VALUES("566","7501000153800","14","2");
INSERT INTO pro_precio VALUES("567","7501000153800","13","3");
INSERT INTO pro_precio VALUES("568","7501000153800","0","4");
INSERT INTO pro_precio VALUES("569","7501000153800","0","5");
INSERT INTO pro_precio VALUES("570","7501000153800","0","6");
INSERT INTO pro_precio VALUES("571","7503010447023","6","1");
INSERT INTO pro_precio VALUES("572","7503010447023","6","2");
INSERT INTO pro_precio VALUES("573","7503010447023","6","3");
INSERT INTO pro_precio VALUES("574","7503010447023","0","4");
INSERT INTO pro_precio VALUES("575","7503010447023","0","5");
INSERT INTO pro_precio VALUES("576","7503010447023","0","6");
INSERT INTO pro_precio VALUES("577","7501011111028","9","1");
INSERT INTO pro_precio VALUES("578","7501011111028","10","2");
INSERT INTO pro_precio VALUES("579","7501011111028","9","3");
INSERT INTO pro_precio VALUES("580","7501011111028","0","4");
INSERT INTO pro_precio VALUES("581","7501011111028","0","5");
INSERT INTO pro_precio VALUES("582","7501011111028","0","6");
INSERT INTO pro_precio VALUES("583","730399007181","8.5","1");
INSERT INTO pro_precio VALUES("584","730399007181","9","2");
INSERT INTO pro_precio VALUES("585","730399007181","8","3");
INSERT INTO pro_precio VALUES("586","730399007181","0","4");
INSERT INTO pro_precio VALUES("587","730399007181","0","5");
INSERT INTO pro_precio VALUES("588","730399007181","0","6");
INSERT INTO pro_precio VALUES("589","7501011145566","7","1");
INSERT INTO pro_precio VALUES("590","7501011145566","7","2");
INSERT INTO pro_precio VALUES("591","7501011145566","6","3");
INSERT INTO pro_precio VALUES("592","7501011145566","0","4");
INSERT INTO pro_precio VALUES("593","7501011145566","0","5");
INSERT INTO pro_precio VALUES("594","7501011145566","0","6");
INSERT INTO pro_precio VALUES("595","7501000112128","13","1");
INSERT INTO pro_precio VALUES("596","7501000112128","14","2");
INSERT INTO pro_precio VALUES("597","7501000112128","13","3");
INSERT INTO pro_precio VALUES("598","7501000112128","0","4");
INSERT INTO pro_precio VALUES("599","7501000112128","0","5");
INSERT INTO pro_precio VALUES("600","7501000112128","0","6");
INSERT INTO pro_precio VALUES("601","7501000112166","13","1");
INSERT INTO pro_precio VALUES("602","7501000112166","14","2");
INSERT INTO pro_precio VALUES("603","7501000112166","13","3");
INSERT INTO pro_precio VALUES("604","7501000112166","0","4");
INSERT INTO pro_precio VALUES("605","7501000112166","0","5");
INSERT INTO pro_precio VALUES("606","7501000112166","0","6");
INSERT INTO pro_precio VALUES("607","7501011104099","10","1");
INSERT INTO pro_precio VALUES("608","7501011104099","10.5","2");
INSERT INTO pro_precio VALUES("609","7501011104099","10","3");
INSERT INTO pro_precio VALUES("610","7501011104099","0","4");
INSERT INTO pro_precio VALUES("611","7501011104099","0","5");
INSERT INTO pro_precio VALUES("612","7501011104099","0","6");
INSERT INTO pro_precio VALUES("613","7501761834840","8","1");
INSERT INTO pro_precio VALUES("614","7501761834840","10","2");
INSERT INTO pro_precio VALUES("615","7501761834840","8","3");
INSERT INTO pro_precio VALUES("616","7501761834840","0","4");
INSERT INTO pro_precio VALUES("617","7501761834840","0","5");
INSERT INTO pro_precio VALUES("618","7501761834840","0","6");
INSERT INTO pro_precio VALUES("619","730399002100","8.5","1");
INSERT INTO pro_precio VALUES("620","730399002100","9","2");
INSERT INTO pro_precio VALUES("621","730399002100","8","3");
INSERT INTO pro_precio VALUES("622","730399002100","0","4");
INSERT INTO pro_precio VALUES("623","730399002100","0","5");
INSERT INTO pro_precio VALUES("624","730399002100","0","6");
INSERT INTO pro_precio VALUES("625","7503003399025","16","1");
INSERT INTO pro_precio VALUES("626","7503003399025","20","2");
INSERT INTO pro_precio VALUES("627","7503003399025","13","3");
INSERT INTO pro_precio VALUES("628","7503003399025","0","4");
INSERT INTO pro_precio VALUES("629","7503003399025","0","5");
INSERT INTO pro_precio VALUES("630","7503003399025","0","6");
INSERT INTO pro_precio VALUES("631","7501000601776","10","1");
INSERT INTO pro_precio VALUES("632","7501000601776","11","2");
INSERT INTO pro_precio VALUES("633","7501000601776","10","3");
INSERT INTO pro_precio VALUES("634","7501000601776","0","4");
INSERT INTO pro_precio VALUES("635","7501000601776","0","5");
INSERT INTO pro_precio VALUES("636","7501000601776","0","6");
INSERT INTO pro_precio VALUES("637","7501031323302","7.5","1");
INSERT INTO pro_precio VALUES("638","7501031323302","10","2");
INSERT INTO pro_precio VALUES("639","7501031323302","7.5","3");
INSERT INTO pro_precio VALUES("640","7501031323302","0","4");
INSERT INTO pro_precio VALUES("641","7501031323302","0","5");
INSERT INTO pro_precio VALUES("642","7501031323302","0","6");
INSERT INTO pro_precio VALUES("643","7506174500207","14","1");
INSERT INTO pro_precio VALUES("644","7506174500207","15","2");
INSERT INTO pro_precio VALUES("645","7506174500207","12.5","3");
INSERT INTO pro_precio VALUES("646","7506174500207","0","4");
INSERT INTO pro_precio VALUES("647","7506174500207","0","5");
INSERT INTO pro_precio VALUES("648","7506174500207","0","6");
INSERT INTO pro_precio VALUES("649","730399003237","8.5","1");
INSERT INTO pro_precio VALUES("650","730399003237","9","2");
INSERT INTO pro_precio VALUES("651","730399003237","8","3");
INSERT INTO pro_precio VALUES("652","730399003237","0","4");
INSERT INTO pro_precio VALUES("653","730399003237","0","5");
INSERT INTO pro_precio VALUES("654","730399003237","0","6");
INSERT INTO pro_precio VALUES("655","7501000156214","12.5","1");
INSERT INTO pro_precio VALUES("656","7501000156214","14","2");
INSERT INTO pro_precio VALUES("657","7501000156214","12","3");
INSERT INTO pro_precio VALUES("658","7501000156214","0","4");
INSERT INTO pro_precio VALUES("659","7501000156214","0","5");
INSERT INTO pro_precio VALUES("660","7501000156214","0","6");
INSERT INTO pro_precio VALUES("661","7501000153374","12.5","1");
INSERT INTO pro_precio VALUES("662","7501000153374","14","2");
INSERT INTO pro_precio VALUES("663","7501000153374","12","3");
INSERT INTO pro_precio VALUES("664","7501000153374","0","4");
INSERT INTO pro_precio VALUES("665","7501000153374","0","5");
INSERT INTO pro_precio VALUES("666","7501000153374","0","6");
INSERT INTO pro_precio VALUES("667","7501000153282","12.5","1");
INSERT INTO pro_precio VALUES("668","7501000153282","14","2");
INSERT INTO pro_precio VALUES("669","7501000153282","12","3");
INSERT INTO pro_precio VALUES("670","7501000153282","0","4");
INSERT INTO pro_precio VALUES("671","7501000153282","0","5");
INSERT INTO pro_precio VALUES("672","7501000153282","0","6");
INSERT INTO pro_precio VALUES("673","7501030424536","10","1");
INSERT INTO pro_precio VALUES("674","7501030424536","10","2");
INSERT INTO pro_precio VALUES("675","7501030424536","9","3");
INSERT INTO pro_precio VALUES("676","7501030424536","0","4");
INSERT INTO pro_precio VALUES("677","7501030424536","0","5");
INSERT INTO pro_precio VALUES("678","7501030424536","0","6");
INSERT INTO pro_precio VALUES("679","7501000164370","10","1");
INSERT INTO pro_precio VALUES("680","7501000164370","10","2");
INSERT INTO pro_precio VALUES("681","7501000164370","9","3");
INSERT INTO pro_precio VALUES("682","7501000164370","0","4");
INSERT INTO pro_precio VALUES("683","7501000164370","0","5");
INSERT INTO pro_precio VALUES("684","7501000164370","0","6");
INSERT INTO pro_precio VALUES("685","7503010447030","10","1");
INSERT INTO pro_precio VALUES("686","7503010447030","10","2");
INSERT INTO pro_precio VALUES("687","7503010447030","10","3");
INSERT INTO pro_precio VALUES("688","7503010447030","0","4");
INSERT INTO pro_precio VALUES("689","7503010447030","0","5");
INSERT INTO pro_precio VALUES("690","7503010447030","0","6");
INSERT INTO pro_precio VALUES("691","7501000657636","10","1");
INSERT INTO pro_precio VALUES("692","7501000657636","10","2");
INSERT INTO pro_precio VALUES("693","7501000657636","8","3");
INSERT INTO pro_precio VALUES("694","7501000657636","0","4");
INSERT INTO pro_precio VALUES("695","7501000657636","0","5");
INSERT INTO pro_precio VALUES("696","7501000657636","0","6");
INSERT INTO pro_precio VALUES("697","604722005154","9","1");
INSERT INTO pro_precio VALUES("698","604722005154","10","2");
INSERT INTO pro_precio VALUES("699","604722005154","9","3");
INSERT INTO pro_precio VALUES("700","604722005154","0","4");
INSERT INTO pro_precio VALUES("701","604722005154","0","5");
INSERT INTO pro_precio VALUES("702","604722005154","0","6");
INSERT INTO pro_precio VALUES("703","7501011127012","10.5","1");
INSERT INTO pro_precio VALUES("704","7501011127012","11","2");
INSERT INTO pro_precio VALUES("705","7501011127012","10","3");
INSERT INTO pro_precio VALUES("706","7501011127012","0","4");
INSERT INTO pro_precio VALUES("707","7501011127012","0","5");
INSERT INTO pro_precio VALUES("708","7501011127012","0","6");
INSERT INTO pro_precio VALUES("709","7501056901882","8","1");
INSERT INTO pro_precio VALUES("710","7501056901882","12","2");
INSERT INTO pro_precio VALUES("711","7501056901882","7","3");
INSERT INTO pro_precio VALUES("712","7501056901882","0","4");
INSERT INTO pro_precio VALUES("713","7501056901882","0","5");
INSERT INTO pro_precio VALUES("714","7501056901882","0","6");
INSERT INTO pro_precio VALUES("715","7501000628933","12","1");
INSERT INTO pro_precio VALUES("716","7501000628933","14","2");
INSERT INTO pro_precio VALUES("717","7501000628933","12","3");
INSERT INTO pro_precio VALUES("718","7501000628933","0","4");
INSERT INTO pro_precio VALUES("719","7501000628933","0","5");
INSERT INTO pro_precio VALUES("720","7501000628933","0","6");
INSERT INTO pro_precio VALUES("721","7501000628940","12","1");
INSERT INTO pro_precio VALUES("722","7501000628940","14","2");
INSERT INTO pro_precio VALUES("723","7501000628940","12","3");
INSERT INTO pro_precio VALUES("724","7501000628940","0","4");
INSERT INTO pro_precio VALUES("725","7501000628940","0","5");
INSERT INTO pro_precio VALUES("726","7501000628940","0","6");
INSERT INTO pro_precio VALUES("727","7501020539400","9","1");
INSERT INTO pro_precio VALUES("728","7501020539400","12","2");
INSERT INTO pro_precio VALUES("729","7501020539400","9","3");
INSERT INTO pro_precio VALUES("730","7501020539400","0","4");
INSERT INTO pro_precio VALUES("731","7501020539400","0","5");
INSERT INTO pro_precio VALUES("732","7501020539400","0","6");


CREATE TABLE `producto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `um` varchar(255) NOT NULL,
  `costo` varchar(255) NOT NULL,
  `maximo` varchar(255) NOT NULL,
  `minimo` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `grupo` varchar(255) NOT NULL,
  `subgrupo` varchar(255) NOT NULL,
  `familia` varchar(255) NOT NULL,
  `dpto` varchar(255) NOT NULL,
  `inv` varchar(10) NOT NULL,
  `nota` text NOT NULL,
  `talla` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;

INSERT INTO producto VALUES("1","12","Producto de Prueba","Unidad","20","100","10","s","1","5","92","10","SI","Es un hecho establecido hace demasiado tiempo que un lector se distraer&Atilde;??&Atilde;?&Acirc;&iexcl; con el contenido del texto de un sitio mientras que mira su dise&Atilde;??&Atilde;?&Acirc;&plusmn;o. El punto de usar Lorem Ipsum es que tiene una distribuci&Atilde;??&Atilde;?&Acirc;&sup3;n m&Atilde;??&Atilde;?&Acirc;&iexcl;s o menos normal de las letras","","");
INSERT INTO producto VALUES("2","13","Producto de Prueba dos","Unidad","200","200","10","s","1","2","3","10","SI","Es un hecho establecido hace demasiado tiempo que un lector se distraer&Atilde;&iexcl; con el contenido del texto de un sitio mientras que mira su dise&Atilde;&plusmn;o. El punto de usar Lorem Ipsum es que tiene una distribuci&Atilde;&sup3;n m&Atilde;&iexcl;s o menos normal de las letras","","");
INSERT INTO producto VALUES("3","676767","PRODUCTO ENTRANTE","Unidad","90","100","200","s","4","5","6","10","SI","Es un hecho establecido hace demasiado tiempo que un lector se distraerá con el contenido del texto de un sitio mientras que mira su diseño. El punto de usar Lorem Ipsum es que tiene una distribución más o menos normal de las letras","","");
INSERT INTO producto VALUES("4","5894048","PARLANTES","Unidad","120","200","400","s","7","8","9","10","SI","Es un hecho establecido hace demasiado tiempo que un lector se distraerá con el contenido del texto de un sitio mientras que mira su diseño. El punto de usar Lorem Ipsum es que tiene una distribución más o menos normal de las letras","","");
INSERT INTO producto VALUES("5","23","COCACOLA","Unidad","5","500","100","s","7","5","6","10","SI","Es un hecho establecido hace demasiado tiempo que un lector se distraerá con el contenido del texto de un sitio mientras que mira su diseño. El punto de usar Lorem Ipsum es que tiene una distribución más o menos normal de las letras","","");
INSERT INTO producto VALUES("6","9393","GALLETAS","Unidad","0","200","100","s","4","5","3","10","SI","Es un hecho establecido hace demasiado tiempo que un lector se distraerá con el contenido del texto de un sitio mientras que mira su diseño. El punto de usar Lorem Ipsum es que tiene una distribución más o menos normal de las letras","","");
INSERT INTO producto VALUES("7","345","LIBROS DE JOVENES","Unidad","300","3","2","s","4","5","3","10","SI","libro descripcion unica para el ejemplo de este modulo de ventas online libro descripcion unica para el ejemplo de este modulo de ventas online libro descripcion unica para el ejemplo de este modulo de ventas online libro descripcion unica para el ejemplo de este modulo de ventas online libro descripcion unica para el ejemplo de este modulo de ventas online libro descripcion unica para el ejemplo de este modulo de ventas online libro descripcion unica para el ejemplo de este modulo de ventas online libro descripcion unica para el ejemplo de este modulo de ventas online libro descripcion unica para el ejemplo de este modulo de ventas online libro descripcion unica para el ejemplo de este modulo de ventas online libro descripcion unica para el ejemplo de este modulo de ventas online","","");
INSERT INTO producto VALUES("8","7501006551068","ACT II MANTEQUILLA EXTRA","PIEZA","6.03","10","100","s","12","13","14","15","SI","","","");
INSERT INTO producto VALUES("9","7503004600120","AVE FRESA","PIEZA","7.02","5","5","s","16","17","18","15","SI","","","");
INSERT INTO producto VALUES("10","7501761810189","BARRAS DE AVENA Y TRIGO FRESA","PIEZA","5.49","40","150","s","19","20","21","15","SI","","","");
INSERT INTO producto VALUES("11","7501761810271","BARRAS DE AVENA Y TRIGO PINA","PIEZA","5.49","40","150","s","19","22","21","15","SI","","","");
INSERT INTO producto VALUES("12","7501000669509","BARRAS DE COCO","PIEZA","7.06","15","150","s","19","23","21","15","SI","","","");
INSERT INTO producto VALUES("13","7501000133055","BARRITAS DE FRESA","PIEZA","6.75","10","60","s","24","25","26","15","SI","","","");
INSERT INTO producto VALUES("14","7501000133031","BARRITAS DE PINA","PIEZA","6.75","10","60","s","24","27","26","15","SI","","","");
INSERT INTO producto VALUES("15","7506241201228","BIG AGUA","PIEZA","2.3","48","360","s","28","29","30","15","SI","","","");
INSERT INTO producto VALUES("16","7750670002196","BIG COLA LATA","PIEZA","3.16","132","1400","s","28","31","30","15","SI","","","");
INSERT INTO producto VALUES("17","730399003848","BOKACHITOS","PIEZA","3.04","35","150","s","32","33","34","15","SI","","","");
INSERT INTO producto VALUES("18","730399004029","BOKADITAS","PIEZA","4.72","25","200","s","32","33","34","15","SI","","","");
INSERT INTO producto VALUES("19","730399013106","BOKAMIX","PIEZA","5.3","35","150","s","32","33","34","15","SI","","","");
INSERT INTO producto VALUES("20","7501000116447","BRAN FRUT FRESA","PIEZA","3.47","12","100","s","24","35","26","15","SI","","","");
INSERT INTO producto VALUES("21","7501000116430","BRAN FRUT PINA","PIEZA","3.47","12","100","s","36","37","26","15","SI","","","");
INSERT INTO producto VALUES("22","7432354","BUBULUBU","PIEZA","4.68","15","100","s","38","39","40","15","SI","","","");
INSERT INTO producto VALUES("23","7501016411505","CACAHUATE NIPON","PIEZA","3.2","20","140","s","41","42","43","15","SI","","","");
INSERT INTO producto VALUES("24","730399001844","CACAHUATES ENCHILADOS","PIEZA","4.4","20","140","s","32","44","34","15","SI","","","");
INSERT INTO producto VALUES("25","75002220","CANELITAS","PIEZA","3","15","150","s","12","23","45","15","SI","","","");
INSERT INTO producto VALUES("26","7501011143586","CHEETOS","PIEZA","4.88","35","150","s","46","33","21","15","SI","","","");
INSERT INTO producto VALUES("27","730399018415","CHICHARRON DE CERDO","PIEZA","5.36","15","200","s","32","47","34","15","SI","","","");
INSERT INTO producto VALUES("28","39465021008","CHICHOS","PIEZA","5.69","25","150","s","48","33","49","15","SI","","","");
INSERT INTO producto VALUES("29","7501000266333","CHIPS JALAPENOS","PIEZA","7.76","35","100","s","50","51","40","15","SI","","","");
INSERT INTO producto VALUES("30","7501020535891","CHOCOLALA","PIEZA","6","12","50","s","52","53","54","15","SI","","","");
INSERT INTO producto VALUES("31","7501000658220","CHOCOLATINES","PIEZA","4.7","35","200","s","19","55","21","15","SI","","","");
INSERT INTO producto VALUES("32","74323078688","CHOCORETAS","PIEZA","5.46","30","200","s","38","39","40","15","SI","","","");
INSERT INTO producto VALUES("33","75002275","CHOCORROLES","PIEZA","8.1","6","20","s","24","17","26","15","SI","","","");
INSERT INTO producto VALUES("34","7501000635306","CHOKIS","PIEZA","6.28","30","150","s","19","55","21","15","SI","","","");
INSERT INTO producto VALUES("35","7501011132283","CHURRUMAIZ","PIEZA","4.07","35","150","s","46","33","21","15","SI","","","");
INSERT INTO producto VALUES("36","75009809","COCA COLA 500 ML","PIEZA","8.09","48","144","s","12","56","34","15","SI","","","");
INSERT INTO producto VALUES("37","7501055300075","COCA COLA LATA","PIEZA","7.6","96","360","s","12","31","34","15","SI","","","");
INSERT INTO producto VALUES("38","7501055305391","COCA COLA LIGHT LATA","PIEZA","7.4","24","360","s","12","31","34","15","SI","","","");
INSERT INTO producto VALUES("39","39465011009","CONCHITAS","PIEZA","5.69","35","150","s","57","33","49","15","SI","","","");
INSERT INTO producto VALUES("40","7506241202102","COOL TEA","PIEZA","4.83","48","144","s","28","58","30","15","SI","","","");
INSERT INTO producto VALUES("41","7501000606566","CREMAX CHOCOLATE","PIEZA","6.28","10","100","s","19","55","21","15","SI","","","");
INSERT INTO producto VALUES("42","7501000606580","CREMAX FRESA","PIEZA","6.28","10","100","s","19","59","21","15","SI","","","");
INSERT INTO producto VALUES("43","7501000606573","CREMAX VAINILLA","PIEZA","6.28","10","100","s","19","23","21","15","SI","","","");
INSERT INTO producto VALUES("44","7501000635245","DELICIAS","PIEZA","7.06","15","150","s","19","23","21","15","SI","","","");
INSERT INTO producto VALUES("45","730399007556","DIPAZOS","PIEZA","2.56","25","200","s","32","33","34","15","SI","","","");
INSERT INTO producto VALUES("46","7501000628384","DORADAS","PIEZA","4.7","15","150","s","19","23","21","15","SI","","","");
INSERT INTO producto VALUES("47","7501011123588","DORITOS","PIEZA","6.5","25","200","s","46","60","21","15","SI","","","");
INSERT INTO producto VALUES("48","730399012062","ENREDOS","PIEZA","4.72","35","150","s","46","33","34","15","SI","","","");
INSERT INTO producto VALUES("49","7503004600014","FLAXY","PIEZA","7.02","5","5","s","16","17","18","15","SI","","","");
INSERT INTO producto VALUES("50","730399003329","FRIKOS FUEGO","PIEZA","4.72","35","150","s","32","33","34","15","SI","","","");
INSERT INTO producto VALUES("51","7501011116252","FRITOS","PIEZA","5.7","35","150","s","46","33","21","15","SI","","","");
INSERT INTO producto VALUES("52","7501761802344","GALLETAS DE AVENA GRANOLA","PIEZA","5.49","30","250","s","19","61","21","15","SI","","","");
INSERT INTO producto VALUES("53","7501761802351","GALLETAS DE AVENA MANZANA Y CANELA","PIEZA","5.49","30","250","s","19","62","21","15","SI","","","");
INSERT INTO producto VALUES("54","7501761802337","GALLETAS DE AVENA PASAS","PIEZA","5.49","30","250","s","19","63","21","15","SI","","","");
INSERT INTO producto VALUES("55","7503004600144","GALLETAS DE NUEZ","PIEZA","9.18","5","5","s","16","64","18","15","SI","","","");
INSERT INTO producto VALUES("56","7501000153107","GANSITO","PIEZA","5.7","5","30","s","65","17","26","15","SI","","","");
INSERT INTO producto VALUES("57","730399002209","GIRASOLITO SEMILLAS","PIEZA","4.4","25","150","s","32","66","34","15","SI","","","");
INSERT INTO producto VALUES("58","730399006122","GOLOS","PIEZA","5.36","25","150","s","32","39","34","15","SI","","","");
INSERT INTO producto VALUES("59","7622210267818","HALLS","PIEZA","3.92","18","180","s","12","67","68","15","SI","","","");
INSERT INTO producto VALUES("60","730399003497","HUEKOS","PIEZA","5.12","35","150","s","32","33","34","15","SI","","","");
INSERT INTO producto VALUES("61","7501013118056","JUMEX DURAZNO","PIEZA","6.5","36","180","s","12","31","69","15","SI","","","");
INSERT INTO producto VALUES("62","7501013118032","JUMEX MANGO","PIEZA","6.5","36","180","s","12","31","69","15","SI","","","");
INSERT INTO producto VALUES("63","7501013118193","JUMEX MANZANA","PIEZA","6.5","36","180","s","12","31","69","15","SI","","","");
INSERT INTO producto VALUES("64","7501013118117","JUMEX PINA","PIEZA","6.5","36","180","s","12","31","69","15","SI","","","");
INSERT INTO producto VALUES("65","7501011197794","KKWATES SALADOS","PIEZA","5.4","30","200","s","50","70","21","15","SI","","","");
INSERT INTO producto VALUES("67","7506174500450","M&amp;M&Acirc;&acute;S","PIEZA","7.16","40","200","s","71","39","72","15","SI","","","");
INSERT INTO producto VALUES("68","7501000651375","MAMUT","PIEZA","3.93","15","150","s","19","55","21","15","SI","","","");
INSERT INTO producto VALUES("69","7501031360130","MANZANITA SOL","PIEZA","5.2","96","360","s","12","31","21","15","SI","","","");
INSERT INTO producto VALUES("70","7501031346301","MIRINDA","PIEZA","5.2","96","360","s","12","31","21","15","SI","","","");
INSERT INTO producto VALUES("71","75002244","NAPOLITANO","PIEZA","6.48","5","30","s","65","17","26","15","SI","","","");
INSERT INTO producto VALUES("72","74323077827","PANDITAS","PIEZA","4.69","10","100","s","38","39","40","15","SI","","","");
INSERT INTO producto VALUES("73","7501000153541","PAY DE NUEZ","PIEZA","11.34","5","50","s","24","73","26","15","SI","","","");
INSERT INTO producto VALUES("74","7501000153503","PAY DE PINA","PIEZA","11.34","5","50","s","24","74","26","15","SI","","","");
INSERT INTO producto VALUES("75","719886511066","PELON PELONETE","PIEZA","3.4","18","100","s","12","39","75","15","SI","","","");
INSERT INTO producto VALUES("76","7501031310012","PEPSI COLA 600 ML","PIEZA","5.57","300","1800","s","12","76","21","15","SI","","","");
INSERT INTO producto VALUES("77","7501037377309","PEPSI COLA LATA","PIEZA","4.75","120","1200","s","12","31","21","15","SI","","","");
INSERT INTO producto VALUES("78","7501031312306","PEPSI LIGHT LATA","PIEZA","4.36","120","240","s","12","31","21","15","SI","","","");
INSERT INTO producto VALUES("79","7501000153800","PINGUINOS","PIEZA","8","5","35","s","24","17","26","15","SI","","","");
INSERT INTO producto VALUES("80","7503010447023","POLVORONES","PIEZA","2.7","20","200","s","77","17","78","15","SI","","","");
INSERT INTO producto VALUES("81","7501011111028","RANCHERITOS","PIEZA","4.88","35","150","s","46","33","21","15","SI","","","");
INSERT INTO producto VALUES("82","730399007181","RIZADAS","PIEZA","4.72","35","150","s","32","33","34","15","SI","","","");
INSERT INTO producto VALUES("83","7501011145566","ROCKALETA","PIEZA","2.44","18","100","s","12","39","79","15","SI","","","");
INSERT INTO producto VALUES("84","7501000112128","ROLES DE CANELA CON PASAS","PIEZA","9.84","4","15","s","80","81","26","15","SI","","","");
INSERT INTO producto VALUES("85","7501000112166","ROLES DE CANELA GLASEADOS","PIEZA","9.84","4","15","s","80","82","26","15","SI","","","");
INSERT INTO producto VALUES("86","7501011104099","RUFFLES","PIEZA","7.32","25","200","s","46","83","21","15","SI","","","");
INSERT INTO producto VALUES("87","7501761834840","SANDWICH","PIEZA","4.82","15","150","s","19","59","21","15","SI","","","");
INSERT INTO producto VALUES("88","730399002100","SEMILLAS DE CALABAZA","PIEZA","4.4","25","150","s","32","66","34","15","SI","","","");
INSERT INTO producto VALUES("89","7503003399025","SEMITA","PIEZA","7","30","300","s","65","84","85","15","SI","","","");
INSERT INTO producto VALUES("90","7501000601776","SENZO","PIEZA","7.06","30","250","s","19","55","21","15","SI","","","");
INSERT INTO producto VALUES("91","7501031323302","SEVEN UP","PIEZA","5.2","96","360","s","12","31","21","15","SI","","","");
INSERT INTO producto VALUES("92","7506174500207","SNICKERS","PIEZA","6.77","40","150","s","71","39","72","15","SI","","","");
INSERT INTO producto VALUES("93","730399003237","STRIPS","PIEZA","4.72","25","200","s","32","33","34","15","SI","","","");
INSERT INTO producto VALUES("94","7501000156214","SUBMARINOS CHOCOLATE","PIEZA","9.72","6","25","s","24","53","26","15","SI","","","");
INSERT INTO producto VALUES("95","7501000153374","SUBMARINOS FRESA","PIEZA","9.72","6","25","s","24","86","26","15","SI","","","");
INSERT INTO producto VALUES("96","7501000153282","SUBMARINOS VAINILLA","PIEZA","9.72","6","25","s","24","87","26","15","SI","","","");
INSERT INTO producto VALUES("97","7501030424536","TAKIS FUEGO","PIEZA","5.89","35","100","s","50","88","40","15","SI","","","");
INSERT INTO producto VALUES("98","7501000164370","TAKIS ORIGINAL","PIEZA","5.89","35","100","s","50","89","40","15","SI","","","");
INSERT INTO producto VALUES("99","7503010447030","TAMAL","PIEZA","4.6","35","150","s","77","17","78","15","SI","","","");
INSERT INTO producto VALUES("100","7501000657636","TARTAS","PIEZA","6.44","30","250","s","19","90","21","15","SI","","","");
INSERT INTO producto VALUES("101","604722005154","TOSTILEO","PIEZA","5.69","35","150","s","48","33","49","15","SI","","","");
INSERT INTO producto VALUES("102","7501011127012","TOSTITOS","PIEZA","7.48","20","150","s","46","33","21","15","SI","","","");
INSERT INTO producto VALUES("103","7501056901882","TRIDENT XTRACARE","PIEZA","4.39","12","120","s","12","91","92","15","SI","","","");
INSERT INTO producto VALUES("104","7501000628933","VUALA CHOCOLATE","PIEZA","7.91","10","50","s","19","53","21","15","SI","","","");
INSERT INTO producto VALUES("105","7501000628940","VUALA VAINILLA","PIEZA","7.91","10","50","s","19","87","21","15","SI","","","");
INSERT INTO producto VALUES("106","7501020539400","YOGHURT LALA","PIEZA","5.5","12","50","s","52","93","54","15","SI","","","");


CREATE TABLE `producto_desactivado` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `um` varchar(255) NOT NULL,
  `costo` varchar(255) NOT NULL,
  `maximo` varchar(255) NOT NULL,
  `minimo` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `grupo` varchar(255) NOT NULL,
  `subgrupo` varchar(255) NOT NULL,
  `familia` varchar(255) NOT NULL,
  `dpto` varchar(255) NOT NULL,
  `inv` varchar(10) NOT NULL,
  `nota` text NOT NULL,
  `talla` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `programar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `fechai` date NOT NULL,
  `fechaf` date NOT NULL,
  `valor` varchar(255) NOT NULL,
  `categoria` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO programar VALUES("1","Descuento de Pruebas","2015-05-01","2015-05-12","5","3","123456789");


CREATE TABLE `prov_tipo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO prov_tipo VALUES("1","Tipo de Proveedor");


CREATE TABLE `proveedor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `contacto` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `rfc` varchar(255) NOT NULL,
  `dir` varchar(255) NOT NULL,
  `calle` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `tel` varchar(255) NOT NULL,
  `cel` varchar(255) NOT NULL,
  `colonia` varchar(255) NOT NULL,
  `municipio` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `cp` varchar(255) NOT NULL,
  `nota` text NOT NULL,
  `lcredito` varchar(255) NOT NULL,
  `dcredito` varchar(255) NOT NULL,
  `saldo` varchar(255) NOT NULL,
  `correo` varchar(255) NOT NULL,
  `metodopago` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO proveedor VALUES("1","12333","NOMBREDEL PROVEEDOR","CONTACTO","1","RFC","DIRECCION","ENTRE CALLE","2015-03-02","TELEFONO","CELULAR","COLONOA","MINICIPI","ESTADO","12345","OBS","10000","45","0","CORREO@GMAIL.COM","1");
INSERT INTO proveedor VALUES("2","67584","umbrella","jorge","prueba","rf648hd","centro","diagonal","2015-06-25","67489","848393","morelos","tecamac","mexico","556644","ninguna","40000","2","0","umbre@gmail.com","2");


CREATE TABLE `res_co_cargo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `concepto` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `compra` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `res_co_concepto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `compra` varchar(255) NOT NULL,
  `concepto` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `dolar` varchar(255) NOT NULL,
  `tasa` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

INSERT INTO res_co_concepto VALUES("1","1","CXP","100","0","15");
INSERT INTO res_co_concepto VALUES("2","1","1","91.90","0","15");
INSERT INTO res_co_concepto VALUES("3","2","CXP","279","0","15");
INSERT INTO res_co_concepto VALUES("4","2","1","200.75","0","15");
INSERT INTO res_co_concepto VALUES("5","3","1","383.8","0","15");
INSERT INTO res_co_concepto VALUES("6","4","1","575.7","0","15");
INSERT INTO res_co_concepto VALUES("7","5","4","767.6","0","15");


CREATE TABLE `res_co_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `compra` varchar(255) NOT NULL,
  `pro` varchar(255) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `recibido` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

INSERT INTO res_co_detalle VALUES("1","2","100","Salsa de Tomate","5","5","101","COMPRA","2015-10-29","09:56:50","1","123456789","");
INSERT INTO res_co_detalle VALUES("2","3","100","Salsa de Tomate","4","0","101","COMPRA","2015-10-29","11:52:19","1","123456789","");
INSERT INTO res_co_detalle VALUES("3","4","100","Salsa de Tomate","6","5","101","COMPRA","2015-10-29","13:40:30","1","123456789","");
INSERT INTO res_co_detalle VALUES("4","5","100","Salsa de Tomate","8","8","101","COMPRA","2015-10-29","13:41:33","1","123456789","");


CREATE TABLE `res_co_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entregada` varchar(10) NOT NULL,
  `fentregada` date NOT NULL,
  `hentregada` time NOT NULL,
  `uentregada` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  `fechae` date NOT NULL,
  `destino` varchar(255) NOT NULL,
  `contado` varchar(255) NOT NULL,
  `credito` varchar(255) NOT NULL,
  `neto` varchar(255) NOT NULL,
  `cod_prov` varchar(255) NOT NULL,
  `referencia` varchar(255) NOT NULL,
  `envio` varchar(255) NOT NULL,
  `des_anticipo` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `id_sucursal` varchar(10) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `nom_ven` varchar(255) NOT NULL,
  `nom_prov` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `municipio` varchar(255) NOT NULL,
  `tel` varchar(255) NOT NULL,
  `calle` varchar(255) NOT NULL,
  `contacto` varchar(255) NOT NULL,
  `rfc` varchar(255) NOT NULL,
  `cp` varchar(10) NOT NULL,
  `est` varchar(10) NOT NULL,
  `nota` text NOT NULL,
  `can_fecha` date NOT NULL,
  `can_hora` time NOT NULL,
  `can_usu` varchar(255) NOT NULL,
  `can_nota` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO res_co_info VALUES("1","s","2015-10-29","09:50:15","","5","2015-10-29","1","91.9","100","191.9","12333","Sin Observaciones","Sin Observaciones","Sin Observaciones","2015-10-29","09:50:15","1","Principal","123456789","JORGE VASQUEZ","NOMBREDEL PROVEEDOR","ESTADO","MINICIPI","TELEFONO","ENTRE CALLE","CONTACTO","RFC","12345","s","ninguna observacione","2015-10-29","11:36:45","123456789","a");
INSERT INTO res_co_info VALUES("2","s","2015-10-29","09:56:50","","5","2015-10-29","1","200.75","279","479.75","12333","Sin Observaciones","Sin Observaciones","Sin Observaciones","2015-10-29","09:56:50","1","Principal","123456789","JORGE VASQUEZ","NOMBREDEL PROVEEDOR","ESTADO","MINICIPI","TELEFONO","ENTRE CALLE","CONTACTO","RFC","12345","s","ninguna observacione","0000-00-00","00:00:00","","");
INSERT INTO res_co_info VALUES("3","s","2015-10-29","12:04:14","123456789","5","2015-10-29","1","383.8","0","383.8","12333","Sin Observaciones","Sin Observaciones","Sin Observaciones","2015-10-29","11:52:19","1","Principal","123456789","JORGE VASQUEZ","NOMBREDEL PROVEEDOR","ESTADO","MINICIPI","TELEFONO","ENTRE CALLE","CONTACTO","RFC","12345","s","","0000-00-00","00:00:00","","");
INSERT INTO res_co_info VALUES("4","s","2015-10-29","13:40:48","123456789","5","2015-10-29","1","575.7","0","575.7","12333","Sin Observaciones","Sin Observaciones","Sin Observaciones","2015-10-29","13:40:30","1","Principal","123456789","JORGE VASQUEZ","NOMBREDEL PROVEEDOR","ESTADO","MINICIPI","TELEFONO","ENTRE CALLE","CONTACTO","RFC","12345","s","","0000-00-00","00:00:00","","");
INSERT INTO res_co_info VALUES("5","s","2015-10-29","13:41:51","123456789","5","2015-10-29","1","0","767.6","767.6","12333","Sin Observaciones","Sin Observaciones","Sin Observaciones","2015-10-29","13:41:33","1","Principal","123456789","JORGE VASQUEZ","NOMBREDEL PROVEEDOR","ESTADO","MINICIPI","TELEFONO","ENTRE CALLE","CONTACTO","RFC","12345","s","","0000-00-00","00:00:00","","");


CREATE TABLE `res_cocina` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `producto` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `mesa` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

INSERT INTO res_cocina VALUES("1","Producto de Prueba","1","2","2015-09-28","10:56:52","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("2","Producto de Prueba dos","1","2","2015-09-28","10:56:52","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("4","Producto de Prueba dos","1","2","2015-09-28","10:58:50","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("5","Producto de Prueba","5","2","2015-09-28","18:25:49","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("6","Producto de Prueba dos","2","2","2015-09-28","18:25:49","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("7","PRODUCTO ENTRANTE","3","2","2015-09-28","18:25:49","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("8","Producto de Prueba","1","1","2015-09-28","18:32:59","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("9","Producto de Prueba dos","5","1","2015-09-28","18:32:59","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("10","PRODUCTO ENTRANTE","1","1","2015-09-28","18:32:59","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("11","Producto de Prueba","1","3","2015-10-06","18:11:48","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("12","Producto de Prueba dos","2","3","2015-10-06","18:11:48","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("13","PRODUCTO ENTRANTE","2","3","2015-10-06","18:11:48","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("14","COCACOLA","1","3","2015-10-06","18:11:48","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("15","Producto de Prueba","1","2","2015-10-12","12:35:59","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("16","Producto de Prueba dos","1","2","2015-10-12","12:36:00","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("17","PRODUCTO ENTRANTE","1","2","2015-10-14","23:24:51","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("18","Producto de Prueba dos","2","2","2015-10-14","23:24:51","<span class=\"label label-important\">Sin Atender</span>");
INSERT INTO res_cocina VALUES("19","Producto de Prueba","1","2","2015-10-14","23:24:51","<span class=\"label label-important\">Sin Atender</span>");


CREATE TABLE `res_costo_prov` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prov` varchar(255) NOT NULL,
  `prod` varchar(255) NOT NULL,
  `costo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO res_costo_prov VALUES("1","12333","100","101");


CREATE TABLE `res_cxc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `cliente` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO res_cxc VALUES("1","11","1","1000","2015-09-28","18:29:22");
INSERT INTO res_cxc VALUES("2","12","1","500","2015-09-28","18:34:17");
INSERT INTO res_cxc VALUES("3","15","16","460","2015-10-14","23:23:48");


CREATE TABLE `res_cxc_abono` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `metodopago` varchar(255) NOT NULL,
  `tasa` varchar(255) NOT NULL,
  `ntasa` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO res_cxc_abono VALUES("1","11","100","123456789","2015-09-28","18:43:51","1","","","1");
INSERT INTO res_cxc_abono VALUES("2","12","100","123456789","2015-09-28","21:06:29","1","","","1");
INSERT INTO res_cxc_abono VALUES("3","11","200","123456789","2015-10-13","21:41:52","1","","","1");
INSERT INTO res_cxc_abono VALUES("4","12","400","123456789","2015-10-14","12:25:01","1","","","1");
INSERT INTO res_cxc_abono VALUES("5","11","400","123456789","2015-10-14","12:25:01","1","","","1");
INSERT INTO res_cxc_abono VALUES("6","12","0","123456789","2015-10-14","21:06:32","1","","","1");
INSERT INTO res_cxc_abono VALUES("7","11","50","123456789","2015-10-14","21:06:32","1","","","1");
INSERT INTO res_cxc_abono VALUES("8","15","0","123456789","2015-10-14","23:23:48","1","","","1");
INSERT INTO res_cxc_abono VALUES("9","15","60","123456789","2015-10-15","22:12:45","1","","","1");


CREATE TABLE `res_cxp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `compra` varchar(255) NOT NULL,
  `proveedor` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO res_cxp VALUES("1","1","12333","100","2015-10-29","09:50:15");
INSERT INTO res_cxp VALUES("2","2","12333","279","2015-10-29","09:56:50");


CREATE TABLE `res_cxp_abono` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `compra` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `total` varchar(255) NOT NULL,
  `saldo` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `metodopago` varchar(255) NOT NULL,
  `tasa` varchar(255) NOT NULL,
  `ntasa` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO res_cxp_abono VALUES("1","2","9","279","270","123456789","2015-10-29","11:42:57","1","0","","1");
INSERT INTO res_cxp_abono VALUES("2","2","70","279","200","123456789","2015-10-29","11:44:00","1","0","","1");


CREATE TABLE `res_dpto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categoria` varchar(255) NOT NULL,
  `usuario` varchar(255) NOT NULL,
  `prioridad` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO res_dpto VALUES("1","10","123456789","5");
INSERT INTO res_dpto VALUES("2","11","123456789","4");
INSERT INTO res_dpto VALUES("3","15","123456789","7");


CREATE TABLE `res_factura_cargo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `concepto` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `factura` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO res_factura_cargo VALUES("1","CREDITO","10","9");


CREATE TABLE `res_insumo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `familia` varchar(255) NOT NULL,
  `grupo` varchar(255) NOT NULL,
  `subgrupo` varchar(255) NOT NULL,
  `medida` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO res_insumo VALUES("1","100","Salsa de Tomate","102","100","101","105","700");


CREATE TABLE `res_insumo_contenido` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `insumo` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `contenido` varchar(255) NOT NULL,
  `cantu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

INSERT INTO res_insumo_contenido VALUES("3","100","1","1400","2");
INSERT INTO res_insumo_contenido VALUES("4","100","2","0","0");


CREATE TABLE `res_mesas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `capacidad` varchar(255) NOT NULL,
  `cpersona` varchar(255) NOT NULL,
  `numero` varchar(255) NOT NULL,
  `atencion` int(11) NOT NULL,
  `nota` text NOT NULL,
  `estado` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `usuario` varchar(255) NOT NULL,
  `clie_cod` varchar(255) NOT NULL,
  `clie_lista` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO res_mesas VALUES("1","MESA 1","10","0","2","1","NINGUNA","ACTIVADO","label label-success","123456789","","","0");
INSERT INTO res_mesas VALUES("2","MESA 2","5","0","1","1","NINGUNA","Cliente Especial","label label-important","123456789","16","1","0");
INSERT INTO res_mesas VALUES("3","MESA 3","10","0","3","1","S","NINGINO","label","","","","0");


CREATE TABLE `res_mesas_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mesa` varchar(255) NOT NULL,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO res_mesas_detalle VALUES("8","2","676767","PRODUCTO ENTRANTE","1","140","0");
INSERT INTO res_mesas_detalle VALUES("9","2","13","Producto de Prueba dos","2","100","0");
INSERT INTO res_mesas_detalle VALUES("10","2","12","Producto de Prueba","1","120","0");


CREATE TABLE `res_mesas_detalle_tmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mesa` varchar(255) NOT NULL,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO res_mesas_detalle_tmp VALUES("2","2","12","Producto de Prueba","1","120","0");


CREATE TABLE `resumen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `concepto` varchar(255) NOT NULL,
  `clase` varchar(255) NOT NULL COMMENT 'Compra, Venta, Abonos, Otro',
  `valor` varchar(255) NOT NULL,
  `dolar` varchar(255) NOT NULL,
  `tasa` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL COMMENT 'Entrada o Salida',
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `very` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `nota` varchar(255) NOT NULL,
  `formapago` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=latin1;

INSERT INTO resumen VALUES("4","VENTA REALIZADA, TICKET No. B 00000001","VENTA ANULADA","0","0","0","ENTRADA","2015-08-10","12:15:31","123456789","s","4","1","Online","1");
INSERT INTO resumen VALUES("5","VENTA ONLINE REALIZADA, TICKET No. B 00000002","VENTA","197","0","0","ENTRADA","2015-08-11","10:23:04","123456789","s","5","1","ONLINE","1");
INSERT INTO resumen VALUES("6","Prestamo Realizado al Empleado Alberto C por Valor de $3.000.000,00","PRESTAMOS","3000000","","","SALIDA","2015-08-13","13:47:27","123456789","s","1","1","Prestamos a Empleados","1");
INSERT INTO resumen VALUES("7","Pago de Empleado Alberto C Mes de Agosto","PAGOS A EMPLEADOS","227500","","","SALIDA","2015-08-13","13:49:43","123456789","s","1","1","Pago a Empleados","4");
INSERT INTO resumen VALUES("8","VENTA REALIZADA, TICKET No. B 00000003","VENTA","100","0","0","CXC","2015-08-13","13:52:46","123456789","s","6","1","Online","CXC");
INSERT INTO resumen VALUES("9","VENTA REALIZADA, TICKET No. B 00000003","VENTA","220","0","0","ENTRADA","2015-08-13","13:52:46","123456789","s","6","1","Online","1");
INSERT INTO resumen VALUES("10","VENTA ONLINE REALIZADA, TICKET No. B 00000004","VENTA","133","0","0","ENTRADA","2015-08-13","13:55:16","123456789","s","7","1","ONLINE","1");
INSERT INTO resumen VALUES("27","CONTRATO REALIZADO Y FINALIZADO, No. 00000010","VENTA","1001","0","0","ENTRADA","2015-08-18","21:10:31","123456789","s","f_10","","Contrato Finalizado","1");
INSERT INTO resumen VALUES("28","CONTRATO REALIZADO Y FINALIZADO, No. 00000010","VENTA","4028.2","0","0","ENTRADA","2015-08-18","21:10:31","123456789","s","f_10","","Contrato Finalizado","4");
INSERT INTO resumen VALUES("29","CONTRATO REALIZADO Y FINALIZADO, No. 00000010","VENTA","1762.6","0","0","ENTRADA","2015-08-21","22:26:36","123456789","s","f_10","","Contrato Finalizado","1");
INSERT INTO resumen VALUES("31","CONTRATO REALIZADO Y FINALIZADO, No. 00000012","VENTA","1755.54","0","0","ENTRADA","2015-08-21","22:37:28","123456789","s","f_12","","Contrato Finalizado","1");
INSERT INTO resumen VALUES("33","CONTRATO REALIZADO Y FINALIZADO, No. 00000013","VENTA","2757.09","0","0","ENTRADA","2015-08-22","10:18:20","123456789","s","f_13","","Contrato Finalizado","1");
INSERT INTO resumen VALUES("34","Compra Correspondiente a la Factura Compra No. 00000001","COMPRA REFACCIONES","199","0","0","SALIDA","2015-08-24","16:17:30","123456789","s","1","1","CompraRefaccion","1");
INSERT INTO resumen VALUES("35","Compra Correspondiente a la Factura Compra No. 00000002","COMPRA REFACCIONES","199","0","0","SALIDA","2015-08-24","16:18:24","123456789","s","2","1","CompraRefaccion","1");
INSERT INTO resumen VALUES("36","Compra Correspondiente a la Factura Compra No. 00000003","COMPRA REFACCIONES","100","0","0","SALIDA","2015-08-24","16:19:13","123456789","s","3","1","CompraRefaccion","1");
INSERT INTO resumen VALUES("37","Compra Correspondiente a la Factura Compra No. 00000003","COMPRA REFACCIONES","99","0","0","CXP","2015-08-24","16:19:13","123456789","s","3","1","CompraRefaccion","CXP");
INSERT INTO resumen VALUES("38","Compra Correspondiente a la Factura Compra No. 00000004","COMPRA REFACCIONES","640","0","0","SALIDA","2015-08-24","16:29:43","123456789","s","4","1","CompraRefaccion","1");
INSERT INTO resumen VALUES("39","Compra Correspondiente a la Factura Compra No. 00000004","COMPRA REFACCIONES","500","0","0","CXP","2015-08-24","16:29:43","123456789","s","4","1","CompraRefaccion","CXP");
INSERT INTO resumen VALUES("40","Abono Correspondiente a la Factura Compra No. 00000004","ABONO COMPRA REFACCIONES","100","0","0","SALIDA","2015-08-26","13:49:55","123456789","s","4","1","Abono Factura Compra","1");
INSERT INTO resumen VALUES("41","Abono Correspondiente a la Factura Compra No. 00000004","ABONO COMPRA REFACCIONES","120","10","12","SALIDA","2015-08-26","13:50:06","123456789","s","4","1","Abono Factura Compra","DOLAR");
INSERT INTO resumen VALUES("42","Pago a Empleados por Mantenimiento FUEL INJECTION","SERVICIOS","480","0","0","SALIDA","2015-08-27","22:51:52","123456789","s","","1","Pago a Empleados por Mantenimiento FUEL INJECTION","1");
INSERT INTO resumen VALUES("44","Compra Correspondiente a la Factura Compra No. 00000005","COMPRA","70","0","0","SALIDA","2015-09-04","17:31:09","123456789","s","5","1","Compras","5");
INSERT INTO resumen VALUES("45","CONTRATO DE EVENTO REALIZADO, No. 00000011","VENTA","1834.72","0","0","CXC","2015-09-11","17:57:07","123456789","s","11","1","Contrato Eventos","CXC");
INSERT INTO resumen VALUES("46","CONTRATO DE EVENTO REALIZADO, No. 00000011","VENTA","5000","0","0","ENTRADA","2015-09-11","17:57:07","123456789","s","11","1","Contrato Eventos","1");
INSERT INTO resumen VALUES("47","CONTRATO DE EVENTO REALIZADO, No. 00000011","VENTA","1834.72","0","0","CXC","2015-09-11","17:58:05","123456789","s","11","1","Contrato Eventos","CXC");
INSERT INTO resumen VALUES("48","CONTRATO DE EVENTO REALIZADO, No. 00000011","VENTA","5000","0","0","ENTRADA","2015-09-11","17:58:05","123456789","s","11","1","Contrato Eventos","1");
INSERT INTO resumen VALUES("50","ABONO REALIZADO DE EVENTO REALIZADO, No. 00000011","ABONO","834.72","0","0","ENTRADA","2015-09-14","20:48:19","123456789","s","11","1","Abonos Contrato Eventos","1");
INSERT INTO resumen VALUES("51","CONTRATO DE EVENTO REALIZADO, No. 00000014","VENTA","5000","0","0","CXC","2015-09-15","12:30:35","123456789","s","14","1","Contrato Eventos","CXC");
INSERT INTO resumen VALUES("52","CONTRATO DE EVENTO REALIZADO, No. 00000014","VENTA","5043.74","0","0","ENTRADA","2015-09-15","12:30:35","123456789","s","14","1","Contrato Eventos","1");
INSERT INTO resumen VALUES("53","ABONO REALIZADO DE EVENTO REALIZADO, No. 00000014","ABONO","800","0","0","ENTRADA","2015-09-15","12:31:05","123456789","s","14","1","Abonos Contrato Eventos","1");
INSERT INTO resumen VALUES("54","CONTRATO DE EVENTO REALIZADO, No. 00000014","VENTA","578.84","0","0","ENTRADA","2015-09-17","11:03:46","123456789","s","14","1","Contrato Eventos","1");
INSERT INTO resumen VALUES("55","CONTRATO DE EVENTO REALIZADO, No. 00000014","VENTA","1279.71","0","0","ENTRADA","2015-09-18","15:06:02","123456789","s","14","1","Contrato Eventos","1");
INSERT INTO resumen VALUES("60","ABONO REALIZADO DEL CONTRATO DE VEHICULO, No. 00000002","ABONO","300","0","0","ENTRADA","2015-09-19","12:18:39","123456789","s","2","1","Abonos Contrato Vehiculo","1");
INSERT INTO resumen VALUES("61","CONTRATO REALIZADO, No. 00000003","VENTA","2000","0","0","ENTRADA","2015-09-19","12:53:42","123456789","s","3","1","Contrato","CXC");
INSERT INTO resumen VALUES("62","CONTRATO REALIZADO, No. 00000003","VENTA","1978.8","0","0","ENTRADA","2015-09-19","12:53:42","123456789","s","3","1","Contrato","1");
INSERT INTO resumen VALUES("63","ABONO REALIZADO DEL CONTRATO DE VEHICULO, No. 00000003","ABONO","400","0","0","ENTRADA","2015-09-19","12:56:14","123456789","s","3","1","Abonos Contrato Vehiculo","1");
INSERT INTO resumen VALUES("64","VENTA REALIZADA, TICKET No.  00000001","VENTA","120","0","0","ENTRADA","2015-09-23","14:52:14","123456789","s","8","1","Online","1");
INSERT INTO resumen VALUES("65","VENTA REALIZADA, TICKET No.  00000002","VENTA","104","0","0","ENTRADA","2015-09-27","18:41:41","123456789","s","9","1","Online","1");
INSERT INTO resumen VALUES("66","VENTA REALIZADA, TICKET No. B 00000005","VENTA","399","0","0","ENTRADA","2015-09-27","18:48:55","123456789","s","10","1","Restaurante","1");
INSERT INTO resumen VALUES("67","VENTA REALIZADA, TICKET No. B 00000006","VENTA","1000","0","0","CXC","2015-09-28","18:29:22","123456789","s","11","1","Restaurante","CXC");
INSERT INTO resumen VALUES("68","VENTA REALIZADA, TICKET No. B 00000006","VENTA","380","0","0","ENTRADA","2015-09-28","18:29:22","123456789","s","11","1","Restaurante","1");
INSERT INTO resumen VALUES("69","VENTA REALIZADA, TICKET No. B 00000007","VENTA","500","0","0","CXC","2015-09-28","18:34:17","123456789","s","12","1","Restaurante","CXC");
INSERT INTO resumen VALUES("70","VENTA REALIZADA, TICKET No. B 00000007","VENTA","260","0","0","ENTRADA","2015-09-28","18:34:17","123456789","s","12","1","Restaurante","1");
INSERT INTO resumen VALUES("71","ABONO REALIZADO EN RESTAURANTE, No. B 00000006","ABONO","100","0","0","ENTRADA","2015-09-28","18:43:51","123456789","s","11","1","Abonos Restaurante","1");
INSERT INTO resumen VALUES("72","ABONO REALIZADO EN RESTAURANTE, No. B 00000007","ABONO","100","0","0","ENTRADA","2015-09-28","21:06:29","123456789","s","12","1","Abonos Restaurante","1");
INSERT INTO resumen VALUES("73","VENTA REALIZADA, TICKET No. B 00000008","VENTA","2712","0","0","ENTRADA","2015-10-03","23:24:35","123456789","s","13","1","Online","1");
INSERT INTO resumen VALUES("74","VENTA REALIZADA, TICKET No. B 00000008","VENTA","1000","0","0","CXC","2015-10-03","23:24:35","123456789","s","13","1","Online","CXC");
INSERT INTO resumen VALUES("75","VENTA REALIZADA, TICKET No. B 00000009","VENTA","610","0","0","ENTRADA","2015-10-06","19:00:09","123456789","s","14","1","Restaurante","1");
INSERT INTO resumen VALUES("76","Movimiento Financiero, agua","MOVIMIENTO FINANCIERO","1000","","","SALIDA","2015-10-10","12:15:41","123456789","s","2","1","","1");
INSERT INTO resumen VALUES("77","ABONO REALIZADO EN RESTAURANTE, No. B 00000006","ABONO","200","0","0","ENTRADA","2015-10-13","21:41:52","123456789","s","11","1","Abonos Restaurante","1");
INSERT INTO resumen VALUES("80","VENTA REALIZADA, TICKET No. B 00000010","VENTA","460","0","0","CXC","2015-10-14","23:23:48","123456789","s","15","1","Restaurante","CXC");
INSERT INTO resumen VALUES("81","MODULO RESTAURANTE DEL CLIENTE PUBLICO GENERAL","ABONO","100","0","0","ENTRADA","2015-10-15","10:03:28","123456789","s","1","1","Abonos al Saldo ","1");
INSERT INTO resumen VALUES("82","MODULO RESTAURANTE DEL CLIENTE PUBLICO GENERAL","ABONO","100","0","0","ENTRADA","2015-10-15","10:19:58","123456789","s","1","1","Abonos al Saldo ","1");
INSERT INTO resumen VALUES("83","MODULO RESTAURANTE DEL CLIENTE PUBLICO GENERAL","ABONO","100","0","0","ENTRADA","2015-10-15","10:21:52","123456789","s","1","1","Abonos al Saldo ","1");
INSERT INTO resumen VALUES("84","ABONO REALIZADO EN MODULO VENTAS, No. B 00000008","ABONO","100","0","0","ENTRADA","2015-10-15","10:34:40","123456789","s","13","1","Modulo de Ventas","1");
INSERT INTO resumen VALUES("85","VENTA REALIZADA, TICKET No. B 00000011","VENTA","4292","0","0","CXC","2015-10-15","10:44:51","123456789","s","16","1","Online","CXC");
INSERT INTO resumen VALUES("86","MODULO RESTAURANTE DEL CLIENTE PUBLICO GENERAL","ABONO","1000","0","0","ENTRADA","2015-10-15","10:45:06","123456789","s","1","1","Abonos al Saldo ","1");
INSERT INTO resumen VALUES("87","MODULO RESTAURANTE DEL CLIENTE Infosis Piso 11","ABONO","1200","0","0","ENTRADA","2015-10-15","11:27:36","123456789","s","16","1","Abonos al Saldo ev_","1");
INSERT INTO resumen VALUES("88","CONTRATO REALIZADO, No. 00000006","VENTA","916","0","0","ENTRADA","2015-10-15","12:39:15","123456789","s","6","1","Contrato","CXC");
INSERT INTO resumen VALUES("89","CONTRATO REALIZADO, No. 00000007","VENTA","713.4","0","0","ENTRADA","2015-10-15","12:45:31","123456789","s","7","1","Contrato","CXC");
INSERT INTO resumen VALUES("90","MODULO RENTA DE VEHICULOS DEL CLIENTE PUBLICO GENERAL","ABONO","250","0","0","ENTRADA","2015-10-15","12:45:59","123456789","s","1","1","Abonos al Saldo vehiculo_","1");
INSERT INTO resumen VALUES("91","MODULO RENTA DE VEHICULOS DEL CLIENTE PUBLICO GENERAL","ABONO","500","0","0","ENTRADA","2015-10-15","12:47:00","123456789","s","1","1","Abonos al Saldo vehiculo_","1");
INSERT INTO resumen VALUES("92","ABONO REALIZADO EN RESTAURANTE, No. B 00000010","ABONO","60","0","0","ENTRADA","2015-10-15","22:12:45","123456789","s","15","1","Abonos Restaurante","1");
INSERT INTO resumen VALUES("93","SERVICIO REALIZADO REALIZADA, FACTURA No. A 00000002","VENTA","672.8","0","0","CXC","2015-10-16","09:43:50","123456789","s","3","1","Servicio","CXC");
INSERT INTO resumen VALUES("94","SERVICIO REALIZADO REALIZADA, FACTURA No. A 00000002","VENTA","116","0","0","ENTRADA","2015-10-16","09:43:50","123456789","s","3","1","Servicio","1");
INSERT INTO resumen VALUES("95","SERVICIO REALIZADO REALIZADA, FACTURA No. A 00000003","VENTA","700","0","0","CXC","2015-10-16","09:57:19","123456789","s","4","1","Servicio","CXC");
INSERT INTO resumen VALUES("96","SERVICIO REALIZADO REALIZADA, FACTURA No. A 00000003","VENTA","88","0","0","ENTRADA","2015-10-16","09:57:19","123456789","s","4","1","Servicio","1");
INSERT INTO resumen VALUES("97","SERVICIO REALIZADO REALIZADA, FACTURA No. A 00000004","VENTA","700","0","0","CXC","2015-10-16","10:07:35","123456789","s","5","1","Servicio","CXC");
INSERT INTO resumen VALUES("98","SERVICIO REALIZADO REALIZADA, FACTURA No. A 00000004","VENTA","88","0","0","ENTRADA","2015-10-16","10:07:35","123456789","s","5","1","Servicio","1");
INSERT INTO resumen VALUES("99","SERVICIO REALIZADO REALIZADA, FACTURA No. A 00000005","VENTA","355.2","0","0","ENTRADA","2015-10-16","10:54:25","123456789","s","6","1","Servicio","1");
INSERT INTO resumen VALUES("100","MODULO SERVICIOS DEL CLIENTE PUBLICO GENERAL","ABONO","800","0","0","ENTRADA","2015-10-16","14:35:50","123456789","s","1","1","Abonos al Saldo ser_","1");
INSERT INTO resumen VALUES("101","ABONO REALIZADO EN SERVICIOS, No. A 00000004","ABONO","100","0","0","ENTRADA","2015-10-16","14:48:46","123456789","s","5","1","Abonos Restaurante","1");
INSERT INTO resumen VALUES("102","ABONO REALIZADO EN MODULO VENTAS, No. B 00000011","ABONO","92","0","0","ENTRADA","2015-10-16","20:46:17","123456789","s","16","1","Modulo de Ventas","1");
INSERT INTO resumen VALUES("103","VENTA REALIZADA, TICKET No. B 00000012","VENTA","1972","0","0","CXC","2015-10-16","20:47:50","123456789","s","17","1","Online","CXC");
INSERT INTO resumen VALUES("104","ABONO REALIZADO EN MODULO VENTAS, No. B 00000012","ABONO","172","0","0","ENTRADA","2015-10-16","20:48:23","123456789","s","17","1","Modulo de Ventas","1");
INSERT INTO resumen VALUES("105","VENTA REALIZADA, TICKET No. B 00000013","VENTA","139.2","0","0","ENTRADA","2015-10-21","20:02:35","123456789","s","18","1","Online","1");
INSERT INTO resumen VALUES("110","VENTA REALIZADA, TICKET No.  00000001","VENTA","835.2","0","0","ENTRADA","2015-10-23","21:30:31","123456789","s","25","1","Online","1");
INSERT INTO resumen VALUES("111","VENTA REALIZADA, TICKET No.  00000002","VENTA","278.4","0","0","ENTRADA","2015-10-23","21:58:54","123456789","s","25","1","Online","1");
INSERT INTO resumen VALUES("112","VENTA REALIZADA, TICKET No.  00000001","VENTA","835.2","0","0","ENTRADA","2015-10-23","21:30:31","123456789","s","26","1","Online","1");
INSERT INTO resumen VALUES("113","VENTA REALIZADA, TICKET No.  00000002","VENTA","278.4","0","0","ENTRADA","2015-10-23","21:58:54","123456789","s","26","1","Online","1");
INSERT INTO resumen VALUES("114","Compra Correspondiente a la Factura Compra No. 00000001","COMPRA","100","0","0","CXP","2015-10-29","09:50:15","123456789","s","1","1","Compras","CXP");
INSERT INTO resumen VALUES("116","Compra Correspondiente a la Factura Compra No. 00000002","COMPRA","279","0","0","CXP","2015-10-29","09:56:50","123456789","s","2","1","Compras de Insumos","CXP");
INSERT INTO resumen VALUES("117","Compra Correspondiente a la Factura Compra No. 00000002","COMPRA","200.75","0","0","SALIDA","2015-10-29","09:56:50","123456789","s","2","1","Compras de Insumos","1");
INSERT INTO resumen VALUES("118","Abono Cuenta por Pagar No. 00000002","ABONO COMPRA","9","","","SALIDA","2015-10-29","11:41:53","123456789","s","","1","","1");
INSERT INTO resumen VALUES("119","Abono Cuenta por Pagar No. 00000002","ABONO COMPRA","9","","","SALIDA","2015-10-29","11:42:08","123456789","s","","1","","1");
INSERT INTO resumen VALUES("120","Abono Cuenta por Pagar No. 00000002","ABONO COMPRA","9","","","SALIDA","2015-10-29","11:42:57","123456789","s","1","1","","1");
INSERT INTO resumen VALUES("121","Abono Cuenta por Pagar No. 00000002","ABONO COMPRA","70","","","SALIDA","2015-10-29","11:44:00","123456789","s","2","1","","1");
INSERT INTO resumen VALUES("122","Compra Correspondiente a la Factura Compra No. 00000003","COMPRA","383.8","0","0","SALIDA","2015-10-29","11:52:19","123456789","s","3","1","Compras de Insumos","1");
INSERT INTO resumen VALUES("123","Regreso de Dinero por Causa de Productos no Recibidos de Factura Compra No. 00000003","REGRESO DE DINERO DE PRODUCTO COMPRA - INSUMOS","404","","","ENTRADA","2015-10-29","12:04:25","123456789","s","3","1","Regreso de Dinero por Productos no Recibidos Factura Compra - Insumos","1");
INSERT INTO resumen VALUES("124","Regreso de Dinero por Causa de Productos no Recibidos de Factura Compra No. 00000003","REGRESO DE DINERO DE PRODUCTO COMPRA - INSUMOS","404","","","ENTRADA","2015-10-29","12:04:30","123456789","s","3","1","Regreso de Dinero por Productos no Recibidos Factura Compra - Insumos","1");
INSERT INTO resumen VALUES("125","Compra Correspondiente a la Factura Compra No. 00000004","COMPRA","575.7","0","0","SALIDA","2015-10-29","13:40:30","123456789","s","4","1","Compras de Insumos","1");
INSERT INTO resumen VALUES("126","Regreso de Dinero por Causa de Productos no Recibidos de Factura Compra No. 00000004","REGRESO DE DINERO DE PRODUCTO COMPRA - INSUMOS","101","","","ENTRADA","2015-10-29","13:40:59","123456789","s","4","1","Regreso de Dinero por Productos no Recibidos Factura Compra - Insumos","1");
INSERT INTO resumen VALUES("127","Regreso de Dinero por Causa de Productos no Recibidos de Factura Compra No. 00000004","REGRESO DE DINERO DE PRODUCTO COMPRA - INSUMOS","101","","","ENTRADA","2015-10-29","13:41:03","123456789","s","4","1","Regreso de Dinero por Productos no Recibidos Factura Compra - Insumos","1");
INSERT INTO resumen VALUES("128","Compra Correspondiente a la Factura Compra No. 00000005","COMPRA","767.6","0","0","SALIDA","2015-10-29","13:41:33","123456789","s","5","1","Compras de Insumos","4");
INSERT INTO resumen VALUES("129","VENTA REALIZADA, TICKET No. B 00000014","VENTA","400","0","0","CXC","2015-10-30","11:34:21","123456789","s","27","1","Online","CXC");
INSERT INTO resumen VALUES("130","VENTA REALIZADA, TICKET No. B 00000014","VENTA","17.6","0","0","ENTRADA","2015-10-30","11:34:21","123456789","s","27","1","Online","1");


CREATE TABLE `seg_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;



CREATE TABLE `seg_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m` varchar(255) NOT NULL,
  `sm` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

INSERT INTO seg_menu VALUES("1","Registro y Control","Modulo Usuarios","s");
INSERT INTO seg_menu VALUES("2","Registro y Control","Modulo Productos","s");
INSERT INTO seg_menu VALUES("3","Registro y Control","Modulo Almacen","s");
INSERT INTO seg_menu VALUES("4","Registro y Control","Modulo Tienda Virtual","s");
INSERT INTO seg_menu VALUES("5","Registro y Control","Modulo Proveedores","s");
INSERT INTO seg_menu VALUES("6","Registro y Control","Modulo Cliente","s");
INSERT INTO seg_menu VALUES("7","Registro y Control","Modulo Nomina","s");
INSERT INTO seg_menu VALUES("8","Registro y Control","Modulo Sucursales","s");
INSERT INTO seg_menu VALUES("9","Administrar","Administrar Informacion de Productos","s");
INSERT INTO seg_menu VALUES("10","Administrar","Configuración Renta","s");
INSERT INTO seg_menu VALUES("11","Financiero","Admin. Cuentas Financieras","s");
INSERT INTO seg_menu VALUES("12","Superior","Registro y Control","s");
INSERT INTO seg_menu VALUES("13","Superior","Administrar","s");
INSERT INTO seg_menu VALUES("14","Superior","Ventas","s");
INSERT INTO seg_menu VALUES("15","Superior","Financiero","s");
INSERT INTO seg_menu VALUES("16","Superior","Asistencias","s");
INSERT INTO seg_menu VALUES("17","Superior","Reportes","s");
INSERT INTO seg_menu VALUES("18","Registro y Control","Modulo Servicios","s");


CREATE TABLE `seg_modulo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO seg_modulo VALUES("1","Modulo de Vehiculos","s");
INSERT INTO seg_modulo VALUES("2","Modulo de Eventos","s");
INSERT INTO seg_modulo VALUES("3","Modulo de Restaurantes","s");


CREATE TABLE `seg_nom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `grupo` varchar(255) NOT NULL,
  `cod` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=latin1;

INSERT INTO seg_nom VALUES("1","Usuarios","1","Registro, Actualizar y Consultar Usuarios","s");
INSERT INTO seg_nom VALUES("2","Usuarios","2","Administrar Permisos","s");
INSERT INTO seg_nom VALUES("3","Usuarios","3","Administrar Cargos","s");
INSERT INTO seg_nom VALUES("4","Usuarios","4","Actualizar Contraseña","s");
INSERT INTO seg_nom VALUES("5","Productos","1","Crear, Consultar y Actualizar Productos","s");
INSERT INTO seg_nom VALUES("6","Productos","2","Administrar Precios y Costos","s");
INSERT INTO seg_nom VALUES("7","Productos","3","Administrar Familia, Grupo y SubGrupo","s");
INSERT INTO seg_nom VALUES("8","Productos","4","Actualizar Precios Masivamente","s");
INSERT INTO seg_nom VALUES("9","Proveedor","1","Crear, Consultar y Actualizar Proveedores","s");
INSERT INTO seg_nom VALUES("10","Proveedor","2","Administrar Tipos de Proveedores","s");
INSERT INTO seg_nom VALUES("11","Cliente","1","Crear, Consultar y Actualizar Clientes","s");
INSERT INTO seg_nom VALUES("12","Cliente","2","Administrar Créditos de Clientes","s");
INSERT INTO seg_nom VALUES("13","Cliente","3","Administrar Metodos de Pagos","s");
INSERT INTO seg_nom VALUES("14","Cliente","4","Cambiar Contraseña de Clientes","s");
INSERT INTO seg_nom VALUES("15","Nomina","1","Administrar Sueldos y Salarios","s");
INSERT INTO seg_nom VALUES("16","Nomina","2","Administrar Conceptos","s");
INSERT INTO seg_nom VALUES("17","Nomina","3","Administrar Tipo de Prestamos","s");
INSERT INTO seg_nom VALUES("18","Nomina","4","Pagar Salarios","s");
INSERT INTO seg_nom VALUES("19","Nomina","5","Aprobar Prestamos","s");
INSERT INTO seg_nom VALUES("20","Nomina","6","Consultar Pagos de Nomina","s");
INSERT INTO seg_nom VALUES("21","Sistemas","1","Administrar Sucursales","s");
INSERT INTO seg_nom VALUES("22","Bodega","1","Administrar Existencias","s");
INSERT INTO seg_nom VALUES("23","Bodega","2","Transferir Productos de Sucursal","s");
INSERT INTO seg_nom VALUES("24","Bodega","3","Consultar Transferencias de Productos","s");
INSERT INTO seg_nom VALUES("25","Bodega","4","Administrar Compras de Productos","s");
INSERT INTO seg_nom VALUES("26","Sistemas","2","Administrar Folios","s");
INSERT INTO seg_nom VALUES("27","Venta","1","Realizar Ventas","s");
INSERT INTO seg_nom VALUES("28","Venta","2","Editar Precio Venta","s");
INSERT INTO seg_nom VALUES("29","Venta","3","Editar Cantidades","s");
INSERT INTO seg_nom VALUES("30","Sistemas","3","Administrar Botones de Venta","s");
INSERT INTO seg_nom VALUES("31","Sistemas","4","Configurar Ticket","s");
INSERT INTO seg_nom VALUES("32","Cuentas","1","Administrar Cuentas por Cobrar CXC","s");
INSERT INTO seg_nom VALUES("33","Productos","5","Administrar Kits","s");
INSERT INTO seg_nom VALUES("34","Sistemas","5","Administrar Metodos de Pagos","s");
INSERT INTO seg_nom VALUES("35","Reportes","1","Productos mas Vendidos","s");
INSERT INTO seg_nom VALUES("36","Venta","4","Administrar Pedidos de Ventas","s");
INSERT INTO seg_nom VALUES("37","Venta","5","Utilizar Kits","s");
INSERT INTO seg_nom VALUES("38","Comisiones","1","Administrar Comisiones","s");
INSERT INTO seg_nom VALUES("39","Financieros","1","Administrar Cuentas","s");
INSERT INTO seg_nom VALUES("40","Financieros","2","Administrar Sub Cuentas","s");
INSERT INTO seg_nom VALUES("41","Financieros","3","Administrar Sub Sub Cuentas","s");
INSERT INTO seg_nom VALUES("42","Sistemas","6","Programar Descuentos","s");
INSERT INTO seg_nom VALUES("43","Productos","6","Consultar Productos Desactivados","s");
INSERT INTO seg_nom VALUES("44","Financieros","4","Consultar Estado Financiero","s");
INSERT INTO seg_nom VALUES("45","Venta","6","Consultar Facturas y/o Ticket","s");
INSERT INTO seg_nom VALUES("46","Reportes","2","Cierre de Caja","s");
INSERT INTO seg_nom VALUES("47","Reportes","3","Estadisticas","s");
INSERT INTO seg_nom VALUES("48","Productos","7","Administrar Listas de Precios","s");
INSERT INTO seg_nom VALUES("49","Sistemas","7","Revisar Correos Enviados","s");
INSERT INTO seg_nom VALUES("50","Venta","7","Administrar Consigna","s");
INSERT INTO seg_nom VALUES("51","Sistemas","8","Actualizar Imágenes de Presentacion","s");
INSERT INTO seg_nom VALUES("52","Venta","8","Administrar Devoluciones","s");
INSERT INTO seg_nom VALUES("53","Subir","1","Productos","s");
INSERT INTO seg_nom VALUES("54","Subir","2","Clientes","s");
INSERT INTO seg_nom VALUES("55","Sistemas","9","Administrar Pie de Pagina de Ticket","s");
INSERT INTO seg_nom VALUES("56","Anulaciones","1","Anular Facturas","s");
INSERT INTO seg_nom VALUES("57","Anulaciones","2","Consultar Facturas Anuladas","s");
INSERT INTO seg_nom VALUES("58","Venta","9","Utilizacion de Factura Electronica","s");
INSERT INTO seg_nom VALUES("59","Productos","8","Administrar Costos por Defecto","s");
INSERT INTO seg_nom VALUES("60","Productos","9","Consultar Costos Promedios ","s");
INSERT INTO seg_nom VALUES("61","Bodega","5","Reporte de Existencias Fisicas","s");
INSERT INTO seg_nom VALUES("62","Asistencias","3","Administrar Horas de Entrada y Salida","s");
INSERT INTO seg_nom VALUES("63","Asistencias","4","Consultar Horarios de Empleados","s");
INSERT INTO seg_nom VALUES("64","Asistencias","5","Administrar Asistencias a Empleados","s");
INSERT INTO seg_nom VALUES("65","Asistencias","6","Consultar Asistencias","s");
INSERT INTO seg_nom VALUES("66","Productos","10","Consultar Precio Venta y Costo de Productos","s");
INSERT INTO seg_nom VALUES("67","Cliente","5","Consultar Cliente por Lista de Precio","s");
INSERT INTO seg_nom VALUES("68","Venta","10","Cambiar Forma de Pagos a Facturas","s");
INSERT INTO seg_nom VALUES("69","Sistemas","10","Administrar Agenda","s");
INSERT INTO seg_nom VALUES("70","Sistemas","11","Administrar Verificador de Precios","s");
INSERT INTO seg_nom VALUES("71","Sistemas","12","Administrar Tasa del Dolar","s");
INSERT INTO seg_nom VALUES("72","Sistemas","13","Consultar Historial de Tasa de Dolar","s");
INSERT INTO seg_nom VALUES("73","Venta","11","Consultar Facturas Vencidas","s");
INSERT INTO seg_nom VALUES("74","Cliente","6","Consultar Estado de Cuenta de Clientes","s");
INSERT INTO seg_nom VALUES("75","Reportes","4","Cliente mas Activo","s");
INSERT INTO seg_nom VALUES("76","Reportes","5","Ventas por Productos","s");
INSERT INTO seg_nom VALUES("77","Asistencias","7","Consultar Horas Trabajadas","s");
INSERT INTO seg_nom VALUES("78","Asistencias","8","Actualizar Imágenes Publicitarias","s");
INSERT INTO seg_nom VALUES("79","Subir","3","Proveedores","s");
INSERT INTO seg_nom VALUES("80","Sistemas","14","Programar Compras","s");
INSERT INTO seg_nom VALUES("81","Sistemas","15","Administrar Impuestos","s");
INSERT INTO seg_nom VALUES("82","Vehiculo","1","Registro y Control de Vehiculo","s");
INSERT INTO seg_nom VALUES("83","Vehiculo","2","Administrar Configuracion Inicial de Vehiculos","s");
INSERT INTO seg_nom VALUES("84","Vehiculo","3","Registrar Compra de Vehiculo","s");
INSERT INTO seg_nom VALUES("85","Sistemas","16","Editar Planes de Renta","s");
INSERT INTO seg_nom VALUES("86","Vehiculo","4","Registrar Proveedores de Vehiculos","s");
INSERT INTO seg_nom VALUES("87","Vehiculo","5","Ingresar Tarifas de Renta de Proveedores","s");
INSERT INTO seg_nom VALUES("88","Vehiculo","6","Administrar Tarifas de Alquiler de Vehiculo","s");
INSERT INTO seg_nom VALUES("89","Vehiculo","7","Administrar Conductores","s");
INSERT INTO seg_nom VALUES("90","Vehiculo","8","Realizar Contrato de Alquiler de Vehiculo","s");
INSERT INTO seg_nom VALUES("91","Vehiculo","9","Administrar Equipamiento del Vehiculo","s");
INSERT INTO seg_nom VALUES("92","Sistemas","17","Historial de Eventos de Usuarios","s");
INSERT INTO seg_nom VALUES("93","Reportes","7","Consultar Descuentos Realizados","s");
INSERT INTO seg_nom VALUES("94","Productos","11","Administrar Departamentos de Productos","s");
INSERT INTO seg_nom VALUES("95","Tienda Online","1","Administrar Gastos de Envios","s");
INSERT INTO seg_nom VALUES("96","Productos","12","Habilitar Campos de Tallas y Color","s");
INSERT INTO seg_nom VALUES("97","Productos","13","Administrar Colores y Tallas","s");
INSERT INTO seg_nom VALUES("98","Tienda Online","2","Administrar Bancos","s");
INSERT INTO seg_nom VALUES("99","Tienda Online","3","Programar Descuentos","s");
INSERT INTO seg_nom VALUES("100","Tienda Online","4","Administrar Productos Preferenciales","s");
INSERT INTO seg_nom VALUES("101","Tienda Online","5","Cambiar de Sucursales Pedidos","s");
INSERT INTO seg_nom VALUES("102","Asistencias","9","Colocar Faltas a Empleados","s");
INSERT INTO seg_nom VALUES("103","Cliente","7","Consultar Estado de Cuenta","s");
INSERT INTO seg_nom VALUES("104","Tienda Online","6","Confirmar Pagos de Pedidos","s");
INSERT INTO seg_nom VALUES("105","Tienda Online","7","Enviar Pedidos","s");
INSERT INTO seg_nom VALUES("106","Reportes","8","Consultar Devoluciones Realizadas","s");
INSERT INTO seg_nom VALUES("107","Reportes","9","Consultar Facturas Anuladas","s");
INSERT INTO seg_nom VALUES("108","Tienda Online","8","Administrar Empresas de Envios","s");
INSERT INTO seg_nom VALUES("109","Tienda Online","9","Administrar Mensaje de Correo de Confirmación de Envio","s");
INSERT INTO seg_nom VALUES("110","Vehiculo","10","Finalizar Contrato","s");
INSERT INTO seg_nom VALUES("111","Vehiculo - Refacciones","1","Administrar Refacciones","s");
INSERT INTO seg_nom VALUES("112","Vehiculo - Refacciones","2","Relacionar Proveedor con Refacciones, Costos","s");
INSERT INTO seg_nom VALUES("113","Vehiculo - Refacciones","3","Compra de Refacciones","s");
INSERT INTO seg_nom VALUES("114","Vehiculo - Refacciones","4","Administrar Bodega de Refacciones","s");
INSERT INTO seg_nom VALUES("115","Vehiculo - Refacciones","5","Realizar Transferencias de Refacciones","s");
INSERT INTO seg_nom VALUES("116","Vehiculo - Empresa de Seguros","1","Administrar Empresas de Seguros","s");
INSERT INTO seg_nom VALUES("117","Venta","12","Imprimir Cotizaciones","s");
INSERT INTO seg_nom VALUES("118","Vehiculo - Mantenimiento","1","Programar Mantenimiento a Vehiculos","s");
INSERT INTO seg_nom VALUES("119","Vehiculo - Mantenimiento","2","Realizar Mantenimientos Programados","s");
INSERT INTO seg_nom VALUES("120","Vehiculo - Mantenimiento","3","Administrar Tipos de Servicios","s");
INSERT INTO seg_nom VALUES("121","Venta","13","Consultar y Procesar Cotizaciones","s");
INSERT INTO seg_nom VALUES("122","Eventos","1","Registro y Control de Salones","s");
INSERT INTO seg_nom VALUES("123","Eventos","2","Registro y Control de Vehiculos","s");
INSERT INTO seg_nom VALUES("124","Eventos","3","Administrar Tipo de Vehiculos","s");
INSERT INTO seg_nom VALUES("125","Eventos","4","Adminsitrar Productos a Alquilar","s");
INSERT INTO seg_nom VALUES("126","Eventos","5","Administrar Cantidades de Productos a Alquilar","s");
INSERT INTO seg_nom VALUES("127","Eventos","6","Administrar Tarifas","s");
INSERT INTO seg_nom VALUES("128","Eventos","7","Generar Contrato de Servicios para Eventos","s");
INSERT INTO seg_nom VALUES("129","Bodega","6","Consultar y Re Imprimir Comprobantes","s");
INSERT INTO seg_nom VALUES("130","Eventos","8","Administrar Cuentas por Cobrar","s");
INSERT INTO seg_nom VALUES("131","Eventos","9","Administrar Zonas","s");
INSERT INTO seg_nom VALUES("132","Eventos","10","Administrar Rutas","s");
INSERT INTO seg_nom VALUES("133","Eventos","11","Consultar Rutas Programadas","s");
INSERT INTO seg_nom VALUES("134","Vehiculo","11","Administrar Cuentas por Cobrar","s");
INSERT INTO seg_nom VALUES("135","Bodega","7","Cancelar Compras","s");
INSERT INTO seg_nom VALUES("136","Restaurante","1","Administrar Mesas","s");
INSERT INTO seg_nom VALUES("137","Restaurante","2","Realizar Pedidos o Atender Mesas","s");
INSERT INTO seg_nom VALUES("138","Restaurante","3","Administrar y Facturar Contenido de Mesas","s");
INSERT INTO seg_nom VALUES("139","Restaurante","4","Consultar Comandas en Cocina","s");
INSERT INTO seg_nom VALUES("140","Restaurante","5","Administrar Cuentas por Cobrar","s");
INSERT INTO seg_nom VALUES("141","Bodega","8","Consultar Productos en Baja Existencia","s");
INSERT INTO seg_nom VALUES("142","Bodega","9","Administrar Cantidad Minimo o Maximo de Productos","s");
INSERT INTO seg_nom VALUES("143","Bodega","10","Administrar Conceptos de Devoluciones","s");
INSERT INTO seg_nom VALUES("144","Bodega","11","Administrar Productos Defectuoso","s");
INSERT INTO seg_nom VALUES("145","Reportes","10","Centro de Costos, Consultar Facturas CXC","s");
INSERT INTO seg_nom VALUES("146","Restaurante - Insumos","1","Administrar Insumos","s");
INSERT INTO seg_nom VALUES("147","Restaurante - Insumos","2","Administrar Grupo, Sub Grupo y Familias","s");
INSERT INTO seg_nom VALUES("148","Restaurante - Insumos","3","Administrar Contenido y Cantidades de Insumos","s");
INSERT INTO seg_nom VALUES("149","Servicios","1","Administrar Servicios","s");
INSERT INTO seg_nom VALUES("150","Servicios","2","Administrar Categorias de Servicios","s");
INSERT INTO seg_nom VALUES("151","Servicios","3","Administrar Precios de Servicios","s");
INSERT INTO seg_nom VALUES("152","Reportes","11","Consultar Productos en Sucursales","s");
INSERT INTO seg_nom VALUES("153","Servicios","4","Facturar Servicios","s");
INSERT INTO seg_nom VALUES("154","Servicios","5","Registrar y Consultar Comprobante","s");
INSERT INTO seg_nom VALUES("155","Servicios","6","Administrar Cuentas por Cobrar de Servicios","s");
INSERT INTO seg_nom VALUES("156","Venta","14","Consultar Cuentas por Cobrar Vencidas","s");
INSERT INTO seg_nom VALUES("157","Bodega","13","Administrar Productos de Baja Existencia","s");
INSERT INTO seg_nom VALUES("158","Sistemas","18","Administrar Informacion Fuera de Linea","s");
INSERT INTO seg_nom VALUES("159","Sistemas","19","Actualizar Facturaciones","s");
INSERT INTO seg_nom VALUES("160","Restaurante - Insumos","4","Compras de Insumos","s");
INSERT INTO seg_nom VALUES("161","Restaurante - Insumos","5","Administrar Costos de Insumos","s");
INSERT INTO seg_nom VALUES("162","Venta","15","Utilizar Sistema de Apartado en Ventas","s");
INSERT INTO seg_nom VALUES("163","Sistemas","20","Administrar Tipo de Apartados en Ventas","s");
INSERT INTO seg_nom VALUES("164","Venta","16","Consultar Apartados Realizados","s");


CREATE TABLE `seg_per` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usu` varchar(255) NOT NULL,
  `modulo` varchar(255) NOT NULL,
  `permiso` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=847 DEFAULT CHARSET=latin1;

INSERT INTO seg_per VALUES("1","123456789","Anulaciones","1","s");
INSERT INTO seg_per VALUES("2","123456789","Anulaciones","2","s");
INSERT INTO seg_per VALUES("3","123456789","Asistencias","3","s");
INSERT INTO seg_per VALUES("4","123456789","Asistencias","4","s");
INSERT INTO seg_per VALUES("5","123456789","Asistencias","5","s");
INSERT INTO seg_per VALUES("6","123456789","Asistencias","6","s");
INSERT INTO seg_per VALUES("7","123456789","Asistencias","7","s");
INSERT INTO seg_per VALUES("8","123456789","Asistencias","8","s");
INSERT INTO seg_per VALUES("9","123456789","Asistencias","9","s");
INSERT INTO seg_per VALUES("10","123456789","Bodega","1","s");
INSERT INTO seg_per VALUES("11","123456789","Bodega","2","s");
INSERT INTO seg_per VALUES("12","123456789","Bodega","3","s");
INSERT INTO seg_per VALUES("13","123456789","Bodega","4","s");
INSERT INTO seg_per VALUES("14","123456789","Bodega","5","s");
INSERT INTO seg_per VALUES("15","123456789","Cliente","1","s");
INSERT INTO seg_per VALUES("16","123456789","Cliente","2","s");
INSERT INTO seg_per VALUES("17","123456789","Cliente","3","s");
INSERT INTO seg_per VALUES("18","123456789","Cliente","4","s");
INSERT INTO seg_per VALUES("19","123456789","Cliente","5","s");
INSERT INTO seg_per VALUES("20","123456789","Cliente","6","s");
INSERT INTO seg_per VALUES("21","123456789","Cliente","7","s");
INSERT INTO seg_per VALUES("22","123456789","Comisiones","1","s");
INSERT INTO seg_per VALUES("23","123456789","Cuentas","1","s");
INSERT INTO seg_per VALUES("24","123456789","Eventos","1","s");
INSERT INTO seg_per VALUES("25","123456789","Eventos","2","s");
INSERT INTO seg_per VALUES("26","123456789","Eventos","3","s");
INSERT INTO seg_per VALUES("27","123456789","Eventos","4","s");
INSERT INTO seg_per VALUES("28","123456789","Eventos","5","s");
INSERT INTO seg_per VALUES("29","123456789","Eventos","6","s");
INSERT INTO seg_per VALUES("30","123456789","Eventos","7","s");
INSERT INTO seg_per VALUES("31","123456789","Financieros","1","s");
INSERT INTO seg_per VALUES("32","123456789","Financieros","2","s");
INSERT INTO seg_per VALUES("33","123456789","Financieros","3","s");
INSERT INTO seg_per VALUES("34","123456789","Financieros","4","s");
INSERT INTO seg_per VALUES("35","123456789","Nomina","1","s");
INSERT INTO seg_per VALUES("36","123456789","Nomina","2","s");
INSERT INTO seg_per VALUES("37","123456789","Nomina","3","s");
INSERT INTO seg_per VALUES("38","123456789","Nomina","4","s");
INSERT INTO seg_per VALUES("39","123456789","Nomina","5","s");
INSERT INTO seg_per VALUES("40","123456789","Nomina","6","s");
INSERT INTO seg_per VALUES("41","123456789","Productos","1","s");
INSERT INTO seg_per VALUES("42","123456789","Productos","2","s");
INSERT INTO seg_per VALUES("43","123456789","Productos","3","s");
INSERT INTO seg_per VALUES("44","123456789","Productos","4","s");
INSERT INTO seg_per VALUES("45","123456789","Productos","5","s");
INSERT INTO seg_per VALUES("46","123456789","Productos","6","s");
INSERT INTO seg_per VALUES("47","123456789","Productos","7","s");
INSERT INTO seg_per VALUES("48","123456789","Productos","8","s");
INSERT INTO seg_per VALUES("49","123456789","Productos","9","s");
INSERT INTO seg_per VALUES("50","123456789","Productos","10","s");
INSERT INTO seg_per VALUES("51","123456789","Productos","11","s");
INSERT INTO seg_per VALUES("52","123456789","Productos","12","s");
INSERT INTO seg_per VALUES("53","123456789","Productos","13","s");
INSERT INTO seg_per VALUES("54","123456789","Proveedor","1","s");
INSERT INTO seg_per VALUES("55","123456789","Proveedor","2","s");
INSERT INTO seg_per VALUES("56","123456789","Reportes","1","s");
INSERT INTO seg_per VALUES("57","123456789","Reportes","2","s");
INSERT INTO seg_per VALUES("58","123456789","Reportes","3","s");
INSERT INTO seg_per VALUES("59","123456789","Reportes","4","s");
INSERT INTO seg_per VALUES("60","123456789","Reportes","5","s");
INSERT INTO seg_per VALUES("61","123456789","Reportes","7","s");
INSERT INTO seg_per VALUES("62","123456789","Reportes","8","s");
INSERT INTO seg_per VALUES("63","123456789","Reportes","9","s");
INSERT INTO seg_per VALUES("64","123456789","Sistemas","1","s");
INSERT INTO seg_per VALUES("65","123456789","Sistemas","2","s");
INSERT INTO seg_per VALUES("66","123456789","Sistemas","3","s");
INSERT INTO seg_per VALUES("67","123456789","Sistemas","4","s");
INSERT INTO seg_per VALUES("68","123456789","Sistemas","5","s");
INSERT INTO seg_per VALUES("69","123456789","Sistemas","6","s");
INSERT INTO seg_per VALUES("70","123456789","Sistemas","7","s");
INSERT INTO seg_per VALUES("71","123456789","Sistemas","8","s");
INSERT INTO seg_per VALUES("72","123456789","Sistemas","9","s");
INSERT INTO seg_per VALUES("73","123456789","Sistemas","10","s");
INSERT INTO seg_per VALUES("74","123456789","Sistemas","11","s");
INSERT INTO seg_per VALUES("75","123456789","Sistemas","12","s");
INSERT INTO seg_per VALUES("76","123456789","Sistemas","13","s");
INSERT INTO seg_per VALUES("77","123456789","Sistemas","14","s");
INSERT INTO seg_per VALUES("78","123456789","Sistemas","15","s");
INSERT INTO seg_per VALUES("79","123456789","Sistemas","16","s");
INSERT INTO seg_per VALUES("80","123456789","Sistemas","17","s");
INSERT INTO seg_per VALUES("81","123456789","Subir","1","s");
INSERT INTO seg_per VALUES("82","123456789","Subir","2","s");
INSERT INTO seg_per VALUES("83","123456789","Subir","3","s");
INSERT INTO seg_per VALUES("84","123456789","Tienda Online","1","s");
INSERT INTO seg_per VALUES("85","123456789","Tienda Online","2","s");
INSERT INTO seg_per VALUES("86","123456789","Tienda Online","3","s");
INSERT INTO seg_per VALUES("87","123456789","Tienda Online","4","s");
INSERT INTO seg_per VALUES("88","123456789","Tienda Online","5","s");
INSERT INTO seg_per VALUES("89","123456789","Tienda Online","6","s");
INSERT INTO seg_per VALUES("90","123456789","Tienda Online","7","s");
INSERT INTO seg_per VALUES("91","123456789","Tienda Online","8","s");
INSERT INTO seg_per VALUES("92","123456789","Tienda Online","9","s");
INSERT INTO seg_per VALUES("93","123456789","Usuarios","1","s");
INSERT INTO seg_per VALUES("94","123456789","Usuarios","2","s");
INSERT INTO seg_per VALUES("95","123456789","Usuarios","3","s");
INSERT INTO seg_per VALUES("96","123456789","Usuarios","4","s");
INSERT INTO seg_per VALUES("97","123456789","Vehiculo","1","s");
INSERT INTO seg_per VALUES("98","123456789","Vehiculo","2","s");
INSERT INTO seg_per VALUES("99","123456789","Vehiculo","3","s");
INSERT INTO seg_per VALUES("100","123456789","Vehiculo","4","s");
INSERT INTO seg_per VALUES("101","123456789","Vehiculo","5","s");
INSERT INTO seg_per VALUES("102","123456789","Vehiculo","6","s");
INSERT INTO seg_per VALUES("103","123456789","Vehiculo","7","s");
INSERT INTO seg_per VALUES("104","123456789","Vehiculo","8","s");
INSERT INTO seg_per VALUES("105","123456789","Vehiculo","9","s");
INSERT INTO seg_per VALUES("106","123456789","Vehiculo","10","s");
INSERT INTO seg_per VALUES("107","123456789","Vehiculo - Empresa de Seguros","1","s");
INSERT INTO seg_per VALUES("108","123456789","Vehiculo - Mantenimiento","1","s");
INSERT INTO seg_per VALUES("109","123456789","Vehiculo - Mantenimiento","2","s");
INSERT INTO seg_per VALUES("110","123456789","Vehiculo - Mantenimiento","3","s");
INSERT INTO seg_per VALUES("111","123456789","Vehiculo - Refacciones","1","s");
INSERT INTO seg_per VALUES("112","123456789","Vehiculo - Refacciones","2","s");
INSERT INTO seg_per VALUES("113","123456789","Vehiculo - Refacciones","3","s");
INSERT INTO seg_per VALUES("114","123456789","Vehiculo - Refacciones","4","s");
INSERT INTO seg_per VALUES("115","123456789","Vehiculo - Refacciones","5","s");
INSERT INTO seg_per VALUES("116","123456789","Venta","1","s");
INSERT INTO seg_per VALUES("117","123456789","Venta","2","s");
INSERT INTO seg_per VALUES("118","123456789","Venta","3","s");
INSERT INTO seg_per VALUES("119","123456789","Venta","4","s");
INSERT INTO seg_per VALUES("120","123456789","Venta","5","s");
INSERT INTO seg_per VALUES("121","123456789","Venta","6","s");
INSERT INTO seg_per VALUES("122","123456789","Venta","7","s");
INSERT INTO seg_per VALUES("123","123456789","Venta","8","s");
INSERT INTO seg_per VALUES("124","123456789","Venta","9","s");
INSERT INTO seg_per VALUES("125","123456789","Venta","10","s");
INSERT INTO seg_per VALUES("126","123456789","Venta","11","s");
INSERT INTO seg_per VALUES("127","123456789","Venta","12","s");
INSERT INTO seg_per VALUES("128","123456789","Venta","13","s");
INSERT INTO seg_per VALUES("254","123456789","Bodega","6","s");
INSERT INTO seg_per VALUES("255","123456789","Eventos","8","s");
INSERT INTO seg_per VALUES("256","123456789","Eventos","9","s");
INSERT INTO seg_per VALUES("519","123456789","Eventos","10","s");
INSERT INTO seg_per VALUES("520","123456789","Eventos","11","s");
INSERT INTO seg_per VALUES("521","123456789","Vehiculo","11","s");
INSERT INTO seg_per VALUES("522","123456789","Bodega","7","s");
INSERT INTO seg_per VALUES("523","123456789","Restaurante","1","s");
INSERT INTO seg_per VALUES("526","123456789","Restaurante","2","s");
INSERT INTO seg_per VALUES("527","123456789","Restaurante","3","s");
INSERT INTO seg_per VALUES("528","123456789","Restaurante","4","s");
INSERT INTO seg_per VALUES("529","123456789","Restaurante","5","s");
INSERT INTO seg_per VALUES("530","123456789","Bodega","8","s");
INSERT INTO seg_per VALUES("532","123456789","Bodega","9","s");
INSERT INTO seg_per VALUES("533","123456789","Bodega","10","s");
INSERT INTO seg_per VALUES("534","123456789","1","","n");
INSERT INTO seg_per VALUES("535","123456789","Bodega","11","s");
INSERT INTO seg_per VALUES("536","123456789","Reportes","10","s");
INSERT INTO seg_per VALUES("537","123456789","32","","n");
INSERT INTO seg_per VALUES("538","","Usuarios","1","n");
INSERT INTO seg_per VALUES("539","","Usuarios","2","n");
INSERT INTO seg_per VALUES("540","","Usuarios","3","n");
INSERT INTO seg_per VALUES("541","","Usuarios","4","n");
INSERT INTO seg_per VALUES("542","","Productos","1","n");
INSERT INTO seg_per VALUES("543","","Productos","2","n");
INSERT INTO seg_per VALUES("544","","Productos","3","n");
INSERT INTO seg_per VALUES("545","","Productos","4","n");
INSERT INTO seg_per VALUES("546","","Proveedor","1","n");
INSERT INTO seg_per VALUES("547","","Proveedor","2","n");
INSERT INTO seg_per VALUES("548","","Cliente","1","n");
INSERT INTO seg_per VALUES("549","","Cliente","2","n");
INSERT INTO seg_per VALUES("550","","Cliente","3","n");
INSERT INTO seg_per VALUES("551","","Cliente","4","n");
INSERT INTO seg_per VALUES("552","","Nomina","1","n");
INSERT INTO seg_per VALUES("553","","Nomina","2","n");
INSERT INTO seg_per VALUES("554","","Nomina","3","n");
INSERT INTO seg_per VALUES("555","","Nomina","4","n");
INSERT INTO seg_per VALUES("556","","Nomina","5","n");
INSERT INTO seg_per VALUES("557","","Nomina","6","n");
INSERT INTO seg_per VALUES("558","","Sistemas","1","n");
INSERT INTO seg_per VALUES("559","","Bodega","1","n");
INSERT INTO seg_per VALUES("560","","Bodega","2","n");
INSERT INTO seg_per VALUES("561","","Bodega","3","n");
INSERT INTO seg_per VALUES("562","","Bodega","4","n");
INSERT INTO seg_per VALUES("563","","Sistemas","2","n");
INSERT INTO seg_per VALUES("564","","Venta","1","n");
INSERT INTO seg_per VALUES("565","","Venta","2","n");
INSERT INTO seg_per VALUES("566","","Venta","3","n");
INSERT INTO seg_per VALUES("567","","Sistemas","3","n");
INSERT INTO seg_per VALUES("568","","Sistemas","4","n");
INSERT INTO seg_per VALUES("569","","Cuentas","1","n");
INSERT INTO seg_per VALUES("570","","Productos","5","n");
INSERT INTO seg_per VALUES("571","","Sistemas","5","n");
INSERT INTO seg_per VALUES("572","","Reportes","1","n");
INSERT INTO seg_per VALUES("573","","Venta","4","n");
INSERT INTO seg_per VALUES("574","","Venta","5","n");
INSERT INTO seg_per VALUES("575","","Comisiones","1","n");
INSERT INTO seg_per VALUES("576","","Financieros","1","n");
INSERT INTO seg_per VALUES("577","","Financieros","2","n");
INSERT INTO seg_per VALUES("578","","Financieros","3","n");
INSERT INTO seg_per VALUES("579","","Sistemas","6","n");
INSERT INTO seg_per VALUES("580","","Productos","6","n");
INSERT INTO seg_per VALUES("581","","Financieros","4","n");
INSERT INTO seg_per VALUES("582","","Venta","6","n");
INSERT INTO seg_per VALUES("583","","Reportes","2","n");
INSERT INTO seg_per VALUES("584","","Reportes","3","n");
INSERT INTO seg_per VALUES("585","","Productos","7","n");
INSERT INTO seg_per VALUES("586","","Sistemas","7","n");
INSERT INTO seg_per VALUES("587","","Venta","7","n");
INSERT INTO seg_per VALUES("588","","Sistemas","8","n");
INSERT INTO seg_per VALUES("589","","Venta","8","n");
INSERT INTO seg_per VALUES("590","","Subir","1","n");
INSERT INTO seg_per VALUES("591","","Subir","2","n");
INSERT INTO seg_per VALUES("592","","Sistemas","9","n");
INSERT INTO seg_per VALUES("593","","Anulaciones","1","n");
INSERT INTO seg_per VALUES("594","","Anulaciones","2","n");
INSERT INTO seg_per VALUES("595","","Venta","9","n");
INSERT INTO seg_per VALUES("596","","Productos","8","n");
INSERT INTO seg_per VALUES("597","","Productos","9","n");
INSERT INTO seg_per VALUES("598","","Bodega","5","n");
INSERT INTO seg_per VALUES("599","","Asistencias","3","n");
INSERT INTO seg_per VALUES("600","","Asistencias","4","n");
INSERT INTO seg_per VALUES("601","","Asistencias","5","n");
INSERT INTO seg_per VALUES("602","","Asistencias","6","n");
INSERT INTO seg_per VALUES("603","","Productos","10","n");
INSERT INTO seg_per VALUES("604","","Cliente","5","n");
INSERT INTO seg_per VALUES("605","","Venta","10","n");
INSERT INTO seg_per VALUES("606","","Sistemas","10","n");
INSERT INTO seg_per VALUES("607","","Sistemas","11","n");
INSERT INTO seg_per VALUES("608","","Sistemas","12","n");
INSERT INTO seg_per VALUES("609","","Sistemas","13","n");
INSERT INTO seg_per VALUES("610","","Venta","11","n");
INSERT INTO seg_per VALUES("611","","Cliente","6","n");
INSERT INTO seg_per VALUES("612","","Reportes","4","n");
INSERT INTO seg_per VALUES("613","","Reportes","5","n");
INSERT INTO seg_per VALUES("614","","Asistencias","7","n");
INSERT INTO seg_per VALUES("615","","Asistencias","8","n");
INSERT INTO seg_per VALUES("616","","Subir","3","n");
INSERT INTO seg_per VALUES("617","","Sistemas","14","n");
INSERT INTO seg_per VALUES("618","","Sistemas","15","n");
INSERT INTO seg_per VALUES("619","","Vehiculo","1","n");
INSERT INTO seg_per VALUES("620","","Vehiculo","2","n");
INSERT INTO seg_per VALUES("621","","Vehiculo","3","n");
INSERT INTO seg_per VALUES("622","","Sistemas","16","n");
INSERT INTO seg_per VALUES("623","","Vehiculo","4","n");
INSERT INTO seg_per VALUES("624","","Vehiculo","5","n");
INSERT INTO seg_per VALUES("625","","Vehiculo","6","n");
INSERT INTO seg_per VALUES("626","","Vehiculo","7","n");
INSERT INTO seg_per VALUES("627","","Vehiculo","8","n");
INSERT INTO seg_per VALUES("628","","Vehiculo","9","n");
INSERT INTO seg_per VALUES("629","","Sistemas","17","n");
INSERT INTO seg_per VALUES("630","","Reportes","7","n");
INSERT INTO seg_per VALUES("631","","Productos","11","n");
INSERT INTO seg_per VALUES("632","","Tienda Online","1","n");
INSERT INTO seg_per VALUES("633","","Productos","12","n");
INSERT INTO seg_per VALUES("634","","Productos","13","n");
INSERT INTO seg_per VALUES("635","","Tienda Online","2","n");
INSERT INTO seg_per VALUES("636","","Tienda Online","3","n");
INSERT INTO seg_per VALUES("637","","Tienda Online","4","n");
INSERT INTO seg_per VALUES("638","","Tienda Online","5","n");
INSERT INTO seg_per VALUES("639","","Asistencias","9","n");
INSERT INTO seg_per VALUES("640","","Cliente","7","n");
INSERT INTO seg_per VALUES("641","","Tienda Online","6","n");
INSERT INTO seg_per VALUES("642","","Tienda Online","7","n");
INSERT INTO seg_per VALUES("643","","Reportes","8","n");
INSERT INTO seg_per VALUES("644","","Reportes","9","n");
INSERT INTO seg_per VALUES("645","","Tienda Online","8","n");
INSERT INTO seg_per VALUES("646","","Tienda Online","9","n");
INSERT INTO seg_per VALUES("647","","Vehiculo","10","n");
INSERT INTO seg_per VALUES("648","","Vehiculo - Refacciones","1","n");
INSERT INTO seg_per VALUES("649","","Vehiculo - Refacciones","2","n");
INSERT INTO seg_per VALUES("650","","Vehiculo - Refacciones","3","n");
INSERT INTO seg_per VALUES("651","","Vehiculo - Refacciones","4","n");
INSERT INTO seg_per VALUES("652","","Vehiculo - Refacciones","5","n");
INSERT INTO seg_per VALUES("653","","Vehiculo - Empresa de Seguros","1","n");
INSERT INTO seg_per VALUES("654","","Venta","12","n");
INSERT INTO seg_per VALUES("655","","Vehiculo - Mantenimiento","1","n");
INSERT INTO seg_per VALUES("656","","Vehiculo - Mantenimiento","2","n");
INSERT INTO seg_per VALUES("657","","Vehiculo - Mantenimiento","3","n");
INSERT INTO seg_per VALUES("658","","Venta","13","n");
INSERT INTO seg_per VALUES("659","","Eventos","1","n");
INSERT INTO seg_per VALUES("660","","Eventos","2","n");
INSERT INTO seg_per VALUES("661","","Eventos","3","n");
INSERT INTO seg_per VALUES("662","","Eventos","4","n");
INSERT INTO seg_per VALUES("663","","Eventos","5","n");
INSERT INTO seg_per VALUES("664","","Eventos","6","n");
INSERT INTO seg_per VALUES("665","","Eventos","7","n");
INSERT INTO seg_per VALUES("666","","Bodega","6","n");
INSERT INTO seg_per VALUES("667","","Eventos","8","n");
INSERT INTO seg_per VALUES("668","","Eventos","9","n");
INSERT INTO seg_per VALUES("669","","Eventos","10","n");
INSERT INTO seg_per VALUES("670","","Eventos","11","n");
INSERT INTO seg_per VALUES("671","","Vehiculo","11","n");
INSERT INTO seg_per VALUES("672","","Bodega","7","n");
INSERT INTO seg_per VALUES("673","","Restaurante","1","n");
INSERT INTO seg_per VALUES("674","","Restaurante","2","n");
INSERT INTO seg_per VALUES("675","","Restaurante","3","n");
INSERT INTO seg_per VALUES("676","","Restaurante","4","n");
INSERT INTO seg_per VALUES("677","","Restaurante","5","n");
INSERT INTO seg_per VALUES("678","","Bodega","8","n");
INSERT INTO seg_per VALUES("679","","Bodega","9","n");
INSERT INTO seg_per VALUES("680","","Bodega","10","n");
INSERT INTO seg_per VALUES("681","","Bodega","11","n");
INSERT INTO seg_per VALUES("682","","Reportes","10","n");
INSERT INTO seg_per VALUES("683","5566","Usuarios","1","n");
INSERT INTO seg_per VALUES("684","5566","Usuarios","2","n");
INSERT INTO seg_per VALUES("685","5566","Usuarios","3","n");
INSERT INTO seg_per VALUES("686","5566","Usuarios","4","n");
INSERT INTO seg_per VALUES("687","5566","Productos","1","n");
INSERT INTO seg_per VALUES("688","5566","Productos","2","n");
INSERT INTO seg_per VALUES("689","5566","Productos","3","n");
INSERT INTO seg_per VALUES("690","5566","Productos","4","n");
INSERT INTO seg_per VALUES("691","5566","Proveedor","1","n");
INSERT INTO seg_per VALUES("692","5566","Proveedor","2","n");
INSERT INTO seg_per VALUES("693","5566","Cliente","1","s");
INSERT INTO seg_per VALUES("694","5566","Cliente","2","s");
INSERT INTO seg_per VALUES("695","5566","Cliente","3","n");
INSERT INTO seg_per VALUES("696","5566","Cliente","4","s");
INSERT INTO seg_per VALUES("697","5566","Nomina","1","n");
INSERT INTO seg_per VALUES("698","5566","Nomina","2","n");
INSERT INTO seg_per VALUES("699","5566","Nomina","3","n");
INSERT INTO seg_per VALUES("700","5566","Nomina","4","n");
INSERT INTO seg_per VALUES("701","5566","Nomina","5","n");
INSERT INTO seg_per VALUES("702","5566","Nomina","6","n");
INSERT INTO seg_per VALUES("703","5566","Sistemas","1","n");
INSERT INTO seg_per VALUES("704","5566","Bodega","1","n");
INSERT INTO seg_per VALUES("705","5566","Bodega","2","n");
INSERT INTO seg_per VALUES("706","5566","Bodega","3","n");
INSERT INTO seg_per VALUES("707","5566","Bodega","4","n");
INSERT INTO seg_per VALUES("708","5566","Sistemas","2","n");
INSERT INTO seg_per VALUES("709","5566","Venta","1","n");
INSERT INTO seg_per VALUES("710","5566","Venta","2","n");
INSERT INTO seg_per VALUES("711","5566","Venta","3","n");
INSERT INTO seg_per VALUES("712","5566","Sistemas","3","n");
INSERT INTO seg_per VALUES("713","5566","Sistemas","4","n");
INSERT INTO seg_per VALUES("714","5566","Cuentas","1","n");
INSERT INTO seg_per VALUES("715","5566","Productos","5","n");
INSERT INTO seg_per VALUES("716","5566","Sistemas","5","n");
INSERT INTO seg_per VALUES("717","5566","Reportes","1","n");
INSERT INTO seg_per VALUES("718","5566","Venta","4","n");
INSERT INTO seg_per VALUES("719","5566","Venta","5","n");
INSERT INTO seg_per VALUES("720","5566","Comisiones","1","n");
INSERT INTO seg_per VALUES("721","5566","Financieros","1","n");
INSERT INTO seg_per VALUES("722","5566","Financieros","2","n");
INSERT INTO seg_per VALUES("723","5566","Financieros","3","n");
INSERT INTO seg_per VALUES("724","5566","Sistemas","6","n");
INSERT INTO seg_per VALUES("725","5566","Productos","6","n");
INSERT INTO seg_per VALUES("726","5566","Financieros","4","n");
INSERT INTO seg_per VALUES("727","5566","Venta","6","n");
INSERT INTO seg_per VALUES("728","5566","Reportes","2","n");
INSERT INTO seg_per VALUES("729","5566","Reportes","3","n");
INSERT INTO seg_per VALUES("730","5566","Productos","7","n");
INSERT INTO seg_per VALUES("731","5566","Sistemas","7","n");
INSERT INTO seg_per VALUES("732","5566","Venta","7","n");
INSERT INTO seg_per VALUES("733","5566","Sistemas","8","n");
INSERT INTO seg_per VALUES("734","5566","Venta","8","n");
INSERT INTO seg_per VALUES("735","5566","Subir","1","n");
INSERT INTO seg_per VALUES("736","5566","Subir","2","n");
INSERT INTO seg_per VALUES("737","5566","Sistemas","9","n");
INSERT INTO seg_per VALUES("738","5566","Anulaciones","1","s");
INSERT INTO seg_per VALUES("739","5566","Anulaciones","2","s");
INSERT INTO seg_per VALUES("740","5566","Venta","9","n");
INSERT INTO seg_per VALUES("741","5566","Productos","8","n");
INSERT INTO seg_per VALUES("742","5566","Productos","9","n");
INSERT INTO seg_per VALUES("743","5566","Bodega","5","n");
INSERT INTO seg_per VALUES("744","5566","Asistencias","3","n");
INSERT INTO seg_per VALUES("745","5566","Asistencias","4","n");
INSERT INTO seg_per VALUES("746","5566","Asistencias","5","n");
INSERT INTO seg_per VALUES("747","5566","Asistencias","6","n");
INSERT INTO seg_per VALUES("748","5566","Productos","10","n");
INSERT INTO seg_per VALUES("749","5566","Cliente","5","n");
INSERT INTO seg_per VALUES("750","5566","Venta","10","n");
INSERT INTO seg_per VALUES("751","5566","Sistemas","10","n");
INSERT INTO seg_per VALUES("752","5566","Sistemas","11","n");
INSERT INTO seg_per VALUES("753","5566","Sistemas","12","n");
INSERT INTO seg_per VALUES("754","5566","Sistemas","13","n");
INSERT INTO seg_per VALUES("755","5566","Venta","11","n");
INSERT INTO seg_per VALUES("756","5566","Cliente","6","n");
INSERT INTO seg_per VALUES("757","5566","Reportes","4","n");
INSERT INTO seg_per VALUES("758","5566","Reportes","5","n");
INSERT INTO seg_per VALUES("759","5566","Asistencias","7","n");
INSERT INTO seg_per VALUES("760","5566","Asistencias","8","n");
INSERT INTO seg_per VALUES("761","5566","Subir","3","n");
INSERT INTO seg_per VALUES("762","5566","Sistemas","14","n");
INSERT INTO seg_per VALUES("763","5566","Sistemas","15","n");
INSERT INTO seg_per VALUES("764","5566","Vehiculo","1","n");
INSERT INTO seg_per VALUES("765","5566","Vehiculo","2","n");
INSERT INTO seg_per VALUES("766","5566","Vehiculo","3","n");
INSERT INTO seg_per VALUES("767","5566","Sistemas","16","n");
INSERT INTO seg_per VALUES("768","5566","Vehiculo","4","n");
INSERT INTO seg_per VALUES("769","5566","Vehiculo","5","n");
INSERT INTO seg_per VALUES("770","5566","Vehiculo","6","n");
INSERT INTO seg_per VALUES("771","5566","Vehiculo","7","n");
INSERT INTO seg_per VALUES("772","5566","Vehiculo","8","n");
INSERT INTO seg_per VALUES("773","5566","Vehiculo","9","n");
INSERT INTO seg_per VALUES("774","5566","Sistemas","17","n");
INSERT INTO seg_per VALUES("775","5566","Reportes","7","n");
INSERT INTO seg_per VALUES("776","5566","Productos","11","n");
INSERT INTO seg_per VALUES("777","5566","Tienda Online","1","n");
INSERT INTO seg_per VALUES("778","5566","Productos","12","n");
INSERT INTO seg_per VALUES("779","5566","Productos","13","n");
INSERT INTO seg_per VALUES("780","5566","Tienda Online","2","n");
INSERT INTO seg_per VALUES("781","5566","Tienda Online","3","n");
INSERT INTO seg_per VALUES("782","5566","Tienda Online","4","n");
INSERT INTO seg_per VALUES("783","5566","Tienda Online","5","n");
INSERT INTO seg_per VALUES("784","5566","Asistencias","9","n");
INSERT INTO seg_per VALUES("785","5566","Cliente","7","n");
INSERT INTO seg_per VALUES("786","5566","Tienda Online","6","n");
INSERT INTO seg_per VALUES("787","5566","Tienda Online","7","n");
INSERT INTO seg_per VALUES("788","5566","Reportes","8","n");
INSERT INTO seg_per VALUES("789","5566","Reportes","9","n");
INSERT INTO seg_per VALUES("790","5566","Tienda Online","8","n");
INSERT INTO seg_per VALUES("791","5566","Tienda Online","9","n");
INSERT INTO seg_per VALUES("792","5566","Vehiculo","10","n");
INSERT INTO seg_per VALUES("793","5566","Vehiculo - Refacciones","1","n");
INSERT INTO seg_per VALUES("794","5566","Vehiculo - Refacciones","2","n");
INSERT INTO seg_per VALUES("795","5566","Vehiculo - Refacciones","3","n");
INSERT INTO seg_per VALUES("796","5566","Vehiculo - Refacciones","4","n");
INSERT INTO seg_per VALUES("797","5566","Vehiculo - Refacciones","5","n");
INSERT INTO seg_per VALUES("798","5566","Vehiculo - Empresa de Seguros","1","n");
INSERT INTO seg_per VALUES("799","5566","Venta","12","n");
INSERT INTO seg_per VALUES("800","5566","Vehiculo - Mantenimiento","1","n");
INSERT INTO seg_per VALUES("801","5566","Vehiculo - Mantenimiento","2","n");
INSERT INTO seg_per VALUES("802","5566","Vehiculo - Mantenimiento","3","n");
INSERT INTO seg_per VALUES("803","5566","Venta","13","n");
INSERT INTO seg_per VALUES("804","5566","Eventos","1","n");
INSERT INTO seg_per VALUES("805","5566","Eventos","2","n");
INSERT INTO seg_per VALUES("806","5566","Eventos","3","n");
INSERT INTO seg_per VALUES("807","5566","Eventos","4","n");
INSERT INTO seg_per VALUES("808","5566","Eventos","5","n");
INSERT INTO seg_per VALUES("809","5566","Eventos","6","n");
INSERT INTO seg_per VALUES("810","5566","Eventos","7","n");
INSERT INTO seg_per VALUES("811","5566","Bodega","6","n");
INSERT INTO seg_per VALUES("812","5566","Eventos","8","n");
INSERT INTO seg_per VALUES("813","5566","Eventos","9","n");
INSERT INTO seg_per VALUES("814","5566","Eventos","10","n");
INSERT INTO seg_per VALUES("815","5566","Eventos","11","n");
INSERT INTO seg_per VALUES("816","5566","Vehiculo","11","n");
INSERT INTO seg_per VALUES("817","5566","Bodega","7","n");
INSERT INTO seg_per VALUES("818","5566","Restaurante","1","n");
INSERT INTO seg_per VALUES("819","5566","Restaurante","2","n");
INSERT INTO seg_per VALUES("820","5566","Restaurante","3","n");
INSERT INTO seg_per VALUES("821","5566","Restaurante","4","n");
INSERT INTO seg_per VALUES("822","5566","Restaurante","5","n");
INSERT INTO seg_per VALUES("823","5566","Bodega","8","n");
INSERT INTO seg_per VALUES("824","5566","Bodega","9","n");
INSERT INTO seg_per VALUES("825","5566","Bodega","10","n");
INSERT INTO seg_per VALUES("826","5566","Bodega","11","n");
INSERT INTO seg_per VALUES("827","5566","Reportes","10","n");
INSERT INTO seg_per VALUES("828","123456789","Restaurante - Insumos","1","s");
INSERT INTO seg_per VALUES("829","123456789","Restaurante - Insumos","2","s");
INSERT INTO seg_per VALUES("830","123456789","Restaurante - Insumos","3","s");
INSERT INTO seg_per VALUES("831","123456789","Servicios","1","s");
INSERT INTO seg_per VALUES("832","123456789","Servicios","2","s");
INSERT INTO seg_per VALUES("833","123456789","Servicios","3","s");
INSERT INTO seg_per VALUES("834","123456789","Reportes","11","s");
INSERT INTO seg_per VALUES("835","123456789","Servicios","4","s");
INSERT INTO seg_per VALUES("836","123456789","Servicios","5","s");
INSERT INTO seg_per VALUES("837","123456789","Servicios","6","s");
INSERT INTO seg_per VALUES("838","123456789","Venta","14","s");
INSERT INTO seg_per VALUES("839","123456789","Bodega","13","s");
INSERT INTO seg_per VALUES("840","123456789","Sistemas","18","s");
INSERT INTO seg_per VALUES("841","123456789","Sistemas","19","s");
INSERT INTO seg_per VALUES("842","123456789","Restaurante - Insumos","4","s");
INSERT INTO seg_per VALUES("843","123456789","Restaurante - Insumos","5","s");
INSERT INTO seg_per VALUES("844","123456789","Venta","15","s");
INSERT INTO seg_per VALUES("845","123456789","Sistemas","20","s");
INSERT INTO seg_per VALUES("846","123456789","Venta","16","s");


CREATE TABLE `ser_comp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `articulo` varchar(255) NOT NULL,
  `nota` text NOT NULL,
  `cliente` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO ser_comp VALUES("1","TELEVISOR","NO FUNCIONA LA TV NO PRENDE, ESTA EN ESTADO ACEPTABLE","1","2015-10-12","17:29:27","123456789");
INSERT INTO ser_comp VALUES("2","TV LG de 15 PULGADAS","TIENE FALLAS EN EL ENCENDIDO, SE APAGA SOLO DESPUES DE 20 MINUTOS DE ESTAR PRENDIDO, EL TV NO TIENEN NINGUN DANO FISICO","1","2015-10-13","21:14:20","123456789");


CREATE TABLE `ser_cxc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `cliente` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO ser_cxc VALUES("5","4","1","700","2015-10-16","09:57:19");
INSERT INTO ser_cxc VALUES("6","5","1","700","2015-10-16","10:07:35");


CREATE TABLE `ser_cxc_abono` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `metodopago` varchar(255) NOT NULL,
  `tasa` varchar(255) NOT NULL,
  `ntasa` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO ser_cxc_abono VALUES("2","4","0","123456789","2015-10-16","09:57:19","1","","","1");
INSERT INTO ser_cxc_abono VALUES("3","5","0","123456789","2015-10-16","10:07:35","1","","","1");
INSERT INTO ser_cxc_abono VALUES("4","4","700","123456789","2015-10-16","14:35:50","1","","","1");
INSERT INTO ser_cxc_abono VALUES("5","5","100","123456789","2015-10-16","14:35:50","1","","","1");
INSERT INTO ser_cxc_abono VALUES("6","5","100","123456789","2015-10-16","14:48:46","1","","","1");


CREATE TABLE `ser_factura` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `folio` varchar(255) NOT NULL,
  `factura` int(11) NOT NULL,
  `articulo` varchar(255) NOT NULL,
  `nota` text NOT NULL,
  `falla` text NOT NULL,
  `cod_cliente` varchar(255) NOT NULL,
  `nom_cliente` varchar(255) NOT NULL,
  `dir_cliente` varchar(255) NOT NULL,
  `tel_cliente` varchar(255) NOT NULL,
  `cel_cliente` varchar(255) NOT NULL,
  `lis_cliente` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usuario` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  `vdescuento` varchar(255) NOT NULL,
  `iva` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO ser_factura VALUES("2","A","1","TELEVISOR","Ninguna observacion","NO FUNCIONA LA TV NO PRENDE, ESTA EN ESTADO ACEPTABLE","1","PUBLICO GENERAL",".dir","NO","34","1","2015-10-15","19:19:13","123456789","1","672.8","0","0","");
INSERT INTO ser_factura VALUES("3","A","2","TV LG de 15 PULGADAS","Ninguna","TIENE FALLAS EN EL ENCENDIDO, SE APAGA SOLO DESPUES DE 20 MINUTOS DE ESTAR PRENDIDO, EL TV NO TIENEN NINGUN DANO FISICO","1","PUBLICO GENERAL",".dir","NO","34","1","2015-10-16","09:43:50","123456789","1","788.8","0","0","");
INSERT INTO ser_factura VALUES("4","A","3","","","","1","PUBLICO GENERAL",".dir","NO","34","1","2015-10-16","09:57:19","123456789","1","788.8","0","0","");
INSERT INTO ser_factura VALUES("5","A","4","Articulo","observacion","no funciona la tv ","1","PUBLICO GENERAL",".dir","NO","34","1","2015-10-16","10:07:35","123456789","1","788.8","0","0","");
INSERT INTO ser_factura VALUES("6","A","5","TELEVISO","NINGUNA","NO SIRVE","1","PUBLICO GENERAL",".dir","NO","34","1","2015-10-16","10:54:25","123456789","1","355.2","5","16","16");


CREATE TABLE `ser_factura_cargo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `concepto` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `factura` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `ser_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `familia` varchar(255) NOT NULL,
  `grupo` varchar(255) NOT NULL,
  `subgrupo` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

INSERT INTO ser_info VALUES("1","10","Prueba Servicio Numero S","106","109","110","s");
INSERT INTO ser_info VALUES("2","12","SERVC","106","108","110","s");
INSERT INTO ser_info VALUES("3","13","SERVICIO","106","108","110","s");
INSERT INTO ser_info VALUES("4","600","INSTALACION","106","108","110","s");


CREATE TABLE `ser_info_desactivado` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `familia` varchar(255) NOT NULL,
  `grupo` varchar(255) NOT NULL,
  `subgrupo` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `ser_precio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `servicio` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `lista` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

INSERT INTO ser_precio VALUES("1","10","100","1");
INSERT INTO ser_precio VALUES("2","10","200","2");
INSERT INTO ser_precio VALUES("3","10","300","3");
INSERT INTO ser_precio VALUES("4","10","400","4");
INSERT INTO ser_precio VALUES("5","10","500","5");
INSERT INTO ser_precio VALUES("6","10","450","6");
INSERT INTO ser_precio VALUES("7","12","100","1");
INSERT INTO ser_precio VALUES("8","12","200","2");
INSERT INTO ser_precio VALUES("9","12","300","3");
INSERT INTO ser_precio VALUES("10","12","400","4");
INSERT INTO ser_precio VALUES("11","12","500","5");
INSERT INTO ser_precio VALUES("12","12","600","6");
INSERT INTO ser_precio VALUES("13","13","100","1");
INSERT INTO ser_precio VALUES("14","13","200","2");
INSERT INTO ser_precio VALUES("15","13","0","3");
INSERT INTO ser_precio VALUES("16","13","0","4");
INSERT INTO ser_precio VALUES("17","13","0","5");
INSERT INTO ser_precio VALUES("18","13","0","6");
INSERT INTO ser_precio VALUES("19","600","100","1");
INSERT INTO ser_precio VALUES("20","600","200","2");
INSERT INTO ser_precio VALUES("21","600","300","3");
INSERT INTO ser_precio VALUES("22","600","0","4");
INSERT INTO ser_precio VALUES("23","600","0","5");
INSERT INTO ser_precio VALUES("24","600","0","6");


CREATE TABLE `ser_tmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tmp1` text NOT NULL,
  `tmp2` text NOT NULL,
  `tmp3` text NOT NULL,
  `tmp4` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO ser_tmp VALUES("9","","","123456789","");


CREATE TABLE `ser_tmp_venta1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `nota` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `usuario` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `ser_tmp_venta2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `usuario` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `ser_venta1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `nota` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `relacion` varchar(255) NOT NULL,
  `grupo` varchar(255) NOT NULL,
  `subgrupo` varchar(255) NOT NULL,
  `familia` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO ser_venta1 VALUES("3","10","Prueba Servicio Numero S","Hola mundo","100","4","109","110","106","1","2015-10-16","09:57:19");
INSERT INTO ser_venta1 VALUES("4","10","Prueba Servicio Numero S","Hola mundo","100","5","109","110","106","1","2015-10-16","10:07:35");
INSERT INTO ser_venta1 VALUES("5","10","Prueba Servicio Numero S","","100","6","109","110","106","1","2015-10-16","10:54:25");


CREATE TABLE `ser_venta2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `relacion` varchar(255) NOT NULL,
  `grupo` varchar(255) NOT NULL,
  `um` varchar(255) NOT NULL,
  `subgrupo` varchar(255) NOT NULL,
  `familia` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO ser_venta2 VALUES("1","12","Producto de Prueba","4","120","4","1","Unidad","5","92","2015-10-16","09:57:19","1");
INSERT INTO ser_venta2 VALUES("2","13","Producto de Prueba dos","1","100","4","1","Unidad","2","3","2015-10-16","09:57:19","1");
INSERT INTO ser_venta2 VALUES("3","12","Producto de Prueba","4","120","5","1","Unidad","5","92","2015-10-16","10:07:35","1");
INSERT INTO ser_venta2 VALUES("4","13","Producto de Prueba dos","1","100","5","1","Unidad","2","3","2015-10-16","10:07:35","1");
INSERT INTO ser_venta2 VALUES("5","12","Producto de Prueba","1","120","6","1","Unidad","5","92","2015-10-16","10:54:25","1");
INSERT INTO ser_venta2 VALUES("6","13","Producto de Prueba dos","1","100","6","1","Unidad","2","3","2015-10-16","10:54:25","1");


CREATE TABLE `sucursal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) NOT NULL,
  `ciudad` varchar(255) NOT NULL,
  `dir` varchar(255) NOT NULL,
  `tel` varchar(255) NOT NULL,
  `correo` varchar(255) NOT NULL,
  `calle` varchar(255) NOT NULL,
  `noext` varchar(255) NOT NULL,
  `noint` varchar(255) NOT NULL,
  `colonia` varchar(255) NOT NULL,
  `localidad` varchar(255) NOT NULL,
  `municipio` varchar(255) NOT NULL,
  `estado2` varchar(255) NOT NULL,
  `pais` varchar(255) NOT NULL,
  `cp` varchar(255) NOT NULL,
  `rfc` varchar(255) NOT NULL,
  `folio` varchar(255) NOT NULL,
  `serie` varchar(255) NOT NULL,
  `auto` varchar(255) NOT NULL,
  `propina` double NOT NULL,
  `tama` varchar(255) NOT NULL,
  `letra` varchar(255) NOT NULL,
  `ve_auto` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO sucursal VALUES("1","Principal","Estado de Mexico","Tecamac","t","correo","calle","no ext","no int","colonia","localidad","municipip","tek","pais","codigopostal","rfc","","00001000000302642674","n","5","340","12","s");
INSERT INTO sucursal VALUES("2","Secundario","Monterrey","NL","11","","","","","","","","","","","","","00001000000302642674","n","0","340","12","n");


CREATE TABLE `t_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `producto` varchar(255) NOT NULL,
  `ref` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `costo` varchar(255) NOT NULL,
  `lista` varchar(255) NOT NULL,
  `rete` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `t_retener` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `descrip` longtext NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `cliente` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `tmp_comi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comi` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `tmp_trans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `origen` varchar(255) NOT NULL,
  `final` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `tmp_venta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cliente` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=latin1;



CREATE TABLE `tmp_venta_caja` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cod` varchar(255) NOT NULL,
  `ref` varchar(255) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `val` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;



CREATE TABLE `tmp_venta_cargo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `concepto` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `tmp_venta_concepto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `concepto` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `cargo` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;



CREATE TABLE `trans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `origen` varchar(255) NOT NULL,
  `final` varchar(255) NOT NULL,
  `producto` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `nota` longtext NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  `relacion` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

INSERT INTO trans VALUES("1","1","2","12","Producto de Prueba","10","nada","2015-05-09","15:03:36","123456789","");
INSERT INTO trans VALUES("2","1","2","13","Producto de Prueba dos","25","nada","2015-06-08","15:05:20","123456789","");
INSERT INTO trans VALUES("3","1","2","123","PRUEBA","10","nada","2015-08-23","14:28:36","123456789","");
INSERT INTO trans VALUES("4","1","2","12","Producto de Prueba","2","nada","2015-09-06","15:59:32","123456789","");
INSERT INTO trans VALUES("5","2","1","12","Producto de Prueba","1","nada","2015-09-14","11:00:59","123456789","");
INSERT INTO trans VALUES("6","2","1","12","Producto de Prueba","1","nada","2015-09-14","11:33:01","123456789","1");
INSERT INTO trans VALUES("7","1","2","12","Producto de Prueba","3","nada","2015-09-14","11:43:11","123456789","2");


CREATE TABLE `trans_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `origen` varchar(255) NOT NULL,
  `final` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `lista` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO trans_detalle VALUES("1","13","Producto de Prueba dos","1","2","1","1");
INSERT INTO trans_detalle VALUES("2","12","Producto de Prueba","1","2","4","3");


CREATE TABLE `trans_encabezado` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usuario` varchar(255) NOT NULL,
  `origen` varchar(255) NOT NULL,
  `final` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO trans_encabezado VALUES("1","2015-09-14","11:33:01","123456789","2","1");
INSERT INTO trans_encabezado VALUES("2","2015-09-14","11:43:11","123456789","1","2");


CREATE TABLE `trans_lista` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `nota` varchar(266) NOT NULL,
  `origen` varchar(255) NOT NULL,
  `final` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO trans_lista VALUES("1","JORGE","MINDA","1","2");
INSERT INTO trans_lista VALUES("2","hola","hola","1","2");
INSERT INTO trans_lista VALUES("3","prueba de refacciones","ninguna opcoon","1","2");


CREATE TABLE `username` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usu` varchar(255) NOT NULL,
  `con` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `cargo` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `caja` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

INSERT INTO username VALUES("1","123456789","caa297fe47671dbb6c4ba4547ebef3a4a022cc91","a","Administrador","1","s","Principal");
INSERT INTO username VALUES("3","15","c0b56e05b4f234bd2ee0f4ac624c98d9a4615d69","c","cliente","1","s","");
INSERT INTO username VALUES("4","5566","7229d98cfb771336daaebdde53206a658a76e460","u","5","1","s","NINGUNA");
INSERT INTO username VALUES("5","58578","5ea720372418c448d69446b6e04a316279793c98","c","Cliente","1","s","");
INSERT INTO username VALUES("6","16","d745e06106d97b8dafaaf5310abe4dca8905a615","c","Cliente","1","s","");
INSERT INTO username VALUES("7","5555","730cdf062eed2454e64723c83d45b243c277bcb0","u","4","1","s","2");
INSERT INTO username VALUES("8","1","6a1ae6807bce538d8b1e08dc07e86742c1387c2d","c","Cliente","1","s","");


CREATE TABLE `ve_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `linea1` text NOT NULL,
  `linea2` text NOT NULL,
  `linea3` text NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO ve_info VALUES("1","hola","como","estas","2015-06-18","14:23:47","123456789","1");
INSERT INTO ve_info VALUES("2","bien","gracias","y tu","2015-06-18","14:26:27","123456789","2");


CREATE TABLE `ve_lista` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lista` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO ve_lista VALUES("1","1","1");
INSERT INTO ve_lista VALUES("2","2","1");
INSERT INTO ve_lista VALUES("3","3","1");


CREATE TABLE `ve_veh_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `placa` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `modelo` varchar(255) NOT NULL,
  `nota` longtext NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO ve_veh_detalle VALUES("1","xyz-123","3","Rojo","2014","Ninguna","s");
INSERT INTO ve_veh_detalle VALUES("2","XXX-2","4","AZUL","2014","NINGUNA","s");


CREATE TABLE `vehiculo_co_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `compra` varchar(255) NOT NULL,
  `pro` varchar(255) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `recibido` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `vehiculo_co_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entregada` varchar(10) NOT NULL,
  `fentregada` date NOT NULL,
  `hentregada` time NOT NULL,
  `uentregada` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  `fechae` date NOT NULL,
  `destino` varchar(255) NOT NULL,
  `contado` varchar(255) NOT NULL,
  `credito` varchar(255) NOT NULL,
  `cod_prov` varchar(255) NOT NULL,
  `referencia` varchar(255) NOT NULL,
  `envio` varchar(255) NOT NULL,
  `des_anticipo` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `id_sucursal` varchar(10) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `nom_ven` varchar(255) NOT NULL,
  `nom_prov` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `municipio` varchar(255) NOT NULL,
  `tel` varchar(255) NOT NULL,
  `calle` varchar(255) NOT NULL,
  `contacto` varchar(255) NOT NULL,
  `rfc` varchar(255) NOT NULL,
  `cp` varchar(10) NOT NULL,
  `est` varchar(10) NOT NULL,
  `nota` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `vehiculo_co_tmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cod` varchar(255) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `val` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `vehiculo_co_tmp_concepto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `concepto` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `vehiculo_compra` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vehiculo` varchar(255) NOT NULL,
  `metodopago` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `nota` text NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `ultimo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_compra VALUES("1","12","1","600000","2015-07-01","19:00:13","123456789","1","1","comprado","Jorge vas");


CREATE TABLE `vehiculo_comprobante` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `cliente` varchar(255) NOT NULL,
  `rfc` varchar(255) NOT NULL,
  `cp` varchar(255) NOT NULL,
  `correo` varchar(255) NOT NULL,
  `celular` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usuario` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_comprobante VALUES("7","13","1","16","f","64000","bryo@no.com","554","2015-08-21","22:54:54","123456789","1");
INSERT INTO vehiculo_comprobante VALUES("8","13","2","16","f","64000","bryo@no.com","554","2015-08-22","10:19:46","123456789","1");
INSERT INTO vehiculo_comprobante VALUES("9","1","1","16","f","64000","bryo@no.com","554","2015-09-19","11:59:17","123456789","1");
INSERT INTO vehiculo_comprobante VALUES("10","2","1","16","f","64000","bryo@no.com","554","2015-09-19","12:12:09","123456789","1");
INSERT INTO vehiculo_comprobante VALUES("11","3","1","16","f","64000","bryo@no.com","554","2015-09-19","12:53:42","123456789","1");
INSERT INTO vehiculo_comprobante VALUES("12","6","1","1","ETUEU","64000","NO@NO.COM","34","2015-10-15","12:39:15","123456789","1");
INSERT INTO vehiculo_comprobante VALUES("13","7","1","1","ETUEU","64000","NO@NO.COM","34","2015-10-15","12:45:31","123456789","1");


CREATE TABLE `vehiculo_comprobante_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `concepto` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `total` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `vehiculo_con_tmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facturado` varchar(255) NOT NULL,
  `cliente` varchar(255) NOT NULL,
  `vehiculo` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `conductor` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `vehiculo_conductor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usu` varchar(255) NOT NULL,
  `licencia` varchar(255) NOT NULL,
  `vencimiento` date NOT NULL,
  `expedido` date NOT NULL,
  `nota` text NOT NULL,
  `estado` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_conductor VALUES("1","5566","4444","2015-07-02","2015-07-02","1111ccc","s");


CREATE TABLE `vehiculo_confi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `tabla` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_confi VALUES("1","Toyota","marca");
INSERT INTO vehiculo_confi VALUES("2","Hyundai","marca");
INSERT INTO vehiculo_confi VALUES("3","Chevrolet","marca");
INSERT INTO vehiculo_confi VALUES("4","Nissan","marca");
INSERT INTO vehiculo_confi VALUES("5","Ford","marca");
INSERT INTO vehiculo_confi VALUES("6","Chrysler","marca");
INSERT INTO vehiculo_confi VALUES("7","Mazda","marca");
INSERT INTO vehiculo_confi VALUES("8","Auto","modelo");
INSERT INTO vehiculo_confi VALUES("9","MInivan","modelo");
INSERT INTO vehiculo_confi VALUES("10","VAN","modelo");
INSERT INTO vehiculo_confi VALUES("11","Pick up","modelo");
INSERT INTO vehiculo_confi VALUES("12","Azul","color");
INSERT INTO vehiculo_confi VALUES("13","Negro","color");
INSERT INTO vehiculo_confi VALUES("14","Blanco","color");
INSERT INTO vehiculo_confi VALUES("15","Gris","color");
INSERT INTO vehiculo_confi VALUES("16","Plata","color");
INSERT INTO vehiculo_confi VALUES("17","Nuevo","estado");
INSERT INTO vehiculo_confi VALUES("18","De Segunda Mano","estado");
INSERT INTO vehiculo_confi VALUES("19","SEMINUEVO","estado");
INSERT INTO vehiculo_confi VALUES("20","50 litros","tanque");
INSERT INTO vehiculo_confi VALUES("21","60 litros","tanque");
INSERT INTO vehiculo_confi VALUES("22","45 litros","tanque");
INSERT INTO vehiculo_confi VALUES("23","95 litros","tanque");
INSERT INTO vehiculo_confi VALUES("24","100 litros","tanque");
INSERT INTO vehiculo_confi VALUES("25","117 litros","tanque");
INSERT INTO vehiculo_confi VALUES("26","138 litros","tanque");
INSERT INTO vehiculo_confi VALUES("27","4 Cilindros","cilindro");
INSERT INTO vehiculo_confi VALUES("28","6 Cilindros","cilindro");
INSERT INTO vehiculo_confi VALUES("29","8 Cilindros","cilindro");
INSERT INTO vehiculo_confi VALUES("30","4 Pasajeros","capacidad");
INSERT INTO vehiculo_confi VALUES("31","5 Pasajeros","capacidad");
INSERT INTO vehiculo_confi VALUES("32","6 Pasajeros","capacidad");
INSERT INTO vehiculo_confi VALUES("33","7 Pasajeros","capacidad");
INSERT INTO vehiculo_confi VALUES("34","8 Pasajeros","capacidad");
INSERT INTO vehiculo_confi VALUES("35","10 Pasajeros","capacidad");
INSERT INTO vehiculo_confi VALUES("36","12 Pasajeros","capacidad");
INSERT INTO vehiculo_confi VALUES("37","14 Pasajeros","capacidad");
INSERT INTO vehiculo_confi VALUES("38","15 Pasajeros","capacidad");
INSERT INTO vehiculo_confi VALUES("39","Automatica","transmision");
INSERT INTO vehiculo_confi VALUES("40","Estandar","transmision");
INSERT INTO vehiculo_confi VALUES("41","Atitude","tipo");
INSERT INTO vehiculo_confi VALUES("42","Express Van","tipo");
INSERT INTO vehiculo_confi VALUES("43","Sentra","tipo");
INSERT INTO vehiculo_confi VALUES("44","Ford F-150","tipo");
INSERT INTO vehiculo_confi VALUES("45","Avenger","tipo");
INSERT INTO vehiculo_confi VALUES("46","Sienna","tipo");
INSERT INTO vehiculo_confi VALUES("47","Town Country","tipo");
INSERT INTO vehiculo_confi VALUES("48","Sonic","tipo");
INSERT INTO vehiculo_confi VALUES("49","Elantra","tipo");
INSERT INTO vehiculo_confi VALUES("50","Fiesta","tipo");
INSERT INTO vehiculo_confi VALUES("51","Hiace","tipo");
INSERT INTO vehiculo_confi VALUES("52","Semi Equipado","equipo");
INSERT INTO vehiculo_confi VALUES("53","Equipado","equipo");
INSERT INTO vehiculo_confi VALUES("54","Tela","inte");
INSERT INTO vehiculo_confi VALUES("55","Piel","inte");
INSERT INTO vehiculo_confi VALUES("56","AXXA","seguro");
INSERT INTO vehiculo_confi VALUES("57","AFIRME","seguro");
INSERT INTO vehiculo_confi VALUES("58","INBURSA","seguro");
INSERT INTO vehiculo_confi VALUES("59","Austero","equipo");
INSERT INTO vehiculo_confi VALUES("60","MAGNA","combustible");
INSERT INTO vehiculo_confi VALUES("61","PREMIUM","combustible");


CREATE TABLE `vehiculo_contrato` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clie_cod` varchar(255) NOT NULL,
  `clie_nom` varchar(255) NOT NULL,
  `clie_dir` varchar(255) NOT NULL,
  `clie_colonia` varchar(255) NOT NULL,
  `clie_tel` varchar(255) NOT NULL,
  `clie_lista` varchar(255) NOT NULL,
  `clie_iva` varchar(255) NOT NULL,
  `veh_cod` varchar(255) NOT NULL,
  `veh_placa` varchar(255) NOT NULL,
  `veh_marca` varchar(255) NOT NULL,
  `veh_modelo` varchar(255) NOT NULL,
  `veh_capacidad` varchar(255) NOT NULL,
  `veh_color` varchar(255) NOT NULL,
  `veh_tipo` varchar(255) NOT NULL,
  `veh_asig` varchar(255) NOT NULL,
  `veh_tarifa` varchar(255) NOT NULL,
  `veh_dia` varchar(255) NOT NULL,
  `veh_cant` varchar(255) NOT NULL,
  `veh_valor` varchar(255) NOT NULL,
  `veh_costo` varchar(255) NOT NULL,
  `veh_inte` varchar(255) NOT NULL,
  `con_cod` varchar(255) NOT NULL,
  `con_nom` varchar(255) NOT NULL,
  `con_lic` varchar(255) NOT NULL,
  `con_exp` date NOT NULL,
  `con_ven` date NOT NULL,
  `con_valor` varchar(255) NOT NULL,
  `ser_desc` varchar(255) NOT NULL,
  `fin_kms_salida` varchar(255) NOT NULL,
  `fin_kms_entrada` varchar(255) NOT NULL,
  `fin_kms_valor` varchar(255) NOT NULL,
  `fin_gasolina_salida` varchar(255) NOT NULL,
  `fin_gasolina_entrada` varchar(255) NOT NULL,
  `fin_gasolina_valor` varchar(255) NOT NULL,
  `fin_autorizado` varchar(255) NOT NULL,
  `fin_tipo` varchar(255) NOT NULL,
  `fin_vehiculo` text NOT NULL,
  `fin_responsable` varchar(255) NOT NULL,
  `fin_fecha_salida` date NOT NULL,
  `fin_hora_salida` time NOT NULL,
  `fin_fecha_entrada` date NOT NULL,
  `fin_hora_entrada` time NOT NULL,
  `fin_deposito` varchar(255) NOT NULL,
  `fin_conductor` text NOT NULL,
  `fin_desc` varchar(255) NOT NULL,
  `fin_factura` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `estado` varchar(255) NOT NULL,
  `usuario` varchar(255) NOT NULL,
  `vencimiento` date NOT NULL,
  `f_tiempo` varchar(255) NOT NULL,
  `f_kms` varchar(255) NOT NULL,
  `f_cargo` varchar(255) NOT NULL,
  `f_choque` varchar(255) NOT NULL,
  `f_gasolina` varchar(255) NOT NULL,
  `f_personal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_contrato VALUES("3","16","Infosis Piso 11","Maq Piso 11","centro","33","1","s","65","abc596","Nissan","2005","4 Pasajeros","Blanco","Avenger","prov","dia","3","3","1800","300000","2","5566","USUARIO DE PRUEBA","4444","2015-07-02","2015-07-02","790","0","300","","","4","","","300","Efectivo","Ninguna","JORGE VASQUEZ","2015-09-20","00:00:00","0000-00-00","00:00:00","1000","nINGUNA","0","Factura","1","2015-09-19","12:38:40","s","123456789","2015-09-25","0","0","0","0","0","0");
INSERT INTO vehiculo_contrato VALUES("6","1","PUBLICO GENERAL",".","CEN","NO","1","s","65","abc596","Nissan","2005","4 Pasajeros","Blanco","Avenger","prov","dia","1","1","600","366777","1","5566","USUARIO DE PRUEBA","4444","2015-07-02","2015-07-02","0","0","1","","","1","","","1","Efectivo","","1","2015-10-20","00:00:00","0000-00-00","00:00:00","1","","0","Factura","1","2015-10-15","12:37:13","s","123456789","2015-10-30","0","0","0","0","0","0");
INSERT INTO vehiculo_contrato VALUES("7","1","PUBLICO GENERAL",".","CEN","NO","1","s","65","abc596","Nissan","2005","4 Pasajeros","Blanco","Avenger","prov","dia","1","1","600","100000","4","5566","USUARIO DE PRUEBA","4444","2015-07-02","2015-07-02","0","0","1","","","1","","","1","Efectivo","1","JORGE","2015-10-22","00:00:00","0000-00-00","00:00:00","1","1","0","Factura","1","2015-10-15","12:44:42","s","123456789","2015-10-23","0","0","0","0","0","0");


CREATE TABLE `vehiculo_contrato_equipo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_contrato_equipo VALUES("1","3","AUDIFONOS","NO","5");
INSERT INTO vehiculo_contrato_equipo VALUES("2","3","DVD","SI","200");
INSERT INTO vehiculo_contrato_equipo VALUES("3","3","RADIO","SI","190");
INSERT INTO vehiculo_contrato_equipo VALUES("4","3","LLANTA","NO","15");
INSERT INTO vehiculo_contrato_equipo VALUES("5","3","GATO","NO","40");
INSERT INTO vehiculo_contrato_equipo VALUES("6","3","TAPONES","NO","15");
INSERT INTO vehiculo_contrato_equipo VALUES("7","3","ESPEJO","SI","30");
INSERT INTO vehiculo_contrato_equipo VALUES("8","3","PLACAS","SI","100");
INSERT INTO vehiculo_contrato_equipo VALUES("9","3","T. CIRCULACION","NO","2");
INSERT INTO vehiculo_contrato_equipo VALUES("10","3","POLIZA DE SEGURO","NO","500");
INSERT INTO vehiculo_contrato_equipo VALUES("11","6","AUDIFONOS","NO","5");
INSERT INTO vehiculo_contrato_equipo VALUES("12","6","DVD","NO","200");
INSERT INTO vehiculo_contrato_equipo VALUES("13","6","RADIO","SI","190");
INSERT INTO vehiculo_contrato_equipo VALUES("14","6","LLANTA","NO","15");
INSERT INTO vehiculo_contrato_equipo VALUES("15","6","GATO","NO","40");
INSERT INTO vehiculo_contrato_equipo VALUES("16","6","TAPONES","NO","15");
INSERT INTO vehiculo_contrato_equipo VALUES("17","6","ESPEJO","NO","30");
INSERT INTO vehiculo_contrato_equipo VALUES("18","6","PLACAS","NO","100");
INSERT INTO vehiculo_contrato_equipo VALUES("19","6","T. CIRCULACION","NO","2");
INSERT INTO vehiculo_contrato_equipo VALUES("20","6","POLIZA DE SEGURO","NO","500");
INSERT INTO vehiculo_contrato_equipo VALUES("26","7","AUDIFONOS","NO","5");
INSERT INTO vehiculo_contrato_equipo VALUES("27","7","DVD","NO","200");
INSERT INTO vehiculo_contrato_equipo VALUES("28","7","RADIO","NO","190");
INSERT INTO vehiculo_contrato_equipo VALUES("29","7","LLANTA","SI","15");
INSERT INTO vehiculo_contrato_equipo VALUES("30","7","GATO","NO","40");
INSERT INTO vehiculo_contrato_equipo VALUES("31","7","TAPONES","NO","15");
INSERT INTO vehiculo_contrato_equipo VALUES("32","7","ESPEJO","NO","30");
INSERT INTO vehiculo_contrato_equipo VALUES("33","7","PLACAS","NO","100");
INSERT INTO vehiculo_contrato_equipo VALUES("34","7","T. CIRCULACION","NO","2");
INSERT INTO vehiculo_contrato_equipo VALUES("35","7","POLIZA DE SEGURO","NO","500");


CREATE TABLE `vehiculo_contrato_producto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cod` varchar(255) NOT NULL,
  `ref` varchar(255) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `val` varchar(255) NOT NULL,
  `descuento` varchar(255) NOT NULL,
  `contrato` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_contrato_producto VALUES("1","12","","Producto de Prueba","1","120","0","3");
INSERT INTO vehiculo_contrato_producto VALUES("2","13","","Producto de Prueba dos","2","100","0","3");


CREATE TABLE `vehiculo_contrato_tarifa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `tarifa` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_contrato_tarifa VALUES("1","3","dia","dia","600");
INSERT INTO vehiculo_contrato_tarifa VALUES("2","3","hora","hora","200");
INSERT INTO vehiculo_contrato_tarifa VALUES("3","3","3","Mes","15000");
INSERT INTO vehiculo_contrato_tarifa VALUES("4","3","2","Semana","4000");
INSERT INTO vehiculo_contrato_tarifa VALUES("5","6","dia","dia","600");
INSERT INTO vehiculo_contrato_tarifa VALUES("6","6","hora","hora","200");
INSERT INTO vehiculo_contrato_tarifa VALUES("7","6","3","Mes","15000");
INSERT INTO vehiculo_contrato_tarifa VALUES("8","6","2","Semana","4000");
INSERT INTO vehiculo_contrato_tarifa VALUES("9","7","dia","dia","600");
INSERT INTO vehiculo_contrato_tarifa VALUES("10","7","hora","hora","200");
INSERT INTO vehiculo_contrato_tarifa VALUES("11","7","3","Mes","15000");
INSERT INTO vehiculo_contrato_tarifa VALUES("12","7","2","Semana","4000");


CREATE TABLE `vehiculo_cxc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `cliente` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_cxc VALUES("1","3","16","2000","2015-09-19","12:53:42");
INSERT INTO vehiculo_cxc VALUES("2","6","1","916","2015-10-15","12:39:15");
INSERT INTO vehiculo_cxc VALUES("3","7","1","713.4","2015-10-15","12:45:31");


CREATE TABLE `vehiculo_cxc_abono` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `metodopago` varchar(255) NOT NULL,
  `tasa` varchar(255) NOT NULL,
  `ntasa` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_cxc_abono VALUES("1","3","400","123456789","2015-09-19","12:56:14","1","","","1");
INSERT INTO vehiculo_cxc_abono VALUES("2","6","0","123456789","0000-00-00","00:00:00","1","","","1");
INSERT INTO vehiculo_cxc_abono VALUES("3","7","0","123456789","2015-10-15","12:45:31","1","","","1");
INSERT INTO vehiculo_cxc_abono VALUES("4","7","250","123456789","2015-10-15","12:45:59","1","","","1");
INSERT INTO vehiculo_cxc_abono VALUES("5","7","463.4","123456789","2015-10-15","12:47:00","1","","","1");
INSERT INTO vehiculo_cxc_abono VALUES("6","6","36.6","123456789","2015-10-15","12:47:00","1","","","1");


CREATE TABLE `vehiculo_cxp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `compra` varchar(255) NOT NULL,
  `proveedor` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_cxp VALUES("1","3","67584","99","2015-08-24","16:19:13");
INSERT INTO vehiculo_cxp VALUES("2","4","67584","500","2015-08-24","16:29:43");


CREATE TABLE `vehiculo_cxp_abono` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `compra` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `total` varchar(255) NOT NULL,
  `saldo` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `metodopago` varchar(255) NOT NULL,
  `tasa` varchar(255) NOT NULL,
  `ntasa` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_cxp_abono VALUES("1","4","100","500","400","123456789","2015-08-26","13:49:55","1","0","","1");
INSERT INTO vehiculo_cxp_abono VALUES("2","4","120","500","280","123456789","2015-08-26","13:50:06","DOLAR","12","USD","1");


CREATE TABLE `vehiculo_equipo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `vehiculo` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_equipo VALUES("1","AUDIFONOS","65","5");
INSERT INTO vehiculo_equipo VALUES("2","DVD","65","200");
INSERT INTO vehiculo_equipo VALUES("3","RADIO","65","190");
INSERT INTO vehiculo_equipo VALUES("4","LLANTA","65","15");
INSERT INTO vehiculo_equipo VALUES("5","GATO","65","40");
INSERT INTO vehiculo_equipo VALUES("6","TAPONES","65","15");
INSERT INTO vehiculo_equipo VALUES("7","ESPEJO","65","30");
INSERT INTO vehiculo_equipo VALUES("8","PLACAS","65","100");
INSERT INTO vehiculo_equipo VALUES("9","T. CIRCULACION","65","2");
INSERT INTO vehiculo_equipo VALUES("10","POLIZA DE SEGURO","65","500");


CREATE TABLE `vehiculo_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `marca` varchar(10) NOT NULL,
  `modelo` varchar(10) NOT NULL,
  `fechac` date NOT NULL,
  `placa` varchar(255) NOT NULL,
  `chasis` varchar(255) NOT NULL,
  `carroceria` varchar(255) NOT NULL,
  `kilometra` varchar(255) NOT NULL,
  `transmision` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `puerta` varchar(20) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `tanque` varchar(255) NOT NULL,
  `capacidad` varchar(255) NOT NULL,
  `cilindro` varchar(255) NOT NULL,
  `costo` varchar(255) NOT NULL,
  `venta` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `nota` text NOT NULL,
  `estrellas` int(11) NOT NULL,
  `dispo` varchar(255) NOT NULL,
  `asig` varchar(255) NOT NULL,
  `equipo` varchar(255) NOT NULL,
  `inte` varchar(255) NOT NULL,
  `seguro` varchar(255) NOT NULL,
  `combustible` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_info VALUES("1","12","1","10","2015-06-29","BXA345","192999","Ninguna","1999","40","15","4","47","26","36","28","0","0","17","","4","n","prop","53","54","56","61","2");
INSERT INTO vehiculo_info VALUES("2","65","4","2005","2015-07-01","abc596","45","n95959","u5559","40","14","4","45","20","30","29","0","0","19","","3","s","prov","53","55","57","61","2");
INSERT INTO vehiculo_info VALUES("3","13","3","8","2015-10-01","as","as","as","as","39","12","2","41","24","35","27","0","0","18","","1","s","prop","59","55","57","60","1");


CREATE TABLE `vehiculo_prov` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `razon` varchar(255) NOT NULL,
  `contacto` varchar(255) NOT NULL,
  `cel` varchar(255) NOT NULL,
  `tel` varchar(255) NOT NULL,
  `dir` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `municipio` varchar(255) NOT NULL,
  `localidad` varchar(255) NOT NULL,
  `nota` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_prov VALUES("1","858585","UMBRELA","JORGE JULIO","75464","78899","CERRADA","MEXICO","TECAMAC","SAN PEDRO","");


CREATE TABLE `vehiculo_prov_tarifa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `proveedor` varchar(255) NOT NULL,
  `vehiculo` varchar(255) NOT NULL,
  `tarifa` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_prov_tarifa VALUES("1","858585","65","hora","40");
INSERT INTO vehiculo_prov_tarifa VALUES("2","858585","65","dia","70");
INSERT INTO vehiculo_prov_tarifa VALUES("3","858585","65","2","500");
INSERT INTO vehiculo_prov_tarifa VALUES("4","858585","65","3","1000");


CREATE TABLE `vehiculo_ref_contenido` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `producto` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_ref_contenido VALUES("1","123","1","23");
INSERT INTO vehiculo_ref_contenido VALUES("2","123","2","60");


CREATE TABLE `vehiculo_ref_prov` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ref` varchar(255) NOT NULL,
  `prov` varchar(255) NOT NULL,
  `costo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_ref_prov VALUES("2","123","67584","300");


CREATE TABLE `vehiculo_refaccion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `nota` text NOT NULL,
  `marca` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  `anno` varchar(255) NOT NULL,
  `modelo` varchar(255) NOT NULL,
  `minimo` varchar(255) NOT NULL,
  `maximo` varchar(255) NOT NULL,
  `costo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_refaccion VALUES("1","123","PRUEBA","NINGUNA","1","47","2014","10","10","30","300");


CREATE TABLE `vehiculo_seguro_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `dir` varchar(255) NOT NULL,
  `tel` varchar(255) NOT NULL,
  `cel` varchar(255) NOT NULL,
  `fax` varchar(255) NOT NULL,
  `ciudad` varchar(255) NOT NULL,
  `pais` varchar(255) NOT NULL,
  `estado` varchar(10) NOT NULL,
  `contacto` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_seguro_info VALUES("1","nombre","direccion","telef","cel","fax","ciudad","pais","s","contato");


CREATE TABLE `vehiculo_ser_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cod` varchar(255) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `val` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `servicio` varchar(255) NOT NULL,
  `nota` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_ser_detalle VALUES("3","1000","Refaccion de Prueba","590","1","3","Ninguna Observaciones");
INSERT INTO vehiculo_ser_detalle VALUES("4","1000","Refaccion de Prueba","590","6","4","Ninguna Observaciones");
INSERT INTO vehiculo_ser_detalle VALUES("5","1000","Refaccion de Prueba","590","5","4","Ninguna Observaciones");
INSERT INTO vehiculo_ser_detalle VALUES("6","123","PRUEBA","300","1","5","");


CREATE TABLE `vehiculo_ser_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(255) NOT NULL,
  `vehiculo` varchar(255) NOT NULL,
  `fechai` date NOT NULL,
  `fechaf` date NOT NULL,
  `k` varchar(255) NOT NULL,
  `costo` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `nota1` text NOT NULL,
  `nota2` text NOT NULL,
  `inventario` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `responsable` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `otros` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_ser_info VALUES("2","4","BHD 124","2015-04-07","2015-04-07","19008","100","VENCIDO","Ninguna","Hola mundo mundo","si","2015-04-14","17:15:04","123456789","1","","");
INSERT INTO vehiculo_ser_info VALUES("3","2","BHD 124","2015-04-14","2015-04-23","19008","766","PENDIENTE","TRABAJA RAPIDO","Se limpio solamente el vehiculo","si","2015-04-14","23:03:34","123456789","1","","");
INSERT INTO vehiculo_ser_info VALUES("4","5","BHD 124","2015-04-15","2015-04-15","19008","300","VENCIDO","g","h","si","2015-04-15","11:22:14","123456789","1","300","50");
INSERT INTO vehiculo_ser_info VALUES("5","3","BXA345","2015-08-27","2015-08-27","1999","380","PENDIENTE","","jol","si","2015-08-27","22:51:52","123456789","1","380","100");


CREATE TABLE `vehiculo_ser_tipo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `costo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_ser_tipo VALUES("1","LAVADO DE MOTORS","899");
INSERT INTO vehiculo_ser_tipo VALUES("2","TUNE UP","766");
INSERT INTO vehiculo_ser_tipo VALUES("3","FUEL INJECTION","380");
INSERT INTO vehiculo_ser_tipo VALUES("4","MOTOR","100");
INSERT INTO vehiculo_ser_tipo VALUES("5","LAVADO GENERAL","300");


CREATE TABLE `vehiculo_ser_tmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cod` varchar(255) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `val` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `vehiculo_tarifa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vehiculo` varchar(255) NOT NULL,
  `lista` varchar(255) NOT NULL,
  `tarifa` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_tarifa VALUES("1","65","1","dia","600");
INSERT INTO vehiculo_tarifa VALUES("2","65","1","hora","200");
INSERT INTO vehiculo_tarifa VALUES("3","65","1","3","15000");
INSERT INTO vehiculo_tarifa VALUES("4","65","1","2","4000");
INSERT INTO vehiculo_tarifa VALUES("5","65","2","dia","600");
INSERT INTO vehiculo_tarifa VALUES("6","65","2","hora","200");
INSERT INTO vehiculo_tarifa VALUES("7","65","2","3","15000");
INSERT INTO vehiculo_tarifa VALUES("8","65","2","2","4000");
INSERT INTO vehiculo_tarifa VALUES("9","65","3","dia","600");
INSERT INTO vehiculo_tarifa VALUES("10","65","3","hora","200");
INSERT INTO vehiculo_tarifa VALUES("11","65","3","3","15000");
INSERT INTO vehiculo_tarifa VALUES("12","65","3","2","4000");
INSERT INTO vehiculo_tarifa VALUES("13","65","4","dia","600");
INSERT INTO vehiculo_tarifa VALUES("14","65","4","hora","200");
INSERT INTO vehiculo_tarifa VALUES("15","65","4","3","15000");
INSERT INTO vehiculo_tarifa VALUES("16","65","4","2","4000");
INSERT INTO vehiculo_tarifa VALUES("17","65","5","dia","600");
INSERT INTO vehiculo_tarifa VALUES("18","65","5","hora","200");
INSERT INTO vehiculo_tarifa VALUES("19","65","5","3","15000");
INSERT INTO vehiculo_tarifa VALUES("20","65","5","2","4000");
INSERT INTO vehiculo_tarifa VALUES("21","65","6","dia","600");
INSERT INTO vehiculo_tarifa VALUES("22","65","6","hora","200");
INSERT INTO vehiculo_tarifa VALUES("23","65","6","3","15000");
INSERT INTO vehiculo_tarifa VALUES("24","65","6","2","4000");


CREATE TABLE `vehiculo_tmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clie_cod` varchar(255) NOT NULL,
  `clie_nom` varchar(255) NOT NULL,
  `clie_dir` varchar(255) NOT NULL,
  `clie_colonia` varchar(355) NOT NULL,
  `clie_tel` varchar(255) NOT NULL,
  `clie_lista` varchar(255) NOT NULL,
  `clie_iva` varchar(255) NOT NULL,
  `veh_cod` varchar(255) NOT NULL,
  `veh_placa` varchar(255) NOT NULL,
  `veh_marca` varchar(255) NOT NULL,
  `veh_modelo` varchar(255) NOT NULL,
  `veh_capacidad` varchar(255) NOT NULL,
  `veh_color` varchar(255) NOT NULL,
  `veh_tipo` varchar(255) NOT NULL,
  `veh_asig` varchar(255) NOT NULL,
  `veh_tarifa` varchar(255) NOT NULL,
  `veh_dia` varchar(255) NOT NULL,
  `veh_cant` varchar(255) NOT NULL,
  `veh_valor` varchar(255) NOT NULL,
  `veh_costo` varchar(255) NOT NULL,
  `veh_inte` varchar(255) NOT NULL,
  `con_cod` varchar(255) NOT NULL,
  `con_nom` varchar(255) NOT NULL,
  `con_lic` varchar(255) NOT NULL,
  `con_exp` date NOT NULL,
  `con_ven` date NOT NULL,
  `con_valor` varchar(255) NOT NULL,
  `ser_desc` varchar(255) NOT NULL,
  `fin_kms_salida` varchar(255) NOT NULL,
  `fin_kms_entrada` varchar(255) NOT NULL,
  `fin_kms_valor` varchar(255) NOT NULL,
  `fin_gasolina_salida` varchar(255) NOT NULL,
  `fin_gasolina_entrada` varchar(255) NOT NULL,
  `fin_gasolina_valor` varchar(255) NOT NULL,
  `fin_autorizado` varchar(255) NOT NULL,
  `fin_tipo` varchar(255) NOT NULL,
  `fin_vehiculo` text NOT NULL,
  `fin_responsable` varchar(255) NOT NULL,
  `fin_fecha_salida` date NOT NULL,
  `fin_hora_salida` time NOT NULL,
  `fin_fecha_entrada` date NOT NULL,
  `fin_hora_entrada` time NOT NULL,
  `fin_deposito` varchar(255) NOT NULL,
  `fin_conductor` text NOT NULL,
  `fin_desc` varchar(255) NOT NULL,
  `fin_factura` varchar(255) NOT NULL,
  `sucursal` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `estado` varchar(255) NOT NULL,
  `usuario` varchar(255) NOT NULL,
  `vencimiento` date NOT NULL,
  `f_tiempo` varchar(255) NOT NULL,
  `f_kms` varchar(255) NOT NULL,
  `f_cargo` varchar(255) NOT NULL,
  `f_choque` varchar(255) NOT NULL,
  `f_gasolina` varchar(255) NOT NULL,
  `f_personal` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_tmp VALUES("5","16","Infosis Piso 11","Maq Piso 11","centro","33","1","s","13","as","Chevrolet","8","10 Pasajeros","Azul","Atitude","prop","dia","2","2","0","140000","5","","","","0000-00-00","0000-00-00","0","0","","","","","","","","","","","0000-00-00","00:00:00","0000-00-00","00:00:00","","","","","","2015-10-01","18:40:15","s","123456789","0000-00-00","0","0","0","0","0","0");


CREATE TABLE `vehiculo_tmp_equipo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tmp` varchar(255) NOT NULL,
  `contrato` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `vehiculo_tmp_fin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contrato` varchar(255) NOT NULL,
  `dias_ex` varchar(255) NOT NULL,
  `fin_fecha_entrada` date NOT NULL,
  `fin_hora_entrada` time NOT NULL,
  `f_choque` varchar(255) NOT NULL,
  `f_personal` varchar(255) NOT NULL,
  `fin_desc` varchar(255) NOT NULL,
  `f_cargo` varchar(255) NOT NULL,
  `f_tiempo` varchar(255) NOT NULL,
  `f_kms` varchar(255) NOT NULL,
  `fin_kms_entrada` varchar(255) NOT NULL,
  `fin_gasolina_entrada` varchar(255) NOT NULL,
  `f_gasolina` varchar(255) NOT NULL,
  `tipo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_tmp_fin VALUES("2","8","2","2015-08-20","11:00:17","100","590","10","146","1200","340","4900","1","26.8","dia");
INSERT INTO vehiculo_tmp_fin VALUES("3","10","1","2015-09-07","22:13:40","300","400","21","200","600","7410","66000","3","13.4","dia");
INSERT INTO vehiculo_tmp_fin VALUES("4","12","1","2015-08-29","22:33:08","100","400","0","200","600","200","1900","4","13.4","dia");
INSERT INTO vehiculo_tmp_fin VALUES("5","13","2","2015-08-28","10:14:36","100","350","0","200","1200","500","3000","2","26.8","dia");


CREATE TABLE `vehiculo_tmp_trans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `origen` varchar(255) NOT NULL,
  `final` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `vehiculo_trans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `origen` varchar(255) NOT NULL,
  `final` varchar(255) NOT NULL,
  `producto` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `nota` longtext NOT NULL,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `usu` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO vehiculo_trans VALUES("1","1","2","123","PRUEBA","10","nada","2015-08-23","14:35:38","123456789");


CREATE TABLE `vehiculo_trans_detalle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `origen` varchar(255) NOT NULL,
  `final` varchar(255) NOT NULL,
  `cant` varchar(255) NOT NULL,
  `lista` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `vehiculo_trans_lista` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) NOT NULL,
  `nota` varchar(266) NOT NULL,
  `origen` varchar(255) NOT NULL,
  `final` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `venta_botones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cliente` varchar(255) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `tama` varchar(255) NOT NULL,
  `estado` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO venta_botones VALUES("1","15","CLIENTE MONSTRADOR","VERDE","PEQUENO","s");
INSERT INTO venta_botones VALUES("2","58578","cliente monstrador","AMARILLO","NORMAL","s");
