added support for booksHEADmaster

1 files changed, 14 insertions, 8 deletions

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);