 
 DROP TABLE IF EXISTS `score`;
 CREATE TABLE IF NOT EXISTS `score` (
-  `Score_ID` int(11) NOT NULL,
+`Score_ID` int(11) NOT NULL,
   `Game_ID` int(11) NOT NULL,
   `Google_ID` int(11) NOT NULL,
   `Totaal` int(11) NOT NULL,
   `Strikes` int(11) NOT NULL,
   `Spare` int(11) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
 
 --
 -- Gegevens worden geëxporteerd voor tabel `score`
 --
 
 INSERT INTO `score` (`Score_ID`, `Game_ID`, `Google_ID`, `Totaal`, `Strikes`, `Spare`) VALUES
-(0, 2, 2, 300, 12, 12),
+(1, 2, 2, 300, 12, 12),
 (2, 2, 2, 300, 12, 12);
 
 -- --------------------------------------------------------

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

--
-- Tabelstructuur voor tabel `deelnemersTournooi`
--

DROP TABLE IF EXISTS `deelnemersTournooi`;
CREATE TABLE IF NOT EXISTS `deelnemersTournooi` (
  `googleID` int(11) NOT NULL,
  `tournooiID` int(11) NOT NULL,
  `accepted` tinyint(1) NOT NULL

/*!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 */;

--
-- Databank: `bowling`
--
CREATE DATABASE IF NOT EXISTS `bowling` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `bowling`;
