-- MySQL dump 10.13 Distrib 5.5.27, for FreeBSD9.0 (amd64) -- -- Host: 127.0.0.1 Database: ale -- ------------------------------------------------------ -- Server version 5.5.27-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 `C` -- DROP TABLE IF EXISTS `C`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `C` ( `C_id` int(11) NOT NULL AUTO_INCREMENT, `Firstname` varchar(50) NOT NULL, `Lastname` varchar(50) NOT NULL, PRIMARY KEY (`C_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `C` -- LOCK TABLES `C` WRITE; /*!40000 ALTER TABLE `C` DISABLE KEYS */; INSERT INTO `C` VALUES (1,'Aleksi','Mantila'),(2,'Juha','Tiikkainen'),(3,'Nikolas','Mantila'); /*!40000 ALTER TABLE `C` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `F` -- DROP TABLE IF EXISTS `F`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `F` ( `F_id` int(11) NOT NULL AUTO_INCREMENT, `U_id` int(11) NOT NULL, `P_id` int(11) NOT NULL, PRIMARY KEY (`F_id`), KEY `id` (`F_id`) ) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `F` -- LOCK TABLES `F` WRITE; /*!40000 ALTER TABLE `F` DISABLE KEYS */; INSERT INTO `F` VALUES (22,1,13),(24,2,13),(35,1,1001),(36,2,1001),(37,1,1013),(38,2,1013),(39,1,1014),(40,2,1014),(41,1,1015),(42,2,1015),(43,1,1016),(44,2,1016),(45,1,1017),(46,1,1018),(47,2,1018),(48,1,1019),(49,2,1019),(50,1,1020),(51,2,1020),(52,1,1021),(53,2,1021),(54,1,9),(55,1,1022),(56,2,1022),(57,1,1023),(58,2,1023),(59,1,1027),(60,2,1027),(61,1,1026),(62,2,1026),(63,1,1025),(64,2,1025),(65,1,1028),(66,2,1028),(67,1,1029),(68,1,1030),(69,1,1031),(70,3,1028),(71,1,1032),(72,2,1032),(73,3,1032),(74,1,11001),(75,1,11003),(76,2,11003),(77,3,11003),(78,1,11004),(79,1,11002); /*!40000 ALTER TABLE `F` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `L` -- DROP TABLE IF EXISTS `L`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `L` ( `L_id` int(11) NOT NULL AUTO_INCREMENT, `LG_id` int(11) NOT NULL, `LG_id_Main` smallint(6) NOT NULL, `nro` varchar(10) NOT NULL, `toimittaja` varchar(20) NOT NULL, `merkki` varchar(20) NOT NULL, `tnro` varchar(15) NOT NULL, `yleisnimi` varchar(25) NOT NULL, `tarkenne` varchar(25) NOT NULL, `kauppanimi` varchar(70) NOT NULL, `ean` varchar(40) NOT NULL, `img` varchar(200) NOT NULL, `ohjehinta` float NOT NULL, `ostohinta` float NOT NULL, PRIMARY KEY (`L_id`) ) ENGINE=InnoDB AUTO_INCREMENT=301 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `L` -- LOCK TABLES `L` WRITE; /*!40000 ALTER TABLE `L` DISABLE KEYS */; INSERT INTO `L` VALUES (23,15,1,'1152190','ABB Oy','ABB Asennustuotteet','','Korotusrengas','AK7, jakorasialle 13mm','Korotusrengas AK7, jakorasialle 13mm','6410011521908','img/labels/1152190.jpg',0,0),(24,15,1,'1152315','ABB Oy','ABB Asennustuotteet','','Kojerasia','AU6.2, matala, syvyys 38m','Kojerasia AU6.2, matala, syvyys 38mm','6410011523155','img/labels/1152315.jpg',0,0),(26,15,1,'1152366','ABB Oy','ABB Asennustuotteet','','Kojerasia','AU5.32, korkeus 73mm','Kojerasia AU5.32, korkeus 73mm','6418677335068','img/labels/1152366.jpg',0,0),(28,15,1,'1152390','ABB Oy','ABB Asennustuotteet','','Korotusrengas','PMR94, kojerasioille 13mm','Korotusrengas PMR94, kojerasioille 13mm','6410011523902','img/labels/1152390.jpg',0,0),(30,15,1,'1152397','ABB Oy','ABB Asennustuotteet','','Korotusrengas','PMR399, kojerasioille 60m','Korotusrengas PMR399, kojerasioille 60mm','6410011523971','img/labels/1152397.jpg',0,0),(31,15,0,'1152578','ABB Oy','ABB Asennustuotteet','','Nysä','AS12, vedonpoistajanysä','Nysä AS12, vedonpoistajanysä','6410011525784','img/labels/1152578.jpg',0.7,0.3),(38,15,1,'1152777','ABB Oy','ABB Asennustuotteet','','Rasiatuki','PMR577.65, 42 – 65 mm','Rasiatuki PMR577.65, 42 – 65 mm','6418677307256','img/labels/1152777.jpg',0,0),(45,15,1,'1152725','ABB Oy','ABB Asennustuotteet','','Nysä','AN25, Ø 25mm','Nysä AN25, Ø 25mm','6410011527252','img/labels/1152725.jpg',0,0),(51,15,1,'1152119','ABB Oy','ABB Asennustuotteet','','Jakorasia','AU19, Irtonysäjakorasia','Jakorasia AU19, Irtonysäjakorasia','6410011521199','img/labels/1152119.jpg',0,0),(52,15,0,'1152364','ABB Oy','ABB Asennustuotteet','','Kojerasia','AU3.2, irtonysärasia','Kojerasia AU3.2, irtonysärasia','6410011523643','img/labels/1152364.jpg',5,3),(53,15,1,'1152367','ABB Oy','ABB Asennustuotteet','','Kojerasia','AU3.32, tiiliseinäkojera','Kojerasia AU3.32, tiiliseinäkojerasia','6410011523674','img/labels/1152367.jpg',0,0),(54,15,1,'1152396','ABB Oy','ABB Asennustuotteet','','Korotusrengas','PMR410, kojerasioille 28m','Korotusrengas PMR410, kojerasioille 28mm','6410011523964','img/labels/1152396.jpg',0,0),(55,15,1,'1152722','ABB Oy','ABB Asennustuotteet','','Nysä','ANK20, kulmanysä Ø 20mm','Nysä ANK20, kulmanysä Ø 20mm','6410011527221','img/labels/1152722.jpg',0,0),(56,15,1,'1152754','ABB Oy','ABB Asennustuotteet','','Nysä','AN16, Ø 16mm','Nysä AN16, Ø 16mm','6410011527542','img/labels/1152754.jpg',0,0),(57,15,1,'1152757','ABB Oy','ABB Asennustuotteet','','Nysä','AN20, Ø20mm','Nysä AN20, Ø20mm','6410011527573','img/labels/1152757.jpg',0,0),(58,15,1,'1152774','ABB Oy','ABB Asennustuotteet','','Rasialiitoskappale','PMR474, C/C 71 mm','Rasialiitoskappale PMR474, C/C 71 mm','6410011527740','img/labels/1152774.jpg',0,0),(59,15,1,'1152776','ABB Oy','ABB Asennustuotteet','','Rasiatuki','PMR577, 42 – 90 mm','Rasiatuki PMR577, 42 – 90 mm','6410011527764','img/labels/1152776.jpg',0,0),(60,15,1,'1152788','ABB Oy','ABB Asennustuotteet','','Rasialiitoskappale','PMR490, C/C 85 mm','Rasialiitoskappale PMR490, C/C 85 mm','6410011527887','img/labels/1152788.jpg',0,0),(61,15,1,'1152792','ABB Oy','ABB Asennustuotteet','','Rasialiitoskappale','PMR502, C/C 100 mm','Rasialiitoskappale PMR502, C/C 100 mm','6410011527924','img/labels/1152792.jpg',0,0),(62,8,1,'2506122','ABB Oy','ABB Asennustuotteet','302EUC','Pistorasia','2S/16A/IP21 UKJ HL VAL','Pistorasia, Jussi, 2-os, maad, jousiliittimin, haaroitusliittimet','6418677310393','img/labels/2506122.jpg',0,0),(63,8,1,'2506131','ABB Oy','ABB Asennustuotteet','20EUCKS-212','Pistorasia','1S/16A/IP21 UKJ 0X VAL','Pistorasia, Jussi, 1-os, maad, jousiliittimin','6410025061315','img/labels/2506131.jpg',0,0),(64,8,1,'2506422','ABB Oy','ABB Asennustuotteet','302EUJ','Pistorasia','2S/16A/IP21 UPJ HL VAL','Pistorasia, Jussi, 2-os, maad, jousiliittimin, haaroitusliittimet','6418677310409','img/labels/2506422.jpg',0,0),(65,8,1,'2506431','ABB Oy','ABB Asennustuotteet','20EUJKS-212','Pistorasia','1S/16A/IP21 UPJ 0X VAL','Pistorasia, Jussi, 1-os, maad, jousiliittimin','6410025064316','img/labels/2506431.jpg',0,0),(66,9,1,'2106012','ABB Oy','ABB Asennustuotteet','1062U','Kytkin','2/16AX/250V/IP21 UKJ 2X V','Kytkin 2, Jussi, 2 lisäliitintä´, 1/0 merkintä','6410021060121','img/labels/2106012.jpg',0,0),(67,9,1,'2106016','ABB Oy','ABB Asennustuotteet','1066U','Kytkin','6/16AX/250V/IP21 UKJ 2X V','Kytkin 6, Jussi, 2 lisäliitintä','6410021060169','img/labels/2106016.jpg',0,0),(68,9,1,'2106017','ABB Oy','ABB Asennustuotteet','1067U','Kytkin','7/16AX/250V/IP21 UKJ 2X V','Kytkin 7, Jussi, 2 lisäliittintä','6410021060176','img/labels/2106017.jpg',0,0),(69,9,1,'2106018','ABB Oy','ABB Asennustuotteet','10666U','Kytkin','6+6/16AX/250V/IP21 UKJ 0X','Kytkin 6+6, Jussi, ei lisäliittimiä','6410021060183','img/labels/2106018.jpg',0,0),(70,9,1,'2106019','ABB Oy','ABB Asennustuotteet','10631U','Kytkin','1+1+1/16AX/250V/IP21 UKJ ','Kytkin 1+1+1, Jussi, ei lisäliittimiä','6410021060190','img/labels/2106019.jpg',0,0),(71,9,1,'2106065','ABB Oy','ABB Asennustuotteet','1065U.1','Kytkin','5/16AX/250V/IP21 UKJ 2X V','Kytkin 5, Jussi, 2 lisäliitintä','6410021060657','img/labels/2106065.jpg',0,0),(72,9,1,'2126011','ABB Oy','ABB Asennustuotteet','1466U','Painike','6/10A/250V/IP21 UKJ 1N LI','Painike 6, Jussi, N-liitin, kirkas merkkivalo, ei sisällä lamppua','6410021260118','img/labels/2126011.jpg',0,0),(73,9,1,'2126013','ABB Oy','ABB Asennustuotteet','1465U','Painike','5/10A/250V/IP21 UKJ 0X VA','Painike 5, Jussi, ei lisäliittimiä','6410021260132','img/labels/2126013.jpg',0,0),(74,10,1,'2166111','ABB Oy','ABB Asennustuotteet','2511','Peitelevy','1OS/IP21/85mm VAL','Peitelevy, Jussi, 85mm, 1-aukkoinen','6410021661113','img/labels/2166111.jpg',0,0),(75,10,1,'2166112','ABB Oy','ABB Asennustuotteet','2512','Peitelevy','2OS/IP21/85mm VAL','Peitelevy, Jussi, 85mm, 2-aukkoinen','6410021661120','img/labels/2166112.jpg',0,0),(76,10,1,'2166113','ABB Oy','ABB Asennustuotteet','2513','Peitelevy','3OS/IP21/85mm VAL','Peitelevy, Jussi, 85mm, 3-aukkoinen','6410021661137','img/labels/2166113.jpg',0,0),(77,10,1,'2166114','ABB Oy','ABB Asennustuotteet','2514','Peitelevy','4OS/IP21/85mm VAL','Peitelevy, Jussi, 85mm, 4-aukkoinen','6410021661144','img/labels/2166114.jpg',0,0),(78,10,1,'2166115','ABB Oy','ABB Asennustuotteet','2515','Peitelevy','5OS/IP21/85mm VAL','Peitelevy, Jussi, 85mm, 5-aukkoinen','6410021661151','img/labels/2166115.jpg',0,0),(79,10,1,'2166121','ABB Oy','ABB Asennustuotteet','2521-100','Peitelevy','1OS/IP21/100mm VAL','Peitelevy, Jussi, 100mm, 1-aukkoinen','6410021661212','img/labels/2166121.jpg',0,0),(80,10,1,'2166122','ABB Oy','ABB Asennustuotteet','2522-100','Peitelevy','2OS/IP21/100mm VAL','Peitelevy, Jussi, 100mm, 2-aukkoinen','6410021661229','img/labels/2166122.jpg',0,0),(81,10,1,'2166123','ABB Oy','ABB Asennustuotteet','2523-100','Peitelevy','3OS/IP21/100mm VAL','Peitelevy, Jussi, 100mm, 3-aukkoinen','6410021661236','img/labels/2166123.jpg',0,0),(82,10,1,'2166124','ABB Oy','ABB Asennustuotteet','2524-100','Peitelevy','4OS/IP21/100mm VAL','Peitelevy, Jussi, 100mm, 4-aukkoinen','6410021661243','img/labels/2166124.jpg',0,0),(83,10,1,'2166125','ABB Oy','ABB Asennustuotteet','2525-100','Peitelevy','5OS/IP21/100mm VAL','Peitelevy, Jussi, 100mm, 5-aukkoinen','6410021661250','img/labels/2166125.jpg',0,0),(84,10,1,'2166162','ABB Oy','ABB Asennustuotteet','2522','Peitelevy','1OS+1/IP21/85mm VAL','Peitelevy, Jussi, 85mm, 1+1-aukkoinen','6410021661625','img/labels/2166162.jpg',0,0),(85,10,1,'2166163','ABB Oy','ABB Asennustuotteet','2523','Peitelevy','2OS+1/IP21/85mm VAL','Peitelevy, Jussi, 85mm, 1+2-aukkoinen','6410021661632','img/labels/2166163.jpg',0,0),(86,10,1,'2166164','ABB Oy','ABB Asennustuotteet','2524','Peitelevy','3OS+1/IP21/85mm VAL','Peitelevy, Jussi, 85mm, 1+3-aukkoinen','6410021661649','img/labels/2166164.jpg',0,0),(87,10,1,'2166165','ABB Oy','ABB Asennustuotteet','2525','Peitelevy','4OS+1/IP21/85mm VAL','Peitelevy, Jussi, 85mm, 1+4-aukkoinen','6410021661656','img/labels/2166165.jpg',0,0),(88,7,1,'7060570','ABB Oy','ABB Asennustuotteet','2531','Keskiölevy','Antenni, TV-R','Keskiölevy, Jussi, antenni, TV-R','6410070605700','img/labels/7060570.jpg',0,0),(89,7,1,'7204065','ABB Oy','ABB Asennustuotteet','FOT6208','Telerasia','2xRJ-45, Cat6 UTP','Telerasia, Jussi, 2xRJ-45, Cat6, suojaamaton','6418677326493','img/labels/7204065.jpg',0,0),(90,7,0,'7541622','Laatuantenni Oy','Laatuantenni','LARS 01','Antennirasia','LARS 01 Päättyvä ant.r','LARS 01, 5-1000 MHz, päättyvä 1db','6410075416226','img/labels/7541622.',0,0),(91,7,0,'7541623','Laatuantenni Oy','Laatuantenni','LARS 02','Antennirasia','LARS 02 Päättyvä ant.r','LARS 02, 5-2150 ja 5-1000 MHz, päättyvä 1db','6410075416233','img/labels/7541623.',0,0),(92,18,1,'7204064','ABB Oy','ABB Asennustuotteet','CEL30.U6','Liitin','RJ-45, Cat6, suojaamaton','Liitin, RJ-45, Cat6, suojaamaton','6418677326486','img/labels/7204064.jpg',0,0),(93,18,1,'7500216','Triax A/S','Triax','153264','Liitin','F-Push on liitin KOKA 6/8','Työnnettävä F-liitin KOKA 6/80/500','5702661532641','img/labels/7500216.jpg',0,0),(94,6,1,'1152521','ABB Oy','ABB Asennustuotteet','','Rasiakansi','AK1.1, jakorasian peiteka','Rasiakansi AK1.1, jakorasian peitekansi','6410011525210','img/labels/1152521.jpg',0,0),(95,6,1,'1152535','ABB Oy','ABB Asennustuotteet','','Rasiakansi','AK5, kojerasialle IP20','Rasiakansi AK5, kojerasialle IP20','6410011525357','img/labels/1152535.jpg',0,0),(96,6,1,'1152560','ABB Oy','ABB Asennustuotteet','','Rasiakansi','AK11, jakorasialle IP44','Rasiakansi AK11, jakorasialle IP44','6410011525609','img/labels/1152560.jpg',0,0),(97,5,1,'7003530','Novar GmbH','Friedland','D723','Ovikellopainike','PUSHLITE musta painike','Muovinen valaistulla B1204N painikkeella','6410070035309','img/labels/7003530.jpg',0,0),(98,5,1,'7025060','Novar GmbH','Friedland','D3230','Ovikello','Big Ben ovikello muuntaja','Big Ben, sis. muuntajalla 230VAC/8V 0.8A, valkoinen, 80 dB(A), 171x10','6410070250603','img/labels/7025060.jpg',0,0),(99,5,1,'7025243','Novar GmbH','Friedland','D723W','Ovikellopainike','PUSHLITE valkoinen painik','Muovinen valaistulla B1204N painikkeella','6410070252430','img/labels/7025243.jpg',0,0),(100,7,1,'1152512','ABB Oy','ABB Asennustuotteet','','Valaisinpistorasia','AKK13, 1-luokka, pinta','Valaisinpistorasia AKK13, 1-luokka, pinta','6410011525128','img/labels/1152512.jpg',0,0),(101,7,1,'1152513','ABB Oy','ABB Asennustuotteet','','Valaisinpistorasia','AKK13J, 1-luokka, uppo','Valaisinpistorasia AKK13J, 1-luokka, uppo','6410011525135','img/labels/1152513.jpg',0,0),(102,5,1,'1150170','Schneider Electric F','Schneider Electric','201499000','Jakorasia','RJE06 ETUKIINNITYKSELLÄ ','RJE 06 jakorasia levyseiniin','6410011501702','img/labels/1150170.jpg',0,0),(103,5,1,'1150413','Schneider Electric F','Schneider Electric','WDE0060010','Kojerasia','RKE06 ETUKIINNITYS K-RAS ','RKE06 etukiinnityskojerasia halogeenivapaa.','6410011504130','img/labels/1150413.jpg',0,0),(104,5,1,'7111995','Kamic Installation O','Kamic Installation','KI-10B','Palovaroitin optinen','KI-10B Optinen 230V','KI-10B Optinen 230V Palovaroitin paristovarmennuksella','6410071119954','img/labels/7111995.jpg',0,0),(105,5,1,'1152563','ABB Oy','ABB Asennustuotteet','','Rasiakansi','AK12.1, jakorasialle IP20','Rasiakansi AK12.1, jakorasialle IP20','6410011525630','img/labels/1152563.jpg',0,0),(106,5,1,'1152565','ABB Oy','ABB Asennustuotteet','','Rasiakansi','AK12.2, liitäntäkansi, ','Rasiakansi AK12.2, liitäntäkansi, IP44','6418677311680','img/labels/1152565.jpg',0,0),(107,5,1,'1152575','ABB Oy','ABB Asennustuotteet','','Rasiakansi','AK4, liitäntäkansi','Rasiakansi AK4, liitäntäkansi','6410011525753','img/labels/1152575.jpg',0,0),(108,5,1,'0400840','Prysmian Finland Oy','Draka','','Kumikaapeli','DRAKAFLEX H07RN-F 5G2,5 P','DRAKAFLEX H07RN-F 5G2,5 450/750V ProPac-pakkaus','6410004008409','img/labels/0400840.',0,0),(109,5,1,'0405216','Onninen Oy','Onninen','H07RN-F 7G1,5 R','Kumikaapeli','H07RN-F 7G1,5 R50','Kumikaapeli H07RN-F 7G1,5 R50','6410004052167','img/labels/0405216.',0,0),(110,6,1,'2406576','ABB Oy','ABB Asennustuotteet','20ESW','Pistorasia','1S/16A/IP55 PPJ 0X VAL','Pistorasia, Kosti, 1-osainen, maad, jousiliittimin','6418677334603','img/labels/2406576.jpg',0,0),(111,6,1,'2406577','ABB Oy','ABB Asennustuotteet','402ESW','Pistorasia','2S/16A/IP55 PPJ 1X VAL','Pistorasia, Kosti, 2-os, maad, jousiliittimin, haaroitusliittimet','6418677334580','img/labels/2406577.jpg',0,0),(112,6,1,'2516132','ABB Oy','ABB Asennustuotteet','302EUG','Pistorasia','2S/16A/IP44 UPJ HL VAL','Pistorasia, Kosti, 2-osainen, maad, jousiliittimin, haaroitusliittimet','6418677331398','img/labels/2516132.jpg',0,0),(113,5,0,'2603001','Nylund Group Oy Ab','Luxomat','97002','Liiketunnistin','RC-plus 230 next IP54 va','Luxomat Liiketunnistin 230° valvonta-alueella','6410026030013','img/labels/2603001.jpg',0,0),(114,5,0,'2603004','Nylund Group Oy Ab','Luxomat','97001','Liiketunnistin','RC-plus 130 next IP54 va','Luxomat Liiketunnistin 130° valvonta-alueella','6410026030044','img/labels/2603004.jpg',0,0),(115,5,0,'2603007','Nylund Group Oy Ab','Luxomat','97003','Liiketunnistin','RC-plus 280 next IP54 va','Luxomat Liiketunnistin 280° valvonta-alueella','6410026030075','img/labels/2603007.jpg',0,0),(116,5,1,'3514126','Gycom Finland Oy','Theben','1260700','Hämäräkytkin','LUNA 126','Hämäräkytkin LU 126, pinta as., 16A, 5-200lx','4003468126004','img/labels/3514126.jpg',0,0),(117,5,1,'3515018','Nylund Group Oy Ab','Luxomat','10310009','Liiketunnistin','PD3-1C-AP','Luxomat kattoonasennettava liikkeentunnistin. Valvonta-alue 360°, hal','6410035150184','img/labels/3515018.jpg',0,0),(118,5,1,'3600477','Katko Oy','Katko','','Turvakytkin','KUM 332U','Turvakytkin KUM 332U','6419410302200','img/labels/3600477.jpg',0,0),(119,5,1,'3601585','ABB Oy','ABB Pj-kojeet','BWS316FTPN','Turvakytkin','BWS316FTPN,7,5kW 3-nap IP','Turvakytkin muovi harmaa 3-nap sivustaohjattava 7,5kW/400V, ei apukos','7392696424424','img/labels/3601585.',0,0),(120,5,1,'3603088','Katko Oy','Katko','','Turvakytkin EMC','KUM 363U 1.V / EMC','Turvakytkin EMC KUM 363U 1.V / EMC','6419410301562','img/labels/3603088.jpg',0,0),(121,5,1,'0106006','Reka Kaapeli Oy','Reka Kaapeli','','Kuparijohdin','HK 16 R50','Kuparijohdin HK 16 R50','6410001060066','img/labels/0106006.jpg',0,0),(122,5,1,'0235739','Nexans Sweden Ab','Nexans','37157443','Telekaapeli sisä','KLMA 4x0,8 150m rengas','KLMA 4x0,8 150m rengas','6410002357394','img/labels/0235739.',0,0),(123,5,1,'0404818','Hedtec Oy Ab','Kabelwerk EUPEN','9863084','Asennusjohto','MKEM 25 KEVI JOHDIN a100m','Asennusjohto MKEM 25 KEVI JOHDIN a100m','5413260196782','img/labels/0404818.jpg',0,0),(124,5,1,'0480999','','','','Asennuskaapeli','MMJ 3x1,5 N','MMJ 3X1,5 N','6410004064221','img/labels/0406422.jpg',0,0),(125,5,1,'0406442','Prysmian Finland Oy','Draka','','Asennuskaapeli','MMJ 5x1,5 N R100','MMJ 5X1,5N','6410004064429','img/labels/0406442.jpg',0,0),(126,5,1,'0406722','Prysmian Finland Oy','Draka','','Asennuskaapeli','MMJ 3x1,5 S R100','MMJ 3x1,5S','6410004067222','img/labels/0406722.jpg',0,0),(127,5,1,'0406723','Prysmian Finland Oy','Draka','','Asennuskaapeli','MMJ 3x2,5 S R100','MMJ 3x2,5S','6410004067239','img/labels/0406723.jpg',0,0),(128,5,1,'0406742','Prysmian Finland Oy','Draka','','Asennuskaapeli','MMJ 5x1,5 S R100','MMJ 5x1,5S','6410004067420','img/labels/0406742.jpg',0,0),(129,5,1,'0406743','Prysmian Finland Oy','Draka','','Asennuskaapeli','MMJ 5x2,5 S R50','MMJ 5x2,5S','6410004067437','img/labels/0406743.jpg',0,0),(130,5,1,'0481018','','','','Asennuskaapeli','MMJ 5x10 S','MMJ 5x10 S','','img/labels/0406746.jpg',0,0),(131,5,1,'0421522','Hedtec Oy Ab','Sami','N07SS-R 3X1,5','Asennuskaapeli','SSJ 3X1,5S ASENNUSKAAP. K','SSJ 3X1,5S ASENNUSKAAPELI a500m','6410004215227','img/labels/0421522.jpg',0,0),(132,5,1,'0454768','Hedtec Oy Ab','Kabelwerk EUPEN','9860080','Asennusjohto','MKEM 6 KEVI JOHDIN a500m','Asennusjohto MKEM 6 KEVI JOHDIN a500m','5413260226434','img/labels/0454768.jpg',0,0),(133,20,1,'1102520','Purso Oy','Purso','','Asennusputki metalli','PPU 20','Asennusputki metalli PPU 20','6410011025208','img/labels/1102520.',0,0),(134,20,1,'1102525','Purso Oy','Purso','','Asennusputki metalli','PPU 25','Asennusputki metalli PPU 25','6410011025253','img/labels/1102525.',0,0),(135,20,1,'1131017','All-Plast Oy Ab','Allplast','','Putkenpääte','JAPP-20,JPP-20,P-17,8','Putkenpääte JAPP-20,JPP-20,P-17,8','6410011310175','img/labels/1131017.',0,0),(136,20,1,'1131022','All-Plast Oy Ab','Allplast','','Putkenpääte','JAPP-25,JPP-25,JP-25,PLM-','Putkenpääte JAPP-25,JPP-25,JP-25,PLM-29','6410011310229','img/labels/1131022.',0,0),(137,20,1,'1308820','Sormat Oy','Sormat','17402','Putkikiinnike','ALKI 20 alumiini','Alumiinikiinnike Ø20 mm putkelle, kiinnitysreikä = 6 x 4 mm','6416031174025','img/labels/1308820.jpg',0,0),(138,20,1,'1308825','Sormat Oy','Sormat','17403','Putkikiinnike','ALKI 25 alumiini','Alumiinikiinnike Ø25 mm putkelle, kiinnitysreikä = 6 x 4 mm','6416031174032','img/labels/1308825.jpg',0,0),(139,11,1,'0602111','Prysmian Finland Oy','Draka','','Asennusvoimakaapeli','MCMK 2x1,5/1,5 PK200','MCMK 2X1,5/1,5 0,6/1kV Pienkela','6410006021116','img/labels/0602111.jpg',0,0),(140,11,1,'0602113','Prysmian Finland Oy','Draka','','Asennusvoimakaapeli','MCMK 2x2,5/2,5 R100','MCMK 2X2,5/2,5 0,6/1kV Kelmupakkaus','6410006021130','img/labels/0602113.jpg',0,0),(141,11,1,'0602143','Prysmian Finland Oy','Draka','','Asennusvoimakaapeli','MCMK 4x2,5/2,5 K9/1000','MCMK 4X2,5/2,5 0,6/1kV K9/1000','6410006021437','img/labels/0602143.jpg',0,0),(143,11,1,'0602172','Prysmian Finland Oy','Draka','','Asennusvoimakaapeli','MCMK 4x1,5/1,5 K8/1000','MCMK 4X1,5/1,5 0,6/1kV K8/1000','6410006021727','img/labels/0602172.jpg',0,0),(144,1,0,'0264070','','','','','','2x4p cat6','','',0,0),(145,11,1,'0603131','Reka Kaapeli Oy','Reka Kaapeli','','Asennusvoimakaapeli','MCMK 4x10/10 F2 K500','Asennusvoimakaapeli MCMK 4x10/10 F2 K500','6410006031313','img/labels/0603131.jpg',0,0),(146,11,1,'0603134','Reka Kaapeli Oy','Reka Kaapeli','','Asennusvoimakaapeli','MCMK 4x16/16 F2 K500','Asennusvoimakaapeli MCMK 4x16/16 F2 K500','6410006031344','img/labels/0603134.jpg',0,0),(147,11,1,'0626213','Reka Kaapeli Oy','Reka Kaapeli','','Alumiinivoimakaapeli','AXMK 4X120S K1000','Alumiinivoimakaapeli AXMK 4X120S K1000','6410006262137','img/labels/0626213.jpg',0,0),(148,11,1,'0626215','Reka Kaapeli Oy','Reka Kaapeli','','Alumiinivoimakaapeli','AXMK 4X185S K500','Alumiinivoimakaapeli AXMK 4X185S K500','6410006262151','img/labels/0626215.jpg',0,0),(150,5,1,'0404808','Hedtec Oy Ab','Kabelwerk EUPEN','H07V-K 16 DB','Asennusjohto','MKEM 16 KEVI JOHDIN R100','MKEM 16 KELTAVIHREÄ JOHDIN 100M NIPPU','5413260196560','img/labels/0404808.jpg',0,0),(151,5,1,'1449311','Meka Pro Oy','Meka','','Valaisinkisko','MEK 70 K','Valaisinkisko MEK 70 K','6410014493110','img/labels/1449311.jpg',0,0),(152,5,1,'1449351','Meka Pro Oy','Meka','','Jatkokappale','MEK J-70','Jatkokappale MEK J-70','6410014493516','img/labels/1449351.jpg',0,0),(153,5,1,'1449356','Meka Pro Oy','Meka','','Kattokannake','MEK RK-70','Kattokannake MEK RK-70','6410014493561','img/labels/1449356.jpg',0,0),(154,1,0,'##','','','','','','FRHF 2x6','','',0,0),(155,21,1,'1441940','Nordic Aluminium','DUCTEL Twist','TB1010-3','Johtokanava','TB1010-3 Al 100x65x3000 V','Johtokanava TB1010-3 Al 100x65x3000 VAL','6410014419400','img/labels/1441940.jpg',0,0),(156,21,1,'1441942','Nordic Aluminium','DUCTEL Twist','TB1310-3','Johtokanava','TB1310-3 Al 135x65x3000 V','Johtokanava TB1310-3 Al 135x65x3000 VAL','6410014419424','img/labels/1441942.jpg',0,0),(157,21,1,'1441943','Nordic Aluminium','DUCTEL Twist','TB1340-3','Johtokanava','TB1340-3 Al 135x65x3000 V','Johtokanava TB1340-3 Al 135x65x3000 VAL','6410014419431','img/labels/1441943.jpg',0,0),(158,21,1,'1449472','Meka Pro Oy','Meka','','Keskikannatin','HK 13-210, KS20/KS30 VRT','Keskikannatin HK 13-210, KS20/KS30 VRT','6410014494728','img/labels/1449472.jpg',0,0),(159,21,1,'1449473','Meka Pro Oy','Meka','','Keskikannatin','HK 13-310, KS/KS VRT','Keskikannatin HK 13-310, KS/KS VRT','6410014494735','img/labels/1449473.jpg',0,0),(160,21,1,'1449475','Meka Pro Oy','Meka','','Keskikannatin','HK 13-510 , KS20/KS30 VR','Keskikannatin HK 13-510 , KS20/KS30 VRT','6410014494759','img/labels/1449475.jpg',0,0),(161,21,1,'1449479','Meka Pro Oy','Meka','','Seinäkannake','VK 2 , KS/KS30 VRT','Seinäkannake VK 2 , KS/KS30 VRT','6410014494797','img/labels/1449479.jpg',0,0),(162,21,1,'1449482','Meka Pro Oy','Meka','','Jatkokappale','SSR , KS20/KS30 VRT','Jatkokappale SSR , KS20/KS30 VRT','6410014494827','img/labels/1449482.jpg',0,0),(163,21,1,'1449486','Meka Pro Oy','Meka','','Kiinnitystarvike','KK , KS20/KS30 VRT','Kiinnitystarvike KK , KS20/KS30 VRT','6410014494865','img/labels/1449486.jpg',0,0),(164,21,1,'1449502','Meka Pro Oy','Meka','','Tikashylly','KS20-200','Tikashylly KS20-200','6410014495022','img/labels/1449502.jpg',0,0),(165,21,1,'1449503','Meka Pro Oy','Meka','KS20-300','Tikashylly','KS20-300 Fe 300x60x6000 K','Kuumasinkitty ohutlevy','6410014495039','img/labels/1449503.jpg',0,0),(166,21,1,'1449505','Meka Pro Oy','Meka','','Tikashylly','KS20-500','Tikashylly KS20-500','6410014495053','img/labels/1449505.jpg',0,0),(167,21,1,'1449591','Meka Pro Oy','Meka','','Seinäkannake','VK-200','Seinäkannake VK-200','6410014495916','img/labels/1449591.jpg',0,0),(168,21,1,'1449592','Meka Pro Oy','Meka','','Seinäkannake','VK-300','Seinäkannake VK-300','6410014495923','img/labels/1449592.jpg',0,0),(169,21,1,'1449594','Meka Pro Oy','Meka','','Seinäkannake','VK-500','Seinäkannake VK-500','6410014495947','img/labels/1449594.jpg',0,0),(170,6,1,'1612509','ABB Oy','ABB Asennustuotteet','','Jakorasia','AP9, 86x86mm,VAL, IP65','Jakorasia AP9, 86x86mm,VAL, IP65','6410016125095','img/labels/1612509.jpg',0,0),(171,1,0,'##','','','','','','läsnäolotunnistin','','',0,0),(172,7,1,'2166015','ABB Oy','ABB Asennustuotteet','2538-212','Keskiölevy','Umpi, ruuvikiinnitys','Keskiölevy, Jussi, umpi, ruuvikiinnitys','6410021660154','img/labels/2166015.jpg',0,0),(173,7,1,'2406131','ABB Oy','ABB Asennustuotteet','20EAKS','Pistorasia','1S/16A/IP21 PPJ 0X VAL','Pistorasia, Jussi, 1-osainen, maad, jousiliittimet','6410024061316','img/labels/2406131.jpg',0,0),(174,7,1,'2406578','ABB Oy','ABB Asennustuotteet','402EA','Pistorasia','2S/16A/IP21 PPJ HL VAL','Pistorasia, Jussi, 2-osainen, maadoitettu, jousiliittimet','6418677335815','img/labels/2406578.jpg',0,0),(175,7,1,'2406579','ABB Oy','ABB Asennustuotteet','404EA','Pistorasia','4S/16A/IP21 PPJ HL VAL','Pistorasia, Jussi, 4-osainen, maadoitettu, jousiliittimet','6418677335822','img/labels/2406579.jpg',0,0),(176,1,0,'0232186','','','','','','Tellu 13','','',0,0),(177,1,0,'##','','','','','','putki 50mm maakapeleille','','',0,0),(178,11,1,'0242901','Prysmian Finland Oy','Draka','','Valokaapeli maa','FYO2PMU FTTH 4xSML','FYO2PMU FTTH 4xSML','6410002429015','img/labels/0242901.jpg',0,0),(179,11,1,'0244626','DKT Finland Oy','Cavel','Cavel','Antennikaapeli maa','DKT 17/73FC/250/PE','Maakaapeli, 1.63/7.2 Ø 10.1mm, 11.8dB/100m@862MHz','5703475006168','img/labels/0244626.',0,0),(180,11,1,'0264022','Prysmian Finland Oy','Draka','','Tietoverkkokaapeli-CAT6','SuperCat 6 ALPE U/UTP 4p ','SuperCat 6 ALPE (F-)U/UTP 4p <75V Pienkela Cat.6 (SUPERCAT 1000 ARM)','6410002640229','img/labels/0264022.',0,0),(181,1,0,'0404808','','','','','','MK 16 kevi','','',0,0),(182,1,0,'0481017','','','','','','MMJ 5x6','','',0,0),(183,6,1,'2006519','ABB Oy','ABB Asennustuotteet','1062SW','Kytkin','2/16AX/250V/IP44 PPJ 2X L','Kytkin 2, Kosti, 2 lisäliitintä, punainen linssi, 1/0, ei sisällä ','6418677334535','img/labels/2006519.jpg',0,0),(184,6,1,'2006520','ABB Oy','ABB Asennustuotteet','1065SW','Kytkin','5/16AX/250V/IP44 PPJ 2X V','Kytkin 5, Kosti, 2 lisäliitintä','6418677334542','img/labels/2006520.jpg',0,0),(185,6,1,'2006521','ABB Oy','ABB Asennustuotteet','1066SW','Kytkin','6/16AX/250V/IP44 PPJ 2X L','Kytkin 6, Kosti, 2 lisäliitintä, kirkas linssi, ei sisällä lamppua','6418677334559','img/labels/2006521.jpg',0,0),(186,6,1,'2006522','ABB Oy','ABB Asennustuotteet','1067SW','Kytkin','7/16AX/250V/IP44 PPJ 2X L','Kytkin 7, Kosti, 2 lisäliitintä, kirkas linssi, ei sisällä lamppua','6418677334566','img/labels/2006522.jpg',0,0),(187,6,1,'1612518','ABB Oy','ABB Asennustuotteet','AP7.1','Liitäntärasia','AP7.1, Ø115mm VAL IP44','Liitäntärasia AP7.1, Ø115mm VAL IP44','6410016125187','img/labels/1612518.jpg',0,0),(188,6,1,'2006524','ABB Oy','ABB Asennustuotteet','1065A4','Kytkin','5/16AX/250V/IP21 PPJ 2X V','Kytkin 5, Jussi, 2 lisäliitintä','6418677307461','img/labels/2006524.jpg',0,0),(189,6,1,'2006525','ABB Oy','ABB Asennustuotteet','1066A4','Kytkin','6/16AX/250V/IP21 PPJ 2X V','Kytkin 6, Jussi, 2 lisäliitintä','6418677307515','img/labels/2006525.jpg',0,0),(190,6,1,'2006526','ABB Oy','ABB Asennustuotteet','1067A4','Kytkin','7/16AX/250V/IP21 PPJ 2X V','Kytkin 7, Jussi, 2 lisäliitintä','6418677307539','img/labels/2006526.jpg',0,0),(191,6,1,'2006527','ABB Oy','ABB Asennustuotteet','10631A4','Kytkin','1+1+1/16AX/250V/IP21 PPJ ','Kytkin 1+1+1, Jussi, ei lisäliittimiä','6418677307447','img/labels/2006527.jpg',0,0),(192,7,1,'3512785','ABB Oy','ABB Asennustuotteet','6513UJGL-214','Valonsäädin','40-420VA RC UPK VAL','Valonsäädin 40-420VA RC UPK VAL','6410035127858','img/labels/3512785.jpg',0,0),(193,7,1,'2421206','ABB Oy','ABB Pj-kojeet','416RS6','Pistorasia','416RS6','Pistorasia 416RS6','6410024212060','img/labels/2421206.jpg',0,0),(194,7,1,'3571982','Gycom Finland Oy','Theben','0300003','Kellokytkin','TIMER 030 TOP','Kellokytkin TIMER 030 TOP','4003468611203','img/labels/3571982.jpg',0,0),(195,1,0,'0611037','','','','','','MCMK 4X6/6','','',0,0),(196,19,1,'2006541','ABB Oy','ABB Asennustuotteet','1721S80-84','Pintakotelo','1OS/IP20 54/80mm VAL','Pintakotelo 80mm, Impressivo, korkeus 54mm, 1-osainen, valkoinen','6438199002651','img/labels/2006541.jpg',0,0),(197,19,1,'2006542','ABB Oy','ABB Asennustuotteet','1722S80-84','Pintakotelo','2OS/IP20 54/80mm VAL','Pintakotelo 80mm, Impressivo, korkeus 54mm, 2-osainen, valkoinen','6438199002682','img/labels/2006542.jpg',0,0),(198,19,1,'2006543','ABB Oy','ABB Asennustuotteet','1723S80-84','Pintakotelo','3OS/IP20 54/80mm VAL','Pintakotelo 80mm, Impressivo, korkeus 54mm, 3-osainen, valkoinen','6438199002712','img/labels/2006543.jpg',0,0),(199,19,1,'2046701','ABB Oy','ABB Asennustuotteet','1065A-84','Kytkin','5/16AX/250V/IP21 PPJ 2X ','Kytkin 5, 16AX/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199003191','img/labels/2046701.jpg',0,0),(200,19,1,'2046704','ABB Oy','ABB Asennustuotteet','1062A-84','Kytkin','2/16AX/250V/IP21 PPJ 2X V','Kytkin 2, 16AX/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199003474','img/labels/2046704.jpg',0,0),(201,19,1,'2046707','ABB Oy','ABB Asennustuotteet','10631A-84','Kytkin','1+1+1/16AX/250V/IP21 PPJ2','Kytkin 1+1+1, 16AX/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199003566','img/labels/2046707.jpg',0,0),(202,19,1,'2046710','ABB Oy','ABB Asennustuotteet','10666A-84','Kytkin','6+6/16AX/250V/IP21 PPJ 0X','Kytkin 6+6, 16AX/250V, Impressivo, ei lisäliittimiä, valkoinen','6438199003504','img/labels/2046710.jpg',0,0),(203,19,1,'2046713','ABB Oy','ABB Asennustuotteet','1066A-84','Kytkin','6/16AX/250V/IP21 PPJ 2X ','Kytkin 6, 16AX/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199003221','img/labels/2046713.jpg',0,0),(204,19,1,'2046716','ABB Oy','ABB Asennustuotteet','1067A-84','Kytkin','7/16AX/250V/IP21 PPJ 2X ','Kytkin 7, 16AX/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199003535','img/labels/2046716.jpg',0,0),(205,19,1,'2046719','ABB Oy','ABB Asennustuotteet','1461A-84','Painike','1/10AX/250V/IP21 PPJ 2X V','Painike 1, 10AX/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199003252','img/labels/2046719.jpg',0,0),(206,19,1,'2046722','ABB Oy','ABB Asennustuotteet','1721A-84','Pintakotelo','1OS/IP20 41mm, VAL','Pintakotelo 85mm, Impressivo, korkeus 41mm, 1-osainen, valkoinen','6438199003375','img/labels/2046722.jpg',0,0),(207,19,1,'2046732','ABB Oy','ABB Asennustuotteet','1721L-84','Pintakotelo','1OS/IP20 LISTA, VAL','Pintakotelo 85mm, Impressivo, 1-osainen, lista-asennus, valkoinen','6438199003924','img/labels/2046732.jpg',0,0),(208,19,1,'2046742','ABB Oy','ABB Asennustuotteet','1722H-84','Pintakehys','2-OS, 85MM, KULMA, VAL','Pintakehys, Impressivo, kulmaan asennettava, 85mm peitelevylle, valkoi','6438199003955','img/labels/2046742.jpg',0,0),(209,19,1,'2106044','ABB Oy','ABB Asennustuotteet','1062UC-84','Kytkin','2/16AX/250V/IP21 UKJ 2X V','Kytkin 2, 16AX/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199001180','img/labels/2106044.jpg',0,0),(210,19,1,'2106049','ABB Oy','ABB Asennustuotteet','10631UC-84','Kytkin','1+1+1/16AX/250V/IP21UKJ 0','Kytkin 1+1+1, 16AX/250V, Impressivo, ei lisäliittimiä, valkoinen','6438199001210','img/labels/2106049.jpg',0,0),(211,19,1,'2106052','ABB Oy','ABB Asennustuotteet','1065UC-84','Kytkin','5/16AX/250V/IP21 UKJ 2X V','Kytkin 5, 16AX/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199001241','img/labels/2106052.jpg',0,0),(212,19,1,'2106055','ABB Oy','ABB Asennustuotteet','10666UC-84','Kytkin','6+6/16AX/250V/IP21 UKJ 0X','Kytkin 6+6, 16AX/250V, Impressivo, ei lisäliittimiä, valkoinen','6438199001272','img/labels/2106055.jpg',0,0),(213,19,1,'2106058','ABB Oy','ABB Asennustuotteet','1066UC-84','Kytkin','6/16AX/250V/IP21 UKJ 2X V','Kytkin 6, 16AX/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199001302','img/labels/2106058.jpg',0,0),(214,19,1,'2106062','ABB Oy','ABB Asennustuotteet','1067UC-84','Kytkin','7/16AX/250V/IP21 UKJ 2X V','Kytkin 7, 16AX/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199001333','img/labels/2106062.jpg',0,0),(215,19,1,'2106066','ABB Oy','ABB Asennustuotteet','1461UC-84','Painike','1/10A/250V/IP21 UKJ 2X VA','Painike 1, 10A/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199001364','img/labels/2106066.jpg',0,0),(216,19,1,'2106069','ABB Oy','ABB Asennustuotteet','1465UC-84','Painike','5/10A/250V/IP21 UKJ 2X VA','Painike 5, 10A/250V, Impressivo, 2 lisäliitintä, valkoinen','6438199001395','img/labels/2106069.jpg',0,0),(217,19,1,'2106074','ABB Oy','ABB Asennustuotteet','1466UC-84','Painike','6/10A/250V/IP21 UKJ 1N VA','Painike 6, 10A/250V, Impressivo, N liitin, valkoinen','6438199001425','img/labels/2106074.jpg',0,0),(218,19,1,'2106215','ABB Oy','ABB Asennustuotteet','1065UW-84','Kytkin','5/16AX/250V/IP44 UPJ 0X V','Kytkin 6, Impressivo, IP44, kokonainen tuote, valkoinen, ei lisäl','6438199000039','img/labels/2106215.jpg',0,0),(219,19,1,'2106216','ABB Oy','ABB Asennustuotteet','1066UW-84','Kytkin','6/16AX/250V/IP44 UPJ 0X V','Kytkin 6, Impressivo, IP44, kokonainen tuote, valkoinen, ei lisäliitt','6438199000022','img/labels/2106216.jpg',0,0),(220,19,1,'2166044','ABB Oy','ABB Asennustuotteet','2538-84','Keskiölevy','Umpi, val','Keskiölevy, Impressivo, umpi, valkoinen','6418677330551','img/labels/2166044.jpg',0,0),(221,19,1,'2166084','ABB Oy','ABB Asennustuotteet','2538-100-84','Keskiölevy','Umpi, 100mm, val','Keskiölevy, Impressivo, umpi, 100mm, valkoinen','6418677332319','img/labels/2166084.jpg',0,0),(222,19,1,'2166101','ABB Oy','ABB Asennustuotteet','1721F85-84','Peitelevy','1OS/IP21/85mm VAL','Peitelevy, Impressivo, 85mm, 1-osainen, valkoinen','6418677327773','img/labels/2166101.jpg',0,0),(223,19,1,'2166102','ABB Oy','ABB Asennustuotteet','1722F85-84','Peitelevy','2OS/IP21/85mm VAL','Peitelevy, Impressivo, 85mm, 2-osainen, valkoinen','6418677327810','img/labels/2166102.jpg',0,0),(224,19,1,'2166103','ABB Oy','ABB Asennustuotteet','1723F85-84','Peitelevy','3OS/IP21/85mm VAL','Peitelevy, Impressivo, 85mm, 3-osainen, valkoinen','6418677327858','img/labels/2166103.jpg',0,0),(225,19,1,'2166104','ABB Oy','ABB Asennustuotteet','1724F85-84','Peitelevy','4OS/IP21/85mm VAL','Peitelevy, Impressivo, 85mm, 4-osainen, valkoinen','6418677327896','img/labels/2166104.jpg',0,0),(226,19,1,'2166105','ABB Oy','ABB Asennustuotteet','1725F85-84','Peitelevy','5OS/IP21/85mm VAL','Peitelevy, Impressivo, 85mm, 5-osainen, valkoinen','6418677327933','img/labels/2166105.jpg',0,0),(227,19,1,'2166116','ABB Oy','ABB Asennustuotteet','2519-84','Sovitin','1-os/2-os, 100mm, val','Sovitin, Impressivo, 1-osainen koje 100mm peitelevyyn, valkoinen','6418677328213','img/labels/2166116.jpg',0,0),(228,19,1,'2166120','ABB Oy','ABB Asennustuotteet','1747SI-84','Sovitin','Jussi keskiölevylle, val','Sovitin, Impressivo, Jussi keskiölevylle, valkoinen','4011395112045','img/labels/2166120.jpg',0,0),(229,19,1,'2166141','ABB Oy','ABB Asennustuotteet','1721F100-84','Peitelevy','1OS/IP21/100mm VAL','Peitelevy, Impressivo, 100mm, 1-osainen, valkoinen','6418677327971','img/labels/2166141.jpg',0,0),(230,19,1,'2166142','ABB Oy','ABB Asennustuotteet','1722F100-84','Peitelevy','2OS/IP21/100mm VAL','Peitelevy, Impressivo, 100mm, 2-osainen, valkoinen','6418677328015','img/labels/2166142.jpg',0,0),(231,19,1,'2166143','ABB Oy','ABB Asennustuotteet','1723F100-84','Peitelevy','3OS/IP21/100mm VAL','Peitelevy, Impressivo, 100mm, 3-osainen, valkoinen','6418677328053','img/labels/2166143.jpg',0,0),(232,19,1,'2166144','ABB Oy','ABB Asennustuotteet','1724F100-84','Peitelevy','4OS/IP21/100mm VAL','Peitelevy, Impressivo, 100mm, 4-osainen, valkoinen','6418677328091','img/labels/2166144.jpg',0,0),(233,19,1,'2166145','ABB Oy','ABB Asennustuotteet','1725F100-84','Peitelevy','5OS/IP21/100mm VAL','Peitelevy, Impressivo, 100mm, 5-osainen, valkoinen','6418677328138','img/labels/2166145.jpg',0,0),(234,19,1,'2406010','ABB Oy','ABB Asennustuotteet','402EL-84','Pistorasia','2S/16A/IP21 PPJ HL VAL LI','Pistorasia, Impressivo, 2-osainen, maadoitettu, jousiliittimet, lista-','6438199003894','img/labels/2406010.jpg',0,0),(235,19,1,'2506002','ABB Oy','ABB Asennustuotteet','20EUC-84','Pistorasia','1S/16A/IP21 UKJ 0X VAL','Pistorasia, Impressivo, 1-osainen, maad, jousiliittimin, valkoinen','6438199000510','img/labels/2506002.jpg',0,0),(236,19,1,'2506008','ABB Oy','ABB Asennustuotteet','20EUJ-84','Pistorasia','1S/16A/IP21 UPJ 0X VAL','Pistorasia, Impressivo, 1-osainen, maad, jousiliittimin, valkoinen','6438199000572','img/labels/2506008.jpg',0,0),(237,19,1,'2506013','ABB Oy','ABB Asennustuotteet','302EUC-84','Pistorasia','2S/16A/IP21 UKJ HL VAL','Pistorasia, Impressivo, 2-os, maad, jousiliittimin, haaroitusliittimet','6438199001524','img/labels/2506013.jpg',0,0),(238,19,1,'2506016','ABB Oy','ABB Asennustuotteet','302EUJ-84','Pistorasia','2S/16A/IP21 UPJ HL VAL','Pistorasia, Impressivo, 2-os, maad, jousiliittimin, haaroitusliittimet','6438199000336','img/labels/2506016.jpg',0,0),(239,19,1,'2516133','ABB Oy','ABB Asennustuotteet','302EUJW-84','Pistorasia','2S/16A/IP44 UPJ HL VAL','Pistorasia, Impressivo, 2-os, maad, IP44, kokonainen tuote, valkoinen,','6438199000046','img/labels/2516133.jpg',0,0),(240,19,1,'2516134','ABB Oy','ABB Asennustuotteet','20EUJW-84','Pistorasia','1S/16A/IP44 UPJ HL VAL','Pistorasia, Impressivo, 1-os, maad, IP44, kokonainen tuote, valkoinen,','6438199000015','img/labels/2516134.jpg',0,0),(241,19,1,'2619318','ABB Oy','ABB Asennustuotteet','2112UC-84','Valonsäädin','1-10V UK VAL','Ohjain 1-10 V, valkoinen','6438199001777','img/labels/2619318.jpg',0,0),(242,19,1,'2619321','ABB Oy','ABB Asennustuotteet','2247UC-84','Valonsäädin','20-500VA RL UK VAL','Muuntajasäädin, 20-500 VA, Sopii 230 V hehku- ja halogeenilampuille ','6438199001890','img/labels/2619321.jpg',0,0),(243,19,1,'2619324','ABB Oy','ABB Asennustuotteet','2250UC-84','Valonsäädin','60-600W R UK VAL','Hehkulamppusäädin, 60-600 W, koje. Sopii 230 V hehku- ja halogeenila','6438199001807','img/labels/2619324.jpg',0,0),(244,19,1,'2619327','ABB Oy','ABB Asennustuotteet','6513UC-84','Valonsäädin','40-420VA RC UK VAL','El.muuntajasäädin, 40-420 VA. Sopii 230 V hehku- ja halogeenilampuil','6438199001838','img/labels/2619327.jpg',0,0),(245,19,1,'7060514','ABB Oy','ABB Asennustuotteet','1743-84','Keskiölevy','TV/R/Sat, val','Keskiölevy, Impressivo, antenni TV/R/Sat, valkoinen','6418677329418','img/labels/7060514.jpg',0,0),(246,19,1,'7204009','ABB Oy','ABB Asennustuotteet','FOT5000-84','Telerasia','2xRJ45,Keyst,ei sis liit,','Telerasia, Impressivo, 2xRJ45, ei sisällä liittimiä, Keystone, valk','6438199001623','img/labels/7204009.jpg',0,0),(247,19,1,'7204083','ABB Oy','ABB Asennustuotteet','1812.1','Telerasia','Runko,2xRJ45,Keystone,pun','Telerasian runko, punainen, 2 x RJ-45 Keystone liittimelle','6410072040837','img/labels/7204083.jpg',0,0),(248,19,1,'7204087','ABB Oy','ABB Asennustuotteet','1819DC-84','Keskiölevy','2xRJ45, pölyluukut,val','Keskiölevy, Impressivo, 2xRJ45 liittimelle, pölyluukut, valkoinen','6438199002835','img/labels/7204087.jpg',0,0),(249,7,1,'7204067','ABB Oy','ABB Asennustuotteet','1819.01','Telerasia','Runko, 2xRJ45, Keystone','Telerasian runko, 2 x RJ45 Keystone liittimelle','6418677330445','img/labels/7204067.jpg',0,0),(250,7,1,'7204081','ABB Oy','ABB Asennustuotteet','1819DC-214','Keskiölevy','2xRJ45,pölyluukut, val','Keskiölevy, Jussi, RJ45 runkoihin 1819.xx, pölyluukut','6438199002804','img/labels/7204081.jpg',0,0),(251,7,1,'7250154','Nylund Group Oy Ab','INFRALAN','20122039','Liitin-CAT6','DNE20080-100','RJ45 liitinmoduuli Cat6 UTP','','img/labels/7250154.jpg',0,0),(252,18,1,'7200593','Schneider Electric F','Schneider Electric','306520006','Dataliitin','LXO 250 CAT6 UTP 500KPL','Dataliitin LXO 250 CAT6 UTP 500KPL','5703302107693','img/labels/7200593.jpg',0,0),(253,18,1,'7240185','Schneider Electric F','Schneider Electric','VDIG01Y241F','Paneeli','Paneeli 24xRJ45 tyhjä il','Paneeli Paneeli 24xRJ45 tyhjä ilman oh','6410072401850','img/labels/7240185.jpg',0,0),(254,18,1,'7270000','Satmatic Oy','Satmatic','FLC0164','Kaappirunko','Kaappi 2000x600x600 Eltek','Kaappirunko Kaappi 2000x600x600 Eltek','','img/labels/7270000.',0,0),(255,18,1,'7270028','Satmatic Oy','Satmatic','ACS00065','Hylly','Hylly etukiin. L19xS370mm','Hylly etukiin. L19xS370mm','','img/labels/7270028.',0,0),(256,18,1,'7270034','Satmatic Oy','Satmatic','ACS00103','Pistorasiapaneeli','Pistorasia 19','Pistorasia 19','','img/labels/7270034.',0,0),(257,18,1,'7270037','Satmatic Oy','Satmatic','ACS00171','Asennustarvike','Korimutteri+ruuvi Eltek','Korimutteri+ruuvi (PKK=4 kpl)','','img/labels/7270037.',0,0),(258,18,1,'7270042','Satmatic Oy','Satmatic','ACS00095','Ohjuripaneeli','Ohjuripaneli 1U metalli m','Ohjuripaneli 1U metalli musta','','img/labels/7270042.',0,0),(259,18,1,'7270130','Satmatic Oy','Satmatic','PAN102','Paneeli-kuitu','19','19','','img/labels/7270130.jpg',0,0),(260,18,1,'7541156','Laatuantenni Oy','Laatuantenni','LAKM 18','Maadoitustarvike','LAKM 18 Antennikaapelin m','Antennikaapelin maadoituskisko 18:lle, ilman liittimiä, liittimet esi','6410075411566','img/labels/7541156.',0,0),(261,18,1,'7541402','Laatuantenni Oy','Laatuantenni','F-56 5.1','Liitin','F-56 5.1, F-kompressiolii','F-liitin kompressio, AL 112-, AL 113- ja AL 102 sarjan sekä Tellu 13 ','6410075414024','img/labels/7541402.',0,0),(262,14,1,'1101016','Pipelife Finland Oy','Pipelife','510 116','Asennusputki muovi','JM-16','Asennusputki muovi','6410011010167','img/labels/1101016.jpg',0,0),(263,14,1,'1101020','Pipelife Finland Oy','Pipelife','510 120','Asennusputki muovi','JM-20','Asennusputki muovi','6410011010204','img/labels/1101020.jpg',0,0),(264,14,1,'1130116','ABB Oy','ABB Asennustuotteet','AJ16','Jatkomuhvi muovi','AJ16, Ø 16 mm','Jatkomuhvi muovi AJ16, Ø 16 mm','6410011301166','img/labels/1130116.jpg',0,0),(265,14,1,'1130120','ABB Oy','ABB Asennustuotteet','AJ20','Jatkomuhvi muovi','AJ20, Ø 20 mm','Jatkomuhvi muovi AJ20, Ø 20 mm','6410011301203','img/labels/1130120.jpg',0,0),(266,1,0,'','','','','','','DATAJAMAK 2X(2+1)X0.24','','',0,0),(267,1,0,'1100020','','','','','','TAIPUISA MUOVIPUTKI TAM 20','','',0,0),(268,7,1,'2506172','ABB Oy','ABB Asennustuotteet','303UC','Pistorasia','3E/2,5A/IP20 UKJ 2X VAL','Pistorasia, 2,5A/250V, 3-osainen, Euro, valkoinen','6418677335136','img/labels/2506172.jpg',0,0),(269,1,0,'0241323','','','','','','Profit 2x4p cat6 + tellu13','','',0,0),(270,5,0,'0611654','','','','','','FRHF 5x2,5S','','',0,0),(271,21,1,'1467001','MP bolagen Industri ','MP Bolagen','MP-102S6','Tikashylly','MP-102S6 Fe 200x56x6000 K','Tikashylly MP-S 200S 6 m','7394333000190','img/labels/1467001.jpg',0,0),(272,21,1,'1467003','MP bolagen Industri ','MP Bolagen','MP-103S6','Tikashylly','MP-103S6 Fe 300x56x6000 K','Tikashylly MP-S 300S 6 m','7394333000220','img/labels/1467003.jpg',0,0),(273,21,1,'1467007','MP bolagen Industri ','MP Bolagen','MP-105S6','Tikashylly','MP-105S6 Fe 500x56x6000 K','Tikashylly MP-S 500S 6 m','7394333000480','img/labels/1467007.jpg',0,0),(274,21,1,'1467011','MP bolagen Industri ','MP Bolagen','MP-107S','Jatkokappale','MP-107S Jatko tikashyllyt','Jatkokappale tikashyllylle S','7394333012957','img/labels/1467011.jpg',0,0),(275,21,1,'1467054','MP bolagen Industri ','MP Bolagen','MP-157S','Keskikannatin','MP-157S Keskikannatin,BI,','Sisäpuolinen keskikannatin BI 200S','7394333003511','img/labels/1467054.jpg',0,0),(276,21,1,'1467055','MP bolagen Industri ','MP Bolagen','MP-158S','Keskikannatin','MP-158S KeskikannatinBI,3','Sisäpuolinen keskikannatin BI 300S','7394333003641','img/labels/1467055.jpg',0,0),(277,21,1,'1467057','MP bolagen Industri ','MP Bolagen','MP-160S','Keskikannatin','MP-160S KeskikannatinBI,5','Sisäpuolinen keskikannatin BI 500S','7394333003801','img/labels/1467057.jpg',0,0),(278,21,1,'1467109','MP bolagen Industri ','MP Bolagen','MP-314S','Jatkokappale','MP-314SJatko75mm,levyhyll','Jatkokappale levyhyllylle 75S','7394333119007','img/labels/1467109.jpg',0,0),(279,21,1,'1467116','MP bolagen Industri ','MP Bolagen','MP-340S','Levyhylly','MP-340SLevyhylly200mm3m,u','Levyhylly 200S 3 m','7394333100661','img/labels/1467116.jpg',0,0),(280,21,1,'1467119','MP bolagen Industri ','MP Bolagen','MP-344S','Jatkokappale','MP-344SJatko200mm,levyhyl','Jatkokappale levyhyllylle 200S','7394333124209','img/labels/1467119.jpg',0,0),(281,21,1,'1467123','MP bolagen Industri ','MP Bolagen','MP-354S','Jatkokappale','MP-354SJatko300mm,levyhyl','Jatkokappale levyhyllylle 300S','7394333124339','img/labels/1467123.jpg',0,0),(282,21,1,'1467131','MP bolagen Industri ','MP Bolagen','MP-374S','Jatkokappale','MP-374SJatko500mm,levyhyl','Jatkokappale levyhyllylle 500S','7394333124599','img/labels/1467131.jpg',0,0),(283,21,1,'1467162','MP bolagen Industri ','MP Bolagen','MP-546S','Keskikannatin','MP-546S Keskikannatin200m','Keskikannatin levyhyllylle 200S','7394333120805','img/labels/1467162.jpg',0,0),(284,21,1,'1467165','MP bolagen Industri ','MP Bolagen','MP-556S','Keskikannatin','MP-556S Keskikannatin300m','Keskikannatin levyhyllylle 300S','7394333120935','img/labels/1467165.jpg',0,0),(285,21,1,'1467171','MP bolagen Industri ','MP Bolagen','MP-576S','Keskikannatin','MP-576S Keskikannatin500m','Keskikannatin levyhyllylle 500S','7394333121161','img/labels/1467171.jpg',0,0),(286,21,1,'1467266','MP bolagen Industri ','MP Bolagen','MP-754S','Seinäkannake','MP-754S Seinäkannatin KL','Seinäkannatin KL 300S','7394333054957','img/labels/1467266.jpg',0,0),(287,21,1,'1467330','MP bolagen Industri ','MP Bolagen','MP-925E','Kiinnitystarvike','MP-925E Kierretangon kiin','Kierretangon kiinnitin E','7394333122397','img/labels/1467330.jpg',0,0),(288,21,1,'1467331','MP bolagen Industri ','MP Bolagen','MP-925V','Kiinnitystarvike','MP-925VKierretangon kiinn','Kierretangon kiinnitin V','7394333122427','img/labels/1467331.jpg',0,0),(289,21,1,'1467336','MP bolagen Industri ','MP Bolagen','MP-931S','Kiinnitystarvike','MP-931S Kannatinkiinnitti','Kannattimen kiinnike S','7394333115863','img/labels/1467336.jpg',0,0),(290,21,1,'1467337','MP bolagen Industri ','MP Bolagen','MP-931V','Kiinnitystarvike','MP-931V Kannatinkiinnitti','Kannattimen kiinnike 100-600V','7394333115993','img/labels/1467337.jpg',0,0),(291,21,1,'1467341','MP bolagen Industri ','MP Bolagen','MP-937E','Asennussarja','MP-937E Asennusruuvisarja','Ruuvisarja E M8x16 mm','7394333028675','img/labels/1467341.jpg',0,0),(292,21,1,'1467346','MP bolagen Industri ','MP Bolagen','MP-942S','Seinäkannake','MP-942S Seinäkannatin si','Sisäpuolinen seinäkannatin KI 100-200S','7394333112695','img/labels/1467346.jpg',0,0),(293,21,1,'1467576','MP bolagen Industri ','MP Bolagen','MP-311V6','Valaisinkisko','MP-311V6 Valaisinkisko 75','Valaisinkisko 75V 6 m','','img/labels/1467576.jpg',0,0),(294,21,1,'1467578','MP bolagen Industri ','MP Bolagen','MP-321V6','Valaisinkisko','MP-321V6 Valaisinkisko 10','Valaisinkisko 100V 6 m','','img/labels/1467578.jpg',0,0),(295,21,1,'1467618','MP bolagen Industri ','MP Bolagen','MP-515V','Keskikannatin','MP-515V Reunak. 75V valai','Reunakiinnitin 75V valaisink.','7394333120713','img/labels/1467618.jpg',0,0),(296,21,1,'1467619','MP bolagen Industri ','MP Bolagen','MP-525V','Keskikannatin','MP-525V Reuna. 100V valai','Reunakiinnitin 100V valaisink.','','img/labels/1467619.jpg',0,0),(297,21,1,'1467838','MP bolagen Industri ','MP Bolagen','MP-350S3','Levyhylly','MP-350S3Levyhylly300mm3m,','Levyhylly 300S 3 m','','img/labels/1467838.jpg',0,0),(298,21,1,'1467840','MP bolagen Industri ','MP Bolagen','MP-370S3','Levyhylly','MP-370S3Levyhylly500mm3m,','Levyhylly 500S 3 m','','img/labels/1467840.jpg',0,0),(299,21,1,'1467882','MP bolagen Industri ','MP Bolagen','MP-756S','Seinäkannake','MP-756S Seinäkannatin KL','Seinäkannatin KL 500S','','img/labels/1467882.jpg',0,0),(300,1,0,'0481445','','','','','','MMJ 5x16 S','','',0,0); /*!40000 ALTER TABLE `L` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `LD` -- DROP TABLE IF EXISTS `LD`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `LD` ( `LD_id` int(11) NOT NULL AUTO_INCREMENT, `nro` varchar(20) NOT NULL, `count` int(11) NOT NULL, `price` float NOT NULL, `date` date NOT NULL, `status` int(11) NOT NULL, `dest_type` int(11) NOT NULL, `dest_id` int(11) NOT NULL, `pair_id` int(11) NOT NULL, `PD_id` int(11) NOT NULL, PRIMARY KEY (`LD_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `LD` -- LOCK TABLES `LD` WRITE; /*!40000 ALTER TABLE `LD` DISABLE KEYS */; /*!40000 ALTER TABLE `LD` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `LG` -- DROP TABLE IF EXISTS `LG`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `LG` ( `LG_id` int(11) NOT NULL AUTO_INCREMENT, `parent` int(11) NOT NULL, `nimi` varchar(30) NOT NULL, PRIMARY KEY (`LG_id`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `LG` -- LOCK TABLES `LG` WRITE; /*!40000 ALTER TABLE `LG` DISABLE KEYS */; INSERT INTO `LG` VALUES (1,0,'Sähkötarvikkeet'),(2,0,'LVI-tarvikkeet'),(3,0,'Muut'),(5,1,'Kaapelit'),(6,1,'Kalusteet'),(7,6,'ABB Jussi uppo'),(8,7,'Pistorasiat'),(9,7,'Kytkimet'),(10,7,'Peitelevyt'),(11,5,'Maakaapelit'),(12,5,'MMJ'),(13,1,'Johdotustarvikkeet'),(14,1,'Putkitus tarvikkeet'),(15,13,'Rasiat ja nysät'),(16,0,'Maakaapelit'),(17,0,'Maakaapelit2'),(18,1,'IT-kytkennät'),(19,6,'ABB Impressivo'),(20,14,'Japp'),(21,1,'Johtotiet'); /*!40000 ALTER TABLE `LG` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `P` -- DROP TABLE IF EXISTS `P`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `P` ( `P_id` int(11) NOT NULL AUTO_INCREMENT, `nimi` varchar(50) NOT NULL, `osoitetiedot` int(11) NOT NULL, `urakkahinta` int(11) NOT NULL, PRIMARY KEY (`P_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11005 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `P` -- LOCK TABLES `P` WRITE; /*!40000 ALTER TABLE `P` DISABLE KEYS */; INSERT INTO `P` VALUES (9,'As Oy Oulun Safiiri',1,10000),(11,'ProMart Pirkkala',0,0),(13,'Toimisto',0,0),(14,'Eerikinkatu',0,0),(15,'Roc-Service Halli',0,0),(1001,'As Oy Vantaan pellavapolku',0,10500),(1013,'OKT Piironen',0,0),(1014,'OKT Tölli',0,0),(1015,'PVK ahscontrol',0,0),(1016,'PVK nuotek',0,0),(1017,'test',0,0),(1018,'OKT Rajamäki Tuulitie 10',0,0),(1019,'OKT Liukko Tuulitie 10',0,0),(1020,'OKT Saarikoski',0,0),(1021,'testi',0,0),(1022,'PT Riihimäki',0,0),(1023,'Laskutyöt',0,0),(1024,'OKT Laine HK1500',0,0),(1025,'OKT Simanainen HK1510',0,0),(1026,'OKT Kaikkonen HK1511',0,0),(1027,'PVK Pirkkala',0,0),(1028,'Forever Kuntoklubi',0,0),(1029,'Haarniskatie',0,0),(1030,'Intran kehitys',0,0),(1031,'As Oy Nurmijärven Paroni',0,0),(1032,'OKT Peltonen HK1543',0,0),(11001,'As Oy Vantaan Mesikämmen',0,0),(11002,'As Oy Hatuntekijänkuja 11',0,0),(11003,'eemeli tekniikka',0,0),(11004,'OKT Arbelius',0,0); /*!40000 ALTER TABLE `P` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PD` -- DROP TABLE IF EXISTS `PD`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PD` ( `PD_id` int(11) NOT NULL AUTO_INCREMENT, `P_id` int(11) NOT NULL, `type` int(11) NOT NULL, `nimi` varchar(50) NOT NULL, PRIMARY KEY (`PD_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `PD` -- LOCK TABLES `PD` WRITE; /*!40000 ALTER TABLE `PD` DISABLE KEYS */; INSERT INTO `PD` VALUES (4,1017,0,'talo'),(5,1021,0,'Talo'),(6,1021,1,'RK'),(7,1021,1,'SPK'); /*!40000 ALTER TABLE `PD` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PG` -- DROP TABLE IF EXISTS `PG`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PG` ( `PG_id` int(11) NOT NULL AUTO_INCREMENT, `parent` int(11) NOT NULL, `nimi` varchar(30) NOT NULL, PRIMARY KEY (`PG_id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `PG` -- LOCK TABLES `PG` WRITE; /*!40000 ALTER TABLE `PG` DISABLE KEYS */; INSERT INTO `PG` VALUES (1,0,'Sähkö'),(2,6,'Kaapelin asennus'),(3,7,'Abb Jussi'),(4,1,'Alipaketit'),(5,4,'Kojerasiapaketit'),(6,1,'Metrimääräiset'),(7,1,'Kappalemääräiset'),(8,3,'Kojeet'),(9,3,'Peitelevyt'),(10,7,'ABB Impressivo'),(11,10,'Kojeet'),(12,10,'Peitelevyt'),(13,7,'Kojeet'); /*!40000 ALTER TABLE `PG` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PS` -- DROP TABLE IF EXISTS `PS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PS` ( `PS_id` int(11) NOT NULL AUTO_INCREMENT, `P_id` int(11) NOT NULL, `S_id` int(11) NOT NULL, `type` int(11) NOT NULL, `value` float NOT NULL, `price` int(11) NOT NULL, `tag` varchar(20) NOT NULL, PRIMARY KEY (`PS_id`) ) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `PS` -- LOCK TABLES `PS` WRITE; /*!40000 ALTER TABLE `PS` DISABLE KEYS */; INSERT INTO `PS` VALUES (9,9,2,0,16,400,'SPK'),(10,9,2,0,27,623,'RK:t'),(11,9,1,0,146,3200,''),(12,9,2,0,7,175,'ATK jakamo'),(13,9,3,0,33,250,'Jakotukit yms.'),(14,9,7,0,4,100,'Lattia'),(15,9,8,0,5,0,''),(18,1001,7,0,34,516,'Lattia'),(19,1001,1,0,90,4142,''),(20,1001,2,0,32.5,948,'Ryhmäkeskukset'),(21,1001,2,0,15,388,'SPK'),(22,1001,2,0,9,516,'ATK-jakamo'),(23,1001,3,0,159,3791,''),(24,1001,3,0,16,307,'Piha-alueet'),(25,1001,4,0,21,603,'Nousukaapelit'),(26,1001,7,0,8.5,689,'Ontelokenttä'),(27,11,8,0,40,680,'Tarjouslaskenta'),(29,1001,8,1,12,500,'Loppukuvat'),(30,1001,8,1,0,500,''),(31,13,8,1,5,0,'Markkinointi'),(32,13,8,1,0,0,'Kirjanpito'),(34,13,8,1,0,0,'Yrityksen kehitys'),(35,1001,8,1,15,300,'Käyttöönottomitta'),(36,13,8,1,5,0,'Nettisivut'),(37,14,8,0,16,0,'Tarjouslaskenta'),(38,15,1,0,20,650,'Suunnittelu'),(41,15,8,0,0,200,'Tarjouslaskenta'),(55,1013,1,0,41,1201,''),(56,1013,2,0,9,210,''),(57,1013,9,0,4,108,''),(58,1013,3,0,35,898,''),(59,1013,7,0,4,32,''),(60,1013,11,1,0,0,''),(61,1014,11,1,0,0,''),(62,1015,11,1,0,0,''),(63,1016,11,1,0,0,''),(64,1013,8,1,0,0,''),(65,1018,11,1,4.5,70,''),(66,1019,11,1,4.5,70,''),(67,1020,10,1,9,150,''),(68,9,3,0,0,0,'VILP'),(69,1001,8,0,19,0,'VILP'),(70,1001,8,0,8,0,'ATK Mittaukset'),(71,1022,11,1,0,120,''),(72,1019,10,1,5,0,''),(73,1018,10,1,5.5,0,''),(74,1014,9,0,16,365,''),(75,1014,1,0,40,942,''),(76,1014,2,0,0,164,''),(77,1014,3,0,30,670,''),(78,1014,8,0,0,100,'Katos'),(79,1023,8,2,0,0,'LVI Wabek'),(80,1023,8,2,0,0,'Best-Caravan puhalli'),(81,1014,10,1,0,0,''),(82,1027,11,0,0,0,''),(83,1022,10,1,0,0,''),(84,1025,10,1,0,0,''),(85,1026,10,1,0,0,''),(86,1028,11,1,16,0,''),(87,1017,1,0,0,0,''),(88,1018,1,0,0,0,''),(89,1018,3,0,0,0,''),(90,1018,2,0,0,0,''),(91,1019,1,0,21,710,''),(92,1019,3,0,17,434,''),(93,1019,2,0,3.5,133,''),(94,1022,7,0,32,409,''),(95,1022,1,0,50,1196,''),(96,1022,3,0,54,1350,''),(97,1022,2,0,10,270,''),(98,1022,9,0,0,0,'porras'),(99,1027,10,0,32,0,''),(100,1028,4,0,6,232,''),(101,1028,7,0,15,315,'1.krs lattiavalu'),(102,1028,7,0,11,315,'2.krs lattiavalu'),(103,1028,1,0,252,6335,''),(104,1028,3,0,74,1863,'Valaisimet'),(105,1028,3,0,75,1880,''),(106,1028,2,0,50,1250,''),(107,1028,2,0,33,833,'ATK jakamo ja antenn'),(108,1028,1,1,0,0,'Optimointi'),(109,1028,8,1,0,0,''),(110,1027,8,1,0,0,''),(111,1027,8,0,5.5,137,'Kaapelitie'),(112,1027,1,0,86,2154,''),(113,1027,3,0,53,1312,''),(114,1027,2,0,14,348,''),(115,1027,3,0,7,175,'Piha-alueet'),(116,1027,3,0,4,100,'Varasto'),(117,1028,8,0,69,2232,'Kaapelitiet'),(118,1029,11,1,0,200,'Tarjouslaskenta'),(119,1019,8,1,0,0,''),(120,1030,8,1,0,180,'Tutustuminen'),(121,1031,1,0,50,4319,''),(122,1031,2,0,105,2644,'Asunnot'),(123,1031,3,0,155,3886,''),(124,1031,7,0,153,3844,''),(125,1031,8,0,19,479,'Kaapelitiet'),(126,1031,1,0,47,1168,'Nousukaapelit'),(127,1031,2,0,29,735,'Kiinteistökeskukset'),(128,1031,2,0,12,295,'ATK Jakamo'),(129,1031,4,0,8,196,''),(130,1031,3,0,9,220,'Piha-alueet'),(131,1031,9,0,31,766,''),(132,1032,1,1,0,220,'Suunnittelu'),(133,1028,8,0,10,0,''),(134,11001,11,1,0,0,''),(135,11004,10,1,0,0,'Tarjouslaskenta'),(136,1030,8,1,0,500,'Kehitys'),(137,11002,11,1,0,0,''); /*!40000 ALTER TABLE `PS` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PSH` -- DROP TABLE IF EXISTS `PSH`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PSH` ( `PSH_id` int(11) NOT NULL AUTO_INCREMENT, `PS_id` int(11) NOT NULL, `U_id` int(11) NOT NULL, `date` date NOT NULL, `value` float NOT NULL, `comment` varchar(150) NOT NULL, PRIMARY KEY (`PSH_id`) ) ENGINE=InnoDB AUTO_INCREMENT=508 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `PSH` -- LOCK TABLES `PSH` WRITE; /*!40000 ALTER TABLE `PSH` DISABLE KEYS */; INSERT INTO `PSH` VALUES (2,2,1,'2013-04-21',2,'test2'),(31,1,1,'2013-04-26',8,''),(34,2,1,'2013-04-29',3,'testi1'),(35,2,1,'2013-01-26',3,''),(41,1,1,'2013-04-27',8,''),(42,2,1,'2013-04-27',5,''),(43,1,1,'2013-04-27',5,''),(47,2,1,'2013-04-27',3,''),(48,1,1,'2013-04-27',8,''),(49,1,1,'2013-04-27',8,''),(51,1,1,'2013-04-27',6,''),(53,1,1,'2013-04-27',8,''),(55,2,1,'2013-04-27',6,''),(59,1,1,'2013-01-27',8,''),(60,1,1,'2013-01-27',8,''),(61,1,1,'2013-01-27',8,''),(62,1,1,'2013-01-27',8,''),(63,2,1,'2013-01-27',8,''),(64,2,1,'2013-01-27',8,''),(66,2,1,'2013-01-27',8,''),(67,1,1,'2013-04-27',8,''),(69,1,1,'2013-04-27',8,''),(70,2,1,'2013-04-26',4,''),(71,1,1,'2013-04-26',2,''),(72,2,1,'2013-04-29',8,'mjoo'),(74,2,1,'2013-05-03',4,''),(75,1,2,'2013-05-04',8,''),(76,1,2,'2013-05-03',5,''),(77,2,1,'2013-07-31',5,''),(78,1,1,'2013-07-31',3,''),(79,2,1,'2013-07-04',2,''),(80,1,1,'2013-07-04',7,''),(81,1,1,'0000-00-00',8,''),(82,6,1,'2014-06-21',8,''),(83,6,1,'0000-00-00',8,''),(84,11,1,'2014-05-19',3,''),(85,14,1,'2014-05-19',1,''),(86,11,1,'2014-05-20',8,'kattorasiat'),(87,11,1,'2014-05-21',8,'kattorasiat'),(88,11,1,'2014-05-22',8,'a1'),(89,11,1,'2014-05-23',8,'a2'),(90,11,1,'2014-05-26',8,''),(91,11,1,'2014-05-27',8,''),(95,11,1,'2014-05-28',3.5,'a katot'),(96,13,1,'2014-05-28',2.5,''),(97,14,1,'2014-05-28',1,''),(98,11,1,'2014-06-02',1,''),(99,9,1,'2014-06-02',0.5,''),(100,12,1,'2014-06-02',4.5,''),(101,9,1,'2014-06-03',4,''),(102,14,1,'2014-06-03',0.5,''),(103,11,1,'2014-06-03',3.5,''),(104,9,1,'2014-06-04',3.5,''),(105,12,1,'2014-06-04',2.5,''),(106,14,1,'2014-06-04',0.5,''),(107,11,1,'2014-06-04',1.5,''),(108,11,1,'2014-06-05',7,''),(109,14,1,'2014-06-05',1,''),(110,11,1,'2014-06-06',5.5,''),(111,13,1,'2014-06-06',2.5,''),(112,13,1,'2014-06-09',2.5,''),(113,10,1,'2014-06-09',1.5,''),(114,11,1,'2014-06-11',6,''),(115,15,1,'2014-06-11',2,''),(116,11,1,'2014-06-12',7,''),(117,10,1,'2014-06-13',6.5,''),(118,10,1,'2014-06-16',1.5,''),(119,11,1,'2014-06-16',6.5,''),(120,11,1,'2014-06-17',8,''),(121,10,1,'2014-06-18',3.5,''),(122,11,1,'2014-06-18',4.5,''),(123,11,1,'2014-06-19',8,''),(124,10,1,'2014-06-23',2.5,''),(125,11,1,'2014-06-23',3.5,''),(126,10,1,'2014-06-24',4,''),(127,11,1,'2014-06-24',4,''),(131,10,1,'2014-06-25',4,''),(132,11,1,'2014-06-25',3.5,''),(133,13,1,'2014-06-25',0.5,''),(136,13,1,'2014-06-26',3,''),(137,15,1,'2014-06-26',3,''),(138,11,1,'2014-07-05',3,''),(139,10,1,'2014-07-05',3,''),(140,11,1,'2014-08-08',2.5,''),(141,11,1,'2014-08-18',8,''),(142,11,1,'2014-08-19',8,''),(144,13,1,'2014-08-20',6,''),(145,13,1,'2014-08-21',8,''),(146,13,1,'2014-08-22',8,''),(151,25,1,'2014-10-13',2.5,''),(152,25,1,'2014-10-14',7.5,''),(153,26,1,'2014-10-14',1.5,''),(154,9,1,'2014-10-14',8,''),(155,25,2,'2014-10-13',2.5,''),(156,25,2,'2014-10-14',8,''),(159,25,2,'2014-10-15',0.5,''),(160,26,2,'2014-10-15',7,''),(161,27,1,'2014-10-22',3,'Valaisinlaskenta'),(162,27,1,'2014-10-23',4.5,''),(163,18,2,'2014-10-23',8,''),(164,27,1,'2014-10-24',2.5,'massoittelu'),(165,27,1,'2014-10-25',3.5,'tavara hinnat'),(166,18,2,'2014-10-27',6.5,''),(167,19,2,'2014-10-16',2,''),(168,31,1,'2014-10-28',2,''),(169,18,2,'2014-10-28',3.5,''),(170,19,2,'2014-10-28',1.5,''),(171,19,2,'2014-10-29',1,''),(172,36,1,'2014-10-29',2,''),(173,18,2,'2014-10-30',7,''),(174,18,2,'2014-10-31',7,''),(175,21,2,'2014-10-31',1,''),(176,19,2,'2014-10-29',2,''),(178,30,1,'2014-11-02',1,'Lattialämmityksen tarjous'),(179,37,1,'2014-11-03',3.5,''),(180,37,1,'2014-11-04',6,''),(181,37,1,'2014-11-05',3,''),(182,36,1,'2014-11-06',2,''),(183,36,1,'2014-11-10',1,''),(184,31,1,'2014-11-19',3,'tonttikeskustarjoukset yms'),(185,38,1,'2014-11-20',2,'Huipputeho, johtotiet'),(186,38,1,'2014-11-21',3.5,'ulkovalot yms'),(188,38,1,'2014-11-24',4,'Johdotus yms'),(189,31,1,'2014-11-24',1,'Kalusteet kivioja'),(190,38,1,'2014-11-25',5,''),(191,38,1,'2014-11-26',5,''),(192,31,1,'2014-11-26',1,'hartman laskenta'),(193,38,1,'2014-11-28',0.5,''),(195,31,1,'2014-11-28',2.5,'hartman laskenta'),(196,34,1,'2014-11-28',1,'kuluseuranta'),(197,31,1,'2014-11-28',2,'hartman laskenta'),(198,31,1,'2014-11-28',1.5,'hartman laskenta'),(199,30,1,'2014-11-28',0.5,'apk hinta ivk yms'),(200,41,1,'2014-11-28',2,''),(201,21,2,'2014-12-02',9,''),(202,19,2,'2014-12-02',7,''),(203,19,2,'2014-12-02',8.5,''),(204,19,2,'2014-12-02',8.5,''),(208,19,2,'2014-12-04',10.5,''),(209,19,2,'2014-12-04',7,''),(211,41,1,'2014-12-05',2,''),(212,31,1,'2014-12-08',1.5,'Hartman toimitussisältö'),(213,19,2,'2014-12-12',5,''),(214,19,2,'2014-12-08',10,''),(215,19,2,'2014-12-09',10,''),(216,20,1,'2014-12-09',1.5,'Merkkaukset'),(217,19,2,'2014-12-10',10,''),(219,23,2,'2014-12-10',2,''),(220,19,2,'2014-12-12',7,''),(223,30,1,'2014-12-17',1,'Tavaran tilaus ja laskenta'),(226,20,2,'2014-12-20',18,''),(244,60,1,'2014-12-30',1,''),(245,60,1,'2014-12-21',3.5,''),(246,61,1,'2014-12-17',1.5,''),(247,61,1,'2014-12-16',4,''),(249,62,1,'2014-12-11',8,''),(250,63,1,'2014-12-01',4,''),(252,64,1,'2014-12-31',1,''),(253,34,1,'2014-12-31',0.5,''),(254,24,2,'2031-12-20',7,''),(255,24,2,'2015-01-05',2,''),(256,23,2,'2015-01-05',6,''),(258,20,2,'2015-01-07',6,''),(259,23,2,'2015-01-07',4,''),(260,23,2,'2015-01-07',8,''),(261,23,2,'2015-01-07',8,''),(262,23,2,'2015-01-05',8,''),(264,34,1,'2015-01-12',6.5,'Ohjelmien asennukset, logo yms tilitoimistoasiat'),(265,65,1,'2015-01-12',0.5,''),(266,61,1,'2015-01-13',1,'Tarjouksen tarkennus'),(267,65,1,'2015-01-13',1.5,''),(268,66,1,'2015-01-13',2,''),(269,31,1,'2015-01-13',2,''),(270,34,1,'2015-01-14',2.5,'Impressivo laskentapaketit'),(271,65,1,'2015-01-14',2,''),(272,66,1,'2015-01-14',2,''),(273,67,1,'2015-01-15',8,''),(274,60,1,'2015-01-15',3,''),(275,20,2,'2015-01-13',5,''),(276,23,2,'2015-01-13',2,''),(277,23,2,'2015-01-14',7.5,''),(278,23,2,'2015-01-15',7,''),(279,23,2,'2015-01-12',8,''),(280,29,1,'2015-01-16',2,''),(281,23,1,'2015-01-19',2.5,''),(282,31,1,'2015-01-19',2.5,''),(283,69,2,'2015-01-19',2,''),(284,18,2,'2015-01-26',0,''),(285,23,1,'2015-01-20',4,''),(286,57,1,'2015-01-20',2,''),(287,59,1,'2015-01-20',2,''),(288,57,2,'2015-01-20',2,''),(289,59,2,'2015-01-20',2,''),(290,23,2,'2015-01-20',4,''),(291,23,1,'2015-01-21',6,''),(292,69,1,'2015-01-26',0.5,''),(293,20,1,'2015-01-26',0.5,''),(294,23,1,'2015-01-26',3.5,''),(295,23,2,'2015-01-26',4,''),(296,21,2,'2015-01-26',4,''),(298,22,2,'2015-01-26',3.5,''),(299,21,2,'2015-01-26',1,''),(300,22,2,'2015-01-26',5,''),(301,20,2,'2015-01-26',1.5,''),(302,69,2,'2015-01-26',1.5,''),(303,23,2,'2015-01-26',3,''),(304,18,2,'2015-01-26',2,''),(305,23,1,'2015-01-27',8,''),(306,23,1,'2015-01-28',4,''),(307,70,1,'2015-02-02',4,''),(308,31,1,'2015-02-02',1.5,''),(309,23,1,'2015-02-02',2.5,''),(310,70,2,'2015-02-02',4,''),(315,23,2,'2015-02-02',2,''),(316,69,2,'2015-01-27',8,''),(317,23,2,'2015-01-26',4,''),(318,61,1,'2015-02-03',0.5,'Sopimus'),(319,65,1,'2015-02-03',0.5,'Sopimus'),(320,66,1,'2015-02-03',0.5,'Sopimus'),(321,31,1,'2015-02-03',1.5,'Lisätyöhinnasto päivitys'),(322,36,1,'2015-02-03',0.5,'RKL toukko referensseihin'),(323,23,2,'2015-02-05',3,''),(324,23,2,'2015-01-30',8,''),(325,23,2,'2015-01-30',7,''),(326,23,2,'2015-01-30',2,''),(327,69,2,'2015-01-30',5,''),(328,23,2,'2015-01-30',7,'mittarointia ja sellasta yleistä kakkaa'),(329,23,2,'2015-01-30',7,'mittarointia ja sellasta yleistä kakkaa'),(330,71,1,'2015-02-05',4,''),(331,72,1,'2015-02-05',1,''),(333,71,1,'2015-02-04',1.5,''),(334,61,1,'2015-02-04',1.5,'Valaisintarjous'),(335,71,1,'2015-02-06',0.5,'Tarjouksen viimeistely ja lähetys'),(336,73,1,'2015-02-04',1.5,''),(337,61,1,'2015-02-06',0.5,'Lattialämmitysten tilaus'),(338,73,1,'2015-02-09',4,''),(340,72,1,'2015-02-09',4,''),(341,24,2,'2015-02-09',6,''),(342,79,1,'2015-02-11',7.5,''),(343,80,1,'2015-02-10',5.5,''),(344,74,1,'2015-02-12',8,''),(345,69,1,'2015-02-12',2,''),(346,55,1,'2015-02-13',8,''),(347,81,1,'2015-02-16',3,'Työpiirustukset & Johdotus tavaran tilaus'),(348,71,1,'2015-02-16',2.5,'Maakaapeli tavaroiden tilaus'),(349,29,1,'2015-02-16',3.5,'Maakaapeli tavaroiden tilaus'),(350,75,1,'2015-02-17',14,''),(351,23,1,'2015-02-23',4,''),(352,23,1,'2015-02-25',2.5,''),(353,35,1,'2015-02-25',6.5,''),(355,35,1,'2015-02-26',3.5,''),(356,74,2,'2015-02-12',8,''),(357,75,2,'2015-02-17',12,''),(360,75,2,'2015-02-18',8,''),(361,75,2,'2015-02-20',6.5,''),(365,23,2,'2015-02-23',6,''),(366,23,2,'2015-02-25',2,''),(367,35,2,'2015-02-25',6,''),(368,35,2,'2015-02-26',3,''),(369,55,2,'2015-02-13',8,''),(370,83,1,'2015-03-02',4,''),(371,56,1,'2015-03-10',6.5,''),(373,55,1,'2015-03-09',8,''),(374,55,2,'2015-03-09',8,''),(375,55,2,'2015-03-10',9,''),(376,85,1,'2015-03-11',2.5,'suunnittelu + Tarjous'),(379,84,1,'2015-03-11',2,'Tarjous'),(382,85,1,'2015-03-06',5,''),(383,84,1,'2015-03-05',5,''),(384,84,1,'2015-03-04',1,''),(385,84,1,'2015-03-03',1.5,'Palaveri'),(386,85,1,'2015-03-03',1.5,'Palaveri'),(387,85,1,'2015-03-03',1,'pistekuvat'),(388,84,1,'2015-03-03',1,'pistekuvat'),(389,23,1,'2015-03-12',2,''),(390,24,1,'2015-03-12',1,''),(391,30,1,'2015-03-12',1,''),(397,91,1,'2015-03-19',2,''),(398,88,1,'2015-03-19',2,''),(399,94,1,'2015-03-24',8,''),(400,94,1,'2015-03-25',9,''),(401,91,1,'2015-03-31',8,''),(402,77,1,'2015-04-02',8,''),(403,99,1,'2015-04-04',3,'Aluekaapelit'),(404,99,1,'2015-04-07',1,'Selvitykset liittymän isontaminen & Palovaroitin'),(405,99,1,'2015-04-08',6,'Palovaroitin, Turvavalot, Valaistus'),(406,99,1,'2015-04-09',6,'ATK, Antenni, Valaistus ohjaukset, '),(408,86,1,'2015-03-26',8,''),(409,86,1,'2015-03-27',8,''),(410,99,1,'2015-04-13',1.5,'Varasto, Antennilaskelmat, Hoivatilat hyväksytys'),(411,31,1,'2015-04-13',8,''),(412,95,2,'2015-04-13',6,''),(413,95,2,'2015-04-14',6,''),(414,95,1,'2015-04-15',3,''),(415,95,1,'2015-04-14',5,''),(416,95,1,'2015-04-16',9,''),(417,58,2,'2015-04-17',7,'Autotalli kalustus'),(419,94,2,'2015-03-23',12,''),(420,94,2,'2015-03-24',5,''),(423,91,2,'2015-03-31',10,''),(424,93,2,'2015-04-01',2,''),(425,91,2,'2015-04-01',1,''),(426,77,2,'2015-04-02',7,'Talon katot valmiit'),(427,95,2,'2015-04-15',6,''),(428,95,2,'2015-04-16',1,''),(429,95,2,'2015-04-20',4,''),(431,31,2,'2015-04-20',4,'maakaapelointi ja suunnittelu'),(432,88,2,'2015-03-18',2,''),(433,100,1,'2015-04-20',1.5,''),(434,108,1,'2015-04-20',4,''),(435,99,1,'2015-04-20',4.5,''),(436,99,1,'2015-04-17',4,''),(437,99,1,'2015-04-15',3,''),(438,88,2,'2015-04-29',8,''),(439,88,2,'2015-04-30',4,''),(440,90,2,'2015-04-30',2.5,''),(441,95,2,'2015-04-28',2,''),(442,101,1,'2015-05-08',8.5,''),(443,102,2,'2015-05-07',8.5,''),(444,102,2,'2015-05-08',2.5,''),(445,101,2,'2015-05-08',6.5,''),(446,100,2,'2015-05-08',4,''),(451,95,1,'2015-05-12',4,''),(452,97,1,'2015-05-12',2,''),(453,98,1,'2015-05-04',3,''),(454,83,1,'2015-05-13',1,''),(458,109,1,'2015-05-13',4,''),(459,36,1,'2015-05-13',1,''),(461,82,1,'2015-05-13',2.5,'Laskenta kuvista & Sopimuksen valmistelu'),(462,118,1,'2015-05-13',2,'Laskenta kuvista & Sopimuksen valmistelu'),(464,119,1,'2015-05-13',1.5,''),(465,93,1,'2015-05-13',0.5,''),(466,76,1,'2015-05-13',0.5,''),(467,92,1,'2015-05-18',12,''),(468,89,1,'2015-05-19',4,''),(469,121,1,'2015-05-26',24,''),(470,77,2,'2015-05-12',6.5,''),(471,95,2,'2015-05-11',5,''),(472,133,1,'2015-05-28',1.5,'Tavaran vastaanotto'),(476,119,1,'2015-05-28',4.5,'pumppaamo'),(478,103,1,'2015-05-29',5,''),(479,117,1,'2015-05-29',1.5,''),(480,92,2,'2015-05-28',4,''),(481,103,2,'2015-05-28',4,''),(482,103,2,'2015-05-29',8,''),(483,132,1,'2015-06-01',1,'Valmistautuminen suunnittelupalaveriin'),(484,84,1,'2015-06-01',0.5,'Muutostyöt'),(485,103,3,'2015-06-01',9.5,''),(486,103,2,'2015-06-01',9,''),(487,117,1,'2015-06-03',3.5,''),(488,117,1,'2015-06-04',8.5,''),(491,117,1,'2015-06-05',8.5,''),(492,103,2,'2015-06-04',7.5,''),(493,103,2,'2015-06-05',5,''),(494,117,2,'2015-06-05',2,''),(496,136,1,'2015-06-04',3,'Tuntiraportti uusiksi & Päivärahat'),(497,136,1,'2015-06-05',5,'Oikeudet,Tuntiraportti, valmiusasteraportti, bugikorj.'),(498,103,2,'2015-06-09',7,''),(499,103,2,'2015-06-08',8.5,''),(500,137,1,'2015-06-12',2.5,''),(501,137,1,'2015-06-10',4,''),(502,86,1,'2015-06-10',2.5,'Aulavalot + kaijutin kaapeli tilaukset'),(503,77,2,'2015-06-11',6,''),(504,117,2,'2015-06-12',1,''),(505,103,2,'2015-06-12',7,''),(507,58,2,'2015-06-10',2,''); /*!40000 ALTER TABLE `PSH` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Pa` -- DROP TABLE IF EXISTS `Pa`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Pa` ( `Pa_id` int(11) NOT NULL AUTO_INCREMENT, `PG_id` int(11) NOT NULL, `nimi` varchar(50) NOT NULL, `info` varchar(200) NOT NULL, PRIMARY KEY (`Pa_id`) ) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Pa` -- LOCK TABLES `Pa` WRITE; /*!40000 ALTER TABLE `Pa` DISABLE KEYS */; INSERT INTO `Pa` VALUES (1,13,'Pistorasia 2-os kokopeitelevy',''),(2,13,'Pistorasia 2-os keskiölevy',''),(3,5,'Kojerasia','Yksittäiselle kojeelle'),(4,9,'Peitelevy','1+2'),(5,1,'Poista',''),(6,1,'Kojerasia','1+2 peitelevylle'),(7,1,'Kojerasia','1+1 Peitelevylle'),(8,9,'Peitelevy','1+1'),(9,3,'K6 / K1',''),(10,3,'K5',''),(11,3,'Atk piste',''),(12,3,'Antenni piste',''),(13,9,'Peitelevy','1'),(14,9,'Peitelevy','2'),(15,9,'Peitelevy','3'),(16,9,'Peitelevy','4'),(17,9,'Peitelevy','5'),(18,5,'Kojerasia','2os peitelevylle'),(19,1,'Kojerasia','3os peitelevylle'),(20,8,'Pistorasia 1-os kokopeitelevy',''),(21,1,'K2',''),(22,1,'Pr + Ant ryhmä',''),(23,1,'Pr + Atk + Ant Ryhmä',''),(24,1,'Jakorasia',''),(25,1,'Jakorasia+kansi',''),(26,1,'Ovikello','BigBen'),(27,1,'Ovikellon painike',''),(28,1,'Kattokoukku, uppo',''),(29,1,'Kattokoukku, Pinta',''),(30,1,'Palovaroitin','Ioni-ilmaisin'),(31,1,'Jakorasia valaisimen alla',''),(32,1,'Kojerasia, etukiinnitys',''),(33,1,'Puolikiinteä laite',''),(34,13,'Pistorasia 2-os ip44',''),(35,1,'Rasiakoje','ei kalustetta'),(36,1,'Jakorasia','etukiinnitys'),(37,1,'poista',''),(38,1,'Turvakytkin','< 7,5kW'),(39,1,'Hämäräkytkin',''),(40,1,'Liiketunnistin seinä as',''),(41,3,'K7',''),(42,1,'Kojerasia 4os peitelevylle',''),(43,3,'Pistorasia 1-os keskiölevy',''),(44,1,'Peitelevy 2 100mm',''),(45,2,'MMJ 3x1,5S',''),(46,2,'MMJ 3x1,5N',''),(47,1,'MMJ 3x2,5S',''),(48,1,'MMJ 5X1.5 S',''),(49,1,'MMJ 5X2.5 S',''),(50,2,'Japp 20','Putkitus'),(51,1,'16mm Kupariköysi',''),(52,1,'Uppo asennus','< 2,5mm2'),(53,2,'Maa asennus',''),(54,2,'Alakautta valussa',''),(55,1,'MCMK 2X1.5+1.5 S',''),(56,1,'MCMK 2X2.5+2.5 S',''),(57,1,'MCMK 4X1.5+1.5',''),(58,1,'2x4P F/UTP CAT6',''),(59,1,'MCMK 4x16+16',''),(60,2,'Alakautta valussa <16mm2',''),(61,2,'MKEM 90 16 KEVI (H07V2-K)',''),(62,1,'MK6 kevi',''),(63,1,'Valaisinripustuskisko',''),(64,1,'FRHF 2X6',''),(65,6,'Japp 25',''),(66,1,'Tikashylly 300mm','Kattokannatus'),(67,1,'Toimistokouru 135x65',''),(68,1,'Jakorasia Pinta',''),(69,1,'Kojerasia varaus',''),(70,1,'Läsnäolotunnistin',''),(71,1,'Pistorasia 2-os pinta',''),(72,1,'Pistorasia 2-os pinta kosti',''),(73,1,'Pistorasia 4-os pinta',''),(74,1,'Valaisin',''),(75,1,'Kytkentä MMJ 3x1,5',''),(76,1,'Kytkentä MMJ 5x1,5',''),(77,1,'Kytkentä 3x2,5',''),(78,1,'Kytkentä 5x2,5',''),(79,1,'Kytkentä MCMK 2X1.5+1.5 S',''),(80,1,'Kytkentä MCMK 4X1.5+1.5',''),(81,1,'Kytkentä MCMK 2x2.5+2.5',''),(82,1,'Kytkentä MCMK 4x2.5+2.5',''),(83,1,'Kytkentä MCMK 4x16+16',''),(84,1,'MMJ 5X1.5 N',''),(85,1,'KLMA 4X0.8+0.8',''),(86,1,'Tellu 13',''),(87,1,'MCMK 4X2.5+2.5 S',''),(88,1,'MCMK 4X6+6 S',''),(89,1,'Maakaapeli 6mm2 50 putkeen',''),(90,1,'Huoneiston atk kaapelit',''),(91,1,'Maakaapeli 2,5mm 3kaapelia/50putki',''),(92,5,'Kojerasia 2/2 peitelevylle',''),(93,9,'Peitelevy 2/2',''),(94,9,'Peitelevy 2+0/2',''),(95,5,'Kojerasia 1/2 peitteelle',''),(96,9,'Peitelevy 1+0/2',''),(97,1,'Peitelevy100 1xpr',''),(98,7,'Valaisin+jr',''),(99,8,'Pistorasia 1-os pinta',''),(100,2,'MMJ 5x6 S',''),(101,1,'Tikashylly 500mm','kattokannatus'),(102,1,'Pintakoje','ei kalusteen toimitusta'),(103,1,'K6 / K1 Pinta ip44',''),(104,1,'Puolikiinteä laite','pinta-as'),(105,1,'K6 / K1 Pinta',''),(106,3,'Himmennin',''),(107,1,'K6+6',''),(108,1,'Painonappi',''),(109,1,'Peitelevy 3+0',''),(110,1,'Kojerasia 3+0',''),(111,3,'Aikakytkin',''),(112,1,'Voimavirtapistorasia',''),(113,1,'Putkitus JM20',''),(114,11,'2-os pr kokopeite',''),(115,8,'2-os pr kokopeite',''),(116,8,'2-os pr',''),(117,1,'2-os pr',''),(118,8,'2-os pr kokopeite ip44',''),(119,11,'2-os pr kokopeite ip44',''),(120,12,'Peitelevy 0+3',''),(121,8,'Atk Piste',''),(122,11,'Atk Piste',''),(123,12,'Sovite 85->100',''),(124,8,'Antenni piste',''),(125,11,'Antenni piste',''),(126,8,'K5',''),(127,11,'k5',''),(128,8,'K6',''),(129,11,'k6',''),(130,12,'Peitelevy 1',''),(131,12,'Peitelevy 2',''),(132,12,'Peitelevy 3',''),(133,12,'Peitelevy 4',''),(134,12,'Peitelevy 5',''),(135,12,'Peitelevy 4 100mm',''),(136,13,'ATK Piste pinta',''),(137,13,'Antenni piste pinta',''),(138,12,'Peitelevy 3+0',''),(139,2,'Datajamak 2x(2+1)x0.24',''),(140,8,'1-os pr kokopeite','jussi'),(141,11,'1-os pr kokopeite','Impressivo'),(142,2,'Johto elementtiin',''),(143,5,'Kojerasia','elementtiin'),(144,13,'Europistorasia',''),(145,1,'Europistorasia','Jussi'),(146,9,'Peitelevy','1+3 Jussi'),(147,1,'Johto Onteloon',''),(148,1,'Profit cat6+tellu13',''),(149,1,'FRHF 5x2,5 S',''),(150,1,'Kojerasia','Roilo'),(151,1,'Kojerasia 2','Roilo'),(152,1,'Kojerasia 1+2','Roilo'),(153,1,'Tikashylly 500m','seinäkannatus'),(154,2,'MCMK 4x10+10',''),(155,1,'< 6mm2 CU Uppo',''),(156,1,'< 16mm2 Cu uppo',''),(157,1,'MMJ 5x10',''),(158,1,'MMJ 5x16',''); /*!40000 ALTER TABLE `Pa` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PaC` -- DROP TABLE IF EXISTS `PaC`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PaC` ( `PaC_id` int(11) NOT NULL AUTO_INCREMENT, `Pa_id` int(11) NOT NULL, `count` int(11) NOT NULL, `c1` varchar(40) NOT NULL, `v1` varchar(40) NOT NULL, `c2` varchar(40) NOT NULL, `v2` varchar(40) NOT NULL, PRIMARY KEY (`PaC_id`) ) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `PaC` -- LOCK TABLES `PaC` WRITE; /*!40000 ALTER TABLE `PaC` DISABLE KEYS */; INSERT INTO `PaC` VALUES (8,2,1,'Nimitys','Kojerasia','',''),(9,1,1,'Nimitys','Kojerasia','',''),(12,9,1,'Nimitys','Kojerasia','',''),(13,9,1,'Nimitys','Peitelevy','',''),(14,10,1,'Nimitys','Kojerasia','',''),(15,10,1,'Nimitys','Peitelevy','',''),(16,11,1,'Nimitys','Kojerasia','',''),(20,12,1,'Nimitys','Peitelevy','',''),(21,12,1,'Nimitys','Kojerasia','',''),(22,11,1,'Nimitys','Peitelevy','',''),(23,20,1,'Nimitys','Kojerasia','',''),(24,21,1,'Nimitys','Kojerasia','',''),(25,21,1,'Nimitys','Peitelevy','',''),(26,22,1,'Nimitys','Pistorasia, 2-os., suojakosketin, uppo','',''),(27,22,1,'Nimitys','Antennipistorasia, uppo','',''),(29,23,1,'Nimitys','Pistorasia, 2-os., suojakosketin, uppo','',''),(30,23,1,'Nimitys','Antennipistorasia, uppo','Peitelevy','2'),(31,23,1,'Nimitys','ATK-pistorasia, uppoasennus','Peitelevy','2'),(33,25,1,'Nimitys','Jakorasia','',''),(34,28,1,'Nimitys','Jakorasia','',''),(35,31,1,'Nimitys','Jakorasia','',''),(36,33,1,'Nimitys','Jakorasia','',''),(37,34,1,'Nimitys','Kojerasia','',''),(38,35,1,'Nimitys','Kojerasia','',''),(39,41,1,'Nimitys','Kojerasia','',''),(40,41,1,'Nimitys','Peitelevy','',''),(41,43,1,'Nimitys','Kojerasia','',''),(42,43,1,'Nimitys','Peitelevy','',''),(53,45,1,'Nimitys','Asennustapa johto','',''),(54,46,1,'Nimitys','Asennustapa johto','',''),(55,47,1,'Nimitys','Asennustapa johto','',''),(56,48,1,'Nimitys','Asennustapa johto','',''),(60,51,1,'Nimitys','Asennustapa maakaapeli','',''),(61,55,1,'Nimitys','Asennustapa maakaapeli','',''),(62,56,1,'Nimitys','Asennustapa maakaapeli','',''),(63,57,1,'Nimitys','Asennustapa maakaapeli','',''),(64,58,1,'Nimitys','Asennustapa johto','',''),(66,59,1,'Nimitys','Asennustapa maakaapeli','Poikkipinta','16'),(67,61,1,'Nimitys','Asennustapa johto','',''),(68,62,1,'Nimitys','Asennustapa johto','',''),(70,64,1,'Nimitys','Asennustapa johto','Poikkipinta','6'),(71,69,1,'Nimitys','Kojerasia','',''),(72,69,1,'Nimitys','Peitelevy','',''),(73,84,1,'Nimitys','Asennustapa johto','',''),(74,85,1,'Nimitys','Asennustapa johto','',''),(75,86,1,'Nimitys','Asennustapa johto','',''),(77,30,1,'Nimitys','Kojerasia','',''),(78,87,1,'Nimitys','Asennustapa maakaapeli','',''),(81,88,1,'Nimitys','Asennustapa maakaapeli','',''),(83,90,1,'Nimitys','Asennustapa maakaapeli','',''),(85,93,0,'','','',''),(89,98,1,'Nimitys','Jakorasia','',''),(91,49,1,'Nimitys','Asennustapa johto','',''),(92,106,1,'Nimitys','Peitelevy','',''),(93,106,1,'Nimitys','Kojerasia','',''),(94,107,1,'Nimitys','Kojerasia','',''),(95,107,1,'Nimitys','Peitelevy','',''),(96,108,1,'Nimitys','Peitelevy','',''),(97,108,1,'Nimitys','Kojerasia','',''),(98,111,1,'Nimitys','Kojerasia','',''),(99,111,1,'Nimitys','Peitelevy','',''),(101,1,1,'Nimitys','Kaluste','Kaluste','2-os pr kokopeite'),(102,2,1,'Nimitys','Kaluste','Kaluste','2-os pr'),(103,34,1,'Nimitys','Kaluste','Kaluste','2-os pr kokopeite ip44'),(104,11,1,'Nimitys','Kaluste','Kaluste','atk piste'),(106,2,1,'Nimitys','Peitelevy100','',''),(107,123,1,'Nimitys','Peitelevy100','',''),(108,12,1,'Nimitys','Kaluste','Kaluste','antenni piste'),(109,10,1,'Nimitys','Kaluste','Kaluste','k5'),(110,9,1,'Nimitys','Kaluste','Kaluste','k6'),(111,136,1,'Nimitys','Kaluste','Kaluste','atk piste'),(112,137,1,'Nimitys','Kaluste','Kaluste','antenni piste'),(113,139,1,'Nimitys','Asennustapa johto','',''),(118,20,1,'Nimitys','Kaluste','Kaluste','1-os pr kokopeite'),(119,144,1,'Nimitys','Kojerasia','',''),(120,144,1,'Nimitys','Peitelevy','',''),(122,144,1,'Nimitys','Kaluste','Kaluste','europr'),(124,149,1,'Nimitys','Asennustapa johto','',''),(126,154,1,'Nimitys','Asennustapa maakaapeli','',''),(128,157,1,'Nimitys','Asennustapa johto','Poikkipinta','10'),(129,158,1,'Nimitys','Asennustapa johto','Poikkipinta','16'),(134,100,1,'Nimitys','Asennustapa johto','Poikkipinta','6'); /*!40000 ALTER TABLE `PaC` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PaL` -- DROP TABLE IF EXISTS `PaL`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PaL` ( `PaL_id` int(11) NOT NULL AUTO_INCREMENT, `Pa_id` int(11) NOT NULL, `S_id` int(11) NOT NULL, `L_id` int(11) NOT NULL, `count` float NOT NULL, PRIMARY KEY (`PaL_id`) ) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `PaL` -- LOCK TABLES `PaL` WRITE; /*!40000 ALTER TABLE `PaL` DISABLE KEYS */; INSERT INTO `PaL` VALUES (3,3,2,52,1),(4,3,1,31,1.1),(5,4,3,85,0.33333),(7,6,1,52,1),(8,6,1,31,1.2),(9,6,1,58,0.66666),(10,6,1,38,2),(11,7,1,52,1),(12,7,1,31,1),(13,7,1,38,2),(14,7,1,58,0.5),(15,8,3,84,0.5),(23,13,3,74,1),(24,14,3,75,0.5),(25,15,3,76,0.33333),(26,16,3,77,0.25),(27,17,3,78,0.2),(28,18,1,52,1),(29,18,1,31,1.2),(30,18,1,38,2),(31,18,1,58,0.5),(32,19,1,52,1),(33,19,1,31,1.2),(34,19,1,58,0.66667),(35,19,1,38,2),(37,21,3,66,1),(38,24,1,51,1),(39,24,1,31,6),(40,25,3,94,1),(41,26,3,98,1),(42,27,3,99,1),(43,28,3,101,1),(44,29,3,100,1),(45,30,3,104,1),(46,32,3,103,1),(47,33,3,106,1),(48,33,3,108,1),(50,36,3,102,1),(52,38,3,119,1),(54,39,3,116,1),(55,40,3,114,1),(56,41,3,68,1),(57,42,1,24,1),(58,42,1,31,1),(59,42,1,58,1),(60,43,3,63,1),(61,44,3,80,0.5),(62,45,1,126,1.07),(63,46,1,124,1.07),(64,47,1,127,1.07),(66,48,1,128,1.07),(67,49,1,129,1.07),(69,50,3,133,1),(70,50,3,137,2),(71,50,3,135,1),(72,51,4,121,1.07),(73,55,4,139,1.07),(74,56,4,141,1.07),(75,57,4,143,1.07),(76,58,1,144,1.07),(77,59,4,146,1.07),(79,62,1,132,1.07),(80,63,3,151,1.07),(81,63,3,152,0.167),(82,63,3,153,0.4),(83,64,1,154,1.07),(84,65,3,138,1),(85,65,3,136,0.5),(86,65,3,134,1),(91,67,3,157,1),(92,68,3,170,1),(93,70,3,171,1),(94,71,3,174,1),(95,72,3,111,1),(96,73,3,175,1),(97,84,1,125,1.07),(98,85,1,122,1.07),(99,86,1,176,1.07),(100,87,4,141,1.07),(102,89,4,177,1),(103,90,4,180,1.07),(104,90,4,179,1.07),(105,90,4,178,1.07),(106,91,4,177,1),(107,92,1,52,1),(108,92,1,31,1),(109,92,1,58,0.5),(110,92,1,38,2),(111,92,1,60,0.25),(112,93,3,75,0.5),(113,94,3,75,0.25),(114,94,3,80,0.25),(115,95,1,52,1),(116,95,1,38,2),(117,95,1,58,0.5),(118,95,1,60,0.25),(119,96,3,75,0.33),(120,99,3,173,1),(121,61,1,181,1.07),(123,100,1,182,1.07),(127,103,3,185,1),(128,104,3,187,1),(129,104,3,108,1),(130,105,3,189,1),(131,106,3,192,1),(132,106,3,74,-1),(133,107,3,69,1),(134,108,3,72,1),(135,109,3,81,1),(136,110,1,52,1),(137,110,1,31,1),(138,110,1,38,1.2),(139,110,1,58,0.75),(140,111,3,194,1),(141,112,3,193,1),(142,88,4,195,1),(144,115,3,64,1),(145,114,3,238,1),(146,116,3,62,1),(147,117,3,237,1),(148,118,3,112,1),(149,119,3,239,1),(150,120,3,231,0.3333),(153,121,3,249,1),(154,121,3,250,1),(155,122,3,247,1),(156,122,3,248,1),(157,123,3,227,1),(158,12,3,91,1),(159,124,3,88,1),(160,125,3,245,1),(161,12,2,261,1),(163,126,3,71,1),(164,127,3,211,1),(165,128,3,67,1),(166,129,3,213,1),(167,130,3,222,1),(168,131,3,223,0.5),(169,132,3,224,0.3333),(170,133,3,225,0.25),(171,134,3,226,0.2),(172,113,7,263,1),(173,113,7,265,0.5),(174,135,3,232,1),(183,0,0,0,0),(184,0,0,0,0),(185,0,0,0,0),(189,121,3,251,4),(190,122,3,251,4),(191,136,3,196,1),(192,137,3,196,1),(193,137,3,91,1),(194,137,2,261,1),(195,138,3,231,0.333),(196,139,1,266,1.07),(197,140,3,65,1),(198,141,3,236,1),(199,142,7,267,0.3),(200,143,7,52,0.2),(201,145,3,268,1),(202,146,3,86,0.25),(203,148,7,269,1.1),(204,149,1,270,1.07),(205,150,7,52,1),(206,150,7,57,1),(207,150,7,267,0.8),(208,151,7,52,1),(209,151,7,57,1),(210,151,7,58,0.5),(211,151,7,267,1),(212,152,7,52,1),(213,152,7,267,0.3),(214,152,7,58,0.333),(215,152,7,57,1),(216,66,8,272,1),(217,66,8,274,0.333),(219,66,8,276,0.5),(220,66,8,289,0.5),(221,66,8,287,0.5),(222,101,8,273,1),(223,101,8,277,0.5),(224,101,8,287,0.5),(225,101,8,289,0.5),(226,101,8,274,0.333),(227,153,8,273,1),(228,153,8,274,0.333),(229,153,8,299,0.5),(230,154,4,145,1.07),(231,157,1,130,1.07),(232,158,1,300,1.07); /*!40000 ALTER TABLE `PaL` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PaR` -- DROP TABLE IF EXISTS `PaR`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PaR` ( `PaR_id` int(11) NOT NULL AUTO_INCREMENT, `Pa_id` int(11) NOT NULL, `c` varchar(40) NOT NULL, `v` varchar(100) NOT NULL, `term` tinyint(1) NOT NULL, PRIMARY KEY (`PaR_id`) ) ENGINE=InnoDB AUTO_INCREMENT=421 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `PaR` -- LOCK TABLES `PaR` WRITE; /*!40000 ALTER TABLE `PaR` DISABLE KEYS */; INSERT INTO `PaR` VALUES (2,1,'Peitelevy','',0),(4,2,'Peitelevy','',1),(5,3,'Nimitys','Kojerasia',0),(6,3,'Peitelevy','',0),(9,2,'Nimitys','Pistorasia, 2-os., suojakosketin, uppo',0),(10,1,'Nimitys','Pistorasia, 2-os., suojakosketin, uppo',0),(13,4,'Peitelevy','1+2',0),(16,3,'Peitelevy','1',0),(17,6,'Nimitys','Kojerasia',0),(18,6,'Peitelevy','1+2',0),(19,7,'Nimitys','Kojerasia',0),(20,7,'Peitelevy','1+1',0),(24,8,'Peitelevy','1+1',0),(25,8,'Nimitys','Peitelevy 2os pr',0),(27,10,'Nimitys','Kruunukytkin, uppo',0),(28,9,'Nimitys','Vaihtokytkin, uppo',0),(29,9,'Nimitys','Kytkin, 1-napainen, uppo',0),(30,11,'Nimitys','ATK-pistorasia, uppoasennus',0),(31,12,'Nimitys','Antennipistorasia, uppo',0),(32,8,'Nimitys','Peitelevy',0),(33,4,'Nimitys','Peitelevy',0),(35,13,'Nimitys','Peitelevy',0),(36,13,'Peitelevy','1',0),(37,13,'Peitelevy','',0),(38,14,'Nimitys','Peitelevy',0),(39,14,'Peitelevy','2',0),(40,15,'Nimitys','Peitelevy',0),(41,15,'Peitelevy','3',0),(42,16,'Nimitys','Peitelevy',0),(43,16,'Peitelevy','4',0),(44,17,'Nimitys','Peitelevy',0),(45,17,'Peitelevy','5',0),(46,18,'Nimitys','Kojerasia',0),(47,18,'Peitelevy','2',0),(48,19,'Nimitys','Kojerasia',0),(49,19,'Peitelevy','3',0),(50,20,'Nimitys','Pistorasia, 1-os., suojakosketin, uppo',0),(51,20,'Peitelevy','',0),(52,21,'Nimitys','Kytkin, 2-napainen, uppo',0),(53,22,'Nimitys','Pistorasia+Antenni',0),(54,23,'Nimitys','Pistorasia+Atk+Antenni',0),(56,24,'Nimitys','Jakorasia',0),(60,26,'Nimitys','Soittokello',0),(62,28,'Nimitys','Valopiste, pistorasia',0),(63,28,'Asennustapa','',0),(64,29,'Nimitys','Valopiste, pistorasia',0),(65,29,'Asennustapa','pinta',0),(66,30,'Nimitys','Ioni-ilmaisin',0),(67,3,'Asennustapa','',0),(68,32,'Nimitys','Kojerasia',0),(69,32,'Peitelevy','1',0),(70,32,'Peitelevy','',0),(71,32,'Asennustapa','etukiinnitys',0),(72,25,'Nimitys','Jakorasia seinässä, uppoas.',0),(73,33,'Nimitys','Jakorasia seinässä, puolikiinteä, uppoas.',0),(74,34,'Nimitys','Pistorasia, 2-os., IP44, uppo',0),(75,35,'Nimitys','TERM',0),(76,25,'Nimitys','Jakorasia katossa, uppoas.',0),(77,24,'Asennustapa','etukiinnitys',1),(78,36,'Nimitys','Jakorasia',0),(79,36,'Asennustapa','etukiinnitys',0),(81,38,'Nimitys','Turvakytkin, 3-napainen',0),(83,38,'Tuotetieto','',0),(84,39,'Nimitys','Hämäräkytkin',0),(85,40,'Nimitys','Infrapunatutka',0),(86,1,'Nimitys','Pistorasia, 2-os., lisätekstillä, uppo',0),(87,20,'Nimitys','Pistorasia, 1-os., lisätekstillä, uppo',0),(88,41,'Nimitys','Ristikytkin, uppo',0),(89,42,'Nimitys','Kojerasia',0),(90,42,'Peitelevy','4',0),(91,43,'Nimitys','Pistorasia, 1-os., suojakosketin, uppo',0),(92,43,'Peitelevy','',1),(93,44,'Nimitys','Peitelevy',0),(96,44,'Peitelevy','2+0',0),(97,45,'Nimitys','MMJ 3X1.5 S',0),(99,46,'Nimitys','MMJ 3X1.5 N',0),(101,47,'Nimitys','MMJ 3X2.5 S',0),(103,48,'Nimitys','MMJ 5X1.5 S',0),(105,49,'Nimitys','MMJ 5X2.5 S',0),(111,50,'Asennustapa','jappi',0),(112,51,'Nimitys','HK 16',0),(113,50,'Nimitys','Asennustapa johto',0),(114,52,'Nimitys','Asennustapa johto',0),(115,52,'Asennustapa','',0),(116,53,'Nimitys','Asennustapa maakaapeli',0),(117,53,'Asennustapa','',0),(118,54,'Nimitys','Asennustapa maakaapeli',0),(119,54,'Asennustapa','valu',0),(120,55,'Nimitys','MCMK 2X1.5+1.5 S',0),(121,56,'Nimitys','MCMK 2X2.5+2.5 S',0),(122,57,'Nimitys','MCMK 4X1.5+1.5',0),(123,58,'Nimitys','4P F/UTP CAT6',0),(124,59,'Nimitys','MCMK 4X16/16',0),(125,54,'Poikkipinta','',0),(126,60,'Nimitys','Asennustapa maakaapeli',0),(127,60,'Asennustapa','valu',0),(128,60,'Poikkipinta','16',0),(129,61,'Nimitys','MKEM 90 16 KEVI (H07V2-K)',0),(130,62,'Nimitys','MKEM 90 6 KEVI (H07V2-K)',0),(131,63,'Nimitys','Valaisinripustuskisko 80',0),(132,64,'Nimitys','AFUMEX FRHF 2X6 750V',0),(133,65,'Nimitys','Asennustapa johto',0),(134,65,'Poikkipinta','6',0),(135,50,'Poikkipinta','',0),(137,67,'Nimitys','Johtokouru/-kanava 135x65',0),(138,68,'Nimitys','Jakorasia katossa, pinta-as.',0),(139,68,'Nimitys','Jakorasia seinässä, pinta-as.',0),(140,69,'Nimitys','Kojerasia, uppoas.',0),(141,70,'Nimitys','Liiketutka',0),(142,71,'Nimitys','Pistorasia, 2-os., suojakosketin, pinta',0),(143,72,'Nimitys','Pistorasia, 2-os., IP44, pinta',0),(144,73,'Nimitys','Pistorasia, 4-os., suojakosketin, pinta',0),(145,74,'Nimitys','Valaisin',0),(146,74,'Nimitys','Seinävalaisin',0),(147,74,'Nimitys','Valonheitin',0),(148,74,'Nimitys','Turvavalaisin',0),(149,74,'Nimitys','Merkkivalaisin seinässä',0),(150,74,'Nimitys','2X49W',0),(152,75,'Johdotus','MMJ 3x1,5 S',0),(154,76,'Johdotus','MMJ 5x1,5 S',0),(155,76,'Johdotus','MMJ 5x1,5 N',0),(156,75,'Johdotus','MMJ 3x1,5 N',0),(157,77,'Johdotus','MMJ 3x2,5 S',0),(158,78,'Johdotus','MMJ 5x2,5 S',0),(159,79,'Johdotus','MCMK 2x1,5+1,5 S',0),(160,80,'Johdotus','MCMK 4x1,5+1,5',0),(161,81,'Johdotus','MCMK 2x2,5+2,5 S',0),(162,82,'Johdotus','MCMK 4x2,5+2,5',0),(163,83,'Johdotus','MCMK 4x16/16',0),(164,84,'Nimitys','MMJ 5X1.5 N',0),(165,85,'Nimitys','KLMA 4X0.8+0.8',0),(167,74,'Nimitys','Seinävalopiste',0),(168,74,'Nimitys','Loisteputkivalaisin, 18 W, kaksoispistorasia, kytkin, seinäas.',0),(169,27,'Nimitys','Telepainike, pinta',0),(170,87,'Nimitys','MCMK 4X2.5+2.5 S',0),(171,88,'Nimitys','MCMK 4X6+6 S',0),(172,89,'Nimitys','Asennustapa maakaapeli',0),(174,90,'Nimitys','ATK huoneisto',0),(175,89,'Poikkipinta','6',0),(176,89,'Asennustapa','50putki',0),(177,91,'Nimitys','Asennustapa maakaapeli',0),(178,91,'Asennustapa','3/50putki',0),(179,35,'Nimitys','Termostaatti',0),(180,92,'Nimitys','Kojerasia',0),(182,93,'Nimitys','Peitelevy',0),(183,93,'Peitelevy','2/2',0),(184,44,'Peitelevy100','2',0),(186,92,'Peitelevy','2+0/2',0),(187,92,'Peitelevy','2/2',0),(188,94,'Nimitys','Peitelevy',0),(189,94,'Peitelevy','2+0/2',0),(190,95,'Nimitys','Kojerasia',0),(191,95,'Peitelevy','1/2',0),(192,95,'Peitelevy','1+0/2',0),(200,96,'Nimitys','Peitelevy',0),(201,96,'Peitelevy','1+0/2',0),(202,98,'Nimitys','Valaisin, rasia',0),(203,74,'Nimitys','Loisteputkivalaisin, 18 W, kaksoispistorasia, seinäas.',0),(204,99,'Nimitys','Pistorasia, 1-os., suojakosketin, pinta',0),(209,63,'Nimitys','VALAISINKISKO 80',0),(210,102,'Nimitys','Säädin ja kytkin, pinta',0),(211,102,'Nimitys','Painike, käyttösuoja, pinta',0),(212,74,'Nimitys','BOX',0),(213,103,'Nimitys','Kytkin, 1-napainen, pinta',0),(214,103,'Peitelevy','IP44',0),(215,74,'Nimitys','Merkkivalaisin, itsenäinen',0),(216,74,'Nimitys','Loisteputkivalaisin, 2x36 W',0),(217,74,'Nimitys','Turvavalaisin katossa, itsenäinen',0),(218,104,'Nimitys','Jakorasia seinässä, puolikiinteä, pinta-as.',0),(219,105,'Nimitys','Vaihtokytkin, pinta',0),(220,9,'Nimitys','1 - napainen uppoasennus',0),(221,9,'Nimitys','Vaihtokytkin uppoasennus',0),(222,10,'Nimitys','Kruunukytkin uppoasennus',0),(223,41,'Nimitys','Ristikytkin uppoasennus',0),(224,106,'Nimitys','Säädin ilman kytkintä uppoas',0),(225,107,'Nimitys','Kaksoiskytkin 2xvaihtokytkin uppoas',0),(226,107,'Nimitys','Vaihtokytkin + vaihtokytkin, uppo',0),(227,106,'Nimitys','Himmennin tehonsäädin uppoasennus',0),(228,35,'Nimitys','IV-ohjaus',0),(229,107,'Nimitys','Vaihtokytkin + 1-napainen, uppo',0),(230,108,'Nimitys','Painike, uppo',0),(231,109,'Nimitys','Peitelevy',0),(232,109,'Peitelevy','3+0',0),(233,110,'Nimitys','Kojerasia',0),(234,110,'Peitelevy','3+0',0),(235,111,'Nimitys','Kellokytkin kojerasiaan',0),(236,111,'Nimitys','Aikakytkin, uppo',0),(237,112,'Nimitys','3L+N+PE 3 x 16 A',0),(238,112,'Nimitys','Pistorasia, 3-vaihe, suojakosketin, uppo',0),(239,112,'Nimitys','Pistorasia, 3-vaihe, suojakosketin, pinta',0),(240,113,'Nimitys','Asennustapa johto',0),(241,113,'Asennustapa','jm',0),(248,115,'Nimitys','Kaluste',0),(249,115,'Kaluste','2-os pr kokopeite',0),(250,115,'Kalustesarja','Jussi',0),(251,114,'Nimitys','Kaluste',0),(252,114,'Kaluste','2-os pr kokopeite',0),(253,114,'Kalustesarja','Impressivo',0),(254,116,'Nimitys','Kaluste',0),(255,116,'Kaluste','2-os pr',0),(256,116,'Kalustesarja','Jussi',0),(257,117,'Nimitys','Kaluste',0),(258,117,'Kaluste','2-os pr',0),(259,117,'Kalustesarja','Impressivo',0),(260,118,'Nimitys','Kaluste',0),(261,118,'Kaluste','2-os pr kokopeite ip44',0),(262,118,'Kalustesarja','Jussi',0),(263,119,'Nimitys','Kaluste',0),(264,119,'Kaluste','2-os pr kokopeite ip44',0),(265,119,'Kalustesarja','Impressivo',0),(266,4,'Kalustesarja','Jussi',0),(267,4,'Nimitys','Peitelevy100',0),(269,120,'Peitelevy','0+3',0),(270,120,'Peitelevy','1+2',0),(271,120,'Kalustesarja','Impressivo',0),(272,121,'Nimitys','Kaluste',0),(273,121,'Kaluste','atk piste',0),(274,121,'Kalustesarja','Jussi',0),(275,122,'Nimitys','Kaluste',0),(276,122,'Kaluste','atk piste',0),(277,122,'Kalustesarja','Impressivo',0),(278,120,'Nimitys','Peitelevy100',0),(279,123,'Nimitys','Peitelevy',0),(280,123,'Peitelevy','1+2',0),(281,123,'Peitelevy','0+3',0),(282,123,'Kalustesarja','Impressivo',0),(283,124,'Nimitys','Kaluste',0),(284,124,'Kaluste','antenni piste',0),(285,124,'Kalustesarja','Jussi',0),(286,125,'Nimitys','Kaluste',0),(287,125,'Kaluste','antenni piste',0),(288,125,'Kalustesarja','Impressivo',0),(289,126,'Nimitys','Kaluste',0),(290,126,'Kaluste','k5',0),(291,126,'Kalustesarja','Jussi',0),(292,127,'Nimitys','Kaluste',0),(293,127,'Kaluste','k5',0),(294,127,'Kalustesarja','Impressivo',0),(295,128,'Nimitys','Kaluste',0),(296,128,'Kaluste','k6',0),(297,128,'Kalustesarja','Jussi',0),(298,129,'Nimitys','Kaluste',0),(299,129,'Kaluste','k6',0),(300,129,'Kalustesarja','Impressivo',0),(301,106,'Nimitys','Säädin ja kytkin, uppo',0),(302,13,'Kalustesarja','Jussi',0),(303,14,'Kalustesarja','Jussi',0),(304,15,'Kalustesarja','Jussi',0),(305,16,'Kalustesarja','Jussi',0),(306,17,'Kalustesarja','Jussi',0),(307,130,'Nimitys','Peitelevy',0),(308,130,'Peitelevy','1',0),(309,130,'Peitelevy','',0),(310,130,'Kalustesarja','Impressivo',0),(311,131,'Nimitys','Peitelevy',0),(312,131,'Peitelevy','2',0),(313,131,'Kalustesarja','Impressivo',0),(314,132,'Nimitys','Peitelevy',0),(315,132,'Peitelevy','3',0),(316,132,'Kalustesarja','Impressivo',0),(317,133,'Nimitys','Peitelevy',0),(318,133,'Peitelevy','4',0),(319,133,'Kalustesarja','Impressivo',0),(320,134,'Nimitys','Peitelevy',0),(321,134,'Peitelevy','5',0),(322,134,'Kalustesarja','Impressivo',0),(323,74,'Nimitys','Halogenivalaisin, upotettava',0),(324,74,'Nimitys','Loisteputkivalaisin, 18 W, seinäas., kytkin',0),(325,74,'Nimitys','Valaisin, upotettava (skaalattava)',0),(326,113,'Asennustapa','Jm',0),(327,74,'Nimitys','Halogenivalaisin',0),(328,74,'Nimitys','Valaisin, upotettava',0),(329,135,'Nimitys','Peitelevy',0),(330,135,'Peitelevy','0+4',0),(333,135,'Kalustesarja','Impressivo',0),(334,99,'Nimitys','Pistorasia, 1-os., lisätekstillä, pinta',0),(335,105,'Nimitys','Kytkin, 1-napainen, pinta',0),(336,50,'Asennustapa','Japp',0),(337,100,'Nimitys','MMJ 5X6 S',0),(338,136,'Nimitys','ATK-pistorasia, pinta-asennus',0),(339,136,'Kalustesarja','Impressivo',0),(340,137,'Nimitys','Antennipistorasia, pinta',0),(341,137,'Kalustesarja','Impressivo',0),(342,109,'Kalustesarja','Jussi',0),(344,138,'Nimitys','Peitelevy',0),(345,138,'Peitelevy','3+0',0),(346,138,'Kalustesarja','Impressivo',0),(348,86,'Nimitys','Tellu 13',0),(349,86,'Nimitys','Tellu 13 VA',0),(350,139,'Nimitys','DATAJAMAK 2X(2+1)X0.24',0),(351,85,'Nimitys','KLMA 4X0.8',0),(352,140,'Nimitys','Kaluste',0),(353,140,'Kaluste','1-os pr kokopeite',0),(354,140,'Kalustesarja','Jussi',0),(355,141,'Nimitys','Kaluste',0),(357,141,'Kalustesarja','Impressivo',0),(359,141,'Kaluste','1-os pr kokopeite',0),(360,142,'Nimitys','Asennustapa johto',0),(361,142,'Asennustapa','elementti',0),(362,142,'Asennustapa','Elementti',0),(363,143,'Nimitys','Kojerasia',0),(364,143,'Asennustapa','Elementti',0),(365,143,'Asennustapa','elementti',0),(366,144,'Nimitys','Pistorasia, 3-os., suojakosketin, uppo',0),(367,145,'Nimitys','Kaluste',0),(368,145,'Kaluste','europr',0),(369,145,'Kalustesarja','Jussi',0),(370,146,'Nimitys','Peitelevy',0),(371,146,'Nimitys','Peitelevy100',0),(372,146,'Peitelevy','1+3',0),(373,146,'Kalustesarja','Jussi',0),(374,147,'Nimitys','Asennustapa johto',0),(375,147,'Asennustapa','ontelo',0),(376,147,'Asennustapa','Ontelo',0),(377,148,'Nimitys','Profit cat6 + tellu13',0),(378,18,'Asennustapa','',0),(380,149,'Nimitys','FRHF 5X2.5 S',0),(381,150,'Nimitys','Kojerasia',0),(382,150,'Peitelevy','',0),(383,150,'Peitelevy','1',0),(384,150,'Asennustapa','roilo',0),(385,150,'Asennustapa','Roilo',0),(386,151,'Nimitys','Kojerasia',0),(387,151,'Peitelevy','2',0),(388,151,'Asennustapa','roilo',0),(389,151,'Asennustapa','Roilo',0),(390,152,'Nimitys','Kojerasia',0),(391,152,'Peitelevy','1+2',0),(392,152,'Asennustapa','Roilo',0),(393,152,'Asennustapa','roilo',0),(394,62,'Nimitys','MK 6 KEVI ANTITWIN',0),(395,148,'Nimitys','PROFIT CAT 6 UTP 2X4P 20',0),(396,7,'Asennustapa','',0),(397,6,'Asennustapa','',0),(398,66,'Nimitys','Tikas300kk',0),(399,101,'Nimitys','Tikas500kk',0),(400,153,'Nimitys','Tikas500sk',0),(403,154,'Nimitys','MCMK 4X10+10',0),(404,88,'Nimitys','MCMK 4X6+6',0),(405,52,'Poikkipinta','',0),(409,156,'Nimitys','Asennustapa johto',0),(410,156,'Asennustapa','',0),(411,156,'Poikkipinta','10',0),(412,156,'Poikkipinta','16',0),(413,157,'Nimitys','MMJ 5X10 S',0),(414,158,'Nimitys','MMJ 5X16 S',0),(415,155,'Nimitys','Asennustapa johto',0),(416,155,'Asennustapa','',0),(417,155,'Poikkipinta','6',0),(418,65,'Asennustapa','Japp',0),(420,74,'Nimitys','Merkkivalaisin seinässä, itsenäinen',0); /*!40000 ALTER TABLE `PaR` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PaW` -- DROP TABLE IF EXISTS `PaW`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PaW` ( `PaW_id` int(11) NOT NULL AUTO_INCREMENT, `Pa_id` int(11) NOT NULL, `S_id` int(11) NOT NULL, `W_id` int(11) NOT NULL, `count` float NOT NULL, PRIMARY KEY (`PaW_id`) ) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `PaW` -- LOCK TABLES `PaW` WRITE; /*!40000 ALTER TABLE `PaW` DISABLE KEYS */; INSERT INTO `PaW` VALUES (5,1,3,3,1),(6,2,3,3,1),(7,3,1,4,1),(8,7,1,4,1),(9,6,1,4,1),(10,9,3,3,1),(11,10,3,3,1),(13,11,3,3,1),(16,12,2,6,1),(17,12,3,3,1),(18,18,1,4,1),(19,19,1,4,1),(20,20,3,3,1),(21,35,3,3,1),(22,36,3,7,1),(23,36,3,8,1),(25,41,3,3,1),(26,42,1,4,1),(27,43,3,3,1),(33,50,3,2,1),(35,52,1,9,1),(36,54,7,10,1),(37,53,4,10,1),(38,50,3,12,1),(39,60,7,13,1),(40,63,3,14,1),(42,65,3,16,1),(43,65,3,15,1),(44,66,8,17,1),(45,39,3,19,1),(46,39,3,20,3),(47,68,3,7,1),(48,68,3,8,1),(49,70,3,19,1),(50,70,3,20,3),(51,24,1,7,1),(52,24,1,8,1),(53,38,3,19,1),(54,38,3,20,10),(55,71,3,24,1),(56,72,3,24,1),(57,73,3,24,1),(58,74,3,25,1),(59,75,2,20,3),(60,76,2,20,5),(61,77,2,21,3),(62,78,2,21,5),(63,79,2,26,3),(64,80,2,26,5),(65,81,2,27,3),(66,82,2,27,5),(67,83,2,29,5),(68,27,3,24,1),(70,30,3,3,1),(71,26,3,19,1),(72,26,3,20,5),(73,89,4,30,1),(74,89,4,16,1),(76,91,4,30,1),(77,91,4,2,3),(78,92,1,4,1),(79,95,1,4,1),(80,98,3,25,1),(81,99,3,24,1),(83,101,8,17,1),(84,102,3,24,1),(85,103,3,24,1),(86,104,3,7,1),(87,104,3,8,1),(88,105,3,24,1),(89,106,3,3,1),(90,107,3,3,1),(91,108,3,3,1),(92,110,1,4,1),(93,111,3,3,1),(94,112,3,24,1),(95,113,7,11,1),(96,113,7,2,1),(98,34,3,3,1),(99,32,3,4,1),(100,121,3,5,2),(101,121,2,5,2),(102,122,3,5,2),(103,122,2,5,2),(104,136,3,24,1),(105,137,2,6,1),(106,137,3,24,1),(108,142,7,40,1),(109,143,7,41,1),(110,147,7,42,1),(111,150,7,4,1),(112,150,7,47,1),(113,151,7,4,1),(114,151,7,47,1),(115,152,7,47,1),(116,152,7,3,1),(117,148,7,48,1),(118,153,8,17,1),(119,155,1,33,1),(120,156,1,34,1); /*!40000 ALTER TABLE `PaW` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PnL` -- DROP TABLE IF EXISTS `PnL`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PnL` ( `PnL_id` int(11) NOT NULL AUTO_INCREMENT, `P_id` int(11) NOT NULL, `PD_id` int(11) NOT NULL, `PS_id` int(11) NOT NULL, `L_id` int(11) NOT NULL, `count` int(11) NOT NULL, `date` date NOT NULL, PRIMARY KEY (`PnL_id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `PnL` -- LOCK TABLES `PnL` WRITE; /*!40000 ALTER TABLE `PnL` DISABLE KEYS */; INSERT INTO `PnL` VALUES (13,0,0,0,26,0,'0000-00-00'),(14,1017,4,87,30,5,'0000-00-00'),(15,1017,4,87,38,2,'0000-00-00'); /*!40000 ALTER TABLE `PnL` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PnW` -- DROP TABLE IF EXISTS `PnW`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PnW` ( `PnW_id` int(11) NOT NULL AUTO_INCREMENT, `P_id` int(11) NOT NULL, `PD_id` int(11) NOT NULL, `W_id` int(11) NOT NULL, `count` int(11) NOT NULL, `date` date NOT NULL, PRIMARY KEY (`PnW_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `PnW` -- LOCK TABLES `PnW` WRITE; /*!40000 ALTER TABLE `PnW` DISABLE KEYS */; /*!40000 ALTER TABLE `PnW` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `S` -- DROP TABLE IF EXISTS `S`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `S` ( `S_id` int(11) NOT NULL AUTO_INCREMENT, `nimi` varchar(50) NOT NULL, `ktapes` float NOT NULL DEFAULT '17', `ktaopt` float NOT NULL DEFAULT '30', PRIMARY KEY (`S_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `S` -- LOCK TABLES `S` WRITE; /*!40000 ALTER TABLE `S` DISABLE KEYS */; INSERT INTO `S` VALUES (1,'Johdotus',17,30),(2,'Keskukset',17,30),(3,'Kalustus',17,30),(4,'Maakaapelointi',17,30),(5,'Testaukset',17,30),(6,'Mittaukset',17,30),(7,'Putkitus',17,30),(8,'Muut',17,30),(9,'Lattialämmitykset',17,30),(10,'Suunnittelu',17,30),(11,'Tarjouslaskenta',17,30); /*!40000 ALTER TABLE `S` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `U` -- DROP TABLE IF EXISTS `U`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `U` ( `U_id` int(11) NOT NULL AUTO_INCREMENT, `C_id` int(11) NOT NULL, `username` varchar(30) NOT NULL, `password` varchar(50) NOT NULL, `UG` int(11) NOT NULL, PRIMARY KEY (`U_id`), KEY `id` (`U_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `U` -- LOCK TABLES `U` WRITE; /*!40000 ALTER TABLE `U` DISABLE KEYS */; INSERT INTO `U` VALUES (1,1,'ale','8b62b869079b76313f206ecd5e8c9b40',0),(2,2,'juha','b9d36bd101600ce49dafddd73b3dcad0',0),(3,3,'nikke','e4ad34ba63df21e80eaf54c171d69cfa',1); /*!40000 ALTER TABLE `U` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `UD` -- DROP TABLE IF EXISTS `UD`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `UD` ( `UD_id` int(11) NOT NULL AUTO_INCREMENT, `U_id` int(11) NOT NULL, `UDC_id` int(11) NOT NULL, `value` varchar(50) NOT NULL, PRIMARY KEY (`UD_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `UD` -- LOCK TABLES `UD` WRITE; /*!40000 ALTER TABLE `UD` DISABLE KEYS */; /*!40000 ALTER TABLE `UD` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `UDC` -- DROP TABLE IF EXISTS `UDC`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `UDC` ( `UDC_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `type` int(11) NOT NULL, PRIMARY KEY (`UDC_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `UDC` -- LOCK TABLES `UDC` WRITE; /*!40000 ALTER TABLE `UDC` DISABLE KEYS */; INSERT INTO `UDC` VALUES (1,'Ammattihenkilö',1),(2,'SFS 6002',4),(3,'Tulityökortti',4),(4,'EA1',4); /*!40000 ALTER TABLE `UDC` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `UPt` -- DROP TABLE IF EXISTS `UPt`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `UPt` ( `UPt_id` int(11) NOT NULL AUTO_INCREMENT, `P_id` int(11) NOT NULL, `U_id` int(11) NOT NULL, `type` int(11) NOT NULL, PRIMARY KEY (`UPt_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `UPt` -- LOCK TABLES `UPt` WRITE; /*!40000 ALTER TABLE `UPt` DISABLE KEYS */; INSERT INTO `UPt` VALUES (1,1001,1,2),(3,1032,1,1),(4,1025,1,2),(5,1028,1,1),(6,1028,2,1),(7,1028,3,1); /*!40000 ALTER TABLE `UPt` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `W` -- DROP TABLE IF EXISTS `W`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `W` ( `W_id` int(11) NOT NULL AUTO_INCREMENT, `WG_id` int(11) NOT NULL, `nimi` varchar(30) NOT NULL, `info` varchar(100) NOT NULL, `price` float NOT NULL, PRIMARY KEY (`W_id`) ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `W` -- LOCK TABLES `W` WRITE; /*!40000 ALTER TABLE `W` DISABLE KEYS */; INSERT INTO `W` VALUES (1,5,'<2,5mm2 CU TC asennus','',1.47),(2,2,'<2,5mm2 CU Putkeen','',0.63),(3,5,'Rasiakojeen asennus','',2.8),(4,5,'Kojerasian asennus','',1.4),(5,2,'Cat6 liittimen kytkentä','',5.35),(6,2,'Antenni haaran kytkentä','',1.34),(7,2,'Jakorasian asennus','',4),(8,2,'Jakorasian kytkentä','',4.31),(9,9,'<2,5mm2 CU uppo','',0.63),(10,8,'< 2,5mm2 Cu Maahan','',0.28),(11,2,'Putkitus <21mm uppo','',0.67),(12,2,'Putkitus <21 pinta','',1.6),(13,2,' < 16mm2 Cu Maahan','',0.39),(14,2,'Valaisinripustuskiskon asennus','',4.2),(15,7,'Putkitus <28 pinta','',1.91),(16,2,'<6mm2 CU Putkeen','',0.79),(17,11,'Tikashylly <800mm','',4.74),(18,2,'Johtokanavan asennus <200mm','',5.78),(19,2,'Pintakoje <3kg','',3.16),(20,2,'Kytkentä Johto < 1,5mm2','',1.05),(21,2,'Kytkentä Johto < 2,5mm2','',1.17),(22,2,'Kytkentä Johto < 6mm2','',1.37),(23,2,'Kytkentä johto < 16mm2','',2),(24,2,'Pintakoje','rasiakojetta vastaava',4.87),(25,2,'Valaisin','',5.05),(26,2,'Kytkentä Johto Arm. <1,5mm2','',1.85),(27,2,'Kytkentä Johto Arm. <2,5mm2','',2.1),(28,2,'Kytkentä Johto Arm. <6mm2','',2.5),(29,2,'Kytkentä Johto Arm. <16mm2','',3.16),(30,2,'Putkitus <70mm','',1.82),(31,2,'Kytkentä johto','',5.81),(32,2,'Keskus kiinnitys','m2',47.3),(33,9,'< 6mm2 CU Uppo','',0.79),(34,9,'< 16mm2 Cu Uppo','',0.97),(35,9,'< 120mm2 CU Uppo','',1.66),(36,4,'< 6mm2 CU Oikaistuna','',0.652),(37,4,'<2,5mm2 CU Oikaistuna','',0.455),(38,6,'Kytkentä Johto Arm. <120mm2','',6.84),(39,2,'Kytkentä Johto <185mm2','',5.8),(40,2,'< 2,5 CU Elementtiputkeen','',1.2),(41,2,'Kojerasia elementissä','',1.6),(42,2,'< 2,5mm2 CU Onteloon','',3.5),(43,8,'< 185mm2 Cu Maahan','',1),(44,2,'Autonlämmitystolppa','',15),(45,2,'Pihavalopylväs ~4m','',15),(46,2,'Lattialämmityskaapeli','',0.897),(47,2,'Piikkaus kiviseinään','',1.6),(48,2,'Putkijohto','',0.69); /*!40000 ALTER TABLE `W` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `WD` -- DROP TABLE IF EXISTS `WD`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `WD` ( `WD_id` int(11) NOT NULL AUTO_INCREMENT, `PD_id` int(11) NOT NULL, `PS_id` int(11) NOT NULL, `count` float NOT NULL, `price` float NOT NULL, PRIMARY KEY (`WD_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `WD` -- LOCK TABLES `WD` WRITE; /*!40000 ALTER TABLE `WD` DISABLE KEYS */; /*!40000 ALTER TABLE `WD` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `WG` -- DROP TABLE IF EXISTS `WG`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `WG` ( `WG_id` int(11) NOT NULL AUTO_INCREMENT, `parent` int(11) NOT NULL, `nimi` varchar(30) NOT NULL, PRIMARY KEY (`WG_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `WG` -- LOCK TABLES `WG` WRITE; /*!40000 ALTER TABLE `WG` DISABLE KEYS */; INSERT INTO `WG` VALUES (1,1,'Sähkötyöt'),(2,0,'Sähkötyöt'),(3,0,'LVI-työt'),(4,2,'Kaapelit'),(5,2,'Kojeet'),(6,2,'Keskusten kytkennät'),(7,4,'Pinta-asennus'),(8,4,'Maa-asennus'),(9,4,'Uppo asennus'),(10,0,'Kaapeli hyllylle asennus'),(11,2,'Johtotiet'); /*!40000 ALTER TABLE `WG` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `play` -- DROP TABLE IF EXISTS `play`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `play` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user1` int(11) NOT NULL, `user2` int(11) NOT NULL, `u1score` int(11) NOT NULL, `u2score` int(11) NOT NULL, `winner` int(11) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `play` -- LOCK TABLES `play` WRITE; /*!40000 ALTER TABLE `play` DISABLE KEYS */; INSERT INTO `play` VALUES (1,1,2,4,233,2,'2013-10-29 14:28:33'),(2,1,2,2,1900,2,'2013-10-29 14:28:48'),(3,3,1,100,700,2,'2013-10-29 14:29:06'),(7,1,2,0,0,0,'2013-10-28 13:59:13'),(8,1,2,0,0,0,'2013-10-28 14:07:12'),(9,4,5,100,200,1,'2013-10-29 14:18:56'),(10,6,7,150,120,2,'2013-10-29 14:18:56'),(11,8,9,200,250,2,'2013-10-29 14:18:56'),(12,10,11,600,800,2,'2013-10-29 14:18:56'),(13,12,13,1000,2000,2,'2013-10-29 14:18:56'),(14,97,3,0,0,0,'2013-11-06 16:57:14'),(15,98,3,0,0,0,'2013-11-06 17:06:34'),(16,115,3,0,0,0,'2013-11-06 17:44:53'),(17,122,3,0,0,0,'2013-11-06 18:20:14'),(18,131,3,0,0,0,'2013-11-06 18:37:35'),(19,134,3,0,0,0,'2013-11-07 11:42:02'),(20,135,3,0,0,0,'2013-11-07 11:47:11'),(21,160,3,0,0,0,'2013-11-07 14:29:48'),(22,171,3,0,0,0,'2013-11-07 16:49:50'),(23,185,3,0,0,0,'2013-11-08 02:17:33'),(24,188,3,0,0,0,'2013-11-08 02:26:49'),(25,189,3,0,0,0,'2013-11-08 02:28:59'),(26,197,3,0,0,0,'2013-11-08 03:11:21'),(27,199,3,0,0,0,'2013-11-08 03:14:17'),(28,233,3,0,0,0,'2013-11-09 21:26:08'),(29,236,3,0,0,0,'2013-11-09 21:47:48'),(30,237,3,0,0,0,'2013-11-09 21:58:16'),(31,238,3,0,0,0,'2013-11-09 22:08:28'),(32,239,3,0,0,0,'2013-11-09 22:25:23'),(33,241,3,0,0,0,'2013-11-09 23:27:17'),(34,244,3,0,0,0,'2013-11-16 18:21:35'),(35,247,3,0,0,0,'2013-11-16 19:29:33'),(36,250,3,0,0,0,'2013-11-16 19:34:23'),(37,258,3,0,0,0,'2013-11-23 18:17:04'),(38,261,3,0,0,0,'2013-11-23 18:21:31'),(39,265,3,0,0,0,'2013-11-23 18:34:33'),(40,268,3,0,0,0,'2013-11-25 19:14:13'),(41,289,3,0,0,0,'2013-11-26 22:58:32'),(42,296,3,0,0,0,'2013-12-07 21:50:03'),(43,304,3,0,0,0,'2013-12-27 13:06:48'),(44,305,3,0,0,0,'2013-12-27 13:24:34'),(45,307,3,0,0,0,'2013-12-27 13:27:52'),(46,309,3,0,0,0,'2013-12-27 13:38:43'),(47,310,3,0,0,0,'2013-12-27 13:41:26'),(48,335,3,0,0,0,'2013-12-28 23:46:08'),(49,336,3,0,0,0,'2013-12-28 23:52:20'),(50,357,3,0,0,0,'2014-01-04 23:21:02'),(51,360,3,0,0,0,'2014-01-06 14:54:26'),(52,362,3,0,0,0,'2014-01-06 15:24:53'),(53,364,3,0,0,0,'2014-01-06 15:42:02'),(54,369,3,0,0,0,'2014-01-18 13:09:36'),(55,370,3,0,0,0,'2014-01-18 13:25:44'),(56,371,3,0,0,0,'2014-01-18 13:27:37'),(57,372,3,0,0,0,'2014-01-18 13:28:58'),(58,386,3,0,0,0,'2014-01-18 14:40:24'),(59,389,3,0,0,0,'2014-01-18 14:44:08'),(60,396,3,0,0,0,'2014-01-26 09:45:03'),(61,1,3,0,0,0,'2014-01-26 17:48:10'); /*!40000 ALTER TABLE `play` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `shop` -- DROP TABLE IF EXISTS `shop`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `shop` ( `type` int(11) NOT NULL, `gameType` int(11) NOT NULL, `level` int(11) NOT NULL, `price` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `shop` -- LOCK TABLES `shop` WRITE; /*!40000 ALTER TABLE `shop` DISABLE KEYS */; INSERT INTO `shop` VALUES (0,0,1,4500),(1,0,1,2500),(1,0,2,3500),(1,0,3,4500),(1,0,4,5500),(1,0,5,6500),(2,0,1,5500),(0,1,1,9500),(0,1,2,15000),(1,1,1,8500),(1,1,2,9500),(1,1,3,1100),(1,1,4,1200),(1,1,5,1300),(2,1,1,10000),(0,2,1,15000),(0,2,2,20000),(1,2,1,12000),(1,2,2,14000),(1,2,3,16000),(1,2,4,18000),(1,2,5,20000),(2,2,1,15000),(0,1,0,25000),(0,2,0,45000),(0,0,2,9500); /*!40000 ALTER TABLE `shop` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stun` -- DROP TABLE IF EXISTS `stun`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `stun` ( `id` int(11) NOT NULL AUTO_INCREMENT, `host` varchar(20) NOT NULL, `port` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `stun` -- LOCK TABLES `stun` WRITE; /*!40000 ALTER TABLE `stun` DISABLE KEYS */; INSERT INTO `stun` VALUES (1,'ip1.hypeshell.com',1234); /*!40000 ALTER TABLE `stun` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(20) NOT NULL, `password` varchar(32) NOT NULL, `cash` int(11) NOT NULL, `country` int(11) NOT NULL, `g1` tinyint(1) NOT NULL, `g2` tinyint(1) NOT NULL, `g0a0` int(11) NOT NULL, `g0a1` int(11) NOT NULL, `g0a2` int(11) NOT NULL, `g1a0` int(11) NOT NULL, `g1a1` int(11) NOT NULL, `g1a2` int(11) NOT NULL, `g2a0` int(11) NOT NULL, `g2a1` int(11) NOT NULL, `g2a2` int(11) NOT NULL, `ip` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=400 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user` -- LOCK TABLES `user` WRITE; /*!40000 ALTER TABLE `user` DISABLE KEYS */; INSERT INTO `user` VALUES (1,'ale','098f6bcd4621d373cade4e832627b4f6',9400,10,1,1,2,5,1,2,5,1,1,3,1,629691675),(2,'BotNiga','098f6bcd4621d373cade4e832627b4f6',3201900,0,1,1,2,5,1,2,5,1,2,5,1,1465879228),(3,'BotNiga2','098f6bcd4621d373cade4e832627b4f6',0,0,0,0,0,0,0,0,0,0,0,0,0,629709039),(4,'Guest','0661a2ddfa8c9f00f03dbc3526a3b1c8',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(5,'Guest','b68a2efa2bb9a0f2a9a2a19d389bf6a5',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(6,'Guest','da0e085cc57db4d1c58bf0527482f0d4',0,0,0,0,0,0,0,0,0,0,0,0,0,2147483647),(7,'t1','',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(8,'test2','',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(9,'test3','',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(10,'test4','',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(11,'test5','',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(12,'test6','',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(13,'test7','',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(14,'Guest','b20354bd41b27222faf36a3310c9d920',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(15,'Guest','b20354bd41b27222faf36a3310c9d920',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(16,'Guest','770f9131b7a325ee344d5750d7e8fd00',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(17,'Guest','770f9131b7a325ee344d5750d7e8fd00',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(18,'Guest','7c5bb3f6840bde1aef67aa91130d9383',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(19,'Guest','7c5bb3f6840bde1aef67aa91130d9383',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(20,'Guest','b8ee507b1aa58178a571badec67e9a67',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(21,'Guest','bf173ff445eb8809cac977e98a24b8dc',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(22,'Guest','6b671e702ef41e0254a14c9c8edaf091',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(23,'Guest','b6907be7a655d14ea554f524015e080c',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(24,'Guest','d319ab1780489a0f1b4ec8dbfa1a22c1',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(25,'Guest','f44b116a0a41cf0e95aa210fd2898452',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(26,'Guest','aa8608a6ab11b22e26895587fc0baa06',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(27,'Guest','7dbd0b7bd921f80ae790d044ca600677',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(28,'Guest','dc84e0cd56191a06ab603024fd407749',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(29,'Guest','00b8ed7b2646ddf8210a4932edc1ea0a',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(30,'Guest','201a3550715c0ccf048283a156f0c598',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(31,'Guest','ec86ff1874cb5d8d8570c08b5467d0ed',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(32,'Guest','c8d6bad9644d2cd09c771b32ed12ddc3',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(33,'Guest','c989d96de9d9cc9cb76a882fcd80c6ef',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(34,'Guest','275926ba7bcae2f7965ec7a2c9536d13',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(35,'Guest','d93c0382f03f73dea322b0c5abd4849b',0,0,0,0,0,0,0,0,0,0,0,0,0,1465863243),(36,'Guest','f0112b07b6549ad83be058cdc7aae003',0,0,0,0,0,0,0,0,0,0,0,0,0,1465863243),(37,'Guest','6af1a5a632faf3a3e4c76ae42ee6c930',0,0,0,0,0,0,0,0,0,0,0,0,0,629724525),(38,'Ale2','098f6bcd4621d373cade4e832627b4f6',0,10,0,0,0,0,0,0,0,0,0,0,0,629724525),(39,'Guest','36a0c2037c47e2644a614f7cc8d64732',0,0,0,0,0,0,0,0,0,0,0,0,0,1465863243),(43,'Ale3','test',0,10,0,0,0,0,0,0,0,0,0,0,0,1465863243),(44,'Guest','7b96ed97264e0cb9dec6970d3e68bc2b',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(45,'Guest','3fb1aaf2f101eebf069e510e08c36cfe',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(46,'Guest','12393eb2b5a259aa04f0c892fdf313d5',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(47,'Guest','2aba49f99aa74fd2d4b6e3ebac240af9',0,0,0,0,0,0,0,0,0,0,0,0,0,0),(48,'Guest','98912e7cef0fc96310c7f674f4d21bc6',0,10,0,0,0,0,0,0,0,0,0,0,0,1465863243),(49,'Guest','cba4d80d01d531ba5fc43530c15f37f9',0,10,0,0,0,0,0,0,0,0,0,0,0,629724525),(50,'Guest','e76d40488bebce30486b279cb476ae4f',0,10,0,0,0,0,0,0,0,0,0,0,0,629724525),(51,'Guest','d62f5c6cca46eb28f28d8071a18333ab',0,10,0,0,0,0,0,0,0,0,0,0,0,629724525),(52,'Guest','ccc114a0a45532f6d6b839ab056aa789',0,10,0,0,0,0,0,0,0,0,0,0,0,629724525),(53,'Guest','11c476f9678207c610d3655d15a0682f',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(54,'Guest','0cf4a9c8915210dd2de035b851586c66',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(55,'Guest','ea4e6a6d74483dfb99b1b50f011be1c4',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(56,'Guest','161dc20317985bbe251e35448eee6bfb',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(57,'Guest','562ec77b09f86863558744aca9b5663b',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(58,'Guest','a248ba69ef4b9cb3c028c69ccad051a0',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(59,'Guest','e2b984ed28942c7b49818daaca4bf76e',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(60,'Guest','fa495187c8ae6ebfdab44ebf6ee862c0',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(61,'Guest','18fce6ce27137ceeafb9604af0f4337f',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(62,'Guest','ed5c69867ceaa4bc2aabee70d39c6b8c',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(63,'Guest','8ee79d77859c31163ea14e34e0267d5e',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(64,'Guest','266ff9e02baed9dded78c79b509d4594',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(65,'Kalle','098f6bcd4621d373cade4e832627b4f6',9880000,10,1,1,2,2,1,2,0,0,0,0,0,629709039),(66,'Guest','6076b4cf092b0198509458b4103aeb51',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(67,'Guest','e389e4ace359add43808770ba4b03035',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(68,'Guest','40ce36c23071aae96ec16b2852d65acd',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(69,'Guest','a9fb855589f2a122a23591dcd9effa78',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(70,'Guest','8a301d066e98b012f09d54ff09c100ee',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(71,'Guest','414693da80c6d9e76f44cf721455d3bb',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(72,'Guest','dd5b0af46f511825637d90596162d8f8',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(73,'Guest','dd2b73f0d50ab606d998ccdc380fcd86',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(74,'Guest','8b96b70391b0ccacec941fae33d75bed',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(75,'Guest','456abf6aa8be1965bf1fb89fd5a35442',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(76,'Guest','804bbba1701b5b3ce1a99c2d7ff438ef',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(77,'Guest','340da0b59abb5d6ff33747d3d48c3198',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(78,'Guest','6eb9b7408576779783cec8266aefae9b',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(79,'Guest','14fff240f445567f6422360fbe8cb971',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(80,'Guest','c74981673466bc03b30a37e3779a5d7c',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(81,'Guest','106df3e6e6d7391645482f002063ac9c',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(82,'Guest','7b00e24285d889a755f88000dd61104d',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(83,'Guest','af9553553bac30e95cdaabd22c83b1e1',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(84,'Guest','ad01294d7a34e1fb0f0a69a154b83a98',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(85,'Guest','98963bd1908a4f22a01aa0563b5e2993',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(86,'Guest','2854b0094e2b214be8d4849c1936c88a',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(87,'Guest','5e72904e3432085ecb76d82981bc0210',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(88,'Guest','2a685aa5abfcd7d60f00a2d71511f13c',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(89,'Guest','f1b083f264e8bba9962c25e2e89a2a70',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(90,'Guest','f9cfd6c767e15fc28670e6e519a90afb',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(91,'Guest','99ddb21a691d52f5ffb37db65dfa06c8',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(92,'Guest','57d73e89675a2f276f6238df8cd5064d',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(93,'Guest','3f552eae14aae4dc3f6a892d3c7532f6',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(94,'Guest','191b07a8feeba5d734a76aa574c29253',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(95,'Guest','40c501205d3b68af10a17fa8193487cd',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(96,'Guest','d2552e7cb9183ed0d20dcc866873f9ea',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(97,'Guest','f57b67c381d4ddbe623f22cbd343afd0',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(98,'Guest','79ea3a1fa44eb41bc431ebd9bc4c1639',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(99,'Guest','47468f6399f817d693baae5d4a8bb6a6',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(100,'Guest','1c1ecade76c092e5b6fffd79f8471d13',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(101,'Guest','9a787a4d7088351205b620f6dd65dbae',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(102,'Guest','2db10c2a49cd27d9bc6d3672b17290c8',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(103,'Guest','801bfbcb5db24da3db58097576b30bf5',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(104,'Guest','3e606e78cedce486d4bb39f9cbd6e234',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(105,'Guest','c8bb2a533f3a1895428233c7beecb839',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(106,'Guest','c8b95e8be29c3de1f14fb383ea1e9476',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(107,'Guest','d58497c77c1f3187c23e42fb4bd3391b',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(108,'Guest','7326425ebccdc55194502afce64f80f5',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(109,'Guest','02c3c9651a00a99ba67ebec17be44bb0',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(110,'Guest','c06a1961c765e9a0c86cd0c3c3f63b79',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(111,'Guest','f6b58ddfdaed659779193815ea92f172',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(112,'Guest','6e3d4fcce2f8dc66adb6b0af217bf920',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(113,'Guest','b969e2ada56f09453f9f723842c79d8d',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(114,'Guest','0517874fcc88a47ae1ce1cbbf1c8da94',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(115,'Guest','cdc632afa28819a2c156f423fc30444d',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(116,'Guest','b18e8d97354a2aafa6684ebb08881bde',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(117,'Guest','8678bf9da54dfa02d604c845c5a00cc6',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(118,'Guest','c5c341930708228921914247015a6759',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(119,'Guest','682174988d0593f6c8a1aa6963f37e14',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(120,'Guest','861ea860b72132a3de68e1b6944b7610',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(121,'Guest','5c5e518589b981c4528bfdde671f4880',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(122,'Guest','cbadb4e8bd73ec27042e07d53a57be92',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(123,'Guest','e2e37f7abdd82c33117edf9bcafdccdf',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(124,'Guest','9e10e9396ca633582f935ef89eabb984',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(125,'Guest','b789894c230e72ce239e4a013d8b14f1',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(126,'Guest','685bdde8c9029390b760d7193167c87c',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(127,'Guest','4c7a41ce215136b834f7cb4dd51e9c2c',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(128,'Guest','d555967962742c593df95d30ef3104b1',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(129,'Guest','26f2726a63fa1cf0a48402e9fffd2310',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(130,'Guest','daa8500ce01ce74d77d55fb06791e421',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(131,'Guest','b69a0332a73d72626a64d83d8a3e2922',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(132,'Guest','53efafc04997dea967e40d2ea99e92b8',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(133,'Guest','7ac88a3b851e3cb8b38104a44fe1a044',0,10,0,0,0,0,0,0,0,0,0,0,0,629709039),(134,'Guest','e17752cb0c252304af095ca5fd5fdc60',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(135,'Guest','2259f225c7bf2b3846d066e18131f89f',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(136,'Guest','0ec3ab5ec5d25790adc8fa9d2713041a',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(137,'Guest','304d9c201e24be9fe874874dec7d92d5',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(138,'Guest','5b281aa3535346a5b0f0bf6b1fe288fb',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(139,'Guest','4ee6d736bb8160f6e6ac701b2dd495e7',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(140,'Guest','aaf4a782872438d707a9b0ad698ec930',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(141,'Guest','1f439100cfa76ff3f3c0ebd4211b6876',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(142,'Guest','4131bc94db95745b64965aab0ef09b0f',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(143,'Guest','00e3ca1d9b5cf41a216ad60a48dd9266',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(144,'Guest','c6af47fe6305b3f86f4e4365ae2e9a42',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(145,'Guest','c50783152642d926eae38b7518e36939',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(146,'Guest','ba2ea85b2e99f3c19d61a4acb64a971a',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(147,'Guest','a27e66057a15660c1407763ad22af58b',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(148,'Guest','c80302da729efbbb6f3c23f75be2162b',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(149,'Guest','36b2a705d9d4491149321e8f8bb9355f',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(150,'Guest','af7b093fab29774844d5651b9e68bd7f',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(151,'Guest','78dc1009c015c46b2d029e4ea686567b',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(152,'Guest','2699d9dc2c9480d0114926b40b83df33',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(153,'Guest','290e2cee3fe7fa3037ad998e73634fcf',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(154,'Guest','0678b53efb6c2b086ea9d1829e4b9b59',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(155,'Guest','5840c15fa94bcc6c37a07d0b7980fe57',0,10,0,0,0,0,0,0,0,0,0,0,0,629695054),(156,'Guest','7fbeb13b21360e65e7fd8b4f23a99442',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(157,'Guest','ba6ad25d9de165ffc0cb3bf5075e51b5',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(158,'Guest','e5be7ead80566e7d80d454ef61154b93',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(159,'Guest','bfbbb3cbdfaa75d6b3c98dd2e42614e7',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(160,'Guest','0b4474256bcf89818c51f1202f45b35b',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(161,'Guest','2c9c28160bb9ed0a1c92b2671fe4bfd7',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(162,'Guest','42098a807b96ae6fce67969656811d8e',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(163,'Guest','06bcf5456ade9fd805b8ac8c6851d914',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(164,'Guest','48038ccbd2a192be9c3c6a1e69dd3419',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(165,'Guest','50ff3048872a7676b9ecce6d8126ece9',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(166,'Guest','a4f0253823894a892c0c79d3edcf11fc',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(167,'Guest','68475300b2f2256ca352c8dc834b147d',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(168,'Guest','2376f2dddfb0f57cbf35a183045e936e',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(169,'Guest','4d35a3a7beb43c2d47fc5561bc15b9ea',0,10,0,0,0,0,0,0,0,0,0,0,0,629707250),(170,'Guest','08446d8165d83129693b940e212e1aeb',0,10,0,0,0,0,0,0,0,0,0,0,0,629718955),(171,'Guest','dbeea4dcb9bbe1fcd7aba14de1df9341',0,10,0,0,0,0,0,0,0,0,0,0,0,629718955),(172,'Guest','74079d3e2c45d25e40ebbcadcb673f8c',0,10,0,0,0,0,0,0,0,0,0,0,0,629718955),(173,'Guest','a75a95035ae98b3a3962ddda4d4070f6',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(174,'Guest','6d8f77f2db86b3dbac52b28bc3175504',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(175,'Guest','5909a6e797ce59bec81790939b75b083',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(176,'Guest','87f569955c8efe0b691cb635e37506f4',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(177,'Guest','13b32c9dc4c96a8c6fc523d4cbdeb260',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(178,'Guest','79fc93f1bf32a1714c1881a7426a9c87',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(179,'Guest','91c534208688a9197c489676cc73b5c7',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(180,'Guest','63351ea4261a7a582c39fae388766dc6',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(181,'Guest','d96837bbccc5695f35470e77ead33330',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(182,'Guest','753e35ecd16495abe45edecfaf738c2d',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(183,'Guest','b4cd3ab540deb38a36e82e7daeee3d92',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(184,'Guest','359f4787d886de8d6f621fa1ccc3e62d',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(185,'Guest','f47a73f2c89058c64a3104636cd210d4',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(186,'Guest','9a60a56f66a20ddd3560adb4cf433ebf',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(187,'Guest','7f6e30bd0a0cf1e4332ce44ddf99e4d8',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(188,'Guest','bc972f4cf79b2d87f1d1c3124de11760',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(189,'Guest','9e549e70e9535e0b4fe100f4301137c8',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(190,'Guest','e66dfa0d946b45c9dda4f4aebe458d01',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(191,'Guest','90818665cab273d4c997eaf9b8b012d5',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(192,'Guest','feb047a78881f5b337d855f8e29932c2',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(193,'Guest','5549cf405e534912715ac68b634ac103',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(194,'Guest','0da256d11139202225eadf21520440ae',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(195,'Guest','5fb7efe307a1ea3259944803cae09ea2',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(196,'Guest','58e95e53f581bfe93220a6c47d7058f1',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(197,'Guest','3d83854dbffd9ca9f78d3524b30c6647',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(198,'Guest','3391cd2fce01c59dae8e702515f54fc5',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(199,'Guest','c95d0259e8a7e1ad14bccc188452a765',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(200,'Guest','44f758a7f5673bed9052c253a2e5ed2f',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(201,'Guest','5ce0e04d1efa067cdef45094b2ea6a45',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(202,'Guest','e5ec5fb86ce6a3d9b690009ae77fa5b4',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(203,'Guest','420560559ca69345d8e8f08d258df851',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(204,'Guest','965e39ab507c5bba5b3def3c28a00836',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(205,'Guest','6457f36ae7dd52f1a547a797773aa96b',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(206,'Guest','1db7d3102eda7f5b8a4efdba7935f02e',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(207,'Guest','0def6e6f8a9f51441229bf3c5123be52',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(208,'Guest','f2de6924bec66277f31636a47cce3934',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(209,'Guest','96a59abe06f9ea0dd36f035ba49c9190',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(210,'Guest','9ea646ae601173855af2213fb60af44d',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(211,'Guest','c3e9135d220c0149f44216077491efcb',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(212,'Guest','0c3376878acdc03692bc588b0991cd33',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(213,'Guest','1fcb00d6758eb5f3f8a0240aeae39b6e',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(214,'Guest','ccf6f515dd7a14114f6cc9c211811d2a',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(215,'Guest','e2c7bee95a16954ec9949ad58aa07868',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(216,'Guest','775548b025ad9ca84a71e8c422b05bd3',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(217,'Guest','e50d59f1c1872ef599838d5dd13a895a',0,10,0,0,0,0,0,0,0,0,0,0,0,629712695),(218,'Guest','b5cf8c338da240e4bf63658554ab101f',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(219,'Guest','0df5800b43b5f05295e4a00b19a63422',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(220,'Guest','86631d749a54a58c524d1640cae16ecb',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(221,'Guest','78788d197ccaafe5b58b0b69644fbc10',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(222,'Guest','86ef64be5f491d0c0f690826e34a63b6',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(223,'Guest','c491efbc9e95386dd68036a6d0bdda1e',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(224,'Guest','d41b00a7b577a5e36c5884c8d28492e2',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(225,'Guest','127d63e12a17d1017a23199bf26c7e1b',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(226,'Guest','38baebb018d83e4172adbba8d5123f76',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(227,'Guest','d9846b9609445202fa5ac418ee510d63',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(228,'Guest','22511d6aca74a31319652c462539cb74',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(229,'Guest','a2b2c5d8e504b297216ff44447715add',0,10,0,0,0,0,0,0,0,0,0,0,0,635117751),(230,'Guest','4097437eb5982e502993201f52712d38',0,10,0,0,0,0,0,0,0,0,0,0,0,635117751),(231,'Guest','e111ba7f2af442bb2fc4f6700ffcfee2',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(232,'Guest','2b844325239f1b07eaaaaab5f5cc5256',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(233,'Guest','74a6bf97b73727234a6dc3539b81fee1',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(234,'Guest','c106c8b382e8e6800f6d7f4fba763518',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(235,'Guest','c9e79da59f4dda576bf5a1459a955647',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(236,'Guest','f0dcf7f3cc06b02c45c8f31ce660c616',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(237,'Guest','dbc85603b9385d5f27d868d9a0216a10',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(238,'Guest','65b59861e3ba11b73d0591925da37892',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(239,'Guest','6c28db8a2a6c8d983b364fa5792bafa9',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(240,'Guest','02cc7d45800f107e45560136b812a185',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(241,'Guest','5ed7a5307785f2d790120cbf320c0b49',0,10,0,0,0,0,0,0,0,0,0,0,0,1465714001),(242,'Guest','bdfcd279c584cbede555fa9b5c56a151',0,10,0,0,0,0,0,0,0,0,0,0,0,629702736),(243,'Guest','ef567b560fa1096842cd1b1cfa6fbb79',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(244,'Guest','d938be85e172c0ce3030674236e05f41',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(245,'Guest','9734c76785586d306213ad3d05c8cccd',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(246,'Guest','b508f53c8f37cc6b23705b6db28452f8',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(247,'klaus','4f3adcfc45e6c3f21bc6263c32d7cc8b',0,10,0,0,0,0,0,0,0,0,0,0,0,3251702296),(248,'Guest','b96dbf0fe80c451c79ccf9290b804c0f',0,10,0,0,0,0,0,0,0,0,0,0,0,1465718904),(249,'Guest','1d86f64b678b8320a7bd1a67cdb19d39',0,10,0,0,0,0,0,0,0,0,0,0,0,1465718904),(250,'Guest','a3c0af32cfc3d8698b8c6885dc0a3c0f',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(251,'Guest','ae0dbad91b411f762536adac72cbff8d',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(252,'Guest','f04b618f84cc6d8976c4c35d3ec6c755',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(253,'Guest','b53840e759ec2d9589fee19d156754f5',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(254,'Guest','66be93b97e5c9ce9dec0b6148846014b',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(255,'Guest','66778a09d00a0880bf9d2c5c5d43b332',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(256,'Guest','6b4af8431f5514c1de53618053a148f5',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(257,'Guest','494124f3b030dfaf682c8b3afa1f93c2',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(258,'Guest','55b668a2cd8da2724b8506d29d225f30',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(259,'Guest','32bdd45a3d649e80700e32b439957079',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(260,'Guest','660e88f55ab29b6cf644176937e497c1',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(261,'Guest','c0b190130bec0b4a5f5f42c43d351cfc',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(262,'Guest','fd0c7c02e4acf39098e47dd780c97194',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(263,'Guest','afb3c52261c145603ddf1d7a017537ee',0,10,0,0,0,0,0,0,0,0,0,0,0,1537027643),(264,'Guest','3e1828971d9604b850e911769f6b46b4',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(265,'Guest','337b6431e7efea5e85d58df1eb99b30a',0,10,0,0,0,0,0,0,0,0,0,0,0,635150080),(266,'Guest','355b506551da0c44fa0522ed9d6d88e2',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(267,'Guest','74040f627a0f94114a03d877ee58270b',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(268,'Guest','a1b2b2913315b5d7947d0f01806acdb8',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(269,'Guest','b9889406e216102109dce4b808c221cc',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(270,'Guest','63b6ebbcf8aa5786bc74fa9c0ea65319',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(271,'Guest','07d06abb742b6bcb15e8152dc808a6a2',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(272,'Guest','dc566aafb9cf7152c0bd0ca0ca03fc24',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(273,'Guest','ae11f1f63de2649b05a8af6182fa65f8',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(274,'Guest','c1f74aa912d2bcb2939f6e4de7603f4e',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(275,'Guest','e08dbc1134c506659a3a7194315efa59',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(276,'Guest','032d3590463cb6dca42b4361fda6f75f',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(277,'Guest','be3fdcb2e4fee0578dd2ea5a9443801d',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(278,'Guest','3de6d6b0a9eb8519f57999c5bab1beb5',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(279,'Guest','313bd1359046f5aaeb7a6cb92b05c0a0',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(280,'Guest','3a5448867c2ace7322614d27161b3077',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(281,'Guest','0df8b4ef4866091852184482626d41dd',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(282,'Guest','08a0e46dff9e4a9446eadaf6feeed3c5',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(283,'Guest','a975fa668a2d8f219345187fb526b8c2',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(284,'Guest','aa59773e9a1b6194021151e5ef17a95a',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(285,'Guest','0b45095fea027c997d6cdf064ead3a70',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(286,'Guest','81e16caedeca1e89f723fa9c32c65ff6',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(287,'Guest','e8117d476ddbe5b3678b713aa9befbcb',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(288,'Guest','f53348535e16b2cc18ad484c3aa73f8d',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(289,'Guest','6aca6fa747bc109fe50020a976fe05c3',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(290,'Guest','d4426c930f2c4ab696fff9e245ba268d',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(291,'Guest','5cc082a903bece441e14cd56b6fb68cf',0,10,0,0,0,0,0,0,0,0,0,0,0,635153532),(292,'Guest','7ba057735d4f805c044ac2524b67eb4e',0,10,0,0,0,0,0,0,0,0,0,0,0,629709960),(293,'Guest','fb2bb84494de30773c34357eb81313f0',0,10,0,0,0,0,0,0,0,0,0,0,0,629709960),(294,'Guest','197c2d0651167bbd45bf3b5397d5a854',0,10,0,0,0,0,0,0,0,0,0,0,0,629709960),(295,'Guest','da5ba71e7d60371da40dae85a4853354',0,10,0,0,0,0,0,0,0,0,0,0,0,629709960),(296,'Guest','d21415bdc23753168c00e5f61b8c5c97',0,10,0,0,0,0,0,0,0,0,0,0,0,629709960),(297,'Guest','e71daca9aa6b0f23b667b1cbac7557fc',0,10,0,0,0,0,0,0,0,0,0,0,0,629709960),(298,'Guest','bc3ce0ec37821e1fd2347540b02243fe',0,10,0,0,0,0,0,0,0,0,0,0,0,635116739),(299,'Guest','c76232ec6edd6ca1e9c90680ea1b3006',0,10,0,0,0,0,0,0,0,0,0,0,0,635116739),(300,'Guest','2ba98548a89aec2d725c486278393adf',0,10,0,0,0,0,0,0,0,0,0,0,0,635116739),(301,'Guest','180762b1f80a1752d43bc21e25cbe457',0,10,0,0,0,0,0,0,0,0,0,0,0,635116739),(302,'Guest','6d21cf5b9abac5517dfad3ba8c0e6ee8',0,10,0,0,0,0,0,0,0,0,0,0,0,629690264),(303,'Guest','d1d5e5e5a7d786c460084d2b449038b7',0,10,0,0,0,0,0,0,0,0,0,0,0,629673376),(304,'Guest','3776bf35075c6356c97ae649b9b003a0',0,10,0,0,0,0,0,0,0,0,0,0,0,629673376),(305,'Guest','d0bf56bc00cc12a9a12560a567215e41',0,10,0,0,0,0,0,0,0,0,0,0,0,629673376),(306,'Guest','ed1cdd30bbe8ff6340b7ae0c36ad759e',0,10,0,0,0,0,0,0,0,0,0,0,0,629673376),(307,'Guest','24512b0611b28c774dabd6971fbe98a4',0,10,0,0,0,0,0,0,0,0,0,0,0,629673376),(308,'Guest','d297dfb523db7b797470e3e324b52e2b',0,10,0,0,0,0,0,0,0,0,0,0,0,629673376),(309,'Guest','4c8170a6c6ceafd47a812f5138db609b',0,10,0,0,0,0,0,0,0,0,0,0,0,629673376),(310,'Guest','de83bafcaa6c12b2ed83fc2e6eabbe7a',0,10,0,0,0,0,0,0,0,0,0,0,0,629673376),(311,'Guest','6acdc168cc54d43a973e4941dc085ea9',0,10,0,0,0,0,0,0,0,0,0,0,0,629673376),(312,'Guest','3edd9e3bfadc54590c4507f1ec019716',0,10,0,0,0,0,0,0,0,0,0,0,0,635161700),(313,'Guest','212087ee4c3388b062e94f9a45d15208',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(314,'Guest','0774efe14578d6dd32579c888becc0a5',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(315,'Guest','f9e62379f7aef03bf90003465347f1fd',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(316,'Guest','766e4eff7e3e88370b296014307bf1ae',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(317,'Guest','d13b9e0e61aadbec55610c1f9e22ca70',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(318,'Guest','7eea9dc4cdefa4b3c61aea52d3193911',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(319,'Guest','8564a38d526e5be79082347c3893debd',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(320,'Guest','e953dc97601640507f4c4820806b7798',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(321,'Guest','a7274c1309c9e41a41ccf155b15a78c6',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(322,'Guest','0169accaa7e178679a2d2da23cbac24b',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(323,'Guest','acf59f92a68c8749b7286e3d70b3950d',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(324,'Guest','b782f1082883c808282389a2f73a0b56',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(325,'Guest','24eed551bf7030082d2c0572c0f5b4de',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(326,'Guest','4136317f4a3e1b6bb4f65c0ec872a2c0',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(327,'Guest','1fb7a465204717ff6651e396755eea4c',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(328,'Guest','7ea6cf199b516006fd0aef326701a07e',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(329,'Guest','867c8a5070fc7e5c097e441624b38dca',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(330,'Guest','1a3b53451f97f1886368935c4eed4662',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(331,'Guest','dbdb2b5a087b09cc805feed2a9e53d98',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(332,'Guest','022b55d04ce3d0d71fe29f323e1b6996',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(333,'Guest','648707944321674cf07411ee8ba57143',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(334,'Guest','ad4b58e5b6631e17c084156d96d7a1ca',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(335,'Guest','8e768665045ef4e8d0f2f828afa70a96',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(336,'Guest','663af5b88741f73dcb6345d4d0576956',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(337,'Guest','cfc4dd9d7759e67e1e2f9fe6253fab7b',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(338,'Guest','4679e29f5dab0f92409828cecc054e3c',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(339,'Guest','cc870dd3bb516ab7d77a403ce444f7ae',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(340,'Guest','a75a0fdfa9b22e8cfb1bbc131aa84086',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(341,'Guest','da3c926d276718f8c4a848954843ab8a',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(342,'Guest','2451b8bee18ca17422e61b5470296f5e',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(343,'Guest','1183231fef875c52dc1644619784a061',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(344,'Guest','ff2fe52d53c833162bcc51ebaef331af',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(345,'Guest','a39e071ea1a52d3d166d59725ce3c063',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(346,'Guest','57d880483cef62f80ba22fe7f12c4fac',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(347,'Guest','b1f30a03c85b6acd5478d0bf85e41cfd',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(348,'Guest','675e2215004298893c81cec4742f4ba1',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(349,'Guest','1d82f3476fb5a06016ec3dae5bbf7bf3',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(350,'Guest','53333f41fc5bc07eee6f789e2b042057',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(351,'Guest','4594cb83ef7bb307ab3f4dd0cb63dd70',0,10,0,0,0,0,0,0,0,0,0,0,0,629674879),(352,'Guest','4ab3dc045c846e04cce64b0b59a3d90f',0,10,0,0,0,0,0,0,0,0,0,0,0,1465742621),(353,'Guest','3934ec98b60f46a343425db3504c9504',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(354,'Guest','6cadb913efb247fa43cb2d3fdda2e8e7',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(355,'Guest','e307fa227d1a3f230718c654c19995bc',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(356,'Guest','5524a6cb657ec6d6d1feb5dfbec02c0e',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(357,'Guest','3e5c0ad2cf1dccb9ee83d234c2abecb8',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(358,'Guest','26ca73eaac83b88edfc878d5d3f389c1',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(359,'Guest','fcefebd731a393205562930c5fe51cb9',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(360,'Guest','275895a5cc661f0e259b6da6bd13c15d',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(361,'Guest','f2abde960b2c7eb470d7ae19507ba578',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(362,'Guest','a505eae40d91341955d705d0f4c2d5fa',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(363,'Guest','ca25e88db76c855eb716c0e867634c37',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(364,'Guest','c9240b81a9f6710ed03c851568d030f2',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(365,'Guest','89c8aa2e25cda106eaab03e9a42091aa',0,10,0,0,0,0,0,0,0,0,0,0,0,635138760),(366,'Guest','64b0dd45c6a709471deedf355f1efd64',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(367,'Guest','44ded4d0443807997995d40066531cfe',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(368,'Guest','ca79b70f1dbd989e22b7dace80e88399',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(369,'Guest','34b3460bb8ab7fef0810548e5a3fa52b',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(370,'Guest','534595752052070721f1f2b810312cbd',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(371,'Guest','464df5449204439c5abe260bad48e0f4',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(372,'Guest','1a0c1504515662c4e6a00e063fa11615',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(373,'Guest','fde8953ee0c4d4ee495bd6780f437a1f',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(374,'Guest','52d3450cdbae1fbfe3722d7c7aebd4c4',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(375,'Guest','2a6c5d4678c3c398bc76d4ce8a0ebb92',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(376,'Guest','dd460d6b66f267ef0948725488756331',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(377,'Guest','f35ae77e06f457fc53ea567d584059dd',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(378,'Guest','84153df5a1be077b08a051cd8c0f0259',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(379,'Guest','3debe547ed12b2fe11b1b2ca544b1eca',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(380,'Guest','6d31a15a857564aba99b4da20efba4d1',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(381,'Guest','1c137d528b65907607939a9dca91a811',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(382,'Guest','da2fd2db99afa107cca2350e04b7b3cb',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(383,'Guest','a62719d2996e4341d0bed3e52953903d',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(384,'Guest','ae4b94d366f4b14887ab88b4f13e2cc4',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(385,'Guest','0130bf78b91dd51aae7ba8db0478a198',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(386,'Guest','f28f1140f3f78c0ffa21ac5c56779503',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(387,'Guest','2c7a8beaa894211b55ef9067854b5c1a',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(388,'Guest','e12da1010e08ccef1122175f82c5bfe2',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(389,'Guest','91115654474e27fd40664b92eeffc94d',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(390,'Guest','62ebd2edda2642b92bb3b78a58622ba7',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(391,'Guest','24d80b427a5f4ddabd6ebc6056091a46',0,10,0,0,0,0,0,0,0,0,0,0,0,629701730),(392,'Guest','2a6bb5222cd8589fe5ccc672e558d8d4',0,10,0,0,0,0,0,0,0,0,0,0,0,1465879228),(393,'Guest','5a9035bd0118b7e3d6330ff798cf7a41',0,10,0,0,0,0,0,0,0,0,0,0,0,1465879228),(394,'Guest','bacbadad05930744a7dbcaec3c728c48',0,10,0,0,0,0,0,0,0,0,0,0,0,3251702296),(395,'Guest','247a327c505e9760d9ed4b7dd794bde5',0,10,0,0,0,0,0,0,0,0,0,0,0,3251702296),(396,'Guest','dd5eb637061e596f241355258f1d7a32',0,10,0,0,0,0,0,0,0,0,0,0,0,1465879228),(397,'Guest','99026bee8357a72e5d0be56b91dd5293',0,10,0,0,0,0,0,0,0,0,0,0,0,3251702296),(398,'Guest','c7467ad964e1c2bc246eddf8d518fb38',0,10,0,0,0,0,0,0,0,0,0,0,0,629691675),(399,'Guest','0229a0c835aa92412462fb4805c007c6',0,10,0,0,0,0,0,0,0,0,0,0,0,635117618); /*!40000 ALTER TABLE `user` ENABLE KEYS */; UNLOCK TABLES; /*!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 2015-06-17 13:45:20