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

START TRANSACTION;



--
-- Database: `3awaafi2`
--

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

--
-- 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;

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

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

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

--
-- 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;

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

--
-- 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]