diff --git a/db/migrate/20220519181644_fix_application_settings_column_default.rb b/db/migrate/20220519181644_fix_application_settings_column_default.rb new file mode 100644 index 0000000000000000000000000000000000000000..59b7415506b044a6dde46dd191fbd014884cf2ad --- /dev/null +++ b/db/migrate/20220519181644_fix_application_settings_column_default.rb @@ -0,0 +1,19 @@ +# frozen_string_literal: true + +class FixApplicationSettingsColumnDefault < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :application_settings, :polling_interval_multiplier, 1.0 + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519181739_fix_broadcast_messages_column_defaults.rb b/db/migrate/20220519181739_fix_broadcast_messages_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..c7af70678bfbd233b4738be53f3283507f38c01d --- /dev/null +++ b/db/migrate/20220519181739_fix_broadcast_messages_column_defaults.rb @@ -0,0 +1,20 @@ +# frozen_string_literal: true + +class FixBroadcastMessagesColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :broadcast_messages, :color, nil + change_column_default :broadcast_messages, :font, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519181800_fix_issues_column_defaults.rb b/db/migrate/20220519181800_fix_issues_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..2921bcaa303641c329ccc2ead35b9cbbe5c06d16 --- /dev/null +++ b/db/migrate/20220519181800_fix_issues_column_defaults.rb @@ -0,0 +1,19 @@ +# frozen_string_literal: true + +class FixIssuesColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :issues, :title, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182033_fix_keys_column_defaults.rb b/db/migrate/20220519182033_fix_keys_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..e04914f12ea5e5d0053a0fbf00c63fbf51c9e767 --- /dev/null +++ b/db/migrate/20220519182033_fix_keys_column_defaults.rb @@ -0,0 +1,21 @@ +# frozen_string_literal: true + +class FixKeysColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :keys, :title, nil + change_column_default :keys, :type, nil + change_column_default :keys, :fingerprint, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182047_fix_label_links_column_defaults.rb b/db/migrate/20220519182047_fix_label_links_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..68691e551f467cd9bd6725dfe4481a2d9db18e1c --- /dev/null +++ b/db/migrate/20220519182047_fix_label_links_column_defaults.rb @@ -0,0 +1,19 @@ +# frozen_string_literal: true + +class FixLabelLinksColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :label_links, :target_type, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182100_fix_labels_column_defaults.rb b/db/migrate/20220519182100_fix_labels_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..ebfcf378b07b496b11882ccc74800f4e47052596 --- /dev/null +++ b/db/migrate/20220519182100_fix_labels_column_defaults.rb @@ -0,0 +1,20 @@ +# frozen_string_literal: true + +class FixLabelsColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :labels, :title, nil + change_column_default :labels, :color, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182116_fix_members_column_default.rb b/db/migrate/20220519182116_fix_members_column_default.rb new file mode 100644 index 0000000000000000000000000000000000000000..e7c1bee1fc82f3f29611ad232b72b881a52b24e9 --- /dev/null +++ b/db/migrate/20220519182116_fix_members_column_default.rb @@ -0,0 +1,19 @@ +# frozen_string_literal: true + +class FixMembersColumnDefault < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :members, :type, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182135_fix_merge_request_diffs_column_defaults.rb b/db/migrate/20220519182135_fix_merge_request_diffs_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..626e9ea02d91a44cf006243a11d0c308b82a9ae0 --- /dev/null +++ b/db/migrate/20220519182135_fix_merge_request_diffs_column_defaults.rb @@ -0,0 +1,19 @@ +# frozen_string_literal: true + +class FixMergeRequestDiffsColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :merge_request_diffs, :state, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182153_fix_merge_request_column_default.rb b/db/migrate/20220519182153_fix_merge_request_column_default.rb new file mode 100644 index 0000000000000000000000000000000000000000..b91be7c07f4fd99d3a39ab90ffffc4b32ab353c7 --- /dev/null +++ b/db/migrate/20220519182153_fix_merge_request_column_default.rb @@ -0,0 +1,19 @@ +# frozen_string_literal: true + +class FixMergeRequestColumnDefault < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :merge_requests, :title, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182217_fix_milestones_column_default.rb b/db/migrate/20220519182217_fix_milestones_column_default.rb new file mode 100644 index 0000000000000000000000000000000000000000..4e2eab21f939b36cf77b1364d1035e9f3eaeaeee --- /dev/null +++ b/db/migrate/20220519182217_fix_milestones_column_default.rb @@ -0,0 +1,19 @@ +# frozen_string_literal: true + +class FixMilestonesColumnDefault < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :milestones, :state, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182242_fix_namespaces_column_defaults.rb b/db/migrate/20220519182242_fix_namespaces_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..e0eb550633b03f6c76d5a94965b5ee940b7f4937 --- /dev/null +++ b/db/migrate/20220519182242_fix_namespaces_column_defaults.rb @@ -0,0 +1,20 @@ +# frozen_string_literal: true + +class FixNamespacesColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :namespaces, :type, nil + change_column_default :namespaces, :avatar, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182258_fix_notes_column_defaults.rb b/db/migrate/20220519182258_fix_notes_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..ea756b5f6de3499aade4c24a7b5c85c973aaa944 --- /dev/null +++ b/db/migrate/20220519182258_fix_notes_column_defaults.rb @@ -0,0 +1,23 @@ +# frozen_string_literal: true + +class FixNotesColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :notes, :noteable_type, nil + change_column_default :notes, :attachment, nil + change_column_default :notes, :line_code, nil + change_column_default :notes, :commit_id, nil + change_column_default :notes, :system, false + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182315_fix_projects_column_defaults.rb b/db/migrate/20220519182315_fix_projects_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..e54cb2725d4c4e7beb776f7fd87b843e399de442 --- /dev/null +++ b/db/migrate/20220519182315_fix_projects_column_defaults.rb @@ -0,0 +1,22 @@ +# frozen_string_literal: true + +class FixProjectsColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :projects, :name, nil + change_column_default :projects, :path, nil + change_column_default :projects, :import_url, nil + change_column_default :projects, :archived, false + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182332_fix_integrations_column_defaults.rb b/db/migrate/20220519182332_fix_integrations_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..7b40734846a704b69ee686fa5c33736b993eef8f --- /dev/null +++ b/db/migrate/20220519182332_fix_integrations_column_defaults.rb @@ -0,0 +1,19 @@ +# frozen_string_literal: true + +class FixIntegrationsColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :integrations, :active, false + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182349_fix_snippets_column_defaults.rb b/db/migrate/20220519182349_fix_snippets_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..896fe1e0406b33bd75dcb97c77c923215b336e77 --- /dev/null +++ b/db/migrate/20220519182349_fix_snippets_column_defaults.rb @@ -0,0 +1,21 @@ +# frozen_string_literal: true + +class FixSnippetsColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :snippets, :title, nil + change_column_default :snippets, :file_name, nil + change_column_default :snippets, :type, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182407_fix_taggings_column_defaults.rb b/db/migrate/20220519182407_fix_taggings_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..d75e7a65e84ac7f54b19711ef48c059c7d8bf4ff --- /dev/null +++ b/db/migrate/20220519182407_fix_taggings_column_defaults.rb @@ -0,0 +1,21 @@ +# frozen_string_literal: true + +class FixTaggingsColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :taggings, :taggable_type, nil + change_column_default :taggings, :tagger_type, nil + change_column_default :taggings, :context, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182423_fix_tags_column_default.rb b/db/migrate/20220519182423_fix_tags_column_default.rb new file mode 100644 index 0000000000000000000000000000000000000000..a918dcdc65ceb6586b64a470747c633a5f100f55 --- /dev/null +++ b/db/migrate/20220519182423_fix_tags_column_default.rb @@ -0,0 +1,19 @@ +# frozen_string_literal: true + +class FixTagsColumnDefault < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :tags, :name, nil + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/migrate/20220519182438_fix_users_column_defaults.rb b/db/migrate/20220519182438_fix_users_column_defaults.rb new file mode 100644 index 0000000000000000000000000000000000000000..555a77ee7be5305fffddd69de54c6c096e54c96d --- /dev/null +++ b/db/migrate/20220519182438_fix_users_column_defaults.rb @@ -0,0 +1,31 @@ +# frozen_string_literal: true + +class FixUsersColumnDefaults < Gitlab::Database::Migration[2.0] + enable_lock_retries! + + def up + # This migration sets default column values where + # missing/incorrect for long running instances that migrated from MySQL database. + + change_column_default :users, :reset_password_token, nil + change_column_default :users, :current_sign_in_ip, nil + change_column_default :users, :last_sign_in_ip, nil + change_column_default :users, :name, nil + change_column_default :users, :admin, false + change_column_default :users, :username, nil + change_column_default :users, :can_create_group, true + change_column_default :users, :can_create_team, true + change_column_default :users, :state, nil + change_column_default :users, :avatar, nil + change_column_default :users, :confirmation_token, nil + change_column_default :users, :unconfirmed_email, nil + change_column_default :users, :hide_no_ssh_key, false + end + + def down + # no-op + + # Unable to revert because previous default column value + # is unknown/not consistent between GitLab instances. + end +end diff --git a/db/schema_migrations/20220519181644 b/db/schema_migrations/20220519181644 new file mode 100644 index 0000000000000000000000000000000000000000..1c0af5b4d062918190259e75aba8d9bb6649ba21 --- /dev/null +++ b/db/schema_migrations/20220519181644 @@ -0,0 +1 @@ +79715d34e196b08f2698a2e4c995d2d1e0daaf3cd9b99f0de97ca57931d72541 \ No newline at end of file diff --git a/db/schema_migrations/20220519181739 b/db/schema_migrations/20220519181739 new file mode 100644 index 0000000000000000000000000000000000000000..42bb555b20e5706a232fa26dcb228b0205b2bfaa --- /dev/null +++ b/db/schema_migrations/20220519181739 @@ -0,0 +1 @@ +472fe141f608d431b355225db3354c8075905b7d04a0815050535435b660f14e \ No newline at end of file diff --git a/db/schema_migrations/20220519181800 b/db/schema_migrations/20220519181800 new file mode 100644 index 0000000000000000000000000000000000000000..d5b31c33db651a6fae6ca457289258f59d00b49d --- /dev/null +++ b/db/schema_migrations/20220519181800 @@ -0,0 +1 @@ +63863df36629d61b0dd02016ec558d6deb68da0ddf331ca341f4689bd0cbef49 \ No newline at end of file diff --git a/db/schema_migrations/20220519182033 b/db/schema_migrations/20220519182033 new file mode 100644 index 0000000000000000000000000000000000000000..4e85038e97e88253b1fa85b91787d8ec0ce40273 --- /dev/null +++ b/db/schema_migrations/20220519182033 @@ -0,0 +1 @@ +0304e7c93988ddedd7ac6a4ce7fbfcdc93224019d5284cc8bf78255466b2829a \ No newline at end of file diff --git a/db/schema_migrations/20220519182047 b/db/schema_migrations/20220519182047 new file mode 100644 index 0000000000000000000000000000000000000000..731fc0632a6ae01139179ca721d848bf5078c192 --- /dev/null +++ b/db/schema_migrations/20220519182047 @@ -0,0 +1 @@ +a9fd8ae357d5a83a616939a55d7961a5b300884a4d856b8e8950b98bddb9f332 \ No newline at end of file diff --git a/db/schema_migrations/20220519182100 b/db/schema_migrations/20220519182100 new file mode 100644 index 0000000000000000000000000000000000000000..b28c7008be8c04f699be45dc604187b06dc18c80 --- /dev/null +++ b/db/schema_migrations/20220519182100 @@ -0,0 +1 @@ +54931683abcf8aa68bacf6fda0ce5337a19772556d25298ca1048f4ae3276a33 \ No newline at end of file diff --git a/db/schema_migrations/20220519182116 b/db/schema_migrations/20220519182116 new file mode 100644 index 0000000000000000000000000000000000000000..f78ec67b41a95d89153296e997fb40384cc3bb48 --- /dev/null +++ b/db/schema_migrations/20220519182116 @@ -0,0 +1 @@ +42514b0f77cadb590d633e09f6e9f615ad49300b2eb6e675155f6f583e331634 \ No newline at end of file diff --git a/db/schema_migrations/20220519182135 b/db/schema_migrations/20220519182135 new file mode 100644 index 0000000000000000000000000000000000000000..499a36b6be8f77603c3be49c06d81b094d1911c6 --- /dev/null +++ b/db/schema_migrations/20220519182135 @@ -0,0 +1 @@ +2f9eb7056b4f7b31df200e2b064f11e9bff37102f3ad82ea18299830df713a58 \ No newline at end of file diff --git a/db/schema_migrations/20220519182153 b/db/schema_migrations/20220519182153 new file mode 100644 index 0000000000000000000000000000000000000000..276f6acaa08da68a7d153fd85eb0271c50c814dc --- /dev/null +++ b/db/schema_migrations/20220519182153 @@ -0,0 +1 @@ +92c94c55fc7eab92f552d7b42210b9ef57edfdf8bd0c53610c42d4a7b4357a0c \ No newline at end of file diff --git a/db/schema_migrations/20220519182217 b/db/schema_migrations/20220519182217 new file mode 100644 index 0000000000000000000000000000000000000000..0af68f123a40edda861b085efa1c639aacc3bc8a --- /dev/null +++ b/db/schema_migrations/20220519182217 @@ -0,0 +1 @@ +c4fd039d456ed2e3bac68cb7a807d8f8e78507d9916f2482a9c5ced44cf8d181 \ No newline at end of file diff --git a/db/schema_migrations/20220519182242 b/db/schema_migrations/20220519182242 new file mode 100644 index 0000000000000000000000000000000000000000..26c6c758a9487e6e0215b4161c9c51316cdef3c6 --- /dev/null +++ b/db/schema_migrations/20220519182242 @@ -0,0 +1 @@ +9171b2546c90024072906a8aeba3f7bc8592cb55b085a7dfe40c1821bc2d6494 \ No newline at end of file diff --git a/db/schema_migrations/20220519182258 b/db/schema_migrations/20220519182258 new file mode 100644 index 0000000000000000000000000000000000000000..2f762f9f5859bee60f1e24ceeea05dec406c9211 --- /dev/null +++ b/db/schema_migrations/20220519182258 @@ -0,0 +1 @@ +9aedccebd649245adff2f3907b0afdfdceeabe100c6aa779790197c20fbd27ec \ No newline at end of file diff --git a/db/schema_migrations/20220519182315 b/db/schema_migrations/20220519182315 new file mode 100644 index 0000000000000000000000000000000000000000..d9316157cc246e8e8a3171c2c0868c7963188000 --- /dev/null +++ b/db/schema_migrations/20220519182315 @@ -0,0 +1 @@ +34fe9f732aa79f3e0c2c252024e02fb191009d2e11207eb7ee538abea1407045 \ No newline at end of file diff --git a/db/schema_migrations/20220519182332 b/db/schema_migrations/20220519182332 new file mode 100644 index 0000000000000000000000000000000000000000..8f434a96acd9d81d8e59d834488ea9ce2b4e3fa2 --- /dev/null +++ b/db/schema_migrations/20220519182332 @@ -0,0 +1 @@ +1d6249370910c72d55666f25f11910787d21b7b7eda5b610460ac9c91a6ac5f6 \ No newline at end of file diff --git a/db/schema_migrations/20220519182349 b/db/schema_migrations/20220519182349 new file mode 100644 index 0000000000000000000000000000000000000000..c0c57f0e3ce8d1823e61d9a0e543017c982b1c5c --- /dev/null +++ b/db/schema_migrations/20220519182349 @@ -0,0 +1 @@ +3ab761129f61b6689e847686aad193afddcc292dcfe50c199ad612d355d040db \ No newline at end of file diff --git a/db/schema_migrations/20220519182407 b/db/schema_migrations/20220519182407 new file mode 100644 index 0000000000000000000000000000000000000000..bdaf9e1cc5bc6025fef78d639b7fbdec4d3fd181 --- /dev/null +++ b/db/schema_migrations/20220519182407 @@ -0,0 +1 @@ +f912eff7eb6ec61762dc9c3ef91f0a4fd34b1564ab1e363d21c058c1ebbec599 \ No newline at end of file diff --git a/db/schema_migrations/20220519182423 b/db/schema_migrations/20220519182423 new file mode 100644 index 0000000000000000000000000000000000000000..0141330c1bf8b7b0f81dc1a11648b782187b1ab4 --- /dev/null +++ b/db/schema_migrations/20220519182423 @@ -0,0 +1 @@ +18dff92a775d7e70626548e205b04440302b184dbc47636eb2a252eb0108f371 \ No newline at end of file diff --git a/db/schema_migrations/20220519182438 b/db/schema_migrations/20220519182438 new file mode 100644 index 0000000000000000000000000000000000000000..7342dac104ab431b9aebae95832eb022766b71f2 --- /dev/null +++ b/db/schema_migrations/20220519182438 @@ -0,0 +1 @@ +8da83438dc4a6f426c54a35bb2bdc65d8f0a1c6b11a03a061f99ef3deaa3539b \ No newline at end of file