· 9 years ago · Jun 08, 2017, 10:42 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Czas generowania: 28 Gru 2015, 18:26
7-- Wersja serwera: 5.6.21
8-- Wersja PHP: 5.6.3
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-- Baza danych: `osadnicy`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabeli dla tabeli `uzytkownicy`
27--
28
29CREATE TABLE IF NOT EXISTS `uzytkownicy` (
30`id` int(11) NOT NULL,
31 `user` text COLLATE utf8_polish_ci NOT NULL,
32 `pass` text COLLATE utf8_polish_ci NOT NULL,
33 `email` text COLLATE utf8_polish_ci NOT NULL)
34 ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
35
36--
37-- Zrzut danych tabeli `uzytkownicy`
38--
39
40INSERT INTO `uzytkownicy` (`id`, `user`, `pass`, `email`) VALUES
41(1, 'adam', 'qwerty', 'adam@gmail.com'),
42(2, 'marek', 'asdfg', 'marek@gmail.com'),
43(3, 'anna', 'zxcvb', 'anna@gmail.com')
44
45
46--
47-- Indeksy dla zrzutów tabel
48--
49
50--
51-- Indexes for table `uzytkownicy`
52--
53ALTER TABLE `uzytkownicy`
54 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`);
55
56--
57-- AUTO_INCREMENT for dumped tables
58--
59
60--
61-- AUTO_INCREMENT dla tabeli `uzytkownicy`
62--
63ALTER TABLE `uzytkownicy`
64MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
65/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
66/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
67/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;