018_create_groups.rb in backlog-0.10.0

- old
+ new

@@ -3,11 +3,11 @@
     create_table :parties do |t|
       t.column :type, :string
     end
     
     create_table :groups, :primary_key => :party_id do |t|
-      t.string :name, :null => false
+      t.column :name, :string, :null => false
     end
     
     rename_column :users, :id, :party_id
     
     execute "INSERT INTO parties (id, type) SELECT party_id, 'User' FROM users"
@@ -15,12 +15,12 @@
       ActiveRecord::Base.connection.execute "select setval('parties_id_seq', (select max(id) from parties));"
     end
     add_foreign_key :users, :party_id, :parties, :id
     
     create_table :groups_users, :id => false do |t|
-      t.integer :group_id, :null => false, :references => nil
-      t.integer :user_id, :null => false, :references => nil
+      t.column :group_id, :integer, :null => false, :references => nil
+      t.column :user_id, :integer, :null => false, :references => nil
     end
     
     add_foreign_key :groups_users, :group_id, :groups, :party_id
     add_foreign_key :groups_users, :user_id, :users, :party_id
     
@@ -63,15 +63,10 @@
     
     remove_column :tasks, :backlog_id
     remove_column :periods, :party_id
     drop_table :groups_users
 
-p User.foreign_keys
-puts
-p User.foreign_keys.select {|fk| fk.references_table_name == 'parties'}
-puts
-
     User.foreign_keys.select {|fk| fk.references_table_name == 'parties'}.each do |fk|
       remove_foreign_key :users, fk.name
     end
     
     rename_column :users, :party_id, :id
@@ -120,6 +115,5 @@
   end
 EOF
     
   end
 end
-