Contents

class CreateStructures < ActiveRecord::Migration
  def self.up
    create_table :structures do |t|
      t.string    :title, :null => false
      t.string    :slug, :null => false, :limit => 25
      t.integer   :kind, :limit => 1, :default => 0
      t.integer   :position, :limit => 2, :default => 0
      t.boolean   :is_visible, :default => true
      t.string    :redirect_url
      
      t.integer  "parent_id"
      t.integer  "lft",                          :default => 0
      t.integer  "rgt",                          :default => 0
      t.integer  "depth",                        :default => 0
      
      t.timestamps
    end
    
    add_index :structures, [:kind, :slug], :unique => true
    add_index :structures, :parent_id
    add_index :structures, [:lft, :rgt]
  end

  def self.down
    drop_table :structures
  end
end

Version data entries

18 entries across 18 versions & 1 rubygems

Version	Path
sunrise-cms-0.5.3	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.5.2	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.5.1	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.5.0	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.5.0.rc5	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.5.0.rc4	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.5.0.rc3	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.5.0.rc2	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.5.0.rc1	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.4.2	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.4.1	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.4.0	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.3.3	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.3.2	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.3.1	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.3.0	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.3.0.rc2	db/migrate/20111216144915_create_structures.rb
sunrise-cms-0.3.0.rc	db/migrate/20111216144915_create_structures.rb