--
-- Host: localhost    Database: 3awaafi
-- ------------------------------------------------------


--
-- Table structure for table `__efmigrationshistory`
--

CREATE TABLE `__efmigrationshistory` (
  `MigrationId` varchar(150) NOT NULL,
  `ProductVersion` varchar(32) NOT NULL,
  PRIMARY KEY (`MigrationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `__efmigrationshistory`
--

INSERT INTO `__efmigrationshistory` VALUES ('20230404083812_initUser','7.0.4'),('20230410084008_adduser_gender_birth','7.0.4'),('20230704092207_edituserstatus','7.0.4'),('20230708124025_addTableAU','7.0.4'),('20230720151508_addcliptable','7.0.4'),('20230726112233_editEntities','7.0.4'),('20230726121041_activeColDel','7.0.4'),('20230806093118_addSchedule','7.0.4'),('20230914145327_init_DB','7.0.4'),('20231009105539_AddMessageTable','7.0.4'),('20231009131114_AddMessageCreatedAT','7.0.4'),('20231019093210_MedicalTestTables','7.0.4'),('20231023091242_editTables','7.0.4'),('20231023193500_scoretoweight','7.0.4'),('20231024145426_useransOldId','7.0.4'),('20231024145513_adduserans','7.0.4'),('20231024145912_removeUSERANSWER','7.0.4'),('20231024145958_addtableuserans','7.0.4'),('20231025071651_adddroptableuserans','7.0.4'),('20231025071737_adddtableuserans11','7.0.4'),('20231121141911_testdeletepram','7.0.4'),('20231127090237_deleteQuestion','7.0.4');

--
-- Table structure for table `anonymoususers`
--

CREATE TABLE `anonymoususers` (
  `PhoneNumber` varchar(255) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Subscribed` tinyint(1) NOT NULL,
  `SubscribeDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`PhoneNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `anonymoususers`
--


--
-- Table structure for table `aspnetroleclaims`
--

CREATE TABLE `aspnetroleclaims` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `RoleId` varchar(255) NOT NULL,
  `ClaimType` longtext,
  `ClaimValue` longtext,
  PRIMARY KEY (`Id`),
  KEY `IX_AspNetRoleClaims_RoleId` (`RoleId`),
  CONSTRAINT `FK_AspNetRoleClaims_AspNetRoles_RoleId` FOREIGN KEY (`RoleId`) REFERENCES `aspnetroles` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `aspnetroleclaims`
--


--
-- Table structure for table `aspnetroles`
--

CREATE TABLE `aspnetroles` (
  `Id` varchar(255) NOT NULL,
  `Name` varchar(256) DEFAULT NULL,
  `NormalizedName` varchar(256) DEFAULT NULL,
  `ConcurrencyStamp` longtext,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `RoleNameIndex` (`NormalizedName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `aspnetroles`
--


--
-- Table structure for table `aspnetuserclaims`
--

CREATE TABLE `aspnetuserclaims` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `UserId` varchar(255) NOT NULL,
  `ClaimType` longtext,
  `ClaimValue` longtext,
  PRIMARY KEY (`Id`),
  KEY `IX_AspNetUserClaims_UserId` (`UserId`),
  CONSTRAINT `FK_AspNetUserClaims_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `aspnetuserclaims`
--


--
-- Table structure for table `aspnetuserlogins`
--

CREATE TABLE `aspnetuserlogins` (
  `LoginProvider` varchar(255) NOT NULL,
  `ProviderKey` varchar(255) NOT NULL,
  `ProviderDisplayName` longtext,
  `UserId` varchar(255) NOT NULL,
  PRIMARY KEY (`LoginProvider`,`ProviderKey`),
  KEY `IX_AspNetUserLogins_UserId` (`UserId`),
  CONSTRAINT `FK_AspNetUserLogins_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `aspnetuserlogins`
--


--
-- Table structure for table `aspnetuserroles`
--

CREATE TABLE `aspnetuserroles` (
  `UserId` varchar(255) NOT NULL,
  `RoleId` varchar(255) NOT NULL,
  PRIMARY KEY (`UserId`,`RoleId`),
  KEY `IX_AspNetUserRoles_RoleId` (`RoleId`),
  CONSTRAINT `FK_AspNetUserRoles_AspNetRoles_RoleId` FOREIGN KEY (`RoleId`) REFERENCES `aspnetroles` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_AspNetUserRoles_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `aspnetuserroles`
--


--
-- Table structure for table `aspnetusertokens`
--

CREATE TABLE `aspnetusertokens` (
  `UserId` varchar(255) NOT NULL,
  `LoginProvider` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Value` longtext,
  PRIMARY KEY (`UserId`,`LoginProvider`,`Name`),
  CONSTRAINT `FK_AspNetUserTokens_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `aspnetusertokens`
--


--
-- Table structure for table `clips`
--

CREATE TABLE `clips` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Title` longtext NOT NULL,
  `Description` longtext NOT NULL,
  `Type` int NOT NULL,
  `Text` longtext NOT NULL,
  `VideoURL` longtext NOT NULL,
  `AudioURL` longtext NOT NULL,
  `IsDeleted` tinyint(1) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `UpdateDate` datetime(6) DEFAULT NULL,
  `CoverURL` longtext NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `clips`
--

INSERT INTO `clips` VALUES (1,'TEST from API','this motaz adli siam testing API',0,'NO TEXT','NO VIDEO','audio.3awaafi.com/16-09-2023-11-57-Ansak_melody4arab.com.mp3',1,'2023-09-16 11:57:07.021067',NULL,'NO COVER'),(2,'OCD','OCD',0,'<p><strong><u>OCD </u></strong></p>','https://player.vimeo.com/video/798094692?h=e65a41def2','audio.3awaafi.com/16-09-2023-12-40-Qalby_Saed_Melody4Arab.Com.mp3',1,'2023-09-16 12:40:53.762590',NULL,'data:image/jpeg;base64,[BLOB]'),(3,'OCD 2','OCD 2',0,'<p><strong class=\"ql-font-monospace\">OCD2<span class=\"ql-cursor\">﻿</span></strong></p>','https://player.vimeo.com/video/798094692?h=e65a41def2','audio.3awaafi.com/16-09-2023-12-43-Habbet_Delwaat_melody4arab.com_.mp3',1,'2023-09-16 12:43:32.583664',NULL,'data:image/jpeg;base64,[BLOB]'),(4,'OCD 3','OCD 3',0,'<h2><strong class=\"ql-font-serif\">OCD 3 OCD 3 OCD 3 OCD 3 </strong></h2>','https://player.vimeo.com/video/798094692?h=e65a41def2','audio.3awaafi.com/16-09-2023-13-23-A2oul_Ansak_melody4arab.com.mp3',1,'2023-09-16 13:23:26.698978',NULL,'data:image/jpeg;base64,[BLOB]'),(5,'OCD 4','OCD 4',0,'<p><strong>text version</strong> of<em class=\"ql-font-serif\"> OCD</em></p>','https://player.vimeo.com/video/798094692?h=e65a41def2','audio.3awaafi.com/16-09-2023-21-18-Tabeeb_Jarrah_melody4arab.com_.mp3',1,'2023-09-16 21:18:24.418652',NULL,'data:image/jpeg;base64,[BLOB]');
INSERT INTO `clips` VALUES (6,'OCD4','OCD4',1,'<p>OCD 4 OCD 4</p>','https://player.vimeo.com/video/798094692?h=e65a41def2','audio.3awaafi.com/17-09-2023-08-47-7abeby_Ya_melody4arab.com_.mp3',1,'2023-09-04 13:32:34.660000','2023-09-17 08:47:16.286149','data:image/jpeg;base64,[BLOB]