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

START TRANSACTION;



--
-- Database: `nowmfsni_fastsh_2`
--

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

--
-- Table structure for table `appdata`
--

CREATE TABLE `appdata` (
  `id` int(11) NOT NULL,
  `image_ad` varchar(100) DEFAULT NULL,
  `phone` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `info` varchar(500) DEFAULT NULL,
  `semail` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `appdata`
--

INSERT INTO `appdata` (`id`, `image_ad`, `phone`, `email`, `info`, `semail`) VALUES
(1, '', '', '', '', 'support@hotmail.com');

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

--
-- Table structure for table `apps`
--

CREATE TABLE `apps` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `apkurl` varchar(200) NOT NULL,
  `apklogo` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apps`
--

INSERT INTO `apps` (`id`, `name`, `apkurl`, `apklogo`) VALUES
(1, 'Netflix', 'http://vodstudio.website/smarthdtvdata/netflix.apk', 'http://vodstudio.website/smarthdtvdata/netflix.png'),
(2, 'Mobdro', 'http://vodstudio.website/smarthdtvdata/mobdro.apk', 'http://vodstudio.website/smarthdtvdata/mobdro1.png'),
(3, 'Sony Crackle', 'http://vodstudio.website/smarthdtvdata/crackle.apk', 'http://vodstudio.website/smarthdtvdata/crackle.png'),
(4, 'VLC', 'http://vodstudio.website/smarthdtvdata/vlcapk.apk', 'http://vodstudio.website/smarthdtvdata/vlcicon.png'),
(5, 'Kodi', 'http://vodstudio.website/smarthdtvdata/kodi.apk', 'http://vodstudio.website/smarthdtvdata/kodiicon.png'),
(6, 'HBO GO', 'http://vodstudio.website/smarthdtvdata/hbogo.apk', 'http://vodstudio.website/smarthdtvdata/hbogologo.png');

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

--
-- Table structure for table `ch_portal`
--

CREATE TABLE `ch_portal` (
  `id` int(11) NOT NULL,
  `ch_portal` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ch_portal`
--

INSERT INTO `ch_portal` (`id`, `ch_portal`) VALUES
(1, 'http://stalker.ugoiptv.com:8000');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `msg` varchar(500) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `msg`) VALUES
(1, 'For any Support or Help Contact us at : Shpromultimedia@gmail.com');

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

--
-- Table structure for table `portal`
--

CREATE TABLE `portal` (
  `id` int(11) NOT NULL,
  `url` varchar(500) NOT NULL,
  `loader` varchar(500) NOT NULL,
  `client` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portal`
--

INSERT INTO `portal` (`id`, `url`, `loader`, `client`) VALUES
(1, 'https://shapp.pw/api/reg.php', 'http://line5.protv.cc/portal.php', '');

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

--
-- Table structure for table `sb_portal`
--

CREATE TABLE `sb_portal` (
  `id` int(11) NOT NULL,
  `portal` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_portal`
--

INSERT INTO `sb_portal` (`id`, `portal`) VALUES
(1, 'https://1658399394.rsc.cdn77.org/api/reg_v119.php');

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

--
-- Table structure for table `sk_users`
--

CREATE TABLE `sk_users` (
  `id` int(11) NOT NULL,
  `macid` varchar(200) DEFAULT NULL,
  `date` varchar(200) DEFAULT NULL,
  `time` varchar(200) DEFAULT NULL,
  `expiry` varchar(200) DEFAULT 'january 1970',
  `deviceinfo` varchar(500) DEFAULT NULL,
  `status` varchar(200) DEFAULT 'true',
  `note` varchar(1000) DEFAULT 'empty',
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(200) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sk_users`
--

INSERT INTO `sk_users` (`id`, `macid`, `date`, `time`, `expiry`, `deviceinfo`, `status`, `note`, `email`, `phone`) VALUES
(8, '00:1A:79:EF:95:46', '31 - 10 - 2021', '23 : 34', 'january 1970', '6678.0_30_faster_SM-A505F', 'true', 'empty', NULL, NULL),
(9, '00:1A:79:B1:49:33', '02 - 11 - 2021', '02 : 10', 'january 1970', '6679.0_28_faster_Prime', 'true', 'empty', NULL, NULL),
(10, '00:1A:79:1B:96:1D', '09 - 10 - 2021', '02 : 44', 'january 1970', '6667.0_25_faster_AFTMM', 'true', 'empty', NULL, NULL),
(11, '00:1A:79:84:78:39', '21 - 10 - 2021', '05 : 34', 'january 1970', '6668.0_24_faster_KINGS BOX', 'true', 'empty', NULL, NULL),
(12, '00:1A:79:B4:45:92', '20 - 10 - 2021', '03 : 09', 'january 1970', '6668.0_28_faster_MIBOX4', 'true', 'empty', NULL, NULL),
(13, '00:1A:79:18:D1:F2', '02 - 11 - 2021', '15 : 21', 'january 1970', '6679.0_30_faster_CPH2251', 'true', 'empty', NULL, NULL),
(14, '00:1A:79:97:B6:1E', '02 - 11 - 2021', '02 : 06', 'january 1970', '6679.0_29_faster_M2003J15SC', 'true', 'empty', NULL, NULL);

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

--
-- Table structure for table `test_portal`
--

CREATE TABLE `test_portal` (
  `id` int(11) NOT NULL,
  `test_portal` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test_portal`
--

INSERT INTO `test_portal` (`id`, `test_portal`) VALUES
(1, 'http://sb.bkiptv.net:2500/c');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `macid` varchar(100) NOT NULL,
  `date` varchar(200) NOT NULL,
  `time` varchar(200) NOT NULL,
  `deviceinfo` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `usersExpiry`
--

CREATE TABLE `usersExpiry` (
  `id` int(11) NOT NULL,
  `macid` varchar(500) NOT NULL,
  `expiry` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `appdata`
--
ALTER TABLE `appdata`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `apps`
--
ALTER TABLE `apps`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ch_portal`
--
ALTER TABLE `ch_portal`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `portal`
--
ALTER TABLE `portal`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sb_portal`
--
ALTER TABLE `sb_portal`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sk_users`
--
ALTER TABLE `sk_users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `test_portal`
--
ALTER TABLE `test_portal`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `usersExpiry`
--
ALTER TABLE `usersExpiry`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `appdata`
--
ALTER TABLE `appdata`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `apps`
--
ALTER TABLE `apps`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `ch_portal`
--
ALTER TABLE `ch_portal`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `portal`
--
ALTER TABLE `portal`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sb_portal`
--
ALTER TABLE `sb_portal`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sk_users`
--
ALTER TABLE `sk_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `test_portal`
--
ALTER TABLE `test_portal`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `usersExpiry`
--
ALTER TABLE `usersExpiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

