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

DROP TABLE IF EXISTS `acuerdo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acuerdo` (
  `acuer_numero` int(9) NOT NULL,
  `acuer_codcli` int(9) DEFAULT NULL,
  `acuer_codres` char(12) NOT NULL,
  `acuer_fecreg` date DEFAULT NULL,
  `acuer_vlrdeu` double(12,2) DEFAULT NULL,
  `acuer_vlrtot` double(12,2) DEFAULT NULL,
  `acuer_vlrcuo` double(12,2) DEFAULT NULL,
  `acuer_cuotas` double(12,2) DEFAULT NULL,
  `acuer_porcen` int(3) DEFAULT NULL,
  `acuer_forpag` char(10) NOT NULL,
  `acuer_abonos` double(12,2) NOT NULL,
  `acuer_pagos` double(12,2) NOT NULL,
  `acuer_estado` varchar(1) NOT NULL,
  `acuer_total` double(12,2) NOT NULL,
  `acuer_fecini` date NOT NULL,
  `acuer_concep` int(4) NOT NULL,
  `acuer_tercero` bigint(12) NOT NULL,
  `acuer_descuento` double(12,2) NOT NULL,
  `acuer_tasapact` double(12,8) NOT NULL,
  `acuer_tasamerc` double(12,8) NOT NULL,
  `acuer_nroant` int(9) NOT NULL,
  `acuer_hora` time NOT NULL,
  `acuer_fecfin` date NOT NULL,
  PRIMARY KEY (`acuer_numero`),
  KEY `acuer_codcli` (`acuer_codcli`),
  KEY `acuer_tercero` (`acuer_tercero`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `acuerdo`
--

LOCK TABLES `acuerdo` WRITE;
/*!40000 ALTER TABLE `acuerdo` DISABLE KEYS */;
/*!40000 ALTER TABLE `acuerdo` 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 `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 `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(80) 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,
  `cp_poriva` double(15,3) 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 `consinvestiga`
--

DROP TABLE IF EXISTS `consinvestiga`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `consinvestiga` (
  `ci_numero` int(9) NOT NULL DEFAULT '0',
  `ci_nromat` int(9) NOT NULL DEFAULT '0',
  `ci_detalle` text NOT NULL,
  `ci_metfac` int(9) NOT NULL DEFAULT '0',
  `ci_metrel` int(9) NOT NULL DEFAULT '0',
  `ci_vlracu` double(10,2) NOT NULL DEFAULT '0.00',
  `ci_vlralc` double(10,2) NOT NULL DEFAULT '0.00',
  `ci_fecreg` date DEFAULT NULL,
  `ci_usuario` char(12) DEFAULT NULL,
  `ci_periodo` int(6) NOT NULL,
  `ci_estado` varchar(1) NOT NULL,
  PRIMARY KEY (`ci_numero`),
  KEY `ci_nromat` (`ci_nromat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `consinvestiga`
--

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

--
-- Table structure for table `descuentos`
--

DROP TABLE IF EXISTS `descuentos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `descuentos` (
  `de_numero` int(9) NOT NULL,
  `de_codcli` bigint(12) DEFAULT NULL,
  `de_nropla` char(6) DEFAULT NULL,
  `de_codres` char(12) NOT NULL,
  `de_fecreg` date DEFAULT NULL,
  `de_horreg` time NOT NULL DEFAULT '00:00:00',
  `de_vlrtot` double(15,2) DEFAULT NULL,
  `de_estado` char(1) NOT NULL,
  `de_tippag` char(1) NOT NULL,
  `de_pagado` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`de_numero`),
  KEY `de_codcli` (`de_codcli`),
  KEY `de_nropla` (`de_nropla`),
  KEY `de_codres` (`de_codres`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `descuentos`
--

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

--
-- Table structure for table `detacuerdo`
--

DROP TABLE IF EXISTS `detacuerdo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detacuerdo` (
  `dacuer_numero` int(9) NOT NULL,
  `dacuer_cuota` bigint(12) NOT NULL DEFAULT '0',
  `dacuer_fecreg` date DEFAULT NULL,
  `dacuer_capital` double(15,2) DEFAULT NULL,
  `dacuer_interes` double(15,2) DEFAULT NULL,
  `dacuer_total` double(15,2) DEFAULT NULL,
  `dacuer_pagos` double(15,2) NOT NULL,
  `dacuer_saldocapital` double(15,2) DEFAULT NULL,
  `dacuer_vna` double(15,2) DEFAULT NULL,
  `dacuer_salajuvna` double(15,2) DEFAULT NULL,
  `dacuer_ajuvna` double(15,2) DEFAULT NULL,
  `dacuer_salvna` double(15,2) DEFAULT NULL,
  `dacuer_salconcorr` double(15,2) DEFAULT NULL,
  `dacuer_salajucorr` double(15,2) DEFAULT NULL,
  `dacuer_ajucorr` double(15,2) DEFAULT NULL,
  `dacuer_salvnanocorr` double(15,2) DEFAULT NULL,
  `dacuer_salconnocorr` double(15,2) DEFAULT NULL,
  `dacuer_salajunocorr` double(15,2) DEFAULT NULL,
  `dacuer_ajunocorr` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dacuer_numero`,`dacuer_cuota`),
  KEY `dacuer_numero` (`dacuer_numero`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detacuerdo`
--

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

--
-- Table structure for table `detacuerdo_rz`
--

DROP TABLE IF EXISTS `detacuerdo_rz`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detacuerdo_rz` (
  `dacuer_numero` int(9) NOT NULL,
  `dacuer_cuota` bigint(12) NOT NULL DEFAULT '0',
  `dacuer_fecreg` date DEFAULT NULL,
  `dacuer_capital` double(15,2) DEFAULT NULL,
  `dacuer_interes` double(15,2) DEFAULT NULL,
  `dacuer_total` double(15,2) DEFAULT NULL,
  `dacuer_pagos` double(15,2) NOT NULL,
  `dacuer_saldocapital` double(15,2) DEFAULT NULL,
  `dacuer_vna` double(15,2) DEFAULT NULL,
  `dacuer_salajuvna` double(15,2) DEFAULT NULL,
  `dacuer_ajuvna` double(15,2) DEFAULT NULL,
  `dacuer_salvna` double(15,2) DEFAULT NULL,
  `dacuer_salconcorr` double(15,2) DEFAULT NULL,
  `dacuer_salajucorr` double(15,2) DEFAULT NULL,
  `dacuer_ajucorr` double(15,2) DEFAULT NULL,
  `dacuer_salvnanocorr` double(15,2) DEFAULT NULL,
  `dacuer_salconnocorr` double(15,2) DEFAULT NULL,
  `dacuer_salajunocorr` double(15,2) DEFAULT NULL,
  `dacuer_ajunocorr` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dacuer_numero`,`dacuer_cuota`),
  KEY `dacuer_numero` (`dacuer_numero`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detacuerdo_rz`
--

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

--
-- Table structure for table `detdescuentos`
--

DROP TABLE IF EXISTS `detdescuentos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detdescuentos` (
  `dd_numero` int(9) NOT NULL,
  `dd_codcon` int(4) NOT NULL,
  `dd_nrofac` int(9) NOT NULL,
  `dd_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dd_numero`,`dd_codcon`,`dd_nrofac`),
  KEY `dd_numero` (`dd_numero`),
  KEY `dd_codcon` (`dd_codcon`),
  KEY `dd_nrofac` (`dd_nrofac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detdescuentos`
--

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

--
-- Table structure for table `detfac`
--

DROP TABLE IF EXISTS `detfac`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detfac` (
  `df_numero` int(9) NOT NULL,
  `df_codcon` int(4) NOT NULL,
  `df_cantid` double(15,2) DEFAULT NULL,
  `df_vlruni` double(15,2) DEFAULT NULL,
  `df_vlriva` double(15,2) DEFAULT NULL,
  `df_vlrtot` double(15,2) DEFAULT NULL,
  `df_pagos` double(15,2) DEFAULT NULL,
  `df_detalle` varchar(40) NOT NULL,
  PRIMARY KEY (`df_numero`,`df_codcon`),
  KEY `df_numero` (`df_numero`),
  KEY `df_codcon` (`df_codcon`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detfac`
--

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

--
-- Table structure for table `detordenes`
--

DROP TABLE IF EXISTS `detordenes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detordenes` (
  `dor_numero` int(9) NOT NULL,
  `dor_codcon` int(9) NOT NULL,
  `dor_bodega` varchar(90) NOT NULL,
  `dor_cantid` double(15,2) DEFAULT NULL,
  `dor_vlruni` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`dor_numero`,`dor_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detordenes`
--

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

--
-- Table structure for table `detped`
--

DROP TABLE IF EXISTS `detped`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detped` (
  `dp_numero` int(9) NOT NULL,
  `dp_codcon` int(4) NOT NULL,
  `dp_cantid` double(15,2) DEFAULT NULL,
  `dp_vlruni` double(15,2) DEFAULT NULL,
  `dp_vlrtot` double(15,2) DEFAULT NULL,
  `dp_detalle` varchar(40) NOT NULL,
  PRIMARY KEY (`dp_numero`,`dp_codcon`),
  KEY `dp_codcon` (`dp_codcon`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detped`
--

LOCK TABLES `detped` WRITE;
/*!40000 ALTER TABLE `detped` DISABLE KEYS */;
/*!40000 ALTER TABLE `detped` 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(4) NOT NULL,
  `dpr_nrofac` int(9) NOT NULL DEFAULT '0',
  `dpr_vlrtot` double(15,2) DEFAULT 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 `detrecibos`
--

DROP TABLE IF EXISTS `detrecibos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detrecibos` (
  `dr_numero` int(9) NOT NULL,
  `dr_codcon` int(4) NOT NULL,
  `dr_nrofac` int(9) NOT NULL,
  `dr_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dr_numero`,`dr_codcon`,`dr_nrofac`),
  KEY `dr_numero` (`dr_numero`),
  KEY `dr_codcon` (`dr_codcon`),
  KEY `dr_nrofac` (`dr_nrofac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detrecibos`
--

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

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

DROP TABLE IF EXISTS `empresa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empresa` (
  `ep_codemp` char(12) NOT NULL DEFAULT '',
  `ep_nombre` char(60) NOT NULL DEFAULT '',
  `ep_direcc` char(40) NOT NULL DEFAULT '',
  `ep_telefo` char(10) 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 */;
INSERT INTO `empresa` (`ep_codemp`, `ep_nombre`, `ep_direcc`, `ep_telefo`, `ep_dpto`, `ep_mcpio`) VALUES ('901445146-5','GASO COLOMBIA S.A.S. E.S.P.','CR 7 CL 65 B CONJ. MILENIUM LC -1','3235726291','','');
/*!40000 ALTER TABLE `empresa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `factemitidas`
--

DROP TABLE IF EXISTS `factemitidas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `factemitidas` (
  `fe_nromat` int(9) NOT NULL,
  `fe_periodo` int(6) NOT NULL,
  `fe_nrofac` int(9) NOT NULL,
  `fe_fecemi` varchar(8) NOT NULL,
  `fe_fecven` varchar(8) NOT NULL,
  PRIMARY KEY (`fe_nromat`,`fe_periodo`,`fe_nrofac`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `factemitidas`
--

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

--
-- Table structure for table `facturas`
--

DROP TABLE IF EXISTS `facturas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `facturas` (
  `fa_numero` int(9) NOT NULL,
  `fa_codcli` bigint(12) NOT NULL DEFAULT '0',
  `fa_nropla` char(6) DEFAULT NULL,
  `fa_codres` char(12) NOT NULL,
  `fa_fecreg` date DEFAULT NULL,
  `fa_horreg` time NOT NULL DEFAULT '00:00:00',
  `fa_vlrtot` double(15,2) DEFAULT NULL,
  `fa_descli` double(15,2) DEFAULT NULL,
  `fa_vlriva` double(15,2) DEFAULT NULL,
  `fa_apagar` double(15,2) DEFAULT NULL,
  `fa_estado` char(1) NOT NULL,
  `fa_tippag` char(1) NOT NULL,
  `fa_pagado` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`fa_numero`),
  KEY `fa_codcli` (`fa_codcli`),
  KEY `fa_nropla` (`fa_nropla`),
  KEY `fa_codres` (`fa_codres`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `facturas`
--

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

--
-- Table structure for table `fcopias`
--

DROP TABLE IF EXISTS `fcopias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fcopias` (
  `fc_nrofac` int(9) NOT NULL DEFAULT '0',
  `fc_nromat` int(9) NOT NULL,
  `fc_apagar` double(12,2) DEFAULT NULL,
  `fc_vabono` double(12,2) DEFAULT NULL,
  `fc_ulfeab` date DEFAULT NULL,
  `fc_usuari` char(12) DEFAULT NULL,
  `fc_tipo` char(12) DEFAULT NULL,
  `fc_periodo` char(6) DEFAULT NULL,
  PRIMARY KEY (`fc_nrofac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fcopias`
--

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

--
-- Table structure for table `matriz`
--

DROP TABLE IF EXISTS `matriz`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `matriz` (
  `mt_ano` int(4) NOT NULL,
  `mt_mes` int(2) NOT NULL,
  `mt_mcpio` int(2) NOT NULL,
  `mt_ciclo` int(2) NOT NULL,
  `mt_usu_acu` int(10) NOT NULL,
  `mt_usu_alc` int(10) NOT NULL,
  `mt_usu_ase` int(10) NOT NULL,
  `mt_usu_acu_p` int(10) NOT NULL,
  `mt_usu_alc_p` int(10) NOT NULL,
  `mt_usu_ase_p` int(10) NOT NULL,
  `mt_usu_acu_des` int(10) NOT NULL,
  `mt_usu_alc_des` int(10) NOT NULL,
  `mt_usu_ase_des` int(10) NOT NULL,
  `mt_med_ins` int(10) NOT NULL,
  `mt_med_fun` int(10) NOT NULL,
  `mt_med_pag` int(10) NOT NULL,
  `mt_pqr_pet` int(10) NOT NULL,
  `mt_pqr_que` int(10) NOT NULL,
  `mt_pqr_rec` int(10) NOT NULL,
  `mt_pqr_sol` int(10) NOT NULL,
  `mt_pqr_pro` int(10) NOT NULL,
  `mt_met_acu` double(15,2) NOT NULL,
  `mt_met_alc` double(15,2) NOT NULL,
  `mt_met_ase` double(15,2) NOT NULL,
  `mt_fc_acue` double(15,2) NOT NULL,
  `mt_fc_alca` double(15,2) NOT NULL,
  `mt_fc_aseo` double(15,2) NOT NULL,
  `mt_sb_acue` double(15,2) NOT NULL,
  `mt_sb_alca` double(15,2) NOT NULL,
  `mt_sb_aseo` double(15,2) NOT NULL,
  `mt_ap_acue` double(15,2) NOT NULL,
  `mt_ap_alca` double(15,2) NOT NULL,
  `mt_ap_aseo` double(15,2) NOT NULL,
  `mt_otro_acue` double(15,2) NOT NULL,
  `mt_otro_alca` double(15,2) NOT NULL,
  `mt_otro_aseo` double(15,2) NOT NULL,
  `mt_rec_acue_c` double(15,2) NOT NULL,
  `mt_rec_alca_c` double(15,2) NOT NULL,
  `mt_rec_aseo_c` double(15,2) NOT NULL,
  `mt_rec_acue_d` double(15,2) NOT NULL,
  `mt_rec_alca_d` double(15,2) NOT NULL,
  `mt_rec_aseo_d` double(15,2) NOT NULL,
  `mt_facturas` int(10) NOT NULL,
  `mt_fac_30` double(15,2) NOT NULL,
  `mt_fac_60` double(15,2) NOT NULL,
  `mt_fac_90` double(15,2) NOT NULL,
  `mt_fac_120` double(15,2) NOT NULL,
  `mt_fac_150` double(15,2) NOT NULL,
  `mt_fac_180` double(15,2) NOT NULL,
  `mt_fac_360` double(15,2) NOT NULL,
  `mt_fac_1800` double(15,2) NOT NULL,
  `mt_fac_mas` double(15,2) NOT NULL,
  `mt_pag_30` double(15,2) NOT NULL,
  `mt_pag_60` double(15,2) NOT NULL,
  `mt_pag_90` double(15,2) NOT NULL,
  `mt_pag_120` double(15,2) NOT NULL,
  `mt_pag_150` double(15,2) NOT NULL,
  `mt_pag_180` double(15,2) NOT NULL,
  `mt_pag_360` double(15,2) NOT NULL,
  `mt_pag_1800` double(15,2) NOT NULL,
  `mt_pag_mas` double(15,2) NOT NULL,
  `mt_usu_susp` double(15,2) NOT NULL,
  `mt_usu_inac` double(15,2) NOT NULL,
  `mt_nue_acue` int(10) NOT NULL,
  `mt_nue_alca` int(10) NOT NULL,
  `mt_nue_aseo` int(10) NOT NULL,
  `mt_nue_total` int(10) NOT NULL,
  PRIMARY KEY (`mt_ano`,`mt_mes`,`mt_mcpio`,`mt_ciclo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `matriz`
--

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

--
-- Table structure for table `ordenes`
--

DROP TABLE IF EXISTS `ordenes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ordenes` (
  `or_numero` int(9) NOT NULL,
  `or_codcli` varchar(12) NOT NULL DEFAULT '0',
  `or_pedido` int(9) NOT NULL,
  `or_observa` text,
  `or_codres` char(12) NOT NULL,
  `or_fecreg` date DEFAULT NULL,
  `or_horreg` time NOT NULL DEFAULT '00:00:00',
  `or_vlrtot` int(9) DEFAULT NULL,
  `or_descli` int(9) DEFAULT NULL,
  `or_vlriva` int(9) DEFAULT NULL,
  `or_apagar` int(9) DEFAULT NULL,
  `or_estado` char(1) NOT NULL,
  `or_tippag` char(1) NOT NULL,
  `or_contrato` varchar(10) NOT NULL,
  `or_vigencia` int(6) NOT NULL,
  PRIMARY KEY (`or_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ordenes`
--

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

--
-- Table structure for table `pedidos`
--

DROP TABLE IF EXISTS `pedidos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidos` (
  `pe_numero` int(9) NOT NULL,
  `pe_mesa` bigint(12) NOT NULL,
  `pe_observ` char(40) DEFAULT NULL,
  PRIMARY KEY (`pe_numero`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidos`
--

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

--
-- Table structure for table `pedidosre`
--

DROP TABLE IF EXISTS `pedidosre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidosre` (
  `per_numero` int(9) NOT NULL,
  `per_observ` char(40) DEFAULT NULL,
  `per_codcli` bigint(12) DEFAULT NULL,
  PRIMARY KEY (`per_numero`),
  KEY `per_codcli` (`per_codcli`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidosre`
--

LOCK TABLES `pedidosre` WRITE;
/*!40000 ALTER TABLE `pedidosre` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidosre` 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 `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 `recibos`
--

DROP TABLE IF EXISTS `recibos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recibos` (
  `re_numero` int(9) NOT NULL,
  `re_codcli` bigint(12) DEFAULT NULL,
  `re_nropla` char(6) DEFAULT NULL,
  `re_codres` char(12) NOT NULL,
  `re_fecreg` date DEFAULT NULL,
  `re_horreg` time NOT NULL DEFAULT '00:00:00',
  `re_vlrtot` double(15,2) DEFAULT NULL,
  `re_estado` char(1) NOT NULL,
  `re_tippag` char(1) NOT NULL,
  `re_pagado` double(15,2) DEFAULT NULL,
  `re_cuenta` varchar(20) NOT NULL,
  PRIMARY KEY (`re_numero`),
  KEY `re_codcli` (`re_codcli`),
  KEY `re_nropla` (`re_nropla`),
  KEY `re_codres` (`re_codres`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recibos`
--

LOCK TABLES `recibos` WRITE;
/*!40000 ALTER TABLE `recibos` DISABLE KEYS */;
/*!40000 ALTER TABLE `recibos` 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 `secuencia`
--

DROP TABLE IF EXISTS `secuencia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `secuencia` (
  `se_tipsec` char(2) NOT NULL,
  `se_descri` char(40) DEFAULT NULL,
  `se_numero` int(9) DEFAULT NULL,
  PRIMARY KEY (`se_tipsec`)
) ENGINE=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 */;
INSERT INTO `secuencia` (`se_tipsec`, `se_descri`, `se_numero`) VALUES ('A','Acuerdos de Financiacion',0),('B','BOLETINES',0),('F','Facturas',0),('G','Generar Abono',0),('I','Avisos de Suspension',0),('M','Movimientos',0),('N','Nuevos usuarios  Matriculados',0),('OR','ORDENES',0),('P','PAGOS',0),('Q','Actualizaciones de Suscriptores',0),('R','Recibos Facturas',0),('S','Cobro Persuasivo',0),('V','Visitas de Gestion',0),('Y','Impresion de Ordenes',0);
/*!40000 ALTER TABLE `secuencia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `soldcobro`
--

DROP TABLE IF EXISTS `soldcobro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `soldcobro` (
  `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 `soldcobro`
--

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

--
-- Table structure for table `suspension`
--

DROP TABLE IF EXISTS `suspension`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suspension` (
  `sus_nromat` int(9) NOT NULL,
  `sus_numbol` int(9) NOT NULL,
  `sus_fecreg` date DEFAULT NULL,
  `sus_horreg` time DEFAULT NULL,
  `sus_usuari` char(10) DEFAULT NULL,
  `sus_numrec` int(9) NOT NULL,
  `sus_fecrec` date DEFAULT NULL,
  `sus_horrec` time DEFAULT NULL,
  `sus_usuarc` char(10) DEFAULT NULL,
  `sus_gestor` bigint(12) NOT NULL,
  `sus_gestion` varchar(10) NOT NULL,
  `sus_observa` text NOT NULL,
  `sus_gestorei` bigint(20) NOT NULL,
  `sus_fecharei` date NOT NULL,
  `sus_periodo` int(8) NOT NULL,
  `sus_tipsus` int(8) NOT NULL,
  `sus_fecsus` date NOT NULL,
  PRIMARY KEY (`sus_numbol`),
  KEY `sus_numbol` (`sus_numbol`),
  KEY `sus_numrec` (`sus_numrec`),
  KEY `sus_gestor` (`sus_gestor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suspension`
--

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

--
-- Table structure for table `suspension_cr`
--

DROP TABLE IF EXISTS `suspension_cr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suspension_cr` (
  `sus_nromat` int(9) NOT NULL,
  `sus_numbol` int(9) NOT NULL,
  `sus_fecreg` date DEFAULT NULL,
  `sus_horreg` time DEFAULT NULL,
  `sus_usuari` char(10) DEFAULT NULL,
  `sus_numrec` int(9) NOT NULL,
  `sus_fecrec` date DEFAULT NULL,
  `sus_horrec` time DEFAULT NULL,
  `sus_usuarc` char(10) DEFAULT NULL,
  `sus_gestor` bigint(12) NOT NULL,
  `sus_gestion` varchar(10) NOT NULL,
  `sus_observa` text NOT NULL,
  `sus_gestorei` bigint(20) NOT NULL,
  `sus_fecharei` date NOT NULL,
  `sus_periodo` int(8) NOT NULL,
  `sus_tipsus` int(8) NOT NULL,
  `sus_fecsus` date NOT NULL,
  PRIMARY KEY (`sus_numbol`),
  KEY `sus_numbol` (`sus_numbol`),
  KEY `sus_numrec` (`sus_numrec`),
  KEY `sus_gestor` (`sus_gestor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suspension_cr`
--

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

--
-- Table structure for table `suspensionr`
--

DROP TABLE IF EXISTS `suspensionr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suspensionr` (
  `sus_nromat` int(9) NOT NULL,
  `sus_numbol` int(9) NOT NULL,
  `sus_fecreg` date DEFAULT NULL,
  `sus_horreg` time DEFAULT NULL,
  `sus_usuari` char(10) DEFAULT NULL,
  `sus_numrec` int(9) NOT NULL,
  `sus_fecrec` date DEFAULT NULL,
  `sus_horrec` time DEFAULT NULL,
  `sus_usuarc` char(10) DEFAULT NULL,
  `sus_gestor` bigint(12) NOT NULL,
  `sus_gestion` varchar(10) NOT NULL,
  `sus_observa` text NOT NULL,
  `sus_gestorei` bigint(20) NOT NULL,
  `sus_fecharei` date NOT NULL,
  `sus_periodo` int(8) NOT NULL,
  `sus_tipsus` int(8) NOT NULL,
  `sus_fecsus` date NOT NULL,
  PRIMARY KEY (`sus_numbol`),
  KEY `sus_numbol` (`sus_numbol`),
  KEY `sus_numrec` (`sus_numrec`),
  KEY `sus_gestor` (`sus_gestor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suspensionr`
--

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

--
-- Table structure for table `suspensionv`
--

DROP TABLE IF EXISTS `suspensionv`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suspensionv` (
  `sus_nromat` int(9) NOT NULL,
  `sus_numbol` int(9) NOT NULL,
  `sus_fecreg` date DEFAULT NULL,
  `sus_horreg` time DEFAULT NULL,
  `sus_usuari` char(10) DEFAULT NULL,
  `sus_numrec` int(9) NOT NULL,
  `sus_fecrec` date DEFAULT NULL,
  `sus_horrec` time DEFAULT NULL,
  `sus_usuarc` char(10) DEFAULT NULL,
  `sus_gestor` bigint(12) NOT NULL,
  `sus_gestion` varchar(10) NOT NULL,
  `sus_observa` text NOT NULL,
  `sus_gestorei` bigint(20) NOT NULL,
  `sus_fecharei` date NOT NULL,
  `sus_periodo` int(8) NOT NULL,
  `sus_tipsus` int(8) NOT NULL,
  `sus_fecsus` date NOT NULL,
  PRIMARY KEY (`sus_numbol`),
  KEY `sus_numbol` (`sus_numbol`),
  KEY `sus_numrec` (`sus_numrec`),
  KEY `sus_gestor` (`sus_gestor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suspensionv`
--

LOCK TABLES `suspensionv` WRITE;
/*!40000 ALTER TABLE `suspensionv` DISABLE KEYS */;
/*!40000 ALTER TABLE `suspensionv` 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 `tipveh`
--

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

--
-- Dumping data for table `tipveh`
--

LOCK TABLES `tipveh` WRITE;
/*!40000 ALTER TABLE `tipveh` DISABLE KEYS */;
/*!40000 ALTER TABLE `tipveh` 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 `vehiculo`
--

DROP TABLE IF EXISTS `vehiculo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehiculo` (
  `vh_nropla` char(6) NOT NULL DEFAULT '',
  `vh_codmar` int(3) NOT NULL DEFAULT '0',
  `vh_tipveh` int(3) NOT NULL DEFAULT '0',
  `vh_descri` char(40) NOT NULL DEFAULT '',
  `vh_modelo` int(4) NOT NULL DEFAULT '0',
  `vh_nromot` char(20) DEFAULT NULL,
  `vh_nrocha` char(20) DEFAULT NULL,
  `vh_nrotra` char(20) DEFAULT NULL,
  `vh_nrocol` char(20) DEFAULT NULL,
  `vh_nroint` char(6) NOT NULL DEFAULT '0',
  `vh_combus` char(1) NOT NULL DEFAULT '',
  `vh_kmact` decimal(8,2) DEFAULT NULL,
  `vh_hmact` decimal(8,2) DEFAULT NULL,
  `vh_codcli` bigint(12) NOT NULL DEFAULT '0',
  `vh_pasaje` int(3) NOT NULL,
  `vh_cermov` int(10) DEFAULT NULL,
  `vh_feccer` date DEFAULT NULL,
  `vh_segobl` char(10) DEFAULT NULL,
  `vh_fecseg` date DEFAULT NULL,
  `vh_estado` char(1) NOT NULL DEFAULT '',
  `vh_afilia` char(1) NOT NULL,
  `vh_base` char(1) NOT NULL,
  PRIMARY KEY (`vh_nropla`),
  KEY `vh_tipveh` (`vh_tipveh`),
  KEY `vh_codcli` (`vh_codcli`),
  KEY `vh_codmar` (`vh_codmar`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `vehiculo` WRITE;
/*!40000 ALTER TABLE `vehiculo` DISABLE KEYS */;
INSERT INTO `vehiculo` (`vh_nropla`, `vh_codmar`, `vh_tipveh`, `vh_descri`, `vh_modelo`, `vh_nromot`, `vh_nrocha`, `vh_nrotra`, `vh_nrocol`, `vh_nroint`, `vh_combus`, `vh_kmact`, `vh_hmact`, `vh_codcli`, `vh_pasaje`, `vh_cermov`, `vh_feccer`, `vh_segobl`, `vh_fecseg`, `vh_estado`, `vh_afilia`, `vh_base`) VALUES ('-',0,0,'SIN DEFINIR',0,NULL,NULL,NULL,NULL,'0','',NULL,NULL,0,0,NULL,NULL,NULL,NULL,'','','');
/*!40000 ALTER TABLE `vehiculo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `visitas`
--

DROP TABLE IF EXISTS `visitas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visitas` (
  `vis_nromat` int(9) NOT NULL,
  `vis_numbol` int(9) NOT NULL,
  `vis_fecreg` date DEFAULT NULL,
  `vis_horreg` time DEFAULT NULL,
  `vis_usuari` char(10) DEFAULT NULL,
  `vis_gestor` bigint(12) DEFAULT NULL,
  `vis_fecrec` date DEFAULT NULL,
  `vis_horrec` time DEFAULT NULL,
  `vis_usuarc` char(10) DEFAULT NULL,
  `vis_feccom` date DEFAULT NULL,
  `vis_gestion` char(15) DEFAULT NULL,
  `vis_observa` text,
  `vis_periodo` int(8) NOT NULL,
  `vis_tipsus` int(8) NOT NULL,
  `vis_fecvis` date NOT NULL,
  PRIMARY KEY (`vis_numbol`),
  KEY `vis_numbol` (`vis_numbol`),
  KEY `vis_gestor` (`vis_gestor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `visitas`
--

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

--
-- Table structure for table `visitas_cr`
--

DROP TABLE IF EXISTS `visitas_cr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visitas_cr` (
  `vis_nromat` int(9) NOT NULL,
  `vis_numbol` int(9) NOT NULL,
  `vis_fecreg` date DEFAULT NULL,
  `vis_horreg` time DEFAULT NULL,
  `vis_usuari` char(10) DEFAULT NULL,
  `vis_gestor` bigint(12) DEFAULT NULL,
  `vis_fecrec` date DEFAULT NULL,
  `vis_horrec` time DEFAULT NULL,
  `vis_usuarc` char(10) DEFAULT NULL,
  `vis_feccom` date DEFAULT NULL,
  `vis_gestion` char(15) DEFAULT NULL,
  `vis_observa` text,
  `vis_periodo` int(8) NOT NULL,
  `vis_tipsus` int(8) NOT NULL,
  `vis_fecvis` date NOT NULL,
  PRIMARY KEY (`vis_numbol`),
  KEY `vis_numbol` (`vis_numbol`),
  KEY `vis_gestor` (`vis_gestor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `visitas_cr`
--

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

--
-- Table structure for table `visitas_ps`
--

DROP TABLE IF EXISTS `visitas_ps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visitas_ps` (
  `vis_nromat` int(9) NOT NULL,
  `vis_numbol` int(9) NOT NULL,
  `vis_fecreg` date DEFAULT NULL,
  `vis_horreg` time DEFAULT NULL,
  `vis_usuari` char(10) DEFAULT NULL,
  `vis_gestor` bigint(12) DEFAULT NULL,
  `vis_fecrec` date DEFAULT NULL,
  `vis_horrec` time DEFAULT NULL,
  `vis_usuarc` char(10) DEFAULT NULL,
  `vis_feccom` date DEFAULT NULL,
  `vis_gestion` char(10) DEFAULT NULL,
  `vis_observa` text,
  `vis_periodo` int(8) NOT NULL,
  `vis_tipsus` int(8) NOT NULL,
  `vis_fecvis` date NOT NULL,
  PRIMARY KEY (`vis_numbol`),
  KEY `vis_numbol` (`vis_numbol`),
  KEY `vis_gestor` (`vis_gestor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `visitas_ps`
--

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

--
-- Table structure for table `visitas_rc`
--

DROP TABLE IF EXISTS `visitas_rc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visitas_rc` (
  `vis_nromat` int(9) NOT NULL,
  `vis_numbol` int(9) NOT NULL,
  `vis_fecreg` date DEFAULT NULL,
  `vis_horreg` time DEFAULT NULL,
  `vis_usuari` char(10) DEFAULT NULL,
  `vis_gestor` bigint(12) DEFAULT NULL,
  `vis_fecrec` date DEFAULT NULL,
  `vis_horrec` time DEFAULT NULL,
  `vis_usuarc` char(10) DEFAULT NULL,
  `vis_feccom` date DEFAULT NULL,
  `vis_gestion` char(10) DEFAULT NULL,
  `vis_observa` text,
  `vis_periodo` int(8) NOT NULL,
  `vis_tipsus` int(8) NOT NULL,
  `vis_fecvis` date NOT NULL,
  PRIMARY KEY (`vis_numbol`),
  KEY `vis_numbol` (`vis_numbol`),
  KEY `vis_gestor` (`vis_gestor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `visitas_rc`
--

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

--
-- Table structure for table `vlrcuot_ope`
--

DROP TABLE IF EXISTS `vlrcuot_ope`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrcuot_ope` (
  `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` int(11) 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_ope`
--

LOCK TABLES `vlrcuot_ope` WRITE;
/*!40000 ALTER TABLE `vlrcuot_ope` DISABLE KEYS */;
/*!40000 ALTER TABLE `vlrcuot_ope` 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` text,
  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_integral'
--

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

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-06-05  2:37:41
