--
-- 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 `aspnetusers`
--

CREATE TABLE `aspnetusers` (
  `Id` varchar(255) NOT NULL,
  `userType` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `UserName` varchar(256) DEFAULT NULL,
  `NormalizedUserName` varchar(256) DEFAULT NULL,
  `Email` varchar(256) DEFAULT NULL,
  `NormalizedEmail` varchar(256) DEFAULT NULL,
  `EmailConfirmed` tinyint(1) NOT NULL,
  `PasswordHash` longtext,
  `SecurityStamp` longtext,
  `ConcurrencyStamp` longtext,
  `PhoneNumber` longtext,
  `PhoneNumberConfirmed` tinyint(1) NOT NULL,
  `TwoFactorEnabled` tinyint(1) NOT NULL,
  `LockoutEnd` datetime(6) DEFAULT NULL,
  `LockoutEnabled` tinyint(1) NOT NULL,
  `AccessFailedCount` int NOT NULL,
  `BirthDay` datetime(6) DEFAULT NULL,
  `Gender` int NOT NULL DEFAULT '0',
  `Status` int NOT NULL DEFAULT '0',
  `confirmCode` longtext,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `UserNameIndex` (`NormalizedUserName`),
  KEY `EmailIndex` (`NormalizedEmail`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `aspnetusers`
--

INSERT INTO `aspnetusers` VALUES ('2b78223c-e402-4ac4-b1da-d6da706353ba',0,'2023-09-25 08:51:29.781974','string','STRING','string','STRING',1,'AQAAAAIAAYagAAAAEPbvBUC+b4JNAQ8LyeveqkJTatWa23eJ+PxDB4Gxi3CC76GC4gaXbmbYQ+23SoqKww==','XBLTDI3S3PSYFGJVEW5BSEJJSQ5CCTEF','6251f6f5-ff3e-4457-a168-a20a5f8ac079',NULL,1,0,NULL,1,0,'2023-09-25 08:51:28.743000',0,1,NULL),('acd8c029-f4ad-4308-b64a-83bc9fa21397',0,'2023-11-23 13:42:02.174496','admin2','ADMIN2','admin@3awaafi.com','ADMIN@3AWAAFI.COM',1,'AQAAAAIAAYagAAAAEOC6QqAvC4XFLQZAfd1XLlKz/U/evZ9W6OCyounnuJ7wAWHuXDGkrjoVcaHC1sdGGw==','CMDS6X4W4UFQWIGCQPA5BJ55Y2HGUDPQ','38b4f9c8-e544-4f7f-8e1f-ea3e627f3d13',NULL,1,0,NULL,1,0,'2023-11-23 13:34:26.288000',0,1,NULL),('e06e01b5-cc88-4251-abd0-783efa6b7bec',0,'2023-09-16 12:01:51.780543','Admin','ADMIN','admin@admin.com','ADMIN@ADMIN.COM',1,'AQAAAAIAAYagAAAAEHKvONbW5Js2eMRp3o1oLmDoxw1/dOpsdeRzJXveCSvr8ZDgmU4d8HmA3YZC+d8x2w==','QWPZY4DFTMX4AQ7P3JALQH6XRJ6OJMA6','f2f6159e-b1d8-435d-b1ef-18bb7b1ddfa9',NULL,1,0,NULL,1,0,'2023-09-16 12:00:40.328000',0,1,NULL);

--
-- 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,[encoded data, 68812 characters]'),(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,[encoded data, 41064 characters]'),(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,[encoded data, 229108 characters]'),(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,[encoded data, 30128 characters]');
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,[encoded data, 141592 characters]