Contents

# frozen_string_literal: true

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   :structure_type_id, limit: 1, default: 0
      t.integer   :position_type_id, 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, :structure_type_id
    add_index :structures, :position_type_id
    add_index :structures, :parent_id
    add_index :structures, [:lft, :rgt]
  end

  def self.down
    drop_table :structures
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
sunrise-cms-1.1.1	db/migrate/20111216144915_create_structures.rb
sunrise-cms-1.1.0	db/migrate/20111216144915_create_structures.rb