Subversion-Projekte lars-tiefland.php_share

--

-- 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 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);