· 9 years ago · Oct 31, 2016, 07:56 AM
1CREATE TABLE IF NOT EXISTS `VBangMemPtnInfo` (
2 `MemoryPatternName` varchar(20) NOT NULL,
3 `OriginalFileSHA1` binary(20) NOT NULL,
4 `SourceId` int(11) NOT NULL,
5 `VirtualAddressBgn` bigint(20) NOT NULL,
6 `VirtualAddressEnd` bigint(20) NOT NULL,
7 `PACPDetection` varchar(20) NOT NULL,
8 `DigestUnique` binary(20) NOT NULL,
9 `BlackOrWhite` char(1) NOT NULL,
10 UNIQUE KEY `MajorIndex` (
11 `MemoryPatternName`,
12 `OriginalFileSHA1`,
13 `SourceId`,
14 `VirtualAddressBgn`,
15 `VirtualAddressEnd`,
16 `PACPDetection`,
17 `DigestUnique`,
18 `BlackOrWhite`),
19 KEY `Report` (`OriginalFileSHA1`,`SourceId`)
20) ENGINE=MyISAM DEFAULT CHARSET=latin1;