-- http://www.phpmyadmin.net
-- 
-- Poèítaè: localhost
-- Vygenerováno: Pátek 16. bøezna 2007, 20:55
-- Verze MySQL: 4.1.9
-- Verze PHP: 4.3.10
-- 
-- Databáze: `statistic`
-- 

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

-- 
-- Struktura tabulky `stat_data`
-- 

CREATE TABLE `stat_data` (
  `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',
  `group` smallint(6) NOT NULL default '0',
  KEY `time` (`time`),
  KEY `time_2` (`time`,`measure`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Struktura tabulky `stat_data_cache`
-- 

CREATE TABLE `stat_data_cache` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(6) 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` smallint(6) NOT NULL default '0',
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;

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

-- 
-- Struktura tabulky `stat_measure`
-- 

CREATE TABLE `stat_measure` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate latin2_czech_cs NOT NULL default '',
  `description` varchar(255) collate latin2_czech_cs NOT NULL default '',
  `divider` int(11) NOT NULL default '1',
  `unit` varchar(16) collate latin2_czech_cs NOT NULL default '',
  `continuity` tinyint(1) NOT NULL default '0',
  `period` int(11) NOT NULL default '60',
  `old_name` varchar(32) collate latin2_czech_cs NOT NULL default '',
  `privileged_hosts` varchar(255) collate latin2_czech_cs NOT NULL default 'localhost',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
        
