Contents

# Adds 'created_at' and 'updated_at' columns to every primary table.
#
class AddTimestamps < ActiveRecord::Migration

	@@TABLES_NEEDING_RENAME = [:clients, :hosts, :notes, :refs, :services, :vulns, :wmap_requests]
	@@TABLES_NEEDING_CREATED_AT = [:wmap_targets]
	@@TABLES_NEEDING_UPDATED_AT = [:clients, :events, :hosts, :notes, :refs, :services, :vulns, :wmap_requests, :wmap_targets]

	def self.up
		@@TABLES_NEEDING_RENAME.each { |t| rename_column t, :created, :created_at }
		
		@@TABLES_NEEDING_CREATED_AT.each { |t| add_column t, :created_at, :datetime }

		@@TABLES_NEEDING_UPDATED_AT.each { |t| add_column t, :updated_at, :datetime }
	end

	def self.down
		@@TABLES_NEEDING_RENAME.each { |t| rename_column t, :created_at, :created }
		
		@@TABLES_NEEDING_CREATED_AT.each { |t| remove_column t, :created_at }

		@@TABLES_NEEDING_UPDATED_AT.each { |t| remove_column t, :updated_at }
	end
end

Version data entries

154 entries across 154 versions & 1 rubygems

Version	Path
metasploit_data_models-3.0.10	db/migrate/006_add_timestamps.rb
metasploit_data_models-3.0.9	db/migrate/006_add_timestamps.rb
metasploit_data_models-3.0.8	db/migrate/006_add_timestamps.rb
metasploit_data_models-3.0.7	db/migrate/006_add_timestamps.rb
metasploit_data_models-3.0.6	db/migrate/006_add_timestamps.rb
metasploit_data_models-3.0.5	db/migrate/006_add_timestamps.rb
metasploit_data_models-2.0.17	db/migrate/006_add_timestamps.rb
metasploit_data_models-3.0.4	db/migrate/006_add_timestamps.rb
metasploit_data_models-3.0.2	db/migrate/006_add_timestamps.rb
metasploit_data_models-3.0.1	db/migrate/006_add_timestamps.rb
metasploit_data_models-3.0.0	db/migrate/006_add_timestamps.rb
metasploit_data_models-2.0.16	db/migrate/006_add_timestamps.rb
metasploit_data_models-2.0.15	db/migrate/006_add_timestamps.rb
metasploit_data_models-2.0.14	db/migrate/006_add_timestamps.rb
metasploit_data_models-2.0.13	db/migrate/006_add_timestamps.rb
metasploit_data_models-2.0.12	db/migrate/006_add_timestamps.rb
metasploit_data_models-2.0.11	db/migrate/006_add_timestamps.rb
metasploit_data_models-2.0.10	db/migrate/006_add_timestamps.rb
metasploit_data_models-2.0.9	db/migrate/006_add_timestamps.rb
metasploit_data_models-2.0.8	db/migrate/006_add_timestamps.rb