summaryrefslogtreecommitdiff
path: root/db-setup.sql
diff options
context:
space:
mode:
authoryuzu-eva <cafebabe@disroot.org>2025-03-25 16:15:25 +0100
committeryuzu-eva <cafebabe@disroot.org>2025-03-25 16:15:25 +0100
commit7cd7876202746fded86d770fb77aea0f55b814d8 (patch)
tree781861dc8c333d2878dec581ddda150e0e34f48e /db-setup.sql
parent1764af3aed0e2ba466f813ca28680d4487f61f19 (diff)
added db-setup script; fixed makefile
Diffstat (limited to 'db-setup.sql')
-rw-r--r--db-setup.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/db-setup.sql b/db-setup.sql
new file mode 100644
index 0000000..1d69989
--- /dev/null
+++ b/db-setup.sql
@@ -0,0 +1,12 @@
+CREATE TABLE anime(
+ ID INTEGER PRIMARY NOT NULL AUTOINCREMENT,
+ NAME TEXT NOT NULL,
+ EPISODE TEXT NOT NULL,
+ STATUS TEXT NOT NULL);
+
+CREATE TABLE manga(
+ ID INTEGER PRIMARY NOT NULL AUTOINCREMENT,
+ NAME TEXT NOT NULL,
+ CHAPTER TEXT NOT NULL,
+ STATUS TEXT NOT NULL);
+