· 6 years ago · Mar 09, 2019, 04:16 PM
1-- MySQL Script generated by MySQL Workbench
2-- 11/19/18 10:26:17
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 BazaKadry
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema BazaKadry
16-- -----------------------------pracownicy------------------------
17CREATE SCHEMA IF NOT EXISTS `BazaKadry` DEFAULT CHARACTER SET utf8 ;
18USE `BazaKadry` ;
19
20-- -----------------------------------------------------
21-- Table `BazaKadry`.`Pracownicy`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `BazaKadry`.`Pracownicy` (
24 `idPracownicy` INT NOT NULL,
25 `imiePracownik` VARCHAR(45) NULL,
26 `nazwiskoPracownik` VARCHAR(45) NULL,
27 PRIMARY KEY (`idPracownicy`))
28ENGINE = InnoDB;
29
30
31SET SQL_MODE=@OLD_SQL_MODE;
32SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
33SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;