-
Notifications
You must be signed in to change notification settings - Fork 11
/
Copy pathpcb.sql
105 lines (94 loc) · 21.7 KB
/
pcb.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
-- MariaDB dump 10.19 Distrib 10.5.18-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: SS
-- ------------------------------------------------------
-- Server version 10.5.18-MariaDB-0+deb11u1
/*!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 `pcb`
--
DROP TABLE IF EXISTS `pcb`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pcb` (
`pcb` int(10) unsigned NOT NULL AUTO_INCREMENT,
`leda` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`nfctx` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`nfcrx` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`nfcpower` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`nfcred` enum('-','30','31','32','33','34','35','71','72','-30','-31','-32','-33','-34','-35','-71','-72') NOT NULL DEFAULT '-',
`nfcamber` enum('-','30','31','32','33','34','35','71','72','-30','-31','-32','-33','-34','-35','-71','-72') NOT NULL DEFAULT '-',
`nfcgreen` enum('-','30','31','32','33','34','35','71','72','-30','-31','-32','-33','-34','-35','-71','-72') NOT NULL DEFAULT '-',
`nfccard` enum('-','30','31','32','33','34','35','71','72','-30','-31','-32','-33','-34','-35','-71','-72') NOT NULL DEFAULT '-',
`pcbname` text DEFAULT NULL,
`keypadtx` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`keypadrx` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`keypadde` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`keypadre` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`ledr` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`ledg` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`ledb` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`gpstx` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`gpsrx` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`gpstick` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
PRIMARY KEY (`pcb`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pcb`
--
LOCK TABLES `pcb` WRITE;
/*!40000 ALTER TABLE `pcb` DISABLE KEYS */;
INSERT INTO `pcb` VALUES (1,'-14','17','16','-4','33','32','31','32','2021-06-01 Access','-','-','-','-','-','-','-','-','-','-'),(2,'-14','-','-','-','-','-','-','-','2021-05-15 Bell Box','-','-','-','-','-','-','-','-','-','-'),(3,'-14','17','16','-5','33','32','31','-','2021-05-11 Access','-','-','-','-','-','-','-','-','-','-'),(4,'-12','17','16','-5','33','32','31','-','2021-05-03 Access','-','-','-','-','-','-','-','-','-','-'),(5,'-25','-','-','-','-','-','-','-','2021-06-20 Bell box','-','-','-','-','-','-','-','-','-','-'),(6,'-14','-','-','-','-','-','-','-','2021-06-01 Keypad','17','16','4','4','-','-','-','-','-','-'),(7,'-','-','-','-','-','-','-','-','2021-06-20 Generic','-','-','-','-','-33','-32','-25','-','-','-'),(9,'-','-','-','-','-','-','-','-','2021-07-20 Keypad','15','27','13','13','-32','-26','-33','-','-','-'),(10,'-','-','-','-','-','-','-','-','2021-07-20 Bell box','-','-','-','-','-26','-27','-25','-','-','-'),(12,'-','-','-','-','-','-','-','-','2021-07-20 Generic','-','-','-','-','-32','-25','-33','-','-','-'),(13,'-','-','-','-','-','-','-','-','2022-03-06 GPS','-','-','-','-','-22','-19','-21','32','25','33'),(14,'-','-','-','-','-','-','-','-','2022-03-06 Keypad2','14','15','13','13','-25','-26','-27','-','-','-'),(15,'-','-','-','-','-','-','-','-','2022-03-06 Bell2GPS','-','-','-','-','-19','-21','-22','33','35','34'),(16,'-','-','-','-','-','-','-','-','2022-03-06 Bell2','-','-','-','-','-19','-21','-22','-','35','34'),(17,'0','-','-','-','-','-','-','-','Shelly Plus 1','-','-','-','-','-','-','-','-','-','-'),(18,'-','4','15','-13','33','32','31','32','2022-02-23 Access2','-','-','-','-','-25','-32','-33','-','-','-'),(19,'0','-','-','-','-','-','-','-','Shelly Plus i4','-','-','-','-','-','-','-','-','-','-'),(21,'-','4','15','-13','33','32','31','32','2023-01-12 Access2','-','-','-','-','-32','-25','-33','-','-','-'),(22,'-','4','-15','-13','33','32','31','32','2023-03-18 Access3','-','-','-','-','-32','-25','-33','-','-','-'),(23,'-','-','-','-','-','-','-','-','2043-04-08 Output','-','-','-','-','-22','-21','-19','-','-','-');
/*!40000 ALTER TABLE `pcb` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gpio`
--
DROP TABLE IF EXISTS `gpio`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gpio` (
`gpio` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pcb` int(10) unsigned DEFAULT NULL,
`pin` enum('-','0','2','4','5','7','8','12','13','14','15','16','17','18','19','20','21','22','23','25','26','27','32','33','34','35','36','39','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','-0','-2','-4','-5','-7','-8','-12','-13','-14','-15','-16','-17','-18','-19','-20','-21','-22','-23','-25','-26','-27','-32','-33','-34','-35','-36','-39','-48','-49','-50','-51','-52','-53','-54','-55','-56','-57','-58','-59','-60','-61','-62','-63') NOT NULL DEFAULT '-',
`io` enum('-','IO','I','O') NOT NULL DEFAULT '-',
`inittype` enum('-','I','O','P') NOT NULL DEFAULT '-',
`initname` char(16) DEFAULT NULL,
`inithold` int(10) DEFAULT NULL,
`initpulse` int(10) DEFAULT NULL,
`initinvert` enum('false','true') NOT NULL DEFAULT 'false',
`value0` text DEFAULT NULL,
`value1` text DEFAULT NULL,
`initfunc` set('L','D','E','B','C','O','M') NOT NULL DEFAULT '',
PRIMARY KEY (`gpio`),
UNIQUE KEY `gpio_pcb_gpio` (`pcb`,`gpio`),
CONSTRAINT `gpio_pcb` FOREIGN KEY (`pcb`) REFERENCES `pcb` (`pcb`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=185 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gpio`
--
LOCK TABLES `gpio` WRITE;
/*!40000 ALTER TABLE `gpio` DISABLE KEYS */;
INSERT INTO `gpio` VALUES (3,1,'5','IO','P','Pin 1',0,0,'true','Low','High',''),(4,1,'18','IO','I','Pin 2',0,0,'true','Low','High','E'),(5,1,'19','IO','P','Pin 3',0,0,'true','Low','High',''),(6,1,'21','IO','I','Pin 4',0,0,'false','Low','High','O'),(7,1,'22','IO','P','Pin 5',0,0,'true','Low','High',''),(8,1,'23','IO','I','Pin 6',0,0,'false','Low','High','L'),(9,1,'-15','O','O','Relay',0,0,'false','Closed','Open','L'),(10,2,'12','IO','I','Tamper',0,0,'false','Low','High',''),(11,2,'13','IO','I','Fault',0,0,'false','Low','High',''),(12,2,'19','O','O','Bell',0,6000,'false','Low','High',''),(13,2,'21','O','O','Strobe',0,0,'false','Low','High',''),(14,2,'22','O','O','EngHold',0,0,'false','Low','High',''),(15,2,'-23','O','O','BltDis',0,0,'false','Low','High',''),(16,3,'18','IO','I','Pin 2',0,0,'true','Low','High','E'),(17,3,'21','IO','I','Pin 4',0,0,'false','Low','High','O'),(18,3,'22','IO','I','Pin 6',0,0,'false','Low','High','L'),(19,3,'-15','O','O','Lock',0,0,'false','Closed','Open','L'),(20,4,'18','IO','I','Pin 2',0,0,'true','Low','High','E'),(21,4,'21','IO','I','Pin 4',0,0,'false','Low','High','O'),(22,4,'22','IO','I','Pin 6',0,0,'false','Low','High','L'),(23,4,'-15','O','O','Lock',0,0,'false','Closed','Open','L'),(24,5,'14','IO','I','Tamper',0,0,'false','Low','High',''),(25,5,'13','IO','I','Fault',0,0,'false','Low','High',''),(26,5,'-19','O','O','Bell',0,3000,'false','Low','High',''),(27,5,'-21','O','O','Strobe',0,0,'false','Low','High',''),(28,5,'-22','O','O','EngHold',0,0,'false','Low','High',''),(29,5,'23','O','O','Light',0,0,'false','Low','High',''),(30,7,'13','IO','-','Pin 2',0,0,'false','Low','High',''),(31,7,'15','IO','-','Pin 3',0,0,'false','Low','High',''),(32,7,'2','IO','-','Pin 4',0,0,'false','Low','High',''),(33,7,'27','IO','-','Pin 5',0,0,'false','Low','High',''),(34,7,'4','IO','-','Pin 6',0,0,'false','Low','High',''),(44,10,'14','IO','I','Tamper',0,0,'false','Low','High',''),(45,10,'13','IO','I','Fault',0,0,'false','Low','High',''),(46,10,'19','O','O','Bell',0,3000,'false','Low','High',''),(47,10,'21','O','O','Strobe',0,0,'false','Low','High',''),(48,10,'22','O','O','EngHold',0,0,'false','Low','High',''),(49,10,'23','O','O','Light',0,0,'false','Low','High',''),(51,12,'13','IO','-','Pin 2',0,0,'false','Low','High',''),(52,12,'15','IO','-','Pin 3',0,0,'false','Low','High',''),(53,12,'2','IO','-','Pin 4',0,0,'false','Low','High',''),(54,12,'27','IO','-','Pin 5',0,0,'false','Low','High',''),(55,12,'4','IO','-','Pin 6',0,0,'false','Low','High',''),(56,4,'48','I','I','NFCTamper',0,0,'false','Low','High',''),(57,4,'-55','I','I','Bell',0,0,'false','Open','Closed',''),(58,3,'48','I','I','NFCTamper',0,0,'false','Low','High',''),(59,3,'-55','I','I','Bell',0,0,'false','Open','Closed',''),(60,3,'13','I','I','Tamper',0,0,'false','Low','High',''),(61,1,'13','I','I','Tamper',0,0,'false','Low','High',''),(62,1,'48','I','I','NFCTamper',0,0,'false','Low','High',''),(63,1,'-55','I','I','Bell',0,0,'false','Open','Closed',''),(64,6,'56','I','I','Tamper',0,0,'false','Low','High',''),(65,9,'56','I','I','Tamper',0,0,'false','Low','High',''),(66,4,'58','I','I','NFCFault',0,0,'false','Low','High',''),(67,3,'58','I','I','NFCFault',0,0,'false','Low','High',''),(68,1,'58','I','I','NFCFault',0,0,'false','Low','High',''),(69,2,'63','I','I','MeshFault',0,0,'false','Low','High',''),(70,5,'63','I','I','MeshFault',0,0,'false','Low','High',''),(71,10,'63','I','I','MeshFault',0,0,'false','Low','High',''),(72,6,'57','I','I','Fault',0,0,'false','Low','High',''),(73,9,'57','I','I','Fault',0,0,'false','Low','High',''),(74,4,'60','I','I','Forced',0,0,'false','Low','High',''),(75,4,'61','I','I','Propped',0,0,'false','Low','High',''),(76,3,'60','I','I','Forced',0,0,'false','Low','High',''),(77,3,'61','I','I','Propped',0,0,'false','Low','High',''),(78,1,'60','I','I','Forced',0,0,'false','Low','High',''),(79,1,'61','I','I','Propped',0,0,'false','Low','High',''),(80,9,'63','I','I','MeshFault',0,0,'false','Low','High',''),(81,6,'63','I','I','MeshFault',0,0,'false','Low','High',''),(82,13,'62','I','I','Fault',0,0,'false','Low','High',''),(83,14,'56','I','I','Tamper',0,0,'false','Low','High',''),(84,14,'57','I','I','Fault',0,0,'false','Low','High',''),(85,14,'63','I','I','MeshFault',0,0,'false','Low','High',''),(86,15,'7','IO','I','Tamper',0,0,'false','Low','High',''),(87,15,'20','IO','I','Fault',0,0,'false','Low','High',''),(88,15,'14','O','O','Bell',0,3000,'false','Low','High',''),(89,15,'13','O','O','Strobe',0,0,'false','Low','High',''),(90,15,'15','O','O','EngHold',0,0,'false','Low','High',''),(91,15,'8','O','O','Light',0,0,'false','Low','High',''),(92,15,'63','I','I','MeshFault',0,0,'false','Low','High',''),(93,16,'7','IO','I','Tamper',0,0,'false','Low','High',''),(94,16,'20','IO','I','Fault',0,0,'false','Low','High',''),(95,16,'14','O','O','Bell',0,3000,'false','Low','High',''),(96,16,'13','O','O','Strobe',0,0,'false','Low','High',''),(97,16,'15','O','O','EngHold',0,0,'false','Low','High',''),(98,16,'8','O','O','Light',0,0,'false','Low','High',''),(99,16,'63','I','I','MeshFault',0,0,'false','Low','High',''),(100,15,'62','I','I','GPSFault',0,0,'false','Low','High',''),(101,15,'-62','I','I','GPSNoSats',0,0,'false','Low','High',''),(102,17,'-4','I','I','Input',0,0,'true','Make','Break',''),(103,17,'26','O','O','Relay',0,0,'false','Low','High',''),(104,18,'20','IO','P','Pin 1',0,0,'true','Low','High',''),(105,18,'7','IO','I','Pin 2',0,0,'true','Low','High','E'),(106,18,'8','IO','P','Pin 3',0,0,'true','Low','High',''),(107,18,'19','IO','I','Pin 4',0,0,'false','Low','High','O'),(108,18,'22','IO','P','Pin 5',0,0,'true','Low','High',''),(109,18,'21','IO','I','Pin 6',0,0,'false','Low','High','L'),(110,18,'-14','O','O','Relay',0,0,'false','Closed','Open','L'),(111,18,'26','I','I','Tamper',0,0,'false','Low','High',''),(112,18,'48','I','I','NFCTamper',0,0,'false','Low','High',''),(113,18,'-55','I','I','Bell',0,0,'false','Open','Closed',''),(114,18,'58','I','I','NFCFault',0,0,'false','Unset','Set',''),(115,18,'60','I','I','Forced',0,0,'false','Unset','Set',''),(116,18,'61','I','I','Propped',0,0,'false','Unset','Set',''),(119,17,'25','I','I','Button',0,0,'false','Low','High',''),(120,17,'-56','I','I','Timer1',0,0,'false','Low','High',''),(121,14,'-56','I','I','Timer1',0,0,'false','Low','High',''),(122,1,'-56','I','I','Timer1',0,0,'false','Low','High',''),(123,3,'-56','I','I','Timer1',0,0,'false','Low','High',''),(124,19,'-14','I','I','I2',0,0,'false','Make','Break',''),(125,19,'-26','I','I','I4',0,0,'false','Make','Break',''),(126,19,'-12','I','I','I1',0,0,'false','Make','Break',''),(127,19,'-27','I','I','I3',0,0,'false','Make','Break',''),(131,19,'-56','I','I','Timer1',0,0,'false','Low','High',''),(132,19,'25','I','I','Button',0,0,'false','Press','Release',''),(146,21,'20','IO','P','Pin 1',0,0,'true','Low','High',''),(147,21,'7','IO','I','Pin 2',0,0,'true','Low','High','E'),(148,21,'8','IO','P','Pin 3',0,0,'true','Low','High',''),(149,21,'19','IO','I','Pin 4',0,0,'false','Low','High','O'),(150,21,'22','IO','P','Pin 5',0,0,'true','Low','High',''),(151,21,'21','IO','I','Pin 6',0,0,'false','Low','High','L'),(152,21,'-14','O','O','Relay',0,0,'false','Closed','Open','L'),(153,21,'26','I','I','Tamper',0,0,'false','Low','High',''),(154,21,'48','I','I','NFCTamper',0,0,'false','Low','High',''),(155,21,'-55','I','I','Bell',0,0,'false','Open','Closed',''),(156,21,'58','I','I','NFCFault',0,0,'false','Unset','Set',''),(157,21,'60','I','I','Forced',0,0,'false','Unset','Set',''),(158,21,'61','I','I','Propped',0,0,'false','Unset','Set',''),(159,18,'59','I','I','Lock fault',0,0,'false','Low','High',''),(160,22,'20','IO','P','Pin 1',0,0,'true','Low','High',''),(161,22,'7','IO','I','Pin 2',0,0,'true','Low','High','E'),(162,22,'8','IO','P','Pin 3',0,0,'true','Low','High',''),(163,22,'19','IO','I','Pin 4',0,0,'false','Low','High','O'),(164,22,'22','IO','P','Pin 5',0,0,'true','Low','High',''),(165,22,'21','IO','I','Pin 6',0,0,'false','Low','High','L'),(166,22,'-14','O','O','Relay',0,0,'false','Closed','Open','L'),(167,22,'26','I','I','Tamper',0,0,'false','Low','High',''),(168,22,'48','I','I','NFCTamper',0,0,'false','Low','High',''),(169,22,'-55','I','I','Bell',0,0,'false','Open','Closed',''),(170,22,'58','I','I','NFCFault',0,0,'false','Unset','Set',''),(171,22,'60','I','I','Forced',0,0,'false','Unset','Set',''),(172,22,'61','I','I','Propped',0,0,'false','Unset','Set',''),(175,23,'13','O','-','Out01',0,0,'false','Low','High',''),(176,23,'7','O','-','Out02',0,0,'false','Low','High',''),(177,23,'8','O','-','Out03',0,0,'false','Low','High',''),(178,23,'20','O','-','Out04',0,0,'false','Low','High',''),(179,23,'4','O','-','Out05',0,0,'false','Low','High',''),(180,23,'32','O','-','Out06',0,0,'false','Low','High',''),(181,23,'14','O','-','Out07',0,0,'false','Low','High',''),(182,23,'33','O','-','Out08',0,0,'false','Low','High',''),(183,23,'25','O','-','Out09',0,0,'false','Low','High',''),(184,23,'26','O','-','Out10',0,0,'false','Low','High','');
/*!40000 ALTER TABLE `gpio` 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-04-19 12:34:56