+) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+DROP TABLE IF EXISTS `barcode`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `barcode` (
+ `barcode_id` int(11) NOT NULL AUTO_INCREMENT,
+ `model_id` int(11) NOT NULL,
+ `barcode_name` varchar(128) COLLATE utf8_czech_ci NOT NULL,
+ PRIMARY KEY (`barcode_id`),
+ KEY `model_id` (`model_id`),
+ CONSTRAINT `barcode_ibfk_2` FOREIGN KEY (`model_id`) REFERENCES `model` (`model_id`) ON UPDATE CASCADE
+) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+DROP TABLE IF EXISTS `lock`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `lock` (
+ `lock_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+ `lock_author` int(11) unsigned NOT NULL,
+ `lock_name` varchar(4096) COLLATE utf8_czech_ci NOT NULL,
+ PRIMARY KEY (`lock_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+DROP TABLE IF EXISTS `transaction`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `transaction` (
+ `transaction_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+ `transaction_time` datetime NOT NULL,
+ `transaction_from` varchar(23) COLLATE utf8_czech_ci NOT NULL,
+ `transaction_to` varchar(23) COLLATE utf8_czech_ci NOT NULL,
+ `transaction_amount` int(11) NOT NULL,
+ `transaction_author` int(11) NOT NULL,
+ `transaction_comment` varchar(128) COLLATE utf8_czech_ci NOT NULL,
+ PRIMARY KEY (`transaction_id`)
+) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;