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, 2701🔥, 0💬
Popular Posts:
What are JMeter command line options? You can get see JMeter command line options by running this co...
How to set Content-Type to application/json? The server requires the Content-Type to be application/...
Where to find test data generators? FYIcenter.com has prepared a number of test data generators for ...
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...
How to validate Mod 10 (Luhn Algorithm) checksum? In order to help your programming or testing tasks...