source: branches/mvc/SQL/FullSample.sql

Last change on this file was 40, checked in by george, 15 years ago
  • Upraveno: Struktura souborů projektu přepracována na systém MVC.
File size: 13.6 KB
Line 
1-- phpMyAdmin SQL Dump
2-- version 3.0.1
3-- http://www.phpmyadmin.net
4--
5-- Počítač: localhost
6-- Vygenerováno: Pátek 07. listopadu 2008, 23:57
7-- Verze MySQL: 5.0.51
8-- Verze PHP: 5.2.6
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Databáze: `statistic`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Struktura tabulky `data_availability`
20--
21
22CREATE TABLE IF NOT EXISTS `data_availability` (
23 `time` datetime NOT NULL default '0000-00-00 00:00:00',
24 `measure` smallint(11) NOT NULL default '0',
25 `min` float NOT NULL default '0',
26 `avg` float NOT NULL default '0',
27 `max` float NOT NULL default '0',
28 `continuity` tinyint(1) NOT NULL default '0',
29 `level` tinyint(4) NOT NULL default '0',
30 KEY `time` (`time`)
31) ENGINE=MyISAM DEFAULT CHARSET=latin2;
32
33-- --------------------------------------------------------
34
35--
36-- Struktura tabulky `data_cpu`
37--
38
39CREATE TABLE IF NOT EXISTS `data_cpu` (
40 `time` datetime NOT NULL default '0000-00-00 00:00:00',
41 `measure` smallint(11) NOT NULL default '0',
42 `min` float NOT NULL default '0',
43 `avg` float NOT NULL default '0',
44 `max` float NOT NULL default '0',
45 `continuity` tinyint(1) NOT NULL default '0',
46 `level` tinyint(4) NOT NULL default '0',
47 KEY `time` (`time`)
48) ENGINE=MyISAM DEFAULT CHARSET=latin2;
49
50-- --------------------------------------------------------
51
52--
53-- Struktura tabulky `data_disk_free_space`
54--
55
56CREATE TABLE IF NOT EXISTS `data_disk_free_space` (
57 `time` datetime NOT NULL default '0000-00-00 00:00:00',
58 `measure` smallint(11) NOT NULL default '0',
59 `min` bigint(20) NOT NULL default '0',
60 `avg` bigint(20) NOT NULL default '0',
61 `max` bigint(20) NOT NULL default '0',
62 `continuity` tinyint(1) NOT NULL default '0',
63 `level` tinyint(4) NOT NULL default '0',
64 KEY `time` (`time`)
65) ENGINE=MyISAM DEFAULT CHARSET=latin2;
66
67-- --------------------------------------------------------
68
69--
70-- Struktura tabulky `data_disk_utilization`
71--
72
73CREATE TABLE IF NOT EXISTS `data_disk_utilization` (
74 `time` datetime NOT NULL default '0000-00-00 00:00:00',
75 `measure` smallint(11) NOT NULL default '0',
76 `min` float NOT NULL default '0',
77 `avg` float NOT NULL default '0',
78 `max` float NOT NULL default '0',
79 `continuity` tinyint(1) NOT NULL default '0',
80 `level` tinyint(4) NOT NULL default '0',
81 KEY `time` (`time`)
82) ENGINE=MyISAM DEFAULT CHARSET=latin2;
83
84-- --------------------------------------------------------
85
86--
87-- Struktura tabulky `data_finance`
88--
89
90CREATE TABLE IF NOT EXISTS `data_finance` (
91 `time` datetime NOT NULL default '0000-00-00 00:00:00',
92 `measure` smallint(11) NOT NULL default '0',
93 `min` int(11) NOT NULL default '0',
94 `avg` int(11) NOT NULL default '0',
95 `max` int(11) NOT NULL default '0',
96 `continuity` tinyint(1) NOT NULL default '0',
97 `level` tinyint(4) NOT NULL default '0',
98 KEY `time` (`time`)
99) ENGINE=MyISAM DEFAULT CHARSET=latin2;
100
101-- --------------------------------------------------------
102
103--
104-- Struktura tabulky `data_mangos_failure`
105--
106
107CREATE TABLE IF NOT EXISTS `data_mangos_failure` (
108 `time` datetime NOT NULL default '0000-00-00 00:00:00',
109 `measure` smallint(11) NOT NULL default '0',
110 `min` int(11) NOT NULL default '0',
111 `avg` int(11) NOT NULL default '0',
112 `max` int(11) NOT NULL default '0',
113 `continuity` tinyint(1) NOT NULL default '0',
114 `level` tinyint(4) NOT NULL default '0',
115 KEY `time` (`time`)
116) ENGINE=MyISAM DEFAULT CHARSET=latin2;
117
118-- --------------------------------------------------------
119
120--
121-- Struktura tabulky `data_mem`
122--
123
124CREATE TABLE IF NOT EXISTS `data_mem` (
125 `time` datetime NOT NULL default '0000-00-00 00:00:00',
126 `measure` smallint(11) NOT NULL default '0',
127 `min` bigint(20) NOT NULL default '0',
128 `avg` bigint(20) NOT NULL default '0',
129 `max` bigint(20) NOT NULL default '0',
130 `continuity` tinyint(1) NOT NULL default '0',
131 `level` tinyint(4) NOT NULL default '0',
132 KEY `time` (`time`)
133) ENGINE=MyISAM DEFAULT CHARSET=latin2;
134
135-- --------------------------------------------------------
136
137--
138-- Struktura tabulky `data_network_down`
139--
140
141CREATE TABLE IF NOT EXISTS `data_network_down` (
142 `time` datetime NOT NULL default '0000-00-00 00:00:00',
143 `measure` smallint(11) NOT NULL default '0',
144 `min` bigint(20) NOT NULL default '0',
145 `avg` bigint(20) NOT NULL default '0',
146 `max` bigint(20) NOT NULL default '0',
147 `continuity` tinyint(1) NOT NULL default '0',
148 `level` tinyint(4) NOT NULL default '0',
149 KEY `time` (`time`)
150) ENGINE=MyISAM DEFAULT CHARSET=latin2;
151
152-- --------------------------------------------------------
153
154--
155-- Struktura tabulky `data_network_up`
156--
157
158CREATE TABLE IF NOT EXISTS `data_network_up` (
159 `time` datetime NOT NULL default '0000-00-00 00:00:00',
160 `measure` smallint(11) NOT NULL default '0',
161 `min` bigint(20) NOT NULL default '0',
162 `avg` bigint(20) NOT NULL default '0',
163 `max` bigint(20) NOT NULL default '0',
164 `continuity` tinyint(1) NOT NULL default '0',
165 `level` tinyint(4) NOT NULL default '0',
166 KEY `time` (`time`)
167) ENGINE=MyISAM DEFAULT CHARSET=latin2;
168
169-- --------------------------------------------------------
170
171--
172-- Struktura tabulky `data_ping_nix`
173--
174
175CREATE TABLE IF NOT EXISTS `data_ping_nix` (
176 `time` datetime NOT NULL default '0000-00-00 00:00:00',
177 `measure` smallint(11) NOT NULL default '0',
178 `min` float NOT NULL default '0',
179 `avg` float NOT NULL default '0',
180 `max` float NOT NULL default '0',
181 `continuity` tinyint(1) NOT NULL default '0',
182 `level` tinyint(4) NOT NULL default '0',
183 KEY `time` (`time`)
184) ENGINE=MyISAM DEFAULT CHARSET=latin2;
185
186-- --------------------------------------------------------
187
188--
189-- Struktura tabulky `data_quests_translated`
190--
191
192CREATE TABLE IF NOT EXISTS `data_quests_translated` (
193 `time` datetime NOT NULL default '0000-00-00 00:00:00',
194 `measure` smallint(11) NOT NULL default '0',
195 `min` int(11) NOT NULL default '0',
196 `avg` int(11) NOT NULL default '0',
197 `max` int(11) NOT NULL default '0',
198 `continuity` tinyint(1) NOT NULL default '0',
199 `level` tinyint(4) NOT NULL default '0',
200 KEY `time` (`time`)
201) ENGINE=MyISAM DEFAULT CHARSET=latin2;
202
203-- --------------------------------------------------------
204
205--
206-- Struktura tabulky `data_teamspeak`
207--
208
209CREATE TABLE IF NOT EXISTS `data_teamspeak` (
210 `time` datetime NOT NULL default '0000-00-00 00:00:00',
211 `measure` smallint(11) NOT NULL default '0',
212 `min` smallint(6) NOT NULL default '0',
213 `avg` smallint(6) NOT NULL default '0',
214 `max` smallint(6) NOT NULL default '0',
215 `continuity` tinyint(1) NOT NULL default '0',
216 `level` tinyint(4) NOT NULL default '0',
217 KEY `time` (`time`)
218) ENGINE=MyISAM DEFAULT CHARSET=latin2;
219
220-- --------------------------------------------------------
221
222--
223-- Struktura tabulky `data_temperature_cpu`
224--
225
226CREATE TABLE IF NOT EXISTS `data_temperature_cpu` (
227 `time` datetime NOT NULL default '0000-00-00 00:00:00',
228 `measure` smallint(11) NOT NULL default '0',
229 `min` float NOT NULL default '0',
230 `avg` float NOT NULL default '0',
231 `max` float NOT NULL default '0',
232 `continuity` tinyint(1) NOT NULL default '0',
233 `level` tinyint(4) NOT NULL default '0',
234 KEY `time` (`time`)
235) ENGINE=MyISAM DEFAULT CHARSET=latin2;
236
237-- --------------------------------------------------------
238
239--
240-- Struktura tabulky `data_wow_account_count`
241--
242
243CREATE TABLE IF NOT EXISTS `data_wow_account_count` (
244 `time` datetime NOT NULL default '0000-00-00 00:00:00',
245 `measure` smallint(11) NOT NULL default '0',
246 `min` smallint(6) NOT NULL default '0',
247 `avg` smallint(6) NOT NULL default '0',
248 `max` smallint(6) NOT NULL default '0',
249 `continuity` tinyint(1) NOT NULL default '0',
250 `level` tinyint(4) NOT NULL default '0',
251 KEY `time` (`time`)
252) ENGINE=MyISAM DEFAULT CHARSET=latin2;
253
254-- --------------------------------------------------------
255
256--
257-- Struktura tabulky `data_wow_character_count`
258--
259
260CREATE TABLE IF NOT EXISTS `data_wow_character_count` (
261 `time` datetime NOT NULL default '0000-00-00 00:00:00',
262 `measure` smallint(11) NOT NULL default '0',
263 `min` smallint(6) NOT NULL default '0',
264 `avg` smallint(6) NOT NULL default '0',
265 `max` smallint(6) NOT NULL default '0',
266 `continuity` tinyint(1) NOT NULL default '0',
267 `level` tinyint(4) NOT NULL default '0',
268 KEY `time` (`time`)
269) ENGINE=MyISAM DEFAULT CHARSET=latin2;
270
271-- --------------------------------------------------------
272
273--
274-- Struktura tabulky `data_wow_gm_online`
275--
276
277CREATE TABLE IF NOT EXISTS `data_wow_gm_online` (
278 `time` datetime NOT NULL default '0000-00-00 00:00:00',
279 `measure` smallint(11) NOT NULL default '0',
280 `min` tinyint(4) NOT NULL default '0',
281 `avg` tinyint(4) NOT NULL default '0',
282 `max` tinyint(4) NOT NULL default '0',
283 `continuity` tinyint(1) NOT NULL default '0',
284 `level` tinyint(4) NOT NULL default '0',
285 KEY `time` (`time`)
286) ENGINE=MyISAM DEFAULT CHARSET=latin2;
287
288-- --------------------------------------------------------
289
290--
291-- Struktura tabulky `data_wow_guild_count`
292--
293
294CREATE TABLE IF NOT EXISTS `data_wow_guild_count` (
295 `time` datetime NOT NULL default '0000-00-00 00:00:00',
296 `measure` smallint(11) NOT NULL default '0',
297 `min` smallint(6) NOT NULL default '0',
298 `avg` smallint(6) NOT NULL default '0',
299 `max` smallint(6) NOT NULL default '0',
300 `continuity` tinyint(1) NOT NULL default '0',
301 `level` tinyint(4) NOT NULL default '0',
302 KEY `time` (`time`)
303) ENGINE=MyISAM DEFAULT CHARSET=latin2;
304
305-- --------------------------------------------------------
306
307--
308-- Struktura tabulky `data_wow_players`
309--
310
311CREATE TABLE IF NOT EXISTS `data_wow_players` (
312 `time` datetime NOT NULL default '0000-00-00 00:00:00',
313 `measure` smallint(11) NOT NULL default '0',
314 `min` smallint(6) NOT NULL default '0',
315 `avg` smallint(6) NOT NULL default '0',
316 `max` smallint(6) NOT NULL default '0',
317 `continuity` tinyint(1) NOT NULL default '0',
318 `level` tinyint(4) NOT NULL default '0',
319 KEY `time` (`time`)
320) ENGINE=MyISAM DEFAULT CHARSET=latin2;
321
322-- --------------------------------------------------------
323
324--
325-- Struktura tabulky `measure`
326--
327
328CREATE TABLE IF NOT EXISTS `measure` (
329 `Id` int(11) NOT NULL auto_increment,
330 `Name` varchar(255) collate latin2_czech_cs NOT NULL,
331 `Description` varchar(255) collate latin2_czech_cs NOT NULL,
332 `Divider` int(11) NOT NULL default '1',
333 `Unit` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL,
334 `Continuity` tinyint(1) NOT NULL default '0',
335 `Period` int(11) NOT NULL default '60',
336 `OldName` varchar(32) collate latin2_czech_cs NOT NULL,
337 `PermissionView` varchar(255) collate latin2_czech_cs NOT NULL default 'all',
338 `PermissionAdd` varchar(255) collate latin2_czech_cs NOT NULL default 'localhost.localdomain',
339 `Info` varchar(255) collate latin2_czech_cs NOT NULL,
340 `Enabled` int(11) NOT NULL default '1',
341 `Cumulative` int(11) NOT NULL default '0',
342 `DataTable` varchar(32) collate latin2_czech_cs NOT NULL default 'data',
343 `DataType` varchar(32) collate latin2_czech_cs NOT NULL,
344 PRIMARY KEY (`Id`)
345) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=22 ;
346
347
348INSERT INTO `measure` (`Id`, `Name`, `Description`, `Divider`, `Unit`, `Continuity`, `Period`, `OldName`, `PermissionView`, `PermissionAdd`, `Info`, `Enabled`, `Cumulative`, `DataTable`, `DataType`) VALUES
349(3, 'mem', 'Systém - Paměť - Využití', 1, 'B', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_mem', 'bigint'),
350(4, 'cpu', 'Systém - Procesor - Zatížení', 1, '%', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_cpu', 'float'),
351(5, 'wow_players', 'WoW - Online hráči', 1, '', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_wow_players', 'smallint'),
352(6, 'mangos_failure', 'WoW - Restarty MaNGOSu', 1, '', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_mangos_failure', 'int'),
353(7, 'disk_free_space', 'Systém - Pevný disk - Volné místo', 1000000000, 'B', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_disk_free_space', 'bigint'),
354(8, 'wow_account_count', 'WoW - Počet účtů', 1, '', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_wow_account_count', 'smallint'),
355(13, 'wow_character_count', 'WoW - Počet postav', 1, '', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_wow_character_count', 'smallint'),
356(10, 'wow_gm_online', 'WoW - Počet GM online', 1, '', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_wow_gm_online', 'tinyint'),
357(11, 'network_down', 'Systém - Síť - Příchozí data', 1, 'B/s', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_network_down', 'bigint'),
358(12, 'network_up', 'Systém - Síť - Odchozí data', 1, 'B/s', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_network_up', 'bigint'),
359(14, 'wow_guild_count', 'WoW - Počet guild', 1, '', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_wow_guild_count', 'smallint'),
360(15, 'availability', 'WoW - Dostupnost ', 1, '%', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_availability', 'float'),
361(16, 'ping_nix', 'Systém - Síť - Odezva z internetu', 1, 'ms', 0, 60, '', 'all', 'localhost.localdomain', 'Vůči serveru nix.cz', 1, 0, 'data_ping_nix', 'float'),
362(17, 'teamspeak', 'TeamSpeak - Připojení uživatelé', 1, '', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_teamspeak', 'smallint'),
363(18, 'quests_translated', 'WoW - Přeložených textů', 1, '', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_quests_translated', 'int'),
364(19, 'disk_utilization', 'Systém - Pevný disk - Zatížení', 1, '%', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_disk_utilization', 'float'),
365(20, 'temperature_cpu', 'Systém - Teplota - Procesor', 1, '˚C', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_temperature_cpu', 'float'),
366(21, 'finance', 'Finance serveru', 1, 'Kč', 1, 3600, '', 'all', 'localhost.localdomain', 'Finanční příspěvky hráčů podle této <a href="http://wow.zdechov.net/finance/">stránky</a>.', 1, 0, 'data_finance', 'float');
Note: See TracBrowser for help on using the repository browser.