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

START TRANSACTION;



--
-- Database: `nowmfsni_optiv2`
--

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

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

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

INSERT INTO `appdata` (`id`, `image_ad`, `phone`, `email`, `info`) VALUES
(1, 'http://vodstudio.website/firsttvdata/gamepos.jpg', '', '', '');

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

--
-- 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, 'Please contact your provider.\r\n\r\nSkype ID: +44 20 3290 6521\r\nWhatsapp: +44 20 3290 6521, +267 74 838 129\r\n\r\nIn Case you are facing any issue.');

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

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

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

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

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

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

--
-- 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, 'http://stalker.ugoiptv.com:8000/c');

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

--
-- 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,
  `portal` varchar(200) NOT NULL DEFAULT '0'
) 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`, `portal`) VALUES
(13, '00:1A:79:3A:8F:54', '01 - 04 - 2020', '16 : 31', 'january 1970', '807.0_26_splayer_Xsarius Q8', 'true', 'empty', NULL, NULL, '0'),
(9, '00:1A:79:37:57:56', '27 - 07 - 2020', '13 : 22', 'january 1970', '810.0_25_splayer_p212_1G', 'true', 'empty', '', '', '1'),
(10, '00:1A:79:58:89:92', '27 - 04 - 2020', '22 : 41', 'january 1970', '812.0_24_splayer_SH', 'true', 'empty', NULL, NULL, '1'),
(11, '00:1A:79:00:03:D6', '18 - 04 - 2020', '14 : 32', 'january 1970', '812.0_25_splayer_p212_1G', 'true', 'empty', NULL, NULL, '1'),
(12, '00:1A:79:00:2C:CD', '11 - 04 - 2020', '11 : 05', 'january 1970', '808.0_25_splayer_p212_1G', 'true', 'empty', NULL, NULL, '0'),
(14, '00:1A:79:00:03:61', '12 - 05 - 2020', '21 : 07', 'january 1970', '813.0_25_splayer_p212_1G', 'true', 'empty', NULL, NULL, '1'),
(15, '00:1A:79:00:25:B3', '04 - 04 - 2020', '19 : 24', 'january 1970', '808.0_25_splayer_p281', 'true', 'empty', NULL, NULL, '0'),
(16, NULL, NULL, NULL, 'january 1970', NULL, 'true', 'empty', NULL, NULL, ''),
(17, '00:1A:79:07:8F:8C', '22 - 04 - 2020', '22 : 13', 'january 1970', '812.0_25_nuvi_MEDIA PLAYER', 'true', 'empty', NULL, NULL, '0'),
(18, '00:1A:79:03:13:EE', '05 - 05 - 2020', '15 : 49', 'january 1970', '812.0_28_splayer_N5MAX', 'true', 'empty', NULL, NULL, '0'),
(19, '00:1A:79:03:13:EE', '05 - 05 - 2020', '15 : 49', 'january 1970', '812.0_28_splayer_N5MAX', 'true', 'empty', NULL, NULL, '0'),
(20, '00:1A:79:7D:0D:1B', '08 - 05 - 2020', '14 : 40', 'january 1970', '813.0_28_splayer_p281', 'true', 'empty', NULL, NULL, '1'),
(21, '00:1A:79:00:01:3F', '05 - 05 - 2020', '12 : 59', 'january 1970', '812.0_25_splayer_p212_1G', 'true', 'empty', NULL, NULL, '1'),
(22, '00:1A:79:00:01:3F', '05 - 05 - 2020', '12 : 59', 'january 1970', '812.0_25_splayer_p212_1G', 'true', 'empty', NULL, NULL, '1'),
(23, '00:1A:79:9B:2D:F9', '09 - 05 - 2020', '17 : 42', 'january 1970', '812.0_27_splayer_DE106', 'true', 'empty', NULL, NULL, '0'),
(24, '00:1A:79:9B:2D:F9', '09 - 05 - 2020', '17 : 42', 'january 1970', '812.0_27_splayer_DE106', 'true', 'empty', NULL, NULL, '0'),
(25, '00:1A:79:04:17:39', '12 - 05 - 2020', '04 : 34', 'january 1970', '812.0_28_splayer_p281', 'true', 'empty', NULL, NULL, '0');

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

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

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `macid`, `date`, `time`, `deviceinfo`) VALUES
(3, '00:1A:79:37:57:56', '04 - 01 - 2020', '00 : 46', '900.0_24_vod_EVA-L19'),
(4, '00:1A:79:91:37:82', '20 - 12 - 2019', '20 : 39', '180.0_23_vod_TX3 Pro'),
(5, '00:1A:79:0E:38:B3', '21 - 12 - 2019', '13 : 23', '881.0_25_vod_Pixel XL'),
(6, '00:1A:79:07:CF:06', '03 - 01 - 2020', '23 : 57', '881.0_25_vod_S7 Plus'),
(7, '00:1A:79:07:92:0C', '23 - 12 - 2019', '11 : 08', '881.0_25_vod_MboxTv'),
(8, '00:1A:79:01:81:31', '25 - 12 - 2019', '19 : 41', '900.0_23_vod_A96S'),
(9, '00:1A:79:6B:67:A4', '28 - 12 - 2019', '21 : 22', '900.0_19_vod_SM-T561'),
(10, '00:1A:79:B3:C1:77', '03 - 01 - 2020', '23 : 44', '900.0_28_vod_SM-G960F');

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

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

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

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

