Skip to content

Instantly share code, notes, and snippets.

@yume-yu

yume-yu/sample.sql

Created September 21, 2023 04:57
Show Gist options
  • Save yume-yu/6cdec4d64b467cdbf925696283940ded to your computer and use it in GitHub Desktop.
Save yume-yu/6cdec4d64b467cdbf925696283940ded to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sample.sql
-- MySQL dump 10.13 Distrib 5.7.40, for Linux (x86_64)
--
-- Host: localhost Database: testlink
-- ------------------------------------------------------
-- Server version 5.7.40
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `assignment_status`
--
DROP TABLE IF EXISTS `assignment_status`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `assignment_status` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`description` varchar(100) NOT NULL DEFAULT 'unknown',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `assignment_status`
--
LOCK TABLES `assignment_status` WRITE;
/*!40000 ALTER TABLE `assignment_status` DISABLE KEYS */;
INSERT INTO `assignment_status` VALUES (1,'open'),(2,'closed'),(3,'completed'),(4,'todo_urgent'),(5,'todo');
/*!40000 ALTER TABLE `assignment_status` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `assignment_types`
--
DROP TABLE IF EXISTS `assignment_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `assignment_types` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fk_table` varchar(30) DEFAULT '',
`description` varchar(100) NOT NULL DEFAULT 'unknown',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `assignment_types`
--
LOCK TABLES `assignment_types` WRITE;
/*!40000 ALTER TABLE `assignment_types` DISABLE KEYS */;
INSERT INTO `assignment_types` VALUES (1,'testplan_tcversions','testcase_execution'),(2,'tcversions','testcase_review');
/*!40000 ALTER TABLE `assignment_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `attachments`
--
DROP TABLE IF EXISTS `attachments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attachments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fk_id` int(10) unsigned NOT NULL DEFAULT '0',
`fk_table` varchar(250) DEFAULT '',
`title` varchar(250) DEFAULT '',
`description` varchar(250) DEFAULT '',
`file_name` varchar(250) NOT NULL DEFAULT '',
`file_path` varchar(250) DEFAULT '',
`file_size` int(11) NOT NULL DEFAULT '0',
`file_type` varchar(250) NOT NULL DEFAULT '',
`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`content` longblob,
`compression_type` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `attachments_idx1` (`fk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `attachments`
--
LOCK TABLES `attachments` WRITE;
/*!40000 ALTER TABLE `attachments` DISABLE KEYS */;
/*!40000 ALTER TABLE `attachments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `builds`
--
DROP TABLE IF EXISTS `builds`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `builds` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`testplan_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(100) NOT NULL DEFAULT 'undefined',
`notes` text,
`active` tinyint(1) NOT NULL DEFAULT '1',
`is_open` tinyint(1) NOT NULL DEFAULT '1',
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`release_date` date DEFAULT NULL,
`closed_on_date` date DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`testplan_id`,`name`),
KEY `testplan_id` (`testplan_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Available builds';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `builds`
--
LOCK TABLES `builds` WRITE;
/*!40000 ALTER TABLE `builds` DISABLE KEYS */;
INSERT INTO `builds` VALUES (1,2,'1st Challenge','',1,1,NULL,'2023-09-20 18:03:47',NULL,NULL);
/*!40000 ALTER TABLE `builds` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cfield_build_design_values`
--
DROP TABLE IF EXISTS `cfield_build_design_values`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cfield_build_design_values` (
`field_id` int(10) NOT NULL DEFAULT '0',
`node_id` int(10) NOT NULL DEFAULT '0',
`value` varchar(4000) NOT NULL DEFAULT '',
PRIMARY KEY (`field_id`,`node_id`),
KEY `idx_cfield_build_design_values` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cfield_build_design_values`
--
LOCK TABLES `cfield_build_design_values` WRITE;
/*!40000 ALTER TABLE `cfield_build_design_values` DISABLE KEYS */;
/*!40000 ALTER TABLE `cfield_build_design_values` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cfield_design_values`
--
DROP TABLE IF EXISTS `cfield_design_values`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cfield_design_values` (
`field_id` int(10) NOT NULL DEFAULT '0',
`node_id` int(10) NOT NULL DEFAULT '0',
`value` varchar(4000) NOT NULL DEFAULT '',
PRIMARY KEY (`field_id`,`node_id`),
KEY `idx_cfield_design_values` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cfield_design_values`
--
LOCK TABLES `cfield_design_values` WRITE;
/*!40000 ALTER TABLE `cfield_design_values` DISABLE KEYS */;
/*!40000 ALTER TABLE `cfield_design_values` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cfield_execution_values`
--
DROP TABLE IF EXISTS `cfield_execution_values`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cfield_execution_values` (
`field_id` int(10) NOT NULL DEFAULT '0',
`execution_id` int(10) NOT NULL DEFAULT '0',
`testplan_id` int(10) NOT NULL DEFAULT '0',
`tcversion_id` int(10) NOT NULL DEFAULT '0',
`value` varchar(4000) NOT NULL DEFAULT '',
PRIMARY KEY (`field_id`,`execution_id`,`testplan_id`,`tcversion_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cfield_execution_values`
--
LOCK TABLES `cfield_execution_values` WRITE;
/*!40000 ALTER TABLE `cfield_execution_values` DISABLE KEYS */;
/*!40000 ALTER TABLE `cfield_execution_values` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cfield_node_types`
--
DROP TABLE IF EXISTS `cfield_node_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cfield_node_types` (
`field_id` int(10) NOT NULL DEFAULT '0',
`node_type_id` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`field_id`,`node_type_id`),
KEY `idx_custom_fields_assign` (`node_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cfield_node_types`
--
LOCK TABLES `cfield_node_types` WRITE;
/*!40000 ALTER TABLE `cfield_node_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `cfield_node_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cfield_testplan_design_values`
--
DROP TABLE IF EXISTS `cfield_testplan_design_values`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cfield_testplan_design_values` (
`field_id` int(10) NOT NULL DEFAULT '0',
`link_id` int(10) NOT NULL DEFAULT '0' COMMENT 'point to testplan_tcversion id',
`value` varchar(4000) NOT NULL DEFAULT '',
PRIMARY KEY (`field_id`,`link_id`),
KEY `idx_cfield_tplan_design_val` (`link_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cfield_testplan_design_values`
--
LOCK TABLES `cfield_testplan_design_values` WRITE;
/*!40000 ALTER TABLE `cfield_testplan_design_values` DISABLE KEYS */;
/*!40000 ALTER TABLE `cfield_testplan_design_values` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cfield_testprojects`
--
DROP TABLE IF EXISTS `cfield_testprojects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cfield_testprojects` (
`field_id` int(10) unsigned NOT NULL DEFAULT '0',
`testproject_id` int(10) unsigned NOT NULL DEFAULT '0',
`display_order` smallint(5) unsigned NOT NULL DEFAULT '1',
`location` smallint(5) unsigned NOT NULL DEFAULT '1',
`active` tinyint(1) NOT NULL DEFAULT '1',
`required` tinyint(1) NOT NULL DEFAULT '0',
`required_on_design` tinyint(1) NOT NULL DEFAULT '0',
`required_on_execution` tinyint(1) NOT NULL DEFAULT '0',
`monitorable` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`field_id`,`testproject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cfield_testprojects`
--
LOCK TABLES `cfield_testprojects` WRITE;
/*!40000 ALTER TABLE `cfield_testprojects` DISABLE KEYS */;
/*!40000 ALTER TABLE `cfield_testprojects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `custom_fields`
--
DROP TABLE IF EXISTS `custom_fields`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 `idx_custom_fields_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `custom_fields`
--
LOCK TABLES `custom_fields` WRITE;
/*!40000 ALTER TABLE `custom_fields` DISABLE KEYS */;
/*!40000 ALTER TABLE `custom_fields` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `db_version`
--
DROP TABLE IF EXISTS `db_version`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_version` (
`version` varchar(50) NOT NULL DEFAULT 'unknown',
`upgrade_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`notes` text,
PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_version`
--
LOCK TABLES `db_version` WRITE;
/*!40000 ALTER TABLE `db_version` DISABLE KEYS */;
INSERT INTO `db_version` VALUES ('DB 1.9.16','2023-09-20 18:02:05','TestLink 1.9.16 Moka Pot');
/*!40000 ALTER TABLE `db_version` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `events`
--
DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`transaction_id` int(10) unsigned NOT NULL DEFAULT '0',
`log_level` smallint(5) unsigned NOT NULL DEFAULT '0',
`source` varchar(45) DEFAULT NULL,
`description` text NOT NULL,
`fired_at` int(10) unsigned NOT NULL DEFAULT '0',
`activity` varchar(45) DEFAULT NULL,
`object_id` int(10) unsigned DEFAULT NULL,
`object_type` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `transaction_id` (`transaction_id`),
KEY `fired_at` (`fired_at`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `events`
--
LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
INSERT INTO `events` VALUES (1,1,32,'GUI','string \'mail\' is not localized for locale \'en_GB\' ',1695232930,'LOCALIZATION',0,NULL),(2,2,2,'GUI','E_WARNING\nsession_set_cookie_params(): Cannot change session cookie parameters when session is active - in /var/www/html/lib/functions/common.php - Line 279',1695232934,'PHP',0,NULL),(3,3,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 721',1695232934,'PHP',0,NULL),(4,3,16,'GUI','O:18:\"tlMetaStringHelper\":4:{s:5:\"label\";s:21:\"audit_login_succeeded\";s:6:\"params\";a:2:{i:0;s:5:\"admin\";i:1;s:10:\"172.25.0.1\";}s:13:\"bDontLocalize\";b:0;s:14:\"bDontFireEvent\";b:0;}',1695232934,'LOGIN',1,'users'),(5,4,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 318',1695232935,'PHP',0,NULL),(6,4,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 721',1695232935,'PHP',0,NULL),(7,5,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 318',1695232935,'PHP',0,NULL),(8,5,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 721',1695232935,'PHP',0,NULL),(9,5,2,'GUI','No project found: Assume a new installation and redirect to create it',1695232935,NULL,0,NULL),(10,6,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 318',1695232935,'PHP',0,NULL),(11,6,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 506',1695232935,'PHP',0,NULL),(12,7,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 318',1695232944,'PHP',0,NULL),(13,7,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 318',1695232944,'PHP',0,NULL),(14,7,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 318',1695232944,'PHP',0,NULL),(15,7,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testproject.class.php - Line 318',1695232944,'PHP',0,NULL),(16,7,16,'GUI','O:18:\"tlMetaStringHelper\":4:{s:5:\"label\";s:25:\"audit_testproject_created\";s:6:\"params\";a:1:{i:0;s:18:\"MyFirstTestproject\";}s:13:\"bDontLocalize\";b:0;s:14:\"bDontFireEvent\";b:0;}',1695232944,'CREATE',1,'testprojects'),(17,8,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/general/navBar.php - Line 51',1695232944,'PHP',0,NULL),(18,8,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/general/navBar.php - Line 64',1695232944,'PHP',0,NULL),(19,9,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/general/navBar.php - Line 51',1695232946,'PHP',0,NULL),(20,10,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/general/mainPage.php - Line 136',1695232946,'PHP',0,NULL),(21,11,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695232950,'PHP',0,NULL),(22,12,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695232958,'PHP',0,NULL),(23,12,16,'GUI','O:18:\"tlMetaStringHelper\":4:{s:5:\"label\";s:22:\"audit_testplan_created\";s:6:\"params\";a:2:{i:0;s:18:\"MyFirstTestproject\";i:1;s:8:\"TestPlan\";}s:13:\"bDontLocalize\";b:0;s:14:\"bDontFireEvent\";b:0;}',1695232958,'CREATED',2,'testplans'),(24,12,16,'GUI','O:18:\"tlMetaStringHelper\":4:{s:5:\"label\";s:32:\"audit_users_roles_added_testplan\";s:6:\"params\";a:3:{i:0;s:5:\"admin\";i:1;s:8:\"TestPlan\";i:2;s:5:\"admin\";}s:13:\"bDontLocalize\";b:0;s:14:\"bDontFireEvent\";b:0;}',1695232958,'ASSIGN',2,'testplans'),(25,13,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695232961,'PHP',0,NULL),(26,14,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695232965,'PHP',0,NULL),(27,14,16,'GUI','O:18:\"tlMetaStringHelper\":4:{s:5:\"label\";s:20:\"audit_testplan_saved\";s:6:\"params\";a:2:{i:0;s:18:\"MyFirstTestproject\";i:1;s:8:\"TestPlan\";}s:13:\"bDontLocalize\";b:0;s:14:\"bDontFireEvent\";b:0;}',1695232965,'SAVE',2,'testplans'),(28,15,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695232973,'PHP',0,NULL),(29,15,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695232973,'PHP',0,NULL),(30,16,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testplan.class.php - Line 4230',1695232973,'PHP',0,NULL),(31,17,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695232979,'PHP',0,NULL),(32,17,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695232979,'PHP',0,NULL),(33,18,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695232979,'PHP',0,NULL),(34,19,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695232980,'PHP',0,NULL),(35,20,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695232982,'PHP',0,NULL),(36,21,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695232991,'PHP',0,NULL),(37,21,2,'GUI','E_NOTICE\nUndefined property: stdClass::$tproject_id - in /var/www/html/gui/templates_c/058861b8a8726c31d078caeb077d33d0d9b2822d.file.containerNew.tpl.php - Line 185',1695232991,'PHP',0,NULL),(38,22,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695232992,'PHP',0,NULL),(39,22,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695232992,'PHP',0,NULL),(40,23,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695232997,'PHP',0,NULL),(41,23,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695232997,'PHP',0,NULL),(42,23,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695232997,'PHP',0,NULL),(43,24,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695232999,'PHP',0,NULL),(44,25,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695233010,'PHP',0,NULL),(45,25,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695233010,'PHP',0,NULL),(46,25,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695233010,'PHP',0,NULL),(47,25,2,'GUI','E_WARNING\nA non-numeric value encountered - in /var/www/html/lib/functions/tlUser.class.php - Line 298',1695233010,'PHP',0,NULL),(48,26,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695233010,'PHP',0,NULL),(49,26,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695233010,'PHP',0,NULL),(50,27,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695233013,'PHP',0,NULL),(51,27,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695233013,'PHP',0,NULL),(52,27,2,'GUI','E_WARNING\nA non-numeric value encountered - in /var/www/html/lib/functions/tlUser.class.php - Line 298',1695233013,'PHP',0,NULL),(53,28,16,'GUI','O:18:\"tlMetaStringHelper\":4:{s:5:\"label\";s:19:\"audit_build_created\";s:6:\"params\";a:3:{i:0;s:18:\"MyFirstTestproject\";i:1;s:8:\"TestPlan\";i:2;s:13:\"1st Challenge\";}s:13:\"bDontLocalize\";b:0;s:14:\"bDontFireEvent\";b:0;}',1695233027,'CREATE',1,'builds'),(54,29,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695233035,'PHP',0,NULL),(55,29,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testplan.class.php - Line 4230',1695233035,'PHP',0,NULL),(56,29,2,'GUI','E_NOTICE\nUndefined index: nindex - in /var/www/html/lib/functions/execTreeMenu.inc.php - Line 219',1695233035,'PHP',0,NULL),(57,29,2,'GUI','E_WARNING\nInvalid argument supplied for foreach() - in /var/www/html/lib/functions/execTreeMenu.inc.php - Line 223',1695233035,'PHP',0,NULL),(58,30,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/testplan.class.php - Line 4230',1695233041,'PHP',0,NULL),(59,31,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695233042,'PHP',0,NULL),(60,31,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695233042,'PHP',0,NULL),(61,32,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/plan/planAddTC.php - Line 137',1695233044,'PHP',0,NULL),(62,33,16,'GUI','O:18:\"tlMetaStringHelper\":4:{s:5:\"label\";s:26:\"audit_tc_added_to_testplan\";s:6:\"params\";a:3:{i:0;s:13:\"my-1 : Do it!\";i:1;s:1:\"1\";i:2;s:8:\"TestPlan\";}s:13:\"bDontLocalize\";b:0;s:14:\"bDontFireEvent\";b:0;}',1695233051,'ASSIGN',2,'testplans'),(63,33,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/plan/planAddTC.php - Line 137',1695233051,'PHP',0,NULL),(64,34,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695233052,'PHP',0,NULL),(65,34,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695233052,'PHP',0,NULL),(66,35,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695233058,'PHP',0,NULL),(67,36,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695233060,'PHP',0,NULL),(68,37,32,'GUI','string \'mail\' is not localized for locale \'en_GB\' ',1695233810,'LOCALIZATION',0,NULL),(69,38,2,'GUI','E_WARNING\nsession_set_cookie_params(): Cannot change session cookie parameters when session is active - in /var/www/html/lib/functions/common.php - Line 279',1695233813,'PHP',0,NULL),(70,39,16,'GUI','O:18:\"tlMetaStringHelper\":4:{s:5:\"label\";s:21:\"audit_login_succeeded\";s:6:\"params\";a:2:{i:0;s:5:\"admin\";i:1;s:10:\"172.29.0.1\";}s:13:\"bDontLocalize\";b:0;s:14:\"bDontFireEvent\";b:0;}',1695233813,'LOGIN',1,'users'),(71,40,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695233820,'PHP',0,NULL),(72,41,2,'GUI','E_NOTICE\nUndefined index: bulk_tester_div - in /var/www/html/lib/plan/tc_exec_assignment.php - Line 301',1695233825,'PHP',0,NULL),(73,41,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/plan/tc_exec_assignment.php - Line 301',1695233825,'PHP',0,NULL),(74,42,2,'GUI','E_NOTICE\nUndefined index: bulk_tester_div - in /var/www/html/lib/plan/tc_exec_assignment.php - Line 301',1695233826,'PHP',0,NULL),(75,42,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/plan/tc_exec_assignment.php - Line 301',1695233826,'PHP',0,NULL),(76,43,2,'GUI','E_NOTICE\nUndefined index: bulk_tester_div - in /var/www/html/lib/plan/tc_exec_assignment.php - Line 301',1695233826,'PHP',0,NULL),(77,43,2,'GUI','E_WARNING\ncount(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/plan/tc_exec_assignment.php - Line 301',1695233826,'PHP',0,NULL),(78,44,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695233840,'PHP',0,NULL),(79,45,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695233842,'PHP',0,NULL),(80,46,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695233870,'PHP',0,NULL),(81,47,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234463,'PHP',0,NULL),(82,48,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695234463,'PHP',0,NULL),(83,48,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695234463,'PHP',0,NULL),(84,49,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234465,'PHP',0,NULL),(85,49,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234465,'PHP',0,NULL),(86,49,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234465,'PHP',0,NULL),(87,50,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695234469,'PHP',0,NULL),(88,51,2,'GUI','E_WARNING\nsession_set_cookie_params(): Cannot change session cookie parameters when session is active - in /var/www/html/lib/functions/common.php - Line 279',1695234480,'PHP',0,NULL),(89,52,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695234481,'PHP',0,NULL),(90,52,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234481,'PHP',0,NULL),(91,52,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234481,'PHP',0,NULL),(92,52,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234481,'PHP',0,NULL),(93,53,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695234481,'PHP',0,NULL),(94,53,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695234481,'PHP',0,NULL),(95,54,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234483,'PHP',0,NULL),(96,55,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234484,'PHP',0,NULL),(97,55,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234484,'PHP',0,NULL),(98,55,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234484,'PHP',0,NULL),(99,56,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234485,'PHP',0,NULL),(100,56,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234485,'PHP',0,NULL),(101,56,2,'GUI','E_WARNING\nA non-numeric value encountered - in /var/www/html/lib/functions/tlUser.class.php - Line 298',1695234485,'PHP',0,NULL),(102,57,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695234491,'PHP',0,NULL),(103,58,2,'GUI','E_WARNING\nsession_set_cookie_params(): Cannot change session cookie parameters when session is active - in /var/www/html/lib/functions/common.php - Line 279',1695234501,'PHP',0,NULL),(104,59,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234501,'PHP',0,NULL),(105,59,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234501,'PHP',0,NULL),(106,59,2,'GUI','E_WARNING\nA non-numeric value encountered - in /var/www/html/lib/functions/tlUser.class.php - Line 298',1695234501,'PHP',0,NULL),(107,60,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695234502,'PHP',0,NULL),(108,60,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/object.class.php - Line 613',1695234502,'PHP',0,NULL),(109,61,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234510,'PHP',0,NULL),(110,61,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234510,'PHP',0,NULL),(111,61,2,'GUI','E_WARNING\nA non-numeric value encountered - in /var/www/html/lib/functions/tlUser.class.php - Line 298',1695234510,'PHP',0,NULL),(112,62,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695234516,'PHP',0,NULL),(113,63,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234520,'PHP',0,NULL),(114,64,2,'GUI','E_WARNING\nsizeof(): Parameter must be an array or an object that implements Countable - in /var/www/html/lib/functions/tlAttachmentRepository.class.php - Line 480',1695234882,'PHP',0,NULL),(115,65,32,'GUI','string \'mail\' is not localized for locale \'en_GB\' ',1695235621,'LOCALIZATION',0,NULL),(116,66,16,'GUI','O:18:\"tlMetaStringHelper\":4:{s:5:\"label\";s:21:\"audit_login_succeeded\";s:6:\"params\";a:2:{i:0;s:5:\"admin\";i:1;s:10:\"172.30.0.1\";}s:13:\"bDontLocalize\";b:0;s:14:\"bDontFireEvent\";b:0;}',1695235625,'LOGIN',1,'users'),(117,67,2,'GUI','E_WARNING\nfile_put_contents(/development/var/tracer.log): failed to open stream: No such file or directory - in /var/www/html/lib/functions/tlFilterControl.class.php - Line 268',1695235633,'PHP',0,NULL),(118,68,2,'GUI','E_WARNING\nCannot modify header information - headers already sent by (output started at /var/www/html/lib/execute/execSetResults.php:1533) - in /var/www/html/lib/execute/execSetResults.php - Line 832',1695235635,'PHP',0,NULL);
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `execution_bugs`
--
DROP TABLE IF EXISTS `execution_bugs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `execution_bugs` (
`execution_id` int(10) unsigned NOT NULL DEFAULT '0',
`bug_id` varchar(64) NOT NULL DEFAULT '0',
`tcstep_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`execution_id`,`bug_id`,`tcstep_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `execution_bugs`
--
LOCK TABLES `execution_bugs` WRITE;
/*!40000 ALTER TABLE `execution_bugs` DISABLE KEYS */;
/*!40000 ALTER TABLE `execution_bugs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `execution_tcsteps`
--
DROP TABLE IF EXISTS `execution_tcsteps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `execution_tcsteps` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`execution_id` int(10) unsigned NOT NULL DEFAULT '0',
`tcstep_id` int(10) unsigned NOT NULL DEFAULT '0',
`notes` text,
`status` char(1) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `execution_tcsteps_idx1` (`execution_id`,`tcstep_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `execution_tcsteps`
--
LOCK TABLES `execution_tcsteps` WRITE;
/*!40000 ALTER TABLE `execution_tcsteps` DISABLE KEYS */;
/*!40000 ALTER TABLE `execution_tcsteps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `executions`
--
DROP TABLE IF EXISTS `executions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `executions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`build_id` int(10) NOT NULL DEFAULT '0',
`tester_id` int(10) unsigned DEFAULT NULL,
`execution_ts` datetime DEFAULT NULL,
`status` char(1) DEFAULT NULL,
`testplan_id` int(10) unsigned NOT NULL DEFAULT '0',
`tcversion_id` int(10) unsigned NOT NULL DEFAULT '0',
`tcversion_number` smallint(5) unsigned NOT NULL DEFAULT '1',
`platform_id` int(10) unsigned NOT NULL DEFAULT '0',
`execution_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 -> manual, 2 -> automated',
`execution_duration` decimal(6,2) DEFAULT NULL COMMENT 'NULL will be considered as NO DATA Provided by user',
`notes` text,
PRIMARY KEY (`id`),
KEY `executions_idx1` (`testplan_id`,`tcversion_id`,`platform_id`,`build_id`),
KEY `executions_idx2` (`execution_type`),
KEY `executions_idx3` (`tcversion_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `executions`
--
LOCK TABLES `executions` WRITE;
/*!40000 ALTER TABLE `executions` DISABLE KEYS */;
/*!40000 ALTER TABLE `executions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `inventory`
--
DROP TABLE IF EXISTS `inventory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`testproject_id` int(10) unsigned NOT NULL,
`owner_id` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`ipaddress` varchar(255) NOT NULL,
`content` text,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modification_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `inventory_idx1` (`testproject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `inventory`
--
LOCK TABLES `inventory` WRITE;
/*!40000 ALTER TABLE `inventory` DISABLE KEYS */;
/*!40000 ALTER TABLE `inventory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `issuetrackers`
--
DROP TABLE IF EXISTS `issuetrackers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `issuetrackers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`type` int(10) DEFAULT '0',
`cfg` text,
PRIMARY KEY (`id`),
UNIQUE KEY `issuetrackers_uidx1` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `issuetrackers`
--
LOCK TABLES `issuetrackers` WRITE;
/*!40000 ALTER TABLE `issuetrackers` DISABLE KEYS */;
/*!40000 ALTER TABLE `issuetrackers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `keywords`
--
DROP TABLE IF EXISTS `keywords`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `keywords` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`keyword` varchar(100) NOT NULL DEFAULT '',
`testproject_id` int(10) unsigned NOT NULL DEFAULT '0',
`notes` text,
PRIMARY KEY (`id`),
KEY `testproject_id` (`testproject_id`),
KEY `keyword` (`keyword`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `keywords`
--
LOCK TABLES `keywords` WRITE;
/*!40000 ALTER TABLE `keywords` DISABLE KEYS */;
/*!40000 ALTER TABLE `keywords` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `milestones`
--
DROP TABLE IF EXISTS `milestones`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `milestones` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`testplan_id` int(10) unsigned NOT NULL DEFAULT '0',
`target_date` date DEFAULT NULL,
`start_date` date NOT NULL,
`a` tinyint(3) unsigned NOT NULL DEFAULT '0',
`b` tinyint(3) unsigned NOT NULL DEFAULT '0',
`c` tinyint(3) unsigned NOT NULL DEFAULT '0',
`name` varchar(100) NOT NULL DEFAULT 'undefined',
PRIMARY KEY (`id`),
UNIQUE KEY `name_testplan_id` (`name`,`testplan_id`),
KEY `testplan_id` (`testplan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `milestones`
--
LOCK TABLES `milestones` WRITE;
/*!40000 ALTER TABLE `milestones` DISABLE KEYS */;
/*!40000 ALTER TABLE `milestones` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `node_types`
--
DROP TABLE IF EXISTS `node_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `node_types` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`description` varchar(100) NOT NULL DEFAULT 'testproject',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `node_types`
--
LOCK TABLES `node_types` WRITE;
/*!40000 ALTER TABLE `node_types` DISABLE KEYS */;
INSERT INTO `node_types` VALUES (1,'testproject'),(2,'testsuite'),(3,'testcase'),(4,'testcase_version'),(5,'testplan'),(6,'requirement_spec'),(7,'requirement'),(8,'requirement_version'),(9,'testcase_step'),(10,'requirement_revision'),(11,'requirement_spec_revision'),(12,'build'),(13,'platform'),(14,'user');
/*!40000 ALTER TABLE `node_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nodes_hierarchy`
--
DROP TABLE IF EXISTS `nodes_hierarchy`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nodes_hierarchy` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`parent_id` int(10) unsigned DEFAULT NULL,
`node_type_id` int(10) unsigned NOT NULL DEFAULT '1',
`node_order` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `pid_m_nodeorder` (`parent_id`,`node_order`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nodes_hierarchy`
--
LOCK TABLES `nodes_hierarchy` WRITE;
/*!40000 ALTER TABLE `nodes_hierarchy` DISABLE KEYS */;
INSERT INTO `nodes_hierarchy` VALUES (1,'MyFirstTestproject',NULL,1,1),(2,'TestPlan',1,5,0),(3,'TryIt',1,2,1),(4,'Do it!',3,3,1000),(5,'',4,4,0);
/*!40000 ALTER TABLE `nodes_hierarchy` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `object_keywords`
--
DROP TABLE IF EXISTS `object_keywords`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `object_keywords` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fk_id` int(10) unsigned NOT NULL DEFAULT '0',
`fk_table` varchar(30) DEFAULT '',
`keyword_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `object_keywords`
--
LOCK TABLES `object_keywords` WRITE;
/*!40000 ALTER TABLE `object_keywords` DISABLE KEYS */;
/*!40000 ALTER TABLE `object_keywords` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `platforms`
--
DROP TABLE IF EXISTS `platforms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `platforms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`testproject_id` int(10) unsigned NOT NULL,
`notes` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_platforms` (`testproject_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `platforms`
--
LOCK TABLES `platforms` WRITE;
/*!40000 ALTER TABLE `platforms` DISABLE KEYS */;
/*!40000 ALTER TABLE `platforms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `plugins`
--
DROP TABLE IF EXISTS `plugins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plugins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`basename` varchar(100) NOT NULL,
`enabled` tinyint(1) NOT NULL DEFAULT '0',
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `plugins`
--
LOCK TABLES `plugins` WRITE;
/*!40000 ALTER TABLE `plugins` DISABLE KEYS */;
/*!40000 ALTER TABLE `plugins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `plugins_configuration`
--
DROP TABLE IF EXISTS `plugins_configuration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plugins_configuration` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`testproject_id` int(11) NOT NULL,
`config_key` varchar(255) NOT NULL,
`config_type` int(11) NOT NULL,
`config_value` varchar(255) NOT NULL,
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `plugins_configuration`
--
LOCK TABLES `plugins_configuration` WRITE;
/*!40000 ALTER TABLE `plugins_configuration` DISABLE KEYS */;
/*!40000 ALTER TABLE `plugins_configuration` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `req_coverage`
--
DROP TABLE IF EXISTS `req_coverage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `req_coverage` (
`req_id` int(10) NOT NULL,
`testcase_id` int(10) NOT NULL,
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`review_requester_id` int(10) unsigned DEFAULT NULL,
`review_request_ts` timestamp NULL DEFAULT NULL,
KEY `req_testcase` (`req_id`,`testcase_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='relation test case ** requirements';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `req_coverage`
--
LOCK TABLES `req_coverage` WRITE;
/*!40000 ALTER TABLE `req_coverage` DISABLE KEYS */;
/*!40000 ALTER TABLE `req_coverage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `req_monitor`
--
DROP TABLE IF EXISTS `req_monitor`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `req_monitor` (
`req_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`testproject_id` int(11) NOT NULL,
PRIMARY KEY (`req_id`,`user_id`,`testproject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `req_monitor`
--
LOCK TABLES `req_monitor` WRITE;
/*!40000 ALTER TABLE `req_monitor` DISABLE KEYS */;
/*!40000 ALTER TABLE `req_monitor` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `req_relations`
--
DROP TABLE IF EXISTS `req_relations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `req_relations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`source_id` int(10) unsigned NOT NULL,
`destination_id` int(10) unsigned NOT NULL,
`relation_type` smallint(5) unsigned NOT NULL DEFAULT '1',
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `req_relations`
--
LOCK TABLES `req_relations` WRITE;
/*!40000 ALTER TABLE `req_relations` DISABLE KEYS */;
/*!40000 ALTER TABLE `req_relations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `req_revisions`
--
DROP TABLE IF EXISTS `req_revisions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `req_revisions` (
`parent_id` int(10) unsigned NOT NULL,
`id` int(10) unsigned NOT NULL,
`revision` smallint(5) unsigned NOT NULL DEFAULT '1',
`req_doc_id` varchar(64) DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`scope` text,
`status` char(1) NOT NULL DEFAULT 'V',
`type` char(1) DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
`is_open` tinyint(1) NOT NULL DEFAULT '1',
`expected_coverage` int(10) NOT NULL DEFAULT '1',
`log_message` text,
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifier_id` int(10) unsigned DEFAULT NULL,
`modification_ts` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `req_revisions_uidx1` (`parent_id`,`revision`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `req_revisions`
--
LOCK TABLES `req_revisions` WRITE;
/*!40000 ALTER TABLE `req_revisions` DISABLE KEYS */;
/*!40000 ALTER TABLE `req_revisions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `req_specs`
--
DROP TABLE IF EXISTS `req_specs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `req_specs` (
`id` int(10) unsigned NOT NULL,
`testproject_id` int(10) unsigned NOT NULL,
`doc_id` varchar(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `req_spec_uk1` (`doc_id`,`testproject_id`),
KEY `testproject_id` (`testproject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Dev. Documents (e.g. System Requirements Specification)';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `req_specs`
--
LOCK TABLES `req_specs` WRITE;
/*!40000 ALTER TABLE `req_specs` DISABLE KEYS */;
/*!40000 ALTER TABLE `req_specs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `req_specs_revisions`
--
DROP TABLE IF EXISTS `req_specs_revisions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `req_specs_revisions` (
`parent_id` int(10) unsigned NOT NULL,
`id` int(10) unsigned NOT NULL,
`revision` smallint(5) unsigned NOT NULL DEFAULT '1',
`doc_id` varchar(64) DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`scope` text,
`total_req` int(10) NOT NULL DEFAULT '0',
`status` int(10) unsigned DEFAULT '1',
`type` char(1) DEFAULT NULL,
`log_message` text,
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifier_id` int(10) unsigned DEFAULT NULL,
`modification_ts` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `req_specs_revisions_uidx1` (`parent_id`,`revision`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `req_specs_revisions`
--
LOCK TABLES `req_specs_revisions` WRITE;
/*!40000 ALTER TABLE `req_specs_revisions` DISABLE KEYS */;
/*!40000 ALTER TABLE `req_specs_revisions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `req_versions`
--
DROP TABLE IF EXISTS `req_versions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `req_versions` (
`id` int(10) unsigned NOT NULL,
`version` smallint(5) unsigned NOT NULL DEFAULT '1',
`revision` smallint(5) unsigned NOT NULL DEFAULT '1',
`scope` text,
`status` char(1) NOT NULL DEFAULT 'V',
`type` char(1) DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
`is_open` tinyint(1) NOT NULL DEFAULT '1',
`expected_coverage` int(10) NOT NULL DEFAULT '1',
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifier_id` int(10) unsigned DEFAULT NULL,
`modification_ts` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`log_message` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `req_versions`
--
LOCK TABLES `req_versions` WRITE;
/*!40000 ALTER TABLE `req_versions` DISABLE KEYS */;
/*!40000 ALTER TABLE `req_versions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `reqmgrsystems`
--
DROP TABLE IF EXISTS `reqmgrsystems`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reqmgrsystems` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`type` int(10) DEFAULT '0',
`cfg` text,
PRIMARY KEY (`id`),
UNIQUE KEY `reqmgrsystems_uidx1` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `reqmgrsystems`
--
LOCK TABLES `reqmgrsystems` WRITE;
/*!40000 ALTER TABLE `reqmgrsystems` DISABLE KEYS */;
/*!40000 ALTER TABLE `reqmgrsystems` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `requirements`
--
DROP TABLE IF EXISTS `requirements`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `requirements` (
`id` int(10) unsigned NOT NULL,
`srs_id` int(10) unsigned NOT NULL,
`req_doc_id` varchar(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `requirements_req_doc_id` (`srs_id`,`req_doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `requirements`
--
LOCK TABLES `requirements` WRITE;
/*!40000 ALTER TABLE `requirements` DISABLE KEYS */;
/*!40000 ALTER TABLE `requirements` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rights`
--
DROP TABLE IF EXISTS `rights`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rights` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`description` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `rights_descr` (`description`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rights`
--
LOCK TABLES `rights` WRITE;
/*!40000 ALTER TABLE `rights` DISABLE KEYS */;
INSERT INTO `rights` VALUES (18,'cfield_management'),(17,'cfield_view'),(22,'events_mgt'),(36,'exec_delete'),(35,'exec_edit_notes'),(41,'exec_testcases_assigned_to_me'),(31,'issuetracker_management'),(32,'issuetracker_view'),(29,'keyword_assignment'),(9,'mgt_modify_key'),(12,'mgt_modify_product'),(11,'mgt_modify_req'),(7,'mgt_modify_tc'),(48,'mgt_plugins'),(16,'mgt_testplan_create'),(30,'mgt_unfreeze_req'),(13,'mgt_users'),(20,'mgt_view_events'),(8,'mgt_view_key'),(10,'mgt_view_req'),(6,'mgt_view_tc'),(21,'mgt_view_usergroups'),(24,'platform_management'),(25,'platform_view'),(26,'project_inventory_management'),(27,'project_inventory_view'),(33,'reqmgrsystem_management'),(34,'reqmgrsystem_view'),(28,'req_tcase_link_management'),(14,'role_management'),(19,'system_configuration'),(47,'testcase_freeze'),(43,'testplan_add_remove_platforms'),(2,'testplan_create_build'),(1,'testplan_execute'),(3,'testplan_metrics'),(40,'testplan_milestone_overview'),(4,'testplan_planning'),(45,'testplan_set_urgent_testcases'),(46,'testplan_show_testcases_newest_versions'),(37,'testplan_unlink_executed_testcases'),(44,'testplan_update_linked_testcase_versions'),(5,'testplan_user_role_assignment'),(38,'testproject_delete_executed_testcases'),(39,'testproject_edit_executed_testcases'),(42,'testproject_metrics_dashboard'),(23,'testproject_user_role_assignment'),(15,'user_role_assignment');
/*!40000 ALTER TABLE `rights` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `risk_assignments`
--
DROP TABLE IF EXISTS `risk_assignments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `risk_assignments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`testplan_id` int(10) unsigned NOT NULL DEFAULT '0',
`node_id` int(10) unsigned NOT NULL DEFAULT '0',
`risk` char(1) NOT NULL DEFAULT '2',
`importance` char(1) NOT NULL DEFAULT 'M',
PRIMARY KEY (`id`),
UNIQUE KEY `risk_assignments_tplan_node_id` (`testplan_id`,`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `risk_assignments`
--
LOCK TABLES `risk_assignments` WRITE;
/*!40000 ALTER TABLE `risk_assignments` DISABLE KEYS */;
/*!40000 ALTER TABLE `risk_assignments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role_rights`
--
DROP TABLE IF EXISTS `role_rights`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_rights` (
`role_id` int(10) NOT NULL DEFAULT '0',
`right_id` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`role_id`,`right_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role_rights`
--
LOCK TABLES `role_rights` WRITE;
/*!40000 ALTER TABLE `role_rights` DISABLE KEYS */;
INSERT INTO `role_rights` VALUES (4,3),(4,6),(4,7),(4,8),(4,9),(4,10),(4,11),(5,3),(5,6),(5,8),(6,1),(6,2),(6,3),(6,6),(6,7),(6,8),(6,9),(6,11),(6,25),(6,27),(7,1),(7,3),(7,6),(7,8),(8,1),(8,2),(8,3),(8,4),(8,5),(8,6),(8,7),(8,8),(8,9),(8,10),(8,11),(8,12),(8,13),(8,14),(8,15),(8,16),(8,17),(8,18),(8,19),(8,20),(8,21),(8,22),(8,23),(8,24),(8,25),(8,26),(8,27),(8,30),(8,31),(8,32),(8,33),(8,34),(8,35),(8,36),(8,37),(8,38),(8,39),(8,40),(8,41),(8,42),(8,43),(8,44),(8,45),(8,46),(8,47),(8,48),(9,1),(9,2),(9,3),(9,4),(9,5),(9,6),(9,7),(9,8),(9,9),(9,10),(9,11),(9,15),(9,16),(9,24),(9,25),(9,26),(9,27),(9,47);
/*!40000 ALTER TABLE `role_rights` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`description` varchar(100) NOT NULL DEFAULT '',
`notes` text,
PRIMARY KEY (`id`),
UNIQUE KEY `role_rights_roles_descr` (`description`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roles`
--
LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'<reserved system role 1>',NULL),(2,'<reserved system role 2>',NULL),(3,'<no rights>',NULL),(4,'test designer',NULL),(5,'guest',NULL),(6,'senior tester',NULL),(7,'tester',NULL),(8,'admin',NULL),(9,'leader',NULL);
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tcsteps`
--
DROP TABLE IF EXISTS `tcsteps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tcsteps` (
`id` int(10) unsigned NOT NULL,
`step_number` int(11) NOT NULL DEFAULT '1',
`actions` text,
`expected_results` text,
`active` tinyint(1) NOT NULL DEFAULT '1',
`execution_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 -> manual, 2 -> automated',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tcsteps`
--
LOCK TABLES `tcsteps` WRITE;
/*!40000 ALTER TABLE `tcsteps` DISABLE KEYS */;
/*!40000 ALTER TABLE `tcsteps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tcversions`
--
DROP TABLE IF EXISTS `tcversions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tcversions` (
`id` int(10) unsigned NOT NULL,
`tc_external_id` int(10) unsigned DEFAULT NULL,
`version` smallint(5) unsigned NOT NULL DEFAULT '1',
`layout` smallint(5) unsigned NOT NULL DEFAULT '1',
`status` smallint(5) unsigned NOT NULL DEFAULT '1',
`summary` text,
`preconditions` text,
`importance` smallint(5) unsigned NOT NULL DEFAULT '2',
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updater_id` int(10) unsigned DEFAULT NULL,
`modification_ts` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`active` tinyint(1) NOT NULL DEFAULT '1',
`is_open` tinyint(1) NOT NULL DEFAULT '1',
`execution_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 -> manual, 2 -> automated',
`estimated_exec_duration` decimal(6,2) DEFAULT NULL COMMENT 'NULL will be considered as NO DATA Provided by user',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tcversions`
--
LOCK TABLES `tcversions` WRITE;
/*!40000 ALTER TABLE `tcversions` DISABLE KEYS */;
INSERT INTO `tcversions` VALUES (5,1,1,1,1,'<p>Moi</p>\r\n','<p>can</p>\r\n',2,1,'2023-09-20 18:03:30',1,'2023-09-20 18:28:21',1,1,1,NULL);
/*!40000 ALTER TABLE `tcversions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `testcase_keywords`
--
DROP TABLE IF EXISTS `testcase_keywords`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testcase_keywords` (
`testcase_id` int(10) unsigned NOT NULL DEFAULT '0',
`keyword_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`testcase_id`,`keyword_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `testcase_keywords`
--
LOCK TABLES `testcase_keywords` WRITE;
/*!40000 ALTER TABLE `testcase_keywords` DISABLE KEYS */;
/*!40000 ALTER TABLE `testcase_keywords` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `testcase_relations`
--
DROP TABLE IF EXISTS `testcase_relations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testcase_relations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`source_id` int(10) unsigned NOT NULL,
`destination_id` int(10) unsigned NOT NULL,
`relation_type` smallint(5) unsigned NOT NULL DEFAULT '1',
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `testcase_relations`
--
LOCK TABLES `testcase_relations` WRITE;
/*!40000 ALTER TABLE `testcase_relations` DISABLE KEYS */;
/*!40000 ALTER TABLE `testcase_relations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `testplan_platforms`
--
DROP TABLE IF EXISTS `testplan_platforms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testplan_platforms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`testplan_id` int(10) unsigned NOT NULL,
`platform_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_testplan_platforms` (`testplan_id`,`platform_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connects a testplan with platforms';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `testplan_platforms`
--
LOCK TABLES `testplan_platforms` WRITE;
/*!40000 ALTER TABLE `testplan_platforms` DISABLE KEYS */;
/*!40000 ALTER TABLE `testplan_platforms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `testplan_tcversions`
--
DROP TABLE IF EXISTS `testplan_tcversions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testplan_tcversions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`testplan_id` int(10) unsigned NOT NULL DEFAULT '0',
`tcversion_id` int(10) unsigned NOT NULL DEFAULT '0',
`node_order` int(10) unsigned NOT NULL DEFAULT '1',
`urgency` smallint(5) NOT NULL DEFAULT '2',
`platform_id` int(10) unsigned NOT NULL DEFAULT '0',
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `testplan_tcversions_tplan_tcversion` (`testplan_id`,`tcversion_id`,`platform_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `testplan_tcversions`
--
LOCK TABLES `testplan_tcversions` WRITE;
/*!40000 ALTER TABLE `testplan_tcversions` DISABLE KEYS */;
INSERT INTO `testplan_tcversions` VALUES (1,2,5,10000,2,0,1,'2023-09-20 18:04:11');
/*!40000 ALTER TABLE `testplan_tcversions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `testplans`
--
DROP TABLE IF EXISTS `testplans`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testplans` (
`id` int(10) unsigned NOT NULL,
`testproject_id` int(10) unsigned NOT NULL DEFAULT '0',
`notes` text,
`active` tinyint(1) NOT NULL DEFAULT '1',
`is_open` tinyint(1) NOT NULL DEFAULT '1',
`is_public` tinyint(1) NOT NULL DEFAULT '1',
`api_key` varchar(64) NOT NULL DEFAULT '829a2ded3ed0829a2dedd8ab81dfa2c77e8235bc3ed0d8ab81dfa2c77e8235bc',
PRIMARY KEY (`id`),
UNIQUE KEY `testplans_api_key` (`api_key`),
KEY `testplans_testproject_id_active` (`testproject_id`,`active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `testplans`
--
LOCK TABLES `testplans` WRITE;
/*!40000 ALTER TABLE `testplans` DISABLE KEYS */;
INSERT INTO `testplans` VALUES (2,1,'',1,1,1,'21fe672f005a3ba8fa1015ee2990f588677a6ba7b49bab765fa0fb3984ecc30f');
/*!40000 ALTER TABLE `testplans` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `testproject_issuetracker`
--
DROP TABLE IF EXISTS `testproject_issuetracker`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testproject_issuetracker` (
`testproject_id` int(10) unsigned NOT NULL,
`issuetracker_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`testproject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `testproject_issuetracker`
--
LOCK TABLES `testproject_issuetracker` WRITE;
/*!40000 ALTER TABLE `testproject_issuetracker` DISABLE KEYS */;
/*!40000 ALTER TABLE `testproject_issuetracker` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `testproject_reqmgrsystem`
--
DROP TABLE IF EXISTS `testproject_reqmgrsystem`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testproject_reqmgrsystem` (
`testproject_id` int(10) unsigned NOT NULL,
`reqmgrsystem_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`testproject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `testproject_reqmgrsystem`
--
LOCK TABLES `testproject_reqmgrsystem` WRITE;
/*!40000 ALTER TABLE `testproject_reqmgrsystem` DISABLE KEYS */;
/*!40000 ALTER TABLE `testproject_reqmgrsystem` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `testprojects`
--
DROP TABLE IF EXISTS `testprojects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testprojects` (
`id` int(10) unsigned NOT NULL,
`notes` text,
`color` varchar(12) NOT NULL DEFAULT '#9BD',
`active` tinyint(1) NOT NULL DEFAULT '1',
`option_reqs` tinyint(1) NOT NULL DEFAULT '0',
`option_priority` tinyint(1) NOT NULL DEFAULT '0',
`option_automation` tinyint(1) NOT NULL DEFAULT '0',
`options` text,
`prefix` varchar(16) NOT NULL,
`tc_counter` int(10) unsigned NOT NULL DEFAULT '0',
`is_public` tinyint(1) NOT NULL DEFAULT '1',
`issue_tracker_enabled` tinyint(1) NOT NULL DEFAULT '0',
`reqmgr_integration_enabled` tinyint(1) NOT NULL DEFAULT '0',
`api_key` varchar(64) NOT NULL DEFAULT '0d8ab81dfa2c77e8235bc829a2ded3edfa2c78235bc829a27eded3ed0d8ab81d',
PRIMARY KEY (`id`),
UNIQUE KEY `testprojects_prefix` (`prefix`),
UNIQUE KEY `testprojects_api_key` (`api_key`),
KEY `testprojects_id_active` (`id`,`active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `testprojects`
--
LOCK TABLES `testprojects` WRITE;
/*!40000 ALTER TABLE `testprojects` DISABLE KEYS */;
INSERT INTO `testprojects` VALUES (1,'','',1,0,0,0,'O:8:\"stdClass\":4:{s:19:\"requirementsEnabled\";i:0;s:19:\"testPriorityEnabled\";i:1;s:17:\"automationEnabled\";i:1;s:16:\"inventoryEnabled\";i:0;}','my',1,1,0,0,'a6c86327b747623125f68c2d0ecd68ce80b580e7e85026dc2b828fd3110f6b6d');
/*!40000 ALTER TABLE `testprojects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `testsuites`
--
DROP TABLE IF EXISTS `testsuites`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testsuites` (
`id` int(10) unsigned NOT NULL,
`details` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `testsuites`
--
LOCK TABLES `testsuites` WRITE;
/*!40000 ALTER TABLE `testsuites` DISABLE KEYS */;
INSERT INTO `testsuites` VALUES (3,'<p>Po</p>\r\n');
/*!40000 ALTER TABLE `testsuites` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `text_templates`
--
DROP TABLE IF EXISTS `text_templates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `text_templates` (
`id` int(10) unsigned NOT NULL,
`type` smallint(5) unsigned NOT NULL,
`title` varchar(100) NOT NULL,
`template_data` text,
`author_id` int(10) unsigned DEFAULT NULL,
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`is_public` tinyint(1) NOT NULL DEFAULT '0',
UNIQUE KEY `idx_text_templates` (`type`,`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Global Project Templates';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `text_templates`
--
LOCK TABLES `text_templates` WRITE;
/*!40000 ALTER TABLE `text_templates` DISABLE KEYS */;
/*!40000 ALTER TABLE `text_templates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `transactions`
--
DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entry_point` varchar(45) NOT NULL DEFAULT '',
`start_time` int(10) unsigned NOT NULL DEFAULT '0',
`end_time` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`session_id` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `transactions`
--
LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
INSERT INTO `transactions` VALUES (1,'/login.php',1695232930,1695232930,0,NULL),(2,'/login.php',1695232934,1695232934,0,NULL),(3,'/login.php',1695232934,1695232934,1,'004a361f8a0603e019053694f3b219f2'),(4,'/lib/general/navBar.php',1695232935,1695232935,1,'004a361f8a0603e019053694f3b219f2'),(5,'/lib/general/mainPage.php',1695232935,1695232935,1,'004a361f8a0603e019053694f3b219f2'),(6,'/lib/project/projectEdit.php',1695232935,1695232936,1,'004a361f8a0603e019053694f3b219f2'),(7,'/lib/project/projectEdit.php',1695232944,1695232944,1,'004a361f8a0603e019053694f3b219f2'),(8,'/lib/general/navBar.php',1695232944,1695232944,1,'004a361f8a0603e019053694f3b219f2'),(9,'/lib/general/navBar.php',1695232946,1695232946,1,'004a361f8a0603e019053694f3b219f2'),(10,'/lib/general/mainPage.php',1695232946,1695232946,1,'004a361f8a0603e019053694f3b219f2'),(11,'/lib/plan/planEdit.php',1695232950,1695232950,1,'004a361f8a0603e019053694f3b219f2'),(12,'/lib/plan/planEdit.php',1695232958,1695232958,1,'004a361f8a0603e019053694f3b219f2'),(13,'/lib/plan/planEdit.php',1695232961,1695232961,1,'004a361f8a0603e019053694f3b219f2'),(14,'/lib/plan/planEdit.php',1695232965,1695232965,1,'004a361f8a0603e019053694f3b219f2'),(15,'/lib/plan/planAddTCNavigator.php',1695232973,1695232973,1,'004a361f8a0603e019053694f3b219f2'),(16,'/lib/results/printDocOptions.php',1695232973,1695232973,1,'004a361f8a0603e019053694f3b219f2'),(17,'/lib/testcases/listTestCases.php',1695232979,1695232979,1,'004a361f8a0603e019053694f3b219f2'),(18,'/lib/testcases/archiveData.php',1695232979,1695232979,1,'004a361f8a0603e019053694f3b219f2'),(19,'/lib/testcases/archiveData.php',1695232980,1695232980,1,'004a361f8a0603e019053694f3b219f2'),(20,'/lib/testcases/containerEdit.php',1695232982,1695232982,1,'004a361f8a0603e019053694f3b219f2'),(21,'/lib/testcases/containerEdit.php',1695232991,1695232991,1,'004a361f8a0603e019053694f3b219f2'),(22,'/lib/testcases/listTestCases.php',1695232992,1695232992,1,'004a361f8a0603e019053694f3b219f2'),(23,'/lib/testcases/archiveData.php',1695232997,1695232997,1,'004a361f8a0603e019053694f3b219f2'),(24,'/lib/testcases/tcEdit.php',1695232999,1695233000,1,'004a361f8a0603e019053694f3b219f2'),(25,'/lib/testcases/tcEdit.php',1695233010,1695233010,1,'004a361f8a0603e019053694f3b219f2'),(26,'/lib/testcases/listTestCases.php',1695233010,1695233010,1,'004a361f8a0603e019053694f3b219f2'),(27,'/lib/testcases/archiveData.php',1695233013,1695233013,1,'004a361f8a0603e019053694f3b219f2'),(28,'/lib/plan/buildEdit.php',1695233027,1695233027,1,'004a361f8a0603e019053694f3b219f2'),(29,'/lib/execute/execNavigator.php',1695233035,1695233035,1,'004a361f8a0603e019053694f3b219f2'),(30,'/lib/results/printDocOptions.php',1695233041,1695233041,1,'004a361f8a0603e019053694f3b219f2'),(31,'/lib/plan/planAddTCNavigator.php',1695233042,1695233042,1,'004a361f8a0603e019053694f3b219f2'),(32,'/lib/plan/planAddTC.php',1695233044,1695233044,1,'004a361f8a0603e019053694f3b219f2'),(33,'/lib/plan/planAddTC.php',1695233051,1695233051,1,'004a361f8a0603e019053694f3b219f2'),(34,'/lib/plan/planAddTCNavigator.php',1695233052,1695233052,1,'004a361f8a0603e019053694f3b219f2'),(35,'/lib/execute/execNavigator.php',1695233058,1695233058,1,'004a361f8a0603e019053694f3b219f2'),(36,'/lib/execute/execSetResults.php',1695233060,1695233060,1,'004a361f8a0603e019053694f3b219f2'),(37,'/login.php',1695233810,1695233810,0,NULL),(38,'/login.php',1695233813,1695233813,0,NULL),(39,'/login.php',1695233813,1695233813,1,'004a361f8a0603e019053694f3b219f2'),(40,'/lib/plan/planTCNavigator.php',1695233820,1695233820,1,'004a361f8a0603e019053694f3b219f2'),(41,'/lib/plan/tc_exec_assignment.php',1695233825,1695233825,1,'004a361f8a0603e019053694f3b219f2'),(42,'/lib/plan/tc_exec_assignment.php',1695233826,1695233826,1,'004a361f8a0603e019053694f3b219f2'),(43,'/lib/plan/tc_exec_assignment.php',1695233826,1695233826,1,'004a361f8a0603e019053694f3b219f2'),(44,'/lib/execute/execNavigator.php',1695233840,1695233840,1,'004a361f8a0603e019053694f3b219f2'),(45,'/lib/execute/execSetResults.php',1695233842,1695233842,1,'004a361f8a0603e019053694f3b219f2'),(46,'/lib/execute/execSetResults.php',1695233870,1695233870,1,'004a361f8a0603e019053694f3b219f2'),(47,'/lib/testcases/archiveData.php',1695234463,1695234463,1,'004a361f8a0603e019053694f3b219f2'),(48,'/lib/testcases/listTestCases.php',1695234463,1695234463,1,'004a361f8a0603e019053694f3b219f2'),(49,'/lib/testcases/archiveData.php',1695234465,1695234465,1,'004a361f8a0603e019053694f3b219f2'),(50,'/lib/testcases/containerEdit.php',1695234469,1695234469,1,'004a361f8a0603e019053694f3b219f2'),(51,'/login.php',1695234480,1695234480,1,'004a361f8a0603e019053694f3b219f2'),(52,'/lib/testcases/containerEdit.php',1695234481,1695234481,1,'004a361f8a0603e019053694f3b219f2'),(53,'/lib/testcases/listTestCases.php',1695234481,1695234481,1,'004a361f8a0603e019053694f3b219f2'),(54,'/lib/testcases/archiveData.php',1695234483,1695234483,1,'004a361f8a0603e019053694f3b219f2'),(55,'/lib/testcases/archiveData.php',1695234484,1695234484,1,'004a361f8a0603e019053694f3b219f2'),(56,'/lib/testcases/archiveData.php',1695234485,1695234485,1,'004a361f8a0603e019053694f3b219f2'),(57,'/lib/testcases/tcEdit.php',1695234491,1695234491,1,'004a361f8a0603e019053694f3b219f2'),(58,'/login.php',1695234501,1695234501,1,'004a361f8a0603e019053694f3b219f2'),(59,'/lib/testcases/tcEdit.php',1695234501,1695234501,1,'004a361f8a0603e019053694f3b219f2'),(60,'/lib/testcases/listTestCases.php',1695234502,1695234502,1,'004a361f8a0603e019053694f3b219f2'),(61,'/lib/testcases/archiveData.php',1695234510,1695234511,1,'004a361f8a0603e019053694f3b219f2'),(62,'/lib/execute/execNavigator.php',1695234516,1695234516,1,'004a361f8a0603e019053694f3b219f2'),(63,'/lib/execute/execSetResults.php',1695234520,1695234520,1,'004a361f8a0603e019053694f3b219f2'),(64,'/lib/execute/execSetResults.php',1695234882,1695234882,1,'004a361f8a0603e019053694f3b219f2'),(65,'/login.php',1695235621,1695235621,0,NULL),(66,'/login.php',1695235625,1695235625,1,'004a361f8a0603e019053694f3b219f2'),(67,'/lib/execute/execNavigator.php',1695235633,1695235633,1,'004a361f8a0603e019053694f3b219f2'),(68,'/lib/execute/execSetResults.php',1695235635,1695235635,1,'004a361f8a0603e019053694f3b219f2');
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_assignments`
--
DROP TABLE IF EXISTS `user_assignments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_assignments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` int(10) unsigned NOT NULL DEFAULT '1',
`feature_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned DEFAULT '0',
`build_id` int(10) unsigned DEFAULT '0',
`deadline_ts` datetime DEFAULT NULL,
`assigner_id` int(10) unsigned DEFAULT '0',
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` int(10) unsigned DEFAULT '1',
PRIMARY KEY (`id`),
KEY `user_assignments_feature_id` (`feature_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_assignments`
--
LOCK TABLES `user_assignments` WRITE;
/*!40000 ALTER TABLE `user_assignments` DISABLE KEYS */;
INSERT INTO `user_assignments` VALUES (1,1,1,1,1,NULL,1,'2023-09-20 18:17:14',1);
/*!40000 ALTER TABLE `user_assignments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_group`
--
DROP TABLE IF EXISTS `user_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_group` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`description` text,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_user_group` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_group`
--
LOCK TABLES `user_group` WRITE;
/*!40000 ALTER TABLE `user_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_group_assign`
--
DROP TABLE IF EXISTS `user_group_assign`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_group_assign` (
`usergroup_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
UNIQUE KEY `idx_user_group_assign` (`usergroup_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_group_assign`
--
LOCK TABLES `user_group_assign` WRITE;
/*!40000 ALTER TABLE `user_group_assign` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_group_assign` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_testplan_roles`
--
DROP TABLE IF EXISTS `user_testplan_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_testplan_roles` (
`user_id` int(10) NOT NULL DEFAULT '0',
`testplan_id` int(10) NOT NULL DEFAULT '0',
`role_id` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`,`testplan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_testplan_roles`
--
LOCK TABLES `user_testplan_roles` WRITE;
/*!40000 ALTER TABLE `user_testplan_roles` DISABLE KEYS */;
INSERT INTO `user_testplan_roles` VALUES (1,2,8);
/*!40000 ALTER TABLE `user_testplan_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_testproject_roles`
--
DROP TABLE IF EXISTS `user_testproject_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_testproject_roles` (
`user_id` int(10) NOT NULL DEFAULT '0',
`testproject_id` int(10) NOT NULL DEFAULT '0',
`role_id` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`,`testproject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_testproject_roles`
--
LOCK TABLES `user_testproject_roles` WRITE;
/*!40000 ALTER TABLE `user_testproject_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_testproject_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`login` varchar(100) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`role_id` int(10) unsigned NOT NULL DEFAULT '0',
`email` varchar(100) NOT NULL DEFAULT '',
`first` varchar(50) NOT NULL DEFAULT '',
`last` varchar(50) NOT NULL DEFAULT '',
`locale` varchar(10) NOT NULL DEFAULT 'en_GB',
`default_testproject_id` int(10) DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
`script_key` varchar(32) DEFAULT NULL,
`cookie_string` varchar(64) NOT NULL DEFAULT '',
`auth_method` varchar(10) DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `users_login` (`login`),
UNIQUE KEY `users_cookie_string` (`cookie_string`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='User information';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3',8,'','Testlink','Administrator','en_GB',NULL,1,NULL,'a2e9b9f96c991b6a5c585a4f4088556c21232f297a57a5a743894a0e4a801fc3','');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2023-09-20 18:52:51
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment