-- MySQL dump 10.13  Distrib 5.5.52, for Linux (x86_64)
--
-- Host: localhost    Database: antsoftw_leticia_operativo
-- ------------------------------------------------------
-- Server version	5.5.52-cll

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `abastecimiento`
--

DROP TABLE IF EXISTS `abastecimiento`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abastecimiento` (
  `ab_numero` int(9) NOT NULL DEFAULT '0',
  `ab_codsis` varchar(20) NOT NULL DEFAULT '',
  `ab_detsis` varchar(20) NOT NULL DEFAULT '',
  `ab_fecini` date NOT NULL DEFAULT '0000-00-00',
  `ab_horini` time NOT NULL DEFAULT '00:00:00',
  `ab_fecfin` date NOT NULL DEFAULT '0000-00-00',
  `ab_horfin` time NOT NULL DEFAULT '00:00:00',
  `ab_lectura` double(12,3) DEFAULT NULL,
  `ab_observa` text,
  `ab_fecreg` date NOT NULL,
  `ab_horreg` time NOT NULL,
  `ab_usuario` varchar(20) NOT NULL,
  `ab_tipofte` varchar(20) NOT NULL,
  `ab_usures` int(9) NOT NULL,
  `ab_volres` int(9) NOT NULL,
  `ab_usunres` int(9) NOT NULL,
  `ab_volnres` int(9) NOT NULL,
  `ab_valorm3` double(15,2) NOT NULL,
  PRIMARY KEY (`ab_numero`),
  KEY `ab_codsis` (`ab_codsis`),
  KEY `ab_detsis` (`ab_detsis`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `abastecimiento`
--

LOCK TABLES `abastecimiento` WRITE;
/*!40000 ALTER TABLE `abastecimiento` DISABLE KEYS */;
/*!40000 ALTER TABLE `abastecimiento` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `accesos`
--

DROP TABLE IF EXISTS `accesos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accesos` (
  `ap_codpro` int(11) NOT NULL DEFAULT '0',
  `ap_nombre` char(40) NOT NULL DEFAULT '',
  `ap_nivelp` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ap_codpro`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `accesos`
--

LOCK TABLES `accesos` WRITE;
/*!40000 ALTER TABLE `accesos` DISABLE KEYS */;
/*!40000 ALTER TABLE `accesos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `actividad`
--

DROP TABLE IF EXISTS `actividad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `actividad` (
  `ac_codact` int(11) NOT NULL DEFAULT '0',
  `ac_descri` char(60) NOT NULL,
  `ac_tiempo` float(3,2) NOT NULL DEFAULT '0.00',
  `ac_nroeje` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ac_codact`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `actividad`
--

LOCK TABLES `actividad` WRITE;
/*!40000 ALTER TABLE `actividad` DISABLE KEYS */;
INSERT INTO `actividad` (`ac_codact`, `ac_descri`, `ac_tiempo`, `ac_nroeje`) VALUES (1,'CAMBIO DE VENTOSA',1.00,1),(2,'INSTALACION DOMICILIARIAS',1.00,1),(3,'INSTALACION MICROMEDIDORES',1.00,1),(4,'MANTENIMIENTO DE PLANTA',1.00,1),(5,'MANTENIMIENTO RED DE CONDUCCION',1.00,1),(6,'MANTEMIENTO DESAIRADORES',1.00,1),(10,'MANTENIMIENTO ESTACIONES DE MACROS',1.00,1),(13,'MANTENIMIENTO TABLERO',1.00,1),(14,'REPARACION DE FUGA DOMICILIARIA',1.00,1),(15,'REPARACION DE FUGA RED MENOR',1.00,1),(16,'REPOSICION DE MEDIDOR',1.00,1),(17,'REVISION CONSUMOS ALTOS',1.00,1),(18,'REVISION INTRADOMICILIARIA',1.00,1),(19,'REVISION MICROMEDIDORES',1.00,1),(20,'SUSPENSION O CORTE',1.00,2),(55,'DISPONIBILIDAD DE SERVICIO',1.00,1),(57,'TRASLADO DE ACOMETIDA',1.00,1),(59,'REPOSICION DE PAVIMENTO RIGIDO',1.00,1),(60,'UBICACION DEL MEDIDOR',1.00,1);
/*!40000 ALTER TABLE `actividad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `actmetraje`
--

DROP TABLE IF EXISTS `actmetraje`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `actmetraje` (
  `am_codres` char(2) NOT NULL,
  `am_descri` char(40) DEFAULT NULL,
  `am_valor` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`am_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `actmetraje`
--

LOCK TABLES `actmetraje` WRITE;
/*!40000 ALTER TABLE `actmetraje` DISABLE KEYS */;
INSERT INTO `actmetraje` (`am_codres`, `am_descri`, `am_valor`) VALUES ('1','EXCAVACION EN M3',15899.00),('2','RELLENO DE MATERIAL DE SITIO EN M3',10753.00),('3','RELLENO DE MATERIAL IMPORTADO EN M3',53870.00),('4','DEMOLICION DE ANDEN EN CONCRETO E=10',7050.00),('5','DEMOLICION DE LOZA E=20',16107.00),('6','ANDEN EN CONCRETO 2500 PSI',25350.00),('7','LOZA DE PAVIMENTO E=15',60673.00),('8','RETIRO DE MATERIAL SOBRANTE Y DISPOSICIO',17398.00),('9','CORTADORA CON DISCO',8097.00);
/*!40000 ALTER TABLE `actmetraje` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `area`
--

DROP TABLE IF EXISTS `area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `area` (
  `ar_codare` int(3) NOT NULL DEFAULT '0',
  `ar_descri` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`ar_codare`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `area`
--

LOCK TABLES `area` WRITE;
/*!40000 ALTER TABLE `area` DISABLE KEYS */;
INSERT INTO `area` (`ar_codare`, `ar_descri`) VALUES (1,'Division Tecnica Operativa'),(5,'Comercial');
/*!40000 ALTER TABLE `area` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `arepre`
--

DROP TABLE IF EXISTS `arepre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arepre` (
  `ap_codare` int(4) NOT NULL,
  `ap_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`ap_codare`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `arepre`
--

LOCK TABLES `arepre` WRITE;
/*!40000 ALTER TABLE `arepre` DISABLE KEYS */;
/*!40000 ALTER TABLE `arepre` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `barrio`
--

DROP TABLE IF EXISTS `barrio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `barrio` (
  `ba_codbar` int(4) NOT NULL,
  `ba_descri` char(40) NOT NULL,
  PRIMARY KEY (`ba_codbar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `barrio`
--

LOCK TABLES `barrio` WRITE;
/*!40000 ALTER TABLE `barrio` DISABLE KEYS */;
INSERT INTO `barrio` (`ba_codbar`, `ba_descri`) VALUES (1,'IBAGUE');
/*!40000 ALTER TABLE `barrio` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `calidadagua`
--

DROP TABLE IF EXISTS `calidadagua`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `calidadagua` (
  `cag_numero` int(9) NOT NULL,
  `cag_fecini` date DEFAULT NULL,
  `cag_horini` time DEFAULT NULL,
  `cag_fecfin` date DEFAULT NULL,
  `cag_horfin` time DEFAULT NULL,
  `cag_punto` varchar(20) NOT NULL,
  `cag_laboratorio` varchar(10) NOT NULL,
  `cag_tipmue` char(10) NOT NULL,
  `cag_clamue` char(30) NOT NULL,
  `cag_color` varchar(15) NOT NULL,
  `cag_turbiedad` varchar(15) NOT NULL,
  `cag_ph` varchar(15) NOT NULL,
  `cag_clores` varchar(15) NOT NULL,
  `cag_dureza` varchar(15) NOT NULL,
  `cag_cloruros` varchar(15) NOT NULL,
  `cag_alcalinidad` varchar(15) NOT NULL,
  `cag_coliformes` varchar(15) NOT NULL,
  `cag_tecnica` char(30) NOT NULL,
  `cag_escher` varchar(15) NOT NULL,
  `cag_tecnicae` char(30) NOT NULL,
  `cag_irca` varchar(15) NOT NULL,
  `cag_muestra` varchar(12) NOT NULL,
  `cag_hierro` varchar(15) NOT NULL,
  PRIMARY KEY (`cag_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calidadagua`
--

LOCK TABLES `calidadagua` WRITE;
/*!40000 ALTER TABLE `calidadagua` DISABLE KEYS */;
/*!40000 ALTER TABLE `calidadagua` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `calidadaguaes`
--

DROP TABLE IF EXISTS `calidadaguaes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `calidadaguaes` (
  `cag_numero` int(9) NOT NULL,
  `cag_fecini` date DEFAULT NULL,
  `cag_horini` time DEFAULT NULL,
  `cag_fecfin` date DEFAULT NULL,
  `cag_horfin` time DEFAULT NULL,
  `cag_punto` varchar(20) NOT NULL,
  `cag_laboratorio` varchar(10) NOT NULL,
  `cag_tipmue` char(10) NOT NULL,
  `cag_clamue` char(30) NOT NULL,
  `cag_residual` varchar(15) NOT NULL,
  `cag_cot` varchar(15) NOT NULL,
  `cag_nitritos` varchar(15) NOT NULL,
  `cag_fluoruros` varchar(15) NOT NULL,
  `cag_giardia` varchar(15) NOT NULL,
  `cag_crypsto` varchar(15) NOT NULL,
  `cag_muestra` varchar(12) NOT NULL,
  PRIMARY KEY (`cag_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calidadaguaes`
--

LOCK TABLES `calidadaguaes` WRITE;
/*!40000 ALTER TABLE `calidadaguaes` DISABLE KEYS */;
/*!40000 ALTER TABLE `calidadaguaes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `calidadaguafs`
--

DROP TABLE IF EXISTS `calidadaguafs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `calidadaguafs` (
  `cag_numero` int(9) NOT NULL,
  `cag_fecini` date DEFAULT NULL,
  `cag_horini` time DEFAULT NULL,
  `cag_punto` varchar(15) NOT NULL,
  `cag_laboratorio` varchar(10) NOT NULL,
  `cag_tipmue` char(10) NOT NULL,
  `cag_ph` varchar(15) NOT NULL,
  `cag_grados` varchar(15) NOT NULL,
  `cag_solidos` varchar(15) NOT NULL,
  `cag_micros` varchar(15) NOT NULL,
  `cag_turbiedad` varchar(15) NOT NULL,
  `cag_color` varchar(15) NOT NULL,
  `cag_coliformes` varchar(15) NOT NULL,
  `cag_escher` varchar(15) NOT NULL,
  `cag_dbo` varchar(15) NOT NULL,
  `cag_dqo` varchar(15) NOT NULL,
  `cag_od` varchar(15) NOT NULL,
  `cag_sodio` varchar(15) NOT NULL,
  `cag_cloruros` varchar(15) NOT NULL,
  `cag_fluoruros` varchar(15) NOT NULL,
  `cag_hierro` varchar(15) NOT NULL,
  `cag_manganeso` varchar(15) NOT NULL,
  `cag_fenoles` varchar(15) NOT NULL,
  `cag_amoniaco` varchar(15) NOT NULL,
  `cag_nitritos` varchar(15) NOT NULL,
  `cag_nitratos` varchar(15) NOT NULL,
  `cag_dureza` varchar(15) NOT NULL,
  `cag_cianuros` varchar(15) NOT NULL,
  `cag_sulfatos` varchar(15) NOT NULL,
  `cag_fosforos` varchar(15) NOT NULL,
  `cag_muestra` varchar(12) NOT NULL,
  PRIMARY KEY (`cag_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calidadaguafs`
--

LOCK TABLES `calidadaguafs` WRITE;
/*!40000 ALTER TABLE `calidadaguafs` DISABLE KEYS */;
/*!40000 ALTER TABLE `calidadaguafs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `calidadaguafsb`
--

DROP TABLE IF EXISTS `calidadaguafsb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `calidadaguafsb` (
  `cag_numero` int(9) NOT NULL,
  `cag_fecini` date DEFAULT NULL,
  `cag_horini` time DEFAULT NULL,
  `cag_punto` varchar(15) NOT NULL,
  `cag_laboratorio` varchar(10) NOT NULL,
  `cag_tipmue` char(10) NOT NULL,
  `cag_ph` varchar(15) NOT NULL,
  `cag_grados` varchar(15) NOT NULL,
  `cag_solidos` varchar(15) NOT NULL,
  `cag_micros` varchar(15) NOT NULL,
  `cag_turbiedad` varchar(15) NOT NULL,
  `cag_color` varchar(15) NOT NULL,
  `cag_coliformes` varchar(15) NOT NULL,
  `cag_escher` varchar(15) NOT NULL,
  `cag_dbo` varchar(15) NOT NULL,
  `cag_dqo` varchar(15) NOT NULL,
  `cag_od` varchar(15) NOT NULL,
  `cag_sodio` varchar(15) NOT NULL,
  `cag_cloruros` varchar(15) NOT NULL,
  `cag_fluoruros` varchar(15) NOT NULL,
  `cag_hierro` varchar(15) NOT NULL,
  `cag_manganeso` varchar(15) NOT NULL,
  `cag_fenoles` varchar(15) NOT NULL,
  `cag_amoniaco` varchar(15) NOT NULL,
  `cag_nitritos` varchar(15) NOT NULL,
  `cag_nitratos` varchar(15) NOT NULL,
  `cag_dureza` varchar(15) NOT NULL,
  `cag_cianuros` varchar(15) NOT NULL,
  `cag_sulfatos` varchar(15) NOT NULL,
  `cag_fosforos` varchar(15) NOT NULL,
  `cag_muestra` varchar(12) NOT NULL,
  PRIMARY KEY (`cag_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calidadaguafsb`
--

LOCK TABLES `calidadaguafsb` WRITE;
/*!40000 ALTER TABLE `calidadaguafsb` DISABLE KEYS */;
/*!40000 ALTER TABLE `calidadaguafsb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `calidadaguano`
--

DROP TABLE IF EXISTS `calidadaguano`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `calidadaguano` (
  `cag_numero` int(9) NOT NULL,
  `cag_fecini` date DEFAULT NULL,
  `cag_horini` time DEFAULT NULL,
  `cag_fecfin` date DEFAULT NULL,
  `cag_horfin` time DEFAULT NULL,
  `cag_punto` varchar(20) NOT NULL,
  `cag_laboratorio` varchar(10) NOT NULL,
  `cag_tipmue` char(10) NOT NULL,
  `cag_clamue` char(30) NOT NULL,
  `cag_analiz` char(30) NOT NULL,
  `cag_caracter` char(6) NOT NULL,
  `cag_valor` varchar(15) NOT NULL,
  `cag_muestra` varchar(12) NOT NULL,
  PRIMARY KEY (`cag_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calidadaguano`
--

LOCK TABLES `calidadaguano` WRITE;
/*!40000 ALTER TABLE `calidadaguano` DISABLE KEYS */;
/*!40000 ALTER TABLE `calidadaguano` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `caracter`
--

DROP TABLE IF EXISTS `caracter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caracter` (
  `cr_codcar` char(6) NOT NULL,
  `cr_descri` char(60) DEFAULT NULL,
  PRIMARY KEY (`cr_codcar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `caracter`
--

LOCK TABLES `caracter` WRITE;
/*!40000 ALTER TABLE `caracter` DISABLE KEYS */;
INSERT INTO `caracter` (`cr_codcar`, `cr_descri`) VALUES ('15','Nitritos NO2 -'),('16','Nitratos NO3 -'),('19','Alcalinidad total CaCO3'),('20','Cloruros Cl-'),('21','Aluminio Al'),('23','Manganeso Mn'),('25','Sulfatos SO4 -2'),('51','Oxigeno Disuelto'),('50','Conductividad'),('28','Residual del coagulante *'),('29','Dureza total CaCO3'),('30','Hierro total Fe'),('31','Giardia Quistes'),('32','Cryptosporidium Ooquistes'),('33','Plaguicidas');
/*!40000 ALTER TABLE `caracter` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `caracterca`
--

DROP TABLE IF EXISTS `caracterca`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caracterca` (
  `cr_codcar` char(6) NOT NULL,
  `cr_descri` char(60) DEFAULT NULL,
  PRIMARY KEY (`cr_codcar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `caracterca`
--

LOCK TABLES `caracterca` WRITE;
/*!40000 ALTER TABLE `caracterca` DISABLE KEYS */;
INSERT INTO `caracterca` (`cr_codcar`, `cr_descri`) VALUES ('1','Antimonio Sb'),('2','Arsenico As'),('3','Bario Ba'),('4','Cadmio Cd'),('5','Cianuro libre y disociable CN-'),('6','Cobre Cu'),('7','Cromo total Cr'),('8','Mercurio Hg'),('9','Niquel Ni'),('10','Plomo Pb'),('11','Selenio Se'),('12','Trihalometanos totales THMs'),('13','Hidrocarburos arom?ticos HAP'),('14','Carbono org?nico total COT'),('15','Nitritos NO2 -'),('16','Nitratos NO3 -'),('17','Fluoruros F-'),('18','Calcio Ca'),('19','Alcalinidad total CaCO3'),('20','Cloruros Cl-'),('21','Aluminio Al'),('22','Magnesio Mg'),('23','Manganeso Mn'),('24','Molibdeno Mo'),('25','Sulfatos SO4 -2'),('26','Zinc Zn'),('27','Fosfatos PO4 -3'),('28','Residual del coagulante *'),('29','Dureza total CaCO3'),('30','Hierro total Fe'),('31','Giardia Quistes'),('32','Cryptosporidium Ooquistes'),('33','Plaguicidas'),('50','Conductividad'),('51','Oxigeno disuelto');
/*!40000 ALTER TABLE `caracterca` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cierres`
--

DROP TABLE IF EXISTS `cierres`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cierres` (
  `ci_suspen` int(9) NOT NULL,
  `ci_numero` int(9) DEFAULT NULL,
  `ci_codsec` int(3) NOT NULL,
  `ci_tipsus` int(3) NOT NULL,
  `ci_fecini` date DEFAULT NULL,
  `ci_horini` time DEFAULT NULL,
  `ci_fecfin` date DEFAULT NULL,
  `ci_horfin` time DEFAULT NULL,
  `ci_tiempo` time NOT NULL DEFAULT '00:00:00',
  PRIMARY KEY (`ci_suspen`),
  KEY `ci_numero` (`ci_numero`),
  KEY `ci_codsec` (`ci_codsec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cierres`
--

LOCK TABLES `cierres` WRITE;
/*!40000 ALTER TABLE `cierres` DISABLE KEYS */;
/*!40000 ALTER TABLE `cierres` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ciudad`
--

DROP TABLE IF EXISTS `ciudad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ciudad` (
  `ci_codciu` varchar(10) NOT NULL DEFAULT '0',
  `ci_descri` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`ci_codciu`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ciudad`
--

LOCK TABLES `ciudad` WRITE;
/*!40000 ALTER TABLE `ciudad` DISABLE KEYS */;
INSERT INTO `ciudad` (`ci_codciu`, `ci_descri`) VALUES ('73001','IBAGUE');
/*!40000 ALTER TABLE `ciudad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clientes`
--

DROP TABLE IF EXISTS `clientes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clientes` (
  `cl_codcli` char(12) NOT NULL DEFAULT '',
  `cl_nombre` char(40) NOT NULL DEFAULT '',
  `cl_direcc` char(40) NOT NULL DEFAULT '',
  `cl_repres` char(40) NOT NULL,
  `cl_telefo` char(10) NOT NULL DEFAULT '',
  `cl_porcen` int(2) DEFAULT NULL,
  PRIMARY KEY (`cl_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clientes`
--

LOCK TABLES `clientes` WRITE;
/*!40000 ALTER TABLE `clientes` DISABLE KEYS */;
/*!40000 ALTER TABLE `clientes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `compras`
--

DROP TABLE IF EXISTS `compras`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `compras` (
  `co_numero` int(9) NOT NULL,
  `co_codcli` char(12) NOT NULL DEFAULT '',
  `co_fecreg` date DEFAULT NULL,
  `co_horreg` time NOT NULL DEFAULT '00:00:00',
  `co_vlrtot` int(9) DEFAULT NULL,
  `co_vlriva` int(9) DEFAULT NULL,
  `co_apagar` int(9) DEFAULT NULL,
  `co_estado` char(1) NOT NULL,
  PRIMARY KEY (`co_numero`),
  KEY `co_codcli` (`co_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `compras`
--

LOCK TABLES `compras` WRITE;
/*!40000 ALTER TABLE `compras` DISABLE KEYS */;
/*!40000 ALTER TABLE `compras` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `conceptos`
--

DROP TABLE IF EXISTS `conceptos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `conceptos` (
  `cp_codcon` int(4) NOT NULL,
  `cp_detalle` char(120) NOT NULL,
  `cp_grupo` int(3) NOT NULL,
  `cp_tiptari` char(1) NOT NULL,
  `cp_referen` int(4) NOT NULL,
  `cp_unidad` char(10) NOT NULL,
  `cp_vlrcomp` float(9,2) DEFAULT NULL,
  `cp_vlrvent` float(9,2) DEFAULT NULL,
  `cp_existen` float(9,2) DEFAULT NULL,
  `cp_poriva` int(2) DEFAULT NULL,
  PRIMARY KEY (`cp_codcon`),
  KEY `cp_grupo` (`cp_grupo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `conceptos`
--

LOCK TABLES `conceptos` WRITE;
/*!40000 ALTER TABLE `conceptos` DISABLE KEYS */;
INSERT INTO `conceptos` (`cp_codcon`, `cp_detalle`, `cp_grupo`, `cp_tiptari`, `cp_referen`, `cp_unidad`, `cp_vlrcomp`, `cp_vlrvent`, `cp_existen`, `cp_poriva`) VALUES (100,'CEMENTO',108,'',0,'Valdes',0.00,0.00,0.00,0),(101,'TUBERIA PVC ALCANTARILLADO 10\"',115,'',0,'M.L',0.00,0.00,0.00,0),(102,'TUBERIA PVC ACUEDUCTO 6\"',115,'',0,'M.L',0.00,0.00,0.00,0),(103,'UNION 2 DE REPARACION (MANGON)',115,'',0,'UN',0.00,0.00,0.00,0),(104,'SEMI CURVAS 2\"',0,'',0,'UN',0.00,0.00,0.00,0),(105,'PINTURA ALUMON',0,'',0,'GL',0.00,0.00,0.00,0),(106,'CURVAS 90°',115,'',0,'UN',0.00,0.00,0.00,0),(107,'CONTADOR 1/2',201,'',0,'UN',0.00,0.00,0.00,0),(108,'REGISTRO DE CORTE 1/2',201,'',0,'UN',0.00,0.00,0.00,0),(109,'CODOS 1/2',214,'',0,'UN',0.00,0.00,0.00,0),(110,'MACHOS 1/2',0,'',0,'UN',0.00,0.00,0.00,0),(111,'UNION GIOT HR 3\" HF',201,'',0,'',0.00,0.00,0.00,0),(112,'TUBO PVC 3\" TP',201,'',0,'',0.00,0.00,0.00,0),(113,'UNION GIOT HR 4\" HF',201,'',0,'UN',0.00,0.00,0.00,0),(114,'VALVULA HF 4\"',201,'',0,'UN',0.00,0.00,0.00,0),(115,'UNION REPARACION PVC 4\"',201,'',0,'UN',0.00,0.00,0.00,0),(116,'GEL LUBRICANTE PVC',201,'',0,'LIBRAS',0.00,0.00,0.00,0),(117,'TUBO PVC 4\" TP',201,'',0,'ML',0.00,0.00,0.00,0),(118,'UNION LISA PVC 4\" TP',201,'',0,'UN',0.00,0.00,0.00,0),(119,'SOLDADURA PVC',201,'',0,'ML',0.00,0.00,0.00,0),(120,'LIMPIADOR PVC',201,'',0,'ML',0.00,0.00,0.00,0),(121,'TANQUE PLASTICO 250LT',114,'I',0,'UN',0.00,0.00,0.00,0),(122,'TANQUE 1000 LT',114,'I',0,'UN',0.00,0.00,0.00,0),(123,'TUBO PVC 1\"',201,'I',0,'UN',0.00,0.00,0.00,0),(124,'ADAPTADOR MACHO 1\"',201,'',0,'UN',0.00,0.00,0.00,0),(125,'LLAVE DE PASO 1\"',201,'I',0,'UN',0.00,0.00,0.00,0),(126,'TUBO PVC 1/2\"',201,'I',0,'',0.00,0.00,0.00,0),(127,'ADAPTADOR MACHO 1/2\"',201,'',0,'UN',0.00,0.00,0.00,0),(128,'LLAVE DE PASO 1/2\"',201,'',0,'UN',0.00,0.00,0.00,0),(129,'TEFLON',201,'I',0,'CRR',0.00,0.00,0.00,0),(130,'ALAMBRON GALBANIZADO CALIB 12',201,'',0,'KL',0.00,0.00,0.00,0),(131,'TUBOS PVC 1\"',104,'',0,'UN',0.00,0.00,0.00,0),(132,'CODOS PVC 1\"',104,'',0,'UN',0.00,0.00,0.00,0),(133,'T PVC 1\"',104,'',0,'UN',0.00,0.00,0.00,0),(134,'VALVULA DE PIE 1\"',104,'',0,'UN',0.00,0.00,0.00,0),(135,'Llave Cheque 1\"',201,'',0,'un',0.00,0.00,0.00,0),(136,'Union Universal 1\"',103,'',0,'UN',0.00,0.00,0.00,0),(137,'Union Universal 1/2\"',103,'',0,'UN',0.00,0.00,0.00,0),(138,'T 1/2\"',201,'',0,'UN',0.00,0.00,0.00,0),(139,'Reduccion 1\"',201,'',0,'',0.00,0.00,0.00,0),(140,'Reduccion 1/2\"',201,'',0,'UN',0.00,0.00,0.00,0),(141,'Union 1/2\"',201,'',0,'UN',0.00,0.00,0.00,0),(142,'Union  PVC 1\"',201,'',0,'UN',0.00,0.00,0.00,0),(143,'ARENA',0,'',0,'CARRETADA',0.00,0.00,0.00,0),(144,'LADRILLO TOLETE',201,'',0,'GRIS',0.00,0.00,0.00,0),(145,'VARILLA CORRUGADA 1/2\"',104,'',0,'UN',0.00,0.00,0.00,0),(146,'VARILLA 9MM',104,'',0,'UN',0.00,0.00,0.00,0),(147,'TRITURADO',104,'',0,'Valdes',0.00,0.00,0.00,0),(148,'ARENA NEGRA',104,'',0,'Valdes',0.00,0.00,0.00,0),(149,'UNION GIBOUT H.F 6\"',104,'I',0,'UN',0.00,0.00,0.00,0),(150,'UNION LISA PVC 6\" PRESION',201,'',0,'UN',0.00,0.00,0.00,0),(151,'TANQUE PLASTICO 2000 LT',201,'I',0,'UN',0.00,0.00,0.00,0),(152,'TACOS AUTAMATICOS 20 AMP',201,'I',0,'UN',0.00,0.00,0.00,0),(153,'CHEQUE TOBULA 1/2\"',201,'I',0,'UN',0.00,0.00,0.00,0),(154,'CHEQUE CORTINA 1/2\"',201,'I',0,'',0.00,0.00,0.00,0),(155,'BUGA PVC 1\" X 1/2\"',201,'I',0,'UN',0.00,0.00,0.00,0),(156,'Tubos sanitarios 4\"',201,'I',0,'TUBO',0.00,0.00,0.00,0),(157,'Uniones Sanitarias 4\"',0,'',0,'UN',0.00,0.00,0.00,0),(158,'Semicodos sanitario 4\"',201,'I',0,'',0.00,0.00,0.00,0),(159,'Tubo Sanitario 3\"',201,'I',0,'UN',0.00,0.00,0.00,0),(160,'Codo sanitario 3\"',201,'',0,'UN',0.00,0.00,0.00,0),(161,'semicodo sanitario 3\"',201,'I',0,'UN',0.00,0.00,0.00,0),(162,'CONGLOMERADO SECO',104,'I',0,'',0.00,0.00,0.00,0),(163,'SIKASET ( ACELERANTE PARA CONCRETO)',104,'I',0,'KL',0.00,0.00,0.00,0),(164,'Collarin pvc 2\" x 1/2',201,'I',0,'',0.00,0.00,0.00,0),(165,'T PVC 3\" PRESIÓN',104,'',0,'UN',0.00,0.00,0.00,0),(166,'CODO PVC 3\" PRESIÓN',104,'',0,'',0.00,0.00,0.00,0),(167,'UNION REPARACION PVC 3\"',104,'',0,'UN',0.00,0.00,0.00,0),(168,'TUBOS PVC 2\"',104,'I',0,'UN',0.00,0.00,0.00,0),(169,'COLLARIN PVC  2 3/4\"',104,'I',0,'UN',0.00,0.00,0.00,0),(170,'ADAPTADOR MACHO 3/4',104,'I',0,'UN',0.00,0.00,0.00,0),(171,'TAPON LISO PVC 2\"',201,'I',0,'UN',0.00,0.00,0.00,0),(172,'REDUCCION BUJE 3/4 X 1/2',201,'I',0,'UN',0.00,0.00,0.00,0),(173,'TAPON LISO 1/2\" PVC',201,'',0,'UN',0.00,0.00,0.00,0),(174,'TUBO PVC 3/4 PRESIÓN',0,'I',0,'UN',0.00,0.00,0.00,0),(175,'TEFLON INDUSTRIAL 3/4',201,'I',0,'CARRETA',0.00,0.00,0.00,0),(176,'GUANTES NITRILO',201,'I',0,'PAR',0.00,0.00,0.00,0),(177,'SEMICODO 3/4',201,'I',0,'UN',0.00,0.00,0.00,0),(178,'REDUCCION BUJE 3/4 X 1/2 HG',201,'I',0,'UN',0.00,0.00,0.00,0),(179,'UNION GIBOUT H.F 2\"',201,'I',0,'UN',0.00,0.00,0.00,0),(180,'UNION LISA PVC 2\" PRESIÓN',201,'I',0,'UN',0.00,0.00,0.00,0),(181,'MANGUERA PFU DE 1/2',201,'I',0,'MT',0.00,0.00,0.00,0),(182,'PUNTERAS MACHO MANGUERA 1/2',201,'I',0,'UN',0.00,0.00,0.00,0),(183,'UNION PVC 3/4',201,'I',0,'UN',0.00,0.00,0.00,0),(184,'LLAVE DE PALANCA 3/4 GRIVAL',201,'I',0,'UN',0.00,0.00,0.00,0),(185,'UNION LISA 3\"',201,'I',0,'UN',0.00,0.00,0.00,0),(186,'TUBO NOVAFORD 6\"',201,'I',0,'UN',0.00,0.00,0.00,0),(187,'ALAMBRE GALVANIZADO #14',201,'I',0,'UN',0.00,0.00,0.00,0),(188,'UNION LISA X 1\"',201,'I',0,'UN',0.00,0.00,0.00,0),(189,'ADAPTADOR MACHO 2\" PRESION',201,'I',0,'UN',0.00,0.00,0.00,0),(190,'SEMICODO 2\" PRESION',201,'I',0,'UN',0.00,0.00,0.00,0),(191,'LLAVE PALANCA 2\" FERMETAL',201,'I',0,'UN',0.00,0.00,0.00,0),(192,'COLLARIN PVC 2\"',201,'',0,'UN',0.00,0.00,0.00,0);
/*!40000 ALTER TABLE `conceptos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detcom`
--

DROP TABLE IF EXISTS `detcom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detcom` (
  `dc_numero` int(9) NOT NULL,
  `dc_codcon` int(4) NOT NULL,
  `dc_cantid` float(9,2) DEFAULT NULL,
  `dc_vlruni` int(9) DEFAULT NULL,
  `dc_vlriva` int(9) DEFAULT NULL,
  `dc_vlrtot` int(9) DEFAULT NULL,
  PRIMARY KEY (`dc_numero`,`dc_codcon`),
  KEY `dc_codcon` (`dc_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detcom`
--

LOCK TABLES `detcom` WRITE;
/*!40000 ALTER TABLE `detcom` DISABLE KEYS */;
/*!40000 ALTER TABLE `detcom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedcom`
--

DROP TABLE IF EXISTS `detpedcom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedcom` (
  `dpc_numero` int(9) NOT NULL,
  `dpc_codcon` int(4) NOT NULL,
  `dpc_cantid` float(9,2) DEFAULT NULL,
  `dpc_vlruni` int(9) DEFAULT NULL,
  `dpc_vlrtot` int(9) DEFAULT NULL,
  PRIMARY KEY (`dpc_numero`,`dpc_codcon`),
  KEY `dpc_codcon` (`dpc_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedcom`
--

LOCK TABLES `detpedcom` WRITE;
/*!40000 ALTER TABLE `detpedcom` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedcom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedsal`
--

DROP TABLE IF EXISTS `detpedsal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedsal` (
  `dps_numero` int(9) NOT NULL,
  `dps_codcon` int(4) NOT NULL,
  `dps_cantid` float(9,2) DEFAULT NULL,
  `dps_vlruni` int(9) DEFAULT NULL,
  `dps_vlrtot` int(9) DEFAULT NULL,
  PRIMARY KEY (`dps_numero`,`dps_codcon`),
  KEY `dps_codcon` (`dps_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedsal`
--

LOCK TABLES `detpedsal` WRITE;
/*!40000 ALTER TABLE `detpedsal` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedsal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detsalidas`
--

DROP TABLE IF EXISTS `detsalidas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detsalidas` (
  `ds_numero` int(9) NOT NULL,
  `ds_codcon` int(4) NOT NULL,
  `ds_cantid` float(9,2) DEFAULT NULL,
  `ds_vlruni` int(9) DEFAULT NULL,
  `ds_vlriva` int(9) DEFAULT NULL,
  `ds_vlrtot` int(9) DEFAULT NULL,
  PRIMARY KEY (`ds_numero`,`ds_codcon`),
  KEY `ds_codcon` (`ds_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detsalidas`
--

LOCK TABLES `detsalidas` WRITE;
/*!40000 ALTER TABLE `detsalidas` DISABLE KEYS */;
/*!40000 ALTER TABLE `detsalidas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ducto`
--

DROP TABLE IF EXISTS `ducto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ducto` (
  `du_codduc` char(2) NOT NULL,
  `du_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`du_codduc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ducto`
--

LOCK TABLES `ducto` WRITE;
/*!40000 ALTER TABLE `ducto` DISABLE KEYS */;
INSERT INTO `ducto` (`du_codduc`, `du_descri`) VALUES ('1','Acueducto - Canal'),('11','Alcantarillado - Box Culvert'),('12','Alcantarillado - Tuberia'),('13','Alcantarillado - Canal abierto'),('2','Acueducto - Tunel'),('3','Acueducto - Tuberia');
/*!40000 ALTER TABLE `ducto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empleado`
--

DROP TABLE IF EXISTS `empleado`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empleado` (
  `em_codemp` char(12) NOT NULL DEFAULT '',
  `em_nombre` char(40) NOT NULL DEFAULT '',
  `em_direcc` char(40) NOT NULL DEFAULT '',
  `em_telefo` char(10) NOT NULL DEFAULT '',
  `em_profes` int(3) DEFAULT NULL,
  PRIMARY KEY (`em_codemp`),
  KEY `em_profes` (`em_profes`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empleado`
--

LOCK TABLES `empleado` WRITE;
/*!40000 ALTER TABLE `empleado` DISABLE KEYS */;
INSERT INTO `empleado` (`em_codemp`, `em_nombre`, `em_direcc`, `em_telefo`, `em_profes`) VALUES ('1','GASOCOL','','',5);
/*!40000 ALTER TABLE `empleado` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empresa`
--

DROP TABLE IF EXISTS `empresa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empresa` (
  `ep_codemp` char(12) NOT NULL DEFAULT '',
  `ep_nombre` char(60) NOT NULL DEFAULT '',
  `ep_direcc` char(40) NOT NULL DEFAULT '',
  `ep_telefo` char(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ep_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empresa`
--

LOCK TABLES `empresa` WRITE;
/*!40000 ALTER TABLE `empresa` DISABLE KEYS */;
INSERT INTO `empresa` (`ep_codemp`, `ep_nombre`, `ep_direcc`, `ep_telefo`) VALUES ('901445146-5','GASO COLOMBIA S.A.S. E.S.P.','CR 7 CL 65 B CONJ. MILENIUM LC -1','3235726291');
/*!40000 ALTER TABLE `empresa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `festivos`
--

DROP TABLE IF EXISTS `festivos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `festivos` (
  `fecfes` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`fecfes`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `festivos`
--

LOCK TABLES `festivos` WRITE;
/*!40000 ALTER TABLE `festivos` DISABLE KEYS */;
INSERT INTO `festivos` (`fecfes`) VALUES ('2020-01-01'),('2020-01-04'),('2020-01-05'),('2020-01-06'),('2020-01-11'),('2020-01-12'),('2020-01-18'),('2020-01-19'),('2020-01-25'),('2020-01-26'),('2020-02-01'),('2020-02-02'),('2020-02-08'),('2020-02-09'),('2020-02-15'),('2020-02-16'),('2020-02-22'),('2020-02-23'),('2020-02-29'),('2020-03-01'),('2020-03-07'),('2020-03-08'),('2020-03-14'),('2020-03-15'),('2020-03-21'),('2020-03-22'),('2020-03-23'),('2020-03-28'),('2020-03-29'),('2020-04-04'),('2020-04-05'),('2020-04-09'),('2020-04-10'),('2020-04-11'),('2020-04-12'),('2020-04-18'),('2020-04-19'),('2020-04-25'),('2020-04-26'),('2020-05-01'),('2020-05-02'),('2020-05-03'),('2020-05-09'),('2020-05-10'),('2020-05-16'),('2020-05-17'),('2020-05-23'),('2020-05-24'),('2020-05-25'),('2020-05-30'),('2020-05-31'),('2020-06-06'),('2020-06-07'),('2020-06-13'),('2020-06-14'),('2020-06-15'),('2020-06-20'),('2020-06-21'),('2020-06-22'),('2020-06-27'),('2020-06-28'),('2020-06-29'),('2020-07-04'),('2020-07-05'),('2020-07-11'),('2020-07-12'),('2020-07-18'),('2020-07-19'),('2020-07-20'),('2020-07-25'),('2020-07-26'),('2020-08-01'),('2020-08-02'),('2020-08-07'),('2020-08-08'),('2020-08-09'),('2020-08-15'),('2020-08-16'),('2020-08-17'),('2020-08-22'),('2020-08-23'),('2020-08-29'),('2020-08-30'),('2020-09-05'),('2020-09-06'),('2020-09-12'),('2020-09-13'),('2020-09-19'),('2020-09-20'),('2020-09-26'),('2020-09-27'),('2020-10-03'),('2020-10-04'),('2020-10-10'),('2020-10-11'),('2020-10-15'),('2020-10-17'),('2020-10-18'),('2020-10-24'),('2020-10-25'),('2020-10-31'),('2020-11-01'),('2020-11-02'),('2020-11-07'),('2020-11-08'),('2020-11-14'),('2020-11-15'),('2020-11-16'),('2020-11-21'),('2020-11-22'),('2020-11-28'),('2020-11-29'),('2020-12-05'),('2020-12-06'),('2020-12-08'),('2020-12-12'),('2020-12-13'),('2020-12-19'),('2020-12-20'),('2020-12-25'),('2020-12-26'),('2020-12-27'),('2021-01-01'),('2021-01-02'),('2021-01-03'),('2021-01-09'),('2021-01-10'),('2021-01-11'),('2021-01-16'),('2021-01-17'),('2021-01-23'),('2021-01-24'),('2021-01-30'),('2021-01-31'),('2021-02-06'),('2021-02-07'),('2021-02-13'),('2021-02-14'),('2021-02-20'),('2021-02-21'),('2021-02-27'),('2021-02-28'),('2021-03-06'),('2021-03-07'),('2021-03-13'),('2021-03-14'),('2021-03-20'),('2021-03-21'),('2021-03-22'),('2021-03-27'),('2021-03-28'),('2021-04-01'),('2021-04-02'),('2021-04-03'),('2021-04-04'),('2021-04-10'),('2021-04-11'),('2021-04-17'),('2021-04-18'),('2021-04-24'),('2021-04-25'),('2021-05-01'),('2021-05-02'),('2021-05-08'),('2021-05-09'),('2021-05-15'),('2021-05-16'),('2021-05-17'),('2021-05-22'),('2021-05-23'),('2021-05-29'),('2021-05-30'),('2021-06-05'),('2021-06-06'),('2021-06-07'),('2021-06-12'),('2021-06-13'),('2021-06-14'),('2021-06-19'),('2021-06-20'),('2021-06-26'),('2021-06-27'),('2021-07-03'),('2021-07-04'),('2021-07-05'),('2021-07-10'),('2021-07-11'),('2021-07-17'),('2021-07-18'),('2021-07-20'),('2021-07-24'),('2021-07-25'),('2021-07-31'),('2021-08-01'),('2021-08-07'),('2021-08-08'),('2021-08-14'),('2021-08-15'),('2021-08-16'),('2021-08-21'),('2021-08-22'),('2021-08-28'),('2021-08-29'),('2021-09-04'),('2021-09-05'),('2021-09-11'),('2021-09-12'),('2021-09-18'),('2021-09-19'),('2021-09-25'),('2021-09-26'),('2021-10-02'),('2021-10-03'),('2021-10-09'),('2021-10-10'),('2021-10-16'),('2021-10-17'),('2021-10-18'),('2021-10-23'),('2021-10-24'),('2021-10-30'),('2021-10-31'),('2021-11-01'),('2021-11-06'),('2021-11-07'),('2021-11-13'),('2021-11-14'),('2021-11-15'),('2021-11-20'),('2021-11-21'),('2021-11-27'),('2021-11-28'),('2021-12-04'),('2021-12-05'),('2021-12-08'),('2021-12-11'),('2021-12-12'),('2021-12-18'),('2021-12-19'),('2021-12-25'),('2021-12-26'),('2022-01-01'),('2022-01-02'),('2022-01-08'),('2022-01-09'),('2022-01-10'),('2022-01-15'),('2022-01-16'),('2022-01-22'),('2022-01-23'),('2022-01-29'),('2022-01-30'),('2022-02-05'),('2022-02-06'),('2022-02-12'),('2022-02-13'),('2022-02-19'),('2022-02-20'),('2022-02-26'),('2022-02-27'),('2022-03-05'),('2022-03-06'),('2022-03-12'),('2022-03-13'),('2022-03-19'),('2022-03-20'),('2022-03-21'),('2022-03-26'),('2022-03-27'),('2022-04-02'),('2022-04-03'),('2022-04-09'),('2022-04-10'),('2022-04-15'),('2022-04-16'),('2022-04-17'),('2022-04-23'),('2022-04-24'),('2022-04-30'),('2022-05-01'),('2022-05-07'),('2022-05-08'),('2022-05-14'),('2022-05-15'),('2022-05-21'),('2022-05-22'),('2022-05-28'),('2022-05-29'),('2022-05-30'),('2022-06-04'),('2022-06-05'),('2022-06-11'),('2022-06-12'),('2022-06-18'),('2022-06-19'),('2022-06-20'),('2022-06-25'),('2022-06-26'),('2022-06-27'),('2022-07-02'),('2022-07-03'),('2022-07-04'),('2022-07-09'),('2022-07-10'),('2022-07-16'),('2022-07-17'),('2022-07-20'),('2022-07-23'),('2022-07-24'),('2022-07-30'),('2022-07-31'),('2022-08-06'),('2022-08-07'),('2022-08-13'),('2022-08-14'),('2022-08-15'),('2022-08-17'),('2022-08-20'),('2022-08-21'),('2022-08-27'),('2022-08-28'),('2022-09-03'),('2022-09-04'),('2022-09-07'),('2022-09-10'),('2022-09-11'),('2022-09-14'),('2022-09-17'),('2022-09-18'),('2022-09-24'),('2022-09-25'),('2022-10-01'),('2022-10-02'),('2022-10-08'),('2022-10-09'),('2022-10-15'),('2022-10-16'),('2022-10-22'),('2022-10-23'),('2022-10-29'),('2022-10-30'),('2022-11-05'),('2022-11-06'),('2022-11-12'),('2022-11-13'),('2022-11-19'),('2022-11-20'),('2022-11-26'),('2022-11-27'),('2022-12-03'),('2022-12-04'),('2022-12-08'),('2022-12-10'),('2022-12-11'),('2022-12-17'),('2022-12-18'),('2022-12-24'),('2022-12-25'),('2022-12-31'),('2023-01-01'),('2023-01-07'),('2023-01-08'),('2023-01-09'),('2023-01-14'),('2023-01-15'),('2023-01-21'),('2023-01-22'),('2023-01-28'),('2023-01-29'),('2023-02-04'),('2023-02-05'),('2023-02-11'),('2023-02-12'),('2023-02-18'),('2023-02-19'),('2023-02-25'),('2023-02-26'),('2023-03-04'),('2023-03-05'),('2023-03-11'),('2023-03-12'),('2023-03-18'),('2023-03-19'),('2023-03-20'),('2023-03-25'),('2023-03-26'),('2023-04-01'),('2023-04-02'),('2023-04-06'),('2023-04-07'),('2023-04-08'),('2023-04-09'),('2023-04-15'),('2023-04-16'),('2023-04-22'),('2023-04-23'),('2023-04-29'),('2023-04-30'),('2023-05-01'),('2023-05-06'),('2023-05-07'),('2023-05-13'),('2023-05-14'),('2023-05-20'),('2023-05-21'),('2023-05-22'),('2023-05-27'),('2023-05-28'),('2023-06-03'),('2023-06-04'),('2023-06-10'),('2023-06-11'),('2023-06-12'),('2023-06-17'),('2023-06-18'),('2023-06-19'),('2023-06-24'),('2023-06-25'),('2023-07-01'),('2023-07-02'),('2023-07-03'),('2023-07-08'),('2023-07-09'),('2023-07-15'),('2023-07-16'),('2023-07-20'),('2023-07-22'),('2023-07-23'),('2023-07-29'),('2023-07-30'),('2023-08-05'),('2023-08-06'),('2023-08-07'),('2023-08-12'),('2023-08-13'),('2023-08-19'),('2023-08-20'),('2023-08-21'),('2023-08-26'),('2023-08-27'),('2023-09-02'),('2023-09-03'),('2023-09-09'),('2023-09-10'),('2023-09-16'),('2023-09-17'),('2023-09-23'),('2023-09-24'),('2023-09-30'),('2023-10-01'),('2023-10-07'),('2023-10-08'),('2023-10-14'),('2023-10-15'),('2023-10-16'),('2023-10-21'),('2023-10-22'),('2023-10-28'),('2023-10-29'),('2023-11-04'),('2023-11-05'),('2023-11-06'),('2023-11-11'),('2023-11-12'),('2023-11-13'),('2023-11-18'),('2023-11-19'),('2023-11-25'),('2023-11-26'),('2023-12-02'),('2023-12-03'),('2023-12-08'),('2023-12-09'),('2023-12-10'),('2023-12-16'),('2023-12-17'),('2023-12-23'),('2023-12-24'),('2023-12-25'),('2023-12-30'),('2023-12-31'),('2024-01-01'),('2024-01-06'),('2024-01-07'),('2024-01-08'),('2024-01-13'),('2024-01-14'),('2024-01-20'),('2024-01-21'),('2024-01-27'),('2024-01-28'),('2024-02-03'),('2024-02-04'),('2024-02-10'),('2024-02-11'),('2024-02-17'),('2024-02-18'),('2024-02-24'),('2024-02-25'),('2024-03-02'),('2024-03-03'),('2024-03-09'),('2024-03-10'),('2024-03-16'),('2024-03-17'),('2024-03-23'),('2024-03-24'),('2024-03-25'),('2024-03-28'),('2024-03-29'),('2024-03-30'),('2024-03-31'),('2024-04-06'),('2024-04-07'),('2024-04-13'),('2024-04-14'),('2024-04-20'),('2024-04-21'),('2024-04-27'),('2024-04-28'),('2024-05-01'),('2024-05-04'),('2024-05-05'),('2024-05-11'),('2024-05-12'),('2024-05-13'),('2024-05-18'),('2024-05-19'),('2024-05-25'),('2024-05-26'),('2024-06-01'),('2024-06-02'),('2024-06-03'),('2024-06-08'),('2024-06-09'),('2024-06-10'),('2024-06-15'),('2024-06-16'),('2024-06-22'),('2024-06-23'),('2024-06-29'),('2024-06-30'),('2024-07-01'),('2024-07-06'),('2024-07-07'),('2024-07-13'),('2024-07-14'),('2024-07-20'),('2024-07-21'),('2024-07-27'),('2024-07-28'),('2024-08-03'),('2024-08-04'),('2024-08-07'),('2024-08-10'),('2024-08-11'),('2024-08-17'),('2024-08-18'),('2024-08-19'),('2024-08-24'),('2024-08-25'),('2024-08-31'),('2024-09-01'),('2024-09-07'),('2024-09-08'),('2024-09-14'),('2024-09-15'),('2024-09-21'),('2024-09-22'),('2024-09-28'),('2024-09-29'),('2024-10-05'),('2024-10-06'),('2024-10-12'),('2024-10-13'),('2024-10-14'),('2024-10-19'),('2024-10-20'),('2024-10-26'),('2024-10-27'),('2024-11-02'),('2024-11-03'),('2024-11-04'),('2024-11-09'),('2024-11-10'),('2024-11-11'),('2024-11-16'),('2024-11-17'),('2024-11-23'),('2024-11-24'),('2024-11-30'),('2024-12-01'),('2024-12-07'),('2024-12-08'),('2024-12-14'),('2024-12-15'),('2024-12-21'),('2024-12-22'),('2024-12-25'),('2024-12-28'),('2024-12-29'),('2025-01-01'),('2025-01-04'),('2025-01-05'),('2025-01-06'),('2025-01-11'),('2025-01-12'),('2025-01-18'),('2025-01-19'),('2025-01-25'),('2025-01-26'),('2025-02-01'),('2025-02-02'),('2025-02-08'),('2025-02-09'),('2025-02-15'),('2025-02-16'),('2025-02-22'),('2025-02-23'),('2025-03-01'),('2025-03-02'),('2025-03-08'),('2025-03-09'),('2025-03-15'),('2025-03-16'),('2025-03-22'),('2025-03-23'),('2025-03-24'),('2025-03-29'),('2025-03-30'),('2025-04-05'),('2025-04-06'),('2025-04-12'),('2025-04-13'),('2025-04-17'),('2025-04-18'),('2025-04-19'),('2025-04-20'),('2025-04-26'),('2025-04-27'),('2025-05-01'),('2025-05-03'),('2025-05-04'),('2025-05-10'),('2025-05-11'),('2025-05-17'),('2025-05-18'),('2025-05-24'),('2025-05-25'),('2025-05-31'),('2025-06-01'),('2025-06-02'),('2025-06-07'),('2025-06-08'),('2025-06-14'),('2025-06-15'),('2025-06-21'),('2025-06-22'),('2025-06-23'),('2025-06-28'),('2025-06-29'),('2025-06-30'),('2025-07-05'),('2025-07-06'),('2025-07-12'),('2025-07-13'),('2025-07-19'),('2025-07-20'),('2025-07-26'),('2025-07-27'),('2025-08-02'),('2025-08-03'),('2025-08-07'),('2025-08-09'),('2025-08-10'),('2025-08-16'),('2025-08-17'),('2025-08-23'),('2025-08-24'),('2025-08-30'),('2025-08-31'),('2025-09-06'),('2025-09-07'),('2025-09-13'),('2025-09-14'),('2025-09-20'),('2025-09-21'),('2025-09-27'),('2025-09-28'),('2025-10-04'),('2025-10-05'),('2025-10-11'),('2025-10-12'),('2025-10-13'),('2025-10-18'),('2025-10-19'),('2025-10-25'),('2025-10-26'),('2025-11-01'),('2025-11-02'),('2025-11-03'),('2025-11-08'),('2025-11-09'),('2025-11-15'),('2025-11-16'),('2025-11-17'),('2025-11-22'),('2025-11-23'),('2025-11-29'),('2025-11-30'),('2025-12-06'),('2025-12-07'),('2025-12-08'),('2025-12-13'),('2025-12-14'),('2025-12-20'),('2025-12-21'),('2025-12-25'),('2025-12-27'),('2025-12-28'),('2026-01-01'),('2026-01-03'),('2026-01-04'),('2026-01-10'),('2026-01-11'),('2026-01-12'),('2026-01-17'),('2026-01-18'),('2026-01-24'),('2026-01-25'),('2026-01-31'),('2026-02-01'),('2026-02-07'),('2026-02-08'),('2026-02-14'),('2026-02-15'),('2026-02-21'),('2026-02-22'),('2026-02-28'),('2026-03-01'),('2026-03-07'),('2026-03-08'),('2026-03-14'),('2026-03-15'),('2026-03-21'),('2026-03-22'),('2026-03-28'),('2026-03-29'),('2026-04-02'),('2026-04-03'),('2026-04-04'),('2026-04-05'),('2026-04-11'),('2026-04-12'),('2026-04-18'),('2026-04-19'),('2026-04-25'),('2026-04-26'),('2026-05-01'),('2026-05-02'),('2026-05-03'),('2026-05-09'),('2026-05-10'),('2026-05-16'),('2026-05-17'),('2026-05-18'),('2026-05-23'),('2026-05-24'),('2026-05-30'),('2026-05-31'),('2026-06-06'),('2026-06-07'),('2026-06-08'),('2026-06-13'),('2026-06-14'),('2026-06-16'),('2026-06-20'),('2026-06-21'),('2026-06-27'),('2026-06-28'),('2026-06-29'),('2026-07-04'),('2026-07-05'),('2026-07-11'),('2026-07-12'),('2026-07-18'),('2026-07-19'),('2026-07-20'),('2026-07-25'),('2026-07-26'),('2026-08-01'),('2026-08-02'),('2026-08-07'),('2026-08-08'),('2026-08-09'),('2026-08-15'),('2026-08-16'),('2026-08-17'),('2026-08-22'),('2026-08-23'),('2026-08-29'),('2026-08-30'),('2026-09-05'),('2026-09-06'),('2026-09-12'),('2026-09-13'),('2026-09-19'),('2026-09-20'),('2026-09-26'),('2026-09-27'),('2026-10-03'),('2026-10-04'),('2026-10-10'),('2026-10-11'),('2026-10-12'),('2026-10-17'),('2026-10-18'),('2026-10-24'),('2026-10-25'),('2026-10-31'),('2026-11-01'),('2026-11-02'),('2026-11-07'),('2026-11-08'),('2026-11-14'),('2026-11-15'),('2026-11-16'),('2026-11-21'),('2026-11-22'),('2026-11-28'),('2026-11-29'),('2026-12-05'),('2026-12-06'),('2026-12-08'),('2026-12-12'),('2026-12-13'),('2026-12-19'),('2026-12-20'),('2026-12-25'),('2026-12-26'),('2026-12-27');
/*!40000 ALTER TABLE `festivos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `grupo`
--

DROP TABLE IF EXISTS `grupo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `grupo` (
  `gr_codgru` int(3) NOT NULL DEFAULT '0',
  `gr_descri` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`gr_codgru`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `grupo`
--

LOCK TABLES `grupo` WRITE;
/*!40000 ALTER TABLE `grupo` DISABLE KEYS */;
INSERT INTO `grupo` (`gr_codgru`, `gr_descri`) VALUES (101,'ACEITES, GRASAS Y LUBRICANTES	'),(102,'COMBUSTIBLE	'),(103,'DROGAS, ELEMENTOS, LABORATORIO'),(104,'ELEM.MATERIA PRIMA CONSTRUCCION'),(105,'EXPLOSIVOS'),(106,'FORRAJES Y ELEME PARA ANIMALES'),(107,'INSECTICIDAS HERVISCIDAS FUNGICIDAS'),(108,'OTROS ELEMENTOS CONSTRUCCION'),(109,'SEMILLAS Y ABONOS'),(110,'UTILES ESCRITORIO, DIBUJO ETC'),(111,'VIVERES RANCHO Y LICORES'),(112,'REPUESTO MAQUINARIA Y EQUIPO'),(113,'UTENCILIOS DE USO DOMESTICO'),(114,'ELEMENTOS Y MATERIALES TALLER	'),(115,'OTROS ELEMENTOS DE CONSUMO'),(116,'EQUIPOS Y ELEMENTOS DE DOTACION'),(201,'ACCESORIOS Y REPUESTOS'),(206,'EQUIPOS MAQUINAS PARA COMEDOR'),(207,'EQUIPO Y MAQ COMUNICACION'),(208,'EQUIPO Y MAQ CONSTRUCCION'),(209,'EQUIPO Y MAQ PARA DEPORTE'),(210,'EQUIPO Y MAQ LABORATORIO'),(211,'EQUIPO Y MAQ PARA MEDICINA'),(212,'EQUIPO Y MAQ OFICINA'),(213,'EQUIPO Y MAQ TRANSPORTE'),(214,'HERRAMIENTA Y ACCESORIOS'),(216,'LIBRO DE BIBLIOTECA'),(217,'LLANTAS Y NEUMATICOS'),(218,'MOBILIARIOS Y ENSERES'),(219,'SEMOVIENTES'),(220,'VESTUARIO, ROPA Y EQUIPO'),(226,'OTROS DEVOLUTIVOS'),(230,'BIENES RAICES');
/*!40000 ALTER TABLE `grupo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kardex`
--

DROP TABLE IF EXISTS `kardex`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kardex` (
  `kd_numero` int(9) NOT NULL,
  `kd_tipo` int(1) NOT NULL,
  `kd_fecreg` date DEFAULT NULL,
  `kd_cantid` float(9,2) DEFAULT NULL,
  `kd_vlrtot` int(9) DEFAULT NULL,
  PRIMARY KEY (`kd_numero`,`kd_tipo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kardex`
--

LOCK TABLES `kardex` WRITE;
/*!40000 ALTER TABLE `kardex` DISABLE KEYS */;
/*!40000 ALTER TABLE `kardex` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `laboratorio`
--

DROP TABLE IF EXISTS `laboratorio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `laboratorio` (
  `la_codlab` varchar(10) NOT NULL,
  `la_descri` char(60) DEFAULT NULL,
  PRIMARY KEY (`la_codlab`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `laboratorio`
--

LOCK TABLES `laboratorio` WRITE;
/*!40000 ALTER TABLE `laboratorio` DISABLE KEYS */;
INSERT INTO `laboratorio` (`la_codlab`, `la_descri`) VALUES ('0','Sin Definir Laboratorio');
/*!40000 ALTER TABLE `laboratorio` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `macroruta`
--

DROP TABLE IF EXISTS `macroruta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `macroruta` (
  `mr_codmac` int(4) NOT NULL,
  `mr_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`mr_codmac`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `macroruta`
--

LOCK TABLES `macroruta` WRITE;
/*!40000 ALTER TABLE `macroruta` DISABLE KEYS */;
/*!40000 ALTER TABLE `macroruta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `material`
--

DROP TABLE IF EXISTS `material`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `material` (
  `ma_codmat` char(2) NOT NULL,
  `ma_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`ma_codmat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `material`
--

LOCK TABLES `material` WRITE;
/*!40000 ALTER TABLE `material` DISABLE KEYS */;
INSERT INTO `material` (`ma_codmat`, `ma_descri`) VALUES ('1','PVC Cloruro de Polivinilo'),('10','PAD (Polietileno de Alta Densidad)'),('11','CCP'),('12','GRES'),('13','Otros'),('2','AC Asbeto Cemento'),('3','Acero'),('4','HF (Hierro Fundido)'),('5','HG (Hierro galvanizado)'),('6','HD (Hierro Ductil)'),('7','PE (Polietileno)'),('8','Fibra de Vidrio'),('9','Concreto Reforzado'),('14','TUBERIA SANITARIA PERFILADA');
/*!40000 ALTER TABLE `material` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `observaciones`
--

DROP TABLE IF EXISTS `observaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `observaciones` (
  `ob_numero` int(9) NOT NULL,
  `ob_detalle` text,
  PRIMARY KEY (`ob_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `observaciones`
--

LOCK TABLES `observaciones` WRITE;
/*!40000 ALTER TABLE `observaciones` DISABLE KEYS */;
/*!40000 ALTER TABLE `observaciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pavimento`
--

DROP TABLE IF EXISTS `pavimento`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pavimento` (
  `pv_numero` int(9) NOT NULL,
  `pv_tramo` char(2) NOT NULL,
  `pv_tipo` char(2) NOT NULL,
  `pv_codres` char(2) NOT NULL,
  `pv_largo` float(9,2) NOT NULL DEFAULT '0.00',
  `pv_ancho` float(9,2) NOT NULL DEFAULT '0.00',
  `pv_profun` float(9,2) NOT NULL DEFAULT '0.00',
  `pv_metros` float(9,2) NOT NULL DEFAULT '0.00',
  `pv_valor` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`pv_numero`,`pv_tramo`),
  KEY `pv_codres` (`pv_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pavimento`
--

LOCK TABLES `pavimento` WRITE;
/*!40000 ALTER TABLE `pavimento` DISABLE KEYS */;
/*!40000 ALTER TABLE `pavimento` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedcom`
--

DROP TABLE IF EXISTS `pedcom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedcom` (
  `pec_numero` int(9) NOT NULL,
  `pec_mesa` int(4) NOT NULL,
  `pec_observ` char(40) DEFAULT NULL,
  PRIMARY KEY (`pec_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedcom`
--

LOCK TABLES `pedcom` WRITE;
/*!40000 ALTER TABLE `pedcom` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedcom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedsal`
--

DROP TABLE IF EXISTS `pedsal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedsal` (
  `pes_numero` int(9) NOT NULL,
  `pes_mesa` int(4) NOT NULL,
  `pes_observ` char(40) DEFAULT NULL,
  PRIMARY KEY (`pes_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedsal`
--

LOCK TABLES `pedsal` WRITE;
/*!40000 ALTER TABLE `pedsal` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedsal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permisos`
--

DROP TABLE IF EXISTS `permisos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permisos` (
  `pe_codpro` int(11) NOT NULL DEFAULT '0',
  `pe_codemp` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`pe_codpro`,`pe_codemp`),
  KEY `pe_codpro` (`pe_codpro`),
  KEY `pe_codemp` (`pe_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permisos`
--

LOCK TABLES `permisos` WRITE;
/*!40000 ALTER TABLE `permisos` DISABLE KEYS */;
/*!40000 ALTER TABLE `permisos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personal`
--

DROP TABLE IF EXISTS `personal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `personal` (
  `pe_numero` int(9) NOT NULL DEFAULT '0',
  `pe_codemp` char(12) NOT NULL DEFAULT '',
  PRIMARY KEY (`pe_numero`,`pe_codemp`),
  KEY `pe_numero` (`pe_numero`),
  KEY `pe_codemp` (`pe_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `personal`
--

LOCK TABLES `personal` WRITE;
/*!40000 ALTER TABLE `personal` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pesajes`
--

DROP TABLE IF EXISTS `pesajes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pesajes` (
  `ps_numero` int(9) NOT NULL,
  `ps_codveh` char(6) NOT NULL,
  `ps_fecini` date DEFAULT NULL,
  `ps_horini` time DEFAULT NULL,
  `ps_fecfin` date DEFAULT NULL,
  `ps_horfin` time DEFAULT NULL,
  `ps_arepre` int(4) NOT NULL,
  `ps_macror` int(4) NOT NULL,
  `ps_tipdis` char(2) NOT NULL,
  `ps_trsu` float(9,2) NOT NULL DEFAULT '0.00',
  `ps_trsr` float(9,2) NOT NULL DEFAULT '0.00',
  `ps_tdsu` float(9,2) NOT NULL DEFAULT '0.00',
  `ps_tdsr` float(9,2) NOT NULL DEFAULT '0.00',
  `ps_tdso` float(9,2) NOT NULL DEFAULT '0.00',
  `ps_sitio` int(4) NOT NULL,
  PRIMARY KEY (`ps_numero`),
  KEY `ps_tipdis` (`ps_tipdis`),
  KEY `ps_arepre` (`ps_arepre`),
  KEY `ps_macror` (`ps_macror`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pesajes`
--

LOCK TABLES `pesajes` WRITE;
/*!40000 ALTER TABLE `pesajes` DISABLE KEYS */;
/*!40000 ALTER TABLE `pesajes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pormetraje`
--

DROP TABLE IF EXISTS `pormetraje`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pormetraje` (
  `pm_numero` int(9) NOT NULL,
  `pm_tramo` char(2) NOT NULL,
  `pm_codres` char(2) NOT NULL,
  `pm_largo` decimal(9,7) NOT NULL DEFAULT '0.0000000',
  `pm_ancho` decimal(9,7) NOT NULL DEFAULT '0.0000000',
  `pm_profun` decimal(9,7) NOT NULL DEFAULT '0.0000000',
  `pm_metros` decimal(9,2) NOT NULL DEFAULT '0.00',
  `pm_valor` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`pm_numero`,`pm_tramo`),
  KEY `pm_codres` (`pm_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pormetraje`
--

LOCK TABLES `pormetraje` WRITE;
/*!40000 ALTER TABLE `pormetraje` DISABLE KEYS */;
/*!40000 ALTER TABLE `pormetraje` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `presionespm`
--

DROP TABLE IF EXISTS `presionespm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `presionespm` (
  `pr_numero` int(9) NOT NULL DEFAULT '0',
  `pr_codsis` varchar(20) NOT NULL DEFAULT '',
  `pr_detsis` varchar(20) NOT NULL DEFAULT '',
  `pr_fecini` date NOT NULL DEFAULT '0000-00-00',
  `pr_horini` time NOT NULL DEFAULT '00:00:00',
  `pr_fecfin` date NOT NULL DEFAULT '0000-00-00',
  `pr_horfin` time NOT NULL DEFAULT '00:00:00',
  `pr_lectura` double(12,3) DEFAULT NULL,
  `pr_observa` text,
  `pr_fecreg` date NOT NULL,
  `pr_horreg` time NOT NULL,
  `pr_usuario` varchar(20) NOT NULL,
  PRIMARY KEY (`pr_numero`),
  KEY `pr_codsis` (`pr_codsis`),
  KEY `pr_detsis` (`pr_detsis`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `presionespm`
--

LOCK TABLES `presionespm` WRITE;
/*!40000 ALTER TABLE `presionespm` DISABLE KEYS */;
/*!40000 ALTER TABLE `presionespm` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `proceso`
--

DROP TABLE IF EXISTS `proceso`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `proceso` (
  `pr_codpro` char(2) NOT NULL,
  `pr_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`pr_codpro`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `proceso`
--

LOCK TABLES `proceso` WRITE;
/*!40000 ALTER TABLE `proceso` DISABLE KEYS */;
INSERT INTO `proceso` (`pr_codpro`, `pr_descri`) VALUES ('2','Gas - Conduccion'),('3','Gas - Distrubucion'),('4','Gas - acometida domiciliria');
/*!40000 ALTER TABLE `proceso` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profesion`
--

DROP TABLE IF EXISTS `profesion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profesion` (
  `pr_codpro` int(3) NOT NULL DEFAULT '0',
  `pr_descri` char(40) NOT NULL DEFAULT '',
  `pr_vlrhor` decimal(9,2) NOT NULL DEFAULT '0.00',
  `pr_vlrrec` decimal(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`pr_codpro`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profesion`
--

LOCK TABLES `profesion` WRITE;
/*!40000 ALTER TABLE `profesion` DISABLE KEYS */;
INSERT INTO `profesion` (`pr_codpro`, `pr_descri`, `pr_vlrhor`, `pr_vlrrec`) VALUES (1,'OPERARIO',3106.00,3882.00),(2,'AUXILIAR ADMINISTRATIVOS',3106.00,3882.00),(3,'BOCATOMERO',3106.00,3882.00),(4,'CONDUCTOR',4063.00,5078.00),(5,'COORDINADOR',4063.00,5078.00),(6,'OPERARIO CORTES',3106.00,3882.00),(7,'FONTANERO',4063.00,5078.00),(9,'OPERARIO PLANTA DE TRATAMIENTO',3563.00,4453.00),(10,'INGENIERO',8750.00,10938.00),(11,'PLOMERO',3106.00,3882.00),(12,'AUXILIAR OPERATIVA ACUEDUCTO  Y ALCANTAR',3000.00,2500.00),(13,'Monitor de Redes',4063.00,5078.00),(14,'ALBAÑIL',3106.00,3882.00),(15,'TECNICO ELECTRONICO',4063.00,5078.00),(16,'TECNICO DE LABORATORIO',4063.00,5078.00),(17,'INSPECTOR DE REDES',4063.00,5078.00),(18,'OFICIAL OPERT ACUEDUCTO ALCANTARILLADO',4500.00,5000.00);
/*!40000 ALTER TABLE `profesion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `punto`
--

DROP TABLE IF EXISTS `punto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `punto` (
  `pu_codpun` varchar(20) NOT NULL,
  `pu_municipio` varchar(20) NOT NULL,
  `pu_descri` char(60) DEFAULT NULL,
  `pu_codsui` varchar(10) NOT NULL,
  `pu_tippun` char(1) NOT NULL,
  `pu_fuente` char(1) NOT NULL,
  `pu_ubica` char(1) NOT NULL,
  `pu_aguablo` char(2) NOT NULL,
  `pu_localiza` char(1) NOT NULL,
  `pu_barrio` varchar(40) NOT NULL,
  `pu_direccion` varchar(50) NOT NULL,
  `pu_latgra` varchar(10) NOT NULL,
  `pu_latmin` varchar(10) NOT NULL,
  `pu_latseg` varchar(10) NOT NULL,
  `pu_longra` varchar(10) NOT NULL,
  `pu_lonmin` varchar(10) NOT NULL,
  `pu_lonseg` varchar(10) NOT NULL,
  `pu_altitud` varchar(10) NOT NULL,
  `pu_codsis` varchar(10) NOT NULL,
  `pu_local` int(9) NOT NULL,
  PRIMARY KEY (`pu_codpun`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `punto`
--

LOCK TABLES `punto` WRITE;
/*!40000 ALTER TABLE `punto` DISABLE KEYS */;
/*!40000 ALTER TABLE `punto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rastreo`
--

DROP TABLE IF EXISTS `rastreo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rastreo` (
  `rt_codpro` int(11) NOT NULL DEFAULT '0',
  `rt_codemp` char(8) NOT NULL DEFAULT '',
  `rt_fecreg` date NOT NULL DEFAULT '0000-00-00',
  `rt_horreg` time NOT NULL DEFAULT '00:00:00',
  PRIMARY KEY (`rt_codpro`,`rt_codemp`,`rt_fecreg`,`rt_horreg`),
  KEY `rt_codpro` (`rt_codpro`),
  KEY `rt_codemp` (`rt_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rastreo`
--

LOCK TABLES `rastreo` WRITE;
/*!40000 ALTER TABLE `rastreo` DISABLE KEYS */;
/*!40000 ALTER TABLE `rastreo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `repuestos`
--

DROP TABLE IF EXISTS `repuestos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `repuestos` (
  `rp_numero` int(9) NOT NULL,
  `rp_codcon` int(4) NOT NULL,
  `rp_cantid` float(9,2) NOT NULL DEFAULT '0.00',
  `rp_vlrtot` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`rp_numero`,`rp_codcon`),
  KEY `rp_nroord` (`rp_numero`),
  KEY `rp_codcon` (`rp_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `repuestos`
--

LOCK TABLES `repuestos` WRITE;
/*!40000 ALTER TABLE `repuestos` DISABLE KEYS */;
/*!40000 ALTER TABLE `repuestos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `resistencia`
--

DROP TABLE IF EXISTS `resistencia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `resistencia` (
  `rs_codres` char(2) NOT NULL,
  `rs_descri` char(40) DEFAULT NULL,
  `rs_valor` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`rs_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `resistencia`
--

LOCK TABLES `resistencia` WRITE;
/*!40000 ALTER TABLE `resistencia` DISABLE KEYS */;
INSERT INTO `resistencia` (`rs_codres`, `rs_descri`, `rs_valor`) VALUES ('1','2500 - 3000',30000.00);
/*!40000 ALTER TABLE `resistencia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `responsable`
--

DROP TABLE IF EXISTS `responsable`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `responsable` (
  `re_codres` char(12) NOT NULL,
  `re_nombre` char(40) DEFAULT NULL,
  `re_cargo` char(40) DEFAULT NULL,
  PRIMARY KEY (`re_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `responsable`
--

LOCK TABLES `responsable` WRITE;
/*!40000 ALTER TABLE `responsable` DISABLE KEYS */;
INSERT INTO `responsable` (`re_codres`, `re_nombre`, `re_cargo`) VALUES ('jmorales','John Jairo Morales','PQR'),('asexis','Asexis Soporte','Asexis');
/*!40000 ALTER TABLE `responsable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salidas`
--

DROP TABLE IF EXISTS `salidas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salidas` (
  `sa_numero` int(9) NOT NULL,
  `sa_codcli` char(12) NOT NULL DEFAULT '',
  `sa_fecreg` date DEFAULT NULL,
  `sa_horreg` time NOT NULL DEFAULT '00:00:00',
  `sa_vlrtot` int(9) DEFAULT NULL,
  `sa_vlriva` int(9) DEFAULT NULL,
  `sa_apagar` int(9) DEFAULT NULL,
  `sa_estado` char(1) NOT NULL,
  `sa_tramite` int(9) NOT NULL,
  `sa_tisalida` char(2) NOT NULL,
  PRIMARY KEY (`sa_numero`),
  KEY `sa_codcli` (`sa_codcli`),
  KEY `sa_tisalida` (`sa_tisalida`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salidas`
--

LOCK TABLES `salidas` WRITE;
/*!40000 ALTER TABLE `salidas` DISABLE KEYS */;
/*!40000 ALTER TABLE `salidas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sector`
--

DROP TABLE IF EXISTS `sector`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sector` (
  `se_codsec` int(3) NOT NULL DEFAULT '0',
  `se_descri` text,
  PRIMARY KEY (`se_codsec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sector`
--

LOCK TABLES `sector` WRITE;
/*!40000 ALTER TABLE `sector` DISABLE KEYS */;
INSERT INTO `sector` (`se_codsec`, `se_descri`) VALUES (1,'SECTOR NORTE '),(2,'SECTOR SUR '),(3,'PARTE ALTA');
/*!40000 ALTER TABLE `sector` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `secuencia`
--

DROP TABLE IF EXISTS `secuencia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `secuencia` (
  `se_tipsec` char(2) NOT NULL,
  `se_descri` char(40) DEFAULT NULL,
  `se_numero` int(9) DEFAULT NULL,
  PRIMARY KEY (`se_tipsec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `secuencia`
--

LOCK TABLES `secuencia` WRITE;
/*!40000 ALTER TABLE `secuencia` DISABLE KEYS */;
INSERT INTO `secuencia` (`se_tipsec`, `se_descri`, `se_numero`) VALUES ('C','Compras',0),('D','Descargas por Salidas',0),('P','Registro Pesaje',0),('S','Suspensiones',0),('T','Tramites',0),('CA','Calidad de Agua',0),('CN','Calidad de Agua no obligatoria',0),('CE','Calidad de Agua Especiales',0),('CF','Calidad de Agua fuentes superficiales',0),('CB','Calidad de agua subterraneas',0),('PR','Presiones',0),('AB','Abastecimiento Por Carrotanques',0),('PM','Presiones Puntos Muestreo',0);
/*!40000 ALTER TABLE `secuencia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sistema`
--

DROP TABLE IF EXISTS `sistema`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sistema` (
  `si_codsis` varchar(20) NOT NULL DEFAULT '0',
  `si_descri` varchar(60) DEFAULT NULL,
  `si_municipio` varchar(10) NOT NULL,
  `si_adicional` varchar(20) NOT NULL,
  PRIMARY KEY (`si_codsis`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sistema`
--

LOCK TABLES `sistema` WRITE;
/*!40000 ALTER TABLE `sistema` DISABLE KEYS */;
INSERT INTO `sistema` (`si_codsis`, `si_descri`, `si_municipio`, `si_adicional`) VALUES ('001','IBAGUE','73001','73001');
/*!40000 ALTER TABLE `sistema` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sitio`
--

DROP TABLE IF EXISTS `sitio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sitio` (
  `si_codsit` int(4) NOT NULL DEFAULT '0',
  `si_descri` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`si_codsit`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sitio`
--

LOCK TABLES `sitio` WRITE;
/*!40000 ALTER TABLE `sitio` DISABLE KEYS */;
/*!40000 ALTER TABLE `sitio` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sucesos`
--

DROP TABLE IF EXISTS `sucesos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sucesos` (
  `su_numero` int(9) NOT NULL,
  `su_consec` int(3) NOT NULL,
  `su_fecreg` date DEFAULT NULL,
  `su_horreg` time NOT NULL DEFAULT '00:00:00',
  `su_codres` char(12) NOT NULL,
  `su_detalle` text,
  PRIMARY KEY (`su_numero`,`su_consec`),
  KEY `su_numero` (`su_numero`),
  KEY `su_codres` (`su_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sucesos`
--

LOCK TABLES `sucesos` WRITE;
/*!40000 ALTER TABLE `sucesos` DISABLE KEYS */;
/*!40000 ALTER TABLE `sucesos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tactividades`
--

DROP TABLE IF EXISTS `tactividades`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tactividades` (
  `ta_numero` int(9) NOT NULL,
  `ta_codact` int(11) NOT NULL,
  `ta_codemp` char(12) NOT NULL,
  `ta_fecini` date DEFAULT NULL,
  `ta_horini` time DEFAULT NULL,
  `ta_fecfin` date DEFAULT NULL,
  `ta_horfin` time DEFAULT NULL,
  `ta_vlract` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`ta_numero`,`ta_codact`,`ta_codemp`),
  KEY `ta_nroord` (`ta_numero`),
  KEY `ta_codact` (`ta_codact`),
  KEY `ta_codemp` (`ta_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tactividades`
--

LOCK TABLES `tactividades` WRITE;
/*!40000 ALTER TABLE `tactividades` DISABLE KEYS */;
/*!40000 ALTER TABLE `tactividades` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tidano`
--

DROP TABLE IF EXISTS `tidano`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tidano` (
  `td_tidano` char(4) NOT NULL,
  `td_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`td_tidano`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tidano`
--

LOCK TABLES `tidano` WRITE;
/*!40000 ALTER TABLE `tidano` DISABLE KEYS */;
INSERT INTO `tidano` (`td_tidano`, `td_descri`) VALUES ('1',' ACOMETIDA NUEVA'),('2',' CAMBIO DE ACOMETIDA'),('3',' CONEXION NUEVA'),('4',' DANO EN LLAVE DE PASO'),('5',' DANO EN RED MATRIZ'),('6',' EMPALMES EN RED MATRIZ INSP. REDES'),('7',' EXCAVASION'),('8',' FRAUDE'),('9',' FRAUDE CONTROL PERDIDAS'),('10',' FUGA DE MEDIDOR CONTROL PERDIDAS'),('11',' FUGA DOMICILIARIA'),('12',' FUGA EN LA CALLE'),('13',' FUGA POR CORTE DEL SERVICIO'),('14',' IDENTIFICACION FRAUDULENTOS'),('15',' INDEPENDIZACION DOMICILIARIA'),('16',' INSTALACION CAJA DE ANDEN'),('17',' INSTALACION DE MEDIDOR'),('18',' INSTALACION DE TAPA VALVULA'),('19',' INSTALACION DE VALVULA'),('20',' INSTALACION DOMICILIARIA'),('21',' INSTALACION LLAVES DE PASO'),('22',' MANTENIMIENTO DE VALVULA'),('23',' RECONEXION (Cartera)'),('24',' RECUPERACION DE ANDEN'),('25',' RED  NUEVA'),('26',' REPOSICION DOMICILIARIA'),('27',' RETIRAR ACOMETIDA'),('28',' REVISION DE MEDIDOR'),('29',' REVISION TECNICA'),('30',' ROBO DE MEDIDOR'),('31',' TAPONAMIENTO DOMICILIARIA'),('32',' TOMA DE PRESION INSP. REDES'),('33',' VISITA TECNICA'),('34',' REVISION RED PRINCIPAL');
/*!40000 ALTER TABLE `tidano` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tidocu`
--

DROP TABLE IF EXISTS `tidocu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tidocu` (
  `td_tidocu` char(2) NOT NULL,
  `td_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`td_tidocu`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tidocu`
--

LOCK TABLES `tidocu` WRITE;
/*!40000 ALTER TABLE `tidocu` DISABLE KEYS */;
INSERT INTO `tidocu` (`td_tidocu`, `td_descri`) VALUES ('CC','Cedula de Ciudadania'),('CE','Cedula de Extranjeria'),('NI','NIT');
/*!40000 ALTER TABLE `tidocu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tipdis`
--

DROP TABLE IF EXISTS `tipdis`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipdis` (
  `td_tipdis` char(2) NOT NULL,
  `td_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`td_tipdis`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tipdis`
--

LOCK TABLES `tipdis` WRITE;
/*!40000 ALTER TABLE `tipdis` DISABLE KEYS */;
INSERT INTO `tipdis` (`td_tipdis`, `td_descri`) VALUES ('SO','SERVICIO ORDINARIO');
/*!40000 ALTER TABLE `tipdis` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tisalida`
--

DROP TABLE IF EXISTS `tisalida`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tisalida` (
  `ts_tisalida` char(2) NOT NULL,
  `ts_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`ts_tisalida`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tisalida`
--

LOCK TABLES `tisalida` WRITE;
/*!40000 ALTER TABLE `tisalida` DISABLE KEYS */;
INSERT INTO `tisalida` (`ts_tisalida`, `ts_descri`) VALUES ('PP','PROCESO DE PRODUCCION'),('PQ','SOLUCION PQR'),('SG','SALIDA GENERAL'),('CS','CORTE Y SUSPENSIONES'),('AD','ADMINISTRACION'),('DT','DOTACION');
/*!40000 ALTER TABLE `tisalida` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tramites`
--

DROP TABLE IF EXISTS `tramites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tramites` (
  `tm_numero` int(9) NOT NULL,
  `tm_codare` int(3) NOT NULL,
  `tm_tidano` char(4) NOT NULL,
  `tm_fecreg` date DEFAULT NULL,
  `tm_horreg` time NOT NULL DEFAULT '00:00:00',
  `tm_tidocu` char(2) NOT NULL,
  `tm_numdoc` char(12) NOT NULL,
  `tm_nomsol` char(40) NOT NULL,
  `tm_telsol` char(12) NOT NULL,
  `tm_celsol` char(30) NOT NULL,
  `tm_dirsol` char(40) NOT NULL,
  `tm_medio` char(1) NOT NULL,
  `tm_estado` char(1) NOT NULL,
  `tm_califi` char(1) DEFAULT NULL,
  `tm_feccon` date DEFAULT NULL,
  `tm_horcon` time NOT NULL DEFAULT '00:00:00',
  `tm_codbar` int(4) NOT NULL,
  `tm_origen` char(1) NOT NULL,
  `tm_tippqr` char(1) NOT NULL,
  `tm_numpqr` int(9) NOT NULL,
  `tm_nromat` int(10) NOT NULL,
  `tm_cobrar` char(1) NOT NULL,
  PRIMARY KEY (`tm_numero`),
  KEY `tm_tidano` (`tm_tidano`),
  KEY `tm_tidocu` (`tm_tidocu`),
  KEY `tm_codare` (`tm_codare`),
  KEY `tm_codbar` (`tm_codbar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tramites`
--

LOCK TABLES `tramites` WRITE;
/*!40000 ALTER TABLE `tramites` DISABLE KEYS */;
/*!40000 ALTER TABLE `tramites` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tuberias`
--

DROP TABLE IF EXISTS `tuberias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tuberias` (
  `tb_numero` int(9) NOT NULL,
  `tb_codpro` char(2) NOT NULL,
  `tb_codduc` char(2) NOT NULL,
  `tb_codmat` char(2) NOT NULL,
  `tb_seccion` char(2) NOT NULL,
  `tb_cantid` float(9,2) NOT NULL DEFAULT '0.00',
  `tb_diamet` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`tb_numero`,`tb_codpro`,`tb_codduc`,`tb_codmat`),
  KEY `tb_numero` (`tb_numero`),
  KEY `tb_codpro` (`tb_codpro`),
  KEY `tb_codduc` (`tb_codduc`),
  KEY `tb_codmat` (`tb_codmat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tuberias`
--

LOCK TABLES `tuberias` WRITE;
/*!40000 ALTER TABLE `tuberias` DISABLE KEYS */;
/*!40000 ALTER TABLE `tuberias` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tvehiculos`
--

DROP TABLE IF EXISTS `tvehiculos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tvehiculos` (
  `tv_numero` int(9) NOT NULL,
  `tv_codveh` char(6) NOT NULL,
  `tv_fecini` date DEFAULT NULL,
  `tv_horini` time DEFAULT NULL,
  `tv_fecfin` date DEFAULT NULL,
  `tv_horfin` time DEFAULT NULL,
  `tv_vlract` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`tv_numero`,`tv_codveh`),
  KEY `tv_numero` (`tv_numero`),
  KEY `tv_codveh` (`tv_codveh`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tvehiculos`
--

LOCK TABLES `tvehiculos` WRITE;
/*!40000 ALTER TABLE `tvehiculos` DISABLE KEYS */;
/*!40000 ALTER TABLE `tvehiculos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usuario`
--

DROP TABLE IF EXISTS `usuario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuario` (
  `us_codemp` char(8) NOT NULL DEFAULT '',
  `us_nombre` char(40) NOT NULL DEFAULT '',
  `us_direcc` char(40) NOT NULL DEFAULT '',
  `us_telefo` char(10) NOT NULL DEFAULT '',
  `us_passwd` char(8) NOT NULL DEFAULT '',
  `us_nivelu` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`us_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usuario`
--

LOCK TABLES `usuario` WRITE;
/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vehiculo`
--

DROP TABLE IF EXISTS `vehiculo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehiculo` (
  `vh_codveh` char(6) NOT NULL,
  `vh_descri` char(40) NOT NULL DEFAULT '',
  `vh_vlrhor` decimal(9,2) NOT NULL DEFAULT '0.00',
  `vh_vlrrec` decimal(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`vh_codveh`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehiculo`
--

LOCK TABLES `vehiculo` WRITE;
/*!40000 ALTER TABLE `vehiculo` DISABLE KEYS */;
INSERT INTO `vehiculo` (`vh_codveh`, `vh_descri`, `vh_vlrhor`, `vh_vlrrec`) VALUES ('101','RETROESCABADORA CASE 210',10000.00,0.00);
/*!40000 ALTER TABLE `vehiculo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'antsoftw_leticia_operativo'
--

--
-- Dumping routines for database 'antsoftw_leticia_operativo'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-06-05  2:33:12