How to create TestMan test case tables in MySQL server?

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

⇒Implementing TestMan in MySQL

⇒⇒Test Management Tutorials