1xR4X2tN

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema CLG
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema CLG
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `CLG` DEFAULT CHARACTER SET utf8 ;
15USE `CLG` ;
16
17-- -----------------------------------------------------
18-- Table `CLG`.`EMPLOYEE`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `CLG`.`EMPLOYEE` (
21  `Ssn` INT NOT NULL,
22  `Ename` VARCHAR(100) NULL,
23  `Bdate` DATE NULL,
24  `Dno` INT NULL,
25  `Salary` INT NULL,
26  `EMPLOYEEcol` VARCHAR(45) NULL,
27  PRIMARY KEY (`Ssn`),
28  INDEX `fk_deptno_idx` (`Dno` ASC),
29  CONSTRAINT `fk_deptno`
30    FOREIGN KEY (`Dno`)
31    REFERENCES `CLG`.`DEPT` (`Dnumber`)
32    ON DELETE NO ACTION
33    ON UPDATE NO ACTION)
34ENGINE = InnoDB;
35
36
37-- -----------------------------------------------------
38-- Table `CLG`.`DEPT`
39-- -----------------------------------------------------
40CREATE TABLE IF NOT EXISTS `CLG`.`DEPT` (
41  `Dnumber` INT NOT NULL,
42  `Dname` VARCHAR(100) NULL,
43  `Founded` DATE NULL,
44  `Mgr_ssn` INT NULL,
45  `Budget` INT NULL,
46  `DEPTcol` VARCHAR(45) NULL,
47  PRIMARY KEY (`Dnumber`),
48  INDEX `fk_empssn_idx` (`Mgr_ssn` ASC),
49  CONSTRAINT `fk_empssn`
50    FOREIGN KEY (`Mgr_ssn`)
51    REFERENCES `CLG`.`EMPLOYEE` (`Ssn`)
52    ON DELETE NO ACTION
53    ON UPDATE NO ACTION)
54ENGINE = InnoDB;
55
56
57SET SQL_MODE=@OLD_SQL_MODE;
58SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
59SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;