<div dir="ltr">Mariusz, Peter,<br><br>Thanks for the pointer on schema. We have devised a script to determine<br>schema inconsistency - hoping to weed these out soon.<div><br></div><div>Noted with thanks - <a href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8053">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8053</a><br>
<br>Regards,<br>Prasad<br><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 Fri, May 16, 2014 at 7:38 PM, Jung Péter <span dir="ltr"><<a href="mailto:pjung@parola.hu" target="_blank">pjung@parola.hu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div lang="HU" link="blue" vlink="purple"><div><p class="MsoNormal"><font size="3" color="#1f497d" face="Times New Roman"><span lang="EN-US" style="font-size:12pt;color:rgb(31,73,125)"><span> </span>Hi,<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" color="#1f497d" face="Times New Roman"><span lang="EN-US" style="font-size:12pt;color:rgb(31,73,125)"><u></u> <u></u></span></font></p><p class="MsoNormal"><font size="3" color="#1f497d" face="Times New Roman"><span lang="EN-US" style="font-size:12pt;color:rgb(31,73,125)">It happened all the time in <span>vTiger</span> 5.*...<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" color="#1f497d" face="Times New Roman"><span lang="EN-US" style="font-size:12pt;color:rgb(31,73,125)">Anno I posted a question, asking whether it is safe to change some of them to INT, but no one replied:<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" color="#1f497d" face="Times New Roman"><span lang="EN-US" style="font-size:12pt;color:rgb(31,73,125)"><u></u> <u></u></span></font></p><p><font face="Consolas"><span lang="EN-US" style="font-size:11pt"><span>However, I found that some optimizing could/should be done on the existing database structure.<u></u><u></u></span></span></font></p>
<p><font face="Consolas"><span lang="EN-US" style="font-size:11pt"><span>Attached is an SQL file that contains these optimizations.<u></u><u></u></span></span></font></p><p><span lang="EN-US"><u></u> <u></u></span></p><p>
<font face="Consolas"><span lang="EN-US" style="font-size:11pt"><span>My question is whether these modifications would cause problems upgrading <span>vTiger</span> to v6.0?<u></u><u></u></span></span></font></p><p class="MsoNormal">
<font size="3" color="#1f497d" face="Times New Roman"><span lang="EN-US" style="font-size:12pt;color:rgb(31,73,125)"><u></u> <u></u></span></font></p><p class="MsoNormal"><font size="3" color="#1f497d" face="Times New Roman"><span lang="EN-US" style="font-size:12pt;color:rgb(31,73,125)"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font color="#1f497d" face="Calibri"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Sincerley,<u></u><u></u></span></font></p><p class="MsoNormal">
<font color="#1f497d" face="Calibri"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span> </span>Peter Jung<u></u><u></u></span></font></p>
<p class="MsoNormal"><font color="#1f497d" face="Calibri"><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span> </span>Parola Kft<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" color="#1f497d" face="Times New Roman"><span lang="EN-US" style="font-size:12pt;color:rgb(31,73,125)"><u></u> <u></u></span></font></p><div style="border-style:none none none solid;border-left-color:blue;border-left-width:1.5pt;padding:0cm 0cm 0cm 4pt">
<div><div style="border-style:solid none none;border-top-color:rgb(181,196,223);border-top-width:1pt;padding:3pt 0cm 0cm"><p class="MsoNormal"><span><b><font face="Tahoma"><span lang="EN-US" style="font-size:10pt;font-family:Tahoma,sans-serif;font-weight:bold">Feladó</span></font></b></span><b><font face="Tahoma"><span lang="EN-US" style="font-size:10pt;font-family:Tahoma,sans-serif;font-weight:bold">:</span></font></b><font face="Tahoma"><span lang="EN-US" style="font-size:10pt;font-family:Tahoma,sans-serif"> <span>Mariusz</span> <span>Krzaczkowski</span><br>
<span><b><span style="font-weight:bold">Küldve</span></b></span><b><span style="font-weight:bold">:</span></b> 2014. <span><span>május</span></span> 16. 15:28<u></u><u></u></span></font></p></div></div><div><div>
<div><p class="MsoNormal"><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12pt"><u></u> <u></u></span></font></p></div><div><div><div><div><p class="MsoNormal"><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12pt">Why <span><b><span style="font-weight:bold">related_to</span></b></span><b><span style="font-weight:bold"> </span></b>in <span><b><span style="font-weight:bold">vtiger_modcomments</span></b></span><b><span style="font-weight:bold"> </span></b>column is of type <span><b><span style="font-weight:bold">varchar</span></b></span>? All columns of id should be of type <span><b><span style="font-weight:bold">int</span></b></span>, which is the purpose of adding <span><b><span style="font-weight:bold">varchar</span></b></span><b><span style="font-weight:bold"> </span></b>here?<u></u><u></u></span></font></p>
</div></div></div></div></div></div></div></div></div><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div></div></div>