diff --git a/db/post_migrate/20250728022816_abuse_report_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728022816_abuse_report_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..4e3dd3271f03a6be9551c1d15156186edfea8937 --- /dev/null +++ b/db/post_migrate/20250728022816_abuse_report_uploads_sharding_keys_not_null.rb @@ -0,0 +1,24 @@ +# frozen_string_literal: true + +class AbuseReportUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + TABLE_NAME = "abuse_report_uploads".freeze + COLUMNS = %w[project_id namespace_id organization_id].freeze + + def up + add_check_constraint( + TABLE_NAME, + "num_nonnulls(#{COLUMNS.join(', ')}) = 0", + check_constraint_name(TABLE_NAME, COLUMNS.join('_'), 'sharding_keys_null') + ) + end + + def down + remove_check_constraint( + TABLE_NAME, + check_constraint_name(TABLE_NAME, COLUMNS.join('_'), 'sharding_keys_null') + ) + end +end diff --git a/db/post_migrate/20250728023316_achievement_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728023316_achievement_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..889cb2ff9cfe4c2732c28cbe6816d47d8b7e275d --- /dev/null +++ b/db/post_migrate/20250728023316_achievement_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class AchievementUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :achievement_uploads, :namespace_id + end + + def down + remove_not_null_constraint :achievement_uploads, :namespace_id + end +end diff --git a/db/post_migrate/20250728023816_ai_vectorizable_file_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728023816_ai_vectorizable_file_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..3daf4e5329ddf0fe5a5f6840678d3972b147c2dc --- /dev/null +++ b/db/post_migrate/20250728023816_ai_vectorizable_file_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class AiVectorizableFileUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :ai_vectorizable_file_uploads, :project_id + end + + def down + remove_not_null_constraint :ai_vectorizable_file_uploads, :project_id + end +end diff --git a/db/post_migrate/20250728024316_alert_management_alert_metric_image_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728024316_alert_management_alert_metric_image_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..74de005697be2982fe786cb8629d6c21d28cd5b6 --- /dev/null +++ b/db/post_migrate/20250728024316_alert_management_alert_metric_image_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class AlertManagementAlertMetricImageUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :alert_management_alert_metric_image_uploads, :project_id + end + + def down + remove_not_null_constraint :alert_management_alert_metric_image_uploads, :project_id + end +end diff --git a/db/post_migrate/20250728024816_appearance_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728024816_appearance_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..3bbad5f933617118a8c7c6f851b80da170c20671 --- /dev/null +++ b/db/post_migrate/20250728024816_appearance_uploads_sharding_keys_not_null.rb @@ -0,0 +1,24 @@ +# frozen_string_literal: true + +class AppearanceUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + TABLE_NAME = "appearance_uploads".freeze + COLUMNS = %w[project_id namespace_id organization_id].freeze + + def up + add_check_constraint( + TABLE_NAME, + "num_nonnulls(#{COLUMNS.join(', ')}) = 0", + check_constraint_name(TABLE_NAME, COLUMNS.join('_'), 'sharding_keys_null') + ) + end + + def down + remove_check_constraint( + TABLE_NAME, + check_constraint_name(TABLE_NAME, COLUMNS.join('_'), 'sharding_keys_null') + ) + end +end diff --git a/db/post_migrate/20250728025316_bulk_import_export_upload_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728025316_bulk_import_export_upload_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..de4daa2f9f8cab3bd3c3aeb92b394f21d453881a --- /dev/null +++ b/db/post_migrate/20250728025316_bulk_import_export_upload_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class BulkImportExportUploadUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + # add_multi_column_not_null_constraint(:bulk_import_export_upload_uploads, :namespace_id, :organization_id, :project_id) + end + + def down + # remove_multi_column_not_null_constraint(:bulk_import_export_upload_uploads, :namespace_id, :organization_id, :project_id) + end +end diff --git a/db/post_migrate/20250728025816_dependency_list_export_part_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728025816_dependency_list_export_part_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..5424634afb516909be350540bebdd743bcf22b33 --- /dev/null +++ b/db/post_migrate/20250728025816_dependency_list_export_part_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class DependencyListExportPartUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :dependency_list_export_part_uploads, :organization_id + end + + def down + remove_not_null_constraint :dependency_list_export_part_uploads, :organization_id + end +end diff --git a/db/post_migrate/20250728030316_dependency_list_export_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728030316_dependency_list_export_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..2e85c5c61a212c573eb25ca1f8699325cdd41374 --- /dev/null +++ b/db/post_migrate/20250728030316_dependency_list_export_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class DependencyListExportUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_multi_column_not_null_constraint(:dependency_list_export_uploads, :namespace_id, :organization_id, :project_id) + end + + def down + remove_multi_column_not_null_constraint(:dependency_list_export_uploads, :namespace_id, :organization_id, :project_id) + end +end diff --git a/db/post_migrate/20250728030816_design_management_action_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728030816_design_management_action_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..65e1391c320aad0faf6c5586810e8e5e55cc60ce --- /dev/null +++ b/db/post_migrate/20250728030816_design_management_action_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class DesignManagementActionUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :design_management_action_uploads, :namespace_id + end + + def down + remove_not_null_constraint :design_management_action_uploads, :namespace_id + end +end diff --git a/db/post_migrate/20250728031316_import_export_upload_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728031316_import_export_upload_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..fabcffb8cfa03f886c3b4a7ec4457f43cfc15f66 --- /dev/null +++ b/db/post_migrate/20250728031316_import_export_upload_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class ImportExportUploadUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_multi_column_not_null_constraint(:import_export_upload_uploads, :namespace_id, :organization_id, :project_id) + end + + def down + remove_multi_column_not_null_constraint(:import_export_upload_uploads, :namespace_id, :organization_id, :project_id) + end +end diff --git a/db/post_migrate/20250728031816_issuable_metric_image_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728031816_issuable_metric_image_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..2d13606f9bc92ce8565f4393097b8991dbed2e74 --- /dev/null +++ b/db/post_migrate/20250728031816_issuable_metric_image_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class IssuableMetricImageUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + # add_not_null_constraint :issuable_metric_image_uploads, :namespace_id + end + + def down + # remove_not_null_constraint :issuable_metric_image_uploads, :namespace_id + end +end diff --git a/db/post_migrate/20250728032316_namespace_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728032316_namespace_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..6d7056c874cbcaefd3af9a542d401eb22a9debe3 --- /dev/null +++ b/db/post_migrate/20250728032316_namespace_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class NamespaceUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :namespace_uploads, :namespace_id + end + + def down + remove_not_null_constraint :namespace_uploads, :namespace_id + end +end diff --git a/db/post_migrate/20250728032816_organization_detail_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728032816_organization_detail_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..0c746fa35379ddb72a68a9ad8a8693663e1e15a4 --- /dev/null +++ b/db/post_migrate/20250728032816_organization_detail_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class OrganizationDetailUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :organization_detail_uploads, :organization_id + end + + def down + remove_not_null_constraint :organization_detail_uploads, :organization_id + end +end diff --git a/db/post_migrate/20250728033316_project_import_export_relation_export_upload_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728033316_project_import_export_relation_export_upload_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..a48114253b9ea8c1263208452855ecbcc87e867d --- /dev/null +++ b/db/post_migrate/20250728033316_project_import_export_relation_export_upload_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class ProjectImportExportRelationExportUploadUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + # add_not_null_constraint :project_import_export_relation_export_upload_uploads, :project_id + end + + def down + # remove_not_null_constraint :project_import_export_relation_export_upload_uploads, :project_id + end +end diff --git a/db/post_migrate/20250728033816_project_topic_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728033816_project_topic_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..e895e620a2fd5f2ceec317ff4073388120210962 --- /dev/null +++ b/db/post_migrate/20250728033816_project_topic_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class ProjectTopicUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :project_topic_uploads, :organization_id + end + + def down + remove_not_null_constraint :project_topic_uploads, :organization_id + end +end diff --git a/db/post_migrate/20250728034316_project_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728034316_project_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..63cd848a3c0d40bb17418dcd465f51e824a46114 --- /dev/null +++ b/db/post_migrate/20250728034316_project_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class ProjectUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + # add_not_null_constraint :project_uploads, :project_id + end + + def down + # remove_not_null_constraint :project_uploads, :project_id + end +end diff --git a/db/post_migrate/20250728034816_snippet_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728034816_snippet_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..b66f489700d8b9a0fb38620f442aedcd03e28a3e --- /dev/null +++ b/db/post_migrate/20250728034816_snippet_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class SnippetUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :snippet_uploads, :organization_id + end + + def down + remove_not_null_constraint :snippet_uploads, :organization_id + end +end diff --git a/db/post_migrate/20250728035316_user_permission_export_upload_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728035316_user_permission_export_upload_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..e58ca599b4c8b5ab95333abbedbef54950450232 --- /dev/null +++ b/db/post_migrate/20250728035316_user_permission_export_upload_uploads_sharding_keys_not_null.rb @@ -0,0 +1,25 @@ +# frozen_string_literal: true + +class UserPermissionExportUploadUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + TABLE_NAME = "user_permission_export_upload_uploads".freeze + COLUMNS = %w[project_id namespace_id organization_id].freeze + + def up + add_check_constraint( + TABLE_NAME, + "num_nonnulls(#{COLUMNS.join(', ')}) = 0", + check_constraint_name(TABLE_NAME, COLUMNS.join('_'), 'sharding_keys_null') + ) + end + + def down + remove_check_constraint( + TABLE_NAME, + check_constraint_name(TABLE_NAME, COLUMNS.join('_'), 'sharding_keys_null') + ) + end +end + diff --git a/db/post_migrate/20250728040316_vulnerability_archive_export_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728040316_vulnerability_archive_export_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..f19eb760e7a94457508b81d890287ee1a7d7f655 --- /dev/null +++ b/db/post_migrate/20250728040316_vulnerability_archive_export_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class VulnerabilityArchiveExportUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :vulnerability_archive_export_uploads, :project_id + end + + def down + remove_not_null_constraint :vulnerability_archive_export_uploads, :project_id + end +end diff --git a/db/post_migrate/20250728040816_vulnerability_export_part_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728040816_vulnerability_export_part_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..6c5c3fc6330729a98dc29d7be28228764d33c6b9 --- /dev/null +++ b/db/post_migrate/20250728040816_vulnerability_export_part_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class VulnerabilityExportPartUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :vulnerability_export_part_uploads, :organization_id + end + + def down + remove_not_null_constraint :vulnerability_export_part_uploads, :organization_id + end +end diff --git a/db/post_migrate/20250728041316_vulnerability_export_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728041316_vulnerability_export_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..8d52d8788e7df0ded20b4a3bdaf20f905b91ba44 --- /dev/null +++ b/db/post_migrate/20250728041316_vulnerability_export_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class VulnerabilityExportUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :vulnerability_export_uploads, :organization_id + end + + def down + remove_not_null_constraint :vulnerability_export_uploads, :organization_id + end +end diff --git a/db/post_migrate/20250728041816_vulnerability_remediation_uploads_sharding_keys_not_null.rb b/db/post_migrate/20250728041816_vulnerability_remediation_uploads_sharding_keys_not_null.rb new file mode 100644 index 0000000000000000000000000000000000000000..1a052bd2b1a2ca04f7812e58643d32532d558d33 --- /dev/null +++ b/db/post_migrate/20250728041816_vulnerability_remediation_uploads_sharding_keys_not_null.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class VulnerabilityRemediationUploadsShardingKeysNotNull < Gitlab::Database::Migration[2.3] + milestone '18.3' + disable_ddl_transaction! + + def up + add_not_null_constraint :vulnerability_remediation_uploads, :project_id + end + + def down + remove_not_null_constraint :vulnerability_remediation_uploads, :project_id + end +end diff --git a/db/schema_migrations/20250728022816 b/db/schema_migrations/20250728022816 new file mode 100644 index 0000000000000000000000000000000000000000..06cec10c6d20a9684f154399a0b750bb8de57055 --- /dev/null +++ b/db/schema_migrations/20250728022816 @@ -0,0 +1 @@ +1d831625edbef648c98327e745f2b1bbd8e972acc78625d3fcdeeacf7176d76f \ No newline at end of file diff --git a/db/schema_migrations/20250728023316 b/db/schema_migrations/20250728023316 new file mode 100644 index 0000000000000000000000000000000000000000..429ebf9b67851147077242254e9e32789405d555 --- /dev/null +++ b/db/schema_migrations/20250728023316 @@ -0,0 +1 @@ +b3c5cc03be3ccde6d24d56c2ec5d56cf2011230b4aa3ec9d179d505a902054cb \ No newline at end of file diff --git a/db/schema_migrations/20250728023816 b/db/schema_migrations/20250728023816 new file mode 100644 index 0000000000000000000000000000000000000000..b2a0944b519f9e97a844ddb9e55c6c9a6f64f472 --- /dev/null +++ b/db/schema_migrations/20250728023816 @@ -0,0 +1 @@ +2ed878ea0ff5de8336cf630e4da08c83ddafa43b0f8ad27e617cfc7bb26203ed \ No newline at end of file diff --git a/db/schema_migrations/20250728024316 b/db/schema_migrations/20250728024316 new file mode 100644 index 0000000000000000000000000000000000000000..c6ee6f7f0d30cd2bec6436bf3f3500830cac63c6 --- /dev/null +++ b/db/schema_migrations/20250728024316 @@ -0,0 +1 @@ +a0092b1dbb3db4a84c2552b18c5acbec1859986cd2a350ed0a9996deb7378023 \ No newline at end of file diff --git a/db/schema_migrations/20250728024816 b/db/schema_migrations/20250728024816 new file mode 100644 index 0000000000000000000000000000000000000000..429f9391171566d5330c4f413cccff385402586b --- /dev/null +++ b/db/schema_migrations/20250728024816 @@ -0,0 +1 @@ +a915c1be1a78ca3372fa3e297b22fb39cf78292f7a5da871e75327502813eaec \ No newline at end of file diff --git a/db/schema_migrations/20250728025316 b/db/schema_migrations/20250728025316 new file mode 100644 index 0000000000000000000000000000000000000000..a6e9b80f93658ffa1c50a0fdc4d28280fc02bd2d --- /dev/null +++ b/db/schema_migrations/20250728025316 @@ -0,0 +1 @@ +65dd41120573058f7c4ec86fd8d397a9f0bd86887c676bd9ad3e5105fa72512d \ No newline at end of file diff --git a/db/schema_migrations/20250728025816 b/db/schema_migrations/20250728025816 new file mode 100644 index 0000000000000000000000000000000000000000..26daa8bd9621a146e37f21e1d70b4796f9274795 --- /dev/null +++ b/db/schema_migrations/20250728025816 @@ -0,0 +1 @@ +87458a99665c8c4b8fa0117eb27848dc5148b4a2caa719a35195625f44d3b91b \ No newline at end of file diff --git a/db/schema_migrations/20250728030316 b/db/schema_migrations/20250728030316 new file mode 100644 index 0000000000000000000000000000000000000000..7425dbb35c35a16eaa243c8083fe98b10f53740f --- /dev/null +++ b/db/schema_migrations/20250728030316 @@ -0,0 +1 @@ +819a0703377749c9947458d6106f63c57ce844fd59fa42370ce0016c54fc9cf2 \ No newline at end of file diff --git a/db/schema_migrations/20250728030816 b/db/schema_migrations/20250728030816 new file mode 100644 index 0000000000000000000000000000000000000000..44c577aabb00709e385b5083d7714b8821a884a2 --- /dev/null +++ b/db/schema_migrations/20250728030816 @@ -0,0 +1 @@ +9f262287264e3df7d40c6aa179b768a69f4bab620d03c4d1cd384ca3ab4205f2 \ No newline at end of file diff --git a/db/schema_migrations/20250728031316 b/db/schema_migrations/20250728031316 new file mode 100644 index 0000000000000000000000000000000000000000..9216f4d90bbe80c24755bc213945501892445162 --- /dev/null +++ b/db/schema_migrations/20250728031316 @@ -0,0 +1 @@ +df5a622580f1bae707fdf46bf43fb761ab0f3de6b584caee2923771f73ec64a6 \ No newline at end of file diff --git a/db/schema_migrations/20250728031816 b/db/schema_migrations/20250728031816 new file mode 100644 index 0000000000000000000000000000000000000000..1294c62a376fe2405aa9f1e32239e29ddf84d1fb --- /dev/null +++ b/db/schema_migrations/20250728031816 @@ -0,0 +1 @@ +d770729f31a6c6558be6a6c08626869005021cf82f7274d1280ff3b885aa93c3 \ No newline at end of file diff --git a/db/schema_migrations/20250728032316 b/db/schema_migrations/20250728032316 new file mode 100644 index 0000000000000000000000000000000000000000..749e9a2739353491efc2e7451ea84f5eefeebe4f --- /dev/null +++ b/db/schema_migrations/20250728032316 @@ -0,0 +1 @@ +52809edcb49cfae73a9e5b1f3aeb122db633bbcb5fd24703ea17a4dce7c04cd9 \ No newline at end of file diff --git a/db/schema_migrations/20250728032816 b/db/schema_migrations/20250728032816 new file mode 100644 index 0000000000000000000000000000000000000000..e3c8198e1cff5a271cba844942767d26b27498cf --- /dev/null +++ b/db/schema_migrations/20250728032816 @@ -0,0 +1 @@ +6c5588e2406abb93fcca7b5b384bf5c81ae5136556fd70d88f1a6d5c25be9a3a \ No newline at end of file diff --git a/db/schema_migrations/20250728033316 b/db/schema_migrations/20250728033316 new file mode 100644 index 0000000000000000000000000000000000000000..b5d649348adbd597d734921f22b6aec220e580e7 --- /dev/null +++ b/db/schema_migrations/20250728033316 @@ -0,0 +1 @@ +cac3d6fbd8962d0d26cc8b7da1b7cbaa5a4b2b63e2bbad2d06193ad27bb695ce \ No newline at end of file diff --git a/db/schema_migrations/20250728033816 b/db/schema_migrations/20250728033816 new file mode 100644 index 0000000000000000000000000000000000000000..b7f67624ee0274443d28ce8ba72273d4df43ce81 --- /dev/null +++ b/db/schema_migrations/20250728033816 @@ -0,0 +1 @@ +563b1d049e76c5413b3fcc2eca671d10fce61ed6d61529f8c0fe2049916ca7ea \ No newline at end of file diff --git a/db/schema_migrations/20250728034316 b/db/schema_migrations/20250728034316 new file mode 100644 index 0000000000000000000000000000000000000000..eaf7d2056206b97fb29627aab0b2beb003c30213 --- /dev/null +++ b/db/schema_migrations/20250728034316 @@ -0,0 +1 @@ +2e054340570195aff2ad022e04ced491b436951053e6ef518efe0284af3495b4 \ No newline at end of file diff --git a/db/schema_migrations/20250728034816 b/db/schema_migrations/20250728034816 new file mode 100644 index 0000000000000000000000000000000000000000..88789024901c2dd398e5c85c3d1d8dc898fa875a --- /dev/null +++ b/db/schema_migrations/20250728034816 @@ -0,0 +1 @@ +a7c29282a1c68d9b68af3beaee3e780d78204236ed25700de4934fd3f7ed8cb7 \ No newline at end of file diff --git a/db/schema_migrations/20250728035316 b/db/schema_migrations/20250728035316 new file mode 100644 index 0000000000000000000000000000000000000000..24280b3c8ab8a0e3e4d76d77efd7508e5ad31507 --- /dev/null +++ b/db/schema_migrations/20250728035316 @@ -0,0 +1 @@ +b40e9b5dfb212d3c74689544b8ea965b0834e7654c356d7c7c748b64fa5d05d2 \ No newline at end of file diff --git a/db/schema_migrations/20250728040316 b/db/schema_migrations/20250728040316 new file mode 100644 index 0000000000000000000000000000000000000000..6c18deabad8ab3c60a2b7960664c8246dc34fcb2 --- /dev/null +++ b/db/schema_migrations/20250728040316 @@ -0,0 +1 @@ +dc95d7521c5680d47f3881a3b8a5fb65fdebc07fd6bf404ab414f31fc3ee5255 \ No newline at end of file diff --git a/db/schema_migrations/20250728040816 b/db/schema_migrations/20250728040816 new file mode 100644 index 0000000000000000000000000000000000000000..356aa4e45acd3b18fd9afe953bdeafa4eda6c973 --- /dev/null +++ b/db/schema_migrations/20250728040816 @@ -0,0 +1 @@ +999b353efb74301c72ae9d23f06180fd0c16f57a7ce2ceb15abd9b577241fb19 \ No newline at end of file diff --git a/db/schema_migrations/20250728041316 b/db/schema_migrations/20250728041316 new file mode 100644 index 0000000000000000000000000000000000000000..ba877fb728cad33360424591524b8c707496b876 --- /dev/null +++ b/db/schema_migrations/20250728041316 @@ -0,0 +1 @@ +ed09cd9234a8ff978afa727938780bef22ef70661b981c1e7993e015b42749b1 \ No newline at end of file diff --git a/db/schema_migrations/20250728041816 b/db/schema_migrations/20250728041816 new file mode 100644 index 0000000000000000000000000000000000000000..2cfc13fd51f91160b964e6d58300784df3799fc7 --- /dev/null +++ b/db/schema_migrations/20250728041816 @@ -0,0 +1 @@ +f0a90500848d2d838c1cd4f41aac5b47a93cfddc5ecc091f85f519e5278e70ae \ No newline at end of file diff --git a/db/structure.sql b/db/structure.sql index 531c7ca2bca335ffc91719bcf666aab95ff81c3f..5c3a3143ecdeb03b31da67018462a522ed6e6cf8 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -7954,6 +7954,7 @@ CREATE TABLE abuse_report_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_8496b14ef4 CHECK ((num_nonnulls(project_id, namespace_id, organization_id) = 0)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -8052,6 +8053,7 @@ CREATE TABLE achievement_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_9dac0178ee CHECK ((namespace_id IS NOT NULL)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -8632,6 +8634,7 @@ CREATE TABLE ai_vectorizable_file_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_73db12226b CHECK ((project_id IS NOT NULL)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -8690,6 +8693,7 @@ CREATE TABLE alert_management_alert_metric_image_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_49e9003aa6 CHECK ((project_id IS NOT NULL)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -9086,6 +9090,7 @@ CREATE TABLE appearance_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_a722a62c04 CHECK ((num_nonnulls(project_id, namespace_id, organization_id) = 0)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -13850,6 +13855,7 @@ CREATE TABLE dependency_list_export_part_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_86a96d8348 CHECK ((organization_id IS NOT NULL)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -13893,6 +13899,7 @@ CREATE TABLE dependency_list_export_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_889220aa2d CHECK ((num_nonnulls(namespace_id, organization_id, project_id) = 1)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -14215,6 +14222,7 @@ CREATE TABLE design_management_action_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_63456653da CHECK ((namespace_id IS NOT NULL)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -15978,6 +15986,7 @@ CREATE TABLE import_export_upload_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_4eb49c8ee8 CHECK ((num_nonnulls(namespace_id, organization_id, project_id) = 1)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -18702,7 +18711,8 @@ CREATE TABLE namespace_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), - CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) + CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)), + CONSTRAINT check_dff00b5115 CHECK ((namespace_id IS NOT NULL)) ); CREATE SEQUENCE namespaces_id_seq @@ -19306,6 +19316,7 @@ CREATE TABLE organization_detail_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_8c86d5dff9 CHECK ((organization_id IS NOT NULL)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -22217,7 +22228,8 @@ CREATE TABLE project_topic_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), - CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) + CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)), + CONSTRAINT check_d6cd4bbec3 CHECK ((organization_id IS NOT NULL)) ); CREATE TABLE project_topics ( @@ -24009,7 +24021,8 @@ CREATE TABLE snippet_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), - CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) + CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)), + CONSTRAINT check_f1b1b6e769 CHECK ((organization_id IS NOT NULL)) ); CREATE TABLE snippet_user_mentions ( @@ -25203,6 +25216,7 @@ CREATE TABLE user_permission_export_upload_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_a2b88c893f CHECK ((num_nonnulls(project_id, namespace_id, organization_id) = 0)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -25632,6 +25646,7 @@ CREATE TABLE vulnerability_archive_export_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_7bfde94300 CHECK ((project_id IS NOT NULL)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -25680,7 +25695,8 @@ CREATE TABLE vulnerability_export_part_uploads ( mount_point text, secret text, CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), - CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) + CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)), + CONSTRAINT check_fafd5f387b CHECK ((organization_id IS NOT NULL)) ); CREATE TABLE vulnerability_export_parts ( @@ -25722,6 +25738,7 @@ CREATE TABLE vulnerability_export_uploads ( uploader text NOT NULL, mount_point text, secret text, + CONSTRAINT check_1bc83211e7 CHECK ((organization_id IS NOT NULL)), CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) ); @@ -26190,6 +26207,7 @@ CREATE TABLE vulnerability_remediation_uploads ( uploader text NOT NULL, mount_point text, secret text, + CONSTRAINT check_23cba26410 CHECK ((project_id IS NOT NULL)), CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) );