322 lines
13 KiB
SQL
322 lines
13 KiB
SQL
-- phpMyAdmin SQL Dump
|
|
-- version 4.6.6deb5ubuntu0.5
|
|
-- https://www.phpmyadmin.net/
|
|
--
|
|
-- Host: localhost:3306
|
|
-- Generation Time: Apr 14, 2022 at 04:28 AM
|
|
-- Server version: 10.1.48-MariaDB-0ubuntu0.18.04.1
|
|
-- PHP Version: 7.2.24-0ubuntu0.18.04.11
|
|
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
SET time_zone = "+00:00";
|
|
|
|
--
|
|
-- Database: `drm`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `cats`
|
|
--
|
|
|
|
CREATE TABLE `cats` (
|
|
`CatID` int(11) NOT NULL,
|
|
`CatName` varchar(64) NOT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
|
|
|
|
--
|
|
-- Dumping data for table `cats`
|
|
--
|
|
|
|
INSERT INTO `cats` (`CatID`, `CatName`) VALUES
|
|
(1, 'General');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `channels`
|
|
--
|
|
|
|
CREATE TABLE `channels` (
|
|
`ID` int(11) NOT NULL,
|
|
`CatID` int(11) NOT NULL DEFAULT '1',
|
|
`ChannelName` varchar(64) NOT NULL,
|
|
`Manifest` varchar(1024) NOT NULL,
|
|
`VariantID` int(11) DEFAULT NULL,
|
|
`DownloadPath` varchar(128) DEFAULT NULL,
|
|
`StartTime` datetime DEFAULT NULL,
|
|
`EndTime` datetime DEFAULT NULL,
|
|
`Status` varchar(16) NOT NULL DEFAULT 'Stopped',
|
|
`PID` int(11) NOT NULL DEFAULT '0',
|
|
`FPID` int(11) DEFAULT '0',
|
|
`info` text,
|
|
`SegmentJoiner` int(11) DEFAULT '0',
|
|
`PlaylistLimit` int(11) DEFAULT '0',
|
|
`URLListLimit` int(11) DEFAULT '0',
|
|
`UseProxy` tinyint(4) DEFAULT '0',
|
|
`ProxyURL` varchar(128) DEFAULT NULL,
|
|
`ProxyPort` int(11) DEFAULT NULL,
|
|
`ProxyUser` varchar(64) DEFAULT NULL,
|
|
`ProxyPass` varchar(64) DEFAULT NULL,
|
|
`DownloadUseragent` varchar(255) DEFAULT NULL,
|
|
`AudioID` varchar(255) DEFAULT NULL,
|
|
`VideoID` varchar(64) DEFAULT NULL,
|
|
`AllowedIP` text,
|
|
`AutoRestart` tinyint(4) DEFAULT '1',
|
|
`Output` varchar(8) NOT NULL DEFAULT 'hls',
|
|
`UDPIP` varchar(32) NOT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
|
|
|
|
--
|
|
-- Dumping data for table `channels`
|
|
--
|
|
|
|
INSERT INTO `channels` (`ID`, `CatID`, `ChannelName`, `Manifest`, `VariantID`, `DownloadPath`, `StartTime`, `EndTime`, `Status`, `PID`, `FPID`, `info`, `SegmentJoiner`, `PlaylistLimit`, `URLListLimit`, `UseProxy`, `ProxyURL`, `ProxyPort`, `ProxyUser`, `ProxyPass`, `DownloadUseragent`, `AudioID`, `VideoID`, `AllowedIP`, `AutoRestart`, `Output`, `UDPIP`) VALUES
|
|
(1, 1, 'bein prem1', 'https://live-d-main-beinmena.beincdn.com/ch10/b96db17d-e0cd-4a40-8c9f-5911d83f6341/ea42ec8d-adfc-4ef4-8981-799f11d07cc8.ism/ZXhwPTE2NDk5MDA4Njh%2bYWNsPSUyZmNoMTAlMmZiOTZkYjE3ZC1lMGNkLTRhNDAtOGM5Zi01OTExZDgzZjYzNDElMmZlYTQyZWM4ZC1hZGZjLTRlZjQtODk4MS03OTlmMTFkMDdjYzguaXNtJTJmKn5kYXRhPWY0OTcxYmE1LWJiMDUtNDViMS1iNTVkLWM3ODRiNGM5MzE1NX5obWFjPWY2MDM4YmM0NDNmNGI0OWExMWViOGNiNTk4Y2VjOWVhZDQ4Njc2MGIwMGVmN2U3ODAwYzgzMDg1OGVjMjU3ZWY%3d/manifest(format=mpd-time-csf,filter=desktop-fullres,encryption=cenc)', NULL, NULL, NULL, '2022-04-14 04:23:25', 'Stopped', 0, 0, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '5_A_primary_12037987828332995369', '1_V_video_17090713503055598136', '[\"\"]', 1, 'hls', ''),
|
|
(2, 1, 'jawwy', 'https://akm.cdn.intigral-ott.net/JAW1/JAW1.isml/manifest.mpd', NULL, NULL, NULL, '2022-04-14 04:23:25', 'Stopped', 0, 0, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, '', 'audio_96052_ara=96000', 'video=3000000', '[\"*\"]', 1, 'hls', ''),
|
|
(3, 1, 'FOX REW', 'https://akm.cdn.intigral-ott.net/FXR/FXR.isml/manifest.mpd', NULL, NULL, NULL, '2022-04-14 04:23:25', 'Stopped', 0, 0, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, '', 'audio_96051_eng=96000', 'video=3000000', '[\"*\"]', 1, 'hls', '');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `channel_keys`
|
|
--
|
|
|
|
CREATE TABLE `channel_keys` (
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`ChannelID` int(11) NOT NULL,
|
|
`KID` varchar(32) NOT NULL,
|
|
`Key` varchar(32) NOT NULL,
|
|
PRIMARY KEY (ID)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
|
|
|
|
INSERT INTO `channel_keys` (`ID`, `ChannelID`, `KID`, `Key`) VALUES
|
|
(1, 1, '9C4DF6B783964B6995628CF95C2A6EB3', '61a4b148c4b0ee4ea27c50cbf8793a78'),
|
|
(2, 2, 'E74C7D697BD26595B196C6B96E2D4F5B', 'e288110233737502e8af9184098ab50b'),
|
|
(3, 3, '556AF5561CBE3405FC3C241FD23B36C2', '18e9a528c7a22b940122afc832c333bf');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `channel_keys`
|
|
--
|
|
|
|
CREATE TABLE `channel_headers` (
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`ChannelID` int(11) NOT NULL,
|
|
`Value` varchar(255) NOT NULL,
|
|
PRIMARY KEY (ID)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
|
|
|
|
|
|
--
|
|
-- Table structure for table `config`
|
|
--
|
|
|
|
CREATE TABLE `config` (
|
|
`ID` int(11) NOT NULL,
|
|
`ConfigName` varchar(32) NOT NULL,
|
|
`ConfigDesc` varchar(64) NOT NULL,
|
|
`ConfigValue` varchar(256) NOT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
|
|
|
|
--
|
|
-- Dumping data for table `config`
|
|
--
|
|
|
|
INSERT INTO `config` (`ID`, `ConfigName`, `ConfigDesc`, `ConfigValue`) VALUES
|
|
(1, 'DownloadPath', '', '/var/www/html/download'),
|
|
(2, 'BinPath', '', '/var/www/html/'),
|
|
(3, 'SegmentJoiner', '', '8'),
|
|
(4, 'DeleteEncryptedAfterDecrypt', '', '1'),
|
|
(5, 'DeleteDecryptedAfterMerge', '', '1'),
|
|
(6, 'PlaylistLimit', '', '8'),
|
|
(7, 'URLListLimit', '', '4'),
|
|
(8, 'FFMpegCMD', '', '-hide_banner -i [VIDEO] -i [AUDIO] -vcodec copy -scodec copy -acodec copy [OUTPUT]'),
|
|
(9, 'M3UDownloadURL', '', 'http://127.0.0.1/download'),
|
|
(10, 'ProxyURL', 'Proxy URL', ''),
|
|
(11, 'ProxyPort', 'Proxy Port', ''),
|
|
(12, 'ProxyUser', 'Proxy Username', ''),
|
|
(13, 'ProxyPass', 'Proxy Password', ''),
|
|
(14, 'DownloadUseragent', 'Download Useragent', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0'),
|
|
(15, 'AutoRestart', 'Auto restart channels', '1'),
|
|
(16, 'DownloaderPath', 'Downloader Path', '/var/www/html/'),
|
|
(17, 'BackupPath', '/var/www/backup', '/var/www/backup'),
|
|
(18, 'MaxLogSize', '', '1048576');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `notification`
|
|
--
|
|
|
|
CREATE TABLE `notification` (
|
|
`ID` int(11) NOT NULL,
|
|
`Titel` varchar(32) DEFAULT NULL,
|
|
`Msg` varchar(256) DEFAULT NULL,
|
|
`Sent` datetime NOT NULL,
|
|
`Status` varchar(8) NOT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `users`
|
|
--
|
|
|
|
CREATE TABLE `users` (
|
|
`ID` int(11) NOT NULL,
|
|
`UserID` varchar(16) NOT NULL,
|
|
`Password` varchar(32) NOT NULL,
|
|
`Role` varchar(16) DEFAULT NULL,
|
|
`LastAccess` datetime DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
|
|
|
|
--
|
|
-- Dumping data for table `users`
|
|
--
|
|
|
|
INSERT INTO `users` (`ID`, `UserID`, `Password`, `Role`, `LastAccess`) VALUES
|
|
(1, 'admin', 'Admin@2023##', 'Admin', '2022-04-14 03:44:24');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `variant`
|
|
--
|
|
|
|
CREATE TABLE `variant` (
|
|
`ID` int(11) NOT NULL,
|
|
`ChannelID` int(11) NOT NULL,
|
|
`Language` varchar(8) DEFAULT NULL,
|
|
`Bandwidth` int(11) DEFAULT NULL,
|
|
`AudioID` varchar(32) NOT NULL,
|
|
`AudioBandwidth` int(11) DEFAULT NULL,
|
|
`AudioCodecs` varchar(32) DEFAULT NULL,
|
|
`VideoID` varchar(32) NOT NULL,
|
|
`VideoBandwidth` int(11) DEFAULT NULL,
|
|
`VideoCodecs` varchar(32) DEFAULT NULL,
|
|
`Width` int(11) DEFAULT NULL,
|
|
`Height` int(11) DEFAULT NULL,
|
|
`Framerate` varchar(16) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
|
|
|
|
--
|
|
-- Dumping data for table `variant`
|
|
--
|
|
|
|
INSERT INTO `variant` (`ID`, `ChannelID`, `Language`, `Bandwidth`, `AudioID`, `AudioBandwidth`, `AudioCodecs`, `VideoID`, `VideoBandwidth`, `VideoCodecs`, `Width`, `Height`, `Framerate`) VALUES
|
|
(38, 1, 'mul', 0, '5_A_secondary_200482043670721364', 96000, 'mp4a.40.2', '1_V_video_6140004908920393176', 400000, 'avc1.4D400D', 384, 216, ''),
|
|
(37, 1, 'mul', 0, '5_A_secondary_200482043670721364', 96000, 'mp4a.40.2', '1_V_video_10384369079951789487', 600000, 'avc1.4D4015', 512, 288, ''),
|
|
(36, 1, 'mul', 0, '5_A_secondary_200482043670721364', 96000, 'mp4a.40.2', '1_V_video_15797029007959740831', 949952, 'avc1.4D401E', 640, 360, ''),
|
|
(35, 1, 'mul', 0, '5_A_secondary_200482043670721364', 96000, 'mp4a.40.2', '1_V_video_14851006325304870635', 1400000, 'avc1.4D401E', 768, 432, ''),
|
|
(34, 1, 'mul', 0, '5_A_secondary_200482043670721364', 96000, 'mp4a.40.2', '1_V_video_16981495139092747609', 2200000, 'avc1.4D401F', 1024, 576, ''),
|
|
(33, 1, 'mul', 0, '5_A_secondary_200482043670721364', 96000, 'mp4a.40.2', '1_V_video_17090713503055598136', 3449984, 'avc1.64001F', 1280, 720, ''),
|
|
(32, 1, 'mul', 0, '5_A_secondary_200482043670721364', 96000, 'mp4a.40.2', '1_V_video_15517948687693901110', 4749952, 'avc1.640028', 1600, 900, ''),
|
|
(31, 1, 'mul', 0, '5_A_secondary_200482043670721364', 96000, 'mp4a.40.2', '1_V_video_14759481473095519504', 6000000, '', 1920, 1080, ''),
|
|
(30, 1, 'mul', 0, '5_A_primary_12037987828332995369', 96000, 'mp4a.40.2', '1_V_video_3750956353252827751', 149952, 'avc1.4D400C', 256, 144, ''),
|
|
(29, 1, 'mul', 0, '5_A_primary_12037987828332995369', 96000, 'mp4a.40.2', '1_V_video_17917517102610242332', 249984, 'avc1.4D400D', 384, 216, ''),
|
|
(28, 1, 'mul', 0, '5_A_primary_12037987828332995369', 96000, 'mp4a.40.2', '1_V_video_6140004908920393176', 400000, 'avc1.4D400D', 384, 216, ''),
|
|
(27, 1, 'mul', 0, '5_A_primary_12037987828332995369', 96000, 'mp4a.40.2', '1_V_video_10384369079951789487', 600000, 'avc1.4D4015', 512, 288, ''),
|
|
(26, 1, 'mul', 0, '5_A_primary_12037987828332995369', 96000, 'mp4a.40.2', '1_V_video_15797029007959740831', 949952, 'avc1.4D401E', 640, 360, ''),
|
|
(25, 1, 'mul', 0, '5_A_primary_12037987828332995369', 96000, 'mp4a.40.2', '1_V_video_14851006325304870635', 1400000, 'avc1.4D401E', 768, 432, ''),
|
|
(24, 1, 'mul', 0, '5_A_primary_12037987828332995369', 96000, 'mp4a.40.2', '1_V_video_16981495139092747609', 2200000, 'avc1.4D401F', 1024, 576, ''),
|
|
(23, 1, 'mul', 0, '5_A_primary_12037987828332995369', 96000, 'mp4a.40.2', '1_V_video_17090713503055598136', 3449984, 'avc1.64001F', 1280, 720, ''),
|
|
(22, 1, 'mul', 0, '5_A_primary_12037987828332995369', 96000, 'mp4a.40.2', '1_V_video_15517948687693901110', 4749952, 'avc1.640028', 1600, 900, ''),
|
|
(21, 1, 'mul', 0, '5_A_primary_12037987828332995369', 96000, 'mp4a.40.2', '1_V_video_14759481473095519504', 6000000, '', 1920, 1080, ''),
|
|
(39, 1, 'mul', 0, '5_A_secondary_200482043670721364', 96000, 'mp4a.40.2', '1_V_video_17917517102610242332', 249984, 'avc1.4D400D', 384, 216, ''),
|
|
(40, 1, 'mul', 0, '5_A_secondary_200482043670721364', 96000, 'mp4a.40.2', '1_V_video_3750956353252827751', 149952, 'avc1.4D400C', 256, 144, ''),
|
|
(41, 2, 'ar', 0, 'audio_96052_ara=96000', 96000, 'mp4a.40.2', 'video=350000', 350000, 'avc1.4D401F', 384, 216, '25'),
|
|
(42, 2, 'ar', 0, 'audio_96052_ara=96000', 96000, 'mp4a.40.2', 'video=600000', 600000, 'avc1.4D401F', 512, 288, '25'),
|
|
(43, 2, 'ar', 0, 'audio_96052_ara=96000', 96000, 'mp4a.40.2', 'video=1300000', 1300000, 'avc1.4D401F', 768, 432, '25'),
|
|
(44, 2, 'ar', 0, 'audio_96052_ara=96000', 96000, 'mp4a.40.2', 'video=1800000', 1800000, 'avc1.4D401F', 960, 540, '25'),
|
|
(45, 2, 'ar', 0, 'audio_96052_ara=96000', 96000, 'mp4a.40.2', 'video=3000000', 3000000, 'avc1.640029', 1280, 720, '25'),
|
|
(46, 3, 'en', 0, 'audio_96051_eng=96000', 96000, 'mp4a.40.2', 'video=350000', 350000, 'avc1.4D401F', 384, 216, '25'),
|
|
(47, 3, 'en', 0, 'audio_96051_eng=96000', 96000, 'mp4a.40.2', 'video=600000', 600000, 'avc1.4D401F', 512, 288, '25'),
|
|
(48, 3, 'en', 0, 'audio_96051_eng=96000', 96000, 'mp4a.40.2', 'video=1300000', 1300000, 'avc1.4D401F', 768, 432, '25'),
|
|
(49, 3, 'en', 0, 'audio_96051_eng=96000', 96000, 'mp4a.40.2', 'video=1800000', 1800000, 'avc1.4D401F', 960, 540, '25'),
|
|
(50, 3, 'en', 0, 'audio_96051_eng=96000', 96000, 'mp4a.40.2', 'video=3000000', 3000000, 'avc1.640029', 1280, 720, '25');
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indexes for table `cats`
|
|
--
|
|
ALTER TABLE `cats`
|
|
ADD PRIMARY KEY (`CatID`);
|
|
|
|
--
|
|
-- Indexes for table `channels`
|
|
--
|
|
ALTER TABLE `channels`
|
|
ADD PRIMARY KEY (`ID`),
|
|
ADD KEY `CatID` (`CatID`);
|
|
|
|
|
|
ALTER TABLE `channel_keys`
|
|
ADD KEY `ChannelId` (`ChannelId`);
|
|
|
|
|
|
ALTER TABLE `channel_headers`
|
|
ADD KEY `ChannelId` (`ChannelId`);
|
|
|
|
--
|
|
-- Indexes for table `config`
|
|
--
|
|
ALTER TABLE `config`
|
|
ADD PRIMARY KEY (`ID`);
|
|
|
|
--
|
|
-- Indexes for table `notification`
|
|
--
|
|
ALTER TABLE `notification`
|
|
ADD PRIMARY KEY (`ID`);
|
|
|
|
--
|
|
-- Indexes for table `users`
|
|
--
|
|
ALTER TABLE `users`
|
|
ADD PRIMARY KEY (`ID`),
|
|
ADD KEY `UserID` (`UserID`);
|
|
|
|
--
|
|
-- Indexes for table `variant`
|
|
--
|
|
ALTER TABLE `variant`
|
|
ADD PRIMARY KEY (`ID`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT for dumped tables
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `cats`
|
|
--
|
|
ALTER TABLE `cats`
|
|
MODIFY `CatID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
|
|
--
|
|
-- AUTO_INCREMENT for table `channels`
|
|
--
|
|
ALTER TABLE `channels`
|
|
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
|
|
--
|
|
-- AUTO_INCREMENT for table `config`
|
|
--
|
|
ALTER TABLE `config`
|
|
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
|
|
--
|
|
-- AUTO_INCREMENT for table `notification`
|
|
--
|
|
ALTER TABLE `notification`
|
|
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
|
|
--
|
|
-- AUTO_INCREMENT for table `variant`
|
|
--
|
|
ALTER TABLE `variant`
|
|
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;
|