--
-- 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: SQLite3.sql 4838 2009-04-27 06:32:39Z sb $
--

CREATE TABLE IF NOT EXISTS run(
  run_id      INTEGER PRIMARY KEY AUTOINCREMENT,
  timestamp   INTEGER,
  revision    INTEGER,
  information STRING,
  completed   INTEGER DEFAULT 0
);

CREATE TABLE IF NOT EXISTS 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_parent         INTEGER,
  node_depth          INTEGER,
  node_is_leaf        INTEGER DEFAULT 0
);

CREATE INDEX IF NOT EXISTS test_run_id         ON test (run_id);
CREATE INDEX IF NOT EXISTS test_result         ON test (test_result);
CREATE INDEX IF NOT EXISTS test_code_method_id ON test (code_method_id);
CREATE INDEX IF NOT EXISTS test_node_root      ON test (node_root);
CREATE INDEX IF NOT EXISTS test_node_left      ON test (node_left);
CREATE INDEX IF NOT EXISTS test_node_right     ON test (node_right);
CREATE INDEX IF NOT EXISTS test_node_parent    ON test (node_parent);

CREATE TABLE IF NOT EXISTS code_file(
  code_file_id        INTEGER PRIMARY KEY AUTOINCREMENT,
  code_file_name      TEXT,
  code_full_file_name TEXT,
  code_file_md5       TEXT,
  revision            INTEGER
);

CREATE TABLE IF NOT EXISTS 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 INDEX IF NOT EXISTS code_file_id ON code_function (code_file_id);

CREATE TABLE IF NOT EXISTS 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
);

CREATE INDEX IF NOT EXISTS code_file_id ON code_class (code_file_id);

CREATE TABLE IF NOT EXISTS 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
);

CREATE INDEX IF NOT EXISTS code_class_id ON code_method (code_class_id);

CREATE TABLE IF NOT EXISTS code_line(
  code_file_id      INTEGER,
  code_line_id      INTEGER PRIMARY KEY AUTOINCREMENT,
  code_line_number  INTEGER,
  code_line         TEXT,
  code_line_covered INTEGER
);

CREATE INDEX IF NOT EXISTS code_line_code_file_id ON code_line (code_file_id);

CREATE TABLE IF NOT EXISTS code_coverage(
  test_id      INTEGER,
  code_line_id INTEGER
);

CREATE UNIQUE INDEX IF NOT EXISTS code_coverage_test_id_code_line_id ON code_coverage (test_id, code_line_id);

CREATE TABLE IF NOT EXISTS 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
);

CREATE INDEX IF NOT EXISTS run_id ON metrics_project (run_id);

CREATE TABLE IF NOT EXISTS 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
);

CREATE INDEX IF NOT EXISTS run_id ON metrics_file (run_id);
CREATE INDEX IF NOT EXISTS code_file_id ON metrics_file (code_file_id);

CREATE TABLE IF NOT EXISTS 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 INDEX IF NOT EXISTS run_id ON metrics_function (run_id);
CREATE INDEX IF NOT EXISTS code_function_id ON metrics_function (code_function_id);

CREATE TABLE IF NOT EXISTS 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
);

CREATE INDEX IF NOT EXISTS run_id ON metrics_class (run_id);
CREATE INDEX IF NOT EXISTS code_class_id ON metrics_class (code_class_id);

CREATE TABLE IF NOT EXISTS 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
);

CREATE INDEX IF NOT EXISTS run_id ON metrics_method (run_id);
CREATE INDEX IF NOT EXISTS code_method_id ON metrics_method (code_method_id);
