Class: CreateSkillTreeAclSystem

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/skill_tree/templates/create_skill_tree_acl_system.rb

Instance Method Summary collapse

Instance Method Details

#change ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
 
# File 'lib/generators/skill_tree/templates/create_skill_tree_acl_system.rb', line 2

def change
  create_table :acls do |t|
    t.string :name, null: false
    t.integer :version, null: false
  end
  add_index :acls, :name, unique: true

  create_table :roles do |t|
    t.string :name, null: false
  end
  add_index :roles, :name, unique: true

  create_table :permissions do |t|
    t.string :name, null: false
  end
  add_index :permissions, :name, unique: true

  create_table :acl_mappings do |t|
    t.references :acl, null: false
    t.references :role, null: false
    t.references :permission, null: true

    t.timestamps null: false
  end

  add_index :acl_mappings, [:acl_id, :role_id, :permission_id], unique: true

  create_table :user_roles do |t|
    t.references :user
    t.references :role, null: false
    t.references :resource, polymorphic: true

    t.timestamps null: false
  end
  add_index :user_roles, [:resource_type, :resource_id]
  # Only can't be admin of a resource multiple times
  add_index :user_roles, [:user_id, :role_id, :resource_type, :resource_id],
            unique: true, name: :user_roles_avoid_duplicate_roles

  create_table :acl_ownerships do |t|
    t.references :acl, null: false
    t.references :resource, polymorphic: true
  end
  # There can be only one-to-many relationship with a resource
  add_index :acl_ownerships, [:resource_type, :resource_id], unique: true
end