Table Description for the DB under Testlink 1.8

1.8 related questions and discussions.
Please upgrade to LATEST 1.9.x.
No more fixes for 1.8.

Moderators: Amaradana, TurboPT, TL Developers

Locked
vinzsanity
TestLink user
Posts: 6
Joined: Tue Jun 08, 2010 9:45 am

Table Description for the DB under Testlink 1.8

Post by vinzsanity »

Hi Folks,

just wanna start some special queries on the mysql database under Testlink 1.8!
So i have already found the DB schema.. but im really missing some informations.
Could someone tell me where i can found the description of the tables?
I mean if i just take a table like "Executions" and the column exections.STATUS:

you find there values like: p, f, r-... and so on
What the hell is p, f or r?
So im in need of the description of every field from the tables...

thanks

vinzy
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: Table Description for the DB under Testlink 1.8

Post by fman »

IMHO you are choosing a not so good solution direct access to DB, instead of trying to use XMLRPC API.
In this way you will be ready to change your work, when changes to DB will be done (thing that will be happen on 1.9)
Anyway if you want to use this approache, you will need to dig on existent code.
For definition of constans see const.inc.php
Locked