1C2PQd2M

1-- phpMyAdmin SQL Dump
2-- version 4.0.4.2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas wygenerowania: 07 Sty 2017, 10:04
7-- Wersja serwera: 5.6.13
8-- Wersja PHP: 5.4.17
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-- Baza danych: `madzia`
21--
22CREATE DATABASE IF NOT EXISTS `mforum` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
23USE `mforum`;
24
25-- --------------------------------------------------------
26
27--
28-- Struktura tabeli dla tabeli `kategorie`
29--
30
31CREATE TABLE IF NOT EXISTS `kategorie` (
32  `id` int(11) NOT NULL AUTO_INCREMENT,
33  `nazwa` varchar(64) COLLATE utf8_polish_ci NOT NULL,
34  PRIMARY KEY (`id`)
35) ENGINE=InnoDB AUTO_INCREMENT=1 ;
36
37-- --------------------------------------------------------
38
39--
40-- Struktura tabeli dla tabeli `posty`
41--
42
43CREATE TABLE IF NOT EXISTS `posty` (
44  `id` int(11) NOT NULL AUTO_INCREMENT,
45  `temat` int(11) NOT NULL,
46  `autor` int(11) NOT NULL,
47  `tekst` text COLLATE utf8_polish_ci NOT NULL,
48  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
49  PRIMARY KEY (`id`)
50) ENGINE=InnoDB AUTO_INCREMENT=1 ;
51
52-- --------------------------------------------------------
53
54--
55-- Struktura tabeli dla tabeli `tematy`
56--
57
58CREATE TABLE IF NOT EXISTS `tematy` (
59  `id` int(11) NOT NULL AUTO_INCREMENT,
60  `kategoria` int(11) NOT NULL,
61  `nazwa` varchar(64) COLLATE utf8_polish_ci NOT NULL,
62  `autor` int(11) NOT NULL,
63  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
64  PRIMARY KEY (`id`)
65) ENGINE=InnoDB AUTO_INCREMENT=1 ;
66
67-- --------------------------------------------------------
68
69--
70-- Struktura tabeli dla tabeli `uzytkownicy`
71--
72
73CREATE TABLE IF NOT EXISTS `uzytkownicy` (
74  `id` int(11) NOT NULL AUTO_INCREMENT,
75  `nazwa` varchar(32) COLLATE utf8_polish_ci NOT NULL,
76  `haslo` varchar(64) COLLATE utf8_polish_ci NOT NULL,
77  `mail` varchar(32) COLLATE utf8_polish_ci NOT NULL,
78  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
79  PRIMARY KEY (`id`)
80) ENGINE=InnoDB AUTO_INCREMENT=1 ;
81
82/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
83/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
84/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;