X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/bf29550db840c97cafffbe1e836750bef6c7942d..b6c354b31b8e7963bbd384045cb72cd3a88c613e:/db/migrate/021_add_changesets.rb?ds=sidebyside diff --git a/db/migrate/021_add_changesets.rb b/db/migrate/021_add_changesets.rb index 772a5f20d..e0cf3904a 100644 --- a/db/migrate/021_add_changesets.rb +++ b/db/migrate/021_add_changesets.rb @@ -4,6 +4,7 @@ class AddChangesets < ActiveRecord::Migration def self.up create_table "changesets", innodb_table do |t| + t.column "id", :bigint_pk, :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 @@ -12,7 +13,6 @@ class AddChangesets < ActiveRecord::Migration t.column "min_lon", :integer, :null => true t.column "max_lon", :integer, :null => true end - add_column :changesets, :id, :bigint_pk create_table "changeset_tags", innodb_table do |t| t.column "id", :bigint, :limit => 64, :null => false @@ -28,7 +28,7 @@ class AddChangesets < ActiveRecord::Migration # 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 id, id, creation_time, 0 from users;" + "SELECT id, id, creation_time, false from users;" @@conv_user_tables.each { |tbl| rename_column tbl, :user_id, :changeset_id