gistfile1.txt

/*
SQLyog Ultimate v8.32 
MySQL - 5.6.16 : Database - problem2
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`problem2` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `problem2`;

/*Data for the table `estimations` */

insert  into `estimations`(`id`,`userId`,`subjectId`,`est_date`,`pointId`) values (1,'123-456-789',1,'2013-12-01',8),(2,'123-456-789',1,'2013-12-01',3),(3,'123-456-789',2,'2013-12-01',1),(4,'123-456-789',2,'2013-12-01',2),(5,'123-456-789',1,'2012-10-01',4),(6,'123-456-789',3,'2012-10-01',4),(7,'123-456-789',3,'2012-10-01',1),(8,'123-456-789',2,'2012-10-01',2),(9,'123-456-789',1,'2012-03-01',1),(10,'123-456-789',1,'2012-03-01',2),(11,'123-456-789',4,'2012-03-01',3),(12,'123-456-789',2,'2012-03-01',1);

/*Data for the table `majors` */

insert  into `majors`(`id`,`name`) values (1,'Computer Science');

/*Data for the table `person` */

insert  into `person`(`id`,`name`,`gpa`,`majorId`) values ('123-456-789','John Doe',NULL,1);

/*Data for the table `points` */

insert  into `points`(`id`,`point`,`name`) values (1,4,'A'),(2,3.7,'A-'),(3,3.33,'B+'),(4,3,'B'),(5,2.7,'B-'),(6,2.3,'C+'),(7,2,'C'),(8,1.7,'C'),(9,1.3,'D+'),(10,1,'D');

/*Data for the table `subjects` */

insert  into `subjects`(`id`,`name`) values (1,'Math'),(2,'Comp Sci'),(3,'English'),(4,'History');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;