20130625024430_create_admin_roles.rb 710 B

1234567891011121314151617181920212223
  1. class CreateAdminRoles < ActiveRecord::Migration
  2. def change
  3. create_table :admin_roles do |t|
  4. t.string :name, :null => false
  5. t.text :description
  6. end
  7. create_table :admin_roles_admin_users do |t|
  8. t.integer :admin_role_id
  9. t.integer :admin_user_id
  10. end
  11. create_table :admin_permissions_admin_roles do |t|
  12. t.integer :admin_role_id
  13. t.integer :admin_permission_id
  14. end
  15. add_index :admin_roles_admin_users,
  16. [:admin_role_id, :admin_user_id],
  17. :name => "idx_admin_r_u_id"
  18. add_index :admin_permissions_admin_roles,
  19. [:admin_role_id, :admin_permission_id],
  20. :name => "idx_admin_roles_id"
  21. end
  22. end