

#
# Data for table "cache_locks"
#


#
# Structure for table "email_messages"
#

CREATE TABLE `email_messages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `chapter` tinyint(1) NOT NULL DEFAULT '0',
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

#
# Data for table "email_messages"
#


#
# Structure for table "email_attachments"
#

CREATE TABLE `email_attachments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email_message_id` bigint unsigned NOT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filepath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `email_attachments_email_message_id_foreign` (`email_message_id`),
  CONSTRAINT `email_attachments_email_message_id_foreign` FOREIGN KEY (`email_message_id`) REFERENCES `email_messages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

#
# Data for table "email_attachments"
#


#
# Structure for table "email_selections"
#

CREATE TABLE `email_selections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `chapter` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EV',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

#
# Data for table "email_selections"
#


#
# Structure for table "email_templates"
#

CREATE TABLE `email_templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `chapter` tinyint(1) NOT NULL DEFAULT '0',
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

#
# Data for table "email_templates"
#


#
# Structure for table "failed_jobs"
#

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

#
# Data for table "failed_jobs"
#


#
# Structure for table "job_batches"
#

CREATE TABLE `job_batches` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

#
# Data for table "job_batches"
#


#
# Structure for table "migrations"
#

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

#
# Data for table "personal_access_tokens"
#


#
# Structure for table "sadresar"
#

CREATE TABLE `sadresar` (
  `id` int NOT NULL AUTO_INCREMENT,
  `odkaz_sjednotka` int NOT NULL DEFAULT '0',
  `odkaz_subjekt` int NOT NULL DEFAULT '0',
  `odkaz_pohoda` int NOT NULL DEFAULT '0',
  `selectedAD` tinyint NOT NULL DEFAULT '0',
  `Pronajem` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'NE',
  `Pronajem_Od` date DEFAULT NULL,
  `Pronajem_Do` date DEFAULT NULL,
  `Nazev_Uctu` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Najem` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Sluzby` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Jistota` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Najem_zvys` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Najem_zvys_Od` date DEFAULT NULL,
  `poradi` int NOT NULL DEFAULT '0',
  `Jmeno` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Prijmeni` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Titul` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Osloveni` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `RC` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Firma_Ok` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'NE',
  `Firma` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `ICO` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `DIC` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Info` mediumblob,
  `Info_R` text CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci,
  `Info_zobraz` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'NE',
  `Pocet_osob` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Poznamka_JM` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Poznamka_Obdobi` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Ulice_Pred` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `C_Domu_Pred` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `PSC_Pred` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Mesto_Pred` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Zeme_Pred` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Poznamka_Adresa_Pred` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Ulice_Naj` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `C_Domu_Naj` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `PSC_Naj` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Mesto_Naj` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Zeme_Naj` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Poznamka_Adresa_Naj` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Telefon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Mobil` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `WWW` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Datova_Schranka` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Cislo_Uctu` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Kod_Banky` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Poznamka_Spojeni` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Poznamka` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Oznacil` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Editoval` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Vytvoril` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=273 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_czech_ci ROW_FORMAT=DYNAMIC;

#
# Data for table "sadresar"
#

INSERT INTO `sadresar` VALUES (1,0,1,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Daniela','HorĂˇkovĂˇ','','','','NE','',' ','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(2,0,2,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Alena','Bennour','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(3,298,3,0,1,'NE','2020-03-04','2020-08-31','','0','0','0','0',NULL,0,'Aneta','HusĂˇkovĂˇ','','','','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(4,309,4,0,1,'NE','2017-08-23','2019-10-20','','0','0','0','0',NULL,0,'Anna','JurĂˇĹovĂˇ','','','915715/2829','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(5,0,5,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'TomĂˇĹˇ','BĂˇrta','','','81 01 28/28','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(6,0,6,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Ĺ tÄ›pĂˇn','BartoĹˇ','','','67 11 17/00','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(7,0,7,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'VĂˇclav','Birkner','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(8,323,8,66033,1,'NE','2016-09-01','2023-03-31','','6500','850','15000','7500','2023-04-01',0,'Zdena','CmĂ­ralovĂˇ','','','','NE','','','',X'3C703E2D204EC3A16A656D6EC3A920446F20C599C3AD6A6E612E32303231202D2035353530206BC48D3C2F703E','- AktuĂˇlnĂ­ nĂˇjem 5 550 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 6 500 kÄŤ','NE','2','Od 2/2021 - 2 osoby.','','','','','','CZ','sss','','','','','CZ','','','734 708 648','z.cmiralova@seznam.cz','','','277285977','0300','','','','@','@'),(10,286,10,65995,1,'ANO','2018-01-07',NULL,'','0','0','0','0',NULL,0,'Daniel','Marek','','','92 04 29/ 3065','NE','','','',X'','','NE','2','','','ModlanskĂˇ','704','41501','Teplice','CZ','TĹ™etĂ­ byt v pronĂˇjmu','','','','','CZ','','','777 800 094','daniel-marek@email.cz','','','2034557033','3030','','','','@','@'),(11,305,10,0,1,'NE','2016-01-01','2016-05-25','','0','0','0','0',NULL,0,'Daniel','Marek','','','92 04 29/3065','NE','','','',X'','','NE','1','','','JateÄŤnĂ­','1837','41501','Teplice','CZ','DruhĂ˝ byt v pronĂˇjmu','','','','','CZ','','','','','','','','','','','','@','@'),(12,470,10,0,1,'ANO','2019-01-01',NULL,'','0','0','0','0',NULL,0,'Daniel','Marek','','','92 04 29/3065','NE','','','',X'','','NE','1','','','ÄŚs. LegiĂ­','579/10','415 01','Teplice','CZ','RodiÄŤe','','','','','CZ','','','777 800 094','','','','','','','','','@','@'),(13,301,13,0,1,'NE','2014-07-17','2021-04-05','','0','0','0','0',NULL,0,'David','KadlÄŤek','','','780110/2848','NE','','','',X'','','NE','4','','','','','','','CZ','','','','','','CZ','','','773 647 263','Djk78@centrum.cz','','','1663583010','3030','','','@','@','@'),(14,284,14,0,1,'NE','2015-10-30','2015-10-30','','0','0','0','0',NULL,0,'David','Schiffer','','','760515/2313','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(15,293,15,0,1,'NE','2014-09-01','2014-09-01','','0','0','0','0',NULL,0,'David','Wiedemann','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(16,0,16,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'JiĹ™Ă­','ZahrĂˇdka','','','','ANO','EKUS spol. s.r.o. ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(17,378,17,0,1,'NE','2020-02-28','2022-01-26','','0','0','0','0',NULL,0,'EliĹˇka','ObrusnĂ­kovĂˇ','','','','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','608 467 066','','','','','','','','','@','@'),(18,0,18,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Pavel','Fiala','','','810408/2855','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(19,313,19,65553,1,'NE','2012-01-01','2022-02-28','','12000','0','0','0',NULL,0,'Gustav','SĂ­gl','','','','ANO','Gustav SĂ­gl-Stodola','67850774','CZ7311302856',X'','','NE','0','','','','','','','CZ','','','','','','CZ','','','602 697 331','gustav.sigl@seznam.cz','','','','','','','@','@','@'),(20,284,20,65953,1,'ANO','2015-11-01',NULL,'','8060','840','21500','9000','2023-01-01',0,'Hana','DohnalovĂˇ','','','495729/124','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','774 837 830','hanka.d49@seznam.cz','','','100159270','0300','','','@','@','@'),(21,0,21,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Hana','ZgrochovĂˇ','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(22,333,22,0,1,'NE','2016-01-01','2022-12-31','','5000','0','0','0',NULL,0,'Milan','Sluka','','','','ANO','Horizont obchod s.r.o.','27300803','CZ27300803',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','603111195','sluka@horizontobchod.cz','','','','','','','@','@','@'),(23,0,23,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Anna','IlleĹˇovĂˇ','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(24,314,24,65558,1,'NE','2004-07-01','2024-03-01','','8000','0','0','12000','2023-04-01',0,'Ilona','HrabĂˇkovĂˇ','','','','ANO','Ilona HrabĂˇkovĂˇ-LINIE','','',X'','','NE','2','','','','','','','CZ','','V zĂˇvÄ›tĹ™Ă­','1672/4','415 01','Teplice','CZ','','','777 049 553, prĂˇce 603 174 705','ilonahrab@centrum.cz','','','','','','','@','@','@'),(25,295,25,66027,1,'NE','2017-08-09','2022-04-30','','5700','420','12000','6000','2023-01-01',0,'Irena','MakoĹˇovĂˇ','','','54 56 30/0641','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','723 427 413','martina.e@seznam.cz','','','709245013','0800','','','','@','@'),(26,0,26,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Ivana','TichĂˇ','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(27,0,27,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Jakub','Sehnoutka','','','920124/3051','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','722163582','','','','','','','','@','@','@'),(28,290,28,65911,1,'ANO','2014-05-01',NULL,'','6200','750','13500','7500','2023-04-01',0,'Jakub','VorĂˇÄŤ','','','890103/3053','NE','','','',X'3C703E72746872747A68723C2F703E','','NE','2','','','','','','','CZ','','','','','','CZ','','','724 742 062 CHA','vorac@seznam.cz','','','1046546011','3030','','','@','@','@'),(29,302,29,0,1,'NE','2016-06-06','2016-06-06','','0','0','0','0',NULL,0,'Jan','KaĹˇpar','','','910713/3057','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(30,0,30,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Jan','Puchr','','','841227/2913','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(31,0,31,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Jan','VrĹˇeckĂ˝','','','841023/2765','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(32,0,32,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Jana','TremlovĂˇ','','','84 62 06/2840','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','776 604 511','','','','','','','','@','@','@'),(33,0,33,0,0,'NE','2012-07-20','2012-10-05','','0','0','0','0',NULL,0,'Jaroslav','Brabenec','','','781117/0488','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(34,285,34,0,1,'NE','2013-04-26','2013-04-26','','0','0','0','0',NULL,0,'Jaroslava','MerhautovĂˇ','','','585110/0992','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(35,0,35,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'KateĹ™ina','JelĂ­nkovĂˇ','','','826018/2843','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(36,272,36,65839,1,'NE','2012-04-26','2023-11-30','','8000','6000','15000','0',NULL,0,'JindĹ™ich','Fiedler','','','','ANO','PrĂˇdelna Bublinka','10454802','CZ6609301105',X'','','NE','1','','','','','','','CZ','','U HornĂ­ drĂˇhy','624','417 42','Krupka','CZ','','','603 320 150','kuba.fiedler@seznam.cz','','','253465826','0300','','','@','@','@'),(37,304,37,65567,1,'ANO','2010-09-29',NULL,'','5200','320','0','5700','2023-01-01',0,'ZdenÄ›k','JĂ­rava','','','50 08 21/25','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','602 930 317','NEMĂ EMAIL','','','1978449019','3030','','','@','@','@'),(38,0,38,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Zuzana','JĂ­ravovĂˇ','','','74 06 25/43','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(39,286,39,0,1,'NE','2017-09-26','2017-09-26','','0','0','0','0',NULL,0,'JiĹ™ina','WolfovĂˇ','','','655105/1540','NE',' ',' ','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(40,0,40,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Jitka','KonviÄŤkovĂˇ','','','876002/3129','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(41,315,41,0,1,'NE','2015-06-05','2015-06-05','','0','0','0','0',NULL,0,'Josef','Keller','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(42,0,42,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Karel','DraĹˇar','','','510531/206','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(43,316,43,66114,1,'NE','2019-09-07','2024-03-01','','7500','850','14000','0',NULL,0,'KarolĂ­na','RĹŻĹľiÄŤkovĂˇ','','','946022/3047','NE','','','',X'','','NE','3','','','','','','','CZ','','','','','','CZ','','','776 322 822','karolinafurstova94@seznam.cz','','','2909932183','0800','','','','@','@'),(44,285,44,65828,1,'ANO','2013-04-27',NULL,'','9060','1260','21000','10000','2023-01-01',0,'KateĹ™ina','KoĹˇĹĄĂˇlovĂˇ','','','785223/2916','NE','','','',X'','','NE','3','','','','','','','CZ','','','','','','CZ','','','727 857 755','katkakostalova@post.cz','','','107-2337100217','0100','','','@','@','@'),(45,326,45,0,1,'NE','2020-03-01','2020-09-17','','0','0','0','0',NULL,0,'KateĹ™ina','PolĂˇÄŤkovĂˇ','','','94 51 14/3053','NE','','','',X'','','NE','1.83','','NS ukonÄŤena dne 17.9.2020, ale pro vĂ˝poÄŤet sluĹľby-el.en. byl datum zkrĂˇcen.','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(46,0,46,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Pavel','Kima','','','70 01 01/28','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(47,0,47,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'OldĹ™ich','KĂłnig','','','32 10 04/05','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(48,0,48,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Miroslava','KurucovĂˇ','','','51 52 25/05','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(49,332,49,65944,1,'NE','2015-06-25','2023-07-31','','5550','750','10000','0',NULL,0,'Ladislav','MichalÄŤĂ­k','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','704 151 618','ladislavmichalcik1@seznam.cz','','','4232711053','0800','','','@','@','@'),(50,279,50,66029,1,'ANO','2017-04-13',NULL,'','4000','200','8000','5000','2023-01-01',0,'Lenka','FialovĂˇ','','','','ANO','Fyzioterapie Lenka FialovĂˇ, Dis.','03683648','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','607 049 077K','lena.fialka@gmail.com','','','','','','','','@','@'),(51,0,51,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Lenka','Ĺ˝ĂˇkovĂˇ','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','170384676','0300','','','@','@','@'),(52,0,52,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Libor','Hartman','','','710110/1447','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(53,0,53,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'LuboĹˇ','Wolf','','','591207/1165','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(54,0,54,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Lucie','GajdoĹˇovĂˇ','','','875914/3107','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(55,320,55,0,1,'NE','2019-06-27','2019-11-08','','0','0','0','0',NULL,0,'Lucie','RansdorfovĂˇ','','','98 59 19/3069','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(56,293,56,65931,1,'ANO','2014-10-19',NULL,'','5700','420','13140','6000','2023-01-01',0,'Dmitry','Lychev','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','608 449 630 K','neodim000@seznam.cz','','','2155101163','0800','','','@','@','@'),(57,0,57,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'','','','','','ANO','MalĂ­Ĺ™skĂ© centrum barvy az, s. r.o.','25488503','CZ25488503',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(58,281,58,0,1,'NE','2019-09-01','2020-03-04','','0','0','0','0',NULL,0,'Marek','Malota','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(59,0,59,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'VÄ›ra','MareĹˇovĂˇ','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','2070377013','0800','','','@','@','@'),(60,0,60,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Martin','Barva','','','710426/2660','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(61,0,61,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Martin','Birkner','','','','ANO','Martin BIRKNER','88667197','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(62,0,62,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Martin','KolĂˇÄŤnĂ˝','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(63,0,63,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Martin','PodsednĂ­k','','','','ANO','Martin PodsednĂ­k - REGAL BIKE','63789876','CZ 6904062836',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','78-7292480297','0100','','','@','@','@'),(64,0,64,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Martina','BernĂˇĹˇkovĂˇ','','','855528/3110','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(65,324,65,66127,1,'NE','2020-03-01','2021-04-04','','0','0','0','0',NULL,0,'Martina','Ĺ˝ĂˇrovĂˇ','','','905911/3074','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','723 391 476','sellena2@seznam.cz','','','194925561','0600','','','','@','@'),(66,297,66,0,1,'NE','2017-08-31','2019-01-08','','0','0','0','0',NULL,0,'Zuzana','KriĹˇkovĂˇ','Mgr.','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(67,327,67,65873,1,'NE','2012-12-14','2024-03-01','','6500','2050','15000','0',NULL,0,'Michael','NovĂˇk','','','780513/2236','NE','','','',X'3C703E4EC3A16A656D6EC3A920446F20C599C3AD6A6E612E32303231202D2035353530206BC48D3C62723E3C2F703E','- AktuĂˇlnĂ­ nĂˇjem 5 550 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 6 500 kÄŤ','NE','3','','','','','','','CZ','','','','','','CZ','','605 265 618 HajmanovĂˇ Nicola','737 188 824','nbart@seznam.cz','','','217156225','0600','','','@','@','@'),(68,306,68,65973,1,'NE','2016-02-10','2021-08-08','','0','0','0','0',NULL,0,'Michaela','KaĹˇparovĂˇ','','','93 60 20/3039','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','+420 728 737 847','728 737 847','misa.kasparova93@seznam.cz','','','1325185001','2700','','','','@','@'),(69,326,69,66136,1,'NE','2020-09-23','2024-03-01','','6500','420','12500','0',NULL,0,'Michaela','MatouĹˇkovĂˇ','','','','NE','','','',X'3C703E2D204EC3A16A656D6EC3A920446F20C599C3AD6A6E612E32303231202D2035353530206BC48D3C62723E3C2F703E','- AktuĂˇlnĂ­ nĂˇjem 5 550 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 6 500 kÄŤ','NE','1','','','','','','','CZ','','','','','','CZ','','','608 001 855','michaela.maty@seznam.cz','','','189139267','0600','','','','@','@'),(70,298,70,0,1,'NE','2018-03-12','2019-12-31','','0','0','0','0',NULL,0,'Michaela','SyĹ™iĹˇĹĄovĂˇ','','','91 55 19/3047','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(71,325,71,66117,1,'NE','2019-11-06','2021-02-28','','0','0','0','0',NULL,0,'Michaela','Ĺ tÄ›pĂˇnkovĂˇ','','','99 58 03/3052','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','601 325 674','mist.zs@seznam.cz','','','38199991','5500','','','','@','@'),(72,326,72,0,1,'NE','2018-12-12','2020-02-28','','0','0','0','0',NULL,0,'Michaela','VyhnalovĂˇ','','','94 57 27/3056','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(73,0,73,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Petr','MikuleckĂ˝','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(74,351,74,66073,1,'NE','2018-04-01','2022-11-30','','1650','0','0','0',NULL,0,'Milan','CHVĂTAL','','','','ANO','MY-DOMA, Milan CHVĂTAL','61510831','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','774 484 394','','','','','','','','','@','@'),(75,0,75,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Miloslav','JanouĹˇek','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(76,0,76,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Miroslav','Hochmal','','','360522/083','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(77,0,77,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Miroslav','JanouĹˇek','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(78,0,78,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Miroslav','RybĂˇĹ™','','','791107/0189','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(79,0,79,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Miroslav','Ĺ enk','','','580217/0605','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(80,292,80,65918,1,'ANO','2014-09-17',NULL,'','7500','750','15000','7800','2023-01-01',0,'NadÄ›Ĺľda','RosĂˇkovĂˇ','','PanĂ­','605825/1100','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','723 832 415CHA','jirkajirka1@centrum.cz','','','291896475','0300','','','@','@','@'),(81,281,81,0,1,'NE','1997-12-30','2018-09-30','','0','0','0','0',NULL,0,'Jana','NeÄŤasovĂˇ','','','51 54 14/18','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(83,326,83,0,1,'NE','2013-02-01','2018-12-04','','0','0','0','0',NULL,0,'Petr','JelĂ­nek','','','590110/0601','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(84,294,84,0,1,'NE','2016-06-19','2016-06-19','','0','0','0','0',NULL,0,'Petr','KubĂ­k','','','920120/3055','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(86,0,86,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Petr','Neumann','','','841209/1402','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(87,259,87,66041,1,'ANO','2017-09-01',NULL,'','15000','2500','30000','0',NULL,0,'Petr','ZITA','','','','ANO','Petr ZITA','06213081','CZ06213081',X'','','NE','1','p. ZĂ­tovĂˇ str. 731 415 482, ZĂ­tovĂˇ ml. 731 119 120','','','','','','CZ','','','','','','CZ','','','603 243 000','i.zitova@seznam.cz','www.barvyhet.cz','','','','','','','@','@'),(88,0,88,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Renata','KohlmistrovĂˇ','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(89,319,89,65938,1,'NE','2015-06-01','2024-03-01','ÄŚeskĂˇ spoĹ™itelna','7500','1310','18000','8500','2023-04-01',0,'RenĂ©','SCHULDES','','','','NE','','','',X'3C703E4EC3A16A656D6EC3A920446F20C599C3AD6A6E612E32303231202D2036353530206BC48D3C62723E3C2F703E','- AktuĂˇlnĂ­ nĂˇjem 6 550 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 7 500 kÄŤ','ANO','4','','','','','','','CZ','','','','','','CZ','','','731 057 267','rendyyy101@centrum.cz','','','2814112123','0800','','','@','@','@'),(90,325,90,0,1,'NE','2010-12-16','2019-10-31','','0','0','0','0',NULL,0,'Pavla','Rubinsteinova','','','855612/3114','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','1719779013','0800','','','@','@','@'),(91,305,91,65984,1,'ANO','2016-05-27',NULL,'','6700','1020','16500','7000','2023-01-01',0,'Rudolf','HorÄŤic','','','74 05 17/2841','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','773 319 288CHA','cudla1@email.cz','','','2060820093','0800','','','','@','@'),(92,0,92,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Rudolf','Tvrz','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(93,316,93,0,1,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Semjon','KuiĹˇ','','','','ANO','Semjon KuiĹˇ','69397317','',X'','','NE','1','','','','','','','CZ','','KruĹˇnohorskĂˇ','1569/9','415 01','Teplice','CZ','','','','','','','1705654017','3030','','','','@','@'),(94,315,94,65940,1,'NE','2015-06-05','2024-03-01','','7500','850','15000','0',NULL,0,'Semjon','KuiĹˇ ml.','','','891108/3038','NE','','','',X'','','NE','3','','','','','','','CZ','','','','','','CZ','','','720 299 607','senakuis@seznam.cz','','','','','','','@','@','@'),(95,320,95,0,1,'NE','2014-03-03','2019-06-27','','0','0','0','0',NULL,0,'Simona','SchlenzovĂˇ','','','765301/2851','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(96,0,96,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Simona','SchlenzovĂˇ','','','765301/2851','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(97,328,97,0,1,'NE','2013-06-29','2013-06-29','','0','0','0','0',NULL,0,'Petr','Sobek','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(98,380,98,0,1,'NE','2020-05-01','2020-09-14','','0','0','0','0',NULL,0,'Stanislav','ManÄŤĂ­k','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(99,296,99,65604,1,'NE','2010-09-29','2021-07-11','','0','0','0','0',NULL,0,'ZdenÄ›k','Synek','','','73 11 09/28','NE','','','',X'','','NE','3','','','','','','','CZ','','','','','','CZ','','','777 043 043','','','','','','','','@','@','@'),(100,0,100,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Ĺ Ăˇrka','FiĹˇerovĂˇ','','','845625/2838','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(101,0,101,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Stanislava','Ĺ indelĂˇĹ™ovĂˇ','','','29 54 16/06','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(102,302,102,65990,1,'NE','2016-07-18','2023-06-30','','5200','420','12000','5700','2023-01-01',0,'JaromĂ­r','Ĺ tefan','','','650703/1575','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','728 159 595','jarominator@email.cz','','','125088763','0300','','','','@','@'),(103,308,103,0,1,'NE','2016-05-13','2021-08-04','','0','0','0','0',NULL,0,'Tereza','EliĂˇĹˇovĂˇ','','','93 53 16/2962','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','732 621 673','teliasova@gmail.com','','','7454586001','5500','','','','@','@'),(104,0,104,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Eva','Thigel (KleÄŤkovĂˇ)','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(105,298,105,66134,1,'NE','2020-09-01','2022-02-28','','5200','420','13500','0',NULL,0,'TomĂˇĹˇ','KolĂ­ÄŤek','','','94 07 24/3043','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','608 980 844','tomaskolicek@seznam.cz','','','237541227','0600','','','','@','@'),(106,0,106,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'TomĂˇĹˇ','LibĂˇnskĂ˝','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(107,0,107,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'TomĂˇĹˇ','Louda','','','830329/2844','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(108,307,108,65951,1,'NE','2015-09-27','2021-07-31','','0','0','0','0',NULL,0,'VĂˇclav','Pergler','','','','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','739 267 895','pergler.v@seznam.cz','','','115-3579380287','0100','','','@','@','@'),(109,0,109,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'VĂˇclav','RychtaĹ™Ă­k','','','820227/2859','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(110,0,110,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Valta','Petr','','','64 03 10/07','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(111,0,111,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Miroslav','VelĂ­Ĺˇek','','','32 06 26/10','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(112,291,112,0,1,'NE','2017-10-26','2020-06-05','','0','0','0','0',NULL,0,'Vendula','MecelovĂˇ','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','vendula.mecelova@gmail.cz','','','','','','','','@','@'),(113,309,113,66116,1,'NE','2019-10-21','2023-02-28','','5700','840','15000','6000','2023-01-01',0,'Vendula','SamusovĂˇ','','','005710/3134','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','735 919 840','vendy.samusova@seznam.cz','','','220889745','0600','','','','@','@'),(114,294,114,65985,1,'ANO','2016-06-20',NULL,'','6700','420','0','7000','2023-01-01',0,'Veronika','SoukupovĂˇ','','','92 54 22/3055','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','776 673686AK','verusoukupova92@gmail.com','','','1483000017','3030','','','','@','@'),(115,295,115,0,1,'NE','2017-08-08','2017-08-08','','0','0','0','0',NULL,0,'Veronika','UlrichovĂˇ','','','90 55 08/3049','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(116,320,116,66118,1,'NE','2019-11-09','2024-03-01','','7500','840','19500','8500','2023-01-01',0,'VladimĂ­r','Kovalenko','','','97 06 16/3115','NE','','','',X'3C703E2D204EC3A16A656D6EC3A920446F20C599C3AD6A6E612E32303231202D2036353530206BC48D3C62723E3C2F703E','- AktuĂˇlnĂ­ nĂˇjem 6 550 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 7 500 kÄŤ','ANO','2','','','','','','','CZ','','','','','','CZ','','','721 049 362','kovalenko-v@seznam.cz','','','214087746','0600','','','','@','@'),(117,303,117,65538,1,'ANO','2017-04-01',NULL,'','6200','320','0','6700','2023-01-01',0,'Josef','Vladyka','','','55 07 19/0700','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','724 160 584','nemĂˇ email','','','nemĂˇ ĂşÄŤet','','','','@','@','@'),(118,0,118,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'FrantiĹˇek','VostrovskĂ˝','','','53 01 25/25','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(119,328,119,65879,1,'NE','2013-06-30','2023-07-31','','6500','420','15000','0',NULL,0,'ZdenÄ›k','Kahoun','','','500307/163','NE','','','',X'3C703E4EC3A16A656D6EC3A920446F20C599C3AD6A6E612E32303231202D2035353530206BC48D3C62723E3C2F703E','- AktuĂˇlnĂ­ nĂˇjem 5 550 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 6 500 kÄŤ','NE','1','','UkonÄŤil najemnĂ© v bytÄ› ÄŤ.6 17.7.2023, ale platil nĂˇjemnĂ©+sluĹľby do 7/23 a od 8/23 platil za byt ÄŤ.1 (v dobÄ› 7-8/23 mÄ›l oba byty-stÄ›hoval se postupnÄ›).','','','','','CZ','','','','','','CZ','','','737 947 587','Pamatkar007@seznam.cz','','','274872690','0300','','','@','@','@'),(120,0,120,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'ZdenÄ›k','KubĂ­k','','','','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(121,291,121,66131,1,'ANO','2020-07-14',NULL,'','5700','420','9600','6000','2023-01-01',0,'ZdenÄ›k','Lipert','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','732 529 008 K','zaloĹľit prosĂ­m email !!!','','','2400885935','2010','','','','@','@'),(122,276,122,65659,1,'ANO','2007-05-01',NULL,'','8000','0','0','',NULL,0,'ZdenÄ›k','PavlĂ­k','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','777 575 851,K','pavcus37@seznam.cz','','','','','','','@','@','@'),(123,0,123,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'ZdÄ›nka','StarcovĂˇ','','','78 53 08/2336','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(124,0,124,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'Zuzana','HurychovĂˇ','','','655101/1467','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(125,257,125,0,1,'ANO','2020-01-01',NULL,'','4000','0','0','0',NULL,0,'Dalibor','BatĂ­k','','','','ANO','TruhlĂˇrna BatĂ­k','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','777210600','','','','batikdalibor@gmail.com','','','','@','@','@'),(126,264,126,0,0,'NE','2015-01-23','2025-02-27','','6500','1500','18000','6500','2021-11-01',0,'Barbora','BohatovĂˇ','','','','NE','','','',X'','','NE','4','','','','','','','CZ','','','','','','CZ','','','722261928','barborka.bohatova@seznam.cz','','','8003437001','5500','kontrola banky Raiffeisenbank','','@','@','@'),(127,350,127,0,0,'NE','2018-03-01','2021-09-30','','12000','2000','12000','0',NULL,0,'David','CĂ­saĹ™','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(128,263,128,0,0,'ANO','2012-07-17',NULL,'','12000','800','30000','12000','2021-12-01',0,'LuboĹˇ','PokornĂ˝','Mudr.','','','ANO','Mudr. LuboĹˇ PokornĂ˝','00708852','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','+420 417 535 873  - ordinace','604279250 - soukromĂ­','info@lekardubi.cz, jlp@centrum.cz','','','0207637033','0600','Pan PokornĂ˝ preferuje email: jlp@centrum.cz, provedena kontrola ĂşÄŤtu nĂˇjemce Moneta money bank','','@','@','@'),(129,262,129,0,0,'NE','2002-10-22','2022-09-30','','10000','0','0','10000','2021-12-01',0,'Ladislava','Ĺ imanovĂˇ','Mudr.','','','ANO','Mudr. Ladislava Ĺ imanovĂˇ','47767138','',X'3C703E3C62723E3C2F703E3C703E372E31302E3231206F6465736CC3A16E20456D61696C207320646F6461746B656D206F207A76C3BDC5A1656EC3AD204EC3A16A6D7520732070726F73626F75206F20466565646261636B20646F2031342E31302E266E6273703B3C62723E3C2F703E3C703E3C62723E3C2F703E','Info pro rychlou informaci->zĂˇpis je moĹľnĂ˝ pro kaĹľdĂ©ho nĂˇjemnĂ­ka v jeho formulĂˇĹ™i','ANO','1','','','','','','','CZ','','','','','','CZ','','','721741199, 417 882 945','simanova.ladislava@seznam.cz','','','000174-0363535784','0600','Je v ordinaci jenom od pondÄ›li aĹľ ÄŤtvrtek od 7-11 hod.','','@','@','@'),(130,270,130,0,0,'NE','2013-11-19','2021-09-30','','4000','2000','15000','0','2021-11-30',0,'Milan','Ĺ palek','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(131,269,131,0,0,'NE','2017-02-01','2021-09-30','','4000','2000','5000','0',NULL,0,'Pavel','KrÄŤka','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(132,347,132,0,1,'NE','2016-07-01','2019-08-31','','0','0','0','0',NULL,0,'Martin','KĹ™iĹľan','','','','ANO','Martin KĹ™iĹľan','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(133,358,133,0,0,'NE','2010-12-31','2010-12-31','','0','0','0','0',NULL,0,'','KuljovĂˇ','','','','ANO',' Barvy laky KuljovĂˇ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(134,342,134,0,0,'NE','2015-01-01','2021-09-30','','7000','0','0','0',NULL,0,'Ĺ tefan','Lux','','','','ANO','Ĺ tefan Lux','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(135,343,135,0,0,'NE','2017-02-01','2021-09-30','','7000','2500','15000','0',NULL,0,'','MarĹˇĂ­k','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(136,258,136,65978,1,'ANO','2016-01-01',NULL,'','8700','2000','16000','0',NULL,0,'Milan','NeckĂˇĹ™','','','','ANO','NESPO plus s.r.o.','','',X'','','NE','1','Milan NeckĂˇĹ™,  Ing. Milan Ĺ pinka 603 469 482, Kuba NeckĂˇĹ™ 724 882 283, nespo@nespo.cz','','','','','','CZ','','','','','','CZ','','','603469520','neckar@nespo.cz;vlkova@sochor.info ĂşÄŤ.','','','','','','','@','@','@'),(137,338,137,66113,1,'NE','2016-05-01','2021-01-31','','10000','0','0','0',NULL,0,'','NovĂˇÄŤek','','','','ANO','Prodoor s.r.o.','','',X'','Je tĹ™eba upravit smlouvu, kde je nutnĂ© upĹ™esnit prostor skladovĂˇnĂ­.','NE','1','Ing. StanislavovĂˇ 775790433 - most@prodoor.eu, NovĂˇÄŤek 774790095 - novacek@prodoor.eu,  RajcherovĂˇ prodejna Teplice 774790076 - teplice@prodoor.eu','','','','','','CZ','','','','','','CZ','','','774790095','most@prodoor.eu','https://www.prodoor.eu/','','','','','','@','@','@'),(138,380,138,66162,1,'NE','2020-09-15','2024-12-31','','0','0','0','0',NULL,0,'Roman','Marek ml.','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','771 217 776','','','','','','','','@','@','@'),(139,265,139,0,0,'NE','2013-01-01','2025-04-30','','4500','140','0','4500','2021-11-01',0,'JiĹ™Ă­','Ĺ rĂˇmek','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','2419369113','0800','','','@','@','@'),(140,344,140,66142,1,'NE','2003-12-29','2025-05-03','','10000','0','0','20000','2023-01-01',0,'Richard','Ĺ tekl','','','','ANO','Richard Ĺ tekl-Pneuservis','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','603210483','ppp.krupka@seznam.cz','www.pneuservis-stekl-teplice.cz','','','','','','@','@','@'),(141,266,141,0,0,'NE','2012-05-04','2022-05-31','','5500','400','8000','5500','2021-11-01',0,'Jan','Topinka','','','','NE','','','',X'[BLOB]','','NE','1','','','','','','','CZ','','','','','','CZ','','','731151574','top@centrum.cz','','','1937534153','0800','pani LeonovĂˇ mobil 731 151 563 jeho bĂ˝valĂˇ partnerka a takĂ© kolegynÄ› (kancelĂˇĹ™) v prĂˇci (SeveroÄŤeskĂ© papĂ­rny Novosedlice)','','@','@','@'),(142,348,142,0,1,'NE','2018-02-09','2019-03-31','','0','0','0','0',NULL,0,'Pavla','TrutzovĂˇ','','','','ANO','Pavla TrutzovĂˇ','87271788','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(143,339,143,0,1,'NE','2014-05-01','2020-12-31','','0','0','0','0',NULL,0,'','StĂ˝blo','','','','ANO','Auto-moto plus s.r.o.','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','@','@','@'),(144,347,144,0,1,'NE','2020-03-20','2021-03-31','','1000','0','0','0',NULL,0,'FrantiĹˇek','Folejtar','','','','ANO','Frfol s.r.o.','','',X'','','NE','1','Bc. Jaroslav Drbal, zĂˇstupce jednatelĹŻ 774412882','','','','','','CZ','','','','','','CZ','','','774412882','info@frfol.cz','www.frfol.cz','','','','','','@','@','@'),(145,345,145,0,1,'ANO','2004-02-04',NULL,'','1000','0','0','0',NULL,0,'','','','','','ANO','AGC s.r.o.','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','+420 417 814 111','774 269 811','chuderice@eu.agc.com','www.agcautomotive.cz/','','','','Ing. Martin JonĂˇĹˇ  mediĂˇlnĂ­ zĂˇstupce AGC Automotive Czech a.s.,  martin.jonas@ad-vise.cz','','@','@','@'),(146,256,146,0,1,'NE','2022-02-01','2024-08-10','','1500','0','0','0',NULL,0,'DACHDECKER s.r.o. (Slukovi)','','','','','ANO','DACHDECKER s.r.o. (Slukovi)','18248292','CZ18248292',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','724 559 343','schmiedova@dachdecker.cz','','','','','telefon i email je na hlavnĂ­ ĂşÄŤetnĂ­','','@','@','@'),(147,331,147,0,1,'ANO','2004-12-30',NULL,'','5000','0','0','6000','2023-01-01',0,'VĂˇclav','VodrĂˇĹľka','','','','ANO','DANMO s.r.o.','61510505','CZ6708150119',X'','Info se pouĹľĂ­vĂˇ na poznĂˇmky pro rychlĂ© Ĺ™eĹˇenĂ­ rĹŻznĂ˝ch nejasnostĂ­ nebo problĂ©mĹŻ tĂ˝kajĂ­cĂ­ch se nĂˇjemnĂ­ka. Zapisuje se a povoluje v kartÄ› nĂˇjemnĂ­ka','ANO','1','','','','','','','CZ','','','','','','CZ','','603 862 001','603 862 001 K','obchod@plastokna.cz','','','','','','','@','@','@'),(148,358,148,0,0,'NE','2012-01-12',NULL,'','0','0','0','0',NULL,0,'Marek-KĹ™Ă­Ĺľ','Marek-KĹ™Ă­Ĺľ','','','','NE','Marek-KĹ™Ă­Ĺľ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','608 222 280 Radek','','','','','','','','@','@','@'),(150,316,10,0,1,'NE','2016-05-30','2018-01-06','','0','0','0','0',NULL,0,'Daniel','Marek','','','92 04 29/ 3065','NE','','','',X'','','NE','1','','','ModlanskĂˇ','704','41501','Teplice','CZ','TĹ™etĂ­ byt v pronĂˇjmu','','','','','CZ','','','','','','','','','','','','@','@'),(155,346,155,0,1,'ANO','2012-05-31',NULL,'','500','0','0','0',NULL,0,'Jaroslav','HĂˇjek','','','','ANO','Jaroslav HĂˇjek - AUTOBEST Teplice','12815047','',X'','','NE','1','777 125 785','','','','','','CZ','','DubskĂˇ','1662','415 01','Teplice','CZ','','417 577 323, 417 570 986','777 332 676','autobestservis@seznam.cz','http://www.autobest-servis.cz/','','','','','','','',''),(161,341,161,0,0,'ANO','2017-07-01',NULL,'','5000','0','5000','5000','2021-11-01',0,'Marek','Janatka','','','','ANO','Marek Janatka','72736151','CZ7702222913',X'','','NE','1','','','','','','','CZ','','KapelnĂ­','486/3','41501','Teplice','CZ','','','776115891','marekjanatka@seznam.cz','','','670100-2201712505','6210','','','','',''),(162,339,162,66138,1,'NE','2020-12-31','2025-05-03','','16000','200','30000','21000','2023-01-01',0,'Martin','HoulĂ­k - Optima Gaz s.r.o.','','','','ANO','OPTIMA GAZ s.r.o.','27576965','CZ27576965',X'','','NE','1','pan HoulĂ­k je zĂˇstupce majitele','','','','','','CZ','','DubÄ›jovickĂˇ','361','25763','TrhovĂ˝ Ĺ tÄ›pĂˇnov','CZ','','','725551290','martin.optimagaz@seznam.cz','','','','','','','','',''),(167,324,45,0,1,'NE','2019-01-22','2020-02-29','','0','0','0','0',NULL,0,'KateĹ™ina','PolĂˇÄŤkovĂˇ','','','94 51 14/3053','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(168,324,72,0,1,'NE','2018-02-06','2018-12-12','','0','0','0','0',NULL,0,'Michaela','VyhnalovĂˇ','','','94 57 27/3056','NE',' ','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(169,393,169,0,0,'NE','2021-01-01',NULL,'','0','0','0','0',NULL,0,'Veronika a Michal','RubĂˇnkovi','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(170,390,170,0,1,'ANO','2021-01-01',NULL,'','0','0','0','0',NULL,0,'','sklepnĂ­ prostory','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','0','','','','','','','','','@','@'),(172,316,58,0,1,'NE','2019-02-01','2019-08-31','','0','0','0','0',NULL,0,'Marek','Malota','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(173,325,173,66151,1,'NE','2021-03-08','2022-11-30','','6500','420','15000','0',NULL,0,'Radek','Houska','','','720611/2837','NE','','','',X'','','NE','1','NS od 8. 3. 2021','','','','','','CZ','','','','','','CZ','','','733 397 868','malomuz@seznam.cz','','','216844608','0600','','','','',''),(174,281,65,0,1,'ANO','2021-04-03',NULL,'','6500','840','15000','7000','2023-01-01',0,'Martina','Ĺ˝ĂˇrovĂˇ-KlouÄŤkovĂˇ','','','905911/3074','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','723 391 476K','sellena2@seznam.cz','','','194925561','0600','','','','',''),(175,324,175,0,1,'NE','2021-04-05','2022-11-16','','','','','0',NULL,0,'Iveta','OprendykovĂˇ','','','715919/9146','NE','','','',X'3C703E4EC3A16A656D6EC3A920446F20C599C3AD6A6E612E32303231202D2035303530206BC48D3C62723E3C2F703E','- AktuĂˇlnĂ­ nĂˇjem 5 050 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 5 500 kÄŤ','ANO','1','','','','','','','CZ','','Na koneÄŤnĂ©','198/6','41501','Teplice','CZ','nĂˇjemnĂ­ byt','','608 149 647','iveta.oprendykova@seznam.cz','','','43-4823130277','0100','','','','',''),(176,301,176,66171,1,'ANO','2021-06-08',NULL,'','6500','420','13000','7000','2023-01-01',0,'Rita','KendĂ­kovĂˇ','','','615502/0949','NE','','','',X'','','NE','1','','','28.Ĺ™Ă­jna','3238','415 01','Teplice','CZ','','','','','','CZ','','','608 615 271CHA','ritakendy@seznam.cz','','','115-4913340227','0100','','','','',''),(178,306,178,0,1,'NE','2021-08-16','2025-07-02','','6000','840','12000','0',NULL,0,'Anna','PetrovickĂˇ','Ing.','','855414/3378','NE','','','',X'','','NE','1','','','DuchcovskĂˇ','410','41501','Teplice','CZ','','','','','','CZ','','','777 905 941CHA','petrovicka@email.cz','','','78-4691550287','0100','','','','',''),(179,307,103,0,1,'ANO','2021-08-01',NULL,'','6700','840','8000','0',NULL,0,'Tereza','EliĂˇĹˇovĂˇ','','','93 53 16/2962','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','732 621 673','teliasova@gmail.com','','','7454586001','5500','','','','',''),(183,308,183,0,1,'NE','2021-09-08','2023-04-30','','6000','420','12000','0',NULL,0,'Filip','Vopat','','','000922/3049','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','770 696 727','vopi2@post.cz','','','1746850022','3030','','','','',''),(185,400,185,0,1,'ANO','2021-10-01',NULL,'','1000','0','0','0',NULL,0,'JiĹ™Ă­','PetrĹľelka','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','722932010','','','','','','','','','',''),(188,0,188,0,0,'NE','2022-02-16','2022-02-20','','0','0','0','0',NULL,0,'MIlan','Pokus','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(190,298,190,0,1,'NE','2022-03-01','2023-08-31','','5500','420','15000','6000','2023-01-01',0,'Denisa','RĹŻĹľkovĂˇ','','','005118/3044','NE','','','',X'','','NE','1','Jistota 15000 KÄŤ zaplacena 1.3.22: do pokladny zaplatila 14000 KÄŤ a do KB poslala 1000 KÄŤ. VrĂˇceno 18.9.2023-KB (D/10). 22.1.2024-KB - 15000 KÄŤ (A/3).','','ZĂˇbruĹˇany 86, 417 71 ZĂˇbruĹˇany','','','','CZ','','','','','','CZ','','','725 868 257','deminka18@seznam.cz','','','2083498017','3030','','','','',''),(192,378,192,0,1,'NE','2022-01-27','2024-12-31','OBRUSNIK','6000','300','0','0',NULL,0,'JindĹ™ich','ObrusnĂ­k','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','Husova','413','41510','Teplice-SobÄ›druhy','CZ','','','776 357 804','','','','2111449483','2700','','','','',''),(193,295,193,0,1,'NE','2022-06-01','2022-07-31','','0','0','0','0',NULL,0,'Dobra','SlĂˇmovĂˇ','','','93 53 20/021','NE','','','',X'','','NE','1','','','KruĹˇnohorskĂˇ 1567','15','415 01','Teplice','CZ','','JateÄŤnĂ­','1836','41510','Teplice','CZ','','','608 310 710','dobra.slamova@gmail.com','','','232133822','0300','','','','',''),(194,295,194,0,1,'NE','2022-08-01','2025-07-04','','0','0','12000','0',NULL,0,'KateĹ™ina','SlĂˇmovĂˇ','','','96 56 05/314','NE','','','',X'','','NE','1','','','K zĂˇmeÄŤku','98','415 10','Teplice','CZ','','JateÄŤnĂ­','1836','41510','Teplice','CZ','','','704 398 133AK','katherinestraw@gmail.com','','','115-1300660267','0100','','','','',''),(197,324,197,0,1,'NE','2022-11-17','2023-06-02','','6000','420','12000','0',NULL,0,'KateĹ™ina','PospĂ­ĹˇilovĂˇ','','','045222/7479','NE','','','',X'','','NE','1','','','RtĂ˝ĹskĂˇ 18','41763','','Ĺ˝alany','CZ','','Ĺ tĂşrovĂˇ 41','616','','','CZ','','','777444751','katerina.pospisilova2046@post.cz','','','1892763015','3030','','','','',''),(198,325,198,0,1,'NE','2022-12-01','2023-11-30','','8000','840','15000','0',NULL,0,'KateĹ™ina','PetĹ™Ă­ÄŤkovĂˇ','','','92 5422/3088','NE','','','',X'','','NE','2','','','HavĂ­Ĺ™skĂˇ','1441','41501','Teplice','CZ','','Ĺ tĂşrovĂˇ 41','616','41501','Teplice','CZ','','','723878879','kata.petrikova@seznam.cz','','','2114677887','2700','','','','',''),(199,405,199,0,0,'ANO','2011-12-20',NULL,'','0','0','0','0',NULL,0,'TelefĂłnica Czech Republic, a.s','','','','','ANO','TelefĂłnica Czech Republic, a.s.','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(200,309,200,0,1,'ANO','2023-03-01',NULL,'','0','0','14000','0',NULL,0,'KlĂˇra','HumpolcovĂˇ','','','9553153060','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','776222350CHT','klara.humpolcova@gmail.com','','','231394609','0600','pĹŻvodnĂ­ adresa: Scheinerova 1833, Teplice','','','',''),(201,410,201,0,1,'ANO','2022-01-01',NULL,'','0','0','0','0',NULL,0,'ĂşklidovĂˇ','sluĹľba','','','','NE','','','',X'3C703E7765773C2F703E','wertqwetqw','ANO','1','','','','','','','CZ','','','','','','CZ','','','doplnit','doplnit@77.cz','','','0207637033','0100','','','','',''),(202,296,202,0,1,'ANO','2023-05-25',NULL,'','0','0','16000','0',NULL,0,'Daniel','KendĂ­k','','','931206/3266','NE','','','',X'','','NE','1','','','U nĂˇdraĹľĂ­','906/16','41501','Teplice','CZ','','','','','','CZ','','','777758793CHT','kendik.daniel@seznam.cz','','','78-4712590297','0100','','','','',''),(207,308,207,0,1,'NE','2023-05-01','2023-12-31','','0','0','0','0',NULL,0,'Martin','PaĹˇinger','','','8809293152','NE','','','',X'','','NE','1','','','LounskĂˇ','2103/11','401501','Teplice','CZ','','','','','','CZ','','','602 150 601','martinpasinger@seznam.cz','','','225501658','0300','','','','',''),(212,262,212,0,0,'ANO','2023-07-01',NULL,'','0','0','30000','0',NULL,0,'Simona','ChynoraiovĂˇ','Mgr. Bc.','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','739306076','chynoraiova@seznam.cz','','','','','','','','',''),(213,302,213,0,1,'NE','2023-09-03','2025-04-30','','0','0','14000','0',NULL,0,'KarolĂ­na','MarÄŤĂˇlovĂˇ','','','005706/2797','NE','','','',X'','','NE','2','dcera Elena Kovalenko RÄŚ: 226005/1332','','','','','','CZ','','','','','','CZ','','','0CHA','marcakar@seznam.cz','','','273728785','0100','','VelkĂ˝ nepoĹ™Ăˇdek pĹ™i pĹ™edĂˇnĂ­ bytu, nutnĂ© zadrĹľet z jistoty 14 000 KÄŤ na opravy','','',''),(214,328,214,0,1,'NE','2023-09-01','2024-03-01','','0','0','15000','0',NULL,0,'VITALII','HORDIIENKO','','','910529/1734','NE','','','',X'','','NE','2','UKR - povolenĂ­ k pobytu do 3.8.2024','povolenĂ­ k pobytu do 3.8.2024, nĂˇjemnĂ© 7500 + 840 = 8 340 KÄŤ','','','','','UKR','','','','','','CZ','','','720 225 358','gordienko8222494@gmail.com','','','1032663663','5500','MANĹ˝ELKA - Iryna Hordiienko, RÄŚ: 92 57 28/1861','','','',''),(215,323,119,0,1,'NE','2023-08-01','2024-03-01','','0','0','15000','0',NULL,0,'ZdenÄ›k','Kahoun','','','500307/163','NE','','','',X'','','NE','1','','UkonÄŤil nĂˇjemnĂ© v bytÄ› ÄŤ. 6 a pĹ™estÄ›hoval se do bytu ÄŤ. 1.','','','','','CZ','','','','','','CZ','','','737 947 587','Pamatkar007@seznam.cz','','','274872690','0300','','','','',''),(216,298,216,0,1,'ANO','2023-09-01',NULL,'','0','0','12000','0',NULL,0,'KlĂˇra','Ĺ ejnohovĂˇ','','','','NE','','','',X'','','NE','2','','','','','','','CZ','','','','','','CZ','','','0AK','','','','','','','','','',''),(217,313,217,0,1,'NE','2023-11-21','2024-03-01','','0','0','0','0',NULL,0,'Stodola restaurace','','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(218,266,218,0,0,'NE','2024-01-17','2025-03-28','','0','0','20000','0',NULL,0,'TomĂˇĹˇ','Tyrpekl','','Pan','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(222,325,190,0,1,'NE','2024-01-20','2024-03-01','','0','0','0','0',NULL,0,'Denisa','RĹŻĹľkovĂˇ','','','005118/3044','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','725 868 257','deminka18@seznam.cz','','','2083498017','3030','','','','',''),(223,308,223,0,1,'NE','2024-01-23','2024-10-31','','0','0','14000','0',NULL,0,'David','NovĂˇk','','','951003/3115','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','davidnovak95@seznam.cz','','','','','','','','',''),(225,429,225,65940,0,'ANO','2024-03-01',NULL,'','7500','850','15000','0',NULL,0,'Semjon','KuiĹˇ ml.','','','891108/3038','NE','','','',X'','','NE','3','','','','','','','CZ','','','','','','CZ','','','720 299 607','senakuis@seznam.cz','','','','','','','@','@','@'),(226,430,226,66114,0,'ANO','2024-03-01',NULL,'','7500','850','14000','0',NULL,0,'KarolĂ­na','RĹŻĹľiÄŤkovĂˇ','','','946022/3047','NE','','','',X'','','NE','3','','','','','','','CZ','','','','','','CZ','','','776 322 822','karolinafurstova94@seznam.cz','','','2909932183','0800','','','','@','@'),(227,428,227,65558,0,'ANO','2024-03-01',NULL,'','8000','0','0','12000','2023-04-01',0,'Ilona','HrabĂˇkovĂˇ','','','','ANO','Ilona HrabĂˇkovĂˇ-LINIE','','',X'','','NE','2','','','','','','','CZ','','V zĂˇvÄ›tĹ™Ă­','1672/4','415 01','Teplice','CZ','','','777 049 553, prĂˇce 603 174 705','ilonahrab@centrum.cz','','','','','','','@','@','@'),(229,427,229,0,0,'ANO','2024-03-01',NULL,'','0','0','0','0',NULL,0,'Stodola restaurace','','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(230,424,230,0,0,'ANO','2024-03-01',NULL,'','0','0','15000','0',NULL,0,'VITALII','HORDIIENKO','','','910529/1734','NE','','','',X'','','NE','2','UKR - povolenĂ­ k pobytu do 3.8.2024','povolenĂ­ k pobytu do 3.8.2024, nĂˇjemnĂ© 7500 + 840 = 8 340 KÄŤ','','','','','UKR','','','','','','CZ','','','720 225 358','gordienko8222494@gmail.com','','','1032663663','5500','MANĹ˝ELKA - Iryna Hordiienko, RÄŚ: 92 57 28/1861','','','',''),(231,421,231,0,0,'ANO','2024-03-01',NULL,'','0','0','15000','0',NULL,0,'Denisa','RĹŻĹľkovĂˇ','','','005118/3044','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','725 868 257','deminka18@seznam.cz','','','2083498017','3030','','','','',''),(232,422,232,66136,0,'ANO','2024-03-01',NULL,'','6500','420','12500','0',NULL,0,'Michaela','MatouĹˇkovĂˇ','','','','NE','','','',X'','- AktuĂˇlnĂ­ nĂˇjem 5 550 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 6 500 kÄŤ','NE','1','','','','','','','CZ','','','','','','CZ','','','608 001 855','michaela.maty@seznam.cz','','','189139267','0600','','','','@','@'),(233,423,233,65873,0,'NE','2024-03-01','2024-10-30','','6500','2050','15000','0',NULL,0,'Michael','NovĂˇk','','','780513/2236','NE','','','',X'','- AktuĂˇlnĂ­ nĂˇjem 5 550 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 6 500 kÄŤ','NE','3','','','','','','','CZ','','','','','','CZ','','605 265 618 HajmanovĂˇ Nicola','737 188 824','nbart@seznam.cz','','','217156225','0600','','','@','@','@'),(234,425,234,65938,0,'ANO','2024-03-01',NULL,'ÄŚeskĂˇ spoĹ™itelna','7500','1310','18000','8500','2023-04-01',0,'RenĂ©','SCHULDES','','','','NE','','','',X'','- AktuĂˇlnĂ­ nĂˇjem 6 550 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 7 500 kÄŤ','ANO','4','','','','','','','CZ','','','','','','CZ','','','731 057 267','rendyyy101@centrum.cz','','','2814112123','0800','','','@','@','@'),(235,426,235,66118,0,'ANO','2024-03-01',NULL,'','7500','840','19500','8500','2023-01-01',0,'VladimĂ­r','Kovalenko','','','97 06 16/3115','NE','','','',X'','- AktuĂˇlnĂ­ nĂˇjem 6 550 kÄŤ \r\n- 13.10.2021 oznĂˇmenĂ­ o navĂ˝ĹˇenĂ­ na 7 500 kÄŤ','ANO','2','','','','','','','CZ','','','','','','CZ','','','721 049 362','kovalenko-v@seznam.cz','','','214087746','0600','','','','@','@'),(236,418,236,0,0,'ANO','2024-03-01',NULL,'','0','0','15000','0',NULL,0,'ZdenÄ›k','Kahoun','','','500307/163','NE','','','',X'','','NE','1','','UkonÄŤil nĂˇjemnĂ© v bytÄ› ÄŤ. 6 a pĹ™estÄ›hoval se do bytu ÄŤ. 1.','','','','','CZ','','','','','','CZ','','','737 947 587','Pamatkar007@seznam.cz','','','274872690','0300','','','','',''),(237,438,237,65659,0,'ANO','2007-05-01',NULL,'','8000','0','0','',NULL,0,'ZdenÄ›k','PavlĂ­k','','','','NE','','','',NULL,'','NE','1','','','','','','','CZ','','','','','','CZ','','','777 575 851','pavcus37@seznam.cz','','','','','','','@','@','@'),(238,440,238,66162,0,'ANO','2020-09-15',NULL,'','0','0','0','0',NULL,0,'Roman','Marek ml.','','','','NE','','','',NULL,'','NE','1','','','','','','','CZ','','','','','','CZ','','','771 217 776','','','','','','','','@','@','@'),(239,442,239,0,0,'ANO','2023-01-04',NULL,'','0','0','0','0',NULL,0,'byt v opravÄ› prĂˇzdnĂ˝','','','','','NE','','','',NULL,'','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(240,449,240,0,0,'ANO','2021-01-01',NULL,'','0','0','0','0',NULL,0,'','sklepnĂ­ prostory','','','','NE','','','',NULL,'','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','@','@'),(241,450,241,65953,0,'ANO','2015-11-01',NULL,'','8060','840','21500','9000','2023-01-01',0,'Hana','DohnalovĂˇ','','','495729/124','NE','','','',NULL,'','NE','2','','','','','','','CZ','','','','','','CZ','','','774 837 830','hanka.d49@seznam.cz','','','100159270','0300','','','@','@','@'),(242,451,242,65828,0,'ANO','2013-04-27',NULL,'','9060','1260','21000','10000','2023-01-01',0,'KateĹ™ina','KoĹˇĹĄĂˇlovĂˇ','','','785223/2916','NE','','','',NULL,'','NE','3','','','','','','','CZ','','','','','','CZ','','','727 857 755','','','','','','','','@','@','@'),(243,452,243,65995,0,'ANO','2018-01-07',NULL,'','0','0','0','0',NULL,0,'Daniel','Marek','','','92 04 29/ 3065','NE','','','',NULL,'','NE','2','','','ModlanskĂˇ','704','41501','Teplice','CZ','TĹ™etĂ­ byt v pronĂˇjmu','','','','','CZ','','','777 800 094','daniel-marek@email.cz','','','2034557033','3030','','','','@','@'),(244,453,244,0,0,'ANO','2022-01-27',NULL,'OBRUSNIK','6000','300','0','0',NULL,0,'JindĹ™ich','ObrusnĂ­k','','','','NE','','','',NULL,'','NE','1','','','','','','','CZ','','Husova','413','41510','Teplice-SobÄ›druhy','CZ','','','776 357 804','','','','2111449483','2700','','','','',''),(245,456,245,66029,0,'ANO','2017-04-13',NULL,'','4000','200','8000','5000','2023-01-01',0,'Lenka','FialovĂˇ','','','','ANO','Fyzioterapie Lenka FialovĂˇ, Dis.','03683648','',NULL,'','NE','1','','','','','','','CZ','','','','','','CZ','','','607 049 077','lena.fialka@gmail.com','','','','','','','','@','@'),(246,458,246,0,0,'ANO','2021-04-03',NULL,'','6500','840','15000','7000','2023-01-01',0,'Martina','Ĺ˝ĂˇrovĂˇ','','','905911/3074','NE','','','',NULL,'','NE','2','','','','','','','CZ','','','','','','CZ','','','723 391 476','sellena2@seznam.cz','','','194925561','0600','','','','',''),(247,419,247,0,0,'ANO','2024-03-27',NULL,'','0','0','13000','0',NULL,0,'Michal','VaculĂ­k','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','703399008','','','','','','','','','',''),(248,463,80,0,1,'ANO','2014-10-01',NULL,'','0','0','0','0',NULL,0,'NadÄ›Ĺľda','RosĂˇkovĂˇ','','PanĂ­','605825/1100','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','723 832 415','jirkajirka1@centrum.cz','','','291896475','0300','','','','',''),(249,464,229,0,0,'ANO','2024-03-01',NULL,'','0','0','0','0',NULL,0,'Stodola restaurace sklep','','','','','NE','','','',X'','','NE','0','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(251,468,251,0,1,'ANO','2023-01-01',NULL,'','0','0','0','0',NULL,0,'Helena','MarkovĂˇ','Mgr.','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(252,469,252,0,1,'ANO','2023-01-01',NULL,'','0','0','0','0',NULL,0,'Ĺ Ăˇrka','SlukovĂˇ','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(255,472,255,0,0,'ANO','2022-01-01',NULL,'','0','0','0','0',NULL,0,'MajitelĂ©','Pozorka','','','','NE','','','',X'','','NE','','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(256,332,256,0,1,'ANO','2024-12-01',NULL,'','0','0','27000','0',NULL,0,'OndĹ™ej','VeselĂ˝','','','840505/2854','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','702377646K','equalibrium@email.cz','','','','','','','','',''),(258,308,258,0,1,'ANO','2025-01-18',NULL,'','0','0','15000','0',NULL,0,'Olena','Druz','','','10091975','NE','','','',X'','','NE','2','2 osoba Oleksandr Shcherba st. pĹ™Ă­sl. UKR RÄŚ: 720228/1306 PovolenĂ­ k pobytu ÄŤ. 001734905','','','','','','CZ','','','','','','CZ','','','606583578CHA','alena19751010@gmail.com','','','','','','','','',''),(259,378,138,0,1,'ANO','2025-02-01',NULL,'','0','0','0','0',NULL,0,'Roman','Marek ml.','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','771 217 776K','','','','','','','','','',''),(260,479,260,0,1,'ANO','2024-01-01',NULL,'','0','0','0','0',NULL,0,'dĂ­lna','','','','','NE','','','',X'','','NE','','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(261,423,261,0,0,'ANO','2024-11-01',NULL,'','0','0','','0',NULL,0,'KonviÄŤka','','','','','NE','','','',X'','','NE','1','','','','','','','CZ','','','','','','CZ','','','','','','','','','','','','',''),(266,266,266,0,0,'ANO','2025-04-01',NULL,'','','','20000','',NULL,0,'Jan','Zwettler','','','971119/3041','NE','','','',X'','','NE','2','Od 02/04/2025 - 2 osoby. AdĂ©la BartoĹˇovĂˇ 777173150 RÄŚ: 966216/3049','','','','','','','','','','','','','','','608861911','hanzyzw@seznam.cz','','','','','','','','',''),(267,302,267,0,1,'ANO','2025-05-01',NULL,'','','','0','',NULL,0,'JiĹ™Ă­','Ĺ rĂˇmek','','','','NE','','','',X'','','NE','1','','','','','','','','','','','','','','','','','','','','2419369113','0800','','','','',''),(268,487,268,0,0,'ANO','2025-06-01',NULL,'','','','','',NULL,0,'MiloĹˇ','ÄŚervinka','Ing.','','','ANO','Meridius REAL, s.r.o.','10847812','',X'','','NE','','','','','','','','','','','','','','','','','','','','','','','','','','',''),(269,495,269,0,1,'ANO','2025-09-25',NULL,'','','','0','',NULL,0,'Radek','Ĺ ikr','','','','NE','','08602999','',X'','','NE','1','','','','','','','','','','','','','','','','734581028, sikr.r@seznam.cz','','','','','','','','','',''),(270,501,162,0,1,'ANO','2025-05-04',NULL,'','','','30000','',NULL,0,'Martin','HoulĂ­k - Optima Gaz s.r.o.','','','','ANO','OPTIMA GAZ s.r.o.','27576965','CZ27576965',X'','','NE','1','pan HoulĂ­k je zĂˇstupce majitele','','','','','','','','','','','','','','','725551290','martin.optimagaz@seznam.cz','','','','','','','','',''),(271,502,140,0,1,'ANO','2025-05-04',NULL,'','','','0','',NULL,0,'Richard','Ĺ tekl','','','','ANO','Richard Ĺ tekl-Pneuservis','','',X'','','NE','1','','','','','','','','','','','','','','','','603210483','ppp.krupka@seznam.cz','www.pneuservis-stekl-teplice.cz','','','','','','','',''),(272,503,146,0,1,'ANO','2022-02-01',NULL,'','','','0','',NULL,0,'DACHDECKER s.r.o.','','','','','ANO','DACHDECKER s.r.o.','18248292','CZ18248292',X'','','NE','1','','','','','','','','','','','','','','','','724 559 343','schmiedova@dachdecker.cz','','','','','telefon i email je na hlavnĂ­ ĂşÄŤetnĂ­','','','','');

#
# Structure for table "sessions"
#

CREATE TABLE `sessions` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

#
# Data for table "sessions"
#

INSERT INTO `sessions` VALUES ('AAasmC5gY4roQ5zDCuXulsNQfTbYGkjXhdOEkKvs',4,'109.81.120.230','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiNzZacHZOa3IxU2lFZEIzSUxSaWNDQ25mcU1TaFN4VEFXVHVtT3UxQyI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NDtzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEyJGNIVUhJSXNNRDZZLkU2eVJ0YTV1dU9TeDZWT0I0TzR2MVlOQTMyN1QvQ1d5eGJZdmFoRU55IjtzOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo5MDoiaHR0cDovLzE4OC4xNzUuMTI2LjI2L3B1YmxpYy9pbmRleC5waHAvZXZpZGVuY2U/Y2lsPVJFVjBYUlhYeDB4WFhHeDB4WFhGeDB4WCUyQUIlM0FBJmNzPUFSIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1753470952),('claxwm1nsPyjLSplEv7No7BYRvUMMJBspYNK2lnX',4,'109.81.120.230','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZmprMTBHTkpXWjhjUlhtaXB4em1Nd0ZEcFRMR2tjd3hDYjR5anRJeiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NDtzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEyJGNIVUhJSXNNRDZZLkU2eVJ0YTV1dU9TeDZWT0I0TzR2MVlOQTMyN1QvQ1d5eGJZdmFoRU55Ijt9',1753433655),('gbynzOLakiVGQXz59SXdkxYR33KeA3sYwHDxJdty',4,'109.81.120.230','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiQ1F3M3lkNFZHS0Q0SGdJTGNEM1U2aElwd2pBZW9tbWdHamR0Q1ExaSI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NDtzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEyJGNIVUhJSXNNRDZZLkU2eVJ0YTV1dU9TeDZWT0I0TzR2MVlOQTMyN1QvQ1d5eGJZdmFoRU55IjtzOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo4OToiaHR0cDovLzE4OC4xNzUuMTI2LjI2L3B1YmxpYy9pbmRleC5waHAvYWRyZXNhcj9jaWw9UkFEMFhSWFh4MHhYWEd4MHhYWEZ4MHhYJTJBQSUzQUEmY3M9QVIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1753425486),('rK7TxySeaAEXWZXFeKAGMtlqBgbtMqQ13Das67DX',4,'109.81.120.230','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiZkNZNXQwQmdHZDB1UnZlTFlPYmYxT2Y2djg0d3VObHdLSkhiNWNLbSI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NDtzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEyJGNIVUhJSXNNRDZZLkU2eVJ0YTV1dU9TeDZWT0I0TzR2MVlOQTMyN1QvQ1d5eGJZdmFoRU55IjtzOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozODoiaHR0cDovLzE4OC4xNzUuMTI2LjI2L3B1YmxpYy9pbmRleC5waHAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1753470737),('yijo2OrgV0BR3WJ4Oxk9JpbHPxoRmjpukSz9klWM',4,'109.81.120.230','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiOFNnMlR5VFIxUzRwTmlXYnZRVW5uYTR0VXdYSElJMHZPUFpUVnM5eiI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NDtzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEyJGNIVUhJSXNNRDZZLkU2eVJ0YTV1dU9TeDZWT0I0TzR2MVlOQTMyN1QvQ1d5eGJZdmFoRU55IjtzOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo5MDoiaHR0cDovLzE4OC4xNzUuMTI2LjI2L3B1YmxpYy9pbmRleC5waHAvZXZpZGVuY2U/Y2lsPVJFVjBYUlhYeDB4WFhHeDB4WFhGeDB4WCUyQUIlM0FBJmNzPUFSIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1753458824);

#
# Structure for table "shm"
#

CREATE TABLE `shm` (
  `id` int NOT NULL AUTO_INCREMENT,
  `odkaz_ssluzby` int DEFAULT NULL,
  `HM_vymena_dat` date DEFAULT NULL,
  `HM_c` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `odecet_end_old` float(10,3) NOT NULL DEFAULT '0.000',
  `odecet_poc_new` float(10,3) NOT NULL DEFAULT '0.000',
  `poznamka` text CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_czech_ci ROW_FORMAT=DYNAMIC;

#
# Data for table "shm"
#

INSERT INTO `shm` VALUES (16,273,'2010-01-01','1231111',0.000,0.000,NULL),(19,297,'2015-10-01','3451111',0.000,0.000,NULL),(21,332,'2018-02-01','111111',0.000,0.000,NULL),(22,291,'2020-05-01','9121111',0.000,0.000,NULL);

#
# Structure for table "sjednotka"
#

CREATE TABLE `sjednotka` (
  `id` int NOT NULL AUTO_INCREMENT,
  `odkaz_sadresar` int NOT NULL DEFAULT '0',
  `id_budova` int NOT NULL DEFAULT '0',
  `nemovitost_del` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'NE',
  `selectedEV` tinyint(1) NOT NULL DEFAULT '0',
  `selectedSL` tinyint(1) NOT NULL DEFAULT '0',
  `Majitele` enum('Markovi','Sluka-Marek','M-V','Marek','Danek','Roman') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'Markovi',
  `Majitele_sdilet` enum('Roman','') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL,
  `Velikost` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Plocha` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `VariabilniBU` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci DEFAULT '',
  `VariabilniJN` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci DEFAULT '',
  `Jednotka` enum('Byt','Nebyt','Budova','Prostory') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'Byt',
  `C_Jednotky` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Ulice` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `C_Domu` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `PSC` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Mesto` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Zeme` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Oznaceni` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Razeni` enum('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'C',
  `Info` mediumblob,
  `Info_R` text CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci,
  `Info_zobraz` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'NE',
  `Kody_budovy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Kontroly_p` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'ANO',
  `Kontroly_k` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'ANO',
  `Kontroly_e` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'ANO',
  `Kontroly_z` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'ANO',
  `Kontroly_s` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'ANO',
  `Sluzba_v` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'ANO',
  `Sluzba_ch_e` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'ANO',
  `Sluzba_e` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'NE',
  `Sluzba_p` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'NE',
  `Najemne` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'ANO',
  `predmet_najmu` enum('bytovĂ˝ prostor','nebytovĂ˝ prostor','reklamnĂ­ prostor') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'bytovĂ˝ prostor',
  `Poznamka_najemce` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Poznamka_Adresa` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Vodomer_c` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Elektromer_ch_c` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Elektromer_c` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Plynomer_c` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `VO_ean` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `VO_om` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `VO_sml` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `VO_ucet` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `VO_distr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `VO_pozn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_ean` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_om` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_sml` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_ucet` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_distr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_faze` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_pozn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `PL_ean` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `PL_om` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `PL_sml` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `PL_ucet` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `PL_distr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `PL_pozn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_ch_ean` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_ch_om` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_ch_sml` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_ch_ucet` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_ch_distr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_ch_faze` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `EL_ch_pozn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Najem_zmena` float(10,1) NOT NULL DEFAULT '0.0',
  `El_chodba_zmena` float(10,1) NOT NULL DEFAULT '0.0',
  `Voda_zmena` float(10,1) NOT NULL DEFAULT '0.0',
  `Plyn_zmena` float(10,1) NOT NULL DEFAULT '0.0',
  `Elektrika_zmena` float(10,1) NOT NULL DEFAULT '0.0',
  `Predpis_od_zmena` date DEFAULT NULL,
  `Vydaje_od_zmena` date DEFAULT NULL,
  `Poznamka_pr_zmena` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Poznamka_vd_zmena` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT '',
  `Vydaje1_zmena` float(10,1) NOT NULL DEFAULT '0.0',
  `Vydaje2_zmena` float(10,1) NOT NULL DEFAULT '0.0',
  `Vydaje3_zmena` float(10,1) NOT NULL DEFAULT '0.0',
  `nemovitost_vybrat` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'ANO',
  `nemovitost_end` enum('ANO','NE') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL DEFAULT 'NE',
  `selectedSLp` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_variabilniJN` (`VariabilniJN`),
  KEY `VariabilniJN` (`VariabilniJN`)
) ENGINE=InnoDB AUTO_INCREMENT=504 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_czech_ci;

#
# Data for table "sjednotka"
#

INSERT INTO `sjednotka` VALUES (255,0,255,'NE',1,0,'Markovi','','','','3205',NULL,'Budova','','HĹ™bitovnĂ­','3205','415 01','Teplice','CZ',' ','A',X'[BLOB]','','NE','3205','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','NE','bytovĂ˝ prostor','','','I16BB007309','','','6641805','','609000832','69178709','1001680447','SÄŚVK SV H+R','','','','','','','','','','9302281883','','9520141486','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(256,0,255,'NE',1,0,'Markovi','','nebyt','0',NULL,'3205001','Nebyt','1','HĹ™bitovnĂ­','3205','415 01','Teplice','CZ',' H/N1','C',X'','','NE','3205','NE','NE','NE','NE','NE','ANO','NE','NE','NE','NE','nebytovĂ˝ prostor','DACHDECKER s.r.o. (Slukovi) ukonÄŤeno: 10-08-2024','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(257,125,255,'NE',1,0,'Markovi','','nebyt','0',NULL,'3205002','Nebyt','2','HĹ™bitovnĂ­','3205','415 01','Teplice','CZ','R/N2','C',X'','','NE','3205','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','ANO','nebytovĂ˝ prostor','TruhlĂˇrna BatĂ­k','','','','1025334242','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(258,136,255,'NE',1,0,'Markovi','','nebyt','0',NULL,'3205003','Nebyt','3','HĹ™bitovnĂ­','3205','415 01','Teplice','CZ',' R/N3','C',X'','','NE','3205','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','ANO','nebytovĂ˝ prostor','NESPO plus s.r.o.','','','','1025199749','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(259,87,255,'NE',1,0,'Markovi','','nebyt','0',NULL,'3205005','Nebyt','5','HĹ™bitovnĂ­','3205','415 01','Teplice','CZ','R/N5','C',X'','','NE','3205','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','ANO','nebytovĂ˝ prostor','Petr ZITA','','','','1025201122','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0);
INSERT INTO `sjednotka` VALUES (261,0,261,'NE',0,0,'M-V','','','','108',NULL,'Budova','','MĂ­rovĂˇ','108','415 01','DubĂ­Â­ 3 Pozorka','CZ',' ','A',X'[BLOB]','Zde lze zapisovat rwqwqychlĂ© info','NE','108','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','bytovĂ˝ prostor','','','103936','1022592227','','','','609001007','69160069/1','1001490081','SÄŚVK Teplice','','','','','','','','','','','','','','','859182400406587100','0002901129','','20839777','ÄŚEZ','1 Ă— 16 A','MÄ›Ĺ™enĂ­ spotĹ™eby proudu u Janatky je pomocĂ­ podruĹľ. jednofaz. elektromÄ›ru, kterĂ˝ je umĂ­stÄ›n u elekrom',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(262,212,261,'NE',0,0,'M-V','','nebyt','84.195',NULL,'108001','Nebyt','1','MĂ­rovĂˇ','108','415 01','DubĂ­Â­ 3 Pozorka','CZ',' P108/N1','C',X'372E31302E3231206F6465736CC3A16E20456D61696C207320646F6461746B656D206F207A76C3BDC5A1656EC3AD204EC3A16A6D7520732070726F73626F75206F20466565646261636B20646F2031342E31302EC2A0','Zde lze zapisovat rychlĂ© info','NE','108','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','ANO','nebytovĂ˝ prostor','Simona ChynoraiovĂˇ','','08567933','','','','','','','','dodavatel - sluĹľba majitel','','','','','','','','','','','','','','','','','','','nemĂˇ odbÄ›r','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(263,128,261,'NE',0,0,'M-V','','nebyt','109.005',NULL,'108002','Nebyt','2','MĂ­rovĂˇ','108','415 01','DubĂ­Â­ 3 Pozorka','CZ','P108/N2','C',X'[BLOB]','','NE','108','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','ANO','nebytovĂ˝ prostor','LuboĹˇ PokornĂ˝','','8386361','','','','','','','','dodavatel - sluĹľba majitel','','','','','','','','','','','','','','','','','','','nemĂˇ odbÄ›r','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(264,0,261,'NE',0,0,'M-V','','3+1','80',NULL,'10803','Byt','3','MĂ­rovĂˇ','108','415 01','DubĂ­Â­ 3 Pozorka','CZ','P108/3','D',X'','','NE','108','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor',' Barbora BohatovĂˇ ukonÄŤeno: 27-02-2025 - oprava bytu','','93087324','','','','','','','','dodavatel - sluĹľba majitel','','','','','','','','','','','','','','','','','','','Majitel','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(265,0,261,'NE',0,0,'M-V','','1+1','42',NULL,'10802','Byt','2','MĂ­rovĂˇ','108','415 01','DubĂ­Â­ 3 Pozorka','CZ','P108/2','D',X'','','NE','108','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor',' JiĹ™Ă­ Ĺ rĂˇmek ukonÄŤeno: 30-04-2025 oprava bytu','','860490/11','','','','','','','','dodavatel - sluĹľba majitel','','','','','','','','','','','','','','','','','','','Majitel','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(266,266,261,'NE',0,0,'M-V','','2+kk','55',NULL,'10801','Byt','1','MĂ­rovĂˇ','108','415 01','DubĂ­Â­ 3 Pozorka','CZ','P108/1','D',X'[BLOB]','Nove opraveny byt','NE','108','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor',' Jan Zwettler','','22488057','','','','','','','','dodavatel - sluĹľba majitel','','','','','','','','','','','','','','','','','','','Majitel','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(268,0,268,'NE',0,0,'Marek','','','','194',NULL,'Budova','','MĂ­rovĂˇ','194','415 01','DubĂ­Â­ 3 Pozorka','CZ',' ','A',X'[BLOB]','','NE','194','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(269,0,268,'NE',0,0,'Marek','','','',NULL,'194001','Nebyt','1','MĂ­rovĂˇ','194','415 01','DubĂ­Â­ 3 Pozorka','CZ',' P194/N1','C',X'[BLOB]','','NE','194','ANO','ANO','ANO','ANO','NE','ANO','ANO','NE','NE','ANO','nebytovĂ˝ prostor','UkonÄŤeno - Pavel KrÄŤka','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(270,0,268,'NE',0,0,'Marek','','','',NULL,'194003','Nebyt','3','MĂ­rovĂˇ','194','415 01','DubĂ­Â­ 3 Pozorka','CZ',' P194/N3','C',X'[BLOB]','','NE','194','NE','NE','ANO','ANO','NE','ANO','ANO','NE','NE','ANO','nebytovĂ˝ prostor','UkonÄŤeno - Milan Ĺ palek','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(271,0,271,'NE',0,0,'Markovi','Roman','','','578',NULL,'Budova','','ÄŚs.LegiĂ­','578/8','415 01','Teplice','CZ','C1','B',X'3C703E75706461746520736A65646E6F746B6120736574204D616A6974656C653D22526F6D63612220776865726520566172696162696C6E69206C696B652022223C62723E3C2F703E','','NE','578/8','NE','NE','NE','NE','NE','NE','NE','NE','NE','NE','bytovĂ˝ prostor','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'NE','NE',0),(272,0,275,'NE',1,0,'Markovi','Roman','nebyt','90',NULL,'579002','Nebyt','2','ÄŚs.LegiĂ­','579/10','415 01','Teplice','CZ','C2/N1','C',X'[BLOB]','','NE','579/8','ANO','ANO','NE','NE','NE','ANO','NE','NE','NE','NE','nebytovĂ˝ prostor','Bublinka oprava ','','94/676563','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(273,0,275,'NE',1,0,'Markovi','Roman','2+1','68.5',NULL,'57903','Byt','3','ÄŚs.LegiĂ­','579/10','415 01','Teplice','CZ','C2/2','D',X'[BLOB]','','NE','579/10','NE','NE','NE','NE','NE','ANO','ANO','NE','NE','NE','bytovĂ˝ prostor','oprava bytu','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(275,0,275,'NE',1,0,'Markovi','Roman','','','579',NULL,'Budova','','ÄŚs.LegiĂ­','579/10','415 01','Teplice','CZ','C2','A',X'','','ANO','579/10','ANO','ANO','NE','ANO','NE','ANO','ANO','ANO','ANO','NE','bytovĂ˝ prostor','','','JBO11569','','1020549634','10371824','','609003151','68023462','1100050230','SÄŚVK-TĂˇta','','859182400404802793','0003065563','','0013222702','ÄŚEZ Helena','3 Ă— 25 A','','27ZG400Z0270717X','2001117700','','0013222702','ÄŚEZ Helena','','','','','','','','V domÄ› je pouze elektromÄ›r majitelĹŻ a je evidovĂˇn ve sluĹľbÄ› elektrika',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(276,122,275,'NE',1,0,'Markovi','Roman','nebyt','82',NULL,'579001','Nebyt','1','ÄŚs.LegiĂ­','579/10','415 01','Teplice','CZ','C1/N1','C',X'[BLOB]','','NE','579/10','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','NE','NE','nebytovĂ˝ prostor','ZdenÄ›k PavlĂ­k','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(278,0,278,'NE',1,0,'Markovi','Roman','','','602',NULL,'Budova','','ÄŚs.LegiĂ­','602/12','415 01','Teplice','CZ','H','A',X'','','NE','602/12','ANO','ANO','ANO','ANO','NE','ANO','ANO','NE','NE','NE','bytovĂ˝ prostor','','','116390 vĂ˝mÄ›na ','','','','','609002960','68023459','1100050230','SÄŚVK-TĂˇta','','','','','','','','','','','','','','','','','','','','','Chodba je mÄ›Ĺ™ena pĹ™es elektromÄ›r bytu ÄŤ.1 - podruĹľnĂ˝ jednofĂˇzovĂ˝ elektromÄ›r s displejem',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(279,50,278,'NE',1,0,'Markovi','Roman','nebyt','38',NULL,'602001','Nebyt','1','ÄŚs.LegiĂ­','602/12','415 01','Teplice','CZ','H','C',X'[BLOB]','','NE','602/12','ANO','ANO','NE','ANO','ANO','ANO','NE','NE','NE','NE','nebytovĂ˝ prostor','Lenka FialovĂˇ','','9004521','','','','','1','1','1','','','','1','1','1','','','','','1','1','1','','','','1','1','1','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(281,174,278,'NE',1,0,'Markovi','Roman','2+1','62',NULL,'60202','Byt','2','ÄŚs.LegiĂ­','602/12','415 01','Teplice','CZ','H/2','D',X'3C703E613C2F703E','','NE','602/12','ANO','ANO','NE','ANO','ANO','ANO','ANO','NE','NE','NE','bytovĂ˝ prostor','Martina Ĺ˝ĂˇrovĂˇ','','9004525','','No 107371928','No 2323727-0','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(283,0,283,'NE',1,0,'Markovi','','','','413',NULL,'Budova','','Husova','413','415 01','SobÄ›druhy','CZ','O','A',X'61C599C599C5BEC3BDC3A1','','NE','413','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','bytovĂ˝ prostor','','','047785','1880103022','','','','609005158','6200806788','9009005158','SÄŚVK - Helena','','','','','','','','','','','','','','','859182400404770115','0003170184','','0013222702','ÄŚEZ-Helena','3 Ă— 25 A','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(284,20,283,'NE',1,0,'Markovi','','3+1','0',NULL,'41301','Byt','1','Husova','413','415 01','Teplice','CZ','O/1','D',X'[BLOB]','','NE','413','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','Hana DohnalovĂˇ','','120238957','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(285,44,283,'NE',1,0,'Markovi','','3+1','0',NULL,'41302','Byt','2','Husova','413','415 01','Teplice','CZ','O/2','D',X'[BLOB]','','NE','413','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','KateĹ™ina KoĹˇĹĄĂˇlovĂˇ','','1120238931','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(286,10,283,'NE',1,0,'Markovi','','3+1','0',NULL,'41303','Byt','3','Husova','413','415 01','Teplice','CZ','O/3','D',X'[BLOB]','','NE','413','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor',' Daniel Marek','','1120238927','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0);
INSERT INTO `sjednotka` VALUES (288,0,288,'NE',1,0,'Markovi','','','','1836',NULL,'Budova','','JateÄŤnĂ­','1836','415 01','Teplice','CZ','D','A',X'[BLOB]','','NE','1836','ANO','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','ANO','bytovĂ˝ prostor','','','22620003196','69128411','70244251','','','609000813','68022801','1100050230','SÄŚVK-TĂˇta','','859182400406633739','0002896917','','0012846991','ÄŚEZ TĂˇta','3 Ă— 25 A','','','','','','','','859182400403420363','0003248113','','0012846991','ÄŚEZ TĂˇta','1 Ă— 20 A','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(289,0,289,'NE',1,0,'Markovi','','','','1837',NULL,'Budova','','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E','A',X'[BLOB]','','NE','1837','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','bytovĂ˝ prostor','','','I21IA012615','1026660941','','','','609000814','68022804','1100050230','SÄŚVK-TĂˇta','','','','','','','','','','','','','','','859182400403420448','0003248642','','0012846991','ÄŚEZ TĂˇta ','1 Ă— 15 A','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(290,28,288,'NE',1,0,'Markovi','','2+1','58',NULL,'183602','Byt','2','JateÄŤnĂ­','1836','415 01','Teplice','CZ','D/2','D',X'[BLOB]','','NE','1836','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','Jakub VorĂˇÄŤ','','76874732','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(291,121,288,'NE',1,0,'Markovi','','1+1','52',NULL,'183603','Byt','3','JateÄŤnĂ­','1836','415 01','Teplice','CZ','D/3','D',X'[BLOB]','','NE','1836','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','ZdenÄ›k Lipert','','76874729','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(292,80,288,'NE',1,0,'Markovi','','2+1','60',NULL,'183604','Byt','4','JateÄŤnĂ­','1836','415 01','Teplice','CZ','D/4','D',X'[BLOB]','','NE','1836','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','NadÄ›Ĺľda RosĂˇkovĂˇ','','76874780','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(293,56,288,'NE',1,0,'Markovi','','1+1','52',NULL,'183605','Byt','5','JateÄŤnĂ­','1836','415 01','Teplice','CZ','D/5','D',X'[BLOB]','','NE','1836','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','Dmitry Lychev','','76876189','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(294,114,288,'NE',1,0,'Markovi','','2+1','60',NULL,'183606','Byt','6','JateÄŤnĂ­','1836','415 01','Teplice','CZ','D/6','D',X'[BLOB]','','NE','1836','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','Veronika SoukupovĂˇ','','76876173','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(295,0,288,'NE',1,0,'Markovi','','1+1','52',NULL,'183607','Byt','7','JateÄŤnĂ­','1836','415 01','Teplice','CZ','D/7','D',X'[BLOB]','','NE','1836','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor',' KateĹ™ina SlĂˇmovĂˇ ukonÄŤeno: 04-07-2025','','76874796','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(296,202,288,'NE',1,0,'Markovi','','2+1','0',NULL,'183608','Byt','8','JateÄŤnĂ­','1836','415 01','Teplice','CZ','D/8','D',X'[BLOB]','','NE','1836','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','bytovĂ˝ prostor','Daniel KendĂ­k','','76874856','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(297,250,288,'NE',0,0,'Markovi','','3+1','NaN',NULL,'183609','Byt','9','JateÄŤnĂ­','1836','415 01','Teplice','CZ','D/9','D',X'','','NE','1836','NE','NE','NE','NE','NE','ANO','NE','NE','NE','NE','bytovĂ˝ prostor','petr hova','','76876218','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'NE','NE',0),(298,216,288,'NE',1,0,'Markovi','','1+1','50',NULL,'183610','Byt','10','JateÄŤnĂ­','1836','415 01','Teplice','CZ','D/10','E',X'[BLOB]','','NE','1836','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','KlĂˇra Ĺ ejnohovĂˇ','','76876201','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(301,176,289,'NE',1,0,'Markovi','','2+1','60',NULL,'183701','Byt','1','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E/1','D',X'[BLOB]','','NE','1837','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','Rita KendĂ­kovĂˇ','','8492532','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(302,267,289,'NE',1,0,'Markovi','','1+1','52',NULL,'183702','Byt','2','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E/2','D',X'[BLOB]','','NE','1837','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','','bytovĂ˝ prostor',' JiĹ™Ă­ Ĺ rĂˇmek','','8494208','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(303,117,289,'NE',1,0,'Markovi','','2+1','62',NULL,'183703','Byt','3','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E/3','D',X'[BLOB]','','NE','1837','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','NE','bytovĂ˝ prostor','Josef Vladyka','','8494202','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(304,37,289,'NE',1,0,'Markovi','','1+1','52',NULL,'183704','Byt','4','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E/4','D',X'[BLOB]','','NE','1837','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','ZdenÄ›k JĂ­rava','','8494200','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(305,91,289,'NE',1,0,'Markovi','','2+1','63',NULL,'183705','Byt','5','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E/5','D',X'[BLOB]','','NE','1837','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','Rudolf HorÄŤic','','8492530','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(306,0,289,'NE',1,0,'Markovi','','1+1','52',NULL,'183706','Byt','6','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E/6','D',X'[BLOB]','','NE','1837','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','Ing. Anna PetrovickĂˇ ukonÄŤeno: 02-07-2025','','8494201','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(307,179,289,'NE',1,0,'Markovi','','2+1','63',NULL,'183707','Byt','7','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E/7','D',X'[BLOB]','','NE','1837','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor',' Tereza EliĂˇĹˇovĂˇ','','8492531','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(308,258,289,'NE',1,0,'Markovi','','1+1','53',NULL,'183708','Byt','8','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E/8','D',X'[BLOB]','','NE','1837','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','ANO','bytovĂ˝ prostor','Olena Druz','','8494204','','','','','','','','majitel','','','','','','Innogi','','','','','','','Innogi','','','','','','majitel','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(309,200,289,'NE',1,0,'Markovi','','1+1','50',NULL,'183709','Byt','9','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E/9','D',X'[BLOB]','','NE','1837','ANO','ANO','ANO','ANO','ANO','ANO','ANO','NE','NE','','bytovĂ˝ prostor',' KlĂˇra HumpolcovĂˇ','','93/500153','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'ANO','NE',0),(310,0,289,'NE',0,0,'Markovi','','3+1','',NULL,'183710','Byt','10','JateÄŤnĂ­','1837','415 01','Teplice','CZ','E/10','E',X'','','NE','1837','NE','NE','NE','NE','NE','NE','NE','NE','NE','NE','bytovĂ˝ prostor','oprava bytu','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0.0,0.0,0.0,0.0,0.0,NULL,NULL,'','',0.0,0.0,0.0,'NE','NE',0);
INSERT INTO `sjednotka` VALUES (312,0,312,'NE',0,0,'Markovi','','','','704',NULL,'Budova','','ModlanskĂˇ','704/8','415 01','Teplice','CZ','M','A',X'[BLOB]