· 5 years ago · Mar 05, 2020, 07:58 AM
1-- phpMyAdmin SQL Dump
2-- version 4.9.0.1
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Czas generowania: 05 Mar 2020, 08:49
7-- Wersja serwera: 10.4.6-MariaDB
8-- Wersja PHP: 7.3.9
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Baza danych: `laboratorium1`
23--
24CREATE DATABASE IF NOT EXISTS `laboratorium1` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci;
25USE `laboratorium1`;
26
27-- --------------------------------------------------------
28
29--
30-- Struktura tabeli dla tabeli `klient`
31--
32
33CREATE TABLE `klient` (
34 `NumerKlienta` int(6) NOT NULL,
35 `Nazwisko` varchar(20) COLLATE utf8_polish_ci NOT NULL,
36 `Adres` varchar(30) COLLATE utf8_polish_ci NOT NULL
37) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
38
39--
40-- Zrzut danych tabeli `klient`
41--
42
43INSERT INTO `klient` (`NumerKlienta`, `Nazwisko`, `Adres`) VALUES
44(1111, 'Nowak', 'Warszawska 10'),
45(1112, 'Kowalski', 'Pawia 2');
46
47-- --------------------------------------------------------
48
49--
50-- Struktura tabeli dla tabeli `klientkonto`
51--
52
53CREATE TABLE `klientkonto` (
54 `NumerKlienta` int(6) NOT NULL,
55 `NumerKonta` int(8) NOT NULL
56) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
57
58--
59-- Zrzut danych tabeli `klientkonto`
60--
61
62INSERT INTO `klientkonto` (`NumerKlienta`, `NumerKonta`) VALUES
63(1111, 2222);
64
65-- --------------------------------------------------------
66
67--
68-- Struktura tabeli dla tabeli `konto`
69--
70
71CREATE TABLE `konto` (
72 `NumerKonta` int(8) NOT NULL,
73 `Saldo` float(8,2) NOT NULL,
74 `Typ` enum('Firmowe','Indywidualne') COLLATE utf8_polish_ci NOT NULL,
75 `DataOtwarcia` date NOT NULL
76) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
77
78--
79-- Zrzut danych tabeli `konto`
80--
81
82INSERT INTO `konto` (`NumerKonta`, `Saldo`, `Typ`, `DataOtwarcia`) VALUES
83(2222, 1234.56, 'Indywidualne', '2020-03-05');
84
85-- --------------------------------------------------------
86
87--
88-- Struktura tabeli dla tabeli `lokata`
89--
90
91CREATE TABLE `lokata` (
92 `NumerLokaty` int(8) NOT NULL,
93 `NumerKlienta` int(6) NOT NULL,
94 `DataOtwarcia` date NOT NULL,
95 `CzasTrwania` int(2) NOT NULL,
96 `KwotaLokaty` float NOT NULL
97) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
98
99--
100-- Indeksy dla zrzutĂłw tabel
101--
102
103--
104-- Indeksy dla tabeli `klient`
105--
106ALTER TABLE `klient`
107 ADD PRIMARY KEY (`NumerKlienta`);
108
109--
110-- Indeksy dla tabeli `klientkonto`
111--
112ALTER TABLE `klientkonto`
113 ADD PRIMARY KEY (`NumerKlienta`,`NumerKonta`),
114 ADD KEY `NumerKonta` (`NumerKonta`);
115
116--
117-- Indeksy dla tabeli `konto`
118--
119ALTER TABLE `konto`
120 ADD PRIMARY KEY (`NumerKonta`);
121
122--
123-- Indeksy dla tabeli `lokata`
124--
125ALTER TABLE `lokata`
126 ADD PRIMARY KEY (`NumerLokaty`),
127 ADD KEY `NumerKlienta` (`NumerKlienta`);
128
129--
130-- Ograniczenia dla zrzutĂłw tabel
131--
132
133--
134-- Ograniczenia dla tabeli `klientkonto`
135--
136ALTER TABLE `klientkonto`
137 ADD CONSTRAINT `klientkonto_ibfk_1` FOREIGN KEY (`NumerKlienta`) REFERENCES `klient` (`NumerKlienta`),
138 ADD CONSTRAINT `klientkonto_ibfk_2` FOREIGN KEY (`NumerKonta`) REFERENCES `konto` (`NumerKonta`);
139
140--
141-- Ograniczenia dla tabeli `lokata`
142--
143ALTER TABLE `lokata`
144 ADD CONSTRAINT `lokata_ibfk_1` FOREIGN KEY (`NumerKlienta`) REFERENCES `klient` (`NumerKlienta`);
145COMMIT;
146
147/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
148/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
149/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;