-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 19, 2026 at 10:04 AM -- Server version: 10.6.27-MariaDB -- PHP Version: 8.4.21 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: `zeroinfinitytech_zeroinfinity` -- -- -------------------------------------------------------- -- -- Table structure for table `about_us` -- CREATE TABLE `about_us` ( `id` int(11) NOT NULL, `title` varchar(100) DEFAULT NULL, `content` varchar(200) DEFAULT NULL, `description` longtext DEFAULT NULL, `image` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `about_us` -- INSERT INTO `about_us` (`id`, `title`, `content`, `description`, `image`) VALUES (1, '\"Transforming Imagination into Reality.\"', 'ZeroInfinity Technologies transforms innovation into boundless possibilities, redefining the future where imagination, intelligence, and technology converge to shape reality.', '.', '/images/image-1759857871575.gif'); -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` int(11) NOT NULL, `title` varchar(200) NOT NULL, `content` longtext DEFAULT NULL, `image` varchar(200) DEFAULT NULL, `badgename` varchar(50) DEFAULT NULL, `category_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `blogs` -- INSERT INTO `blogs` (`id`, `title`, `content`, `image`, `badgename`, `category_id`) VALUES (15, 'Meta Ray-Ban Display', 'Meta’s partnership with Ray-Ban is redefining what smart eyewear can do. The new Meta Ray-Ban smart glasses combine the timeless Ray-Ban style with cutting-edge technology offering a seamless blend of fashion, function, and innovation.\n\nEquipped with a micro OLED display, these glasses allow users to see notifications, messages, and navigation directions directly in their field of view. With built-in cameras, voice assistants, and AI-powered features, they make it possible to capture moments hands-free, stream live, or even translate text in real time.\n\nUnlike bulky AR headsets, Meta’s glasses look and feel like regular eyewear lightweight, stylish, and designed for everyday use. They mark a major step toward wearable augmented reality, giving us a glimpse of how technology might naturally integrate into our daily lives.\n\nIn short, the Meta Ray-Ban Display isn’t just about what you see, it’s about how you experience the world.', 'image-1759858117505.png', '#technology #glasses #rayban #meta', 6), (16, 'Is Windows 12 Rumor or Reality?', 'There has been a lot of buzz online about Windows 12, leaving users wondering whether it’s a rumor or reality. As of now, Microsoft has not officially confirmed the release of Windows 12, making it more of a speculation than a fact. The company continues to roll out major updates for Windows 11, introducing features like deeper AI integration, enhanced security, and improved system performance. Some insiders have hinted that Microsoft is working on a more advanced version of Windows that focuses heavily on artificial intelligence, cloud connectivity, and smarter user experiences, but it’s unclear if that version will actually be called Windows 12. Many tech experts believe that the so-called “Windows 12” could simply be a major update—such as the Windows 11 24H2 update—rather than a brand-new operating system. Until Microsoft makes an official announcement, Windows 12 remains a rumor, but one that reflects the company’s clear direction toward AI-powered, context-aware computing that will redefine how users interact with their PCs in the near future.', 'image-1759858659775.jpg', '#windows #software #website #webdevelopment ', 5), (17, 'Would You Trust Homegrown AI Over Big Tech Giants?', 'As artificial intelligence continues to shape industries and influence daily life, a growing question emerges: should we place our trust in homegrown AI solutions or rely on systems developed by tech giants? Homegrown AI built locally by smaller, independent innovators, often brings a deeper understanding of cultural nuances, data privacy, and regional challenges. These systems can be more transparent, adaptable, and aligned with community needs. In contrast, AI from big tech companies offers scale, stability, and global reach, but often at the cost of personalization and data sovereignty.', 'image-1760206904789.png', '#TechEthics #ZeroInfinity #Innovation #FutureTech ', 1); -- -------------------------------------------------------- -- -- Table structure for table `blog_cat` -- CREATE TABLE `blog_cat` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `blog_cat` -- INSERT INTO `blog_cat` (`id`, `name`) VALUES (1, 'AI'), (2, 'Web Technology'), (3, 'Hacking'), (4, 'Science'), (5, 'OperatingSystem'), (6, 'Technology'); -- -------------------------------------------------------- -- -- Table structure for table `cache_metadata` -- CREATE TABLE `cache_metadata` ( `id` int(11) NOT NULL, `resource_name` varchar(50) NOT NULL, `last_modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `version` int(11) DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `cache_metadata` -- INSERT INTO `cache_metadata` (`id`, `resource_name`, `last_modified`, `version`, `created_at`) VALUES (1, 'blogs', '2025-10-11 18:21:44', 37, '2025-10-02 14:55:29'), (2, 'categories', '2025-10-07 17:22:35', 4, '2025-10-02 14:55:29'), (43, '1', '2025-10-17 19:42:46', 1, '2025-10-17 19:42:46'); -- -------------------------------------------------------- -- -- Table structure for table `carousel` -- CREATE TABLE `carousel` ( `id` int(11) NOT NULL, `image` varchar(500) NOT NULL, `title` varchar(200) NOT NULL, `content` varchar(200) NOT NULL, `smallimg` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `carousel` -- INSERT INTO `carousel` (`id`, `image`, `title`, `content`, `smallimg`) VALUES (27, '/images/image-1759856316524.gif', 'Welcome to Zero Infinity', 'Zero Infinity fuels innovation and creativity to build powerful, scalable software that amplifies your vision.\n', '/images/smallimg-1759856316542.gif'), (28, '/images/image-1759856369114.gif', 'Custom Software Development', 'From startups to enterprises, Zero Infinity powers your growth with efficient, scalable, and future-ready software.', '/images/smallimg-1759856369118.gif'), (30, '/images/image-1759856749006.gif', 'Web & Application Development', 'We craft blazing-fast, intelligent applications that merge power, precision, and design — igniting global connections and driving unstoppable growth for your business.', '/images/smallimg-1759856749011.gif'); -- -------------------------------------------------------- -- -- Table structure for table `collaborators` -- CREATE TABLE `collaborators` ( `id` int(11) NOT NULL, `name` varchar(500) DEFAULT NULL, `image` varchar(500) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `collaborators` -- INSERT INTO `collaborators` (`id`, `name`, `image`) VALUES (6, 'Nepal Prashasan', 'image-1759835134500.png'), (7, 'Matribhoomi', 'image-1759835260334.png'), (21, 'CK Adventure Nepal', 'image-1767636106350.png'), (22, 'Matribhoomi', 'image-1759835347670.png'), (23, 'Nepal Prashasan', 'image-1759835357048.png'), (25, 'CK Adventure Nepal', 'image-1767636013381.png'), (26, 'NTB PhotoNepal', 'image-1767636364778.png'); -- -------------------------------------------------------- -- -- Table structure for table `education` -- CREATE TABLE `education` ( `id` int(11) NOT NULL, `image_path` varchar(500) NOT NULL COMMENT 'Example: /public/images/edu.jpg', `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `education` -- INSERT INTO `education` (`id`, `image_path`, `created_at`) VALUES (1, '/public/images/hero-1768410560673.jpg', '2026-01-06 17:56:33'), (2, '/public/images/hero-1768410533629.jpg', '2026-01-06 18:09:04'); -- -------------------------------------------------------- -- -- Table structure for table `footer_settings` -- CREATE TABLE `footer_settings` ( `id` int(11) NOT NULL, `facebook_link` varchar(255) NOT NULL, `instagram_link` varchar(100) NOT NULL, `phone` varchar(20) NOT NULL, `address` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `copyright_name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `footer_settings` -- INSERT INTO `footer_settings` (`id`, `facebook_link`, `instagram_link`, `phone`, `address`, `email`, `copyright_name`) VALUES (1, 'https://www.facebook.com/profile.php?id=61581269713098', 'https://www.facebook.com/profile.php?id=61581269713098', '+9779818323521', 'Kathmandu', 'zeroinfinitytech@gmail.com', ' 2025 ZeroInfinityTechnologies'); -- -------------------------------------------------------- -- -- Table structure for table `message` -- CREATE TABLE `message` ( `id` int(11) NOT NULL, `name` varchar(20) NOT NULL, `email` varchar(100) DEFAULT NULL, `phone` varchar(10) DEFAULT NULL, `message` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `message` -- INSERT INTO `message` (`id`, `name`, `email`, `phone`, `message`) VALUES (6, '1OR\'1=\'1', 'x@x.x', '1111111111', '\'../public/index.js\'\','), (7, 'a@a.a', 'a@a.a', '1111111111', '\'DROPTABLEusers;\''); -- -------------------------------------------------------- -- -- Table structure for table `navbar` -- CREATE TABLE `navbar` ( `id` int(11) NOT NULL, `logo` varchar(500) DEFAULT NULL, `link1` varchar(20) DEFAULT NULL, `link2` varchar(20) DEFAULT NULL, `link3` varchar(20) DEFAULT NULL, `link4` varchar(20) DEFAULT NULL, `link5` varchar(20) DEFAULT NULL, `link6` varchar(20) DEFAULT NULL, `font_size` varchar(100) DEFAULT '20', `font_family` varchar(100) DEFAULT 'Arial', `text1_color` varchar(10) DEFAULT '#ffffff', `text2_color` varchar(10) DEFAULT '#ffffff', `firstname` varchar(50) DEFAULT 'Anonymous', `lastname` varchar(50) DEFAULT 'Nepal' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `navbar` -- INSERT INTO `navbar` (`id`, `logo`, `link1`, `link2`, `link3`, `link4`, `link5`, `link6`, `font_size`, `font_family`, `text1_color`, `text2_color`, `firstname`, `lastname`) VALUES (1, '/images/logo-1760460167727.webp', 'Home', 'About', 'Education', 'Portfolio', 'Services', 'Contact', '20', 'Montserrat', '#ffffff', '#ffffff', 'Zero', 'Infinity'); -- -------------------------------------------------------- -- -- Table structure for table `program` -- CREATE TABLE `program` ( `id` int(11) NOT NULL, `cat_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `subtitle` varchar(500) NOT NULL, `status` enum('coming_soon','registration_open','ongoing','completed','cancelled') NOT NULL DEFAULT 'coming_soon', `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Point-wise description: min 1, max 7 (handled in frontend)' CHECK (json_valid(`description`)), `media` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Array of image/video paths, max 2' CHECK (json_valid(`media`)), `modal_media` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Array of image/video paths, max 2' CHECK (json_valid(`modal_media`)), `modal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Point-wise modal description (JSON array)' CHECK (json_valid(`modal_description`)), `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `program` -- INSERT INTO `program` (`id`, `cat_id`, `title`, `subtitle`, `status`, `description`, `media`, `modal_media`, `modal_description`, `created_at`) VALUES (9, 2, 'Learn PHOTOSHOP', '', 'coming_soon', '[\"3D DESIGN USING PHOTOSHOP\",\"LEARN TO USE ALL TOOLS\",\"PROFESSIONALS SUPERVISION\"]', '[\"/images/program-1768416315576-pkr0pn.png\"]', '[\"/images/program-1768416315577-6oqiol.png\"]', '[\"PROFESSIONALS SUPERVISION\",\"PROFESSIONALS SUPERVISION\"]', '2026-01-06 19:34:22'), (11, 4, 'Master MERN STACK with zero Infinity', 'ssadsadasd', 'registration_open', '[\"60 days course\",\"industry level architecture\",\"certification on completion\",\"learn from industry experts\"]', '[\"/images/program-1768416216487-5vdwd6.jpeg\"]', '[\"/images/program-1767767307215-awsklp.jpeg\"]', '[\"hands on real project edxpreiences\",\" learn to build , innovate , and teamwork\",\"qwewqewqeqwewe\"]', '2026-01-06 19:51:24'); -- -------------------------------------------------------- -- -- Table structure for table `program_cat` -- CREATE TABLE `program_cat` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `program_cat` -- INSERT INTO `program_cat` (`id`, `name`, `created_at`) VALUES (2, 'Designing', '2026-01-06 19:06:29'), (4, 'MERN STACK WEB DEVELOPEMENT', '2026-01-06 19:51:06'); -- -------------------------------------------------------- -- -- Table structure for table `projects` -- CREATE TABLE `projects` ( `id` int(11) NOT NULL, `image` varchar(200) DEFAULT NULL, `title` varchar(100) DEFAULT NULL, `content` text DEFAULT NULL, `link` varchar(200) DEFAULT NULL, `status` enum('completed','ongoing') DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `projects` -- INSERT INTO `projects` (`id`, `image`, `title`, `content`, `link`, `status`) VALUES (17, 'image-1768159976878.png', 'CK Adventure Nepal', 'Environmental Restoration programme\r\n', 'https://ckadventurenepal.com/', 'completed'), (18, 'image-1768419113511.png', 'Photo Nepal', 'This project in currently on the development phase.', 'http://photonepal.org/', 'ongoing'); -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` int(11) NOT NULL, `name` varchar(100) DEFAULT NULL, `position` varchar(100) DEFAULT NULL, `company` varchar(100) DEFAULT NULL, `message` varchar(200) DEFAULT NULL, `approved` tinyint(1) DEFAULT 0, `image` varchar(500) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `reviews` -- INSERT INTO `reviews` (`id`, `name`, `position`, `company`, `message`, `approved`, `image`) VALUES (8, 'Rana B Chand PhD.', 'Chairperson', 'Matribhoomi', '“A Gen Z–driven tech force — creative, bold, and absolutely unstoppable. They’re not just following trends, they’re setting them.”', 1, 'public/images/1759837438761-828785416-AIG RADA B. CHAND.png'), (9, 'Surendra Subedi', 'Editor', 'Nepal Prashasan', '\"ZeroInfinity shows that with vision and innovation, technology can truly shape a better future.\"', 1, 'public/images/1759838413852-510726048-surendra.jpg'), (10, 'Harka bahadur mikso', 'pratashya umedwar', 'nepali communist party', 'babal cha', 0, 'public/images/1768303031684-741530067-२.png'); -- -------------------------------------------------------- -- -- Table structure for table `services` -- CREATE TABLE `services` ( `id` int(11) NOT NULL, `title` varchar(200) NOT NULL, `content` longtext DEFAULT NULL, `image` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `services` -- INSERT INTO `services` (`id`, `title`, `content`, `image`) VALUES (74, 'Web Development', 'Responsive, secure, and performance-driven websites to grow your online presence.', 'image-1759836507113.png'), (75, 'Software Development', 'We design and develop powerful software solutions that perfectly align with your goals and workflows.', 'image-1759837101992.png'), (76, 'Mobile App Development', 'Engaging and user-friendly mobile applications for Android and iOS platforms.', 'image-1759837138533.png'), (77, 'Digital Marketing', 'Boost your online presence with our SEO, social media, content, and performance marketing strategies tailored to drive results.', 'image-1759837175036.png'), (78, 'AI & Data Analytics', 'Unlock insights through AI, machine learning, and big data solutions tailored to your industry.', 'image-1759837235407.png'), (79, 'IT Consulting & Support', 'Strategic technology consulting and ongoing support to future-proof your business.', 'image-1759837277391.png'); -- -------------------------------------------------------- -- -- Table structure for table `students` -- CREATE TABLE `students` ( `id` int(11) NOT NULL, `fullname` varchar(255) DEFAULT NULL, `address` text DEFAULT NULL, `education` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `mobile` varchar(50) DEFAULT NULL COMMENT 'contacts/mobile', `programid` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `students` -- INSERT INTO `students` (`id`, `fullname`, `address`, `education`, `email`, `mobile`, `programid`, `created_at`) VALUES (15, 'awdasdasdas', 'asdasdasdasdasd', 'see', 'chaudharyraman590@gmail.com', '8888888888', 4, '2026-02-03 09:10:41'); -- -------------------------------------------------------- -- -- Table structure for table `students_review` -- CREATE TABLE `students_review` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `course_taken` varchar(255) DEFAULT NULL, `current_position` varchar(255) DEFAULT NULL, `image` varchar(512) DEFAULT NULL, `ratings` tinyint(3) UNSIGNED NOT NULL, `message` text NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `is_approved` tinyint(1) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `students_review` -- INSERT INTO `students_review` (`id`, `name`, `course_taken`, `current_position`, `image`, `ratings`, `message`, `created_at`, `updated_at`, `is_approved`) VALUES (19, 'Nirnaya Khadka', 'Fullstack', 'Fullstack developer', '/images/review-1768751127044-933008634.jpeg', 5, 'Thank you zeroinfinity for teaching me how full architecture how frontend and backend work how to connect api I really appreciate your love and support', '2026-01-18 15:45:29', '2026-01-18 16:42:54', 1), (20, 'Shashi Bhushan thakur', 'Full stack web development', 'Fronted Developer', '/images/review-1768753888595-113821197.jpg', 5, 'I get very good experience of learning in Zeroinfinity because all the members of this company are very friendly and they quality education. They provide different knowledge and skills, so that learning has become easy for me.', '2026-01-18 16:31:28', '2026-01-18 16:42:50', 1); -- -------------------------------------------------------- -- -- Table structure for table `subscribers` -- CREATE TABLE `subscribers` ( `id` int(11) NOT NULL, `email` varchar(200) NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `subscribers` -- INSERT INTO `subscribers` (`id`, `email`, `created_at`) VALUES (1, 'asimdahal03@gmail.com', '2025-09-29 16:42:03'), (2, 'viphack1122@gmail.com', '2025-09-29 16:46:16'), (3, 'sujannsubedii@gmail.com', '2025-10-02 19:00:18'), (6, 'dairyrdc@gmail.com', '2025-10-03 11:29:22'), (7, 'callapp608@gmail.com', '2025-10-03 11:29:30'), (8, 'asdasdasd@asdasd.com', '2025-10-03 15:47:48'), (9, 'subedigee@gmail.com', '2025-10-04 00:40:57'), (13, 'ddas@gmail.com', '2025-10-06 06:43:55'), (15, 'asdasdasd@gmail.coma', '2025-10-06 20:53:00'), (19, 'bishalbasnet123@gmail.com', '2025-10-06 21:14:04'), (20, 'sad@asdsad.com', '2025-10-07 07:01:41'), (22, 'asdas@asdsad.casdad', '2025-10-07 21:36:39'), (23, 'x@x.com', '2025-10-07 21:37:39'), (24, 'x@x.x', '2025-10-07 22:01:56'), (25, 'asdasd@asdsad.com', '2025-10-07 22:11:24'), (29, 'zero@gmail.com', '2025-10-10 20:02:29'), (30, '123@gmail.com', '2025-10-12 06:50:34'), (31, 'sadsad@asdad.com', '2025-10-14 10:49:42'), (37, 'nirnayakhadka21@gmail.com', '2026-01-04 09:17:53'); -- -------------------------------------------------------- -- -- Table structure for table `teams` -- CREATE TABLE `teams` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `role` varchar(100) NOT NULL, `image` varchar(500) DEFAULT NULL, `facebook_link` varchar(500) DEFAULT NULL, `linkedin_link` varchar(500) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `teams` -- INSERT INTO `teams` (`id`, `name`, `role`, `image`, `facebook_link`, `linkedin_link`) VALUES (8, 'Sujan Subedi', 'Founder', '/images/image-1759834871439.jpg', 'https://web.facebook.com/sujan.subedi.58323', NULL), (11, 'Ashim Dahal', 'CEO/Backend developer', '/images/image-1766763471760.jpeg', NULL, NULL), (12, 'Bishal Basnet ', 'Manager & Web Developer ', '/images/image-1760386379415.jpg', 'https://www.facebook.com/bishal.basnet.5891004', 'https://www.linkedin.com/in/bishal-basnet-13b4ab273/'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `username` varchar(50) NOT NULL, `password` varchar(255) NOT NULL, `role` enum('admin','user') DEFAULT 'admin' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `password`, `role`) VALUES (1, 'admin', '$2a$12$JqYmDmtyk.zvFav6MI5I6uwhp5Nm9rfRA4oqXZMhzq/gtze8.FDZ.', 'admin'); -- -- Indexes for dumped tables -- -- -- Indexes for table `about_us` -- ALTER TABLE `about_us` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`), ADD KEY `fk_blog_cat` (`category_id`); -- -- Indexes for table `blog_cat` -- ALTER TABLE `blog_cat` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cache_metadata` -- ALTER TABLE `cache_metadata` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `resource_name` (`resource_name`); -- -- Indexes for table `carousel` -- ALTER TABLE `carousel` ADD PRIMARY KEY (`id`); -- -- Indexes for table `collaborators` -- ALTER TABLE `collaborators` ADD PRIMARY KEY (`id`); -- -- Indexes for table `education` -- ALTER TABLE `education` ADD PRIMARY KEY (`id`); -- -- Indexes for table `footer_settings` -- ALTER TABLE `footer_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `message` -- ALTER TABLE `message` ADD PRIMARY KEY (`id`); -- -- Indexes for table `navbar` -- ALTER TABLE `navbar` ADD PRIMARY KEY (`id`); -- -- Indexes for table `program` -- ALTER TABLE `program` ADD PRIMARY KEY (`id`), ADD KEY `fk_program_cat` (`cat_id`); -- -- Indexes for table `program_cat` -- ALTER TABLE `program_cat` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name` (`name`); -- -- Indexes for table `projects` -- ALTER TABLE `projects` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`); -- -- Indexes for table `services` -- ALTER TABLE `services` ADD PRIMARY KEY (`id`); -- -- Indexes for table `students` -- ALTER TABLE `students` ADD PRIMARY KEY (`id`), ADD KEY `programid` (`programid`); -- -- Indexes for table `students_review` -- ALTER TABLE `students_review` ADD PRIMARY KEY (`id`), ADD KEY `idx_course` (`course_taken`), ADD KEY `idx_ratings` (`ratings`), ADD KEY `idx_approved` (`is_approved`); -- -- Indexes for table `subscribers` -- ALTER TABLE `subscribers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`); -- -- Indexes for table `teams` -- ALTER TABLE `teams` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `about_us` -- ALTER TABLE `about_us` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `blog_cat` -- ALTER TABLE `blog_cat` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `cache_metadata` -- ALTER TABLE `cache_metadata` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44; -- -- AUTO_INCREMENT for table `carousel` -- ALTER TABLE `carousel` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `collaborators` -- ALTER TABLE `collaborators` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `education` -- ALTER TABLE `education` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `footer_settings` -- ALTER TABLE `footer_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `message` -- ALTER TABLE `message` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `program` -- ALTER TABLE `program` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `program_cat` -- ALTER TABLE `program_cat` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `projects` -- ALTER TABLE `projects` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `services` -- ALTER TABLE `services` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80; -- -- AUTO_INCREMENT for table `students` -- ALTER TABLE `students` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `students_review` -- ALTER TABLE `students_review` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `subscribers` -- ALTER TABLE `subscribers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- AUTO_INCREMENT for table `teams` -- ALTER TABLE `teams` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Constraints for dumped tables -- -- -- Constraints for table `blogs` -- ALTER TABLE `blogs` ADD CONSTRAINT `fk_blog_cat` FOREIGN KEY (`category_id`) REFERENCES `blog_cat` (`id`); -- -- Constraints for table `program` -- ALTER TABLE `program` ADD CONSTRAINT `fk_program_cat` FOREIGN KEY (`cat_id`) REFERENCES `program_cat` (`id`) ON DELETE CASCADE; -- -- Constraints for table `students` -- ALTER TABLE `students` ADD CONSTRAINT `students_ibfk_1` FOREIGN KEY (`programid`) REFERENCES `program_cat` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; 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 */;