From 2dc8e8e1e32242f8e8cacc226b04e5502b84d54c Mon Sep 17 00:00:00 2001 From: yuzu-eva 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