text: -- phpMyAdmin SQL Dump
  -- version 5.0.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: May 26, 2020 at 11:04 AM
  -- Server version: 10.4.11-MariaDB
  -- PHP Version: 7.4.1
  
  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: `student_management`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `contact`
  --
  
  CREATE TABLE `contact` (
    `id` int(10) NOT NULL,
    `name` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `message` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `contact`
  --
  
  INSERT INTO `contact` (`id`, `name`, `email`, `message`) VALUES
  (1, 'B.Rabbit', 'gmhs13@yopmail.com', 'zdfcgvhbjk'),
  (3, 'Isaiah L. Smith', 'gmhs13@yopmail.com', 'fghj'),
  (4, 'Isaiah L. Smith', 'gmhs13@yopmail.com', 'fghj'),
  (5, 'B.Rabbit', 'gmhs13@yopmail.com', 'ajbdknl');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `course`
  --
  
  CREATE TABLE `course` (
    `id` int(10) NOT NULL,
    `c_name` varchar(255) NOT NULL,
    `c_description` varchar(255) NOT NULL,
    `c_dept` varchar(255) NOT NULL,
    `status` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `course`
  --
  
  INSERT INTO `course` (`id`, `c_name`, `c_description`, `c_dept`, `status`) VALUES
  (9, 'OOP2', 'C# Programming Language', 'EEE & CSE', 'Deactive'),
  (13, 'OOP1', 'JAVA Programming Language', 'CSE', 'Active'),
  (14, 'PL2', 'C++ Language', 'CSE & EEE', 'Active');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `note`
  --
  
  CREATE TABLE `note` (
    `id` int(10) NOT NULL,
    `name` varchar(255) NOT NULL,
    `title` varchar(255) NOT NULL,
    `details` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `note`
  --
  
  INSERT INTO `note` (`id`, `name`, `title`, `details`) VALUES
  (1, 'public/assets/note/1663565408006341.txt', 'Test', 'Test purpose'),
  (2, 'public/assets/note/1663621851614320.pdf', 'test2', 'Test purpose'),
  (3, 'public/assets/note/1667010449986677.txt', 'testing', 'Test purpose');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `notice`
  --
  
  CREATE TABLE `notice` (
    `id` int(10) NOT NULL,
    `subject` varchar(255) NOT NULL,
    `details` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `notice`
  --
  
  INSERT INTO `notice` (`id`, `subject`, `details`) VALUES
  (1, 'test', 'This is Test'),
  (2, 'test', 'This is Test'),
  (3, 'adwd', 'awghvjbdk');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `registration`
  --
  
  CREATE TABLE `registration` (
    `id` int(10) NOT NULL,
    `name` varchar(50) NOT NULL,
    `email` varchar(50) NOT NULL,
    `password` varchar(50) NOT NULL,
    `gender` varchar(10) NOT NULL,
    `address` varchar(255) NOT NULL,
    `phone` varchar(20) NOT NULL,
    `role` varchar(20) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `registration`
  --
  
  INSERT INTO `registration` (`id`, `name`, `email`, `password`, `gender`, `address`, `phone`, `role`) VALUES
  (2, 'Zihad', 'admin@g.com', '1234', 'male', 'tyvujbiojpk', '853200316494613', 'Admin'),
  (7, 'Isaiah L. Smith', 'teacher@gmail.com', '12345', 'male', '3125  Elkview Drive, Miami', '7865641399', 'Teacher'),
  (20, 'B.Rabbit', 'gmhs89@yopmail.com', '12345', 'male', '3125  Elkview Drive', '7865641399', 'Student'),
  (21, 'test', 'gmhs465@yopmail.com', '12345', 'male', '3125  Elkview Drive', '7865641399', 'Student');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `result`
  --
  
  CREATE TABLE `result` (
    `id` int(10) NOT NULL,
    `student_id` int(10) NOT NULL,
    `score` varchar(5) DEFAULT NULL,
    `grade` varchar(10) DEFAULT NULL,
    `role` varchar(20) NOT NULL DEFAULT 'Student'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `result`
  --
  
  INSERT INTO `result` (`id`, `student_id`, `score`, `grade`, `role`) VALUES
  (8, 20, '90', 'A+', 'Student');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `salary`
  --
  
  CREATE TABLE `salary` (
    `id` int(10) NOT NULL,
    `name` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `salary` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `salary`
  --
  
  INSERT INTO `salary` (`id`, `name`, `email`, `salary`) VALUES
  (1, 'Isaiah L. Smith', 'Isaiah@gmail.com', '20000'),
  (2, 'Teacher 2', 'test555@yopmail.com', '30000'),
  (3, 'Teacher 3', 'gmhs13@yopmail.com', '25000'),
  (4, 'Teacher 4', 'gmhs13@yopmail.com', '3000'),
  (5, 'Teacher 5', 'gmhs13@yopmail.com', '3000'),
  (6, 'Teacher 6', 'gmhs13@yopmail.com', '651320');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `contact`
  --
  ALTER TABLE `contact`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `course`
  --
  ALTER TABLE `course`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `note`
  --
  ALTER TABLE `note`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `notice`
  --
  ALTER TABLE `notice`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `registration`
  --
  ALTER TABLE `registration`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `result`
  --
  ALTER TABLE `result`
    ADD PRIMARY KEY (`id`),
    ADD KEY `result_ibfk_1` (`student_id`);
  
  --
  -- Indexes for table `salary`
  --
  ALTER TABLE `salary`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `contact`
  --
  ALTER TABLE `contact`
    MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `course`
  --
  ALTER TABLE `course`
    MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  
  --
  -- AUTO_INCREMENT for table `note`
  --
  ALTER TABLE `note`
    MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `notice`
  --
  ALTER TABLE `notice`
    MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `registration`
  --
  ALTER TABLE `registration`
    MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
  
  --
  -- AUTO_INCREMENT for table `result`
  --
  ALTER TABLE `result`
    MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  
  --
  -- AUTO_INCREMENT for table `salary`
  --
  ALTER TABLE `salary`
    MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `result`
  --
  ALTER TABLE `result`
    ADD CONSTRAINT `result_ibfk_1` FOREIGN KEY (`student_id`) REFERENCES `registration` (`id`) ON DELETE CASCADE ON UPDATE 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 */;
  