rails db:migrate:reset したら、データベースが消えてしまった

rails初心者です。データベースが消えてかなり焦っています。お助けください。

事の経緯

scoreテーブルのhole_scoreというカラムのデータ型の変更作業をしていました。マイグレート済みでしたが、migrateファイル（change_column ）に誤記があることに気付き、rails db:rollbackを実行したのですが、
「rails aborted!StandardError: An error has occurred, all later migrations canceled:」
が出たので、一度rails db:migrate:resetを実行したら、下記のようになりました。

元に戻す方法

rails db:migrateを実行すれば、データベースは元に戻りますでしょうか。怖くなってしまいました…

% rails db:migrate:reset
Dropped database 'golfscore_development'
Dropped database 'golfscore_test'
Created database 'golfscore_development'
Created database 'golfscore_test'
== 20201016031114 CreateMessages: migrating ===================================
-- create_table(:messages)
   -> 0.0218s
== 20201016031114 CreateMessages: migrated (0.0219s) ==========================

== 20201016031241 CreateScores: migrating =====================================
-- create_table(:scores)
   -> 0.0238s
== 20201016031241 CreateScores: migrated (0.0238s) ============================

== 20201016032022 AddHoleNumberToMessages: migrating ==========================
-- add_column(:messages, :title, :string)
   -> 0.0468s
== 20201016032022 AddHoleNumberToMessages: migrated (0.0469s) =================

== 20201016035114 RemoveTitleFromMessages: migrating ==========================
-- remove_column(:messages, :title, :string)
   -> 0.0413s
== 20201016035114 RemoveTitleFromMessages: migrated (0.0414s) =================

== 20201016035321 AddHoleNumberToScores: migrating ============================
-- add_column(:scores, :hole_number, :integer)
   -> 0.0158s
== 20201016035321 AddHoleNumberToScores: migrated (0.0158s) ===================

== 20201016131954 DeviseCreateUsers: migrating ================================
-- create_table(:users)
rails aborted!
StandardError: An error has occurred, all later migrations canceled:

途中省略

Tasks: TOP => db:migrate:reset => db:migrate
(See full trace by running task with --trace)

追記

rails db:migrate実行してみましたが、下記のようなエラーがでました。

== 20201016131954 DeviseCreateUsers: migrating ================================
-- create_table(:users)
rails aborted!
StandardError: An error has occurred, all later migrations canceled:

you can't define an already defined column 'name'.