Posted By

viatropos on 02/19/10

Tagged

mysql
rails

Versions (?)

Last Edited at 02/19/10 08:22pm

Statistics

Viewed 1050 times

Favorited by 0 user(s)

Related snippets

Rails has_many through without join tables - Proposal

/ Published in: Rails

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

# acts_as_roleable
create_table :users, :force => true do |t|
  t.string :name
  # ...
end
 
# acts_as_roleable
create_table :groups, :force => true do |t|
  t.string :name
  # ...
end
 
create_table :memberships, :force => true do |t|
  t.integer :group_id
  t.integer :user_id
end
 
create_table :roles, :force => true do |t|
  t.string :name
  t.column :roleable_id, :integer
  t.column :roleable_type, :string
end
 
create_table :permissions, :force => true do |t|
  t.string :role_id
  t.string :name
  # ...
end