· 8 years ago · Jan 06, 2018, 10:52 AM
1-- phpMyAdmin SQL Dump
2-- version 3.3.9
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jan 06, 2018 at 11:45 AM
7-- Server version: 5.5.8
8-- PHP Version: 5.3.5
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Database: `ust`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Table structure for table `students`
26--
27
28CREATE TABLE IF NOT EXISTS `students` (
29 `id` int(11) DEFAULT NULL,
30 `name` varchar(50) DEFAULT NULL,
31 `mname` varchar(2) DEFAULT NULL,
32 `lname` varchar(50) DEFAULT NULL,
33 `address` varchar(250) DEFAULT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35
36--
37-- Dumping data for table `students`
38--
39
40INSERT INTO `students` (`id`, `name`, `mname`, `lname`, `address`) VALUES
41(1, 'Son', 'M', 'Goku', 'Oas Albay'),
42(2, 'Tony', 'S', 'Stark', 'Daraga Albay'),
43(3, 'Steve', 'R', 'Rogers', 'Camalig Albay'),
44(4, 'Natasha', 'F', 'Romanof', 'Daraga Albay'),
45(5, 'Bruce', 'D', 'Wane', 'Legazpi Albay'),
46(6, 'Phoenix', 'S', 'Darkk', 'Ligao Albay'),
47(7, 'Doctor', 'R', 'Strange', 'Camalig Albay'),
48(8, 'Doctor', 'F', 'Doom', 'Daraga Albay'),
49(9, 'Watafak', 'F', 'Watata', 'Legazpi Albay'),
50(10, 'Stan', 'Z', 'Lee', 'Legazpi Albay');
51
52-- --------------------------------------------------------
53
54--
55-- Table structure for table `student_grades`
56--
57
58CREATE TABLE IF NOT EXISTS `student_grades` (
59 `Id` int(11) DEFAULT NULL,
60 `Name` varchar(50) DEFAULT NULL,
61 `Mname` varchar(2) DEFAULT NULL,
62 `Lname` varchar(50) DEFAULT NULL,
63 `prelim_grade` float(5,2) DEFAULT NULL,
64 `midterm_grade` float(5,2) DEFAULT NULL,
65 `prefinal_grade` float(5,2) DEFAULT NULL,
66 `final_grade` float(5,2) DEFAULT NULL
67) ENGINE=InnoDB DEFAULT CHARSET=latin1;
68
69--
70-- Dumping data for table `student_grades`
71--
72
73INSERT INTO `student_grades` (`Id`, `Name`, `Mname`, `Lname`, `prelim_grade`, `midterm_grade`, `prefinal_grade`, `final_grade`) VALUES
74(1, 'Moira', 'Z', 'Mactaggert', 72.00, 82.90, 80.10, 72.30),
75(2, 'Abraham', 'D', 'Whistler', 74.40, 65.80, 90.10, 86.00),
76(3, 'Alicia', 'K', 'Masters', 87.10, 85.00, 67.00, 76.30),
77(4, 'Happy', 'Z', 'Hogan', 90.30, 72.70, 89.80, 72.90),
78(5, 'Sally', 'V', 'Floyd', 87.70, 70.00, 74.60, 78.40),
79(6, 'Moira', 'Z', 'Mactaggert', 86.20, 88.80, 83.60, 74.10),
80(7, 'Geralt', 'Of', 'Rivia', 77.10, 73.50, 74.60, 71.70),
81(8, 'Yennefer', 'Of', 'Vengerberg', 90.20, 70.10, 84.10, 77.60),
82(9, 'Triss', 'B', 'Merigold', 73.00, 67.10, 89.90, 73.50),
83(10, 'Roach', 'R', 'Roach', 80.50, 84.30, 81.00, 87.40),
84(11, 'Katy', 'Y', 'Farrell', 80.57, 84.32, 99.00, 68.44),
85(12, 'Robert', 'X', 'Kelly', 70.60, 79.00, 87.00, 72.10),
86(13, 'Rick', 'C', 'Jones', 69.40, 87.30, 85.00, 88.00),
87(14, 'Henry', 'P', 'Gyrich', 65.80, 86.00, 74.10, 60.30),
88(15, 'Franklyn', 'G', 'Storm', 66.00, 61.00, 68.30, 92.20),
89(16, 'Vallery', 'A', 'Cooper', 79.80, 82.10, 84.50, 95.00),
90(17, 'Turk', 'H', 'Barret', 90.90, 85.10, 79.00, 90.70),
91(18, 'Dog', 'W', 'Logan', 60.50, 81.00, 69.00, 74.00),
92(19, 'Dead', 'O', 'Pool', 73.90, 88.00, 80.10, 92.00),
93(20, 'Stan', 'N', 'Lee', 93.90, 89.90, 90.90, 95.90);