-- MySqlBackup.NET 2.3.8.0
-- Dump Time: 2026-05-04 12:15:22
-- --------------------------------------
-- Server version 11.8.6-MariaDB-0+deb13u1 from Debian -- Please help get to 10k stars at https://github.com/MariaDB/Server


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!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 */;


-- 
-- Definition of ClientGalleries
-- 

DROP TABLE IF EXISTS `ClientGalleries`;
CREATE TABLE IF NOT EXISTS `ClientGalleries` (
  `Id` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `FirstName` longtext NOT NULL,
  `LastName` longtext NOT NULL,
  `DateOfBirth` datetime(6) NOT NULL,
  `FolderName` longtext NOT NULL,
  `CreatedAt` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `OrderDate` datetime(6) DEFAULT NULL,
  `OrderSignature` longtext DEFAULT NULL,
  `PaymentAmount` decimal(65,30) DEFAULT NULL,
  `PaymentReceiptUrl` longtext DEFAULT NULL,
  `PaymentStatus` longtext DEFAULT NULL,
  `PaymentTransactionId` longtext DEFAULT NULL,
  `Email` longtext DEFAULT NULL,
  `PhoneNumber` longtext DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table ClientGalleries
-- 

/*!40000 ALTER TABLE `ClientGalleries` DISABLE KEYS */;
INSERT INTO `ClientGalleries`(`Id`,`FirstName`,`LastName`,`DateOfBirth`,`FolderName`,`CreatedAt`,`OrderDate`,`OrderSignature`,`PaymentAmount`,`PaymentReceiptUrl`,`PaymentStatus`,`PaymentTransactionId`,`Email`,`PhoneNumber`) VALUES('00000000-0000-0000-0000-000000000001','Michael','Jordan','1963-02-17 00:00:00.000000','michael-jordan','2026-05-04 03:07:17.255100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `ClientGalleries` ENABLE KEYS */;

-- 
-- Definition of ClientSelectedPhotos
-- 

DROP TABLE IF EXISTS `ClientSelectedPhotos`;
CREATE TABLE IF NOT EXISTS `ClientSelectedPhotos` (
  `Id` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `ClientGalleryId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `PhotoName` longtext DEFAULT NULL,
  `SelectedAt` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `IsOrdered` tinyint(1) NOT NULL,
  `SelectedSizes` longtext DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ClientSelectedPhotos_ClientGalleryId` (`ClientGalleryId`),
  CONSTRAINT `FK_ClientSelectedPhotos_ClientGalleries_ClientGalleryId` FOREIGN KEY (`ClientGalleryId`) REFERENCES `ClientGalleries` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table ClientSelectedPhotos
-- 

/*!40000 ALTER TABLE `ClientSelectedPhotos` DISABLE KEYS */;

/*!40000 ALTER TABLE `ClientSelectedPhotos` ENABLE KEYS */;

-- 
-- Definition of ContactUses
-- 

DROP TABLE IF EXISTS `ContactUses`;
CREATE TABLE IF NOT EXISTS `ContactUses` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `Subject` varchar(200) NOT NULL,
  `Message` longtext NOT NULL,
  `Recieved` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table ContactUses
-- 

/*!40000 ALTER TABLE `ContactUses` DISABLE KEYS */;

/*!40000 ALTER TABLE `ContactUses` ENABLE KEYS */;

-- 
-- Definition of ErrorHandlings
-- 

DROP TABLE IF EXISTS `ErrorHandlings`;
CREATE TABLE IF NOT EXISTS `ErrorHandlings` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Message` longtext DEFAULT NULL,
  `StackTrace` longtext DEFAULT NULL,
  `JsonException` longtext DEFAULT NULL,
  `Inserted` datetime(6) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table ErrorHandlings
-- 

/*!40000 ALTER TABLE `ErrorHandlings` DISABLE KEYS */;

/*!40000 ALTER TABLE `ErrorHandlings` ENABLE KEYS */;

-- 
-- Definition of Newsletters
-- 

DROP TABLE IF EXISTS `Newsletters`;
CREATE TABLE IF NOT EXISTS `Newsletters` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Email` varchar(100) NOT NULL,
  `Unsubscribe` tinyint(1) NOT NULL,
  `Registered` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table Newsletters
-- 

/*!40000 ALTER TABLE `Newsletters` DISABLE KEYS */;

/*!40000 ALTER TABLE `Newsletters` ENABLE KEYS */;

-- 
-- Definition of PhotoPackages
-- 

DROP TABLE IF EXISTS `PhotoPackages`;
CREATE TABLE IF NOT EXISTS `PhotoPackages` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` longtext NOT NULL,
  `Price` decimal(65,30) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table PhotoPackages
-- 

/*!40000 ALTER TABLE `PhotoPackages` DISABLE KEYS */;

/*!40000 ALTER TABLE `PhotoPackages` ENABLE KEYS */;

-- 
-- Definition of PhotoPackageMappings
-- 

DROP TABLE IF EXISTS `PhotoPackageMappings`;
CREATE TABLE IF NOT EXISTS `PhotoPackageMappings` (
  `Id` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `ClientGalleryId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `PhotoName` longtext DEFAULT NULL,
  `PhotoPackageId` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_PhotoPackageMappings_PhotoPackageId` (`PhotoPackageId`),
  CONSTRAINT `FK_PhotoPackageMappings_PhotoPackages_PhotoPackageId` FOREIGN KEY (`PhotoPackageId`) REFERENCES `PhotoPackages` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table PhotoPackageMappings
-- 

/*!40000 ALTER TABLE `PhotoPackageMappings` DISABLE KEYS */;

/*!40000 ALTER TABLE `PhotoPackageMappings` ENABLE KEYS */;

-- 
-- Definition of ProfileCategories
-- 

DROP TABLE IF EXISTS `ProfileCategories`;
CREATE TABLE IF NOT EXISTS `ProfileCategories` (
  `CategoryId` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL,
  `Visible` tinyint(1) NOT NULL,
  PRIMARY KEY (`CategoryId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table ProfileCategories
-- 

/*!40000 ALTER TABLE `ProfileCategories` DISABLE KEYS */;
INSERT INTO `ProfileCategories`(`CategoryId`,`Name`,`Visible`) VALUES(1,'Book design',1),(2,'Client Project',1),(3,'Logo',1),(4,'Sample Design',1),(5,'Work done',1);
/*!40000 ALTER TABLE `ProfileCategories` ENABLE KEYS */;

-- 
-- Definition of ProfileFilters
-- 

DROP TABLE IF EXISTS `ProfileFilters`;
CREATE TABLE IF NOT EXISTS `ProfileFilters` (
  `ProfileFilterId` int(11) NOT NULL AUTO_INCREMENT,
  `Text` varchar(100) NOT NULL,
  `Value` varchar(100) NOT NULL,
  `Visible` tinyint(1) NOT NULL,
  PRIMARY KEY (`ProfileFilterId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table ProfileFilters
-- 

/*!40000 ALTER TABLE `ProfileFilters` DISABLE KEYS */;
INSERT INTO `ProfileFilters`(`ProfileFilterId`,`Text`,`Value`,`Visible`) VALUES(1,'Creative','creative',1),(2,'Design','design',1),(3,'Vector','vector',1),(4,'Logo','logo',1);
/*!40000 ALTER TABLE `ProfileFilters` ENABLE KEYS */;

-- 
-- Definition of Profiles
-- 

DROP TABLE IF EXISTS `Profiles`;
CREATE TABLE IF NOT EXISTS `Profiles` (
  `ProfileId` int(11) NOT NULL AUTO_INCREMENT,
  `Thumbnail` longtext DEFAULT NULL,
  `Filename` longtext DEFAULT NULL,
  `Caption` longtext DEFAULT NULL,
  `Priority` int(11) NOT NULL,
  `CategoryId` int(11) NOT NULL,
  `ImageType` int(11) NOT NULL,
  `Visible` tinyint(1) NOT NULL,
  PRIMARY KEY (`ProfileId`),
  KEY `IX_Profiles_CategoryId` (`CategoryId`),
  CONSTRAINT `FK_Profiles_ProfileCategories_CategoryId` FOREIGN KEY (`CategoryId`) REFERENCES `ProfileCategories` (`CategoryId`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table Profiles
-- 

/*!40000 ALTER TABLE `Profiles` DISABLE KEYS */;
INSERT INTO `Profiles`(`ProfileId`,`Thumbnail`,`Filename`,`Caption`,`Priority`,`CategoryId`,`ImageType`,`Visible`) VALUES(1,'[''HappyLittleBearThumb.jpg'']','[''HappyLittleBear.jpg'']','My Book',100,1,0,1),(2,'[''MlmiaThumb.jpg'']','[''Mlmia.jpg'']',NULL,200,3,0,1),(3,'[''LogoBeeCafThumb.jpg'']','[''LogoBeeCaf.jpg'']',NULL,300,3,0,1),(4,'[''GapThumb.jpg'']','[''Gap.jpg'']',NULL,400,3,0,1),(5,'[''DancefirstThumb.jpg'', ''DanceFinalThumb.jpg'']','[''DancefirstPic.jpg'', ''DanceFinal.jpg'']','caption',500,4,1,1),(6,'[''AlergiaThumb.jpg'']','[''Alergia.jpg'']','Algergia',600,3,0,1),(7,'[''AliesetteStudioThumb.jpg'']','[''AliesetteStudio.jpg'']','Aliesette studio',700,3,0,1),(8,'[''AlergiaThumb.jpg'']','[''Alergia.jpg'']','caption',800,3,0,1),(9,'[''MarinaBeautyThumb.jpg'']','[''MarinaBeauty.jpg'']','Marina Logo',900,3,0,1),(10,'[''IllustrationThumb.jpg'']','[''IllustrationBig.jpg'']','Illustrate design',1000,2,0,1),(11,'[''cupThumb.jpg'']','[''cup.jpg'']','Cup design',1100,4,0,1),(12,'[''T-shirt2Thumb.jpg'']','[''T -shirt2.jpg'']','T - shirt design',1200,4,0,1),(13,'[''T-shirtThumb.jpg'']','[''T-shirt.jpg'']','T-shirt design',1300,4,0,1),(14,'[''BestenThumb.jpg'']','[''Besten.jpg'']','Besten logo',1400,3,0,1);
/*!40000 ALTER TABLE `Profiles` ENABLE KEYS */;

-- 
-- Definition of ProfileFilterProfile
-- 

DROP TABLE IF EXISTS `ProfileFilterProfile`;
CREATE TABLE IF NOT EXISTS `ProfileFilterProfile` (
  `ProfileId` int(11) NOT NULL,
  `ProfileFilterId` int(11) NOT NULL,
  PRIMARY KEY (`ProfileId`,`ProfileFilterId`),
  KEY `IX_ProfileFilterProfile_ProfileFilterId` (`ProfileFilterId`),
  CONSTRAINT `FK_ProfileFilterProfile_ProfileFilters_ProfileFilterId` FOREIGN KEY (`ProfileFilterId`) REFERENCES `ProfileFilters` (`ProfileFilterId`) ON DELETE CASCADE,
  CONSTRAINT `FK_ProfileFilterProfile_Profiles_ProfileId` FOREIGN KEY (`ProfileId`) REFERENCES `Profiles` (`ProfileId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table ProfileFilterProfile
-- 

/*!40000 ALTER TABLE `ProfileFilterProfile` DISABLE KEYS */;
INSERT INTO `ProfileFilterProfile`(`ProfileId`,`ProfileFilterId`) VALUES(1,1),(1,2),(5,2),(9,2),(1,3),(10,3),(2,4),(3,4),(4,4),(6,4),(7,4),(8,4),(9,4);
/*!40000 ALTER TABLE `ProfileFilterProfile` ENABLE KEYS */;

-- 
-- Definition of __EFMigrationsHistory
-- 

DROP TABLE IF EXISTS `__EFMigrationsHistory`;
CREATE TABLE IF NOT EXISTS `__EFMigrationsHistory` (
  `MigrationId` varchar(150) NOT NULL,
  `ProductVersion` varchar(32) NOT NULL,
  PRIMARY KEY (`MigrationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 
-- Dumping data for table __EFMigrationsHistory
-- 

/*!40000 ALTER TABLE `__EFMigrationsHistory` DISABLE KEYS */;
INSERT INTO `__EFMigrationsHistory`(`MigrationId`,`ProductVersion`) VALUES('20201216181955_InitMysql','9.0.0'),('20201216225424_DataSeed','9.0.0'),('20201216230246_DataSeededit','9.0.0'),('20201217212546_addErrorModel','9.0.0'),('20260426181449_AddClientGallery','9.0.0'),('20260426181625_FixDynamicDefaults','9.0.0'),('20260427021735_ChangeIdsToGuid','9.0.0'),('20260427061417_AddSizesAndSignature','9.0.0'),('20260428044309_AddPhotoPackages','9.0.0'),('20260430032837_AddPaymentFields','9.0.0'),('20260430041306_FixPhotoPackageIdType','9.0.0'),('20260503022234_AddClientContactInfo','9.0.0');
/*!40000 ALTER TABLE `__EFMigrationsHistory` ENABLE KEYS */;


/*!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 2026-05-04 12:15:22
-- Total time: 0:0:0:0:134 (d:h:m:s:ms)
