Contents

# encoding: UTF-8

Sequel.migration do
  up do
    alter_table(:content) do
      add_column :hidden,  :boolean, :default => false
      # keeps track of the id of the parent item that is giving us our invisible status
      add_column :hidden_origin, :integer
      # a 'materialized path' for the complete content path
      add_column :content_path, String

      add_index :hidden
      add_index :content_path
    end
  end

  down do
    alter_table(:content) do
      drop_index :hidden
      drop_index :content_path
      drop_column :hidden
      drop_column :hidden_origin
      drop_column :content_path
    end
  end
end

Version data entries

18 entries across 18 versions & 1 rubygems

Version	Path
spontaneous-0.2.0.beta10	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.beta9	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.beta8	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.beta7	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.beta6	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.beta5	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.beta4	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.beta3	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.beta2	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.beta1	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.alpha7	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.alpha6	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.alpha5	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.alpha4	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.alpha3	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.alpha2	db/migrations/20110201133550_visibility.rb
spontaneous-0.2.0.alpha1	db/migrations/20110201133550_visibility.rb
spontaneous-0.1.0.alpha1	db/migrations/20110201133550_visibility.rb