[Vtigercrm-developers] Wrong type of column

[Prasad]

Mariusz, Peter,

Thanks for the pointer on schema. We have devised a script to determine
schema inconsistency - hoping to weed these out soon.

Noted with thanks - http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8053

Regards,
Prasad

*Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I*
Facebook<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
 *I* Blog <https://blogs.vtiger.com/>* I*
Wiki<http://wiki.vtiger.com/index.php/Main_Page>
 *I *Forums  <https://discussions.vtiger.com>*I*
Website<https://www.vtiger.com/>


On Fri, May 16, 2014 at 7:38 PM, Jung Péter <pjung at parola.hu> wrote:

>             Hi,
>
>
>
> It happened all the time in vTiger 5.*...
>
> Anno I posted a question, asking whether it is safe to change some of them
> to INT, but no one replied:
>
>
>
> However, I found that some optimizing could/should be done on the existing
> database structure.
>
> Attached is an SQL file that contains these optimizations.
>
>
>
> My question is whether these modifications would cause problems upgrading
> vTiger to v6.0?
>
>
>
>
>
> Sincerley,
>
>                                Peter Jung
>
>                                Parola Kft
>
>
>
> *Feladó**:* Mariusz Krzaczkowski
> *Küldve**:* 2014. május 16. 15:28
>
>
>
> Why *related_to* in *vtiger_modcomments* column is of type *varchar*? All
> columns of id should be of type *int*, which is the purpose of adding
> *varchar* here?
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140516/576ff77f/attachment.html>