blob: 61541a9673fcbb53542eeaaebd2a8d2b273605d0 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
);
|
