075_add_new_feed_stuff.rb
1.23 KB
1
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
class AddNewFeedStuff < ActiveRecord::Migration
def self.up
add_column :blocks, :enabled, :boolean, :default => true
execute('update blocks set enabled = (1=1)')
add_column :blocks, :created_at, :datetime
add_column :blocks, :updated_at, :datetime
add_column :blocks, :fetched_at, :datetime
execute("update blocks set created_at = '2009-10-23 17:00', updated_at = '2009-10-23 17:00'")
add_index :blocks, :enabled
add_index :blocks, :fetched_at
add_index :blocks, :type
add_column :external_feeds, :error_message, :text
add_column :external_feeds, :update_errors, :integer, :default => 0
execute('update external_feeds set update_errors = 0')
add_index :external_feeds, :enabled
add_index :external_feeds, :fetched_at
end
def self.down
remove_index :blocks, :enabled
remove_index :blocks, :fetched_at
remove_index :blocks, :type
remove_column :blocks, :enabled
remove_column :blocks, :updated_at
remove_column :blocks, :created_at
remove_column :blocks, :fetched_at
remove_index :external_feeds, :enabled
remove_index :external_feeds, :fetched_at
remove_column :external_feeds, :error_message
remove_column :external_feeds, :update_errors
end
end