-- phpMyAdmin SQL Dump -- version 5.0.3 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 04, 2024 at 01:05 AM -- Server version: 10.4.14-MariaDB -- PHP Version: 7.4.11 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `nexpage` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL, `username` varchar(30) NOT NULL, `password` varchar(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `username`, `password`) VALUES (2, 'admin', '12345'); -- -------------------------------------------------------- -- -- Table structure for table `authors` -- CREATE TABLE `authors` ( `id` int(11) NOT NULL, `image` varchar(30) NOT NULL, `name` varchar(1000) NOT NULL, `btitle` varchar(1000) NOT NULL, `aboutauthor` varchar(1000) NOT NULL, `idn` varchar(1000) NOT NULL, `date` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `authors` -- INSERT INTO `authors` (`id`, `image`, `name`, `btitle`, `aboutauthor`, `idn`, `date`) VALUES (1, 'b.jpeg', 'Mrs. Akudo-chikezie Nwokorie', 'THE EMISSARY', 'Mrs. Akudo-chikezie Nwokorie is a versatile professional with over 20 years of experience in the public and private sectors. She is the Chief Executive Officer of Seasons Group, utilizing her expertise in corporate service, human capital development, media management, theatre education, arts and culture.\r\n\r\nWith a bachelor’s degree in Theatre Arts, her commitment to learning is reflected in her educational achievements including a postgraduate degree in International Business from the University of East London, masters in Human Resources Management, diploma in Education and a certificate from the School of Politics, Policy and Government. \r\n\r\nShe is a fellow of the Mentoring and Career Development Institute and holds various professional certifications. \r\n\r\nA-Kay as fondly called advocates for youths through her Creative Arts Initiative projects, hosts the talk show “Seasons with Akudo,” and initiated the Bookworm Literary Competition for secondary schools in Nigeria and Africa. Her ad', '166fdb3c9858841727902665', '02-10-2024 09:57'), (4, 'a.jpeg', 'Daniel Kanu Ekpezu ', 'The Job Search Compass', 'Daniel Kanu Ekpezu is a professional in the field of Human Resources, Leadership Coaching and Management Consulting. He holds the position of Managing Director at Dek Global Consulting Ltd, where he leads a team of dedicated professionals focused on providing exceptional training, certification and consultancy services in the realm of human capital development. \r\n\r\nAs a public speaker, Daniel is renowned for his ability to inspire and motivate audiences through his value-oriented approach to leadership. His unwavering commitment lies in helping individuals and organizations maximize their productivity and achieve their goals. \r\n\r\nThroughout his professional journey, he has closely collaborated with numerous startups and corporate entities, leveraging his expertise to assist them in improving their efficiency and productivity. His knowledge and practical experiences sets him apart as an invaluable asset to those seeking guidance in enhancing their organizational effectiveness.\r\n\r\n', '166fdcdb7563321727909303', '02-10-2024 11:48'); -- -------------------------------------------------------- -- -- Table structure for table `books` -- CREATE TABLE `books` ( `id` int(11) NOT NULL, `image` varchar(30) NOT NULL, `btitle` varchar(500) NOT NULL, `author` varchar(1000) NOT NULL, `pub` varchar(1000) NOT NULL, `lang` varchar(1000) NOT NULL, `isbn` varchar(1000) NOT NULL, `cat` varchar(1000) NOT NULL, `copyright` varchar(1000) NOT NULL, `aboutbook` varchar(3000) NOT NULL, `idn` varchar(1000) NOT NULL, `date` varchar(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `books` -- INSERT INTO `books` (`id`, `image`, `btitle`, `author`, `pub`, `lang`, `isbn`, `cat`, `copyright`, `aboutbook`, `idn`, `date`) VALUES (6, 'IMG-20240616-WA0007.jpg', 'The Emissary (Paradigm Shift)', 'Author: Akudo-chikezie Nwokorie', 'Publication date: 9th August 2024', 'Language:English', 'ISBN: 9787912232', 'Category:Literature', 'Copyright: All Rights Reserved – Standard Copyright License', 'Inspired by the life of Dr. Samuel Onunaka Mbakwe “Asiele’s quest for legacy” chronicles the journey of a determined 20 years old student, who aims to revolutionize his school’s political scene and beyond. Haunted by the legacy of one of the heroes past, Adiele embarks on a quest for knowledge about true leadership and public service. Immersing himself in historical records and guided by mentors, he uncovers the principles of competence, capacity, character and compassion that defined the hero’s successful governance. Despite resistance, Adiele’s newfound wisdom and unwavering determination inspire his peers and community, igniting a movement for ethical leadership and improved governance to enhance the prosperity of his state. ', '166fc80262ea681727823910', '02-10-2024 12:05'), (7, 'Front Cover (1).jpg', 'THE JOB SEARCH COMPASS', 'Author: Daniel Kanu Ekpezu', 'Publication Date: 18th March 2024', 'Language:English', 'ISBN: 9781304208620', 'Category: Personal Growth', 'Copyright: All Rights Reserved – Standard Copyright License', 'The Job Search Compass” is a comprehensive guide designed to empower job seekers, fresh graduates, educators, human resources executives, and students alike. It delves deep into the intricacies of the job market, providing invaluable insights and strategies to navigate the ever-evolving landscape of employment. Whether you’re embarking on your first job search or looking to revitalize your career, this book offers a wealth of knowledge and practical advice. The Job Search Compass” is a must-read for anyone seeking to navigate the job market with clarity, confidence, and a competitive edge. Invest in your future and secure your path to career success with this essential resource.', '166fc80ee4fce81727824110', '02-10-2024 12:08'); -- -------------------------------------------------------- -- -- Table structure for table `link` -- CREATE TABLE `link` ( `id` int(11) NOT NULL, `name` varchar(60) NOT NULL, `link` varchar(1000) NOT NULL, `idn` varchar(1000) NOT NULL, `date` varchar(1000) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `link` -- INSERT INTO `link` (`id`, `name`, `link`, `idn`, `date`) VALUES (1, 'Amazon', 'https://www.amazon.com/Emissary-Paradigm-Shift-Akudo-Chikezie-Nwokorie-ebook/dp/B0DH1Z9K7W/ref=mp_s_a_1_1?crid=W13I4FB7HH4J&dib=eyJ2IjoiMSJ9.tVCTu3Ke8Vtbtq61ybspKpSsRc-JeIXc62IEhtuNTGs.SvjkGPUZ9LqXx7JvHgnfas6FsDBn9SG96q6MCz7twxA&dib_tag=se&keywords=the+Emissary+Paradigm+Shift&qid=1727224565&sprefix=the+emissary+paradigm+shift+%2Caps%2C484&sr=8-1', '166fc80ee4fce81727824110', '03-10-2024 09:37'), (2, '24h.pchome', 'https://24h.pchome.com.tw/books/prod/DJBQD8-D900HT4N9', '166fc80ee4fce81727824110', '03-10-2024 09:40'), (4, 'Selar', 'https://selar.co/370ofl', '166fc80ee4fce81727824110', '03-10-2024 09:40'), (5, 'Everand', 'https://www.everand.com/book/769045468/The-Emissary-Paradigm-Shift', '166fc80ee4fce81727824110', '03-10-2024 09:41'), (6, 'Indigo', 'https://www.indigo.ca/en-ca/the-emissary-paradigm-shift/a95825e0-c2dc-3d7d-8082-d10cb10e5f8a.html', '166fc80ee4fce81727824110', '03-10-2024 09:42'), (7, 'Bol', 'https://www.bol.com/nl/nl/p/the-emissary/9300000189904134/', '166fc80ee4fce81727824110', '03-10-2024 09:42'), (8, 'Rakuten Kobo', 'https://books.rakuten.co.jp/rk/a95825e0c2dc3d7d8082d10cb10e5f8a/', '166fc80ee4fce81727824110', '03-10-2024 09:43'), (9, 'Lulu', 'https://www.lulu.com/fr/shop/akudo-chikezie-nwokorie/the-emissary-paradigm-shift/paperback/product-zmkp4n7.html?q=The+Emissary+Paradigm+Shift+&page=1&pageSize=4', '166fc80ee4fce81727824110', '03-10-2024 09:44'), (10, 'Amazon', 'https://www.amazon.com/Emissary-Paradigm-Shift-Akudo-Chikezie-Nwokorie-ebook/dp/B0DH1Z9K7W/ref=mp_s_a_1_1?crid=W13I4FB7HH4J&dib=eyJ2IjoiMSJ9.tVCTu3Ke8Vtbtq61ybspKpSsRc-JeIXc62IEhtuNTGs.SvjkGPUZ9LqXx7JvHgnfas6FsDBn9SG96q6MCz7twxA&dib_tag=se&keywords=the+Emissary+Paradigm+Shift&qid=1727224565&sprefix=the+emissary+paradigm+shift+%2Caps%2C484&sr=8-1', '166fc80262ea681727823910', '03-10-2024 09:51'), (11, '24h.pchome', 'https://24h.pchome.com.tw/books/prod/DJBQD8-D900HT4N9', '166fc80262ea681727823910', '03-10-2024 09:51'), (12, 'Selar', 'https://selar.co/370ofl', '166fc80262ea681727823910', '03-10-2024 09:52'), (13, 'Everand', 'https://www.everand.com/book/769045468/The-Emissary-Paradigm-Shift', '166fc80262ea681727823910', '03-10-2024 09:52'), (14, 'Indigo', 'https://www.indigo.ca/en-ca/the-emissary-paradigm-shift/a95825e0-c2dc-3d7d-8082-d10cb10e5f8a.html', '166fc80262ea681727823910', '03-10-2024 09:54'), (15, 'Bol', 'https://www.bol.com/nl/nl/p/the-emissary/9300000189904134/', '166fc80262ea681727823910', '03-10-2024 09:54'), (16, 'Rakuten Kobo', 'https://books.rakuten.co.jp/rk/a95825e0c2dc3d7d8082d10cb10e5f8a/', '166fc80262ea681727823910', '03-10-2024 09:55'), (17, 'Lulu', 'https://www.lulu.com/fr/shop/akudo-chikezie-nwokorie/the-emissary-paradigm-shift/paperback/product-zmkp4n7.html?q=The+Emissary+Paradigm+Shift+&page=1&pageSize=4', '166fc80262ea681727823910', '03-10-2024 09:56'); -- -------------------------------------------------------- -- -- Table structure for table `test` -- CREATE TABLE `test` ( `id` int(11) NOT NULL, `name` varchar(60) NOT NULL, `testi` varchar(1000) NOT NULL, `date` varchar(1000) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `test` -- INSERT INTO `test` (`id`, `name`, `testi`, `date`) VALUES (1, 'Boss Ntanyi', 'I recommend this company to anyone. I love their customer service. I bought an e-book (The Job Search Compass) from them and my experience with their team was very good.', '03-10-2024 11:17'), (2, 'Daniel Kanu Ekpezu', 'They just published my book and I must commend the amazing job done, they have a prompt response system with simple but detailed communication process', '03-10-2024 11:18'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `authors` -- ALTER TABLE `authors` ADD PRIMARY KEY (`id`); -- -- Indexes for table `books` -- ALTER TABLE `books` ADD PRIMARY KEY (`id`); -- -- Indexes for table `link` -- ALTER TABLE `link` ADD PRIMARY KEY (`id`); -- -- Indexes for table `test` -- ALTER TABLE `test` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `authors` -- ALTER TABLE `authors` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `books` -- ALTER TABLE `books` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `link` -- ALTER TABLE `link` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `test` -- ALTER TABLE `test` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; 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 */;