SQLize Online / PHPize Online  /  SQLtest Online

DROP TABLE IF EXISTS `address_data`; CREATE TABLE `address_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group` text DEFAULT NULL, `location` text DEFAULT NULL, `details` text DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=367 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `address_data` WRITE; INSERT INTO `address_data` VALUES (1,'Tallinn','Impact Day pakihoiu automaat','Põhja-Tallinna linnaosa, Marati tn 5'),(2,'Tallinn','Tallinna Akadeemia Coop Konsumi pakiautomaat','Mustamäe linnaosa, Akadeemia tee 35'),(3,'Tallinn','Tallinna Arsenali Keskuse pakiautomaat','Põhja-Tallinna linnaosa, Erika tn 14'),(4,'Tallinn','Tallinna Balti Jaama pakiautomaat','Põhja-Tallinna linnaosa, Toompuiestee 37'),(5,'Tallinn','Tallinna Balti Jaama turu pakiautomaat','Põhja-Tallinna linnaosa, Kopli tn 1'),(6,'Tallinn','Tallinna Coca-Cola Plaza pakiautomaat','Kesklinna linnaosa, Hobujaama tn 5'),(7,'Tallinn','Tallinna Donte Ärikeskuse pakiautomaat','Kesklinna linnaosa, Pärnu mnt 142'),(8,'Tallinn','Tallinna Ehitajate tee Grossi pakiautomaat','Mustamäe linnaosa, Ehitajate tee 41'),(9,'Tallinn','Tallinna Ehitajate tee Maxima XXX pakiautomaat','Haabersti linnaosa, Ehitajate tee 148'),(10,'Tallinn','Tallinna Haabersti Rimi pakiautomaat','Haabersti linnaosa, Haabersti tn 1'),(11,'Tallinn','Tallinna Idakeskuse pakiautomaat','Lasnamäe linnaosa, Punane tn 16'),(12,'Tallinn','Tallinna Järve Keskuse pakiautomaat','Nõmme linnaosa, Pärnu mnt 238'),(13,'Tallinn','Tallinna Järveotsa Grossi pakiautomaat','Haabersti linnaosa, Järveotsa tee 35b'),(14,'Tallinn','Tallinna Juhkentali Rimi pakiautomaat','Kesklinna linnaosa, Juhkentali tn 35'),(15,'Tallinn','Tallinna Kadaka Selveri pakiautomaat','Mustamäe linnaosa, Kadaka tee 56a'),(16,'Tallinn','Tallinna Kakumäe Selveri pakiautomaat','Haabersti linnaosa, Rannamõisa tee 6'),(17,'Tallinn','Tallinna Kärberi Keskuse pakiautomaat','Lasnamäe linnaosa, K. Kärberi tn 20'),(18,'Tallinn','Tallinna Kari Grossipoe pakiautomaat','Põhja-Tallinna linnaosa, Kari tn 3'),(19,'Tallinn','Tallinna Kivila Grossi pakiautomaat','Lasnamäe linnaosa, Kivila tn 26'),(20,'Tallinn','Tallinna Kolde Rimi pakiautomaat','Põhja-Tallinna linnaosa, Sõle tn 27'),(21,'Tallinn','Tallinna Kollase keskuse pakiautomaat','Haabersti linnaosa, Õismäe tee 107'),(22,'Tallinn','Tallinna Kristiine Keskuse pakiautomaat','Kristiine linnaosa, Endla tn 45'),(23,'Tallinn','Tallinna Läänemere Selveri pakiautomaat','Lasnamäe linnaosa, Läänemere tee 28'),(24,'Tallinn','Tallinna Lasnamäe Centrumi pakiautomaat','Lasnamäe linnaosa, Mustakivi tee 13'),(25,'Tallinn','Tallinna Lasnamäe Centrumi pakiautomaat','Lasnamäe linnaosa, Mustakivi tee 13'),(26,'Tallinn','Tallinna Lasnamäe Prisma pakiautomaat','Lasnamäe linnaosa, Mustakivi tee 17'),(27,'Tallinn','Tallinna Lastekodu Grossi pakiautomaat','Kesklinna linnaosa, Lastekodu tn 14'),(28,'Tallinn','Tallinna Linnamäe Maxima XXX pakiautomaat','Lasnamäe linnaosa, Linnamäe tee 57'),(29,'Tallinn','Tallinna Magdaleena pakiautomaat','Kesklinna linnaosa, Pärnu mnt 106'),(30,'Tallinn','Tallinna Magistrali Keskuse pakiautomaat','Mustamäe linnaosa, Sõpruse pst 201'),(31,'Tallinn','Tallinna Mähe Grossi pakiautomaat','Pirita linnaosa, Randvere tee 115'),(32,'Tallinn','Tallinna Männiku Rimi pakiautomaat','Nõmme linnaosa, Männiku tee 100'),(33,'Tallinn','Tallinna Marienthali keskuse pakiautomaat','Kristiine linnaosa, Mustamäe tee 16'),(34,'Tallinn','Tallinna Merimetsa Selveri pakiautomaat','Põhja-Tallinna linnaosa, Paldiski mnt 56'),(35,'Tallinn','Tallinna Mustakivi Keskuse pakiautomaat','Lasnamäe linnaosa, Mahtra tn 1'),(36,'Tallinn','Tallinna Mustamäe Keskuse pakiautomaat','Mustamäe linnaosa, A. H. Tammsaare tee 104a'),(37,'Tallinn','Tallinna Mustika Keskuse pakiautomaat','Mustamäe linnaosa, Karjavälja tn 4'),(38,'Tallinn','Tallinna Nautica Keskuse pakiautomaat','Kesklinna linnaosa, Ahtri tn 9'),(39,'Tallinn','Tallinna Nõmme tee 23 Maxima X pakiautomaat','Kristiine linnaosa, Nõmme tee 23'),(40,'Tallinn','Tallinna Nõmme turu pakiautomaat','Nõmme linnaosa, Turu plats 8'),(41,'Tallinn','Tallinna Nurmenuku pakiautomaat','Haabersti linnaosa, Ehitajate tee 107'),(42,'Tallinn','Tallinna Õismäe Maxima XX pakiautomaat','Haabersti linnaosa, Õismäe tee 46'),(43,'Tallinn','Tallinna Paasiku Grossi pakiautomaat','Lasnamäe linnaosa, Paasiku tn 2a'),(44,'Tallinn','Tallinna Pääsküla RIMI pakiautomaat','Nõmme linnaosa, Pärnu mnt 453e'),(45,'Tallinn','Tallinna Paepargi Maxima XX pakiautomaat','Lasnamäe linnaosa, Paepargi tn 57'),(46,'Tallinn','Tallinna Pallasti pakiautomaat','Lasnamäe linnaosa, Pallasti tn 28'),(47,'Tallinn','Tallinna Pärnu mnt 390b Maxima X pakiautomaat','Nõmme linnaosa, Pärnu mnt 390'),(48,'Tallinn','Tallinna Pelgulinna Selveri pakiautomaat','Põhja-Tallinna linnaosa, Sõle tn 51'),(49,'Tallinn','Tallinna Pirita Keskuse pakiautomaat','Pirita linnaosa, Merivälja tee 24'),(50,'Tallinn','Tallinna Pirita Selveri pakiautomaat','Pirita linnaosa, Rummu tee 4'),(51,'Tallinn','Tallinna Põhja pst Neste pakiautomaat','Põhja-Tallinna linnaosa, Põhja pst 17a'),(52,'Tallinn','Tallinna Punane 50 pakiautomaat','Lasnamäe linnaosa, Punane tn 50'),(53,'Tallinn','Tallinna Rannamõisa Lidl pakiautomaat','Haabersti linnaosa, Rannamõisa tee 12a'),(54,'Tallinn','Tallinna Raudalu Coop Konsumi pakiautomaat','Nõmme linnaosa, Viljandi mnt 41a'),(55,'Tallinn','Tallinna Rocca al Mare pakiautomaat','Haabersti linnaosa, Paldiski mnt 102'),(56,'Tallinn','Tallinna Sikupilli pakiautomaat','Lasnamäe linnaosa, Tartu mnt 87b'),(57,'Tallinn','Tallinna Smuuli Maxima XX pakiautomaat','Lasnamäe linnaosa, J. Smuuli tee 9'),(58,'Tallinn','Tallinna Solaris Keskuse pakiautomaat (Pikem ooteaeg kuni 2 päeva)','Kesklinna linnaosa, Estonia pst 9'),(59,'Tallinn','Tallinna Sõpruse pst 171 Maxima X pakiautomaat','Mustamäe linnaosa, Sõpruse pst 171'),(60,'Tallinn','Tallinna Sõpruse Rimi pakiautomaat','Kristiine linnaosa, Sõpruse pst 174'),(61,'Tallinn','Tallinna Stockmanni pakiautomaat','Kesklinna linnaosa, Liivalaia tn 53'),(62,'Tallinn','Tallinna Stroomi Keskuse pakiautomaat','Põhja-Tallinna linnaosa, Tuulemaa tn 20'),(63,'Tallinn','Tallinna Sütiste Maxima X pakiautomaat','Mustamäe linnaosa, J. Sütiste tee 28'),(64,'Tallinn','Tallinna T1 Keskuse pakiautomaat','Lasnamäe linnaosa, Peterburi tee 2'),(65,'Tallinn','Tallinna Tähesaju Selveri pakiautomaat','Lasnamäe linnaosa, Tähesaju tee 1'),(66,'Tallinn','Tallinna Talleke ja Pullike pakiautomaat','Haabersti linnaosa, Kakumäe tee 42'),(67,'Tallinn','Tallinna Tammsaare Ärikeskuse pakiautomaat','Kristiine linnaosa, A. H. Tammsaare tee 47'),(68,'Tallinn','Tallinna Tammsaare Maxima XX pakiautomaat','Mustamäe linnaosa, A. H. Tammsaare tee 133'),(69,'Tallinn','Tallinna Tatari 51 pakiautomaat','Kesklinna linnaosa, Tatari tn 51'),(70,'Tallinn','Tallinna Tatari Rimi pakiautomaat','Kesklinna linnaosa, Tatari tn 64'),(71,'Tallinn','Tallinna Telliskivi Rimi pakiautomaat','Põhja-Tallinna linnaosa, Telliskivi tn 61'),(72,'Tallinn','Tallinna Tondiraba Maxima XX pakiautomaat','Lasnamäe linnaosa, Tondiraba tn 7'),(73,'Tallinn','Tallinna Tondi Selveri pakiautomaat','Kristiine linnaosa, A. H. Tammsaare tee 62'),(74,'Tallinn','Tallinna Tööstuse Rimi pakiautomaat','Põhja-Tallinna linnaosa, Tööstuse tn 101'),(75,'Tallinn','Tallinna Torupilli Selveri pakiautomaat','Kesklinna linnaosa, Vesivärava tn 37'),(76,'Tallinn','Tallinna Ülemiste City Selveri pakiautomaat','Lasnamäe linnaosa, Sepapaja tn 2'),(77,'Tallinn','Tallinna Ümera Maxima XX pakiautomaat','Lasnamäe linnaosa, Laagna tee 80'),(78,'Tallinn','Tallinna Valdeku Maxima X pakiautomaat','Nõmme linnaosa, Valdeku tn 114'),(79,'Tallinn','Tallinna Valdeku Selver ABC pakiautomaat','Nõmme linnaosa, Vabaduse pst 54b'),(80,'Tallinn','Tallinna Vikerlase Rimi pakiautomaat','Lasnamäe linnaosa, Vikerlase tn 19'),(81,'Tallinn','Tallinna Vilde tee Maxima XX pakiautomaat','Mustamäe linnaosa, E. Vilde tee 75'),(82,'Tallinn','Tallinna Viru Bussiterminali pakiautomaat','Kesklinna linnaosa, Viru väljak 4'),(83,'Alutaguse vald','Iisaku Grossi pakiautomaat','Iisaku alevik, Tartu mnt 55'),(84,'Alutaguse vald','Mäetaguse bussijaama pakiautomaat','Mäetaguse alevik, Kooli tn 7'),(85,'Anija vald','Aegviidu Meie kaupluse pakiautomaat','Aegviidu alev, Piibe mnt 8'),(86,'Anija vald','Alavere pakiautomaat','Alavere küla, Oja tn 1'),(87,'Anija vald','Kehra Coop Konsumi pakiautomaat','Kehra linn, Kose mnt 9'),(88,'Antsla vald','Antsla Coop Konsumi pakiautomaat','Antsla linn, F. R. Kreutzwaldi tn 4a'),(89,'Antsla vald','Tsooru pakiautomaat','Tsooru küla'),(90,'Elva vald','Elva Arbimäe Coop Konsumi pakiautomaat','Elva linn, Kirde tn 3'),(91,'Elva vald','Elva Turuplatsi Coop Konsumi pakiautomaat','Elva linn, Kesk tn 1'),(92,'Elva vald','Puhja Coop Konsumi pakiautomaat','Puhja alevik, Nooruse tn 2'),(93,'Elva vald','Rannu Coop Kaupluse pakiautomaat','Rannu alevik, Elva tee 10'),(94,'Häädemeeste vald','Häädemeeste Coop Konsumi pakiautomaat','Häädemeeste alevik, Pärnu mnt 40'),(95,'Haapsalu linn','Haapsalu Kastani pakiautomaat','Haapsalu linn, Kuuse tn 28'),(96,'Haapsalu linn','Haapsalu Kaubamaja pakiautomaat','Haapsalu linn, Tallinna mnt 1'),(97,'Haapsalu linn','Uuemõisa Coop Konsumi pakiautomaat','Uuemõisa alevik, Tallinna mnt 84'),(98,'Haljala vald','Haljala Grossi pakiautomaat','Haljala alevik, Võsu mnt 5'),(99,'Haljala vald','Võsu pakiautomaat','Võsu alevik, Mere tn 63'),(100,'Harku vald','Harku Raamatukogu pakiautomaat','Harku alevik, Instituudi tee 5'),(101,'Harku vald','Muraste Coop Konsumi pakiautomaat','Muraste küla, Lee tee 1'),(102,'Harku vald','Roo Prisma pakiautomaat','Harkujärve küla, Roo tee 1'),(103,'Harku vald','Tabasalu Keskuse pakiautomaat','Tabasalu alevik, Kallaste tn 7'),(104,'Harku vald','Tabasalu Rimi pakiautomaat','Tabasalu alevik, Klooga mnt 10b'),(105,'Harku vald','Tiskre Prisma pakiautomaat','Tiskre küla, Liiva tee 59'),(106,'Harku vald','Vääna-Jõesuu kauplus Maksis pakiautomaat','Vääna-Jõesuu küla'),(107,'Harku vald','Vääna pakiautomaat','Vääna küla, Viljapuuaia tee 1'),(108,'Hiiumaa vald','Käina Coop Konsumi pakiautomaat','Käina alevik, Spordi tn 9'),(109,'Hiiumaa vald','Kärdla Hiiu Coop Konsumi pakiautomaat','Kärdla linn, Keskväljak 1'),(110,'Hiiumaa vald','Kärdla Tormi Coop Konsumi pakiautomaat','Kärdla linn, Heltermaa mnt 14a'),(111,'Hiiumaa vald','Kõrgessaare Coop kaupluse pakiautomaat','Kõrgessaare alevik, Tööstuse tee 10'),(112,'Järva vald','Aravete Meie kaupluse pakiautomaat','Aravete alevik, Piibe mnt 16'),(113,'Järva vald','Imavere pakiautomaat','Imavere küla, Viljandi mnt 11'),(114,'Järva vald','Järva-Jaani Grossi pakiautomaat','Järva-Jaani alev, Lai tn 23'),(115,'Järva vald','Kareda teeninduskeskuse pakiautomaat','Peetri alevik, Kesktee 11'),(116,'Järva vald','Koeru Vallamaja pakiautomaat','Koeru alevik, Paide tee 5'),(117,'Järva vald','Koigi pakiautomaat','Koigi küla, Mõisavahe tee 2'),(118,'Jõelähtme vald','Kostivere Meie kaupluse pakiautomaat','Kostivere alevik, Mõisa tee 3'),(119,'Jõelähtme vald','Loo Grossi pakiautomaat','Loo alevik, Saha tee 9'),(120,'Jõgeva vald','Jõgeva Postkontori pakiautomaat','Jõgeva linn, Aia tn 8'),(121,'Jõgeva vald','Palamuse pakiautomaat','Palamuse alevik, Uus tn 1'),(122,'Jõgeva vald','Torma Coop kaupluse pakiautomaat','Torma alevik, Kesk tn 1a'),(123,'Jõhvi vald','Jõhvi Grossi pakiautomaat','Jõhvi linn, Tartu mnt 15a'),(124,'Jõhvi vald','Jõhvi Jewe kaubanduskeskuse pakiautomaat','Jõhvi linn, Narva mnt 8'),(125,'Jõhvi vald','Jõhvi Maxima XX pakiautomaat','Jõhvi linn, Rakvere tn 29'),(126,'Jõhvi vald','Jõhvi Pargi keskuse pakiautomaat','Jõhvi linn, Puru tee 1'),(127,'Kambja vald','Kambja Coop Konsumi pakiautomaat','Kambja alevik, Kesk tn 2a'),(128,'Kambja vald','Külitse Coop Konsumi pakiautomaat','Külitse alevik, Kiigemäe tee 2'),(129,'Kambja vald','Soinaste Kaasiku Coop Konsumi pakiautomaat','Soinaste küla, Kaasiku tn 35'),(130,'Kambja vald','Tõrvandi Coop Konsumi pakiautomaat','Tõrvandi alevik, Müürsepa tn 1'),(131,'Kambja vald','Ülenurme Coop Konsumi pakiautomaat','Ülenurme alevik, Võru mnt 2'),(132,'Kanepi vald','Kanepi Vallamaja pakiautomaat','Kanepi alevik, Turu põik 1'),(133,'Kanepi vald','Saverna pakiautomaat','Saverna küla, Kooli tee 5'),(134,'Kastre vald','Haaslava Meie kaupluse pakiautomaat','Haaslava küla, Jõe tn 1'),(135,'Kastre vald','Melliste pakiautomaat','Melliste küla, Tartu mnt 8'),(136,'Kastre vald','Roiu Coop kaupluse pakiautomaat','Roiu alevik, Männi tn 9'),(137,'Kastre vald','Võnnu kultuurimaja pakiautomaat','Võnnu alevik, Tartu tn 24'),(138,'Kehtna vald','Järvakandi Kandi Konsumi pakiautomaat','Järvakandi alev, Tallinna mnt 37'),(139,'Kehtna vald','Kehtna Coop kaupluse pakiautomaat','Kehtna alevik, Lasteaia tn 12'),(140,'Keila linn','Keila Grossi pakiautomaat','Piiri tn 5'),(141,'Keila linn','Keila Maxima X pakiautomaat','Tallinna mnt 25'),(142,'Keila linn','Keila Rõõmu kaubamaja pakiautomaat','Haapsalu mnt 57a'),(143,'Kiili vald','Kiili Coop Konsumi pakiautomaat','Kiili alev, Nabala tee 4'),(144,'Kiili vald','Luige Keskuse pakiautomaat','Luige alevik, Viljandi mnt 168'),(145,'Kohtla-Järve linn','Ahtme Estonia pst Grossi pakiautomaat','Ahtme linnaosa, Estonia pst 30a'),(146,'Kohtla-Järve linn','Ahtme Grossi pakiautomaat','Ahtme linnaosa, Maleva tn 23'),(147,'Kohtla-Järve linn','Ahtme Maxima XX pakiautomaat','Ahtme linnaosa, Puru tee 77'),(148,'Kohtla-Järve linn','Kohtla-Järve Keskallee Maxima X pakiautomaat','Järve linnaosa, Keskallee 12'),(149,'Kohtla-Järve linn','Kohtla-Järve Mõisa tee Maxima X pakiautomaat','Järve linnaosa, Mõisa tee 3'),(150,'Kohtla-Järve linn','Kohtla-Järve Rimi pakiautomaat','Järve linnaosa, Põhja allee 4'),(151,'Kohtla-Järve linn','Kohtla-Järve Selveri pakiautomaat','Järve linnaosa, Järveküla tee 68'),(152,'Kohtla-Järve linn','Kohtla-Järve Vironia keskuse pakiautomaat','Järve linnaosa, Järveküla tee 50'),(153,'Kose vald','Kose Grossi pakiautomaat','Kose alevik, Kodu tn 2'),(154,'Kose vald','Kose-Uuemõisa pakiautomaat','Kose-Uuemõisa alevik, Kesk tn 15'),(155,'Lääne-Harju vald','Klooga pakiautomaat','Klooga alevik, Aedlinna tee 3'),(156,'Lääne-Harju vald','Laulasmaa Selver ABC pakiautomaat','Laulasmaa küla, Kloogaranna tee 26'),(157,'Lääne-Harju vald','Padise Keskuse tee pakiautomaat','Padise küla'),(158,'Lääne-Harju vald','Paldiski Coop Konsumi pakiautomaat','Paldiski linn, Rae tn 38'),(159,'Lääne-Harju vald','Paldiski Maxima X pakiautomaat','Paldiski linn, Rae tn 14b'),(160,'Lääne-Nigula vald','Nõva pakiautomaat','Nõva küla'),(161,'Lääne-Nigula vald','Pürksi pakiautomaat','Pürksi küla / Birkas'),(162,'Lääne-Nigula vald','Risti Coop kaupluse pakiautomaat','Risti alevik, Haapsalu mnt 1'),(163,'Lääne-Nigula vald','Taebla Bussijaama pakiautomaat','Taebla alevik, Haapsalu mnt 9'),(164,'Lääneranna vald','Kõmsi pakiautomaat','Kõmsi küla, Keskuse tee 3'),(165,'Lääneranna vald','Koonga pakiautomaat','Koonga küla, 2'),(166,'Lääneranna vald','Lihula Coop Konsumi pakiautomaat','Lihula linn, Tallinna mnt 12'),(167,'Lääneranna vald','Lõpe pakiautomaat','Lõpe küla, 1'),(168,'Lääneranna vald','Varbla pakiautomaat','Varbla küla'),(169,'Lääneranna vald','Virtsu pakiautomaat','Virtsu alevik, Tallinna mnt 13'),(170,'Lüganuse vald','Kiviõli Grossi pakiautomaat','Kiviõli linn, Keskpuiestee 33'),(171,'Lüganuse vald','Kiviõli Maxima X pakiautomaat','Kiviõli linn, Viru tn 5'),(172,'Luunja vald','Ihaste Coop Konsumi pakiautomaat','Veibri küla, Kasesalu tee 51'),(173,'Luunja vald','Lohkva Spordihoone pakiautomaat','Lohkva küla, Kabina tee 14'),(174,'Luunja vald','Luunja pakiautomaat','Luunja alevik, Puiestee tn 4'),(175,'Maardu linn','Maardu Maxima X pakiautomaat','Keemikute tn 37'),(176,'Maardu linn','Maardu Maxima XX pakiautomaat','Keemikute tn 2'),(177,'Maardu linn','Maardu Pärli Keskuse pakiautomaat','Nurga tn 3'),(178,'Maardu linn','Muuga Maxima X pakiautomaat','Altmetsa tee 1'),(179,'Märjamaa vald','Kivi-Vigala pakiautomaat','Kivi-Vigala küla, Kiriku tee 4'),(180,'Märjamaa vald','Märjamaa Maxima X pakiautomaat','Märjamaa alev, Kasti tee 1'),(181,'Mulgi vald','Abja Coop Konsumi pakiautomaat','Abja-Paluoja linn, Pärnu mnt 13'),(182,'Mulgi vald','Halliste Coop Kaupluse pakiautomaat','Halliste alevik, Viljandi mnt 11'),(183,'Mulgi vald','Karksi-Nuia Coop Konsumi pakiautomaat','Karksi-Nuia linn, Rahumäe tn 1'),(184,'Mulgi vald','Mõisaküla Coop kaupluse pakiautomaat','Mõisaküla linn, Kesk tn 8'),(185,'Mustvee vald','Avinurme pakiautomaat','Avinurme alevik, Võidu tn 2'),(186,'Mustvee vald','Mustvee Coop Konsumi pakiautomaat','Mustvee linn, Tartu tn 3'),(187,'Narva linn','Narva Astri Keskuse pakiautomaat','Tallinna mnt 41'),(188,'Narva linn','Narva Fama keskuse pakiautomaat','Fama tn 10'),(189,'Narva linn','Narva Kangelaste Lidl pakiautomaat','Kangelaste prospekt 37a'),(190,'Narva linn','Narva Kerese keskuse pakiautomaat','P. Kerese tn 3'),(191,'Narva linn','Narva Kreenholmi Maxima XX pakiautomaat','Kreenholmi tn 52'),(192,'Narva linn','Narva Megamarketi pakiautomaat','Rakvere tn 71'),(193,'Narva linn','Narva Optimus Mööbli pakiautomaat','Kreenholmi tn 50'),(194,'Narva linn','Narva Prisma pakiautomaat','Kangelaste prospekt 29'),(195,'Narva linn','Narva Soldina Maxima XX pakiautomaat','Soldina tn 20'),(196,'Otepää vald','Otepää Maxima X pakiautomaat','Otepää linn, Valga mnt 1b'),(197,'Otepää vald','Puka pakiautomaat','Puka alevik, Kooli tn 6'),(198,'Otepää vald','Sangaste pakiautomaat','Sangaste alevik, Valga mnt 11'),(199,'Paide linn','Paide Coop Maksimarket pakiautomaat','Paide linn, Ringtee 2'),(200,'Paide linn','Paide Pärnu 55 pakiautomaat','Paide linn, Pärnu tn 55'),(201,'Paide linn','Paide Selveri pakiautomaat','Paide linn, Aiavilja tn 4'),(202,'Pärnu linn','Audru osavallakeskuse pakiautomaat','Audru alevik, Pärna allee 7'),(203,'Pärnu linn','Lavassaare pakiautomaat','Lavassaare alev, Võidu tn 2'),(204,'Pärnu linn','Paikuse Coop Konsumi pakiautomaat','Paikuse alev, Pärnade pst 1'),(205,'Pärnu linn','Pärnu Coop Maksimarketi pakiautomaat','Papsaare küla, Haapsalu mnt 43'),(206,'Pärnu linn','Pärnu Jannseni Rimi pakiautomaat','Pärnu linn, J. V. Jannseni tn 3/1'),(207,'Pärnu linn','Pärnu Kaubamajaka pakiautomaat','Pärnu linn, Papiniidu tn 8'),(208,'Pärnu linn','Pärnu Maxima XXX pakiautomaat','Pärnu linn, Riia mnt 131'),(209,'Pärnu linn','Pärnu Oja Selver ABC pakiautomaat','Pärnu linn, Liblika tn 6'),(210,'Pärnu linn','Pärnu Port Artur 2 pakiautomaat','Pärnu linn, Lai tn 11'),(211,'Pärnu linn','Pärnu Tiina Coop Konsumi pakiautomaat','Pärnu linn, Riia mnt 74'),(212,'Pärnu linn','Pärnu Turu pakiautomaat','Pärnu linn, Suur-Sepa tn 18'),(213,'Pärnu linn','Pärnu Ülejõe Selveri pakiautomaat','Pärnu linn, Tallinna mnt 93a'),(214,'Pärnu linn','Tõstamaa pakiautomaat','Tõstamaa alevik, Varbla mnt 2'),(215,'Põhja-Pärnumaa vald','Pärnu-Jaagupi Grossi pakiautomaat','Pärnu-Jaagupi alev, Uus tn 20a'),(216,'Põhja-Pärnumaa vald','Tootsi Bussijaama pakiautomaat','Tootsi alev, Kesk tn 8'),(217,'Põhja-Pärnumaa vald','Vändra Coop Konsumi pakiautomaat','Vändra alev, Pärnu-Paide mnt 21'),(218,'Põhja-Pärnumaa vald','Vändra Koidula Coop Konsumi pakiautomaat','Vändra alev, Vana tn 60'),(219,'Põhja-Sakala vald','Kõpu pakiautomaat','Kõpu alevik, Tipu tn 6'),(220,'Põhja-Sakala vald','Suure-Jaani Tervisekoja pakiautomaat','Suure-Jaani linn, Pärnu tn 4'),(221,'Põhja-Sakala vald','Võhma Bussijaama pakiautomaat','Võhma linn, Tallinna tn 17'),(222,'Põlva vald','Mooste pakiautomaat','Mooste alevik, Lasteaia tee 3'),(223,'Põlva vald','Põlva Coop Konsumi pakiautomaat','Põlva linn, Aasa tn 1'),(224,'Põlva vald','Põlva Meie Ostumarketi pakiautomaat','Põlva linn, Lao tn 14'),(225,'Põlva vald','Põlva Selveri pakiautomaat','Põlva linn, Jaama tn 12'),(226,'Põlva vald','Tilsi pakiautomaat','Tilsi küla'),(227,'Põlva vald','Vastse-Kuuste Coop kaupluse pakiautomaat','Vastse-Kuuste alevik, Kesktänav 16'),(228,'Raasiku vald','Aruküla Coop Konsumi pakiautomaat','Aruküla alevik, Tallinna mnt 8'),(229,'Raasiku vald','Raasiku Coop Konsumi pakiautomaat','Raasiku alevik, Tallinna mnt 19'),(230,'Rae vald','Järveküla Rimi pakiautomaat','Peetri alevik, Vana-Tartu mnt 71'),(231,'Rae vald','Jüri Coop Konsumi pakiautomaat','Jüri alevik, Aruküla tee 29'),(232,'Rae vald','Jüri Grossi pakiautomaat','Jüri alevik, Aruküla tee 7'),(233,'Rae vald','Lagedi Keskusehoone pakiautomaat','Lagedi alevik, Kooli tn 18b'),(234,'Rae vald','Peetri Keskuse pakiautomaat','Peetri alevik, Küti tee 4'),(235,'Rae vald','Peetri Selveri pakiautomaat','Peetri alevik, Veesaare tee 2'),(236,'Rae vald','Vaida Coop kaupluse pakiautomaat','Vaida alevik, Vana-Vaida tee 3'),(237,'Rakvere linn','Rakvere Lilleoru kaupluse pakiautomaat','Tartu tn 55'),(238,'Rakvere linn','Rakvere Turutare pakiautomaat','Laada tn 18'),(239,'Rakvere linn','Rakvere Vaala Keskuse pakiautomaat','Lõõtspilli tn 2'),(240,'Rakvere vald','Rakvere Lidl pakiautomaat','Ussimäe küla, Ussimäe tn 1'),(241,'Rakvere vald','Rakvere Põhjakeskuse pakiautomaat','Tõrremäe küla, Haljala tee 4'),(242,'Rakvere vald','Uhtna kaupluse pakiautomaat','Uhtna alevik, Mõisa tn 1'),(243,'Räpina vald','Räpina Coop Konsumi pakiautomaat','Räpina linn, Kooli tn 14a'),(244,'Räpina vald','Räpina Maxima X pakiautomaat','Räpina linn, Pargi tn 1'),(245,'Räpina vald','Veriora pakiautomaat','Veriora alevik, Räpina mnt 2'),(246,'Rapla vald','Kabala pakiautomaat','Kabala küla, Koikse tee 7'),(247,'Rapla vald','Kaiu Huvikooli pakiautomaat','Kaiu alevik, Kasvandu tee 15'),(248,'Rapla vald','Rapla Coop Konsumi pakiautomaat','Rapla linn, Tallinna mnt 16'),(249,'Rapla vald','Rapla Maxima X pakiautomaat','Rapla linn, Tallinna mnt 50a'),(250,'Rõuge vald','Haanja pakiautomaat','Haanja küla, Võru tee 15'),(251,'Rõuge vald','Mõniste pakiautomaat','Mõniste küla'),(252,'Rõuge vald','Rõuge Bussijaama pakiautomaat','Rõuge alevik'),(253,'Ruhnu vald','Ruhnu pakiväljastus','Ruhnu küla'),(254,'Saarde vald','Kilingi-Nõmme Coop Konsumi pakiautomaat','Kilingi-Nõmme linn, Pärnu tn 37'),(255,'Saaremaa vald','Kärla pakiautomaat','Kärla alevik, Pargi tn 2'),(256,'Saaremaa vald','Kummeli Coop Konsumi pakiautomaat','Kudjape alevik, Kummeli põik 1'),(257,'Saaremaa vald','Kuressaare Maxima XX pakiautomaat','Kuressaare linn, Tallinna tn 64'),(258,'Saaremaa vald','Kuressaare Smuuli Coop Konsumi pakiautomaat','Kuressaare linn, J. Smuuli tn 1'),(259,'Saaremaa vald','Leisi pakiautomaat','Leisi alevik, Mustjala mnt 5'),(260,'Saaremaa vald','Lümanda pakiautomaat','Lümanda küla'),(261,'Saaremaa vald','Orissaare Coop Konsumi pakiautomaat','Orissaare alevik, Kuivastu mnt 28'),(262,'Saaremaa vald','Saaremaa Kaubamaja pakiautomaat','Kuressaare linn, Raekoja tn 1'),(263,'Saaremaa vald','Salme Coop Konsumi pakiautomaat','Salme alevik, Sõrve mnt 2'),(264,'Saaremaa vald','Valjala pakiautomaat','Valjala alevik, Posti tn 27'),(265,'Saku vald','Kiisa Coop kaupluse pakiautomaat','Kiisa alevik, Kurtna tee 10'),(266,'Saku vald','Roobuka pakiautomaat','Roobuka küla, Roheluse tee 1'),(267,'Saku vald','Saku Coop Ehituskeskuse pakiautomaat','Saku alevik, Tallinna mnt 6'),(268,'Saku vald','Saku Selveri pakiautomaat','Saku alevik, Üksnurme tee 2'),(269,'Saue vald','Haiba Bussijaama pakiautomaat','Haiba küla, Riisipere tee 8'),(270,'Saue vald','Kaasiku pakiautomaat','Kaasiku küla'),(271,'Saue vald','Laagri Coop Maksimarketi pakiautomaat','Laagri alevik, Pärnu mnt 558a'),(272,'Saue vald','Laagri Veskitammi Maxima X pakiautomaat','Laagri alevik, Veskitammi tn 3'),(273,'Saue vald','Laagri Veskitammi Selver ABC pakiautomaat','Laagri alevik, Veskitammi tn 10'),(274,'Saue vald','Saue Grossi pakiautomaat','Saue linn, Pärnasalu põik 1b'),(275,'Saue vald','Saue Kaubakeskuse pakiautomaat','Saue linn, Ridva tn 15'),(276,'Saue vald','Turba kaupluse pakiautomaat','Turba alevik, Jaama tee 8'),(277,'Saue vald','Veskimöldre Keskuse pakiautomaat','Alliku küla, Instituudi tee 132'),(278,'Setomaa vald','Värska pakiautomaat','Värska alevik, Pikk tn 12'),(279,'Sillamäe linn','Sillamäe Coop Maksimarketi pakiautomaat','Viru pst 5a'),(280,'Sillamäe linn','Sillamäe Viru pst Maxima X pakiautomaat','Viru pst 35'),(281,'Tapa vald','Tamsalu Grossi pakiautomaat','Tamsalu linn, Tehnika tn 24'),(282,'Tapa vald','Tapa Grossi pakiautomaat','Tapa linn, Jaama tn 1'),(283,'Tapa vald','Tapa Maxima X pakiautomaat','Tapa linn, Pikk tn 33'),(284,'Tartu linn','Märja Coop Konsumi pakiautomaat','Märja alevik, Aisa tn 2'),(285,'Tartu linn','Tartu Aardla Selveri pakiautomaat','Tartu linn, Võru tn 77'),(286,'Tartu linn','Tartu Anne 40 Maxima X pakiautomaat','Tartu linn, Anne tn 40'),(287,'Tartu linn','Tartu Annelinna Prisma pakiautomaat','Tartu linn, Nõlvaku tn 2'),(288,'Tartu linn','Tartu Anne Selveri pakiautomaat','Tartu linn, Kalda tee 43'),(289,'Tartu linn','Tartu Eedeni pakiautomaat','Tartu linn, Kalda tee 1c'),(290,'Tartu linn','Tartu Ilmatsalu Maxima X pakiautomaat','Tartu linn, Ilmatsalu tn 11'),(291,'Tartu linn','Tartu Jaamamõisa Selveri pakiautomaat','Tartu linn, Jaama tn 74'),(292,'Tartu linn','Tartu Karete Coop Konsumi pakiautomaat','Tartu linn, Jalaka tn 34'),(293,'Tartu linn','Tartu Kesklinna Keskuse pakiautomaat','Tartu linn, Küüni tn 7'),(294,'Tartu linn','Tartu Kivilinna Coop Konsumi pakiautomaat','Tartu linn, Jaama tn 173'),(295,'Tartu linn','Tartu Kvartali Keskuse pakiautomaat','Tartu linn, Riia tn 2'),(296,'Tartu linn','Tartu Kvissentali Coop Konsumi pakiautomaat','Tartu linn, Aruküla tee 5'),(297,'Tartu linn','Tartu Lembitu Coop Konsumi pakiautomaat','Tartu linn, Lembitu tn 2'),(298,'Tartu linn','Tartu Lõunakeskuse pakiautomaat','Tartu linn, Lääneringtee 39'),(299,'Tartu linn','Tartu Maarjamõisa Coop Konsumi pakiautomaat','Tartu linn, Ravila tn 14d'),(300,'Tartu linn','Tartu Raadi Maxima XX pakiautomaat','Tartu linn, Narva mnt 112'),(301,'Tartu linn','Tartu Rebase Rimi pakiautomaat','Tartu linn, Rebase tn 10'),(302,'Tartu linn','Tartu Ringtee Selveri pakiautomaat (Pikem ooteaeg kuni 2 päeva)','Tartu linn, Aardla tn 114'),(303,'Tartu linn','Tartu Saare Maxima X pakiautomaat','Tartu linn, Anne tn 57'),(304,'Tartu linn','Tartu Sõbrakeskuse pakiautomaat','Tartu linn, Võru tn 55f'),(305,'Tartu linn','Tartu Tähe Rimi pakiautomaat','Tartu linn, Tähe tn 19'),(306,'Tartu linn','Tartu Tasku keskuse pakiautomaat','Tartu linn, Turu tn 2'),(307,'Tartu linn','Tartu Tuglase Rimi pakiautomaat','Tartu linn, F. Tuglase tn 19'),(308,'Tartu linn','Tartu Ujula Coop Konsumi pakiautomaat','Tartu linn, Ujula tn 2'),(309,'Tartu linn','Tartu Ülikooli Kliinikumi pakiautomaat','Tartu linn, L. Puusepa tn 8'),(310,'Tartu linn','Tartu Vahi Selveri pakiautomaat','Tartu linn, Vahi tn 62'),(311,'Tartu linn','Tartu Veeriku Selveri pakiautomaat','Tartu linn, Vitamiini tn 1'),(312,'Tartu vald','Kõrveküla Coop kaupluse pakiautomaat','Kõrveküla alevik, Vasula tee 4'),(313,'Tartu vald','Laeva Spordihoone pakiautomaat','Laeva küla, Aeru tee 3'),(314,'Tartu vald','Lähte pakiautomaat','Lähte alevik, Poe tn 4/3'),(315,'Tartu vald','Tabivere Saadjärve Coop kaupluse pakiautomaat','Tabivere alevik, Kalda tn 1'),(316,'Tartu vald','Tartu Raadimõisa Coop Konsumi pakiautomaat','Raadi alev, Kaupmehe tn 2'),(317,'Toila vald','Kohtla-Nõmme pakiautomaat','Kohtla-Nõmme alev, Kooli tn 6'),(318,'Toila vald','Toila Meie kaupluse pakiautomaat','Toila alevik, Pikk tn 18a'),(319,'Tori vald','Are pakiautomaat','Are alevik, Pärivere tee 17'),(320,'Tori vald','Sauga Coop Konsumi pakiautomaat','Sauga alevik, Kuldnoka tn 1'),(321,'Tori vald','Sindi Maxima X pakiautomaat','Sindi linn, Pärnu mnt 57'),(322,'Tori vald','Tammiste Coop Konsumi pakiautomaat','Tammiste küla, Kellukese tee 2'),(323,'Tori vald','Tori pakiautomaat','Tori alevik, Pärnu mnt 21'),(324,'Tõrva vald','Ala Coop kaupluse pakiautomaat','Ala küla'),(325,'Tõrva vald','Hummuli Coop kaupluse pakiautomaat','Hummuli alevik, Tamme tee 2'),(326,'Tõrva vald','Tõrva Tikste Coop pakiautomaat','Tõrva linn, Viljandi tn 28'),(327,'Türi vald','Oisu (aktiivne kuni 31.10.2024) pakiautomaat','Oisu alevik, Estonia pst 1'),(328,'Türi vald','Türi Maxima X pakiautomaat','Türi linn, Viljandi tn 10'),(329,'Türi vald','Väätsa pakiautomaat','Väätsa alevik, Pikk tn 3'),(330,'Väike-Maarja vald','Rakke pakiautomaat','Rakke alevik, F. R. Faehlmanni tee 15'),(331,'Väike-Maarja vald','Simuna pakiautomaat','Simuna alevik, Pargi tn 2'),(332,'Väike-Maarja vald','Väike-Maarja Grossi pakiautomaat','Väike-Maarja alevik, Pikk tn 9'),(333,'Valga vald','Lüllemäe pakiautomaat','Lüllemäe küla, Kirikumõisa tee 1'),(334,'Valga vald','Tsirguliina pakiautomaat','Tsirguliina alevik, Nooruse tn 1'),(335,'Valga vald','Valga Kungla Coop Konsumi pakiautomaat','Valga linn, Kungla tn 37b'),(336,'Valga vald','Valga Maxima XX pakiautomaat','Valga linn, Jaama pst 2b'),(337,'Valga vald','Valga Siili Coop Konsumi pakiautomaat','Valga linn, A. Neulandi tn 2'),(338,'Viimsi vald','Haabneeme Coop Konsumi pakiautomaat','Haabneeme alevik, Rohuneeme tee 32'),(339,'Viimsi vald','Leppneeme sadama pakiautomaat','Leppneeme küla, Leppneeme Sadama tee'),(340,'Viimsi vald','Viimsi Kaubanduskeskuse pakiautomaat','Haabneeme alevik, Randvere tee 6'),(341,'Viimsi vald','Viimsi Pärnamäe Rimi pakiautomaat','Laiaküla, Lilleoru tee 4'),(342,'Viimsi vald','Viimsi Rimi pakiautomaat','Haabneeme alevik, Randvere tee 9'),(343,'Viljandi linn','Viljandi Bussijaama pakiautomaat','Ilmarise tn 1'),(344,'Viljandi linn','Viljandi Coop Maksimarketi pakiautomaat','Lääne tn 2'),(345,'Viljandi linn','Viljandi Kaare Meie kaupluse pakiautomaat','Suur-Kaare tn 68'),(346,'Viljandi linn','Viljandi Männimäe Maksimarketi pakiautomaat','Puidu tn 2'),(347,'Viljandi linn','Viljandi Männimäe Selveri pakiautomaat','Riia mnt 35'),(348,'Viljandi linn','Viljandi Tallinna 60 Maxima X pakiautomaat','Tallinna tn 60'),(349,'Viljandi linn','Viljandi Vaksali Maxima X pakiautomaat','Vaksali tn 11b'),(350,'Viljandi vald','Kolga-Jaani pakiautomaat','Kolga-Jaani alevik, Viljandi mnt 6'),(351,'Viljandi vald','Mustla Coop Konsumi pakiautomaat','Mustla alevik, Posti tn 52a'),(352,'Viljandi vald','Ramsi Coop kaupluse pakiautomaat','Ramsi alevik, Keskuse tee 1'),(353,'Viljandi vald','Viiratsi pakiautomaat','Viiratsi alevik, Tiigi tn 4'),(354,'Vinni vald','Laekvere pakiautomaat','Laekvere alevik, Salutaguse tee 2'),(355,'Vinni vald','Roela pakiautomaat','Roela alevik, Sinilille tn 1a'),(356,'Vinni vald','Vinni Spordikompleksi pakiautomaat','Vinni alevik, Sõpruse tn 16'),(357,'Viru-Nigula vald','Aseri Grossi pakiautomaat','Aseri alevik, Tehase tn 23'),(358,'Viru-Nigula vald','Kunda Grossi pakiautomaat','Kunda linn, Kasemäe tn 12'),(359,'Viru-Nigula vald','Viru-Nigula pakiautomaat','Viru-Nigula alevik, Kirikaia tn 2'),(360,'Vormsi vald','Vormsi pakiväljastus','Hullo küla'),(361,'Võru linn','Võru Coop Maksimarketi pakiautomaat','Jüri tn 83'),(362,'Võru linn','Võru kesklinna Circle K pakiautomaat','Jüri tn 45'),(363,'Võru linn','Võru Maxima XX pakiautomaat','Kooli tn 2'),(364,'Võru vald','Lasva Coop kaupluse pakiautomaat','Lasva küla, Pässä põik 6'),(365,'Võru vald','Orava pakiautomaat','Orava küla'),(366,'Võru vald','Vastseliina Coop Konsumi pakiautomaat','Vastseliina alevik, Võidu tn 21'); UNLOCK TABLES; DROP TABLE IF EXISTS `admin_account_logs`; CREATE TABLE `admin_account_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `entered_password` varchar(255) NOT NULL, `action` varchar(50) NOT NULL, `ip_address` varchar(255) NOT NULL, `device_whole_device` varchar(255) DEFAULT NULL, `device_only_device` varchar(100) DEFAULT NULL, `is_current_login` varchar(60) DEFAULT NULL, `is_first_login` varchar(60) DEFAULT NULL, `created_at` datetime DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `user_id` (`user_id`), CONSTRAINT `admin_account_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `admin_account_logs` WRITE; INSERT INTO `admin_account_logs` VALUES (1,1,'admin5810','login_success','2a00:807:e1:dd5d:9561:2db5:f4b1:fae7','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36','Windows 10.0.0','2024-10-29T20:23:05.424Z',NULL,'2024-10-29 22:23:05'),(2,1,'admin5810','login_success','2a00:807:e1:dd5d:9561:2db5:f4b1:fae7','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36','Windows 10.0.0','2024-10-30T00:41:56.048Z','0','2024-10-30 02:41:56'),(3,1,'admin5810','login_success','2a00:807:e1:dd5d:ac18:4736:ac45:996d','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36','Windows 10.0.0','2024-11-09T13:17:25.774Z','0','2024-11-09 15:17:25'),(4,1,'admin5810','login_success','2a00:807:e1:dd5d:58a0:2914:927f:3707','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','Windows 10.0.0','2024-11-16T01:45:10.387Z','0','2024-11-16 03:45:10'); UNLOCK TABLES; DROP TABLE IF EXISTS `admin_password_reset_tokens`; CREATE TABLE `admin_password_reset_tokens` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `reset_token` varchar(255) NOT NULL, `expires_at` datetime NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `user_id` (`user_id`), CONSTRAINT `admin_password_reset_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `admin_password_reset_tokens` WRITE; UNLOCK TABLES; DROP TABLE IF EXISTS `admin_sender_info`; CREATE TABLE `admin_sender_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `senderName` varchar(255) DEFAULT NULL, `senderEmail` varchar(255) DEFAULT NULL, `senderPhone` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `admin_sender_info` WRITE; INSERT INTO `admin_sender_info` VALUES (1,'@omniva_track_bot','omniva_track_bot@coonlink.fun','51234567'); UNLOCK TABLES; DROP TABLE IF EXISTS `admin_users`; CREATE TABLE `admin_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `telegram_chat_id` int(11) DEFAULT NULL, `role` enum('admin','righthand','newbies') DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `session_secret` varchar(255) DEFAULT NULL, `first_name` text NOT NULL, `last_name` text NOT NULL, `bananas_island` enum('temporary_ban','permanent_ban') DEFAULT NULL, `ip_address` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `admin_users` WRITE; INSERT INTO `admin_users` VALUES (1,1,782821990,'admin','$2b$10$qH.qXocRFk/WUF64.A8qxOywPRBVODAPvJtATfHPCqtPObHgQak7m','f18edffb998fc7df4922684ac2ccf4d751f495b21376a751a9646c1ca9b72547','Alberto','Clemente',NULL,'91.129.101.93, 2a00:807:e1:dd5d:d9f1:bc50:8118:2973','2024-10-28 20:05:21','2024-11-22 06:58:42'); UNLOCK TABLES; DROP TABLE IF EXISTS `apps_translations`; CREATE TABLE `apps_translations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `language` varchar(5) DEFAULT NULL, `key` varchar(255) DEFAULT NULL, `message` varchar(9000) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `apps_translations` WRITE; INSERT INTO `apps_translations` VALUES (1,'en','welcome','Welcome to the Omniva app!','2024-11-01 20:50:39','2024-11-01 20:50:39'),(2,'ru','welcome','Добро пожаловать в приложение Omniva!','2024-11-01 20:50:39','2024-11-01 20:50:39'),(3,'et','welcome','Tere tulemast Omniva rakendusse!','2024-11-01 20:50:39','2024-11-01 20:50:39'),(4,'en','footer_creator','Creator by','2024-11-02 00:23:19','2024-11-02 00:23:19'),(5,'ru','footer_creator','Создатель','2024-11-02 00:23:19','2024-11-02 00:23:19'),(6,'et','footer_creator','Looja','2024-11-02 00:23:33','2024-11-02 00:23:33'),(7,'en','welcome_description','text','2024-11-02 03:02:10','2024-11-02 03:03:45'),(8,'ru','welcome_description','text','2024-11-02 03:02:10','2024-11-02 03:03:47'),(9,'et','welcome_description','text','2024-11-02 03:02:17','2024-11-02 03:03:49'),(10,'en','button_home_navigation','Dashboard','2024-11-02 03:22:26','2024-11-04 01:02:31'),(11,'ru','button_home_navigation','Рабочий стол','2024-11-02 03:22:26','2024-11-04 01:02:35'),(12,'et','button_home_navigation','Töölaud','2024-11-02 03:23:31','2024-11-04 01:02:38'),(13,'en','top_banner_home_page','Dashboard','2024-11-02 03:38:30','2024-11-05 03:06:10'),(14,'ru','top_banner_home_page','Рабочий стол','2024-11-02 03:38:30','2024-11-05 03:06:12'),(15,'et','top_banner_home_page','Töölaud','2024-11-02 03:38:52','2024-11-05 03:06:15'),(16,'en','button_track_navigation','Shipments','2024-11-04 00:52:03','2024-11-04 01:01:05'),(17,'ru','button_track_navigation','Посылки','2024-11-04 00:52:03','2024-11-04 01:01:08'),(18,'et','button_track_navigation','Saadetised','2024-11-04 00:52:51','2024-11-04 01:01:14'),(19,'en','button_send_navigation','Send','2024-11-04 00:59:01','2024-11-04 01:01:17'),(20,'ru','button_send_navigation','Отправить','2024-11-04 00:59:01','2024-11-04 01:01:20'),(21,'et','button_send_navigation','Saada','2024-11-04 01:03:30','2024-11-04 01:03:30'),(22,'en','button_profile_navigation','Profile','2024-11-04 01:04:49','2024-11-04 01:04:49'),(23,'ru','button_profile_navigation','Профиль','2024-11-04 01:04:49','2024-11-04 01:04:49'),(24,'et','button_profile_navigation','Profiil','2024-11-04 01:05:18','2024-11-04 01:05:18'),(25,'en','button_notifications_navigation','Notifications','2024-11-04 01:07:34','2024-11-04 01:07:34'),(26,'ru','button_notifications_navigation','Пакет СМС','2024-11-04 01:07:34','2024-11-05 03:24:40'),(27,'et','button_notifications_navigation','Teavitused','2024-11-04 01:08:07','2024-11-04 01:08:07'),(28,'en','button_send_home','Send parcel','2024-11-04 01:13:14','2024-11-04 01:13:14'),(29,'ru','button_send_home','Отправь посылку','2024-11-04 01:13:14','2024-11-04 01:13:14'),(30,'et','button_send_home','Saada pakk','2024-11-04 01:14:08','2024-11-04 01:14:08'),(31,'en','button_track_home','Track shipments','2024-11-04 01:17:28','2024-11-04 01:17:28'),(32,'ru','button_track_home','Отслеживание посылок','2024-11-04 01:17:28','2024-11-04 01:17:28'),(33,'et','button_track_home','Jälgi saadetisi','2024-11-04 01:18:28','2024-11-04 01:18:28'),(34,'en','button_packomat_home','Ready for Pickup','2024-11-04 01:22:30','2024-11-04 01:22:30'),(35,'ru','button_packomat_home','Готово к выдаче','2024-11-04 01:22:30','2024-11-04 01:22:30'),(36,'et','button_packomat_home','Valmis väljastamiseks','2024-11-04 01:22:45','2024-11-04 01:22:45'),(37,'en','button_car_home','Parcels in Transit','2024-11-04 01:26:33','2024-11-04 01:26:33'),(38,'ru','button_car_home','Посылки в пути','2024-11-04 01:26:33','2024-11-04 01:26:33'),(39,'et','button_car_home','Teel olevad pakid','2024-11-04 01:26:47','2024-11-04 01:26:47'),(40,'en','top_banner_track_page','-','2024-11-05 03:07:11','2024-11-05 03:07:11'),(41,'ru','top_banner_track_page','-','2024-11-05 03:07:11','2024-11-05 03:07:11'),(42,'et','top_banner_track_page','-','2024-11-05 03:07:18','2024-11-05 03:07:18'),(43,'en','top_banner_notifications_page','-','2024-11-05 03:08:07','2024-11-05 03:08:07'),(44,'ru','top_banner_notifications_page','-','2024-11-05 03:08:07','2024-11-05 03:08:07'),(45,'et','top_banner_notifications_page','-','2024-11-05 03:08:15','2024-11-05 03:08:15'); UNLOCK TABLES; DROP TABLE IF EXISTS `apps_users`; CREATE TABLE `apps_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `apps_users` WRITE; UNLOCK TABLES; DROP TABLE IF EXISTS `ban_reasons`; CREATE TABLE `ban_reasons` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `ban_status` enum('temporary_ban','permanent_ban') NOT NULL, `reason` varchar(255) NOT NULL, `created_at` datetime DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `user_id` (`user_id`), CONSTRAINT `ban_reasons_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `ban_reasons` WRITE; INSERT INTO `ban_reasons` VALUES (3,1347982128,'permanent_ban','Вы нарушили правило 6.1 — правило поддержки, касающееся оскорблений. Просим вас соблюдать нормы уважительного общения.','2024-10-29 16:25:36'); UNLOCK TABLES; DELIMITER ;; DELIMITER ; DELIMITER ;; DELIMITER ; DELIMITER ;; DELIMITER ; DELIMITER ;; DELIMITER ; DELIMITER ;; DELIMITER ; DELIMITER ;; DELIMITER ; DROP TABLE IF EXISTS `changelog`; CREATE TABLE `changelog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `version` varchar(50) NOT NULL, `date` date NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL, `image_url` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `changelog` WRITE; INSERT INTO `changelog` VALUES (1,'Version 1.2.0','2024-11-05','Style Guide Builder Beta, Portfolio Sections, GPT Prompt Builder & More','This month, we\'re excited to launch the Beta of the Style Guide Builder, introduce 6 new Uncommon Portfolio Sections, unveil a ChatGPT-Powered Prompt Builder, and expand our React Library.','https://cdn.prod.website-files.com/61789b489343c8242282a0ae/67297b6f1815199f3e259787_Nov%20Component%20Day%20(1).png'); UNLOCK TABLES; DROP TABLE IF EXISTS `chat_export`; CREATE TABLE `chat_export` ( `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `chat_export` WRITE; UNLOCK TABLES; DROP TABLE IF EXISTS `faq_home_page`; CREATE TABLE `faq_home_page` ( `id` int(11) NOT NULL AUTO_INCREMENT, `question` text DEFAULT NULL, `answer` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `faq_home_page` WRITE; INSERT INTO `faq_home_page` VALUES (1,'Why Should I Use the Omniva Chatbot Instead of the Website?','The Omniva Chatbot offers instant access to postal services without needing to open a browser. You can quickly track parcels, locate the nearest post offices, and calculate postage rates — all in a single chat interface. No more clicking through multiple pages; just ask and receive!','2024-11-08 11:19:26','2024-11-08 11:19:26'),(2,'What Are the Benefits of Using a Chatbot for Postal Services?','Convenience is key! You get access to everything from your smartphone without the need for complicated searches. You can check delivery statuses, find opening hours, and get support, all with simple commands.','2024-11-08 11:21:30','2024-11-08 11:21:30'),(3,'Is the Omniva Chatbot Free to Use?','Yes, the bot is completely free to use. There are no hidden charges for using basic features like tracking and finding postal locations.','2024-11-08 11:22:03','2024-11-08 11:22:03'),(4,'Is It Secure to Use the Chatbot for My Parcel Information?','Absolutely. We use secure methods to handle your information, ensuring your data stays safe. You do not need to input sensitive personal information; simply enter your tracking number or ask a general question.','2024-11-08 11:22:03','2024-11-08 11:22:03'),(5,'Can I Use the Bot for Any Postal Inquiry?','Yes, the bot provides answers for almost all general inquiries related to postal services. Whether you need a post office address, operating hours, or the delivery status of your package, the bot has you covered.','2024-11-08 11:22:15','2024-11-08 11:22:15'),(6,'How Quickly Can I Get Updates via the Chatbot?','Real-time updates are a key feature of the Omniva Chatbot. As soon as there\'s an update on your package, you can receive information instantly, rather than having to refresh a page or wait for an email.','2024-11-08 11:22:28','2024-11-08 11:22:28'),(7,'Do I Need an Omniva Account to Use the Chatbot?','No, there is no need for an Omniva account. Just start chatting and access the services you need. The chatbot is here to simplify things, no account is required.','2024-11-08 11:22:41','2024-11-08 11:22:41'),(8,'What Makes the Omniva Chatbot Better Than Other Solutions?','Unlike typical tracking pages or customer service lines, our chatbot is available 24/7, responds immediately, and provides all necessary information in one place. No waiting, no navigating — just results.','2024-11-08 11:22:51','2024-11-08 11:22:51'),(9,'How Do I Get Started?','It\'s simple! Just find the Omniva Chatbot in Telegram and start the conversation. You\'ll receive step-by-step guidance on how to use the different features available.','2024-11-08 11:23:02','2024-11-08 11:23:02'); UNLOCK TABLES; DROP TABLE IF EXISTS `insight_page_views`; CREATE TABLE `insight_page_views` ( `id` int(11) NOT NULL AUTO_INCREMENT, `insight_id` int(11) DEFAULT NULL, `view_date` timestamp NULL DEFAULT current_timestamp(), `ip_address` varchar(45) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `insight_id` (`insight_id`), CONSTRAINT `insight_page_views_ibfk_1` FOREIGN KEY (`insight_id`) REFERENCES `insights_home_page` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `insight_page_views` WRITE; UNLOCK TABLES; DROP TABLE IF EXISTS `insights_home_page`; CREATE TABLE `insights_home_page` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `type` enum('Inspiration','Product','Company') DEFAULT NULL, `publish_date` date DEFAULT NULL, `image_url` varchar(255) DEFAULT NULL, `short_description` varchar(255) DEFAULT NULL, `full_article_url` varchar(255) DEFAULT NULL, `page_views` int(11) DEFAULT 0, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `insights_home_page` WRITE; UNLOCK TABLES; DROP TABLE IF EXISTS `package_prices`; CREATE TABLE `package_prices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `provider` varchar(50) DEFAULT NULL, `size` char(1) DEFAULT NULL, `grossPrice` decimal(10,2) DEFAULT NULL, `vatAmount` decimal(10,2) DEFAULT NULL, `vatPercent` decimal(5,2) DEFAULT NULL, `lastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `created_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `unique_provider_size` (`provider`,`size`) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `package_prices` WRITE; INSERT INTO `package_prices` VALUES (1,'Omniva','S',3.40,0.61,22.00,'2024-11-23 22:00:17','2024-11-23 22:00:17'),(2,'Omniva','M',4.40,0.79,22.00,'2024-11-23 22:00:17','2024-11-23 22:00:17'),(3,'Omniva','L',5.40,0.97,22.00,'2024-11-23 22:00:17','2024-11-23 22:00:17'),(4,'Osta.ee','S',1.39,0.00,0.00,'2024-11-23 22:00:17','2024-11-23 22:00:17'),(5,'Osta.ee','M',1.89,0.00,0.00,'2024-11-23 22:00:17','2024-11-23 22:00:17'),(6,'Osta.ee','L',3.87,0.00,0.00,'2024-11-23 22:00:17','2024-11-23 22:00:17'); UNLOCK TABLES; DROP TABLE IF EXISTS `parcels_archive_30d`; CREATE TABLE `parcels_archive_30d` ( `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `parcels_archive_30d` WRITE; UNLOCK TABLES; DROP TABLE IF EXISTS `receiver_info`; CREATE TABLE `receiver_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sendUrlSizeParcel` varchar(3) DEFAULT NULL, `senderName` varchar(255) DEFAULT NULL, `senderEmail` varchar(255) DEFAULT NULL, `senderPhone` varchar(255) DEFAULT NULL, `sendParcel` int(11) DEFAULT NULL, `consigneeId` int(11) DEFAULT NULL, `notified` int(3) DEFAULT 0, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `receiver_info` WRITE; INSERT INTO `receiver_info` VALUES (1,'s','Test','test@example.com','51234567',254,254,1,'2024-10-31 05:40:30','2024-11-01 03:16:59'); UNLOCK TABLES; DROP TABLE IF EXISTS `sms_packages`; CREATE TABLE `sms_packages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `price` decimal(10,2) DEFAULT 0.00, `star` decimal(10,2) DEFAULT 0.00, `discount` decimal(5,2) DEFAULT 0.00, `pass` enum('ea','month') DEFAULT NULL, `created_at` datetime DEFAULT current_timestamp(), `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `sms_packages` WRITE; INSERT INTO `sms_packages` VALUES (1,'3 SMS',3.00,150.00,0.00,'ea','2024-10-25 06:32:11','2024-11-06 05:16:42'),(2,'5 SMS',4.50,250.00,0.00,'month','2024-10-25 06:32:11','2024-11-06 05:16:49'),(3,'10 SMS',8.50,500.00,0.00,'month','2024-10-25 06:32:38','2024-11-06 05:16:52'),(4,'50 SMS',37.50,2500.00,0.00,'month','2024-10-25 06:32:38','2024-11-06 05:16:55'),(5,'100 SMS',70.00,5000.00,0.00,'month','2024-10-25 06:32:54','2024-11-06 05:16:59'); UNLOCK TABLES; DROP TABLE IF EXISTS `testimonials_home_page`; CREATE TABLE `testimonials_home_page` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `occupation` varchar(100) NOT NULL, `message` text NOT NULL, `image_url` varchar(255) DEFAULT NULL, `publish_date` datetime DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `testimonials_home_page` WRITE; UNLOCK TABLES; DROP TABLE IF EXISTS `tracking`; CREATE TABLE `tracking` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `shipmentBarcode` varchar(255) DEFAULT NULL, `mainService` varchar(255) DEFAULT NULL, `currentDeliveryChannel` varchar(255) DEFAULT NULL, `returningShipment` varchar(255) DEFAULT NULL, `customerReturn` varchar(255) DEFAULT NULL, `customsDeclarationRequired` varchar(255) DEFAULT NULL, `phoenixShipment` varchar(255) DEFAULT NULL, `direction` varchar(255) DEFAULT NULL, `postalNetworkCode` varchar(255) DEFAULT NULL, `inboundNetworkCode` varchar(255) DEFAULT NULL, `registrationChannelTypeCode` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT current_timestamp(), `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `tracking` WRITE; INSERT INTO `tracking` VALUES (1,782821990,'CC527038025EE','PARCEL','PARCEL_MACHINE','0','0','0','1','TRANSIT','OMNIVA','OMNIVA','OMX','2024-10-20 04:23:25','2024-10-20 04:23:25'),(2,782821990,'UQ447759660DE','PARCEL',NULL,'0','0','0','1','INBOUND','OMNIVA','UPU_LETTER','INS','2024-10-20 04:54:37','2024-10-20 04:54:37'),(3,5392413644,'RL525224864EE','PARCEL',NULL,'0','0','0','1','INBOUND','UPU_LETTER','NON_EU_CARGO','OCT','2024-10-22 01:34:45','2024-10-22 01:34:45'),(4,5924307463,'RL526838930EE','PARCEL',NULL,'0','0','0','1','INBOUND','UPU_LETTER','NON_EU_CARGO','OCT','2024-10-24 12:31:57','2024-10-24 12:31:57'),(5,782821990,'1','PARCEL','COURIER','0','0','0','0','TRANSIT','OMNIVA','OMNIVA','OMG-CR','2024-10-25 02:13:56','2024-10-29 05:52:59'),(6,681786243,'RL530203323EE','PARCEL',NULL,'0','0','0','1','INBOUND','UPU_LETTER','NON_EU_CARGO','OCT','2024-10-25 15:34:26','2024-10-25 15:34:26'),(8,6033552306,'RL529750534EE','PARCEL',NULL,'0','0','0','1','INBOUND','UPU_LETTER','NON_EU_CARGO','OCT','2024-10-25 16:19:20','2024-10-25 16:19:20'),(9,1448631857,'RL529828154EE','PARCEL',NULL,'0','0','0','1','INBOUND','UPU_LETTER','NON_EU_CARGO','OCT','2024-10-27 08:35:04','2024-10-27 08:35:04'),(10,5021809923,'RL527666431EE','PARCEL',NULL,'0','0','0','1','INBOUND','UPU_LETTER','NON_EU_CARGO','OCT','2024-10-28 13:39:04','2024-10-28 13:39:04'),(12,5745970528,'1','PARCEL','COURIER','0','0','0','0','TRANSIT','OMNIVA','OMNIVA','OMG-CR','2024-10-31 23:54:24','2024-10-31 23:54:24'),(13,782821990,'5','PARCEL','COURIER','0','0','0','1','TRANSIT','OMNIVA','OMNIVA','OMG-CR','2024-11-07 05:05:12','2024-11-07 05:05:12'),(35,892984982,'CC649333950EE','PARCEL','PARCEL_MACHINE','0','0','0','1','TRANSIT','OMNIVA','OMNIVA','OMX','2024-11-23 13:42:07','2024-11-23 13:42:07'); UNLOCK TABLES; DROP TABLE IF EXISTS `tracking_deliveryLocation`; CREATE TABLE `tracking_deliveryLocation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shipmentBarcode` varchar(255) DEFAULT NULL, `zip` varchar(255) DEFAULT NULL, `locationName` varchar(255) DEFAULT NULL, `servicePointTypeCode` varchar(255) DEFAULT NULL, `countryCode` varchar(255) DEFAULT NULL, `translations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `tracking_deliveryLocation` WRITE; INSERT INTO `tracking_deliveryLocation` VALUES (1,'CC527038025EE','96103','Tallinna Õismäe Maxima XX pakiautomaat','PARCEL_MACHINE','EE','{}','2024-10-20 01:23:25','2024-10-20 01:23:25'),(2,'UQ447759660DE',NULL,NULL,NULL,NULL,NULL,'2024-10-20 01:54:37','2024-10-20 01:54:37'),(3,'RL525224864EE',NULL,NULL,NULL,NULL,NULL,'2024-10-21 22:34:45','2024-10-21 22:34:45'),(4,'RL526838930EE',NULL,NULL,NULL,NULL,NULL,'2024-10-24 09:31:57','2024-10-24 09:31:57'),(5,'CC649333950EE','9984','Krāslavas Maxima X pakomāts','PARCEL_MACHINE','LV','{}','2024-11-23 11:42:07','2024-11-23 11:42:07'); UNLOCK TABLES; DROP TABLE IF EXISTS `tracking_dimensions`; CREATE TABLE `tracking_dimensions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shipmentBarcode` varchar(255) DEFAULT NULL, `measurementType` varchar(255) DEFAULT NULL, `width` varchar(255) DEFAULT NULL, `height` varchar(255) DEFAULT NULL, `depth` varchar(255) DEFAULT NULL, `weight` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `tracking_dimensions` WRITE; INSERT INTO `tracking_dimensions` VALUES (1,'CC527038025EE',NULL,NULL,NULL,NULL,NULL,'2024-10-20 01:23:25','2024-10-20 01:23:25'),(2,'UQ447759660DE',NULL,NULL,NULL,NULL,NULL,'2024-10-20 01:54:37','2024-10-20 01:54:37'),(3,'RL525224864EE','HAND_MEASURED',NULL,NULL,NULL,'1749','2024-10-21 22:34:45','2024-10-21 22:34:45'),(4,'RL526838930EE','HAND_MEASURED',NULL,NULL,NULL,'2672','2024-10-24 09:31:57','2024-10-24 09:31:57'),(5,'1','SORTING_LINE_MEASURED','282','140','184','1750','2024-10-24 23:13:56','2024-10-24 23:13:56'),(6,'RL530203323EE','HAND_MEASURED',NULL,NULL,NULL,'963','2024-10-25 12:34:26','2024-10-25 12:34:26'),(8,'RL529750534EE','HAND_MEASURED',NULL,NULL,NULL,'2245','2024-10-25 13:19:20','2024-10-25 13:19:20'),(9,'RL529828154EE','HAND_MEASURED',NULL,NULL,NULL,'1056','2024-10-27 06:35:04','2024-10-27 06:35:04'),(10,'RL527666431EE','HAND_MEASURED',NULL,NULL,NULL,'110','2024-10-28 11:39:04','2024-10-28 11:39:04'),(12,'1','SORTING_LINE_MEASURED','282','140','184','1750','2024-10-31 21:54:24','2024-10-31 21:54:24'),(13,'5','SORTING_LINE_MEASURED','595','210','273','3080','2024-11-07 03:05:12','2024-11-07 03:05:12'),(14,'CC649333950EE','HAND_MEASURED','380','390','640','10000','2024-11-23 11:42:07','2024-11-23 11:42:07'); UNLOCK TABLES; DROP TABLE IF EXISTS `tracking_events`; CREATE TABLE `tracking_events` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shipmentBarcode` varchar(255) NOT NULL, `eventId` bigint(20) DEFAULT NULL, `eventCode` varchar(255) DEFAULT NULL, `eventName` varchar(255) DEFAULT NULL, `eventDate` datetime DEFAULT NULL, `zip` varchar(255) DEFAULT NULL, `locationName` varchar(255) DEFAULT NULL, `servicePointTypeCode` varchar(255) DEFAULT NULL, `countryCode` varchar(255) DEFAULT NULL, `translations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`translations`)), `created_at` datetime DEFAULT current_timestamp(), `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=284 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `tracking_events` WRITE; INSERT INTO `tracking_events` VALUES (1,'CC527038025EE',668914906,'TRT_SHIPMENT_REGISTERED','Shipment registered. Shipment has not been handed over to Omniva','2024-04-25 08:16:07',NULL,NULL,NULL,NULL,NULL,'2024-10-20 04:23:25','2024-10-20 04:23:25'),(2,'UQ447759660DE',737733000,'TRT_SHIPMENT_EMA','Item is posted by the sender/collected by the Post','2024-07-06 08:34:00',NULL,NULL,NULL,NULL,NULL,'2024-10-20 04:54:37','2024-10-20 04:54:37'),(3,'RL525224864EE',853311589,'TRT_SHIPMENT_EMA','Item is posted by the sender/collected by the Post','2024-10-16 09:00:00',NULL,NULL,NULL,NULL,NULL,'2024-10-22 01:34:45','2024-10-22 01:34:45'),(4,'RL525224864EE',853315017,'TRT_SHIPMENT_EMB','Arrival at outward Office of Exchange','2024-10-16 09:06:00',NULL,NULL,NULL,NULL,NULL,'2024-10-22 01:34:45','2024-10-22 01:34:45'),(5,'RL525224864EE',853266180,'CARGO_SHIPMENT_HANDOVER_FROM_LINEHAUL_EVENT','Shipment handover from linehaul','2024-10-16 09:41:00',NULL,NULL,NULL,NULL,NULL,'2024-10-22 01:34:45','2024-10-22 01:34:45'),(6,'RL525224864EE',853320668,'TRT_SHIPMENT_EMC','Shipment is on the way to the destination country','2024-10-16 09:43:00',NULL,NULL,NULL,NULL,NULL,'2024-10-22 01:34:45','2024-10-22 01:34:45'),(7,'RL525224864EE',858526217,'CARGO_SHIPMENT_IN_TRANSIT_TO_DESTINATION_COUNTRY','Shipment in transit to destination country','2024-10-20 11:10:51',NULL,NULL,NULL,NULL,NULL,'2024-10-22 01:34:45','2024-10-22 01:34:45'),(8,'RL525224864EE',859867639,'TRT_SHIPMENT_EMD','Arrival to destination country','2024-10-21 07:12:00',NULL,NULL,NULL,NULL,NULL,'2024-10-22 01:34:45','2024-10-22 01:34:45'),(9,'RL525224864EE',859873457,'TRT_SHIPMENT_EDB','Shipment presented to customs','2024-10-21 07:27:00',NULL,NULL,NULL,NULL,NULL,'2024-10-22 01:34:45','2024-10-22 01:34:45'),(10,'RL525224864EE',859877410,'TRT_SHIPMENT_EDC','Shipment released from customs','2024-10-21 07:42:00',NULL,NULL,NULL,NULL,NULL,'2024-10-22 01:34:45','2024-10-22 01:34:45'),(11,'RL525224864EE',859886891,'TRT_SHIPMENT_EMF','Departure from inward Office of Exchange','2024-10-21 07:57:00',NULL,NULL,NULL,NULL,NULL,'2024-10-22 01:34:45','2024-10-22 01:34:45'),(12,'RL526838930EE',863770909,'TRT_SHIPMENT_EMA','Item is posted by the sender/collected by the Post','2024-10-23 12:36:00',NULL,NULL,NULL,NULL,NULL,'2024-10-24 12:31:57','2024-10-24 12:31:57'),(13,'RL526838930EE',863777417,'TRT_SHIPMENT_EMB','Arrival at outward Office of Exchange','2024-10-23 12:42:00',NULL,NULL,NULL,NULL,NULL,'2024-10-24 12:31:57','2024-10-24 12:31:57'),(14,'RL526838930EE',863731018,'CARGO_SHIPMENT_HANDOVER_FROM_LINEHAUL_EVENT','Shipment handover from linehaul','2024-10-23 13:16:00',NULL,NULL,NULL,NULL,NULL,'2024-10-24 12:31:57','2024-10-24 12:31:57'),(15,'RL526838930EE',863783858,'TRT_SHIPMENT_EMC','Shipment is on the way to the destination country','2024-10-23 13:19:00',NULL,NULL,NULL,NULL,NULL,'2024-10-24 12:31:57','2024-10-24 12:31:57'),(16,'1',82995182,'TRT_SHIPMENT_PICKED_UP_BY_COURIER','The courier has picked up the shipment','2022-05-30 06:43:55',NULL,NULL,NULL,NULL,NULL,'2024-10-25 02:13:56','2024-10-25 02:13:56'),(17,'1',82995180,'TRT_SHIPMENT_REGISTERED','Shipment registered. Shipment has not been handed over to Omniva','2022-05-30 06:43:59',NULL,NULL,NULL,NULL,NULL,'2024-10-25 02:13:56','2024-10-25 02:13:56'),(18,'1',103739699,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-06-28 15:08:16','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(19,'1',123893753,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-07-25 23:41:11','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(20,'1',127038233,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-07-29 07:18:02','65623','Võru jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(21,'1',134067610,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-08-08 23:11:28','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(22,'1',150147094,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-08-31 19:34:08','99999','Kaunas terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1346,\"name\":\"Kauno terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(23,'1',169275130,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-09-26 20:30:31','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(24,'1',179154165,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-10 15:26:59','99981','Vilnius sorting zone 1','WORKSTATION','LT','{\"lv\":{\"id\":1326,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1323,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1324,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1322,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1325,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(25,'1',179436906,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-10 23:25:24','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(26,'1',181299786,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-12 18:41:07','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(27,'1',185060016,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-17 20:22:28','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(28,'1',188900148,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-21 14:37:57','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(29,'1',188967280,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-21 16:09:46','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(30,'1',190526057,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-24 18:35:01','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(31,'1',194610336,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-28 18:58:23','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(32,'1',196428157,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-01 03:25:17','99996','Klaipėda terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1345,\"name\":\"Klaipėdos terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(33,'1',199825833,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-05 02:26:40','99995','Šiauliai terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1337,\"name\":\"Šiaulių terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(34,'1',200772811,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 11:22:23','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(35,'1',201317849,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 20:07:36','14026','Logistikakeskuse terminal','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(36,'1',201338312,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 20:38:00','14069','Liinisorteerimine','WORKSTATION','EE','{\"lv\":{\"id\":1344,\"name\":\"Sutījumu šķirošanas centrs Igaunijā\"},\"et\":{\"id\":1341,\"name\":\"Eesti Pakisorteerimise keskus\"},\"ru\":{\"id\":1342,\"name\":\"Центр сортировки посылок Эстонии\"},\"en\":{\"id\":1340,\"name\":\"Estonian parcel sorting center\"},\"lt\":{\"id\":1343,\"name\":\"Siuntų rūšiavimo centras Estijoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(37,'1',201421037,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 23:01:20','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(38,'1',202477745,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-08 19:44:05','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(39,'1',206667649,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-12 15:44:51','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(40,'1',207663428,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-14 14:00:59','79533','Rapla jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(41,'1',207924462,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-14 17:37:42','99981','Vilnius sorting zone 1','WORKSTATION','LT','{\"lv\":{\"id\":1326,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1323,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1324,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1322,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1325,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(42,'1',207959592,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-14 18:11:36','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(43,'1',208294866,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-15 02:48:51','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(44,'1',208446438,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-15 07:00:37','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(45,'1',211429219,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-17 14:31:46','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(46,'1',211590173,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-17 16:15:14','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(47,'1',212029140,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-18 04:16:24','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(48,'1',212131798,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-18 07:21:32','65614','Võru kullerpunkt','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(49,'1',214817318,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-21 21:00:54','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(50,'1',214871931,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-21 22:26:24','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(51,'1',216059788,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-23 04:52:46','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(52,'1',219121781,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-25 19:57:42','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(53,'1',220228818,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-28 04:20:37','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(54,'1',220956413,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-28 16:11:15','99981','Vilnius sorting zone 1','WORKSTATION','LT','{\"lv\":{\"id\":1326,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1323,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1324,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1322,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1325,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(55,'1',226819404,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-05 07:59:12','10103','Tallinna jaotuspunkt','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(56,'1',227680232,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-05 22:06:37','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(57,'1',228546885,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-06 16:34:32','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(58,'1',231059861,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-08 22:45:56','14036','Tallinna kullerpunkt','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(59,'1',231857480,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-09 16:03:45','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(60,'1',232381152,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-10 11:36:44','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(61,'1',232910813,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-11 23:45:44','01017','Riga Sorting line','WORKSTATION','LV','{\"lv\":{\"id\":1255,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1257,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1259,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1256,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1258,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(62,'1',235016806,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-14 03:50:21','99995','Šiauliai terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1337,\"name\":\"Šiaulių terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(63,'1',236130275,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-14 20:08:03','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(64,'1',240420447,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-19 22:10:08','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(65,'1',240420450,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-19 22:10:10','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(66,'1',241648738,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-21 03:43:05','80101','Pärnu jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(67,'1',246236362,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-27 22:32:18','01026','Marupe Manual Sorting 1','WORKSTATION','LV','{\"lv\":{\"id\":1279,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1276,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1277,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1275,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1278,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(68,'1',246236364,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-27 22:32:19','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(69,'1',248975865,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-30 20:09:09','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(70,'1',256182676,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-11 04:43:10','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(71,'1',256849999,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-11 15:06:13','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(72,'1',261546793,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-18 01:47:39','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(73,'1',263496250,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-19 19:21:37','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(74,'1',264536266,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-20 22:05:49','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(75,'1',264536271,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-20 22:05:51','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(76,'1',266906846,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-24 17:48:05','99986','Vilnius China Sorting Zone 1','WORKSTATION','LT','{\"lv\":{\"id\":1098,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1095,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1096,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1094,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1097,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(77,'1',294373222,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-03-03 04:16:35','99995','Šiauliai terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1337,\"name\":\"Šiaulių terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(78,'1',295062590,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-03-03 15:39:54','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(79,'1',296903819,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-03-06 19:39:30','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(80,'1',298998525,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-03-08 20:07:06','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(81,'1',306360747,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-03-17 21:44:24','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(82,'1',322257388,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-04-06 12:07:02','14062','Liini järelsorteerimine','WORKSTATION','EE','{\"lv\":{\"id\":1224,\"name\":\"Sutījumu šķirošanas centrs Igaunijā\"},\"et\":{\"id\":1221,\"name\":\"Eesti Pakisorteerimise keskus\"},\"ru\":{\"id\":1222,\"name\":\"Центр сортировки посылок Эстонии\"},\"en\":{\"id\":1220,\"name\":\"Estonian parcel sorting center\"},\"lt\":{\"id\":1223,\"name\":\"Siuntų rūšiavimo centras Estijoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(83,'1',330213654,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-04-17 21:58:18','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(84,'1',346577988,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-07 21:18:45','01029','Marupe Manual Sorting 3','WORKSTATION','LV','{\"lv\":{\"id\":1294,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1291,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1292,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1290,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1293,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(85,'1',348555191,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-09 19:55:13','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(86,'1',359466574,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-22 21:52:35','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(87,'1',362689365,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-26 02:13:15','79533','Rapla jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(88,'1',365188487,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-29 21:51:22','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(89,'1',376409860,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-12 14:01:50','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(90,'1',381038387,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-16 19:27:02','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(91,'1',383695318,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-20 14:47:34','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(92,'1',388315453,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-26 19:18:26','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(93,'1',388321702,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-26 19:29:24','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(94,'1',404771748,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-07-15 03:20:55','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(95,'1',406213816,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-07-17 14:44:47','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(96,'1',437369264,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-08-21 19:15:06','01017','Riga Sorting line','WORKSTATION','LV','{\"lv\":{\"id\":1255,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1257,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1259,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1256,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1258,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(97,'1',453363839,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-09-07 15:24:54','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(98,'1',463989192,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-09-19 20:57:17','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(99,'1',471130627,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-09-27 18:33:26','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(100,'1',475472784,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-10-03 16:37:47','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(101,'1',490176464,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-10-19 13:45:42','01033','Riga Sorting line 2','WORKSTATION','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(102,'1',534415595,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-12-04 15:16:25','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(103,'1',534766128,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-12-04 22:48:31','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(104,'1',563240410,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-01-02 21:39:11','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(105,'1',574101166,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-01-13 01:08:32','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(106,'1',606237055,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-02-20 06:38:53','99984','Kaunas sorting line','WORKSTATION','LT','{\"lv\":{\"id\":1361,\"name\":\"Kauņas šķirošanas centrs\"},\"et\":{\"id\":1358,\"name\":\"Kaunase sorteerimiskeskus\"},\"ru\":{\"id\":1359,\"name\":\"Сортировочный центр Каунаса\"},\"en\":{\"id\":1357,\"name\":\"Kaunas sorting center\"},\"lt\":{\"id\":1360,\"name\":\"Siuntų skirstymo terminalas Kaune\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(107,'1',607088656,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-02-20 22:48:12','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(108,'1',615066473,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-01 16:54:04','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(109,'1',615757768,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-03 20:52:35','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(110,'1',625380661,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-14 17:39:32','99992','Kaunas manual sorting','WORKSTATION','LT','{\"lv\":{\"id\":1351,\"name\":\"Kauņas šķirošanas centrs\"},\"et\":{\"id\":1348,\"name\":\"Kaunase sorteerimiskeskus\"},\"ru\":{\"id\":1349,\"name\":\"Сортировочный центр Каунаса\"},\"en\":{\"id\":1347,\"name\":\"Kaunas sorting center\"},\"lt\":{\"id\":1350,\"name\":\"Siuntų skirstymo terminalas Kaune\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(111,'1',625498601,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-14 20:25:30','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(112,'1',628463106,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-18 17:31:55','01024','Riga Terminal H','WORKSTATION','LV','{\"lv\":{\"id\":1063,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1060,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1061,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1059,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1062,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(113,'1',628627424,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-18 22:18:12','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(114,'1',676178028,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-02 18:43:44','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(115,'1',680622144,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-07 23:51:56','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(116,'1',686536383,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-13 17:14:39','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(117,'1',704598073,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-31 08:43:28','14075','Tolliterminali ooteala','WORKSTATION','EE','{\"lv\":{\"id\":1025,\"name\":\"Omniva muitas terminālis Igaunijā\"},\"et\":{\"id\":1028,\"name\":\"Eesti Omniva tolliterminal\"},\"ru\":{\"id\":1027,\"name\":\"Таможенный терминал Omniva Эстонии\"},\"en\":{\"id\":1024,\"name\":\"Estonian Omniva customs terminal\"},\"lt\":{\"id\":1026,\"name\":\"Omniva muitinės terminalas Estijoje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(118,'1',707834028,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-04 14:03:36','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(119,'1',709102709,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-05 14:58:13','01033','Riga Sorting line 2','WORKSTATION','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(120,'1',711342617,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-07 13:55:18','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(121,'1',716733283,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-13 20:18:13','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(122,'1',717684281,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-14 15:46:41','99993','Kaunas sorting line','WORKSTATION','LT','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(123,'1',720472076,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-18 16:09:26','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(124,'1',721512677,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-19 14:23:15','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-25 02:13:56','2024-10-25 02:13:56'),(125,'1',82995182,'TRT_SHIPMENT_PICKED_UP_BY_COURIER','The courier has picked up the shipment','2022-05-30 06:43:55',NULL,NULL,NULL,NULL,NULL,'2024-10-31 23:54:24','2024-10-31 23:54:24'),(126,'1',82995180,'TRT_SHIPMENT_REGISTERED','Shipment registered. Shipment has not been handed over to Omniva','2022-05-30 06:43:59',NULL,NULL,NULL,NULL,NULL,'2024-10-31 23:54:24','2024-10-31 23:54:24'),(127,'1',103739699,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-06-28 15:08:16','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(128,'1',123893753,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-07-25 23:41:11','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(129,'1',127038233,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-07-29 07:18:02','65623','Võru jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(130,'1',134067610,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-08-08 23:11:28','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(131,'1',150147094,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-08-31 19:34:08','99999','Kaunas terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1346,\"name\":\"Kauno terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(132,'1',169275130,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-09-26 20:30:31','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(133,'1',179154165,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-10 15:26:59','99981','Vilnius sorting zone 1','WORKSTATION','LT','{\"lv\":{\"id\":1326,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1323,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1324,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1322,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1325,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(134,'1',179436906,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-10 23:25:24','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(135,'1',181299786,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-12 18:41:07','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(136,'1',185060016,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-17 20:22:28','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(137,'1',188900148,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-21 14:37:57','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(138,'1',188967280,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-21 16:09:46','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(139,'1',190526057,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-24 18:35:01','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(140,'1',194610336,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-28 18:58:23','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(141,'1',196428157,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-01 03:25:17','99996','Klaipėda terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1345,\"name\":\"Klaipėdos terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(142,'1',199825833,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-05 02:26:40','99995','Šiauliai terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1337,\"name\":\"Šiaulių terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(143,'1',200772811,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 11:22:23','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(144,'1',201317849,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 20:07:36','14026','Logistikakeskuse terminal','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(145,'1',201338312,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 20:38:00','14069','Liinisorteerimine','WORKSTATION','EE','{\"lv\":{\"id\":1344,\"name\":\"Sutījumu šķirošanas centrs Igaunijā\"},\"et\":{\"id\":1341,\"name\":\"Eesti Pakisorteerimise keskus\"},\"ru\":{\"id\":1342,\"name\":\"Центр сортировки посылок Эстонии\"},\"en\":{\"id\":1340,\"name\":\"Estonian parcel sorting center\"},\"lt\":{\"id\":1343,\"name\":\"Siuntų rūšiavimo centras Estijoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(146,'1',201421037,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 23:01:20','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(147,'1',202477745,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-08 19:44:05','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(148,'1',206667649,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-12 15:44:51','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(149,'1',207663428,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-14 14:00:59','79533','Rapla jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(150,'1',207924462,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-14 17:37:42','99981','Vilnius sorting zone 1','WORKSTATION','LT','{\"lv\":{\"id\":1326,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1323,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1324,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1322,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1325,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(151,'1',207959592,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-14 18:11:36','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(152,'1',208294866,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-15 02:48:51','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(153,'1',208446438,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-15 07:00:37','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(154,'1',211429219,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-17 14:31:46','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(155,'1',211590173,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-17 16:15:14','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(156,'1',212029140,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-18 04:16:24','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(157,'1',212131798,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-18 07:21:32','65614','Võru kullerpunkt','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(158,'1',214817318,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-21 21:00:54','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(159,'1',214871931,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-21 22:26:24','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(160,'1',216059788,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-23 04:52:46','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(161,'1',219121781,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-25 19:57:42','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(162,'1',220228818,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-28 04:20:37','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(163,'1',220956413,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-28 16:11:15','99981','Vilnius sorting zone 1','WORKSTATION','LT','{\"lv\":{\"id\":1326,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1323,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1324,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1322,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1325,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(164,'1',226819404,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-05 07:59:12','10103','Tallinna jaotuspunkt','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(165,'1',227680232,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-05 22:06:37','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(166,'1',228546885,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-06 16:34:32','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(167,'1',231059861,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-08 22:45:56','14036','Tallinna kullerpunkt','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(168,'1',231857480,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-09 16:03:45','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(169,'1',232381152,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-10 11:36:44','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(170,'1',232910813,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-11 23:45:44','01017','Riga Sorting line','WORKSTATION','LV','{\"lv\":{\"id\":1255,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1257,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1259,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1256,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1258,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(171,'1',235016806,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-14 03:50:21','99995','Šiauliai terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1337,\"name\":\"Šiaulių terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(172,'1',236130275,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-14 20:08:03','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(173,'1',240420447,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-19 22:10:08','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(174,'1',240420450,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-19 22:10:10','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(175,'1',241648738,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-21 03:43:05','80101','Pärnu jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(176,'1',246236362,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-27 22:32:18','01026','Marupe Manual Sorting 1','WORKSTATION','LV','{\"lv\":{\"id\":1279,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1276,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1277,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1275,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1278,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(177,'1',246236364,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-27 22:32:19','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(178,'1',248975865,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-30 20:09:09','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(179,'1',256182676,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-11 04:43:10','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(180,'1',256849999,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-11 15:06:13','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(181,'1',261546793,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-18 01:47:39','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(182,'1',263496250,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-19 19:21:37','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(183,'1',264536266,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-20 22:05:49','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(184,'1',264536271,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-20 22:05:51','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(185,'1',266906846,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-24 17:48:05','99986','Vilnius China Sorting Zone 1','WORKSTATION','LT','{\"lv\":{\"id\":1098,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1095,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1096,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1094,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1097,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(186,'1',294373222,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-03-03 04:16:35','99995','Šiauliai terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1337,\"name\":\"Šiaulių terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(187,'1',295062590,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-03-03 15:39:54','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(188,'1',296903819,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-03-06 19:39:30','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(189,'1',298998525,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-03-08 20:07:06','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(190,'1',306360747,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-03-17 21:44:24','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(191,'1',322257388,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-04-06 12:07:02','14062','Liini järelsorteerimine','WORKSTATION','EE','{\"lv\":{\"id\":1224,\"name\":\"Sutījumu šķirošanas centrs Igaunijā\"},\"et\":{\"id\":1221,\"name\":\"Eesti Pakisorteerimise keskus\"},\"ru\":{\"id\":1222,\"name\":\"Центр сортировки посылок Эстонии\"},\"en\":{\"id\":1220,\"name\":\"Estonian parcel sorting center\"},\"lt\":{\"id\":1223,\"name\":\"Siuntų rūšiavimo centras Estijoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(192,'1',330213654,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-04-17 21:58:18','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(193,'1',346577988,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-07 21:18:45','01029','Marupe Manual Sorting 3','WORKSTATION','LV','{\"lv\":{\"id\":1294,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1291,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1292,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1290,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1293,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(194,'1',348555191,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-09 19:55:13','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(195,'1',359466574,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-22 21:52:35','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(196,'1',362689365,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-26 02:13:15','79533','Rapla jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(197,'1',365188487,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-29 21:51:22','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(198,'1',376409860,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-12 14:01:50','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(199,'1',381038387,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-16 19:27:02','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(200,'1',383695318,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-20 14:47:34','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(201,'1',388315453,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-26 19:18:26','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(202,'1',388321702,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-26 19:29:24','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(203,'1',404771748,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-07-15 03:20:55','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(204,'1',406213816,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-07-17 14:44:47','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(205,'1',437369264,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-08-21 19:15:06','01017','Riga Sorting line','WORKSTATION','LV','{\"lv\":{\"id\":1255,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1257,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1259,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1256,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1258,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(206,'1',453363839,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-09-07 15:24:54','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(207,'1',463989192,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-09-19 20:57:17','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(208,'1',471130627,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-09-27 18:33:26','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(209,'1',475472784,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-10-03 16:37:47','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(210,'1',490176464,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-10-19 13:45:42','01033','Riga Sorting line 2','WORKSTATION','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(211,'1',534415595,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-12-04 15:16:25','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(212,'1',534766128,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-12-04 22:48:31','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(213,'1',563240410,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-01-02 21:39:11','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(214,'1',574101166,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-01-13 01:08:32','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(215,'1',606237055,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-02-20 06:38:53','99984','Kaunas sorting line','WORKSTATION','LT','{\"lv\":{\"id\":1361,\"name\":\"Kauņas šķirošanas centrs\"},\"et\":{\"id\":1358,\"name\":\"Kaunase sorteerimiskeskus\"},\"ru\":{\"id\":1359,\"name\":\"Сортировочный центр Каунаса\"},\"en\":{\"id\":1357,\"name\":\"Kaunas sorting center\"},\"lt\":{\"id\":1360,\"name\":\"Siuntų skirstymo terminalas Kaune\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(216,'1',607088656,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-02-20 22:48:12','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(217,'1',615066473,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-01 16:54:04','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(218,'1',615757768,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-03 20:52:35','01021','Courier sorting','WORKSTATION','LV','{\"lv\":{\"id\":1274,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1271,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1272,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1270,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1273,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(219,'1',625380661,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-14 17:39:32','99992','Kaunas manual sorting','WORKSTATION','LT','{\"lv\":{\"id\":1351,\"name\":\"Kauņas šķirošanas centrs\"},\"et\":{\"id\":1348,\"name\":\"Kaunase sorteerimiskeskus\"},\"ru\":{\"id\":1349,\"name\":\"Сортировочный центр Каунаса\"},\"en\":{\"id\":1347,\"name\":\"Kaunas sorting center\"},\"lt\":{\"id\":1350,\"name\":\"Siuntų skirstymo terminalas Kaune\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(220,'1',625498601,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-14 20:25:30','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(221,'1',628463106,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-18 17:31:55','01024','Riga Terminal H','WORKSTATION','LV','{\"lv\":{\"id\":1063,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1060,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1061,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1059,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1062,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(222,'1',628627424,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-18 22:18:12','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(223,'1',676178028,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-02 18:43:44','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(224,'1',680622144,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-07 23:51:56','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(225,'1',686536383,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-13 17:14:39','99987','Vilnius sorting zone 3 ','WORKSTATION','LT','{\"lv\":{\"id\":1336,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1333,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1334,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1332,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1335,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(226,'1',704598073,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-31 08:43:28','14075','Tolliterminali ooteala','WORKSTATION','EE','{\"lv\":{\"id\":1025,\"name\":\"Omniva muitas terminālis Igaunijā\"},\"et\":{\"id\":1028,\"name\":\"Eesti Omniva tolliterminal\"},\"ru\":{\"id\":1027,\"name\":\"Таможенный терминал Omniva Эстонии\"},\"en\":{\"id\":1024,\"name\":\"Estonian Omniva customs terminal\"},\"lt\":{\"id\":1026,\"name\":\"Omniva muitinės terminalas Estijoje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(227,'1',707834028,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-04 14:03:36','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(228,'1',709102709,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-05 14:58:13','01033','Riga Sorting line 2','WORKSTATION','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(229,'1',711342617,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-07 13:55:18','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(230,'1',716733283,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-13 20:18:13','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(231,'1',717684281,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-14 15:46:41','99993','Kaunas sorting line','WORKSTATION','LT','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(232,'1',720472076,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-18 16:09:26','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(233,'1',721512677,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-19 14:23:15','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-10-31 23:54:24','2024-10-31 23:54:24'),(234,'5',126444211,'TRT_SHIPMENT_PICKED_UP_BY_COURIER','The courier has picked up the shipment','2022-07-28 12:00:57',NULL,NULL,NULL,NULL,NULL,'2024-11-07 05:05:12','2024-11-07 05:05:12'),(235,'5',126444205,'TRT_SHIPMENT_REGISTERED','Shipment registered. Shipment has not been handed over to Omniva','2022-07-28 12:01:03',NULL,NULL,NULL,NULL,NULL,'2024-11-07 05:05:12','2024-11-07 05:05:12'),(236,'5',131935259,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-08-05 01:55:53','99995','Šiauliai terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1337,\"name\":\"Šiaulių terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(237,'5',138918549,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-08-16 06:05:32','14075','Tolliterminali ooteala','WORKSTATION','EE','{\"lv\":{\"id\":1025,\"name\":\"Omniva muitas terminālis Igaunijā\"},\"et\":{\"id\":1028,\"name\":\"Eesti Omniva tolliterminal\"},\"ru\":{\"id\":1027,\"name\":\"Таможенный терминал Omniva Эстонии\"},\"en\":{\"id\":1024,\"name\":\"Estonian Omniva customs terminal\"},\"lt\":{\"id\":1026,\"name\":\"Omniva muitinės terminalas Estijoje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(238,'5',146843931,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-08-26 14:08:43','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(239,'5',147027102,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-08-26 19:17:35','14069','Liinisorteerimine','WORKSTATION','EE','{\"lv\":{\"id\":1344,\"name\":\"Sutījumu šķirošanas centrs Igaunijā\"},\"et\":{\"id\":1341,\"name\":\"Eesti Pakisorteerimise keskus\"},\"ru\":{\"id\":1342,\"name\":\"Центр сортировки посылок Эстонии\"},\"en\":{\"id\":1340,\"name\":\"Estonian parcel sorting center\"},\"lt\":{\"id\":1343,\"name\":\"Siuntų rūšiavimo centras Estijoje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(240,'5',155286194,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-09-07 20:15:05','99983','Kaunas sorting line hospital','WORKSTATION','LT','{\"lv\":{\"id\":1320,\"name\":\"Kauņas šķirošanas centrs\"},\"et\":{\"id\":1317,\"name\":\"Kaunase sorteerimiskeskus\"},\"ru\":{\"id\":1318,\"name\":\"Сортировочный центр Каунаса\"},\"en\":{\"id\":1316,\"name\":\"Kaunas sorting center\"},\"lt\":{\"id\":1319,\"name\":\"Siuntų skirstymo terminalas Kaune\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(241,'5',183581059,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-15 03:48:00','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(242,'5',195335884,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-31 02:26:25','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(243,'5',195370993,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-10-31 05:16:39','99999','Kaunas terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1346,\"name\":\"Kauno terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(244,'5',199499178,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-04 15:58:06','99981','Vilnius sorting zone 1','WORKSTATION','LT','{\"lv\":{\"id\":1326,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1323,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1324,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1322,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1325,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(245,'5',200964710,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 14:16:18','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(246,'5',201317758,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 20:07:36','14026','Logistikakeskuse terminal','DISTRIBUTION_POINT','EE','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(247,'5',201379477,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-07 21:50:51','14069','Liinisorteerimine','WORKSTATION','EE','{\"lv\":{\"id\":1344,\"name\":\"Sutījumu šķirošanas centrs Igaunijā\"},\"et\":{\"id\":1341,\"name\":\"Eesti Pakisorteerimise keskus\"},\"ru\":{\"id\":1342,\"name\":\"Центр сортировки посылок Эстонии\"},\"en\":{\"id\":1340,\"name\":\"Estonian parcel sorting center\"},\"lt\":{\"id\":1343,\"name\":\"Siuntų rūšiavimo centras Estijoje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(248,'5',205117443,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-11 02:42:30','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(249,'5',209201778,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-15 17:50:18','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(250,'5',210693580,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-17 02:28:14','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(251,'5',213659417,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-11-20 21:13:00','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(252,'5',223649966,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2022-12-01 03:32:20','99995','Šiauliai terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1337,\"name\":\"Šiaulių terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(253,'5',255406716,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-10 07:36:38','76693','Keila jaotuspunkt','DISTRIBUTION_POINT','EE','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(254,'5',256817575,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-11 14:25:18','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(255,'5',258170677,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-13 02:27:58','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(256,'5',266821699,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-01-24 15:45:50','41509','Jõhvi jaotuskeskus','DISTRIBUTION_POINT','EE','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(257,'5',277421670,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-02-09 03:28:22','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(258,'5',279115569,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-02-10 16:22:50','99981','Vilnius sorting zone 1','WORKSTATION','LT','{\"lv\":{\"id\":1326,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1323,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1324,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1322,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1325,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(259,'5',350654789,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-05-11 21:35:55','14062','Liini järelsorteerimine','WORKSTATION','EE','{\"lv\":{\"id\":1224,\"name\":\"Sutījumu šķirošanas centrs Igaunijā\"},\"et\":{\"id\":1221,\"name\":\"Eesti Pakisorteerimise keskus\"},\"ru\":{\"id\":1222,\"name\":\"Центр сортировки посылок Эстонии\"},\"en\":{\"id\":1220,\"name\":\"Estonian parcel sorting center\"},\"lt\":{\"id\":1223,\"name\":\"Siuntų rūšiavimo centras Estijoje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(260,'5',389668800,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-06-28 02:56:38','99996','Klaipėda terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1345,\"name\":\"Klaipėdos terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(261,'5',429351398,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-08-11 13:06:10','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(262,'5',475453613,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-10-03 16:12:59','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(263,'5',521363788,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-11-21 22:09:13','99997','Vilnius terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1321,\"name\":\"Vilniaus terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(264,'5',532243213,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2023-12-01 14:56:41','01033','Riga Sorting line 2','WORKSTATION','LV','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(265,'5',563357853,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-01-03 03:30:48','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(266,'5',576149224,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-01-15 20:29:59','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(267,'5',605961007,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-02-19 19:22:01','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(268,'5',616814820,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-05 02:11:28','99994','Panevėžys terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1339,\"name\":\"Panevėžio terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(269,'5',626888922,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-03-16 01:19:08','99995','Šiauliai terminal','DISTRIBUTION_POINT','LT','{\"lt\":{\"id\":1337,\"name\":\"Šiaulių terminalas\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(270,'5',654716704,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-04-12 04:12:44','76693','Keila jaotuspunkt','DISTRIBUTION_POINT','EE','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(271,'5',658011602,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-04-15 21:26:30','99983','Kaunas sorting line hospital','WORKSTATION','LT','{\"lv\":{\"id\":1320,\"name\":\"Kauņas šķirošanas centrs\"},\"et\":{\"id\":1317,\"name\":\"Kaunase sorteerimiskeskus\"},\"ru\":{\"id\":1318,\"name\":\"Сортировочный центр Каунаса\"},\"en\":{\"id\":1316,\"name\":\"Kaunas sorting center\"},\"lt\":{\"id\":1319,\"name\":\"Siuntų skirstymo terminalas Kaune\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(272,'5',658719126,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-04-16 10:58:39','74393','Kehra jaotuspunkt','DISTRIBUTION_POINT','EE','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(273,'5',676066611,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-02 16:16:18','99992','Kaunas manual sorting','WORKSTATION','LT','{\"lv\":{\"id\":1351,\"name\":\"Kauņas šķirošanas centrs\"},\"et\":{\"id\":1348,\"name\":\"Kaunase sorteerimiskeskus\"},\"ru\":{\"id\":1349,\"name\":\"Сортировочный центр Каунаса\"},\"en\":{\"id\":1347,\"name\":\"Kaunas sorting center\"},\"lt\":{\"id\":1350,\"name\":\"Siuntų skirstymo terminalas Kaune\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(274,'5',680256299,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-07 13:49:28','01033','Riga Sorting line 2','WORKSTATION','LV','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(275,'5',697317459,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-23 16:08:52','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(276,'5',697980629,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-05-24 08:22:50','01033','Riga Sorting line 2','WORKSTATION','LV','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(277,'5',717862317,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-14 20:49:36','99978','FB sorting','WORKSTATION','LT','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(278,'5',720455468,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-06-18 15:49:33','99993','Kaunas sorting line','WORKSTATION','LT','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(279,'5',731773126,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-07-01 18:08:17','99982','Vilnius sorting zone 2 ','WORKSTATION','LT','{\"lv\":{\"id\":1331,\"name\":\"Viļņas šķirošanas centrs\"},\"et\":{\"id\":1328,\"name\":\"Vilniuse sorteerimiskeskus\"},\"ru\":{\"id\":1329,\"name\":\"Сортировочный центр Вильнюса\"},\"en\":{\"id\":1327,\"name\":\"Vilnius sorting center\"},\"lt\":{\"id\":1330,\"name\":\"Siuntų skirstymo terminalas Vilniuje\"}}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(280,'5',755147466,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-07-24 18:05:18','99993','Kaunas sorting line','WORKSTATION','LT','{}','2024-11-07 05:05:12','2024-11-07 05:05:12'),(281,'CC649333950EE',906525608,'TRT_SHIPMENT_REGISTERED','Shipment registered. Shipment has not been handed over to Omniva','2024-11-21 08:25:41',NULL,NULL,NULL,NULL,NULL,'2024-11-23 13:42:07','2024-11-23 13:42:07'),(282,'CC649333950EE',907904053,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-11-22 01:50:32','01026','Marupe Manual Sorting 1','WORKSTATION','LV','{\"lv\":{\"id\":1279,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1276,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1277,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1275,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1278,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}','2024-11-23 13:42:07','2024-11-23 13:42:07'),(283,'CC649333950EE',908651144,'TRT_SHIPMENT_ARRIVED_TO_PO','Arrival to postal facility','2024-11-22 12:44:04','9999','Rīga Terminal','DISTRIBUTION_POINT','LV','{}','2024-11-23 13:42:07','2024-11-23 13:42:07'); UNLOCK TABLES; DROP TABLE IF EXISTS `tracking_states`; CREATE TABLE `tracking_states` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shipmentBarcode` varchar(255) DEFAULT NULL, `stateCode` varchar(255) DEFAULT NULL, `stateName` varchar(255) DEFAULT NULL, `stateDate` varchar(255) DEFAULT NULL, `location` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `tracking_states` WRITE; INSERT INTO `tracking_states` VALUES (1,'CC527038025EE','REGISTERED','Shipment registered. Shipment has not been handed over to Omniva','2024-04-25T08:16:07.405',NULL,'2024-10-20 01:23:25','2024-10-20 01:23:25'),(2,'UQ447759660DE','IPS_POSTED_EMA','Item is posted by the sender/collected by the Post','2024-07-06T08:34:00',NULL,'2024-10-20 01:54:37','2024-10-20 01:54:37'),(3,'RL525224864EE','IPS_POSTED_EMA','Item is posted by the sender/collected by the Post','2024-10-16T09:00:00',NULL,'2024-10-21 22:34:45','2024-10-21 22:34:45'),(4,'RL525224864EE','IPS_DEPARTED_EMC','Departure from sender country','2024-10-16T09:43:00',NULL,'2024-10-21 22:34:45','2024-10-21 22:34:45'),(5,'RL525224864EE','IPS_ARRIVED_EMD','Arrived to destination country','2024-10-21T07:12:00',NULL,'2024-10-21 22:34:45','2024-10-21 22:34:45'),(6,'RL525224864EE','TAKEN_TO_CUSTOMS','Shipment in customs','2024-10-21T07:27:00',NULL,'2024-10-21 22:34:45','2024-10-21 22:34:45'),(7,'RL525224864EE','RELEASED_FROM_CUSTOMS','Released from customs','2024-10-21T07:42:00',NULL,'2024-10-21 22:34:45','2024-10-21 22:34:45'),(8,'RL525224864EE','IN_LOGISTIC_CENTER','Shipment is at the sorting centre','2024-10-21T07:57:00',NULL,'2024-10-21 22:34:45','2024-10-21 22:34:45'),(9,'RL526838930EE','IPS_POSTED_EMA','Item is posted by the sender/collected by the Post','2024-10-23T12:36:00',NULL,'2024-10-24 09:31:57','2024-10-24 09:31:57'),(10,'RL526838930EE','IPS_DEPARTED_EMC','Departure from sender country','2024-10-23T13:19:00',NULL,'2024-10-24 09:31:57','2024-10-24 09:31:57'),(11,'1','REGISTERED','Shipment registered. Shipment has not been handed over to Omniva','2022-05-30T06:43:59.355',NULL,'2024-10-24 23:13:56','2024-10-24 23:13:56'),(12,'1','IN_TRANSIT','Shipment is on the way','2022-05-30T06:43:55.176',NULL,'2024-10-24 23:13:56','2024-10-24 23:13:56'),(13,'1','IN_LOGISTIC_CENTER','Shipment is at the sorting centre','2022-07-25T23:41:10.431','{\"zip\":\"01017\",\"locationName\":\"Riga Sorting line\",\"servicePointTypeCode\":\"WORKSTATION\",\"countryCode\":\"LV\",\"translations\":{\"lv\":{\"id\":1255,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1257,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1259,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1256,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1258,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}}','2024-10-24 23:13:56','2024-10-24 23:13:56'),(14,'1','REGISTERED','Shipment registered. Shipment has not been handed over to Omniva','2022-05-30T06:43:59.355',NULL,'2024-10-31 21:54:24','2024-10-31 21:54:24'),(15,'1','IN_TRANSIT','Shipment is on the way','2022-05-30T06:43:55.176',NULL,'2024-10-31 21:54:24','2024-10-31 21:54:24'),(16,'1','IN_LOGISTIC_CENTER','Shipment is at the sorting centre','2022-07-25T23:41:10.431','{\"zip\":\"01017\",\"locationName\":\"Riga Sorting line\",\"servicePointTypeCode\":\"WORKSTATION\",\"countryCode\":\"LV\",\"translations\":{\"lv\":{\"id\":1255,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1257,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1259,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1256,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1258,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}}','2024-10-31 21:54:24','2024-10-31 21:54:24'),(17,'5','REGISTERED','Shipment registered. Shipment has not been handed over to Omniva','2022-07-28T12:01:03.46',NULL,'2024-11-07 03:05:12','2024-11-07 03:05:12'),(18,'5','IN_TRANSIT','Shipment is on the way','2022-07-28T12:00:57.018',NULL,'2024-11-07 03:05:12','2024-11-07 03:05:12'),(19,'5','IN_LOGISTIC_CENTER','Shipment is at the sorting centre','2024-01-15T20:29:58.304','{\"zip\":\"01017\",\"locationName\":\"Riga Sorting line\",\"servicePointTypeCode\":\"WORKSTATION\",\"countryCode\":\"LV\",\"translations\":{\"lv\":{\"id\":1255,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1257,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1259,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1256,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1258,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}}','2024-11-07 03:05:12','2024-11-07 03:05:12'),(20,'CC649333950EE','REGISTERED','Shipment registered. Shipment has not been handed over to Omniva','2024-11-21T08:25:41.602',NULL,'2024-11-23 11:42:07','2024-11-23 11:42:07'),(21,'CC649333950EE','IN_TRANSIT','Shipment is on the way','2024-11-22T01:50:32.449','{\"zip\":\"01026\",\"locationName\":\"Marupe Manual Sorting 1\",\"servicePointTypeCode\":\"WORKSTATION\",\"countryCode\":\"LV\",\"translations\":{\"lv\":{\"id\":1279,\"name\":\"Rīgas šķirošanas centrs\"},\"et\":{\"id\":1276,\"name\":\"Riia sorteerimiskeskus\"},\"ru\":{\"id\":1277,\"name\":\"Сортировочный центр Риги\"},\"en\":{\"id\":1275,\"name\":\"Riga sorting center\"},\"lt\":{\"id\":1278,\"name\":\"Siuntų skirstymo terminalas Rygoje\"}}}','2024-11-23 11:42:07','2024-11-23 11:42:07'),(22,'CC649333950EE','IN_LOGISTIC_CENTER','Shipment is at the sorting centre','2024-11-22T12:44:04.439','{\"zip\":\"9999\",\"locationName\":\"Rīga Terminal\",\"servicePointTypeCode\":\"DISTRIBUTION_POINT\",\"countryCode\":\"LV\",\"translations\":{}}','2024-11-23 11:42:07','2024-11-23 11:42:07'); UNLOCK TABLES; DROP TABLE IF EXISTS `translations`; CREATE TABLE `translations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `language` varchar(5) DEFAULT NULL, `key` varchar(255) DEFAULT NULL, `message` varchar(9000) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `language` (`language`,`key`) ) ENGINE=InnoDB AUTO_INCREMENT=295 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `translations` WRITE; INSERT INTO `translations` VALUES (1,'en','track_button','🔎 Track Shipment','2024-10-25 00:09:16','2024-11-15 00:58:35'),(2,'en','my_shipments_button','📦 My Shipments ','2024-10-25 00:09:16','2024-11-15 01:01:05'),(3,'en','parcel_baltics_new_button','🚚 Register a package','2024-10-25 00:09:16','2024-11-15 01:00:23'),(4,'en','cargo_calculator_button','Cargo Calculator','2024-10-25 00:09:16','2024-10-25 01:25:25'),(5,'en','welcome','Welcome to the Omniva Tracking Bot! Please select one of the options below to start.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(6,'en','menu_message','Please use the buttons below to navigate through the available options.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(7,'en','select_language_prompt','Please select your language:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(8,'en','invalid_language_choice','Invalid choice. Please use the /start command again.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(9,'en','cargo_calculator_response','🛠 Temporarily unavailable, currently in testing phase.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(10,'en','parcel_baltics_new_button_response','🛠 Temporarily unavailable, currently in testing phase.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(11,'en','enter_barcode','Please enter your shipment barcode:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(12,'en','invalid_barcode','Invalid barcode. Please try again.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(13,'en','already_tracked','Shipment {barcode} is already being tracked.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(14,'en','tracking_started','Tracking started for shipment: {barcode}','2024-10-25 00:09:16','2024-10-25 00:09:16'),(15,'en','no_shipment_data','No data found for shipment with tracking code {trackingCode}.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(16,'en','your_shipments','Here are your tracked shipments:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(17,'en','no_shipments','You do not have any tracked shipments.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(18,'en','error_loading_shipments','Error loading shipment information. Please try again later.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(19,'en','dimensions_info_absent','Not available','2024-10-25 00:09:16','2024-10-25 00:09:16'),(20,'en','tracking_unavailable','Tracking for this shipment is temporarily unavailable.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(21,'en','unsupported_parcel','This type of parcel is not supported.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(22,'en','no_detailed_info','No detailed information available for shipment: {barcode}','2024-10-25 00:09:16','2024-10-25 00:09:16'),(23,'en','tracking_info','Shipment number: {barcode}\nDelivery location: {delivery_location}\nStatus:\n{status_list}\n\n{dimensions_info}','2024-10-25 00:09:16','2024-10-25 00:09:16'),(24,'en','dimensions_info','Dimensions:\n- Width: {width} cm\n- Height: {height} cm\n- Depth: {depth} cm\n- Weight: {weight} kg','2024-10-25 00:09:16','2024-10-25 00:09:16'),(25,'en','inbound_network_code_unsupported','Tracking for this parcel type is temporarily unavailable.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(26,'en','not_available','Not available','2024-10-25 00:09:16','2024-10-25 00:09:16'),(27,'en','status_absent','Status not available','2024-10-25 00:09:16','2024-10-25 00:09:16'),(28,'en','shipment_added','The shipment with tracking code {trackingCode} has been successfully added.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(29,'en','YES_replyOptions','Yes','2024-10-25 00:09:16','2024-10-25 00:09:16'),(30,'en','NO_replyOptions','No','2024-10-25 00:09:16','2024-10-25 00:09:16'),(31,'en','invalid_command','Invalid command. Please use the buttons below to navigate.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(32,'en','support_button','🆘 Support','2024-10-25 00:09:16','2024-11-15 01:04:55'),(33,'en','contact_support_button','Contact Support','2024-10-25 00:09:16','2024-10-25 00:09:16'),(34,'en','visit_omniva_support_button','Visit Omniva Support','2024-10-25 00:09:16','2024-10-25 00:09:16'),(35,'en','creator_support_button','Application Support','2024-10-25 00:09:16','2024-10-25 00:09:16'),(36,'en','postal_office_support_button','Postal Office Support','2024-10-25 00:09:16','2024-10-25 00:09:16'),(37,'en','support_message','Please choose the type of support you need:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(38,'en','creator_support_response','For application-related support, please contact us at support@coonlink.fun.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(39,'en','postal_office_support_response','For issues regarding postal services, please contact your nearest Omniva office or visit the official support page.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(40,'en','already_delivered','🚚 Shipment with barcode {barcode} has already been delivered. Tracking is not available.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(41,'en','cannot_track_status','🚚 Shipment with barcode {barcode} cannot be tracked because its current status is {status}.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(42,'en','just_now','just now','2024-10-25 00:09:16','2024-10-25 00:09:16'),(43,'en','minute_ago','a minute ago','2024-10-25 00:09:16','2024-10-25 00:09:16'),(44,'en','minutes_ago','minutes ago','2024-10-25 00:09:16','2024-10-25 00:09:16'),(45,'en','hour_ago','an hour ago','2024-10-25 00:09:16','2024-10-25 00:09:16'),(46,'en','hours_ago','hours ago','2024-10-25 00:09:16','2024-10-25 00:09:16'),(47,'en','today','Today','2024-10-25 00:09:16','2024-10-25 00:09:16'),(48,'en','yesterday','Yesterday','2024-10-25 00:09:16','2024-10-25 00:09:16'),(49,'en','day_before_yesterday','The day before yesterday','2024-10-25 00:09:16','2024-10-25 00:09:16'),(50,'en','year_abbreviation',NULL,'2024-10-25 00:09:16','2024-10-25 00:09:16'),(51,'en','months','[\'January\', \'February\', \'March\', \'April\', \'May\', \'June\', \'July\', \'August\', \'September\', \'October\', \'November\', \'December\']','2024-10-25 00:09:16','2024-10-25 00:09:16'),(52,'en','weekdays','[\'Sunday\', \'Monday\', \'Tuesday\', \'Wednesday\', \'Thursday\', \'Friday\', \'Saturday\']','2024-10-25 00:09:16','2024-10-25 00:09:16'),(53,'en','tracking_info_barcode','Shipment Number','2024-10-25 00:09:16','2024-10-25 00:09:16'),(54,'en','tracking_info_delivery_location','Delivery Location','2024-10-25 00:09:16','2024-10-25 00:09:16'),(55,'en','tracking_info_status','Status','2024-10-25 00:09:16','2024-10-25 00:09:16'),(56,'en','last_update','Last Update','2024-10-25 00:09:16','2024-10-25 00:09:16'),(57,'en','progress','Progress','2024-10-25 00:09:16','2024-10-25 00:09:16'),(58,'en','estimated_delivery','Estimated Delivery','2024-10-25 00:09:16','2024-10-25 00:09:16'),(59,'en','estimated_delivery_not_available','Estimated delivery is not available','2024-10-25 00:09:16','2024-10-25 00:09:16'),(60,'en','additional_info','Please contact support if you have any questions about your package.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(61,'en','tracking_info_dimensions','Dimensions','2024-10-25 00:09:16','2024-10-25 00:09:16'),(62,'ru','track_button','🔎 Отследить посылку','2024-10-25 00:09:16','2024-11-15 00:58:43'),(63,'ru','my_shipments_button','📦 Мои посылки','2024-10-25 00:09:16','2024-11-15 01:00:50'),(64,'ru','parcel_baltics_new_button','🚚 Зарегистрировать посылку','2024-10-25 00:09:16','2024-11-15 01:00:05'),(65,'ru','cargo_calculator_button','Калькулятор груза','2024-10-25 00:09:16','2024-10-25 01:25:58'),(66,'ru','welcome','Добро пожаловать в бот отслеживания Omniva! Пожалуйста, выберите один из вариантов ниже для начала.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(67,'ru','menu_message','Пожалуйста, используйте кнопки ниже для навигации по доступным вариантам.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(68,'ru','select_language_prompt','Пожалуйста, выберите язык:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(69,'ru','invalid_language_choice','Неверный выбор. Пожалуйста, используйте команду /start снова.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(70,'ru','cargo_calculator_response','🛠 Временно недоступно, находится в стадии тестирования.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(71,'ru','parcel_baltics_new_button_response','🛠 Временно недоступно, находится в стадии тестирования.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(72,'ru','enter_barcode','Пожалуйста, введите номер штрихкода вашей посылки:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(73,'ru','invalid_barcode','Неверный штрихкод. Пожалуйста, попробуйте снова.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(74,'ru','already_tracked','Посылка {barcode} уже отслеживается.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(75,'ru','tracking_started','Отслеживание начато для посылки: {barcode}','2024-10-25 00:09:16','2024-10-25 00:09:16'),(76,'ru','no_shipment_data','Данные о посылке с номером {trackingCode} не найдены.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(77,'ru','your_shipments','Вот ваши отслеживаемые посылки:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(78,'ru','no_shipments','У вас нет отслеживаемых посылок.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(79,'ru','error_loading_shipments','Ошибка загрузки информации о посылках. Пожалуйста, попробуйте позже.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(80,'ru','dimensions_info_absent','Отсутствуют','2024-10-25 00:09:16','2024-10-25 00:09:16'),(81,'ru','tracking_unavailable','Отслеживание для этой посылки временно недоступно.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(82,'ru','unsupported_parcel','Этот тип посылки не поддерживается.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(83,'ru','no_detailed_info','Нет подробной информации для посылки: {barcode}','2024-10-25 00:09:16','2024-10-25 00:09:16'),(84,'ru','tracking_info','Номер посылки: {barcode}\nМесто доставки: {delivery_location}\nСтатус:\n{status_list}\n\n{dimensions_info}','2024-10-25 00:09:16','2024-10-25 00:09:16'),(85,'ru','dimensions_info','Размеры:\n- Ширина: {width} см\n- Высота: {height} см\n- Глубина: {depth} см\n- Вес: {weight} кг','2024-10-25 00:09:16','2024-10-25 00:09:16'),(86,'ru','inbound_network_code_unsupported','Отслеживание для этой посылки временно недоступно.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(87,'ru','not_available','Отсутствует','2024-10-25 00:09:16','2024-10-25 00:09:16'),(88,'ru','status_absent','Статус отсутствует','2024-10-25 00:09:16','2024-10-25 00:09:16'),(89,'ru','shipment_added','Посылка с номером {trackingCode} успешно добавлена.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(90,'ru','YES_replyOptions','Да','2024-10-25 00:09:16','2024-10-25 00:09:16'),(91,'ru','NO_replyOptions','Нет','2024-10-25 00:09:16','2024-10-25 00:09:16'),(92,'ru','invalid_command','Неверная команда. Пожалуйста, используйте кнопки ниже для навигации.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(93,'ru','support_button','🆘 Поддержка','2024-10-25 00:09:16','2024-11-15 01:05:02'),(94,'ru','contact_support_button','Связаться с поддержкой','2024-10-25 00:09:16','2024-10-25 00:09:16'),(95,'ru','visit_omniva_support_button','Посетить поддержку Omniva','2024-10-25 00:09:16','2024-10-25 00:09:16'),(96,'ru','creator_support_button','Поддержка приложения','2024-10-25 00:09:16','2024-10-25 00:09:16'),(97,'ru','postal_office_support_button','Поддержка почтового отделения','2024-10-25 00:09:16','2024-10-25 00:09:16'),(98,'ru','support_message','Пожалуйста, выберите тип поддержки, который вам нужен:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(99,'ru','creator_support_response','Для поддержки, связанной с приложением, свяжитесь с нами по адресу support@coonlink.fun.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(100,'ru','postal_office_support_response','По вопросам, связанным с почтовыми услугами, обратитесь в ближайшее отделение Omniva или посетите официальную страницу поддержки.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(101,'ru','already_delivered','🚚 Посылка с номером {barcode} уже доставлена. Отслеживание невозможно.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(102,'ru','cannot_track_status','🚚 Посылка с номером {barcode} не может быть отслежена, так как её текущий статус: {status}.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(103,'ru','just_now','только что','2024-10-25 00:09:16','2024-10-25 00:09:16'),(104,'ru','minute_ago','минуту назад','2024-10-25 00:09:16','2024-10-25 00:09:16'),(105,'ru','minutes_ago','минут назад','2024-10-25 00:09:16','2024-10-25 00:09:16'),(106,'ru','hour_ago','час назад','2024-10-25 00:09:16','2024-10-25 00:09:16'),(107,'ru','hours_ago','часов назад','2024-10-25 00:09:16','2024-10-25 00:09:16'),(108,'ru','today','Сегодня','2024-10-25 00:09:16','2024-10-25 00:09:16'),(109,'ru','yesterday','Вчера','2024-10-25 00:09:16','2024-10-25 00:09:16'),(110,'ru','day_before_yesterday','Позавчера','2024-10-25 00:09:16','2024-10-25 00:09:16'),(111,'ru','year_abbreviation','г.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(112,'ru','months','[\'январь\', \'февраль\', \'март\', \'апрель\', \'май\', \'июнь\', \'июль\', \'август\', \'сентябрь\', \'октябрь\', \'ноябрь\', \'декабрь\']','2024-10-25 00:09:16','2024-10-25 00:09:16'),(113,'ru','weekdays','[\'воскресенье\', \'понедельник\', \'вторник\', \'среда\', \'четверг\', \'пятница\', \'суббота\']','2024-10-25 00:09:16','2024-10-25 00:09:16'),(114,'ru','tracking_info_barcode','Номер посылки','2024-10-25 00:09:16','2024-10-25 00:09:16'),(115,'ru','tracking_info_delivery_location','Место доставки','2024-10-25 00:09:16','2024-10-25 00:09:16'),(116,'ru','tracking_info_status','Статус','2024-10-25 00:09:16','2024-10-25 00:09:16'),(117,'ru','last_update','Последнее обновление','2024-10-25 00:09:16','2024-10-25 00:09:16'),(118,'ru','progress','Прогресс','2024-10-25 00:09:16','2024-10-25 00:09:16'),(119,'ru','estimated_delivery','Ожидаемая доставка','2024-10-25 00:09:16','2024-10-25 00:09:16'),(120,'ru','estimated_delivery_not_available','Ожидаемая доставка недоступна','2024-10-25 00:09:16','2024-10-25 00:09:16'),(121,'ru','tracking_info_dimensions','Размеры','2024-10-25 00:09:16','2024-10-25 00:09:16'),(122,'ru','additional_info','Пожалуйста, свяжитесь с поддержкой, если у вас есть вопросы по поводу посылки.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(123,'et','track_button','🔎 Jälgi saadetist','2024-10-25 00:09:16','2024-11-15 00:58:51'),(124,'et','my_shipments_button','📦 Minu saadetised','2024-10-25 00:09:16','2024-11-15 01:01:13'),(125,'et','parcel_baltics_new_button','🚚 Registreeri pakk','2024-10-25 00:09:16','2024-11-15 01:00:33'),(126,'et','cargo_calculator_button','Kaubakalkulaator','2024-10-25 00:09:16','2024-10-25 01:26:24'),(127,'et','welcome','Tere tulemast Omniva jälgimise botti! Valige üks allolevatest valikutest alustamiseks.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(128,'et','menu_message','Palun kasutage allolevaid nuppe, et liikuda läbi valikute.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(129,'et','select_language_prompt','Palun vali keel:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(130,'et','invalid_language_choice','Vale valik. Palun kasutage uuesti käsku /start.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(131,'et','cargo_calculator_response','🛠 Ajutiselt kättesaamatu, testimisfaasis.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(132,'et','parcel_baltics_new_button_response','🛠 Ajutiselt kättesaamatu, testimisfaasis.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(133,'et','enter_barcode','Palun sisesta oma saadetise triipkood:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(134,'et','invalid_barcode','Vale triipkood. Palun proovi uuesti.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(135,'et','already_tracked','Saadetist {barcode} juba jälgitakse.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(136,'et','tracking_started','Jälgimine alustatud saadetise jaoks: {barcode}','2024-10-25 00:09:16','2024-10-25 00:09:16'),(137,'et','no_shipment_data','Saadetise numbriga {trackingCode} andmeid ei leitud.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(138,'et','your_shipments','Siin on teie jälgitavad saadetised:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(139,'et','no_shipments','Teil pole jälgitavaid saadetisi.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(140,'et','error_loading_shipments','Saadetise teabe laadimisel ilmnes tõrge. Palun proovige hiljem uuesti.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(141,'et','dimensions_info_absent','Puuduvad','2024-10-25 00:09:16','2024-10-25 00:09:16'),(142,'et','tracking_unavailable','Selle saadetise jälgimine on ajutiselt kättesaamatu.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(143,'et','unsupported_parcel','Seda tüüpi saadetis ei ole toetatud.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(144,'et','no_detailed_info','Pole üksikasjalikku teavet saadetise kohta: {barcode}','2024-10-25 00:09:16','2024-10-25 00:09:16'),(145,'et','tracking_info','Saadetise number: {barcode}\nKohaletoimetamise asukoht: {delivery_location}\nStaatus:\n{status_list}\n\n{dimensions_info}','2024-10-25 00:09:16','2024-10-25 00:09:16'),(146,'et','dimensions_info','Mõõtmed:\n- Laius: {width} cm\n- Kõrgus: {height} cm\n- Sügavus: {depth} cm\n- Kaal: {weight} kg','2024-10-25 00:09:16','2024-10-25 00:09:16'),(147,'et','inbound_network_code_unsupported','Selle saadetise jälgimine on ajutiselt kättesaamatu.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(148,'et','not_available','Puuduvad','2024-10-25 00:09:16','2024-10-25 00:09:16'),(149,'et','status_absent','Staatus puudub','2024-10-25 00:09:16','2024-10-25 00:09:16'),(150,'et','shipment_added','Saadetis numbriga {trackingCode} on edukalt lisatud.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(151,'et','YES_replyOptions','Jä','2024-10-25 00:09:16','2024-10-25 00:09:16'),(152,'et','NO_replyOptions','Ei','2024-10-25 00:09:16','2024-10-25 00:09:16'),(153,'et','invalid_command','Vale käsklus. Palun kasutage allolevaid nuppe navigeerimiseks.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(154,'et','support_button','🆘 Tugi','2024-10-25 00:09:16','2024-11-15 01:05:13'),(155,'et','contact_support_button','Võtke ühendust toega','2024-10-25 00:09:16','2024-10-25 00:09:16'),(156,'et','visit_omniva_support_button','Külastage Omniva tuge','2024-10-25 00:09:16','2024-10-25 00:09:16'),(157,'et','creator_support_button','Rakenduse tugi','2024-10-25 00:09:16','2024-10-25 00:09:16'),(158,'et','postal_office_support_button','Postkontori tugi','2024-10-25 00:09:16','2024-10-25 00:09:16'),(159,'et','support_message','Palun valige, millist tuge vajate:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(160,'et','creator_support_response','Rakendusega seotud toe saamiseks võtke meiega ühendust aadressil support@coonlink.fun.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(161,'et','postal_office_support_response','Postiteenustega seotud küsimuste korral pöörduge lähimasse Omniva kontorisse või külastage ametlikku tugilehte.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(162,'et','already_delivered','🚚 Pakk numbriga {barcode} on juba kohale toimetatud. Jälgimine pole saadaval.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(163,'et','cannot_track_status','🚚 Pakki numbriga {barcode} ei saa jälgida, kuna selle praegune olek on: {status}.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(164,'et','just_now','just nüüd','2024-10-25 00:09:16','2024-10-25 00:09:16'),(165,'et','minute_ago','minut tagasi','2024-10-25 00:09:16','2024-10-25 00:09:16'),(166,'et','minutes_ago','minutit tagasi','2024-10-25 00:09:16','2024-10-25 00:09:16'),(167,'et','hour_ago','tund tagasi','2024-10-25 00:09:16','2024-10-25 00:09:16'),(168,'et','hours_ago','tundi tagasi','2024-10-25 00:09:16','2024-10-25 00:09:16'),(169,'et','today','Täna','2024-10-25 00:09:16','2024-10-25 00:09:16'),(170,'et','yesterday','Eile','2024-10-25 00:09:16','2024-10-25 00:09:16'),(171,'et','day_before_yesterday','Üleeile','2024-10-25 00:09:16','2024-10-25 00:09:16'),(172,'et','year_abbreviation',NULL,'2024-10-25 00:09:16','2024-10-25 00:09:16'),(173,'et','months','[\'jaanuar\', \'veebruar\', \'märts\', \'aprill\', \'mai\', \'juuni\', \'juuli\', \'august\', \'september\', \'oktoober\', \'november\', \'detsember\']','2024-10-25 00:09:16','2024-10-25 00:09:16'),(174,'et','weekdays','[\'Pühapäev\', \'Esmaspäev\', \'Teisipäev\', \'Kolmapäev\', \'Neljapäev\', \'Reede\', \'Laupäev\']','2024-10-25 00:09:16','2024-10-25 00:09:16'),(175,'et','tracking_info_barcode','Saadetise number','2024-10-25 00:09:16','2024-10-25 00:09:16'),(176,'et','tracking_info_delivery_location','Kohaletoimetamise asukoht','2024-10-25 00:09:16','2024-10-25 00:09:16'),(177,'et','tracking_info_status','Staatus','2024-10-25 00:09:16','2024-10-25 00:09:16'),(178,'et','last_update','Viimane värskendus','2024-10-25 00:09:16','2024-10-25 00:09:16'),(179,'et','progress','Edenemine','2024-10-25 00:09:16','2024-10-25 00:09:16'),(180,'et','estimated_delivery','Eeldatav kohaletoimetamine','2024-10-25 00:09:16','2024-10-25 00:09:16'),(181,'et','estimated_delivery_not_available','Eeldatav kohaletoimetamine ei ole saadaval','2024-10-25 00:09:16','2024-10-25 00:09:16'),(182,'et','tracking_info_dimensions','Mõõtmed','2024-10-25 00:09:16','2024-10-25 00:09:16'),(183,'et','additional_info','Võtke ühendust klienditoega, kui teil on küsimusi oma paki kohta.','2024-10-25 00:09:16','2024-10-25 00:09:16'),(184,'multi','select_language_prompt','The language you are using is not supported.\n Please select one of the available languages:','2024-10-25 00:09:16','2024-10-25 00:09:16'),(201,'en','status_translations','[REGISTERED: \'Registered\',IN_TRANSIT: \'Shipment is on the way\',IN_LOGISTIC_CENTER: \'Shipment is at the sorting centre\',IN_PARCEL_MACHINE: \'Shipment delivered to the parcel machine\',DELIVERED: \'Shipment delivered\']','2024-10-25 00:09:16','2024-10-25 00:09:16'),(206,'ru','status_translations','[REGISTERED: \'Зарегистрировано\',IN_TRANSIT: \'Посылка уже в пути\',IN_LOGISTIC_CENTER: \'Посылка в логистическом центре\',IN_PARCEL_MACHINE: \'Посылка доставлена в автомат\',DELIVERED: \'Посылка доставлена\']','2024-10-25 00:09:16','2024-10-25 00:09:16'),(226,'et','status_translations','[REGISTERED: \'Registreeritud\',IN_TRANSIT: \'Saadetis on teel\',IN_LOGISTIC_CENTER: \'Saadetis on sorteerimiskeskuses\',IN_PARCEL_MACHINE: \'Saadetis tarnitud pakiautomaati\',DELIVERED: \'Saadetis kohaletoimetatud\']','2024-10-25 00:09:16','2024-10-25 00:09:16'),(227,'en','sms_package_button','SMS package','2024-10-25 00:09:16','2024-10-25 01:24:21'),(228,'en','sms_info_button','(SMS package) info','2024-10-25 00:09:16','2024-10-25 01:24:18'),(231,'ru','sms_package_button','Пакет СМС','2024-10-25 00:09:16','2024-10-25 01:24:06'),(232,'ru','sms_info_button','(Пакет СМС) Информация','2024-10-25 00:09:16','2024-10-25 01:24:15'),(233,'et','sms_package_button','SMS pakett','2024-10-25 00:09:16','2024-10-25 01:24:02'),(234,'et','sms_info_button','(SMS pakett) Teave','2024-10-25 00:09:16','2024-10-25 01:24:10'),(235,'en','sms_package_message','📋 Choose from the suggested options or create your own package:','2024-10-25 00:27:10','2024-10-25 00:27:54'),(236,'ru','sms_package_message','📋 Выберите из предложенных вариантов или создайте свой собственный пакет:','2024-10-25 00:27:10','2024-10-25 00:28:06'),(237,'et','sms_package_message','📋 Valige pakutud valikute hulgast või looge oma pakett:','2024-10-25 00:27:10','2024-10-25 00:28:12'),(241,'en','sms_info_message','ℹ️ The \"SMS Package\" service allows you to rent a virtual phone number to receive verification codes for opening parcel lockers.\nThis way, you don’t need to use your personal phone number — all SMS will come here in Telegram.\n\n💬 Select \"SMS Package\" to start using the service.','2024-10-25 00:33:57','2024-10-25 01:38:01'),(242,'ru','sms_info_message','ℹ️ Услуга \"Пакет SMS\" позволяет вам арендовать виртуальный номер телефона, на который будут поступать коды подтверждения для открытия посылочных автоматов.\nТаким образом, вам не нужно использовать ваш личный номер телефона — все SMS будут приходить сюда, в Telegram.\n\n💬 Выберите \"Пакет SMS\", чтобы начать пользоваться.','2024-10-25 00:33:57','2024-10-25 01:37:48'),(243,'et','sms_info_message','ℹ️ \"SMS-paketi\" teenus võimaldab teil rentida virtuaalse telefoninumbri, kuhu saadetakse kinnituskoodid pakiautomaatide avamiseks.\nNii ei pea te kasutama oma isiklikku telefoninumbrit — kõik SMS-id saabuvad siia Telegrami.\n\n💬 Valige \"SMS-pakett\", et alustada kasutamist.','2024-10-25 00:33:57','2024-10-25 01:38:11'),(244,'en','sms_package_app_button','Open the application to select a package','2024-10-25 00:39:14','2024-10-25 01:24:51'),(245,'ru','sms_package_app_button','Откройте приложение, чтобы выбрать пакет','2024-10-25 00:39:14','2024-10-25 01:25:01'),(246,'et','sms_package_app_button','Avage rakendus, et valida pakett','2024-10-25 00:39:53','2024-10-25 01:25:08'),(247,'en','shipment_journey_button','Shipment track & trace','2024-10-25 02:08:06','2024-10-25 02:08:06'),(248,'ru','shipment_journey_button','Маршрут посылки','2024-10-25 02:08:06','2024-10-25 02:08:06'),(249,'et','shipment_journey_button','Saadetise teekond','2024-10-25 02:08:23','2024-10-25 02:08:23'),(250,'en','terms_privacy_of_service','🔒 *Privacy Policy and Terms of Service*\n\nBefore you can use this bot, please take a moment to review our Privacy Policy and Terms of Service:\n\n📄 [Privacy Policy](https://omnivatrackbot.coonlink.fun/apps/privacy)\n📄 [Terms of Service](https://omnivatrackbot.coonlink.fun/apps/terms)\n\nWe value your privacy and want you to understand how we handle your data.\n\nBy clicking \"I Agree,\" you agree to our Privacy Policy and Terms of Service. If you do not agree, you may click \"I Decline\" and will not be able to use the bot.\n\nThank you for your understanding!','2024-10-25 02:49:32','2024-10-27 17:31:59'),(251,'ru','terms_privacy_of_service','🔒 Политика конфиденциальности и условия использования\nПрежде чем вы сможете использовать этого бота, пожалуйста, уделите время для ознакомления с нашей Политикой конфиденциальности и Условиями использования:\n\n📄 [Политика конфиденциальности](https://omnivatrackbot.coonlink.fun/apps/privacy)\n📄 [Условия использования](https://omnivatrackbot.coonlink.fun/apps/terms)\n\nМы ценим вашу конфиденциальность и хотим, чтобы вы понимали, как мы обрабатываем ваши данные.\n\nНажав на \"Я согласен\", вы соглашаетесь с нашей Политикой конфиденциальности и Условиями использования. Если вы не согласны, вы можете нажать \"Я не согласен\" и не сможете пользоваться ботом.\n\nСпасибо за понимание!','2024-10-25 02:49:32','2024-10-27 17:40:13'),(252,'et','terms_privacy_of_service','🔒 Privaatsuspoliitika ja kasutustingimused\nEnne kui saate seda boti kasutada, võtke hetk, et tutvuda meie privaatsuspoliitika ja kasutustingimustega:\n\n📄 [Privaatsuspoliitika](https://omnivatrackbot.coonlink.fun/apps/privacy)\n📄 [Kasutustingimused](https://omnivatrackbot.coonlink.fun/apps/terms)\n\nMe hindame teie privaatsust ja soovime, et te mõistaksite, kuidas me teie andmeid käsitleme.\n\nKlikkides \"Nõustun\", nõustute meie privaatsuspoliitika ja kasutustingimustega. Kui te ei nõustu, võite klikkida \"Keeldun\" ja ei saa boti kasutada.\n\nTäname mõistmise eest!','2024-10-25 02:49:32','2024-10-27 17:40:20'),(253,'en','terms_accept_button','✅ I Agree','2024-10-25 02:56:23','2024-10-25 02:56:23'),(254,'ru','terms_accept_button','✅ Я согласен','2024-10-25 02:56:23','2024-10-25 02:56:23'),(255,'et','terms_accept_button','✅ Nõustun','2024-10-25 02:56:23','2024-10-25 02:56:23'),(256,'en','terms_decline_button','❌ I Decline','2024-10-25 02:57:20','2024-10-25 02:57:20'),(257,'ru','terms_decline_button','❌ Я не согласен','2024-10-25 02:57:20','2024-10-25 02:57:20'),(258,'et','terms_decline_button','❌ Keeldun','2024-10-25 02:57:20','2024-10-25 02:57:20'),(259,'en','send_parcel_us','Send with Our Service','2024-10-29 04:24:18','2024-10-29 04:51:50'),(260,'ru','send_parcel_us','Отправить через наш сервис','2024-10-29 04:24:18','2024-10-29 04:51:39'),(261,'et','send_parcel_us','Saada meie teenuse kaudu','2024-10-29 04:24:33','2024-10-29 04:51:58'),(262,'en','send_postal_office','Send via Local Post Office','2024-10-29 04:25:02','2024-10-29 04:52:15'),(263,'ru','send_postal_office','Оформить через почтовое отделение','2024-10-29 04:25:02','2024-10-29 04:25:02'),(264,'et','send_postal_office','Saada postkontori kaudu','2024-10-29 04:25:19','2024-10-29 04:52:26'),(265,'en','parcel_baltics_new_button_message','What would you like to do? 📦 You have two options for sending your parcel:','2024-10-29 04:26:01','2024-10-29 04:48:00'),(266,'ru','parcel_baltics_new_button_message','Что вы хотите сделать? 📦 У вас есть два варианта для отправки посылки:','2024-10-29 04:26:01','2024-10-29 04:47:47'),(267,'et','parcel_baltics_new_button_message','Mida soovite teha? 📦 Teil on kaks võimalust paki saatmiseks:','2024-10-29 04:26:19','2024-10-29 04:48:07'),(268,'en','parcel_baltics_new_button_message_extra','1. **Send through our service** - With this option, you don\'t need to pay for the shipping upfront. However, the recipient will need to pay when they receive the parcel.\n2. **Send through a postal office** - You will pay for the shipping at the time of sending, and the recipient will not need to pay anything when they receive it.\n\nIt\'s entirely up to you to decide which option works best for you. 😊 Just keep in mind that there is a limit on the number of parcels you can send through our service.','2024-10-29 04:39:42','2024-10-29 04:49:33'),(269,'ru','parcel_baltics_new_button_message_extra','1. **Отправить через наш сервис** - В этом случае вам не нужно оплачивать доставку сразу. Однако получатель должен будет оплатить, когда получит посылку.\n2. **Отправить через почтовое отделение** - Вы оплачиваете доставку при отправке, и получателю не нужно будет ничего платить при получении.\n\nРешать вам, какой вариант подходит больше. 😊 Учтите, что существует лимит на количество отправок через наш сервис.','2024-10-29 04:39:42','2024-10-29 04:49:47'),(270,'et','parcel_baltics_new_button_message_extra','1. **Saada läbi meie teenuse** - Selle võimalusega ei pea te saatmise eest kohe maksma. Kuid saaja peab paki kättesaamisel tasuma.\n2. **Saada postkontori kaudu** - Maksate saatmise eest postitamise ajal ja saaja ei pea kättesaamisel midagi maksma.\n\nOtsus on täiesti teie, kumb valik teile paremini sobib. 😊 Pidage siiski meeles, et meie teenuse kaudu saadetavate pakkide arv on piiratud.','2024-10-29 04:40:04','2024-10-29 04:50:00'),(271,'en','upu_letter_unavailable','Unfortunately, this shipment type is currently under testing, and information is partially unavailable. We will provide updates once more data is gathered.','2024-10-29 05:20:14','2024-10-29 05:20:14'),(272,'ru','upu_letter_unavailable','К сожалению, этот тип отправления в настоящее время проходит тестирование, и информация частично недоступна. Мы предоставим обновления, как только будет собрано больше данных.','2024-10-29 05:20:14','2024-10-29 05:21:14'),(273,'et','upu_letter_unavailable','Kahjuks on see saadetise tüüp praegu testimisel ja teave on osaliselt kättesaamatu. Anname teada, kui rohkem andmeid on kogutud.','2024-10-29 05:20:41','2024-10-29 05:20:41'),(274,'en','error_saving_tracking','An error occurred while saving the tracking information. Please try again later.','2024-10-29 05:22:00','2024-10-29 05:22:00'),(275,'ru','error_saving_tracking','Произошла ошибка при сохранении информации об отслеживании. Пожалуйста, попробуйте позже.','2024-10-29 05:22:00','2024-10-29 05:22:00'),(276,'et','error_saving_tracking','Jälgimisteabe salvestamisel ilmnes tõrge. Palun proovige hiljem uuesti.','2024-10-29 05:22:16','2024-10-29 05:22:16'),(277,'en','access_denied_rejected_policy','Access denied. You have previously rejected the Terms of Service and Privacy Policy.','2024-11-14 00:51:51','2024-11-14 00:51:51'),(278,'ru','access_denied_rejected_policy','Доступ запрещен. Вы ранее отклонили Условия использования и Политику конфиденциальности.','2024-11-14 00:51:51','2024-11-14 00:51:51'),(279,'et','access_denied_rejected_policy','Juurdepääs keelatud. Olete varem teenusetingimused ja privaatsuspoliitika tagasi lükanud.','2024-11-14 00:52:09','2024-11-14 00:52:09'),(280,'en','declined_policy_cannot_use_service','You have declined our Terms of Service and Privacy Policy, and therefore access to this bot is temporarily unavailable. However, we understand that making decisions takes time. You can return and accept our terms in **14 days** to use the bot again.\n\nIf you have any questions or want to learn more about the terms, please contact our support. You can reach us either via email at `support@coonlink.fun` or through Telegram. Please note that our support is handled by qualified specialists. We will do our best to assist you as quickly as possible, but the wait time may vary.\n\nOperating hours: Monday through Saturday from `10:00 AM` to `7:00 PM`, and on Sunday from `10:00 AM` to `6:00 PM`.','2024-11-14 01:16:39','2024-11-14 01:48:19'),(281,'ru','declined_policy_cannot_use_service','Вы отказались принять Условия использования и Политику конфиденциальности, поэтому использование этого бота для вас временно недоступно. Однако мы понимаем, что иногда решение требует времени. Вы сможете вернуться и принять наши условия через **14 дней**, чтобы снова начать пользоваться ботом.\n\nЕсли у вас возникли вопросы или вы хотите узнать больше об условиях, пожалуйста, свяжитесь с нашей поддержкой. Вы можете обратиться к нам по электронной почте `support@coonlink.fun` или через Telegram. Пожалуйста, обратите внимание, что в поддержке работают квалифицированные специалисты. Мы постараемся помочь вам как можно быстрее, но ожидание может занять некоторое время.\n\nГрафик работы: с понедельника по субботу с `10:00` до `19:00`, в воскресенье с `10:00` до `18:00`.','2024-11-14 01:16:39','2024-11-14 01:40:14'),(282,'et','declined_policy_cannot_use_service','Olete keeldunud teenusetingimustest ja privaatsuspoliitikast, mistõttu pole selle boti kasutamine ajutiselt saadaval. Kuid me mõistame, et otsuste tegemine võtab aega. Saate **14 päeva** pärast tagasi tulla ja meie tingimused vastu võtta, et uuesti botiga alustada.\n\nKui teil on küsimusi või soovite tingimuste kohta rohkem teada saada, võtke ühendust meie klienditoega. Saate meiega ühendust võtta kas e-posti teel aadressil `support@coonlink.fun` või Telegrami kaudu. Pange tähele, et klienditeeninduses töötavad kvalifitseeritud spetsialistid. Anname endast parima, et teid võimalikult kiiresti aidata, kuid ooteaeg võib varieeruda.\n\nTööaeg: esmaspäevast laupäevani kell `10:00` kuni `19:00` ja pühapäeval kell `10:00` kuni `18:00`.','2024-11-14 01:17:15','2024-11-14 01:47:05'),(283,'en','support_mode_activated','✅ Support mode activated. Please describe your issue, and we will assist you as soon as possible. Press the \\\"End chat\\\" button when you wish to exit support mode.','2024-11-14 02:02:42','2024-11-14 02:02:42'),(284,'ru','support_mode_activated','✅ Режим поддержки включен. Пожалуйста, опишите свою проблему, и мы постараемся помочь вам как можно скорее. Нажмите кнопку \\\"Завершить диалог\\\", когда захотите выйти из режима поддержки.','2024-11-14 02:02:42','2024-11-14 02:02:42'),(285,'et','support_mode_activated','✅ Tugirežiim aktiveeritud. Kirjeldage oma probleemi, ja me püüame teid aidata võimalikult kiiresti. Vajutage nuppu \\\"Lõpeta vestlus\\\", kui soovite tugirežiimist väljuda.','2024-11-14 02:03:01','2024-11-14 02:03:01'),(286,'en','end_chat_button','End chat','2024-11-14 02:03:34','2024-11-14 02:03:34'),(287,'ru','end_chat_button','Завершить диалог','2024-11-14 02:03:34','2024-11-14 02:03:34'),(288,'et','end_chat_button','Lõpeta vestlus','2024-11-14 02:03:47','2024-11-14 02:03:47'),(289,'en','support_chat_ended','Support chat has been ended. Feel free to contact us again if you need further assistance!','2024-11-14 02:04:17','2024-11-14 02:04:17'),(290,'ru','support_chat_ended','Диалог с поддержкой завершен. Если возникнут дополнительные вопросы, не стесняйтесь обращаться!','2024-11-14 02:04:17','2024-11-14 02:04:17'),(291,'et','support_chat_ended','Vestlus tugiteenusega on lõpetatud. Kui vajate edasist abi, võtke kindlasti uuesti ühendust!','2024-11-14 02:04:35','2024-11-14 02:04:35'),(292,'en','start_support_chat_button','🆘 Enable support mode','2024-11-14 02:05:45','2024-11-14 02:05:45'),(293,'ru','start_support_chat_button','🆘 Включить режим поддержки','2024-11-14 02:05:45','2024-11-14 02:05:45'),(294,'et','start_support_chat_button','🆘 Luba tugirežiim','2024-11-14 02:06:16','2024-11-14 02:06:16'); UNLOCK TABLES; DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `username` varchar(255) DEFAULT NULL, `fake_eyes` int(3) DEFAULT 0, `admin` int(3) DEFAULT 0, `agreed_terms` varchar(250) DEFAULT 'pending', `first_name` text DEFAULT NULL, `last_name` text DEFAULT NULL, `language` varchar(10) DEFAULT NULL, `trackparcel` varchar(255) DEFAULT NULL, `notified` int(1) DEFAULT 0, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `current_ban_status` enum('temporary_ban','permanent_ban') DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `username` (`username`), KEY `fake_eyes` (`fake_eyes`), KEY `agreed_terms` (`agreed_terms`), KEY `agreed_terms_2` (`agreed_terms`), KEY `language` (`language`), KEY `trackparcel` (`trackparcel`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; LOCK TABLES `users` WRITE; INSERT INTO `users` VALUES (1,1347982128,'ankara_1261',0,0,'accepted','саня','','ru','0',1,'2024-10-25 13:01:58','2024-10-29 14:46:38','permanent_ban'),(2,1448631857,'gakskkdj',0,0,'accepted','Юпии','','ru','1',0,'2024-10-27 06:33:57','2024-10-29 03:02:51',NULL),(3,5392413644,'qwrudy',0,0,'pending','v potoke',NULL,'ru','1',0,'2024-10-21 22:34:38','2024-10-29 03:02:53',NULL),(4,5745970528,NULL,0,0,'accepted','CRC137',NULL,'ru','1',0,'2024-10-20 08:28:00','2024-10-31 21:54:24',NULL),(5,5924307463,'Isksnxx',0,0,'accepted','stasya',NULL,'ru','1',0,'2024-10-24 09:30:06','2024-10-29 03:02:56',NULL),(6,6033552306,'',0,0,'accepted','wwq','','ru','1',0,'2024-10-25 13:19:00','2024-10-29 03:02:58',NULL),(7,782821990,'CRC137',0,1,'accepted','Alberto','Clemente','ru','4',0,'2024-10-27 17:14:33','2024-11-15 00:36:54',NULL),(8,5021809923,'',0,0,'accepted','Виталий','','ru','1',0,'2024-10-28 11:38:10','2024-10-29 03:03:00',NULL),(10,1104305223,'',0,0,'accepted','Витя','','ru','0',0,'2024-10-29 12:26:08','2024-10-29 12:26:19',NULL),(11,1199115645,'Diffusials',0,0,'accepted','Singles','','ru','0',0,'2024-10-29 16:24:37','2024-10-29 16:24:49',NULL),(12,5295639538,'Olyarte',0,0,'accepted','Оля','','ru','0',0,'2024-10-30 06:06:00','2024-10-30 06:06:06',NULL),(13,714342337,'',0,0,'accepted','𝓔𝓵𝓲𝔃𝓪𝓿𝓮𝓽𝓪🦋','','ru','0',0,'2024-10-31 14:16:52','2024-10-31 14:16:56',NULL),(14,477997585,'ilonayurchuk',0,0,'accepted','Ilona','','ru','0',0,'2024-10-31 21:08:20','2024-10-31 21:08:28',NULL),(15,1015856667,'',0,0,'accepted','Irina','Anatolievna','ru','0',0,'2024-11-01 20:44:17','2024-11-01 20:44:31',NULL),(16,1235523751,'anet15205',0,0,'accepted','Ann','Antsibor','ru','0',0,'2024-11-04 11:32:19','2024-11-04 11:32:44',NULL),(17,402139348,'lizonka_kotik',0,0,'accepted','Лизавета','Мякота','ru','0',0,'2024-11-05 01:45:51','2024-11-05 01:45:55',NULL),(18,6946731815,'',0,0,'rejected','Victoria🤤','','ru','0',0,'2024-11-05 09:35:42','2024-11-05 09:35:48',NULL),(19,1297910684,'',0,0,'accepted','Аня','','ru','0',0,'2024-11-06 11:42:57','2024-11-06 11:43:22',NULL),(20,753367703,'curiousvlxd',0,0,'accepted','Vlad','','en','0',0,'2024-11-06 14:00:19','2024-11-06 14:00:21',NULL),(21,510136189,'sychfraud',0,0,'accepted','sychfraud','','ru','0',0,'2024-11-11 09:03:10','2024-11-11 09:03:12',NULL),(22,308021325,'',0,0,'accepted','Marta','','en','0',0,'2024-11-11 20:15:00','2024-11-11 20:17:36',NULL),(23,456195218,'dobryivechir18',0,0,'accepted','Ліза','','ru','0',0,'2024-11-12 02:05:54','2024-11-12 02:05:57',NULL),(24,5232734067,'Dansen457',0,0,'accepted','Serhii','Danylenko','ru','0',0,'2024-11-12 10:50:33','2024-11-12 10:50:36',NULL),(25,1177874859,'m_ary_d',0,0,'accepted','ஓ๑_m.a_ry_๑ஓ','','ru','0',0,'2024-11-12 12:39:14','2024-11-12 12:39:19',NULL),(26,931669172,'',0,0,'accepted','Лера','Прохорова','ru','0',0,'2024-11-13 09:23:38','2024-11-13 09:23:41',NULL),(27,1733746693,'',0,0,'pending','Diogo','Ambrosio','en','0',0,'2024-11-13 14:50:14','2024-11-13 14:50:14',NULL),(28,5541187591,'',0,0,'pending','搬运工','代发推广','en','0',0,'2024-11-13 15:00:40','2024-11-13 15:00:40',NULL),(29,5890753594,'',0,0,'rejected','Світлана Гарбузюк','','ru','0',0,'2024-11-14 19:31:19','2024-11-14 19:31:32',NULL),(30,6492558787,'',0,0,'pending','Виктория','Караневска','ru','0',0,'2024-11-15 08:20:23','2024-11-15 08:20:23',NULL),(31,1764019825,'',0,0,'accepted','V','S','ru','0',0,'2024-11-17 22:07:42','2024-11-17 22:07:45',NULL),(32,2129502082,'maniavska_katya',0,0,'accepted','kateryna','','ru','0',0,'2024-11-19 13:24:32','2024-11-19 13:24:38',NULL),(33,6954272430,'Viktoria_Horbachuk',0,0,'accepted','Viktoria','','ru','0',0,'2024-11-19 17:49:33','2024-11-19 17:49:42',NULL),(34,502155576,'zona_88',0,0,'accepted','Артем','','ru','0',0,'2024-11-21 21:22:51','2024-11-21 21:22:53',NULL),(35,892984982,'OGdrai',0,0,'accepted','OGdrai','','ru','1',0,'2024-11-23 11:38:22','2024-11-23 11:42:07',NULL),(36,707220801,'eden_art_studio',0,0,'accepted','Eden','','ru','0',0,'2024-11-23 19:57:54','2024-11-23 19:57:59',NULL),(37,2061742315,'Alina_Valentinowna',0,0,'accepted','Алина','','ru','0',0,'2024-11-24 06:41:34','2024-11-24 06:41:39',NULL),(38,1495349162,'kind94531',0,0,'accepted','Миша','','ru','0',0,'2024-11-24 08:09:40','2024-11-24 08:09:49',NULL),(39,663654872,'donttelmewhattodo',0,0,'accepted','Dima','Lima 🐾','ru','0',0,'2024-11-25 09:42:37','2024-11-25 09:42:40',NULL),(40,6908545561,'',0,0,'accepted','Keita','Sebre','en','0',0,'2024-11-25 10:49:34','2024-11-25 10:49:39',NULL),(41,1475274908,'n_kryvanio',0,0,'accepted','Настя','','ru','0',0,'2024-11-26 14:21:42','2024-11-26 14:22:14',NULL),(42,739719284,'Nataly_8816',0,0,'accepted','Nataliya','Zaichenko','ru','0',0,'2024-11-27 14:42:51','2024-11-27 14:42:59',NULL),(43,739719284,'Nataly_8816',0,0,'accepted','Nataliya','Zaichenko','ru','0',0,'2024-11-27 14:43:29','2024-11-27 14:43:31',NULL),(44,1001147544,'vmt1222',0,0,'accepted','Um','','ru','0',0,'2024-11-28 18:28:42','2024-11-28 18:28:46',NULL); UNLOCK TABLES;