cirandas.net

 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