Rq905KbM

1-- MySQL Script generated by MySQL Workbench
2-- Sun Oct  6 12:56:00 2019
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 saba_pl
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema saba_pl
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `saba_pl` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci ;
18USE `saba_pl` ;
19
20-- -----------------------------------------------------
21-- Table `saba_pl`.`grupa`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `saba_pl`.`grupa` (
24  `id_grupa` INT NOT NULL AUTO_INCREMENT,
25  `nazwa_grupa` VARCHAR(45) NOT NULL,
26  PRIMARY KEY (`id_grupa`),
27  UNIQUE INDEX `nazwa_grupa_UNIQUE` (`nazwa_grupa` ASC))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `saba_pl`.`kontakt`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `saba_pl`.`kontakt` (
35  `id_kontakt` INT NOT NULL AUTO_INCREMENT,
36  `imie` VARCHAR(45) NOT NULL,
37  `nazwisko` VARCHAR(45) NOT NULL,
38  `telefon` VARCHAR(45) NULL,
39  `email` VARCHAR(45) NULL,
40  `ulica` VARCHAR(45) NULL,
41  `kod` VARCHAR(45) NULL,
42  `poczta` VARCHAR(45) NULL,
43  `mobile` VARCHAR(45) NULL,
44  `grupa_id_grupa` INT NOT NULL,
45  PRIMARY KEY (`id_kontakt`, `grupa_id_grupa`),
46  INDEX `fk_kontakt_grupa_idx` (`grupa_id_grupa` ASC),
47  CONSTRAINT `fk_kontakt_grupa`
48    FOREIGN KEY (`grupa_id_grupa`)
49    REFERENCES `saba_pl`.`grupa` (`id_grupa`)
50    ON DELETE NO ACTION
51    ON UPDATE NO ACTION)
52ENGINE = InnoDB;
53
54
55SET SQL_MODE=@OLD_SQL_MODE;
56SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
57SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
58
59-- -----------------------------------------------------
60-- Data for table `saba_pl`.`grupa`
61-- -----------------------------------------------------
62START TRANSACTION;
63USE `saba_pl`;
64INSERT INTO `saba_pl`.`grupa` (`id_grupa`, `nazwa_grupa`) VALUES (1, 'szkola');
65INSERT INTO `saba_pl`.`grupa` (`id_grupa`, `nazwa_grupa`) VALUES (2, 'koledzy');
66INSERT INTO `saba_pl`.`grupa` (`id_grupa`, `nazwa_grupa`) VALUES (3, 'VIP');
67
68COMMIT;