-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathtest_data.sql
More file actions
267 lines (261 loc) · 74.7 KB
/
Copy pathtest_data.sql
File metadata and controls
267 lines (261 loc) · 74.7 KB
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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
INSERT INTO "Users"("Id","Name","Active") VALUES ('6','XFilip Naumovic','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('7','XKatka H.','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('8','XDenisa Svobodova','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('9','XPavel Moravec','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('10','XMichal Kuric','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('11','XPetr Hermansky','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('12','XTomy','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('13','XDavid Kubon','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('14','XRadek','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('15','XPepa','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('16','XPetr Kubat','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('17','XPetr Micko','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('18','XMarek','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('19','XMichal Venos','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('20','XIlde','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('21','XPetr Martisek','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('22','XStego','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('23','XTonda','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('24','XJan Bartunek','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('60','SFilip Naumovic','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('70','SKatka H.','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('80','SDenisa Svobodova','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('90','SPavel Moravec','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('100','SMichal Kuric','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('110','SPetr Hermansky','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('120','STomy','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('130','SDavid Kubon','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('140','SRadek','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('150','SPepa','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('160','SPetr Kubat','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('170','SPetr Micko','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('180','SMarek','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('190','SMichal Venos','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('200','SIlde','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('210','SPetr Martisek','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('220','SStego','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('230','STonda','true');
INSERT INTO "Users"("Id","Name","Active") VALUES ('240','SJan Bartunek','true');
INSERT INTO "Games"("Id", "Name", "Description") VALUES ('3', 'tennis', 'Tennis is awesome!');
-- Foosball players
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('12','1040','971','1','6');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('25','1002','1000','1','7');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('24','945','1000','1','8');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('20','829','1000','1','9');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('26','1055','1000','1','10');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('22','853','1000','1','11');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('10','914','1004','1','12');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('16','640','1000','1','13');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('7','1411','1032','1','14');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('11','1182','981','1','15');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('15','882','941','1','16');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('8','990','1020','1','17');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('13','925','970','1','18');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('23','1106','1000','1','19');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('21','800','1000','1','20');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('9','1038','1012','1','21');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('5','971','1054','1','22');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('6','1323','1052','1','23');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('14','1094','963','1','24');
-- Foosball matches
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('298','14','1083','5','979','8','1030','23','1051','2019-09-02 10:29:50.486','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('299','11','1076','10','973','5','995','9','1050','2019-09-02 13:10:46.237','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('300','21','856','22','853','16','693','20','867','2019-09-02 15:07:10.464','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('301','13','1018','9','1034','23','1035','5','979','2019-09-02 16:01:39.864','15','-15', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('302','12','1003','14','1099','8','1014','7','1302','2019-09-03 09:17:29.416','21','-21', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('303','10','989','13','1033','23','1020','16','680','2019-09-04 15:39:31.303','23','-23', '1', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('304','9','1049','23','1043','15','891','14','1120','2019-09-05 11:56:11.343','14','-14', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('305','11','1092','22','866','15','877','21','869','2019-09-06 11:54:25.379','11','-11', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('306','21','858','15','866','13','1010','16','703','2019-09-06 14:47:55.402','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('307','22','877','20','854','15','882','16','687','2019-09-09 10:02:55.271','12','-12', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('308','9','1063','8','993','23','1057','13','994','2019-09-09 11:24:52.137','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('309','11','1103','6','1275','14','1106','22','889','2019-09-09 14:30:19.756','8','-8', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('311','15','852','14','1098','9','1079','22','881','2019-09-10 13:02:19.941','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('312','16','693','9','1063','22','865','15','868','2019-09-11 12:57:13.607','15','-15', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('313','13','978','8','1009','23','1041','16','708','2019-09-11 15:29:02.857','11','-11', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('314','23','1030','10','984','9','1078','22','850','2019-09-12 12:08:51.389','14','-14', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('315','11','1111','23','1044','14','1114','13','989','2019-09-12 15:46:10.526','15','-15', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('316','21','856','11','1126','10','998','9','1064','2019-09-13 11:04:24.882','18','-18', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('317','11','1144','23','1059','13','974','14','1099','2019-09-13 14:09:23.956','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('318','23','1072','15','853','9','1046','13','961','2019-09-16 15:59:49.578','18','-18', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('319','7','1281','11','1157','6','1283','15','871','2019-09-17 18:04:25.93','10','-10', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('320','15','861','6','1273','14','1086','9','1028','2019-09-19 10:25:29.731','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('321','13','943','9','1012','15','877','6','1289','2019-09-19 15:34:05.228','21','-21', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('322','7','1291','9','1033','11','1167','6','1268','2019-09-20 12:13:04.865','19','-19', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('323','13','964','15','856','10','980','16','697','2019-09-20 12:48:53.371','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('324','16','684','6','1249','9','1052','10','967','2019-09-23 09:14:19.769','14','-14', '1', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('325','23','1090','10','981','16','670','6','1235','2019-09-23 13:41:13.966','12','-12', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('326','10','993',NULL,NULL,'16','658',NULL,NULL,'2019-09-23 13:57:35.313','4','-4', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('327','15','869','22','836','16','654','10','997','2019-09-24 09:10:53.533','15','-15', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('328','7','1310','15','884','23','1102','10','982','2019-09-24 14:48:03.163','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('329','14','1070','16','639','8','1020','20','866','2019-09-24 15:37:15.747','20','-20', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('330','8','1000','7','1323','14','1090','6','1223','2019-09-25 12:44:24.448','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('331','10','969','23','1089','9','1066','13','977','2019-09-25 13:46:40.801','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('364','22','851','6','1207','10','985','13','961','2019-09-26 13:49:38.422','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('365','6','1220','16','659','10','972','15','897','2019-09-27 11:43:34.41','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('367','11','1148','23','1105','6','1236','13','948','2019-09-30 12:52:38.859','14','-14', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('368','23','1119','6','1222','7','1339','21','874','2019-09-30 13:12:01.437','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('369','10','956',NULL,NULL,'21','861',NULL,NULL,'2019-10-01 07:49:54.767','12','-12', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('370','6','1235','21','849','10','968','15','881','2019-10-01 12:13:59.608','11','-11', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('371','6','1246','14','1074','7','1326','8','1016','2019-10-01 15:04:07.898','17','-17', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('372','11','1162','6','1263','7','1309','15','870','2019-10-01 20:15:43.512','11','-11', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('373','8','999','9','1050','11','1173','16','675','2019-10-02 12:58:09.756','11','-11', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('374','23','1132','15','859','10','957','5','964','2019-10-02 14:52:34.194','18','-18', '1', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('375','13','934','15','841','11','1162','16','664','2019-10-03 15:53:51.176','17','-17', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('376','10','975',NULL,NULL,'5','982',NULL,NULL,'2019-10-04 10:20:48.868','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('377','15','858','23','1114','21','860','22','864','2019-10-04 12:45:26.712','11','-11', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('378','14','1091','16','647','13','951','22','853','2019-10-04 15:22:57.665','18','-18', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('379','9','1061','6','1274','11','1145','14','1109','2019-10-07 10:21:52.809','14','-14', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('380','10','991','24','1000','16','665','20','846','2019-10-07 11:43:19.329','6','-6', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('381','11','1131','6','1288','7','1298','22','835','2019-10-07 15:30:32.097','10','-10', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('382','24','1006','16','659','15','869','20','840','2019-10-08 08:27:19.687','15','-15', '1', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('383','21','849','7','1288','9','1075','13','933','2019-10-08 11:59:25.292','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('385','6','1312','21','862','11','1141','13','920','2019-10-10 15:38:49.24','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('386','9','1062','16','658','15','870','21','875','2019-10-11 09:13:11.817','17','-17', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('387','11','1128','5','966','9','1079','10','997','2019-10-11 12:10:27.07','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('388','6','1325','15','853','8','1010','5','982','2019-10-14 14:52:13.58','12','-12', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('389','6','1337','8','998','7','1301','11','1144','2019-10-15 13:40:07.295','19','-19', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('390','22','825','6','1356','21','858','10','981','2019-10-15 15:46:50.125','9','-9', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('391','15','865','22','834','12','1024','14','1095','2019-10-16 12:34:03.014','7','-7', '1', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('392','6','1365','10','972','9','1063','8','1017','2019-10-16 13:28:06.791','10','-10', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('393','6','1375','16','675','5','970','15','858','2019-10-17 15:29:45.238','11','-11', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('394','10','982','21','849','20','855','13','907','2019-10-17 16:13:30.169','14','-14', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('395','6','1386','22','827','9','1053','21','863','2019-10-21 14:44:15.301','10','-10', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('397','22','837','5','959','10','983','16','699','2019-10-22 12:36:39.496','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('398','16','686','7','1295','15','834','23','1125','2019-10-22 15:35:16.362','15','-15', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('399','15','819','7','1310','21','853','10','970','2019-10-23 13:17:02.335','9','-9', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('400','7','1319','10','961','14','1102','23','1110','2019-10-23 15:52:29.963','14','-14', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('401','9','1043','22','850','24','977','10','975','2019-10-24 13:14:50.308','17','-17', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('434','6','1396','5','972','14','1088','23','1096','2019-10-25 14:04:56.953','12','-12', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('435','7','1333','5','984','6','1408','15','828','2019-10-29 10:25:02.474','14','-14', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('436','9','1060','22','867','8','1007','10','958','2019-10-29 13:28:28.874','17','-17', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('437','13','893','7','1347','6','1394','15','814','2019-10-29 16:03:00.575','15','-15', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('438','15','799','7','1362','23','1084','10','941','2019-10-30 10:35:24.213','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('439','23','1071','7','1375','14','1076','9','1077','2019-10-30 13:43:16.825','10','-10', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('440','6','1379','15','812','23','1081','5','998','2019-10-31 12:17:56.513','13','-13', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('441','11','1125','14','1066','6','1392','5','985','2019-10-31 16:22:17.083','20','-20', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('442','22','884','9','1067','5','965','13','908','2019-11-01 12:31:01.34','14','-14', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('443','15','825','6','1372','10','928','21','844','2019-11-01 14:19:33.986','7','-7', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('444','22','898','7','1385','6','1379','10','921','2019-11-04 12:05:38.816','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('445','5','951','13','894','9','1081','21','837','2019-11-04 13:45:37.201','18','-18', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('446','6','1363','11','1145','7','1401','14','1086','2019-11-04 16:26:20.909','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('447','15','832','7','1385','5','969','22','914','2019-11-05 12:59:01.638','9','-9', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('448','6','1379','22','905','14','1070','5','960','2019-11-05 15:53:46.953','10','-10', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('449','11','1161','6','1389','7','1394','15','841','2019-11-05 20:44:23.939','9','-9', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('450','14','1060','12','1031','15','832','22','915','2019-11-06 13:30:41.325','9','-9', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('451','15','823','23','1068','7','1385','21','819','2019-11-06 13:57:41.732','9','-9', '1', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('452','15','814','9','1063','5','950','22','906','2019-11-07 16:15:51.246','16','-16', '1', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange", "LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('453','9','1079','15','830','24','960','22','890','2019-11-08 12:16:44.265','15','-15', '1', '1', '0');
-- Tennis players
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('120','1040','971','3','60');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('250','1002','1000','3','70');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('240','945','1000','3','80');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('200','829','1000','3','90');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('260','1055','1000','3','100');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('220','853','1000','3','110');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('100','914','1004','3','120');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('160','640','1000','3','130');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('70','1411','1032','3','140');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('110','1182','981','3','150');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('150','882','941','3','160');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('80','990','1020','3','170');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('130','925','970','3','180');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('230','1106','1000','3','190');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('210','800','1000','3','200');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('90','1038','1012','3','210');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('50','971','1054','3','220');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('60','1323','1052','3','230');
INSERT INTO "Players"("Id","Rating","InitialRating", "GameId", "UserId") VALUES ('140','1094','963','3','240');
-- Tennis matches
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('2980','140','1083','50','979','80','1030','230','1051','2019-09-02 10:29:50.486','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('2990','110','1076','100','973','50','995','90','1050','2019-09-02 13:10:46.237','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3000','210','856','220','853','160','693','200','867','2019-09-02 15:07:10.464','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3010','130','1018','90','1034','230','1035','50','979','2019-09-02 16:01:39.864','15','-15', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3020','120','1003','140','1099','80','1014','70','1302','2019-09-03 09:17:29.416','21','-21', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3030','100','989','130','1033','230','1020','160','680','2019-09-04 15:39:31.303','23','-23', '3', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3040','90','1049','230','1043','150','891','140','1120','2019-09-05 11:56:11.343','14','-14', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3050','110','1092','220','866','150','877','210','869','2019-09-06 11:54:25.379','11','-11', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3060','210','858','150','866','130','1010','160','703','2019-09-06 14:47:55.402','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3070','220','877','200','854','150','882','160','687','2019-09-09 10:02:55.271','12','-12', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3080','90','1063','80','993','230','1057','130','994','2019-09-09 11:24:52.137','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3090','110','1103','60','1275','140','1106','220','889','2019-09-09 14:30:19.756','8','-8', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3110','150','852','140','1098','90','1079','220','881','2019-09-10 13:02:19.941','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3120','160','693','90','1063','220','865','150','868','2019-09-11 12:57:13.607','15','-15', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3130','130','978','80','1009','230','1041','160','708','2019-09-11 15:29:02.857','11','-11', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3140','230','1030','100','984','90','1078','220','850','2019-09-12 12:08:51.389','14','-14', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3150','110','1111','230','1044','140','1114','130','989','2019-09-12 15:46:10.526','15','-15', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3160','210','856','110','1126','100','998','90','1064','2019-09-13 11:04:24.882','18','-18', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3170','110','1144','230','1059','130','974','140','1099','2019-09-13 14:09:23.956','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3180','230','1072','150','853','90','1046','130','961','2019-09-16 15:59:49.578','18','-18', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3190','70','1281','110','1157','60','1283','150','871','2019-09-17 18:04:25.93','10','-10', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3200','150','861','60','1273','140','1086','90','1028','2019-09-19 10:25:29.731','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3210','130','943','90','1012','150','877','60','1289','2019-09-19 15:34:05.228','21','-21', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3220','70','1291','90','1033','110','1167','60','1268','2019-09-20 12:13:04.865','19','-19', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3230','130','964','150','856','100','980','160','697','2019-09-20 12:48:53.371','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3240','160','684','60','1249','90','1052','100','967','2019-09-23 09:14:19.769','14','-14', '3', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3250','230','1090','100','981','160','670','60','1235','2019-09-23 13:41:13.966','12','-12', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3260','100','993',NULL,NULL,'160','658',NULL,NULL,'2019-09-23 13:57:35.313','4','-4', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3270','150','869','220','836','160','654','100','997','2019-09-24 09:10:53.533','15','-15', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3280','70','1310','150','884','230','1102','100','982','2019-09-24 14:48:03.163','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3290','140','1070','160','639','80','1020','200','866','2019-09-24 15:37:15.747','20','-20', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3300','80','1000','70','1323','140','1090','60','1223','2019-09-25 12:44:24.448','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3310','100','969','230','1089','90','1066','130','977','2019-09-25 13:46:40.801','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3640','220','851','60','1207','100','985','130','961','2019-09-26 13:49:38.422','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3650','60','1220','160','659','100','972','150','897','2019-09-27 11:43:34.41','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3670','110','1148','230','1105','60','1236','130','948','2019-09-30 12:52:38.859','14','-14', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3680','230','1119','60','1222','70','1339','210','874','2019-09-30 13:12:01.437','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3690','100','956',NULL,NULL,'210','861',NULL,NULL,'2019-10-01 07:49:54.767','12','-12', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3700','60','1235','210','849','100','968','150','881','2019-10-01 12:13:59.608','11','-11', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3710','60','1246','140','1074','70','1326','80','1016','2019-10-01 15:04:07.898','17','-17', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3720','110','1162','60','1263','70','1309','150','870','2019-10-01 20:15:43.512','11','-11', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3730','80','999','90','1050','110','1173','160','675','2019-10-02 12:58:09.756','11','-11', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3740','230','1132','150','859','100','957','50','964','2019-10-02 14:52:34.194','18','-18', '3', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3750','130','934','150','841','110','1162','160','664','2019-10-03 15:53:51.176','17','-17', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3760','100','975',NULL,NULL,'50','982',NULL,NULL,'2019-10-04 10:20:48.868','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3770','150','858','230','1114','210','860','220','864','2019-10-04 12:45:26.712','11','-11', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3780','140','1091','160','647','130','951','220','853','2019-10-04 15:22:57.665','18','-18', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3790','90','1061','60','1274','110','1145','140','1109','2019-10-07 10:21:52.809','14','-14', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3800','100','991','240','1000','160','665','200','846','2019-10-07 11:43:19.329','6','-6', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3810','110','1131','60','1288','70','1298','220','835','2019-10-07 15:30:32.097','10','-10', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3820','240','1006','160','659','150','869','200','840','2019-10-08 08:27:19.687','15','-15', '3', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3830','210','849','70','1288','90','1075','130','933','2019-10-08 11:59:25.292','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3850','60','1312','210','862','110','1141','130','920','2019-10-10 15:38:49.24','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3860','90','1062','160','658','150','870','210','875','2019-10-11 09:13:11.817','17','-17', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3870','110','1128','50','966','90','1079','100','997','2019-10-11 12:10:27.07','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3880','60','1325','150','853','80','1010','50','982','2019-10-14 14:52:13.58','12','-12', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3890','60','1337','80','998','70','1301','110','1144','2019-10-15 13:40:07.295','19','-19', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3900','220','825','60','1356','210','858','100','981','2019-10-15 15:46:50.125','9','-9', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3910','150','865','220','834','120','1024','140','1095','2019-10-16 12:34:03.014','7','-7', '3', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3920','60','1365','100','972','90','1063','80','1017','2019-10-16 13:28:06.791','10','-10', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3930','60','1375','160','675','50','970','150','858','2019-10-17 15:29:45.238','11','-11', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3940','100','982','210','849','200','855','130','907','2019-10-17 16:13:30.169','14','-14', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3950','60','1386','220','827','90','1053','210','863','2019-10-21 14:44:15.301','10','-10', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3970','220','837','50','959','100','983','160','699','2019-10-22 12:36:39.496','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3980','160','686','70','1295','150','834','230','1125','2019-10-22 15:35:16.362','15','-15', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('3990','150','819','70','1310','210','853','100','970','2019-10-23 13:17:02.335','9','-9', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4000','70','1319','100','961','140','1102','230','1110','2019-10-23 15:52:29.963','14','-14', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4010','90','1043','220','850','240','977','100','975','2019-10-24 13:14:50.308','17','-17', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4340','60','1396','50','972','140','1088','230','1096','2019-10-25 14:04:56.953','12','-12', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4350','70','1333','50','984','60','1408','150','828','2019-10-29 10:25:02.474','14','-14', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4360','90','1060','220','867','80','1007','100','958','2019-10-29 13:28:28.874','17','-17', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4370','130','893','70','1347','60','1394','150','814','2019-10-29 16:03:00.575','15','-15', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4380','150','799','70','1362','230','1084','100','941','2019-10-30 10:35:24.213','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4390','230','1071','70','1375','140','1076','90','1077','2019-10-30 13:43:16.825','10','-10', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4400','60','1379','150','812','230','1081','50','998','2019-10-31 12:17:56.513','13','-13', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4410','110','1125','140','1066','60','1392','50','985','2019-10-31 16:22:17.083','20','-20', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4420','220','884','90','1067','50','965','130','908','2019-11-01 12:31:01.34','14','-14', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4430','150','825','60','1372','100','928','210','844','2019-11-01 14:19:33.986','7','-7', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4440','220','898','70','1385','60','1379','100','921','2019-11-04 12:05:38.816','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4450','50','951','130','894','90','1081','210','837','2019-11-04 13:45:37.201','18','-18', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4460','60','1363','110','1145','70','1401','140','1086','2019-11-04 16:26:20.909','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4470','150','832','70','1385','50','969','220','914','2019-11-05 12:59:01.638','9','-9', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4480','60','1379','220','905','140','1070','50','960','2019-11-05 15:53:46.953','10','-10', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4490','110','1161','60','1389','70','1394','150','841','2019-11-05 20:44:23.939','9','-9', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4500','140','1060','120','1031','150','832','220','915','2019-11-06 13:30:41.325','9','-9', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4510','150','823','230','1068','70','1385','210','819','2019-11-06 13:57:41.732','9','-9', '3', '0', '1');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4520','150','814','90','1063','50','950','220','906','2019-11-07 16:15:51.246','16','-16', '3', '1', '0');
INSERT INTO "Matches"("Id","Team1Player1Id","Team1Player1Rating","Team1Player2Id","Team1Player2Rating","Team2Player1Id","Team2Player1Rating","Team2Player2Id","Team2Player2Rating","Date","WinningTeamRatingChange","LosingTeamRatingChange", "GameId", "Team1Score", "Team2Score") VALUES ('4530','90','1079','150','830','240','960','220','890','2019-11-08 12:16:44.265','15','-15', '3', '1', '0');
-- Shift Ids' Serials to avoid errors when inserting new rows
ALTER SEQUENCE "Users_Id_seq1" RESTART WITH 300;
ALTER SEQUENCE "Users_Id_seq" RESTART WITH 300;
ALTER SEQUENCE "Matches_Id_seq" RESTART WITH 5000;