/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19-11.8.6-MariaDB, for debian-linux-gnu (aarch64) -- -- Host: localhost Database: firefly -- ------------------------------------------------------ -- Server version 11.8.6-MariaDB-ubu2404 /*!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 utf8mb4 */; /*!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' */; /*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */; -- -- Table structure for table `2fa_tokens` -- DROP TABLE IF EXISTS `2fa_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `2fa_tokens` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL, `expires_at` datetime NOT NULL, `token` varchar(64) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `2fa_tokens_token_unique` (`token`), KEY `2fa_tokens_user_id_foreign` (`user_id`), CONSTRAINT `2fa_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `2fa_tokens` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `2fa_tokens` WRITE; /*!40000 ALTER TABLE `2fa_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `2fa_tokens` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `account_balances` -- DROP TABLE IF EXISTS `account_balances`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `account_balances` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `title` varchar(100) DEFAULT NULL, `account_id` int(10) unsigned NOT NULL, `transaction_currency_id` int(10) unsigned NOT NULL, `date` date DEFAULT NULL, `date_tz` varchar(50) DEFAULT NULL, `transaction_journal_id` int(10) unsigned DEFAULT NULL, `balance` decimal(32,12) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_account_currency` (`account_id`,`transaction_currency_id`,`transaction_journal_id`,`date`,`title`), KEY `account_balances_transaction_journal_id_foreign` (`transaction_journal_id`), KEY `account_balances_transaction_currency_id_foreign` (`transaction_currency_id`), CONSTRAINT `account_balances_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, CONSTRAINT `account_balances_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, CONSTRAINT `account_balances_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_balances` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `account_balances` WRITE; /*!40000 ALTER TABLE `account_balances` DISABLE KEYS */; /*!40000 ALTER TABLE `account_balances` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `account_meta` -- DROP TABLE IF EXISTS `account_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `account_meta` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `account_id` int(10) unsigned NOT NULL, `name` varchar(191) NOT NULL, `data` text NOT NULL, PRIMARY KEY (`id`), KEY `account_meta_account_id_index` (`account_id`), CONSTRAINT `account_meta_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_meta` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `account_meta` WRITE; /*!40000 ALTER TABLE `account_meta` DISABLE KEYS */; INSERT INTO `account_meta` VALUES (1,'2026-03-05 23:02:04','2026-03-05 23:02:04',1,'account_role','\"defaultAsset\"'), (2,'2026-03-05 23:02:04','2026-03-05 23:02:04',1,'currency_id','\"1\"'), (3,'2026-03-05 23:02:04','2026-03-05 23:02:04',2,'account_role','\"savingAsset\"'), (4,'2026-03-05 23:02:04','2026-03-05 23:02:04',2,'currency_id','\"1\"'), (5,'2026-03-05 23:02:04','2026-03-05 23:02:04',3,'account_role','\"cashWalletAsset\"'), (6,'2026-03-05 23:02:04','2026-03-05 23:02:04',3,'currency_id','\"1\"'), (7,'2026-03-05 23:23:30','2026-03-05 23:23:30',4,'BIC','\"\"'), (8,'2026-03-05 23:23:30','2026-03-05 23:23:30',4,'account_number','\"\"'), (9,'2026-03-05 23:23:30','2026-03-05 23:23:30',5,'BIC','\"\"'), (10,'2026-03-05 23:23:30','2026-03-05 23:23:30',5,'account_number','\"\"'), (11,'2026-03-05 23:23:30','2026-03-05 23:23:30',6,'BIC','\"\"'), (12,'2026-03-05 23:23:30','2026-03-05 23:23:30',6,'account_number','\"\"'), (13,'2026-03-05 23:23:31','2026-03-05 23:23:31',7,'BIC','\"\"'), (14,'2026-03-05 23:23:31','2026-03-05 23:23:31',7,'account_number','\"\"'), (15,'2026-03-05 23:23:31','2026-03-05 23:23:31',8,'BIC','\"\"'), (16,'2026-03-05 23:23:31','2026-03-05 23:23:31',8,'account_number','\"\"'), (17,'2026-03-05 23:23:31','2026-03-05 23:23:31',9,'BIC','\"\"'), (18,'2026-03-05 23:23:31','2026-03-05 23:23:31',9,'account_number','\"\"'), (19,'2026-03-05 23:23:31','2026-03-05 23:23:31',10,'BIC','\"\"'), (20,'2026-03-05 23:23:31','2026-03-05 23:23:31',10,'account_number','\"\"'), (21,'2026-03-05 23:23:31','2026-03-05 23:23:31',11,'BIC','\"\"'), (22,'2026-03-05 23:23:31','2026-03-05 23:23:31',11,'account_number','\"\"'), (23,'2026-03-05 23:23:31','2026-03-05 23:23:31',12,'BIC','\"\"'), (24,'2026-03-05 23:23:31','2026-03-05 23:23:31',12,'account_number','\"\"'), (25,'2026-03-05 23:30:40','2026-03-05 23:30:40',13,'BIC','\"\"'), (26,'2026-03-05 23:30:40','2026-03-05 23:30:40',13,'account_number','\"\"'), (27,'2026-03-05 23:30:40','2026-03-05 23:30:40',14,'BIC','\"\"'), (28,'2026-03-05 23:30:40','2026-03-05 23:30:40',14,'account_number','\"\"'), (29,'2026-03-05 23:30:40','2026-03-05 23:30:40',15,'BIC','\"\"'), (30,'2026-03-05 23:30:40','2026-03-05 23:30:40',15,'account_number','\"\"'), (31,'2026-03-05 23:30:40','2026-03-05 23:30:40',16,'BIC','\"\"'), (32,'2026-03-05 23:30:40','2026-03-05 23:30:40',16,'account_number','\"\"'), (33,'2026-03-05 23:30:40','2026-03-05 23:30:40',17,'BIC','\"\"'), (34,'2026-03-05 23:30:40','2026-03-05 23:30:40',17,'account_number','\"\"'), (35,'2026-03-05 23:30:41','2026-03-05 23:30:41',18,'BIC','\"\"'), (36,'2026-03-05 23:30:41','2026-03-05 23:30:41',18,'account_number','\"\"'), (37,'2026-03-05 23:30:41','2026-03-05 23:30:41',19,'BIC','\"\"'), (38,'2026-03-05 23:30:41','2026-03-05 23:30:41',19,'account_number','\"\"'), (39,'2026-03-05 23:30:41','2026-03-05 23:30:41',20,'BIC','\"\"'), (40,'2026-03-05 23:30:41','2026-03-05 23:30:41',20,'account_number','\"\"'); /*!40000 ALTER TABLE `account_meta` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `account_piggy_bank` -- DROP TABLE IF EXISTS `account_piggy_bank`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `account_piggy_bank` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(10) unsigned NOT NULL, `piggy_bank_id` int(10) unsigned NOT NULL, `current_amount` decimal(32,12) NOT NULL DEFAULT 0.000000000000, `native_current_amount` decimal(32,12) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_piggy_save` (`account_id`,`piggy_bank_id`), KEY `account_piggy_bank_piggy_bank_id_foreign` (`piggy_bank_id`), CONSTRAINT `account_piggy_bank_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, CONSTRAINT `account_piggy_bank_piggy_bank_id_foreign` FOREIGN KEY (`piggy_bank_id`) REFERENCES `piggy_banks` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_piggy_bank` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `account_piggy_bank` WRITE; /*!40000 ALTER TABLE `account_piggy_bank` DISABLE KEYS */; /*!40000 ALTER TABLE `account_piggy_bank` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `account_types` -- DROP TABLE IF EXISTS `account_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `account_types` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `type` varchar(50) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `account_types_type_unique` (`type`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_types` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `account_types` WRITE; /*!40000 ALTER TABLE `account_types` DISABLE KEYS */; INSERT INTO `account_types` VALUES (1,'2026-03-05 22:12:26','2026-03-05 22:12:26','Asset account'), (2,'2026-03-05 22:12:26','2026-03-05 22:12:26','Beneficiary account'), (3,'2026-03-05 22:12:26','2026-03-05 22:12:26','Cash account'), (4,'2026-03-05 22:12:26','2026-03-05 22:12:26','Credit card'), (5,'2026-03-05 22:12:26','2026-03-05 22:12:26','Debt'), (6,'2026-03-05 22:12:26','2026-03-05 22:12:26','Default account'), (7,'2026-03-05 22:12:26','2026-03-05 22:12:26','Expense account'), (8,'2026-03-05 22:12:26','2026-03-05 22:12:26','Import account'), (9,'2026-03-05 22:12:26','2026-03-05 22:12:26','Initial balance account'), (10,'2026-03-05 22:12:26','2026-03-05 22:12:26','Liability credit account'), (11,'2026-03-05 22:12:26','2026-03-05 22:12:26','Loan'), (12,'2026-03-05 22:12:26','2026-03-05 22:12:26','Mortgage'), (13,'2026-03-05 22:12:26','2026-03-05 22:12:26','Reconciliation account'), (14,'2026-03-05 22:12:26','2026-03-05 22:12:26','Revenue account'); /*!40000 ALTER TABLE `account_types` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `accounts` -- DROP TABLE IF EXISTS `accounts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `accounts` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `account_type_id` int(10) unsigned NOT NULL, `name` varchar(1024) NOT NULL, `virtual_balance` decimal(32,12) DEFAULT NULL, `iban` varchar(255) DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `encrypted` tinyint(1) NOT NULL DEFAULT 0, `order` int(10) unsigned NOT NULL DEFAULT 0, `native_virtual_balance` decimal(32,12) DEFAULT NULL, PRIMARY KEY (`id`), KEY `accounts_user_id_index` (`user_id`), KEY `accounts_user_group_id_index` (`user_group_id`), KEY `accounts_account_type_id_index` (`account_type_id`), CONSTRAINT `accounts_account_type_id_foreign` FOREIGN KEY (`account_type_id`) REFERENCES `account_types` (`id`) ON DELETE CASCADE, CONSTRAINT `accounts_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accounts` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `accounts` WRITE; /*!40000 ALTER TABLE `accounts` DISABLE KEYS */; INSERT INTO `accounts` VALUES (1,'2026-03-05 23:02:04','2026-03-05 23:02:37',NULL,1,1,1,'BMO',0.000000000000,NULL,1,0,1,NULL), (2,'2026-03-05 23:02:04','2026-03-05 23:02:37',NULL,1,1,1,'BMO savings account',0.000000000000,NULL,1,0,2,NULL), (3,'2026-03-05 23:02:04','2026-03-05 23:02:04',NULL,1,1,1,'Cash wallet',0.000000000000,NULL,1,0,3,NULL), (4,'2026-03-05 23:23:30','2026-03-05 23:30:41',NULL,1,1,14,'Adobe',NULL,NULL,1,0,0,NULL), (5,'2026-03-05 23:23:30','2026-03-05 23:30:41',NULL,1,1,14,'KPN Phone Provider',NULL,NULL,1,0,0,NULL), (6,'2026-03-05 23:23:30','2026-03-05 23:30:41',NULL,1,1,14,'Taxes and Revenues Government service',NULL,NULL,1,0,0,NULL), (7,'2026-03-05 23:23:31','2026-03-05 23:30:41',NULL,1,1,7,'Alibaba',NULL,NULL,1,0,0,NULL), (8,'2026-03-05 23:23:31','2026-03-05 23:30:41',NULL,1,1,7,'amazon.com',NULL,NULL,1,0,0,NULL), (9,'2026-03-05 23:23:31','2026-03-05 23:30:41',NULL,1,1,7,'iCentre Mac Store',NULL,NULL,1,0,0,NULL), (10,'2026-03-05 23:23:31','2026-03-05 23:30:41',NULL,1,1,7,'Jumper Pet Food Store',NULL,NULL,1,0,0,NULL), (11,'2026-03-05 23:23:31','2026-03-05 23:30:41',NULL,1,1,7,'Cafe Central',NULL,NULL,1,0,0,NULL), (12,'2026-03-05 23:23:31','2026-03-05 23:30:41',NULL,1,1,7,'Student Loan Organization',NULL,NULL,1,0,0,NULL), (13,'2026-03-05 23:30:40','2026-03-05 23:30:41',NULL,1,1,7,'Baker Bob',NULL,NULL,1,0,0,NULL), (14,'2026-03-05 23:30:40','2026-03-05 23:30:41',NULL,1,1,7,'Buy and Large',NULL,NULL,1,0,0,NULL), (15,'2026-03-05 23:30:40','2026-03-05 23:30:41',NULL,1,1,7,'Halfords Car Parts',NULL,NULL,1,0,0,NULL), (16,'2026-03-05 23:30:40','2026-03-05 23:30:41',NULL,1,1,7,'McDonalds',NULL,NULL,1,0,0,NULL), (17,'2026-03-05 23:30:40','2026-03-05 23:30:41',NULL,1,1,7,'SuperMarket',NULL,NULL,1,0,0,NULL), (18,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,'XS4All ISP',NULL,NULL,1,0,0,NULL), (19,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,'The Water Company',NULL,NULL,1,0,0,NULL), (20,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,'Shell',NULL,NULL,1,0,0,NULL); /*!40000 ALTER TABLE `accounts` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `attachments` -- DROP TABLE IF EXISTS `attachments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `attachments` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `attachable_id` int(10) unsigned NOT NULL, `attachable_type` varchar(255) NOT NULL, `md5` varchar(128) NOT NULL, `filename` varchar(1024) NOT NULL, `title` varchar(1024) DEFAULT NULL, `description` text DEFAULT NULL, `mime` varchar(1024) NOT NULL, `size` int(10) unsigned NOT NULL, `uploaded` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), KEY `attachments_user_id_foreign` (`user_id`), KEY `attachments_to_ugi` (`user_group_id`), CONSTRAINT `attachments_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `attachments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attachments` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `attachments` WRITE; /*!40000 ALTER TABLE `attachments` DISABLE KEYS */; /*!40000 ALTER TABLE `attachments` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `audit_log_entries` -- DROP TABLE IF EXISTS `audit_log_entries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `audit_log_entries` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `auditable_id` int(10) unsigned NOT NULL, `auditable_type` varchar(191) NOT NULL, `changer_id` int(10) unsigned NOT NULL, `changer_type` varchar(191) NOT NULL, `action` varchar(255) NOT NULL, `before` text DEFAULT NULL, `after` text DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `audit_log_entries` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `audit_log_entries` WRITE; /*!40000 ALTER TABLE `audit_log_entries` DISABLE KEYS */; /*!40000 ALTER TABLE `audit_log_entries` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `auto_budgets` -- DROP TABLE IF EXISTS `auto_budgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `auto_budgets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `budget_id` int(10) unsigned NOT NULL, `transaction_currency_id` int(10) unsigned NOT NULL, `auto_budget_type` tinyint(3) unsigned NOT NULL DEFAULT 1, `amount` decimal(32,12) NOT NULL, `period` varchar(50) NOT NULL, `native_amount` decimal(32,12) DEFAULT NULL, PRIMARY KEY (`id`), KEY `auto_budgets_transaction_currency_id_foreign` (`transaction_currency_id`), KEY `auto_budgets_budget_id_foreign` (`budget_id`), CONSTRAINT `auto_budgets_budget_id_foreign` FOREIGN KEY (`budget_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE, CONSTRAINT `auto_budgets_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auto_budgets` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `auto_budgets` WRITE; /*!40000 ALTER TABLE `auto_budgets` DISABLE KEYS */; /*!40000 ALTER TABLE `auto_budgets` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `available_budgets` -- DROP TABLE IF EXISTS `available_budgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `available_budgets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `transaction_currency_id` int(10) unsigned NOT NULL, `amount` decimal(32,12) NOT NULL, `start_date` date NOT NULL, `start_date_tz` varchar(50) DEFAULT NULL, `end_date` date NOT NULL, `end_date_tz` varchar(50) DEFAULT NULL, `native_amount` decimal(32,12) DEFAULT NULL, PRIMARY KEY (`id`), KEY `available_budgets_transaction_currency_id_foreign` (`transaction_currency_id`), KEY `available_budgets_user_id_foreign` (`user_id`), KEY `available_budgets_to_ugi` (`user_group_id`), CONSTRAINT `available_budgets_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `available_budgets_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, CONSTRAINT `available_budgets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `available_budgets` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `available_budgets` WRITE; /*!40000 ALTER TABLE `available_budgets` DISABLE KEYS */; /*!40000 ALTER TABLE `available_budgets` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `bills` -- DROP TABLE IF EXISTS `bills`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `bills` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `transaction_currency_id` int(10) unsigned DEFAULT NULL, `name` varchar(1024) NOT NULL, `match` varchar(1024) NOT NULL, `amount_min` decimal(32,12) NOT NULL, `amount_max` decimal(32,12) NOT NULL, `date` date NOT NULL, `date_tz` varchar(50) DEFAULT NULL, `end_date` date DEFAULT NULL, `end_date_tz` varchar(50) DEFAULT NULL, `extension_date` date DEFAULT NULL, `extension_date_tz` varchar(50) DEFAULT NULL, `repeat_freq` varchar(30) NOT NULL, `skip` smallint(5) unsigned NOT NULL DEFAULT 0, `automatch` tinyint(1) NOT NULL DEFAULT 1, `active` tinyint(1) NOT NULL DEFAULT 1, `name_encrypted` tinyint(1) NOT NULL DEFAULT 0, `match_encrypted` tinyint(1) NOT NULL DEFAULT 0, `order` int(10) unsigned NOT NULL DEFAULT 0, `native_amount_min` decimal(32,12) DEFAULT NULL, `native_amount_max` decimal(32,12) DEFAULT NULL, PRIMARY KEY (`id`), KEY `bills_user_id_foreign` (`user_id`), KEY `bills_transaction_currency_id_foreign` (`transaction_currency_id`), KEY `bills_to_ugi` (`user_group_id`), CONSTRAINT `bills_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `bills_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE SET NULL, CONSTRAINT `bills_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bills` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `bills` WRITE; /*!40000 ALTER TABLE `bills` DISABLE KEYS */; /*!40000 ALTER TABLE `bills` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `budget_limits` -- DROP TABLE IF EXISTS `budget_limits`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `budget_limits` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `budget_id` int(10) unsigned NOT NULL, `transaction_currency_id` int(10) unsigned DEFAULT NULL, `start_date` date NOT NULL, `start_date_tz` varchar(50) DEFAULT NULL, `end_date` date DEFAULT NULL, `end_date_tz` varchar(50) DEFAULT NULL, `amount` decimal(32,12) NOT NULL, `period` varchar(12) DEFAULT NULL, `generated` tinyint(1) NOT NULL DEFAULT 0, `native_amount` decimal(32,12) DEFAULT NULL, PRIMARY KEY (`id`), KEY `budget_limits_budget_id_foreign` (`budget_id`), KEY `budget_limits_transaction_currency_id_foreign` (`transaction_currency_id`), CONSTRAINT `budget_limits_budget_id_foreign` FOREIGN KEY (`budget_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE, CONSTRAINT `budget_limits_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `budget_limits` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `budget_limits` WRITE; /*!40000 ALTER TABLE `budget_limits` DISABLE KEYS */; /*!40000 ALTER TABLE `budget_limits` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `budget_transaction` -- DROP TABLE IF EXISTS `budget_transaction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `budget_transaction` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `budget_id` int(10) unsigned NOT NULL, `transaction_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `budget_transaction_budget_id_foreign` (`budget_id`), KEY `budget_transaction_transaction_id_foreign` (`transaction_id`), CONSTRAINT `budget_transaction_budget_id_foreign` FOREIGN KEY (`budget_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE, CONSTRAINT `budget_transaction_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `budget_transaction` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `budget_transaction` WRITE; /*!40000 ALTER TABLE `budget_transaction` DISABLE KEYS */; /*!40000 ALTER TABLE `budget_transaction` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `budget_transaction_journal` -- DROP TABLE IF EXISTS `budget_transaction_journal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `budget_transaction_journal` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `budget_id` int(10) unsigned NOT NULL, `budget_limit_id` int(10) unsigned DEFAULT NULL, `transaction_journal_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `budget_transaction_journal_budget_id_foreign` (`budget_id`), KEY `budget_transaction_journal_transaction_journal_id_foreign` (`transaction_journal_id`), KEY `budget_id_foreign` (`budget_limit_id`), CONSTRAINT `budget_id_foreign` FOREIGN KEY (`budget_limit_id`) REFERENCES `budget_limits` (`id`) ON DELETE SET NULL, CONSTRAINT `budget_transaction_journal_budget_id_foreign` FOREIGN KEY (`budget_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE, CONSTRAINT `budget_transaction_journal_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `budget_transaction_journal` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `budget_transaction_journal` WRITE; /*!40000 ALTER TABLE `budget_transaction_journal` DISABLE KEYS */; INSERT INTO `budget_transaction_journal` VALUES (1,1,NULL,10), (2,3,NULL,11), (3,3,NULL,12), (4,1,NULL,13), (5,2,NULL,14), (6,1,NULL,15), (7,2,NULL,16), (8,2,NULL,17), (9,2,NULL,18), (10,1,NULL,19), (11,4,NULL,20), (12,1,NULL,21), (13,3,NULL,22), (14,3,NULL,23); /*!40000 ALTER TABLE `budget_transaction_journal` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `budgets` -- DROP TABLE IF EXISTS `budgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `budgets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(1024) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `encrypted` tinyint(1) NOT NULL DEFAULT 0, `order` mediumint(8) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `budgets_user_id_index` (`user_id`), KEY `budgets_user_group_id_index` (`user_group_id`), CONSTRAINT `budgets_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `budgets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `budgets` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `budgets` WRITE; /*!40000 ALTER TABLE `budgets` DISABLE KEYS */; INSERT INTO `budgets` VALUES (1,'2026-03-05 23:27:42','2026-03-05 23:27:42',NULL,1,1,'Groceries',1,0,1), (2,'2026-03-05 23:28:23','2026-03-05 23:28:23',NULL,1,1,'Bills',1,0,2), (3,'2026-03-05 23:28:28','2026-03-05 23:28:28',NULL,1,1,'Car',1,0,3), (4,'2026-03-05 23:28:43','2026-03-05 23:28:43',NULL,1,1,'Going out',1,0,4); /*!40000 ALTER TABLE `budgets` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(1024) NOT NULL, `encrypted` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `categories_user_id_index` (`user_id`), KEY `categories_user_group_id_index` (`user_group_id`), CONSTRAINT `categories_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` VALUES (1,'2026-03-05 23:23:30','2026-03-05 23:23:30',NULL,1,1,'Reimbursements',0), (2,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,'Internet',0), (3,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,'Electronics',0), (4,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,'Cats',0), (5,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,'Drinks',0), (6,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,'Student loans',0), (7,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,'Daily Groceries',0), (8,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,'Car',0), (9,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,'Junk food',0), (10,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,'House',0), (11,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,'Going out',0); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `category_transaction` -- DROP TABLE IF EXISTS `category_transaction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `category_transaction` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `category_id` int(10) unsigned NOT NULL, `transaction_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `category_transaction_category_id_foreign` (`category_id`), KEY `category_transaction_transaction_id_foreign` (`transaction_id`), CONSTRAINT `category_transaction_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `category_transaction_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_transaction` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `category_transaction` WRITE; /*!40000 ALTER TABLE `category_transaction` DISABLE KEYS */; /*!40000 ALTER TABLE `category_transaction` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `category_transaction_journal` -- DROP TABLE IF EXISTS `category_transaction_journal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `category_transaction_journal` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `category_id` int(10) unsigned NOT NULL, `transaction_journal_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `category_transaction_journal_category_id_foreign` (`category_id`), KEY `category_transaction_journal_transaction_journal_id_index` (`transaction_journal_id`), CONSTRAINT `category_transaction_journal_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `category_transaction_journal_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_transaction_journal` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `category_transaction_journal` WRITE; /*!40000 ALTER TABLE `category_transaction_journal` DISABLE KEYS */; INSERT INTO `category_transaction_journal` VALUES (1,1,1), (2,1,2), (3,1,3), (4,2,4), (5,2,5), (6,3,6), (7,4,7), (8,5,8), (9,6,9), (10,7,10), (11,8,11), (12,8,12), (13,9,13), (14,6,14), (15,7,15), (16,2,16), (17,6,17), (18,10,18), (19,7,19), (20,11,20), (21,7,21), (22,8,22), (23,8,23); /*!40000 ALTER TABLE `category_transaction_journal` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `configuration` -- DROP TABLE IF EXISTS `configuration`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `configuration` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `name` varchar(50) NOT NULL, `data` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `configuration` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `configuration` WRITE; /*!40000 ALTER TABLE `configuration` DISABLE KEYS */; INSERT INTO `configuration` VALUES (1,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'db_version','1'), (2,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_accounts','true'), (3,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_attachments','true'), (4,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_bills','true'), (5,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_budgets','true'), (6,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_categories','true'), (7,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_piggy_banks','true'), (8,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_preferences','true'), (9,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_tags','true'), (10,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_transaction_journals','true'), (11,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_transactions','true'), (12,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'is_decrypted_journal_links','true'), (13,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_transaction_identifier','true'), (14,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_migrated_to_groups','true'), (15,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_account_currencies','true'), (16,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_transfer_currencies','true'), (17,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_other_currencies','true'), (18,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_migrate_notes','true'), (19,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_migrate_attachments','true'), (20,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_bills_to_rules','true'), (21,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_bl_currency','true'), (22,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_cc_liabilities','true'), (23,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_back_to_journals','true'), (24,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'480_rename_account_meta','true'), (25,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'481_migrate_recurrence_meta','true'), (26,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'500_migrate_tag_locations','true'), (27,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'560_upgrade_liabilities','true'), (28,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'600_upgrade_liabilities','true'), (29,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'550_budget_limit_periods','true'), (30,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'610_migrate_rule_actions','true'), (31,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'610_correct_balances','true'), (32,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'use_running_balance','true'), (33,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'610_upgrade_currency_prefs','true'), (34,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'620_make_multi_piggies','true'), (35,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'620_pc_amounts','true'), (36,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'enable_exchange_rates','false'), (37,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'640_upgrade_webhooks','true'), (38,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'oauth_private_key','\"eyJpdiI6InE1cGkzT2hEb2RTNjdydHc5VzhxVlE9PSIsInZhbHVlIjoiNkkxeENCUmtEUXhaZUtBVkltVCs3WkNXdmM0SmEySzRZdHE2d0VVbFhKckp6LzBqZ0pjanVXaXZ5ejE5NWdXbzNWZWRqRWs5U0owS0NCc01IcGdrVExLZWcwSkt6dll4Q0k0MDR5SVVQTXVPMEwwRXc3VnBRNVFXS09EMWRvT08yYUV1M0tOQitmMkdYSUpuRk5IOTlwSWpWUWhYdmcyWG85YklFY1U2MVFyN0ZveWNLWXc4Y2oyTHRuOGRvYjBsNHJUOGpVYVppam1FSXY0VE5jOG5PMFlJUHQxK1I0R3Qyb2lSVlB0RC9KNi8wNi90MnVwOFpiQ3NKSzZZT2pMaDBqdnovMzd3aGMrdEMvVUFvR25sU3FPa25ZMjRRZXpFRS92clVadUNKdkY2a0UwQXN2N0gxTmI2TkljYnBsaTY5UERpb2tKaWFrUW5WUkYvYTkrUy85cnViNklzckRST2tOa2xkZmZneWQwQlRjZERCTkVOSENNZS8yWWprTkNMN3czZXR0d1c4OGFLZkEzZmpCSTlJNGpxQ1RHNXNreVp6OEwzWHZJQVZ1Yk5WQ0ZTaGJCdzJ5ZzY2eHgwL0JCY2dQNXRlaWJqVlUwZTdHZEZwNnIwWFBtbGd5NGRJZ3FxYytzZ0JHaGk1dDVkT2NsS3RXZVhVM2dVTjNna05uTlBNdEN3L0NhdWkxYWRCQ0lTcE9FTGx6ZWVid0phOTRTWTV1OHRpa01pRGZtQ21tTkRZdm5EZVhHU1ZqOGhaalFIOVpPYXI3Qmh4TU1NUnFDN3crVDJNOFdHWGlVdlpPZCtDemYzWDdud2hQRDVabFNtOU84aGJXMTFsaU5MRklHRENMMzR5MHMyN0FURGV2U1RIVU9pMkRGbkVGdTFsOGdZSklaaWU5Y1hHN3VGQUtxUWdzTXZnbUVOR1ZycXVFbERoZFA2Wi8wZWRUeGNmdHhCOUdMd1c5NVhJVGxEZ3J4L2U4ZWVHUjFCN1dYNm1OeThOOVJNOEJDcGh1VjhOM1M3OE4rUWhnZmVIZU10QklnMmNVOC96M3J2TjNYcHFMSHR6aHkxN2tSMndkZ0k1UHorenY3SUtsUXh4MTBwb0YwSDBrOXRMakFBSUl6NURJN210RGJ0eW1HbGRCRndNKzVqOGhGb3lOa2ZMQlFmUXNGM3BxU0E1MnZMWlY1SG11VDFYV09aQ0E5V2I5MThHWk0rNkJCRUdwUFNsdDRXclU5ZXd3b2lEelBsTmJ1aC9uVXBYYzB3bXVhVzRnb3JSMndpNFg5WmlYRTlmZWx1MU5LNXR0eDVvcTBBNlk2bzhYRkxjTGo4NHEwSGZsL3VTV3lkSDgrR2xVTDZ6TkZsRzZtNUoxbS9zN01VL1BGVXU0Rkd5WmU1djFYK3JzYXlrcVZLazNPdC9NYVhmSU1PUTZmTStpdXQxWmdlMmY0V1FxOXB3WFN0djdhTW40a2xDNFZuSkhKcXhzTzVuNS83UEphYmNTOHI3MTNhakkxRlZDcjhwc21VSTdrZ213TWVJTU81enZYMzVvM0Z2VHZFaHF3MzlxaFU1ZmtXRGllWlFjSWFPcGdvdlZKWGhXeW12emVyRGFWcjNyRGh6YUxKT3JFaFEraFR1cmR0dEtDK2VTUUNJWC9VZ1E5NHZFUks3NlYvNkRxWmh0QWxEMVVmNExaalZ4RTNSU1cwa05ZNUduT3dyZzl4UHRsbWdraTRucWVtTHQ0L0RHaTEzZHRTTi9YQTF5V1ZMVU9BS3RTbXVDVFRKUThCTStSd0JscC9nQW5MNDE5VzcrWlFIMGYxR1Y0WTlJVmlDNVFNZVlSZkRlYnpoODc5ZEZURUkvcVV0ZEFMR3pNWng2dXZnVnVIaVlIS1ZlNXltYXZibVVSbWx3ZlM3RVo2WmthVFE1MTk2bTdvQkg5aUNUSEZrT2wyeTNVZ0U2bzhmRUpvVHJ5VnY1WHBjc0FrNTQ0N2hWelZXTWdiWnpmVURKdlBHK3J5U29EbW5QcmhmRzJYYlFaR2hIQmFYOG1XUGs0Z1dydHg0bFpJdFpRWmlyZnVKcnB5SnpzVTJXcjdLSFlUNkhmZEhMYStPb3NMYXZUVmRsVmc4emF4bk5IUjlrOTZhOUNmSlJUR21rdU9uOHpzdGFabFZhR1lTcHk0M1Q0US9YZ3UybE44T2U3UGE1OGg3Z09WRXlDUGdqejREakU3RHBUTUl0ZWxpQjVvQldFRWxvS01uSmNVSFB0SWxBRW9kbGdacitCd3Y3VDlYdnpNUUc2OENzMUlOYy9Wa2YyckJsSVRYbFpvamlxMm5LMmdXTFZFNDh4UEdMRDNrV2tEbStCUFdOcWIrbFpKZmJFaHpYbXFtSDE0c2dFVzNJQUV0TVpNVXp1ZHhxdjYzUFhGcUdhU0pSbzZ6N1YxTmYvRFpoYUg2L0ZUVmVwbE5TUTBMK1FBWktEakJmeWluME04RUpjd0kyVXNhem9FT1Bmd0Q3UU12NDcwM3NPMzlQVk90N1RDSFZhZ2JBRXRPb0FmV0J4MzhBZkNsaWpzTmtiT1N6L203SGJSRE1kMzM1K3V0bnZBVDBhZTd4L1lWTStYM1BnNkQxT3VPQ3JkTUVOSHJ6QWVmNFJiNUtsSTN1b2dTQ3hqSU9yV3Zia2tRNkwvMG5wUzNwL1RibkVDU1FSOVdhQWZhWHpRbUlvUHVQVTZFYnNOeGtpekxHb3NRdGtIdCtiV1AvaE9nZHM3bG5XMVZiMkhpdEUzSFVMcjV1QUFONFdZWm1JaG5zcFlTa3dVNzdhS1p5VDcrZlpxNmMrRG1ibFNoa0l0anBQS1JTb2UxMFRrSk4zQU1CVmY0SERqNTNmczhPdExldmdvYmo1cTVqL2xtRlVmWVZLa01RWWx2SC9qcjJrRytQYnU5RThTdFdsZlY0Si9uYnFTWWNqMnNXeGxRSm55a3hSak5Ic3FvVXlvc0hqZmNvc0oxVGUwVDV4SDk5bEtxVHBReEsyQmxHZ1dnU2IwZE5tZzR1VG8vMjFHLytpNjBxSURSeUUrTmpQS1cxR3lFZmROTzBobDVPY1Y3Y3JJWEcvQXJ5UFBnTm52dDl1MVJycVFFWGkveEs5NHI3UHFsT2svZGtmOWVYeDJyczE2elJUbnE4MnJ1RzBqTnRzMisvRk5HTHN1U2ZKNDBsdXVpV01rQjFjOENCRnFLT3NmNW1Xa3NaaUpjTGdzRCtZRmtCQnU0cjlLR2FScU1sbHhZdHZoZS9mdlM2NnZwN1paTGN3eklPc2dDSHl6aU5kQmQ2VVNYUUU3bmxKL0lHZGtHRVpxYWpMa0tmVVpFZFRQTmdBUW0zTmMwbGt3bXhOV0NrbGE2MlFNYTVjRzZWRkZvdVlPS1hmSE1zOGVuZzBLVXVFS3p1RVpSWnpNQ0FqQkZGdHVyalJvQmU1SnUrdUhDVnJtTERYTTRPMlo1MGpqK3p3RGo3R2JJQ054aSt1V1RMc3lrL3Ztdy9qUmdhWlpOM1h6clE0UHdkZDJPNFlvbkROaDloWS9kQi9rZlBZZUpsU1JKUUNvbHYzWnREOTE1amIvZjBSc1F4bTdqWjE2RFBMZ2VRNnNUUEowbjJhaG1IeXdES3lHTFB1ZFlXSzBvem9jaXl1NksrZFg4cDcyUGMvZWpHaklHOG9Sc3FoOExVVWwzZjN4YWgvcDVCcmVoRDd2Q0VTWTRtU0NPTmNWWlBiQWRCa2o2Qmo3S3ExZlNrbUJoRmdqQ3pRMVRTdFdFTm5RL2xiS2I3WmJPeUg0SEV3WlN3MHlIZ1hLWTk1dS9XTHp1VVlDand2WkF4WFJCNEUwcEo1dFptL0c0c1paL001cFRQbjdvcm1zZEpFMWVvWmVCL1E2YzJMMGFpbTBUcUFaY1YwQWNvYkpjbkNjamZvTjY5Zm5XNkJzQUR3VVZ0UjBJc1FCVjlJV2VyM2pVZ3RINE9XNithZkhtWUFlVjVyTko3NE1QYUxNT1lCRWJHZ2VwUXd4S0Q0WG5JcWN3eUpHNDlySHQzLzR3V0doZFpKRERqKzV4RHMydktNWnE2Q3dlbm1GMlhDVWRzTTlqanNmbGxUdjIrby8wMmh0NGhlY1MyM1pXUHdJdm42YXdDRTc5aHN0TDJSNU9pTXlCVmZvN0RtWHFWcHY2ZWg4NTRCZFlVZWxJNENWTmlDd2NhdlF3WTFFOTN5OTNJdDZsZmxrOW4yNlJNaEtIZHNPU3BhaUJ2SS8vYXpLUVZUMlJHL1F4Z0xUNy9QYUsrY3RIdWoreXRlR2h1TUdUL2ErWDFKSmx3SUx2R3A1ZEVIMWhIS3NWcXF1OVhuQTVPYTZ6dEljNEp2Ty9iTDgvMERhUjJqVTBUSWsweFpGMjdvZWIyYUIyeFR4REVLaEtONUswM1NvcWNaVE92SzRYNmRDazVBNWRDREN1OHdEUjVwUjRpSlVYelBsMlFtdnFSdHZZeWVXZWFtMmdJTGY2VWpJbHp3cFN5N0JTT3BYYnpZRlZhTnhscGVENWw0cy9jWEJSRThVTi9sZWtFODZFTFRZclJvaEJnTzBaSldiWENzc3plZ0lQUVgyckZ3ZVBvRVZ4MHZyM3FYZmhBQmY3dlRrUmpGOWlJOUpFU0NpbEtTWVAzSHhXR3ZoOUk4c0FLRzF6QVgwc3AydGRjekl0T0RmdXp1aFN0S2g4bm14M0dTOUJzUy9XekZnMWxRY0NPcTJ6SkFnQTdHanFENVphVlBxNkh0Tm5pR3B5VlhlYU9CdTI0SDNFRksrZ2dMUEFUUWt3S1YrQTRJSHhIbGk1ZzBmeVJhNUNzS1d3U2J2MHF5K2xuL2hVMmgxYWJtcUJBVHFoVnlCNUEzOGVkQ21UZlJtckYrOVBSSUtueXovcFJVWTc1QTJqWVBSandyemQzTVJxMHNURGtOOHFSUVRxc3huVjhuL1doY3BOY1BMOFU3cnlvejMyTEh4bGJnRHVERHhNdHFOckd6UmU4ZUZ1NkN3eENwcE9sL3p2ci85VlhyT2JYcVJTbGFVeUFiQm5UQklmcGF2TGhOUjNuR1NIcGUvbVNDTHR6bWZEL2dFMjZPTTZ4MldDT2JBblR0TkZZR2VVTnFJNVZqYjBNZzlPT0NYRkxRK0NSY1pkNkR1enpnQnhROXhZL2cxZmFNNzlUVHlSWVFrZkVjSDdEemVUYXc0bDRIWnhkanMzRXNYZ0dvdS95d1FGQnRHOTliTlJ4OW5rTTQyVTQ0eWU4anFMZC9Ma2RoTzV6RzNmOW51U2ZUOUUvcnZuUHJmQytsT0dZQXdldmd6OEh0OXNmZXl1SDFGZkNibXI5THduLzhCVkNwbkFUMkpTVkV4T3RMenQrc09vOGg2S0R3MkNRUTdiM25iS1VZZDhlTXZqRzdZRkd1aFppTmFPVzBYcDZnaWt6L20vZHB0UXhsZGlFa05mdHJiaHo5MGxUQW5Ta3lXcVk5VkIwcC9NcmpUVFEvWmZYYlgvTjlYV3RUNk44T1hOdGVUcU9HOFVoWWVURHRHanM4MGFWVzBWY1pYZ3NjNFp5YzgwT1pQYldKaEUrbnJqcDZvVDNsTzliSXBKSlBsRG9FVVhpOVZKbitteUlVRVczQ0NZWERKNVNRQldwTHU1REVMc0ZlNXYwNStmUkpodmlwYnRteDVwQ3FNZW8vVFNwcng4a1lucWcxbGZ6M0tqTmc1ZzNSamVuRDA0dzVNQkp5WkVEU3pML001dUZ0Z2VhYzB5UlhZQVFJWkxRM2s2ak9NajdGdXEzM0ZnWUZLSVg0aVVaUTcrWHZJSktWSFlKN3UzTTF5bzJXcnhUK3RCZGMwd0JlbTZMTlZqdHlmUkpFOVZwd3ZNZktWZDdodlRCVzdIb3FDL2pXSTdQY3o5eEJIaDA0VEl1WWtWWFQzQzlHRVpmYnh4dW5NODNPTHJIZFdtMnpObW5KNjZQMD0iLCJtYWMiOiI5YTNjYmQ4MjZjMzQwMWRhNTc4MmExMDI2ZDZhMjU4OGZmMDc0MTk2MjNlMDhjOTliM2QyNThjNTE2ZjkyOTkzIiwidGFnIjoiIn0=\"'), (39,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'oauth_public_key','\"eyJpdiI6InBCRjVUek1tRUhCQ1p5NkVsVEFyWEE9PSIsInZhbHVlIjoieHh1djB6Zit1QzdkWmoxdzdwTUJTNWRKdXNrVUwxcWwwb1FZVTh1eDNWaUdESWZ1RmdjRXNnWDB1YjJRb09yT0xOOWhDdmZEYTQ5czlPSXNsMG5IemRDWmxrSEIzbXU5VE5xUGtXV1hXQWpRd0dieUtBRmNKTGZPNXh6aW1JZkh5OFZhSWFSYUZxVG1FSk5qRHVHcjFzOGlDU1NBbExBcDkxYVBtM0JWZklqZDFGZS9pUmpKZjhURDZnY0JxMlFzWEg3TlFjeVprK0ZuZDNtWVJWdUltbHcyMlF1elhEdTkvdTQ2QnlCSVRGSkdxTzVLRjdzcTMrckNpY29kWWpVV21ZR3dTTTQ3L1d3YjNOd1BFNHZxaVZIZUROcFZKd0I2M0RMV1duT3dDN2cyRk5jbVFTeDFzeHlTaGNQd3NLWmpRaEFKU2dsTzhvVTNUSG5Fc1Z3a3UzdFdySnlMdFJKTEZxQjRtR2dwRGY4TVMxTitwMFpOaVFLWXJUeVlUUHllZmtnRlNEQXJaN0NxN2d0V05mWXAwN2YyUGJteHQ4Mm5Jd0FDQVVSbFRPc0c2akhQS1JyRFR0ZXVCZHQyVmpLYkNmMkpnN3c5TlBId0lNTStZVk9BaVRjaWJwdC9xcVJNWDl6MzlhZkNxUHkwcVpibUFOL2RDVkM4VHZ3RUZCUlEvTWhDdDNqNm1SUEJKSUFvc2FEZkI0bWVmUXE0NTVsVi9kRnNmN0RpMGtlblE0dDlrVnh2STZBWVFSUlJFNllXaEJOaEI3VFAyVGpBKy9jSERGS1ByQnBycHpQbEZlblFmN1FDVkdERW5iK0JuVTVUWjFrMEs3UkhIc3E2VXpRbjFzMDYvVjNLSmhGLzRTSjE2ZWVEOEVGQ0QrLzlwOTlqMzRMMm5EbUU5U3B2amtwVHZRUndybFF3ZzZsV08rQmVyS0o5czhFL014TlhhcmdRZTYwVHd1eVgyci9tQlpkbnc0bTZLYW41TmJRc3duZW5JKzJsWmVOS1BhTkovY3BBSGgvb3V5azVnTzVLWms2VjVsS3lOb2s0QkJEYnVQeEtQeFJuMDBvd2pNenZibkhHSjJvSjlDbXBHN3RDU0ltYzczWVc3anJFR3B3QWdpUWlibWtPTFJHdE9oNzNrMFRwZUl1ejZqNHByTG5xRk5acFpGaW1ZNjJzTFM1eTNwbWs4c21Hd2h6ZXdtcWRDVlczdWg0dzViSWlBRVZUVmhsQXFvWEsvNDZBNzdJK1crVWJtWGlFa1VzYkxIVUlzWlN1bUN3ODVIc0NVclVIUEJER2NKdE5idG4wZklXMWx1UlpJUXVMMHdSS2JkLzJ2cWRiWjJ0TlUzMUZsWWhTQlNCelJTYmw2QnJ1K1MxRlJMaFk2cGxWcDNhbXpvaDc5OVRydVppUkNlQUZraEdBeXpmTHRxSU94b3VCK05UdndCcGRhV2VndDM1NGI5Q29sWU8zY1g2NzFBPT0iLCJtYWMiOiI5YTBlYThmYzY0OTAwMjNiMjc3MDU2MmI1ZmVmNzAxZTI1NjZhYTMxYmVlZmVmYjIzNTZjY2Q5YzU2ZDk3YjZmIiwidGFnIjoiIn0=\"'), (40,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'utc','false'), (41,'2026-03-05 22:12:27','2026-03-05 22:12:27',NULL,'allow_webhooks','false'), (42,'2026-03-05 22:12:27','2026-03-05 22:12:27',NULL,'ff3_build_time','1772606967'), (43,'2026-03-05 22:12:28','2026-03-05 22:12:28',NULL,'installation_id','\"04764dfb-0151-4749-b336-670fb589c79b\"'), (44,'2026-03-05 22:13:01','2026-03-05 22:13:01',NULL,'is_demo_site','false'), (45,'2026-03-05 22:13:01','2026-03-05 22:13:01',NULL,'single_user_mode','true'), (46,'2026-03-05 22:30:27','2026-03-05 22:30:27',NULL,'notification_user_new_reg','true'), (47,'2026-03-05 22:30:27','2026-03-05 22:30:27',NULL,'notification_admin_new_reg','true'), (48,'2026-03-05 22:30:27','2026-03-05 22:30:27',NULL,'slack_webhook_url','\"\"'), (49,'2026-03-05 22:30:27','2026-03-05 22:30:27',NULL,'pushover_app_token','\"\"'), (50,'2026-03-05 22:30:27','2026-03-05 22:30:27',NULL,'pushover_user_token','\"\"'), (51,'2026-03-05 23:02:05','2026-03-05 23:02:05',NULL,'permission_update_check','-1'), (52,'2026-03-05 23:02:05','2026-03-05 23:02:05',NULL,'last_update_warning','1772748125'), (53,'2026-03-05 23:09:32','2026-03-05 23:09:32',NULL,'valid_url_protocols','\"http,https,ftp,ftps,mailto\"'), (54,'2026-03-05 23:23:30','2026-03-05 23:23:30',NULL,'enable_batch_processing','false'); /*!40000 ALTER TABLE `configuration` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `currency_exchange_rates` -- DROP TABLE IF EXISTS `currency_exchange_rates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `currency_exchange_rates` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `from_currency_id` int(10) unsigned NOT NULL, `to_currency_id` int(10) unsigned NOT NULL, `date` date NOT NULL, `date_tz` varchar(50) DEFAULT NULL, `rate` decimal(32,12) NOT NULL, `user_rate` decimal(32,12) DEFAULT NULL, PRIMARY KEY (`id`), KEY `currency_exchange_rates_user_id_foreign` (`user_id`), KEY `currency_exchange_rates_from_currency_id_foreign` (`from_currency_id`), KEY `currency_exchange_rates_to_currency_id_foreign` (`to_currency_id`), KEY `cer_to_ugi` (`user_group_id`), CONSTRAINT `cer_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `currency_exchange_rates_from_currency_id_foreign` FOREIGN KEY (`from_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, CONSTRAINT `currency_exchange_rates_to_currency_id_foreign` FOREIGN KEY (`to_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, CONSTRAINT `currency_exchange_rates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `currency_exchange_rates` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `currency_exchange_rates` WRITE; /*!40000 ALTER TABLE `currency_exchange_rates` DISABLE KEYS */; INSERT INTO `currency_exchange_rates` VALUES (1,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,1,'2025-04-15',NULL,1.000000000000,NULL), (2,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,2,'2025-04-15',NULL,410.797980000000,NULL), (3,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,3,'2025-04-15',NULL,0.860032610000,NULL), (4,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,4,'2025-04-15',NULL,46.867455000000,NULL), (5,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,5,'2025-04-15',NULL,4.280209800000,NULL), (6,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,6,'2025-04-15',NULL,43.180054000000,NULL), (7,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,7,'2025-04-15',NULL,7.459100000000,NULL), (8,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,11,'2025-04-15',NULL,7.464833600000,NULL), (9,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,12,'2025-04-15',NULL,1.134904400000,NULL), (10,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,13,'2025-04-15',NULL,6.645851800000,NULL), (11,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,14,'2025-04-15',NULL,1.575105000000,NULL), (12,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,15,'2025-04-15',NULL,22.805278000000,NULL), (13,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,21,'2025-04-15',NULL,19070.382000000000,NULL), (14,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,22,'2025-04-15',NULL,1.787202000000,NULL), (15,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,23,'2025-04-15',NULL,1.919107800000,NULL), (16,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,24,'2025-04-15',NULL,57.874172000000,NULL), (17,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,25,'2025-04-15',NULL,10.549438000000,NULL), (18,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,26,'2025-04-15',NULL,21.444356000000,NULL), (19,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,27,'2025-04-15',NULL,162.471950000000,NULL), (20,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,28,'2025-04-15',NULL,8.284997700000,NULL), (21,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,30,'2025-04-15',NULL,93.344230000000,NULL), (22,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,31,'2025-04-15',NULL,97.572815000000,NULL), (23,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,32,'2025-04-15',NULL,4.180178600000,NULL), (24,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,33,'2025-04-15',NULL,0.926831260000,NULL), (25,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,34,'2025-04-15',NULL,7.534500000000,NULL), (26,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,8,'2025-04-15',NULL,145.105320000000,NULL), (27,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,9,'2025-04-15',NULL,11.980824000000,NULL), (28,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,10,'2025-04-15',NULL,11.088090000000,NULL), (29,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,35,'2025-04-15',NULL,8.804632200000,NULL), (30,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,1,36,'2025-04-15',NULL,25.092213000000,NULL); /*!40000 ALTER TABLE `currency_exchange_rates` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(191) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `group_journals` -- DROP TABLE IF EXISTS `group_journals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `group_journals` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `transaction_group_id` int(10) unsigned NOT NULL, `transaction_journal_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_in_group` (`transaction_group_id`,`transaction_journal_id`), KEY `group_journals_transaction_journal_id_foreign` (`transaction_journal_id`), CONSTRAINT `group_journals_transaction_group_id_foreign` FOREIGN KEY (`transaction_group_id`) REFERENCES `transaction_groups` (`id`) ON DELETE CASCADE, CONSTRAINT `group_journals_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `group_journals` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `group_journals` WRITE; /*!40000 ALTER TABLE `group_journals` DISABLE KEYS */; /*!40000 ALTER TABLE `group_journals` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `group_memberships` -- DROP TABLE IF EXISTS `group_memberships`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `group_memberships` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned NOT NULL, `user_role_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `group_memberships_user_id_user_group_id_user_role_id_unique` (`user_id`,`user_group_id`,`user_role_id`), KEY `group_memberships_user_group_id_foreign` (`user_group_id`), KEY `group_memberships_user_role_id_foreign` (`user_role_id`), CONSTRAINT `group_memberships_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `group_memberships_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `group_memberships_user_role_id_foreign` FOREIGN KEY (`user_role_id`) REFERENCES `user_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `group_memberships` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `group_memberships` WRITE; /*!40000 ALTER TABLE `group_memberships` DISABLE KEYS */; INSERT INTO `group_memberships` VALUES (1,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,1,1,21); /*!40000 ALTER TABLE `group_memberships` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `invited_users` -- DROP TABLE IF EXISTS `invited_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `invited_users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `email` varchar(255) NOT NULL, `invite_code` varchar(64) NOT NULL, `expires` datetime NOT NULL, `expires_tz` varchar(50) DEFAULT NULL, `redeemed` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `invited_users_user_id_foreign` (`user_id`), CONSTRAINT `invited_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invited_users` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `invited_users` WRITE; /*!40000 ALTER TABLE `invited_users` DISABLE KEYS */; /*!40000 ALTER TABLE `invited_users` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(191) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `journal_links` -- DROP TABLE IF EXISTS `journal_links`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `journal_links` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `link_type_id` int(10) unsigned NOT NULL, `source_id` int(10) unsigned NOT NULL, `destination_id` int(10) unsigned NOT NULL, `comment` text DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `journal_links_link_type_id_source_id_destination_id_unique` (`link_type_id`,`source_id`,`destination_id`), KEY `journal_links_source_id_foreign` (`source_id`), KEY `journal_links_destination_id_foreign` (`destination_id`), CONSTRAINT `journal_links_destination_id_foreign` FOREIGN KEY (`destination_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE, CONSTRAINT `journal_links_link_type_id_foreign` FOREIGN KEY (`link_type_id`) REFERENCES `link_types` (`id`) ON DELETE CASCADE, CONSTRAINT `journal_links_source_id_foreign` FOREIGN KEY (`source_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `journal_links` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `journal_links` WRITE; /*!40000 ALTER TABLE `journal_links` DISABLE KEYS */; /*!40000 ALTER TABLE `journal_links` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `journal_meta` -- DROP TABLE IF EXISTS `journal_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `journal_meta` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `transaction_journal_id` int(10) unsigned NOT NULL, `name` varchar(255) NOT NULL, `data` text NOT NULL, `hash` varchar(64) NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `journal_meta_transaction_journal_id_index` (`transaction_journal_id`), KEY `journal_meta_data_index` (`data`(768)), KEY `journal_meta_name_index` (`name`), CONSTRAINT `journal_meta_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `journal_meta` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `journal_meta` WRITE; /*!40000 ALTER TABLE `journal_meta` DISABLE KEYS */; INSERT INTO `journal_meta` VALUES (1,'2026-03-05 23:23:30','2026-03-05 23:23:30',1,'import_hash_v2','\"dcf2e87d82ad4eefccc39f91879e5933836a02b4edcf98704729ea2245fd00ea\"','b242f71b054c863d2b67608baf7443c1116f3ce2d1eab30143fb0473828584bd',NULL), (2,'2026-03-05 23:23:30','2026-03-05 23:23:30',2,'import_hash_v2','\"5757f0c0b69b9d76e697c28efbbde40cc1513ee106ca40f213174c18889dc6f9\"','96bf821babed2b956df55fb6d6962249392b9a3b1b3b4f9bd40153da694d3696',NULL), (3,'2026-03-05 23:23:30','2026-03-05 23:23:30',3,'import_hash_v2','\"dc72dbc4381ceefd2eb865f0518713031e98598f48217a506379787f0da71a8c\"','632ebd9bed77cc2f06dba5078263fc2457d5226d2f5abb2e1597a9f48cdaf0f7',NULL), (4,'2026-03-05 23:23:31','2026-03-05 23:23:31',4,'import_hash_v2','\"b0e17eca3ffdf800d1a200d7ef0fb72dcbd8e9a0e432792200766d3ffb6588fd\"','3a6f860bc756f6b976c26b75b6b054522f4aff831980912fab6dff9ceff3fdf3',NULL), (5,'2026-03-05 23:23:31','2026-03-05 23:23:31',5,'import_hash_v2','\"024601cf219a6fbe941676814d85aefc03dfd2367bae6570c3426c8ce2731278\"','7ff0b53875d4d9ab3b16228d18e43abb511fa16bed3bbd54f2aa8619c3574422',NULL), (6,'2026-03-05 23:23:31','2026-03-05 23:23:31',6,'import_hash_v2','\"6aa38141534083c01182001cbe4f989f1474ce74c7d1354ac786528a89e173ba\"','848a8e1ed38b3652718f283390c9140acc7bed1502771b6016f7d6b842d18f72',NULL), (7,'2026-03-05 23:23:31','2026-03-05 23:23:31',7,'import_hash_v2','\"08abbd147facb802c042cc05aab634c1b42d46e919ae14d964cf3201fe2b6838\"','2cd847e6f79dcef28d9ecce43ce25cbeea08a17125ca6c27e0d9c45f6164a116',NULL), (8,'2026-03-05 23:23:31','2026-03-05 23:23:31',8,'import_hash_v2','\"5121f0983ed0b1138d7f978e4d62c2e9af19eb67cfd795941dfd23493dd47a35\"','0c19f1f2552d3c43a62337f46c762e1226e9db8139b9d9ca72f9e6efadda70e7',NULL), (9,'2026-03-05 23:23:31','2026-03-05 23:23:31',9,'import_hash_v2','\"8e149cc8a7b25a8b462a0383fd9ff78f9228cd81b344b6d9f1d73c08df00874d\"','0cba0f296196b2eab7e0350a581eec578c7319cca666d8226bf21c71bd5987ee',NULL), (10,'2026-03-05 23:30:40','2026-03-05 23:30:40',10,'import_hash_v2','\"d4f54f62bd47c0d6a96f9ff626a070770ec5d32a2b2d4328fdb9a328e2fd3240\"','7c92da2ef19e9f521d7d5c415dad4246cd9b0b59c671eef0239cbd6cf637e0cc',NULL), (11,'2026-03-05 23:30:40','2026-03-05 23:30:40',11,'import_hash_v2','\"071b28c50002fe4147e7b7fff8e302c69899334b80b0baaa528806fbd4a21ee3\"','bd1f368347dc7fe730724f5626e95320f57c52f7760a1c0e639d1b31f7041163',NULL), (12,'2026-03-05 23:30:40','2026-03-05 23:30:40',12,'import_hash_v2','\"e81326c4153c8ae6a5016826b7d715ac05a91e3a7aa667125e073ac3d9bdf1b8\"','882088f50a1d2c147259aed8092081181e14b7046590867398e31ff158010500',NULL), (13,'2026-03-05 23:30:40','2026-03-05 23:30:40',13,'import_hash_v2','\"bf2af176bf58741449f3d9496ff72eefe781e03bad81f0fc39d85b72bece4966\"','eb4597a43e33a43769d4ae9de5933fc54660669a8a4460b607c5e10d975aaf03',NULL), (14,'2026-03-05 23:30:40','2026-03-05 23:30:40',14,'import_hash_v2','\"0014fbce57658008f470ed3b3485c1caf3d82abde71bbaaaf6acb91dc11b8bca\"','0485ccbed126d74df9d1ee4a9802a25a641223bc4b04f3fe957e985df94073ff',NULL), (15,'2026-03-05 23:30:40','2026-03-05 23:30:40',15,'import_hash_v2','\"b30bf48224875b78028cb4daf4753a4865315bb908112323c686af1f6468ea38\"','1ac9af7ed1696f98677be632e714231a9d822e779a981c4281ac0f379ecadce8',NULL), (16,'2026-03-05 23:30:41','2026-03-05 23:30:41',16,'import_hash_v2','\"4703a7654031070e167351dca10fe2866df07d00eb38a5b87c94a4ae2f2b415c\"','04009ea6d299ac9e705af3fe544c8f1df8c14e259f83477f4c234448fae528d3',NULL), (17,'2026-03-05 23:30:41','2026-03-05 23:30:41',17,'import_hash_v2','\"86dd4b7b23cca4692e6c6abb47f72e5b8ff40a0f005d3b277165b43927213060\"','d27a13b3434b4df775b12fb703e0489268d546c5b60a52fe5d3bfc8bd9b6891d',NULL), (18,'2026-03-05 23:30:41','2026-03-05 23:30:41',18,'import_hash_v2','\"cb98cd97ec0c919abaa7c16d1194155cd7da3dcf42ec5b6800e00ff1cf8c0638\"','2b8a7995a43e0d56b08a6327b10a9252d2eca3b90e21eafe2b47dc1f22ef73b3',NULL), (19,'2026-03-05 23:30:41','2026-03-05 23:30:41',19,'import_hash_v2','\"9b7b8dea6d785f1899451c03b10ef25b480752b5f558034f1d747bbf390eb720\"','9bb8f7e53af3a4be0b94adb4ae0705b2259936aec94f60a5dc1edafc353676a7',NULL), (20,'2026-03-05 23:30:41','2026-03-05 23:30:41',20,'import_hash_v2','\"b6da52c1ef4c06da284e583da576887e61355d8972292b9efc178b03e429f975\"','19f51c0b15a7c11bfdcbe32008d782f027c43e4a1af249db40773c4f9d8fc5f1',NULL), (21,'2026-03-05 23:30:41','2026-03-05 23:30:41',21,'import_hash_v2','\"83c58c5607dfadbafdb901c6e1531db464cd0a1a81cd44dd109a53f7f8ba4f22\"','cbaf7e4618d0985053e1e83d8887ddc9793e11551757cba78dc19b07652c18d4',NULL), (22,'2026-03-05 23:30:41','2026-03-05 23:30:41',22,'import_hash_v2','\"6006414b6ca440aea10bc69b2aea8b598a29e6930dcbd1adc928cede7bf6562a\"','f27a2b488685b421b25b8ac3f1eca6e4b37e4237384b0efbdd73a694c419de85',NULL), (23,'2026-03-05 23:30:41','2026-03-05 23:30:41',23,'import_hash_v2','\"c31d4911b8a07b022e7c1ff3b0a46a085c73cc3f63b8284ef6a1ae2e570af6e1\"','cdc77f641fd359b0c92a072f69107a9ad53e424aa8c90c1889972c478ad82a47',NULL); /*!40000 ALTER TABLE `journal_meta` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `link_types` -- DROP TABLE IF EXISTS `link_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `link_types` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `name` varchar(191) NOT NULL, `outward` varchar(191) NOT NULL, `inward` varchar(191) NOT NULL, `editable` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `link_types_name_outward_inward_unique` (`name`,`outward`,`inward`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `link_types` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `link_types` WRITE; /*!40000 ALTER TABLE `link_types` DISABLE KEYS */; INSERT INTO `link_types` VALUES (1,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Related','relates to','relates to',0), (2,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Refund','(partially) refunds','is (partially) refunded by',0), (3,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Paid','(partially) pays for','is (partially) paid for by',0), (4,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Reimbursement','(partially) reimburses','is (partially) reimbursed by',0); /*!40000 ALTER TABLE `link_types` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `locations` -- DROP TABLE IF EXISTS `locations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `locations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `locatable_id` int(10) unsigned NOT NULL, `locatable_type` varchar(255) NOT NULL, `latitude` decimal(12,8) DEFAULT NULL, `longitude` decimal(12,8) DEFAULT NULL, `zoom_level` smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `locations` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `locations` WRITE; /*!40000 ALTER TABLE `locations` DISABLE KEYS */; /*!40000 ALTER TABLE `locations` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2016_06_16_000000_create_support_tables',1), (2,'2016_06_16_000001_create_users_table',1), (3,'2016_06_16_000002_create_main_tables',1), (4,'2016_08_25_091522_changes_for_3101',1), (5,'2016_09_12_121359_fix_nullables',1), (6,'2016_10_09_150037_expand_transactions_table',1), (7,'2016_10_22_075804_changes_for_v410',1), (8,'2016_11_24_210552_changes_for_v420',1), (9,'2016_12_22_150431_changes_for_v430',1), (10,'2016_12_28_203205_changes_for_v431',1), (11,'2017_04_13_163623_changes_for_v440',1), (12,'2017_06_02_105232_changes_for_v450',1), (13,'2017_08_20_062014_changes_for_v470',1), (14,'2017_11_04_170844_changes_for_v470a',1), (15,'2018_01_01_000001_create_oauth_auth_codes_table',1), (16,'2018_01_01_000002_create_oauth_access_tokens_table',1), (17,'2018_01_01_000003_create_oauth_refresh_tokens_table',1), (18,'2018_01_01_000004_create_oauth_clients_table',1), (19,'2018_01_01_000005_create_oauth_personal_access_clients_table',1), (20,'2018_03_19_141348_changes_for_v472',1), (21,'2018_04_07_210913_changes_for_v473',1), (22,'2018_04_29_174524_changes_for_v474',1), (23,'2018_06_08_200526_changes_for_v475',1), (24,'2018_09_05_195147_changes_for_v477',1), (25,'2018_11_06_172532_changes_for_v479',1), (26,'2019_01_28_193833_changes_for_v4710',1), (27,'2019_02_05_055516_changes_for_v4711',1), (28,'2019_02_11_170529_changes_for_v4712',1), (29,'2019_03_11_223700_fix_ldap_configuration',1), (30,'2019_03_22_183214_changes_for_v480',1), (31,'2019_11_30_000000_create_2fa_token_table',1), (32,'2019_12_28_191351_make_locations_table',1), (33,'2020_03_13_201950_changes_for_v520',1), (34,'2020_06_07_063612_changes_for_v530',1), (35,'2020_06_30_202620_changes_for_v530a',1), (36,'2020_07_24_162820_changes_for_v540',1), (37,'2020_11_12_070604_changes_for_v550',1), (38,'2021_03_12_061213_changes_for_v550b2',1), (39,'2021_05_09_064644_add_ldap_columns_to_users_table',1), (40,'2021_05_13_053836_extend_currency_info',1), (41,'2021_07_05_193044_drop_tele_table',1), (42,'2021_08_28_073733_user_groups',1), (43,'2021_12_27_000001_create_local_personal_access_tokens_table',1), (44,'2022_08_21_104626_add_user_groups',1), (45,'2022_09_18_123911_create_notifications_table',1), (46,'2022_10_01_074908_invited_users',1), (47,'2022_10_01_210238_audit_log_entries',1), (48,'2023_08_11_192521_upgrade_og_table',1), (49,'2023_10_21_113213_add_currency_pivot_tables',1), (50,'2024_03_03_174645_add_indices',1), (51,'2024_04_01_174351_expand_preferences_table',1), (52,'2024_05_12_060551_create_account_balance_table',1), (53,'2024_07_28_145631_add_running_balance',1), (54,'2024_11_05_062108_add_date_tz_columns',1), (55,'2024_11_30_075826_multi_piggy',1), (56,'2024_12_19_061003_add_native_amount_column',1), (57,'2025_07_10_065736_rename_tag_mode',1), (58,'2025_08_19_180459_create_webhook_details_tables',1), (59,'2025_09_25_175248_create_period_statistics',1), (60,'2026_01_28_201901_migrations_01_2026',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `notes` -- DROP TABLE IF EXISTS `notes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `notes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `noteable_id` int(10) unsigned NOT NULL, `noteable_type` varchar(191) NOT NULL, `title` varchar(191) DEFAULT NULL, `text` text DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notes` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `notes` WRITE; /*!40000 ALTER TABLE `notes` DISABLE KEYS */; /*!40000 ALTER TABLE `notes` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `notifications` ( `id` char(36) NOT NULL, `type` varchar(191) NOT NULL, `notifiable_type` varchar(191) NOT NULL, `notifiable_id` bigint(20) unsigned NOT NULL, `data` text NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `oauth_access_tokens` -- DROP TABLE IF EXISTS `oauth_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_access_tokens` ( `id` varchar(100) NOT NULL, `user_id` int(11) DEFAULT NULL, `client_id` int(11) NOT NULL, `name` varchar(191) DEFAULT NULL, `scopes` text DEFAULT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_access_tokens_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_access_tokens` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `oauth_access_tokens` WRITE; /*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */; INSERT INTO `oauth_access_tokens` VALUES ('2f1aa8ce1a863daeddf6717626fdc6cd491fffe34d6d0242945868aa4dc27dd90f65cba67ffea19f',1,2,NULL,'[]',0,'2026-03-05 22:41:14','2026-03-05 22:41:14','2026-03-19 22:41:14'), ('521f8ef5d5e44b7ae556b2f5858cbbf1b9e2a1089a4409780ba12bb3558fda6c791a3aa3a833bbdc',1,2,NULL,'[]',0,'2026-03-05 23:02:26','2026-03-05 23:02:26','2026-03-19 23:02:26'), ('8b9316b8cd0fa8a55b25d9bc54cf429b34b5f3f38176113676325c0c2b60b8219dfeb9d5dd1e6d4e',1,2,NULL,'[]',0,'2026-03-05 23:31:26','2026-03-05 23:31:26','2026-03-19 23:31:26'), ('ba900d09ca0b7c3cb1a08ceb98b4db75af836a9019bcf4d0b6c878ae1c81a38ab29f49d3f028d4a8',1,2,NULL,'[]',0,'2026-03-05 23:17:02','2026-03-05 23:17:02','2026-03-19 23:17:02'), ('e38e527dff4d5a5e5ae97bdcf50d9b968fb496463951687b0b57caa76d10b57c0aded8415418bb62',1,2,NULL,'[]',0,'2026-03-05 23:29:36','2026-03-05 23:29:36','2026-03-19 23:29:36'); /*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `oauth_auth_codes` -- DROP TABLE IF EXISTS `oauth_auth_codes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_auth_codes` ( `id` varchar(100) NOT NULL, `user_id` int(11) NOT NULL, `client_id` int(11) NOT NULL, `scopes` text DEFAULT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_auth_codes` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `oauth_auth_codes` WRITE; /*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */; INSERT INTO `oauth_auth_codes` VALUES ('1fba287c73d801a898cf6e2261c99d8121631335cb954276357b2ee4ecc78b3b16c2eed6ed8bc22e',1,2,'[]',1,'2026-03-05 23:39:36'), ('3e09a8250ccf9239e09e6f94497e684e95d2de39a980a14ab5c266b81b79340e7a9a62262b1f4e60',1,2,'[]',1,'2026-03-05 23:41:25'), ('640c1d9145dc3669384ceda6efc0882a8e5a73d7b392d2d358b3cf731a51cd63be3ad5b01e822192',1,2,'[]',1,'2026-03-05 22:51:13'), ('96448ab1d210d50ec7006588423c9dea5e55019507c8593dce9bbc3351879c72c104c4df56788790',1,2,'[]',1,'2026-03-05 23:27:01'), ('dc2aed51fc9b03b2306ba43b75ae0696a5829a8e6ec904ddcf9600d12ac680d0a7264e7dc96d0309',1,2,'[]',1,'2026-03-05 23:12:26'); /*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `oauth_clients` -- DROP TABLE IF EXISTS `oauth_clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_clients` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `name` varchar(191) NOT NULL, `secret` varchar(100) DEFAULT NULL, `redirect` text NOT NULL, `personal_access_client` tinyint(1) NOT NULL, `password_client` tinyint(1) NOT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `provider` varchar(191) DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_clients_user_id_index` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_clients` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `oauth_clients` WRITE; /*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */; INSERT INTO `oauth_clients` VALUES (1,NULL,'FireflyIII Personal Access Grant Client','upy2Xvzi81JYYTTXesIwhGoQF4s2LIWLsXQyw3T1','http://localhost',1,0,0,'2026-03-05 22:39:01','2026-03-05 22:39:01',NULL), (2,1,'importer',NULL,'http://localhost:81/callback',0,0,0,'2026-03-05 22:40:44','2026-03-05 22:40:44',NULL); /*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `oauth_personal_access_clients` -- DROP TABLE IF EXISTS `oauth_personal_access_clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_personal_access_clients` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `client_id` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_personal_access_clients_client_id_index` (`client_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_personal_access_clients` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `oauth_personal_access_clients` WRITE; /*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */; INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2026-03-05 22:39:01','2026-03-05 22:39:01'); /*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `oauth_refresh_tokens` -- DROP TABLE IF EXISTS `oauth_refresh_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_refresh_tokens` ( `id` varchar(100) NOT NULL, `access_token_id` varchar(100) NOT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_refresh_tokens` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `oauth_refresh_tokens` WRITE; /*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */; INSERT INTO `oauth_refresh_tokens` VALUES ('1c3ff91a8ce251709c9038cf769dab8013c1386c72bbcb294904067552bc15f4f2180c422de35f46','8b9316b8cd0fa8a55b25d9bc54cf429b34b5f3f38176113676325c0c2b60b8219dfeb9d5dd1e6d4e',0,'2027-03-05 23:31:26'), ('7b75b2d5229646e27a0b47628f7a5ede5d8b6ea4e71390a8484a3ce956f5b9e9321143260e82f790','ba900d09ca0b7c3cb1a08ceb98b4db75af836a9019bcf4d0b6c878ae1c81a38ab29f49d3f028d4a8',0,'2027-03-05 23:17:02'), ('b26712cd5f6b7077d8b08a17c7977c27f5b1663a242727d49ff04861638937d8053c1e1f457569d3','e38e527dff4d5a5e5ae97bdcf50d9b968fb496463951687b0b57caa76d10b57c0aded8415418bb62',0,'2027-03-05 23:29:36'), ('e6e3884222a54e62e20488fc84fc67e7315b5a22070c1de9451047321caf6e3762ddc423d733d567','521f8ef5d5e44b7ae556b2f5858cbbf1b9e2a1089a4409780ba12bb3558fda6c791a3aa3a833bbdc',0,'2027-03-05 23:02:26'), ('ee4b4021e4f780c5495fb2e29347ba42de5ea2d04db691b909bd998e4b1eaff1738248641e2bd191','2f1aa8ce1a863daeddf6717626fdc6cd491fffe34d6d0242945868aa4dc27dd90f65cba67ffea19f',0,'2027-03-05 22:41:14'); /*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `object_groupables` -- DROP TABLE IF EXISTS `object_groupables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `object_groupables` ( `object_group_id` int(11) NOT NULL, `object_groupable_id` int(10) unsigned NOT NULL, `object_groupable_type` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `object_groupables` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `object_groupables` WRITE; /*!40000 ALTER TABLE `object_groupables` DISABLE KEYS */; /*!40000 ALTER TABLE `object_groupables` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `object_groups` -- DROP TABLE IF EXISTS `object_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `object_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `title` varchar(255) NOT NULL, `order` mediumint(8) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `object_groups_user_id_foreign` (`user_id`), KEY `object_groups_to_ugi` (`user_group_id`), CONSTRAINT `object_groups_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `object_groups_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `object_groups` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `object_groups` WRITE; /*!40000 ALTER TABLE `object_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `object_groups` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `password_resets` ( `email` varchar(191) NOT NULL, `token` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`), KEY `password_resets_token_index` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `period_statistics` -- DROP TABLE IF EXISTS `period_statistics`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `period_statistics` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_group_id` bigint(20) unsigned NOT NULL, `primary_statable_id` int(10) unsigned DEFAULT NULL, `primary_statable_type` varchar(255) DEFAULT NULL, `secondary_statable_id` int(10) unsigned DEFAULT NULL, `secondary_statable_type` varchar(255) DEFAULT NULL, `tertiary_statable_id` int(10) unsigned DEFAULT NULL, `tertiary_statable_type` varchar(255) DEFAULT NULL, `transaction_currency_id` int(10) unsigned NOT NULL, `start` datetime DEFAULT NULL, `start_tz` varchar(50) DEFAULT NULL, `end` datetime DEFAULT NULL, `end_tz` varchar(50) DEFAULT NULL, `type` varchar(255) NOT NULL, `count` int(10) unsigned NOT NULL DEFAULT 0, `amount` decimal(32,12) NOT NULL, PRIMARY KEY (`id`), KEY `period_statistics_transaction_currency_id_foreign` (`transaction_currency_id`), KEY `period_statistics_user_group_id_foreign` (`user_group_id`), CONSTRAINT `period_statistics_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, CONSTRAINT `period_statistics_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `period_statistics` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `period_statistics` WRITE; /*!40000 ALTER TABLE `period_statistics` DISABLE KEYS */; INSERT INTO `period_statistics` VALUES (1,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2026-03-01 00:00:00','Europe/Amsterdam','2026-03-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (2,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2026-02-01 00:00:00','Europe/Amsterdam','2026-02-28 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (3,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2026-01-01 00:00:00','Europe/Amsterdam','2026-01-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (4,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-12-01 00:00:00','Europe/Amsterdam','2025-12-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (5,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-11-01 00:00:00','Europe/Amsterdam','2025-11-30 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (6,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-10-01 00:00:00','Europe/Amsterdam','2025-10-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (7,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-09-01 00:00:00','Europe/Amsterdam','2025-09-30 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (8,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-08-01 00:00:00','Europe/Amsterdam','2025-08-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (9,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-07-01 00:00:00','Europe/Amsterdam','2025-07-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (10,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-06-01 00:00:00','Europe/Amsterdam','2025-06-30 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (11,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-05-01 00:00:00','Europe/Amsterdam','2025-05-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (12,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-04-01 00:00:00','Europe/Amsterdam','2025-04-30 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (13,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-03-01 00:00:00','Europe/Amsterdam','2025-03-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (14,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2025-01-01 00:00:00','Europe/Amsterdam','2025-12-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (15,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2024-01-01 00:00:00','Europe/Amsterdam','2024-12-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (16,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2023-01-01 00:00:00','Europe/Amsterdam','2023-12-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (17,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2022-01-01 00:00:00','Europe/Amsterdam','2022-12-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (18,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2021-01-01 00:00:00','Europe/Amsterdam','2021-12-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000), (19,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,NULL,NULL,NULL,NULL,NULL,1,'2020-01-01 00:00:00','Europe/Amsterdam','2020-12-31 23:59:59','Europe/Amsterdam','all_withdrawal',0,0.000000000000); /*!40000 ALTER TABLE `period_statistics` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `permission_role` -- DROP TABLE IF EXISTS `permission_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `permission_role` ( `permission_id` int(10) unsigned NOT NULL, `role_id` int(10) unsigned NOT NULL, PRIMARY KEY (`permission_id`,`role_id`), KEY `permission_role_role_id_foreign` (`role_id`), CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permission_role` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `permission_role` WRITE; /*!40000 ALTER TABLE `permission_role` DISABLE KEYS */; /*!40000 ALTER TABLE `permission_role` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `name` varchar(191) NOT NULL, `display_name` varchar(191) DEFAULT NULL, `description` varchar(191) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `permissions_name_unique` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(191) NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` varchar(191) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `piggy_bank_events` -- DROP TABLE IF EXISTS `piggy_bank_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `piggy_bank_events` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `piggy_bank_id` int(10) unsigned NOT NULL, `transaction_journal_id` int(10) unsigned DEFAULT NULL, `date` date NOT NULL, `date_tz` varchar(50) DEFAULT NULL, `amount` decimal(32,12) NOT NULL, `native_amount` decimal(32,12) DEFAULT NULL, PRIMARY KEY (`id`), KEY `piggy_bank_events_piggy_bank_id_foreign` (`piggy_bank_id`), KEY `piggy_bank_events_transaction_journal_id_foreign` (`transaction_journal_id`), CONSTRAINT `piggy_bank_events_piggy_bank_id_foreign` FOREIGN KEY (`piggy_bank_id`) REFERENCES `piggy_banks` (`id`) ON DELETE CASCADE, CONSTRAINT `piggy_bank_events_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `piggy_bank_events` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `piggy_bank_events` WRITE; /*!40000 ALTER TABLE `piggy_bank_events` DISABLE KEYS */; /*!40000 ALTER TABLE `piggy_bank_events` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `piggy_bank_repetitions` -- DROP TABLE IF EXISTS `piggy_bank_repetitions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `piggy_bank_repetitions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `piggy_bank_id` int(10) unsigned NOT NULL, `start_date` date DEFAULT NULL, `start_date_tz` varchar(50) DEFAULT NULL, `target_date` date DEFAULT NULL, `target_date_tz` varchar(50) DEFAULT NULL, `current_amount` decimal(32,12) NOT NULL, PRIMARY KEY (`id`), KEY `piggy_bank_repetitions_piggy_bank_id_foreign` (`piggy_bank_id`), CONSTRAINT `piggy_bank_repetitions_piggy_bank_id_foreign` FOREIGN KEY (`piggy_bank_id`) REFERENCES `piggy_banks` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `piggy_bank_repetitions` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `piggy_bank_repetitions` WRITE; /*!40000 ALTER TABLE `piggy_bank_repetitions` DISABLE KEYS */; /*!40000 ALTER TABLE `piggy_bank_repetitions` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `piggy_banks` -- DROP TABLE IF EXISTS `piggy_banks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `piggy_banks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `account_id` int(10) unsigned DEFAULT NULL, `transaction_currency_id` int(10) unsigned DEFAULT NULL, `name` varchar(1024) NOT NULL, `target_amount` decimal(32,12) NOT NULL, `start_date` date DEFAULT NULL, `start_date_tz` varchar(50) DEFAULT NULL, `target_date` date DEFAULT NULL, `target_date_tz` varchar(50) DEFAULT NULL, `order` int(10) unsigned NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 0, `encrypted` tinyint(1) NOT NULL DEFAULT 1, `native_target_amount` decimal(32,12) DEFAULT NULL, PRIMARY KEY (`id`), KEY `unique_currency` (`transaction_currency_id`), KEY `piggy_banks_account_id_foreign` (`account_id`), CONSTRAINT `piggy_banks_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE SET NULL, CONSTRAINT `unique_currency` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `piggy_banks` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `piggy_banks` WRITE; /*!40000 ALTER TABLE `piggy_banks` DISABLE KEYS */; /*!40000 ALTER TABLE `piggy_banks` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `preferences` -- DROP TABLE IF EXISTS `preferences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `preferences` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(1024) NOT NULL, `data` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `preferences_user_id_foreign` (`user_id`), KEY `preferences_to_ugi` (`user_group_id`), CONSTRAINT `preferences_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `preferences_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `preferences` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `preferences` WRITE; /*!40000 ALTER TABLE `preferences` DISABLE KEYS */; INSERT INTO `preferences` VALUES (1,'2026-03-05 22:30:28','2026-03-05 22:30:28',1,NULL,'viewRange','\"1M\"'), (2,'2026-03-05 22:30:28','2026-03-05 22:30:28',1,NULL,'language','\"en_US\"'), (3,'2026-03-05 22:30:28','2026-03-05 22:30:28',1,NULL,'locale','\"equal\"'), (4,'2026-03-05 22:30:28','2026-03-05 23:30:41',1,NULL,'lastActivity','\"0.93103500 1772749841\"'), (5,'2026-03-05 22:30:28','2026-03-05 22:37:40',1,NULL,'anonymous','false'), (6,'2026-03-05 22:30:28','2026-03-05 22:30:28',1,NULL,'list-length','10'), (7,'2026-03-05 22:30:28','2026-03-05 22:30:28',1,NULL,'darkMode','\"browser\"'), (8,'2026-03-05 22:30:28','2026-03-05 22:30:28',1,NULL,'convert_to_primary','false'), (9,'2026-03-05 22:30:37','2026-03-05 22:30:37',1,NULL,'listPageSize','50'), (10,'2026-03-05 22:31:41','2026-03-05 22:31:41',1,NULL,'shown_demo_piggy-banks_index','false'), (11,'2026-03-05 22:31:45','2026-03-05 23:02:06',1,NULL,'shown_demo_index','true'), (12,'2026-03-05 22:39:01','2026-03-05 22:39:01',1,NULL,'mfa_recovery','[]'), (13,'2026-03-05 22:39:01','2026-03-05 22:39:01',1,NULL,'access_token','\"c4d8e29d8caf1f0b572e744ae7f37cef\"'), (14,'2026-03-05 22:41:14','2026-03-05 22:41:14',1,NULL,'slack_webhook_url','\"\"'), (15,'2026-03-05 22:41:14','2026-03-05 22:41:14',1,NULL,'pushover_app_token','\"\"'), (16,'2026-03-05 22:41:14','2026-03-05 22:41:14',1,NULL,'pushover_user_token','\"\"'), (17,'2026-03-05 23:02:04','2026-03-05 23:02:04',1,NULL,'frontpageAccounts','[1,2,3]'), (18,'2026-03-05 23:02:04','2026-03-05 23:02:04',1,NULL,'transaction_journal_optional_fields','{\"interest_date\":true,\"book_date\":false,\"process_date\":false,\"due_date\":false,\"payment_date\":false,\"invoice_date\":false,\"internal_reference\":false,\"notes\":true,\"attachments\":true}'), (19,'2026-03-05 23:24:50','2026-03-05 23:27:44',1,NULL,'shown_demo_budgets_index','true'), (20,'2026-03-05 23:29:50','2026-03-05 23:29:50',1,NULL,'customFiscalYear','false'); /*!40000 ALTER TABLE `preferences` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `recurrences` -- DROP TABLE IF EXISTS `recurrences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `recurrences` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `transaction_type_id` int(10) unsigned NOT NULL, `title` varchar(1024) NOT NULL, `description` text NOT NULL, `first_date` date NOT NULL, `first_date_tz` varchar(50) DEFAULT NULL, `repeat_until` date DEFAULT NULL, `repeat_until_tz` varchar(50) DEFAULT NULL, `latest_date` date DEFAULT NULL, `latest_date_tz` varchar(50) DEFAULT NULL, `repetitions` smallint(5) unsigned NOT NULL, `apply_rules` tinyint(1) NOT NULL DEFAULT 1, `active` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), KEY `recurrences_user_id_foreign` (`user_id`), KEY `recurrences_transaction_type_id_foreign` (`transaction_type_id`), KEY `recurrences_to_ugi` (`user_group_id`), CONSTRAINT `recurrences_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `recurrences_transaction_type_id_foreign` FOREIGN KEY (`transaction_type_id`) REFERENCES `transaction_types` (`id`) ON DELETE CASCADE, CONSTRAINT `recurrences_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `recurrences` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `recurrences` WRITE; /*!40000 ALTER TABLE `recurrences` DISABLE KEYS */; /*!40000 ALTER TABLE `recurrences` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `recurrences_meta` -- DROP TABLE IF EXISTS `recurrences_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `recurrences_meta` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `recurrence_id` int(10) unsigned NOT NULL, `name` varchar(50) NOT NULL, `value` text NOT NULL, PRIMARY KEY (`id`), KEY `recurrences_meta_recurrence_id_foreign` (`recurrence_id`), CONSTRAINT `recurrences_meta_recurrence_id_foreign` FOREIGN KEY (`recurrence_id`) REFERENCES `recurrences` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `recurrences_meta` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `recurrences_meta` WRITE; /*!40000 ALTER TABLE `recurrences_meta` DISABLE KEYS */; /*!40000 ALTER TABLE `recurrences_meta` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `recurrences_repetitions` -- DROP TABLE IF EXISTS `recurrences_repetitions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `recurrences_repetitions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `recurrence_id` int(10) unsigned NOT NULL, `repetition_type` varchar(50) NOT NULL, `repetition_moment` varchar(50) NOT NULL, `repetition_skip` smallint(5) unsigned NOT NULL, `weekend` smallint(5) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `recurrences_repetitions_recurrence_id_foreign` (`recurrence_id`), CONSTRAINT `recurrences_repetitions_recurrence_id_foreign` FOREIGN KEY (`recurrence_id`) REFERENCES `recurrences` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `recurrences_repetitions` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `recurrences_repetitions` WRITE; /*!40000 ALTER TABLE `recurrences_repetitions` DISABLE KEYS */; /*!40000 ALTER TABLE `recurrences_repetitions` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `recurrences_transactions` -- DROP TABLE IF EXISTS `recurrences_transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `recurrences_transactions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `recurrence_id` int(10) unsigned NOT NULL, `transaction_currency_id` int(10) unsigned NOT NULL, `transaction_type_id` int(10) unsigned DEFAULT NULL, `foreign_currency_id` int(10) unsigned DEFAULT NULL, `source_id` int(10) unsigned NOT NULL, `destination_id` int(10) unsigned NOT NULL, `amount` decimal(32,12) NOT NULL, `foreign_amount` decimal(32,12) DEFAULT NULL, `description` varchar(1024) NOT NULL, PRIMARY KEY (`id`), KEY `recurrences_transactions_recurrence_id_foreign` (`recurrence_id`), KEY `recurrences_transactions_transaction_currency_id_foreign` (`transaction_currency_id`), KEY `recurrences_transactions_foreign_currency_id_foreign` (`foreign_currency_id`), KEY `recurrences_transactions_source_id_foreign` (`source_id`), KEY `recurrences_transactions_destination_id_foreign` (`destination_id`), KEY `type_foreign` (`transaction_type_id`), CONSTRAINT `recurrences_transactions_destination_id_foreign` FOREIGN KEY (`destination_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, CONSTRAINT `recurrences_transactions_foreign_currency_id_foreign` FOREIGN KEY (`foreign_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE SET NULL, CONSTRAINT `recurrences_transactions_recurrence_id_foreign` FOREIGN KEY (`recurrence_id`) REFERENCES `recurrences` (`id`) ON DELETE CASCADE, CONSTRAINT `recurrences_transactions_source_id_foreign` FOREIGN KEY (`source_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, CONSTRAINT `recurrences_transactions_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, CONSTRAINT `type_foreign` FOREIGN KEY (`transaction_type_id`) REFERENCES `transaction_types` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `recurrences_transactions` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `recurrences_transactions` WRITE; /*!40000 ALTER TABLE `recurrences_transactions` DISABLE KEYS */; /*!40000 ALTER TABLE `recurrences_transactions` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `role_user` -- DROP TABLE IF EXISTS `role_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `role_user` ( `user_id` int(10) unsigned NOT NULL, `role_id` int(10) unsigned NOT NULL, PRIMARY KEY (`user_id`,`role_id`), KEY `role_user_role_id_foreign` (`role_id`), CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_user` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `role_user` WRITE; /*!40000 ALTER TABLE `role_user` DISABLE KEYS */; INSERT INTO `role_user` VALUES (1,1); /*!40000 ALTER TABLE `role_user` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `name` varchar(191) NOT NULL, `display_name` varchar(191) DEFAULT NULL, `description` varchar(191) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,'2026-03-05 22:12:26','2026-03-05 22:12:26','owner','Site Owner','User runs this instance of FF3'), (2,'2026-03-05 22:12:26','2026-03-05 22:12:26','demo','Demo User','User is a demo user'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `rt_meta` -- DROP TABLE IF EXISTS `rt_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `rt_meta` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `rt_id` int(10) unsigned NOT NULL, `name` varchar(50) NOT NULL, `value` text NOT NULL, PRIMARY KEY (`id`), KEY `rt_meta_rt_id_foreign` (`rt_id`), CONSTRAINT `rt_meta_rt_id_foreign` FOREIGN KEY (`rt_id`) REFERENCES `recurrences_transactions` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rt_meta` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `rt_meta` WRITE; /*!40000 ALTER TABLE `rt_meta` DISABLE KEYS */; /*!40000 ALTER TABLE `rt_meta` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `rule_actions` -- DROP TABLE IF EXISTS `rule_actions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `rule_actions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `rule_id` int(10) unsigned NOT NULL, `action_type` varchar(50) NOT NULL, `action_value` varchar(255) NOT NULL, `order` int(10) unsigned NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `stop_processing` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `rule_actions_rule_id_foreign` (`rule_id`), CONSTRAINT `rule_actions_rule_id_foreign` FOREIGN KEY (`rule_id`) REFERENCES `rules` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rule_actions` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `rule_actions` WRITE; /*!40000 ALTER TABLE `rule_actions` DISABLE KEYS */; /*!40000 ALTER TABLE `rule_actions` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `rule_groups` -- DROP TABLE IF EXISTS `rule_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `rule_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `order` int(10) unsigned NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `stop_processing` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `rule_groups_user_id_foreign` (`user_id`), KEY `rule_groups_to_ugi` (`user_group_id`), CONSTRAINT `rule_groups_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `rule_groups_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rule_groups` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `rule_groups` WRITE; /*!40000 ALTER TABLE `rule_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `rule_groups` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `rule_triggers` -- DROP TABLE IF EXISTS `rule_triggers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `rule_triggers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `rule_id` int(10) unsigned NOT NULL, `trigger_type` varchar(50) NOT NULL, `trigger_value` varchar(255) NOT NULL, `order` int(10) unsigned NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `stop_processing` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `rule_triggers_rule_id_foreign` (`rule_id`), CONSTRAINT `rule_triggers_rule_id_foreign` FOREIGN KEY (`rule_id`) REFERENCES `rules` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rule_triggers` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `rule_triggers` WRITE; /*!40000 ALTER TABLE `rule_triggers` DISABLE KEYS */; /*!40000 ALTER TABLE `rule_triggers` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `rules` -- DROP TABLE IF EXISTS `rules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `rules` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `rule_group_id` int(10) unsigned NOT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `order` int(10) unsigned NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `stop_processing` tinyint(1) NOT NULL DEFAULT 0, `strict` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), KEY `rules_user_id_foreign` (`user_id`), KEY `rules_rule_group_id_foreign` (`rule_group_id`), KEY `rules_to_ugi` (`user_group_id`), CONSTRAINT `rules_rule_group_id_foreign` FOREIGN KEY (`rule_group_id`) REFERENCES `rule_groups` (`id`) ON DELETE CASCADE, CONSTRAINT `rules_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `rules_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rules` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `rules` WRITE; /*!40000 ALTER TABLE `rules` DISABLE KEYS */; /*!40000 ALTER TABLE `rules` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `sessions` ( `id` varchar(191) NOT NULL, `user_id` int(11) DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` text NOT NULL, `last_activity` int(11) NOT NULL, UNIQUE KEY `sessions_id_unique` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `tag_transaction_journal` -- DROP TABLE IF EXISTS `tag_transaction_journal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tag_transaction_journal` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tag_id` int(10) unsigned NOT NULL, `transaction_journal_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `tag_transaction_journal_tag_id_transaction_journal_id_unique` (`tag_id`,`transaction_journal_id`), KEY `idx_ttj_journal_tag` (`transaction_journal_id`,`tag_id`), CONSTRAINT `tag_transaction_journal_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE, CONSTRAINT `tag_transaction_journal_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tag_transaction_journal` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `tag_transaction_journal` WRITE; /*!40000 ALTER TABLE `tag_transaction_journal` DISABLE KEYS */; INSERT INTO `tag_transaction_journal` VALUES (1,1,1), (2,1,2), (3,1,3), (4,1,4), (5,1,5), (6,1,6), (7,1,7), (8,1,8), (9,1,9), (10,2,10), (11,2,11), (12,2,12), (13,2,13), (14,2,14), (15,2,15), (16,2,16), (17,2,17), (18,2,18), (19,2,19), (20,2,20), (21,2,21), (22,2,22), (23,2,23); /*!40000 ALTER TABLE `tag_transaction_journal` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `tags` -- DROP TABLE IF EXISTS `tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tags` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `tag` varchar(1024) NOT NULL, `tag_mode` varchar(1024) NOT NULL, `date` date DEFAULT NULL, `date_tz` varchar(50) DEFAULT NULL, `description` text DEFAULT NULL, `latitude` decimal(12,8) DEFAULT NULL, `longitude` decimal(12,8) DEFAULT NULL, `zoomLevel` smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `tags_user_id_foreign` (`user_id`), KEY `tags_to_ugi` (`user_group_id`), CONSTRAINT `tags_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `tags_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tags` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `tags` WRITE; /*!40000 ALTER TABLE `tags` DISABLE KEYS */; INSERT INTO `tags` VALUES (1,'2026-03-05 23:23:30','2026-03-05 23:23:30',NULL,1,1,'Data Import on 2026-03-05 @ 23:23','nothing','2026-03-05',NULL,'',NULL,NULL,NULL), (2,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,'Data Import on 2026-03-05 @ 23:30','nothing','2026-03-05',NULL,'',NULL,NULL,NULL); /*!40000 ALTER TABLE `tags` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `transaction_currencies` -- DROP TABLE IF EXISTS `transaction_currencies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `transaction_currencies` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `enabled` tinyint(1) NOT NULL DEFAULT 0, `code` varchar(51) NOT NULL, `name` varchar(255) NOT NULL, `symbol` varchar(51) NOT NULL, `decimal_places` smallint(5) unsigned NOT NULL DEFAULT 2, PRIMARY KEY (`id`), UNIQUE KEY `transaction_currencies_code_unique` (`code`) ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transaction_currencies` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `transaction_currencies` WRITE; /*!40000 ALTER TABLE `transaction_currencies` DISABLE KEYS */; INSERT INTO `transaction_currencies` VALUES (1,'2026-03-05 22:12:26','2026-03-05 23:02:04',NULL,1,'EUR','Euro','€',2), (2,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'HUF','Hungarian forint','Ft',2), (3,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'GBP','British Pound','£',2), (4,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'UAH','Ukrainian hryvnia','₴',2), (5,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'PLN','Polish złoty','zł',2), (6,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'TRY','Turkish lira','₺',2), (7,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'DKK','Dansk krone','kr.',2), (8,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'ISK','Íslensk króna','kr.',2), (9,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'NOK','Norsk krone','kr.',2), (10,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'SEK','Svensk krona','kr.',2), (11,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'RON','Romanian leu','lei',2), (12,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'USD','US Dollar','$',2), (13,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'BRL','Brazilian real','R$',2), (14,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'CAD','Canadian dollar','C$',2), (15,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'MXN','Mexican peso','MX$',2), (16,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'PEN','Peruvian Sol','S/',2), (17,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'ARS','Argentinian Peso','$',2), (18,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'COP','Colombian Peso','$',2), (19,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'CLP','Chilean Peso','$',2), (20,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'UYU','Uruguayan Peso','$',2), (21,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'IDR','Indonesian rupiah','Rp',2), (22,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'AUD','Australian dollar','A$',2), (23,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'NZD','New Zealand dollar','NZ$',2), (24,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'EGP','Egyptian pound','E£',2), (25,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'MAD','Moroccan dirham','DH',2), (26,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'ZAR','South African rand','R',2), (27,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'JPY','Japanese yen','¥',0), (28,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'CNY','Chinese yuan','¥',2), (29,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'KRW','South Korean won','₩',2), (30,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'RUB','Russian ruble','₽',2), (31,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'INR','Indian rupee','₹',2), (32,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'ILS','Israeli new shekel','₪',2), (33,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'CHF','Swiss franc','CHF',2), (34,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'HRK','Croatian kuna','kn',2), (35,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'HKD','Hong Kong dollar','HK$',2), (36,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'CZK','Czech koruna','Kč',2), (37,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'KZT','Kazakhstani tenge','₸',2), (38,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'SAR','Saudi Riyal','SAR',2), (39,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'RSD','Serbian Dinar','RSD',2), (40,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'TWD','New Taiwan Dollar','NT$',0), (41,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,0,'THB','Thai baht','฿',2); /*!40000 ALTER TABLE `transaction_currencies` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `transaction_currency_user` -- DROP TABLE IF EXISTS `transaction_currency_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `transaction_currency_user` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `transaction_currency_id` int(10) unsigned NOT NULL, `user_default` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `unique_combo` (`user_id`,`transaction_currency_id`), KEY `transaction_currency_user_transaction_currency_id_foreign` (`transaction_currency_id`), CONSTRAINT `transaction_currency_user_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, CONSTRAINT `transaction_currency_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transaction_currency_user` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `transaction_currency_user` WRITE; /*!40000 ALTER TABLE `transaction_currency_user` DISABLE KEYS */; /*!40000 ALTER TABLE `transaction_currency_user` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `transaction_currency_user_group` -- DROP TABLE IF EXISTS `transaction_currency_user_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `transaction_currency_user_group` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_group_id` bigint(20) unsigned NOT NULL, `transaction_currency_id` int(10) unsigned NOT NULL, `group_default` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `unique_combo_ug` (`user_group_id`,`transaction_currency_id`), KEY `transaction_currency_user_group_transaction_currency_id_foreign` (`transaction_currency_id`), CONSTRAINT `transaction_currency_user_group_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, CONSTRAINT `transaction_currency_user_group_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transaction_currency_user_group` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `transaction_currency_user_group` WRITE; /*!40000 ALTER TABLE `transaction_currency_user_group` DISABLE KEYS */; INSERT INTO `transaction_currency_user_group` VALUES (2,'2026-03-05 23:02:04','2026-03-05 23:02:04',1,1,1); /*!40000 ALTER TABLE `transaction_currency_user_group` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `transaction_groups` -- DROP TABLE IF EXISTS `transaction_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `transaction_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `title` varchar(1024) DEFAULT NULL, PRIMARY KEY (`id`), KEY `transaction_groups_user_id_index` (`user_id`), KEY `transaction_groups_user_group_id_index` (`user_group_id`), CONSTRAINT `transaction_groups_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `transaction_groups_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transaction_groups` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `transaction_groups` WRITE; /*!40000 ALTER TABLE `transaction_groups` DISABLE KEYS */; INSERT INTO `transaction_groups` VALUES (1,'2026-03-05 23:23:30','2026-03-05 23:23:30',NULL,1,1,NULL), (2,'2026-03-05 23:23:30','2026-03-05 23:23:30',NULL,1,1,NULL), (3,'2026-03-05 23:23:30','2026-03-05 23:23:31',NULL,1,1,NULL), (4,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,NULL), (5,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,NULL), (6,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,NULL), (7,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,NULL), (8,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,NULL), (9,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,NULL), (10,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,NULL), (11,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,NULL), (12,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,NULL), (13,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,NULL), (14,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,NULL), (15,'2026-03-05 23:30:40','2026-03-05 23:30:41',NULL,1,1,NULL), (16,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,NULL), (17,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,NULL), (18,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,NULL), (19,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,NULL), (20,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,NULL), (21,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,NULL), (22,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,NULL), (23,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,NULL); /*!40000 ALTER TABLE `transaction_groups` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `transaction_journals` -- DROP TABLE IF EXISTS `transaction_journals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `transaction_journals` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `transaction_type_id` int(10) unsigned NOT NULL, `transaction_group_id` int(10) unsigned DEFAULT NULL, `bill_id` int(10) unsigned DEFAULT NULL, `transaction_currency_id` int(10) unsigned DEFAULT NULL, `description` varchar(1024) NOT NULL, `date` datetime NOT NULL, `date_tz` varchar(50) DEFAULT NULL, `interest_date` date DEFAULT NULL, `book_date` date DEFAULT NULL, `process_date` date DEFAULT NULL, `order` int(10) unsigned NOT NULL DEFAULT 0, `tag_count` int(10) unsigned NOT NULL, `encrypted` tinyint(1) NOT NULL DEFAULT 1, `completed` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), KEY `transaction_journals_user_id_index` (`user_id`), KEY `transaction_journals_user_group_id_index` (`user_group_id`), KEY `transaction_journals_date_index` (`date`), KEY `transaction_journals_transaction_group_id_index` (`transaction_group_id`), KEY `transaction_journals_transaction_type_id_index` (`transaction_type_id`), KEY `transaction_journals_transaction_currency_id_index` (`transaction_currency_id`), KEY `transaction_journals_bill_id_index` (`bill_id`), KEY `idx_tj_deleted` (`deleted_at`), CONSTRAINT `transaction_journals_bill_id_foreign` FOREIGN KEY (`bill_id`) REFERENCES `bills` (`id`) ON DELETE SET NULL, CONSTRAINT `transaction_journals_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `transaction_journals_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, CONSTRAINT `transaction_journals_transaction_group_id_foreign` FOREIGN KEY (`transaction_group_id`) REFERENCES `transaction_groups` (`id`) ON DELETE CASCADE, CONSTRAINT `transaction_journals_transaction_type_id_foreign` FOREIGN KEY (`transaction_type_id`) REFERENCES `transaction_types` (`id`) ON DELETE CASCADE, CONSTRAINT `transaction_journals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transaction_journals` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `transaction_journals` WRITE; /*!40000 ALTER TABLE `transaction_journals` DISABLE KEYS */; INSERT INTO `transaction_journals` VALUES (1,'2026-03-05 23:23:30','2026-03-05 23:23:30',NULL,1,1,1,1,NULL,1,'Money back from internet subscription','2016-10-10 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (2,'2026-03-05 23:23:30','2026-03-05 23:23:30',NULL,1,1,1,2,NULL,1,'Discount from new service subscription','2016-11-11 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (3,'2026-03-05 23:23:30','2026-03-05 23:23:31',NULL,1,1,1,3,NULL,1,'Tax break for 2016','2016-12-12 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (4,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,7,4,NULL,1,'Bought some weird Chinese stuff','2016-02-12 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (5,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,7,5,NULL,1,'Bought some books','2016-02-24 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (6,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,7,6,NULL,1,'Apple brand batteries for Magic Mouse','2016-04-20 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (7,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,7,7,NULL,1,'Expensive pet food','2016-05-09 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (8,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,7,8,NULL,1,'Drinks with friends','2016-07-14 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (9,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,1,1,7,9,NULL,1,'Paid back third part','2016-09-10 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (10,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,7,10,NULL,1,'Bread','2016-03-11 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (11,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,7,11,NULL,1,'Car parts','2016-03-22 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (12,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,7,12,NULL,1,'Oil for car','2016-04-10 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (13,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,7,13,NULL,1,'McBurger with fries','2016-05-18 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (14,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,7,14,NULL,1,'Paid back first part of one million of student loans','2016-06-08 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (15,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,1,1,7,15,NULL,1,'Did some groceries','2016-06-16 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (16,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,16,NULL,1,'Forgot a bill','2016-07-07 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (17,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,17,NULL,1,'Paid back the second part','2016-08-06 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (18,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,18,NULL,1,'Water bill','2016-08-12 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (19,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,19,NULL,1,'Did some groceries','2016-09-05 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (20,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,20,NULL,1,'Drinks with friends','2016-11-04 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (21,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,21,NULL,1,'Did some groceries','2016-11-08 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (22,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,22,NULL,1,'Got gas for the car','2016-12-03 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1), (23,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,1,1,7,23,NULL,1,'Got gas for the car','2016-12-06 00:00:00','Europe/Amsterdam',NULL,NULL,NULL,0,0,1,1); /*!40000 ALTER TABLE `transaction_journals` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `transaction_types` -- DROP TABLE IF EXISTS `transaction_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `transaction_types` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `type` varchar(50) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `transaction_types_type_unique` (`type`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transaction_types` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `transaction_types` WRITE; /*!40000 ALTER TABLE `transaction_types` DISABLE KEYS */; INSERT INTO `transaction_types` VALUES (1,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Deposit'), (2,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Invalid'), (3,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Liability credit'), (4,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Opening balance'), (5,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Reconciliation'), (6,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Transfer'), (7,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'Withdrawal'); /*!40000 ALTER TABLE `transaction_types` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `transactions` -- DROP TABLE IF EXISTS `transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `transactions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `reconciled` tinyint(1) NOT NULL DEFAULT 0, `account_id` int(10) unsigned NOT NULL, `transaction_journal_id` int(10) unsigned NOT NULL, `description` varchar(1024) DEFAULT NULL, `transaction_currency_id` int(10) unsigned DEFAULT NULL, `amount` decimal(32,12) NOT NULL, `balance_before` decimal(32,12) DEFAULT NULL, `balance_after` decimal(32,12) DEFAULT NULL, `balance_dirty` tinyint(1) NOT NULL DEFAULT 1, `foreign_amount` decimal(32,12) DEFAULT NULL, `foreign_currency_id` int(10) unsigned DEFAULT NULL, `identifier` smallint(5) unsigned NOT NULL DEFAULT 0, `native_amount` decimal(32,12) DEFAULT NULL, `native_foreign_amount` decimal(32,12) DEFAULT NULL, PRIMARY KEY (`id`), KEY `transactions_account_id_index` (`account_id`), KEY `transactions_transaction_journal_id_index` (`transaction_journal_id`), KEY `transactions_transaction_currency_id_index` (`transaction_currency_id`), KEY `transactions_foreign_currency_id_index` (`foreign_currency_id`), KEY `idx_tx_journal_amount` (`transaction_journal_id`,`amount`), CONSTRAINT `transactions_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, CONSTRAINT `transactions_foreign_currency_id_foreign` FOREIGN KEY (`foreign_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE SET NULL, CONSTRAINT `transactions_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE SET NULL, CONSTRAINT `transactions_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transactions` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `transactions` WRITE; /*!40000 ALTER TABLE `transactions` DISABLE KEYS */; INSERT INTO `transactions` VALUES (1,'2026-03-05 23:23:30','2026-03-05 23:23:30',NULL,0,4,1,NULL,1,-120.000000000000,0.000000000000,-120.000000000000,0,NULL,NULL,0,NULL,NULL), (2,'2026-03-05 23:23:30','2026-03-05 23:30:41',NULL,0,1,1,NULL,1,120.000000000000,-989.830000000000,-869.830000000000,0,NULL,NULL,0,NULL,NULL), (3,'2026-03-05 23:23:30','2026-03-05 23:23:30',NULL,0,5,2,NULL,1,-180.000000000000,0.000000000000,-180.000000000000,0,NULL,NULL,0,NULL,NULL), (4,'2026-03-05 23:23:30','2026-03-05 23:30:41',NULL,0,1,2,NULL,1,180.000000000000,-915.260000000000,-735.260000000000,0,NULL,NULL,0,NULL,NULL), (5,'2026-03-05 23:23:30','2026-03-05 23:23:31',NULL,0,6,3,NULL,1,-200.000000000000,0.000000000000,-200.000000000000,0,NULL,NULL,0,NULL,NULL), (6,'2026-03-05 23:23:30','2026-03-05 23:23:31',NULL,0,2,3,NULL,1,200.000000000000,0.000000000000,200.000000000000,0,NULL,NULL,0,NULL,NULL), (7,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,0,1,4,NULL,1,-15.000000000000,0.000000000000,-15.000000000000,0,NULL,NULL,0,NULL,NULL), (8,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,0,7,4,NULL,1,15.000000000000,0.000000000000,15.000000000000,0,NULL,NULL,0,NULL,NULL), (9,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,0,1,5,NULL,1,-110.000000000000,-15.000000000000,-125.000000000000,0,NULL,NULL,0,NULL,NULL), (10,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,0,8,5,NULL,1,110.000000000000,0.000000000000,110.000000000000,0,NULL,NULL,0,NULL,NULL), (11,'2026-03-05 23:23:31','2026-03-05 23:30:40',NULL,0,1,6,NULL,1,-34.000000000000,-193.400000000000,-227.400000000000,0,NULL,NULL,0,NULL,NULL), (12,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,0,9,6,NULL,1,34.000000000000,0.000000000000,34.000000000000,0,NULL,NULL,0,NULL,NULL), (13,'2026-03-05 23:23:31','2026-03-05 23:30:40',NULL,0,1,7,NULL,1,-30.000000000000,-227.400000000000,-257.400000000000,0,NULL,NULL,0,NULL,NULL), (14,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,0,10,7,NULL,1,30.000000000000,0.000000000000,30.000000000000,0,NULL,NULL,0,NULL,NULL), (15,'2026-03-05 23:23:31','2026-03-05 23:30:41',NULL,0,1,8,NULL,1,-34.230000000000,-530.300000000000,-564.530000000000,0,NULL,NULL,0,NULL,NULL), (16,'2026-03-05 23:23:31','2026-03-05 23:23:31',NULL,0,11,8,NULL,1,34.230000000000,0.000000000000,34.230000000000,0,NULL,NULL,0,NULL,NULL), (17,'2026-03-05 23:23:31','2026-03-05 23:30:41',NULL,0,1,9,NULL,1,-200.000000000000,-789.830000000000,-989.830000000000,0,NULL,NULL,0,NULL,NULL), (18,'2026-03-05 23:23:31','2026-03-05 23:30:41',NULL,0,12,9,NULL,1,200.000000000000,400.000000000000,600.000000000000,0,NULL,NULL,0,NULL,NULL), (19,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,0,1,10,NULL,1,-3.400000000000,-125.000000000000,-128.400000000000,0,NULL,NULL,0,NULL,NULL), (20,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,0,13,10,NULL,1,3.400000000000,0.000000000000,3.400000000000,0,NULL,NULL,0,NULL,NULL), (21,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,0,1,11,NULL,1,-45.000000000000,-128.400000000000,-173.400000000000,0,NULL,NULL,0,NULL,NULL), (22,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,0,14,11,NULL,1,45.000000000000,0.000000000000,45.000000000000,0,NULL,NULL,0,NULL,NULL), (23,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,0,1,12,NULL,1,-20.000000000000,-173.400000000000,-193.400000000000,0,NULL,NULL,0,NULL,NULL), (24,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,0,15,12,NULL,1,20.000000000000,0.000000000000,20.000000000000,0,NULL,NULL,0,NULL,NULL), (25,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,0,1,13,NULL,1,-8.000000000000,-257.400000000000,-265.400000000000,0,NULL,NULL,0,NULL,NULL), (26,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,0,16,13,NULL,1,8.000000000000,0.000000000000,8.000000000000,0,NULL,NULL,0,NULL,NULL), (27,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,0,1,14,NULL,1,-200.000000000000,-265.400000000000,-465.400000000000,0,NULL,NULL,0,NULL,NULL), (28,'2026-03-05 23:30:40','2026-03-05 23:30:40',NULL,0,12,14,NULL,1,200.000000000000,0.000000000000,200.000000000000,0,NULL,NULL,0,NULL,NULL), (29,'2026-03-05 23:30:40','2026-03-05 23:30:41',NULL,0,1,15,NULL,1,-14.900000000000,-465.400000000000,-480.300000000000,0,NULL,NULL,0,NULL,NULL), (30,'2026-03-05 23:30:40','2026-03-05 23:30:41',NULL,0,17,15,NULL,1,14.900000000000,0.000000000000,14.900000000000,0,NULL,NULL,0,NULL,NULL), (31,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,1,16,NULL,1,-50.000000000000,-480.300000000000,-530.300000000000,0,NULL,NULL,0,NULL,NULL), (32,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,18,16,NULL,1,50.000000000000,0.000000000000,50.000000000000,0,NULL,NULL,0,NULL,NULL), (33,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,1,17,NULL,1,-200.000000000000,-564.530000000000,-764.530000000000,0,NULL,NULL,0,NULL,NULL), (34,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,12,17,NULL,1,200.000000000000,200.000000000000,400.000000000000,0,NULL,NULL,0,NULL,NULL), (35,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,1,18,NULL,1,-10.000000000000,-764.530000000000,-774.530000000000,0,NULL,NULL,0,NULL,NULL), (36,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,19,18,NULL,1,10.000000000000,0.000000000000,10.000000000000,0,NULL,NULL,0,NULL,NULL), (37,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,1,19,NULL,1,-15.300000000000,-774.530000000000,-789.830000000000,0,NULL,NULL,0,NULL,NULL), (38,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,17,19,NULL,1,15.300000000000,14.900000000000,30.200000000000,0,NULL,NULL,0,NULL,NULL), (39,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,1,20,NULL,1,-31.100000000000,-869.830000000000,-900.930000000000,0,NULL,NULL,0,NULL,NULL), (40,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,11,20,NULL,1,31.100000000000,34.230000000000,65.330000000000,0,NULL,NULL,0,NULL,NULL), (41,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,1,21,NULL,1,-14.330000000000,-900.930000000000,-915.260000000000,0,NULL,NULL,0,NULL,NULL), (42,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,17,21,NULL,1,14.330000000000,30.200000000000,44.530000000000,0,NULL,NULL,0,NULL,NULL), (43,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,1,22,NULL,1,-30.100000000000,-735.260000000000,-765.360000000000,0,NULL,NULL,0,NULL,NULL), (44,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,20,22,NULL,1,30.100000000000,0.000000000000,30.100000000000,0,NULL,NULL,0,NULL,NULL), (45,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,1,23,NULL,1,-22.910000000000,-765.360000000000,-788.270000000000,0,NULL,NULL,0,NULL,NULL), (46,'2026-03-05 23:30:41','2026-03-05 23:30:41',NULL,0,20,23,NULL,1,22.910000000000,30.100000000000,53.010000000000,0,NULL,NULL,0,NULL,NULL); /*!40000 ALTER TABLE `transactions` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `user_groups` -- DROP TABLE IF EXISTS `user_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `user_groups` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `title` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_groups_title_unique` (`title`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_groups` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `user_groups` WRITE; /*!40000 ALTER TABLE `user_groups` DISABLE KEYS */; INSERT INTO `user_groups` VALUES (1,'2026-03-05 22:30:28','2026-03-05 22:30:28',NULL,'test@example.com'); /*!40000 ALTER TABLE `user_groups` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `user_roles` -- DROP TABLE IF EXISTS `user_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `user_roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `title` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_roles_title_unique` (`title`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_roles` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `user_roles` WRITE; /*!40000 ALTER TABLE `user_roles` DISABLE KEYS */; INSERT INTO `user_roles` VALUES (1,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'ro'), (2,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'mng_trx'), (3,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'mng_meta'), (4,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'read_budgets'), (5,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'read_piggies'), (6,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'read_subscriptions'), (7,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'read_rules'), (8,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'read_recurring'), (9,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'read_webhooks'), (10,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'read_currencies'), (11,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'mng_budgets'), (12,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'mng_piggies'), (13,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'mng_subscriptions'), (14,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'mng_rules'), (15,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'mng_recurring'), (16,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'mng_webhooks'), (17,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'mng_currencies'), (18,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'view_reports'), (19,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'view_memberships'), (20,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'full'), (21,'2026-03-05 22:12:26','2026-03-05 22:12:26',NULL,'owner'); /*!40000 ALTER TABLE `user_roles` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `objectguid` char(36) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `email` varchar(255) NOT NULL, `password` varchar(60) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `reset` varchar(32) DEFAULT NULL, `blocked` tinyint(3) unsigned NOT NULL DEFAULT 0, `blocked_code` varchar(25) DEFAULT NULL, `mfa_secret` varchar(50) DEFAULT NULL, `domain` varchar(191) DEFAULT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `type_user_group_id` (`user_group_id`), CONSTRAINT `type_user_group_id` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,NULL,'2026-03-05 22:30:27','2026-03-05 22:30:28','test@example.com','$2y$10$uyBxNWTJDNvN23.xggu2QeEinwAziJb9i7huq49MTk/oTE9YZ4RVO',NULL,NULL,0,NULL,NULL,NULL,1); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `webhook_attempts` -- DROP TABLE IF EXISTS `webhook_attempts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `webhook_attempts` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `webhook_message_id` int(10) unsigned NOT NULL, `status_code` smallint(5) unsigned NOT NULL DEFAULT 0, `logs` longtext DEFAULT NULL, `response` longtext DEFAULT NULL, PRIMARY KEY (`id`), KEY `webhook_attempts_webhook_message_id_foreign` (`webhook_message_id`), CONSTRAINT `webhook_attempts_webhook_message_id_foreign` FOREIGN KEY (`webhook_message_id`) REFERENCES `webhook_messages` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webhook_attempts` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `webhook_attempts` WRITE; /*!40000 ALTER TABLE `webhook_attempts` DISABLE KEYS */; /*!40000 ALTER TABLE `webhook_attempts` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `webhook_deliveries` -- DROP TABLE IF EXISTS `webhook_deliveries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `webhook_deliveries` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `key` smallint(5) unsigned NOT NULL, `title` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `webhook_deliveries_key_title_unique` (`key`,`title`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webhook_deliveries` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `webhook_deliveries` WRITE; /*!40000 ALTER TABLE `webhook_deliveries` DISABLE KEYS */; INSERT INTO `webhook_deliveries` VALUES (1,'2026-03-05 22:12:26','2026-03-05 22:12:26',300,'JSON'); /*!40000 ALTER TABLE `webhook_deliveries` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `webhook_messages` -- DROP TABLE IF EXISTS `webhook_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `webhook_messages` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `sent` tinyint(1) NOT NULL DEFAULT 0, `errored` tinyint(1) NOT NULL DEFAULT 0, `webhook_id` int(10) unsigned NOT NULL, `uuid` varchar(64) NOT NULL, `message` longtext NOT NULL, PRIMARY KEY (`id`), KEY `webhook_messages_webhook_id_foreign` (`webhook_id`), CONSTRAINT `webhook_messages_webhook_id_foreign` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webhook_messages` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `webhook_messages` WRITE; /*!40000 ALTER TABLE `webhook_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `webhook_messages` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `webhook_responses` -- DROP TABLE IF EXISTS `webhook_responses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `webhook_responses` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `key` smallint(5) unsigned NOT NULL, `title` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `webhook_responses_key_title_unique` (`key`,`title`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webhook_responses` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `webhook_responses` WRITE; /*!40000 ALTER TABLE `webhook_responses` DISABLE KEYS */; INSERT INTO `webhook_responses` VALUES (1,'2026-03-05 22:12:26','2026-03-05 22:12:26',200,'TRANSACTIONS'), (2,'2026-03-05 22:12:26','2026-03-05 22:12:26',210,'ACCOUNTS'), (3,'2026-03-05 22:12:26','2026-03-05 22:12:26',230,'BUDGET'), (4,'2026-03-05 22:12:26','2026-03-05 22:12:26',240,'RELEVANT'), (5,'2026-03-05 22:12:26','2026-03-05 22:12:26',220,'NONE'); /*!40000 ALTER TABLE `webhook_responses` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `webhook_triggers` -- DROP TABLE IF EXISTS `webhook_triggers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `webhook_triggers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `key` smallint(5) unsigned NOT NULL, `title` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `webhook_triggers_key_title_unique` (`key`,`title`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webhook_triggers` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `webhook_triggers` WRITE; /*!40000 ALTER TABLE `webhook_triggers` DISABLE KEYS */; INSERT INTO `webhook_triggers` VALUES (1,'2026-03-05 22:12:26','2026-03-05 22:12:26',50,'ANY'), (2,'2026-03-05 22:12:26','2026-03-05 22:12:26',100,'STORE_TRANSACTION'), (3,'2026-03-05 22:12:26','2026-03-05 22:12:26',110,'UPDATE_TRANSACTION'), (4,'2026-03-05 22:12:26','2026-03-05 22:12:26',120,'DESTROY_TRANSACTION'), (5,'2026-03-05 22:12:26','2026-03-05 22:12:26',200,'STORE_BUDGET'), (6,'2026-03-05 22:12:26','2026-03-05 22:12:26',210,'UPDATE_BUDGET'), (7,'2026-03-05 22:12:26','2026-03-05 22:12:26',220,'DESTROY_BUDGET'), (8,'2026-03-05 22:12:26','2026-03-05 22:12:26',230,'STORE_UPDATE_BUDGET_LIMIT'); /*!40000 ALTER TABLE `webhook_triggers` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `webhook_webhook_delivery` -- DROP TABLE IF EXISTS `webhook_webhook_delivery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `webhook_webhook_delivery` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `webhook_id` int(10) unsigned NOT NULL, `webhook_delivery_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `webhook_webhook_delivery_webhook_id_webhook_delivery_id_unique` (`webhook_id`,`webhook_delivery_id`), KEY `link_to_delivery` (`webhook_delivery_id`), CONSTRAINT `link_to_delivery` FOREIGN KEY (`webhook_delivery_id`) REFERENCES `webhook_deliveries` (`id`) ON DELETE CASCADE, CONSTRAINT `webhook_webhook_delivery_webhook_id_foreign` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webhook_webhook_delivery` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `webhook_webhook_delivery` WRITE; /*!40000 ALTER TABLE `webhook_webhook_delivery` DISABLE KEYS */; /*!40000 ALTER TABLE `webhook_webhook_delivery` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `webhook_webhook_response` -- DROP TABLE IF EXISTS `webhook_webhook_response`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `webhook_webhook_response` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `webhook_id` int(10) unsigned NOT NULL, `webhook_response_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `webhook_webhook_response_webhook_id_webhook_response_id_unique` (`webhook_id`,`webhook_response_id`), KEY `link_to_response` (`webhook_response_id`), CONSTRAINT `link_to_response` FOREIGN KEY (`webhook_response_id`) REFERENCES `webhook_responses` (`id`) ON DELETE CASCADE, CONSTRAINT `webhook_webhook_response_webhook_id_foreign` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webhook_webhook_response` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `webhook_webhook_response` WRITE; /*!40000 ALTER TABLE `webhook_webhook_response` DISABLE KEYS */; /*!40000 ALTER TABLE `webhook_webhook_response` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `webhook_webhook_trigger` -- DROP TABLE IF EXISTS `webhook_webhook_trigger`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `webhook_webhook_trigger` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `webhook_id` int(10) unsigned NOT NULL, `webhook_trigger_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `webhook_webhook_trigger_webhook_id_webhook_trigger_id_unique` (`webhook_id`,`webhook_trigger_id`), KEY `link_to_trigger` (`webhook_trigger_id`), CONSTRAINT `link_to_trigger` FOREIGN KEY (`webhook_trigger_id`) REFERENCES `webhook_triggers` (`id`) ON DELETE CASCADE, CONSTRAINT `webhook_webhook_trigger_webhook_id_foreign` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webhook_webhook_trigger` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `webhook_webhook_trigger` WRITE; /*!40000 ALTER TABLE `webhook_webhook_trigger` DISABLE KEYS */; /*!40000 ALTER TABLE `webhook_webhook_trigger` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; -- -- Table structure for table `webhooks` -- DROP TABLE IF EXISTS `webhooks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `webhooks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `user_id` int(10) unsigned NOT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, `title` varchar(255) NOT NULL, `secret` varchar(32) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `trigger` smallint(5) unsigned NOT NULL, `response` smallint(5) unsigned NOT NULL, `delivery` smallint(5) unsigned NOT NULL, `url` varchar(1024) NOT NULL, PRIMARY KEY (`id`), KEY `webhooks_user_id_foreign` (`user_id`), KEY `webhooks_title_index` (`title`), KEY `webhooks_secret_index` (`secret`), KEY `webhooks_to_ugi` (`user_group_id`), CONSTRAINT `webhooks_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `webhooks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webhooks` -- SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=0; LOCK TABLES `webhooks` WRITE; /*!40000 ALTER TABLE `webhooks` DISABLE KEYS */; /*!40000 ALTER TABLE `webhooks` ENABLE KEYS */; UNLOCK TABLES; COMMIT; SET AUTOCOMMIT=@OLD_AUTOCOMMIT; /*!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 */; /*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */; -- Dump completed on 2026-03-05 22:45:25