aFUeaSE7

1-- phpMyAdmin SQL Dump
2-- version 3.5.8.2
3-- http://www.phpmyadmin.net
4--
5-- Hostiteľ: md2.wedos.net:3306
6-- Vygenerované: Ne 29.Júl 2018, 01:01
7-- Verzia serveru: 10.1.32-MariaDB
8-- Verzia 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áza: `d178160_radiodb`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Štruktúra tabuľky pre tabuľku `news`
27--
28
29CREATE TABLE IF NOT EXISTS `news` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
32  `text` text COLLATE utf8_unicode_ci NOT NULL,
33  `autor` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
34  `time` timestamp NOT NULL DEFAULT TIMESTAMP,
35  `img` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'empty.png',
36  PRIMARY KEY (`id`)
37) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
38
39-- --------------------------------------------------------
40
41--
42-- Štruktúra tabuľky pre tabuľku `registration`
43--
44
45CREATE TABLE IF NOT EXISTS `registration` (
46  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
47  `heslo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'nezadané',
48  `registraciadna` timestamp NOT NULL DEFAULT TIMESTAMP,
49  `icq` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
50  `prava` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'nevyplnené',
51  `salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
52  `loggeddna` timestamp NOT NULL DEFAULT TIMESTAMP ON UPDATE TIMESTAMP,
53  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
54  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
55  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
56  `ban` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
57  `admin_group` text COLLATE utf8_unicode_ci NOT NULL,
58  `code` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
59  UNIQUE KEY `email` (`email`)
60) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
61
62-- --------------------------------------------------------
63
64--
65-- Štruktúra tabuľky pre tabuľku `settingsedit`
66--
67
68CREATE TABLE IF NOT EXISTS `settingsedit` (
69  `id` int(11) NOT NULL AUTO_INCREMENT,
70  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
71  `sitename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
72  `description` text COLLATE utf8_unicode_ci NOT NULL,
73  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
74  `sitename2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
75  `locale2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
76  `author` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
77  PRIMARY KEY (`id`)
78) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
79
80--
81-- Sťahujem dáta pre tabuľku `settingsedit`
82--
83
84INSERT INTO `settingsedit` (`id`, `locale`, `sitename`, `description`, `keywords`, `sitename2`, `locale2`, `author`) VALUES
85(1, 'cs', 'Unknown title', '', '', '', 'Czech', 'Marcel "Hopyers" Krištofík');
86
87-- --------------------------------------------------------
88
89--
90-- Štruktúra tabuľky pre tabuľku `statistics`
91--
92
93CREATE TABLE IF NOT EXISTS `statistics` (
94  `id` int(11) NOT NULL AUTO_INCREMENT,
95  `mesiac` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
96  `den` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
97  `rok` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
98  `salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
99  `pouz` timestamp NOT NULL DEFAULT TIMESTAMP ON UPDATE TIMESTAMP,
100  `browser` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
101  PRIMARY KEY (`id`)
102) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
103
104-- --------------------------------------------------------
105
106--
107-- Štruktúra tabuľky pre tabuľku `users`
108--
109
110CREATE TABLE IF NOT EXISTS `users` (
111  `id` int(11) NOT NULL AUTO_INCREMENT,
112  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
113  `heslo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'nezadané',
114  `registraciadna` timestamp NOT NULL DEFAULT TIMESTAMP,
115  `icq` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
116  `prava` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'nevyplnené',
117  `salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
118  `loggeddna` timestamp NOT NULL DEFAULT TIMESTAMP ON UPDATE TIMESTAMP,
119  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
120  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
121  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
122  `ban` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
123  `admin_group` text COLLATE utf8_unicode_ci NOT NULL,
124  PRIMARY KEY (`id`),
125  UNIQUE KEY `email` (`email`)
126) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
127
128/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
129/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
130/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;