From 2dc8e8e1e32242f8e8cacc226b04e5502b84d54c Mon Sep 17 00:00:00 2001
From: yuzu-eva <cafebabe@disroot.org>
Date: Thu, 17 Apr 2025 18:14:25 +0200
Subject: added support for books

---
 db-setup.sql | 22 ++++++++++++++--------
 1 file changed, 14 insertions(+), 8 deletions(-)

(limited to 'db-setup.sql')

diff --git a/db-setup.sql b/db-setup.sql
index 5110dca..3cc7996 100644
--- a/db-setup.sql
+++ b/db-setup.sql
@@ -1,12 +1,18 @@
 CREATE TABLE anime(
-       ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
-       NAME TEXT NOT NULL,
-       EPISODE TEXT NOT NULL,
-       STATUS TEXT NOT NULL);
+       id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+       name TEXT NOT NULL,
+       episode TEXT NOT NULL,
+       status TEXT NOT NULL);
 
 CREATE TABLE manga(
-       ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
-       NAME TEXT NOT NULL,
-       CHAPTER TEXT NOT NULL,
-       STATUS TEXT NOT NULL);
+       id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+       name TEXT NOT NULL,
+       chapter TEXT NOT NULL,
+       status TEXT NOT NULL);
 
+CREATE TABLE book(
+       id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+       name TEXT NOT NULL,
+       author TEXT NOT NULL,
+       chapter TEXT NOT NULL,
+       status TEXT NOT NULL);
-- 
cgit v1.2.3

