-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 18. Juni 2010 um 04:06
-- Server Version: 4.1.18
-- PHP-Version: 4.4.2
-- 
-- Datenbank: `niki_2009`
-- 

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

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

DROP TABLE IF EXISTS `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, 'HAMILTON', 'Lewis'),
(2, 'KOVALAINEN', 'Heikki'),
(3, 'MASSA', 'Felipe'),
(4, 'RAIKKONEN', 'Kimi'),
(5, 'KUBICA', 'Robert'),
(6, 'HEIDFELD', 'Nick'),
(7, 'ALONSO', 'Fernando'),
(8, 'PIQUET', 'Nelson Jr.'),
(9, 'TRULLI', 'Jarno'),
(10, 'GLOCK', 'Timo'),
(11, 'BOURDAIS', 'Sebastien'),
(12, 'BUEMI', 'Sebastien'),
(14, 'WEBBER', 'Mark'),
(15, 'VETTEL', 'Sebastian'),
(16, 'ROSBERG', 'Nico'),
(17, 'NAKAJIMA', 'Kazuki'),
(18, 'SUTIL', 'Adrian'),
(19, 'FISICHELLA', 'Giancarlo'),
(20, 'BUTTON', 'Jenson'),
(21, 'BARRICHELLO', 'Rubens'),
(22, 'DE LA ROSA', 'Pedro'),
(23, 'PAFFETT', 'Gary'),
(24, 'BADOER', 'Luca'),
(25, 'GENE', 'Marc'),
(26, 'KLIEN', 'Christian'),
(27, 'GROSJEAN', 'Romain'),
(28, 'KOBAYASHI', 'Kamui'),
(29, 'HUELKENBERG', 'Nico'),
(30, 'LIUZZI', 'Vitantonio'),
(31, 'DAVIDSON', 'Anthony'),
(32, 'HARTLEY', 'Brendon'),
(33, 'ALGUERSUARI', 'Jaime'),
(34, 'SCHUMACHER', 'Michael');

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

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

DROP TABLE IF EXISTS `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`
-- 

DROP TABLE IF EXISTS `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=34 ;

-- 
-- 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)', '2009-03-28 07:00:00', '2009-03-29 08:00:00', 'flag_AUSTRALIA.gif', 'circuit_AUSTRALIA.gif'),
(2, 'MALAYSIA (Sepang)', '2009-04-04 11:00:00', '2009-04-05 11:00:00', 'flag_MALAYSIA.gif', 'circuit_MALAYSIA.gif'),
(3, 'CHINA (Shanghai)', '2009-04-18 08:00:00', '2009-04-19 09:00:00', 'flag_CHINA.gif', 'circuit_CHINA.gif'),
(4, 'BAHRAIN (Sakhir)', '2009-04-25 13:00:00', '2009-04-26 14:00:00', 'flag_BAHRAIN.gif', 'circuit_BAHRAIN.gif'),
(5, 'SPAIN (Barcelona)', '2009-05-09 14:00:00', '2009-05-10 14:00:00', 'flag_SPAIN.gif', 'circuit_SPAIN_(Barcelona).gif'),
(6, 'MONACO (Monte Carlo)', '2009-05-23 14:00:00', '2009-05-24 14:00:00', 'flag_MONACO.gif', 'circuit_MONACO.gif'),
(7, 'TURKEY (Istanbul)', '2009-06-06 13:00:00', '2009-06-07 14:00:00', 'flag_TURKEY.gif', 'circuit_TURKEY.gif'),
(8, 'GREAT BRITAIN (Silverstone)', '2009-06-20 14:00:00', '2009-06-21 14:00:00', 'flag_UK.gif', 'circuit_UK.gif'),
(9, 'GERMANY (Nuerburgring)', '2009-07-11 14:00:00', '2009-07-12 14:00:00', 'flag_GERMANY.gif', 'circuit_GERMANY_(Nuerburgring).gif'),
(10, 'HUNGARY (Budapest)', '2009-07-25 14:00:00', '2009-07-26 14:00:00', 'flag_HUNGARY.gif', 'circuit_HUNGARY.gif'),
(11, 'EUROPE (Valencia)', '2009-08-22 14:00:00', '2009-08-23 14:00:00', 'flag_EUROPE.gif', 'circuit_EUROPE_(Valencia).gif'),
(12, 'BELGIUM (Spa)', '2009-08-29 14:00:00', '2009-08-30 14:00:00', 'flag_BELGIUM.gif', 'circuit_BELGIUM.gif'),
(13, 'ITALY (Monza)', '2009-09-12 14:00:00', '2009-09-13 14:00:00', 'flag_ITALY.gif', 'circuit_ITALY.gif'),
(14, 'SINGAPORE (Singapore)', '2009-09-26 16:00:00', '2009-09-27 14:00:00', 'flag_SINGAPORE.gif', 'circuit_SINGAPORE.gif'),
(15, 'JAPAN (Suzuka)', '2009-10-03 07:00:00', '2009-10-04 07:00:00', 'flag_JAPAN.gif', 'circuit_JAPAN_(Suzuka).gif'),
(16, 'BRAZIL (Sao Paulo)', '2009-10-17 19:00:00', '2009-10-18 18:00:00', 'flag_BRAZIL.gif', 'circuit_BRAZIL.gif'),
(17, 'UNITED ARAB EMIRATES (Abu Dhabi)', '2009-10-31 14:00:00', '2009-11-01 14:00:00', 'flag_UAE.gif', 'circuit_UAE.gif');

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

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

DROP TABLE IF EXISTS `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, 20, 21, 15, 0, -1),
(1, 2, 20, 21, 9, 16, 1),
(2, 1, 20, 9, 15, 0, -1),
(2, 2, 20, 6, 10, 20, 1),
(3, 1, 15, 7, 14, 0, -1),
(3, 2, 15, 14, 20, 21, 1),
(4, 1, 9, 10, 15, 0, -1),
(4, 2, 20, 15, 9, 9, 0),
(5, 1, 20, 15, 21, 0, -1),
(5, 2, 20, 21, 14, 21, 1),
(6, 1, 20, 4, 21, 0, -1),
(6, 2, 20, 21, 4, 3, 0),
(7, 1, 15, 20, 21, 0, -1),
(7, 2, 20, 14, 15, 20, 0),
(8, 1, 15, 21, 14, 0, -1),
(8, 2, 15, 14, 21, 15, 0),
(9, 1, 14, 21, 20, 0, -1),
(9, 2, 14, 15, 3, 7, 0),
(10, 1, 7, 15, 14, 0, -1),
(10, 2, 1, 4, 14, 14, 0),
(11, 1, 1, 2, 21, 0, -1),
(11, 2, 21, 1, 4, 10, 0),
(12, 1, 19, 9, 6, 0, -1),
(12, 2, 4, 19, 15, 15, 1),
(13, 1, 1, 18, 4, 0, -1),
(13, 2, 21, 20, 4, 18, 1),
(14, 1, 1, 15, 16, 0, -1),
(14, 2, 1, 10, 7, 7, 1),
(15, 1, 15, 9, 1, 0, -1),
(15, 2, 15, 9, 1, 14, 1),
(16, 1, 21, 14, 18, 0, -1),
(16, 2, 14, 5, 1, 14, 1),
(17, 1, 1, 15, 14, 0, -1),
(17, 2, 15, 14, 20, 15, 0);

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

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

DROP TABLE IF EXISTS `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 (9, 1, 1, 16, 21, 17, 0, 0, '2009-03-27 12:12:15', 2),
(8, 1, 1, 16, 21, 4, 0, 0, '2009-03-27 12:29:24', 2),
(13, 1, 1, 20, 4, 21, 0, 0, '2009-03-27 14:50:53', 3),
(3, 1, 1, 20, 16, 21, 0, 0, '2009-03-27 17:14:11', 3),
(7, 1, 1, 4, 16, 21, 0, 0, '2009-03-27 18:37:55', 1),
(1, 1, 1, 4, 21, 3, 0, 0, '2009-03-27 19:37:59', 2),
(10, 1, 1, 4, 3, 21, 0, 0, '2009-03-27 21:42:18', 1),
(11, 1, 1, 4, 1, 2, 0, 0, '2009-03-27 21:53:49', 0),
(12, 1, 1, 4, 1, 3, 0, 0, '2009-03-27 22:27:49', 0),
(3, 1, 2, 21, 20, 15, 21, -1, '2009-03-28 09:30:16', 2),
(1, 1, 2, 21, 20, 15, 21, 1, '2009-03-28 15:03:03', 3),
(7, 1, 2, 20, 15, 21, 20, -1, '2009-03-28 17:13:40', 3),
(9, 1, 2, 21, 20, 16, 10, -1, '2009-03-28 19:23:36', 2),
(8, 1, 2, 16, 20, 5, 16, 1, '2009-03-28 19:26:54', 3),
(13, 1, 2, 20, 21, 5, 20, -1, '2009-03-28 22:10:28', 4),
(11, 1, 2, 21, 15, 5, 21, 0, '2009-03-28 22:15:28', 0),
(12, 1, 2, 20, 9, 5, 20, -1, '2009-03-28 22:21:07', 3),
(10, 1, 2, 20, 15, 3, 20, -1, '2009-03-28 22:26:16', 2),
(2, 1, 2, 20, 21, 15, 21, 0, '2009-03-29 07:50:37', 3),
(14, 2, 2, 21, 20, 4, 20, 0, '2009-04-03 09:44:06', 1),
(14, 2, 1, 20, 21, 4, 0, 0, '2009-04-03 09:44:37', 2),
(12, 2, 1, 20, 5, 1, 0, 0, '2009-04-03 11:47:03', 2),
(13, 2, 1, 20, 4, 16, 0, 0, '2009-04-03 13:01:42', 2),
(3, 2, 1, 20, 21, 4, 0, 0, '2009-04-03 16:39:07', 2),
(9, 2, 1, 3, 20, 4, 0, 0, '2009-04-03 20:08:48', 1),
(8, 2, 1, 3, 16, 20, 0, 0, '2009-04-03 20:11:15', 1),
(4, 2, 1, 20, 16, 3, 0, 0, '2009-04-03 22:03:55', 2),
(7, 2, 1, 4, 3, 15, 0, 0, '2009-04-03 23:39:28', 2),
(1, 2, 1, 4, 21, 3, 0, 0, '2009-04-04 10:34:03', 0),
(11, 2, 1, 3, 14, 9, 0, 0, '2009-04-04 10:34:36', 1),
(2, 2, 1, 3, 20, 16, 0, 0, '2009-04-04 10:35:59', 1),
(10, 2, 1, 4, 15, 3, 0, 0, '2009-04-04 10:37:26', 1),
(3, 2, 2, 20, 9, 4, 20, -1, '2009-04-04 14:27:34', 3),
(9, 2, 2, 20, 5, 16, 21, -1, '2009-04-04 18:33:21', 2),
(8, 2, 2, 9, 20, 16, 20, 1, '2009-04-04 21:24:20', 3),
(7, 2, 2, 20, 15, 21, 20, -1, '2009-04-04 22:31:08', 3),
(4, 2, 2, 9, 20, 16, 20, 1, '2009-04-05 07:32:20', 3),
(13, 2, 2, 20, 9, 5, 15, -1, '2009-04-05 08:06:45', 2),
(2, 2, 2, 20, 9, 21, 21, 1, '2009-04-05 10:20:57', 3),
(1, 2, 2, 20, 9, 5, 21, 0, '2009-04-05 10:31:11', 1),
(11, 2, 2, 20, 9, 16, 20, 1, '2009-04-05 10:33:32', 4),
(12, 2, 2, 20, 9, 5, 9999, -1, '2009-04-05 10:34:59', 2),
(10, 2, 2, 20, 5, 9, 16, -1, '2009-04-05 10:36:56', 2),
(13, 3, 1, 20, 21, 9, 0, 0, '2009-04-17 14:16:27', 0),
(3, 3, 1, 20, 21, 9, 0, 0, '2009-04-17 16:26:12', 0),
(1, 3, 1, 20, 21, 15, 0, 0, '2009-04-17 22:43:44', 1),
(11, 3, 1, 20, 21, 16, 0, 0, '2009-04-17 22:44:24', 0),
(8, 3, 1, 20, 15, 16, 0, 0, '2009-04-17 22:49:07', 1),
(9, 3, 1, 20, 21, 14, 0, 0, '2009-04-17 22:49:40', 2),
(7, 3, 1, 20, 16, 21, 0, 0, '2009-04-17 23:47:26', 0),
(10, 3, 1, 15, 20, 9, 0, 0, '2009-04-18 00:24:17', 2),
(12, 3, 1, 20, 9, 21, 0, 0, '2009-04-18 00:25:22', 0),
(2, 3, 1, 20, 9, 21, 0, 0, '2009-04-18 07:52:47', 0),
(3, 3, 2, 14, 20, 21, 20, -1, '2009-04-18 10:10:30', 2),
(1, 3, 2, 15, 20, 21, 16, 0, '2009-04-18 12:38:36', 2),
(8, 3, 2, 15, 16, 20, 4, -1, '2009-04-18 18:13:19', 4),
(9, 3, 2, 21, 20, 16, 15, -1, '2009-04-18 18:15:23', 1),
(7, 3, 2, 15, 7, 20, 15, -1, '2009-04-18 18:39:31', 4),
(13, 3, 2, 7, 9, 20, 16, 1, '2009-04-18 18:54:24', 3),
(11, 3, 2, 15, 20, 21, 7, 0, '2009-04-18 23:10:34', 2),
(4, 3, 2, 7, 15, 20, 7, 1, '2009-04-19 07:20:39', 4),
(2, 3, 2, 20, 15, 21, 20, 1, '2009-04-19 08:50:15', 3),
(10, 3, 2, 15, 20, 21, 15, 1, '2009-04-19 08:53:59', 4),
(12, 3, 2, 20, 15, 21, 14, 1, '2009-04-19 08:54:49', 3),
(14, 4, 1, 21, 15, 20, 0, 0, '2009-04-24 17:45:12', 1),
(14, 4, 2, 21, 10, 15, 20, 1, '2009-04-24 17:45:45', 0),
(7, 4, 1, 15, 20, 14, 0, 0, '2009-04-24 19:15:56', 1),
(13, 4, 1, 20, 15, 9, 0, 0, '2009-04-24 21:38:14', 2),
(3, 4, 1, 20, 15, 9, 0, 0, '2009-04-25 08:49:52', 2),
(9, 4, 1, 15, 14, 20, 0, 0, '2009-04-25 10:02:13', 1),
(8, 4, 1, 15, 16, 21, 0, 0, '2009-04-25 10:02:40', 1),
(4, 4, 1, 16, 20, 1, 0, 0, '2009-04-25 10:56:38', 0),
(1, 4, 1, 20, 21, 15, 0, 0, '2009-04-25 12:15:11', 2),
(2, 4, 1, 9, 20, 3, 0, 0, '2009-04-25 12:42:30', 2),
(12, 4, 1, 20, 14, 21, 0, 0, '2009-04-25 12:44:04', 0),
(11, 4, 1, 15, 20, 1, 0, 0, '2009-04-25 12:47:02', 1),
(10, 4, 1, 15, 20, 21, 0, 0, '2009-04-25 12:48:38', 1),
(3, 4, 2, 15, 9, 20, 15, -1, '2009-04-25 16:18:19', 3),
(9, 4, 2, 15, 20, 9, 16, -1, '2009-04-25 18:11:24', 4),
(8, 4, 2, 1, 21, 10, 9, 0, '2009-04-25 18:12:05', 2),
(7, 4, 2, 15, 9, 1, 15, -1, '2009-04-26 04:04:48', 2),
(1, 4, 2, 15, 20, 9, 10, 0, '2009-04-26 07:11:00', 5),
(4, 4, 2, 9, 21, 15, 15, 1, '2009-04-26 07:59:04', 1),
(13, 4, 2, 15, 20, 10, 15, -1, '2009-04-26 08:46:27', 2),
(2, 4, 2, 15, 9, 20, 15, 0, '2009-04-26 12:42:55', 4),
(11, 4, 2, 15, 20, 9, 9, 0, '2009-04-26 13:09:55', 6),
(12, 4, 2, 15, 10, 20, 14, -1, '2009-04-26 13:37:30', 2),
(10, 4, 2, 15, 20, 9, 15, -1, '2009-04-26 13:39:03', 4),
(9, 5, 1, 20, 14, 16, 0, 0, '2009-05-08 19:56:33', 2),
(8, 5, 1, 20, 7, 17, 0, 0, '2009-05-08 19:57:25', 2),
(4, 5, 1, 5, 20, 15, 0, 0, '2009-05-08 22:31:29', 2),
(7, 5, 1, 20, 21, 10, 0, 0, '2009-05-08 22:55:23', 3),
(13, 5, 1, 20, 21, 16, 0, 0, '2009-05-09 10:19:36', 3),
(3, 5, 1, 20, 15, 9, 0, 0, '2009-05-09 10:29:56', 4),
(11, 5, 1, 20, 4, 1, 0, 0, '2009-05-09 13:23:51', 2),
(10, 5, 1, 20, 4, 3, 0, 0, '2009-05-09 13:35:53', 2),
(12, 5, 1, 20, 4, 3, 0, 0, '2009-05-09 13:36:15', 2),
(1, 5, 1, 20, 9, 15, 0, 0, '2009-05-09 13:39:20', 3),
(2, 5, 1, 20, 3, 9, 0, 0, '2009-05-09 13:56:19', 2),
(7, 5, 2, 20, 15, 21, 20, -1, '2009-05-09 15:30:16', 3),
(3, 5, 2, 20, 15, 21, 15, -1, '2009-05-09 17:24:27', 3),
(9, 5, 2, 20, 15, 14, 15, 0, '2009-05-09 20:01:02', 3),
(8, 5, 2, 20, 21, 15, 21, -1, '2009-05-09 20:01:30', 5),
(1, 5, 2, 20, 15, 3, 20, 0, '2009-05-10 00:03:01', 1),
(11, 5, 2, 20, 15, 21, 20, 0, '2009-05-10 00:34:30', 2),
(4, 5, 2, 20, 3, 15, 20, 0, '2009-05-10 06:28:29', 1),
(13, 5, 2, 15, 20, 3, 15, -1, '2009-05-10 09:01:09', 1),
(10, 5, 2, 15, 20, 3, 3, -1, '2009-05-10 11:42:39', 1),
(12, 5, 2, 20, 15, 21, 15, -1, '2009-05-10 11:43:37', 3),
(2, 5, 2, 15, 20, 21, 9999, -1, '2009-05-10 12:52:18', 2),
(15, 6, 2, 15, 20, 14, 15, 1, '2009-05-11 15:39:10', 0),
(15, 6, 1, 20, 14, 15, 0, 0, '2009-05-11 15:39:35', 2),
(13, 6, 1, 15, 20, 3, 0, 0, '2009-05-22 09:32:50', 1),
(7, 6, 1, 20, 21, 1, 0, 0, '2009-05-22 22:14:12', 3),
(4, 6, 1, 3, 21, 20, 0, 0, '2009-05-23 07:37:10', 2),
(8, 6, 1, 16, 21, 1, 0, 0, '2009-05-23 07:49:12', 1),
(9, 6, 1, 20, 3, 21, 0, 0, '2009-05-23 07:50:15', 4),
(3, 6, 1, 20, 21, 15, 0, 0, '2009-05-23 12:49:43', 3),
(12, 6, 1, 9, 15, 3, 0, 0, '2009-05-23 13:17:46', 0),
(10, 6, 1, 15, 14, 3, 0, 0, '2009-05-23 13:24:45', 0),
(1, 6, 1, 21, 15, 20, 0, 0, '2009-05-23 13:33:09', 2),
(11, 6, 1, 21, 3, 20, 0, 0, '2009-05-23 13:33:59', 2),
(2, 6, 1, 20, 21, 16, 0, 0, '2009-05-23 13:55:06', 3),
(9, 6, 2, 20, 21, 15, 15, -1, '2009-05-23 16:16:15', 4),
(8, 6, 2, 20, 21, 4, 4, 1, '2009-05-23 16:16:53', 5),
(3, 6, 2, 20, 4, 21, 15, -1, '2009-05-23 18:08:01', 4),
(13, 6, 2, 20, 4, 21, 20, -1, '2009-05-24 11:16:34', 4),
(1, 6, 2, 20, 21, 4, 20, 1, '2009-05-24 12:57:07', 5),
(11, 6, 2, 20, 21, 4, 4, 1, '2009-05-24 12:57:48', 5),
(10, 6, 2, 21, 20, 4, 21, 1, '2009-05-24 13:15:49', 3),
(4, 6, 2, 20, 15, 3, 20, 1, '2009-05-24 13:39:43', 1),
(12, 6, 2, 20, 15, 21, 9999, -1, '2009-05-24 13:44:08', 3),
(2, 6, 2, 20, 21, 4, 20, 1, '2009-05-24 13:48:42', 5),
(14, 7, 2, 15, 20, 6, 20, 0, '2009-06-05 09:21:10', 4),
(14, 7, 1, 20, 21, 15, 0, 0, '2009-06-05 09:21:57', 3),
(15, 7, 1, 20, 4, 15, 0, 0, '2009-06-05 16:13:26', 2),
(7, 7, 1, 20, 21, 4, 0, 0, '2009-06-05 16:49:21', 2),
(13, 7, 1, 15, 20, 21, 0, 0, '2009-06-05 22:09:11', 6),
(3, 7, 1, 20, 3, 15, 0, 0, '2009-06-06 11:37:17', 2),
(10, 7, 1, 3, 9, 20, 0, 0, '2009-06-06 12:21:21', 1),
(2, 7, 1, 3, 21, 20, 0, 0, '2009-06-06 12:39:18', 2),
(12, 7, 1, 20, 3, 15, 0, 0, '2009-06-06 12:55:29', 2),
(9, 7, 1, 20, 15, 21, 0, 0, '2009-06-06 09:00:00', 4),
(3, 7, 2, 20, 15, 21, 15, -1, '2009-06-06 17:15:58', 3),
(9, 7, 2, 20, 21, 15, 20, -1, '2009-06-06 19:12:00', 5),
(7, 7, 2, 20, 15, 14, 20, -1, '2009-06-06 22:55:35', 5),
(8, 7, 2, 20, 9, 15, 3, -1, '2009-06-07 09:40:37', 4),
(13, 7, 2, 15, 20, 21, 15, 0, '2009-06-07 10:06:38', 3),
(11, 7, 2, 15, 20, 4, 3, -1, '2009-06-07 12:22:18', 2),
(12, 7, 2, 15, 20, 21, 14, -1, '2009-06-07 12:48:40', 2),
(10, 7, 2, 20, 15, 14, 14, 0, '2009-06-07 12:50:45', 5),
(1, 7, 2, 15, 20, 14, 4, 0, '2009-06-07 13:26:51', 4),
(2, 7, 2, 20, 15, 21, 21, 0, '2009-06-07 13:57:22', 4),
(14, 8, 1, 4, 20, 21, 0, 0, '2009-06-19 10:55:12', 1),
(14, 8, 2, 20, 15, 1, 20, 0, '2009-06-19 10:56:16', 2),
(9, 8, 1, 15, 20, 14, 0, 0, '2009-06-19 21:00:01', 4),
(7, 8, 1, 15, 20, 14, 0, 0, '2009-06-19 21:04:19', 4),
(13, 8, 1, 20, 15, 14, 0, 0, '2009-06-20 06:37:20', 3),
(4, 8, 1, 15, 20, 14, 0, 0, '2009-06-20 08:51:13', 4),
(11, 8, 1, 20, 15, 14, 0, 0, '2009-06-20 09:24:15', 3),
(1, 8, 1, 15, 20, 14, 0, 0, '2009-06-20 09:25:00', 4),
(3, 8, 1, 15, 20, 14, 0, 0, '2009-06-20 09:36:53', 4),
(8, 8, 1, 16, 15, 9, 0, 0, '2009-06-20 12:30:16', 1),
(10, 8, 1, 15, 20, 14, 0, 0, '2009-06-20 13:44:49', 4),
(12, 8, 1, 15, 20, 14, 0, 0, '2009-06-20 13:45:54', 4),
(2, 8, 1, 15, 20, 9, 0, 0, '2009-06-20 13:57:23', 2),
(15, 8, 1, 15, 20, 4, 0, 0, '2009-06-20 13:59:58', 2),
(7, 8, 2, 15, 14, 20, 15, 0, '2009-06-20 15:57:12', 6),
(3, 8, 2, 15, 14, 21, 21, 0, '2009-06-20 17:17:26', 7),
(1, 8, 2, 15, 14, 21, 15, 0, '2009-06-20 18:29:17', 8),
(9, 8, 2, 14, 20, 15, 20, -1, '2009-06-20 20:19:03', 2),
(11, 8, 2, 15, 14, 20, 15, 0, '2009-06-20 23:17:35', 6),
(10, 8, 2, 15, 14, 20, 14, -1, '2009-06-21 10:48:05', 4),
(4, 8, 2, 15, 14, 21, 15, 1, '2009-06-21 10:54:09', 6),
(12, 8, 2, 15, 21, 20, 20, -1, '2009-06-21 10:58:54', 3),
(13, 8, 2, 15, 14, 20, 15, -1, '2009-06-21 11:14:25', 5),
(15, 8, 2, 15, 14, 9, 20, 1, '2009-06-21 12:47:25', 3),
(8, 8, 2, 14, 15, 9, 14, 1, '2009-06-21 12:59:53', 1),
(2, 8, 2, 15, 14, 21, 15, 0, '2009-06-21 13:38:31', 8),
(16, 9, 1, 20, 15, 21, 0, 0, '2009-06-22 12:11:54', 2),
(7, 9, 1, 15, 14, 20, 0, 0, '2009-07-10 17:10:17', 3),
(8, 9, 1, 15, 20, 14, 0, 0, '2009-07-11 09:45:27', 2),
(9, 9, 1, 15, 14, 20, 0, 0, '2009-07-11 09:46:25', 3),
(12, 9, 1, 15, 3, 14, 0, 0, '2009-07-11 12:14:10', 1),
(10, 9, 1, 15, 14, 3, 0, 0, '2009-07-11 12:17:26', 1),
(3, 9, 1, 15, 20, 14, 0, 0, '2009-07-11 12:20:39', 2),
(13, 9, 1, 15, 14, 20, 0, 0, '2009-07-11 11:49:21', 3),
(1, 9, 1, 15, 20, 14, 0, 0, '2009-07-11 12:56:26', 2),
(11, 9, 1, 20, 15, 1, 0, 0, '2009-07-11 12:57:32', 1),
(3, 9, 2, 14, 20, 15, 15, -1, '2009-07-11 17:14:32', 3),
(9, 9, 2, 20, 21, 15, 20, 0, '2009-07-11 20:26:08', 2),
(7, 9, 2, 14, 20, 15, 14, 1, '2009-07-11 22:10:59', 2),
(1, 9, 2, 14, 20, 15, 14, 1, '2009-07-11 22:58:49', 2),
(8, 9, 2, 14, 15, 20, 1, -1, '2009-07-12 08:37:05', 4),
(13, 9, 2, 14, 15, 20, 15, -1, '2009-07-12 09:14:50', 4),
(4, 9, 2, 20, 21, 14, 20, 1, '2009-07-12 11:24:31', 0),
(10, 9, 2, 14, 15, 20, 14, -1, '2009-07-12 12:23:17', 4),
(12, 9, 2, 14, 15, 20, 14, -1, '2009-07-12 12:24:16', 4),
(11, 9, 2, 15, 14, 20, 14, 0, '2009-07-12 13:26:03', 3),
(2, 9, 2, 14, 15, 21, 15, 0, '2009-07-12 13:50:19', 5),
(16, 10, 1, 14, 15, 21, 0, 0, '2009-07-13 11:22:16', 3),
(16, 10, 2, 15, 20, 9, 20, 0, '2009-07-13 11:23:20', 1),
(7, 10, 1, 14, 20, 2, 0, 0, '2009-07-24 18:07:27', 1),
(13, 10, 1, 20, 16, 15, 0, 0, '2009-07-24 19:10:50', 1),
(3, 10, 1, 20, 15, 14, 0, 0, '2009-07-25 09:29:30', 4),
(10, 10, 1, 14, 15, 21, 0, 0, '2009-07-25 10:45:00', 3),
(12, 10, 1, 14, 3, 15, 0, 0, '2009-07-25 10:45:49', 2),
(8, 10, 1, 1, 2, 16, 0, 0, '2009-07-25 12:15:04', 0),
(9, 10, 1, 14, 1, 9, 0, 0, '2009-07-25 12:16:02', 1),
(1, 10, 1, 14, 15, 1, 0, 0, '2009-07-25 12:24:04', 3),
(11, 10, 1, 1, 16, 20, 0, 0, '2009-07-25 13:28:50', 0),
(2, 10, 1, 1, 14, 15, 0, 0, '2009-07-25 13:52:00', 2),
(3, 10, 2, 15, 14, 7, 20, 0, '2009-07-25 16:22:49', 2),
(9, 10, 2, 14, 15, 1, 1, -1, '2009-07-25 17:39:23', 2),
(7, 10, 2, 15, 14, 1, 15, 0, '2009-07-25 17:41:14', 3),
(1, 10, 2, 15, 14, 1, 15, 0, '2009-07-26 07:52:08', 3),
(13, 10, 2, 15, 14, 7, 0, -1, '2009-07-26 10:51:49', 1),
(10, 10, 2, 15, 14, 20, 14, -1, '2009-07-26 12:43:49', 2),
(12, 10, 2, 15, 14, 1, 7, -1, '2009-07-26 12:46:04', 2),
(4, 10, 2, 7, 15, 14, 15, 1, '2009-07-26 13:05:49', 1),
(8, 10, 2, 14, 15, 16, 7, 0, '2009-07-26 13:35:24', 2),
(11, 10, 2, 15, 14, 1, 7, 1, '2009-07-26 13:44:42', 1),
(2, 10, 2, 15, 14, 7, 15, 0, '2009-07-26 13:53:21', 2),
(16, 11, 2, 14, 4, 34, 21, 1, '2009-07-30 10:36:51', 0),
(16, 11, 1, 20, 14, 15, 0, 0, '2009-07-30 10:37:03', 0),
(14, 11, 1, 14, 20, 15, 0, 0, '2009-08-21 15:36:32', 0),
(14, 11, 2, 15, 14, 21, 15, 0, '2009-08-21 15:37:31', 2),
(7, 11, 1, 15, 14, 20, 0, 0, '2009-08-21 15:40:59', 0),
(9, 11, 1, 21, 20, 7, 0, 0, '2009-08-22 08:29:45', 1),
(13, 11, 1, 7, 20, 15, 0, 0, '2009-08-22 10:04:49', 0),
(3, 11, 1, 7, 1, 20, 0, 0, '2009-08-22 12:52:10', 1),
(8, 11, 1, 17, 5, 2, 0, 0, '2009-08-22 13:02:56', 1),
(1, 11, 1, 1, 14, 20, 0, 0, '2009-08-22 13:34:57', 2),
(11, 11, 1, 20, 21, 1, 0, 0, '2009-08-22 13:43:52', 2),
(2, 11, 1, 7, 20, 1, 0, 0, '2009-08-22 13:57:13', 1),
(3, 11, 2, 1, 2, 20, 14, -1, '2009-08-22 15:57:36', 1),
(7, 11, 2, 1, 2, 15, 1, 0, '2009-08-22 20:20:26', 2),
(9, 11, 2, 1, 20, 2, 1, -1, '2009-08-22 20:44:45', 1),
(13, 11, 2, 1, 2, 15, 1, 1, '2009-08-22 20:47:39', 0),
(1, 11, 2, 1, 21, 4, 1, 0, '2009-08-23 12:07:20', 5),
(8, 11, 2, 1, 21, 20, 2, 0, '2009-08-23 12:24:44', 3),
(11, 11, 2, 1, 15, 21, 1, -1, '2009-08-23 12:29:07', 2),
(4, 11, 2, 1, 21, 15, 21, 0, '2009-08-23 12:35:18', 3),
(12, 11, 2, 1, 21, 20, 1, -1, '2009-08-23 13:50:43', 2),
(10, 11, 2, 21, 1, 4, 16, -1, '2009-08-23 13:53:29', 6),
(2, 11, 2, 1, 21, 20, 21, 1, '2009-08-23 13:58:31', 1),
(16, 12, 1, 21, 1, 14, 0, 0, '2009-08-24 11:09:04', 0),
(16, 12, 2, 1, 21, 20, 21, 1, '2009-08-24 11:09:44', 1),
(14, 12, 2, 15, 21, 4, 15, 0, '2009-08-26 15:17:46', 2),
(14, 12, 1, 21, 15, 14, 0, 0, '2009-08-26 15:18:16', 0),
(13, 12, 1, 4, 15, 1, 0, 0, '2009-08-28 21:11:46', 0),
(3, 12, 1, 15, 14, 1, 0, 0, '2009-08-29 09:36:50', 0),
(9, 12, 1, 9, 1, 10, 0, 0, '2009-08-29 12:24:53', 1),
(2, 12, 1, 15, 1, 14, 0, 0, '2009-08-29 12:35:20', 0),
(8, 12, 1, 1, 20, 4, 0, 0, '2009-08-29 12:38:13', 0),
(1, 12, 1, 1, 20, 4, 0, 0, '2009-08-29 13:01:34', 0),
(11, 12, 1, 1, 20, 15, 0, 0, '2009-08-29 13:04:57', 0),
(10, 12, 1, 15, 4, 1, 0, 0, '2009-08-29 13:49:37', 0),
(12, 12, 1, 15, 4, 1, 0, 0, '2009-08-29 13:50:15', 0),
(3, 12, 2, 21, 4, 9, 14, -1, '2009-08-29 18:37:13', 1),
(7, 12, 2, 21, 6, 4, 21, -1, '2009-08-29 21:19:06', 1),
(1, 12, 2, 6, 9, 4, 10, 0, '2009-08-30 07:05:45', 0),
(13, 12, 2, 9, 6, 4, 15, -1, '2009-08-30 10:41:04', 2),
(9, 12, 2, 9, 21, 4, 4, -1, '2009-08-30 10:48:57', 1),
(8, 12, 2, 9, 5, 21, 19, 0, '2009-08-30 12:19:14', -1),
(11, 12, 2, 6, 5, 4, 4, 0, '2009-08-30 13:31:20', 0),
(12, 12, 2, 21, 4, 9, 4, -1, '2009-08-30 13:32:06', 1),
(10, 12, 2, 4, 1, 15, 21, -1, '2009-08-30 13:34:22', 4),
(2, 12, 2, 4, 9, 6, 19, 0, '2009-08-30 13:49:04', 1),
(16, 13, 1, 4, 14, 15, 0, 0, '2009-08-31 11:11:42', 1),
(16, 13, 2, 4, 15, 14, 15, 1, '2009-08-31 11:12:14', 2),
(3, 13, 1, 1, 15, 4, 0, 0, '2009-09-12 09:56:30', 4),
(9, 13, 1, 1, 15, 10, 0, 0, '2009-09-12 10:57:25', 2),
(7, 13, 1, 1, 2, 18, 0, 0, '2009-09-12 11:26:13', 3),
(14, 13, 1, 21, 19, 1, 0, 0, '2009-09-12 12:24:56', 1),
(14, 13, 2, 4, 15, 21, 15, 0, '2009-09-12 12:25:33', 1),
(13, 13, 1, 4, 7, 1, 0, 0, '2009-09-12 12:31:19', 2),
(8, 13, 1, 6, 20, 1, 0, 0, '2009-09-12 12:40:20', 1),
(11, 13, 1, 1, 20, 21, 0, 0, '2009-09-12 13:19:58', 2),
(1, 13, 1, 1, 18, 20, 0, 0, '2009-09-12 13:33:53', 4),
(2, 13, 1, 18, 20, 1, 0, 0, '2009-09-12 13:57:50', 2),
(7, 13, 2, 1, 4, 18, 1, -1, '2009-09-12 16:10:03', 1),
(13, 13, 2, 1, 4, 2, 4, -1, '2009-09-12 20:24:34', 1),
(11, 13, 2, 1, 4, 2, 4, -1, '2009-09-12 22:28:30', 1),
(1, 13, 2, 1, 4, 2, 4, 1, '2009-09-13 08:50:48', 2),
(9, 13, 2, 1, 2, 21, 18, -1, '2009-09-13 09:33:22', 2),
(3, 13, 2, 1, 4, 20, 21, 0, '2009-09-13 10:37:31', 1),
(4, 13, 2, 1, 4, 21, 4, 1, '2009-09-13 13:09:08', 3),
(8, 13, 2, 1, 4, 20, 1, 1, '2009-09-13 13:53:51', 3),
(13, 14, 1, 1, 15, 20, 0, 0, '2009-09-26 10:07:27', 4),
(4, 14, 1, 15, 7, 6, 0, 0, '2009-09-26 10:40:43', 1),
(9, 14, 1, 15, 20, 2, 0, 0, '2009-09-26 12:24:46', 1),
(1, 14, 1, 15, 1, 21, 0, 0, '2009-09-26 14:20:41', 2),
(11, 14, 1, 1, 15, 5, 0, 0, '2009-09-26 14:22:12', 4),
(8, 14, 1, 1, 15, 2, 0, 0, '2009-09-26 14:28:24', 4),
(3, 14, 1, 1, 15, 2, 0, 0, '2009-09-26 14:44:06', 4),
(10, 14, 1, 1, 15, 21, 0, 0, '2009-09-26 15:35:39', 4),
(12, 14, 1, 1, 15, 21, 0, 0, '2009-09-26 15:55:52', 4),
(7, 14, 2, 1, 15, 14, 1, 1, '2009-09-26 17:41:47', 3),
(3, 14, 2, 1, 15, 14, 14, 1, '2009-09-26 18:50:16', 3),
(9, 14, 2, 1, 15, 14, 16, 1, '2009-09-26 20:07:49', 3),
(4, 14, 2, 1, 16, 15, 1, 1, '2009-09-27 08:21:37', 3),
(1, 14, 2, 1, 14, 15, 7, 1, '2009-09-27 08:38:18', 4),
(13, 14, 2, 1, 15, 16, 15, -1, '2009-09-27 08:42:22', 2),
(11, 14, 2, 1, 15, 14, 1, -1, '2009-09-27 11:35:23', 2),
(8, 14, 2, 1, 15, 21, 1, 1, '2009-09-27 13:37:40', 3),
(10, 14, 2, 1, 16, 4, 16, -1, '2009-09-27 13:51:56', 2),
(12, 14, 2, 1, 15, 16, 16, 1, '2009-09-27 13:54:04', 3),
(16, 15, 1, 20, 15, 7, 0, 0, '2009-10-02 14:14:17', 1),
(16, 15, 2, 14, 1, 6, 14, 0, '2009-10-02 14:15:19', 1),
(13, 15, 1, 1, 15, 16, 0, 0, '2009-10-02 14:41:49', 2),
(14, 15, 2, 20, 1, 15, 20, 0, '2009-10-02 16:30:25', 1),
(14, 15, 1, 20, 15, 4, 0, 0, '2009-10-02 16:30:51', 1),
(9, 15, 1, 15, 1, 18, 0, 0, '2009-10-02 20:29:48', 3),
(11, 15, 1, 1, 21, 15, 0, 0, '2009-10-02 21:18:19', 2),
(3, 15, 1, 1, 14, 15, 0, 0, '2009-10-02 22:02:35', 2),
(12, 15, 1, 15, 21, 9, 0, 0, '2009-10-03 06:18:41', 3),
(10, 15, 1, 15, 21, 9, 0, 0, '2009-10-03 06:19:24', 3),
(1, 15, 1, 15, 4, 16, 0, 0, '2009-10-03 06:38:09', 2),
(8, 15, 1, 15, 1, 12, 0, 0, '2009-10-03 06:59:08', 3),
(3, 15, 2, 15, 1, 9, 20, -1, '2009-10-03 11:14:16', 4),
(7, 15, 2, 15, 1, 18, 15, -1, '2009-10-03 11:45:05', 3),
(11, 15, 2, 15, 1, 21, 15, 1, '2009-10-03 19:10:26', 4),
(9, 15, 2, 15, 1, 4, 18, 1, '2009-10-03 19:13:12', 4),
(1, 15, 2, 15, 1, 4, 15, 1, '2009-10-03 19:25:11', 4),
(13, 15, 2, 15, 1, 4, 15, 1, '2009-10-03 19:52:28', 4),
(8, 15, 2, 9, 15, 21, 9, 1, '2009-10-03 21:25:08', 3),
(12, 15, 2, 15, 1, 4, 15, -1, '2009-10-04 06:46:34', 3),
(10, 15, 2, 15, 1, 4, 15, -1, '2009-10-04 06:48:09', 3),
(16, 16, 1, 15, 1, 14, 0, 0, '2009-10-05 09:32:49', 1),
(16, 16, 2, 15, 1, 20, 15, 0, '2009-10-05 09:33:20', 0),
(11, 16, 1, 1, 21, 15, 0, 0, '2009-10-16 16:30:14', 1),
(13, 16, 1, 14, 15, 1, 0, 0, '2009-10-16 20:55:52', 1),
(7, 16, 1, 21, 15, 1, 0, 0, '2009-10-16 23:08:59', 2),
(7, 16, 2, 21, 14, 9, 15, -1, '2009-10-16 23:09:40', 1),
(9, 16, 1, 21, 14, 15, 0, 0, '2009-10-17 14:56:32', 4),
(3, 16, 1, 15, 1, 14, 0, 0, '2009-10-17 17:54:04', 1),
(4, 16, 1, 14, 15, 21, 0, 0, '2009-10-17 18:41:32', 2),
(10, 16, 1, 15, 21, 16, 0, 0, '2009-10-17 18:44:46', 1),
(12, 16, 1, 15, 21, 16, 0, 0, '2009-10-17 18:45:53', 1),
(1, 16, 1, 15, 16, 18, 0, 0, '2009-10-17 18:48:03', 2),
(4, 16, 2, 21, 14, 4, 14, 1, '2009-10-18 09:11:46', 3),
(3, 16, 2, 21, 14, 4, 15, 1, '2009-10-18 10:37:41', 2),
(13, 16, 2, 21, 14, 18, 15, -1, '2009-10-18 16:21:06', 1),
(10, 16, 2, 14, 21, 4, 14, -1, '2009-10-18 16:35:25', 3),
(12, 16, 2, 21, 14, 4, 14, -1, '2009-10-18 16:40:01', 2),
(9, 16, 2, 21, 14, 5, 15, 1, '2009-10-18 16:50:35', 3),
(8, 16, 2, 21, 14, 12, 21, 1, '2009-10-18 16:52:09', 2),
(1, 16, 2, 21, 4, 9, 14, 1, '2009-10-18 17:02:01', 2),
(7, 17, 1, 34, 3, 20, 0, 0, '2009-10-30 12:13:05', 0),
(7, 17, 2, 34, 20, 3, 34, -1, '2009-10-30 12:14:28', 1),
(13, 17, 1, 14, 2, 16, 0, 0, '2009-10-30 19:40:06', 1),
(9, 17, 1, 1, 21, 2, 0, 0, '2009-10-31 08:32:47', 2),
(8, 17, 1, 21, 18, 14, 0, 0, '2009-10-31 08:33:24', 2),
(11, 17, 1, 1, 20, 15, 0, 0, '2009-10-31 11:56:23', 3),
(3, 17, 1, 1, 20, 2, 0, 0, '2009-10-31 12:47:54', 2),
(1, 17, 1, 1, 20, 15, 0, 0, '2009-10-31 13:18:42', 3),
(10, 17, 1, 1, 20, 21, 0, 0, '2009-10-31 13:54:16', 2),
(12, 17, 1, 1, 20, 21, 0, 0, '2009-10-31 13:55:08', 2),
(3, 17, 2, 1, 14, 21, 1, 0, '2009-10-31 18:54:27', 3),
(9, 17, 2, 1, 21, 14, 1, -1, '2009-10-31 19:32:04', 1),
(11, 17, 2, 1, 15, 14, 14, -1, '2009-10-31 22:40:07', 2),
(1, 17, 2, 1, 15, 14, 14, -1, '2009-11-01 08:17:21', 2),
(13, 17, 2, 1, 15, 14, 1, 0, '2009-11-01 08:32:02', 3),
(8, 17, 2, 1, 14, 21, 1, -1, '2009-11-01 11:55:30', 2),
(10, 17, 2, 15, 1, 14, 14, -1, '2009-11-01 13:47:08', 3),
(12, 17, 2, 15, 1, 14, 14, -1, '2009-11-01 13:48:11', 3),
(4, 17, 2, 1, 14, 15, 1, 1, '2009-11-01 13:54:32', 2);

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

-- 
-- Tabellenstruktur für Tabelle `users`
-- 

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `u_id` int(11) NOT NULL auto_increment,
  `u_name` char(3) NOT NULL default '',
  `u_passcode` varchar(41) character set utf8 collate utf8_bin NOT NULL default '',
  `u_pic` varchar(20) NOT NULL default '',
  `u_realname` varchar(40) NOT NULL default '',
  `u_nickname` varchar(20) NOT NULL default 'not revealed',
  `u_email` varchar(50) NOT NULL default '',
  `u_emailreminder` int(1) NOT NULL default '0',
  `u_nationality` varchar(20) NOT NULL default 'not revealed',
  `u_favdriver` int(11) NOT NULL default '0',
  `u_since` year(4) NOT NULL default '0000',
  `u_gtwins` int(3) NOT NULL default '0',
  PRIMARY KEY  (`u_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

-- 
-- Daten für Tabelle `users`
-- 

INSERT INTO `users` (`u_id`, `u_name`, `u_passcode`, `u_pic`, `u_realname`, `u_nickname`, `u_email`, `u_emailreminder`, `u_nationality`, `u_favdriver`, `u_since`, `u_gtwins`) VALUES (1, 'MAM', 0x3561393336316232386565353137393566316538326439303534393139303334, 'pic_MAM.gif', 'Markus A. Mascelli', 'MAM', 'mam@heimam.at', 0, 'italian', 4, 2006, 1),
(2, 'GUE', 0x3738393138636563663839323664306361646134633562633331616638376133, 'pic_GUE.gif', 'Guenther Schmidt', 'GueStar', 'guenther.schmidt@gmail.com', 0, 'austrian', 0, 2006, 2),
(3, 'ZEI', 0x3864616437636162636539633531316264343938336538646339366561356461, 'pic_ZEI.gif', 'Christian Zeichmann', 'Zeichi', 'christian.zeichmann@inode.at', 0, 'austrian', 0, 2007, 0),
(4, 'AFG', 0x3833333834343331333930613134383839633939353539333862623536303466, 'pic_AFG.gif', 'Andrea F. Grohmann', '', 'andrea.grohmann@chello.at', 0, 'austrian', 0, 2007, 0),
(6, 'JIR', 0x3835323263326363666436666335643234326564313664313638343031666164, 'avatar.jpg', 'Juergen Iser', '', 'j.iser@gmx.at', 0, 'austrian', 4, 2008, 0),
(7, 'KAI', 0x6535663464393761343936316465613131383462626265383437623539316633, 'avatar.jpg', 'Roman Kailbach', 'Kailo', 'kailo@gmx.at', 0, 'austrian', 1, 2008, 0),
(8, 'WOB', 0x3737366164306566323761636330363032633333376463323733366633613937, 'avatar.jpg', 'Wolfgang Boehm', 'WoB', 'wboehm@gmail.com', 0, 'austrian', 0, 2008, 0),
(9, 'REG', 0x3737366164306566323761636330363032633333376463323733366633613937, 'avatar.jpg', 'Regina Boehm', '', 'wboehm@gmail.com', 0, 'austrian', 0, 2008, 0),
(10, 'ISA', 0x3363346462393536316161326238353330643563363030313464626662653836, 'pic_ISA.jpg', 'Ildiko K. Samu', 'sam', 'ildiko.samu@aon.at', 0, 'hungarian', 4, 2008, 0),
(11, 'MRO', 0x6364613066643239313864313965323061633837316564373961386432626230, 'pic_MRO.jpg', 'Martha Rossa', 'RoMa', 'rossama@yahoo.com', 0, 'austrian', 1, 2008, 1),
(12, 'MPU', 0x3438643534663433633330613237313337656462333833646532363035613836, 'avatar.jpg', 'Michael Puehringer', '', 'michael.puehringer@atosorigin.com', 0, 'austrian', 8, 2008, 0),
(13, 'RHA', 0x3963656438326330353135646636396434653333313166363364343066666130, 'avatar.jpg', 'Robert Haller', '', 'robert.haller@kabsi.at', 0, 'austrian', 0, 2008, 0),
(14, 'FAN', 0x3333633265323064333162336165386634353634643735313737333865623764, 'extremeevil.gif', 'Georg Juren', 'Schurl', 'georg.juren@atosorigin.com', 0, 'austrian', 21, 2009, 0),
(15, 'MBR', 0x3037623961363565396130613838636634656265643536373266323039323737, 'avatar.jpg', 'Markus Brenner', '', 'm.brenn@gmx.net', 0, 'austrian', 0, 2009, 0),
(16, 'RSC', 0x6639633137313137623562386462663863666138336438303537656531613062, 'schicht_roman.jpg', 'Roman Schicht', '', 'rschicht@yahoo.com', 0, 'austrian', 0, 2009, 0);