-- phpMyAdmin SQL Dump
-- version 2.8.2.4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 07, 2011 at 12:37 AM
-- Server version: 5.0.24
-- PHP Version: 5.1.6
-- 
-- Database: `nurs_school`
-- 

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

-- 
-- Table structure for table `mypinnos`
-- 

CREATE TABLE `mypinnos` (
  `PinKey` varchar(30) NOT NULL,
  PRIMARY KEY  (`PinKey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `mypinnos`
-- 

INSERT INTO `mypinnos` (`PinKey`) VALUES ('12345');

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

-- 
-- Table structure for table `schoolres`
-- 

CREATE TABLE `schoolres` (
  `StuExamNo` varchar(50) NOT NULL,
  `StudName` varchar(70) NOT NULL,
  `English` varchar(20) NOT NULL,
  `Maths` varchar(20) NOT NULL,
  `Health` varchar(20) NOT NULL,
  `GeStudy` varchar(20) NOT NULL,
  `Total` varchar(20) NOT NULL,
  `Avera` varchar(20) NOT NULL,
  PRIMARY KEY  (`StuExamNo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `schoolres`
-- 

INSERT INTO `schoolres` (`StuExamNo`, `StudName`, `English`, `Maths`, `Health`, `GeStudy`, `Total`, `Avera`) VALUES ('ScH0012', 'Grace Orji', '60', '40', '20', '50', '170', '34');