BEGIN TRANSACTION;
CREATE TABLE run(
  run_id      INTEGER PRIMARY KEY AUTOINCREMENT,
  timestamp   INTEGER,
  revision    INTEGER,
  information STRING
);
INSERT INTO "run" VALUES(1,1200464352,1,'');
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('run',1);
INSERT INTO "sqlite_sequence" VALUES('test',4);
INSERT INTO "sqlite_sequence" VALUES('code_file',2);
INSERT INTO "sqlite_sequence" VALUES('code_class',3);
INSERT INTO "sqlite_sequence" VALUES('code_method',8);
INSERT INTO "sqlite_sequence" VALUES('code_line',257);
CREATE TABLE test(
  run_id              INTEGER,
  test_id             INTEGER PRIMARY KEY AUTOINCREMENT,
  test_name           TEXT,
  test_result         INTEGER DEFAULT 0,
  test_message        TEXT    DEFAULT "",
  test_execution_time REAL    DEFAULT 0,
  code_method_id      INTEGER,
  node_root           INTEGER,
  node_left           INTEGER,
  node_right          INTEGER,
  node_is_leaf        INTEGER DEFAULT 0
);
INSERT INTO "test" VALUES(1,1,'BankAccountTest',0,'',0.00549,NULL,1,1,8,0);
INSERT INTO "test" VALUES(1,2,'testBalanceIsInitiallyZero',0,'',0.001817,2,1,2,3,1);
INSERT INTO "test" VALUES(1,3,'testBalanceCannotBecomeNegative',0,'',0.001996,3,1,4,5,1);
INSERT INTO "test" VALUES(1,4,'testBalanceCannotBecomeNegative2',0,'',0.001677,4,1,6,7,1);
CREATE TABLE code_file(
  code_file_id   INTEGER PRIMARY KEY AUTOINCREMENT,
  code_file_name TEXT,
  code_file_md5  TEXT,
  revision       INTEGER
);
INSERT INTO "code_file" VALUES(1,'BankAccountTest.php','c04eaeb760116e7623b7d457aeafc4c6',1);
INSERT INTO "code_file" VALUES(2,'BankAccount.php','02e07f8b5849900c0835a5d0a3e76b4f',1);
CREATE TABLE code_function(
  code_file_id             INTEGER,
  code_function_id         INTEGER PRIMARY KEY AUTOINCREMENT,
  code_function_name       TEXT,
  code_function_start_line INTEGER,
  code_function_end_line   INTEGER
);
CREATE TABLE code_class(
  code_file_id          INTEGER,
  code_class_id         INTEGER PRIMARY KEY AUTOINCREMENT,
  code_class_parent_id  INTEGER,
  code_class_name       TEXT,
  code_class_start_line INTEGER,
  code_class_end_line   INTEGER
);
INSERT INTO "code_class" VALUES(1,1,NULL,'BankAccountTest',62,130);
INSERT INTO "code_class" VALUES(2,2,NULL,'BankAccountException',47,47);
INSERT INTO "code_class" VALUES(2,3,NULL,'BankAccount',61,125);
CREATE TABLE code_method(
  code_class_id          INTEGER,
  code_method_id         INTEGER PRIMARY KEY AUTOINCREMENT,
  code_method_name       TEXT,
  code_method_start_line INTEGER,
  code_method_end_line   INTEGER
);
INSERT INTO "code_method" VALUES(1,1,'setUp',66,69);
INSERT INTO "code_method" VALUES(1,2,'testBalanceIsInitiallyZero',74,77);
INSERT INTO "code_method" VALUES(1,3,'testBalanceCannotBecomeNegative',82,95);
INSERT INTO "code_method" VALUES(1,4,'testBalanceCannotBecomeNegative2',100,113);
INSERT INTO "code_method" VALUES(3,5,'getBalance',77,80);
INSERT INTO "code_method" VALUES(3,6,'setBalance',89,96);
INSERT INTO "code_method" VALUES(3,7,'depositMoney',105,110);
INSERT INTO "code_method" VALUES(3,8,'withdrawMoney',119,124);
CREATE TABLE code_line(
  code_file_id      INTEGER,
  code_line_id      INTEGER PRIMARY KEY AUTOINCREMENT,
  code_line_number  INTEGER,
  code_line         TEXT,
  code_line_covered INTEGER
);
INSERT INTO "code_line" VALUES(1,1,1,'<?php
',0);
INSERT INTO "code_line" VALUES(1,2,2,'/**
',0);
INSERT INTO "code_line" VALUES(1,3,3,' * PHPUnit
',0);
INSERT INTO "code_line" VALUES(1,4,4,' *
',0);
INSERT INTO "code_line" VALUES(1,5,5,' * Copyright (c) 2002-2008, Sebastian Bergmann <sb@sebastian-bergmann.de>.
',0);
INSERT INTO "code_line" VALUES(1,6,6,' * All rights reserved.
',0);
INSERT INTO "code_line" VALUES(1,7,7,' *
',0);
INSERT INTO "code_line" VALUES(1,8,8,' * Redistribution and use in source and binary forms, with or without
',0);
INSERT INTO "code_line" VALUES(1,9,9,' * modification, are permitted provided that the following conditions
',0);
INSERT INTO "code_line" VALUES(1,10,10,' * are met:
',0);
INSERT INTO "code_line" VALUES(1,11,11,' *
',0);
INSERT INTO "code_line" VALUES(1,12,12,' *   * Redistributions of source code must retain the above copyright
',0);
INSERT INTO "code_line" VALUES(1,13,13,' *     notice, this list of conditions and the following disclaimer.
',0);
INSERT INTO "code_line" VALUES(1,14,14,' *
',0);
INSERT INTO "code_line" VALUES(1,15,15,' *   * Redistributions in binary form must reproduce the above copyright
',0);
INSERT INTO "code_line" VALUES(1,16,16,' *     notice, this list of conditions and the following disclaimer in
',0);
INSERT INTO "code_line" VALUES(1,17,17,' *     the documentation and/or other materials provided with the
',0);
INSERT INTO "code_line" VALUES(1,18,18,' *     distribution.
',0);
INSERT INTO "code_line" VALUES(1,19,19,' *
',0);
INSERT INTO "code_line" VALUES(1,20,20,' *   * Neither the name of Sebastian Bergmann nor the names of his
',0);
INSERT INTO "code_line" VALUES(1,21,21,' *     contributors may be used to endorse or promote products derived
',0);
INSERT INTO "code_line" VALUES(1,22,22,' *     from this software without specific prior written permission.
',0);
INSERT INTO "code_line" VALUES(1,23,23,' *
',0);
INSERT INTO "code_line" VALUES(1,24,24,' * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
',0);
INSERT INTO "code_line" VALUES(1,25,25,' * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
',0);
INSERT INTO "code_line" VALUES(1,26,26,' * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
',0);
INSERT INTO "code_line" VALUES(1,27,27,' * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
',0);
INSERT INTO "code_line" VALUES(1,28,28,' * COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
',0);
INSERT INTO "code_line" VALUES(1,29,29,' * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
',0);
INSERT INTO "code_line" VALUES(1,30,30,' * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
',0);
INSERT INTO "code_line" VALUES(1,31,31,' * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
',0);
INSERT INTO "code_line" VALUES(1,32,32,' * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
',0);
INSERT INTO "code_line" VALUES(1,33,33,' * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
',0);
INSERT INTO "code_line" VALUES(1,34,34,' * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
',0);
INSERT INTO "code_line" VALUES(1,35,35,' * POSSIBILITY OF SUCH DAMAGE.
',0);
INSERT INTO "code_line" VALUES(1,36,36,' *
',0);
INSERT INTO "code_line" VALUES(1,37,37,' * @category   Testing
',0);
INSERT INTO "code_line" VALUES(1,38,38,' * @package    PHPUnit
',0);
INSERT INTO "code_line" VALUES(1,39,39,' * @author     Sebastian Bergmann <sb@sebastian-bergmann.de>
',0);
INSERT INTO "code_line" VALUES(1,40,40,' * @copyright  2002-2008 Sebastian Bergmann <sb@sebastian-bergmann.de>
',0);
INSERT INTO "code_line" VALUES(1,41,41,' * @license    http://www.opensource.org/licenses/bsd-license.php  BSD License
',0);
INSERT INTO "code_line" VALUES(1,42,42,' * @version    SVN: $Id: BankAccountTest.php 1984 2007-12-26 18:11:04Z sb $
',0);
INSERT INTO "code_line" VALUES(1,43,43,' * @link       http://www.phpunit.de/
',0);
INSERT INTO "code_line" VALUES(1,44,44,' * @since      File available since Release 2.3.0
',0);
INSERT INTO "code_line" VALUES(1,45,45,' */
',0);
INSERT INTO "code_line" VALUES(1,46,46,'
',0);
INSERT INTO "code_line" VALUES(1,47,47,'require_once ''PHPUnit/Framework/TestCase.php'';
',0);
INSERT INTO "code_line" VALUES(1,48,48,'require_once ''BankAccount.php'';
',0);
INSERT INTO "code_line" VALUES(1,49,49,'
',0);
INSERT INTO "code_line" VALUES(1,50,50,'/**
',0);
INSERT INTO "code_line" VALUES(1,51,51,' * Tests for the BankAccount class.
',0);
INSERT INTO "code_line" VALUES(1,52,52,' *
',0);
INSERT INTO "code_line" VALUES(1,53,53,' * @category   Testing
',0);
INSERT INTO "code_line" VALUES(1,54,54,' * @package    PHPUnit
',0);
INSERT INTO "code_line" VALUES(1,55,55,' * @author     Sebastian Bergmann <sb@sebastian-bergmann.de>
',0);
INSERT INTO "code_line" VALUES(1,56,56,' * @copyright  2002-2008 Sebastian Bergmann <sb@sebastian-bergmann.de>
',0);
INSERT INTO "code_line" VALUES(1,57,57,' * @license    http://www.opensource.org/licenses/bsd-license.php  BSD License
',0);
INSERT INTO "code_line" VALUES(1,58,58,' * @version    Release: @package_version@
',0);
INSERT INTO "code_line" VALUES(1,59,59,' * @link       http://www.phpunit.de/
',0);
INSERT INTO "code_line" VALUES(1,60,60,' * @since      Class available since Release 2.3.0
',0);
INSERT INTO "code_line" VALUES(1,61,61,' */
',0);
INSERT INTO "code_line" VALUES(1,62,62,'class BankAccountTest extends PHPUnit_Framework_TestCase
',0);
INSERT INTO "code_line" VALUES(1,63,63,'{
',0);
INSERT INTO "code_line" VALUES(1,64,64,'    protected $ba;
',0);
INSERT INTO "code_line" VALUES(1,65,65,'
',0);
INSERT INTO "code_line" VALUES(1,66,66,'    protected function setUp()
',0);
INSERT INTO "code_line" VALUES(1,67,67,'    {
',0);
INSERT INTO "code_line" VALUES(1,68,68,'        $this->ba = new BankAccount;
',1);
INSERT INTO "code_line" VALUES(1,69,69,'    }
',1);
INSERT INTO "code_line" VALUES(1,70,70,'
',0);
INSERT INTO "code_line" VALUES(1,71,71,'    /**
',0);
INSERT INTO "code_line" VALUES(1,72,72,'     * @covers BankAccount::getBalance
',0);
INSERT INTO "code_line" VALUES(1,73,73,'     */
',0);
INSERT INTO "code_line" VALUES(1,74,74,'    public function testBalanceIsInitiallyZero()
',0);
INSERT INTO "code_line" VALUES(1,75,75,'    {
',0);
INSERT INTO "code_line" VALUES(1,76,76,'        $this->assertEquals(0, $this->ba->getBalance());
',1);
INSERT INTO "code_line" VALUES(1,77,77,'    }
',1);
INSERT INTO "code_line" VALUES(1,78,78,'
',0);
INSERT INTO "code_line" VALUES(1,79,79,'    /**
',0);
INSERT INTO "code_line" VALUES(1,80,80,'     * @covers BankAccount::withdrawMoney
',0);
INSERT INTO "code_line" VALUES(1,81,81,'     */
',0);
INSERT INTO "code_line" VALUES(1,82,82,'    public function testBalanceCannotBecomeNegative()
',0);
INSERT INTO "code_line" VALUES(1,83,83,'    {
',0);
INSERT INTO "code_line" VALUES(1,84,84,'        try {
',0);
INSERT INTO "code_line" VALUES(1,85,85,'            $this->ba->withdrawMoney(1);
',1);
INSERT INTO "code_line" VALUES(1,86,86,'        }
',0);
INSERT INTO "code_line" VALUES(1,87,87,'
',0);
INSERT INTO "code_line" VALUES(1,88,88,'        catch (BankAccountException $e) {
',1);
INSERT INTO "code_line" VALUES(1,89,89,'            $this->assertEquals(0, $this->ba->getBalance());
',1);
INSERT INTO "code_line" VALUES(1,90,90,'
',0);
INSERT INTO "code_line" VALUES(1,91,91,'            return;
',1);
INSERT INTO "code_line" VALUES(1,92,92,'        }
',0);
INSERT INTO "code_line" VALUES(1,93,93,'
',0);
INSERT INTO "code_line" VALUES(1,94,94,'        $this->fail();
',1);
INSERT INTO "code_line" VALUES(1,95,95,'    }
',1);
INSERT INTO "code_line" VALUES(1,96,96,'
',0);
INSERT INTO "code_line" VALUES(1,97,97,'    /**
',0);
INSERT INTO "code_line" VALUES(1,98,98,'     * @covers BankAccount::depositMoney
',0);
INSERT INTO "code_line" VALUES(1,99,99,'     */
',0);
INSERT INTO "code_line" VALUES(1,100,100,'    public function testBalanceCannotBecomeNegative2()
',0);
INSERT INTO "code_line" VALUES(1,101,101,'    {
',0);
INSERT INTO "code_line" VALUES(1,102,102,'        try {
',0);
INSERT INTO "code_line" VALUES(1,103,103,'            $this->ba->depositMoney(-1);
',1);
INSERT INTO "code_line" VALUES(1,104,104,'        }
',0);
INSERT INTO "code_line" VALUES(1,105,105,'
',0);
INSERT INTO "code_line" VALUES(1,106,106,'        catch (BankAccountException $e) {
',1);
INSERT INTO "code_line" VALUES(1,107,107,'            $this->assertEquals(0, $this->ba->getBalance());
',1);
INSERT INTO "code_line" VALUES(1,108,108,'
',0);
INSERT INTO "code_line" VALUES(1,109,109,'            return;
',1);
INSERT INTO "code_line" VALUES(1,110,110,'        }
',0);
INSERT INTO "code_line" VALUES(1,111,111,'
',0);
INSERT INTO "code_line" VALUES(1,112,112,'        $this->fail();
',1);
INSERT INTO "code_line" VALUES(1,113,113,'    }
',1);
INSERT INTO "code_line" VALUES(1,114,114,'
',0);
INSERT INTO "code_line" VALUES(1,115,115,'    /**
',0);
INSERT INTO "code_line" VALUES(1,116,116,'     * @covers BankAccount::getBalance
',0);
INSERT INTO "code_line" VALUES(1,117,117,'     * @covers BankAccount::depositMoney
',0);
INSERT INTO "code_line" VALUES(1,118,118,'     * @covers BankAccount::withdrawMoney
',0);
INSERT INTO "code_line" VALUES(1,119,119,'     */
',0);
INSERT INTO "code_line" VALUES(1,120,120,'/*
',0);
INSERT INTO "code_line" VALUES(1,121,121,'    public function testDepositWithdrawMoney()
',0);
INSERT INTO "code_line" VALUES(1,122,122,'    {
',0);
INSERT INTO "code_line" VALUES(1,123,123,'        $this->assertEquals(0, $this->ba->getBalance());
',0);
INSERT INTO "code_line" VALUES(1,124,124,'        $this->ba->depositMoney(1);
',0);
INSERT INTO "code_line" VALUES(1,125,125,'        $this->assertEquals(1, $this->ba->getBalance());
',0);
INSERT INTO "code_line" VALUES(1,126,126,'        $this->ba->withdrawMoney(1);
',0);
INSERT INTO "code_line" VALUES(1,127,127,'        $this->assertEquals(0, $this->ba->getBalance());
',0);
INSERT INTO "code_line" VALUES(1,128,128,'    }
',0);
INSERT INTO "code_line" VALUES(1,129,129,'*/
',0);
INSERT INTO "code_line" VALUES(1,130,130,'}
',0);
INSERT INTO "code_line" VALUES(1,131,131,'?>
',0);
INSERT INTO "code_line" VALUES(2,132,1,'<?php
',0);
INSERT INTO "code_line" VALUES(2,133,2,'/**
',0);
INSERT INTO "code_line" VALUES(2,134,3,' * PHPUnit
',0);
INSERT INTO "code_line" VALUES(2,135,4,' *
',0);
INSERT INTO "code_line" VALUES(2,136,5,' * Copyright (c) 2002-2008, Sebastian Bergmann <sb@sebastian-bergmann.de>.
',0);
INSERT INTO "code_line" VALUES(2,137,6,' * All rights reserved.
',0);
INSERT INTO "code_line" VALUES(2,138,7,' *
',0);
INSERT INTO "code_line" VALUES(2,139,8,' * Redistribution and use in source and binary forms, with or without
',0);
INSERT INTO "code_line" VALUES(2,140,9,' * modification, are permitted provided that the following conditions
',0);
INSERT INTO "code_line" VALUES(2,141,10,' * are met:
',0);
INSERT INTO "code_line" VALUES(2,142,11,' *
',0);
INSERT INTO "code_line" VALUES(2,143,12,' *   * Redistributions of source code must retain the above copyright
',0);
INSERT INTO "code_line" VALUES(2,144,13,' *     notice, this list of conditions and the following disclaimer.
',0);
INSERT INTO "code_line" VALUES(2,145,14,' *
',0);
INSERT INTO "code_line" VALUES(2,146,15,' *   * Redistributions in binary form must reproduce the above copyright
',0);
INSERT INTO "code_line" VALUES(2,147,16,' *     notice, this list of conditions and the following disclaimer in
',0);
INSERT INTO "code_line" VALUES(2,148,17,' *     the documentation and/or other materials provided with the
',0);
INSERT INTO "code_line" VALUES(2,149,18,' *     distribution.
',0);
INSERT INTO "code_line" VALUES(2,150,19,' *
',0);
INSERT INTO "code_line" VALUES(2,151,20,' *   * Neither the name of Sebastian Bergmann nor the names of his
',0);
INSERT INTO "code_line" VALUES(2,152,21,' *     contributors may be used to endorse or promote products derived
',0);
INSERT INTO "code_line" VALUES(2,153,22,' *     from this software without specific prior written permission.
',0);
INSERT INTO "code_line" VALUES(2,154,23,' *
',0);
INSERT INTO "code_line" VALUES(2,155,24,' * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
',0);
INSERT INTO "code_line" VALUES(2,156,25,' * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
',0);
INSERT INTO "code_line" VALUES(2,157,26,' * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
',0);
INSERT INTO "code_line" VALUES(2,158,27,' * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
',0);
INSERT INTO "code_line" VALUES(2,159,28,' * COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
',0);
INSERT INTO "code_line" VALUES(2,160,29,' * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
',0);
INSERT INTO "code_line" VALUES(2,161,30,' * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
',0);
INSERT INTO "code_line" VALUES(2,162,31,' * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
',0);
INSERT INTO "code_line" VALUES(2,163,32,' * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
',0);
INSERT INTO "code_line" VALUES(2,164,33,' * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
',0);
INSERT INTO "code_line" VALUES(2,165,34,' * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
',0);
INSERT INTO "code_line" VALUES(2,166,35,' * POSSIBILITY OF SUCH DAMAGE.
',0);
INSERT INTO "code_line" VALUES(2,167,36,' *
',0);
INSERT INTO "code_line" VALUES(2,168,37,' * @category   Testing
',0);
INSERT INTO "code_line" VALUES(2,169,38,' * @package    PHPUnit
',0);
INSERT INTO "code_line" VALUES(2,170,39,' * @author     Sebastian Bergmann <sb@sebastian-bergmann.de>
',0);
INSERT INTO "code_line" VALUES(2,171,40,' * @copyright  2002-2008 Sebastian Bergmann <sb@sebastian-bergmann.de>
',0);
INSERT INTO "code_line" VALUES(2,172,41,' * @license    http://www.opensource.org/licenses/bsd-license.php  BSD License
',0);
INSERT INTO "code_line" VALUES(2,173,42,' * @version    SVN: $Id: BankAccount.php 1984 2007-12-26 18:11:04Z sb $
',0);
INSERT INTO "code_line" VALUES(2,174,43,' * @link       http://www.phpunit.de/
',0);
INSERT INTO "code_line" VALUES(2,175,44,' * @since      File available since Release 2.3.0
',0);
INSERT INTO "code_line" VALUES(2,176,45,' */
',0);
INSERT INTO "code_line" VALUES(2,177,46,'
',0);
INSERT INTO "code_line" VALUES(2,178,47,'class BankAccountException extends RuntimeException {}
',0);
INSERT INTO "code_line" VALUES(2,179,48,'
',0);
INSERT INTO "code_line" VALUES(2,180,49,'/**
',0);
INSERT INTO "code_line" VALUES(2,181,50,' * A bank account.
',0);
INSERT INTO "code_line" VALUES(2,182,51,' *
',0);
INSERT INTO "code_line" VALUES(2,183,52,' * @category   Testing
',0);
INSERT INTO "code_line" VALUES(2,184,53,' * @package    PHPUnit
',0);
INSERT INTO "code_line" VALUES(2,185,54,' * @author     Sebastian Bergmann <sb@sebastian-bergmann.de>
',0);
INSERT INTO "code_line" VALUES(2,186,55,' * @copyright  2002-2008 Sebastian Bergmann <sb@sebastian-bergmann.de>
',0);
INSERT INTO "code_line" VALUES(2,187,56,' * @license    http://www.opensource.org/licenses/bsd-license.php  BSD License
',0);
INSERT INTO "code_line" VALUES(2,188,57,' * @version    Release: @package_version@
',0);
INSERT INTO "code_line" VALUES(2,189,58,' * @link       http://www.phpunit.de/
',0);
INSERT INTO "code_line" VALUES(2,190,59,' * @since      Class available since Release 2.3.0
',0);
INSERT INTO "code_line" VALUES(2,191,60,' */
',0);
INSERT INTO "code_line" VALUES(2,192,61,'class BankAccount
',0);
INSERT INTO "code_line" VALUES(2,193,62,'{
',0);
INSERT INTO "code_line" VALUES(2,194,63,'    /**
',0);
INSERT INTO "code_line" VALUES(2,195,64,'     * The bank account''s balance.
',0);
INSERT INTO "code_line" VALUES(2,196,65,'     *
',0);
INSERT INTO "code_line" VALUES(2,197,66,'     * @var    float
',0);
INSERT INTO "code_line" VALUES(2,198,67,'     * @access protected
',0);
INSERT INTO "code_line" VALUES(2,199,68,'     */
',0);
INSERT INTO "code_line" VALUES(2,200,69,'    protected $balance = 0;
',0);
INSERT INTO "code_line" VALUES(2,201,70,'
',0);
INSERT INTO "code_line" VALUES(2,202,71,'    /**
',0);
INSERT INTO "code_line" VALUES(2,203,72,'     * Returns the bank account''s balance.
',0);
INSERT INTO "code_line" VALUES(2,204,73,'     *
',0);
INSERT INTO "code_line" VALUES(2,205,74,'     * @return float
',0);
INSERT INTO "code_line" VALUES(2,206,75,'     * @access public
',0);
INSERT INTO "code_line" VALUES(2,207,76,'     */
',0);
INSERT INTO "code_line" VALUES(2,208,77,'    public function getBalance()
',0);
INSERT INTO "code_line" VALUES(2,209,78,'    {
',0);
INSERT INTO "code_line" VALUES(2,210,79,'        return $this->balance;
',1);
INSERT INTO "code_line" VALUES(2,211,80,'    }
',1);
INSERT INTO "code_line" VALUES(2,212,81,'
',0);
INSERT INTO "code_line" VALUES(2,213,82,'    /**
',0);
INSERT INTO "code_line" VALUES(2,214,83,'     * Sets the bank account''s balance.
',0);
INSERT INTO "code_line" VALUES(2,215,84,'     *
',0);
INSERT INTO "code_line" VALUES(2,216,85,'     * @param  float $balance
',0);
INSERT INTO "code_line" VALUES(2,217,86,'     * @throws BankAccountException
',0);
INSERT INTO "code_line" VALUES(2,218,87,'     * @access protected
',0);
INSERT INTO "code_line" VALUES(2,219,88,'     */
',0);
INSERT INTO "code_line" VALUES(2,220,89,'    protected function setBalance($balance)
',0);
INSERT INTO "code_line" VALUES(2,221,90,'    {
',0);
INSERT INTO "code_line" VALUES(2,222,91,'        if ($balance >= 0) {
',1);
INSERT INTO "code_line" VALUES(2,223,92,'            $this->balance = $balance;
',1);
INSERT INTO "code_line" VALUES(2,224,93,'        } else {
',1);
INSERT INTO "code_line" VALUES(2,225,94,'            throw new BankAccountException;
',1);
INSERT INTO "code_line" VALUES(2,226,95,'        }
',0);
INSERT INTO "code_line" VALUES(2,227,96,'    }
',1);
INSERT INTO "code_line" VALUES(2,228,97,'
',0);
INSERT INTO "code_line" VALUES(2,229,98,'    /**
',0);
INSERT INTO "code_line" VALUES(2,230,99,'     * Deposits an amount of money to the bank account.
',0);
INSERT INTO "code_line" VALUES(2,231,100,'     *
',0);
INSERT INTO "code_line" VALUES(2,232,101,'     * @param  float $balance
',0);
INSERT INTO "code_line" VALUES(2,233,102,'     * @throws BankAccountException
',0);
INSERT INTO "code_line" VALUES(2,234,103,'     * @access public
',0);
INSERT INTO "code_line" VALUES(2,235,104,'     */
',0);
INSERT INTO "code_line" VALUES(2,236,105,'    public function depositMoney($balance)
',0);
INSERT INTO "code_line" VALUES(2,237,106,'    {
',0);
INSERT INTO "code_line" VALUES(2,238,107,'        $this->setBalance($this->getBalance() + $balance);
',1);
INSERT INTO "code_line" VALUES(2,239,108,'
',0);
INSERT INTO "code_line" VALUES(2,240,109,'        return $this->getBalance();
',1);
INSERT INTO "code_line" VALUES(2,241,110,'    }
',1);
INSERT INTO "code_line" VALUES(2,242,111,'
',0);
INSERT INTO "code_line" VALUES(2,243,112,'    /**
',0);
INSERT INTO "code_line" VALUES(2,244,113,'     * Withdraws an amount of money from the bank account.
',0);
INSERT INTO "code_line" VALUES(2,245,114,'     *
',0);
INSERT INTO "code_line" VALUES(2,246,115,'     * @param  float $balance
',0);
INSERT INTO "code_line" VALUES(2,247,116,'     * @throws BankAccountException
',0);
INSERT INTO "code_line" VALUES(2,248,117,'     * @access public
',0);
INSERT INTO "code_line" VALUES(2,249,118,'     */
',0);
INSERT INTO "code_line" VALUES(2,250,119,'    public function withdrawMoney($balance)
',0);
INSERT INTO "code_line" VALUES(2,251,120,'    {
',0);
INSERT INTO "code_line" VALUES(2,252,121,'        $this->setBalance($this->getBalance() - $balance);
',1);
INSERT INTO "code_line" VALUES(2,253,122,'
',0);
INSERT INTO "code_line" VALUES(2,254,123,'        return $this->getBalance();
',1);
INSERT INTO "code_line" VALUES(2,255,124,'    }
',1);
INSERT INTO "code_line" VALUES(2,256,125,'}
',0);
INSERT INTO "code_line" VALUES(2,257,126,'?>
',0);
CREATE TABLE code_coverage(
  test_id      INTEGER,
  code_line_id INTEGER
);
INSERT INTO "code_coverage" VALUES(2,68);
INSERT INTO "code_coverage" VALUES(3,68);
INSERT INTO "code_coverage" VALUES(4,68);
INSERT INTO "code_coverage" VALUES(2,69);
INSERT INTO "code_coverage" VALUES(3,69);
INSERT INTO "code_coverage" VALUES(4,69);
INSERT INTO "code_coverage" VALUES(2,76);
INSERT INTO "code_coverage" VALUES(2,77);
INSERT INTO "code_coverage" VALUES(3,85);
INSERT INTO "code_coverage" VALUES(3,88);
INSERT INTO "code_coverage" VALUES(3,89);
INSERT INTO "code_coverage" VALUES(3,91);
INSERT INTO "code_coverage" VALUES(4,103);
INSERT INTO "code_coverage" VALUES(4,106);
INSERT INTO "code_coverage" VALUES(4,107);
INSERT INTO "code_coverage" VALUES(4,109);
INSERT INTO "code_coverage" VALUES(2,210);
INSERT INTO "code_coverage" VALUES(4,238);
INSERT INTO "code_coverage" VALUES(3,252);
CREATE TABLE metrics_project(
  run_id                  INTEGER,
  metrics_project_cls     INTEGER,
  metrics_project_clsa    INTEGER,
  metrics_project_clsc    INTEGER,
  metrics_project_roots   INTEGER,
  metrics_project_leafs   INTEGER,
  metrics_project_interfs INTEGER,
  metrics_project_maxdit  INTEGER
);
INSERT INTO "metrics_project" VALUES(1,3,0,3,0,3,0,2);
CREATE TABLE metrics_file(
  run_id                      INTEGER,
  code_file_id                INTEGER,
  metrics_file_coverage       REAL,
  metrics_file_loc            INTEGER,
  metrics_file_cloc           INTEGER,
  metrics_file_ncloc          INTEGER,
  metrics_file_loc_executable INTEGER,
  metrics_file_loc_executed   INTEGER
);
INSERT INTO "metrics_file" VALUES(1,1,100.0,131,80,51,12,12);
INSERT INTO "metrics_file" VALUES(1,2,37.5,126,89,37,8,3);
CREATE TABLE metrics_function(
  run_id                          INTEGER,
  code_function_id                INTEGER,
  metrics_function_coverage       REAL,
  metrics_function_loc            INTEGER,
  metrics_function_loc_executable INTEGER,
  metrics_function_loc_executed   INTEGER,
  metrics_function_ccn            INTEGER,
  metrics_function_crap           REAL,
  metrics_function_npath          INTEGER
);
CREATE TABLE metrics_class(
  run_id                       INTEGER,
  code_class_id                INTEGER,
  metrics_class_coverage       REAL,
  metrics_class_loc            INTEGER,
  metrics_class_loc_executable INTEGER,
  metrics_class_loc_executed   INTEGER,
  metrics_class_aif            REAL,
  metrics_class_ahf            REAL,
  metrics_class_cis            INTEGER,
  metrics_class_csz            INTEGER,
  metrics_class_dit            INTEGER,
  metrics_class_impl           INTEGER,
  metrics_class_mif            REAL,
  metrics_class_mhf            REAL,
  metrics_class_noc            INTEGER,
  metrics_class_pf             REAL,
  metrics_class_vars           INTEGER,
  metrics_class_varsnp         INTEGER,
  metrics_class_varsi          INTEGER,
  metrics_class_wmc            INTEGER,
  metrics_class_wmcnp          INTEGER,
  metrics_class_wmci           INTEGER
);
INSERT INTO "metrics_class" VALUES(1,1,100.0,69,12,12,93.333333,100.0,3,5,2,3,96.396396,17.117117,0,0.925926,1,0,15,6,5,232);
INSERT INTO "metrics_class" VALUES(1,2,0.0,1,0,0,100.0,100.0,0,0,2,0,100.0,11.111111,0,0.0,0,0,4,0,0,9);
INSERT INTO "metrics_class" VALUES(1,3,37.5,65,8,3,0.0,100.0,3,5,0,0,0.0,25.0,0,0.0,1,0,1,5,3,5);
CREATE TABLE metrics_method(
  run_id                        INTEGER,
  code_method_id                INTEGER,
  metrics_method_coverage       REAL,
  metrics_method_loc            INTEGER,
  metrics_method_loc_executable INTEGER,
  metrics_method_loc_executed   INTEGER,
  metrics_method_ccn            INTEGER,
  metrics_method_crap           REAL,
  metrics_method_npath          INTEGER
);
INSERT INTO "metrics_method" VALUES(1,1,100.0,4,2,2,1,1.0,1);
INSERT INTO "metrics_method" VALUES(1,2,100.0,4,2,2,1,1.0,1);
INSERT INTO "metrics_method" VALUES(1,3,100.0,14,4,4,2,2.0,2);
INSERT INTO "metrics_method" VALUES(1,4,100.0,14,4,4,2,2.0,2);
INSERT INTO "metrics_method" VALUES(1,5,100.0,4,1,1,1,1.0,1);
INSERT INTO "metrics_method" VALUES(1,6,0.0,8,3,0,2,6.0,2);
INSERT INTO "metrics_method" VALUES(1,7,50.0,6,2,1,1,1.125,1);
INSERT INTO "metrics_method" VALUES(1,8,50.0,6,2,1,1,1.125,1);
CREATE INDEX test_run_id         ON test (run_id);
CREATE INDEX test_result         ON test (test_result);
CREATE INDEX test_code_method_id ON test (code_method_id);
CREATE INDEX test_node_root      ON test (node_root);
CREATE INDEX test_node_left      ON test (node_left);
CREATE INDEX test_node_right     ON test (node_right);
CREATE INDEX code_file_id ON code_function (code_file_id);
CREATE INDEX code_class_id ON code_method (code_class_id);
CREATE INDEX code_line_code_file_id ON code_line (code_file_id);
CREATE UNIQUE INDEX code_coverage_test_id_code_line_id ON code_coverage (test_id, code_line_id);
CREATE INDEX run_id ON metrics_project (run_id);
CREATE INDEX code_function_id ON metrics_function (code_function_id);
CREATE INDEX code_method_id ON metrics_method (code_method_id);
COMMIT;