Re: Import of SQL file slow or freezes
Posted by: Craig Eidson
Date: August 17, 2018 05:20PM
Date: August 17, 2018 05:20PM
James, great suggestions. I got pulled away on other projects today but I'll be back on it this weekend.
First 100 lines....
CREATE DATABASE IF NOT EXISTS `my_db` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `my_db`;
-- MySQL dumep 10.13 Distrib 5.7.9, for Win64 (x86_64)
--
-- Host: localhost Database: my_db
-- ------------------------------------------------------
-- Server version 5.6.17-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 `sensor_reading_base`
--
DROP TABLE IF EXISTS `sensor_reading_base`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sensor_reading_base` (
`reading_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`analog_sensor_id` int(11) unsigned DEFAULT NULL,
`UNIX_time` bigint(20) unsigned NOT NULL,
`temp_analog_sensor_id` int(11) unsigned NOT NULL,
`secondary_table_id` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`reading_id`),
UNIQUE KEY `analog_sensor_id_UNIX_time` (`analog_sensor_id`,`UNIX_time`),
KEY `temp_analog_sensor_id` (`temp_analog_sensor_id`),
CONSTRAINT `analog_sensor_id_reading_base` FOREIGN KEY (`analog_sensor_id`) REFERENCES `analog_sensor` (`analog_sensor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=131713295 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sensor_reading_base`
--
LOCK TABLES `sensor_reading_base` WRITE;
/*!40000 ALTER TABLE `sensor_reading_base` DISABLE KEYS */;
INSERT INTO `sensor_reading_base` VALUES (1,1,1341356018,0,1),(2,1,1341356318,0,1),(3,1,1341356618,0,1),(4,1,1341356918,0,1),(5,1,1341357218,0,1),(6,1,1341357518,0,1),(7,1,1341357781,0,1),(8,1,1341358118,0,1),(9,1,1341360781,0,1),(10,1,1341361118,0,1),(11,1,1341361418,0,1),(12,1,1341363218,0,1),(13,1,1341363518,0,1),(14,1,1341363818,0,1),(15,1,1341364118,0,1),(16,1,1341364418,0,1),(17,1,1341364718,0,1),(18,1,1341365018,0,1),(19,1,1341365318,0,1),(20,1,1341366518,0,1),(21,1,1341366818,0,1),(22,1,1341367118,0,1),(23,1,1341367418,0,1),(24,1,1341367718,0,1),(25,1,1341367981,0,1),(26,1,1341368318,0,1),(27,1,1341368618,0,1),(28,1,1341371018,0,1),(29,1,1341371318,0,1),(30,1,1341371618,0,1),(31,1,1341371918,0,1),(32,1,1341372218,0,1),(33,1,1341372481,0,1),(34,1,1341372818,0,1),(35,1,1341373118,0,1),(36,1,1341373418,0,1),(37,1,1341373718,0,1),(38,1,1341374018,0,1),(39,1,1341374318,0,1),(40,1,1341374618,0,1),(41,1,1341374881,0,1),(42,1,1341375218,0,1),(43,1,1341375518,0,1),(44,1,1341375818,0,1),(45,1,1341376118,0,1),(46,1,1341376418,0,1),(47,1,1341376718,0,1),(48,1,1341377018,0,1),(49,1,1341377618,0,1),(50,1,1341377918,0,1),(51,1,1341378218,0,1),(52,1,1341378518,0,1),(53,1,1341378818,0,1),(54,1,1341379118,0,1),(55,1,1341379418,0,1),(56,1,1341380018,0,1),(57,1,1341380318,0,1),(58,1,1341380618,0,1),(59,1,1341380918,0,1),(60,1,1341381218,0,1),(61,1,1341381518,0,1),(62,1,1341381818,0,1),(63,1,1341382418,0,1),(64,1,1341382718,0,1),(65,1,1341383018,0,1),(66,1,1341383318,0,1),(67,1,1341383618,0,1),(68,1,1341383918,0,1),(69,1,1341384218,0,1),(70,1,1341384481,0,1),(71,1,1341384818,0,1),(72,1,1341385118,0,1),(73,1,1341385418,0,1),(74,1,1341385718,0,1),(75,1,1341386018,0,1),(76,1,1341386318,0,1),(77,1,1341386618,0,1),(78,1,1341386881,0,1),(79,1,1341387218,0,1),(80,1,1341387518,0,1),(81,1,1341387818,0,1),(82,1,1341388118,0,1),(83,1,1341388418,0,1),(84,1,1341388718,0,1),(85,1,1341389018,0,1),(86,1,1341389618,0,1),(87,1,1341389918,0,1),(88,1,1341390218,0,1),(89,1,1341390518,0,1),(90,1,1341390818,0,1),(91,1,1341391118,0,1),(92,1,1341391418,0,1),(93,1,1341391718,0,1),(94,1,1341392018,0,1),(95,1,1341392281,0,1),(96,1,1341392618,0,1),(97,1,1341392918,0,1),(98,1,1341393218,0,1),(99,1,1341393518,0,1),(100,1,1341393818,0,1),(101,1,1341394118,0,1),(102,1,1341394418,0,1),(103,1,1341394718,0,1),(104,1,1341395018,0,1),(105,1,1341395318,0,1),(106,1,1341395618,0,1),(107,1,1341395918,0,1),(108,1,1341396218,0,1),(109,1,1341396518,0,1),(110,1,1341396818,0,1),(111,1,1341397118,0,1),(112,1,1341397418,0,1),(113,1,1341397718,0,1),(114,1,1341398018,0,1),(115,1,1341398318,0,1),(116,1,1341398618,0,1),(117,1,1341398918,0,1),(118,1,1341399218,0,1),(119,1,1341399518,0,1),(120,1,1341399818,0,1),(121,1,1341400118,0,1),(122,1,1341400418,0,1),(123,1,1341400718,0,1),(124,1,1341401018,0,1),(125,1,1341401318,0,1),(126,1,1341401618,0,1),(127,1,1341401918,0,1),(128,1,1341402218,0,1),(129,1,1341402518,0,1),(130,1,1341402818,0,1),(131,1,1341403118,0,1),(132,1,1341403418,0,1),(133,1,1341403718,0,1),(134,1,1341404018,0,1),(135,1,1341404318,0,1),(136,1,1341404618,0,1),(137,1,1341404918,0,1),(138,1,1341405218,0,1),(139,1,1341405518,0,1),(140,1,1341405818,0,1),(141,1,1341406118,0,1),(142,1,1341406418,0,1),(143,1,1341406718,0,1),(144,1,1341407318,0,1),(145,1,1341407618,0,1),(146,1,1341407918,0,1),(147,1,1341408218,0,1),(148,1,1341408518,0,1),(149,1,1341408818,0,1),(150,1,1341409118,0,1),(151,1,1341409418,0,1),(152,1,1341409718,0,1),(153,1,1341410018,0,1),(154,1,1341410318,0,1),(155,1,1341410618,0,1),(156,1,1341410918,0,1),(157,1,1341411218,0,1),(158,1,1341411518,0,1),(159,1,1341411818,0,1),(160,1,1341412118,0,1),(161,1,1341412418,0,1),(162,1,1341412718,0,1),(163,1,1341413018,0,1),(164,1,1341413281,0,1),(165,1,1341413618,0,1),(166,1,1341413918,0,1),(167,1,1341414518,0,1),(168,1,1341414818,0,1),(169,1,1341415118,0,1),(170,1,1341415418,0,1),(171,1,1341415718,0,1),(172,1,1341416018,0,1),(173,1,1341416318,0,1),(174,1,1341416618,0,1),(175,1,1341416918,0,1),(176,1,1341417218,0,1),(177,1,1341417518,0,1),(178,1,1341417818,0,1),(179,1,1341418118,0,1),(180,1,1341418418,0,1),(181,1,1341418718,0,1),(182,1,1341419018,0,1),(183,1,1341419318,0,1),(184,1,1341419618,0,1),(185,1,1341419918,0,1),(186,1,1341420218,0,1),(187,1,1341420519,0,1),(188,1,1341420818,0,1),(189,1,1341421118,0,1),(190,1,1341421418,0,1),(191,1,1341421718,0,1),(192,1,1341422018,0,1),(193,1,1341422318,0,1),(194,1,1341422618,0,1),(195,1,1341422918,0,1),(196,1,1341423218,0,1),(197,1,1341423518,0,1),(198,1,1341423818,0,1),(199,1,1341424118,0,1),(200,1,1341424418,0,1),(201,1,1341424718,0,1),(202,1,1341425018,0,1),(203,1,1341425318,0,1),(204,1,1341425618,0,1),(205,1,1341425919,0,1),(206,1,1341426218,0,1),(207,1,1341426518,0,1),(208,1,1341426818,0,1),(209,1,1341427118,0,1),(210,1,1341427418,0,1),(211,1,1341427718,0,1),(212,1,1341428018,0,1),(213,1,1341428319,0,1),(214,1,1341428618,0,1),(215,1,1341428918,0,1),(216,1,1341429218,0,1),(217,1,1341429518,0,1),(218,1,1341429819,0,1),(219,1,1341430119,0,1),(220,1,1341430419,0,1),(221,1,1341430719,0,1),(222,1,1341431018,0,1),(223,1,1341431319,0,1),(224,1,1341431618,0,1),(225,1,1341431918,0,1),(226,1,1341432219,0,1),(227,1,1341432519,0,1),(228,1,1341432819,0,1),(229,1,1341433119,0,1),(230,1,1341433419,0,1),(231,1,1341433719,0,1),(232,1,1341434019,0,1),(233,1,1341434319,0,1),(234,1,1341434619,0,1),(235,1,1341434881,0,1),(236,1,1341435219,0,1),(237,1,1341435519,0,1),(238,1,1341435819,0,1),(239,1,1341436119,0,1),(240,1,1341436419,0,1),(241,1,1341436719,0,1),(242,1,1341437019,0,1),(243,1,1341437281,0,1),(244,1,1341437619,0,1),(245,1,1341437919,0,1),(246,1,1341438219,0,1),(247,1,1341438519,0,1),(248,1,1341438819,0,1),(249,1,1341439119,0,1),(250,1,1341439419,0,1),(251,1,1341439719,0,1),(252,1,1341440019,0,1),(253,1,1341440319,0,1),(254,1,1341440581,0,1),(255,1,1341440919,0,1),(256,1,1341441219,0,1),(257,1,1341441519,0,1),(258,1,1341441819,0,1),(259,1,1341442119,0,1),(260,1,1341442419,0,1),(261,1,1341442719,0,1),(262,1,1341443019,0,1),(263,1,1341443319,0,1),(264,1,1341443619,0,1),(265,1,1341443919,0,1),(266,1,1341444219,0,1),(267,1,1341444519,0,1),(268,1,1341444819,0,1),(269,1,1341445119,0,1),(270,1,1341445419,0,1),(271,1,1341445719,0,1),(272,1,1341446019,0,1),(273,1,1341446281,0,1),(274,1,1341446619,0,1),(275,1,1341446919,0,1),(276,1,1341447219,0,1),(277,1,1341447519,0,1),(278,1,1341447819,0,1),(279,1,1341448119,0,1),(280,1,1341448419,0,1),(281,1,1341448719,0,1),(282,1,1341449019,0,1),(283,1,1341449319,0,1),(284,1,1341449619,0,1),(285,1,1341449919,0,1),(286,1,1341450219,0,1),(287,1,1341450481,0,1),(288,1,1341450819,0,1),(289,1,1341451119,0,1),(290,1,1341451419,0,1),(291,1,1341451719,0,1),(292,1,1341452019,0,1),(293,1,1341452319,0,1),(294,1,1341452619,0,1),(295,1,1341452919,0,1),(296,1,1341453219,0,1),(297,1,1341453519,0,1),(298,1,1341453819,0,1),(299,1,1341454119,0,1),(300,1,1341454419,0,1),(301,1,1341454719,0,1),(302,1,1341455019,0,1),(303,1,1341455319,0,1),(304,1,1341455619,0,1),(305,1,1341455919,0,1),(306,1,1341456219,0,1),(307,1,1341456519,0,1),(308,1,1341456819,0,1),(309,1,1341457081,0,1),(310,1,1341457419,0,1),(311,1,1341457719,0,1),(312,1,1341458019,0,1),(313,1,1341458319,0,1),(314,1,1341458619,0,1),(315,1,1341458919,0,1),(316,1,1341459219,0,1),(317,1,1341459519,0,1),(318,1,1341459819,0,1),(319,1,1341460119,0,1),(320,1,1341460419,0,1),(321,1,1341460719,0,1),(322,1,1341461019,0,1),(323,1,1341461319,0,1),(324,1,1341461619,0,1),(325,1,1341461919,0,1),(326,1,1341462219,0,1),(327,1,1341462519,0,1),(328,1,1341462819,0,1),(329,1,1341463119,0,1),(330,1,1341463419,0,1),(331,1,1341463719,0,1),(332,1,1341464019,0,1),(333,1,1341464319,0,1),(334,1,1341464619,0,1),(335,1,1341464919,0,1),(336,1,1341465219,0,1),(337,1,1341465519,0,1),(338,1,1341465819,0,1),(339,1,1341466119,0,1),(340,1,1341466419,0,1),(341,1,1341466719,0,1),(342,1,1341467019,0,1),(343,1,1341467319,0,1),(344,1,1341467619,0,1),(345,1,1341467919,0,1),(346,1,1341468219,0,1),(347,1,1341468519,0,1),(348,1,1341468819,0,1),(349,1,1341469119,0,1),(350,1,1341469419,0,1),(351,1,1341469719,0,1),(352,1,1341469981,0,1),(353,1,1341470319,0,1),(354,1,1341470619,0,1),(355,1,1341470919,0,1),(356,1,1341471219,0,1),(357,1,1341471519,0,1),(358,1,1341471819,0,1),(359,1,1341472119,0,1),(360,1,1341472419,0,1),(361,1,1341472719,0,1),(362,1,1341473019,0,1),(363,1,1341473319,0,1),(364,1,1341473619,0,1),(365,1,1341473919,0,1),(366,1,1341474219,0,1),(367,1,1341474519,0,1),(368,1,1341474819,0,1),(369,1,1341475119,0,1),(370,1,1341475419,0,1),(371,1,1341475719,0,1),(372,1,1341476019,0,1),(373,1,1341476319,0,1),(374,1,1341476619,0,1),(375,1,1341476919,0,1),(376,1,1341477219,0,1),(377,1,1341477519,0,1),(378,1,1341477819,0,1),(379,1,1341478119,0,1),(380,1,1341478419,0,1),(381,1,1341478719,0,1),(382,1,1341479019,0,1),(383,1,1341479319,0,1),(384,1,1341479619,0,1),(385,1,1341479919,0,1),(386,1,1341480219,0,1),(387,1,1341480519,0,1),(388,1,1341480819,0,1),(389,1,1341481119,0,1),(390,1,1341481419,0,1),(391,1,1341481719,0,1),(392,1,1341482019,0,1),(393,1,1341482619,0,1),(394,1,1341482919,0,1),(395,1,1341483219,0,1),(396,1,1341483519,0,1),(397,1,1341483819,0,1),(398,1,1341484119,0,1),(399,1,1341484419,0,1),(400,1,1341485019,0,1),(401,1,1341485319,0,1),(402,1,1341485619,0,1),(403,1,1341485919,0,1),(404,1,1341486219,0,1),(405,1,1341486519,0,1),(406,1,1341486819,0,1),(407,1,1341487419,0,1),(408,1,1341487681,0,1),(409,1,1341488019,0,1),(410,1,1341488319,0,1),(411,1,1341488619,0,1),(412,1,1341488919,0,1),(413,1,1341489219,0,1),(414,1,1341489819,0,1),(415,1,1341490119,0,1),(416,1,1341490419,0,1),(417,1,1341490719,0,1),(418,1,1341491019,0,1),(419,1,1341491319,0,1),(420,1,1341491619,0,1),(421,1,1341491919,0,1),(422,1,1341492219,0,1),(423,1,1341492519,0,1),(424,1,1341492819,0,1),(425,1,1341493119,0,1),(426,1,1341493419,0,1),(427,1,1341493719,0,1),(428,1,1341494019,0,1),(429,1,1341494319,0,1),(430,1,1341494619,0,1),(431,1,1341494919,0,1),(432,1,1341495219,0,1),(433,1,1341495519,0,1),(434,1,1341495819,0,1),(435,1,1341496119,0,1),(436,1,1341496419,0,1),(437,1,1341496719,0,1),(438,1,1341497019,0,1),(439,1,1341497319,0,1),(440,1,1341497619,0,1),(441,1,1341497919,0,1),(442,1,1341498219,0,1),(443,1,1341498481,0,1),(444,1,1341498819,0,1),(445,2,1341356025,0,1),(446,2,1341356288,0,1),(447,2,1341356625,0,1),(448,2,1341356925,0,1),(449,2,1341357225,0,1),(450,2,1341357525,0,1),(451,2,1341357825,0,1),(452,2,1341358125,0,1),(453,2,1341360825,0,1),(454,2,1341361125,0,1),(455,2,1341361425,0,1),(456,2,1341362925,0,1),(457,2,1341363225,0,1),(458,2,1341363525,0,1),(459,2,1341363825,0,1),(460,2,1341364125,0,1),(461,2,1341364425,0,1),(462,2,1341364725,0,1),(463,2,1341365025,0,1),(464,2,1341366488,0,1),(465,2,1341366825,0,1),(466,2,1341367125,0,1),(467,2,1341367425,0,1),(468,2,1341367725,0,1),(469,2,1341368025,0,1),(470,2,1341368325,0,1),(471,2,1341368625,0,1),(472,2,1341371025,0,1),(473,2,1341371325,0,1),(474,2,1341371625,0,1),(475,2,1341371925,0,1),(476,2,1341372225,0,1),(477,2,1341372525,0,1),(478,2,1341372825,0,1),(479,2,1341373125,0,1),(480,2,1341373425,0,1),(481,2,1341373725,0,1),(482,2,1341374025,0,1),(483,2,1341374325,0,1),(484,2,1341374625,0,1),(485,2,1341374925,0,1),(486,2,1341375225,0,1),(487,2,1341375525,0,1),(488,2,1341375825,0,1),(489,2,1341376125,0,1),(490,2,1341376425,0,1),(491,2,1341376725,0,1),(492,2,1341377025,0,1),(493,2,1341377325,0,1),(494,2,1341377588,0,1),(495,2,1341377925,0,1),(496,2,1341378225,0,1),(497,2,1341378525,0,1),(498,2,1341378825,0,1),(499,2,1341379125,0,1),(500,2,1341379425,0,1),(501,2,1341379725,0,1),(502,2,1341380025,0,1),(503,2,1341380325,0,1),(504,2,1341380625,0,1),(505,2,1341380925,0,1),(506,2,1341381225,0,1),(507,2,1341381525,0,1),(508,2,1341381825,0,1),(509,2,1341382125,0,1),(510,2,1341382388,0,1),(511,2,1341382725,0,1),(512,2,1341383025,0,1),(513,2,1341383325,0,1),(514,2,1341383625,0,1),(515,2,1341383925,0,1),(516,2,1341384225,0,1),(517,2,1341384525,0,1),(518,2,1341384825,0,1),(519,2,1341385125,0,1),(520,2,1341385425,0,1),(521,2,1341385725,0,1),(522,2,1341386025,0,1),(523,2,1341386325,0,1),(524,2,1341386625,0,1),(525,2,1341386925,0,1),(526,2,1341387225,0,1),(527,2,1341387525,0,1),(528,2,1341387825,0,1),(529,2,1341388125,0,1),(530,2,1341388425,0,1),(531,2,1341388725,0,1),(532,2,1341389025,0,1),(533,2,1341389325,0,1),(534,2,1341389625,0,1),(535,2,1341389925,0,1),(536,2,1341390225,0,1),(537,2,1341390525,0,1),(538,2,1341390825,0,1),(539,2,1341391125,0,1),(540,2,1341391425,0,1),(541,2,1341391725,0,1),(542,2,1341392025,0,1),(543,2,1341392325,0,1),(544,2,1341392625,0,1),(545,2,1341392925,0,1),(546,2,1341393225,0,1),(547,2,1341393525,0,1),(548,2,1341393825,0,1),(549,2,1341394125,0,1),(550,2,1341394425,0,1),(551,2,1341394725,0,1),(552,2,1341395025,0,1),(553,2,1341395325,0,1),(554,2,1341395625,0,1),(555,2,1341395925,0,1),(556,2,1341396225,0,1),(557,2,1341396525,0,1),(558,2,1341396825,0,1),(559,2,1341397125,0,1),(560,2,1341397425,0,1),(561,2,1341397725,0,1),(562,2,1341398025,0,1),(563,2,1341398325,0,1),(564,2,1341398625,0,1),(565,2,1341398925,0,1),(566,2,1341399225,0,1),(567,2,1341399525,0,1),(568,2,1341399825,0,1),(569,2,1341400125,0,1),(570,2,1341400425,0,1),(571,2,1341400725,0,1),(572,2,1341401025,0,1),(573,2,1341401325,0,1),(574,2,1341401625,0,1),(575,2,1341401925,0,1),(576,2,1341402225,0,1),(577,2,1341402525,0,1),(578,2,1341402825,0,1),(579,2,1341403125,0,1),(580,2,1341403425,0,1),(581,2,1341403725,0,1),(582,2,1341404025,0,1),(583,2,1341404325,0,1),(584,2,1341404625,0,1),(585,2,1341404925,0,1),(586,2,1341405225,0,1),(587,2,1341405525,0,1),(588,2,1341405825,0,1),(589,2,1341406125,0,1),(590,2,1341406425,0,1),(591,2,1341406725,0,1),(592,2,1341407025,0,1),(593,2,1341407325,0,1),(594,2,1341407625,0,1),(595,2,1341407925,0,1),(596,2,1341408225,0,1),(597,2,1341408525,0,1),(598,2,1341408825,0,1),(599,2,1341409125,0,1),(600,2,1341409425,0,1),(601,2,1341409725,0,1),(602,2,1341410025,0,1),(603,2,1341410325,0,1),(604,2,1341410625,0,1),(605,2,1341410925,0,1),(606,2,1341411225,0,1),(607,2,1341411525,0,1),(608,2,1341411825,0,1),(609,2,1341412125,0,1),(610,2,1341412425,0,1),(611,2,1341412725,0,1),(612,2,1341413025,0,1),(613,2,1341413325,0,1),(614,2,1341413625,0,1),(615,2,1341413925,0,1),(616,2,1341414225,0,1),(617,2,1341414525,0,1),(618,2,1341414825,0,1),(619,2,1341415088,0,1),(620,2,1341415425,0,1),(621,2,1341415725,0,1),(622,2,1341416025,0,1),(623,2,1341416325,0,1),(624,2,1341416625,0,1),(625,2,1341416925,0,1),(626,2,1341417225,0,1),(627,2,1341417525,0,1),(628,2,1341417825,0,1),(629,2,1341418125,0,1),(630,2,1341418425,0,1),(631,2,1341418725,0,1),(632,2,1341419025,0,1),(633,2,1341419325,0,1),(634,2,1341419625,0,1),(635,2,1341419925,0,1),(636,2,1341420225,0,1),(637,2,1341420525,0,1),(638,2,1341420825,0,1),(639,2,1341421125,0,1),(640,2,1341421425,0,1),(641,2,1341421725,0,1),(642,2,1341422025,0,1),(643,2,1341422325,0,1),(644,2,1341422625,0,1),(645,2,1341422925,0,1),(646,2,1341423225,0,1),(647,2,1341423525,0,1),(648,2,1341423825,0,1),(649,2,1341424125,0,1),(650,2,1341424425,0,1),(651,2,1341424725,0,1),(652,2,1341425025,0,1),(653,2,1341425325,0,1),(654,2,1341425625,0,1),(655,2,1341425925,0,1),(656,2,1341426225,0,1),(657,2,1341426525,0,1),(658,2,1341426825,0,1),(659,2,1341427125,0,1),(660,2,1341427425,0,1),(661,2,1341427725,0,1),(662,2,1341428025,0,1),(663,2,1341428325,0,1),(664,2,1341428625,0,1),(665,2,1341428925,0,1),(666,2,1341429225,0,1),(667,2,1341429525,0,1),(668,2,1341429825,0,1),(669,2,1341430125,0,1),(670,2,1341430425,0,1),(671,2,1341430725,0,1),(672,2,1341431025,0,1),(673,2,1341431325,0,1),(674,2,1341431625,0,1),(675,2,1341431925,0,1),(676,2,1341432225,0,1),(677,2,1341432525,0,1),(678,2,1341432825,0,1),(679,2,1341433125,0,1),(680,2,1341433425,0,1),(681,2,1341433725,0,1),(682,2,1341434025,0,1),(683,2,1341434325,0,1),(684,2,1341434625,0,1),(685,2,1341434925,0,1),(686,2,1341435225,0,1),(687,2,1341435525,0,1),(688,2,1341435825,0,1),(689,2,1341436125,0,1),(690,2,1341436425,0,1),(691,2,1341436725,0,1),(692,2,1341437025,0,1),(693,2,1341437325,0,1),(694,2,1341437625,0,1),(695,2,1341437925,0,1),(696,2,1341438225,0,1),(697,2,1341438525,0,1),(698,2,1341438825,0,1),(699,2,1341439125,0,1),(700,2,1341439425,0,1),(701,2,1341439725,0,1),(702,2,1341440025,0,1),(703,2,1341440325,0,1),(704,2,1341440625,0,1),(705,2,1341440925,0,1),(706,2,1341441225,0,1),(707,2,1341441525,0,1),(708,2,1341441825,0,1),(709,2,1341442125,0,1),(710,2,1341442425,0,1),(711,2,1341442725,0,1),(712,2,1341443025,0,1),(713,2,1341443325,0,1),(714,2,1341443625,0,1),(715,2,1341443925,0,1),(716,2,1341444225,0,1),(717,2,1341444525,0,1),(718,2,1341444825,0,1),(719,2,1341445125,0,1),(720,2,1341445425,0,1),(721,2,1341445725,0,1),(722,2,1341446025,0,1),(723,2,1341446325,0,1),(724,2,1341446625,0,1),(725,2,1341446925,0,1),(726,2,1341447225,0,1),(727,2,1341447525,0,1),(728,2,1341447825,0,1),(729,2,1341448088,0,1),(730,2,1341448425,0,1),(731,2,1341448725,0,1),(732,2,1341449025,0,1),(733,2,1341449325,0,1),(734,2,1341449625,0,1),(735,2,1341449925,0,1),(736,2,1341450225,0,1),(737,2,1341450525,0,1),(738,2,1341450825,0,1),(739,2,1341451125,0,1),(740,2,1341451425,0,1),(741,2,1341451725,0,1),(742,2,1341452025,0,1),(743,2,1341452325,0,1),(744,2,1341452625,0,1),(745,2,1341452925,0,1),(746,2,1341453225,0,1),(747,2,1341453525,0,1),(748,2,1341453825,0,1),(749,2,1341454125,0,1),(750,2,1341454425,0,1),(751,2,1341454725,0,1),(752,2,1341455025,0,1),(753,2,1341455325,0,1),(754,2,1341455625,0,1),(755,2,1341455925,0,1),(756,2,1341456225,0,1),(757,2,1341456525,0,1),(758,2,1341456825,0,1),(759,2,1341457125,0,1),(760,2,1341457425,0,1),(761,2,1341457725,0,1),(762,2,1341458025,0,1),(763,2,1341458325,0,1),(764,2,1341458625,0,1),(765,2,1341458925,0,1),(766,2,1341459225,0,1),(767,2,1341459525,0,1),(768,2,1341459825,0,1),(769,2,1341460125,0,1),(770,2,1341460425,0,1),(771,2,1341460725,0,1),(772,2,1341461025,0,1),(773,2,1341461325,0,1),(774,2,1341461625,0,1),(775,2,1341461925,0,1),(776,2,1341462225,0,1),(777,2,1341462525,0,1),(778,2,1341462825,0,1),(779,2,1341463125,0,1),(780,2,1341463425,0,1),(781,2,1341463725,0,1),(782,2,1341464025,0,1),(783,2,1341464325,0,1),(784,2,1341464625,0,1),(785,2,1341464925,0,1),(786,2,1341465225,0,1),(787,2,1341465525,0,1),(788,2,1341465825,0,1),(789,2,1341466125,0,1),(790,2,1341466425,0,1),(791,2,1341466725,0,1),(792,2,1341467025,0,1),(793,2,1341467325,0,1),(794,2,1341467625,0,1),(795,2,1341467925,0,1),(796,2,1341468225,0,1),(797,2,1341468525,0,1),(798,2,1341468825,0,1),(799,2,1341469125,0,1),(800,2,1341469425,0,1),(801,2,1341469725,0,1),(802,2,1341470025,0,1),(803,2,1341470325,0,1),(804,2,1341470625,0,1),(805,2,1341470925,0,1),(806,2,1341471225,0,1),(807,2,1341471525,0,1),(808,2,1341471825,0,1),(809,2,1341472125,0,1),(810,2,1341472425,0,1),(811,2,1341472725,0,1),(812,2,1341473025,0,1),(813,2,1341473325,0,1),(814,2,1341473625,0,1),(815,2,1341473925,0,1),(816,2,1341474225,0,1),(817,2,1341474525,0,1),(818,2,1341474825,0,1),(819,2,1341475125,0,1),(820,2,1341475425,0,1),(821,2,1341475725,0,1),(822,2,1341476025,0,1),(823,2,1341476325,0,1),(824,2,1341476625,0,1),(825,2,1341476925,0,1),(826,2,1341477225,0,1),(827,2,1341477488,0,1),(828,2,1341477825,0,1),(829,2,1341478125,0,1),(830,2,1341478425,0,1),(831,2,1341478725,0,1),....
First 100 lines....
CREATE DATABASE IF NOT EXISTS `my_db` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `my_db`;
-- MySQL dumep 10.13 Distrib 5.7.9, for Win64 (x86_64)
--
-- Host: localhost Database: my_db
-- ------------------------------------------------------
-- Server version 5.6.17-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 `sensor_reading_base`
--
DROP TABLE IF EXISTS `sensor_reading_base`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sensor_reading_base` (
`reading_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`analog_sensor_id` int(11) unsigned DEFAULT NULL,
`UNIX_time` bigint(20) unsigned NOT NULL,
`temp_analog_sensor_id` int(11) unsigned NOT NULL,
`secondary_table_id` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`reading_id`),
UNIQUE KEY `analog_sensor_id_UNIX_time` (`analog_sensor_id`,`UNIX_time`),
KEY `temp_analog_sensor_id` (`temp_analog_sensor_id`),
CONSTRAINT `analog_sensor_id_reading_base` FOREIGN KEY (`analog_sensor_id`) REFERENCES `analog_sensor` (`analog_sensor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=131713295 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sensor_reading_base`
--
LOCK TABLES `sensor_reading_base` WRITE;
/*!40000 ALTER TABLE `sensor_reading_base` DISABLE KEYS */;
INSERT INTO `sensor_reading_base` VALUES (1,1,1341356018,0,1),(2,1,1341356318,0,1),(3,1,1341356618,0,1),(4,1,1341356918,0,1),(5,1,1341357218,0,1),(6,1,1341357518,0,1),(7,1,1341357781,0,1),(8,1,1341358118,0,1),(9,1,1341360781,0,1),(10,1,1341361118,0,1),(11,1,1341361418,0,1),(12,1,1341363218,0,1),(13,1,1341363518,0,1),(14,1,1341363818,0,1),(15,1,1341364118,0,1),(16,1,1341364418,0,1),(17,1,1341364718,0,1),(18,1,1341365018,0,1),(19,1,1341365318,0,1),(20,1,1341366518,0,1),(21,1,1341366818,0,1),(22,1,1341367118,0,1),(23,1,1341367418,0,1),(24,1,1341367718,0,1),(25,1,1341367981,0,1),(26,1,1341368318,0,1),(27,1,1341368618,0,1),(28,1,1341371018,0,1),(29,1,1341371318,0,1),(30,1,1341371618,0,1),(31,1,1341371918,0,1),(32,1,1341372218,0,1),(33,1,1341372481,0,1),(34,1,1341372818,0,1),(35,1,1341373118,0,1),(36,1,1341373418,0,1),(37,1,1341373718,0,1),(38,1,1341374018,0,1),(39,1,1341374318,0,1),(40,1,1341374618,0,1),(41,1,1341374881,0,1),(42,1,1341375218,0,1),(43,1,1341375518,0,1),(44,1,1341375818,0,1),(45,1,1341376118,0,1),(46,1,1341376418,0,1),(47,1,1341376718,0,1),(48,1,1341377018,0,1),(49,1,1341377618,0,1),(50,1,1341377918,0,1),(51,1,1341378218,0,1),(52,1,1341378518,0,1),(53,1,1341378818,0,1),(54,1,1341379118,0,1),(55,1,1341379418,0,1),(56,1,1341380018,0,1),(57,1,1341380318,0,1),(58,1,1341380618,0,1),(59,1,1341380918,0,1),(60,1,1341381218,0,1),(61,1,1341381518,0,1),(62,1,1341381818,0,1),(63,1,1341382418,0,1),(64,1,1341382718,0,1),(65,1,1341383018,0,1),(66,1,1341383318,0,1),(67,1,1341383618,0,1),(68,1,1341383918,0,1),(69,1,1341384218,0,1),(70,1,1341384481,0,1),(71,1,1341384818,0,1),(72,1,1341385118,0,1),(73,1,1341385418,0,1),(74,1,1341385718,0,1),(75,1,1341386018,0,1),(76,1,1341386318,0,1),(77,1,1341386618,0,1),(78,1,1341386881,0,1),(79,1,1341387218,0,1),(80,1,1341387518,0,1),(81,1,1341387818,0,1),(82,1,1341388118,0,1),(83,1,1341388418,0,1),(84,1,1341388718,0,1),(85,1,1341389018,0,1),(86,1,1341389618,0,1),(87,1,1341389918,0,1),(88,1,1341390218,0,1),(89,1,1341390518,0,1),(90,1,1341390818,0,1),(91,1,1341391118,0,1),(92,1,1341391418,0,1),(93,1,1341391718,0,1),(94,1,1341392018,0,1),(95,1,1341392281,0,1),(96,1,1341392618,0,1),(97,1,1341392918,0,1),(98,1,1341393218,0,1),(99,1,1341393518,0,1),(100,1,1341393818,0,1),(101,1,1341394118,0,1),(102,1,1341394418,0,1),(103,1,1341394718,0,1),(104,1,1341395018,0,1),(105,1,1341395318,0,1),(106,1,1341395618,0,1),(107,1,1341395918,0,1),(108,1,1341396218,0,1),(109,1,1341396518,0,1),(110,1,1341396818,0,1),(111,1,1341397118,0,1),(112,1,1341397418,0,1),(113,1,1341397718,0,1),(114,1,1341398018,0,1),(115,1,1341398318,0,1),(116,1,1341398618,0,1),(117,1,1341398918,0,1),(118,1,1341399218,0,1),(119,1,1341399518,0,1),(120,1,1341399818,0,1),(121,1,1341400118,0,1),(122,1,1341400418,0,1),(123,1,1341400718,0,1),(124,1,1341401018,0,1),(125,1,1341401318,0,1),(126,1,1341401618,0,1),(127,1,1341401918,0,1),(128,1,1341402218,0,1),(129,1,1341402518,0,1),(130,1,1341402818,0,1),(131,1,1341403118,0,1),(132,1,1341403418,0,1),(133,1,1341403718,0,1),(134,1,1341404018,0,1),(135,1,1341404318,0,1),(136,1,1341404618,0,1),(137,1,1341404918,0,1),(138,1,1341405218,0,1),(139,1,1341405518,0,1),(140,1,1341405818,0,1),(141,1,1341406118,0,1),(142,1,1341406418,0,1),(143,1,1341406718,0,1),(144,1,1341407318,0,1),(145,1,1341407618,0,1),(146,1,1341407918,0,1),(147,1,1341408218,0,1),(148,1,1341408518,0,1),(149,1,1341408818,0,1),(150,1,1341409118,0,1),(151,1,1341409418,0,1),(152,1,1341409718,0,1),(153,1,1341410018,0,1),(154,1,1341410318,0,1),(155,1,1341410618,0,1),(156,1,1341410918,0,1),(157,1,1341411218,0,1),(158,1,1341411518,0,1),(159,1,1341411818,0,1),(160,1,1341412118,0,1),(161,1,1341412418,0,1),(162,1,1341412718,0,1),(163,1,1341413018,0,1),(164,1,1341413281,0,1),(165,1,1341413618,0,1),(166,1,1341413918,0,1),(167,1,1341414518,0,1),(168,1,1341414818,0,1),(169,1,1341415118,0,1),(170,1,1341415418,0,1),(171,1,1341415718,0,1),(172,1,1341416018,0,1),(173,1,1341416318,0,1),(174,1,1341416618,0,1),(175,1,1341416918,0,1),(176,1,1341417218,0,1),(177,1,1341417518,0,1),(178,1,1341417818,0,1),(179,1,1341418118,0,1),(180,1,1341418418,0,1),(181,1,1341418718,0,1),(182,1,1341419018,0,1),(183,1,1341419318,0,1),(184,1,1341419618,0,1),(185,1,1341419918,0,1),(186,1,1341420218,0,1),(187,1,1341420519,0,1),(188,1,1341420818,0,1),(189,1,1341421118,0,1),(190,1,1341421418,0,1),(191,1,1341421718,0,1),(192,1,1341422018,0,1),(193,1,1341422318,0,1),(194,1,1341422618,0,1),(195,1,1341422918,0,1),(196,1,1341423218,0,1),(197,1,1341423518,0,1),(198,1,1341423818,0,1),(199,1,1341424118,0,1),(200,1,1341424418,0,1),(201,1,1341424718,0,1),(202,1,1341425018,0,1),(203,1,1341425318,0,1),(204,1,1341425618,0,1),(205,1,1341425919,0,1),(206,1,1341426218,0,1),(207,1,1341426518,0,1),(208,1,1341426818,0,1),(209,1,1341427118,0,1),(210,1,1341427418,0,1),(211,1,1341427718,0,1),(212,1,1341428018,0,1),(213,1,1341428319,0,1),(214,1,1341428618,0,1),(215,1,1341428918,0,1),(216,1,1341429218,0,1),(217,1,1341429518,0,1),(218,1,1341429819,0,1),(219,1,1341430119,0,1),(220,1,1341430419,0,1),(221,1,1341430719,0,1),(222,1,1341431018,0,1),(223,1,1341431319,0,1),(224,1,1341431618,0,1),(225,1,1341431918,0,1),(226,1,1341432219,0,1),(227,1,1341432519,0,1),(228,1,1341432819,0,1),(229,1,1341433119,0,1),(230,1,1341433419,0,1),(231,1,1341433719,0,1),(232,1,1341434019,0,1),(233,1,1341434319,0,1),(234,1,1341434619,0,1),(235,1,1341434881,0,1),(236,1,1341435219,0,1),(237,1,1341435519,0,1),(238,1,1341435819,0,1),(239,1,1341436119,0,1),(240,1,1341436419,0,1),(241,1,1341436719,0,1),(242,1,1341437019,0,1),(243,1,1341437281,0,1),(244,1,1341437619,0,1),(245,1,1341437919,0,1),(246,1,1341438219,0,1),(247,1,1341438519,0,1),(248,1,1341438819,0,1),(249,1,1341439119,0,1),(250,1,1341439419,0,1),(251,1,1341439719,0,1),(252,1,1341440019,0,1),(253,1,1341440319,0,1),(254,1,1341440581,0,1),(255,1,1341440919,0,1),(256,1,1341441219,0,1),(257,1,1341441519,0,1),(258,1,1341441819,0,1),(259,1,1341442119,0,1),(260,1,1341442419,0,1),(261,1,1341442719,0,1),(262,1,1341443019,0,1),(263,1,1341443319,0,1),(264,1,1341443619,0,1),(265,1,1341443919,0,1),(266,1,1341444219,0,1),(267,1,1341444519,0,1),(268,1,1341444819,0,1),(269,1,1341445119,0,1),(270,1,1341445419,0,1),(271,1,1341445719,0,1),(272,1,1341446019,0,1),(273,1,1341446281,0,1),(274,1,1341446619,0,1),(275,1,1341446919,0,1),(276,1,1341447219,0,1),(277,1,1341447519,0,1),(278,1,1341447819,0,1),(279,1,1341448119,0,1),(280,1,1341448419,0,1),(281,1,1341448719,0,1),(282,1,1341449019,0,1),(283,1,1341449319,0,1),(284,1,1341449619,0,1),(285,1,1341449919,0,1),(286,1,1341450219,0,1),(287,1,1341450481,0,1),(288,1,1341450819,0,1),(289,1,1341451119,0,1),(290,1,1341451419,0,1),(291,1,1341451719,0,1),(292,1,1341452019,0,1),(293,1,1341452319,0,1),(294,1,1341452619,0,1),(295,1,1341452919,0,1),(296,1,1341453219,0,1),(297,1,1341453519,0,1),(298,1,1341453819,0,1),(299,1,1341454119,0,1),(300,1,1341454419,0,1),(301,1,1341454719,0,1),(302,1,1341455019,0,1),(303,1,1341455319,0,1),(304,1,1341455619,0,1),(305,1,1341455919,0,1),(306,1,1341456219,0,1),(307,1,1341456519,0,1),(308,1,1341456819,0,1),(309,1,1341457081,0,1),(310,1,1341457419,0,1),(311,1,1341457719,0,1),(312,1,1341458019,0,1),(313,1,1341458319,0,1),(314,1,1341458619,0,1),(315,1,1341458919,0,1),(316,1,1341459219,0,1),(317,1,1341459519,0,1),(318,1,1341459819,0,1),(319,1,1341460119,0,1),(320,1,1341460419,0,1),(321,1,1341460719,0,1),(322,1,1341461019,0,1),(323,1,1341461319,0,1),(324,1,1341461619,0,1),(325,1,1341461919,0,1),(326,1,1341462219,0,1),(327,1,1341462519,0,1),(328,1,1341462819,0,1),(329,1,1341463119,0,1),(330,1,1341463419,0,1),(331,1,1341463719,0,1),(332,1,1341464019,0,1),(333,1,1341464319,0,1),(334,1,1341464619,0,1),(335,1,1341464919,0,1),(336,1,1341465219,0,1),(337,1,1341465519,0,1),(338,1,1341465819,0,1),(339,1,1341466119,0,1),(340,1,1341466419,0,1),(341,1,1341466719,0,1),(342,1,1341467019,0,1),(343,1,1341467319,0,1),(344,1,1341467619,0,1),(345,1,1341467919,0,1),(346,1,1341468219,0,1),(347,1,1341468519,0,1),(348,1,1341468819,0,1),(349,1,1341469119,0,1),(350,1,1341469419,0,1),(351,1,1341469719,0,1),(352,1,1341469981,0,1),(353,1,1341470319,0,1),(354,1,1341470619,0,1),(355,1,1341470919,0,1),(356,1,1341471219,0,1),(357,1,1341471519,0,1),(358,1,1341471819,0,1),(359,1,1341472119,0,1),(360,1,1341472419,0,1),(361,1,1341472719,0,1),(362,1,1341473019,0,1),(363,1,1341473319,0,1),(364,1,1341473619,0,1),(365,1,1341473919,0,1),(366,1,1341474219,0,1),(367,1,1341474519,0,1),(368,1,1341474819,0,1),(369,1,1341475119,0,1),(370,1,1341475419,0,1),(371,1,1341475719,0,1),(372,1,1341476019,0,1),(373,1,1341476319,0,1),(374,1,1341476619,0,1),(375,1,1341476919,0,1),(376,1,1341477219,0,1),(377,1,1341477519,0,1),(378,1,1341477819,0,1),(379,1,1341478119,0,1),(380,1,1341478419,0,1),(381,1,1341478719,0,1),(382,1,1341479019,0,1),(383,1,1341479319,0,1),(384,1,1341479619,0,1),(385,1,1341479919,0,1),(386,1,1341480219,0,1),(387,1,1341480519,0,1),(388,1,1341480819,0,1),(389,1,1341481119,0,1),(390,1,1341481419,0,1),(391,1,1341481719,0,1),(392,1,1341482019,0,1),(393,1,1341482619,0,1),(394,1,1341482919,0,1),(395,1,1341483219,0,1),(396,1,1341483519,0,1),(397,1,1341483819,0,1),(398,1,1341484119,0,1),(399,1,1341484419,0,1),(400,1,1341485019,0,1),(401,1,1341485319,0,1),(402,1,1341485619,0,1),(403,1,1341485919,0,1),(404,1,1341486219,0,1),(405,1,1341486519,0,1),(406,1,1341486819,0,1),(407,1,1341487419,0,1),(408,1,1341487681,0,1),(409,1,1341488019,0,1),(410,1,1341488319,0,1),(411,1,1341488619,0,1),(412,1,1341488919,0,1),(413,1,1341489219,0,1),(414,1,1341489819,0,1),(415,1,1341490119,0,1),(416,1,1341490419,0,1),(417,1,1341490719,0,1),(418,1,1341491019,0,1),(419,1,1341491319,0,1),(420,1,1341491619,0,1),(421,1,1341491919,0,1),(422,1,1341492219,0,1),(423,1,1341492519,0,1),(424,1,1341492819,0,1),(425,1,1341493119,0,1),(426,1,1341493419,0,1),(427,1,1341493719,0,1),(428,1,1341494019,0,1),(429,1,1341494319,0,1),(430,1,1341494619,0,1),(431,1,1341494919,0,1),(432,1,1341495219,0,1),(433,1,1341495519,0,1),(434,1,1341495819,0,1),(435,1,1341496119,0,1),(436,1,1341496419,0,1),(437,1,1341496719,0,1),(438,1,1341497019,0,1),(439,1,1341497319,0,1),(440,1,1341497619,0,1),(441,1,1341497919,0,1),(442,1,1341498219,0,1),(443,1,1341498481,0,1),(444,1,1341498819,0,1),(445,2,1341356025,0,1),(446,2,1341356288,0,1),(447,2,1341356625,0,1),(448,2,1341356925,0,1),(449,2,1341357225,0,1),(450,2,1341357525,0,1),(451,2,1341357825,0,1),(452,2,1341358125,0,1),(453,2,1341360825,0,1),(454,2,1341361125,0,1),(455,2,1341361425,0,1),(456,2,1341362925,0,1),(457,2,1341363225,0,1),(458,2,1341363525,0,1),(459,2,1341363825,0,1),(460,2,1341364125,0,1),(461,2,1341364425,0,1),(462,2,1341364725,0,1),(463,2,1341365025,0,1),(464,2,1341366488,0,1),(465,2,1341366825,0,1),(466,2,1341367125,0,1),(467,2,1341367425,0,1),(468,2,1341367725,0,1),(469,2,1341368025,0,1),(470,2,1341368325,0,1),(471,2,1341368625,0,1),(472,2,1341371025,0,1),(473,2,1341371325,0,1),(474,2,1341371625,0,1),(475,2,1341371925,0,1),(476,2,1341372225,0,1),(477,2,1341372525,0,1),(478,2,1341372825,0,1),(479,2,1341373125,0,1),(480,2,1341373425,0,1),(481,2,1341373725,0,1),(482,2,1341374025,0,1),(483,2,1341374325,0,1),(484,2,1341374625,0,1),(485,2,1341374925,0,1),(486,2,1341375225,0,1),(487,2,1341375525,0,1),(488,2,1341375825,0,1),(489,2,1341376125,0,1),(490,2,1341376425,0,1),(491,2,1341376725,0,1),(492,2,1341377025,0,1),(493,2,1341377325,0,1),(494,2,1341377588,0,1),(495,2,1341377925,0,1),(496,2,1341378225,0,1),(497,2,1341378525,0,1),(498,2,1341378825,0,1),(499,2,1341379125,0,1),(500,2,1341379425,0,1),(501,2,1341379725,0,1),(502,2,1341380025,0,1),(503,2,1341380325,0,1),(504,2,1341380625,0,1),(505,2,1341380925,0,1),(506,2,1341381225,0,1),(507,2,1341381525,0,1),(508,2,1341381825,0,1),(509,2,1341382125,0,1),(510,2,1341382388,0,1),(511,2,1341382725,0,1),(512,2,1341383025,0,1),(513,2,1341383325,0,1),(514,2,1341383625,0,1),(515,2,1341383925,0,1),(516,2,1341384225,0,1),(517,2,1341384525,0,1),(518,2,1341384825,0,1),(519,2,1341385125,0,1),(520,2,1341385425,0,1),(521,2,1341385725,0,1),(522,2,1341386025,0,1),(523,2,1341386325,0,1),(524,2,1341386625,0,1),(525,2,1341386925,0,1),(526,2,1341387225,0,1),(527,2,1341387525,0,1),(528,2,1341387825,0,1),(529,2,1341388125,0,1),(530,2,1341388425,0,1),(531,2,1341388725,0,1),(532,2,1341389025,0,1),(533,2,1341389325,0,1),(534,2,1341389625,0,1),(535,2,1341389925,0,1),(536,2,1341390225,0,1),(537,2,1341390525,0,1),(538,2,1341390825,0,1),(539,2,1341391125,0,1),(540,2,1341391425,0,1),(541,2,1341391725,0,1),(542,2,1341392025,0,1),(543,2,1341392325,0,1),(544,2,1341392625,0,1),(545,2,1341392925,0,1),(546,2,1341393225,0,1),(547,2,1341393525,0,1),(548,2,1341393825,0,1),(549,2,1341394125,0,1),(550,2,1341394425,0,1),(551,2,1341394725,0,1),(552,2,1341395025,0,1),(553,2,1341395325,0,1),(554,2,1341395625,0,1),(555,2,1341395925,0,1),(556,2,1341396225,0,1),(557,2,1341396525,0,1),(558,2,1341396825,0,1),(559,2,1341397125,0,1),(560,2,1341397425,0,1),(561,2,1341397725,0,1),(562,2,1341398025,0,1),(563,2,1341398325,0,1),(564,2,1341398625,0,1),(565,2,1341398925,0,1),(566,2,1341399225,0,1),(567,2,1341399525,0,1),(568,2,1341399825,0,1),(569,2,1341400125,0,1),(570,2,1341400425,0,1),(571,2,1341400725,0,1),(572,2,1341401025,0,1),(573,2,1341401325,0,1),(574,2,1341401625,0,1),(575,2,1341401925,0,1),(576,2,1341402225,0,1),(577,2,1341402525,0,1),(578,2,1341402825,0,1),(579,2,1341403125,0,1),(580,2,1341403425,0,1),(581,2,1341403725,0,1),(582,2,1341404025,0,1),(583,2,1341404325,0,1),(584,2,1341404625,0,1),(585,2,1341404925,0,1),(586,2,1341405225,0,1),(587,2,1341405525,0,1),(588,2,1341405825,0,1),(589,2,1341406125,0,1),(590,2,1341406425,0,1),(591,2,1341406725,0,1),(592,2,1341407025,0,1),(593,2,1341407325,0,1),(594,2,1341407625,0,1),(595,2,1341407925,0,1),(596,2,1341408225,0,1),(597,2,1341408525,0,1),(598,2,1341408825,0,1),(599,2,1341409125,0,1),(600,2,1341409425,0,1),(601,2,1341409725,0,1),(602,2,1341410025,0,1),(603,2,1341410325,0,1),(604,2,1341410625,0,1),(605,2,1341410925,0,1),(606,2,1341411225,0,1),(607,2,1341411525,0,1),(608,2,1341411825,0,1),(609,2,1341412125,0,1),(610,2,1341412425,0,1),(611,2,1341412725,0,1),(612,2,1341413025,0,1),(613,2,1341413325,0,1),(614,2,1341413625,0,1),(615,2,1341413925,0,1),(616,2,1341414225,0,1),(617,2,1341414525,0,1),(618,2,1341414825,0,1),(619,2,1341415088,0,1),(620,2,1341415425,0,1),(621,2,1341415725,0,1),(622,2,1341416025,0,1),(623,2,1341416325,0,1),(624,2,1341416625,0,1),(625,2,1341416925,0,1),(626,2,1341417225,0,1),(627,2,1341417525,0,1),(628,2,1341417825,0,1),(629,2,1341418125,0,1),(630,2,1341418425,0,1),(631,2,1341418725,0,1),(632,2,1341419025,0,1),(633,2,1341419325,0,1),(634,2,1341419625,0,1),(635,2,1341419925,0,1),(636,2,1341420225,0,1),(637,2,1341420525,0,1),(638,2,1341420825,0,1),(639,2,1341421125,0,1),(640,2,1341421425,0,1),(641,2,1341421725,0,1),(642,2,1341422025,0,1),(643,2,1341422325,0,1),(644,2,1341422625,0,1),(645,2,1341422925,0,1),(646,2,1341423225,0,1),(647,2,1341423525,0,1),(648,2,1341423825,0,1),(649,2,1341424125,0,1),(650,2,1341424425,0,1),(651,2,1341424725,0,1),(652,2,1341425025,0,1),(653,2,1341425325,0,1),(654,2,1341425625,0,1),(655,2,1341425925,0,1),(656,2,1341426225,0,1),(657,2,1341426525,0,1),(658,2,1341426825,0,1),(659,2,1341427125,0,1),(660,2,1341427425,0,1),(661,2,1341427725,0,1),(662,2,1341428025,0,1),(663,2,1341428325,0,1),(664,2,1341428625,0,1),(665,2,1341428925,0,1),(666,2,1341429225,0,1),(667,2,1341429525,0,1),(668,2,1341429825,0,1),(669,2,1341430125,0,1),(670,2,1341430425,0,1),(671,2,1341430725,0,1),(672,2,1341431025,0,1),(673,2,1341431325,0,1),(674,2,1341431625,0,1),(675,2,1341431925,0,1),(676,2,1341432225,0,1),(677,2,1341432525,0,1),(678,2,1341432825,0,1),(679,2,1341433125,0,1),(680,2,1341433425,0,1),(681,2,1341433725,0,1),(682,2,1341434025,0,1),(683,2,1341434325,0,1),(684,2,1341434625,0,1),(685,2,1341434925,0,1),(686,2,1341435225,0,1),(687,2,1341435525,0,1),(688,2,1341435825,0,1),(689,2,1341436125,0,1),(690,2,1341436425,0,1),(691,2,1341436725,0,1),(692,2,1341437025,0,1),(693,2,1341437325,0,1),(694,2,1341437625,0,1),(695,2,1341437925,0,1),(696,2,1341438225,0,1),(697,2,1341438525,0,1),(698,2,1341438825,0,1),(699,2,1341439125,0,1),(700,2,1341439425,0,1),(701,2,1341439725,0,1),(702,2,1341440025,0,1),(703,2,1341440325,0,1),(704,2,1341440625,0,1),(705,2,1341440925,0,1),(706,2,1341441225,0,1),(707,2,1341441525,0,1),(708,2,1341441825,0,1),(709,2,1341442125,0,1),(710,2,1341442425,0,1),(711,2,1341442725,0,1),(712,2,1341443025,0,1),(713,2,1341443325,0,1),(714,2,1341443625,0,1),(715,2,1341443925,0,1),(716,2,1341444225,0,1),(717,2,1341444525,0,1),(718,2,1341444825,0,1),(719,2,1341445125,0,1),(720,2,1341445425,0,1),(721,2,1341445725,0,1),(722,2,1341446025,0,1),(723,2,1341446325,0,1),(724,2,1341446625,0,1),(725,2,1341446925,0,1),(726,2,1341447225,0,1),(727,2,1341447525,0,1),(728,2,1341447825,0,1),(729,2,1341448088,0,1),(730,2,1341448425,0,1),(731,2,1341448725,0,1),(732,2,1341449025,0,1),(733,2,1341449325,0,1),(734,2,1341449625,0,1),(735,2,1341449925,0,1),(736,2,1341450225,0,1),(737,2,1341450525,0,1),(738,2,1341450825,0,1),(739,2,1341451125,0,1),(740,2,1341451425,0,1),(741,2,1341451725,0,1),(742,2,1341452025,0,1),(743,2,1341452325,0,1),(744,2,1341452625,0,1),(745,2,1341452925,0,1),(746,2,1341453225,0,1),(747,2,1341453525,0,1),(748,2,1341453825,0,1),(749,2,1341454125,0,1),(750,2,1341454425,0,1),(751,2,1341454725,0,1),(752,2,1341455025,0,1),(753,2,1341455325,0,1),(754,2,1341455625,0,1),(755,2,1341455925,0,1),(756,2,1341456225,0,1),(757,2,1341456525,0,1),(758,2,1341456825,0,1),(759,2,1341457125,0,1),(760,2,1341457425,0,1),(761,2,1341457725,0,1),(762,2,1341458025,0,1),(763,2,1341458325,0,1),(764,2,1341458625,0,1),(765,2,1341458925,0,1),(766,2,1341459225,0,1),(767,2,1341459525,0,1),(768,2,1341459825,0,1),(769,2,1341460125,0,1),(770,2,1341460425,0,1),(771,2,1341460725,0,1),(772,2,1341461025,0,1),(773,2,1341461325,0,1),(774,2,1341461625,0,1),(775,2,1341461925,0,1),(776,2,1341462225,0,1),(777,2,1341462525,0,1),(778,2,1341462825,0,1),(779,2,1341463125,0,1),(780,2,1341463425,0,1),(781,2,1341463725,0,1),(782,2,1341464025,0,1),(783,2,1341464325,0,1),(784,2,1341464625,0,1),(785,2,1341464925,0,1),(786,2,1341465225,0,1),(787,2,1341465525,0,1),(788,2,1341465825,0,1),(789,2,1341466125,0,1),(790,2,1341466425,0,1),(791,2,1341466725,0,1),(792,2,1341467025,0,1),(793,2,1341467325,0,1),(794,2,1341467625,0,1),(795,2,1341467925,0,1),(796,2,1341468225,0,1),(797,2,1341468525,0,1),(798,2,1341468825,0,1),(799,2,1341469125,0,1),(800,2,1341469425,0,1),(801,2,1341469725,0,1),(802,2,1341470025,0,1),(803,2,1341470325,0,1),(804,2,1341470625,0,1),(805,2,1341470925,0,1),(806,2,1341471225,0,1),(807,2,1341471525,0,1),(808,2,1341471825,0,1),(809,2,1341472125,0,1),(810,2,1341472425,0,1),(811,2,1341472725,0,1),(812,2,1341473025,0,1),(813,2,1341473325,0,1),(814,2,1341473625,0,1),(815,2,1341473925,0,1),(816,2,1341474225,0,1),(817,2,1341474525,0,1),(818,2,1341474825,0,1),(819,2,1341475125,0,1),(820,2,1341475425,0,1),(821,2,1341475725,0,1),(822,2,1341476025,0,1),(823,2,1341476325,0,1),(824,2,1341476625,0,1),(825,2,1341476925,0,1),(826,2,1341477225,0,1),(827,2,1341477488,0,1),(828,2,1341477825,0,1),(829,2,1341478125,0,1),(830,2,1341478425,0,1),(831,2,1341478725,0,1),....
Subject
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.