/*
Navicat MySQL Data Transfer

Source Server         : Server 40
Source Server Version : 50736
Source Host           : 192.200.100.40:3306
Source Database       : dotacion

Target Server Type    : MYSQL
Target Server Version : 50736
File Encoding         : 65001

Date: 2026-03-10 14:51:26
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `area` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cargo
-- ----------------------------
DROP TABLE IF EXISTS `cargo`;
CREATE TABLE `cargo` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `CARGO` varchar(100) COLLATE utf8mb4_spanish_ci NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `CARGO` (`CARGO`)
) ENGINE=MyISAM AUTO_INCREMENT=147 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

-- ----------------------------
-- Table structure for ccosto
-- ----------------------------
DROP TABLE IF EXISTS `ccosto`;
CREATE TABLE `ccosto` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `CCOSTO` varchar(100) COLLATE utf8mb4_spanish_ci NOT NULL,
  `DESCRIPCION` varchar(100) COLLATE utf8mb4_spanish_ci NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `CCOSTO` (`CCOSTO`)
) ENGINE=MyISAM AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

-- ----------------------------
-- Table structure for dotacion
-- ----------------------------
DROP TABLE IF EXISTS `dotacion`;
CREATE TABLE `dotacion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `empleado_id` int(11) NOT NULL,
  `nombre_epp` varchar(255) COLLATE utf8mb4_spanish2_ci NOT NULL,
  `cantidad` int(11) NOT NULL,
  `fecha_entrega` datetime DEFAULT CURRENT_TIMESTAMP,
  `codigo_epp` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `empleado_id` (`empleado_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2071 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish2_ci;

-- ----------------------------
-- Table structure for dotxcc
-- ----------------------------
DROP TABLE IF EXISTS `dotxcc`;
CREATE TABLE `dotxcc` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `FECHA` date DEFAULT NULL,
  `CEDULA` int(20) DEFAULT NULL,
  `CCOSTO` varchar(100) COLLATE utf8mb4_spanish_ci NOT NULL,
  `CARGO` varchar(100) COLLATE utf8mb4_spanish_ci NOT NULL,
  `ITEM` varchar(100) COLLATE utf8mb4_spanish_ci NOT NULL,
  `DESCRIPCION` varchar(100) COLLATE utf8mb4_spanish_ci NOT NULL,
  `CANTIDAD` int(20) DEFAULT NULL,
  `ESTADO` varchar(10) COLLATE utf8mb4_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1638 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

-- ----------------------------
-- Table structure for empleado
-- ----------------------------
DROP TABLE IF EXISTS `empleado`;
CREATE TABLE `empleado` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cedula` varchar(255) DEFAULT NULL,
  `nombre` varchar(255) NOT NULL,
  `ccosto` varchar(50) DEFAULT NULL,
  `cargo` varchar(50) DEFAULT NULL,
  `fingreso` date DEFAULT NULL,
  `area` varchar(250) DEFAULT NULL,
  `TALLAPANT` varchar(255) DEFAULT NULL,
  `TALLACAMI` varchar(255) DEFAULT NULL,
  `TALLABOT` varchar(255) DEFAULT NULL,
  `tallaChaq` varchar(255) DEFAULT NULL,
  `tallaImp` varchar(255) DEFAULT NULL,
  `tpContrato` varchar(255) DEFAULT NULL,
  `ESTADO` varchar(20) DEFAULT NULL,
  `tpEntrega` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=613 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for entregasst
-- ----------------------------
DROP TABLE IF EXISTS `entregasst`;
CREATE TABLE `entregasst` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `cedula` varchar(12) DEFAULT NULL,
  `nombre` varchar(80) DEFAULT NULL,
  `ccosto` varchar(255) DEFAULT NULL,
  `area` varchar(30) DEFAULT NULL,
  `cargo` varchar(255) DEFAULT NULL,
  `fEntrega` date DEFAULT NULL,
  `tpEstado` varchar(100) DEFAULT NULL,
  `codigo` varchar(10) DEFAULT NULL,
  `epp` varchar(100) DEFAULT NULL,
  `cantidad` varchar(3) DEFAULT NULL,
  `FIRMA` mediumblob,
  `userEntrega` varchar(50) DEFAULT NULL,
  `tpEntrega` varchar(255) DEFAULT NULL,
  `PDF` mediumblob,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1637 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for eppsst
-- ----------------------------
DROP TABLE IF EXISTS `eppsst`;
CREATE TABLE `eppsst` (
  `CODIGO` varchar(10) NOT NULL,
  `NOMBRE` varchar(100) NOT NULL,
  `ENT` varchar(5) DEFAULT NULL,
  `SAL` varchar(5) DEFAULT NULL,
  `PRECIO` int(1) DEFAULT NULL,
  PRIMARY KEY (`CODIGO`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for inventario
-- ----------------------------
DROP TABLE IF EXISTS `inventario`;
CREATE TABLE `inventario` (
  `ID` int(250) NOT NULL AUTO_INCREMENT,
  `CODIGO` int(15) NOT NULL,
  `DESCRIPCION` varchar(250) NOT NULL,
  `CANTIDAD` int(10) NOT NULL,
  `ESTADO` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`ID`,`CODIGO`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for inventariousado
-- ----------------------------
DROP TABLE IF EXISTS `inventariousado`;
CREATE TABLE `inventariousado` (
  `ID` int(250) NOT NULL AUTO_INCREMENT,
  `CODIGO` int(15) NOT NULL,
  `DESCRIPCION` varchar(250) NOT NULL,
  `CANTIDAD` int(10) NOT NULL,
  `ESTADO` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for noe
-- ----------------------------
DROP TABLE IF EXISTS `noe`;
CREATE TABLE `noe` (
  `DOCUMENTO` int(10) DEFAULT NULL,
  `CONSECUTIVO` int(5) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for reginventario
-- ----------------------------
DROP TABLE IF EXISTS `reginventario`;
CREATE TABLE `reginventario` (
  `ID` int(250) NOT NULL AUTO_INCREMENT,
  `fechaIngreso` date DEFAULT NULL,
  `CODIGO` int(15) NOT NULL,
  `DESCRIPCION` varchar(250) NOT NULL,
  `CANTIDAD` int(10) NOT NULL,
  `MOVIMIENTO` varchar(10) DEFAULT '0',
  `AREA` varchar(30) DEFAULT NULL,
  `userEntrega` varchar(255) DEFAULT NULL,
  `nfactura` varchar(255) DEFAULT NULL,
  `provedor` varchar(255) DEFAULT NULL,
  `precio` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1720 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for regusado
-- ----------------------------
DROP TABLE IF EXISTS `regusado`;
CREATE TABLE `regusado` (
  `ID` int(250) NOT NULL AUTO_INCREMENT,
  `fechaIngreso` date DEFAULT NULL,
  `CODIGO` int(15) NOT NULL,
  `DESCRIPCION` varchar(250) NOT NULL,
  `CANTIDAD` int(10) NOT NULL,
  `MOVIMIENTO` varchar(10) DEFAULT '0',
  `AREA` varchar(30) DEFAULT NULL,
  `userEntrega` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for usuarios
-- ----------------------------
DROP TABLE IF EXISTS `usuarios`;
CREATE TABLE `usuarios` (
  `USR` varchar(10) COLLATE utf8mb4_spanish2_ci NOT NULL,
  `PAS` varchar(10) COLLATE utf8mb4_spanish2_ci NOT NULL,
  `NOMBRE` varchar(60) COLLATE utf8mb4_spanish2_ci NOT NULL,
  `GRADO` int(1) NOT NULL,
  `DESC GRADO` varchar(255) COLLATE utf8mb4_spanish2_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish2_ci;
