-- MySQL dump 10.13  Distrib 5.5.30, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: lididb
-- ------------------------------------------------------
-- Server version	5.5.30-1.1

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

--
-- Table structure for table `konicky`
--

DROP TABLE IF EXISTS `konicky`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `konicky` (
  `id_konicku` int(11) NOT NULL AUTO_INCREMENT,
  `nazev_konicku` varchar(30) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id_konicku`),
  UNIQUE KEY `nazev` (`nazev_konicku`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `konicky`
--

LOCK TABLES `konicky` WRITE;
/*!40000 ALTER TABLE `konicky` DISABLE KEYS */;
INSERT INTO `konicky` VALUES (22,'3D modelování'),(16,'atletika'),(4,'bastlení'),(6,'Counter-Strike'),(14,'divadlo'),(18,'dřevořezba'),(12,'film'),(13,'fotografie'),(3,'houbaření'),(17,'hudba'),(10,'chovatelství'),(1,'karban'),(11,'modelářství'),(8,'omalovánky'),(9,'pěstitelství'),(21,'pletení'),(20,'pouštění draků'),(2,'rybaření'),(19,'vaření'),(7,'vystřihovánky'),(5,'WoWko'),(15,'zpěv');
/*!40000 ALTER TABLE `konicky` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `konicky_lidi`
--

DROP TABLE IF EXISTS `konicky_lidi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `konicky_lidi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_osoby` int(11) NOT NULL,
  `id_konicku` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `LIDIAKONICKY` (`id_osoby`,`id_konicku`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `konicky_lidi`
--

LOCK TABLES `konicky_lidi` WRITE;
/*!40000 ALTER TABLE `konicky_lidi` DISABLE KEYS */;
INSERT INTO `konicky_lidi` VALUES (1,1,8),(3,1,15),(2,1,21),(4,2,17),(5,2,18),(6,2,20),(8,3,2),(9,3,3),(7,3,12),(10,4,9),(12,4,12),(11,4,15),(13,4,17),(16,5,6),(14,5,7),(15,5,17),(19,6,8),(18,6,13),(17,6,15),(21,7,17),(20,7,20),(22,8,14),(27,9,1),(23,9,2),(26,9,6),(24,9,15),(25,9,21),(29,10,7),(28,10,16),(33,11,5),(34,11,7),(31,11,8),(32,11,9),(35,11,21),(36,12,13),(37,12,17),(38,13,1),(39,13,4),(40,14,21),(41,15,4),(42,16,1),(44,17,1),(43,17,11),(45,17,20),(46,18,6),(47,18,8),(48,19,4),(49,20,9),(51,21,2),(52,21,17),(50,21,19),(53,22,12),(54,22,16),(55,23,10),(56,24,11),(57,25,1),(58,25,2),(59,25,5),(60,26,20),(61,27,9),(62,28,13),(63,28,16),(66,29,7),(65,29,11),(64,29,14),(68,30,6),(69,30,7),(67,30,18),(72,31,11),(73,31,14),(71,31,18),(70,31,21),(75,32,3),(76,32,4),(74,32,8),(77,33,5),(79,33,7),(78,33,10),(80,33,14);
/*!40000 ALTER TABLE `konicky_lidi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lidi`
--

DROP TABLE IF EXISTS `lidi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lidi` (
  `id_osoby` int(11) NOT NULL AUTO_INCREMENT,
  `jmeno` varchar(30) COLLATE utf8_czech_ci NOT NULL,
  `rok_narozeni` year(4) NOT NULL,
  `id_zamestnani` int(11) DEFAULT NULL,
  `data` text COLLATE utf8_czech_ci,
  PRIMARY KEY (`id_osoby`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lidi`
--

LOCK TABLES `lidi` WRITE;
/*!40000 ALTER TABLE `lidi` DISABLE KEYS */;
INSERT INTO `lidi` VALUES (1,'Karel',1983,9,NULL),(2,'Marek',1983,1,'blázen'),(3,'Václav',1978,14,NULL),(4,'Tom',1972,13,NULL),(5,'Jeroným',1988,13,'to je můj kámoš'),(6,'Lukáš',1971,12,NULL),(7,'Filip',1992,13,NULL),(8,'Radmila',1993,10,NULL),(9,'Libor',1992,9,NULL),(10,'Honza',1992,13,NULL),(11,'Míša',1991,NULL,NULL),(12,'Jarda',1989,8,NULL),(13,'Martin',1988,9,NULL),(14,'Pavel',1990,10,NULL),(15,'Petr',1988,9,NULL),(16,'Jiří',1987,10,NULL),(17,'Milan',1986,4,NULL),(18,'Mirek',1984,5,NULL),(19,'Vladimír',1976,2,NULL),(20,'Ivan',1972,15,NULL),(21,'Franta',1980,3,NULL),(22,'Šimon',1976,4,'dobrej borec'),(23,'Helena',1976,9,'dobrá borka'),(24,'Ivana',1977,8,NULL),(25,'Radka',1973,15,NULL),(26,'Leonard',1982,15,NULL),(27,'David',1974,1,NULL),(28,'Johanes',1983,6,NULL),(29,'Koko',1981,2,NULL),(30,'Ludvík',1972,1,NULL),(31,'Pepa',1977,11,NULL),(32,'Josef',1979,10,NULL),(33,'Dana',1983,14,NULL),(35,'Yanek',1976,NULL,NULL);
/*!40000 ALTER TABLE `lidi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zamestnani`
--

DROP TABLE IF EXISTS `zamestnani`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zamestnani` (
  `id_zamestnani` int(11) NOT NULL AUTO_INCREMENT,
  `nazev_zamestnani` varchar(30) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id_zamestnani`),
  UNIQUE KEY `nazev` (`nazev_zamestnani`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zamestnani`
--

LOCK TABLES `zamestnani` WRITE;
/*!40000 ALTER TABLE `zamestnani` DISABLE KEYS */;
INSERT INTO `zamestnani` VALUES (15,'fotograf'),(4,'hasič'),(7,'herec'),(10,'kuchař'),(16,'montér'),(8,'poslanec'),(2,'pošťák'),(9,'programátor'),(14,'řidič'),(17,'sazeč'),(3,'soustružník'),(5,'starosta'),(11,'truhlář'),(1,'učitel'),(6,'uhlobaron'),(12,'vychovatel'),(13,'zemědělec');
/*!40000 ALTER TABLE `zamestnani` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2013-04-25 11:15:32
