diff --git a/web/database/queries/db-queries.js b/web/database/queries/db-queries.js --- a/web/database/queries/db-queries.js +++ b/web/database/queries/db-queries.js @@ -14,4 +14,13 @@ return dbVersions; } -export { getSQLiteDBVersion }; +function setupSQLiteDB(db: SqliteDatabase) { + db.exec(` + CREATE TABLE IF NOT EXISTS drafts ( + key TEXT UNIQUE PRIMARY KEY NOT NULL, + text TEXT NOT NULL + ) + `); +} + +export { getSQLiteDBVersion, setupSQLiteDB }; diff --git a/web/database/worker/db-worker.js b/web/database/worker/db-worker.js --- a/web/database/worker/db-worker.js +++ b/web/database/worker/db-worker.js @@ -11,7 +11,7 @@ workerResponseMessageTypes, type WorkerRequestProxyMessage, } from '../../types/worker-types.js'; -import { getSQLiteDBVersion } from '../queries/db-queries.js'; +import { getSQLiteDBVersion, setupSQLiteDB } from '../queries/db-queries.js'; import { SQLITE_CONTENT, SQLITE_ENCRYPTION_KEY } from '../utils/constants.js'; import { generateDatabaseCryptoKey } from '../utils/worker-crypto-utils.js'; @@ -43,6 +43,7 @@ sqliteDb = new SQL.Database(new Uint8Array(content)); } else { sqliteDb = new SQL.Database(); + setupSQLiteDB(sqliteDb); } const dbVersion = getSQLiteDBVersion(sqliteDb);