-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlatest.sql
524 lines (457 loc) · 220 KB
/
latest.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
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
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
-- MySQL dump 10.13 Distrib 5.1.34, for apple-darwin9.5.0 (i386)
--
-- Host: localhost Database: stallcount9
-- ------------------------------------------------------
-- Server version 5.1.34
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `brackets`
--
DROP TABLE IF EXISTS `brackets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brackets` (
`nrteams` int(11) NOT NULL DEFAULT '0',
`nrrounds` int(11) NOT NULL DEFAULT '0',
`round` int(11) NOT NULL DEFAULT '0',
`matchnr` int(11) NOT NULL DEFAULT '0',
`home` int(11) DEFAULT NULL,
`away` int(11) DEFAULT NULL,
`winplace` int(11) DEFAULT NULL,
`loseplace` int(11) DEFAULT NULL,
PRIMARY KEY (`nrteams`,`nrrounds`,`round`,`matchnr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brackets`
--
LOCK TABLES `brackets` WRITE;
/*!40000 ALTER TABLE `brackets` DISABLE KEYS */;
INSERT INTO `brackets` VALUES (5,3,1,1,1,5,NULL,NULL),(5,3,1,2,4,2,NULL,NULL),(5,3,1,3,3,NULL,NULL,NULL),(5,3,2,1,1,3,NULL,NULL),(5,3,2,2,2,5,NULL,NULL),(5,3,2,3,4,NULL,NULL,NULL),(5,3,3,1,1,2,1,2),(5,3,3,2,4,3,3,4),(5,3,3,3,5,NULL,5,NULL),(8,3,1,1,1,8,NULL,NULL),(8,3,1,2,5,4,NULL,NULL),(8,3,1,3,6,3,NULL,NULL),(8,3,1,4,7,2,NULL,NULL),(8,3,2,1,1,4,NULL,NULL),(8,3,2,2,3,2,NULL,NULL),(8,3,2,3,8,5,NULL,NULL),(8,3,2,4,6,7,NULL,NULL),(8,3,3,1,1,2,1,2),(8,3,3,2,3,4,3,4),(8,3,3,3,5,6,5,6),(8,3,3,4,7,8,7,8),(9,3,1,1,1,8,NULL,NULL),(9,3,1,2,5,4,NULL,NULL),(9,3,1,3,6,3,NULL,NULL),(9,3,1,4,7,2,NULL,NULL),(9,3,1,5,9,NULL,NULL,NULL),(9,3,2,1,1,4,NULL,NULL),(9,3,2,2,3,2,NULL,NULL),(9,3,2,3,9,6,NULL,NULL),(9,3,2,4,8,7,NULL,NULL),(9,3,2,5,5,NULL,NULL,NULL),(9,3,3,1,1,2,1,2),(9,3,3,2,3,4,3,4),(9,3,3,3,5,7,5,6),(9,3,3,4,8,9,7,9),(9,3,3,5,6,NULL,8,NULL),(10,3,1,1,1,8,NULL,NULL),(10,3,1,2,6,3,NULL,NULL),(10,3,1,3,4,5,NULL,NULL),(10,3,1,4,7,2,NULL,NULL),(10,3,1,5,9,10,NULL,NULL),(10,3,2,1,1,3,NULL,NULL),(10,3,2,2,4,2,NULL,NULL),(10,3,2,3,6,8,NULL,NULL),(10,3,2,4,5,10,NULL,NULL),(10,3,2,5,7,9,NULL,NULL),(10,3,3,1,1,2,1,2),(10,3,3,2,3,4,3,4),(10,3,3,3,6,5,5,6),(10,3,3,4,7,8,7,8),(10,3,3,5,9,10,9,10);
/*!40000 ALTER TABLE `brackets` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `division`
--
DROP TABLE IF EXISTS `division`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `division` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tournament_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `tournament_id_idx` (`tournament_id`),
CONSTRAINT `division_tournament_id_tournament_id` FOREIGN KEY (`tournament_id`) REFERENCES `tournament` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `division`
--
LOCK TABLES `division` WRITE;
/*!40000 ALTER TABLE `division` DISABLE KEYS */;
INSERT INTO `division` VALUES (1,'open',1),(2,'mixed',1),(3,'women',1);
/*!40000 ALTER TABLE `division` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `field`
--
DROP TABLE IF EXISTS `field`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `field` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tournament_id` int(11) DEFAULT NULL,
`comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`rank` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `tournament_id_idx` (`tournament_id`),
CONSTRAINT `field_tournament_id_tournament_id` FOREIGN KEY (`tournament_id`) REFERENCES `tournament` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `field`
--
LOCK TABLES `field` WRITE;
/*!40000 ALTER TABLE `field` DISABLE KEYS */;
INSERT INTO `field` VALUES (1,'Field 1',1,'',1),(2,'Field 2',1,'',2),(3,'Field 3',1,'',3),(4,'Field 4',1,'',4),(5,'Field 5',1,'',5),(6,'Field 6',1,'',6),(7,'Field 7',1,'',7),(8,'Field 8',1,'',8),(9,'Field 9',1,'',9),(10,'Field 10',1,'',10),(11,'Field 11',1,'',11),(12,'Field 12',1,'artificial grass',12),(13,'Field 13',1,'artificial grass',13),(14,'Field 14',1,'',14),(15,'Field 15',1,'',15),(16,'Field 16',1,'',16),(17,'Field 17',1,'',17),(18,'Field 18',1,'',18),(19,'Field 19',1,'',19),(20,'Field 20',1,'',20);
/*!40000 ALTER TABLE `field` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pool`
--
DROP TABLE IF EXISTS `pool`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pool` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`currentround` int(11) DEFAULT '0',
`pool_ruleset_id` int(11) DEFAULT NULL,
`stage_id` int(11) DEFAULT NULL,
`spots` int(11) DEFAULT NULL,
`rank` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `pool_ruleset_id_idx` (`pool_ruleset_id`),
KEY `stage_id_idx` (`stage_id`),
CONSTRAINT `pool_pool_ruleset_id_pool_ruleset_id` FOREIGN KEY (`pool_ruleset_id`) REFERENCES `pool_ruleset` (`id`) ON DELETE CASCADE,
CONSTRAINT `pool_stage_id_stage_id` FOREIGN KEY (`stage_id`) REFERENCES `stage` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pool`
--
LOCK TABLES `pool` WRITE;
/*!40000 ALTER TABLE `pool` DISABLE KEYS */;
INSERT INTO `pool` VALUES (1,'Registration seeding',0,1,1,41,1),(2,'Swissdraw',6,2,2,42,1),(3,'Top Playoff',3,3,3,8,1),(4,'Upper Playoff',4,3,3,8,2),(5,'Middle Playoff',4,3,3,8,3),(6,'Lower Playoff',4,3,3,8,4),(7,'Playout',4,3,3,9,5),(8,'Registration seeding',0,1,4,28,1),(9,'Swissdraw',6,2,5,28,1),(10,'Top Playoff',4,3,6,8,1),(11,'Middle Playoff',4,3,6,8,2),(12,'Lower Playoff',4,3,6,8,3),(13,'Registration seeding',0,1,7,13,1),(14,'Playout',4,4,6,4,4),(15,'FlexPool',11,5,8,13,1);
/*!40000 ALTER TABLE `pool` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pool_move`
--
DROP TABLE IF EXISTS `pool_move`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pool_move` (
`pool_id` int(11) NOT NULL DEFAULT '0',
`source_pool_id` int(11) NOT NULL DEFAULT '0',
`sourcespot` int(11) NOT NULL DEFAULT '0',
`destinationspot` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`pool_id`,`source_pool_id`,`sourcespot`,`destinationspot`),
KEY `pool_move_source_pool_id_pool_id` (`source_pool_id`),
CONSTRAINT `pool_move_pool_id_pool_id` FOREIGN KEY (`pool_id`) REFERENCES `pool` (`id`) ON DELETE CASCADE,
CONSTRAINT `pool_move_source_pool_id_pool_id` FOREIGN KEY (`source_pool_id`) REFERENCES `pool` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pool_move`
--
LOCK TABLES `pool_move` WRITE;
/*!40000 ALTER TABLE `pool_move` DISABLE KEYS */;
INSERT INTO `pool_move` VALUES (2,1,1,1),(2,1,2,2),(2,1,3,3),(2,1,4,4),(2,1,5,5),(2,1,6,6),(2,1,7,7),(2,1,8,8),(2,1,9,9),(2,1,10,10),(2,1,11,11),(2,1,12,12),(2,1,13,13),(2,1,14,14),(2,1,15,15),(2,1,16,16),(2,1,17,17),(2,1,18,18),(2,1,19,19),(2,1,20,20),(2,1,21,21),(2,1,22,22),(2,1,23,23),(2,1,24,24),(2,1,25,25),(2,1,26,26),(2,1,27,27),(2,1,28,28),(2,1,29,29),(2,1,30,30),(2,1,31,31),(2,1,32,32),(2,1,33,33),(2,1,34,34),(2,1,35,35),(2,1,36,36),(2,1,37,37),(2,1,38,38),(2,1,39,39),(2,1,40,40),(2,1,41,41),(3,2,1,1),(3,2,2,2),(3,2,3,3),(3,2,4,4),(3,2,5,5),(3,2,6,6),(3,2,7,7),(3,2,8,8),(4,2,9,1),(4,2,10,2),(4,2,11,3),(4,2,12,4),(4,2,13,5),(4,2,14,6),(4,2,15,7),(4,2,16,8),(5,2,17,1),(5,2,18,2),(5,2,19,3),(5,2,20,4),(5,2,21,5),(5,2,22,6),(5,2,23,7),(5,2,24,8),(6,2,25,1),(6,2,26,2),(6,2,27,3),(6,2,28,4),(6,2,29,5),(6,2,30,6),(6,2,31,7),(6,2,32,8),(7,2,33,1),(7,2,34,2),(7,2,35,3),(7,2,36,4),(7,2,37,5),(7,2,38,6),(7,2,39,7),(7,2,40,8),(7,2,41,9),(9,8,1,1),(9,8,2,2),(9,8,3,3),(9,8,4,4),(9,8,5,5),(9,8,6,6),(9,8,7,7),(9,8,8,8),(9,8,9,9),(9,8,10,10),(9,8,11,11),(9,8,12,12),(9,8,13,13),(9,8,14,14),(9,8,15,15),(9,8,16,16),(9,8,17,17),(9,8,18,18),(9,8,19,19),(9,8,20,20),(9,8,21,21),(9,8,22,22),(9,8,23,23),(9,8,24,24),(9,8,25,25),(9,8,26,26),(9,8,27,27),(9,8,28,28),(10,9,1,1),(10,9,2,2),(10,9,3,3),(10,9,4,4),(10,9,5,5),(10,9,6,6),(10,9,7,7),(10,9,8,8),(11,9,9,1),(11,9,10,2),(11,9,11,3),(11,9,12,4),(11,9,13,5),(11,9,14,6),(11,9,15,7),(11,9,16,8),(12,9,17,1),(12,9,18,2),(12,9,19,3),(12,9,20,4),(12,9,21,5),(12,9,22,6),(12,9,23,7),(12,9,24,8),(14,9,25,1),(14,9,26,2),(14,9,27,3),(14,9,28,4),(15,13,1,1),(15,13,2,2),(15,13,3,3),(15,13,4,4),(15,13,5,5),(15,13,6,6),(15,13,7,7),(15,13,8,8),(15,13,9,9),(15,13,10,10),(15,13,11,11),(15,13,12,12),(15,13,13,13);
/*!40000 ALTER TABLE `pool_move` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pool_ruleset`
--
DROP TABLE IF EXISTS `pool_ruleset`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pool_ruleset` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`pool_strategy_id` int(11) DEFAULT NULL,
`numberofrounds` int(11) DEFAULT NULL,
`matchlength` int(11) DEFAULT NULL,
`qualificationcutoff` int(11) DEFAULT NULL,
`winningscore` int(11) DEFAULT NULL,
`byescore` int(11) DEFAULT NULL,
`byeagainst` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `pool_strategy_id_idx` (`pool_strategy_id`),
CONSTRAINT `pool_ruleset_pool_strategy_id_pool_strategy_id` FOREIGN KEY (`pool_strategy_id`) REFERENCES `pool_strategy` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pool_ruleset`
--
LOCK TABLES `pool_ruleset` WRITE;
/*!40000 ALTER TABLE `pool_ruleset` DISABLE KEYS */;
INSERT INTO `pool_ruleset` VALUES (1,'Setup',1,0,0,0,NULL,NULL,NULL),(2,'Swissdraw',2,5,90,0,15,12,15),(3,'Bracket',3,0,90,0,15,NULL,NULL),(4,'RoundRobin',4,0,90,0,15,NULL,NULL),(5,'FlexPool',5,0,90,0,15,NULL,NULL);
/*!40000 ALTER TABLE `pool_ruleset` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pool_strategy`
--
DROP TABLE IF EXISTS `pool_strategy`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pool_strategy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pool_strategy`
--
LOCK TABLES `pool_strategy` WRITE;
/*!40000 ALTER TABLE `pool_strategy` DISABLE KEYS */;
INSERT INTO `pool_strategy` VALUES (1,'ManualRanking','manually rank pool'),(2,'Swissdraw','Swissdraw matchmaking according to victory points'),(3,'Bracket','Bracket'),(4,'RoundRobin','RoundRobin'),(5,'FlexPool','flexible pool where you can make the matchups yourself');
/*!40000 ALTER TABLE `pool_strategy` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pool_team`
--
DROP TABLE IF EXISTS `pool_team`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pool_team` (
`pool_id` int(11) NOT NULL DEFAULT '0',
`team_id` int(11) NOT NULL DEFAULT '0',
`rank` int(11) DEFAULT NULL,
`seed` int(11) DEFAULT NULL,
PRIMARY KEY (`pool_id`,`team_id`),
KEY `pool_team_team_id_team_id` (`team_id`),
CONSTRAINT `pool_team_pool_id_pool_id` FOREIGN KEY (`pool_id`) REFERENCES `pool` (`id`) ON DELETE CASCADE,
CONSTRAINT `pool_team_team_id_team_id` FOREIGN KEY (`team_id`) REFERENCES `team` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pool_team`
--
LOCK TABLES `pool_team` WRITE;
/*!40000 ALTER TABLE `pool_team` DISABLE KEYS */;
INSERT INTO `pool_team` VALUES (1,1,19,1),(1,2,27,2),(1,3,34,3),(1,4,28,4),(1,5,25,5),(1,6,21,6),(1,7,36,7),(1,8,31,8),(1,9,20,9),(1,10,32,10),(1,11,22,11),(1,12,4,12),(1,13,41,13),(1,14,33,14),(1,15,15,15),(1,16,23,16),(1,17,16,17),(1,18,6,18),(1,19,1,19),(1,20,10,20),(1,21,8,21),(1,22,40,22),(1,23,14,23),(1,24,26,24),(1,25,39,25),(1,26,5,26),(1,27,18,27),(1,28,37,28),(1,29,3,29),(1,30,24,30),(1,31,7,31),(1,32,9,32),(1,33,30,33),(1,34,38,34),(1,35,2,35),(1,36,17,36),(1,37,12,37),(1,38,35,38),(1,39,13,39),(1,40,11,40),(1,41,29,41),(2,1,9,19),(2,2,12,27),(2,3,18,34),(2,4,28,28),(2,5,27,25),(2,6,29,21),(2,7,37,36),(2,8,41,31),(2,9,16,20),(2,10,26,32),(2,11,7,22),(2,12,14,4),(2,13,35,41),(2,14,6,33),(2,15,19,15),(2,16,13,23),(2,17,4,16),(2,18,17,6),(2,19,1,1),(2,20,24,10),(2,21,20,8),(2,22,39,40),(2,23,21,14),(2,24,15,26),(2,25,22,39),(2,26,10,5),(2,27,40,18),(2,28,42,37),(2,29,5,3),(2,30,30,24),(2,31,32,7),(2,32,3,9),(2,33,38,30),(2,34,36,38),(2,35,2,2),(2,36,11,17),(2,37,8,12),(2,38,31,35),(2,39,33,13),(2,40,23,11),(2,41,25,29),(2,42,34,42),(3,11,8,7),(3,14,5,6),(3,17,4,4),(3,19,1,1),(3,29,6,5),(3,32,2,3),(3,35,3,2),(3,37,7,8),(4,1,6,1),(4,2,2,4),(4,9,4,8),(4,12,3,6),(4,16,7,5),(4,24,8,7),(4,26,1,2),(4,36,5,3),(5,3,6,2),(5,15,2,3),(5,18,1,1),(5,20,5,8),(5,21,7,4),(5,23,4,5),(5,25,8,6),(5,40,3,7),(6,4,8,4),(6,5,7,3),(6,6,1,5),(6,10,5,2),(6,30,2,6),(6,31,3,8),(6,38,4,7),(6,41,6,1),(7,7,5,4),(7,8,7,8),(7,13,4,2),(7,22,8,6),(7,27,6,7),(7,28,9,9),(7,33,3,5),(7,34,1,3),(7,39,2,1),(8,43,6,1),(8,44,8,2),(8,45,9,3),(8,46,7,4),(8,47,2,5),(8,48,12,6),(8,49,23,7),(8,50,18,8),(8,51,14,9),(8,52,20,10),(8,53,16,11),(8,54,3,12),(8,55,19,13),(8,56,13,14),(8,57,22,15),(8,58,11,16),(8,59,10,17),(8,60,25,18),(8,61,21,19),(8,62,1,20),(8,63,15,21),(8,64,26,22),(8,65,17,23),(8,66,4,24),(8,67,27,25),(8,68,24,26),(8,69,5,27),(8,84,28,NULL),(9,43,22,6),(9,44,12,8),(9,45,15,9),(9,46,10,7),(9,47,1,2),(9,48,14,12),(9,49,13,23),(9,50,21,18),(9,51,5,14),(9,52,19,20),(9,53,20,16),(9,54,2,3),(9,55,9,19),(9,56,3,13),(9,57,26,22),(9,58,23,11),(9,59,6,10),(9,60,24,25),(9,61,17,21),(9,62,8,1),(9,63,25,15),(9,64,4,26),(9,65,16,17),(9,66,18,4),(9,67,11,27),(9,68,27,24),(9,69,7,5),(9,84,28,28),(10,47,2,1),(10,51,4,5),(10,54,1,2),(10,56,3,3),(10,59,5,6),(10,62,8,8),(10,64,6,4),(10,69,7,7),(11,44,8,4),(11,45,4,7),(11,46,7,2),(11,48,5,6),(11,49,1,5),(11,55,3,1),(11,65,6,8),(11,67,2,3),(12,43,8,6),(12,50,7,5),(12,52,3,3),(12,53,2,4),(12,58,6,7),(12,60,4,8),(12,61,5,1),(12,66,1,2),(13,70,13,1),(13,71,4,2),(13,72,5,3),(13,73,6,4),(13,74,7,5),(13,75,12,6),(13,76,8,7),(13,77,1,8),(13,78,11,9),(13,79,2,10),(13,80,3,11),(13,81,10,12),(13,82,9,13),(14,57,3,2),(14,63,1,1),(14,68,2,3),(14,84,4,4),(15,70,13,13),(15,71,4,4),(15,72,8,5),(15,73,5,6),(15,74,3,7),(15,75,11,12),(15,76,2,8),(15,77,1,1),(15,78,12,11),(15,79,6,2),(15,80,7,3),(15,81,10,10),(15,82,9,9);
/*!40000 ALTER TABLE `pool_team` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `round`
--
DROP TABLE IF EXISTS `round`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `round` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pool_id` int(11) DEFAULT NULL,
`matchlength` int(11) DEFAULT NULL,
`rank` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `pool_id_idx` (`pool_id`),
CONSTRAINT `round_pool_id_pool_id` FOREIGN KEY (`pool_id`) REFERENCES `pool` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `round`
--
LOCK TABLES `round` WRITE;
/*!40000 ALTER TABLE `round` DISABLE KEYS */;
INSERT INTO `round` VALUES (1,2,90,1),(2,2,90,2),(3,2,90,3),(4,2,90,4),(5,2,90,5),(6,3,90,1),(7,3,90,2),(8,3,90,3),(9,4,90,1),(10,4,90,2),(11,4,90,3),(12,5,90,1),(13,5,90,2),(14,5,90,3),(15,6,90,1),(16,6,90,2),(17,6,90,3),(18,7,90,1),(19,7,90,2),(20,7,90,3),(21,9,90,1),(22,9,90,2),(23,9,90,3),(24,9,90,4),(25,9,90,5),(26,10,90,1),(27,10,90,2),(28,10,90,3),(29,11,90,1),(30,11,90,2),(31,11,90,3),(32,12,90,1),(33,12,90,2),(34,12,90,3),(35,14,90,1),(36,14,90,2),(37,14,90,3),(38,15,NULL,1),(39,15,NULL,2),(40,15,NULL,3),(41,15,NULL,4),(42,15,NULL,5),(43,15,NULL,6),(44,15,NULL,7),(45,15,NULL,8),(46,15,NULL,9),(47,15,NULL,10);
/*!40000 ALTER TABLE `round` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `round_match`
--
DROP TABLE IF EXISTS `round_match`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `round_match` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`round_id` int(11) DEFAULT NULL,
`scheduledtime` bigint(20) DEFAULT NULL,
`field_id` int(11) DEFAULT NULL,
`matchname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`homename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`awayname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`rank` int(11) DEFAULT NULL,
`home_team_id` int(11) DEFAULT NULL,
`away_team_id` int(11) DEFAULT NULL,
`homescore` int(11) DEFAULT NULL,
`awayscore` int(11) DEFAULT NULL,
`homespirit` int(11) DEFAULT NULL,
`awayspirit` int(11) DEFAULT NULL,
`scoresubmittime` bigint(20) DEFAULT NULL,
`spiritsubmittime` bigint(20) DEFAULT NULL,
`bestpossiblerank` int(11) DEFAULT NULL,
`worstpossiblerank` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `field_id_idx` (`field_id`),
KEY `home_team_id_idx` (`home_team_id`),
KEY `away_team_id_idx` (`away_team_id`),
KEY `round_id_idx` (`round_id`),
CONSTRAINT `round_match_away_team_id_team_id` FOREIGN KEY (`away_team_id`) REFERENCES `team` (`id`) ON DELETE CASCADE,
CONSTRAINT `round_match_field_id_field_id` FOREIGN KEY (`field_id`) REFERENCES `field` (`id`) ON DELETE CASCADE,
CONSTRAINT `round_match_home_team_id_team_id` FOREIGN KEY (`home_team_id`) REFERENCES `team` (`id`) ON DELETE CASCADE,
CONSTRAINT `round_match_round_id_round_id` FOREIGN KEY (`round_id`) REFERENCES `round` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=341 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `round_match`
--
LOCK TABLES `round_match` WRITE;
/*!40000 ALTER TABLE `round_match` DISABLE KEYS */;
INSERT INTO `round_match` VALUES (1,1,1308302100,1,'Match rank 1','Seed 1','Seed 22',1,19,11,15,4,13,13,NULL,NULL,NULL,NULL),(2,1,1308302100,2,'Match rank 2','Seed 2','Seed 23',2,35,16,15,9,11,11,NULL,NULL,NULL,NULL),(3,1,1308302100,3,'Match rank 3','Seed 3','Seed 24',3,29,30,15,5,10,10,NULL,NULL,NULL,NULL),(4,1,1308302100,4,'Match rank 4','Seed 4','Seed 25',4,12,5,15,3,10,10,NULL,NULL,NULL,NULL),(5,1,1308302100,5,'Match rank 5','Seed 5','Seed 26',5,26,24,14,6,10,11,NULL,NULL,NULL,NULL),(6,1,1308302100,6,'Match rank 6','Seed 6','Seed 27',6,18,2,11,10,10,9,NULL,NULL,NULL,NULL),(7,1,1308302100,7,'Match rank 7','Seed 7','Seed 28',7,31,4,12,7,10,9,NULL,NULL,NULL,NULL),(8,1,1308302100,8,'Match rank 8','Seed 8','Seed 29',8,21,41,15,11,10,10,NULL,NULL,NULL,NULL),(9,1,1308302100,9,'Match rank 9','Seed 9','Seed 30',9,32,33,15,6,11,10,NULL,NULL,NULL,NULL),(10,1,1308302100,10,'Match rank 10','Seed 10','Seed 31',10,20,8,15,5,13,14,NULL,NULL,NULL,NULL),(11,1,1308302100,11,'Match rank 11','Seed 11','Seed 32',11,40,10,14,15,12,10,NULL,NULL,NULL,NULL),(12,1,1308302100,12,'Match rank 12','Seed 12','Seed 33',12,37,14,12,15,12,12,NULL,NULL,NULL,NULL),(13,1,1308302100,13,'Match rank 13','Seed 13','Seed 34',13,39,3,13,10,11,12,NULL,NULL,NULL,NULL),(14,1,1308302100,14,'Match rank 14','Seed 14','Seed 35',14,23,38,15,5,10,12,NULL,NULL,NULL,NULL),(15,1,1308302100,15,'Match rank 15','Seed 15','Seed 36',15,15,7,15,4,12,10,NULL,NULL,NULL,NULL),(16,1,1308302100,16,'Match rank 16','Seed 16','Seed 37',16,17,28,15,2,7,9,NULL,NULL,NULL,NULL),(17,1,1308302100,17,'Match rank 17','Seed 17','Seed 38',17,36,34,13,7,10,10,NULL,NULL,NULL,NULL),(18,1,1308302100,18,'Match rank 18','Seed 18','Seed 39',18,27,25,9,15,9,11,NULL,NULL,NULL,NULL),(19,1,1308302100,19,'Match rank 19','Seed 19','Seed 40',19,1,22,15,2,11,11,NULL,NULL,NULL,NULL),(20,1,1308302100,20,'Match rank 20','Seed 20','Seed 41',20,9,13,15,2,9,13,NULL,NULL,NULL,NULL),(21,1,1308302100,NULL,'BYE Match Round 1','Seed 21','BYE',21,6,42,15,12,NULL,NULL,NULL,NULL,NULL,NULL),(22,2,1308312000,20,'Match rank 1','Round 1 aprx rank 1','Round 1 aprx rank 2',1,17,1,15,9,4,8,NULL,NULL,NULL,NULL),(23,2,1308312000,19,'Match rank 2','Round 1 aprx rank 3','Round 1 aprx rank 4',2,9,12,7,15,10,12,NULL,NULL,NULL,NULL),(24,2,1308312000,18,'Match rank 3','Round 1 aprx rank 5','Round 1 aprx rank 6',3,19,15,15,9,10,12,NULL,NULL,NULL,NULL),(25,2,1308312000,17,'Match rank 4','Round 1 aprx rank 7','Round 1 aprx rank 8',4,29,20,15,8,6,8,NULL,NULL,NULL,NULL),(26,2,1308312000,16,'Match rank 5','Round 1 aprx rank 9','Round 1 aprx rank 10',5,23,32,9,15,12,9,NULL,NULL,NULL,NULL),(27,2,1308312000,15,'Match rank 6','Round 1 aprx rank 11','Round 1 aprx rank 12',6,26,35,8,15,10,12,NULL,NULL,NULL,NULL),(28,2,1308312000,14,'Match rank 7','Round 1 aprx rank 13','Round 1 aprx rank 14',7,25,36,4,15,11,9,NULL,NULL,NULL,NULL),(29,2,1308312000,13,'Match rank 8','Round 1 aprx rank 15','Round 1 aprx rank 16',8,31,21,15,9,10,8,NULL,NULL,NULL,NULL),(30,2,1308312000,12,'Match rank 9','Round 1 aprx rank 17','Round 1 aprx rank 18',9,6,14,9,15,10,10,NULL,NULL,NULL,NULL),(31,2,1308312000,3,'Match rank 10','Round 1 aprx rank 19','Round 1 aprx rank 20',10,39,10,15,12,9,11,NULL,NULL,NULL,NULL),(32,2,1308312000,10,'Match rank 11','Round 1 aprx rank 21','Round 1 aprx rank 22',11,18,40,15,3,9,10,NULL,NULL,NULL,NULL),(33,2,1308312000,9,'Match rank 12','Round 1 aprx rank 23','Round 1 aprx rank 24',12,2,37,13,15,12,9,NULL,NULL,NULL,NULL),(34,2,1308312000,8,'Match rank 13','Round 1 aprx rank 25','Round 1 aprx rank 26',13,41,4,15,12,9,12,NULL,NULL,NULL,NULL),(35,2,1308312000,7,'Match rank 14','Round 1 aprx rank 27','Round 1 aprx rank 28',14,27,16,4,15,8,10,NULL,NULL,NULL,NULL),(36,2,1308312000,6,'Match rank 15','Round 1 aprx rank 29','Round 1 aprx rank 30',15,34,24,9,15,10,12,NULL,NULL,NULL,NULL),(37,2,1308312000,5,'Match rank 16','Round 1 aprx rank 31','Round 1 aprx rank 32',16,33,30,5,15,7,9,NULL,NULL,NULL,NULL),(38,2,1308312000,4,'Match rank 17','Round 1 aprx rank 33','Round 1 aprx rank 34',17,8,38,3,15,10,12,NULL,NULL,NULL,NULL),(39,2,1308312000,11,'Match rank 18','Round 1 aprx rank 35','Round 1 aprx rank 36',18,11,7,15,10,14,15,NULL,NULL,NULL,NULL),(40,2,1308312000,2,'Match rank 19','Round 1 aprx rank 37','Round 1 aprx rank 38',19,5,28,15,6,10,11,NULL,NULL,NULL,NULL),(41,2,1308312000,1,'Match rank 20','Round 1 aprx rank 39','Round 1 aprx rank 40',20,22,13,9,15,12,9,NULL,NULL,NULL,NULL),(42,2,1308312000,NULL,'BYE Match Round 1','Round 1 team','BYE',21,42,3,12,15,NULL,NULL,NULL,NULL,NULL,NULL),(43,3,1308322800,11,'Match rank 1','Round 2 aprx rank 1','Round 2 aprx rank 2',1,12,29,14,8,10,11,NULL,NULL,NULL,NULL),(44,3,1308322800,12,'Match rank 2','Round 2 aprx rank 3','Round 2 aprx rank 4',2,19,36,15,5,10,12,NULL,NULL,NULL,NULL),(45,3,1308322800,13,'Match rank 3','Round 2 aprx rank 5','Round 2 aprx rank 6',3,17,32,12,15,8,13,NULL,NULL,NULL,NULL),(46,3,1308322800,14,'Match rank 4','Round 2 aprx rank 7','Round 2 aprx rank 8',4,35,31,15,6,9,11,NULL,NULL,NULL,NULL),(47,3,1308322800,15,'Match rank 5','Round 2 aprx rank 9','Round 2 aprx rank 10',5,18,14,8,15,9,12,NULL,NULL,NULL,NULL),(48,3,1308322800,6,'Match rank 6','Round 2 aprx rank 11','Round 2 aprx rank 12',6,39,23,9,15,10,10,NULL,NULL,NULL,NULL),(49,3,1308322800,17,'Match rank 7','Round 2 aprx rank 13','Round 2 aprx rank 14',7,15,1,12,15,11,10,NULL,NULL,NULL,NULL),(50,3,1308322800,18,'Match rank 8','Round 2 aprx rank 15','Round 2 aprx rank 16',8,16,20,14,11,15,11,NULL,NULL,NULL,NULL),(51,3,1308322800,19,'Match rank 9','Round 2 aprx rank 17','Round 2 aprx rank 18',9,9,26,6,15,5,4,NULL,NULL,NULL,NULL),(52,3,1308322800,20,'Match rank 10','Round 2 aprx rank 19','Round 2 aprx rank 20',10,3,30,15,10,14,10,NULL,NULL,NULL,NULL),(53,3,1308322800,1,'Match rank 11','Round 2 aprx rank 21','Round 2 aprx rank 22',11,38,37,9,15,12,10,NULL,NULL,NULL,NULL),(54,3,1308322800,2,'Match rank 12','Round 2 aprx rank 23','Round 2 aprx rank 24',12,41,10,10,15,8,11,NULL,NULL,NULL,NULL),(55,3,1308322800,3,'Match rank 13','Round 2 aprx rank 25','Round 2 aprx rank 26',13,21,24,6,15,10,12,NULL,NULL,NULL,NULL),(56,3,1308322800,4,'Match rank 14','Round 2 aprx rank 27','Round 2 aprx rank 28',14,2,6,13,15,8,9,NULL,NULL,NULL,NULL),(57,3,1308322800,5,'Match rank 15','Round 2 aprx rank 29','Round 2 aprx rank 30',15,5,25,11,13,10,12,NULL,NULL,NULL,NULL),(58,3,1308322800,16,'Match rank 16','Round 2 aprx rank 31','Round 2 aprx rank 32',16,13,4,8,15,11,12,NULL,NULL,NULL,NULL),(59,3,1308322800,7,'Match rank 17','Round 2 aprx rank 33','Round 2 aprx rank 34',17,34,40,5,15,8,10,NULL,NULL,NULL,NULL),(60,3,1308322800,8,'Match rank 18','Round 2 aprx rank 35','Round 2 aprx rank 36',18,7,27,10,11,13,11,NULL,NULL,NULL,NULL),(61,3,1308322800,9,'Match rank 19','Round 2 aprx rank 37','Round 2 aprx rank 38',19,33,22,14,12,2,12,NULL,NULL,NULL,NULL),(62,3,1308322800,10,'Match rank 20','Round 2 aprx rank 39','Round 2 aprx rank 40',20,28,8,2,15,13,11,NULL,NULL,NULL,NULL),(63,3,1308322800,NULL,'BYE Match Round 2','Round 2 team','BYE',21,11,42,15,12,NULL,NULL,NULL,NULL,NULL,NULL),(64,4,1308380400,1,'Match rank 1','Round 3 aprx rank 1','Round 3 aprx rank 2',1,19,12,14,10,11,NULL,NULL,NULL,NULL,NULL),(65,4,1308380400,2,'Match rank 2','Round 3 aprx rank 3','Round 3 aprx rank 4',2,35,32,12,9,9,8,NULL,NULL,NULL,NULL),(66,4,1308380400,3,'Match rank 3','Round 3 aprx rank 5','Round 3 aprx rank 6',3,14,17,14,15,8,4,NULL,NULL,NULL,NULL),(67,4,1308380400,10,'Match rank 4','Round 3 aprx rank 7','Round 3 aprx rank 8',4,29,26,13,5,12,13,NULL,NULL,NULL,NULL),(68,4,1308380400,14,'Match rank 5','Round 3 aprx rank 9','Round 3 aprx rank 10',5,23,16,10,13,11,12,NULL,NULL,NULL,NULL),(69,4,1308380400,15,'Match rank 6','Round 3 aprx rank 11','Round 3 aprx rank 12',6,1,24,10,14,12,8,NULL,NULL,NULL,NULL),(70,4,1308380400,16,'Match rank 7','Round 3 aprx rank 13','Round 3 aprx rank 14',7,36,37,10,12,12,11,NULL,NULL,NULL,NULL),(71,4,1308380400,11,'Match rank 8','Round 3 aprx rank 15','Round 3 aprx rank 16',8,3,18,4,15,10,11,NULL,NULL,NULL,NULL),(72,4,1308380400,19,'Match rank 9','Round 3 aprx rank 17','Round 3 aprx rank 18',9,10,31,11,10,9,7,NULL,NULL,NULL,NULL),(73,4,1308380400,4,'Match rank 10','Round 3 aprx rank 19','Round 3 aprx rank 20',10,15,39,12,14,NULL,10,NULL,NULL,NULL,NULL),(74,4,1308380400,17,'Match rank 11','Round 3 aprx rank 21','Round 3 aprx rank 22',11,20,6,13,9,10,12,NULL,NULL,NULL,NULL),(75,4,1308380400,18,'Match rank 12','Round 3 aprx rank 23','Round 3 aprx rank 24',12,4,11,2,15,14,10,NULL,NULL,NULL,NULL),(76,4,1308380400,13,'Match rank 13','Round 3 aprx rank 25','Round 3 aprx rank 26',13,40,25,15,7,10,NULL,NULL,NULL,NULL,NULL),(77,4,1308380400,5,'Match rank 14','Round 3 aprx rank 27','Round 3 aprx rank 28',14,2,30,15,8,9,12,NULL,NULL,NULL,NULL),(78,4,1308380400,6,'Match rank 15','Round 3 aprx rank 29','Round 3 aprx rank 30',15,5,38,6,13,7,10,NULL,NULL,NULL,NULL),(79,4,1308380400,7,'Match rank 16','Round 3 aprx rank 31','Round 3 aprx rank 32',16,41,9,7,14,12,7,NULL,NULL,NULL,NULL),(80,4,1308380400,8,'Match rank 17','Round 3 aprx rank 33','Round 3 aprx rank 34',17,8,13,6,15,13,13,NULL,NULL,NULL,NULL),(81,4,1308380400,9,'Match rank 18','Round 3 aprx rank 35','Round 3 aprx rank 36',18,27,33,6,14,10,10,NULL,NULL,NULL,NULL),(82,4,1308380400,12,'Match rank 19','Round 3 aprx rank 37','Round 3 aprx rank 38',19,7,22,15,4,12,13,NULL,NULL,NULL,NULL),(83,4,1308380400,20,'Match rank 20','Round 3 aprx rank 39','Round 3 aprx rank 40',20,34,28,15,3,12,12,NULL,NULL,NULL,NULL),(84,4,1308380400,NULL,'BYE Match Round 3','Round 3 team','BYE',21,42,21,12,15,NULL,NULL,NULL,NULL,NULL,NULL),(85,5,1308391200,2,'Match rank 1','Round 4 aprx rank 1','Round 4 aprx rank 2',1,19,35,13,14,10,NULL,NULL,NULL,NULL,NULL),(86,5,1308391200,12,'Match rank 2','Round 4 aprx rank 3','Round 4 aprx rank 4',2,12,32,5,15,10,9,NULL,NULL,NULL,NULL),(87,5,1308391200,11,'Match rank 3','Round 4 aprx rank 5','Round 4 aprx rank 6',3,29,14,12,11,12,7,NULL,NULL,NULL,NULL),(88,5,1308391200,18,'Match rank 4','Round 4 aprx rank 7','Round 4 aprx rank 8',4,18,17,6,13,11,10,NULL,NULL,NULL,NULL),(89,5,1308391200,19,'Match rank 5','Round 4 aprx rank 9','Round 4 aprx rank 10',5,24,16,10,11,10,13,NULL,NULL,NULL,NULL),(90,5,1308391200,1,'Match rank 6','Round 4 aprx rank 11','Round 4 aprx rank 12',6,23,37,6,12,11,7,NULL,NULL,NULL,NULL),(91,5,1308391200,3,'Match rank 7','Round 4 aprx rank 13','Round 4 aprx rank 14',7,11,40,15,8,NULL,11,NULL,NULL,NULL,NULL),(92,5,1308391200,14,'Match rank 8','Round 4 aprx rank 15','Round 4 aprx rank 16',8,36,20,15,7,12,13,NULL,NULL,NULL,NULL),(93,5,1308391200,13,'Match rank 9','Round 4 aprx rank 17','Round 4 aprx rank 18',9,10,1,4,15,10,16,NULL,NULL,NULL,NULL),(94,5,1308391200,10,'Match rank 10','Round 4 aprx rank 19','Round 4 aprx rank 20',10,26,39,15,1,NULL,7,NULL,NULL,NULL,NULL),(95,5,1308391200,16,'Match rank 11','Round 4 aprx rank 21','Round 4 aprx rank 22',11,2,31,15,4,10,10,NULL,NULL,NULL,NULL),(96,5,1308391200,17,'Match rank 12','Round 4 aprx rank 23','Round 4 aprx rank 24',12,38,9,5,15,14,12,NULL,NULL,NULL,NULL),(97,5,1308391200,4,'Match rank 13','Round 4 aprx rank 25','Round 4 aprx rank 26',13,15,6,15,11,10,8,NULL,NULL,NULL,NULL),(98,5,1308391200,5,'Match rank 14','Round 4 aprx rank 27','Round 4 aprx rank 28',14,13,3,5,15,12,10,NULL,NULL,NULL,NULL),(99,5,1308391200,6,'Match rank 15','Round 4 aprx rank 29','Round 4 aprx rank 30',15,7,21,4,15,10,9,NULL,NULL,NULL,NULL),(100,5,1308391200,7,'Match rank 16','Round 4 aprx rank 31','Round 4 aprx rank 32',16,33,25,4,15,9,12,NULL,NULL,NULL,NULL),(101,5,1308391200,8,'Match rank 17','Round 4 aprx rank 33','Round 4 aprx rank 34',17,34,5,8,13,9,8,NULL,NULL,NULL,NULL),(102,5,1308391200,9,'Match rank 18','Round 4 aprx rank 35','Round 4 aprx rank 36',18,41,8,14,5,13,10,NULL,NULL,NULL,NULL),(103,5,1308391200,15,'Match rank 19','Round 4 aprx rank 37','Round 4 aprx rank 38',19,4,27,14,8,12,11,NULL,NULL,NULL,NULL),(104,5,1308391200,20,'Match rank 20','Round 4 aprx rank 39','Round 4 aprx rank 40',20,22,28,15,8,11,14,NULL,NULL,NULL,NULL),(105,5,1308391200,NULL,'BYE Match Round 4','Round 4 team','BYE',21,30,42,15,12,NULL,0,NULL,NULL,NULL,NULL),(106,6,1308402000,10,'Quarterfinals 1','Team 1','Team 8',1,19,37,15,12,13,NULL,NULL,NULL,1,8),(107,6,1308402000,6,'Quarterfinals 2','Team 5','Team 4',2,29,17,8,13,10,4,NULL,NULL,1,8),(108,6,1308402000,14,'Quarterfinals 3','Team 6','Team 3',3,14,32,9,11,7,16,NULL,NULL,1,8),(109,6,1308402000,8,'Quarterfinals 4','Team 7','Team 2',4,11,35,5,12,9,9,NULL,NULL,1,8),(110,7,1308412800,1,'Semifinals 1','Winner Quarterfinals 1','Winner Quarterfinals 2',1,19,17,15,7,13,NULL,NULL,NULL,1,4),(111,7,1308412800,2,'Semifinals 2','Winner Quarterfinals 3','Winner Quarterfinals 4',2,32,35,12,8,NULL,14,NULL,NULL,1,4),(112,7,1308412800,6,'Semifinals 3','Loser Quarterfinals 1','Loser Quarterfinals 2',3,37,29,4,15,10,7,NULL,NULL,5,8),(113,7,1308412800,7,'Semifinals 4','Loser Quarterfinals 3','Loser Quarterfinals 4',4,14,11,14,4,16,11,NULL,NULL,5,8),(114,8,1308488400,3,'Finals 1','Winner Semifinals 1','Winner Semifinals 2',1,19,32,15,9,NULL,NULL,NULL,NULL,1,2),(115,8,1308472200,2,'Finals 2','Loser Semifinals 2','Loser Semifinals 1',2,35,17,15,13,NULL,NULL,NULL,NULL,3,4),(116,8,1308472200,4,'Finals 3','Winner Semifinals 3','Winner Semifinals 4',3,29,14,11,15,13,NULL,NULL,NULL,5,6),(117,8,1308472200,1,'Finals 4','Loser Semifinals 4','Loser Semifinals 3',4,11,37,8,15,11,11,NULL,NULL,7,8),(118,9,1308402000,9,'Quarterfinals 1','Team 1','Team 8',1,1,9,12,15,11,10,NULL,NULL,9,16),(119,9,1308402000,12,'Quarterfinals 2','Team 5','Team 4',2,16,2,2,15,12,11,NULL,NULL,9,16),(120,9,1308402000,5,'Quarterfinals 3','Team 6','Team 3',3,12,36,15,9,10,8,NULL,NULL,9,16),(121,9,1308402000,13,'Quarterfinals 4','Team 7','Team 2',4,24,26,4,15,7,9,NULL,NULL,9,16),(122,10,1308412800,8,'Semifinals 1','Winner Quarterfinals 1','Winner Quarterfinals 2',1,9,2,13,15,10,11,NULL,NULL,9,12),(123,10,1308412800,9,'Semifinals 2','Winner Quarterfinals 3','Winner Quarterfinals 4',2,12,26,11,12,11,10,NULL,NULL,9,12),(124,10,1308412800,17,'Semifinals 3','Loser Quarterfinals 1','Loser Quarterfinals 2',3,1,16,15,9,NULL,12,NULL,NULL,13,16),(125,10,1308412800,18,'Semifinals 4','Loser Quarterfinals 3','Loser Quarterfinals 4',4,36,24,15,2,10,10,NULL,NULL,13,16),(126,11,1308472200,5,'Finals 1','Winner Semifinals 1','Winner Semifinals 2',1,2,26,11,14,7,9,NULL,NULL,9,10),(127,11,1308472200,6,'Finals 2','Loser Semifinals 2','Loser Semifinals 1',2,12,9,15,8,12,9,NULL,NULL,11,12),(128,11,1308472200,7,'Finals 3','Winner Semifinals 3','Winner Semifinals 4',3,1,36,10,11,10,8,NULL,NULL,13,14),(129,11,1308472200,8,'Finals 4','Loser Semifinals 4','Loser Semifinals 3',4,24,16,8,9,12,9,NULL,NULL,15,16),(130,12,1308402000,7,'Quarterfinals 1','Team 1','Team 8',1,18,20,13,9,13,12,NULL,NULL,17,24),(131,12,1308402000,18,'Quarterfinals 2','Team 5','Team 4',2,23,21,15,7,10,13,NULL,NULL,17,24),(132,12,1308402000,19,'Quarterfinals 3','Team 6','Team 3',3,25,15,11,12,12,13,NULL,NULL,17,24),(133,12,1308402000,11,'Quarterfinals 4','Team 7','Team 2',4,40,3,15,8,11,NULL,NULL,NULL,17,24),(134,13,1308412800,13,'Semifinals 1','Winner Quarterfinals 1','Winner Quarterfinals 2',1,18,23,15,7,12,10,NULL,NULL,17,20),(135,13,1308412800,20,'Semifinals 2','Winner Quarterfinals 3','Winner Quarterfinals 4',2,15,40,14,6,NULL,9,NULL,NULL,17,20),(136,13,1308412800,10,'Semifinals 3','Loser Quarterfinals 1','Loser Quarterfinals 2',3,20,21,15,2,8,8,NULL,NULL,21,24),(137,13,1308412800,19,'Semifinals 4','Loser Quarterfinals 3','Loser Quarterfinals 4',4,25,3,10,15,10,12,NULL,NULL,21,24),(138,14,1308472200,9,'Finals 1','Winner Semifinals 1','Winner Semifinals 2',1,18,15,11,7,10,10,NULL,NULL,17,18),(139,14,1308472200,10,'Finals 2','Loser Semifinals 2','Loser Semifinals 1',2,40,23,13,8,12,NULL,NULL,NULL,19,20),(140,14,1308472200,12,'Finals 3','Winner Semifinals 3','Winner Semifinals 4',3,20,3,15,8,12,12,NULL,NULL,21,22),(141,14,1308472200,11,'Finals 4','Loser Semifinals 4','Loser Semifinals 3',4,25,21,10,13,10,10,NULL,NULL,23,24),(142,15,1308402000,2,'Quarterfinals 1','Team 1','Team 8',1,41,31,5,13,10,10,NULL,NULL,25,32),(143,15,1308402000,16,'Quarterfinals 2','Team 5','Team 4',2,6,4,15,5,9,13,NULL,NULL,25,32),(144,15,1308402000,17,'Quarterfinals 3','Team 6','Team 3',3,30,5,15,12,12,12,NULL,NULL,25,32),(145,15,1308402000,1,'Quarterfinals 4','Team 7','Team 2',4,38,10,15,5,11,7,NULL,NULL,25,32),(146,16,1308412800,14,'Semifinals 1','Winner Quarterfinals 1','Winner Quarterfinals 2',1,31,6,10,15,8,9,NULL,NULL,25,28),(147,16,1308412800,11,'Semifinals 2','Winner Quarterfinals 3','Winner Quarterfinals 4',2,30,38,14,11,10,13,NULL,NULL,25,28),(148,16,1308412800,12,'Semifinals 3','Loser Quarterfinals 1','Loser Quarterfinals 2',3,41,4,15,7,10,9,NULL,NULL,29,32),(149,16,1308412800,3,'Semifinals 4','Loser Quarterfinals 3','Loser Quarterfinals 4',4,5,10,11,15,7,7,NULL,NULL,29,32),(150,17,1308472200,13,'Finals 1','Winner Semifinals 1','Winner Semifinals 2',1,6,30,15,6,10,11,NULL,NULL,25,26),(151,17,1308472200,14,'Finals 2','Loser Semifinals 2','Loser Semifinals 1',2,38,31,7,15,4,11,NULL,NULL,27,28),(152,17,1308472200,15,'Finals 3','Winner Semifinals 3','Winner Semifinals 4',3,41,10,12,15,11,10,NULL,NULL,29,30),(153,17,1308472200,16,'Finals 4','Loser Semifinals 4','Loser Semifinals 3',4,5,4,15,11,11,NULL,NULL,NULL,31,32),(154,18,1308402000,15,'Quarterfinals 1','Team 1','Team 8',1,39,8,14,9,10,NULL,NULL,NULL,33,41),(155,18,1308402000,3,'Quarterfinals 2','Team 5','Team 4',2,33,7,14,11,10,9,NULL,NULL,33,38),(156,18,1308402000,4,'Quarterfinals 3','Team 6','Team 3',3,22,34,5,15,13,14,NULL,NULL,33,41),(157,18,1308402000,20,'Quarterfinals 4','Team 7','Team 2',4,27,13,6,10,13,8,NULL,NULL,33,41),(158,18,1308402000,NULL,'Quarterfinals BYE Match','Team 9','BYE',5,28,NULL,NULL,NULL,NULL,NULL,NULL,NULL,40,41),(159,19,1308412800,4,'Semifinals 1','Winner Quarterfinals 1','Winner Quarterfinals 2',1,39,33,15,6,11,NULL,NULL,NULL,33,36),(160,19,1308412800,5,'Semifinals 2','Winner Quarterfinals 3','Winner Quarterfinals 4',2,34,13,15,4,15,11,NULL,NULL,33,36),(161,19,1308412800,15,'Semifinals 3','Team 9','Loser Quarterfinals 3',3,28,22,7,14,15,14,NULL,NULL,40,41),(162,19,1308412800,16,'Semifinals 4','Loser Quarterfinals 1','Loser Quarterfinals 4',4,8,27,11,12,10,12,NULL,NULL,37,41),(163,19,1308412800,NULL,'Semifinals BYE Match','Loser Quarterfinals 2','BYE',5,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,37,38),(164,20,1308472200,17,'Finals 1','Winner Semifinals 1','Winner Semifinals 2',1,39,34,9,12,13,NULL,NULL,NULL,33,34),(165,20,1308472200,18,'Finals 2','Loser Semifinals 2','Loser Semifinals 1',2,13,33,8,15,10,8,NULL,NULL,35,36),(166,20,1308472200,19,'Finals 3','Loser Quarterfinals 2','Winner Semifinals 4',3,7,27,10,7,7,10,NULL,NULL,37,39),(167,20,1308472200,20,'Finals 4','Loser Semifinals 4','Loser Semifinals 3',4,8,28,15,2,NULL,15,NULL,NULL,40,41),(168,20,1308472200,NULL,'Finals BYE Match','Winner Semifinals 3','BYE',5,22,NULL,NULL,NULL,NULL,NULL,NULL,NULL,38,38),(169,21,1308297600,1,'Match rank 1','Seed 1','Seed 15',1,62,63,15,9,14,13,NULL,NULL,NULL,NULL),(170,21,1308297600,2,'Match rank 2','Seed 2','Seed 16',2,47,53,15,6,8,9,NULL,NULL,NULL,NULL),(171,21,1308297600,4,'Match rank 3','Seed 3','Seed 17',3,54,65,15,3,11,12,NULL,NULL,NULL,NULL),(172,21,1308297600,6,'Match rank 4','Seed 4','Seed 18',4,66,50,15,6,10,11,NULL,NULL,NULL,NULL),(173,21,1308297600,8,'Match rank 5','Seed 5','Seed 19',5,69,55,12,8,8,13,NULL,NULL,NULL,NULL),(174,21,1308297600,9,'Match rank 6','Seed 6','Seed 20',6,43,52,3,11,15,11,NULL,NULL,NULL,NULL),(175,21,1308297600,10,'Match rank 7','Seed 7','Seed 21',7,46,61,15,6,13,10,NULL,NULL,NULL,NULL),(176,21,1308297600,11,'Match rank 8','Seed 8','Seed 22',8,44,57,15,3,12,11,NULL,NULL,NULL,NULL),(177,21,1308297600,13,'Match rank 9','Seed 9','Seed 23',9,45,49,9,12,13,11,NULL,NULL,NULL,NULL),(178,21,1308297600,16,'Match rank 10','Seed 10','Seed 24',10,59,68,15,2,12,10,NULL,NULL,NULL,NULL),(179,21,1308297600,17,'Match rank 11','Seed 11','Seed 25',11,58,60,15,8,16,13,NULL,NULL,NULL,NULL),(180,21,1308297600,18,'Match rank 12','Seed 12','Seed 26',12,48,64,7,10,13,11,NULL,NULL,NULL,NULL),(181,21,1308297600,19,'Match rank 13','Seed 13','Seed 27',13,56,67,12,13,11,10,NULL,NULL,NULL,NULL),(182,21,1308297600,20,'Match rank 14','Seed 14','Seed 28',14,51,84,15,0,11,10,NULL,NULL,NULL,NULL),(183,22,1308306600,20,'Match rank 1','Round 1 aprx rank 1','Round 1 aprx rank 2',1,51,59,15,11,9,11,NULL,NULL,NULL,NULL),(184,22,1308306600,19,'Match rank 2','Round 1 aprx rank 3','Round 1 aprx rank 4',2,54,44,15,3,8,11,NULL,NULL,NULL,NULL),(185,22,1308306600,18,'Match rank 3','Round 1 aprx rank 5','Round 1 aprx rank 6',3,47,66,15,4,9,12,NULL,NULL,NULL,NULL),(186,22,1308306600,17,'Match rank 4','Round 1 aprx rank 7','Round 1 aprx rank 8',4,46,52,15,4,12,15,NULL,NULL,NULL,NULL),(187,22,1308306600,16,'Match rank 5','Round 1 aprx rank 9','Round 1 aprx rank 10',5,58,62,4,15,9,13,NULL,NULL,NULL,NULL),(188,22,1308306600,15,'Match rank 6','Round 1 aprx rank 11','Round 1 aprx rank 12',6,69,49,15,10,11,14,NULL,NULL,NULL,NULL),(189,22,1308306600,14,'Match rank 7','Round 1 aprx rank 13','Round 1 aprx rank 14',7,64,67,14,8,10,10,NULL,NULL,NULL,NULL),(190,22,1308306600,13,'Match rank 8','Round 1 aprx rank 15','Round 1 aprx rank 16',8,56,45,15,11,10,9,NULL,NULL,NULL,NULL),(191,22,1308306600,12,'Match rank 9','Round 1 aprx rank 17','Round 1 aprx rank 18',9,48,55,5,12,11,13,NULL,NULL,NULL,NULL),(192,22,1308306600,11,'Match rank 10','Round 1 aprx rank 19','Round 1 aprx rank 20',10,63,60,11,6,5,10,NULL,NULL,NULL,NULL),(193,22,1308306600,10,'Match rank 11','Round 1 aprx rank 21','Round 1 aprx rank 22',11,43,53,9,15,10,10,NULL,NULL,NULL,NULL),(194,22,1308306600,3,'Match rank 12','Round 1 aprx rank 23','Round 1 aprx rank 24',12,50,61,12,15,10,12,NULL,NULL,NULL,NULL),(195,22,1308306600,2,'Match rank 13','Round 1 aprx rank 25','Round 1 aprx rank 26',13,65,57,15,11,9,10,NULL,NULL,NULL,NULL),(196,22,1308306600,1,'Match rank 14','Round 1 aprx rank 27','Round 1 aprx rank 28',14,68,84,9,11,13,9,NULL,NULL,NULL,NULL),(197,23,1308317400,5,'Match rank 1','Round 2 aprx rank 1','Round 2 aprx rank 2',1,54,47,12,15,11,12,NULL,NULL,NULL,NULL),(198,23,1308317400,4,'Match rank 2','Round 2 aprx rank 3','Round 2 aprx rank 4',2,46,62,12,15,10,7,NULL,NULL,NULL,NULL),(199,23,1308317400,3,'Match rank 3','Round 2 aprx rank 5','Round 2 aprx rank 6',3,51,69,15,3,3,3,NULL,NULL,NULL,NULL),(200,23,1308317400,2,'Match rank 4','Round 2 aprx rank 7','Round 2 aprx rank 8',4,64,59,10,15,9,12,NULL,NULL,NULL,NULL),(201,23,1308317400,1,'Match rank 5','Round 2 aprx rank 9','Round 2 aprx rank 10',5,55,56,8,15,11,11,NULL,NULL,NULL,NULL),(202,23,1308317400,20,'Match rank 6','Round 2 aprx rank 11','Round 2 aprx rank 12',6,63,66,10,13,10,12,NULL,NULL,NULL,NULL),(203,23,1308317400,19,'Match rank 7','Round 2 aprx rank 13','Round 2 aprx rank 14',7,44,49,11,14,12,12,NULL,NULL,NULL,NULL),(204,23,1308317400,18,'Match rank 8','Round 2 aprx rank 15','Round 2 aprx rank 16',8,53,52,13,4,8,11,NULL,NULL,NULL,NULL),(205,23,1308317400,10,'Match rank 9','Round 2 aprx rank 17','Round 2 aprx rank 18',9,58,67,8,15,12,11,NULL,NULL,NULL,NULL),(206,23,1308317400,11,'Match rank 10','Round 2 aprx rank 19','Round 2 aprx rank 20',10,61,45,14,13,12,14,NULL,NULL,NULL,NULL),(207,23,1308317400,9,'Match rank 11','Round 2 aprx rank 21','Round 2 aprx rank 22',11,65,48,6,14,8,10,NULL,NULL,NULL,NULL),(208,23,1308317400,6,'Match rank 12','Round 2 aprx rank 23','Round 2 aprx rank 24',12,60,50,8,15,11,NULL,NULL,NULL,NULL,NULL),(209,23,1308317400,7,'Match rank 13','Round 2 aprx rank 25','Round 2 aprx rank 26',13,84,43,6,12,9,7,NULL,NULL,NULL,NULL),(210,23,1308317400,8,'Match rank 14','Round 2 aprx rank 27','Round 2 aprx rank 28',14,68,57,8,14,7,6,NULL,NULL,NULL,NULL),(211,24,1308385800,7,'Match rank 1','Round 3 aprx rank 1','Round 3 aprx rank 2',1,51,47,7,11,8,NULL,NULL,NULL,NULL,NULL),(212,24,1308385800,13,'Match rank 2','Round 3 aprx rank 3','Round 3 aprx rank 4',2,62,54,11,13,12,9,NULL,NULL,NULL,NULL),(213,24,1308385800,9,'Match rank 3','Round 3 aprx rank 5','Round 3 aprx rank 6',3,46,59,4,10,11,4,NULL,NULL,NULL,NULL),(214,24,1308385800,1,'Match rank 4','Round 3 aprx rank 7','Round 3 aprx rank 8',4,56,53,14,9,10,6,NULL,NULL,NULL,NULL),(215,24,1308385800,2,'Match rank 5','Round 3 aprx rank 9','Round 3 aprx rank 10',5,64,66,13,6,9,10,NULL,NULL,NULL,NULL),(216,24,1308385800,3,'Match rank 6','Round 3 aprx rank 11','Round 3 aprx rank 12',6,67,49,8,10,12,12,NULL,NULL,NULL,NULL),(217,24,1308385800,16,'Match rank 7','Round 3 aprx rank 13','Round 3 aprx rank 14',7,48,69,9,14,10,8,NULL,NULL,NULL,NULL),(218,24,1308385800,18,'Match rank 8','Round 3 aprx rank 15','Round 3 aprx rank 16',8,55,63,15,7,10,11,NULL,NULL,NULL,NULL),(219,24,1308385800,4,'Match rank 9','Round 3 aprx rank 17','Round 3 aprx rank 18',9,44,61,13,12,11,10,NULL,NULL,NULL,NULL),(220,24,1308385800,8,'Match rank 10','Round 3 aprx rank 19','Round 3 aprx rank 20',10,50,45,7,15,10,7,NULL,NULL,NULL,NULL),(221,24,1308385800,5,'Match rank 11','Round 3 aprx rank 21','Round 3 aprx rank 22',11,43,57,11,6,8,9,NULL,NULL,NULL,NULL),(222,24,1308385800,6,'Match rank 12','Round 3 aprx rank 23','Round 3 aprx rank 24',12,58,52,12,7,12,12,NULL,NULL,NULL,NULL),(223,24,1308385800,19,'Match rank 13','Round 3 aprx rank 25','Round 3 aprx rank 26',13,65,84,15,4,10,10,NULL,NULL,NULL,NULL),(224,24,1308385800,20,'Match rank 14','Round 3 aprx rank 27','Round 3 aprx rank 28',14,60,68,9,6,11,7,NULL,NULL,NULL,NULL),(225,25,1308396600,10,'Match rank 1','Round 4 aprx rank 1','Round 4 aprx rank 2',1,47,59,15,12,11,12,NULL,NULL,NULL,NULL),(226,25,1308396600,11,'Match rank 2','Round 4 aprx rank 3','Round 4 aprx rank 4',2,51,54,8,14,11,NULL,NULL,NULL,NULL,NULL),(227,25,1308396600,17,'Match rank 3','Round 4 aprx rank 5','Round 4 aprx rank 6',3,62,56,8,15,7,7,NULL,NULL,NULL,NULL),(228,25,1308396600,19,'Match rank 4','Round 4 aprx rank 7','Round 4 aprx rank 8',4,64,46,14,9,6,15,NULL,NULL,NULL,NULL),(229,25,1308396600,7,'Match rank 5','Round 4 aprx rank 9','Round 4 aprx rank 10',5,55,49,10,7,10,9,NULL,NULL,NULL,NULL),(230,25,1308396600,8,'Match rank 6','Round 4 aprx rank 11','Round 4 aprx rank 12',6,69,53,15,5,9,12,NULL,NULL,NULL,NULL),(231,25,1308396600,9,'Match rank 7','Round 4 aprx rank 13','Round 4 aprx rank 14',7,67,45,15,13,12,10,NULL,NULL,NULL,NULL),(232,25,1308396600,12,'Match rank 8','Round 4 aprx rank 15','Round 4 aprx rank 16',8,43,44,4,10,8,9,NULL,NULL,NULL,NULL),(233,25,1308396600,18,'Match rank 9','Round 4 aprx rank 17','Round 4 aprx rank 18',9,66,61,12,13,8,10,NULL,NULL,NULL,NULL),(234,25,1308396600,13,'Match rank 10','Round 4 aprx rank 19','Round 4 aprx rank 20',10,58,65,11,15,11,9,NULL,NULL,NULL,NULL),(235,25,1308396600,14,'Match rank 11','Round 4 aprx rank 21','Round 4 aprx rank 22',11,48,63,11,5,11,11,NULL,NULL,NULL,NULL),(236,25,1308396600,15,'Match rank 12','Round 4 aprx rank 23','Round 4 aprx rank 24',12,57,60,4,10,11,11,NULL,NULL,NULL,NULL),(237,25,1308396600,20,'Match rank 13','Round 4 aprx rank 25','Round 4 aprx rank 26',13,50,68,11,7,6,9,NULL,NULL,NULL,NULL),(238,25,1308396600,16,'Match rank 14','Round 4 aprx rank 27','Round 4 aprx rank 28',14,52,84,15,4,15,15,NULL,NULL,NULL,NULL),(239,26,1308407400,1,'Quarterfinals 1','Team 1','Team 8',1,47,62,14,6,9,10,NULL,NULL,1,8),(240,26,1308407400,2,'Quarterfinals 2','Team 5','Team 4',2,51,64,15,5,1,NULL,NULL,NULL,1,8),(241,26,1308407400,3,'Quarterfinals 3','Team 6','Team 3',3,59,56,8,13,16,8,NULL,NULL,1,8),(242,26,1308481200,4,'Quarterfinals 4','Team 7','Team 2',4,69,54,7,15,11,11,NULL,NULL,1,8),(243,27,1308466800,1,'Semifinals 1','Winner Quarterfinals 1','Winner Quarterfinals 2',1,47,51,15,7,NULL,10,NULL,NULL,1,4),(244,27,1308466800,18,'Semifinals 2','Winner Quarterfinals 3','Winner Quarterfinals 4',2,56,54,7,15,NULL,NULL,NULL,NULL,1,4),(245,27,1308466800,6,'Semifinals 3','Loser Quarterfinals 1','Loser Quarterfinals 2',3,62,64,11,14,14,10,NULL,NULL,5,8),(246,27,1308466800,12,'Semifinals 4','Loser Quarterfinals 3','Loser Quarterfinals 4',4,59,69,15,5,13,10,NULL,NULL,5,8),(247,28,1308481200,6,'Finals 1','Winner Semifinals 1','Winner Semifinals 2',1,47,54,5,15,0,12,NULL,NULL,1,2),(248,28,1308477600,2,'Finals 2','Loser Semifinals 2','Loser Semifinals 1',2,56,51,15,12,NULL,NULL,NULL,NULL,3,4),(249,28,1308477600,1,'Finals 3','Winner Semifinals 3','Winner Semifinals 4',3,64,59,13,15,10,0,NULL,NULL,5,6),(250,28,1308477600,10,'Finals 4','Loser Semifinals 4','Loser Semifinals 3',4,69,62,15,4,8,8,NULL,NULL,7,8),(251,29,1308407400,11,'Quarterfinals 1','Team 1','Team 8',1,55,65,15,2,10,8,NULL,NULL,9,16),(252,29,1308407400,15,'Quarterfinals 2','Team 5','Team 4',2,49,44,15,5,9,13,NULL,NULL,9,16),(253,29,1308407400,16,'Quarterfinals 3','Team 6','Team 3',3,48,67,7,10,11,5,NULL,NULL,9,16),(254,29,1308407400,14,'Quarterfinals 4','Team 7','Team 2',4,45,46,12,11,5,8,NULL,NULL,9,16),(255,30,1308466800,19,'Semifinals 1','Winner Quarterfinals 1','Winner Quarterfinals 2',1,55,49,10,15,NULL,10,NULL,NULL,9,12),(256,30,1308466800,7,'Semifinals 2','Winner Quarterfinals 3','Winner Quarterfinals 4',2,67,45,11,10,NULL,12,NULL,NULL,9,12),(257,30,1308466800,15,'Semifinals 3','Loser Quarterfinals 1','Loser Quarterfinals 2',3,65,44,15,8,10,10,NULL,NULL,13,16),(258,30,1308466800,13,'Semifinals 4','Loser Quarterfinals 3','Loser Quarterfinals 4',4,48,46,11,10,7,13,NULL,NULL,13,16),(259,31,1308477600,13,'Finals 1','Winner Semifinals 1','Winner Semifinals 2',1,49,67,15,12,0,0,NULL,NULL,9,10),(260,31,1308477600,11,'Finals 2','Loser Semifinals 2','Loser Semifinals 1',2,45,55,5,15,12,NULL,NULL,NULL,11,12),(261,31,1308477600,12,'Finals 3','Winner Semifinals 3','Winner Semifinals 4',3,65,48,12,15,6,8,NULL,NULL,13,14),(262,31,1308477600,14,'Finals 4','Loser Semifinals 4','Loser Semifinals 3',4,46,44,15,12,8,13,NULL,NULL,15,16),(263,32,1308407400,12,'Quarterfinals 1','Team 1','Team 8',1,61,60,8,13,5,7,NULL,NULL,17,24),(264,32,1308407400,13,'Quarterfinals 2','Team 5','Team 4',2,50,53,12,15,10,9,NULL,NULL,17,24),(265,32,1308407400,17,'Quarterfinals 3','Team 6','Team 3',3,43,52,6,12,13,10,NULL,NULL,17,24),(266,32,1308407400,18,'Quarterfinals 4','Team 7','Team 2',4,58,66,3,15,12,11,NULL,NULL,17,24),(267,33,1308466800,11,'Semifinals 1','Winner Quarterfinals 1','Winner Quarterfinals 2',1,60,53,7,10,10,11,NULL,NULL,17,20),(268,33,1308466800,10,'Semifinals 2','Winner Quarterfinals 3','Winner Quarterfinals 4',2,52,66,5,15,12,15,NULL,NULL,17,20),(269,33,1308466800,14,'Semifinals 3','Loser Quarterfinals 1','Loser Quarterfinals 2',3,61,50,15,11,10,10,NULL,NULL,21,24),(270,33,1308466800,8,'Semifinals 4','Loser Quarterfinals 3','Loser Quarterfinals 4',4,43,58,10,11,3,NULL,NULL,NULL,21,24),(271,34,1308477600,15,'Finals 1','Winner Semifinals 1','Winner Semifinals 2',1,53,66,11,14,10,10,NULL,NULL,17,18),(272,34,1308477600,16,'Finals 2','Loser Semifinals 2','Loser Semifinals 1',2,52,60,15,9,14,17,NULL,NULL,19,20),(273,34,1308477600,17,'Finals 3','Winner Semifinals 3','Winner Semifinals 4',3,61,58,15,10,15,13,NULL,NULL,21,22),(274,34,1308477600,18,'Finals 4','Loser Semifinals 4','Loser Semifinals 3',4,43,50,4,15,6,NULL,NULL,NULL,23,24),(275,35,1308407400,19,'Match rank 1','Team 1','Team 3',1,57,68,5,6,2,8,NULL,NULL,25,28),(276,35,1308407400,20,'Match rank 2','Team 2','Team 4',2,63,84,12,4,10,9,NULL,NULL,25,28),(277,36,1308466800,20,'Match rank 1','Team 1','Team 4',1,57,84,15,7,11,12,NULL,NULL,25,28),(278,36,1308466800,2,'Match rank 2','Team 3','Team 2',2,68,63,8,15,8,11,NULL,NULL,25,28),(279,37,1308477600,19,'Match rank 1','Team 1','Team 2',1,57,63,7,15,9,11,NULL,NULL,25,28),(280,37,1308477600,20,'Match rank 2','Team 4','Team 3',2,84,68,10,12,12,NULL,NULL,NULL,25,28),(281,38,1308297600,5,'Match rank 2',NULL,NULL,2,79,71,14,6,8,14,NULL,NULL,NULL,NULL),(282,38,1308297600,7,'Match rank 3',NULL,NULL,3,72,74,12,8,9,11,NULL,NULL,NULL,NULL),(283,38,1308297600,12,'Match rank 4',NULL,NULL,4,73,76,7,11,10,11,NULL,NULL,NULL,NULL),(284,38,1308297600,14,'Match rank 5',NULL,NULL,5,82,78,10,11,10,12,NULL,NULL,NULL,NULL),(285,38,1308297600,15,'Match rank 6',NULL,NULL,6,81,75,8,12,10,8,NULL,NULL,NULL,NULL),(286,38,1308297600,NULL,'Match rank 7',NULL,NULL,7,70,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(287,38,1308297600,3,'Match rank 1',NULL,NULL,1,77,80,10,9,11,10,NULL,NULL,NULL,NULL),(288,39,1308306600,5,'Match rank 2',NULL,NULL,2,72,82,13,8,6,6,NULL,NULL,NULL,NULL),(289,39,1308306600,6,'Match rank 3',NULL,NULL,3,80,78,15,1,13,12,NULL,NULL,NULL,NULL),(290,39,1308306600,7,'Match rank 4',NULL,NULL,4,76,75,15,4,9,9,NULL,NULL,NULL,NULL),(291,39,1308306600,8,'Match rank 5',NULL,NULL,5,77,70,15,0,10,10,NULL,NULL,NULL,NULL),(292,39,1308306600,9,'Match rank 6',NULL,NULL,6,71,81,15,7,10,9,NULL,NULL,NULL,NULL),(293,39,1308306600,NULL,'Match rank 7',NULL,NULL,7,74,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(294,39,1308306600,4,'Match rank 1',NULL,NULL,1,79,73,13,12,8,13,NULL,NULL,NULL,NULL),(295,40,1308317400,13,'Match rank 2',NULL,NULL,2,72,73,11,10,12,9,NULL,NULL,NULL,NULL),(296,40,1308317400,14,'Match rank 3',NULL,NULL,3,80,76,13,14,8,8,NULL,NULL,NULL,NULL),(297,40,1308317400,15,'Match rank 4',NULL,NULL,4,78,75,8,14,9,9,NULL,NULL,NULL,NULL),(298,40,1308317400,16,'Match rank 5',NULL,NULL,5,77,74,10,12,13,10,NULL,NULL,NULL,NULL),(299,40,1308317400,17,'Match rank 6',NULL,NULL,6,81,70,12,8,9,10,NULL,NULL,NULL,NULL),(300,40,1308317400,NULL,'Match rank 7',NULL,NULL,7,71,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(301,40,1308317400,12,'Match rank 1',NULL,NULL,1,79,82,15,5,11,13,NULL,NULL,NULL,NULL),(302,41,1308328200,4,'Match rank 2',NULL,NULL,2,71,70,15,1,11,10,NULL,NULL,NULL,NULL),(303,41,1308328200,3,'Match rank 1',NULL,NULL,1,74,81,15,3,9,8,NULL,NULL,NULL,NULL),(304,42,1308385800,11,'Match rank 2',NULL,NULL,2,73,82,15,8,10,6,NULL,NULL,NULL,NULL),(305,42,1308385800,12,'Match rank 3',NULL,NULL,3,80,75,15,7,12,13,NULL,NULL,NULL,NULL),(306,42,1308385800,14,'Match rank 4',NULL,NULL,4,77,81,14,2,8,NULL,NULL,NULL,NULL,NULL),(307,42,1308385800,15,'Match rank 5',NULL,NULL,5,71,74,12,11,11,7,NULL,NULL,NULL,NULL),(308,42,1308385800,17,'Match rank 6',NULL,NULL,6,76,78,15,4,17,10,NULL,NULL,NULL,NULL),(309,42,1308385800,NULL,'Match rank 7',NULL,NULL,7,70,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(310,42,1308385800,10,'Match rank 1',NULL,NULL,1,79,72,10,8,NULL,14,NULL,NULL,NULL,NULL),(311,43,1308396600,2,'Match rank 2',NULL,NULL,2,76,72,12,11,10,9,NULL,NULL,NULL,NULL),(312,43,1308396600,3,'Match rank 3',NULL,NULL,3,73,75,15,3,5,9,NULL,NULL,NULL,NULL),(313,43,1308396600,4,'Match rank 4',NULL,NULL,4,82,78,14,5,10,9,NULL,NULL,NULL,NULL),(314,43,1308396600,5,'Match rank 5',NULL,NULL,5,77,71,13,6,6,NULL,NULL,NULL,NULL,NULL),(315,43,1308396600,6,'Match rank 6',NULL,NULL,6,74,70,15,0,10,10,NULL,NULL,NULL,NULL),(316,43,1308396600,NULL,'Match rank 7',NULL,NULL,7,81,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(317,43,1308396600,1,'Match rank 1',NULL,NULL,1,79,80,12,8,12,14,NULL,NULL,NULL,NULL),(318,44,1308407400,6,'Match rank 2',NULL,NULL,2,79,71,12,15,10,14,NULL,NULL,NULL,NULL),(319,44,1308407400,7,'Match rank 3',NULL,NULL,3,76,80,14,9,4,9,NULL,NULL,NULL,NULL),(320,44,1308407400,8,'Match rank 4',NULL,NULL,4,74,72,14,8,14,5,NULL,NULL,NULL,NULL),(321,44,1308407400,9,'Match rank 5',NULL,NULL,5,81,82,6,13,10,9,NULL,NULL,NULL,NULL),(322,44,1308407400,10,'Match rank 6',NULL,NULL,6,75,70,15,4,10,15,NULL,NULL,NULL,NULL),(323,44,1308407400,NULL,'Match rank 7',NULL,NULL,7,78,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(324,44,1308407400,5,'Match rank 1',NULL,NULL,1,77,73,11,8,14,NULL,NULL,NULL,NULL,NULL),(325,45,1308466800,4,'Match rank 2',NULL,NULL,2,78,70,15,2,12,13,NULL,NULL,NULL,NULL),(326,45,1308466800,5,'Match rank 3',NULL,NULL,3,75,81,4,15,8,10,NULL,NULL,NULL,NULL),(327,45,1308466800,9,'Match rank 4',NULL,NULL,4,77,74,15,4,9,NULL,NULL,NULL,NULL,NULL),(328,45,1308466800,16,'Match rank 5',NULL,NULL,5,72,73,9,15,8,NULL,NULL,NULL,NULL,NULL),(329,45,1308466800,17,'Match rank 6',NULL,NULL,6,80,79,11,15,14,13,NULL,NULL,NULL,NULL),(330,45,1308466800,NULL,'Match rank 7',NULL,NULL,7,82,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(331,45,1308466800,3,'Match rank 1',NULL,NULL,1,71,76,7,15,NULL,5,NULL,NULL,NULL,NULL),(332,46,1308477600,5,'Match rank 2',NULL,NULL,2,73,79,15,14,13,10,NULL,NULL,NULL,NULL),(333,46,1308477600,6,'Match rank 3',NULL,NULL,3,81,78,11,9,13,11,NULL,NULL,NULL,NULL),(334,46,1308477600,8,'Match rank 4',NULL,NULL,4,75,82,13,15,7,6,NULL,NULL,NULL,NULL),(335,46,1308477600,9,'Match rank 5',NULL,NULL,5,72,80,5,15,13,NULL,NULL,NULL,NULL,NULL),(336,46,1308477600,NULL,'Match rank 6',NULL,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(337,46,1308477600,NULL,'Match rank 7',NULL,NULL,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(338,46,1308477600,4,'Match rank 1',NULL,NULL,1,74,71,15,5,12,13,NULL,NULL,NULL,NULL),(339,47,1308481200,10,'Match rank 2',NULL,NULL,2,82,70,8,1,14,13,NULL,NULL,NULL,NULL),(340,47,1308484800,7,'Match rank 1',NULL,NULL,1,77,76,15,12,0,0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `round_match` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `s_m_s`
--
DROP TABLE IF EXISTS `s_m_s`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `s_m_s` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`team_id` int(11) DEFAULT NULL,
`round_id` int(11) DEFAULT NULL,
`tournament_id` int(11) DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci,
`status` int(11) DEFAULT NULL,
`createtime` bigint(20) DEFAULT NULL,
`submittime` bigint(20) DEFAULT NULL,
`senttime` bigint(20) DEFAULT NULL,
`receivedtime` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `tournament_id_idx` (`tournament_id`),
KEY `team_id_idx` (`team_id`),
KEY `round_id_idx` (`round_id`),
CONSTRAINT `s_m_s_round_id_round_id` FOREIGN KEY (`round_id`) REFERENCES `round` (`id`) ON DELETE CASCADE,
CONSTRAINT `s_m_s_team_id_team_id` FOREIGN KEY (`team_id`) REFERENCES `team` (`id`) ON DELETE CASCADE,
CONSTRAINT `s_m_s_tournament_id_tournament_id` FOREIGN KEY (`tournament_id`) REFERENCES `tournament` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=924 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `s_m_s`
--
LOCK TABLES `s_m_s` WRITE;
/*!40000 ALTER TABLE `s_m_s` DISABLE KEYS */;
INSERT INTO `s_m_s` VALUES (43,19,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Rebel on Field 1 at 11:15',NULL,1308259856,NULL,NULL,NULL),(44,11,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Flying Angels on Field 1 at 11:15',NULL,1308259856,NULL,NULL,NULL),(45,35,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Solebang on Field 2 at 11:15',NULL,1308259856,NULL,NULL,NULL),(46,16,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Freespeed on Field 2 at 11:15',NULL,1308259856,NULL,NULL,NULL),(47,29,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Sun on Field 3 at 11:15',NULL,1308259856,NULL,NULL,NULL),(48,30,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Denmark on Field 3 at 11:15',NULL,1308259857,NULL,NULL,NULL),(49,12,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play KoBOld on Field 4 at 11:15',NULL,1308259857,NULL,NULL,NULL),(50,5,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Silence on Field 4 at 11:15',NULL,1308259857,NULL,NULL,NULL),(51,26,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Gummibaerchen on Field 5 at 11:15',NULL,1308259857,NULL,NULL,NULL),(52,24,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Russia on Field 5 at 11:15',NULL,1308259857,NULL,NULL,NULL),(53,18,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play FranceMaster on Field 6 at 11:15',NULL,1308259857,NULL,NULL,NULL),(54,2,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play M.U.C. on Field 6 at 11:15',NULL,1308259857,NULL,NULL,NULL),(55,31,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Carapedos on Field 7 at 11:15',NULL,1308259857,NULL,NULL,NULL),(56,4,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Friselis on Field 7 at 11:15',NULL,1308259857,NULL,NULL,NULL),(57,21,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play German Masters on Field 8 at 11:15',NULL,1308259857,NULL,NULL,NULL),(58,41,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Iznogood on Field 8 at 11:15',NULL,1308259857,NULL,NULL,NULL),(59,32,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Barbastreji on Field 9 at 11:15',NULL,1308259857,NULL,NULL,NULL),(60,33,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play 7Schwaben on Field 9 at 11:15',NULL,1308259857,NULL,NULL,NULL),(61,20,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Xlr8rs on Field 10 at 11:15',NULL,1308259857,NULL,NULL,NULL),(62,8,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Spain on Field 10 at 11:15',NULL,1308259857,NULL,NULL,NULL),(63,40,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play MAM on Field 11 at 11:15',NULL,1308259857,NULL,NULL,NULL),(64,10,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Netherlands on Field 11 at 11:15',NULL,1308259857,NULL,NULL,NULL),(65,37,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Pissotte on Field 12 at 11:15',NULL,1308259857,NULL,NULL,NULL),(66,14,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Red Lights on Field 12 at 11:15',NULL,1308259857,NULL,NULL,NULL),(67,39,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Rainbow Warriors on Field 13 at 11:15',NULL,1308259857,NULL,NULL,NULL),(68,3,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Cambo Cakes on Field 13 at 11:15',NULL,1308259857,NULL,NULL,NULL),(69,23,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Les etoiles o on Field 14 at 11:15',NULL,1308259857,NULL,NULL,NULL),(70,38,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play German Junior on Field 14 at 11:15',NULL,1308259857,NULL,NULL,NULL),(71,15,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Tsunami on Field 15 at 11:15',NULL,1308259857,NULL,NULL,NULL),(72,7,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play theBigEz on Field 15 at 11:15',NULL,1308259857,NULL,NULL,NULL),(73,17,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Soimii on Field 16 at 11:15',NULL,1308259857,NULL,NULL,NULL),(74,28,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Bologna on Field 16 at 11:15',NULL,1308259857,NULL,NULL,NULL),(75,36,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play deLux on Field 17 at 11:15',NULL,1308259857,NULL,NULL,NULL),(76,34,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Flying Bisc on Field 17 at 11:15',NULL,1308259857,NULL,NULL,NULL),(77,27,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Panthers on Field 18 at 11:15',NULL,1308259857,NULL,NULL,NULL),(78,25,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Buggoli on Field 18 at 11:15',NULL,1308259857,NULL,NULL,NULL),(79,1,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play UL Ninjas on Field 19 at 11:15',NULL,1308259857,NULL,NULL,NULL),(80,22,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Gentle on Field 19 at 11:15',NULL,1308259857,NULL,NULL,NULL),(81,9,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Funatics on Field 20 at 11:15',NULL,1308259857,NULL,NULL,NULL),(82,13,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Mooncatchers on Field 20 at 11:15',NULL,1308259857,NULL,NULL,NULL),(83,6,1,1,'Welcome to Windmill Windup 2011!In round 1,you can take a break due to the odd number of teams.You\'ll score a 15-12 win',NULL,1308259857,NULL,NULL,NULL),(84,42,1,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Hardfisch on Field at 11:15',NULL,1308259857,NULL,NULL,NULL),(85,62,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Moscow on Field 1 at 10:00',NULL,1308259947,NULL,NULL,NULL),(86,63,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Frizzly Bears on Field 1 at 10:00',NULL,1308259947,NULL,NULL,NULL),(87,47,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Nuts\'nBerries on Field 2 at 10:00',NULL,1308259947,NULL,NULL,NULL),(88,53,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play France on Field 2 at 10:00',NULL,1308259947,NULL,NULL,NULL),(89,54,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Frisbee Family on Field 4 at 10:00',NULL,1308259947,NULL,NULL,NULL),(90,65,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Germany on Field 4 at 10:00',NULL,1308259947,NULL,NULL,NULL),(91,66,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Cheek2Cheek on Field 6 at 10:00',NULL,1308259947,NULL,NULL,NULL),(92,50,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Switzerland on Field 6 at 10:00',NULL,1308259947,NULL,NULL,NULL),(93,69,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Robiram on Field 8 at 10:00',NULL,1308259947,NULL,NULL,NULL),(94,55,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Russia on Field 8 at 10:00',NULL,1308259947,NULL,NULL,NULL),(95,43,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Rusty Bikes on Field 9 at 10:00',NULL,1308259947,NULL,NULL,NULL),(96,52,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Disco Stu on Field 9 at 10:00',NULL,1308259948,NULL,NULL,NULL),(97,46,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Cranberry on Field 10 at 10:00',NULL,1308259948,NULL,NULL,NULL),(98,61,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Quijotes on Field 10 at 10:00',NULL,1308259948,NULL,NULL,NULL),(99,44,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play WAF on Field 11 at 10:00',NULL,1308259948,NULL,NULL,NULL),(100,57,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Superfly on Field 11 at 10:00',NULL,1308259948,NULL,NULL,NULL),(101,45,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Spirit on Lemon on Field 13 at 10:00',NULL,1308259948,NULL,NULL,NULL),(102,49,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play PUF on Field 13 at 10:00',NULL,1308259948,NULL,NULL,NULL),(103,59,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Aye-Aye on Field 16 at 10:00',NULL,1308259948,NULL,NULL,NULL),(104,68,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Ireland on Field 16 at 10:00',NULL,1308259948,NULL,NULL,NULL),(105,58,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Turkey on Field 17 at 10:00',NULL,1308259948,NULL,NULL,NULL),(106,60,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Akka on Field 17 at 10:00',NULL,1308259948,NULL,NULL,NULL),(107,48,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Sexy Legs on Field 18 at 10:00',NULL,1308259948,NULL,NULL,NULL),(108,64,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Stockholm on Field 18 at 10:00',NULL,1308259948,NULL,NULL,NULL),(109,56,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Drehst\'nDeckel on Field 19 at 10:00',NULL,1308259948,NULL,NULL,NULL),(110,67,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Holland on Field 19 at 10:00',NULL,1308259948,NULL,NULL,NULL),(111,51,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play on Field 20 at 10:00',NULL,1308259948,NULL,NULL,NULL),(112,84,21,1,'Welcome to Windmill Windup 2011!In round 1,you\'ll play Austria on Field 20 at 10:00',NULL,1308259948,NULL,NULL,NULL),(113,77,38,1,'Welcome to Windmill Windup 2011!you\'ll play Switzerland on Field 3 at 10:00',NULL,1308260039,NULL,NULL,NULL),(114,80,38,1,'Welcome to Windmill Windup 2011!you\'ll play GB on Field 3 at 10:00',NULL,1308260039,NULL,NULL,NULL),(115,79,38,1,'Welcome to Windmill Windup 2011!you\'ll play Hot Beaches on Field 5 at 10:00',NULL,1308260039,NULL,NULL,NULL),(116,71,38,1,'Welcome to Windmill Windup 2011!you\'ll play Germany on Field 5 at 10:00',NULL,1308260039,NULL,NULL,NULL),(117,72,38,1,'Welcome to Windmill Windup 2011!you\'ll play Ireland on Field 7 at 10:00',NULL,1308260039,NULL,NULL,NULL),(118,74,38,1,'Welcome to Windmill Windup 2011!you\'ll play France on Field 7 at 10:00',NULL,1308260039,NULL,NULL,NULL),(119,73,38,1,'Welcome to Windmill Windup 2011!you\'ll play Italy on Field 12 at 10:00',NULL,1308260039,NULL,NULL,NULL),(120,76,38,1,'Welcome to Windmill Windup 2011!you\'ll play Denmark on Field 12 at 10:00',NULL,1308260039,NULL,NULL,NULL),(121,82,38,1,'Welcome to Windmill Windup 2011!you\'ll play Thalys on Field 14 at 10:00',NULL,1308260039,NULL,NULL,NULL),(122,78,38,1,'Welcome to Windmill Windup 2011!you\'ll play Russia on Field 14 at 10:00',NULL,1308260039,NULL,NULL,NULL),(123,81,38,1,'Welcome to Windmill Windup 2011!you\'ll play Seagulls on Field 15 at 10:00',NULL,1308260040,NULL,NULL,NULL),(124,75,38,1,'Welcome to Windmill Windup 2011!you\'ll play Holland on Field 15 at 10:00',NULL,1308260040,NULL,NULL,NULL),(125,70,38,1,'Welcome to Windmill Windup 2011!due to the odd number of teams,you can take a break at 10:00',NULL,1308260040,NULL,NULL,NULL),(126,51,22,1,'After a 15-0 win in round 1, you are now ranked 1st.In round 2,you\'ll play Ireland(ranked 2nd) on Field 20 at 12:30',NULL,1308303502,NULL,NULL,NULL),(127,59,22,1,'After a 15-2 win in round 1, you are now ranked 2nd.In round 2,you\'ll play Austria(ranked 1st) on Field 20 at 12:30',NULL,1308303502,NULL,NULL,NULL),(128,54,22,1,'After a 15-3 win in round 1, you are now ranked 3rd.In round 2,you\'ll play Superfly(ranked 4th) on Field 19 at 12:30',NULL,1308303502,NULL,NULL,NULL),(129,44,22,1,'After a 15-3 win in round 1, you are now ranked 4th.In round 2,you\'ll play Germany(ranked 3rd) on Field 19 at 12:30',NULL,1308303502,NULL,NULL,NULL),(130,47,22,1,'After a 15-6 win in round 1, you are now ranked 5th.In round 2,you\'ll play Switzerland(ranked 6th) on Field 18 at 12:30',NULL,1308303502,NULL,NULL,NULL),(131,66,22,1,'After a 15-6 win in round 1, you are now ranked 6th.In round 2,you\'ll play France(ranked 5th) on Field 18 at 12:30',NULL,1308303502,NULL,NULL,NULL),(132,46,22,1,'After a 15-6 win in round 1, you are now ranked 7th.In round 2,you\'ll play Rusty Bikes(ranked 8th) on Field 17 at 12:30',NULL,1308303502,NULL,NULL,NULL),(133,52,22,1,'After a 11-3 win in round 1, you are now ranked 8th.In round 2,you\'ll play Quijotes(ranked 7th) on Field 17 at 12:30',NULL,1308303502,NULL,NULL,NULL),(134,58,22,1,'After a 15-8 win in round 1, you are now ranked 9th.In round 2,you\'ll play Frizzly Bears(ranked 10th) on Field 16 at 12:30',NULL,1308303502,NULL,NULL,NULL),(135,62,22,1,'After a 15-9 win in round 1, you are now ranked 10th.In round 2,you\'ll play Akka(ranked 9th) on Field 16 at 12:30',NULL,1308303502,NULL,NULL,NULL),(136,69,22,1,'After a 12-8 win in round 1, you are now ranked 11th.In round 2,you\'ll play Spirit on Lemon(ranked 12th) on Field 15 at 12:30',NULL,1308303502,NULL,NULL,NULL),(137,49,22,1,'After a 12-9 win in round 1, you are now ranked 12th.In round 2,you\'ll play Russia(ranked 11th) on Field 15 at 12:30',NULL,1308303502,NULL,NULL,NULL),(138,64,22,1,'After a 10-7 win in round 1, you are now ranked 13th.In round 2,you\'ll play Drehst\'nDeckel(ranked 14th) on Field 14 at 12:30',NULL,1308303502,NULL,NULL,NULL),(139,67,22,1,'After a 13-12 win in round 1, you are now ranked 14th.In round 2,you\'ll play Sexy Legs(ranked 13th) on Field 14 at 12:30',NULL,1308303502,NULL,NULL,NULL),(140,56,22,1,'After a 12-13 loss in round 1, you are now ranked 15th.In round 2,you\'ll play PUF(ranked 16th) on Field 13 at 12:30',NULL,1308303502,NULL,NULL,NULL),(141,45,22,1,'After a 9-12 loss in round 1, you are now ranked 16th.In round 2,you\'ll play Holland(ranked 15th) on Field 13 at 12:30',NULL,1308303502,NULL,NULL,NULL),(142,48,22,1,'After a 7-10 loss in round 1, you are now ranked 17th.In round 2,you\'ll play Robiram(ranked 18th) on Field 12 at 12:30',NULL,1308303502,NULL,NULL,NULL),(143,55,22,1,'After a 8-12 loss in round 1, you are now ranked 18th.In round 2,you\'ll play Stockholm(ranked 17th) on Field 12 at 12:30',NULL,1308303502,NULL,NULL,NULL),(144,63,22,1,'After a 9-15 loss in round 1, you are now ranked 19th.In round 2,you\'ll play Turkey(ranked 20th) on Field 11 at 12:30',NULL,1308303502,NULL,NULL,NULL),(145,60,22,1,'After a 8-15 loss in round 1, you are now ranked 20th.In round 2,you\'ll play Moscow(ranked 19th) on Field 11 at 12:30',NULL,1308303502,NULL,NULL,NULL),(146,43,22,1,'After a 3-11 loss in round 1, you are now ranked 21st.In round 2,you\'ll play Nuts\'nBerries(ranked 22nd) on Field 10 at 12:30',NULL,1308303502,NULL,NULL,NULL),(147,53,22,1,'After a 6-15 loss in round 1, you are now ranked 22nd.In round 2,you\'ll play Disco Stu(ranked 21st) on Field 10 at 12:30',NULL,1308303502,NULL,NULL,NULL),(148,50,22,1,'After a 6-15 loss in round 1, you are now ranked 23rd.In round 2,you\'ll play Cranberry(ranked 24th) on Field 3 at 12:30',NULL,1308303503,NULL,NULL,NULL),(149,61,22,1,'After a 6-15 loss in round 1, you are now ranked 24th.In round 2,you\'ll play Cheek2Cheek(ranked 23rd) on Field 3 at 12:30',NULL,1308303503,NULL,NULL,NULL),(150,65,22,1,'After a 3-15 loss in round 1, you are now ranked 25th.In round 2,you\'ll play WAF(ranked 26th) on Field 2 at 12:30',NULL,1308303503,NULL,NULL,NULL),(151,57,22,1,'After a 3-15 loss in round 1, you are now ranked 26th.In round 2,you\'ll play Frisbee Family(ranked 25th) on Field 2 at 12:30',NULL,1308303503,NULL,NULL,NULL),(152,68,22,1,'After a 2-15 loss in round 1, you are now ranked 27th.In round 2,you\'ll play (ranked 28th) on Field 1 at 12:30',NULL,1308303503,NULL,NULL,NULL),(153,84,22,1,'After a 0-15 loss in round 1, you are now ranked 28th.In round 2,you\'ll play Aye-Aye(ranked 27th) on Field 1 at 12:30',NULL,1308303503,NULL,NULL,NULL),(154,79,39,1,'After a 14-6 win in the previous round, you\'ll play Denmark on Field 4 at 12:30',NULL,1308305197,NULL,NULL,NULL),(155,73,39,1,'After a 7-11 loss in the previous round, you\'ll play Germany on Field 4 at 12:30',NULL,1308305198,NULL,NULL,NULL),(156,72,39,1,'After a 12-8 win in the previous round, you\'ll play Russia on Field 5 at 12:30',NULL,1308305198,NULL,NULL,NULL),(157,82,39,1,'After a 10-11 loss in the previous round, you\'ll play France on Field 5 at 12:30',NULL,1308305198,NULL,NULL,NULL),(158,80,39,1,'After a 9-10 loss in the previous round, you\'ll play Thalys on Field 6 at 12:30',NULL,1308305198,NULL,NULL,NULL),(159,78,39,1,'After a 11-10 win in the previous round, you\'ll play Switzerland on Field 6 at 12:30',NULL,1308305198,NULL,NULL,NULL),(160,76,39,1,'After a 11-7 win in the previous round, you\'ll play Seagulls on Field 7 at 12:30',NULL,1308305198,NULL,NULL,NULL),(161,75,39,1,'After a 12-8 win in the previous round, you\'ll play Italy on Field 7 at 12:30',NULL,1308305198,NULL,NULL,NULL),(162,77,39,1,'After a 10-9 win in the previous round, you\'ll play Chakalakas on Field 8 at 12:30',NULL,1308305198,NULL,NULL,NULL),(163,70,39,1,'After a break in the previous round, you\'ll play GB on Field 8 at 12:30',NULL,1308305198,NULL,NULL,NULL),(164,71,39,1,'After a 6-14 loss in the previous round, you\'ll play Holland on Field 9 at 12:30',NULL,1308305198,NULL,NULL,NULL),(165,81,39,1,'After a 8-12 loss in the previous round, you\'ll play Hot Beaches on Field 9 at 12:30',NULL,1308305198,NULL,NULL,NULL),(166,74,39,1,'After a 8-12 loss in the previous round, due to the odd number of teams,you can take a break at 12:30',NULL,1308305198,NULL,NULL,NULL),(167,17,2,1,'After a 15-2 win in round 1, you are now ranked 1st.In round 2,you\'ll play Gentle(ranked 2nd) on Field 20 at 14:00',NULL,1308308042,NULL,NULL,NULL),(168,1,2,1,'After a 15-2 win in round 1, you are now ranked 2nd.In round 2,you\'ll play Bologna(ranked 1st) on Field 20 at 14:00',NULL,1308308042,NULL,NULL,NULL),(169,9,2,1,'After a 15-2 win in round 1, you are now ranked 3rd.In round 2,you\'ll play Silence(ranked 4th) on Field 19 at 14:00',NULL,1308308042,NULL,NULL,NULL),(170,12,2,1,'After a 15-3 win in round 1, you are now ranked 4th.In round 2,you\'ll play Mooncatchers(ranked 3rd) on Field 19 at 14:00',NULL,1308308042,NULL,NULL,NULL),(171,19,2,1,'After a 15-4 win in round 1, you are now ranked 5th.In round 2,you\'ll play theBigEz(ranked 6th) on Field 18 at 14:00',NULL,1308308042,NULL,NULL,NULL),(172,15,2,1,'After a 15-4 win in round 1, you are now ranked 6th.In round 2,you\'ll play Flying Angels(ranked 5th) on Field 18 at 14:00',NULL,1308308042,NULL,NULL,NULL),(173,29,2,1,'After a 15-5 win in round 1, you are now ranked 7th.In round 2,you\'ll play Spain(ranked 8th) on Field 17 at 14:00',NULL,1308308042,NULL,NULL,NULL),(174,20,2,1,'After a 15-5 win in round 1, you are now ranked 8th.In round 2,you\'ll play Denmark(ranked 7th) on Field 17 at 14:00',NULL,1308308042,NULL,NULL,NULL),(175,23,2,1,'After a 15-5 win in round 1, you are now ranked 9th.In round 2,you\'ll play 7Schwaben(ranked 10th) on Field 16 at 14:00',NULL,1308308042,NULL,NULL,NULL),(176,32,2,1,'After a 15-6 win in round 1, you are now ranked 10th.In round 2,you\'ll play German Junior(ranked 9th) on Field 16 at 14:00',NULL,1308308042,NULL,NULL,NULL),(177,26,2,1,'After a 14-6 win in round 1, you are now ranked 11th.In round 2,you\'ll play Freespeed(ranked 12th) on Field 15 at 14:00',NULL,1308308042,NULL,NULL,NULL),(178,35,2,1,'After a 15-9 win in round 1, you are now ranked 12th.In round 2,you\'ll play Russia(ranked 11th) on Field 15 at 14:00',NULL,1308308042,NULL,NULL,NULL),(179,25,2,1,'After a 15-9 win in round 1, you are now ranked 13th.In round 2,you\'ll play Flying Bisc(ranked 14th) on Field 14 at 14:00',NULL,1308308042,NULL,NULL,NULL),(180,36,2,1,'After a 13-7 win in round 1, you are now ranked 14th.In round 2,you\'ll play Panthers(ranked 13th) on Field 14 at 14:00',NULL,1308308042,NULL,NULL,NULL),(181,31,2,1,'After a 12-7 win in round 1, you are now ranked 15th.In round 2,you\'ll play Iznogood(ranked 16th) on Field 13 at 14:00',NULL,1308308042,NULL,NULL,NULL),(182,21,2,1,'After a 15-11 win in round 1, you are now ranked 16th.In round 2,you\'ll play Friselis(ranked 15th) on Field 13 at 14:00',NULL,1308308042,NULL,NULL,NULL),(183,6,2,1,'After a 15-12 win in round 1, you are now ranked 17th.In round 2,you\'ll play Pissotte(ranked 18th) on Field 12 at 14:00',NULL,1308308042,NULL,NULL,NULL),(184,14,2,1,'After a 15-12 win in round 1, you are now ranked 18th.In round 2,you\'ll play Hardfisch(ranked 17th) on Field 12 at 14:00',NULL,1308308042,NULL,NULL,NULL),(185,39,2,1,'After a 13-10 win in round 1, you are now ranked 19th.In round 2,you\'ll play MAM(ranked 20th) on Field 3 at 14:00',NULL,1308308042,NULL,NULL,NULL),(186,10,2,1,'After a 15-14 win in round 1, you are now ranked 20th.In round 2,you\'ll play Cambo Cakes(ranked 19th) on Field 3 at 14:00',NULL,1308308042,NULL,NULL,NULL),(187,18,2,1,'After a 11-10 win in round 1, you are now ranked 21st.In round 2,you\'ll play Netherlands(ranked 22nd) on Field 10 at 14:00',NULL,1308308042,NULL,NULL,NULL),(188,40,2,1,'After a 14-15 loss in round 1, you are now ranked 22nd.In round 2,you\'ll play M.U.C.(ranked 21st) on Field 10 at 14:00',NULL,1308308042,NULL,NULL,NULL),(189,2,2,1,'After a 10-11 loss in round 1, you are now ranked 23rd.In round 2,you\'ll play Red Lights(ranked 24th) on Field 9 at 14:00',NULL,1308308042,NULL,NULL,NULL),(190,37,2,1,'After a 12-15 loss in round 1, you are now ranked 24th.In round 2,you\'ll play FranceMaster(ranked 23rd) on Field 9 at 14:00',NULL,1308308042,NULL,NULL,NULL),(191,41,2,1,'After a 11-15 loss in round 1, you are now ranked 27th.In round 2,you\'ll play Carapedos(ranked 28th) on Field 8 at 14:00',NULL,1308308042,NULL,NULL,NULL),(192,4,2,1,'After a 7-12 loss in round 1, you are now ranked 28th.In round 2,you\'ll play German Masters(ranked 27th) on Field 8 at 14:00',NULL,1308308042,NULL,NULL,NULL),(193,27,2,1,'After a 9-15 loss in round 1, you are now ranked 29th.In round 2,you\'ll play Solebang(ranked 30th) on Field 7 at 14:00',NULL,1308308042,NULL,NULL,NULL),(194,16,2,1,'After a 9-15 loss in round 1, you are now ranked 30th.In round 2,you\'ll play Buggoli(ranked 29th) on Field 7 at 14:00',NULL,1308308043,NULL,NULL,NULL),(195,34,2,1,'After a 7-13 loss in round 1, you are now ranked 31st.In round 2,you\'ll play Gummibaerchen(ranked 32nd) on Field 6 at 14:00',NULL,1308308043,NULL,NULL,NULL),(196,24,2,1,'After a 6-14 loss in round 1, you are now ranked 32nd.In round 2,you\'ll play deLux(ranked 31st) on Field 6 at 14:00',NULL,1308308043,NULL,NULL,NULL),(197,33,2,1,'After a 6-15 loss in round 1, you are now ranked 33rd.In round 2,you\'ll play Sun(ranked 34th) on Field 5 at 14:00',NULL,1308308043,NULL,NULL,NULL),(198,30,2,1,'After a 5-15 loss in round 1, you are now ranked 34th.In round 2,you\'ll play Barbastreji(ranked 33rd) on Field 5 at 14:00',NULL,1308308043,NULL,NULL,NULL),(199,8,2,1,'After a 5-15 loss in round 1, you are now ranked 35th.In round 2,you\'ll play Les etoiles o(ranked 36th) on Field 4 at 14:00',NULL,1308308043,NULL,NULL,NULL),(200,38,2,1,'After a 5-15 loss in round 1, you are now ranked 36th.In round 2,you\'ll play Xlr8rs(ranked 35th) on Field 4 at 14:00',NULL,1308308043,NULL,NULL,NULL),(201,11,2,1,'After a 4-15 loss in round 1, you are now ranked 37th.In round 2,you\'ll play Tsunami(ranked 38th) on Field 11 at 14:00',NULL,1308308043,NULL,NULL,NULL),(202,7,2,1,'After a 4-15 loss in round 1, you are now ranked 38th.In round 2,you\'ll play Rebel(ranked 37th) on Field 11 at 14:00',NULL,1308308043,NULL,NULL,NULL),(203,5,2,1,'After a 3-15 loss in round 1, you are now ranked 39th.In round 2,you\'ll play Soimii(ranked 40th) on Field 2 at 14:00',NULL,1308308043,NULL,NULL,NULL),(204,28,2,1,'After a 2-15 loss in round 1, you are now ranked 40th.In round 2,you\'ll play KoBOld(ranked 39th) on Field 2 at 14:00',NULL,1308308043,NULL,NULL,NULL),(205,22,2,1,'After a 2-15 loss in round 1, you are now ranked 41st.In round 2,you\'ll play Funatics(ranked 42nd) on Field 1 at 14:00',NULL,1308308043,NULL,NULL,NULL),(206,13,2,1,'After a 2-15 loss in round 1, you are now ranked 42nd.In round 2,you\'ll play UL Ninjas(ranked 41st) on Field 1 at 14:00',NULL,1308308043,NULL,NULL,NULL),(207,42,2,1,'After a 12-15 loss in round 1, you are now ranked 25th.In round 2,you\'ll play Rainbow Warriors(ranked 26th) on Field at 14:00',NULL,1308308043,NULL,NULL,NULL),(208,3,2,1,'After a 10-13 loss in round 1, you are now ranked 26th.In round 2,you can take a break due to the odd number of teams.You\'ll score a 15-12 win',NULL,1308308043,NULL,NULL,NULL),(209,79,40,1,'After a 13-12 win in the previous round, you\'ll play Russia on Field 12 at 15:30',NULL,1308312474,NULL,NULL,NULL),(210,82,40,1,'After a 8-13 loss in the previous round, you\'ll play Germany on Field 12 at 15:30',NULL,1308312474,NULL,NULL,NULL),(211,72,40,1,'After a 13-8 win in the previous round, you\'ll play Denmark on Field 13 at 15:30',NULL,1308312474,NULL,NULL,NULL),(212,73,40,1,'After a 12-13 loss in the previous round, you\'ll play France on Field 13 at 15:30',NULL,1308312474,NULL,NULL,NULL),(213,80,40,1,'After a 15-1 win in the previous round, you\'ll play Italy on Field 14 at 15:30',NULL,1308312474,NULL,NULL,NULL),(214,76,40,1,'After a 15-4 win in the previous round, you\'ll play Switzerland on Field 14 at 15:30',NULL,1308312474,NULL,NULL,NULL),(215,78,40,1,'After a 1-15 loss in the previous round, you\'ll play Seagulls on Field 15 at 15:30',NULL,1308312474,NULL,NULL,NULL),(216,75,40,1,'After a 4-15 loss in the previous round, you\'ll play Thalys on Field 15 at 15:30',NULL,1308312474,NULL,NULL,NULL),(217,77,40,1,'After a 15-0 win in the previous round, you\'ll play Ireland on Field 16 at 15:30',NULL,1308312474,NULL,NULL,NULL),(218,74,40,1,'After a break in the previous round, you\'ll play GB on Field 16 at 15:30',NULL,1308312474,NULL,NULL,NULL),(219,81,40,1,'After a 7-15 loss in the previous round, you\'ll play Chakalakas on Field 17 at 15:30',NULL,1308312475,NULL,NULL,NULL),(220,70,40,1,'After a 0-15 loss in the previous round, you\'ll play Holland on Field 17 at 15:30',NULL,1308312475,NULL,NULL,NULL),(221,71,40,1,'After a 15-7 win in the previous round, due to the odd number of teams,you can take a break at 15:30',NULL,1308312475,NULL,NULL,NULL),(222,54,23,1,'After a 15-3 win in round 2, you are now ranked 1st.In round 3,you\'ll play France(ranked 2nd) on Field 5 at 15:30',NULL,1308313420,NULL,NULL,NULL),(223,47,23,1,'After a 15-4 win in round 2, you are now ranked 2nd.In round 3,you\'ll play Germany(ranked 1st) on Field 5 at 15:30',NULL,1308313420,NULL,NULL,NULL),(224,46,23,1,'After a 15-4 win in round 2, you are now ranked 3rd.In round 3,you\'ll play Frizzly Bears(ranked 4th) on Field 4 at 15:30',NULL,1308313420,NULL,NULL,NULL),(225,62,23,1,'After a 15-4 win in round 2, you are now ranked 4th.In round 3,you\'ll play Quijotes(ranked 3rd) on Field 4 at 15:30',NULL,1308313420,NULL,NULL,NULL),(226,51,23,1,'After a 15-11 win in round 2, you are now ranked 5th.In round 3,you\'ll play Russia(ranked 6th) on Field 3 at 15:30',NULL,1308313420,NULL,NULL,NULL),(227,69,23,1,'After a 15-10 win in round 2, you are now ranked 6th.In round 3,you\'ll play Austria(ranked 5th) on Field 3 at 15:30',NULL,1308313420,NULL,NULL,NULL),(228,64,23,1,'After a 14-8 win in round 2, you are now ranked 7th.In round 3,you\'ll play Ireland(ranked 8th) on Field 2 at 15:30',NULL,1308313420,NULL,NULL,NULL),(229,59,23,1,'After a 11-15 loss in round 2, you are now ranked 8th.In round 3,you\'ll play Sexy Legs(ranked 7th) on Field 2 at 15:30',NULL,1308313420,NULL,NULL,NULL),(230,55,23,1,'After a 12-5 win in round 2, you are now ranked 9th.In round 3,you\'ll play Holland(ranked 10th) on Field 1 at 15:30',NULL,1308313420,NULL,NULL,NULL),(231,56,23,1,'After a 15-11 win in round 2, you are now ranked 10th.In round 3,you\'ll play Robiram(ranked 9th) on Field 1 at 15:30',NULL,1308313420,NULL,NULL,NULL),(232,63,23,1,'After a 11-6 win in round 2, you are now ranked 11th.In round 3,you\'ll play Switzerland(ranked 12th) on Field 20 at 15:30',NULL,1308313420,NULL,NULL,NULL),(233,66,23,1,'After a 4-15 loss in round 2, you are now ranked 12th.In round 3,you\'ll play Moscow(ranked 11th) on Field 20 at 15:30',NULL,1308313421,NULL,NULL,NULL),(234,44,23,1,'After a 3-15 loss in round 2, you are now ranked 13th.In round 3,you\'ll play Spirit on Lemon(ranked 14th) on Field 19 at 15:30',NULL,1308313421,NULL,NULL,NULL),(235,49,23,1,'After a 10-15 loss in round 2, you are now ranked 14th.In round 3,you\'ll play Superfly(ranked 13th) on Field 19 at 15:30',NULL,1308313421,NULL,NULL,NULL),(236,53,23,1,'After a 15-9 win in round 2, you are now ranked 15th.In round 3,you\'ll play Rusty Bikes(ranked 16th) on Field 18 at 15:30',NULL,1308313421,NULL,NULL,NULL),(237,52,23,1,'After a 4-15 loss in round 2, you are now ranked 16th.In round 3,you\'ll play Nuts\'nBerries(ranked 15th) on Field 18 at 15:30',NULL,1308313421,NULL,NULL,NULL),(238,58,23,1,'After a 4-15 loss in round 2, you are now ranked 17th.In round 3,you\'ll play Drehst\'nDeckel(ranked 18th) on Field 10 at 15:30',NULL,1308313421,NULL,NULL,NULL),(239,67,23,1,'After a 8-14 loss in round 2, you are now ranked 18th.In round 3,you\'ll play Akka(ranked 17th) on Field 10 at 15:30',NULL,1308313421,NULL,NULL,NULL),(240,61,23,1,'After a 15-12 win in round 2, you are now ranked 19th.In round 3,you\'ll play PUF(ranked 20th) on Field 11 at 15:30',NULL,1308313421,NULL,NULL,NULL),(241,45,23,1,'After a 11-15 loss in round 2, you are now ranked 20th.In round 3,you\'ll play Cranberry(ranked 19th) on Field 11 at 15:30',NULL,1308313421,NULL,NULL,NULL),(242,65,23,1,'After a 15-11 win in round 2, you are now ranked 21st.In round 3,you\'ll play Stockholm(ranked 22nd) on Field 9 at 15:30',NULL,1308313421,NULL,NULL,NULL),(243,48,23,1,'After a 5-12 loss in round 2, you are now ranked 22nd.In round 3,you\'ll play Frisbee Family(ranked 21st) on Field 9 at 15:30',NULL,1308313421,NULL,NULL,NULL),(244,60,23,1,'After a 6-11 loss in round 2, you are now ranked 23rd.In round 3,you\'ll play Cheek2Cheek(ranked 24th) on Field 6 at 15:30',NULL,1308313421,NULL,NULL,NULL),(245,50,23,1,'After a 12-15 loss in round 2, you are now ranked 24th.In round 3,you\'ll play Turkey(ranked 23rd) on Field 6 at 15:30',NULL,1308313421,NULL,NULL,NULL),(246,84,23,1,'After a 11-9 win in round 2, you are now ranked 25th.In round 3,you\'ll play Disco Stu(ranked 26th) on Field 7 at 15:30',NULL,1308313421,NULL,NULL,NULL),(247,43,23,1,'After a 9-15 loss in round 2, you are now ranked 26th.In round 3,you\'ll play (ranked 25th) on Field 7 at 15:30',NULL,1308313421,NULL,NULL,NULL),(248,68,23,1,'After a 9-11 loss in round 2, you are now ranked 27th.In round 3,you\'ll play WAF(ranked 28th) on Field 8 at 15:30',NULL,1308313421,NULL,NULL,NULL),(249,57,23,1,'After a 11-15 loss in round 2, you are now ranked 28th.In round 3,you\'ll play Aye-Aye(ranked 27th) on Field 8 at 15:30',NULL,1308313421,NULL,NULL,NULL),(250,12,3,1,'After a 15-7 win in round 2, you are now ranked 1st.In round 3,you\'ll play Denmark(ranked 2nd) on Field 11 at 17:00',NULL,1308318496,NULL,NULL,NULL),(251,29,3,1,'After a 15-8 win in round 2, you are now ranked 2nd.In round 3,you\'ll play Silence(ranked 1st) on Field 11 at 17:00',NULL,1308318496,NULL,NULL,NULL),(252,19,3,1,'After a 15-9 win in round 2, you are now ranked 3rd.In round 3,you\'ll play Flying Bisc(ranked 4th) on Field 12 at 17:00',NULL,1308318496,NULL,NULL,NULL),(253,36,3,1,'After a 15-4 win in round 2, you are now ranked 4th.In round 3,you\'ll play Flying Angels(ranked 3rd) on Field 12 at 17:00',NULL,1308318496,NULL,NULL,NULL),(254,17,3,1,'After a 15-9 win in round 2, you are now ranked 5th.In round 3,you\'ll play 7Schwaben(ranked 6th) on Field 13 at 17:00',NULL,1308318496,NULL,NULL,NULL),(255,32,3,1,'After a 15-9 win in round 2, you are now ranked 6th.In round 3,you\'ll play Bologna(ranked 5th) on Field 13 at 17:00',NULL,1308318496,NULL,NULL,NULL),(256,35,3,1,'After a 15-8 win in round 2, you are now ranked 7th.In round 3,you\'ll play Friselis(ranked 8th) on Field 14 at 17:00',NULL,1308318496,NULL,NULL,NULL),(257,31,3,1,'After a 15-9 win in round 2, you are now ranked 8th.In round 3,you\'ll play Freespeed(ranked 7th) on Field 14 at 17:00',NULL,1308318496,NULL,NULL,NULL),(258,18,3,1,'After a 15-3 win in round 2, you are now ranked 9th.In round 3,you\'ll play Pissotte(ranked 10th) on Field 15 at 17:00',NULL,1308318496,NULL,NULL,NULL),(259,14,3,1,'After a 15-9 win in round 2, you are now ranked 10th.In round 3,you\'ll play M.U.C.(ranked 9th) on Field 15 at 17:00',NULL,1308318496,NULL,NULL,NULL),(260,39,3,1,'After a 15-12 win in round 2, you are now ranked 11th.In round 3,you\'ll play German Junior(ranked 12th) on Field 6 at 17:00',NULL,1308318496,NULL,NULL,NULL),(261,23,3,1,'After a 9-15 loss in round 2, you are now ranked 12th.In round 3,you\'ll play Cambo Cakes(ranked 11th) on Field 6 at 17:00',NULL,1308318497,NULL,NULL,NULL),(262,15,3,1,'After a 9-15 loss in round 2, you are now ranked 13th.In round 3,you\'ll play Gentle(ranked 14th) on Field 17 at 17:00',NULL,1308318497,NULL,NULL,NULL),(263,1,3,1,'After a 9-15 loss in round 2, you are now ranked 14th.In round 3,you\'ll play theBigEz(ranked 13th) on Field 17 at 17:00',NULL,1308318497,NULL,NULL,NULL),(264,16,3,1,'After a 15-4 win in round 2, you are now ranked 15th.In round 3,you\'ll play Spain(ranked 16th) on Field 18 at 17:00',NULL,1308318497,NULL,NULL,NULL),(265,20,3,1,'After a 8-15 loss in round 2, you are now ranked 16th.In round 3,you\'ll play Solebang(ranked 15th) on Field 18 at 17:00',NULL,1308318497,NULL,NULL,NULL),(266,9,3,1,'After a 7-15 loss in round 2, you are now ranked 17th.In round 3,you\'ll play Russia(ranked 18th) on Field 19 at 17:00',NULL,1308318497,NULL,NULL,NULL),(267,26,3,1,'After a 8-15 loss in round 2, you are now ranked 18th.In round 3,you\'ll play Mooncatchers(ranked 17th) on Field 19 at 17:00',NULL,1308318497,NULL,NULL,NULL),(268,3,3,1,'After a 15-12 win in round 2, you are now ranked 19th.In round 3,you\'ll play Sun(ranked 20th) on Field 20 at 17:00',NULL,1308318497,NULL,NULL,NULL),(269,30,3,1,'After a 15-5 win in round 2, you are now ranked 20th.In round 3,you\'ll play Rainbow Warriors(ranked 19th) on Field 20 at 17:00',NULL,1308318497,NULL,NULL,NULL),(270,38,3,1,'After a 15-3 win in round 2, you are now ranked 21st.In round 3,you\'ll play Red Lights(ranked 22nd) on Field 1 at 17:00',NULL,1308318497,NULL,NULL,NULL),(271,37,3,1,'After a 15-13 win in round 2, you are now ranked 22nd.In round 3,you\'ll play Les etoiles o(ranked 21st) on Field 1 at 17:00',NULL,1308318497,NULL,NULL,NULL),(272,41,3,1,'After a 15-12 win in round 2, you are now ranked 23rd.In round 3,you\'ll play MAM(ranked 25th) on Field 2 at 17:00',NULL,1308318497,NULL,NULL,NULL),(273,10,3,1,'After a 12-15 loss in round 2, you are now ranked 25th.In round 3,you\'ll play German Masters(ranked 23rd) on Field 2 at 17:00',NULL,1308318497,NULL,NULL,NULL),(274,21,3,1,'After a 9-15 loss in round 2, you are now ranked 24th.In round 3,you\'ll play Gummibaerchen(ranked 26th) on Field 3 at 17:00',NULL,1308318497,NULL,NULL,NULL),(275,24,3,1,'After a 15-9 win in round 2, you are now ranked 26th.In round 3,you\'ll play Iznogood(ranked 24th) on Field 3 at 17:00',NULL,1308318497,NULL,NULL,NULL),(276,2,3,1,'After a 13-15 loss in round 2, you are now ranked 27th.In round 3,you\'ll play Hardfisch(ranked 28th) on Field 4 at 17:00',NULL,1308318497,NULL,NULL,NULL),(277,6,3,1,'After a 9-15 loss in round 2, you are now ranked 28th.In round 3,you\'ll play FranceMaster(ranked 27th) on Field 4 at 17:00',NULL,1308318497,NULL,NULL,NULL),(278,5,3,1,'After a 15-6 win in round 2, you are now ranked 29th.In round 3,you\'ll play Panthers(ranked 30th) on Field 5 at 17:00',NULL,1308318497,NULL,NULL,NULL),(279,25,3,1,'After a 4-15 loss in round 2, you are now ranked 30th.In round 3,you\'ll play KoBOld(ranked 29th) on Field 5 at 17:00',NULL,1308318497,NULL,NULL,NULL),(280,13,3,1,'After a 15-9 win in round 2, you are now ranked 33rd.In round 3,you\'ll play Carapedos(ranked 34th) on Field 16 at 17:00',NULL,1308318497,NULL,NULL,NULL),(281,4,3,1,'After a 12-15 loss in round 2, you are now ranked 34th.In round 3,you\'ll play Funatics(ranked 33rd) on Field 16 at 17:00',NULL,1308318497,NULL,NULL,NULL),(282,34,3,1,'After a 9-15 loss in round 2, you are now ranked 35th.In round 3,you\'ll play Netherlands(ranked 36th) on Field 7 at 17:00',NULL,1308318497,NULL,NULL,NULL),(283,40,3,1,'After a 3-15 loss in round 2, you are now ranked 36th.In round 3,you\'ll play deLux(ranked 35th) on Field 7 at 17:00',NULL,1308318497,NULL,NULL,NULL),(284,7,3,1,'After a 10-15 loss in round 2, you are now ranked 37th.In round 3,you\'ll play Buggoli(ranked 38th) on Field 8 at 17:00',NULL,1308318497,NULL,NULL,NULL),(285,27,3,1,'After a 4-15 loss in round 2, you are now ranked 38th.In round 3,you\'ll play Tsunami(ranked 37th) on Field 8 at 17:00',NULL,1308318497,NULL,NULL,NULL),(286,33,3,1,'After a 5-15 loss in round 2, you are now ranked 39th.In round 3,you\'ll play UL Ninjas(ranked 40th) on Field 9 at 17:00',NULL,1308318497,NULL,NULL,NULL),(287,22,3,1,'After a 9-15 loss in round 2, you are now ranked 40th.In round 3,you\'ll play Barbastreji(ranked 39th) on Field 9 at 17:00',NULL,1308318497,NULL,NULL,NULL),(288,28,3,1,'After a 6-15 loss in round 2, you are now ranked 41st.In round 3,you\'ll play Xlr8rs(ranked 42nd) on Field 10 at 17:00',NULL,1308318497,NULL,NULL,NULL),(289,8,3,1,'After a 3-15 loss in round 2, you are now ranked 42nd.In round 3,you\'ll play Soimii(ranked 41st) on Field 10 at 17:00',NULL,1308318497,NULL,NULL,NULL),(290,11,3,1,'After a 15-10 win in round 2, you are now ranked 31st.In round 3,you can take a break due to the odd number of teams.You\'ll score a 15-12 win',NULL,1308318497,NULL,NULL,NULL),(291,42,3,1,'After a 12-15 loss in round 2, you are now ranked 32nd.In round 3,you\'ll play Rebel(ranked 31st) on Field at 17:00',NULL,1308318497,NULL,NULL,NULL),(292,74,41,1,'After a 12-10 win in the previous round, you\'ll play Holland on Field 3 at 18:30',NULL,1308324412,NULL,NULL,NULL),(293,81,41,1,'After a 12-8 win in the previous round, you\'ll play Ireland on Field 3 at 18:30',NULL,1308324412,NULL,NULL,NULL),(294,71,41,1,'After a break in the previous round, you\'ll play Chakalakas on Field 4 at 18:30',NULL,1308324413,NULL,NULL,NULL),(295,70,41,1,'After a 8-12 loss in the previous round, you\'ll play Hot Beaches on Field 4 at 18:30',NULL,1308324413,NULL,NULL,NULL),(296,51,24,1,'After a 15-3 win in round 3, you are now ranked 1st.In round 4,you\'ll play France(ranked 2nd) on Field 7 at 10:30',NULL,1308324548,NULL,NULL,NULL),(297,47,24,1,'After a 15-12 win in round 3, you are now ranked 2nd.In round 4,you\'ll play Austria(ranked 1st) on Field 7 at 10:30',NULL,1308324548,NULL,NULL,NULL),(298,62,24,1,'After a 15-12 win in round 3, you are now ranked 3rd.In round 4,you\'ll play Germany(ranked 4th) on Field 13 at 10:30',NULL,1308324548,NULL,NULL,NULL),(299,54,24,1,'After a 12-15 loss in round 3, you are now ranked 4th.In round 4,you\'ll play Frizzly Bears(ranked 3rd) on Field 13 at 10:30',NULL,1308324548,NULL,NULL,NULL),(300,46,24,1,'After a 12-15 loss in round 3, you are now ranked 5th.In round 4,you\'ll play Ireland(ranked 6th) on Field 9 at 10:30',NULL,1308324548,NULL,NULL,NULL),(301,59,24,1,'After a 15-10 win in round 3, you are now ranked 6th.In round 4,you\'ll play Quijotes(ranked 5th) on Field 9 at 10:30',NULL,1308324548,NULL,NULL,NULL),(302,56,24,1,'After a 15-8 win in round 3, you are now ranked 7th.In round 4,you\'ll play Nuts\'nBerries(ranked 8th) on Field 1 at 10:30',NULL,1308324548,NULL,NULL,NULL),(303,53,24,1,'After a 13-4 win in round 3, you are now ranked 8th.In round 4,you\'ll play Holland(ranked 7th) on Field 1 at 10:30',NULL,1308324548,NULL,NULL,NULL),(304,64,24,1,'After a 10-15 loss in round 3, you are now ranked 9th.In round 4,you\'ll play Switzerland(ranked 11th) on Field 2 at 10:30',NULL,1308324548,NULL,NULL,NULL),(305,66,24,1,'After a 13-10 win in round 3, you are now ranked 11th.In round 4,you\'ll play Sexy Legs(ranked 9th) on Field 2 at 10:30',NULL,1308324548,NULL,NULL,NULL),(306,67,24,1,'After a 15-8 win in round 3, you are now ranked 10th.In round 4,you\'ll play Spirit on Lemon(ranked 12th) on Field 3 at 10:30',NULL,1308324548,NULL,NULL,NULL),(307,49,24,1,'After a 14-11 win in round 3, you are now ranked 12th.In round 4,you\'ll play Drehst\'nDeckel(ranked 10th) on Field 3 at 10:30',NULL,1308324548,NULL,NULL,NULL),(308,48,24,1,'After a 14-6 win in round 3, you are now ranked 13th.In round 4,you\'ll play Russia(ranked 14th) on Field 16 at 10:30',NULL,1308324548,NULL,NULL,NULL),(309,69,24,1,'After a 3-15 loss in round 3, you are now ranked 14th.In round 4,you\'ll play Stockholm(ranked 13th) on Field 16 at 10:30',NULL,1308324548,NULL,NULL,NULL),(310,55,24,1,'After a 8-15 loss in round 3, you are now ranked 15th.In round 4,you\'ll play Moscow(ranked 16th) on Field 18 at 10:30',NULL,1308324548,NULL,NULL,NULL),(311,63,24,1,'After a 10-13 loss in round 3, you are now ranked 16th.In round 4,you\'ll play Robiram(ranked 15th) on Field 18 at 10:30',NULL,1308324548,NULL,NULL,NULL),(312,44,24,1,'After a 11-14 loss in round 3, you are now ranked 17th.In round 4,you\'ll play Cranberry(ranked 18th) on Field 4 at 10:30',NULL,1308324548,NULL,NULL,NULL),(313,61,24,1,'After a 14-13 win in round 3, you are now ranked 18th.In round 4,you\'ll play Superfly(ranked 17th) on Field 4 at 10:30',NULL,1308324548,NULL,NULL,NULL),(314,50,24,1,'After a 15-8 win in round 3, you are now ranked 19th.In round 4,you\'ll play PUF(ranked 20th) on Field 8 at 10:30',NULL,1308324548,NULL,NULL,NULL),(315,45,24,1,'After a 13-14 loss in round 3, you are now ranked 20th.In round 4,you\'ll play Cheek2Cheek(ranked 19th) on Field 8 at 10:30',NULL,1308324548,NULL,NULL,NULL),(316,43,24,1,'After a 12-6 win in round 3, you are now ranked 21st.In round 4,you\'ll play WAF(ranked 22nd) on Field 5 at 10:30',NULL,1308324548,NULL,NULL,NULL),(317,57,24,1,'After a 14-8 win in round 3, you are now ranked 22nd.In round 4,you\'ll play Disco Stu(ranked 21st) on Field 5 at 10:30',NULL,1308324548,NULL,NULL,NULL),(318,58,24,1,'After a 8-15 loss in round 3, you are now ranked 23rd.In round 4,you\'ll play Rusty Bikes(ranked 24th) on Field 6 at 10:30',NULL,1308324548,NULL,NULL,NULL),(319,52,24,1,'After a 4-13 loss in round 3, you are now ranked 24th.In round 4,you\'ll play Akka(ranked 23rd) on Field 6 at 10:30',NULL,1308324548,NULL,NULL,NULL),(320,65,24,1,'After a 6-14 loss in round 3, you are now ranked 25th.In round 4,you\'ll play (ranked 26th) on Field 19 at 10:30',NULL,1308324548,NULL,NULL,NULL),(321,84,24,1,'After a 6-12 loss in round 3, you are now ranked 26th.In round 4,you\'ll play Frisbee Family(ranked 25th) on Field 19 at 10:30',NULL,1308324548,NULL,NULL,NULL),(322,60,24,1,'After a 8-15 loss in round 3, you are now ranked 27th.In round 4,you\'ll play Aye-Aye(ranked 28th) on Field 20 at 10:30',NULL,1308324548,NULL,NULL,NULL),(323,68,24,1,'After a 8-14 loss in round 3, you are now ranked 28th.In round 4,you\'ll play Turkey(ranked 27th) on Field 20 at 10:30',NULL,1308324548,NULL,NULL,NULL),(324,19,4,1,'After a 15-5 win in round 3, you are now ranked 1st.In round 4,you\'ll play Silence(ranked 2nd) on Field 1 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331709,NULL,NULL,NULL),(325,12,4,1,'After a 14-8 win in round 3, you are now ranked 2nd.In round 4,you\'ll play Flying Angels(ranked 1st) on Field 1 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331709,NULL,NULL,NULL),(326,35,4,1,'After a 15-6 win in round 3, you are now ranked 3rd.In round 4,you\'ll play 7Schwaben(ranked 4th) on Field 2 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331709,NULL,NULL,NULL),(327,32,4,1,'After a 15-12 win in round 3, you are now ranked 4th.In round 4,you\'ll play Freespeed(ranked 3rd) on Field 2 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331709,NULL,NULL,NULL),(328,14,4,1,'After a 15-8 win in round 3, you are now ranked 5th.In round 4,you\'ll play Bologna(ranked 6th) on Field 3 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331709,NULL,NULL,NULL),(329,17,4,1,'After a 12-15 loss in round 3, you are now ranked 6th.In round 4,you\'ll play Pissotte(ranked 5th) on Field 3 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331709,NULL,NULL,NULL),(330,29,4,1,'After a 8-14 loss in round 3, you are now ranked 7th.In round 4,you\'ll play Russia(ranked 8th) on Field 10 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331709,NULL,NULL,NULL),(331,26,4,1,'After a 15-6 win in round 3, you are now ranked 8th.In round 4,you\'ll play Denmark(ranked 7th) on Field 10 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331709,NULL,NULL,NULL),(332,23,4,1,'After a 15-9 win in round 3, you are now ranked 9th.In round 4,you\'ll play Solebang(ranked 10th) on Field 14 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331709,NULL,NULL,NULL),(333,16,4,1,'After a 14-11 win in round 3, you are now ranked 10th.In round 4,you\'ll play German Junior(ranked 9th) on Field 14 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(334,1,4,1,'After a 15-12 win in round 3, you are now ranked 11th.In round 4,you\'ll play Gummibaerchen(ranked 12th) on Field 15 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(335,24,4,1,'After a 15-6 win in round 3, you are now ranked 12th.In round 4,you\'ll play Gentle(ranked 11th) on Field 15 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(336,36,4,1,'After a 5-15 loss in round 3, you are now ranked 13th.In round 4,you\'ll play Red Lights(ranked 14th) on Field 16 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(337,37,4,1,'After a 15-9 win in round 3, you are now ranked 14th.In round 4,you\'ll play Flying Bisc(ranked 13th) on Field 16 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(338,3,4,1,'After a 15-10 win in round 3, you are now ranked 15th.In round 4,you\'ll play M.U.C.(ranked 16th) on Field 11 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(339,18,4,1,'After a 8-15 loss in round 3, you are now ranked 16th.In round 4,you\'ll play Rainbow Warriors(ranked 15th) on Field 11 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(340,10,4,1,'After a 15-10 win in round 3, you are now ranked 17th.In round 4,you\'ll play Friselis(ranked 18th) on Field 19 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(341,31,4,1,'After a 6-15 loss in round 3, you are now ranked 18th.In round 4,you\'ll play MAM(ranked 17th) on Field 19 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(342,15,4,1,'After a 12-15 loss in round 3, you are now ranked 19th.In round 4,you\'ll play Cambo Cakes(ranked 20th) on Field 4 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(343,39,4,1,'After a 9-15 loss in round 3, you are now ranked 20th.In round 4,you\'ll play theBigEz(ranked 19th) on Field 4 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(344,20,4,1,'After a 11-14 loss in round 3, you are now ranked 21st.In round 4,you\'ll play Hardfisch(ranked 22nd) on Field 17 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(345,6,4,1,'After a 15-13 win in round 3, you are now ranked 22nd.In round 4,you\'ll play Spain(ranked 21st) on Field 17 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(346,4,4,1,'After a 15-8 win in round 3, you are now ranked 23rd.In round 4,you\'ll play Rebel(ranked 24th) on Field 18 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(347,11,4,1,'After a 15-12 win in round 3, you are now ranked 24th.In round 4,you\'ll play Carapedos(ranked 23rd) on Field 18 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(348,40,4,1,'After a 15-5 win in round 3, you are now ranked 25th.In round 4,you\'ll play Panthers(ranked 25th) on Field 13 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(349,25,4,1,'After a 13-11 win in round 3, you are now ranked 25th.In round 4,you\'ll play Netherlands(ranked 25th) on Field 13 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(350,2,4,1,'After a 13-15 loss in round 3, you are now ranked 27th.In round 4,you\'ll play Sun(ranked 28th) on Field 5 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(351,30,4,1,'After a 10-15 loss in round 3, you are now ranked 28th.In round 4,you\'ll play FranceMaster(ranked 27th) on Field 5 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(352,5,4,1,'After a 11-13 loss in round 3, you are now ranked 29th.In round 4,you\'ll play Les etoiles o(ranked 30th) on Field 6 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(353,38,4,1,'After a 9-15 loss in round 3, you are now ranked 30th.In round 4,you\'ll play KoBOld(ranked 29th) on Field 6 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(354,41,4,1,'After a 10-15 loss in round 3, you are now ranked 31st.In round 4,you\'ll play Mooncatchers(ranked 32nd) on Field 7 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(355,9,4,1,'After a 6-15 loss in round 3, you are now ranked 32nd.In round 4,you\'ll play German Masters(ranked 31st) on Field 7 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(356,8,4,1,'After a 15-2 win in round 3, you are now ranked 35th.In round 4,you\'ll play Funatics(ranked 36th) on Field 8 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(357,13,4,1,'After a 8-15 loss in round 3, you are now ranked 36th.In round 4,you\'ll play Xlr8rs(ranked 35th) on Field 8 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(358,27,4,1,'After a 11-10 win in round 3, you are now ranked 37th.In round 4,you\'ll play Barbastreji(ranked 38th) on Field 9 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(359,33,4,1,'After a 14-12 win in round 3, you are now ranked 38th.In round 4,you\'ll play Buggoli(ranked 37th) on Field 9 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(360,7,4,1,'After a 10-11 loss in round 3, you are now ranked 39th.In round 4,you\'ll play UL Ninjas(ranked 40th) on Field 12 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(361,22,4,1,'After a 12-14 loss in round 3, you are now ranked 40th.In round 4,you\'ll play Tsunami(ranked 39th) on Field 12 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(362,34,4,1,'After a 5-15 loss in round 3, you are now ranked 41st.In round 4,you\'ll play Soimii(ranked 42nd) on Field 20 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(363,28,4,1,'After a 2-15 loss in round 3, you are now ranked 42nd.In round 4,you\'ll play deLux(ranked 41st) on Field 20 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(364,42,4,1,'After a 12-15 loss in round 3, you are now ranked 33rd.In round 4,you\'ll play Iznogood(ranked 34th) on Field tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(365,21,4,1,'After a 6-15 loss in round 3, you are now ranked 34th.In round 4,you can take a break due to the odd number of teams.You\'ll score a 15-12 win.Please hand in today\'s spirit scores!',NULL,1308331710,NULL,NULL,NULL),(366,79,42,1,'After a 15-5 win in the previous round, you\'ll play France on Field 10tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333205,NULL,NULL,NULL),(367,72,42,1,'After a 11-10 win in the previous round, you\'ll play Germany on Field 10tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333205,NULL,NULL,NULL),(368,73,42,1,'After a 10-11 loss in the previous round, you\'ll play Russia on Field 11tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333205,NULL,NULL,NULL),(369,82,42,1,'After a 5-15 loss in the previous round, you\'ll play Denmark on Field 11tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333206,NULL,NULL,NULL),(370,80,42,1,'After a 13-14 loss in the previous round, you\'ll play Seagulls on Field 12tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333206,NULL,NULL,NULL),(371,75,42,1,'After a 14-8 win in the previous round, you\'ll play Switzerland on Field 12tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333206,NULL,NULL,NULL),(372,77,42,1,'After a 10-12 loss in the previous round, you\'ll play Holland on Field 14tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333206,NULL,NULL,NULL),(373,81,42,1,'After a 3-15 loss in the previous round, you\'ll play GB on Field 14tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333206,NULL,NULL,NULL),(374,71,42,1,'After a 15-1 win in the previous round, you\'ll play Ireland on Field 15tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333206,NULL,NULL,NULL),(375,74,42,1,'After a 15-3 win in the previous round, you\'ll play Hot Beaches on Field 15tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333206,NULL,NULL,NULL),(376,76,42,1,'After a 14-13 win in the previous round, you\'ll play Thalys on Field 17tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333206,NULL,NULL,NULL),(377,78,42,1,'After a 8-14 loss in the previous round, you\'ll play Italy on Field 17tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333206,NULL,NULL,NULL),(378,70,42,1,'After a 1-15 loss in the previous round, due to the odd number of teams,you can take a break tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308333206,NULL,NULL,NULL),(379,1,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339584,NULL,NULL,NULL),(380,2,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339586,NULL,NULL,NULL),(381,3,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339586,NULL,NULL,NULL),(382,4,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339587,NULL,NULL,NULL),(383,5,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339587,NULL,NULL,NULL),(384,6,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339588,NULL,NULL,NULL),(385,7,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339588,NULL,NULL,NULL),(386,8,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339589,NULL,NULL,NULL),(387,9,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339589,NULL,NULL,NULL),(388,10,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339589,NULL,NULL,NULL),(389,11,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339590,NULL,NULL,NULL),(390,12,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339590,NULL,NULL,NULL),(391,13,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339591,NULL,NULL,NULL),(392,14,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339591,NULL,NULL,NULL),(393,15,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339592,NULL,NULL,NULL),(394,16,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339592,NULL,NULL,NULL),(395,17,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339593,NULL,NULL,NULL),(396,18,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339593,NULL,NULL,NULL),(397,19,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339594,NULL,NULL,NULL),(398,20,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339595,NULL,NULL,NULL),(399,21,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339595,NULL,NULL,NULL),(400,22,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339596,NULL,NULL,NULL),(401,23,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339597,NULL,NULL,NULL),(402,24,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339597,NULL,NULL,NULL),(403,25,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339598,NULL,NULL,NULL),(404,26,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339598,NULL,NULL,NULL),(405,27,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339598,NULL,NULL,NULL),(406,28,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339599,NULL,NULL,NULL),(407,29,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339599,NULL,NULL,NULL),(408,30,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339600,NULL,NULL,NULL),(409,31,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339601,NULL,NULL,NULL),(410,32,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339601,NULL,NULL,NULL),(411,33,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339602,NULL,NULL,NULL),(412,34,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339603,NULL,NULL,NULL),(413,35,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339603,NULL,NULL,NULL),(414,36,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339604,NULL,NULL,NULL),(415,37,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339605,NULL,NULL,NULL),(416,38,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339605,NULL,NULL,NULL),(417,39,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339606,NULL,NULL,NULL),(418,40,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339606,NULL,NULL,NULL),(419,41,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339607,NULL,NULL,NULL),(420,42,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339608,NULL,NULL,NULL),(421,43,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339609,NULL,NULL,NULL),(422,44,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339611,NULL,NULL,NULL),(423,45,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339612,NULL,NULL,NULL),(424,46,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339613,NULL,NULL,NULL),(425,47,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339613,NULL,NULL,NULL),(426,48,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339614,NULL,NULL,NULL),(427,49,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339614,NULL,NULL,NULL),(428,50,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339614,NULL,NULL,NULL),(429,51,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339615,NULL,NULL,NULL),(430,52,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339616,NULL,NULL,NULL),(431,53,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339617,NULL,NULL,NULL),(432,54,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339617,NULL,NULL,NULL),(433,55,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339618,NULL,NULL,NULL),(434,56,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339618,NULL,NULL,NULL),(435,57,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339619,NULL,NULL,NULL),(436,58,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339619,NULL,NULL,NULL),(437,59,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339620,NULL,NULL,NULL),(438,60,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339620,NULL,NULL,NULL),(439,61,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339621,NULL,NULL,NULL),(440,62,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339621,NULL,NULL,NULL),(441,63,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339621,NULL,NULL,NULL),(442,64,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339622,NULL,NULL,NULL),(443,65,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339622,NULL,NULL,NULL),(444,66,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339623,NULL,NULL,NULL),(445,67,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339623,NULL,NULL,NULL),(446,68,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339624,NULL,NULL,NULL),(447,69,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339625,NULL,NULL,NULL),(448,84,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339625,NULL,NULL,NULL),(449,70,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339626,NULL,NULL,NULL),(450,71,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339626,NULL,NULL,NULL),(451,72,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339626,NULL,NULL,NULL),(452,73,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339627,NULL,NULL,NULL),(453,74,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339628,NULL,NULL,NULL),(454,75,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339628,NULL,NULL,NULL),(455,76,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339628,NULL,NULL,NULL),(456,77,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339629,NULL,NULL,NULL),(457,78,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339629,NULL,NULL,NULL),(458,79,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339630,NULL,NULL,NULL),(459,80,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339630,NULL,NULL,NULL),(460,81,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339631,NULL,NULL,NULL),(461,82,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339631,NULL,NULL,NULL),(462,83,NULL,1,'Complements to teams that handed in their Spirit Sheet, for the others PLEASE make sure you hand it in within the next 60 mins.',NULL,1308339631,NULL,NULL,NULL),(463,19,5,1,'After a 14-10 win in round 4, you are now ranked 1st.In round 5,you\'ll play Freespeed(ranked 2nd) on Field 2 at 12:00',NULL,1308387905,NULL,NULL,NULL),(464,35,5,1,'After a 12-9 win in round 4, you are now ranked 2nd.In round 5,you\'ll play Flying Angels(ranked 1st) on Field 2 at 12:00',NULL,1308387905,NULL,NULL,NULL),(465,12,5,1,'After a 10-14 loss in round 4, you are now ranked 3rd.In round 5,you\'ll play 7Schwaben(ranked 5th) on Field 12 at 12:00',NULL,1308387905,NULL,NULL,NULL),(466,32,5,1,'After a 9-12 loss in round 4, you are now ranked 5th.In round 5,you\'ll play Silence(ranked 3rd) on Field 12 at 12:00',NULL,1308387905,NULL,NULL,NULL),(467,29,5,1,'After a 13-5 win in round 4, you are now ranked 4th.In round 5,you\'ll play Pissotte(ranked 6th) on Field 11 at 12:00',NULL,1308387905,NULL,NULL,NULL),(468,14,5,1,'After a 14-15 loss in round 4, you are now ranked 6th.In round 5,you\'ll play Denmark(ranked 4th) on Field 11 at 12:00',NULL,1308387905,NULL,NULL,NULL),(469,18,5,1,'After a 15-4 win in round 4, you are now ranked 7th.In round 5,you\'ll play Bologna(ranked 8th) on Field 18 at 12:00',NULL,1308387905,NULL,NULL,NULL),(470,17,5,1,'After a 15-14 win in round 4, you are now ranked 8th.In round 5,you\'ll play M.U.C.(ranked 7th) on Field 18 at 12:00',NULL,1308387905,NULL,NULL,NULL),(471,24,5,1,'After a 14-10 win in round 4, you are now ranked 9th.In round 5,you\'ll play Solebang(ranked 10th) on Field 19 at 12:00',NULL,1308387905,NULL,NULL,NULL),(472,16,5,1,'After a 13-10 win in round 4, you are now ranked 10th.In round 5,you\'ll play Gummibaerchen(ranked 9th) on Field 19 at 12:00',NULL,1308387905,NULL,NULL,NULL),(473,23,5,1,'After a 10-13 loss in round 4, you are now ranked 11th.In round 5,you\'ll play Red Lights(ranked 12th) on Field 1 at 12:00',NULL,1308387905,NULL,NULL,NULL),(474,37,5,1,'After a 12-10 win in round 4, you are now ranked 12th.In round 5,you\'ll play German Junior(ranked 11th) on Field 1 at 12:00',NULL,1308387905,NULL,NULL,NULL),(475,11,5,1,'After a 15-2 win in round 4, you are now ranked 13th.In round 5,you\'ll play Netherlands(ranked 14th) on Field 3 at 12:00',NULL,1308387905,NULL,NULL,NULL),(476,40,5,1,'After a 15-7 win in round 4, you are now ranked 14th.In round 5,you\'ll play Rebel(ranked 13th) on Field 3 at 12:00',NULL,1308387905,NULL,NULL,NULL),(477,36,5,1,'After a 10-12 loss in round 4, you are now ranked 15th.In round 5,you\'ll play Spain(ranked 16th) on Field 14 at 12:00',NULL,1308387905,NULL,NULL,NULL),(478,20,5,1,'After a 13-9 win in round 4, you are now ranked 16th.In round 5,you\'ll play Flying Bisc(ranked 15th) on Field 14 at 12:00',NULL,1308387906,NULL,NULL,NULL),(479,10,5,1,'After a 11-10 win in round 4, you are now ranked 17th.In round 5,you\'ll play Gentle(ranked 18th) on Field 13 at 12:00',NULL,1308387906,NULL,NULL,NULL),(480,1,5,1,'After a 10-14 loss in round 4, you are now ranked 18th.In round 5,you\'ll play MAM(ranked 17th) on Field 13 at 12:00',NULL,1308387906,NULL,NULL,NULL),(481,26,5,1,'After a 5-13 loss in round 4, you are now ranked 19th.In round 5,you\'ll play Cambo Cakes(ranked 20th) on Field 10 at 12:00',NULL,1308387906,NULL,NULL,NULL),(482,39,5,1,'After a 14-12 win in round 4, you are now ranked 20th.In round 5,you\'ll play Russia(ranked 19th) on Field 10 at 12:00',NULL,1308387906,NULL,NULL,NULL),(483,2,5,1,'After a 15-8 win in round 4, you are now ranked 21st.In round 5,you\'ll play Friselis(ranked 22nd) on Field 16 at 12:00',NULL,1308387906,NULL,NULL,NULL),(484,31,5,1,'After a 10-11 loss in round 4, you are now ranked 22nd.In round 5,you\'ll play FranceMaster(ranked 21st) on Field 16 at 12:00',NULL,1308387906,NULL,NULL,NULL),(485,38,5,1,'After a 13-6 win in round 4, you are now ranked 23rd.In round 5,you\'ll play Mooncatchers(ranked 24th) on Field 17 at 12:00',NULL,1308387906,NULL,NULL,NULL),(486,9,5,1,'After a 14-7 win in round 4, you are now ranked 24th.In round 5,you\'ll play Les etoiles o(ranked 23rd) on Field 17 at 12:00',NULL,1308387906,NULL,NULL,NULL),(487,15,5,1,'After a 12-14 loss in round 4, you are now ranked 25th.In round 5,you\'ll play Hardfisch(ranked 26th) on Field 4 at 12:00',NULL,1308387906,NULL,NULL,NULL),(488,6,5,1,'After a 9-13 loss in round 4, you are now ranked 26th.In round 5,you\'ll play theBigEz(ranked 25th) on Field 4 at 12:00',NULL,1308387906,NULL,NULL,NULL),(489,13,5,1,'After a 15-6 win in round 4, you are now ranked 27th.In round 5,you\'ll play Rainbow Warriors(ranked 28th) on Field 5 at 12:00',NULL,1308387906,NULL,NULL,NULL),(490,3,5,1,'After a 4-15 loss in round 4, you are now ranked 28th.In round 5,you\'ll play Funatics(ranked 27th) on Field 5 at 12:00',NULL,1308387906,NULL,NULL,NULL),(491,7,5,1,'After a 15-4 win in round 4, you are now ranked 29th.In round 5,you\'ll play Iznogood(ranked 30th) on Field 6 at 12:00',NULL,1308387906,NULL,NULL,NULL),(492,21,5,1,'After a 15-12 win in round 4, you are now ranked 30th.In round 5,you\'ll play Tsunami(ranked 29th) on Field 6 at 12:00',NULL,1308387906,NULL,NULL,NULL),(493,33,5,1,'After a 14-6 win in round 4, you are now ranked 31st.In round 5,you\'ll play Panthers(ranked 32nd) on Field 7 at 12:00',NULL,1308387906,NULL,NULL,NULL),(494,25,5,1,'After a 7-15 loss in round 4, you are now ranked 32nd.In round 5,you\'ll play Barbastreji(ranked 31st) on Field 7 at 12:00',NULL,1308387906,NULL,NULL,NULL),(495,34,5,1,'After a 15-3 win in round 4, you are now ranked 35th.In round 5,you\'ll play KoBOld(ranked 36th) on Field 8 at 12:00',NULL,1308387906,NULL,NULL,NULL),(496,5,5,1,'After a 6-13 loss in round 4, you are now ranked 36th.In round 5,you\'ll play deLux(ranked 35th) on Field 8 at 12:00',NULL,1308387906,NULL,NULL,NULL),(497,41,5,1,'After a 7-14 loss in round 4, you are now ranked 37th.In round 5,you\'ll play Xlr8rs(ranked 39th) on Field 9 at 12:00',NULL,1308387906,NULL,NULL,NULL),(498,8,5,1,'After a 6-15 loss in round 4, you are now ranked 39th.In round 5,you\'ll play German Masters(ranked 37th) on Field 9 at 12:00',NULL,1308387906,NULL,NULL,NULL),(499,4,5,1,'After a 2-15 loss in round 4, you are now ranked 38th.In round 5,you\'ll play Buggoli(ranked 40th) on Field 15 at 12:00',NULL,1308387906,NULL,NULL,NULL),(500,27,5,1,'After a 6-14 loss in round 4, you are now ranked 40th.In round 5,you\'ll play Carapedos(ranked 38th) on Field 15 at 12:00',NULL,1308387906,NULL,NULL,NULL),(501,22,5,1,'After a 4-15 loss in round 4, you are now ranked 41st.In round 5,you\'ll play Soimii(ranked 42nd) on Field 20 at 12:00',NULL,1308387906,NULL,NULL,NULL),(502,28,5,1,'After a 3-15 loss in round 4, you are now ranked 42nd.In round 5,you\'ll play UL Ninjas(ranked 41st) on Field 20 at 12:00',NULL,1308387906,NULL,NULL,NULL),(503,30,5,1,'After a 8-15 loss in round 4, you are now ranked 33rd.In round 5,you can take a break due to the odd number of teams.You\'ll score a 15-12 win',NULL,1308387906,NULL,NULL,NULL),(504,42,5,1,'After a 12-15 loss in round 4, you are now ranked 34th.In round 5,you\'ll play Sun(ranked 33rd) on Field at 12:00',NULL,1308387906,NULL,NULL,NULL),(505,79,43,1,'After a 10-8 win in the previous round, you\'ll play Switzerland on Field 1 at 13:30',NULL,1308392950,NULL,NULL,NULL),(506,80,43,1,'After a 15-7 win in the previous round, you\'ll play Germany on Field 1 at 13:30',NULL,1308392950,NULL,NULL,NULL),(507,76,43,1,'After a 15-4 win in the previous round, you\'ll play France on Field 2 at 13:30',NULL,1308392950,NULL,NULL,NULL),(508,72,43,1,'After a 8-10 loss in the previous round, you\'ll play Italy on Field 2 at 13:30',NULL,1308392950,NULL,NULL,NULL),(509,73,43,1,'After a 15-8 win in the previous round, you\'ll play Seagulls on Field 3 at 13:30',NULL,1308392950,NULL,NULL,NULL),(510,75,43,1,'After a 7-15 loss in the previous round, you\'ll play Denmark on Field 3 at 13:30',NULL,1308392950,NULL,NULL,NULL),(511,82,43,1,'After a 8-15 loss in the previous round, you\'ll play Thalys on Field 4 at 13:30',NULL,1308392950,NULL,NULL,NULL),(512,78,43,1,'After a 4-15 loss in the previous round, you\'ll play Russia on Field 4 at 13:30',NULL,1308392950,NULL,NULL,NULL),(513,77,43,1,'After a 14-2 win in the previous round, you\'ll play Hot Beaches on Field 5 at 13:30',NULL,1308392950,NULL,NULL,NULL),(514,71,43,1,'After a 12-11 win in the previous round, you\'ll play GB on Field 5 at 13:30',NULL,1308392950,NULL,NULL,NULL),(515,74,43,1,'After a 11-12 loss in the previous round, you\'ll play Chakalakas on Field 6 at 13:30',NULL,1308392950,NULL,NULL,NULL),(516,70,43,1,'After a break in the previous round, you\'ll play Ireland on Field 6 at 13:30',NULL,1308392950,NULL,NULL,NULL),(517,81,43,1,'After a 2-14 loss in the previous round, due to the odd number of teams,you can take a break at 13:30',NULL,1308392950,NULL,NULL,NULL),(518,47,25,1,'After a 11-7 win in round 4, you are now ranked 1st.In round 5,you\'ll play Ireland(ranked 4th) on Field 10 at 13:30',NULL,1308393528,NULL,NULL,NULL),(519,59,25,1,'After a 10-4 win in round 4, you are now ranked 4th.In round 5,you\'ll play France(ranked 1st) on Field 10 at 13:30',NULL,1308393528,NULL,NULL,NULL),(520,51,25,1,'After a 7-11 loss in round 4, you are now ranked 2nd.In round 5,you\'ll play Germany(ranked 3rd) on Field 11 at 13:30',NULL,1308393528,NULL,NULL,NULL),(521,54,25,1,'After a 13-11 win in round 4, you are now ranked 3rd.In round 5,you\'ll play Austria(ranked 2nd) on Field 11 at 13:30',NULL,1308393528,NULL,NULL,NULL),(522,62,25,1,'After a 11-13 loss in round 4, you are now ranked 5th.In round 5,you\'ll play Holland(ranked 6th) on Field 17 at 13:30',NULL,1308393528,NULL,NULL,NULL),(523,56,25,1,'After a 14-9 win in round 4, you are now ranked 6th.In round 5,you\'ll play Frizzly Bears(ranked 5th) on Field 17 at 13:30',NULL,1308393528,NULL,NULL,NULL),(524,64,25,1,'After a 13-6 win in round 4, you are now ranked 7th.In round 5,you\'ll play Quijotes(ranked 8th) on Field 19 at 13:30',NULL,1308393528,NULL,NULL,NULL),(525,46,25,1,'After a 4-10 loss in round 4, you are now ranked 8th.In round 5,you\'ll play Sexy Legs(ranked 7th) on Field 19 at 13:30',NULL,1308393528,NULL,NULL,NULL),(526,55,25,1,'After a 15-7 win in round 4, you are now ranked 9th.In round 5,you\'ll play Spirit on Lemon(ranked 10th) on Field 7 at 13:30',NULL,1308393528,NULL,NULL,NULL),(527,49,25,1,'After a 10-8 win in round 4, you are now ranked 10th.In round 5,you\'ll play Robiram(ranked 9th) on Field 7 at 13:30',NULL,1308393528,NULL,NULL,NULL),(528,69,25,1,'After a 14-9 win in round 4, you are now ranked 11th.In round 5,you\'ll play Nuts\'nBerries(ranked 12th) on Field 8 at 13:30',NULL,1308393528,NULL,NULL,NULL),(529,53,25,1,'After a 9-14 loss in round 4, you are now ranked 12th.In round 5,you\'ll play Russia(ranked 11th) on Field 8 at 13:30',NULL,1308393528,NULL,NULL,NULL),(530,67,25,1,'After a 8-10 loss in round 4, you are now ranked 13th.In round 5,you\'ll play PUF(ranked 14th) on Field 9 at 13:30',NULL,1308393528,NULL,NULL,NULL),(531,45,25,1,'After a 15-7 win in round 4, you are now ranked 14th.In round 5,you\'ll play Drehst\'nDeckel(ranked 13th) on Field 9 at 13:30',NULL,1308393528,NULL,NULL,NULL),(532,43,25,1,'After a 11-6 win in round 4, you are now ranked 15th.In round 5,you\'ll play Superfly(ranked 16th) on Field 12 at 13:30',NULL,1308393528,NULL,NULL,NULL),(533,44,25,1,'After a 13-12 win in round 4, you are now ranked 16th.In round 5,you\'ll play Disco Stu(ranked 15th) on Field 12 at 13:30',NULL,1308393528,NULL,NULL,NULL),(534,66,25,1,'After a 6-13 loss in round 4, you are now ranked 17th.In round 5,you\'ll play Cranberry(ranked 18th) on Field 18 at 13:30',NULL,1308393528,NULL,NULL,NULL),(535,61,25,1,'After a 12-13 loss in round 4, you are now ranked 18th.In round 5,you\'ll play Switzerland(ranked 17th) on Field 18 at 13:30',NULL,1308393528,NULL,NULL,NULL),(536,58,25,1,'After a 12-7 win in round 4, you are now ranked 19th.In round 5,you\'ll play Frisbee Family(ranked 20th) on Field 13 at 13:30',NULL,1308393528,NULL,NULL,NULL),(537,65,25,1,'After a 15-4 win in round 4, you are now ranked 20th.In round 5,you\'ll play Akka(ranked 19th) on Field 13 at 13:30',NULL,1308393528,NULL,NULL,NULL),(538,48,25,1,'After a 9-14 loss in round 4, you are now ranked 21st.In round 5,you\'ll play Moscow(ranked 22nd) on Field 14 at 13:30',NULL,1308393529,NULL,NULL,NULL),(539,63,25,1,'After a 7-15 loss in round 4, you are now ranked 22nd.In round 5,you\'ll play Stockholm(ranked 21st) on Field 14 at 13:30',NULL,1308393529,NULL,NULL,NULL),(540,57,25,1,'After a 6-11 loss in round 4, you are now ranked 24th.In round 5,you\'ll play Turkey(ranked 25th) on Field 15 at 13:30',NULL,1308393529,NULL,NULL,NULL),(541,60,25,1,'After a 9-6 win in round 4, you are now ranked 25th.In round 5,you\'ll play WAF(ranked 24th) on Field 15 at 13:30',NULL,1308393529,NULL,NULL,NULL),(542,50,25,1,'After a 7-15 loss in round 4, you are now ranked 23rd.In round 5,you\'ll play Aye-Aye(ranked 27th) on Field 20 at 13:30',NULL,1308393529,NULL,NULL,NULL),(543,68,25,1,'After a 6-9 loss in round 4, you are now ranked 27th.In round 5,you\'ll play Cheek2Cheek(ranked 23rd) on Field 20 at 13:30',NULL,1308393529,NULL,NULL,NULL),(544,52,25,1,'After a 7-12 loss in round 4, you are now ranked 26th.In round 5,you\'ll play (ranked 28th) on Field 16 at 13:30',NULL,1308393529,NULL,NULL,NULL),(545,84,25,1,'After a 4-15 loss in round 4, you are now ranked 28th.In round 5,you\'ll play Rusty Bikes(ranked 26th) on Field 16 at 13:30',NULL,1308393529,NULL,NULL,NULL),(546,19,6,1,'After a 13-14 loss in round 5, your final rank after Swissdraw is 1st.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Red Lightsfor rank 1 on Field 10 at 15:00',NULL,1308399928,NULL,NULL,NULL),(547,37,6,1,'After a 12-6 win in round 5, your final rank after Swissdraw is 8th.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Flying Angelsfor rank 1 on Field 10 at 15:00',NULL,1308399928,NULL,NULL,NULL),(548,29,6,1,'After a 12-11 win in round 5, your final rank after Swissdraw is 5th.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Bolognafor rank 1 on Field 6 at 15:00',NULL,1308399928,NULL,NULL,NULL),(549,17,6,1,'After a 13-6 win in round 5, your final rank after Swissdraw is 4th.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Denmarkfor rank 1 on Field 6 at 15:00',NULL,1308399928,NULL,NULL,NULL),(550,14,6,1,'After a 11-12 loss in round 5, your final rank after Swissdraw is 6th.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play 7Schwabenfor rank 1 on Field 14 at 15:00',NULL,1308399928,NULL,NULL,NULL),(551,32,6,1,'After a 15-5 win in round 5, your final rank after Swissdraw is 3rd.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Pissottefor rank 1 on Field 14 at 15:00',NULL,1308399928,NULL,NULL,NULL),(552,11,6,1,'After a 15-8 win in round 5, your final rank after Swissdraw is 7th.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Freespeedfor rank 1 on Field 8 at 15:00',NULL,1308399928,NULL,NULL,NULL),(553,35,6,1,'After a 14-13 win in round 5, your final rank after Swissdraw is 2nd.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Rebelfor rank 1 on Field 8 at 15:00',NULL,1308399928,NULL,NULL,NULL),(554,1,9,1,'After a 15-4 win in round 5, your final rank after Swissdraw is 9th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Mooncatchersfor rank 9 on Field 9 at 15:00',NULL,1308399932,NULL,NULL,NULL),(555,9,9,1,'After a 15-5 win in round 5, your final rank after Swissdraw is 16th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Gentlefor rank 9 on Field 9 at 15:00',NULL,1308399932,NULL,NULL,NULL),(556,16,9,1,'After a 11-10 win in round 5, your final rank after Swissdraw is 13th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play FranceMasterfor rank 9 on Field 12 at 15:00',NULL,1308399932,NULL,NULL,NULL),(557,2,9,1,'After a 15-4 win in round 5, your final rank after Swissdraw is 12th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Solebangfor rank 9 on Field 12 at 15:00',NULL,1308399932,NULL,NULL,NULL),(558,12,9,1,'After a 5-15 loss in round 5, your final rank after Swissdraw is 14th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Flying Biscfor rank 9 on Field 5 at 15:00',NULL,1308399932,NULL,NULL,NULL),(559,36,9,1,'After a 15-7 win in round 5, your final rank after Swissdraw is 11th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Silencefor rank 9 on Field 5 at 15:00',NULL,1308399932,NULL,NULL,NULL),(560,24,9,1,'After a 10-11 loss in round 5, your final rank after Swissdraw is 15th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Russiafor rank 9 on Field 13 at 15:00',NULL,1308399932,NULL,NULL,NULL),(561,26,9,1,'After a 15-1 win in round 5, your final rank after Swissdraw is 10th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Gummibaerchenfor rank 9 on Field 13 at 15:00',NULL,1308399932,NULL,NULL,NULL),(562,18,12,1,'After a 6-13 loss in round 5, your final rank after Swissdraw is 17th.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Spainfor rank 17 on Field 7 at 15:00',NULL,1308399936,NULL,NULL,NULL),(563,20,12,1,'After a 7-15 loss in round 5, your final rank after Swissdraw is 24th.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play M.U.C.for rank 17 on Field 7 at 15:00',NULL,1308399937,NULL,NULL,NULL),(564,23,12,1,'After a 6-12 loss in round 5, your final rank after Swissdraw is 21st.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Iznogoodfor rank 17 on Field 18 at 15:00',NULL,1308399937,NULL,NULL,NULL),(565,21,12,1,'After a 15-4 win in round 5, your final rank after Swissdraw is 20th.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play German Juniorfor rank 17 on Field 18 at 15:00',NULL,1308399937,NULL,NULL,NULL),(566,25,12,1,'After a 15-4 win in round 5, your final rank after Swissdraw is 22nd.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play theBigEzfor rank 17 on Field 19 at 15:00',NULL,1308399937,NULL,NULL,NULL),(567,15,12,1,'After a 15-11 win in round 5, your final rank after Swissdraw is 19th.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Panthersfor rank 17 on Field 19 at 15:00',NULL,1308399937,NULL,NULL,NULL),(568,40,12,1,'After a 8-15 loss in round 5, your final rank after Swissdraw is 23rd.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Rainbow Warriorsfor rank 17 on Field 11 at 15:00',NULL,1308399937,NULL,NULL,NULL),(569,3,12,1,'After a 15-5 win in round 5, your final rank after Swissdraw is 18th.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Netherlandsfor rank 17 on Field 11 at 15:00',NULL,1308399937,NULL,NULL,NULL),(570,41,15,1,'After a 14-5 win in round 5, your final rank after Swissdraw is 25th.You will thus play for rank 25 to 32.In the Quarterfinals,you\'ll play Friselisfor rank 25 on Field 2 at 15:00',NULL,1308399941,NULL,NULL,NULL),(571,31,15,1,'After a 4-15 loss in round 5, your final rank after Swissdraw is 32nd.You will thus play for rank 25 to 32.In the Quarterfinals,you\'ll play German Mastersfor rank 25 on Field 2 at 15:00',NULL,1308399942,NULL,NULL,NULL),(572,6,15,1,'After a 11-15 loss in round 5, your final rank after Swissdraw is 29th.You will thus play for rank 25 to 32.In the Quarterfinals,you\'ll play Carapedosfor rank 25 on Field 16 at 15:00',NULL,1308399942,NULL,NULL,NULL),(573,4,15,1,'After a 14-8 win in round 5, your final rank after Swissdraw is 28th.You will thus play for rank 25 to 32.In the Quarterfinals,you\'ll play Hardfischfor rank 25 on Field 16 at 15:00',NULL,1308399942,NULL,NULL,NULL),(574,30,15,1,'After a 15-12 win in round 5, your final rank after Swissdraw is 30th.You will thus play for rank 25 to 32.In the Quarterfinals,you\'ll play KoBOldfor rank 25 on Field 17 at 15:00',NULL,1308399942,NULL,NULL,NULL),(575,5,15,1,'After a 13-8 win in round 5, your final rank after Swissdraw is 27th.You will thus play for rank 25 to 32.In the Quarterfinals,you\'ll play Sunfor rank 25 on Field 17 at 15:00',NULL,1308399942,NULL,NULL,NULL),(576,38,15,1,'After a 5-15 loss in round 5, your final rank after Swissdraw is 31st.You will thus play for rank 25 to 32.In the Quarterfinals,you\'ll play MAMfor rank 25 on Field 1 at 15:00',NULL,1308399942,NULL,NULL,NULL),(577,10,15,1,'After a 4-15 loss in round 5, your final rank after Swissdraw is 26th.You will thus play for rank 25 to 32.In the Quarterfinals,you\'ll play Les etoiles ofor rank 25 on Field 1 at 15:00',NULL,1308399942,NULL,NULL,NULL),(578,39,18,1,'After a 1-15 loss in round 5, your final rank after Swissdraw is 33rd.You will thus play for rank 33 to 41.In the Quarterfinals,you\'ll play Xlr8rsfor rank 33 on Field 15 at 15:00',NULL,1308399947,NULL,NULL,NULL),(579,8,18,1,'After a 5-14 loss in round 5, your final rank after Swissdraw is 40th.You will thus play for rank 33 to 41.In the Quarterfinals,you\'ll play Cambo Cakesfor rank 33 on Field 15 at 15:00',NULL,1308399947,NULL,NULL,NULL),(580,33,18,1,'After a 4-15 loss in round 5, your final rank after Swissdraw is 37th.You will thus play for rank 33 to 38.In the Quarterfinals,you\'ll play Tsunamifor rank 33 on Field 3 at 15:00',NULL,1308399948,NULL,NULL,NULL),(581,7,18,1,'After a 4-15 loss in round 5, your final rank after Swissdraw is 36th.You will thus play for rank 33 to 38.In the Quarterfinals,you\'ll play Barbastrejifor rank 33 on Field 3 at 15:00',NULL,1308399948,NULL,NULL,NULL),(582,22,18,1,'After a 15-8 win in round 5, your final rank after Swissdraw is 38th.You will thus play for rank 33 to 41.In the Quarterfinals,you\'ll play deLuxfor rank 33 on Field 4 at 15:00',NULL,1308399948,NULL,NULL,NULL),(583,34,18,1,'After a 8-13 loss in round 5, your final rank after Swissdraw is 35th.You will thus play for rank 33 to 41.In the Quarterfinals,you\'ll play UL Ninjasfor rank 33 on Field 4 at 15:00',NULL,1308399948,NULL,NULL,NULL),(584,27,18,1,'After a 8-14 loss in round 5, your final rank after Swissdraw is 39th.You will thus play for rank 33 to 41.In the Quarterfinals,you\'ll play Funaticsfor rank 33 on Field 20 at 15:00',NULL,1308399948,NULL,NULL,NULL),(585,13,18,1,'After a 5-15 loss in round 5, your final rank after Swissdraw is 34th.You will thus play for rank 33 to 41.In the Quarterfinals,you\'ll play Buggolifor rank 33 on Field 20 at 15:00',NULL,1308399948,NULL,NULL,NULL),(586,28,18,1,'After a 8-15 loss in round 5, your final rank after Swissdraw is 41st.You will thus play for rank 40 to 41.In the Quarterfinals,you can take a break due to the odd number of teams.',NULL,1308399948,NULL,NULL,NULL),(587,77,44,1,'After a 13-6 win in the previous round, you\'ll play Denmark on Field 5 at 16:30',NULL,1308404541,NULL,NULL,NULL),(588,73,44,1,'After a 15-3 win in the previous round, you\'ll play GB on Field 5 at 16:30',NULL,1308404541,NULL,NULL,NULL),(589,79,44,1,'After a 12-8 win in the previous round, you\'ll play Hot Beaches on Field 6 at 16:30',NULL,1308404541,NULL,NULL,NULL),(590,71,44,1,'After a 6-13 loss in the previous round, you\'ll play Germany on Field 6 at 16:30',NULL,1308404541,NULL,NULL,NULL),(591,76,44,1,'After a 12-11 win in the previous round, you\'ll play Switzerland on Field 7 at 16:30',NULL,1308404541,NULL,NULL,NULL),(592,80,44,1,'After a 8-12 loss in the previous round, you\'ll play Italy on Field 7 at 16:30',NULL,1308404541,NULL,NULL,NULL),(593,74,44,1,'After a 15-0 win in the previous round, you\'ll play France on Field 8 at 16:30',NULL,1308404541,NULL,NULL,NULL),(594,72,44,1,'After a 11-12 loss in the previous round, you\'ll play Ireland on Field 8 at 16:30',NULL,1308404541,NULL,NULL,NULL),(595,81,44,1,'After a break in the previous round, you\'ll play Russia on Field 9 at 16:30',NULL,1308404541,NULL,NULL,NULL),(596,82,44,1,'After a 14-5 win in the previous round, you\'ll play Holland on Field 9 at 16:30',NULL,1308404541,NULL,NULL,NULL),(597,75,44,1,'After a 3-15 loss in the previous round, you\'ll play Chakalakas on Field 10 at 16:30',NULL,1308404541,NULL,NULL,NULL),(598,70,44,1,'After a 0-15 loss in the previous round, you\'ll play Seagulls on Field 10 at 16:30',NULL,1308404541,NULL,NULL,NULL),(599,78,44,1,'After a 5-14 loss in the previous round, due to the odd number of teams,you can take a break at 16:30',NULL,1308404541,NULL,NULL,NULL),(600,47,26,1,'After a 15-12 win in round 5, your final rank after Swissdraw is 1st.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Frizzly Bearsfor rank 1 on Field 1 at 16:30',NULL,1308404989,NULL,NULL,NULL),(601,62,26,1,'After a 8-15 loss in round 5, your final rank after Swissdraw is 8th.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Francefor rank 1 on Field 1 at 16:30',NULL,1308404989,NULL,NULL,NULL),(602,51,26,1,'After a 8-14 loss in round 5, your final rank after Swissdraw is 5th.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Sexy Legsfor rank 1 on Field 2 at 16:30',NULL,1308404989,NULL,NULL,NULL),(603,64,26,1,'After a 14-9 win in round 5, your final rank after Swissdraw is 4th.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Austriafor rank 1 on Field 2 at 16:30',NULL,1308404989,NULL,NULL,NULL),(604,59,26,1,'After a 12-15 loss in round 5, your final rank after Swissdraw is 6th.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Hollandfor rank 1 on Field 3 at 16:30',NULL,1308404989,NULL,NULL,NULL),(605,56,26,1,'After a 15-8 win in round 5, your final rank after Swissdraw is 3rd.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Irelandfor rank 1 on Field 3 at 16:30',NULL,1308404989,NULL,NULL,NULL),(606,69,26,1,'After a 15-5 win in round 5, your final rank after Swissdraw is 7th.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Germanyfor rank 1 on Field 4 at 16:30',NULL,1308404989,NULL,NULL,NULL),(607,54,26,1,'After a 14-8 win in round 5, your final rank after Swissdraw is 2nd.You will thus play for rank 1 to 8.In the Quarterfinals,you\'ll play Russiafor rank 1 on Field 4 at 16:30',NULL,1308404989,NULL,NULL,NULL),(608,55,29,1,'After a 10-7 win in round 5, your final rank after Swissdraw is 9th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Frisbee Familyfor rank 9 on Field 11 at 16:30',NULL,1308404993,NULL,NULL,NULL),(609,65,29,1,'After a 15-11 win in round 5, your final rank after Swissdraw is 16th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Robiramfor rank 9 on Field 11 at 16:30',NULL,1308404993,NULL,NULL,NULL),(610,49,29,1,'After a 7-10 loss in round 5, your final rank after Swissdraw is 13th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Superflyfor rank 9 on Field 15 at 16:30',NULL,1308404993,NULL,NULL,NULL),(611,44,29,1,'After a 10-4 win in round 5, your final rank after Swissdraw is 12th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Spirit on Lemonfor rank 9 on Field 15 at 16:30',NULL,1308404993,NULL,NULL,NULL),(612,48,29,1,'After a 11-5 win in round 5, your final rank after Swissdraw is 14th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Drehst\'nDeckelfor rank 9 on Field 16 at 16:30',NULL,1308404993,NULL,NULL,NULL),(613,67,29,1,'After a 15-13 win in round 5, your final rank after Swissdraw is 11th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Stockholmfor rank 9 on Field 16 at 16:30',NULL,1308404993,NULL,NULL,NULL),(614,45,29,1,'After a 13-15 loss in round 5, your final rank after Swissdraw is 15th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play Quijotesfor rank 9 on Field 14 at 16:30',NULL,1308404993,NULL,NULL,NULL),(615,46,29,1,'After a 9-14 loss in round 5, your final rank after Swissdraw is 10th.You will thus play for rank 9 to 16.In the Quarterfinals,you\'ll play PUFfor rank 9 on Field 14 at 16:30',NULL,1308404993,NULL,NULL,NULL),(616,61,32,1,'After a 13-12 win in round 5, your final rank after Swissdraw is 17th.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Turkeyfor rank 17 on Field 12 at 16:30',NULL,1308404997,NULL,NULL,NULL),(617,60,32,1,'After a 10-4 win in round 5, your final rank after Swissdraw is 24th.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Cranberryfor rank 17 on Field 12 at 16:30',NULL,1308404997,NULL,NULL,NULL),(618,50,32,1,'After a 11-7 win in round 5, your final rank after Swissdraw is 21st.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Nuts\'nBerriesfor rank 17 on Field 13 at 16:30',NULL,1308404997,NULL,NULL,NULL),(619,53,32,1,'After a 5-15 loss in round 5, your final rank after Swissdraw is 20th.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Cheek2Cheekfor rank 17 on Field 13 at 16:30',NULL,1308404997,NULL,NULL,NULL),(620,43,32,1,'After a 4-10 loss in round 5, your final rank after Swissdraw is 22nd.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Rusty Bikesfor rank 17 on Field 17 at 16:30',NULL,1308404997,NULL,NULL,NULL),(621,52,32,1,'After a 15-4 win in round 5, your final rank after Swissdraw is 19th.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Disco Stufor rank 17 on Field 17 at 16:30',NULL,1308404997,NULL,NULL,NULL),(622,58,32,1,'After a 11-15 loss in round 5, your final rank after Swissdraw is 23rd.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Switzerlandfor rank 17 on Field 18 at 16:30',NULL,1308404997,NULL,NULL,NULL),(623,66,32,1,'After a 12-13 loss in round 5, your final rank after Swissdraw is 18th.You will thus play for rank 17 to 24.In the Quarterfinals,you\'ll play Akkafor rank 17 on Field 18 at 16:30',NULL,1308404997,NULL,NULL,NULL),(624,63,35,1,'After a 5-11 loss in round 5, your final rank after Swissdraw is 25th.You will play a RoundRobin for rank 25 to 28.In round 1,you\'ll play Aye-Aye on Field 19 at 16:30',NULL,1308405000,NULL,NULL,NULL),(625,68,35,1,'After a 7-11 loss in round 5, your final rank after Swissdraw is 27th.You will play a RoundRobin for rank 25 to 28.In round 1,you\'ll play Moscow on Field 19 at 16:30',NULL,1308405001,NULL,NULL,NULL),(626,57,35,1,'After a 4-10 loss in round 5, your final rank after Swissdraw is 26th.You will play a RoundRobin for rank 25 to 28.In round 1,you\'ll play on Field 20 at 16:30',NULL,1308405002,NULL,NULL,NULL),(627,84,35,1,'After a 4-15 loss in round 5, your final rank after Swissdraw is 28th.You will play a RoundRobin for rank 25 to 28.In round 1,you\'ll play WAF on Field 20 at 16:30',NULL,1308405003,NULL,NULL,NULL),(628,19,7,1,'After a 15-12 win in the Quarterfinals,you\'ll play Bolognafor rank 1 on Field 1 at 18:00',NULL,1308409416,NULL,NULL,NULL),(629,17,7,1,'After a 13-8 win in the Quarterfinals,you\'ll play Flying Angelsfor rank 1 on Field 1 at 18:00',NULL,1308409416,NULL,NULL,NULL),(630,32,7,1,'After a 11-9 win in the Quarterfinals,you\'ll play Freespeedfor rank 1 on Field 2 at 18:00',NULL,1308409416,NULL,NULL,NULL),(631,35,7,1,'After a 12-5 win in the Quarterfinals,you\'ll play 7Schwabenfor rank 1 on Field 2 at 18:00',NULL,1308409416,NULL,NULL,NULL),(632,37,7,1,'After a 12-15 loss in the Quarterfinals,you\'ll play Denmarkfor rank 5 on Field 6 at 18:00',NULL,1308409417,NULL,NULL,NULL),(633,29,7,1,'After a 8-13 loss in the Quarterfinals,you\'ll play Red Lightsfor rank 5 on Field 6 at 18:00',NULL,1308409417,NULL,NULL,NULL),(634,14,7,1,'After a 9-11 loss in the Quarterfinals,you\'ll play Rebelfor rank 5 on Field 7 at 18:00',NULL,1308409417,NULL,NULL,NULL),(635,11,7,1,'After a 5-12 loss in the Quarterfinals,you\'ll play Pissottefor rank 5 on Field 7 at 18:00',NULL,1308409417,NULL,NULL,NULL),(636,9,10,1,'After a 15-12 win in the Quarterfinals,you\'ll play FranceMasterfor rank 9 on Field 8 at 18:00',NULL,1308409420,NULL,NULL,NULL),(637,2,10,1,'After a 15-2 win in the Quarterfinals,you\'ll play Mooncatchersfor rank 9 on Field 8 at 18:00',NULL,1308409420,NULL,NULL,NULL),(638,12,10,1,'After a 15-9 win in the Quarterfinals,you\'ll play Russiafor rank 9 on Field 9 at 18:00',NULL,1308409420,NULL,NULL,NULL),(639,26,10,1,'After a 15-4 win in the Quarterfinals,you\'ll play Silencefor rank 9 on Field 9 at 18:00',NULL,1308409420,NULL,NULL,NULL),(640,1,10,1,'After a 12-15 loss in the Quarterfinals,you\'ll play Solebangfor rank 13 on Field 17 at 18:00',NULL,1308409420,NULL,NULL,NULL),(641,16,10,1,'After a 2-15 loss in the Quarterfinals,you\'ll play Gentlefor rank 13 on Field 17 at 18:00',NULL,1308409420,NULL,NULL,NULL),(642,36,10,1,'After a 9-15 loss in the Quarterfinals,you\'ll play Gummibaerchenfor rank 13 on Field 18 at 18:00',NULL,1308409420,NULL,NULL,NULL),(643,24,10,1,'After a 4-15 loss in the Quarterfinals,you\'ll play Flying Biscfor rank 13 on Field 18 at 18:00',NULL,1308409420,NULL,NULL,NULL),(644,18,13,1,'After a 13-9 win in the Quarterfinals,you\'ll play German Juniorfor rank 17 on Field 13 at 18:00',NULL,1308409423,NULL,NULL,NULL),(645,23,13,1,'After a 15-7 win in the Quarterfinals,you\'ll play M.U.C.for rank 17 on Field 13 at 18:00',NULL,1308409423,NULL,NULL,NULL),(646,15,13,1,'After a 12-11 win in the Quarterfinals,you\'ll play Netherlandsfor rank 17 on Field 20 at 18:00',NULL,1308409423,NULL,NULL,NULL),(647,40,13,1,'After a 15-8 win in the Quarterfinals,you\'ll play theBigEzfor rank 17 on Field 20 at 18:00',NULL,1308409423,NULL,NULL,NULL),(648,20,13,1,'After a 9-13 loss in the Quarterfinals,you\'ll play Iznogoodfor rank 21 on Field 10 at 18:00',NULL,1308409423,NULL,NULL,NULL),(649,21,13,1,'After a 7-15 loss in the Quarterfinals,you\'ll play Spainfor rank 21 on Field 10 at 18:00',NULL,1308409423,NULL,NULL,NULL),(650,25,13,1,'After a 11-12 loss in the Quarterfinals,you\'ll play Rainbow Warriorsfor rank 21 on Field 19 at 18:00',NULL,1308409423,NULL,NULL,NULL),(651,3,13,1,'After a 8-15 loss in the Quarterfinals,you\'ll play Panthersfor rank 21 on Field 19 at 18:00',NULL,1308409423,NULL,NULL,NULL),(652,31,16,1,'After a 13-5 win in the Quarterfinals,you\'ll play Hardfischfor rank 25 on Field 14 at 18:00',NULL,1308409426,NULL,NULL,NULL),(653,6,16,1,'After a 15-5 win in the Quarterfinals,you\'ll play Friselisfor rank 25 on Field 14 at 18:00',NULL,1308409427,NULL,NULL,NULL),(654,30,16,1,'After a 15-12 win in the Quarterfinals,you\'ll play Les etoiles ofor rank 25 on Field 11 at 18:00',NULL,1308409427,NULL,NULL,NULL),(655,38,16,1,'After a 15-5 win in the Quarterfinals,you\'ll play Sunfor rank 25 on Field 11 at 18:00',NULL,1308409427,NULL,NULL,NULL),(656,41,16,1,'After a 5-13 loss in the Quarterfinals,you\'ll play Carapedosfor rank 29 on Field 12 at 18:00',NULL,1308409427,NULL,NULL,NULL),(657,4,16,1,'After a 5-15 loss in the Quarterfinals,you\'ll play German Mastersfor rank 29 on Field 12 at 18:00',NULL,1308409427,NULL,NULL,NULL),(658,5,16,1,'After a 12-15 loss in the Quarterfinals,you\'ll play MAMfor rank 29 on Field 3 at 18:00',NULL,1308409427,NULL,NULL,NULL),(659,10,16,1,'After a 5-15 loss in the Quarterfinals,you\'ll play KoBOldfor rank 29 on Field 3 at 18:00',NULL,1308409427,NULL,NULL,NULL),(660,39,19,1,'After a 14-9 win in the Quarterfinals,you\'ll play Barbastrejifor rank 33 on Field 4 at 18:00',NULL,1308409430,NULL,NULL,NULL),(661,33,19,1,'After a 14-11 win in the Quarterfinals,you\'ll play Cambo Cakesfor rank 33 on Field 4 at 18:00',NULL,1308409430,NULL,NULL,NULL),(662,34,19,1,'After a 15-5 win in the Quarterfinals,you\'ll play Funaticsfor rank 33 on Field 5 at 18:00',NULL,1308409430,NULL,NULL,NULL),(663,13,19,1,'After a 10-6 win in the Quarterfinals,you\'ll play deLuxfor rank 33 on Field 5 at 18:00',NULL,1308409430,NULL,NULL,NULL),(664,28,19,1,'After a break in the Quarterfinals,you\'ll play UL Ninjasfor rank 40 on Field 15 at 18:00',NULL,1308409430,NULL,NULL,NULL),(665,22,19,1,'After a 5-15 loss in the Quarterfinals,you\'ll play Soimiifor rank 40 on Field 15 at 18:00',NULL,1308409430,NULL,NULL,NULL),(666,8,19,1,'After a 9-14 loss in the Quarterfinals,you\'ll play Buggolifor rank 37 on Field 16 at 18:00',NULL,1308409430,NULL,NULL,NULL),(667,27,19,1,'After a 6-10 loss in the Quarterfinals,you\'ll play Xlr8rsfor rank 37 on Field 16 at 18:00',NULL,1308409430,NULL,NULL,NULL),(668,7,19,1,'After a 11-14 loss in the Quarterfinals,you can take a break due to the odd number of teams.',NULL,1308409430,NULL,NULL,NULL),(669,47,27,1,'After a 14-6 win in the Quarterfinals,you\'ll play Austria on Field 1tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414692,NULL,NULL,NULL),(670,51,27,1,'After a 15-5 win in the Quarterfinals,you\'ll play France on Field 1tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414692,NULL,NULL,NULL),(671,56,27,1,'After a 13-8 win in the Quarterfinals,you\'ll play Germany on Field 18tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414692,NULL,NULL,NULL),(672,54,27,1,'After a 15-7 win in the Quarterfinals,you\'ll play Holland on Field 18tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414692,NULL,NULL,NULL),(673,62,27,1,'After a 6-14 loss in the Quarterfinals,you\'ll play Sexy Legs on Field 6tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414692,NULL,NULL,NULL),(674,64,27,1,'After a 5-15 loss in the Quarterfinals,you\'ll play Frizzly Bears on Field 6tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414692,NULL,NULL,NULL),(675,59,27,1,'After a 8-13 loss in the Quarterfinals,you\'ll play Russia on Field 12tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414692,NULL,NULL,NULL),(676,69,27,1,'After a 7-15 loss in the Quarterfinals,you\'ll play Ireland on Field 12tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414692,NULL,NULL,NULL),(677,55,30,1,'After a 15-2 win in the Quarterfinals,you\'ll play Spirit on Lemon on Field 19tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414695,NULL,NULL,NULL),(678,49,30,1,'After a 15-5 win in the Quarterfinals,you\'ll play Robiram on Field 19tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414695,NULL,NULL,NULL),(679,67,30,1,'After a 10-7 win in the Quarterfinals,you\'ll play PUF on Field 7tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414695,NULL,NULL,NULL),(680,45,30,1,'After a 12-11 win in the Quarterfinals,you\'ll play Drehst\'nDeckel on Field 7tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414695,NULL,NULL,NULL),(681,65,30,1,'After a 2-15 loss in the Quarterfinals,you\'ll play Superfly on Field 15tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414695,NULL,NULL,NULL),(682,44,30,1,'After a 5-15 loss in the Quarterfinals,you\'ll play Frisbee Family on Field 15tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414695,NULL,NULL,NULL),(683,48,30,1,'After a 7-10 loss in the Quarterfinals,you\'ll play Quijotes on Field 13tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414695,NULL,NULL,NULL),(684,46,30,1,'After a 11-12 loss in the Quarterfinals,you\'ll play Stockholm on Field 13tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414695,NULL,NULL,NULL),(685,60,33,1,'After a 13-8 win in the Quarterfinals,you\'ll play Nuts\'nBerries on Field 11tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414698,NULL,NULL,NULL),(686,53,33,1,'After a 15-12 win in the Quarterfinals,you\'ll play Turkey on Field 11tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414698,NULL,NULL,NULL),(687,52,33,1,'After a 12-6 win in the Quarterfinals,you\'ll play Switzerland on Field 10tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414698,NULL,NULL,NULL),(688,66,33,1,'After a 15-3 win in the Quarterfinals,you\'ll play Rusty Bikes on Field 10tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414699,NULL,NULL,NULL),(689,61,33,1,'After a 8-13 loss in the Quarterfinals,you\'ll play Cheek2Cheek on Field 14tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414699,NULL,NULL,NULL),(690,50,33,1,'After a 12-15 loss in the Quarterfinals,you\'ll play Cranberry on Field 14tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414699,NULL,NULL,NULL),(691,43,33,1,'After a 6-12 loss in the Quarterfinals,you\'ll play Akka on Field 8tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414699,NULL,NULL,NULL),(692,58,33,1,'After a 3-15 loss in the Quarterfinals,you\'ll play Disco Stu on Field 8tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414699,NULL,NULL,NULL),(693,57,36,1,'After a 15-2 win,you\'ll play on Field 20 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414702,NULL,NULL,NULL),(694,84,36,1,'After a 8-15 loss,you\'ll play WAF on Field 20 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414702,NULL,NULL,NULL),(695,68,36,1,'After a 2-15 loss,you\'ll play Moscow on Field 2 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414702,NULL,NULL,NULL),(696,63,36,1,'After a 15-8 win,you\'ll play Aye-Aye on Field 2 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308414702,NULL,NULL,NULL),(697,71,45,1,'After a 15-12 win in the previous round, you\'ll play Italy on Field 3 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(698,76,45,1,'After a 14-9 win in the previous round, you\'ll play Hot Beaches on Field 3 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(699,78,45,1,'After a break in the previous round, you\'ll play Chakalakas on Field 4 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(700,70,45,1,'After a 4-15 loss in the previous round, you\'ll play Thalys on Field 4 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(701,75,45,1,'After a 15-4 win in the previous round, you\'ll play Holland on Field 5 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(702,81,45,1,'After a 6-13 loss in the previous round, you\'ll play Seagulls on Field 5 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(703,77,45,1,'After a 11-8 win in the previous round, you\'ll play Ireland on Field 9 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(704,74,45,1,'After a 14-8 win in the previous round, you\'ll play GB on Field 9 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(705,72,45,1,'After a 8-14 loss in the previous round, you\'ll play Denmark on Field 16 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(706,73,45,1,'After a 8-11 loss in the previous round, you\'ll play France on Field 16 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(707,80,45,1,'After a 9-14 loss in the previous round, you\'ll play Germany on Field 17 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(708,79,45,1,'After a 12-15 loss in the previous round, you\'ll play Switzerland on Field 17 tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416311,NULL,NULL,NULL),(709,82,45,1,'After a 13-6 win in the previous round, due to the odd number of teams,you can take a break tomorrow at 9:00.Please hand in today\'s spirit scores!',NULL,1308416312,NULL,NULL,NULL),(710,57,NULL,1,'We adjusted your games tomorrow: You play Aye-Aye at 9:00, Field 2. Then, Moscow at 12:00 on Field 19. ',NULL,1308420336,NULL,NULL,NULL),(711,68,NULL,1,'We adjusted your games tomorrow: You play WAF at 9:00, Field 2. Then, Born Yesterday at 12:00 on Field 20. ',NULL,1308420365,NULL,NULL,NULL),(712,84,NULL,1,'We adjusted your games tomorrow: You play Moscow at 9:00, Field 20. Then, Aye-Aye at 12:00 on Field 20. ',NULL,1308420387,NULL,NULL,NULL),(713,63,NULL,1,'We adjusted your games tomorrow: You play Born Yesterday at 9:00, Field 2. Then, WAF at 12:00 on Field 19. ',NULL,1308420413,NULL,NULL,NULL),(714,19,8,1,'After a 15-7 win in the Semifinals,you\'ll play 7Schwabenfor rank 1 on Field 3tomorrow at 15:00.Please hand in today\'s spirit scores!',NULL,1308420862,NULL,NULL,NULL),(715,32,8,1,'After a 12-8 win in the Semifinals,you\'ll play Flying Angelsfor rank 1 on Field 3tomorrow at 15:00.Please hand in today\'s spirit scores!',NULL,1308420862,NULL,NULL,NULL),(716,35,8,1,'After a 8-12 loss in the Semifinals,you\'ll play Bolognafor rank 3 on Field 2tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420862,NULL,NULL,NULL),(717,17,8,1,'After a 7-15 loss in the Semifinals,you\'ll play Freespeedfor rank 3 on Field 2tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420862,NULL,NULL,NULL),(718,29,8,1,'After a 15-4 win in the Semifinals,you\'ll play Pissottefor rank 5 on Field 4tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420862,NULL,NULL,NULL),(719,14,8,1,'After a 14-4 win in the Semifinals,you\'ll play Denmarkfor rank 5 on Field 4tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420862,NULL,NULL,NULL),(720,11,8,1,'After a 4-14 loss in the Semifinals,you\'ll play Red Lightsfor rank 7 on Field 1tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420862,NULL,NULL,NULL),(721,37,8,1,'After a 4-15 loss in the Semifinals,you\'ll play Rebelfor rank 7 on Field 1tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420862,NULL,NULL,NULL),(722,2,11,1,'After a 15-13 win in the Semifinals,you\'ll play Russiafor rank 9 on Field 5tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420866,NULL,NULL,NULL),(723,26,11,1,'After a 12-11 win in the Semifinals,you\'ll play FranceMasterfor rank 9 on Field 5tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420866,NULL,NULL,NULL),(724,12,11,1,'After a 11-12 loss in the Semifinals,you\'ll play Mooncatchersfor rank 11 on Field 6tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420866,NULL,NULL,NULL),(725,9,11,1,'After a 13-15 loss in the Semifinals,you\'ll play Silencefor rank 11 on Field 6tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420866,NULL,NULL,NULL),(726,1,11,1,'After a 15-9 win in the Semifinals,you\'ll play Flying Biscfor rank 13 on Field 7tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420866,NULL,NULL,NULL),(727,36,11,1,'After a 15-2 win in the Semifinals,you\'ll play Gentlefor rank 13 on Field 7tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420866,NULL,NULL,NULL),(728,24,11,1,'After a 2-15 loss in the Semifinals,you\'ll play Solebangfor rank 15 on Field 8tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420866,NULL,NULL,NULL),(729,16,11,1,'After a 9-15 loss in the Semifinals,you\'ll play Gummibaerchenfor rank 15 on Field 8tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420866,NULL,NULL,NULL),(730,18,14,1,'After a 15-7 win in the Semifinals,you\'ll play theBigEzfor rank 17 on Field 9tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420870,NULL,NULL,NULL),(731,15,14,1,'After a 14-6 win in the Semifinals,you\'ll play M.U.C.for rank 17 on Field 9tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420870,NULL,NULL,NULL),(732,40,14,1,'After a 6-14 loss in the Semifinals,you\'ll play German Juniorfor rank 19 on Field 10tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420870,NULL,NULL,NULL),(733,23,14,1,'After a 7-15 loss in the Semifinals,you\'ll play Netherlandsfor rank 19 on Field 10tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420870,NULL,NULL,NULL),(734,20,14,1,'After a 15-2 win in the Semifinals,you\'ll play Rainbow Warriorsfor rank 21 on Field 12tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420870,NULL,NULL,NULL),(735,3,14,1,'After a 15-10 win in the Semifinals,you\'ll play Spainfor rank 21 on Field 12tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420870,NULL,NULL,NULL),(736,25,14,1,'After a 10-15 loss in the Semifinals,you\'ll play Iznogoodfor rank 23 on Field 11tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420870,NULL,NULL,NULL),(737,21,14,1,'After a 2-15 loss in the Semifinals,you\'ll play Panthersfor rank 23 on Field 11tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420870,NULL,NULL,NULL),(738,6,17,1,'After a 15-10 win in the Semifinals,you\'ll play Sunfor rank 25 on Field 13tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420873,NULL,NULL,NULL),(739,30,17,1,'After a 14-11 win in the Semifinals,you\'ll play Hardfischfor rank 25 on Field 13tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420873,NULL,NULL,NULL),(740,38,17,1,'After a 11-14 loss in the Semifinals,you\'ll play Friselisfor rank 27 on Field 14tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420874,NULL,NULL,NULL),(741,31,17,1,'After a 10-15 loss in the Semifinals,you\'ll play Les etoiles ofor rank 27 on Field 14tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420874,NULL,NULL,NULL),(742,41,17,1,'After a 15-7 win in the Semifinals,you\'ll play MAMfor rank 29 on Field 15tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420874,NULL,NULL,NULL),(743,10,17,1,'After a 15-11 win in the Semifinals,you\'ll play German Mastersfor rank 29 on Field 15tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420874,NULL,NULL,NULL),(744,5,17,1,'After a 11-15 loss in the Semifinals,you\'ll play Carapedosfor rank 31 on Field 16tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420874,NULL,NULL,NULL),(745,4,17,1,'After a 7-15 loss in the Semifinals,you\'ll play KoBOldfor rank 31 on Field 16tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420874,NULL,NULL,NULL),(746,39,20,1,'After a 15-6 win in the Semifinals,you\'ll play deLuxfor rank 33 on Field 17tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420877,NULL,NULL,NULL),(747,34,20,1,'After a 15-4 win in the Semifinals,you\'ll play Cambo Cakesfor rank 33 on Field 17tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420877,NULL,NULL,NULL),(748,13,20,1,'After a 4-15 loss in the Semifinals,you\'ll play Barbastrejifor rank 35 on Field 18tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420877,NULL,NULL,NULL),(749,33,20,1,'After a 6-15 loss in the Semifinals,you\'ll play Funaticsfor rank 35 on Field 18tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420877,NULL,NULL,NULL),(750,7,20,1,'After a break in the Semifinals,you\'ll play Buggolifor rank 37 on Field 19tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420877,NULL,NULL,NULL),(751,27,20,1,'After a 12-11 win in the Semifinals,you\'ll play Tsunamifor rank 37 on Field 19tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420877,NULL,NULL,NULL),(752,8,20,1,'After a 11-12 loss in the Semifinals,you\'ll play Soimiifor rank 40 on Field 20tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420877,NULL,NULL,NULL),(753,28,20,1,'After a 7-14 loss in the Semifinals,you\'ll play Xlr8rsfor rank 40 on Field 20tomorrow at 10:30.Please hand in today\'s spirit scores!',NULL,1308420877,NULL,NULL,NULL),(754,22,20,1,'After a 14-7 win in the Semifinals,you finish Windmill 2011 on rank 38.Please hand in today\'s spirit scores!',NULL,1308420878,NULL,NULL,NULL),(755,47,28,1,'After a 15-7 win in the Semifinals,you\'ll play Germanyfor rank 1 on Field 6 at 13:00',NULL,1308475929,NULL,NULL,NULL),(756,54,28,1,'After a 15-7 win in the Semifinals,you\'ll play Francefor rank 1 on Field 6 at 13:00',NULL,1308475930,NULL,NULL,NULL),(757,56,28,1,'After a 7-15 loss in the Semifinals,you\'ll play Austriafor rank 3 on Field 2 at 12:00',NULL,1308475930,NULL,NULL,NULL),(758,51,28,1,'After a 7-15 loss in the Semifinals,you\'ll play Hollandfor rank 3 on Field 2 at 12:00',NULL,1308475930,NULL,NULL,NULL),(759,64,28,1,'After a 14-11 win in the Semifinals,you\'ll play Irelandfor rank 5 on Field 1 at 12:00',NULL,1308475930,NULL,NULL,NULL),(760,59,28,1,'After a 15-5 win in the Semifinals,you\'ll play Sexy Legsfor rank 5 on Field 1 at 12:00',NULL,1308475930,NULL,NULL,NULL),(761,69,28,1,'After a 5-15 loss in the Semifinals,you\'ll play Frizzly Bearsfor rank 7 on Field 10 at 12:00',NULL,1308475930,NULL,NULL,NULL),(762,62,28,1,'After a 11-14 loss in the Semifinals,you\'ll play Russiafor rank 7 on Field 10 at 12:00',NULL,1308475930,NULL,NULL,NULL),(763,49,31,1,'After a 15-10 win in the Semifinals,you\'ll play Drehst\'nDeckelfor rank 9 on Field 13 at 12:00',NULL,1308475933,NULL,NULL,NULL),(764,67,31,1,'After a 11-10 win in the Semifinals,you\'ll play Spirit on Lemonfor rank 9 on Field 13 at 12:00',NULL,1308475933,NULL,NULL,NULL),(765,45,31,1,'After a 10-11 loss in the Semifinals,you\'ll play Robiramfor rank 11 on Field 11 at 12:00',NULL,1308475933,NULL,NULL,NULL),(766,55,31,1,'After a 10-15 loss in the Semifinals,you\'ll play PUFfor rank 11 on Field 11 at 12:00',NULL,1308475933,NULL,NULL,NULL),(767,65,31,1,'After a 15-8 win in the Semifinals,you\'ll play Stockholmfor rank 13 on Field 12 at 12:00',NULL,1308475933,NULL,NULL,NULL),(768,48,31,1,'After a 11-10 win in the Semifinals,you\'ll play Frisbee Familyfor rank 13 on Field 12 at 12:00',NULL,1308475933,NULL,NULL,NULL),(769,46,31,1,'After a 10-11 loss in the Semifinals,you\'ll play Superflyfor rank 15 on Field 14 at 12:00',NULL,1308475933,NULL,NULL,NULL),(770,44,31,1,'After a 8-15 loss in the Semifinals,you\'ll play Quijotesfor rank 15 on Field 14 at 12:00',NULL,1308475933,NULL,NULL,NULL),(771,53,34,1,'After a 10-7 win in the Semifinals,you\'ll play Switzerlandfor rank 17 on Field 15 at 12:00',NULL,1308475936,NULL,NULL,NULL),(772,66,34,1,'After a 15-5 win in the Semifinals,you\'ll play Nuts\'nBerriesfor rank 17 on Field 15 at 12:00',NULL,1308475936,NULL,NULL,NULL),(773,52,34,1,'After a 5-15 loss in the Semifinals,you\'ll play Turkeyfor rank 19 on Field 16 at 12:00',NULL,1308475936,NULL,NULL,NULL),(774,60,34,1,'After a 7-10 loss in the Semifinals,you\'ll play Rusty Bikesfor rank 19 on Field 16 at 12:00',NULL,1308475936,NULL,NULL,NULL),(775,61,34,1,'After a 15-11 win in the Semifinals,you\'ll play Akkafor rank 21 on Field 17 at 12:00',NULL,1308475936,NULL,NULL,NULL),(776,58,34,1,'After a 11-10 win in the Semifinals,you\'ll play Cranberryfor rank 21 on Field 17 at 12:00',NULL,1308475936,NULL,NULL,NULL),(777,43,34,1,'After a 10-11 loss in the Semifinals,you\'ll play Cheek2Cheekfor rank 23 on Field 18 at 12:00',NULL,1308475936,NULL,NULL,NULL),(778,50,34,1,'After a 11-15 loss in the Semifinals,you\'ll play Disco Stufor rank 23 on Field 18 at 12:00',NULL,1308475936,NULL,NULL,NULL),(779,57,37,1,'After a 15-7 win,you\'ll play Moscow on Field 19 at 12:00',NULL,1308475939,NULL,NULL,NULL),(780,63,37,1,'After a 15-8 win,you\'ll play WAF on Field 19 at 12:00',NULL,1308475939,NULL,NULL,NULL),(781,84,37,1,'After a 7-15 loss,you\'ll play Aye-Aye on Field 20 at 12:00',NULL,1308475939,NULL,NULL,NULL),(782,68,37,1,'After a 8-15 loss,you\'ll play on Field 20 at 12:00',NULL,1308475939,NULL,NULL,NULL),(783,74,46,1,'After a 4-15 loss in the previous round, you\'ll play Hot Beaches on Field 4 at 12:00',NULL,1308477002,NULL,NULL,NULL),(784,71,46,1,'After a 7-15 loss in the previous round, you\'ll play Ireland on Field 4 at 12:00',NULL,1308477002,NULL,NULL,NULL),(785,73,46,1,'After a 15-9 win in the previous round, you\'ll play Germany on Field 5 at 12:00',NULL,1308477002,NULL,NULL,NULL),(786,79,46,1,'After a 15-11 win in the previous round, you\'ll play Denmark on Field 5 at 12:00',NULL,1308477002,NULL,NULL,NULL),(787,81,46,1,'After a 15-4 win in the previous round, you\'ll play Thalys on Field 6 at 12:00',NULL,1308477002,NULL,NULL,NULL),(788,78,46,1,'After a 15-2 win in the previous round, you\'ll play Holland on Field 6 at 12:00',NULL,1308477002,NULL,NULL,NULL),(789,75,46,1,'After a 4-15 loss in the previous round, you\'ll play Russia on Field 8 at 12:00',NULL,1308477002,NULL,NULL,NULL),(790,82,46,1,'After a break in the previous round, you\'ll play Seagulls on Field 8 at 12:00',NULL,1308477002,NULL,NULL,NULL),(791,72,46,1,'After a 9-15 loss in the previous round, you\'ll play Switzerland on Field 9 at 12:00',NULL,1308477002,NULL,NULL,NULL),(792,80,46,1,'After a 11-15 loss in the previous round, you\'ll play France on Field 9 at 12:00',NULL,1308477002,NULL,NULL,NULL),(793,47,NULL,1,'You play mixed final against Germany at 13:00 on Field 6 in the stadion!',NULL,1308478772,NULL,NULL,NULL),(794,54,NULL,1,'You play mixed final against France at 13:00 on Field 6 in the stadion!',NULL,1308478806,NULL,NULL,NULL),(795,77,NULL,1,'You play mixed final against Italy at 14:00 on Field 7 in the stadion!',NULL,1308478884,NULL,NULL,NULL),(796,76,NULL,1,'You play mixed final against GB at 14:00 on Field 7 in the stadion!',NULL,1308478918,NULL,NULL,NULL),(797,19,NULL,1,'You play mixed final against 7 Schwaben at 15:00 on Field 6 in the stadion!',NULL,1308478973,NULL,NULL,NULL),(798,32,NULL,1,'You play open final against Germany at 15:00 on Field 6 in the stadion!',NULL,1308479012,NULL,NULL,NULL),(840,11,NULL,1,'After a 8-15 loss in the final game, you finish Windmill 2011 in place 8.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483743,NULL,NULL,NULL),(841,14,NULL,1,'After a 15-11 win in the final game, you finish Windmill 2011 in place 5.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(842,17,NULL,1,'After a 13-15 loss in the final game, you finish Windmill 2011 in place 4.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(843,29,NULL,1,'After a 11-15 loss in the final game, you finish Windmill 2011 in place 6.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(844,35,NULL,1,'After a 15-13 win in the final game, you finish Windmill 2011 in place 3.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(845,37,NULL,1,'After a 15-8 win in the final game, you finish Windmill 2011 in place 7.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(846,1,NULL,1,'After a 10-11 loss in the final game, you finish Windmill 2011 in place 14.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(847,2,NULL,1,'After a 11-14 loss in the final game, you finish Windmill 2011 in place 10.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(848,9,NULL,1,'After a 8-15 loss in the final game, you finish Windmill 2011 in place 12.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(849,12,NULL,1,'After a 15-8 win in the final game, you finish Windmill 2011 in place 11.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(850,16,NULL,1,'After a 9-8 win in the final game, you finish Windmill 2011 in place 15.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(851,24,NULL,1,'After a 8-9 loss in the final game, you finish Windmill 2011 in place 16.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(852,26,NULL,1,'After a 14-11 win in the final game, you finish Windmill 2011 in place 9.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(853,36,NULL,1,'After a 11-10 win in the final game, you finish Windmill 2011 in place 13.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483744,NULL,NULL,NULL),(854,3,NULL,1,'After a 8-15 loss in the final game, you finish Windmill 2011 in place 22.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(855,15,NULL,1,'After a 7-11 loss in the final game, you finish Windmill 2011 in place 18.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(856,18,NULL,1,'After a 11-7 win in the final game, you finish Windmill 2011 in place 17.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(857,20,NULL,1,'After a 15-8 win in the final game, you finish Windmill 2011 in place 21.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(858,21,NULL,1,'After a 13-10 win in the final game, you finish Windmill 2011 in place 23.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(859,23,NULL,1,'After a 8-13 loss in the final game, you finish Windmill 2011 in place 20.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(860,25,NULL,1,'After a 10-13 loss in the final game, you finish Windmill 2011 in place 24.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(861,40,NULL,1,'After a 13-8 win in the final game, you finish Windmill 2011 in place 19.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(862,4,NULL,1,'After a 11-15 loss in the final game, you finish Windmill 2011 in place 32.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(863,5,NULL,1,'After a 15-11 win in the final game, you finish Windmill 2011 in place 31.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(864,6,NULL,1,'After a 15-6 win in the final game, you finish Windmill 2011 in place 25.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483745,NULL,NULL,NULL),(865,10,NULL,1,'After a 15-12 win in the final game, you finish Windmill 2011 in place 29.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483746,NULL,NULL,NULL),(866,30,NULL,1,'After a 6-15 loss in the final game, you finish Windmill 2011 in place 26.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483746,NULL,NULL,NULL),(867,31,NULL,1,'After a 15-7 win in the final game, you finish Windmill 2011 in place 27.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483746,NULL,NULL,NULL),(868,38,NULL,1,'After a 7-15 loss in the final game, you finish Windmill 2011 in place 28.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483746,NULL,NULL,NULL),(869,41,NULL,1,'After a 12-15 loss in the final game, you finish Windmill 2011 in place 30.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483746,NULL,NULL,NULL),(870,7,NULL,1,'After a 10-7 win in the final game, you finish Windmill 2011 in place 37.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483746,NULL,NULL,NULL),(871,8,NULL,1,'After a 15-2 win in the final game, you finish Windmill 2011 in place 39.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483746,NULL,NULL,NULL),(872,13,NULL,1,'After a 8-15 loss in the final game, you finish Windmill 2011 in place 36.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483746,NULL,NULL,NULL),(873,27,NULL,1,'After a 7-10 loss in the final game, you finish Windmill 2011 in place 38.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483746,NULL,NULL,NULL),(874,28,NULL,1,'After a 2-15 loss in the final game, you finish Windmill 2011 in place 41.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483747,NULL,NULL,NULL),(875,33,NULL,1,'After a 15-8 win in the final game, you finish Windmill 2011 in place 35.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483747,NULL,NULL,NULL),(876,34,NULL,1,'After a 12-9 win in the final game, you finish Windmill 2011 in place 33.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483747,NULL,NULL,NULL),(877,39,NULL,1,'After a 9-12 loss in the final game, you finish Windmill 2011 in place 34.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308483747,NULL,NULL,NULL),(878,47,NULL,1,'After a 5-15 loss in the final game, you finish Windmill 2011 in place 2.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488468,NULL,NULL,NULL),(879,51,NULL,1,'After a 12-15 loss in the final game, you finish Windmill 2011 in place 4.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488469,NULL,NULL,NULL),(880,54,NULL,1,'After a 15-5 win in the final game, you finish Windmill 2011 in place 1.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488469,NULL,NULL,NULL),(881,56,NULL,1,'After a 15-12 win in the final game, you finish Windmill 2011 in place 3.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488469,NULL,NULL,NULL),(882,59,NULL,1,'After a 15-13 win in the final game, you finish Windmill 2011 in place 5.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488470,NULL,NULL,NULL),(883,62,NULL,1,'After a 4-15 loss in the final game, you finish Windmill 2011 in place 8.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488471,NULL,NULL,NULL),(884,64,NULL,1,'After a 13-15 loss in the final game, you finish Windmill 2011 in place 6.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488471,NULL,NULL,NULL),(885,69,NULL,1,'After a 15-4 win in the final game, you finish Windmill 2011 in place 7.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488472,NULL,NULL,NULL),(886,44,NULL,1,'After a 12-15 loss in the final game, you finish Windmill 2011 in place 16.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488472,NULL,NULL,NULL),(887,45,NULL,1,'After a 5-15 loss in the final game, you finish Windmill 2011 in place 12.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488473,NULL,NULL,NULL),(888,46,NULL,1,'After a 15-12 win in the final game, you finish Windmill 2011 in place 15.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488474,NULL,NULL,NULL),(889,48,NULL,1,'After a 15-12 win in the final game, you finish Windmill 2011 in place 13.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488475,NULL,NULL,NULL),(890,49,NULL,1,'After a 15-12 win in the final game, you finish Windmill 2011 in place 9.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488475,NULL,NULL,NULL),(891,55,NULL,1,'After a 15-5 win in the final game, you finish Windmill 2011 in place 11.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488476,NULL,NULL,NULL),(892,65,NULL,1,'After a 12-15 loss in the final game, you finish Windmill 2011 in place 14.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488476,NULL,NULL,NULL),(893,67,NULL,1,'After a 12-15 loss in the final game, you finish Windmill 2011 in place 10.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488477,NULL,NULL,NULL),(894,43,NULL,1,'After a 4-15 loss in the final game, you finish Windmill 2011 in place 24.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488478,NULL,NULL,NULL),(895,50,NULL,1,'After a 15-4 win in the final game, you finish Windmill 2011 in place 23.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488479,NULL,NULL,NULL),(896,52,NULL,1,'After a 15-9 win in the final game, you finish Windmill 2011 in place 19.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488479,NULL,NULL,NULL),(897,53,NULL,1,'After a 11-14 loss in the final game, you finish Windmill 2011 in place 18.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488480,NULL,NULL,NULL),(898,58,NULL,1,'After a 10-15 loss in the final game, you finish Windmill 2011 in place 22.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488480,NULL,NULL,NULL),(899,60,NULL,1,'After a 9-15 loss in the final game, you finish Windmill 2011 in place 20.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488481,NULL,NULL,NULL),(900,61,NULL,1,'After a 15-10 win in the final game, you finish Windmill 2011 in place 21.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488481,NULL,NULL,NULL),(901,66,NULL,1,'After a 14-11 win in the final game, you finish Windmill 2011 in place 17.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488482,NULL,NULL,NULL),(902,57,NULL,1,'After a 7-15 loss in the final game, you finish Windmill 2011 in place 27.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488482,NULL,NULL,NULL),(903,63,NULL,1,'After a 15-7 win in the final game, you finish Windmill 2011 in place 25.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488483,NULL,NULL,NULL),(904,68,NULL,1,'After a 12-10 win in the final game, you finish Windmill 2011 in place 26.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488485,NULL,NULL,NULL),(905,84,NULL,1,'After a 10-12 loss in the final game, you finish Windmill 2011 in place 28.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308488485,NULL,NULL,NULL),(906,19,NULL,1,'Congratulations! You\'ve won Windmill 2011. Please hand in all spirit scores. See you next year!',NULL,1308494435,NULL,NULL,NULL),(907,32,NULL,1,'Congratulations with your second place! Please hand in all spirit scores. See you next year!',NULL,1308494515,NULL,NULL,NULL),(908,77,NULL,1,'Congratulations! You\'ve won Windmill 2011. Please hand in all spirit scores. See you next year!',NULL,1308494550,NULL,NULL,NULL),(909,76,NULL,1,'Congratulations with your second place! Please hand in all spirit scores. See you next year!',NULL,1308494596,NULL,NULL,NULL),(910,70,NULL,1,'After a 1-8 loss in the final game, you finish Windmill 2011 in place 13.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308494866,NULL,NULL,NULL),(911,76,NULL,1,'After a 12-15 loss in the final game, you finish Windmill 2011 in place 2.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308494867,NULL,NULL,NULL),(912,77,NULL,1,'After a 15-12 win in the final game, you finish Windmill 2011 in place 1.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308494867,NULL,NULL,NULL),(913,82,NULL,1,'After a 8-1 win in the final game, you finish Windmill 2011 in place 9.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308494868,NULL,NULL,NULL),(914,71,NULL,1,'After a 5-15 loss in the final game, you finish Windmill 2011 in place 4.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308495038,NULL,NULL,NULL),(915,72,NULL,1,'After a 5-15 loss in the final game, you finish Windmill 2011 in place 8.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308495038,NULL,NULL,NULL),(916,73,NULL,1,'After a 15-14 win in the final game, you finish Windmill 2011 in place 5.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308495039,NULL,NULL,NULL),(917,74,NULL,1,'After a 15-5 win in the final game, you finish Windmill 2011 in place 3.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308495039,NULL,NULL,NULL),(918,75,NULL,1,'After a 13-15 loss in the final game, you finish Windmill 2011 in place 11.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308495040,NULL,NULL,NULL),(919,78,NULL,1,'After a 9-11 loss in the final game, you finish Windmill 2011 in place 12.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308495040,NULL,NULL,NULL),(920,79,NULL,1,'After a 14-15 loss in the final game, you finish Windmill 2011 in place 6.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308495041,NULL,NULL,NULL),(921,80,NULL,1,'After a 15-5 win in the final game, you finish Windmill 2011 in place 7.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308495041,NULL,NULL,NULL),(922,81,NULL,1,'After a 11-9 win in the final game, you finish Windmill 2011 in place 10.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308495042,NULL,NULL,NULL),(923,82,NULL,1,'After a 15-13 win in the final game, you finish Windmill 2011 in place 9.Congratulations!Please hand in all spirit scores now. See you next year!',NULL,1308495042,NULL,NULL,NULL);
/*!40000 ALTER TABLE `s_m_s` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stage`
--
DROP TABLE IF EXISTS `stage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stage` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`division_id` int(11) DEFAULT NULL,
`rank` int(11) DEFAULT NULL,
`locked` tinyint(1) DEFAULT NULL,
`placement` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `division_id_idx` (`division_id`),
CONSTRAINT `stage_division_id_division_id` FOREIGN KEY (`division_id`) REFERENCES `division` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stage`
--
LOCK TABLES `stage` WRITE;
/*!40000 ALTER TABLE `stage` DISABLE KEYS */;
INSERT INTO `stage` VALUES (1,'Registration stage',1,1,NULL,NULL),(2,'Swissdraw',1,2,NULL,NULL),(3,'Playoff',1,3,NULL,1),(4,'Registration stage',2,1,NULL,NULL),(5,'Swissdraw',2,2,NULL,NULL),(6,'Playoff',2,3,NULL,1),(7,'Registration stage',3,1,NULL,NULL),(8,'FlexStage',3,2,NULL,1);
/*!40000 ALTER TABLE `stage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `team`
--
DROP TABLE IF EXISTS `team`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `team` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`shortname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`contactname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`mobile1` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`mobile2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`mobile3` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`mobile4` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`mobile5` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8_unicode_ci,
`tournament_id` int(11) DEFAULT NULL,
`division_id` int(11) DEFAULT NULL,
`byestatus` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `tournament_id_idx` (`tournament_id`),
KEY `division_id_idx` (`division_id`),
CONSTRAINT `team_division_id_division_id` FOREIGN KEY (`division_id`) REFERENCES `division` (`id`) ON DELETE CASCADE,
CONSTRAINT `team_tournament_id_tournament_id` FOREIGN KEY (`tournament_id`) REFERENCES `tournament` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `team`
--
LOCK TABLES `team` WRITE;
/*!40000 ALTER TABLE `team` DISABLE KEYS */;
INSERT INTO `team` VALUES (1,'Gentle','Gentle','johanbommie@yahoo.com','','korneel','Gent','Belgium','32486652562','',NULL,NULL,NULL,'',NULL,1,NULL),(2,'France National Master Team','FranceMaster','pierril9@yahoo.com','jygoliard@yahoo.com','jano','ALL AROUND','FRANCE','33685554475','33650741660',NULL,NULL,NULL,'',NULL,1,NULL),(3,'Rainbow Warriors','Rainbow Warriors','thomas.kuypers@laposte.net','thomas.kuypers@laposte.net','Thomas Kuypers','Lille/Besan̤on/Clermont','France','33626820763','',NULL,NULL,NULL,'',NULL,1,NULL),(4,'Carapedos','Carapedos','db@davidbender.de','hauck@ghost-o-one.de','Torsten','Wuppertal/ Dortmund','Germany','491752015296','491732716004','491725766639',NULL,NULL,'',NULL,1,NULL),(5,'KoBOld','KoBOld','tim.oehr@gmail.com','timoehr@uni-bremen.de','Tim Oehr','Bremen, Oldenburg, Osnabrueck','Germany','491777157468','4915111667320','4917663048053','491732112759','4917621714819','',NULL,1,NULL),(6,'Hardfisch','Hardfisch','tieiben@gmail.com','tieiben@gmail.com','Tarek Iko Eiben','Hamburg','Germany','491729047847','4915788484214','491776052828','491774454771','4916095730116','',NULL,1,NULL),(7,'Tsunami Vintage','Tsunami','cyrille.perez@wanadoo.Fr','cyrille.perez@wanadoo.fr','cyrille','Nemours','FRANCE','33650634651','33625651587','33661239577','33670427292','33632517820','',NULL,1,NULL),(8,'Xlr8rs','Xlr8rs','lucchome@yahoo.com','tsasfra@gmail.com','FRANZ TSAS','Brussels','Belgium','32486036417','32497056317','32485454818',NULL,NULL,'',NULL,1,NULL),(9,'Mooncatchers','Mooncatchers','cbihin@gmail.com','calimemo@hotmail.com','Nicolas De Mesmaeker','Brussels','Belgium','32487178892','32495866466','32474816536','32495785634','32497215167','',NULL,1,NULL),(10,'MAM Friends','MAM','sbeltramo@wanadoo.fr','seb.beltramo@gmail.com','Bab','Manies','France','33601171070','33620698325',NULL,NULL,NULL,'',NULL,1,NULL),(11,'Rebel Ultimate','Rebel','rebelultimate@gmail.com','flashdan9@gmail.com','Brian O\'Callaghan','Cork','Ireland','353863979041','353860859092','31652100534','353863448084','353868801012','',NULL,1,NULL),(12,'Silence','Silence','ondrej.bouska@gmail.com','frankie@praguedevils.org','Ondrej Bouska','Prague','Czech Republic','420775686147','420603751806','420732944669','420604344735','420724773365','',NULL,1,NULL),(13,'Funatics','Funatics','vorstand@funaten.de','mario-tonini@wanadoo.fr','Mario','Hannover','Germany','491799781163','491789388635','4917664856234','491782090301','491753593883','',NULL,1,NULL),(14,'Pissotte','Pissotte','richard.francheteau@gmail.com','spiroo@laposte.net','Spiroo','Open national team','France','33672716922','33664220255','33618086583','33616708685','33670901003','',NULL,1,NULL),(15,'theBigEz - Vienna','theBigEz','','christian_holzinger@inode.at','Christian Holzinger','Vienna','Austria','436505411902','436502443256','436642165781','436764742685',NULL,'',NULL,1,NULL),(16,'Solebang','Solebang','mario_baumann@hotmail.com','benji@gnadelos.ch','Benji Fischer','Cham','Schweiz','41763377106','41788867050','41788032851','41763606791','41786814639','',NULL,1,NULL),(17,'CUS Bologna','Bologna','info@bodisc.it','info#@bodisc.it','Davide Morri','Bologna','Italy','393334064008','',NULL,NULL,NULL,'',NULL,1,NULL),(18,'M.U.C.','M.U.C.','michy@zamperl.com','jens91@mnet-online.de','Jens Achenbach','Munich','Germany','491739438483','491717481682',NULL,NULL,NULL,'',NULL,1,NULL),(19,'Flying Angels Bern (FAB)','Flying Angels','info@flyingangels.ch','christian.brethaut@gmail.com','Chris','Bern','Switzerland','41787962969','41766034294','41793431899','41788116165','41763967716','',NULL,1,NULL),(20,'Spain National Team','Spain','tim.kohlstadt@gmail.com','ajpalmer@gmail.com','Tim + Justin','Spain','Spain','34606131660','34634496468','34666296632','34628875164','687278957','',NULL,1,NULL),(21,'Iznogood','Iznogood','ckriss9-izno@yahoo.fr','Francoiszoubir@yahoo.fr','Francois','Paris ','France','33660488699','33661239410','33662218190','33698315180','33660361873','',NULL,1,NULL),(22,'UL Ninjas','UL Ninjas','ulultimatefrisbee@gmail.com','jamesmoore@o2.ie','James Moore','Limerick','Ireland','353852702485','353879216409','353857048535','353863989799','353877811008','',NULL,1,NULL),(23,'German Junior Open','German Junior','Matthias@brucklacher.com','matthias@brucklacher.com','Matthias','allover germany','germany','491727058899','4915125364400','4916097627493','491772005288',NULL,'',NULL,1,NULL),(24,'Gummibaerchen','Gummibaerchen','trainer@ultimate-karlsruhe.de','turniere@ultimate-karlsruhe.de','Felix Mach','Karlsruhe','Germany','4917662675590','491781396019','491702440365','4915123636638','33661528544','',NULL,1,NULL),(25,'Disc Club Panthers','Panthers','info@dcp.ch','l.schaer@gmx.net','Lukas Schaer','Bern','Switzerland','41794595728','41792430667','41798743279','41787918807','41797681679','',NULL,1,NULL),(26,'Russia National Team','Russia','av@rusultimate.org','avasilyev18@gmail.com','Anatoly Vasilyev','','Russia','79670919059','79161537629','79162117731','79161586615','79263879408','',NULL,1,NULL),(27,'Buggoli','Buggoli','earley.mark@gmail.com','coach@broccoliultimate.com','David Rickard','Dublin','Ireland','353877431088','447816540534','447525475977','353871226693','353873530108','Great idea lads! To clarify the team name: Broccoli and BUG are combining their squads, so you can call us Buggoli if you like!',NULL,1,NULL),(28,'Soimii Patriei','Soimii','pasalega_adrian@yahoo.com','c_relu@yahoo.com','Adrian Pasalega','Cluj-Napoca','ROMANIA','40729880789','40745383562','447503576111','4917638873170','447756177107','',NULL,1,NULL),(29,'Denmark National Team','Denmark','administrator@dfsu.dk','elite@dfsu.dk','Taiyo J̦nsson','Copenhagen','Denmark','4528185684','4551506588','4561338010','4527388129','4551923885','',NULL,1,NULL),(30,'Sun','Sun','sunFrisbee@gmail.com','pabs_agro@yahoo.fr','Pablo Lopez','Cr̩teil','France','33677090606','33607560464',NULL,NULL,NULL,'',NULL,1,NULL),(31,'Friselis Club Ultimate Versailles','Friselis','friselisclubversailles@gmail.com','augustinscala@gmail.com','Gus','Versailles','France','33688435794','',NULL,NULL,NULL,'',NULL,1,NULL),(32,'7 Schwaben','7Schwaben','schlecht@selk-stuttgart.de','wolfi.a@gmx.de','Philipp Haas, Wolfgang Alder','Stuttgart','Germany','4915159213337','491778741959',NULL,NULL,NULL,'',NULL,1,NULL),(33,'Barbastreji','Barbastreji','info@ultimatepadova.it','diego_melisi@yahoo.it','Diego','Padova','Italy','393483609600','393409799795','393463243176','393288456619','393497319366','formerly PUF - Padova Ultimate Frisbee',NULL,1,NULL),(34,'Ultimate deLux','deLux','contact@ultimate-delux.org','richardson_jt@yahoo.com','JT Richardson','Luxembourg','Luxembourg','4916095063547','352621699507','491781897744',NULL,NULL,'',NULL,1,NULL),(35,'Freespeed','Freespeed','info@freespeed.ch','flow@freespeed.ch','Florian Kaeser','Basel','Switzerland','41764173505','41788795948','31619091702',NULL,NULL,'',NULL,1,NULL),(36,'Flying Bisc','Flying Bisc','tuscanultimate@gmail.com','','Massimo Duradoni','Florence','Italy','393356555593','393384528940','391723949','393280312940','393282663408','',NULL,1,NULL),(37,'Red Lights','Red Lights','tedbeute@upcmail.nl','','Ted Beute','Amsterdam','Nederland','31614994428','31619618365','31644550455','31651401141','31647047588','',NULL,1,NULL),(38,'Les etoiles o','Les etoiles o','sigibodson@yahoo.com','bodsonsigi@hotmail.com','Sigi Bodson','Hasselt + Huy','Belgium','32476782806','32497305258','32474799174',NULL,NULL,'',NULL,1,NULL),(39,'Cambo Cakes','Cambo Cakes','wombatcummings@hotmail.com','miccwvdl@hotmail.com','Michiel van de Leur','Amsterdam','Netherlands','31643045677','31611000974','31647820682','31646163224','31645628298','',NULL,1,NULL),(40,'Holland National Team','Netherlands','dutchnationalteam@gmail.com','tomwaijers@yahoo.com','Tom Waaijers','','Netherlands','31626072266','31622403400','31624224269','31645107556',NULL,'',NULL,1,NULL),(41,'German masters','German Masters','froetsch@gmx.de','','Bernhard Froetschl','','Germany','4915150466083','491791489105','4915158624369','491795182637',NULL,'',NULL,1,NULL),(42,'BYE Team',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1),(43,'Disco Stu','Disco Stu','raffarufus@hotmail.it','raffarufus@hotmail.it','raffaele de curtis (rufus)','modena','italy','393331433038','\r\n393283062072\r\n','393478458673','393400541058',NULL,'Sorry, someone else made a \"disco stu\" team before me and in the previous registration form i chose the wrong one.\n\nrufus',NULL,2,NULL),(44,'Superfly','Superfly','tomsummerbee@yahoo.com','tomsummerbee@yahoo.com','Tom Summerbee','Birmingham','England','33611488080','447983626232','447743082362','447917735917','447793281060','Hi,\nI\'m sorry but I just sent a message asking when registration opened, so please ignore that message. If you could let me know how to pay the team fee I will get that done as soon as possible.\n\nMany thanks\nTom Summerbee',NULL,2,NULL),(45,'PUF','PUF','lutzmuerau@hotmail.com','ravi.a.vasudevan@gmail.com','Lutz, Ravi','Delft, Den Haag, Leiden','Netherlands','31634313251','31681163086','31646690049','31634034778','31650894721','',NULL,2,NULL),(46,'Quijotes+Dulcineas','Quijotes','quijotesultimate@gmail.com','ajpalmer@gmail.com','Justin','Madrid','Spain','34651950590','34653273248','34687278957','34628289964','34671407027','Looking forward to Windmill again!We finished 14th last year with half the team and a handful of pickups, but the stories we brought back seem to have convinced the rest of the team to come along this year...',NULL,2,NULL),(47,'France National Team','France','intendant.mixte@ffdf.fr','intendant.mixte@ffdf.fr','Guillaume CANAL','','France','33672615141','33688472848','33663846770','33672506436',NULL,'',NULL,2,NULL),(48,'Stockholm Syndromes','Stockholm','ssufc@stockholmsyndromes.se','paul.eriksson@frisbeesport.se','Paul Eriksson','Stockholm','Sweden','46739960557','46733783257','33684524501','46767725843',NULL,'Hej,\n\nWe are the Stockholm Syndromes, have never been to a Dutch tournament, but have heard only great things. Beside the Swedish guys and girls, we are a pretty international squad from Stockholm and are aiming for a fun mixed experience :-)',NULL,2,NULL),(49,'Spirit on Lemon','Spirit on Lemon','','tailor82@gmail.com','Tom','Sosnowiec','Poland','48502489694','48507120311','48601292278','48695802883','48501108913','Hello\nMy nam is Tom. I\'am a capitan of Spirit on Lemon Ultimate Frisbee Team from Poland!\nI would like to register my team Spirit on Lemon from Poland for this year Windmill Windup!\nIt would be pleasure to join you!\nTom',NULL,2,NULL),(50,'Cheek2Cheek','Cheek2Cheek','christoph.obenhuber@gmx.at','florian.eywo@gmx.at','Christoph Obenhuber','Vienna','Austria','436508050081','436644203437','436646197616','436508682816','436502833428','Hi guys,\n\nWe are the current Austrian Mixed Champion and would love to come to windmill with our girlz and boyz. We have been at windmill for the last few years with our open team (bigez) and now we are looking forward to join the windmill mixed experience ;-)\n\ncheers,\nchristoph',NULL,2,NULL),(51,'TeamAustria Mixed','Austria','hnowak@gmx.at','upsadaisy@gmx.at','harald nowak','vienna - rest of austria','austria','436767545950','4369912131355','436602266725','436509827662','436508050082','',NULL,2,NULL),(52,'Rusty Bikes','Rusty Bikes','mariekebuijs@gmail.com','mariekebuijs@gmail.com','Marleen Vervoort, Marieke Buijs','Amsterdam','the netherlands','31633695574','31648357529','31626236229','31611562869','31614547055','',NULL,2,NULL),(53,'Nuts\'n Berries','Nuts\'nBerries','hexemexe@web.de','hexemexe@web.de','Kathleen','Halle','Germany','4917648391108','491736342208','491788588834','4917623392475','4917885888341','',NULL,2,NULL),(54,'German National Team','Germany','heiko.karpowski@googlemail.com','heiko.karpowski@googlemail.com','Heiko Karpowski, Janne Lepthin','','Germany','491704104130','491757002822','491729419441','491601544928','4917681187476','',NULL,2,NULL),(55,'Robiram Project','Robiram','tloustik@gmail.com','julik8@gmail.com','Petra Moravkova, Julia Navratova','Bratislava','Slovakia','447877749695','421903172634','421903363033','421903227746','421904566535','',NULL,2,NULL),(56,'Holland National Team','Holland','frisbeemeisje@gmail.com','frisbeemeisje@gmail.com','roelien','all over','nederland','31648408847','31649393448','31614957591','31614867760','31626072266','',NULL,2,NULL),(57,'WAF','WAF','waf@wur.nl','pnmdejongh@gmail.com, bramtebrake1@gmail.com','Niek','Wageningen','Netherlands','31634317858','31646036901','31634449486','31619054127','31644591879','',NULL,2,NULL),(58,'Akka','Akka','akka@frisbee.se','hanna@frisbee.se','Hanna','Lund','Sweden','393282926595','46730292948','393397456579','33688947876',NULL,'',NULL,2,NULL),(59,'Ireland National Team','Ireland','irelandmixed2011@gmail.com','peter.forde@gmail.com','Peter','Dublin','Ireland','353857068828','353857203563','353861994086','353879302429','447833645624','',NULL,2,NULL),(60,'Turkey National Team','Turkey','ord-yk@googlegroups.com','demir.emra@gmail.com','Emrah Demir','İstanbul - Ankara','Turkey','905337107856','905373843878',NULL,NULL,NULL,'',NULL,2,NULL),(61,'Cranberry Snack','Cranberry','juleclech@gmail.com','klaatii@gmail.com','Klaus Walther','Karlsruhe','Germany','491782331741','353857326695','3164231000','491712811801','491637182829','Hey Windmillers,\n\n\n\nwe did a mistake a registered us for the Open Division, but we\'re naturally mixed. We want to be registered for the MIXED DIVISON!\n\n\n\nCould you please help us to switch the division.\n\nI\'m so sorry, i tried to register us several times for open. I just dont realize that i need to register especialy for mixed ;)\n\nI hope you could unterstand my doing.\n\n\n\nPlease contact me if something goes wrong or ask Nan. He should know me now ;)\n\n\n\nMy contact is: klaatii@gmail.com \n\n\n\nThank you so much, i will bring you a present for that!\n\n\n\nSee you all in june!\n\nKlaus - Cranberry Snack\n\n\n\n',NULL,2,NULL),(62,'Frizzly Bears','Frizzly Bears','hanstiro@gmx.de','','','','','','',NULL,NULL,NULL,'',NULL,2,NULL),(63,'Moscow Chapiteau','Moscow','moscowsharks@gmail.com','chernykh.ira@gmail.com','Alexey, Irina','Moscow','Russia','79639785897','79263425143','447884000898','447562742045','79067903176','',NULL,2,NULL),(64,'Sexy Legs','Sexy Legs','','liisa.licht@mail.ee','Liisa Licht','we\'re an international team','mainly from Estonia','37256218415','37256563967',NULL,NULL,NULL,'We\'re an international team that played last year as \"Tallinn Frisbee Club\" in mixed division',NULL,2,NULL),(65,'Frisbee Family','Frisbee Family','verena@frisbee-family.de','matthias@brucklacher.com','Doerthe, Mattes','Duesseldorf','Germany','4917666631600','491727071718','491727058899','4917620494927',NULL,'',NULL,2,NULL),(66,'Switzerland National Team','Switzerland','international-coordinator@ultimate.ch','kian.rieben@gmail.com','Nef','Switzerland','Switzerland','41765862927','41763703078','31619091702',NULL,NULL,'',NULL,2,NULL),(67,'Drehst\'n Deckel','Drehst\'nDeckel','ulle@drehstn-deckel.de','kirvel@gmx.ch','Christian Kirvel','Dresden','Germany','491785381277','4915152354763','4915154424157','491772837618','4915773837864','',NULL,2,NULL),(68,'Aye-Aye Ultimate (UEA)','Aye-Aye','b.hutton@uea.ac.uk','b.hutton@uea.ac.uk','Ben Hutton','Norwich','England','447595739460','447840391708',NULL,NULL,NULL,'We have already registered for the open division earlier this year. We have since decided that our team would be better suited to play in the mixed division. I will therefore be removing our open division bid after submitting this bid. Sorry for all the confusion, thanks.\n\n\n\nBen Hutton\n\nAye-Aye president',NULL,2,NULL),(69,'Russo Turisto','Russia','av@rusultimate.org','shebouniaev@yandex.ru ','Toly','','Russia','79166866666','79167000446',NULL,NULL,NULL,'',NULL,2,NULL),(70,'Chakalakas','Chakalakas','marysmile@gmx.de','esther.kunay@gmx.de','Esther','all over Germany','Germany','491638826584','4915773806933','491709593197','491737218525',NULL,'',NULL,3,NULL),(71,'Hot Beaches','Hot Beaches','','aja_sem@centrum.cz','aja, katy','Prague','Czech Republic','420774858308','420736286157','420774114711','420724119726','420606133565','',NULL,3,NULL),(72,'France National Team','France','angodet@yahoo.fr','angodet@yahoo.fr','AL','Paris','France','33683103015','33677795481','33676665501','33686999203','(NULL)','The team will count around 23 players + 3 coachs.\n\nThanks !',NULL,3,NULL),(73,'Denmark National Team','Denmark','administrator@dfsu.dk','elite@dfsu.dk','Taiyo Jönsson','Copenhagen','Denmark','4522664242','4526247090','4523956204','4530381084','4551900103','The National Team of Denmark would like to apply for a spot in the Windmill Womens Division 2011.',NULL,3,NULL),(74,'Ireland National Team','Ireland','ladiescaptain@gmail.com','ladiescaptain@gmail.com','Laura, Linda','Dublin','Ireland','353833702663','32498311237',NULL,NULL,NULL,'',NULL,3,NULL),(75,'Seagulls','Seagulls','info@fischbees.de','Britta_Kipcke@web.de','Britta','Hamburg','Germany','491708150105','491785543687','491631767943','491707719472',NULL,'',NULL,3,NULL),(76,'Italy National Team','Italy','Frixsven@gmail.com','Britneyz88@yahoo.it','Frida Svensson','','Italy','393287016841','393289123854','393395980966','393335257750','393335797880','',NULL,3,NULL),(77,'GB National Team','GB','jennat49@yahoo.co.uk','me01gmt@googlemail.com','Jenna Thomson','','United Kingdom','447590382152','447976364407','447855446423','447950315532','447843254472','',NULL,3,NULL),(78,'Thalys','Thalys','paulinette71@yahoo.fr','paulinette71@yahoo.fr','Pauline Vicard','Lille/Bruxelles','France/Belgium','33683049712','33609553008','33674596169','32484917080','32486927712','',NULL,3,NULL),(79,'DNT National Team','Germany','oburch@web.de','oburch@web.de','Silke Oldenburg','all over Germany','Germany','4917661265079','491772927428','491749142834','491782175415','4915140152093','',NULL,3,NULL),(80,'Switzerland National Team','Switzerland','vogel.simone@gmail.com','vogel.simone@gmail.com','Simone Vogel','Geneva','Switzerland','41786735048','41793500034','31619091702',NULL,NULL,'',NULL,3,NULL),(81,'Holland National Team','Holland','luzia.helfer@gmail.com','iris.terpstra@gmail.com','Iris','','The Netherlands','31625266393','31626507460','31648797084','31641479141','31626072266','',NULL,3,NULL),(82,'Russia National Team','Russia','astreya2004@yandex.ru','astreya2004@yandex.ru','Margarita','Moscow','Russian Federation','79647962477','79117166991','79116914355','79164691957','37259613605','',NULL,3,NULL),(83,'BYE Team',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,1),(84,'Born Yesterday',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL);
/*!40000 ALTER TABLE `team` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tournament`
--
DROP TABLE IF EXISTS `tournament`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tournament` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` int(11) DEFAULT NULL,
`startdate` bigint(20) DEFAULT NULL,
`enddate` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tournament`
--
LOCK TABLES `tournament` WRITE;
/*!40000 ALTER TABLE `tournament` DISABLE KEYS */;
INSERT INTO `tournament` VALUES (1,'Windmill Windup 2011',1,1308261600,1308434400);
/*!40000 ALTER TABLE `tournament` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `victory_points`
--
DROP TABLE IF EXISTS `victory_points`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `victory_points` (
`margin` int(11) NOT NULL DEFAULT '0',
`victorypoints` int(11) DEFAULT NULL,
PRIMARY KEY (`margin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `victory_points`
--
LOCK TABLES `victory_points` WRITE;
/*!40000 ALTER TABLE `victory_points` DISABLE KEYS */;
INSERT INTO `victory_points` VALUES (-15,0),(-14,1),(-13,2),(-12,3),(-11,4),(-10,5),(-9,6),(-8,7),(-7,8),(-6,9),(-5,10),(-4,11),(-3,12),(-2,13),(-1,14),(0,15),(1,16),(2,17),(3,18),(4,19),(5,20),(6,21),(7,22),(8,23),(9,24),(10,25),(11,25),(12,25),(13,25),(14,25),(15,25);
/*!40000 ALTER TABLE `victory_points` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2011-06-19 20:18:05