GTrack/insert.sql at master · DwyaneWan/GTrack · 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
-- INSERT INTO students (id, email, username, name, password_hash)
-- VALUES (2, '002@000.com', 'tom', 'tom ford', '123'),
-- (3, '003@000.com', 'dfs', 'jack james', '123'),
-- (4, '004@000.com', 'sdg', 'tom lil', '123'),
-- (5, '005@000.com', 'gas', 'jack ma', '123'),
-- (6, '006@000.com', 'saf', 'tnoy leo', '123'),
-- (7, '007@000.com', 'yre', 'yes no', '123'),
-- (8, '008@000.com', 'ppp', 'fun fact', '123'),
-- (9, '009@000.com', 'qqq', 'data base', '123'),
-- (10, '010@000.com', 'eee', 'james john', '123'),
-- (11, '011000.com', 'ttt', 'jackie chen', '123'),
-- (12, '012@000.com', 'xxx', 'ming yao', '123'),
-- (13, '013@000.com', 'jjj', 'dwyane wade', '123'),
-- (14, '014@000.com', 'sss', 'derick rose', '123'),
-- (15, '015@000.com', 'www', 'blue stone', '123'),
-- (16, '016@000.com', 'uuu', 'emma stone', '123'),
-- (17, '017@000.com', 'kkk', 'jane smith', '123'),
-- (18, '018@000.com', 'bbb', 'tony allen', '123');
--
--
-- INSERT INTO teams
-- VALUES (001, 6400, 1, 'gtrack'),
-- (002, 6250, 1, 'quic performance'),
-- (003, 6560, 1, 'forecase prices'),
-- (004, 6470, 1, 'book recommendation'),
-- (005, 6120, 1, 'build new web'),
-- (006, 6230, 1, 'fun project'),
-- (007, 6410, 1, 'cool app'),
-- (008, 6400, 2, 'fun app'),
-- (009, 6400, 3, 'cool project'),
-- (010, 6400, 4, 'new database'),
-- (011, 6400, 5, 'management system');
--
-- INSERT INTO participations
-- VALUES (1, 001, 'do demo', 'built app'),
-- (1, 002, 'fix filter bug', 'implemented the filter'),
-- (1, 003, 'draw bar chart', 'collected all data'),
-- (2, 001, 'fix filter bug', 'implemented the filter'),
-- (2, 004, 'do demo', 'built app'),
-- (2, 005, 'do demo', 'built app'),
-- (3, 009, 'do demo', 'built app'),
-- (3, 004, 'do demo', 'built app'),
-- (4, 002, 'draw bar chart', 'collected data'),
-- (5, 001, 'do demo', 'built app'),
-- (6, 002, 'do demo', 'built app'),
-- (6, 004, 'do demo', 'built app'),
-- (6, 005, 'do demo', 'built app'),
-- (7, 001, 'do demo', 'built app'),
-- (7, 004, 'do demo', 'built app'),
-- (7, 005, 'do demo', 'built app'),
-- (8, 003, 'write final report', 'did presentation'),
-- (8, 005, 'do demo', 'built app'),
-- (9, 003, 'do demo', 'built app'),
-- (10, 002, 'do demo', 'built app'),
-- (11, 001, 'do demo', 'built app'),
-- (11, 004, 'do demo', 'built app'),
-- (11, 005, 'do demo', 'built app'),
-- (11, 006, 'do demo', 'built app'),
-- (11, 007, 'do demo', 'built app'),
-- (14, 004, 'do demo', 'built app'),
-- (15, 005, 'do demo', 'built app'),
-- (16, 006, 'do demo', 'built app'),
-- (17, 007, 'do demo', 'built app'),
-- (18, 008, 'do demo', 'built app'),
-- (18, 009, 'do demo', 'built app'),
-- (12, 010, 'do demo', 'built app');

INSERT INTO milestones
VALUES (001, 1, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(001, 2, 'gtrack', 999, '10.12.2017', 'graded', '80'),
(001, 3, 'gtrack', 999, '11.12.2017', 'graded', '96'),
(001, 4, 'gtrack', 999, '11.22.2017', 'todo', ''),
(001, 5, 'gtrack', 999, '12.12.2017', 'todo', ''),
(002, 1, 'quic performance', 998, '9.14.2017', 'graded', '80'),
(002, 2, 'quic performance', 998, '11.14.2017', 'graded', '89'),
(002, 3, 'quic performance', 998, '12.14.2017', 'todo', ''),
(003, 1, 'forecase prices', 994, '9.13.2017', 'graded', '98'),
(003, 2, 'forecase prices', 994, '9.13.2017', 'graded', '96'),
(003, 3, 'forecase prices', 994, '9.13.2017', 'graded', '70'),
(003, 4, 'forecase prices', 994, '9.13.2017', 'graded', '80'),
(003, 5, 'forecase prices', 994, '9.13.2017', 'todo', ''),
(003, 6, 'forecase prices', 994, '9.13.2017', 'todo', ''),
(004, 1, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(005, 2, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(004, 8, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(005, 8, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(004, 9, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(005, 9, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(004, 7, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(005, 7, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(004, 6, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(005, 6, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(004, 11, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(005, 11, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(004, 12, 'gtrack', 999, '9.12.2017', 'graded', '90'),
(005, 22, 'gtrack', 999, '9.12.2017', 'graded', '90');

-- INSERT INTO instructors
-- VALUES (999, 'Sham Navathe', 'Klaus 3320', 'Thur 3:00-4:00pm'),
-- (998, 'John Smith', 'CCB 109', 'Fri 3:00-4:00pm'),
-- (994, 'Tom Ford', 'CCB 223', 'Thur 3:00-4:00pm'),
-- (995, 'Jade Lil', 'Klaus 2150', 'Thur 3:00-4:00pm');