5kULYqY6

1CREATE TABLE IF NOT EXISTS `objednavky` (
2`id` int(11) NOT NULL AUTO_INCREMENT,
3  `cislo` varchar(10) NOT NULL,
4  `id_uzivatel` int(11) NOT NULL,
5  `cena` int(11) NOT NULL,
6  `datum` datetime NOT NULL,
7  `id_doprava` int(11) NOT NULL,
8  `id_platba` int(11) NOT NULL,
9  `postovne` int(11) NOT NULL
10) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
11
12
13INSERT INTO `objednavky` (`id`, `cislo`, `id_uzivatel`, `cena`, `datum`, `id_doprava`, `id_platba`, `postovne`) VALUES
14(1, '2017500001', 1, 500, '2017-11-03 15:24:35', 1, 1, 100),
15(2, '2017500002', 2, 250, '2017-11-04 20:25:13', 2, 4, 90),
16(3, '2017500003', 3, 600, '2017-10-04 22:25:13', 1, 1, 100),
17(4, '2017500004', 4, 1200, '2017-10-04 17:35:00', 1, 3, 0),
18(5, '2017500005', 2, 2000, '2017-11-05 12:25:13', 3, 3, 90),
19(6, '2017500006', 0, 360, '2017-11-05 20:25:13', 1, 2, 100),
20(7, '2017500007', 0, 450, '2017-11-06 20:25:13', 4, 4, 0),
21(8, '2017500008', 4, 1000, '2017-11-10 17:30:00', 1, 1, 50);
22
23ALTER TABLE `objednavky`
24 ADD PRIMARY KEY (`id`), ADD KEY `id_uzivatel` (`id_uzivatel`), ADD KEY `id_doprava` (`id_doprava`), ADD KEY `id_platba` (`id_platba`);
25
26
27CREATE TABLE IF NOT EXISTS `doprava` (
28`id` int(11) NOT NULL AUTO_INCREMENT,
29  `nazev` varchar(100) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
30  `zkratka` varchar(5) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
31  `postovne` decimal(3,0) NOT NULL
32) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8
33
34
35INSERT INTO `doprava` (`id`, `nazev`, `zkratka`, `postovne`) VALUES
36(1, 'Česká pošta', 'CP', 110),
37(2, 'DPD', 'DPD', 100),
38(3, 'Geis', 'Geis', 100),
39(4, 'Osobní odběr na prodejně', 'OO', 10),
40(5, 'Uloženka', 'Uloz', 50);
41
42ALTER TABLE `doprava`
43 ADD PRIMARY KEY (`id`);
44 
45CREATE TABLE IF NOT EXISTS `platby` (
46`id` int(11) NOT NULL AUTO_INCREMENT,
47  `nazev` varchar(50) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
48  `zkratka` varchar(5) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL
49) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
50
51
52INSERT INTO `platby` (`id`, `nazev`, `zkratka`) VALUES
53(1, 'Dobírka', 'dob'),
54(2, 'Bankovní převod', 'prev'),
55(3, 'Online platba kartou', 'karta'),
56(4, 'Hotově při převzetí zboží', 'hotov'),
57(5, 'eBank', 'eBank');
58
59ALTER TABLE `platby`
60 ADD PRIMARY KEY (`id`);