diff --git a/db/migrate/006_create_roles.rb b/db/migrate/006_create_roles.rb new file mode 100644 --- /dev/null +++ b/db/migrate/006_create_roles.rb @@ -0,0 +1,19 @@ +class CreateRoles < ActiveRecord::Migration + def self.up + create_table :roles do |t| + t.column 'name', :string + end + + create_table :roles_users, :id => false do |t| + t.column 'role_id', :integer + t.column 'user_id', :integer + end + + add_index :roles_users, :user_id + end + + def self.down + drop_table :roles_users + drop_table :roles + end +end