Contents

class ExtendLabel < ActiveRecord::Migration

  FIELDS = [
    {"rev" => {:type => :integer, :options => {:default => 1}}},
    {"published_version_id" => {:type => :integer}},
    {"published_at" => {:type => :date}},
    {"locked_by" => {:type => :integer}},
    {"expired_at" => {:type => :date}},
    {"follow_up" => {:type => :date}},
    {"to_review" => {:type => :boolean}},
    {"rdf_updated_at" => {:type => :date}}
  ]

  def self.up
    FIELDS.each do |hsh|
      hsh.each do |column_name, hsh2|
        unless column_exists?(:labels, column_name)
          add_column(:labels, column_name, hsh2[:type], (hsh2[:options] || {}))
        end
      end
    end

    add_index :labels, "published_version_id", :name => "ix_labels_on_published_v" unless index_exists?(:labels, "published_version_id", :name => "ix_labels_on_published_v")

  end

  def self.down
    FIELDS.each do |hsh|
      hsh.each do |column_name, hsh2|
        if column_exists?(:labels, column_name)
          remove_column(:labels, column_name)
        end
      end
    end
  end

end

Version data entries

11 entries across 11 versions & 1 rubygems

Version	Path
iqvoc_skosxl-2.3.1	db/migrate/20110408121540_extend_label.rb
iqvoc_skosxl-2.3.0	db/migrate/20110408121540_extend_label.rb
iqvoc_skosxl-2.1.0	db/migrate/20110408121540_extend_label.rb
iqvoc_skosxl-2.0.2	db/migrate/20110408121540_extend_label.rb
iqvoc_skosxl-2.0.1	db/migrate/20110408121540_extend_label.rb
iqvoc_skosxl-2.0.0	db/migrate/20110408121540_extend_label.rb
iqvoc_skosxl-1.2.3	db/migrate/20110408121540_extend_label.rb
iqvoc_skosxl-1.2.2	db/migrate/20110408121540_extend_label.rb
iqvoc_skosxl-1.2.1	db/migrate/20110408121540_extend_label.rb
iqvoc_skosxl-1.2.0	db/migrate/20110408121540_extend_label.rb
iqvoc_skosxl-1.1.4	db/migrate/20110408121540_extend_label.rb