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, 2605🔥, 0💬
Popular Posts:
How to convert a date and time to a standard format? Date and time can be displayed in a number of s...
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
What are date and time test values? Date and time test values are frequently needed in testing date ...
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...
How to Open and Close Internet Explorer with UFT script? One way to open and close Internet Explorer...