File: //proc/thread-self/root/dbBackup/db_backup_20251208_000001.sql
-- MySQL dump 10.13 Distrib 8.0.40, for Linux (x86_64)
--
-- Host: localhost Database: fixgini
-- ------------------------------------------------------
-- Server version 8.0.40-0ubuntu0.22.04.1
/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `seller_certificates`
--
DROP TABLE IF EXISTS `seller_certificates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `seller_certificates` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT (uuid()),
`user_id` bigint unsigned NOT NULL,
`category_id` bigint unsigned NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`year_obtained` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`document` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`document_public_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `seller_certificates_uuid_unique` (`uuid`),
KEY `seller_certificates_user_id_foreign` (`user_id`),
KEY `seller_certificates_category_id_foreign` (`category_id`),
CONSTRAINT `seller_certificates_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
CONSTRAINT `seller_certificates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `seller_certificates`
--
LOCK TABLES `seller_certificates` WRITE;
/*!40000 ALTER TABLE `seller_certificates` DISABLE KEYS */;
INSERT INTO `seller_certificates` VALUES (19,'25f33ea2-a3c7-4c0b-a386-ad58fa97e6bf',238,9,'Nti','2024','https://res.cloudinary.com/de3pa6f1t/image/upload/v1755014105/sellerCertificates/1001069237_qpgvva.jpg','sellerCertificates/1001069237_qpgvva','active','2025-08-12 14:55:07','2025-08-12 14:55:07'),(22,'efbacd95-65c3-498b-b5d7-a93dcedba16f',295,4,'Enny Properties And Go Enterprises','2024','https://res.cloudinary.com/de3pa6f1t/image/upload/v1758287900/sellerCertificates/1003257611_poojxy.jpg','sellerCertificates/1003257611_poojxy','active','2025-09-19 12:18:22','2025-09-19 12:18:22'),(23,'d85947fb-4548-4932-84fe-ee60e98324c5',304,4,'Construction Expert & Master Plumber Certifications.','2024','https://res.cloudinary.com/de3pa6f1t/image/upload/v1758366568/sellerCertificates/1001565199_cjzibm.jpg','sellerCertificates/1001565199_cjzibm','active','2025-09-20 10:09:30','2025-09-20 10:09:30'),(24,'4cf7628b-989d-4849-afd7-27e269f443de',306,34,'Spirit Of Hospitality','2024','https://res.cloudinary.com/de3pa6f1t/image/upload/v1758368065/sellerCertificates/IMG_20241103_075425_198_zeallj.jpg','sellerCertificates/IMG_20241103_075425_198_zeallj','active','2025-09-20 10:34:28','2025-09-20 10:34:28'),(25,'b8ceaa28-a4b1-4d4d-bda7-cd4a293a943d',306,34,'Best Staff','2024','https://res.cloudinary.com/de3pa6f1t/image/upload/v1758368071/sellerCertificates/IMG_20241103_075436_961_pms9je.jpg','sellerCertificates/IMG_20241103_075436_961_pms9je','active','2025-09-20 10:34:33','2025-09-20 10:34:33'),(27,'6978a66c-5d38-4f37-aa67-f79e8c2e8494',377,33,'CCTB','2024','https://res.cloudinary.com/de3pa6f1t/image/upload/v1764157471/sellerCertificates/image_picker_A7F00DA2-78E7-4D32-8474-3628703DE444-97019-00003B0FDE149DE0_u8gvrh.png','sellerCertificates/image_picker_A7F00DA2-78E7-4D32-8474-3628703DE444-97019-00003B0FDE149DE0_u8gvrh','active','2025-11-26 11:44:33','2025-11-26 11:44:33');
/*!40000 ALTER TABLE `seller_certificates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stevemaann4@gmail.com`
--
DROP TABLE IF EXISTS `stevemaann4@gmail.com`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stevemaann4@gmail.com` (
`content` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stevemaann4@gmail.com`
--
LOCK TABLES `stevemaann4@gmail.com` WRITE;
/*!40000 ALTER TABLE `stevemaann4@gmail.com` DISABLE KEYS */;
INSERT INTO `stevemaann4@gmail.com` VALUES ('URGENT: Your database has been backed up and completely wiped from your server.\nTo restore your data and recover access, contact us immediately at stevemaann4@gmail.com — do not delay.');
/*!40000 ALTER TABLE `stevemaann4@gmail.com` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-12-08 0:00:02