-- phpMyAdmin SQL Dump
-- version 4.6.5.2
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 04-10-2017 a las 05:45:13
-- Versión del servidor: 10.1.21-MariaDB
-- Versión de PHP: 7.1.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de datos: `almacen`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `bienes`
--

CREATE TABLE `bienes` (
  `id` int(11) NOT NULL,
  `sap` varchar(10) DEFAULT NULL,
  `codigo` varchar(50) DEFAULT NULL,
  `descripcion` varchar(200) DEFAULT NULL,
  `tipo` tinyint(4) DEFAULT NULL,
  `unidad` varchar(20) DEFAULT NULL,
  `cantidadUnidad` int(11) DEFAULT NULL,
  `unidadUtil` varchar(20) DEFAULT NULL,
  `cantidadUnidadUtil` int(11) DEFAULT NULL,
  `relacionUnidades` int(11) DEFAULT NULL,
  `marca` varchar(30) DEFAULT NULL,
  `modelo` varchar(30) DEFAULT NULL,
  `serial` varchar(30) DEFAULT NULL,
  `fechaCreacion` datetime DEFAULT NULL,
  `fechaActualizacion` datetime DEFAULT NULL,
  `cedulaEditor` varchar(20) DEFAULT NULL,
  `tiempoRetorno` int(11) DEFAULT NULL,
  `mesesEntrega` int(11) DEFAULT NULL,
  `cantidadEntregada` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `bienes`
--

INSERT INTO `bienes` (`id`, `sap`, `codigo`, `descripcion`, `tipo`, `unidad`, `cantidadUnidad`, `unidadUtil`, `cantidadUnidadUtil`, `relacionUnidades`, `marca`, `modelo`, `serial`, `fechaCreacion`, `fechaActualizacion`, `cedulaEditor`, `tiempoRetorno`, `mesesEntrega`, `cantidadEntregada`) VALUES
(1, '300168', '300168', 'SEÑAL \"PROHIBIDO ENCENDER FUEGO\"', 1, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:23', '2017-10-03 22:09:23', '10877056', 180, 0, 0),
(2, '300169', '300169', 'SEÑAL \"RIESGO ELECTRICO\"', 1, 'PZA', 7, 'PZA', 7, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:23', '2017-10-03 22:09:23', '10877056', 180, 0, 3),
(3, '300170', '300170', 'SEÑAL \"PELIGRO ESCALERA\"', 1, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:23', '2017-10-03 22:09:23', '10877056', 180, 0, 1),
(4, '300172', '300172', 'SEÑAL \"PELIGRO SUELO RESBALADIZO\"', 1, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:23', '2017-10-03 22:09:23', '10877056', 180, 0, 1),
(5, '300177', '300177', 'SEÑAL \"PROTECCION OCULAR\"', 1, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:23', '2017-10-03 22:09:23', '10877056', 180, 0, 1),
(6, '300181', '300181', 'SEÑAL \"PROTECCION RESPIRATORIA\"', 1, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:23', '2017-10-03 22:09:23', '10877056', 180, 0, 0),
(7, '300185', '300185', 'SEÑAL \"USO DE BOTAS\"', 1, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:23', '2017-10-03 22:09:23', '10877056', 180, 0, 1),
(8, '300198', '300198', 'SEÑAL \"USO DE GUANTES\"', 1, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:23', '2017-10-03 22:09:23', '10877056', 180, 0, 1),
(9, '300199', '300199', 'SEÑAL \"EXTINTOR\"', 1, 'PZA', 5, 'PZA', 5, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:23', '2017-10-03 22:09:23', '10877056', 180, 0, 5),
(10, '300200', '300200', 'SEÑAL \"PRIMEROS AUXILIOS\"', 1, 'PZA', 7, 'PZA', 7, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:23', '2017-10-03 22:09:23', '10877056', 180, 0, 3),
(11, '300096', '300096', 'CARETA PARA SOLDAR NO 505', 2, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:33', '2017-10-03 22:09:33', '10877056', 0, 0, 0),
(12, '300098', '300098', 'CARETA PARA BUCEO', 2, 'PZA', 7, 'PZA', 7, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:33', '2017-10-03 22:09:33', '10877056', 0, 0, 3),
(13, '300103', '300103', 'CARETA P/SANDBLASTING', 2, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:33', '2017-10-03 22:09:33', '10877056', 0, 0, 0),
(14, '300107', '300107', 'CHALECO P/SANDBLASTING', 2, 'PZA', 8, 'PZA', 8, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:33', '2017-10-03 22:09:33', '10877056', 0, 0, 2),
(15, '300120', '300120', 'CINTURON DE SEGURIDAD', 2, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:33', '2017-10-03 22:09:33', '10877056', 0, 0, 1),
(16, '300121', '300121', 'CINTURON ANTIHERNIA (SOPORTE LUMBAR)', 2, 'PZA', 8, 'PZA', 8, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:33', '2017-10-03 22:09:33', '10877056', 0, 0, 2),
(17, '300122', '300122', 'CHALECO SALVAVIDA', 2, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:33', '2017-10-03 22:09:33', '10877056', 0, 0, 1),
(18, '300123', '300123', 'ARO SALVAVIDA 30”', 2, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:33', '2017-10-03 22:09:33', '10877056', 0, 0, 0),
(19, '300124', '300124', 'SALVAVIDA TIPO YUGO', 2, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:33', '2017-10-03 22:09:33', '10877056', 0, 0, 1),
(20, '300127', '300127', 'ESLINGA NYLON 2\" X 6M', 2, 'PZA', 8, 'PZA', 8, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:33', '2017-10-03 22:09:33', '10877056', 0, 0, 2),
(21, '300001', '300001', 'BOTA DE SEGURIDAD C/ALTA VAQUETA C/TRENZ', 3, 'PAA', 4, 'PAA', 4, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:47', '2017-10-03 22:09:47', '10877056', 0, 6, 6),
(22, '300002', '300002', 'BOTA DE SEGURIDAD C/ALTA VAQUETA S/TRENZ', 3, 'PAA', 10, 'PAA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:47', '2017-10-03 22:09:47', '10877056', 0, 6, 0),
(23, '300003', '300003', 'BOTA DE SEGURIDAD C/BAJA C/TRENZA', 3, 'PAA', 9, 'PAA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:47', '2017-10-03 22:09:47', '10877056', 0, 6, 1),
(24, '300004', '300004', 'BOTA DE SEGURIDAD C/BAJA C/ELASTICA', 3, 'PAA', 10, 'PAA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:47', '2017-10-03 22:09:47', '10877056', 0, 6, 0),
(25, '300005', '300005', 'ZAPATO DE SEGURIDAD VAQUETA', 3, 'PAA', 7, 'PAA', 7, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:47', '2017-10-03 22:09:47', '10877056', 0, 6, 3),
(26, '300006', '300006', 'BOTA DE GOMA C/ALTA SIN PUNTA ACERO', 3, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:47', '2017-10-03 22:09:47', '10877056', 0, 6, 1),
(27, '300008', '300008', 'BOTA ESPECIAL P/SUPERVISOR', 3, 'PAA', 6, 'PAA', 6, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:47', '2017-10-03 22:09:47', '10877056', 0, 6, 4),
(28, '300009', '300009', 'BOTA NAPA NEGRA', 3, 'PAA', 6, 'PAA', 6, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:47', '2017-10-03 22:09:47', '10877056', 0, 6, 4),
(29, '300010', '300010', 'BOTIN DE SEGURIDAD VAQUETA C/TRENZ', 3, 'PAA', 7, 'PAA', 7, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:47', '2017-10-03 22:09:47', '10877056', 0, 6, 3),
(30, '300011', '300011', 'BOTIN SEGURIDAD PUNTA ACERO', 3, 'PAA', 9, 'PAA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:47', '2017-10-03 22:09:47', '10877056', 0, 6, 1),
(31, '100149', '100149', 'IGNITOR P/BOMBILLO SODIO M/H 150 2000W', 4, 'PZA', 7, 'PZA', 7, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:58', '2017-10-03 22:09:58', '10877056', 0, 0, 3),
(32, '100902', '100902', 'CONTACTOR 3 X 60 AMP  BOBINA 220 VT', 4, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:58', '2017-10-03 22:09:58', '10877056', 0, 0, 1),
(33, '101714', '101714', 'KIT DE REPARACION 248837 GRACO', 4, 'JGO', 6, 'JGO', 6, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:58', '2017-10-03 22:09:58', '10877056', 0, 0, 4),
(34, '101779', '101779', 'KING PIN 5TA RUEDA 3775W', 4, 'PZA', 9, 'PZA', 9, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:58', '2017-10-03 22:09:58', '10877056', 0, 0, 1),
(35, '101782', '101782', 'CATALIZADOR INTERTHANE 990 (1/4 GLN) ', 4, 'PZA', 7, 'PZA', 7, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:58', '2017-10-03 22:09:58', '10877056', 0, 0, 3),
(36, '101784', '101784', 'CEMTECH UNDERWATER (25KG)', 4, 'BTO', 10, 'BTO', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:58', '2017-10-03 22:09:58', '10877056', 0, 0, 0),
(37, '103146', '103146', 'PALANCA PARA DADO 1\" PROTO 5868', 4, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:58', '2017-10-03 22:09:58', '10877056', 0, 0, 0),
(38, '103891', '103891', 'FILTRO SEP RK60 RAMA', 4, 'PZA', 8, 'PZA', 8, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:58', '2017-10-03 22:09:58', '10877056', 0, 0, 2),
(39, '104521', '104521', 'TUERCA CONICA 5030-12-1,50 X 21 X 16', 4, 'PZA', 8, 'PZA', 8, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:58', '2017-10-03 22:09:58', '10877056', 0, 0, 2),
(40, '104908', '104908', 'RESISTOR CON BLOWER 26KW', 4, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:09:58', '2017-10-03 22:09:58', '10877056', 0, 0, 0),
(41, '100063', '100063', 'PULMON DE AIRE 3 SALIDAS', 5, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:10', '2017-10-03 22:10:10', '10877056', 0, 0, 0),
(42, '100064', '100064', 'KIT OVERHAUL 29546239 TRANSM ALLISON', 5, 'KIT', 10, 'KIT', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:10', '2017-10-03 22:10:10', '10877056', 0, 0, 0),
(43, '100065', '100065', 'CONO RODAMIENTO 25580 TIMKEN', 5, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:10', '2017-10-03 22:10:10', '10877056', 0, 0, 0),
(44, '100066', '100066', 'TUERCA 3K9770 CAT', 5, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:10', '2017-10-03 22:10:10', '10877056', 0, 0, 0),
(45, '100067', '100067', 'RODAMIENTO NDH 3L09', 5, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:10', '2017-10-03 22:10:10', '10877056', 0, 0, 0),
(46, '100068', '100068', 'TORNILLO 6V1734 CAT', 5, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:10', '2017-10-03 22:10:10', '10877056', 0, 0, 0),
(47, '100070', '100070', 'RODAMIENTO KOYO RNU0727', 5, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:10', '2017-10-03 22:10:10', '10877056', 0, 0, 0),
(48, '100071', '100071', 'RODAMIENTO 237918', 5, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:10', '2017-10-03 22:10:10', '10877056', 0, 0, 0),
(49, '100072', '100072', 'RODAMIENTO 62/282RSC3', 5, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:10', '2017-10-03 22:10:10', '10877056', 0, 0, 0),
(50, '100073', '100073', 'CONO RODAMIENTO J482064', 5, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:10', '2017-10-03 22:10:10', '10877056', 0, 0, 0),
(51, '103898', '103898', 'IMPRESORA HP D2300', 6, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:27', '2017-10-03 22:10:27', '10877056', 0, 0, 0),
(52, '105229', '105229', 'FILM P/IMP HP LASER JET 1320', 6, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:27', '2017-10-03 22:10:27', '10877056', 0, 0, 0),
(53, '106120', '106120', 'TONER CANON GPR-22 MOD 1023N', 6, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:27', '2017-10-03 22:10:27', '10877056', 0, 0, 0),
(54, '106266', '106266', 'MEMORIA RAM 2GB PC2-5300S DDR2-667MHZ', 6, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:27', '2017-10-03 22:10:27', '10877056', 0, 0, 0),
(55, '112924', '112924', 'CALENTADOR DE AGUA 60 L', 6, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:27', '2017-10-03 22:10:27', '10877056', 0, 0, 0),
(56, '118804', '118804', 'CARTUCHO HP 662-662XL NEGRO', 6, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:27', '2017-10-03 22:10:27', '10877056', 0, 0, 0),
(57, '118806', '118806', 'CARTUCHO HP 662-662XL COLOR', 6, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:27', '2017-10-03 22:10:27', '10877056', 0, 0, 0),
(58, '122538', '122538', 'CARGADOR LAPTOP DELL INSPIRON 15 3000', 6, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:27', '2017-10-03 22:10:27', '10877056', 0, 0, 0),
(59, '600046', '600046', 'TINTA MADERA CAOBA', 6, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:27', '2017-10-03 22:10:27', '10877056', 0, 0, 0),
(60, '600047', '600047', 'TINTA MADERA NEGRA', 6, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:27', '2017-10-03 22:10:27', '10877056', 0, 0, 0),
(61, '400026', '400026', 'MONITOR DE SIGNOS VITALES', 7, 'UN', 10, 'UN', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:40', '2017-10-03 22:10:40', '10877056', 0, 0, 0),
(62, '600021', '600021', 'BOMBONA OXIGENO 5LTS (MEDICINAL)', 7, 'CIL', 10, 'CIL', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:40', '2017-10-03 22:10:40', '10877056', 0, 0, 0),
(63, '600025', '600025', 'FLUJOMETRO DE OXIGENO', 7, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:40', '2017-10-03 22:10:40', '10877056', 0, 0, 0),
(64, '600023', '600023', 'BOMBONA OXIGENO 1LTS (MEDICINAL)', 7, 'CIL', 10, 'CIL', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:40', '2017-10-03 22:10:40', '10877056', 0, 0, 0),
(65, '600053', '600053', 'BOMBONA OXIGENO 3 M3 (MEDICINAL)', 7, 'CIL', 10, 'CIL', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:40', '2017-10-03 22:10:40', '10877056', 0, 0, 0),
(66, '600054', '600054', 'MULETAS GRADUABLES', 7, 'PZA', 10, 'PZA', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:40', '2017-10-03 22:10:40', '10877056', 0, 0, 0),
(67, '600144', '600144', 'MALETIN PRIMEROS AUXILIOS', 7, 'UN', 10, 'UN', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:40', '2017-10-03 22:10:40', '10877056', 0, 0, 0),
(68, '600145', '600145', 'FERULAS NEUMATICAS', 7, 'JGO', 10, 'JGO', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:40', '2017-10-03 22:10:40', '10877056', 0, 0, 0),
(69, '600154', '600154', 'ENSURE PLUS', 7, 'UN', 10, 'UN', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:40', '2017-10-03 22:10:40', '10877056', 0, 0, 0),
(70, '600156', '600156', 'GUANTES DE LATEX PARA EXAMEN', 7, 'CJ', 10, 'CJ', 10, 1, 'N/A', 'N/A', 'N/A', '2017-10-03 22:10:40', '2017-10-03 22:10:40', '10877056', 0, 0, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `devolucionprestamo`
--

CREATE TABLE `devolucionprestamo` (
  `id` int(11) NOT NULL,
  `numOperacion` int(11) DEFAULT NULL,
  `codigo` varchar(50) DEFAULT NULL,
  `descripcion` varchar(200) DEFAULT NULL,
  `cantidad` int(11) DEFAULT NULL,
  `tipo` varchar(20) DEFAULT NULL,
  `fechaDevolucion` varchar(15) DEFAULT NULL,
  `ubicacion` varchar(100) DEFAULT NULL,
  `observacion` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `devolucionprestamo`
--

INSERT INTO `devolucionprestamo` (`id`, `numOperacion`, `codigo`, `descripcion`, `cantidad`, `tipo`, `fechaDevolucion`, `ubicacion`, `observacion`) VALUES
(1, 8, '300170', 'SEÑAL \"PELIGRO ESCALERA\"', 1, 'Equipo', '03/10/2017', 'Taller', ''),
(2, 8, '300120', 'CINTURON DE SEGURIDAD', 1, 'Herramienta', '03/10/2017', 'Taller', '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `devoluciontransferencia`
--

CREATE TABLE `devoluciontransferencia` (
  `id` int(11) NOT NULL,
  `numOperacion` int(11) DEFAULT NULL,
  `codigo` varchar(50) DEFAULT NULL,
  `descripcion` varchar(200) DEFAULT NULL,
  `cantidad` int(11) DEFAULT NULL,
  `tipo` varchar(20) DEFAULT NULL,
  `fechaDevolucion` varchar(15) DEFAULT NULL,
  `ubicacion` varchar(100) DEFAULT NULL,
  `observacion` text,
  `emisor` varchar(100) DEFAULT NULL,
  `receptor` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `devoluciontransferencia`
--

INSERT INTO `devoluciontransferencia` (`id`, `numOperacion`, `codigo`, `descripcion`, `cantidad`, `tipo`, `fechaDevolucion`, `ubicacion`, `observacion`, `emisor`, `receptor`) VALUES
(1, 9, '300170', 'SEÑAL \"PELIGRO ESCALERA\"', 2, 'Equipo', '03/10/2017', 'Construcción', '', 'Almacen', 'Construcción A'),
(2, 9, '300185', 'SEÑAL \"USO DE BOTAS\"', 1, 'Equipo', '03/10/2017', 'Construcción', '', 'Almacen', 'Construcción A'),
(3, 9, '300127', 'ESLINGA NYLON 2\" X 6M', 3, 'Herramienta', '03/10/2017', 'Construcción', '', 'Almacen', 'Construcción A'),
(4, 9, '103146', 'PALANCA PARA DADO 1\" PROTO 5868', 2, 'Consumible', '03/10/2017', 'Construcción', '', 'Almacen', 'Construcción A');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `dotacion`
--

CREATE TABLE `dotacion` (
  `id` int(11) NOT NULL,
  `numOperacion` int(11) DEFAULT NULL,
  `codigo` varchar(50) DEFAULT NULL,
  `cantidad` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `cedulaSolicita` varchar(20) DEFAULT NULL,
  `cedulaDespacha` varchar(20) DEFAULT NULL,
  `cedulaAutoriza` varchar(20) DEFAULT NULL,
  `fechaEntrega` datetime DEFAULT NULL,
  `razon` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `dotacion`
--

INSERT INTO `dotacion` (`id`, `numOperacion`, `codigo`, `cantidad`, `status`, `cedulaSolicita`, `cedulaDespacha`, `cedulaAutoriza`, `fechaEntrega`, `razon`) VALUES
(1, 11, '300001', 1, 1, '16219875', '10877056', '', '2017-10-03 23:11:27', 2),
(2, 11, '300003', 1, 1, '16219875', '10877056', '', '2017-10-03 23:11:27', 2),
(3, 11, '300005', 1, 1, '16219875', '10877056', '', '2017-10-03 23:11:27', 1),
(4, 11, '300006', 1, 1, '16219875', '10877056', '', '2017-10-03 23:11:27', 3),
(5, 11, '300008', 1, 1, '16219875', '10877056', '', '2017-10-03 23:11:27', 1),
(6, 11, '300009', 1, 1, '16219875', '10877056', '', '2017-10-03 23:11:27', 1),
(7, 13, '300001', 1, 1, '10927393', '10877056', '', '2017-10-03 23:21:49', 1),
(8, 13, '300005', 1, 1, '10927393', '10877056', '', '2017-10-03 23:21:49', 1),
(9, 13, '300011', 1, 1, '10927393', '10877056', '', '2017-10-03 23:21:49', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `items`
--

CREATE TABLE `items` (
  `id` int(11) NOT NULL,
  `codigo` int(11) NOT NULL,
  `cantidad` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `numoperaciones`
--

CREATE TABLE `numoperaciones` (
  `id` int(11) NOT NULL,
  `numero` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `numoperaciones`
--

INSERT INTO `numoperaciones` (`id`, `numero`) VALUES
(1, 14);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `operaciones`
--

CREATE TABLE `operaciones` (
  `id` int(11) NOT NULL,
  `numero` int(11) NOT NULL,
  `tipo` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `operaciones`
--

INSERT INTO `operaciones` (`id`, `numero`, `tipo`) VALUES
(1, 1, 4),
(2, 2, 4),
(3, 3, 4),
(4, 4, 4),
(5, 5, 4),
(6, 6, 4),
(7, 7, 4),
(8, 8, 1),
(9, 9, 3),
(10, 10, 1),
(11, 11, 2),
(12, 12, 1),
(13, 13, 2),
(14, 14, 3);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `prestamos`
--

CREATE TABLE `prestamos` (
  `id` int(11) NOT NULL,
  `numOperacion` int(11) DEFAULT NULL,
  `codigo` varchar(50) DEFAULT NULL,
  `cantidad` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `cedulaSolicita` varchar(20) DEFAULT NULL,
  `cedulaDespacha` varchar(20) DEFAULT NULL,
  `cedulaAutoriza` varchar(20) DEFAULT NULL,
  `fechaEntrega` datetime DEFAULT NULL,
  `fechaDevolucion` datetime DEFAULT NULL,
  `cedulaRecibeDev` varchar(20) DEFAULT NULL,
  `ubicacion` varchar(100) NOT NULL,
  `observacion` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Volcado de datos para la tabla `prestamos`
--

INSERT INTO `prestamos` (`id`, `numOperacion`, `codigo`, `cantidad`, `status`, `cedulaSolicita`, `cedulaDespacha`, `cedulaAutoriza`, `fechaEntrega`, `fechaDevolucion`, `cedulaRecibeDev`, `ubicacion`, `observacion`) VALUES
(1, 8, '300170', 1, 2, '8866458', '10877056', '13798626', '2017-10-03 23:02:10', '2017-10-03 23:32:01', '10877056', 'Taller', ''),
(2, 8, '300120', 1, 2, '8866458', '10877056', '13798626', '2017-10-03 23:02:10', '2017-10-03 23:32:01', '10877056', 'Taller', ''),
(3, 8, '101782', 2, 1, '8866458', '10877056', '13798626', '2017-10-03 23:02:10', '0000-00-00 00:00:00', '', 'Taller', ''),
(4, 8, '103891', 1, 1, '8866458', '10877056', '13798626', '2017-10-03 23:02:10', '0000-00-00 00:00:00', '', 'Taller', ''),
(5, 8, '300122', 1, 1, '8866458', '10877056', '13798626', '2017-10-03 23:02:10', '0000-00-00 00:00:00', '', 'Taller', ''),
(6, 10, '300177', 1, 1, '16219875', '10877056', '14836527', '2017-10-03 23:09:45', '0000-00-00 00:00:00', '', 'Taller', ''),
(7, 10, '300198', 1, 1, '16219875', '10877056', '14836527', '2017-10-03 23:09:45', '0000-00-00 00:00:00', '', 'Taller', ''),
(8, 10, '300124', 1, 1, '16219875', '10877056', '14836527', '2017-10-03 23:09:45', '0000-00-00 00:00:00', '', 'Taller', ''),
(9, 10, '300127', 1, 1, '16219875', '10877056', '14836527', '2017-10-03 23:09:45', '0000-00-00 00:00:00', '', 'Taller', ''),
(10, 10, '104521', 2, 1, '16219875', '10877056', '14836527', '2017-10-03 23:09:45', '0000-00-00 00:00:00', '', 'Taller', ''),
(11, 10, '100902', 1, 1, '16219875', '10877056', '14836527', '2017-10-03 23:09:45', '0000-00-00 00:00:00', '', 'Taller', ''),
(12, 10, '101782', 1, 1, '16219875', '10877056', '14836527', '2017-10-03 23:09:45', '0000-00-00 00:00:00', '', 'Taller', ''),
(13, 12, '300172', 1, 1, '10927393', '10877056', '8533161', '2017-10-03 23:18:58', '0000-00-00 00:00:00', '', 'Almacen', ''),
(14, 12, '300185', 1, 1, '10927393', '10877056', '8533161', '2017-10-03 23:18:58', '0000-00-00 00:00:00', '', 'Almacen', ''),
(15, 12, '300169', 1, 1, '10927393', '10877056', '8533161', '2017-10-03 23:18:58', '0000-00-00 00:00:00', '', 'Almacen', ''),
(16, 12, '300121', 1, 1, '10927393', '10877056', '8533161', '2017-10-03 23:18:58', '0000-00-00 00:00:00', '', 'Almacen', ''),
(17, 12, '300127', 1, 1, '10927393', '10877056', '8533161', '2017-10-03 23:18:58', '0000-00-00 00:00:00', '', 'Almacen', ''),
(18, 12, '300120', 1, 1, '10927393', '10877056', '8533161', '2017-10-03 23:18:58', '0000-00-00 00:00:00', '', 'Almacen', ''),
(19, 12, '103891', 1, 1, '10927393', '10877056', '8533161', '2017-10-03 23:18:58', '0000-00-00 00:00:00', '', 'Almacen', '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `registrostock`
--

CREATE TABLE `registrostock` (
  `id` int(11) NOT NULL,
  `numOperacion` int(11) DEFAULT NULL,
  `codigo` varchar(50) DEFAULT NULL,
  `cantidad` int(11) DEFAULT NULL,
  `objetivo` tinyint(4) DEFAULT NULL,
  `fechaOperacion` datetime DEFAULT NULL,
  `observacion` text,
  `cedulaResponsable` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `registrostock`
--

INSERT INTO `registrostock` (`id`, `numOperacion`, `codigo`, `cantidad`, `objetivo`, `fechaOperacion`, `observacion`, `cedulaResponsable`) VALUES
(1, 1, '100149', 10, 1, '2017-10-03 22:44:03', 'Carga inicial', '10877056'),
(2, 1, '100902', 10, 1, '2017-10-03 22:44:03', 'Carga inicial', '10877056'),
(3, 1, '101714', 10, 1, '2017-10-03 22:44:03', 'Carga inicial', '10877056'),
(4, 1, '101779', 10, 1, '2017-10-03 22:44:03', 'Carga inicial', '10877056'),
(5, 1, '101782', 10, 1, '2017-10-03 22:44:03', 'Carga inicial', '10877056'),
(6, 1, '101784', 10, 1, '2017-10-03 22:44:03', 'Carga inicial', '10877056'),
(7, 1, '103146', 10, 1, '2017-10-03 22:44:03', 'Carga inicial', '10877056'),
(8, 1, '103891', 10, 1, '2017-10-03 22:44:03', 'Carga inicial', '10877056'),
(9, 1, '104521', 10, 1, '2017-10-03 22:44:03', 'Carga inicial', '10877056'),
(10, 1, '104908', 10, 1, '2017-10-03 22:44:03', 'Carga inicial', '10877056'),
(11, 2, '300001', 10, 1, '2017-10-03 22:45:40', 'Carga inicial', '10877056'),
(12, 2, '300002', 10, 1, '2017-10-03 22:45:40', 'Carga inicial', '10877056'),
(13, 2, '300003', 10, 1, '2017-10-03 22:45:40', 'Carga inicial', '10877056'),
(14, 2, '300004', 10, 1, '2017-10-03 22:45:40', 'Carga inicial', '10877056'),
(15, 2, '300005', 10, 1, '2017-10-03 22:45:40', 'Carga inicial', '10877056'),
(16, 2, '300006', 10, 1, '2017-10-03 22:45:40', 'Carga inicial', '10877056'),
(17, 2, '300008', 10, 1, '2017-10-03 22:45:40', 'Carga inicial', '10877056'),
(18, 2, '300009', 10, 1, '2017-10-03 22:45:40', 'Carga inicial', '10877056'),
(19, 2, '300010', 10, 1, '2017-10-03 22:45:40', 'Carga inicial', '10877056'),
(20, 2, '300011', 10, 1, '2017-10-03 22:45:40', 'Carga inicial', '10877056'),
(21, 3, '300168', 10, 1, '2017-10-03 22:47:13', 'Carga inicial', '10877056'),
(22, 3, '300169', 10, 1, '2017-10-03 22:47:13', 'Carga inicial', '10877056'),
(23, 3, '300170', 10, 1, '2017-10-03 22:47:13', 'Carga inicial', '10877056'),
(24, 3, '300172', 10, 1, '2017-10-03 22:47:13', 'Carga inicial', '10877056'),
(25, 3, '300177', 10, 1, '2017-10-03 22:47:13', 'Carga inicial', '10877056'),
(26, 3, '300181', 10, 1, '2017-10-03 22:47:13', 'Carga inicial', '10877056'),
(27, 3, '300185', 10, 1, '2017-10-03 22:47:13', 'Carga inicial', '10877056'),
(28, 3, '300198', 10, 1, '2017-10-03 22:47:13', 'Carga inicial', '10877056'),
(29, 3, '300199', 10, 1, '2017-10-03 22:47:13', 'Carga inicial', '10877056'),
(30, 3, '300200', 10, 1, '2017-10-03 22:47:13', 'Carga inicial', '10877056'),
(31, 4, '300096', 10, 1, '2017-10-03 22:48:45', 'Carga inicial', '10877056'),
(32, 4, '300098', 10, 1, '2017-10-03 22:48:45', 'Carga inicial', '10877056'),
(33, 4, '300103', 10, 1, '2017-10-03 22:48:45', 'Carga inicial', '10877056'),
(34, 4, '300107', 10, 1, '2017-10-03 22:48:45', 'Carga inicial', '10877056'),
(35, 4, '300120', 10, 1, '2017-10-03 22:48:45', 'Carga inicial', '10877056'),
(36, 4, '300121', 10, 1, '2017-10-03 22:48:45', 'Carga inicial', '10877056'),
(37, 4, '300122', 10, 1, '2017-10-03 22:48:45', 'Carga inicial', '10877056'),
(38, 4, '300123', 10, 1, '2017-10-03 22:48:45', 'Carga inicial', '10877056'),
(39, 4, '300124', 10, 1, '2017-10-03 22:48:45', 'Carga inicial', '10877056'),
(40, 4, '300127', 10, 1, '2017-10-03 22:48:45', 'Carga inicial', '10877056'),
(41, 5, '103898', 10, 1, '2017-10-03 22:50:03', 'Carga inicial', '10877056'),
(42, 5, '105229', 10, 1, '2017-10-03 22:50:03', 'Carga inicial', '10877056'),
(43, 5, '106120', 10, 1, '2017-10-03 22:50:03', 'Carga inicial', '10877056'),
(44, 5, '106266', 10, 1, '2017-10-03 22:50:03', 'Carga inicial', '10877056'),
(45, 5, '112924', 10, 1, '2017-10-03 22:50:03', 'Carga inicial', '10877056'),
(46, 5, '118804', 10, 1, '2017-10-03 22:50:03', 'Carga inicial', '10877056'),
(47, 5, '118806', 10, 1, '2017-10-03 22:50:03', 'Carga inicial', '10877056'),
(48, 5, '122538', 10, 1, '2017-10-03 22:50:03', 'Carga inicial', '10877056'),
(49, 5, '600046', 10, 1, '2017-10-03 22:50:03', 'Carga inicial', '10877056'),
(50, 5, '600047', 10, 1, '2017-10-03 22:50:03', 'Carga inicial', '10877056'),
(51, 6, '400026', 10, 1, '2017-10-03 22:51:29', 'Carga inicial', '10877056'),
(52, 6, '600021', 10, 1, '2017-10-03 22:51:29', 'Carga inicial', '10877056'),
(53, 6, '600025', 10, 1, '2017-10-03 22:51:29', 'Carga inicial', '10877056'),
(54, 6, '600023', 10, 1, '2017-10-03 22:51:29', 'Carga inicial', '10877056'),
(55, 6, '600053', 10, 1, '2017-10-03 22:51:29', 'Carga inicial', '10877056'),
(56, 6, '600054', 10, 1, '2017-10-03 22:51:29', 'Carga inicial', '10877056'),
(57, 6, '600144', 10, 1, '2017-10-03 22:51:29', 'Carga inicial', '10877056'),
(58, 6, '600145', 10, 1, '2017-10-03 22:51:29', 'Carga inicial', '10877056'),
(59, 6, '600154', 10, 1, '2017-10-03 22:51:29', 'Carga inicial', '10877056'),
(60, 6, '600156', 10, 1, '2017-10-03 22:51:29', 'Carga inicial', '10877056'),
(61, 7, '100063', 10, 1, '2017-10-03 22:52:57', 'Carga inicial', '10877056'),
(62, 7, '100064', 10, 1, '2017-10-03 22:52:57', 'Carga inicial', '10877056'),
(63, 7, '100065', 10, 1, '2017-10-03 22:52:57', 'Carga inicial', '10877056'),
(64, 7, '100066', 10, 1, '2017-10-03 22:52:57', 'Carga inicial', '10877056'),
(65, 7, '100067', 10, 1, '2017-10-03 22:52:57', 'Carga inicial', '10877056'),
(66, 7, '100068', 10, 1, '2017-10-03 22:52:57', 'Carga inicial', '10877056'),
(67, 7, '100070', 10, 1, '2017-10-03 22:52:57', 'Carga inicial', '10877056'),
(68, 7, '100071', 10, 1, '2017-10-03 22:52:57', 'Carga inicial', '10877056'),
(69, 7, '100072', 10, 1, '2017-10-03 22:52:57', 'Carga inicial', '10877056'),
(70, 7, '100073', 10, 1, '2017-10-03 22:52:57', 'Carga inicial', '10877056');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `transferencias`
--

CREATE TABLE `transferencias` (
  `id` int(11) NOT NULL,
  `numOperacion` int(11) DEFAULT NULL,
  `codigo` varchar(50) DEFAULT NULL,
  `cantidad` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `cedulaSolicita` varchar(20) DEFAULT NULL,
  `cedulaDespacha` varchar(20) DEFAULT NULL,
  `cedulaAutoriza` varchar(20) DEFAULT NULL,
  `cedulaTransportista` varchar(20) DEFAULT NULL,
  `fechaEntrega` datetime DEFAULT NULL,
  `fechaDevolucion` datetime DEFAULT NULL,
  `cedulaRecibeDev` varchar(20) DEFAULT NULL,
  `emisor` varchar(100) DEFAULT NULL,
  `receptor` varchar(100) DEFAULT NULL,
  `ubicacion` varchar(100) DEFAULT NULL,
  `observacion` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Volcado de datos para la tabla `transferencias`
--

INSERT INTO `transferencias` (`id`, `numOperacion`, `codigo`, `cantidad`, `status`, `cedulaSolicita`, `cedulaDespacha`, `cedulaAutoriza`, `cedulaTransportista`, `fechaEntrega`, `fechaDevolucion`, `cedulaRecibeDev`, `emisor`, `receptor`, `ubicacion`, `observacion`) VALUES
(1, 9, '300169', 2, 1, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción A', 'Construcción', ''),
(2, 9, '300170', 1, 1, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción A', 'Construcción', ''),
(3, 9, '300185', 1, 2, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '2017-10-03 23:35:44', '10877056', 'Almacen', 'Construcción A', 'Construcción', ''),
(4, 9, '300096', 1, 2, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '2017-10-03 23:34:18', '10877056', 'Almacen', 'Construcción A', 'Construcción', ''),
(5, 9, '300127', 3, 2, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '2017-10-03 23:35:44', '10877056', 'Almacen', 'Construcción A', 'Construcción', ''),
(6, 9, '300121', 1, 1, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción A', 'Construcción', ''),
(7, 9, '100902', 1, 2, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '2017-10-03 23:34:18', '10877056', 'Almacen', 'Construcción A', 'Construcción', ''),
(8, 9, '103146', 2, 2, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '2017-10-03 23:35:44', '10877056', 'Almacen', 'Construcción A', 'Construcción', ''),
(9, 9, '101779', 1, 3, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción A', 'Construcción', ''),
(10, 9, '300008', 3, 3, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción A', 'Construcción', ''),
(11, 9, '300010', 3, 3, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción A', 'Construcción', ''),
(12, 9, '300005', 3, 2, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '2017-10-03 23:34:18', '10877056', 'Almacen', 'Construcción A', 'Construcción', ''),
(13, 9, '300009', 3, 1, '8866458', '10877056', '8533161', '10927393', '2017-10-03 23:07:31', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción A', 'Construcción', ''),
(14, 14, '300200', 3, 1, '10927393', '10877056', '13798626', '11442535', '2017-10-03 23:28:04', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción B', 'Construcción', ''),
(15, 14, '300199', 5, 1, '10927393', '10877056', '13798626', '11442535', '2017-10-03 23:28:04', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción B', 'Construcción', ''),
(16, 14, '300098', 3, 1, '10927393', '10877056', '13798626', '11442535', '2017-10-03 23:28:04', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción B', 'Construcción', ''),
(17, 14, '300107', 2, 1, '10927393', '10877056', '13798626', '11442535', '2017-10-03 23:28:04', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción B', 'Construcción', ''),
(18, 14, '100149', 3, 1, '10927393', '10877056', '13798626', '11442535', '2017-10-03 23:28:04', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción B', 'Construcción', ''),
(19, 14, '101714', 4, 1, '10927393', '10877056', '13798626', '11442535', '2017-10-03 23:28:04', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción B', 'Construcción', ''),
(20, 14, '300001', 4, 1, '10927393', '10877056', '13798626', '11442535', '2017-10-03 23:28:04', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción B', 'Construcción', ''),
(21, 14, '300005', 1, 1, '10927393', '10877056', '13798626', '11442535', '2017-10-03 23:28:04', '0000-00-00 00:00:00', '', 'Almacen', 'Construcción B', 'Construcción', '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `usuarios`
--

CREATE TABLE `usuarios` (
  `id` int(11) NOT NULL,
  `clave` varchar(50) DEFAULT NULL,
  `codigo` varchar(50) DEFAULT NULL,
  `cedula` varchar(20) DEFAULT NULL,
  `nombre` varchar(200) DEFAULT NULL,
  `tipo` tinyint(4) DEFAULT NULL,
  `cargo` varchar(200) DEFAULT NULL,
  `dependencia` varchar(200) DEFAULT NULL,
  `ficha` varchar(20) DEFAULT NULL,
  `fechaIngreso` datetime DEFAULT NULL,
  `fechaCreacion` datetime DEFAULT NULL,
  `fechaActualizacion` datetime DEFAULT NULL,
  `cedulaEditor` varchar(20) DEFAULT NULL,
  `tallaCamisa` tinyint(4) DEFAULT NULL,
  `tallaChaqueta` tinyint(4) DEFAULT NULL,
  `tallaPantalon` tinyint(4) DEFAULT NULL,
  `tallaBotas` tinyint(4) DEFAULT NULL,
  `tallaZapatos` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `usuarios`
--

INSERT INTO `usuarios` (`id`, `clave`, `codigo`, `cedula`, `nombre`, `tipo`, `cargo`, `dependencia`, `ficha`, `fechaIngreso`, `fechaCreacion`, `fechaActualizacion`, `cedulaEditor`, `tallaCamisa`, `tallaChaqueta`, `tallaPantalon`, `tallaBotas`, `tallaZapatos`) VALUES
(2, '1234', '10877056', '10877056', 'HERNANDEZ SANCHEZ, IGOR ENRIQUE', 1, 'JEFE DE ALMACEN', '200251', '3293', '2014-09-29 00:00:00', '2017-10-03 21:59:57', '2017-10-03 21:59:57', '00000000', 40, 40, 34, 41, 41),
(3, '1234', '18013215', '18013215', 'MARTINEZ MUÑOZ,FERNANDO JESUS', 1, 'JEFE DE ALMACEN', '204000', '4007', '2015-09-14 00:00:00', '2017-10-03 21:59:57', '2017-10-03 21:59:57', '00000000', 38, 38, 28, 39, 39),
(4, '', '14836527', '14836527', 'CHACIN PAJARERO, OSWALDO JOSE', 3, 'SUPERVISOR', '204000', '439', '2008-11-17 00:00:00', '2017-10-03 22:02:55', '2017-10-03 22:02:55', '10877056', 40, 40, 34, 40, 40),
(5, '', '13994398', '13994398', 'DELGADO JULIO, MANUEL ENRIQUE', 3, 'SUPERVISOR', '200251', '256', '2005-12-01 00:00:00', '2017-10-03 22:02:55', '2017-10-03 22:02:55', '10877056', 32, 32, 30, 36, 36),
(6, '', '11175789', '11175789', 'GARCIA GONZALEZ, EFRAIN RAFAEL', 3, 'SUPERVISOR', '200251', '2111', '2013-11-28 00:00:00', '2017-10-03 22:02:55', '2017-10-03 22:02:55', '10877056', 38, 38, 32, 40, 40),
(7, '', '13798626', '13798626', 'MACHADO REYES, ALY RAFAEL', 3, 'SUPERVISOR', '204000', '4200', '2017-03-10 00:00:00', '2017-10-03 22:02:55', '2017-10-03 22:02:55', '10877056', 38, 38, 38, 45, 45),
(8, '', '10392001', '10392001', 'MARQUEZ TORO, JESUS ENRIQUE', 3, 'SUPERVISOR', '200251', '3452', '2015-04-06 00:00:00', '2017-10-03 22:02:55', '2017-10-03 22:02:55', '10877056', 40, 40, 34, 42, 42),
(9, '', '9819595', '9819595', 'MARTINEZ, ELEAZAR JESUS', 3, 'SUPERVISOR', '204000', '1698', '2010-08-16 00:00:00', '2017-10-03 22:02:55', '2017-10-03 22:02:55', '10877056', 0, 0, 0, 0, 0),
(10, '', '8533161', '8533161', 'MORENO GUERRERO, DENIS ANTONIO', 3, 'SUPERVISOR', '200251', '3579', '2015-06-15 00:00:00', '2017-10-03 22:02:55', '2017-10-03 22:02:55', '10877056', 30, 30, 28, 42, 42),
(11, '', '81715863', '81715863', 'RUIZ PATIÑO, WILLIAM', 3, 'SUPERVISOR', '200251', '72', '1990-10-10 00:00:00', '2017-10-03 22:02:55', '2017-10-03 22:02:55', '10877056', 44, 44, 36, 42, 42),
(12, '', '8923564', '8923564', 'SANCHEZ HERNANDEZ, HENRY JOSE', 3, 'SUPERVISOR', '200251', '2105', '2013-11-11 00:00:00', '2017-10-03 22:02:55', '2017-10-03 22:02:55', '10877056', 40, 40, 34, 43, 43),
(13, '', '8866458', '8866458', 'ALVAREZ, RICARDO JOSE', 4, 'OPERADOR DE GRUA DE 1RA', '200251', '3201', '2014-06-19 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 40, 40, 32, 41, 41),
(14, '', '16219875', '16219875', 'APARICIO HURTADO, YILSON RAMON', 4, 'MONTADOR', '200251', '4103', '2016-10-06 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 32, 32, 32, 40, 40),
(15, '', '8544364', '8544364', 'ASCANIO BERMUDEZ, VICTOR MANUEL', 4, 'MAESTRO DE OBRA DE 1RA.', '200251', '4055', '2016-02-15 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 38, 42, 42),
(16, '', '10927393', '10927393', 'BALLERA BRITO, CRUZ JOSÉ', 4, 'AYUDANTE', '200251', '3203', '2014-06-19 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 32, 38, 38),
(17, '', '24855380', '24855380', 'CABEZA LEZAMA, BRYAN JOSUE', 4, 'OPERADOR DE GRUA DE 2DA', '200251', '4062', '2016-04-04 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 36, 36, 36, 43, 43),
(18, '', '11442535', '11442535', 'CAMPOS BONILLA, JOSE FELIX', 4, 'MONTADOR', '200251', '4116', '2016-10-24 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 32, 32, 28, 41, 41),
(19, '', '12131884', '12131884', 'CAMPOS, ELIEZER EDMUNDO', 4, 'ELECTRICISTA DE 1RA', '200251', '1771', '2011-09-06 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 40, 40, 30, 40, 40),
(20, '', '15587270', '15587270', 'CASTILLO MATERAN, GREGORY JOSE', 4, 'MONTADOR', '200251', '4174', '2017-02-15 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 34, 34, 38, 41, 41),
(21, '', '11114661', '11114661', 'CASTRO BECERRA, FELIX GREGORIO', 4, 'MONTADOR', '200251', '4085', '2016-08-31 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 32, 32, 30, 41, 41),
(22, '', '10271156', '10271156', 'CORREA PEREZ, JOSE GREGORIO', 4, 'MONTADOR', '200251', '3590', '2015-06-18 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 34, 41, 41),
(23, '', '8869854', '8869854', 'DE SOUZA FERRAZ, JOSE ADOLFO', 4, 'AYUDANTE', '200251', '3191', '2014-06-18 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 34, 41, 41),
(24, '', '25744774', '25744774', 'DELGADO CASTILLO, MARCO ANTONIO', 4, 'AYUDANTE', '200251', '4105', '2016-10-03 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 32, 32, 30, 40, 40),
(25, '', '16055045', '16055045', 'FIGUEROA FRATELLO, LUIS ENRIQUE', 4, 'OPERADOR DE GRUA DE 1RA', '200251', '4039', '2015-10-29 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 32, 32, 32, 42, 42),
(26, '', '10932199', '10932199', 'FLORES GUEVARA, ALEXIS RAFAEL', 4, 'OP. DE MAQ.-HERRMIENTAS DE 1ra', '200251', '3262  ', '2014-07-22 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 44, 44, 34, 43, 43),
(27, '', '12909772', '12909772', 'GARCIA, JOSE YSABEL', 4, 'MONTADOR', '200251', '4165', '2017-01-25 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 36, 36, 34, 41, 41),
(28, '', '8866493', '8866493', 'GIL MARQUEZ, VICENTE JOSE', 4, 'OPERADOR DE GRUA DE 1RA', '200251', '4211', '2017-06-15 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 42, 42, 36, 44, 44),
(29, '', '17039078', '17039078', 'GONZALEZ, DOUGLAS', 4, 'MAESTRO DE OBRA DE 1RA.', '200251', '4127', '2016-11-07 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 0, 0, 0, 0, 0),
(30, '', '15.186.292', '15.186.292', 'GUZMAN, JOSE GREGORIO', 4, 'MONTADOR (ARGENIS MORENO)', '200251', '4142', '2016-11-14 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 30, 30, 32, 40, 40),
(31, '', '27330485', '27330485', 'HERNANDEZ GUZMAN, DARWIN ENRIQUE', 4, 'AYUDANTE', '200251', '4126', '2016-11-14 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 30, 30, 32, 39, 39),
(32, '', '17541471', '17541471', 'HERNANDEZ SOLANO, JORAN RAFAEL', 4, 'MONTADOR', '200251', '492', '2016-09-26 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 40, 40, 34, 43, 43),
(33, '', '8792618', '8792618', 'LEDEZMA GUTIERREZ, WILLIANS JOSE', 4, 'OPERADOR DE GRUA DE 1RA', '204000', '782', '2004-09-07 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 34, 42, 42),
(34, '', '14622106', '14622106', 'LOPEZ GONZALEZ, DENIS ORLANDO', 4, 'MAESTRO DE OBRA DE 1RA.', '200266', '4201', '2017-03-13 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 0, 0, 0, 0, 0),
(35, '', '13092682', '13092682', 'LOZADA BRITO, NELSON ANTONIO', 4, 'AYUDANTE', '200251', '3340', '2014-12-11 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 36, 42, 42),
(36, '', '22592782', '22592782', 'LOZANO GALVEZ, ZADITH LANDITH', 4, 'AYUDANTE', '200251', '3208', '2014-06-25 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 28, 36, 36),
(37, '', '10389721', '10389721', 'MARK MARRERO,JOSE GREGORIO', 4, 'AYUDANTE', '200251', '3573', '2015-06-05 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 42, 42, 34, 42, 42),
(38, '', '9903955', '9903955', 'MARTINEZ AULAR, JOSE ALFREDO', 4, 'MAESTRO DE OBRA DE 1RA.', '200260', '3393', '2015-02-09 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 0, 0, 0, 0, 0),
(39, '', '21608268', '21608268', 'MARTINEZ VELASQUEZ, ALFRENYS DE JESUS', 4, 'AYUDANTE', '200251', '4114', '2016-10-24 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 36, 36, 34, 40, 40),
(40, '', '8936729', '8936729', 'MEDINA BLANCA, EDWIN EDUVILIO', 4, 'AYUDANTE', '200266', '4202', '2017-03-21 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 32, 32, 32, 41, 41),
(41, '', '19040168', '19040168', 'MINOTTI AZOCAR, KELIN YOVANNYS', 4, 'AYUDANTE', '200266', '4172', '2017-02-13 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 36, 36, 36, 42, 42),
(42, '', '13093564', '13093564', 'MORENO NAVARRO, OSKARINA DEL VALLE', 4, 'AYUDANTE', '200251', '4065', '2016-04-15 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 30, 36, 36),
(43, '', '16614751', '16614751', 'MUÑOZ GUZMAN,JESUS RAFAEL', 4, 'MONTADOR', '200251', '3549', '2015-06-02 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 36, 36, 34, 41, 41),
(44, '', '13089924', '13089924', 'MUÑOZ HOSPEDALES,MOISES RAMSES', 4, 'PINTOR DE 1RA.', '200251', '3632', '2015-08-17 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 40, 40, 32, 40, 40),
(45, '', '13782111', '13782111', 'NACIMIENTO RABELLO, ASTERIO LORENZO', 4, 'MONTADOR', '200251', '3172', '2014-06-17 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 40, 40, 34, 41, 41),
(46, '', '27010726', '27010726', 'ORTUÑEZ GUATUME, MOISES JAVIER', 4, 'AYUDANTE', '200251', '4093', '2016-10-04 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 30, 30, 28, 38, 38),
(47, '', '10469911', '10469911', 'PEREZ LEMUS, LUIS BELTRAN', 4, 'MAESTRO DE OBRA DE 2DA.', '200251', '47', '2013-09-05 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 42, 42, 34, 40, 40),
(48, '', '18013364', '18013364', 'POMONTI GUZMÁN, DIOBER JOSÉ', 4, 'MONTADOR', '200251', '4157', '2017-01-23 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 0, 0, 0, 0, 0),
(49, '', '24541099', '24541099', 'REBOLLEDO RINCONES, DARLING JESUS', 4, 'AYUDANTE', '200251', '4082', '2016-08-15 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 40, 40, 34, 43, 43),
(50, '', '8542230', '8542230', 'RIVAS, JONNY JOSE', 4, 'MONTADOR', '200251', '4100', '2016-10-06 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 36, 42, 42),
(51, '', '21110034', '21110034', 'RODRIGUEZ BLANCO, FRANCISCO ANTONIO', 4, 'MONTADOR', '200251', '3574', '2015-06-08 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 44, 44, 34, 43, 43),
(52, '', '8293942', '8293942', 'RODRIGUEZ MARCHAN, SERGIO JOSE', 4, 'FABRICADOR', '200251', '3554', '2015-06-02 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 42, 42, 36, 40, 40),
(53, '', '11449499', '11449499', 'RODRIGUEZ, ALEXIS JOSE', 4, 'PINTOR DE 1RA.', '200251', '3196', '2014-06-19 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 40, 40, 36, 40, 40),
(54, '', '15688555', '15688555', 'RODRIGUEZ, RAFAEL ALEXANDER', 4, 'AYUDANTE', '200251', '3282', '2014-08-26 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 42, 42, 34, 41, 41),
(55, '', '13798722', '13798722', 'ROMERO FARFAN,ARQUIMEDES ALBERTO', 4, 'MAESTRO DE OBRA DE 1RA.', '200251', '3529', '2015-05-18 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 40, 40, 36, 42, 42),
(56, '', '14611405', '14611405', 'RONDON BELMONTE, ORLANDO JOSE', 4, 'AYUDANTE', '200266', '4193', '2017-03-06 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 42, 42, 30, 42, 42),
(57, '', '12194087', '12194087', 'SALAZAR,FRANKLIN ALEXANDER', 4, 'MONTADOR', '200251', '3174', '2014-06-17 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 32, 38, 38),
(58, '', '10930156', '10930156', 'SANCHEZ, MARCO ANTONIO', 4, 'MONTADOR', '200266', '4195', '2017-03-06 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 30, 39, 39),
(59, '', '12053055', '12053055', 'SERRANO RIVERA, YENNY CECILIA', 4, 'MAESTRO DE OBRA DE 1RA.', '200266', '4196', '2017-03-07 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 0, 0, 0, 0, 0),
(60, '', '8536487', '8536487', 'VALDEZ, ANGEL HENRIQUE', 4, 'SOLDADOR DE 1RA.', '200251', '3313', '2014-11-13 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 41, 41, 41),
(61, '', '5571110', '5571110', 'VANDER PERDOMO, JESUS RAMON', 4, 'AYUDANTE', '200251', '493', '2016-09-26 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 35, 35, 32, 40, 40),
(62, '', '11514914', '11514914', 'VELASQUEZ GIL, CRUZ OMAR', 4, 'MONTADOR', '200251', '4091', '2016-09-26 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 40, 40, 32, 41, 41),
(63, '', '18838951', '18838951', 'VELAZQUEZ GUEVARA, JOSE GREGORIO', 4, 'MONTADOR', '200251', '4115', '2016-10-24 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 36, 36, 30, 39, 39),
(64, '', '15149698', '15149698', 'VIERA ECHEVERRIA, VLADIMIR WILLIANS', 4, 'MONTADOR', '204000', '1929', '2012-04-18 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 38, 38, 38, 42, 42),
(65, '', '10549261', '10549261', 'YANEZ LUGO, FRANKLIN GREGORIO', 4, 'MONTADOR', '200251', '4159', '2017-01-23 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 30, 30, 34, 41, 41),
(66, '', '10573257', '10573257', 'ZAPATA BOLIVAR, JOSE GREGORIO', 4, 'ELECTRICISTA DE 1RA', '200266', '4183', '2017-02-21 00:00:00', '2017-10-03 22:03:18', '2017-10-03 22:03:18', '10877056', 36, 36, 30, 40, 40);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `bienes`
--
ALTER TABLE `bienes`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `devolucionprestamo`
--
ALTER TABLE `devolucionprestamo`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `devoluciontransferencia`
--
ALTER TABLE `devoluciontransferencia`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `dotacion`
--
ALTER TABLE `dotacion`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `numoperaciones`
--
ALTER TABLE `numoperaciones`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `operaciones`
--
ALTER TABLE `operaciones`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `prestamos`
--
ALTER TABLE `prestamos`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `registrostock`
--
ALTER TABLE `registrostock`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `transferencias`
--
ALTER TABLE `transferencias`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `usuarios`
--
ALTER TABLE `usuarios`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `bienes`
--
ALTER TABLE `bienes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;
--
-- AUTO_INCREMENT de la tabla `devolucionprestamo`
--
ALTER TABLE `devolucionprestamo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de la tabla `devoluciontransferencia`
--
ALTER TABLE `devoluciontransferencia`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT de la tabla `dotacion`
--
ALTER TABLE `dotacion`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT de la tabla `items`
--
ALTER TABLE `items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `numoperaciones`
--
ALTER TABLE `numoperaciones`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `operaciones`
--
ALTER TABLE `operaciones`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT de la tabla `prestamos`
--
ALTER TABLE `prestamos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT de la tabla `registrostock`
--
ALTER TABLE `registrostock`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;
--
-- AUTO_INCREMENT de la tabla `transferencias`
--
ALTER TABLE `transferencias`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT de la tabla `usuarios`
--
ALTER TABLE `usuarios`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;