diff options
Diffstat (limited to 'db/migrate')
3 files changed, 43 insertions, 0 deletions
diff --git a/db/migrate/20220503035221_add_gitlab_schema_to_batched_background_migrations.rb b/db/migrate/20220503035221_add_gitlab_schema_to_batched_background_migrations.rb new file mode 100644 index 00000000000..eaebe979ff3 --- /dev/null +++ b/db/migrate/20220503035221_add_gitlab_schema_to_batched_background_migrations.rb @@ -0,0 +1,11 @@ +# frozen_string_literal: true + +class AddGitlabSchemaToBatchedBackgroundMigrations < Gitlab::Database::Migration[2.0] + # rubocop:disable Migration/AddLimitToTextColumns + # limit is added in 20220503035437_add_text_limit_to_batched_background_migrations_gitlab_schema + def change + add_column :batched_background_migrations, :gitlab_schema, :text, null: false, default: :gitlab_main + change_column_default(:batched_background_migrations, :gitlab_schema, from: :gitlab_main, to: nil) + end + # rubocop:enable Migration/AddLimitToTextColumns +end diff --git a/db/migrate/20220503035437_add_text_limit_to_batched_background_migrations_gitlab_schema.rb b/db/migrate/20220503035437_add_text_limit_to_batched_background_migrations_gitlab_schema.rb new file mode 100644 index 00000000000..d5629cd1b8d --- /dev/null +++ b/db/migrate/20220503035437_add_text_limit_to_batched_background_migrations_gitlab_schema.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class AddTextLimitToBatchedBackgroundMigrationsGitlabSchema < Gitlab::Database::Migration[2.0] + disable_ddl_transaction! + + def up + add_text_limit :batched_background_migrations, :gitlab_schema, 255 + end + + def down + remove_text_limit :batched_background_migrations, :gitlab_schema + end +end diff --git a/db/migrate/20220512020500_index_batched_migrations_on_gitlab_schema_and_configuration.rb b/db/migrate/20220512020500_index_batched_migrations_on_gitlab_schema_and_configuration.rb new file mode 100644 index 00000000000..077a60856cd --- /dev/null +++ b/db/migrate/20220512020500_index_batched_migrations_on_gitlab_schema_and_configuration.rb @@ -0,0 +1,19 @@ +# frozen_string_literal: true + +class IndexBatchedMigrationsOnGitlabSchemaAndConfiguration < Gitlab::Database::Migration[2.0] + disable_ddl_transaction! + + TABLE_NAME = :batched_background_migrations + INDEX_NAME = 'index_batched_migrations_on_gl_schema_and_unique_configuration' + + def up + add_concurrent_index TABLE_NAME, + %i[gitlab_schema job_class_name table_name column_name job_arguments], + unique: true, + name: INDEX_NAME + end + + def down + remove_concurrent_index_by_name TABLE_NAME, INDEX_NAME + end +end |