-- phpMyAdmin SQL Dump
-- version 4.3.11
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 19, 2015 at 02:27 PM
-- Server version: 5.6.24
-- PHP Version: 5.6.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `techathon`
--

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

--
-- Table structure for table `laptop_authentication`
--

CREATE TABLE IF NOT EXISTS `laptop_authentication` (
  `Serial_Number` varchar(30) NOT NULL,
  `Employee_Name` varchar(30) NOT NULL,
  `Salary_Code` varchar(15) NOT NULL,
  `Project` varchar(20) NOT NULL,
  `Designation` varchar(30) NOT NULL,
  `Laptop_Detail` text NOT NULL,
  `Model` varchar(20) NOT NULL,
  `Asset_Code` varchar(15) NOT NULL,
  `Image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `laptop_authentication`
--

INSERT INTO `laptop_authentication` (`Serial_Number`, `Employee_Name`, `Salary_Code`, `Project`, `Designation`, `Laptop_Detail`, `Model`, `Asset_Code`, `Image`) VALUES
('$LAP_B97Q542', 'Kuldeep Yadav', '18417', 'AIRBUS', 'Software Engg', 'Laptop on lease from HPFS.', 'DELL E5450', '502247', 'C:\Users\gandhi\Documents\Pic\Pic1.jpg');

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

--
-- Table structure for table `library_management`
--

CREATE TABLE IF NOT EXISTS `library_management` (
  `Book_ID` varchar(20) NOT NULL,
  `Book_Name` varchar(50) NOT NULL,
  `Author_Name` varchar(50) NOT NULL,
  `Employee_ID` varchar(20) NOT NULL
  `Book_Image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `library_management`
--

INSERT INTO `library_management` (`Book_ID`, `Book_Name`, `Author_Name`,`Employee_ID`,`Book_Image`) VALUES
('$B_12409', 'Qt 4', 'Daniel Molkentin', '$15396', 'C:\Users\gandhi\Documents\Book\QT4.jpg');

/*!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 */;
