-- MySQL dump 10.16  Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: SPYquartup1
-- ------------------------------------------------------
-- Server version	10.1.48-MariaDB-0+deb9u2

/*!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 `cialejer`
--

DROP TABLE IF EXISTS `cialejer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cialejer` (
  `ejercicio` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Ejercicio',
  `fecha_apertura` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha Apertura',
  `fecha_cierre` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha cierre',
  `descripcion` text NOT NULL COMMENT 'Descripción',
  `fecha_ciepar_cont` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Cierre parcial contable',
  `fecha_ciepar_comp` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Cierre parcial compras',
  `fecha_ciepar_vent` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Cierre parcial ventas',
  `sw_abierto` char(1) NOT NULL DEFAULT 'N' COMMENT 'Apertura hecha',
  `sw_regularizado` char(1) NOT NULL DEFAULT 'N' COMMENT 'Regulariz. hecha',
  `sw_cerrado` char(1) NOT NULL DEFAULT 'N' COMMENT 'Cierre hecho',
  `sw_regularizar` char(1) NOT NULL DEFAULT 'N' COMMENT 'Regularizar',
  `sw_cerrar` char(1) NOT NULL DEFAULT 'N' COMMENT 'Cerrar',
  `sw_retroceder` char(1) NOT NULL DEFAULT 'N' COMMENT 'Retroceder',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  UNIQUE KEY `key0` (`id_tenant`,`ejercicio`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cialejer`
--
-- WHERE:  id_tenant='1'

LOCK TABLES `cialejer` WRITE;
/*!40000 ALTER TABLE `cialejer` DISABLE KEYS */;
INSERT INTO `cialejer` (`ejercicio`, `fecha_apertura`, `fecha_cierre`, `descripcion`, `fecha_ciepar_cont`, `fecha_ciepar_comp`, `fecha_ciepar_vent`, `sw_abierto`, `sw_regularizado`, `sw_cerrado`, `sw_regularizar`, `sw_cerrar`, `sw_retroceder`, `id_tenant`) VALUES (1999,'1999-01-01','1999-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2000,'2000-01-01','2000-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2001,'2001-01-01','2001-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2002,'2002-01-01','2002-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2003,'2003-01-01','2003-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2004,'2004-01-01','2004-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2005,'2005-01-01','2005-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2006,'2006-01-01','2006-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2007,'2007-01-01','2007-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2008,'2008-01-01','2008-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2009,'2009-01-01','2009-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2010,'2010-01-01','2010-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2011,'2011-01-01','2011-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2012,'2012-01-01','2012-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2013,'2013-01-01','2013-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2014,'2014-01-01','2014-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2015,'2015-01-01','2015-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2016,'2016-01-01','2016-12-31','Traspasado','0000-00-00','0000-00-00','0000-00-00','N','S','S','N','N','N',1),(2017,'2017-01-01','2017-12-31','Creado automáticamente','0000-00-00','0000-00-00','0000-00-00','S','S','S','N','N','N',1),(2018,'2018-01-01','2018-12-31','Creado automáticamente','2018-12-31','2018-12-31','2018-12-31','S','S','S','N','N','N',1),(2019,'2019-01-01','2019-12-31','Creado automáticamente','2019-01-01','2019-12-31','2019-12-31','S','S','S','N','N','N',1),(2020,'2020-01-01','2020-12-31','Creado automáticamente','2020-01-01','2020-12-31','2020-12-31','S','S','S','N','N','N',1),(2021,'2021-01-01','2021-12-31','Creado automáticamente','2021-12-31','2021-12-31','2021-12-31','S','S','S','N','N','N',1),(2022,'2022-01-01','2022-12-31','Creado automáticamente','2022-12-31','2022-12-31','2022-12-31','S','S','S','N','N','N',1),(2023,'2023-01-01','2023-12-31','Creado automáticamente','2023-12-31','2023-12-31','2023-12-31','S','S','S','N','N','N',1),(2024,'2024-01-01','2024-12-31','Cierre ejercicio 2024','2024-12-31','2024-12-31','2024-12-31','S','S','S','N','N','N',1),(2025,'2025-01-01','2025-12-31','Creado automáticamente','0000-00-00','0000-00-00','0000-00-00','S','N','N','N','N','N',1),(2026,'2026-01-01','2026-12-31','Creado automáticamente','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2028,'2028-01-01','2028-12-31','Creado automáticamente','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1),(2032,'2032-01-01','2032-12-31','Creado automáticamente','0000-00-00','0000-00-00','0000-00-00','N','N','N','N','N','N',1);
/*!40000 ALTER TABLE `cialejer` 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 2025-10-30  8:40:58
