X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/7252ffa8207855229123ae466ca7d29e72f8a6a0..e598ee220f30bbe4b6033d087e25a8fee0bcebe2:/db/migrate/020_add_changesets.rb diff --git a/db/migrate/020_add_changesets.rb b/db/migrate/020_add_changesets.rb index 1c599de01..772a5f20d 100644 --- a/db/migrate/020_add_changesets.rb +++ b/db/migrate/020_add_changesets.rb @@ -4,7 +4,6 @@ class AddChangesets < ActiveRecord::Migration def self.up create_table "changesets", innodb_table do |t| - t.column "id", :bigint, :limit => 20, :null => false t.column "user_id", :bigint, :limit => 20, :null => false t.column "created_at", :datetime, :null => false t.column "open", :boolean, :null => false, :default => true @@ -13,11 +12,7 @@ class AddChangesets < ActiveRecord::Migration t.column "min_lon", :integer, :null => true t.column "max_lon", :integer, :null => true end - - add_primary_key "changesets", ["id"] - # FIXME add indexes? - - change_column "changesets", "id", :bigint, :limit => 20, :null => false, :options => "AUTO_INCREMENT" + add_column :changesets, :id, :bigint_pk create_table "changeset_tags", innodb_table do |t| t.column "id", :bigint, :limit => 64, :null => false @@ -38,7 +33,7 @@ class AddChangesets < ActiveRecord::Migration @@conv_user_tables.each { |tbl| rename_column tbl, :user_id, :changeset_id #foreign keys too - add_foreign_key tbl, [:changeset_id], :users + add_foreign_key tbl, [:changeset_id], :changesets, [:id] } end