Page MenuHomePhorge
Files F32881542

D7984.1768156489.diff
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

D7984.1768156489.diff
View Options

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
@@ -38,6 +38,11 @@
key TEXT UNIQUE PRIMARY KEY NOT NULL,
item TEXT NOT NULL
);
+
+ CREATE TABLE IF NOT EXISTS reports (
+ id TEXT UNIQUE PRIMARY KEY NOT NULL,
+ report TEXT NOT NULL
+ );
`);
const migrationKeys = migrations.size ? migrations.keys() : [0];
const newDatabaseVersion = Math.max(...migrationKeys);
diff --git a/web/database/utils/migrations.js b/web/database/utils/migrations.js
--- a/web/database/utils/migrations.js
+++ b/web/database/utils/migrations.js
@@ -2,7 +2,16 @@
import type { SqliteDatabase } from 'sql.js';
+import { createReportTable } from '../queries/report-queries.js';
+
const migrations: $ReadOnlyMap<number, (sqliteDb: SqliteDatabase) => void> =
- new Map([]);
+ new Map([
+ [
+ 1,
+ (sqliteDb: SqliteDatabase) => {
+ createReportTable(sqliteDb);
+ },
+ ],
+ ]);
export { migrations };

File Metadata

Mime Type
text/plain
Expires
Sun, Jan 11, 6:34 PM (12 h, 53 s)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5918641
Default Alt Text
D7984.1768156489.diff (1 KB)

Event Timeline