forked from KD8EYF/DMRlink
-
Notifications
You must be signed in to change notification settings - Fork 0
/
dmrlink.sql
28 lines (28 loc) · 967 Bytes
/
dmrlink.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
CREATE TABLE IF NOT EXISTS `peer_status` (
`NETWORK` varchar(16) NOT NULL,
`RADIO_ID` int(11) NOT NULL,
`IP` varchar(16) NOT NULL,
`PORT` int(11) NOT NULL,
`TS_1` tinyint(1) NOT NULL,
`TS_2` tinyint(1) NOT NULL,
`PEER_MODE` varchar(8) NOT NULL,
`PEER_OP` tinyint(1) NOT NULL,
`VOICE` tinyint(1) NOT NULL,
`RCM` tinyint(1) NOT NULL,
`XNL_SLAVE` tinyint(1) NOT NULL,
`MASTER` tinyint(1) NOT NULL,
`CON_APP` tinyint(1) NOT NULL,
`XNL_CON` tinyint(1) NOT NULL,
`CSBK` tinyint(1) NOT NULL,
`DATA` tinyint(1) NOT NULL,
`XNL_MASTER` tinyint(1) NOT NULL,
`AUTH` tinyint(1) NOT NULL,
`KEEP_ALIVE_RX_TIME` int(11) NOT NULL,
`KEEP_ALIVES_SENT` int(11) NOT NULL,
`KEEP_ALIVES_OUTSTANDING` int(11) NOT NULL,
`CONNECTED` tinyint(1) NOT NULL,
`PEER_LIST` tinyint(1) NOT NULL,
`KEEP_ALIVES_RECEIVED` int(11) NOT NULL,
`KEEP_ALIVES_MISSED` int(11) NOT NULL,
UNIQUE KEY `RADIO_ID` (`RADIO_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;