X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/204fa8706495a4f78612d0e2a21f10b94649cc86..366a9e9097e6b8ca19cd3ecb2b08db1fbc0e2274:/db/migrate/010_diary_comments.rb?ds=sidebyside diff --git a/db/migrate/010_diary_comments.rb b/db/migrate/010_diary_comments.rb index 43019a938..ac0f5e23a 100644 --- a/db/migrate/010_diary_comments.rb +++ b/db/migrate/010_diary_comments.rb @@ -1,16 +1,17 @@ +require "migrate" + class DiaryComments < ActiveRecord::Migration def self.up - create_table "diary_comments", myisam_table do |t| - t.column "id", :bigint_pk, :null => false - t.column "diary_entry_id", :bigint, :limit => 20, :null => false - t.column "user_id", :bigint, :limit => 20, :null => false - t.column "body", :text, :null => false - t.column "created_at", :datetime, :null => false - t.column "updated_at", :datetime, :null => false + create_table "diary_comments", :id => false do |t| + t.column "id", :bigserial, :primary_key => true, :null => false + t.column "diary_entry_id", :bigint, :null => false + t.column "user_id", :bigint, :null => false + t.column "body", :text, :null => false + t.column "created_at", :datetime, :null => false + t.column "updated_at", :datetime, :null => false end - add_index "diary_comments", ["diary_entry_id", "id"], :name => "diary_comments_entry_id_idx", :unique => true - + add_index "diary_comments", %w[diary_entry_id id], :name => "diary_comments_entry_id_idx", :unique => true end def self.down