root/branch/umitweb-ng/share/umit/sql/sqlite-drop-tables.sql @ 4770

Revision 4770, 1.6 kB (checked in by rcarvalho, 4 years ago)

Merged revisions 4208-4214 via svnmerge from
http://svn.umitproject.org/svnroot/umit/trunk

........

r4208 | gpolo | 2009-02-27 15:54:02 -0300 (Sex, 27 Fev 2009) | 1 line


Fixed ticket #213. HOME under Windows is now set to the user's local appdata.

........

r4209 | gpolo | 2009-02-27 15:55:22 -0300 (Sex, 27 Fev 2009) | 1 line


Adjusted to work with win32com.shell imports.

........

r4210 | gpolo | 2009-02-27 15:58:49 -0300 (Sex, 27 Fev 2009) | 1 line


Fixed ticket #199: "Umit may hang while staring".

........

r4211 | gpolo | 2009-02-27 20:09:20 -0300 (Sex, 27 Fev 2009) | 1 line


Generate a service class string from the service path if given. This helps installing the service inside Umit in case umit_scheduler.py moves to somewhere else (like to bin/).

........

r4212 | gpolo | 2009-02-27 20:21:42 -0300 (Sex, 27 Fev 2009) | 1 line


Setting service path

........

r4213 | gpolo | 2009-02-28 18:17:47 -0300 (Sáb, 28 Fev 2009) | 1 line


Relayout

........

r4214 | gpolo | 2009-02-28 18:45:29 -0300 (Sáb, 28 Fev 2009) | 3 lines


Moved umitDB/sql to share/umit/sql, updated installers. This also fixes
ticket #220.

........

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 Tables
23-------------------
24
25-- scan
26DROP TABLE scan;
27DROP TABLE scaninfo;
28DROP TABLE scan_type;
29DROP TABLE scanner;
30-- host
31DROP TABLE host;
32DROP TABLE fingerprint_info;
33DROP TABLE osmatch;
34DROP TABLE osclass;
35DROP TABLE osgen;
36DROP TABLE osfamily;
37DROP TABLE osvendor;
38DROP TABLE ostype;
39DROP TABLE portused;
40DROP TABLE host_state;
41DROP TABLE address;
42DROP TABLE vendor;
43DROP TABLE hostname;
44DROP TABLE _host_hostname;
45DROP TABLE _host_address;
46DROP TABLE _host_port;
47-- ports
48DROP TABLE port;
49DROP TABLE extraports;
50DROP TABLE protocol;
51DROP TABLE service_info;
52DROP TABLE service_name;
53DROP TABLE port_state;
54-- inventory
55DROP TABLE inventory;
56DROP TABLE inventory_change_category;
57DROP TABLE _inventory_scan;
58DROP TABLE _inventory_changes;
59-- traceroute
60DROP TABLE trace;
61DROP TABLE hop;
62
Note: See TracBrowser for help on using the browser.