-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 11, 2025 at 08:14 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.0.30

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: `codingthunder`
--

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `sno` int(50) NOT NULL,
  `name` text NOT NULL,
  `email` varchar(50) NOT NULL,
  `phone_num` varchar(50) NOT NULL,
  `mes` text NOT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`sno`, `name`, `email`, `phone_num`, `mes`, `date`) VALUES
(1, 'first post', 'firstpost@gmail.com', '123456789', 'first post', '2025-07-07 16:25:34'),
(2, 'this_name', 'this@gmail.com', '6565656565', 'This is a test message', NULL),
(3, 'this_name', 'this@gmail.com', '6565656565', 'This is a test message', '2025-07-07 16:49:24'),
(4, 'this_name', 'thissss@gmail.com', '4545454545', 'NO', '2025-07-07 23:31:44'),
(5, 'this_name', 'thissss@gmail.com', '4545454545', 'NO', '2025-07-07 23:35:11'),
(6, 'this_name', 'thissss@gmail.com', '4545454545', 'NO', '2025-07-07 23:38:58'),
(7, 'Trail', 'trial@gmail.com', '9512638475', 'This is a trial for sending email', '2025-07-08 00:17:15'),
(8, 'Trail', 'trial@gmail.com', '9512638475', 'This is a trial for sending email', '2025-07-08 00:34:34'),
(9, 'Trail', 'trial@gmail.com', '9512638475', 'This is a trial for sending email', '2025-07-08 00:34:58'),
(10, 'Trail', 'trial@gmail.com', '9512638475', 'This is a trial for sending email', '2025-07-08 00:46:27'),
(11, 'Trail', 'trial@gmail.com', '9512638475', 'This is a trial for sending email', '2025-07-08 00:52:18'),
(12, 'Ashish', 'ap@gmail.com', '1234567890', 'I am sending this mail after successfully adding background image for post.html ', '2025-07-08 11:50:08'),
(13, 'Ashish', 'ap@gmail.com', '1234567890', 'I am sending this mail after successfully adding background image for post.html ', '2025-07-08 12:02:17'),
(14, 'Ashish', 'ap@gmail.com', '1234567890', 'this is trial after upload file #20', '2025-07-11 23:30:39');

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `sno` int(11) NOT NULL,
  `title` text NOT NULL,
  `tagline` text NOT NULL,
  `slug` varchar(25) NOT NULL,
  `content` text NOT NULL,
  `img_file` varchar(12) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`sno`, `title`, `tagline`, `slug`, `content`, `img_file`, `date`) VALUES
(1, 'Let\'s learn about stock market', 'This is first post', 'first_post', 'A stock is a security that represents ownership of a fraction of the corporation that issued it. Units of stock are called shares and entitle the owner to a portion of the corporation’s profits equal to the number of shares owned.\r\n\r\nStocks are bought and sold predominantly on public exchanges. The exchanges and the stocks that are listed on them are required to conform to government regulations meant to protect investors from fraudulent practices.', 'home-bg.jpg', '2025-07-11 00:38:55'),
(3, 'Why Side Projects Matter', 'Because building for yourself is the fastest way to grow.', 'third_post', 'In a world dominated by structured learning, side projects are your playground for creativity and experimentation. They’re where theory meets practice — and where true learning begins.\r\n\r\nUnlike classroom assignments or office tasks, side projects are entirely yours. You pick the stack, the goals, the features, and the timeline. That freedom lets you explore technologies you\'re curious about — whether it’s building a REST API with Flask, experimenting with AI, or designing a mobile app in Flutter.\r\n\r\nSide projects also act as a personal portfolio. They tell future employers (and yourself) that you\'re driven, self-motivated, and capable of building something from scratch. It\'s one thing to say you know Python — it\'s another to show a working app that uses Flask and SQLAlchemy.\r\n\r\nMore importantly, side projects keep the spark alive. They’re fun, challenging, and often the reason many developers fall in love with coding in the first place.\r\n\r\nSo if you’re waiting for the perfect idea or the perfect time — don’t. Start small, stay consistent, and keep building.', 'home-bg.jpg', '2025-07-11 14:58:41'),
(4, 'Breaking Through the Tutorial Phase', 'When watching tutorials isn\'t enough — build, break, and repeat.', 'fourth_post', 'If you’ve ever felt stuck in the “tutorial loop” — constantly watching videos or reading articles without actually building something — you’re not alone. It’s one of the most common phases for beginners and even experienced devs when learning something new.\r\n\r\nTutorials are a great starting point. They teach you structure, syntax, and step-by-step logic. But they often give a false sense of mastery. That’s because following along doesn’t require problem-solving — you’re guided every step of the way.\r\n\r\nThe real growth happens when you try to build something without a walkthrough. That’s when the questions start flooding in: How do I structure this app? What database should I use? How do I fix this error? These struggles aren’t signs of failure — they’re signs that you’re learning.\r\n\r\nThe key is to treat tutorials like a launchpad, not a destination. Watch, take notes, then close the tab and try it on your own — even if you fail. Especially if you fail.\r\n\r\nBecause breaking through the tutorial phase is exactly where real developers are made.', '', '2025-07-08 12:41:55'),
(5, 'Embracing Debugging: Your Best Teacher', ' Every bug has a lesson — if you\'re willing to find it.', 'embracing-debugging', 'Debugging might seem frustrating, but it\'s one of the most powerful ways to truly understand how your code works. When something breaks, it forces you to slow down, think critically, and trace logic step by step.\r\n\r\nNo tutorial can replicate the real-world chaos of a sneaky off-by-one error or a database connection issue. Yet it’s through these challenges that you grow. Over time, you start recognizing patterns: how Flask handles routes, where SQL queries go wrong, or why a CSS change won’t reflect.\r\n\r\nMore importantly, debugging teaches resilience. You stop fearing failure and start welcoming it as part of the process.\r\n\r\nSo the next time your code crashes — pause, breathe, and dig in. That bug might be annoying now, but solving it will sharpen your skills for life.', '', '2025-07-08 12:45:08'),
(6, 'Learning One Stack at a Time', 'Tech is vast — go deep, not wide.', 'one-stack-at-a-time', 'With so many tools, frameworks, and languages out there, it’s tempting to learn everything at once — React, Flask, Docker, Tailwind, GraphQL… the list never ends.\r\n\r\nBut trying to master everything at the same time often leads to burnout and confusion. The best approach? Choose one stack and go deep. For example, learn Flask thoroughly before moving to Django. Understand HTML/CSS fundamentals before diving into JavaScript frameworks.\r\n\r\nA focused learning path builds strong foundations. Once you\'re confident with one tech stack, picking up the next one becomes much easier.\r\n\r\nRemember, the goal isn\'t to collect buzzwords — it’s to build real projects that work. And that only happens when you know your tools inside out.\r\n\r\nSo go deep. Master one thing. Then move to the next.', '', '2025-07-08 12:45:08'),
(7, '7th. Embracing Minimalism: A Simpler Life in a Complex World', 'minimalist-living', 'Less is more: discovering', 'In today’s fast-paced and consumer-driven world, minimalism offers a refreshing shift in perspective. It’s not about living with nothing, but about living with intention — keeping only what adds value to your life and letting go of the rest.\r\n\r\nA minimalist lifestyle can reduce stress, increase focus, and give you the mental space to prioritize what truly matters: health, relationships, personal growth, and peace of mind. It’s about clearing the clutter — physically, digitally, and emotionally.\r\n\r\nMinimalism isn\'t a strict rulebook; it’s a mindset. Whether you\'re decluttering your home, simplifying your schedule, or spending less time on social media, every small step towards simplicity counts.\r\n\r\nStart small. One drawer. One hour of tech-free time. One day without buying anything unnecessary. You’ll be amazed at how much clearer your life feels.', 'img.jpg', '2025-07-11 00:27:20');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`sno`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`sno`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `sno` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `sno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
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 */;
