2 Navicat MySQL Data Transfer
\r
4 Source Server : generic-localhost
\r
5 Source Server Version : 50167
\r
6 Source Host : localhost:3306
\r
7 Source Database : snorby
\r
9 Target Server Type : MYSQL
\r
10 Target Server Version : 50167
\r
11 File Encoding : 65001
\r
13 Date: 2013-01-28 16:35:59
\r
16 SET FOREIGN_KEY_CHECKS=0;
\r
17 -- ----------------------------
\r
18 -- Table structure for `category`
\r
19 -- ----------------------------
\r
20 DROP TABLE IF EXISTS `category`;
\r
21 CREATE TABLE `category` (
\r
22 `cat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
\r
23 `sig_class_id` smallint(5) NOT NULL,
\r
24 `cat_name` varchar(32) NOT NULL,
\r
25 PRIMARY KEY (`cat_id`),
\r
26 UNIQUE KEY `cat_name` (`cat_name`),
\r
27 KEY `cat_name_2` (`cat_name`)
\r
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\r
30 -- ----------------------------
\r
31 -- Records of category
\r
32 -- ----------------------------
\r
33 INSERT INTO `category` VALUES ('1', '1', 'syslog');
\r
34 INSERT INTO `category` VALUES ('2', '29', 'firewall');
\r
35 INSERT INTO `category` VALUES ('3', '29', 'ids');
\r
36 INSERT INTO `category` VALUES ('4', '1', 'web-log');
\r
37 INSERT INTO `category` VALUES ('5', '1', 'squid');
\r
38 INSERT INTO `category` VALUES ('6', '1', 'windows');
\r
39 INSERT INTO `category` VALUES ('7', '1', 'ossec');
\r
40 INSERT INTO `category` VALUES ('8', '9', 'pam');
\r
41 INSERT INTO `category` VALUES ('9', '11', 'authentication_success');
\r
42 INSERT INTO `category` VALUES ('10', '18', 'authentication_failed');
\r
43 INSERT INTO `category` VALUES ('11', '18', 'invalid_login');
\r
44 INSERT INTO `category` VALUES ('12', '18', 'authentication_failures');
\r
45 INSERT INTO `category` VALUES ('13', '1', 'sshd');
\r
46 INSERT INTO `category` VALUES ('14', '4', 'recon');
\r
47 INSERT INTO `category` VALUES ('15', '28', 'exploit_attempt');
\r
48 INSERT INTO `category` VALUES ('16', '1', 'telnetd');
\r
49 INSERT INTO `category` VALUES ('17', '3', 'errors');
\r
50 INSERT INTO `category` VALUES ('18', '29', 'low_diskspace');
\r
51 INSERT INTO `category` VALUES ('19', '29', 'service_availability');
\r
52 INSERT INTO `category` VALUES ('20', '29', 'nfs');
\r
53 INSERT INTO `category` VALUES ('21', '29', 'xinetd');
\r
54 INSERT INTO `category` VALUES ('22', '29', 'access_control');
\r
55 INSERT INTO `category` VALUES ('23', '18', 'access_denied');
\r
56 INSERT INTO `category` VALUES ('24', '22', 'connection_attempt');
\r
57 INSERT INTO `category` VALUES ('25', '1', 'mail');
\r
58 INSERT INTO `category` VALUES ('26', '1', 'smartd');
\r
59 INSERT INTO `category` VALUES ('27', '1', 'linuxkernel');
\r
60 INSERT INTO `category` VALUES ('28', '1', 'promisc');
\r
61 INSERT INTO `category` VALUES ('29', '1', 'system_shutdown');
\r
62 INSERT INTO `category` VALUES ('30', '1', 'cron');
\r
63 INSERT INTO `category` VALUES ('31', '19', 'su');
\r
64 INSERT INTO `category` VALUES ('32', '1', 'tripwire');
\r
65 INSERT INTO `category` VALUES ('33', '1', 'adduser');
\r
66 INSERT INTO `category` VALUES ('34', '19', 'sudo');
\r
67 INSERT INTO `category` VALUES ('35', '29', 'pptp');
\r
68 INSERT INTO `category` VALUES ('36', '1', 'fts');
\r
69 INSERT INTO `category` VALUES ('37', '1', 'dpkg');
\r
70 INSERT INTO `category` VALUES ('38', '1', 'config_changed');
\r
71 INSERT INTO `category` VALUES ('39', '1', 'yum');
\r
72 INSERT INTO `category` VALUES ('40', '29', 'arpwatch');
\r
73 INSERT INTO `category` VALUES ('41', '29', 'new_host');
\r
74 INSERT INTO `category` VALUES ('42', '30', 'ip_spoof');
\r
75 INSERT INTO `category` VALUES ('43', '1', 'symantec');
\r
76 INSERT INTO `category` VALUES ('44', '17', 'virus');
\r
77 INSERT INTO `category` VALUES ('45', '29', 'pix');
\r
78 INSERT INTO `category` VALUES ('46', '1', 'account_changed');
\r
79 INSERT INTO `category` VALUES ('47', '3', 'system_error');
\r
80 INSERT INTO `category` VALUES ('48', '1', 'named');
\r
81 INSERT INTO `category` VALUES ('49', '10', 'invalid_access');
\r
82 INSERT INTO `category` VALUES ('50', '3', 'client_misconfig');
\r
83 INSERT INTO `category` VALUES ('51', '29', 'smbd');
\r
84 INSERT INTO `category` VALUES ('52', '29', 'vsftpd');
\r
85 INSERT INTO `category` VALUES ('53', '29', 'pure-ftpd');
\r
86 INSERT INTO `category` VALUES ('54', '29', 'proftpd');
\r
87 INSERT INTO `category` VALUES ('55', '29', 'msftp');
\r
88 INSERT INTO `category` VALUES ('56', '29', 'ftpd');
\r
89 INSERT INTO `category` VALUES ('57', '29', 'hordeimp');
\r
90 INSERT INTO `category` VALUES ('58', '29', 'roundcube');
\r
91 INSERT INTO `category` VALUES ('59', '1', 'wordpress');
\r
92 INSERT INTO `category` VALUES ('60', '29', 'cimserver');
\r
93 INSERT INTO `category` VALUES ('61', '29', 'vpopmail');
\r
94 INSERT INTO `category` VALUES ('62', '29', 'vm-pop3d');
\r
95 INSERT INTO `category` VALUES ('63', '29', 'courier');
\r
96 INSERT INTO `category` VALUES ('64', '29', 'web');
\r
97 INSERT INTO `category` VALUES ('65', '1', 'accesslog');
\r
98 INSERT INTO `category` VALUES ('66', '28', 'attack');
\r
99 INSERT INTO `category` VALUES ('67', '30', 'sql_injection');
\r
100 INSERT INTO `category` VALUES ('68', '27', 'web_scan');
\r
101 INSERT INTO `category` VALUES ('69', '29', 'appsec');
\r
102 INSERT INTO `category` VALUES ('70', '29', 'apache');
\r
103 INSERT INTO `category` VALUES ('71', '22', 'automatic_attack');
\r
104 INSERT INTO `category` VALUES ('72', '22', 'unknown_resource');
\r
105 INSERT INTO `category` VALUES ('73', '3', 'invalid_request');
\r
106 INSERT INTO `category` VALUES ('74', '1', 'mysql_log');
\r
107 INSERT INTO `category` VALUES ('75', '1', 'postgresql_log');
\r
108 INSERT INTO `category` VALUES ('76', '29', 'firewall_drop');
\r
109 INSERT INTO `category` VALUES ('77', '23', 'multiple_drops');
\r
110 INSERT INTO `category` VALUES ('78', '29', 'cisco_ios');
\r
111 INSERT INTO `category` VALUES ('79', '29', 'netscreenfw');
\r
112 INSERT INTO `category` VALUES ('80', '29', 'sonicwall');
\r
113 INSERT INTO `category` VALUES ('81', '1', 'postfix');
\r
114 INSERT INTO `category` VALUES ('82', '32', 'spam');
\r
115 INSERT INTO `category` VALUES ('83', '32', 'multiple_spam');
\r
116 INSERT INTO `category` VALUES ('84', '29', 'sendmail');
\r
117 INSERT INTO `category` VALUES ('85', '29', 'smf-sav');
\r
118 INSERT INTO `category` VALUES ('86', '29', 'imapd');
\r
119 INSERT INTO `category` VALUES ('87', '29', 'mailscanner');
\r
120 INSERT INTO `category` VALUES ('88', '29', 'dovecot');
\r
121 INSERT INTO `category` VALUES ('89', '29', 'ms');
\r
122 INSERT INTO `category` VALUES ('90', '29', 'exchange');
\r
123 INSERT INTO `category` VALUES ('91', '29', 'racoon');
\r
124 INSERT INTO `category` VALUES ('92', '29', 'cisco_vpn');
\r
125 INSERT INTO `category` VALUES ('93', '29', 'spamd');
\r
126 INSERT INTO `category` VALUES ('94', '10', 'win_authentication_failed');
\r
127 INSERT INTO `category` VALUES ('95', '1', 'policy_changed');
\r
128 INSERT INTO `category` VALUES ('96', '1', 'group_changed');
\r
129 INSERT INTO `category` VALUES ('97', '1', 'win_group_changed');
\r
130 INSERT INTO `category` VALUES ('98', '1', 'logs_cleared');
\r
131 INSERT INTO `category` VALUES ('99', '1', 'login_denied');
\r
132 INSERT INTO `category` VALUES ('100', '1', 'time_changed');
\r
133 INSERT INTO `category` VALUES ('101', '1', 'group_created');
\r
134 INSERT INTO `category` VALUES ('102', '1', 'win_group_created');
\r
135 INSERT INTO `category` VALUES ('103', '2', 'group_deleted');
\r
136 INSERT INTO `category` VALUES ('104', '2', 'win_group_deleted');
\r
137 INSERT INTO `category` VALUES ('105', '30', 'attacks');
\r
138 INSERT INTO `category` VALUES ('106', '1', 'mcafee');
\r
139 INSERT INTO `category` VALUES ('107', '1', 'trend_micro');
\r
140 INSERT INTO `category` VALUES ('108', '1', 'ocse');
\r
141 INSERT INTO `category` VALUES ('109', '1', 'ocsevirus');
\r
142 INSERT INTO `category` VALUES ('110', '1', 'mse');
\r
143 INSERT INTO `category` VALUES ('111', '30', 'zeus');
\r
144 INSERT INTO `category` VALUES ('112', '1', 'solaris_bsm');
\r
145 INSERT INTO `category` VALUES ('113', '1', 'vmware');
\r
146 INSERT INTO `category` VALUES ('114', '29', 'dhcp');
\r
147 INSERT INTO `category` VALUES ('115', '1', 'service_start');
\r
148 INSERT INTO `category` VALUES ('116', '29', 'dhcp_lease_action');
\r
149 INSERT INTO `category` VALUES ('117', '29', 'dhcp_dns_maintenance');
\r
150 INSERT INTO `category` VALUES ('118', '29', 'dhcp_maintenance');
\r
151 INSERT INTO `category` VALUES ('119', '30', 'dhcp_rogue_server');
\r
152 INSERT INTO `category` VALUES ('120', '29', 'dhcp_ipv6');
\r
153 INSERT INTO `category` VALUES ('121', '29', 'asterisk');
\r
154 INSERT INTO `category` VALUES ('122', '1', 'rootcheck');
\r
155 INSERT INTO `category` VALUES ('123', '1', 'syscheck');
\r
156 INSERT INTO `category` VALUES ('124', '1', 'process_monitor');
\r
157 INSERT INTO `category` VALUES ('125', '1', 'agentless');
\r
158 INSERT INTO `category` VALUES ('126', '1', 'hostinfo');
\r
159 INSERT INTO `category` VALUES ('127', '1', 'active_response');
\r
160 INSERT INTO `category` VALUES ('128', '13', 'elevation_of_privilege');
\r
161 INSERT INTO `category` VALUES ('129', '1', 'local');
\r
162 INSERT INTO `category` VALUES ('130', '1', 'openbsd');
\r
163 INSERT INTO `category` VALUES ('131', '1', 'openbsdgroupdel');
\r
164 INSERT INTO `category` VALUES ('132', '1', 'clamd');
\r
165 INSERT INTO `category` VALUES ('133', '1', 'freshclam');
\r
166 INSERT INTO `category` VALUES ('134', '1', 'bro');
\r
167 INSERT INTO `category` VALUES ('135', '30', 'dropbear');
\r
168 INSERT INTO `category` VALUES ('136', '30', 'dropbearauthentication_failed');
\r
169 INSERT INTO `category` VALUES ('137', '4', 'dropbearauthentication_failures');
\r
170 INSERT INTO `category` VALUES ('138', '4', 'dropbearrecon');
\r
171 INSERT INTO `category` VALUES ('139', '5', 'dropbearauthentication_success');
\r