-- MySQL dump 10.13  Distrib 5.5.52, for Linux (x86_64)
--
-- Host: localhost    Database: antsoftw_leticia_fact202102
-- ------------------------------------------------------
-- 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 `abono`
--

DROP TABLE IF EXISTS `abono`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abono` (
  `ab_nromat` int(9) NOT NULL,
  `ab_nrofac` int(9) NOT NULL DEFAULT '0',
  `ab_apagar` double(12,2) DEFAULT NULL,
  `ab_vabono` double(12,2) DEFAULT NULL,
  `ab_ulfeab` date DEFAULT NULL,
  `ab_usuari` char(12) DEFAULT NULL,
  PRIMARY KEY (`ab_nromat`,`ab_nrofac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `abono`
--

LOCK TABLES `abono` WRITE;
/*!40000 ALTER TABLE `abono` DISABLE KEYS */;
/*!40000 ALTER TABLE `abono` 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(4) NOT NULL,
  `ac_descri` char(40) DEFAULT NULL,
  `ac_vlract` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`ac_codact`)
) ENGINE=InnoDB 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 */;
/*!40000 ALTER TABLE `actividad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `acupag`
--

DROP TABLE IF EXISTS `acupag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acupag` (
  `acu_nromat` int(9) NOT NULL,
  `acu_banco` int(4) NOT NULL,
  `acu_fecpag` date NOT NULL,
  `acu_nrodoc` int(9) NOT NULL,
  `acu_secuen` int(9) NOT NULL,
  `acu_vlrpag` double(12,2) DEFAULT NULL,
  `acu_estado` char(1) DEFAULT NULL,
  PRIMARY KEY (`acu_nromat`,`acu_banco`,`acu_fecpag`,`acu_nrodoc`,`acu_secuen`),
  KEY `acu_banco` (`acu_banco`,`acu_fecpag`),
  KEY `acu_nromat` (`acu_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `acupag`
--

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

--
-- Table structure for table `afavor`
--

DROP TABLE IF EXISTS `afavor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `afavor` (
  `af_nromat` int(9) NOT NULL,
  `af_saldo` double(12,2) DEFAULT NULL,
  `af_valor` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`af_nromat`),
  KEY `af_nromat` (`af_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `afavor`
--

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

--
-- Table structure for table `aseo`
--

DROP TABLE IF EXISTS `aseo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aseo` (
  `nuid` int(11) NOT NULL,
  `nit` varchar(20) NOT NULL,
  `empresa` varchar(20) NOT NULL,
  `fechainicial` varchar(20) NOT NULL,
  `fechafinal` varchar(20) NOT NULL,
  `dias` int(11) NOT NULL,
  `fechagenera` varchar(20) NOT NULL,
  `uso` varchar(20) NOT NULL,
  `estrato` varchar(20) NOT NULL,
  `porcentaje` varchar(10) NOT NULL,
  `mesesv` int(11) NOT NULL,
  `unidades` varchar(20) NOT NULL,
  `fbarrido` int(11) NOT NULL,
  `frecolecion` int(11) NOT NULL,
  `c_fijo` double NOT NULL,
  `c_variable` double NOT NULL,
  `subsidio` double NOT NULL,
  `c_varaprov` double NOT NULL,
  `interesesmes` double NOT NULL,
  `interesespor` varchar(20) NOT NULL,
  `ref01` double NOT NULL,
  `totfinanciacion` double NOT NULL,
  `saldoanterior` double NOT NULL,
  `totalaseo` double NOT NULL,
  `historico6` double NOT NULL,
  `historico5` double NOT NULL,
  `historico4` double NOT NULL,
  `historico3` double NOT NULL,
  `historico2` double NOT NULL,
  `historico1` double NOT NULL,
  `ton_barr` varchar(20) NOT NULL,
  `limp_urb` varchar(20) NOT NULL,
  `rechazo` varchar(20) NOT NULL,
  `tna_uz` varchar(20) NOT NULL,
  `trn_auz` varchar(20) NOT NULL,
  `tafna` varchar(20) NOT NULL,
  `tonbar1` varchar(20) NOT NULL,
  `tonbar2` varchar(20) NOT NULL,
  `limp_urb1` varchar(20) NOT NULL,
  `limp_urb2` varchar(20) NOT NULL,
  `rechazo1` varchar(20) NOT NULL,
  `rechazo2` varchar(20) NOT NULL,
  `tnauz1` varchar(20) NOT NULL,
  `tnauz2` varchar(20) NOT NULL,
  `trnauz1` varchar(20) NOT NULL,
  `trnauz2` varchar(20) NOT NULL,
  `tafna1` varchar(20) NOT NULL,
  `tafna2` varchar(20) NOT NULL,
  PRIMARY KEY (`nuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `aseo`
--

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

--
-- Table structure for table `audmaestro`
--

DROP TABLE IF EXISTS `audmaestro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audmaestro` (
  `audm_numero` int(9) NOT NULL,
  `audm_e_nromat` int(9) NOT NULL,
  `audm_e_zona` int(2) DEFAULT NULL,
  `audm_e_ruta` int(2) DEFAULT NULL,
  `audm_e_cons` int(7) DEFAULT NULL,
  `audm_e_anex` int(7) DEFAULT NULL,
  `audm_e_codigo` char(20) DEFAULT NULL,
  `audm_e_nombre` char(40) DEFAULT NULL,
  `audm_e_direcc` char(40) DEFAULT NULL,
  `audm_e_uso` int(2) NOT NULL,
  `audm_e_estrato` int(2) NOT NULL,
  `audm_e_acuedu` char(1) NOT NULL,
  `audm_e_alcant` char(1) NOT NULL,
  `audm_e_aseo` char(1) NOT NULL,
  `audm_e_medido` char(1) NOT NULL,
  `audm_e_granpro` char(1) NOT NULL,
  `audm_e_nrouni` int(2) DEFAULT NULL,
  `audm_e_exceso` int(9) DEFAULT NULL,
  `audm_e_estmed` int(4) DEFAULT NULL,
  `audm_e_metro3` float(7,2) DEFAULT NULL,
  `audm_e_telefo` char(10) DEFAULT NULL,
  `audm_e_numnit` char(15) DEFAULT NULL,
  `audm_e_diamed` int(2) DEFAULT NULL,
  `audm_e_marmed` int(2) NOT NULL,
  `audm_e_descto` int(2) DEFAULT NULL,
  `audm_e_codbar` int(4) DEFAULT NULL,
  `audm_e_frerec` char(1) DEFAULT '1',
  `audm_e_frebar` char(1) DEFAULT '1',
  `audm_e_nromed` char(15) DEFAULT NULL,
  `audm_e_cicfac` int(2) DEFAULT NULL,
  `audm_e_tipafo` char(1) DEFAULT NULL,
  `audm_e_ubica` char(1) DEFAULT NULL,
  `audm_e_estado` char(1) DEFAULT NULL,
  `audm_e_predial` varchar(18) NOT NULL,
  `audm_q_nromat` int(9) NOT NULL,
  `audm_q_zona` int(2) DEFAULT NULL,
  `audm_q_ruta` int(2) DEFAULT NULL,
  `audm_q_cons` int(7) DEFAULT NULL,
  `audm_q_anex` int(7) DEFAULT NULL,
  `audm_q_codigo` char(20) DEFAULT NULL,
  `audm_q_nombre` char(40) DEFAULT NULL,
  `audm_q_direcc` char(40) DEFAULT NULL,
  `audm_q_uso` int(2) NOT NULL,
  `audm_q_estrato` int(2) NOT NULL,
  `audm_q_acuedu` char(1) NOT NULL,
  `audm_q_alcant` char(1) NOT NULL,
  `audm_q_aseo` char(1) NOT NULL,
  `audm_q_medido` char(1) NOT NULL,
  `audm_q_granpro` char(1) NOT NULL,
  `audm_q_nrouni` int(2) DEFAULT NULL,
  `audm_q_exceso` int(9) DEFAULT NULL,
  `audm_q_estmed` int(4) DEFAULT NULL,
  `audm_q_metro3` float(7,2) DEFAULT NULL,
  `audm_q_telefo` char(10) DEFAULT NULL,
  `audm_q_numnit` char(15) DEFAULT NULL,
  `audm_q_diamed` int(2) DEFAULT NULL,
  `audm_q_marmed` int(2) NOT NULL,
  `audm_q_descto` int(2) DEFAULT NULL,
  `audm_q_codbar` int(4) DEFAULT NULL,
  `audm_q_frerec` char(1) DEFAULT '1',
  `audm_q_frebar` char(1) DEFAULT '1',
  `audm_q_nromed` char(15) DEFAULT NULL,
  `audm_q_cicfac` int(2) DEFAULT NULL,
  `audm_q_tipafo` char(1) DEFAULT NULL,
  `audm_q_ubica` char(1) DEFAULT NULL,
  `audm_q_estado` char(1) DEFAULT NULL,
  `audm_q_predial` varchar(18) NOT NULL,
  `audm_usuario` char(10) DEFAULT NULL,
  `audm_hora` time NOT NULL DEFAULT '00:00:00',
  `audm_fecing` date NOT NULL,
  `audm_observa` text,
  PRIMARY KEY (`audm_numero`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `audmaestro`
--

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

--
-- Table structure for table `banco`
--

DROP TABLE IF EXISTS `banco`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banco` (
  `ba_codban` int(4) NOT NULL,
  `ba_cuenta` char(15) NOT NULL,
  `ba_descri` char(40) DEFAULT NULL,
  `ba_nit` char(15) NOT NULL,
  PRIMARY KEY (`ba_codban`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banco`
--

LOCK TABLES `banco` WRITE;
/*!40000 ALTER TABLE `banco` DISABLE KEYS */;
/*!40000 ALTER TABLE `banco` 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=InnoDB 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 */;
/*!40000 ALTER TABLE `barrio` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bolact`
--

DROP TABLE IF EXISTS `bolact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bolact` (
  `bact_numbol` int(9) NOT NULL,
  `bact_codact` int(4) NOT NULL,
  PRIMARY KEY (`bact_numbol`,`bact_codact`),
  KEY `bact_codact` (`bact_codact`),
  KEY `bact_numbol` (`bact_numbol`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bolact`
--

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

--
-- Table structure for table `boletin`
--

DROP TABLE IF EXISTS `boletin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boletin` (
  `bol_numbol` int(9) NOT NULL,
  `bol_nromat` int(9) NOT NULL,
  `bol_codsec` int(4) DEFAULT NULL,
  `bol_fecreg` date DEFAULT NULL,
  `bol_feccon` date DEFAULT NULL,
  `bol_diamed` int(2) DEFAULT NULL,
  `bol_acomet` char(2) DEFAULT NULL,
  `bol_estaco` char(1) DEFAULT NULL,
  `bol_tipfug` char(1) DEFAULT NULL,
  `bol_comfug` char(1) DEFAULT NULL,
  `bol_fraude` char(1) DEFAULT NULL,
  `bol_direct` char(1) DEFAULT NULL,
  `bol_nromed` char(15) DEFAULT NULL,
  `bol_lectura` int(9) DEFAULT NULL,
  `bol_marmed` int(2) DEFAULT NULL,
  `bol_tiplev` char(1) DEFAULT NULL,
  `bol_tipins` char(1) DEFAULT NULL,
  `bol_cajaan` char(1) DEFAULT NULL,
  `bol_estcaj` char(1) DEFAULT NULL,
  `bol_compre` char(1) DEFAULT NULL,
  `bol_vivien` char(1) DEFAULT NULL,
  `bol_clande` char(1) DEFAULT NULL,
  `bol_tipbol` char(1) DEFAULT NULL,
  `bol_corte` char(1) DEFAULT NULL,
  `bol_recon` char(1) DEFAULT NULL,
  `bol_cobrep` char(12) DEFAULT NULL,
  `bol_vlrbol` double(12,2) DEFAULT NULL,
  `bol_estbol` char(1) DEFAULT NULL,
  `bol_fecdig` date DEFAULT NULL,
  `bol_usuario` char(8) DEFAULT NULL,
  `bol_hordig` time DEFAULT NULL,
  `bol_gestion` varchar(10) NOT NULL,
  `bol_observa` text NOT NULL,
  PRIMARY KEY (`bol_numbol`),
  KEY `bol_diamed` (`bol_diamed`),
  KEY `bol_marmed` (`bol_marmed`),
  KEY `bol_nromat` (`bol_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `boletin`
--

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

--
-- Table structure for table `bolope`
--

DROP TABLE IF EXISTS `bolope`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bolope` (
  `bope_numbol` int(9) NOT NULL,
  `bope_codope` bigint(12) NOT NULL,
  PRIMARY KEY (`bope_numbol`,`bope_codope`),
  KEY `bope_codope` (`bope_codope`),
  KEY `bope_numbol` (`bope_numbol`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bolope`
--

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

--
-- Table structure for table `bolrep`
--

DROP TABLE IF EXISTS `bolrep`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bolrep` (
  `brep_numbol` int(9) NOT NULL,
  `brep_codrep` int(9) NOT NULL,
  `brep_cantidad` float(9,2) DEFAULT NULL,
  `brep_valor` double(12,2) DEFAULT NULL,
  `brep_total` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`brep_numbol`,`brep_codrep`),
  KEY `brep_codrep` (`brep_codrep`),
  KEY `brep_numbol` (`brep_numbol`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bolrep`
--

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

--
-- Table structure for table `ciclofact`
--

DROP TABLE IF EXISTS `ciclofact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ciclofact` (
  `ciclo` int(2) NOT NULL,
  `periodo` int(11) NOT NULL,
  `estado` char(1) NOT NULL,
  `detalle` text NOT NULL,
  `fecini` date NOT NULL,
  `fecemi` date NOT NULL,
  PRIMARY KEY (`ciclo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ciclofact`
--

LOCK TABLES `ciclofact` WRITE;
/*!40000 ALTER TABLE `ciclofact` DISABLE KEYS */;
/*!40000 ALTER TABLE `ciclofact` 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(40) NOT NULL,
  `cp_servicio` int(2) NOT NULL,
  `cp_tiptari` char(1) NOT NULL,
  `cp_vlrtari` float(9,2) DEFAULT NULL,
  `cp_coddebito` char(10) DEFAULT NULL,
  `cp_codcredito` char(10) DEFAULT NULL,
  `cp_factdeb` varchar(12) NOT NULL,
  `cp_factcre` varchar(12) NOT NULL,
  `cp_recadeb` varchar(12) NOT NULL,
  `cp_recacre` varchar(12) NOT NULL,
  `cp_nodbdeb` varchar(12) NOT NULL,
  `cp_nodbcre` varchar(12) NOT NULL,
  `cp_nocrdeb` varchar(12) NOT NULL,
  `cp_nocrcre` varchar(12) NOT NULL,
  `cp_saafdeb` varchar(12) NOT NULL,
  `cp_saafcre` varchar(12) NOT NULL,
  `cp_rubro` varchar(25) NOT NULL,
  PRIMARY KEY (`cp_codcon`),
  KEY `cp_servicio` (`cp_servicio`)
) ENGINE=InnoDB 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 */;
/*!40000 ALTER TABLE `conceptos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `consigna`
--

DROP TABLE IF EXISTS `consigna`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `consigna` (
  `cs_banco` int(4) NOT NULL,
  `cs_fechap` date NOT NULL,
  `cs_nrodoc` varchar(12) NOT NULL,
  `cs_valor` double(12,2) DEFAULT NULL,
  `cs_detalle` varchar(12) NOT NULL,
  `cs_usuario` char(10) DEFAULT NULL,
  `cs_fechacon` date NOT NULL,
  PRIMARY KEY (`cs_banco`,`cs_fechap`,`cs_nrodoc`),
  KEY `cs_consigna_2` (`cs_banco`),
  KEY `cs_consigna_3` (`cs_banco`,`cs_fechap`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `consigna`
--

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

--
-- Table structure for table `consumos`
--

DROP TABLE IF EXISTS `consumos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `consumos` (
  `cs_nromat` int(9) NOT NULL,
  `cs_lecant` int(9) DEFAULT NULL,
  `cs_lecact` int(9) DEFAULT NULL,
  `cs_consu1` int(9) DEFAULT NULL,
  `cs_consu2` int(9) DEFAULT NULL,
  `cs_consu3` int(9) DEFAULT NULL,
  `cs_consu4` int(9) DEFAULT NULL,
  `cs_consu5` int(9) DEFAULT NULL,
  `cs_consu6` int(9) DEFAULT NULL,
  `cs_promed` int(9) DEFAULT NULL,
  `cs_consumo` double(10,2) DEFAULT NULL,
  PRIMARY KEY (`cs_nromat`),
  KEY `cs_nromat` (`cs_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `consumos`
--

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

--
-- Table structure for table `consumosh`
--

DROP TABLE IF EXISTS `consumosh`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `consumosh` (
  `cs_nromat` int(9) NOT NULL,
  `cs_lecant` int(9) DEFAULT NULL,
  `cs_lecact` int(9) DEFAULT NULL,
  `cs_consu1` int(9) DEFAULT NULL,
  `cs_consu2` int(9) DEFAULT NULL,
  `cs_consu3` int(9) DEFAULT NULL,
  `cs_consu4` int(9) DEFAULT NULL,
  `cs_consu5` int(9) DEFAULT NULL,
  `cs_consu6` int(9) DEFAULT NULL,
  `cs_promed` int(9) DEFAULT NULL,
  `cs_consumo` int(9) DEFAULT NULL,
  PRIMARY KEY (`cs_nromat`),
  KEY `cs_nromat` (`cs_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `consumosh`
--

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

--
-- Table structure for table `consumost`
--

DROP TABLE IF EXISTS `consumost`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `consumost` (
  `cs_nromat` int(9) NOT NULL,
  `cs_lecant` int(9) DEFAULT NULL,
  `cs_lecact` int(9) DEFAULT NULL,
  `cs_consu1` int(9) DEFAULT NULL,
  `cs_consu2` int(9) DEFAULT NULL,
  `cs_consu3` int(9) DEFAULT NULL,
  `cs_consu4` int(9) DEFAULT NULL,
  `cs_consu5` int(9) DEFAULT NULL,
  `cs_consu6` int(9) DEFAULT NULL,
  `cs_promed` int(9) DEFAULT NULL,
  `cs_consumo` int(9) DEFAULT NULL,
  `cs_observa` int(9) DEFAULT NULL,
  PRIMARY KEY (`cs_nromat`),
  KEY `cs_nromat` (`cs_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `consumost`
--

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

--
-- Table structure for table `cortes`
--

DROP TABLE IF EXISTS `cortes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cortes` (
  `cor_nromat` int(9) NOT NULL,
  `cor_fecreg` date DEFAULT NULL,
  `cor_feccon` date DEFAULT NULL,
  `cor_numero` int(9) DEFAULT NULL,
  `cor_estado` char(1) DEFAULT NULL,
  PRIMARY KEY (`cor_nromat`),
  KEY `cor_nromat` (`cor_nromat`),
  KEY `cor_numero` (`cor_numero`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cortes`
--

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

--
-- Table structure for table `detmet`
--

DROP TABLE IF EXISTS `detmet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detmet` (
  `dm_nromat` int(9) NOT NULL,
  `dm_fecreg` date NOT NULL,
  `dm_bol031` float(4,4) DEFAULT NULL,
  `dm_bol005` float(4,4) DEFAULT NULL,
  `dm_bol111` float(4,4) DEFAULT NULL,
  `dm_can008` float(4,4) DEFAULT NULL,
  `dm_can013` float(4,4) DEFAULT NULL,
  `dm_can021` float(4,4) DEFAULT NULL,
  `dm_caj191` float(4,4) DEFAULT NULL,
  `dm_usuario` char(10) DEFAULT NULL,
  `dm_hora` time NOT NULL DEFAULT '00:00:00',
  `dm_fecing` date NOT NULL,
  PRIMARY KEY (`dm_nromat`,`dm_fecreg`),
  KEY `dm_nromat` (`dm_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detmet`
--

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

--
-- Table structure for table `detmultiusuario`
--

DROP TABLE IF EXISTS `detmultiusuario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detmultiusuario` (
  `dmulti_numero` int(9) NOT NULL,
  `dmulti_nromat` int(9) NOT NULL DEFAULT '0',
  `dmulti_metros` int(9) NOT NULL DEFAULT '0',
  `dmulti_consumo` double(12,2) DEFAULT NULL,
  `dmulti_subapo` double(12,2) DEFAULT NULL,
  `dmulti_consumo_al` double(12,2) DEFAULT NULL,
  `dmulti_subapo_al` double(12,2) DEFAULT NULL,
  `dmulti_total` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`dmulti_numero`,`dmulti_nromat`),
  KEY `dmulti_numero` (`dmulti_numero`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detmultiusuario`
--

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

--
-- Table structure for table `detpedre`
--

DROP TABLE IF EXISTS `detpedre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedre` (
  `dpr_numero` int(9) NOT NULL,
  `dpr_codcon` int(9) NOT NULL,
  `dpr_nrofac` int(9) NOT NULL DEFAULT '0',
  `dpr_vlrtot` double(15,2) DEFAULT NULL,
  `dpr_detalle` varchar(100) NOT NULL,
  PRIMARY KEY (`dpr_numero`,`dpr_codcon`,`dpr_nrofac`),
  KEY `dpr_codcon` (`dpr_codcon`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedre`
--

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

--
-- Table structure for table `diametros`
--

DROP TABLE IF EXISTS `diametros`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `diametros` (
  `dm_coddia` int(2) NOT NULL,
  `dm_descri` char(40) DEFAULT NULL,
  `dm_vlrmed` float(10,2) DEFAULT NULL,
  PRIMARY KEY (`dm_coddia`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `diametros`
--

LOCK TABLES `diametros` WRITE;
/*!40000 ALTER TABLE `diametros` DISABLE KEYS */;
/*!40000 ALTER TABLE `diametros` 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(80) NOT NULL DEFAULT '',
  `ep_direcc` char(40) NOT NULL DEFAULT '',
  `ep_telefo` char(15) NOT NULL DEFAULT '',
  `ep_dpto` varchar(3) NOT NULL,
  `ep_mcpio` varchar(3) NOT NULL,
  PRIMARY KEY (`ep_codemp`)
) ENGINE=InnoDB 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 */;
/*!40000 ALTER TABLE `empresa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `estado_servicio`
--

DROP TABLE IF EXISTS `estado_servicio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estado_servicio` (
  `es_codigo` varchar(2) NOT NULL,
  `es_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`es_codigo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estado_servicio`
--

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

--
-- Table structure for table `estrato`
--

DROP TABLE IF EXISTS `estrato`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estrato` (
  `es_codest` int(2) NOT NULL,
  `es_detalle` char(40) DEFAULT NULL,
  PRIMARY KEY (`es_codest`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estrato`
--

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

--
-- Table structure for table `hisaseo`
--

DROP TABLE IF EXISTS `hisaseo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hisaseo` (
  `ha_nromat` int(9) NOT NULL,
  `ha_valor1` double(12,2) DEFAULT NULL,
  `ha_valor2` double(12,2) DEFAULT NULL,
  `ha_valor3` double(12,2) DEFAULT NULL,
  `ha_valor4` double(12,2) DEFAULT NULL,
  `ha_valor5` double(12,2) DEFAULT NULL,
  `ha_valor6` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`ha_nromat`),
  KEY `ha_nromat` (`ha_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hisaseo`
--

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

--
-- Table structure for table `hisaya`
--

DROP TABLE IF EXISTS `hisaya`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hisaya` (
  `haya_nromat` int(9) NOT NULL,
  `haya_servi` int(1) NOT NULL,
  `haya_valor1` double(12,2) DEFAULT NULL,
  `haya_valor2` double(12,2) DEFAULT NULL,
  `haya_valor3` double(12,2) DEFAULT NULL,
  `haya_valor4` double(12,2) DEFAULT NULL,
  `haya_valor5` double(12,2) DEFAULT NULL,
  `haya_valor6` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`haya_nromat`,`haya_servi`),
  KEY `haya_nromat` (`haya_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hisaya`
--

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

--
-- Table structure for table `kardexmed`
--

DROP TABLE IF EXISTS `kardexmed`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kardexmed` (
  `kd_nromat` int(9) NOT NULL,
  `kd_codcon` int(4) NOT NULL,
  `kd_period` int(6) NOT NULL DEFAULT '0',
  `kd_totfin` double(12,2) DEFAULT NULL,
  `kd_vlrtot` double(12,2) DEFAULT NULL,
  `kd_vlrcuo` double(12,2) DEFAULT NULL,
  `kd_cuotas` float(5,2) DEFAULT NULL,
  `kd_pagada` float(5,2) DEFAULT NULL,
  `kd_fecreg` date NOT NULL DEFAULT '0000-00-00',
  `kd_fecini` date DEFAULT NULL,
  `kd_operar` bigint(12) DEFAULT NULL,
  `kd_diapag` int(2) DEFAULT NULL,
  `kd_nromed` char(15) DEFAULT NULL,
  `kd_lecact` int(9) DEFAULT '0',
  `kd_motivo` char(15) DEFAULT NULL,
  `kd_marmed` int(2) NOT NULL,
  `kd_diamed` int(2) DEFAULT NULL,
  `kd_usuari` char(15) DEFAULT NULL,
  `kd_timedi` int(2) NOT NULL,
  `kd_modelo` varchar(20) NOT NULL,
  `kd_digitos` int(2) NOT NULL,
  `kd_longitud` int(4) NOT NULL,
  `kd_posicion` varchar(1) NOT NULL,
  `kd_acta` varchar(15) NOT NULL,
  PRIMARY KEY (`kd_nromat`,`kd_fecreg`),
  KEY `kd_codcon` (`kd_codcon`),
  KEY `kd_nromat` (`kd_nromat`),
  KEY `kd_operar` (`kd_operar`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kardexmed`
--

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

--
-- Table structure for table `lectura`
--

DROP TABLE IF EXISTS `lectura`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lectura` (
  `lc_nromat` int(9) NOT NULL,
  `lc_fecreg` date NOT NULL DEFAULT '0000-00-00',
  `lc_horreg` time NOT NULL DEFAULT '00:00:00',
  `lc_lecant` int(9) DEFAULT NULL,
  `lc_lecact` int(9) DEFAULT NULL,
  `lc_observ` int(9) DEFAULT NULL,
  `lc_codemp` varchar(8) NOT NULL,
  `lc_tipomv` char(1) DEFAULT NULL,
  `lc_consumo` int(9) NOT NULL,
  PRIMARY KEY (`lc_nromat`,`lc_fecreg`,`lc_horreg`),
  KEY `lc_nromat` (`lc_nromat`),
  KEY `lc_codemp` (`lc_codemp`),
  KEY `lc_observ` (`lc_observ`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lectura`
--

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

--
-- Table structure for table `maestro`
--

DROP TABLE IF EXISTS `maestro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maestro` (
  `m_nromat` int(9) NOT NULL,
  `m_zona` int(2) DEFAULT NULL,
  `m_ruta` int(3) DEFAULT NULL,
  `m_cons` int(7) DEFAULT NULL,
  `m_anex` int(7) DEFAULT NULL,
  `m_codigo` double(20,0) DEFAULT NULL,
  `m_nombre` char(40) DEFAULT NULL,
  `m_direcc` char(40) DEFAULT NULL,
  `m_uso` int(2) NOT NULL,
  `m_estrato` int(2) NOT NULL,
  `m_acuedu` char(1) NOT NULL,
  `m_alcant` char(1) NOT NULL,
  `m_aseo` char(1) NOT NULL,
  `m_medido` char(1) NOT NULL,
  `m_granpro` char(1) NOT NULL,
  `m_nrouni` int(2) DEFAULT NULL,
  `m_exceso` double(10,2) DEFAULT NULL,
  `m_estmed` int(4) DEFAULT NULL,
  `m_metro3` float(7,2) DEFAULT NULL,
  `m_telefo` char(10) DEFAULT NULL,
  `m_numnit` char(15) DEFAULT NULL,
  `m_diamed` int(2) DEFAULT NULL,
  `m_marmed` int(2) NOT NULL,
  `m_descto` int(2) DEFAULT NULL,
  `m_codbar` int(4) DEFAULT NULL,
  `m_frerec` char(2) DEFAULT '1',
  `m_frebar` char(1) DEFAULT '1',
  `m_nromed` char(15) DEFAULT NULL,
  `m_cicfac` int(2) DEFAULT NULL,
  `m_tipafo` char(2) DEFAULT NULL,
  `m_ubica` char(1) DEFAULT NULL,
  `m_estado` char(1) DEFAULT NULL,
  `m_predial` varchar(18) DEFAULT NULL,
  `m_estapredio` varchar(2) NOT NULL,
  `m_causanlec` int(2) NOT NULL,
  `m_email` varchar(50) NOT NULL,
  PRIMARY KEY (`m_nromat`),
  UNIQUE KEY `codigo` (`m_zona`,`m_ruta`,`m_cons`,`m_anex`),
  KEY `m_codbar` (`m_codbar`),
  KEY `m_diamed` (`m_diamed`),
  KEY `m_estrato` (`m_estrato`),
  KEY `m_marmed` (`m_marmed`),
  KEY `m_uso` (`m_uso`),
  KEY `m_cicfac` (`m_cicfac`),
  KEY `m_ruta` (`m_ruta`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `maestro`
--

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

--
-- Table structure for table `maestroh`
--

DROP TABLE IF EXISTS `maestroh`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maestroh` (
  `m_nromat` int(9) NOT NULL,
  `m_zona` int(2) DEFAULT NULL,
  `m_ruta` int(3) DEFAULT NULL,
  `m_cons` int(7) DEFAULT NULL,
  `m_anex` int(7) DEFAULT NULL,
  `m_codigo` double(20,0) DEFAULT NULL,
  `m_nombre` char(40) DEFAULT NULL,
  `m_direcc` char(40) DEFAULT NULL,
  `m_uso` int(2) NOT NULL,
  `m_estrato` int(2) NOT NULL,
  `m_acuedu` char(1) NOT NULL,
  `m_alcant` char(1) NOT NULL,
  `m_aseo` char(1) NOT NULL,
  `m_medido` char(1) NOT NULL,
  `m_granpro` char(1) NOT NULL,
  `m_nrouni` int(2) DEFAULT NULL,
  `m_exceso` int(9) DEFAULT NULL,
  `m_estmed` int(4) DEFAULT NULL,
  `m_metro3` float(7,2) DEFAULT NULL,
  `m_telefo` char(10) DEFAULT NULL,
  `m_numnit` char(15) DEFAULT NULL,
  `m_diamed` int(2) DEFAULT NULL,
  `m_marmed` int(2) NOT NULL,
  `m_descto` int(2) DEFAULT NULL,
  `m_codbar` int(4) DEFAULT NULL,
  `m_frerec` char(2) DEFAULT '1',
  `m_frebar` char(1) DEFAULT '1',
  `m_nromed` char(15) DEFAULT NULL,
  `m_cicfac` int(2) DEFAULT NULL,
  `m_tipafo` char(2) DEFAULT NULL,
  `m_ubica` char(1) DEFAULT NULL,
  `m_estado` char(1) DEFAULT NULL,
  `m_predial` varchar(18) DEFAULT NULL,
  `m_estapredio` varchar(2) NOT NULL,
  `m_causanlec` int(2) NOT NULL,
  `m_email` varchar(50) NOT NULL,
  PRIMARY KEY (`m_nromat`),
  UNIQUE KEY `codigo` (`m_zona`,`m_ruta`,`m_cons`,`m_anex`),
  KEY `m_codbar` (`m_codbar`),
  KEY `m_diamed` (`m_diamed`),
  KEY `m_estrato` (`m_estrato`),
  KEY `m_marmed` (`m_marmed`),
  KEY `m_uso` (`m_uso`),
  KEY `m_cicfac` (`m_cicfac`),
  KEY `m_ruta` (`m_ruta`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `maestroh`
--

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

--
-- Table structure for table `marca`
--

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

--
-- Dumping data for table `marca`
--

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

--
-- Table structure for table `movto`
--

DROP TABLE IF EXISTS `movto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `movto` (
  `mv_numero` int(9) NOT NULL,
  `mv_nromat` int(9) NOT NULL,
  `mv_fecreg` date NOT NULL,
  `mv_tipago` int(2) NOT NULL,
  `mv_salant` double(12,2) DEFAULT NULL,
  `mv_movidb` double(12,2) DEFAULT NULL,
  `mv_movicr` double(12,2) DEFAULT NULL,
  `mv_salact` double(12,2) DEFAULT NULL,
  `mv_pagado` double(12,2) DEFAULT NULL,
  `mv_usuario` char(10) DEFAULT NULL,
  `mv_hora` time NOT NULL DEFAULT '00:00:00',
  `mv_fecing` date NOT NULL,
  `mv_observa` text,
  PRIMARY KEY (`mv_numero`),
  KEY `mv_fecreg` (`mv_fecreg`,`mv_tipago`),
  KEY `mv_nromat` (`mv_nromat`),
  KEY `mv_tipago` (`mv_tipago`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `movto`
--

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

--
-- Table structure for table `multiusuario`
--

DROP TABLE IF EXISTS `multiusuario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `multiusuario` (
  `multi_numero` int(9) NOT NULL,
  `multi_codcli` int(9) DEFAULT NULL,
  `multi_nombre` char(40) NOT NULL,
  `multi_metros` int(9) DEFAULT NULL,
  `multi_carfij` double(12,2) DEFAULT NULL,
  `multi_subapocf` double(12,2) DEFAULT NULL,
  `multi_consumo` double(12,2) DEFAULT NULL,
  `multi_subapo` double(12,2) DEFAULT NULL,
  `multi_carfij_al` double(12,2) DEFAULT NULL,
  `multi_subapocf_al` double(12,2) DEFAULT NULL,
  `multi_consumo_al` double(12,2) DEFAULT NULL,
  `multi_subapo_al` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`multi_numero`),
  KEY `multi_codcli` (`multi_codcli`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `multiusuario`
--

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

--
-- Table structure for table `observa`
--

DROP TABLE IF EXISTS `observa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `observa` (
  `ob_observa` int(2) NOT NULL,
  `ob_descri` char(40) DEFAULT NULL,
  `ob_exonera` char(1) DEFAULT NULL,
  PRIMARY KEY (`ob_observa`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `observa`
--

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

--
-- Table structure for table `observa_causa`
--

DROP TABLE IF EXISTS `observa_causa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `observa_causa` (
  `obc_observa` int(2) NOT NULL,
  `obc_descri` char(40) DEFAULT NULL,
  `obc_exonera` char(1) DEFAULT NULL,
  PRIMARY KEY (`obc_observa`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `observa_causa`
--

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

--
-- Table structure for table `obslectura`
--

DROP TABLE IF EXISTS `obslectura`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `obslectura` (
  `olc_nromat` int(9) NOT NULL,
  `olc_fecreg` date NOT NULL DEFAULT '0000-00-00',
  `olc_horreg` time NOT NULL DEFAULT '00:00:00',
  `olc_observa` text,
  PRIMARY KEY (`olc_nromat`,`olc_fecreg`,`olc_horreg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `obslectura`
--

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

--
-- Table structure for table `operar`
--

DROP TABLE IF EXISTS `operar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `operar` (
  `op_codope` bigint(12) NOT NULL,
  `op_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`op_codope`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `operar`
--

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

--
-- Table structure for table `pagos`
--

DROP TABLE IF EXISTS `pagos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pagos` (
  `p_banco` int(4) NOT NULL,
  `p_fechap` date NOT NULL,
  `p_nrodoc` int(9) NOT NULL,
  `p_numnot` int(4) DEFAULT NULL,
  `p_secuen` int(9) NOT NULL DEFAULT '0',
  `p_nromat` int(9) NOT NULL,
  `p_valor` double(12,2) DEFAULT NULL,
  `p_codact` int(2) DEFAULT NULL,
  `p_usuario` char(10) DEFAULT NULL,
  `p_hora` time NOT NULL,
  PRIMARY KEY (`p_secuen`),
  KEY `p_banco` (`p_banco`,`p_fechap`,`p_nrodoc`,`p_nromat`),
  KEY `p_banco_2` (`p_banco`),
  KEY `p_banco_3` (`p_banco`,`p_fechap`),
  KEY `p_nromat` (`p_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pagos`
--

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

--
-- Table structure for table `pagosa`
--

DROP TABLE IF EXISTS `pagosa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pagosa` (
  `pa_nromat` int(9) NOT NULL,
  `pa_fecreg` date NOT NULL,
  `pa_codcon` int(4) NOT NULL,
  `pa_period` int(6) NOT NULL DEFAULT '0',
  `pa_tipago` int(2) NOT NULL,
  `pa_numero` int(9) NOT NULL,
  `pa_apagar` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`pa_nromat`,`pa_fecreg`,`pa_codcon`,`pa_period`,`pa_tipago`,`pa_numero`),
  KEY `pa_codcon` (`pa_codcon`),
  KEY `pa_nromat` (`pa_nromat`),
  KEY `pa_tipago` (`pa_tipago`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pagosa`
--

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

--
-- Table structure for table `pagosp`
--

DROP TABLE IF EXISTS `pagosp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pagosp` (
  `pp_nromat` int(9) NOT NULL,
  `pp_fecreg` date NOT NULL,
  `pp_codcon` int(4) NOT NULL,
  `pp_period` int(6) NOT NULL DEFAULT '0',
  `pp_tipago` int(2) NOT NULL,
  `pp_numero` int(9) NOT NULL,
  `pp_apagar` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`pp_nromat`,`pp_fecreg`,`pp_codcon`,`pp_period`,`pp_tipago`,`pp_numero`),
  KEY `pp_codcon` (`pp_codcon`),
  KEY `pp_nromat` (`pp_nromat`),
  KEY `pp_tipago` (`pp_tipago`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pagosp`
--

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

--
-- Table structure for table `pagostma`
--

DROP TABLE IF EXISTS `pagostma`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pagostma` (
  `pp_nromat` int(9) NOT NULL,
  `pp_fecreg` date NOT NULL,
  `pp_codcon` int(4) NOT NULL,
  `pp_period` int(6) NOT NULL DEFAULT '0',
  `pp_tipago` int(2) NOT NULL,
  `pp_numero` int(9) NOT NULL,
  `pp_apagar` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`pp_nromat`,`pp_fecreg`,`pp_codcon`,`pp_period`,`pp_tipago`,`pp_numero`),
  KEY `pp_codcon` (`pp_codcon`),
  KEY `pp_nromat` (`pp_nromat`),
  KEY `pp_tipago` (`pp_tipago`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pagostma`
--

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

--
-- Table structure for table `pagostmp`
--

DROP TABLE IF EXISTS `pagostmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pagostmp` (
  `pp_nromat` int(9) NOT NULL,
  `pp_fecreg` date NOT NULL,
  `pp_codcon` int(4) NOT NULL,
  `pp_period` int(6) NOT NULL DEFAULT '0',
  `pp_tipago` int(2) NOT NULL,
  `pp_numero` int(9) NOT NULL,
  `pp_apagar` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`pp_nromat`,`pp_fecreg`,`pp_codcon`,`pp_period`,`pp_tipago`,`pp_numero`),
  KEY `pp_codcon` (`pp_codcon`),
  KEY `pp_nromat` (`pp_nromat`),
  KEY `pp_tipago` (`pp_tipago`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pagostmp`
--

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

--
-- Table structure for table `pendientepagos`
--

DROP TABLE IF EXISTS `pendientepagos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pendientepagos` (
  `pp_banco` int(4) NOT NULL,
  `pp_fechap` date NOT NULL,
  `pp_nrodoc` varchar(12) NOT NULL,
  `pp_valor` double(12,2) DEFAULT NULL,
  `pp_detalle` text,
  `pp_usuario` char(10) DEFAULT NULL,
  `pp_fechacon` date NOT NULL,
  PRIMARY KEY (`pp_banco`,`pp_fechap`,`pp_nrodoc`),
  KEY `pp_pendiente_2` (`pp_banco`),
  KEY `pp_pendiente_3` (`pp_banco`,`pp_fechap`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pendientepagos`
--

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

--
-- Table structure for table `produccion`
--

DROP TABLE IF EXISTS `produccion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `produccion` (
  `pro_nromat` int(9) NOT NULL,
  `pro_consu1` double(7,2) DEFAULT NULL,
  `pro_consu2` double(7,2) DEFAULT NULL,
  `pro_consu3` double(7,2) DEFAULT NULL,
  `pro_consu4` double(7,2) DEFAULT NULL,
  `pro_consu5` double(7,2) DEFAULT NULL,
  `pro_consu6` double(7,2) DEFAULT NULL,
  `pro_promed` double(7,2) DEFAULT NULL,
  `pro_consumo` double(7,2) DEFAULT NULL,
  PRIMARY KEY (`pro_nromat`),
  KEY `pro_nromat` (`pro_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `produccion`
--

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

--
-- Table structure for table `promreca`
--

DROP TABLE IF EXISTS `promreca`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `promreca` (
  `pr_periodo` int(6) NOT NULL,
  `pr_codcon` int(4) NOT NULL,
  `pr_por_30` double(9,2) DEFAULT NULL,
  `pr_por_60` double(9,2) DEFAULT NULL,
  `pr_por_90` double(9,2) DEFAULT NULL,
  `pr_por_120` double(9,2) DEFAULT NULL,
  `pr_por_150` double(9,2) DEFAULT NULL,
  `pr_por_180` double(9,2) DEFAULT NULL,
  `pr_por_210` double(9,2) DEFAULT NULL,
  `pr_por_240` double(9,2) DEFAULT NULL,
  `pr_por_270` double(9,2) DEFAULT NULL,
  `pr_por_300` double(9,2) DEFAULT NULL,
  `pr_por_330` double(9,2) DEFAULT NULL,
  `pr_por_360` double(9,2) DEFAULT NULL,
  `pr_por_720` double(9,2) DEFAULT NULL,
  `pr_por_1080` double(9,2) DEFAULT NULL,
  `pr_por_1440` double(9,2) DEFAULT NULL,
  `pr_por_1800` double(9,2) DEFAULT NULL,
  `pr_por_m1800` double(9,2) DEFAULT NULL,
  PRIMARY KEY (`pr_periodo`,`pr_codcon`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `promreca`
--

LOCK TABLES `promreca` WRITE;
/*!40000 ALTER TABLE `promreca` DISABLE KEYS */;
/*!40000 ALTER TABLE `promreca` 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=InnoDB 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 `recaudador`
--

DROP TABLE IF EXISTS `recaudador`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recaudador` (
  `re_codrec` bigint(12) NOT NULL,
  `re_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`re_codrec`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recaudador`
--

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

--
-- Table structure for table `recaudos`
--

DROP TABLE IF EXISTS `recaudos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recaudos` (
  `re_banco` int(4) NOT NULL,
  `re_fecreg` date NOT NULL,
  `re_vlrtot` double(12,2) DEFAULT NULL,
  `re_estado` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`re_banco`,`re_fecreg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recaudos`
--

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

--
-- Table structure for table `repuesto`
--

DROP TABLE IF EXISTS `repuesto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `repuesto` (
  `rp_codrep` int(9) NOT NULL,
  `rp_descri` char(40) DEFAULT NULL,
  `rp_vlrrep` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`rp_codrep`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `repuesto`
--

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

--
-- Table structure for table `riesgo`
--

DROP TABLE IF EXISTS `riesgo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `riesgo` (
  `ri_nromat` int(9) NOT NULL,
  `ri_apagar` double(12,2) DEFAULT NULL,
  `ri_mesven` int(4) DEFAULT NULL,
  `ri_cansus` int(9) DEFAULT NULL,
  `ri_valdia` int(9) DEFAULT NULL,
  `ri_antigu` int(9) DEFAULT NULL,
  `ri_claseu` int(9) DEFAULT NULL,
  `ri_factur` int(2) DEFAULT NULL,
  `ri_totalr` double(12,8) DEFAULT NULL,
  `ri_descri` char(15) DEFAULT NULL,
  PRIMARY KEY (`ri_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `riesgo`
--

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

--
-- Table structure for table `seccion`
--

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

--
-- Dumping data for table `seccion`
--

LOCK TABLES `seccion` WRITE;
/*!40000 ALTER TABLE `seccion` DISABLE KEYS */;
/*!40000 ALTER TABLE `seccion` 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(2) NOT NULL,
  `se_descri` char(50) DEFAULT NULL,
  PRIMARY KEY (`se_codsec`)
) ENGINE=InnoDB 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 */;
/*!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(1) NOT NULL,
  `se_descri` char(40) DEFAULT NULL,
  `se_numero` int(9) DEFAULT NULL,
  PRIMARY KEY (`se_tipsec`)
) ENGINE=InnoDB 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 */;
/*!40000 ALTER TABLE `secuencia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `servicios`
--

DROP TABLE IF EXISTS `servicios`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `servicios` (
  `sv_codser` int(2) NOT NULL,
  `sv_descri` char(40) DEFAULT NULL,
  `sv_tiptar` char(1) DEFAULT NULL,
  `sv_serref` int(2) DEFAULT NULL,
  `sv_porref` float(3,2) DEFAULT NULL,
  `sv_indexa` double DEFAULT NULL,
  `sv_morares` double DEFAULT NULL,
  `sv_moranres` double DEFAULT NULL,
  `sv_divcon` char(1) DEFAULT NULL,
  `sv_rango1` int(4) DEFAULT NULL,
  `sv_rango2` int(4) DEFAULT NULL,
  `sv_rango3` int(4) DEFAULT NULL,
  PRIMARY KEY (`sv_codser`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `servicios`
--

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

--
-- Table structure for table `soldnotas`
--

DROP TABLE IF EXISTS `soldnotas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `soldnotas` (
  `snd_numero` int(9) NOT NULL,
  `snd_nromat` int(9) NOT NULL,
  `snd_codcon` int(4) NOT NULL,
  `snd_period` int(6) NOT NULL DEFAULT '0',
  `snd_ubica` int(1) NOT NULL DEFAULT '0',
  `snd_apagar` double(12,2) DEFAULT NULL,
  `snd_vlrnue` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`snd_numero`,`snd_nromat`,`snd_codcon`,`snd_period`,`snd_ubica`),
  KEY `snd_codcon` (`snd_codcon`),
  KEY `snd_nromat` (`snd_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `soldnotas`
--

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

--
-- Table structure for table `solnotas`
--

DROP TABLE IF EXISTS `solnotas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `solnotas` (
  `sn_numero` int(9) NOT NULL,
  `sn_nromat` int(9) NOT NULL,
  `sn_fecreg` date NOT NULL,
  `sn_usuario` char(10) DEFAULT NULL,
  `sn_hora` time NOT NULL DEFAULT '00:00:00',
  `sn_observa` text,
  `sn_fecha_apli` date NOT NULL,
  `sn_usuario_apli` char(10) DEFAULT NULL,
  `sn_hora_apli` time NOT NULL DEFAULT '00:00:00',
  `sn_observa_apli` text,
  `sn_estado` char(1) DEFAULT NULL,
  `sn_tiporefe` char(1) NOT NULL,
  `sn_numerefe` varchar(15) NOT NULL,
  `sn_movimiento` varchar(15) NOT NULL,
  PRIMARY KEY (`sn_numero`),
  KEY `sn_nromat` (`sn_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `solnotas`
--

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

--
-- Table structure for table `tareco`
--

DROP TABLE IF EXISTS `tareco`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tareco` (
  `tareco_yeard` int(4) NOT NULL,
  `tareco_mes` int(2) NOT NULL,
  `tareco_uso` int(2) NOT NULL,
  `tareco_estrato` int(2) NOT NULL,
  `tareco_vlrcor` double(9,3) DEFAULT NULL,
  `tareco_vlrrec` double(9,3) DEFAULT NULL,
  PRIMARY KEY (`tareco_yeard`,`tareco_mes`,`tareco_uso`,`tareco_estrato`),
  KEY `tareco_uso` (`tareco_uso`),
  KEY `tareco_estrato` (`tareco_estrato`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tareco`
--

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

--
-- Table structure for table `tarifasb`
--

DROP TABLE IF EXISTS `tarifasb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tarifasb` (
  `tar_yeardb` int(4) NOT NULL,
  `tar_mesb` int(2) NOT NULL,
  `tar_serviciob` int(2) NOT NULL,
  `tar_usob` int(2) NOT NULL,
  `tar_estratob` int(2) NOT NULL,
  `tar_carfijb` float(9,3) DEFAULT NULL,
  `tar_conbasb` float(9,3) DEFAULT NULL,
  `tar_concomb` float(9,3) DEFAULT NULL,
  `tar_consunb` float(9,3) DEFAULT NULL,
  PRIMARY KEY (`tar_yeardb`,`tar_mesb`,`tar_serviciob`,`tar_usob`,`tar_estratob`),
  KEY `tar_estratob` (`tar_estratob`),
  KEY `tar_serviciob` (`tar_serviciob`),
  KEY `tar_usob` (`tar_usob`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tarifasb`
--

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

--
-- Table structure for table `tarifasc`
--

DROP TABLE IF EXISTS `tarifasc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tarifasc` (
  `tar_yeardc` int(4) NOT NULL,
  `tar_mesc` int(2) NOT NULL,
  `tar_servicioc` int(2) NOT NULL,
  `tar_usoc` int(2) NOT NULL,
  `tar_estratoc` int(2) NOT NULL,
  `tar_carfijc` float(9,3) DEFAULT NULL,
  `tar_conbasc` float(9,3) DEFAULT NULL,
  `tar_concomc` float(9,3) DEFAULT NULL,
  `tar_consunc` float(9,3) DEFAULT NULL,
  PRIMARY KEY (`tar_yeardc`,`tar_mesc`,`tar_servicioc`,`tar_usoc`,`tar_estratoc`),
  KEY `tar_estratoc` (`tar_estratoc`),
  KEY `tar_servicioc` (`tar_servicioc`),
  KEY `tar_usoc` (`tar_usoc`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tarifasc`
--

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

--
-- Table structure for table `tarifaseo`
--

DROP TABLE IF EXISTS `tarifaseo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tarifaseo` (
  `taras_yeard` int(4) NOT NULL,
  `taras_mes` int(2) NOT NULL,
  `taras_servicio` int(2) NOT NULL,
  `taras_uso` int(2) NOT NULL,
  `taras_estrato` int(2) NOT NULL,
  `taras_estmed` int(2) NOT NULL,
  `taras_tbl` double(15,5) DEFAULT NULL,
  `taras_trt` double(15,5) DEFAULT NULL,
  `taras_tte` double(15,5) DEFAULT NULL,
  `taras_tdt` double(15,5) DEFAULT NULL,
  `taras_tmr` double(15,5) DEFAULT NULL,
  `taras_tmrf` double(15,5) DEFAULT NULL,
  `taras_tmrv` double(15,5) DEFAULT NULL,
  `taras_tfr` double(15,5) DEFAULT NULL,
  `taras_tar` double(15,5) DEFAULT NULL,
  `taras_facsub` double(15,4) DEFAULT NULL,
  `taras_tarsub` double(15,5) DEFAULT NULL,
  `taras_subapo` double(15,5) DEFAULT NULL,
  PRIMARY KEY (`taras_yeard`,`taras_mes`,`taras_servicio`,`taras_uso`,`taras_estrato`,`taras_estmed`),
  KEY `tar_estrato` (`taras_estrato`),
  KEY `tar_servicio` (`taras_servicio`),
  KEY `tar_uso` (`taras_uso`),
  KEY `tar_estmed` (`taras_estmed`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tarifaseo`
--

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

--
-- Table structure for table `tarifaspag`
--

DROP TABLE IF EXISTS `tarifaspag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tarifaspag` (
  `tar_yeards` int(4) NOT NULL,
  `tar_mess` int(2) NOT NULL,
  `tar_servicios` int(2) NOT NULL,
  `tar_usos` int(2) NOT NULL,
  `tar_estratos` int(2) NOT NULL,
  `tar_carfijs` float(9,8) DEFAULT NULL,
  `tar_conbass` float(9,3) DEFAULT NULL,
  `tar_concoms` float(9,3) DEFAULT NULL,
  `tar_consuns` float(9,3) DEFAULT NULL,
  PRIMARY KEY (`tar_yeards`,`tar_mess`,`tar_servicios`,`tar_usos`,`tar_estratos`),
  KEY `tar_estratos` (`tar_estratos`),
  KEY `tar_servicios` (`tar_servicios`),
  KEY `tar_usos` (`tar_usos`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tarifaspag`
--

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

--
-- Table structure for table `tarifass`
--

DROP TABLE IF EXISTS `tarifass`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tarifass` (
  `tar_yeards` int(4) NOT NULL,
  `tar_mess` int(2) NOT NULL,
  `tar_servicios` int(2) NOT NULL,
  `tar_usos` int(2) NOT NULL,
  `tar_estratos` int(2) NOT NULL,
  `tar_carfijs` float(9,3) DEFAULT NULL,
  `tar_conbass` float(9,3) DEFAULT NULL,
  `tar_concoms` float(9,3) DEFAULT NULL,
  `tar_consuns` float(9,3) DEFAULT NULL,
  PRIMARY KEY (`tar_yeards`,`tar_mess`,`tar_servicios`,`tar_usos`,`tar_estratos`),
  KEY `tar_estratos` (`tar_estratos`),
  KEY `tar_servicios` (`tar_servicios`),
  KEY `tar_usos` (`tar_usos`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tarifass`
--

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

--
-- Table structure for table `tasas`
--

DROP TABLE IF EXISTS `tasas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tasas` (
  `ta_periodo` int(6) NOT NULL,
  `ta_valor` double(10,4) NOT NULL,
  PRIMARY KEY (`ta_periodo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tasas`
--

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

--
-- Table structure for table `temporal`
--

DROP TABLE IF EXISTS `temporal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temporal` (
  `tm_nromat` int(9) NOT NULL,
  `tm_valor` double(10,2) NOT NULL,
  PRIMARY KEY (`tm_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `temporal`
--

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

--
-- Table structure for table `terceros`
--

DROP TABLE IF EXISTS `terceros`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `terceros` (
  `te_codcli` bigint(12) NOT NULL DEFAULT '0',
  `te_nombre` char(50) NOT NULL DEFAULT '',
  `te_direcc` char(50) NOT NULL DEFAULT '',
  `te_telefo` char(30) NOT NULL DEFAULT '',
  `te_fecnac` date DEFAULT NULL,
  `te_estudi` char(10) DEFAULT NULL,
  `te_sexo` char(1) NOT NULL,
  PRIMARY KEY (`te_codcli`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `terceros`
--

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

--
-- Table structure for table `terusuario`
--

DROP TABLE IF EXISTS `terusuario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `terusuario` (
  `tu_nromat` int(9) NOT NULL,
  `tu_codcli` bigint(12) NOT NULL DEFAULT '0',
  `tu_tipo` char(15) DEFAULT NULL,
  PRIMARY KEY (`tu_nromat`,`tu_codcli`),
  KEY `tu_nromat` (`tu_nromat`),
  KEY `tu_codcli` (`tu_codcli`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `terusuario`
--

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

--
-- Table structure for table `tiaforo`
--

DROP TABLE IF EXISTS `tiaforo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tiaforo` (
  `ta_taforo` int(2) NOT NULL,
  `ta_descri` char(60) DEFAULT NULL,
  PRIMARY KEY (`ta_taforo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tiaforo`
--

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

--
-- Table structure for table `timedi`
--

DROP TABLE IF EXISTS `timedi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `timedi` (
  `tm_timedi` int(2) NOT NULL,
  `tm_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`tm_timedi`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `timedi`
--

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

--
-- Table structure for table `tipago`
--

DROP TABLE IF EXISTS `tipago`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipago` (
  `tp_tipago` int(2) NOT NULL,
  `tp_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`tp_tipago`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tipago`
--

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

--
-- Table structure for table `tisuspen`
--

DROP TABLE IF EXISTS `tisuspen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tisuspen` (
  `ts_tisuspen` int(2) NOT NULL,
  `ts_descri` char(60) DEFAULT NULL,
  PRIMARY KEY (`ts_tisuspen`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tisuspen`
--

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

--
-- Table structure for table `tisuspen_vis`
--

DROP TABLE IF EXISTS `tisuspen_vis`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tisuspen_vis` (
  `ts_tisuspen` int(2) NOT NULL,
  `ts_descri` char(60) DEFAULT NULL,
  PRIMARY KEY (`ts_tisuspen`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tisuspen_vis`
--

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

--
-- Table structure for table `tmpniif`
--

DROP TABLE IF EXISTS `tmpniif`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tmpniif` (
  `tn_uso` varchar(2) NOT NULL,
  `tn_est` varchar(2) NOT NULL,
  `tn_fase` varchar(2) NOT NULL,
  `tn_tipo` varchar(2) NOT NULL,
  `tn_serv` varchar(4) NOT NULL,
  `tn_conc` varchar(4) NOT NULL,
  `tn_signo` varchar(1) NOT NULL,
  `tn_valor` varchar(20) NOT NULL,
  PRIMARY KEY (`tn_uso`,`tn_est`,`tn_fase`,`tn_tipo`,`tn_serv`,`tn_conc`,`tn_signo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tmpniif`
--

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

--
-- Table structure for table `totfach`
--

DROP TABLE IF EXISTS `totfach`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `totfach` (
  `th_nromat` int(9) NOT NULL,
  `th_nrofac` int(9) DEFAULT NULL,
  `th_apagar` double(12,2) DEFAULT NULL,
  `th_salant` double(12,2) DEFAULT NULL,
  `th_salact` double(12,2) DEFAULT NULL,
  `th_notadb` double(12,2) DEFAULT NULL,
  `th_notacr` double(12,2) DEFAULT NULL,
  `th_pagado` double(12,2) DEFAULT NULL,
  `th_afavor` double(12,2) DEFAULT NULL,
  `th_recibo` int(9) DEFAULT NULL,
  `th_ulfepa` date DEFAULT NULL,
  `th_mesven` int(4) DEFAULT NULL,
  `th_mesinl` int(4) DEFAULT NULL,
  `th_ultpag` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`th_nromat`),
  UNIQUE KEY `totfach_th_recibo_key` (`th_recibo`),
  KEY `th_nromat` (`th_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `totfach`
--

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

--
-- Table structure for table `totfact`
--

DROP TABLE IF EXISTS `totfact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `totfact` (
  `tf_nromat` int(9) NOT NULL,
  `tf_nrofac` int(9) DEFAULT NULL,
  `tf_apagar` double(12,2) DEFAULT NULL,
  `tf_salant` double(12,2) DEFAULT NULL,
  `tf_salact` double(12,2) DEFAULT NULL,
  `tf_notadb` double(12,2) DEFAULT NULL,
  `tf_notacr` double(12,2) DEFAULT NULL,
  `tf_pagado` double(12,2) DEFAULT NULL,
  `tf_afavor` double(12,2) DEFAULT NULL,
  `tf_recibo` int(9) DEFAULT NULL,
  `tf_ulfepa` date DEFAULT NULL,
  `tf_mesven` int(4) DEFAULT NULL,
  `tf_mesinl` int(4) DEFAULT NULL,
  `tf_ultpag` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`tf_nromat`),
  UNIQUE KEY `totfact_tf_recibo_key` (`tf_recibo`),
  KEY `tf_nromat` (`tf_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `totfact`
--

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

--
-- Table structure for table `usoest`
--

DROP TABLE IF EXISTS `usoest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usoest` (
  `ue_uso` int(2) NOT NULL,
  `ue_estrato` int(2) NOT NULL,
  `ue_detalle` char(40) DEFAULT NULL,
  PRIMARY KEY (`ue_uso`,`ue_estrato`),
  KEY `ue_estrato` (`ue_estrato`),
  KEY `ue_uso` (`ue_uso`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usoest`
--

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

--
-- Table structure for table `usos`
--

DROP TABLE IF EXISTS `usos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usos` (
  `us_coduso` int(2) NOT NULL,
  `us_detalle` char(40) DEFAULT NULL,
  PRIMARY KEY (`us_coduso`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usos`
--

LOCK TABLES `usos` WRITE;
/*!40000 ALTER TABLE `usos` DISABLE KEYS */;
/*!40000 ALTER TABLE `usos` 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=InnoDB 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 `variesgo`
--

DROP TABLE IF EXISTS `variesgo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `variesgo` (
  `vr_codrie` char(4) NOT NULL,
  `vr_descri` char(50) DEFAULT NULL,
  `vr_ranini` double(15,8) NOT NULL,
  `vr_ranfin` double(15,8) NOT NULL,
  `vr_puntos` double(15,8) NOT NULL,
  PRIMARY KEY (`vr_codrie`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `variesgo`
--

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

--
-- Table structure for table `vence`
--

DROP TABLE IF EXISTS `vence`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vence` (
  `vc_codigo` int(4) NOT NULL,
  `vc_descri` char(40) DEFAULT NULL,
  `vc_fecpago` char(15) DEFAULT NULL,
  `vc_fecreca` char(15) DEFAULT NULL,
  `vc_fecini` char(15) DEFAULT NULL,
  `vc_fecfin` char(15) DEFAULT NULL,
  `vc_dias` char(5) DEFAULT NULL,
  `vc_ano` int(4) DEFAULT NULL,
  `vc_mes` int(4) DEFAULT NULL,
  `vc_periodo` char(20) DEFAULT NULL,
  `vc_txt1` char(70) DEFAULT NULL,
  `vc_txt2` char(70) DEFAULT NULL,
  `vc_txt3` char(70) DEFAULT NULL,
  `vc_txt4` char(70) DEFAULT NULL,
  `vc_txt5` char(70) DEFAULT NULL,
  `vc_txt6` char(70) DEFAULT NULL,
  `vc_txt7` char(70) DEFAULT NULL,
  `vc_txt8` char(70) DEFAULT NULL,
  PRIMARY KEY (`vc_codigo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vence`
--

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

--
-- Table structure for table `vlrcuoh`
--

DROP TABLE IF EXISTS `vlrcuoh`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrcuoh` (
  `ch_nromat` int(9) NOT NULL,
  `ch_codcon` int(4) NOT NULL,
  `ch_period` int(6) NOT NULL DEFAULT '0',
  `ch_totfin` double(12,2) DEFAULT NULL,
  `ch_vlrtot` double(12,2) DEFAULT NULL,
  `ch_vlrcuo` double(12,2) DEFAULT NULL,
  `ch_cuotas` float(5,2) DEFAULT NULL,
  `ch_pagada` float(5,2) DEFAULT NULL,
  `ch_fecreg` date DEFAULT NULL,
  `ch_fecini` date DEFAULT NULL,
  `ch_operar` char(12) DEFAULT NULL,
  `ch_diapag` int(9) DEFAULT NULL,
  PRIMARY KEY (`ch_nromat`,`ch_codcon`,`ch_period`),
  KEY `ch_codcon` (`ch_codcon`),
  KEY `ch_nromat` (`ch_nromat`),
  KEY `ch_operar` (`ch_operar`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrcuoh`
--

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

--
-- Table structure for table `vlrcuoh_inicial`
--

DROP TABLE IF EXISTS `vlrcuoh_inicial`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrcuoh_inicial` (
  `ch_nromat` int(9) NOT NULL,
  `ch_codcon` int(4) NOT NULL,
  `ch_period` int(6) NOT NULL DEFAULT '0',
  `ch_totfin` double(12,2) DEFAULT NULL,
  `ch_vlrtot` double(12,2) DEFAULT NULL,
  `ch_vlrcuo` double(12,2) DEFAULT NULL,
  `ch_cuotas` float(5,2) DEFAULT NULL,
  `ch_pagada` float(5,2) DEFAULT NULL,
  `ch_fecreg` date DEFAULT NULL,
  `ch_fecini` date DEFAULT NULL,
  `ch_operar` char(12) DEFAULT NULL,
  `ch_diapag` int(9) DEFAULT NULL,
  PRIMARY KEY (`ch_nromat`,`ch_codcon`,`ch_period`),
  KEY `ch_codcon` (`ch_codcon`),
  KEY `ch_nromat` (`ch_nromat`),
  KEY `ch_operar` (`ch_operar`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrcuoh_inicial`
--

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

--
-- Table structure for table `vlrcuot`
--

DROP TABLE IF EXISTS `vlrcuot`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrcuot` (
  `ct_nromat` int(9) NOT NULL,
  `ct_codcon` int(4) NOT NULL,
  `ct_period` int(6) NOT NULL DEFAULT '0',
  `ct_totfin` double(12,2) DEFAULT NULL,
  `ct_vlrtot` double(12,2) DEFAULT NULL,
  `ct_vlrcuo` double(12,2) DEFAULT NULL,
  `ct_cuotas` float(5,2) DEFAULT NULL,
  `ct_pagada` float(5,2) DEFAULT NULL,
  `ct_fecreg` date DEFAULT NULL,
  `ct_fecini` date DEFAULT NULL,
  `ct_operar` char(12) DEFAULT NULL,
  `ct_diapag` int(9) DEFAULT NULL,
  PRIMARY KEY (`ct_nromat`,`ct_codcon`,`ct_period`),
  KEY `ct_codcon` (`ct_codcon`),
  KEY `ct_nromat` (`ct_nromat`),
  KEY `ct_operar` (`ct_operar`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrcuot`
--

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

--
-- Table structure for table `vlrcuotr`
--

DROP TABLE IF EXISTS `vlrcuotr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrcuotr` (
  `ctr_nromat` int(9) NOT NULL,
  `ctr_codcon` int(4) NOT NULL,
  `ctr_period` int(6) NOT NULL DEFAULT '0',
  `ctr_totfin` double(12,2) DEFAULT NULL,
  `ctr_vlrtot` double(12,2) DEFAULT NULL,
  `ctr_vlrcuo` double(12,2) DEFAULT NULL,
  `ctr_cuotas` float(5,2) DEFAULT NULL,
  `ctr_pagada` float(5,2) DEFAULT NULL,
  `ctr_fecreg` date DEFAULT NULL,
  `ctr_fecini` date DEFAULT NULL,
  `ctr_operar` bigint(12) DEFAULT NULL,
  `ctr_diapag` int(2) DEFAULT NULL,
  PRIMARY KEY (`ctr_nromat`,`ctr_codcon`,`ctr_period`),
  KEY `ctr_codcon` (`ctr_codcon`),
  KEY `ctr_nromat` (`ctr_nromat`),
  KEY `ctr_operar` (`ctr_operar`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrcuotr`
--

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

--
-- Table structure for table `vlrdeud`
--

DROP TABLE IF EXISTS `vlrdeud`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrdeud` (
  `dd_nromat` int(9) NOT NULL,
  `dd_codcon` int(4) NOT NULL,
  `dd_period` int(6) NOT NULL DEFAULT '0',
  `dd_apagar` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`dd_nromat`,`dd_codcon`,`dd_period`),
  KEY `dd_codcon` (`dd_codcon`),
  KEY `dd_nromat` (`dd_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrdeud`
--

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

--
-- Table structure for table `vlrdeuh`
--

DROP TABLE IF EXISTS `vlrdeuh`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrdeuh` (
  `ddh_nromat` int(9) NOT NULL,
  `ddh_codcon` int(4) NOT NULL,
  `ddh_period` int(6) NOT NULL DEFAULT '0',
  `ddh_apagar` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`ddh_nromat`,`ddh_codcon`,`ddh_period`),
  KEY `ddh_codcon` (`ddh_codcon`),
  KEY `ddh_nromat` (`ddh_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrdeuh`
--

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

--
-- Table structure for table `vlrfach`
--

DROP TABLE IF EXISTS `vlrfach`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrfach` (
  `dfh_nromat` int(9) NOT NULL,
  `dfh_codcon` int(4) NOT NULL,
  `dfh_period` int(6) NOT NULL DEFAULT '0',
  `dfh_apagar` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`dfh_nromat`,`dfh_codcon`,`dfh_period`),
  KEY `dfh_codcon` (`dfh_codcon`),
  KEY `dfh_nromat` (`dfh_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrfach`
--

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

--
-- Table structure for table `vlrfact`
--

DROP TABLE IF EXISTS `vlrfact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrfact` (
  `df_nromat` int(9) NOT NULL,
  `df_codcon` int(4) NOT NULL,
  `df_period` int(6) NOT NULL DEFAULT '0',
  `df_apagar` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`df_nromat`,`df_codcon`,`df_period`),
  KEY `df_codcon` (`df_codcon`),
  KEY `df_nromat` (`df_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrfact`
--

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

--
-- Table structure for table `vlrrech`
--

DROP TABLE IF EXISTS `vlrrech`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrrech` (
  `dhr_nromat` int(9) NOT NULL,
  `dhr_codcon` int(4) NOT NULL,
  `dhr_period` int(6) NOT NULL DEFAULT '0',
  `dhr_apagar` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`dhr_nromat`,`dhr_codcon`,`dhr_period`),
  KEY `dhr_codcon` (`dhr_codcon`),
  KEY `dhr_nromat` (`dhr_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrrech`
--

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

--
-- Table structure for table `vlrrecl`
--

DROP TABLE IF EXISTS `vlrrecl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrrecl` (
  `dr_nromat` int(9) NOT NULL,
  `dr_codcon` int(4) NOT NULL,
  `dr_period` int(6) NOT NULL DEFAULT '0',
  `dr_apagar` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`dr_nromat`,`dr_codcon`,`dr_period`),
  KEY `dr_codcon` (`dr_codcon`),
  KEY `dr_nromat` (`dr_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrrecl`
--

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

--
-- Table structure for table `vlrtemp`
--

DROP TABLE IF EXISTS `vlrtemp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrtemp` (
  `dt_nromat` int(9) NOT NULL,
  `dt_codcon` int(4) NOT NULL,
  `dt_period` int(6) NOT NULL DEFAULT '0',
  `dt_ubica` int(1) NOT NULL DEFAULT '0',
  `dt_apagar` double(12,2) DEFAULT NULL,
  `dt_vlrnue` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`dt_nromat`,`dt_codcon`,`dt_period`,`dt_ubica`),
  KEY `dt_codcon` (`dt_codcon`),
  KEY `dt_nromat` (`dt_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrtemp`
--

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

--
-- Dumping events for database 'antsoftw_leticia_fact202102'
--

--
-- Dumping routines for database 'antsoftw_leticia_fact202102'
--
/*!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 2021-05-05  3:16:51
