summaryrefslogtreecommitdiff
path: root/db/migrate/20220216110023_create_saved_replies.rb
blob: e4b6c039dee81dd2ca014008b2af271e82f94bc0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
# frozen_string_literal: true

class CreateSavedReplies < Gitlab::Database::Migration[1.0]
  enable_lock_retries!

  def up
    create_table :saved_replies do |t|
      t.references :user, index: false, null: false, foreign_key: { on_delete: :cascade }
      t.timestamps_with_timezone null: false
      t.text :name, null: false, limit: 255
      t.text :content, null: false, limit: 10000

      t.index [:user_id, :name], name: 'index_saved_replies_on_name_text_pattern_ops', unique: true, opclass: { name: :text_pattern_ops }
    end
  end

  def down
    drop_table :saved_replies, if_exists: true
  end
end