summaryrefslogtreecommitdiff
path: root/db-setup.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db-setup.sql')
-rw-r--r--db-setup.sql22
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);