[Vtigercrm-developers] Multiple current stamp in MySQL

[Sutharsan Jeganathan]

Hi

Thanks
Sutharsan Jeganathan

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=oa-2322-b>
Virus-free
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=oa-2322-b>
<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Wed, Jun 29, 2016 at 11:55 AM, Prasad <prasad at vtiger.com> wrote:

> 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/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160629/3e4084b8/attachment.html>