oncourse/tester_data_sample_text.cmd at master · LHousehold/oncourse · GitHub

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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118

use oncourse;

TRUNCATE TABLE course_package;

INSERT INTO course_package
VALUES (NULL,1,"PDF", 1, "./files/McDonald.pdf", "FULL");

INSERT INTO course_package
VALUES (NULL,1,"PDF", 2, "./files/1.pdf", "LEFT");

INSERT INTO course_package
VALUES (NULL,1,"PDF", 2, "./files/2.pdf", "RIGHT");

INSERT INTO course_package
VALUES (NULL,1,"PDF", 3, "./files/3.pdf", "LEFT");

INSERT INTO course_package
VALUES (NULL,1,"YOUTUBE", 3, "-epDdKaLPN0", "TR");

INSERT INTO course_package
VALUES (NULL,1,"YOUTUBE", 3, "c170GdSKkyg", "BR");

INSERT INTO course_package
VALUES (NULL,1,"PDF", 4, "./files/4.pdf", "LEFT");

INSERT INTO course_package
VALUES (NULL,1,"PDF", 4, "./files/5.pdf", "RIGHT");

INSERT INTO course_package
VALUES (NULL,1,"PDF", 5, "./files/6.pdf", "RIGHT");

INSERT INTO course_package
VALUES (NULL,1,"MP3", 5, "./files/style.mp3", "TL");

INSERT INTO course_package
VALUES (NULL,1,"YOUTUBE", 5, "dtm_tIkEbMc", "BL");

INSERT INTO course_package
VALUES (NULL,1,"PDF", 6, "./files/7.pdf", "LEFT");

INSERT INTO course_package
VALUES (NULL,1,"PDF", 6, "./files/8.pdf", "RIGHT");


INSERT INTO course_package
VALUES (NULL,2,"PDF", 1, "./jsftut/title.pdf", "FULL");

INSERT INTO course_package
VALUES (NULL,2,"PDF", 2, "./jsftut/page1_1.pdf", "LEFT");

INSERT INTO course_package
VALUES (NULL,2,"PDF", 2, "./jsftut/page1_2.pdf", "RIGHT");

INSERT INTO course_package
VALUES (NULL,2,"PDF", 3, "./jsftut/page2_1.pdf", "LEFT");

INSERT INTO course_package
VALUES (NULL,2,"PDF", 3, "./jsftut/page2_2.pdf", "RIGHT");

INSERT INTO course_package
VALUES (NULL,2,"PDF", 4, "./jsftut/page2_3.pdf", "LEFT");

INSERT INTO course_package
VALUES (NULL,2,"YOUTUBE", 4, "Q0WyiOfOGCc", "TR");

INSERT INTO course_package
VALUES (NULL,2,"YOUTUBE", 4, "IaMgMVO765o", "BR");

INSERT INTO course_package
VALUES (NULL,2,"PDF", 5, "./jsftut/page3_1.pdf", "LEFT");

INSERT INTO course_package
VALUES (NULL,2,"PDF", 5, "./jsftut/page3_2.pdf", "RIGHT");


INSERT INTO course_package_section
VALUES (NULL,2,1,"Title","section",1);

INSERT INTO course_package_section
VALUES (NULL,2,2,"JSP Overview","section",2);

INSERT INTO course_package_section
VALUES (NULL,2,2.1,"Why use JSP?","subsection",2);

INSERT INTO course_package_section
VALUES (NULL,2,2.2,"Advantages of JSP","subsection",2);

INSERT INTO course_package_section
VALUES (NULL,2,3,"JSP Environment Setup","section",3);

INSERT INTO course_package_section
VALUES (NULL,2,3.1,"Setting up Java Development Kit","subsection",3);

INSERT INTO course_package_section
VALUES (NULL,2,3.2,"Setting up Web Server: Tomcat","subsection",3);


INSERT INTO course_package_name
VALUES (NULL,"McDonald's Nutrition","MCD100");

INSERT INTO course_package_name
VALUES (NULL,"Introduction to JSP","JSP100");

INSERT INTO users
VALUES (NULL,"a","a","STUDENT", "1, 2");

INSERT INTO users
VALUES (NULL,"b","b","INSTRUCTOR", "1, 2");

INSERT INTO users
VALUES (NULL,"sam","password","STUDENT", "2");

INSERT INTO users
VALUES (NULL,"john","123456","INSTRUCTOR", "2");