[Vtigercrm-developers] Multiple current stamp in MySQL

[Prasad]

Sutharsan,

6.5.0 addresses issue
<http://code.vtiger.com/vtiger/vtigercrm/commit/cb5996ca37c6dabc5d9b44dba7c54ebcdefbf6b7>

Regards,
Prasad

--
FB <http://www.facebook.com/vtiger> I Twit <http://twitter.com/vtigercrm> I
LIn <https://www.linkedin.com/company/1270573?trk=tyah> I Blog
<https://blogs.vtiger.com> I Website <https://www.vtiger.com/>

On Wed, Jun 29, 2016 at 11:00 AM, Sutharsan Jeganathan <ajstharsan at gmail.com
> wrote:

> Hi
>
> I have downloaded the last 6.4 which has following statements under CREATE
> TABLE queries when, example in vtiger_users
>
>  `date_entered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
>   `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
>
>
> When a table has two Timestamp columns, you can't select two columns to
> have the special default values when right clicking the default field. This
> used to be the correct behavior v<5.6.5, but this restriction was lifted
>
> But in vtiger requirments still MySQL 5.1+ is mentioned.
>
> My Question is if I will make the udpate field 'date_modified' default to
> 0000-00-00 00:00:00, will it affect the update process?
>
>
> Thanks
> Sutharsan Jeganathan
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160629/a810c047/attachment.html>