<?php

include('../global.php');

$Database->select_db('measure');
$Result = $Database->select('measure', '*', 'DataTable != "data"');
while($Measure = $Result->fetch_array())
{
  echo($Measure['Description'].'<br>');
  
  $Database->query("
CREATE TABLE IF NOT EXISTS `".$Measure['DataTable']."` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `measure` smallint(11) NOT NULL default '0',
  `min` ".$Measure['DataType']." NOT NULL default '0',
  `avg` ".$Measure['DataType']." NOT NULL default '0',
  `max` ".$Measure['DataType']." 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;
");
  $Database->query('TRUNCATE TABLE `'.$Measure['DataTable'].'`');
  
  $Database->query('INSERT INTO '.$Measure['DataTable'].' SELECT * FROM data WHERE measure='.$Measure['Id']);
  $Database->query('INSERT INTO '.$Measure['DataTable'].' SELECT * FROM data_cache WHERE measure='.$Measure['Id']);
  if($Measure['Divider'] == 100)
  {
    $Database->query('UPDATE '.$Measure['DataTable'].' SET min=min / '.$Measure['Divider'].', avg=avg /'.$Measure['Divider'].', max=max /'.$Measure['Divider']);
  }
  if($Measure['Divider'] == 1000000000)
  {
    $Database->query('UPDATE '.$Measure['DataTable'].' SET min=min * 1000000, avg=avg *1000000, max=max * 1000000');
  }
}

?>