From 935243d8b4ea992c50315f0c8fcb300365a5762d Mon Sep 17 00:00:00 2001
From: Emil
Date: Fri, 4 Aug 2023 09:13:47 -0600
Subject: Initial commit

---
 bootstrap/defaults.sql | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 bootstrap/defaults.sql

(limited to 'bootstrap/defaults.sql')

diff --git a/bootstrap/defaults.sql b/bootstrap/defaults.sql
new file mode 100644
index 0000000..61541a9
--- /dev/null
+++ b/bootstrap/defaults.sql
@@ -0,0 +1,28 @@
+INSERT INTO difficulty VALUES('Easy');
+INSERT INTO difficulty VALUES('Medium');
+INSERT INTO difficulty VALUES('Hard');
+INSERT INTO difficulty VALUES('Fuck You');
+
+INSERT INTO tag VALUES('AI');
+INSERT INTO tag VALUES('Algorithms');
+INSERT INTO tag VALUES('Games');
+INSERT INTO tag VALUES('Math');
+INSERT INTO tag VALUES('Networking');
+INSERT INTO tag VALUES('Rendering');
+INSERT INTO tag VALUES('Simulation');
+INSERT INTO tag VALUES('Tools');
+
+-- I believe the list of links might be better suited as a detacted part of this
+-- I also have no idea how this would format this internally
+-- Does SQL would support 'a' 'b' concat syntax? as in C's puts("abc" "def")?
+
+INSERT INTO project (title, body) VALUES (
+	'IRC Bot',
+	'Build an IRC Bot using SQLite3 and libircclient\nhttps://www.sqlite.org/index.html\n
+   http://www.ulduzsoft.com/libircclient/'
+);
+
+INSERT INTO assignment (who, project) VALUES (
+	'#/g/chad',
+	1
+);
-- 
cgit v1.2.3

