<div dir="ltr">Istvan,<div><br></div><div>You are right - we had noticed the same and need for foreign key constraint as well</div><div>to ensure data is removed when entry from crmentity is done. </div><div><br></div><div>
We will take care of it soon.<br><div><br></div><div>Regards,</div><div>Prasad</div></div></div><div class="gmail_extra"><br clear="all"><div><span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><b>Connect with us on: </b><a href="http://twitter.com/vtigercrm" style="color:rgb(0,0,204)" target="_blank">Twitter</a> <b>I</b> <a href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall" style="color:rgb(0,0,204)" target="_blank">Facebook</a> <b>I</b> <a href="https://blogs.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Blog</a><b> I</b> <a href="http://wiki.vtiger.com/index.php/Main_Page" style="color:rgb(0,0,204)" target="_blank">Wiki</a> <b>I </b><a href="https://discussions.vtiger.com" style="color:rgb(0,0,204)" target="_blank">Forums </a><b>I</b> <a href="https://www.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Website</a></span></div>
<br><br><div class="gmail_quote">On Thu, Jul 3, 2014 at 5:53 PM, Holbok István <span dir="ltr"><<a href="mailto:holbok@gmail.com" target="_blank">holbok@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Dear Vtiger Team,<br>
<br>
As I am involved in vtiger custom module development I am facing
with several issues.<br>
<br>
One of them is, the bootstrap vtlib script creates entity module
base table <b>without primary key</b> to table - and this is
obviously a BUG.<br>
<br>
How to reproduce it:<br>
<br>
Use the script from the page:<br>
<a href="http://community.vtiger.com/help/vtigercrm/developers/extensions/examples/entity-module.html" target="_blank">http://community.vtiger.com/help/vtigercrm/developers/extensions/examples/entity-module.html</a><br>
<b>Create the bootstrap vtlib script in root folder of Vtiger to
activate the module entry.</b><br>
<br>
Running the script (environment PHP 5.4.19, XAMPP Windows 8.1) you
will get 2 tables in vtiger CRM. (Sorry for the Hungarian screen
shoots, but my PHPMyadmin do not want to give screens in English in
this moment :-), I hope the main data is shown. )<br>
<b><font color="#cc0000">The base table without primary key:</font></b><br>
<h1 style="color:rgb(0,0,0);font-family:'Times New Roman';font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
vtiger_expenses</h1>
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;width:1903px;background-color:rgb(255,255,255)">
<thead><tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Oszlop</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Típus</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Nulla</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Alapértelmezett</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Megjegyzések</th>
</tr>
</thead><tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">expensesid</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(11)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">summary</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(255)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">expenseon</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">date<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">expenseamount</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(255)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
</tbody>
</table>
<h3 style="color:rgb(0,0,0);font-family:'Times New Roman';font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
Indexek</h3>
<div style="color:rgb(0,0,0);font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<div><img src="cid:part1.06080007.01080707@gmail.com" title="" alt="" style="border:0px"><span> </span>Nincs meghatározott
index! (No indexes!)<br>
</div>
</div>
<br>
<h1>vtiger_expensescf</h1>
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;width:1903px;background-color:rgb(255,255,255)">
<thead><tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Oszlop</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Típus</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Nulla</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Alapértelmezett</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Megjegyzések</th>
</tr>
</thead><tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">expensesid</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(11)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Nem </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
</tbody>
</table>
<h3>Indexek</h3>
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)">
<thead><tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Kulcsnév</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Típus</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Egyedi</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Csomagolt</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Oszlop</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Számosság</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Illesztés</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Nulla</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Megjegyzés</th>
</tr>
</thead><tbody>
<tr>
<td rowspan="1">PRIMARY</td>
<td rowspan="1">BTREE</td>
<td rowspan="1">Igen</td>
<td rowspan="1">Nem</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
expensesid</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
0</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
A</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
Nem</td>
</tr>
</tbody>
</table>
<br>
The custom field table with necessary primary key to table.<br>
<br>
The exported module manifest file also will not contain the primary
key.<br>
<br>
I think due to this vtlib bug there are several variant of table
usage. And this variation is independent from the usage of
Autoincrement <br>
<b><font color="#006600"><br>
For example the Assets module (from the latest developments) has
primary key in its base table:</font></b><br>
<h1>vtiger_assets</h1>
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;width:1903px;background-color:rgb(255,255,255)">
<thead><tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Oszlop</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Típus</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Nulla</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Alapértelmezett</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Hivatkozás</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Megjegyzések</th>
</tr>
</thead><tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">assetsid</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(11)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Nem </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">vtiger_crmentity
-> crmid </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">asset_no</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(30)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Nem </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">account</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(19)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">product</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(19)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Nem </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">serialnumber</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(200)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">datesold</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">date<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">dateinservice</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">date<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">assetstatus</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(200)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">In
Service </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">tagnumber</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(300)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">invoiceid</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(19)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">shippingmethod</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(200)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">shippingtrackingnumber</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(200)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">assetname</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(100)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">contact</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(19)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
</tbody>
</table>
<h3>Indexek</h3>
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)">
<thead><tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Kulcsnév</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Típus</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Egyedi</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Csomagolt</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Oszlop</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Számosság</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Illesztés</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Nulla</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Megjegyzés</th>
</tr>
</thead><tbody>
<tr>
<td rowspan="1">PRIMARY</td>
<td rowspan="1">BTREE</td>
<td rowspan="1">Igen</td>
<td rowspan="1">Nem</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
assetsid</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
0</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
A</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
Nem</td>
</tr>
</tbody>
</table>
<br>
<font color="#cc0000"><b>But the Project module has not primary key.</b></font><br>
<h1 style="color:rgb(0,0,0);font-family:'Times New Roman';font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
vtiger_project</h1>
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;width:1903px;background-color:rgb(255,255,255)">
<thead><tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Oszlop</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Típus</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Nulla</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Alapértelmezett</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Megjegyzések</th>
</tr>
</thead><tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">projectid</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(11)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">projectname</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(255)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">project_no</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(100)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">startdate</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">date<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">targetenddate</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">date<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">actualenddate</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">date<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">targetbudget</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(255)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">projecturl</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(255)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">projectstatus</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(100)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">projectpriority</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(100)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">projecttype</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(100)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">progress</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(100)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">linktoaccountscontacts</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(100)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
</tbody>
</table>
<h3 style="color:rgb(0,0,0);font-family:'Times New Roman';font-style:normal;font-variant:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
Indexek</h3>
<div style="color:rgb(0,0,0);font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<div><img src="cid:part1.06080007.01080707@gmail.com" title="" alt="" style="border:0px"><span> </span>Nincs meghatározott
index!</div>
</div>
<br>
<b><font color="#006600">The Pricebook also has primary key:</font></b><br>
<h1>vtiger_pricebook</h1>
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;width:1903px;background-color:rgb(255,255,255)">
<thead><tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Oszlop</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Típus</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Nulla</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Alapértelmezett</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Hivatkozás</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Megjegyzések</th>
</tr>
</thead><tbody>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">pricebookid</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(19)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Nem </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">0 </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">vtiger_crmentity
-> crmid </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">pricebook_no</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(100)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Nem </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">bookname</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">varchar(100)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">active</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(1)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Igen </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"><i>NULL</i> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
<tr>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">currency_id</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">int(19)<bdo dir="ltr"></bdo></td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">Nem </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)">1 </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;background-color:rgb(255,255,255)"> </td>
</tr>
</tbody>
</table>
<h3>Indexek</h3>
<table style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);border-collapse:collapse;border-spacing:0px;background-color:rgb(255,255,255)">
<thead><tr>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Kulcsnév</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Típus</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Egyedi</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Csomagolt</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Oszlop</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Számosság</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Illesztés</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Nulla</th>
<th style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-weight:bold;background-color:rgb(229,229,229)">Megjegyzés</th>
</tr>
</thead><tbody>
<tr>
<td rowspan="1">PRIMARY</td>
<td rowspan="1">BTREE</td>
<td rowspan="1">Igen</td>
<td rowspan="1">Nem</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
pricebookid</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
0</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
A</td>
<td style="color:rgb(0,0,0);border:0.1em solid rgb(0,0,0);padding:0.2em;font-family:'Times New Roman';font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
Nem</td>
</tr>
</tbody>
</table>
<br>
<br>
--------------------------<br>
My suggestion is to correct vtlib to create primary key for the base
tables of modules.<br>
And use primary key to all table of vtiger CRM database.<br>
<br>
Kindest regards:<br>
István<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
<div>-- <br>
üdvözlettel:<br>
<br>
<b>Holbok István</b><br>
<br>
+3670-342-0900<br>
<b>e-mail:</b> <a href="mailto:holbok@gmail.com" target="_blank">holbok@gmail.com</a><br>
<b>SkyPe:</b> holboki<br>
<br>
</div>
</font></span></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>