Edit File by line
• /home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../testlink
• File: testlink.sql
[0] Fix | Delete
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
[1] Fix | Delete
SET time_zone = "+00:00";
[2] Fix | Delete
[3] Fix | Delete
[4] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[5] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[6] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[7] Fix | Delete
/*!40101 SET NAMES utf8 */;
[8] Fix | Delete
[9] Fix | Delete
--
[10] Fix | Delete
-- Database: `testlink1920`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `[[dbprefix]]assignment_status`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `[[dbprefix]]assignment_status` (
[20] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`description` varchar(100) NOT NULL DEFAULT 'unknown',
[22] Fix | Delete
PRIMARY KEY (`id`)
[23] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
[24] Fix | Delete
[25] Fix | Delete
--
[26] Fix | Delete
-- Dumping data for table `[[dbprefix]]assignment_status`
[27] Fix | Delete
--
[28] Fix | Delete
[29] Fix | Delete
INSERT INTO `[[dbprefix]]assignment_status` VALUES
[30] Fix | Delete
(1, 'open'),
[31] Fix | Delete
(2, 'closed'),
[32] Fix | Delete
(3, 'completed'),
[33] Fix | Delete
(4, 'todo_urgent'),
[34] Fix | Delete
(5, 'todo');
[35] Fix | Delete
[36] Fix | Delete
-- --------------------------------------------------------
[37] Fix | Delete
[38] Fix | Delete
--
[39] Fix | Delete
-- Table structure for table `[[dbprefix]]assignment_types`
[40] Fix | Delete
--
[41] Fix | Delete
[42] Fix | Delete
CREATE TABLE `[[dbprefix]]assignment_types` (
[43] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[44] Fix | Delete
`fk_table` varchar(30) DEFAULT '',
[45] Fix | Delete
`description` varchar(100) NOT NULL DEFAULT 'unknown',
[46] Fix | Delete
PRIMARY KEY (`id`)
[47] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
[48] Fix | Delete
[49] Fix | Delete
--
[50] Fix | Delete
-- Dumping data for table `[[dbprefix]]assignment_types`
[51] Fix | Delete
--
[52] Fix | Delete
[53] Fix | Delete
INSERT INTO `[[dbprefix]]assignment_types` VALUES
[54] Fix | Delete
(1, 'testplan_tcversions', 'testcase_execution'),
[55] Fix | Delete
(2, 'tcversions', 'testcase_review');
[56] Fix | Delete
[57] Fix | Delete
-- --------------------------------------------------------
[58] Fix | Delete
[59] Fix | Delete
--
[60] Fix | Delete
-- Table structure for table `[[dbprefix]]attachments`
[61] Fix | Delete
--
[62] Fix | Delete
[63] Fix | Delete
CREATE TABLE `[[dbprefix]]attachments` (
[64] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[65] Fix | Delete
`fk_id` int(10) unsigned NOT NULL DEFAULT '0',
[66] Fix | Delete
`fk_table` varchar(250) DEFAULT '',
[67] Fix | Delete
`title` varchar(250) DEFAULT '',
[68] Fix | Delete
`description` varchar(250) DEFAULT '',
[69] Fix | Delete
`file_name` varchar(250) NOT NULL DEFAULT '',
[70] Fix | Delete
`file_path` varchar(250) DEFAULT '',
[71] Fix | Delete
`file_size` int(11) NOT NULL DEFAULT '0',
[72] Fix | Delete
`file_type` varchar(250) NOT NULL DEFAULT '',
[73] Fix | Delete
`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
[74] Fix | Delete
`content` longblob,
[75] Fix | Delete
`compression_type` int(11) NOT NULL DEFAULT '0',
[76] Fix | Delete
PRIMARY KEY (`id`),
[77] Fix | Delete
KEY `[[dbprefix]]attachments_idx1` (`fk_id`)
[78] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[79] Fix | Delete
[80] Fix | Delete
-- --------------------------------------------------------
[81] Fix | Delete
[82] Fix | Delete
--
[83] Fix | Delete
-- Table structure for table `[[dbprefix]]baseline_l1l2_context`
[84] Fix | Delete
--
[85] Fix | Delete
[86] Fix | Delete
CREATE TABLE `[[dbprefix]]baseline_l1l2_context` (
[87] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[88] Fix | Delete
`testplan_id` int(10) unsigned NOT NULL DEFAULT '0',
[89] Fix | Delete
`platform_id` int(10) unsigned NOT NULL DEFAULT '0',
[90] Fix | Delete
`begin_exec_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
[91] Fix | Delete
`end_exec_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
[92] Fix | Delete
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
[93] Fix | Delete
PRIMARY KEY (`id`),
[94] Fix | Delete
UNIQUE KEY `udx1_context` (`testplan_id`,`platform_id`,`creation_ts`)
[95] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[96] Fix | Delete
[97] Fix | Delete
-- --------------------------------------------------------
[98] Fix | Delete
[99] Fix | Delete
--
[100] Fix | Delete
-- Table structure for table `[[dbprefix]]baseline_l1l2_details`
[101] Fix | Delete
--
[102] Fix | Delete
[103] Fix | Delete
CREATE TABLE `[[dbprefix]]baseline_l1l2_details` (
[104] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[105] Fix | Delete
`context_id` int(10) unsigned NOT NULL,
[106] Fix | Delete
`top_tsuite_id` int(10) unsigned NOT NULL DEFAULT '0',
[107] Fix | Delete
`child_tsuite_id` int(10) unsigned NOT NULL DEFAULT '0',
[108] Fix | Delete
`status` char(1) DEFAULT NULL,
[109] Fix | Delete
`qty` int(10) unsigned NOT NULL DEFAULT '0',
[110] Fix | Delete
`total_tc` int(10) unsigned NOT NULL DEFAULT '0',
[111] Fix | Delete
PRIMARY KEY (`id`),
[112] Fix | Delete
UNIQUE KEY `udx1_details` (`context_id`,`top_tsuite_id`,`child_tsuite_id`,`status`)
[113] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[114] Fix | Delete
[115] Fix | Delete
-- --------------------------------------------------------
[116] Fix | Delete
[117] Fix | Delete
--
[118] Fix | Delete
-- Table structure for table `[[dbprefix]]builds`
[119] Fix | Delete
--
[120] Fix | Delete
[121] Fix | Delete
CREATE TABLE `[[dbprefix]]builds` (
[122] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[123] Fix | Delete
`testplan_id` int(10) unsigned NOT NULL DEFAULT '0',
[124] Fix | Delete
`name` varchar(100) NOT NULL DEFAULT 'undefined',
[125] Fix | Delete
`notes` text,
[126] Fix | Delete
`active` tinyint(1) NOT NULL DEFAULT '1',
[127] Fix | Delete
`is_open` tinyint(1) NOT NULL DEFAULT '1',
[128] Fix | Delete
`author_id` int(10) unsigned DEFAULT NULL,
[129] Fix | Delete
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
[130] Fix | Delete
`release_date` date DEFAULT NULL,
[131] Fix | Delete
`closed_on_date` date DEFAULT NULL,
[132] Fix | Delete
`commit_id` varchar(64) DEFAULT NULL,
[133] Fix | Delete
`tag` varchar(64) DEFAULT NULL,
[134] Fix | Delete
`branch` varchar(64) DEFAULT NULL,
[135] Fix | Delete
`release_candidate` varchar(100) DEFAULT NULL,
[136] Fix | Delete
PRIMARY KEY (`id`),
[137] Fix | Delete
UNIQUE KEY `[[dbprefix]]name` (`testplan_id`,`name`),
[138] Fix | Delete
KEY `[[dbprefix]]testplan_id` (`testplan_id`)
[139] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Available builds' AUTO_INCREMENT=1 ;
[140] Fix | Delete
[141] Fix | Delete
-- --------------------------------------------------------
[142] Fix | Delete
[143] Fix | Delete
--
[144] Fix | Delete
-- Table structure for table `[[dbprefix]]cfield_build_design_values`
[145] Fix | Delete
--
[146] Fix | Delete
[147] Fix | Delete
CREATE TABLE `[[dbprefix]]cfield_build_design_values` (
[148] Fix | Delete
`field_id` int(10) NOT NULL DEFAULT '0',
[149] Fix | Delete
`node_id` int(10) NOT NULL DEFAULT '0',
[150] Fix | Delete
`value` varchar(4000) NOT NULL DEFAULT '',
[151] Fix | Delete
PRIMARY KEY (`field_id`,`node_id`),
[152] Fix | Delete
KEY `[[dbprefix]]idx_cfield_build_design_values` (`node_id`)
[153] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[154] Fix | Delete
[155] Fix | Delete
-- --------------------------------------------------------
[156] Fix | Delete
[157] Fix | Delete
--
[158] Fix | Delete
-- Table structure for table `[[dbprefix]]cfield_design_values`
[159] Fix | Delete
--
[160] Fix | Delete
[161] Fix | Delete
CREATE TABLE `[[dbprefix]]cfield_design_values` (
[162] Fix | Delete
`field_id` int(10) NOT NULL DEFAULT '0',
[163] Fix | Delete
`node_id` int(10) NOT NULL DEFAULT '0',
[164] Fix | Delete
`value` varchar(4000) NOT NULL DEFAULT '',
[165] Fix | Delete
PRIMARY KEY (`field_id`,`node_id`),
[166] Fix | Delete
KEY `[[dbprefix]]idx_cfield_design_values` (`node_id`)
[167] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[168] Fix | Delete
[169] Fix | Delete
-- --------------------------------------------------------
[170] Fix | Delete
[171] Fix | Delete
--
[172] Fix | Delete
-- Table structure for table `[[dbprefix]]cfield_execution_values`
[173] Fix | Delete
--
[174] Fix | Delete
[175] Fix | Delete
CREATE TABLE `[[dbprefix]]cfield_execution_values` (
[176] Fix | Delete
`field_id` int(10) NOT NULL DEFAULT '0',
[177] Fix | Delete
`execution_id` int(10) NOT NULL DEFAULT '0',
[178] Fix | Delete
`testplan_id` int(10) NOT NULL DEFAULT '0',
[179] Fix | Delete
`tcversion_id` int(10) NOT NULL DEFAULT '0',
[180] Fix | Delete
`value` varchar(4000) NOT NULL DEFAULT '',
[181] Fix | Delete
PRIMARY KEY (`field_id`,`execution_id`,`testplan_id`,`tcversion_id`)
[182] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[183] Fix | Delete
[184] Fix | Delete
-- --------------------------------------------------------
[185] Fix | Delete
[186] Fix | Delete
--
[187] Fix | Delete
-- Table structure for table `[[dbprefix]]cfield_node_types`
[188] Fix | Delete
--
[189] Fix | Delete
[190] Fix | Delete
CREATE TABLE `[[dbprefix]]cfield_node_types` (
[191] Fix | Delete
`field_id` int(10) NOT NULL DEFAULT '0',
[192] Fix | Delete
`node_type_id` int(10) NOT NULL DEFAULT '0',
[193] Fix | Delete
PRIMARY KEY (`field_id`,`node_type_id`),
[194] Fix | Delete
KEY `[[dbprefix]]idx_custom_fields_assign` (`node_type_id`)
[195] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[196] Fix | Delete
[197] Fix | Delete
-- --------------------------------------------------------
[198] Fix | Delete
[199] Fix | Delete
--
[200] Fix | Delete
-- Table structure for table `[[dbprefix]]cfield_testplan_design_values`
[201] Fix | Delete
--
[202] Fix | Delete
[203] Fix | Delete
CREATE TABLE `[[dbprefix]]cfield_testplan_design_values` (
[204] Fix | Delete
`field_id` int(10) NOT NULL DEFAULT '0',
[205] Fix | Delete
`link_id` int(10) NOT NULL DEFAULT '0' COMMENT 'point to testplan_tcversion id',
[206] Fix | Delete
`value` varchar(4000) NOT NULL DEFAULT '',
[207] Fix | Delete
PRIMARY KEY (`field_id`,`link_id`),
[208] Fix | Delete
KEY `[[dbprefix]]idx_cfield_tplan_design_val` (`link_id`)
[209] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[210] Fix | Delete
[211] Fix | Delete
-- --------------------------------------------------------
[212] Fix | Delete
[213] Fix | Delete
--
[214] Fix | Delete
-- Table structure for table `[[dbprefix]]cfield_testprojects`
[215] Fix | Delete
--
[216] Fix | Delete
[217] Fix | Delete
CREATE TABLE `[[dbprefix]]cfield_testprojects` (
[218] Fix | Delete
`field_id` int(10) unsigned NOT NULL DEFAULT '0',
[219] Fix | Delete
`testproject_id` int(10) unsigned NOT NULL DEFAULT '0',
[220] Fix | Delete
`display_order` smallint(5) unsigned NOT NULL DEFAULT '1',
[221] Fix | Delete
`location` smallint(5) unsigned NOT NULL DEFAULT '1',
[222] Fix | Delete
`active` tinyint(1) NOT NULL DEFAULT '1',
[223] Fix | Delete
`required` tinyint(1) NOT NULL DEFAULT '0',
[224] Fix | Delete
`required_on_design` tinyint(1) NOT NULL DEFAULT '0',
[225] Fix | Delete
`required_on_execution` tinyint(1) NOT NULL DEFAULT '0',
[226] Fix | Delete
`monitorable` tinyint(1) NOT NULL DEFAULT '0',
[227] Fix | Delete
PRIMARY KEY (`field_id`,`testproject_id`)
[228] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[229] Fix | Delete
[230] Fix | Delete
-- --------------------------------------------------------
[231] Fix | Delete
[232] Fix | Delete
--
[233] Fix | Delete
-- Table structure for table `[[dbprefix]]codetrackers`
[234] Fix | Delete
--
[235] Fix | Delete
[236] Fix | Delete
CREATE TABLE `[[dbprefix]]codetrackers` (
[237] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[238] Fix | Delete
`name` varchar(100) NOT NULL,
[239] Fix | Delete
`type` int(10) DEFAULT '0',
[240] Fix | Delete
`cfg` text,
[241] Fix | Delete
PRIMARY KEY (`id`),
[242] Fix | Delete
UNIQUE KEY `[[dbprefix]]codetrackers_uidx1` (`name`)
[243] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[244] Fix | Delete
[245] Fix | Delete
-- --------------------------------------------------------
[246] Fix | Delete
[247] Fix | Delete
--
[248] Fix | Delete
-- Table structure for table `[[dbprefix]]custom_fields`
[249] Fix | Delete
--
[250] Fix | Delete
[251] Fix | Delete
CREATE TABLE `[[dbprefix]]custom_fields` (
[252] Fix | Delete
`id` int(10) NOT NULL AUTO_INCREMENT,
[253] Fix | Delete
`name` varchar(64) NOT NULL DEFAULT '',
[254] Fix | Delete
`label` varchar(64) NOT NULL DEFAULT '' COMMENT 'label to display on user interface',
[255] Fix | Delete
`type` smallint(6) NOT NULL DEFAULT '0',
[256] Fix | Delete
`possible_values` varchar(4000) NOT NULL DEFAULT '',
[257] Fix | Delete
`default_value` varchar(4000) NOT NULL DEFAULT '',
[258] Fix | Delete
`valid_regexp` varchar(255) NOT NULL DEFAULT '',
[259] Fix | Delete
`length_min` int(10) NOT NULL DEFAULT '0',
[260] Fix | Delete
`length_max` int(10) NOT NULL DEFAULT '0',
[261] Fix | Delete
`show_on_design` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1=> show it during specification design',
[262] Fix | Delete
`enable_on_design` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1=> user can write/manage it during specification design',
[263] Fix | Delete
`show_on_execution` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1=> show it during test case execution',
[264] Fix | Delete
`enable_on_execution` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1=> user can write/manage it during test case execution',
[265] Fix | Delete
`show_on_testplan_design` tinyint(3) unsigned NOT NULL DEFAULT '0',
[266] Fix | Delete
`enable_on_testplan_design` tinyint(3) unsigned NOT NULL DEFAULT '0',
[267] Fix | Delete
PRIMARY KEY (`id`),
[268] Fix | Delete
UNIQUE KEY `[[dbprefix]]idx_custom_fields_name` (`name`)
[269] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[270] Fix | Delete
[271] Fix | Delete
-- --------------------------------------------------------
[272] Fix | Delete
[273] Fix | Delete
--
[274] Fix | Delete
-- Table structure for table `[[dbprefix]]db_version`
[275] Fix | Delete
--
[276] Fix | Delete
[277] Fix | Delete
CREATE TABLE `[[dbprefix]]db_version` (
[278] Fix | Delete
`version` varchar(50) NOT NULL DEFAULT 'unknown',
[279] Fix | Delete
`upgrade_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
[280] Fix | Delete
`notes` text,
[281] Fix | Delete
PRIMARY KEY (`version`)
[282] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[283] Fix | Delete
[284] Fix | Delete
--
[285] Fix | Delete
-- Dumping data for table `[[dbprefix]]db_version`
[286] Fix | Delete
--
[287] Fix | Delete
[288] Fix | Delete
INSERT INTO `[[dbprefix]]db_version` VALUES
[289] Fix | Delete
('DB 1.9.20', '[[regtime]]', 'TestLink 1.9.20 Raijin');
[290] Fix | Delete
[291] Fix | Delete
-- --------------------------------------------------------
[292] Fix | Delete
[293] Fix | Delete
--
[294] Fix | Delete
-- Table structure for table `[[dbprefix]]events`
[295] Fix | Delete
--
[296] Fix | Delete
[297] Fix | Delete
CREATE TABLE `[[dbprefix]]events` (
[298] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[299] Fix | Delete
`transaction_id` int(10) unsigned NOT NULL DEFAULT '0',
[300] Fix | Delete
`log_level` smallint(5) unsigned NOT NULL DEFAULT '0',
[301] Fix | Delete
`source` varchar(45) DEFAULT NULL,
[302] Fix | Delete
`description` text NOT NULL,
[303] Fix | Delete
`fired_at` int(10) unsigned NOT NULL DEFAULT '0',
[304] Fix | Delete
`activity` varchar(45) DEFAULT NULL,
[305] Fix | Delete
`object_id` int(10) unsigned DEFAULT NULL,
[306] Fix | Delete
`object_type` varchar(45) DEFAULT NULL,
[307] Fix | Delete
PRIMARY KEY (`id`),
[308] Fix | Delete
KEY `[[dbprefix]]transaction_id` (`transaction_id`),
[309] Fix | Delete
KEY `[[dbprefix]]fired_at` (`fired_at`)
[310] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[311] Fix | Delete
[312] Fix | Delete
--
[313] Fix | Delete
-- Dumping data for table `[[dbprefix]]events`
[314] Fix | Delete
--
[315] Fix | Delete
[316] Fix | Delete
[317] Fix | Delete
-- --------------------------------------------------------
[318] Fix | Delete
[319] Fix | Delete
--
[320] Fix | Delete
-- Table structure for table `[[dbprefix]]executions`
[321] Fix | Delete
--
[322] Fix | Delete
[323] Fix | Delete
CREATE TABLE `[[dbprefix]]executions` (
[324] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[325] Fix | Delete
`build_id` int(10) NOT NULL DEFAULT '0',
[326] Fix | Delete
`tester_id` int(10) unsigned DEFAULT NULL,
[327] Fix | Delete
`execution_ts` datetime DEFAULT NULL,
[328] Fix | Delete
`status` char(1) DEFAULT NULL,
[329] Fix | Delete
`testplan_id` int(10) unsigned NOT NULL DEFAULT '0',
[330] Fix | Delete
`tcversion_id` int(10) unsigned NOT NULL DEFAULT '0',
[331] Fix | Delete
`tcversion_number` smallint(5) unsigned NOT NULL DEFAULT '1',
[332] Fix | Delete
`platform_id` int(10) unsigned NOT NULL DEFAULT '0',
[333] Fix | Delete
`execution_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 -> manual, 2 -> automated',
[334] Fix | Delete
`execution_duration` decimal(6,2) DEFAULT NULL COMMENT 'NULL will be considered as NO DATA Provided by user',
[335] Fix | Delete
`notes` text,
[336] Fix | Delete
PRIMARY KEY (`id`),
[337] Fix | Delete
KEY `[[dbprefix]]executions_idx1` (`testplan_id`,`tcversion_id`,`platform_id`,`build_id`),
[338] Fix | Delete
KEY `[[dbprefix]]executions_idx2` (`execution_type`),
[339] Fix | Delete
KEY `[[dbprefix]]executions_idx3` (`tcversion_id`)
[340] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[341] Fix | Delete
[342] Fix | Delete
-- --------------------------------------------------------
[343] Fix | Delete
[344] Fix | Delete
--
[345] Fix | Delete
-- Table structure for table `[[dbprefix]]execution_bugs`
[346] Fix | Delete
--
[347] Fix | Delete
[348] Fix | Delete
CREATE TABLE `[[dbprefix]]execution_bugs` (
[349] Fix | Delete
`execution_id` int(10) unsigned NOT NULL DEFAULT '0',
[350] Fix | Delete
`bug_id` varchar(64) NOT NULL DEFAULT '0',
[351] Fix | Delete
`tcstep_id` int(10) unsigned NOT NULL DEFAULT '0',
[352] Fix | Delete
PRIMARY KEY (`execution_id`,`bug_id`,`tcstep_id`)
[353] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[354] Fix | Delete
[355] Fix | Delete
-- --------------------------------------------------------
[356] Fix | Delete
[357] Fix | Delete
--
[358] Fix | Delete
-- Table structure for table `[[dbprefix]]execution_tcsteps`
[359] Fix | Delete
--
[360] Fix | Delete
[361] Fix | Delete
CREATE TABLE `[[dbprefix]]execution_tcsteps` (
[362] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[363] Fix | Delete
`execution_id` int(10) unsigned NOT NULL DEFAULT '0',
[364] Fix | Delete
`tcstep_id` int(10) unsigned NOT NULL DEFAULT '0',
[365] Fix | Delete
`notes` text,
[366] Fix | Delete
`status` char(1) DEFAULT NULL,
[367] Fix | Delete
PRIMARY KEY (`id`),
[368] Fix | Delete
UNIQUE KEY `[[dbprefix]]execution_tcsteps_idx1` (`execution_id`,`tcstep_id`)
[369] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[370] Fix | Delete
[371] Fix | Delete
-- --------------------------------------------------------
[372] Fix | Delete
[373] Fix | Delete
--
[374] Fix | Delete
-- Table structure for table `[[dbprefix]]execution_tcsteps_wip`
[375] Fix | Delete
--
[376] Fix | Delete
[377] Fix | Delete
CREATE TABLE `[[dbprefix]]execution_tcsteps_wip` (
[378] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[379] Fix | Delete
`tcstep_id` int(10) unsigned NOT NULL DEFAULT '0',
[380] Fix | Delete
`testplan_id` int(10) unsigned NOT NULL DEFAULT '0',
[381] Fix | Delete
`platform_id` int(10) unsigned NOT NULL DEFAULT '0',
[382] Fix | Delete
`build_id` int(10) unsigned NOT NULL DEFAULT '0',
[383] Fix | Delete
`tester_id` int(10) unsigned DEFAULT NULL,
[384] Fix | Delete
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
[385] Fix | Delete
`notes` text,
[386] Fix | Delete
`status` char(1) DEFAULT NULL,
[387] Fix | Delete
PRIMARY KEY (`id`),
[388] Fix | Delete
UNIQUE KEY `[[dbprefix]]execution_tcsteps_wip_idx1` (`tcstep_id`,`testplan_id`,`platform_id`,`build_id`)
[389] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[390] Fix | Delete
[391] Fix | Delete
-- --------------------------------------------------------
[392] Fix | Delete
[393] Fix | Delete
--
[394] Fix | Delete
-- Stand-in structure for view `[[dbprefix]]exec_by_date_time`
[395] Fix | Delete
--
[396] Fix | Delete
CREATE TABLE `[[dbprefix]]exec_by_date_time` (
[397] Fix | Delete
`testplan_name` varchar(100)
[398] Fix | Delete
,`yyyy_mm_dd` varchar(10)
[399] Fix | Delete
,`yyyy_mm` varchar(7)
[400] Fix | Delete
,`hh` varchar(7)
[401] Fix | Delete
,`hour` varchar(7)
[402] Fix | Delete
,`id` int(10) unsigned
[403] Fix | Delete
,`build_id` int(10)
[404] Fix | Delete
,`tester_id` int(10) unsigned
[405] Fix | Delete
,`execution_ts` datetime
[406] Fix | Delete
,`status` char(1)
[407] Fix | Delete
,`testplan_id` int(10) unsigned
[408] Fix | Delete
,`tcversion_id` int(10) unsigned
[409] Fix | Delete
,`tcversion_number` smallint(5) unsigned
[410] Fix | Delete
,`platform_id` int(10) unsigned
[411] Fix | Delete
,`execution_type` tinyint(1)
[412] Fix | Delete
,`execution_duration` decimal(6,2)
[413] Fix | Delete
,`notes` text
[414] Fix | Delete
);
[415] Fix | Delete
-- --------------------------------------------------------
[416] Fix | Delete
[417] Fix | Delete
--
[418] Fix | Delete
-- Table structure for table `[[dbprefix]]inventory`
[419] Fix | Delete
--
[420] Fix | Delete
[421] Fix | Delete
CREATE TABLE `[[dbprefix]]inventory` (
[422] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[423] Fix | Delete
`testproject_id` int(10) unsigned NOT NULL,
[424] Fix | Delete
`owner_id` int(10) unsigned NOT NULL,
[425] Fix | Delete
`name` varchar(255) NOT NULL,
[426] Fix | Delete
`ipaddress` varchar(255) NOT NULL,
[427] Fix | Delete
`content` text,
[428] Fix | Delete
`creation_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
[429] Fix | Delete
`modification_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
[430] Fix | Delete
PRIMARY KEY (`id`),
[431] Fix | Delete
KEY `[[dbprefix]]inventory_idx1` (`testproject_id`)
[432] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[433] Fix | Delete
[434] Fix | Delete
-- --------------------------------------------------------
[435] Fix | Delete
[436] Fix | Delete
--
[437] Fix | Delete
-- Table structure for table `[[dbprefix]]issuetrackers`
[438] Fix | Delete
--
[439] Fix | Delete
[440] Fix | Delete
CREATE TABLE `[[dbprefix]]issuetrackers` (
[441] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[442] Fix | Delete
`name` varchar(100) NOT NULL,
[443] Fix | Delete
`type` int(10) DEFAULT '0',
[444] Fix | Delete
`cfg` text,
[445] Fix | Delete
PRIMARY KEY (`id`),
[446] Fix | Delete
UNIQUE KEY `[[dbprefix]]issuetrackers_uidx1` (`name`)
[447] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[448] Fix | Delete
[449] Fix | Delete
-- --------------------------------------------------------
[450] Fix | Delete
[451] Fix | Delete
--
[452] Fix | Delete
-- Table structure for table `[[dbprefix]]keywords`
[453] Fix | Delete
--
[454] Fix | Delete
[455] Fix | Delete
CREATE TABLE `[[dbprefix]]keywords` (
[456] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[457] Fix | Delete
`keyword` varchar(100) NOT NULL DEFAULT '',
[458] Fix | Delete
`testproject_id` int(10) unsigned NOT NULL DEFAULT '0',
[459] Fix | Delete
`notes` text,
[460] Fix | Delete
PRIMARY KEY (`id`),
[461] Fix | Delete
UNIQUE KEY `[[dbprefix]]keyword_testproject_id` (`keyword`,`testproject_id`),
[462] Fix | Delete
KEY `[[dbprefix]]testproject_id` (`testproject_id`),
[463] Fix | Delete
KEY `[[dbprefix]]keyword` (`keyword`)
[464] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[465] Fix | Delete
[466] Fix | Delete
-- --------------------------------------------------------
[467] Fix | Delete
[468] Fix | Delete
--
[469] Fix | Delete
-- Stand-in structure for view `[[dbprefix]]latest_exec_by_context`
[470] Fix | Delete
--
[471] Fix | Delete
CREATE TABLE `[[dbprefix]]latest_exec_by_context` (
[472] Fix | Delete
`tcversion_id` int(10) unsigned
[473] Fix | Delete
,`testplan_id` int(10) unsigned
[474] Fix | Delete
,`build_id` int(10)
[475] Fix | Delete
,`platform_id` int(10) unsigned
[476] Fix | Delete
,`id` int(10) unsigned
[477] Fix | Delete
);
[478] Fix | Delete
-- --------------------------------------------------------
[479] Fix | Delete
[480] Fix | Delete
--
[481] Fix | Delete
-- Stand-in structure for view `[[dbprefix]]latest_exec_by_testplan`
[482] Fix | Delete
--
[483] Fix | Delete
CREATE TABLE `[[dbprefix]]latest_exec_by_testplan` (
[484] Fix | Delete
`tcversion_id` int(10) unsigned
[485] Fix | Delete
,`testplan_id` int(10) unsigned
[486] Fix | Delete
,`id` int(10) unsigned
[487] Fix | Delete
);
[488] Fix | Delete
-- --------------------------------------------------------
[489] Fix | Delete
[490] Fix | Delete
--
[491] Fix | Delete
-- Stand-in structure for view `[[dbprefix]]latest_exec_by_testplan_plat`
[492] Fix | Delete
--
[493] Fix | Delete
CREATE TABLE `[[dbprefix]]latest_exec_by_testplan_plat` (
[494] Fix | Delete
`tcversion_id` int(10) unsigned
[495] Fix | Delete
,`testplan_id` int(10) unsigned
[496] Fix | Delete
,`platform_id` int(10) unsigned
[497] Fix | Delete
,`id` int(10) unsigned
[498] Fix | Delete
);
[499] Fix | Delete
1234
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function