-- MySQL dump 10.19  Distrib 10.3.38-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: mfc
-- ------------------------------------------------------
-- Server version	10.3.38-MariaDB-0ubuntu0.20.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!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 `bins`
--

DROP TABLE IF EXISTS `bins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `licenceplate` int(11) DEFAULT NULL,
  `order` varchar(45) DEFAULT NULL,
  `deliveryDate` varchar(45) DEFAULT NULL,
  `slotRange` varchar(45) DEFAULT NULL,
  `containersQuantity` int(11) DEFAULT NULL,
  `rackId` int(11) DEFAULT NULL,
  `rackLevelId` int(11) DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=222 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bins`
--

LOCK TABLES `bins` WRITE;
/*!40000 ALTER TABLE `bins` DISABLE KEYS */;
INSERT INTO `bins` VALUES (2,90,'7361','2023-03-13','0900-1400',3,1,NULL,NULL),(3,90,'7361','2023-03-13','0900-1400',3,1,NULL,NULL),(4,90,'7361','2023-03-13','0900-1400',3,1,NULL,NULL),(5,90,'7361','2023-03-13','0900-1400',3,1,NULL,NULL),(6,90,'7361','2023-03-13','0900-1400',3,2,NULL,NULL),(7,90,'7361','2023-03-13','0900-1400',3,2,NULL,NULL),(8,90,'7361','2023-03-13','0900-1400',3,2,NULL,NULL),(9,90,'7361','2023-03-13','0900-1400',3,3,NULL,NULL),(10,90,'7361','2023-03-13','0900-1400',3,3,NULL,NULL),(11,90,'7361','2023-03-13','0900-1400',3,3,NULL,NULL),(12,90,'7361','2023-03-13','0900-1400',3,4,NULL,NULL),(13,90,'7361','2023-03-13','0900-1400',3,4,NULL,NULL),(14,90,'7361','2023-03-13','0900-1400',3,4,NULL,NULL),(15,90,'7361','2023-03-13','0900-1400',3,5,NULL,NULL),(16,78,'8241','2022-02-21','0900-1400',10,5,NULL,NULL),(17,56,'7361','2023-03-29','0900-1400',1,5,NULL,NULL),(18,56,'7361','2023-03-29','0900-1400',1,6,NULL,NULL),(19,90,'7361','2023-03-13','0900-1400',3,6,NULL,NULL),(20,90,'7361','2023-03-13','0900-1400',3,6,NULL,NULL),(21,56,'7361','2023-03-29','0900-1400',1,7,NULL,NULL),(22,56,'7361','2023-03-29','0900-1400',1,7,NULL,NULL),(23,56,'7361','2023-03-29','0900-1400',1,7,NULL,NULL),(24,90,'7361','2023-03-13','0900-1400',3,8,NULL,NULL),(25,90,'7361','2023-03-13','0900-1400',3,8,NULL,NULL),(26,90,'7361','2023-03-13','0900-1400',3,8,NULL,NULL),(27,90,'7361','2023-03-13','0900-1400',3,9,NULL,NULL),(28,90,'7361','2023-03-13','0900-1400',3,9,NULL,NULL),(29,56,'7361','2023-03-29','0900-1400',1,9,NULL,NULL),(30,56,'7361','2023-03-29','0900-1400',1,10,NULL,NULL),(31,56,'7361','2023-03-29','0900-1400',1,10,NULL,NULL),(32,56,'7361','2023-03-29','0900-1400',1,10,NULL,NULL),(33,56,'7361','2023-03-29','0900-1400',1,11,NULL,NULL),(34,56,'7361','2023-03-29','0900-1400',1,11,NULL,NULL),(35,56,'7361','2023-03-29','0900-1400',1,11,NULL,NULL),(36,56,'7361','2023-03-29','0900-1400',1,12,NULL,NULL),(37,56,'7361','2023-03-29','0900-1600',1,12,NULL,NULL),(38,56,'7361','2023-03-29','0900-1400',1,12,NULL,NULL),(39,56,'7361','2023-03-29','0900-1600',1,13,NULL,NULL),(40,56,'7361','2023-03-29','0900-1600',1,13,NULL,NULL),(41,56,'7361','2023-03-29','0900-1400',1,13,NULL,NULL),(42,56,'7361','2023-03-29','0900-1400',1,14,NULL,NULL),(43,56,'7361','2023-03-29','0900-1400',1,14,NULL,NULL),(44,56,'7361','2023-03-29','0900-1600',1,14,NULL,NULL),(45,56,'7361','2023-03-29','0900-1600',1,15,NULL,NULL),(46,56,'7361','2023-03-29','0900-1400',1,15,NULL,NULL),(47,56,'7361','2023-03-29','0900-1400',1,15,NULL,NULL),(48,56,'7361','2023-03-29','0900-1400',1,16,NULL,NULL),(49,10004333,'5002972389-17','2022-02-21','0900-1400',1,16,NULL,NULL),(50,987654321,'5002972323-15','2022-02-21','0900-1400',1,16,NULL,NULL),(51,10004333,'5002911111-965','2022-02-21','0900-1400',1,17,NULL,NULL),(52,10004333,'5002911111-555','2022-02-21','0900-1400',1,17,NULL,NULL),(53,10004333,'5002911111-999','2022-02-21','0900-1400',1,17,NULL,NULL),(54,10004333,'5002911111-889','2022-02-21','0900-1400',1,18,NULL,NULL),(55,10004333,'5002911111-569','2022-02-21','0900-1400',1,18,NULL,NULL),(56,10004333,'5002911111-5787','2022-02-21','0900-1400',1,18,NULL,NULL),(57,10004333,'5002911111-9685','2022-02-21','0900-1400',1,19,NULL,NULL),(58,90,'7361','2023-03-13','0900-1400',3,19,NULL,NULL),(59,90,'7361','2023-03-13','0900-1400',3,19,NULL,NULL),(60,10004333,'5002911111-7898','2022-02-21','0900-1400',1,20,NULL,NULL),(61,10004333,'50112211111-2','2022-02-21','0900-1400',1,20,NULL,NULL),(62,10004333,'50112211111-11','2022-02-21','0900-1400',1,20,NULL,NULL),(63,10004333,'50112211111-12','2022-02-21','0900-1400',1,21,NULL,NULL),(64,10004333,'50112211111-20','2022-02-21','0900-1400',1,21,NULL,NULL),(65,123456,'50029723555-OSR','2022-02-21','0900-1400',1,21,NULL,NULL),(66,264230991,'50029723290-FIL','2022-02-21','0900-1400',1,22,NULL,NULL),(67,264230991,'50029723291-FIL','2022-02-21','0900-1400',1,22,NULL,NULL),(68,987654321,'5002972439-FIL','2023-03-28','0900-1400',1,22,NULL,NULL),(69,987654321,'50029724390-FIL','2023-03-28','0900-1400',1,23,NULL,NULL),(70,987654321,'50029724391-FIL','2023-03-28','0900-1400',1,23,NULL,NULL),(71,987654321,'50029724392-FIL','2023-03-28','0900-1400',1,23,NULL,NULL),(72,987654321,'50029724393-FIL','2023-03-28','0900-1400',1,24,NULL,NULL),(73,56,'7361','2023-03-29','0900-1400',1,24,NULL,NULL),(74,987654321,'50029724394-FIL','2023-03-28','0900-1400',1,24,NULL,NULL),(75,987654321,'50029724395-FIL','2023-03-28','0900-1400',1,25,NULL,NULL),(76,56,'7361','2023-03-29','0900-1400',1,25,NULL,NULL),(77,56,'7361','2023-03-29','0900-1600',1,25,NULL,NULL),(78,56,'7361','2023-03-29','0900-1600',1,26,NULL,NULL),(79,987654321,'5002972439-FIL','2023-03-28','0900-1400',1,26,NULL,NULL),(80,123456,'5002972777-OSR','2022-02-21','0900-1400',1,26,NULL,NULL),(81,123456,'5002972888-OSR','2022-02-21','0900-1400',1,27,NULL,NULL),(82,123456,'5002972440-FIL','2023-03-28','0900-1400',1,27,NULL,NULL),(83,987654321,'5002972450-FIL','2023-03-28','0900-1400',1,27,NULL,NULL),(84,10004333,'70000000','2022-05-12','0900-1400',1,28,NULL,NULL),(85,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(86,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(87,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(88,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(89,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(90,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(91,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(92,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(93,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(94,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(95,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(96,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(97,78,'8241','2022-02-21','0900-1400',10,1,NULL,NULL),(98,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(99,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(100,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(101,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(102,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(103,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(104,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(105,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(106,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(107,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(108,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(109,78,'8241','2022-02-21','0900-1400',10,2,NULL,NULL),(110,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(111,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(112,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(113,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(114,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(115,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(116,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(117,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(118,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(119,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(120,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(121,78,'8241','2022-02-21','0900-1400',10,3,NULL,NULL),(122,78,'8241','2022-02-21','0900-1400',10,4,NULL,NULL),(123,78,'8241','2022-02-21','0900-1400',10,4,4,NULL),(124,78,'8241','2022-02-21','0900-1400',10,4,4,NULL),(125,78,'8241','2022-02-21','0900-1400',10,4,4,NULL),(126,78,'8241','2022-02-21','0900-1400',10,4,61,NULL),(127,78,'8241','2022-02-21','0900-1400',10,4,61,NULL),(128,78,'8241','2022-02-21','0900-1400',10,4,61,NULL),(129,78,'8241','2022-02-21','0900-1400',10,4,61,NULL),(130,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(131,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(132,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(133,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(134,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(135,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(136,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(137,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(138,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(139,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(140,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(141,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(142,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(143,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(144,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(145,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(146,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(147,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(148,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(149,78,'8241','2022-02-21','0900-1400',10,4,118,NULL),(150,78,'8241','2022-02-21','0900-1400',10,5,5,NULL),(151,78,'5555','2022-02-21','0900-1400',10,5,5,NULL),(152,78,'54555','2022-02-21','0900-1400',10,5,62,NULL),(153,78,'54555','2022-02-21','0900-1400',10,5,62,NULL),(154,78,'54555','2022-02-21','0900-1400',10,5,62,NULL),(155,78,'54555','2022-02-21','0900-1400',10,5,62,NULL),(156,78,'54555','2022-02-21','0900-1400',10,5,119,NULL),(157,78,'54555','2022-02-21','0900-1400',10,5,119,NULL),(158,78,'56755','2022-02-21','0900-1400',10,6,6,NULL),(159,78,'56755','2022-02-21','0900-1400',10,6,6,NULL),(160,78,'56755','2022-02-21','0900-1400',10,6,6,NULL),(161,78,'56755','2022-02-21','0900-1400',10,6,6,NULL),(162,78,'56755','2022-02-21','0900-1400',10,6,63,NULL),(163,78,'56755','2022-02-21','0900-1400',10,6,63,NULL),(164,78,'56755','2022-02-21','0900-1400',10,6,63,NULL),(165,78,'56755','2022-02-21','0900-1400',10,6,63,NULL),(166,78,'56755','2022-02-21','0900-1400',10,6,120,NULL),(167,78,'56755','2022-02-21','0900-1400',10,6,120,NULL),(168,78,'56755','2022-02-21','0900-1400',10,6,120,NULL),(169,78,'56755','2022-02-21','0900-1400',10,6,120,NULL),(170,78,'3','2022-02-21','0900-1400',10,37,94,NULL),(171,78,'3','2022-02-21','0900-1400',10,37,94,NULL),(172,78,'3','2022-02-21','0900-1400',10,37,94,NULL),(173,78,'3','2022-02-21','0900-1400',10,37,94,NULL),(174,78,'3','2022-02-21','0900-1400',10,37,37,NULL),(175,78,'344','2022-02-21','0900-1400',10,17,74,NULL),(176,78,'3','2022-02-21','0900-1400',10,37,37,NULL),(177,78,'3','2022-02-21','0900-1400',10,37,37,NULL),(178,78,'3','2022-02-21','0900-1400',10,37,37,NULL),(179,78,'3','2022-02-21','0900-1400',10,37,151,NULL),(180,78,'3','2022-02-21','0900-1400',10,37,151,NULL),(181,78,'3','2022-02-21','0900-1400',10,37,151,NULL),(182,78,'3','2022-02-21','0900-1400',10,37,151,NULL),(183,78,'3','2022-02-21','0900-1400',10,36,93,NULL),(184,78,'3','2022-02-21','0900-1400',10,36,93,NULL),(185,78,'3','2022-02-21','0900-1400',10,36,93,NULL),(186,78,'3','2022-02-21','0900-1400',10,36,93,NULL),(187,78,'3','2022-02-21','0900-1400',10,36,36,NULL),(188,78,'3','2022-02-21','0900-1400',10,36,36,NULL),(189,78,'3','2022-02-21','0900-1400',10,36,36,NULL),(190,78,'3','2022-02-21','0900-1400',10,36,36,NULL),(191,78,'3','2022-02-21','0900-1400',10,36,150,NULL),(192,78,'3','2022-02-21','0900-1400',10,36,150,NULL),(193,78,'3','2022-02-21','0900-1400',10,36,150,NULL),(194,78,'3','2022-02-21','0900-1400',10,36,150,NULL),(195,78,'3','2022-02-21','0900-1400',10,16,73,NULL),(196,78,'3','2022-02-21','0900-1400',10,16,73,NULL),(197,78,'3','2022-02-21','0900-1400',10,16,73,NULL),(198,78,'3','2022-02-21','0900-1400',10,16,73,NULL),(199,78,'3','2022-02-21','0900-1400',10,16,16,NULL),(200,78,'3','2022-02-21','0900-1400',10,16,16,NULL),(201,78,'3','2022-02-21','0900-1400',10,16,16,NULL),(202,78,'3','2022-02-21','0900-1400',10,16,16,NULL),(203,78,'3','2022-02-21','0900-1400',10,16,130,NULL),(204,78,'3','2022-02-21','0900-1400',10,16,130,NULL),(205,78,'3','2022-02-21','0900-1400',10,16,130,NULL),(206,78,'3','2022-02-21','0900-1400',10,16,130,NULL),(207,78,'3','2022-02-21','0900-1400',10,35,92,NULL),(208,78,'3','2022-02-21','0900-1400',10,35,92,NULL),(209,78,'3','2022-02-21','0900-1400',10,35,92,NULL),(210,78,'3','2022-02-21','0900-1400',10,35,92,NULL),(211,78,'3','2022-02-21','0900-1400',10,35,35,NULL),(212,78,'3','2022-02-21','0900-1400',10,35,35,NULL),(213,10004333,'501122111112-2','2022-02-21','0900-1400',1,15,72,NULL),(214,10004333,'501122111112-23','2022-02-21','0900-1400',2,34,91,NULL),(215,10004333,'501122111112-2356','2022-02-21','0900-1400',1,14,71,NULL),(216,10004333,'501122111112-23567','2022-02-21','0900-1400',1,33,90,NULL),(217,10004333,'501122111112-DEMO','2022-02-21','0900-1400',1,13,70,NULL),(218,78,'3','2022-02-21','0900-1400',10,35,35,NULL),(219,78,'5002','2023-02-21','0900-1400',1,17,17,NULL),(220,78,'5002972315-AMIDA-TEST2-DEV','2023-02-21','0900-1400',1,15,15,NULL),(221,12344321,'5002972315-AMIDA-TEST-NEW-TEST2','2024-02-21','0900-1400',1,34,34,NULL);
/*!40000 ALTER TABLE `bins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bins_log`
--

DROP TABLE IF EXISTS `bins_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bins_log` (
  `id` int(11) NOT NULL,
  `licenceplate` int(11) DEFAULT NULL,
  `order` varchar(45) DEFAULT NULL,
  `deliveryDate` varchar(45) DEFAULT NULL,
  `slotRange` varchar(45) DEFAULT NULL,
  `containersQuantity` int(11) DEFAULT NULL,
  `rackPosition` int(11) DEFAULT NULL,
  `timestamp` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bins_log`
--

LOCK TABLES `bins_log` WRITE;
/*!40000 ALTER TABLE `bins_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `bins_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `order` varchar(45) DEFAULT NULL,
  `insertDate` varchar(45) DEFAULT NULL,
  `rackLevelId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rack_levels`
--

DROP TABLE IF EXISTS `rack_levels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rack_levels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rack` int(11) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `lock_available` int(11) DEFAULT 4,
  `real_available` int(11) DEFAULT 1,
  `real_status` int(11) DEFAULT 0 COMMENT '0000:0\\n0001:1*\\n0010:2\\n0011:3*\\n0100:4\\n0101:5\\n0110:6\\n0111:7*\\n1000:8\\n1001:9\\n1010:10\\n1011:11\\n1100:12\\n1101:13\\n1110:14\\n1111:15*',
  `updatedAt` datetime DEFAULT NULL,
  `doordistance` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rack_cell` (`rack`,`level`,`real_available`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rack_levels`
--

LOCK TABLES `rack_levels` WRITE;
/*!40000 ALTER TABLE `rack_levels` DISABLE KEYS */;
INSERT INTO `rack_levels` VALUES (1,1,1,0,4,0,NULL,71),(2,2,1,0,4,0,NULL,69),(3,3,1,0,4,0,NULL,67),(4,4,1,0,4,0,NULL,65),(5,5,1,2,4,0,NULL,63),(6,6,1,0,4,0,NULL,48),(7,7,1,4,4,0,NULL,46),(8,8,1,4,4,0,NULL,44),(9,9,1,4,4,0,NULL,42),(10,10,1,4,4,0,NULL,40),(11,11,1,4,4,0,NULL,38),(12,12,1,4,4,0,NULL,36),(13,13,1,4,4,0,NULL,20),(14,14,1,4,4,0,NULL,18),(15,15,1,3,4,0,NULL,16),(16,16,1,0,4,0,NULL,14),(17,17,1,3,4,0,NULL,12),(18,18,1,4,4,0,NULL,74),(19,19,1,4,4,0,NULL,73),(20,20,1,4,4,0,NULL,72),(21,21,1,4,4,0,NULL,70),(22,22,1,4,4,0,NULL,68),(23,23,1,4,4,0,NULL,66),(24,24,1,4,4,0,NULL,64),(25,25,1,4,4,0,NULL,62),(26,26,1,4,4,0,NULL,47),(27,27,1,4,4,0,NULL,45),(28,28,1,4,4,0,NULL,43),(29,29,1,4,4,0,NULL,41),(30,30,1,4,4,0,NULL,39),(31,31,1,4,4,0,NULL,37),(32,32,1,4,4,0,NULL,35),(33,33,1,4,4,0,NULL,19),(34,34,1,3,4,0,NULL,17),(35,35,1,1,4,0,NULL,15),(36,36,1,0,4,0,NULL,13),(37,37,1,0,4,0,NULL,11),(41,41,1,4,4,0,NULL,151),(42,42,1,4,4,0,NULL,150),(43,43,1,4,4,0,NULL,149),(44,44,1,4,4,0,NULL,148),(45,45,1,4,4,0,NULL,147),(46,46,1,4,4,0,NULL,146),(47,47,1,4,4,0,NULL,145),(48,48,1,4,4,0,NULL,144),(49,49,1,4,4,0,NULL,143),(50,50,1,4,4,0,NULL,142),(51,51,1,4,4,0,NULL,141),(52,52,1,4,4,0,NULL,140),(53,53,1,4,4,0,NULL,139),(54,54,1,4,4,0,NULL,138),(55,55,1,4,4,0,NULL,137),(56,56,1,4,4,0,NULL,136),(57,57,1,4,4,0,NULL,135),(58,1,2,0,4,0,NULL,58),(59,2,2,0,4,0,NULL,56),(60,3,2,0,4,0,NULL,54),(61,4,2,0,4,0,NULL,52),(62,5,2,0,4,0,NULL,50),(63,6,2,0,4,0,NULL,34),(64,7,2,4,4,0,NULL,32),(65,8,2,4,4,0,NULL,30),(66,9,2,4,4,0,NULL,28),(67,10,2,4,4,0,NULL,26),(68,11,2,4,4,0,NULL,24),(69,12,2,4,4,0,NULL,22),(70,13,2,3,4,0,NULL,10),(71,14,2,3,4,0,NULL,8),(72,15,2,3,4,0,NULL,6),(73,16,2,0,4,0,NULL,4),(74,17,2,3,4,0,NULL,2),(75,18,2,4,4,0,NULL,61),(76,19,2,4,4,0,NULL,60),(77,20,2,4,4,0,NULL,59),(78,21,2,4,4,0,NULL,57),(79,22,2,4,4,0,NULL,55),(80,23,2,4,4,0,NULL,53),(81,24,2,4,4,0,NULL,51),(82,25,2,4,4,0,NULL,49),(83,26,2,4,4,0,NULL,33),(84,27,2,4,4,0,NULL,31),(85,28,2,4,4,0,NULL,29),(86,29,2,4,4,0,NULL,27),(87,30,2,4,4,0,NULL,25),(88,31,2,4,4,0,NULL,23),(89,32,2,4,4,0,NULL,21),(90,33,2,3,4,0,NULL,9),(91,34,2,3,4,0,NULL,7),(92,35,2,0,4,0,NULL,5),(93,36,2,0,4,0,NULL,3),(94,37,2,0,4,0,NULL,1),(98,41,2,4,4,0,NULL,131),(99,42,2,4,4,0,NULL,130),(100,43,2,4,4,0,NULL,129),(101,44,2,4,4,0,NULL,128),(102,45,2,4,4,0,NULL,127),(103,46,2,4,4,0,NULL,126),(104,47,2,4,4,0,NULL,125),(105,48,2,4,4,0,NULL,124),(106,49,2,4,4,0,NULL,123),(107,50,2,4,4,0,NULL,122),(108,51,2,4,4,0,NULL,121),(109,52,2,4,4,0,NULL,120),(110,53,2,4,4,0,NULL,119),(111,54,2,4,4,0,NULL,118),(112,55,2,4,4,0,NULL,117),(113,56,2,4,4,0,NULL,116),(114,57,2,4,4,0,NULL,115),(115,1,3,0,4,0,NULL,108),(116,2,3,0,4,0,NULL,106),(117,3,3,0,4,0,NULL,104),(118,4,3,0,4,0,NULL,102),(119,5,3,2,4,0,NULL,100),(120,6,3,0,4,0,NULL,98),(121,7,3,4,4,0,NULL,96),(122,8,3,4,4,0,NULL,94),(123,9,3,4,4,0,NULL,92),(124,10,3,4,4,0,NULL,90),(125,11,3,4,4,0,NULL,88),(126,12,3,4,4,0,NULL,86),(127,13,3,4,4,0,NULL,84),(128,14,3,4,4,0,NULL,82),(129,15,3,4,4,0,NULL,80),(130,16,3,0,4,0,NULL,78),(131,17,3,4,4,0,NULL,76),(132,18,3,4,4,0,NULL,111),(133,19,3,4,4,0,NULL,110),(134,20,3,4,4,0,NULL,109),(135,21,3,4,4,0,NULL,107),(136,22,3,4,4,0,NULL,105),(137,23,3,4,4,0,NULL,103),(138,24,3,4,4,0,NULL,101),(139,25,3,4,4,0,NULL,99),(140,26,3,4,4,0,NULL,97),(141,27,3,4,4,0,NULL,95),(142,28,3,4,4,0,NULL,93),(143,29,3,4,4,0,NULL,91),(144,30,3,4,4,0,NULL,89),(145,31,3,4,4,0,NULL,87),(146,32,3,4,4,0,NULL,85),(147,33,3,4,4,0,NULL,83),(148,34,3,4,4,0,NULL,81),(149,35,3,4,4,0,NULL,79),(150,36,3,0,4,0,NULL,77),(151,37,3,0,4,0,NULL,75),(155,41,3,4,4,0,NULL,171),(156,42,3,4,4,0,NULL,170),(157,43,3,4,4,0,NULL,169),(158,44,3,4,4,0,NULL,168),(159,45,3,4,4,0,NULL,167),(160,46,3,4,4,0,NULL,166),(161,47,3,4,4,0,NULL,165),(162,48,3,4,4,0,NULL,164),(163,49,3,4,4,0,NULL,163),(164,50,3,4,4,0,NULL,162),(165,51,3,4,4,0,NULL,161),(166,52,3,4,4,0,NULL,160),(167,53,3,4,4,0,NULL,159),(168,54,3,4,4,0,NULL,158),(169,55,3,4,4,0,NULL,157),(170,56,3,4,4,0,NULL,156),(171,57,3,4,4,0,NULL,155);
/*!40000 ALTER TABLE `rack_levels` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rack_log`
--

DROP TABLE IF EXISTS `rack_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rack_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rack` int(11) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `position` int(11) DEFAULT 1,
  `status` int(11) DEFAULT 0 COMMENT '0000:0\n0001:1*\n0010:2\n0011:3*\n0100:4\n0101:5\n0110:6\n0111:7*\n1000:8\n1001:9\n1010:10\n1011:11\n1100:12\n1101:13\n1110:14\n1111:15*',
  `timestamp` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rack_cell` (`rack`,`level`,`position`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rack_log`
--

LOCK TABLES `rack_log` WRITE;
/*!40000 ALTER TABLE `rack_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `rack_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `status_map`
--

DROP TABLE IF EXISTS `status_map`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `status_map` (
  `status` int(11) NOT NULL,
  `available` int(11) DEFAULT NULL,
  PRIMARY KEY (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `status_map`
--

LOCK TABLES `status_map` WRITE;
/*!40000 ALTER TABLE `status_map` DISABLE KEYS */;
/*!40000 ALTER TABLE `status_map` 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 2023-06-20 15:49:49
