-- MySQL dump 10.13  Distrib 8.0.36, for Linux (x86_64)
--
-- Host: localhost    Database: Galvanek_teams
-- ------------------------------------------------------
-- Server version	8.0.40-0ubuntu0.24.04.1

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

--
-- Table structure for table `teams_list`
--

DROP TABLE IF EXISTS `teams_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `teams_list` (
  `Zoho_Id` varchar(255) NOT NULL,
  `Team_Name` varchar(255) NOT NULL,
  `Vendor_Id` varchar(255) NOT NULL,
  `Vendor_Name` varchar(255) DEFAULT NULL,
  `Team_PLZ` varchar(15) DEFAULT NULL,
  `Latitude` varchar(20) DEFAULT NULL,
  `Longitude` varchar(20) DEFAULT NULL,
  `Created_At` date DEFAULT NULL,
  PRIMARY KEY (`Zoho_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `teams_list`
--

LOCK TABLES `teams_list` WRITE;
/*!40000 ALTER TABLE `teams_list` DISABLE KEYS */;
INSERT INTO `teams_list` VALUES ('424278000009338184','Team 1 - Judit Simon Vendor','424278000007670987','Judit Simon Vendor','37483','51.165691','10.451526','2025-01-13'),('424278000009512410','Team 4 - Judit Simon Vendor','424278000007670987','Judit Simon Vendor','123','51.165691','10.451526','2025-01-13'),('424278000009512415','Team 2 - Test Vendor','424278000004413075','Vision Sicherheitssysteme','70173','48.78270269999999','9.182862999999999','2025-01-13'),('424278000009540003','Team 2 Judit Simon Vendor','424278000007670987','Judit Simon Vendor','41242','51.165691','10.451526','2025-01-13'),('424278000009540008','Team 3 - Judit Simon Vendor','424278000007670987','Judit Simon Vendor','13144','51.165691','10.451526','2025-01-13'),('424278000009578057','Team 1 - Test Vendor','424278000011018035','Test mali vendor','70173','48.78270269999999','9.182862999999999','2025-01-13'),('424278000009590197','Team 3 - Test Vendor','424278000011101299','TEST MALI Emini Solar (Egzon)','90453','49.3757248','11.0346054','2025-01-13'),('424278000009590202','Team 4 - Test Vendor','424278000006760015','Fuwatech Elektrotechnik & Identifikation Meisterbetrieb','82296','48.13701450000001','11.200538','2025-01-13'),('424278000009592004','Team 5 - Test Vendor','unknown','','23422','51.165691','10.451526','2025-01-13'),('424278000009696070','Team 6 - Test Vendor','unknown','','6542','51.404673','11.3857674','2025-01-13'),('424278000010176756','Team 7 - Test Vendor','unknown','','234221','51.165691','10.451526','2025-01-13'),('424278000010176774','Team 8 - Test Vendor','424278000004278595','Emini Solar (Egzon)','90453','49.3757248','11.0346054','2025-01-13'),('424278000010210099','Team 1 - test developer vendor','424278000005014106','WayStrom GmbH','70173','48.78270269999999','9.182862999999999','2025-01-13'),('424278000010210119','Team 2 - test developer vendor','424278000005014106','WayStrom GmbH','70173','48.78270269999999','9.182862999999999','2025-01-13'),('424278000010210287','Team 3 - test developer vendor','unknown','','23421','51.165691','10.451526','2025-01-13'),('424278000010210307','Team 4 - test developer vendor','unknown','','23413','51.165691','10.451526','2025-01-13'),('424278000010211073','Team 1 - Steam Solarteur','424278000009919047','Steam Solarteur','85521','48.0598428','11.6681224','2025-01-13'),('424278000010211121','Team 2 - Steam Solarteur','424278000009919047','Steam Solarteur','85521','48.0598428','11.6681224','2025-01-13'),('424278000010218532','Team 3 - Steam Solarteur','424278000009919047','Steam Solarteur','85521','48.0598428','11.6681224','2025-01-13'),('424278000010223035','Team 9 - Test Vendor','unknown','','23429','51.165691','10.451526','2025-01-13'),('424278000010359089','Team 1 - Galvanek DC Marian','424278000007747016','Galvanek DC Marian','91466','49.6297064','10.6945405','2025-01-13'),('424278000010604021','Team 1 - SLE-TEK UG','424278000004260017','SLE-TEK UG','79713','47.5749447','7.982216900000001','2025-01-13'),('424278000010677116','Team 1 - BOSD Service GmbH','424278000006469003','BOSD Service GmbH','95643','49.877961','12.3187354','2025-01-13'),('424278000010687403','Team 1 Kösters Solarservice GmbH','424278000004217074','Kösters Solarservice GmbH','48619','52.1204646','7.1048718','2025-01-13'),('424278000010918187','Team 1 - Astro Montage GmbH & Co.KG','424278000004217019','Astro Montage GmbH & Co.KG','61231','50.3822571','8.7387728','2025-01-13'),('424278000011000118','Team 2 - Kösters Solarservice GmbH','424278000004217074','Kösters Solarservice GmbH','48619','52.1204646','7.1048718','2025-01-13'),('424278000011018058','Test mali team 1','424278000005896001','Krasniqi Shpetim','70173','48.78270269999999','9.182862999999999','2025-01-13'),('424278000011020513','Test M Ali 2','424278000011020388','Test M Ali 2','70173','48.78270269999999','9.182862999999999','2025-01-13'),('424278000011088122','Team 1 - Galvanek Sinisa AC','424278000007292137','Galvanek Sinisa AC','91466','49.6297064','10.6945405','2025-01-13'),('424278000011095141','Test Enc 1','424278000011095110','TEST Rab Emini Solar (Egzon)','90453','49.3757248','11.0346054','2025-01-13'),('424278000011099313','Team 1 - S&M Bau','424278000008449018','S&M Bau','91629','49.3555791','10.6281722','2025-01-13'),('424278000011126257','Team 1 - test vendor','424278000011126007','test vendor','234221','51.165691','10.451526','2025-01-13'),('424278000011132008','Team 2 - test vendor','424278000011126007','test vendor','23422','51.165691','10.451526','2025-01-13'),('424278000011159004','Team 3 - test vendor','424278000011126007','test vendor','23421','51.165691','10.451526','2025-01-13'),('424278000011162001','Team 4 - test vendor','424278000011126007','test vendor','234221','51.165691','10.451526','2025-01-13'),('424278000011197321','Team 4 - Steam Solarteur','424278000009919047','Steam Solarteur','85521','48.0598428','11.6681224','2025-01-13'),('424278000011214020','Team 4 - Vendor Search test','424278000011235005','Vendor Search test','85521','48.0598428','11.6681224','2025-01-13'),('424278000011223025','Team 3 - Vendor Search test','424278000011235005','Vendor Search test','85521','48.0598428','11.6681224','2025-01-13'),('424278000011223036','Team 5 - Steam Solarteur','424278000009919047','Steam Solarteur','85521','48.0598428','11.6681224','2025-01-13'),('424278000011233017','Team 2 - Vendor Search test','424278000011235005','Vendor Search test','85521','48.0598428','11.6681224','2025-01-13'),('424278000011246017','Team 5 - Vendor Search test','424278000011235005','Vendor Search test','85521','48.0598428','11.6681224','2025-01-13'),('424278000011251151','Team 1 - Vendor Search test','424278000011235005','Vendor Search test','85521','48.0598428','11.6681224','2025-01-13'),('424278000011251231','Team 1 - skibiddytoilette','424278000011251194','skibiddytoilette','82008','48.0650187','11.6175944','2025-01-13'),('424278000011506009','Team 2 - Kosmobauer GbR','424278000004252124','Kosmobauer GbR','46535','51.5591279','6.7313988','2025-01-13'),('424278000011581130','Sinisa','424278000007292137','Galvanek Sinisa AC','91466','49.6297064','10.6945405','2025-01-13');
/*!40000 ALTER TABLE `teams_list` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2025-01-13 11:38:31
