|
| 1 | +-- phpMyAdmin SQL Dump |
| 2 | +-- version 4.5.1 |
| 3 | +-- http://www.phpmyadmin.net |
| 4 | +-- |
| 5 | +-- Host: 127.0.0.1 |
| 6 | +-- Generation Time: Aug 26, 2017 at 12:41 AM |
| 7 | +-- Server version: 10.1.13-MariaDB |
| 8 | +-- PHP Version: 7.0.8 |
| 9 | + |
| 10 | +SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; |
| 11 | +SET time_zone = "+00:00"; |
| 12 | + |
| 13 | + |
| 14 | +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
| 15 | +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
| 16 | +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
| 17 | +/*!40101 SET NAMES utf8mb4 */; |
| 18 | + |
| 19 | +-- |
| 20 | +-- Database: `java_registration` |
| 21 | +-- |
| 22 | + |
| 23 | +-- -------------------------------------------------------- |
| 24 | + |
| 25 | +-- |
| 26 | +-- Table structure for table `adminstrator` |
| 27 | +-- |
| 28 | + |
| 29 | +CREATE TABLE `adminstrator` ( |
| 30 | + `adminNo` varchar(10) DEFAULT NULL, |
| 31 | + `name` varchar(20) DEFAULT NULL, |
| 32 | + `gender` varchar(10) DEFAULT NULL, |
| 33 | + `phoneNo` varchar(15) DEFAULT NULL, |
| 34 | + `Email` varchar(225) DEFAULT NULL |
| 35 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 36 | + |
| 37 | +-- |
| 38 | +-- Dumping data for table `adminstrator` |
| 39 | +-- |
| 40 | + |
| 41 | +INSERT INTO `adminstrator` (`adminNo`, `name`, `gender`, `phoneNo`, `Email`) VALUES |
| 42 | +('ad01', 'Sammuel', 'Male', '0-778-589-369', NULL), |
| 43 | +('ad02', 'Tracy', 'Female', '0-712-993-698', NULL), |
| 44 | +('ad03', 'Hariet', 'Female', '0-704-965-785', NULL); |
| 45 | + |
| 46 | +-- -------------------------------------------------------- |
| 47 | + |
| 48 | +-- |
| 49 | +-- Table structure for table `enroll` |
| 50 | +-- |
| 51 | + |
| 52 | +CREATE TABLE `enroll` ( |
| 53 | + `Regno` varchar(10) DEFAULT NULL, |
| 54 | + `course_code` varchar(10) DEFAULT NULL, |
| 55 | + `courseUnit` varchar(50) DEFAULT NULL, |
| 56 | + `marks` int(11) DEFAULT NULL, |
| 57 | + `grade` char(1) DEFAULT NULL |
| 58 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 59 | + |
| 60 | +-- |
| 61 | +-- Dumping data for table `enroll` |
| 62 | +-- |
| 63 | + |
| 64 | +INSERT INTO `enroll` (`Regno`, `course_code`, `courseUnit`, `marks`, `grade`) VALUES |
| 65 | +('142', 'ceu1', 'advanced database systems', 67, 'C'), |
| 66 | +('142', 'ceu2', 'computer networks', 80, 'A'), |
| 67 | +('123', 'ceu1', 'advanced database systems', 77, 'B'), |
| 68 | +('857', 'ceu1', 'advanced database systems', 50, 'C'), |
| 69 | +('875', 'ceu3', 'analysis of algorithms', 64, 'C'), |
| 70 | +('456', 'ceu2', 'computer networks', 90, 'A'), |
| 71 | +('013', 'ceu4', 'Database', 87, 'A'), |
| 72 | +('378', 'ceu5', 'system administration', 79, 'A'), |
| 73 | +('782', 'ceu6', 'programming principles', 65, 'C'), |
| 74 | +('320', 'ceu7', 'Ethics', 73, 'B'), |
| 75 | +('320', 'ceu2', 'computer networks', 76, 'B'), |
| 76 | +('013', 'ceu6', 'programming principles', 62, 'C'), |
| 77 | +('782', 'ceu3', 'analysis of algorithms', 67, 'C'), |
| 78 | +('378', 'ceu1', 'advanced database systems', 83, 'A'), |
| 79 | +('213', 'ceu4', 'Database', 80, 'A'), |
| 80 | +('278', 'ceu4', 'Database', 72, 'B'), |
| 81 | +('213', 'ceu6', 'programming principles', 80, 'A'), |
| 82 | +('213', 'ceu7', 'Ethics', 78, 'B'), |
| 83 | +('278', 'ceu7', 'Ethics', 69, 'C'), |
| 84 | +('278', 'ceu5', 'system administration', 75, 'B'); |
| 85 | + |
| 86 | +-- -------------------------------------------------------- |
| 87 | + |
| 88 | +-- |
| 89 | +-- Table structure for table `lecturer` |
| 90 | +-- |
| 91 | + |
| 92 | +CREATE TABLE `lecturer` ( |
| 93 | + `staffNo` varchar(10) DEFAULT NULL, |
| 94 | + `Fname` varchar(15) DEFAULT NULL, |
| 95 | + `Lname` varchar(15) DEFAULT NULL, |
| 96 | + `Age` int(11) DEFAULT NULL, |
| 97 | + `gender` varchar(10) DEFAULT NULL, |
| 98 | + `Address` varchar(20) DEFAULT NULL, |
| 99 | + `Email` varchar(255) DEFAULT NULL, |
| 100 | + `PhoneNo` varchar(15) DEFAULT NULL, |
| 101 | + `dept` varchar(255) DEFAULT NULL |
| 102 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 103 | + |
| 104 | +-- |
| 105 | +-- Dumping data for table `lecturer` |
| 106 | +-- |
| 107 | + |
| 108 | +INSERT INTO `lecturer` (`staffNo`, `Fname`, `Lname`, `Age`, `gender`, `Address`, `Email`, `PhoneNo`, `dept`) VALUES |
| 109 | +('le01', 'Annet', 'Nanta', 25, 'Female', 'Entebbe,najja', 'anne@gmail.com', '0-727-457-890', 'Faculty Of Scince and technology'), |
| 110 | +('le02', 'Bob', 'John', 25, 'Male', 'Kampala,Kibuli', 'bobjo@Yahoo.com', '0-797-224-752', 'Faculty Of Scince and technology'), |
| 111 | +('le03', 'Rose', 'Mary', 30, 'Female', 'Gulu,ayam', 'rosem@gmail.com', '0-787-878-998', 'Faculty Of Scince and technology'), |
| 112 | +('le04', 'Brian', 'Leju', 34, 'Male', 'Mukono,Nangwa', 'briale@rocketmail.com', '0-754-478-324', 'Faculty Of Law'), |
| 113 | +('le05', 'Lwiza', 'Ayikoru', 33, 'Female', 'Arua,Youmbee', 'lwiayi@hotmail.com', '0-787-488-361', 'Faculty Of Law'), |
| 114 | +('le06', 'JohnBosco', 'Wabwere', 31, 'Male', 'Kampala,Muyenga', 'wabzjo@Yahoo.com', '0-797-222-333', 'Scince and technology'), |
| 115 | +('le07', 'Nancy', 'Askipwe', 28, 'Female', 'Arua,bako', 'nancy@asphotmail.com', '0-787-118-551', 'Foundations Studies'); |
| 116 | + |
| 117 | +-- -------------------------------------------------------- |
| 118 | + |
| 119 | +-- |
| 120 | +-- Table structure for table `login` |
| 121 | +-- |
| 122 | + |
| 123 | +CREATE TABLE `login` ( |
| 124 | + `password` varchar(15) DEFAULT NULL, |
| 125 | + `username` varchar(20) DEFAULT NULL, |
| 126 | + `type` varchar(15) DEFAULT NULL |
| 127 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 128 | + |
| 129 | +-- |
| 130 | +-- Dumping data for table `login` |
| 131 | +-- |
| 132 | + |
| 133 | +INSERT INTO `login` (`password`, `username`, `type`) VALUES |
| 134 | +('ad00', 'robert', 'adminstrator'), |
| 135 | +('13', 'Robert', 'student'), |
| 136 | +('le08', 'robert', 'lecturer'); |
| 137 | + |
| 138 | +-- -------------------------------------------------------- |
| 139 | + |
| 140 | +-- |
| 141 | +-- Table structure for table `student` |
| 142 | +-- |
| 143 | + |
| 144 | +CREATE TABLE `student` ( |
| 145 | + `RegNo` int(11) DEFAULT NULL, |
| 146 | + `Fname` varchar(15) DEFAULT NULL, |
| 147 | + `Lname` varchar(15) DEFAULT NULL, |
| 148 | + `Age` int(11) DEFAULT NULL, |
| 149 | + `Gender` varchar(10) DEFAULT NULL, |
| 150 | + `Address` varchar(15) DEFAULT NULL, |
| 151 | + `Programme` varchar(10) DEFAULT NULL, |
| 152 | + `PhoneNo` varchar(15) DEFAULT NULL, |
| 153 | + `Email` varchar(225) DEFAULT NULL |
| 154 | +) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 155 | + |
| 156 | +-- |
| 157 | +-- Dumping data for table `student` |
| 158 | +-- |
| 159 | + |
| 160 | +INSERT INTO `student` (`RegNo`, `Fname`, `Lname`, `Age`, `Gender`, `Address`, `Programme`, `PhoneNo`, `Email`) VALUES |
| 161 | +(142, 'Dart', 'Dranni', 20, 'Male', 'Arua,ayui', 'BSCs', NULL, NULL), |
| 162 | +(123, 'lisa', 'Namata', 21, 'Female', 'Kampala,Gayaza', 'BITs', '234567', 'lisa@home.com'), |
| 163 | +(857, 'milhouse', 'Eree', 23, 'Male', 'Mukono,Kayunga', 'BSCs', NULL, NULL), |
| 164 | +(456, 'Ralph', 'Macher', 21, 'Male', 'Enttebe,Kazi', 'BSCs', NULL, NULL), |
| 165 | +(320, 'Robin', 'Waswaa', 23, 'Male', 'Mukono,Kasoo', 'BITs', NULL, NULL), |
| 166 | +(13, 'Robert', 'Andama', 22, 'Male', 'Mbarara,Mataa', 'LIBs', '0787458902', 'rolynandama@gmail.com'), |
| 167 | +(378, 'Matha', 'Anne', 21, 'Female', 'Mbale,fttee', 'BES', NULL, NULL), |
| 168 | +(213, 'Grace', 'Mutoni', 22, 'Female', 'Wakiso,Mbuya', 'LIBs', NULL, NULL), |
| 169 | +(782, 'Joana', 'Yangi', 25, 'Female', 'Soroti,oyamu', 'LIBs', NULL, NULL), |
| 170 | +(278, 'Juliana', 'Tabu', 21, 'Female', 'Mbale,fttee', 'BES', NULL, NULL); |
| 171 | + |
| 172 | +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
| 173 | +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
| 174 | +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
0 commit comments