-- MySQL dump 10.11
--
-- Host: 192.168.1.6    Database: kdm
-- ------------------------------------------------------
-- Server version	5.0.88-log

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

--
-- Table structure for table `ttlacitka`
--

DROP TABLE IF EXISTS `ttlacitka`;
CREATE TABLE `ttlacitka` (
  `Tlacitko_id` int(11) unsigned NOT NULL auto_increment,
  `TlacitkoTxt` varchar(50) default NULL,
  `Zbozi_id` int(11) default NULL,
  `NadSkupina_id` int(11) default NULL,
  `Vlastnost_idx` int(4) default '0',
  `PosX` int(4) default '0',
  `PosY` int(4) default '0',
  `SkupinaTl_id` int(11) NOT NULL default '0',
  `Color` int(11) NOT NULL default '16777215',
  `u_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`Tlacitko_id`)
) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=utf8 COMMENT='Tlacitka bufetu';

--
-- Dumping data for table `ttlacitka`
--

LOCK TABLES `ttlacitka` WRITE;
/*!40000 ALTER TABLE `ttlacitka` DISABLE KEYS */;
INSERT INTO `ttlacitka` VALUES (4,'ghkff',NULL,NULL,0,3,0,0,16777215,5),(8,'Oběd 1',1078,NULL,0,0,0,0,16777215,5),(9,'Oběd 2',1079,NULL,0,1,0,0,16777215,5),(10,'Polévka',1219,NULL,0,2,0,0,16777215,5),(11,'med - porce',214,NULL,0,0,1,157,16777215,6),(12,'Mléko 1l',620,NULL,0,0,1,157,16777215,6),(13,'Švestkový koláč',666,NULL,0,0,1,160,16777215,6),(14,'Bohemia sekt 0.7',846,NULL,0,4,1,156,16777215,6),(15,'Pizza šunková',910,NULL,0,2,4,162,16777215,6),(16,'Oplatky - tatranky',1004,NULL,0,2,2,163,16777215,6),(17,'Menu box',1021,NULL,0,0,1,157,16777215,6),(18,'Bonaqua pet 0.5l',1081,NULL,0,2,4,154,16777215,6),(19,'Bernard  0,3l',1082,NULL,0,4,1,153,16777215,6),(20,'Točená limonáda-čaj ',1083,NULL,0,4,3,152,16777215,6),(21,'Kofola 0,2',1084,NULL,0,5,3,152,16777215,6),(22,'Kofola 0,3',1085,NULL,0,5,2,152,16777215,6),(23,'Kofola 0,4',1086,NULL,0,4,2,152,16777215,6),(24,'Kofola 0,5',1087,NULL,0,3,4,152,16777215,6),(25,'Coca -cola SKLO',1088,NULL,0,3,3,152,16777215,6),(26,'Cappy sklo 0,2 l',1089,NULL,0,3,2,152,16777215,6),(27,'Tonic sklo 0,25l',1090,NULL,0,3,1,152,16777215,6),(28,'Coca - cola PET 0,5l',1091,NULL,0,3,3,154,16777215,6),(29,'Fanta pet 0,5l',1092,NULL,0,2,3,154,16777215,6),(30,'Sprite pet 0,5l',1093,NULL,0,3,2,154,16777215,6),(31,'Cappy pet 0,5l',1094,NULL,0,3,1,154,16777215,6),(32,'Nestea pet 0,5l',1095,NULL,0,2,2,154,16777215,6),(33,'Monster energy 0,5l',1096,NULL,0,2,1,154,16777215,6),(34,'Rum 0.02',1097,NULL,0,3,8,166,16777215,6),(35,'Rum 0,04',1098,NULL,0,2,8,166,16777215,6),(36,'Captain Morgan 0,04',1099,NULL,0,2,0,166,16777215,6),(37,'Grog 0,02 ',1100,NULL,0,5,2,155,16777215,6),(38,'Grog 0,04',1101,NULL,0,4,3,155,16777215,6),(39,'Vaječný koňak 0,02',1102,NULL,0,3,7,166,16777215,6),(40,'Vaječný koňak 0,04',1103,NULL,0,2,7,166,16777215,6),(41,'Fernet 0,02',1104,NULL,0,5,6,166,16777215,6),(42,'Fernet 0,04',1105,NULL,0,4,6,166,16777215,6),(43,'Fernet citrus 0,02',1106,NULL,0,3,6,166,16777215,6),(44,'Fernet citrus 0,04',1107,NULL,0,2,6,166,16777215,6),(45,'GIN gordons 0,04',1108,NULL,0,2,5,166,16777215,6),(46,'FINLANDIA vodka 0,04',1109,NULL,0,2,4,166,16777215,6),(47,'Ballantines WHISKY 0,04',1110,NULL,0,2,3,166,16777215,6),(48,'Becherovka 0,02',1111,NULL,0,3,2,166,16777215,6),(49,'Becherovka 0,0,4',1112,NULL,0,2,2,166,16777215,6),(50,'Whisky CREAM 0,04',1113,NULL,0,7,1,164,16777215,6),(51,'Víno červené 0,1l',1114,NULL,0,3,1,156,16777215,6),(52,'Víno bílé 0,1l',1115,NULL,0,2,1,156,16777215,6),(53,'Svařák 0,2',1116,NULL,0,3,3,155,16777215,6),(54,'Cinzano rosso 1dc',1117,NULL,0,3,1,166,16777215,6),(55,'Cinzano bianco 1dc ',1118,NULL,0,2,1,166,16777215,6),(56,'Pivo - Plzeň 12° ',1120,NULL,0,3,1,153,16777215,6),(57,'Pivo nealko 0,5l Bernard ',1121,NULL,0,2,1,153,16777215,6),(58,'PEČIVO',1122,NULL,0,0,1,157,16777215,6),(59,'OVOCE',1123,NULL,0,0,1,157,16777215,6),(60,'Jídelní lístek',1125,NULL,0,0,1,157,16777215,6),(61,'Espresso malé/velké ',1126,NULL,0,2,3,158,16777215,6),(62,'Cappucinno  / Latte káva ',1127,NULL,0,6,2,158,16777215,6),(63,'Turek',1128,NULL,0,5,2,158,16777215,6),(64,'Alžírská káva ',1129,NULL,0,4,2,158,16777215,6),(65,'Irská káva',1130,NULL,0,3,2,158,16777215,6),(66,'Vídeňská káva ',1131,NULL,0,2,2,158,16777215,6),(67,'Káva se zmrzlinou',1132,NULL,0,6,1,158,16777215,6),(68,'Mléčné frappé ',1133,NULL,0,5,1,158,16777215,6),(69,'Horká čokoláda',1134,NULL,0,4,1,158,16777215,6),(70,'Horká čokoláda s vaječnákem ',1135,NULL,0,3,1,158,16777215,6),(71,'Porce smetany do kávy  ',1136,NULL,0,2,1,158,16777215,6),(72,'Čaj černý ',1137,NULL,0,4,2,159,16777215,6),(73,'Čaj zelený ',1138,NULL,0,4,1,159,16777215,6),(74,'Čaj ovocný ',1139,NULL,0,3,2,159,16777215,6),(75,'Čaj mátový',1140,NULL,0,3,1,159,16777215,6),(76,'Horký nápoj jahoda',1141,NULL,0,3,2,155,16777215,6),(77,'Horký nápoj brusinka',1142,NULL,0,4,2,155,16777215,6),(78,'Horký nápoj višeň ',1143,NULL,0,4,1,155,16777215,6),(79,'Horký nápoj hruška',1144,NULL,0,3,1,155,16777215,6),(80,'Horký nápoj jablko',1145,NULL,0,2,1,155,16777215,6),(81,'Dort MEDOVNÍK ',1146,NULL,0,0,1,160,16777215,6),(82,'Dort MANDLOVÝ  ',1147,NULL,0,0,1,160,16777215,6),(83,'Belgický jablečný koláč ',1149,NULL,0,0,1,160,16777215,6),(84,'Domácí jablečný závin ',1150,NULL,0,0,1,160,16777215,6),(85,'Rakvička   1ks.',1151,NULL,0,0,1,160,16777215,6),(86,'Horká láska ',1152,NULL,0,0,1,161,16777215,6),(87,'Ovocné osvěžení',1153,NULL,0,0,1,161,16777215,6),(88,'Veselý pohár ',1154,NULL,0,0,1,161,16777215,6),(89,'Ořechové potěšení',1155,NULL,0,0,1,161,16777215,6),(90,'Pohár Ludmila ',1156,NULL,0,0,1,161,16777215,6),(91,'Karamelový pohár',1157,NULL,0,0,1,161,16777215,6),(92,'Likérový sen ',1158,NULL,0,0,1,161,16777215,6),(93,'Kopeček zmrzliny ',1159,NULL,0,0,1,161,16777215,6),(94,'Palačinka se zmrzlinou',1160,NULL,0,0,1,160,16777215,6),(95,'Palačinka s ovocem',1161,NULL,0,0,1,160,16777215,6),(96,'Míchaná vajíčka',1162,NULL,0,7,3,162,16777215,6),(97,'Vídeňské párky',1163,NULL,0,6,3,162,16777215,6),(98,'Pečená šunka s vejci ',1164,NULL,0,5,3,162,16777215,6),(99,'Marinovaná kuřecí křídla ',1165,NULL,0,4,3,162,16777215,6),(100,'Smažený sýr',1166,NULL,0,3,3,162,16777215,6),(101,'Smažený camemmbert',1167,NULL,0,2,3,162,16777215,6),(102,'Obalované kuřecí kousky ',1168,NULL,0,7,2,162,16777215,6),(103,'Bramboráková kapsa se zelím ',1169,NULL,0,6,2,162,16777215,6),(104,'Pizza sýrová',1171,NULL,0,5,2,162,16777215,6),(105,'Langoš s kečupem a sýrem',1172,NULL,0,4,2,162,16777215,6),(106,'Smažený vepřový řízek',1173,NULL,0,3,2,162,16777215,6),(107,'Hranolky ',1174,NULL,0,2,2,162,16777215,6),(108,'Americké brambory',1175,NULL,0,7,1,162,16777215,6),(109,'Bramboráčky',1176,NULL,0,6,1,162,16777215,6),(110,'Toasty se šunkou a sýrem',1177,NULL,0,5,1,162,16777215,6),(111,'CHLEBÍČEK se šunkou',1178,NULL,0,4,1,162,16777215,6),(112,'Tatarská omáčka',1179,NULL,0,3,1,162,16777215,6),(113,'Kečup',1180,NULL,0,2,1,162,16777215,6),(114,'Lízátka kulata',1181,NULL,0,7,1,163,16777215,6),(115,'Žvýkačky ORBIT',1182,NULL,0,6,1,163,16777215,6),(116,'Skittles  bonbony',1183,NULL,0,5,1,163,16777215,6),(117,'Sušenky coco a trubikčy',1184,NULL,0,4,1,163,16777215,6),(118,'Tatranka',1185,NULL,0,3,1,163,16777215,6),(119,'Brambůrky',1186,NULL,0,2,1,163,16777215,6),(120,'WAFFLE se šlehačkou a čokoládou',1187,NULL,0,6,1,164,16777215,6),(121,'WAFFLE s čokoládou a cukrem',1188,NULL,0,5,1,164,16777215,6),(122,'WAFFLE se zmrzlinou a šlehačkou',1189,NULL,0,4,1,164,16777215,6),(123,'WAFFLE s ovocem a šlehačkou',1190,NULL,0,3,1,164,16777215,6),(124,'WAFFLE s ovocem a zmrzlinou',1191,NULL,0,2,1,164,16777215,6),(125,'TORPÉDO',1192,NULL,0,0,1,165,16777215,6),(126,'Mrož ',1193,NULL,0,0,1,165,16777215,6),(127,'Mrož tvarohovej ',1194,NULL,0,0,1,165,16777215,6),(128,'Tygr',1195,NULL,0,0,1,165,16777215,6),(129,'PEGAS VELKÝ  - premium',1196,NULL,0,0,1,165,16777215,6),(130,'PEGAS malej  ',1197,NULL,0,0,1,165,16777215,6),(131,'Kuba ',1198,NULL,0,0,1,165,16777215,6),(132,'Fit line',1199,NULL,0,0,1,165,16777215,6),(133,'SNACK MILK',1200,NULL,0,0,1,165,16777215,6),(134,'KEKS ROLL',1201,NULL,0,0,1,165,16777215,6),(135,'ChocoMilk',1202,NULL,0,0,1,165,16777215,6),(136,'RUSKÁ ZMRZLINA ',1203,NULL,0,0,1,165,16777215,6),(137,'RUSKÁ kornout',1204,NULL,0,0,1,165,16777215,6),(138,'MROŽ kornout ',1205,NULL,0,0,1,165,16777215,6),(139,'Mrož dřeň ',1206,NULL,0,0,1,165,16777215,6),(140,'Pegas kornout ',1207,NULL,0,0,1,165,16777215,6),(141,'Eiskoko',1208,NULL,0,0,1,165,16777215,6),(142,'PARÁDA',1209,NULL,0,0,1,165,16777215,6),(143,'Vanilková zmrzlina 4,5l',1210,NULL,0,0,1,157,16777215,6),(144,'Jahodová zmrzlina 2,2l',1211,NULL,0,0,1,157,16777215,6),(145,'Čokoládová zmrzlina 2,2l',1212,NULL,0,0,1,157,16777215,6),(146,'Ořechová zmrzlina 2,2l',1213,NULL,0,0,1,157,16777215,6),(147,'Karamelová zmrzlina 2,2l',1214,NULL,0,0,1,157,16777215,6),(148,'Citrónová zmrzlina 4,5l',1215,NULL,0,0,1,157,16777215,6),(149,'Šlehačka sprej',1216,NULL,0,0,1,157,16777215,6),(150,'Citróny',1218,NULL,0,0,1,157,16777215,6),(151,'Obědy',NULL,NULL,0,2,6,0,16777215,6),(152,'Nealko nápoje',NULL,NULL,0,5,1,0,16777215,6),(153,'Pivo',NULL,NULL,0,2,2,0,16777215,6),(154,'Nealko pet',NULL,NULL,0,3,1,0,16777215,6),(155,'Teplé nápoje',NULL,NULL,0,6,1,0,16777215,6),(156,'Víno',NULL,NULL,0,2,3,0,16777215,6),(157,'Ostatní',NULL,NULL,0,7,7,0,16777215,6),(158,'Káva',NULL,NULL,0,6,3,0,16777215,6),(159,'Čaj',NULL,NULL,0,6,2,0,16777215,6),(160,'Dorty',NULL,NULL,0,5,5,0,16777215,6),(161,'Zmrlinové poháry',NULL,NULL,0,7,5,0,16777215,6),(162,'Jídlo',NULL,NULL,0,2,5,0,16777215,6),(163,'Cukrovinky',NULL,NULL,0,6,5,0,16777215,6),(164,'Waffle',NULL,NULL,0,5,6,0,16777215,6),(165,'Nanuky',NULL,NULL,0,8,5,0,16777215,6),(166,'Alko nápoje',NULL,NULL,0,3,0,0,16777215,6);
/*!40000 ALTER TABLE `ttlacitka` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trozdelzbozi`
--

DROP TABLE IF EXISTS `trozdelzbozi`;
CREATE TABLE `trozdelzbozi` (
  `RozdelZbozi_id` int(11) unsigned NOT NULL auto_increment,
  `zbozi_id` int(11) default NULL,
  `SkupZbozi_id` int(11) default NULL,
  `Poradi` int(4) default '0',
  PRIMARY KEY  (`RozdelZbozi_id`),
  UNIQUE KEY `SkupZb_u` (`zbozi_id`,`SkupZbozi_id`),
  KEY `poradi_i` (`Poradi`),
  KEY `zbozi_id_i` (`zbozi_id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `trozdelzbozi`
--

LOCK TABLES `trozdelzbozi` WRITE;
/*!40000 ALTER TABLE `trozdelzbozi` DISABLE KEYS */;
INSERT INTO `trozdelzbozi` VALUES (1,1078,1,0),(2,1079,1,0),(3,1080,1,0),(4,1219,1,0),(5,214,2,0),(6,620,2,0),(7,666,2,0),(8,846,2,0),(9,910,2,0),(10,1004,2,0),(11,1021,2,0),(12,1081,2,0),(13,1082,2,0),(14,1083,2,0),(15,1084,2,0),(16,1085,2,0),(17,1086,2,0),(18,1087,2,0),(19,1088,2,0),(20,1089,2,0),(21,1090,2,0),(22,1091,2,0),(23,1092,2,0),(24,1093,2,0),(25,1094,2,0),(26,1095,2,0),(27,1096,2,0),(28,1097,2,0),(29,1098,2,0),(30,1099,2,0),(31,1100,2,0),(32,1101,2,0),(33,1102,2,0),(34,1103,2,0),(35,1104,2,0),(36,1105,2,0),(37,1106,2,0),(38,1107,2,0),(39,1108,2,0),(40,1109,2,0),(41,1110,2,0),(42,1111,2,0),(43,1112,2,0),(44,1113,2,0),(45,1114,2,0),(46,1115,2,0),(47,1116,2,0),(48,1117,2,0),(49,1118,2,0),(50,1120,2,0),(51,1121,2,0),(52,1122,2,0),(53,1123,2,0),(54,1125,2,0),(55,1126,2,0),(56,1127,2,0),(57,1128,2,0),(58,1129,2,0),(59,1130,2,0),(60,1131,2,0),(61,1132,2,0),(62,1133,2,0),(63,1134,2,0),(64,1135,2,0),(65,1136,2,0),(66,1137,2,0),(67,1138,2,0),(68,1139,2,0),(69,1140,2,0),(70,1141,2,0),(71,1142,2,0),(72,1143,2,0),(73,1144,2,0),(74,1145,2,0),(75,1146,2,0),(76,1147,2,0),(77,1149,2,0),(78,1150,2,0),(79,1151,2,0),(80,1152,2,0),(81,1153,2,0),(82,1154,2,0),(83,1155,2,0),(84,1156,2,0),(85,1157,2,0),(86,1158,2,0),(87,1159,2,0),(88,1160,2,0),(89,1161,2,0),(90,1162,2,0),(91,1163,2,0),(92,1164,2,0),(93,1165,2,0),(94,1166,2,0),(95,1167,2,0),(96,1168,2,0),(97,1169,2,0),(98,1171,2,0),(99,1172,2,0),(100,1173,2,0),(101,1174,2,0),(102,1175,2,0),(103,1176,2,0),(104,1177,2,0),(105,1178,2,0),(106,1179,2,0),(107,1180,2,0),(108,1181,2,0),(109,1182,2,0),(110,1183,2,0),(111,1184,2,0),(112,1185,2,0),(113,1186,2,0),(114,1187,2,0),(115,1188,2,0),(116,1189,2,0),(117,1190,2,0),(118,1191,2,0),(119,1192,2,0),(120,1193,2,0),(121,1194,2,0),(122,1195,2,0),(123,1196,2,0),(124,1197,2,0),(125,1198,2,0),(126,1199,2,0),(127,1200,2,0),(128,1201,2,0),(129,1202,2,0),(130,1203,2,0),(131,1204,2,0),(132,1205,2,0),(133,1206,2,0),(134,1207,2,0),(135,1208,2,0),(136,1209,2,0),(137,1210,2,0),(138,1211,2,0),(139,1212,2,0),(140,1213,2,0),(141,1214,2,0),(142,1215,2,0),(143,1216,2,0),(144,1218,2,0);
/*!40000 ALTER TABLE `trozdelzbozi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tskupzbozi`
--

DROP TABLE IF EXISTS `tskupzbozi`;
CREATE TABLE `tskupzbozi` (
  `SkupZbozi_id` int(10) unsigned NOT NULL auto_increment,
  `SkupZboziTxt` varchar(30) default NULL,
  PRIMARY KEY  (`SkupZbozi_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tskupzbozi`
--

LOCK TABLES `tskupzbozi` WRITE;
/*!40000 ALTER TABLE `tskupzbozi` DISABLE KEYS */;
INSERT INTO `tskupzbozi` VALUES (1,'Bufet'),(2,'Kavárna');
/*!40000 ALTER TABLE `tskupzbozi` 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 2014-03-04 10:24:18
