X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/d7289a06deb1a644cbff7ba0606fe9e4c74830c7..c6592045c482d9086d5db6ebab87db49aa85cefa:/db/migrate/020_add_changesets.rb diff --git a/db/migrate/020_add_changesets.rb b/db/migrate/020_add_changesets.rb index 95a9bdbd6..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, [:id], :users + add_foreign_key tbl, [:changeset_id], :changesets, [:id] } end