root/trunk/umitDB/sql/sqlite-drop-triggers.sql @ 4097

Revision 4097, 5.5 kB (checked in by luis, 4 years ago)

Updated licence copyrights using -> find . -path '*/.svn' -prune -o -type f -print0 | xargs -0 sed -i -e 's/2007 Insecure.Com LLC./2007 Adriano Monteiro Marques/'

Line 
1-- Copyright (C) 2007 Adriano Monteiro Marques
2--
3-- Author: Guilherme Polo <ggpolo@gmail.com>
4--
5-- This program is free software; you can redistribute it and/or modify
6-- it under the terms of the GNU General Public License as published by
7-- the Free Software Foundation; either version 2 of the License, or
8-- (at your option) any later version.
9--
10-- This program is distributed in the hope that it will be useful,
11-- but WITHOUT ANY WARRANTY; without even the implied warranty of
12-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
13-- GNU General Public License for more details.
14--
15-- You should have received a copy of the GNU General Public License
16-- along with this program; if not, write to the Free Software
17-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307
18-- USA
19
20
21-------------------
22-- Drop Triggers
23-------------------
24
25--
26-- Triggers for handling INSERT
27--
28
29-- scan
30DROP TRIGGER scan_insert_bad_scanner;
31DROP TRIGGER scaninfo_insert_bad_scan;
32DROP TRIGGER scaninfo_insert_bad_scan_type;
33DROP TRIGGER scaninfo_insert_bad_protocol;
34-- host
35DROP TRIGGER host_insert_bad_scan;
36DROP TRIGGER host_insert_bad_host_state;
37DROP TRIGGER fingerprint_info_insert_bad_host;
38DROP TRIGGER address_insert_bad_vendor;
39DROP TRIGGER _host_hostname_insert_bad_host;
40DROP TRIGGER _host_hostname_insert_bad_hostname;
41DROP TRIGGER _host_address_insert_bad_host;
42DROP TRIGGER _host_address_insert_bad_address;
43DROP TRIGGER _host_port_insert_bad_host;
44DROP TRIGGER _host_port_insert_bad_port;
45DROP TRIGGER osmatch_insert_bad_host;
46DROP TRIGGER osclass_insert_bad_osgen;
47DROP TRIGGER osclass_insert_bad_osfamily;
48DROP TRIGGER osclass_insert_bad_osvendor;
49DROP TRIGGER osclass_insert_bad_ostype;
50DROP TRIGGER osclass_insert_bad_host;
51DROP TRIGGER portused_insert_bad_protocol;
52DROP TRIGGER portused_insert_bad_port_state;
53DROP TRIGGER portused_insert_bad_host;
54-- ports
55DROP TRIGGER port_insert_bad_service_info;
56DROP TRIGGER port_insert_bad_protocol;
57DROP TRIGGER port_insert_bad_port_state;
58DROP TRIGGER extraports_insert_bad_host;
59DROP TRIGGER extraports_insert_bad_port_state;
60DROP TRIGGER service_info_insert_bad_service_name;
61DROP TRIGGER service_info_insert_bad_ostype;
62-- inventory
63DROP TRIGGER _inventory_scan_insert_bad_scan;
64DROP TRIGGER _inventory_scan_insert_bad_inventory;
65DROP TRIGGER _inventory_changes_insert_bad_inventory;
66DROP TRIGGER _inventory_changes_insert_bad_category;
67DROP TRIGGER _inventory_changes_insert_bad_address;
68-- traceroute
69DROP TRIGGER trace_insert_bad_protocol;
70DROP TRIGGER hop_insert_bad_trace;
71
72
73--
74-- Triggers for handling UPDATE
75--
76
77-- scan
78DROP TRIGGER scan_update_bad_scanner;
79DROP TRIGGER scaninfo_update_bad_scan;
80DROP TRIGGER scaninfo_update_bad_scan_type;
81DROP TRIGGER scaninfo_update_bad_protocol;
82-- host
83DROP TRIGGER host_update_bad_scan;
84DROP TRIGGER host_update_bad_host_state;
85DROP TRIGGER fingerprint_info_update_bad_host;
86DROP TRIGGER address_update_bad_vendor;
87DROP TRIGGER _host_hostname_update_bad_host;
88DROP TRIGGER _host_hostname_update_bad_hostname;
89DROP TRIGGER _host_address_update_bad_host;
90DROP TRIGGER _host_address_update_bad_address;
91DROP TRIGGER _host_port_update_bad_host;
92DROP TRIGGER _host_port_update_bad_port;
93DROP TRIGGER osmatch_update_bad_host;
94DROP TRIGGER osclass_update_bad_osgen;
95DROP TRIGGER osclass_update_bad_osfamily;
96DROP TRIGGER osclass_update_bad_osvendor;
97DROP TRIGGER osclass_update_bad_ostype;
98DROP TRIGGER osclass_update_bad_host;
99DROP TRIGGER portused_update_bad_protocol;
100DROP TRIGGER portused_update_bad_port_state;
101DROP TRIGGER portused_update_bad_host;
102-- ports
103DROP TRIGGER port_update_bad_service_info;
104DROP TRIGGER port_update_bad_protocol;
105DROP TRIGGER port_update_bad_port_state;
106DROP TRIGGER extraports_update_bad_host;
107DROP TRIGGER extraports_update_bad_port_state;
108DROP TRIGGER service_info_update_bad_service_name;
109DROP TRIGGER service_info_update_bad_ostype;
110-- inventory
111DROP TRIGGER _inventory_scan_update_bad_scan;
112DROP TRIGGER _inventory_scan_update_bad_inventory;
113DROP TRIGGER _inventory_changes_update_bad_inventory;
114DROP TRIGGER _inventory_changes_update_bad_category;
115DROP TRIGGER _inventory_changes_update_bad_address;
116-- traceroute
117DROP TRIGGER trace_update_bad_protocol;
118DROP TRIGGER hop_update_bad_trace;
119
120
121--
122-- Triggers for handling DELETE
123--
124
125-- scan
126DROP TRIGGER scan_type_bad_delete;
127DROP TRIGGER scanner_bad_delete;
128DROP TRIGGER scan_bad_delete;
129DROP TRIGGER scan2_bad_delete;
130DROP TRIGGER scan3_bad_delete;
131-- host
132DROP TRIGGER vendor_bad_delete;
133DROP TRIGGER address_bad_delete;
134DROP TRIGGER address2_bad_delete;
135DROP TRIGGER hostname_bad_delete;
136DROP TRIGGER host_state_bad_delete;
137DROP TRIGGER osgen_bad_delete;
138DROP TRIGGER osfamily_bad_delete;
139DROP TRIGGER osvendor_bad_delete;
140DROP TRIGGER ostype_bad_delete;
141DROP TRIGGER ostype2_bad_delete;
142DROP TRIGGER host_bad_delete;
143DROP TRIGGER host2_bad_delete;
144DROP TRIGGER host3_bad_delete;
145DROP TRIGGER host4_bad_delete;
146DROP TRIGGER host5_bad_delete;
147DROP TRIGGER host6_bad_delete;
148DROP TRIGGER host7_bad_delete;
149DROP TRIGGER host8_bad_delete;
150-- ports
151DROP TRIGGER service_name_bad_delete;
152DROP TRIGGER port_state_bad_delete;
153DROP TRIGGER port_state2_bad_delete;
154DROP TRIGGER port_state3_bad_delete;
155DROP TRIGGER protocol_bad_delete;
156DROP TRIGGER protocol2_bad_delete;
157DROP TRIGGER protocol3_bad_delete;
158DROP TRIGGER protocol4_bad_delete;
159DROP TRIGGER service_info_bad_delete;
160DROP TRIGGER port_bad_delete;
161-- inventory
162DROP TRIGGER inventory_bad_delete;
163DROP TRIGGER inventory2_bad_delete;
164DROP TRIGGER inventory_change_category_bad_delete;
165-- traceroute
166DROP TRIGGER trace_bad_delete;
167
Note: See TracBrowser for help on using the browser.