-
Notifications
You must be signed in to change notification settings - Fork 0
/
skyttedb.sql
641 lines (532 loc) · 155 KB
/
skyttedb.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
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
-- Run denna efter allt importeras manuellt
-- CREATE USER 'skyskol.com/mysq'@'localhost' IDENTIFIED BY '875CD99826627B93FAFD164FEA4C71';
-- GRANT ALL ON *.* TO 'skyskol.com/mysq'@'localhost';
-- MySQL dump 10.11
--
-- Host: localhost Database: gunnar
-- ------------------------------------------------------
-- Server version 5.0.32-Debian_7etch6-log
/*!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 */;
--
-- Current Database: `gunnar`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `gunnar` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `gunnar`;
--
-- Table structure for table `tbl_Pistol_Club`
--
DROP TABLE IF EXISTS `tbl_Pistol_Club`;
CREATE TABLE `tbl_Pistol_Club` (
`Id` bigint(20) NOT NULL auto_increment,
`Name` varchar(100) NOT NULL,
`CreateDate` datetime NOT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=102 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_Club`
--
LOCK TABLES `tbl_Pistol_Club` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_Club` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_Club` VALUES (1,'Alingsås','2008-05-14 17:16:21'),(2,'Arvika PK','2008-05-14 17:16:21'),(3,'Bengtsfors PSK','2008-05-14 17:16:21'),(4,'Björlanda SKF','2008-05-14 17:16:21'),(5,'Borås PS','2008-05-14 17:16:21'),(6,'Boråspolisen','2008-05-14 17:16:21'),(7,'Bredared SF','2008-05-14 17:16:21'),(8,'Bredareds SSK','2008-05-14 17:16:21'),(9,'Broaryds PK','2008-05-14 17:16:21'),(10,'Dals PSKF','2008-05-14 17:16:21'),(11,'Donsö PF','2008-05-14 17:16:21'),(12,'Eds PSK','2008-05-14 17:16:21'),(13,'F14 Skf','2008-05-14 17:16:21'),(14,'F7 PK','2008-05-14 17:16:21'),(15,'FOK Borås','2008-05-14 17:16:21'),(16,'Fagersta PSK','2008-05-14 17:16:21'),(17,'Falkenbergs PK','2008-05-14 17:16:21'),(18,'Färjenäs PK','2008-05-14 17:16:21'),(19,'Gamla Surte Skyttar','2008-05-14 17:16:21'),(20,'Gbg Hemvärnsbef PK','2008-05-14 17:16:21'),(21,'Grästorps PSK','2008-05-14 17:16:21'),(22,'Göteborgs PSSK','2008-05-14 17:16:21'),(23,'Göteborgs SKS','2008-05-14 17:16:21'),(24,'Habo PK','2008-05-14 17:16:21'),(25,'Hagfors Uddeholm Pk','2008-05-14 17:16:21'),(26,'Halmstads sport','2008-05-14 17:16:21'),(27,'Harplinge PK','2008-05-14 17:16:21'),(28,'Horns PSS','2008-05-14 17:16:21'),(29,'Härlanda PK','2008-05-14 17:16:21'),(30,'Härryda PSS','2008-05-14 17:16:21'),(31,'Hörsholm PF','2008-05-14 17:16:21'),(32,'I 15','2008-05-14 17:16:21'),(33,'I 16 SKF','2008-05-14 17:16:21'),(34,'JBF','2008-05-14 17:16:21'),(35,'Jämjö SPK','2008-05-14 17:16:21'),(36,'Jönköpings PK','2008-05-14 17:16:21'),(37,'KA2 PSK','2008-05-14 17:16:21'),(38,'Karlstad PSK','2008-05-14 17:16:21'),(39,'Kullens PK','2008-05-14 17:16:21'),(40,'Kumla SS','2008-05-14 17:16:21'),(41,'Kungsbacka-Wiske SPSK','2008-05-14 17:16:21'),(42,'Kungshamn PSK','2008-05-14 17:16:21'),(43,'Kvibergs PK','2008-05-14 17:16:21'),(44,'Laholms PSK','2008-05-14 17:16:21'),(45,'Lerums JoSSK','2008-05-14 17:16:21'),(46,'Lidköpings PF','2008-05-14 17:16:21'),(47,'Lilla Edets PK','2008-05-14 17:16:21'),(48,'Lysekil PSK','2008-05-14 17:16:21'),(49,'Lödöse Pk','2008-05-14 17:16:21'),(50,'Mariestads PK','2008-05-14 17:16:21'),(51,'Marinens SKF','2008-05-14 17:16:21'),(52,'Markaryds SPK','2008-05-14 17:16:21'),(53,'Marks PK','2008-05-14 17:16:21'),(54,'Melleruds PK','2008-05-14 17:16:21'),(55,'Munkfors PK','2008-05-14 17:16:21'),(56,'Målöga Skyttegille','2008-05-14 17:16:21'),(57,'Mölndals PK','2008-05-14 17:16:21'),(58,'Mölndals SF','2008-05-14 17:16:21'),(59,'P4 IF','2008-05-14 17:16:21'),(60,'Polisen','2008-05-14 17:16:21'),(61,'Roasjö SKF','2008-05-14 17:16:21'),(62,'SJ PK Luleå','2008-05-14 17:16:21'),(63,'Saab PK','2008-05-14 17:16:21'),(64,'Sjoormens PK','2008-05-14 17:16:21'),(65,'Sjuntorps PSK','2008-05-14 17:16:21'),(66,'Skepplanda SKF','2008-05-14 17:16:21'),(67,'Skövde PK','2008-05-14 17:16:21'),(68,'Sollebrunns PK','2008-05-14 17:16:21'),(69,'Starrkärrs SF','2008-05-14 17:16:21'),(70,'Stenungsund','2008-05-14 17:16:21'),(71,'Strängnäs PK','2008-05-14 17:16:21'),(72,'Surte-Bohus SSG','2008-05-14 17:16:21'),(73,'Säffle PK','2008-05-14 17:16:21'),(74,'Sätila PK','2008-05-14 17:16:21'),(75,'Säve PSK','2008-05-14 17:16:21'),(76,'Södra Dahls PK','2008-05-14 17:16:21'),(77,'Södra Kinds FBU','2008-05-14 17:16:21'),(78,'Sörbygdens PK','2008-05-14 17:16:21'),(79,'Telegrafverket PK','2008-05-14 17:16:21'),(80,'Tidaholms PSK','2008-05-14 17:16:21'),(81,'Trollhättans PK','2008-05-14 17:16:21'),(82,'Tullens PK','2008-05-14 17:16:21'),(83,'Uddevalla PSF','2008-05-14 17:16:21'),(84,'Ulricehamns PK','2008-05-14 17:16:21'),(85,'Unnaryds PSK','2008-05-14 17:16:21'),(86,'Varbergs PK','2008-05-14 17:16:21'),(87,'Vargöns PK','2008-05-14 17:16:21'),(88,'Vedums PSK','2008-05-14 17:16:21'),(89,'Vilhelmina PK','2008-05-14 17:16:21'),(90,'Volvo PK','2008-05-14 17:16:21'),(91,'Västbo PK','2008-05-14 17:16:21'),(92,'Växjö PK','2008-05-14 17:16:21'),(93,'Vårgårda PSK','2008-05-14 17:16:21'),(94,'Ängelholms PK','2008-05-14 17:16:21'),(95,'Åmåls PK','2008-05-14 17:16:21'),(96,'Öckerö SF','2008-05-14 17:16:21'),(97,'Öjaby SF','2008-05-14 17:16:21'),(98,'Örebro PSSK','2008-05-14 17:16:21'),(99,'Örgryte PK','2008-05-14 17:16:21'),(100,'Östersunds PK','2008-05-14 17:16:21'),(101,'Överby PK','2008-05-14 17:16:21');
/*!40000 ALTER TABLE `tbl_Pistol_Club` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`www`@`%` */ /*!50003 TRIGGER `tr_club_ins` BEFORE INSERT ON `tbl_Pistol_Club` FOR EACH ROW set NEW.CreateDate = now() */;;
DELIMITER ;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */;
--
-- Table structure for table `tbl_Pistol_Competition`
--
DROP TABLE IF EXISTS `tbl_Pistol_Competition`;
CREATE TABLE `tbl_Pistol_Competition` (
`Id` bigint(20) NOT NULL auto_increment,
`Name` varchar(100) default NULL,
`StartDate` date default NULL,
`EndDate` date default NULL,
`Location` varchar(100) default NULL,
`HostClubId` bigint(20) default NULL,
`MaxPatrolSize` int(11) NOT NULL,
`Status` int(11) NOT NULL,
`ScoreType` char(1) default NULL,
`OnlineBetalning` CHAR(1) NULL DEFAULT NULL,
`Masterskap` CHAR(1) NULL DEFAULT NULL ,
PRIMARY KEY (`Id`),
UNIQUE KEY `i2` (`Name`,`StartDate`),
KEY `i1` (`StartDate`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
-- ALTER TABLE `gunnar`.`tbl_Pistol_Competition` ADD COLUMN `Masterskap` CHAR(1) NULL DEFAULT NULL AFTER `ScoreType` ;
-- ALTER TABLE `gunnar`.`tbl_Pistol_Competition` ADD COLUMN `OnlineBetalning` CHAR(1) NULL DEFAULT NULL AFTER `ScoreType` ;
--
-- Dumping data for table `tbl_Pistol_Competition`
--
LOCK TABLES `tbl_Pistol_Competition` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_Competition` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_Competition` VALUES (12,'Skoj','2010-01-07','2010-01-07','GPSSK',22,6,5,'N'),(13,'test','2010-01-09','2010-01-09','gpssk',1,4,5,'N'),(14,'Enl hjälp','2010-01-10','2010-01-10','kkkk',2,6,5,'T'),(15,'Big Shooter','2010-05-01','2010-05-01','Grusplanen',1,7,1,'N'),(16,'Lars Testar 20feb','2010-02-22','2010-02-22','Hemma',22,6,5,'N'),(17,'Ulfs arkiverade','0000-00-00','0000-00-00','',1,0,5,'N'),(18,'Västbo','2101-03-30','2101-03-30','Västbo',91,6,5,'N'),(19,'','0000-00-00','0000-00-00','',1,0,5,'N'),(20,'Nybörjarfält','2010-04-11','2010-04-11','GPSSK - Högsbo',22,4,4,'T'),(21,'100% 2010','2010-06-23','2010-06-23','Högsbo',22,4,4,'N');
/*!40000 ALTER TABLE `tbl_Pistol_Competition` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_CompetitionDay`
--
DROP TABLE IF EXISTS `tbl_Pistol_CompetitionDay`;
CREATE TABLE `tbl_Pistol_CompetitionDay` (
`Id` bigint(20) NOT NULL auto_increment,
`CompetitionId` bigint(20) default NULL,
`DayNo` smallint(6) NOT NULL,
`FirstStart` varchar(5) default NULL,
`LastStart` varchar(5) default NULL,
`MaxStation` int(11) default NULL,
`PatrolSpace` int(11) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`CompetitionId`,`DayNo`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_CompetitionDay`
--
LOCK TABLES `tbl_Pistol_CompetitionDay` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_CompetitionDay` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_CompetitionDay` VALUES (15,12,1,'09:00','12:00',8,15),(16,0,0,'','',0,0),(17,0,1,'08:00','10:00',8,10),(18,13,1,'08:00','10:00',8,10),(19,14,1,'09:00','15:00',8,15),(20,15,1,'09:00','15:00',10,15),(21,16,1,'08:30','14:00',8,10),(22,18,1,'08:00','16:00',8,8),(23,20,1,'10:00','14:00',6,15),(24,20,0,'','',0,0),(25,21,1,'16:00','19:00',10,10);
/*!40000 ALTER TABLE `tbl_Pistol_CompetitionDay` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_Entry`
--
DROP TABLE IF EXISTS `tbl_Pistol_Entry`;
CREATE TABLE `tbl_Pistol_Entry` (
`Id` bigint(20) NOT NULL auto_increment,
`ShotId` bigint(20) default NULL,
`GunClassificationId` bigint(20) default NULL,
`ShotClassId` bigint(20) default NULL,
`RegisterDate` datetime NOT NULL,
`Status` char(1) default NULL,
`PatrolId` bigint(20) default NULL,
`PayDate` datetime default NULL,
`TeamId` bigint(20) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`PatrolId`,`ShotId`),
UNIQUE KEY `i2` (`ShotId`,`PatrolId`)
) ENGINE=MyISAM AUTO_INCREMENT=376 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_Entry`
--
LOCK TABLES `tbl_Pistol_Entry` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_Entry` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_Entry` VALUES (192,3,2,15,'2010-01-06 13:09:15','U',229,NULL,NULL),(191,2,4,17,'2010-01-06 13:09:15','U',276,NULL,NULL),(193,3,3,3,'2010-01-06 13:09:40','U',216,NULL,NULL),(194,2,1,11,'2010-01-06 13:10:05','U',272,NULL,NULL),(195,10,1,10,'2010-01-06 13:10:48','U',165,NULL,NULL),(196,10,2,15,'2010-01-06 13:11:04','U',229,NULL,NULL),(197,10,4,18,'2010-01-06 13:11:33','U',169,NULL,NULL),(198,4,3,2,'2010-01-06 13:13:25','U',267,NULL,NULL),(199,10,1,11,'2010-01-06 13:17:46','U',273,NULL,NULL),(200,4,1,11,'2010-01-06 13:17:51','U',280,NULL,NULL),(201,10,3,2,'2010-01-06 13:17:57','U',267,NULL,NULL),(202,10,5,19,'2010-01-06 13:18:29','U',280,NULL,NULL),(203,1,1,11,'2010-01-06 13:25:29','U',165,NULL,NULL),(204,1,2,14,'2010-01-06 13:25:38','U',212,NULL,NULL),(205,1,4,17,'2010-01-06 13:25:57','U',193,NULL,NULL),(279,65,3,2,'2010-04-10 02:14:35','U',341,NULL,NULL),(313,53,3,2,'2010-04-10 07:51:24','U',340,NULL,NULL),(295,53,1,11,'2010-04-10 04:19:21','P',343,'2010-04-10 07:42:52',NULL),(274,64,4,18,'2010-04-09 05:16:44','P',350,'2010-04-10 04:22:00',NULL),(210,8,1,10,'2010-01-06 13:28:23','U',272,NULL,NULL),(211,8,2,14,'2010-01-06 13:28:30','U',269,NULL,NULL),(212,8,3,3,'2010-01-06 13:28:39','U',268,NULL,NULL),(213,8,4,17,'2010-01-06 13:28:53','U',276,NULL,NULL),(214,8,5,19,'2010-01-06 13:29:02','U',278,NULL,NULL),(273,64,1,12,'2010-04-09 05:16:05','P',342,'2010-04-10 04:21:57',NULL),(297,63,1,12,'2010-04-10 04:29:04','U',343,NULL,NULL),(357,91,3,7,'2010-06-22 16:19:03','P',351,'2010-06-22 16:27:31',NULL),(218,3,3,3,'2010-02-20 09:20:56','P',310,'2010-02-23 18:38:16',2),(219,3,2,15,'2010-02-20 09:21:07','P',322,'2010-02-23 18:38:18',NULL),(220,3,4,18,'2010-02-20 09:21:20','P',317,'2010-02-23 18:38:17',NULL),(221,10,3,3,'2010-02-20 09:22:04','P',310,'2010-02-20 09:31:38',NULL),(222,10,2,15,'2010-02-20 09:22:11','P',322,'2010-02-20 09:31:40',NULL),(223,10,4,18,'2010-02-20 09:22:22','P',317,'2010-02-20 09:31:39',NULL),(271,62,4,17,'2010-04-07 09:34:43','P',342,'2010-04-10 02:22:02',NULL),(270,62,3,2,'2010-04-07 09:34:11','P',338,'2010-04-10 02:22:00',NULL),(268,61,3,1,'2010-04-06 14:28:24','P',339,'2010-04-10 02:49:46',NULL),(267,60,4,17,'2010-04-06 14:10:58','P',349,'2010-04-10 02:21:47',NULL),(315,55,3,1,'2010-04-10 09:17:49','U',341,NULL,NULL),(300,16,3,4,'2010-04-10 04:42:37','P',344,'2010-04-10 07:43:04',NULL),(308,52,4,16,'2010-04-10 06:31:44','U',348,NULL,NULL),(269,2,3,2,'2010-04-07 07:40:05','P',339,'2010-04-10 02:51:31',NULL),(278,66,3,1,'2010-04-10 02:12:39','P',337,'2010-04-10 02:32:54',NULL),(233,16,3,4,'2010-02-20 09:26:32','P',310,'2010-02-20 09:31:48',NULL),(234,16,2,13,'2010-02-20 09:26:39','P',322,'2010-02-20 09:31:50',NULL),(235,16,4,16,'2010-02-20 09:26:44','P',317,'2010-02-20 09:31:49',NULL),(236,12,3,5,'2010-02-20 09:27:38','P',311,'2010-02-20 09:31:15',NULL),(237,12,2,14,'2010-02-20 09:27:46','P',322,'2010-02-20 09:31:16',NULL),(238,12,4,17,'2010-02-20 09:28:00','P',324,'2010-02-20 09:31:16',NULL),(311,50,3,1,'2010-04-10 06:41:20','U',340,NULL,NULL),(250,49,3,1,'2010-03-30 15:56:08','P',337,'2010-04-10 02:21:21',NULL),(249,48,3,1,'2010-03-30 15:38:56','P',337,'2010-04-10 02:40:26',NULL),(242,3,1,12,'2010-02-20 09:29:30','P',326,'2010-02-23 18:38:19',NULL),(369,91,1,12,'2010-06-22 18:26:47','P',361,'2010-06-22 19:52:12',NULL),(264,58,3,7,'2010-04-05 14:21:54','U',337,NULL,NULL),(266,60,3,5,'2010-04-06 14:10:00','P',339,'2010-04-10 02:21:41',NULL),(296,49,4,16,'2010-04-10 04:20:46','U',342,NULL,NULL),(281,67,3,2,'2010-04-10 02:27:02','P',338,'2010-04-10 02:31:19',NULL),(282,67,1,11,'2010-04-10 02:27:17','P',343,'2010-04-10 02:31:20',NULL),(283,68,3,4,'2010-04-10 02:28:50','P',338,'2010-04-10 02:31:26',NULL),(294,48,1,10,'2010-04-10 04:06:50','U',342,NULL,NULL),(285,70,3,8,'2010-04-10 02:37:08','P',341,'2010-04-10 02:37:52',NULL),(286,71,3,2,'2010-04-10 02:44:59','P',340,'2010-04-10 02:48:03',NULL),(301,71,4,17,'2010-04-10 04:54:44','U',349,NULL,NULL),(288,71,1,11,'2010-04-10 02:45:41','P',350,'2010-04-10 02:48:04',NULL),(289,72,3,1,'2010-04-10 02:46:59','P',338,'2010-04-10 02:48:13',NULL),(290,72,1,10,'2010-04-10 02:47:25','P',343,'2010-04-10 02:48:14',NULL),(291,73,3,5,'2010-04-10 03:05:38','U',340,NULL,NULL),(314,53,4,17,'2010-04-10 07:51:40','U',348,NULL,NULL),(298,3,3,3,'2010-04-10 04:40:43','U',344,NULL,NULL),(310,52,3,1,'2010-04-10 06:37:13','U',344,NULL,NULL),(304,74,1,11,'2010-04-10 05:01:42','U',350,NULL,NULL),(303,74,3,2,'2010-04-10 05:01:12','U',344,NULL,NULL),(305,55,4,16,'2010-04-10 05:05:51','U',349,NULL,NULL),(309,2,4,17,'2010-04-10 06:33:30','U',348,NULL,NULL),(312,16,4,16,'2010-04-10 07:27:04','P',348,'2010-04-10 07:43:06',NULL),(318,3,3,3,'2010-06-15 00:13:19','U',351,NULL,NULL),(375,3,2,15,'2010-06-22 19:44:13','U',363,NULL,NULL),(322,50,3,1,'2010-06-15 21:19:47','P',352,'2010-06-22 16:48:31',NULL),(323,64,1,12,'2010-06-15 21:32:29','P',355,'2010-06-22 17:36:13',NULL),(374,98,3,4,'2010-06-22 19:43:26','P',364,'2010-06-22 20:08:06',NULL),(368,2,3,2,'2010-06-22 18:22:46','U',359,NULL,NULL),(327,60,3,5,'2010-06-16 13:43:38','P',357,'2010-06-22 17:36:50',NULL),(328,75,3,8,'2010-06-16 17:08:20','P',354,'2010-06-22 16:48:14',NULL),(329,52,3,1,'2010-06-16 23:38:11','P',354,'2010-06-22 17:06:08',NULL),(330,52,2,13,'2010-06-16 23:40:06','P',363,'2010-06-22 17:06:09',NULL),(333,48,3,1,'2010-06-17 10:32:52','P',357,'2010-06-22 17:36:59',NULL),(334,63,3,8,'2010-06-18 22:24:51','P',353,'2010-06-22 16:47:54',NULL),(336,16,3,4,'2010-06-19 12:21:15','P',357,'2010-06-22 18:05:49',NULL),(340,76,3,3,'2010-06-20 15:03:32','P',351,'2010-06-22 18:18:28',NULL),(341,76,2,15,'2010-06-20 15:03:57','P',360,'2010-06-22 18:18:29',NULL),(342,77,3,3,'2010-06-20 17:53:45','P',351,'2010-06-22 16:26:33',NULL),(343,77,2,15,'2010-06-20 17:54:23','P',360,'2010-06-22 16:26:34',NULL),(344,78,1,12,'2010-06-20 20:34:26','P',356,'2010-06-22 17:04:45',NULL),(345,78,3,3,'2010-06-20 20:35:12','P',366,'2010-06-22 17:04:46',NULL),(346,80,3,3,'2010-06-20 21:51:37','P',357,'2010-06-22 17:40:32',NULL),(348,81,4,16,'2010-06-20 22:00:20','P',362,'2010-06-22 17:13:07',NULL),(349,81,3,1,'2010-06-20 22:02:55','P',354,'2010-06-22 17:13:06',NULL),(350,85,3,3,'2010-06-21 20:58:14','P',354,'2010-06-22 17:35:42',NULL),(351,86,3,9,'2010-06-21 21:14:00','P',352,'2010-06-22 16:27:46',NULL),(352,87,3,9,'2010-06-21 21:15:34','P',352,'2010-06-22 16:27:42',NULL),(353,88,3,1,'2010-06-21 21:17:46','P',352,'2010-06-22 16:27:49',NULL),(354,89,3,9,'2010-06-21 22:35:32','U',359,NULL,NULL),(355,67,3,2,'2010-06-21 23:20:01','P',353,'2010-06-22 17:36:00',NULL),(373,67,1,11,'2010-06-22 19:27:34','P',362,'2010-06-22 20:07:46',NULL),(359,92,3,8,'2010-06-22 16:30:55','P',353,'2010-06-22 19:51:37',NULL),(366,55,3,8,'2010-06-22 18:16:39','P',358,'2010-06-22 19:52:33',NULL),(367,93,3,3,'2010-06-22 18:21:56','P',353,'2010-06-22 20:07:59',NULL),(362,68,3,4,'2010-06-22 17:55:11','P',359,'2010-06-22 17:58:03',NULL),(363,90,3,7,'2010-06-22 17:56:39','P',359,'2010-06-22 17:57:53',NULL),(364,94,3,2,'2010-06-22 18:02:03','P',358,'2010-06-22 18:02:48',NULL),(365,95,3,2,'2010-06-22 18:04:54','P',358,'2010-06-22 18:05:33',NULL),(370,96,3,1,'2010-06-22 18:30:43','U',360,NULL,NULL),(372,97,3,2,'2010-06-22 18:39:24','P',363,'2010-06-22 18:39:57',NULL);
/*!40000 ALTER TABLE `tbl_Pistol_Entry` ENABLE KEYS */;
UNLOCK TABLES;
ALTER TABLE `tbl_Pistol_Entry` ADD COLUMN `StaPlats` int DEFAULT 0 AFTER `TeamId` ;
ALTER TABLE `tbl_Pistol_Entry` ADD COLUMN `BokadAvShotId` int DEFAULT 0 AFTER `StaPlats` ;
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`root`@`localhost` */ /*!50003 TRIGGER `tr_entry_ins` BEFORE INSERT ON `tbl_Pistol_Entry` FOR EACH ROW set NEW.RegisterDate = now() */;;
DELIMITER ;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */;
--
-- Table structure for table `tbl_Pistol_EntryPatrol`
--
DROP TABLE IF EXISTS `tbl_Pistol_EntryPatrol`;
CREATE TABLE `tbl_Pistol_EntryPatrol` (
`Id` bigint(20) NOT NULL auto_increment,
`EntryId` bigint(20) default NULL,
`PatrolId` bigint(20) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`EntryId`,`PatrolId`),
UNIQUE KEY `i2` (`PatrolId`,`EntryId`)
) ENGINE=MyISAM AUTO_INCREMENT=279 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_EntryPatrol`
--
LOCK TABLES `tbl_Pistol_EntryPatrol` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_EntryPatrol` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_Pistol_EntryPatrol` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_FailedLogons`
--
DROP TABLE IF EXISTS `tbl_Pistol_FailedLogons`;
CREATE TABLE `tbl_Pistol_FailedLogons` (
`Id` bigint(20) NOT NULL auto_increment,
`GunCard` varchar(10) NOT NULL,
`LogonDate` timestamp NOT NULL default CURRENT_TIMESTAMP ,
PRIMARY KEY (`Id`),
KEY `i1` (`GunCard`,`LogonDate`),
KEY `i2` (`LogonDate`)
) ENGINE=MyISAM AUTO_INCREMENT=162 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_FailedLogons`
--
LOCK TABLES `tbl_Pistol_FailedLogons` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_FailedLogons` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_FailedLogons` VALUES (1,'1','2008-05-14 22:42:38'),(2,'1','2008-05-14 22:43:04'),(3,'1','2008-05-14 22:44:07'),(4,'1','2008-05-14 22:44:16'),(5,'1','2008-05-14 22:52:45'),(6,'1','2008-05-15 08:54:34'),(7,'1','2008-05-15 08:54:49'),(8,'1','2008-05-15 19:09:15'),(9,'1','2008-05-23 16:25:58'),(10,'100','2008-06-10 01:02:51'),(11,'100','2008-06-12 09:43:12'),(12,'100','2008-06-12 14:38:35'),(13,'100','2008-06-12 14:39:18'),(14,'1','2008-06-12 14:40:42'),(15,'100','2008-06-12 14:42:04'),(16,'1','2008-06-12 16:12:01'),(17,'24924','2008-06-17 10:35:20'),(18,'1657','2008-06-17 17:57:38'),(19,'1657','2008-06-17 17:57:52'),(20,'1657','2008-06-17 17:58:08'),(21,'1657','2008-06-17 18:00:18'),(22,'1657','2008-06-17 18:05:11'),(23,'1657','2008-06-17 18:05:19'),(24,'1657','2008-06-17 18:29:08'),(25,'1657','2008-06-17 18:29:16'),(26,'1657','2008-06-17 20:46:47'),(27,'1657','2008-06-17 20:46:56'),(28,'1657','2008-06-17 20:47:05'),(29,'1657','2008-06-17 20:47:12'),(30,'1657','2008-06-17 20:47:20'),(31,'1657','2008-06-23 04:32:04'),(32,'1657','2008-06-23 04:32:10'),(33,'1657','2008-06-23 04:32:23'),(34,'1657','2008-06-23 04:32:29'),(35,'1','2008-06-23 10:07:31'),(36,'1','2008-06-24 06:38:56'),(37,'666','2008-07-01 12:50:48'),(38,'1','2008-07-15 11:01:59'),(39,'1','2008-07-15 11:02:15'),(40,'1','2008-07-15 17:55:23'),(41,'18623','2008-09-02 10:04:20'),(42,'18623','2008-09-02 10:04:28'),(43,'24924','2008-09-11 17:56:24'),(44,'18623','2008-10-07 08:44:45'),(45,'66666','2008-11-10 06:57:15'),(46,'66666','2008-11-10 06:57:26'),(47,'1457','2008-11-18 07:08:02'),(48,'1457','2008-11-18 07:08:16'),(49,'1457','2008-11-18 07:08:28'),(50,'1457','2008-11-18 07:08:35'),(51,'1457','2008-11-18 07:14:00'),(52,'1547','2008-11-18 07:14:18'),(53,'1457','2008-11-18 07:14:35'),(54,'1457','2008-11-18 07:14:58'),(55,'24924','2008-12-05 19:44:39'),(56,'1457','2008-12-06 23:17:32'),(57,'1657','2009-01-17 20:06:56'),(58,'1657','2009-01-17 20:07:04'),(59,'1657','2009-01-17 20:07:24'),(60,'15','2009-01-17 20:47:15'),(61,'15','2009-01-17 20:47:29'),(62,'5712','2009-01-24 15:46:10'),(63,'66666','2009-03-11 11:20:08'),(64,'1','2009-04-04 07:27:11'),(65,'1','2009-04-26 00:09:57'),(66,'14246','2009-04-30 16:14:56'),(67,'66666','2009-10-13 15:59:49'),(68,'66666','2009-10-13 16:00:00'),(69,'24924','2009-12-10 11:48:46'),(70,'1001','2009-12-10 17:18:19'),(71,'1657','2010-01-06 12:41:18'),(72,'1657','2010-03-30 15:30:54'),(73,'30611','2010-03-31 17:23:44'),(74,'28388','2010-04-01 02:52:34'),(75,'66666','2010-04-01 04:47:44'),(76,'asd','2010-04-06 09:37:23'),(77,'asd','2010-04-06 09:37:30'),(78,'1472317','2010-04-06 14:06:34'),(79,'tsellering','2010-04-07 11:50:05'),(80,'m270966tom','2010-04-07 11:51:11'),(81,'m270966tom','2010-04-07 11:51:21'),(82,'M270966TOM','2010-04-07 11:51:59'),(83,'M270966TOM','2010-04-07 11:52:27'),(84,'M270966TOM','2010-04-07 11:52:53'),(85,'M270966TOM','2010-04-07 11:53:13'),(86,'M270966TOM','2010-04-07 11:53:31'),(87,'m270966tom','2010-04-07 11:54:19'),(88,'m270966tom','2010-04-07 11:55:21'),(89,'m270966tom','2010-04-07 11:55:32'),(90,'m270966tom','2010-04-07 11:57:10'),(91,'m270966tom','2010-04-07 11:57:18'),(92,'M270966TOM','2010-04-07 11:58:20'),(93,'M270966TOM','2010-04-07 12:03:39'),(94,'M270966TOM','2010-04-07 12:04:47'),(95,'M270966TOM','2010-04-07 12:05:00'),(96,'M270966TOM','2010-04-07 12:05:07'),(97,'M270966TOM','2010-04-08 08:08:05'),(98,'M270966TOM','2010-04-08 08:08:39'),(99,'M270966TOM','2010-04-08 08:09:11'),(100,'M270966TOM','2010-04-08 08:09:49'),(101,'M270966TOM','2010-04-08 08:09:51'),(102,'M270966TOM','2010-04-08 08:09:57'),(103,'M270966TOM','2010-04-08 08:09:59'),(104,'M270966TOM','2010-04-08 08:10:01'),(105,'M270966TOM','2010-04-08 08:11:57'),(106,'M270966TOM','2010-04-08 08:12:12'),(107,'M270966TOM','2010-04-08 08:12:35'),(108,'M270966TOM','2010-04-08 08:13:08'),(109,'M270966TOM','2010-04-08 08:13:12'),(110,'M270966TOM','2010-04-08 08:13:15'),(111,'25664','2010-04-08 09:49:32'),(112,'020','2010-04-08 10:06:52'),(113,'020','2010-04-08 10:09:26'),(114,'M270966TOM','2010-04-09 09:13:08'),(115,'M270966TOM','2010-04-09 09:13:38'),(116,'M270966TOM','2010-04-09 09:13:57'),(117,'M270966TOM','2010-04-09 09:14:09'),(118,'08688','2010-04-09 09:14:51'),(119,'08688','2010-04-09 09:15:08'),(120,'M270966TOM','2010-04-09 09:15:32'),(121,'M270966TOM','2010-04-09 09:15:42'),(122,'1657','2010-04-10 01:57:30'),(123,'30611','2010-04-10 06:04:00'),(124,'3632','2010-06-15 21:21:38'),(125,'26314','2010-06-16 13:31:12'),(126,'5708','2010-06-16 17:03:56'),(127,'5708','2010-06-16 17:10:23'),(128,'28390','2010-06-16 23:10:46'),(129,'28390','2010-06-16 23:11:04'),(130,'28390','2010-06-16 23:11:42'),(131,'1486928','2010-06-17 10:29:09'),(132,'28390','2010-06-17 21:36:25'),(133,'28390','2010-06-17 21:36:42'),(134,'28390','2010-06-17 21:37:00'),(135,'28390','2010-06-17 21:37:16'),(136,'28390','2010-06-17 21:37:42'),(137,'','2010-06-19 12:12:22'),(138,'17563','2010-06-20 20:31:53'),(139,'24314','2010-06-20 21:01:45'),(140,'24314','2010-06-20 21:01:56'),(141,'24314','2010-06-20 21:10:03'),(142,'24314','2010-06-20 22:25:58'),(143,'24314','2010-06-20 22:26:07'),(144,'24314','2010-06-20 22:26:38'),(145,'24314','2010-06-20 22:26:48'),(146,'23174','2010-06-21 01:04:15'),(147,'26707','2010-06-21 21:04:16'),(148,'26707','2010-06-21 21:04:29'),(149,'26706','2010-06-21 22:30:37'),(150,'583','2010-06-22 17:16:39'),(151,'583','2010-06-22 17:16:48'),(152,'583','2010-06-22 17:16:54'),(153,'583','2010-06-22 17:19:56'),(154,'0583','2010-06-22 17:20:07'),(155,'583','2010-06-22 17:20:45'),(156,'583','2010-06-22 17:20:54'),(157,'0583','2010-06-22 17:21:00'),(158,'583','2010-06-22 17:22:06'),(159,'29055','2010-06-22 17:34:20'),(160,'1657','2010-06-22 21:20:15'),(161,'1657','2010-06-22 21:20:25');
/*!40000 ALTER TABLE `tbl_Pistol_FailedLogons` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`www`@`%` */ /*!50003 TRIGGER `tr_failedlogons_ins` BEFORE INSERT ON `tbl_Pistol_FailedLogons` FOR EACH ROW set NEW.LogonDate = now() */;;
DELIMITER ;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */;
--
-- Table structure for table `tbl_Pistol_GunClassification`
--
DROP TABLE IF EXISTS `tbl_Pistol_GunClassification`;
CREATE TABLE `tbl_Pistol_GunClassification` (
`Id` bigint(20) NOT NULL auto_increment,
`Grade` varchar(30) NOT NULL,
`Description` varchar(100) default NULL,
`ForScoreType` CHAR(10) NULL DEFAULT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`Grade`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_GunClassification`
--
LOCK TABLES `tbl_Pistol_GunClassification` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_GunClassification` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_GunClassification` VALUES (1,'A','Grovkalibrig pistol', 'NTP'),(2,'B','Grovkalibrig pistol special', 'NTP'),(3,'C','Finkalibrig pistol (22)', 'NTP'),(4,'R','Revolver', 'NTP'),(5,'S','Snubb', 'NTP');
INSERT INTO `tbl_Pistol_GunClassification` VALUES (6,'Grov','Grovkalibrig pistol', 'S'),(7,'Sport','Sportpistol', 'S'),(8,'Standard','Standard pistol', 'S'),(9,'Snabb','Snabbpistol', 'S'),(10,'Luft','Luftpistol', 'S');
INSERT INTO `tbl_Pistol_GunClassification` VALUES (11,'P1500','Pistol 1500', 'C'),(12,'R1500','Revlover 1500', 'C'),(13,'SR6','SR6', 'C'),(14,'SP5','SP5', 'C'),(15,'SR4','SR4', 'C'),(16,'SR3','SR3', 'C'),(17,'SP5FR','SP5FR', 'C');
/*!40000 ALTER TABLE `tbl_Pistol_GunClassification` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_Logons`
--
DROP TABLE IF EXISTS `tbl_Pistol_Logons`;
CREATE TABLE `tbl_Pistol_Logons` (
`Id` bigint(20) NOT NULL auto_increment,
`ShotId` bigint(20) NOT NULL,
`LogonDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`Id`),
KEY `i1` (`ShotId`,`LogonDate`),
KEY `i2` (`LogonDate`)
) ENGINE=MyISAM AUTO_INCREMENT=395 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_Logons`
--
LOCK TABLES `tbl_Pistol_Logons` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_Logons` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_Logons` VALUES (1,2,'2008-05-14 18:08:05'),(2,1,'2008-05-14 22:42:42'),(3,1,'2008-05-15 08:54:56'),(4,1,'2008-05-15 08:55:13'),(5,1,'2008-05-15 08:57:32'),(6,2,'2008-05-15 10:07:31'),(7,2,'2008-05-15 11:22:11'),(8,2,'2008-05-15 16:59:43'),(9,1,'2008-05-15 17:48:40'),(10,3,'2008-05-15 17:50:56'),(11,2,'2008-05-15 18:04:45'),(12,1,'2008-05-15 19:09:20'),(13,2,'2008-05-15 19:11:10'),(14,4,'2008-05-15 19:17:41'),(15,2,'2008-05-15 19:20:35'),(16,2,'2008-05-14 10:41:11'),(17,4,'2008-05-14 10:42:06'),(18,1,'2008-05-14 13:04:58'),(19,1,'2008-05-14 13:23:06'),(20,1,'2008-05-14 13:25:55'),(21,4,'2008-05-14 14:26:20'),(22,2,'2008-05-14 14:26:38'),(23,1,'2008-05-14 20:14:31'),(24,1,'2008-05-16 18:15:27'),(25,1,'2008-05-18 18:14:03'),(26,1,'2008-05-18 18:14:48'),(27,1,'2008-05-19 15:32:43'),(28,1,'2008-05-20 12:31:24'),(29,1,'2008-05-21 12:19:35'),(30,2,'2008-05-21 12:42:35'),(31,4,'2008-05-21 12:50:57'),(32,2,'2008-05-21 12:51:53'),(33,1,'2008-05-21 13:16:20'),(34,2,'2008-05-21 13:28:14'),(35,1,'2008-05-22 10:32:55'),(36,2,'2008-05-22 13:00:42'),(37,1,'2008-05-23 05:36:51'),(38,1,'2008-05-23 16:25:59'),(39,3,'2008-05-25 23:04:23'),(40,2,'2008-05-26 23:14:47'),(41,1,'2008-05-30 06:10:11'),(42,2,'2008-06-01 10:13:48'),(43,1,'2008-06-07 08:19:18'),(44,2,'2008-06-08 03:04:47'),(45,5,'2008-06-11 11:08:53'),(46,1,'2008-06-11 11:09:05'),(47,5,'2008-06-12 14:39:44'),(48,1,'2008-06-12 14:40:48'),(49,5,'2008-06-12 14:42:06'),(50,1,'2008-06-12 15:24:15'),(51,1,'2008-06-12 16:12:26'),(52,2,'2008-06-17 10:16:49'),(53,1,'2008-06-17 10:39:24'),(54,2,'2008-06-17 10:39:59'),(55,4,'2008-06-17 10:41:00'),(56,2,'2008-06-17 10:43:37'),(57,2,'2008-06-17 14:20:50'),(58,2,'2008-06-23 04:53:42'),(59,3,'2008-06-23 04:54:08'),(60,3,'2008-06-23 05:42:34'),(61,1,'2008-06-23 10:07:48'),(62,1,'2008-06-24 06:39:01'),(63,3,'2008-06-24 08:39:06'),(64,1,'2008-06-26 07:26:51'),(65,6,'2008-06-26 09:37:06'),(66,1,'2008-06-26 16:02:47'),(67,3,'2008-07-01 12:36:20'),(68,4,'2008-07-01 12:50:57'),(69,2,'2008-07-01 12:57:15'),(70,3,'2008-07-01 12:59:28'),(71,3,'2008-07-01 13:02:58'),(72,1,'2008-07-02 08:29:33'),(73,3,'2008-07-07 05:02:33'),(74,1,'2008-07-14 19:29:09'),(75,2,'2008-07-15 06:28:27'),(76,4,'2008-07-15 06:44:18'),(77,2,'2008-07-15 06:45:56'),(78,1,'2008-07-15 11:02:23'),(79,1,'2008-07-15 17:55:29'),(80,1,'2008-07-15 18:54:42'),(81,1,'2008-07-23 03:37:20'),(82,3,'2008-08-05 22:34:08'),(83,6,'2008-09-02 10:04:36'),(84,1,'2008-09-09 17:40:37'),(85,2,'2008-09-11 17:56:35'),(86,11,'2008-09-12 16:18:08'),(87,2,'2008-09-12 16:21:43'),(88,11,'2008-09-12 16:24:57'),(89,2,'2008-09-12 16:48:35'),(90,1,'2008-10-08 20:09:55'),(91,2,'2008-11-10 06:56:26'),(92,4,'2008-11-10 06:57:30'),(93,2,'2008-11-10 06:58:09'),(94,4,'2008-11-10 06:58:44'),(95,2,'2008-11-10 07:02:51'),(96,2,'2008-11-15 09:48:58'),(97,4,'2008-11-15 09:50:22'),(98,2,'2008-11-15 09:51:03'),(99,1,'2008-12-01 08:34:41'),(100,2,'2008-12-05 19:42:06'),(101,3,'2008-12-06 23:20:58'),(102,15,'2008-12-29 12:33:42'),(103,2,'2008-12-29 13:18:01'),(104,2,'2009-01-17 18:46:18'),(105,4,'2009-01-17 18:54:43'),(106,2,'2009-01-17 18:55:27'),(107,4,'2009-01-17 18:56:37'),(108,2,'2009-01-17 18:58:31'),(109,4,'2009-01-17 19:08:22'),(110,3,'2009-01-17 20:08:09'),(111,24,'2009-01-17 20:13:33'),(112,27,'2009-01-17 20:18:40'),(113,19,'2009-01-17 20:25:52'),(114,3,'2009-01-17 20:36:02'),(115,28,'2009-01-17 20:42:10'),(116,26,'2009-01-17 20:43:52'),(117,30,'2009-01-17 20:45:15'),(118,31,'2009-01-17 20:46:34'),(119,9,'2009-01-17 20:47:45'),(120,17,'2009-01-17 20:48:32'),(121,18,'2009-01-17 20:49:24'),(122,34,'2009-01-17 20:49:47'),(123,32,'2009-01-17 20:50:06'),(124,3,'2009-01-17 20:50:49'),(125,2,'2009-01-17 20:53:48'),(126,19,'2009-01-17 20:56:57'),(127,19,'2009-01-17 20:57:57'),(128,2,'2009-01-17 21:13:37'),(129,19,'2009-01-17 21:25:40'),(130,15,'2009-01-24 15:46:20'),(131,4,'2009-03-11 11:20:16'),(132,2,'2009-03-11 11:20:46'),(133,4,'2009-03-11 11:21:24'),(134,1,'2009-04-04 07:27:21'),(135,1,'2009-04-04 07:41:45'),(136,2,'2009-04-14 18:13:12'),(137,44,'2009-04-14 20:35:38'),(138,44,'2009-04-14 21:14:07'),(139,44,'2009-04-20 00:59:53'),(140,44,'2009-04-20 01:19:42'),(141,44,'2009-04-20 02:16:55'),(142,1,'2009-04-22 10:59:08'),(143,1,'2009-04-26 00:10:05'),(144,2,'2009-04-26 00:55:50'),(145,2,'2009-04-26 01:18:02'),(146,3,'2009-04-26 01:18:39'),(147,3,'2009-04-26 02:09:15'),(148,2,'2009-04-29 12:08:35'),(149,15,'2009-04-29 14:48:46'),(150,45,'2009-04-30 16:15:05'),(151,2,'2009-05-01 23:09:47'),(152,15,'2009-05-04 01:50:21'),(153,45,'2009-05-04 21:27:50'),(154,3,'2009-05-05 00:37:46'),(155,3,'2009-05-08 12:00:37'),(156,44,'2009-05-14 05:44:27'),(157,2,'2009-10-13 15:51:20'),(158,4,'2009-10-13 16:00:10'),(159,2,'2009-10-13 16:04:19'),(160,2,'2009-10-19 19:37:55'),(161,4,'2009-10-19 19:51:37'),(162,2,'2009-10-19 19:54:24'),(163,2,'2009-12-10 11:48:54'),(164,1,'2009-12-10 17:18:25'),(165,3,'2010-01-06 12:43:11'),(166,2,'2010-01-06 12:44:02'),(167,4,'2010-01-06 13:13:03'),(168,3,'2010-01-06 13:14:21'),(169,4,'2010-01-06 13:18:51'),(170,2,'2010-01-06 13:22:37'),(171,3,'2010-01-06 13:22:54'),(172,3,'2010-01-06 13:26:23'),(173,3,'2010-01-06 13:27:56'),(174,3,'2010-01-06 13:29:29'),(175,2,'2010-01-06 13:33:04'),(176,2,'2010-01-06 13:49:29'),(177,3,'2010-01-06 14:06:12'),(178,1,'2010-02-16 01:56:46'),(179,2,'2010-02-17 04:30:19'),(180,1,'2010-02-17 05:11:17'),(181,2,'2010-02-17 05:23:27'),(182,1,'2010-02-17 05:46:30'),(183,1,'2010-02-17 07:26:57'),(184,1,'2010-02-18 06:23:37'),(185,1,'2010-02-18 06:23:56'),(186,1,'2010-02-19 12:31:02'),(187,1,'2010-02-20 04:50:00'),(188,3,'2010-02-20 09:15:07'),(189,3,'2010-02-20 09:22:43'),(190,3,'2010-02-20 09:23:46'),(191,3,'2010-02-20 09:24:49'),(192,3,'2010-02-20 09:25:58'),(193,3,'2010-02-20 09:27:01'),(194,3,'2010-02-20 09:28:14'),(195,3,'2010-02-20 09:29:05'),(196,3,'2010-02-20 09:30:20'),(197,1,'2010-02-20 14:23:40'),(198,3,'2010-02-21 10:28:53'),(199,3,'2010-02-23 18:34:46'),(200,3,'2010-02-24 23:37:45'),(201,3,'2010-02-25 09:28:06'),(202,3,'2010-02-25 18:07:10'),(203,3,'2010-02-26 18:52:47'),(204,3,'2010-03-08 08:33:07'),(205,3,'2010-03-08 14:15:45'),(206,3,'2010-03-09 14:43:50'),(207,3,'2010-03-10 17:51:57'),(208,3,'2010-03-11 07:43:55'),(209,1,'2010-03-11 16:51:29'),(210,3,'2010-03-13 12:35:33'),(211,3,'2010-03-21 05:12:16'),(212,3,'2010-03-21 05:15:42'),(213,3,'2010-03-21 05:40:10'),(214,46,'2010-03-21 05:41:29'),(215,46,'2010-03-21 09:01:03'),(216,46,'2010-03-21 10:41:16'),(217,3,'2010-03-27 04:53:55'),(218,3,'2010-03-27 10:20:47'),(219,3,'2010-03-27 10:27:28'),(220,3,'2010-03-27 10:34:05'),(221,3,'2010-03-28 14:00:31'),(222,47,'2010-03-29 08:37:54'),(223,1,'2010-03-30 15:28:25'),(224,3,'2010-03-30 15:32:11'),(225,49,'2010-03-30 15:57:05'),(226,3,'2010-03-31 02:36:58'),(227,52,'2010-03-31 04:40:25'),(228,53,'2010-03-31 05:48:14'),(229,53,'2010-03-31 07:37:50'),(230,53,'2010-03-31 08:14:48'),(231,2,'2010-03-31 08:17:43'),(232,50,'2010-03-31 11:09:29'),(233,2,'2010-03-31 11:54:30'),(234,53,'2010-03-31 17:24:06'),(235,53,'2010-03-31 18:51:14'),(236,16,'2010-04-01 02:54:25'),(237,3,'2010-04-01 03:07:19'),(238,2,'2010-04-01 04:45:52'),(239,4,'2010-04-01 04:47:51'),(240,3,'2010-04-01 06:47:35'),(241,3,'2010-04-01 09:24:22'),(242,3,'2010-04-01 14:05:22'),(243,53,'2010-04-01 18:29:15'),(244,55,'2010-04-02 04:29:14'),(245,52,'2010-04-04 11:29:30'),(246,2,'2010-04-06 07:15:27'),(247,53,'2010-04-06 07:44:19'),(248,16,'2010-04-07 02:03:56'),(249,16,'2010-04-07 02:14:02'),(250,3,'2010-04-07 02:38:26'),(251,61,'2010-04-07 04:56:15'),(252,53,'2010-04-07 07:26:24'),(253,2,'2010-04-07 07:38:59'),(254,61,'2010-04-07 08:20:36'),(255,60,'2010-04-07 10:16:18'),(256,61,'2010-04-08 02:11:45'),(257,61,'2010-04-08 05:07:58'),(258,53,'2010-04-08 07:18:10'),(259,2,'2010-04-08 08:08:19'),(260,16,'2010-04-08 09:44:38'),(261,63,'2010-04-08 10:12:34'),(262,3,'2010-04-08 12:28:10'),(263,61,'2010-04-08 13:18:04'),(264,61,'2010-04-09 02:13:35'),(265,61,'2010-04-09 04:38:01'),(266,52,'2010-04-09 04:53:13'),(267,2,'2010-04-09 06:05:32'),(268,53,'2010-04-09 08:41:19'),(269,60,'2010-04-09 11:12:42'),(270,49,'2010-04-09 14:00:16'),(271,53,'2010-04-09 14:52:00'),(272,53,'2010-04-09 15:55:20'),(273,3,'2010-04-10 00:03:54'),(274,53,'2010-04-10 01:56:28'),(275,3,'2010-04-10 01:57:41'),(276,3,'2010-04-10 02:11:15'),(277,3,'2010-04-10 02:13:00'),(278,65,'2010-04-10 02:17:03'),(279,3,'2010-04-10 02:20:53'),(280,3,'2010-04-10 02:30:59'),(281,3,'2010-04-10 02:37:37'),(282,3,'2010-04-10 02:42:46'),(283,3,'2010-04-10 02:43:47'),(284,3,'2010-04-10 02:47:38'),(285,3,'2010-04-10 02:58:27'),(286,3,'2010-04-10 03:07:33'),(287,3,'2010-04-10 03:09:07'),(288,3,'2010-04-10 03:19:12'),(289,3,'2010-04-10 04:06:09'),(290,3,'2010-04-10 04:07:04'),(291,49,'2010-04-10 04:20:06'),(292,3,'2010-04-10 04:21:06'),(293,3,'2010-04-10 04:29:22'),(294,3,'2010-04-10 04:40:14'),(295,3,'2010-04-10 04:42:02'),(296,3,'2010-04-10 04:43:04'),(297,3,'2010-04-10 04:54:55'),(298,3,'2010-04-10 04:59:20'),(299,3,'2010-04-10 04:59:55'),(300,3,'2010-04-10 05:02:15'),(301,3,'2010-04-10 05:06:08'),(302,3,'2010-04-10 05:09:52'),(303,3,'2010-04-10 06:04:28'),(304,3,'2010-04-10 06:14:11'),(305,3,'2010-04-10 06:19:25'),(306,3,'2010-04-10 06:20:34'),(307,3,'2010-04-10 06:21:52'),(308,3,'2010-04-10 06:32:04'),(309,3,'2010-04-10 06:37:39'),(310,3,'2010-04-10 06:41:33'),(311,3,'2010-04-10 07:27:16'),(312,3,'2010-04-10 07:50:56'),(313,3,'2010-04-10 07:51:53'),(314,3,'2010-04-10 09:16:01'),(315,3,'2010-04-10 09:18:01'),(316,52,'2010-04-10 09:22:01'),(317,2,'2010-04-11 04:19:45'),(318,61,'2010-04-11 10:56:30'),(319,3,'2010-04-11 13:57:25'),(320,2,'2010-04-12 11:14:44'),(321,2,'2010-04-13 01:05:22'),(322,3,'2010-04-16 07:10:58'),(323,3,'2010-04-19 21:01:52'),(324,15,'2010-04-25 02:14:36'),(325,53,'2010-05-17 21:09:15'),(326,3,'2010-06-15 00:06:06'),(327,50,'2010-06-15 21:13:48'),(328,64,'2010-06-15 21:29:25'),(329,53,'2010-06-16 00:03:17'),(330,2,'2010-06-16 12:02:39'),(331,60,'2010-06-16 13:42:17'),(332,60,'2010-06-16 13:45:05'),(333,75,'2010-06-16 17:10:34'),(334,1,'2010-06-16 20:45:50'),(335,3,'2010-06-16 21:29:21'),(336,60,'2010-06-16 21:36:06'),(337,52,'2010-06-16 23:18:35'),(338,75,'2010-06-17 10:02:17'),(339,48,'2010-06-17 10:29:13'),(340,53,'2010-06-17 13:04:20'),(341,3,'2010-06-17 14:10:46'),(342,52,'2010-06-17 21:41:26'),(343,60,'2010-06-18 00:46:37'),(344,50,'2010-06-18 17:22:46'),(345,63,'2010-06-18 22:23:52'),(346,16,'2010-06-19 12:16:10'),(347,52,'2010-06-19 18:10:05'),(348,60,'2010-06-19 22:24:19'),(349,3,'2010-06-19 23:20:07'),(350,53,'2010-06-20 01:10:40'),(351,53,'2010-06-20 01:17:24'),(352,75,'2010-06-20 09:57:48'),(353,64,'2010-06-20 14:30:32'),(354,80,'2010-06-20 22:08:55'),(355,2,'2010-06-21 09:39:47'),(356,2,'2010-06-21 12:03:06'),(357,2,'2010-06-21 16:45:40'),(358,75,'2010-06-21 17:23:36'),(359,60,'2010-06-21 20:36:40'),(360,67,'2010-06-21 23:09:54'),(361,53,'2010-06-21 23:48:27'),(362,76,'2010-06-22 10:29:50'),(363,2,'2010-06-22 12:35:50'),(364,89,'2010-06-22 13:59:35'),(365,76,'2010-06-22 14:19:45'),(366,52,'2010-06-22 14:26:59'),(367,3,'2010-06-22 15:09:01'),(368,75,'2010-06-22 15:11:24'),(369,3,'2010-06-22 16:20:00'),(370,3,'2010-06-22 16:31:13'),(371,3,'2010-06-22 16:34:00'),(372,2,'2010-06-22 17:04:00'),(373,2,'2010-06-22 17:19:03'),(374,2,'2010-06-22 17:22:14'),(375,2,'2010-06-22 17:28:32'),(376,2,'2010-06-22 17:30:25'),(377,2,'2010-06-22 17:38:49'),(378,68,'2010-06-22 17:54:58'),(379,90,'2010-06-22 17:56:22'),(380,3,'2010-06-22 18:16:52'),(381,3,'2010-06-22 18:22:06'),(382,3,'2010-06-22 18:28:08'),(383,3,'2010-06-22 18:31:02'),(384,3,'2010-06-22 18:39:47'),(385,3,'2010-06-22 19:13:33'),(386,3,'2010-06-22 19:27:44'),(387,3,'2010-06-22 19:43:36'),(388,3,'2010-06-22 21:20:41'),(389,3,'2010-06-22 22:39:17'),(390,90,'2010-06-23 08:03:27'),(391,2,'2010-06-23 09:42:32'),(392,2,'2010-06-23 10:59:51'),(393,67,'2010-07-04 09:52:26'),(394,2,'2010-07-04 14:14:24');
/*!40000 ALTER TABLE `tbl_Pistol_Logons` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`www`@`%` */ /*!50003 TRIGGER `tr_logons_ins` BEFORE INSERT ON `tbl_Pistol_Logons` FOR EACH ROW set NEW.LogonDate = now() */;;
DELIMITER ;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */;
--
-- Table structure for table `tbl_Pistol_MedalGroup`
--
DROP TABLE IF EXISTS `tbl_Pistol_MedalGroup`;
CREATE TABLE `tbl_Pistol_MedalGroup` (
`Id` bigint(20) NOT NULL auto_increment,
`Name` varchar(100) NOT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_MedalGroup`
--
LOCK TABLES `tbl_Pistol_MedalGroup` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_MedalGroup` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_MedalGroup` VALUES (1,'C'),(2,'A'),(3,'B'),(4,'R');
/*!40000 ALTER TABLE `tbl_Pistol_MedalGroup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_MedalGroupMember`
--
DROP TABLE IF EXISTS `tbl_Pistol_MedalGroupMember`;
CREATE TABLE `tbl_Pistol_MedalGroupMember` (
`Id` bigint(20) NOT NULL auto_increment,
`MedalGroupId` bigint(20) default NULL,
`ShotClassId` bigint(20) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`ShotClassId`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_MedalGroupMember`
--
LOCK TABLES `tbl_Pistol_MedalGroupMember` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_MedalGroupMember` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_MedalGroupMember` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),(10,2,10),(11,2,11),(12,2,12),(13,3,13),(14,3,14),(15,3,15),(16,4,16),(17,4,17),(18,4,18);
/*!40000 ALTER TABLE `tbl_Pistol_MedalGroupMember` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_Patrol`
--
DROP TABLE IF EXISTS `tbl_Pistol_Patrol`;
CREATE TABLE `tbl_Pistol_Patrol` (
`Id` bigint(20) NOT NULL auto_increment,
`CompetitionDayId` bigint(20) default NULL,
`SortOrder` smallint(6) NOT NULL,
`Description` varchar(100) default NULL,
`StartTime` datetime default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`CompetitionDayId`,`SortOrder`)
) ENGINE=MyISAM AUTO_INCREMENT=367 DEFAULT CHARSET=latin1;
ALTER TABLE `tbl_Pistol_Patrol` ADD COLUMN `Hidden` TINYINT(1) NULL DEFAULT false AFTER `StartTime` ;
--
-- Dumping data for table `tbl_Pistol_Patrol`
--
LOCK TABLES `tbl_Pistol_Patrol` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_Patrol` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_Patrol` VALUES (165,15,1,'Grov','2010-01-07 09:00:00'),(166,15,2,'Grov','2010-01-07 09:15:00'),(167,15,3,'Grov','2010-01-07 09:30:00'),(168,15,4,'Grov','2010-01-07 09:45:00'),(169,15,5,'Grov','2010-01-07 10:00:00'),(170,15,6,'Grov','2010-01-07 10:15:00'),(171,15,7,'Grov','2010-01-07 10:30:00'),(172,15,8,'Grov','2010-01-07 10:45:00'),(173,15,9,'Fin','2010-01-07 11:00:00'),(174,15,10,'Fin','2010-01-07 11:15:00'),(175,15,11,'Fin','2010-01-07 11:30:00'),(176,15,12,'Fin','2010-01-07 11:45:00'),(177,15,13,'Fin','2010-01-07 12:00:00'),(178,15,14,'Fin','2010-01-07 12:15:00'),(179,15,15,'Fin','2010-01-07 12:30:00'),(180,15,16,'Fin','2010-01-07 12:45:00'),(181,15,17,'Fin','2010-01-07 13:00:00'),(182,15,18,'Fin','2010-01-07 13:15:00'),(183,15,19,'Fin','2010-01-07 13:30:00'),(184,15,20,'Fin','2010-01-07 13:45:00'),(185,15,21,'Bland','2010-01-07 14:00:00'),(186,15,22,'Bland','2010-01-07 14:15:00'),(187,15,23,'Bland','2010-01-07 14:30:00'),(188,15,24,'Bland','2010-01-07 14:45:00'),(189,15,25,'Bland','2010-01-07 15:00:00'),(190,15,26,'Bland','2010-01-07 15:15:00'),(191,15,27,'Bland','2010-01-07 15:30:00'),(192,15,28,'Bland','2010-01-07 15:45:00'),(193,15,29,'Bland','2010-01-07 16:00:00'),(194,15,30,'Bland','2010-01-07 16:15:00'),(195,15,31,'Bland','2010-01-07 16:30:00'),(196,15,32,'Bland','2010-01-07 16:45:00'),(197,15,33,'Bland','2010-01-07 17:00:00'),(198,15,34,'Bland','2010-01-07 17:15:00'),(199,15,35,'Bland','2010-01-07 17:30:00'),(200,15,36,'Bland','2010-01-07 17:45:00'),(201,15,37,'Bland','2010-01-07 18:00:00'),(202,15,38,'Bland','2010-01-07 18:15:00'),(203,15,39,'Bland','2010-01-07 18:30:00'),(204,15,40,'Bland','2010-01-07 18:45:00'),(205,15,41,'fin','2010-01-07 19:00:00'),(206,15,42,'fin','2010-01-07 19:15:00'),(207,15,43,'fin','2010-01-07 19:30:00'),(208,15,44,'fin','2010-01-07 19:45:00'),(209,15,45,'fin','2010-01-07 20:00:00'),(210,15,46,'fin','2010-01-07 20:15:00'),(211,15,47,'fin','2010-01-07 20:30:00'),(212,15,48,'fin','2010-01-07 20:45:00'),(213,15,49,'fin','2010-01-07 21:00:00'),(214,15,50,'fin','2010-01-07 21:15:00'),(215,15,51,'fin','2010-01-07 21:30:00'),(216,15,52,'fin','2010-01-07 21:45:00'),(217,15,53,'fin','2010-01-07 22:00:00'),(218,15,54,'fin','2010-01-07 22:15:00'),(219,15,55,'fin','2010-01-07 22:30:00'),(220,15,56,'fin','2010-01-07 22:45:00'),(221,15,57,'fin','2010-01-07 23:00:00'),(222,15,58,'fin','2010-01-07 23:15:00'),(223,15,59,'fin','2010-01-07 23:30:00'),(224,15,60,'fin','2010-01-07 23:45:00'),(225,15,61,'fin','2010-01-08 00:00:00'),(226,15,62,'fin','2010-01-08 00:15:00'),(227,15,63,'fin','2010-01-08 00:30:00'),(228,15,64,'fin','2010-01-08 00:45:00'),(229,15,65,'fin','2010-01-08 01:00:00'),(230,16,1,'fin','0000-00-00 00:00:00'),(231,16,2,'fin','0000-00-00 00:00:00'),(232,16,3,'fin','0000-00-00 00:00:00'),(233,16,4,'fin','0000-00-00 00:00:00'),(234,16,5,'fin','0000-00-00 00:00:00'),(235,16,6,'fin','0000-00-00 00:00:00'),(236,16,7,'fin','0000-00-00 00:00:00'),(237,16,8,'fin','0000-00-00 00:00:00'),(238,16,9,'fin','0000-00-00 00:00:00'),(239,16,10,'fin','0000-00-00 00:00:00'),(240,16,11,'fin','0000-00-00 00:00:00'),(241,16,12,'fin','0000-00-00 00:00:00'),(242,16,13,'fin','0000-00-00 00:00:00'),(243,16,14,'fin','0000-00-00 00:00:00'),(244,16,15,'fin','0000-00-00 00:00:00'),(245,16,16,'fin','0000-00-00 00:00:00'),(246,16,17,'fin','0000-00-00 00:00:00'),(247,16,18,'fin','0000-00-00 00:00:00'),(248,17,1,'','0000-00-00 00:00:00'),(249,17,2,'','0000-00-00 00:00:00'),(250,17,3,'','0000-00-00 00:00:00'),(251,17,4,'','0000-00-00 00:00:00'),(252,17,5,'','0000-00-00 00:00:00'),(253,17,6,'','0000-00-00 00:00:00'),(254,17,7,'','0000-00-00 00:00:00'),(255,17,8,'','0000-00-00 00:00:00'),(256,17,9,'','0000-00-00 00:00:00'),(257,17,10,'','0000-00-00 00:00:00'),(258,17,11,'','0000-00-00 00:00:00'),(259,17,12,'','0000-00-00 00:00:00'),(260,17,13,'','0000-00-00 00:00:00'),(261,17,14,'','0000-00-00 00:00:00'),(262,17,15,'fin','0000-00-00 00:00:00'),(263,17,16,'fin','0000-00-00 00:00:00'),(264,17,17,'fin','0000-00-00 00:00:00'),(265,17,18,'fin','0000-00-00 00:00:00'),(266,17,19,'fin','0000-00-00 00:00:00'),(267,18,1,'fin','2010-01-09 08:00:00'),(268,18,2,'fin','2010-01-09 08:10:00'),(269,18,3,'fin','2010-01-09 08:20:00'),(270,18,4,'fin','2010-01-09 08:30:00'),(271,18,5,'fin','2010-01-09 08:40:00'),(272,18,6,'fin','2010-01-09 08:50:00'),(273,18,7,'fin','2010-01-09 09:00:00'),(274,18,8,'fin','2010-01-09 09:10:00'),(275,18,9,'fin','2010-01-09 09:20:00'),(276,18,10,'fin','2010-01-09 09:30:00'),(277,18,11,'fin','2010-01-09 09:40:00'),(278,18,12,'fin','2010-01-09 09:50:00'),(279,18,13,'fin','2010-01-09 10:00:00'),(280,18,14,'fin','2010-01-09 10:10:00'),(281,18,15,'fin','2010-01-09 10:20:00'),(282,19,1,'fin','2010-01-10 09:00:00'),(283,19,2,'fin','2010-01-10 09:15:00'),(284,19,3,'fin','2010-01-10 09:30:00'),(285,19,4,'fin','2010-01-10 09:45:00'),(286,19,5,'fin','2010-01-10 10:00:00'),(287,19,6,'fin','2010-01-10 10:15:00'),(288,19,7,'fin','2010-01-10 10:30:00'),(289,19,8,'fin','2010-01-10 10:45:00'),(290,19,9,'fin','2010-01-10 11:00:00'),(291,19,10,'fin','2010-01-10 11:15:00'),(292,19,11,'grov','2010-01-10 11:30:00'),(293,19,12,'grov','2010-01-10 11:45:00'),(294,19,13,'grov','2010-01-10 12:00:00'),(295,19,14,'grov','2010-01-10 12:15:00'),(296,19,15,'grov','2010-01-10 12:30:00'),(297,19,16,'grov','2010-01-10 12:45:00'),(298,19,17,'grov','2010-01-10 13:00:00'),(299,19,18,'grov','2010-01-10 13:15:00'),(300,19,19,'grov','2010-01-10 13:30:00'),(301,19,20,'grov','2010-01-10 13:45:00'),(302,20,1,'Allt tillåtet','2010-05-01 09:00:00'),(303,20,2,'Allt tillåtet','2010-05-01 09:15:00'),(304,20,3,'Allt tillåtet','2010-05-01 09:30:00'),(305,20,4,'Allt tillåtet','2010-05-01 09:45:00'),(306,20,5,'Allt tillåtet','2010-05-01 10:00:00'),(307,20,6,'Allt tillåtet','2010-05-01 10:15:00'),(308,20,7,'Allt tillåtet','2010-05-01 10:30:00'),(309,20,8,'Allt tillåtet','2010-05-01 10:45:00'),(310,21,1,'C','2010-02-20 08:30:00'),(311,21,2,'C','2010-02-20 08:40:00'),(312,21,3,'C','2010-02-20 08:50:00'),(313,21,4,'C','2010-02-20 09:00:00'),(314,21,5,'B','2010-02-20 09:10:00'),(315,21,6,'AR','2010-02-20 09:20:00'),(316,21,7,'AR','2010-02-20 09:30:00'),(317,21,8,'AR','2010-02-20 09:40:00'),(318,21,9,'C','2010-02-20 09:50:00'),(319,21,10,'C','2010-02-20 10:00:00'),(320,21,11,'C','2010-02-20 10:10:00'),(321,21,12,'C','2010-02-20 10:20:00'),(322,21,13,'B','2010-02-20 10:30:00'),(323,21,14,'AR','2010-02-20 10:40:00'),(324,21,15,'AR','2010-02-20 10:50:00'),(325,21,16,'AR','2010-02-20 11:00:00'),(326,21,17,'AR','2010-02-20 11:10:00'),(327,22,1,'AR','2101-03-30 08:00:00'),(328,22,2,'AR','2101-03-30 08:08:00'),(329,22,3,'AR','2101-03-30 08:16:00'),(330,22,4,'AR','2101-03-30 08:24:00'),(331,22,5,'AR','2101-03-30 08:32:00'),(332,22,6,'CB','2101-03-30 08:40:00'),(333,22,7,'CB','2101-03-30 08:48:00'),(334,22,8,'CB','2101-03-30 08:56:00'),(335,22,9,'CB','2101-03-30 09:04:00'),(336,22,10,'CB','2101-03-30 09:12:00'),(337,23,1,'Fin','2010-03-17 10:00:00'),(338,23,2,'Fin','2010-03-17 10:15:00'),(339,23,3,'Fin','2010-03-17 10:30:00'),(340,23,4,'Fin','2010-03-17 10:45:00'),(341,23,5,'Fin','2010-03-17 11:00:00'),(342,23,6,'Grov','2010-03-17 11:15:00'),(343,23,7,'Grov','2010-03-17 11:30:00'),(344,23,8,'Fin','2010-03-17 11:45:00'),(345,23,9,'Fin','2010-03-17 12:00:00'),(346,23,10,'Fin','2010-03-17 12:15:00'),(347,23,11,'Fin','2010-03-17 12:30:00'),(348,23,12,'Grov','2010-03-17 12:45:00'),(349,23,13,'Grov','2010-03-17 13:00:00'),(350,23,14,'Grov','2010-03-17 13:15:00'),(351,25,1,'CB','2010-06-23 16:00:00'),(352,25,2,'CB','2010-06-23 16:10:00'),(353,25,3,'CB','2010-06-23 16:20:00'),(354,25,4,'CB','2010-06-23 16:30:00'),(355,25,5,'AR','2010-06-23 16:40:00'),(356,25,6,'AR','2010-06-23 16:50:00'),(357,25,7,'CB','2010-06-23 17:00:00'),(358,25,8,'CB','2010-06-23 17:10:00'),(359,25,9,'CB','2010-06-23 17:20:00'),(360,25,10,'CB','2010-06-23 17:30:00'),(361,25,11,'AR','2010-06-23 17:40:00'),(362,25,12,'AR','2010-06-23 17:50:00'),(363,25,13,'BC','2010-06-23 18:00:00'),(364,25,14,'BC','2010-06-23 18:10:00'),(365,25,15,'BC','2010-06-23 18:20:00'),(366,25,16,'BC','2010-06-23 18:30:00');
/*!40000 ALTER TABLE `tbl_Pistol_Patrol` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_PatrolGun`
--
DROP TABLE IF EXISTS `tbl_Pistol_PatrolGun`;
CREATE TABLE `tbl_Pistol_PatrolGun` (
`Id` bigint(20) NOT NULL auto_increment,
`PatrolId` bigint(20) default NULL,
`GunClassId` bigint(20) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`PatrolId`,`GunClassId`)
) ENGINE=MyISAM AUTO_INCREMENT=714 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_PatrolGun`
--
LOCK TABLES `tbl_Pistol_PatrolGun` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_PatrolGun` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_PatrolGun` VALUES (272,165,1),(273,165,4),(274,166,1),(275,166,4),(276,167,1),(277,167,4),(278,168,1),(279,168,4),(280,169,1),(281,169,4),(282,170,1),(283,170,4),(284,171,1),(285,171,4),(286,172,1),(287,172,4),(288,173,2),(289,173,3),(290,174,2),(291,174,3),(292,175,2),(293,175,3),(294,176,2),(295,176,3),(296,177,2),(297,177,3),(298,178,2),(299,178,3),(300,179,2),(301,179,3),(302,180,2),(303,180,3),(304,181,2),(305,181,3),(306,182,2),(307,182,3),(308,183,2),(309,183,3),(310,184,2),(311,184,3),(312,185,1),(313,185,2),(314,185,3),(315,185,4),(316,185,5),(317,186,1),(318,186,2),(319,186,3),(320,186,4),(321,186,5),(322,187,1),(323,187,2),(324,187,3),(325,187,4),(326,187,5),(327,188,1),(328,188,2),(329,188,3),(330,188,4),(331,188,5),(332,189,1),(333,189,2),(334,189,3),(335,189,4),(336,189,5),(337,190,1),(338,190,2),(339,190,3),(340,190,4),(341,190,5),(342,191,1),(343,191,2),(344,191,3),(345,191,4),(346,191,5),(347,192,1),(348,192,2),(349,192,3),(350,192,4),(351,192,5),(352,193,1),(353,193,2),(354,193,3),(355,193,4),(356,193,5),(357,194,1),(358,194,2),(359,194,3),(360,194,4),(361,194,5),(362,195,1),(363,195,2),(364,195,3),(365,195,4),(366,195,5),(367,196,1),(368,196,2),(369,196,3),(370,196,4),(371,196,5),(372,197,1),(373,197,2),(374,197,3),(375,197,4),(376,197,5),(377,198,1),(378,198,2),(379,198,3),(380,198,4),(381,198,5),(382,199,1),(383,199,2),(384,199,3),(385,199,4),(386,199,5),(387,200,1),(388,200,2),(389,200,3),(390,200,4),(391,200,5),(392,201,1),(393,201,2),(394,201,3),(395,201,4),(396,201,5),(397,202,1),(398,202,2),(399,202,3),(400,202,4),(401,202,5),(402,203,1),(403,203,2),(404,203,3),(405,203,4),(406,203,5),(407,204,1),(408,204,2),(409,204,3),(410,204,4),(411,204,5),(412,205,2),(413,205,3),(414,206,2),(415,206,3),(416,207,2),(417,207,3),(418,208,2),(419,208,3),(420,209,2),(421,209,3),(422,210,2),(423,210,3),(424,211,2),(425,211,3),(426,212,2),(427,212,3),(428,213,2),(429,213,3),(430,214,2),(431,214,3),(432,215,2),(433,215,3),(434,216,2),(435,216,3),(436,217,2),(437,217,3),(438,218,2),(439,218,3),(440,219,2),(441,219,3),(442,220,2),(443,220,3),(444,221,2),(445,221,3),(446,222,2),(447,222,3),(448,223,2),(449,223,3),(450,224,2),(451,224,3),(452,225,2),(453,225,3),(454,226,2),(455,226,3),(456,227,2),(457,227,3),(458,228,2),(459,228,3),(460,229,2),(461,229,3),(462,230,3),(463,231,3),(464,232,3),(465,233,3),(466,234,3),(467,235,1),(468,235,4),(469,236,1),(470,236,4),(471,237,1),(472,237,4),(473,238,3),(474,239,3),(475,240,3),(477,241,2),(478,242,3),(479,243,3),(480,244,3),(481,245,3),(482,246,3),(483,247,3),(484,248,3),(485,249,3),(486,250,3),(487,251,3),(488,252,3),(489,253,1),(490,253,4),(491,254,1),(492,254,4),(493,255,1),(494,255,4),(495,256,1),(496,256,4),(497,257,1),(498,257,4),(499,258,2),(500,259,2),(501,260,5),(502,261,5),(503,262,2),(504,262,3),(505,263,2),(506,263,3),(507,264,2),(508,264,3),(509,265,2),(510,265,3),(511,266,2),(512,266,3),(513,267,2),(514,267,3),(515,268,2),(516,268,3),(517,269,2),(518,269,3),(519,270,2),(520,270,3),(521,271,2),(522,271,3),(523,272,1),(524,272,4),(525,273,1),(526,273,4),(527,274,1),(528,274,4),(529,275,1),(530,275,4),(531,276,1),(532,276,4),(533,277,5),(534,278,5),(535,279,1),(536,279,2),(537,279,3),(538,279,4),(539,279,5),(540,280,1),(541,280,2),(542,280,3),(543,280,4),(544,280,5),(545,281,1),(546,281,2),(547,281,3),(548,281,4),(549,281,5),(550,282,3),(551,283,3),(552,284,3),(553,285,3),(554,286,3),(555,287,3),(556,288,3),(557,289,3),(558,290,3),(559,291,3),(560,292,1),(561,292,4),(562,293,1),(563,293,4),(564,294,1),(565,294,4),(566,295,1),(567,295,4),(568,296,1),(569,296,4),(570,297,1),(571,297,4),(572,298,1),(573,298,4),(574,299,1),(575,299,4),(576,300,1),(577,300,4),(578,301,1),(579,301,4),(580,302,1),(581,302,2),(582,302,3),(583,302,4),(584,302,5),(585,303,1),(586,303,2),(587,303,3),(588,303,4),(589,303,5),(590,304,1),(591,304,2),(592,304,3),(593,304,4),(594,304,5),(595,305,1),(596,305,2),(597,305,3),(598,305,4),(599,305,5),(600,306,1),(601,306,2),(602,306,3),(603,306,4),(604,306,5),(605,307,1),(606,307,2),(607,307,3),(608,307,4),(609,307,5),(610,308,1),(611,308,2),(612,308,3),(613,308,4),(614,308,5),(615,309,1),(616,309,2),(617,309,3),(618,309,4),(619,309,5),(620,310,3),(621,311,3),(622,312,3),(623,313,3),(625,314,2),(626,315,1),(627,315,4),(628,316,1),(629,316,4),(630,317,1),(631,317,4),(632,318,3),(633,319,3),(634,320,3),(635,321,3),(636,322,2),(637,323,1),(638,323,4),(639,324,1),(640,324,4),(641,325,1),(642,325,4),(643,326,1),(644,326,4),(645,327,1),(646,327,4),(647,328,1),(648,328,4),(649,329,1),(650,329,4),(651,330,1),(652,330,4),(653,331,1),(654,331,4),(655,332,2),(656,332,3),(657,333,2),(658,333,3),(659,334,2),(660,334,3),(661,335,2),(662,335,3),(663,336,2),(664,336,3),(665,337,3),(666,338,3),(667,339,3),(668,340,3),(669,341,3),(670,342,1),(671,342,4),(672,343,1),(673,343,4),(674,344,3),(675,345,3),(676,346,3),(677,347,3),(678,348,1),(679,348,4),(680,349,1),(681,349,4),(682,350,1),(683,350,4),(684,351,2),(685,351,3),(686,352,2),(687,352,3),(688,353,2),(689,353,3),(690,354,2),(691,354,3),(692,355,1),(693,356,1),(694,357,2),(695,357,3),(696,358,2),(697,358,3),(698,359,2),(699,359,3),(700,360,2),(701,360,3),(702,361,1),(703,361,4),(704,362,1),(705,362,4),(706,363,2),(707,363,3),(708,364,2),(709,364,3),(710,365,2),(711,365,3),(712,366,2),(713,366,3);
/*!40000 ALTER TABLE `tbl_Pistol_PatrolGun` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_Schedule`
--
DROP TABLE IF EXISTS `tbl_Pistol_Schedule`;
CREATE TABLE `tbl_Pistol_Schedule` (
`Id` bigint(20) NOT NULL auto_increment,
`CompetitionDayId` bigint(20) default NULL,
`StartTime` datetime NOT NULL,
`PatrolId` bigint(20) default NULL,
`Station` smallint(6) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`CompetitionDayId`,`PatrolId`,`Station`),
KEY `i2` (`PatrolId`,`StartTime`)
) ENGINE=MyISAM AUTO_INCREMENT=2893 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_Schedule`
--
LOCK TABLES `tbl_Pistol_Schedule` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_Schedule` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_Schedule` VALUES (1552,15,'2010-01-07 10:45:00',172,1),(1551,15,'2010-01-07 10:30:00',171,1),(1550,15,'2010-01-07 10:15:00',170,1),(1549,15,'2010-01-07 10:00:00',169,1),(1548,15,'2010-01-07 09:45:00',168,1),(1547,15,'2010-01-07 09:30:00',167,1),(1546,15,'2010-01-07 09:15:00',166,1),(1545,15,'2010-01-07 09:00:00',165,1),(1553,15,'2010-01-07 11:00:00',173,1),(1554,15,'2010-01-07 11:15:00',174,1),(1555,15,'2010-01-07 11:30:00',175,1),(1556,15,'2010-01-07 11:45:00',176,1),(1557,15,'2010-01-07 12:00:00',177,1),(1558,15,'2010-01-07 12:15:00',178,1),(1559,15,'2010-01-07 12:30:00',179,1),(1560,15,'2010-01-07 12:45:00',180,1),(1561,15,'2010-01-07 13:00:00',181,1),(1562,15,'2010-01-07 13:15:00',182,1),(1563,15,'2010-01-07 13:30:00',183,1),(1564,15,'2010-01-07 13:45:00',184,1),(1565,15,'2010-01-07 14:00:00',185,1),(1566,15,'2010-01-07 14:15:00',186,1),(1567,15,'2010-01-07 14:30:00',187,1),(1568,15,'2010-01-07 14:45:00',188,1),(1569,15,'2010-01-07 15:00:00',189,1),(1570,15,'2010-01-07 15:15:00',190,1),(1571,15,'2010-01-07 15:30:00',191,1),(1572,15,'2010-01-07 15:45:00',192,1),(1573,15,'2010-01-07 16:00:00',193,1),(1574,15,'2010-01-07 16:15:00',194,1),(1575,15,'2010-01-07 16:30:00',195,1),(1576,15,'2010-01-07 16:45:00',196,1),(1577,15,'2010-01-07 17:00:00',197,1),(1578,15,'2010-01-07 17:15:00',198,1),(1579,15,'2010-01-07 17:30:00',199,1),(1580,15,'2010-01-07 17:45:00',200,1),(1581,15,'2010-01-07 18:00:00',201,1),(1582,15,'2010-01-07 18:15:00',202,1),(1583,15,'2010-01-07 18:30:00',203,1),(1584,15,'2010-01-07 18:45:00',204,1),(1585,15,'2010-01-07 19:00:00',205,1),(1586,15,'2010-01-07 19:15:00',206,1),(1587,15,'2010-01-07 19:30:00',207,1),(1588,15,'2010-01-07 19:45:00',208,1),(1589,15,'2010-01-07 20:00:00',209,1),(1590,15,'2010-01-07 20:15:00',210,1),(1591,15,'2010-01-07 20:30:00',211,1),(1592,15,'2010-01-07 20:45:00',212,1),(1593,15,'2010-01-07 21:00:00',213,1),(1594,15,'2010-01-07 21:15:00',214,1),(1595,15,'2010-01-07 21:30:00',215,1),(1596,15,'2010-01-07 21:45:00',216,1),(1597,15,'2010-01-07 22:00:00',217,1),(1598,15,'2010-01-07 22:15:00',218,1),(1599,15,'2010-01-07 22:30:00',219,1),(1600,15,'2010-01-07 22:45:00',220,1),(1601,15,'2010-01-07 23:00:00',221,1),(1602,15,'2010-01-07 23:15:00',222,1),(1603,15,'2010-01-07 23:30:00',223,1),(1604,15,'2010-01-07 23:45:00',224,1),(1605,15,'2010-01-08 00:00:00',225,1),(1606,15,'2010-01-08 00:15:00',226,1),(1607,15,'2010-01-08 00:30:00',227,1),(1608,15,'2010-01-08 00:45:00',228,1),(1609,15,'2010-01-08 01:00:00',229,1),(1610,15,'2010-01-07 09:15:00',165,2),(1611,15,'2010-01-07 09:30:00',166,2),(1612,15,'2010-01-07 09:45:00',167,2),(1613,15,'2010-01-07 10:00:00',168,2),(1614,15,'2010-01-07 10:15:00',169,2),(1615,15,'2010-01-07 10:30:00',170,2),(1616,15,'2010-01-07 10:45:00',171,2),(1617,15,'2010-01-07 11:00:00',172,2),(1618,15,'2010-01-07 11:15:00',173,2),(1619,15,'2010-01-07 11:30:00',174,2),(1620,15,'2010-01-07 11:45:00',175,2),(1621,15,'2010-01-07 12:00:00',176,2),(1622,15,'2010-01-07 12:15:00',177,2),(1623,15,'2010-01-07 12:30:00',178,2),(1624,15,'2010-01-07 12:45:00',179,2),(1625,15,'2010-01-07 13:00:00',180,2),(1626,15,'2010-01-07 13:15:00',181,2),(1627,15,'2010-01-07 13:30:00',182,2),(1628,15,'2010-01-07 13:45:00',183,2),(1629,15,'2010-01-07 14:00:00',184,2),(1630,15,'2010-01-07 14:15:00',185,2),(1631,15,'2010-01-07 14:30:00',186,2),(1632,15,'2010-01-07 14:45:00',187,2),(1633,15,'2010-01-07 15:00:00',188,2),(1634,15,'2010-01-07 15:15:00',189,2),(1635,15,'2010-01-07 15:30:00',190,2),(1636,15,'2010-01-07 15:45:00',191,2),(1637,15,'2010-01-07 16:00:00',192,2),(1638,15,'2010-01-07 16:15:00',193,2),(1639,15,'2010-01-07 16:30:00',194,2),(1640,15,'2010-01-07 16:45:00',195,2),(1641,15,'2010-01-07 17:00:00',196,2),(1642,15,'2010-01-07 17:15:00',197,2),(1643,15,'2010-01-07 17:30:00',198,2),(1644,15,'2010-01-07 17:45:00',199,2),(1645,15,'2010-01-07 18:00:00',200,2),(1646,15,'2010-01-07 18:15:00',201,2),(1647,15,'2010-01-07 18:30:00',202,2),(1648,15,'2010-01-07 18:45:00',203,2),(1649,15,'2010-01-07 19:00:00',204,2),(1650,15,'2010-01-07 19:15:00',205,2),(1651,15,'2010-01-07 19:30:00',206,2),(1652,15,'2010-01-07 19:45:00',207,2),(1653,15,'2010-01-07 20:00:00',208,2),(1654,15,'2010-01-07 20:15:00',209,2),(1655,15,'2010-01-07 20:30:00',210,2),(1656,15,'2010-01-07 20:45:00',211,2),(1657,15,'2010-01-07 21:00:00',212,2),(1658,15,'2010-01-07 21:15:00',213,2),(1659,15,'2010-01-07 21:30:00',214,2),(1660,15,'2010-01-07 21:45:00',215,2),(1661,15,'2010-01-07 22:00:00',216,2),(1662,15,'2010-01-07 22:15:00',217,2),(1663,15,'2010-01-07 22:30:00',218,2),(1664,15,'2010-01-07 22:45:00',219,2),(1665,15,'2010-01-07 23:00:00',220,2),(1666,15,'2010-01-07 23:15:00',221,2),(1667,15,'2010-01-07 23:30:00',222,2),(1668,15,'2010-01-07 23:45:00',223,2),(1669,15,'2010-01-08 00:00:00',224,2),(1670,15,'2010-01-08 00:15:00',225,2),(1671,15,'2010-01-08 00:30:00',226,2),(1672,15,'2010-01-08 00:45:00',227,2),(1673,15,'2010-01-08 01:00:00',228,2),(1674,15,'2010-01-08 01:15:00',229,2),(1675,15,'2010-01-07 09:30:00',165,3),(1676,15,'2010-01-07 09:45:00',166,3),(1677,15,'2010-01-07 10:00:00',167,3),(1678,15,'2010-01-07 10:15:00',168,3),(1679,15,'2010-01-07 10:30:00',169,3),(1680,15,'2010-01-07 10:45:00',170,3),(1681,15,'2010-01-07 11:00:00',171,3),(1682,15,'2010-01-07 11:15:00',172,3),(1683,15,'2010-01-07 11:30:00',173,3),(1684,15,'2010-01-07 11:45:00',174,3),(1685,15,'2010-01-07 12:00:00',175,3),(1686,15,'2010-01-07 12:15:00',176,3),(1687,15,'2010-01-07 12:30:00',177,3),(1688,15,'2010-01-07 12:45:00',178,3),(1689,15,'2010-01-07 13:00:00',179,3),(1690,15,'2010-01-07 13:15:00',180,3),(1691,15,'2010-01-07 13:30:00',181,3),(1692,15,'2010-01-07 13:45:00',182,3),(1693,15,'2010-01-07 14:00:00',183,3),(1694,15,'2010-01-07 14:15:00',184,3),(1695,15,'2010-01-07 14:30:00',185,3),(1696,15,'2010-01-07 14:45:00',186,3),(1697,15,'2010-01-07 15:00:00',187,3),(1698,15,'2010-01-07 15:15:00',188,3),(1699,15,'2010-01-07 15:30:00',189,3),(1700,15,'2010-01-07 15:45:00',190,3),(1701,15,'2010-01-07 16:00:00',191,3),(1702,15,'2010-01-07 16:15:00',192,3),(1703,15,'2010-01-07 16:30:00',193,3),(1704,15,'2010-01-07 16:45:00',194,3),(1705,15,'2010-01-07 17:00:00',195,3),(1706,15,'2010-01-07 17:15:00',196,3),(1707,15,'2010-01-07 17:30:00',197,3),(1708,15,'2010-01-07 17:45:00',198,3),(1709,15,'2010-01-07 18:00:00',199,3),(1710,15,'2010-01-07 18:15:00',200,3),(1711,15,'2010-01-07 18:30:00',201,3),(1712,15,'2010-01-07 18:45:00',202,3),(1713,15,'2010-01-07 19:00:00',203,3),(1714,15,'2010-01-07 19:15:00',204,3),(1715,15,'2010-01-07 19:30:00',205,3),(1716,15,'2010-01-07 19:45:00',206,3),(1717,15,'2010-01-07 20:00:00',207,3),(1718,15,'2010-01-07 20:15:00',208,3),(1719,15,'2010-01-07 20:30:00',209,3),(1720,15,'2010-01-07 20:45:00',210,3),(1721,15,'2010-01-07 21:00:00',211,3),(1722,15,'2010-01-07 21:15:00',212,3),(1723,15,'2010-01-07 21:30:00',213,3),(1724,15,'2010-01-07 21:45:00',214,3),(1725,15,'2010-01-07 22:00:00',215,3),(1726,15,'2010-01-07 22:15:00',216,3),(1727,15,'2010-01-07 22:30:00',217,3),(1728,15,'2010-01-07 22:45:00',218,3),(1729,15,'2010-01-07 23:00:00',219,3),(1730,15,'2010-01-07 23:15:00',220,3),(1731,15,'2010-01-07 23:30:00',221,3),(1732,15,'2010-01-07 23:45:00',222,3),(1733,15,'2010-01-08 00:00:00',223,3),(1734,15,'2010-01-08 00:15:00',224,3),(1735,15,'2010-01-08 00:30:00',225,3),(1736,15,'2010-01-08 00:45:00',226,3),(1737,15,'2010-01-08 01:00:00',227,3),(1738,15,'2010-01-08 01:15:00',228,3),(1739,15,'2010-01-08 01:30:00',229,3),(1740,15,'2010-01-07 09:45:00',165,4),(1741,15,'2010-01-07 10:00:00',166,4),(1742,15,'2010-01-07 10:15:00',167,4),(1743,15,'2010-01-07 10:30:00',168,4),(1744,15,'2010-01-07 10:45:00',169,4),(1745,15,'2010-01-07 11:00:00',170,4),(1746,15,'2010-01-07 11:15:00',171,4),(1747,15,'2010-01-07 11:30:00',172,4),(1748,15,'2010-01-07 11:45:00',173,4),(1749,15,'2010-01-07 12:00:00',174,4),(1750,15,'2010-01-07 12:15:00',175,4),(1751,15,'2010-01-07 12:30:00',176,4),(1752,15,'2010-01-07 12:45:00',177,4),(1753,15,'2010-01-07 13:00:00',178,4),(1754,15,'2010-01-07 13:15:00',179,4),(1755,15,'2010-01-07 13:30:00',180,4),(1756,15,'2010-01-07 13:45:00',181,4),(1757,15,'2010-01-07 14:00:00',182,4),(1758,15,'2010-01-07 14:15:00',183,4),(1759,15,'2010-01-07 14:30:00',184,4),(1760,15,'2010-01-07 14:45:00',185,4),(1761,15,'2010-01-07 15:00:00',186,4),(1762,15,'2010-01-07 15:15:00',187,4),(1763,15,'2010-01-07 15:30:00',188,4),(1764,15,'2010-01-07 15:45:00',189,4),(1765,15,'2010-01-07 16:00:00',190,4),(1766,15,'2010-01-07 16:15:00',191,4),(1767,15,'2010-01-07 16:30:00',192,4),(1768,15,'2010-01-07 16:45:00',193,4),(1769,15,'2010-01-07 17:00:00',194,4),(1770,15,'2010-01-07 17:15:00',195,4),(1771,15,'2010-01-07 17:30:00',196,4),(1772,15,'2010-01-07 17:45:00',197,4),(1773,15,'2010-01-07 18:00:00',198,4),(1774,15,'2010-01-07 18:15:00',199,4),(1775,15,'2010-01-07 18:30:00',200,4),(1776,15,'2010-01-07 18:45:00',201,4),(1777,15,'2010-01-07 19:00:00',202,4),(1778,15,'2010-01-07 19:15:00',203,4),(1779,15,'2010-01-07 19:30:00',204,4),(1780,15,'2010-01-07 19:45:00',205,4),(1781,15,'2010-01-07 20:00:00',206,4),(1782,15,'2010-01-07 20:15:00',207,4),(1783,15,'2010-01-07 20:30:00',208,4),(1784,15,'2010-01-07 20:45:00',209,4),(1785,15,'2010-01-07 21:00:00',210,4),(1786,15,'2010-01-07 21:15:00',211,4),(1787,15,'2010-01-07 21:30:00',212,4),(1788,15,'2010-01-07 21:45:00',213,4),(1789,15,'2010-01-07 22:00:00',214,4),(1790,15,'2010-01-07 22:15:00',215,4),(1791,15,'2010-01-07 22:30:00',216,4),(1792,15,'2010-01-07 22:45:00',217,4),(1793,15,'2010-01-07 23:00:00',218,4),(1794,15,'2010-01-07 23:15:00',219,4),(1795,15,'2010-01-07 23:30:00',220,4),(1796,15,'2010-01-07 23:45:00',221,4),(1797,15,'2010-01-08 00:00:00',222,4),(1798,15,'2010-01-08 00:15:00',223,4),(1799,15,'2010-01-08 00:30:00',224,4),(1800,15,'2010-01-08 00:45:00',225,4),(1801,15,'2010-01-08 01:00:00',226,4),(1802,15,'2010-01-08 01:15:00',227,4),(1803,15,'2010-01-08 01:30:00',228,4),(1804,15,'2010-01-08 01:45:00',229,4),(1805,15,'2010-01-07 10:00:00',165,5),(1806,15,'2010-01-07 10:15:00',166,5),(1807,15,'2010-01-07 10:30:00',167,5),(1808,15,'2010-01-07 10:45:00',168,5),(1809,15,'2010-01-07 11:00:00',169,5),(1810,15,'2010-01-07 11:15:00',170,5),(1811,15,'2010-01-07 11:30:00',171,5),(1812,15,'2010-01-07 11:45:00',172,5),(1813,15,'2010-01-07 12:00:00',173,5),(1814,15,'2010-01-07 12:15:00',174,5),(1815,15,'2010-01-07 12:30:00',175,5),(1816,15,'2010-01-07 12:45:00',176,5),(1817,15,'2010-01-07 13:00:00',177,5),(1818,15,'2010-01-07 13:15:00',178,5),(1819,15,'2010-01-07 13:30:00',179,5),(1820,15,'2010-01-07 13:45:00',180,5),(1821,15,'2010-01-07 14:00:00',181,5),(1822,15,'2010-01-07 14:15:00',182,5),(1823,15,'2010-01-07 14:30:00',183,5),(1824,15,'2010-01-07 14:45:00',184,5),(1825,15,'2010-01-07 15:00:00',185,5),(1826,15,'2010-01-07 15:15:00',186,5),(1827,15,'2010-01-07 15:30:00',187,5),(1828,15,'2010-01-07 15:45:00',188,5),(1829,15,'2010-01-07 16:00:00',189,5),(1830,15,'2010-01-07 16:15:00',190,5),
(1831,15,'2010-01-07 16:30:00',191,5),(1832,15,'2010-01-07 16:45:00',192,5),(1833,15,'2010-01-07 17:00:00',193,5),(1834,15,'2010-01-07 17:15:00',194,5),(1835,15,'2010-01-07 17:30:00',195,5),(1836,15,'2010-01-07 17:45:00',196,5),(1837,15,'2010-01-07 18:00:00',197,5),(1838,15,'2010-01-07 18:15:00',198,5),(1839,15,'2010-01-07 18:30:00',199,5),(1840,15,'2010-01-07 18:45:00',200,5),(1841,15,'2010-01-07 19:00:00',201,5),(1842,15,'2010-01-07 19:15:00',202,5),(1843,15,'2010-01-07 19:30:00',203,5),(1844,15,'2010-01-07 19:45:00',204,5),(1845,15,'2010-01-07 20:00:00',205,5),(1846,15,'2010-01-07 20:15:00',206,5),(1847,15,'2010-01-07 20:30:00',207,5),(1848,15,'2010-01-07 20:45:00',208,5),(1849,15,'2010-01-07 21:00:00',209,5),(1850,15,'2010-01-07 21:15:00',210,5),(1851,15,'2010-01-07 21:30:00',211,5),(1852,15,'2010-01-07 21:45:00',212,5),(1853,15,'2010-01-07 22:00:00',213,5),(1854,15,'2010-01-07 22:15:00',214,5),(1855,15,'2010-01-07 22:30:00',215,5),(1856,15,'2010-01-07 22:45:00',216,5),(1857,15,'2010-01-07 23:00:00',217,5),(1858,15,'2010-01-07 23:15:00',218,5),(1859,15,'2010-01-07 23:30:00',219,5),(1860,15,'2010-01-07 23:45:00',220,5),(1861,15,'2010-01-08 00:00:00',221,5),(1862,15,'2010-01-08 00:15:00',222,5),(1863,15,'2010-01-08 00:30:00',223,5),(1864,15,'2010-01-08 00:45:00',224,5),(1865,15,'2010-01-08 01:00:00',225,5),(1866,15,'2010-01-08 01:15:00',226,5),(1867,15,'2010-01-08 01:30:00',227,5),(1868,15,'2010-01-08 01:45:00',228,5),(1869,15,'2010-01-08 02:00:00',229,5),(1870,15,'2010-01-07 10:15:00',165,6),(1871,15,'2010-01-07 10:30:00',166,6),(1872,15,'2010-01-07 10:45:00',167,6),(1873,15,'2010-01-07 11:00:00',168,6),(1874,15,'2010-01-07 11:15:00',169,6),(1875,15,'2010-01-07 11:30:00',170,6),(1876,15,'2010-01-07 11:45:00',171,6),(1877,15,'2010-01-07 12:00:00',172,6),(1878,15,'2010-01-07 12:15:00',173,6),(1879,15,'2010-01-07 12:30:00',174,6),(1880,15,'2010-01-07 12:45:00',175,6),(1881,15,'2010-01-07 13:00:00',176,6),(1882,15,'2010-01-07 13:15:00',177,6),(1883,15,'2010-01-07 13:30:00',178,6),(1884,15,'2010-01-07 13:45:00',179,6),(1885,15,'2010-01-07 14:00:00',180,6),(1886,15,'2010-01-07 14:15:00',181,6),(1887,15,'2010-01-07 14:30:00',182,6),(1888,15,'2010-01-07 14:45:00',183,6),(1889,15,'2010-01-07 15:00:00',184,6),(1890,15,'2010-01-07 15:15:00',185,6),(1891,15,'2010-01-07 15:30:00',186,6),(1892,15,'2010-01-07 15:45:00',187,6),(1893,15,'2010-01-07 16:00:00',188,6),(1894,15,'2010-01-07 16:15:00',189,6),(1895,15,'2010-01-07 16:30:00',190,6),(1896,15,'2010-01-07 16:45:00',191,6),(1897,15,'2010-01-07 17:00:00',192,6),(1898,15,'2010-01-07 17:15:00',193,6),(1899,15,'2010-01-07 17:30:00',194,6),(1900,15,'2010-01-07 17:45:00',195,6),(1901,15,'2010-01-07 18:00:00',196,6),(1902,15,'2010-01-07 18:15:00',197,6),(1903,15,'2010-01-07 18:30:00',198,6),(1904,15,'2010-01-07 18:45:00',199,6),(1905,15,'2010-01-07 19:00:00',200,6),(1906,15,'2010-01-07 19:15:00',201,6),(1907,15,'2010-01-07 19:30:00',202,6),(1908,15,'2010-01-07 19:45:00',203,6),(1909,15,'2010-01-07 20:00:00',204,6),(1910,15,'2010-01-07 20:15:00',205,6),(1911,15,'2010-01-07 20:30:00',206,6),(1912,15,'2010-01-07 20:45:00',207,6),(1913,15,'2010-01-07 21:00:00',208,6),(1914,15,'2010-01-07 21:15:00',209,6),(1915,15,'2010-01-07 21:30:00',210,6),(1916,15,'2010-01-07 21:45:00',211,6),(1917,15,'2010-01-07 22:00:00',212,6),(1918,15,'2010-01-07 22:15:00',213,6),(1919,15,'2010-01-07 22:30:00',214,6),(1920,15,'2010-01-07 22:45:00',215,6),(1921,15,'2010-01-07 23:00:00',216,6),(1922,15,'2010-01-07 23:15:00',217,6),(1923,15,'2010-01-07 23:30:00',218,6),(1924,15,'2010-01-07 23:45:00',219,6),(1925,15,'2010-01-08 00:00:00',220,6),(1926,15,'2010-01-08 00:15:00',221,6),(1927,15,'2010-01-08 00:30:00',222,6),(1928,15,'2010-01-08 00:45:00',223,6),(1929,15,'2010-01-08 01:00:00',224,6),(1930,15,'2010-01-08 01:15:00',225,6),(1931,15,'2010-01-08 01:30:00',226,6),(1932,15,'2010-01-08 01:45:00',227,6),(1933,15,'2010-01-08 02:00:00',228,6),(1934,15,'2010-01-08 02:15:00',229,6),(1935,15,'2010-01-07 10:30:00',165,7),(1936,15,'2010-01-07 10:45:00',166,7),(1937,15,'2010-01-07 11:00:00',167,7),(1938,15,'2010-01-07 11:15:00',168,7),(1939,15,'2010-01-07 11:30:00',169,7),(1940,15,'2010-01-07 11:45:00',170,7),(1941,15,'2010-01-07 12:00:00',171,7),(1942,15,'2010-01-07 12:15:00',172,7),(1943,15,'2010-01-07 12:30:00',173,7),
(1944,15,'2010-01-07 12:45:00',174,7),(1945,15,'2010-01-07 13:00:00',175,7),(1946,15,'2010-01-07 13:15:00',176,7),(1947,15,'2010-01-07 13:30:00',177,7),(1948,15,'2010-01-07 13:45:00',178,7),(1949,15,'2010-01-07 14:00:00',179,7),(1950,15,'2010-01-07 14:15:00',180,7),(1951,15,'2010-01-07 14:30:00',181,7),(1952,15,'2010-01-07 14:45:00',182,7),(1953,15,'2010-01-07 15:00:00',183,7),(1954,15,'2010-01-07 15:15:00',184,7),(1955,15,'2010-01-07 15:30:00',185,7),(1956,15,'2010-01-07 15:45:00',186,7),(1957,15,'2010-01-07 16:00:00',187,7),(1958,15,'2010-01-07 16:15:00',188,7),(1959,15,'2010-01-07 16:30:00',189,7),(1960,15,'2010-01-07 16:45:00',190,7),(1961,15,'2010-01-07 17:00:00',191,7),(1962,15,'2010-01-07 17:15:00',192,7),(1963,15,'2010-01-07 17:30:00',193,7),(1964,15,'2010-01-07 17:45:00',194,7),(1965,15,'2010-01-07 18:00:00',195,7),(1966,15,'2010-01-07 18:15:00',196,7),(1967,15,'2010-01-07 18:30:00',197,7),(1968,15,'2010-01-07 18:45:00',198,7),(1969,15,'2010-01-07 19:00:00',199,7),(1970,15,'2010-01-07 19:15:00',200,7),(1971,15,'2010-01-07 19:30:00',201,7),(1972,15,'2010-01-07 19:45:00',202,7),(1973,15,'2010-01-07 20:00:00',203,7),(1974,15,'2010-01-07 20:15:00',204,7),(1975,15,'2010-01-07 20:30:00',205,7),(1976,15,'2010-01-07 20:45:00',206,7),(1977,15,'2010-01-07 21:00:00',207,7),(1978,15,'2010-01-07 21:15:00',208,7),(1979,15,'2010-01-07 21:30:00',209,7),(1980,15,'2010-01-07 21:45:00',210,7),(1981,15,'2010-01-07 22:00:00',211,7),(1982,15,'2010-01-07 22:15:00',212,7),(1983,15,'2010-01-07 22:30:00',213,7),(1984,15,'2010-01-07 22:45:00',214,7),(1985,15,'2010-01-07 23:00:00',215,7),(1986,15,'2010-01-07 23:15:00',216,7),(1987,15,'2010-01-07 23:30:00',217,7),(1988,15,'2010-01-07 23:45:00',218,7),(1989,15,'2010-01-08 00:00:00',219,7),(1990,15,'2010-01-08 00:15:00',220,7),(1991,15,'2010-01-08 00:30:00',221,7),(1992,15,'2010-01-08 00:45:00',222,7),(1993,15,'2010-01-08 01:00:00',223,7),(1994,15,'2010-01-08 01:15:00',224,7),(1995,15,'2010-01-08 01:30:00',225,7),(1996,15,'2010-01-08 01:45:00',226,7),(1997,15,'2010-01-08 02:00:00',227,7),(1998,15,'2010-01-08 02:15:00',228,7),(1999,15,'2010-01-08 02:30:00',229,7),(2000,15,'2010-01-07 10:45:00',165,8),(2001,15,'2010-01-07 11:00:00',166,8),(2002,15,'2010-01-07 11:15:00',167,8),(2003,15,'2010-01-07 11:30:00',168,8),(2004,15,'2010-01-07 11:45:00',169,8),(2005,15,'2010-01-07 12:00:00',170,8),(2006,15,'2010-01-07 12:15:00',171,8),(2007,15,'2010-01-07 12:30:00',172,8),(2008,15,'2010-01-07 12:45:00',173,8),(2009,15,'2010-01-07 13:00:00',174,8),(2010,15,'2010-01-07 13:15:00',175,8),(2011,15,'2010-01-07 13:30:00',176,8),(2012,15,'2010-01-07 13:45:00',177,8),(2013,15,'2010-01-07 14:00:00',178,8),(2014,15,'2010-01-07 14:15:00',179,8),(2015,15,'2010-01-07 14:30:00',180,8),(2016,15,'2010-01-07 14:45:00',181,8),(2017,15,'2010-01-07 15:00:00',182,8),(2018,15,'2010-01-07 15:15:00',183,8),(2019,15,'2010-01-07 15:30:00',184,8),(2020,15,'2010-01-07 15:45:00',185,8),(2021,15,'2010-01-07 16:00:00',186,8),(2022,15,'2010-01-07 16:15:00',187,8),(2023,15,'2010-01-07 16:30:00',188,8),(2024,15,'2010-01-07 16:45:00',189,8),(2025,15,'2010-01-07 17:00:00',190,8),(2026,15,'2010-01-07 17:15:00',191,8),(2027,15,'2010-01-07 17:30:00',192,8),(2028,15,'2010-01-07 17:45:00',193,8),(2029,15,'2010-01-07 18:00:00',194,8),(2030,15,'2010-01-07 18:15:00',195,8),(2031,15,'2010-01-07 18:30:00',196,8),(2032,15,'2010-01-07 18:45:00',197,8),(2033,15,'2010-01-07 19:00:00',198,8),(2034,15,'2010-01-07 19:15:00',199,8),(2035,15,'2010-01-07 19:30:00',200,8),(2036,15,'2010-01-07 19:45:00',201,8),(2037,15,'2010-01-07 20:00:00',202,8),(2038,15,'2010-01-07 20:15:00',203,8),(2039,15,'2010-01-07 20:30:00',204,8),(2040,15,'2010-01-07 20:45:00',205,8),(2041,15,'2010-01-07 21:00:00',206,8),(2042,15,'2010-01-07 21:15:00',207,8),(2043,15,'2010-01-07 21:30:00',208,8),(2044,15,'2010-01-07 21:45:00',209,8),(2045,15,'2010-01-07 22:00:00',210,8),(2046,15,'2010-01-07 22:15:00',211,8),(2047,15,'2010-01-07 22:30:00',212,8),(2048,15,'2010-01-07 22:45:00',213,8),(2049,15,'2010-01-07 23:00:00',214,8),(2050,15,'2010-01-07 23:15:00',215,8),(2051,15,'2010-01-07 23:30:00',216,8),(2052,15,'2010-01-07 23:45:00',217,8),(2053,15,'2010-01-08 00:00:00',218,8),(2054,15,'2010-01-08 00:15:00',219,8),(2055,15,'2010-01-08 00:30:00',220,8),(2056,15,'2010-01-08 00:45:00',221,8),(2057,15,'2010-01-08 01:00:00',222,8),(2058,15,'2010-01-08 01:15:00',223,8),(2059,15,'2010-01-08 01:30:00',224,8),(2060,15,'2010-01-08 01:45:00',225,8),(2061,15,'2010-01-08 02:00:00',226,8),(2062,15,'2010-01-08 02:15:00',227,8),(2063,15,'2010-01-08 02:30:00',228,8),(2064,15,'2010-01-08 02:45:00',229,8),(2065,18,'2010-01-09 08:00:00',267,1),(2066,18,'2010-01-09 08:10:00',268,1),(2067,18,'2010-01-09 08:20:00',269,1),(2068,18,'2010-01-09 08:30:00',270,1),(2069,18,'2010-01-09 08:40:00',271,1),(2070,18,'2010-01-09 08:50:00',272,1),(2071,18,'2010-01-09 09:00:00',273,1),(2072,18,'2010-01-09 09:10:00',274,1),(2073,18,'2010-01-09 09:20:00',275,1),(2074,18,'2010-01-09 09:30:00',276,1),(2075,18,'2010-01-09 09:40:00',277,1),(2076,18,'2010-01-09 09:50:00',278,1),(2077,18,'2010-01-09 10:00:00',279,1),(2078,18,'2010-01-09 10:10:00',280,1),(2079,18,'2010-01-09 10:20:00',281,1),(2080,18,'2010-01-09 08:10:00',267,2),(2081,18,'2010-01-09 08:20:00',268,2),(2082,18,'2010-01-09 08:30:00',269,2),(2083,18,'2010-01-09 08:40:00',270,2),(2084,18,'2010-01-09 08:50:00',271,2),(2085,18,'2010-01-09 09:00:00',272,2),(2086,18,'2010-01-09 09:10:00',273,2),(2087,18,'2010-01-09 09:20:00',274,2),(2088,18,'2010-01-09 09:30:00',275,2),(2089,18,'2010-01-09 09:40:00',276,2),(2090,18,'2010-01-09 09:50:00',277,2),(2091,18,'2010-01-09 10:00:00',278,2),(2092,18,'2010-01-09 10:10:00',279,2),(2093,18,'2010-01-09 10:20:00',280,2),(2094,18,'2010-01-09 10:30:00',281,2),(2095,18,'2010-01-09 08:20:00',267,3),(2096,18,'2010-01-09 08:30:00',268,3),(2097,18,'2010-01-09 08:40:00',269,3),(2098,18,'2010-01-09 08:50:00',270,3),(2099,18,'2010-01-09 09:00:00',271,3),(2100,18,'2010-01-09 09:10:00',272,3),(2101,18,'2010-01-09 09:20:00',273,3),(2102,18,'2010-01-09 09:30:00',274,3),(2103,18,'2010-01-09 09:40:00',275,3),(2104,18,'2010-01-09 09:50:00',276,3),(2105,18,'2010-01-09 10:00:00',277,3),(2106,18,'2010-01-09 10:10:00',278,3),(2107,18,'2010-01-09 10:20:00',279,3),(2108,18,'2010-01-09 10:30:00',280,3),(2109,18,'2010-01-09 10:40:00',281,3),(2110,18,'2010-01-09 08:30:00',267,4),(2111,18,'2010-01-09 08:40:00',268,4),(2112,18,'2010-01-09 08:50:00',269,4),(2113,18,'2010-01-09 09:00:00',270,4),(2114,18,'2010-01-09 09:10:00',271,4),(2115,18,'2010-01-09 09:20:00',272,4),(2116,18,'2010-01-09 09:30:00',273,4),(2117,18,'2010-01-09 09:40:00',274,4),(2118,18,'2010-01-09 09:50:00',275,4),(2119,18,'2010-01-09 10:00:00',276,4),(2120,18,'2010-01-09 10:10:00',277,4),(2121,18,'2010-01-09 10:20:00',278,4),(2122,18,'2010-01-09 10:30:00',279,4),(2123,18,'2010-01-09 10:40:00',280,4),(2124,18,'2010-01-09 10:50:00',281,4),(2125,18,'2010-01-09 08:40:00',267,5),(2126,18,'2010-01-09 08:50:00',268,5),(2127,18,'2010-01-09 09:00:00',269,5),(2128,18,'2010-01-09 09:10:00',270,5),(2129,18,'2010-01-09 09:20:00',271,5),(2130,18,'2010-01-09 09:30:00',272,5),(2131,18,'2010-01-09 09:40:00',273,5),(2132,18,'2010-01-09 09:50:00',274,5),(2133,18,'2010-01-09 10:00:00',275,5),(2134,18,'2010-01-09 10:10:00',276,5),(2135,18,'2010-01-09 10:20:00',277,5),(2136,18,'2010-01-09 10:30:00',278,5),(2137,18,'2010-01-09 10:40:00',279,5),(2138,18,'2010-01-09 10:50:00',280,5),(2139,18,'2010-01-09 11:00:00',281,5),(2140,18,'2010-01-09 08:50:00',267,6),(2141,18,'2010-01-09 09:00:00',268,6),(2142,18,'2010-01-09 09:10:00',269,6),(2143,18,'2010-01-09 09:20:00',270,6),(2144,18,'2010-01-09 09:30:00',271,6),(2145,18,'2010-01-09 09:40:00',272,6),(2146,18,'2010-01-09 09:50:00',273,6),(2147,18,'2010-01-09 10:00:00',274,6),(2148,18,'2010-01-09 10:10:00',275,6),(2149,18,'2010-01-09 10:20:00',276,6),(2150,18,'2010-01-09 10:30:00',277,6),(2151,18,'2010-01-09 10:40:00',278,6),(2152,18,'2010-01-09 10:50:00',279,6),(2153,18,'2010-01-09 11:00:00',280,6),(2154,18,'2010-01-09 11:10:00',281,6),(2155,18,'2010-01-09 09:00:00',267,7),(2156,18,'2010-01-09 09:10:00',268,7),(2157,18,'2010-01-09 09:20:00',269,7),(2158,18,'2010-01-09 09:30:00',270,7),(2159,18,'2010-01-09 09:40:00',271,7),(2160,18,'2010-01-09 09:50:00',272,7),(2161,18,'2010-01-09 10:00:00',273,7),(2162,18,'2010-01-09 10:10:00',274,7),(2163,18,'2010-01-09 10:20:00',275,7),(2164,18,'2010-01-09 10:30:00',276,7),(2165,18,'2010-01-09 10:40:00',277,7),(2166,18,'2010-01-09 10:50:00',278,7),(2167,18,'2010-01-09 11:00:00',279,7),(2168,18,'2010-01-09 11:10:00',280,7),(2169,18,'2010-01-09 11:20:00',281,7),(2170,18,'2010-01-09 09:10:00',267,8),(2171,18,'2010-01-09 09:20:00',268,8),(2172,18,'2010-01-09 09:30:00',269,8),(2173,18,'2010-01-09 09:40:00',270,8),(2174,18,'2010-01-09 09:50:00',271,8),(2175,18,'2010-01-09 10:00:00',272,8),(2176,18,'2010-01-09 10:10:00',273,8),(2177,18,'2010-01-09 10:20:00',274,8),(2178,18,'2010-01-09 10:30:00',275,8),(2179,18,'2010-01-09 10:40:00',276,8),(2180,18,'2010-01-09 10:50:00',277,8),(2181,18,'2010-01-09 11:00:00',278,8),(2182,18,'2010-01-09 11:10:00',279,8),(2183,18,'2010-01-09 11:20:00',280,8),(2184,18,'2010-01-09 11:30:00',281,8),(2185,19,'2010-01-10 09:00:00',282,1),(2186,19,'2010-01-10 09:15:00',283,1),(2187,19,'2010-01-10 09:30:00',284,1),(2188,19,'2010-01-10 09:45:00',285,1),(2189,19,'2010-01-10 10:00:00',286,1),(2190,19,'2010-01-10 10:15:00',287,1),(2191,19,'2010-01-10 10:30:00',288,1),(2192,19,'2010-01-10 10:45:00',289,1),(2193,19,'2010-01-10 11:00:00',290,1),(2194,19,'2010-01-10 11:15:00',291,1),(2195,19,'2010-01-10 11:30:00',292,1),(2196,19,'2010-01-10 11:45:00',293,1),(2197,19,'2010-01-10 12:00:00',294,1),(2198,19,'2010-01-10 12:15:00',295,1),
(2199,19,'2010-01-10 12:30:00',296,1),(2200,19,'2010-01-10 12:45:00',297,1),(2201,19,'2010-01-10 13:00:00',298,1),(2202,19,'2010-01-10 13:15:00',299,1),(2203,19,'2010-01-10 13:30:00',300,1),(2204,19,'2010-01-10 13:45:00',301,1),(2205,19,'2010-01-10 09:15:00',282,2),(2206,19,'2010-01-10 09:30:00',283,2),(2207,19,'2010-01-10 09:45:00',284,2),(2208,19,'2010-01-10 10:00:00',285,2),(2209,19,'2010-01-10 10:15:00',286,2),(2210,19,'2010-01-10 10:30:00',287,2),(2211,19,'2010-01-10 10:45:00',288,2),(2212,19,'2010-01-10 11:00:00',289,2),(2213,19,'2010-01-10 11:15:00',290,2),(2214,19,'2010-01-10 11:30:00',291,2),(2215,19,'2010-01-10 11:45:00',292,2),(2216,19,'2010-01-10 12:00:00',293,2),(2217,19,'2010-01-10 12:15:00',294,2),(2218,19,'2010-01-10 12:30:00',295,2),(2219,19,'2010-01-10 12:45:00',296,2),(2220,19,'2010-01-10 13:00:00',297,2),(2221,19,'2010-01-10 13:15:00',298,2),(2222,19,'2010-01-10 13:30:00',299,2),(2223,19,'2010-01-10 13:45:00',300,2),(2224,19,'2010-01-10 14:00:00',301,2),(2225,19,'2010-01-10 09:30:00',282,3),(2226,19,'2010-01-10 09:45:00',283,3),(2227,19,'2010-01-10 10:00:00',284,3),(2228,19,'2010-01-10 10:15:00',285,3),(2229,19,'2010-01-10 10:30:00',286,3),(2230,19,'2010-01-10 10:45:00',287,3),(2231,19,'2010-01-10 11:00:00',288,3),(2232,19,'2010-01-10 11:15:00',289,3),(2233,19,'2010-01-10 11:30:00',290,3),(2234,19,'2010-01-10 11:45:00',291,3),(2235,19,'2010-01-10 12:00:00',292,3),(2236,19,'2010-01-10 12:15:00',293,3),(2237,19,'2010-01-10 12:30:00',294,3),(2238,19,'2010-01-10 12:45:00',295,3),(2239,19,'2010-01-10 13:00:00',296,3),(2240,19,'2010-01-10 13:15:00',297,3),(2241,19,'2010-01-10 13:30:00',298,3),(2242,19,'2010-01-10 13:45:00',299,3),(2243,19,'2010-01-10 14:00:00',300,3),(2244,19,'2010-01-10 14:15:00',301,3),(2245,19,'2010-01-10 09:45:00',282,4),(2246,19,'2010-01-10 10:00:00',283,4),(2247,19,'2010-01-10 10:15:00',284,4),(2248,19,'2010-01-10 10:30:00',285,4),(2249,19,'2010-01-10 10:45:00',286,4),(2250,19,'2010-01-10 11:00:00',287,4),(2251,19,'2010-01-10 11:15:00',288,4),(2252,19,'2010-01-10 11:30:00',289,4),(2253,19,'2010-01-10 11:45:00',290,4),(2254,19,'2010-01-10 12:00:00',291,4),(2255,19,'2010-01-10 12:15:00',292,4),(2256,19,'2010-01-10 12:30:00',293,4),(2257,19,'2010-01-10 12:45:00',294,4),(2258,19,'2010-01-10 13:00:00',295,4),(2259,19,'2010-01-10 13:15:00',296,4),(2260,19,'2010-01-10 13:30:00',297,4),(2261,19,'2010-01-10 13:45:00',298,4),(2262,19,'2010-01-10 14:00:00',299,4),(2263,19,'2010-01-10 14:15:00',300,4),(2264,19,'2010-01-10 14:30:00',301,4),(2265,19,'2010-01-10 10:00:00',282,5),(2266,19,'2010-01-10 10:15:00',283,5),(2267,19,'2010-01-10 10:30:00',284,5),(2268,19,'2010-01-10 10:45:00',285,5),(2269,19,'2010-01-10 11:00:00',286,5),(2270,19,'2010-01-10 11:15:00',287,5),(2271,19,'2010-01-10 11:30:00',288,5),(2272,19,'2010-01-10 11:45:00',289,5),(2273,19,'2010-01-10 12:00:00',290,5),(2274,19,'2010-01-10 12:15:00',291,5),(2275,19,'2010-01-10 12:30:00',292,5),(2276,19,'2010-01-10 12:45:00',293,5),(2277,19,'2010-01-10 13:00:00',294,5),(2278,19,'2010-01-10 13:15:00',295,5),(2279,19,'2010-01-10 13:30:00',296,5),(2280,19,'2010-01-10 13:45:00',297,5),(2281,19,'2010-01-10 14:00:00',298,5),(2282,19,'2010-01-10 14:15:00',299,5),(2283,19,'2010-01-10 14:30:00',300,5),(2284,19,'2010-01-10 14:45:00',301,5),(2285,19,'2010-01-10 10:15:00',282,6),(2286,19,'2010-01-10 10:30:00',283,6),(2287,19,'2010-01-10 10:45:00',284,6),(2288,19,'2010-01-10 11:00:00',285,6),(2289,19,'2010-01-10 11:15:00',286,6),(2290,19,'2010-01-10 11:30:00',287,6),(2291,19,'2010-01-10 11:45:00',288,6),(2292,19,'2010-01-10 12:00:00',289,6),(2293,19,'2010-01-10 12:15:00',290,6),(2294,19,'2010-01-10 12:30:00',291,6),(2295,19,'2010-01-10 12:45:00',292,6),(2296,19,'2010-01-10 13:00:00',293,6),(2297,19,'2010-01-10 13:15:00',294,6),(2298,19,'2010-01-10 13:30:00',295,6),(2299,19,'2010-01-10 13:45:00',296,6),(2300,19,'2010-01-10 14:00:00',297,6),(2301,19,'2010-01-10 14:15:00',298,6),(2302,19,'2010-01-10 14:30:00',299,6),(2303,19,'2010-01-10 14:45:00',300,6),(2304,19,'2010-01-10 15:00:00',301,6),(2305,19,'2010-01-10 10:30:00',282,7),(2306,19,'2010-01-10 10:45:00',283,7),(2307,19,'2010-01-10 11:00:00',284,7),(2308,19,'2010-01-10 11:15:00',285,7),(2309,19,'2010-01-10 11:30:00',286,7),(2310,19,'2010-01-10 11:45:00',287,7),(2311,19,'2010-01-10 12:00:00',288,7),(2312,19,'2010-01-10 12:15:00',289,7),(2313,19,'2010-01-10 12:30:00',290,7),(2314,19,'2010-01-10 12:45:00',291,7),(2315,19,'2010-01-10 13:00:00',292,7),(2316,19,'2010-01-10 13:15:00',293,7),(2317,19,'2010-01-10 13:30:00',294,7),(2318,19,'2010-01-10 13:45:00',295,7),(2319,19,'2010-01-10 14:00:00',296,7),(2320,19,'2010-01-10 14:15:00',297,7),(2321,19,'2010-01-10 14:30:00',298,7),(2322,19,'2010-01-10 14:45:00',299,7),(2323,19,'2010-01-10 15:00:00',300,7),(2324,19,'2010-01-10 15:15:00',301,7),(2325,19,'2010-01-10 10:45:00',282,8),(2326,19,'2010-01-10 11:00:00',283,8),(2327,19,'2010-01-10 11:15:00',284,8),(2328,19,'2010-01-10 11:30:00',285,8),(2329,19,'2010-01-10 11:45:00',286,8),(2330,19,'2010-01-10 12:00:00',287,8),(2331,19,'2010-01-10 12:15:00',288,8),(2332,19,'2010-01-10 12:30:00',289,8),(2333,19,'2010-01-10 12:45:00',290,8),(2334,19,'2010-01-10 13:00:00',291,8),(2335,19,'2010-01-10 13:15:00',292,8),(2336,19,'2010-01-10 13:30:00',293,8),(2337,19,'2010-01-10 13:45:00',294,8),(2338,19,'2010-01-10 14:00:00',295,8),(2339,19,'2010-01-10 14:15:00',296,8),(2340,19,'2010-01-10 14:30:00',297,8),(2341,19,'2010-01-10 14:45:00',298,8),(2342,19,'2010-01-10 15:00:00',299,8),(2343,19,'2010-01-10 15:15:00',300,8),(2344,19,'2010-01-10 15:30:00',301,8),(2345,20,'2010-05-01 09:00:00',302,1),(2346,20,'2010-05-01 09:15:00',303,1),(2347,20,'2010-05-01 09:30:00',304,1),(2348,20,'2010-05-01 09:45:00',305,1),(2349,20,'2010-05-01 10:00:00',306,1),(2350,20,'2010-05-01 10:15:00',307,1),(2351,20,'2010-05-01 10:30:00',308,1),(2352,20,'2010-05-01 10:45:00',309,1),(2353,20,'2010-05-01 09:15:00',302,2),(2354,20,'2010-05-01 09:30:00',303,2),(2355,20,'2010-05-01 09:45:00',304,2),(2356,20,'2010-05-01 10:00:00',305,2),(2357,20,'2010-05-01 10:15:00',306,2),(2358,20,'2010-05-01 10:30:00',307,2),(2359,20,'2010-05-01 10:45:00',308,2),(2360,20,'2010-05-01 11:00:00',309,2),(2361,20,'2010-05-01 09:30:00',302,3),(2362,20,'2010-05-01 09:45:00',303,3),(2363,20,'2010-05-01 10:00:00',304,3),(2364,20,'2010-05-01 10:15:00',305,3),(2365,20,'2010-05-01 10:30:00',306,3),(2366,20,'2010-05-01 10:45:00',307,3),(2367,20,'2010-05-01 11:00:00',308,3),(2368,20,'2010-05-01 11:15:00',309,3),(2369,20,'2010-05-01 09:45:00',302,4),(2370,20,'2010-05-01 10:00:00',303,4),(2371,20,'2010-05-01 10:15:00',304,4),(2372,20,'2010-05-01 10:30:00',305,4),(2373,20,'2010-05-01 10:45:00',306,4),(2374,20,'2010-05-01 11:00:00',307,4),(2375,20,'2010-05-01 11:15:00',308,4),(2376,20,'2010-05-01 11:30:00',309,4),(2377,20,'2010-05-01 10:00:00',302,5),(2378,20,'2010-05-01 10:15:00',303,5),(2379,20,'2010-05-01 10:30:00',304,5),(2380,20,'2010-05-01 10:45:00',305,5),(2381,20,'2010-05-01 11:00:00',306,5),(2382,20,'2010-05-01 11:15:00',307,5),(2383,20,'2010-05-01 11:30:00',308,5),(2384,20,'2010-05-01 11:45:00',309,5),(2385,20,'2010-05-01 10:15:00',302,6),(2386,20,'2010-05-01 10:30:00',303,6),(2387,20,'2010-05-01 10:45:00',304,6),(2388,20,'2010-05-01 11:00:00',305,6),(2389,20,'2010-05-01 11:15:00',306,6),(2390,20,'2010-05-01 11:30:00',307,6),(2391,20,'2010-05-01 11:45:00',308,6),(2392,20,'2010-05-01 12:00:00',309,6),(2393,20,'2010-05-01 10:30:00',302,7),(2394,20,'2010-05-01 10:45:00',303,7),(2395,20,'2010-05-01 11:00:00',304,7),(2396,20,'2010-05-01 11:15:00',305,7),(2397,20,'2010-05-01 11:30:00',306,7),(2398,20,'2010-05-01 11:45:00',307,7),(2399,20,'2010-05-01 12:00:00',308,7),(2400,20,'2010-05-01 12:15:00',309,7),(2401,20,'2010-05-01 10:45:00',302,8),(2402,20,'2010-05-01 11:00:00',303,8),(2403,20,'2010-05-01 11:15:00',304,8),(2404,20,'2010-05-01 11:30:00',305,8),(2405,20,'2010-05-01 11:45:00',306,8),(2406,20,'2010-05-01 12:00:00',307,8),(2407,20,'2010-05-01 12:15:00',308,8),(2408,20,'2010-05-01 12:30:00',309,8),(2409,20,'2010-05-01 11:00:00',302,9),(2410,20,'2010-05-01 11:15:00',303,9),(2411,20,'2010-05-01 11:30:00',304,9),(2412,20,'2010-05-01 11:45:00',305,9),(2413,20,'2010-05-01 12:00:00',306,9),(2414,20,'2010-05-01 12:15:00',307,9),(2415,20,'2010-05-01 12:30:00',308,9),(2416,20,'2010-05-01 12:45:00',309,9),(2417,20,'2010-05-01 11:15:00',302,10),(2418,20,'2010-05-01 11:30:00',303,10),(2419,20,'2010-05-01 11:45:00',304,10),(2420,20,'2010-05-01 12:00:00',305,10),(2421,20,'2010-05-01 12:15:00',306,10),(2422,20,'2010-05-01 12:30:00',307,10),(2423,20,'2010-05-01 12:45:00',308,10),(2424,20,'2010-05-01 13:00:00',309,10),(2425,21,'2010-02-20 08:30:00',310,1),(2426,21,'2010-02-20 08:40:00',311,1),(2427,21,'2010-02-20 08:50:00',312,1),(2428,21,'2010-02-20 09:00:00',313,1),(2429,21,'2010-02-20 09:10:00',314,1),(2430,21,'2010-02-20 09:20:00',315,1),(2431,21,'2010-02-20 09:30:00',316,1),(2432,21,'2010-02-20 09:40:00',317,1),(2433,21,'2010-02-20 09:50:00',318,1),(2434,21,'2010-02-20 10:00:00',319,1),(2435,21,'2010-02-20 10:10:00',320,1),(2436,21,'2010-02-20 10:20:00',321,1),(2437,21,'2010-02-20 10:30:00',322,1),(2438,21,'2010-02-20 10:40:00',323,1),(2439,21,'2010-02-20 10:50:00',324,1),(2440,21,'2010-02-20 11:00:00',325,1),(2441,21,'2010-02-20 11:10:00',326,1),(2442,21,'2010-02-20 08:40:00',310,2),(2443,21,'2010-02-20 08:50:00',311,2),(2444,21,'2010-02-20 09:00:00',312,2),(2445,21,'2010-02-20 09:10:00',313,2),(2446,21,'2010-02-20 09:20:00',314,2),(2447,21,'2010-02-20 09:30:00',315,2),(2448,21,'2010-02-20 09:40:00',316,2),(2449,21,'2010-02-20 09:50:00',317,2),(2450,21,'2010-02-20 10:00:00',318,2),(2451,21,'2010-02-20 10:10:00',319,2),(2452,21,'2010-02-20 10:20:00',320,2),(2453,21,'2010-02-20 10:30:00',321,2),(2454,21,'2010-02-20 10:40:00',322,2),(2455,21,'2010-02-20 10:50:00',323,2),(2456,21,'2010-02-20 11:00:00',324,2),(2457,21,'2010-02-20 11:10:00',325,2),(2458,21,'2010-02-20 11:20:00',326,2),(2459,21,'2010-02-20 08:50:00',310,3),(2460,21,'2010-02-20 09:00:00',311,3),(2461,21,'2010-02-20 09:10:00',312,3),(2462,21,'2010-02-20 09:20:00',313,3),(2463,21,'2010-02-20 09:30:00',314,3),(2464,21,'2010-02-20 09:40:00',315,3),(2465,21,'2010-02-20 09:50:00',316,3),(2466,21,'2010-02-20 10:00:00',317,3),(2467,21,'2010-02-20 10:10:00',318,3),(2468,21,'2010-02-20 10:20:00',319,3),(2469,21,'2010-02-20 10:30:00',320,3),(2470,21,'2010-02-20 10:40:00',321,3),(2471,21,'2010-02-20 10:50:00',322,3),(2472,21,'2010-02-20 11:00:00',323,3),(2473,21,'2010-02-20 11:10:00',324,3),(2474,21,'2010-02-20 11:20:00',325,3),(2475,21,'2010-02-20 11:30:00',326,3),(2476,21,'2010-02-20 09:00:00',310,4),(2477,21,'2010-02-20 09:10:00',311,4),(2478,21,'2010-02-20 09:20:00',312,4),(2479,21,'2010-02-20 09:30:00',313,4),(2480,21,'2010-02-20 09:40:00',314,4),(2481,21,'2010-02-20 09:50:00',315,4),(2482,21,'2010-02-20 10:00:00',316,4),(2483,21,'2010-02-20 10:10:00',317,4),(2484,21,'2010-02-20 10:20:00',318,4),(2485,21,'2010-02-20 10:30:00',319,4),
(2486,21,'2010-02-20 10:40:00',320,4),(2487,21,'2010-02-20 10:50:00',321,4),(2488,21,'2010-02-20 11:00:00',322,4),(2489,21,'2010-02-20 11:10:00',323,4),(2490,21,'2010-02-20 11:20:00',324,4),(2491,21,'2010-02-20 11:30:00',325,4),(2492,21,'2010-02-20 11:40:00',326,4),(2493,21,'2010-02-20 09:10:00',310,5),(2494,21,'2010-02-20 09:20:00',311,5),(2495,21,'2010-02-20 09:30:00',312,5),(2496,21,'2010-02-20 09:40:00',313,5),(2497,21,'2010-02-20 09:50:00',314,5),(2498,21,'2010-02-20 10:00:00',315,5),(2499,21,'2010-02-20 10:10:00',316,5),(2500,21,'2010-02-20 10:20:00',317,5),(2501,21,'2010-02-20 10:30:00',318,5),(2502,21,'2010-02-20 10:40:00',319,5),(2503,21,'2010-02-20 10:50:00',320,5),(2504,21,'2010-02-20 11:00:00',321,5),(2505,21,'2010-02-20 11:10:00',322,5),(2506,21,'2010-02-20 11:20:00',323,5),(2507,21,'2010-02-20 11:30:00',324,5),(2508,21,'2010-02-20 11:40:00',325,5),(2509,21,'2010-02-20 11:50:00',326,5),(2510,21,'2010-02-20 09:20:00',310,6),(2511,21,'2010-02-20 09:30:00',311,6),(2512,21,'2010-02-20 09:40:00',312,6),(2513,21,'2010-02-20 09:50:00',313,6),(2514,21,'2010-02-20 10:00:00',314,6),(2515,21,'2010-02-20 10:10:00',315,6),(2516,21,'2010-02-20 10:20:00',316,6),(2517,21,'2010-02-20 10:30:00',317,6),(2518,21,'2010-02-20 10:40:00',318,6),(2519,21,'2010-02-20 10:50:00',319,6),(2520,21,'2010-02-20 11:00:00',320,6),(2521,21,'2010-02-20 11:10:00',321,6),(2522,21,'2010-02-20 11:20:00',322,6),(2523,21,'2010-02-20 11:30:00',323,6),(2524,21,'2010-02-20 11:40:00',324,6),(2525,21,'2010-02-20 11:50:00',325,6),(2526,21,'2010-02-20 12:00:00',326,6),(2527,21,'2010-02-20 09:30:00',310,7),(2528,21,'2010-02-20 09:40:00',311,7),(2529,21,'2010-02-20 09:50:00',312,7),(2530,21,'2010-02-20 10:00:00',313,7),(2531,21,'2010-02-20 10:10:00',314,7),(2532,21,'2010-02-20 10:20:00',315,7),(2533,21,'2010-02-20 10:30:00',316,7),(2534,21,'2010-02-20 10:40:00',317,7),(2535,21,'2010-02-20 10:50:00',318,7),(2536,21,'2010-02-20 11:00:00',319,7),(2537,21,'2010-02-20 11:10:00',320,7),(2538,21,'2010-02-20 11:20:00',321,7),(2539,21,'2010-02-20 11:30:00',322,7),(2540,21,'2010-02-20 11:40:00',323,7),(2541,21,'2010-02-20 11:50:00',324,7),(2542,21,'2010-02-20 12:00:00',325,7),(2543,21,'2010-02-20 12:10:00',326,7),(2544,21,'2010-02-20 09:40:00',310,8),(2545,21,'2010-02-20 09:50:00',311,8),(2546,21,'2010-02-20 10:00:00',312,8),(2547,21,'2010-02-20 10:10:00',313,8),(2548,21,'2010-02-20 10:20:00',314,8),(2549,21,'2010-02-20 10:30:00',315,8),(2550,21,'2010-02-20 10:40:00',316,8),(2551,21,'2010-02-20 10:50:00',317,8),(2552,21,'2010-02-20 11:00:00',318,8),(2553,21,'2010-02-20 11:10:00',319,8),(2554,21,'2010-02-20 11:20:00',320,8),(2555,21,'2010-02-20 11:30:00',321,8),(2556,21,'2010-02-20 11:40:00',322,8),(2557,21,'2010-02-20 11:50:00',323,8),(2558,21,'2010-02-20 12:00:00',324,8),(2559,21,'2010-02-20 12:10:00',325,8),(2560,21,'2010-02-20 12:20:00',326,8),(2576,22,'2101-03-30 08:56:00',334,1),(2575,22,'2101-03-30 08:48:00',333,1),(2574,22,'2101-03-30 08:40:00',332,1),(2573,22,'2101-03-30 08:32:00',331,1),(2572,22,'2101-03-30 08:24:00',330,1),(2571,22,'2101-03-30 08:16:00',329,1),(2570,22,'2101-03-30 08:08:00',328,1),(2569,22,'2101-03-30 08:00:00',327,1),(2577,22,'2101-03-30 09:04:00',335,1),(2578,22,'2101-03-30 09:12:00',336,1),(2579,22,'2101-03-30 08:08:00',327,2),(2580,22,'2101-03-30 08:16:00',328,2),(2581,22,'2101-03-30 08:24:00',329,2),(2582,22,'2101-03-30 08:32:00',330,2),(2583,22,'2101-03-30 08:40:00',331,2),(2584,22,'2101-03-30 08:48:00',332,2),(2585,22,'2101-03-30 08:56:00',333,2),(2586,22,'2101-03-30 09:04:00',334,2),(2587,22,'2101-03-30 09:12:00',335,2),(2588,22,'2101-03-30 09:20:00',336,2),(2589,22,'2101-03-30 08:16:00',327,3),(2590,22,'2101-03-30 08:24:00',328,3),(2591,22,'2101-03-30 08:32:00',329,3),(2592,22,'2101-03-30 08:40:00',330,3),(2593,22,'2101-03-30 08:48:00',331,3),(2594,22,'2101-03-30 08:56:00',332,3),(2595,22,'2101-03-30 09:04:00',333,3),(2596,22,'2101-03-30 09:12:00',334,3),(2597,22,'2101-03-30 09:20:00',335,3),(2598,22,'2101-03-30 09:28:00',336,3),(2599,22,'2101-03-30 08:24:00',327,4),(2600,22,'2101-03-30 08:32:00',328,4),(2601,22,'2101-03-30 08:40:00',329,4),(2602,22,'2101-03-30 08:48:00',330,4),(2603,22,'2101-03-30 08:56:00',331,4),(2604,22,'2101-03-30 09:04:00',332,4),(2605,22,'2101-03-30 09:12:00',333,4),(2606,22,'2101-03-30 09:20:00',334,4),
(2607,22,'2101-03-30 09:28:00',335,4),(2608,22,'2101-03-30 09:36:00',336,4),(2609,22,'2101-03-30 08:32:00',327,5),(2610,22,'2101-03-30 08:40:00',328,5),(2611,22,'2101-03-30 08:48:00',329,5),(2612,22,'2101-03-30 08:56:00',330,5),(2613,22,'2101-03-30 09:04:00',331,5),(2614,22,'2101-03-30 09:12:00',332,5),(2615,22,'2101-03-30 09:20:00',333,5),(2616,22,'2101-03-30 09:28:00',334,5),(2617,22,'2101-03-30 09:36:00',335,5),(2618,22,'2101-03-30 09:44:00',336,5),(2619,22,'2101-03-30 08:40:00',327,6),(2620,22,'2101-03-30 08:48:00',328,6),(2621,22,'2101-03-30 08:56:00',329,6),(2622,22,'2101-03-30 09:04:00',330,6),(2623,22,'2101-03-30 09:12:00',331,6),(2624,22,'2101-03-30 09:20:00',332,6),(2625,22,'2101-03-30 09:28:00',333,6),(2626,22,'2101-03-30 09:36:00',334,6),(2627,22,'2101-03-30 09:44:00',335,6),(2628,22,'2101-03-30 09:52:00',336,6),(2629,22,'2101-03-30 08:48:00',327,7),(2630,22,'2101-03-30 08:56:00',328,7),(2631,22,'2101-03-30 09:04:00',329,7),(2632,22,'2101-03-30 09:12:00',330,7),(2633,22,'2101-03-30 09:20:00',331,7),(2634,22,'2101-03-30 09:28:00',332,7),(2635,22,'2101-03-30 09:36:00',333,7),(2636,22,'2101-03-30 09:44:00',334,7),(2637,22,'2101-03-30 09:52:00',335,7),(2638,22,'2101-03-30 10:00:00',336,7),(2639,22,'2101-03-30 08:56:00',327,8),(2640,22,'2101-03-30 09:04:00',328,8),(2641,22,'2101-03-30 09:12:00',329,8),(2642,22,'2101-03-30 09:20:00',330,8),(2643,22,'2101-03-30 09:28:00',331,8),(2644,22,'2101-03-30 09:36:00',332,8),(2645,22,'2101-03-30 09:44:00',333,8),(2646,22,'2101-03-30 09:52:00',334,8),(2647,22,'2101-03-30 10:00:00',335,8),(2648,22,'2101-03-30 10:08:00',336,8),(2649,23,'2010-03-17 10:00:00',337,1),(2650,23,'2010-03-17 10:15:00',338,1),(2651,23,'2010-03-17 10:30:00',339,1),(2652,23,'2010-03-17 10:45:00',340,1),(2653,23,'2010-03-17 11:00:00',341,1),(2654,23,'2010-03-17 11:15:00',342,1),(2655,23,'2010-03-17 11:30:00',343,1),(2656,23,'2010-03-17 11:45:00',344,1),(2657,23,'2010-03-17 12:00:00',345,1),(2658,23,'2010-03-17 12:15:00',346,1),(2659,23,'2010-03-17 12:30:00',347,1),(2660,23,'2010-03-17 12:45:00',348,1),(2661,23,'2010-03-17 13:00:00',349,1),(2662,23,'2010-03-17 13:15:00',350,1),(2663,23,'2010-03-17 10:15:00',337,2),(2664,23,'2010-03-17 10:30:00',338,2),(2665,23,'2010-03-17 10:45:00',339,2),(2666,23,'2010-03-17 11:00:00',340,2),(2667,23,'2010-03-17 11:15:00',341,2),(2668,23,'2010-03-17 11:30:00',342,2),(2669,23,'2010-03-17 11:45:00',343,2),(2670,23,'2010-03-17 12:00:00',344,2),(2671,23,'2010-03-17 12:15:00',345,2),(2672,23,'2010-03-17 12:30:00',346,2),(2673,23,'2010-03-17 12:45:00',347,2),(2674,23,'2010-03-17 13:00:00',348,2),(2675,23,'2010-03-17 13:15:00',349,2),(2676,23,'2010-03-17 13:30:00',350,2),(2677,23,'2010-03-17 10:30:00',337,3),(2678,23,'2010-03-17 10:45:00',338,3),(2679,23,'2010-03-17 11:00:00',339,3),(2680,23,'2010-03-17 11:15:00',340,3),(2681,23,'2010-03-17 11:30:00',341,3),(2682,23,'2010-03-17 11:45:00',342,3),(2683,23,'2010-03-17 12:00:00',343,3),(2684,23,'2010-03-17 12:15:00',344,3),(2685,23,'2010-03-17 12:30:00',345,3),(2686,23,'2010-03-17 12:45:00',346,3),(2687,23,'2010-03-17 13:00:00',347,3),(2688,23,'2010-03-17 13:15:00',348,3),(2689,23,'2010-03-17 13:30:00',349,3),(2690,23,'2010-03-17 13:45:00',350,3),(2691,23,'2010-03-17 10:45:00',337,4),(2692,23,'2010-03-17 11:00:00',338,4),(2693,23,'2010-03-17 11:15:00',339,4),(2694,23,'2010-03-17 11:30:00',340,4),(2695,23,'2010-03-17 11:45:00',341,4),(2696,23,'2010-03-17 12:00:00',342,4),(2697,23,'2010-03-17 12:15:00',343,4),(2698,23,'2010-03-17 12:30:00',344,4),(2699,23,'2010-03-17 12:45:00',345,4),(2700,23,'2010-03-17 13:00:00',346,4),(2701,23,'2010-03-17 13:15:00',347,4),(2702,23,'2010-03-17 13:30:00',348,4),(2703,23,'2010-03-17 13:45:00',349,4),(2704,23,'2010-03-17 14:00:00',350,4),(2705,23,'2010-03-17 11:00:00',337,5),(2706,23,'2010-03-17 11:15:00',338,5),(2707,23,'2010-03-17 11:30:00',339,5),(2708,23,'2010-03-17 11:45:00',340,5),(2709,23,'2010-03-17 12:00:00',341,5),(2710,23,'2010-03-17 12:15:00',342,5),(2711,23,'2010-03-17 12:30:00',343,5),(2712,23,'2010-03-17 12:45:00',344,5),(2713,23,'2010-03-17 13:00:00',345,5),(2714,23,'2010-03-17 13:15:00',346,5),(2715,23,'2010-03-17 13:30:00',347,5),(2716,23,'2010-03-17 13:45:00',348,5),(2717,23,'2010-03-17 14:00:00',349,5),(2718,23,'2010-03-17 14:15:00',350,5),(2719,23,'2010-03-17 11:15:00',337,6),
(2848,25,'2010-06-23 17:40:00',354,8),(2849,25,'2010-06-23 17:50:00',355,8),(2850,25,'2010-06-23 18:00:000:00',360,8),(2855,25,'2010-06-23 18:50:00',361,8),
(2856,25,'2010-06-23 19:00:00',362,8),(2857,25,'2010-06-23 19:10:00',363,8),(2858,25,'2010-06-23 19:20:00',364,8),(2859,25,'2010-06-23 19:30:00',365,8),(2860,25,'2010-06-23 19:40:00',366,8),(2861,25,'2010-06-23 17:20:00',351,9),(2862,25,'2010-06-23 17:30:00',352,9),(2863,25,'2010-06-23 17:40:00',353,9),(2864,25,'2010-06-23 17:50:00',354,9),(2865,25,'2010-06-23 18:00:00',355,9),(2866,25,'2010-06-23 18:10:00',356,9),(2867,25,'2010-06-23 18:20:00',357,9),(2868,25,'2010-06-23 18:30:00',358,9),(2869,25,'2010-06-23 18:40:00',359,9),(2870,25,'2010-06-23 18:50:00',360,9),(2871,25,'2010-06-23 19:00:00',361,9),(2872,25,'2010-06-23 19:10:00',362,9),(2873,25,'2010-06-23 19:20:00',363,9),(2874,25,'2010-06-23 19:30:00',364,9),(2875,25,'2010-06-23 19:40:00',365,9),(2876,25,'2010-06-23 19:50:00',366,9),(2877,25,'2010-06-23 17:30:00',351,10),(2878,25,'2010-06-23 17:40:00',352,10),(2879,25,'2010-06-23 17:50:00',353,10),
(2880,25,'2010-06-23 18:00:00',354,10),(2881,25,'2010-06-23 18:10:00',355,10),(2882,25,'2010-06-23 18:20:00',356,10),(2883,25,'2010-06-23 18:30:00',357,10),(2884,25,'2010-06-23 18:40:00',358,10),(2885,25,'2010-06-23 18:50:00',359,10),(2886,25,'2010-06-23 19:00:00',360,10),(2887,25,'2010-06-23 19:10:00',361,10),(2888,25,'2010-06-23 19:20:00',362,10),(2889,25,'2010-06-23 19:30:00',363,10),(2890,25,'2010-06-23 19:40:00',364,10),(2891,25,'2010-06-23 19:50:00',365,10),(2892,25,'2010-06-23 20:00:00',366,10);
/*!40000 ALTER TABLE `tbl_Pistol_Schedule` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_Score`
--
DROP TABLE IF EXISTS `tbl_Pistol_Score`;
CREATE TABLE `tbl_Pistol_Score` (
`Id` bigint(20) NOT NULL auto_increment,
`CompetitionDayId` bigint(20) default NULL,
`StationId` smallint(6) NOT NULL,
`Hits` int(11) NOT NULL,
`Targets` int(11) NOT NULL,
`Points` int(11) NOT NULL,
`RegisterDate` datetime NOT NULL,
`EntryId` bigint(20) default NULL,
`CompetitionId` bigint(20) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`EntryId`,`CompetitionDayId`,`StationId`)
) ENGINE=MyISAM AUTO_INCREMENT=1710 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_Score`
--
LOCK TABLES `tbl_Pistol_Score` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_Score` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_Score` VALUES (604,18,1,6,4,0,'2010-03-21 05:13:41',201),(605,18,2,5,3,0,'2010-03-21 05:13:41',201),(606,18,3,6,2,20,'2010-03-21 05:13:41',201),(614,18,3,1,3,22,'2010-03-21 05:13:41',198),(613,18,2,1,4,0,'2010-03-21 05:13:41',198),(607,18,4,6,2,0,'2010-03-21 05:13:41',201),(608,18,5,6,3,0,'2010-03-21 05:13:41',201),(609,18,6,5,5,0,'2010-03-21 05:13:41',201),(610,18,7,6,6,0,'2010-03-21 05:13:41',201),(611,18,8,6,2,0,'2010-03-21 05:13:41',201),(612,18,1,1,1,1,'2010-03-21 05:13:41',198),(615,18,4,1,1,0,'2010-03-21 05:13:41',198),(616,18,5,1,1,0,'2010-03-21 05:13:41',198),(617,18,6,1,2,0,'2010-03-21 05:13:41',198),(618,18,7,1,1,0,'2010-03-21 05:13:41',198),(619,18,8,1,2,0,'2010-03-21 05:13:41',198),(181,19,1,2,2,2,'2010-01-06 14:03:22',216),(183,19,2,2,2,2,'2010-01-06 14:03:35',216),(185,19,3,2,2,2,'2010-01-06 14:03:50',216),(174,19,4,0,0,0,'2010-01-06 14:02:24',216),(1023,23,4,5,3,13,'2010-04-10 06:02:15',299),(1022,23,3,6,3,17,'2010-04-10 06:02:15',299),(1021,23,2,6,2,0,'2010-04-10 06:02:15',299),(1020,23,1,6,3,0,'2010-04-10 06:02:15',299),(851,23,6,4,3,0,'2010-04-10 04:57:36',263),(850,23,5,5,3,0,'2010-04-10 04:57:36',263),(849,23,4,6,3,13,'2010-04-10 04:57:36',263),(848,23,3,1,1,4,'2010-04-10 04:57:36',263),(847,23,2,6,2,0,'2010-04-10 04:57:36',263),(846,23,1,3,2,0,'2010-04-10 04:57:36',263),(1283,23,6,6,3,0,'2010-04-10 09:18:53',285),(1282,23,5,5,3,0,'2010-04-10 09:18:53',285),(1281,23,4,6,3,13,'2010-04-10 09:18:53',285),(1280,23,3,6,3,6,'2010-04-10 09:18:53',285),(1279,23,2,5,2,0,'2010-04-10 09:18:53',285),(1278,23,1,6,3,0,'2010-04-10 09:18:53',285),(1277,23,6,6,3,0,'2010-04-10 09:18:53',279),(1276,23,5,4,3,0,'2010-04-10 09:18:53',279),(1275,23,4,6,3,14,'2010-04-10 09:18:53',279),(1274,23,3,6,3,7,'2010-04-10 09:18:53',279),(1273,23,2,6,2,0,'2010-04-10 09:18:53',279),(1272,23,1,6,3,0,'2010-04-10 09:18:53',279),(1247,23,6,6,3,0,'2010-04-10 07:53:17',291),(1246,23,5,6,3,0,'2010-04-10 07:53:17',291),(580,21,1,6,2,0,'2010-03-11 07:49:29',221),(581,21,2,6,2,0,'2010-03-11 07:49:29',221),(582,21,3,6,2,0,'2010-03-11 07:49:29',221),(583,21,4,6,2,29,'2010-03-11 07:49:29',221),(584,21,5,6,2,0,'2010-03-11 07:49:29',221),(585,21,6,6,2,0,'2010-03-11 07:49:29',221),(586,21,7,5,2,0,'2010-03-11 07:49:29',221),(587,21,8,6,2,0,'2010-03-11 07:49:29',221),(588,21,1,6,2,0,'2010-03-11 07:49:29',218),(589,21,2,6,2,0,'2010-03-11 07:49:29',218),(590,21,3,6,2,0,'2010-03-11 07:49:29',218),(591,21,4,6,2,29,'2010-03-11 07:49:29',218),(592,21,5,6,2,0,'2010-03-11 07:49:29',218),(593,21,6,6,2,0,'2010-03-11 07:49:29',218),(594,21,7,6,2,0,'2010-03-11 07:49:29',218),(595,21,8,5,2,0,'2010-03-11 07:49:29',218),(596,21,1,6,2,0,'2010-03-11 07:49:29',233),(597,21,2,6,2,0,'2010-03-11 07:49:29',233),(598,21,3,6,2,0,'2010-03-11 07:49:29',233),(599,21,4,5,2,29,'2010-03-11 07:49:29',233),(600,21,5,6,2,0,'2010-03-11 07:49:29',233),(601,21,6,6,2,0,'2010-03-11 07:49:29',233),(602,21,7,6,2,0,'2010-03-11 07:49:29',233),(603,21,8,6,2,0,'2010-03-11 07:49:29',233),(1245,23,4,6,3,17,'2010-04-10 07:53:17',291),(1244,23,3,6,3,19,'2010-04-10 07:53:17',291),(1243,23,2,6,2,0,'2010-04-10 07:53:17',291),(1242,23,1,6,3,0,'2010-04-10 07:53:17',291),(1241,23,6,6,3,0,'2010-04-10 07:53:17',286),(1240,23,5,4,3,0,'2010-04-10 07:53:17',286),(1239,23,4,2,2,7,'2010-04-10 07:53:17',286),(1238,23,3,6,3,9,'2010-04-10 07:53:17',286),(1237,23,2,6,2,0,'2010-04-10 07:53:17',286),(1236,23,1,3,3,0,'2010-04-10 07:53:17',286),(1139,23,6,5,3,0,'2010-04-10 06:42:48',292),(1138,23,5,4,2,0,'2010-04-10 06:42:48',292),(1137,23,4,3,2,9,'2010-04-10 06:42:48',292),(1136,23,3,5,3,8,'2010-04-10 06:42:48',292),(1135,23,2,2,1,0,'2010-04-10 06:42:48',292),(1134,23,1,2,1,0,'2010-04-10 06:42:48',292),(250,21,1,1,1,0,'2010-02-20 09:38:58',236),(251,21,2,2,2,0,'2010-02-20 09:38:58',236),(252,21,3,3,3,0,'2010-02-20 09:38:58',236),(253,21,4,4,4,1,'2010-02-20 09:38:58',236),(254,21,5,6,3,0,'2010-02-20 09:38:58',236),(255,21,6,6,4,0,'2010-02-20 09:38:58',236),(256,21,7,6,4,0,'2010-02-20 09:38:58',236),(257,21,8,6,4,0,'2010-02-20 09:38:58',236),(779,23,6,6,3,0,'2010-04-10 04:27:10',266),(778,23,5,4,2,0,'2010-04-10 04:27:10',266),(777,23,4,5,2,7,'2010-04-10 04:27:10',266),(776,23,3,6,2,23,'2010-04-10 04:27:10',266),(775,23,2,5,1,0,'2010-04-10 04:27:10',266),(774,23,1,5,3,0,'2010-04-10 04:27:10',266),(773,23,6,6,3,0,'2010-04-10 04:27:10',269),(772,23,5,6,3,0,'2010-04-10 04:27:10',269),(771,23,4,4,2,13,'2010-04-10 04:27:10',269),(770,23,3,6,3,20,'2010-04-10 04:27:10',269),(769,23,2,6,2,0,'2010-04-10 04:27:10',269),(768,23,1,4,2,0,'2010-04-10 04:27:10',269),(767,23,6,6,3,0,'2010-04-10 04:27:10',253),(766,23,5,4,2,0,'2010-04-10 04:27:10',253),(765,23,4,0,0,0,'2010-04-10 04:27:10',253),(764,23,3,2,1,6,'2010-04-10 04:27:10',253),(763,23,2,4,1,0,'2010-04-10 04:27:10',253),(762,23,1,4,3,0,'2010-04-10 04:27:10',253),(761,23,6,6,3,0,'2010-04-10 04:27:10',268),(760,23,5,5,2,0,'2010-04-10 04:27:10',268),(759,23,4,5,3,14,'2010-04-10 04:27:10',268),(758,23,3,6,2,25,'2010-04-10 04:27:10',268),(757,23,2,4,1,0,'2010-04-10 04:27:10',268),(756,23,1,6,1,0,'2010-04-10 04:27:10',268),(755,23,6,6,3,0,'2010-04-10 04:24:02',281),(754,23,5,6,2,0,'2010-04-10 04:24:02',281),(753,23,4,6,2,22,'2010-04-10 04:24:02',281),(752,23,3,5,3,14,'2010-04-10 04:24:02',281),(751,23,2,5,2,0,'2010-04-10 04:24:02',281),(750,23,1,5,3,0,'2010-04-10 04:24:02',281),(749,23,6,5,3,0,'2010-04-10 04:24:02',270),(748,23,5,6,3,0,'2010-04-10 04:24:02',270),(747,23,4,5,2,11,'2010-04-10 04:24:02',270),(746,23,3,5,3,16,'2010-04-10 04:24:02',270),(745,23,2,6,2,0,'2010-04-10 04:24:02',270),(744,23,1,6,3,0,'2010-04-10 04:24:02',270),(743,23,6,5,2,0,'2010-04-10 04:24:02',283),(742,23,5,6,3,0,'2010-04-10 04:24:02',283),(741,23,4,5,2,16,'2010-04-10 04:24:02',283),(740,23,3,4,1,14,'2010-04-10 04:24:02',283),(298,21,1,6,3,0,'2010-02-20 09:42:15',223),(299,21,2,6,4,0,'2010-02-20 09:42:15',223),(300,21,3,6,2,0,'2010-02-20 09:42:15',223),(301,21,4,6,3,28,'2010-02-20 09:42:15',223),(302,21,5,6,4,0,'2010-02-20 09:42:15',223),(303,21,6,6,4,0,'2010-02-20 09:42:15',223),(304,21,7,6,4,0,'2010-02-20 09:42:15',223),(305,21,8,6,4,0,'2010-02-20 09:42:15',223),(306,21,1,6,3,0,'2010-02-20 09:42:15',220),(307,21,2,6,4,0,'2010-02-20 09:42:15',220),(308,21,3,6,3,0,'2010-02-20 09:42:15',220),(309,21,4,6,3,28,'2010-02-20 09:42:15',220),(310,21,5,6,4,0,'2010-02-20 09:42:15',220),(311,21,6,6,4,0,'2010-02-20 09:42:15',220),(312,21,7,6,4,0,'2010-02-20 09:42:15',220),(313,21,8,6,4,0,'2010-02-20 09:42:15',220),(314,21,1,6,3,0,'2010-02-20 09:42:15',235),(315,21,2,6,4,0,'2010-02-20 09:42:15',235),(316,21,3,6,3,0,'2010-02-20 09:42:15',235),(317,21,4,6,3,29,'2010-02-20 09:42:15',235),(318,21,5,6,4,0,'2010-02-20 09:42:15',235),(319,21,6,6,4,0,'2010-02-20 09:42:15',235),(320,21,7,6,4,0,'2010-02-20 09:42:15',235),(321,21,8,6,4,0,'2010-02-20 09:42:15',235),(739,23,2,6,2,0,'2010-04-10 04:24:02',283),(738,23,1,5,2,0,'2010-04-10 04:24:02',283),(737,23,6,6,3,0,'2010-04-10 04:24:02',289),(736,23,5,4,2,0,'2010-04-10 04:24:02',289),(735,23,4,4,2,14,'2010-04-10 04:24:02',289),(734,23,3,5,2,14,'2010-04-10 04:24:02',289),(733,23,2,6,2,0,'2010-04-10 04:24:02',289),(732,23,1,5,3,0,'2010-04-10 04:24:02',289),(731,23,6,2,1,0,'2010-04-10 04:23:40',249),(730,23,5,1,1,0,'2010-04-10 04:23:40',249),(729,23,4,5,2,13,'2010-04-10 04:23:40',249),(728,23,3,2,2,5,'2010-04-10 04:23:40',249),(727,23,2,5,1,0,'2010-04-10 04:23:40',249),(726,23,1,3,1,0,'2010-04-10 04:23:40',249),(725,23,6,4,3,0,'2010-04-10 04:23:40',264),(724,23,5,4,2,0,'2010-04-10 04:23:40',264),(338,21,1,5,3,0,'2010-02-20 09:44:25',222),(339,21,2,5,3,0,'2010-02-20 09:44:25',222),(340,21,3,6,3,0,'2010-02-20 09:44:25',222),(341,21,4,6,4,18,'2010-02-20 09:44:25',222),(342,21,5,6,4,0,'2010-02-20 09:44:25',222),(343,21,6,6,4,0,'2010-02-20 09:44:25',222),(344,21,7,6,4,0,'2010-02-20 09:44:25',222),(345,21,8,6,4,0,'2010-02-20 09:44:25',222),(346,21,1,6,3,0,'2010-02-20 09:44:25',219),(347,21,2,6,5,0,'2010-02-20 09:44:25',219),(348,21,3,6,4,0,'2010-02-20 09:44:25',219),(349,21,4,6,4,30,'2010-02-20 09:44:25',219),(350,21,5,6,3,0,'2010-02-20 09:44:25',219),(351,21,6,6,4,0,'2010-02-20 09:44:25',219),(352,21,7,6,4,0,'2010-02-20 09:44:25',219),(353,21,8,6,4,0,'2010-02-20 09:44:25',219),(354,21,1,3,3,0,'2010-02-20 09:44:25',234),(355,21,2,4,4,0,'2010-02-20 09:44:25',234),(356,21,3,3,2,0,'2010-02-20 09:44:25',234),(357,21,4,6,3,12,'2010-02-20 09:44:25',234),(358,21,5,5,3,0,'2010-02-20 09:44:25',234),(359,21,6,4,4,0,'2010-02-20 09:44:25',234),(360,21,7,4,4,0,'2010-02-20 09:44:25',234),(361,21,8,4,4,0,'2010-02-20 09:44:25',234),(362,21,1,3,3,0,'2010-02-20 09:44:25',237),(363,21,2,3,3,0,'2010-02-20 09:44:25',237),(364,21,3,3,3,0,'2010-02-20 09:44:25',237),(365,21,4,3,3,3,'2010-02-20 09:44:25',237),(366,21,5,3,3,0,'2010-02-20 09:44:25',237),(367,21,6,3,3,3,'2010-02-20 09:44:25',237),(368,21,7,3,3,0,'2010-02-20 09:44:25',237),(369,21,8,3,3,0,'2010-02-20 09:44:25',237),(723,23,4,5,3,11,'2010-04-10 04:23:40',264),(722,23,3,3,2,9,'2010-04-10 04:23:40',264),(721,23,2,5,1,0,'2010-04-10 04:23:40',264),(720,23,1,2,1,0,'2010-04-10 04:23:40',264),(719,23,6,5,2,0,'2010-04-10 04:23:40',250),(718,23,5,6,3,0,'2010-04-10 04:23:40',250),(717,23,4,4,3,10,'2010-04-10 04:23:40',250),(716,23,3,4,2,12,'2010-04-10 04:23:40',250),(378,21,1,6,3,0,'2010-02-20 09:55:56',238),(379,21,2,6,3,0,'2010-02-20 09:55:56',238),(380,21,3,6,4,0,'2010-02-20 09:55:56',238),(381,21,4,6,4,26,'2010-02-20 09:55:56',238),(382,21,5,4,2,0,'2010-02-20 09:55:56',238),(383,21,6,4,2,0,'2010-02-20 09:55:56',238),(384,21,7,4,2,0,'2010-02-20 09:55:56',238),(385,21,8,4,2,0,'2010-02-20 09:55:56',238),(715,23,2,6,2,0,'2010-04-10 04:23:40',250),(714,23,1,5,1,0,'2010-04-10 04:23:40',250),(713,23,6,6,3,0,'2010-04-10 04:23:40',278),(712,23,5,5,2,0,'2010-04-10 04:23:40',278),(711,23,4,1,1,5,'2010-04-10 04:23:40',278),(710,23,3,3,2,7,'2010-04-10 04:23:40',278),(709,23,2,2,1,0,'2010-04-10 04:23:40',278),(708,23,1,1,1,0,'2010-04-10 04:23:40',278),(659,22,8,0,0,0,'2010-03-27 10:31:11',246),(658,22,7,0,0,0,'2010-03-27 10:31:10',246),(657,22,6,0,0,0,'2010-03-27 10:31:10',246),(656,22,5,0,0,0,'2010-03-27 10:31:10',246),(655,22,4,0,0,0,'2010-03-27 10:31:10',246),(654,22,3,0,0,0,'2010-03-27 10:31:10',246),(653,22,2,0,0,0,'2010-03-27 10:31:10',246),(652,22,1,4,3,12,'2010-03-27 10:31:10',246),(402,21,1,6,3,0,'2010-02-20 09:57:21',242),(403,21,2,6,3,0,'2010-02-20 09:57:21',242),(404,21,3,6,5,0,'2010-02-20 09:57:21',242),(405,21,4,6,5,29,'2010-02-20 09:57:21',242),(406,21,5,6,2,0,'2010-02-20 09:57:21',242),(407,21,6,6,2,0,'2010-02-20 09:57:21',242),(408,21,7,6,4,0,'2010-02-20 09:57:21',242),(409,21,8,6,4,0,'2010-02-20 09:57:21',242),(651,22,8,0,0,0,'2010-03-27 10:31:10',248),(650,22,7,0,0,0,'2010-03-27 10:31:10',248),(649,22,6,0,0,0,'2010-03-27 10:31:10',248),(648,22,5,0,0,0,'2010-03-27 10:31:10',248),(647,22,4,0,0,0,'2010-03-27 10:31:10',248),(646,22,3,0,0,0,'2010-03-27 10:31:10',248),(645,22,2,0,0,0,'2010-03-27 10:31:10',248),(644,22,1,6,6,0,'2010-03-27 10:31:10',248),(628,18,1,0,0,0,'2010-03-21 05:13:45',212),(629,18,2,0,0,0,'2010-03-21 05:13:45',212),(630,18,3,0,0,0,'2010-03-21 05:13:45',212),(631,18,4,0,0,0,'2010-03-21 05:13:45',212),(632,18,5,0,0,0,'2010-03-21 05:13:45',212),(633,18,6,0,0,0,'2010-03-21 05:13:45',212),(634,18,7,0,0,0,'2010-03-21 05:13:45',212),(635,18,8,0,0,0,'2010-03-21 05:13:45',212),(636,18,1,0,0,0,'2010-03-21 05:13:48',211),(637,18,2,0,0,0,'2010-03-21 05:13:48',211),(638,18,3,0,0,0,'2010-03-21 05:13:48',211),(639,18,4,0,0,0,'2010-03-21 05:13:48',211),(640,18,5,0,0,0,'2010-03-21 05:13:48',211),(641,18,6,0,0,0,'2010-03-21 05:13:48',211),(642,18,7,0,0,0,'2010-03-21 05:13:48',211),(643,18,8,0,0,0,'2010-03-21 05:13:48',211),(1024,23,5,6,3,0,'2010-04-10 06:02:15',299),(1025,23,6,6,3,0,'2010-04-10 06:02:15',299),(1116,23,1,6,3,0,'2010-04-10 06:39:00',298),(1117,23,2,6,2,0,'2010-04-10 06:39:00',298),(1118,23,3,6,3,16,'2010-04-10 06:39:00',298),(1119,23,4,6,3,19,'2010-04-10 06:39:00',298),(1120,23,5,6,3,0,'2010-04-10 06:39:00',298),(1121,23,6,6,3,0,'2010-04-10 06:39:00',298),(1122,23,1,6,3,0,'2010-04-10 06:39:00',303),(1123,23,2,6,2,0,'2010-04-10 06:39:00',303),(1124,23,3,5,3,15,'2010-04-10 06:39:00',303),(1125,23,4,6,3,15,'2010-04-10 06:39:00',303),(1126,23,5,6,3,0,'2010-04-10 06:39:00',303),(1127,23,6,6,3,0,'2010-04-10 06:39:00',303),(1128,23,1,5,3,0,'2010-04-10 06:39:00',300),(1129,23,2,5,1,0,'2010-04-10 06:39:00',300),(1130,23,3,4,3,10,'2010-04-10 06:39:00',300),(1131,23,4,2,1,9,'2010-04-10 06:39:00',300),(1132,23,5,5,2,0,'2010-04-10 06:39:00',300),(1133,23,6,6,3,0,'2010-04-10 06:39:00',300),(1044,23,1,5,3,0,'2010-04-10 06:09:35',295),(1045,23,2,2,2,0,'2010-04-10 06:09:35',295),(1046,23,3,5,3,12,'2010-04-10 06:09:35',295),(1047,23,4,2,1,8,'2010-04-10 06:09:35',295),(1048,23,5,2,1,0,'2010-04-10 06:09:35',295),(1049,23,6,6,3,0,'2010-04-10 06:09:35',295),(1050,23,1,6,3,0,'2010-04-10 06:09:35',297),(1051,23,2,4,2,0,'2010-04-10 06:09:35',297),(1052,23,3,5,3,15,'2010-04-10 06:09:35',297),(1053,23,4,6,3,15,'2010-04-10 06:09:35',297),(1054,23,5,5,2,0,'2010-04-10 06:09:35',297),(1055,23,6,4,2,0,'2010-04-10 06:09:35',297),(1056,23,1,2,2,0,'2010-04-10 06:09:35',290),(1057,23,2,2,2,0,'2010-04-10 06:09:35',290),(1058,23,3,2,2,1,'2010-04-10 06:09:35',290),(1059,23,4,3,1,9,'2010-04-10 06:09:35',290),(1060,23,5,3,2,0,'2010-04-10 06:09:35',290),(1061,23,6,4,3,0,'2010-04-10 06:09:35',290),(1062,23,1,4,2,0,'2010-04-10 06:09:35',282),(1063,23,2,4,1,0,'2010-04-10 06:09:35',282),(1064,23,3,6,3,18,'2010-04-10 06:09:35',282),(1065,23,4,4,2,11,'2010-04-10 06:09:35',282),(1066,23,5,6,3,0,'2010-04-10 06:09:35',282),(1067,23,6,6,3,0,'2010-04-10 06:09:35',282),(1068,23,1,6,3,0,'2010-04-10 06:11:15',273),(1069,23,2,6,2,0,'2010-04-10 06:11:15',273),(1070,23,3,6,3,18,'2010-04-10 06:11:15',273),(1071,23,4,6,3,20,'2010-04-10 06:11:15',273),(1072,23,5,6,3,0,'2010-04-10 06:11:15',273),(1073,23,6,6,3,0,'2010-04-10 06:11:15',273),(1074,23,1,5,3,0,'2010-04-10 06:11:15',296),(1075,23,2,1,1,0,'2010-04-10 06:11:15',296),(1076,23,3,3,2,9,'2010-04-10 06:11:15',296),(1077,23,4,4,3,8,'2010-04-10 06:11:15',296),(1078,23,5,4,2,0,'2010-04-10 06:11:15',296),(1079,23,6,6,3,0,'2010-04-10 06:11:15',296),(1080,23,1,2,1,0,'2010-04-10 06:11:15',294),(1081,23,2,1,1,0,'2010-04-10 06:11:15',294),(1082,23,3,2,1,6,'2010-04-10 06:11:15',294),(1083,23,4,3,2,8,'2010-04-10 06:11:15',294),(1084,23,5,1,1,0,'2010-04-10 06:11:15',294),(1085,23,6,2,2,0,'2010-04-10 06:11:15',294),(1086,23,1,6,3,0,'2010-04-10 06:11:15',271),(1087,23,2,6,2,0,'2010-04-10 06:11:15',271),(1088,23,3,4,1,8,'2010-04-10 06:11:15',271),(1089,23,4,4,2,10,'2010-04-10 06:11:15',271),(1090,23,5,5,2,0,'2010-04-10 06:11:15',271),(1091,23,6,5,3,0,'2010-04-10 06:11:15',271),(1092,23,1,3,2,0,'2010-04-10 06:25:07',301),(1093,23,2,2,1,0,'2010-04-10 06:25:07',301),(1094,23,3,1,1,4,'2010-04-10 06:25:07',301),(1095,23,4,2,1,3,'2010-04-10 06:25:07',301),(1096,23,5,4,2,0,'2010-04-10 06:25:07',301),(1097,23,6,5,3,0,'2010-04-10 06:25:07',301),(1098,23,1,4,3,0,'2010-04-10 06:25:07',305),(1099,23,2,3,2,0,'2010-04-10 06:25:07',305),(1100,23,3,3,2,3,'2010-04-10 06:25:07',305),(1101,23,4,0,0,0,'2010-04-10 06:25:07',305),(1102,23,5,2,2,0,'2010-04-10 06:25:07',305),(1103,23,6,4,3,0,'2010-04-10 06:25:07',305),(1104,23,1,6,3,0,'2010-04-10 06:25:07',267),(1105,23,2,4,1,0,'2010-04-10 06:25:07',267),(1106,23,3,5,2,12,'2010-04-10 06:25:07',267),(1107,23,4,6,3,11,'2010-04-10 06:25:07',267),(1108,23,5,4,2,0,'2010-04-10 06:25:07',267),(1109,23,6,4,3,0,'2010-04-10 06:25:07',267),(1110,23,1,6,3,0,'2010-04-10 06:39:00',310),(1111,23,2,6,2,0,'2010-04-10 06:39:00',310),(1112,23,3,6,3,17,'2010-04-10 06:39:00',310),(1113,23,4,5,3,13,'2010-04-10 06:39:00',310),(1114,23,5,6,3,0,'2010-04-10 06:39:00',310),(1115,23,6,6,3,0,'2010-04-10 06:39:00',310),(1230,23,1,4,3,0,'2010-04-10 07:53:17',311),(1231,23,2,4,1,0,'2010-04-10 07:53:17',311),(1232,23,3,2,1,6,'2010-04-10 07:53:17',311),(1233,23,4,0,0,0,'2010-04-10 07:53:17',311),(1234,23,5,4,2,0,'2010-04-10 07:53:17',311),(1235,23,6,6,3,0,'2010-04-10 07:53:17',311),(1182,23,1,3,2,0,'2010-04-10 07:33:27',306),(1183,23,2,3,1,0,'2010-04-10 07:33:27',306),(1184,23,3,3,2,11,'2010-04-10 07:33:27',306),(1185,23,4,5,2,14,'2010-04-10 07:33:27',306),(1186,23,5,5,3,0,'2010-04-10 07:33:27',306),(1187,23,6,4,2,0,'2010-04-10 07:33:27',306),(1254,23,1,5,3,0,'2010-04-10 07:53:58',308),(1255,23,2,6,2,0,'2010-04-10 07:53:58',308),(1256,23,3,6,3,16,'2010-04-10 07:53:58',308),(1257,23,4,4,2,7,'2010-04-10 07:53:58',308),(1258,23,5,6,3,0,'2010-04-10 07:53:58',308),(1259,23,6,5,3,0,'2010-04-10 07:53:58',308),(1260,23,1,6,3,0,'2010-04-10 07:53:58',309),(1261,23,2,5,1,0,'2010-04-10 07:53:58',309),(1262,23,3,6,3,17,'2010-04-10 07:53:58',309),(1263,23,4,5,2,7,'2010-04-10 07:53:58',309),(1264,23,5,6,3,0,'2010-04-10 07:53:58',309),(1265,23,6,6,3,0,'2010-04-10 07:53:58',309),(1266,23,1,4,3,0,'2010-04-10 07:53:58',312),(1267,23,2,0,0,0,'2010-04-10 07:53:58',312),(1268,23,3,5,2,14,'2010-04-10 07:53:58',312),(1269,23,4,2,2,4,'2010-04-10 07:53:58',312),(1270,23,5,4,2,0,'2010-04-10 07:53:58',312),(1271,23,6,3,2,0,'2010-04-10 07:53:58',312),(1206,23,1,6,3,0,'2010-04-10 07:40:19',274),(1207,23,2,6,2,0,'2010-04-10 07:40:19',274),(1208,23,3,6,3,18,'2010-04-10 07:40:19',274),(1209,23,4,6,3,13,'2010-04-10 07:40:19',274),(1210,23,5,5,2,0,'2010-04-10 07:40:19',274),(1211,23,6,6,3,0,'2010-04-10 07:40:19',274),(1212,23,1,6,3,0,'2010-04-10 07:40:19',304),(1213,23,2,6,2,0,'2010-04-10 07:40:19',304),(1214,23,3,6,3,17,'2010-04-10 07:40:19',304),(1215,23,4,5,3,13,'2010-04-10 07:40:19',304),(1216,23,5,6,3,0,'2010-04-10 07:40:20',304),(1217,23,6,6,3,0,'2010-04-10 07:40:20',304),(1218,23,1,2,2,0,'2010-04-10 07:40:20',288),(1219,23,2,4,2,0,'2010-04-10 07:40:20',288),(1220,23,3,1,1,3,'2010-04-10 07:40:20',288),(1221,23,4,1,1,1,'2010-04-10 07:40:20',288),(1222,23,5,0,0,0,'2010-04-10 07:40:20',288),(1223,23,6,0,0,0,'2010-04-10 07:40:20',288),(1224,23,1,2,1,0,'2010-04-10 07:53:17',313),(1225,23,2,2,1,0,'2010-04-10 07:53:17',313),(1226,23,3,5,3,14,'2010-04-10 07:53:17',313),(1227,23,4,3,2,3,'2010-04-10 07:53:17',313),(1228,23,5,4,2,0,'2010-04-10 07:53:17',313),(1229,23,6,5,3,0,'2010-04-10 07:53:17',313),(1248,23,1,3,2,0,'2010-04-10 07:53:58',314),(1249,23,2,3,1,0,'2010-04-10 07:53:58',314),(1250,23,3,3,2,20,'2010-04-10 07:53:58',314),(1251,23,4,5,2,5,'2010-04-10 07:53:58',314),(1252,23,5,5,3,0,'2010-04-10 07:53:58',314),(1253,23,6,4,2,0,'2010-04-10 07:53:58',314),(1284,23,1,3,2,0,'2010-04-10 09:18:53',315),(1285,23,2,6,2,0,'2010-04-10 09:18:53',315),(1286,23,3,1,1,10,'2010-04-10 09:18:53',315),(1287,23,4,6,3,7,'2010-04-10 09:18:53',315),(1288,23,5,5,3,0,'2010-04-10 09:18:53',315),(1289,23,6,4,3,0,'2010-04-10 09:18:53',315),(1290,25,1,6,6,0,'2010-06-22 18:13:31',342),(1291,25,2,5,3,0,'2010-06-22 18:13:31',342),(1292,25,3,6,3,13,'2010-06-22 18:13:31',342),(1293,25,4,6,1,0,'2010-06-22 18:13:31',342),(1294,25,5,6,6,0,'2010-06-22 18:13:31',342),(1295,25,6,6,5,24,'2010-06-22 18:13:31',342),(1296,25,7,6,4,0,'2010-06-22 18:13:31',342),(1297,25,8,6,4,0,'2010-06-22 18:13:31',342),(1298,25,9,5,4,0,'2010-06-22 18:13:31',342),(1299,25,10,5,2,0,'2010-06-22 18:13:31',342),(1300,25,1,6,6,0,'2010-06-22 18:13:31',340),(1301,25,2,5,3,0,'2010-06-22 18:13:31',340),(1302,25,3,6,3,13,'2010-06-22 18:13:31',340),(1303,25,4,6,1,0,'2010-06-22 18:13:31',340),(1304,25,5,4,4,0,'2010-06-22 18:13:31',340),(1305,25,6,6,5,20,'2010-06-22 18:13:31',340),(1306,25,7,6,4,0,'2010-06-22 18:13:31',340),(1307,25,8,6,4,0,'2010-06-22 18:13:31',340),(1308,25,9,6,4,0,'2010-06-22 18:13:31',340),(1309,25,10,6,3,0,'2010-06-22 18:13:31',340),(1310,25,1,6,6,0,'2010-06-22 18:13:31',318),(1311,25,2,5,3,0,'2010-06-22 18:13:31',318),(1312,25,3,6,3,13,'2010-06-22 18:13:31',318),(1313,25,4,6,1,0,'2010-06-22 18:13:31',318),(1314,25,5,6,6,0,'2010-06-22 18:13:31',318),(1315,25,6,6,5,26,'2010-06-22 18:13:31',318),(1316,25,7,6,4,0,'2010-06-22 18:13:31',318),(1317,25,8,0,0,0,'2010-06-22 18:13:31',318),(1318,25,9,6,4,0,'2010-06-22 18:13:31',318),(1319,25,10,5,3,0,'2010-06-22 18:13:31',318),(1320,25,1,5,5,0,'2010-06-22 18:13:31',357),(1321,25,2,6,3,0,'2010-06-22 18:13:31',357),(1322,25,3,5,2,13,'2010-06-22 18:13:31',357),(1323,25,4,6,1,0,'2010-06-22 18:13:31',357),(1324,25,5,6,5,0,'2010-06-22 18:13:31',357),(1325,25,6,4,3,10,'2010-06-22 18:13:31',357),(1326,25,7,4,3,0,'2010-06-22 18:13:31',357),(1327,25,8,6,4,0,'2010-06-22 18:13:31',357),(1328,25,9,5,4,0,'2010-06-22 18:13:31',357),(1329,25,10,4,2,0,'2010-06-22 18:13:31',357),(1330,25,1,2,2,0,'2010-06-22 19:17:01',352),(1331,25,2,6,3,0,'2010-06-22 19:17:01',352),(1332,25,3,5,2,15,'2010-06-22 19:17:01',352),(1333,25,4,5,1,0,'2010-06-22 19:17:01',352),(1334,25,5,3,3,0,'2010-06-22 19:17:01',352),(1335,25,6,5,4,0,'2010-06-22 19:17:01',352),(1336,25,7,4,3,0,'2010-06-22 19:17:01',352),(1337,25,8,4,2,0,'2010-06-22 19:17:01',352),(1338,25,9,4,3,0,'2010-06-22 19:17:01',352),(1339,25,10,3,2,0,'2010-06-22 19:17:01',352),(1340,25,1,4,4,0,'2010-06-22 19:17:01',351),(1341,25,2,6,4,0,'2010-06-22 19:17:01',351),(1342,25,3,6,3,21,'2010-06-22 19:17:01',351),(1343,25,4,6,1,0,'2010-06-22 19:17:01',351),(1344,25,5,6,6,0,'2010-06-22 19:17:01',351),(1345,25,6,6,5,0,'2010-06-22 19:17:01',351),(1346,25,7,1,1,0,'2010-06-22 19:17:01',351),(1347,25,8,6,4,0,'2010-06-22 19:17:01',351),(1348,25,9,6,4,0,'2010-06-22 19:17:01',351),(1349,25,10,0,0,0,'2010-06-22 19:17:01',351),(1350,25,1,5,5,0,'2010-06-22 19:17:01',353),(1351,25,2,3,2,0,'2010-06-22 19:17:01',353),(1352,25,3,6,3,17,'2010-06-22 19:17:01',353),(1353,25,4,6,1,0,'2010-06-22 19:17:01',353),(1354,25,5,1,1,0,'2010-06-22 19:17:01',353),(1355,25,6,6,5,0,'2010-06-22 19:17:01',353),(1356,25,7,5,3,0,'2010-06-22 19:17:01',353),(1357,25,8,6,4,0,'2010-06-22 19:17:01',353),(1358,25,9,1,1,0,'2010-06-22 19:17:01',353),(1359,25,10,4,2,0,'2010-06-22 19:17:01',353),(1360,25,1,3,2,0,'2010-06-22 19:17:01',322),(1361,25,2,2,2,0,'2010-06-22 19:17:01',322),(1362,25,3,3,2,6,'2010-06-22 19:17:01',322),(1363,25,4,6,1,0,'2010-06-22 19:17:01',322),(1364,25,5,2,2,0,'2010-06-22 19:17:01',322),(1365,25,6,0,0,0,'2010-06-22 19:17:01',322),(1366,25,7,1,1,0,'2010-06-22 19:17:01',322),(1367,25,8,2,1,0,'2010-06-22 19:17:01',322),(1368,25,9,2,1,0,'2010-06-22 19:17:01',322),(1369,25,10,1,1,0,'2010-06-22 19:17:01',322),(1370,25,1,5,5,0,'2010-06-22 19:31:52',334),(1371,25,2,6,3,0,'2010-06-22 19:31:52',334),(1372,25,3,6,3,14,'2010-06-22 19:31:52',334),(1373,25,4,6,1,0,'2010-06-22 19:31:52',334),(1374,25,5,6,5,0,'2010-06-22 19:31:52',334),(1375,25,6,4,3,18,'2010-06-22 19:31:52',334),(1376,25,7,6,4,0,'2010-06-22 19:31:52',334),(1377,25,8,5,3,0,'2010-06-22 19:31:52',334),(1378,25,9,5,3,0,'2010-06-22 19:31:52',334),(1379,25,10,5,1,0,'2010-06-22 19:31:52',334),(1380,25,1,6,6,0,'2010-06-22 19:31:52',367),(1381,25,2,5,3,0,'2010-06-22 19:31:52',367),(1382,25,3,6,3,19,'2010-06-22 19:31:52',367),(1383,25,4,6,1,0,'2010-06-22 19:31:52',367),(1384,25,5,6,6,0,'2010-06-22 19:31:52',367),(1385,25,6,6,5,24,'2010-06-22 19:31:52',367),(1386,25,7,5,4,0,'2010-06-22 19:31:52',367),(1387,25,8,6,4,0,'2010-06-22 19:31:52',367),(1388,25,9,6,4,0,'2010-06-22 19:31:52',367),(1389,25,10,1,1,0,'2010-06-22 19:31:52',367),(1390,25,1,3,3,0,'2010-06-22 19:31:52',359),(1391,25,2,3,2,0,'2010-06-22 19:31:52',359),(1392,25,3,4,2,10,'2010-06-22 19:31:52',359),(1393,25,4,6,1,0,'2010-06-22 19:31:52',359),(1394,25,5,1,1,0,'2010-06-22 19:31:52',359),(1395,25,6,3,2,8,'2010-06-22 19:31:52',359),(1396,25,7,3,2,0,'2010-06-22 19:31:52',359),(1397,25,8,0,0,0,'2010-06-22 19:31:52',359),(1398,25,9,1,1,0,'2010-06-22 19:31:52',359),(1399,25,10,5,3,0,'2010-06-22 19:31:52',359),(1400,25,1,4,3,0,'2010-06-22 19:31:53',355),(1401,25,2,5,2,0,'2010-06-22 19:31:53',355),(1402,25,3,2,2,4,'2010-06-22 19:31:53',355),(1403,25,4,3,1,0,'2010-06-22 19:31:53',355),(1404,25,5,4,1,0,'2010-06-22 19:31:53',355),(1405,25,6,5,3,12,'2010-06-22 19:31:53',355),(1406,25,7,6,2,0,'2010-06-22 19:31:53',355),(1407,25,8,4,3,0,'2010-06-22 19:31:53',355),(1408,25,9,4,2,0,'2010-06-22 19:31:53',355),(1409,25,10,4,2,0,'2010-06-22 19:31:53',355),(1410,25,1,6,6,0,'2010-06-22 19:35:14',350),(1411,25,2,6,3,0,'2010-06-22 19:35:14',350),(1412,25,3,5,2,17,'2010-06-22 19:35:14',350),(1413,25,4,6,1,0,'2010-06-22 19:35:14',350),(1414,25,5,6,6,0,'2010-06-22 19:35:14',350),(1415,25,6,5,4,21,'2010-06-22 19:35:14',350),(1416,25,7,6,4,0,'2010-06-22 19:35:14',350),(1417,25,8,6,4,0,'2010-06-22 19:35:14',350),(1418,25,9,6,4,0,'2010-06-22 19:35:14',350),(1419,25,10,5,3,0,'2010-06-22 19:35:15',350),(1420,25,1,6,6,0,'2010-06-22 19:35:15',349),(1421,25,2,5,3,0,'2010-06-22 19:35:15',349),(1422,25,3,6,3,22,'2010-06-22 19:35:15',349),(1423,25,4,6,1,0,'2010-06-22 19:35:15',349),(1424,25,5,2,2,0,'2010-06-22 19:35:15',349),(1425,25,6,6,5,20,'2010-06-22 19:35:15',349),(1426,25,7,5,3,0,'2010-06-22 19:35:15',349),(1427,25,8,5,4,0,'2010-06-22 19:35:15',349),(1428,25,9,4,3,0,'2010-06-22 19:35:15',349),(1429,25,10,5,3,0,'2010-06-22 19:35:15',349),(1430,25,1,6,6,0,'2010-06-22 19:35:15',329),(1431,25,2,3,2,0,'2010-06-22 19:35:15',329),(1432,25,3,5,3,10,'2010-06-22 19:35:15',329),(1433,25,4,6,1,0,'2010-06-22 19:35:15',329),(1434,25,5,3,3,0,'2010-06-22 19:35:15',329),(1435,25,6,5,4,11,'2010-06-22 19:35:15',329),(1436,25,7,4,3,0,'2010-06-22 19:35:15',329),(1437,25,8,5,3,0,'2010-06-22 19:35:15',329),(1438,25,9,6,4,0,'2010-06-22 19:35:15',329),(1439,25,10,4,2,0,'2010-06-22 19:35:15',329),(1440,25,1,4,3,0,'2010-06-22 19:35:15',328),(1441,25,2,3,2,0,'2010-06-22 19:35:15',328),(1442,25,3,6,6,20,'2010-06-22 19:35:15',328),(1443,25,4,6,1,0,'2010-06-22 19:35:15',328),(1444,25,5,4,2,0,'2010-06-22 19:35:15',328),(1445,25,6,2,2,6,'2010-06-22 19:35:15',328),(1446,25,7,5,4,0,'2010-06-22 19:35:15',328),(1447,25,8,4,3,0,'2010-06-22 19:35:15',328),(1448,25,9,3,2,0,'2010-06-22 19:35:15',328),(1449,25,10,3,1,0,'2010-06-22 19:35:15',328),(1450,25,1,5,5,0,'2010-06-22 19:36:36',323),(1451,25,2,5,3,0,'2010-06-22 19:36:36',323),(1452,25,3,2,1,0,'2010-06-22 19:36:36',323),(1453,25,4,6,1,0,'2010-06-22 19:36:36',323),(1454,25,5,5,5,0,'2010-06-22 19:36:36',323),(1455,25,6,5,5,18,'2010-06-22 19:36:36',323),(1456,25,7,5,4,0,'2010-06-22 19:36:36',323),(1457,25,8,5,4,0,'2010-06-22 19:36:36',323),(1458,25,9,3,2,0,'2010-06-22 19:36:36',323),(1459,25,10,1,1,0,'2010-06-22 19:36:36',323),(1460,25,1,6,6,0,'2010-06-22 19:37:06',344),(1461,25,2,5,3,0,'2010-06-22 19:37:06',344),(1462,25,3,5,3,0,'2010-06-22 19:37:06',344),(1463,25,4,6,1,0,'2010-06-22 19:37:06',344),(1464,25,5,4,4,0,'2010-06-22 19:37:06',344),(1465,25,6,5,5,14,'2010-06-22 19:37:06',344),(1466,25,7,6,4,0,'2010-06-22 19:37:06',344),(1467,25,8,6,4,0,'2010-06-22 19:37:06',344),(1468,25,9,6,4,0,'2010-06-22 19:37:06',344),(1469,25,10,0,0,0,'2010-06-22 19:37:06',344),(1470,25,1,4,4,0,'2010-06-22 20:03:40',346),(1471,25,2,6,3,0,'2010-06-22 20:03:40',346),(1472,25,3,6,3,17,'2010-06-22 20:03:40',346),(1473,25,4,6,1,0,'2010-06-22 20:03:40',346),(1474,25,5,5,5,0,'2010-06-22 20:03:40',346),(1475,25,6,5,4,15,'2010-06-22 20:03:40',346),(1476,25,7,5,4,0,'2010-06-22 20:03:40',346),(1477,25,8,5,4,0,'2010-06-22 20:03:40',346),(1478,25,9,6,4,0,'2010-06-22 20:03:40',346),(1479,25,10,1,1,0,'2010-06-22 20:03:40',346),(1480,25,1,5,1,0,'2010-06-22 20:03:40',333),(1481,25,2,6,3,0,'2010-06-22 20:03:40',333),(1482,25,3,5,3,16,'2010-06-22 20:03:40',333),(1483,25,4,3,3,0,'2010-06-22 20:03:40',333),(1484,25,5,3,3,0,'2010-06-22 20:03:40',333),(1485,25,6,3,3,4,'2010-06-22 20:03:40',333),(1486,25,7,3,2,0,'2010-06-22 20:03:40',333),(1487,25,8,4,1,0,'2010-06-22 20:03:40',333),(1488,25,9,3,2,0,'2010-06-22 20:03:40',333),(1489,25,10,1,1,0,'2010-06-22 20:03:40',333),(1490,25,1,1,1,0,'2010-06-22 20:03:40',336),(1491,25,2,5,3,0,'2010-06-22 20:03:40',336),(1492,25,3,3,2,8,'2010-06-22 20:03:40',336),(1493,25,4,6,1,0,'2010-06-22 20:03:40',336),(1494,25,5,2,2,0,'2010-06-22 20:03:40',336),(1495,25,6,6,5,21,'2010-06-22 20:03:40',336),(1496,25,7,3,3,0,'2010-06-22 20:03:40',336),(1497,25,8,5,3,0,'2010-06-22 20:03:40',336),(1498,25,9,4,2,0,'2010-06-22 20:03:40',336),(1499,25,10,3,2,0,'2010-06-22 20:03:40',336),(1500,25,1,4,4,0,'2010-06-22 20:03:40',327),(1501,25,2,4,2,0,'2010-06-22 20:03:40',327),(1502,25,3,2,1,5,'2010-06-22 20:03:40',327),(1503,25,4,5,1,0,'2010-06-22 20:03:40',327),(1504,25,5,3,3,0,'2010-06-22 20:03:40',327),(1505,25,6,2,2,6,'2010-06-22 20:03:40',327),(1506,25,7,4,2,0,'2010-06-22 20:03:40',327),(1507,25,8,5,3,0,'2010-06-22 20:03:40',327),(1508,25,9,3,3,0,'2010-06-22 20:03:40',327),(1509,25,10,3,2,0,'2010-06-22 20:03:40',327),(1510,25,1,5,5,0,'2010-06-22 20:18:36',365),(1511,25,2,5,3,0,'2010-06-22 20:18:36',365),(1512,25,3,5,2,17,'2010-06-22 20:18:36',365),(1513,25,4,6,1,0,'2010-06-22 20:18:36',365),(1514,25,5,1,1,0,'2010-06-22 20:18:36',365),(1515,25,6,6,5,13,'2010-06-22 20:18:36',365),(1516,25,7,5,3,0,'2010-06-22 20:18:36',365),(1517,25,8,5,4,0,'2010-06-22 20:18:36',365),(1518,25,9,3,3,0,'2010-06-22 20:18:36',365),(1519,25,10,3,2,0,'2010-06-22 20:18:36',365),(1520,25,1,4,4,0,'2010-06-22 20:18:36',364),(1521,25,2,4,3,0,'2010-06-22 20:18:36',364),(1522,25,3,5,2,18,'2010-06-22 20:18:36',364),(1523,25,4,6,1,0,'2010-06-22 20:18:36',364),(1524,25,5,1,1,0,'2010-06-22 20:18:36',364),(1525,25,6,1,1,3,'2010-06-22 20:18:36',364),(1526,25,7,4,3,0,'2010-06-22 20:18:36',364),(1527,25,8,3,2,0,'2010-06-22 20:18:36',364),(1528,25,9,4,3,0,'2010-06-22 20:18:36',364),(1529,25,10,0,0,0,'2010-06-22 20:18:36',364),(1530,25,1,6,6,0,'2010-06-22 20:18:36',366),(1531,25,2,4,2,0,'2010-06-22 20:18:36',366),(1532,25,3,3,2,5,'2010-06-22 20:18:36',366),(1533,25,4,3,1,0,'2010-06-22 20:18:36',366),(1534,25,5,2,2,0,'2010-06-22 20:18:36',366),(1535,25,6,3,3,7,'2010-06-22 20:18:36',366),(1536,25,7,1,1,0,'2010-06-22 20:18:36',366),(1537,25,8,6,4,0,'2010-06-22 20:18:36',366),(1538,25,9,6,4,0,'2010-06-22 20:18:36',366),(1539,25,10,5,3,0,'2010-06-22 20:18:36',366),(1540,25,1,2,2,0,'2010-06-22 20:30:00',362),(1541,25,2,4,2,0,'2010-06-22 20:30:00',362),(1542,25,3,5,2,11,'2010-06-22 20:30:00',362),(1543,25,4,1,1,0,'2010-06-22 20:30:00',362),(1544,25,5,5,4,0,'2010-06-22 20:30:00',362),(1545,25,6,3,3,12,'2010-06-22 20:30:00',362),(1546,25,7,3,3,0,'2010-06-22 20:30:00',362),(1547,25,8,4,3,0,'2010-06-22 20:30:00',362),(1548,25,9,4,2,0,'2010-06-22 20:30:00',362),(1549,25,10,0,0,0,'2010-06-22 20:30:00',362),(1550,25,1,5,5,0,'2010-06-22 20:30:00',368),(1551,25,2,3,2,0,'2010-06-22 20:30:00',368),(1552,25,3,4,2,10,'2010-06-22 20:30:00',368),(1553,25,4,6,1,0,'2010-06-22 20:30:00',368),(1554,25,5,2,2,0,'2010-06-22 20:30:00',368),(1555,25,6,6,5,24,'2010-06-22 20:30:00',368),(1556,25,7,3,3,0,'2010-06-22 20:30:00',368),(1557,25,8,5,4,0,'2010-06-22 20:30:00',368),(1558,25,9,3,2,0,'2010-06-22 20:30:00',368),(1559,25,10,0,0,0,'2010-06-22 20:30:00',368),(1560,25,1,5,5,0,'2010-06-22 20:30:01',363),(1561,25,2,6,3,0,'2010-06-22 20:30:01',363),(1562,25,3,6,3,14,'2010-06-22 20:30:01',363),(1563,25,4,6,1,0,'2010-06-22 20:30:01',363),(1564,25,5,5,5,0,'2010-06-22 20:30:01',363),(1565,25,6,4,3,16,'2010-06-22 20:30:01',363),(1566,25,7,5,3,0,'2010-06-22 20:30:01',363),(1567,25,8,6,4,0,'2010-06-22 20:30:01',363),(1568,25,9,5,4,0,'2010-06-22 20:30:01',363),(1569,25,10,0,0,0,'2010-06-22 20:30:01',363),(1570,25,1,6,6,0,'2010-06-22 20:30:01',354),(1571,25,2,6,3,0,'2010-06-22 20:30:01',354),(1572,25,3,6,3,17,'2010-06-22 20:30:01',354),(1573,25,4,5,1,0,'2010-06-22 20:30:01',354),(1574,25,5,3,3,0,'2010-06-22 20:30:01',354),(1575,25,6,6,5,18,'2010-06-22 20:30:01',354),(1576,25,7,6,4,0,'2010-06-22 20:30:01',354),(1577,25,8,6,4,0,'2010-06-22 20:30:01',354),(1578,25,9,6,4,0,'2010-06-22 20:30:01',354),(1579,25,10,0,0,0,'2010-06-22 20:30:01',354),(1580,25,1,6,6,0,'2010-06-22 21:20:07',343),(1581,25,2,6,3,0,'2010-06-22 21:20:07',343),(1582,25,3,6,3,22,'2010-06-22 21:20:07',343),(1583,25,4,5,1,0,'2010-06-22 21:20:07',343),(1584,25,5,5,5,0,'2010-06-22 21:20:07',343),(1585,25,6,6,5,26,'2010-06-22 21:20:07',343),(1586,25,7,6,4,0,'2010-06-22 21:20:07',343),(1587,25,8,6,4,0,'2010-06-22 21:20:07',343),(1588,25,9,6,4,0,'2010-06-22 21:20:07',343),(1589,25,10,5,2,0,'2010-06-22 21:20:07',343),(1590,25,1,2,2,0,'2010-06-22 21:20:07',370),(1591,25,2,3,3,0,'2010-06-22 21:20:07',370),(1592,25,3,5,2,10,'2010-06-22 21:20:07',370),(1593,25,4,4,1,0,'2010-06-22 21:20:07',370),(1594,25,5,1,1,0,'2010-06-22 21:20:07',370),(1595,25,6,0,0,0,'2010-06-22 21:20:07',370),(1596,25,7,2,2,0,'2010-06-22 21:20:07',370),(1597,25,8,2,1,0,'2010-06-22 21:20:07',370),(1598,25,9,1,1,0,'2010-06-22 21:20:07',370),(1599,25,10,0,0,0,'2010-06-22 21:20:07',370),(1600,25,1,6,6,0,'2010-06-22 21:20:07',341),(1601,25,2,5,3,0,'2010-06-22 21:20:07',341),(1602,25,3,5,3,12,'2010-06-22 21:20:07',341),(1603,25,4,5,1,0,'2010-06-22 21:20:07',341),(1604,25,5,5,5,0,'2010-06-22 21:20:07',341),(1605,25,6,6,5,22,'2010-06-22 21:20:07',341),(1606,25,7,6,4,0,'2010-06-22 21:20:07',341),(1607,25,8,5,4,0,'2010-06-22 21:20:07',341),(1608,25,9,5,3,0,'2010-06-22 21:20:07',341),(1609,25,10,4,3,0,'2010-06-22 21:20:07',341),(1610,25,1,6,6,0,'2010-06-22 21:21:35',369),(1611,25,2,5,3,0,'2010-06-22 21:21:35',369),(1612,25,3,5,3,16,'2010-06-22 21:21:35',369),(1613,25,4,6,1,0,'2010-06-22 21:21:35',369),(1614,25,5,6,6,0,'2010-06-22 21:21:35',369),(1615,25,6,6,5,15,'2010-06-22 21:21:35',369),(1616,25,7,6,4,0,'2010-06-22 21:21:35',369),(1617,25,8,5,4,0,'2010-06-22 21:21:35',369),(1618,25,9,5,3,0,'2010-06-22 21:21:35',369),(1619,25,10,1,1,0,'2010-06-22 21:21:35',369),(1620,25,1,0,0,0,'2010-06-22 21:22:46',347),(1621,25,2,0,0,0,'2010-06-22 21:22:46',347),(1622,25,3,0,0,0,'2010-06-22 21:22:46',347),(1623,25,4,0,0,0,'2010-06-22 21:22:46',347),(1624,25,5,0,0,0,'2010-06-22 21:22:46',347),(1625,25,6,0,0,0,'2010-06-22 21:22:46',347),(1626,25,7,0,0,0,'2010-06-22 21:22:46',347),(1627,25,8,0,0,0,'2010-06-22 21:22:46',347),(1628,25,9,0,0,0,'2010-06-22 21:22:46',347),(1629,25,10,0,0,0,'2010-06-22 21:22:46',347),(1630,25,1,5,5,0,'2010-06-22 21:22:46',348),(1631,25,2,5,3,0,'2010-06-22 21:22:46',348),(1632,25,3,4,3,11,'2010-06-22 21:22:46',348),(1633,25,4,6,1,0,'2010-06-22 21:22:46',348),(1634,25,5,2,2,0,'2010-06-22 21:22:46',348),(1635,25,6,6,5,24,'2010-06-22 21:22:46',348),(1636,25,7,0,0,0,'2010-06-22 21:22:46',348),(1637,25,8,6,4,0,'2010-06-22 21:22:46',348),(1638,25,9,6,4,0,'2010-06-22 21:22:46',348),(1639,25,10,0,0,0,'2010-06-22 21:22:46',348),(1640,25,1,0,0,0,'2010-06-22 21:22:46',326),(1641,25,2,0,0,0,'2010-06-22 21:22:46',326),(1642,25,3,0,0,0,'2010-06-22 21:22:46',326),(1643,25,4,0,0,0,'2010-06-22 21:22:46',326),(1644,25,5,0,0,0,'2010-06-22 21:22:46',326),(1645,25,6,0,0,0,'2010-06-22 21:22:46',326),(1646,25,7,0,0,0,'2010-06-22 21:22:46',326),(1647,25,8,0,0,0,'2010-06-22 21:22:46',326),(1648,25,9,0,0,0,'2010-06-22 21:22:46',326),(1649,25,10,0,0,0,'2010-06-22 21:22:46',326),(1650,25,1,5,4,0,'2010-06-22 21:22:46',373),(1651,25,2,3,3,0,'2010-06-22 21:22:46',373),(1652,25,3,3,2,14,'2010-06-22 21:22:46',373),(1653,25,4,6,1,0,'2010-06-22 21:22:46',373),(1654,25,5,1,1,0,'2010-06-22 21:22:46',373),(1655,25,6,3,2,7,'2010-06-22 21:22:46',373),(1656,25,7,6,2,0,'2010-06-22 21:22:46',373),(1657,25,8,4,3,0,'2010-06-22 21:22:46',373),(1658,25,9,2,1,0,'2010-06-22 21:22:46',373),(1659,25,10,0,0,0,'2010-06-22 21:22:46',373),(1660,25,1,2,2,0,'2010-06-22 21:23:22',374),(1661,25,2,1,1,0,'2010-06-22 21:23:22',374),(1662,25,3,3,3,3,'2010-06-22 21:23:22',374),(1663,25,4,6,1,0,'2010-06-22 21:23:22',374),(1664,25,5,2,2,0,'2010-06-22 21:23:22',374),(1665,25,6,3,3,9,'2010-06-22 21:23:22',374),(1666,25,7,4,2,0,'2010-06-22 21:23:22',374),(1667,25,8,3,2,0,'2010-06-22 21:23:22',374),(1668,25,9,2,2,0,'2010-06-22 21:23:22',374),(1669,25,10,0,0,0,'2010-06-22 21:23:22',374),(1670,25,1,4,4,0,'2010-06-22 21:24:34',345),(1671,25,2,6,3,0,'2010-06-22 21:24:34',345),(1672,25,3,2,1,6,'2010-06-22 21:24:34',345),(1673,25,4,6,1,0,'2010-06-22 21:24:34',345),(1674,25,5,3,3,0,'2010-06-22 21:24:34',345),(1675,25,6,6,5,18,'2010-06-22 21:24:34',345),(1676,25,7,4,2,0,'2010-06-22 21:24:34',345),(1677,25,8,6,4,0,'2010-06-22 21:24:34',345),(1678,25,9,6,4,0,'2010-06-22 21:24:34',345),(1679,25,10,0,0,0,'2010-06-22 21:24:34',345),(1680,25,1,5,5,0,'2010-06-22 21:28:40',372),(1681,25,2,0,0,0,'2010-06-22 21:28:40',372),(1682,25,3,5,2,10,'2010-06-22 21:28:40',372),(1683,25,4,6,1,0,'2010-06-22 21:28:40',372),(1684,25,5,4,4,0,'2010-06-22 21:28:40',372),(1685,25,6,3,3,7,'2010-06-22 21:28:40',372),(1686,25,7,5,4,0,'2010-06-22 21:28:40',372),(1687,25,8,6,4,0,'2010-06-22 21:28:40',372),(1688,25,9,3,2,0,'2010-06-22 21:28:40',372),(1689,25,10,1,1,0,'2010-06-22 21:28:40',372),(1690,25,1,6,6,0,'2010-06-22 21:28:40',330),(1691,25,2,6,3,0,'2010-06-22 21:28:40',330),(1692,25,3,3,1,6,'2010-06-22 21:28:40',330),(1693,25,4,6,1,0,'2010-06-22 21:28:40',330),(1694,25,5,4,4,0,'2010-06-22 21:28:40',330),(1695,25,6,6,5,18,'2010-06-22 21:28:40',330),(1696,25,7,5,4,0,'2010-06-22 21:28:40',330),(1697,25,8,5,3,0,'2010-06-22 21:28:40',330),(1698,25,9,5,4,0,'2010-06-22 21:28:40',330),(1699,25,10,3,2,0,'2010-06-22 21:28:40',330),(1700,25,1,6,6,0,'2010-06-22 21:28:40',375),(1701,25,2,6,3,0,'2010-06-22 21:28:40',375),(1702,25,3,6,3,22,'2010-06-22 21:28:40',375),(1703,25,4,6,1,0,'2010-06-22 21:28:40',375),(1704,25,5,5,5,0,'2010-06-22 21:28:40',375),(1705,25,6,6,5,24,'2010-06-22 21:28:40',375),(1706,25,7,6,4,0,'2010-06-22 21:28:40',375),(1707,25,8,6,4,0,'2010-06-22 21:28:40',375),(1708,25,9,6,4,0,'2010-06-22 21:28:40',375),(1709,25,10,3,1,0,'2010-06-22 21:28:40',375);
/*!40000 ALTER TABLE `tbl_Pistol_Score` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`root`@`localhost` */ /*!50003 TRIGGER `tr_score_ins` BEFORE INSERT ON `tbl_Pistol_Score` FOR EACH ROW set NEW.RegisterDate = now() */;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`root`@`localhost` */ /*!50003 TRIGGER `tr_score_upd` BEFORE UPDATE ON `tbl_Pistol_Score` FOR EACH ROW set NEW.RegisterDate = now() */;;
DELIMITER ;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */;
--
-- Table structure for table `tbl_Pistol_Shot`
--
DROP TABLE IF EXISTS `tbl_Pistol_Shot`;
CREATE TABLE `tbl_Pistol_Shot` (
`Id` bigint(20) NOT NULL auto_increment,
`FirstName` varchar(20) default NULL,
`LastName` varchar(40) default NULL,
`ClubId` bigint(20) default NULL,
`GunCard` varchar(10) default NULL,
`Email` varchar(60) default NULL,
`Password` varchar(100) default NULL,
`UserType` varchar(10) default NULL,
`CreateDate` timestamp NOT NULL default current_timestamp,
`Status` varchar(10) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i3` (`GunCard`),
KEY `i1` (`LastName`,`FirstName`),
KEY `i2` (`ClubId`,`LastName`)
) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_Shot`
--
LOCK TABLES `tbl_Pistol_Shot` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_Shot` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_Shot` VALUES (1,'Ulf','Thörnblad',95,'1','[email protected]','ebfc7910077770c8340f63cd2dca2ac1f120444f','ADMIN','2008-05-14 18:03:50','ACTIVE'),(2,'Pierre','Lindqvist',22,'24924','[email protected]','b7c125e801d26b62a5ceca00179f82788a7ac7c4','ADMIN','2008-05-14 18:07:08','ACTIVE'),(3,'Lars','Lundmark',22,'1657','[email protected]','d2c88b2aa103acf3d69891df0b6fb8a7d95d86ee','ADMIN','2008-05-15 17:50:30','ACTIVE'),(4,'Smith','Wesson',22,'666666','[email protected]','fa376e383626491fb6f3b6b5c06b1c208bba702b','USER','2008-05-15 19:17:01','ACTIVE'),(5,'Svenne','Duva',1,'100','[email protected]','84f82634d5cf289f2b248ac3d9a296291e41cbf3','USER','2008-06-10 01:02:39','ACTIVE'),(6,'Heléne','Loberg',60,'18623','[email protected]','925a290882138da39ff6372761b695e80bd28364','USER','2008-06-26 09:36:17','ACTIVE'),(7,'Thomas','Bäckström',58,'1212','[email protected]','3d4f2bf07dc1be38b20cd6e46949a1071f9d0e3d','USER','2008-07-01 12:54:07','ACTIVE'),(8,'Annika ','Gabrielsson',58,'1122','[email protected]','3d4f2bf07dc1be38b20cd6e46949a1071f9d0e3d','USER','2008-07-01 12:55:29','ACTIVE'),(9,'Britt','Karlsson',99,'12','[email protected]','3d4f2bf07dc1be38b20cd6e46949a1071f9d0e3d','USER','2008-07-01 13:00:51','ACTIVE'),(10,'Navid','Bagheri',22,'0101','[email protected]','3d4f2bf07dc1be38b20cd6e46949a1071f9d0e3d','USER','2008-07-01 13:02:21','ACTIVE'),(11,'Camilla','Knutsson',58,'20921','[email protected]','897cba9cc449b54ba3c94d26b8905bb3be72167a','USER','2008-09-12 16:17:04','ACTIVE'),(12,'två','tvåan',1,'2','[email protected]','5554e95a04453eae2af34eb2be4d9cba9f94665b','USER','2008-10-07 08:46:36','ACTIVE'),(13,'tre','trean',1,'3','[email protected]','a18f3b5412b05ce83a4781917e326f1e7c4cfab0','USER','2008-10-07 08:49:21','ACTIVE'),(14,'fyra','fyran',1,'4','[email protected]','a2bbc15b3c901c5d1199bf3c635502f8dca1f70c','USER','2008-10-07 08:51:38','ACTIVE'),(15,'Urban','Källestig',22,'5702','[email protected]','c085563abbcde81cc1e9f36a46ac99a960db26f9','ADMIN','2008-12-29 12:10:48','ACTIVE'),(16,'Anna-Lena','Stenfeldt',22,'28388','[email protected]','b7c125e801d26b62a5ceca00179f82788a7ac7c4','USER','2009-01-17 19:13:15','ACTIVE'),(63,'Arne','Friberg',22,'020','[email protected]','37076a00c0e8dcafd1e0bda94793dc1a8a999bca','USER','2010-04-08 10:10:39','ACTIVE'),(62,'Nader','Nazari',22,'12880','[email protected]','dc07c6cba562f7c42cb1c564a364883cac195c9c','USER','2010-04-07 09:33:02','ACTIVE'),(61,'Gökhan','Kurt',22,'29544','[email protected]','c859a69ae064a49e815e17dc33335035ca8fdb4a','USER','2010-04-06 14:25:50','ACTIVE'),(60,'Barbro','Wegerstam',22,'1472317','[email protected]','89724b0e5a92bb1388fa52ee2b259851635ed454','USER','2010-04-06 14:07:53','ACTIVE'),(59,'asd','asd',1,'123','[email protected]','85136c79cbf9fe36bb9d05d0639c70c265c18d37','USER','2010-04-06 06:33:37','ACTIVE'),(58,'Åke','Lewensjö',22,'12720','[email protected]','7eaa29e9c7daf389818b0191571a7714911784d4','USER','2010-04-05 14:20:50','ACTIVE'),(57,'Tommy','Sellering',22,'M270966TOM','[email protected]','4e8f7377720f4ca2824090330c8610d5f85a6a9f','USER','2010-04-05 09:13:27','ACTIVE'),(56,'erik','gamarra',23,'0000','[email protected]','b06b81531cc8e9b5f25902187e9d748a3f3fd853','USER','2010-04-01 06:18:01','ACTIVE'),(55,'Alexander','Vaynshteyn',22,'29545','[email protected]','3f5962c46facf3d7f0e7a3d7bacd1dbd2e1129eb','USER','2010-04-01 05:58:59','ACTIVE'),(54,'Mattias','Gustafsson',22,'29548','[email protected]','46c8c1efbfa67679e9546ef7e717de0a64fc639b','USER','2010-03-31 10:15:53','ACTIVE'),(53,'Tim','Bågenholm',22,'30116','[email protected]','76c15e6c9ac7e63202739b4283c504d186baae39','USER','2010-03-31 05:24:03','ACTIVE'),(52,'Pertti','Karjalainen',22,'28390','[email protected]','2e9bb42c3de7d98f6a72abd2a57c80c99f2d64fe','USER','2010-03-31 04:37:26','ACTIVE'),(51,'abc','abc',22,'abc','[email protected]','f8c1d87006fbf7e5cc4b026c3138bc046883dc71','USER','2010-03-31 03:31:44','ACTIVE'),(50,'Ronny','Larsson',22,'1486221','[email protected]','1c071514bdf51007fda9d16a6c371a04b5437318','USER','2010-03-31 03:25:47','ACTIVE'),(49,'Bedjet','Iséni',22,'30118','[email protected]','ff004cfe54b2ca6d9ad6a0a149c3893a71813b59','USER','2010-03-30 15:54:29','ACTIVE'),(48,'Christoffer','Meyer',22,'1486928','[email protected]','182b6cb552e016337805988bc1ee0f6aefa1f7a0','USER','2010-03-30 15:37:27','ACTIVE'),(47,'Jonas','Eriksson',91,'05031','[email protected]','b73856d9eef18150915ab6366fe3b155a02b9ac6','ADMIN','2010-03-27 10:33:30','ACTIVE'),(44,'Ulf','Hansson',29,'24287','[email protected]','214c418002e37328fa4269e3a4c952adc6e79ea4','ADMIN','2009-04-14 17:49:45','ACTIVE'),(45,'Andreas','Klementsson',22,'14426','[email protected]','bc0fd96aa487df4cb5a4f51eb86acdac00afbefa','ADMIN','2009-04-29 16:08:30','ACTIVE'),(46,'Claes','Linder',58,'3813','[email protected]','907a1177cdf5dbc33b9b493e03ab26be0045629d','ADMIN','2010-03-21 05:39:41','ACTIVE'),(64,'Christian','Holmgren',22,'3263','[email protected]','59c0912941dbfa0d5d7bde2f782a8f303c586d1c','USER','2010-04-09 04:41:00','ACTIVE'),(65,'Christer','Beckman',22,'26317','[email protected]','ff00fa5d784ed1757f2ec5979ca1da50821cc61d','OPER','2010-04-10 02:02:46','ACTIVE'),(66,'Ralph','Häggedahl',22,'123456','[email protected]','32502e080ad1a739c78e34295bf14d457e3a9608','USER','2010-04-10 02:10:37','ACTIVE'),(67,'Ingemar','Wahlberg',22,'24314','[email protected]','d76c0786b339c2b2567bdaf99858d035b8804ba8','USER','2010-04-10 02:26:41','ACTIVE'),(68,'Mia','Karlman',22,'29055','[email protected]','57ca2dad17817a05249a192cc18ef326772df0d4','USER','2010-04-10 02:28:37','ACTIVE'),(69,'Ronny','Larsson',22,'1234567','[email protected]','d2c88b2aa103acf3d69891df0b6fb8a7d95d86ee','USER','2010-04-10 02:30:10','ACTIVE'),(70,'Astor','Fritzon',22,'654321','[email protected]','160ea291432224d3fbf77e865579f83d9cc5739a','USER','2010-04-10 02:36:42','ACTIVE'),(71,'Tommy','Sellering',22,'086886','[email protected]','8b89cc0a3710e0bed7f548bf447d24881251b117','USER','2010-04-10 02:42:27','ACTIVE'),(72,'Dominique','Gasc',22,'4321','[email protected]','d2c88b2aa103acf3d69891df0b6fb8a7d95d86ee','USER','2010-04-10 02:46:40','ACTIVE'),(73,'Sanna','Zetterberg',22,'21281','[email protected]','32502e080ad1a739c78e34295bf14d457e3a9608','USER','2010-04-10 03:05:06','ACTIVE'),(74,'Lars','Persson',22,'987','[email protected]','d2c88b2aa103acf3d69891df0b6fb8a7d95d86ee','USER','2010-04-10 04:58:59','ACTIVE'),(75,'Carl-Erik','Lissfors',22,'5708','[email protected]','8a2275f2aaba24900a62d746a355bf36aa413570','USER','2010-06-16 17:05:58','ACTIVE'),(76,'Peter','Larsson',90,'19699','[email protected]','84c43305b6a78500e7ccb4165936378d4b831a76','USER','2010-06-20 15:03:03','ACTIVE'),(77,'Navid','Bagheri',22,'5712','[email protected]','3e5e06ddd784102da0afff1a585625653269c265','USER','2010-06-20 17:51:29','ACTIVE'),(78,'Tony','Forslund',90,'17563','[email protected]','deaf9369612366b797c1825fcd5769bc9a6bcf85','USER','2010-06-20 20:33:07','ACTIVE'),(79,'Mikael','Jonasson',79,'16687','[email protected]','3b0a5a5c7771f2d87fb321f74877dfe4ffa92908','USER','2010-06-20 20:58:07','ACTIVE'),(80,'Bengt','Dahl',90,'7726','[email protected]','5c8a7a129de8b649e9a0cbfbb7e9cec37a6efcb6','USER','2010-06-20 21:50:37','ACTIVE'),(81,'daniel','johansson',90,'28550','[email protected]','23af1bb7463f46d948bc17f3900a5cbe512922a1','USER','2010-06-20 21:58:14','ACTIVE'),(82,'Urban','Waldenström',58,'602','[email protected]','633a74f5d793800c6e2802a1bf2f0da8529143a3','USER','2010-06-20 23:19:09','ACTIVE'),(83,'Johan','Lindquist',58,'23174','[email protected]','5f75fbcccdb0071a07ea6c8008c858fe0e3e64cc','USER','2010-06-21 01:04:41','ACTIVE'),(84,'Sune','Johnson',22,'05140','[email protected]','ee5251e111bc059272d06c7722a6ba2198155ebd','USER','2010-06-21 15:22:07','ACTIVE'),(85,'Thomas','Dannberg',22,'8670','[email protected]','ee5251e111bc059272d06c7722a6ba2198155ebd','USER','2010-06-21 20:57:14','ACTIVE'),(86,'Oskar','Ekblad',30,'26707','[email protected]','083c270078073f7366519ef56092e9480ba373b1','USER','2010-06-21 21:08:38','ACTIVE'),(87,'Anton ','Ekblad',30,'26905','[email protected]','f644e9c09f48319e45e5e78ad9d148f4f9a4e2bf','USER','2010-06-21 21:15:21','ACTIVE'),(88,'Rolf','Ekblad',30,'27297','[email protected]','3c17b33673640dca980458a2d13b3833ea1dcb99','USER','2010-06-21 21:17:37','ACTIVE'),(89,'David','Svensson',30,'26706','[email protected]','c6d85de9b8c079438674a1d7ec8ed504d6efa7da','USER','2010-06-21 22:31:40','ACTIVE'),(90,'Christer','Svensson',30,'26583','[email protected]','c6d85de9b8c079438674a1d7ec8ed504d6efa7da','USER','2010-06-21 22:38:15','ACTIVE'),(91,'Ulf','Sandahl',58,'3812','[email protected]','7c4a8d09ca3762af61e59520943dc26494f8941b','USER','2010-06-22 16:18:37','ACTIVE'),(92,'Slavoljub','Mrdenovic',22,'12712','[email protected]','7c4a8d09ca3762af61e59520943dc26494f8941b','USER','2010-06-22 16:30:42','ACTIVE'),(93,'Patrik','Fritzson',22,'583','[email protected]','7c4a8d09ca3762af61e59520943dc26494f8941b','USER','2010-06-22 17:24:58','ACTIVE'),(94,'Lars','Regner',22,'22461','[email protected]','9df0d271aaa770f00fef80ebb07e1f552c193d74','USER','2010-06-22 18:00:56','ACTIVE'),(95,'Ronny','Meijer',22,'16983','[email protected]','cd51452db9fa7bf1d9abfceb3f25a2af3d1898be','USER','2010-06-22 18:04:23','ACTIVE'),(96,'Dominique','Gasc',22,'13467','[email protected]','7c4a8d09ca3762af61e59520943dc26494f8941b','USER','2010-06-22 18:30:26','ACTIVE'),(97,'Blagoja','Bogoevski',22,'16976','[email protected]','31c73562bdb0ecf52a9b15546dd31b9c69a87d1b','USER','2010-06-22 18:38:25','ACTIVE'),(98,'Camilla ','Ersdal',22,'1000000','[email protected]','1f8ac10f23c5b5bc1167bda84b833e5c057a77d2','USER','2010-06-22 19:43:01','ACTIVE');
/*!40000 ALTER TABLE `tbl_Pistol_Shot` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`www`@`%` */ /*!50003 TRIGGER `tr_shot_ins` BEFORE INSERT ON `tbl_Pistol_Shot` FOR EACH ROW set NEW.CreateDate = now() */;;
DELIMITER ;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */;
--
-- Table structure for table `tbl_Pistol_ShotClass`
--
DROP TABLE IF EXISTS `tbl_Pistol_ShotClass`;
CREATE TABLE `tbl_Pistol_ShotClass` (
`Id` bigint(20) NOT NULL auto_increment,
`Name` varchar(20) default NULL,
`Description` varchar(20) default NULL,
`GunClassificationId` bigint(20) default NULL,
`Masterskap` CHAR(1) NULL DEFAULT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_ShotClass`
--
LOCK TABLES `tbl_Pistol_ShotClass` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_ShotClass` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_ShotClass` VALUES (1,'C1',NULL,3, NULL),(2,'C2',NULL,3,NULL),(3,'C3',NULL,3,NULL),(4,'D1',NULL,3,NULL),(5,'D2',NULL,3,NULL),(6,'D3',NULL,3,NULL),(7,'VY',NULL,3,NULL),(8,'VÄ',NULL,3,NULL),(9,'JUN',NULL,3,NULL),(10,'A1',NULL,1,NULL),(11,'A2',NULL,1,NULL),(12,'A3',NULL,1,NULL),(13,'B1',NULL,2,NULL),(14,'B2',NULL,2,NULL),(15,'B3',NULL,2,NULL),(16,'R1',NULL,4,NULL),(17,'R2',NULL,4,NULL),(18,'R3',NULL,4,NULL),(19,'S',NULL,5,NULL);
UPDATE `tbl_Pistol_ShotClass` SET `Masterskap`='Y' WHERE `Id`='3';
UPDATE `tbl_Pistol_ShotClass` SET `Masterskap`='Y' WHERE `Id`='6';
UPDATE `tbl_Pistol_ShotClass` SET `Masterskap`='Y' WHERE `Id`='12';
UPDATE `tbl_Pistol_ShotClass` SET `Masterskap`='Y' WHERE `Id`='15';
UPDATE `tbl_Pistol_ShotClass` SET `Masterskap`='Y' WHERE `Id`='18';
INSERT INTO `tbl_Pistol_ShotClass` VALUES (20,'H1 - Grov',NULL,6, NULL),(21,'H2 - Grov',NULL,6, NULL),(22,'H3 - Grov',NULL,6, NULL),
(23,'H1 - Sport',NULL,7, NULL),(24,'H2 - Sport',NULL,7, NULL),(25,'H3 - Sport',NULL,7, NULL),
(26,'H1 - Standard',NULL,8, NULL),(27,'H2 - Standard',NULL,8, NULL),(28,'H3 - Standard',NULL,8, NULL),
(29,'H1 - Snabb',NULL,9, NULL),(30,'H2 - Snabb',NULL,9, NULL),(31,'H3 - Snabb',NULL,9, NULL),
(32,'H1 - Luft',NULL,10, NULL),(33,'H2 - Luft',NULL,10, NULL),(34,'H3 - Luft',NULL,10, NULL)
;
INSERT INTO `tbl_Pistol_ShotClass` VALUES (35,'High Master - P1500',NULL,11, NULL),
(36,'High Master - R1500',NULL,12, NULL),
(37,'High Master - SR6',NULL,13, NULL),
(38,'High Master - SP5',NULL,14, NULL),
(39,'High Master - SR4',NULL,15, NULL),
(40,'High Master - SR3',NULL,16, NULL),
(41,'High Master - SP5FR',NULL,17, NULL)
;
/*!40000 ALTER TABLE `tbl_Pistol_ShotClass` ENABLE KEYS */;
UNLOCK TABLES;
UPDATE `gunnar`.`tbl_Pistol_ShotClass` SET `Masterskap`='Y' WHERE `Id`='3';
UPDATE `gunnar`.`tbl_Pistol_ShotClass` SET `Masterskap`='Y' WHERE `Id`='6';
UPDATE `gunnar`.`tbl_Pistol_ShotClass` SET `Masterskap`='Y' WHERE `Id`='12';
UPDATE `gunnar`.`tbl_Pistol_ShotClass` SET `Masterskap`='Y' WHERE `Id`='15';
UPDATE `gunnar`.`tbl_Pistol_ShotClass` SET `Masterskap`='Y' WHERE `Id`='18';
--
-- Table structure for table `tbl_Pistol_Station`
--
DROP TABLE IF EXISTS `tbl_Pistol_Station`;
CREATE TABLE `tbl_Pistol_Station` (
`Id` bigint(20) NOT NULL auto_increment,
`CompetitionDayId` bigint(20) default NULL,
`SortOrder` smallint(6) NOT NULL,
`PatrolSpace` smallint(6) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `i1` (`CompetitionDayId`,`SortOrder`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_Station`
--
LOCK TABLES `tbl_Pistol_Station` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_Station` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_Pistol_Station` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_Team`
--
DROP TABLE IF EXISTS `tbl_Pistol_Team`;
CREATE TABLE `tbl_Pistol_Team` (
`Id` bigint(20) NOT NULL auto_increment,
`Name` varchar(50) NOT NULL,
`CompetitionDayId` bigint(20) default NULL,
`GunClassId` bigint(20) default NULL,
`ClubId` bigint(20) default NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_Team`
--
LOCK TABLES `tbl_Pistol_Team` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_Team` DISABLE KEYS */;
INSERT INTO `tbl_Pistol_Team` VALUES (1,'Cowboys',20,1,95),(2,'GPSSK 1',21,3,22);
/*!40000 ALTER TABLE `tbl_Pistol_Team` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_Pistol_TeamMember`
--
DROP TABLE IF EXISTS `tbl_Pistol_TeamMember`;
CREATE TABLE `tbl_Pistol_TeamMember` (
`Id` bigint(20) NOT NULL auto_increment,
`TeamId` bigint(20) default NULL,
`EntryId` bigint(20) default NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_Pistol_TeamMember`
--
LOCK TABLES `tbl_Pistol_TeamMember` WRITE;
/*!40000 ALTER TABLE `tbl_Pistol_TeamMember` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_Pistol_TeamMember` 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 */;
-- Table traning
DROP TABLE IF EXISTS `tbl_Pistol_Traning`;
CREATE TABLE `tbl_Pistol_Traning` (
`Id` bigint(20) NOT NULL auto_increment,
`ShotId` bigint(20) NOT NULL,
`ShotClassId` bigint(20) NOT NULL,
`Date` date default NULL,
`Score` int NOT NULL,
`GodkanShotId` bigint(20) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `tbl_Pistol_Payment`;
CREATE TABLE `tbl_Pistol_Payment` (
`Id` bigint(20) NOT NULL auto_increment,
`EntryId` bigint(20) NOT NULL,
`TransactionId` varchar(40) NOT NULL ,
`StatusCode` int(11) NOT NULL ,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=102 DEFAULT CHARSET=latin1;
--ALTER TABLE `tbl_Pistol_Payment` ADD COLUMN `StatusCode` int(11) NULL DEFAULT 0 AFTER `TransactionId` ;