4jYtXAi7

1-- phpMyAdmin SQL Dump
2-- version 3.5.8.2
3-- http://www.phpmyadmin.net
4--
5-- Počítač: wm109.wedos.net:3306
6-- Vygenerováno: Pon 20. čen 2016, 23:27
7-- Verze serveru: 10.0.21-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: `dawe5`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabulky `administration`
27--
28
29CREATE TABLE IF NOT EXISTS `administration` (
30  `id` bigint(20) NOT NULL AUTO_INCREMENT,
31  `nick` text COLLATE utf8_czech_ci NOT NULL,
32  `email` text COLLATE utf8_czech_ci NOT NULL,
33  `level` int(11) NOT NULL,
34  `heslo` text COLLATE utf8_czech_ci NOT NULL,
35  `body` bigint(20) NOT NULL,
36  `ip` text COLLATE utf8_czech_ci NOT NULL,
37  `registrovany` text COLLATE utf8_czech_ci NOT NULL,
38  `avatar` text COLLATE utf8_czech_ci NOT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
41
42-- --------------------------------------------------------
43
44--
45-- Struktura tabulky `categories`
46--
47
48CREATE TABLE IF NOT EXISTS `categories` (
49  `id` smallint(6) NOT NULL,
50  `name` varchar(256) NOT NULL,
51  `description` text NOT NULL,
52  `position` smallint(6) NOT NULL,
53  PRIMARY KEY (`id`)
54) ENGINE=MyISAM DEFAULT CHARSET=utf8;
55
56-- --------------------------------------------------------
57
58--
59-- Struktura tabulky `kupony`
60--
61
62CREATE TABLE IF NOT EXISTS `kupony` (
63  `id` bigint(20) NOT NULL AUTO_INCREMENT,
64  `kupon` text COLLATE utf8_czech_ci NOT NULL,
65  `mjuse` text COLLATE utf8_czech_ci NOT NULL,
66  `coins` text COLLATE utf8_czech_ci NOT NULL,
67  `smazano` int(11) NOT NULL,
68  PRIMARY KEY (`id`)
69) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
70
71-- --------------------------------------------------------
72
73--
74-- Struktura tabulky `novinky`
75--
76
77CREATE TABLE IF NOT EXISTS `novinky` (
78  `id` bigint(20) NOT NULL AUTO_INCREMENT,
79  `nadpis` text COLLATE utf8_czech_ci NOT NULL,
80  `text` text COLLATE utf8_czech_ci NOT NULL,
81  `autor` text COLLATE utf8_czech_ci NOT NULL,
82  `datum` text COLLATE utf8_czech_ci NOT NULL,
83  `smazano` int(11) NOT NULL,
84  PRIMARY KEY (`id`)
85) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
86
87-- --------------------------------------------------------
88
89--
90-- Struktura tabulky `pm`
91--
92
93CREATE TABLE IF NOT EXISTS `pm` (
94  `id` bigint(20) NOT NULL,
95  `id2` int(11) NOT NULL,
96  `title` varchar(256) NOT NULL,
97  `user1` bigint(20) NOT NULL,
98  `user2` bigint(20) NOT NULL,
99  `message` text NOT NULL,
100  `timestamp` int(10) NOT NULL,
101  `user1read` varchar(3) NOT NULL,
102  `user2read` varchar(3) NOT NULL
103) ENGINE=MyISAM DEFAULT CHARSET=utf8;
104
105-- --------------------------------------------------------
106
107--
108-- Struktura tabulky `topics`
109--
110
111CREATE TABLE IF NOT EXISTS `topics` (
112  `parent` smallint(6) NOT NULL,
113  `id` int(11) NOT NULL,
114  `id2` int(11) NOT NULL,
115  `title` varchar(256) NOT NULL,
116  `message` longtext NOT NULL,
117  `authorid` int(11) NOT NULL,
118  `timestamp` int(11) NOT NULL,
119  `timestamp2` int(11) NOT NULL,
120  PRIMARY KEY (`id`,`id2`)
121) ENGINE=MyISAM DEFAULT CHARSET=utf8;
122
123-- --------------------------------------------------------
124
125--
126-- Struktura tabulky `udalosti`
127--
128
129CREATE TABLE IF NOT EXISTS `udalosti` (
130  `id` bigint(20) NOT NULL AUTO_INCREMENT,
131  `text` text COLLATE utf8_czech_ci NOT NULL,
132  `smazano` int(11) NOT NULL,
133  PRIMARY KEY (`id`)
134) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
135
136/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
137/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
138/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;