-- MySQL dump 10.14 Distrib 5.5.64-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: TOFMap2 -- ------------------------------------------------------ -- Server version 5.5.64-MariaDB /*!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 `adc` -- DROP TABLE IF EXISTS `adc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adc` ( `serialNo` varchar(32) NOT NULL, `adcLocationId` smallint(6) NOT NULL, PRIMARY KEY (`serialNo`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `adc` -- LOCK TABLES `adc` WRITE; /*!40000 ALTER TABLE `adc` DISABLE KEYS */; INSERT INTO `adc` VALUES ('ACDI-065',7),('ACDI-079',1),('ACDI-202',4),('ACDI-227',10),('ACDI-230',5),('ACDI-255',3),('ACDI-265',11),('ACDI-310',6),('ACDI-518',8),('ACDI-561',9),('ACDI-603',2),('unknown_1',12); /*!40000 ALTER TABLE `adc` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `adcCable` -- DROP TABLE IF EXISTS `adcCable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adcCable` ( `id` smallint(6) NOT NULL, `label` varchar(128) NOT NULL, `splitterLocationId` smallint(6) DEFAULT NULL, `adcLocationId` smallint(6) DEFAULT NULL, `channel` smallint(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `adcCable` -- LOCK TABLES `adcCable` WRITE; /*!40000 ALTER TABLE `adcCable` DISABLE KEYS */; INSERT INTO `adcCable` VALUES (1,'TOF-UP-A-1',1,6,8),(2,'TOF-UP-A-2',2,6,9),(3,'TOF-UP-A-3',3,6,10),(4,'TOF-UP-A-4',4,6,11),(5,'TOF-UP-A-5',5,6,12),(6,'TOF-UP-A-6',6,6,13),(7,'TOF-UP-A-7',7,6,14),(8,'TOF-UP-A-8',8,6,15),(9,'TOF-UP-A-9',9,7,0),(10,'TOF-UP-A-10',10,7,1),(11,'TOF-UP-A-11',11,7,2),(12,'TOF-UP-A-12',12,7,3),(13,'TOF-UP-A-13',13,7,4),(14,'TOF-UP-A-14',14,7,5),(15,'TOF-UP-A-15',15,7,6),(16,'TOF-UP-A-16',16,7,7),(17,'TOF-UP-A-17',17,7,8),(18,'TOF-UP-A-18',18,7,9),(19,'TOF-UP-A-19',19,7,10),(20,'TOF-UP-A-20',20,7,11),(21,'TOF-UP-A-21',21,7,12),(22,'TOF-UP-A-22',22,7,13),(23,'TOF-UP-A-45',23,12,4),(24,'TOF-UP-A-46',24,12,5),(25,'TOF-UP-A-23',25,7,14),(26,'TOF-UP-A-24',26,7,15),(27,'TOF-UP-A-25',27,8,0),(28,'TOF-UP-A-26',28,8,1),(29,'TOF-UP-A-27',29,8,2),(30,'TOF-UP-A-28',30,8,3),(31,'TOF-UP-A-29',31,8,4),(32,'TOF-UP-A-30',32,8,5),(33,'TOF-UP-A-31',33,8,6),(34,'TOF-UP-A-32',34,8,7),(35,'TOF-UP-A-33',35,8,8),(36,'TOF-UP-A-34',36,8,9),(37,'TOF-UP-A-35',37,8,10),(38,'TOF-UP-A-36',38,8,11),(39,'TOF-UP-A-37',39,8,12),(40,'TOF-UP-A-38',40,8,13),(41,'TOF-UP-A-39',41,8,14),(42,'TOF-UP-A-40',42,8,15),(43,'TOF-UP-A-41',43,9,0),(44,'TOF-UP-A-42',44,9,1),(45,'TOF-UP-A-43',45,9,2),(46,'TOF-UP-A-44',46,9,3),(47,'TOF-DW-A-44',47,11,15),(48,'TOF-DW-A-43',48,11,14),(49,'TOF-DW-A-42',49,11,13),(50,'TOF-DW-A-41',50,11,12),(51,'TOF-DW-A-40',51,11,11),(52,'TOF-DW-A-39',52,11,10),(53,'TOF-DW-A-38',53,11,9),(54,'TOF-DW-A-37',54,11,8),(55,'TOF-DW-A-36',55,11,7),(56,'TOF-DW-A-35',56,11,6),(57,'TOF-DW-A-34',57,11,5),(58,'TOF-DW-A-33',58,11,4),(59,'TOF-DW-A-32',59,11,3),(60,'TOF-DW-A-31',60,11,2),(61,'TOF-DW-A-30',61,11,1),(62,'TOF-DW-A-29',62,11,0),(63,'TOF-DW-A-28',63,10,15),(64,'TOF-DW-A-27',64,10,14),(65,'TOF-DW-A-26',65,10,13),(66,'TOF-DW-A-25',66,10,12),(67,'TOF-DW-A-24',67,10,11),(68,'TOF-DW-A-23',68,10,10),(69,'TOF-DW-A-46',69,12,7),(70,'TOF-DW-A-45',70,12,6),(71,'TOF-DW-A-22',71,10,9),(72,'TOF-DW-A-21',72,10,8),(73,'TOF-DW-A-20',73,10,7),(74,'TOF-DW-A-19',74,10,6),(75,'TOF-DW-A-18',75,10,5),(76,'TOF-DW-A-17',76,10,4),(77,'TOF-DW-A-16',77,10,3),(78,'TOF-DW-A-15',78,10,2),(79,'TOF-DW-A-14',79,10,1),(80,'TOF-DW-A-13',80,10,0),(81,'TOF-DW-A-12',81,9,15),(82,'TOF-DW-A-11',82,9,14),(83,'TOF-DW-A-10',83,9,13),(84,'TOF-DW-A-9',84,9,12),(85,'TOF-DW-A-8',85,9,11),(86,'TOF-DW-A-7',86,9,10),(87,'TOF-DW-A-6',87,9,9),(88,'TOF-DW-A-5',88,9,8),(89,'TOF-DW-A-4',89,9,7),(90,'TOF-DW-A-3',90,9,6),(91,'TOF-DW-A-2',91,9,5),(92,'TOF-DW-A-1',92,9,4),(93,'TOF-S-A-1',93,3,12),(94,'TOF-S-A-2',94,3,13),(95,'TOF-S-A-3',95,3,14),(96,'TOF-S-A-4',96,3,15),(97,'TOF-S-A-5',97,4,0),(98,'TOF-S-A-6',98,4,1),(99,'TOF-S-A-7',99,4,2),(100,'TOF-S-A-8',100,4,3),(101,'TOF-S-A-9',101,4,4),(102,'TOF-S-A-10',102,4,5),(103,'TOF-S-A-11',103,4,6),(104,'TOF-S-A-12',104,4,7),(105,'TOF-S-A-13',105,4,8),(106,'TOF-S-A-14',106,4,9),(107,'TOF-S-A-15',107,4,10),(108,'TOF-S-A-16',108,4,11),(109,'TOF-S-A-17',109,4,12),(110,'TOF-S-A-18',110,4,13),(111,'TOF-S-A-19',111,4,14),(112,'TOF-S-A-20',112,4,15),(113,'TOF-S-A-21',113,5,0),(114,'TOF-S-A-22',114,5,1),(115,'TOF-S-A-45',115,12,2),(116,'TOF-S-A-46',116,12,3),(117,'TOF-S-A-23',117,5,2),(118,'TOF-S-A-24',118,5,3),(119,'TOF-S-A-25',119,5,4),(120,'TOF-S-A-26',120,5,5),(121,'TOF-S-A-27',121,5,6),(122,'TOF-S-A-28',122,5,7),(123,'TOF-S-A-29',123,5,8),(124,'TOF-S-A-30',124,5,9),(125,'TOF-S-A-31',125,5,10),(126,'TOF-S-A-32',126,5,11),(127,'TOF-S-A-33',127,5,12),(128,'TOF-S-A-34',128,5,13),(129,'TOF-S-A-35',129,5,14),(130,'TOF-S-A-36',130,5,15),(131,'TOF-S-A-37',131,6,0),(132,'TOF-S-A-38',132,6,1),(133,'TOF-S-A-39',133,6,2),(134,'TOF-S-A-40',134,6,3),(135,'TOF-S-A-41',135,6,4),(136,'TOF-S-A-42',136,6,5),(137,'TOF-S-A-43',137,6,6),(138,'TOF-S-A-44',138,6,7),(139,'TOF-N-A-44',139,3,11),(140,'TOF-N-A-43',140,3,10),(141,'TOF-N-A-42',141,3,9),(142,'TOF-N-A-41',142,3,8),(143,'TOF-N-A-40',143,3,7),(144,'TOF-N-A-39',144,3,6),(145,'TOF-N-A-38',145,3,5),(146,'TOF-N-A-37',146,3,4),(147,'TOF-N-A-36',147,3,3),(148,'TOF-N-A-35',148,3,2),(149,'TOF-N-A-34',149,3,1),(150,'TOF-N-A-33',150,3,0),(151,'TOF-N-A-32',151,2,15),(152,'TOF-N-A-31',152,2,14),(153,'TOF-N-A-30',153,2,13),(154,'TOF-N-A-29',154,2,12),(155,'TOF-N-A-28',155,2,11),(156,'TOF-N-A-27',156,2,10),(157,'TOF-N-A-26',157,2,9),(158,'TOF-N-A-25',158,2,8),(159,'TOF-N-A-24',159,2,7),(160,'TOF-N-A-23',160,2,6),(161,'TOF-N-A-46',161,12,1),(162,'TOF-N-A-45',162,12,0),(163,'TOF-N-A-22',163,2,5),(164,'TOF-N-A-21',164,2,4),(165,'TOF-N-A-20',165,2,3),(166,'TOF-N-A-19',166,2,2),(167,'TOF-N-A-18',167,2,1),(168,'TOF-N-A-17',168,2,0),(169,'TOF-N-A-16',169,1,15),(170,'TOF-N-A-15',170,1,14),(171,'TOF-N-A-14',171,1,13),(172,'TOF-N-A-13',172,1,12),(173,'TOF-N-A-12',173,1,11),(174,'TOF-N-A-11',174,1,10),(175,'TOF-N-A-10',175,1,9),(176,'TOF-N-A-9',176,1,8),(177,'TOF-N-A-8',177,1,7),(178,'TOF-N-A-7',178,1,6),(179,'TOF-N-A-6',179,1,5),(180,'TOF-N-A-5',180,1,4),(181,'TOF-N-A-4',181,1,3),(182,'TOF-N-A-3',182,1,2),(183,'TOF-N-A-2',183,1,1),(184,'TOF-N-A-1',184,1,0); /*!40000 ALTER TABLE `adcCable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `adcLocation` -- DROP TABLE IF EXISTS `adcLocation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `adcLocation` ( `id` smallint(6) NOT NULL, `crateLocationId` smallint(6) NOT NULL, `slot` smallint(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `adcLocation` -- LOCK TABLES `adcLocation` WRITE; /*!40000 ALTER TABLE `adcLocation` DISABLE KEYS */; INSERT INTO `adcLocation` VALUES (1,1,3),(2,1,4),(3,1,5),(4,1,6),(5,1,7),(6,1,8),(7,1,9),(8,1,10),(9,1,13),(10,1,14),(11,1,15),(12,1,16); /*!40000 ALTER TABLE `adcLocation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `crate` -- DROP TABLE IF EXISTS `crate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `crate` ( `serialNo` varchar(32) NOT NULL, `type` varchar(32) DEFAULT NULL, `crateLocationId` smallint(6) DEFAULT NULL, PRIMARY KEY (`serialNo`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `crate` -- LOCK TABLES `crate` WRITE; /*!40000 ALTER TABLE `crate` DISABLE KEYS */; INSERT INTO `crate` VALUES ('1188025','VXS',1),('1688033','VXS',4),('500','CAENHV',2),('788005','VME',3); /*!40000 ALTER TABLE `crate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `crateLocation` -- DROP TABLE IF EXISTS `crateLocation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `crateLocation` ( `id` smallint(6) NOT NULL, `cratePositionLabel` varchar(32) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `crateLocation` -- LOCK TABLES `crateLocation` WRITE; /*!40000 ALTER TABLE `crateLocation` DISABLE KEYS */; INSERT INTO `crateLocation` VALUES (1,'D2-1-TOP'),(2,'D2-8-TOP'),(3,'D2-1-BOT'),(4,'D2-1-MID'); /*!40000 ALTER TABLE `crateLocation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `disc` -- DROP TABLE IF EXISTS `disc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `disc` ( `serialNo` varchar(32) NOT NULL, `discLocationId` smallint(6) NOT NULL, PRIMARY KEY (`serialNo`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `disc` -- LOCK TABLES `disc` WRITE; /*!40000 ALTER TABLE `disc` DISABLE KEYS */; INSERT INTO `disc` VALUES ('ACDI-012',10),('ACDI-015',8),('ACDI-016',1),('ACDI-017',5),('ACDI-028',9),('ACDI-042',3),('ACDI-068',2),('ACDI-071',12),('ACDI-083',11),('ACDI-092',4),('TRIS-27',6),('TRIS-28',7); /*!40000 ALTER TABLE `disc` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discCable` -- DROP TABLE IF EXISTS `discCable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discCable` ( `id` smallint(6) NOT NULL, `label` varchar(128) NOT NULL, `splitterLocationId` smallint(6) DEFAULT NULL, `discLocationId` smallint(6) DEFAULT NULL, `channel` smallint(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discCable` -- LOCK TABLES `discCable` WRITE; /*!40000 ALTER TABLE `discCable` DISABLE KEYS */; INSERT INTO `discCable` VALUES (1,'TOF-N-T-1',184,1,1),(2,'TOF-N-T-17',168,2,1),(3,'TOF-N-T-33',150,3,1),(4,'TOF-S-T-5',97,4,1),(5,'TOF-S-T-21',113,5,1),(6,'TOF-S-T-37',131,6,1),(7,'TOF-UP-T-9',9,7,1),(8,'TOF-UP-T-25',27,8,1),(9,'TOF-UP-T-41',43,9,1),(10,'TOF-DW-T-13',80,10,1),(11,'TOF-DW-T-29',62,11,1),(12,'TOF-N-T-45',162,12,1),(13,'TOF-N-T-2',183,1,2),(14,'TOF-N-T-18',167,2,2),(15,'TOF-N-T-34',149,3,2),(16,'TOF-S-T-6',98,4,2),(17,'TOF-S-T-22',114,5,2),(18,'TOF-S-T-38',132,6,2),(19,'TOF-UP-T-10',10,7,2),(20,'TOF-UP-T-26',28,8,2),(21,'TOF-UP-T-42',44,9,2),(22,'TOF-DW-T-14',79,10,2),(23,'TOF-DW-T-30',61,11,2),(24,'TOF-N-T-46',161,12,2),(25,'TOF-N-T-3',182,1,3),(26,'TOF-N-T-19',166,2,3),(27,'TOF-N-T-35',148,3,3),(28,'TOF-S-T-7',99,4,3),(29,'TOF-S-T-23',117,5,3),(30,'TOF-S-T-39',133,6,3),(31,'TOF-UP-T-11',11,7,3),(32,'TOF-UP-T-27',29,8,3),(33,'TOF-UP-T-43',45,9,3),(34,'TOF-DW-T-15',78,10,3),(35,'TOF-DW-T-31',60,11,3),(36,'TOF-S-T-45',115,12,3),(37,'TOF-N-T-4',181,1,4),(38,'TOF-N-T-20',165,2,4),(39,'TOF-N-T-36',147,3,4),(40,'TOF-S-T-8',100,4,4),(41,'TOF-S-T-24',118,5,4),(42,'TOF-S-T-40',134,6,4),(43,'TOF-UP-T-12',12,7,4),(44,'TOF-UP-T-28',30,8,4),(45,'TOF-UP-T-44',46,9,4),(46,'TOF-DW-T-16',77,10,4),(47,'TOF-DW-T-32',59,11,4),(48,'TOF-S-T-46',116,12,4),(49,'TOF-N-T-5',180,1,5),(50,'TOF-N-T-21',164,2,5),(51,'TOF-N-T-37',146,3,5),(52,'TOF-S-T-9',101,4,5),(53,'TOF-S-T-25',119,5,5),(54,'TOF-S-T-41',135,6,5),(55,'TOF-UP-T-13',13,7,5),(56,'TOF-UP-T-29',31,8,5),(57,'TOF-DW-T-1',92,9,5),(58,'TOF-DW-T-17',76,10,5),(59,'TOF-DW-T-33',58,11,5),(60,'TOF-UP-T-45',23,12,5),(61,'TOF-N-T-6',179,1,6),(62,'TOF-N-T-22',163,2,6),(63,'TOF-N-T-38',145,3,6),(64,'TOF-S-T-10',102,4,6),(65,'TOF-S-T-26',120,5,6),(66,'TOF-S-T-42',136,6,6),(67,'TOF-UP-T-14',14,7,6),(68,'TOF-UP-T-30',32,8,6),(69,'TOF-DW-T-2',91,9,6),(70,'TOF-DW-T-18',75,10,6),(71,'TOF-DW-T-34',57,11,6),(72,'TOF-UP-T-46',24,12,6),(73,'TOF-N-T-7',178,1,7),(74,'TOF-N-T-23',160,2,7),(75,'TOF-N-T-39',144,3,7),(76,'TOF-S-T-11',103,4,7),(77,'TOF-S-T-27',121,5,7),(78,'TOF-S-T-43',137,6,7),(79,'TOF-UP-T-15',15,7,7),(80,'TOF-UP-T-31',33,8,7),(81,'TOF-DW-T-3',90,9,7),(82,'TOF-DW-T-19',74,10,7),(83,'TOF-DW-T-35',56,11,7),(84,'TOF-DW-T-45',70,12,7),(85,'TOF-N-T-8',177,1,8),(86,'TOF-N-T-24',159,2,8),(87,'TOF-N-T-40',143,3,8),(88,'TOF-S-T-12',104,4,8),(89,'TOF-S-T-28',122,5,8),(90,'TOF-S-T-44',138,6,8),(91,'TOF-UP-T-16',16,7,8),(92,'TOF-UP-T-32',34,8,8),(93,'TOF-DW-T-4',89,9,8),(94,'TOF-DW-T-20',73,10,8),(95,'TOF-DW-T-36',55,11,8),(96,'TOF-DW-T-46',69,12,8),(97,'TOF-N-T-9',176,1,9),(98,'TOF-N-T-25',158,2,9),(99,'TOF-N-T-41',142,3,9),(100,'TOF-S-T-13',105,4,9),(101,'TOF-S-T-29',123,5,9),(102,'TOF-UP-T-1',1,6,9),(103,'TOF-UP-T-17',17,7,9),(104,'TOF-UP-T-33',35,8,9),(105,'TOF-DW-T-5',88,9,9),(106,'TOF-DW-T-21',72,10,9),(107,'TOF-DW-T-37',54,11,9),(108,'TOF-N-T-10',175,1,10),(109,'TOF-N-T-26',157,2,10),(110,'TOF-N-T-42',141,3,10),(111,'TOF-S-T-14',106,4,10),(112,'TOF-S-T-30',124,5,10),(113,'TOF-UP-T-2',2,6,10),(114,'TOF-UP-T-18',18,7,10),(115,'TOF-UP-T-34',36,8,10),(116,'TOF-DW-T-6',87,9,10),(117,'TOF-DW-T-22',71,10,10),(118,'TOF-DW-T-38',53,11,10),(119,'TOF-N-T-11',174,1,11),(120,'TOF-N-T-27',156,2,11),(121,'TOF-N-T-43',140,3,11),(122,'TOF-S-T-15',107,4,11),(123,'TOF-S-T-31',125,5,11),(124,'TOF-UP-T-3',3,6,11),(125,'TOF-UP-T-19',19,7,11),(126,'TOF-UP-T-35',37,8,11),(127,'TOF-DW-T-7',86,9,11),(128,'TOF-DW-T-23',68,10,11),(129,'TOF-DW-T-39',52,11,11),(130,'TOF-N-T-12',173,1,12),(131,'TOF-N-T-28',155,2,12),(132,'TOF-N-T-44',139,3,12),(133,'TOF-S-T-16',108,4,12),(134,'TOF-S-T-32',126,5,12),(135,'TOF-UP-T-4',4,6,12),(136,'TOF-UP-T-20',20,7,12),(137,'TOF-UP-T-36',38,8,12),(138,'TOF-DW-T-8',85,9,12),(139,'TOF-DW-T-24',67,10,12),(140,'TOF-DW-T-40',51,11,12),(141,'TOF-N-T-13',172,1,13),(142,'TOF-N-T-29',154,2,13),(143,'TOF-S-T-1',93,3,13),(144,'TOF-S-T-17',109,4,13),(145,'TOF-S-T-33',127,5,13),(146,'TOF-UP-T-5',5,6,13),(147,'TOF-UP-T-21',21,7,13),(148,'TOF-UP-T-37',39,8,13),(149,'TOF-DW-T-9',84,9,13),(150,'TOF-DW-T-25',66,10,13),(151,'TOF-DW-T-41',50,11,13),(152,'TOF-N-T-14',171,1,14),(153,'TOF-N-T-30',153,2,14),(154,'TOF-S-T-2',94,3,14),(155,'TOF-S-T-18',110,4,14),(156,'TOF-S-T-34',128,5,14),(157,'TOF-UP-T-6',6,6,14),(158,'TOF-UP-T-22',22,7,14),(159,'TOF-UP-T-38',40,8,14),(160,'TOF-DW-T-10',83,9,14),(161,'TOF-DW-T-26',65,10,14),(162,'TOF-DW-T-42',49,11,14),(163,'TOF-N-T-15',170,1,15),(164,'TOF-N-T-31',152,2,15),(165,'TOF-S-T-3',95,3,15),(166,'TOF-S-T-19',111,4,15),(167,'TOF-S-T-35',129,5,15),(168,'TOF-UP-T-7',7,6,15),(169,'TOF-UP-T-23',25,7,15),(170,'TOF-UP-T-39',41,8,15),(171,'TOF-DW-T-11',82,9,15),(172,'TOF-DW-T-27',64,10,15),(173,'TOF-DW-T-43',48,11,15),(174,'TOF-N-T-16',169,1,16),(175,'TOF-N-T-32',151,2,16),(176,'TOF-S-T-4',96,3,16),(177,'TOF-S-T-20',112,4,16),(178,'TOF-S-T-36',130,5,16),(179,'TOF-UP-T-8',8,6,16),(180,'TOF-UP-T-24',26,7,16),(181,'TOF-UP-T-40',42,8,16),(182,'TOF-DW-T-12',81,9,16),(183,'TOF-DW-T-28',63,10,16),(184,'TOF-DW-T-44',47,11,16); /*!40000 ALTER TABLE `discCable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discLocation` -- DROP TABLE IF EXISTS `discLocation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discLocation` ( `id` smallint(6) NOT NULL, `crateLocationId` smallint(6) NOT NULL, `slot` smallint(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discLocation` -- LOCK TABLES `discLocation` WRITE; /*!40000 ALTER TABLE `discLocation` DISABLE KEYS */; INSERT INTO `discLocation` VALUES (1,3,4),(2,3,5),(3,3,6),(4,3,7),(5,3,8),(6,3,9),(7,3,10),(8,3,11),(9,3,12),(10,3,13),(11,3,14),(12,3,15); /*!40000 ALTER TABLE `discLocation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `hvCable` -- DROP TABLE IF EXISTS `hvCable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hvCable` ( `id` smallint(6) NOT NULL, `label` varchar(128) DEFAULT NULL, `pmtLocationId` smallint(6) DEFAULT NULL, `hvCardLocationId` smallint(6) DEFAULT NULL, `channel` smallint(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `hvCable` -- LOCK TABLES `hvCable` WRITE; /*!40000 ALTER TABLE `hvCable` DISABLE KEYS */; INSERT INTO `hvCable` VALUES (1,'TOF-N-1',184,1,0),(2,'TOF-N-25',158,2,0),(3,'TOF-S-5',97,3,0),(4,'TOF-S-29',123,4,0),(5,'TOF-UP-9',9,5,0),(6,'TOF-UP-33',35,6,0),(7,'TOF-DW-13',80,7,0),(8,'TOF-DW-37',54,8,0),(9,'TOF-N-2',183,1,1),(10,'TOF-N-26',157,2,1),(11,'TOF-S-6',98,3,1),(12,'TOF-S-30',124,4,1),(13,'TOF-UP-10',10,5,1),(14,'TOF-UP-34',36,6,1),(15,'TOF-DW-14',79,7,1),(16,'TOF-DW-38',53,8,1),(17,'TOF-N-3',182,1,2),(18,'TOF-N-27',156,2,2),(19,'TOF-S-7',99,3,2),(20,'TOF-S-31',125,4,2),(21,'TOF-UP-11',11,5,2),(22,'TOF-UP-35',37,6,2),(23,'TOF-DW-15',78,7,2),(24,'TOF-DW-39',52,8,2),(25,'TOF-N-4',181,1,3),(26,'TOF-N-28',155,2,3),(27,'TOF-S-8',100,3,3),(28,'TOF-S-32',126,4,3),(29,'TOF-UP-12',12,5,3),(30,'TOF-UP-36',38,6,3),(31,'TOF-DW-16',77,7,3),(32,'TOF-DW-40',51,8,3),(33,'TOF-N-5',180,1,4),(34,'TOF-N-29',154,2,4),(35,'TOF-S-9',101,3,4),(36,'TOF-S-33',127,4,4),(37,'TOF-UP-13',13,5,4),(38,'TOF-UP-37',39,6,4),(39,'TOF-DW-17',76,7,4),(40,'TOF-DW-41',50,8,4),(41,'TOF-N-6',179,1,5),(42,'TOF-N-30',153,2,5),(43,'TOF-S-10',102,3,5),(44,'TOF-S-34',128,4,5),(45,'TOF-UP-14',14,5,5),(46,'TOF-UP-38',40,6,5),(47,'TOF-DW-18',75,7,5),(48,'TOF-DW-42',49,8,5),(49,'TOF-N-7',178,1,6),(50,'TOF-N-31',152,2,6),(51,'TOF-S-11',103,3,6),(52,'TOF-S-35',129,4,6),(53,'TOF-UP-15',15,5,6),(54,'TOF-UP-39',41,6,6),(55,'TOF-DW-19',74,7,6),(56,'TOF-DW-43',48,8,6),(57,'TOF-N-8',177,1,7),(58,'TOF-N-32',151,2,7),(59,'TOF-S-12',104,3,7),(60,'TOF-S-36',130,4,7),(61,'TOF-UP-16',16,5,7),(62,'TOF-UP-40',42,6,7),(63,'TOF-DW-20',73,7,7),(64,'TOF-DW-44',47,8,7),(65,'TOF-N-9',176,1,8),(66,'TOF-N-33',150,2,8),(67,'TOF-S-13',105,3,8),(68,'TOF-S-37',131,4,8),(69,'TOF-UP-17',17,5,8),(70,'TOF-UP-41',43,6,8),(71,'TOF-DW-21',72,7,8),(72,'TOF-N-45',162,8,8),(73,'TOF-N-10',175,1,9),(74,'TOF-N-34',149,2,9),(75,'TOF-S-14',106,3,9),(76,'TOF-S-38',132,4,9),(77,'TOF-UP-18',18,5,9),(78,'TOF-UP-42',44,6,9),(79,'TOF-DW-22',71,7,9),(80,'TOF-N-46',161,8,9),(81,'TOF-N-11',174,1,10),(82,'TOF-N-35',148,2,10),(83,'TOF-S-15',107,3,10),(84,'TOF-S-39',133,4,10),(85,'TOF-UP-19',19,5,10),(86,'TOF-UP-43',45,6,10),(87,'TOF-DW-23',68,7,10),(88,'TOF-S-45',115,8,10),(89,'TOF-N-12',173,1,11),(90,'TOF-N-36',147,2,11),(91,'TOF-S-16',108,3,11),(92,'TOF-S-40',134,4,11),(93,'TOF-UP-20',20,5,11),(94,'TOF-UP-44',46,6,11),(95,'TOF-DW-24',67,7,11),(96,'TOF-S-46',116,8,11),(97,'TOF-N-13',172,1,12),(98,'TOF-N-37',146,2,12),(99,'TOF-S-17',109,3,12),(100,'TOF-S-41',135,4,12),(101,'TOF-UP-21',21,5,12),(102,'TOF-DW-1',92,6,12),(103,'TOF-DW-25',66,7,12),(104,'TOF-UP-45',23,8,12),(105,'TOF-N-14',171,1,13),(106,'TOF-N-38',145,2,13),(107,'TOF-S-18',110,3,13),(108,'TOF-S-42',136,4,13),(109,'TOF-UP-22',22,5,13),(110,'TOF-DW-2',91,6,13),(111,'TOF-DW-26',65,7,13),(112,'TOF-UP-46',24,8,13),(113,'TOF-N-15',170,1,14),(114,'TOF-N-39',144,2,14),(115,'TOF-S-19',111,3,14),(116,'TOF-S-43',137,4,14),(117,'TOF-UP-23',25,5,14),(118,'TOF-DW-3',90,6,14),(119,'TOF-DW-27',64,7,14),(120,'TOF-DW-45',70,8,14),(121,'TOF-N-16',169,1,15),(122,'TOF-N-40',143,2,15),(123,'TOF-S-20',112,3,15),(124,'TOF-S-44',138,4,15),(125,'TOF-UP-24',26,5,15),(126,'TOF-DW-4',89,6,15),(127,'TOF-DW-28',63,7,15),(128,'TOF-DW-46',69,8,15),(129,'TOF-N-17',168,1,16),(130,'TOF-N-41',142,2,16),(131,'TOF-S-21',113,3,16),(132,'TOF-UP-1',1,4,16),(133,'TOF-UP-25',27,5,16),(134,'TOF-DW-5',88,6,16),(135,'TOF-DW-29',62,7,16),(136,'TOF-N-18',167,1,17),(137,'TOF-N-42',141,2,17),(138,'TOF-S-22',114,3,17),(139,'TOF-UP-2',2,4,17),(140,'TOF-UP-26',28,5,17),(141,'TOF-DW-6',87,6,17),(142,'TOF-DW-30',61,7,17),(143,'TOF-N-19',166,1,18),(144,'TOF-N-43',140,2,18),(145,'TOF-S-23',117,3,18),(146,'TOF-UP-3',3,4,18),(147,'TOF-UP-27',29,5,18),(148,'TOF-DW-7',86,6,18),(149,'TOF-DW-31',60,7,18),(150,'TOF-N-20',165,1,19),(151,'TOF-N-44',139,2,19),(152,'TOF-S-24',118,3,19),(153,'TOF-UP-4',4,4,19),(154,'TOF-UP-28',30,5,19),(155,'TOF-DW-8',85,6,19),(156,'TOF-DW-32',59,7,19),(157,'TOF-N-21',164,1,20),(158,'TOF-S-1',93,2,20),(159,'TOF-S-25',119,3,20),(160,'TOF-UP-5',5,4,20),(161,'TOF-UP-29',31,5,20),(162,'TOF-DW-9',84,6,20),(163,'TOF-DW-33',58,7,20),(164,'TOF-N-22',163,1,21),(165,'TOF-S-2',94,2,21),(166,'TOF-S-26',120,3,21),(167,'TOF-UP-6',6,4,21),(168,'TOF-UP-30',32,5,21),(169,'TOF-DW-10',83,6,21),(170,'TOF-DW-34',57,7,21),(171,'TOF-N-23',160,1,22),(172,'TOF-S-3',95,2,22),(173,'TOF-S-27',121,3,22),(174,'TOF-UP-7',7,4,22),(175,'TOF-UP-31',33,5,22),(176,'TOF-DW-11',82,6,22),(177,'TOF-DW-35',56,7,22),(178,'TOF-N-24',159,1,23),(179,'TOF-S-4',96,2,23),(180,'TOF-S-28',122,3,23),(181,'TOF-UP-8',8,4,23),(182,'TOF-UP-32',34,5,23),(183,'TOF-DW-12',81,6,23),(184,'TOF-DW-36',55,7,23); /*!40000 ALTER TABLE `hvCable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `hvCard` -- DROP TABLE IF EXISTS `hvCard`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hvCard` ( `serialNo` varchar(32) NOT NULL, `hvCardLocationId` smallint(6) DEFAULT NULL, PRIMARY KEY (`serialNo`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `hvCard` -- LOCK TABLES `hvCard` WRITE; /*!40000 ALTER TABLE `hvCard` DISABLE KEYS */; INSERT INTO `hvCard` VALUES ('370',7),('377',8),('405',4),('420',6),('428',5),('458',1),('489',3),('493',2); /*!40000 ALTER TABLE `hvCard` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `hvCardLocation` -- DROP TABLE IF EXISTS `hvCardLocation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hvCardLocation` ( `id` smallint(6) NOT NULL, `crateLocationId` smallint(6) DEFAULT NULL, `slot` smallint(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `hvCardLocation` -- LOCK TABLES `hvCardLocation` WRITE; /*!40000 ALTER TABLE `hvCardLocation` DISABLE KEYS */; INSERT INTO `hvCardLocation` VALUES (1,2,0),(2,2,2),(3,2,4),(4,2,6),(5,2,8),(6,2,10),(7,2,12),(8,2,14); /*!40000 ALTER TABLE `hvCardLocation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `moduleLocation` -- DROP TABLE IF EXISTS `moduleLocation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `moduleLocation` ( `id` smallint(6) NOT NULL, `layer` smallint(6) DEFAULT NULL, `bar` smallint(6) DEFAULT NULL, `moduleType` enum('long_60','long_45_sym','long_45_asym','long_30','short_45_sym','short_45_left','short_45_right') NOT NULL, `end` smallint(6) DEFAULT NULL, `orientation` enum('up','down') DEFAULT NULL, `label` varchar(16) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `moduleLocation` -- LOCK TABLES `moduleLocation` WRITE; /*!40000 ALTER TABLE `moduleLocation` DISABLE KEYS */; INSERT INTO `moduleLocation` VALUES (1,1,1,'long_60',NULL,'down','X-01'),(2,1,2,'long_60',NULL,'up','X-02'),(3,1,3,'long_60',NULL,'down','X-03'),(4,1,4,'long_60',NULL,'up','X-04'),(5,1,5,'long_60',NULL,'down','X-05'),(6,1,6,'long_60',NULL,'up','X-06'),(7,1,7,'long_60',NULL,'down','X-07'),(8,1,8,'long_60',NULL,'up','X-08'),(9,1,9,'long_60',NULL,'down','X-09'),(10,1,10,'long_60',NULL,'up','X-10'),(11,1,11,'long_60',NULL,'down','X-11'),(12,1,12,'long_60',NULL,'up','X-12'),(13,1,13,'long_60',NULL,'down','X-13'),(14,1,14,'long_60',NULL,'up','X-14'),(15,1,15,'long_60',NULL,'down','X-15'),(16,1,16,'long_60',NULL,'up','X-16'),(17,1,17,'long_60',NULL,'down','X-17'),(18,1,18,'long_45_sym',NULL,'up','X-IN-1'),(19,1,19,'long_45_asym',NULL,'down','X-IN-2'),(20,1,20,'long_30',NULL,'up','X-IN-3'),(21,1,21,'long_30',NULL,'down','X-IN-4'),(22,1,22,'short_45_left',-1,'up','X-IN-5L'),(23,1,23,'short_45_sym',-1,'down','X-IN-6L'),(24,1,24,'short_45_sym',-1,'up','X-IN-7L'),(25,1,25,'short_45_left',-1,'down','X-IN-8L'),(26,1,22,'short_45_right',1,'up','X-IN-5R'),(27,1,23,'short_45_sym',1,'down','X-IN-6R'),(28,1,24,'short_45_sym',1,'up','X-IN-7R'),(29,1,25,'short_45_right',1,'down','X-IN-8R'),(30,1,26,'long_30',NULL,'up','X-IN-9'),(31,1,27,'long_30',NULL,'down','X-IN-10'),(32,1,28,'long_45_asym',NULL,'up','X-IN-11'),(33,1,29,'long_45_sym',NULL,'down','X-IN-12'),(34,1,30,'long_60',NULL,'up','X-28'),(35,1,31,'long_60',NULL,'down','X-29'),(36,1,32,'long_60',NULL,'up','X-30'),(37,1,33,'long_60',NULL,'down','X-31'),(38,1,34,'long_60',NULL,'up','X-32'),(39,1,35,'long_60',NULL,'down','X-33'),(40,1,36,'long_60',NULL,'up','X-34'),(41,1,37,'long_60',NULL,'down','X-35'),(42,1,38,'long_60',NULL,'up','X-36'),(43,1,39,'long_60',NULL,'down','X-37'),(44,1,40,'long_60',NULL,'up','X-38'),(45,1,41,'long_60',NULL,'down','X-39'),(46,1,42,'long_60',NULL,'up','X-40'),(47,1,43,'long_60',NULL,'down','X-41'),(48,1,44,'long_60',NULL,'up','X-42'),(49,1,45,'long_60',NULL,'down','X-43'),(50,1,46,'long_60',NULL,'up','X-44'),(51,-1,1,'long_60',NULL,'down','Y-01'),(52,-1,2,'long_60',NULL,'up','Y-02'),(53,-1,3,'long_60',NULL,'down','Y-03'),(54,-1,4,'long_60',NULL,'up','Y-04'),(55,-1,5,'long_60',NULL,'down','Y-05'),(56,-1,6,'long_60',NULL,'up','Y-06'),(57,-1,7,'long_60',NULL,'down','Y-07'),(58,-1,8,'long_60',NULL,'up','Y-08'),(59,-1,9,'long_60',NULL,'down','Y-09'),(60,-1,10,'long_60',NULL,'up','Y-10'),(61,-1,11,'long_60',NULL,'down','Y-11'),(62,-1,12,'long_60',NULL,'up','Y-12'),(63,-1,13,'long_60',NULL,'down','Y-13'),(64,-1,14,'long_60',NULL,'up','Y-14'),(65,-1,15,'long_60',NULL,'down','Y-15'),(66,-1,16,'long_60',NULL,'up','Y-16'),(67,-1,17,'long_60',NULL,'down','Y-17'),(68,-1,18,'long_45_sym',NULL,'up','Y-IN-1'),(69,-1,19,'long_45_asym',NULL,'down','Y-IN-2'),(70,-1,20,'long_30',NULL,'up','Y-IN-3'),(71,-1,21,'long_30',NULL,'down','Y-IN-4'),(72,-1,22,'short_45_left',-1,'up','Y-IN-5L'),(73,-1,23,'short_45_sym',-1,'down','Y-IN-6L'),(74,-1,24,'short_45_sym',-1,'up','Y-IN-7L'),(75,-1,25,'short_45_left',-1,'down','Y-IN-8L'),(76,-1,22,'short_45_right',1,'up','Y-IN-5R'),(77,-1,23,'short_45_sym',1,'down','Y-IN-6R'),(78,-1,24,'short_45_sym',1,'up','Y-IN-7R'),(79,-1,25,'short_45_right',1,'down','Y-IN-8R'),(80,-1,26,'long_30',NULL,'up','Y-IN-9'),(81,-1,27,'long_30',NULL,'down','Y-IN-10'),(82,-1,28,'long_45_asym',NULL,'up','Y-IN-11'),(83,-1,29,'long_45_sym',NULL,'down','Y-IN-12'),(84,-1,30,'long_60',NULL,'up','Y-28'),(85,-1,31,'long_60',NULL,'down','Y-29'),(86,-1,32,'long_60',NULL,'up','Y-30'),(87,-1,33,'long_60',NULL,'down','Y-31'),(88,-1,34,'long_60',NULL,'up','Y-32'),(89,-1,35,'long_60',NULL,'down','Y-33'),(90,-1,36,'long_60',NULL,'up','Y-34'),(91,-1,37,'long_60',NULL,'down','Y-35'),(92,-1,38,'long_60',NULL,'up','Y-36'),(93,-1,39,'long_60',NULL,'down','Y-37'),(94,-1,40,'long_60',NULL,'up','Y-38'),(95,-1,41,'long_60',NULL,'down','Y-39'),(96,-1,42,'long_60',NULL,'up','Y-40'),(97,-1,43,'long_60',NULL,'down','Y-41'),(98,-1,44,'long_60',NULL,'up','Y-42'),(99,-1,45,'long_60',NULL,'down','Y-43'),(100,-1,46,'long_60',NULL,'up','Y-44'); /*!40000 ALTER TABLE `moduleLocation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pmt` -- DROP TABLE IF EXISTS `pmt`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pmt` ( `serialNo` varchar(32) NOT NULL, `type` varchar(32) NOT NULL, `pmtLocationId` int(11) DEFAULT NULL, `comment` varchar(128) DEFAULT NULL, PRIMARY KEY (`serialNo`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pmt` -- LOCK TABLES `pmt` WRITE; /*!40000 ALTER TABLE `pmt` DISABLE KEYS */; INSERT INTO `pmt` VALUES ('WA0440','H13795MOD',165,NULL),('WA0442','H13795MOD',157,NULL),('WA0447','H13795MOD',161,NULL),('WA0454','H13795MOD',114,NULL),('WA0461','H13795MOD',163,NULL),('WA0462','H13795MOD',113,NULL),('WA0463','H13795MOD',112,NULL),('WA0467','H13795MOD',120,NULL),('WA0473','H13795MOD',164,NULL),('WA0478','H13795MOD',71,NULL),('WA0491','H13795MOD',25,NULL),('WA0506','H13795MOD',75,NULL),('WA0507','H13795MOD',160,NULL),('WA0521','H13795MOD',28,NULL),('WA0526','H13795MOD',162,NULL),('WA0527','H13795MOD',115,NULL),('ZQ2246','H10534MOD',127,NULL),('ZQ2248','H10534MOD',110,NULL),('ZQ2249','H10534MOD',96,NULL),('ZQ2250','H10534MOD',91,NULL),('ZQ2255','H10534MOD',119,NULL),('ZQ2257','H10534MOD',37,NULL),('ZQ2262','H10534MOD',183,NULL),('ZQ2263','H10534MOD',5,NULL),('ZQ2265','H10534MOD',141,NULL),('ZQ2269','H10534MOD',135,NULL),('ZQ2292','H10534MOD',45,NULL),('ZQ2295','H10534MOD',3,NULL),('ZQ2297','H10534MOD',182,NULL),('ZQ2300','H10534MOD',98,NULL),('ZQ2465','H10534MOD',63,NULL),('ZQ2475','H10534MOD',136,NULL),('ZQ2486','H10534MOD',2,NULL),('ZQ2489','H10534MOD',43,NULL),('ZQ2499','H10534MOD',1,NULL),('ZQ2500','H10534MOD',143,NULL),('ZQ2502','H10534MOD',42,NULL),('ZQ2503','H10534MOD',138,NULL),('ZQ2508','H10534MOD',144,NULL),('ZQ2510','H10534MOD',128,NULL),('ZQ2512','H10534MOD',172,NULL),('ZQ2513','H10534MOD',106,NULL),('ZQ2514','H10534MOD',147,NULL),('ZQ2520','H10534MOD',116,NULL),('ZQ2521','H10534MOD',36,NULL),('ZQ2522','H10534MOD',131,NULL),('ZQ2535','H10534MOD',54,NULL),('ZQ2536','H10534MOD',178,NULL),('ZQ2554','H10534MOD',89,NULL),('ZQ2563','H10534MOD',88,NULL),('ZQ2564','H10534MOD',142,NULL),('ZQ2568','H10534MOD',44,NULL),('ZQ2571','H10534MOD',38,NULL),('ZQ2573','H10534MOD',174,NULL),('ZQ2574','H10534MOD',92,NULL),('ZQ2575','H10534MOD',73,NULL),('ZQ2576','H10534MOD',146,NULL),('ZQ2577','H10534MOD',180,NULL),('ZQ2580','H10534MOD',83,NULL),('ZQ2581','H10534MOD',153,NULL),('ZQ2582','H10534MOD',125,NULL),('ZQ2589','H10534MOD',81,NULL),('ZQ2590','H10534MOD',93,NULL),('ZQ2593','H10534MOD',51,NULL),('ZQ2594','H10534MOD',99,NULL),('ZQ2595','H10534MOD',48,NULL),('ZQ2598','H10534MOD',129,NULL),('ZQ2600','H10534MOD',95,NULL),('ZQ2603','H10534MOD',67,NULL),('ZQ2604','H10534MOD',104,NULL),('ZQ2605','H10534MOD',17,NULL),('ZQ2607','H10534MOD',130,NULL),('ZQ2613','H10534MOD',133,NULL),('ZQ2614','H10534MOD',21,NULL),('ZQ2617','H10534MOD',151,NULL),('ZQ2618','H10534MOD',148,NULL),('ZQ2623','H10534MOD',150,NULL),('ZQ2626','H10534MOD',60,NULL),('ZQ2627','H10534MOD',14,NULL),('ZQ2630','H10534MOD',152,NULL),('ZQ2631','H10534MOD',154,NULL),('ZQ2633','H10534MOD',177,NULL),('ZQ2635','H10534MOD',26,NULL),('ZQ2637','H10534MOD',39,NULL),('ZQ2638','H10534MOD',35,NULL),('ZQ2640','H10534MOD',27,NULL),('ZQ2641','H10534MOD',79,NULL),('ZQ2645','H10534MOD',11,NULL),('ZQ2646','H10534MOD',166,NULL),('ZQ2647','H10534MOD',76,NULL),('ZQ2648','H10534MOD',74,NULL),('ZQ2650','H10534MOD',124,NULL),('ZQ2651','H10534MOD',107,NULL),('ZQ2654','H10534MOD',30,NULL),('ZQ2655','H10534MOD',19,NULL),('ZQ2656','H10534MOD',78,NULL),('ZQ2658','H10534MOD',20,NULL),('ZQ2667','H10534MOD',169,NULL),('ZQ2672','H10534MOD',155,NULL),('ZQ2673','H10534MOD',101,NULL),('ZQ2675','H10534MOD',7,NULL),('ZQ2681','H10534MOD',59,NULL),('ZQ2682','H10534MOD',173,NULL),('ZQ2685','H10534MOD',102,NULL),('ZQ2686','H10534MOD',175,NULL),('ZQ2693','H10534MOD',85,NULL),('ZQ2694','H10534MOD',49,NULL),('ZQ2695','H10534MOD',149,NULL),('ZQ2696','H10534MOD',4,NULL),('ZQ2729','H10534MOD',100,NULL),('ZQ2732','H10534MOD',31,NULL),('ZQ2737','H10534MOD',108,NULL),('ZQ2740','H10534MOD',168,NULL),('ZQ2742','H10534MOD',122,NULL),('ZQ2743','H10534MOD',53,NULL),('ZQ2745','H10534MOD',40,NULL),('ZQ2749','H10534MOD',159,NULL),('ZQ2751','H10534MOD',118,NULL),('ZQ2752','H10534MOD',47,NULL),('ZQ2753','H10534MOD',97,NULL),('ZQ2754','H10534MOD',6,NULL),('ZQ2756','H10534MOD',90,NULL),('ZQ2757','H10534MOD',167,NULL),('ZQ2759','H10534MOD',15,NULL),('ZQ2760','H10534MOD',103,NULL),('ZQ2767','H10534MOD',33,NULL),('ZQ2769','H10534MOD',170,NULL),('ZQ2770','H10534MOD',12,NULL),('ZQ2772','H10534MOD',105,NULL),('ZQ2774','H10534MOD',126,NULL),('ZQ2781','H10534MOD',52,NULL),('ZQ2789','H10534MOD',9,NULL),('ZQ2790','H10534MOD',70,NULL),('ZQ2794','H10534MOD',34,NULL),('ZQ2795','H10534MOD',57,NULL),('ZQ2804','H10534MOD',134,NULL),('ZQ2805','H10534MOD',140,NULL),('ZQ2813','H10534MOD',55,NULL),('ZQ2814','H10534MOD',86,NULL),('ZQ2817','H10534MOD',61,NULL),('ZQ2819','H10534MOD',18,NULL),('ZQ2820','H10534MOD',8,NULL),('ZQ2821','H10534MOD',72,NULL),('ZQ2822','H10534MOD',41,NULL),('ZQ2825','H10534MOD',58,NULL),('ZQ2827','H10534MOD',176,NULL),('ZQ2828','H10534MOD',117,NULL),('ZQ2831','H10534MOD',46,NULL),('ZQ2832','H10534MOD',179,NULL),('ZQ2835','H10534MOD',184,NULL),('ZQ2836','H10534MOD',145,NULL),('ZQ2838','H10534MOD',181,NULL),('ZQ2839','H10534MOD',137,NULL),('ZQ2841','H10534MOD',10,NULL),('ZQ2842','H10534MOD',132,NULL),('ZQ2844','H10534MOD',50,NULL),('ZQ2846','H10534MOD',94,NULL),('ZQ2963','H10534MOD',29,NULL),('ZQ2972','H10534MOD',68,NULL),('ZQ2994','H10534MOD',64,NULL),('ZQ3003','H10534MOD',111,NULL),('ZQ3004','H10534MOD',171,NULL),('ZQ3008','H10534MOD',82,NULL),('ZQ3011','H10534MOD',13,NULL),('ZQ3012','H10534MOD',121,NULL),('ZQ3016','H10534MOD',62,NULL),('ZQ3017','H10534MOD',109,NULL),('ZQ3020','H10534MOD',32,NULL),('ZQ3021','H10534MOD',77,NULL),('ZQ3023','H10534MOD',80,NULL),('ZQ3028','H10534MOD',156,NULL),('ZQ3032','H10534MOD',84,NULL),('ZQ3034','H10534MOD',65,NULL),('ZQ3036','H10534MOD',16,NULL),('ZQ3038','H10534MOD',139,NULL),('ZQ3054','H10534MOD',22,NULL),('ZQ3069','H10534MOD',24,NULL),('ZQ3074','H10534MOD',123,NULL),('ZQ3077','H10534MOD',87,NULL),('ZQ3078','H10534MOD',158,NULL),('ZQ3079','H10534MOD',56,NULL),('ZQ3080','H10534MOD',66,NULL),('ZQ3118','H10534MOD',69,NULL),('ZQ3128','H10534MOD',23,NULL); /*!40000 ALTER TABLE `pmt` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pmtLocation` -- DROP TABLE IF EXISTS `pmtLocation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pmtLocation` ( `id` smallint(6) NOT NULL, `moduleLocationId` smallint(6) DEFAULT NULL, `end` smallint(6) DEFAULT NULL, `label` varchar(128) DEFAULT NULL, `labelPhysics` char(4) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pmtLocation` -- LOCK TABLES `pmtLocation` WRITE; /*!40000 ALTER TABLE `pmtLocation` DISABLE KEYS */; INSERT INTO `pmtLocation` VALUES (1,1,1,'TOF-UP-1','V01+'),(2,2,1,'TOF-UP-2','V02+'),(3,3,1,'TOF-UP-3','V03+'),(4,4,1,'TOF-UP-4','V04+'),(5,5,1,'TOF-UP-5','V05+'),(6,6,1,'TOF-UP-6','V06+'),(7,7,1,'TOF-UP-7','V07+'),(8,8,1,'TOF-UP-8','V08+'),(9,9,1,'TOF-UP-9','V09+'),(10,10,1,'TOF-UP-10','V10+'),(11,11,1,'TOF-UP-11','V11+'),(12,12,1,'TOF-UP-12','V12+'),(13,13,1,'TOF-UP-13','V13+'),(14,14,1,'TOF-UP-14','V14+'),(15,15,1,'TOF-UP-15','V15+'),(16,16,1,'TOF-UP-16','V16+'),(17,17,1,'TOF-UP-17','V17+'),(18,18,1,'TOF-UP-18','V18+'),(19,19,1,'TOF-UP-19','V19+'),(20,20,1,'TOF-UP-20','V20+'),(21,21,1,'TOF-UP-21','V21+'),(22,26,1,'TOF-UP-22','V22+'),(23,27,1,'TOF-UP-45','V23+'),(24,28,1,'TOF-UP-46','V24+'),(25,29,1,'TOF-UP-23','V25+'),(26,30,1,'TOF-UP-24','V26+'),(27,31,1,'TOF-UP-25','V27+'),(28,32,1,'TOF-UP-26','V28+'),(29,33,1,'TOF-UP-27','V29+'),(30,34,1,'TOF-UP-28','V30+'),(31,35,1,'TOF-UP-29','V31+'),(32,36,1,'TOF-UP-30','V32+'),(33,37,1,'TOF-UP-31','V33+'),(34,38,1,'TOF-UP-32','V34+'),(35,39,1,'TOF-UP-33','V35+'),(36,40,1,'TOF-UP-34','V36+'),(37,41,1,'TOF-UP-35','V37+'),(38,42,1,'TOF-UP-36','V38+'),(39,43,1,'TOF-UP-37','V39+'),(40,44,1,'TOF-UP-38','V40+'),(41,45,1,'TOF-UP-39','V41+'),(42,46,1,'TOF-UP-40','V42+'),(43,47,1,'TOF-UP-41','V43+'),(44,48,1,'TOF-UP-42','V44+'),(45,49,1,'TOF-UP-43','V45+'),(46,50,1,'TOF-UP-44','V46+'),(47,50,-1,'TOF-DW-44','V46-'),(48,49,-1,'TOF-DW-43','V45-'),(49,48,-1,'TOF-DW-42','V44-'),(50,47,-1,'TOF-DW-41','V43-'),(51,46,-1,'TOF-DW-40','V42-'),(52,45,-1,'TOF-DW-39','V41-'),(53,44,-1,'TOF-DW-38','V40-'),(54,43,-1,'TOF-DW-37','V39-'),(55,42,-1,'TOF-DW-36','V38-'),(56,41,-1,'TOF-DW-35','V37-'),(57,40,-1,'TOF-DW-34','V36-'),(58,39,-1,'TOF-DW-33','V35-'),(59,38,-1,'TOF-DW-32','V34-'),(60,37,-1,'TOF-DW-31','V33-'),(61,36,-1,'TOF-DW-30','V32-'),(62,35,-1,'TOF-DW-29','V31-'),(63,34,-1,'TOF-DW-28','V30-'),(64,33,-1,'TOF-DW-27','V29-'),(65,32,-1,'TOF-DW-26','V28-'),(66,31,-1,'TOF-DW-25','V27-'),(67,30,-1,'TOF-DW-24','V26-'),(68,25,-1,'TOF-DW-23','V25-'),(69,24,-1,'TOF-DW-46','V24-'),(70,23,-1,'TOF-DW-45','V23-'),(71,22,-1,'TOF-DW-22','V22-'),(72,21,-1,'TOF-DW-21','V21-'),(73,20,-1,'TOF-DW-20','V20-'),(74,19,-1,'TOF-DW-19','V19-'),(75,18,-1,'TOF-DW-18','V18-'),(76,17,-1,'TOF-DW-17','V17-'),(77,16,-1,'TOF-DW-16','V16-'),(78,15,-1,'TOF-DW-15','V15-'),(79,14,-1,'TOF-DW-14','V14-'),(80,13,-1,'TOF-DW-13','V13-'),(81,12,-1,'TOF-DW-12','V12-'),(82,11,-1,'TOF-DW-11','V11-'),(83,10,-1,'TOF-DW-10','V10-'),(84,9,-1,'TOF-DW-9','V09-'),(85,8,-1,'TOF-DW-8','V08-'),(86,7,-1,'TOF-DW-7','V07-'),(87,6,-1,'TOF-DW-6','V06-'),(88,5,-1,'TOF-DW-5','V05-'),(89,4,-1,'TOF-DW-4','V04-'),(90,3,-1,'TOF-DW-3','V03-'),(91,2,-1,'TOF-DW-2','V02-'),(92,1,-1,'TOF-DW-1','V01-'),(93,51,-1,'TOF-S-1','H01-'),(94,52,-1,'TOF-S-2','H02-'),(95,53,-1,'TOF-S-3','H03-'),(96,54,-1,'TOF-S-4','H04-'),(97,55,-1,'TOF-S-5','H05-'),(98,56,-1,'TOF-S-6','H06-'),(99,57,-1,'TOF-S-7','H07-'),(100,58,-1,'TOF-S-8','H08-'),(101,59,-1,'TOF-S-9','H09-'),(102,60,-1,'TOF-S-10','H10-'),(103,61,-1,'TOF-S-11','H11-'),(104,62,-1,'TOF-S-12','H12-'),(105,63,-1,'TOF-S-13','H13-'),(106,64,-1,'TOF-S-14','H14-'),(107,65,-1,'TOF-S-15','H15-'),(108,66,-1,'TOF-S-16','H16-'),(109,67,-1,'TOF-S-17','H17-'),(110,68,-1,'TOF-S-18','H18-'),(111,69,-1,'TOF-S-19','H19-'),(112,70,-1,'TOF-S-20','H20-'),(113,71,-1,'TOF-S-21','H21-'),(114,76,-1,'TOF-S-22','H22-'),(115,77,-1,'TOF-S-45','H23-'),(116,78,-1,'TOF-S-46','H24-'),(117,79,-1,'TOF-S-23','H25-'),(118,80,-1,'TOF-S-24','H26-'),(119,81,-1,'TOF-S-25','H27-'),(120,82,-1,'TOF-S-26','H28-'),(121,83,-1,'TOF-S-27','H29-'),(122,84,-1,'TOF-S-28','H30-'),(123,85,-1,'TOF-S-29','H31-'),(124,86,-1,'TOF-S-30','H32-'),(125,87,-1,'TOF-S-31','H33-'),(126,88,-1,'TOF-S-32','H34-'),(127,89,-1,'TOF-S-33','H35-'),(128,90,-1,'TOF-S-34','H36-'),(129,91,-1,'TOF-S-35','H37-'),(130,92,-1,'TOF-S-36','H38-'),(131,93,-1,'TOF-S-37','H39-'),(132,94,-1,'TOF-S-38','H40-'),(133,95,-1,'TOF-S-39','H41-'),(134,96,-1,'TOF-S-40','H42-'),(135,97,-1,'TOF-S-41','H43-'),(136,98,-1,'TOF-S-42','H44-'),(137,99,-1,'TOF-S-43','H45-'),(138,100,-1,'TOF-S-44','H46-'),(139,100,1,'TOF-N-44','H46+'),(140,99,1,'TOF-N-43','H45+'),(141,98,1,'TOF-N-42','H44+'),(142,97,1,'TOF-N-41','H43+'),(143,96,1,'TOF-N-40','H42+'),(144,95,1,'TOF-N-39','H41+'),(145,94,1,'TOF-N-38','H40+'),(146,93,1,'TOF-N-37','H39+'),(147,92,1,'TOF-N-36','H38+'),(148,91,1,'TOF-N-35','H37+'),(149,90,1,'TOF-N-34','H36+'),(150,89,1,'TOF-N-33','H35+'),(151,88,1,'TOF-N-32','H34+'),(152,87,1,'TOF-N-31','H33+'),(153,86,1,'TOF-N-30','H32+'),(154,85,1,'TOF-N-29','H31+'),(155,84,1,'TOF-N-28','H30+'),(156,83,1,'TOF-N-27','H29+'),(157,82,1,'TOF-N-26','H28+'),(158,81,1,'TOF-N-25','H27+'),(159,80,1,'TOF-N-24','H26+'),(160,75,1,'TOF-N-23','H25+'),(161,74,1,'TOF-N-46','H24+'),(162,73,1,'TOF-N-45','H23+'),(163,72,1,'TOF-N-22','H22+'),(164,71,1,'TOF-N-21','H21+'),(165,70,1,'TOF-N-20','H20+'),(166,69,1,'TOF-N-19','H19+'),(167,68,1,'TOF-N-18','H18+'),(168,67,1,'TOF-N-17','H17+'),(169,66,1,'TOF-N-16','H16+'),(170,65,1,'TOF-N-15','H15+'),(171,64,1,'TOF-N-14','H14+'),(172,63,1,'TOF-N-13','H13+'),(173,62,1,'TOF-N-12','H12+'),(174,61,1,'TOF-N-11','H11+'),(175,60,1,'TOF-N-10','H10+'),(176,59,1,'TOF-N-9','H09+'),(177,58,1,'TOF-N-8','H08+'),(178,57,1,'TOF-N-7','H07+'),(179,56,1,'TOF-N-6','H06+'),(180,55,1,'TOF-N-5','H05+'),(181,54,1,'TOF-N-4','H04+'),(182,53,1,'TOF-N-3','H03+'),(183,52,1,'TOF-N-2','H02+'),(184,51,1,'TOF-N-1','H01+'); /*!40000 ALTER TABLE `pmtLocation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `signalCable` -- DROP TABLE IF EXISTS `signalCable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `signalCable` ( `id` smallint(6) NOT NULL, `label` varchar(128) DEFAULT NULL, `pmtLocationId` smallint(6) DEFAULT NULL, `splitterLocationId` smallint(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `signalCable` -- LOCK TABLES `signalCable` WRITE; /*!40000 ALTER TABLE `signalCable` DISABLE KEYS */; INSERT INTO `signalCable` VALUES (1,'TOF-UP-1',1,1),(2,'TOF-UP-2',2,2),(3,'TOF-UP-3',3,3),(4,'TOF-UP-4',4,4),(5,'TOF-UP-5',5,5),(6,'TOF-UP-6',6,6),(7,'TOF-UP-7',7,7),(8,'TOF-UP-8',8,8),(9,'TOF-UP-9',9,9),(10,'TOF-UP-10',10,10),(11,'TOF-UP-11',11,11),(12,'TOF-UP-12',12,12),(13,'TOF-UP-13',13,13),(14,'TOF-UP-14',14,14),(15,'TOF-UP-15',15,15),(16,'TOF-UP-16',16,16),(17,'TOF-UP-17',17,17),(18,'TOF-UP-18',18,18),(19,'TOF-UP-19',19,19),(20,'TOF-UP-20',20,20),(21,'TOF-UP-21',21,21),(22,'TOF-UP-22',22,22),(23,'TOF-UP-45',23,23),(24,'TOF-UP-46',24,24),(25,'TOF-UP-23',25,25),(26,'TOF-UP-24',26,26),(27,'TOF-UP-25',27,27),(28,'TOF-UP-26',28,28),(29,'TOF-UP-27',29,29),(30,'TOF-UP-28',30,30),(31,'TOF-UP-29',31,31),(32,'TOF-UP-30',32,32),(33,'TOF-UP-31',33,33),(34,'TOF-UP-32',34,34),(35,'TOF-UP-33',35,35),(36,'TOF-UP-34',36,36),(37,'TOF-UP-35',37,37),(38,'TOF-UP-36',38,38),(39,'TOF-UP-37',39,39),(40,'TOF-UP-38',40,40),(41,'TOF-UP-39',41,41),(42,'TOF-UP-40',42,42),(43,'TOF-UP-41',43,43),(44,'TOF-UP-42',44,44),(45,'TOF-UP-43',45,45),(46,'TOF-UP-44',46,46),(47,'TOF-DW-44',47,47),(48,'TOF-DW-43',48,48),(49,'TOF-DW-42',49,49),(50,'TOF-DW-41',50,50),(51,'TOF-DW-40',51,51),(52,'TOF-DW-39',52,52),(53,'TOF-DW-38',53,53),(54,'TOF-DW-37',54,54),(55,'TOF-DW-36',55,55),(56,'TOF-DW-35',56,56),(57,'TOF-DW-34',57,57),(58,'TOF-DW-33',58,58),(59,'TOF-DW-32',59,59),(60,'TOF-DW-31',60,60),(61,'TOF-DW-30',61,61),(62,'TOF-DW-29',62,62),(63,'TOF-DW-28',63,63),(64,'TOF-DW-27',64,64),(65,'TOF-DW-26',65,65),(66,'TOF-DW-25',66,66),(67,'TOF-DW-24',67,67),(68,'TOF-DW-23',68,68),(69,'TOF-DW-46',69,69),(70,'TOF-DW-45',70,70),(71,'TOF-DW-22',71,71),(72,'TOF-DW-21',72,72),(73,'TOF-DW-20',73,73),(74,'TOF-DW-19',74,74),(75,'TOF-DW-18',75,75),(76,'TOF-DW-17',76,76),(77,'TOF-DW-16',77,77),(78,'TOF-DW-15',78,78),(79,'TOF-DW-14',79,79),(80,'TOF-DW-13',80,80),(81,'TOF-DW-12',81,81),(82,'TOF-DW-11',82,82),(83,'TOF-DW-10',83,83),(84,'TOF-DW-9',84,84),(85,'TOF-DW-8',85,85),(86,'TOF-DW-7',86,86),(87,'TOF-DW-6',87,87),(88,'TOF-DW-5',88,88),(89,'TOF-DW-4',89,89),(90,'TOF-DW-3',90,90),(91,'TOF-DW-2',91,91),(92,'TOF-DW-1',92,92),(93,'TOF-S-1',93,93),(94,'TOF-S-2',94,94),(95,'TOF-S-3',95,95),(96,'TOF-S-4',96,96),(97,'TOF-S-5',97,97),(98,'TOF-S-6',98,98),(99,'TOF-S-7',99,99),(100,'TOF-S-8',100,100),(101,'TOF-S-9',101,101),(102,'TOF-S-10',102,102),(103,'TOF-S-11',103,103),(104,'TOF-S-12',104,104),(105,'TOF-S-13',105,105),(106,'TOF-S-14',106,106),(107,'TOF-S-15',107,107),(108,'TOF-S-16',108,108),(109,'TOF-S-17',109,109),(110,'TOF-S-18',110,110),(111,'TOF-S-19',111,111),(112,'TOF-S-20',112,112),(113,'TOF-S-21',113,113),(114,'TOF-S-22',114,114),(115,'TOF-S-45',115,115),(116,'TOF-S-46',116,116),(117,'TOF-S-23',117,117),(118,'TOF-S-24',118,118),(119,'TOF-S-25',119,119),(120,'TOF-S-26',120,120),(121,'TOF-S-27',121,121),(122,'TOF-S-28',122,122),(123,'TOF-S-29',123,123),(124,'TOF-S-30',124,124),(125,'TOF-S-31',125,125),(126,'TOF-S-32',126,126),(127,'TOF-S-33',127,127),(128,'TOF-S-34',128,128),(129,'TOF-S-35',129,129),(130,'TOF-S-36',130,130),(131,'TOF-S-37',131,131),(132,'TOF-S-38',132,132),(133,'TOF-S-39',133,133),(134,'TOF-S-40',134,134),(135,'TOF-S-41',135,135),(136,'TOF-S-42',136,136),(137,'TOF-S-43',137,137),(138,'TOF-S-44',138,138),(139,'TOF-N-44',139,139),(140,'TOF-N-43',140,140),(141,'TOF-N-42',141,141),(142,'TOF-N-41',142,142),(143,'TOF-N-40',143,143),(144,'TOF-N-39',144,144),(145,'TOF-N-38',145,145),(146,'TOF-N-37',146,146),(147,'TOF-N-36',147,147),(148,'TOF-N-35',148,148),(149,'TOF-N-34',149,149),(150,'TOF-N-33',150,150),(151,'TOF-N-32',151,151),(152,'TOF-N-31',152,152),(153,'TOF-N-30',153,153),(154,'TOF-N-29',154,154),(155,'TOF-N-28',155,155),(156,'TOF-N-27',156,156),(157,'TOF-N-26',157,157),(158,'TOF-N-25',158,158),(159,'TOF-N-24',159,159),(160,'TOF-N-23',160,160),(161,'TOF-N-46',161,161),(162,'TOF-N-45',162,162),(163,'TOF-N-22',163,163),(164,'TOF-N-21',164,164),(165,'TOF-N-20',165,165),(166,'TOF-N-19',166,166),(167,'TOF-N-18',167,167),(168,'TOF-N-17',168,168),(169,'TOF-N-16',169,169),(170,'TOF-N-15',170,170),(171,'TOF-N-14',171,171),(172,'TOF-N-13',172,172),(173,'TOF-N-12',173,173),(174,'TOF-N-11',174,174),(175,'TOF-N-10',175,175),(176,'TOF-N-9',176,176),(177,'TOF-N-8',177,177),(178,'TOF-N-7',178,178),(179,'TOF-N-6',179,179),(180,'TOF-N-5',180,180),(181,'TOF-N-4',181,181),(182,'TOF-N-3',182,182),(183,'TOF-N-2',183,183),(184,'TOF-N-1',184,184); /*!40000 ALTER TABLE `signalCable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `splitterLocation` -- DROP TABLE IF EXISTS `splitterLocation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `splitterLocation` ( `id` smallint(6) NOT NULL, `label` varchar(128) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `splitterLocation` -- LOCK TABLES `splitterLocation` WRITE; /*!40000 ALTER TABLE `splitterLocation` DISABLE KEYS */; INSERT INTO `splitterLocation` VALUES (1,'splitter_1'),(2,'splitter_2'),(3,'splitter_3'),(4,'splitter_4'),(5,'splitter_5'),(6,'splitter_6'),(7,'splitter_7'),(8,'splitter_8'),(9,'splitter_9'),(10,'splitter_10'),(11,'splitter_11'),(12,'splitter_12'),(13,'splitter_13'),(14,'splitter_14'),(15,'splitter_15'),(16,'splitter_16'),(17,'splitter_17'),(18,'splitter_18'),(19,'splitter_19'),(20,'splitter_20'),(21,'splitter_21'),(22,'splitter_22'),(23,'splitter_23'),(24,'splitter_24'),(25,'splitter_25'),(26,'splitter_26'),(27,'splitter_27'),(28,'splitter_28'),(29,'splitter_29'),(30,'splitter_30'),(31,'splitter_31'),(32,'splitter_32'),(33,'splitter_33'),(34,'splitter_34'),(35,'splitter_35'),(36,'splitter_36'),(37,'splitter_37'),(38,'splitter_38'),(39,'splitter_39'),(40,'splitter_40'),(41,'splitter_41'),(42,'splitter_42'),(43,'splitter_43'),(44,'splitter_44'),(45,'splitter_45'),(46,'splitter_46'),(47,'splitter_47'),(48,'splitter_48'),(49,'splitter_49'),(50,'splitter_50'),(51,'splitter_51'),(52,'splitter_52'),(53,'splitter_53'),(54,'splitter_54'),(55,'splitter_55'),(56,'splitter_56'),(57,'splitter_57'),(58,'splitter_58'),(59,'splitter_59'),(60,'splitter_60'),(61,'splitter_61'),(62,'splitter_62'),(63,'splitter_63'),(64,'splitter_64'),(65,'splitter_65'),(66,'splitter_66'),(67,'splitter_67'),(68,'splitter_68'),(69,'splitter_69'),(70,'splitter_70'),(71,'splitter_71'),(72,'splitter_72'),(73,'splitter_73'),(74,'splitter_74'),(75,'splitter_75'),(76,'splitter_76'),(77,'splitter_77'),(78,'splitter_78'),(79,'splitter_79'),(80,'splitter_80'),(81,'splitter_81'),(82,'splitter_82'),(83,'splitter_83'),(84,'splitter_84'),(85,'splitter_85'),(86,'splitter_86'),(87,'splitter_87'),(88,'splitter_88'),(89,'splitter_89'),(90,'splitter_90'),(91,'splitter_91'),(92,'splitter_92'),(93,'splitter_93'),(94,'splitter_94'),(95,'splitter_95'),(96,'splitter_96'),(97,'splitter_97'),(98,'splitter_98'),(99,'splitter_99'),(100,'splitter_100'),(101,'splitter_101'),(102,'splitter_102'),(103,'splitter_103'),(104,'splitter_104'),(105,'splitter_105'),(106,'splitter_106'),(107,'splitter_107'),(108,'splitter_108'),(109,'splitter_109'),(110,'splitter_110'),(111,'splitter_111'),(112,'splitter_112'),(113,'splitter_113'),(114,'splitter_114'),(115,'splitter_115'),(116,'splitter_116'),(117,'splitter_117'),(118,'splitter_118'),(119,'splitter_119'),(120,'splitter_120'),(121,'splitter_121'),(122,'splitter_122'),(123,'splitter_123'),(124,'splitter_124'),(125,'splitter_125'),(126,'splitter_126'),(127,'splitter_127'),(128,'splitter_128'),(129,'splitter_129'),(130,'splitter_130'),(131,'splitter_131'),(132,'splitter_132'),(133,'splitter_133'),(134,'splitter_134'),(135,'splitter_135'),(136,'splitter_136'),(137,'splitter_137'),(138,'splitter_138'),(139,'splitter_139'),(140,'splitter_140'),(141,'splitter_141'),(142,'splitter_142'),(143,'splitter_143'),(144,'splitter_144'),(145,'splitter_145'),(146,'splitter_146'),(147,'splitter_147'),(148,'splitter_148'),(149,'splitter_149'),(150,'splitter_150'),(151,'splitter_151'),(152,'splitter_152'),(153,'splitter_153'),(154,'splitter_154'),(155,'splitter_155'),(156,'splitter_156'),(157,'splitter_157'),(158,'splitter_158'),(159,'splitter_159'),(160,'splitter_160'),(161,'splitter_161'),(162,'splitter_162'),(163,'splitter_163'),(164,'splitter_164'),(165,'splitter_165'),(166,'splitter_166'),(167,'splitter_167'),(168,'splitter_168'),(169,'splitter_169'),(170,'splitter_170'),(171,'splitter_171'),(172,'splitter_172'),(173,'splitter_173'),(174,'splitter_174'),(175,'splitter_175'),(176,'splitter_176'),(177,'splitter_177'),(178,'splitter_178'),(179,'splitter_179'),(180,'splitter_180'),(181,'splitter_181'),(182,'splitter_182'),(183,'splitter_183'),(184,'splitter_184'); /*!40000 ALTER TABLE `splitterLocation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tdc` -- DROP TABLE IF EXISTS `tdc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tdc` ( `serialNo` varchar(32) NOT NULL, `tdcLocationId` smallint(6) NOT NULL, PRIMARY KEY (`serialNo`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tdc` -- LOCK TABLES `tdc` WRITE; /*!40000 ALTER TABLE `tdc` DISABLE KEYS */; INSERT INTO `tdc` VALUES ('0054',1),('0057',2),('0058',3),('0059',4),('0061',5),('0065',6); /*!40000 ALTER TABLE `tdc` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tdcCable` -- DROP TABLE IF EXISTS `tdcCable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tdcCable` ( `id` smallint(6) NOT NULL, `label` varchar(128) NOT NULL, `discLocationId` smallint(6) DEFAULT NULL, `discChannel` smallint(6) DEFAULT NULL, `tdcLocationId` smallint(6) DEFAULT NULL, `tdcHalf` enum('TOP','BOT') DEFAULT NULL, `tdcChannel` smallint(6) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tdcCable` -- LOCK TABLES `tdcCable` WRITE; /*!40000 ALTER TABLE `tdcCable` DISABLE KEYS */; INSERT INTO `tdcCable` VALUES (1,'TOF-N-T-17',2,1,1,'TOP',16),(2,'TOF-S-T-5',4,1,2,'TOP',16),(3,'TOF-S-T-37',6,1,3,'TOP',16),(4,'TOF-UP-T-25',8,1,4,'TOP',16),(5,'TOF-DW-T-13',10,1,5,'TOP',16),(6,'TOF-N-T-45',12,1,6,'TOP',16),(7,'TOF-N-T-18',2,2,1,'TOP',17),(8,'TOF-S-T-6',4,2,2,'TOP',17),(9,'TOF-S-T-38',6,2,3,'TOP',17),(10,'TOF-UP-T-26',8,2,4,'TOP',17),(11,'TOF-DW-T-14',10,2,5,'TOP',17),(12,'TOF-N-T-46',12,2,6,'TOP',17),(13,'TOF-N-T-19',2,3,1,'TOP',18),(14,'TOF-S-T-7',4,3,2,'TOP',18),(15,'TOF-S-T-39',6,3,3,'TOP',18),(16,'TOF-UP-T-27',8,3,4,'TOP',18),(17,'TOF-DW-T-15',10,3,5,'TOP',18),(18,'TOF-S-T-45',12,3,6,'TOP',18),(19,'TOF-N-T-20',2,4,1,'TOP',19),(20,'TOF-S-T-8',4,4,2,'TOP',19),(21,'TOF-S-T-40',6,4,3,'TOP',19),(22,'TOF-UP-T-28',8,4,4,'TOP',19),(23,'TOF-DW-T-16',10,4,5,'TOP',19),(24,'TOF-S-T-46',12,4,6,'TOP',19),(25,'TOF-N-T-21',2,5,1,'TOP',20),(26,'TOF-S-T-9',4,5,2,'TOP',20),(27,'TOF-S-T-41',6,5,3,'TOP',20),(28,'TOF-UP-T-29',8,5,4,'TOP',20),(29,'TOF-DW-T-17',10,5,5,'TOP',20),(30,'TOF-UP-T-45',12,5,6,'TOP',20),(31,'TOF-N-T-22',2,6,1,'TOP',21),(32,'TOF-S-T-10',4,6,2,'TOP',21),(33,'TOF-S-T-42',6,6,3,'TOP',21),(34,'TOF-UP-T-30',8,6,4,'TOP',21),(35,'TOF-DW-T-18',10,6,5,'TOP',21),(36,'TOF-UP-T-46',12,6,6,'TOP',21),(37,'TOF-N-T-23',2,7,1,'TOP',22),(38,'TOF-S-T-11',4,7,2,'TOP',22),(39,'TOF-S-T-43',6,7,3,'TOP',22),(40,'TOF-UP-T-31',8,7,4,'TOP',22),(41,'TOF-DW-T-19',10,7,5,'TOP',22),(42,'TOF-DW-T-45',12,7,6,'TOP',22),(43,'TOF-N-T-24',2,8,1,'TOP',23),(44,'TOF-S-T-12',4,8,2,'TOP',23),(45,'TOF-S-T-44',6,8,3,'TOP',23),(46,'TOF-UP-T-32',8,8,4,'TOP',23),(47,'TOF-DW-T-20',10,8,5,'TOP',23),(48,'TOF-DW-T-46',12,8,6,'TOP',23),(49,'TOF-N-T-25',2,9,1,'TOP',24),(50,'TOF-S-T-13',4,9,2,'TOP',24),(51,'TOF-UP-T-1',6,9,3,'TOP',24),(52,'TOF-UP-T-33',8,9,4,'TOP',24),(53,'TOF-DW-T-21',10,9,5,'TOP',24),(54,'TOF-N-T-26',2,10,1,'TOP',25),(55,'TOF-S-T-14',4,10,2,'TOP',25),(56,'TOF-UP-T-2',6,10,3,'TOP',25),(57,'TOF-UP-T-34',8,10,4,'TOP',25),(58,'TOF-DW-T-22',10,10,5,'TOP',25),(59,'TOF-N-T-27',2,11,1,'TOP',26),(60,'TOF-S-T-15',4,11,2,'TOP',26),(61,'TOF-UP-T-3',6,11,3,'TOP',26),(62,'TOF-UP-T-35',8,11,4,'TOP',26),(63,'TOF-DW-T-23',10,11,5,'TOP',26),(64,'TOF-N-T-28',2,12,1,'TOP',27),(65,'TOF-S-T-16',4,12,2,'TOP',27),(66,'TOF-UP-T-4',6,12,3,'TOP',27),(67,'TOF-UP-T-36',8,12,4,'TOP',27),(68,'TOF-DW-T-24',10,12,5,'TOP',27),(69,'TOF-N-T-29',2,13,1,'TOP',28),(70,'TOF-S-T-17',4,13,2,'TOP',28),(71,'TOF-UP-T-5',6,13,3,'TOP',28),(72,'TOF-UP-T-37',8,13,4,'TOP',28),(73,'TOF-DW-T-25',10,13,5,'TOP',28),(74,'TOF-N-T-30',2,14,1,'TOP',29),(75,'TOF-S-T-18',4,14,2,'TOP',29),(76,'TOF-UP-T-6',6,14,3,'TOP',29),(77,'TOF-UP-T-38',8,14,4,'TOP',29),(78,'TOF-DW-T-26',10,14,5,'TOP',29),(79,'TOF-N-T-31',2,15,1,'TOP',30),(80,'TOF-S-T-19',4,15,2,'TOP',30),(81,'TOF-UP-T-7',6,15,3,'TOP',30),(82,'TOF-UP-T-39',8,15,4,'TOP',30),(83,'TOF-DW-T-27',10,15,5,'TOP',30),(84,'TOF-N-T-32',2,16,1,'TOP',31),(85,'TOF-S-T-20',4,16,2,'TOP',31),(86,'TOF-UP-T-8',6,16,3,'TOP',31),(87,'TOF-UP-T-40',8,16,4,'TOP',31),(88,'TOF-DW-T-28',10,16,5,'TOP',31),(89,'TOF-N-T-1',1,1,1,'BOT',0),(90,'TOF-N-T-33',3,1,2,'BOT',0),(91,'TOF-S-T-21',5,1,3,'BOT',0),(92,'TOF-UP-T-9',7,1,4,'BOT',0),(93,'TOF-UP-T-41',9,1,5,'BOT',0),(94,'TOF-DW-T-29',11,1,6,'BOT',0),(95,'TOF-N-T-2',1,2,1,'BOT',1),(96,'TOF-N-T-34',3,2,2,'BOT',1),(97,'TOF-S-T-22',5,2,3,'BOT',1),(98,'TOF-UP-T-10',7,2,4,'BOT',1),(99,'TOF-UP-T-42',9,2,5,'BOT',1),(100,'TOF-DW-T-30',11,2,6,'BOT',1),(101,'TOF-N-T-3',1,3,1,'BOT',2),(102,'TOF-N-T-35',3,3,2,'BOT',2),(103,'TOF-S-T-23',5,3,3,'BOT',2),(104,'TOF-UP-T-11',7,3,4,'BOT',2),(105,'TOF-UP-T-43',9,3,5,'BOT',2),(106,'TOF-DW-T-31',11,3,6,'BOT',2),(107,'TOF-N-T-4',1,4,1,'BOT',3),(108,'TOF-N-T-36',3,4,2,'BOT',3),(109,'TOF-S-T-24',5,4,3,'BOT',3),(110,'TOF-UP-T-12',7,4,4,'BOT',3),(111,'TOF-UP-T-44',9,4,5,'BOT',3),(112,'TOF-DW-T-32',11,4,6,'BOT',3),(113,'TOF-N-T-5',1,5,1,'BOT',4),(114,'TOF-N-T-37',3,5,2,'BOT',4),(115,'TOF-S-T-25',5,5,3,'BOT',4),(116,'TOF-UP-T-13',7,5,4,'BOT',4),(117,'TOF-DW-T-1',9,5,5,'BOT',4),(118,'TOF-DW-T-33',11,5,6,'BOT',4),(119,'TOF-N-T-6',1,6,1,'BOT',5),(120,'TOF-N-T-38',3,6,2,'BOT',5),(121,'TOF-S-T-26',5,6,3,'BOT',5),(122,'TOF-UP-T-14',7,6,4,'BOT',5),(123,'TOF-DW-T-2',9,6,5,'BOT',5),(124,'TOF-DW-T-34',11,6,6,'BOT',5),(125,'TOF-N-T-7',1,7,1,'BOT',6),(126,'TOF-N-T-39',3,7,2,'BOT',6),(127,'TOF-S-T-27',5,7,3,'BOT',6),(128,'TOF-UP-T-15',7,7,4,'BOT',6),(129,'TOF-DW-T-3',9,7,5,'BOT',6),(130,'TOF-DW-T-35',11,7,6,'BOT',6),(131,'TOF-N-T-8',1,8,1,'BOT',7),(132,'TOF-N-T-40',3,8,2,'BOT',7),(133,'TOF-S-T-28',5,8,3,'BOT',7),(134,'TOF-UP-T-16',7,8,4,'BOT',7),(135,'TOF-DW-T-4',9,8,5,'BOT',7),(136,'TOF-DW-T-36',11,8,6,'BOT',7),(137,'TOF-N-T-9',1,9,1,'BOT',8),(138,'TOF-N-T-41',3,9,2,'BOT',8),(139,'TOF-S-T-29',5,9,3,'BOT',8),(140,'TOF-UP-T-17',7,9,4,'BOT',8),(141,'TOF-DW-T-5',9,9,5,'BOT',8),(142,'TOF-DW-T-37',11,9,6,'BOT',8),(143,'TOF-N-T-10',1,10,1,'BOT',9),(144,'TOF-N-T-42',3,10,2,'BOT',9),(145,'TOF-S-T-30',5,10,3,'BOT',9),(146,'TOF-UP-T-18',7,10,4,'BOT',9),(147,'TOF-DW-T-6',9,10,5,'BOT',9),(148,'TOF-DW-T-38',11,10,6,'BOT',9),(149,'TOF-N-T-11',1,11,1,'BOT',10),(150,'TOF-N-T-43',3,11,2,'BOT',10),(151,'TOF-S-T-31',5,11,3,'BOT',10),(152,'TOF-UP-T-19',7,11,4,'BOT',10),(153,'TOF-DW-T-7',9,11,5,'BOT',10),(154,'TOF-DW-T-39',11,11,6,'BOT',10),(155,'TOF-N-T-12',1,12,1,'BOT',11),(156,'TOF-N-T-44',3,12,2,'BOT',11),(157,'TOF-S-T-32',5,12,3,'BOT',11),(158,'TOF-UP-T-20',7,12,4,'BOT',11),(159,'TOF-DW-T-8',9,12,5,'BOT',11),(160,'TOF-DW-T-40',11,12,6,'BOT',11),(161,'TOF-N-T-13',1,13,1,'BOT',12),(162,'TOF-S-T-1',3,13,2,'BOT',12),(163,'TOF-S-T-33',5,13,3,'BOT',12),(164,'TOF-UP-T-21',7,13,4,'BOT',12),(165,'TOF-DW-T-9',9,13,5,'BOT',12),(166,'TOF-DW-T-41',11,13,6,'BOT',12),(167,'TOF-N-T-14',1,14,1,'BOT',13),(168,'TOF-S-T-2',3,14,2,'BOT',13),(169,'TOF-S-T-34',5,14,3,'BOT',13),(170,'TOF-UP-T-22',7,14,4,'BOT',13),(171,'TOF-DW-T-10',9,14,5,'BOT',13),(172,'TOF-DW-T-42',11,14,6,'BOT',13),(173,'TOF-N-T-15',1,15,1,'BOT',14),(174,'TOF-S-T-3',3,15,2,'BOT',14),(175,'TOF-S-T-35',5,15,3,'BOT',14),(176,'TOF-UP-T-23',7,15,4,'BOT',14),(177,'TOF-DW-T-11',9,15,5,'BOT',14),(178,'TOF-DW-T-43',11,15,6,'BOT',14),(179,'TOF-N-T-16',1,16,1,'BOT',15),(180,'TOF-S-T-4',3,16,2,'BOT',15),(181,'TOF-S-T-36',5,16,3,'BOT',15),(182,'TOF-UP-T-24',7,16,4,'BOT',15),(183,'TOF-DW-T-12',9,16,5,'BOT',15),(184,'TOF-DW-T-44',11,16,6,'BOT',15); /*!40000 ALTER TABLE `tdcCable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tdcLocation` -- DROP TABLE IF EXISTS `tdcLocation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tdcLocation` ( `id` smallint(6) NOT NULL, `crateLocationId` smallint(6) NOT NULL, `slot` smallint(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tdcLocation` -- LOCK TABLES `tdcLocation` WRITE; /*!40000 ALTER TABLE `tdcLocation` DISABLE KEYS */; INSERT INTO `tdcLocation` VALUES (1,4,3),(2,4,4),(3,4,5),(4,4,6),(5,4,7),(6,4,8); /*!40000 ALTER TABLE `tdcLocation` 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 2019-11-22 17:26:13