· 7 years ago · Jan 30, 2019, 11:46 PM
1-- phpMyAdmin SQL Dump
2-- version 3.5.8.2
3-- http://www.phpmyadmin.net
4--
5-- PoÄÃtaÄ: md38.wedos.net:3306
6-- Vygenerováno: Čtv 31. led 2019, 00:43
7-- Verze serveru: 10.1.37-MariaDB
8-- Verze PHP: 5.4.23
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: `d211308_kryptok`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabulky `users`
27--
28
29CREATE TABLE IF NOT EXISTS `users` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `username` varchar(80) NOT NULL,
32 `name` varchar(80) NOT NULL,
33 `password` varchar(80) NOT NULL,
34 `email` varchar(255) DEFAULT NULL,
35 `ip` varchar(255) DEFAULT NULL,
36 `img` varchar(2500) DEFAULT NULL,
37 `stav` int(1) DEFAULT NULL,
38 `reg_date` varchar(255) DEFAULT NULL,
39 `rank` int(2) DEFAULT NULL,
40 PRIMARY KEY (`id`)
41) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
42
43--
44-- Vypisuji data pro tabulku `users`
45--
46
47INSERT INTO `users` (`id`, `username`, `name`, `password`, `email`, `ip`, `img`, `stav`, `reg_date`, `rank`) VALUES
48(1, 'arbx12', 'ARBX12', 'admin', 'arbx12@arbolet.net', '127.0.0.1', 'avatar2.png', 1, '16.01.2019', 8),
49(2, 'arbx11', 'ARBX11', 'admin', 'arbx11@arbolet.net', '127.0.0.1', 'avatar.png', 1, '16.01.2019', 3);
50
51/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
52/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
53/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;