aboutsummaryrefslogtreecommitdiff
path: root/resources/migrations
diff options
context:
space:
mode:
authorJoris Guyonvarch2025-12-26 18:41:26 +0100
committerJoris Guyonvarch2025-12-27 20:41:44 +0100
commita110c200e86d2325af07167531fac0f61d9681a0 (patch)
tree90e843f915a2e153ba735849afd83710d90560bf /resources/migrations
parenta26d92ad5055fa057647158eb79511e7b1841162 (diff)
Switch to GUI to manage the library
Allow to regroup the CLI and the view into one unique tool.
Diffstat (limited to 'resources/migrations')
-rw-r--r--resources/migrations/01.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/resources/migrations/01.sql b/resources/migrations/01.sql
new file mode 100644
index 0000000..1acccdd
--- /dev/null
+++ b/resources/migrations/01.sql
@@ -0,0 +1,6 @@
+CREATE TABLE IF NOT EXISTS "books" (
+ "id" TEXT PRIMARY KEY,
+ "created_at" TEXT NOT NULL DEFAULT (datetime()),
+ "updated_at" TEXT NOT NULL DEFAULT (datetime()),
+ "data" BLOB NOT NULL
+) STRICT;