Collections:
Create Test Case Tables
How to create TestMan test case tables in MySQL server?
✍: FYIcenter.com
You can create TestMan test case tables in MySQL server by following this tutorial.
1. Create the following SQL file, CreateTestCase.sql:
-- CreateTestCase.sql use TestMan; create table Test_Case ( ID bigint, Name varchar(80), Status varchar(16), Description varchar(255), Priority varchar(16), Product varchar(80), Component varchar(80), Function varchar(80), Pre_Condition varchar(255), Post_Impact varchar(255) ); create table Test_Case_Parameter ( ID bigint, Test_Case_ID bigint, Name varchar(80), Description varchar(255), Value varchar(255) ); create table Test_Case_Step ( ID bigint, Test_Case_ID bigint, Name varchar(80), Description varchar(255) ); create table Test_Case_Step_Input ( ID bigint, Test_Case_Step_ID bigint, Name varchar(80), Description varchar(255) ); create table Test_Case_Step_Assertion ( ID bigint, Test_Case_Step_ID bigint, Name varchar(80), Description varchar(255) ); create table Test_Case_Reference ( ID bigint, Test_Case_ID bigint, Name varchar(80), Value varchar(255) ); create table Test_Case_History ( ID bigint, Test_Case_ID bigint, Timestamp timestamp null default null, Author varchar(80), Description varchar(255) );
2. Run CreateTestCase.sql with MySQL client command tool:
>\fyicenter\mysql\bin\mysql -u fyicenter < CreateTestCase.sql
⇐ MySQL Requirements for TestMan
2017-12-21, 2678🔥, 0💬
Popular Posts:
How to generate test credit card numbers? Test credit card numbers are frequently needed in testing ...
Where to find tutorials on UFT (Unified Functional Testing) tool? I want to know how to use UFT. Her...
How to generate date and time test values? Timestamp values are frequently needed in testing almost ...
How to generate email addresses? To help you to obtain some email addresses for testing purpose, FYI...
How to force JMeter to automatically flush test result to file immediately after each sampler is exe...