text: #
  # PHPUnit
  #
  # Copyright (c) 2002-2009, Sebastian Bergmann <sb@sebastian-bergmann.de>.
  # All rights reserved.
  #
  # Redistribution and use in source and binary forms, with or without
  # modification, are permitted provided that the following conditions
  # are met:
  #
  #   * Redistributions of source code must retain the above copyright
  #     notice, this list of conditions and the following disclaimer.
  #
  #   * Redistributions in binary form must reproduce the above copyright
  #     notice, this list of conditions and the following disclaimer in
  #     the documentation and/or other materials provided with the
  #     distribution.
  #
  #   * Neither the name of Sebastian Bergmann nor the names of his
  #     contributors may be used to endorse or promote products derived
  #     from this software without specific prior written permission.
  #
  # THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
  # "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
  # LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
  # FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
  # COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
  # INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
  # BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
  # LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
  # CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
  # LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
  # ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
  # POSSIBILITY OF SUCH DAMAGE.
  #
  # $Id$
  #
  
  CREATE TABLE IF NOT EXISTS run(
    run_id      INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    timestamp   INTEGER UNSIGNED NOT NULL,
    revision    INTEGER UNSIGNED NOT NULL,
    information TEXT             NOT NULL,
    completed   BOOLEAN          NOT NULL DEFAULT 0
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS test(
    run_id              INTEGER UNSIGNED NOT NULL REFERENCES run.run_id,
    test_id             INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    test_name           CHAR(128)        NOT NULL,
    test_result         TINYINT UNSIGNED NOT NULL DEFAULT 0,
    test_message        TEXT             NOT NULL DEFAULT "",
    test_execution_time FLOAT   UNSIGNED NOT NULL DEFAULT 0,
    code_method_id      INTEGER UNSIGNED          REFERENCES code_method.code_method_id,
    node_root           INTEGER UNSIGNED NOT NULL,
    node_left           INTEGER UNSIGNED NOT NULL,
    node_right          INTEGER UNSIGNED NOT NULL,
    node_parent         INTEGER UNSIGNED NOT NULL,
    node_depth          TINYINT UNSIGNED NOT NULL,
    node_is_leaf        BOOLEAN          NOT NULL DEFAULT 0,
  
    INDEX (run_id),
    INDEX (test_result),
    INDEX (code_method_id),
    INDEX (node_root),
    INDEX (node_left),
    INDEX (node_right),
    INDEX (node_parent)
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS code_file(
    code_file_id        INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    code_file_name      CHAR(255),
    code_full_file_name CHAR(255),
    code_file_md5       CHAR(32),
    revision            INTEGER UNSIGNED NOT NULL
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS code_function(
    code_file_id             INTEGER UNSIGNED NOT NULL REFERENCES code_file.code_file_id,
    code_function_id         INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    code_function_name       CHAR(255),
    code_function_start_line INTEGER UNSIGNED NOT NULL,
    code_function_end_line   INTEGER UNSIGNED NOT NULL,
  
    INDEX (code_file_id)
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS code_class(
    code_file_id          INTEGER UNSIGNED NOT NULL REFERENCES code_file.code_file_id,
    code_class_id         INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    code_class_parent_id  INTEGER UNSIGNED REFERENCES code_class.code_class_id,
    code_class_name       CHAR(255),
    code_class_start_line INTEGER UNSIGNED NOT NULL,
    code_class_end_line   INTEGER UNSIGNED NOT NULL,
  
    INDEX (code_file_id)
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS code_method(
    code_class_id          INTEGER UNSIGNED NOT NULL REFERENCES code_class.code_class_id,
    code_method_id         INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    code_method_name       CHAR(255),
    code_method_start_line INTEGER UNSIGNED NOT NULL,
    code_method_end_line   INTEGER UNSIGNED NOT NULL,
  
    INDEX (code_class_id)
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS code_line(
    code_file_id      INTEGER UNSIGNED NOT NULL REFERENCES code_file.code_file_id,
    code_line_id      INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    code_line_number  INTEGER UNSIGNED NOT NULL,
    code_line         TEXT,
    code_line_covered TINYINT          NOT NULL,
  
    INDEX (code_file_id)
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS code_coverage(
    test_id      INTEGER UNSIGNED NOT NULL REFERENCES test.test_id,
    code_line_id INTEGER UNSIGNED NOT NULL REFERENCES code_line.code_line_id,
  
    PRIMARY KEY (test_id, code_line_id)
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS metrics_project(
    run_id                  INTEGER UNSIGNED NOT NULL,
    metrics_project_cls     INTEGER UNSIGNED NOT NULL,
    metrics_project_clsa    INTEGER UNSIGNED NOT NULL,
    metrics_project_clsc    INTEGER UNSIGNED NOT NULL,
    metrics_project_roots   INTEGER UNSIGNED NOT NULL,
    metrics_project_leafs   INTEGER UNSIGNED NOT NULL,
    metrics_project_interfs INTEGER UNSIGNED NOT NULL,
    metrics_project_maxdit  INTEGER UNSIGNED NOT NULL,
  
    INDEX (run_id)
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS metrics_file(
    run_id                      INTEGER UNSIGNED NOT NULL,
    code_file_id                INTEGER UNSIGNED NOT NULL REFERENCES code_file.code_file_id,
    metrics_file_coverage       FLOAT   UNSIGNED NOT NULL,
    metrics_file_loc            INTEGER UNSIGNED NOT NULL,
    metrics_file_cloc           INTEGER UNSIGNED NOT NULL,
    metrics_file_ncloc          INTEGER UNSIGNED NOT NULL,
    metrics_file_loc_executable INTEGER UNSIGNED NOT NULL,
    metrics_file_loc_executed   INTEGER UNSIGNED NOT NULL,
  
    INDEX (run_id),
    INDEX (code_file_id)
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS metrics_function(
    run_id                          INTEGER UNSIGNED NOT NULL,
    code_function_id                INTEGER UNSIGNED NOT NULL REFERENCES code_method.code_function_id,
    metrics_function_coverage       FLOAT   UNSIGNED NOT NULL,
    metrics_function_loc            INTEGER UNSIGNED NOT NULL,
    metrics_function_loc_executable INTEGER UNSIGNED NOT NULL,
    metrics_function_loc_executed   INTEGER UNSIGNED NOT NULL,
    metrics_function_ccn            INTEGER UNSIGNED NOT NULL,
    metrics_function_crap           FLOAT   UNSIGNED NOT NULL,
    metrics_function_npath          INTEGER UNSIGNED NOT NULL,
  
    INDEX (run_id),
    INDEX (code_function_id)
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS metrics_class(
    run_id                       INTEGER UNSIGNED NOT NULL,
    code_class_id                INTEGER UNSIGNED NOT NULL REFERENCES code_class.code_class_id,
    metrics_class_coverage       FLOAT   UNSIGNED NOT NULL,
    metrics_class_loc            INTEGER UNSIGNED NOT NULL,
    metrics_class_loc_executable INTEGER UNSIGNED NOT NULL,
    metrics_class_loc_executed   INTEGER UNSIGNED NOT NULL,
    metrics_class_aif            FLOAT   UNSIGNED NOT NULL,
    metrics_class_ahf            FLOAT   UNSIGNED NOT NULL,
    metrics_class_cis            INTEGER UNSIGNED NOT NULL,
    metrics_class_csz            INTEGER UNSIGNED NOT NULL,
    metrics_class_dit            INTEGER UNSIGNED NOT NULL,
    metrics_class_impl           INTEGER UNSIGNED NOT NULL,
    metrics_class_mif            FLOAT   UNSIGNED NOT NULL,
    metrics_class_mhf            FLOAT   UNSIGNED NOT NULL,
    metrics_class_noc            INTEGER UNSIGNED NOT NULL,
    metrics_class_pf             FLOAT   UNSIGNED NOT NULL,
    metrics_class_vars           INTEGER UNSIGNED NOT NULL,
    metrics_class_varsnp         INTEGER UNSIGNED NOT NULL,
    metrics_class_varsi          INTEGER UNSIGNED NOT NULL,
    metrics_class_wmc            INTEGER UNSIGNED NOT NULL,
    metrics_class_wmcnp          INTEGER UNSIGNED NOT NULL,
    metrics_class_wmci           INTEGER UNSIGNED NOT NULL,
  
    INDEX (run_id),
    INDEX (code_class_id)
  ) ENGINE=InnoDB;
  
  CREATE TABLE IF NOT EXISTS metrics_method(
    run_id                        INTEGER UNSIGNED NOT NULL,
    code_method_id                INTEGER UNSIGNED NOT NULL REFERENCES code_method.code_method_id,
    metrics_method_coverage       FLOAT   UNSIGNED NOT NULL,
    metrics_method_loc            INTEGER UNSIGNED NOT NULL,
    metrics_method_loc_executable INTEGER UNSIGNED NOT NULL,
    metrics_method_loc_executed   INTEGER UNSIGNED NOT NULL,
    metrics_method_ccn            INTEGER UNSIGNED NOT NULL,
    metrics_method_crap           FLOAT   UNSIGNED NOT NULL,
    metrics_method_npath          INTEGER UNSIGNED NOT NULL,
  
    INDEX (run_id),
    INDEX (code_method_id)
  ) ENGINE=InnoDB;
  