· 5 years ago · Feb 10, 2020, 10:02 AM
1-- phpMyAdmin SQL Dump
2-- version 2.11.6
3-- http://www.phpmyadmin.net
4--
5-- Počítač: localhost:3306
6-- Vygenerováno: Pondělí 10. února 2020, 10:59
7-- Verze MySQL: 5.1.30
8-- Verze PHP: 5.2.6
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Databáze: `banka2`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Struktura tabulky `klient`
20--
21
22CREATE TABLE IF NOT EXISTS `klient` (
23 `ID` int(11) NOT NULL AUTO_INCREMENT,
24 `Jmeno` varchar(32) COLLATE utf8_czech_ci NOT NULL,
25 `Prijmeni` varchar(32) COLLATE utf8_czech_ci NOT NULL,
26 `Datum_narozeni` varchar(32) COLLATE utf8_czech_ci NOT NULL,
27 `ID_Mesta` int(11) NOT NULL,
28 PRIMARY KEY (`ID`),
29 KEY `ID_Mesta` (`ID_Mesta`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='lol cs' AUTO_INCREMENT=10 ;
31
32--
33-- Vypisuji data pro tabulku `klient`
34--
35
36INSERT INTO `klient` (`ID`, `Jmeno`, `Prijmeni`, `Datum_narozeni`, `ID_Mesta`) VALUES
37(1, 'Petr', 'Bezruč', '2.2.2020', 1),
38(2, 'Karel', 'Malý', '3.3.2003', 1),
39(3, 'Karel', 'Větší', '4.4.2004', 1),
40(4, 'Znamy', 'Deviant', '2.2.2002', 13),
41(5, 'Radek', 'Krivy', '4.4.2004', 12),
42(6, 'Otto', 'VonBismark', '3.1.2003', 18),
43(7, 'Kulomet', 'Lehky', '1.7.1969', 2),
44(8, 'Zdroj', 'Elektrický', '7.12.2005', 8),
45(9, 'Franta', 'PepaJednička', '1.1.1900', 14);
46
47-- --------------------------------------------------------
48
49--
50-- Struktura tabulky `ku`
51--
52
53CREATE TABLE IF NOT EXISTS `ku` (
54 `ID_KU` int(11) NOT NULL AUTO_INCREMENT,
55 `ID_K` int(11) NOT NULL,
56 `ID_U` int(11) NOT NULL,
57 PRIMARY KEY (`ID_KU`),
58 KEY `ID_K` (`ID_K`),
59 KEY `ID_U` (`ID_U`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
61
62--
63-- Vypisuji data pro tabulku `ku`
64--
65
66INSERT INTO `ku` (`ID_KU`, `ID_K`, `ID_U`) VALUES
67(1, 1, 3),
68(2, 2, 4),
69(3, 3, 5),
70(4, 4, 6),
71(5, 5, 7),
72(6, 6, 8),
73(7, 7, 9),
74(8, 8, 10),
75(9, 9, 11),
76(10, 5, 11);
77
78-- --------------------------------------------------------
79
80--
81-- Struktura tabulky `mesta`
82--
83
84CREATE TABLE IF NOT EXISTS `mesta` (
85 `ID_M` int(11) NOT NULL AUTO_INCREMENT,
86 `Jmeno` varchar(32) COLLATE utf8_czech_ci NOT NULL,
87 PRIMARY KEY (`ID_M`)
88) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=19 ;
89
90--
91-- Vypisuji data pro tabulku `mesta`
92--
93
94INSERT INTO `mesta` (`ID_M`, `Jmeno`) VALUES
95(1, 'Přerov'),
96(2, 'ValMez'),
97(3, 'Olomouc'),
98(4, 'Pribram'),
99(5, 'Valchov'),
100(6, 'Ubram'),
101(7, 'Nazdar'),
102(8, 'Bazar'),
103(9, 'Kolmov'),
104(10, 'Tuplov'),
105(11, 'Kolmov'),
106(12, 'Tuplov'),
107(13, 'Ostrov'),
108(14, 'Nymandov'),
109(15, 'Kaprov'),
110(16, 'Stikov'),
111(17, 'Cicikov'),
112(18, 'Tramtarie');
113
114-- --------------------------------------------------------
115
116--
117-- Struktura tabulky `pobocka`
118--
119
120CREATE TABLE IF NOT EXISTS `pobocka` (
121 `ID_P` int(11) NOT NULL AUTO_INCREMENT,
122 `Jmeno` varchar(32) COLLATE utf8_czech_ci NOT NULL,
123 `ID_M` int(11) NOT NULL,
124 PRIMARY KEY (`ID_P`),
125 KEY `ID_M` (`ID_M`)
126) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;
127
128--
129-- Vypisuji data pro tabulku `pobocka`
130--
131
132INSERT INTO `pobocka` (`ID_P`, `Jmeno`, `ID_M`) VALUES
133(1, 'Koliba', 13),
134(2, 'Tulipan', 12),
135(3, 'Zahrada', 11),
136(4, 'Ruze', 14),
137(5, 'Kohout', 10),
138(6, 'Noc', 9),
139(7, 'Na', 8),
140(8, 'Karlstejne', 7),
141(9, 'Jejda', 6),
142(10, 'Strejda', 5);
143
144-- --------------------------------------------------------
145
146--
147-- Struktura tabulky `ucty`
148--
149
150CREATE TABLE IF NOT EXISTS `ucty` (
151 `ID_U` int(11) NOT NULL AUTO_INCREMENT,
152 `Zustatek` int(11) NOT NULL,
153 `Cislo_Uctu` int(11) NOT NULL,
154 `ID_P` int(11) NOT NULL,
155 PRIMARY KEY (`ID_U`),
156 UNIQUE KEY `Cislo_Uctu` (`Cislo_Uctu`),
157 KEY `ID_P` (`ID_P`)
158) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ;
159
160--
161-- Vypisuji data pro tabulku `ucty`
162--
163
164INSERT INTO `ucty` (`ID_U`, `Zustatek`, `Cislo_Uctu`, `ID_P`) VALUES
165(3, 5, 123456789, 1),
166(4, 0, 545413214, 2),
167(5, 28250, 123475641, 1),
168(6, 34450, 544825354, 2),
169(7, 33700, 785214562, 5),
170(8, 0, 412598889, 4),
171(9, 2211968, 895898589, 3),
172(10, 0, 632154811, 1),
173(11, 46370618, 232525658, 9);
174
175--
176-- Omezení pro exportované tabulky
177--
178
179--
180-- Omezení pro tabulku `klient`
181--
182ALTER TABLE `klient`
183 ADD CONSTRAINT `klient_ibfk_1` FOREIGN KEY (`ID_Mesta`) REFERENCES `mesta` (`ID_M`);
184
185--
186-- Omezení pro tabulku `ku`
187--
188ALTER TABLE `ku`
189 ADD CONSTRAINT `ku_ibfk_1` FOREIGN KEY (`ID_K`) REFERENCES `klient` (`ID`),
190 ADD CONSTRAINT `ku_ibfk_2` FOREIGN KEY (`ID_U`) REFERENCES `ucty` (`ID_U`);
191
192--
193-- Omezení pro tabulku `pobocka`
194--
195ALTER TABLE `pobocka`
196 ADD CONSTRAINT `pobocka_ibfk_1` FOREIGN KEY (`ID_M`) REFERENCES `mesta` (`ID_M`);
197
198--
199-- Omezení pro tabulku `ucty`
200--
201ALTER TABLE `ucty`
202 ADD CONSTRAINT `ucty_ibfk_1` FOREIGN KEY (`ID_P`) REFERENCES `pobocka` (`ID_P`);