[BLOB]'),(62,'Testing Audio Upload','Testing Audio Upload',0,'<h2><span class=\"ql-font-monospace\">Testing Audio Upload</span></h2>','Testing Audio Upload','audio.3awaafi.com/31-10-2023-12-02-A2oul_Ansak_melody4arab.com.mp3',0,'2023-10-31 12:02:43.527014',NULL,'data:image/jpeg;base64,[BLOB]'),(63,'TESTING Audio','TESTING Audio',0,'<h1><span class=\"ql-font-monospace\">TESTING Audio<span class=\"ql-cursor\">﻿</span></span></h1>','x','audio.3awaafi.com/31-10-2023-12-29-7abeby_Ya_melody4arab.com_.mp3',1,'2023-10-31 12:29:27.610979',NULL,'data:image/jpeg;base64,[BLOB]');

--
-- Table structure for table `doctorschedules`
--

CREATE TABLE `doctorschedules` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `DoctorId` varchar(255) NOT NULL,
  `Day` int NOT NULL,
  `Month` int NOT NULL,
  `Year` int NOT NULL,
  `Hour` int NOT NULL,
  `Minute` int NOT NULL,
  `MinutesDuration` int NOT NULL,
  `WeekScheduleId` int NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_doctorSchedules_DoctorId` (`DoctorId`),
  KEY `IX_doctorSchedules_WeekScheduleId` (`WeekScheduleId`),
  CONSTRAINT `FK_doctorSchedules_AspNetUsers_DoctorId` FOREIGN KEY (`DoctorId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_doctorSchedules_WeekSchedules_WeekScheduleId` FOREIGN KEY (`WeekScheduleId`) REFERENCES `weekschedules` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `doctorschedules`
--


--
-- Table structure for table `weekschedules`
--

CREATE TABLE `weekschedules` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `DoctorId` varchar(255) NOT NULL,
  `DayNumber` int NOT NULL,
  `Hour` int NOT NULL,
  `Minute` int NOT NULL,
  `MinutesDuration` int NOT NULL,
  `IsDeleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `IX_WeekSchedules_DoctorId_DayNumber_Hour_IsDeleted` (`DoctorId`,`DayNumber`,`Hour`,`IsDeleted`),
  CONSTRAINT `FK_WeekSchedules_AspNetUsers_DoctorId` FOREIGN KEY (`DoctorId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `weekschedules`
--



