Schema-Join-Help

-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Host: 91.192.193.170
-- Generation Time: May 21, 2012 at 09:06 PM
-- Server version: 5.0.51
-- PHP Version: 5.3.0
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
 
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
 
--
-- Database: `db`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `games`
--
 
CREATE TABLE IF NOT EXISTS `games` (
  `id` int(128) NOT NULL auto_increment,
  `title` varchar(150) NOT NULL,
  `developer` varchar(85) NOT NULL,
  `publisher` varchar(85) NOT NULL,
  `released` varchar(4) NOT NULL,
  `description` varchar(4048) NOT NULL,
  `header` varchar(500) NOT NULL,
  `cover` varchar(500) NOT NULL,
  `screenshots` varchar(4048) NOT NULL,
  `thumbnails` varchar(4048) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=848 ;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `products`
--
 
CREATE TABLE IF NOT EXISTS `products` (
  `ref` int(11) NOT NULL auto_increment,
  `game_id` int(11) NOT NULL,
  `notes` varchar(4048) NOT NULL,
  `price` decimal(10,0) NOT NULL,
  `postage` decimal(10,0) NOT NULL,
  `picture` text NOT NULL,
  `sold` varchar(3) NOT NULL default 'No',
  PRIMARY KEY  (`ref`),
  KEY `game_id` (`game_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
 
--
-- Constraints for dumped tables
--
 
--
-- Constraints for table `games`
--
ALTER TABLE `games`
  ADD CONSTRAINT `games_ibfk_1` FOREIGN KEY (`id`) REFERENCES `games` (`id`);
 
--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`game_id`) REFERENCES `games` (`id`);
 
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;