-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 20, 2023 at 07:54 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

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

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

--
-- Table structure for table `b1`
--

CREATE TABLE `b1` (
  `id` int(225) NOT NULL,
  `stu_name` varchar(225) NOT NULL,
  `stu_year` varchar(225) NOT NULL,
  `stu_department` varchar(225) NOT NULL,
  `stu_batch` varchar(225) NOT NULL,
  `stu_achievements` int(225) NOT NULL,
  `stu_eventname` varchar(225) NOT NULL,
  `stu_achievelocation` varchar(225) NOT NULL,
  `stu_achievefrom` varchar(225) NOT NULL,
  `stu_achieveto` varchar(225) NOT NULL,
  `stu_description` varchar(500) NOT NULL,
  `stu_achievefile` varchar(333) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `b1`
--

INSERT INTO `b1` (`id`, `stu_name`, `stu_year`, `stu_department`, `stu_batch`, `stu_achievements`, `stu_eventname`, `stu_achievelocation`, `stu_achievefrom`, `stu_achieveto`, `stu_description`, `stu_achievefile`) VALUES
(1, 'Vanshika', 'II', 'CSE', '2025-2029', 1, 'Workshop', 'SMVEC', 'Dec 18, 2023', 'Dec 20, 2023', 'Recend trends in Deep Learning', 'FILE-6580bc9ec5c5aVanshika.docx'),
(2, 'Venisri Ravi', 'II', 'BME', '   ', 1, 'workshop', 'chennai', 'Dec 18, 2023      ', 'Dec 23, 2023', 'very useful for learning.', 'FILE-6580bccc515a0Venisri.docx'),
(3, 'Mahalakshmi S', 'IV', 'BME', '2021-2025', 1, 'Workshop', 'SMVEC', 'Dec 17, 2023', 'Dec 22, 2023', 'Machine learning', 'FILE-6580bd120be7bMahalakshmi S.docx'),
(4, 'Balagopalan V', 'IV', 'ECE', '2019-2013', 2, 'Workshop,symposium', 'SMVEC,mathagadipet', 'Dec 03, 2023$Dec 18, 2023', 'Dec 08, 2023$Dec 23, 2023', 'very useful for learning.,Recend trends in Deep Learning', 'FILE-6580bd74c00dfBalagopalan V.docx,FILE-6580bd74c0695Balagopalan V.docx'),
(5, 'Sabarinathan S', 'III', 'CSE', '2021-2025', 1, 'Internship', 'Chennai', 'Dec 03, 2023', 'Feb 07, 2024', 'great  learning', 'FILE-6580d9b49d3caSabarinathan S.docx'),
(6, 'Ram', 'II', 'ECE', '2021-2025', 1, 'VINOMESW', 'Chennai', 'Dec 04, 2023', 'Dec 30, 2023', 'great  learning', 'FILE-6580daf0b5d68Ram.pdf'),
(7, 'Vinothini R', 'III', 'CSE', '2021-2025', 5, 'Sports,Workshop,Internship,Intercollege,Symposium', 'chennai,mumbai,delhi,pondy,Pune', 'Dec 03, 2023$Dec 04, 2023$Sep 10, 2023$Nov 06, 2023$Dec 10, 2023', 'Dec 08, 2023$Dec 15, 2023$Dec 15, 2023$Nov 10, 2023$Dec 13, 2023', 'great  learning,cvsfdgdfgdgbf,great  learning,arffwe,great  learning', 'FILE-6580ed427cb6cVinothini R.docx,FILE-6580ed427ce4fVinothini R.docx,FILE-6580ed427cf96Vinothini R.docx,FILE-6580ed427d084Vinothini R.docx,FILE-6580ed427d193Vinothini R.docx'),
(8, 'Lakshmi M', 'III', 'CSE', '2021-2025', 1, 'Workshop', 'SMVEC', 'Dec 11, 2023', 'Dec 28, 2023', 'very useful for learning.', 'FILE-65823c6f12b36Lakshmi M.pdf'),
(9, 'Ramesh Kanna B', 'IV', 'ECE', '2018-2022', 2, 'Workshop,Internship ', 'Mumbai,Chennai', 'Apr 08, 2020$May 08, 2023', 'May 07, 2020$Dec 08, 2023', 'Machine learning,As a Junior software developer', 'FILE-658244fbca309Ramesh Kanna B.docx,FILE-658244fbca4bcRamesh Kanna B.docx');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `b1`
--
ALTER TABLE `b1`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `b1`
--
ALTER TABLE `b1`
  MODIFY `id` int(225) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
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 */;
