gistfile1.txt

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 25. August 2011 um 20:37
-- Server Version: 5.5.8
-- PHP-Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datenbank: `market2`
--

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

--
-- Tabellenstruktur für Tabelle `latest`
--

CREATE TABLE IF NOT EXISTS `latest` (
  `ItemID` int(11) NOT NULL,
  `ShopID` int(11) NOT NULL,
  `Buy` int(11) NOT NULL,
  `Sell` int(11) NOT NULL,
  `Count` int(11) NOT NULL,
  PRIMARY KEY (`ItemID`,`ShopID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `latest`
--

INSERT INTO `latest` (`ItemID`, `ShopID`, `Buy`, `Sell`, `Count`) VALUES
(11, 42, 5, 0, 10),
(11, 43, 0, 12, 5);