3 -- Table structure for table `acid_event`
6 CREATE TABLE `acid_event` (
7 `sid` int(10) unsigned NOT NULL,
8 `cid` int(10) unsigned NOT NULL,
9 `signature` varchar(255) NOT NULL,
10 `sig_name` varchar(255) default NULL,
11 `sig_class_id` int(10) unsigned default NULL,
12 `sig_priority` int(10) unsigned default NULL,
13 `timestamp` datetime NOT NULL,
14 `ip_src` int(10) unsigned default NULL,
15 `ip_dst` int(10) unsigned default NULL,
16 `ip_proto` int(11) default NULL,
17 `layer4_sport` int(10) unsigned default NULL,
18 `layer4_dport` int(10) unsigned default NULL,
19 `username` varchar(255) default NULL,
20 PRIMARY KEY (`sid`,`cid`),
21 KEY `signature` (`signature`),
22 KEY `sig_name` (`sig_name`),
23 KEY `sig_class_id` (`sig_class_id`),
24 KEY `sig_priority` (`sig_priority`),
25 KEY `timestamp` (`timestamp`),
26 KEY `ip_src` (`ip_src`),
27 KEY `ip_dst` (`ip_dst`),
28 KEY `ip_proto` (`ip_proto`),
29 KEY `layer4_sport` (`layer4_sport`),
30 KEY `layer4_dport` (`layer4_dport`)
31 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
33 -- --------------------------------------------------------
36 -- Table structure for table `data`
40 `sid` int(10) unsigned NOT NULL,
41 `cid` int(10) unsigned NOT NULL,
43 PRIMARY KEY (`sid`,`cid`)
44 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
46 -- --------------------------------------------------------
49 -- Table structure for table `event`
52 CREATE TABLE `event` (
53 `sid` int(10) unsigned NOT NULL,
54 `cid` int(10) unsigned NOT NULL,
55 `signature` int(10) unsigned NOT NULL,
56 `timestamp` datetime NOT NULL,
57 PRIMARY KEY (`sid`,`cid`),
58 KEY `sig` (`signature`),
59 KEY `time` (`timestamp`)
60 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
62 -- --------------------------------------------------------
65 -- Table structure for table `sensor`
68 CREATE TABLE `sensor` (
69 `sid` int(10) unsigned NOT NULL auto_increment,
73 `detail` tinyint(4) default NULL,
74 `encoding` tinyint(4) default NULL,
75 `last_cid` int(10) unsigned NOT NULL,
77 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
79 -- --------------------------------------------------------
82 -- Table structure for table `signature`
85 CREATE TABLE `signature` (
86 `sig_id` int(10) unsigned NOT NULL auto_increment,
87 `sig_name` varchar(255) NOT NULL,
88 `sig_class_id` int(10) unsigned NOT NULL,
89 `sig_priority` int(10) unsigned default NULL,
90 `sig_rev` int(10) unsigned default NULL,
91 `sig_sid` int(10) unsigned default NULL,
92 `sig_gid` int(10) unsigned default NULL,
93 PRIMARY KEY (`sig_id`),
94 KEY `sign_idx` (`sig_name`(20)),
95 KEY `sig_class_id_idx` (`sig_class_id`)
96 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;