21 lines
740 B
Ruby
21 lines
740 B
Ruby
# frozen_string_literal: true
|
|
|
|
class AddZoektShardsAndIndexedNamespaces < Gitlab::Database::Migration[2.1]
|
|
enable_lock_retries!
|
|
|
|
def change
|
|
create_table :zoekt_shards do |t|
|
|
t.text :index_base_url, limit: 1024, index: { unique: true }, null: false
|
|
t.text :search_base_url, limit: 1024, index: { unique: true }, null: false
|
|
t.timestamps_with_timezone
|
|
end
|
|
|
|
create_table :zoekt_indexed_namespaces do |t|
|
|
t.references :zoekt_shard, null: false, index: false, foreign_key: { on_delete: :cascade }
|
|
t.bigint :namespace_id, null: false, index: true
|
|
t.timestamps_with_timezone
|
|
t.index [:zoekt_shard_id, :namespace_id], unique: true, name: 'index_zoekt_shard_and_namespace'
|
|
end
|
|
end
|
|
end
|