| Server IP : 66.29.132.122 / Your IP : 3.144.121.184 Web Server : LiteSpeed System : Linux business142.web-hosting.com 4.18.0-553.lve.el8.x86_64 #1 SMP Mon May 27 15:27:34 UTC 2024 x86_64 User : admazpex ( 531) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /proc/self/root/proc/self/root/proc/thread-self/root/proc/thread-self/root/proc/self/root/proc/thread-self/root/proc/self/root/proc/self/root/proc/self/root/var/softaculous/firefly/ |
Upload File : |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `firefly6122` -- -- -------------------------------------------------------- -- -- Table structure for table `2fa_tokens` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `2fa_tokens_token_unique` (`token`), KEY `2fa_tokens_user_id_foreign` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `accounts` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `virtual_balance` decimal(32,12) DEFAULT NULL, `iban` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT '1', `encrypted` tinyint(1) NOT NULL DEFAULT '0', `order` int(10) unsigned NOT NULL DEFAULT '0', 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `account_balances` -- 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `account_meta` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `data` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `account_meta_account_id_index` (`account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `account_types` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `account_types_type_unique` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=14 ; -- -- Dumping data for table `account_types` -- INSERT INTO `account_types` VALUES (1, '[[regtime]]', '[[regtime]]', 'Default account'), (2, '[[regtime]]', '[[regtime]]', 'Cash account'), (3, '[[regtime]]', '[[regtime]]', 'Asset account'), (4, '[[regtime]]', '[[regtime]]', 'Expense account'), (5, '[[regtime]]', '[[regtime]]', 'Revenue account'), (6, '[[regtime]]', '[[regtime]]', 'Initial balance account'), (7, '[[regtime]]', '[[regtime]]', 'Beneficiary account'), (8, '[[regtime]]', '[[regtime]]', 'Import account'), (9, '[[regtime]]', '[[regtime]]', 'Loan'), (10, '[[regtime]]', '[[regtime]]', 'Reconciliation account'), (11, '[[regtime]]', '[[regtime]]', 'Debt'), (12, '[[regtime]]', '[[regtime]]', 'Mortgage'), (13, '[[regtime]]', '[[regtime]]', 'Liability credit account'); -- -------------------------------------------------------- -- -- Table structure for table `attachments` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `md5` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, `filename` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `mime` varchar(1024) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `audit_log_entries` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `changer_id` int(10) unsigned NOT NULL, `changer_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `before` text COLLATE utf8mb4_unicode_ci, `after` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `auto_budgets` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `auto_budgets_transaction_currency_id_foreign` (`transaction_currency_id`), KEY `auto_budgets_budget_id_foreign` (`budget_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `available_budgets` -- 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `end_date` date NOT NULL, `end_date_tz` varchar(50) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `bills` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `match` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL, `amount_min` decimal(32,12) NOT NULL, `amount_max` decimal(32,12) NOT NULL, `date` date NOT NULL, `date_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `end_date` date DEFAULT NULL, `end_date_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `extension_date` date DEFAULT NULL, `extension_date_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `repeat_freq` varchar(30) COLLATE utf8mb4_unicode_ci 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', 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `budgets` -- 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) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `budget_limits` -- 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `end_date` date DEFAULT NULL, `end_date_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` decimal(32,12) NOT NULL, `period` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `generated` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `budget_limits_budget_id_foreign` (`budget_id`), KEY `budget_limits_transaction_currency_id_foreign` (`transaction_currency_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `budget_transaction` -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `budget_transaction_journal` -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- 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) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `category_transaction` -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `category_transaction_journal` -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `configuration` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `data` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=42 ; -- -- Dumping data for table `configuration` -- INSERT INTO `configuration` VALUES (1, '[[regtime]]', '[[regtime]]', NULL, 'db_version', '25'), (2, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_accounts', 'true'), (3, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_attachments', 'true'), (4, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_bills', 'true'), (5, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_budgets', 'true'), (6, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_categories', 'true'), (7, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_piggy_banks', 'true'), (8, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_preferences', 'true'), (9, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_tags', 'true'), (10, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_transaction_journals', 'true'), (11, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_transactions', 'true'), (12, '[[regtime]]', '[[regtime]]', NULL, 'is_decrypted_journal_links', 'true'), (13, '[[regtime]]', '[[regtime]]', NULL, '480_transaction_identifier', 'true'), (14, '[[regtime]]', '[[regtime]]', NULL, '480_migrated_to_groups', 'true'), (15, '[[regtime]]', '[[regtime]]', NULL, '480_account_currencies', 'true'), (16, '[[regtime]]', '[[regtime]]', NULL, '480_transfer_currencies', 'true'), (17, '[[regtime]]', '[[regtime]]', NULL, '480_other_currencies', 'true'), (18, '[[regtime]]', '[[regtime]]', NULL, '480_migrate_notes', 'true'), (19, '[[regtime]]', '[[regtime]]', NULL, '480_migrate_attachments', 'true'), (20, '[[regtime]]', '[[regtime]]', NULL, '480_bills_to_rules', 'true'), (21, '[[regtime]]', '[[regtime]]', NULL, '480_bl_currency', 'true'), (22, '[[regtime]]', '[[regtime]]', NULL, '480_cc_liabilities', 'true'), (23, '[[regtime]]', '[[regtime]]', NULL, '480_back_to_journals', 'true'), (24, '[[regtime]]', '[[regtime]]', NULL, '480_rename_account_meta', 'true'), (25, '[[regtime]]', '[[regtime]]', NULL, '481_migrate_recurrence_meta', 'true'), (26, '[[regtime]]', '[[regtime]]', NULL, '500_migrate_tag_locations', 'true'), (27, '[[regtime]]', '[[regtime]]', NULL, '550_migrate_recurrence_type', 'true'), (28, '[[regtime]]', '[[regtime]]', NULL, '560_upgrade_liabilities', 'true'), (29, '[[regtime]]', '[[regtime]]', NULL, '600_upgrade_liabilities', 'true'), (30, '[[regtime]]', '[[regtime]]', NULL, '550_budget_limit_periods', 'true'), (31, '[[regtime]]', '[[regtime]]', NULL, '610_migrate_rule_actions', 'true'), (32, '[[regtime]]', '[[regtime]]', NULL, 'oauth_private_key', '[[private_key_enc]]'), (33, '[[regtime]]', '[[regtime]]', NULL, 'oauth_public_key', '[[public_key_enc]]'), (34, '[[regtime]]', '[[regtime]]', NULL, '610_correct_balances', 'false'), (35, '[[regtime]]', '[[regtime]]', NULL, '610_upgrade_currency_prefs', 'true'), (36, '[[regtime]]', '[[regtime]]', NULL, 'ff3_version', '"6.1.22"'), (37, '[[regtime]]', '[[regtime]]', NULL, 'installation_id', '[[installation_id]]'), (38, '[[regtime]]', '[[regtime]]', NULL, 'is_demo_site', 'false'), (39, '[[regtime]]', '[[regtime]]', NULL, 'single_user_mode', 'true'), (40, '[[regtime]]', '[[regtime]]', NULL, 'notification_user_new_reg', 'true'), (41, '[[regtime]]', '[[regtime]]', NULL, 'notification_admin_new_reg', 'true'); -- -------------------------------------------------------- -- -- Table structure for table `currency_exchange_rates` -- 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) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=25 ; -- -- Dumping data for table `currency_exchange_rates` -- INSERT INTO `currency_exchange_rates` VALUES (1, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 1, '2022-06-06', NULL, '1.000000000000', NULL), (2, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 2, '2022-06-06', NULL, '387.962900000000', NULL), (3, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 3, '2022-06-06', NULL, '0.854207540000', NULL), (4, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 4, '2022-06-06', NULL, '31.659752000000', NULL), (5, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 5, '2022-06-06', NULL, '4.581788000000', NULL), (6, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 6, '2022-06-06', NULL, '17.801397000000', NULL), (7, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 7, '2022-06-06', NULL, '7.438975300000', NULL), (8, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 9, '2022-06-06', NULL, '1.072228100000', NULL), (9, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 10, '2022-06-06', NULL, '5.097317300000', NULL), (10, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 11, '2022-06-06', NULL, '1.345996900000', NULL), (11, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 12, '2022-06-06', NULL, '20.899824000000', NULL), (12, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 13, '2022-06-06', NULL, '15466.299000000000', NULL), (13, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 14, '2022-06-06', NULL, '1.483854900000', NULL), (14, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 15, '2022-06-06', NULL, '1.642582900000', NULL), (15, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 16, '2022-06-06', NULL, '19.997350000000', NULL), (16, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 17, '2022-06-06', NULL, '10.573307000000', NULL), (17, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 18, '2022-06-06', NULL, '16.413167000000', NULL), (18, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 19, '2022-06-06', NULL, '140.152570000000', NULL), (19, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 20, '2022-06-06', NULL, '1.000000000000', NULL), (20, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 21, '2022-06-06', NULL, '66.000895000000', NULL), (21, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 22, '2022-06-06', NULL, '83.220481000000', NULL), (22, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 23, '2022-06-06', NULL, '3.571250800000', NULL), (23, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 24, '2022-06-06', NULL, '1.032389100000', NULL), (24, '[[regtime]]', '[[regtime]]', NULL, 1, NULL, 1, 25, '2022-06-06', NULL, '7.522084500000', NULL); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `group_journals` -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `group_memberships` -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `group_memberships` -- INSERT INTO `group_memberships` VALUES (1, '[[regtime]]', '[[regtime]]', NULL, 1, 1, 14); -- -------------------------------------------------------- -- -- Table structure for table `invited_users` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `invite_code` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `expires` datetime NOT NULL, `expires_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `redeemed` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `invited_users_user_id_foreign` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `journal_links` -- 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 COLLATE utf8mb4_unicode_ci, 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `journal_meta` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `data` text COLLATE utf8mb4_unicode_ci NOT NULL, `hash` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `journal_meta_transaction_journal_id_index` (`transaction_journal_id`), KEY `journal_meta_name_index` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `limit_repetitions` -- CREATE TABLE `limit_repetitions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `budget_limit_id` int(10) unsigned NOT NULL, `startdate` date NOT NULL, `enddate` date NOT NULL, `amount` decimal(32,12) NOT NULL, PRIMARY KEY (`id`), KEY `limit_repetitions_budget_limit_id_foreign` (`budget_limit_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `link_types` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `outward` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `inward` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `editable` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `link_types_name_outward_inward_unique` (`name`,`outward`,`inward`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ; -- -- Dumping data for table `link_types` -- INSERT INTO `link_types` VALUES (1, '[[regtime]]', '[[regtime]]', NULL, 'Related', 'relates to', 'relates to', 0), (2, '[[regtime]]', '[[regtime]]', NULL, 'Refund', '(partially) refunds', 'is (partially) refunded by', 0), (3, '[[regtime]]', '[[regtime]]', NULL, 'Paid', '(partially) pays for', 'is (partially) paid for by', 0), (4, '[[regtime]]', '[[regtime]]', NULL, 'Reimbursement', '(partially) reimburses', 'is (partially) reimbursed by', 0); -- -------------------------------------------------------- -- -- Table structure for table `locations` -- 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) COLLATE utf8mb4_unicode_ci 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=55 ; -- -- Dumping data for table `migrations` -- 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); -- -------------------------------------------------------- -- -- Table structure for table `notes` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `text` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `notifications` -- CREATE TABLE `notifications` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `notifiable_id` bigint(20) unsigned NOT NULL, `data` text COLLATE utf8mb4_unicode_ci 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; -- -------------------------------------------------------- -- -- Table structure for table `oauth_access_tokens` -- CREATE TABLE `oauth_access_tokens` ( `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(11) DEFAULT NULL, `client_id` int(11) NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `scopes` text COLLATE utf8mb4_unicode_ci, `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; -- -------------------------------------------------------- -- -- Table structure for table `oauth_auth_codes` -- CREATE TABLE `oauth_auth_codes` ( `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, `client_id` int(11) NOT NULL, `scopes` text COLLATE utf8mb4_unicode_ci, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `oauth_clients` -- CREATE TABLE `oauth_clients` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `redirect` text COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_clients_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `oauth_personal_access_clients` -- 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `oauth_refresh_tokens` -- CREATE TABLE `oauth_refresh_tokens` ( `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci 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; -- -------------------------------------------------------- -- -- Table structure for table `object_groupables` -- CREATE TABLE `object_groupables` ( `object_group_id` int(11) NOT NULL, `object_groupable_id` int(10) unsigned NOT NULL, `object_groupable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `object_groups` -- 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) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci 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; -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `permissions_name_unique` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `permission_role` -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `piggy_banks` -- 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 NOT NULL, `name` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL, `targetamount` decimal(32,12) NOT NULL, `startdate` date DEFAULT NULL, `startdate_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `targetdate` date DEFAULT NULL, `targetdate_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `order` int(10) unsigned NOT NULL DEFAULT '0', `active` tinyint(1) NOT NULL DEFAULT '0', `encrypted` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `piggy_banks_account_id_foreign` (`account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `piggy_bank_events` -- 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` decimal(32,12) NOT 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `piggy_bank_repetitions` -- 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, `startdate` date DEFAULT NULL, `startdate_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `targetdate` date DEFAULT NULL, `targetdate_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `currentamount` decimal(32,12) NOT NULL, PRIMARY KEY (`id`), KEY `piggy_bank_repetitions_piggy_bank_id_foreign` (`piggy_bank_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `preferences` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `data` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `preferences_user_id_foreign` (`user_id`), KEY `preferences_to_ugi` (`user_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ; -- -- Dumping data for table `preferences` -- INSERT INTO `preferences` VALUES (1, '[[regtime]]', '[[regtime]]', 1, NULL, 'viewRange', '"1M"'), (2, '[[regtime]]', '[[regtime]]', 1, NULL, 'language', '"[[language]]"'); -- -------------------------------------------------------- -- -- Table structure for table `recurrences` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `first_date` date NOT NULL, `first_date_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `repeat_until` date DEFAULT NULL, `repeat_until_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `latest_date` date DEFAULT NULL, `latest_date_tz` varchar(50) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `recurrences_meta` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `recurrences_meta_recurrence_id_foreign` (`recurrence_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `recurrences_repetitions` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `repetition_moment` varchar(50) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `recurrences_transactions` -- 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) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name_unique` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ; -- -- Dumping data for table `roles` -- INSERT INTO `roles` VALUES (1, '[[regtime]]', '[[regtime]]', 'owner', 'Site Owner', 'User runs this instance of FF3'), (2, '[[regtime]]', '[[regtime]]', 'demo', 'Demo User', 'User is a demo user'); -- -------------------------------------------------------- -- -- Table structure for table `role_user` -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `role_user` -- INSERT INTO `role_user` VALUES (1, 1); -- -------------------------------------------------------- -- -- Table structure for table `rt_meta` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `rt_meta_rt_id_foreign` (`rt_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `rules` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `rule_actions` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `action_value` varchar(255) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `rule_groups` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `rule_triggers` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `trigger_value` varchar(255) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(11) DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` text COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int(11) NOT NULL, UNIQUE KEY `sessions_id_unique` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tags` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `tagMode` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL, `date` date DEFAULT NULL, `date_tz` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tag_transaction_journal` -- 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 `tag_transaction_journal_transaction_journal_id_foreign` (`transaction_journal_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- 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) COLLATE utf8mb4_unicode_ci 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', 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `transaction_currencies` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `symbol` varchar(51) COLLATE utf8mb4_unicode_ci NOT NULL, `decimal_places` smallint(5) unsigned NOT NULL DEFAULT '2', PRIMARY KEY (`id`), UNIQUE KEY `transaction_currencies_code_unique` (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=26 ; -- -- Dumping data for table `transaction_currencies` -- INSERT INTO `transaction_currencies` VALUES (1, '[[regtime]]', '[[regtime]]', NULL, 1, 'EUR', 'Euro', '€', 2), (2, '[[regtime]]', '[[regtime]]', NULL, 0, 'HUF', 'Hungarian forint', 'Ft', 2), (3, '[[regtime]]', '[[regtime]]', NULL, 0, 'GBP', 'British Pound', '£', 2), (4, '[[regtime]]', '[[regtime]]', NULL, 0, 'UAH', 'Ukrainian hryvnia', '₴', 2), (5, '[[regtime]]', '[[regtime]]', NULL, 0, 'PLN', 'Polish złoty', 'zł', 2), (6, '[[regtime]]', '[[regtime]]', NULL, 0, 'TRY', 'Turkish lira', '₺', 2), (7, '[[regtime]]', '[[regtime]]', NULL, 0, 'DKK', 'Dansk krone', 'kr.', 2), (8, '[[regtime]]', '[[regtime]]', NULL, 0, 'RON', 'Romanian leu', 'lei', 2), (9, '[[regtime]]', '[[regtime]]', NULL, 0, 'USD', 'US Dollar', '$', 2), (10, '[[regtime]]', '[[regtime]]', NULL, 0, 'BRL', 'Brazilian real', 'R$', 2), (11, '[[regtime]]', '[[regtime]]', NULL, 0, 'CAD', 'Canadian dollar', 'C$', 2), (12, '[[regtime]]', '[[regtime]]', NULL, 0, 'MXN', 'Mexican peso', 'MX$', 2), (13, '[[regtime]]', '[[regtime]]', NULL, 0, 'IDR', 'Indonesian rupiah', 'Rp', 2), (14, '[[regtime]]', '[[regtime]]', NULL, 0, 'AUD', 'Australian dollar', 'A$', 2), (15, '[[regtime]]', '[[regtime]]', NULL, 0, 'NZD', 'New Zealand dollar', 'NZ$', 2), (16, '[[regtime]]', '[[regtime]]', NULL, 0, 'EGP', 'Egyptian pound', 'E£', 2), (17, '[[regtime]]', '[[regtime]]', NULL, 0, 'MAD', 'Moroccan dirham', 'DH', 2), (18, '[[regtime]]', '[[regtime]]', NULL, 0, 'ZAR', 'South African rand', 'R', 2), (19, '[[regtime]]', '[[regtime]]', NULL, 0, 'JPY', 'Japanese yen', '¥', 0), (20, '[[regtime]]', '[[regtime]]', NULL, 0, 'CNY', 'Chinese yuan', '¥', 2), (21, '[[regtime]]', '[[regtime]]', NULL, 0, 'RUB', 'Russian ruble', '₽', 2), (22, '[[regtime]]', '[[regtime]]', NULL, 0, 'INR', 'Indian rupee', '₹', 2), (23, '[[regtime]]', '[[regtime]]', NULL, 0, 'ILS', 'Israeli new shekel', '₪', 2), (24, '[[regtime]]', '[[regtime]]', NULL, 0, 'CHF', 'Swiss franc', 'CHF', 2), (25, '[[regtime]]', '[[regtime]]', NULL, 0, 'HRK', 'Croatian kuna', 'kn', 2); -- -------------------------------------------------------- -- -- Table structure for table `transaction_currency_user` -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `transaction_currency_user_group` -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `transaction_currency_user_group` -- INSERT INTO `transaction_currency_user_group` VALUES (1, '[[regtime]]', '[[regtime]]', 1, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `transaction_groups` -- 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `transaction_groups_user_id_index` (`user_id`), KEY `transaction_groups_user_group_id_index` (`user_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `transaction_journals` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `date` datetime NOT NULL, `date_tz` varchar(50) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `transaction_types` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `transaction_types_type_unique` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=8 ; -- -- Dumping data for table `transaction_types` -- INSERT INTO `transaction_types` VALUES (1, '[[regtime]]', '[[regtime]]', NULL, 'Withdrawal'), (2, '[[regtime]]', '[[regtime]]', NULL, 'Deposit'), (3, '[[regtime]]', '[[regtime]]', NULL, 'Transfer'), (4, '[[regtime]]', '[[regtime]]', NULL, 'Opening balance'), (5, '[[regtime]]', '[[regtime]]', NULL, 'Reconciliation'), (6, '[[regtime]]', '[[regtime]]', NULL, 'Invalid'), (7, '[[regtime]]', '[[regtime]]', NULL, 'Liability credit'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `objectguid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reset` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `blocked` tinyint(3) unsigned NOT NULL DEFAULT '0', `blocked_code` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mfa_secret` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `domain` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_group_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `type_user_group_id` (`user_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `users` -- INSERT INTO `users` VALUES (1, NULL, '[[regtime]]', '[[regtime]]', '[[admin_email]]', '[[admin_pass]]', NULL, NULL, 0, NULL, NULL, NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `user_groups` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_groups_title_unique` (`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `user_groups` -- INSERT INTO `user_groups` VALUES (1, '[[regtime]]', '[[regtime]]', NULL, '[[admin_email]]'); -- -------------------------------------------------------- -- -- Table structure for table `user_roles` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_roles_title_unique` (`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=15 ; -- -- Dumping data for table `user_roles` -- INSERT INTO `user_roles` VALUES (1, '[[regtime]]', '[[regtime]]', NULL, 'ro'), (2, '[[regtime]]', '[[regtime]]', NULL, 'mng_trx'), (3, '[[regtime]]', '[[regtime]]', NULL, 'mng_meta'), (4, '[[regtime]]', '[[regtime]]', NULL, 'mng_budgets'), (5, '[[regtime]]', '[[regtime]]', NULL, 'mng_piggies'), (6, '[[regtime]]', '[[regtime]]', NULL, 'mng_subscriptions'), (7, '[[regtime]]', '[[regtime]]', NULL, 'mng_rules'), (8, '[[regtime]]', '[[regtime]]', NULL, 'mng_recurring'), (9, '[[regtime]]', '[[regtime]]', NULL, 'mng_webhooks'), (10, '[[regtime]]', '[[regtime]]', NULL, 'mng_currencies'), (11, '[[regtime]]', '[[regtime]]', NULL, 'view_reports'), (12, '[[regtime]]', '[[regtime]]', NULL, 'view_memberships'), (13, '[[regtime]]', '[[regtime]]', NULL, 'full'), (14, '[[regtime]]', '[[regtime]]', NULL, 'owner'); -- -------------------------------------------------------- -- -- Table structure for table `webhooks` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `secret` varchar(32) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `webhook_attempts` -- 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 COLLATE utf8mb4_unicode_ci, `response` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `webhook_attempts_webhook_message_id_foreign` (`webhook_message_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `webhook_messages` -- 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) COLLATE utf8mb4_unicode_ci NOT NULL, `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `webhook_messages_webhook_id_foreign` (`webhook_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -- Constraints for dumped tables -- -- -- Constraints for table `2fa_tokens` -- ALTER TABLE `2fa_tokens` ADD CONSTRAINT `2fa_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `accounts` -- ALTER TABLE `accounts` ADD CONSTRAINT `accounts_account_type_id_foreign` FOREIGN KEY (`account_type_id`) REFERENCES `account_types` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `accounts_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `account_balances` -- ALTER TABLE `account_balances` ADD CONSTRAINT `account_balances_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `account_balances_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `account_balances_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `account_meta` -- ALTER TABLE `account_meta` ADD CONSTRAINT `account_meta_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE; -- -- Constraints for table `attachments` -- ALTER TABLE `attachments` ADD CONSTRAINT `attachments_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `attachments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `auto_budgets` -- ALTER TABLE `auto_budgets` ADD CONSTRAINT `auto_budgets_budget_id_foreign` FOREIGN KEY (`budget_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `auto_budgets_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE; -- -- Constraints for table `available_budgets` -- ALTER TABLE `available_budgets` ADD CONSTRAINT `available_budgets_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `available_budgets_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `available_budgets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `bills` -- ALTER TABLE `bills` ADD CONSTRAINT `bills_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `bills_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `bills_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `budgets` -- ALTER TABLE `budgets` ADD CONSTRAINT `budgets_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `budgets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `budget_limits` -- ALTER TABLE `budget_limits` ADD CONSTRAINT `budget_limits_budget_id_foreign` FOREIGN KEY (`budget_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `budget_limits_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE SET NULL; -- -- Constraints for table `budget_transaction` -- ALTER TABLE `budget_transaction` ADD CONSTRAINT `budget_transaction_budget_id_foreign` FOREIGN KEY (`budget_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `budget_transaction_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `budget_transaction_journal` -- ALTER TABLE `budget_transaction_journal` ADD CONSTRAINT `budget_id_foreign` FOREIGN KEY (`budget_limit_id`) REFERENCES `budget_limits` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `budget_transaction_journal_budget_id_foreign` FOREIGN KEY (`budget_id`) REFERENCES `budgets` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `budget_transaction_journal_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `categories` -- ALTER TABLE `categories` ADD CONSTRAINT `categories_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `category_transaction` -- ALTER TABLE `category_transaction` ADD CONSTRAINT `category_transaction_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `category_transaction_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `category_transaction_journal` -- ALTER TABLE `category_transaction_journal` ADD CONSTRAINT `category_transaction_journal_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `category_transaction_journal_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `currency_exchange_rates` -- ALTER TABLE `currency_exchange_rates` ADD CONSTRAINT `cer_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `currency_exchange_rates_from_currency_id_foreign` FOREIGN KEY (`from_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `currency_exchange_rates_to_currency_id_foreign` FOREIGN KEY (`to_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `currency_exchange_rates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `group_journals` -- ALTER TABLE `group_journals` ADD CONSTRAINT `group_journals_transaction_group_id_foreign` FOREIGN KEY (`transaction_group_id`) REFERENCES `transaction_groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `group_journals_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `group_memberships` -- ALTER TABLE `group_memberships` ADD CONSTRAINT `group_memberships_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `group_memberships_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `group_memberships_user_role_id_foreign` FOREIGN KEY (`user_role_id`) REFERENCES `user_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `invited_users` -- ALTER TABLE `invited_users` ADD CONSTRAINT `invited_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `journal_links` -- ALTER TABLE `journal_links` ADD CONSTRAINT `journal_links_destination_id_foreign` FOREIGN KEY (`destination_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `journal_links_link_type_id_foreign` FOREIGN KEY (`link_type_id`) REFERENCES `link_types` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `journal_links_source_id_foreign` FOREIGN KEY (`source_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `journal_meta` -- ALTER TABLE `journal_meta` ADD CONSTRAINT `journal_meta_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `limit_repetitions` -- ALTER TABLE `limit_repetitions` ADD CONSTRAINT `limit_repetitions_budget_limit_id_foreign` FOREIGN KEY (`budget_limit_id`) REFERENCES `budget_limits` (`id`) ON DELETE CASCADE; -- -- Constraints for table `object_groups` -- ALTER TABLE `object_groups` ADD CONSTRAINT `object_groups_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `object_groups_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `permission_role` -- ALTER TABLE `permission_role` ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `piggy_banks` -- ALTER TABLE `piggy_banks` ADD CONSTRAINT `piggy_banks_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE; -- -- Constraints for table `piggy_bank_events` -- ALTER TABLE `piggy_bank_events` ADD CONSTRAINT `piggy_bank_events_piggy_bank_id_foreign` FOREIGN KEY (`piggy_bank_id`) REFERENCES `piggy_banks` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `piggy_bank_events_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE SET NULL; -- -- Constraints for table `piggy_bank_repetitions` -- ALTER TABLE `piggy_bank_repetitions` ADD CONSTRAINT `piggy_bank_repetitions_piggy_bank_id_foreign` FOREIGN KEY (`piggy_bank_id`) REFERENCES `piggy_banks` (`id`) ON DELETE CASCADE; -- -- Constraints for table `preferences` -- ALTER TABLE `preferences` ADD CONSTRAINT `preferences_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `preferences_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `recurrences` -- ALTER TABLE `recurrences` ADD CONSTRAINT `recurrences_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `recurrences_transaction_type_id_foreign` FOREIGN KEY (`transaction_type_id`) REFERENCES `transaction_types` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `recurrences_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `recurrences_meta` -- ALTER TABLE `recurrences_meta` ADD CONSTRAINT `recurrences_meta_recurrence_id_foreign` FOREIGN KEY (`recurrence_id`) REFERENCES `recurrences` (`id`) ON DELETE CASCADE; -- -- Constraints for table `recurrences_repetitions` -- ALTER TABLE `recurrences_repetitions` ADD CONSTRAINT `recurrences_repetitions_recurrence_id_foreign` FOREIGN KEY (`recurrence_id`) REFERENCES `recurrences` (`id`) ON DELETE CASCADE; -- -- Constraints for table `recurrences_transactions` -- ALTER TABLE `recurrences_transactions` ADD CONSTRAINT `recurrences_transactions_destination_id_foreign` FOREIGN KEY (`destination_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `recurrences_transactions_foreign_currency_id_foreign` FOREIGN KEY (`foreign_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `recurrences_transactions_recurrence_id_foreign` FOREIGN KEY (`recurrence_id`) REFERENCES `recurrences` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `recurrences_transactions_source_id_foreign` FOREIGN KEY (`source_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `recurrences_transactions_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `type_foreign` FOREIGN KEY (`transaction_type_id`) REFERENCES `transaction_types` (`id`) ON DELETE SET NULL; -- -- Constraints for table `role_user` -- ALTER TABLE `role_user` ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `rt_meta` -- ALTER TABLE `rt_meta` ADD CONSTRAINT `rt_meta_rt_id_foreign` FOREIGN KEY (`rt_id`) REFERENCES `recurrences_transactions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `rules` -- ALTER TABLE `rules` ADD CONSTRAINT `rules_rule_group_id_foreign` FOREIGN KEY (`rule_group_id`) REFERENCES `rule_groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `rules_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `rules_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `rule_actions` -- ALTER TABLE `rule_actions` ADD CONSTRAINT `rule_actions_rule_id_foreign` FOREIGN KEY (`rule_id`) REFERENCES `rules` (`id`) ON DELETE CASCADE; -- -- Constraints for table `rule_groups` -- ALTER TABLE `rule_groups` ADD CONSTRAINT `rule_groups_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `rule_groups_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `rule_triggers` -- ALTER TABLE `rule_triggers` ADD CONSTRAINT `rule_triggers_rule_id_foreign` FOREIGN KEY (`rule_id`) REFERENCES `rules` (`id`) ON DELETE CASCADE; -- -- Constraints for table `tags` -- ALTER TABLE `tags` ADD CONSTRAINT `tags_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `tags_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `tag_transaction_journal` -- ALTER TABLE `tag_transaction_journal` ADD CONSTRAINT `tag_transaction_journal_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `tag_transaction_journal_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `transactions` -- ALTER TABLE `transactions` ADD CONSTRAINT `transactions_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transactions_foreign_currency_id_foreign` FOREIGN KEY (`foreign_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `transactions_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `transactions_transaction_journal_id_foreign` FOREIGN KEY (`transaction_journal_id`) REFERENCES `transaction_journals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `transaction_currency_user` -- ALTER TABLE `transaction_currency_user` ADD CONSTRAINT `transaction_currency_user_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transaction_currency_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `transaction_currency_user_group` -- ALTER TABLE `transaction_currency_user_group` ADD CONSTRAINT `transaction_currency_user_group_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transaction_currency_user_group_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE; -- -- Constraints for table `transaction_groups` -- ALTER TABLE `transaction_groups` ADD CONSTRAINT `transaction_groups_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `transaction_groups_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `transaction_journals` -- ALTER TABLE `transaction_journals` ADD CONSTRAINT `transaction_journals_bill_id_foreign` FOREIGN KEY (`bill_id`) REFERENCES `bills` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `transaction_journals_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `transaction_journals_transaction_currency_id_foreign` FOREIGN KEY (`transaction_currency_id`) REFERENCES `transaction_currencies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transaction_journals_transaction_group_id_foreign` FOREIGN KEY (`transaction_group_id`) REFERENCES `transaction_groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transaction_journals_transaction_type_id_foreign` FOREIGN KEY (`transaction_type_id`) REFERENCES `transaction_types` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transaction_journals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `type_user_group_id` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; -- -- Constraints for table `webhooks` -- ALTER TABLE `webhooks` ADD CONSTRAINT `webhooks_to_ugi` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `webhooks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `webhook_attempts` -- ALTER TABLE `webhook_attempts` ADD CONSTRAINT `webhook_attempts_webhook_message_id_foreign` FOREIGN KEY (`webhook_message_id`) REFERENCES `webhook_messages` (`id`) ON DELETE CASCADE; -- -- Constraints for table `webhook_messages` -- ALTER TABLE `webhook_messages` ADD CONSTRAINT `webhook_messages_webhook_id_foreign` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE; /*!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 */;