· 9 years ago · Jan 25, 2017, 12:54 PM
1-- MySQL Script generated by MySQL Workbench
2-- 01/25/17 13:50:39
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 serwis
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `serwis` ;
14
15-- -----------------------------------------------------
16-- Schema serwis
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `serwis` DEFAULT CHARACTER SET utf8 ;
19SHOW WARNINGS;
20USE `serwis` ;
21
22-- -----------------------------------------------------
23-- Table `Klient`
24-- -----------------------------------------------------
25DROP TABLE IF EXISTS `Klient` ;
26
27SHOW WARNINGS;
28CREATE TABLE IF NOT EXISTS `Klient` (
29 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
30 `imie` VARCHAR(12) NOT NULL,
31 `nazwisko` VARCHAR(20) NOT NULL,
32 `nazwa_firmy` VARCHAR(20) NULL,
33 `nip` CHAR(10) NULL,
34 `pesel` CHAR(9) NULL,
35 `email` VARCHAR(25) NULL,
36 `miejscowosc` VARCHAR(25) NULL,
37 `kod_pocztowy` VARCHAR(7) NULL,
38 `ulica` VARCHAR(25) NULL,
39 `mieszkanie` CHAR(10) NULL,
40 PRIMARY KEY (`id`))
41ENGINE = InnoDB;
42
43SHOW WARNINGS;
44CREATE UNIQUE INDEX `id_UNIQUE` ON `Klient` (`id` ASC);
45
46SHOW WARNINGS;
47
48-- -----------------------------------------------------
49-- Table `Samochod`
50-- -----------------------------------------------------
51DROP TABLE IF EXISTS `Samochod` ;
52
53SHOW WARNINGS;
54CREATE TABLE IF NOT EXISTS `Samochod` (
55 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
56 `model` VARCHAR(45) NOT NULL,
57 `marka` VARCHAR(45) NOT NULL,
58 `nr_rejestracyjny` VARCHAR(45) NOT NULL,
59 `nr_ewidencyjny` VARCHAR(45) NULL,
60 `wlasciciel` INT UNSIGNED NOT NULL,
61 PRIMARY KEY (`id`))
62ENGINE = InnoDB;
63
64SHOW WARNINGS;
65CREATE UNIQUE INDEX `id_UNIQUE` ON `Samochod` (`id` ASC);
66
67SHOW WARNINGS;
68
69-- -----------------------------------------------------
70-- Table `Pracownik`
71-- -----------------------------------------------------
72DROP TABLE IF EXISTS `Pracownik` ;
73
74SHOW WARNINGS;
75CREATE TABLE IF NOT EXISTS `Pracownik` (
76 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
77 `imie` VARCHAR(45) NULL,
78 `nazwisko` VARCHAR(45) NULL,
79 `nazwa` VARCHAR(45) NULL,
80 `haslo` VARCHAR(45) NULL,
81 `pozycja` ENUM('kierownik', 'pracownik', 'zwolniony') NULL,
82 PRIMARY KEY (`id`))
83ENGINE = InnoDB;
84
85SHOW WARNINGS;
86CREATE UNIQUE INDEX `id_UNIQUE` ON `Pracownik` (`id` ASC);
87
88SHOW WARNINGS;
89
90-- -----------------------------------------------------
91-- Table `Zlecenie`
92-- -----------------------------------------------------
93DROP TABLE IF EXISTS `Zlecenie` ;
94
95SHOW WARNINGS;
96CREATE TABLE IF NOT EXISTS `Zlecenie` (
97 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
98 `opis` VARCHAR(45) NOT NULL,
99 `wystawienie` DATETIME NOT NULL,
100 `raport` VARCHAR(45) NULL,
101 `zakonczenie` DATETIME NULL,
102 `do_zaplaty` DOUBLE NULL,
103 `pracownik` INT UNSIGNED NOT NULL,
104 `samochod` INT UNSIGNED NOT NULL,
105 PRIMARY KEY (`id`))
106ENGINE = InnoDB;
107
108SHOW WARNINGS;
109CREATE UNIQUE INDEX `id_UNIQUE` ON `Zlecenie` (`id` ASC);
110
111SHOW WARNINGS;
112
113-- -----------------------------------------------------
114-- Table `Magazyn`
115-- -----------------------------------------------------
116DROP TABLE IF EXISTS `Magazyn` ;
117
118SHOW WARNINGS;
119CREATE TABLE IF NOT EXISTS `Magazyn` (
120 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
121 `nazwa` VARCHAR(45) NOT NULL,
122 `nr_katalogowy` VARCHAR(45) NULL,
123 `nr_fabryczny` VARCHAR(45) NULL,
124 `data_kupna` VARCHAR(45) NOT NULL,
125 `data_sprzedazy` VARCHAR(45) NULL,
126 `zlecenie` INT UNSIGNED NULL,
127 PRIMARY KEY (`id`))
128ENGINE = InnoDB;
129
130SHOW WARNINGS;
131CREATE UNIQUE INDEX `id_UNIQUE` ON `Magazyn` (`id` ASC);
132
133SHOW WARNINGS;
134
135SET SQL_MODE=@OLD_SQL_MODE;
136SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
137SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;