Initial commitHEADmaster

1 files changed, 28 insertions, 0 deletions

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