2.2 Create pytesthistoric table - adiralashiva8/pytest-historic GitHub Wiki

pytest-historic report stores created projects in pytesthistoric.TB_PROJECT table to provide more information like project last updated, project image, total executions, recent pass percentage information.

Users must create pytesthistoric.TB_PROJECT table initially, following are steps to create table.

---

Step 1: Open command prompt (root to mysql: mysql -uroot -p123456)

Step 2: Create database (type following query and hit enter)

CREATE DATABASE IF NOT EXISTS pytesthistoric;

Step 3: Create table (type following query and hit enter - one after other)

USE pytesthistoric;
Create table TB_PROJECT ( Project_Id INT NOT NULL auto_increment primary key, Project_Name TEXT, Project_Desc TEXT, Project_Image TEXT, Created_Date DATETIME, Last_Updated DATETIME, Total_Executions INT, Recent_Pass_Perc FLOAT, Overall_Pass_Perc FLOAT);