Skip to content

2.2 Create robothistoric table

Shiva Prasad Adirala edited this page May 26, 2020 · 2 revisions

From v0.1.3 robotframework-historic report stores created projects in robothistoric.TB_PROJECT table to provide more information like project last updated, project image, total executions, recent pass percentage information.

Users must create robothistoric.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 robothistoric;

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

USE robothistoric;
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);