This repository has been archived on 2024-03-02. You can view files and clone it, but cannot push or open issues or pull requests.
probotic/bootstrap/defaults.sql

28 lines
815 B
MySQL
Raw Permalink Normal View History

2023-08-04 11:13:47 -04:00
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',
2023-08-06 22:51:57 -04:00
'Contribute to Probotic'
2023-08-04 11:13:47 -04:00
);
INSERT INTO assignment (who, project) VALUES (
'#/g/chad',
1
);