Sha256: b79b5a96ad6dd4e1dba7c769cdbb705deb2a2df0edb68a3f29903f64e2902a45
Contents?: true
Size: 1.13 KB
Versions: 36
Compression:
Stored size: 1.13 KB
Contents
class MonarchyCreateMemberships < ActiveRecord::Migration
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
end
Version data entries
36 entries across 20 versions & 1 rubygems