-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-2ubuntu1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 28, 2007 at 01:14 AM
-- Server version: 5.0.38
-- PHP Version: 5.2.1
-- 
-- Database: `tmtimetrial`
-- 

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

-- 
-- Table structure for table `best_time`
-- 

CREATE TABLE `best_time` (
  `id` bigint(32) unsigned NOT NULL auto_increment,
  `user_id` bigint(32) unsigned NOT NULL,
  `time` bigint(32) unsigned NOT NULL,
  `recordsetat` bigint(32) unsigned NOT NULL,
  `trackuid` varchar(64) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `best_time`
-- 

INSERT INTO `best_time` (`id`, `user_id`, `time`, `recordsetat`, `trackuid`) VALUES 
(1, 1, 2434, 1190287899, 'gIiYgpX0t4xB7QN64CFdXJ1EQv1'),
(2, 1, 2658, 1190288607, 'jtjdphT6ZrVy2E0NrKyIl8T2w5l'),
(3, 1, 3813, 1190290035, 's22NucI_vtYcvEMxHIFIUt1gGuf'),
(4, 2, 4548, 1190302500, 'kdK8bcetWwy2z9UnmX22sIfS3Uh'),
(5, 2, 2554, 1192708011, 'jtjdphT6ZrVy2E0NrKyIl8T2w5l');

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

-- 
-- Table structure for table `tracks`
-- 

CREATE TABLE `tracks` (
  `uid` varchar(64) collate latin1_general_ci NOT NULL,
  `name` varchar(64) collate latin1_general_ci NOT NULL,
  `author` varchar(64) collate latin1_general_ci NOT NULL,
  `filename` varchar(256) collate latin1_general_ci NOT NULL,
  UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- 
-- Dumping data for table `tracks`
-- 

INSERT INTO `tracks` (`uid`, `name`, `author`, `filename`) VALUES 
('jtjdphT6ZrVy2E0NrKyIl8T2w5l', 'E-1', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/E-1.Challenge.Gbx'),
('jdAlTbVu1Gdm_XWnC3dDxJYXJN3', 'E-4', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/E-4.Challenge.Gbx'),
('Fjd5ROyYShfhLHx76vZCNz3KWR', 'E-0', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/E-0.Challenge.Gbx'),
('0dRD3yA8yo2KI263y0RpPtkeDKk', 'F-3', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/F-3.Challenge.Gbx'),
('UAus_s9YIq5z13zux97VGMKcsP2', 'F-8', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/F-8.Challenge.Gbx'),
('UhAIs3d0276Nt7ATNsoAnDyZq35', 'E-5', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/E-5.Challenge.Gbx'),
('LwOJN0gNSXxyFhgDBAnpVf1Y8f7', 'F-6', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/F-6.Challenge.Gbx'),
('sDY93tadGZyEDZ1au4hGAy1QZZ6', 'E-8', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/E-8.Challenge.Gbx'),
('iauTD9ITr9wqPVmIejIylRSKrT0', 'F-0', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/F-0.Challenge.Gbx'),
('U0ye1jSM6yvioCnlmOujHJ7Q0I8', 'D-1', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/D-1.Challenge.Gbx'),
('fpFUNqIATrsd28p4gYrcA0RnUx', 'E-9', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/E-9.Challenge.Gbx'),
('5TSm78pbUykdDEXj8Hlj2TQrlj6', 'D-7', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/D-7.Challenge.Gbx'),
('uXnb_jnElzbV4CYlbO51Hoolf4a', 'D-2', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/D-2.Challenge.Gbx'),
('gIiYgpX0t4xB7QN64CFdXJ1EQv1', 'D-9', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/D-9.Challenge.Gbx'),
('HkhOzC1KEYxBUhb0srKCipJZ2a6', 'D-3', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/D-3.Challenge.Gbx'),
('n3EVi35B5Q5Mpvw0MdoUEJfAd06', 'D-4', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/D-4.Challenge.Gbx'),
('kdK8bcetWwy2z9UnmX22sIfS3Uh', 'E-2', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/E-2.Challenge.Gbx'),
('Lqzi5acFiwi5w3enkg9VSQulru1', 'F-5', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/F-5.Challenge.Gbx'),
('s22NucI_vtYcvEMxHIFIUt1gGuf', 'D-5', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/D-5.Challenge.Gbx'),
('GRJBG1kh5UyMPM4Nt9mDq2PEne', 'E-6', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/E-6.Challenge.Gbx'),
('52CzzepKqn4EofsP2nYXPG78xN6', 'F-1', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/F-1.Challenge.Gbx'),
('ua1L2We9Q9NKZH9I754AGWqoME6', 'E-7', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/E-7.Challenge.Gbx'),
('alNHKoNkR5DwIFsiM_GbhEfQhVk', 'F-2', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/F-2.Challenge.Gbx'),
('yxUTF2YQd351q4iWVtrrqYV59tk', 'E-3', 'Nadeo', 'Challenges/Nadeo/Nations/Advanced/E-3.Challenge.Gbx');

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

-- 
-- Table structure for table `user_stats`
-- 

CREATE TABLE `user_stats` (
  `id` bigint(32) unsigned NOT NULL auto_increment,
  `nickname` varchar(64) collate latin1_general_ci NOT NULL,
  `playrounds` int(16) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `nickname` (`nickname`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `user_stats`
-- 

INSERT INTO `user_stats` (`id`, `nickname`, `playrounds`) VALUES 
(1, 'Testbox', 20),
(2, 'micolous (laptop)', 3);