1 | -- phpMyAdmin SQL Dump
|
---|
2 | -- version 2.9.2
|
---|
3 | -- http://www.phpmyadmin.net
|
---|
4 | --
|
---|
5 | -- Počítač: mysql5-1
|
---|
6 | -- Vygenerováno: Čtvrtek 01. května 2008, 01:16
|
---|
7 | -- Verze MySQL: 5.0.32
|
---|
8 | -- Verze PHP: 5.2.0-8+etch3
|
---|
9 | --
|
---|
10 | -- Databáze: `servery_1274`
|
---|
11 | --
|
---|
12 |
|
---|
13 | -- --------------------------------------------------------
|
---|
14 |
|
---|
15 | --
|
---|
16 | -- Struktura tabulky `comments`
|
---|
17 | --
|
---|
18 |
|
---|
19 | CREATE TABLE `comments` (
|
---|
20 | `id` int(11) NOT NULL auto_increment,
|
---|
21 | `time` int(11) default NULL,
|
---|
22 | `server` int(11) default NULL,
|
---|
23 | `author` int(11) default NULL,
|
---|
24 | `text` text character set utf8 collate utf8_czech_ci,
|
---|
25 | PRIMARY KEY (`id`)
|
---|
26 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1486 ;
|
---|
27 |
|
---|
28 | -- --------------------------------------------------------
|
---|
29 |
|
---|
30 | --
|
---|
31 | -- Struktura tabulky `pages`
|
---|
32 | --
|
---|
33 |
|
---|
34 | CREATE TABLE `pages` (
|
---|
35 | `page` varchar(30) collate utf8_czech_ci default NULL,
|
---|
36 | `url` varchar(30) collate utf8_czech_ci default NULL,
|
---|
37 | `title` varchar(30) collate utf8_czech_ci default NULL,
|
---|
38 | `admin` tinyint(2) default NULL,
|
---|
39 | `menu` tinyint(2) default NULL,
|
---|
40 | UNIQUE KEY `page` (`page`)
|
---|
41 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
|
---|
42 |
|
---|
43 | -- --------------------------------------------------------
|
---|
44 |
|
---|
45 | --
|
---|
46 | -- Struktura tabulky `ratings`
|
---|
47 | --
|
---|
48 |
|
---|
49 | CREATE TABLE `ratings` (
|
---|
50 | `user_id` int(11) default NULL,
|
---|
51 | `server_id` int(11) default NULL,
|
---|
52 | `rating` tinyint(2) default NULL
|
---|
53 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
---|
54 |
|
---|
55 | -- --------------------------------------------------------
|
---|
56 |
|
---|
57 | --
|
---|
58 | -- Struktura tabulky `servers`
|
---|
59 | --
|
---|
60 |
|
---|
61 | CREATE TABLE `servers` (
|
---|
62 | `id` int(11) NOT NULL auto_increment,
|
---|
63 | `name` varchar(30) character set utf8 collate utf8_czech_ci NOT NULL,
|
---|
64 | `version` varchar(10) character set utf8 collate utf8_czech_ci default '2.1.3',
|
---|
65 | `emu` varchar(30) character set utf8 collate utf8_czech_ci default NULL,
|
---|
66 | `type` varchar(5) character set utf8 collate utf8_czech_ci default '1',
|
---|
67 | `xp` tinyint(2) default '3',
|
---|
68 | `limit` int(11) default '100',
|
---|
69 | `place` tinyint(2) default '1',
|
---|
70 | `web` varchar(255) character set utf8 collate utf8_czech_ci default 'http://',
|
---|
71 | `web_reg` varchar(255) character set utf8 collate utf8_czech_ci default 'http://',
|
---|
72 | `desc` text character set utf8 collate utf8_czech_ci,
|
---|
73 | `owner` int(11) default NULL,
|
---|
74 | `rating_sum` int(11) default '0',
|
---|
75 | `ratings` int(11) default '0',
|
---|
76 | `online_players_sum` bigint(20) default '0',
|
---|
77 | `online` int(11) default '0',
|
---|
78 | `player_checks` int(11) default '1',
|
---|
79 | `online_checks` int(11) default '0',
|
---|
80 | `port` int(11) default '8085',
|
---|
81 | `ip` varchar(50) character set utf8 collate utf8_czech_ci default NULL,
|
---|
82 | `created` int(11) default NULL,
|
---|
83 | `wss_partner` tinyint(2) default '0',
|
---|
84 | PRIMARY KEY (`id`)
|
---|
85 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=370 ;
|
---|
86 |
|
---|
87 | -- --------------------------------------------------------
|
---|
88 |
|
---|
89 | --
|
---|
90 | -- Struktura tabulky `users`
|
---|
91 | --
|
---|
92 |
|
---|
93 | CREATE TABLE `users` (
|
---|
94 | `id` int(11) NOT NULL auto_increment,
|
---|
95 | `name` varchar(30) collate utf8_czech_ci default NULL,
|
---|
96 | `password` varchar(50) collate utf8_czech_ci default NULL,
|
---|
97 | `email` varchar(50) collate utf8_czech_ci default NULL,
|
---|
98 | `ban` tinyint(2) default '0',
|
---|
99 | `active` tinyint(2) default '0',
|
---|
100 | `admin` tinyint(2) default '0',
|
---|
101 | PRIMARY KEY (`id`),
|
---|
102 | UNIQUE KEY `Unique` (`name`)
|
---|
103 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1471 ;
|
---|