· 9 years ago · Jan 19, 2017, 10:44 AM
1-- phpMyAdmin SQL Dump
2-- version 4.3.11
3-- http://www.phpmyadmin.net
4--
5-- Hostiteľ: 127.0.0.1
6-- ÄŒas generovania: Å t 19.Jan 2017, 11:41
7-- Verzia serveru: 5.6.24
8-- Verzia PHP: 5.6.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET 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áza: `test`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Štruktúra tabuľky pre tabuľku `vozidlo`
27--
28
29CREATE TABLE IF NOT EXISTS `vozidlo` (
30 `id` int(11) NOT NULL,
31 `nazov` varchar(40) NOT NULL,
32 `dveri` int(11) NOT NULL,
33 `spotreba` float NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35
36--
37-- KľúÄe pre exportované tabuľky
38--
39
40--
41-- Indexy pre tabuľku `vozidlo`
42--
43ALTER TABLE `vozidlo`
44 ADD PRIMARY KEY (`id`);
45
46--
47-- AUTO_INCREMENT pre exportované tabuľky
48--
49
50--
51-- AUTO_INCREMENT pre tabuľku `vozidlo`
52--
53ALTER TABLE `vozidlo`
54 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
55/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
56/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
57/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;