-- phpMyAdmin SQL Dump
-- version 3.0.1
-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vygenerováno: Pátek 07. listopadu 2008, 23:57
-- Verze MySQL: 5.0.51
-- Verze PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Databáze: `statistic`
--

-- --------------------------------------------------------

--
-- Struktura tabulky `data_availability`
--

CREATE TABLE IF NOT EXISTS `data_availability` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` float NOT NULL default '0',
  `avg` float NOT NULL default '0',
  `max` float NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_cpu`
--

CREATE TABLE IF NOT EXISTS `data_cpu` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` float NOT NULL default '0',
  `avg` float NOT NULL default '0',
  `max` float NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_disk_free_space`
--

CREATE TABLE IF NOT EXISTS `data_disk_free_space` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` bigint(20) NOT NULL default '0',
  `avg` bigint(20) NOT NULL default '0',
  `max` bigint(20) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_disk_utilization`
--

CREATE TABLE IF NOT EXISTS `data_disk_utilization` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` float NOT NULL default '0',
  `avg` float NOT NULL default '0',
  `max` float NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_finance`
--

CREATE TABLE IF NOT EXISTS `data_finance` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` int(11) NOT NULL default '0',
  `avg` int(11) NOT NULL default '0',
  `max` int(11) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_mangos_failure`
--

CREATE TABLE IF NOT EXISTS `data_mangos_failure` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` int(11) NOT NULL default '0',
  `avg` int(11) NOT NULL default '0',
  `max` int(11) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_mem`
--

CREATE TABLE IF NOT EXISTS `data_mem` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` bigint(20) NOT NULL default '0',
  `avg` bigint(20) NOT NULL default '0',
  `max` bigint(20) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_network_down`
--

CREATE TABLE IF NOT EXISTS `data_network_down` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` bigint(20) NOT NULL default '0',
  `avg` bigint(20) NOT NULL default '0',
  `max` bigint(20) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_network_up`
--

CREATE TABLE IF NOT EXISTS `data_network_up` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` bigint(20) NOT NULL default '0',
  `avg` bigint(20) NOT NULL default '0',
  `max` bigint(20) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_ping_nix`
--

CREATE TABLE IF NOT EXISTS `data_ping_nix` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` float NOT NULL default '0',
  `avg` float NOT NULL default '0',
  `max` float NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_quests_translated`
--

CREATE TABLE IF NOT EXISTS `data_quests_translated` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` int(11) NOT NULL default '0',
  `avg` int(11) NOT NULL default '0',
  `max` int(11) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_teamspeak`
--

CREATE TABLE IF NOT EXISTS `data_teamspeak` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` smallint(6) NOT NULL default '0',
  `avg` smallint(6) NOT NULL default '0',
  `max` smallint(6) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_temperature_cpu`
--

CREATE TABLE IF NOT EXISTS `data_temperature_cpu` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` float NOT NULL default '0',
  `avg` float NOT NULL default '0',
  `max` float NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_wow_account_count`
--

CREATE TABLE IF NOT EXISTS `data_wow_account_count` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` smallint(6) NOT NULL default '0',
  `avg` smallint(6) NOT NULL default '0',
  `max` smallint(6) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_wow_character_count`
--

CREATE TABLE IF NOT EXISTS `data_wow_character_count` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` smallint(6) NOT NULL default '0',
  `avg` smallint(6) NOT NULL default '0',
  `max` smallint(6) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_wow_gm_online`
--

CREATE TABLE IF NOT EXISTS `data_wow_gm_online` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` tinyint(4) NOT NULL default '0',
  `avg` tinyint(4) NOT NULL default '0',
  `max` tinyint(4) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_wow_guild_count`
--

CREATE TABLE IF NOT EXISTS `data_wow_guild_count` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` smallint(6) NOT NULL default '0',
  `avg` smallint(6) NOT NULL default '0',
  `max` smallint(6) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `data_wow_players`
--

CREATE TABLE IF NOT EXISTS `data_wow_players` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` smallint(6) NOT NULL default '0',
  `avg` smallint(6) NOT NULL default '0',
  `max` smallint(6) NOT NULL default '0',
  `continuity` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

-- --------------------------------------------------------

--
-- Struktura tabulky `measure`
--

CREATE TABLE IF NOT EXISTS `measure` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) collate latin2_czech_cs NOT NULL,
  `Description` varchar(255) collate latin2_czech_cs NOT NULL,
  `Divider` int(11) NOT NULL default '1',
  `Unit` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL,
  `Continuity` tinyint(1) NOT NULL default '0',
  `Period` int(11) NOT NULL default '60',
  `OldName` varchar(32) collate latin2_czech_cs NOT NULL,
  `PermissionView` varchar(255) collate latin2_czech_cs NOT NULL default 'all',
  `PermissionAdd` varchar(255) collate latin2_czech_cs NOT NULL default 'localhost.localdomain',
  `Info` varchar(255) collate latin2_czech_cs NOT NULL,
  `Enabled` int(11) NOT NULL default '1',
  `Cumulative` int(11) NOT NULL default '0',
  `DataTable` varchar(32) collate latin2_czech_cs NOT NULL default 'data',
  `DataType` varchar(32) collate latin2_czech_cs NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=22 ;


INSERT INTO `measure` (`Id`, `Name`, `Description`, `Divider`, `Unit`, `Continuity`, `Period`, `OldName`, `PermissionView`, `PermissionAdd`, `Info`, `Enabled`, `Cumulative`, `DataTable`, `DataType`) VALUES
(3, 'mem', 'Systém - Paměť - Využití', 1, 'B', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_mem', 'bigint'),
(4, 'cpu', 'Systém - Procesor - Zatížení', 1, '%', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_cpu', 'float'),
(5, 'wow_players', 'WoW - Online hráči', 1, '', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_wow_players', 'smallint'),
(6, 'mangos_failure', 'WoW - Restarty MaNGOSu', 1, '', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_mangos_failure', 'int'),
(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'),
(8, 'wow_account_count', 'WoW - Počet účtů', 1, '', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_wow_account_count', 'smallint'),
(13, 'wow_character_count', 'WoW - Počet postav', 1, '', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_wow_character_count', 'smallint'),
(10, 'wow_gm_online', 'WoW - Počet GM online', 1, '', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_wow_gm_online', 'tinyint'),
(11, 'network_down', 'Systém - Síť - Příchozí data', 1, 'B/s', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_network_down', 'bigint'),
(12, 'network_up', 'Systém - Síť - Odchozí data', 1, 'B/s', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_network_up', 'bigint'),
(14, 'wow_guild_count', 'WoW - Počet guild', 1, '', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_wow_guild_count', 'smallint'),
(15, 'availability', 'WoW - Dostupnost ', 1, '%', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_availability', 'float'),
(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'),
(17, 'teamspeak', 'TeamSpeak - Připojení uživatelé', 1, '', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_teamspeak', 'smallint'),
(18, 'quests_translated', 'WoW - Přeložených textů', 1, '', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_quests_translated', 'int'),
(19, 'disk_utilization', 'Systém - Pevný disk - Zatížení', 1, '%', 0, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_disk_utilization', 'float'),
(20, 'temperature_cpu', 'Systém - Teplota - Procesor', 1, '˚C', 1, 60, '', 'all', 'localhost.localdomain', '', 1, 0, 'data_temperature_cpu', 'float'),
(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');
