mirror of
https://0xacab.org/sutty/sutty
synced 2024-11-24 12:56:21 +00:00
18 lines
532 B
Ruby
18 lines
532 B
Ruby
# frozen_string_literal: true
|
|
|
|
# Cambia los msec a datetime para poder agregar por tiempos
|
|
class AddCreateAtToAccessLogs < ActiveRecord::Migration[6.1]
|
|
def up
|
|
add_column :access_logs, :created_at, :datetime, precision: 6
|
|
|
|
create_trigger(compatibility: 1).on(:access_logs).before(:insert) do
|
|
'new.created_at := to_timestamp(new.msec)'
|
|
end
|
|
|
|
ActiveRecord::Base.connection.execute('update access_logs set created_at = to_timestamp(msec);')
|
|
end
|
|
|
|
def down
|
|
remove_column :access_logs, :created_at
|
|
end
|
|
end
|