db-setup.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

CREATE TABLE anime(
       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);

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