Newer
Older
marking / sql / test_data.sql
INSERT INTO Assessment VALUES ('Testing', 20.0);

INSERT INTO Category VALUES
	('Stuff', 1.0),
	('Things', 2.0),
	('Other', 3.0);

INSERT INTO Criterion VALUES
	('first', 'Stuff', 'Did the first thing', 1.0, 1.0, 0, 5, 'Scale', 'Normal'),
	('second', 'Stuff', 'Did the second thing', 2.0, 1.0, 0, 5, 'Scale', 'Normal'),
	('third', 'Things', 'Did the third thing', 3.0, 1.0, 0, 5, 'Scale', 'Normal'),
	('fourth', 'Things', 'Did the fourth thing', 4.0, 1.0, 0, 5, 'Numeric', 'Normal'),
	('bonus', 'Other', 'Did the bonus task', 5.0, 1.0, 0, 5, 'Numeric', 'Special'),
	('late', 'Other', 'Penalty for late submission', 6.0, 1.0, 0, 20, 'Numeric', 'Penalty');

INSERT INTO Student VALUES
	('1111', '1111', 'one', 'Onesy', 'One', 'one@example.com', TRUE, FALSE),
	('2222', '2222', 'two', 'Twosy', 'Two', 'two@example.com', TRUE, FALSE);

INSERT INTO Submission VALUES
	('1111', 'Onesy One'),
	('2222', 'Twosy Two');