[HaBo]

-- MySQL dump 9.11
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version       4.0.20

--
-- Table structure for table `liga`
--

CREATE TABLE liga (
  id int(11) NOT NULL auto_increment,
  liganame varchar(50) NOT NULL default '',
  firstgame timestamp(14) NOT NULL,
  lastgame timestamp(14) NOT NULL default '00000000000000',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `liga`
--

INSERT INTO liga VALUES (1,'meine liga',20050304184312,20060309000000);

--
-- Table structure for table `mark`
--

CREATE TABLE mark (
  markid int(11) NOT NULL auto_increment,
  name varchar(100) NOT NULL default '',
  imageurl varchar(255) NOT NULL default '',
  PRIMARY KEY  (markid)
) TYPE=MyISAM;

--
-- Dumping data for table `mark`
--

INSERT INTO mark VALUES (1,'sauber-petronas','http://www.wasbinich.com');

--
-- Table structure for table `player_account`
--

CREATE TABLE player_account (
  playerid int(11) NOT NULL auto_increment,
  ligaid int(11) NOT NULL default '0',
  username char(50) NOT NULL default '',
  passwd char(32) NOT NULL default '',
  PRIMARY KEY  (playerid)
) TYPE=MyISAM;

--
-- Dumping data for table `player_account`
--

INSERT INTO player_account VALUES (1,1,'testuser','e22a63fb76874c99488435f26b117e37');

--
-- Table structure for table `rennen`
--

CREATE TABLE rennen (
  rennenid int(11) NOT NULL auto_increment,
  ligaid int(11) NOT NULL default '0',
  datum timestamp(14) NOT NULL,
  rennenname varchar(100) NOT NULL default '',
  PRIMARY KEY  (rennenid)
) TYPE=MyISAM;

--
-- Dumping data for table `rennen`
--

INSERT INTO rennen VALUES (1,1,20050304184847,'grosser preis von honolulu');
INSERT INTO rennen VALUES (2,1,20050304184847,'grosser preis des habos');

--
-- Table structure for table `result`
--

CREATE TABLE result (
  userid int(11) NOT NULL default '0',
  rennenid int(11) default NULL,
  punkte int(11) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `result`
--

INSERT INTO result VALUES (1,1,30);
INSERT INTO result VALUES (1,2,20);

--
-- Table structure for table `vehicle`
--

CREATE TABLE vehicle (
  vehicleid int(11) NOT NULL auto_increment,
  vehiclename varchar(100) NOT NULL default '',
  imageurl varchar(255) NOT NULL default '',
  markid int(11) NOT NULL default '0',
  PRIMARY KEY  (vehicleid)
) TYPE=MyISAM;

--
-- Dumping data for table `vehicle`
--

INSERT INTO vehicle VALUES (1,'mein f1 mobil','http://...',1);

mysql> select user.username, res.punkte from player_account as user LEFT JOIN result AS res ON (res.userid = user.userid);
+----------+--------+
| username | punkte |
+----------+--------+
| testuser |     30 |
| testuser |     20 |
+----------+--------+
2 rows in set (0.00 sec)

mysql> 
mysql> select sum(punkte),  user.username, res.punkte from player_account as user LEFT JOIN result AS res ON (res.userid = user.userid) GROUP BY username;
+-------------+----------+--------+
| sum(punkte) | username | punkte |
+-------------+----------+--------+
|          50 | testuser |     30 |
+-------------+----------+--------+
1 row in set (0.00 sec)

mysql>