LennyRace schema

-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- http://www.phpmyadmin.net
--
-- Värd: localhost
-- Skapad: 16 juni 2011 kl 13:29
-- Serverversion: 5.0.77
-- PHP-version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Databas: `training`
--

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

--
-- Struktur för tabell `races`
--

CREATE TABLE IF NOT EXISTS `races` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `vehicles` varchar(40) NOT NULL,
  `creator` varchar(24) NOT NULL,
  `fastest` varchar(24) NOT NULL default 'Noone',
  `record` int(11) NOT NULL default '36000',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

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

--
-- Struktur för tabell `race_checkpoints`
--

CREATE TABLE IF NOT EXISTS `race_checkpoints` (
  `id` int(11) NOT NULL auto_increment,
  `raceid` int(11) NOT NULL,
  `x` float NOT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `type` int(11) NOT NULL default '0',
  `size` float NOT NULL default '5',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=599 ;

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

--
-- Struktur för tabell `race_times`
--

CREATE TABLE IF NOT EXISTS `race_times` (
  `id` int(11) NOT NULL auto_increment,
  `raceid` int(11) NOT NULL,
  `playerid` int(11) NOT NULL,
  `name` varchar(24) NOT NULL,
  `time` int(11) NOT NULL,
  `vehicle` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;