From 7dccf9fda6f30d8f4b0c5eaad9f6e2a1e67cd643 Mon Sep 17 00:00:00 2001
From: Jean-Philippe Lang <jp_lang@yahoo.fr>
Date: Sun, 10 May 2009 10:54:31 +0000
Subject: Allows multiple roles on the same project (#706). Prerequisite for
 user groups feature.

git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2726 e93f8b46-1217-0410-a6f0-8f06a7374b81
---
 db/migrate/20090503121501_create_member_roles.rb   | 12 ++++++++++++
 db/migrate/20090503121505_populate_member_roles.rb | 11 +++++++++++
 db/migrate/20090503121510_drop_members_role_id.rb  |  9 +++++++++
 3 files changed, 32 insertions(+)
 create mode 100644 db/migrate/20090503121501_create_member_roles.rb
 create mode 100644 db/migrate/20090503121505_populate_member_roles.rb
 create mode 100644 db/migrate/20090503121510_drop_members_role_id.rb

(limited to 'db')

diff --git a/db/migrate/20090503121501_create_member_roles.rb b/db/migrate/20090503121501_create_member_roles.rb
new file mode 100644
index 000000000..38519ea7c
--- /dev/null
+++ b/db/migrate/20090503121501_create_member_roles.rb
@@ -0,0 +1,12 @@
+class CreateMemberRoles < ActiveRecord::Migration
+  def self.up
+    create_table :member_roles do |t|
+      t.column :member_id, :integer, :null => false
+      t.column :role_id, :integer, :null => false
+    end
+  end
+
+  def self.down
+    drop_table :member_roles
+  end
+end
diff --git a/db/migrate/20090503121505_populate_member_roles.rb b/db/migrate/20090503121505_populate_member_roles.rb
new file mode 100644
index 000000000..8b7c98750
--- /dev/null
+++ b/db/migrate/20090503121505_populate_member_roles.rb
@@ -0,0 +1,11 @@
+class PopulateMemberRoles < ActiveRecord::Migration
+  def self.up
+    Member.find(:all).each do |member|
+      MemberRole.create!(:member_id => member.id, :role_id => member.role_id)
+    end
+  end
+
+  def self.down
+    MemberRole.delete_all
+  end
+end
diff --git a/db/migrate/20090503121510_drop_members_role_id.rb b/db/migrate/20090503121510_drop_members_role_id.rb
new file mode 100644
index 000000000..c28119910
--- /dev/null
+++ b/db/migrate/20090503121510_drop_members_role_id.rb
@@ -0,0 +1,9 @@
+class DropMembersRoleId < ActiveRecord::Migration
+  def self.up
+    remove_column :members, :role_id
+  end
+
+  def self.down
+    raise IrreversibleMigration
+  end
+end
-- 
cgit v1.2.3