forgot to put my database
-- phpMyAdmin SQL Dump
-- version 4.1.6
-- Host: 127.0.0.1
-- Generation Time: Jul 25, 2014 at 05:52 AM
-- Server version: 5.6.16
-- PHP Version: 5.5.9
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 /;
--
-- Database: school
--
-- Table structure for table class
CREATE TABLE IF NOT EXISTS class (
id int(11) NOT NULL AUTO_INCREMENT,
subject varchar(30) COLLATE utf8_spanish_ci NOT NULL,
unit varchar(5) COLLATE utf8_spanish_ci NOT NULL,
homework varchar(50) COLLATE utf8_spanish_ci NOT NULL,
dueDate date NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=11 ;
--
-- Dumping data for table class
INSERT INTO class (id, subject, unit, homework, dueDate) VALUES
(1, 'Math', 'UI', 'Math work1', '2014-04-04'),
(2, 'Math', 'UI', 'Math work2', '2014-05-12'),
(3, 'Science', 'UI', 'Science work1', '2014-04-09'),
(4, 'Home Economics', 'UII', 'Home economics work1', '2014-04-16'),
(5, 'Math', 'UII', 'Math work 3', '2014-05-12'),
(6, 'Math', 'UIII', 'Math work4', '2014-05-21'),
(7, 'Science', 'UII', 'Science work2', '2014-05-14'),
(8, 'Physics', 'UI', 'Physics work1', '2014-05-06'),
(9, 'Math', 'UIII', 'Math work5', '2014-07-16'),
(10, 'Math', 'UIV', 'Math work6', '2014-07-14');
/!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 /;