Add latest changes from gitlab-org/gitlab@15-6-stable-eev15.6.0-rc42

1 files changed, 24 insertions, 0 deletions

diff --git a/db/migrate/20221107184542_add_new_amount_used_to_ci_namespace_monthly_usages.rb b/db/migrate/20221107184542_add_new_amount_used_to_ci_namespace_monthly_usages.rb
new file mode 100644
index 00000000000..23a5a716164
--- /dev/null
+++ b/db/migrate/20221107184542_add_new_amount_used_to_ci_namespace_monthly_usages.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class AddNewAmountUsedToCiNamespaceMonthlyUsages < Gitlab::Database::Migration[2.0]
+  TABLE = :ci_namespace_monthly_usages
+  OLD_COLUMN = :amount_used
+  NEW_COLUMN = :new_amount_used
+  TRIGGER_NAME = 'sync_namespaces_amount_used_columns'
+
+  disable_ddl_transaction!
+
+  def up
+    check_trigger_permissions!(TABLE)
+
+    add_column(TABLE, NEW_COLUMN, :decimal, default: 0.0, precision: 18, scale: 4, null: false, if_not_exists: true)
+
+    install_rename_triggers(TABLE, OLD_COLUMN, NEW_COLUMN, trigger_name: TRIGGER_NAME)
+  end
+
+  def down
+    remove_rename_triggers(TABLE, TRIGGER_NAME)
+
+    remove_column(TABLE, NEW_COLUMN)
+  end
+end