Category Archives: mysql

vtiger CRM 5.10 database tables

The list of the tables used by vTiger CRM 5.10 is available on this page:

vtiger CRM 5.10 Table list

How to do it yourself:

To extract the list into a file, open a cmd window. Change directory to
C:\Program Files\vtigercrm-5.1.0\mysql\bin

Create a file showtables.sql that contains the following lines:
use vtigercrm510;
show tables;

In the command line window, enter the following line, where xxxxxx must be replaced with your password for mysql:
mysql -u root -pxxxxxx < showtables.sql > tablelist.txt

Mysql will exectue the commands from showtables.sql and store the result in tablelist.txt