Sha256: 0a931b448041c155a214bbdb7844fced338258d5f9c173668085628e880d5e9b

Contents?: true

Size: 635 Bytes

Versions: 18

Compression:

Stored size: 635 Bytes

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