-- phpMyAdmin SQL Dump
-- version 2.6.2-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 07, 2005 at 07:15 PM
-- Server version: 3.23.58
-- PHP Version: 4.3.11
-- 
-- Database: `mythconverg`
-- 

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

-- 
-- Table structure for table `gamemetadata`
-- 

CREATE TABLE `gamemetadata` (
  `system` varchar(128) NOT NULL default '',
  `romname` varchar(128) NOT NULL default '',
  `gamename` varchar(128) NOT NULL default '',
  `genre` varchar(128) NOT NULL default '',
  `year` int(10) unsigned NOT NULL default '0',
  `favorite` tinyint(1) default NULL,
  KEY `system` (`system`),
  KEY `year` (`year`),
  KEY `romname` (`romname`),
  KEY `gamename` (`gamename`),
  KEY `genre` (`genre`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `gamemetadata`
-- 


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

-- 
-- Table structure for table `gameplayers`
-- 

CREATE TABLE `gameplayers` (
  `gameplayerid` int(10) unsigned NOT NULL auto_increment,
  `playername` varchar(64) NOT NULL default '',
  `workingpath` varchar(255) NOT NULL default '',
  `rompath` varchar(255) NOT NULL default '',
  `screenshots` varchar(255) NOT NULL default '',
  `commandline` varchar(255) NOT NULL default '',
  `gametype` varchar(64) NOT NULL default '',
  `extensions` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`gameplayerid`),
  UNIQUE KEY `playername` (`playername`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `gameplayers`
-- 

INSERT INTO `gameplayers` VALUES (1, 'NES Player', '', '/mnt/video/mythtv/games/nes/roms', '/mnt/video/mythtv/games/nes/screenshots', '/usr/bin/fceu-sdl -opengl 0 -fs 1', 'NES', 'zip,nes');
INSERT INTO `gameplayers` VALUES (2, 'zSNES', '', '/mnt/video/mythtv/games/snes/roms', '/mnt/video/mythtv/games/snes/screenshots', '/usr/local/bin/zsnes', 'SNES', 'zip,smc,sfc,fig,swc');
INSERT INTO `gameplayers` VALUES (3, 'XMame', '', '/mnt/video/mythtv/games/xmame/roms', '/mnt/video/mythtv/games/xmame/screenshots', 'xmame', 'MAME', 'zip');
