-- http://www.phpmyadmin.net
-- 
-- Erstellungszeit: 04. April 2009 um 12:12
-- Server Version: 4.1.18
-- PHP-Version: 4.4.2
-- 
-- Datenbank: `niki_2008`
-- 

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `drivers`
-- 

CREATE TABLE IF NOT EXISTS `drivers` (
  `d_id` int(11) NOT NULL auto_increment,
  `d_lname` varchar(20) NOT NULL default '',
  `d_fname` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`d_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;

-- 
-- Daten für Tabelle `drivers`
-- 

INSERT INTO `drivers` (`d_id`, `d_lname`, `d_fname`) VALUES (1, 'RAIKKONEN', 'Kimi'),
(2, 'MASSA', 'Felipe'),
(3, 'HEIDFELD', 'Nick'),
(4, 'KUBICA', 'Robert'),
(5, 'ALONSO', 'Fernando'),
(6, 'PIQUET', 'Nelson Jr.'),
(7, 'ROSBERG', 'Nico'),
(8, 'NAKAJIMA', 'Kazuki'),
(9, 'COULTHARD', 'David'),
(10, 'WEBBER', 'Mark'),
(11, 'TRULLI', 'Jarno'),
(12, 'GLOCK', 'Timo'),
(14, 'BOURDAIS', 'Sebastien'),
(15, 'VETTEL', 'Sebastian'),
(16, 'BUTTON', 'Jenson'),
(17, 'BARRICHELLO', 'Rubens'),
(18, 'SATO', 'Takuma'),
(19, 'DAVIDSON', 'Anthony'),
(20, 'SUTIL', 'Adrian'),
(21, 'FISICHELLA', 'Giancarlo'),
(22, 'HAMILTON', 'Lewis'),
(23, 'KOVALAINEN', 'Heikki'),
(24, 'BADOER', 'Luca'),
(25, 'GENE', 'Marc'),
(26, 'KLIEN', 'Christian'),
(27, 'ASMER', 'Marko'),
(28, 'GROSJEAN', 'Romain'),
(29, 'DI GRASSI', 'Lucas'),
(30, 'YAMAMOTO', 'Sakon'),
(31, 'HUELKENBERG', 'Nico'),
(32, 'BUEMI', 'Sebastien'),
(33, 'KOBAYASHI', 'Kamui'),
(34, 'WURZ', 'Alexander'),
(35, 'ROSSITER', 'James'),
(36, 'LIUZZI', 'Vitantonio'),
(37, 'DE LA ROSA', 'Pedro'),
(38, 'PAFFETT', 'Gary');

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `events`
-- 

CREATE TABLE IF NOT EXISTS `events` (
  `e_id` int(11) NOT NULL auto_increment,
  `e_type` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`e_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Daten für Tabelle `events`
-- 

INSERT INTO `events` (`e_id`, `e_type`) VALUES (1, 'QUALIFYING'),
(2, 'RACE');

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `gps`
-- 

CREATE TABLE IF NOT EXISTS `gps` (
  `g_id` int(11) NOT NULL auto_increment,
  `g_name` varchar(40) NOT NULL default '',
  `g_datetime_q` datetime NOT NULL default '0000-00-00 00:00:00',
  `g_datetime_r` datetime NOT NULL default '0000-00-00 00:00:00',
  `g_flag` varchar(20) NOT NULL default '',
  `g_circuit` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`g_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

-- 
-- Daten für Tabelle `gps`
-- 

INSERT INTO `gps` (`g_id`, `g_name`, `g_datetime_q`, `g_datetime_r`, `g_flag`, `g_circuit`) VALUES (1, 'AUSTRALIA (Melbourne)', '2008-03-15 04:00:00', '2008-03-16 05:30:00', 'flag_AUSTRALIA.gif', 'circuit_AUSTRALIA.gif'),
(2, 'MALAYSIA (Sepang)', '2008-03-22 07:00:00', '2008-03-23 08:00:00', 'flag_MALAYSIA.gif', 'circuit_MALAYSIA.gif'),
(3, 'BAHRAIN (Sakhir)', '2008-04-05 13:00:00', '2008-04-06 13:30:00', 'flag_BAHRAIN.gif', 'circuit_BAHRAIN.gif'),
(4, 'SPAIN (Barcelona)', '2008-04-26 14:00:00', '2008-04-27 14:00:00', 'flag_SPAIN.gif', 'circuit_SPAIN.gif'),
(5, 'TURKEY (Istanbul)', '2008-05-10 13:00:00', '2008-05-11 14:00:00', 'flag_TURKEY.gif', 'circuit_TURKEY.gif'),
(6, 'MONACO (Monte Carlo)', '2008-05-24 14:00:00', '2008-05-25 14:00:00', 'flag_MONACO.gif', 'circuit_MONACO.gif'),
(7, 'CANADA (Montreal)', '2008-06-07 19:00:00', '2008-06-08 19:00:00', 'flag_CANADA.gif', 'circuit_CANADA.gif'),
(8, 'FRANCE (Magny-Cours)', '2008-06-21 14:00:00', '2008-06-22 14:00:00', 'flag_FRANCE.gif', 'circuit_FRANCE.gif'),
(9, 'GREAT BRITAIN (Silverstone)', '2008-07-05 14:00:00', '2008-07-06 14:00:00', 'flag_UK.gif', 'circuit_UK.gif'),
(10, 'GERMANY (Hockenheim)', '2008-07-19 14:00:00', '2008-07-20 14:00:00', 'flag_GERMANY.gif', 'circuit_GERMANY_(Hockenheim).gif'),
(11, 'HUNGARY (Budapest)', '2008-08-02 14:00:00', '2008-08-03 14:00:00', 'flag_HUNGARY.gif', 'circuit_HUNGARY.gif'),
(12, 'EUROPE (Valencia)', '2008-08-23 14:00:00', '2008-08-24 14:00:00', 'flag_EUROPE.gif', 'circuit_EUROPE_(Valencia).gif'),
(13, 'BELGIUM (Spa)', '2008-09-06 14:00:00', '2008-09-07 14:00:00', 'flag_BELGIUM.gif', 'circuit_BELGIUM.gif'),
(14, 'ITALY (Monza)', '2008-09-13 14:00:00', '2008-09-14 14:00:00', 'flag_ITALY.gif', 'circuit_ITALY.gif'),
(15, 'SINGAPORE (Singapore)', '2008-09-27 16:00:00', '2008-09-28 14:00:00', 'flag_SINGAPORE.gif', 'circuit_SINGAPORE.gif'),
(16, 'JAPAN (Fuji)', '2008-10-11 07:00:00', '2008-10-12 06:30:00', 'flag_JAPAN.gif', 'circuit_JAPAN_(Fuji).gif'),
(17, 'CHINA (Shanghai)', '2008-10-18 08:00:00', '2008-10-19 09:00:00', 'flag_CHINA.gif', 'circuit_CHINA.gif'),
(18, 'BRASIL (Sao Paolo)', '2008-11-01 17:00:00', '2008-11-02 18:00:00', 'flag_BRASIL.gif', 'circuit_BRASIL.gif');

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `results`
-- 

CREATE TABLE IF NOT EXISTS `results` (
  `r_g_id` int(11) NOT NULL default '0',
  `r_e_id` int(11) NOT NULL default '0',
  `r_d_id_p1` int(11) NOT NULL default '0',
  `r_d_id_p2` int(11) NOT NULL default '0',
  `r_d_id_p3` int(11) NOT NULL default '0',
  `r_fl` int(11) NOT NULL default '0',
  `r_sc` int(11) NOT NULL default '-1',
  PRIMARY KEY  (`r_g_id`,`r_e_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Daten für Tabelle `results`
-- 

INSERT INTO `results` (`r_g_id`, `r_e_id`, `r_d_id_p1`, `r_d_id_p2`, `r_d_id_p3`, `r_fl`, `r_sc`) VALUES (1, 1, 22, 4, 23, 0, -1),
(1, 2, 22, 3, 7, 23, 1),
(2, 1, 2, 1, 23, 0, -1),
(2, 2, 1, 4, 23, 3, 0),
(3, 1, 4, 2, 22, 0, -1),
(3, 2, 2, 1, 4, 23, 0),
(4, 1, 1, 5, 2, 0, -1),
(4, 2, 1, 2, 22, 1, 1),
(5, 1, 2, 23, 22, 0, -1),
(5, 2, 2, 22, 1, 1, 1),
(6, 1, 2, 1, 22, 0, -1),
(6, 2, 22, 4, 2, 1, 1),
(7, 1, 22, 4, 1, 0, -1),
(7, 2, 4, 3, 9, 1, 1),
(8, 1, 1, 2, 22, 0, -1),
(8, 2, 2, 1, 11, 1, 0),
(9, 1, 23, 10, 1, 0, -1),
(9, 2, 22, 3, 17, 1, 0),
(10, 1, 22, 2, 23, 0, -1),
(10, 2, 22, 6, 2, 3, 1),
(11, 1, 22, 23, 2, 0, -1),
(11, 2, 23, 12, 1, 1, 0),
(12, 1, 2, 22, 4, 0, -1),
(12, 2, 2, 22, 4, 2, 0),
(13, 1, 22, 2, 23, 0, -1),
(13, 2, 2, 3, 22, 1, 0),
(14, 1, 15, 23, 10, 0, -1),
(14, 2, 15, 23, 4, 1, 1),
(15, 1, 2, 22, 1, 0, -1),
(15, 2, 5, 7, 22, 1, 1),
(16, 1, 22, 1, 23, 0, -1),
(16, 2, 5, 4, 1, 2, 0),
(17, 1, 22, 1, 2, 0, -1),
(17, 2, 22, 2, 1, 22, 0),
(18, 1, 2, 11, 1, 0, -1),
(18, 2, 2, 5, 1, 2, 1);

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `tips`
-- 

CREATE TABLE IF NOT EXISTS `tips` (
  `t_u_id` int(11) NOT NULL default '0',
  `t_g_id` int(11) NOT NULL default '0',
  `t_e_id` int(11) NOT NULL default '0',
  `t_d_id_p1` int(11) NOT NULL default '0',
  `t_d_id_p2` int(11) NOT NULL default '0',
  `t_d_id_p3` int(11) NOT NULL default '0',
  `t_fl` int(11) NOT NULL default '0',
  `t_sc` int(11) NOT NULL default '0',
  `t_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `t_score` int(11) NOT NULL default '0',
  PRIMARY KEY  (`t_u_id`,`t_g_id`,`t_e_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Daten für Tabelle `tips`
-- 

INSERT INTO `tips` (`t_u_id`, `t_g_id`, `t_e_id`, `t_d_id_p1`, `t_d_id_p2`, `t_d_id_p3`, `t_fl`, `t_sc`, `t_timestamp`, `t_score`) VALUES (7, 1, 1, 1, 22, 2, 0, 0, '2008-03-14 11:25:18', 1),
(3, 1, 1, 1, 22, 2, 0, 0, '2008-03-14 16:46:45', 1),
(8, 1, 1, 1, 22, 2, 0, 0, '2008-03-14 17:20:45', 1),
(6, 1, 2, 22, 2, 23, 1, 0, '2008-03-15 12:47:15', 1),
(9, 1, 1, 22, 2, 23, 0, 0, '2008-03-14 17:27:34', 4),
(9, 1, 2, 22, 2, 23, 15, -1, '2008-03-15 12:38:04', 2),
(10, 1, 1, 22, 1, 2, 0, 0, '2008-03-14 19:51:43', 2),
(11, 1, 1, 22, 1, 2, 0, 0, '2008-03-14 21:11:04', 2),
(1, 1, 1, 1, 22, 2, 0, 0, '2008-03-15 03:48:00', 1),
(7, 1, 2, 22, 4, 2, 22, 0, '2008-03-15 13:36:31', 1),
(8, 1, 2, 22, 2, 4, 1, -1, '2008-03-15 14:44:44', 2),
(3, 1, 2, 22, 2, 4, 22, 0, '2008-03-15 14:48:53', 1),
(1, 1, 2, 2, 22, 23, 1, 1, '2008-03-15 19:35:15', 2),
(12, 1, 2, 22, 4, 2, 9999, -1, '2008-03-15 20:11:25', 2),
(10, 1, 2, 22, 2, 4, 1, 0, '2008-03-15 20:22:24', 1),
(11, 1, 2, 22, 2, 23, 22, -1, '2008-03-15 22:06:27', 2),
(2, 1, 2, 22, 23, 2, 1, 0, '2008-03-16 04:49:25', 1),
(9, 2, 1, 22, 23, 2, 0, 0, '2008-03-21 12:33:54', 2),
(8, 2, 1, 2, 22, 1, 0, 0, '2008-03-21 14:39:44', 3),
(10, 2, 1, 2, 22, 1, 0, 0, '2008-03-21 18:08:50', 3),
(3, 2, 1, 22, 1, 2, 0, 0, '2008-03-21 18:18:08', 3),
(12, 2, 1, 22, 1, 23, 0, 0, '2008-03-21 20:52:33', 4),
(7, 2, 1, 22, 23, 1, 0, 0, '2008-03-21 21:04:24', 2),
(11, 2, 1, 22, 2, 23, 0, 0, '2008-03-21 21:55:54', 3),
(6, 2, 1, 22, 2, 1, 0, 0, '2008-03-22 00:22:21', 2),
(1, 2, 1, 22, 1, 2, 0, 0, '2008-03-22 06:24:22', 3),
(2, 2, 1, 2, 1, 3, 0, 0, '2008-03-22 06:56:56', 4),
(3, 2, 2, 1, 22, 2, 22, -1, '2008-03-22 10:39:35', 2),
(6, 2, 2, 2, 1, 22, 2, -1, '2008-03-22 11:30:36', 1),
(1, 2, 2, 1, 2, 3, 1, 1, '2008-03-22 19:24:01', 1),
(9, 2, 2, 2, 4, 3, 22, 1, '2008-03-22 19:30:22', 1),
(8, 2, 2, 2, 3, 23, 2, 1, '2008-03-22 19:35:32', 1),
(10, 2, 2, 1, 2, 22, 1, 1, '2008-03-22 20:31:47', 1),
(7, 2, 2, 2, 1, 4, 2, -1, '2008-03-22 20:45:57', 2),
(12, 2, 2, 1, 22, 23, 1, -1, '2008-03-22 21:51:38', 4),
(11, 2, 2, 1, 2, 3, 22, -1, '2008-03-22 23:24:55', 2),
(2, 2, 2, 1, 2, 3, 1, 1, '2008-03-23 07:48:45', 1),
(3, 3, 1, 1, 2, 22, 0, 0, '2008-04-03 13:06:05', 4),
(7, 3, 1, 1, 2, 22, 0, 0, '2008-04-04 23:26:28', 4),
(9, 3, 1, 2, 1, 23, 0, 0, '2008-04-05 09:05:49', 1),
(8, 3, 1, 2, 1, 22, 0, 0, '2008-04-05 09:06:31', 3),
(6, 3, 1, 2, 1, 23, 0, 0, '2008-04-05 11:20:07', 1),
(10, 3, 1, 2, 1, 4, 0, 0, '2008-04-05 11:45:31', 2),
(12, 3, 1, 1, 22, 2, 0, 0, '2008-04-05 11:46:24', 2),
(11, 3, 1, 2, 1, 23, 0, 0, '2008-04-05 12:35:11', 1),
(1, 3, 1, 2, 1, 23, 0, 0, '2008-04-05 12:35:45', 1),
(2, 3, 1, 2, 1, 11, 0, 0, '2008-04-05 12:49:00', 1),
(6, 3, 2, 2, 1, 4, 4, -1, '2008-04-05 14:11:56', 6),
(9, 3, 2, 22, 4, 1, 2, -1, '2008-04-05 19:29:32', 2),
(3, 3, 2, 2, 1, 22, 1, -1, '2008-04-05 19:33:50', 4),
(8, 3, 2, 22, 1, 3, 23, -1, '2008-04-05 19:47:38', 3),
(1, 3, 2, 2, 22, 1, 2, 0, '2008-04-05 23:14:09', 4),
(11, 3, 2, 2, 22, 4, 4, 0, '2008-04-05 23:27:41', 5),
(7, 3, 2, 1, 4, 22, 23, -1, '2008-04-06 10:36:15', 3),
(10, 3, 2, 1, 4, 22, 23, 0, '2008-04-06 12:02:21', 4),
(12, 3, 2, 2, 4, 22, 1, -1, '2008-04-06 12:23:17', 3),
(2, 3, 2, 1, 2, 4, 2, 0, '2008-04-06 13:29:58', 5),
(3, 4, 1, 1, 2, 4, 0, 0, '2008-04-25 18:29:02', 3),
(7, 4, 1, 1, 2, 22, 0, 0, '2008-04-25 18:42:54', 3),
(8, 4, 1, 1, 2, 22, 0, 0, '2008-04-26 11:51:12', 3),
(9, 4, 1, 1, 2, 4, 0, 0, '2008-04-26 11:55:43', 3),
(12, 4, 1, 2, 1, 22, 0, 0, '2008-04-26 13:15:35', 2),
(10, 4, 1, 1, 4, 2, 0, 0, '2008-04-26 13:15:36', 4),
(6, 4, 1, 1, 4, 23, 0, 0, '2008-04-26 13:25:06', 2),
(1, 4, 1, 1, 2, 22, 0, 0, '2008-04-26 13:31:48', 3),
(11, 4, 1, 1, 2, 22, 0, 0, '2008-04-26 13:33:53', 3),
(2, 4, 1, 1, 2, 4, 0, 0, '2008-04-26 14:00:09', 3),
(6, 4, 2, 1, 2, 5, 2, -1, '2008-04-26 15:16:54', 4),
(3, 4, 2, 1, 2, 4, 4, -1, '2008-04-26 15:36:59', 4),
(1, 4, 2, 1, 2, 4, 2, 0, '2008-04-26 16:05:35', 3),
(7, 4, 2, 1, 2, 4, 1, -1, '2008-04-27 04:06:09', 5),
(4, 4, 2, 1, 4, 5, 4, 0, '2008-04-27 09:14:01', 1),
(9, 4, 2, 1, 2, 4, 3, 0, '2008-04-27 10:27:06', 3),
(8, 4, 2, 1, 4, 5, 3, 1, '2008-04-27 10:28:31', 3),
(11, 4, 2, 1, 2, 4, 4, 0, '2008-04-27 12:22:13', 3),
(10, 4, 2, 1, 4, 5, 1, 0, '2008-04-27 13:29:03', 2),
(12, 4, 2, 1, 4, 22, 2, -1, '2008-04-27 13:29:57', 4),
(2, 4, 2, 1, 2, 4, 1, 0, '2008-04-27 13:54:40', 4),
(7, 5, 1, 2, 23, 1, 0, 0, '2008-05-10 00:27:59', 4),
(13, 5, 1, 2, 1, 23, 0, 0, '2008-05-10 09:43:40', 3),
(3, 5, 1, 1, 22, 2, 0, 0, '2008-05-10 10:42:54', 2),
(8, 5, 1, 2, 23, 1, 0, 0, '2008-05-10 11:19:02', 4),
(9, 5, 1, 1, 2, 22, 0, 0, '2008-05-10 11:20:42', 3),
(2, 5, 1, 22, 1, 4, 0, 0, '2008-05-10 12:58:00', 1),
(1, 5, 1, 1, 2, 22, 0, 0, '2008-05-10 12:58:13', 3),
(11, 5, 1, 1, 22, 2, 0, 0, '2008-05-10 12:59:26', 2),
(10, 5, 1, 4, 2, 1, 0, 0, '2008-05-10 12:44:02', 1),
(12, 5, 1, 1, 2, 22, 0, 0, '2008-05-10 12:44:18', 3),
(3, 5, 2, 2, 22, 1, 2, 0, '2008-05-10 15:07:15', 5),
(11, 5, 2, 2, 22, 1, 2, -1, '2008-05-10 22:31:57', 6),
(7, 5, 2, 2, 23, 22, 2, -1, '2008-05-11 00:59:17', 3),
(13, 5, 2, 1, 2, 22, 9999, -1, '2008-05-11 08:05:23', 3),
(8, 5, 2, 2, 22, 1, 1, -1, '2008-05-11 08:44:42', 7),
(9, 5, 2, 2, 23, 22, 1, 0, '2008-05-11 08:47:48', 3),
(1, 5, 2, 2, 1, 22, 2, -1, '2008-05-11 12:08:58', 4),
(12, 5, 2, 2, 1, 23, 1, -1, '2008-05-11 12:41:40', 4),
(10, 5, 2, 2, 1, 22, 1, 0, '2008-05-11 12:42:51', 4),
(2, 5, 2, 2, 1, 23, 2, 1, '2008-05-11 13:52:57', 4),
(3, 6, 1, 1, 22, 2, 0, 0, '2008-05-22 18:16:53', 3),
(7, 6, 1, 1, 22, 23, 0, 0, '2008-05-24 01:47:43', 2),
(4, 6, 1, 1, 22, 2, 0, 0, '2008-05-24 06:53:43', 3),
(1, 6, 1, 22, 1, 2, 0, 0, '2008-05-24 12:23:01', 4),
(11, 6, 1, 22, 1, 2, 0, 0, '2008-05-24 12:35:38', 4),
(8, 6, 1, 1, 22, 3, 0, 0, '2008-05-24 12:44:02', 2),
(9, 6, 1, 22, 23, 7, 0, 0, '2008-05-24 12:45:08', 1),
(6, 6, 1, 23, 1, 22, 0, 0, '2008-05-24 12:46:34', 4),
(13, 6, 1, 22, 5, 1, 0, 0, '2008-05-24 12:50:39', 2),
(10, 6, 1, 22, 7, 1, 0, 0, '2008-05-24 13:10:22', 2),
(12, 6, 1, 23, 22, 1, 0, 0, '2008-05-24 13:12:03', 2),
(2, 6, 1, 22, 1, 7, 0, 0, '2008-05-24 13:29:38', 3),
(2, 6, 2, 22, 1, 23, 22, 1, '2008-05-24 13:30:10', 3),
(3, 6, 2, 1, 2, 22, 1, 1, '2008-05-24 15:06:51', 4),
(7, 6, 2, 1, 22, 2, 1, 1, '2008-05-25 03:27:23', 5),
(13, 6, 2, 2, 1, 22, 7, 1, '2008-05-25 07:11:10', 3),
(4, 6, 2, 1, 2, 22, 1, 0, '2008-05-25 10:55:47', 2),
(1, 6, 2, 2, 22, 1, 22, 1, '2008-05-25 12:20:48', 3),
(11, 6, 2, 2, 1, 22, 1, 1, '2008-05-25 12:30:48', 4),
(12, 6, 2, 2, 1, 22, 2, -1, '2008-05-25 13:35:00', 2),
(10, 6, 2, 2, 1, 22, 1, 1, '2008-05-25 13:40:57', 4),
(9, 6, 2, 2, 22, 23, 2, -1, '2008-05-25 13:45:29', 2),
(8, 6, 2, 1, 2, 4, 7, 1, '2008-05-25 13:47:05', 3),
(3, 7, 1, 22, 1, 2, 0, 0, '2008-06-06 17:21:11', 3),
(13, 7, 1, 22, 2, 1, 0, 0, '2008-06-07 14:36:36', 4),
(7, 7, 1, 22, 4, 1, 0, 0, '2008-06-07 16:53:29', 6),
(11, 7, 1, 22, 1, 2, 0, 0, '2008-06-07 17:34:22', 3),
(1, 7, 1, 22, 1, 2, 0, 0, '2008-06-07 17:34:50', 3),
(9, 7, 1, 1, 22, 2, 0, 0, '2008-06-07 17:59:04', 2),
(8, 7, 1, 22, 1, 4, 0, 0, '2008-06-07 18:01:34', 4),
(12, 7, 1, 2, 22, 1, 0, 0, '2008-06-07 18:22:00', 3),
(10, 7, 1, 4, 2, 22, 0, 0, '2008-06-07 18:23:00', 2),
(1, 7, 2, 22, 1, 4, 22, 1, '2008-06-07 20:25:02', 2),
(3, 7, 2, 22, 1, 4, 1, -1, '2008-06-07 20:31:38', 2),
(7, 7, 2, 22, 1, 4, 22, -1, '2008-06-07 23:11:17', 1),
(13, 7, 2, 22, 1, 4, 9999, -1, '2008-06-08 10:40:06', 1),
(2, 7, 2, 22, 4, 1, 22, 1, '2008-06-08 11:51:50', 2),
(8, 7, 2, 4, 22, 2, 3, -1, '2008-06-08 16:32:20', 2),
(9, 7, 2, 22, 1, 4, 7, -1, '2008-06-08 16:35:46', 1),
(11, 7, 2, 22, 1, 4, 1, 1, '2008-06-08 17:45:01', 3),
(10, 7, 2, 22, 1, 4, 4, 1, '2008-06-08 18:52:25', 2),
(12, 7, 2, 22, 1, 4, 22, 1, '2008-06-08 18:56:59', 2),
(7, 8, 1, 2, 22, 23, 0, 0, '2008-06-20 14:05:43', 2),
(13, 8, 1, 4, 22, 2, 0, 0, '2008-06-20 15:32:21', 2),
(11, 8, 1, 2, 1, 22, 0, 0, '2008-06-20 19:47:20', 4),
(1, 8, 1, 1, 2, 4, 0, 0, '2008-06-20 19:47:50', 4),
(3, 8, 1, 2, 1, 23, 0, 0, '2008-06-21 12:17:38', 2),
(8, 8, 1, 2, 5, 23, 0, 0, '2008-06-21 13:02:58', 1),
(9, 8, 1, 1, 2, 4, 0, 0, '2008-06-21 13:03:31', 4),
(10, 8, 1, 2, 22, 1, 0, 0, '2008-06-21 13:34:49', 3),
(2, 8, 1, 1, 22, 5, 0, 0, '2008-06-21 13:51:51', 3),
(3, 8, 2, 1, 2, 22, 1, -1, '2008-06-21 15:27:18', 3),
(13, 8, 2, 1, 2, 4, 9999, -1, '2008-06-22 08:02:13', 2),
(1, 8, 2, 1, 2, 4, 1, 1, '2008-06-22 09:58:57', 2),
(12, 8, 2, 1, 2, 23, 1, -1, '2008-06-22 12:09:18', 3),
(10, 8, 2, 1, 2, 4, 1, -1, '2008-06-22 12:12:49', 3),
(9, 8, 2, 2, 1, 23, 22, 0, '2008-06-22 12:24:42', 5),
(8, 8, 2, 2, 5, 23, 22, -1, '2008-06-22 12:52:48', 2),
(11, 8, 2, 1, 2, 4, 1, 0, '2008-06-22 13:03:09', 4),
(2, 8, 2, 1, 2, 5, 1, 0, '2008-06-22 13:38:18', 4),
(7, 8, 2, 1, 2, 4, 1, 0, '2008-06-22 13:43:26', 4),
(7, 9, 1, 2, 22, 1, 0, 0, '2008-07-04 16:26:26', 2),
(3, 9, 1, 2, 22, 1, 0, 0, '2008-07-04 18:53:06', 2),
(9, 9, 1, 23, 2, 22, 0, 0, '2008-07-05 08:57:20', 2),
(8, 9, 1, 2, 22, 23, 0, 0, '2008-07-05 09:13:12', 1),
(13, 9, 1, 1, 23, 22, 0, 0, '2008-07-05 10:13:20', 2),
(10, 9, 1, 2, 1, 22, 0, 0, '2008-07-05 10:20:53', 1),
(12, 9, 1, 22, 1, 4, 0, 0, '2008-07-05 10:21:30', 1),
(11, 9, 1, 22, 2, 23, 0, 0, '2008-07-05 12:22:26', 1),
(1, 9, 1, 22, 2, 1, 0, 0, '2008-07-05 12:40:10', 2),
(2, 9, 1, 2, 22, 1, 0, 0, '2008-07-05 12:43:09', 2),
(7, 9, 2, 1, 22, 23, 23, -1, '2008-07-05 15:41:22', 1),
(1, 9, 2, 23, 22, 1, 22, 1, '2008-07-05 17:25:34', 0),
(3, 9, 2, 23, 1, 22, 23, -1, '2008-07-05 17:28:36', 1),
(13, 9, 2, 1, 23, 22, 4, -1, '2008-07-05 22:14:26', 1),
(11, 9, 2, 1, 23, 22, 23, 1, '2008-07-06 10:31:17', 0),
(8, 9, 2, 1, 22, 3, 2, 1, '2008-07-06 11:23:17', 1),
(9, 9, 2, 23, 1, 10, 1, 1, '2008-07-06 11:23:37', 0),
(10, 9, 2, 1, 22, 23, 1, -1, '2008-07-06 12:22:21', 2),
(12, 9, 2, 1, 22, 23, 1, 1, '2008-07-06 12:22:31', 1),
(2, 9, 2, 1, 23, 15, 1, 1, '2008-07-06 13:32:17', 0),
(13, 10, 2, 22, 2, 23, 4, 1, '2008-07-13 08:09:19', 4),
(13, 10, 1, 22, 2, 23, 0, 0, '2008-07-13 08:09:45', 6),
(3, 10, 1, 22, 2, 1, 0, 0, '2008-07-18 19:49:43', 4),
(9, 10, 1, 22, 23, 2, 0, 0, '2008-07-19 11:48:56', 4),
(8, 10, 1, 22, 1, 23, 0, 0, '2008-07-19 11:50:37', 4),
(1, 10, 1, 22, 2, 23, 0, 0, '2008-07-19 12:12:43', 6),
(11, 10, 1, 22, 2, 23, 0, 0, '2008-07-19 12:13:29', 6),
(12, 10, 1, 1, 22, 2, 0, 0, '2008-07-19 12:25:24', 2),
(10, 10, 1, 2, 22, 1, 0, 0, '2008-07-19 12:25:25', 2),
(7, 10, 1, 22, 23, 2, 0, 0, '2008-07-19 13:00:01', 4),
(2, 10, 1, 22, 2, 23, 0, 0, '2008-07-19 13:56:56', 6),
(7, 10, 2, 22, 2, 23, 22, -1, '2008-07-19 16:01:35', 3),
(3, 10, 2, 22, 2, 1, 22, 0, '2008-07-19 17:59:36', 2),
(1, 10, 2, 22, 2, 1, 2, 0, '2008-07-20 11:08:40', 2),
(11, 10, 2, 22, 23, 2, 22, -1, '2008-07-20 11:52:52', 4),
(10, 10, 2, 22, 2, 1, 1, -1, '2008-07-20 12:59:19', 3),
(8, 10, 2, 22, 23, 2, 5, 1, '2008-07-20 13:11:38', 5),
(9, 10, 2, 23, 2, 1, 1, -1, '2008-07-20 13:15:52', 1),
(2, 10, 2, 22, 2, 1, 2, 0, '2008-07-20 13:57:34', 2),
(7, 11, 1, 22, 2, 1, 0, 0, '2008-08-01 15:17:56', 3),
(3, 11, 1, 22, 2, 1, 0, 0, '2008-08-02 09:49:24', 3),
(13, 11, 1, 22, 23, 5, 0, 0, '2008-08-02 12:42:37', 4),
(9, 11, 1, 22, 23, 3, 0, 0, '2008-08-02 12:45:51', 4),
(8, 11, 1, 22, 2, 23, 0, 0, '2008-08-02 12:46:24', 4),
(1, 11, 1, 22, 2, 23, 0, 0, '2008-08-02 13:26:52', 4),
(10, 11, 1, 2, 22, 1, 0, 0, '2008-08-02 13:28:18', 2),
(11, 11, 1, 22, 23, 2, 0, 0, '2008-08-02 13:30:10', 6),
(2, 11, 1, 22, 2, 23, 0, 0, '2008-08-02 13:50:23', 4),
(1, 11, 2, 22, 2, 23, 22, 0, '2008-08-02 15:17:11', 2),
(3, 11, 2, 22, 2, 23, 22, 0, '2008-08-02 19:04:00', 2),
(7, 11, 2, 22, 2, 4, 22, 0, '2008-08-03 05:49:49', 1),
(9, 11, 2, 22, 23, 4, 1, -1, '2008-08-03 10:08:12', 2),
(13, 11, 2, 22, 2, 23, 22, 0, '2008-08-03 10:21:54', 2),
(8, 11, 2, 22, 4, 23, 2, -1, '2008-08-03 10:30:55', 1),
(10, 11, 2, 22, 2, 4, 1, -1, '2008-08-03 12:00:10', 1),
(11, 11, 2, 22, 23, 2, 22, 0, '2008-08-03 13:00:32', 2),
(2, 11, 2, 22, 2, 23, 22, 1, '2008-08-03 13:52:27', 0),
(3, 12, 1, 1, 22, 2, 0, 0, '2008-08-22 21:18:30', 3),
(7, 12, 1, 2, 22, 15, 0, 0, '2008-08-23 00:39:58', 4),
(13, 12, 2, 22, 2, 5, 2, 1, '2008-08-23 08:01:42', 2),
(13, 12, 1, 2, 1, 22, 0, 0, '2008-08-23 08:02:21', 3),
(8, 12, 1, 4, 1, 2, 0, 0, '2008-08-23 12:38:44', 2),
(9, 12, 1, 1, 4, 2, 0, 0, '2008-08-23 12:45:02', 2),
(1, 12, 1, 2, 22, 1, 0, 0, '2008-08-23 13:10:05', 4),
(11, 12, 1, 2, 22, 4, 0, 0, '2008-08-23 13:30:25', 6),
(2, 12, 1, 1, 22, 2, 0, 0, '2008-08-23 13:38:45', 3),
(7, 12, 2, 22, 1, 2, 22, -1, '2008-08-23 15:09:43', 2),
(3, 12, 2, 2, 22, 1, 2, 1, '2008-08-23 16:51:28', 4),
(9, 12, 2, 2, 4, 23, 1, 1, '2008-08-24 10:45:44', 2),
(8, 12, 2, 2, 23, 22, 22, 1, '2008-08-24 10:49:22', 2),
(1, 12, 2, 2, 22, 1, 1, 1, '2008-08-24 11:55:50', 3),
(10, 12, 2, 2, 22, 1, 1, 1, '2008-08-24 12:39:37', 3),
(12, 12, 2, 2, 22, 1, 1, -1, '2008-08-24 12:40:45', 4),
(2, 12, 2, 2, 22, 1, 1, 1, '2008-08-24 13:45:38', 3),
(11, 12, 2, 22, 2, 1, 22, 1, '2008-08-24 13:49:37', 1),
(7, 13, 1, 2, 1, 22, 0, 0, '2008-09-05 15:24:44', 2),
(3, 13, 1, 2, 22, 23, 0, 0, '2008-09-06 09:59:36', 4),
(10, 13, 1, 1, 2, 22, 0, 0, '2008-09-06 11:21:15', 3),
(12, 13, 1, 1, 2, 22, 0, 0, '2008-09-06 11:21:50', 3),
(11, 13, 1, 2, 22, 23, 0, 0, '2008-09-06 11:54:10', 4),
(1, 13, 1, 2, 22, 1, 0, 0, '2008-09-06 12:02:08', 2),
(9, 13, 1, 2, 23, 22, 0, 0, '2008-09-06 13:41:52', 3),
(8, 13, 1, 1, 3, 22, 0, 0, '2008-09-06 13:42:24', 1),
(2, 13, 1, 22, 2, 1, 0, 0, '2008-09-06 13:48:19', 4),
(1, 13, 2, 22, 23, 1, 22, 0, '2008-09-06 15:16:37', 2),
(7, 13, 2, 22, 2, 1, 22, 0, '2008-09-06 15:59:14', 3),
(3, 13, 2, 22, 2, 1, 2, 0, '2008-09-07 10:24:57', 3),
(9, 13, 2, 22, 23, 1, 1, -1, '2008-09-07 10:39:47', 2),
(10, 13, 2, 2, 22, 1, 1, 0, '2008-09-07 11:00:29', 5),
(12, 13, 2, 22, 2, 23, 1, -1, '2008-09-07 11:01:10', 3),
(8, 13, 2, 1, 2, 23, 22, 1, '2008-09-07 11:23:34', 0),
(11, 13, 2, 22, 2, 23, 22, 1, '2008-09-07 13:29:07', 1),
(13, 13, 2, 1, 22, 4, 2, -1, '2008-09-07 13:34:05', 1),
(2, 13, 2, 22, 2, 1, 22, 0, '2008-09-07 13:49:53', 3),
(13, 14, 1, 1, 22, 2, 0, 0, '2008-09-12 09:59:43', 0),
(13, 14, 2, 22, 2, 23, 1, 1, '2008-09-12 10:00:41', 3),
(7, 14, 1, 1, 22, 2, 0, 0, '2008-09-12 15:50:31', 0),
(3, 14, 1, 1, 2, 22, 0, 0, '2008-09-13 08:24:16', 0),
(10, 14, 1, 2, 1, 22, 0, 0, '2008-09-13 11:38:17', 0),
(12, 14, 1, 2, 1, 22, 0, 0, '2008-09-13 11:38:42', 0),
(9, 14, 1, 2, 1, 22, 0, 0, '2008-09-13 12:42:26', 0),
(8, 14, 1, 1, 22, 3, 0, 0, '2008-09-13 12:43:27', 0),
(2, 14, 1, 22, 1, 15, 0, 0, '2008-09-13 13:30:58', 1),
(1, 14, 1, 22, 1, 2, 0, 0, '2008-09-13 13:38:18', 0),
(11, 14, 1, 22, 2, 4, 0, 0, '2008-09-13 13:44:31', 0),
(3, 14, 2, 23, 2, 15, 23, 1, '2008-09-13 16:41:29', 3),
(7, 14, 2, 15, 23, 2, 2, 1, '2008-09-14 08:29:51', 5),
(8, 14, 2, 23, 2, 7, 1, 1, '2008-09-14 12:55:53', 3),
(9, 14, 2, 23, 2, 15, 2, -1, '2008-09-14 12:56:58', 2),
(1, 14, 2, 23, 2, 3, 22, 1, '2008-09-14 13:02:28', 2),
(12, 14, 2, 23, 2, 10, 22, -1, '2008-09-14 13:35:18', 1),
(10, 14, 2, 2, 23, 15, 23, 1, '2008-09-14 13:38:33', 4),
(11, 14, 2, 23, 15, 2, 23, 1, '2008-09-14 13:42:54', 3),
(2, 14, 2, 23, 15, 14, 22, 1, '2008-09-14 13:53:13', 3),
(13, 15, 1, 22, 1, 2, 0, 0, '2008-09-26 13:22:15', 3),
(7, 15, 1, 22, 2, 1, 0, 0, '2008-09-27 00:52:38', 4),
(3, 15, 1, 22, 2, 1, 0, 0, '2008-09-27 09:57:15', 4),
(2, 15, 1, 22, 2, 5, 0, 0, '2008-09-27 12:34:34', 2),
(9, 15, 1, 2, 22, 23, 0, 0, '2008-09-27 13:59:57', 4),
(12, 15, 1, 22, 2, 4, 0, 0, '2008-09-27 14:41:01', 2),
(10, 15, 1, 22, 2, 4, 0, 0, '2008-09-27 14:41:34', 2),
(11, 15, 1, 22, 2, 4, 0, 0, '2008-09-27 15:29:56', 2),
(1, 15, 1, 22, 2, 23, 0, 0, '2008-09-27 15:35:22', 2),
(3, 15, 2, 2, 22, 1, 2, -1, '2008-09-27 18:01:02', 1),
(7, 15, 2, 2, 22, 1, 2, -1, '2008-09-27 23:14:29', 1),
(1, 15, 2, 2, 22, 1, 1, 1, '2008-09-28 09:43:10', 3),
(11, 15, 2, 22, 2, 1, 1, 1, '2008-09-28 11:36:30', 3),
(9, 15, 2, 2, 1, 23, 1, -1, '2008-09-28 12:22:12', 1),
(13, 15, 2, 22, 1, 4, 2, 1, '2008-09-28 12:28:01', 2),
(8, 15, 2, 2, 22, 23, 5, -1, '2008-09-28 13:18:17', 1),
(12, 15, 2, 2, 1, 22, 1, -1, '2008-09-28 13:47:00', 3),
(10, 15, 2, 2, 1, 22, 1, 1, '2008-09-28 13:47:53', 4),
(2, 15, 2, 2, 22, 1, 9999, -1, '2008-09-28 13:57:09', 1),
(13, 16, 1, 22, 2, 5, 0, 0, '2008-10-10 15:11:02', 2),
(13, 16, 2, 22, 2, 5, 1, 1, '2008-10-10 15:11:40', 0),
(7, 16, 1, 22, 2, 23, 0, 0, '2008-10-10 15:13:27', 4),
(3, 16, 1, 22, 2, 1, 0, 0, '2008-10-10 18:05:40', 3),
(1, 16, 1, 22, 2, 1, 0, 0, '2008-10-10 23:54:32', 3),
(11, 16, 1, 22, 2, 1, 0, 0, '2008-10-11 00:16:19', 3),
(3, 16, 2, 22, 2, 1, 22, -1, '2008-10-11 09:59:43', 2),
(7, 16, 2, 22, 2, 1, 22, 0, '2008-10-11 16:58:40', 3),
(9, 16, 2, 22, 23, 1, 1, -1, '2008-10-11 20:04:07', 2),
(8, 16, 2, 22, 2, 5, 12, 1, '2008-10-11 23:59:44', 0),
(11, 16, 2, 22, 2, 1, 1, 0, '2008-10-12 00:24:14', 3),
(1, 16, 2, 22, 2, 1, 1, 0, '2008-10-12 01:15:29', 3),
(2, 16, 2, 22, 23, 2, 22, 0, '2008-10-12 06:25:26', 1),
(13, 17, 1, 22, 1, 2, 0, 0, '2008-10-17 14:39:58', 6),
(3, 17, 1, 22, 2, 1, 0, 0, '2008-10-17 16:44:37', 4),
(9, 17, 1, 22, 2, 5, 0, 0, '2008-10-17 19:49:45', 3),
(8, 17, 1, 22, 5, 2, 0, 0, '2008-10-17 20:07:50', 4),
(7, 17, 1, 22, 2, 5, 0, 0, '2008-10-17 18:26:39', 3),
(1, 17, 1, 22, 2, 1, 0, 0, '2008-10-17 20:33:56', 4),
(11, 17, 1, 22, 2, 1, 0, 0, '2008-10-17 22:23:25', 4),
(2, 17, 1, 22, 5, 23, 0, 0, '2008-10-18 07:58:06', 2),
(3, 17, 2, 2, 1, 22, 2, -1, '2008-10-18 10:53:00', 3),
(9, 17, 2, 22, 2, 23, 1, 0, '2008-10-18 17:03:50', 5),
(7, 17, 2, 22, 2, 5, 22, -1, '2008-10-18 17:12:32', 5),
(8, 17, 2, 2, 5, 22, 4, 0, '2008-10-18 17:23:18', 3),
(13, 17, 2, 2, 1, 5, 1, -1, '2008-10-18 20:00:39', 2),
(11, 17, 2, 22, 2, 1, 22, -1, '2008-10-18 21:47:55', 7),
(1, 17, 2, 22, 2, 1, 1, 0, '2008-10-18 21:48:53', 7),
(2, 17, 2, 22, 2, 1, 22, 0, '2008-10-19 08:49:19', 8),
(13, 18, 1, 1, 2, 22, 0, 0, '2008-10-31 12:05:12', 2),
(7, 18, 1, 2, 22, 5, 0, 0, '2008-11-01 00:16:21', 2),
(3, 18, 1, 2, 1, 22, 0, 0, '2008-11-01 08:04:45', 3),
(8, 18, 1, 22, 2, 1, 0, 0, '2008-11-01 14:46:39', 3),
(9, 18, 1, 2, 22, 5, 0, 0, '2008-11-01 14:48:13', 2),
(2, 18, 1, 2, 5, 22, 0, 0, '2008-11-01 15:27:01', 2),
(11, 18, 1, 22, 2, 5, 0, 0, '2008-11-01 15:57:57', 1),
(1, 18, 1, 2, 22, 5, 0, 0, '2008-11-01 16:29:12', 2),
(3, 18, 2, 2, 11, 1, 2, 0, '2008-11-01 18:03:40', 4),
(1, 18, 2, 2, 1, 22, 1, 0, '2008-11-02 07:05:19', 2),
(11, 18, 2, 2, 1, 22, 2, 1, '2008-11-02 10:18:49', 5),
(9, 18, 2, 2, 1, 5, 1, 0, '2008-11-02 12:23:25', 3),
(13, 18, 2, 2, 1, 22, 1, -1, '2008-11-02 12:42:13', 3),
(8, 18, 2, 2, 11, 1, 5, 1, '2008-11-02 12:44:40', 5),
(7, 18, 2, 2, 1, 22, 2, -1, '2008-11-02 16:30:21', 4),
(2, 18, 2, 2, 1, 22, 22, 1, '2008-11-02 17:57:13', 4);
        