[Vtigercrm-developers] database booleans

[Prasad]

Adam,

We plan to take up data-type consistency while we pickup schema
architecture improvement.
As this inconsistency has crept in while the product was too early...
fixing them would take sometime.

Please update (http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7429) when
you come across others.

Thanks for your efforts!!

Regards,
Prasad


On Thu, May 31, 2012 at 10:07 PM, Adam Heinz <amh at metricwise.net> wrote:

> Whoops.  I just wasted a few minutes because I forgot that for
> vtiger_products.discontinued, 0 means true and 1 means false, but for
> vtiger_crmentity.deleted, 1 means true and 0 means false.  Has any
> thought been given to consistently representing booleans in the
> database?  Per mysql documentation
>
> http://dev.mysql.com/doc/refman/5.1/en/numeric-type-overview.html
>  BOOL, BOOLEAN
>  These types are synonyms for TINYINT(1). A value of zero is
> considered false. Nonzero values are considered true:
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20120601/7b01c273/attachment.html