From 7cd7876202746fded86d770fb77aea0f55b814d8 Mon Sep 17 00:00:00 2001 From: yuzu-eva Date: Tue, 25 Mar 2025 16:15:25 +0100 Subject: added db-setup script; fixed makefile --- db-setup.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 db-setup.sql (limited to 'db-setup.sql') 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); + -- cgit v1.2.3