diff --git a/internal/praefect/datastore/migrations/20220214202822_replication_queue_state_lock_id_indices.go b/internal/praefect/datastore/migrations/20220214202822_replication_queue_state_lock_id_indices.go new file mode 100644 index 0000000000000000000000000000000000000000..549db4dffa335d0d4a83976f6c8c9ebbcd81b239 --- /dev/null +++ b/internal/praefect/datastore/migrations/20220214202822_replication_queue_state_lock_id_indices.go @@ -0,0 +1,20 @@ +package migrations + +import migrate "github.com/rubenv/sql-migrate" + +func init() { + m := &migrate.Migration{ + Id: "20220214202822_replication_queue_state_lock_id_indices", + Up: []string{ + "CREATE INDEX CONCURRENTLY replication_queue_lock_id ON replication_queue (lock_id)", + "CREATE INDEX CONCURRENTLY replication_queue_state ON replication_queue (state)", + }, + DisableTransactionUp: true, + Down: []string{ + "DROP INDEX replication_queue_state", + "DROP INDEX replication_queue_lock_id", + }, + } + + allMigrations = append(allMigrations, m) +}