mrAEQEeU

1[SQL] Query houseoptima_dev start
2[ERR] 1840 - @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
3[ERR] -- MySQL dump 10.13  Distrib 5.7.21, for Linux (x86_64)
4--
5-- Host: 127.0.0.1    Database: houseoptima_dev
6-- ------------------------------------------------------
7-- Server version	5.6.36-google-log
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
20SET @@SESSION.SQL_LOG_BIN= 0;
21
22--
23-- GTID state at the beginning of the backup 
24--
25
26SET @@GLOBAL.GTID_PURGED='3bf2f112-451c-11e7-9ad9-42010a8400b1:1-23817946,
27c16331cf-dc93-11e6-b133-42010a84005e:1-11385535';
28
29--
30-- Table structure for table `accounting_accounts`
31--
32
33DROP TABLE IF EXISTS `accounting_accounts`;
34/*!40101 SET @saved_cs_client     = @@character_set_client */;
35/*!40101 SET character_set_client = utf8 */;
36CREATE TABLE `accounting_accounts` (
37  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
38  `name` varchar(100) COLLATE utf8_swedish_ci DEFAULT NULL,
39  `account` int(6) unsigned DEFAULT NULL,
40  `type` enum('sales','purchase') COLLATE utf8_swedish_ci DEFAULT NULL,
41  `type_default` tinyint(1) DEFAULT NULL,
42  `service_company_id` int(10) unsigned DEFAULT NULL,
43  PRIMARY KEY (`id`),
44  UNIQUE KEY `unique_account` (`account`,`service_company_id`),
45  UNIQUE KEY `unique_type_default` (`type`,`type_default`,`service_company_id`),
46  KEY `FK_accounting_account_service_company` (`service_company_id`),
47  CONSTRAINT `FK_accounting_account_service_company` FOREIGN KEY (`service_company_id`) REFERENCES `service_companies` (`id`) ON DELETE CASCADE
48) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
49/*!40101 SET character_set_client = @saved_cs_client */;
50
51--
52-- Dumping data for table `accounting_accounts`
53--
54
55LOCK TABLES `accounting_accounts` WRITE;
56/*!40000 ALTER TABLE `accounting_accounts` DISABLE KEYS */;
57INSERT INTO `accounting_accounts` VALUES (1,'Osto',4000,'purchase',NULL,1),(2,'Myynti',3000,'sales',NULL,1),(4,'Myynti',12345,'sales',1,1),(7,'Alihankinta',4450,'purchase',NULL,1),(8,'Matkapuhelinkulut',7750,'purchase',0,1),(9,'AAA',3001,'purchase',NULL,1),(10,'Some',2000,'sales',NULL,1),(11,'Myynti',3000,'sales',1,20),(12,'Myynti',3000,'sales',1,24),(13,'Osto',4000,'purchase',1,24),(14,'sales',3000,'sales',1,2),(15,'purchase',4000,'purchase',1,2),(16,'sales',3000,'sales',1,3),(17,'purchase',4000,'purchase',1,3),(18,'sales',3000,'sales',1,4),(19,'purchase',4000,'purchase',1,4),(20,'sales',3000,'sales',1,5),(21,'purchase',4000,'purchase',1,5),(22,'sales',3000,'sales',1,7),(23,'purchase',4000,'purchase',1,7),(24,'sales',3000,'sales',1,8),(25,'purchase',4000,'purchase',1,8),(26,'sales',3000,'sales',1,9),(27,'purchase',4000,'purchase',1,9),(28,'sales',3000,'sales',1,10),(29,'purchase',4000,'purchase',1,10),(30,'sales',3000,'sales',1,11),(31,'purchase',4000,'purchase',1,11),(32,'sales',3000,'sales',1,12),(33,'purchase',4000,'purchase',1,12),(34,'sales',3000,'sales',1,13),(35,'purchase',4000,'purchase',1,13),(36,'sales',3000,'sales',1,14),(37,'purchase',4000,'purchase',1,14),(38,'sales',3000,'sales',1,15),(39,'purchase',4000,'purchase',1,15),(40,'sales',3000,'sales',1,16),(41,'purchase',4000,'purchase',1,16),(42,'sales',3000,'sales',1,17),(43,'purchase',4000,'purchase',1,17),(44,'sales',3000,'sales',1,18),(45,'purchase',4000,'purchase',1,18),(46,'sales',3000,'sales',1,19),(47,'purchase',4000,'purchase',1,19),(48,'purchase',4000,'purchase',1,20),(49,'sales',3000,'sales',1,21),(50,'purchase',4000,'purchase',1,21),(51,'sales',3000,'sales',1,22),(52,'purchase',4000,'purchase',1,22),(53,'sales',3000,'sales',1,23),(54,'purchase',4000,'purchase',1,23),(55,'Toinen',2222,'pu
58[ERR] 2006 - MySQL server has gone away
59[ERR] 
60INSERT INTO `consumption_readings` VALUES (13,12,'2014-11-18 22:00:00',5422.000),(14,12,'2014-12-08 22:00:00',122.000),(15,12,'2014-12-01 22:00:00',1000.000),(16,12,'2014-12-18 22:00:00',300.000),(17,12,'2014-12-09 22:00:00',-200.000),(18,12,'2014-12-14 22:00:00',-2000.000),(20,9,'2015-03-04 22:00:00',600.000),(21,9,'2015-03-01 22:00:00',500.000),(23,12,'2015-03-12 22:00:00',9000.000),(24,9,'2015-03-31 21:00:00',200.000),(27,155,'2015-05-12 12:51:45',21.000),(29,156,'2015-05-12 13:15:05',43.000),(30,155,'2015-05-12 14:29:40',24.000),(31,156,'2015-05-13 09:10:20',86.000),(32,156,'2015-05-13 09:39:40',87.000),(33,156,'2015-05-13 09:41:30',88.000),(34,156,'2015-05-13 09:41:40',89.000),(35,156,'2015-05-13 09:45:42',90.000),(36,156,'2015-05-13 09:47:12',91.000),(37,155,'2015-05-13 11:30:45',32.000),(38,155,'2015-05-13 11:31:05',33.000),(39,156,'2015-05-13 11:31:16',92.000),(40,155,'2015-05-13 11:31:26',34.000),(41,156,'2015-05-13 12:10:18',93.000),(42,156,'2015-05-13 12:11:59',94.000),(43,156,'2015-05-13 12:12:19',95.000),(44,156,'2015-05-13 12:25:03',96.000),(45,156,'2015-05-13 12:25:23',97.000),(46,156,'2015-05-13 12:32:05',98.000),(47,156,'2015-05-13 12:32:15',99.000),(48,155,'2015-05-13 12:45:29',35.000),(49,156,'2015-05-13 14:43:27',100.000),(50,156,'2015-05-13 14:43:37',101.000),(51,156,'2015-05-13 14:53:30',102.000),(52,156,'2015-05-15 08:28:01',106.000),(53,155,'2015-05-15 08:36:24',36.000),(54,156,'2015-05-15 08:36:24',107.000),(55,155,'2015-05-08 10:06:28',4.000),(56,155,'2015-05-08 11:03:58',6.000),(57,155,'2015-05-08 11:04:08',7.000),(58,155,'2015-05-08 12:08:38',8.000),(59,155,'2015-05-08 12:09:59',9.000),(60,155,'2015-05-08 12:13:40',10.000),(61,155,'2015-05-12 04:56:07',12.000),(62,155,'2015-05-12 04:56:17',13.000),(63,156,'2015-05-08 10:05:07',6.000),(64,156,'2015-05-08 10:06:28',7.000),(65,156,'2015-05-08 10:06:48',8.000),(66,156,'2015-05-08 10:06:58',9.000),(67,156,'2015-05-08 11:03:48',10.000),(68,156,'2015-05-08 11:03:58',12.000),(69,156,'2015-05-08 11:04:08',13.000),(70,156,'2015-05-12 04:55:57',14.000),(71,156,'2015-05-12 04:56:07',15.000),(72,156,'2015-05-12 04:56:17',16.000),(73,156,'2015-05-12 05:05:50',17.000),(74,156,'2015-05-12 05:13:42',18.000),(75,156,'2015-05-12 06:29:30',19.000),(76,156,'2015-05-12 06:29:40',20.000),(77,156,'2015-05-12 07:16:45',21.000),(78,156,'2015-05-12 07:23:57',22.000),(79,156,'2015-05-12 07:24:17',23.000),(80,156,'2015-05-12 08:35:49',24.000),(81,156,'2015-05-12 08:35:59',25.000),(82,156,'2015-05-12 08:41:11',26.000),(83,155,'2015-05-15 08:49:18',37.000),(84,155,'2015-05-15 08:49:28',38.000),(85,155,'2015-05-15 08:49:38',39.000),(86,156,'2015-05-15 08:49:48',108.000),(87,156,'2015-05-15 08:49:58',109.000),(88,155,'2015-05-15 08:55:30',40.000),(89,156,'2015-05-15 08:55:40',110.000),(90,156,'2015-05-15 08:55:50',111.000),(91,156,'2015-05-15 08:56:00',113.000),(92,156,'2015-05-15 08:56:10',114.000),(93,156,'2015-05-15 09:04:03',115.000),(94,155,'2015-05-15 09:10:04',41.000),(95,155,'2015-05-15 09:10:35',42.000),(96,156,'2015-05-15 09:45:06',116.000),(97,187,'2015-05-15 09:55:05',44.400),(98,181,'2015-05-15 09:55:05',30.900),(99,186,'2015-05-15 09:55:06',44.900),(100,179,'2015-05-15 09:55:07',32.300),(101,185,'2015-05-15 09:55:08',45.200),(102,178,'2015-05-15 09:55:09',76.100),(103,180,'2015-05-15 09:55:09',36.100),(104,188,'2015-05-15 09:55:10',11.400),(105,156,'2015-05-15 09:58:50',117.000),(106,156,'2015-05-15 09:59:00',118.000),(107,187,'2015-05-15 10:00:05',44.400),(108,181,'2015-05-15 10:00:06',30.800),(109,186,'2015-05-15 10:00:07',44.900),(110,179,'2015-05-15 10:00:08',31.300),(111,185,'2015-05-15 10:00:08',45.200),(112,178,'2015-05-15 10:00:09',76.100),(113,180,'2015-05-15 10:00:10',36.100),(114,188,'2015-05-15 10:00:11',11.400),(115,156,'2015-05-15 10:00:51',119.000),(4092,187,'2015-05-15 10:05:05',44.400),(4093,181,'2015-05-15 10:05:06',30.800),(4094,186,'2015-05-15 10:05:07',45.000),(4095,179,'2015-05-15 10:05:08',31.200),(4096,185,'2015-05-15 10:05:09',45.200),(4097,178,'2015-05-15 10:05:09',76.200),(4098,180,'2015-05-15 10:05:10',36.100),(4099,188,'2015-0
61[ERR] 1146 - Table 'optima_dev.customers' doesn't exist
62[ERR] 
63INSERT INTO `customers` VALUES (127,NULL,'Niko Jämsä',NULL,'niko.jamsa@kolumbus.fi',NULL,1,NULL,'FI','FI',14,NULL,1,NULL,NULL,NULL,NULL,NULL),(128,NULL,'Teemu Hyry',NULL,'teemu.hyry@senera.fi',NULL,1,NULL,'FI','FI',14,430,1,NULL,NULL,NULL,NULL,NULL),(129,NULL,'Tomi Koivukoski',NULL,'tomi.koivukoski@koivukoski.fi',NULL,1,NULL,'FI','FI',14,NULL,1,NULL,NULL,NULL,NULL,NULL),(130,NULL,'Markus Torkki','0405275931','markus.torkki@netlife.fi','markus.torkki@omasairaala.fi',2,NULL,'FI','FI',14,258,1,NULL,NULL,NULL,NULL,NULL),(131,NULL,'Antti Heikkilä',NULL,'antti.heikkila@saunalahti.fi',NULL,1,NULL,'FI','FI',14,NULL,1,NULL,NULL,NULL,NULL,NULL),(132,NULL,'Aapo Holma','040 5301278','aapo.holma@terawatt.fi',NULL,1,NULL,'FI','FI',14,396,1,NULL,NULL,NULL,NULL,NULL),(133,NULL,'Majoituspalvelu Forenom Oy',NULL,NULL,NULL,3,'003716332413','FI','FI',7,1559,1,NULL,NULL,NULL,NULL,NULL),(134,NULL,'As Oy Niina-kirsti',NULL,NULL,NULL,1,NULL,'FI','FI',14,NULL,1,NULL,NULL,NULL,NULL,NULL),(135,NULL,'Aho Tapani',NULL,NULL,NULL,1,NULL,'FI','FI',14,223,1,NULL,NULL,NULL,NULL,NULL),(136,NULL,'Airwise Oy','0443598139',NULL,NULL,1,NULL,'FI','FI',7,149,1,NULL,NULL,NULL,NULL,NULL),(137,NULL,'Alamäki Harri',NULL,NULL,NULL,1,NULL,'FI','FI',14,352,1,NULL,NULL,NULL,NULL,NULL),(138,NULL,'As Oy Hakolahdentie 35 c/o Jouko Leikkola',NULL,NULL,NULL,1,NULL,'FI','FI',14,52,1,NULL,NULL,NULL,NULL,NULL),(139,NULL,'As Oy Hämäläistentie 18 C/O Innofori Oy',NULL,NULL,NULL,1,NULL,'FI','FI',14,304,1,NULL,NULL,NULL,NULL,NULL),(140,NULL,'AS oy Jorvaksen Koivumäki c/o Kuudi Oy',NULL,NULL,'isannointi@kuudi.fi',3,'00370127942900001','FI','FI',14,109,1,NULL,NULL,NULL,NULL,NULL),(141,NULL,'As Oy Katiskaranta c/o Talotili Oy',NULL,NULL,NULL,1,NULL,'FI','FI',14,166,1,NULL,NULL,NULL,NULL,NULL),(142,NULL,'As Oy Klaukkalanportti Kiinteistötahkola Oy Oulu',NULL,NULL,NULL,3,'FI5980000710218085','FI','FI',7,30,1,NULL,NULL,NULL,NULL,NULL),(143,NULL,'As Oy Klaukkalanpursi c/o Taloasema Averia Isännöinti Oy',NULL,NULL,NULL,3,'FI7380000710217251@DABAFIHH','FI','FI',7,511,1,NULL,NULL,NULL,NULL,NULL),(144,'0677495-5','As Oy Kulkurinmäki 6 C/O Innofori Oy',NULL,NULL,NULL,3,'003706774955@NDEAFIHH','FI','FI',7,153,1,NULL,NULL,NULL,NULL,NULL),(145,NULL,'As Oy Kultarikon Kukka Kiinteistötahkola Oy Oulu',NULL,NULL,NULL,3,'003723925364@NDEAFIHH','FI','FI',7,15,1,NULL,NULL,NULL,NULL,NULL),(146,NULL,'As Oy Kultarikon Nuppu c/o Kiinteistötahkola Oy Oulu',NULL,NULL,NULL,3,'003723925399@NDEAFIHH','FI','FI',7,16,1,NULL,NULL,NULL,NULL,NULL),(147,'0571365-9','AS OY NEIDONKARTANO C/O Innofori Oy',NULL,NULL,NULL,3,'003705713659@NDEAFIHH','FI','FI',7,31,1,NULL,NULL,NULL,NULL,NULL),(148,NULL,'As Oy Nurmijärven Ohjastie 4 c/o Kiinteistötahkola Oy',NULL,NULL,NULL,1,NULL,'FI','FI',7,97,1,NULL,NULL,NULL,NULL,NULL),(149,NULL,'As Oy Ratsumestari Marcus Johansson/ Maikoski Oy',NULL,NULL,NULL,1,NULL,'FI','FI',7,96,1,NULL,NULL,NULL,NULL,NULL),(150,'0480516-4','As Oy Solisevankuja C/O Innofori Oy',NULL,NULL,NULL,3,'003704805164@NDEAFIHH','FI','FI',7,154,1,NULL,NULL,NULL,NULL,NULL),(151,NULL,'As Oy Tonttuketo C/O Innofori',NULL,NULL,NULL,1,NULL,'FI','FI',7,323,1,NULL,NULL,NULL,NULL,NULL),(152,NULL,'As Oy Vantaan Ilolan Sävel c/o Uudenmaan Tili- ja Kiinteistötieto Oy',NULL,NULL,NULL,1,NULL,'FI','FI',14,3687,1,NULL,NULL,NULL,NULL,NULL),(153,NULL,'As Oy Vantaan Ilolan Taika c/o Isännöinti Hietikko Oy',NULL,NULL,NULL,1,NULL,'FI','FI',7,27,1,NULL,NULL,NULL,NULL,NULL),(154,NULL,'As Oy Vantaan Marsalkka Jarmo Kangas',NULL,NULL,NULL,1,NULL,'FI','FI',14,296,1,NULL,NULL,NULL,NULL,NULL),(155,NULL,'As Oy Vantaan Sananjalantie Kiinteistötahkola Oy Oulu',NULL,NULL,NULL,3,'FI8813133000111595','FI','FI',7,32,1,NULL,NULL,NULL,NULL,NULL),(156,'2106531-3','As Oy Villa Gardenia C/O Innofori Oy',NULL,NULL,NULL,3,'003721065313@NDEAFIHH','FI','FI',7,17,1,NULL,NULL,NULL,NULL,NULL),(157,NULL,'As Oy Nurmijärven Ohjastie 10 Kiinteistötahkola Oy Oulu',NULL,NULL,NULL,3,'FI3080180710149728','FI','FI',7,64,1,NULL,NULL,NULL,NULL,NULL),(158,NULL,'As.oy Penttiläntie Kiinteistötahkola Oy Oulu',NULL,NULL,'tuomo.huusko@kiinteistotahkola.fi',3,'0037046727
64[ERR] 1146 - Table 'optima_dev.import_history' doesn't exist
65[ERR] 
66INSERT INTO `import_history` VALUES (1,'projects',849,862),(2,'stata_kohde',73641,862),(3,'employee_worktimes',16592,3085),(4,'employee_worktimes',17185,3086),(5,'employee_worktimes',17186,3087),(6,'employee_worktimes',17222,3088),(7,'employee_worktimes',17430,3089),(8,'employee_worktimes',17493,3090),(9,'employee_worktimes',17494,3091),(10,'employee_worktimes',17578,3092),(11,'employee_worktimes',17685,3093),(12,'employee_worktimes',17868,3094),(13,'employee_worktimes',17929,3095),(14,'employee_worktimes',18463,3096),(15,'employee_worktimes',18466,3097),(16,'employee_worktimes',18515,3098),(17,'employee_worktimes',18632,3099),(18,'employee_worktimes',18657,3100),(19,'employee_worktimes',18718,3101),(20,'employee_worktimes',18851,3102),(21,'employee_worktimes',19452,3103),(22,'employee_worktimes',19453,3104),(23,'employee_worktimes',19454,3105),(24,'employee_worktimes',19455,3106),(25,'employee_worktimes',19456,3107),(26,'employee_worktimes',19457,3108),(27,'employee_worktimes',19458,3109),(28,'employee_worktimes',19459,3110),(29,'employee_worktimes',19460,3111),(30,'employee_worktimes',19461,3112),(31,'employee_worktimes',19485,3113),(32,'employee_worktimes',19486,3114),(33,'employee_worktimes',19487,3115),(34,'employee_worktimes',19517,3116),(35,'employee_worktimes',19652,3117),(36,'employee_worktimes',19673,3118),(37,'employee_worktimes',19719,3119),(38,'employee_worktimes',19940,3120),(39,'employee_worktimes',20180,3121),(40,'employee_worktimes',20182,3122),(41,'employee_worktimes',20183,3123),(42,'employee_worktimes',20433,3124),(43,'employee_worktimes',21048,3125),(44,'employee_worktimes',21051,3126),(45,'employee_worktimes',21413,3127),(46,'employee_worktimes',21414,3128),(47,'employee_worktimes',21415,3129),(48,'employee_worktimes',21416,3130),(49,'employee_worktimes',21420,3131),(50,'employee_worktimes',21422,3132),(51,'employee_worktimes',22208,3133),(52,'employee_worktimes',22597,3134),(53,'employee_worktimes',22629,3135),(54,'employee_worktimes',22764,3136),(55,'employee_worktimes',22819,3137),(56,'employee_worktimes',22832,3138),(57,'employee_worktimes',22842,3139),(58,'employee_worktimes',22965,3140),(59,'employee_worktimes',22967,3141),(60,'employee_worktimes',22968,3142),(61,'employee_worktimes',22969,3143),(62,'employee_worktimes',22970,3144),(63,'employee_worktimes',22971,3145),(64,'employee_worktimes',23361,3146),(65,'employee_worktimes',23371,3147),(66,'employee_worktimes',23393,3148),(67,'employee_worktimes',23800,3149),(68,'employee_worktimes',24089,3150),(69,'employee_worktimes',24296,3151),(70,'employee_worktimes',24312,3152),(71,'employee_worktimes',24313,3153),(72,'employee_worktimes',24314,3154),(73,'employee_worktimes',24315,3155),(74,'employee_worktimes',24316,3156),(75,'employee_worktimes',24317,3157),(76,'employee_worktimes',24953,3158),(77,'employee_worktimes',25266,3159),(78,'employee_worktimes',25506,3160),(79,'employee_worktimes',25553,3161),(80,'employee_worktimes',25554,3162),(81,'employee_worktimes',25555,3163),(82,'employee_worktimes',25556,3164),(83,'employee_worktimes',25557,3165),(84,'employee_worktimes',25691,3166),(85,'employee_worktimes',25718,3167),(86,'employee_worktimes',25773,3168),(87,'employee_worktimes',25774,3169),(88,'employee_worktimes',25791,3170),(89,'employee_worktimes',25859,3171),(90,'employee_worktimes',25860,3172),(91,'employee_worktimes',25861,3173),(92,'projects',519,863),(93,'stata_kohde',56270,863),(94,'stata_kohde',56274,863),(95,'stata_kohde',56271,863),(96,'stata_kohde',56272,863),(97,'stata_kohde',56273,863),(98,'stata_kohde',56275,863),(99,'stata_kohde',56276,863),(100,'stata_kohde',56277,863),(101,'stata_kohde',56278,863),(102,'stata_kohde',56279,863),(103,'stata_kohde',56280,863),(104,'stata_kohde',56281,863),(105,'stata_kohde',56282,91),(106,'stata_kohde',56283,92),(107,'stata_kohde',56284,863),(108,'stata_kohde',56285,863),(109,'stata_kohde',56286,863),(110,'stata_kohde',56287,863),(111,'stata_kohde',56288,93),(112,'stata_kohde',56289,863),(113,'stata_kohde',56290,94),(114,'stata_kohde',56291,95),(115,'stata_kohde',56292,863),(116,'stata_ko
67[ERR] 1146 - Table 'optima_dev.notification_ticket_user' doesn't exist
68[ERR] 
69INSERT INTO `notification_ticket_user` VALUES (19,1),(19,3),(19,4),(19,5),(19,6),(19,7),(19,8),(19,9),(19,11),(19,12),(19,13),(19,14),(19,15),(19,16),(19,17),(19,18),(19,19),(19,20),(19,23),(19,24),(19,25),(19,26),(19,27),(19,28),(19,29),(19,30),(19,31),(19,32),(19,33),(19,34),(19,35),(19,36),(19,37),(19,38),(19,39),(19,40),(19,41),(19,42),(19,43),(19,44),(19,45),(19,46),(19,47),(19,48),(19,49),(19,50),(19,51),(19,52),(19,53),(19,54),(19,55),(19,56),(19,57),(19,58),(19,59),(19,60),(19,61),(19,62),(19,63),(19,64),(19,66),(19,68),(19,69),(19,70),(19,71),(19,72),(19,73),(19,74),(19,76),(19,77),(19,79),(19,81),(19,82),(19,83),(19,84),(19,85),(19,86),(19,87),(19,88),(19,89),(19,90),(19,91),(19,92),(19,93),(19,95),(19,96),(19,97),(19,98),(19,99),(19,100),(19,101),(19,102),(19,103),(19,104),(19,105),(19,106),(19,107),(19,108),(19,109),(19,110),(19,111),(19,112),(19,113),(19,114),(19,115),(19,116),(19,117),(19,118),(19,119),(19,120),(19,121),(19,122),(19,123),(19,124),(19,125),(19,126),(19,127),(19,128),(19,129),(19,130),(19,131),(19,132),(19,133),(19,134),(19,135),(19,136),(19,137),(19,138),(19,139),(19,140),(19,141),(19,142),(19,143),(19,144),(19,145),(19,146),(19,147),(19,148),(19,149),(19,150),(19,151),(19,152),(19,153),(19,154),(19,155),(19,158),(19,159),(19,160),(19,161),(19,162),(19,163),(19,164),(19,165),(19,166),(19,167),(19,168),(19,169),(19,170),(19,171),(19,172),(19,173),(19,174),(19,175),(19,176),(19,177),(19,178),(19,179),(19,180),(19,181),(19,182),(19,184),(19,185),(19,186),(19,187),(19,188),(19,189),(19,190),(19,191),(19,192),(19,193),(19,194),(19,195),(19,199),(19,200),(19,201),(19,202),(19,203),(19,204),(19,207),(19,208),(19,209),(19,210),(19,212),(19,213),(19,214),(19,215),(19,216),(19,217),(19,218),(19,219),(19,220),(19,221),(19,223),(19,224),(19,225),(19,226),(19,227),(19,228),(19,229),(19,231),(19,232),(19,237),(19,238),(19,239),(19,240),(19,241),(19,242),(19,243),(19,244),(19,245),(19,246),(19,247),(19,248),(19,249),(19,250),(19,251),(19,252),(19,253),(19,254),(19,255),(19,256),(19,257),(19,258),(19,259),(19,260),(19,262),(19,263),(19,264),(19,265),(19,266),(19,267),(19,268),(19,269),(19,270),(19,271),(19,272),(19,273),(19,274),(19,275),(19,276),(19,277),(19,278),(19,279),(19,280),(19,281),(19,282),(19,283),(19,284),(19,285),(19,286),(19,287),(19,288),(19,289),(19,290),(19,291),(19,292),(19,293),(19,294),(19,295),(19,296),(19,297),(19,298),(19,299),(19,300),(19,301),(19,302),(19,303),(19,304),(19,305),(19,306),(19,307),(19,308),(19,309),(19,310),(19,311),(19,312),(19,313),(19,314),(19,315),(19,316),(19,317),(19,318),(19,319),(19,320),(19,321),(19,322),(19,323),(19,324),(19,325),(19,326),(19,327),(19,328),(19,329),(19,330),(19,331),(19,332),(19,333),(19,334),(19,335),(19,336),(19,337),(19,338),(19,339),(19,340),(19,341),(19,342),(19,343),(19,344),(19,345),(19,346),(19,347),(19,348),(19,349),(19,350),(19,351),(19,352),(19,353),(19,354),(19,355),(19,356),(19,357),(19,358),(19,359),(19,360),(19,361),(19,362),(19,363),(19,364),(19,365),(19,366),(19,367),(19,368),(19,369),(19,370),(19,371),(19,372),(19,373),(19,374),(19,375),(19,376),(19,377),(19,378),(19,379),(19,380),(19,381),(19,382),(19,383),(19,384),(19,385),(19,386),(19,387),(19,388),(19,389),(19,390),(19,391),(19,392),(19,393),(19,394),(19,395),(19,396),(19,397),(19,398),(19,399),(19,400),(19,401),(19,402),(19,403),(19,404),(19,405),(19,406),(19,407),(19,408),(19,409),(19,410),(19,411),(19,412),(19,413),(19,414),(19,415),(19,416),(19,417),(19,418),(19,419),(20,1),(20,3),(20,4),(20,5),(20,6),(20,7),(20,8),(20,9),(20,11),(20,12),(20,13),(20,14),(20,15),(20,16),(20,17),(20,18),(20,19),(20,20),(20,23),(20,24),(20,25),(20,26),(20,27),(20,28),(20,29),(20,30),(20,31),(20,32),(20,33),(20,34),(20,35),(20,36),(20,37),(20,38),(20,39),(20,40),(20,41),(20,42),(20,43),(20,44),(20,45),(20,46),(20,47),(20,48),(20,49),(20,50),(20,51),(20,52),(20,53),(20,54),(20,55),(20,56),(20,57),(20,58),(20,59),(20,60),(20,61),(20,62),(20,63),(20,64),(20,66),(20,68),(20,69),(20,70),(20,71),(20,72),(20,73),(20,74),(20,76),(20,77),(20,79),(20,81),(20,82),(20,83),(20,84),(20,85),(20
70[ERR] 1146 - Table 'optima_dev.product' doesn't exist
71[ERR] 
72INSERT INTO `product` VALUES (1,1,NULL,'3001','Ultracell UL 12V/7Ah','Akku 12V / 7 Ah','product'),(2,2,NULL,'3020','3G antenni',NULL,'product'),(3,2,NULL,'3021','4G antenni',NULL,'product'),(4,2,NULL,'3022','Wlan antenni',NULL,'product'),(5,3,NULL,'3040','Asennus helppo','Asennus','product'),(6,3,NULL,'3041','Asennus kohtalainen','Asennus','product'),(7,3,NULL,'3042','Asennus keskivaikea','Asennus','product'),(8,3,NULL,'3043','Asennus vaikea','Asennus','product'),(9,4,NULL,'3060','Tenda AC500','Kontrolleri','product'),(10,5,NULL,'3080','Tuntityö',NULL,'product'),(11,5,NULL,'3081','Palvelutaso 1',NULL,'product'),(12,5,NULL,'3082','Palvelutaso 2',NULL,'product'),(13,5,NULL,'3083','Palvelutaso 3',NULL,'product'),(14,5,NULL,'3084','Palvelutaso 4',NULL,'product'),(15,6,NULL,'3100','Logitech M185','Hiiri','product'),(16,6,NULL,'3101','Logitech M325','Hiiri','product'),(17,7,NULL,'3120','Järjestelmän päivitys',NULL,'product'),(18,9,NULL,'3160','Alueella tallentava kameravalvontatarra (pieni)',NULL,'product'),(19,9,NULL,'3161','Alueella tallentava kameravalvontatarra (iso)',NULL,'product'),(20,10,NULL,'3180','Laitteiden toimivuus',NULL,'product'),(21,10,NULL,'3181','Levytilan hallinta',NULL,'product'),(22,12,NULL,'3220','Laajakaista 40Mbit / 40Mbit (SHDSL)',NULL,'product'),(23,12,NULL,'3221','Laajakaista 100Mbit / 100Mbit (VDSL)',NULL,'product'),(24,12,NULL,'3222','Laajakaista 100Mbit / 10Mbit (VDSL)',NULL,'product'),(25,12,NULL,'3223','Laajakaista 20Mbit / 20Mbit (SHDSL)',NULL,'product'),(26,12,NULL,'3224','Kaapeliyhteyden Internet - liittymä',NULL,'product'),(27,13,NULL,'3240','Järjestelmäkartoitus',NULL,'product'),(28,14,NULL,'3260','Samsung 21.5\" DB22D-T LED','Kosketusnäyttö 21,5\"','product'),(29,14,NULL,'3261','Lenovo A7600-F','Kosketusnäyttö 7\"','product'),(30,15,NULL,'3280','Ensto Cubo C 300x400','Asennuskotelo','product'),(31,15,NULL,'3281','Kosketusnäyttö 21,5\" kotelo',NULL,'product'),(32,15,NULL,'3282','Obo T160','Asennuskotelo','product'),(33,15,NULL,'3283','Obo T250','Asennuskotelo','product'),(34,15,NULL,'3284','Raspberry Pi - kotelot','Asennuskotelo','product'),(35,15,NULL,'3285','Semac-kotelo','Asennuskotelo','product'),(36,15,NULL,'3286','WebPass asennuspohja','Näppäimistön asennuspohja','product'),(37,30,NULL,'3300','1TB WD Purple sata HDD','Kovalevy 1TB','product'),(38,30,NULL,'3301','2TB WD Purple sata HDD','Kovalevy 2TB','product'),(39,30,NULL,'3302','3TB WD Purple sata HDD','Kovalevy 3 TB','product'),(40,16,NULL,'3320','PLANET-FNSW-1601','Ethernet-kytkin','product'),(41,16,NULL,'3321','PLANET-FNSW-2401','Ethernet-kytkin','product'),(42,16,NULL,'3322','PLANET-FSD-503','Ethernet-kytkin','product'),(43,16,NULL,'3323','PLANET-FSD-803','Ethernet-kytkin','product'),(44,16,NULL,'3324','PLANET-GSD-503','Ethernet-kytkin','product'),(45,16,NULL,'3325','PLANET-GSD-803','Ethernet-kytkin','product'),(46,16,NULL,'3326','PLANET-GSD-805','Ethernet-kytkin','product'),(47,16,NULL,'3327','PLANET-GSW-1601','Ethernet-kytkin','product'),(48,16,NULL,'3328','PLANET-GSW-2401','Ethernet-kytkin','product'),(49,16,NULL,'3329','PLANET-GSW-4800','Ethernet-kytkin','product'),(50,16,NULL,'3330','PLANET-RKE-10A','Ethernet-kytkin','product'),(51,16,NULL,'3331','PLANET-RKE-10B','Ethernet-kytkin','product'),(52,17,NULL,'3350','PLANET-GS-2240-24T4X','Ethernet-kytkin','product'),(53,17,NULL,'3351','PLANET-GS-4210-16T2S','Ethernet-kytkin','product'),(54,17,NULL,'3352','PLANET-GS-4210-24T2S','Ethernet-kytkin','product'),(55,17,NULL,'3353','PLANET-GS-4210-48T4S','Ethernet-kytkin','product'),(56,17,NULL,'3354','PLANET-GSD-1002M','Ethernet-kytkin','product'),(57,17,NULL,'3355','PLANET-GSD-1020S','Ethernet-kytkin','product'),(58,17,NULL,'3356','PLANET-GSD-800S','Ethernet-kytkin','product'),(59,17,NULL,'3357','PLANET-MGSD-10080F','Ethernet-kytkin','product'),(60,17,NULL,'3358','PLANET-MGSW-24160F','Ethernet-kytkin','product'),(61,17,NULL,'3359','PLANET-MGSW-28240F','Ethernet-kytkin','product'),(62,17,NULL,'3360','PLANET-WGSD-10020','Ethernet-kytkin','product'),(63,17,NULL,'3361','PLANET-WGSW-24040','Ethernet-kytkin','product'),(64,17,NULL,'3
73[ERR] 2006 - MySQL server has gone away
74[ERR] 
75INSERT INTO `product_variants` VALUES (1,1,1,230.00,'2017-04-04 08:05:51','2017-04-06 08:37:38','2017-04-06'),(2,2,1,2323.00,'2017-04-04 08:07:11',NULL,NULL),(3,1,3,230.00,'2017-04-04 08:08:19','2017-04-06 08:37:38','2017-04-06'),(4,2,3,230.00,'2017-04-04 08:08:19','2017-04-11 10:34:45','2017-04-11'),(5,1,4,250.00,'2017-04-06 08:12:21','2017-04-13 10:10:29','2017-04-13'),(6,1,2,230.00,'2017-04-06 08:14:31','2017-04-06 08:37:38','2017-04-06'),(7,1,1,230.00,'2017-04-06 08:14:31','2017-04-06 08:37:38','2017-04-06'),(8,1,3,230.00,'2017-04-06 08:14:31','2017-04-06 08:37:38','2017-04-06'),(9,1,1,230.00,'2017-04-06 08:37:12','2017-04-06 08:37:38','2017-04-06'),(10,1,3,230.00,'2017-04-06 08:37:12','2017-04-06 08:37:38','2017-04-06'),(11,1,2,230.00,'2017-04-06 08:37:12','2017-04-06 08:37:38','2017-04-06'),(12,1,2,230.00,'2017-04-06 08:37:49','2017-04-11 10:34:45','2017-04-11'),(13,1,1,250.00,'2017-04-06 08:37:49','2017-04-06 08:43:28',NULL),(14,1,3,230.00,'2017-04-06 08:37:49','2017-04-11 10:34:45','2017-04-11'),(15,3,8,49.50,'2017-04-07 12:24:30','2017-11-01 05:50:26',NULL),(16,4,8,106.00,'2017-04-07 12:25:08',NULL,NULL),(17,5,8,77.00,'2017-04-07 12:25:08',NULL,NULL),(18,6,8,155.00,'2017-04-07 12:25:08',NULL,NULL),(19,7,8,2.36,'2017-04-07 12:25:08',NULL,NULL),(20,8,8,3.34,'2017-04-07 12:25:08',NULL,NULL),(21,9,8,5.41,'2017-04-07 12:25:08',NULL,NULL),(22,10,8,50.40,'2017-04-07 12:25:08',NULL,NULL),(23,11,8,108.00,'2017-04-07 12:25:08',NULL,NULL),(24,12,8,215.00,'2017-04-07 12:25:08',NULL,NULL),(25,13,8,2.04,'2017-04-07 12:25:08',NULL,NULL),(26,14,8,81.50,'2017-04-07 12:25:08',NULL,NULL),(27,15,8,160.00,'2017-04-07 12:25:08',NULL,NULL),(28,16,8,320.00,'2017-04-07 12:25:08',NULL,NULL),(29,17,8,3.07,'2017-04-07 12:25:08',NULL,NULL),(30,18,8,4.81,'2017-04-07 12:25:08',NULL,NULL),(31,19,8,6.50,'2017-04-07 12:25:08',NULL,NULL),(32,20,8,9.51,'2017-04-07 12:25:08',NULL,NULL),(33,21,8,13.46,'2017-04-07 12:25:08',NULL,NULL),(34,22,8,17.33,'2017-04-07 12:25:08',NULL,NULL),(35,23,8,73.90,'2017-04-07 12:25:08',NULL,NULL),(36,24,8,144.00,'2017-04-07 12:25:08',NULL,NULL),(37,25,8,292.00,'2017-04-07 12:25:08',NULL,NULL),(38,26,8,233.00,'2017-04-07 12:25:08',NULL,NULL),(39,27,8,475.00,'2017-04-07 12:25:08',NULL,NULL),(40,28,8,2.03,'2017-04-07 12:25:08',NULL,NULL),(41,29,8,211.00,'2017-04-07 12:25:08',NULL,NULL),(42,30,8,2.94,'2017-04-07 12:25:08',NULL,NULL),(43,31,8,4.19,'2017-04-07 12:25:08',NULL,NULL),(44,32,8,309.00,'2017-04-07 12:25:08',NULL,NULL),(45,33,8,1.01,'2017-04-07 12:25:08',NULL,NULL),(46,34,8,1.48,'2017-04-07 12:25:08',NULL,NULL),(47,35,8,2.39,'2017-04-07 12:25:08',NULL,NULL),(48,36,8,2.84,'2017-04-07 12:25:08',NULL,NULL),(49,37,8,4.41,'2017-04-07 12:25:08',NULL,NULL),(50,38,8,1.81,'2017-04-07 12:25:08',NULL,NULL),(51,39,8,2.46,'2017-04-07 12:25:08',NULL,NULL),(52,40,8,3.18,'2017-04-07 12:25:08',NULL,NULL),(53,41,8,3.89,'2017-04-07 12:25:08',NULL,NULL),(54,42,8,4.64,'2017-04-07 12:25:08',NULL,NULL),(55,43,8,50.00,'2017-04-07 12:25:08',NULL,NULL),(56,44,8,50.60,'2017-04-07 12:25:08',NULL,NULL),(57,45,8,63.40,'2017-04-07 12:25:08',NULL,NULL),(58,46,8,223.00,'2017-04-07 12:25:08',NULL,NULL),(59,47,8,3.54,'2017-04-07 12:25:08',NULL,NULL),(60,48,8,99.70,'2017-04-07 12:25:08',NULL,NULL),(61,49,8,5.88,'2017-04-07 12:25:08',NULL,NULL),(62,50,8,118.00,'2017-04-07 12:25:08',NULL,NULL),(63,51,8,8.10,'2017-04-07 12:25:08',NULL,NULL),(64,52,8,1.97,'2017-04-07 12:25:08',NULL,NULL),(65,53,8,1.39,'2017-04-07 12:25:08',NULL,NULL),(66,54,8,2.10,'2017-04-07 12:25:09',NULL,NULL),(67,55,8,3.13,'2017-04-07 12:25:09',NULL,NULL),(68,56,8,4.36,'2017-04-07 12:25:09',NULL,NULL),(69,57,8,6.14,'2017-04-07 12:25:09',NULL,NULL),(70,58,8,8.64,'2017-04-07 12:25:09',NULL,NULL),(71,59,8,12.20,'2017-04-07 12:25:09',NULL,NULL),(72,60,8,15.45,'2017-04-07 12:25:09',NULL,NULL),(73,61,8,2.68,'2017-04-07 12:25:09',NULL,NULL),(74,62,8,4.31,'2017-04-07 12:25:09',NULL,NULL),(75,63,8,6.06,'2017-04-07 12:25:09',NULL,NULL),(76,64,8,7.76,'2017-04-07 12:25:09',NULL,NULL),(77,65,8,11.54,'2017-04-07 12:25:09',NULL,NULL),(78,66,8,16.13,'2017-04-07 12:25:09',NULL,NULL),(79,67,8,
76[ERR] 1146 - Table 'optima_dev.supplies' doesn't exist
77[ERR] 
78INSERT INTO `supplies` VALUES (1,'0105100','HK 16/25M RENGAS NEXANS','KPL',49.60,1,NULL,3),(2,'0105101','HK 16/50M RENGAS NEXANS','KPL',106.00,1,NULL,4),(3,'0105102','HK 25/25M RENGAS NEXANS','KPL',77.00,1,NULL,5),(4,'0105103','HK 25/50M RENGAS NEXANS','KPL',155.00,1,NULL,6),(5,'0105104','BLL 62/2000','M',2.36,1,NULL,7),(6,'0105105','BLL 99/2000','M',3.34,1,NULL,8),(7,'0105106','BLL 157/1000','M',5.41,1,NULL,9),(8,'0105205','HK 16/25M RENGAS DRAKANKC','KPL',50.40,1,NULL,10),(9,'0105206','HK 16/50M RENGAS DRAKANKC','KPL',108.00,1,NULL,11),(10,'0105207','HK 16/100M RENGAS DRAKANKC','KPL',215.00,1,NULL,12),(11,'0105316','HK 16 KELALLA DRAKANKC','M',2.04,1,NULL,13),(12,'0105323','HK 25/25M RENGAS DRAKANKC','KPL',81.50,1,NULL,14),(13,'0105324','HK 25/50M RENGAS DRAKANKC','KPL',160.00,1,NULL,15),(14,'0105325','HK 25/100M RENGAS DRAKANKC','KPL',320.00,1,NULL,16),(15,'0105327','HK 25 KELALLA DRAKANKC','M',3.07,1,NULL,17),(16,'0105335','HK 35 KELALLA DRAKANKC','M',4.81,1,NULL,18),(17,'0105350','HK 50 KELALLA DRAKANKC','M',6.50,1,NULL,19),(18,'0105370','HK 70 KELALLA DRAKANKC','M',9.51,1,NULL,20),(19,'0105395','HK 95 KELALLA DRAKANKC','M',13.46,1,NULL,21),(20,'0105397','HK 120 KELALLA DRAKANKC','M',17.33,1,NULL,22),(21,'0106005','HK 16/25M RENGAS REKA','KPL',73.90,1,NULL,23),(22,'0106006','HK 16/50M RENGAS REKA','KPL',144.00,1,NULL,24),(23,'0106007','HK 16/100M RENGAS REKA','KPL',292.00,1,NULL,25),(24,'0106024','HK 25/50M RENGAS REKA','KPL',233.00,1,NULL,26),(25,'0106025','HK 25/100M RENGAS REKA','KPL',475.00,1,NULL,27),(26,'0107006','HK 16 KELALLA NEXANS','M',2.03,1,NULL,28),(27,'0107007','HK 16/100M RENGAS NEXANS','KPL',211.00,1,NULL,29),(28,'0107008','HK 25 KELALLA NEXANS','M',2.94,1,NULL,30),(29,'0107009','HK 35 KELALLA NEXANS','M',4.19,1,NULL,31),(30,'0107025','HK 25/100M RENGAS NEXANS','KPL',309.00,1,NULL,32),(31,'0120202','ACSR 34/6 SPARROW PRYSMIAN','M',1.01,1,NULL,33),(32,'0120205','ACSR 54/9 RAVEN PRYSMIAN','M',1.48,1,NULL,34),(33,'0120209','ACSR 85/14 PIGEON PRYSMIAN','M',2.39,1,NULL,35),(34,'0120252','AAC 132 AL PRYSMIAN','M',2.84,1,NULL,36),(35,'0120255','AAC 201 AL PRYSMIAN','M',4.41,1,NULL,37),(36,'0122258','SAX-W 50 ALMGSI PRYSMIAN','M',1.81,1,NULL,38),(37,'0122259','SAX-W 70 ALMGSI PRYSMIAN','M',2.46,1,NULL,39),(38,'0122260','SAX-W 95 ALMGSI PRYSMIAN','M',3.18,1,NULL,40),(39,'0122262','SAX-W 120 ALMGSI PRYSMIAN','M',3.89,1,NULL,41),(40,'0122263','SAX-W 150 ALMGSI PRYSMIAN','M',4.64,1,NULL,42),(41,'0124012','AL.S.LANKA AHL 12/4,0 100M','KPL',50.00,1,NULL,43),(42,'0124016','AL.S.LANKA AHL 16/4,4 100M','KPL',50.60,1,NULL,44),(43,'0124025','AL.S.LANKA AHL 25/5,6 100M','KPL',63.40,1,NULL,45),(44,'0124049','JOMPPI 50 (60M RENGAS)','KPL',223.00,1,NULL,46),(45,'0124050','JOMPPI 50','M',3.54,1,NULL,47),(46,'0124093','JOMPPI 95 (15M RENGAS)','KPL',99.70,1,NULL,48),(47,'0124095','JOMPPI 95','M',5.88,1,NULL,49),(48,'0124098','JOMPPI 120 (15M RENGAS)','KPL',118.00,1,NULL,50),(49,'0124120','JOMPPI 120','M',8.10,1,NULL,51),(50,'0126523','HARUSKÖYSI FEMU 25/100M','M',1.97,1,NULL,52),(51,'0126533','HARUSKÖYSI FE 25/100 M','M',1.39,1,NULL,53),(52,'0130012','HK 16 KELALLA TF','M',2.10,1,NULL,54),(53,'0130013','HK 25 KELALLA TF','M',3.13,1,NULL,55),(54,'0130014','HK 35 KELALLA TF','M',4.36,1,NULL,56),(55,'0130015','HK 50 KELALLA TF','M',6.14,1,NULL,57),(56,'0130016','HK 70 KELALLA TF','M',8.64,1,NULL,58),(57,'0130017','HK 95 KELALLA TF','M',12.20,1,NULL,59),(58,'0130018','HK 120 KELALLA TF','M',15.45,1,NULL,60),(59,'0156016','HK 16 KELALLA REKA','M',2.68,1,NULL,61),(60,'0156025','HK 25 KELALLA REKA','M',4.31,1,NULL,62),(61,'0156035','HK 35 KELALLA REKA','M',6.06,1,NULL,63),(62,'0156050','HK 50 KELALLA REKA','M',7.76,1,NULL,64),(63,'0156070','HK 70 KELALLA REKA','M',11.54,1,NULL,65),(64,'0156095','HK 95 KELALLA REKA','M',16.13,1,NULL,66),(65,'0156098','HK 120 KELALLA REKA','M',20.37,1,NULL,67),(66,'0201023','KYTK.LANKA KL 1X0,5 MUS','M',0.20,1,NULL,68),(67,'0201024','KYTK.LANKA KL 1X0,5 KEL','M',0.20,1,NULL,69),(68,'0201026','KYTK.LANKA KL 1X0,5 PUN','M',0.20,1,NULL,70),(69,'0201041','KYTK.LANKA KL 1X0,6 HAR','M',0.19,1,NULL,71
79[ERR] 2006 - MySQL server has gone away
80[ERR] 
81INSERT INTO `task_executions` VALUES (1,9,NULL,NULL,NULL,'2014-12-05 00:00:00','putsattu hajulukot, pesty lattikaivo',NULL,NULL,30,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(2,11,NULL,NULL,NULL,'2013-04-23 00:00:00','Käyty mittaan suodattimet ja haettu suodattimet fonseenintieltä ja K:taloon keretty asentaan.',NULL,2,0,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(3,11,NULL,NULL,NULL,'2013-04-25 00:00:00','Vaihdettu suodattimet sokkakujalta.',NULL,2,0,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(4,11,NULL,NULL,NULL,'2013-12-02 00:00:00','Kohteessa vaihdoimme poito- ja tuloilmasuodattimet, sekä imuroimme suodatinkammiot.<br><br>Stata Oy<br>Oskari Rentola',NULL,2,30,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(5,11,NULL,NULL,NULL,'2013-12-02 00:00:00','Suodattimet vaihdettu ja remmit tarkistettu. Ruokalan rakennukseen viellä vaihtamatta. Sekä kaksi remmiä pitää uusia',NULL,4,0,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(6,11,NULL,NULL,NULL,'2014-07-03 00:00:00','vaihdettu kaikkiin majoitus rakennuksiin iv suodattimet.<br>Samalla vaihdettu ja säädetty  kaikkiin moottoreihin uudet kiilahihnat jotka hankittu eilen.<br>sekä puhdistettu ilman  imu ritilät rakennuksista.<br> <br><br>',NULL,7,0,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(7,12,NULL,NULL,NULL,'2012-12-19 00:00:00','Lumet aurattu parkkipaikalta ja talojen edestä',NULL,2,0,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(8,12,NULL,NULL,NULL,'2013-02-15 00:00:00','Verkostonpaineet 1.8 bar.',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(9,12,NULL,NULL,NULL,'2013-03-28 00:00:00','Verkoston paineet 1,6 bar.',NULL,0,5,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(10,12,NULL,NULL,NULL,'2013-05-17 00:00:00','Verkoston paineet 1,1 bar.',NULL,0,15,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(11,12,NULL,NULL,NULL,'2013-06-18 00:00:00','Verkoston paineet 1,5 bar.',NULL,1,0,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(12,12,NULL,NULL,NULL,'2013-07-25 00:00:00','Paineet olivat ihan normaalit 1,4 bar.',NULL,0,30,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(13,12,NULL,NULL,NULL,'2013-09-03 00:00:00','Paineet ok.',NULL,0,15,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(14,12,NULL,NULL,NULL,'2013-10-03 00:00:00','paine 1,1 bar.',NULL,0,10,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(15,12,NULL,NULL,NULL,'2013-11-08 00:00:00','Verkostonpaine 1,8 bar',NULL,0,5,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(16,12,NULL,NULL,NULL,'2013-12-18 00:00:00','Verkoston paine 1,5bar. Kv pumput toimii.',NULL,0,30,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(17,12,NULL,NULL,NULL,'2014-01-24 00:00:00','Nostettu verkoston paine 1,1-->1,5bar.',NULL,0,15,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(18,12,NULL,NULL,NULL,'2014-02-27 00:00:00','verkostonpaine 1.2 ok<br>kiertovesipumput toimii',NULL,0,10,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(19,12,NULL,NULL,NULL,'2014-03-26 00:00:00','kiertovesipumput toimii paine 1,5 ',NULL,0,10,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(20,12,NULL,NULL,NULL,'2014-04-23 00:00:00','paineet 1.4 kiertovesipumput toimii',NULL,0,10,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(21,12,NULL,NULL,NULL,'2014-05-14 00:00:00','pumput ok verkostopaine 1.5 bar<br>- Samalla kyytiin otettiin 4 settia vuodevaatteita seuraavaa paivystyskeikkaa varten (kuten palautteessa toivottiin)<br><br>Stata Oy<br>Oskari Rentola<br><br>',NULL,0,25,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NULL),(22,12,NULL,NULL,NULL,'2014-06-11 00:00:00','Pumput tarkistettiin;  kunnossa ovat<br>Verkostopaine 1,5 bar',NULL,0,10,NULL,NULL,NULL,NULL,NULL,0,2,'open','Tuntityöt',NULL,NULL,NULL,NU
82[ERR] 1146 - Table 'optima_dev.timesheets' doesn't exist
83[ERR] 
84INSERT INTO `timesheets` VALUES (23,5,'2012-12-18 08:00:00','2012-12-18 11:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(24,NULL,'2012-12-18 08:00:00','2012-12-18 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(25,NULL,'2012-12-18 08:00:00','2012-12-18 11:00:00',NULL,NULL,0.00,0.44,'meal_compensation',0.00,NULL,1.35,1,7.50),(26,5,'2012-12-19 08:00:00','2012-12-19 09:50:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(27,252,'2012-12-19 08:00:00','2012-12-19 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(28,252,'2012-12-19 08:00:00','2012-12-19 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(29,252,'2012-12-19 08:00:00','2012-12-19 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(30,252,'2012-12-19 08:00:00','2012-12-19 10:00:00',NULL,NULL,0.00,0.44,'meal_compensation',0.00,NULL,1.35,1,7.50),(31,NULL,'2012-12-19 08:00:00','2012-12-19 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(32,NULL,'2012-12-20 08:00:00','2012-12-20 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(33,NULL,'2012-12-20 08:00:00','2012-12-20 09:30:00',NULL,NULL,0.00,0.44,'meal_compensation',0.00,NULL,1.35,1,7.50),(34,5,'2012-12-20 08:00:00','2012-12-20 08:15:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(35,NULL,'2012-12-20 08:00:00','2012-12-20 09:30:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(36,251,'2012-12-20 08:00:00','2012-12-20 08:30:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(37,254,'2012-12-20 08:00:00','2012-12-20 09:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(38,NULL,'2012-12-21 08:00:00','2012-12-21 09:30:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(39,NULL,'2012-12-21 08:00:00','2012-12-21 10:30:00',NULL,NULL,0.00,0.44,'meal_compensation',0.00,NULL,1.35,1,7.50),(40,5,'2012-12-21 08:00:00','2012-12-21 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(41,5,'2012-12-21 08:00:00','2012-12-21 08:05:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(42,5,'2012-12-21 08:00:00','2012-12-21 08:05:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(43,5,'2012-12-21 08:00:00','2012-12-21 08:05:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(44,NULL,'2012-12-21 08:00:00','2012-12-21 11:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(45,NULL,'2012-12-21 08:00:00','2012-12-21 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(46,NULL,'2012-12-21 08:00:00','2012-12-21 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(47,NULL,'2012-12-24 08:00:00','2012-12-24 11:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(48,NULL,'2012-12-25 08:00:00','2012-12-25 11:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(49,NULL,'2012-12-25 08:00:00','2012-12-25 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(50,NULL,'2012-12-25 08:00:00','2012-12-25 13:30:00',NULL,NULL,0.00,0.44,'meal_compensation',0.00,NULL,1.35,1,7.50),(51,NULL,'2012-12-25 08:00:00','2012-12-25 09:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(52,251,'2012-12-25 08:00:00','2012-12-25 09:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(53,251,'2012-12-25 08:00:00','2012-12-25 09:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(54,251,'2012-12-25 08:00:00','2012-12-25 09:30:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(55,251,'2012-12-25 08:00:00','2012-12-25 09:30:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(56,24,'2012-12-25 08:00:00','2012-12-25 10:30:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(57,24,'2012-12-26 08:00:00','2012-12-26 09:30:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(58,24,'2012-12-26 08:00:00','2012-12-26 10:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(59,5,'2012-12-26 08:00:00','2012-12-26 09:20:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(60,5,'2012-12-26 08:00:00','2012-12-26 09:00:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(61,5,'2012-12-26 08:00:00','2012-12-26 09:10:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35,1,7.50),(62,5,'2012-12-26 08:00:00','2012-12-26 08:20:00',NULL,NULL,0.00,0.44,NULL,NULL,NULL,1.35
85[SQL] Finished with error