· 7 years ago · Nov 20, 2018, 02:06 AM
1CREATE TABLE IF NOT EXISTS `UserLog` (
2 `Key` text NOT NULL,
3 `StartTime` datetime NOT NULL,
4 `EndTime` datetime NOT NULL,
5 `SourceNet` int(11) NOT NULL,
6 `PacketType` int(2) NOT NULL,
7 `RepeaterID` int(11) NOT NULL,
8 `DmrID` int(11) NOT NULL,
9 `DestinationID` int(11) NOT NULL,
10 `Sequence` int(11) NOT NULL,
11 `TimeSlot` int(11) NOT NULL,
12 `GroupCall` int(11) NOT NULL,
13 `PrivateCall` int(11) NOT NULL,
14 `DataCall` int(11) NOT NULL,
15 `Raw` int(11) NOT NULL,
16 `Duration` int(11) NOT NULL
17) ENGINE=MyISAM DEFAULT CHARSET=latin1;
18
19/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
20/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
21/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;