-- MySQL dump 10.13 Distrib 5.5.35, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: santander -- ------------------------------------------------------ -- Server version 5.5.35-0ubuntu0.13.10.2 /*!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 `bd_apunte` -- DROP TABLE IF EXISTS `bd_apunte`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bd_apunte` ( `Id_apunte` int(5) NOT NULL AUTO_INCREMENT, `fecha_cargo` date NOT NULL, `fecha_valor` date NOT NULL, `comision` decimal(10,2) DEFAULT NULL, `concepto` varchar(55) DEFAULT 'Gastos Reclamacion Saldo Deudor', `total_interes` decimal(10,2) DEFAULT NULL, `total_demora` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`Id_apunte`), KEY `k_fechas` (`fecha_cargo`,`fecha_valor`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bd_apunte` -- LOCK TABLES `bd_apunte` WRITE; /*!40000 ALTER TABLE `bd_apunte` DISABLE KEYS */; INSERT INTO `bd_apunte` VALUES (1,'2013-03-11','2013-03-11',35.00,'GASTOS POSICIONES DEUDORAS',3.02,2.88),(2,'2013-05-25','2013-05-25',35.00,'GASTOS POSICIONES DEUDORAS',2.38,2.25),(3,'2013-05-30','2013-05-30',35.00,'GASTOS POSICIONES DEUDORAS',2.33,2.21),(4,'2013-08-12','2013-08-12',35.00,'GASTOS POSICIONES DEUDORAS',1.70,1.60),(5,'2013-09-10','2013-09-10',39.00,'GASTOS POSICIONES DEUDORAS',1.62,1.51),(6,'2013-11-08','2013-11-08',39.00,'GASTOS POSICIONES DEUDORAS',1.05,0.97),(7,'2013-12-02','2013-12-02',39.00,'GASTOS POSICIONES DEUDORAS',0.82,0.75),(8,'2014-01-07','2014-01-07',39.00,'GASTOS POSICIONES DEUDORAS',0.47,0.43); /*!40000 ALTER TABLE `bd_apunte` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bd_demora_comercial` -- DROP TABLE IF EXISTS `bd_demora_comercial`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bd_demora_comercial` ( `Id_demora_comercial` int(5) NOT NULL AUTO_INCREMENT, `fecha_inicio` date NOT NULL, `fecha_fin` date NOT NULL, `demora_comercial` decimal(4,2) NOT NULL, PRIMARY KEY (`Id_demora_comercial`) ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bd_demora_comercial` -- LOCK TABLES `bd_demora_comercial` WRITE; /*!40000 ALTER TABLE `bd_demora_comercial` DISABLE KEYS */; INSERT INTO `bd_demora_comercial` VALUES (1,'1990-01-01','2002-12-31',0.00),(2,'2003-01-01','2003-06-30',9.85),(3,'2003-07-01','2003-12-31',9.10),(4,'2004-01-01','2004-06-30',9.02),(5,'2004-07-01','2004-12-31',9.01),(6,'2005-01-01','2005-06-30',9.09),(7,'2005-07-01','2005-12-31',9.05),(8,'2006-01-01','2006-06-30',9.25),(9,'2006-07-01','2006-12-31',9.83),(10,'2007-01-01','2007-06-30',10.58),(11,'2007-07-01','2007-12-31',11.07),(12,'2008-01-01','2008-06-30',11.20),(13,'2008-07-01','2008-12-31',11.07),(14,'2009-01-01','2009-06-30',9.50),(15,'2009-07-01','2009-12-31',8.00),(16,'2010-01-01','2010-06-30',8.00),(17,'2010-07-01','2010-12-31',8.00),(18,'2011-01-01','2011-06-30',8.00),(19,'2011-07-01','2011-12-31',8.25),(20,'2012-01-01','2012-06-30',8.00),(21,'2012-07-01','2012-12-31',8.00),(22,'2013-01-01','2013-02-23',7.75),(23,'2013-02-24','2013-06-30',8.75),(24,'2013-07-01','2013-12-31',8.50),(25,'2014-01-01','2014-06-30',8.25); /*!40000 ALTER TABLE `bd_demora_comercial` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bd_demora_legal` -- DROP TABLE IF EXISTS `bd_demora_legal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bd_demora_legal` ( `Id_demora_legal` int(5) NOT NULL AUTO_INCREMENT, `fecha_inicio` date NOT NULL, `fecha_fin` date NOT NULL, `demora_legal` decimal(4,2) NOT NULL, PRIMARY KEY (`Id_demora_legal`) ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bd_demora_legal` -- LOCK TABLES `bd_demora_legal` WRITE; /*!40000 ALTER TABLE `bd_demora_legal` DISABLE KEYS */; INSERT INTO `bd_demora_legal` VALUES (1,'1990-01-01','1990-12-31',12.00),(2,'1991-01-01','1991-12-31',12.00),(3,'1992-01-01','1992-12-31',12.00),(4,'1993-01-01','1993-12-31',12.00),(5,'1994-01-01','1994-12-31',11.00),(6,'1995-01-01','1995-12-31',11.00),(7,'1996-01-01','1996-12-31',11.00),(8,'1997-01-01','1997-12-31',9.50),(9,'1998-01-01','1998-12-31',7.50),(10,'1999-01-01','1999-12-31',5.50),(11,'2000-01-01','2000-12-31',5.50),(12,'2001-01-01','2001-12-31',6.50),(13,'2002-01-01','2002-12-31',5.50),(14,'2003-01-01','2003-12-31',5.50),(15,'2004-01-01','2004-12-31',4.75),(16,'2005-01-01','2005-12-31',5.00),(17,'2006-01-01','2006-12-31',5.00),(18,'2007-01-01','2007-12-31',6.25),(19,'2008-01-01','2008-12-31',7.00),(20,'2009-01-01','2009-03-31',7.00),(21,'2009-04-01','2009-12-31',5.00),(22,'2010-01-01','2010-12-31',5.00),(23,'2011-01-01','2011-12-31',5.00),(24,'2012-01-01','2012-12-31',5.00),(25,'2013-01-01','2013-12-31',5.00),(26,'2014-01-01','2014-12-31',5.00); /*!40000 ALTER TABLE `bd_demora_legal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bd_detalle` -- DROP TABLE IF EXISTS `bd_detalle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bd_detalle` ( `Id_detalle` int(5) NOT NULL AUTO_INCREMENT, `fecha_cargo` date NOT NULL, `fecha_valor` date NOT NULL, `apunte` int(5) DEFAULT NULL, `per_ini` date DEFAULT NULL, `per_fin` date DEFAULT NULL, `dias` int(4) DEFAULT NULL, `comision` decimal(10,2) DEFAULT NULL, `concepto` varchar(55) DEFAULT NULL, `interes` decimal(4,2) DEFAULT NULL, `demora` decimal(4,2) DEFAULT NULL, `total_interes` decimal(10,2) DEFAULT NULL, `total_demora` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`Id_detalle`), KEY `k_fechas` (`fecha_cargo`,`fecha_valor`) ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bd_detalle` -- LOCK TABLES `bd_detalle` WRITE; /*!40000 ALTER TABLE `bd_detalle` DISABLE KEYS */; INSERT INTO `bd_detalle` VALUES (1,'2013-03-11','2013-03-11',1,'2013-03-11','2013-06-30',112,35.00,'Periodo: 01 de 02 ** Sub-Periodo: 01 de 02',NULL,8.75,NULL,0.94),(2,'2013-03-11','2013-03-11',1,'2013-07-01','2013-12-31',184,35.00,'Periodo: 01 de 02 ** Sub-Periodo: 02 de 02',NULL,8.50,NULL,1.50),(3,'2013-03-11','2013-03-11',1,'2014-01-01','2014-02-25',55,35.00,'Periodo: 02 de 02 ** Sub-Periodo: 01 de 01',NULL,8.25,NULL,0.44),(4,'2013-05-25','2013-05-25',2,'2013-05-25','2013-06-30',37,35.00,'Periodo: 01 de 02 ** Sub-Periodo: 01 de 02',NULL,8.75,NULL,0.31),(5,'2013-05-25','2013-05-25',2,'2013-07-01','2013-12-31',184,35.00,'Periodo: 01 de 02 ** Sub-Periodo: 02 de 02',NULL,8.50,NULL,1.50),(6,'2013-05-25','2013-05-25',2,'2014-01-01','2014-02-25',55,35.00,'Periodo: 02 de 02 ** Sub-Periodo: 01 de 01',NULL,8.25,NULL,0.44),(7,'2013-05-30','2013-05-30',3,'2013-05-30','2013-06-30',32,35.00,'Periodo: 01 de 02 ** Sub-Periodo: 01 de 02',NULL,8.75,NULL,0.27),(8,'2013-05-30','2013-05-30',3,'2013-07-01','2013-12-31',184,35.00,'Periodo: 01 de 02 ** Sub-Periodo: 02 de 02',NULL,8.50,NULL,1.50),(9,'2013-05-30','2013-05-30',3,'2014-01-01','2014-02-25',55,35.00,'Periodo: 02 de 02 ** Sub-Periodo: 01 de 01',NULL,8.25,NULL,0.44),(10,'2013-08-12','2013-08-12',4,'2013-08-12','2013-12-31',142,35.00,'Periodo: 01 de 02 ** Sub-Periodo: 01 de 01',NULL,8.50,NULL,1.16),(11,'2013-08-12','2013-08-12',4,'2014-01-01','2014-02-25',55,35.00,'Periodo: 02 de 02 ** Sub-Periodo: 01 de 01',NULL,8.25,NULL,0.44),(12,'2013-09-10','2013-09-10',5,'2013-09-10','2013-12-31',113,39.00,'Periodo: 01 de 02 ** Sub-Periodo: 01 de 01',NULL,8.50,NULL,1.03),(13,'2013-09-10','2013-09-10',5,'2014-01-01','2014-02-25',55,39.00,'Periodo: 02 de 02 ** Sub-Periodo: 01 de 01',NULL,8.25,NULL,0.48),(14,'2013-11-08','2013-11-08',6,'2013-11-08','2013-12-31',54,39.00,'Periodo: 01 de 02 ** Sub-Periodo: 01 de 01',NULL,8.50,NULL,0.49),(15,'2013-11-08','2013-11-08',6,'2014-01-01','2014-02-25',55,39.00,'Periodo: 02 de 02 ** Sub-Periodo: 01 de 01',NULL,8.25,NULL,0.48),(16,'2013-12-02','2013-12-02',7,'2013-12-02','2013-12-31',30,39.00,'Periodo: 01 de 02 ** Sub-Periodo: 01 de 01',NULL,8.50,NULL,0.27),(17,'2013-12-02','2013-12-02',7,'2014-01-01','2014-02-25',55,39.00,'Periodo: 02 de 02 ** Sub-Periodo: 01 de 01',NULL,8.25,NULL,0.48),(18,'2014-01-07','2014-01-07',8,'2014-01-07','2014-02-25',49,39.00,'Periodo: 01 de 01 ** Sub-Periodo: 01 de 01',NULL,8.25,NULL,0.43); /*!40000 ALTER TABLE `bd_detalle` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bd_interes_legal` -- DROP TABLE IF EXISTS `bd_interes_legal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bd_interes_legal` ( `Id_interes_legal` int(5) NOT NULL AUTO_INCREMENT, `fecha_inicio` date NOT NULL, `fecha_fin` date NOT NULL, `interes_legal` decimal(4,2) NOT NULL, PRIMARY KEY (`Id_interes_legal`) ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bd_interes_legal` -- LOCK TABLES `bd_interes_legal` WRITE; /*!40000 ALTER TABLE `bd_interes_legal` DISABLE KEYS */; INSERT INTO `bd_interes_legal` VALUES (1,'1990-01-01','1990-12-31',10.00),(2,'1991-01-01','1991-12-31',10.00),(3,'1992-01-01','1992-12-31',10.00),(4,'1993-01-01','1993-12-31',10.00),(5,'1994-01-01','1994-12-31',9.00),(6,'1995-01-01','1995-12-31',9.00),(7,'1996-01-01','1996-12-31',9.00),(8,'1997-01-01','1997-12-31',7.50),(9,'1998-01-01','1998-12-31',5.50),(10,'1999-01-01','1999-12-31',4.25),(11,'2000-01-01','2000-12-31',4.25),(12,'2001-01-01','2001-12-31',5.50),(13,'2002-01-01','2002-12-31',4.25),(14,'2003-01-01','2003-12-31',4.25),(15,'2004-01-01','2004-12-31',3.75),(16,'2005-01-01','2005-12-31',4.00),(17,'2006-01-01','2006-12-31',4.00),(18,'2007-01-01','2007-12-31',5.00),(19,'2008-01-01','2008-12-31',5.50),(20,'2009-01-01','2009-03-31',5.50),(21,'2009-04-01','2009-12-31',4.00),(22,'2010-01-01','2010-12-31',4.00),(23,'2011-01-01','2011-12-31',4.00),(24,'2012-01-01','2012-12-31',4.00),(25,'2013-01-01','2013-12-31',4.00),(26,'2014-01-01','2014-12-31',4.00); /*!40000 ALTER TABLE `bd_interes_legal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bd_interes_legal_mas5` -- DROP TABLE IF EXISTS `bd_interes_legal_mas5`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bd_interes_legal_mas5` ( `Id_interes_legal_mas5` int(5) DEFAULT NULL, `fecha_inicio` date NOT NULL, `fecha_fin` date NOT NULL, `interes_legal_mas5` decimal(4,2) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bd_interes_legal_mas5` -- LOCK TABLES `bd_interes_legal_mas5` WRITE; /*!40000 ALTER TABLE `bd_interes_legal_mas5` DISABLE KEYS */; INSERT INTO `bd_interes_legal_mas5` VALUES (1,'1990-01-01','1990-12-31',15.00),(2,'1991-01-01','1991-12-31',15.00),(3,'1992-01-01','1992-12-31',15.00),(4,'1993-01-01','1993-12-31',15.00),(5,'1994-01-01','1994-12-31',14.00),(6,'1995-01-01','1995-12-31',14.00),(7,'1996-01-01','1996-12-31',14.00),(8,'1997-01-01','1997-12-31',12.50),(9,'1998-01-01','1998-12-31',10.50),(10,'1999-01-01','1999-12-31',9.25),(11,'2000-01-01','2000-12-31',9.25),(12,'2001-01-01','2001-12-31',10.50),(13,'2002-01-01','2002-12-31',9.25),(14,'2003-01-01','2003-12-31',9.25),(15,'2004-01-01','2004-12-31',8.75),(16,'2005-01-01','2005-12-31',9.00),(17,'2006-01-01','2006-12-31',9.00),(18,'2007-01-01','2007-12-31',10.00),(19,'2008-01-01','2008-12-31',10.50),(20,'2009-01-01','2009-03-31',10.50),(21,'2009-04-01','2009-12-31',9.00),(22,'2010-01-01','2010-12-31',9.00),(23,'2011-01-01','2011-12-31',9.00),(24,'2012-01-01','2012-12-31',9.00),(25,'2013-01-01','2013-12-31',9.00),(26,'2014-01-01','2014-12-31',9.00); /*!40000 ALTER TABLE `bd_interes_legal_mas5` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bd_interes_pactado` -- DROP TABLE IF EXISTS `bd_interes_pactado`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bd_interes_pactado` ( `Id_interes_pactado` int(4) NOT NULL AUTO_INCREMENT, `fecha_inicio` date NOT NULL, `fecha_fin` date NOT NULL, `interes_pactado` decimal(4,2) DEFAULT NULL, PRIMARY KEY (`Id_interes_pactado`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bd_interes_pactado` -- LOCK TABLES `bd_interes_pactado` WRITE; /*!40000 ALTER TABLE `bd_interes_pactado` DISABLE KEYS */; INSERT INTO `bd_interes_pactado` VALUES (1,'1990-01-01','1990-12-31',10.00),(2,'1991-01-01','1991-12-31',10.00),(3,'1992-01-01','1992-12-31',10.00),(4,'1993-01-01','1993-12-31',10.00),(5,'1994-01-01','1994-12-31',9.00),(6,'1995-01-01','1995-12-31',9.00),(7,'1996-01-01','1996-12-31',9.00),(8,'1997-01-01','1997-12-31',7.50),(9,'1998-01-01','1998-12-31',5.50),(10,'1999-01-01','1999-12-31',4.25),(11,'2000-01-01','2000-12-31',4.25),(12,'2001-01-01','2001-12-31',5.50),(13,'2002-01-01','2002-12-31',4.25),(14,'2003-01-01','2003-12-31',4.25),(15,'2004-01-01','2004-12-31',3.75),(16,'2005-01-01','2005-12-31',4.00),(17,'2006-01-01','2006-12-31',4.00),(18,'2007-01-01','2007-12-31',5.00),(19,'2008-01-01','2008-12-31',5.50),(20,'2009-01-01','2009-03-31',5.50),(21,'2009-04-01','2009-12-31',4.00),(22,'2010-01-01','2010-12-31',4.00),(23,'2011-01-01','2011-12-31',4.00),(24,'2012-01-01','2012-12-31',4.00),(25,'2013-01-01','2013-12-31',4.00),(26,'2014-01-01','2014-12-31',4.00); /*!40000 ALTER TABLE `bd_interes_pactado` ENABLE KEYS */; UNLOCK TABLES; /*!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 2014-02-24 7:32:48