· 5 years ago · Jun 19, 2020, 03:32 PM
1CREATE DATABASE IF NOT EXISTS `hb_student_tracker`;
2USE `hb_student_tracker`;
3
4--
5-- Table structure for table `student`
6--
7
8DROP TABLE IF EXISTS `student`;
9
10CREATE TABLE `student` (
11 `id` int(11) NOT NULL AUTO_INCREMENT,
12 `first_name` varchar(45) DEFAULT NULL,
13 `last_name` varchar(45) DEFAULT NULL,
14 `email` varchar(45) DEFAULT NULL,
15 PRIMARY KEY (`id`)
16) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;