zE8QEMT6

1-- MySQL Script generated by MySQL Workbench
2-- Thu Nov 30 22:25:47 2017
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema hrappdb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema hrappdb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `hrappdb` DEFAULT CHARACTER SET utf8 ;
18USE `hrappdb` ;
19
20-- -----------------------------------------------------
21-- Table `hrappdb`.`person`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `hrappdb`.`person` (
24  `idperson` INT NOT NULL AUTO_INCREMENT,
25  `fName` VARCHAR(45) NOT NULL,
26  `lName` VARCHAR(45) NOT NULL,
27  `gender` ENUM('м', 'ж') NOT NULL,
28  `status` ENUM('зает', 'свободен') NOT NULL,
29  PRIMARY KEY (`idperson`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `hrappdb`.`company`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `hrappdb`.`company` (
37  `idcompany` INT NOT NULL AUTO_INCREMENT,
38  `companyName` VARCHAR(45) NULL,
39  `address` VARCHAR(45) NULL,
40  PRIMARY KEY (`idcompany`))
41ENGINE = InnoDB;
42
43
44-- -----------------------------------------------------
45-- Table `hrappdb`.`department`
46-- -----------------------------------------------------
47CREATE TABLE IF NOT EXISTS `hrappdb`.`department` (
48  `iddepartment` INT NOT NULL AUTO_INCREMENT,
49  `departmentName` VARCHAR(45) NULL,
50  `company_idcompany` INT NOT NULL,
51  `person_idperson` INT NOT NULL,
52  PRIMARY KEY (`iddepartment`, `company_idcompany`),
53  INDEX `fk_department_company_idx` (`company_idcompany` ASC),
54  INDEX `fk_department_person1_idx` (`person_idperson` ASC),
55  CONSTRAINT `fk_department_company`
56    FOREIGN KEY (`company_idcompany`)
57    REFERENCES `hrappdb`.`company` (`idcompany`)
58    ON DELETE NO ACTION
59    ON UPDATE NO ACTION,
60  CONSTRAINT `fk_department_person1`
61    FOREIGN KEY (`person_idperson`)
62    REFERENCES `hrappdb`.`person` (`idperson`)
63    ON DELETE NO ACTION
64    ON UPDATE NO ACTION)
65ENGINE = InnoDB;
66
67
68SET SQL_MODE=@OLD_SQL_MODE;
69SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
70SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
71
72-- -----------------------------------------------------
73-- Data for table `hrappdb`.`person`
74-- -----------------------------------------------------
75START TRANSACTION;
76USE `hrappdb`;
77INSERT INTO `hrappdb`.`person` (`idperson`, `fName`, `lName`, `gender`, `status`) VALUES (DEFAULT, 'Джон', 'Атанасов', 'м', 'зает');
78INSERT INTO `hrappdb`.`person` (`idperson`, `fName`, `lName`, `gender`, `status`) VALUES (DEFAULT, 'Майкъл', 'Дейвидсън', 'м', 'зает');
79INSERT INTO `hrappdb`.`person` (`idperson`, `fName`, `lName`, `gender`, `status`) VALUES (DEFAULT, 'Винсент', 'Пери', 'м', 'зает');
80INSERT INTO `hrappdb`.`person` (`idperson`, `fName`, `lName`, `gender`, `status`) VALUES (DEFAULT, 'Иван', 'Петров', 'м', 'зает');
81INSERT INTO `hrappdb`.`person` (`idperson`, `fName`, `lName`, `gender`, `status`) VALUES (DEFAULT, 'Филип', 'Кирилов', 'м', 'зает');
82INSERT INTO `hrappdb`.`person` (`idperson`, `fName`, `lName`, `gender`, `status`) VALUES (DEFAULT, 'Петър', 'Иванов', 'м', 'зает');
83INSERT INTO `hrappdb`.`person` (`idperson`, `fName`, `lName`, `gender`, `status`) VALUES (DEFAULT, 'Кирил', 'Димитров', 'м', 'зает');
84INSERT INTO `hrappdb`.`person` (`idperson`, `fName`, `lName`, `gender`, `status`) VALUES (DEFAULT, 'Вероника', 'Михайлова', 'ж', 'свободен');
85
86COMMIT;
87
88
89-- -----------------------------------------------------
90-- Data for table `hrappdb`.`company`
91-- -----------------------------------------------------
92START TRANSACTION;
93USE `hrappdb`;
94INSERT INTO `hrappdb`.`company` (`idcompany`, `companyName`, `address`) VALUES (DEFAULT, 'Hewlett-Packard', 'Германия');
95INSERT INTO `hrappdb`.`company` (`idcompany`, `companyName`, `address`) VALUES (DEFAULT, 'Dell', 'Белгия');
96INSERT INTO `hrappdb`.`company` (`idcompany`, `companyName`, `address`) VALUES (DEFAULT, 'Acer', 'Китай');
97INSERT INTO `hrappdb`.`company` (`idcompany`, `companyName`, `address`) VALUES (DEFAULT, 'Asus', 'САЩ');
98INSERT INTO `hrappdb`.`company` (`idcompany`, `companyName`, `address`) VALUES (DEFAULT, 'Apple', 'Аржентина');
99INSERT INTO `hrappdb`.`company` (`idcompany`, `companyName`, `address`) VALUES (DEFAULT, 'Tesla', 'Испания');
100
101COMMIT;
102
103
104-- -----------------------------------------------------
105-- Data for table `hrappdb`.`department`
106-- -----------------------------------------------------
107START TRANSACTION;
108USE `hrappdb`;
109INSERT INTO `hrappdb`.`department` (`iddepartment`, `departmentName`, `company_idcompany`, `person_idperson`) VALUES (DEFAULT, 'Човешки Ресурси', 1, 1);
110INSERT INTO `hrappdb`.`department` (`iddepartment`, `departmentName`, `company_idcompany`, `person_idperson`) VALUES (DEFAULT, 'Продажби', 1, 2);
111INSERT INTO `hrappdb`.`department` (`iddepartment`, `departmentName`, `company_idcompany`, `person_idperson`) VALUES (DEFAULT, 'Изследователски', 1, 3);
112INSERT INTO `hrappdb`.`department` (`iddepartment`, `departmentName`, `company_idcompany`, `person_idperson`) VALUES (DEFAULT, 'Международни отношения', 2, 4);
113INSERT INTO `hrappdb`.`department` (`iddepartment`, `departmentName`, `company_idcompany`, `person_idperson`) VALUES (DEFAULT, 'Маркетинг', 3, 5);
114INSERT INTO `hrappdb`.`department` (`iddepartment`, `departmentName`, `company_idcompany`, `person_idperson`) VALUES (DEFAULT, 'Маркетинг', 4, 6);
115INSERT INTO `hrappdb`.`department` (`iddepartment`, `departmentName`, `company_idcompany`, `person_idperson`) VALUES (DEFAULT, 'Човешки Ресурси', 5, 1);
116INSERT INTO `hrappdb`.`department` (`iddepartment`, `departmentName`, `company_idcompany`, `person_idperson`) VALUES (DEFAULT, 'Човешки Ресурси', 6, 4);
117INSERT INTO `hrappdb`.`department` (`iddepartment`, `departmentName`, `company_idcompany`, `person_idperson`) VALUES (DEFAULT, 'Изследователски', 6, 7);
118INSERT INTO `hrappdb`.`department` (`iddepartment`, `departmentName`, `company_idcompany`, `person_idperson`) VALUES (DEFAULT, 'Международни отношения', 3, 3);
119
120COMMIT;