Contents

# FIXME: move this with 'node_query' into a plugins might be cleaner
# make sure there exists a link with NULL content and id == -1 (used in queries using query order sorting)
class ChangeDefaultLinkIdToZero < ActiveRecord::Migration
  def self.up
    Link.connection.execute "UPDATE #{Link.table_name} SET id = 0 WHERE id = -1"
    NodeQuery.insert_zero_link(Link)
  end

  def self.down
    Link.connection.execute "UPDATE #{Link.table_name} SET id = -1 WHERE id = 0"
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
zena-0.16.3	db/migrate/047_change_default_link_id_to_zero.rb
zena-0.16.2	db/migrate/047_change_default_link_id_to_zero.rb
zena-0.16.1	db/migrate/047_change_default_link_id_to_zero.rb
zena-0.16.0	db/migrate/047_change_default_link_id_to_zero.rb
zena-0.15.2	db/migrate/047_change_default_link_id_to_zero.rb
zena-0.15.1	db/migrate/047_change_default_link_id_to_zero.rb
zena-0.15.0	db/migrate/047_change_default_link_id_to_zero.rb