--
-- 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'),('20231206182146_addRates','7.0.4'),('20231206191950_addReviews','7.0.4'),('20240115092935_addbooksession','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`
--

INSERT INTO `anonymoususers` VALUES ('011122233544','2024-02-06 09:01:46.228652',1,NULL),('1111111111','2024-02-11 12:23:00.555163',1,NULL);

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

CREATE TABLE `booksessions` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `BookDate` datetime(6) NOT NULL,
  `StartDateTime` datetime(6) NOT NULL,
  `PatientId` varchar(255) NOT NULL,
  `DoctorId` varchar(255) NOT NULL,
  `Status` int NOT NULL,
  `EndDateTime` datetime(6) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_BookSessions_DoctorId` (`DoctorId`),
  KEY `IX_BookSessions_PatientId` (`PatientId`),
  CONSTRAINT `FK_BookSessions_AspNetUsers_DoctorId` FOREIGN KEY (`DoctorId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_BookSessions_AspNetUsers_PatientId` FOREIGN KEY (`PatientId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `booksessions`
--

INSERT INTO `booksessions` VALUES (1,'2024-01-16 07:20:04.920278','2024-01-16 17:19:26.485000','97033173-fb7a-4b82-b39b-f60fa2ff0da9','8c93b005-9111-4819-a4a2-4f95947bcda9',0,'2024-01-16 18:19:26.485000'),(2,'2024-02-18 10:00:21.120304','2024-02-19 18:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-19 18:00:00.000000'),(3,'2024-02-18 10:35:15.896332','2024-02-22 04:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-22 04:00:00.000000'),(4,'2024-02-18 10:53:35.326050','2024-04-05 08:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-04-05 08:00:00.000000'),(5,'2024-02-18 10:55:10.968937','2024-04-04 04:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-04-04 04:00:00.000000'),(6,'2024-02-18 10:56:01.970803','2024-04-12 08:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-04-12 08:00:00.000000'),(7,'2024-02-18 10:56:33.293621','2024-04-11 04:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-04-11 04:00:00.000000'),(8,'2024-02-18 10:58:37.408007','2024-03-20 02:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-03-20 02:00:00.000000'),(9,'2024-02-18 10:59:26.763934','2024-03-21 04:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-03-21 04:00:00.000000'),(10,'2024-02-18 11:00:51.861335','2024-04-10 08:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-04-10 08:00:00.000000'),(11,'2024-02-18 11:03:00.776520','2024-04-07 00:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-04-07 00:00:00.000000'),(12,'2024-02-18 11:32:02.240396','2024-02-21 03:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-21 03:00:00.000000'),(13,'2024-02-18 11:32:15.564696','2024-02-21 02:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-21 02:00:00.000000'),(14,'2024-02-18 11:53:18.075030','2024-02-20 04:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-20 04:00:00.000000'),(15,'2024-02-18 11:53:42.406593','2024-02-20 07:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-20 07:00:00.000000'),(16,'2024-02-18 13:21:37.911979','2024-02-20 00:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-20 00:00:00.000000'),(17,'2024-02-18 13:38:57.045624','2024-03-18 18:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-03-18 18:00:00.000000'),(18,'2024-02-18 13:39:11.433405','2024-03-18 00:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-03-18 00:00:00.000000'),(19,'2024-02-19 08:41:14.795995','2024-02-21 08:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-21 08:00:00.000000'),(20,'2024-02-19 08:41:35.570481','2024-02-27 07:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-27 07:00:00.000000'),(21,'2024-02-19 08:44:59.880422','2024-02-21 00:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-21 00:00:00.000000'),(22,'2024-02-19 08:45:04.580541','2024-02-21 01:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-21 01:00:00.000000'),(23,'2024-02-19 08:45:52.392901','2024-02-28 03:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-28 03:00:00.000000'),(24,'2024-02-19 08:46:00.499115','2024-02-28 02:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-28 02:00:00.000000'),(25,'2024-02-19 08:46:05.678552','2024-02-28 01:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-28 01:00:00.000000'),(26,'2024-02-20 14:41:12.175004','2024-02-20 21:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','07ad336a-5ce7-4624-a634-30ec107fb822',0,'2024-02-20 21:00:00.000000'),(27,'2024-02-20 15:09:18.716648','2024-02-21 09:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-21 09:00:00.000000'),(28,'2024-02-20 15:09:23.919874','2024-02-21 12:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-21 12:00:00.000000'),(29,'2024-02-20 15:09:32.515501','2024-02-26 18:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','5b46af80-4471-4957-92b9-dcc57442f6f3',0,'2024-02-26 18:00:00.000000'),(30,'2024-02-20 16:18:40.889333','2024-02-27 21:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','07ad336a-5ce7-4624-a634-30ec107fb822',0,'2024-02-27 21:00:00.000000'),(31,'2024-02-21 02:16:27.032415','2024-02-27 20:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','07ad336a-5ce7-4624-a634-30ec107fb822',0,'2024-02-27 20:00:00.000000'),(32,'2024-02-21 02:18:44.522505','2024-02-27 04:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','350f212d-27ab-483a-a9c5-01b2c58fdb35',0,'2024-02-27 04:00:00.000000'),(33,'2024-02-21 02:18:59.186925','2024-02-27 01:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','350f212d-27ab-483a-a9c5-01b2c58fdb35',0,'2024-02-27 01:00:00.000000'),(34,'2024-02-21 14:55:46.944591','2024-02-22 09:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','07ad336a-5ce7-4624-a634-30ec107fb822',0,'2024-02-22 09:00:00.000000'),(35,'2024-02-21 15:47:46.431980','2024-02-24 14:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','07ad336a-5ce7-4624-a634-30ec107fb822',0,'2024-02-24 14:00:00.000000'),(36,'2024-02-21 15:47:54.373480','2024-02-24 13:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','07ad336a-5ce7-4624-a634-30ec107fb822',0,'2024-02-24 13:00:00.000000'),(37,'2024-02-21 15:48:24.964599','2024-02-28 01:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','07ad336a-5ce7-4624-a634-30ec107fb822',0,'2024-02-28 01:00:00.000000'),(38,'2024-02-21 15:48:37.678388','2024-02-27 01:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','07ad336a-5ce7-4624-a634-30ec107fb822',0,'2024-02-27 01:00:00.000000'),(39,'2024-02-21 15:51:45.685257','2024-02-29 09:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','07ad336a-5ce7-4624-a634-30ec107fb822',0,'2024-02-29 09:00:00.000000'),(40,'2024-02-22 09:23:24.441719','2024-03-16 13:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','a4f3530f-1cf1-435b-8130-8dc19545c893',0,'2024-03-16 13:00:00.000000'),(41,'2024-02-22 09:27:03.480100','2024-02-24 09:00:00.000000','2b78223c-e402-4ac4-b1da-d6da706353ba','a4f3530f-1cf1-435b-8130-8dc19545c893',0,'2024-02-24 09:00:00.000000');

--
-- Table structure for table `cliprates`
--

CREATE TABLE `cliprates` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ClipCategory` int NOT NULL,
  `ClipId` int NOT NULL,
  `Rate` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ClipRates_ClipId` (`ClipId`),
  CONSTRAINT `FK_ClipRates_Clips_ClipId` FOREIGN KEY (`ClipId`) REFERENCES `clips` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cliprates`
--

INSERT INTO `cliprates` VALUES (1,0,22,5,'2023-12-10 11:03:11.605339'),(2,0,22,3,'2023-12-10 11:03:52.109193'),(3,0,22,3,'2023-12-10 11:04:40.791854'),(4,0,22,3,'2023-12-10 11:21:06.263351'),(8,0,22,0,'2023-12-11 09:50:30.067291'),(9,0,22,5,'2023-12-11 09:50:33.118231'),(10,0,22,4,'2023-12-11 09:50:39.183978'),(11,0,23,3,'2023-12-11 09:52:29.783441'),(12,0,23,5,'2023-12-11 09:52:41.361077'),(13,0,23,4,'2023-12-11 09:52:50.955629'),(14,0,23,4,'2023-12-11 09:52:56.980758'),(15,0,23,4,'2023-12-11 09:53:04.958493'),(16,0,22,0,'2023-12-11 09:56:39.655464'),(17,0,22,4,'2023-12-11 09:56:40.916384'),(18,0,32,0,'2023-12-11 10:03:15.309109'),(19,0,22,0,'2023-12-11 10:03:44.648422'),(20,0,22,0,'2023-12-11 10:04:38.771304'),(21,0,22,0,'2023-12-11 10:05:41.389812'),(22,0,22,0,'2023-12-11 10:05:43.639112'),(23,0,22,0,'2023-12-11 10:05:45.320791'),(24,0,22,0,'2023-12-11 10:05:47.311736'),(25,0,22,0,'2023-12-11 10:05:54.090592'),(26,0,22,0,'2023-12-11 10:05:56.377129'),(27,0,32,0,'2023-12-11 10:18:11.207950'),(28,0,32,0,'2023-12-11 10:18:12.365851'),(29,0,32,0,'2023-12-11 10:18:14.715358'),(30,0,32,0,'2023-12-11 10:18:29.158073'),(31,0,32,0,'2023-12-11 10:18:32.930493'),(32,0,32,0,'2023-12-11 10:18:37.898815'),(33,0,58,0,'2023-12-11 10:19:37.280946'),(34,0,58,0,'2023-12-11 10:19:39.204852'),(35,0,58,0,'2023-12-11 10:19:40.117095'),(36,0,58,0,'2023-12-11 10:19:40.253512'),(37,0,58,0,'2023-12-11 10:19:43.053253'),(38,0,58,0,'2023-12-11 10:19:44.789374'),(39,0,58,0,'2023-12-11 10:19:46.188204'),(40,0,58,0,'2023-12-11 10:19:48.236148'),(41,0,58,0,'2023-12-11 10:19:51.226298'),(42,0,58,0,'2023-12-11 10:19:52.777759'),(45,0,25,0,'2023-12-11 10:21:15.243209'),(46,0,25,4,'2023-12-11 10:21:19.569220'),(47,0,28,0,'2023-12-11 10:22:46.821583'),(48,0,28,3,'2023-12-11 10:22:54.093290'),(49,0,28,3,'2023-12-11 10:22:57.778394'),(50,0,28,5,'2023-12-11 10:23:00.032503'),(51,0,35,0,'2023-12-11 10:33:50.250346'),(52,0,35,5,'2023-12-11 10:33:51.535903'),(53,0,35,5,'2023-12-11 10:33:59.183513'),(57,2,58,4,'2023-12-11 11:07:37.290628'),(58,2,58,4,'2023-12-11 11:07:41.208978'),(59,2,58,5,'2023-12-11 11:07:43.536105'),(60,2,58,5,'2023-12-11 11:07:45.171653'),(61,2,58,4,'2023-12-11 11:07:46.910996'),(62,2,58,4,'2023-12-11 11:07:48.960086'),(63,2,58,5,'2023-12-11 11:07:51.315442'),(64,2,28,4,'2023-12-11 11:08:30.330744'),(65,2,28,5,'2023-12-11 11:08:33.505350'),(66,2,22,0,'2023-12-11 11:22:29.292124'),(67,2,22,5,'2023-12-11 11:22:33.716083'),(68,2,25,5,'2023-12-11 11:22:43.434994'),(69,2,25,5,'2023-12-11 11:22:47.262805'),(70,2,25,4,'2023-12-11 11:22:48.596114'),(71,2,25,4,'2023-12-11 11:22:54.587694'),(72,2,25,4,'2023-12-11 11:23:08.571234'),(73,2,22,4,'2023-12-11 11:23:15.965559'),(74,2,22,5,'2023-12-11 11:23:18.266626'),(75,2,22,5,'2023-12-11 11:23:25.237465'),(76,2,22,5,'2023-12-11 11:23:30.689808'),(77,2,27,0,'2023-12-11 11:26:23.411390'),(78,2,27,5,'2023-12-11 11:26:25.241599'),(79,2,27,5,'2023-12-11 11:26:29.692958'),(80,2,27,4,'2023-12-11 11:26:32.497733'),(81,1,23,0,'2023-12-11 11:41:59.835876'),(82,1,23,5,'2023-12-11 11:42:05.877541'),(83,1,24,0,'2023-12-11 11:57:34.906112'),(84,1,24,3,'2023-12-11 11:57:37.445105'),(85,1,24,3,'2023-12-11 11:57:45.705153'),(86,1,24,4,'2023-12-11 11:57:47.412251'),(87,1,24,0,'2023-12-11 11:59:33.037545'),(88,1,24,0,'2023-12-11 11:59:38.829386'),(89,1,24,0,'2023-12-11 12:02:18.375174'),(90,1,24,0,'2023-12-11 12:02:23.520705'),(91,1,24,0,'2023-12-11 12:06:47.123443'),(92,1,24,0,'2023-12-11 12:06:50.331537'),(93,1,24,0,'2023-12-11 12:06:57.010438'),(94,1,24,0,'2023-12-11 12:07:05.569609'),(95,1,24,5,'2023-12-11 12:07:05.606711'),(96,1,24,0,'2023-12-11 12:07:15.178578'),(97,1,24,0,'2023-12-11 12:07:20.155808'),(98,1,24,0,'2023-12-11 12:07:24.296843'),(99,1,24,0,'2023-12-11 12:07:40.337205'),(100,1,24,0,'2023-12-11 12:08:01.234456'),(101,1,24,5,'2023-12-11 12:08:04.782547'),(102,1,24,0,'2023-12-11 12:08:26.166858'),(103,1,27,0,'2023-12-11 12:08:56.705201'),(104,1,27,0,'2023-12-11 12:09:01.657488'),(105,1,27,0,'2023-12-11 12:09:05.335620'),(106,1,27,0,'2023-12-11 12:09:10.013896'),(107,1,27,0,'2023-12-11 12:09:30.510462'),(108,1,27,5,'2023-12-11 12:09:31.535508'),(109,1,27,0,'2023-12-11 12:10:42.509993'),(110,1,27,0,'2023-12-11 12:10:48.584647'),(111,1,27,0,'2023-12-11 12:10:54.171082'),(112,2,22,0,'2023-12-11 12:16:00.509491'),(113,2,22,5,'2023-12-11 12:16:01.640007'),(114,1,22,0,'2023-12-11 12:32:58.180870'),(115,1,22,5,'2023-12-11 12:33:01.196106'),(116,1,22,0,'2023-12-12 13:50:07.560150'),(117,1,22,0,'2023-12-12 14:00:25.440385'),(118,1,22,0,'2023-12-12 14:00:34.866331'),(119,1,22,5,'2023-12-12 14:00:42.695335'),(120,1,23,0,'2023-12-12 17:12:50.980983'),(121,1,23,5,'2023-12-12 17:12:51.876462'),(122,2,23,0,'2023-12-12 17:15:16.233971'),(123,2,23,5,'2023-12-12 17:15:17.341511'),(124,2,23,5,'2023-12-12 17:15:22.747299'),(125,2,23,5,'2023-12-12 17:15:26.078710'),(126,2,23,5,'2023-12-12 17:15:55.739071'),(127,2,23,5,'2023-12-12 17:15:58.854738'),(128,2,23,5,'2023-12-12 17:16:02.238680'),(129,1,25,0,'2023-12-12 17:36:12.869999'),(130,1,25,5,'2023-12-12 17:36:14.992074'),(131,1,29,0,'2023-12-19 11:48:12.596261'),(132,1,29,5,'2023-12-19 11:48:14.026530'),(133,1,52,0,'2023-12-19 13:25:57.440378'),(134,1,52,5,'2023-12-19 13:25:58.237995'),(135,1,31,0,'2023-12-19 13:28:20.774882'),(136,1,31,5,'2023-12-19 13:28:21.513287'),(137,1,26,0,'2023-12-19 14:18:28.182700'),(138,1,26,5,'2023-12-19 14:18:29.869098'),(139,1,26,0,'2023-12-24 11:16:13.723138'),(140,1,26,5,'2023-12-24 11:16:14.598617'),(141,1,22,0,'2023-12-26 10:53:41.685297'),(142,1,22,0,'2023-12-26 11:37:21.107039'),(143,1,24,0,'2023-12-26 12:54:38.272993'),(144,1,24,5,'2023-12-26 12:54:39.402820'),(145,1,31,0,'2023-12-28 14:13:43.204534'),(146,1,31,5,'2023-12-28 14:13:43.751966'),(147,1,31,5,'2023-12-28 14:14:46.683418'),(148,1,32,0,'2023-12-28 14:17:47.811257'),(149,1,32,5,'2023-12-28 14:17:49.901128'),(150,1,32,5,'2023-12-28 14:19:22.370079'),(151,1,32,0,'2023-12-28 14:24:57.331786'),(152,1,31,5,'2023-12-28 14:32:45.082772'),(153,1,31,0,'2023-12-28 14:34:06.337252'),(154,1,31,5,'2023-12-28 14:34:09.907150'),(155,1,32,5,'2023-12-28 14:44:37.921608'),(156,1,22,0,'2023-12-31 14:09:33.596002'),(157,1,22,5,'2023-12-31 14:09:34.681797');

--
-- Table structure for table `clipreviews`
--

CREATE TABLE `clipreviews` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ClipCategory` int NOT NULL,
  `ClipId` int NOT NULL,
  `Review` longtext NOT NULL,
  `Approval` tinyint(1) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `clipreviews`
--

INSERT INTO `clipreviews` VALUES (1,0,22,'test',1,'2023-12-10 11:08:17.942055'),(2,0,0,'string',1,'2023-12-11 12:57:43.720436'),(3,1,23,'first review',1,'2023-12-11 13:00:42.184384'),(4,1,23,'first review',1,'2023-12-11 13:25:48.300525'),(5,1,23,'first review',1,'2023-12-11 13:26:53.264811'),(6,1,23,'first review',1,'2023-12-11 13:26:56.312813'),(7,0,22,'review 2',0,'2023-12-12 08:52:34.024015'),(8,0,22,'review 2',0,'2023-12-12 13:14:52.415442'),(9,0,22,'string',0,'2023-12-12 13:16:56.794437'),(10,0,22,'cccccccccccccccccccstring',0,'2023-12-12 13:19:46.500251'),(11,0,22,'cccccccccccccccccccstring',0,'2023-12-12 14:04:32.526915'),(12,0,22,'cccccc',0,'2023-12-12 14:08:57.923098'),(13,0,22,'this review from front end',0,'2023-12-12 14:09:24.746689'),(14,0,22,'second review from Front end',0,'2023-12-12 14:14:19.075410'),(15,0,22,'',0,'2023-12-12 14:14:52.956233'),(16,0,22,'',0,'2023-12-12 14:21:46.343849'),(17,0,23,'',0,'2023-12-12 14:34:35.772644'),(18,0,23,'',0,'2023-12-12 16:41:20.499087'),(19,0,23,'',0,'2023-12-12 16:55:56.429216'),(20,0,23,'test for validation',0,'2023-12-12 17:09:46.793406'),(21,1,25,'string',0,'2023-12-12 17:35:07.332968'),(22,1,25,'comment no 1    ',1,'2023-12-12 17:35:29.272891'),(23,1,25,'comment no 1    ',1,'2023-12-12 17:35:51.877999'),(24,0,23,'test 2 from front end',1,'2023-12-18 12:18:27.276676'),(25,0,31,'review for video id 31',1,'2023-12-18 12:25:33.598201'),(26,0,52,'xxxxxxxxxxxxx',0,'2023-12-19 13:24:39.902515'),(27,0,52,'ccccccccc',0,'2023-12-19 13:25:17.225541'),(28,0,31,'xxxxxxxxxxxxxx',0,'2023-12-19 13:41:12.215142'),(29,0,31,'vvvv',0,'2023-12-19 13:41:57.399927'),(30,0,31,'second review for video 31',1,'2023-12-19 13:46:40.735801'),(31,0,31,'third review for video 31',1,'2023-12-19 14:05:47.904696'),(32,0,23,'review for تاثير الحرب علي الحوامل',1,'2023-12-21 11:18:20.728344'),(33,0,32,'review 32',1,'2023-12-28 13:56:38.271022'),(34,0,23,'review for video id 23 --',1,'2023-12-31 09:37:32.574860'),(35,0,23,'new one',1,'2023-12-31 09:44:51.175945'),(36,0,23,'newer one',1,'2023-12-31 10:26:29.136671'),(37,0,23,'newest',1,'2023-12-31 10:26:35.926613'),(38,0,22,'test review for video 22',0,'2023-12-31 13:59:36.336422'),(39,0,23,'جيد',0,'2024-01-10 15:51:40.787901');

--
-- 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,
  `AudioRate` double NOT NULL DEFAULT '0',
  `TextRate` double NOT NULL DEFAULT '0',
  `VideoRate` double NOT NULL DEFAULT '0',
  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',0,0,0),(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]',0,0,0),(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]',0,0,0),(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]',0,0,0),(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]',0,0,0);
