-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `3awaafidb`
--

-- --------------------------------------------------------

--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `anonymoususers` (`PhoneNumber`, `CreatedDate`, `Subscribed`, `SubscribeDate`) 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(11) NOT NULL,
  `RoleId` varchar(255) NOT NULL,
  `ClaimType` longtext DEFAULT NULL,
  `ClaimValue` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- 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 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

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

CREATE TABLE `aspnetuserclaims` (
  `Id` int(11) NOT NULL,
  `UserId` varchar(255) NOT NULL,
  `ClaimType` longtext DEFAULT NULL,
  `ClaimValue` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

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

CREATE TABLE `aspnetuserlogins` (
  `LoginProvider` varchar(255) NOT NULL,
  `ProviderKey` varchar(255) NOT NULL,
  `ProviderDisplayName` longtext DEFAULT NULL,
  `UserId` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

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

CREATE TABLE `aspnetuserroles` (
  `UserId` varchar(255) NOT NULL,
  `RoleId` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- 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 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `booksessions`
--

CREATE TABLE `booksessions` (
  `Id` int(11) NOT NULL,
  `BookDate` datetime(6) NOT NULL,
  `StartDateTime` datetime(6) NOT NULL,
  `PatientId` varchar(255) NOT NULL,
  `DoctorId` varchar(255) NOT NULL,
  `Status` int(11) NOT NULL,
  `EndDateTime` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `booksessions` (`Id`, `BookDate`, `StartDateTime`, `PatientId`, `DoctorId`, `Status`, `EndDateTime`) 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'),
(43, '2024-02-22 09:55:29.743682', '2024-03-07 09:00:00.000000', '97033173-fb7a-4b82-b39b-f60fa2ff0da9', 'a4f3530f-1cf1-435b-8130-8dc19545c893', 0, '2024-03-07 10:00:00.000000'),
(47, '2024-02-22 13:38:51.100371', '2024-03-02 13:00:00.000000', 'e06e01b5-cc88-4251-abd0-783efa6b7bec', 'a4f3530f-1cf1-435b-8130-8dc19545c893', 0, '2024-03-02 14:00:00.000000'),
(48, '2024-02-22 13:39:35.409821', '2024-03-01 12:00:00.000000', 'e06e01b5-cc88-4251-abd0-783efa6b7bec', 'a4f3530f-1cf1-435b-8130-8dc19545c893', 0, '2024-03-01 13:00:00.000000'),
(49, '2024-02-25 09:10:24.913048', '2024-02-25 18:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', 'a4f3530f-1cf1-435b-8130-8dc19545c893', 0, '2024-02-25 19:00:00.000000'),
(50, '2024-02-25 09:11:03.182889', '2024-02-26 23:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-02-27 00:00:00.000000'),
(51, '2024-02-28 17:59:25.212934', '2024-03-04 13:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-03-04 14:00:00.000000'),
(52, '2024-02-28 17:59:38.581703', '2024-03-04 23:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-03-05 00:00:00.000000'),
(53, '2024-02-28 17:59:46.597493', '2024-03-02 19:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-03-02 20:00:00.000000'),
(54, '2024-02-28 17:59:50.700467', '2024-03-02 02:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-03-02 03:00:00.000000'),
(55, '2024-02-28 17:59:54.499430', '2024-03-02 08:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-03-02 09:00:00.000000'),
(56, '2024-02-28 18:00:15.943674', '2024-03-11 13:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-03-11 14:00:00.000000'),
(57, '2024-02-28 18:00:20.289907', '2024-03-11 23:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-03-12 00:00:00.000000'),
(58, '2024-02-29 09:22:57.624144', '2024-03-04 00:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '350f212d-27ab-483a-a9c5-01b2c58fdb35', 0, '2024-03-04 01:00:00.000000'),
(59, '2024-02-29 09:26:55.224261', '2024-03-03 01:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '350f212d-27ab-483a-a9c5-01b2c58fdb35', 0, '2024-03-03 02:00:00.000000'),
(60, '2024-02-29 09:27:19.272628', '2024-03-05 01:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '350f212d-27ab-483a-a9c5-01b2c58fdb35', 0, '2024-03-05 02:00:00.000000'),
(61, '2024-03-04 10:09:12.313963', '2024-03-05 01:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '07ad336a-5ce7-4624-a634-30ec107fb822', 0, '2024-03-05 02:00:00.000000'),
(62, '2024-03-04 10:09:39.863572', '2024-03-05 20:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '07ad336a-5ce7-4624-a634-30ec107fb822', 0, '2024-03-05 21:00:00.000000'),
(63, '2024-03-04 10:38:16.448459', '2024-03-05 21:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '07ad336a-5ce7-4624-a634-30ec107fb822', 0, '2024-03-05 22:00:00.000000'),
(64, '2024-03-04 10:38:31.495060', '2024-03-09 13:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '07ad336a-5ce7-4624-a634-30ec107fb822', 0, '2024-03-09 14:00:00.000000'),
(65, '2024-03-04 10:49:36.247977', '2024-03-09 14:00:00.000000', '350f212d-27ab-483a-a9c5-01b2c58fdb35', '07ad336a-5ce7-4624-a634-30ec107fb822', 0, '2024-03-09 15:00:00.000000'),
(66, '2024-03-04 10:56:19.501412', '2024-03-06 01:00:00.000000', 'e06e01b5-cc88-4251-abd0-783efa6b7bec', '07ad336a-5ce7-4624-a634-30ec107fb822', 0, '2024-03-06 02:00:00.000000'),
(69, '2024-03-07 11:21:33.227482', '2024-03-12 01:00:00.000000', '07ad336a-5ce7-4624-a634-30ec107fb822', '350f212d-27ab-483a-a9c5-01b2c58fdb35', 0, '2024-03-12 02:00:00.000000'),
(70, '2024-03-07 11:23:49.219379', '2024-03-10 01:00:00.000000', '07ad336a-5ce7-4624-a634-30ec107fb822', '350f212d-27ab-483a-a9c5-01b2c58fdb35', 0, '2024-03-10 02:00:00.000000'),
(71, '2024-03-07 11:32:42.275304', '2024-03-08 12:00:00.000000', '07ad336a-5ce7-4624-a634-30ec107fb822', 'a4f3530f-1cf1-435b-8130-8dc19545c893', 0, '2024-03-08 13:00:00.000000'),
(72, '2024-03-07 11:37:56.094169', '2024-03-08 09:00:00.000000', '07ad336a-5ce7-4624-a634-30ec107fb822', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-03-08 10:00:00.000000'),
(73, '2024-03-07 11:55:54.494563', '2024-03-08 05:00:00.000000', '07ad336a-5ce7-4624-a634-30ec107fb822', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-03-08 06:00:00.000000'),
(74, '2024-03-07 11:56:17.056067', '2024-03-09 02:00:00.000000', '07ad336a-5ce7-4624-a634-30ec107fb822', '514cb96f-7e0d-428e-8759-85fdc9dd1627', 0, '2024-03-09 03:00:00.000000'),
(75, '2024-03-07 11:59:58.410872', '2024-03-11 01:00:00.000000', '07ad336a-5ce7-4624-a634-30ec107fb822', '350f212d-27ab-483a-a9c5-01b2c58fdb35', 0, '2024-03-11 02:00:00.000000'),
(78, '2024-03-07 12:45:40.883663', '2024-03-08 14:00:00.000000', 'b20b8192-d77b-46d0-8e95-8eaf736c3ede', '07ad336a-5ce7-4624-a634-30ec107fb822', 0, '2024-03-08 15:00:00.000000'),
(79, '2024-03-09 09:48:13.249737', '2024-03-11 03:00:00.000000', 'b20b8192-d77b-46d0-8e95-8eaf736c3ede', '07ad336a-5ce7-4624-a634-30ec107fb822', 0, '2024-03-11 04:00:00.000000'),
(80, '2024-03-09 09:48:41.247810', '2024-03-11 01:00:00.000000', 'b20b8192-d77b-46d0-8e95-8eaf736c3ede', '07ad336a-5ce7-4624-a634-30ec107fb822', 0, '2024-03-11 02:00:00.000000');

-- --------------------------------------------------------

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

CREATE TABLE `cliprates` (
  `Id` int(11) NOT NULL,
  `ClipCategory` int(11) NOT NULL,
  `ClipId` int(11) NOT NULL,
  `Rate` int(11) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `cliprates` (`Id`, `ClipCategory`, `ClipId`, `Rate`, `CreatedDate`) 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'),
(158, 0, 22, 0, '2024-02-25 09:06:20.266510'),
(159, 0, 22, 5, '2024-02-25 09:06:24.346516'),
(160, 2, 32, 0, '2024-03-13 13:52:33.316815');

-- --------------------------------------------------------

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

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

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

INSERT INTO `clipreviews` (`Id`, `ClipCategory`, `ClipId`, `Review`, `Approval`, `CreatedDate`) 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'),
(40, 0, 29, 'ccc', 0, '2024-03-13 13:49:14.324375'),
(41, 0, 29, 'ء', 0, '2024-03-13 13:50:55.592513');

-- --------------------------------------------------------

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

CREATE TABLE `clips` (
  `Id` int(11) NOT NULL,
  `Title` longtext NOT NULL,
  `Description` longtext NOT NULL,
  `Type` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `clips` (`Id`, `Title`, `Description`, `Type`, `Text`, `VideoURL`, `AudioURL`, `IsDeleted`, `CreatedDate`, `UpdateDate`, `CoverURL`, `AudioRate`, `TextRate`, `VideoRate`) 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);
INSERT INTO `clips` (`Id`, `Title`, `Description`, `Type`, `Text`, `VideoURL`, `AudioURL`, `IsDeleted`, `CreatedDate`, `UpdateDate`, `CoverURL`, `AudioRate`, `TextRate`, `VideoRate`) VALUES
(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);
INSERT INTO `clips` (`Id`, `Title`, `Description`, `Type`, `Text`, `VideoURL`, `AudioURL`, `IsDeleted`, `CreatedDate`, `UpdateDate`, `CoverURL`, `AudioRate`, `TextRate`, `VideoRate`) VALUES
(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);
INSERT INTO `clips` (`Id`, `Title`, `Description`, `Type`, `Text`, `VideoURL`, `AudioURL`, `IsDeleted`, `CreatedDate`, `UpdateDate`, `CoverURL`, `AudioRate`, `TextRate`, `VideoRate`) VALUES
(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);
INSERT INTO `clips` (`Id`, `Title`, `Description`, `Type`, `Text`, `VideoURL`, `AudioURL`, `IsDeleted`, `CreatedDate`, `UpdateDate`, `CoverURL`, `AudioRate`, `TextRate`, `VideoRate`) VALUES
(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);
INSERT INTO `clips` (`Id`, `Title`, `Description`, `Type`, `Text`, `VideoURL`, `AudioURL`, `IsDeleted`, `CreatedDate`, `UpdateDate`, `CoverURL`, `AudioRate`, `TextRate`, `VideoRate`) 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]