Blame | Letzte Änderung | Log anzeigen | RSS feed
## 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;