| 1 |
bad470c9
|
horkym
|
-- phpMyAdmin SQL Dump
|
| 2 |
|
|
-- version 3.5.2.2
|
| 3 |
|
|
-- http://www.phpmyadmin.net
|
| 4 |
|
|
--
|
| 5 |
|
|
-- Počítač: 127.0.0.1
|
| 6 |
|
|
-- Vygenerováno: Čtv 07. čen 2018, 01:11
|
| 7 |
|
|
-- Verze MySQL: 5.5.27-log
|
| 8 |
|
|
-- Verze PHP: 5.4.6
|
| 9 |
|
|
|
| 10 |
|
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
|
| 11 |
|
|
SET time_zone = "+00:00";
|
| 12 |
|
|
|
| 13 |
|
|
|
| 14 |
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
| 15 |
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
| 16 |
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
| 17 |
|
|
/*!40101 SET NAMES utf8 */;
|
| 18 |
|
|
|
| 19 |
|
|
--
|
| 20 |
|
|
-- Databáze: `prujezd_vozidel`
|
| 21 |
|
|
--
|
| 22 |
|
|
CREATE DATABASE `prujezd_vozidel` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
| 23 |
|
|
USE `prujezd_vozidel`;
|
| 24 |
|
|
|
| 25 |
|
|
-- --------------------------------------------------------
|
| 26 |
|
|
|
| 27 |
|
|
--
|
| 28 |
|
|
-- Struktura tabulky `datum`
|
| 29 |
|
|
--
|
| 30 |
|
|
|
| 31 |
|
|
CREATE TABLE IF NOT EXISTS `datum` (
|
| 32 |
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
| 33 |
|
|
`od` datetime NOT NULL,
|
| 34 |
|
|
`do` datetime NOT NULL,
|
| 35 |
|
|
PRIMARY KEY (`id`)
|
| 36 |
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=98 ;
|
| 37 |
|
|
|
| 38 |
|
|
--
|
| 39 |
|
|
-- Vypisuji data pro tabulku `datum`
|
| 40 |
|
|
--
|
| 41 |
|
|
|
| 42 |
|
|
INSERT INTO `datum` (`id`, `od`, `do`) VALUES
|
| 43 |
|
|
(1, '2018-06-05 00:00:00', '2018-06-05 00:15:00'),
|
| 44 |
|
|
(2, '2018-06-05 00:15:00', '2018-06-05 00:30:00'),
|
| 45 |
|
|
(3, '2018-06-05 00:30:00', '2018-06-05 00:45:00'),
|
| 46 |
|
|
(4, '2018-06-05 00:45:00', '2018-06-05 01:00:00'),
|
| 47 |
|
|
(5, '2018-06-05 01:00:00', '2018-06-05 01:15:00'),
|
| 48 |
|
|
(6, '2018-06-05 01:15:00', '2018-06-05 01:30:00'),
|
| 49 |
|
|
(7, '2018-06-05 01:30:00', '2018-06-05 01:45:00'),
|
| 50 |
|
|
(8, '2018-06-05 01:45:00', '2018-06-05 02:00:00'),
|
| 51 |
|
|
(9, '2018-06-05 02:00:00', '2018-06-05 02:15:00'),
|
| 52 |
|
|
(10, '2018-06-05 02:15:00', '2018-06-05 02:30:00'),
|
| 53 |
|
|
(11, '2018-06-05 02:30:00', '2018-06-05 02:45:00'),
|
| 54 |
|
|
(12, '2018-06-05 02:45:00', '2018-06-05 03:00:00'),
|
| 55 |
|
|
(13, '2018-06-05 03:00:00', '2018-06-05 03:15:00'),
|
| 56 |
|
|
(14, '2018-06-05 03:15:00', '2018-06-05 03:30:00'),
|
| 57 |
|
|
(15, '2018-06-05 03:30:00', '2018-06-05 03:45:00'),
|
| 58 |
|
|
(16, '2018-06-05 03:45:00', '2018-06-05 04:00:00'),
|
| 59 |
|
|
(17, '2018-06-05 04:00:00', '2018-06-05 04:15:00'),
|
| 60 |
|
|
(18, '2018-06-05 04:15:00', '2018-06-05 04:30:00'),
|
| 61 |
|
|
(19, '2018-06-05 04:30:00', '2018-06-05 04:45:00'),
|
| 62 |
|
|
(20, '2018-06-05 04:45:00', '2018-06-05 05:00:00'),
|
| 63 |
|
|
(21, '2018-06-05 05:00:00', '2018-06-05 05:15:00'),
|
| 64 |
|
|
(22, '2018-06-05 05:15:00', '2018-06-05 05:30:00'),
|
| 65 |
|
|
(23, '2018-06-05 05:30:00', '2018-06-05 05:45:00'),
|
| 66 |
|
|
(24, '2018-06-05 05:45:00', '2018-06-05 06:00:00'),
|
| 67 |
|
|
(25, '2018-06-05 06:00:00', '2018-06-05 06:15:00'),
|
| 68 |
|
|
(26, '2018-06-05 06:15:00', '2018-06-05 06:30:00'),
|
| 69 |
|
|
(27, '2018-06-05 06:30:00', '2018-06-05 06:45:00'),
|
| 70 |
|
|
(28, '2018-06-05 06:45:00', '2018-06-05 07:00:00'),
|
| 71 |
|
|
(29, '2018-06-05 07:00:00', '2018-06-05 07:15:00'),
|
| 72 |
|
|
(30, '2018-06-05 07:15:00', '2018-06-05 07:30:00'),
|
| 73 |
|
|
(31, '2018-06-05 07:30:00', '2018-06-05 07:45:00'),
|
| 74 |
|
|
(32, '2018-06-05 07:45:00', '2018-06-05 08:00:00'),
|
| 75 |
|
|
(33, '2018-06-05 08:00:00', '2018-06-05 08:15:00'),
|
| 76 |
|
|
(34, '2018-06-05 08:15:00', '2018-06-05 08:30:00'),
|
| 77 |
|
|
(35, '2018-06-05 08:30:00', '2018-06-05 08:45:00'),
|
| 78 |
|
|
(36, '2018-06-05 08:45:00', '2018-06-05 09:00:00'),
|
| 79 |
|
|
(37, '2018-06-05 09:00:00', '2018-06-05 09:15:00'),
|
| 80 |
|
|
(38, '2018-06-05 09:15:00', '2018-06-05 09:30:00'),
|
| 81 |
|
|
(39, '2018-06-05 09:30:00', '2018-06-05 09:45:00'),
|
| 82 |
|
|
(40, '2018-06-05 09:45:00', '2018-06-05 10:00:00'),
|
| 83 |
|
|
(41, '2018-06-05 10:00:00', '2018-06-05 10:15:00'),
|
| 84 |
|
|
(42, '2018-06-05 10:15:00', '2018-06-05 10:30:00'),
|
| 85 |
|
|
(43, '2018-06-05 10:30:00', '2018-06-05 10:45:00'),
|
| 86 |
|
|
(44, '2018-06-05 10:45:00', '2018-06-05 11:00:00'),
|
| 87 |
|
|
(45, '2018-06-05 11:00:00', '2018-06-05 11:15:00'),
|
| 88 |
|
|
(46, '2018-06-05 11:15:00', '2018-06-05 11:30:00'),
|
| 89 |
|
|
(47, '2018-06-05 11:30:00', '2018-06-05 11:45:00'),
|
| 90 |
|
|
(48, '2018-06-05 11:45:00', '2018-06-05 12:00:00'),
|
| 91 |
|
|
(49, '2018-06-05 12:00:00', '2018-06-05 12:15:00'),
|
| 92 |
|
|
(50, '2018-06-05 12:15:00', '2018-06-05 12:30:00'),
|
| 93 |
|
|
(51, '2018-06-05 12:30:00', '2018-06-05 12:45:00'),
|
| 94 |
|
|
(52, '2018-06-05 12:45:00', '2018-06-05 13:00:00'),
|
| 95 |
|
|
(53, '2018-06-05 13:00:00', '2018-06-05 13:15:00'),
|
| 96 |
|
|
(54, '2018-06-05 13:15:00', '2018-06-05 13:30:00'),
|
| 97 |
|
|
(55, '2018-06-05 13:30:00', '2018-06-05 13:45:00'),
|
| 98 |
|
|
(56, '2018-06-05 13:45:00', '2018-06-05 14:00:00'),
|
| 99 |
|
|
(57, '2018-06-05 14:00:00', '2018-06-05 14:15:00'),
|
| 100 |
|
|
(58, '2018-06-05 14:15:00', '2018-06-05 14:30:00'),
|
| 101 |
|
|
(59, '2018-06-05 14:30:00', '2018-06-05 14:45:00'),
|
| 102 |
|
|
(60, '2018-06-05 14:45:00', '2018-06-05 15:00:00'),
|
| 103 |
|
|
(61, '2018-06-05 15:00:00', '2018-06-05 15:15:00'),
|
| 104 |
|
|
(62, '2018-06-05 15:15:00', '2018-06-05 15:30:00'),
|
| 105 |
|
|
(63, '2018-06-05 15:30:00', '2018-06-05 15:45:00'),
|
| 106 |
|
|
(64, '2018-06-05 15:45:00', '2018-06-05 16:00:00'),
|
| 107 |
|
|
(65, '2018-06-05 16:00:00', '2018-06-05 16:15:00'),
|
| 108 |
|
|
(66, '2018-06-05 16:15:00', '2018-06-05 16:30:00'),
|
| 109 |
|
|
(67, '2018-06-05 16:30:00', '2018-06-05 16:45:00'),
|
| 110 |
|
|
(68, '2018-06-05 16:45:00', '2018-06-05 17:00:00'),
|
| 111 |
|
|
(69, '2018-06-05 17:00:00', '2018-06-05 17:15:00'),
|
| 112 |
|
|
(70, '2018-06-05 17:15:00', '2018-06-05 17:30:00'),
|
| 113 |
|
|
(71, '2018-06-05 17:30:00', '2018-06-05 17:45:00'),
|
| 114 |
|
|
(72, '2018-06-05 17:45:00', '2018-06-05 18:00:00'),
|
| 115 |
|
|
(73, '2018-06-05 18:00:00', '2018-06-05 18:15:00'),
|
| 116 |
|
|
(74, '2018-06-05 18:15:00', '2018-06-05 18:30:00'),
|
| 117 |
|
|
(75, '2018-06-05 18:30:00', '2018-06-05 18:45:00'),
|
| 118 |
|
|
(76, '2018-06-05 18:45:00', '2018-06-05 19:00:00'),
|
| 119 |
|
|
(77, '2018-06-05 19:00:00', '2018-06-05 19:15:00'),
|
| 120 |
|
|
(78, '2018-06-05 19:15:00', '2018-06-05 19:30:00'),
|
| 121 |
|
|
(79, '2018-06-05 19:30:00', '2018-06-05 19:45:00'),
|
| 122 |
|
|
(80, '2018-06-05 19:45:00', '2018-06-05 20:00:00'),
|
| 123 |
|
|
(81, '2018-06-05 20:00:00', '2018-06-05 20:15:00'),
|
| 124 |
|
|
(82, '2018-06-05 20:15:00', '2018-06-05 20:30:00'),
|
| 125 |
|
|
(83, '2018-06-05 20:30:00', '2018-06-05 20:45:00'),
|
| 126 |
|
|
(84, '2018-06-05 20:45:00', '2018-06-05 21:00:00'),
|
| 127 |
|
|
(85, '2018-06-05 21:00:00', '2018-06-05 21:15:00'),
|
| 128 |
|
|
(86, '2018-06-05 21:15:00', '2018-06-05 21:30:00'),
|
| 129 |
|
|
(87, '2018-06-05 21:30:00', '2018-06-05 21:45:00'),
|
| 130 |
|
|
(88, '2018-06-05 21:45:00', '2018-06-05 22:00:00'),
|
| 131 |
|
|
(89, '2018-06-05 22:00:00', '2018-06-05 22:15:00'),
|
| 132 |
|
|
(90, '2018-06-05 22:15:00', '2018-06-05 22:30:00'),
|
| 133 |
|
|
(91, '2018-06-05 22:30:00', '2018-06-05 22:45:00'),
|
| 134 |
|
|
(92, '2018-06-05 22:45:00', '2018-06-05 23:00:00'),
|
| 135 |
|
|
(93, '2018-06-05 23:00:00', '2018-06-05 23:15:00'),
|
| 136 |
|
|
(94, '2018-06-05 23:15:00', '2018-06-05 23:30:00'),
|
| 137 |
|
|
(95, '2018-06-05 23:30:00', '2018-06-05 23:45:00'),
|
| 138 |
|
|
(96, '2018-06-05 23:45:00', '2018-06-06 00:00:00'),
|
| 139 |
|
|
(97, '2018-06-05 00:00:00', '2018-06-06 00:00:00');
|
| 140 |
|
|
|
| 141 |
|
|
-- --------------------------------------------------------
|
| 142 |
|
|
|
| 143 |
|
|
--
|
| 144 |
|
|
-- Struktura tabulky `mesto`
|
| 145 |
|
|
--
|
| 146 |
|
|
|
| 147 |
|
|
CREATE TABLE IF NOT EXISTS `mesto` (
|
| 148 |
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
| 149 |
|
|
`nazev` varchar(100) NOT NULL,
|
| 150 |
|
|
PRIMARY KEY (`id`)
|
| 151 |
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
|
| 152 |
|
|
|
| 153 |
|
|
--
|
| 154 |
|
|
-- Vypisuji data pro tabulku `mesto`
|
| 155 |
|
|
--
|
| 156 |
|
|
|
| 157 |
|
|
INSERT INTO `mesto` (`id`, `nazev`) VALUES
|
| 158 |
|
|
(1, 'Česká Kubice');
|
| 159 |
|
|
|
| 160 |
|
|
-- --------------------------------------------------------
|
| 161 |
|
|
|
| 162 |
|
|
--
|
| 163 |
|
|
-- Struktura tabulky `ulice`
|
| 164 |
|
|
--
|
| 165 |
|
|
|
| 166 |
|
|
CREATE TABLE IF NOT EXISTS `ulice` (
|
| 167 |
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
| 168 |
|
|
`nazev` varchar(255) NOT NULL,
|
| 169 |
|
|
`mesto_id` bigint(20) NOT NULL,
|
| 170 |
|
|
`zem_sirka` double NOT NULL DEFAULT '-1' COMMENT 'Zemepisna sirka podle GOOGLE.',
|
| 171 |
|
|
`zem_delka` double NOT NULL DEFAULT '-1' COMMENT 'Zemepisna delka podle GOOGLE.',
|
| 172 |
|
|
PRIMARY KEY (`id`),
|
| 173 |
|
|
KEY `fk_ulice_mesto_idx` (`mesto_id`)
|
| 174 |
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
|
| 175 |
|
|
|
| 176 |
|
|
--
|
| 177 |
|
|
-- Vypisuji data pro tabulku `ulice`
|
| 178 |
|
|
--
|
| 179 |
|
|
|
| 180 |
|
|
INSERT INTO `ulice` (`id`, `nazev`, `mesto_id`, `zem_sirka`, `zem_delka`) VALUES
|
| 181 |
|
|
(1, 'Česká Kubice', 1, 49.369388, 12.8588044);
|
| 182 |
|
|
|
| 183 |
|
|
-- --------------------------------------------------------
|
| 184 |
|
|
|
| 185 |
|
|
--
|
| 186 |
|
|
-- Struktura tabulky `vozidlo`
|
| 187 |
|
|
--
|
| 188 |
|
|
|
| 189 |
|
|
CREATE TABLE IF NOT EXISTS `vozidlo` (
|
| 190 |
|
|
`id` bigint(20) NOT NULL COMMENT 'Odpovídá číslu skupiny vozidla (TypVozidla10 v csv souboru s daty). Hodnoty 0-10.',
|
| 191 |
|
|
`nazev` varchar(45) NOT NULL,
|
| 192 |
|
|
PRIMARY KEY (`id`)
|
| 193 |
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
| 194 |
|
|
|
| 195 |
|
|
--
|
| 196 |
|
|
-- Vypisuji data pro tabulku `vozidlo`
|
| 197 |
|
|
--
|
| 198 |
|
|
|
| 199 |
|
|
INSERT INTO `vozidlo` (`id`, `nazev`) VALUES
|
| 200 |
|
|
(0, 'Neznámé vozidlo'),
|
| 201 |
|
|
(1, 'Motocykl'),
|
| 202 |
|
|
(2, 'Auto'),
|
| 203 |
|
|
(3, 'Auto s přívěsem'),
|
| 204 |
|
|
(4, 'Dodávka'),
|
| 205 |
|
|
(5, 'Dodávka s přívěsem'),
|
| 206 |
|
|
(6, 'Lehký nákladní automobil'),
|
| 207 |
|
|
(7, 'Lehký nákladní automobil s přívěsem'),
|
| 208 |
|
|
(8, 'Nákladní automobil'),
|
| 209 |
|
|
(9, 'Nákladní automobil s přívěsem'),
|
| 210 |
|
|
(10, 'Autobus');
|
| 211 |
|
|
|
| 212 |
|
|
-- --------------------------------------------------------
|
| 213 |
|
|
|
| 214 |
|
|
--
|
| 215 |
|
|
-- Struktura tabulky `zarizeni`
|
| 216 |
|
|
--
|
| 217 |
|
|
|
| 218 |
|
|
CREATE TABLE IF NOT EXISTS `zarizeni` (
|
| 219 |
|
|
`id` varchar(20) NOT NULL COMMENT 'Odpovídá idDevice v location.csv.',
|
| 220 |
|
|
`smer_popis` varchar(255) NOT NULL COMMENT 'Odpovídá Name v locations.csv.',
|
| 221 |
|
|
`stav` int(11) NOT NULL,
|
| 222 |
|
|
`ulice_id` bigint(20) NOT NULL,
|
| 223 |
|
|
PRIMARY KEY (`id`),
|
| 224 |
|
|
KEY `fk_zarizeni_ulice1_idx` (`ulice_id`)
|
| 225 |
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
| 226 |
|
|
|
| 227 |
|
|
--
|
| 228 |
|
|
-- Vypisuji data pro tabulku `zarizeni`
|
| 229 |
|
|
--
|
| 230 |
|
|
|
| 231 |
|
|
INSERT INTO `zarizeni` (`id`, `smer_popis`, `stav`, `ulice_id`) VALUES
|
| 232 |
|
|
('055', 'Česká Kubice, směr od Německa', 0, 1),
|
| 233 |
|
|
('056', 'Česká Kubice, směr od Babylonu', 0, 1);
|
| 234 |
|
|
|
| 235 |
|
|
-- --------------------------------------------------------
|
| 236 |
|
|
|
| 237 |
|
|
--
|
| 238 |
|
|
-- Struktura tabulky `zaznam`
|
| 239 |
|
|
--
|
| 240 |
|
|
|
| 241 |
|
|
CREATE TABLE IF NOT EXISTS `zaznam` (
|
| 242 |
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
| 243 |
|
|
`vozidla_pocet` int(11) NOT NULL,
|
| 244 |
|
|
`rychlost_prumer` double NOT NULL,
|
| 245 |
|
|
`vozidla_id` bigint(20) NOT NULL,
|
| 246 |
|
|
`zaznam_cas_id` bigint(20) NOT NULL,
|
| 247 |
|
|
PRIMARY KEY (`id`),
|
| 248 |
|
|
KEY `fk_zaznam_vozidla1_idx` (`vozidla_id`),
|
| 249 |
|
|
KEY `fk_zaznam_zaznam_cas1_idx` (`zaznam_cas_id`)
|
| 250 |
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
|
| 251 |
|
|
|
| 252 |
|
|
--
|
| 253 |
|
|
-- Vypisuji data pro tabulku `zaznam`
|
| 254 |
|
|
--
|
| 255 |
|
|
|
| 256 |
|
|
INSERT INTO `zaznam` (`id`, `vozidla_pocet`, `rychlost_prumer`, `vozidla_id`, `zaznam_cas_id`) VALUES
|
| 257 |
|
|
(1, 1, 12, 0, 1),
|
| 258 |
|
|
(2, 1, 16, 1, 1),
|
| 259 |
|
|
(3, 4, 110.49233333333, 2, 1),
|
| 260 |
|
|
(4, 1, -1, 3, 1),
|
| 261 |
|
|
(5, 1, 19.05, 4, 1),
|
| 262 |
|
|
(6, 2, 25.5, 8, 1),
|
| 263 |
|
|
(7, 1, 65.4, 2, 2),
|
| 264 |
|
|
(8, 1, 65.789, 6, 2),
|
| 265 |
|
|
(9, 1, 25.15, 2, 3),
|
| 266 |
|
|
(10, 1, 12, 0, 4),
|
| 267 |
|
|
(11, 1, 16, 1, 4),
|
| 268 |
|
|
(12, 2, 25.5, 2, 4),
|
| 269 |
|
|
(13, 1, -1, 3, 4),
|
| 270 |
|
|
(14, 1, 19.05, 4, 4),
|
| 271 |
|
|
(15, 4, 110.49233333333, 8, 4),
|
| 272 |
|
|
(16, 1, 25.15, 8, 5);
|
| 273 |
|
|
|
| 274 |
|
|
-- --------------------------------------------------------
|
| 275 |
|
|
|
| 276 |
|
|
--
|
| 277 |
|
|
-- Struktura tabulky `zaznam_cas`
|
| 278 |
|
|
--
|
| 279 |
|
|
|
| 280 |
|
|
CREATE TABLE IF NOT EXISTS `zaznam_cas` (
|
| 281 |
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
| 282 |
|
|
`smer` int(11) NOT NULL COMMENT '1 nebo 2 viz struktura idDetektor v csv souboru s daty.',
|
| 283 |
|
|
`zarizeni_id` varchar(20) NOT NULL,
|
| 284 |
|
|
`datum_id` bigint(20) NOT NULL,
|
| 285 |
|
|
PRIMARY KEY (`id`),
|
| 286 |
|
|
KEY `fk_zaznam_cas_zarizeni1_idx` (`zarizeni_id`),
|
| 287 |
|
|
KEY `datum_id` (`datum_id`)
|
| 288 |
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
|
| 289 |
|
|
|
| 290 |
|
|
--
|
| 291 |
|
|
-- Vypisuji data pro tabulku `zaznam_cas`
|
| 292 |
|
|
--
|
| 293 |
|
|
|
| 294 |
|
|
INSERT INTO `zaznam_cas` (`id`, `smer`, `zarizeni_id`, `datum_id`) VALUES
|
| 295 |
|
|
(1, 2, '056', 1),
|
| 296 |
|
|
(2, 1, '056', 2),
|
| 297 |
|
|
(3, 2, '056', 2),
|
| 298 |
|
|
(4, 1, '055', 1),
|
| 299 |
|
|
(5, 1, '055', 2);
|
| 300 |
|
|
|
| 301 |
|
|
-- --------------------------------------------------------
|
| 302 |
|
|
|
| 303 |
|
|
--
|
| 304 |
|
|
-- Struktura tabulky `zaznam_prum_den`
|
| 305 |
|
|
--
|
| 306 |
|
|
|
| 307 |
|
|
CREATE TABLE IF NOT EXISTS `zaznam_prum_den` (
|
| 308 |
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
| 309 |
|
|
`vozidla_pocet` int(11) NOT NULL,
|
| 310 |
|
|
`rychlost_prumer` double NOT NULL,
|
| 311 |
|
|
`smer` int(11) NOT NULL,
|
| 312 |
|
|
`zarizeni_id` varchar(20) NOT NULL,
|
| 313 |
|
|
`vozidla_id` bigint(20) NOT NULL,
|
| 314 |
|
|
`datum_id` bigint(20) NOT NULL,
|
| 315 |
|
|
PRIMARY KEY (`id`),
|
| 316 |
|
|
KEY `zarizeni_id` (`zarizeni_id`),
|
| 317 |
|
|
KEY `vozidla_id` (`vozidla_id`),
|
| 318 |
|
|
KEY `datum_id` (`datum_id`)
|
| 319 |
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
|
| 320 |
|
|
|
| 321 |
|
|
--
|
| 322 |
|
|
-- Vypisuji data pro tabulku `zaznam_prum_den`
|
| 323 |
|
|
--
|
| 324 |
|
|
|
| 325 |
|
|
INSERT INTO `zaznam_prum_den` (`id`, `vozidla_pocet`, `rychlost_prumer`, `smer`, `zarizeni_id`, `vozidla_id`, `datum_id`) VALUES
|
| 326 |
|
|
(1, 1, 65.4, 1, '056', 2, 97),
|
| 327 |
|
|
(2, 1, 65.789, 1, '056', 6, 97),
|
| 328 |
|
|
(3, 1, 12, 2, '056', 0, 97),
|
| 329 |
|
|
(4, 1, 16, 2, '056', 1, 97),
|
| 330 |
|
|
(5, 5, 89.15675, 2, '056', 2, 97),
|
| 331 |
|
|
(6, 1, -1, 2, '056', 3, 97),
|
| 332 |
|
|
(7, 1, 19.05, 2, '056', 4, 97),
|
| 333 |
|
|
(8, 2, 25.5, 2, '056', 8, 97),
|
| 334 |
|
|
(9, 1, 12, 1, '055', 0, 97),
|
| 335 |
|
|
(10, 1, 16, 1, '055', 1, 97),
|
| 336 |
|
|
(11, 2, 25.5, 1, '055', 2, 97),
|
| 337 |
|
|
(12, 1, -1, 1, '055', 3, 97),
|
| 338 |
|
|
(13, 1, 19.05, 1, '055', 4, 97),
|
| 339 |
|
|
(14, 5, 89.15675, 1, '055', 8, 97);
|
| 340 |
|
|
|
| 341 |
|
|
--
|
| 342 |
|
|
-- Omezení pro exportované tabulky
|
| 343 |
|
|
--
|
| 344 |
|
|
|
| 345 |
|
|
--
|
| 346 |
|
|
-- Omezení pro tabulku `ulice`
|
| 347 |
|
|
--
|
| 348 |
|
|
ALTER TABLE `ulice`
|
| 349 |
|
|
ADD CONSTRAINT `fk_ulice_mesto` FOREIGN KEY (`mesto_id`) REFERENCES `mesto` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
|
| 350 |
|
|
|
| 351 |
|
|
--
|
| 352 |
|
|
-- Omezení pro tabulku `zarizeni`
|
| 353 |
|
|
--
|
| 354 |
|
|
ALTER TABLE `zarizeni`
|
| 355 |
|
|
ADD CONSTRAINT `fk_zarizeni_ulice1` FOREIGN KEY (`ulice_id`) REFERENCES `ulice` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
|
| 356 |
|
|
|
| 357 |
|
|
--
|
| 358 |
|
|
-- Omezení pro tabulku `zaznam`
|
| 359 |
|
|
--
|
| 360 |
|
|
ALTER TABLE `zaznam`
|
| 361 |
|
|
ADD CONSTRAINT `fk_zaznam_vozidla1` FOREIGN KEY (`vozidla_id`) REFERENCES `vozidlo` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
|
| 362 |
|
|
ADD CONSTRAINT `fk_zaznam_zaznam_cas1` FOREIGN KEY (`zaznam_cas_id`) REFERENCES `zaznam_cas` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
|
| 363 |
|
|
|
| 364 |
|
|
--
|
| 365 |
|
|
-- Omezení pro tabulku `zaznam_cas`
|
| 366 |
|
|
--
|
| 367 |
|
|
ALTER TABLE `zaznam_cas`
|
| 368 |
|
|
ADD CONSTRAINT `zaznam_cas_ibfk_1` FOREIGN KEY (`datum_id`) REFERENCES `datum` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
|
| 369 |
|
|
ADD CONSTRAINT `fk_zaznam_cas_zarizeni1` FOREIGN KEY (`zarizeni_id`) REFERENCES `zarizeni` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
|
| 370 |
|
|
|
| 371 |
|
|
--
|
| 372 |
|
|
-- Omezení pro tabulku `zaznam_prum_den`
|
| 373 |
|
|
--
|
| 374 |
|
|
ALTER TABLE `zaznam_prum_den`
|
| 375 |
|
|
ADD CONSTRAINT `zaznam_prum_den_ibfk_3` FOREIGN KEY (`datum_id`) REFERENCES `datum` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
|
| 376 |
|
|
ADD CONSTRAINT `zaznam_prum_den_ibfk_1` FOREIGN KEY (`zarizeni_id`) REFERENCES `zarizeni` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
|
| 377 |
|
|
ADD CONSTRAINT `zaznam_prum_den_ibfk_2` FOREIGN KEY (`vozidla_id`) REFERENCES `vozidlo` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
|
| 378 |
|
|
|
| 379 |
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
| 380 |
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
| 381 |
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|