-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-3
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Mardi 01 Mai 2007 à 04:54
-- Version du serveur: 5.0.32
-- Version de PHP: 5.2.0-8+etch1
-- 
-- Base de données: `stepmani_newstats`
-- 

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

-- 
-- Structure de la table `banlist`
-- 

CREATE TABLE `banlist` (
  `ban_userid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ban_userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `general_rank`
-- 

CREATE TABLE `general_rank` (
  `pid` int(11) NOT NULL,
  `pts` int(11) NOT NULL,
  PRIMARY KEY  (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `player_stats`
-- 

CREATE TABLE `player_stats` (
  `round_key` int(11) unsigned NOT NULL auto_increment,
  `round_ID` int(11) unsigned NOT NULL default '0',
  `pid` int(11) unsigned NOT NULL default '0',
  `score` int(11) unsigned NOT NULL default '0',
  `grade` int(11) unsigned NOT NULL default '0',
  `difficulty` int(11) unsigned NOT NULL default '0',
  `feet` int(11) unsigned NOT NULL default '0',
  `toasty` int(11) unsigned NOT NULL default '0',
  `marvelous` int(11) unsigned NOT NULL default '0',
  `perfect` int(11) unsigned NOT NULL default '0',
  `great` int(11) unsigned NOT NULL default '0',
  `good` int(11) unsigned NOT NULL default '0',
  `boo` int(11) unsigned NOT NULL default '0',
  `miss` int(11) unsigned NOT NULL default '0',
  `ok` int(11) unsigned NOT NULL default '0',
  `ng` int(11) unsigned NOT NULL default '0',
  `hmine` int(11) unsigned NOT NULL default '0',
  `amine` int(11) unsigned NOT NULL default '0',
  `maxcombo` int(11) unsigned NOT NULL default '0',
  `options` text NOT NULL,
  `timing` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`round_key`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

-- 
-- Structure de la table `player_totals`
-- 

CREATE TABLE `player_totals` (
  `pid` int(10) unsigned NOT NULL default '0',
  `score` int(10) unsigned NOT NULL default '0',
  `rounds` int(10) unsigned NOT NULL default '0',
  `grade` int(10) unsigned NOT NULL default '0',
  `difficulty` int(10) unsigned NOT NULL default '0',
  `feet` int(10) unsigned NOT NULL default '0',
  `toasty` int(10) unsigned NOT NULL default '0',
  `marvelous` int(10) unsigned NOT NULL default '0',
  `perfect` int(10) unsigned NOT NULL default '0',
  `great` int(10) unsigned NOT NULL default '0',
  `good` int(10) unsigned NOT NULL default '0',
  `boo` int(10) unsigned NOT NULL default '0',
  `miss` int(10) unsigned NOT NULL default '0',
  `ok` int(10) unsigned NOT NULL default '0',
  `ng` int(10) unsigned NOT NULL default '0',
  `hmine` int(10) unsigned NOT NULL default '0',
  `amine` int(10) unsigned NOT NULL default '0',
  `maxcombo` int(10) unsigned NOT NULL default '0',
  `seed` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `rounds`
-- 

CREATE TABLE `rounds` (
  `round_ID` int(11) unsigned NOT NULL auto_increment,
  `song_ID` int(11) unsigned NOT NULL default '0',
  `playtime` int(11) unsigned NOT NULL default '0',
  `roomname` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`round_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=2 ;

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

-- 
-- Structure de la table `song_stats`
-- 

CREATE TABLE `song_stats` (
  `song_ID` int(11) unsigned NOT NULL auto_increment,
  `played` int(11) unsigned NOT NULL default '0',
  `title` text NOT NULL,
  `subtitle` text NOT NULL,
  `artist` text NOT NULL,
  PRIMARY KEY  (`song_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

-- 
-- Structure de la table `users`
-- 

CREATE TABLE `users` (
  `user_id` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(15) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_level` tinyint(4) unsigned NOT NULL default '0',
  `date_inscrit` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `email` varchar(250) NOT NULL,
  `description` text NOT NULL,
  `avatar` text NOT NULL,
  `user_active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=2 ;
