diff --git a/db/migrate/20250425111120_add_author_email_to_ssh_signatures.rb b/db/migrate/20250425111120_add_author_email_to_ssh_signatures.rb new file mode 100644 index 0000000000000000000000000000000000000000..b96fa9ece915ba397f6c545da7d638b3ab2b515c --- /dev/null +++ b/db/migrate/20250425111120_add_author_email_to_ssh_signatures.rb @@ -0,0 +1,16 @@ +# frozen_string_literal: true + +class AddAuthorEmailToSshSignatures < Gitlab::Database::Migration[2.2] + disable_ddl_transaction! + milestone '18.0' + + # rubocop:disable Migration/AddLimitToTextColumns -- limit is added in a separate migration 20250425111203 + def up + add_column :ssh_signatures, :author_email, :text + end + # rubocop:enable Migration/AddLimitToTextColumns + + def down + remove_column :ssh_signatures, :author_email if column_exists?(:ssh_signatures, :author_email) + end +end diff --git a/db/migrate/20250425111203_add_author_email_limit_to_ssh_signatures.rb b/db/migrate/20250425111203_add_author_email_limit_to_ssh_signatures.rb new file mode 100644 index 0000000000000000000000000000000000000000..fcafd807267d84c1ab30dc2619a102a24314e92f --- /dev/null +++ b/db/migrate/20250425111203_add_author_email_limit_to_ssh_signatures.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class AddAuthorEmailLimitToSshSignatures < Gitlab::Database::Migration[2.2] + disable_ddl_transaction! + milestone '18.0' + + def up + add_text_limit :ssh_signatures, :author_email, 255 + end + + def down + remove_text_limit :ssh_signatures, :author_email + end +end diff --git a/db/schema_migrations/20250425111120 b/db/schema_migrations/20250425111120 new file mode 100644 index 0000000000000000000000000000000000000000..bd21a506b02d2f6413d4ce750a841559e8aabca3 --- /dev/null +++ b/db/schema_migrations/20250425111120 @@ -0,0 +1 @@ +a07dd290fe3abc6c4e74f41ec0a83218b4ef8cc8c83a99e0da820fce11c7c732 \ No newline at end of file diff --git a/db/schema_migrations/20250425111203 b/db/schema_migrations/20250425111203 new file mode 100644 index 0000000000000000000000000000000000000000..537eff660931ce59ea952ae30e068e77b77c09e8 --- /dev/null +++ b/db/schema_migrations/20250425111203 @@ -0,0 +1 @@ +3672a1886f77ed6e9072ef2e4bb2f1b00f87e1b9f7c7289bc930db1f0f4e376d \ No newline at end of file diff --git a/db/structure.sql b/db/structure.sql index e3ed52b5568cd3bdf69bd44beddf34b837c92a11..9f5d29b208c429819656bdbcf862078bb84c3f18 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -23305,7 +23305,9 @@ CREATE TABLE ssh_signatures ( verification_status smallint DEFAULT 0 NOT NULL, commit_sha bytea NOT NULL, user_id bigint, - key_fingerprint_sha256 bytea + key_fingerprint_sha256 bytea, + author_email text, + CONSTRAINT check_5ff707c7f9 CHECK ((char_length(author_email) <= 255)) ); CREATE SEQUENCE ssh_signatures_id_seq