-
Notifications
You must be signed in to change notification settings - Fork 0
/
assignment_data.sql
45 lines (38 loc) · 4.46 KB
/
assignment_data.sql
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
-- assignments for course 106 created
INSERT INTO assignments (assignment_id, course_id, due_date, is_published, title, content, total_points, assignment_type)
VALUES
(5024, 106, '2024-05-07 23:59:59', 1, 'Assignment 1', 'https://drive.google.com/file/d/1MClstaDzxtLO4k5w-cJvjvP5FM9LDO87/view?usp=sharing', 100, 'homework'),
(5025, 106, '2024-05-14 23:59:59', 1, 'Assignment 2', 'https://drive.google.com/file/d/1MClstaDzxtLO4k5w-cJvjvP5FM9LDO87/view?usp=sharing', 100, 'homework'),
(5026, 106, '2024-05-21 23:59:59', 1, 'Assignment 3', 'https://drive.google.com/file/d/1MClstaDzxtLO4k5w-cJvjvP5FM9LDO87/view?usp=sharing', 100, 'homework'),
(5027, 106, '2024-05-28 23:59:59', 1, 'Assignment 4', 'https://drive.google.com/file/d/1MClstaDzxtLO4k5w-cJvjvP5FM9LDO87/view?usp=sharing', 100, 'homework'),
(5028, 106, '2024-06-04 23:59:59', 1, 'Assignment 5', 'https://drive.google.com/file/d/1MClstaDzxtLO4k5w-cJvjvP5FM9LDO87/view?usp=sharing', 100, 'homework');
INSERT INTO assignments (assignment_id, course_id, due_date, is_published, title, content, total_points, assignment_type)
VALUES
(5029, 106, '2024-05-07 23:59:59', 1, 'Quizz 1', 'https://drive.google.com/file/d/1MClstaDzxtLO4k5w-cJvjvP5FM9LDO87/view?usp=sharing', 100, 'quiz');
-- assignments for course 107 created
INSERT INTO assignments (assignment_id, course_id, due_date, is_published, title, content, total_points, assignment_type)
VALUES
(5033, 107, '2024-05-07 23:59:59', 1, 'Assignment 1', 'https://drive.google.com/file/d/1BmCCJiCLeoZWoQj2c-z66AFZVhsWTLKh/view?usp=sharing', 100, 'homework'),
(5034, 107, '2024-05-14 23:59:59', 1, 'Assignment 2', 'https://drive.google.com/file/d/1BmCCJiCLeoZWoQj2c-z66AFZVhsWTLKh/view?usp=sharing', 100, 'homework'),
(5035, 107, '2024-05-21 23:59:59', 1, 'Assignment 3', 'https://drive.google.com/file/d/1BmCCJiCLeoZWoQj2c-z66AFZVhsWTLKh/view?usp=sharing', 100, 'homework'),
(5036, 107, '2024-05-28 23:59:59', 1, 'Assignment 4', 'https://drive.google.com/file/d/1BmCCJiCLeoZWoQj2c-z66AFZVhsWTLKh/view?usp=sharing', 100, 'homework'),
(5037, 107, '2024-06-04 23:59:59', 1, 'Assignment 5', 'https://drive.google.com/file/d/1BmCCJiCLeoZWoQj2c-z66AFZVhsWTLKh/view?usp=sharing', 100, 'homework'),
(5038, 107, '2024-06-11 23:59:59', 1, 'Quiz 1', 'https://drive.google.com/file/d/1BmCCJiCLeoZWoQj2c-z66AFZVhsWTLKh/view?usp=sharing', 50, 'quiz');
-- assignements for course 108 created
INSERT INTO assignments (assignment_id, course_id, due_date, is_published, title, content, total_points, assignment_type)
VALUES
(5043, 108, '2024-05-07 23:59:59', 1, 'Assignment 1', 'https://drive.google.com/file/d/1mBxBoIA2dHf-uJW66hNhxJW92osI_1Xg/view?usp=sharing', 100, 'homework'),
(5044, 108, '2024-05-14 23:59:59', 1, 'Assignment 2', 'https://drive.google.com/file/d/1mBxBoIA2dHf-uJW66hNhxJW92osI_1Xg/view?usp=sharing', 100, 'homework'),
(5045, 108, '2024-05-21 23:59:59', 1, 'Assignment 3', 'https://drive.google.com/file/d/1mBxBoIA2dHf-uJW66hNhxJW92osI_1Xg/view?usp=sharing', 100, 'homework'),
(5046, 108, '2024-05-28 23:59:59', 1, 'Assignment 4', 'https://drive.google.com/file/d/1mBxBoIA2dHf-uJW66hNhxJW92osI_1Xg/view?usp=sharing', 100, 'homework'),
(5047, 108, '2024-06-04 23:59:59', 1, 'Assignment 5', 'https://drive.google.com/file/d/1mBxBoIA2dHf-uJW66hNhxJW92osI_1Xg/view?usp=sharing', 100, 'homework'),
(5048, 108, '2024-06-11 23:59:59', 1, 'Quiz 1', 'https://drive.google.com/file/d/1mBxBoIA2dHf-uJW66hNhxJW92osI_1Xg/view?usp=sharing', 50, 'quiz');
--assignments for course 105 created
INSERT INTO assignments (assignment_id, course_id, due_date, is_published, title, content, total_points, assignment_type)
VALUES
(5053, 105, '2023-12-07 23:59:59', 1, 'Assignment 1', 'https://drive.google.com/file/d/18vIzOFmV-vjo9Tj303Rb67gYExm74XQH/view?usp=sharing', 100, 'homework'),
(5054, 105, '2023-12-14 23:59:59', 1, 'Assignment 2', 'https://drive.google.com/file/d/18vIzOFmV-vjo9Tj303Rb67gYExm74XQH/view?usp=sharing', 100, 'homework'),
(5055, 105, '2023-12-21 23:59:59', 1, 'Assignment 3', 'https://drive.google.com/file/d/18vIzOFmV-vjo9Tj303Rb67gYExm74XQH/view?usp=sharing', 100, 'homework'),
(5056, 105, '2023-12-28 23:59:59', 1, 'Assignment 4', 'https://drive.google.com/file/d/18vIzOFmV-vjo9Tj303Rb67gYExm74XQH/view?usp=sharing', 100, 'homework'),
(5057, 105, '2024-01-04 23:59:59', 1, 'Assignment 5', 'https://drive.google.com/file/d/18vIzOFmV-vjo9Tj303Rb67gYExm74XQH/view?usp=sharing', 100, 'homework'),
(5058, 105, '2024-01-11 23:59:59', 1, 'Quiz 1', 'https://drive.google.com/file/d/18vIzOFmV-vjo9Tj303Rb67gYExm74XQH/view?usp=sharing', 50, 'quiz');