summaryrefslogtreecommitdiff
path: root/db/migrate/20200812150810_add_verification_state_to_snippet_repository.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20200812150810_add_verification_state_to_snippet_repository.rb')
-rw-r--r--db/migrate/20200812150810_add_verification_state_to_snippet_repository.rb18
1 files changed, 18 insertions, 0 deletions
diff --git a/db/migrate/20200812150810_add_verification_state_to_snippet_repository.rb b/db/migrate/20200812150810_add_verification_state_to_snippet_repository.rb
new file mode 100644
index 00000000000..3fdf0b4adf4
--- /dev/null
+++ b/db/migrate/20200812150810_add_verification_state_to_snippet_repository.rb
@@ -0,0 +1,18 @@
+# frozen_string_literal: true
+
+class AddVerificationStateToSnippetRepository < ActiveRecord::Migration[6.0]
+ DOWNTIME = false
+
+ def change
+ change_table(:snippet_repositories) do |t|
+ t.integer :verification_retry_count, limit: 2
+ t.column :verification_retry_at, :datetime_with_timezone
+ t.column :verified_at, :datetime_with_timezone
+ t.binary :verification_checksum, using: 'verification_checksum::bytea'
+
+ # rubocop:disable Migration/AddLimitToTextColumns
+ t.text :verification_failure
+ # rubocop:enable Migration/AddLimitToTextColumns
+ end
+ end
+end