1<?php 2# --------------------------------------------------------------------- 3# rth is a requirement, test, and bugtracking system 4# Copyright (C) 2005 George Holbrook - rth@lists.sourceforge.net 5# This program is distributed under the terms and conditions of the GPL 6# See the README and LICENSE files for details 7#---------------------------------------------------------------------- 8# -------------------------------------------------- 9# RTH Configuration Data 10# $RCSfile: properties_inc.php,v $ $Revision: 1.40 $ 11# -------------------------------------------------- 12 13# ------------------------------------------- 14# This file contains all constants. 15# All variables in this file should be defined constants. 16# The file is broken up into several sections 17# 1) Environment Settings: 18# urls, path info, and database connection information 19# 2) Cookie Settings 20# 3) Configuration Settings: 21# debug, login, and optimization options, etc 22# 4) Database Constants: 23# Table Names for the RTH database 24# Field Names for the RTH database 25# Table Names for the RTH Project database 26# Field Names for the RTH Project database 27# 5) Error Codes 28# 6) Email config 29# ------------------------------------------- 30 31# ------------------------------------------- 32# Environment Information 33# ------------------------------------------- 34if ( isset($_SERVER['PHP_SELF']) && isset($_SERVER['HTTP_HOST']) ) { 35 36 $rth_path = split ('/', dirname($_SERVER['PHP_SELF'])); 37 38 39 if( strpos( $_SERVER['HTTP_HOST'], ":" ) ) { 40 41 $hostname_array = split( ":", $_SERVER['HTTP_HOST']); 42 $hostname = $hostname_array[0]; 43 $port_number = $hostname_array[1]; 44 45 $rth_url = 'http://' . $hostname .':'. $port_number .'/'. $rth_path[1] . '/'; 46 } 47 else { 48 $rth_url = 'http://' . $_SERVER['HTTP_HOST'] .'/'. $rth_path[1] . '/'; 49 } 50 51} else { 52 $rth_url = 'http://localhost/rth/' ; 53} 54 55define('RTH_URL', $rth_url); 56 57 58# Set the database type, host, db_name, and provide login information 59define('DB_TYPE', 'MySQL'); 60define('DB_HOST', 'localhost'); 61define('DB_NAME', 'rth'); 62define('DB_LOGIN', 'root'); 63define('DB_PWORD', ''); 64 65 66# FCK EDITOR 67define('FCK_EDITOR_BASEPATH', RTH_URL ."fckeditor/"); 68define('IMG_SRC', RTH_URL ."images/"); 69define('ICON_SRC', RTH_URL ."images/icons"); # Might not need icons 70define('DOC_ROOT', RTH_URL); # do not store documents in web server document root 71define('FILE_UPLOAD_PATH', './rth_file_upload/'); # include forwardslash at end of path 72define('WINDOW_TITLE', 'RTH - Quality Centre'); 73define('PAGE_TITLE', 'RTH'); 74define('RTH_VERSION', 'Version 1.7.0'); 75 76# ------------------------------------------- 77# Cookies 78# ------------------------------------------- 79define('USER_COOKIE_NAME','RTH_USER'); 80define('PWD_COOKIE_NAME','RTH_PWD'); 81define('COOKIE_PATH', '/'); # set this to something more restrictive if needed 82define('COOKIE_DOMAIN', ''); 83define('COOKIE_EXPIRE_LENGTH', 30000000); # time for cookie to live in seconds (1 year) 84define( 'ON', 1 ); 85define( 'OFF', 0 ); 86 87# ------------------------------------------- 88# Configuration Settings 89# ------------------------------------------- 90define('LOGIN_METHOD', 'MD5'); # Type of encryption used (MD5, PLAIN, LDAP) 91define('DEBUG', ON); # used to view debug info at the bottom of each page 92define('LOGGING', ON); # not currently used. 93define('USE_JAVASCRIPT', true); # Allow javascript features. 94define('USE_FCK_EDITOR', true); # View textarea as fck editor. Must have javascript enabled 95define('IMPORT_EXPORT_TO_EXCEL', true); # Set to false and all files will be imported and exported in csv format 96define('REMOTE_TEST_EXE', true); # Enable remote test execution 97define('NEWLINE', "\n"); # define the newline character for your OS 98define('IGNORE_VERSION_FILENAME_VALIDATION', true); # if it's set true, the validation that a new supporting doc version have to be equal to an older version, will be ignored 99 100 101#-------------------------------------------------------------------------- 102# Select the appropriate bug tracker 103# rth is the default bugtracker but you can also select mantis 104# support for bugzilla will follow 105#-------------------------------------------------------------------------- 106 107#-------------------------------------------------------------------------- 108# The urls for rth bug reporting 109# Make sure to comment out these lines if you're using mantis 110#-------------------------------------------------------------------------- 111define('BUGTRACKER', 'rth'); 112define('BUGTRACKER_URL', RTH_URL .'bug_page.php'); 113define('REPORT_BUG_URL', RTH_URL .'bug_add_page.php'); 114define('VIEW_BUG_URL', RTH_URL .'bug_detail_page.php'); 115 116 117#-------------------------------------------------------------------------- 118# The urls for mantis bug reporting 119# Set the REPORT_BUG_URL to either the advanced page or the simple view 120# depending on the default you prefer. 121#-------------------------------------------------------------------------- 122/* 123define('BUGTRACKER', 'mantis'); 124define('BUGTRACKER_URL', 'http://localhost/mantis/view_all_bug_page.php'); 125define('REPORT_BUG_URL', 'http://localhost/mantis/bug_report_advanced_page.php'); // bug_report_page.php 126define('VIEW_BUG_URL', 'http://localhost/mantis/view.php'); 127*/ 128 129#----------------------------------------------------------------------------------------- 130# FOR MORE ADVANCED MANTIS INTEGRATION FOLLOW THE DIRECTIONS BELOW 131# These instructions are based on version 1.0.5 of mantis 132# Take the code between the characters /* and */ and place it in the file listed 133# This integration will populate the rth database with the mantis bug_id when you create 134# a bug by clicking the "defect" link in the test execution section of rth. 135# This code will also redirect the user from mantis back to rth when the user created 136# a bug by clicking the "defect" link. 137#----------------------------------------------------------------------------------------- 138 139# Add the following lines to config_inc.php 140# This code will allow for a database connection from mantis to rth 141# We are assuming that the db type is the same for rth and mantis (MySQL by default) 142/* 143#----------------------------------------------------------------------------------------- 144# CODE FOR RTH - MANTIS INTEGRATION - config_inc.php 145#----------------------------------------------------------------------------------------- 146$g_rth_hostname = 'localhost'; 147$g_rth_database_name = 'rth'; 148$g_rth_db_username = 'root'; 149$g_rth_db_password = ''; 150$g_rth_url = 'http://localhost/rth/results_view_verifications_page.php'; 151*/ 152 153# Copy rth_api.php from the /rth/docs/mantis directory to the /mantis/core directory 154# This file will allow for a database connection to rth from within the mantis code. 155# Once the file is in the /mantis/core directory, add the following line to core.php 156# I added this code after line 105 of core.php 157/* 158#----------------------------------------------------------------------------------------- 159# CODE FOR RTH - MANTIS INTEGRATION - core.php 160#----------------------------------------------------------------------------------------- 161require_once( $t_core_path.'rth_api.php' ); 162*/ 163 164# Add the following lines to bug_report_advanced_page.php and bug_report_page.php 165# Place the lines in the <table> just below the <form> named "report_bug_form" 166# This is line 119 of bug_report_advanced_page.php and line 102 of bug_report_page.php 167# You will have to place the code in php tags. 168# I can't place the php tags in this file without breaking this file. 169/* 170#----------------------------------------------------------------------------------------- 171# CODE FOR RTH - MANTIS INTEGRATION - bug_report_advanced_page.php and bug_report_page.php 172#----------------------------------------------------------------------------------------- 173$test_run_id = $_GET['test_run_id']; 174$verify_id = $_GET['verify_id']; 175print"<input type='hidden' name='test_run_id' value='$test_run_id'/>"; 176print"<input type='hidden' name='verify_id' value='$verify_id'/>"; 177*/ 178 179# Now add the following lines to bug_report.php. 180# You will place these lines somewhere after the bug_create function on line 89. 181# The bug_id created by the bug_create function is necessary to populate the rth database with the bug_id. 182# I placed the code after helper_call_custom_function( 'issue_create_notify', array( $t_bug_id ) ); 183# on line 138 of bug_report.php. 184/* 185#----------------------------------------------------------------------------------------- 186# CODE FOR RTH INTEGRATION - bug_report.php 187#----------------------------------------------------------------------------------------- 188$test_run_id = $_POST['test_run_id']; 189$verify_id = $_POST['verify_id']; 190 191# Insert bug_id into rth database 192if( !is_blank($verify_id) ) { 193 194 $query = "UPDATE rth.verifyresults SET defect_id = '$t_bug_id' WHERE VerifyResultsID = '$verify_id'"; 195 rth_db_query( $query ); 196} 197*/ 198# You must also alter the logic on line 156 of bug_report.php 199# Change lines that read 200# if ( ! $f_report_stay ) { 201# html_meta_redirect( 'view_all_bug_page.php' ); 202# } 203# to the logic below. 204# Be sure to enter the correct url for your rth installation. 205/* 206#----------------------------------------------------------------------------------------- 207# CODE FOR RTH INTEGRATION - bug_report.php (approx. line 156) 208#----------------------------------------------------------------------------------------- 209# Redirect to mantis or rth. Redirect to rth if the verify_id variable is set. 210if ( ! $f_report_stay ) { 211 212 if( is_blank($verify_id) ) { 213 html_meta_redirect( 'view_all_bug_page.php' ); 214 } 215 else { 216 html_meta_redirect( config_get('rth_url') ); 217 } 218 } 219*/ 220 221# END OF MANTIS INTEGRATION= 222 223# ------------------------------------------- 224# LDAP Settings 225# ------------------------------------------- 226/* 227define('LDAP_SERVER', 'ldap://server_name/'); 228define('LDAP_PORT', '389'); 229define('LDAP_ID', 'uid=user_id,ou=people,o=in_your,o=org'); 230define('LDAP_PWD', 'password'); 231define('LDAP_DN', 'ou=people,o=in_your,o=org'); 232define('LDAP_PROTOCOL','3'); 233*/ 234 235 236# --- notice display --- 237# Control whether errors of level NOTICE, the lowest level of error, 238# are displayed to the user. Default is OFF, but turning it ON may 239# be useful while debugging. Leave this set to ON while we developing 240define('SHOW_WARNINGS', ON); 241 242# --- warning display --- 243# Control whether errors of level WARNING, the middle level of error, 244# are displayed to the user. Default is ON. Turning it OFF may 245# hide useful information from the user. 246define('SHOW_NOTICES', ON); 247 248# ------------------------------------------- 249# DEFINE EMAIL PROPERTIES 250# NOTE: Right now the system only works with SMTP. 251# You will have to supply a valid SMTP server name for email to work 252# We will eventually implement something that allows for different mail protocols. 253# ------------------------------------------- 254define('ADMIN_EMAIL', 'rth.admin@yourdomain.com'); 255define('SEND_EMAIL_NOTIFICATION', true); 256define('SMTP_HOST', 'localhost'); 257define('SMTP_USERNAME', ''); 258define('SMTP_PASSWORD', ''); 259 260# ------------------------------------------- 261# EMAIL CONFIG FOR BUGS 262# The email in the bug section relies on the bugmonitor table and user preferences. 263# The array below determines whether a user is added to the bug_monitor table on certain actions. 264# This allows the system administrator to determine whether they want email on specific actions in the bug section 265# For instance, by setting 'reporter' = true, whoever reported the bug will appear in the bug_monitor table. 266# This does not mean that the user will receive an email on an update to the bug, but that the system 267# will look at the users preferences (email on new, email on update, etc) to determine if the user should 268# receive an email. These are high level preferences which determine what actions will cause the bugmonitor 269# table to be populated. 270# The email routine works as follows. 271# 1. user creates or updates a bug 272# 2. the system looks at the particular action taken (did the user update the bug, add a bugnote, etc) 273# and the array below to determine whether to add a user to the bugmonitor table. 274# reporter = bug is reported and the logged in user is added to the bug_monitor table 275# assigned_to = bug is assigned to a user and that user is added to the bug_monitor table 276# bugnote = user who adds a bugnote is added to the bug_monitor table 277# status = user who changes the bug status is added to the bug_monitor table 278# update = user who makes a general update to the ticket is added to the bug_monitor table 279# 3. The system scans the bug_monitor table for users 280# 4. The system scans the users preferences to see if they want email for that particular action. 281# NOTE: You may wonder why we add users to tbe bug_monitor table if their prefs say they don't want email 282# for a particular action. We do this in case the user later changes their email prefs. If the user 283# is in the bug_monitor table, they can change their email preferencs and immediately start getting notifications. 284# 5. The system removes the logged in user from the list of email recipients if BUG_EMAIL_ON_OWN_ACTIONS = false 285# 6. The system sends the email 286# ---------------------------------------------- 287$default_notify_flags = array('reporter' => true, # true = add the reporter to the bug_monitor table. 288 'assigned_to' => true, # true = add user who was assigned to the ticket 289 'bugnote' => true, # true = add user who added a bugnote 290 'status' => true, # true = add user who changed status to bug_monitor table 291 'update' => true ); # true = add user when they update any other field on the ticket 292 293 294# Whether user's should receive emails for their own actions in the bug section 295define('BUG_EMAIL_ON_OWN_ACTIONS', true); 296 297 298 299# used for alternate row colors on tables 300define('ROW1_STYLE', 'row-1'); 301define('ROW2_STYLE', 'row-2'); 302 303# ------------------------------------------- 304# Permissions 305# ------------------------------------------- 306define('ANYBODY', 0); 307define('USER', 10); 308define('DEVELOPER', 20); 309define('MANAGER', 30); 310define('ADMIN', 40); 311define('NOBODY', 100); 312 313# ------------------------------------------- 314# DEFINE RECORDS PER PAGE 315# ------------------------------------------- 316define('RECORDS_PER_PAGE_TESTSET_ADD', 100); 317define('RECORDS_PER_PAGE_TESTSET_COPY', 100); 318define('RECORDS_PER_PAGE_TESTSET_EDIT', 100); 319define('RECORDS_PER_PAGE_TEST_REQ_ASSOC', 100); 320define('RECORDS_PER_PAGE_PROJECT_EDIT_USERS', 100); 321define('RECORDS_PER_PAGE_PROJECT_MANAGE_AREAS', 25); 322define('RECORDS_PER_PAGE_PROJECT_MANAGE_ENVIRONMENTS', 25); 323define('RECORDS_PER_PAGE_PROJECT_MANAGE_MACHINES', 25); 324define('RECORDS_PER_PAGE_PROJECT_MANAGE_REQ_AREA_COVERED', 25); 325define('RECORDS_PER_PAGE_PROJECT_MANAGE_REQ_DOC_TYPE', 25); 326define('RECORDS_PER_PAGE_PROJECT_MANAGE_REQ_FUNCT', 25); 327define('RECORDS_PER_PAGE_PROJECT_MANAGE_TESTTYPE', 25); 328define('RECORDS_PER_PAGE_PROJECT_MANAGE_TEST_DOC_TYPE', 25); 329define('RECORDS_PER_PAGE_PROJECT_MANAGE_USERS', 25); 330define('RECORDS_PER_PAGE_REPORT_FAILED_VERIFIS', 100); 331define('RECORDS_PER_PAGE_REQUIREMENTS', 25); 332define('RECORDS_PER_PAGE_REQUIREMENT_NOTIFICATIONS', 100); 333define('RECORDS_PER_PAGE_TEST_STEPS', 50); 334define('RECORDS_PER_PAGE_ARCHIVE_TESTS', 25); 335define('RECORDS_PER_PAGE_PROJECT_MANAGE_BUG_CATEGORY', 25); 336define('RECORDS_PER_PAGE_PROJECT_MANAGE_BUG_COMPONENT', 25); 337define('RECORDS_PER_PAGE_100', 100); 338define('RECORDS_PER_PAGE_25', 25); 339 340 341# ------------------------------------------- 342# DEFINE TABLES IN TEMPEST DATABASE 343# ------------------------------------------- 344define('AREA_TESTED_TBL', 'testarea'); 345define('BUILD_TBL', 'build'); 346define('BUG_TBL', 'bug'); 347define('BUG_ASSOC_TBL', 'bugassoc'); 348define('BUG_CATEGORY_TBL', 'bugcategory'); 349define('BUG_COMPONENT_TBL', 'bugcomponent'); 350define('BUG_FILE_TBL', 'bugfile'); 351define('BUG_HISTORY_TBL', 'bughistory'); 352define('BUG_MONITOR_TBL', 'bugmonitor'); 353define('BUG_NOTE_TBL', 'bugnote'); 354#define('BUG_TEST_ASSOC_TBL', 'BugTestAssoc'); 355define('DISC_TBL', 'discussion'); 356define('DISC_POST_TBL', 'discussionpost'); 357define('ENVIRONMENT_TBL', 'testenvironment'); # needed??? 358define('FEEDBACK_TBL', 'feedback'); 359define('FIELD_TBL', 'field_tbl'); 360define('FUNCTION_TBL', 'function_tbl'); 361define('GUI_CHECK_TBL', 'guichecktable'); 362define('INDIV_RUN_DOCS_TBL', 'individualrundocs'); 363define('ISSUES_TBL', 'issues'); 364define('LOGS_TBL', 'logs'); 365define('MACH_TBL', 'testmachine'); # needed??? 366define('MAN_DOC_TYPE_TBL', 'manualdoctype'); 367define('MAN_TD_TBL', 'manualtestdocs'); 368define('MAN_TD_VER_TBL', 'manualtestdocs_version'); 369define('NEWS_TBL', 'news'); 370define('RELEASE_TBL', 'release_tbl'); 371define('REQ_TBL', 'requirement'); 372define('REQ_AREA_COVERAGE_TBL', 'requirementareacoverage'); 373define('REQ_DOC_TYPE_TBL', 'requirementdocumenttype'); 374define('REQ_FUNCT_TBL', 'requirementfunctionality'); 375define('REQ_FUNCT_ASSOC_TBL', 'requirementfunctionality_assoc'); 376define('REQ_NOTIFY_TBL', 'requirementnotifications'); 377define('REQ_VERS_TBL', 'requirementversion'); 378define('REQ_VERS_ASSOC_REL', 'requirementversion_release_assoc'); 379define('PROJECT_TBL', 'project'); 380define('PROJECT_USER_ASSOC_TBL', 'project_user_assoc'); 381define('RESET_PASS_TBL', 'reset_password'); 382define('SCREEN_TBL', 'screen'); 383define('STEP_TBL', 'step_tbl'); 384define('TEST_PLAN', 'testplan'); 385define('TEST_PLAN_VERSION', 'testplanversion'); 386define('TS_TBL', 'testset'); 387define('TEST_TS_ASSOC_TBL', 'testset_testsuite_assoc'); 388define('TEST_STATUS_TBL', 'teststatus'); 389define('TEST_STEP_TBL', 'teststep'); 390define('TEST_TBL', 'testsuite'); 391define('TEST_FUNC_ASSOC_TBL', 'test_func_assoc'); 392define('TEST_REQ_ASSOC_TBL', 'testsuite_requirement_assoc'); 393define('TEST_RESULTS_TBL', 'testsuiteresults'); 394define('TEST_TYPE_TBL', 'testtype'); 395define('TEST_VERS_TBL', 'testversion'); 396define('TEST_WORK_FLOW_TBL', 'testworkflow'); 397define('USER_TBL', 'user' ); 398define('VERIFY_RESULTS_TBL', 'verifyresults'); 399#define('TEST_CASE_RESULTS_TBL', 'testcaseresults'); # not needed 400 401 402# ------------------------------------------- 403# DEFINE FIELDS IN TEMPEST DATABASE 404# ------------------------------------------- 405 406define('PROJECT_ID', 'project_id'); # exists in every table 407 408# ------------------------------------------- 409# AREA_TESTED TABLE - FIELDS 410# ------------------------------------------- 411define('AREA_TESTED_ID', 'AreaTestedID'); 412define('AREA_TESTED_PROJ_ID', 'project_id'); 413define('AREA_TESTED_NAME', 'AreaTestedName'); 414 415# ------------------------------------------- 416# BUILD TABLE - FIELDS 417# ------------------------------------------- 418define('BUILD_ID', "BuildID"); 419define('BUILD_REL_ID', "ReleaseID"); 420define('BUILD_NAME', "BuildName"); 421define('BUILD_DATE_REC', "DateReceived"); 422define('BUILD_ARCHIVE', "Archive"); 423define('BUILD_DESCRIPTION', 'Description'); 424 425# ------------------------------------------- 426# DISC TABLE - FIELDS 427# ------------------------------------------- 428define('DISC_ID', 'DiscussionID'); 429define('DISC_REQ_ID', 'ReqID'); 430define('DISC_DISCUSSION', 'Discussion'); 431define('DISC_STATUS', 'Status'); 432define('DISC_SUBJECT', 'DiscSubject'); 433define('DISC_AUTHOR', 'Author'); 434define('DISC_ASSIGN_TO', 'AssignTo'); 435define('DISC_DATE', 'Date'); 436 437 438# ------------------------------------------- 439# POST TABLE - FIELDS 440# ------------------------------------------- 441define('POST_ID', 'PostID'); 442define('POST_DISCUSSION_ID', 'DiscussionID'); 443define('POST_MESSAGE', 'Post'); 444define('POST_AUTHOR', 'Author'); 445define('POST_DATE', 'Date'); 446 447# ------------------------------------------- 448# ENVIRONMENT TABLE - FIELDS 449# ------------------------------------------- 450define('ENVIRONMENT_ID', 'EnvironmentID'); 451define('ENVIRONMENT_NAME', 'EnvironmentName'); 452define('ENVIRONMENT_PROJ_ID', 'ProjectID'); 453 454# ------------------------------------------- 455# FEEDBACK TABLE - FIELDS 456# ------------------------------------------- 457define('FEEDBACK_FEEDBACK_ID', 'FeedbackID'); 458define('FEEDBACK_AUTHOR', 'Author'); 459define('FEEDBACK_COMMENT', 'Comment'); 460define('FEEDBACK_PROJECT', 'Project'); 461define('FEEDBACK_TIMESTAMP', 'TimeStamp'); 462 463# ------------------------------------------- 464# FIELD TABLE - FIELDS 465# ------------------------------------------- 466define('FIELD_ID', 'field_id'); 467define('FIELD_SCREEN_ID', 'screen_id'); 468define('FIELD_ORDER', 'field_order'); 469define('FIELD_NAME', 'field_name'); 470define('FIELD_DESC', 'field_desc'); 471define('FIELD_TEXT_ONLY', 'text_only'); 472 473# ------------------------------------------- 474# FUNCTION TABLE - FIELDS 475# ------------------------------------------- 476define('FUNCTION_ID', 'function_id'); 477define('FUNCTION_NAME', 'function_name'); 478define('FUNCTION_DATE_CREATED', 'date_created'); 479define('FUNCTION_LAST_UPDATED', 'last_updated'); 480define('FUNCTION_LAST_UPDATED_BY', 'last_updated_by'); 481define('FUNCTION_DESC', 'description'); 482 483# ------------------------------------------- 484# GUI_CHECK TABLE - FIELDS 485# ------------------------------------------- 486define('GUI_CHECK_ID', 'GuiCheckID'); 487define('GUI_CHECK_NUMBER', 'GuiCheckNumber'); 488define('GUI_CHECK_ICON_CODE', 'IconCode'); 489define('GUI_CHECK_TS_UNIQUE_RUN_ID', 'TS_UniqueRunID'); 490define('GUI_CHECK_OBJECT_NAME', 'ObjectName'); 491define('GUI_CHECK_EXPECTED_VALUE', 'ExpectedValue'); 492define('GUI_CHECK_ACTUAL_VALUE', 'ActualValue'); 493define('GUI_CHECK_STATUS', 'Status'); 494 495# ------------------------------------------- 496# INDIV_RUN_DOCS TABLE - FIELDS 497# ------------------------------------------- 498define('INDIV_RUN_DOCS_UNIQUE_ID', 'UniqueDocID'); 499define('INDIV_RUN_DOCS_TS_UNIQUE_RUN_ID', 'TS_UniqueRunID'); 500define('INDIV_RUN_DOCS_TIMESTAMP', 'TimeStamp'); 501define('INDIV_RUN_DOCS_UPLOADED_BY', 'UploadedBy'); 502define('INDIV_RUN_DOCS_FILE_NAME', 'FileName'); 503define('INDIV_RUN_DOCS_DISPLAY_NAME', 'DisplayName'); 504define('INDIV_RUN_DOCS_COMMENTS', 'Comments'); 505define('INDIV_RUN_DOCS_LINK', 'Link'); 506 507# ------------------------------------------- 508# ISSUES TABLE - FIELDS 509# ------------------------------------------- 510define('ISSUES_ID', 'id'); 511define('ISSUES_NAME', 'Name'); 512define('ISSUES_PRIORITY', 'Priority'); 513define('ISSUES_STATUS', 'Status'); 514define('ISSUES_DETAILS', 'Details'); 515define('ISSUES_OWNER', 'Owner'); 516define('ISSUES_TIMESTAMP', 'Timestamp'); 517define('ISSUES_TYPE', 'Type'); 518 519# ------------------------------------------- 520# LOGS TABLE - FIELDS 521# ------------------------------------------- 522define('LOGS_LOG_ID', 'LogID'); 523define('LOGS_SESSION_ID', 'SessionID'); 524define('LOGS_DELETION', 'Deletion'); 525define('LOGS_CREATION', 'Creation'); 526define('LOGS_UPLOAD', 'Upload'); 527define('LOGS_TIMESTAMP', 'TimeStamp'); 528define('LOGS_USER', 'User'); 529define('LOGS_PAGE', 'Page'); 530define('LOGS_ACTION', 'Action'); 531 532# ------------------------------------------- 533# MACH_TABLE - FIELDS 534# ------------------------------------------- 535define('MACH_ID', 'MachineID'); 536define('MACH_PROJ_ID', 'ProjectID'); 537define('MACH_NAME', 'MachineName'); 538define('MACH_LOCATION', 'MachineLocation'); 539define('MACH_IP_ADDRESS', 'MachineIPAddress'); 540 541# ------------------------------------------- 542# MAN_DOC_TYPE TABLE - FIELDS 543# ------------------------------------------- 544define('MAN_DOC_TYPE_ID', 'ManualDocTypeID'); 545define('MAN_DOC_TYPE_NAME', 'ManualDocTypeName'); 546define('MAN_DOC_TYPE_PROJ_ID', 'ProjectID'); 547 548# ------------------------------------------- 549# MAN_TD_TBL TABLE - FIELDS 550# ------------------------------------------- 551define('MAN_TD_MANUAL_TEST_ID', 'ManualTestID'); 552define('MAN_TD_TEST_ID', 'TestID'); 553define('MAN_TD_DISPLAY_NAME', 'DisplayName'); 554 555# ------------------------------------------- 556# MAN_TD_VER TABLE - FIELDS 557# ------------------------------------------- 558define('MAN_TD_VER_ID', 'VersionID'); 559define('MAN_TD_VER_MANUAL_TEST_ID', 'ManualTestID'); 560define('MAN_TD_VER_VERSION', 'Version'); 561define('MAN_TD_VER_TIME_STAMP', 'TimeStamp'); 562define('MAN_TD_VER_UPLOADED_BY', 'UploadedBy'); 563define('MAN_TD_VER_FILENAME', 'FileName'); 564define('MAN_TEST_DOCS_VERS_COMMENTS', 'Comments'); 565define('MAN_TEST_DOCS_VERS_MANUAL_DOC_TYPE_NAME', 'ManualDocTypeName'); 566 567# ------------------------------------------- 568# POST TABLE - FIELDS 569# ------------------------------------------- 570define('NEWS_ID', 'NewsID'); 571define('NEWS_PROJECT_ID', 'project_id'); 572define('NEWS_SUBJECT', 'Subject'); 573define('NEWS_BODY', 'Body'); 574define('NEWS_MODIFIED', 'LastModified'); 575define('NEWS_POSTER', 'Poster'); 576define('NEWS_DELETED', 'Deleted'); 577 578#------------------------------------------- 579# RELEASE TABLE - FIELDS 580# ------------------------------------------- 581define('RELEASE_ID', 'ReleaseID'); 582define('RELEASE_ARCHIVE', 'Archive'); 583define('RELEASE_PLATFORM', 'Platform'); 584define('RELEASE_NAME', 'ReleaseName'); 585define('RELEASE_DATE_RECEIVED', 'DateReceived'); 586define('RELEASE_QA_SIGNOFF', 'QASignoff'); 587define('RELEASE_BA_SIGNOFF', 'BASignoff'); 588define('RELEASE_QA_SIGNOFF_DATE', 'QASignoffDate'); 589define('RELEASE_BA_SIGNOFF_DATE', 'BASignoffDate'); 590define('RELEASE_QA_SIGNOFF_BY', 'QASignoffBy'); 591define('RELEASE_BA_SIGNOFF_BY', 'BASignoffBy'); 592define('RELEASE_QA_SIGNOFF_COMMENTS', 'QASignoffComments'); 593define('RELEASE_BA_SIGNOFF_COMMENTS', 'BASignoffComments'); 594define('RELEASE_DESCRIPTION', 'Description'); 595define('RELEASE_PROJECT_ID', 'project_id'); 596 597# ------------------------------------------- 598# REQ_AREA Coverage TABLE - FIELDS 599# ------------------------------------------- 600define('REQ_AREA_COVERAGE_ID', 'ReqAreaCoverageID'); 601define('REQ_AREA_PROJ_ID', 'ProjectID'); 602define('REQ_AREA_COVERAGE', 'AreaCoverage'); 603 604# ------------------------------------------- 605# REQ_DOC_TYPE TABLE - FIELDS 606# ------------------------------------------- 607define('REQ_DOC_TYPE_ID', 'ReqDocTypeID'); 608define('REQ_DOC_TYPE_NAME', 'ReqDocTypeName'); 609define('REQ_DOC_TYPE_ROOT_DOC', 'RootDocument'); 610define('REQ_DOC_TYPE_PROJ_ID', 'ProjectID'); 611 612# ------------------------------------------- 613# REQ_FUNCTIONALITY TABLE - FIELDS 614# ------------------------------------------- 615define('REQ_FUNCT_ID', 'FunctionalityID'); 616define('REQ_FUNCT_NAME', 'FunctionalityName'); 617define('REQ_FUNCT_PROJ_ID', 'ProjectID'); 618 619# ------------------------------------------- 620# REQ_FUNCTIONALITY_ASSOC TABLE - FIELDS 621# ------------------------------------------- 622define('REQ_FUNCT_ASSOC_ID', 'RequirementFunctionality_AssocID'); 623define('REQ_FUNCT_ASSOC_REQ_ID', 'RequirementID'); 624define('REQ_FUNCT_ASSOC_FUNCT_ID', 'RequirementFunctionalityID'); 625 626# ------------------------------------------- 627# REQ_NOTIFICATION TABLE - FIELDS 628# ------------------------------------------- 629define('REQ_NOTIFY_ID', 'ReqNotifyID'); 630define('REQ_NOTIFY_REQ_ID', 'ReqID'); 631define('REQ_NOTIFY_USER_ID', 'UserID'); 632 633# ------------------------------------------- 634# REQ TABLE - FIELDS 635# ------------------------------------------- 636define('REQ_PROJECT_ID', 'project_id'); 637define('REQ_ID', 'ReqID'); 638define('REQ_FILENAME', 'ReqName'); 639define('REQ_AREA_COVERED', 'AreaCovered'); 640define('REQ_TYPE', 'Type'); 641define('REQ_PARENT', 'Parent'); 642define('REQ_ROOT', 'RootNode'); 643define('REQ_LABEL', 'Label'); 644define('REQ_UNIQUE_ID', 'UniqueID'); 645define('REQ_FUNCTIONALITY', 'Functionality'); 646define('REQ_LOCKED', 'Locked'); 647define('REQ_LOCKED_BY', 'LockedBy'); 648define('REQ_LOCKED_DATE', 'LockedDate'); 649define('REQ_REC_FILE', 'RecordOrFile'); 650define('REQ_PRIORITY', 'Priority'); 651define('REQ_LAST_UPDATED', 'LastUpdated'); 652 653# ------------------------------------------- 654# REQ_VERS_TBL - FIELDS 655# ------------------------------------------- 656define('REQ_VERS_UNIQUE_ID', 'ReqVersionID'); 657define('REQ_VERS_REQ_ID', 'ReqID'); 658define('REQ_VERS_DEFECT_ID', 'defect_id'); 659define('REQ_VERS_VERSION', 'Version'); 660define('REQ_VERS_TIMESTAMP', 'TimeStamp'); 661define('REQ_VERS_UPLOADED_BY', 'Author'); 662define('REQ_VERS_AUTHOR', 'Author'); 663define('REQ_VERS_FILENAME', 'FileName'); 664define('REQ_VERS_COMMENTS', 'Comments'); 665define('REQ_VERS_STATUS', 'Status'); 666define('REQ_VERS_SCHEDULED_RELEASE_IMP', 'Scheduled_Release_Implementation'); 667define('REQ_VERS_SCHEDULED_BUILD_IMP', 'Scheduled_Build_Implementation'); 668define('REQ_VERS_ACTUAL_RELEASE_IMP', 'Actual_Release_Implementation'); 669define('REQ_VERS_ACTUAL_BUILD_IMP', 'Actual_Build_Implementation'); 670define('REQ_VERS_ASSIGN_RELEASE', 'AssignToRelease'); 671define('REQ_VERS_ASSIGNED_TO', 'AssignedTo'); 672define('REQ_VERS_DETAIL', 'Detail'); 673define('REQ_VERS_LATEST', 'Latest'); 674define('REQ_VERS_REASON_CHANGE', 'ReasonForChange'); 675define('REQ_VERS_LAST_UPDATED', 'LastUpdated'); 676define('REQ_VERS_LAST_UPDATED_BY', 'LastUpdatedBy'); 677 678# ------------------------------------------- 679# REQ_VERS_ASSOC_REL TABLE - FIELDS 680# ------------------------------------------- 681define('REQ_VERS_ASSOC_REL_ID', 'RequirementVersion_Release_AssocID'); 682define('REQ_VERS_ASSOC_REL_REQ_ID', 'RequirementVersionID'); 683define('REQ_VERS_ASSOC_REL_REL_ID', 'ReleaseID'); 684 685# ------------------------------------------- 686# TEST_CASE_RESULTS TABLE - FIELDS 687# ------------------------------------------- 688/* 689define('TEST_CASE_RESULTS_ID', 'TestCaseResultsID'); 690define('TEST_CASE_RESULTS_LOG_TIME_STAMP', 'LogTimeStamp'); 691define('TEST_CASE_RESULTS_TEST_STATUS', 'TestStatus'); 692define('TEST_CASE_RESULTS_STARTEd', 'Started'); 693define('TEST_CASE_RESULTS_FINISHED', 'Finished'); 694define('TEST_CASE_RESULTS_CVS_VERSION', 'CVSVersion'); 695define('TEST_CASE_RESULTS_TC_UNIQUE_RUN_ID', 'TC_UniqueRunID'); 696define('TEST_CASE_RESULTS_TS_UNIQUE_RUN_ID', 'TS_UniqueRunID'); 697define('TEST_CASE_RESULTS_TEST_CASE', 'TestCase'); 698define('TEST_CASE_RESULTS_TEST_PATH', 'TestPath'); 699define('TEST_CASE_RESULTS_NARRATIVE', 'Narrative'); 700define('TEST_CASE_RESULTS_RUN_ID', 'RunID'); 701define('TEST_CASE_RESULTS_TIME_STARTED', 'TimeStarted'); 702define('TEST_CASE_RESULTS_TIME_FINISHED', 'TimeFinished'); 703*/ 704 705# ------------------------------------------- 706# SCREEN TABLE - Fields 707# ------------------------------------------- 708define('SCREEN_ID', 'screen_id'); 709define('SCREEN_PROJ_ID', 'project_id'); 710define('SCREEN_ORDER', 'screen_order'); 711define('SCREEN_NAME', 'screen_name'); 712define('SCREEN_DESC', 'screen_desc'); 713 714# ------------------------------------------- 715# STEP TABLE - Fields 716# ------------------------------------------- 717define('STEP_ID', 'step_id'); 718define('STEP_FUNCTION_ID', 'function_id'); 719define('STEP_NO', 'step_number'); 720define('STEP_ACTION', 'action'); 721define('STEP_INPUTS', 'inputs'); 722define('STEP_EXPECTED', 'expected_result'); 723define('STEP_INFO_STEP', 'step_type'); 724 725# ------------------------------------------- 726# TEST FUNCTION ASSOC TABLE - Fields 727# ------------------------------------------- 728define('TEST_FUNC_ASSOC_ID', 'test_func_assoc_id'); 729define('TEST_FUNC_TEST_ID', 'test_id'); 730define('TEST_FUNC_ASSOC_FUNC_ID', 'function_id'); 731define('TEST_FUNC_ASSOC_ON_ERROR', 'on_error'); 732 733# ------------------------------------------- 734# TEST_PLAN TABLE - Fields 735# ------------------------------------------- 736define('TEST_PLAN_ID', 'TestPlanID'); 737define('TEST_PLAN_BUILDID', 'BuildID'); 738define('TEST_PLAN_NAME', 'TestPlanName'); 739 740# ------------------------------------------- 741# TEST_PLAN_VERSION TABLE - Fields 742# ------------------------------------------- 743define('TEST_PLAN_VERSION_ID', 'TestPlanVersionID'); 744define('TEST_PLAN_VERSION_TESTPLANID', 'TestPlanID'); 745define('TEST_PLAN_VERSION_VERSION', 'Version'); 746define('TEST_PLAN_VERSION_UPLOADEDDATE', 'UploadedDate'); 747define('TEST_PLAN_VERSION_UPLOADEDBY', 'UploadedBy'); 748define('TEST_PLAN_VERSION_FILENAME', 'FileName'); 749define('TEST_PLAN_VERSION_COMMMENTS', 'Comments'); 750define('TEST_PLAN_VERSION_LATEST', 'Latest'); 751 752# ------------------------------------------- 753# TEST_SET TABLE - Fields 754# ------------------------------------------- 755define('TS_ID', 'TestSetID'); 756define('TS_NAME', 'TestSetName'); 757define('TS_STATUS', 'TestSetStatus'); 758define('TS_DESCRIPTION', 'Description'); 759define('TS_BUILD_ID', 'BuildID'); 760define('TS_ORDERBY', 'TestSetOrderBy'); 761define('TS_ARCHIVE', 'Archive'); 762define('TS_DATE_CREATED', 'DateCreated'); 763define('TS_SIGNOFF_DATE', 'SignOffDate'); 764define('TS_SIGNOFF_BY', 'SignOffBy'); 765define('TS_SIGNOFF_COMMENTS', 'SignOffComments'); 766define('TS_UNIQUE_ID', 'UniqueID'); 767define('TS_LOCKCHANGE_DATE','LockChangeDate'); 768define('TS_LOCK','Locked'); 769define('TS_LOCK_BY','LockBy'); 770define('TS_LOCK_COMMENT','LockComment'); 771 772#-------------------------------------------- 773# TEST_TS_ASSOC TABLE - FIELDS 774# ------------------------------------------- 775define('TEST_TS_ASSOC_ID', 'TestSet_TestSuite_AssocID'); 776define('TEST_TS_ASSOC_TS_ID', 'TestSetID'); 777define('TEST_TS_ASSOC_TEST_ID', 'TestID'); 778define('TEST_TS_ASSOC_FINISHED', 'Finished'); 779define('TEST_TS_ASSOC_TIMESTAMP', 'LogTimeStamp'); 780define('TEST_TS_ASSOC_ROOT_CAUSE', 'root_cause'); 781define('TEST_TS_ASSOC_STATUS', 'TestStatus'); 782define('TEST_TS_ASSOC_ASSIGNED_TO', 'AssignedTo'); 783define('TEST_TS_ASSOC_COMMENTS', 'Comments'); 784 785# ------------------------------------------- 786# TEST_STATUS TABLE - FIELDS 787# ------------------------------------------- 788define('TEST_STATUS_ID', 'TestStatusID'); 789define('TEST_STATUS_PROJECT_ID', 'project_id'); 790define('TEST_STATUS_STATUS', 'TestStatus'); 791 792# ------------------------------------------- 793# TEST TABLE - FIELDS 794# ------------------------------------------- 795define('TEST_ID', 'TestID'); 796define('TEST_PROJ_ID', 'project_id'); 797define('TEST_DELETED', 'Deleted'); 798define('TEST_ARCHIVED', 'Archive'); 799define('TEST_CODE_REVIEW', 'CodeReview'); 800define('TEST_BA_APPROVAL', 'BA_Approval'); 801define('TEST_MANUAL', 'Steps'); 802define('TEST_AUTOMATED', 'Script'); 803define('TEST_LR', 'LoadRunner'); 804define('TEST_EMAIL_BA_OWNER', 'email_ba_owner'); 805define('TEST_EMAIL_QA_OWNER', 'email_qa_owner'); 806define('TEST_AUTO_PASS', 'AutoPass'); 807define('TEST_DURATION', 'Duration'); 808define('TEST_PURPOSE', 'Purpose'); 809define('TEST_NAME', 'TestSuiteName'); 810define('TEST_TESTTYPE', 'TestType'); 811define('TEST_AREA_TESTED', 'AreaTested'); 812define('TEST_BA_OWNER', 'BAOwner'); 813define('TEST_QA_OWNER', 'Scripter'); 814define('TEST_APPROVED_FOR_AUTO', 'ApprovedForAuto'); 815define('TEST_PRIORITY', 'Priority'); 816define('TEST_STATUS', 'Status'); 817define('TEST_COMMENTS', 'Comments'); 818define('TEST_TESTER', 'Tester'); 819define('TEST_ASSIGNED_TO', 'AssignedTo'); 820define('TEST_ASSIGNED_BY', 'AssignedBy'); 821define('TEST_DATE_CREATED', 'DateCreated'); 822define('TEST_DATE_ASSIGNED', 'DateAssigned'); 823define('TEST_DATE_EXPECTED', 'ExpDateComplete'); 824define('TEST_DATE_COMPLETE', 'ActDateComplete'); 825define('TEST_BA_SIGNOFF', 'BASignOff'); 826define('TEST_SIGNOFF_BY', 'SignoffBy'); 827define('TEST_SIGNOFF_DATE', 'SignoffDate'); 828define('TEST_LAST_UPDATED', 'LastUpdated'); 829define('TEST_LAST_UPDATED_BY', 'LastUpdatedBy'); 830define('TEST_UNIQUE_ID', 'UniqueID'); 831 832# ------------------------------------------- 833# TEST_RESULTS TABLE - FIELDS 834# ------------------------------------------- 835define('TEST_RESULTS_ID', 'TestSuiteResultsID'); 836define('TEST_RESULTS_TEST_SET_ID', 'TestSetID'); 837define('TEST_RESULTS_TEMPEST_TEST_ID', 'TestID'); 838define('TEST_RESULTS_LOG_TIME_STAMP', 'LogTimeStamp'); 839define('TEST_RESULTS_TEST_STATUS', 'TestStatus'); 840define('TEST_RESULTS_ASSIGNED_TO', 'assigned_to'); 841define('TEST_RESULTS_ROOT_CAUSE', 'root_cause'); 842define('TEST_RESULTS_COMMENTS', 'test_run_comment'); 843define('TEST_RESULTS_STARTED', 'Started'); 844define('TEST_RESULTS_FINISHED', 'Finished'); 845define('TEST_RESULTS_CVS_VERSION', 'CVSVersion'); 846define('TEST_RESULTS_CHECKED_FOR_AUTO_PASS', 'CheckedForAutoPass'); 847define('TEST_RESULTS_OS', 'OS'); 848define('TEST_RESULTS_SP', 'SP'); 849define('TEST_RESULTS_N_NUMBER_ID', 'nNumberID'); 850define('TEST_RESULTS_USER_ID', 'UserID'); 851define('TEST_RESULTS_MACHINE_NAME', 'MachineName'); 852define('TEST_RESULTS_TEST_SUITE', 'TestSuite'); 853define('TEST_RESULTS_TEST_PATH', 'TestPath'); 854define('TEST_RESULTS_ENVIRONMENT', 'Environment'); 855define('TEST_RESULTS_RUN_ID', 'RunID'); 856define('TEST_RESULTS_TS_UNIQUE_RUN_ID', 'TS_UniqueRunID'); 857define('TEST_RESULTS_TIME_STARTED', 'TimeStarted'); 858define('TEST_RESULTS_TIME_FINISHED', 'TimeFinished'); 859 860# ------------------------------------------- 861# TEST_STEPS TABLE - FIELDS 862# ------------------------------------------- 863define('TEST_STEP_ID', 'TestStepID'); 864define('TEST_STEP_TEST_ID', 'TestID'); 865define('TEST_STEP_VERSION_ID', 'TestVersionID'); 866define('TEST_STEP_NO', 'TestStep_Number'); 867define('TEST_STEP_ACTION', 'Action'); 868define('TEST_STEP_EXPECTED', 'Expected_Result'); 869define('TEST_STEP_TEST_INPUTS', 'Inputs'); 870define('TEST_STEP_INFO_STEP', 'StepType'); 871 872# ------------------------------------------- 873# TEST_REQ_ASSOC TABLE - FIELDS 874# ------------------------------------------- 875define('TEST_REQ_ASSOC_ID', 'TestSuite_Requirement_AssocID'); 876define('TEST_REQ_ASSOC_TEMPEST_TEST_ID', 'TestID'); 877define('TEST_REQ_ASSOC_REQ_ID', 'ReqID'); 878define('TEST_REQ_ASSOC_PERCENT_COVERED', 'PercentCovered'); 879 880# ------------------------------------------- 881# TEST_TYPE TABLE - FIELDS 882# ------------------------------------------- 883define('TEST_TYPE_ID', 'TestTypeID'); 884define('TEST_TYPE_TYPE', 'TestType'); 885define('TEST_TYPE_PROJ_ID', 'project_id'); 886 887# ------------------------------------------- 888# TEST_VERS TABLE - FIELDS 889# ------------------------------------------- 890define('TEST_VERS_ID', 'TestVersionID'); 891define('TEST_VERS_TEST_ID', 'TestID'); 892define('TEST_VERS_NUMBER', 'Version'); 893define('TEST_VERS_LATEST', 'Latest'); 894define('TEST_VERS_ACTIVE', 'ActiveVersion'); 895define('TEST_VERS_COMMENTS', 'Comments'); 896define('TEST_VERS_STATUS', 'Status'); 897define('TEST_VERS_ASSIGNED_TO', 'AssignedTo'); 898define('TEST_VERS_SIGNOFF_BY', 'SignOffBy'); 899define('TEST_VERS_SIGNOFF_DATE', 'BASignOff'); 900define('TEST_VERS_AUTHOR', 'Creator'); 901define('TEST_VERS_DATE_CREATED', 'DateCreated'); 902 903# ------------------------------------------- 904# TEST_WORK_FLOW TABLE - FIELDS 905# ------------------------------------------- 906define('TEST_WORK_FLOW_UNIQUE_TEST_ID', 'UniqueTestID'); 907define('TEST_WORK_FLOW_COMPLETE', 'Complete'); 908define('TEST_WORK_FLOW_TEST_NAME', 'TestName'); 909define('TEST_WORK_FLOW_BA_TO_CREATE_TC', 'BAToCreateTC'); 910define('TEST_WORK_FLOW_BA_CREATE_DATE_COMP', 'BACreateDateComp'); 911define('TEST_WORK_FLOW_QA_TO_REVIEW_TV', 'QAToReviewTC'); 912define('TEST_WORK_FLOW_QA_REVIEW_DATE_COMP', 'QAReviewDateComp'); 913define('TEST_WORK_FLOW_QA_AUTOMATED', 'QAAutomated'); 914define('TEST_WORK_FLOW_QA_AUTO_DATE_START', 'QAAutoDateStart'); 915define('TEST_WORK_FLOW_QA_AUTO_DATE_EXP', 'QAAutoDateExp'); 916define('TEST_WORK_FLOW_QA_AUTO_DATE_COMP', 'QAAutoDateComp'); 917define('TEST_WORK_FLOW_BA_TO_APPROVE', 'BAToApprove'); 918define('TEST_WORK_FLOW_BA_APPROVAL_DATE', 'BAApprovalDate'); 919define('TEST_WORK_FLOW_COMMENTS', 'Comments'); 920 921# ------------------------------------------- 922# VERIFY_RESULTS TABLE - FIELDS 923# ------------------------------------------- 924define('VERIFY_RESULTS_ID', 'VerifyResultsID'); 925define('VERIFY_RESULTS_LOG_TIME_STAMP', 'LogTimeStamp'); 926define('VERIFY_RESULTS_TEST_STATUS', 'TestStatus'); 927define('VERIFY_RESULTS_LINE_NUMBER', 'LineNumber'); 928define('VERIFY_RESULTS_TOTAL_PHY_MEM', 'TotalPhyMem'); 929define('VERIFY_RESULTS_FREE_PHY_MEM', 'FreePhyMem'); 930define('VERIFY_RESULTS_TOTAL_VIR_MEM', 'TotalVirMem'); 931define('VERIFY_RESULTS_FREE_VIR_MEM', 'FreeVirMem'); 932define('VERIFY_RESULTS_CUR_MEM_UTIL', 'CurMemUtil'); 933define('VERIFY_RESULTS_TOTAL_PAGE_FILE', 'TotalPageFile'); 934define('VERIFY_RESULTS_FREE_PAGE_FILE', 'FreePageFile'); 935define('VERIFY_RESULTS_SHOW_CUSTOM_1', 'Custom_1'); 936define('VERIFY_RESULTS_SHOW_CUSTOM_2', 'Custom_2'); 937define('VERIFY_RESULTS_SHOW_CUSTOM_3', 'Custom_3'); 938define('VERIFY_RESULTS_SHOW_CUSTOM_4', 'Custom_4'); 939define('VERIFY_RESULTS_SHOW_CUSTOM_5', 'Custom_5'); 940define('VERIFY_RESULTS_SHOW_CUSTOM_6', 'Custom_6'); 941define('VERIFY_RESULTS_COMMENT', 'Comment'); 942define('VERIFY_RESULTS_ACTION', 'Action'); 943define('VERIFY_RESULTS_EXPECTED_RESULT', 'ExpectedResult'); 944define('VERIFY_RESULTS_ACTUAL_RESULT', 'ActualResult'); 945define('VERIFY_RESULTS_WINDOW', 'Window'); 946define('VERIFY_RESULTS_OBJ', 'Object'); 947define('VERIFY_RESULTS_OBJ_TYPE', 'ObjType'); 948define('VERIFY_RESULTS_VAL_ID', 'StepNumber'); 949define('VERIFY_RESULTS_TS_UNIQUE_RUN_ID', 'TS_UniqueRunID'); 950define('VERIFY_RESULTS_TIMESTAMP', 'TimeStamp'); 951define('VERIFY_RESULTS_DEFECT_ID', 'defect_id'); 952 953# ------------------------------------------- 954# USER TABLE - FIELDS 955# ------------------------------------------- 956define('USER_ID', 'user_id'); 957define('USER_PWORD', 'password'); 958define('USER_UNAME', 'username'); 959define('USER_FNAME', 'first_name'); 960define('USER_LNAME', 'last_name'); 961define('USER_PHONE', 'phone'); 962define('USER_EMAIL', 'email'); 963define('USER_ADMIN', 'user_admin'); 964define('USER_DELETED', 'deleted'); 965define('USER_DEFAULT_PROJECT', 'default_project'); 966 967# ------------------------------------------- 968# PROJECT TABLE - FIELDS ##### 969# ------------------------------------------- 970define('PROJ_ID', 'project_id'); 971define('PROJ_DBNAME', 'db_name'); 972define('PROJ_NAME', 'project_name'); 973define('PROJ_DATE_CREATED', 'date_created'); 974define('PROJ_DELETED', 'deleted'); 975define('PROJ_REQ_UPLOAD_PATH', 'req_upload_path'); 976define('PROJ_TEST_UPLOAD_PATH', 'test_upload_path'); 977define('PROJ_TEST_RUN_UPLOAD_PATH', 'test_run_upload_path'); 978define('PROJ_TEST_PLAN_UPLOAD_PATH', 'test_plan_upload_path'); 979define('PROJ_DEFECT_UPLOAD_PATH', 'defect_upload_path'); 980define('PROJ_USE_FILES', 'use_files'); 981define('PROJ_STATUS', 'status'); 982define('PROJ_DESCRIPTION', 'description'); 983define('PROJ_BUG_URL_UPLOAD_PATH', 'bug_url'); 984define('PROJ_SHOW_TESTCASE', 'show_testcase'); 985define('PROJ_SHOW_CUSTOM_1', 'show_custom_1'); 986define('PROJ_SHOW_CUSTOM_2', 'show_custom_2'); 987define('PROJ_SHOW_CUSTOM_3', 'show_custom_3'); 988define('PROJ_SHOW_CUSTOM_4', 'show_custom_4'); 989define('PROJ_SHOW_CUSTOM_5', 'show_custom_5'); 990define('PROJ_SHOW_CUSTOM_6', 'show_custom_6'); 991define('PROJ_SHOW_WINDOW', 'show_window'); 992define('PROJ_SHOW_OBJECT', 'show_object'); 993define('PROJ_SHOW_MEM_STATS', 'show_memory_stats'); 994define('PROJ_SHOW_PRIORITY', 'show_priority'); 995define('PROJ_SHOW_TEST_INPUT', 'show_test_input'); 996define('PROJ_TEST_VERSIONS', 'test_versions'); 997 998# ------------------------------------------- 999# PROJECT_USER_ASSOC TABLE - FIELDS 1000# ------------------------------------------- 1001define('PROJ_USER_ID', 'project_user_assoc_id'); 1002define('PROJ_USER_PROJ_ID', 'project_id'); 1003define('PROJ_USER_USER_ID', 'user_id'); 1004define('PROJ_USER_BA_OWNER', 'ba_owner'); 1005define('PROJ_USER_QA_OWNER', 'qa_tester'); 1006//define('PROJ_USER_DEFAULT_PROJECT', 'default_project'); 1007define('PROJ_USER_DELETE_RIGHTS', 'delete_rights'); 1008define('PROJ_USER_EMAIL_TESTSET', 'email_testset'); 1009define('PROJ_USER_EMAIL_REQ_DISCUSSION', 'email_discussion'); 1010define('PROJ_USER_EMAIL_NEW_BUG', 'email_new_bug'); 1011define('PROJ_USER_EMAIL_UPDATE_BUG', 'email_update_bug'); 1012define('PROJ_USER_EMAIL_ASSIGNED_BUG', 'email_assigned_bug'); 1013define('PROJ_USER_EMAIL_BUGNOTE_BUG', 'email_bugnote_bug'); 1014define('PROJ_USER_EMAIL_STATUS_BUG', 'email_status_bug'); 1015define('PROJ_USER_PROJECT_RIGHTS', 'user_rights'); 1016 1017 1018# ------------------------------------------- 1019# RESET_PASSWORD TABLE - FIELDS 1020# ------------------------------------------- 1021define('RESET_PASS_ID', 'reset_id'); 1022define('RESET_PASS_LINK', 'reset_link'); 1023define('RESET_PASS_USER', 'user'); 1024define('RESET_PASS_RESET_USED', 'reset_used'); 1025define('RESET_PASS_EXPIRES', 'expires'); 1026 1027# ------------------------------------------- 1028# BUG TABLE - FIELDS 1029# ------------------------------------------- 1030define('BUG_ID', 'BugID'); 1031define('BUG_PROJECT_ID', 'ProjectID'); 1032define('BUG_CATEGORY', 'Category'); 1033define('BUG_COMPONENT', 'Component'); 1034define('BUG_PRIORITY', 'Priority'); 1035define('BUG_SEVERITY', 'Severity'); 1036define('BUG_CLOSED_REASON_CODE', 'ClosedReasonCode'); 1037define('BUG_STATUS', 'Status'); 1038define('BUG_REPORTER', 'Reporter'); 1039define('BUG_REPORTED_DATE', 'ReportedDate'); 1040define('BUG_ASSIGNED_TO', 'AssignedTo'); 1041define('BUG_ASSIGNED_TO_DEVELOPER', 'AssignedToDeveloper'); 1042define('BUG_CLOSED', 'Closed'); 1043define('BUG_CLOSED_DATE', 'ClosedDate'); 1044define('BUG_TEST_VERIFY_ID', 'TestID'); 1045define('BUG_REQ_VERSION_ID', 'ReqID'); 1046define('BUG_FOUND_IN_RELEASE', 'FoundInRelease'); 1047define('BUG_ASSIGN_TO_RELEASE', 'AssignToRelease'); 1048define('BUG_IMPLEMENTED_IN_RELEASE', 'ImplementedInRelease'); 1049define('BUG_DISCOVERY_PERIOD', 'DiscoveryPeriod'); 1050define('BUG_SUMMARY', 'Summary'); 1051define('BUG_DESCRIPTION', 'Description'); 1052 1053# ------------------------------------------- 1054# BUG MONITOR TABLE - FIELDS 1055# ------------------------------------------- 1056define('BUG_MONITOR_ID', 'BugMonitorID'); 1057define('BUG_MONITOR_USER_ID', 'UserID'); 1058define('BUG_MONITOR_BUG_ID', 'BugID'); 1059define('BUG_MONITOR_MONITOR', 'Monitor'); 1060 1061# ------------------------------------------- 1062# BUG NOTE TABLE - FIELDS 1063# ------------------------------------------- 1064define('BUG_NOTE_ID', 'BugNoteID'); 1065define('BUG_NOTE_BUG_ID', 'BugID'); 1066define('BUG_NOTE_AUTHOR', 'Author'); 1067define('BUG_NOTE_DATE_CREATED', 'DateCreated'); 1068define('BUG_NOTE_DETAIL', 'BugNoteDetail'); 1069 1070# ------------------------------------------- 1071# BUG CATEGORY TABLE - FIELDS 1072# ------------------------------------------- 1073define('CATEGORY_ID', 'CategoryID'); 1074define('CATEGORY_PROJECT_ID', 'ProjectID'); 1075define('CATEGORY_NAME', 'CategoryName'); 1076 1077# ------------------------------------------- 1078# BUG COMPONENT TABLE - FIELDS 1079# ------------------------------------------- 1080define('COMPONENT_ID', 'ComponentID'); 1081define('COMPONENT_PROJECT_ID', 'ProjectID'); 1082define('COMPONENT_NAME', 'ComponentName'); 1083 1084# ------------------------------------------- 1085# BUG FILE TABLE - FIELDS 1086# ------------------------------------------- 1087define('BUG_FILE_ID', 'BugFileID'); 1088define('BUG_FILE_BUG_ID', 'BugID'); 1089define('BUG_FILE_UPLOAD_DATE', 'UploadedDate'); 1090define('BUG_FILE_UPLOAD_BY', 'UploadedBy'); 1091define('BUG_FILE_DISPLAY_NAME', 'DisplayName'); 1092define('BUG_FILE_NAME', 'BugFileName'); 1093 1094# ------------------------------------------- 1095# BUG HISTORY TABLE - FIELDS 1096# ------------------------------------------- 1097define('BUG_HISTORY_ID', 'BugHistoryID'); 1098define('BUG_HISTORY_BUG_ID', 'BugID'); 1099define('BUG_HISTORY_DATE', 'DateModified'); 1100define('BUG_HISTORY_USER', 'UserName'); 1101define('BUG_HISTORY_FIELD', 'Field'); 1102define('BUG_HISTORY_OLD_VALUE', 'OldValue'); 1103define('BUG_HISTORY_NEW_VALUE', 'NewValue'); 1104 1105# ------------------------------------------- 1106# BUG ASSOC TABLE - FIELDS 1107# ------------------------------------------- 1108define('BUG_ASSOC_ID', 'BugAssocID'); 1109define('BUG_ASSOC_SRC_ID', 'PrimaryID'); 1110define('BUG_ASSOC_DEST_ID', 'SecondaryID'); 1111define('BUG_ASSOC_REL_TYPE', 'RelationshipType'); 1112 1113# ------------------------------------------- 1114# BUG TEST ASSOC TABLE - FIELDS 1115# ------------------------------------------- 1116/* 1117define('BUG_TEST_ASSOC_ID', 'BugAssocID'); 1118define('BUG_ID', 'BugID'); 1119define('VERIFICATION_ID', 'VerificationID'); 1120*/ 1121 1122define('BUG_RELATED', 0); 1123define('BUG_CHILD', 1); 1124define('BUG_PARENT', 2); 1125 1126 1127# ------------------------------------------- 1128# Error Codes 1129# ------------------------------------------- 1130define('INVALID_LOGIN', 10); 1131define('NO_DEFAULT_PROJ', 20); 1132define('NO_USER_RIGHTS', 30); 1133define('NOT_LOGGED_IN', 40); 1134define('COOKIES_NOT_ENABLED', 50); 1135define('PROJECT_SWITCH_FAILED', 60); 1136define('PROJECT_DB_NOT_SET', 70); 1137define('REQUIRED_FIELD_MISSING', 80); 1138define('INVALID_DATE', 90); 1139define('DUPLICATE_TESTNAME', 100); 1140define('LDAP_CONNECTION_FAILED',110); 1141define('DUPLICATE_RELEASE_NAME', 120); 1142define('FAILED_FILE_UPLOAD', 130); 1143define('PASSWORDS_NOT_MATCH', 140); 1144define('USERNAME_NOT_UNIQUE', 150); 1145define('NO_RIGHTS_TO_VIEW_PAGE', 155); 1146define('NO_REQ_SELECTED', 160); 1147define('NO_TESTS_SELECTED', 170); 1148define('DUPLICATE_REQ_NAME', 180); 1149define('UNABLE_TO_CREATE_PROJECT_FOLDERS', 190); 1150define('PROJECT_NOT_UNIQUE', 200); 1151define('ERROR_ACCOUNT_NOT_FOUND', 210); 1152define('ERROR_CANNOT_RESET_PASSWORD', 220); 1153define('ERROR_WRONG_HOST', 230); 1154define('EMAIL_NOT_UNIQUE', 240); 1155define('NO_RIGHTS_TO_PROJECT', 250); 1156define('COULD_NOT_CREATE_RELATIONSHIP', 260); 1157define('NO_BUGS_SELECTED', 270); 1158define('INVALID_BUG_ID', 280); 1159define('DUPLICATE_FILE_NAME', 290); 1160define('DUPLICATE_AREANAME', 300); 1161define('DUPLICATE_BUILD_NAME', 310); 1162define('DUPLICATE_TESTSET_NAME', 320); 1163define('DUPLICATE_TESTAREA', 330); 1164define('DUPLICATE_TEST_DOC_TYPE', 340); 1165define('DUPLICATE_ENVIRONMENT_NAME', 350); 1166define('DUPLICATE_TESTTYPE_NAME', 360); 1167define('DUPLICATE_MACHINE_NAME', 370); 1168define('DUPLICATE_IP_ADDRESS', 380); 1169define('DUPLICATE_REQUIREMENT_FUNCTIONALITY', 390); 1170define('DUPLICATE_REQUIREMENT_DOCTYPE', 400); 1171define('DUPLICATE_BUG_CATEGORY', 410); 1172define('DUPLICATE_BUG_COMPONENT', 420); 1173define('NO_MATCHING_FILE_NAME', 430); 1174define('NO_FILE_SPECIFIED', 440); 1175define('DUPLICATE_SCREEN_NAME', 450); 1176define('DUPLICATE_FIELD_NAME', 460); 1177define('USERNAME_CONTAINS_BLANK',470); 1178define('PROJECT_NOT_EXISTS',480); 1179define('NO_RIGHTS_TO_VIEW_PROJECT',490); 1180define('TEST_NOT_EXISTS',500); 1181define('USERNAME_CONTAINS_INVALID_CHARS',510); 1182define('PASSWORD_INVALID',520); 1183define('FAILED_DELETE_DOC',530); 1184 1185 1186# ------------------------------------------- 1187# Delete Messages 1188# ------------------------------------------- 1189define('DEL_TEST_RUN', 10); 1190define('DEL_RELEASE', 20); 1191define('DEL_BUILD', 30); 1192define('DEL_TESTSET', 40); 1193define('DEL_USER_FROM_PROJECT', 50); 1194define('DEL_AREA_FROM_PROJECT', 60); 1195define('DEL_MACHINE_FROM_PROJECT', 70); 1196define('DEL_TESTTYPE_FROM_PROJECT', 80); 1197define('DEL_TEST_DOC_TYPE_FROM_PROJECT', 90); 1198define('DEL_TEST_STEP', 100); 1199define('DEL_ENVIRONMENT_FROM_PROJECT', 110); 1200define('DEL_REQ_DOC_TYPE_FROM_PROJECT', 120); 1201define('DEL_PROJECT', 130); 1202define('DEL_USER', 140); 1203define('DEL_REQ_AREA_FROM_PROJECT', 150); 1204define('DEL_REQUIREMENT', 190); 1205define('DEL_REQ_FUNCT_FROM_PROJECT', 200); 1206define('DEL_TEST', 210); 1207define('DEL_NEWS', 220); 1208define('DEL_BUG_CATEGORY_FROM_PROJECT', 230); 1209define('DEL_BUG_COMPONENT_FROM_PROJECT', 240); 1210define('DEL_BUG', 250); 1211define('DEL_BUGNOTE', 260); 1212define('DEL_BUG_ASSOC', 270); 1213define('DEL_TEST_PLAN', 280); 1214define('DEL_TEST_RUN_DOC', 290); 1215define('DEL_SCREEN', 300); 1216define('DEL_FIELD', 310); 1217 1218 1219# ------------------------------- 1220# $Log: properties_inc.php,v $ 1221# Revision 1.40 2008/08/07 11:18:35 cryobean 1222# changed version number to 1.7.0 1223# 1224# Revision 1.39 2008/08/07 10:57:52 peter_thal 1225# Now blanks are replaced with underscores by adding a new supporting doc 1226# 1227# Revision 1.38 2008/07/25 09:50:07 peter_thal 1228# added lock testset feature 1229# disabled detail column in test result, because functionality is not implemented yet 1230# 1231# Revision 1.37 2008/07/23 14:53:51 peter_thal 1232# delete supporting docs feature added (linux/unix) 1233# 1234# Revision 1.36 2008/07/10 07:28:30 peter_thal 1235# security update: 1236# disabled writing spaces or apostrophe and others into login textfields 1237# 1238# Revision 1.35 2008/07/09 07:13:20 peter_thal 1239# added direct linking of test detail by adding project_id link parameter 1240# added automated project switching if necessary 1241# 1242# Revision 1.34 2008/07/01 13:46:24 peter_thal 1243# now usernames can't contain whitespaces 1244# 1245# Revision 1.33 2008/01/31 07:59:53 cryobean 1246# change version number for release 1247# 1248# Revision 1.32 2007/12/11 12:12:35 cryobean 1249# change version number to 1.6.2 1250# 1251# Revision 1.31 2007/03/14 17:45:52 gth2 1252# removing code that passes varables by reference - gth 1253# 1254# Revision 1.30 2007/02/25 23:17:41 gth2 1255# fixing bugs for release 1.6.1 - gth 1256# 1257# Revision 1.29 2007/02/12 07:16:35 gth2 1258# adding email functionality on test update - gth 1259# 1260# Revision 1.28 2007/02/02 04:26:12 gth2 1261# adding version information to the footer of each page - gth 1262# 1263# Revision 1.27 2006/12/05 05:29:19 gth2 1264# updates for 1.6.1 release 1265# 1266# Revision 1.26 2006/10/11 02:41:11 gth2 1267# adding phpMailer - gth 1268# 1269# Revision 1.25 2006/10/05 02:42:18 gth2 1270# adding file upload to the bug page - gth 1271# 1272# Revision 1.24 2006/09/27 23:46:50 gth2 1273# Adding functionality to link a change request (defect_id) to a requirement - gth 1274# 1275# Revision 1.23 2006/09/27 06:09:29 gth2 1276# correcting case sensativity with FCKeditor - gth 1277# 1278# Revision 1.22 2006/09/27 05:37:59 gth2 1279# adding Mantis integration - gth 1280# 1281# Revision 1.21 2006/09/27 05:35:01 gth2 1282# adding Mantis integration - gth 1283# 1284# Revision 1.20 2006/09/25 12:46:37 gth2 1285# Working on linking rth and other bugtrackers - gth 1286# 1287# Revision 1.19 2006/08/05 22:31:46 gth2 1288# adding NEWLINE constant to support mulitple OS - gth 1289# 1290# Revision 1.18 2006/08/05 22:08:36 gth2 1291# adding NEWLINE constant to support multiple OS newline chars - gth 1292# 1293# Revision 1.17 2006/08/05 20:31:43 gth2 1294# adding NEWLINE constant to support multiple OS newline chars - gth 1295# 1296# Revision 1.16 2006/08/01 23:44:46 gth2 1297# fixing case sensativity errors reported by users - gth 1298# 1299# Revision 1.15 2006/08/01 23:42:56 gth2 1300# fixing case sensativity errors reported by users - gth 1301# 1302# Revision 1.14 2006/06/24 14:34:15 gth2 1303# updating changes lost with cvs problem. 1304# 1305# Revision 1.13 2006/05/03 20:35:35 gth2 1306# no message 1307# 1308# Revision 1.12 2006/04/11 12:11:01 gth2 1309# create a test version when uploading test steps - gth 1310# 1311# Revision 1.11 2006/04/09 16:37:28 gth2 1312# no message 1313# 1314# Revision 1.10 2006/02/27 17:26:16 gth2 1315# added email functionality to bug tracker - gth 1316# 1317# Revision 1.9 2006/02/24 11:33:31 gth2 1318# minor bug fixes and enhancements for 1.5.1 release - gth 1319# 1320# Revision 1.8 2006/02/15 03:11:20 gth2 1321# correcting case - gth 1322# 1323# Revision 1.7 2006/02/09 12:41:46 gth2 1324# clean up syntax causing NOTICES in php - gth 1325# 1326# Revision 1.6 2006/02/06 13:04:23 gth2 1327# fixing problem with mkdir when creating a new project - gth 1328# 1329# Revision 1.5 2006/01/16 13:27:48 gth2 1330# adding excel integration - gth 1331# 1332# Revision 1.4 2006/01/09 02:02:24 gth2 1333# fixing some defects found while writing help file 1334# 1335# Revision 1.3 2005/12/28 23:05:33 gth2 1336# Updating release table definition - gth 1337# 1338# Revision 1.2 2005/12/06 13:56:50 gth2 1339# Adding requirement priority and last updated - gth 1340# 1341# Revision 1.1.1.1 2005/11/30 23:01:12 gth2 1342# importing initial version - gth 1343# 1344# -------------------------------