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

START TRANSACTION;



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

--
-- Table structure for table `Categories`
--

CREATE TABLE `Categories` (
  `id` int(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `image` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Categories`
--

INSERT INTO `Categories` (`id`, `title`, `image`) VALUES
(1, 'Nature', 'politics.png'),
(2, 'Cars', 'business.png'),
(3, 'Food', 'sport.png'),
(4, 'Places', '44538.'),
(6, 'Animated', '63935.');

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

--
-- Table structure for table `Comment`
--

CREATE TABLE `Comment` (
  `id` int(200) NOT NULL,
  `user_id` int(250) NOT NULL,
  `article_id` int(120) NOT NULL,
  `comment` varchar(250) NOT NULL,
  `status` varchar(250) NOT NULL,
  `pubDat` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Comment`
--

INSERT INTO `Comment` (`id`, `user_id`, `article_id`, `comment`, `status`, `pubDat`) VALUES
(1, 2, 7, 'We have a lot of expectation from Pakistan Tahreef Insaf to perform well in all sectors', 'true', '15/07/2018 03:30 Pm'),
(3, 2, 7, 'Actually I\'m not very big fan of PTI but i like its way of approach & also expect lot of things from upcoming Govt.', 'true', '15/07/2018 10:30 Am'),
(4, 2, 7, 'We must take the chance some one others may be it would give revolution in every field', 'true', '15/07/2018 03:30 Pm'),
(5, 2, 7, 'I thought we kust give Chance to Imran Khan may be it give good things to Country', 'true', '07/08/2018 12:15 PM'),
(6, 2, 3, 'its not working good', 'true', '15/07/2018 03:30 Pm'),
(8, 20, 34, 'testing', 'true', '20/09/2018 11:01'),
(9, 20, 19, 'its again testing', 'true', '20/09/2018 11:06'),
(10, 20, 19, 'testimg', 'true', '20/09/2018 11:07'),
(11, 20, 23, 'testing purposes', 'true', '20/09/2018 11:40'),
(12, 20, 23, 'testing again', 'true', '20/09/2018 11:43'),
(13, 22, 1, 'testing commercial.', 'true', '09/10/2018 06:54'),
(14, 30, 23, 'Wkwkkw ', 'true', '13/10/2018 03:41'),
(15, 31, 1, 'testing again', 'true', '13/10/2018 05:39'),
(16, 32, 37, 'great', 'true', '14/10/2018 08:16'),
(17, 42, 16, 'cool one', 'true', '27/10/2018 08:03'),
(18, 46, 18, 'comment test', 'true', '05/11/2018 10:42'),
(19, 48, 1, 'niice\n', 'true', '07/11/2018 07:41'),
(20, 48, 20, 'test\n', 'true', '07/11/2018 05:26'),
(21, 48, 28, 'test comment\n', 'true', '07/11/2018 11:16'),
(22, 52, 23, 'dbdndhdbdjhdjdjd', 'true', '10/11/2018 05:48');

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

--
-- Table structure for table `Favourites`
--

CREATE TABLE `Favourites` (
  `id` int(250) NOT NULL,
  `user_id` int(150) NOT NULL,
  `article_id` int(150) NOT NULL,
  `title` varchar(350) NOT NULL,
  `categoryType` varchar(250) NOT NULL,
  `tags` varchar(250) NOT NULL,
  `tagline` bigint(20) DEFAULT '0',
  `wallpaper` varchar(250) NOT NULL,
  `date` varchar(250) NOT NULL,
  `likes` bigint(20) NOT NULL DEFAULT '0',
  `dislikes` bigint(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Favourites`
--

INSERT INTO `Favourites` (`id`, `user_id`, `article_id`, `title`, `categoryType`, `tags`, `tagline`, `wallpaper`, `date`, `likes`, `dislikes`) VALUES
(35, 22, 1, 'Red Car', 'Premium', 'red,car,interior,exterior', 0, 'wallpaper_09.png', '20/07/2018 08:30', 0, 0),
(36, 24, 20, 'Girl on Road', 'Trending', 'girl on road,desert,girl on desert,sexy', 0, 'wallpaper_01.jpeg', '20/07/2018 08:30', 0, 0),
(37, 25, 44, 'Beautiful Leaves', 'Nature', 'nature,leaves,beautiful,leaves view', 0, 'nature_09.png', '20/07/2018 08:30', 0, 0),
(38, 35, 31, 'Red Car', 'Cars', 'red,side,view,car', 0, 'car_09.jpeg', '20/07/2018 08:30', 0, 0),
(39, 36, 23, 'Anonymous Man', 'Premium', 'anonymous', 0, 'wallpaper_06.jpeg', '20/07/2018 08:30', 0, 0),
(40, 36, 16, 'Bike Front', 'Premium', 'black,bike,premium,bike front', 0, 'wallpaper_08.jpeg', '20/07/2018 08:30', 0, 0),
(41, 39, 23, 'Anonymous Man', 'Premium', 'anonymous', 0, 'wallpaper_06.jpeg', '20/07/2018 08:30', 0, 0),
(42, 42, 16, 'Bike Front', 'Premium', 'black,bike,premium,bike front', 0, 'wallpaper_08.jpeg', '20/07/2018 08:30', 0, 0),
(43, 43, 23, 'Anonymous Man', 'Premium', 'anonymous', 0, 'wallpaper_06.jpeg', '20/07/2018 08:30', 0, 0),
(44, 43, 23, 'Anonymous Man', 'Premium', 'anonymous', 0, 'wallpaper_06.jpeg', '20/07/2018 08:30', 0, 0),
(45, 44, 23, 'Anonymous Man', 'Premium', 'anonymous', 0, 'wallpaper_06.jpeg', '20/07/2018 08:30', 0, 0),
(46, 44, 7, 'Ludo Blocks', 'Premium', 'ludo,block', 0, 'wallpaper_07.jpeg', '20/07/2018 08:30', 0, 0),
(47, 46, 41, 'Beautiful Nature', 'Nature', 'nature,beautiful,nature scene,beautiful view', 0, 'nature_06.png', '20/07/2018 08:30', 0, 0),
(48, 46, 23, 'Anonymous Man', 'Premium', 'anonymous', 0, 'wallpaper_06.jpeg', '20/07/2018 08:30', 0, 0),
(49, 48, 7, 'Ludo Blocks', 'Premium', 'ludo,block', 0, 'wallpaper_07.jpeg', '20/07/2018 08:30', 0, 0),
(50, 48, 16, 'Bike Front', 'Premium', 'black,bike,premium,bike front', 0, 'wallpaper_08.jpeg', '20/07/2018 08:30', 0, 0),
(51, 48, 20, 'Girl on Road', 'Trending', 'girl on road,desert,girl on desert,sexy', 0, 'wallpaper_01.jpeg', '20/07/2018 08:30', 0, 0),
(52, 48, 50, 'Burj Al Arab', 'Dubai Wallpapers', 'dubai,dubai hotel,burj al arab', 0, '71726.png', '29/10/2018 04:53 AM', 0, 0),
(53, 48, 18, 'Car Interior', 'Trending', 'car,interior', 0, 'wallpaper_03.jpeg', '20/07/2018 14:30', 0, 0),
(54, 26, 36, 'Beach ', 'Nature', 'beach,sea,nature', 0, 'nature_01.png', '20/07/2018 08:30', 0, 0),
(55, 26, 42, 'Beach Forest', 'Nature', 'forest,nature,beach tree,beach forest', 0, 'nature_07.png', '20/07/2018 08:30', 0, 0),
(56, 26, 41, 'Beautiful Nature', 'Nature', 'nature,beautiful,nature scene,beautiful view', 0, 'nature_06.png', '20/07/2018 08:30', 0, 0),
(57, 26, 40, 'Trees on Beach', 'Nature', 'nature,beach tree,sand,people on beach', 0, 'nature_05.png', '20/07/2018 08:30', 0, 0),
(58, 26, 43, 'Green Leave', 'Nature', 'green,leaves,nature,beautiful leaves', 0, 'nature_08.png', '20/07/2018 08:30', 0, 0),
(59, 26, 4, 'Red Car Side Mirror', 'Cars', 'red,side scene,car', 0, 'car_01.png', '20/07/2018 08:30', 0, 0),
(60, 26, 28, 'Maroon Car', 'Cars', 'maroon,side scene,car', 0, 'car_05.png', '20/07/2018 08:30', 0, 0),
(61, 26, 31, 'Red Car', 'Cars', 'red,side,view,car', 0, 'car_09.jpeg', '20/07/2018 08:30', 0, 0),
(62, 26, 23, 'Anonymous Man', 'Premium', 'anonymous', 0, 'wallpaper_06.jpeg', '20/07/2018 08:30', 0, 0),
(63, 26, 7, 'Ludo Blocks', 'Premium', 'ludo,block', 0, 'wallpaper_07.jpeg', '20/07/2018 08:30', 0, 0),
(64, 48, 28, 'Maroon Car', 'Cars', 'maroon,side scene,car', 0, 'car_05.png', '20/07/2018 08:30', 0, 0),
(65, 51, 7, 'Ludo Blocks', 'Premium', 'ludo,block', 0, 'wallpaper_07.jpeg', '20/07/2018 08:30', 0, 0),
(67, 2, 25, 'Red Ferrari', 'Cars', 'red,ferrari,car', 0, 'car_03.png', '20/07/2018 08:30', 0, 0),
(69, 20, 43, 'Green Leave', 'Nature', 'green,leaves,nature,beautiful leaves', 1, 'nature_08.png', '20/07/2018 08:30', 1, 0),
(70, 55, 23, 'Anonymous Man', 'Premium', 'anonymous', 0, 'wallpaper_06.jpeg', '20/07/2018 08:30', 0, 0);

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

--
-- Table structure for table `Featured`
--

CREATE TABLE `Featured` (
  `id` int(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `cover_image` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Featured`
--

INSERT INTO `Featured` (`id`, `title`, `cover_image`) VALUES
(1, 'Singapore Wallpapers', 'feature_05.png'),
(2, 'Dubai Wallpapers', 'feature_01.png'),
(3, 'London Wallpapers', 'feature_03.png'),
(5, 'Mario Brothers Wallpapers', 'feature_02.jpg'),
(6, 'Spider Man', 'feature_04.jpg');

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

--
-- Table structure for table `Updates`
--

CREATE TABLE `Updates` (
  `id` int(120) NOT NULL,
  `version` varchar(150) NOT NULL,
  `description` varchar(1500) NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Updates`
--

INSERT INTO `Updates` (`id`, `version`, `description`, `status`) VALUES
(1, '1.0', '1-Some Bug Fixed  \r\n2-New navigation interaction  \r\n3-Improve loading experience  \r\n4-Voice integration in Search', 0);

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

--
-- Table structure for table `Wallpapers`
--

CREATE TABLE `Wallpapers` (
  `id` int(250) NOT NULL,
  `title` varchar(350) NOT NULL,
  `categoryType` varchar(250) NOT NULL,
  `tags` varchar(250) NOT NULL,
  `tagline` bigint(20) NOT NULL DEFAULT '0',
  `wallpaper` varchar(250) NOT NULL,
  `date` varchar(250) NOT NULL,
  `likes` bigint(20) NOT NULL DEFAULT '0',
  `dislikes` bigint(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Wallpapers`
--

INSERT INTO `Wallpapers` (`id`, `title`, `categoryType`, `tags`, `tagline`, `wallpaper`, `date`, `likes`, `dislikes`) VALUES
(1, 'Red Car', 'Premium', 'red,car,interior,exterior', 0, 'wallpaper_09.png', '20/07/2018 08:30', 0, 0),
(2, 'Small Car', 'Trending', 'green,small car', 0, 'wallpaper_04.jpg', '20/07/2018 14:30', 0, 0),
(4, 'Red Car Side Mirror', 'Cars', 'red,side scene,car', 0, 'car_01.png', '20/07/2018 08:30', 0, 0),
(33, 'Yellow Car', 'Cars', 'yellow,small,car', 0, 'car_11.jpeg', '20/07/2018 08:30', 0, 0),
(7, 'Ludo Blocks', 'Premium', 'ludo,block', 4, 'wallpaper_07.jpeg', '20/07/2018 08:30', 5, 4),
(8, 'Toy Car', 'Trending', 'toy car,car,small car', 0, 'wallpaper_05.jpeg', '20/07/2018 08:30', 0, 0),
(18, 'Car Interior', 'Trending', 'car,interior', 0, 'wallpaper_03.jpeg', '20/07/2018 14:30', 0, 0),
(19, 'Yellow Cab', 'Trending', 'yellow,car,car front,car exterior', 1, 'wallpaper_02.jpeg', '20/07/2018 08:30', 0, 0),
(16, 'Bike Front', 'Premium', 'black,bike,premium,bike front', 0, 'wallpaper_08.jpeg', '20/07/2018 08:30', 0, 0),
(20, 'Girl on Road', 'Trending', 'girl on road,desert,girl on desert,sexy', 2, 'wallpaper_01.jpeg', '20/07/2018 08:30', 0, 0),
(50, 'Burj Al Arab', 'Dubai Wallpapers', 'dubai,dubai hotel,burj al arab', 0, '71726.png', '29/10/2018 04:53 AM', 0, 0),
(32, 'Baby Color Car', 'Cars', 'baby color,side,car', 0, 'car_10.jpeg', '20/07/2018 08:30', 0, 0),
(23, 'Anonymous Man', 'Premium', 'anonymous', 3, 'wallpaper_06.jpeg', '20/07/2018 08:30', 0, 0),
(24, 'Black Car', 'Cars', 'black,car,side mirror', 0, 'car_02.png', '20/07/2018 08:30', 0, 0),
(30, 'Hilux Car', 'Cars', 'hilux,jeep,car', 1, 'car_08.jpeg', '20/07/2018 08:30', 0, 0),
(31, 'Red Car', 'Cars', 'red,side,view,car', 0, 'car_09.jpeg', '20/07/2018 08:30', 0, 0),
(25, 'Red Ferrari', 'Cars', 'red,ferrari,car', 0, 'car_03.png', '20/07/2018 08:30', 0, 0),
(28, 'Maroon Car', 'Cars', 'maroon,side scene,car', 1, 'car_05.png', '20/07/2018 08:30', 0, 0),
(29, 'Old Car', 'Cars', 'old,car,headlights', 1, 'car_06.png', '20/07/2018 08:30', 0, 0),
(26, 'Green Classic Car', 'Cars', 'green,vintage,classic,car', 0, 'car_04.png', '20/07/2018 08:30', 0, 3),
(34, 'Yellow Audi Car', 'Cars', 'yellow,audi,scene,car', 2, 'car_12.png', '20/07/2018 08:30', 0, 0),
(35, 'Car Side View', 'Cars', 'black,car,side view', 2, 'car_07.jpeg', '20/07/2018 08:30', 0, 0),
(36, 'Beach ', 'Nature', 'beach,sea,nature', 0, 'nature_01.png', '20/07/2018 08:30', 0, 0),
(37, 'Beach Stone', 'Nature', 'beach,stone,sea,nature', 0, 'nature_02.png', '20/07/2018 08:30', 0, 0),
(38, 'Foresty Road', 'Nature', 'road,nature,forest,pathway foresty', 5, 'nature_03.png', '20/07/2018 08:30', 0, 0),
(39, 'Beautiful Beach', 'Nature', 'beach,beautiful beach,nature,blue water', 0, 'nature_04.png', '20/07/2018 08:30', 0, 0),
(40, 'Trees on Beach', 'Nature', 'nature,beach tree,sand,people on beach', 1, 'nature_05.png', '20/07/2018 08:30', 0, 1),
(41, 'Beautiful Nature', 'Nature', 'nature,beautiful,nature scene,beautiful view', 0, 'nature_06.png', '20/07/2018 08:30', 0, 0),
(42, 'Beach Forest', 'Nature', 'forest,nature,beach tree,beach forest', 0, 'nature_07.png', '20/07/2018 08:30', 0, 0),
(43, 'Green Leave', 'Nature', 'green,leaves,nature,beautiful leaves', 3, 'nature_08.png', '20/07/2018 08:30', 1, 0),
(62, 'People Moving', 'Animated', 'gify,animated,people', 7, '80187.gif', '16/11/2018 06:48 AM', 0, 0),
(63, 'Record Playing', 'Animated', 'record,animated,gif,record,yellow', 2, '70761.gif', '16/11/2018 17:07 PM', 0, 0),
(75, 'Eagle Bird', '', 'eagle,bird', 0, '14163.jpeg', '17/11/2018 07:14 AM', 0, 0);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `Comment`
--
ALTER TABLE `Comment`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `Favourites`
--
ALTER TABLE `Favourites`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `Featured`
--
ALTER TABLE `Featured`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `Wallpapers`
--
ALTER TABLE `Wallpapers`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;
COMMIT;

