· 7 years ago · Dec 21, 2018, 08:50 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.4
3-- http://www.phpmyadmin.net
4--
5-- PoÄÃtaÄ: innodb.endora.cz:3306
6-- Vytvořeno: Pát 21. pro 2018, 21:42
7-- Verze serveru: 5.6.41-84.1
8-- Verze PHP: 5.4.45
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áze: `jidlo`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabulky `Uzivatele`
27--
28
29CREATE TABLE IF NOT EXISTS `Uzivatele` (
30 `idUzivatel` int(11) NOT NULL,
31 `jmeno` varchar(50) NOT NULL,
32 `prijmeni` varchar(50) NOT NULL,
33 `email` varchar(100) NOT NULL,
34 `heslo` varchar(100) NOT NULL,
35 `ulice` varchar(100) NOT NULL,
36 `cisloPopisne` varchar(20) NOT NULL,
37 `psc` varchar(6) NOT NULL,
38 `obec` varchar(50) NOT NULL,
39 `telefon` varchar(12) NOT NULL,
40 `body` int(11) NOT NULL,
41 `rank` tinyint(1) NOT NULL
42) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
43
44--
45-- Vypisuji data pro tabulku `Uzivatele`
46--
47
48INSERT INTO `Uzivatele` (`idUzivatel`, `jmeno`, `prijmeni`, `email`, `heslo`, `ulice`, `cisloPopisne`, `psc`, `obec`, `telefon`, `body`, `rank`) VALUES
49(1, 'asdsa', 'asda', 'asdad.asda@sads.sd', '281ffbf5eb2a3916b9c1eb8f28637836', '', '', '', '', '', 0, 0),
50(2, 'Jan', 'VavÅ™inÃk', 'jan.vavrinik@email.cz', '95ebc78d15b6595f03b1492aef1aca2c', '', '', '', '', '', 0, 0),
51(3, 'pepa', 'zdepa', 'pepa@zdepa.cz', '2cd324f30dc548396570da4e637c53ee', '', '', '', '', '', 0, 0),
52(4, 'Anna', 'Holubová', 'anna.holubova@rapotin.cz', 'b06099c91f983e5b3420a9a5407c1ff3', '', '', '', '', '', 0, 0),
53(5, 'Franta', 'Novak', 'franta.novak@novak.no', '464e07afc9e46359fb480839150595c5', '', '', '', '', '', 0, 0),
54(6, 'Andul', 'VavÅ™inÃková', 'pizinka1@seznam.cz', '0015cc32089af63f1dfaf4fceafdfd3f', '', '', '', '', '', 0, 0),
55(7, 'Josef', 'VoráÄ', 'jovo@mail.xt', '83227a721a3363d2c78381664c78657f', '', '', '', '', '', 0, 0),
56(8, 'marek', 'venos', 'marek.venos@venos.cz', 'c3187ae00cc04be1c3f1b89a0614038a', '', '', '', '', '', 0, 0),
57(9, 'JiÅ™Ã', 'Krajzinger', 'jiri.krajzinger@seznam.cz', '582ff94ead309cf6728fc7c099f05d87', '', '', '', '', '', 0, 0),
58(10, 'Olda', 'Horak', 'olda.horak@horak.cz', 'b99edb6317b29863dcc3adb8e2d882ba', '', '', '', '', '', 0, 0),
59(11, 'asdas', 'asdasd', 'asfdasd.dasd@sdad.as', '955db0b81ef1989b4a4dfeae8061a9a6', '', '', '', '', '', 0, 0),
60(12, 'asdasd', 'asdasd', 'adsasd@adsdsa.sd', '202cb962ac59075b964b07152d234b70', '', '', '', '', '', 0, 0),
61(13, 'Honza', 'Vavrinik', 'honza.vavrinik@vavrinik.cz', '9a8844dd1b10b8c517579ef01806155c', '', '', '', '', '', 0, 0),
62(14, 'test', 'test', 'test.test@test.com', '098f6bcd4621d373cade4e832627b4f6', '', '', '', '', '', 0, 0),
63(15, 'olda', 'olda', 'olda@olda.olda', 'b99edb6317b29863dcc3adb8e2d882ba', '', '', '', '', '', 0, 0),
64(16, 'Adam', 'Å piler', 'adam@spiler.cz', '1d7c2923c1684726dc23d2901c4d8157', '', '', '', '', '', 0, 0),
65(17, 'Zdena', 'Riegelu', 'zdena@riegel.cz', '789a6d201e6b1a29ad5b1783067fb399', '', '', '', '', '', 0, 0),
66(18, 'a', 'a', 'a@a.a', '0cc175b9c0f1b6a831c399e269772661', '', '', '', '', '', 0, 0),
67(19, 'Mirek', 'Novák', 'mirek@novak.cz', 'faeebfb0745abd883d1ef17c553a1d78', '', '', '', '', '', 0, 0),
68(20, 'testovaci', 'ucet', 'testovaci@ucet.cz', 'c106922d0d063c1006911bc3704cd4fc', '', '', '', '', '', 0, 0),
69(21, 'q', 'q', 'q@q.q', '7694f4a66316e53c8cdd9d9954bd611d', '', '', '', '', '', 0, 0),
70(22, 'Filip', 'Turna', 'fturna@a.cz', '7c8613914aba2fd771b643202da55e06', '', '', '', '', '', 0, 0),
71(23, 'Ferda', 'Mravenec', 'ferda.mravenec@mraveniste.cz', 'a63dee598163f1993afed84be0b37d17', '', '', '', '', '', 0, 0),
72(24, 'Jan', 'VavÅ™ÃnÃk', 'modyCz@seznam.cz', 'c180a5a9a0f661faedbf1974cc8f4352', '', '', '', '', '', 0, 0),
73(25, 'Jan', 'asdasd', 'asdasd.asdas@asdsa.sd', '7815696ecbf1c96e6894b779456d330e', '', '', '', '', '', 0, 0),
74(26, 'Zdeněk', 'Riegel', 'zdenek@riegel.cz', 'b06099c91f983e5b3420a9a5407c1ff3', '', '', '', '', '', 0, 0),
75(27, 'asdasd', 'asdad', 'olda@olda.olda', '955db0b81ef1989b4a4dfeae8061a9a6', '', '', '', '', '', 0, 0),
76(28, 'aa', 'aa', 'asdas.asdd@sada.sd', '4124bc0a9335c27f086f24ba207a4912', '', '', '', '', '', 0, 0),
77(29, 'test', 'test', 'test@test.cz', '098f6bcd4621d373cade4e832627b4f6', '', '', '', '', '', 0, 0);
78
79--
80-- Kl̀e pro exportovan̩ tabulky
81--
82
83--
84-- KlÃÄe pro tabulku `Uzivatele`
85--
86ALTER TABLE `Uzivatele`
87 ADD PRIMARY KEY (`idUzivatel`);
88
89--
90-- AUTO_INCREMENT pro tabulky
91--
92
93--
94-- AUTO_INCREMENT pro tabulku `Uzivatele`
95--
96ALTER TABLE `Uzivatele`
97 MODIFY `idUzivatel` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=30;
98/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
99/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
100/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;