Revision 0f38d367
Added by Timo Goebel over 7 years ago
| db/migrate/20170118142654_add_auto_increment_to_bigint_ids.rb | ||
|---|---|---|
|
class AddAutoIncrementToBigintIds < ActiveRecord::Migration
|
||
|
def self.up
|
||
|
if ['mysql', 'mysql2'].include? ActiveRecord::Base.connection.instance_values['config'][:adapter]
|
||
|
change_column :logs, :id, 'SERIAL'
|
||
|
change_column :reports, :id, 'SERIAL'
|
||
|
change_column :fact_values, :id, 'SERIAL'
|
||
|
end
|
||
|
end
|
||
|
def self.down
|
||
|
if ['mysql', 'mysql2'].include? ActiveRecord::Base.connection.instance_values['config'][:adapter]
|
||
|
change_column :logs, :id, :bigint
|
||
|
change_column :reports, :id, :bigint
|
||
|
change_column :fact_values, :id, :bigint
|
||
|
end
|
||
|
end
|
||
|
end
|
||
Also available in: Unified diff
fixes #18130 - add autoincrement for bigint id columns