· 6 years ago · Mar 29, 2019, 01:08 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1ubuntu0.1
3-- http://www.phpmyadmin.net
4--
5-- Hostiteľ: localhost
6-- Vygenerované: Po 25.Mar 2019, 19:53
7-- Verzia serveru: 5.6.33-0ubuntu0.14.04.1
8-- Verzia PHP: 5.5.9-1ubuntu4.27
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: `287525_mysql56`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Štruktúra tabuľky pre tabuľku `bany`
27--
28
29CREATE TABLE IF NOT EXISTS `bany` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `account` int(11) NOT NULL,
32 `od` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
33 `do` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
36
37--
38-- Sťahujem dáta pre tabuľku `bany`
39--
40
41INSERT INTO `bany` (`id`, `account`, `od`, `do`) VALUES
42(14, 18, '2019-03-22 14:09:27', '0000-00-00 00:00:00');
43
44-- --------------------------------------------------------
45
46--
47-- Štruktúra tabuľky pre tabuľku `lifts`
48--
49
50CREATE TABLE IF NOT EXISTS `lifts` (
51 `id` int(11) NOT NULL AUTO_INCREMENT,
52 `disabled` tinyint(1) NOT NULL DEFAULT '0',
53 `comment` varchar(255) DEFAULT NULL,
54 PRIMARY KEY (`id`)
55) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
56
57-- --------------------------------------------------------
58
59--
60-- Štruktúra tabuľky pre tabuľku `lift_floors`
61--
62
63CREATE TABLE IF NOT EXISTS `lift_floors` (
64 `id` int(11) NOT NULL AUTO_INCREMENT,
65 `lift` int(11) NOT NULL,
66 `x` float(10,6) DEFAULT '0.000000',
67 `y` float(10,6) DEFAULT '0.000000',
68 `z` float(10,6) DEFAULT '0.000000',
69 `dimension` int(5) DEFAULT '0',
70 `interior` int(5) DEFAULT '0',
71 `floor` varchar(3) NOT NULL,
72 `name` varchar(100) NOT NULL,
73 PRIMARY KEY (`id`)
74) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
75
76-- --------------------------------------------------------
77
78--
79-- Štruktúra tabuľky pre tabuľku `ucty`
80--
81
82CREATE TABLE IF NOT EXISTS `ucty` (
83 `ID` int(11) NOT NULL AUTO_INCREMENT,
84 `meno` text NOT NULL,
85 `heslo` varchar(32) NOT NULL,
86 `email` varchar(100) NOT NULL,
87 `ip` text NOT NULL,
88 `serial` text NOT NULL,
89 `skin` int(3) NOT NULL DEFAULT '1',
90 `x` float NOT NULL DEFAULT '0',
91 `y` float NOT NULL DEFAULT '0',
92 `z` float NOT NULL DEFAULT '0',
93 `admin_level` int(11) NOT NULL DEFAULT '0',
94 `km` int(11) NOT NULL DEFAULT '0',
95 `played` int(11) NOT NULL DEFAULT '1',
96 PRIMARY KEY (`ID`)
97) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
98
99--
100-- Sťahujem dáta pre tabuľku `ucty`
101--
102
103INSERT INTO `ucty` (`ID`, `meno`, `heslo`, `email`, `ip`, `serial`, `skin`, `x`, `y`, `z`, `admin_level`, `km`, `played`) VALUES
104(18, 'pato', '56B34FEABE82F143521B911D6139F3E5', 'ssS@ssS.Ss', '91.222.104.82', '6730F1BE2BE52A2821061DDBCEE926F2', 125, 2439.56, -1720.03, 14.0088, 6, 25, 144),
105(19, 'didio', '04D09B112D32F374677782357D91A412', 'mas@curaka.Decko', '91.226.115.247', '5AD1C4A473813CEE19E064182B44C9F3', 1, 0, 0, 0, 0, 0, 1),
106(20, 'paradoxx', 'A3DCB4D229DE6FDE0DB5686DEE47145D', 'asd@gmail.com', '62.197.221.186', '671DC40F450A22C19D721FEADB6AFD12', 1, 1252, -1693.35, 19.5287, 6, 41, 238),
107(21, 'della', 'FFDF640DF492C2E14E46FE4B60B20937', 'rici.bernath@gmail.com', '90.64.116.165', '97F86DC0945529CCDCAEF9D0833D94E4', 1, -1573.1, 940.72, 7.18907, 0, 6, 25);
108
109/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
110/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
111/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;