mirror of
https://github.com/System-End/hackatime.git
synced 2026-04-19 19:55:16 +00:00
606bdaed01
* Drop unused heartbeat lookup tables and their FK columns Remove 8 abandoned normalization tables (heartbeat_branches, heartbeat_categories, heartbeat_editors, heartbeat_languages, heartbeat_machines, heartbeat_operating_systems, heartbeat_projects, heartbeat_user_agents) and their corresponding foreign key columns from the heartbeats table. None had models, associations, or any application code referencing them. * Remove migrations cancelling each other out
27 lines
1.6 KiB
Ruby
27 lines
1.6 KiB
Ruby
class DropUnusedHeartbeatLookupTables < ActiveRecord::Migration[8.1]
|
|
def change
|
|
remove_foreign_key :heartbeats, :heartbeat_branches, column: :branch_id, if_exists: true
|
|
remove_foreign_key :heartbeats, :heartbeat_categories, column: :category_id, if_exists: true
|
|
remove_foreign_key :heartbeats, :heartbeat_editors, column: :editor_id, if_exists: true
|
|
remove_foreign_key :heartbeats, :heartbeat_languages, column: :language_id, if_exists: true
|
|
remove_foreign_key :heartbeats, :heartbeat_machines, column: :machine_id, if_exists: true
|
|
remove_foreign_key :heartbeats, :heartbeat_operating_systems, column: :operating_system_id, if_exists: true
|
|
remove_foreign_key :heartbeats, :heartbeat_projects, column: :project_id, if_exists: true
|
|
|
|
remove_column :heartbeats, :branch_id, :bigint, if_exists: true
|
|
remove_column :heartbeats, :category_id, :bigint, if_exists: true
|
|
remove_column :heartbeats, :editor_id, :bigint, if_exists: true
|
|
remove_column :heartbeats, :language_id, :bigint, if_exists: true
|
|
remove_column :heartbeats, :machine_id, :bigint, if_exists: true
|
|
remove_column :heartbeats, :operating_system_id, :bigint, if_exists: true
|
|
remove_column :heartbeats, :project_id, :bigint, if_exists: true
|
|
|
|
drop_table :heartbeat_branches, if_exists: true
|
|
drop_table :heartbeat_categories, if_exists: true
|
|
drop_table :heartbeat_editors, if_exists: true
|
|
drop_table :heartbeat_languages, if_exists: true
|
|
drop_table :heartbeat_machines, if_exists: true
|
|
drop_table :heartbeat_operating_systems, if_exists: true
|
|
drop_table :heartbeat_projects, if_exists: true
|
|
end
|
|
end
|