# all the changesets will have the id of the user that made them.
# We need to generate a changeset for each user in the database
execute "INSERT INTO changesets (id, user_id, created_at, open)" +
- "SELECT user_id, user_id, creation_time, 0 from users;"
+ "SELECT id, id, creation_time, 0 from users;"
@@conv_user_tables.each { |tbl|
rename_column tbl, :user_id, :changeset_id
#foreign keys too
- add_foreign_key tbl, :changeset_id, [:id], :users
+ add_foreign_key tbl, [:changeset_id], :users, [:id]
}
end