# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 28, 2004 at 07:29 PM
# Server version: 4.0.16
# PHP Version: 4.3.4
#
# Database : `aqvp07_exoops`
#

# --------------------------------------------------------

#
# Table structure for table `arcade_cats`
#

CREATE TABLE arcade_cats (
  cat_id int(10) unsigned NOT NULL auto_increment,
  cat_name varchar(64) NOT NULL default '',
  is_active tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (cat_id)
) TYPE=MyISAM;

#
# Dumping data for table `arcade_cats`
#

INSERT INTO arcade_cats VALUES (1, 'General', 1);

# --------------------------------------------------------

#
# Table structure for table `arcade_games`
#

CREATE TABLE arcade_games (
  gid int(11) NOT NULL auto_increment,
  gname varchar(40) NOT NULL default '',
  gwords text NOT NULL,
  gcount int(11) NOT NULL default '0',
  gtitle varchar(40) NOT NULL default '',
  bgcolor varchar(6) NOT NULL default '000',
  active tinyint(1) NOT NULL default '1',
  gwidth int(11) NOT NULL default '400',
  gheight int(11) NOT NULL default '400',
  position mediumint(8) NOT NULL default '1',
  cat_id int(10) unsigned NOT NULL default '1',
  object text NOT NULL,
  gkeys text NOT NULL,
  date_added int(10) NOT NULL default '0',
  UNIQUE KEY gid (gid)
) TYPE=MyISAM;

#
# Dumping data for table `arcade_games`
#

INSERT INTO arcade_games VALUES (1, 'asteroids', ' Kill some asteroids and flying saucers&#33; ', 0, 'Asteroids', '000000', 1, 500, 500, 1, 1, 'Shoot all of the asteroids.', 'Arrow keys move the ship.<br>\r\nSpace bar fires.', 0);
INSERT INTO arcade_games VALUES (2, 'invaders', ' Kill the invading army of UFO&#39;s ', 0, 'Space Invaders', '000000', 1, 500, 500, 1, 1, 'To shoot all of the aliens.', 'Left and Right arrow keys to move.<br>\r\nSpace bar to shoot.', 0);
INSERT INTO arcade_games VALUES (3, 'pacman', ' Eat all the little dots without letting the ghosts get you&#33; ', 0, 'Pacman', '000000', 1, 500, 500, 1, 1, 'Eat all of the dots.', 'Arrow keys to move.', 0);
INSERT INTO arcade_games VALUES (4, 'tetris', ' Build solid lines to clear and get points.  Clear 4 rows at the same time and you&#39;ve just Tetris&#39;d&#33; ', 0, 'Tetris', 'FFFFFF', 1, 500, 500, 1, 1, 'Form lines using the different shapes.', 'Up arrow changes the rotation of the piece.<br>\r\nLeft and Right arrows move it.<br>\r\nDown arrow brings it down faster.', 0);
INSERT INTO arcade_games VALUES (5, 'snake', ' Eat the apples and don&#39;t hit the walls.... or yourself. ', 0, 'Snake', '000000', 1, 500, 500, 1, 1, 'Eat all of the apples.', 'Arrow keys to move.', 0);
INSERT INTO arcade_games VALUES (6, 'hexxagon', ' Flip and multiply your pieces to take over the computer. ', 0, 'Hexxagon', '000000', 1, 500, 500, 1, 1, 'Take over as many enemy pieces as possible.', 'Click in quadrants around your piece to move or jump.', 0);
INSERT INTO arcade_games VALUES (7, 'breakout', ' Use a ball and paddle to smash your way through a series of regenerating blocks. ', 0, 'Breakout', '000000', 1,500, 500, 1, 1, 'Break all of the blocks.', 'Left and Right arrows move.<br>\r\n<center>or</center>\r\nMouse moves.', 0);
INSERT INTO arcade_games VALUES (8, 'moonlander', 'Navigate your spaceship onto the different landing pads for points.  Each round the gravity gets more intense.  Each pad is worth 100 points.', 0, 'Moon Lander', '000000', 1, 500, 500, 1, 1, 'Land on as many pads as possible.', 'Up key thrusts upward.<br>\r\nLeft key thrusts rightward.<br>\r\nRight key thrusts leftward.', 0);

# --------------------------------------------------------

#
# Table structure for table `arcade_scores`
#

CREATE TABLE arcade_scores (
  score_id int(10) unsigned NOT NULL auto_increment,
  gid int(10) unsigned NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  score int(10) unsigned NOT NULL default '0',
  score_date int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (score_id)
) TYPE=MyISAM;

#
# Dumping data for table `arcade_scores`
#
