-- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 26, 2022 at 04:22 PM -- Server version: 5.7.36 -- PHP Version: 7.3.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `papemusc_blogs` -- -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` int(11) NOT NULL, `image` varchar(100) NOT NULL, `category` varchar(100) NOT NULL, `topic` varchar(100) NOT NULL, `content` varchar(9999) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `session` varchar(100) NOT NULL, `status` varchar(111) NOT NULL DEFAULT 'published' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `blogs` -- INSERT INTO `blogs` (`id`, `image`, `category`, `topic`, `content`, `time`, `session`, `status`) VALUES (13, 'home-A.jpg', 'BUSINESS', 'Farming In Nyandarua County', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique. Quisque vehicula, risus eget aliquam placerat, purus leo tincidunt eros, eget luctus quam orci in velit. Praesent scelerisque tortor sed accumsan convallis.\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique. Quisque vehicula, risus eget aliquam placerat, purus leo tincidunt eros, eget luctus quam orci in velit. Praesent scelerisque tortor sed accumsan convallis.', '2021-12-20 20:24:34', '', 'published'), (14, '254727021808_status_70834ddc55594dfc8f8bc573bd24e255.jpg', 'NATURE', 'I hate the way i love her', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique.\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique.\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique.\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique.\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique. ', '2021-12-26 04:23:29', '', 'published'), (15, 'bedB001.jpg', 'NATURE', 'THE NEED OF A BED REST', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna.\r\n\r\nVivamus venenatis velit nec neque ultricies, eget elementum magna tristique. Quisque vehicula, risus eget aliquam placerat, purus leo tincidunt eros, eget luctus quam orci in velit. Praesent scelerisque tortor sed accumsan convalli \r\n\r\n\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique. Quisque vehicula, risus eget aliquam placerat, purus leo tincidunt eros, eget luctus quam orci in velit. Praesent scelerisque tortor sed accumsan convalli \r\n\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique. Quisque vehicula, risus eget aliquam placerat, purus leo tincidunt eros, eget luctus quam orci in velit. Praesent scelerisque tortor sed accumsan convalli ', '2022-08-21 10:53:40', '', 'published'), (16, '24x7-helpdesk-support-service-500x500.jpg', 'NATURE', 'THE need for adventuring ', 'The HSV (hue, saturation, value) color space values, also known as HSB (hue, saturation, brightness), and the hex triplets (for HTML web colors) are also given in the following table. Some environments (like Microsoft Excel) reverse the order of bytes in hex color values (i.e. to \"BGR\"). Colors that appear on the web-safe color palette—which includes the sixteen named colors—are noted.[1] (Those four named colors corresponding to the neutral greys have no hue value, which is effectively ignored—i.e., left blank.) ', '2022-08-21 19:55:12', '', 'deleted'), (2022001, '5_6246832097248412518.jpg', 'LIFESTYLES', 'The music that will heal your soul', 'Music is not just music, let\'s talk about music written by the late Dj Avicii, the likes of the nights, waiting for love and many more. He lets us understand that this life should be a better place to live.', '2022-09-03 20:01:33', '', 'published'), (2022002, '254708053203_status_f713b608c1974d92ba42f0fd8be539ec.jpg', 'EDUCATION', 'The nature as told- by John Spere', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna.\r\n\r\nVivamus venenatis velit nec neque ultricies, eget elementum magna tristique. Quisque vehicula, risus eget aliquam placerat, purus leo tincidunt eros, eget luctus quam orci in velit. Praesent scelerisque tortor sed accumsan convalli \r\n\r\n\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique. Quisque vehicula, risus eget aliquam placerat, purus leo tincidunt eros, eget luctus quam orci in velit. Praesent scelerisque tortor sed accumsan convalli \r\n\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas sit amet pretium urna. Vivamus venenatis velit nec neque ultricies, eget elementum magna tristique. Quisque vehicula, risus eget aliquam placerat, purus leo tincidunt eros, eget luctus quam orci in velit. Praesent scelerisque tortor sed accumsan convalli - John the editor', '2022-09-03 20:08:05', 'ken', 'published'), (2022003, 'pMArPDIUr2bnvUewSzjJuDPNrP7HTHvzgRt2vdMk.jpg', 'breaking news', 'Mahat somane:frofile of brilliant lawyer who defended Ruto\'s win in court', 'Lawyer mahat somane was a thorn in the presidential election petitioners as he dismantled their evidence one by one.\r\n\r\ndubbed \'\'the man with numbers \'\' somane brilliantly demonstrated how William achieved 50% +1 an d how it was hard to edit forms 34A. ', '2022-09-05 18:07:44', 'joskin', 'published'), (2022004, 'Fb4vP8ZXwAUyEvh.jfif', 'POLITICS', 'court ruling:mahat and ngatia', 'Wapi likes za Mahat Somane and Fred Ngatia?\r\n\r\nCongratulations WSR, bring back Miguna Miguna.\r\n\r\nThank you CJ Martha Koome and the Supreme Court at large!', '2022-09-05 18:38:29', 'joskin', 'published'); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(11) NOT NULL, `category_code` varchar(100) NOT NULL, `category_name` varchar(100) NOT NULL, `session` varchar(111) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `category_code`, `category_name`, `session`, `time`) VALUES (16, 'BLOGS-3', 'EDUCATION', 'kinuthiajose105@gmail.com', '2022-08-25 19:01:41'), (17, 'Blog -m ', 'breaking news', 'ken', '2022-09-04 14:08:56'), (13, 'BLOG - N', 'NATURE', 'kinuthiajose105@gmail.com', '2022-08-21 13:50:58'), (14, 'Blog - M', 'LIFESTYLES', 'kinuthiajose105@gmail.com', '2022-08-21 19:59:26'), (12, 'BLOG - P', 'POLITICS', 'kinuthiajose105@gmail.com', '2022-08-21 13:49:40'), (18, 'blog-x', 'ENTERTAINMENT', 'joskin', '2022-09-05 17:52:40'); -- -------------------------------------------------------- -- -- Table structure for table `comments` -- CREATE TABLE `comments` ( `id` int(11) NOT NULL, `blog_id` varchar(1000) NOT NULL, `category` varchar(100) NOT NULL, `name` varchar(100) NOT NULL, `comments` varchar(999) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `comments` -- INSERT INTO `comments` (`id`, `blog_id`, `category`, `name`, `comments`, `time`) VALUES (14, '16', 'NATURE', 'joseph', 'What a nice post. Bravo! ', '2022-09-14 07:36:42'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `fname` text NOT NULL, `lname` text NOT NULL, `email` varchar(100) NOT NULL, `phone1` varchar(100) NOT NULL, `phone2` varchar(110) NOT NULL, `idno` int(11) NOT NULL, `password` varchar(100) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `gender` varchar(100) NOT NULL, `address` varchar(100) NOT NULL, `occupation` varchar(100) NOT NULL, `username` varchar(100) NOT NULL, `session` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `fname`, `lname`, `email`, `phone1`, `phone2`, `idno`, `password`, `time`, `gender`, `address`, `occupation`, `username`, `session`) VALUES (24, 'JOSEPH', 'KINUTHIA', 'KINUTHIAJOSE105@GMAIL.COM', '+254708448164', '+254797545677', 36576533, '123ae7b27e350955d4822a16cc76245d', '2022-09-02 20:26:52', 'MALE', 'THIKA', 'JUNIOR - LECTURER', 'Joskin', 'Joskin'); -- -- Indexes for dumped tables -- -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `comments` -- ALTER TABLE `comments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2022005; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `comments` -- ALTER TABLE `comments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;