-- MySQL dump 10.13  Distrib 5.1.41, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: google_charts
-- ------------------------------------------------------
-- Server version	5.1.51-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `chart_data`
--

DROP TABLE IF EXISTS `chart_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chart_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `data` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=289 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chart_data`
--

LOCK TABLES `chart_data` WRITE;
/*!40000 ALTER TABLE `chart_data` DISABLE KEYS */;
INSERT INTO `chart_data` VALUES (1,'2011-03-02 22:00:00',1.99666833293656),(2,'2011-03-02 22:05:00',7.94677323180245),(3,'2011-03-02 22:10:00',17.7312123996804),(4,'2011-03-02 22:15:00',31.153467384692),(5,'2011-03-02 22:20:00',47.9425538604203),(6,'2011-03-02 22:25:00',67.7570968074042),(7,'2011-03-02 22:30:00',90.1904762132767),(8,'2011-03-02 22:35:00',114.776974543924),(9,'2011-03-02 22:40:00',140.998843732947),(10,'2011-03-02 22:45:00',168.294196961579),(11,'2011-03-02 22:50:00',196.065619213516),(12,'2011-03-02 22:55:00',223.689380632134),(13,'2011-03-02 23:00:00',250.52512820847),(14,'2011-03-02 23:05:00',275.925924396769),(15,'2011-03-02 23:10:00',299.248495981216),(16,'2011-03-02 23:15:00',319.863552973282),(17,'2011-03-02 23:20:00',337.166035553839),(18,'2011-03-02 23:25:00',350.58514711615),(19,'2011-03-02 23:30:00',359.594033321217),(20,'2011-03-02 23:35:00',363.718970730273),(21,'2011-03-02 23:40:00',362.547933992527),(22,'2011-03-02 23:45:00',355.73841768062),(23,'2011-03-02 23:50:00',343.024397601291),(24,'2011-03-02 23:55:00',324.222326664552),(25,'2011-03-03 00:00:00',299.236072051978),(26,'2011-03-03 00:05:00',268.060713347161),(27,'2011-03-03 00:10:00',230.785135326268),(28,'2011-03-03 00:15:00',187.593364087307),(29,'2011-03-03 00:20:00',138.76461094411),(30,'2011-03-03 00:25:00',84.6720048359203),(31,'2011-03-03 00:30:00',25.7800107086401),(32,'2011-03-03 00:35:00',-37.3594517936513),(33,'2011-03-03 00:40:00',-104.112158134544),(34,'2011-03-03 00:45:00',-173.767949378245),(35,'2011-03-03 00:50:00',-245.548259382734),(36,'2011-03-03 00:55:00',-318.614719172294),(37,'2011-03-03 01:00:00',-392.078744272285),(38,'2011-03-03 01:05:00',-465.011997116466),(39,'2011-03-03 01:10:00',-536.4576041635),(40,'2011-03-03 01:15:00',-605.441996246343),(41,'2011-03-03 01:20:00',-670.987231072816),(42,'2011-03-03 01:25:00',-732.123648827414),(43,'2011-03-03 01:30:00',-787.902705604531),(44,'2011-03-03 01:35:00',-837.409825022774),(45,'2011-03-03 01:40:00',-879.777105898587),(46,'2011-03-03 01:45:00',-914.195723342787),(47,'2011-03-03 01:50:00',-939.927862110255),(48,'2011-03-03 01:55:00',-956.318024482407),(49,'2011-03-03 02:00:00',-962.803560371846),(50,'2011-03-03 02:05:00',-958.924274663138),(51,'2011-03-03 02:10:00',-944.330975974287),(52,'2011-03-03 02:15:00',-918.792841948959),(53,'2011-03-03 02:20:00',-882.203488757335),(54,'2011-03-03 02:25:00',-834.585646560466),(55,'2011-03-03 02:30:00',-776.094358127431),(56,'2011-03-03 02:35:00',-707.018634417),(57,'2011-03-03 02:40:00',-627.781518561307),(58,'2011-03-03 02:45:00',-538.938528119959),(59,'2011-03-03 02:50:00',-441.174464499678),(60,'2011-03-03 02:55:00',-335.298597838711),(61,'2011-03-03 03:00:00',-222.238255211957),(62,'2011-03-03 03:05:00',-103.030859493696),(63,'2011-03-03 03:10:00',21.1855146102806),(64,'2011-03-03 03:15:00',149.182982208632),(65,'2011-03-03 03:20:00',279.65598451416),(66,'2011-03-03 03:25:00',411.234599837659),(67,'2011-03-03 03:30:00',542.498893626242),(68,'2011-03-03 03:35:00',671.994157548507),(69,'2011-03-03 03:40:00',798.246874855716),(70,'2011-03-03 03:45:00',919.781238206305),(71,'2011-03-03 03:50:00',1035.13603697874),(72,'2011-03-03 03:55:00',1142.88172394278),(73,'2011-03-03 04:00:00',1241.6374661177),(74,'2011-03-03 04:05:00',1330.08798180121),(75,'2011-03-03 04:10:00',1406.99996516211),(76,'2011-03-03 04:15:00',1471.23790148786),(77,'2011-03-03 04:20:00',1521.77908017058),(78,'2011-03-03 04:25:00',1557.72761878438),(79,'2011-03-03 04:30:00',1578.32732010684),(80,'2011-03-03 04:35:00',1582.97319459741),(81,'2011-03-03 04:40:00',1571.22149356904),(82,'2011-03-03 04:45:00',1542.79811295483),(83,'2011-03-03 04:50:00',1497.60524403545),(84,'2011-03-03 04:55:00',1435.72616558831),(85,'2011-03-03 05:00:00',1357.42809145993),(86,'2011-03-03 05:05:00',1263.16300834347),(87,'2011-03-03 05:10:00',1153.566460343),(88,'2011-03-03 05:15:00',1029.4542594895),(89,'2011-03-03 05:20:00',891.817124495035),(90,'2011-03-03 05:25:00',741.813273435162),(91,'2011-03-03 05:30:00',580.759019475821),(92,'2011-03-03 05:35:00',410.117441944456),(93,'2011-03-03 05:40:00',231.485227723135),(94,'2011-03-03 05:45:00',46.5777998523126),(95,'2011-03-03 05:50:00',-142.787128877438),(96,'2011-03-03 05:55:00',-334.707419948121),(97,'2011-03-03 06:00:00',-527.215615237228),(98,'2011-03-03 06:05:00',-718.29909333378),(99,'2011-03-03 06:10:00',-905.921069675136),(100,'2011-03-03 06:15:00',-1088.04222177874),(101,'2011-03-03 06:20:00',-1262.64271076362),(102,'2011-03-03 06:25:00',-1427.74436269083),(103,'2011-03-03 06:30:00',-1581.43276811298),(104,'2011-03-03 06:35:00',-1721.87905569816),(105,'2011-03-03 06:40:00',-1847.36109594051),(106,'2011-03-03 06:45:00',-1956.28389381915),(107,'2011-03-03 06:50:00',-2047.1989348182),(108,'2011-03-03 06:55:00',-2118.82225694362),(109,'2011-03-03 07:00:00',-2170.0510322079),(110,'2011-03-03 07:05:00',-2199.97845441155),(111,'2011-03-03 07:10:00',-2207.90674581286),(112,'2011-03-03 07:15:00',-2193.35811329895),(113,'2011-03-03 07:20:00',-2156.08350477872),(114,'2011-03-03 07:25:00',-2096.06903851546),(115,'2011-03-03 07:30:00',-2013.54000178339),(116,'2011-03-03 07:35:00',-1908.9623403274),(117,'2011-03-03 07:40:00',-1783.04158637054),(118,'2011-03-03 07:45:00',-1636.71920007401),(119,'2011-03-03 07:50:00',-1471.16632712414),(120,'2011-03-03 07:55:00',-1287.77500320104),(121,'2011-03-03 08:00:00',-1088.14686417374),(122,'2011-03-03 08:05:00',-874.079448657862),(123,'2011-03-03 08:10:00',-647.55020675987),(124,'2011-03-03 08:15:00',-410.698355111807),(125,'2011-03-03 08:20:00',-165.804743378002),(126,'2011-03-03 08:25:00',84.7300789972645),(127,'2011-03-03 08:30:00',338.409385206653),(128,'2011-03-03 08:35:00',592.66515225994),(129,'2011-03-03 08:40:00',844.884052975248),(130,'2011-03-03 08:45:00',1092.43429574927),(131,'2011-03-03 08:50:00',1332.69303665562),(132,'2011-03-03 08:55:00',1563.07407882707),(133,'2011-03-03 09:00:00',1781.05556744296),(134,'2011-03-03 09:05:00',1984.20738507256),(135,'2011-03-03 09:10:00',2170.21795168938),(136,'2011-03-03 09:15:00',2336.92013640967),(137,'2011-03-03 09:20:00',2482.31599392519),(138,'2011-03-03 09:25:00',2604.60004766573),(139,'2011-03-03 09:30:00',2702.18085387803),(140,'2011-03-03 09:35:00',2773.70059594564),(141,'2011-03-03 09:40:00',2818.05247626913),(142,'2011-03-03 09:45:00',2834.39569371447),(143,'2011-03-03 09:50:00',2822.16781782539),(144,'2011-03-03 09:55:00',2781.09439646192),(145,'2011-03-03 10:00:00',2711.19566102158),(146,'2011-03-03 10:05:00',2612.79022265027),(147,'2011-03-03 10:10:00',2486.49568356023),(148,'2011-03-03 10:15:00',2333.22611943094),(149,'2011-03-03 10:20:00',2154.18642154569),(150,'2011-03-03 10:25:00',1950.86352047135),(151,'2011-03-03 10:30:00',1725.01454637317),(152,'2011-03-03 10:35:00',1478.65201411555),(153,'2011-03-03 10:40:00',1214.02615377967),(154,'2011-03-03 10:45:00',933.604538776763),(155,'2011-03-03 10:50:00',640.049194007169),(156,'2011-03-03 10:55:00',336.191395174265),(157,'2011-03-03 11:00:00',25.0043970878433),(158,'2011-03-03 11:05:00',-290.425646719474),(159,'2011-03-03 11:10:00',-606.930288769922),(160,'2011-03-03 11:15:00',-921.290613328209),(161,'2011-03-03 11:20:00',-1230.26996333251),(162,'2011-03-03 11:25:00',-1530.64723593103),(163,'2011-03-03 11:30:00',-1819.2504043949),(164,'2011-03-03 11:35:00',-2092.98991810127),(165,'2011-03-03 11:40:00',-2348.89162981811),(166,'2011-03-03 11:45:00',-2584.12890073387),(167,'2011-03-03 11:50:00',-2796.05353858595),(168,'2011-03-03 11:55:00',-2982.22523283386),(169,'2011-03-03 12:00:00',-3140.43916304217),(170,'2011-03-03 12:05:00',-3268.75147239049),(171,'2011-03-03 12:10:00',-3365.50231737922),(172,'2011-03-03 12:15:00',-3429.33622718309),(173,'2011-03-03 12:20:00',-3459.21953151262),(174,'2011-03-03 12:25:00',-3454.4546440378),(175,'2011-03-03 12:30:00',-3414.69101913855),(176,'2011-03-03 12:35:00',-3339.9326326718),(177,'2011-03-03 12:40:00',-3230.54187226079),(178,'2011-03-03 12:45:00',-3087.23975896867),(179,'2011-03-03 12:50:00',-2911.10245974813),(180,'2011-03-03 12:55:00',-2703.55408837803),(181,'2011-03-03 13:00:00',-2466.35583131091),(182,'2011-03-03 13:05:00',-2201.59147355887),(183,'2011-03-03 13:10:00',-1911.64943803384),(184,'2011-03-03 13:15:00',-1599.20148922458),(185,'2011-03-03 13:20:00',-1267.17828833757),(186,'2011-03-03 13:25:00',-918.74202166023),(187,'2011-03-03 13:30:00',-557.256356545103),(188,'2011-03-03 13:35:00',-186.254009702661),(189,'2011-03-03 13:40:00',190.597759909746),(190,'2011-03-03 13:45:00',569.533396719219),(191,'2011-03-03 13:50:00',946.726674494907),(192,'2011-03-03 13:55:00',1318.3293266684),(193,'2011-03-03 14:00:00',1680.51029103937),(194,'2011-03-03 14:05:00',2029.49516881186),(195,'2011-03-03 14:10:00',2361.60549190644),(196,'2011-03-03 14:15:00',2673.29739066709),(197,'2011-03-03 14:20:00',2961.19925648746),(198,'2011-03-03 14:25:00',3222.14800052814),(199,'2011-03-03 14:30:00',3453.22352055384),(200,'2011-03-03 14:35:00',3651.78100291051),(201,'2011-03-03 14:40:00',3815.48070566454),(202,'2011-03-03 14:45:00',3942.31489177858),(203,'2011-03-03 14:50:00',4030.63160769378),(204,'2011-03-03 14:55:00',4079.15503258209),(205,'2011-03-03 15:00:00',4087.00215654308),(206,'2011-03-03 15:05:00',4053.6955818287),(207,'2011-03-03 15:10:00',3979.17227943876),(208,'2011-03-03 15:15:00',3863.78817376132),(209,'2011-03-03 15:20:00',3708.31846993403),(210,'2011-03-03 15:25:00',3513.95368185144),(211,'2011-03-03 15:30:00',3282.29136280061),(212,'2011-03-03 15:35:00',3015.32358512137),(213,'2011-03-03 15:40:00',2715.42025960002),(214,'2011-03-03 15:45:00',2385.30842905559),(215,'2011-03-03 15:50:00',2028.04771330504),(216,'2011-03-03 15:55:00',1647.00212394934),(217,'2011-03-03 16:00:00',1245.80850676234),(218,'2011-03-03 16:05:00',828.341906468109),(219,'2011-03-03 16:10:00',398.678182955334),(220,'2011-03-03 16:15:00',-38.9457608777771),(221,'2011-03-03 16:20:00',-480.173751774433),(222,'2011-03-03 16:25:00',-920.573707494009),(223,'2011-03-03 16:30:00',-1355.68215529727),(224,'2011-03-03 16:35:00',-1781.04946038402),(225,'2011-03-03 16:40:00',-2192.28530607229),(226,'2011-03-03 16:45:00',-2585.10396109523),(227,'2011-03-03 16:50:00',-2955.36886772476),(228,'2011-03-03 16:55:00',-3299.13608756176),(229,'2011-03-03 17:00:00',-3612.69614976741),(230,'2011-03-03 17:05:00',-3892.61385920579),(231,'2011-03-03 17:10:00',-4135.76563932693),(232,'2011-03-03 17:15:00',-4339.37400650266),(233,'2011-03-03 17:20:00',-4501.03879874009),(234,'2011-03-03 17:25:00',-4618.76481200464),(235,'2011-03-03 17:30:00',-4690.98553150316),(236,'2011-03-03 17:35:00',-4716.58268288488),(237,'2011-03-03 17:40:00',-4694.90136905252),(238,'2011-03-03 17:45:00',-4625.76060174079),(239,'2011-03-03 17:50:00',-4509.45908278678),(240,'2011-03-03 17:55:00',-4346.77613763179),(241,'2011-03-03 18:00:00',-4138.96775257986),(242,'2011-03-03 18:05:00',-3887.75771719874),(243,'2011-03-03 18:10:00',-3595.32392347856),(244,'2011-03-03 18:15:00',-3264.27992344476),(245,'2011-03-03 18:20:00',-2897.65189633911),(246,'2011-03-03 18:25:00',-2498.85122472186),(247,'2011-03-03 18:30:00',-2071.64292540176),(248,'2011-03-03 18:35:00',-1620.11022547942),(249,'2011-03-03 18:40:00',-1148.61561551843),(250,'2011-03-03 18:45:00',-661.758750488865),(251,'2011-03-03 18:50:00',-164.331604240844),(252,'2011-03-03 18:55:00',338.728685528394),(253,'2011-03-03 19:00:00',842.388817898026),(254,'2011-03-03 19:05:00',1341.5696886331),(255,'2011-03-03 19:10:00',1831.19760551306),(256,'2011-03-03 19:15:00',2306.25584268999),(257,'2011-03-03 19:20:00',2761.83601037327),(258,'2011-03-03 19:25:00',3193.1887141394),(259,'2011-03-03 19:30:00',3595.77298154661),(260,'2011-03-03 19:35:00',3965.30394249393),(261,'2011-03-03 19:40:00',4297.79826385279),(262,'2011-03-03 19:45:00',4589.61685820906),(263,'2011-03-03 19:50:00',4837.50441092222),(264,'2011-03-03 19:55:00',5038.62529892144),(265,'2011-03-03 20:00:00',5190.59550845076),(266,'2011-03-03 20:05:00',5291.5101970301),(267,'2011-03-03 20:10:00',5339.96658685649),(268,'2011-03-03 20:15:00',5335.08192232596),(269,'2011-03-03 20:20:00',5276.50627286892),(270,'2011-03-03 20:25:00',5164.43001338432),(271,'2011-03-03 20:30:00',4999.58586772312),(272,'2011-03-03 20:35:00',4783.24545537994),(273,'2011-03-03 20:40:00',4517.21033725077),(274,'2011-03-03 20:45:00',4203.7976124427),(275,'2011-03-03 20:50:00',3845.82017410304),(276,'2011-03-03 20:55:00',3446.56178749848),(277,'2011-03-03 21:00:00',3009.74720754665),(278,'2011-03-03 21:05:00',2539.50760512171),(279,'2011-03-03 21:10:00',2040.34162117703),(280,'2011-03-03 21:15:00',1517.07241452407),(281,'2011-03-03 21:20:00',974.801112481914),(282,'2011-03-03 21:25:00',418.857113095798),(283,'2011-03-03 21:30:00',-145.254277210767),(284,'2011-03-03 21:35:00',-711.906356227717),(285,'2011-03-03 21:40:00',-1275.40714906474),(286,'2011-03-03 21:45:00',-1830.05658197761),(287,'2011-03-03 21:50:00',-2370.2041326407),(288,'2011-03-03 21:55:00',-2890.30637387851);
/*!40000 ALTER TABLE `chart_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `chart_data_minmax`
--

DROP TABLE IF EXISTS `chart_data_minmax`;
/*!50001 DROP VIEW IF EXISTS `chart_data_minmax`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `chart_data_minmax` (
  `min_value` double,
  `max_value` double
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Final view structure for view `chart_data_minmax`
--

/*!50001 DROP TABLE IF EXISTS `chart_data_minmax`*/;
/*!50001 DROP VIEW IF EXISTS `chart_data_minmax`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `chart_data_minmax` AS select min(`chart_data`.`data`) AS `min_value`,max(`chart_data`.`data`) AS `max_value` from `chart_data` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-03-03  8:49:38