bookrush.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Sep 10, 2025 at 01:39 PM
-- Server version: 9.1.0
-- PHP Version: 8.3.14

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

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

--
-- Table structure for table `admin_account`
--

DROP TABLE IF EXISTS `admin_account`;
CREATE TABLE IF NOT EXISTS `admin_account` (
  `username` varchar(100) NOT NULL,
  `pwd` varchar(255) NOT NULL,
  `Name` varchar(100) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `admin_account`
--

INSERT INTO `admin_account` (`username`, `pwd`, `Name`) VALUES
('isaact', 'gubznf1', 'Isaac Thomas');

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

--
-- Table structure for table `book_details`
--

DROP TABLE IF EXISTS `book_details`;
CREATE TABLE IF NOT EXISTS `book_details` (
  `Product_Id` int NOT NULL AUTO_INCREMENT,
  `Book_name` varchar(200) NOT NULL,
  `Genre` varchar(100) DEFAULT NULL,
  `Author` varchar(150) DEFAULT NULL,
  `Publisher` varchar(150) DEFAULT NULL,
  `Price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`Product_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `book_details`
--

INSERT INTO `book_details` (`Product_Id`, `Book_name`, `Genre`, `Author`, `Publisher`, `Price`) VALUES
(1, 'The Silent Forest', 'Fiction', 'Amelia Clarke', 'HarperCollins', 299.99),
(2, 'Data Structures in Java', 'Education', 'Robert Hughes', 'O\'Reilly Media', 499.50),
(3, 'The Lost Kingdom', 'Fantasy', 'Evelyn Carter', 'Penguin Random House', 399.00),
(4, 'Machine Learning Basics', 'Technology', 'Dr. Arjun Patel', 'Springer', 650.75),
(5, 'Winds of the Desert', 'Adventure', 'Liam Johnson', 'Macmillan', 280.00),
(6, 'Python for Everyone', 'Education', 'Sophia Adams', 'Packt Publishing', 520.00),
(7, 'Secrets of the Ocean', 'Science', 'Noah Williams', 'Pearson', 310.45),
(8, 'Mind Over Matter', 'Self-Help', 'Olivia Brown', 'Simon & Schuster', 275.00),
(9, 'The Rising Sun', 'History', 'Ethan Miller', 'Oxford University Press', 450.20),
(10, 'Cooking Made Simple', 'Cooking', 'Isabella Garcia', 'Bloomsbury', 199.99),
(11, 'Shadows of Time', 'Fiction', 'Benjamin Scott', 'HarperCollins', 320.00),
(12, 'C++ in Depth', 'Education', 'Natalie Evans', 'O\'Reilly Media', 570.60),
(13, 'Tales of the Forgotten', 'Fantasy', 'Lucas Turner', 'Penguin Random House', 410.00),
(14, 'Artificial Intelligence Explained', 'Technology', 'Dr. Priya Nair', 'Springer', 720.90),
(15, 'Journey to the North', 'Adventure', 'Mason Clark', 'Macmillan', 260.00),
(16, 'Learn SQL in 30 Days', 'Education', 'Grace Hall', 'Packt Publishing', 480.75),
(17, 'Exploring Space', 'Science', 'James Lee', 'Pearson', 350.00),
(18, 'The Happiness Habit', 'Self-Help', 'Mia Walker', 'Simon & Schuster', 290.00),
(19, 'Empire of the East', 'History', 'Alexander Harris', 'Oxford University Press', 510.40),
(20, 'The Art of Baking', 'Cooking', 'Charlotte Lewis', 'Bloomsbury', 225.00),
(21, 'Echoes of Eternity', 'Fiction', 'Henry Roberts', 'HarperCollins', 315.00),
(22, 'JavaScript for Beginners', 'Education', 'Ella Martinez', 'O\'Reilly Media', 430.20),
(23, 'Dragonfire', 'Fantasy', 'Matthew White', 'Penguin Random House', 385.00),
(24, 'Deep Learning Simplified', 'Technology', 'Dr. Neha Sharma', 'Springer', 800.00),
(25, 'The Great Escape', 'Adventure', 'Jack Wilson', 'Macmillan', 270.50),
(26, 'Mastering Python', 'Education', 'Ava Thompson', 'Packt Publishing', 600.00),
(27, 'Wonders of Biology', 'Science', 'Samuel King', 'Pearson', 340.00),
(28, 'Think Positive', 'Self-Help', 'Harper Young', 'Simon & Schuster', 265.75),
(29, 'World Wars Uncovered', 'History', 'Michael Green', 'Oxford University Press', 480.00),
(30, 'Flavors of Italy', 'Cooking', 'Sofia Lopez', 'Bloomsbury', 210.99),
(31, 'The Last Horizon', 'Fiction', 'Daniel Wright', 'HarperCollins', 330.00),
(32, 'Programming in C#', 'Education', 'Chloe Adams', 'O\'Reilly Media', 550.40),
(33, 'The Crystal Sword', 'Fantasy', 'Ryan Hill', 'Penguin Random House', 395.00),
(34, 'Blockchain Revolution', 'Technology', 'Dr. Rakesh Mehta', 'Springer', 870.60),
(35, 'Riders of the Storm', 'Adventure', 'Zoe Carter', 'Macmillan', 285.00),
(36, 'Hands-on React', 'Education', 'Ella Parker', 'Packt Publishing', 490.25),
(37, 'Physics for All', 'Science', 'Liam Davis', 'Pearson', 375.00),
(38, 'The Power of Focus', 'Self-Help', 'Abigail Moore', 'Simon & Schuster', 300.00),
(39, 'Civilizations of the Past', 'History', 'William Allen', 'Oxford University Press', 520.00),
(40, 'Quick & Easy Recipes', 'Cooking', 'Emily Young', 'Bloomsbury', 180.50),
(41, 'Whispers in the Dark', 'Fiction', 'Jacob Baker', 'HarperCollins', 299.75),
(42, 'Algorithms Unlocked', 'Education', 'Natalie Torres', 'O\'Reilly Media', 610.00),
(43, 'Crown of Flames', 'Fantasy', 'Sophia Reed', 'Penguin Random House', 420.30),
(44, 'Cybersecurity Essentials', 'Technology', 'Dr. Vikram Iyer', 'Springer', 750.00),
(45, 'Into the Wildlands', 'Adventure', 'Andrew Scott', 'Macmillan', 295.40),
(46, 'Practical Data Science', 'Education', 'Ella Carter', 'Packt Publishing', 640.00),
(47, 'Chemistry Basics', 'Science', 'Oliver Turner', 'Pearson', 325.00),
(48, 'Unlocking Potential', 'Self-Help', 'Aiden Rivera', 'Simon & Schuster', 285.00),
(49, 'The Roman Empire', 'History', 'Grace Bennett', 'Oxford University Press', 505.25),
(50, 'Healthy Living Cookbook', 'Cooking', 'Lily Foster', 'Bloomsbury', 230.00);

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

--
-- Table structure for table `cart`
--

DROP TABLE IF EXISTS `cart`;
CREATE TABLE IF NOT EXISTS `cart` (
  `username` varchar(100) NOT NULL,
  `product_id` int NOT NULL,
  `qty` int NOT NULL,
  `price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`username`,`product_id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `order_info`
--

DROP TABLE IF EXISTS `order_info`;
CREATE TABLE IF NOT EXISTS `order_info` (
  `order_id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `username` varchar(100) NOT NULL,
  `qty` int NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `pin` varchar(10) NOT NULL,
  `locality` varchar(150) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `payment` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`order_id`),
  KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `order_info`
--

INSERT INTO `order_info` (`order_id`, `product_id`, `username`, `qty`, `price`, `pin`, `locality`, `address`, `city`, `state`, `payment`) VALUES
(1, 42, 'ionat', 1, 610.00, '600126', 'ABCD', '123 Main Street, Side Street,', 'Chennai', 'Tamil Nadu', 'COD');

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

--
-- Table structure for table `order_status`
--

DROP TABLE IF EXISTS `order_status`;
CREATE TABLE IF NOT EXISTS `order_status` (
  `order_id` int NOT NULL,
  `status` varchar(50) NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `order_status`
--

INSERT INTO `order_status` (`order_id`, `status`) VALUES
(1, 'Delivered');

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

--
-- Table structure for table `product_stock`
--

DROP TABLE IF EXISTS `product_stock`;
CREATE TABLE IF NOT EXISTS `product_stock` (
  `product_id` int NOT NULL,
  `discount` decimal(5,2) DEFAULT '0.00',
  `stock_num` int DEFAULT '0',
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `product_stock`
--

INSERT INTO `product_stock` (`product_id`, `discount`, `stock_num`) VALUES
(1, 10.00, 25),
(2, 0.00, 50),
(3, 15.00, 30),
(4, 5.00, 40),
(5, 20.00, 12),
(6, 0.00, 60),
(7, 25.00, 18),
(8, 0.00, 70),
(9, 5.00, 45),
(10, 10.00, 22),
(11, 0.00, 55),
(12, 30.00, 10),
(13, 15.00, 28),
(14, 0.00, 65),
(15, 10.00, 35),
(16, 0.00, 80),
(17, 20.00, 15),
(18, 5.00, 40),
(19, 25.00, 20),
(20, 0.00, 75),
(21, 15.00, 32),
(22, 10.00, 28),
(23, 0.00, 60),
(24, 30.00, 8),
(25, 20.00, 18),
(26, 0.00, 70),
(27, 10.00, 25),
(28, 5.00, 38),
(29, 15.00, 30),
(30, 0.00, 90),
(31, 25.00, 12),
(32, 0.00, 55),
(33, 20.00, 20),
(34, 10.00, 42),
(35, 0.00, 85),
(36, 30.00, 7),
(37, 15.00, 33),
(38, 5.00, 47),
(39, 10.00, 29),
(40, 0.00, 65),
(41, 20.00, 16),
(42, 0.00, 74),
(43, 25.00, 19),
(44, 10.00, 36),
(45, 0.00, 82),
(46, 5.00, 48),
(47, 15.00, 27),
(48, 0.00, 95),
(49, 20.00, 14),
(50, 10.00, 30);

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

--
-- Table structure for table `transaction_details`
--

DROP TABLE IF EXISTS `transaction_details`;
CREATE TABLE IF NOT EXISTS `transaction_details` (
  `trans_id` int NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `username` varchar(100) NOT NULL,
  `card_num` varchar(20) NOT NULL,
  PRIMARY KEY (`trans_id`),
  KEY `order_id` (`order_id`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `user_details`
--

DROP TABLE IF EXISTS `user_details`;
CREATE TABLE IF NOT EXISTS `user_details` (
  `name` varchar(100) NOT NULL,
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `pwd` varchar(255) NOT NULL,
  `dob` date DEFAULT NULL,
  `gender` enum('Male','Female') DEFAULT NULL,
  `pin` varchar(10) DEFAULT NULL,
  `locality` varchar(150) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `mobile` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`username`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `mobile` (`mobile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_details`
--

INSERT INTO `user_details` (`name`, `username`, `pwd`, `dob`, `gender`, `pin`, `locality`, `address`, `city`, `state`, `email`, `mobile`) VALUES
('Iona Thomas', 'ionat', 'gubznf12', '1998-03-06', 'Female', '600126', 'ABCD', '123 Main Street, Side Street,', 'Chennai', 'Tamil Nadu', 'ionat@gmail.com', '7998899400');
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 */;