summaryrefslogtreecommitdiff
path: root/db/migrate/20210311120154_initialize_conversion_of_push_event_payloads_event_id_to_bigint.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20210311120154_initialize_conversion_of_push_event_payloads_event_id_to_bigint.rb')
-rw-r--r--db/migrate/20210311120154_initialize_conversion_of_push_event_payloads_event_id_to_bigint.rb21
1 files changed, 21 insertions, 0 deletions
diff --git a/db/migrate/20210311120154_initialize_conversion_of_push_event_payloads_event_id_to_bigint.rb b/db/migrate/20210311120154_initialize_conversion_of_push_event_payloads_event_id_to_bigint.rb
new file mode 100644
index 00000000000..9ce3b59e2dd
--- /dev/null
+++ b/db/migrate/20210311120154_initialize_conversion_of_push_event_payloads_event_id_to_bigint.rb
@@ -0,0 +1,21 @@
+# frozen_string_literal: true
+
+class InitializeConversionOfPushEventPayloadsEventIdToBigint < ActiveRecord::Migration[6.0]
+ include Gitlab::Database::MigrationHelpers
+
+ DOWNTIME = false
+
+ def up
+ # Foreign key that references events.id
+ # Also Primary key of the push_event_payloads table
+ initialize_conversion_of_integer_to_bigint :push_event_payloads, :event_id, primary_key: :event_id
+ end
+
+ def down
+ trigger_name = rename_trigger_name(:push_event_payloads, :event_id, :event_id_convert_to_bigint)
+
+ remove_rename_triggers_for_postgresql :push_event_payloads, trigger_name
+
+ remove_column :push_event_payloads, :event_id_convert_to_bigint
+ end
+end