pKy5He6S

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
4 
5-- -----------------------------------------------------
6-- Schema mydb
7-- -----------------------------------------------------
8-- -----------------------------------------------------
9-- Schema user
10-- -----------------------------------------------------
11 
12-- -----------------------------------------------------
13-- Schema user
14-- -----------------------------------------------------
15CREATE SCHEMA IF NOT EXISTS `user` DEFAULT CHARACTER SET utf8 ;
16USE `user` ;
17 
18-- -----------------------------------------------------
19-- Table `user`.`t_student_assignments`
20-- -----------------------------------------------------
21CREATE TABLE IF NOT EXISTS `user`.`t_student_assignments` (
22  `Id` BIGINT(20) NOT NULL AUTO_INCREMENT,
23  `StudendId` BIGINT(20) NOT NULL,
24  `AssingnmentId` BIGINT(20) NOT NULL,
25  `Result` VARCHAR(60) NULL DEFAULT NULL,
26  `Date` DATETIME NOT NULL,
27  PRIMARY KEY (`Id`))
28ENGINE = InnoDB
29AUTO_INCREMENT = 310
30DEFAULT CHARACTER SET = latin1;
31 
32 
33-- -----------------------------------------------------
34-- Table `user`.`t_teacher_assignments`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `user`.`t_teacher_assignments` (
37  `Id` BIGINT(20) NOT NULL AUTO_INCREMENT,
38  `TotalMarks` VARCHAR(60) NOT NULL,
39  `DueDate` DATETIME NOT NULL,
40  `Date` DATETIME NOT NULL,
41  PRIMARY KEY (`Id`))
42ENGINE = InnoDB
43AUTO_INCREMENT = 313
44DEFAULT CHARACTER SET = latin1;
45 
46 
47-- -----------------------------------------------------
48-- Table `user`.`t_users`
49-- -----------------------------------------------------
50CREATE TABLE IF NOT EXISTS `user`.`t_users` (
51  `Id` BIGINT(20) NOT NULL AUTO_INCREMENT,
52  `Password` VARCHAR(50) NOT NULL,
53  `FirstName` VARCHAR(255) NOT NULL,
54  `LastName` VARCHAR(255) NULL DEFAULT NULL,
55  `Gender` VARCHAR(10) NOT NULL,
56  `Email` VARCHAR(255) NOT NULL,
57  `UserType` ENUM('Teacher', 'Student') NOT NULL DEFAULT 'Student',
58  `RegDate` DATE NOT NULL,
59  PRIMARY KEY (`Id`))
60ENGINE = InnoDB
61AUTO_INCREMENT = 3
62DEFAULT CHARACTER SET = latin1;
63 
64 
65SET SQL_MODE=@OLD_SQL_MODE;
66SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
67SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;t_userst_users