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
|
# File 'lib/osa/migrations/00005_create_dns_blacklists.rb', line 5
def change
create_table :dns_blacklists do |t|
t.text :name, null: false
t.text :server, null: false
end
reversible do |dir|
dir.up do
execute " insert into dns_blacklists (name, server) values\n ('spamcop', 'bl.spamcop.net'),\n ('sbl', 'sbl.spamhaus.org'),\n ('psbl', 'psbl.surriel.org');\n SQL\n add_column :reports, :blacklist, :string, null: true\n execute <<~SQL\n update reports set blacklist = 'db' where blacklisted = true;\n SQL\n remove_column :reports, :blacklisted\n end\n\n dir.down do\n add_column :reports, :blacklisted, :boolean, default: false\n execute <<~SQL\n update reports set blacklisted = true where blacklist = 'db';\n SQL\n remove_column :reports, :blacklist\n end\n end\nend\n"
|