DB structure:
-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5+lenny7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Czas wygenerowania: 24 Lut 2011, 17:49
-- Wersja serwera: 5.0.51
-- Wersja PHP: 5.3.5-0.dotdeb.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Baza danych: `ltwt`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `classes`
--
CREATE TABLE IF NOT EXISTS `classes` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) collate utf8_unicode_ci NOT NULL,
`short` varchar(255) collate utf8_unicode_ci NOT NULL,
`cars` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `drivers`
--
CREATE TABLE IF NOT EXISTS `drivers` (
`id` int(10) unsigned NOT NULL auto_increment,
`team_nr` int(10) unsigned NOT NULL,
`session` int(10) unsigned NOT NULL default '0',
`nick` varchar(255) collate utf8_unicode_ci default NULL,
`uname` varchar(255) collate utf8_unicode_ci NOT NULL,
`car` varchar(255) collate utf8_unicode_ci default NULL,
`plate` varchar(255) collate utf8_unicode_ci default NULL,
`admin` int(10) unsigned NOT NULL default '0',
`add_mass` int(10) unsigned NOT NULL default '0',
`rest_intake` int(10) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`pla` int(10) unsigned NOT NULL default '0',
`country` varchar(3) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=148 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `laps`
--
CREATE TABLE IF NOT EXISTS `laps` (
`id` int(10) unsigned NOT NULL auto_increment,
`session` int(11) NOT NULL default '0',
`server` int(11) NOT NULL default '1',
`driver` int(11) NOT NULL,
`s1` int(11) NOT NULL default '0',
`s2` int(11) NOT NULL default '0',
`s3` int(11) NOT NULL default '0',
`s4` int(11) NOT NULL default '0',
`ltime` int(11) NOT NULL,
`ttime` int(11) NOT NULL,
`lap` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1679 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `packets`
--
CREATE TABLE IF NOT EXISTS `packets` (
`id` int(10) unsigned NOT NULL auto_increment,
`server` int(11) NOT NULL default '1',
`time` int(10) unsigned NOT NULL,
`data` mediumtext collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6844 ;
-- --------------------------------------------------------
--
-- Struktura tabeli dla `teams`
--
CREATE TABLE IF NOT EXISTS `teams` (
`id` int(10) unsigned NOT NULL auto_increment,
`session` int(11) NOT NULL default '0',
`team_nr` int(11) NOT NULL,
`start_pos` int(11) NOT NULL default '0',
`pos` int(11) NOT NULL default '0',
`name` varchar(255) collate utf8_unicode_ci NOT NULL,
`car` varchar(255) collate utf8_unicode_ci NOT NULL,
`changes` int(11) NOT NULL default '0',
`penalty` int(11) NOT NULL default '0',
`dsq` int(11) NOT NULL default '0',
`s1` int(11) NOT NULL default '0',
`s2` int(11) NOT NULL default '0',
`s3` int(11) NOT NULL default '0',
`s4` int(11) NOT NULL default '0',
`last_time` int(11) NOT NULL default '0',
`laps_done` int(11) NOT NULL default '0',
`ttime` int(11) NOT NULL default '0',
`online_driver` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=43 ;
+ its the best tracker I have seen to date. Although Misiek's works well but is not as developed as Mike's beast