diff --git a/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp b/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp --- a/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp +++ b/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp @@ -456,6 +456,15 @@ return true; } +bool create_users_table(sqlite3 *db) { + std::string query = + "CREATE TABLE IF NOT EXISTS users (" + " id TEXT UNIQUE PRIMARY KEY NOT NULL," + " user_info TEXT NOT NULL" + ");"; + return create_table(db, query, "users"); +} + bool create_schema(sqlite3 *db) { char *error; sqlite3_exec( @@ -534,6 +543,11 @@ " item TEXT NOT NULL" ");" + "CREATE TABLE IF NOT EXISTS users (" + " id TEXT UNIQUE PRIMARY KEY NOT NULL," + " user_info TEXT NOT NULL" + ");" + "CREATE INDEX IF NOT EXISTS media_idx_container" " ON media (container);" @@ -774,7 +788,8 @@ {28, {create_message_store_threads_table, true}}, {29, {create_reports_table, true}}, {30, {create_persist_storage_table, true}}, - {31, {recreate_message_store_threads_table, true}}}}; + {31, {recreate_message_store_threads_table, true}}, + {32, {create_users_table, true}}}}; enum class MigrationResult { SUCCESS, FAILURE, NOT_APPLIED }; diff --git a/web/database/_generated/comm_query_executor.wasm b/web/database/_generated/comm_query_executor.wasm index 0000000000000000000000000000000000000000..0000000000000000000000000000000000000000 GIT binary patch literal 0 Hc$@