--
-- Host: localhost    Database: learning_application
-- ------------------------------------------------------


--
-- Table structure for table `comment`
--

CREATE TABLE `comment` (
  `comment_ID` int(11) NOT NULL AUTO_INCREMENT,
  `description` char(50) DEFAULT NULL,
  PRIMARY KEY (`comment_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `comment`
--

INSERT INTO `comment` VALUES
(1,'WOW! THANKS!'),
(2,'This was very helpful'),
(3,'Thanks for clearing this up'),
(4,'This helped my studies greatly'),
(5,'Could you exlain sig figs?'),
(6,'Dint help too long'),
(7,'Sorry i could not follow along not helpful'),
(8,'I dont think this is correct...'),
(9,'HUH???'),
(10,'This is just completetly wrong please delete :)');

--
-- Table structure for table `creator`
--

CREATE TABLE `creator` (
  `creator_ID` int(11) NOT NULL AUTO_INCREMENT,
  `expertise` char(50) DEFAULT NULL,
  PRIMARY KEY (`creator_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `creator`
--

INSERT INTO `creator` VALUES
(1,'Math'),
(2,'English'),
(3,'History'),
(4,'Geography'),
(5,'Chemistry'),
(6,'Biology'),
(7,'Computer_Science'),
(8,'Calculus'),
(9,'World War II'),
(10,'Essay Writing');

--
-- Table structure for table `lesson`
--

CREATE TABLE `lesson` (
  `lesson_ID` int(11) NOT NULL AUTO_INCREMENT,
  `subject` char(50) DEFAULT NULL,
  PRIMARY KEY (`lesson_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `lesson`
--

INSERT INTO `lesson` VALUES
(1,'Math'),
(2,'English'),
(3,'History'),
(4,'Science'),
(5,'Science'),
(6,'Computer Science'),
(7,'Math'),
(8,'History'),
(9,'English');

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `rating_ID` int(11) NOT NULL AUTO_INCREMENT,
  `number` char(50) DEFAULT NULL,
  PRIMARY KEY (`rating_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `rating`
--

INSERT INTO `rating` VALUES
(1,'10'),
(2,'7'),
(3,'8'),
(4,'9'),
(5,'5'),
(6,'3'),
(7,'4'),
(8,'2'),
(9,'6'),
(10,'1');


