IP : 18.224.55.136Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
./
../
var/
softaculous/
moodle43/
../
goffice6/
../
elgg4/
./
../
testlink/
testlink.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `[[dbprefix]]custom_fields` --
CREATE TABLE `[[dbprefix]]custom_fields` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL DEFAULT '', `label` varchar(64) NOT NULL DEFAULT '' COMMENT 'label to display on user interface', `type` smallint(6) NOT NULL DEFAULT '0', `possible_values` varchar(4000) NOT NULL DEFAULT '', `default_value` varchar(4000) NOT NULL DEFAULT '', `valid_regexp` varchar(255) NOT NULL DEFAULT '', `length_min` int(10) NOT NULL DEFAULT '0', `length_max` int(10) NOT NULL DEFAULT '0', `show_on_design` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1=> show it during specification design', `enable_on_design` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1=> user can write/manage it during specification design', `show_on_execution` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1=> show it during test case execution', `enable_on_execution` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1=> user can write/manage it during test case execution', `show_on_testplan_design` tinyint(3) unsigned NOT NULL DEFAULT '0', `enable_on_testplan_design` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `[[dbprefix]]idx_custom_fields_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Structure for view `[[dbprefix]]exec_by_date_time` -- DROP TABLE IF EXISTS `[[dbprefix]]exec_by_date_time`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `[[dbprefix]]exec_by_date_time` AS (select `NHTPL`.`name` AS `testplan_name`,date_format(`E`.`execution_ts`,'%Y-%m-%d') AS `yyyy_mm_dd`,date_format(`E`.`execution_ts`,'%Y-%m') AS `yyyy_mm`,date_format(`E`.`execution_ts`,'%H') AS `hh`,date_format(`E`.`execution_ts`,'%k') AS `hour`,`E`.`id` AS `id`,`E`.`build_id` AS `build_id`,`E`.`tester_id` AS `tester_id`,`E`.`execution_ts` AS `execution_ts`,`E`.`status` AS `status`,`E`.`testplan_id` AS `testplan_id`,`E`.`tcversion_id` AS `tcversion_id`,`E`.`tcversion_number` AS `tcversion_number`,`E`.`platform_id` AS `platform_id`,`E`.`execution_type` AS `execution_type`,`E`.`execution_duration` AS `execution_duration`,`E`.`notes` AS `notes` from ((`[[dbprefix]]executions` `E` join `[[dbprefix]]testplans` `TPL` on((`TPL`.`id` = `E`.`testplan_id`))) join `[[dbprefix]]nodes_hierarchy` `NHTPL` on((`NHTPL`.`id` = `TPL`.`id`))));
-- -- Structure for view `[[dbprefix]]latest_exec_by_context` -- DROP TABLE IF EXISTS `[[dbprefix]]latest_exec_by_context`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `[[dbprefix]]latest_exec_by_context` AS select `[[dbprefix]]executions`.`tcversion_id` AS `tcversion_id`,`[[dbprefix]]executions`.`testplan_id` AS `testplan_id`,`[[dbprefix]]executions`.`build_id` AS `build_id`,`[[dbprefix]]executions`.`platform_id` AS `platform_id`,max(`[[dbprefix]]executions`.`id`) AS `id` from `[[dbprefix]]executions` group by `[[dbprefix]]executions`.`tcversion_id`,`[[dbprefix]]executions`.`testplan_id`,`[[dbprefix]]executions`.`build_id`,`[[dbprefix]]executions`.`platform_id`;
-- -- Structure for view `[[dbprefix]]latest_exec_by_testplan` -- DROP TABLE IF EXISTS `[[dbprefix]]latest_exec_by_testplan`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `[[dbprefix]]latest_exec_by_testplan` AS select `[[dbprefix]]executions`.`tcversion_id` AS `tcversion_id`,`[[dbprefix]]executions`.`testplan_id` AS `testplan_id`,max(`[[dbprefix]]executions`.`id`) AS `id` from `[[dbprefix]]executions` group by `[[dbprefix]]executions`.`tcversion_id`,`[[dbprefix]]executions`.`testplan_id`;
-- -- Structure for view `[[dbprefix]]latest_exec_by_testplan_plat` -- DROP TABLE IF EXISTS `[[dbprefix]]latest_exec_by_testplan_plat`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `[[dbprefix]]latest_exec_by_testplan_plat` AS select `[[dbprefix]]executions`.`tcversion_id` AS `tcversion_id`,`[[dbprefix]]executions`.`testplan_id` AS `testplan_id`,`[[dbprefix]]executions`.`platform_id` AS `platform_id`,max(`[[dbprefix]]executions`.`id`) AS `id` from `[[dbprefix]]executions` group by `[[dbprefix]]executions`.`tcversion_id`,`[[dbprefix]]executions`.`testplan_id`,`[[dbprefix]]executions`.`platform_id`;
-- -- Structure for view `[[dbprefix]]latest_rspec_revision` -- DROP TABLE IF EXISTS `[[dbprefix]]latest_rspec_revision`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `[[dbprefix]]latest_rspec_revision` AS select `RSR`.`parent_id` AS `req_spec_id`,`RS`.`testproject_id` AS `testproject_id`,max(`RSR`.`revision`) AS `revision` from (`[[dbprefix]]req_specs_revisions` `RSR` join `[[dbprefix]]req_specs` `RS` on((`RS`.`id` = `RSR`.`parent_id`))) group by `RSR`.`parent_id`,`RS`.`testproject_id`;
-- -- Structure for view `[[dbprefix]]tcversions_without_keywords` -- DROP TABLE IF EXISTS `[[dbprefix]]tcversions_without_keywords`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `[[dbprefix]]tcversions_without_keywords` AS select `NHTCV`.`parent_id` AS `testcase_id`,`NHTCV`.`id` AS `id` from `[[dbprefix]]nodes_hierarchy` `NHTCV` where ((`NHTCV`.`node_type_id` = 4) and (not(exists(select 1 from `[[dbprefix]]testcase_keywords` `TCK` where (`TCK`.`tcversion_id` = `NHTCV`.`id`)))));
-- -- Structure for view `[[dbprefix]]tcversions_without_platforms` -- DROP TABLE IF EXISTS `[[dbprefix]]tcversions_without_platforms`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `[[dbprefix]]tcversions_without_platforms` AS select `NHTCV`.`parent_id` AS `testcase_id`,`NHTCV`.`id` AS `id` from `[[dbprefix]]nodes_hierarchy` `NHTCV` where ((`NHTCV`.`node_type_id` = 4) and (not(exists(select 1 from `[[dbprefix]]testcase_platforms` `TCPL` where (`TCPL`.`tcversion_id` = `NHTCV`.`id`)))));
-- -- Structure for view `[[dbprefix]]tsuites_tree_depth_2` -- DROP TABLE IF EXISTS `[[dbprefix]]tsuites_tree_depth_2`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `[[dbprefix]]tsuites_tree_depth_2` AS select `TPRJ`.`prefix` AS `prefix`,`NHTPRJ`.`name` AS `testproject_name`,`NHTS_L1`.`name` AS `level1_name`,`NHTS_L2`.`name` AS `level2_name`,`NHTPRJ`.`id` AS `testproject_id`,`NHTS_L1`.`id` AS `level1_id`,`NHTS_L2`.`id` AS `level2_id` from (((`[[dbprefix]]testprojects` `TPRJ` join `[[dbprefix]]nodes_hierarchy` `NHTPRJ` on((`TPRJ`.`id` = `NHTPRJ`.`id`))) left join `[[dbprefix]]nodes_hierarchy` `NHTS_L1` on((`NHTS_L1`.`parent_id` = `NHTPRJ`.`id`))) left join `[[dbprefix]]nodes_hierarchy` `NHTS_L2` on((`NHTS_L2`.`parent_id` = `NHTS_L1`.`id`))) where ((`NHTPRJ`.`node_type_id` = 1) and (`NHTS_L1`.`node_type_id` = 2) and (`NHTS_L2`.`node_type_id` = 2));
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;