class MonarchyCreateMemberships

Public Instance Methods

change() click to toggle source
# File lib/generators/templates/migrations/membership.rb, line 2
def change
  create_table :monarchy_members do |t|
    t.belongs_to :user
    t.belongs_to :hierarchy
    t.timestamps null: false
  end

  create_table :monarchy_roles do |t|
    t.string :name, null: false
    t.integer :level, default: 0, null: false
    t.integer :inherited_role_id
    t.boolean :inherited, default: false, null: false
    t.timestamps null: false
  end

  create_table :monarchy_members_roles do |t|
    t.belongs_to :role
    t.belongs_to :member
    t.timestamps null: false
  end

  add_index :monarchy_hierarchies, :parent_id
  add_index :monarchy_hierarchies, :resource_id

  add_index :monarchy_members, :hierarchy_id
  add_index :monarchy_members, :user_id

  add_index :monarchy_roles, :level
  add_index :monarchy_roles, :inherited
  add_index :monarchy_roles, :inherited_role_id
  add_index :monarchy_roles, :name, unique: true

  add_index :monarchy_members_roles, [:role_id, :member_id], unique: true
  add_index :monarchy_members_roles, :member_id
  add_index :monarchy_members_roles, :role_id
end