text: -- phpMyAdmin SQL Dump
  -- version 4.8.3
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Nov 14, 2018 at 07:30 AM
  -- Server version: 10.1.35-MariaDB
  -- PHP Version: 7.2.9
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  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: `resume_builder`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `login`
  --
  
  CREATE TABLE `login` (
    `user_id` int(11) NOT NULL,
    `username` varchar(30) NOT NULL,
    `password` varchar(30) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `login`
  --
  
  INSERT INTO `login` (`user_id`, `username`, `password`) VALUES
  (14567, 'arbaaz2410', 'root123');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `resumes`
  --
  
  CREATE TABLE `resumes` (
    `resume_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `resume_name` varchar(30) NOT NULL,
    `date` date NOT NULL,
    `filename` varchar(500) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `resumes`
  --
  
  INSERT INTO `resumes` (`resume_id`, `user_id`, `resume_name`, `date`, `filename`) VALUES
  (1, 14567, 'doppio', '2018-11-14', 'user_resumes14567_doppio_2018-11-14_06-28-38.html'),
  (2, 14567, 'heavy', '2018-11-14', 'user_resumes14567_heavy_2018-11-14_06-45-16.html'),
  (3, 14567, 'vandeco', '2018-11-14', 'user_resumes14567_vandeco_2018-11-14_06-54-48.html');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user_details`
  --
  
  CREATE TABLE `user_details` (
    `full_name` varchar(30) NOT NULL,
    `username` varchar(20) NOT NULL,
    `email` varchar(30) NOT NULL,
    `ph_no` bigint(20) NOT NULL,
    `dob` date NOT NULL,
    `password` varchar(30) NOT NULL,
    `user_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Storing USER Details';
  
  --
  -- Dumping data for table `user_details`
  --
  
  INSERT INTO `user_details` (`full_name`, `username`, `email`, `ph_no`, `dob`, `password`, `user_id`) VALUES
  ('DM Arbaaz', 'arbaaz2410', 'arbaaz2410@gmail.com', 9611906587, '1997-10-24', 'root123', 14567),
  ('d.m arbaaz1', 'arbaaz24101', 'km.firas1212@gmail.com', 9823472423, '2018-11-01', 'randi', 14568),
  ('gsgg', 'arbaaz24101', 'official.arbaaz2410@gmail.com', 8172493724, '2018-11-20', 'rabdi', 14569);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `login`
  --
  ALTER TABLE `login`
    ADD PRIMARY KEY (`user_id`);
  
  --
  -- Indexes for table `resumes`
  --
  ALTER TABLE `resumes`
    ADD PRIMARY KEY (`resume_id`);
  
  --
  -- Indexes for table `user_details`
  --
  ALTER TABLE `user_details`
    ADD PRIMARY KEY (`user_id`);
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `login`
  --
  ALTER TABLE `login`
    ADD CONSTRAINT `login_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_details` (`user_id`) ON DELETE 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 */;
  