DMRNtUYg

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 CURRENT_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 '0000-00-00',
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 CURRENT_TIMESTAMP ON UPDATE CURRENT_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=1 ;
79
80--
81-- Sťahujem dáta pre tabuľku `settingsedit`
82--
83
84-- --------------------------------------------------------
85
86--
87-- Štruktúra tabuľky pre tabuľku `statistics`
88--
89
90CREATE TABLE IF NOT EXISTS statistics (
91  id int(11) NOT NULL AUTO_INCREMENT,
92  mesiac varchar(255) COLLATE utf8_unicode_ci NOT NULL,
93  den varchar(255) COLLATE utf8_unicode_ci NOT NULL,
94  rok varchar(255) COLLATE utf8_unicode_ci NOT NULL,
95  salt varchar(255) COLLATE utf8_unicode_ci NOT NULL,
96  pouz timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
97  browser varchar(255) COLLATE utf8_unicode_ci NOT NULL,
98  PRIMARY KEY (id)
99) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
100
101-- --------------------------------------------------------
102
103--
104-- Štruktúra tabuľky pre tabuľku `users`
105--
106
107CREATE TABLE IF NOT EXISTS `users` (
108  `id` int(11) NOT NULL AUTO_INCREMENT,
109  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
110  `heslo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'nezadané',
111  `registraciadna` timestamp NOT NULL DEFAULT '0000-00-00',
112  `icq` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
113  `prava` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'nevyplnené',
114  `salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
115  `loggeddna` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
116  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
117  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
118  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
119  `ban` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
120  `admin_group` text COLLATE utf8_unicode_ci NOT NULL,
121  PRIMARY KEY (`id`),
122  UNIQUE KEY `email` (`email`)
123) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
124
125/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
126/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
127/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;