1] [SQLITE_ERROR] SQL error or missing database (table auth_user_dg_tmp already exists). code example

Example: [SQLITE_ERROR] SQL error or missing database (no such table: category_table)

If you just added a new table, just update your Database class 
(That one class extending the RoomDatabase() class) and update the entities annotation

@Database(entities = [User::class, NewTableHere::class], version = 1)
abstract class AppDatabase : RoomDatabase() {
Wish it saves you time on searching for answer, happy coding.