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
2017-12-21, 1107👍, 0💬
Popular Posts:
How to generate MAC addresses? To help you to obtain some MAC addresses for testing purpose, FYIcent...
How to validate domain name format? In order to help your programming or testing tasks, FYIcenter.co...
How to generate test credit card numbers? Test credit card numbers are frequently needed in testing ...
Here is a list of top popular Software Test Management Commercial and Free Tools: RankNameVendorPric...
How to validate email address format? In order to help your programming or testing tasks, FYIcenter....