-- 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