Class: AddInitialIndexes

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
db/migrate/20110730000001_add_initial_indexes.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
 
# File 'db/migrate/20110730000001_add_initial_indexes.rb', line 47

def self.down

	remove_index :hosts, :address
	remove_index :hosts, :address6
	remove_index :hosts, :name
	remove_index :hosts, :state
	remove_index :hosts, :os_name
	remove_index :hosts, :os_flavor
	remove_index :hosts, :purpose
	remove_index :hosts, :comments

	remove_index :services, :port
	remove_index :services, :proto
	remove_index :services, :state
	remove_index :services, :name
	remove_index :services, :info

	remove_index :notes, :ntype

	remove_index :vulns, :name
	remove_index :vulns, :info

	remove_index :refs, :name

	remove_index :web_sites, :vhost
	remove_index :web_sites, :comments
	remove_index :web_sites, :options

	remove_index :web_pages, :path
	remove_index :web_pages, :query

	remove_index :web_forms, :path

	remove_index :web_vulns, :path
	remove_index :web_vulns, :method
	remove_index :web_vulns, :name
end

.up ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
 
# File 'db/migrate/20110730000001_add_initial_indexes.rb', line 2

def self.up


	add_index :hosts, :address
	add_index :hosts, :address6
	add_index :hosts, :name
	add_index :hosts, :state
	add_index :hosts, :os_name
	add_index :hosts, :os_flavor
	add_index :hosts, :purpose

	# Removed (conditionally dropped in the next migration)
	# add_index :hosts, :comments

	add_index :services, :port
	add_index :services, :proto
	add_index :services, :state
	add_index :services, :name

	# Removed (conditionally dropped in the next migration)
	# add_index :services, :info

	add_index :notes, :ntype

	add_index :vulns, :name

	# Removed (conditionally dropped in the next migration)
	# add_index :vulns, :info

	add_index :refs, :name

	add_index :web_sites, :vhost
	add_index :web_sites, :comments
	add_index :web_sites, :options

	add_index :web_pages, :path
	add_index :web_pages, :query

	add_index :web_forms, :path

	add_index :web_vulns, :path
	add_index :web_vulns, :method
	add_index :web_vulns, :name
end