From f36f77472a82d6ebfac153aed6d17f154ae239a6 Mon Sep 17 00:00:00 2001 From: Benjamin Chausse Date: Sat, 22 Feb 2025 09:59:10 -0500 Subject: Good foundations --- internal/storage/schema.go | 38 -------------------------------------- 1 file changed, 38 deletions(-) delete mode 100644 internal/storage/schema.go (limited to 'internal/storage/schema.go') diff --git a/internal/storage/schema.go b/internal/storage/schema.go deleted file mode 100644 index 042c09b..0000000 --- a/internal/storage/schema.go +++ /dev/null @@ -1,38 +0,0 @@ -package storage - -func opts() string { - return "?_foreign_keys=on&_journal_mode=WAL" -} - -func schema() string { - return ` -CREATE TABLE User ( - UserID INTEGER PRIMARY KEY AUTOINCREMENT, - Name TEXT NOT NULL, - Email TEXT NOT NULL UNIQUE -); - -CREATE TABLE Task ( - TaskID INTEGER PRIMARY KEY AUTOINCREMENT, - Title TEXT NOT NULL, - Description TEXT NOT NULL, - Due DATE NOT NULL, - Do DATE NOT NULL, - Owner INTEGER NOT NULL, - FOREIGN KEY (Owner) REFERENCES User(UserID) ON DELETE CASCADE -); - -CREATE TABLE Tag ( - TagID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Name TEXT NOT NULL UNIQUE -); - -CREATE TABLE TaskTag ( - TaskUUID INTEGER NOT NULL, - TagID INTEGER NOT NULL, - PRIMARY KEY (TaskUUID, TagID), - FOREIGN KEY (TaskUUID) REFERENCES Task(UUID) ON DELETE CASCADE, - FOREIGN KEY (TagID) REFERENCES Tag(TagID) ON DELETE CASCADE -); -` -} -- cgit v1.2.3