topical media & game development

talk show tell print

game-php-score-vu-db.sql / sql



  -- phpMyAdmin SQL Dump
  -- version 2.11.8-rc1
  -- http://www.phpmyadmin.net
  --
  -- Host: localhost
  -- Generation Time: Nov 04, 2008 at 08:01 PM
  -- Server version: 5.0.45
  -- PHP Version: 5.1.6
  
  SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  
  --
  -- Database: `miniGames`
  --
  CREATE DATABASE `miniGames` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  USE `miniGames`;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `highscores`
  --
  
  CREATE TABLE IF NOT EXISTS `highscores` (
    `ID` int(11) NOT NULL auto_increment,
    `game` varchar(20) NOT NULL default '',
    `name` varchar(20) NOT NULL default '',
    `IP` varchar(16) NOT NULL default '',
    `time` int(11) NOT NULL default '0',
    `score` decimal(8,2) NOT NULL default '0.00',
    `debug` varchar(100) NOT NULL default '',
    `level` int(11) NOT NULL default '0',
    PRIMARY KEY  (`ID`),
    KEY `game` (`game`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=540 ;
  
  --


(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.