File: /home/xedaptot/.cpanel/logs/restoredb/2025-12-07T07:34:49Z.1.log
{"type":"info","data":{"file":"mrsimple_work.sql.gz","description":"No virus detected in upload “mrsimple_work.sql.gz”."},"name":"no-virus"}
{"data":{"archive":"/home/xedaptot/tmp/Cpanel_Form_file.upload.56995ac6","description":"The system is extracting the archive “/home/xedaptot/tmp/Cpanel_Form_file.upload.56995ac6”.","file":"mrsimple_work.sql.gz"},"name":"gunzip","type":"info"}
{"type":"debug","name":"database_name","data":{"description":"The system identified the database name for the backup file “mrsimple_work.sql.gz” to be “xedaptot_mrsimple_work”.","file":"mrsimple_work.sql.gz","database":"xedaptot_mrsimple_work"}}
{"type":"info","data":{"description":"The system created the database “xedaptot_mrsimple_work” since it did not exist.","file":"mrsimple_work.sql.gz","database":"xedaptot_mrsimple_work"},"name":"database_create"}
{"type":"debug","name":"created_temp_database_user","data":{"username":"xedaptot_fhhc5yi","file":"mrsimple_work.sql.gz","description":"The system created a temporary database user “xedaptot_fhhc5yi”."}}
{"type":"debug","data":{"database":"xedaptot_mrsimple_work","username":"xedaptot_fhhc5yi","file":"mrsimple_work.sql.gz","description":"The system linked the temporary database user “xedaptot_fhhc5yi” to the database “xedaptot_mrsimple_work”."},"name":"linked_temp_database_user_to_database"}
{"type":"info","data":{"file":"mrsimple_work.sql.gz","description":"The system is starting to restore the database backup “mrsimple_work.sql.gz”."},"name":"restoring_start"}
{"name":"restoring","data":{"description":"--------------\n/*M!999999 enable the sandbox mode */ \n\n\n\n\n\n\n/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */\n--------------\n\n--------------\n/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */\n--------------\n\n--------------\n/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */\n--------------\n\n--------------\n/*!40101 SET NAMES utf8mb4 */\n--------------\n\n--------------\n/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */\n--------------\n\n--------------\n/*!40103 SET TIME_ZONE='+00:00' */\n--------------\n\n--------------\n/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */\n--------------\n\n--------------\n/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */\n--------------\n\n--------------\n/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */\n--------------\n\n--------------\n/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */\n--------------\n\n--------------\nDROP TABLE IF EXISTS `accept_estimates`\n--------------\n\n-----------","file":"mrsimple_work.sql.gz"},"type":"debug"}
{"data":{"description":"---\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `accept_estimates` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `estimate_id` int(10) unsigned NOT NULL,\n `full_name` varchar(191) NOT NULL,\n `email` varchar(191) NOT NULL,\n `signature` varchar(191) NOT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `accept_estimates_company_id_foreign` (`company_id`),\n KEY `accept_estimates_estimate_id_foreign` (`estimate_id`),\n CONSTRAINT `accept_estimates_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `accept_estimates_estimate_id_foreign` FOREIGN KEY (`estimate_id`) REFERENCES `estimates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLL","file":"mrsimple_work.sql.gz"},"name":"restoring","type":"debug"}
{"type":"debug","name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"ATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `accept_estimates` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `accept_estimates` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `accept_estimates` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `appreciations`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `appreciations` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `award_id` bigint(20) unsigned NOT NULL,\n `award_to` int(10) unsigned NOT NULL,\n `award_date` date NOT NULL,\n `image` varchar(191) DEFAULT NULL,\n `summary` text DEFAULT NULL,\n `added_by` int(10) unsigned NOT NULL,\n `creat"}}
{"name":"restoring","data":{"description":"ed_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `appreciations_company_id_foreign` (`company_id`),\n KEY `appreciations_award_id_foreign` (`award_id`),\n KEY `appreciations_award_to_foreign` (`award_to`),\n KEY `appreciations_added_by_foreign` (`added_by`),\n CONSTRAINT `appreciations_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `appreciations_award_id_foreign` FOREIGN KEY (`award_id`) REFERENCES `awards` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `appreciations_award_to_foreign` FOREIGN KEY (`award_to`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `appreciations_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------","file":"mrsimple_work.sql.gz"},"type":"debug"}
{"data":{"description":"------\n\n--------------\nLOCK TABLES `appreciations` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `appreciations` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `appreciations` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `attendance_settings`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `attendance_settings` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `auto_clock_in` enum('yes','no') NOT NULL DEFAULT 'no',\n `auto_clock_in_location` enum('office','home') NOT NULL DEFAULT 'office',\n `office_start_time` time NOT NULL,\n `office_end_time` time NOT NULL,\n `halfday_mark_time` time DEFAULT NULL,\n `late_mark_duration` tinyint(4) NOT NULL,\n `clockin_in_day` int(11) NOT NULL DEFAULT 1,\n `employ","file":"mrsimple_work.sql.gz"},"name":"restoring","type":"debug"}
{"name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"ee_clock_in_out` enum('yes','no') NOT NULL DEFAULT 'yes',\n `office_open_days` varchar(191) NOT NULL DEFAULT '[1,2,3,4,5]',\n `ip_address` text DEFAULT NULL,\n `radius` int(11) DEFAULT NULL,\n `radius_check` enum('yes','no') NOT NULL DEFAULT 'no',\n `ip_check` enum('yes','no') NOT NULL DEFAULT 'no',\n `alert_after` int(11) DEFAULT NULL,\n `alert_after_status` tinyint(1) NOT NULL DEFAULT 1,\n `save_current_location` tinyint(1) NOT NULL DEFAULT 0,\n `default_employee_shift` bigint(20) unsigned DEFAULT 1,\n `week_start_from` varchar(191) NOT NULL DEFAULT '1',\n `allow_shift_change` tinyint(1) NOT NULL DEFAULT 1,\n `show_clock_in_button` enum('yes','no') NOT NULL DEFAULT 'no',\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n `monthly_report` tinyint(1) NOT NULL DEFAULT 0,\n `monthly_report_roles` varchar(191) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `attendance_settings_company_id_foreign` (`company_id`),\n KEY `attendance_settings_default_employee_shift_foreign` (`defaul"},"type":"debug"}
{"type":"debug","name":"restoring","data":{"description":"t_employee_shift`),\n CONSTRAINT `attendance_settings_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `attendance_settings_default_employee_shift_foreign` FOREIGN KEY (`default_employee_shift`) REFERENCES `employee_shifts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `attendance_settings` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `attendance_settings` DISABLE KEYS */\n--------------\n\n--------------\nINSERT INTO `attendance_settings` (`id`, `company_id`, `auto_clock_in`, `auto_clock_in_location`, `office_start_time`, `office_end_time`, `halfday_mark_time`, `late_mark_duration`, `clockin_in_day`, `employee_clock_in_out`, `office_open_days`, `ip_address`, `radius`, `radius_check`, `ip_check`, `alert_after`, `ale","file":"mrsimple_work.sql.gz"}}
{"type":"debug","name":"restoring","data":{"description":"rt_after_status`, `save_current_location`, `default_employee_shift`, `week_start_from`, `allow_shift_change`, `show_clock_in_button`, `created_at`, `updated_at`, `monthly_report`, `monthly_report_roles`) VALUES (1,1,'no','office','09:00:00','18:00:00',NULL,20,1,'yes','[1,2,3,4,5]',NULL,NULL,'no','no',NULL,0,0,2,'1',1,'no','2023-05-16 02:49:16','2023-05-16 02:49:16',0,NULL),(2,2,'no','office','09:00:00','18:00:00',NULL,20,1,'yes','[1,2,3,4,5]',NULL,NULL,'no','no',NULL,0,0,4,'1',1,'no','2023-11-09 08:29:01','2023-11-09 08:29:01',0,NULL)\n--------------\n\n--------------\n/*!40000 ALTER TABLE `attendance_settings` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `attendances`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `attendances` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `","file":"mrsimple_work.sql.gz"}}
{"type":"debug","name":"restoring","data":{"description":"company_id` int(10) unsigned DEFAULT NULL,\n `user_id` int(10) unsigned NOT NULL,\n `location_id` bigint(20) unsigned DEFAULT NULL,\n `clock_in_time` datetime NOT NULL,\n `clock_out_time` datetime DEFAULT NULL,\n `clock_in_ip` varchar(191) NOT NULL,\n `clock_out_ip` varchar(191) DEFAULT NULL,\n `working_from` varchar(191) DEFAULT 'office',\n `late` enum('yes','no') NOT NULL DEFAULT 'no',\n `half_day` enum('yes','no') NOT NULL,\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `latitude` decimal(10,8) DEFAULT NULL,\n `longitude` decimal(11,8) DEFAULT NULL,\n `shift_start_time` datetime DEFAULT NULL,\n `shift_end_time` datetime DEFAULT NULL,\n `employee_shift_id` bigint(20) unsigned DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n `work_from_type` enum('home','office','other') NOT NULL DEFAULT 'other',\n `overwrite_attendance` enum('yes','no') NOT NULL DEFAULT 'no',\n PRIMARY KEY (`id`),\n KEY `attendances_comp","file":"mrsimple_work.sql.gz"}}
{"type":"debug","name":"restoring","data":{"description":"any_id_foreign` (`company_id`),\n KEY `attendances_user_id_foreign` (`user_id`),\n KEY `attendances_location_id_foreign` (`location_id`),\n KEY `attendances_clock_in_time_index` (`clock_in_time`),\n KEY `attendances_clock_out_time_index` (`clock_out_time`),\n KEY `attendances_added_by_foreign` (`added_by`),\n KEY `attendances_last_updated_by_foreign` (`last_updated_by`),\n KEY `attendances_employee_shift_id_foreign` (`employee_shift_id`),\n CONSTRAINT `attendances_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `attendances_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `attendances_employee_shift_id_foreign` FOREIGN KEY (`employee_shift_id`) REFERENCES `employee_shifts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `attendances_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n","file":"mrsimple_work.sql.gz"}}
{"type":"debug","data":{"description":" CONSTRAINT `attendances_location_id_foreign` FOREIGN KEY (`location_id`) REFERENCES `company_addresses` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `attendances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `attendances` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `attendances` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `attendances` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `award_icons`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `award_icons` (\n `id` bigint(20) unsi","file":"mrsimple_work.sql.gz"},"name":"restoring"}
{"type":"debug","data":{"file":"mrsimple_work.sql.gz","description":"gned NOT NULL AUTO_INCREMENT,\n `title` varchar(191) NOT NULL,\n `icon` varchar(191) NOT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `award_icons` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `award_icons` DISABLE KEYS */\n--------------\n\n--------------\nINSERT INTO `award_icons` (`id`, `title`, `icon`, `created_at`, `updated_at`) VALUES (1,'Trophy','trophy','2023-05-16 02:49:14','2023-05-16 02:49:14'),(2,'Thumbs Up','hand-thumbs-up','2023-05-16 02:49:14','2023-05-16 02:49:14'),(3,'Award','award','2023-05-16 02:49:14','2023-05-16 02:49:14'),(4,'Book','book','2023-05-16 02:49:14','2023-05-16 02:49:14'),(5,'Gift','gift','2023-05-16 02:49:14','2023-05-16 02:49:14'),(6,'Watch','watch','2023-05-16 02:49:14','2023-05-16 02:"},"name":"restoring"}
{"name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"49:14'),(7,'Cup','cup-hot','2023-05-16 02:49:14','2023-05-16 02:49:14'),(8,'Puzzle','puzzle','2023-05-16 02:49:14','2023-05-16 02:49:14'),(9,'Plane','airplane','2023-05-16 02:49:14','2023-05-16 02:49:14'),(10,'Money','piggy-bank','2023-05-16 02:49:14','2023-05-16 02:49:14'),(11,'Trophy','trophy','2023-11-09 08:29:00','2023-11-09 08:29:00'),(12,'Thumbs Up','hand-thumbs-up','2023-11-09 08:29:00','2023-11-09 08:29:00'),(13,'Award','award','2023-11-09 08:29:00','2023-11-09 08:29:00'),(14,'Book','book','2023-11-09 08:29:00','2023-11-09 08:29:00'),(15,'Gift','gift','2023-11-09 08:29:00','2023-11-09 08:29:00'),(16,'Watch','watch','2023-11-09 08:29:00','2023-11-09 08:29:00'),(17,'Cup','cup-hot','2023-11-09 08:29:00','2023-11-09 08:29:00'),(18,'Puzzle','puzzle','2023-11-09 08:29:00','2023-11-09 08:29:00'),(19,'Plane','airplane','2023-11-09 08:29:00','2023-11-09 08:29:00'),(20,'Money','piggy-bank','2023-11-09 08:29:00','2023-11-09 08:29:00')\n--------------\n\n--------------\n/*!40000 ALTER TABLE `award_icons` ENABLE KEYS "},"type":"debug"}
{"data":{"description":"*/\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `awards`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `awards` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `title` varchar(191) NOT NULL,\n `award_icon_id` bigint(20) unsigned DEFAULT NULL,\n `summary` text DEFAULT NULL,\n `status` enum('active','inactive') NOT NULL DEFAULT 'active',\n `color_code` varchar(191) NOT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `awards_company_id_foreign` (`company_id`),\n KEY `awards_award_icon_id_foreign` (`award_icon_id`),\n CONSTRAINT `awards_award_icon_id_foreign` FOREIGN KEY (`award_icon_id`) REFERENCES `award_icons` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `","file":"mrsimple_work.sql.gz"},"name":"restoring","type":"debug"}
{"type":"debug","data":{"file":"mrsimple_work.sql.gz","description":"awards_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `awards` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `awards` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `awards` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `bank_accounts`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `bank_accounts` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `type` varchar(191) DEFAULT NULL,\n `bank_name` varchar(191) DEFAULT NULL,\n `account_name` varc"},"name":"restoring"}
{"type":"debug","name":"restoring","data":{"description":"har(191) DEFAULT NULL,\n `account_number` varchar(191) DEFAULT NULL,\n `account_type` varchar(191) DEFAULT NULL,\n `currency_id` int(10) unsigned DEFAULT NULL,\n `contact_number` varchar(191) DEFAULT NULL,\n `opening_balance` double(15,2) DEFAULT NULL,\n `bank_logo` varchar(191) DEFAULT NULL,\n `status` tinyint(1) DEFAULT NULL,\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `bank_balance` double(16,2) DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `bank_accounts_company_id_foreign` (`company_id`),\n KEY `bank_accounts_currency_id_foreign` (`currency_id`),\n KEY `bank_accounts_added_by_foreign` (`added_by`),\n KEY `bank_accounts_last_updated_by_foreign` (`last_updated_by`),\n CONSTRAINT `bank_accounts_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `bank_accounts_company_id_foreign` FOREIGN KEY (`company_id`)","file":"mrsimple_work.sql.gz"}}
{"name":"restoring","data":{"description":" REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `bank_accounts_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `bank_accounts_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `bank_accounts` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `bank_transactions`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client =","file":"mrsimple_work.sql.gz"},"type":"debug"}
{"type":"debug","name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":" utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `bank_transactions` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `bank_account_id` int(10) unsigned DEFAULT NULL,\n `payment_id` int(10) unsigned DEFAULT NULL,\n `invoice_id` int(10) unsigned DEFAULT NULL,\n `expense_id` int(10) unsigned DEFAULT NULL,\n `amount` double(15,2) DEFAULT NULL,\n `type` enum('Cr','Dr') NOT NULL DEFAULT 'Cr',\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `memo` text DEFAULT NULL,\n `transaction_relation` varchar(191) DEFAULT NULL,\n `transaction_related_to` varchar(191) DEFAULT NULL,\n `title` text DEFAULT NULL,\n `transaction_date` date DEFAULT NULL,\n `bank_balance` double(16,2) DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `bank_transactions_company_id_foreign` (`company_id`),\n KEY `bank_transactions_bank_account_id_foreign` (`bank_accoun"}}
{"name":"restoring","data":{"description":"t_id`),\n KEY `bank_transactions_payment_id_foreign` (`payment_id`),\n KEY `bank_transactions_invoice_id_foreign` (`invoice_id`),\n KEY `bank_transactions_expense_id_foreign` (`expense_id`),\n KEY `bank_transactions_added_by_foreign` (`added_by`),\n KEY `bank_transactions_last_updated_by_foreign` (`last_updated_by`),\n CONSTRAINT `bank_transactions_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `bank_transactions_bank_account_id_foreign` FOREIGN KEY (`bank_account_id`) REFERENCES `bank_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `bank_transactions_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `bank_transactions_expense_id_foreign` FOREIGN KEY (`expense_id`) REFERENCES `expenses` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `bank_transactions_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DEL","file":"mrsimple_work.sql.gz"},"type":"debug"}
{"data":{"description":"ETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `bank_transactions_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `bank_transactions_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE SET NULL ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `bank_transactions` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `bank_transactions` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `bank_transactions` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `client_categories`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------","file":"mrsimple_work.sql.gz"},"name":"restoring","type":"debug"}
{"type":"debug","name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"------\n\n--------------\nCREATE TABLE `client_categories` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `category_name` varchar(191) NOT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `client_categories_company_id_foreign` (`company_id`),\n CONSTRAINT `client_categories_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `client_categories` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_categories` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_categories` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `client_contacts"}}
{"type":"debug","name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `client_contacts` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `user_id` int(10) unsigned NOT NULL,\n `contact_name` varchar(191) NOT NULL,\n `phone` varchar(191) DEFAULT NULL,\n `email` varchar(191) DEFAULT NULL,\n `title` varchar(191) DEFAULT NULL,\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `client_contacts_company_id_foreign` (`company_id`),\n KEY `client_contacts_user_id_foreign` (`user_id`),\n KEY `client_contacts_added_by_foreign` (`added_by`),\n KEY `client_contacts_last_updated_by_foreign` (`last_updated_by`),\n CONSTRAINT `client_contacts_added_by_foreign` FOREIGN KEY ("}}
{"data":{"description":"`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `client_contacts_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `client_contacts_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `client_contacts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `client_contacts` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_contacts` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_contacts` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `client_details`\n--------------","file":"mrsimple_work.sql.gz"},"name":"restoring","type":"debug"}
{"name":"restoring","data":{"description":"\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `client_details` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `user_id` int(10) unsigned NOT NULL,\n `company_name` varchar(191) DEFAULT NULL,\n `address` text DEFAULT NULL,\n `shipping_address` text DEFAULT NULL,\n `postal_code` varchar(191) DEFAULT NULL,\n `state` varchar(191) DEFAULT NULL,\n `city` varchar(191) DEFAULT NULL,\n `office` varchar(191) DEFAULT NULL,\n `website` varchar(191) DEFAULT NULL,\n `note` text DEFAULT NULL,\n `linkedin` varchar(191) DEFAULT NULL,\n `facebook` varchar(191) DEFAULT NULL,\n `twitter` varchar(191) DEFAULT NULL,\n `skype` varchar(191) DEFAULT NULL,\n `tax_name` varchar(191) DEFAULT NULL,\n `gst_number` varchar(191) DEFAULT NULL,\n `category_id` bigint(20) unsigned DEFAULT NULL,\n `sub_category_id` bigint(20) unsigned DEFAUL","file":"mrsimple_work.sql.gz"},"type":"debug"}
{"name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"T NULL,\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `company_logo` varchar(191) DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n `quickbooks_client_id` int(11) DEFAULT NULL,\n `electronic_address` varchar(191) DEFAULT NULL,\n `electronic_address_scheme` varchar(191) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `client_details_company_id_foreign` (`company_id`),\n KEY `client_details_user_id_foreign` (`user_id`),\n KEY `client_details_category_id_foreign` (`category_id`),\n KEY `client_details_sub_category_id_foreign` (`sub_category_id`),\n KEY `client_details_added_by_foreign` (`added_by`),\n KEY `client_details_last_updated_by_foreign` (`last_updated_by`),\n CONSTRAINT `client_details_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `client_details_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `client_categories` (`id`) O"},"type":"debug"}
{"data":{"file":"mrsimple_work.sql.gz","description":"N DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `client_details_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `client_details_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `client_details_sub_category_id_foreign` FOREIGN KEY (`sub_category_id`) REFERENCES `client_sub_categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `client_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `client_details` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_details` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_details` ENABLE KEYS */\n-------"},"name":"restoring","type":"debug"}
{"data":{"description":"-------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `client_docs`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `client_docs` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `user_id` int(10) unsigned NOT NULL,\n `name` varchar(200) NOT NULL,\n `filename` varchar(200) NOT NULL,\n `hashname` varchar(200) NOT NULL,\n `size` varchar(200) DEFAULT NULL,\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `client_docs_company_id_foreign` (`company_id`),\n KEY `client_docs_user_id_foreign` (`user_id`),\n KEY `client_docs_added_by_foreign` (`added_by`),\n KEY `client_docs_last_updated_by_foreign` (`last_upda","file":"mrsimple_work.sql.gz"},"name":"restoring","type":"debug"}
{"type":"debug","data":{"description":"ted_by`),\n CONSTRAINT `client_docs_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `client_docs_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `client_docs_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `client_docs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `client_docs` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_docs` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_docs` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABL","file":"mrsimple_work.sql.gz"},"name":"restoring"}
{"type":"debug","data":{"description":"E IF EXISTS `client_notes`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `client_notes` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `client_id` int(10) unsigned DEFAULT NULL,\n `title` varchar(191) NOT NULL,\n `type` tinyint(1) NOT NULL DEFAULT 0,\n `member_id` int(10) unsigned DEFAULT NULL,\n `is_client_show` tinyint(1) NOT NULL DEFAULT 0,\n `ask_password` tinyint(1) NOT NULL DEFAULT 0,\n `details` longtext NOT NULL,\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `client_notes_company_id_foreign` (`company_id`),\n KEY `client_notes_client_id_foreign` (`client_id`),\n KEY `client_notes_member_id_foreign` (`member_id`),\n KEY `cl","file":"mrsimple_work.sql.gz"},"name":"restoring"}
{"data":{"description":"ient_notes_added_by_foreign` (`added_by`),\n KEY `client_notes_last_updated_by_foreign` (`last_updated_by`),\n CONSTRAINT `client_notes_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `client_notes_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `client_notes_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `client_notes_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `client_notes_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `client_notes` WRITE\n-----","file":"mrsimple_work.sql.gz"},"name":"restoring","type":"debug"}
{"data":{"file":"mrsimple_work.sql.gz","description":"---------\n\n--------------\n/*!40000 ALTER TABLE `client_notes` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_notes` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `client_sub_categories`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `client_sub_categories` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `category_id` bigint(20) unsigned NOT NULL,\n `category_name` varchar(191) NOT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `client_sub_categories_company_id_foreign` (`company_id`),\n KEY `client_sub_categories_category_id_foreign` (`category_id`),\n CONSTRAINT `client_sub_categories_category_id_foreign` FOREIGN KEY (`cate"},"name":"restoring","type":"debug"}
{"type":"debug","name":"restoring","data":{"description":"gory_id`) REFERENCES `client_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `client_sub_categories_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `client_sub_categories` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_sub_categories` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_sub_categories` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `client_user_notes`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `client_user_notes` (\n `id` int(10) unsigned NO","file":"mrsimple_work.sql.gz"}}
{"data":{"file":"mrsimple_work.sql.gz","description":"T NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `user_id` int(10) unsigned NOT NULL,\n `client_note_id` int(10) unsigned NOT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `client_user_notes_company_id_foreign` (`company_id`),\n KEY `client_user_notes_user_id_foreign` (`user_id`),\n KEY `client_user_notes_client_note_id_foreign` (`client_note_id`),\n CONSTRAINT `client_user_notes_client_note_id_foreign` FOREIGN KEY (`client_note_id`) REFERENCES `client_notes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `client_user_notes_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `client_user_notes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @sa"},"name":"restoring","type":"debug"}
{"data":{"file":"mrsimple_work.sql.gz","description":"ved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `client_user_notes` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_user_notes` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `client_user_notes` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `companies`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `companies` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_name` varchar(191) NOT NULL,\n `app_name` varchar(191) DEFAULT NULL,\n `company_email` varchar(191) NOT NULL,\n `company_phone` varchar(191) NOT NULL,\n `logo` varchar(191) DEFAULT NULL,\n `light_logo` varchar(191) DEFAULT NULL,\n `favicon` varchar(191) DEFAULT NULL,\n `auth_theme` enum('dark','light') NOT NULL DEFAULT 'light',\n `auth_theme_text` enum('dark','li"},"name":"restoring","type":"debug"}
{"type":"debug","name":"restoring","data":{"description":"ght') NOT NULL DEFAULT 'dark',\n `sidebar_logo_style` enum('square','full') NOT NULL DEFAULT 'square',\n `login_background` varchar(191) DEFAULT NULL,\n `address` text NOT NULL,\n `website` varchar(191) DEFAULT NULL,\n `currency_id` int(10) unsigned DEFAULT NULL,\n `timezone` varchar(191) NOT NULL DEFAULT 'Asia/Kolkata',\n `date_format` varchar(20) NOT NULL DEFAULT 'd-m-Y',\n `date_picker_format` varchar(191) NOT NULL DEFAULT 'dd-mm-yyyy',\n `year_starts_from` varchar(191) NOT NULL DEFAULT '1',\n `moment_format` varchar(191) NOT NULL DEFAULT 'DD-MM-YYYY',\n `time_format` varchar(20) NOT NULL DEFAULT 'h:i a',\n `locale` varchar(191) NOT NULL DEFAULT 'en',\n `latitude` decimal(10,8) NOT NULL DEFAULT 26.91243360,\n `longitude` decimal(11,8) NOT NULL DEFAULT 75.78727090,\n `leaves_start_from` enum('joining_date','year_start') NOT NULL DEFAULT 'joining_date',\n `active_theme` enum('default','custom') NOT NULL DEFAULT 'default',\n `status` enum('active','inactive') NOT NULL DEFAULT 'active',\n `last_updated_by` int","file":"mrsimple_work.sql.gz"}}
{"name":"restoring","data":{"description":"(10) unsigned DEFAULT NULL,\n `google_map_key` varchar(191) DEFAULT NULL,\n `task_self` enum('yes','no') NOT NULL DEFAULT 'yes',\n `rounded_theme` tinyint(1) NOT NULL DEFAULT 1,\n `logo_background_color` varchar(191) NOT NULL DEFAULT '#ffffff',\n `header_color` varchar(191) NOT NULL DEFAULT '#1D82F5',\n `before_days` int(11) NOT NULL,\n `after_days` int(11) NOT NULL,\n `on_deadline` enum('yes','no') NOT NULL DEFAULT 'yes',\n `default_task_status` int(10) unsigned DEFAULT NULL,\n `dashboard_clock` tinyint(1) NOT NULL DEFAULT 1,\n `ticket_form_google_captcha` tinyint(1) NOT NULL DEFAULT 0,\n `lead_form_google_captcha` tinyint(1) NOT NULL DEFAULT 0,\n `taskboard_length` int(11) NOT NULL DEFAULT 10,\n `datatable_row_limit` int(11) NOT NULL DEFAULT 10,\n `allow_client_signup` tinyint(1) NOT NULL,\n `admin_client_signup_approval` tinyint(1) NOT NULL,\n `google_calendar_status` enum('active','inactive') NOT NULL DEFAULT 'inactive',\n `google_client_id` text DEFAULT NULL,\n `google_client_secret` text DEFAULT NULL,\n ","file":"mrsimple_work.sql.gz"},"type":"debug"}
{"name":"restoring","data":{"description":" `google_calendar_verification_status` enum('verified','non_verified') NOT NULL DEFAULT 'non_verified',\n `google_id` varchar(191) DEFAULT NULL,\n `name` varchar(191) DEFAULT NULL,\n `token` text DEFAULT NULL,\n `hash` varchar(191) DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n `last_login` datetime DEFAULT NULL,\n `rtl` tinyint(1) NOT NULL DEFAULT 0,\n `show_new_webhook_alert` tinyint(1) NOT NULL DEFAULT 0,\n `pm_type` varchar(191) DEFAULT NULL,\n `pm_last_four` varchar(191) DEFAULT NULL,\n `employee_can_export_data` tinyint(1) NOT NULL DEFAULT 1,\n `headers` text DEFAULT NULL,\n `register_ip` varchar(191) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `companies_currency_id_foreign` (`currency_id`),\n KEY `companies_last_updated_by_foreign` (`last_updated_by`),\n KEY `companies_default_task_status_foreign` (`default_task_status`),\n CONSTRAINT `companies_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE ON UP","file":"mrsimple_work.sql.gz"},"type":"debug"}
{"data":{"file":"mrsimple_work.sql.gz","description":"DATE CASCADE,\n CONSTRAINT `companies_default_task_status_foreign` FOREIGN KEY (`default_task_status`) REFERENCES `taskboard_columns` (`id`) ON UPDATE CASCADE,\n CONSTRAINT `companies_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `companies` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `companies` DISABLE KEYS */\n--------------\n\n--------------\nINSERT INTO `companies` (`id`, `company_name`, `app_name`, `company_email`, `company_phone`, `logo`, `light_logo`, `favicon`, `auth_theme`, `auth_theme_text`, `sidebar_logo_style`, `login_background`, `address`, `website`, `currency_id`, `timezone`, `date_format`, `date_picker_format`, `year_starts_from`, `moment_format`, `time_format`, `locale`, `latitude`, `longitude`, `le"},"name":"restoring","type":"debug"}
{"data":{"file":"mrsimple_work.sql.gz","description":"aves_start_from`, `active_theme`, `status`, `last_updated_by`, `google_map_key`, `task_self`, `rounded_theme`, `logo_background_color`, `header_color`, `before_days`, `after_days`, `on_deadline`, `default_task_status`, `dashboard_clock`, `ticket_form_google_captcha`, `lead_form_google_captcha`, `taskboard_length`, `datatable_row_limit`, `allow_client_signup`, `admin_client_signup_approval`, `google_calendar_status`, `google_client_id`, `google_client_secret`, `google_calendar_verification_status`, `google_id`, `name`, `token`, `hash`, `created_at`, `updated_at`, `last_login`, `rtl`, `show_new_webhook_alert`, `pm_type`, `pm_last_four`, `employee_can_export_data`, `headers`, `register_ip`) VALUES (1,'Phú Quốc Agency','Phú Quốc Agency','[email protected]','+84 36 581 0086','b0a26e48b40118a2e73a537aaef42da3.png','2270d52602f2806308cb166ea8bd0f2e.png','0f6233e7ac63de31060520ec6d726e4a.png','light','dark','square',NULL,'Your Company address here','https://naniguide.com/',5,'Asia/Ho_Chi_Minh','d-m-Y','dd-m"},"name":"restoring","type":"debug"}
{"type":"debug","data":{"file":"mrsimple_work.sql.gz","description":"m-yyyy','1','DD-MM-YYYY','H:i','vi',26.91243360,75.78727090,'joining_date','default','active',1,NULL,'yes',1,'#FFFFFF','#1D82F5',0,0,'yes',1,0,0,0,10,10,1,0,'inactive',NULL,NULL,'non_verified',NULL,NULL,NULL,'219085ea0d6ee552a2b6b9b6370c6b19','2023-05-16 02:49:16','2024-04-27 10:16:35',NULL,0,0,NULL,NULL,1,NULL,NULL),(2,'Worksuite','Worksuite','[email protected]','1234567891','b0a26e48b40118a2e73a537aaef42da3.png','2270d52602f2806308cb166ea8bd0f2e.png','0f6233e7ac63de31060520ec6d726e4a.png','light','dark','square',NULL,'Your Company address here','https://worksuite.biz',6,'Asia/Kolkata','d-m-Y','dd-mm-yyyy','1','DD-MM-YYYY','H:i','en',26.91243360,75.78727090,'joining_date','default','active',NULL,NULL,'yes',1,'#FFFFFF','#1D82F5',0,0,'yes',5,1,0,0,10,10,0,0,'inactive',NULL,NULL,'non_verified',NULL,NULL,NULL,'d6e997bc29114476818d3f443ba3d75e','2023-11-09 08:29:01','2023-11-09 08:29:01',NULL,0,0,NULL,NULL,1,NULL,NULL)\n--------------\n\n--------------\n/*!40000 ALTER TABLE `companies` ENABLE KEYS */\n--------------\n\n"},"name":"restoring"}
{"type":"debug","name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `company_addresses`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `company_addresses` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `country_id` int(10) unsigned DEFAULT NULL,\n `address` mediumtext NOT NULL,\n `is_default` tinyint(1) NOT NULL,\n `tax_number` varchar(191) DEFAULT NULL,\n `tax_name` varchar(191) DEFAULT NULL,\n `location` varchar(191) DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n `latitude` decimal(10,8) DEFAULT NULL,\n `longitude` decimal(11,8) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `company_addresses_company_id_foreign` (`company_id`),\n KEY `company_addresses_country_id_foreign` (`country_id`),\n CONSTRAINT `company_addresses_comp"}}
{"type":"debug","name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"any_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `company_addresses_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `company_addresses` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `company_addresses` DISABLE KEYS */\n--------------\n\n--------------\nINSERT INTO `company_addresses` (`id`, `company_id`, `country_id`, `address`, `is_default`, `tax_number`, `tax_name`, `location`, `created_at`, `updated_at`, `latitude`, `longitude`) VALUES (1,1,NULL,'335 Nguyen Trung Truc, Duong Dong, Tp.Phu Quoc, Kien Giang',1,'1702274892','MST','335 Nguyễn Trung Trực, Dương Đông Phú Quốc','2023-05-16 02:49:16','2023-05-16 03:01:53',NULL,NULL),(2,2,NULL,'Your Company address he"}}
{"data":{"file":"mrsimple_work.sql.gz","description":"re',1,NULL,NULL,'Worksuite','2023-11-09 08:29:01','2023-11-09 08:29:01',NULL,NULL)\n--------------\n\n--------------\n/*!40000 ALTER TABLE `company_addresses` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `contract_discussions`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `contract_discussions` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `contract_id` bigint(20) unsigned NOT NULL,\n `from` int(10) unsigned NOT NULL,\n `message` longtext NOT NULL,\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `contract_discussions_company_id_foreign` (`company_id`),\n KEY `contrac"},"name":"restoring","type":"debug"}
{"type":"debug","data":{"file":"mrsimple_work.sql.gz","description":"t_discussions_contract_id_foreign` (`contract_id`),\n KEY `contract_discussions_from_foreign` (`from`),\n KEY `contract_discussions_added_by_foreign` (`added_by`),\n KEY `contract_discussions_last_updated_by_foreign` (`last_updated_by`),\n CONSTRAINT `contract_discussions_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `contract_discussions_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contract_discussions_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES `contracts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contract_discussions_from_foreign` FOREIGN KEY (`from`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contract_discussions_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_"},"name":"restoring"}
{"data":{"description":"unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `contract_discussions` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_discussions` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_discussions` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `contract_files`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `contract_files` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `user_id` int(10) unsigned NOT NULL,\n `contract_id` bigint(20) unsigned NOT NULL,\n `filename` varchar(191) NOT NULL,\n `hashname` varchar(191) NOT NULL,\n `size` varchar(191) NOT NULL,\n `google_url` varchar(191) NOT NULL,\n `","file":"mrsimple_work.sql.gz"},"name":"restoring","type":"debug"}
{"name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"dropbox_link` varchar(191) NOT NULL,\n `external_link_name` varchar(191) NOT NULL,\n `external_link` varchar(191) NOT NULL,\n `description` text DEFAULT NULL,\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `contract_files_company_id_foreign` (`company_id`),\n KEY `contract_files_user_id_foreign` (`user_id`),\n KEY `contract_files_contract_id_foreign` (`contract_id`),\n KEY `contract_files_added_by_foreign` (`added_by`),\n KEY `contract_files_last_updated_by_foreign` (`last_updated_by`),\n CONSTRAINT `contract_files_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `contract_files_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contract_files_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES "},"type":"debug"}
{"data":{"file":"mrsimple_work.sql.gz","description":"`contracts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contract_files_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `contract_files_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `contract_files` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_files` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_files` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `contract_renews`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n-----------"},"name":"restoring","type":"debug"}
{"type":"debug","data":{"description":"---\n\n--------------\nCREATE TABLE `contract_renews` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `renewed_by` int(10) unsigned NOT NULL,\n `contract_id` bigint(20) unsigned NOT NULL,\n `start_date` date NOT NULL,\n `end_date` date NOT NULL,\n `amount` decimal(12,2) NOT NULL,\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `contract_renews_company_id_foreign` (`company_id`),\n KEY `contract_renews_renewed_by_foreign` (`renewed_by`),\n KEY `contract_renews_contract_id_foreign` (`contract_id`),\n KEY `contract_renews_added_by_foreign` (`added_by`),\n KEY `contract_renews_last_updated_by_foreign` (`last_updated_by`),\n CONSTRAINT `contract_renews_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `contract_renews_company_id_foreig","file":"mrsimple_work.sql.gz"},"name":"restoring"}
{"type":"debug","data":{"file":"mrsimple_work.sql.gz","description":"n` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contract_renews_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES `contracts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contract_renews_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `contract_renews_renewed_by_foreign` FOREIGN KEY (`renewed_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `contract_renews` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_renews` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_renews` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `c"},"name":"restoring"}
{"type":"debug","data":{"description":"ontract_signs`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `contract_signs` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `contract_id` bigint(20) unsigned NOT NULL,\n `full_name` varchar(191) NOT NULL,\n `email` varchar(191) NOT NULL,\n `signature` varchar(191) NOT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n `place` varchar(191) DEFAULT NULL,\n `date` varchar(191) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `contract_signs_contract_id_foreign` (`contract_id`),\n KEY `contract_signs_company_id_foreign` (`company_id`),\n CONSTRAINT `contract_signs_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contract_signs_contract_id_foreign` FOREIGN KEY (`contract_id`) RE","file":"mrsimple_work.sql.gz"},"name":"restoring"}
{"name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"FERENCES `contracts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `contract_signs` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_signs` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_signs` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `contract_templates`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `contract_templates` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `contract_template_number` bigint(20) DEFAULT NULL,\n `company_id` int(10) unsigned DEFAULT NULL,\n `subject` varchar(191) NOT NULL,\n `description` longtext DEF"},"type":"debug"}
{"type":"debug","name":"restoring","data":{"description":"AULT NULL,\n `amount` varchar(191) NOT NULL,\n `contract_type_id` bigint(20) unsigned NOT NULL,\n `currency_id` int(10) unsigned DEFAULT NULL,\n `contract_detail` longtext DEFAULT NULL,\n `added_by` int(11) NOT NULL DEFAULT 1,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `contract_templates_company_id_foreign` (`company_id`),\n KEY `contract_templates_contract_type_id_foreign` (`contract_type_id`),\n KEY `contract_templates_currency_id_foreign` (`currency_id`),\n CONSTRAINT `contract_templates_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contract_templates_contract_type_id_foreign` FOREIGN KEY (`contract_type_id`) REFERENCES `contract_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contract_templates_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHA","file":"mrsimple_work.sql.gz"}}
{"name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"RSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `contract_templates` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_templates` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_templates` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `contract_types`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `contract_types` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `name` varchar(191) NOT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `contract_types_company_id_foreign` (`company_id`),\n CO"},"type":"debug"}
{"type":"debug","data":{"file":"mrsimple_work.sql.gz","description":"NSTRAINT `contract_types_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `contract_types` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_types` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contract_types` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `contracts`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `contracts` (\n `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n `contract_number` varchar(191) DEFAULT NULL,\n `original_contract_number` varchar(191) DEFAULT NULL,\n `c"},"name":"restoring"}
{"data":{"file":"mrsimple_work.sql.gz","description":"ompany_id` int(10) unsigned DEFAULT NULL,\n `client_id` int(10) unsigned NOT NULL,\n `project_id` int(10) unsigned DEFAULT NULL,\n `subject` varchar(191) NOT NULL,\n `amount` varchar(191) NOT NULL,\n `original_amount` decimal(15,2) NOT NULL,\n `contract_type_id` bigint(20) unsigned DEFAULT NULL,\n `start_date` date NOT NULL,\n `original_start_date` date NOT NULL,\n `end_date` date DEFAULT NULL,\n `original_end_date` date DEFAULT NULL,\n `description` longtext DEFAULT NULL,\n `contract_name` varchar(191) DEFAULT NULL,\n `alternate_address` varchar(191) DEFAULT NULL,\n `contract_note` text DEFAULT NULL,\n `cell` varchar(191) DEFAULT NULL,\n `office` varchar(191) DEFAULT NULL,\n `city` varchar(191) DEFAULT NULL,\n `state` varchar(191) DEFAULT NULL,\n `country` varchar(191) DEFAULT NULL,\n `postal_code` varchar(191) DEFAULT NULL,\n `contract_detail` longtext DEFAULT NULL,\n `added_by` int(10) unsigned DEFAULT NULL,\n `last_updated_by` int(10) unsigned DEFAULT NULL,\n `hash` text DEFAULT NULL,\n `currency_id` int("},"name":"restoring","type":"debug"}
{"type":"debug","name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"10) unsigned DEFAULT NULL,\n `event_id` text DEFAULT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n `company_sign` varchar(191) DEFAULT NULL,\n `sign_date` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `contracts_company_id_foreign` (`company_id`),\n KEY `contracts_client_id_foreign` (`client_id`),\n KEY `contracts_contract_type_id_foreign` (`contract_type_id`),\n KEY `contracts_added_by_foreign` (`added_by`),\n KEY `contracts_last_updated_by_foreign` (`last_updated_by`),\n KEY `contracts_currency_id_foreign` (`currency_id`),\n KEY `contracts_project_id_foreign` (`project_id`),\n CONSTRAINT `contracts_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `contracts_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contracts_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON "}}
{"name":"restoring","data":{"description":"UPDATE CASCADE,\n CONSTRAINT `contracts_contract_type_id_foreign` FOREIGN KEY (`contract_type_id`) REFERENCES `contract_types` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `contracts_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `contracts_last_updated_by_foreign` FOREIGN KEY (`last_updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `contracts_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `contracts` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contracts` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `contracts` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n-----------","file":"mrsimple_work.sql.gz"},"type":"debug"}
{"data":{"file":"mrsimple_work.sql.gz","description":"---\n\n--------------\nDROP TABLE IF EXISTS `conversation`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `conversation` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `user_one` int(10) unsigned NOT NULL,\n `user_two` int(10) unsigned NOT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `conversation_company_id_foreign` (`company_id`),\n KEY `conversation_user_one_foreign` (`user_one`),\n KEY `conversation_user_two_foreign` (`user_two`),\n CONSTRAINT `conversation_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client "},"name":"restoring","type":"debug"}
{"name":"restoring","data":{"description":"*/\n--------------\n\n--------------\nLOCK TABLES `conversation` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `conversation` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `conversation` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `conversation_reply`\n--------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `conversation_reply` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `company_id` int(10) unsigned DEFAULT NULL,\n `conversation_id` int(10) unsigned NOT NULL,\n `reply` text NOT NULL,\n `user_id` int(10) unsigned NOT NULL,\n `created_at` timestamp NULL DEFAULT NULL,\n `updated_at` timestamp NULL DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `conversation_reply_company_id_foreign` (`company_id`),\n KEY `conversation_reply_conversation_id_foreign` (`conve","file":"mrsimple_work.sql.gz"},"type":"debug"}
{"data":{"file":"mrsimple_work.sql.gz","description":"rsation_id`),\n KEY `conversation_reply_user_id_foreign` (`user_id`),\n CONSTRAINT `conversation_reply_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `conversation_reply_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `conversation_reply_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `conversation_reply` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `conversation_reply` DISABLE KEYS */\n--------------\n\n--------------\n/*!40000 ALTER TABLE `conversation_reply` ENABLE KEYS */\n--------------\n\n--------------\nUNLOCK TABLES\n--------------\n\n--------------\nDROP TABLE IF EXISTS `countries`\n-"},"name":"restoring","type":"debug"}
{"type":"debug","name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":"-------------\n\n--------------\n/*!40101 SET @saved_cs_client = @@character_set_client */\n--------------\n\n--------------\n/*!40101 SET character_set_client = utf8mb4 */\n--------------\n\n--------------\nCREATE TABLE `countries` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `iso` char(2) NOT NULL,\n `name` varchar(80) NOT NULL,\n `nicename` varchar(80) NOT NULL,\n `iso3` char(3) DEFAULT NULL,\n `numcode` smallint(6) DEFAULT NULL,\n `phonecode` int(11) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=254 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci\n--------------\n\n--------------\n/*!40101 SET character_set_client = @saved_cs_client */\n--------------\n\n--------------\nLOCK TABLES `countries` WRITE\n--------------\n\n--------------\n/*!40000 ALTER TABLE `countries` DISABLE KEYS */\n--------------\n\n--------------\nINSERT INTO `countries` (`id`, `iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`) VALUES (1,'AF','AFGHANISTAN','Afghanistan','AFG',4,93),(2,'AL','ALBANIA','Albania','ALB',8,355),(3"}}
{"name":"restoring","data":{"file":"mrsimple_work.sql.gz","description":",'DZ','ALGERIA','Algeria','DZA',12,213),(4,'AS','AMERICAN SAMOA','American Samoa','ASM',16,1684),(5,'AD','ANDORRA','Andorra','AND',20,376),(6,'AO','ANGOLA','Angola','AGO',24,244),(7,'AI','ANGUILLA','Anguilla','AIA',660,1264),(8,'AQ','ANTARCTICA','Antarctica',NULL,NULL,0),(9,'AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG',28,1268),(10,'AR','ARGENTINA','Argentina','ARG',32,54),(11,'AM','ARMENIA','Armenia','ARM',51,374),(12,'AW','ARUBA','Aruba','ABW',533,297),(13,'AU','AUSTRALIA','Australia','AUS',36,61),(14,'AT','AUSTRIA','Austria','AUT',40,43),(15,'AZ','AZERBAIJAN','Azerbaijan','AZE',31,994),(16,'BS','BAHAMAS','Bahamas','BHS',44,1242),(17,'BH','BAHRAIN','Bahrain','BHR',48,973),(18,'BD','BANGLADESH','Bangladesh','BGD',50,880),(19,'BB','BARBADOS','Barbados','BRB',52,1246),(20,'BY','BELARUS','Belarus','BLR',112,375),(21,'BE','BELGIUM','Belgium','BEL',56,32),(22,'BZ','BELIZE','Belize','BLZ',84,501),(23,'BJ','BENIN','Benin','BEN',204,229),(24,'BM','BERMUDA','Bermuda','BMU',60,1441),(25,'BT','BHUTAN','Bhutan'"},"type":"debug"}
{"data":{"file":"mrsimple_work.sql.gz","description":",'BTN',64,975),(26,'BO','BOLIVIA','Bolivia','BOL',68,591),(27,'BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH',70,387),(28,'BW','BOTSWANA','Botswana','BWA',72,267),(29,'BV','BOUVET ISLAND','Bouvet Island',NULL,NULL,0),(30,'BR','BRAZIL','Brazil','BRA',76,55),(31,'IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL,246),(32,'BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN',96,673),(33,'BG','BULGARIA','Bulgaria','BGR',100,359),(34,'BF','BURKINA FASO','Burkina Faso','BFA',854,226),(35,'BI','BURUNDI','Burundi','BDI',108,257),(36,'KH','CAMBODIA','Cambodia','KHM',116,855),(37,'CM','CAMEROON','Cameroon','CMR',120,237),(38,'CA','CANADA','Canada','CAN',124,1),(39,'CV','CAPE VERDE','Cape Verde','CPV',132,238),(40,'KY','CAYMAN ISLANDS','Cayman Islands','CYM',136,1345),(41,'CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF',140,236),(42,'TD','CHAD','Chad','TCD',148,235),(43,'CL','CHILE','Chile','CHL',152,56),(44,'CN','CHINA','China','CHN',156,86),(45,'CX','CHRISTMAS IS"},"name":"restoring","type":"debug"}
{"type":"debug","data":{"description":"LAND','Christmas Island',NULL,NULL,61),(46,'CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL,672),(47,'CO','COLOMBIA','Colombia','COL',170,57),(48,'KM','COMOROS','Comoros','COM',174,269),(49,'CG','CONGO','Congo','COG',178,242),(50,'CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD',180,242),(51,'CK','COOK ISLANDS','Cook Islands','COK',184,682),(52,'CR','COSTA RICA','Costa Rica','CRI',188,506),(53,'CI','COTE D\\'IVOIRE','Cote D\\'Ivoire','CIV',384,225),(54,'HR','CROATIA','Croatia','HRV',191,385),(55,'CU','CUBA','Cuba','CUB',192,53),(56,'CY','CYPRUS','Cyprus','CYP',196,357),(57,'CZ','CZECH REPUBLIC','Czech Republic','CZE',203,420),(58,'DK','DENMARK','Denmark','DNK',208,45),(59,'DJ','DJIBOUTI','Djibouti','DJI',262,253),(60,'DM','DOMINICA','Dominica','DMA',212,1767),(61,'DO','DOMINICAN REPUBLIC','Dominican Republic','DOM',214,1809),(62,'EC','ECUADOR','Ecuador','ECU',218,593),(63,'EG','EGYPT','Egypt','EGY',818,20),(64,'SV','EL SALVADOR','El Salvador','SLV',222,","file":"mrsimple_work.sql.gz"},"name":"restoring"}
{"type":"debug","data":{"file":"mrsimple_work.sql.gz","description":"…","truncated":1},"name":"restoring"}
{"type":"debug","data":{"file":"mrsimple_work.sql.gz","description":"The system removed the temporary database user “xedaptot_fhhc5yi”.","username":"xedaptot_fhhc5yi"},"name":"removed_temp_database_user"}
{"type":"done","data":{"description":"The system successfully restored the database “xedaptot_mrsimple_work” from the backup file “mrsimple_work.sql.gz”.","file":"mrsimple_work.sql.gz"},"name":"restore_done"}
{"data":{"file":"mrsimple_work.sql.gz"},"name":"processed","type":"info"}
{"type":"close"}