zeropaste: db/migrate/20180625074738_convert_timestamps_to_with_time

Update to use correct timestamp datatype Use sql dump instead of ruby because zone info would be lost otherwise.

comparison

equal deleted inserted replaced

-:07d6c6639adf
+:b1ef80121c79
+class ConvertTimestampsToWithTimeZone < ActiveRecord::Migration[5.2]
+COLUMNS = {
+ar_internal_metadata: [:created_at, :updated_at],
+pastes: [:created_at, :updated_at],
+}
+def up
+COLUMNS.each do |table, columns|
+change_table table do |t|
+columns.each do |column|
+t.change column, :timestamptz
+end
+end
+end
+end
+def down
+COLUMNS.each do |table, columns|
+change_table table do |t|
+columns.each do |column|
+t.change column, :timestamp
+end
+end
+end
+end
+end

Mercurial > zeropaste