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 @@ -502,6 +502,15 @@ return false; } +bool create_communities_table(sqlite3 *db) { + std::string query = + "CREATE TABLE IF NOT EXISTS communities (" + " id TEXT UNIQUE PRIMARY KEY NOT NULL," + " community_info TEXT NOT NULL" + ");"; + return create_table(db, query, "communities"); +} + bool create_schema(sqlite3 *db) { char *error; sqlite3_exec( @@ -590,6 +599,11 @@ " keyserver_info TEXT NOT NULL" ");" + "CREATE TABLE IF NOT EXISTS communities (" + " id TEXT UNIQUE PRIMARY KEY NOT NULL," + " community_info TEXT NOT NULL" + ");" + "CREATE INDEX IF NOT EXISTS media_idx_container" " ON media (container);" @@ -829,7 +843,8 @@ {31, {recreate_message_store_threads_table, true}}, {32, {create_users_table, true}}, {33, {create_keyservers_table, true}}, - {34, {enable_rollback_journal_mode, false}}}}; + {34, {enable_rollback_journal_mode, false}}, + {35, {create_communities_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$@