/*!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 */;
DROP TABLE IF EXISTS `banco_cliente`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banco_cliente` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cliente_id` bigint(20) unsigned NOT NULL,
  `banco_id` bigint(20) unsigned NOT NULL,
  `numero_cuenta` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipo_ingreso_banco` enum('web','api','archivo','manual') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usuario_banco` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clave_banco` text COLLATE utf8mb4_unicode_ci,
  `principal` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `banco_cliente_cliente_id_banco_id_unique` (`cliente_id`,`banco_id`),
  KEY `banco_cliente_banco_id_foreign` (`banco_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `bancos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bancos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `cliente_banco`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cliente_banco` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cliente_id` bigint(20) unsigned NOT NULL,
  `banco_id` bigint(20) unsigned NOT NULL,
  `numero_cuenta` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipo_ingreso` enum('web','api','archivo','manual') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usuario` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clave` text COLLATE utf8mb4_unicode_ci,
  `principal` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cliente_banco_cliente_id_banco_id_unique` (`cliente_id`,`banco_id`),
  KEY `cliente_banco_banco_id_foreign` (`banco_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `clientes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clientes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `grupo_empresa_id` bigint(20) unsigned DEFAULT NULL,
  `nombre_empresa` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rut_empresa` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre_rep` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rut_rep` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `direccion_emp` text COLLATE utf8mb4_unicode_ci,
  `software_id` bigint(20) unsigned DEFAULT NULL,
  `nom_en_sw` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nombre en el software',
  `usuario_sw_main` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clave_sw_main` text COLLATE utf8mb4_unicode_ci,
  `rut_sii` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rut_sii_empresa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clave_sii` text COLLATE utf8mb4_unicode_ci,
  `clave_sii_empresa` text COLLATE utf8mb4_unicode_ci,
  `clave_unica` text COLLATE utf8mb4_unicode_ci,
  `usuario_previred` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clave_previred` text COLLATE utf8mb4_unicode_ci,
  `clave_dt` text COLLATE utf8mb4_unicode_ci,
  `usuario_defontana` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clave_defontana` text COLLATE utf8mb4_unicode_ci,
  `usuario_nubox` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clave_nubox` text COLLATE utf8mb4_unicode_ci,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `numero_cuenta` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banco_id` bigint(20) unsigned DEFAULT NULL,
  `tipo_ingreso_banco` enum('web','api','archivo','manual') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usuario_banco` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clave_us_banco` text COLLATE utf8mb4_unicode_ci,
  `banco_id_2` bigint(20) unsigned DEFAULT NULL,
  `numero_cuenta_2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipo_ingreso_banco_2` enum('web','api','archivo','manual') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usuario_banco_2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clave_us_banco_2` text COLLATE utf8mb4_unicode_ci,
  `banco_id_3` bigint(20) unsigned DEFAULT NULL,
  `numero_cuenta_3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipo_ingreso_banco_3` enum('web','api','archivo','manual') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usuario_banco_3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clave_us_banco_3` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `clientes_rut_empresa_unique` (`rut_empresa`),
  KEY `clientes_grupo_empresa_id_foreign` (`grupo_empresa_id`),
  KEY `clientes_software_id_foreign` (`software_id`),
  KEY `clientes_banco_id_foreign` (`banco_id`),
  KEY `clientes_banco_id_2_foreign` (`banco_id_2`),
  KEY `clientes_banco_id_3_foreign` (`banco_id_3`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `control_gestion_mensual`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `control_gestion_mensual` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cliente_id` bigint(20) unsigned DEFAULT NULL,
  `grupo_empresa_id` bigint(20) unsigned DEFAULT NULL,
  `periodo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Formato MM-YYYY',
  `compras_ventas_id` bigint(20) unsigned DEFAULT NULL,
  `formulario_29_id` bigint(20) unsigned DEFAULT NULL,
  `centralizacion_impuesto_id` bigint(20) unsigned DEFAULT NULL,
  `est_sueldos_id` bigint(20) unsigned DEFAULT NULL,
  `imposiciones_previsionales_id` bigint(20) unsigned DEFAULT NULL,
  `certificados_laborales_id` bigint(20) unsigned DEFAULT NULL,
  `libro_electronico_remuneraciones_id` bigint(20) unsigned DEFAULT NULL,
  `despidos_mes_id` bigint(20) unsigned DEFAULT NULL,
  `registro_electronico_dt_id` bigint(20) unsigned DEFAULT NULL,
  `archivo_dig_cont_anex_otros_id` bigint(20) unsigned DEFAULT NULL,
  `mora_presuntas_id` bigint(20) unsigned DEFAULT NULL,
  `deudas_fiscales_id` bigint(20) unsigned DEFAULT NULL,
  `conciliacion_bancaria_id` bigint(20) unsigned DEFAULT NULL,
  `balance_mensual_id` bigint(20) unsigned DEFAULT NULL,
  `analisis_cuentas_id` bigint(20) unsigned DEFAULT NULL,
  `folio_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `monto_peso_cm` decimal(15,0) DEFAULT '0',
  `fecha_venc_form29_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fecha_declara_en_plazo_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fecha_pago_f_p_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `multa_acum_clp_cm` decimal(15,0) DEFAULT '0',
  `total_pagado_clp_cm` decimal(15,0) DEFAULT '0',
  `iva_post_clp_cm` decimal(15,0) DEFAULT '0',
  `fecha_venc_iva_post_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fecha_pago_iva_post_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `multa_iva_post_clp_cm` decimal(15,0) DEFAULT '0',
  `hh_compra_venta_iva_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `monto_impo_cm` decimal(15,0) DEFAULT '0',
  `fecha_venc_impo_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fecha_pago_impo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `multa_impo_clp_cm` decimal(15,0) DEFAULT '0',
  `total_pagado_clp_impo_cm` decimal(15,0) DEFAULT '0',
  `hh_impo_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hh_deuda_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hh_banco_balance_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_hh_mes_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hh_asignada_mes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diferencia_hh_mes_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valor_servicio_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valor_hh_cm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_cliente_periodo` (`cliente_id`,`periodo`),
  KEY `control_gestion_mensual_grupo_empresa_id_foreign` (`grupo_empresa_id`),
  KEY `cgm_compras_ventas_fk` (`compras_ventas_id`),
  KEY `cgm_formulario_29_fk` (`formulario_29_id`),
  KEY `cgm_centralizacion_fk` (`centralizacion_impuesto_id`),
  KEY `cgm_sueldos_fk` (`est_sueldos_id`),
  KEY `cgm_imposiciones_fk` (`imposiciones_previsionales_id`),
  KEY `cgm_certificados_fk` (`certificados_laborales_id`),
  KEY `cgm_lre_fk` (`libro_electronico_remuneraciones_id`),
  KEY `cgm_despidos_fk` (`despidos_mes_id`),
  KEY `cgm_reg_dt_fk` (`registro_electronico_dt_id`),
  KEY `cgm_archivo_fk` (`archivo_dig_cont_anex_otros_id`),
  KEY `cgm_mora_fk` (`mora_presuntas_id`),
  KEY `cgm_deudas_fk` (`deudas_fiscales_id`),
  KEY `cgm_conciliacion_fk` (`conciliacion_bancaria_id`),
  KEY `cgm_balance_fk` (`balance_mensual_id`),
  KEY `cgm_analisis_fk` (`analisis_cuentas_id`),
  KEY `control_gestion_mensual_periodo_index` (`periodo`),
  KEY `control_gestion_mensual_cliente_id_periodo_index` (`cliente_id`,`periodo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `estados`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estados` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `tipo_estado_id` bigint(20) unsigned DEFAULT NULL,
  `tipo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'gray',
  `orden` int(11) NOT NULL DEFAULT '0',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `estados_parent_id_foreign` (`parent_id`),
  KEY `estados_tipo_estado_id_foreign` (`tipo_estado_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `grupos_empresa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `grupos_empresa` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` text COLLATE utf8mb4_unicode_ci,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `modulos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modulos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `orden` int(11) NOT NULL DEFAULT '0',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `modulos_slug_unique` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `softwares`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `softwares` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` text COLLATE utf8mb4_unicode_ci,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `tipos_estado`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipos_estado` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `modulo_id` bigint(20) unsigned NOT NULL,
  `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icono` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `orden` int(11) NOT NULL DEFAULT '0',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tipos_estado_slug_unique` (`slug`),
  KEY `tipos_estado_modulo_id_foreign` (`modulo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1,'2014_10_12_000000_create_users_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (2,'2014_10_12_100000_create_password_reset_tokens_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (3,'2019_08_19_000000_create_failed_jobs_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (4,'2019_12_14_000001_create_personal_access_tokens_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (5,'*_create_estados_table',2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (6,'2026_02_10_112313_add_parent_id_to_estados_table',3);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (7,'2026_02_10_114210_create_modulos_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (8,'2026_02_10_114216_create_tipos_estado_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (9,'2026_02_10_114225_modify_estados_table_add_tipo_estado_id',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (10,'2026_02_10_150253_create_grupos_empresa_table',5);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (11,'2026_02_10_150302_create_softwares_table',5);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (12,'2026_02_10_150310_create_bancos_table',5);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (16,'2026_02_10_150317_create_clientes_table',6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (17,'2026_02_10_161458_create_banco_cliente_table',6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (18,'2026_02_10_163118_add_numero_cuenta_to_clientes_table',7);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (19,'2026_02_10_163903_restore_banco_columns_to_clientes',8);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (20,'2026_02_10_180926_add_empresa_sii_fields_to_clientes',9);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (22,'2026_02_10_181731_create_cliente_banco_table',10);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (23,'2026_02_10_182434_add_segundo_banco_to_clientes',10);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (25,'2026_02_10_183243_add_tercer_banco_to_clientes',11);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (26,'2026_02_11_000001_create_control_gestion_mensual_table',12);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (27,'2026_02_11_000002_add_unique_cliente_periodo_index',12);
